· 2 min read
Eddition
A script that edits Google spreadsheets (the required number, in the desired folder, the same or with the necessary changes).
Origin
We have interactive courses (task books) in various areas: UX design, management, UX writing, marketing and much more. Their first versions were in Google Sheets and looked like this.
When we launched the first task book on tables, two days after launch we found several fundamental errors in it. There were some typos, and in a couple of places points for completed tasks were calculated incorrectly. There were mistakes that could be corrected later, but there were also those that annoy students right now.
We went to fix them. There were just under a hundred students, so we thought we’d quickly fix everything. We corrected it, the students were happy, the night was very long and fun. We didn’t want more of this experience of manually correcting errors in each Google sheet. It needs to be automated.
And then Eddition was born.
Hwo are the users?
Everyone who somehow intersects with Google Sheets in their work.
How Eddition works?
The script has 3 functions.
- The ability to correct one specific cell.
- Possibility to correct several cells.
- Ability to insert your own formula into a cell.
Eddition helps you to:
- save time;
- increase productivity;
- automate document creation.
What problems Eddition solves:
- If you have an array of identical documents, Eddition will help you correct a systematic typo in all documents or make the same change (recolor a column, for example).
Eddition, as a script, can only change literal values, formatting, conditional formatting, and work with formulas. It can’t work with pictures.
We also prepared an Instruction.
If you have questions or can’t understand the principles of this script work, write to us to we@eduhund.com, we’ll help :)
