14-05-2012, 08:49 PM
It looks a bit messy. I hate hard coded data, so I write any number I need in a formula in a cell near it. I overwrote the column header cells with them, which makes it harder to understand what's what.
This is what's in the columns:
A: INPUT date dd/mm/yyyy
B: Body Mass Index (BMI) in kg/m2 (body weight divided by the square of height in m)
C: Difference between Bust and Under bust in cm
D: Waist to Hip Ratio (WHR) in cm/cm
E: INPUT body weight in kg
F: INPUT Bust circumference across nipples in cm
G: INPUT Under bust circumference in cm
H: INPUT Waist circumference in cm
I: INPUT Butt circumference in cm
J: Bust circumference across nipples in inches
K: Under bust circumference in inches
L: Waist circumference in inches
M: Butt circumference in inches
N: body weight in pounds
O: bra band size according to Anastasia's US bra size calculator
P: cup size = bust size minus band size (the legend to convert numbers to cups is in R1-S12)
Q: US cup size
Cell E1 contains =(1.785)^2 INPUT your height
My height in cm, squared, for the calculation of BMI
Cell J1 contains 2.54
1 inch, in centimeters
Cell N1 contains 2.2046
1 kg, in lbs
Cell O1 contains 5
Anastasia adds 4 or 5 to the underbust size so as to obtain an even number, so I added 5 (in cell O1), divided by 2 (in cell P1), took the integer part (Excel function INT), and multiplied by 2 again (in cell P1)
Cell P1 contains 2
for the calculation of the US band size.
The P column is Bust - Band difference values, similar to column C, but in inches. Actually, the P column are cup sizes. They are formatted as letters in column Q.
This is what's in the columns:
A: INPUT date dd/mm/yyyy
B: Body Mass Index (BMI) in kg/m2 (body weight divided by the square of height in m)
C: Difference between Bust and Under bust in cm
D: Waist to Hip Ratio (WHR) in cm/cm
E: INPUT body weight in kg
F: INPUT Bust circumference across nipples in cm
G: INPUT Under bust circumference in cm
H: INPUT Waist circumference in cm
I: INPUT Butt circumference in cm
J: Bust circumference across nipples in inches
K: Under bust circumference in inches
L: Waist circumference in inches
M: Butt circumference in inches
N: body weight in pounds
O: bra band size according to Anastasia's US bra size calculator
P: cup size = bust size minus band size (the legend to convert numbers to cups is in R1-S12)
Q: US cup size
Cell E1 contains =(1.785)^2 INPUT your height
My height in cm, squared, for the calculation of BMI
Cell J1 contains 2.54
1 inch, in centimeters
Cell N1 contains 2.2046
1 kg, in lbs
Cell O1 contains 5
Anastasia adds 4 or 5 to the underbust size so as to obtain an even number, so I added 5 (in cell O1), divided by 2 (in cell P1), took the integer part (Excel function INT), and multiplied by 2 again (in cell P1)
Cell P1 contains 2
for the calculation of the US band size.
The P column is Bust - Band difference values, similar to column C, but in inches. Actually, the P column are cup sizes. They are formatted as letters in column Q.