DeletedUser4240
It is important to players like myself who do not purchase many city expansions that they get the most use out of every single cell in their cities. Using the Excel spreadsheet program I have created city models that allow me to find the best way or ways to rearrange existing buildings and create space for new ones. I am sure that without this remodeling tool I would have on occasion missed the ideal solution to a remodeling or repacking problem..
.
.
Excel in its entirety is a daunting application, but using it to make a model of your city is much simpler than you might think. The following instructions explain in detail how to do that. I warn you, however. that they were written to be simple and specific to the point of rudeness. By using them even someone who has never worked with Excel or any other spreadsheet program in his life should be able to turn out a fine model of his city in no time. (I have been told that these instructions will also basically work with certain freeware spreadsheet programs, but I cannot personally confirm that.)
.
Step 0: Start Excel.
.
Step 1: Create a file. On the menubar (the one with text on it) click on File and then New... When the New Workbook menu pops up, select Blank workbook and your workbook (file) will appear.
.
Step 2: Save the file. Click on File and then Save As... Choose an easily accessible folder such as MyDocuments and a name for this file. The file name will now appear at the top of the window.
.
Step 3: Name the master worksheet. On the menubar click on Format, then Sheet, then Rename. Type in the name of your city. It will now appear on the tab at the bottom of the window. This is your master worksheet. It should always exactly represent the current state of your city. The other worksheets are for experimenting with changes.
.
How to Copy the Master Worksheet to a Different Worksheet:
a. Select the entire master worksheet by pressing Ctrl+A or by clicking on the small, empty box just above row 1 and to the left of column A.
b. Press Ctrl+C (copy)
c. Activate the worksheet you wish to copy to by clicking on its tab at the bottom of the window.
d. Click on cell A1 and press Ctrl+V (paste). You want to use the source formatting, so ignore the little menu that pops up when you do the paste.
.
You can update the master worksheet by reversing the copy/paste procedure once the changes to your city are in place.
.
Step 4: Make the worksheet cells square. We do this by setting their row height and column width. You are free to experiment with different values for these settings, of course, but the ones I give here work pretty well for me.
.
a. With the master worksheet active select the entire worksheet (Ctrl+A).
b. Right click on the tab for the master worksheet at the bottom of the window and click on Select All Sheets.
c. On the menubar select Format, then Row, then Height...
d. In the box that pops up enter the value 17.5 and press OK.
e. Repeat steps a and b. Then select Format, Column, Width...
f. In the box that pops up enter the value 3 and press OK.
.
Since you will probably begin using another worksheet by first copying the master worksheet to it, part b is not very important. But it is kind of neat.
.
IMPORTANT NOTE: If you do not see one of the menu entries mentioned as being on a pulldown menu, click on the button with a double down-arrow at the bottom of the menu. This will fully expand the menu. (They like to hide things from you.)
.
Step 5: Delimit the city expansion slots. I think this is a good idea, but it is not essential. The dimensions of the cityspace are 40 by 40 city cells, which means its worksheet representation will cover rows 1 to 40 and columns A to AN. Expansions are 4x4 in size, so there will be 10 by 10 expansion slots.
.
a. Left-click on cell A4 to select it. Expand the window or scroll it if necessary until you can see cell AN4. Hold Shift and left-click this cell. You should see a row of 40 cells highlighted. This is your selection.
b. Right-click on the selection and choose Format Cells..., then click on the tab labelled Border.
c. To use this tool you must first pick a line style from the box at the right. Since we are basically doing underpainting here, I would recommend one of the light and unobtrusive broken line styles. Click on it to select it.
d. Around the large box that says "Text" you will see some smaller boxes. Click on the one on the left that shows a solid line at its bottom. The line style you picked should now appear along the bottom of the Text box. This means it will be used as the bottom border of each cell in the selection.
e. Click OK.
.
You should now see a line bordering the bottom of cells A4 to AN4. If you do not, you can go back to the Border tab and clear the Text box by clicking on the None box at the top of the dialog. Try again. Also...
.
IMPORTANT NOTE: Pressing Ctrl+Z will undo most of the actions you can take in Excel. This is usually the fastest way to correct a mistake when you make one. Always remember this time-saving tip.
.
f. With cells A4 to AN4 selected, press Ctrl+C.
g. Click on cell A8 and press Ctrl+V.
h. Click on cell A12 and press Ctrl+V again. Continue copying the borders until you reach cell A40.
i. Since row 40 is the edge of the cityspace, you may wish to mark it with one of the heavier borders. You simply need to select cells A40 to AN40 and repeat the procedure in the Border tab using a different border.
.
We will basically be repeating steps a to i now to create the vertical delimiters. The differences are these:
.
j. Select cells D1 to D40. (Remember to hold down Shift when you select D40.)
k. In the Border tab use the same line style you used before, but click the box below and to the right of the Text box, so that your line style appears along its right edge. DO NOT TOUCH any of the other indications within the Text box.
l. If you did not mess up, click OK. Otherwise, close the dialog and start over.
m. Copy the selection using cells H1, L1, P1, T1, etc. as targets. If you do not arrive at column AN you made a mistake; use Ctrl+Z to back out.
n. Put the same border on column AN that you used for row 40.
.
For the rest of these instructions we will be using three tools: Merge and Center, Borders, and Fill Color. Try to locate them on the toolbar (the one with all the little icons on it). Hover over a tool to read its title. If you cannot find a tool, it might not be there. Click on the dark icon with the down arrow named Toolbar Options. Select Add or Remove Buttons and then Formatting. Make sure all three tools have check marks in front of them.
.
GOOD TIP: Remember to make your selection before you click on a tool. It is that simple and can save a lot of "why didn't that work" confusion. Select, then apply.
.
Step 6: Create a basic structure. The hardest part of this step may be establishing where exactly to put the very first structure on your worksheet. Placing additional structures is much easier than placing the first structure because you can relate their location to the locations of other nearby structures. But to place the first structure you must determine its city coordinates.
.
How to Determine the City Coordinates of a Structure: To do this you need to turn on the city grid. And, of course, there is no control for that ... However, it is possible to see the grid by bringing up the road-building dialog and clicking on Build.
.
There is only one natural way to associate the cells that you see on the city grid with the cells of your worksheet model. The physically uppermost cell of the city grid, way at the top of the screen, will be represented by worksheet cell A1. Counting along the "top" row of the city grid (which runs from Northwest to Southeast and contains the A1 cell) corresponds to counting along row 1 on the worksheet. And counting "down" a column (meaning to the Southwest) on the city grid corresponds to counting down a worksheet column. It should be clear then that worksheet coordinates are identical to city coordinates. For example, city coordinates (12,4) will correspond to L4 on the worksheet.
.
a. Using the road tile graphic as a cursor, determine the city coordinates of the upper-leftmost cell of the structure you want to place on the worksheet. (If you have a structure that borders either the "top" or the "left" edge of the cityspace, it is a good choice for first placement.)
b. On the worksheet place the mouse cursor at the determined coordinates and, holding down the left mouse button, drag the mouse diagonally to select a rectangle the size and shape of the structure.
c. With the selection still active click on the Merge and Center tool. (This is a toggle.) You now have a basic structure.
.
How to Move A Structure: With the structure selected place the cursor on one of its edges. You will see it change to a four-directional arrow. Hold down the left mouse button and you can drag the structure to a new location -- unless its new location would overlap its original location. In that case you must first drag the structure a distance away and then drag it back again. Weird, but true. (You will get a cross-shaped cursor if you hover the mouse on the lower right corner of the structure. This is used for doing things you do not want to do. It is easy to get this cursor when you go to move a 1x1 decoration, so watch it.)
.
How to Delete A Structure: The fastest way to do this is to drag the structure right past column AN, right click on it, select Delete..., and then pick Shift cells left. Gone in a jiffy.
.
Now it is time to finish the structure.
.
Step 7: Put a border around the structure. With the structure selected click the down arrow on the Borders tool and select the style named Outside Borders. (This is not required, but I think it improves the appearance of the map.)
.
If you simply click on the Borders tool, it will apply the style that it shows on its face. To remove all borders use the No Borders style. Notice the Thick Box border style? I think it looks great on Great Buildings.
.
Step 8: Label the structure.
a. With the structure selected right click and pick Format Cells..., then click on the Alignment tab. For Text alignment Vertical: choose Center and then put a check in the Wrap text box. All structures should have these settings.
b. Now type in a text label for the structure. I use the Arial type style (which I think is the default). It is a neat and clean sanserif style.
.
Notes: Remember to select the entire worksheet before you go changing type styles! The type size that looks best generally depends on the size of the structure and the size of the label. For 2x2 residential buildings I use 9 point. Labels like "estate", "arcade", "country", "gambrel" fit nicely at this size. (Be sure to enter apartment as "apart ment". That is why you have wrap on.) For bigger structures you can go up to 12 point -- or more. For 1x1's you must use 8 point. With this type size you can sometimes fit four characters into a 1x1 label -- e.g. "tree", "sign" (signpost), "lant" (lantern), or "fntn" (fountain). But "bush" will not fit.
.
Step 9: Add color. With the structure selected click the down arrow on the Fill Color tool and pick the color you want to use as the background color of the structure. If you simply click on this tool, you will apply the color it shows on its face. To remove color choose the No Fill style.
.
Color is obviously a matter of personal preference, but since I am being so explicit in these instructions, I will share my largely arbitrary color scheme with you. (It is hard to pick a color for the Wishing Well.)
.
White ------------ Residential Buildings. White is the color you first get when you use Merge and Center. I use it for residences, likely the majority of your city's buildings. I also use white for any building that pays out coin only, for instance, the King and City Hall.
Pale Blue -------- Production Buildings
Rose ------------- Goods Manufactories
Lavender -------- Cultural Buildings
Tan -------------- Military Buildings
Light Green ----- Floral Decorations. Here I decided that because there are so many tiny decorations, it would be helpful to distinguish the botanical kind from the non-botanical kind. Light greens include trees, bushes, hedges, plants in pots and plants in tubs: anything as long as it is a plant.
.
Lime Green ----- Other Decorations: statuary, signs, street lamps, pillars, flags, kites, fountains, ponds, etc.
Light Yellow ----- Great Buildings!
Gray - 25% ----- Roads. Road are not considered to be structures, so you only need to color a road cell to be done with it; they have no borders or labels. (I do not try to distinguish types of pavement because it is chiefly the city geometry that concerns me, but I suppose one could try using patterns to do that.)
.
Copy Structures and Save Time: After you have finished creating a structure you can save work by copying it over to a new location using Ctrl+C and Ctrl+V. Changing the label or the color of a structure is very easy, so you really only need to create one house, for example, and then copy it over and over.
.
Have fun making your city model!
.
.
Excel in its entirety is a daunting application, but using it to make a model of your city is much simpler than you might think. The following instructions explain in detail how to do that. I warn you, however. that they were written to be simple and specific to the point of rudeness. By using them even someone who has never worked with Excel or any other spreadsheet program in his life should be able to turn out a fine model of his city in no time. (I have been told that these instructions will also basically work with certain freeware spreadsheet programs, but I cannot personally confirm that.)
.
Step 0: Start Excel.
.
Step 1: Create a file. On the menubar (the one with text on it) click on File and then New... When the New Workbook menu pops up, select Blank workbook and your workbook (file) will appear.
.
Step 2: Save the file. Click on File and then Save As... Choose an easily accessible folder such as MyDocuments and a name for this file. The file name will now appear at the top of the window.
.
Step 3: Name the master worksheet. On the menubar click on Format, then Sheet, then Rename. Type in the name of your city. It will now appear on the tab at the bottom of the window. This is your master worksheet. It should always exactly represent the current state of your city. The other worksheets are for experimenting with changes.
.
How to Copy the Master Worksheet to a Different Worksheet:
a. Select the entire master worksheet by pressing Ctrl+A or by clicking on the small, empty box just above row 1 and to the left of column A.
b. Press Ctrl+C (copy)
c. Activate the worksheet you wish to copy to by clicking on its tab at the bottom of the window.
d. Click on cell A1 and press Ctrl+V (paste). You want to use the source formatting, so ignore the little menu that pops up when you do the paste.
.
You can update the master worksheet by reversing the copy/paste procedure once the changes to your city are in place.
.
Step 4: Make the worksheet cells square. We do this by setting their row height and column width. You are free to experiment with different values for these settings, of course, but the ones I give here work pretty well for me.
.
a. With the master worksheet active select the entire worksheet (Ctrl+A).
b. Right click on the tab for the master worksheet at the bottom of the window and click on Select All Sheets.
c. On the menubar select Format, then Row, then Height...
d. In the box that pops up enter the value 17.5 and press OK.
e. Repeat steps a and b. Then select Format, Column, Width...
f. In the box that pops up enter the value 3 and press OK.
.
Since you will probably begin using another worksheet by first copying the master worksheet to it, part b is not very important. But it is kind of neat.
.
IMPORTANT NOTE: If you do not see one of the menu entries mentioned as being on a pulldown menu, click on the button with a double down-arrow at the bottom of the menu. This will fully expand the menu. (They like to hide things from you.)
.
Step 5: Delimit the city expansion slots. I think this is a good idea, but it is not essential. The dimensions of the cityspace are 40 by 40 city cells, which means its worksheet representation will cover rows 1 to 40 and columns A to AN. Expansions are 4x4 in size, so there will be 10 by 10 expansion slots.
.
a. Left-click on cell A4 to select it. Expand the window or scroll it if necessary until you can see cell AN4. Hold Shift and left-click this cell. You should see a row of 40 cells highlighted. This is your selection.
b. Right-click on the selection and choose Format Cells..., then click on the tab labelled Border.
c. To use this tool you must first pick a line style from the box at the right. Since we are basically doing underpainting here, I would recommend one of the light and unobtrusive broken line styles. Click on it to select it.
d. Around the large box that says "Text" you will see some smaller boxes. Click on the one on the left that shows a solid line at its bottom. The line style you picked should now appear along the bottom of the Text box. This means it will be used as the bottom border of each cell in the selection.
e. Click OK.
.
You should now see a line bordering the bottom of cells A4 to AN4. If you do not, you can go back to the Border tab and clear the Text box by clicking on the None box at the top of the dialog. Try again. Also...
.
IMPORTANT NOTE: Pressing Ctrl+Z will undo most of the actions you can take in Excel. This is usually the fastest way to correct a mistake when you make one. Always remember this time-saving tip.
.
f. With cells A4 to AN4 selected, press Ctrl+C.
g. Click on cell A8 and press Ctrl+V.
h. Click on cell A12 and press Ctrl+V again. Continue copying the borders until you reach cell A40.
i. Since row 40 is the edge of the cityspace, you may wish to mark it with one of the heavier borders. You simply need to select cells A40 to AN40 and repeat the procedure in the Border tab using a different border.
.
We will basically be repeating steps a to i now to create the vertical delimiters. The differences are these:
.
j. Select cells D1 to D40. (Remember to hold down Shift when you select D40.)
k. In the Border tab use the same line style you used before, but click the box below and to the right of the Text box, so that your line style appears along its right edge. DO NOT TOUCH any of the other indications within the Text box.
l. If you did not mess up, click OK. Otherwise, close the dialog and start over.
m. Copy the selection using cells H1, L1, P1, T1, etc. as targets. If you do not arrive at column AN you made a mistake; use Ctrl+Z to back out.
n. Put the same border on column AN that you used for row 40.
.
For the rest of these instructions we will be using three tools: Merge and Center, Borders, and Fill Color. Try to locate them on the toolbar (the one with all the little icons on it). Hover over a tool to read its title. If you cannot find a tool, it might not be there. Click on the dark icon with the down arrow named Toolbar Options. Select Add or Remove Buttons and then Formatting. Make sure all three tools have check marks in front of them.
.
GOOD TIP: Remember to make your selection before you click on a tool. It is that simple and can save a lot of "why didn't that work" confusion. Select, then apply.
.
Step 6: Create a basic structure. The hardest part of this step may be establishing where exactly to put the very first structure on your worksheet. Placing additional structures is much easier than placing the first structure because you can relate their location to the locations of other nearby structures. But to place the first structure you must determine its city coordinates.
.
How to Determine the City Coordinates of a Structure: To do this you need to turn on the city grid. And, of course, there is no control for that ... However, it is possible to see the grid by bringing up the road-building dialog and clicking on Build.
.
There is only one natural way to associate the cells that you see on the city grid with the cells of your worksheet model. The physically uppermost cell of the city grid, way at the top of the screen, will be represented by worksheet cell A1. Counting along the "top" row of the city grid (which runs from Northwest to Southeast and contains the A1 cell) corresponds to counting along row 1 on the worksheet. And counting "down" a column (meaning to the Southwest) on the city grid corresponds to counting down a worksheet column. It should be clear then that worksheet coordinates are identical to city coordinates. For example, city coordinates (12,4) will correspond to L4 on the worksheet.
.
a. Using the road tile graphic as a cursor, determine the city coordinates of the upper-leftmost cell of the structure you want to place on the worksheet. (If you have a structure that borders either the "top" or the "left" edge of the cityspace, it is a good choice for first placement.)
b. On the worksheet place the mouse cursor at the determined coordinates and, holding down the left mouse button, drag the mouse diagonally to select a rectangle the size and shape of the structure.
c. With the selection still active click on the Merge and Center tool. (This is a toggle.) You now have a basic structure.
.
How to Move A Structure: With the structure selected place the cursor on one of its edges. You will see it change to a four-directional arrow. Hold down the left mouse button and you can drag the structure to a new location -- unless its new location would overlap its original location. In that case you must first drag the structure a distance away and then drag it back again. Weird, but true. (You will get a cross-shaped cursor if you hover the mouse on the lower right corner of the structure. This is used for doing things you do not want to do. It is easy to get this cursor when you go to move a 1x1 decoration, so watch it.)
.
How to Delete A Structure: The fastest way to do this is to drag the structure right past column AN, right click on it, select Delete..., and then pick Shift cells left. Gone in a jiffy.
.
Now it is time to finish the structure.
.
Step 7: Put a border around the structure. With the structure selected click the down arrow on the Borders tool and select the style named Outside Borders. (This is not required, but I think it improves the appearance of the map.)
.
If you simply click on the Borders tool, it will apply the style that it shows on its face. To remove all borders use the No Borders style. Notice the Thick Box border style? I think it looks great on Great Buildings.
.
Step 8: Label the structure.
a. With the structure selected right click and pick Format Cells..., then click on the Alignment tab. For Text alignment Vertical: choose Center and then put a check in the Wrap text box. All structures should have these settings.
b. Now type in a text label for the structure. I use the Arial type style (which I think is the default). It is a neat and clean sanserif style.
.
Notes: Remember to select the entire worksheet before you go changing type styles! The type size that looks best generally depends on the size of the structure and the size of the label. For 2x2 residential buildings I use 9 point. Labels like "estate", "arcade", "country", "gambrel" fit nicely at this size. (Be sure to enter apartment as "apart ment". That is why you have wrap on.) For bigger structures you can go up to 12 point -- or more. For 1x1's you must use 8 point. With this type size you can sometimes fit four characters into a 1x1 label -- e.g. "tree", "sign" (signpost), "lant" (lantern), or "fntn" (fountain). But "bush" will not fit.
.
Step 9: Add color. With the structure selected click the down arrow on the Fill Color tool and pick the color you want to use as the background color of the structure. If you simply click on this tool, you will apply the color it shows on its face. To remove color choose the No Fill style.
.
Color is obviously a matter of personal preference, but since I am being so explicit in these instructions, I will share my largely arbitrary color scheme with you. (It is hard to pick a color for the Wishing Well.)
.
White ------------ Residential Buildings. White is the color you first get when you use Merge and Center. I use it for residences, likely the majority of your city's buildings. I also use white for any building that pays out coin only, for instance, the King and City Hall.
Pale Blue -------- Production Buildings
Rose ------------- Goods Manufactories
Lavender -------- Cultural Buildings
Tan -------------- Military Buildings
Light Green ----- Floral Decorations. Here I decided that because there are so many tiny decorations, it would be helpful to distinguish the botanical kind from the non-botanical kind. Light greens include trees, bushes, hedges, plants in pots and plants in tubs: anything as long as it is a plant.
.
Lime Green ----- Other Decorations: statuary, signs, street lamps, pillars, flags, kites, fountains, ponds, etc.
Light Yellow ----- Great Buildings!
Gray - 25% ----- Roads. Road are not considered to be structures, so you only need to color a road cell to be done with it; they have no borders or labels. (I do not try to distinguish types of pavement because it is chiefly the city geometry that concerns me, but I suppose one could try using patterns to do that.)
.
Copy Structures and Save Time: After you have finished creating a structure you can save work by copying it over to a new location using Ctrl+C and Ctrl+V. Changing the label or the color of a structure is very easy, so you really only need to create one house, for example, and then copy it over and over.
.
Have fun making your city model!
Last edited by a moderator: