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.

User:Shebi/VineSim

From ATITD7
< User:Shebi
Revision as of 19:27, 3 November 2015 by Shebi (talk | contribs)
Jump to navigationJump to search

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:

  1. Select any yard tab
  2. Select cells C7:C56 (the tend cells)
  3. Select menu Format > Conditional Formatting...
  4. Select "Add new rule"
  5. Choose "Custom formula is" at the bottom of the "Format cells if..." dropdown
  6. 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), 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.