Monthly Storage Fee Excel Tool
Budget: $10 – $30 USD
I need a clean, well-structured Excel workbook that will automatically calculate our storage fees at $0.60 per cubic foot. I’ll supply the raw numbers as cubic feet per line item, spanning more than 10 different organizations, so the file must scale gracefully.
Workbook requirements
• A data sheet where I can paste or import the monthly cubic-foot figures per line item.
• Formulas that multiply each entry by 0.60 to generate the charge, then roll those charges up:
- by line item and organization for each month,
- into directorate-level totals for the same period.
• Pivot tables that let me view charges month-by-month for every organization and its individual line items, plus a grand-total row for each directorate.
• An additional pivot (or summary sheet) that shows annual totals: both the overall fee per directorate and a breakdown of the yearly cubic-foot cost for every line item.
Deliverables
1. The finished Excel workbook with all formulas and pivot tables in place.
2. A concise text document that walks me through, step by step, how you built the spreadsheet—covering data layout, formula logic, and pivot-table setup—so I can maintain or extend it later.
No Macros are required; standard Excel functions and Pivot Tables are fine. If you have any questions about the structure or need a sample of my data format, let me know and I’ll provide it right away.
Workbook requirements
• A data sheet where I can paste or import the monthly cubic-foot figures per line item.
• Formulas that multiply each entry by 0.60 to generate the charge, then roll those charges up:
- by line item and organization for each month,
- into directorate-level totals for the same period.
• Pivot tables that let me view charges month-by-month for every organization and its individual line items, plus a grand-total row for each directorate.
• An additional pivot (or summary sheet) that shows annual totals: both the overall fee per directorate and a breakdown of the yearly cubic-foot cost for every line item.
Deliverables
1. The finished Excel workbook with all formulas and pivot tables in place.
2. A concise text document that walks me through, step by step, how you built the spreadsheet—covering data layout, formula logic, and pivot-table setup—so I can maintain or extend it later.
No Macros are required; standard Excel functions and Pivot Tables are fine. If you have any questions about the structure or need a sample of my data format, let me know and I’ll provide it right away.
Related categories:
Visual Basic
Data Processing
Excel
Excel VBA
Excel Macros
Data Visualization
Data Analysis