Welcome Guest Search | Active Topics | Log In | Register

Rescale Measurements and Converter Options
Son of Bulwark
#1 Posted : 07 September 2010 19:01:44

Rank: Pro

Groups:

Joined: 24/08/2009
Posts: 47,828
Points: -10,248
Hi Shipmates! BigGrin

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

ThumpUp Darron
Son of Bulwark attached the following image(s):
Scale resize spreadsheet.jpg
KevinWalsh
#2 Posted : 07 September 2010 19:35:25

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
Son of Bulwark
#3 Posted : 07 September 2010 19:50:50

Rank: Pro

Groups:

Joined: 24/08/2009
Posts: 47,828
Points: -10,248
Hi Kev! BigGrin

Feel free! to share it with anyone as for years I've struggled with paper, pen and a calculator. I needed a better way to get the scale right as will many models, so I worked on this getting the formulas right so the more who benefit from this spreadsheet the happier I'll be. LOL LOL LOL

ThumpUp Darron
Zeptrader
#4 Posted : 07 September 2010 20:32:27

Rank: Pro

Groups:

Joined: 24/08/2009
Posts: 47,828
Points: -10,248
Thanks darren, got mine via email, thanks mate.
ian smith
#5 Posted : 08 September 2010 00:56:17

Rank: Super-Elite

Publisher Medal: Featured Build of the MonthActive Service Medal: 500 post active service MedalPurple Medal: Super active service medal for 1000 postsRed Medal: Red MedalBuild-Diary Medal: Build-Diary Medal of Honour
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.
magpie1832
#6 Posted : 08 September 2010 14:10:05

Rank: Super-Elite

Publisher Medal: Featured Build of the MonthActive Service Medal: 500 post active service MedalPurple Medal: Super active service medal for 1000 postsRed Medal: Red MedalTurquoise Medal: Turquoise Medal for model making know-how contributionBuild-Diary Medal: Build-Diary Medal of Honour
Groups: Tech Support, Forum Support Team, Moderator, Registered, Official Builds, Global Forum Support

Joined: 11/11/2009
Posts: 3,430
Points: 10,314
Location: Bâe Colwyn, Wales
Don't know if anyone noticed but there is one on the tutorials page.BigGrin BigGrin
http://www.model-space.co.uk/tutorials/scaling
On the bench

1/350 Revell Tirpitz Platinum Edition (Pontos PE and Wooden deck) plus extra Eduard PE set and extra MK1 door sets.




Son of Bulwark
#7 Posted : 08 September 2010 15:12:01

Rank: Pro

Groups:

Joined: 24/08/2009
Posts: 47,828
Points: -10,248
Hi magpie! BigGrin

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!Cool

ThumpUp Darron
Wilfy the Sea Dog
#8 Posted : 08 September 2010 23:00:08

Rank: Vice-Master
Active Service Medal: 500 post active service MedalBuild-Diary Medal: Build-Diary Medal of Honour
Groups: Registered

Joined: 06/06/2010
Posts: 566
Points: 1,657
Location: UK
Thanks Bulwark that's excellent!! BigGrin
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.226 seconds.
DeAgostini