You are not logged in. Please login or register.
Play nice. (This means you.)
Logins from the previous forum have been carried over; if you have difficulty logging in, please try resetting your password before contacting us. Attachments did not survive the migration--many apologies, but we're lucky we kept what we could!
mj12games.com/forum → News → Drydock v2 BETA release
A beta-test version of the Starmada Drydock (v2) is now available for download. It has been tested to work with Office 10; using other applications (earlier editions of Excel, Open Office, etc.) may result in varying degrees of success.
There is currently no user guide available, and changes have been locked. Feedback is much appreciated.
[ATTACHMENT DELETED]
Ran into a problem right away.
Trying to input a weapon and no matter what I input the BSUR gives me #NAME?
I get the same result with Office 10 and FreeOffice 2018
I cannot replicate the problem. Would you mind sending a screenshot?
Here is what I get with Office 10. BSUR changes to #NAME? as soon as I enter anything other than the Weapon Name.
Okay, so it appears I've been using Office 365, not Office 10. Clearly there is a function somewhere that Office 10 does not like. I'll need to do some digging.
Figured out the problem. CONCAT is a function that didn't exist prior to Office 365. Made the necessary adjustments and reuploaded.
The BSUR is working now.
Next problem, the Display tab is not showing the weapon arcs and equipment.
It works in Office 365 but not Office 10.
Do me a favor... unlock the SHIP1 tab (password is "Drydock2") and show me what's happening in cells X20:X31.
X20:X31 are all #NAME?
I don't recognize the TEXTJOIN command so I suspect that is the problem.
You are correct. TEXTJOIN is not recognized by Office 2010.
Hmph.
On the SHIP1 tab, enter the following into cell X20.
=IF(K20=U$20,V$20,"")&IF(K20=U$21,V$21,"")&IF(K20=U$22,V$22,"")&IF(K20=U$23,V$23,"")&IF(K20=U$24,V$24,"")&IF(K20=U$25,V$25,"")&IF(K20=U$26,V$26,"")&IF(K20=U$27,V$27,"")&IF(K20=U$28,V$28,"")&IF(K20=U$29,V$29,"")&IF(K20=U$30,V$30,"")&IF(K20=U$31,V$31,"")Then select cells X20:X31 and hit Ctrl-D.
Enter the following into cell U43.
=IF(LEFT(V33)="E",U33&CHAR(160)&REPT("▢",W33)&"│ ","")&IF(LEFT(V34)="E",U34&CHAR(160)&REPT("▢",W34)&"│ ","")&IF(LEFT(V35)="E",U35&CHAR(160)&REPT("▢",W35)&"│ ","")&IF(LEFT(V36)="E",U36&CHAR(160)&REPT("▢",W36)&"│ ","")&IF(LEFT(V37)="E",U37&CHAR(160)&REPT("▢",W37)&"│ ","")&IF(LEFT(V38)="E",U38&CHAR(160)&REPT("▢",W38)&"│ ","")&IF(LEFT(V39)="E",U39&CHAR(160)&REPT("▢",W39)&"│ ","")&IF(LEFT(V40)="E",U40&CHAR(160)&REPT("▢",W40)&"│ ","")&IF(LEFT(V41)="E",U41&CHAR(160)&REPT("▢",W41)&"│ ","")&IF(LEFT(V42)="E",U42&CHAR(160)&REPT("▢",W42)&"│ ","")Enter the following into cell U44.
=IF(LEFT(V33)="T",U33,"")&IF(V33="T1"," ("&W33&")","")&IF(LEFT(V33)="T","; ","")&IF(LEFT(V34)="T",U34,"")&IF(V34="T1"," ("&W34&")","")&IF(LEFT(V34)="T","; ","")&IF(LEFT(V35)="T",U35,"")&IF(V35="T1"," ("&W35&")","")&IF(LEFT(V35)="T","; ","")&IF(LEFT(V36)="T",U36,"")&IF(V36="T1"," ("&W36&")","")&IF(LEFT(V36)="T","; ","")&IF(LEFT(V37)="T",U37,"")&IF(V37="T1"," ("&W37&")","")&IF(LEFT(V37)="T","; ","")&IF(LEFT(V38)="T",U38,"")&IF(V38="T1"," ("&W38&")","")&IF(LEFT(V38)="T","; ","")&IF(LEFT(V39)="T",U39,"")&IF(V39="T1"," ("&W39&")","")&IF(LEFT(V39)="T","; ","")&IF(LEFT(V40)="T",U40,"")&IF(V40="T1"," ("&W40&")","")&IF(LEFT(V40)="T","; ","")&IF(LEFT(V41)="T",U41,"")&IF(V41="T1"," ("&W41&")","")&IF(LEFT(V41)="T","; ","")&IF(LEFT(V42)="T",U42,"")&IF(V42="T1"," ("&W42&")","")&IF(LEFT(V42)="T","; ","")Also, from your screenshot I can see the following edit needs to be made:
On the TABLES tab (you'll need to unhide it) go to cell N12 and change it to =SUM(SHIP1!E$20:E$31)*-0.3
That fixed it. However, the formula in X20 should look at cell K20 not K31.
=IF(K20=U$20,V$20,"")&IF(K20=U$21,V$21,"")&IF(K20=U$22,V$22,"")&IF(K20=U$23,V$23,"")&IF(K20=U$24,V$24,"")&IF(K20=U$25,V$25,"")&IF(K20=U$26,V$26,"")&IF(K20=U$27,V$27,"")&IF(K20=U$28,V$28,"")&IF(K20=U$29,V$29,"")&IF(K20=U$30,V$30,"")&IF(K20=U$31,V$31,"")Found another issue.
If you fill all 12 of the weapon slots on the SHIP1 tab, the last weapon doubles up on the DISPLAY tab.
I can't replicate this.
I can't replicate this.
My mistake. When I changed cell X20 I did a find and replace to change K31 to K20 and that changed cell W31 as well as X20. :oops:
CONCATENATE works in Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010
Having looked at this (and sadly failed to figure out how to use it properly) I'm wondering why the massive changes? I don't see range traits anymore. Looking at this makes me feel like there's massive changes coming to the rules...
Also, noticed that there are a bunch of new traits (outside of the SFB ones I could identify). Will we be getting rules to go with them?
What massive changes are you seeing?
You've rightly noted the removal of range-based traits. That's to go along with the ability to set different ROF/ACC/IMP/DMG values for each range band. Achieves the same result, but much more flexible.
For example, before you had to do this: 4-8-*; 1x5+/1/1 (Crn)
Now you can do this:
1-4; 1x4+/1/1
5-8; 1x5+/1/1
The other changes are just tweaks, and don't affect the rules themselves.
Ah. Massive changes would relate to those changes in weapons and calculations, which made no sense to me at the time. I'm guessing that the calcs for weapons are different now.
I'll be honest, I'm quite happy with the old Drydock and old range traits. 
If I could get some pointers on how to add the new Equipment Traits to the old Drydock I'd be just as happy.
Not a big fan of the new layout, but then again I live and die by Drake Notation so...
Also, wondering about some of these new traits I see. Are we going to get explanations of them soon I hope?
Just logged on to see this. Been busy with my new releases (which will be up ASAP). So am I right in assuming that the ranges are now completely modifiable in every way? That raises some...interesting concepts...:D
Yes. 
A very quick playaround with the weapons sheet has shown me that some aspects are interesting, although I am a bit disappointed that you can't choose different traits for different modes. I was hoping to have a weapon that could be Modulating at short range, with lessening shield-cracking properties at longer ranges. But that's just one aspect, and I like the fact that, with the five potential weapon range combinations, you could have a plasma torch-like weapon--a weapon with awesome power close-in but virtually no effect further away.
You people are never happy.
Dan, awesome stuff. Been watching The Expanse and getting pumped to get back into Starmada. Exciting to see the fine control over attributes based on range.
Tim
mj12games.com/forum → News → Drydock v2 BETA release
Powered by PunBB, supported by Informer Technologies, Inc.