Questions & Answers

Q: As an uninformed Excel person I have found your software helpful and informative. However, the quarterly 'total received' on the Income file is causing me much grief. The drop down menu does not drop down. The lines of arrows help but do not give me a solution. I have read the Help page and the Q and A pages but am out of ideas now. Is it something to do with the formula? I would be most grateful for your suggestions as I think this system will be very suitable for my small business.

A: The totals for Quarter as automatically summed from the values input in each month for the quarter. Inputs are only in the blue cells. The Quarter totals are all calculated by formula and should not be changed (there is no drop down for totals). If you continue to have difficulty send me a copy of your file as an email attachment and let me know exactly what the problem is and I can have a look for you.

Question and Answer Item 2058296 - Browse All Question and Answer Items

Q: I have a question with regard to inputs for break even analysis. How do variables like economic, political risks and other non-quantifiable variables affect break even calculations ? Are there taken into consideration ?

A: Not directly in standard break even analysis. Break even analysis is at a point in time, so if you are looking at current data ie revenue/expenses it already includes all internal and external environmental impacts. However if you build a business forecast using relative indicators ( https://bizpep.com/Input-Help.html#Relative-Indicators ) as applied in our forecast methodology areas such as Market Strength, Business Market Position, Level of Competition, etc are applied in developing the forecast and these do consider the future impact of these variables and apply them in a quatifiable manner. You can then calculate break even points for future years using the forecast values. This would allow future subjective variables to be considered in break even calculations, see https://bizpep.com/Breakeven-Help.html .

Question and Answer Item 2058295 - Browse All Question and Answer Items

Q: Downloaded the excel verison of Queuing Model for evaluation. I cannot open the file as it requires a password. Is there a way I can eval the product or do I need to puchase?

A: You should be able to open and extract the excel file from the download file. Then open the Excel file. In the Excel file input cells (blue) are not protected and are the only cells that should be changed for the software to function correctly. 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. Please refer to the instructions sheet for details. If you continue to have difficulty please let me know exactly what you are doing and I can assist further.

Question and Answer Item 2058294 - Browse All Question and Answer Items

Q: Hi I need to get a version of this software that will run on my mac 2008 excel. I have used one of my versions on a PC but use a mac from home.

A: Try saving the registered version from your pc (via a usb etc) to your mac. This will give you a pre registered version on your mac. If your mac is capable of running the software it should now do so. If you do not have full functionality it is most likely that your mac / spreadsheet does not include all the required functions for the software to run.

Question and Answer Item 2058293 - Browse All Question and Answer Items

Q: I saved my 2011 monthly qbks profit and loss data in a file named PL.csv as instructed. Clicked Update PL. The 2011 qbks data appeared with 2012 monthly headings in the Month Actual column (i.e., January-12, February-12, and so on).

A: The Compiler is designed to build a 12 month budget. When you Update PL with exported PL data the dates of this data are set in the compiler. Then when you go New Budget and Apply the dates are set for the next year ie the 2011 data is exported from QuickBooks and the compiler uses this as a base for the 2012 budget. If your 2011 data has 2012 dates check your PL.csv file. If the data was exported correctly it should have 2011 dates. The budget dates are set as the year following the imported date.

Question and Answer Item 2058288 - Browse All Question and Answer Items

<< < Page 41 42 43 44 45 46 47 48 49 50 > >>