mj12games.com

Dry dock and OpenOffice/LibreOffice

Dry dock and OpenOffice/LibreOffice

Posted: Thu Jul 27, 2017 8:11 am

by mikeaxe

Hi guys,My spreadsheet skills are not great but I have been trying to get the Drydock to work on open office and found some success, well sort of. Libreoffice 5 rather than OpenOffice seems to work with a single small tweak. On the weapons sheet change the acc column format numbers to text and it all appears to work...ish.

I have tried a couple of ships from the rules and the crat seems out. The imperial concordat is 770 rather than 755. Probably a rounding error somewhere. On the ship sheet it is 769.

There obviously needs some more testing but with my poor spreadsheet skills I thought I would post my results so far and others might help some testing and post any changes from Dan's original needed.

It would help if we could have a working example in the drydock. Perhaps the good old Majestic could be added to show how. Dan?

Re: Dry dock and OpenOffice/LibreOffice

Posted: Sun Jul 30, 2017 7:18 am

by mikeaxe1066

Hi,I'm having isssues with my old id of mikeaxe and have re-registered.I have now upgraded my libreOffice to 5.4 and apart from having to change the cell format for tha ACC column on the weapons sheet it appears to work without any other issues. I have tested the Imperial ships from the rules and the Majestic and Concodant are correct the Swiftsure has a CRAT of 165 rather than 170 not clear why.

Looking to play my first non-solo game next weekend so need to sort out the ships now!

Re: Dry dock and OpenOffice/LibreOffice

Posted: Mon Jul 31, 2017 2:40 pm

by bekosh

Dan had mentioned that the CRAT on the ship page (M5) rounds up but the display page (Q2) rounds the the nearest 5.It looks like LibreOffice might be rounding differently than MSExcel.

If the CRAT in M5 on the ship page rounds down rather than up you may end with a CRAT of 167 rounding to 165 for the nearest 5 vs. rounding up to 168 and 170.

Just the first thing that came to mind.

Re: Dry dock and OpenOffice/LibreOffice

Posted: Wed Aug 02, 2017 10:38 am

by mikeaxe1066

While trying to validate LibreOffice I have been frustrated with the inconsistances between the ships in the rules and the results from LibreOffice. I have 'tested' quite a few of the ships provided in the book and could not detect any particular pattern or error in the code caused be any conversion. It was defiantly not a rounding error as some of the variations are quite large. Finally I got out my parchment, quill and abacus. I have gone through the KALAEDINESE Coronation Heavy Cruiser from the rule book and have calculated its CRAT is 455, which agrees with LibreOffice not 505 as in the book.Given this and assuming LibreOffice is correct I offer the following:-