This Page
Last Updated





Aug 23rd, 2005
NEW ULTRA Revision Released
    Starfire Design Studio announces the release of the Version 7 of ULTRA Starfire. Ultra Starfire is a merger of Galactic Starfire and the Elite suppliment and all errata -- changes in recent months have slowed dramatically and so it is very stable now. There are a few changes to the game system. The biggest change is that Ultra Starfire is a 100% PDF product with lots of crosslinks.
    Click here to learn more
    Order it now!
    Suggestions for improvements to the Ultra Starfire PDF are welcome.

Feb 22nd, 2005
GSF Errata 4.14 available

Version 4.14 changes from Version 4.13
1,19,D6.02.1 add "PDC armor is energized and grounded. This prevents E damage from skipping armor. Armor is destroyed on a 1:1 basis."
1,28,F2.03 Add the the end "When rolling to activate a datagroup, determine the activation number individually and use the lowest one of the group."
1,52,M1.02.1 replacement: Ground-Based Industry A population has (PU/200 + IU/50) (FRD) construction facilities with the same build rate as the races SY. All projects and tasks, except those involving PDCs or Ground Facilities, cost 150% the project price/task. Assembly tasks cost an additional +50% of the hull cost. LEL: ground-based industry counts as having EL 0. No ground based industry exists on asteroids or HGT.
1,55,M6.03 AF can add systems but must shutdown while doing so.
2,17,Y11.05 IND race Spending Policies
LEL pay 35% of income per turn for R&D. No projects or anything else occur but that cares for all the automatic EL and SL gains that occur in N12 and N12.01 and N12.02.
LEL pay 15% of income per turn for industrial upgrades. This money is effectively lost.
LEL pay 25% of income for Qv army purchase and maintenance.
LEL have the remaining 25% of income to either buy IU, buy Qv, or if IND-2 and having the technology to do so, buy hulls and systems.
2,17,Y11.06 Pre-IND race Spending Policies
Pre-Ind lose all money generated unless controlled by a HEL race. In that case, Pre-Ind lose 50% of income to R&D
2,17,Y13 - Chart 141-150: "... but no surveying." should be "but NOT surveying."
AP.02 1st table Add "A CD is a special smaller version of Drone1-cm and does not have inherent sensors."
2,40,Table7 add Smcft and AP Base Range (often listed as inherent sensor range) is Medium Range. Combat range is 1/2 base range. Short range is 50% of combat range. Scan range is 20% (FRD) of Short Range.


Jan 4th, 2005
ULTRA STARFIRE OFFICIALLY RELEASED
    Starfire Design Studio announces the 2nd release (first usable) Version of ULTRA Starfire. Ultra Starfire is a merger of Galactic Starfire and the Elite suppliment and all errata. There are a few changes to the game system. The biggest change is that Ultra Starfire is a 100% PDF product with lots of crosslinks. Current size is 295 pages with Tech Items going up to SL 50.
    Click here to learn more
    Order it now!

PS: Since the order site is down, if you want just Ultra, paypal $21.00 to marvlamb@comcast.net and include your name, address, phone number and that you want Ultra.
    Note: the following e-mail domains do not support the Ultra file size "@cox.net", "@gci.net", "@netzero.com", and "@netscape.net". Yahoo accounts are free and work (recommended).
Dec 23rd, 2004
Marvin (and thus the SDS) is on vacation until Jan 4th, 2005. Do not expect any responses to E-mail or Orders until that time. Merry Christmas and Happy Holidays!!


Nov 30th, 2004
NEW PRODUCT RELEASED
    Starfire Design Studio announces the release of the Beta Version of ULTRA Starfire. Ultra Starfire is a merger of Galactic Starfire and the Elite suppliment and all errata. There are a few changes to the game system. The biggest change is that Ultra Starfire is a 100% PDF product with lots of crosslinks.
    Click here to learn more
    Order it now!
    Suggestions for improvements to the Ultra Starfire PDF are welcome.

Oct 2th, 2004
   GAME PARTY IN ORLANDO FLORIDA!!
   On Sunday, Dec 26th from 1:00 PM to Midnight the Starfire Design Studio will host its 2nd Annual Game Party in Orlando, Florida. I will be there and will provide snacks and dinner (Bring your own beverage and please limit the alcohol). The cost will be $5.00 (check please) at the door. We will play Starfire or any other game your interested in (bring your own game). We can even just talk about Starfire. Please contact me at marvlamb@comcast.net to confirm your reservation (and those of any friends since I have limited space) and to get directions.
   On Thursday, Dec 29th from Noon to Midnight, a 2nd Party in the same location will occur. We will play games and talk about Starfire's future. Again, bring your own beverage, $5.00 check, and get your reservation confirmed.
   Starfire Event at the Parties
   Elite Starfire, 20,000 MC, max SL 8.
   If you have a suggestion for another type of battle you'd like to fight on one of those days, please let me know and I can post the information here.

Sept 28th, 2004
NEW PRODUCT
    Starfire Design Studio announces the pending release of ULTRA Starfire. Ultra Starfire is a merger of Galactic Starfire and the Elite suppliment and all errata. There are a few changes to the game system. The biggest change is that Ultra Starfire is a 100% PDF product with lots of crosslinks.
    Initial release (Beta) is planned for late November.
Click here to learn more
    Pre-Order it now!
    Suggestions for improvements to the Ultra Starfire PDF are welcome.

Sept 28th, 2004
CAMPAIGN SUPPORT

    Starfire Design Studio has worked out a deal with CorbyNova and Digital Gamers to make the CorbyNova Website the official Strategic Game support module. In the future, CorbyNova will be able to export battle information directly into the coming Digital Gamers Tactical Battle module.

Sept 28th, 2004
Updated Encyclopedia Galactica

The following races have been added to the Encyclopedia Galactica
  • The Umbra of Vestrii
  • The Corsairs Of Tangri
  • The Kess
  • The J'Rill
Aug 22nd, 2004
GSF Errata 4.13 available

Version 4.13 changes from Version 4.12
1,23,D9.06.2 Change the word "including" to "excluding".
2,25,AP: Add AP shot defense is always 100%.
AP.02 1st table: Add "A CD is a small version of the Drone1-cm and does not have the Drone1's inherent sensors."
2,40,Table7: Change Long ranges to Yca-1440; Ycb-4320; Yce-7200; Yci-10080; Ycm-12960; Ycn-15840; Yco-18720. Fighters and gunboats have a scan range of 1. Drone1 has no inherent sensors.

Mar 16th, 2004
GSF Errata 4.12 available

Version 4.12 changes from Version 4.11
1,22,D7.04.1 Add " Losses are totaled for all battles in 30 day period that occur in the same or adjacent system - this might occur in situations where gunboats constantly strike a fleet over weeks as they cross a couple of systems, or more. This paragraph is not definitely always 30 days or always same or adjacent systems. It is much more about the nature of a particular attack campaign. A fleet engaging multiple enemy fleets (or the same fleet repeatedly) as they travel can be worn down over time to the breaking point whereas each enemy fleet starts whole (no losses). A fleet which stops and defends a WP or planet without being harassed for a period of 3 days resets its loss level to zero. Receiving reinforcements does not reset the loss level unless the reinforcements are at least 50% of the original fleet size or 100% of its current size."
1,82,Add T3.14.6 NPRs Treaties and Amalgamation
Any third party NPRs, assuming T3.13.5 does not apply, keep the treaty type they had with the race that offered amalgamation, even if that treaty type is worst than the treaty they have with the race accepting amalgamation. The sole exception is when the NPR and the accepting race have a partnership in which case that is the new treaty.
1,94,V4.04 change "contact" to "full communications"
Add to AP.01.2 XOg racks are not allowed on AP.
Add: "Errata: Each -1 or +1 "targeting" modifier increases or decreases the number of shots by 15% (FRN). This applies to things like EM, EMS, transit effects, and now includes Crew Grade. It does not apply to specific weapon modifiers (i.e. Pg are still at -1 shot). This is also used instead of "shot defense" modifiers for strikewave targeting. Rounding in this case occurs per firing unit, per firing datagroup, or per firing fleet, which ever is most accurate. Thus, a ship firing shots at x number of small units, would total the shots against all small units, and then apply the targeting modifier adjustment, and then round to see how many shots were added/subtracted. Then that player reduces the shots against each small unit in proportion to the number applied against each target."

Rule Numbering Changes:
C4.04.5 should be C4.04.2.
D9.02.1 (the 2nd one) should be D9.02.1.1
K2.03.2 and K2.03.2.1 (the first ones) should be K2.03.1 and K2.03.1.1 respectively.
The 2nd N9.03.3.1 should be N9.03.3.1

Jan 14th, 2004
   New Player aid
   Starfire Design Studios is considering making a PDF with all the tech trees in a new format. It should make things easier to read. Tell us what you think on the Starfire list. Sample Laser Tree

Jan 14th, 2004
   MAP Shortage
   I have discovered that I have less that 20 complete maps left and I have adjusted prices accordingly. I have a number of the OTHER map parts but the map part with numbers 8 and 9 on it are about gone. I still have plenty of unfolded maps (perhaps 200-250). Once all those are gone, I'll decide whether to print more maps or now. As it is rather expensive and I don't sell them that fast, that doesn't look terribly promising unless I do a pre-order thing.

Jan 14th, 2004
   PAYPAL
   Starfire Design Studios now accepts Paypal at marvlamb@comcast.net.

Dec 8th, 2003
   GAME PARTY IN ORLANDO FLORIDA!!
   On Sunday, Dec 28th from 1:00 PM to Midnight the Starfire Design Studio will host its 1st ever Game Party in Orlando, Florida. I will be there and will provide snacks and dinner (Bring your own beverage and please limit the alcohol). The cost will be $5.00 (check please) at the door. We will play Starfire or any other game your interested in (bring your own game). We can even just talk about Starfire. Please contact me at marvlamb@comcast.net to confirm your reservation (and those of any friends since I have limited space) and to get directions.
   On Thursday, Jan 1st (New Year's Day) from Noon to Midnight, a 2nd Party in the same location will occur. We will play games and watch football. Again, bring your own beverage, $5.00 check, and get your reservation confirmed.
   Starfire Event at the Parties
(Optional) Take 25,000 MC and build a fleet from Elite (Any SL!!). For Sunday, only offical technologies are allowed but for Thursday, anything in Elite is allowed. Final results will be posted on the Website.
   If you have a suggestion for another type of battle you'd like to fight on one of those days, please let me know and I can post the information here.

Oct 14th, 2003
   GSF Design Notes

   I decided not to worry about all the misc stuff in the design notes and instead provide them to all. If your interested in helping to clean them up and organize them, let me know. The design notes are downloadable from the GSF updates page.

Oct 14th, 2003
   GSF/Elite errata

   GSF/Elite errata is now available from the GSF updates page (button on left).

Oct 14th, 2003
GSF Errata 4.11 available

Version 4.11 changes from Version 4.10
In errata 1,20,D7.01.2 change "normally" to as "non-LOD" 1,17,D5.03 Add bullet "* All additions/subtractions to sensor ranges occur before any percentage increases or decreases are applied."
1,41,K2.03.4: add EL2 hulls, including prototypes, cannot be built during the pre-turn.
1,41,K2.03.5 add Optional Rule: Allow the building of prototypes, at full cost, during the pre-turn.
1,51,Add L7.02.3 Units which do not receive maintenance can not be repaired during the same month.
1,84,U5.04 Add below Table "Information is tech data in reference to the players current SL in that particular branch of science. Thus, a player with Force Beam SL 3 captures 6 Fe systems. In order to understand the tech data received, about the Fe system, the roll must be 91 or greater because Fe is SL 7 and that is 4 SL above the players current SL of 3."
In errata 2,10,Y2.02: The Ind-1 modifier should be "Divide PU by 2 (FRU)".
2,26,Construct. Tree: Add EXa to the EL 2 line.
2,27,Electronics: Branch to EM occurs at SL 5.
2,30,Lnk
{Modified} Lnk.01 Damage as a single weapon, but for each added weapon firing, range is +1 (at 1 damage) OR to-hit is +2 (max to-hit of 8) OR damage is +1. EX: 3 linked beams could be +1 range and +2 to hit OR range is +1 and damage is +1.
{add} Lnk.01.1 Linked weapons can fire through the atmosphere of a planet at -2 damage. Before fire through atmosphere, the ship must not have fired the involved beams during the previous 2 turns.
{modified} Lnk.03 Link R&D x cost (per RP) is lnk quantity times 10+10. I.e Lnk 2 is 30 per RP or 300 for 10 RP.
{add} Lnk.04 High level link abilities can split fire. I.e. Lnk4 could fire 2 Li at one target and 2 Li at a 2nd target on the same turn. All weapons must still be identical.
2,34,XO: XO racks are allowed bases.


June 3rd, 2003
   Shipyard Not Working?

   A Shipyard owner recently made this comment. "While the shareware version works perfectly, you must (as noted in your 'if error read me file') replace the COMDLG32.OCX file in the Windows/System32 folder. Shipyard now works fine."

May 30th, 2003
   PRICE REDUCTIONS

   See the ordering page for a number of price reductions including GSF, Elite, the 3rdR Game and Scenario Packs    Order Page.

Nov 15th, 2002
   FTP sites working!

   There are now TWO FTP sites.    http://ftp1.24invest.com/ftp/ and http://www.galacticstarfire.com/ftp/. The ELITE spreadsheets are available on at least one of these sites.

Oct 26th, 2002
   ELITE IS FINAL!

   Another month has passed at the Starfire Design Studio, and ELITE has become final. While Section N needs to be redone for clairity, there are almost no rule changes in that section. Therefore, I'll go final with ELITE and when Section N is able to get done from the person doing it, I'll release that. There might be a few more minor changes but I think that I can either (if they are major) use red font to show the changes or errata them in a small document. The nice thing about Electronic Publishing is the ability to replace documents which fully corrected ones and to insert things you forgot about, like Table of Contents and Index.

Sept 28th, 2002
   After almost two weeks of frustration, I'm finally able to update the Starfire website again.
   Of particular news is that the main Starfire FTP download site is also offline as is the FTP site I've been using for the last few months to allow downloads of large electronic products (such as Elite and UTM). This 2nd site will probably not be reactivated and instead Starfire will, in cooperation with its online partner Digital Gamers, be using a site that will initially allow you to download (on demand) the products that you have previously purchased (that is ANY previously purchased "electronic" product). This will require you to be registered and will limit you to downloading from a single location. As I'm sure that your concerned about your privacy information (no credit card information will be passed to Digital Gamers) and only information on those who have REGISTERED will digital gamers will be passed. As the original Starfire Design Studio privacy policy was that no information is EVER, nor has EVER, been given to any other entity (company or individual), I've never felt a need for a privacy policy. However, with the new alliance with Digital Gamers, I am going to be needing a privacy policy. Initially, I'm going to start with theirDigital Gamers Draft Privacy Policy. Please check this out for any concerns and let me know if this is an issue for you.
   Digital Gamers will also be handling the FTP site for regular up and downloads soon, so that should be back in action within a couple of weeks at the worst.
   "Digital Gamers is also going to be doing lots of other things for the Starfire Community as part of getting the online version of Tactical Starfire up and running. A couple of things of interest, in particular, include a JAVA based version of Shipyard (cross-platform compatible, of course) and The Academy. The Academy is an interesting idea and I'd like to see a number of you submit articles on the tactical aspects of Starfire (ESF, chase battles, initiative importance, weapons discussions (GSF and Elite)). There is also room for Strategic and Fleet operations level "papers". Please don't be worried about the "paper" wording. These discussions are expected to help both novices and/or intermediate level players get up to speed with Starfire. On thing you might be asking yourself is "Why should *I* spend my time writing such a paper?" The answer is simple. Such papers help players overcome the initial learning curve. And while you might be giving away some of your super-secret tactics and strategy, it will be worth it in the long run as the Starfire Community grows by leaps and bounds. Instead of having dozens of players interested in playing at a time, you'll have thousands. You'll never lack having people interested in joining a campaign, filling in for a drop out or just playing a pickup (or even ladder) tactical battle to keep your skills sharp for your next online battle in a campaign. So be selfish and write that paper.

Sept 17th, 2002
   Galactic Starfire's expansion ELITE (electronic PDF only) is now available from the ordering page. Please note that this product is in a **beta**-release version. However, free updates will be provided as they become available. If you want to provide input into the Elite product, here is your chance and it costs you nothing extra. This product will likely range in the area of 200 or so pages once everything is completed. The outline looks something like Elite Index

July 6th, 2002

Announcing StarfireTM Online!
      Digital Gamers
Digital Gamers, Inc., in collaboration with the Starfire Design Studio, is proud to bring you an exciting new series of games based on Galactic Starfire, the 4th edition of the Stature game system. New opportunities for victory await you as you go head-to-head online against players from around the world. Play tactical battles in pick-up games or confrontations generated in a strategic campaign. Join your friends in a private on-line Space Mastered campaign, competing against each other and non-player races for control of your galaxy. Or build your empire and compete against thousands of players in a massive multi-player persistent on-line universe, And if you are a Space Master who has been looking for tools to support your campaign,, make use of the Space Master campaign aid service.

      Starfire Tactical Combat
Compete online in the classical game of space combat. Customize battlefields to environments ranging from a starless nexus to a heavily fortified warp point junction. Choose victory conditions ranging from last man standing to specialized objectives. Set constraints on forces including available technologies, technology levels, hull sizes, and fleet size/cost. Import ships from Shipyard(TM) or use the built-in editor to design new ships. Save ship designs in a private library, and draw from that library to define your fleets. Record the events of your battle for download and review in an after-action report.
      Requirements: Sun-compliant 1.2 JVM Available: 2Q2003

      Space Master Aid
Few games offer a job as challenging as that of the Starfire Space Master. Generate hundreds of star systems for the campaign. Link them together through warp points, Audit players for "accounting errors." Manage non-player races. Generate contacts between potentially hostile forces. What is the total capacity of that warp point? How long does it take to transit from System A to System X? Space Master Aides give you tools to manage the data driving your campaign. And the tools interface directly to the Tactical combat system, allowing you to set up battles for your players who are also subscribers.
      Requirements: Sun-compliant 1.2 JVM Available 4Q2003

      Premium Space Mastered Campaign
Play the full Starfire system in a private campaign of up to ten players. Issue orders at the strategic time scale, and take command at the tactical time scale as you contact hostile forces, Negotiate with players and non-player races - or just overrun them - as you struggle for control of the galaxy. The choice is yours.
      Requirements: Sun-compliant 1.2 JVM Available: 2004

      Starfire RTS
Experience the challenges and rewards of running an interstellar empire in real-time. The Starfire RTS (Real Time Simulation) allows you to run an empire in a shared, persistent universe with thousands of other players. Time is compressed to allow the passage of several game days in a single real-world day. React to events in real-time as they occur, or "catch up" while the game clock is suspended during evening hours. Use pre-defined behaviors to control political, economic, and military behavior, or use the built-in scripting engine to program your own behaviors. Requirements: Sun-compliant 1.2 JVM; some optional messaging features will require a pager, cell phone, or email account
      Available: 2004


Features and system requirements are evolving as products develop. Digital Gamers is committed to supporting the broadest range of target platforms possible, but performance requirements may cause software to perform inadequately on some low-end hardware.

starfire and Shipyard are trademarks of State Design Studio,
www.starfiredesign.com

Digital Gamers and the Digital Gamers logo are trademarks or service marks of Digital Gamers, Inc.


Jul 1st, 2002
GSF Errata 4.10 available

Version 4.10 changes from Version 4.9
1,10, Add "C6.02.7 For a unit in transit racks, the following systems cannot be operated: shields, weapons, engines, T, Td, X, Z, Zc, bays. Point defense can only engage inbounds aimed at the PD mounting unit. All other systems operate normally."
1,20,D7.01.2 Units may use LOD mode to transit WPs but LOD is detected normally and all other penalties still apply. All sensor ranges, including standard, are reduced by 50% (FRD).
1,20,D7.02.1 Change "Primary beams" to "Precision weapons".
1,22,D9.05.1 Inherent buoy sensors detect all starship DF modes except LOD and OFF modes. Note: To be in LOD mode your shields must be down!
1,35,H1.04.3.1 Add: "The ship must have at least one cargo hold."
1,52,M1.02.1 No ground based industry exists on asteroids or HGT. Change "? those involving PDCs, ?" to "?those involving PDCs or Ground Facilities, ?". FRD for ground based industry amount.
1,54,M4: Scrap value on the table should be 30%, not 1/3rd.
1,60,N9.06 A combined project is treated as one development project. Costs are determined as if each project was separate and of its own type (SL/development) -- with the additional 25% cost. If any item/SL in the combined project is critical/hazardous, etc. then the whole project is of that type (or the worst type of two types). All breakthroughs leading to the individual items in the project must be opened before the project can begin.
1,75,T3.04 Add "T3.04.3 Conquerors are required to maintain SEC forces on slave planets at 1 sec per 5 PU. This force is maintained at zero cost by the slave race and grows as the slave race grows. When subject race is achieved, the SEC maybe moved or sold."
1,77,T3.10.5.1 When the fee is split, the trade bonus is earned on the second turn of payment.
1,82,U "Ships with only armor and/or holds remaining are not eligible for section U rules on intelligence."
1,83,U4.03 Damage systems cannot be evaluated.
2,15,Y8.02.2 Result 81-00 should refer to [App6-Y8.02].

June 18th, 2002
   Third Edition Starfire's UNIFIED TECH MANUAL (UTM) is now complete. This manual (electronic PDF only) is now available from the ordering page. This product is in final form and any updates will be free of charge. This is the first product from the new 3rdR Design Group.

June 17th, 2002
   Galactic Starfire's expansion ELITE (electronic PDF only) is now available from the ordering page. Please note that this product is in a pre-release version. However, free updates will be provided as they become available. If you want to provide input into the Elite product, here is your chance and it costs you nothing extra. This product will likely range in the area of 200 or so pages once everything is completed. The outline looks something like Elite Index

ORIGINS 2002    Plan for the Future! - June 17th, 2002
Next year Origins will be run by GAMA on July 4-7, 2002. Expected attendance at Origins 2002 is 10,000 people. And I'll present running the Starfire Tournament.
GameBase 7 will be running the entire Boardgame area at Origins.

Starfire Tournament --- 2002
Qualifier Rounds
Thur 10 AM, 12 PM(noon), 2 PM
Fri 12 PM (Noon), 2 PM, 5 PM, 7 PM
Sat 10 AM

Semi-Final -- Sat Noon
Final -- Sat 2 PM

STARFIRE SEMINAR -- Sat 7 PM Meet at GameBase 7 HQ (maybe changed later).
   A MAJOR ANNOUNCEMENT WILL OCCUR AT THIS SEMINAR!

Prize from SDS -- $20 Gift certificate and possible medal.

Cost Standard Generic Ticket price.

Wording on the event
Galactic Starfire -- A meeting engagement between two small squadrons occurs in deep space. Who will survive? Top four scores advance to semi-finals Saturday at Noon.

If you are willing to run the tournament for a few hours or help out, let me know.
GENCON 2002    Plan for the Future! - June 17th, 2002
Next year GenCon will be run by Wizards of the Coast on Aug 8-11, 2002. Expected attendance at GENCON 2002 is 25,000+ people. And I'll present running the Starfire Tournament.

Starfire Tournament --- 2002
Qualifier Rounds
Thur 10 AM, 12 PM(noon), 2 PM
Fri 12 PM (Noon), 2 PM, 5 PM, 7 PM
Sat 10 AM

Semi-Final -- Sat Noon
Final -- Sat 2 PM

STARFIRE SEMINAR -- Sat 7 PM Meet at GameBase 7 HQ (maybe changed later).

Prize from SDS -- $20 Gift certificate and possible medal.

Cost Standard Generic Ticket price.

Wording on the event
Galactic Starfire -- A meeting engagement between two small squadrons occurs in deep space. Who will survive? Top four scores advance to semi-finals Saturday at Noon.

If you are willing to run the tournament for a few hours or help out, let me know.

Mar 8th, 2002

ATTENTION:
The SDS credit card processing computer crashed today. Until the problem is fixed, all orders processing must be halted. Anticipate a 1-2 week delay. Sorry for any inconvenience.

Jan 17th, 2002
Version FF spreadsheet V2.01 available!!!!
Invasion calculator had a few errors, primary was not adding the modifier for number of turns the invader has been on the planet.
CFN shipping of IN-SYSTEM Qv and H is wrong
J31 and below (fill down) should be =INT((499+$H31*VLOOKUP($I31,PCF,5,0)*IF($E31=0,0.1,IF($E31=1,0.5,1)))/500)
K31 and below (fill down) should be =INT((0.999+$H31*VLOOKUP($I31,PCF,7,0)*IF($E31=0,0.1,IF($E31=1,0.5,1))))

Multiple problems with R&D page. Made the following changes
F8 (Fill down to F28) becomes =IF(C8>0,E8/10,0)*W8
F32 (Fill down to F39) becomes =IF(AND(C32>0,E32>0),(E32+$M$3*0.01)/10,0)*W32
G8 (Fill down both sections through G39) becomes =IF(D8="","",IF(C8>D8,"extra RP",IF(OR(M8="",M8=" "),"facility",IF(C8>MaxRP,MaxRP*F8*W8+(C8-MaxRP)*F8*X8,C8*W8*F8)+IF(I8-C8>=10,0,(10-(I8-C8))*W8*F8))))
W8 (Fill down both sections through W39) becomes =IF(I8>0,IF(AND($T8="x",OR($N8="x",$O8="x",$P8="x",$Q8="x",$R8="x",$S8="x")),200%,100%)*VLOOKUP(IF($A$4-B8>4,4,$A$4-B8),SLvsEL,3,0),0)*(1+SLcost)*IF(GovType="Hive Mind Race",1.5,1)*IF(OR(V8="y",V8="x"),1.25,1)
X8 (Fill down both sections through X39) becomes =IF(I8>0,IF($P8="x",1,IF($S8="x",2.5,IF(OR($R8="x",$O8="x"),3,IF($N8="x",4,IF(OR($T8="x",$Q8="x"),5,1))))),0)*(1+SLcost)*IF(GovType="Hive Mind Race",1.5,1)*IF(OR(V8="y",V8="x"),1.25,1)
Other sheet, cell A31 has the wrong sum range. The correct formula is =SUM(C32:C38).
Summary sheet, cell I19 has the wrong formula. Should be =Other!A40

Jan 14th, 2002
New Version FF spreadsheet available!!!!
Changes and new features -- version V2.00
Major error previous versions -- in cell of Turn 0, Summary!H28. This should have the formula from the cell below except the last 9 should be an 8.
Military Forces retained at home now correct.
Colonization Policy was not being correctly calculated.
Income from Conquered populations no longer affects the cost of R&D but still affects CFN size, as it should.
CFN size is now based on total GPV (imperial income plus conquered income) plus trade income as indicated by new errata.

WARNING version FF of the sheets is not compatible with previous versions due to new columns added to the maintenance page and R&D page!!!

   NEW FEATURES
All types of construction should now function properly including pre-fab and assembly of full units.
Pre-fab units are tracked on the maintenance page similar to mothballed units (except location is not tracked). Undeployed Buoys and drones should be tracked as pre-fab. Deployed buoys and stuff can be assembled (zero cost, minor capacity usage but that can be reduced to 1 HS) to show on the "maintenance/in use" section. Used materials can be destroyed via col Y or normal destroy unit method.
Furthermore, all types have been automated in as many areas as possible. Fast assembly is automatically 50% cost and assmbl is zero cost. Both assmbl types remove units from pre-fab. Prototype costs are automatically calculated and included. New class units are 20% more expensive. Planet build costs are included. Examine unit and Refurbish unit project types add and use the proper amount of shipyard space. Repaired units are automatically tracked and not added to the total number of units. Refit unit warning to delete old class on the summary page BUT see next item.
Refits just got easier as you can now place a -{old class name} after the rf indicator and the old class will be deleted from the maintenance page on the same turn the new class appears. See comment in Yards!U50 for more information and examples.
Disassemble projects [M2.03] added and they automatically generate cost (hull cost) and project size (HS) and are completed in a single turn per section M.
Combined projects now supported.
Added to Spy page a list of when you gain certain informational bits from an NPR race, a WP Transit chart, and a War Check resolver for Space Master use.
Reformatted INV Qv and H page and added an Invasion calculator for Space Master use.
Added Technologies available summary to the tables page.
Added to fleet page a total lookup of ships, their designs, and speeds. This will help avoid lots of jumping around to figure out how fast ships can travel.
Added NPR creation check list on the summary page.

Jan 14th, 2002
Errata Control
Version 4.9 changes from Version 4.8
L4.02.1-A The Base CFN size is based by the total of Imperial planet GPV, conquered planet GPV, and trade income. Temporary incomes such as pillaging, wealth transfers, lease revenue, scraping, and IU sales do not increase the Base CFN size.