X-Kilt Excel Spreadsheet

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