Have you been annoyed, like me, because that Luxury Palace keeps devolving for lack of desirability?
Many times to me. I was wondering how to measure desirability to find out which is the best tile of that palace to make an improvement on it maybe adding a garden or a statue near by. My first action was to jump to that wonderful Excel file provided by Philonhere.
Once you create the macro as per Philon's instructions it is a matter to know where to paste (ctrl-D) each desirability mapping into your layout. When you have four or three houses and two or three non-house structures to copy/paste it is not so difficult.
If you want to calculate desirability for your entire loop then you may be dealing with about 40 houses and so 20 service buildings and that would be a very hard task to do it with Philon's spreadsheet. Every time you want to ctrl-D a desirabiity mapping you better save first because each paste can't be undone.
In the meantime, I am still watching that stupid palace devolving for lack of desirability...duh!
What if somehow I design my next loop but before I fire C3 I were able to calculate the entire loop desirability on each and every tile? Humn...that would be nice.
Welcome to C3 Desirability Calculator
It took me a couple of days in my free time to think about a solution. My first question was how to provide my layout as input to my application. Succendly the bulb was on:Housing Block Generator.
That is it. Take that bunch of letters/symbols as seen in the glyply main window and feed them to my application.
Next question was about the output. Again, same idea as with glyphy, an html file which is easy to see in any web browser. Nowadays almost every body has access to a browser.
I am going to use as a demo one of the loops created by Brugle in his wonderfulHappy Massilia, the loop to the far left near the fighting when you load the saved game. I hope Brugle doesn't mind using his loop for this demo .
Here is the representation for the glyphy if you want to use in the glyphy (it is almost 100% accurate as seen in the saved game, I like oracles a lot):
Once this design is processed by the glyphy the loop looks like:
Legend
Now, let's feed the same input to my application and see what output would come out:
(There are some important colors missing above which are defined in my stylesheet css that would make more sense once I explain some details later.)
That is what I want to see, each and every tile of the loop with the desirability effects from each of the houses and buildings in the loop. As a loop designer, I would observe the blue areas where my houses are located to ping point where the critical areas for evolving are located and make improvement accordingly.
Once the application is uploaded and approved to be displayed in theUtilities Programs I would clarify its usage not explained so far.
Just uploaded. Waiting for approval.
Many times to me. I was wondering how to measure desirability to find out which is the best tile of that palace to make an improvement on it maybe adding a garden or a statue near by. My first action was to jump to that wonderful Excel file provided by Philon
Once you create the macro as per Philon's instructions it is a matter to know where to paste (ctrl-D) each desirability mapping into your layout. When you have four or three houses and two or three non-house structures to copy/paste it is not so difficult.
If you want to calculate desirability for your entire loop then you may be dealing with about 40 houses and so 20 service buildings and that would be a very hard task to do it with Philon's spreadsheet. Every time you want to ctrl-D a desirabiity mapping you better save first because each paste can't be undone.
In the meantime, I am still watching that stupid palace devolving for lack of desirability...duh!
What if somehow I design my next loop but before I fire C3 I were able to calculate the entire loop desirability on each and every tile? Humn...that would be nice.
It took me a couple of days in my free time to think about a solution. My first question was how to provide my layout as input to my application. Succendly the bulb was on:
That is it. Take that bunch of letters/symbols as seen in the glyply main window and feed them to my application.
Next question was about the output. Again, same idea as with glyphy, an html file which is easy to see in any web browser. Nowadays almost every body has access to a browser.
I am going to use as a demo one of the loops created by Brugle in his wonderful
Here is the representation for the glyphy if you want to use in the glyphy (it is almost 100% accurate as seen in the saved game, I like oracles a lot):
#########################
#HHHHHHHHHHHHHHHHG#
#HHHHHHHHHHHHHHHHG#
##HH##########HH@@#
##HH#HHHHHHHH#HH@@#
#HHD#HHHHHHHH#HHHH#
#HHF#HHGGGHHF#HHHH#
#GHH#HH!!!HHG##HHG#
#GHH#SS!!!HHHH#HHG#
#GHH#SS!!!HHHH#EHH#
#GHH#HHHH!!!HH#PHH#
#GHH#HHHH!!!HH#bbG#
#GHH##HHG!!!ff#bbG#
#HHHH#HHG!!!ff#SSG#
#HHHH#BHH!!!MM#SSG#
#@@HH#FHH!!!MM#00G#
#@@HH#HHMMMMMM#00G#
#@@HH#HHMMMMMM#xxG#
#@@HH##########xxG#
#GHHHHHHLLHH((XXXG#
#GHHHHHHLLHH((XXXG#
##############XXX##
Once this design is processed by the glyphy the loop looks like:
Now, let's feed the same input to my application and see what output would come out:
12 | 16 | 16 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 18 | 18 | 19 | 19 | 21 | 23 | 28 | 30 | 30 | 29 | 25 | 19 | 18 | 16 | 6 | 6 | 2 | 0 |
18 | 26 | 26 | 22 | 22 | 24 | 26 | 26 | 26 | 26 | 32 | 32 | 31 | 29 | 30 | 30 | 36 | 37 | 36 | 38 | 31 | 23 | 22 | 20 | 10 | 6 | 2 | 0 |
22 | 28 | 38 | 32 | 32 | 36 | 38 | 36 | 36 | 36 | 42 | 44 | 43 | 39 | 38 | 26 | 32 | 35 | 34 | 36 | 27 | 17 | 16 | 14 | 6 | 4 | 2 | 0 |
20 | 20 | 34 | 28 | 25 | 30 | 31 | 27 | 27 | 27 | 33 | 36 | 36 | 31 | 32 | 18 | 15 | 21 | 25 | 28 | 19 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
21 | 21 | 37 | 33 | 30 | 39 | 39 | 34 | 34 | 35 | 40 | 44 | 45 | 36 | 38 | 21 | 14 | 20 | 24 | 28 | 20 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
21 | 25 | 39 | 37 | 41 | 49 | 48 | 42 | 43 | 43 | 48 | 53 | 56 | 49 | 53 | 35 | 34 | 28 | 24 | 28 | 20 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
20 | 24 | 38 | 34 | 37 | 44 | 41 | 30 | 31 | 32 | 40 | 46 | 53 | 50 | 54 | 39 | 37 | 29 | 25 | 28 | 19 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
21 | 22 | 39 | 34 | 37 | 43 | 40 | 18 | 20 | 21 | 40 | 45 | 49 | 51 | 50 | 41 | 40 | 27 | 26 | 28 | 20 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
24 | 25 | 42 | 36 | 48 | 55 | 54 | 31 | 32 | 34 | 54 | 58 | 66 | 70 | 64 | 57 | 56 | 31 | 31 | 33 | 21 | 7 | 6 | 6 | 0 | 0 | 0 | 0 |
32 | 33 | 50 | 44 | 55 | 63 | 61 | 36 | 37 | 35 | 56 | 58 | 65 | 70 | 65 | 61 | 59 | 36 | 33 | 36 | 23 | 8 | 8 | 6 | 0 | 0 | 0 | 0 |
32 | 33 | 53 | 49 | 62 | 68 | 69 | 60 | 58 | 42 | 51 | 51 | 72 | 78 | 75 | 74 | 66 | 43 | 37 | 40 | 24 | 8 | 8 | 6 | 0 | 0 | 0 | 0 |
37 | 38 | 56 | 53 | 70 | 76 | 78 | 70 | 65 | 41 | 43 | 43 | 64 | 69 | 64 | 58 | 54 | 34 | 31 | 35 | 19 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
34 | 35 | 51 | 50 | 70 | 71 | 78 | 71 | 60 | 37 | 37 | 37 | 57 | 62 | 61 | 56 | 55 | 34 | 33 | 36 | 19 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
33 | 37 | 48 | 48 | 75 | 72 | 81 | 72 | 58 | 34 | 34 | 33 | 53 | 61 | 61 | 65 | 64 | 38 | 36 | 38 | 20 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
30 | 34 | 43 | 42 | 70 | 68 | 76 | 70 | 56 | 29 | 29 | 28 | 54 | 62 | 60 | 64 | 64 | 38 | 37 | 39 | 21 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
29 | 25 | 22 | 29 | 59 | 57 | 66 | 56 | 42 | 14 | 16 | 16 | 42 | 51 | 50 | 59 | 59 | 39 | 38 | 40 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
29 | 25 | 22 | 29 | 61 | 60 | 70 | 62 | 53 | 37 | 36 | 38 | 46 | 52 | 51 | 58 | 59 | 41 | 38 | 40 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
31 | 27 | 24 | 29 | 59 | 56 | 69 | 63 | 56 | 41 | 39 | 41 | 48 | 53 | 50 | 56 | 60 | 42 | 39 | 39 | 21 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
33 | 29 | 26 | 28 | 45 | 42 | 51 | 46 | 39 | 24 | 23 | 23 | 28 | 32 | 36 | 43 | 48 | 42 | 38 | 38 | 20 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
37 | 40 | 42 | 35 | 50 | 52 | 61 | 59 | 50 | 37 | 40 | 40 | 45 | 43 | 36 | 39 | 44 | 41 | 37 | 38 | 19 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
37 | 42 | 46 | 39 | 52 | 50 | 58 | 56 | 51 | 38 | 42 | 42 | 44 | 40 | 30 | 32 | 39 | 38 | 34 | 34 | 16 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
30 | 34 | 37 | 31 | 32 | 30 | 36 | 35 | 34 | 22 | 22 | 21 | 19 | 15 | 14 | 16 | 22 | 29 | 26 | 27 | 12 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
28 | 32 | 37 | 34 | 37 | 35 | 39 | 37 | 37 | 25 | 25 | 26 | 24 | 20 | 17 | 17 | 19 | 24 | 20 | 18 | 9 | 2 | 2 | 0 | 0 | 0 | 0 | 0 |
13 | 15 | 20 | 20 | 24 | 24 | 27 | 27 | 27 | 19 | 20 | 21 | 20 | 17 | 15 | 15 | 12 | 14 | 11 | 10 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 1 | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
(There are some important colors missing above which are defined in my stylesheet css that would make more sense once I explain some details later.)
That is what I want to see, each and every tile of the loop with the desirability effects from each of the houses and buildings in the loop. As a loop designer, I would observe the blue areas where my houses are located to ping point where the critical areas for evolving are located and make improvement accordingly.
Once the application is uploaded and approved to be displayed in the
Just uploaded. Waiting for approval.
[This message has been edited by guane2009 (edited 03-19-2018 @ 08:44 PM).]