Hi All,
I am using Microsoft Excel for Mac 2011 Version 14.4.3 (140616) Last update 14.4.3
I cannot seem to get my head around this problem. I have made an Excel spread sheet Table that is for what is known as a Helicopter Weight and Balance computation Table WB
The operator inputs weight values into one column - Column C.
In Column D there are set values representing a station position or Center of Gravity CG position (passenger seat, baggage compartment, etc)
In Column E there is the result of The C Cell x the D cell for each row known as the Moment value
The Column D value for one of the items - Fuel, is variable based on the weight value entered in the corresponding C cell. I have successfully utilized a Vlookup function to do this for the Table on the right side FUEL Station Moments Table
After all values have been entered a Total Weight is calculated in C19 from the Sum of Values of Column C and I have managed to insert an IF statement in C21 to tell me whether or not I have exceeded the Max allowable weight or not.
A Total 'Moment' Value E19 is calculated from the Sum of Values of Column E
A CG Position value is then calculated by dividing The sum from Column E by the Total weight Sum in Column C and placing this at the bottom of Column D in D20
My problem comes at the bottom of the sheet.
For any given Total weight at the bottom of Column C in C19 of the main Table I must be able to show and OK or Not OK answer in D21 to an If or Nested If statement or Some other statement as I am not sure what to write in.
I have another table The CG Reference Table on the bottom of the sheet. In column A is a list of weight values ranging from the lowest possible weight of the empty helicopter of 4,715.5 KG up to the Maximum allowable of 6,800 KG Spaced in 100KG increments from 4,800 upwards.
For each weight value there is a balance range it must fall into in order to be safe to fly. The corresponding minimum figures are listed in column B and the corresponding maximum figures in column C
So, what I need is to be able to Look at the Value of the Main table Column C - C19 Total Weight (lets say it is 5,525.5) then the program must reference the lower table The CG Reference Table and be able to tell me if the CG Value that is in Table WB column D - D20 falls within the allowable range corresponding to that weight value (or closest) in the left side of CG Ref Table column A and if so give me an OK (true), Not OK (false). Or Green Check Mark instead of OK
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: "Arial Narrow",sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { border: 0.5pt solid windowtext; }.xl64 { font-weight: 700; border: 0.5pt solid windowtext; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(166, 166, 166); }.xl67 { text-align: center; border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; }.xl69 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }.xl70 { text-align: center; }.xl71 { }.xl72 { }.xl73 { text-align: center; border: 0.5pt solid windowtext; }.xl74 { text-align: center; border: 0.5pt solid windowtext; }.xl75 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl76 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl77 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl78 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl79 { text-align: center; border: 0.5pt solid windowtext; }.xl80 { text-align: center; border: 0.5pt solid windowtext; }.xl81 { font-family: "Zapf Dingbats",sans-serif; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% lime; }.xl82 { font-family: Calibri; text-align: center; border: 0.5pt solid windowtext; }.xl83 { border: 0.5pt solid windowtext; }.xl84 { text-align: left; vertical-align: middle; padding-left: 12px; }</style> [TABLE="width: 780"]
<tbody>[TR]
[TD="class: xl65, width: 130, colspan: 2"]Aircraft: AW139[/TD]
[TD="class: xl63, width: 65"]BMHM[/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="class: xl70, width: 195, colspan: 3"]FUEL STATIONS MOMENTS[/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]25[/TD]
[TD="class: xl71, align: right"]6208[/TD]
[TD="class: xl72, align: right"]155.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69, colspan: 2"]Item[/TD]
[TD="class: xl64"]Weight Kg[/TD]
[TD="class: xl64"]ST:MM[/TD]
[TD="class: xl64"]Long Moment[/TD]
[TD="class: xl64"]BL:MM[/TD]
[TD="class: xl64"]Lat Moment[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD="class: xl71, align: right"]6209[/TD]
[TD="class: xl72, align: right"]310.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Empty Weight[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]4715.5[/TD]
[TD="class: xl65"]5287.06[/TD]
[TD="class: xl65"]24933494[/TD]
[TD="class: xl65"]5.09[/TD]
[TD="class: xl65"]23982.5[/TD]
[TD][/TD]
[TD="align: right"]75[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]465.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]P1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]60[/TD]
[TD="class: xl65"]2820[/TD]
[TD="class: xl65"]169200[/TD]
[TD="class: xl65"]550[/TD]
[TD="class: xl65"]33000[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]621.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]P2[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]80[/TD]
[TD="class: xl65"]2820[/TD]
[TD="class: xl65"]225600[/TD]
[TD="class: xl65"]-550[/TD]
[TD="class: xl65"]-44000[/TD]
[TD][/TD]
[TD="align: right"]125[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]776.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Seat[/TD]
[TD="class: xl63"]M/F/C/1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]931.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]A[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]737[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]175[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1086.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]B[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]254[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]200[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1241.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]C[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-254[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]225[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1397.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]D[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-737[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]250[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1552.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]E.[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]5566[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]640[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]275[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1707.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]F.[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]5566[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-640[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1862.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Cabinet contents[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]5459[/TD]
[TD="class: xl65"]10918[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]325[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]2018.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Fuel[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]650[/TD]
[TD="class: xl73"]6214[/TD]
[TD="class: xl74"]4039100.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]350[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2173.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Oil[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]6875[/TD]
[TD="class: xl65"]110000[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]375[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2329.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Loose items[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2484.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Baggage[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]7700[/TD]
[TD="class: xl65"]15400[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]425[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2639.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]MGW[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]5525.50[/TD]
[TD="class: xl67"]5339.56[/TD]
[TD="class: xl67"]29503712.00[/TD]
[TD="class: xl67"]2.35[/TD]
[TD="class: xl67"]12982.50[/TD]
[TD][/TD]
[TD="align: right"]450[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2795.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]ST:M[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl83, align: right"]5.3396[/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83, align: right"]0.0023[/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]475[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2950.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]OK/Not OK[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl82"]OK[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]500[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3106.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]525[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3261.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]550[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3416.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl84"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]575[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3571.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]600[/TD]
[TD="class: xl71, align: right"]6213[/TD]
[TD="class: xl72, align: right"]3727.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl75"]Weight (Kg)[/TD]
[TD="class: xl75"]Station Min (M)[/TD]
[TD="class: xl75"]Station Max (M)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]625[/TD]
[TD="class: xl71, align: right"]6213[/TD]
[TD="class: xl72, align: right"]3883.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]6800[/TD]
[TD="class: xl76"]5.2380[/TD]
[TD="class: xl78"]5.480[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD="align: right"]650[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4039.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6700[/TD]
[TD="class: xl79"]5.2264[/TD]
[TD="class: xl80"]5.486[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD="align: right"]675[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4194.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6600[/TD]
[TD="class: xl79"]5.2148[/TD]
[TD="class: xl80"]5.492[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]700[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4349.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6500[/TD]
[TD="class: xl79"]5.2032[/TD]
[TD="class: xl80"]5.498[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]725[/TD]
[TD="class: xl71, align: right"]6215[/TD]
[TD="class: xl72, align: right"]4505.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]6400[/TD]
[TD="class: xl76"]5.1916[/TD]
[TD="class: xl78"]5.504[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]750[/TD]
[TD="class: xl71, align: right"]6215[/TD]
[TD="class: xl72, align: right"]4661.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6300[/TD]
[TD="class: xl79"]5.1800[/TD]
[TD="class: xl80"]5.510[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]775[/TD]
[TD="class: xl71, align: right"]6216[/TD]
[TD="class: xl72, align: right"]4817.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6200[/TD]
[TD="class: xl79"]5.1684[/TD]
[TD="class: xl80"]5.516[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800[/TD]
[TD="class: xl71, align: right"]6217[/TD]
[TD="class: xl72, align: right"]4973.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6100[/TD]
[TD="class: xl79"]5.1568[/TD]
[TD="class: xl80"]5.522[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]825[/TD]
[TD="class: xl71, align: right"]6219[/TD]
[TD="class: xl72, align: right"]5130.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6000[/TD]
[TD="class: xl79"]5.1452[/TD]
[TD="class: xl80"]5.528[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]850[/TD]
[TD="class: xl71, align: right"]6221[/TD]
[TD="class: xl72, align: right"]5287.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5900[/TD]
[TD="class: xl79"]5.1336[/TD]
[TD="class: xl80"]5.534[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]875[/TD]
[TD="class: xl71, align: right"]6223[/TD]
[TD="class: xl72, align: right"]5445.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5800[/TD]
[TD="class: xl79"]5.1220[/TD]
[TD="class: xl80"]5.540[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]900[/TD]
[TD="class: xl71, align: right"]6225[/TD]
[TD="class: xl72, align: right"]5602.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5700[/TD]
[TD="class: xl79"]5.1104[/TD]
[TD="class: xl80"]5.546[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]925[/TD]
[TD="class: xl71, align: right"]6225[/TD]
[TD="class: xl72, align: right"]5758.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5600[/TD]
[TD="class: xl79"]5.0988[/TD]
[TD="class: xl80"]5.552[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]950[/TD]
[TD="class: xl71, align: right"]6226[/TD]
[TD="class: xl72, align: right"]5914.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5500[/TD]
[TD="class: xl79"]5.0872[/TD]
[TD="class: xl80"]5.558[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]975[/TD]
[TD="class: xl71, align: right"]6227[/TD]
[TD="class: xl72, align: right"]6071.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5400[/TD]
[TD="class: xl79"]5.0756[/TD]
[TD="class: xl80"]5.564[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1000[/TD]
[TD="class: xl71, align: right"]6228[/TD]
[TD="class: xl72, align: right"]6227.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5300[/TD]
[TD="class: xl79"]5.0640[/TD]
[TD="class: xl80"]5.570[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1025[/TD]
[TD="class: xl71, align: right"]6228[/TD]
[TD="class: xl72, align: right"]6384.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5200[/TD]
[TD="class: xl79"]5.0524[/TD]
[TD="class: xl80"]5.576[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1050[/TD]
[TD="class: xl71, align: right"]6229[/TD]
[TD="class: xl72, align: right"]6540.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]5170[/TD]
[TD="class: xl76"]5.0000[/TD]
[TD="class: xl78"]5.582[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1075[/TD]
[TD="class: xl71, align: right"]6229[/TD]
[TD="class: xl72, align: right"]6696.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5100[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.588[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1100[/TD]
[TD="class: xl71, align: right"]6230[/TD]
[TD="class: xl72, align: right"]6852.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5000[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.594[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1125[/TD]
[TD="class: xl71, align: right"]6230[/TD]
[TD="class: xl72, align: right"]7009.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4900[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.600[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1150[/TD]
[TD="class: xl71, align: right"]6231[/TD]
[TD="class: xl72, align: right"]7165.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4850[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.595[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1175[/TD]
[TD="class: xl71, align: right"]6231[/TD]
[TD="class: xl72, align: right"]7322.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4800[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.588[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1200[/TD]
[TD="class: xl71, align: right"]6232[/TD]
[TD="class: xl72, align: right"]7478.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]4726[/TD]
[TD="class: xl76"]5.0000[/TD]
[TD="class: xl78"]5.570[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1225[/TD]
[TD="class: xl71, align: right"]6232[/TD]
[TD="class: xl72, align: right"]7634.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1250[/TD]
[TD="class: xl71, align: right"]6233[/TD]
[TD="class: xl72, align: right"]7791.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1270[/TD]
[TD="class: xl71, align: right"]6233[/TD]
[TD="class: xl72, align: right"]7915.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
(Grid coordinates didn't print)
I do so hope I have been clear on what I am trying to accomplish. And I thank anyone who is able to help me solve what function should go in D21 Longitudinal balance. Whatever it is I will need to do similar for F21 for the Lateral balance for Columns F and G
Again, Thanks!
Bob
I am using Microsoft Excel for Mac 2011 Version 14.4.3 (140616) Last update 14.4.3
I cannot seem to get my head around this problem. I have made an Excel spread sheet Table that is for what is known as a Helicopter Weight and Balance computation Table WB
The operator inputs weight values into one column - Column C.
In Column D there are set values representing a station position or Center of Gravity CG position (passenger seat, baggage compartment, etc)
In Column E there is the result of The C Cell x the D cell for each row known as the Moment value
The Column D value for one of the items - Fuel, is variable based on the weight value entered in the corresponding C cell. I have successfully utilized a Vlookup function to do this for the Table on the right side FUEL Station Moments Table
After all values have been entered a Total Weight is calculated in C19 from the Sum of Values of Column C and I have managed to insert an IF statement in C21 to tell me whether or not I have exceeded the Max allowable weight or not.
A Total 'Moment' Value E19 is calculated from the Sum of Values of Column E
A CG Position value is then calculated by dividing The sum from Column E by the Total weight Sum in Column C and placing this at the bottom of Column D in D20
My problem comes at the bottom of the sheet.
For any given Total weight at the bottom of Column C in C19 of the main Table I must be able to show and OK or Not OK answer in D21 to an If or Nested If statement or Some other statement as I am not sure what to write in.
I have another table The CG Reference Table on the bottom of the sheet. In column A is a list of weight values ranging from the lowest possible weight of the empty helicopter of 4,715.5 KG up to the Maximum allowable of 6,800 KG Spaced in 100KG increments from 4,800 upwards.
For each weight value there is a balance range it must fall into in order to be safe to fly. The corresponding minimum figures are listed in column B and the corresponding maximum figures in column C
So, what I need is to be able to Look at the Value of the Main table Column C - C19 Total Weight (lets say it is 5,525.5) then the program must reference the lower table The CG Reference Table and be able to tell me if the CG Value that is in Table WB column D - D20 falls within the allowable range corresponding to that weight value (or closest) in the left side of CG Ref Table column A and if so give me an OK (true), Not OK (false). Or Green Check Mark instead of OK
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: "Arial Narrow",sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { border: 0.5pt solid windowtext; }.xl64 { font-weight: 700; border: 0.5pt solid windowtext; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(166, 166, 166); }.xl67 { text-align: center; border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; }.xl69 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }.xl70 { text-align: center; }.xl71 { }.xl72 { }.xl73 { text-align: center; border: 0.5pt solid windowtext; }.xl74 { text-align: center; border: 0.5pt solid windowtext; }.xl75 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl76 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl77 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl78 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(141, 180, 226); }.xl79 { text-align: center; border: 0.5pt solid windowtext; }.xl80 { text-align: center; border: 0.5pt solid windowtext; }.xl81 { font-family: "Zapf Dingbats",sans-serif; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% lime; }.xl82 { font-family: Calibri; text-align: center; border: 0.5pt solid windowtext; }.xl83 { border: 0.5pt solid windowtext; }.xl84 { text-align: left; vertical-align: middle; padding-left: 12px; }</style> [TABLE="width: 780"]
<tbody>[TR]
[TD="class: xl65, width: 130, colspan: 2"]Aircraft: AW139[/TD]
[TD="class: xl63, width: 65"]BMHM[/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="class: xl70, width: 195, colspan: 3"]FUEL STATIONS MOMENTS[/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]25[/TD]
[TD="class: xl71, align: right"]6208[/TD]
[TD="class: xl72, align: right"]155.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl69, colspan: 2"]Item[/TD]
[TD="class: xl64"]Weight Kg[/TD]
[TD="class: xl64"]ST:MM[/TD]
[TD="class: xl64"]Long Moment[/TD]
[TD="class: xl64"]BL:MM[/TD]
[TD="class: xl64"]Lat Moment[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD="class: xl71, align: right"]6209[/TD]
[TD="class: xl72, align: right"]310.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Empty Weight[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]4715.5[/TD]
[TD="class: xl65"]5287.06[/TD]
[TD="class: xl65"]24933494[/TD]
[TD="class: xl65"]5.09[/TD]
[TD="class: xl65"]23982.5[/TD]
[TD][/TD]
[TD="align: right"]75[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]465.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]P1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]60[/TD]
[TD="class: xl65"]2820[/TD]
[TD="class: xl65"]169200[/TD]
[TD="class: xl65"]550[/TD]
[TD="class: xl65"]33000[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]621.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]P2[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]80[/TD]
[TD="class: xl65"]2820[/TD]
[TD="class: xl65"]225600[/TD]
[TD="class: xl65"]-550[/TD]
[TD="class: xl65"]-44000[/TD]
[TD][/TD]
[TD="align: right"]125[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]776.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Seat[/TD]
[TD="class: xl63"]M/F/C/1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]931.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]A[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]737[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]175[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1086.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]B[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]254[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]200[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1241.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]C[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-254[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]225[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1397.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]D[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]3415[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-737[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]250[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1552.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]E.[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]5566[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]640[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]275[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1707.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]F.[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]5566[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]-640[/TD]
[TD="class: xl65"]0[/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]1862.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Cabinet contents[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]5459[/TD]
[TD="class: xl65"]10918[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]325[/TD]
[TD="class: xl71, align: right"]6210[/TD]
[TD="class: xl72, align: right"]2018.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Fuel[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]650[/TD]
[TD="class: xl73"]6214[/TD]
[TD="class: xl74"]4039100.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]350[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2173.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Oil[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]6875[/TD]
[TD="class: xl65"]110000[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]375[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2329.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Loose items[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2484.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]Baggage[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]7700[/TD]
[TD="class: xl65"]15400[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD="align: right"]425[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2639.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]MGW[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]5525.50[/TD]
[TD="class: xl67"]5339.56[/TD]
[TD="class: xl67"]29503712.00[/TD]
[TD="class: xl67"]2.35[/TD]
[TD="class: xl67"]12982.50[/TD]
[TD][/TD]
[TD="align: right"]450[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2795.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]ST:M[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl83, align: right"]5.3396[/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83, align: right"]0.0023[/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]475[/TD]
[TD="class: xl71, align: right"]6211[/TD]
[TD="class: xl72, align: right"]2950.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]OK/Not OK[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl82"]OK[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]500[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3106.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD="align: right"]525[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3261.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]550[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3416.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl84"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]575[/TD]
[TD="class: xl71, align: right"]6212[/TD]
[TD="class: xl72, align: right"]3571.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]600[/TD]
[TD="class: xl71, align: right"]6213[/TD]
[TD="class: xl72, align: right"]3727.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl75"]Weight (Kg)[/TD]
[TD="class: xl75"]Station Min (M)[/TD]
[TD="class: xl75"]Station Max (M)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]625[/TD]
[TD="class: xl71, align: right"]6213[/TD]
[TD="class: xl72, align: right"]3883.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]6800[/TD]
[TD="class: xl76"]5.2380[/TD]
[TD="class: xl78"]5.480[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD="align: right"]650[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4039.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6700[/TD]
[TD="class: xl79"]5.2264[/TD]
[TD="class: xl80"]5.486[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD="align: right"]675[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4194.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6600[/TD]
[TD="class: xl79"]5.2148[/TD]
[TD="class: xl80"]5.492[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]700[/TD]
[TD="class: xl71, align: right"]6214[/TD]
[TD="class: xl72, align: right"]4349.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6500[/TD]
[TD="class: xl79"]5.2032[/TD]
[TD="class: xl80"]5.498[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]725[/TD]
[TD="class: xl71, align: right"]6215[/TD]
[TD="class: xl72, align: right"]4505.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]6400[/TD]
[TD="class: xl76"]5.1916[/TD]
[TD="class: xl78"]5.504[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]750[/TD]
[TD="class: xl71, align: right"]6215[/TD]
[TD="class: xl72, align: right"]4661.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6300[/TD]
[TD="class: xl79"]5.1800[/TD]
[TD="class: xl80"]5.510[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]775[/TD]
[TD="class: xl71, align: right"]6216[/TD]
[TD="class: xl72, align: right"]4817.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6200[/TD]
[TD="class: xl79"]5.1684[/TD]
[TD="class: xl80"]5.516[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800[/TD]
[TD="class: xl71, align: right"]6217[/TD]
[TD="class: xl72, align: right"]4973.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6100[/TD]
[TD="class: xl79"]5.1568[/TD]
[TD="class: xl80"]5.522[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]825[/TD]
[TD="class: xl71, align: right"]6219[/TD]
[TD="class: xl72, align: right"]5130.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]6000[/TD]
[TD="class: xl79"]5.1452[/TD]
[TD="class: xl80"]5.528[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]850[/TD]
[TD="class: xl71, align: right"]6221[/TD]
[TD="class: xl72, align: right"]5287.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5900[/TD]
[TD="class: xl79"]5.1336[/TD]
[TD="class: xl80"]5.534[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]875[/TD]
[TD="class: xl71, align: right"]6223[/TD]
[TD="class: xl72, align: right"]5445.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5800[/TD]
[TD="class: xl79"]5.1220[/TD]
[TD="class: xl80"]5.540[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]900[/TD]
[TD="class: xl71, align: right"]6225[/TD]
[TD="class: xl72, align: right"]5602.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5700[/TD]
[TD="class: xl79"]5.1104[/TD]
[TD="class: xl80"]5.546[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]925[/TD]
[TD="class: xl71, align: right"]6225[/TD]
[TD="class: xl72, align: right"]5758.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5600[/TD]
[TD="class: xl79"]5.0988[/TD]
[TD="class: xl80"]5.552[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]950[/TD]
[TD="class: xl71, align: right"]6226[/TD]
[TD="class: xl72, align: right"]5914.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5500[/TD]
[TD="class: xl79"]5.0872[/TD]
[TD="class: xl80"]5.558[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]975[/TD]
[TD="class: xl71, align: right"]6227[/TD]
[TD="class: xl72, align: right"]6071.7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5400[/TD]
[TD="class: xl79"]5.0756[/TD]
[TD="class: xl80"]5.564[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1000[/TD]
[TD="class: xl71, align: right"]6228[/TD]
[TD="class: xl72, align: right"]6227.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5300[/TD]
[TD="class: xl79"]5.0640[/TD]
[TD="class: xl80"]5.570[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1025[/TD]
[TD="class: xl71, align: right"]6228[/TD]
[TD="class: xl72, align: right"]6384.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5200[/TD]
[TD="class: xl79"]5.0524[/TD]
[TD="class: xl80"]5.576[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1050[/TD]
[TD="class: xl71, align: right"]6229[/TD]
[TD="class: xl72, align: right"]6540.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]5170[/TD]
[TD="class: xl76"]5.0000[/TD]
[TD="class: xl78"]5.582[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1075[/TD]
[TD="class: xl71, align: right"]6229[/TD]
[TD="class: xl72, align: right"]6696.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5100[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.588[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1100[/TD]
[TD="class: xl71, align: right"]6230[/TD]
[TD="class: xl72, align: right"]6852.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]5000[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.594[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1125[/TD]
[TD="class: xl71, align: right"]6230[/TD]
[TD="class: xl72, align: right"]7009.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4900[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.600[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1150[/TD]
[TD="class: xl71, align: right"]6231[/TD]
[TD="class: xl72, align: right"]7165.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4850[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.595[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1175[/TD]
[TD="class: xl71, align: right"]6231[/TD]
[TD="class: xl72, align: right"]7322.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]4800[/TD]
[TD="class: xl79"]5.0000[/TD]
[TD="class: xl80"]5.588[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1200[/TD]
[TD="class: xl71, align: right"]6232[/TD]
[TD="class: xl72, align: right"]7478.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl77"]4726[/TD]
[TD="class: xl76"]5.0000[/TD]
[TD="class: xl78"]5.570[/TD]
[TD="class: xl81"]✔[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1225[/TD]
[TD="class: xl71, align: right"]6232[/TD]
[TD="class: xl72, align: right"]7634.8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1250[/TD]
[TD="class: xl71, align: right"]6233[/TD]
[TD="class: xl72, align: right"]7791.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1270[/TD]
[TD="class: xl71, align: right"]6233[/TD]
[TD="class: xl72, align: right"]7915.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
(Grid coordinates didn't print)
I do so hope I have been clear on what I am trying to accomplish. And I thank anyone who is able to help me solve what function should go in D21 Longitudinal balance. Whatever it is I will need to do similar for F21 for the Lateral balance for Columns F and G
Again, Thanks!
Bob
