Daily Email APR Reporting

₹600-1500 INR

Concluído

Publicado há aproximadamente 1 mês

₹600-1500 INR

Pago na entrega

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 do Projeto: 40313338

Sobre o projeto

3 propostas

Projeto remoto

Ativo há 1 mês

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

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

Concedido a:

@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 em 2 dias

0,0

(0 avaliações)

0,0

3 freelancers estão ofertando em média ₹1.167 INR for esse trabalho

@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 em 7 dias