I made the program for my a specific use, so there was no need to ask. We had a player who was REALLY slow at doing damage allocation, and I wanted to help him enjoy the game. Sad story, I finished the program, we used it once, then he died the next weekend. Life sucks sometimes.

By Eric Smith (Badsyntax) on Thursday, June 27, 2013 - 09:44 am: Edit

I wrote up an app a while back that drew SSDs (you had to import x/y coordinates of all the boxes) and would do damage allocation with them, filling in boxes. It was automated, so in some cases had to choose a box over another (priority value for each type of box). It worked pretty well, but was just me playing, though I showed it to a couple folks it was never used for anything.

I was just tinkering at the time with thoughts of making a real time, top down, 2d, version of SFB. Then I came to my senses

By Richard B. Eitzen (Rbeitzen) on Thursday, June 27, 2013 - 09:52 am: Edit

Pity, that could have been fun.

By Chuck Strong (Raider) on Thursday, June 27, 2019 - 06:45 pm: Edit

Here is the latest work on the F&E Econ Sheet for 2019.

Comments are welcome.

-FEDS

Beta F&E Econ Sheet 2019A fe-econform-2019a.pdf (236 k)

By Ted Fay (Catwhoeatsphoto) on Thursday, June 27, 2019 - 08:06 pm: Edit

No additional comments.

Is it possible to get this in Excel?

By Randy Blair (Randyblair) on Friday, June 28, 2019 - 12:26 am: Edit

Second that.

By A. David Merritt (Adm) on Friday, June 28, 2019 - 01:40 am: Edit

Third.

By Ted Fay (Catwhoeatsphoto) on Friday, June 28, 2019 - 09:15 am: Edit

The only enhancements I would like is to have an Excel version which cannot fit on a single page. The reason why I say this is because Mike Parker's form has a lot of beautiful functionality that I would like to have in the new and improved eco form - such as auto-population of build schedules by empire, auto-population of the base economic numbers, as well as one tab for each turn. It also calculates interest automatically and has several other nice features, not the least of which is automatic addition and multiplication of costs and income, as needed.

When I play F&E I currently use Mike Parker's form, and it's wonderful because I only need to maintain one spreadsheet per empire. Each tab represents a turn, but the first tab has a drop-down menu for selecting which empire that Excel file will apply to. This system is very compact and efficient, and helps reduce the time needed to spend on eco.

Of course, it only works on a computer.

While I totally grok the need to have a single page eco form that can be downloaded and printed (this really really is necessary for the game on a broader perspective), I think for us old veteran hacks we'd like to see more.

Mike Parker's old eco form still works great - it just needs some tweaks for the changes that have come out since Mike first worked on it. I'm pretty sure Thomas Matthews has worked on it, and I know that you, Chuck, based this form on Mike Parker's version.

All that is a round-about way of saying "gee, that's necessary and cool, and well done, - but let's now produce a suped-up turbo version that takes advantage of the full power of Excel."



-T

By Thomas Mathews (Turtle) on Friday, June 28, 2019 - 09:46 am: Edit

Actually MP did the current excel version off of Chuck's economy form. The latest version I have requires that your spreadsheet support the .xlsx file type. So any spreadsheet that doesn't support that file type will not work.

The current version I have supports the Winds Aloft and Howling Winds scenarios.

The new 6ES scenario is partially supported in the latest version.

By Chuck Strong (Raider) on Friday, June 28, 2019 - 12:13 pm: Edit

I gave the Mike my form to help me with streamlining the Excel language formulas. While I designed the Excel layout of the sheets, Mike had better experience with lookup tables and other exotic Excel features.

By Thomas Mathews (Turtle) on Friday, June 28, 2019 - 01:47 pm: Edit

Fortunately for me, my better half was a great help when I had to expand the drop down menu on the first tab for choosing the empire you wanted to play. Most of the other updates I did were trial and error. I killed more than one working copy as I added the minor empires and lost empires.

By Chuck Strong (Raider) on Friday, June 28, 2019 - 03:41 pm: Edit

BTW, the form is in Excel version 2016. I'd like someone to review the nation debt and deficit spending to make sure my accounting practices are correct.

I'm also looking for someone who is an expert in Excel to help me in streamlining the formulas and is an expert in conditional formatting and drop-down menus.

I want to automatically populate the build schedule for each turn in one column but want to want the player to select want is actually built in an adjacent column from a dropdown list of LEGAL substitutions for that specific turn.

By Stewart Frazier (Frazikar2) on Friday, June 28, 2019 - 07:20 pm: Edit

The problem with the drop-down is that it's only a single listing and production needs more than one to work (hull, cost and YIS?). Even then, I haven't found a work-around that will stop on the YIS, it's been all or nothing …

By Ken Kazinski (Kjkazinski) on Wednesday, July 24, 2019 - 12:59 am: Edit

Chuck,

Are you OK with using VBA or does it all have to be via formula's.

By Chuck Strong (Raider) on Wednesday, July 24, 2019 - 01:07 am: Edit

What’s VBA?

By Thomas Mathews (Turtle) on Wednesday, July 24, 2019 - 06:42 am: Edit

VBA is Visual Basic for Applications. It is a programming language. I don't think it will work for this spreadsheet for the simple fact that the MAC is different from the Windows machines even though they use the same intel based procressors.


NOTE: The AMD processor is based on intel processors but have mutated a little over the years. Still 1 and 1 in binary is 10.

By Lawrence Bergen (Lar) on Tuesday, October 01, 2019 - 04:44 pm: Edit

Where is the excel version of the above? (Even the 2016 will do.)

Also Mike Parker was working on the posted previous version in the resources page. I notice it still has CEDS throughout. Has support for it been abandoned?

By Lawrence Bergen (Lar) on Monday, April 27, 2020 - 10:44 pm: Edit

Starting a new "Isolated Empires" game to commemorate COVID'19. I will re-ask.

Does anyone have the above updated 2019 form in an Excel file?

By Ryan Opel (Ryan) on Monday, April 27, 2020 - 10:58 pm: Edit

Lar,

Email Chuck.

By Chuck Strong (Raider) on Tuesday, April 28, 2020 - 06:15 am: Edit

Lar:

Here is the 2020 Beta version...

Econ 2020 Beta fe-econform-2020v3_blank.pdf (238 k)

By Lawrence Bergen (Lar) on Sunday, February 06, 2022 - 11:00 pm: Edit

I have an excel formula Question for you (well google sheets actually).

I am trying to create logic to build a smart Combat tracker. One where you enter Compot and EW each round as well as die rolls (VBIR and COMBAT). I have all cells working (even the VBIR SHIFT and Combat %) as of now except one (two actually).

The EW comparison that generates the shift (should one exist). I can make it do the math but I cannot get it to also understand the exception for one side having a scout and the other not having a one point scout.

My formula in cell C20 as I have it now should calculate Coalition EW Shift:

=IFS(C7-C19=C7,"-1",C7-C19<=1,"0",C7-C19=2,"-1",C7-C19=3,"-1",C7-C19=4,"-1",C7-C19>=5,"-2")


Givens: ID and Cell
Alliance EW = C7
Coalition EW = C19
Coalition EW Shift (where the formula is) = C20

(Not shown Alliance EW Shift formula attempt in = C8) But I will need help with that one too.

For reference the EW Table/rule exception as written:

NEWPT = DIE-ROLL SHIFT
0-1 = None
2-4 = -1
5 or more = -2

(313.22) EXCEPTION: If one side has a scout and the other does not, a NEWPT of 1 will produce a -1 shift.

Who can ID where I went wrong or what I am missing?

By Stewart Frazier (Frazikar3) on Sunday, February 06, 2022 - 11:41 pm: Edit

One, you should make sure that C7 is greater than 1 to start with (otherwise it could be that both sides have 0 EW but show '-1' due to the first condition). The same would apply for the other side (C20).

But what isn't this doing right? What is being shown under what conditions?

By Alan De Salvio (Alandwork) on Monday, February 07, 2022 - 01:08 pm: Edit

Check for two conditions. Check for delta, and if more than 4 apply -2, else if more than 1 apply -1, else if 1 and no scout -1, else zero. This should be straightforward since no scout can downgrade to zero EW.

So add number of scouts, and three nested if statements should do it (one set for each side).

By Mike Curtis (Nashvillen) on Monday, February 07, 2022 - 01:40 pm: Edit

I did it this way for attacker:

=IF($B$2-$B$10>-2,0,IF($B$4=-1,IF($B$2=0,-1,IF($B$4-2,0,IF($B$12=-1,IF($B$10=0,-1,IF($B$12<-4,-2,-1)),IF($B$12<-4,-2,-1)))

Where B2 is Attacker EW (raw)
B10 is Defender EW (raw)
B4 is Attacker EW - Defender EW (raw)

By Mike Curtis (Nashvillen) on Monday, February 07, 2022 - 01:40 pm: Edit

For the Defender:

=IF($B$10-$B$2>-2,0,IF($B$12=-1,IF($B$10=0,-1,IF($B$12<-4,-2,-1)),IF($B$12<-4,-2,-1)))