Politician Archive
Thread: TREASURERY TOOL v 1.0.7b: Spreadsheet for Mayors and Treasurers (22 Mar 2005)
Kyorlana
Mon Oct 18, 2004 2:49 pm
#27
No... seems the upload was corrupted. I've reuploaded the file so try again, sorry!
Kyorlana
Mon Oct 18, 2004 7:01 pm
#28
There was also an error relating to civic structures, please download v1.0.5a 
Kyorlana
Fri Oct 22, 2004 12:12 am
#29
Did you reboot your machine inbetween to ensure there were no open locks on the file?
KJFett
Fri Oct 22, 2004 9:28 am
#30
Yes, The PC has been rebooted several times since then and still no luck.
Kyorlana
Fri Oct 22, 2004 1:05 pm
#31
I'm terribly sorry... the file on the server was corrupt.
I've uploaded it for the third time now and was able to download and open it successfully.
If this doesn't workf for you please PM me your e-mail address and I shall e-mail it to you
I've uploaded it for the third time now and was able to download and open it successfully.
If this doesn't workf for you please PM me your e-mail address and I shall e-mail it to you
Kyorlana
Sun Jan 09, 2005 10:43 am
#33
Treasury tool updated to version 1.0.6
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
Thanks to all who have sent in requests and comments!
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
Thanks to all who have sent in requests and comments!
Kyorlana
Mon Jan 10, 2005 2:22 pm
#34
The residency field is a lookup based on what you enter on the front Summary page as your city name. Change it from 'Tirius' to your city name and voila
I didn't put in the formula for the count as I figured most people would just enter the number from the terminal rather than maintaining a citizen listing as some of us do.
If you have any further request let me know
I didn't put in the formula for the count as I figured most people would just enter the number from the terminal rather than maintaining a citizen listing as some of us do.
If you have any further request let me know
EmperoressPalpatine
Tue Jan 11, 2005 1:35 am
#35
The citizen page is great, thank you! People can code it to count the residents and put that in the Overview page.
Only problem is the Resident field is locked to just Tidius, not sure if that was the plan or not.
Anneke Rose
Kyorlana
Mon Feb 28, 2005 1:37 am
#36
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
- 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
Kyorlana
Sat Mar 05, 2005 10:11 am
#38
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
- 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
Kyorlana
Wed Mar 23, 2005 3:49 pm
#39
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 *
- 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 *