Convert measurements to scale of 1:6

[PoohsMate]

I've done several searches on this and can't find an answer.
I am looking to use Excel to help me scale down measurements. Some on original drawing I am using are in inches and some in centimetres which makes it more interesting.
What I am hoping to be able to do is to enter the original dimension in either inches or centimeters e.g. Inches in Cell A2 cms in B2 and then apply a scale of 1:6 in D2 with the conversion appearing in E2. There are applications on the web but I was hoping someone would help me understand and design my own as a learning excercise as I tend to use logical functions alot but not the mathematical ones.
Any help would be appreciated.Kind regards, Bernard

 

[sykes]

Bernard

1. What are the final dimension units required?
2. Are the original dimensions all whole numbers, or parts thereof?
3. If it's the latter above, how are the parts thereof expressed, in fractions, or decimals
4. To what degree of accuracy are the scaled results required?

 

[PoohsMate]

Sykes,
I am rounding (to hopefully make things simple even if less accurate).
e.g.
Cell A2 = Input 132.75 inches actual (rounded to 133 inches).
Then I have used a series of calculations.
D2 (To convert to metres as I can't find centimeters) =CONVERT(A2,"in","m")
E2 (To get the centimeters) =SUM(D2*100)
F2 (To get the 1:6 conversion rate) =SUM(E2/6)
Then finally G2 (To convert to centimeters)=SUM(F2/2.8), as I think there are 2.8 centimeters to an Inch?
I am trying to get to the stage where I enter the actual length. Select the convertion rate then out pos the result in centimetres (or in extreme cases metres and centimeters if possible).
Hope this makes sense.
Bernard (PS Nice Pic - Buff Orpington?, we've got Peking Buffs due to small garden).

 

[sykes]

Bernard
Don't understand the G2 stage - you're already in cm, and say you want the result in cm (and/or cm/m)!

A2 is the input cell
in B2 type the scaler eg "6" for 1:6 scale, "5" for 1:5 scale etc etc
in C2 put the formula:
=IF(CONVERT(A2/B2,"in","cm")<100,CONVERT(A2/B2,"in","cm"),CONVERT(A2/B2,"in","m"))

I'm only using whole numbers in A2, and I've formatted C2 for "number" to 2 decimal places.

Now, if you type up to 236 in A2 you'll get the answer in cm in C2, anything over 236 in A2 will automatically show in metres and decimals thereof, in C2.

 

[sykes]

...........Oh, PS she was a Warren....... my favourite, called "May". She died of old age a couple of years ago now....surprising how you get attached to them though isn't it?

 

[sykes]

Bernard
Forgot to mention, doing it this way, you can type in A2 to whatever accuracy you wish, and be fairly certain of an accurate result, depending upon the number of DPs you set the cells to.
If I use the 132.75 inches in your example, I get a result of 56.20 cm.

 

[PoohsMate]

Sykes,
Superb. Thank you.
Our two have gone broody so there is a lot of Fowl language (sorry!) in the coop at the moment - especially when I turf them out. I recommend them, lovely little eggs, great personalities and sound fantastic when contentedly ripping my lawn to shreds.
Kind regards, Bernard

 

[sykes]

Bernard
Pleasure!
Yes, same here, mine love dandelion and dock leaves & fresh grass - unfortunately next door's particularly, and their cat's food!
Through the winter I end up buying greens from the supermarket for them. How sad is that!

All the best....

 

[sykes]

Bernard
We never got to complete your original question, which was to allow for the original input to be in cm as well as ins.
I've come up with a nifty solution (even if I say so myself) to accomodate this if you're interested.
Problem is, I'm away for a week from tomorrow, so we'd have to implement it today..... are you available?

 

[Scott Huish]

How about:

=(CONVERT(A2,"in","cm")+B2)/6

then you could input in inches, centimeters or both:

small.xls
	A	B	C	D
1	In	Cm
2	132.75		56.1975
3		14	2.333333
4	7	18	5.963333
Sheet1