Questions & Answers
Q: Great thank you. So the dynamic one will update itself, or I need to run it manually each time?
A: If you upload the Dynamic Sitemap code to your site everytime that url is called it will automatically regenerate and return an updated sitemap.
Q: Hi, I am trying to get the trial version of SiteMap XML Software to work before purchasing. I followed the instructions it seems to function but doesn't crawl any pages (just shows the initial URL in the sitemap). I don't see that answered in the FAQ's, could you suggest how to troubleshoot that?
A: You need to set your Include Url's with value to match your site structure. I added a / to Include Url's with and css to Exclude Url's with (to exclude all your css files being listed) clicked Generate Static Sitemap and returned a sitemap with 133 unique links as per screenshots below. See the Include URLs with section of the help file https://bizpep.com/sitemapxml/ for details. You may need to adjust these values further to suit your specific requirements. Let me know how you go.
Q: Is there a place to enter the fixed assets my client is also selling with his business? The way I understand your software, is that it only values the earnings of the business, not the assets you are selling? Is that correct?
A: Asset inputs are classed as Business Assets with their associate life span which are depreciated, property assets at market value, and other. These inputs are on the Input sheet under Valuation Data. The Valuation Data section of Help includes details https://bizpep.com/businessvaluation.html . The input used depends on what the asset is. If the fixed assets are part of the business and not property they should be included as Business Assets. If not related to the business ie the business is fully functional without it could be treated as completely separate and its market value simply added to the business valuation. If it is included as a component of the valuation it will impact the business valuation based on the required rate of return. Replacement Value of Business Assets Input the replacement value of physical business assets. Exclude property. Consider vehicles, plant and equipment. This forms a component of the total business investment. Life of Assets (years) Input the average life of the assets. The Replacement Value of Business Assets will be divided by the Life of Assets to provide an indication of annual asset depreciation expense. This will be used in determining the owners return from the business. Market Value of Property Input the estimated market value of property owned by the business. Property values are considered stable over the forecast period and no depreciation is allowed for. This forms a component of the total business investment. Other Investment in Business This is the calculated value of any other investment made in the business. It consists of operating capital and goodwill. This forms a component of the total business investment. This amount will be adjusted in-line with your Valuation Analysis.
Q: I'm keen to include the wages component to my spreadsheet but am unsure how this will affect the setup I already have. The info box says it will delete certain components and add others. I'm not sure which ones and whether they will affect me?
A: Before any change please back up all data (transactions and setup), this will allow you to restore if required. You can see the Preset Accounts detail at http://bas-i.com.au/accountsgst.html . If you change the preset account or set up (ie Include Wages) then any existing pre set Accounts will be removed and the new pre set accounts added. Any transactions that are set with an account that has been removed will become orphaned and unable to be reconciled in the BAS View. The transactions will still remain but in List View they will be shaded red. Accounts that you have individually added will remain valid. If you Include Wages existing preset accounts will be replaced with the Include Wage setup and if needed you can then re load the required preset accounts (ie click Generic etc..). In list view check that you have no orphaned accounts (shaded red) and you should be all good. Please back up before making any changes and ensure you backup regularly. All data is saved locally on your system (no where else). Hope that makes sense. Additional detail on accounts is available at http://bas-i.com.au/chartofaccounts.html . If you have a different computer or browser you can use your account link to access BAS-I.C and play around with account settings without impacting your current setup.
Q: Hi there, I just got a new computer and IT moved my files over, and not my shift scheduler is not working. Are you able to let me know how to set it correctly so I am able to click the buttons on it again?
A: I just checked and your file runs on my system, most likely your macros are not enabled ... how you enable macros depends on your system. The following info may help? Enable Macros using Excel 2010/2007 to open a .xlsm file - When you open the .xlsm Excel file with Excel 2010/2007 macro status and options will depend on your system and security settings. The .xlsm extension indicates the file is an Excel Macro-enabled Workbook. If macros are not enabled from the top ribbon click Developer, Macro Security to access the Trust Center. If the Developer tab is not displayed, click the Microsoft Office Button, Excel Options, Trust Center, and the Trust Center Settings Button. From the Trust Center click Trusted Locations, Add new location, browse to the directory in which the Excel software file is saved, select the sub folders option if required, click OK, and then click OK once more to exit the Trust Center. This enables macros for any files saved in a Trusted Location. Only files that you trust should be saved in Trusted Locations, if you save all your Bizpep Excel files to a trusted directory macros will be enabled and they will run correctly. For additional information see Microsoft's Create, remove, or change a trusted location for your files. Alternatively from the Macro Settings category in the Trust Center you can select 'Enable all macros' however this enables macros in files from any location and should only be used when all files you access are trusted. Enable Macros using Excel 93-2003 to open a .xls file - If when you open the Excel software you are not presented with an option to enable macros you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.