User:Shebi/VineSim

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), 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.