The World of The Gunny

The checking for built infra is done, and am now working on infra placement. The following are the easy ones. The facs are on a diff sheet and will require a few more hoops. But i figure one thing at a time. We will need to make sure the player fills out the infra purchase order correctly or it could get sticky. Infra that does not qualify or that is mispelled will be outputed to a file for GM trouble shooting.

Also, on the system Terrain sheet we will only parse 500 lines so it will read down to Row 542. If this is not enough it can be changed. If you would give me an idea of the maximum size (in rows) a system can reasonably expect to get to, I will change the value appropriatly.

"Industry"
"Farms"
"Resource"
"Wealth"
"Power Station"
"Research"
"Fuel"
"Housing"
"Unpaved Road"
"Paved Road"
"Interstate Highway"
"Poor Rail Road"
"Standard Rail Road"
"Advanced Rail Road"
"Hyper-Advanced Railroads"
"Mag-Lev Railroads"

This auto advanced the turn at the top and then read the contents of the infra const into an array, which then printed to a file while looking for the next set of infra. The ones with a zero at the end are finished on turn 30. Now to add it to the appropriate region!

"N-3 Saretan Lowlands Wealth 6 24 0"
"N-3 Saretan Lowlands Research 6 24 0"
"N-3 Saretan Lowlands Research 6 24 0"
"N-3 Saretan Lowlands Industry 6 24 0"
"N-3 Saretan Lowlands Industry 6 24 0"
"OR-1 Quadrant 1 Industry 6 24 0"
"N-2 Somerset Wealth 6 25 1"
"N-2 Somerset Power Station 6 25 1"
"N-2 Somerset Power Station 6 25 1"
"N-1 Orly Standard Railroad Layer 24 25 19"
"N-1 Orly Standard Railroad Layer 24 25 19"
"N-2 Somerset Wealth 6 25 1"
"N-3 Saretan Lowlands Research 6 25 1"
"N-3 Saretan Lowlands Research 6 25 1"
"N-3 Saretan Lowlands Industry 6 25 1"
"N-3 Saretan Lowlands Industry 6 25 1"
"N-2 Somerset Standard Railroad Layer 24 26 20"
"N-2 Somerset Standard Railroad Layer 24 26 20"
"N-3 Saretan Lowlands Wealth 6 26 2"
"N-3 Saretan Lowlands Wealth 6 26 2"
"N-2 Somerset Research 6 26 2"
"N-2 Somerset Research 6 26 2"
"N-3 Saretan Lowlands Power Station 6 26 2"
"N-3 Saretan Lowlands Power Station 6 26 2"
"N-3 Saretan Lowlands Standard Railroad Layer 24 27 21"
"N-3 Saretan Lowlands Standard Railroad Layer 24 27 21"
"N-4 Sarhus Standard Railroad Layer 24 27 21"
"N-4 Sarhus Standard Railroad Layer 24 27 21"
"N-3 Saretan Lowlands Wealth 6 27 3"
"N-3 Saretan Lowlands Wealth 6 27 3"
"N-2 Somerset Research 6 27 3"
"N-2 Somerset Research 6 27 3"
"N-2 Somerset Industry 6 27 3"
"N-2 Somerset Industry 6 27 3"
"N-1 Orly Standard Railroad Layer 24 28 22"
"N-1 Orly Standard Railroad Layer 24 28 22"
"N-3 Saretan Lowlands Wealth 6 28 4"
"N-3 Saretan Lowlands Wealth 6 28 4"
"N-2 Somerset Research 6 28 4"
"N-2 Somerset Research 6 28 4"
"N-3 Saretan Lowlands Research 6 28 4"
"N-3 Saretan Lowlands Research 6 28 4"
"N-3 Saretan Lowlands Industry 6 28 4"
"N-3 Saretan Lowlands Industry 6 28 4"
"N-3 Saretan Lowlands Wealth 6 29 5"
"N-3 Saretan Lowlands Wealth 6 29 5"
"N-2 Somerset Research 6 29 5"
"N-2 Somerset Research 6 29 5"
"N-3 Saretan Lowlands Industry 6 29 5"
"N-3 Saretan Lowlands Industry 6 29 5"

Haegan, sorry but I got back LATE last night!

As for the size a system can get, thats a tough one bud. But I would boost the number up to 1000 for now. And it may need to get larger since every segment in a ring can possibly hold space colonies. And each segment holds a varying number of regions depending on what ring the segment is located in.

Also, I think the region location should have in the sector and subsector locations. Since for example, if there is 6 sectors there are going to be 60 hexes with the same number. 10 per sector. So to prevent any possible problems we should use them.

And it sounds fantastic so far!

You are likely right about 1000 rows, but it will potentily get worse then that. Before we get this far I expect to have a web based app that will replace the excel sheets. We have posted pics of the program on CDG at the following link.

http://cdgroup.org/forums/showthread.php?t=257

can you give me an example? using numeria, of course

Actions so far. **** marks what needs to be done.

Updates turn number on GM Empire sheet and on "Const" sheet in System workbook

checks for finished infra on "Const" sheet in system workbook and transfers it to "terrain" sheet in system workbook
Removes finished infra from "Const" sheet in system workbook
Looks for Tn infra and adds it to Newly built stuff in array. totals Qty of infra and WU and RM costs and puts it into a running total on the form for GM to see.
Looks for Infra and adds to Newly built stuff in array. Totals Qty of Infra and Facs, Totals the WU and IUU and RM(for IUU building) costs and adds costs to running totals the form for GM to see,added PROJECT IMPLEMENTATION purchases from empire sheet.
Purchases of more then 1 infra of a given type is spaced out in the array so that it will be entered on the Const sheet correctly.
**** Need to check for odd infra spelling and convert to standard spelling so it can be placed correctly. (ie PP is converted to Industry, RM is converted to Resources, etc.) This will take some time to do as several checks have to be made and anything that does not match must be put into the error file. Which reminds me, we need an error boolean that when turned true will cause a popup to inform the GM of said errors.

**** Still need transfer new infra const to Const sheet.


****Want to be able to take new unit purchases and palce them on the Const sheet properly.
**** needs to calc population increases per region and adjust the 'Terrain' sheet where needed.
****Needs to update research and maybe do rolls?
****Needs to do Prestige roll at end of year, and maybe do pop maintenance? IIRC pop maintenance is optional for player so should have a way to toggle it on and off.(uses WU or IUU)

Updates the "Economics" sheet in Empire workbook as follows:
updates infra totals and energy production total
updates energy usage total. maybe can update the energy breakdown totals as well? or should switch it and only update energy usage breakdown?
food is updated every 3rd month, as per rules.

Due to the fact that many players will want to do shorthand when entering orders we have entered a converter to check for the players shorthand when checking for infra purchases on the Empire sheet. Any short hand that it doesn't catch will be put into an Error.txt file in the same folder as the GM One Click.

An infra purchase that is larger then one(ie I buy two industry) is now parsed so it is entered twice into the purchase array as individual purchases.

Coding is now writing new purchases to the system Const sheet.

Next is natural monthly population increases.

Ken, I need any short hand infra codes that Gavin has been using so that we will have a broader sample for the converter.

Sounds great bud. Did you get the program to Gavin to try out?

Up to now, Gav has been using the exact abbreviations I have listed in the rules.

Yes, i sent it to gavin and he replied today. It errored out, but not because of excel. I sent him a buggy version. Good thing is that you should be fine with Office 2003 if you can get it.

Now to find a very cheap copy of office 03.

Population incrementation has been initiated correctly. One headache down, lots more to go!

Before processing Construction, Moves these to show totals from last turn to the B column on Empire economics sheet. They are from the expenditures columns from bottom right of sheet;
Wealth Units
food
fuel
Raw Materials
research
IUU
Energy


do firesales;

update wv,
update the sold items in expenditures section at bottom of sheet for food, fuel, energy, Iuu, raw materials,
zero sales items

doing spade work for multiple system sheets. and updateing industry and industry based off of poplulation to the Economics sheet. This has to be done for each system as they are processed. The same for energy usage for population, Infrastructure, and the Transport network.

Population usage for the facilities, transport network, and infrastructure has been tied together on the excel sheets. This permits the player to see how adding facilities and infra, etc will effect his empire in real time. The idea is to make it easier for the player to plan ahead and see what the results of that planning will likely be.

The GM program has had the Facilities setup to be placed onto the Facilities sheet when finished production. Facilities cover bases, manufactories, training places for teams and personnel for units, and power and enviromental terraforming centers.

Squashed a bug in population incrementation and adjusted the rate of population incrementation with kens help. Good thing he has a calculator!

Added fields to the visible form for error and unprocessed order notification as well as wealth spent on unit purchases. Will need to add Production points expenditures as well.

I am waiting for a list of abbreviations for the internal converter for names. Many players will want to use short hand for many of the infra and facilities when noting what is being purchased. Such as Wu for Wealth, RP for Research, SRR for Standard Railroad, etc. Short hand that is not converted will be listed in a file called 'Error.txt'

the 'error.txt' file format is as follows:

Unable to Place finished facility or infra.
N-1 Orly Sandard rail road 24 25 19

In this case the Standard Railroad is mispelled and the program does not recognize it so GM involvement is needed to figure it out!

Added 8 facilities to the Excel Facilities sheet including all 6 team buildings, the anti-matter production facility, and the He3 Production Station.

The following Facilites are now being transfered:

"Command Center"
"Beanstalk"
"Lunar Beanstalk"
"Naval Base"
"Army Base"
"Air Base"
"Task Force Depot"
"Squadron Depot"
"Garrison Post"
"Outpost"
"Air Field"
"Air Strip"
"Sub Yard"
"Dock Yard"
"Ship Yard"
"Star Yard"
"Harbor"
"Star Port"
"Fleet Command"
"Army Command"
"Air Command"
"Military Academy"
"Starbase"
"Vehicle Manufactory"
"Super Vehicle Manufactory"
"Human Vehicle Manufactory"
"Airship Manufactory"
"Tactical Air Manufactory"
"Strategic Air Manufactory"
"Airlift Manufactory"
"Avaition Manufactory"
"Rocket Manufactory"
"WMD Manufactory"
"Artillary Manufactory"
"Star Fighter Manufactory"
"Infantry Depot"
"Solar Satellites"
"Solar Reciever"
"Solletta"
"Institute Of Higher Learning"
"Intelligence Center"
"Detention Center"
"Atmospheric Processor"
"Gravity Generator"
"Core Temperature Regulator"
"Temperature Regulator"
"ZPE Transmitter"
"Fuel Crystallization Station"
"Mechanological University"
"Inventor's Hall"
"Steamworks Manufactory"
"Anti-Matter Production Station"
"He3 Production Station"
"Museum of Natural History"
"Diplomatic Institute"
"Assay Offices"
"Explorers Clubs"
"Hunting Preserve"
"Spy Academy"

List of abbreviations sent. And I like the error txt format. nice, direct, and simple.



Cheers, Thor

Monthly food spoilage of 5% added. This iscalculated before new food is brought in. Of course, new food is only brought it every 3 months. This may eat up large reserves to the point where large amounts of reserve food is hard to keep. We'll see!

I have your abbreviations! Thank you!

I forgot to ask if you had gotten that email or not. Glad to see that you did.

At considerable risk to myself in terms of repetitive typing, the abreviations have been entered. A unconverted abreviation is transfered anyways and noted in the 'Error.txt' file as follows.

"Name conversion has failed for the following item. Please fix it on the Const sheet for 1508-20NU-S"
"N-3 Saretan PRRAil 1 24; Name has found no match."

It occurred to me that a lot of orders cannot be processed by the program. Like diplomacy, movement orders, things like that. These, when found, will be put into a file for GM processing and an announcement listed for the GM so he knows that they exist.

As long as it spits out an accurate txt file showing what was not done, I am ok with that for now.



Cheers, Thor

The 'Not Processed Orders' file is proceeding apace, slowly. I am having bugs and can't seem to find the spray. On the plus side, it does write the Planetary Orders and Movement orders to the file successfully.



OK, dummy update. What happens when you refer to A0 in an excel sheet?


It errors! Duh!

You are doing a damn fine job bud. Keep up the good work!



Cheers, Thor

Chad, here is a thought, why not post your GM one Click status reports on Aurora to? Maybe we can reel in another sucker, err, I mean playtester.



Cheers, Thorgrimm