Valor Excel Sheet
-
- Lancer
- Posts: 12
- Joined: Fri Jan 04, 2013 6:58 am
-
- Lancer
- Posts: 2
- Joined: Tue Mar 26, 2013 7:35 pm
Not sure if this is just a problem on my end... But when I put my cities into the 'Names' pages, the number of scouts isn't adding up correctly, and the number of ballistas doesn't add up at all. For example, I put in cities that had a total of under 1,000 scouts combined, but it says my total number is almost 7,000...?
-
- Lancer
- Posts: 12
- Joined: Fri Jan 04, 2013 6:58 am
SoulSlayer556 wrote:Not sure if this is just a problem on my end... But when I put my cities into the 'Names' pages, the number of scouts isn't adding up correctly, and the number of ballistas doesn't add up at all. For example, I put in cities that had a total of under 1,000 scouts combined, but it says my total number is almost 7,000...?
What line are you having issues with? Totals add up correctly for me. Can you perhaps post a screenshot of this?
RS406 wrote:Matthew,
Thanks for sharing this great spreadsheet. i don't want to be pushy but Do you have an updated spreadsheet you wouldn't mind sharing? Also, would you consider releasing one that isn't password protected so we could make some modification to meet or personal preferences?
I haven't had time to update the sheet lately. I am still trying to figure out the way ballistas and rams behave so I can build a proper battle simulator.
I don't plan on releasing a non-password protected version, however, if you send me a personal message with your suggested modification I may add it to the sheet or give you the password to the current sheet if I choose not to add it.
Matthew618 wrote:What line are you having issues with? Totals add up correctly for me. Can you perhaps post a screenshot of this?
I haven't had time to update the sheet lately. I am still trying to figure out the way ballistas and rams behave so I can build a proper battle simulator.
I don't plan on releasing a non-password protected version, however, if you send me a personal message with your suggested modification I may add it to the sheet or give you the password to the current sheet if I choose not to add it.
The cell G3 for total number of scouts on the overview page sums the scouts, knights, guardians, AND rams columns on the names page. It should be =SUM(Names!Y3:Y1000) not =SUM(Names!Y3:AB1000), but that cell is password protected so I can't change it myself
Alarielle wrote:The cell G3 for total number of scouts on the overview page sums the scouts, knights, guardians, AND rams columns on the names page. It should be =SUM(Names!Y3:Y1000) not =SUM(Names!Y3:AB1000), but that cell is password protected so I can't change it myself
Lol, select all cells, copy it, paste in another unprotected sheet and correct the cell.
Save the new sheet. If there's references to original sheet, correct it and copy necessited sheets too the same way...
;-P
-
- Lancer
- Posts: 12
- Joined: Fri Jan 04, 2013 6:58 am
I'll be honest (if you couldn't already tell): my overview page was a complete afterthought in building the sheet. However, the problem mentioned above has been fixed.
I have also created a public password for a few the of the tabs so you can all customize those as you wish. The password and the tabs it will access are in my original post.
PS: Quark, any chance I can have the Source Code which dictates the behavior of the Rams & Ballista in battle?
I have also created a public password for a few the of the tabs so you can all customize those as you wish. The password and the tabs it will access are in my original post.
PS: Quark, any chance I can have the Source Code which dictates the behavior of the Rams & Ballista in battle?
Matthew618 wrote:I'll be honest (if you couldn't already tell): my overview page was a complete afterthought in building the sheet. However, the problem mentioned above has been fixed.
I have also created a public password for a few the of the tabs so you can all customize those as you wish. The password and the tabs it will access are in my original post.
PS: Quark, any chance I can have the Source Code which dictates the behavior of the Rams & Ballista in battle?
Lool I wanna it too for my simulator!!!
-
- Lancer
- Posts: 1
- Joined: Mon Apr 22, 2013 2:46 pm
Thanks for sharing this workbook.
I cannot get the Attack Table to recognise World and Unit speed changes. The Land Time and Launch Time calculate travel time perfectly, with my current world speed and unit speed of 2, but the Attack Table refuses to even recognise I have changed the values at cells F1 and F2. Perhaps a macro is not being triggered?
I am using Excel 2010 SP1.
I cannot get the Attack Table to recognise World and Unit speed changes. The Land Time and Launch Time calculate travel time perfectly, with my current world speed and unit speed of 2, but the Attack Table refuses to even recognise I have changed the values at cells F1 and F2. Perhaps a macro is not being triggered?
I am using Excel 2010 SP1.
Who is online
Users browsing this forum: No registered users and 14 guests