Kolyanas Building Guide in Excel Format

[Sharr 6]

I really appreciated Kolyana''s effort in putting together that building guide. But it''s hard for me to use in web page format, so I put it into Excel. I get the feeling that I''m not the only one who would appreciate a slightly quicker way to sort through the info, so I''m putting it up here.

I have the Building Data on the first tab, Demand Info on a second tab, and a third tab that just looks at key info from the building data - YIMBY/NIMBY, Demand Cap relief, Mayor rating, and Footprint.

Buildings with some YIMBY/NIMBY of 100/-100 are highlighted.

[Sharr 6]

If anything is messed up, please let me know. Thanks!

[+Guest]

Thanks to both Kolyana and Sharr for thier work with the building guide. I've just d/led it and will look at it in the morning. I haven't used a guide yet to aid in my building but since it is so readily available, why not? lol

[Kolyana 0]

Nice work - I'd love to get my hands on a printable version oneday, but this is certainly nice.

I've recommended to Dirk that he add it as an available download, so *fingers crossed*.

[Rodge 0]

My thanks to both yourself and Kolyana for taking the effort to do this.

It's a lot more user friendly now and really is quite useful, especially as I am still a relative newbie at SC4.

[Mike230224 0]

Its in the downloads now!

[Dirktator 2,324]

Thanks Sharr for the effort, I've added it to our downloads area, much appreciated!

-dirk

[bumblebeeonarose 0]

where did you get all this information?

[+Guest]

They probably got it from the Prima guide.

[Kolyana 0]

----------------

On 3/19/2003 7:50:20 PM flywildjaguar14 wrote:

They probably got it from the Prima guide.

----------------

I bought the guide and foudn it very useful - I'd encourage its purchase to any SC4 fan.

However, I also foudn that the information i needed was spread over half a dozen chapters, so I took the liberty to drag it all into one location.

[Screwballl 196]

thank you to both koly and sharr, i found the information usefull but as i cant see that and the game at the same time, it will be tough to remember everything... but i opened it under MSWorks SS and it works fine, just shows a small windows asking which tab to open.. everything still works or so i think

[Sharr 6]

Thanks to Kolyana, for putting the info together.

If you click the basic data tab, you should be able to print that out on two pages (or 1 if you print on both sides) using .5" margins. Demand Data should easily print in 1 page.

[Kolyana 0]

I'm greedy, I want it all

I wonder if I could get the font small enough to get it all to fit on a landscape print and get a well positioned page break? i could live with 2 or 3 pages like that.

BTW Sharr, did you retype everything, or were you able to import it from the webpage?

[Sharr 6]

I did a lot of cutting and pasting. There were some extra columns, though, on the left that were throwing it off, but I edited them out.

Unless you want to look at it with a magnifying glass, I think you are better off just printing the basic data

It's already printing at 7pt. To get EVERYTHING on one page would require some really teeeeny point size. However, even at 3 or 4 point, it's just too much info to put on one page.

It might be easier if you use legal length paper as you can get all the columns, but the rows might be tricky.

[Meg 368]

----------------

On 3/19/2003 4:34

1 PM Sharr wrote:

I really appreciated Kolyana's effort in putting together that building guide. But it's hard for me to use in web page format, so I put it into Excel. I get the feeling that I'm not the only one who would appreciate a slightly quicker way to sort through the info, so I'm putting it up here.

----------------

Thank you! Now I can sort it

[Emiliano240 0]

i've gotta say also that this guide is GOLD........i love it! but it woudl be nice to have a printer fiendly version so that i can reference it easier....... does this exist? or could it? thanx emil

[Wyldestorm 0]

I printed out the NIMBY/YIMBY by editing the sc4.html that is in building guide folder after you extract zip file,just changed the Table Font size from 10px to 8px,then printed out in lanscape.

[NOLEAFCLOVR 0]

what do h amd w stand for in the footprint list of the building reference program?

[Sharr 6]

Height and Width.

[jasski 0]

I can't seem to download anything from this site, any suggestions folks?

[Kolyana 0]

What happens? What error do you get?

Try right clicking the download link and select "Save target As..."

[SmegHead 0]

i have same problem

download through explorer sais page cannot be found

if getright catches it it sais server busy

i tried yesterday and today but still no luck

were else can i get these files (builing guide ones that is)

[Kolyana 0]

Are you trying the html or excell verion?
Are all downloads from this site the same?
Can you download new regions okay?

What version of IE are you using?
Have you downloaded and installed the latest MS updates?

How does the site ingeneral work for you? Is it slow?

[jasski 0]

----------------

On 3/24/2003 8:10:11 AM Kolyana wrote:

Are you trying the html or excell verion?

Either One.

Are all downloads from this site the same?

Yuppers.

Can you download new regions okay?

Regions work fine due to the fact that they are a straight away .jpg file...

What version of IE are you using?

6.0.2800.1106

Have you downloaded and installed the latest MS updates?

Yuppers.

How does the site ingeneral work for you? Is it slow?

Fine, not slow at all.

----------------

As an example, here is the Url that comes up when trying to get the html version :
ftp://24.141.6.242/SimCityBuildingGuide.zip

And result is "Cannot find server..."

[Kolyana 0]

Actually, something's broken - I'm goign to alert Dirk asap.

[jasski 0]

It's actually very odd indeed, the number of downloads gets higher every day, but still seems that some of us are having probs.

Thanks for your help Kolyana.

[Kolyana 0]

I imagine that when a link is clicked, it auto-increments the counter regardless of download success.

Thanks for the tip-off, I'm surprised someone else didn't bring it up before!!!

I've emailed, PMed Dirk and posted about this in the Mod-board, hopefully we'll get an early fix

[Kai 0]

After trying to download it for 24 hours, I gave up and searched the forums. I found this link from a most amazing kolyana. You should be able to get this copy through kolyana's site. It's at... (drumroll)

http://www.kolyana.com/files/SimCityBuildingGuide.zip

we love you kolyana. keep up the great work

[Kolyana 0]

HAH! That was a temporary location when i first started distributing the file, so please be aware that there is an error with one of the parks, but I forget what it was and to which one

You did some good searching there

[SmegHead 0]

GOOD searching


GOOD SEARCHING

it bloody fantastic

i searched and searched and searched and could not find that file anywhere else

VERY nice work

what did you use to find it

another thing
did you get all that just from the guide or is some your own workings

you say that certain buildings ease pop caps
I thought i had one but have decided it is just stuffed
SINCE
i spending $3500 a month on parks and stuff
have highways connecting to multiple neighbours
large subway rail neighbours ......
blah blah blah blah
plenty of good stuff

but she wont grow

sigh

well done kai

good work kolyana

Dr Maria