Politician Archive
Thread: TREASURERY TOOL v 1.0.7b: Spreadsheet for Mayors and Treasurers (22 Mar 2005)
Page 1 of 4
Kyorlana
Thu Apr 29, 2004 4:53 pm
#1
Hi everyone,
Thank you for your continued support and feedback. I have updated the webpage for the Treasurer's Tool detailing the changes and new screenshots. Please bookmark the page so that you can quickly find information about the latest version.
v1.0.7b - 22-Mar-2005
- Corrected chart on Guild tab.
- Corrected the formula on the structures tab showing number of structures in use (thanks T'lara for pointing this out!)
- Changed the way the structure count works to fix open office compatibility issue when dealing with wildcard *
v1.0.7a - 5-Mar-2005
- Corrected some formula ranges on the citizens tab
- Re-entered 1 in the city costs tab so the city hall is picked up as a structure in the count
v1.0.7 - 27-Feb-2005 Added garden drop down lists, dependent upon planetary selection
- Added mission terminal drop down list
- Added trainer drop down list (note that Starship trainers are still not available)
- Corrected formula total range on Decorations sheet for streetlamps.
- Added guild tab and modified the citizens tab so each can have their guild status against them
- Added city withdrawals tab as requested by Marlon Craccholio of Corbantis
- Added option to indicate if the city has provided the home
- Received 2 reports that shuttleport reduced to 25k. I have verified that this is incorrect, the cost remains at 75k. Anyone having trouble balancing the budget, it is not due to this.
- Added declared number of citizens to the citizens tab
- Unprotected the declared residence column on citizens tab and added warning
v1.0.6 - 09-Jan-2004
- Corrected the range on the structure sheet celss g8 and g9 (thanks Oreh Kevo)
- Updated citizens page to take account of mailing subscription
- Added option 5 - none to the structures tab (thanks Oreh Kevo, and K'Thorn)
- Updated the calc values on wind/solar/fusion generators (thanks Mayor Blara Okana)
- Inserted citizens page as requested by Anneke Rose
v1.0.5 - 17-Oct-2004
Implemented sponsorship of decorations as requested by Toka - City of Mercator, Talus (Corbantis Server)
Implemented sponsorship of mission terminals
Added validation for required selection entries
Added facility to select specialisation rate and civic structures
v1.0.4 - 16-Sept-2004
Implemented sponsorship of civic structures as requested by Toka - City of Mercator, Talus (Corbantis Server)
Added today as the default date on the front overview sheet
Keep the feedback coming, thank you!
Message Edited by Kyorlana on 10-17-2004 09:20 PM
Message Edited by Kyorlana on 01-09-2005 05:40 PM
Message Edited by Kyorlana on 01-09-2005 05:41 PM
Message Edited by Kyorlana on 02-27-2005 08:36 PM
Message Edited by Kyorlana on 03-05-2005 05:11 PM
Message Edited by Kyorlana on 03-23-2005 10:49 PM
Kerico
Thu Apr 29, 2004 6:40 pm
#2
hehe I've done one of these as well. http://web1.greatbasin.net/~ericandshannon/swg.htm
Do you actually maintain that every week? Seems like alot of details. I don't even maintain mine every week.
I just use mine to get an 'impression' of what the budget is doing... "Well looks like we're running in the red by about 200k/week" etc.
There is so much that can influence revenue that you can't get a real idea (merchant discount, fluctuating tickets and sales, garage usage). You can nail the costs pretty well though.
Kyorlana
Fri Apr 30, 2004 3:39 am
#3
Rather than every week, we tend to update it on a fortnightly basis to coincide with reporting for our council meetings. Admittedly without everyone who uses the garage telling you how much they spent, merchants telling you how much they sold that week, etc. it is hard to pin down an exact amount - but we are able to balance the books and establish within reason just how much we are breaking even by or in deficit. It is useful for us because of the sponsorship and donations to keep records. Game within a game I suppose 
I like seeing trends and such like as you can see by my Talus City Review post.
Kyorlana
Tue May 04, 2004 9:44 am
#6
chuckbaca wrote:
This is a well thought out and through spreadsheet. Thanks.
Yay! I am glad that it is helping someone else out there other than myself! Thank you for the feedback Chuckbaca
Surius
Wed May 05, 2004 10:07 am
#7
/edit
neverMind. I redownloaded yours and noticed that the one I had before had been corupted and only the first sheet was showing. wondered what was missing. lol
I redownloaded yours and noticed that the one I had before had been corupted and only the first sheet was showing. wondered what was missing. lol/end edit
Message Edited by Surius on 05-05-2004 01:30 PM
Kyorlana
Thu May 06, 2004 6:26 am
#8
Thank you Surius for bringing that to my attention. That could be why some people aren't seeing the benefits of it, lol. I've amended my initial post to explain what IS included with a screenshot to help clarify it. Please download the new version as well, thanks!
Tavie_Bautat
Thu May 06, 2004 9:01 am
#9
How bout unlocking the "City of YOUR CITY NAME" cell so we can put our own city name there.
Otherwise, nice work.
Surius
Thu May 06, 2004 9:21 am
#11
Yeah, an unlocked version would be nice also. I have found a few errors and it was a pain in the rear trying to change them. If you could offer an unlocked version for those who want to make small changes/corrections, that would be great. it is a great spreadsheet though.
Kiom
Thu May 06, 2004 10:23 am
#12
This is a well done spreadsheet but without all of the required information being available to us what can you really get from it?
Unless I'm missing something we have no way of telling how much money comes in and no idea of from which catagory it comes from. It seems to me that without being able to look at income the ability to examine expenses doesn't do anything for you.
Tavie_Bautat
Thu May 06, 2004 11:30 am
#13
Kiom wrote:
This is a well done spreadsheet but without all of the required information being available to us what can you really get from it?
Unless I'm missing something we have no way of telling how much money comes in and no idea of from which catagory it comes from. It seems to me that without being able to look at income the ability to examine expenses doesn't do anything for you.
There are some numbers than can be estimated. For example, a random sampling of shuttle traffic over an hour can be used to estimate average shuttle visits per week. Vendors can report sales to help you calculate an average sale count for the week. The shuttle rule works for Garages as well. It's not going to be right on the nose by any means, but it is an excellent forecasting tool.
Page 1 of 4