Claude Code request size: what our local recorder measured
Recorded request sizes for CLAUDE.md, skills and MCP tools in Claude Code. What the byte counts show, and why they do not measure your bill.
At a glanceReplace names with “Customer A” and “Customer B,” and use fake phone numbers with the same digit counts and hyphen positions. Preserve formatting because changing it can obscure the cause of formula failures.

When you paste an entire file to ask AI about an Excel formula, information such as names, contact details, and business partners is sent along with it. To fix a formula, the column structure and a few representative rows are usually enough. This article outlines how to mask real data, create example rows, and then verify the formula. It is a checking procedure based on formula rules in Microsoft support documents, not a result tested with an actual AI tool.
What AI needs to know is which column to search and which column to retrieve a value from. Copy one header row and only 5–10 representative rows from the original sheet, leaving out the remaining rows and other sheets. Also remove information that reveals the organization, such as sheet names or file paths, from the question.
Replace names with “Customer A” and “Customer B,” and replace phone numbers with fake numbers that retain the same number of digits and hyphen positions. If you change the format, you may misidentify the cause of a formula failure. Microsoft support documents cite hidden spaces in cells and numbers stored as text as reasons MATCH may fail to find a value. Therefore, leave leading and trailing spaces, numbers formatted as text, and blank cells in the same state as in the original.
Here is a hypothetical example. If “Customer A” has an amount of 10,000 won and “Customer B” has 25,000 won in the example table, their combined value should be 35,000 won. First check whether the same value appears when you enter the formula provided by AI into the example sheet. If the example value is incorrect, fix the formula before moving it to the actual file. These names and amounts were created for explanatory purposes.
AI often wraps INDEX and MATCH formulas in IFERROR. However, Microsoft support documents explain that replacing #N/A with another value only identifies the error and does not resolve it. The cause is usually spaces, numbers stored as text, or a mismatch between match_type and the sort order. If match_type is 1 or omitted, the lookup range must be sorted in ascending order; if it is -1, it must be sorted in descending order. Check these two points first in the example sheet.
If the result is correct in the example sheet, move only the formula to the actual file. The reference method is important here. Microsoft support documents explain cell references as relative references and absolute references. Add the $ symbol to lookup ranges that must remain fixed when copied, and directly compare the results for several rows in the actual file. Store the anonymized file and the original file separately without mixing them.
Source: Microsoft Support “How to correct a #N/A error in INDEX/MATCH functions” , Microsoft Support “How to correct a #N/A error” , Microsoft Support “Overview of formulas in Excel” . The three materials were opened and read on Oct 29th 2026 KST. If you use Copilot with a company account, also check your organization’s data protection settings (Microsoft Learn document ). The names and amounts in the examples above are fictional. Related articles: AI document privacy checklist , When the leading 0 disappears in Excel
Read the Korean original on Naver
This article reflects public information available when it was written. Specifications, prices and schedules can change; check the linked official documentation.
This English edition was written and translated with AI assistance, with sources provided. For errors or additional information, please request a correction. Editorial policy
Found this useful? Share it, or follow for new guides.