That's a good suggestion, I will try to add that functionality over this weekend if I find time.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2013-07-02
The transaction functions and data functions sheets appear to handle re-use differently. In Data Functions, the Reuse FPs = total FPs * % re-use (which is what I would expect). In transaction functions the Reuse FPs = Total FPs - (Total FPS * % re-use). If you have a use case which is a mix of transaction and data Functions and the sheet adds it together, the results are therefore wrong.
I think this is a bug and it makes summing up all the FPs very difficult and innacurate
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It was a bug, the transaction sheet had not copied the same formula across all cells in Reuse FP count, this has been fixed in version 1.3 onwards...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2013-07-02
The templates could do with better examples and documentation... it took me a long time to work out what the extensions mean. The:
DET-Impact FTR-Impact PET-Impact LCS-Impact Reuse(Y/N) %
section of Changed transaction functions - haven't worked this out yet, plus most of the cells are locked anyway, which would appear to be a bug.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The Impact column was introduced to justify the changed FP counts, sometimes if the changes include removed/added scenarios like you have 50 DETs and 25 were removed and 25 were added or updated, this will lead to same DET count on pre-count and post-count so the impact field will specify the actual numbers before you put in the Reuse percentage. I found the bug which locked the last two columns, this has been fixed since version 1.4 onwards...
Last edit: Ruben Gerad Mathew 2013-07-04
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2013-07-02
Once I had entered a certain number of Use cases on the transaction sheet, the formula stopped working. Because everything is locked, I cannot debug and fix it therefore I have had to split over 2 sheets and spend a lot of time adding things together manually.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There was a bug in rows starting from 56-68, the forumla was not copied evenly across the sheet, this has been fixed in release 1.3 onwards, Thank you for pointing it out.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2013-07-02
I would like to be able to cut and paste the totals columns into a new sheet. because of the bugs in the calculations, I want to cut and paste into my own sheet and add up there. because it is password protected I cannot unprotect and do this so I am now typing hundreds of rows of data into my own sheet.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You have a point there, I've fixed the problems overnight, however, I will add a reporting feature to version 2.0 to help you extract all data if required...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you face any problems working with any of the sheets please contact me immediately by mail(ruben_gerad@rediffmail.com) and I can respond to you, also help you with workaround for free, and correct any bugs that may be stopping you immediately. This will eventually help me in improving the product. Download only the latest sheet as I keep updating minor versions for bug fixes, and major versions for releases with new features. When reporting a problem, kindly mention the release, otherwise I cannot track down the problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Kindly let me know if there could be anything done to improve your user experience and daily use of the worksheet.
Hello,
Is it possible to offer the possibility to change currency, hour per day, and other stuves that is different between countries ?
Thanks
Feature request has been earmarked for Rel 2.0.
That's a good suggestion, I will try to add that functionality over this weekend if I find time.
The transaction functions and data functions sheets appear to handle re-use differently. In Data Functions, the Reuse FPs = total FPs * % re-use (which is what I would expect). In transaction functions the Reuse FPs = Total FPs - (Total FPS * % re-use). If you have a use case which is a mix of transaction and data Functions and the sheet adds it together, the results are therefore wrong.
I think this is a bug and it makes summing up all the FPs very difficult and innacurate
It was a bug, the transaction sheet had not copied the same formula across all cells in Reuse FP count, this has been fixed in version 1.3 onwards...
The templates could do with better examples and documentation... it took me a long time to work out what the extensions mean. The:
DET-Impact FTR-Impact PET-Impact LCS-Impact Reuse(Y/N) %
section of Changed transaction functions - haven't worked this out yet, plus most of the cells are locked anyway, which would appear to be a bug.
The Impact column was introduced to justify the changed FP counts, sometimes if the changes include removed/added scenarios like you have 50 DETs and 25 were removed and 25 were added or updated, this will lead to same DET count on pre-count and post-count so the impact field will specify the actual numbers before you put in the Reuse percentage. I found the bug which locked the last two columns, this has been fixed since version 1.4 onwards...
Last edit: Ruben Gerad Mathew 2013-07-04
Once I had entered a certain number of Use cases on the transaction sheet, the formula stopped working. Because everything is locked, I cannot debug and fix it therefore I have had to split over 2 sheets and spend a lot of time adding things together manually.
There was a bug in rows starting from 56-68, the forumla was not copied evenly across the sheet, this has been fixed in release 1.3 onwards, Thank you for pointing it out.
I would like to be able to cut and paste the totals columns into a new sheet. because of the bugs in the calculations, I want to cut and paste into my own sheet and add up there. because it is password protected I cannot unprotect and do this so I am now typing hundreds of rows of data into my own sheet.
You have a point there, I've fixed the problems overnight, however, I will add a reporting feature to version 2.0 to help you extract all data if required...
If you face any problems working with any of the sheets please contact me immediately by mail(ruben_gerad@rediffmail.com) and I can respond to you, also help you with workaround for free, and correct any bugs that may be stopping you immediately. This will eventually help me in improving the product. Download only the latest sheet as I keep updating minor versions for bug fixes, and major versions for releases with new features. When reporting a problem, kindly mention the release, otherwise I cannot track down the problem.