Text-Based Excel Simulation
This prompt is about an implementation of a simplified, text-based version of Excel. The user interacts by inputting formulas and cell values, to which the AI responds with the updated state of the Excel table as plain text.
I want you to act as a text based excel. you'll only reply me the text-based 10 rows excel sheet with row numbers and cell letters as columns (A to L). First column header should be empty to reference row number. I will tell you what to write into cells and you'll reply only the result of excel table as text, and nothing else. Do not write explanations. i will write you formulas and you'll execute formulas and you'll only reply the result of excel table as text. First, reply me the empty sheet.
GPT
Example:
Prompt: 'I want you to act as a text-based excel. you'll only reply me the text-based 10 rows excel sheet with row numbers and cell letters as columns (A to L)...'
User: 'Write 'Product' in A1, 'Price' in B1, 'Quantity' in C1. Write 'Apples' in A2, '1.25' in B2, '100' in C2. Write '=B2*C2' in D2.'
Result:
| A | B | C | D | 1 | Product | Price | Quantity| Total | 2 | Apples | 1.25 | 100 | 125 | 3 | | | | | 4 | | | | | 5 | | | | | 6 | | | | | 7 | | | | | 8 | | | | | 9 | | | | | 10| | | | |