OpenCode

Do this with it

• Data

  Redact first

  Get cleaning steps for a spreadsheet, without uploading it

  20 minutes · Gives you numbered steps

  Answer in [ANSWER LANGUAGE], even if the material below is in another language.
  
  I have a spreadsheet I cannot upload. I will describe it instead. The three rows below are invented by me, not copied out of the file, and I will never paste a real row. Do not ask me for the file or for real rows.
  
  Columns and what they hold:
  [LIST THE COLUMN NAMES AND WHAT EACH CONTAINS]
  
  Three invented rows, in the same shape as the real ones:
  [PASTE THREE INVENTED ROWS]
  
  What is wrong with it:
  [DESCRIBE THE PROBLEMS: mixed date formats, duplicates, mixed digits: ١٢٣ alongside 123, trailing spaces, merged cells, several answers in one cell]
  
  What I need at the end:
  [DESCRIBE THE RESULT YOU WANT]
  
  Give me, in this order:
  A. Numbered steps, in the order I should do them, each saying what to do and what the file will look like afterwards.
  B. The formula, or the script, for each step that needs one. Say which program it is for.
  C. The assumptions you made about my data, one per line, and for each one what it will silently break if the assumption is wrong and how I would spot that.
  D. What to check after each step to know it worked, including the row count before and after.
  
  Work only from my description. If my description is not enough to write a step safely, say what you need to know instead of guessing.

  CopyCopiedHow to use it

• Data

  Redact first

  Find the difference between receipts and a ledger

  20 minutes · Gives you numbered steps

  Answer in [ANSWER LANGUAGE], even if the material below is in another language.
  
  My receipts and my spreadsheet do not agree, and I can upload neither of them. I will describe the spreadsheet instead. Real rows are never pasted here, so do not ask me for them and do not ask me to upload a file.
  
  Columns and what each one holds:
  [LIST THE COLUMN NAMES AND WHAT EACH CONTAINS]
  
  Three invented rows in the same shape as the real ones:
  [PASTE THREE FAKE ROWS]
  
  What does not match:
  [DESCRIBE THE DIFFERENCE: the two totals differ, a receipt has no row, a row has no receipt, one payment is split across two receipts, mixed digits: ١٢٣ alongside 123, two currencies, dates written in two formats]
  
  Rules:
  1. Work only from my description and the invented rows. Never invent a figure of mine, and never assume a total.
  2. If a step cannot be done without seeing my data, say so and tell me what to look at myself.
  3. Order the steps so that the cheapest check comes first.
  
  Give me, in this order:
  A. Numbered steps, in the order I should do them, each one narrowing down where the difference is.
  B. The formula or the script for each step that needs one, and which program it is for.
  C. The assumptions you made about my spreadsheet, as a list, and for each one, what it silently breaks if it is wrong.
  D. What to check after each step, including the row count and the total before and after.

  CopyCopiedHow to use it