The Wiki for Tale 4 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 talk:Shebi/VineSim"

From A Tale in the Desert
Jump to navigationJump to search
(→‎Page 11: new section)
 
(6 intermediate revisions by 3 users not shown)
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]]
  
Wow, I see you found the SS for Open Office fast :)
+
: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)
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.  
+
::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)
  
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)
+
:::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.

Latest revision as of 09:53, 3 April 2009

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! -- 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. --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. -- 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. --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.