Politician Archive

Thread: Excel Spreadsheet for City Budget

Kerico
Sun Nov 02, 2003 4:42 pm
#1

Hi,


I made this Excel Spreadsheet for City Budgets (using MS Excel 2000). I've scanned with updated Norton Anti-Virus. Size is 19.0 KB (19,456 bytes). It should have no macros.


http://web1.greatbasin.net/~ericandshannon/files/SWGCityBudget.xls


(Sorry, I don't know how to post a link)


It's pretty rough right now but will get the job done (I'll dress it up later).


Costs: These are just approximate right now (I didn't know costs for gardens and such).


Fill in the Blue values. All the black numbers are driven.


It's 3 sheets: 1 summary page, 1 costs page, 1 revenue page


I hope this helps you, tell me if its mission something or if you have a better cost.


Thanks, Keh' Icoh

Kerico
Sun Nov 02, 2003 5:17 pm
#2

put up a little page so you can SaveTarget


http://web1.greatbasin.net/~ericandshannon/swg.htm

Kerico
Mon Nov 03, 2003 11:17 am
#3

I guess not many folk have excel.

watchkeeper
Mon Nov 03, 2003 11:27 am
#4

thx... can't wait for the updated version. :-)


vortexala
Mon Nov 03, 2003 11:29 am
#5

I'll be keeping an eye on it, thanks for the work



~Texxie Xetrov~
Retired Mayor of Vesania, Corellia, Chilastra
Retired Combat Medic Correspondent(Feb 04 - Dec 04)

"A Day without sunlight is like.... night."
A CU Alpha Testers Disclaimer: This CU Alpha Test Contained neither Alpha nor Testing.
Play at your own risk, but don't blame us...
Tansun
Mon Nov 03, 2003 11:31 am
#6

Nice little spreadsheet. Thanks



Tanson Yanshi - Working to Master BE once again.
Quarmo
Mon Nov 03, 2003 11:55 am
#7

i know you didnt know the gardens and lamps and such but are the major buildings accurate? 100,000 for city hall? all previous responses were saying 50,000. 150,000 for shuttleport?


Thanks in advance for response


Quarzi

Kerico
Mon Nov 03, 2003 12:08 pm
#8

The only costs I know right now.. and I'm sure they're not final.


But I'm pretty sure on test center right now that



  • hall is 100k

  • shuttle is 125k? (I set it to 150k I think in the spreadsheet)

  • specialization is 150k

  • trainer is 1k

The rest are pure speculation and I'm sure they're wrong.


I'm very sure of weekly house, harvester, factory maintenance rates. (at least without merchant efficiency IV)

DashZero
Thu Jan 15, 2004 2:28 pm
#9

Any recent updates to this? Any other resources out there to calculate city costs?


Thanks!




_ _ _ _ _ | _ _ _ _ _ | _ _ _ _ _ | _ _ _ _ _ | _ _ _ _ _ | _ _ _ _ _ | _ _

Gawchubak - Pre-Silent: Marksman - Commando (H1) - Smuggler (H2) - Scout - Ranger (H3)
Post-Silent: Entertainer - Image Designer - Dancer - Musician - Artisan - Medic - TKA - Brawler - Merchant - Swordsman - Pikeman - Fencer - Doctor (current)

Ego Agam - VP of Engineering - MinMax Corporation - Tempest

Kerico
Thu Jan 15, 2004 6:00 pm
#10

Hi, no I haven't updated it. I think I've been too busy actually being mayor! hahaha


Really the only thing that needs to be done is to modify some of the costs. This is easy enough to do on your own.


If there is a major thing you need on it, or changed. I could do that.


Keh'

Kerico
Thu Jan 15, 2004 6:04 pm
#11

Just looked at it again. Well... maybe I will update it. Didn't realize the public version was that old.


I have the double secret version .3! haha


I should at least get it to 1.0

Page 1 of 1
Previous Next