valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 350
Questions & Answers
Q: I only need FOUR product groups and customer segments. Entering zero into the fifth column results in a DIV/0 error message and produces wrong charts and tables. I'm attaching my work file for your review. Can the calcs be modified to only have FOUR groups instead of FIVE please?
A: The fifth/last column values are calculated by the software. To use less than 5 Segments in the Revenue Percent/Monetary input cell for the first Segment input a significantly low number ie 0.00001, the same can be done for the Transaction Num Sales/Price input. This basically negates the significance of that Segment and eliminates the DIV/0 issue. I have also attached to this email the unprotected and pre-registered version of your Commercial license software. Simply save it to your computer. The software includes an additional sheet named Worksheet with the underlying formula and calculations. Any changes to formula may impact on the validity of the software. It is recommended that you save a copy of this as a master to ensure that you always have a valid software version. Please note that Bizpep retain full copyright and intellectual property rights at all times.
Question and Answer Item 350 - Browse All Question and Answer Items