Shipbucket
http://67.205.157.234/forums/

Spreadsheet for calculation of shipbucket scale - Beta 1
http://67.205.157.234/forums/viewtopic.php?f=5&t=5560		 Page 1 of 1
Author:  Psilander [ September 5th, 2014, 12:31 pm ]
Post subject:  Spreadsheet for calculation of shipbucket scale - Beta 1
I made a Little Excel spreadsheet for calculating ships into Shipbucket scale.

Functions
- It is primary made for metric drawers (like me).
- The sheet is made for Springsharp users. When you have calculated your ship in SS. Just put the numbers in spreadsheet and you will see how many pixels it should be.


Screendump
[ img ]

Notes:
1. Quuite simple to use. change the bold numbers inte your own and the answer will be given in italics the cells(s) next to it.

2. When you scale a Blueprint, you need to put in the ships true length in meters in B2 and the ships length in pixels in your blueprint in G2, the multiply the drawing by the the numbers given.


DOWNLOAD SHIPBUCKET CONVERTER

I am a quite poor programmer, but it is a nice tool to have whem you do you your ships
Author:  Novice [ September 5th, 2014, 10:04 pm ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
A wonderful idea psilander, but when I press the link, all I got was some gibberish.
I believe that is I don't have Office 2010
Author:  Blackbuck [ September 5th, 2014, 10:18 pm ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
A: Save link as rather than clicking ;)
B: There are some errors with the actual file when opening in Office 2007, not sure if they're formulaic or something else.
Author:  Novice [ September 5th, 2014, 10:32 pm ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
Blackbuck wrote:
A: Save link as rather than clicking ;)
B: There are some errors with the actual file when opening in Office 2007, not sure if they're formulaic or something else.
A:Worked like a charm
B: Still can't open, as I use an XML converter (my Office edition is 2003 only.
Author:  Psilander [ September 6th, 2014, 5:40 am ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
It's your lucky day, I am not epsecially good at computers and love to save things, so I still the 2003 officepackage on my computer aswell, so I made a 2003 version of it

SHIPBUCKET CONVERTER EXCEL2003 version

Hope it works better.
Author:  Judah14 [ September 6th, 2014, 6:32 am ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
I wrote a Python script that does the same thing, altough it has the advantage to work on any platform with Python 3 installed, it needs the command line to be run, not the best thing for inexperienced users.
Author:  Hood [ September 6th, 2014, 9:21 am ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
A nifty little idea. Thanks for sharing this.
Author:  heuhen [ September 6th, 2014, 9:26 am ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
I use something funny called an "calculator"!
Author:  Novice [ September 6th, 2014, 6:58 pm ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
The link is to Tripod site which prevents downloads.
Author:  apdsmith [ September 7th, 2014, 8:37 pm ]
Post subject:  Re: Spreadsheet for calculation of shipbucket scale - Beta 1
One of the other things I've done on mine is have the cells as follows:

Cell 1: "m:" Cell 2: Value Cell 3: "px:" (for instance) Cell 4: This concatenates cells 1 and 3 to get an index key - this form the basis of a vlookup to get the ratio to be applied to cell 2, letting you go straight from metres to pixels (or any other measurement you define ratios for)

Ad
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/