Excel Acquisition Record Template
Budget: ₹750 – ₹1,250 INR
I need a clean, ready-to-use Excel spreadsheet that will serve as our master “Acquisition Record.” The sheet must include these columns in this exact order: Date, Department, Applicant, Item, Quantity, Purpose, Approval.
Core requirements
• Format: Excel (.xlsx) only.
• Formulas: automatic sums and running totals so I can see, at a glance, how many items have been requested overall and per department.
• Data validation:
– Drop-down lists for Department and Approval status.
– Number ranges that allow only positive whole numbers for Quantity.
– Date ranges that restrict entries to the current fiscal year.
I’d also like a small “Briefing” or “Instructions” tab explaining how to add new departments or tweak the validation rules, so anyone on the team can maintain the file without extra help.
Deliverable: one polished .xlsx file that meets the above points and is free of errors on open—no broken references or stray formatting.
Core requirements
• Format: Excel (.xlsx) only.
• Formulas: automatic sums and running totals so I can see, at a glance, how many items have been requested overall and per department.
• Data validation:
– Drop-down lists for Department and Approval status.
– Number ranges that allow only positive whole numbers for Quantity.
– Date ranges that restrict entries to the current fiscal year.
I’d also like a small “Briefing” or “Instructions” tab explaining how to add new departments or tweak the validation rules, so anyone on the team can maintain the file without extra help.
Deliverable: one polished .xlsx file that meets the above points and is free of errors on open—no broken references or stray formatting.