Politician Archive

Here is a simple tool I made for my PA to build City plans. This is made in Excel. http://houselymbo.insane-asylum.dk/files/cityplanner.xls. (Currently it needs some work. So any feedback would be really welcomed! (spelling mistakes, error in the data, possible and easy improvements). I'll post some more detailed information below).

Here is a small explanation.

There are 4 tabs at the bottom.
City planning - This is just a template of the City. Here you can actually plan a City. Each Circle represents the area that you can build in at each rank (The smallest circle is the outpost and the largest circle is the Rank 5 cities and the most you'll ever be able to build in). You cna copy "buildings" from the second "city stuff" tab.

Each Cell in Excel is a 1x1 grid (a small harvester i think is that size). These are the grid squares that you can see when you place a building (from the top down). 1x1 represents 8x8 metres in game. (A cell is 15x15 pixels large)

Zoom in and out to see more detail or see your whole city in one go.

City Stuff - This contains lots of boxes with writing in them. These are the buildings to scale. For example a medium tatooine house is 5x5. This means it takes up 5x5 cells on the city Planning grid. You can copy these buildings from the second sheet to the first city planning sheet. They will be to scale so if you place a tatooine house next to a Naboo PA Hall, then that is what a top-down view should look like off your city. If you copy lots of houses and buildings across, you should be able to accurately construct a city!

City rulers - I made this before I put in the Circles showing the actual amount of land you can have (before it was just squares on the first sheet). Basically each circle is the Radius of a city at a certain rank. You could measure from the center to the edge to see if a particular building can fit. Still useful. (Copy and paste into the main sheet again).

Information - Calculations and information I used to work out how much land each block will be in terms of Metres.

Note this is not ENTIRELY Accurate. Some information may be wrong (due to disagreements on the forums). And when the radius of a level 1 city was 18.75 blocks. I started getting confused. The O might not be the exact center of some Radius and I don't know where the O is measured from. (The center of a City is the City hall BUT A city hall is 8x8. where on that City hall counts as the center of the city? I have no idea.

If you know how to use the drawing tools in Excel or Word you should be able to use this.

[url]http://houselymbo.insane-asylum.dk/files/cityplanner.xls[/url]

Looks very useful - we are still handdrawing our city layouts!

Thanks a lot for posting this

Alot of work, nicely down! I've been taking screen shots and making a collage I edit in a paint program. This should be alot easier!

Question, does the size include empty space between buildigns? In most cases we have buildings as close to each other as possible. They are tatooine style homes and have pretty good sized gaps between them.

The size is the footprint of the building, independent of what space the building actually takes within that footprint. (Well, it doesn't have the small naboo style 2 footprint, but besides that) Therefore it represents the closest you can place a structure near it.

If you have any problems or comments PLEASE send them to me

As I said, I haven't been able to get into the game recently, and go all my information from a particular website that only showed the overall plot thing for a small selection of houses.

[email protected] is my e-mail address if you want to e-mail corrections.

Kade Deveron, Yes I think they do include the space between each building. I think you can put houses right next to each other and it doesn't matter

Can anyone confirm this?

Secondly Some buildings are irregular shapes. And all the buildings are just blocks. Does anyone have any suggestions on how to improve this. Or can anyone submit somewhere an updated version of this. Like I said you can change the thing in any way except the credits section.

this is awesome

Very nice.

nice

Hmmmmm no one able to improve on it in anyway?

Have any of you been able to use the tool?

Do you think you could send me some of your finished cities out of interest and see whether they worked or not

Well not an improvement but I'm making my own that graphically depicts the structures and will have a web interface, as well as the option to display or hide footprints. (IE hide for the public map but display for planning) I've got the Naboo/Generic structures finished (Not installations though and not faction related stuff) and am working on the web backend now.