We do this by setting their row height and column width. You can update the master worksheet by reversing the copy/paste procedure once the changes to your city are in place. You want to use the source formatting, so ignore the little menu that pops up when you do the paste. Click on cell A1 and press Ctrl+V (paste). Activate the worksheet you wish to copy to by clicking on its tab at the bottom of the window.ĭ. 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.Ĭ. How to Copy the Master Worksheet to a Different Worksheet:Ī. The other worksheets are for experimenting with changes. It should always exactly represent the current state of your city. It will now appear on the tab at the bottom of the window. On the menubar click on Format, then Sheet, then Rename. The file name will now appear at the top of the window. Choose an easily accessible folder such as MyDocuments and a name for this file. When the New Workbook menu pops up, select Blank workbook and your workbook (file) will appear. On the menubar (the one with text on it) click on File and then New. (I have been told that these instructions will also basically work with certain freeware spreadsheet programs, but I cannot personally confirm that.) 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. that they were written to be simple and specific to the point of rudeness. The following instructions explain in detail how to do that. I am sure that without this remodeling tool I would have on occasion missed the ideal solution to a remodeling or repacking problem.Įxcel in its entirety is a daunting application, but using it to make a model of your city is much simpler than you might think. 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. Either the initial plot of land was cleaner or I got better.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. Voila, success!īelieve it or not, this was the only time I had to use these items as a rearranging aid for Feudal Japan. Finally came the fourth step, The board (which was a rather small antique one dating back to the Great War) was brought to where I sit and play FoE so I could do the board's arrangement on the game screen. For the third thing to do, I just kept rearranging the pieces until I was happy. Now I could do a layout with dominoes delineating a building, pawns showing where roads would go and larger chess pieces representing the obstacles on the ground. It turns out the initial plot of land is 8x8, which is the same size as a board for checkers or chess! For the second thing to do, I broke out the board and chess pieces, then added in dominoes. What did I do to figure out how to use the space to the max? The first thing was to ascertain how many tiles were present. When I first did the Feudal Japan settlement, the obstacles on the ground were high in number for the size of area.
0 Comments
Leave a Reply. |