
Fechado
Publicado
Pago na entrega
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.
ID do Projeto: 40292780
28 propostas
Projeto remoto
Ativo há 25 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
28 freelancers estão ofertando em média $26 USD for esse trabalho

As an experienced Full Stack Developer who has spent the last 7 years in the industry, I have gained a wealth of knowledge and skills that make me perfect for this project. I have an extensive background in Excel, which includes not only basic functions but also more advanced areas such as Macros and VBA. I am well-versed in data management and analysis, guaranteeing your workbook will be clean, well-structured, and highly-functional. Over the years, I have worked with companies such as Metlife GOSC, DXC technologies, and Elite Services where precision and scalability were paramount. Given the multiple organizations and large volumes of data you need to manage and present accurately, my experience will ensure that your data presentation is spot-on and consistently updated to meet your monthly storage fee requirements. Moreover, my essence lies in making my clients 100% satisfied with my work. I prioritize long-term relationships so I assure you that you will not only get an efficient solution for this project but also have the necessary support going forward. My commitment is to deliver quality work within the shortest timeframe possible while maintaining accuracy and meeting all project specifications. Choose me for your Monthly Storage Fee Excel Tool project and let's build something incredible together!
$80 USD em 2 dias
8,6
8,6

As an experienced data analyst, I bring a wealth of knowledge to the table when it comes to crafting efficient Excel solutions and maximizing its functions for data manipulation. When building your Monthly Storage Fee Excel Tool, my expertise in areas such as data processing, visualization and Excel macros will ensure that your workbook is not only well-structured but also performs promptly and accurately even as your inputs scale across various organizations. My skill set in Excel VBA, Macros and Pivot Tables perfectly aligns with your requirements, meaning I can deliver exactly what you need. To further illustrate my suitability for this project, one of my key skills is making the complex simple through clear documentation. For every formula, pivot-table layout and numerical calculation employed in building this workbook, I'll provide a concise yet thorough text document that explains step-by-step how each aspect was created. This will empower you to maintain or expand upon the created spreadsheet easily even without my presence. In conclusion, engaging my services would guarantee an efficient and scalable Monthly Storage Fee Excel Tool. My proficiency in handling data entry, analysis and mining would combine perfectly with your detailed brief while my skills in creating functional PDF documents could be potentially useful for your business needs in the future. Allow me to bring simplicity yet sophistication to your monthly storage fee calculations; You won't
$29 USD em 1 dia
7,6
7,6

I would be absolutely thrilled to take this Monthly Storage Fee Excel Tool project off your hands. With years of experience in Data Analytics, Financial Planning & Analysis, I am impeccably equipped to handle this task. My expertise in creating dynamic and automated Excel workbooks has consistently impressed my clients and I am confident it will do the same for you. In organizing your monthly cubic-foot data across multiple organizations, I'll create a clean and scalable workbook that will meet your every need. Not only will it calculate charges by line item and organization on a monthly basis, but also generate directorate-level summaries with all the necessary roll ups. The pivot tables I'll apply would allow you to access charges for any organization's individual line items, as well as overall totals for each directorate, both monthly and annually. Further setting me apart from other freelancers is my commitment to knowledge transfer. Upon completion of the project, I will not only deliver the finished excel workbook but will provide a concise text document that walks you through step by step on how everything was built. Even after the contract ends, rest assured, I would happily offer my continued support if required. My goal is العزاء all your worries
$20 USD em 1 dia
7,6
7,6

Hello, I am an experienced Excel specialist who has built dozens of scalable, formula-driven workbooks for clients managing multi-level cost calculations, and I will create a clean, well-structured file that automatically calculates your storage fees at $0.60 per cubic foot across 10+ organizations. I'll design a simple data sheet where you can paste monthly figures, with formulas that multiply each entry by 0.60 and roll up charges by line item, organization, and directorate level. Using standard pivot tables, you'll be able to view month-by-month charges for every organization and line item, plus annual summaries showing total fees per directorate and yearly cubic-foot costs per line item. I'll also provide a concise step-by-step guide explaining the data layout, formula logic, and pivot table setup so you can maintain or extend the workbook yourself. Just share a sample of your data format and I'll build it right away. Regards, Zafar
$30 USD em 1 dia
6,2
6,2

Hi there, I understand you need a dynamic Monthly Storage Fee Excel Tool that automates fee calculations while being accurate, user-friendly, and easy to update monthly. With strong Excel modeling experience including structured tables, advanced formulas, and automated calculations, I can build a solution that streamlines your storage fee process and ensures reliable outputs. My approach will begin by organizing your data logically, including storage usage, fee tiers, dates, and rate variables. I will implement data validation to prevent errors and ensure consistent input across all sheets. Next, I will create automated calculations that determine monthly storage fees based on your business rules, using dynamic formulas and lookup functions to update instantly when new data is entered. I can also incorporate tiered pricing, prorated days, or minimum fees if needed. Finally, I will provide a clear summary of totals, with optional visual cues or conditional formatting to flag anomalies, and ensure the tool is easy to use and maintain. Deliverable: Fully functional Excel tool with automated calculations, structured data entry, and clear monthly fee outputs ready for operational use. QUESTION: Could you please share a sample of your current data and the specific rules for calculating storage fees? Let's chat and get started now! Regards, Shehwani.
$50 USD em 1 dia
4,3
4,3

Your storage fee workbook is a straightforward data-modeling problem I've built many times: a clean input sheet for monthly cubic-foot figures across 10+ organizations, SUMPRODUCT and SUMIFS formulas to apply the $0.60/cu-ft rate and roll charges up by line item, organization, and directorate, and well-structured pivot tables for both monthly breakdowns and annual summaries. I'll design the data sheet with a flat, normalized layout so it scales effortlessly as you add organizations or line items—no macros needed, just robust native Excel formulas and pivots. You'll also receive a clear step-by-step reference document covering the data architecture, formula logic, and pivot configuration so you can maintain and extend everything independently. I'm available to start immediately and happy to work from a sample of your data to ensure the structure fits perfectly.
$10 USD em 1 dia
2,4
2,4

Hi! I can build a clean, scalable Excel workbook (no macros) where you paste monthly cubic feet by line item and it automatically calculates storage fees at $0.60/ft³, with directorate rollups, monthly pivots, and annual summaries. I’ll set up a structured Data table + calculated charge fields, then create PivotTables for month-by-month views per organization/line item and grand totals per directorate. You’ll receive the finished workbook plus a short step‑by‑step guide explaining the layout, formulas, and pivot configuration so you can maintain or extend it easily. If you share a quick sample of your columns (Organization/Directorate/Line Item/Month/Cubic Feet), I’ll match your exact format and deliver fast.
$12 USD em 1 dia
2,5
2,5

Clear requirements — I can build this exactly as described. One data sheet where you paste your cubic-foot figures, formulas that auto-calculate the $0.60 charge per line item and roll up by organization and directorate, plus pivot tables for monthly and annual views. No macros, fully maintainable. I'll also deliver the step-by-step documentation so you can update it yourself without needing to come back. Share a sample of your data format and I'll send you a pre-built template with the structure already in place — free — so you can confirm it fits before we finalize anything
$20 USD em 1 dia
1,6
1,6

Hi there, I understand you want a clean, scalable Excel workbook that automatically calculates storage fees at 0.60 per cubic foot, with robust organization-by-month rollups and pivot-driven insights, without macros. I’ll deliver a tidy data sheet for monthly cubic-foot figures, built-in calculations, and multi-level pivots to show line-item, organization, and directorate totals, plus an annual-summary view. My Plan: - Structure a data sheet designed for easy paste/import of cubic feet per line item across 10+ organizations, with clear headers and data validation. - Implement formulas to compute charges (cubic feet × 0.60) and create month-level and organization-level rollups, feeding consistent totals for directorates. - Create pivot tables to display monthly charges by organization and line item, plus directorate grand totals, with an annual summary alongside. - Provide a final deliverable workbook with clean formatting, plus a concise text document detailing data layout, formula logic, and pivot configuration for future maintenance. In a closely related project, I built a scalable fee-tracking workbook for a logistics provider that processed 15 organizations, supporting multi-month rollups and pivot-driven dashboards in a single workbook, with zero macros and no performance pauses. Best regards, Thando
$20 USD em 1 dia
0,0
0,0

As a skilled full-stack AI engineer with a specialization in data visualization, I am perfectly suited for your Monthly Storage Fee Excel Tool project. By choosing me for this project, you're selecting a professional who never loses sight of an application's goal; minimizing manual work and maximizing efficiency. I'm excited by the potential to automate your workflow, enabling rapid and accurate fee calculations while offering comprehensive pivot tables to analyze costs at various levels. Let me put my skills and experience to work for you!
$20 USD em 1 dia
0,0
0,0

I see you need a clean, scalable Excel workbook that calculates monthly storage fees at $0.60 per cubic foot across multiple organizations, with detailed rollups and pivot tables. You want a solution without macros, relying on formulas and pivot tables to keep it simple and maintainable. Your project requires a data sheet for importing cubic-foot figures, formulas to calculate charges per line item and organization, plus pivot tables that provide monthly and annual summaries by directorate and line item. You also want a clear, concise guide explaining how everything is structured and works for future updates. I have created similar Excel tools that handle multi-organization data with complex rollups and dynamic pivot tables, ensuring accuracy and ease of use without VBA. I’ll build your workbook with clean formulas and pivot tables that update seamlessly as you add data, and provide a straightforward walkthrough document as you requested. I can deliver the finished workbook and guide within two days. Let’s discuss any specific data format you have so I can tailor the structure precisely to your needs.
$11 USD em 7 dias
0,0
0,0

⭐Timeline: 4 days | Cost: $70 | Proven experience⭐ I've successfully completed projects like this before, creating scalable Excel workbooks with automated calculations and Pivot Tables for multiple organizations. From my experience, the key challenge is ensuring formulas correctly calculate storage fees per line item, roll up monthly totals by organization and directorate, and provide clear pivot summaries for both monthly and annual views. I will build a clean, well-structured workbook with all formulas and Pivot Tables in place and provide a concise guide explaining the setup so you can maintain or extend it easily. This project is straightforward for me, and I’m confident I can deliver a fully functional, user-friendly Excel workbook. I’m ready to collaborate and get started immediately: let’s make this a reality.
$70 USD em 4 dias
0,0
0,0

Good day I trust you are well. You need a scalable Excel workbook that accurately calculates storage fees at $0.60 per cubic foot, organized by line item, organization, and directorate with monthly and annual summaries. I’ll set up a clean data sheet for your raw cubic-foot inputs, implement formulas to compute charges per entry, and use Pivot Tables to organize monthly and yearly totals as specified. This approach ensures easy updates and clear visibility across over 10 organizations. The step-by-step guide will empower you to maintain and extend the workbook effortlessly. Tell me more about your project so I can help make it a success. Regards, Marissa
$12 USD em 14 dias
0,0
0,0

Hi there, I’ve reviewed your Temp Storage Master data structure. I can build a "bulletproof" version of this workbook that automates your $0.60/cu ft calculations while maintaining the relationship between your Directorates, Organizations, and individual line items. My plan for your workbook: Standardized Data Mapping: I will clean and structure the data from your "Temp Storage Master" into a dynamic Excel Table. This ensures that as you add rows for different Organizations (e.g., Clinical, Public Health), the fee calculations "roll down" automatically. Hierarchical Roll-ups: I’ll implement the $0.60 calculation at the line-item level, with logic that rolls these charges up into your specified Directorate-level totals. Customized Pivot Architecture: * Monthly View: I’ll set up a Pivot Table that breaks down charges by Month, Organization, and Line Item, including the requested Grand Total rows for each Directorate. Annual Summary: A dedicated view showing the yearly cubic-foot cost and fee breakdown, providing a high-level executive overview of the year’s spend. Documentation & Handover: I’ll provide a step-by-step guide explaining how the Pivot Tables pull from the Master sheet, so you can easily import future months without breaking the logic. I focus on "clean" Excel—no macros, just efficient formulas and Pivot Tables that keep the file fast and scalable. Regards, Naveen Kumar
$25 USD em 7 dias
0,0
0,0

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
$20 USD em 7 dias
0,0
0,0

Houston, United States
Membro desde mar. 11, 2026
$10-30 USD
₹12500-37500 INR
$250-750 USD
mín. $100000 USD
₹600-1500 INR
$250-750 USD
€10-25 EUR
$250-750 USD
₹1500-12500 INR
$250-750 USD
₹75000-150000 INR
$10-30 USD
₹600-1500 INR
₹750-1250 INR / hora
₹600-1500 INR
$15-25 USD / hora
$30-250 USD
$30-250 USD
₹1500-12500 INR
₹600-1500 INR