The Wiki for Tale 7 is in read-only mode and is available for archival and reference purposes only. Please visit the current Tale 11 Wiki in the meantime.
If you have any issues with this Wiki, please post in #wiki-editing on Discord or contact Brad in-game.
Difference between revisions of "User:Shebi/VineSim"
| Line 26: | Line 26: | ||
Once you have one sheet done, you can select the tend cells again (C7:C56), copy, and then paste them on each other yard sheet. | Once you have one sheet done, you can select the tend cells again (C7:C56), copy, and then paste them on each other yard sheet. | ||
| + | |||
NOTE: Be sure to select "Paste special... Paste conditional formatting only" if you have already entered some tends into a sheet. | NOTE: Be sure to select "Paste special... Paste conditional formatting only" if you have already entered some tends into a sheet. | ||
Revision as of 19:28, 3 November 2015
Wines — Vines — Vineyards — Flavors
VineSim — TendGen
Wine Template — Vine Template — YT Template
Overview
VineSim is a Google Spreadsheet for tracking up to 25 vineyard states and tends, and the resulting grape stats.
How to Use
- Access the VineSim spreadsheet.
- File > Make a copy.
- The Instructions tab gives an overview of the tabs.
Versions
3.06
- Added conditional formatting to yard sheets to turn empty tend cells to red/red text when you select "Yes" in the Done cell (J2). Hopefully this will help prevent over tending.
Updating your sheets
You may apply the conditional formatting to your already-in-progress sheet as follows:
- Select any yard tab
- Select cells C7:C56 (the tend cells)
- Select menu Format > Conditional Formatting...
- Select "Add new rule"
- Choose "Custom formula is" at the bottom of the "Format cells if..." dropdown
- Type (or copy/paste) this formula: =AND($J$2="Yes",ISBLANK($C7))
Once you have one sheet done, you can select the tend cells again (C7:C56), copy, and then paste them on each other yard sheet.
NOTE: Be sure to select "Paste special... Paste conditional formatting only" if you have already entered some tends into a sheet.
3.05
- Fixed a calculation error on the Grapes Summary tab.
Updating your sheets
You may copy the blue cells in Columns I and J (Bottles and Extra) from the updated sheet to your personal sheet, without affecting anything else.
3.04
- First public release
- Vines included
- Amusement
- Wisdom
Discussion
Feel free to add your comments or suggestions to the Discussion tab.
Credits
- The original Excel version was created by Shebi during Tale 3.
- Version 2.0 was managed by Shebi (Excel) and Darien (Open Office) during Tale 4.
- Version 3.0 for Google Docs was created by Shebi during Tale 7, with user testing by Daetrin.
