X-Kilt Excel Spreadsheet

[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..........????

[ccga3359]

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

A 2 x 4 is dressed and the actual dimensions are 1½ x 3½" that would equal 3.8 x 8.5 cm. Metric is easy, it's based on units of 10 - 10mm = 1cm, 10cm = 1dm, 10dm = 1m, 1000m = 1km. Units of 10 people and I can even figure it out with my 9 ½ fingers (fly being open is a necessity though).

[Mipi]

I woud suggest two things:
- use inch covertion seppartely not to mess with IF statements
- protect worksheet back to be sure you're not doing any fulish thing and destroy formulas

I'll try to do something in inchis when I find some time. But don't think I'll to any fractions!

[12stones]

I woud suggest two things:
- use inch covertion seppartely not to mess with IF statements
- protect worksheet back to be sure you're not doing any fulish thing and destroy formulas

I'll try to do something in inchis when I find some time. But don't think I'll to any fractions!

I sent a modified file to Wolfgore. Don't know if he's had the chance to do anything with it yet. I could send it to you to verify if you'd like. If so, PM me your email.

[Mipi]

As a fact, I sent the inch version already to Wolfgore. Maybe he can compare to find any errors/differences, or decide which to post. In case of doubt, he can send me your version and I'll see...

[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!)