Excel formula and Macro Expert
Budget: $10 – $50 USD
Hi
The Stylist Bonuses, 2019 WORKING v2.2 file is the preferred format. Raw data is cut/pasted from a CVS export to the SalonData tab. Formulas find key data points and paste them into different tabs for
analytics. The tabs in Red are helper tabs. Tabs in green are data entry or end result tabs.
Some formulas link to the other file attached - the HELP file. This is an error. My XLSs do not integrate across workbooks.
The Stylist Bonuses, 2019 WORKING v2 - Help File 2 file was made for help on a forum. The formatting is changed to accommodate free expert assistance. Following debugging, I'll need to test the XLS to insure it can pull the data accurately.
Comments:
The SalonData tab is a data dump. Attached is the system data. It's broken into 2 files d/t export size. This needs to be cut/pasted in to A1. The 2nd one is right below it. Should be around 3,000 total lines. Since we're scaling this to 90 locations, the data dump could grow to 12,000 lines.
Please check the attached files and let me know
The Stylist Bonuses, 2019 WORKING v2.2 file is the preferred format. Raw data is cut/pasted from a CVS export to the SalonData tab. Formulas find key data points and paste them into different tabs for
analytics. The tabs in Red are helper tabs. Tabs in green are data entry or end result tabs.
Some formulas link to the other file attached - the HELP file. This is an error. My XLSs do not integrate across workbooks.
The Stylist Bonuses, 2019 WORKING v2 - Help File 2 file was made for help on a forum. The formatting is changed to accommodate free expert assistance. Following debugging, I'll need to test the XLS to insure it can pull the data accurately.
Comments:
The SalonData tab is a data dump. Attached is the system data. It's broken into 2 files d/t export size. This needs to be cut/pasted in to A1. The 2nd one is right below it. Should be around 3,000 total lines. Since we're scaling this to 90 locations, the data dump could grow to 12,000 lines.
Please check the attached files and let me know