Disenfrancised
Beep Beep
Balls! That's what you get for adding them to the end rather than the middle of the sheet. V7.2 reworked coming soon
Pre-SysNES2: Beta-testing and Submission
- Thread starter Disenfrancised
- Start date
Disenfrancised
Beep Beep
Okay this should be fixed, also has the construction tech requirements based on size finally displaying correctly.
Sure. Just had a look and 500 is really pushing it...
Another question though: Are Ion cannons meant to give int and EW dubuffs so high? Couple two together and they RUIN an armoured opponent (20 armour, 12 particle dmg with EMP => 22 int debuff and 94 EW debuff). That will make most ships worse than useless!
I'm just amazed....
EDIT: simulation
Lets go with 600 e for fleet.
1000e/1000s that you can spend as you want on Refinement.
Include racial bonus. And if you could designate your fleets operational role (as Symphony D. has been doing).
I'm going to be attempting to designing IS War Fleets with the role of destroying ships (so I need to include Range for 2 years or more, and IS Transport)
Disenfrancised
Beep Beep
Sure. Just had a look and 500 is really pushing it...
Another question though: Are Ion cannons meant to give int and EW dubuffs so high? Couple two together and they RUIN an armoured opponent (20 armour, 12 particle dmg with EMP => 22 int debuff and 94 EW debuff). That will make most ships worse than useless!
I'm just amazed....
Hmm that does seem a tad high, I think I forgot to connect up a fractional power in the equation.
It is very variable though - sometimes that only going to give an int debuff of 1 and then you're borked if you've taken some risks.
Use =IF(AND(D27="Y",F33>0),RANDBETWEEN(1,10),0)+IF(AND(D28="Y",F33>0),RANDBETWEEN(1,ROUND(1+(F33*0.5*MAX(H21,1))^0.5,0)),0) for the int
and =IF(AND(D27="Y",F33>0),RANDBETWEEN(1,20),0)+IF(AND(D28="Y",F33>0),RANDBETWEEN(1,ROUND(1+(F33*0.5*MAX(H21,1))^0.5,0)*5),0) for the EW instead until V8.
It'll make shields more than a curiosity for sure
.
Disenfrancised
Beep Beep
Actually, come V8 shields will have additional reductions on the int and EW debuffs beyond the damage reduction.
Disenfrancised
Beep Beep
Symphony D.
Deity
I'm not getting Microwave Lasers to show up under the #EM/EM Total Damage output at all, and Microwave Beamers are showing up as short-range damage.
Are you sure?
I get Microwave Beamers to give a result for both Long and Short range (cells K21 = S, M21 = L). And normal Microwave lasers give no dmg at long and dmg at short.
Are you just looking at the wrong cells?
Symphony D.
Deity
I'm many things, but I'm not blind.
I can plug in an arbitrary number of Microwave Lasers and they don't add cost, mass or size, don't drain power, and don't add damage or show up. (They do show up in the Component Count though.) Likewise I can make whatever kind of design with Microwave Beamers and they only show up in short range damage.
It could be that there are finally too many conditions for Excel 2003 to convert the file properly, but this is what I'm seeing.
I can plug in an arbitrary number of Microwave Lasers and they don't add cost, mass or size, don't drain power, and don't add damage or show up. (They do show up in the Component Count though.) Likewise I can make whatever kind of design with Microwave Beamers and they only show up in short range damage.
It could be that there are finally too many conditions for Excel 2003 to convert the file properly, but this is what I'm seeing.
Symphony D.
Deity
There's nothing to upload. I haven't made any changes, and Excel 2003 opens .xlsx in read-only format as it has to convert them since they're made for Excel 2007 and beyond. This error occurs on opening the downloaded file without doing anything to it.
If you're not seeing the same problem, it has to do with how it's being converted, and the only way you'll see it is to open it with the same program. What's changed to make v7 produce errors when v6 didn't, I don't know.
If you're not seeing the same problem, it has to do with how it's being converted, and the only way you'll see it is to open it with the same program. What's changed to make v7 produce errors when v6 didn't, I don't know.
Symphony D.
Deity
After some investigating I think this is a legitimate error. In CC, cell BO158, the contents are "=IF(Design!H154=1,BN158,BL158)*Design!G154", and for BM158, the contents are "=IF(BL158>0,1,0)*Design!G154". Row 158 is Microwave Lasers. Cell G154 in Design is the count for Microwaver Beamers. Microwave Lasers can be whatever and of course it'll register as zero because it's reading for Microwave Beamers.
CC cells BM154 and BO154, which read for Microwave Beamers, are pointing at Design G150, which is now Autoloaders. Having 1 Microwave Emitter with 5 Basic Fusion Cores and 3 Salt Sinks produces 12S Total EM Damage, with 1EM weapon counter. Adding 1 Autoloader bumps it up to 2EM weapons counted, with 9S and 30L damage.
I think when these components were added the cells weren't changed, because I don't see how a conversion error would do this, and it's reading for entries and not finding them properly. This is ShipDesigner2_v7.xlsx, right out of the SYS_V7_Corrected.zip.
CC cells BM154 and BO154, which read for Microwave Beamers, are pointing at Design G150, which is now Autoloaders. Having 1 Microwave Emitter with 5 Basic Fusion Cores and 3 Salt Sinks produces 12S Total EM Damage, with 1EM weapon counter. Adding 1 Autoloader bumps it up to 2EM weapons counted, with 9S and 30L damage.
I think when these components were added the cells weren't changed, because I don't see how a conversion error would do this, and it's reading for entries and not finding them properly. This is ShipDesigner2_v7.xlsx, right out of the SYS_V7_Corrected.zip.
There is a compatibility issue, just tried to save it as a 2003 worksheet. Odd thing is that as far as I can tell all the issues are with the colour conditionals that Dis is using.
EDIT: Ah. Sorry I've been an idiot, I'm still utilizing V7 but I added my own corrections for things. In fact it looks like the same error that I flagged with dis, just moved somewhere else...
EDITEDIT: Actually its worse than before: everything from CC sheet row 149 below is wrong.
EDITEDIT: Try this:
Spoiler compatibility report :
EDIT: Ah. Sorry I've been an idiot, I'm still utilizing V7 but I added my own corrections for things. In fact it looks like the same error that I flagged with dis, just moved somewhere else...
EDITEDIT: Actually its worse than before: everything from CC sheet row 149 below is wrong.
EDITEDIT: Try this:
Disenfrancised
Beep Beep
Alright I'll have a fixed version out later tonight - the adding the new components updated same page references but not off page references (despite doing it right the last time I added cells).
Disenfrancised
Beep Beep
Sorry about this bit of an emergency came up.
Here is the V& ship designer fix with the tables realigned, I also redesigned some of the display for the weapons output to make the new model easier to parse.
Shipdesigner2_V7_Fix
Here is the V& ship designer fix with the tables realigned, I also redesigned some of the display for the weapons output to make the new model easier to parse.
Shipdesigner2_V7_Fix
Okay:
Lets go with 600 e for fleet.
1000e/1000s that you can spend as you want on Refinement.
Include racial bonus. And if you could designate your fleets operational role (as Symphony D. has been doing).
I'm going to be attempting to designing IS War Fleets with the role of destroying ships (so I need to include Range for 2 years or more, and IS Transport)
If you can get this done tonight/sat, I might be able to get some done on Sat evening or Sunday.
Lets go with 600 e for fleet.
1000e/1000s that you can spend as you want on Refinement.
Include racial bonus. And if you could designate your fleets operational role (as Symphony D. has been doing).
I'm going to be attempting to designing IS War Fleets with the role of destroying ships (so I need to include Range for 2 years or more, and IS Transport)
If you can get this done tonight/sat, I might be able to get some done on Sat evening or Sunday.
Thlayli
Le Pétit Prince
It's going to take me some time to try and make optimized designs with the new particle system.
Similar threads
