Politician Archive

I've updated my Excel spreadsheet to V.2

Updated costs, added spinboxes, added rank and lookup tables

Fill in the blue values.

You can get it here (scanned with updated Norton anti-virus)

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

you may need to update the page

Happy budgetting!

Keh'

The macros are the spinboxes and checkboxes....

Let me put up a non-macro version...

Keh'

ok... I can't seem to totally remove them now that I've used the form tools...

(if anyone can tell me how to officially unmacro it, please tell me)

refresh this page...

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

There is now a no spinbox/checkbox version. Just disable the macros on opening.

If you want to change your security settings, Tools > Macro > Security...

Once again, 3 sheets (summary, costs, revenue). Edit the blue values.

Keh'

push this back up a little bit...

btw, already found a bug the spinbox for #weekend tickets rolls the weekday tickets.

I also plan on putting in warnings if max trainers, terminals or decorations is exceeded.

Also, would a distance calculator be helpful?? Like you have the coords to the city, then you put the coords to a house and it gives you the distance? Then checks it against the city's radius?

Kudos Keh'! Nice sheet.

Question for you, how do i add in more vendors? I tried copy and Inseting the Pasted Cells, but the spinboxes don't match up after that. Need more than 2 Vendors in the Revenues.

Cheers,

-Ex

hmm.. well if you want to copy the spinbox (and redirect it to the correct cell), you need to enable the 'control tools' toolbar. If you hit the little blue right triangle icon (first one), that lets you edit (grab/copy/configure) the spinboxes and checkboxes. If you go to the properties of the spinbox, there is a 'linked cell' field.

I'll certainly be easier to turn on the control tools, and just delete the spinboxes from the vendor section.

Maybe I should remove them from the vendor section entirely, since that's the only area that really needs to be customized for each city.... or make 5 spinbox vendors and 3 non-spinbox vendors at the bottom so people can copy the row, then 'insert the copied cells'.