Condo Maintenance Tracker Spreadsheet

$30-100 USD

Sürüyor

İlan edilme: yaklaşık 2 ay önce

$30-100 USD

Teslimde ödenir

I need a streamlined Excel workbook that lets me type in a unit number, date of service, service company, description of the repair, vendor, invoice number, parts cost, labour, and tax, then instantly answers two questions: • “How much did that job cost?” — The sheet must apply a formula that adds parts, labour, and tax so the Total Cost field populates automatically (Yes, calculate totals). • “How is each unit performing over time?” — I want built-in statistics that refresh on entry: service frequency and the average cost per service for every unit (Yes, show statistics with Service frequency; Average cost per service). A small dashboard, pivot table, or anything similarly clear is welcome, provided I can filter by unit and quickly spot where money is going. Keep the file uncluttered, formula-driven, and protected against accidental overwrites while still letting me add rows on the fly. Once delivered, I should be able to drop the workbook into OneDrive and have it work without additional setup. how often the unit is serviced no matter what the service was.

Proje No: 40266146

Proje hakkında

19 teklifler

Uzaktan proje

Son aktiviteden bu yana geçen zaman 2 ay önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@ParisPallas

$0 USD 3 gün içinde

5,0

(856 değerlendirme)

9,0

19 freelancer bu proje için ortalama $124 USD teklif veriyor

@DYehia2020

Hello, I HAVE REVIEWED YOUR PROJECT REQUIREMENTS, AND I AM READY TO START IMMEDIATELY. I am an expert in excel, formulas and data visualization I offer unlimited revisions and guarantee 100% satisfaction. Let’s discuss the details in chat.

$140 USD 7 gün içinde

5,0

(174 değerlendirme)

6,7

@mehmoodfaisal61

Hello, I hope you are doing well. I hold a master's degree in Statistics from a renowned university. I am a well experienced data analyst. I have good command over popular statistical software i.e., Excel, SPSS, RStudio, Jamovi, and Stata (please visit my profile to check reviews for my past projects). I have reviewed and understood your requirements, I can help you with this project. Please feel free to ask me, if you have any queries.

$250 USD 7 gün içinde

5,0

(50 değerlendirme)

6,5

@ZohaibRoy

⭐⭐⭐⭐⭐ Create an Efficient Excel Workbook for Service Cost Tracking ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project needs and see you're looking for an Excel workbook to track service costs and performance. You don’t need to look any further; Zohaib is here to help! My team has successfully completed 50+ similar projects for Excel solutions. I'll design a workbook that calculates total costs and provides clear performance statistics. ➡️ Why Me? I can easily create your Excel workbook as I have 5 years of experience in Excel data management, specializing in formula creation, data analysis, and dashboard design. I also have a strong grip on other relevant tools, ensuring a comprehensive approach to your project. ➡️ Let's have a quick chat to discuss your project in detail and let me show you examples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Excel Formulas ✅ Data Analysis ✅ Dashboard Design ✅ Pivot Tables ✅ Data Visualization ✅ Spreadsheet Automation ✅ Cost Tracking ✅ Service Frequency Analysis ✅ Error Checking ✅ Report Generation ✅ User-Friendly Design ✅ Data Protection Waiting for your response! Best Regards, Zohaib

$150 USD 2 gün içinde

5,0

(26 değerlendirme)

6,4

@techplusintl

Hi there, I’m ready to start immediately and will create a streamlined Excel workbook that meets your needs. I will set up formulas to automatically calculate the total cost by adding parts, labor, and tax. Additionally, I will implement built-in statistics to track service frequency and average cost per service for each unit. This will allow you to see how each unit is performing over time. I have previously designed similar Excel dashboards that provided clear insights and made data management easier for my clients. To ensure the workbook remains uncluttered and user-friendly, I will protect it against accidental overwrites while allowing you to add rows as needed. Once completed, you’ll be able to drop it into OneDrive without any extra setup. Could you clarify if you have any specific preferences for the layout of the dashboard or the statistics you want to see? Regards, Burhan Ahmad

$160 USD 2 gün içinde