MAKING A NEW SPREADSHEET - Open the Google Sheets document! (You can see which VERSION it is by checking the title; the current version is also preserved on the INSTRUCTIONS sheet for future reference.)
- FILE > Make a copy - You will want one copy for each character you plan to use this code for. - Review the INSTRUCTIONS sheet if necessary. Also available on this sheet: quick-copy HTML that might be useful to you. Feel free to add more snippets. (You can then RIGHT-CLICK the INSTRUCTIONS SHEET and choose "Hide Sheet" to hide it.) - From the SETTINGS sheet, set up your sections and pick your colors. These can be in any order. You can also add or remove sections, though I would recommend an even number. :) Perhaps combining "IC Limit"/"OOC Limit" into just "No" and adding "Favorites" as the first section. - Fill out the LIST sheet, being sure to update your "Section" column if you've changed the sections from the original sheet.
NOTE: You can create line-breaks in any Google Sheets cell by hitting CTRL/CMD+ENTER.
COPYING YOUR DATA TO A NEW VERSION - You can absolutely copy-paste data from old versions of my spreadsheet to new copies! Click on a column (e.g., "A" at the very top of the Section column on the LIST sheet), hit CTRL/CMD+C, and switch tabs to your fresh copy of my updated spreadsheet. Highlight the "A" column there, then hit CTRL/CMD+V. - Take more care when copy-pasting columns with formulas involved, such as the Type and Fave columns; these can still be copy-pasted safely, as long as the values in the drop-down have not changed. - Everything on the SETTINGS sheet, it would probably be safer to manually copy over instead.
USAGE
- Open the Google Sheets document! (You can see which VERSION it is by checking the title; the current version is also preserved on the INSTRUCTIONS sheet for future reference.)
- FILE > Make a copy
- You will want one copy for each character you plan to use this code for.
- Review the INSTRUCTIONS sheet if necessary. Also available on this sheet: quick-copy HTML that might be useful to you. Feel free to add more snippets. (You can then RIGHT-CLICK the INSTRUCTIONS SHEET and choose "Hide Sheet" to hide it.)
- From the SETTINGS sheet, set up your sections and pick your colors. These can be in any order. You can also add or remove sections, though I would recommend an even number. :) Perhaps combining "IC Limit"/"OOC Limit" into just "No" and adding "Favorites" as the first section.
- Fill out the LIST sheet, being sure to update your "Section" column if you've changed the sections from the original sheet.
NOTE: You can create line-breaks in any Google Sheets cell by hitting CTRL/CMD+ENTER.
COPYING YOUR DATA TO A NEW VERSION
- You can absolutely copy-paste data from old versions of my spreadsheet to new copies! Click on a column (e.g., "A" at the very top of the Section column on the LIST sheet), hit CTRL/CMD+C, and switch tabs to your fresh copy of my updated spreadsheet. Highlight the "A" column there, then hit CTRL/CMD+V.
- Take more care when copy-pasting columns with formulas involved, such as the Type and Fave columns; these can still be copy-pasted safely, as long as the values in the drop-down have not changed.
- Everything on the SETTINGS sheet, it would probably be safer to manually copy over instead.