No Bullshit AINo Bullshit AIno-bullshit-aiCannabis Courseby Distru00 XP
Plain English

Paste the Spreadsheet: Working With Your Own Data

Yes, you can paste a 500-row inventory export into a chat and ask questions. Here is what to paste, what to cut first, and why you ask for the formula instead of the total.A 500-row inventory export (a CSV) fits in the model's working memory (the context window) with room to spare. Here is what to paste, what to strip and redact first, and why anything numeric gets a formula or script back instead of a number.CSV in context vs. a tool: token budgets by shape, header discipline, redaction before paste, chunking by group, and the rule that the model writes the query and the runtime computes the answer.

8 min read2 giveaways

Questions this answersQuestions this answersfaq

can I paste a 500-row inventory export into an AI chat?can I paste a 500-row inventory export into an AI chat?how large a CSV fits in context?
Yes, easily. A 500-row, ten-column package export with a Metrc tag on every row is roughly 25 to 30 thousand word-chunks, and it fits in any current chat with room to spare. Keep the header row, cut the columns the question does not need, and take the customer names out first. Past a few thousand rows, upload the file or ask for a script instead.Yes, easily. A 500-row, ten-column package export with a Metrc tag on every row is roughly 25 to 30 thousand word-chunks, and it fits in any current chat with room to spare. Keep the header row, cut the columns the question does not need, and take the customer names out first. Past a few thousand rows, upload the file or ask for a script instead.A 500-row, 10-column export with tags runs about 25 to 30K tokens, comfortably inside current context windows; tags and numbers tokenize denser than prose, so a Metrc export costs roughly twice what the same volume of text would. Keep the header, drop unneeded columns, redact PII, and keep tags as text so a spreadsheet does not turn them into scientific notation. Beyond that scale, give the model a tool and let the runtime hold the data.
why does AI get the total wrong on my export?why does AI get the total wrong on my export?why is model-computed aggregation unreliable?
It reads numbers as chunks of text, not digits, so it lands close rather than exact, and close is worse than wrong because nobody checks a close number. For anything numeric past about twenty rows, ask for the formula instead of the answer: write the formula that sums quantity where status is Active. Paste that into your sheet and the number comes from the sheet.It reads numbers as chunks of text, not digits, so it lands close rather than exact, and close is worse than wrong because nobody checks a close number. For anything numeric past about twenty rows, ask for the formula instead of the answer: write the formula that sums quantity where status is Active. Paste that into your sheet and the number comes from the sheet.There is no arithmetic unit and no second pass over the rows, so a long sum fails silently: no error, no flag, just a number that is off. Have the model emit the expression instead, a SUMIFS, a pandas groupby or the equivalent SQL, and let the runtime compute it. Code is checkable and reproducible; a summarized number is neither.

Read the rest for freeSign in to read the restauth required past this point

A name and an email, once. The whole course is free, nothing is sold to you, and your place is kept so you can pick it up on your phone later.A name and an email, once. The course is free; the account exists so your progress and your level on the dial follow you between devices, and so you can be issued a certificate at the end.name + email. free. account carries completion state, data-level and certificate issuance.

Sign in or sign upSign in or sign upsign in

We store your name, your email, which lessons you open and which you finish, and the reading level you use. Distru can see that. Nothing is charged and nothing is sold on.Stored: name, email, which lessons you open and complete, and your level on the dial. Distru staff can see it. No payment, no third-party advertising trackers.stored: name, email, per-lesson view + completion, data-level. visible to Distru. no payment, no ad-tech, no third-party pixels.