Check Your Weekly Numbers Sheet with ChatGPT Data Analysis

1. In your spreadsheet, make a copy of the file so the original stays untouched.
2. Delete any tab that has customer or staff details.
3. Check that row 1 holds short, plain headers, that each week is one row and that there are no blank rows or columns splitting the data. OpenAI's data analysis help page recommends descriptive headers, one record per row and no empty rows or columns.
4. Leave the formulas in place. If you want the formulas visible to ChatGPT, see Step 2.

What you should see: one tab, one header row, eight (or more) weekly rows. Troubleshooting: If your sheet has merged cells or decorative title rows, delete them in the copy. The tool reads tidy tables best.

1. Choose File, then Download, then Comma Separated Values (.csv) in Google Sheets, or save as .xlsx in Excel.
2. ChatGPT's data analysis help page lists .xls, .xlsx and .csv as supported types.
3. A CSV file carries the calculated results but not the formulas behind them. To let ChatGPT see formulas, type them into your message as text, as shown in Step 4.

What you should see: a file in your downloads folder. Troubleshooting: A CSV with an error value such as #DIV/0! in a cell is fine. That is one of the things you want ChatGPT to notice.

1. Open ChatGPT at chatgpt.com and start a new chat.
2. Look for the attach or plus button near the message box and choose to add a file.
3. Pick your exported file and wait until it shows as attached.

What you should see: the file name in the message box. Troubleshooting: If you cannot find an attach option, check OpenAI's current help pages for your plan. Plan features and menu names change.

Paste this message and add your formulas below it. In the invented sheet, the formulas are as shown.

This is a weekly numbers file with no customer or staff names. Invented practice data. Columns: A Week, B Leads, C Booked jobs, D Revenue, E Labor hours, F Marketing spend, G Average ticket, H Cost per lead.

My formulas, row 7 and row 9 shown as examples:
G7 =D7/C7
H7 =F7/B7
G9 =D9/C9
H9 =F9/C9

1. Explain in plain words what each calculated column measures.
2. List any formula that could break on a blank cell or a zero, and say which rows in this file would show an error.
3. Check whether each formula divides the right columns for what its header says.
4. Chart booked jobs and average ticket by week.
Do not change my data. Tell me what you see and I will fix the sheet myself.

What you should see: a plain-language explanation of columns G and H, a note about the zero in Week 6, a flag on H9 and two charts. Troubleshooting: If ChatGPT does not mention row 9, ask, "Compare the formula in H9 with the formula in H7 and tell me if they measure the same thing."

1. Look at what ChatGPT says about row 7. Week 6 has 0 booked jobs, so =D7/C7 divides 0 by 0 and shows #DIV/0!.
2. Open your sheet and confirm the error appears in G7.
3. Fix it with a guarded formula. In G7, type:

=IF(C7=0,"",D7/C7)

1. Copy that formula down column G, rows 2 to 9, so every week is protected.

What you should see: G7 now shows a blank. The other weeks keep their values, which are 225, 228, 230, 235, 240, blank, 235 and 240 in the invented sheet. Troubleshooting: If a chart treats the blank as zero, ask ChatGPT to leave Week 6 as a gap, or hide that row in the chart.

1. Look at what ChatGPT says about H9. Cost per lead is marketing spend divided by leads, so for Week 8 it should be =F9/B9.
2. The sheet has =F9/C9, which divides marketing spend by booked jobs. That gives 650 / 19, about 34.21, instead of 650 / 44, about 14.77.
3. In your sheet, correct H9 to:

=F9/B9

1. Check the other rows in column H use the same pattern.

What you should see: H9 now shows about 14.77, close to the weeks around it. Troubleshooting: A wrong-column error does not show an error message. The number just looks plausible. That is why comparing a formula with its header matters.

1. For each number ChatGPT quotes, find that number in your own sheet.
2. Recompute one or two by hand. For example, W5 average ticket is 4320 / 18 = 240.
3. If ChatGPT says a total, check it against your sheet's total row. The invented totals are 286 leads, 113 booked jobs, revenue 26415, 570 labor hours and marketing spend 4150.
4. Treat anything you cannot find in your sheet as unconfirmed.

What you should see: every figure ChatGPT used matches a cell in your sheet. Troubleshooting: If a figure does not match, ask, "Which rows did you use for that number?" Then check those rows yourself. The sheet is the record.