I need to configure a set of 23-25 Excel spreadsheets that I will use for uploading forecast spreads into a PeopleSoft Budgeting & Forecasting model. Please note that I already have a similar set of spreadsheets, from a colleague, that we can use as a sample to benchmark and replicate the project.
The project, basically, consists in linking 23-25 sets of: (1) source queries that contain base data with (2) a spreadsheets that are the working slates. I need someone who: (1) is very good at Excel, (2) understands the basics of hospitality forecasting, (3) understands what kind of volumes/statistics drive particular forecast values.
I will send you: (1) the set of benchmark sheets that I have ready, and (2) the set of source queries that will derive the data. The final deliverable will be: (1) the final set of 23-25 Excel spreadsheets that are linked to the base queries, and for which the driver accounts are working correctly and generating the right forecast values.