Post by blackgoat on May 11, 2009 22:50:17 GMT 12
Ok so here is the link to the spreadsheet, I could not see way to upload it in this forum, so it is an external link:
www.4shared.com/file/104668863/6a3c0996/Lords2Share.html
spread sheet basics. The blue fields are for you to fill in based on the data for yourself or in the case of the Palace Size Calculation for that individual you are looking at. The yellow fields are the final answers.
3 Tabs at bottom: Score, AttackDefence and PalaceSizeCalc
Score is just what it says it is your score based of the 4 variables that compose it. I use this both to track how successful of a week I have had or to see what buy a tech or palace size will leave my score at. Fun side note is that towards the bottom there is a field that says average TE per day, Cell C7 will need updated with the correct lords day that is not so much automated. Please note that there is round off error for the calculated score as the game is written using binary math, this is why I have left 2 decimal places showing.
AttackDefence tab: I find that this one is useful in maximizing either, you can sit there and ask if I buy so many of this type of unit what will it do to my Attack or defence or if I bought these other units what would it do with out actually having to pay for the units. This sheet does make the assumption that you maintain 100% barracks bonus. Also the Technological advantage bonus is white not blue it calc itself off of the score page techs purchased number entered. The T/E is also white and not blue as it pulls it’s figures from the score page as well.
Palace Size Calc Tab that caught your interest. This is the touchiest tab of them all. This is meant to be used around the time of the tick of an hour. Cell E1 takes what gold they were showing prior to the tick. Cell E2 takes what they are showing after the tick. Cell E3 is just the number of population that they have. E4 is where the fun begins. If you are quote unquote sitting on the player as the tick happens you can see when there gold shoots up and then back down a bit if they have the Jeweler tech and his apprentice. If you think that they have both enter a 2 if you think that they have only the 1 then a 1, or if they have not bought either then a 0. Now for Cell E5 this is a bit tricky. Based on the standard techs this should usually be 7, but if some one has not purchased all gold generating techs or chose the economy specialization they could up this to 9. Please note that again like in the score there is a pinch of round off error but just a pinch. Again I have left several decimal places on the final guess at palace size. If you are not very, and I do mean very(within 1% of a whole number you have likely guessed wrong at the jeweler or tax rate question. The pinkish cell should be a low number, this is another double check that you are not too far off. The data currently displaying on this page is for our faction leader Jantar. I have not PM’ed him to confirm but I am within 1% of a whole number and the 4 in the pink cell is low so I think that it is right.
Have fun and enjoy. I am working on additional sheets for the cost of palaces and techs but only just started and am kicking myself for not recording what each tech I bought this round cost. Sorry to be long winded but as these sheets are not 100% user friendly I thought that the full tour was required.
I know that this is a lot and not all of it is straight forward so ask if you have questions
www.4shared.com/file/104668863/6a3c0996/Lords2Share.html
spread sheet basics. The blue fields are for you to fill in based on the data for yourself or in the case of the Palace Size Calculation for that individual you are looking at. The yellow fields are the final answers.
3 Tabs at bottom: Score, AttackDefence and PalaceSizeCalc
Score is just what it says it is your score based of the 4 variables that compose it. I use this both to track how successful of a week I have had or to see what buy a tech or palace size will leave my score at. Fun side note is that towards the bottom there is a field that says average TE per day, Cell C7 will need updated with the correct lords day that is not so much automated. Please note that there is round off error for the calculated score as the game is written using binary math, this is why I have left 2 decimal places showing.
AttackDefence tab: I find that this one is useful in maximizing either, you can sit there and ask if I buy so many of this type of unit what will it do to my Attack or defence or if I bought these other units what would it do with out actually having to pay for the units. This sheet does make the assumption that you maintain 100% barracks bonus. Also the Technological advantage bonus is white not blue it calc itself off of the score page techs purchased number entered. The T/E is also white and not blue as it pulls it’s figures from the score page as well.
Palace Size Calc Tab that caught your interest. This is the touchiest tab of them all. This is meant to be used around the time of the tick of an hour. Cell E1 takes what gold they were showing prior to the tick. Cell E2 takes what they are showing after the tick. Cell E3 is just the number of population that they have. E4 is where the fun begins. If you are quote unquote sitting on the player as the tick happens you can see when there gold shoots up and then back down a bit if they have the Jeweler tech and his apprentice. If you think that they have both enter a 2 if you think that they have only the 1 then a 1, or if they have not bought either then a 0. Now for Cell E5 this is a bit tricky. Based on the standard techs this should usually be 7, but if some one has not purchased all gold generating techs or chose the economy specialization they could up this to 9. Please note that again like in the score there is a pinch of round off error but just a pinch. Again I have left several decimal places on the final guess at palace size. If you are not very, and I do mean very(within 1% of a whole number you have likely guessed wrong at the jeweler or tax rate question. The pinkish cell should be a low number, this is another double check that you are not too far off. The data currently displaying on this page is for our faction leader Jantar. I have not PM’ed him to confirm but I am within 1% of a whole number and the 4 in the pink cell is low so I think that it is right.
Have fun and enjoy. I am working on additional sheets for the cost of palaces and techs but only just started and am kicking myself for not recording what each tech I bought this round cost. Sorry to be long winded but as these sheets are not 100% user friendly I thought that the full tour was required.
I know that this is a lot and not all of it is straight forward so ask if you have questions