Subtopic	Posts		Updated
	Archive through September 03, 2015	25		09/03 12:57pm
	Archive through August 19, 2016	25		08/19 03:23pm

VBA code may cause issues. The spreadsheet must support multiple OS's and multiple versions of Excel. Although I now that Office 2007 and earlier will not install on a 64 bit version of Windows 7. (I know because I tried.) MAC OS's are different from Windows and so Office for the MAC is somewhat different as well. So you run into the compatibility issue when trying to save to an earlier version of Excel.

By Chuck Strong (Raider) on Friday, August 19, 2016 - 07:44 pm: Edit

No VBA solutions please. Thanks.

By Jason E. Schaff (Jschaff297061) on Friday, August 19, 2016 - 08:00 pm: Edit

Chuck:

Leaving town for several days tomorrow, but if no one has gotten back you by the time I return, I'll figure out the necessary Excel functions & syntax. I used a lot of "INDIRECT" functions in my EB spreadsheet, but set that up years ago and need to refresh my memory.

By Ted Fay (Catwhoeatsphoto) on Sunday, August 21, 2016 - 02:39 am: Edit

I found some time tonight and so sat down and did this. I produced a spreadsheet showing the navy-wide unit limits per major empire (plus the Tholians). It shows only those units that have a hard limit as to the number that can be built (e.g., the Gorn can only have one DNT in service at any given time).

I sent the form to Chuck. If anyone wants a copy, either chime in here or send me an email.

-T

By Richard B. Eitzen (Rbeitzen) on Sunday, August 21, 2016 - 03:08 am: Edit

I'd like a copy, please.

By Ted Fay (Catwhoeatsphoto) on Sunday, August 21, 2016 - 11:58 am: Edit

Caveat: I checked the rules, SITs, and OB. I did not check the FO2016 new rules or ME. Naturally it's possible I could have missed something, so if someone reviews this and notes an error, please advise.

By Ken Kazinski (Kjkazinski) on Monday, August 22, 2016 - 10:30 am: Edit

I would also like a copy.

By Thomas Mathews (Turtle) on Sunday, February 19, 2017 - 10:54 am: Edit

Transfer from Allies Line: Add Vudar Tribute (547.113). The Klingons must send a ship to collect this tribute under (435.2).

By Chuck Strong (Raider) on Sunday, February 19, 2017 - 02:23 pm: Edit

There are blank lines for empire specific line items - the electric version will allow you to type it in.

By Chuck Strong (Raider) on Tuesday, May 23, 2017 - 05:53 am: Edit

DRAFT 2017 F&E ECON FORM v1 fe-econform-v2017-v1-0.pdf (937 k)

By Ted Fay (Catwhoeatsphoto) on Tuesday, May 23, 2017 - 11:19 am: Edit

1) Excellent job, Chuck, thanks for all your hard work. It looks very tight. The custom entry lines and their locations are especially thoughtful and well done.
FEDS: Thanks.

2) Suggest removing the term "original" from the terms "original major planets" and "original minor planets". It is possibly confusing because planets may not be original, but conquered and fully annexed and recovered (or gained via diplomacy) which would then be properly entered in those boxes to get the correct economic value. As an alternative, instead of deleting "original", replace with "understated".
FEDS: Sounds reasonable.

3) What are "mobilization costs"? Just activations? There's space in the line, so may be worth putting an example or two as to what is meant by this category of costs to prevent confusion. Or just include the term "activation" somehow in the line to prevent confusion.
FEDS: See the second sheet -- police, mothballs, activations, etc.

4) Paying for colonial development already initiated is a production expense, but there is no line for it. Is this part of "mobilization costs?" Will we need the custom entry line in production expenses to cover this very common exense? Suggest consider deleting "vital unit production surcharges", as that is relatively rare and can be included in the production tracking page and hence included in the "production costs line", and instead replacing "vital unit production surcharges" with "continuing colonial development." This could be accomplished by having the "vital production" totals from that part of page 2 being reflected in the last line of the "scheduled production" so that the total of "scheduled production" reflected on page 1 also includes the vital production. That leaves room for having a line for colonial development on page 1.
FEDS: See the second sheet -- OTHER PRODUCTION -- then list the colony hex number and the type as "Colony-2 or -3" for the second and third turns of payment.

5) The end non-phasing turn includes an entry for peak debt. Will the *order* in which entries are processed affect peak debt? Example: Say I gain 10 points in salvage but I spent 20 points in non-phasing expenses. Nominally, peak debt is increased by 10 because salvage can be accrued as soon as it happens. However, if the logic isn't right on the spreadsheet, then it might record the peak debt as being 20 points instead of 10 points higher.
FEDS: To avoid continuous "Debt Checks" after EVERY SINGLE ROUND of combat and ground combat, it is best that we only check the peak debt at the end of the three major phases otherwise it will slow the game down TOO much as players will nit-pick their way through the sequence of play to find that one best path to save a half point of interest on the next turn.

6) Mike Parker's old form included all of the data for production schedules. You might be able to cannibilize that data (check it for updates) and then use it for adding that productions schedule addition that you mentioned in your original post.
FEDS: noted - thanks.

7) Will the excel sheet have this sheet propagated among multiple tabs in order that an entire war's worth of econ forms are in one file? Or will each turn have to be saved as a separate file? Obviously the former is better, but I don't know how you have your excel file setup so it's hard to tell.
FEDS: Tabs as follow: FT1 - Y168F; FT2 - Y169S; etc. (Meaning: Federation Turn One - Fall Y168; etc). One file for one empire for each game. Page 1 and page 2 (above) will be side-by-side.

8) *CALL ME* if you want to discuss anything or want to brainstorm about Excel issues. While not an Excel guru, I've been fiddling with Excel for a long time for a bunch of different games and maybe I can help. If you need my phone number, just send me an email.

Thanks again!
Ted Fay

By Nick Samaras (Koogie) on Tuesday, May 23, 2017 - 05:51 pm: Edit

Wow, and people call energy allocation forms "tax forms"

By Mike Dowd (Mike_Dowd) on Tuesday, May 23, 2017 - 06:50 pm: Edit

Nick, F&E is *all* about spending taxes, so.... YEAH!

By Thomas Mathews (Turtle) on Tuesday, May 23, 2017 - 08:31 pm: Edit

Chuck, your exhaustion levels have issues with the Federation who have 20 turns before they drop to 75% exhaustion. The ISC would have the same issue if the sheet goes that far.
This is not an issue as when you select the empire to play (upper left page 1) , this will drive a conditional change on the exhaustion chart. All is good.

I've modified MP's spreadsheet heavily. Both Ted and Bill have test copies. Bill, because we are using it in the Empires of the Dead game and that includes the Paravians, Carnivons, Vudar, LDR, ISC, and in time the Seltorians all at the same time.

By Stewart Frazier (Frazikar2) on Tuesday, May 23, 2017 - 09:42 pm: Edit

Chuck, are the XTPs subject to exhaustion as it's not shown (26.4 before and after)??

No.

---

Quote:

(523.125) Bonus XTPs received for planets are not
reduced by the current economic level, including
exhaustion, limited war, etc. The XTPs received for 20% of
the total economy have already been adjusted for this and
would not be further adjusted.

---

By Chuck Strong (Raider) on Monday, May 29, 2017 - 02:48 pm: Edit

EXCEL Warriors, Experts and/or Coders:

I need your assistance with building a drop down list for the update of the new Econ & Production sheet (see above PDF of 23 May). Here is what I want to do:

Every turn the production form will be populated with all an empire's scheduled builds. These scheduled ships will be in column 'A'. This is easy to do.

In the next column 'B' is what is actually selected to be built, this will be a drop down list that will be initially filled with the scheduled ship as the default choice. I want the players to be able to select from a drop down list POPULATED from a list elsewhere on the spreadsheet with one of the following: the scheduled ship, a null selection, then all LEGAL substitutions available for the scheduled ship based on the turn in question.

The next column 'C' is automatically filled with the the cost of the selected ship from column B and column 'D' is automatically filled with the cost of the fighters for that same selected ship. This will use some sort of lookup table based upon the ship selected in B.

For Example: the scheduled build is a "CA" and is listed in column A (it cannot be changed); column B is also automatically filled with "CA" (by default) with its cost in column C as "8" and nothing in the fighter cost column D. When the player clicks the box in column B, I want him to be able to select from the drop down list a CVS which then automatically fill in the cost of "10" in column C and the fighter cost of "16" in column D.

This is where it gets difficult...

How do I build the drop down list that selects ONLY ships legally available for the turn based upon the year? If the year is Y170, I only want selected ships from Y170 and before to show up on the drop down list.

A	B (drop down)	C	D	E
Schedule Ship	Selected Ship	Ship Cost	Fighter cost	Selected Ship Available Year
CA	CA	8		120
	- (null)			120
CA	CVS	10	16	168
CA	TG	6		125
CA	CC	9		130
CA	CAQ	12	24	175
CA	CAX	14		184
CA	DD	6		132
CA	FF	3		120

Some restrictions: No macros or VBA please as I want to keep the coding as "simple" as possible; formulas are fine.

Thanks.

By Ted Fay (Catwhoeatsphoto) on Thursday, June 29, 2017 - 10:13 pm: Edit

Any news, Chuck? I look forward to the Excel version of this!

In fact, I'm willing to play guinea pig in my current games if you want to email me the current prototype version.

By Jeffrey Tiel (Platoaquinas) on Friday, June 30, 2017 - 08:06 am: Edit

Has anyone created a Planet/Province Control spreadsheet that keeps track of which empire controls which province, neutral zone, and planet as well as when that control yields long term capture and ultimately annexation?

By Ryan Opel (Ryan) on Friday, June 30, 2017 - 09:04 am: Edit

Jeffrey,

Not that I know of. Looks like it's your time to Excel at this project.

Ryan

By Mike Curtis (Nashvillen) on Friday, June 30, 2017 - 04:46 pm: Edit

I love it when someone steps up to volunteer!

By Jeffrey Tiel (Platoaquinas) on Sunday, July 02, 2017 - 06:09 am: Edit

Good God, Jim, I'm a philosopher, not a mathematician!

Unfortunately, Excel isn't my strong suit. Best I stick to novels

By Mike Curtis (Nashvillen) on Sunday, July 02, 2017 - 11:04 am: Edit

Well, get back to writing, then! I am waiting for a new book!

BTW, if anyone has not read Dr. Tiel's novels, look them up on Amazon! Pretty good read.

By Daniel Glenn Knipfer (Dgknipfer) on Saturday, October 21, 2017 - 12:08 pm: Edit

Any word on the updated Exel econ sheet?

By James Wood (Jwood314) on Monday, December 04, 2017 - 03:55 pm: Edit

I took this and turned it into Excel. Not sure if I can share that though, also, not all of the maths work on the page yet. We are debugging it as we play.

Does anyone know if we can download the Excel version of the SITS? Would be great to actually be able to sort on date, to see what becomes available when.

Cheers,

By Ryan Opel (Feast) on Monday, December 04, 2017 - 04:23 pm: Edit

No excel version of the SITs is available or likely to be made available.

By Jim Westerfield (Jimwesterfield) on Monday, July 27, 2020 - 11:41 pm: Edit

Did anything ever become of the excel version of this eco form?

By Stewart Frazier (Frazikar3) on Tuesday, July 28, 2020 - 06:22 pm: Edit

Still being worked on, think it's on hold for possible beta testing (soon) ...