|
|
 Rank: Pro Groups: Joined: 24/08/2009 Posts: 48,827 Points: -13,348
|
Hi Shipmates!  A little spreadsheet to help you resize measurements from one plan to use on your model. Say you have a plan with the scale of 1/48 and you need the measurements for the 1/84 scale Victory, No problem use this simply spreadsheet on execl 2007 entered 48 in the 'Start Scale' so it showed 1/48, then entered 84 in the 'Convert To Scale' so it showed 1/84 and that gave my a 'Correction Factor' of 0.571428571. Next measured the gunports on the plan 9mm so entered 9 in the 'Measurement' section and got 5.14 in the 'Converted To' section, so rounded 5.14mm down to 5mm. Below that I setup a section to convert measurement from yards down to millimetres so I can use reference measurements from all sources real and from scale plans. As you enter the scale your can go from 1/1 scaled down to 1/99999999 or the other way from 1/99999999 scale up to 1/1 scale. Example you have the real deck plank measurement 21 foot so you want the scale measurement for a scale 1/84. Enter 1/1 for 'Start Scale', 1/84 for 'Convert To Scale', 21 in the 'Start Measurement' section on the row for 'Feet'. This give you all the converted measurements from yards down to millimetres, Enter 6400.8 in the 'Measurement' section and you get 76.20 in the 'Converted To' section that's 76.2mm. Just use the link below and download the file I've set the spreadsheet protection on so you won't change the formats only the cell's that you need to change can be. If you what you can unprotect the spreadsheet to see how the formulas work. http://www.4shared.com/f...urements_excel_200.html
 Darron Son of Bulwark attached the following image(s):
|
|
|
 Rank: Amateur Level 1  Groups: Registered
Joined: 19/04/2010 Posts: 35 Points: 105 Location: Hailsham, East Sussex
|
Darren,
You Sir are a true gent, scholar and fine judge of ar$e. Would you object if I shared this spreadsheet amongst the railway modelling fraternity?
Kev
|
|
|
Rank: Pro Groups: Joined: 24/08/2009 Posts: 48,827 Points: -13,348
|
|
|
|
Rank: Pro Groups: Joined: 24/08/2009 Posts: 48,827 Points: -13,348
|
Thanks darren, got mine via email, thanks mate.
|
|
|
 Rank: Super-Elite       Groups: Registered
Joined: 16/08/2010 Posts: 2,771 Points: 8,344 Location: Brighton
|
Realy useful tool thanks Current builds.Hachettes build the bismark,HMS Victory, HMS Hood.
Finished Builds Corel HMS Victory cross section.
|
|
|
|
|
Don't know if anyone noticed but there is one on the tutorials page. http://www.model-space.co.uk/tutorials/scalingOn the bench 1/350 Revell Tirpitz Platinum Edition (Pontos PE and Wooden deck) plus extra Eduard PE set and extra MK1 door sets.
|
|
|
Rank: Pro Groups: Joined: 24/08/2009 Posts: 48,827 Points: -13,348
|
Hi magpie! YES! but doesn’t convert sizes larger than cm, so if you get details in feet and inches or even yards you have to first convert into cm or mm measurements. So if you have all the conversions on one spreadsheet then that's less work for you. I like the way your builds are going magpie nice detail, the fact you have made your cutout towards the aft section showing the pumps is great idea!  Darron
|
|
|
 Rank: Vice-Master Groups: Registered
Joined: 06/06/2010 Posts: 566 Points: 1,657 Location: UK
|
Thanks Bulwark that's excellent!!
|
|
|
|
Guest
|
US
