Dials per appointment: the call center number that shows money or noise

Hi! Please be my patient guide for this step-by-step guide from Receipts Group: "Dials per certified appointment: the one number to watch every week"
The guide is here: https://receiptsgroup.com/guides/dials-per-certified-appointment (open it if you can; if you can't, everything you need is below).

About me: I run a home-service business with people on the phones booking in-home appointments, and I'm not technical. Use plain words and short sentences.

My goal: one number I watch every week that tells me whether my dials make money or noise: dials divided by certified appointments. Certified means the appointment passed my QA check: someone other than the setter called the homeowner back and confirmed four things. We're talking to the homeowner, everyone who makes the decision will be there, the product is right, and the time works. The bottom number is only the appointments that passed. Leads, conversations and booked appointments don't count. I measure my own number; nobody else's number is a target for me.

How to help me:
1. One step at a time. For each step, tell me in a sentence what it's for and exactly what to do (where to click, what to type, who to ask). Then stop and wait until I say "done" or tell you what I see.
2. Ask before you assume anything about my business, my dialer, my team, my sheet or my numbers. One question at a time.
3. If you use a technical word, explain it in plain English the first time (for example: dial, dialer, QA, certified, pending, baseline, bottom number, formula, cell, column, tab, sparkline).
4. Stop and check with me before anything that costs money (signing up for a tool or a paid plan), anything that reaches a real customer (calling homeowners, changing my dialer's settings, my lists or my calling hours), and anything that deletes something (clearing cells, deleting rows or tabs).
5. Use only what I tell you or show you. Never make up numbers or results, and don't compare my number to anybody else's. If something's missing, ask me.
6. If I paste anything, remind me first to take out homeowners' names, phone numbers and addresses.

The steps, from the guide:

Step 1. Pick the bottom number on purpose.
Help me write down, in a sentence each: what counts as a dial (every call attempt my dialer placed, answered or not: no-answers, voicemails, busy signals and hang-ups all count), what counts as booked, and what my QA check is (the four things above, or mine if I already have one). Ask me what happens to an appointment QA can't reach, and write that rule down too. If I don't have a QA callback yet, tell me that's the first thing to set up, and help me pick who does it: someone other than the setter who booked it.

Step 2. Make the sheet.
Help me make a Google Sheet (sheets.google.com) with one tab for one floor or one list. Row 1 is the headers, then one row per week starting on row 2:
A Week starting, B Dials, C Booked, D Certified, E Pending QA, F Dials per certified, G Booked that passed QA, H Change vs last week, I Change vs baseline, J Floor cost (optional: payroll, dialer, phone lines, lists), K Cost per certified, L What changed (notes, no names).

Step 3. Fill in one row per week.
B comes from my dialer's report for that week. C, D and E come from my QA log or my CRM. Certified counts in the week the appointment was booked, not the week QA passed it, so both numbers come from the same dials. Ask me what dialer and CRM I use and help me find where each number lives. Don't guess menu names: if you're not sure, tell me to look for the call report for a date range.

Step 4. Add the formulas.
Walk me through typing these exactly as written:
Row 2 (your first week):
F2  =IF(D2=0,"none certified",ROUND(B2/D2))
G2  =IF(C2=0,"none booked",D2/C2)
I2  =IFERROR(F2/$O$4-1)
K2  =IF(D2=0,"none certified",ROUND(J2/D2))

Row 3 (your second week), the same four with 3, plus H:
F3  =IF(D3=0,"none certified",ROUND(B3/D3))
G3  =IF(C3=0,"none booked",D3/C3)
H3  =IFERROR(F3/F2-1)
I3  =IFERROR(F3/$O$4-1)
K3  =IF(D3=0,"none certified",ROUND(J3/D3))

Every new week: the same five formulas with that row's
number (row 4 uses B4, C4, D4, J4, and F4/F3 in H).
$O$4 always stays $O$4: that's your baseline.

Step 5. My baseline: my last 10 dialing days.
Help me fill in N1 to O6:
N1  Baseline: last 10 dialing days ([first day] to [last day])
N2  Dials                 O2  [the total from your dialer for those days]
N3  Certified             O3  [booked in those days and passed QA]
N4  Dials per certified   O4  =ROUND(O2/O3)

N6  Trend                 O6  =SPARKLINE(F2:F60,{"empty","ignore";"nan","ignore"})

Step 6. Read it every week.
Once QA has finished with last week (E is 0), fill in its row and read F. G, H and I show decimals: 0.10 in H means 10% more dials per certified appointment than the week before, and 0.71 in G means 71 out of 100 bookings passed QA. Help me read it like this:
- Dials up, booked flat: more dials aren't turning into bookings. Look at the list, the calling hours and the dialer.
- Booked steady, certified down (G falling): bookings are missing a QA check. Look at which check misses most.
- Dials down, number flat: fewer dials, same result per dial. That's staffing or hours, not quality.
- The number drops fast: before celebrating, check that QA's check didn't get looser and nobody started counting booked as certified.
- Small weeks: with only a handful of certified appointments, one more or one less moves the number a lot, so read two weeks together.
If the number creeps up, help me find what changed (column L) before anyone buys more dials. Before I change my dialer's pace, my list or my calling hours, remind me to check the calling rules (federal and my state's) with my lawyer.

Rules: this is my number, from my list, my market and my hours. Don't tell me what a good number is. Help me watch mine.

Here are the weekly numbers from my phone floor. Please read them for me in plain words.

What the columns mean:
- Dials: every call attempt the dialer placed that week, answered or not.
- Booked: appointments set that week.
- Certified: of the ones booked that week, how many passed QA (a callback by someone other than the setter confirmed the homeowner, every decision maker, the product and the time).
- Pending QA: of the ones booked that week, how many QA hasn't finished.
- Dials per certified: dials divided by certified.
My baseline is my last 10 dialing days: [dials] dials, [certified] certified.

Please tell me:
1. For each week, dials per certified, and whether it went up or down from the week before and from my baseline.
2. Any week where Pending QA isn't 0. Tell me to wait on that week instead of reading it.
3. Any week with only a handful of certified appointments, where one more or one less would move the number a lot.
4. Whether dials per booked and dials per certified are moving in different directions, and what that points at: the list, the hours and the dialer (more dials aren't turning into bookings), or the bookings themselves (they're missing a QA check).
5. Up to three questions I should ask my team about what changed.

Rules: use only the numbers I paste. Never guess a number I didn't give you. Don't compare my numbers to anybody else's or tell me what a good number is.

My weeks (week starting, dials, booked, certified, pending QA):
[paste them here: numbers only, no names]