Spreadsheet Design
Budget: $250 – $750 AUD
1. Import reports into spreadsheet (multiple sheets)
2. Check the number in the reports are added or subtracted correctly
3. Check the number in one report reconcile with other
4. Embed the Calculators (formula will be provided) into the spreadsheet and match the output to the report.
5. The cells with negative answer to coloured red automatically.
6. if any of the questions in a sheet is red then the sheet name must be coloured red as well .
7. The questions marked red from all the sheets to be collated in one separate sheet( summary of all the issues)
8. All the questions relevant to one heading to hide or unhide in one click.
9.) we have basic template
2. Check the number in the reports are added or subtracted correctly
3. Check the number in one report reconcile with other
4. Embed the Calculators (formula will be provided) into the spreadsheet and match the output to the report.
5. The cells with negative answer to coloured red automatically.
6. if any of the questions in a sheet is red then the sheet name must be coloured red as well .
7. The questions marked red from all the sheets to be collated in one separate sheet( summary of all the issues)
8. All the questions relevant to one heading to hide or unhide in one click.
9.) we have basic template