I'll volunteer to convert it into an HTML web form.

By Gary Carney (Nerroth) on Thursday, September 03, 2015 - 06:12 pm: Edit

Do the "pre-final" Seltorian rules being primed for publication in the Minor Empires rulebook include revised numbers for playtest rules (5ST.121) and (5ST.44) from Captain's Log #45? If so, please consider adding Seltorian Base Planet Income and Seltorian Hive Ship EP Storage entries (with references to their "correct" respective rule numbers), for use by the Torch expedition in the soon-to-be-published Vortex of Vengeance (627.0) scenario. - Gary Carney 03 September 2015


(I just noticed that I accidentally dated my ISC note above to tomorrow. Ahem...)

By Chuck Strong (Raider) on Thursday, September 03, 2015 - 10:06 pm: Edit

Okay -- Here is the notional revenue side of things. I've included ***BLANK*** or ***DropDown*** lines for those oddball items that show up for just one empire (like the Hydran Bonus Treasury, Tholian Home World income, etc.)

Comments/corrections/suggestions are welcome. Report an item using the grid.

Revenue Chart	A	B	C	D	E	F
1	REF.		GENERATED REVENUE SOURCES	#	EP	XTP
2			Capital Planet
3	(430.11)		Original Major Planets
4	(508.21)		Captured/Devastated Major/Capital Planets
5	(430.11)		Original Minor Planets
6	(508.21)		Captured/Devastated Minor Planets
7	(540.21)	From Calculated Table	Captured Planet Diplomatic Influence Bonus
8		***DropDown***	Other Planetary Revenue
9			***BLANK***
10			Planetary Revenue: Sub-Total
11	(430.11)		On-map Provinces
12	(430.2)		Captured/Disrupted Provinces
13	(430.5)	From Calculated Table	Off-map Provinces
14	(446.21)		Colonies
15	(542.34)		On-Map Survey Hexes
16	(442.52)		Captured Neutral Zone Hexes
17	(448.21)		Annexed Neutral Zone Hexes
18			***BLANK***
19			Territorial Revenue: Sub-Total
20			TOTAL GROSS GENERATED REVENUE
21	(652.21)	***DropDown***	Economic Status Adjustment Factor	xx%
22			ECONOMICALLY ADJUSTED REVENUE
23	(540.2)		Diplomatic Trade Revenue
24	(542.27)		High Risk Survey Revenue
25	(442.4)***	***DropDown***	Bonus Funds
26			***BLANK***
27			TOTAL ADJUSTED REVENUE
28	(523.12)		Bonus XTPs for Undevastated Capital Planet
29	(523.12)		Bonus XTPs for each X-Starbase
30	(523.12)		May Convert up to 20% into XTPs
31	(523.12)		May Convert 1 EP to 1 XTP: max 10 EP
32	(523.12)		May Convert 2 EP to 1 XTP: max 20 EP
33	(523.12)	Planetary Rev x 40%	XTP Production from Planets (Calculated)	40%
34			XTP ADJUSTED REVENUE
35			Previous Turn Credit Balances
36	(305.22)		Scrap Units
37			Borrowed Interest Payment
38			Debt Payment
39			TOTAL FUNDING AVAILABLE

By Chuck Strong (Raider) on Thursday, September 03, 2015 - 10:23 pm: Edit

Here is the national debt chart.

DEBT CHART	A	B	C
1	Interest Bearing	NATIONAL DEBT	Interest Free
2	Total EPs+XTPs	PEAK DEBT LAST TURN	EPs Only
3	+10%	Interest Due	NA
4		Interest Paid
5		Scrap Units to Pay Interest
6		Borrowed Interest Payment	NA
7		REVISED DEBT
8	+5%	Basic Default Penalty	NA
9		ADJUSTED DEBT
10		Debt Payment
11		Scrap Units to Pay Debt
12		CURRENT DEBT

By Chuck Strong (Raider) on Tuesday, September 15, 2015 - 09:47 pm: Edit

Here is the proposed update to the Production/Conversion/Repair/Activations Sheet:

TITLE ROW1									TITLE ROW2									TITLE ROW3
SCHEDULED PRODUCTION			SHIP COSTS		FIGHTER COSTS				STANDARD CONVERSIONS			UNIT COSTS		FIGHTER COSTS				STANDARD REPAIRS			REPAIR COSTS
SITE	SHIP	SUB	EP	XTP	EP	XTP	FFF		SITE	FROM	TO	EP	XTP	EP	XTP	FFF		SITE	UNIT	PTS	EP	XTP
0000-CSY	DNG	WWWW	77.777	77.777	77.777	77.777	77.8		0000-SBX8	DNG	SCSA	77.777	77.777	77.777	77.777	77.8		0000-SBX8	B10S	10	77.777	77.777
000-MSY	CA						0.0		0000-CF+							0.0		2	CA	4	1.5	0.5
3	CA								0000-1CF-									3
4	NCA								4									4
5	NCL								5									5
6	NCL								6									6
7	NCL								7									7
8	NCL								8									8
9	NCL								9									9
10	NCL								10									10
11	NCL								11									11
12	NCL								12									12
13	NCL								13									13
14	NCL								14									14
15	NCL								15									15
16	NCL								16									16
0000-SBX1	DW	DWSX							17									17
18	DW								18									18
19	DW								19									19
20	DW								20									20
21	DW								21									21
22	DW								22									22
23	DW								23									23
24	DW								24									24
25	DW								25									25
26	FF								26									26
27	FF								27									27
28	FF								28									28
29	FF								29									29
30	FF								30									30
31	*FREE*	FFB							31									31
32	*ACCEL								32									32
MINOR SHIPYARDS			SHIP COST		FIGHTER COSTS				SPECIAL & CDR CONV			SHIP COST		FIGHTER COSTS				33
SITE	SHIP	SUB	EP	XTP	EP	XTP	FFF		SITE	FROM	TO	EP	XTP	EP	XTP	FFF		34
0000-NCL-1	NCL	NAC	77.777	77.777	77.777	77.777	77.8		0000-BTX8	HDWW	HDWW	77.777	77.777	77.777	77.777	77.8		35
0000-NCL-2	NCL									<CA>	CC	1						36
0000-NCL-3	NCL																	37
0000-DW-1	DW																	38
0000-DW-2	DW																	39
0000-DW-3	DW																	40
0000-FF-1	FF																		TOTAL:		To ECON	To ECON
0000-FF-2	FF								BASE UPGRADES			BASE COST		FIGHTER COSTS				FREE ATTRITION FACTORS
0000-FF-3	FF								SITE	FROM	TO	EP	XTP	EP	XTP			TYPE	START	ADDED	USED	BAL
OVERBUILDS			SHIP COST		FIGHTER COSTS				0000-BTX8	BTX	SBX	77.777	77.777	77.777	77.777			FIGHTERS	2	15	4	13
SITE	# BUILT	SHIP	EP	XTP	EP	XTP	FFF											PF	0	6	2	4
0000-BTX8	10	FF	77.777	77.777	77.777	77.777	77.8				TOTAL:	To ECON	To ECON	To ECON	To ECON			RUNNING TALLIES
2	1	CX							ACTIVATIONS & CALL-UPS			SHIP COST		FIGHTER COSTS				TYPE	START	ADDED	SUBT	BAL
OTHER PRODUCTION			UNIT COST		FIGHTER COSTS				UNIT	AVAIL	# ACT	EP	XTP	EP	XTP	FF		SWARM	90	10		100
SITE	# BUILT	UNIT	EP	XTP	EP	XTP	FFF		CA	6	1	1.000	0.000	0.000	0.000	0.0		B10-1
0000-SFB5	1	MON-V	77.777	77.777	77.777	77.777	77.8		CS	2	0							CMD PTS
2	24	PF							CL	18	3							PRIMES
3	1	SWAC							DD	3	1
4	1	HSWAC							FF	18	3							VITAL PRODUCTION CHARGES
5	2	CONVY							POL	25	2							TYPE		EP	XTP	UNIT
6	1	LAV							FLG	6	0							Extra Major
7	1	ENG							POV	2	0							Accellerated				*ACCEL
8	1	FRD+							PV	4	0							Override				WWW
		TOTAL:	To ECON	To ECON	To ECON	To ECON					TOTAL:	To ECON	To ECON	To ECON	To ECON				TOTAL:	To ECON	To ECON

Please excuse the test data on the form as it is there to make sure maximum data rows & column widths are accounted for so as to fit on one sheet.

Comments are welcome.

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 07:20 am: Edit

I need a list of running totals needed to be tracked during a game on the newest iteration of the F&E Economics & Production Form. So far I have the following:

Free FTRs
WYN Trade Rights
B10 Build Points
SWARMS
WYNCOVIA Accounts
Kzinti Drone Stockpile
ISC PPDs
Selt Booms
Treasury
Initial PF Pool remaining

What else???

By Richard B. Eitzen (Rbeitzen) on Tuesday, August 16, 2016 - 08:48 am: Edit

Command points.
National debt.
Main Grid Treasuries (capital and offmap).
Partial Grid Treasuries.
SFG kits.
Homeless ships paid for.

By Ted Fay (Catwhoeatsphoto) on Tuesday, August 16, 2016 - 12:45 pm: Edit

-Romulan modules
-Mothballs (but if you're starting with Mike Parker's econ form that's already accounted for).
-Survey Points and provinces found (same).
-Number of HRS colonies found.
-Police units activated (same - MP's form does that).
-Free PF factors (same).
-Ships sold to the WYN (specifically, the number of ships sold and when to observe those limits).


Not necessary, but would be useful to have a separate tab on the spreadsheet for tracking ship type limits. For example, every empire is limited as to how many AUXes they are allowed to have of various different types. The Lyrans are only allowed so many DNDs, etc. The Feds can only have one DLV, etc.

Ideally a drop down menu on sheet 1 would select the empire (per MP's spreadsheet). Then another tab on the spreadsheet would display the ship type limits that apply to that empire. Then the player could manually enter how many of each ship type is currently in service.

I might be able to work on this, but I'd have to teach myself the Excel skills. If this new spreadsheet is on Excel, then I would have to have access to the final version to program it.

Or Chuck can do it.

By Nick Blank (Nickgb) on Tuesday, August 16, 2016 - 04:15 pm: Edit

Repair/spare parts for Kestral ships?

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 04:17 pm: Edit

Ted:

Just FYI -- Some of the things you listed (like mothballs, survey, police, etc.) were already on the econ sheets I sent to Mike Parker years ago. He cleaned up my novice Excel coding and then he added some nice features of his own. Some of my sheets included very limited rule enforcements so that one could only roll counting numbers of dice instead of '-3.567' dice during survey. Some cells would also have a drop-down error explanations as to why an entry was wrong and would give a rule reference. I just didn't want to point out errors but wanted it to also be a teaching tool to beginners or as a refresher to the older players.

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 04:35 pm: Edit

Here is a preview to some items on the production sheet:
(Please ignore the checksums used to make sure things added up correctly.)

STANDARD CONVERSIONS			UNIT COSTS		FIGHTER COSTS
SITE	FROM	TO	EP	XTP	EP	XTP	FFF
1401-SB1	BC	CVS	1.000	1.000	1.000	1.000	30.5
1401-SB1	FF	FFK	1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
.
CONV DURING REPAIR			UNIT COSTS		FIGHTER COSTS
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000	30.5
.
SPECIAL CONVERSIONS			UNIT COSTS		FIGHTER COSTS
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
.
BASE UPGRADES			BASE COSTS		FIGHTER COSTS
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
			1.000	1.000	1.000	1.000
CONVERSIONS:			25.000	25.000	25.000	25.000	152.5
.
VITAL PRODUCTION			PREMIUMS		RECORD KEEPING
TYPE			EP	XTP	UNIT	SITE
Extra Major Conversion			1.000	1.000
Accellerated Production			1.000	1.000
Production Override			1.000	1.000
SURCHARGES:			3.000	3.000
.
FIELD SUPPORT ACTIONS			UNIT COSTS		FIGHTER COSTS
TYPE		#	EP	XTP	EP	XTP	FFF
Homeless Units		1	1.000	1.000	1.000	1.000	30.5
Homeless Carriers		2	1.000	1.000	1.000	1.000	30.5
Expeditionary Units			1.000	1.000	1.000	1.000
Planetary Recovery			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
FIELD SUPPORT:			5.000	5.000	5.000	5.000	122.0
.
ACTIVATIONS & CALL-UPS			SHIP COSTS		FIGHTER COSTS
UNIT	AVAIL	# ACT	EP	XTP	EP	XTP	FFF
CS	2	1	1.000	1.000	1.000	1.000	30.5
CA	6	1	1.000	1.000	1.000	1.000	30.5
FF	12	3	1.000	1.000	1.000	1.000	30.5
POL	15	2	1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
			1.000	1.000	1.000	1.000	30.5
MOBILIZATIONS:			9.000	9.000	9.000	9.000	274.5

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 04:45 pm: Edit

STANDARD REPAIRS			REPAIR COSTS
SITE	UNIT	PTS	EP	XTP
3008-SY	B10AA	10	1.000	1.000
3008-SY	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
'.
PARTIAL REPAIRS			REPAIR COSTS
0303-SFB33	CA	2	1.000	1.000
0303-SFB33	HDWW		1.000	1.000
'.
SIDS REPAIRS			REPAIR COSTS
0303-SFB33	HDWW	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
'.
BASE REPAIRS BY TUGS			REPAIR COSTS
0303-PSBX	PSBX	10	1.000	1.000
0303-SFB33	HDWW	10	1.000	1.000
REPAIR TOTALS:			4.000	39.000
'.
RUNNING TALLIES
TYPE	START	ADDED	SUBT	BAL
Free FTRs	1		0.5	0.5
Trade Rights	1	2	1	2
B10-1
SWARM-1
WYNCOVIA
Drone Stock
PPDs
S-Booms
Treasury
PF Pool

Note that Running Tally lines will be drop down lists but I'll include a few blank row for custom use. Free fighter factors will be a fixed sheet tally line.

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 04:49 pm: Edit

SCHEDULED PRODUCTION			SHIP COSTS		FIGHTER COSTS
SITE	SHIP	BUILT	EP	XTP	EP	XTP	FFF
1	CVA	DD	1.000	1.000	1.000	1.000	30.5
2	B10AA	B10AA	1.000	1.000	1.000	1.000	30.5
3	CA	CC	1.000	1.000	1.000	1.000	30.5
4	CA	CC	1.000	1.000	1.000	1.000	30.5
5	CA	CC	1.000	1.000	1.000	1.000	30.5
6	CA	CC	1.000	1.000	1.000	1.000	30.5
7	CA	CC	1.000	1.000	1.000	1.000	30.5
8	CA	CC	1.000	1.000	1.000	1.000	30.5
9	CA	CC	1.000	1.000	1.000	1.000	30.5
10	CA	CC	1.000	1.000	1.000	1.000	30.5
11	CA	CC	1.000	1.000	1.000	1.000	30.5
12	CA	CC	1.000	1.000	1.000	1.000	30.5
13	CA	CC	1.000	1.000	1.000	1.000	30.5
14	CA	CC	1.000	1.000	1.000	1.000	30.5
15	CA	CC	1.000	1.000	1.000	1.000	30.5
16	CA	CC	1.000	1.000	1.000	1.000	30.5
17	CA	CC	1.000	1.000	1.000	1.000	30.5
18	CA	CC	1.000	1.000	1.000	1.000	30.5
19	CA	CC	1.000	1.000	1.000	1.000	30.5
20	CA	CC	1.000	1.000	1.000	1.000	30.5
21	CA	CC	1.000	1.000	1.000	1.000	30.5
22	CA	CC	1.000	1.000	1.000	1.000	30.5
23	CA	CC	1.000	1.000	1.000	1.000	30.5
24	CA	CC	1.000	1.000	1.000	1.000	30.5
25	CA	CC	1.000	1.000	1.000	1.000	30.5
26	CA	CC	1.000	1.000	1.000	1.000	30.5
27	CA	CC	1.000	1.000	1.000	1.000	30.5
28	CA	CC	1.000	1.000	1.000	1.000	30.5
29	CA	CC	1.000	1.000	1.000	1.000	30.5
30	CA	CC	1.000	1.000	1.000	1.000	30.5
31
32	CA	CC	1.000	1.000	1.000	1.000	30.5
33	CA	CC	1.000	1.000	1.000	1.000	30.5
'.
MINOR SHIPYARDS			SHIP COSTS		FIGHTER COSTS
0303-NCL1	NCL	NCL	1.000	1.000	1.000	1.000
0303-NCL2	NCL	NAC	1.000	1.000	1.000	1.000
0303-NCL3	NCL	NSC	1.000	1.000	1.000	1.000
0303-DW1	DW	DW	1.000	1.000	1.000	1.000
0303-DW2	DW	DWG	1.000	1.000	1.000	1.000
0303-DW3	DW	DWE	1.000	1.000	1.000	1.000
0303-FF1	FF	FF	1.000	1.000	1.000	1.000
0303-FF2	FF	FFE	1.000	1.000	1.000	1.000
0303-FF3	FF	FFS	1.000	1.000	1.000	1.000
'.
OTHER PRODUCTION			UNIT COSTS		FIGHTER COSTS
SITE	# BUILT	ITEM	EP	XTP	EP	XTP	FFF
0303-SFB33			1.000	1.000	1.000	1.000
0303-SFB33	1	B10-1	1.000	1.000	1.000	1.000	4.0
0303-SFB33	1	PRIME	1.000	1.000	1.000	1.000
0303-SFB33	2	PDU7	1.000	1.000	1.000	1.000
0303-SFB33	1	CMDPT	1.000	1.000	1.000	1.000
0303-SFB33	1	PRD3	1.000	1.000	1.000	1.000
0303-SFB33			1.000	1.000	1.000	1.000
0303-SFB33			1.000	1.000	1.000	1.000
0303-SFB33			1.000	1.000	1.000	1.000
CONSTRUTION TOTALS:			50.000	50.000	50.000	50.000	980.0

By Ted Fay (Catwhoeatsphoto) on Tuesday, August 16, 2016 - 05:00 pm: Edit

Chuck,

Recommend a line for B10#2. I don't know about others, but I often build 2 B10s in a full F&E game.

Recommend line for Kestrel parts per Nick's suggestion.

Recommend line for homeless ship lines available per Richard's suggestion. Note this is different than the EPs paid for homeless ship support. Once a slot is paid for it is available for a different ship later, so the number of slots should be tracked separately.

Recommend line for recording ship sales and turn number for WYN ship sales.

Recommend line for Rom modules.

Finally, I did not see a response to my suggestion for a new tab on the spreadsheet that tracks navy-wide hull limits on a per-empire basis. Did you want me to take a crack when you're done with the main econ forms? You want to try it?

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 05:52 pm: Edit

Ted:

There will be 10 lines:

Line 1 will be a fixed line for free fighter factors (everyone uses these and they are linked to totals used elsewhere on the new form);

Lines 2-8 will have drop-down titles since the Gorns don't need Kestrel Part tracking but will need a line for their three free PFs per turn;

Lines 9-10 will be customizable for things like scenario specific counts, B10-7, etc.

==========

Tracks for navy-wide hull limits:
Can you guys compile a list by empire of the units, numbers, and post them here?

By Chuck Strong (Raider) on Tuesday, August 16, 2016 - 06:42 pm: Edit

Here is my initial SIMPLE running tallies categories.

TALLY TRACKING
TYPE START ADDED SUBT BAL

Free Fighter Factors
Free PF Factors
Command Points Stockpile
Battleship-1
Battleship-2
Battleship-3
Battleship-4
Battleship-5
WYNCOVIA Account
WYN Trade Rights Available
Drone Bombardment Stockpile
Homeless Ships - A
Homeless Carriers - A
Homeless Ships - B
Homeless Carriers - B
Homeless Ships - C
Homeless Carriers - C
SWARM
SFG Stockpile
S-Boom Stockpile
M-Boom Stockpile
L-Boom Stockpile
PPD Stockpile
Kestrel Parts Stockpile
Victory Conditions
PF Initial Starting Pool
Guilds Treasury
Prime Teams in Play (may make this a fixed tally)
Free Strategic Movement Allotments?
Partial Grid-A EPs
Partial Grid-B EPs
Off-Map Colonies

Complex Tracking Items (Tracked elsewhere on the form?):
WYN Ship-A Sales Tracking; Unit; When; Opens
WYN Ship-B Sales Tracking; Unit; When; Opens
WYN Ship-C Sales Tracking; Unit; When; Opens
WYN Ship-D Sales Tracking; Unit; When; Opens

SP-A/K Modules
SP-B Modules
SP-C Modules
SP-E Modules
SP-G Modules
SP-H Modules
SP-J Modules
SP-M Modules
SP-P Modules
SP-S Modules (Survey)
SP-U Modules
SP-V Modules

SK-A Modules
SK-B Modules
SK-C Modules
SK-E Modules
SK-F Modules
SK-G Modules
SK-H Modules
SK-R Modules

Planet Recovery-A: Method (ENG/MED); Location; Start Turn, Rcovered Turn
Planet Recovery-B: Method (ENG/MED); Location; Start Turn, Rcovered Turn
Planet Recovery-C: Method (ENG/MED); Location; Start Turn, Rcovered Turn
Planet Recovery-D: Method (ENG/MED); Location; Start Turn, Rcovered Turn

Override Production: "Ship Type", When

By Thomas Mathews (Turtle) on Tuesday, August 16, 2016 - 10:09 pm: Edit

HDW-x Modules? These units are used by everyone. While not everyone will use all of the modules available, i.e. Drone (Kzinti only), or PF (all except Federation), they can be changed out during the course of the game.

Add to your SP Module list: SP-R (Repair, Future product?)

By Ted Fay (Catwhoeatsphoto) on Wednesday, August 17, 2016 - 12:48 pm: Edit

Chuck, seems like an excellent way to proceed. Drop downs and customization will help prevent bloat on the spreadsheet.

Comments on tally posted by Chuck:
-I don't think you will need 3 homeless ship and carrier lines. You really only need 1 of each, as once you've paid for a line it's permanent (and you can only have something like 10).

-Victory conditions are complicated. Suggest you have a whole different tab for tracking that. Maybe (maybe) a line on the tally is good for reporting the results of the calculations done on the second tab. Would you like me to work on such a calculator?

-Suggest 3 lines for offmap colonies. Line 1 is total colonies (for calculating income generated by them). 2nd line reports how many colonies found by survey (as opposed to HRS). Third line is how many developed by tugs/convoys. This is important because the total number of colonies you can develop by tug/convoy/COE is limited by how many colonies you've found by survey (1 per 5).

-Your request for navy wide hull units on a per empire basis will take some time to compile on spreadsheets. I'm willing to undertake this project, but it will take me some time (week maybe). Unless someone else wants to take it on? If no one volunteers I'll do it in time.

-Thank you for working on the updated form!!!!

By Ryan Opel (Ryan) on Wednesday, August 17, 2016 - 02:01 pm: Edit

- The problem I see with tracking limited hull units is then you have to go back to the econ sheet when one is destroyed.

- I can see doing this with Tug Pods since they don't get lost nearly as often as a ship.

By Richard B. Eitzen (Rbeitzen) on Wednesday, August 17, 2016 - 02:08 pm: Edit

You need multiple homeless ship lines for adopting more than one empire's ships.

By Chuck Strong (Raider) on Wednesday, August 17, 2016 - 08:10 pm: Edit

In theory, the maximum is three during the GW where one alliance player could adopt homeless ships from three other empires, thus empires A/B/C.

By Chuck Strong (Raider) on Friday, August 19, 2016 - 04:31 am: Edit

Excel Spreadsheet Users:

I need assistance in formatting validations drop down cells. I plan on having the build schedule in one column of the new F&E Econ form and the adjacent cell have a drop down valid selections for what can be built from that scheduled unit. Here is an extract:

SCHEDULED PRODUCTION			SHIP COSTS		FIGHTER COSTS
SITE	SHIP	BUILT	EP	XTP	EP	XTP	FFF
SY-2903	CA	TG	6.000
SY-2903	NCL	NVS	7.000		12.000
SY-2903	DW	DWG	4.000
SY-2903	FF	FFS	4.000

My ship selection data table would look something like this:

Schedule Ship	Selection Ships
CA	CA	CC	TG	CVS	DD*;	FF*
NCL	NCL	NVS	NAC	LTT	NSC	FF*
DW	DWE	DWG	DWV	DWS	DWT	FF*
FF	FFE	CFF	FCR	FFS	FFT	FFV

I DO NOT want a series of *IF** statements (I think I need to use the "INDIRECT" function but I don't quite understand how to us it in the validation criteria. I want to use the already populated scheduled ships to drive a drop down validated list.

Example:
The schedule says I have an NCL slot available which means (based on the available selections I could build a (standard) NCL, NVS, NAC, LTT, NSC, or downgraded to an FF. I want the validation list to show NCL, NVS, NAC, LTT, NSC, or FF*.

Please post the coding mythology here that need to to be placed into the validation formula bar and any steps to make this possible.

Thanks.

By Ted Fay (Catwhoeatsphoto) on Friday, August 19, 2016 - 11:27 am: Edit

Sorry, that is beyond my Excel skills.

Since no one has volunteered so far, sometime in the next couple of weeks I will get you that empire-wide limits information.

By Glenn Hoepfner (Ikabar) on Friday, August 19, 2016 - 11:46 am: Edit

Ted, and Chuck,
I'm going to look into the "INDIRECT" function as well (I've never used it). I consider myself well adapt in Excel but I only learn what I need to learn (I'm self taught and yet I know more about Excel than most people I know . . . not to toot my own horn).
Is "Indirect" a formula for a newer version of Excel? Oh heck, don't answer. I'll find out myself by EOD.

By Ken Kazinski (Kjkazinski) on Friday, August 19, 2016 - 03:23 pm: Edit

Have you thought of using VBA and having functions instead?

User functions provide a lot more flexibility when it comes to complex queries and lookups as you can do loops, if then else type calculations.