Browse All Question and Answer Items
Items selected where Topic is Product and Supplier Profitability Excel
Topic: Product and Supplier Profitability Excel
Q: I have put in formula from my own in the input cells, which by the way didn't save. Are you saying in the input cells I can only put in numbers no formulas?
A: You can use formula in the form inputs but the calculated values must result in numbers ie all input values must equate to numbers. When you Save Profile only the value will be saved not the formula. As a non design work around if you want set formulas then you could input them into the Form but and they will be saved when you save the file but if you Retrieve a profile they will be overwritten so to have different profiles you would need to save each file as a different name.
This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.
Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items
Topic: Product and Supplier Profitability Excel
Q: I have been using the spread sheet and its useful to say the least. However, I couldn't help but notice few problems with it. for e.g. if I do change values in the spread sheet and resave it then most likely the numbers in the over all totalling sheets will not change and you will have to delet the sheet then make a new one inorder to have the correct data showing.
A: Values should be changed on the Form sheet only and when you Save Profile the updated values are transferred to the Table sheet and totals updated. The Table sheet does not include all formula only values updated from the Form when you save a profile. As outlined in the Help all value changes should be done on the Form sheet. When the profile is saved the table sheet is then updated.
This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.
Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items
Topic: Product and Supplier Profitability Excel
Q: I have been using the spread sheet and its useful to say the least. However, I couldn't help but notice few problems with it. for e.g. if I do change values in the spread sheet and resave it then most likely the numbers in the over all totalling sheets will not change and you will have to delet the sheet then make a new one inorder to have the correct data showing.
A: Values should be changed on the Form sheet only and when you Save Profile the updated values are transferred to the Table sheet and totals updated. The Table sheet does not include all formula only values updated from the Form when you save a profile. As outlined in the Help all value changes should be done on the Form sheet. When the profile is saved the table sheet is then updated.
This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.
Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items
Topic: Product and Supplier Profitability Excel
Q: I would like to purchase the Product & Supplier Profitability template. Once I have purchased same, will you provide me with the password to the workbook and sheet protect?
A: You will need to purchase a Commercial or Source License to receive unprotected software. With a standard Non-Commercial License all non-input cells and Visual Basic code are protected to ensure integrity and protect source code. All input is via unprotected input cells, protected cells contain formula and should not be changed. The software is fully functional and the protection is in place to ensure the software formula and code is not corrupted. We also offer Commercial licenses and upon request with a Commercial license can provide an unprotected software version allowing you to view the formula applied, access cell contents to enhance your knowledge of software operation (macros remain protected) and undertake minor refinements (ie headings etc). Commercial licensing fees are 3 times Non-Commercial licensing fees. To access the source code of our software including the visual basic code (macros) a Source License is required. This license allows you to modify and adapt all components of the software to meet your specific needs. Source licensing fees are 3 times Commercial licensing fees. Source Code License details are available at www.bizpeponline.com . Please note that Bizpep retain full copyright and intellectual property rights at all times. I can provide additional detail as required.
This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.
Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items
