Build an excel document with macros and formulas for business forecasting.
Budget: $250 – $750 AUD
We are building a forecasting tool to help us forecast our temporary contractors. We want to input data into the spread sheet I have attached with names of contractors, margin, start date, finish date. The spread sheet should be able to populate the monthly fields in accordance to working days for the year in Australia.
If needed you can find the working day data here: https://australia.workingdays.org/data_excel.php#
For example a Sam (Contractor) starts on 1/1/22 and finishes on 15/6/22, with a daily margin off $100 it would auto populate the months from Jan to June and finish on the 15th in accordance to the working days from the data above
Jan would read, 1900, feb 2000, march 2300, April 1800, may 2200, June $1000 ( as finishing on the 15th)
All the greens a totals from columns and rows.
Then could we populate for 2023, 2024 etc.
after we complete this we can look at changing it to reflect different states and global areas.
If needed you can find the working day data here: https://australia.workingdays.org/data_excel.php#
For example a Sam (Contractor) starts on 1/1/22 and finishes on 15/6/22, with a daily margin off $100 it would auto populate the months from Jan to June and finish on the 15th in accordance to the working days from the data above
Jan would read, 1900, feb 2000, march 2300, April 1800, may 2200, June $1000 ( as finishing on the 15th)
All the greens a totals from columns and rows.
Then could we populate for 2023, 2024 etc.
after we complete this we can look at changing it to reflect different states and global areas.