User talk:Shebi/VineSim - Revision history

Linalia: /* Page 11 */ new section

2009-04-03T09:53:45Z

Page 11: new section

Shebi at 21:18, 26 March 2009

2009-03-26T21:18:31Z

Xirxx at 20:13, 26 March 2009

2009-03-26T20:13:06Z

Xirxx at 20:12, 26 March 2009

2009-03-26T20:12:56Z

Shebi at 15:18, 26 March 2009

2009-03-26T15:18:33Z

Xirxx at 17:38, 25 March 2009

2009-03-25T17:38:10Z

Darien: Replacing page with 'The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)'

2009-03-06T19:08:51Z

Replacing page with 'The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)'

Darien at 00:27, 4 March 2009

2009-03-04T00:27:47Z

SouperGrrl: New page: The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)

2009-01-21T11:33:29Z

New page: The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)

New page

The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)

← Older revision		Revision as of 09:53, 3 April 2009
Line 8:		Line 8:

	:::I think I'm going to need to test with your old (v2.1) spreadsheet, if you feel ok sharing it. --[[User:Shebi\|Shebi]] 16:18, 26 March 2009 (EST)		:::I think I'm going to need to test with your old (v2.1) spreadsheet, if you feel ok sharing it. --[[User:Shebi\|Shebi]] 16:18, 26 March 2009 (EST)
		+
		+	== Page 11 ==
		+
		+	I noticed that for the OS version Page 11 does not account for all stages and the totals appear different than if they were inserted on another page.
		+
		+	Also I'm wanting to add a few more rows to the tends since some vineyards have more than 35 tending stages, however if I insert more rows into the sheet and put figures in them it doesn't account for them in the totals. Forgive me but I know little about spreadsheets and macros so I don't know how to get it to recognise the extra rows even though the totals have updated the formula to count them in, it's just not calculating them.

← Older revision		Revision as of 21:18, 26 March 2009
Line 6:		Line 6:

	::I was importing from version 2.1 and I have Excel 2007. There was no error when I tried to auto-add my favorite tends. It just put the first tend in the first row on some pages and thats all it did. -- [[User:Xirxx\|Xirxx]] 15:12, 26 March 2009 (EST)		::I was importing from version 2.1 and I have Excel 2007. There was no error when I tried to auto-add my favorite tends. It just put the first tend in the first row on some pages and thats all it did. -- [[User:Xirxx\|Xirxx]] 15:12, 26 March 2009 (EST)
		+
		+	:::I think I'm going to need to test with your old (v2.1) spreadsheet, if you feel ok sharing it. --[[User:Shebi\|Shebi]] 16:18, 26 March 2009 (EST)

← Older revision		Revision as of 20:13, 26 March 2009
Line 5:		Line 5:
	:If you can provide me with a bit more information, such as what version you were importing from, what error you encountered, etc., that would help. --[[User:Shebi\|Shebi]] 10:18, 26 March 2009 (EST)		:If you can provide me with a bit more information, such as what version you were importing from, what error you encountered, etc., that would help. --[[User:Shebi\|Shebi]] 10:18, 26 March 2009 (EST)

−	:I was importing from version 2.1 and I have Excel 2007. There was no error when I tried to auto-add my favorite tends. It just put the first tend in the first row on some pages and thats all it did. -- [[User:Xirxx\|Xirxx]] 15:12, 26 March 2009 (EST)	+	::I was importing from version 2.1 and I have Excel 2007. There was no error when I tried to auto-add my favorite tends. It just put the first tend in the first row on some pages and thats all it did. -- [[User:Xirxx\|Xirxx]] 15:12, 26 March 2009 (EST)

← Older revision		Revision as of 20:12, 26 March 2009
Line 4:		Line 4:

	:If you can provide me with a bit more information, such as what version you were importing from, what error you encountered, etc., that would help. --[[User:Shebi\|Shebi]] 10:18, 26 March 2009 (EST)		:If you can provide me with a bit more information, such as what version you were importing from, what error you encountered, etc., that would help. --[[User:Shebi\|Shebi]] 10:18, 26 March 2009 (EST)
		+
		+	:I was importing from version 2.1 and I have Excel 2007. There was no error when I tried to auto-add my favorite tends. It just put the first tend in the first row on some pages and thats all it did. -- [[User:Xirxx\|Xirxx]] 15:12, 26 March 2009 (EST)

← Older revision		Revision as of 15:18, 26 March 2009
Line 2:		Line 2:

	Hi Shebi! Just want to let you know that I get an error when I import my tendings. Also, the auto-add my favorite tends won't work on individual pages and doesn't work on the macro page - only a couple of the first tends work. I do love the sheet though - thanks! -- [[user:xirxx\|Xirxx]]		Hi Shebi! Just want to let you know that I get an error when I import my tendings. Also, the auto-add my favorite tends won't work on individual pages and doesn't work on the macro page - only a couple of the first tends work. I do love the sheet though - thanks! -- [[user:xirxx\|Xirxx]]
		+
		+	:If you can provide me with a bit more information, such as what version you were importing from, what error you encountered, etc., that would help. --[[User:Shebi\|Shebi]] 10:18, 26 March 2009 (EST)

← Older revision		Revision as of 17:38, 25 March 2009
Line 1:		Line 1:
	The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)		The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)
		+
		+	Hi Shebi! Just want to let you know that I get an error when I import my tendings. Also, the auto-add my favorite tends won't work on individual pages and doesn't work on the macro page - only a couple of the first tends work. I do love the sheet though - thanks! -- [[user:xirxx\|Xirxx]]

← Older revision		Revision as of 19:08, 6 March 2009
Line 1:		Line 1:
	The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)		The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)
−
−
−	~~Wow, I see you found the SS for Open Office fast :)~~
−	Honestly there wasn't much to do other than opening it, unhiding the Lookups. Then having it update the links again, rehide, and save the file. (It kept trying to pull the lookup information from other spreadsheets when I left "Lookups" hidden.)
−
−	As for V2, I only had to do a find/replace ! for . (Worksheets are seperated with a period (.) instead of an exclamation mark (!)). Also, it seemed to have lost all of the proper cell protections though once you turn off sheet protection (Will take time to fix). I don't plan on going much further with it unless there are several folks wanting it. The fix may just be taking the lookup tables out of the individual yard sheets and/or having fewer vineyard tabs.
−
−	On a different note, I updated to Vinesims_v2-2a and its on my discussion page at the bottom. Someone really wanted there to be more than 35 tends. It wasn't as painful to add as I thought it would be. --[[User:Darien\|Darien]] 19:27, 3 March 2009 (EST)

← Older revision		Revision as of 00:27, 4 March 2009
Line 1:		Line 1:
	The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)		The best spreadsheet available of its kind! Use it, pplz! (PS: Thanks, Shebi)
		+
		+
		+	Wow, I see you found the SS for Open Office fast :)
		+	Honestly there wasn't much to do other than opening it, unhiding the Lookups. Then having it update the links again, rehide, and save the file. (It kept trying to pull the lookup information from other spreadsheets when I left "Lookups" hidden.)
		+
		+	As for V2, I only had to do a find/replace ! for . (Worksheets are seperated with a period (.) instead of an exclamation mark (!)). Also, it seemed to have lost all of the proper cell protections though once you turn off sheet protection (Will take time to fix). I don't plan on going much further with it unless there are several folks wanting it. The fix may just be taking the lookup tables out of the individual yard sheets and/or having fewer vineyard tabs.
		+
		+	On a different note, I updated to Vinesims_v2-2a and its on my discussion page at the bottom. Someone really wanted there to be more than 35 tends. It wasn't as painful to add as I thought it would be. --[[User:Darien\|Darien]] 19:27, 3 March 2009 (EST)