User:Shebi/VineSim - Revision history

Shebi at 04:24, 5 December 2015

2015-12-05T04:24:06Z

Shebi at 19:41, 7 November 2015

2015-11-07T19:41:46Z

Shebi: /* Updating your sheets */

2015-11-03T19:30:12Z

Updating your sheets

Shebi: /* Updating your sheets */

2015-11-03T19:28:18Z

Updating your sheets

Shebi: /* Updating your sheets */

2015-11-03T19:28:05Z

Updating your sheets

Shebi at 19:27, 3 November 2015

2015-11-03T19:27:47Z

Shebi: /* Versions */

2015-10-31T05:42:54Z

Versions

Shebi at 01:55, 27 October 2015

2015-10-27T01:55:07Z

Shebi: Created page with "== 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 [https://docs.googl..."

2015-10-27T01:54:10Z

Created page with "== 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 [https://docs.googl..."

New page

== 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 [https://docs.google.com/spreadsheets/d/1wNpFQxo49aR0Nx3KVbx50WR0omeEOfJP3KWktGb04lk/edit?usp=sharing VineSim spreadsheet].
* File > Make a copy.
* The Instructions tab gives an overview of the tabs.

== Versions ==
=== 3.04 ===
* First public release
* Vines included
** Amusement
** Wisdom

== Discussion ==
Feel free to add your comments or suggestions to the [[User talk:Shebi/VineSim|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.

@@ Line 13: / Line 13: @@
 == Versions ==
 === 3.1 ===
 * Added Flavor Summary tab for recording your found flavors for each vineyard.
 * Added [[Wine/Appreciation|Appreciation]] tend tables.
 ==== Updating your sheets ====
-* Copy/paste the tables on the Appreciation tab into your Appreciation tab.
+* Tend tables
-* Copy/paste the Lookup tab content into your Lookup tab.
+** Copy/paste the tables on the Appreciation tab into your Appreciation tab.
-* On the Flavor Summary tab, click on the tab and select "Copy to..." and select your spreadsheet. This will place the new tab at the end, but you can move it to where you want it by dragging or using the "Move left" command.
+* Flavor Summary tab
-** Alternatively, create a new tab where you want it, name it Flavor Summary and then copy/paste the content onto it.
+*# Copy/paste the Lookup tab content into your Lookup tab.
 === 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 ====
@@ Line 41: / Line 64: @@
 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.
+<div style="background-color: linen; padding: 0px 10px 5px 10px; margin-top: 10px; border: 1px solid black;">
 === 3.04 ===
 * First public release
@@ Line 53: / Line 78: @@
 ** Amusement
 ** Wisdom
 == Discussion ==

@@ Line 13: / Line 13: @@
 == 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.

@@ Line 24: / Line 24: @@
 # 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.

← Older revision		Revision as of 19:28, 3 November 2015
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.

@@ Line 25: / Line 25: @@
 # 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.
+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 ===

← Older revision		Revision as of 01:55, 27 October 2015
Line 1:		Line 1:
		+	__NOTOC__
		+	{{User:Shebi/Wine Navigation}}
		+
	== Overview ==		== Overview ==
	VineSim is a Google Spreadsheet for tracking up to 25 vineyard states and tends, and the resulting grape stats.		VineSim is a Google Spreadsheet for tracking up to 25 vineyard states and tends, and the resulting grape stats.