X-Kilt Excel Spreadsheet

[Wolfgore]

OK, I have received a couple PM's asking me to convert this to inches.
I didn't make this thing, Mipi did.
I just hosted and posted it.

I am not very good with excel.
Is there anyone out there that can convert Mipi's fine work over to inches for us?

If anyone is able to do so, send me a PM, I will send you my email addy and you can send it to me and I will post it as well.

Gary

[Canuck]

OK, I have received a couple PM's asking me to convert this to inches.
I didn't make this thing, Mipi did.
I just hosted and posted it.


I am not very good with excel.
Is there anyone out there that can convert Mipi's fine work over to inches for us?

If anyone is able to do so, send me a PM, I will send you my email addy and you can send it to me and I will post it as well.

Gary

unprotect the spreadsheet under the tools menu
select a free column. reference the column and insert a formula for example =b2/2.54 for waist
=b3/2.54 for hip.
there are 2.54cm in an inch or you can do the reverse .... multiple the inch measurement by 2.54 to get the centimeters

[12stones]

I am not very good with excel.
Is there anyone out there that can convert Mipi's fine work over to inches for us?

If anyone is able to do so, send me a PM, I will send you my email addy and you can send it to me and I will post it as well.

Gary

PM on its way. I'm working to see what I can do with it.

unprotect the spreadsheet under the tools menu
select a free column. reference the column and insert a formula for example =b2/2.54 for waist
=b3/2.54 for hip.
there are 2.54cm in an inch or you can do the reverse .... multiple the inch measurement by 2.54 to get the centimeters

You can't just do that because of some of the formulas that work together. It'll throw the recommendations off.

[Canuck]

PM on its way. I'm working to see what I can do with it.



You can't just do that because of some of the formulas that work together. It'll throw the recommendations off.

Yes you can. actually the formulas should work whether you put in inches or cm the ratios should be the same as long as you are consistent throughout the whole process just change the tag from cm to inches.

[12stones]

Yes you can. actually the formulas should work whether you put in inches or cm the ratios should be the same as long as you are consistent throughout the whole process just change the tag from cm to inches.

That's not what I'm saying. Yes, the conversion doesn't change because it's always 2.54 either way, however, he has IF statements that are based on the metrics that give recommendations. If someone doesn't know to go into the formulas and change those also, then just doing the conversions of 2.54 doesn't help with the recommendations the sheet is trying to provide.

[ccga3359]

That's not what I'm saying. Yes, the conversion doesn't change because it's always 2.54 either way, however, he has IF statements that are based on the metrics that give recommendations. If someone doesn't know to go into the formulas and change those also, then just doing the conversions of 2.54 doesn't help with the recommendations the sheet is trying to provide.

Then have a seperate cell converting inches into metric then input result in cm. Problem with imperial to begin with is having to convert a fraction into a decimal so that Excel understands. Metric is so much easier to work with (then again when working with wood I'm always working in inches, go figure ).

[James MacMillan]

Then have a seperate cell converting inches into metric then input result in cm. Problem with imperial to begin with is having to convert a fraction into a decimal so that Excel understands. Metric is so much easier to work with (then again when working with wood I'm always working in inches, go figure ).

I've been told that the current finished dimensions of the common 2 by 4 is really metric..........????

[Decay]

I noticed there were a few errors in the spreadsheet done up in inches (at least for the one in the official Xkilt thread, its the only one I've checked). I took the liberty of fixing up the errors (some of the conversions between the measurements were missing) and cleaned up the protection so people can actually enter their data without having to unlock the rest of the page.

You can find the file here:
http://rapidshare.com/files/12828059...nches.xls.html
If I remember though, rapidshare deletes any files that haven't been downloaded in 30 days or something like that so maybe one of the official hosts can replace the incorrect file with the corrected ones?

Anyways, as this is my first time creating a kilt (you should have seen my consternation and frustration when I was trying to figure out why the numbers weren't working on the "broken" file) if anyone who downloads the new file could take a brief overview of my numbers to see if I screwed up anything, I'd greatly appreciate it.

(oh, and hello Xmarksthescot!)