Daily Email APR Reporting

₹600-1500 INR

Selesai

Disiarkan 28 hari yang lalu

₹600-1500 INR

Dibayar semasa penghantaran

I track customer-service email performance every day and I need a clear, repeatable way to see how we are doing at a glance. Please build an Excel spreadsheet that turns my raw daily data into an APR report laid out on separate sheets for each category that matters to me. Sheets required • Daily email counts • Breached and met emails • Breached emails • Met emails • SLA 15 minutes • SLA 30 minutes • SLA performance What I expect on each sheet • The total number of emails processed that day. • A split between emails that breached SLA and those that met it, shown both as counts and percentages. • For the 15-minute and 30-minute SLA sheets, the number of emails that met each target and the associated success rate. • Simple, readable formulas so I can audit or edit the logic later, with no hidden cells or password protection. If a lightweight macro, pivot table, or Power Query makes daily refresh easier, feel free to use it—the file just needs to stay entirely in Excel so I can hand it over to the rest of the team without extra software. The job is done when I can drop in a new day’s raw data and the workbook instantly updates every sheet with correct figures and percentages.

ID Projek: 40313338

Tentang projek

3 cadangan

Projek jarak jauh

Aktif 27 hari yang lalu

Ingin menjana wang?

Alamat e-mail

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@praveenveera277

You want a workbook where you can drop in daily raw data and instantly see SLA performance across multiple sheets, with clear formulas and no hidden logic—that’s exactly the kind of reporting setup I’ve built before. I’ve created Excel trackers that split breached vs met emails, calculate percentages automatically, and generate clean SLA views (15/30 mins) using formulas, pivot tables, and Power Query for quick refresh. The focus is always on making the logic easy to follow so anyone on your team can audit or tweak it later. I’ll structure each sheet exactly as you described and make sure updates happen as soon as new data is added. If you want, share a sample of your raw data and I’ll map out the structure before starting.

₹950 INR dalam 2 hari

0.0

(0 ulasan)

0.0

3 pekerja bebas membida secara purata ₹1,167 INR untuk pekerjaan ini

@bhartimalu

Hello, I can automate your Daily APR reporting using Excel VBA so that data is processed, formatted, and emailed automatically without manual effort. I’ll build a reliable macro that fetches/updates data, calculates APR metrics, generates a clean report, and sends it via email (Outlook integration) on schedule. This type of automation eliminates repetitive work and ensures accurate, consistent reporting every day with zero delays. You’ll get a fully working solution with error handling, easy controls, and clear instructions for future use. Ready to start immediately. Regards, Bharti

₹1,050 INR dalam 7 hari