Shipbucket

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


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

_________________
Dieu et mon droit
Solus dux nullus ductus

Worklist
All Royal Swedish Navy units from 1522 to present

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

_________________
Thank you Kim for the crest

"Never fear to try on something new. Remember that the Titanic was built by professionals, and the Ark by an amateur"

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.

_________________
AU Projects: | Banbha et al. | New England: The Divided States
Blood and Fire

A:Worked like a charm
B: Still can't open, as I use an XML converter (my Office edition is 2003 only.

_________________
Thank you Kim for the crest

"Never fear to try on something new. Remember that the Titanic was built by professionals, and the Ark by an amateur"

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.

_________________
Dieu et mon droit
Solus dux nullus ductus

Worklist
All Royal Swedish Navy units from 1522 to present

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.

A nifty little idea. Thanks for sharing this.

_________________
Hood's Worklist
English Electric Canberra FD
Interwar RN Capital Ships
Super-Darings
Never-Were British Aircraft

I use something funny called an "calculator"!

The link is to Tripod site which prevents downloads.

_________________
Thank you Kim for the crest

"Never fear to try on something new. Remember that the Titanic was built by professionals, and the Ark by an amateur"

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

_________________
Public Service Announcement: This is the preferred SB / FD font.

NSWE: viewtopic.php?f=14&t=5695