{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["MainMenu","TestInfo","HVIQualityData","YieldAndReturnData","LoanValueGraphs","B","LoanTable","GraphData","PremDisc","G"],"not_rendered":{"charts":1,"images":18,"macros":1,"external_links":0,"defined_names":64,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MainMenu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TestInfo","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,3,6,7],[18,0,18,5]]}
[]
[]
[]
[]
["Study or Variety Test Name :","2016 Example Loan Values"]
[]
["Base Price in Cents per Lint Pound:",52]
[]
["Cotton Seed Value ($/ton) :",185]
[]
["Picking/Stripping & Moduling Cost per Cwt of Seed Cotton:",3.2]
[]
["Ginning Cost Per Pound of Cotton Lint:",0.12]
[]
["Pounds of Seed Per Pound of Cotton Lint:",1.4119999999999999]
[]
["Check this box if cotton was raised in TX/NM/OK/KS."]
[]
["For additional information on how any input data is used, place the cursor over the desired input cell."]

{"sheet":"HVIQualityData","index":2,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,16],[4,7,4,9]]}
[{"$f":"TestInfo!B5&\" HVI Data and Quality Information\"","v":"2016 Example Loan Values HVI Data and Quality Information"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Grade & Length","Strength","Mike",null,"Uniformity","Net"]
[null,null,null,null,null,null,null,null,null,null,null,"Premium","Premium","Premium","Extraneous","Premium","Loan"]
[null,null,null,null,null,null,null,"Extraneous Matter",null,null,null,"or","or","or","Matter","or","Price"]
["Variety","Color","Leaf","Mike","Length","Strength","Uniformity","Bark","Preparation","Other","Staple","Discount","Discount","Discount","Discount","Discount","(cents/lb)"]
["Variety 1",41,4,4.9000000000000004,1.06,26,81.3,null,null,null,{"$f":"IF($E$7>0,VLOOKUP($E$7,HVI,2),0)","v":34},{"$f":"IF($K$7=0,0,(VLOOKUP(($B$7*10+$C$7),LOANLOOK,VLOOKUP($K$7,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$7=0,0,VLOOKUP($F$7,STRENGTHLOOK,2))","v":0},{"$f":"IF(D7>0,VLOOKUP(D7,MIKE,IF(K7<33,1,2)+1),0)","v":0},{"$f":"IF(H7<1,0,IF(H7=0,0,IF(H7=1,ExMat1,IF(H7=2,ExMat2,NA()))))+IF(I7<1,0,IF(I7=0,0,IF(I7=1,Prep1,IF(I7=2,Prep2,NA()))))+IF(J7<1,0,IF(J7=0,0,IF(J7=1,OtherEM1,IF(J7=2,OtherEm2,NA()))))","v":0},{"$f":"IF(G7=0,0,VLOOKUP(G7,UNIFORMITY,2))","v":0},{"$f":"IF(K7<1,0,SUM(L7:P7)/100+BASE)","v":52}]
["Variety 2",41,4,4.8,1.18,28.1,81.900000000000006,null,null,null,{"$f":"IF($E$8>0,VLOOKUP($E$8,HVI,2),0)","v":38},{"$f":"IF($K$8=0,0,+(VLOOKUP(($B$8*10+$C$8),LOANLOOK,VLOOKUP($K$8,STAPLELOOK,2)+1)))","v":230},{"$f":"IF($F$8=0,0,VLOOKUP($F$8,STRENGTHLOOK,2))","v":0},0,{"$f":"IF(H8<1,0,IF(H8=0,0,IF(H8=1,ExMat1,IF(H8=2,ExMat2,NA()))))","v":0},0,{"$f":"IF(K8<1,0,SUM(L8:P8)/100+BASE)","v":54.3}]
["Variety 3",41,4,4.5,1.18,28.1,81.599999999999994,null,null,null,{"$f":"IF($E$9>0,VLOOKUP($E$9,HVI,2),0)","v":38},{"$f":"IF($K$9=0,0,+(VLOOKUP(($B$9*10+$C$9),LOANLOOK,VLOOKUP($K$9,STAPLELOOK,2)+1)))","v":230},{"$f":"IF($F$9=0,0,VLOOKUP($F$9,STRENGTHLOOK,2))","v":0},0,0,0,{"$f":"IF(K9<1,0,SUM(L9:P9)/100+BASE)","v":54.3}]
["Variety 4",41,4,4.3,1.18,28.1,80.599999999999994,null,null,null,{"$f":"IF($E$10>0,VLOOKUP($E$10,HVI,2),0)","v":38},{"$f":"IF($K$10=0,0,+(VLOOKUP(($B$10*10+$C$10),LOANLOOK,VLOOKUP($K$10,STAPLELOOK,2)+1)))","v":230},{"$f":"IF($F$10=0,0,VLOOKUP($F$10,STRENGTHLOOK,2))","v":0},0,0,0,54.3]
["Variety 5",41,4,4.7,1.18,28.1,82.3,null,null,null,{"$f":"IF($E$11>0,VLOOKUP($E$11,HVI,2),0)","v":38},{"$f":"IF($K$11=0,0,+(VLOOKUP(($B$11*10+$C$11),LOANLOOK,VLOOKUP($K$11,STAPLELOOK,2)+1)))","v":230},{"$f":"IF($F$11=0,0,VLOOKUP($F$11,STRENGTHLOOK,2))","v":0},0,0,5,54.35]
["Variety 6",31,6,4.8,1.18,28.1,81.7,null,null,null,{"$f":"IF($E$12>0,VLOOKUP($E$12,HVI,2),0)","v":38},{"$f":"IF($K$12=0,0,+(VLOOKUP(($B$12*10+$C$12),LOANLOOK,VLOOKUP($K$12,STAPLELOOK,2)+1)))","v":-210},{"$f":"IF($F$12=0,0,VLOOKUP($F$12,STRENGTHLOOK,2))","v":0},0,0,0,49.9]
["Variety 7",41,6,5.3,1.18,28.1,82.5,null,null,null,{"$f":"IF($E$13>0,VLOOKUP($E$13,HVI,2),0)","v":38},{"$f":"IF($K$13=0,0,+(VLOOKUP(($B$13*10+$C$13),LOANLOOK,VLOOKUP($K$13,STAPLELOOK,2)+1)))","v":-275},{"$f":"IF($F$13=0,0,VLOOKUP($F$13,STRENGTHLOOK,2))","v":0},-375,0,5,45.55]
["Variety 8",32,7,4.8,1.18,28.1,81.3,null,null,null,{"$f":"IF($E$14>0,VLOOKUP($E$14,HVI,2),0)","v":38},{"$f":"IF($K$14=0,0,+(VLOOKUP(($B$14*10+$C$14),LOANLOOK,VLOOKUP($K$14,STAPLELOOK,2)+1)))","v":-520},{"$f":"IF($F$14=0,0,VLOOKUP($F$14,STRENGTHLOOK,2))","v":0},0,0,0,46.8]
["Variety 9",41,6,4.5999999999999996,1.18,28.1,82.2,null,null,null,{"$f":"IF($E$15>0,VLOOKUP($E$15,HVI,2),0)","v":38},{"$f":"IF($K$15=0,0,+(VLOOKUP(($B$15*10+$C$15),LOANLOOK,VLOOKUP($K$15,STAPLELOOK,2)+1)))","v":-275},{"$f":"IF($F$15=0,0,VLOOKUP($F$15,STRENGTHLOOK,2))","v":0},0,0,5,49.3]
["Variety 10",31,6,5.2,1.18,28.1,82.2,null,null,null,{"$f":"IF($E$16>0,VLOOKUP($E$16,HVI,2),0)","v":38},{"$f":"IF($K$16=0,0,+(VLOOKUP(($B$16*10+$C$16),LOANLOOK,VLOOKUP($K$16,STAPLELOOK,2)+1)))","v":-210},{"$f":"IF($F$16=0,0,VLOOKUP($F$16,STRENGTHLOOK,2))","v":0},-230,0,5,47.65]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$17>0,VLOOKUP($E$17,HVI,2),0)","v":0},{"$f":"IF($K$17=0,0,+(VLOOKUP(($B$17*10+$C$17),LOANLOOK,VLOOKUP($K$17,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP($F$17,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$18>0,VLOOKUP($E$18,HVI,2),0)","v":0},{"$f":"IF($K$18=0,0,+(VLOOKUP(($B$18*10+$C$18),LOANLOOK,VLOOKUP($K$18,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$18=0,0,VLOOKUP($F$18,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$19>0,VLOOKUP($E$19,HVI,2),0)","v":0},{"$f":"IF($K$19=0,0,+(VLOOKUP(($B$19*10+$C$19),LOANLOOK,VLOOKUP($K$19,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$19=0,0,VLOOKUP($F$19,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$20>0,VLOOKUP($E$20,HVI,2),0)","v":0},{"$f":"IF($K$20=0,0,+(VLOOKUP(($B$20*10+$C$20),LOANLOOK,VLOOKUP($K$20,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$20=0,0,VLOOKUP($F$20,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$21>0,VLOOKUP($E$21,HVI,2),0)","v":0},{"$f":"IF($K$21=0,0,+(VLOOKUP(($B$21*10+$C$21),LOANLOOK,VLOOKUP($K$21,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$21=0,0,VLOOKUP($F$21,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$22>0,VLOOKUP($E$22,HVI,2),0)","v":0},{"$f":"IF($K$22=0,0,+(VLOOKUP(($B$22*10+$C$22),LOANLOOK,VLOOKUP($K$22,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$22=0,0,VLOOKUP($F$22,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$23>0,VLOOKUP($E$23,HVI,2),0)","v":0},{"$f":"IF($K$23=0,0,+(VLOOKUP(($B$23*10+$C$23),LOANLOOK,VLOOKUP($K$23,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$23=0,0,VLOOKUP($F$23,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$24>0,VLOOKUP($E$24,HVI,2),0)","v":0},{"$f":"IF($K$24=0,0,+(VLOOKUP(($B$24*10+$C$24),LOANLOOK,VLOOKUP($K$24,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$24=0,0,VLOOKUP($F$24,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$25>0,VLOOKUP($E$25,HVI,2),0)","v":0},{"$f":"IF($K$25=0,0,+(VLOOKUP(($B$25*10+$C$25),LOANLOOK,VLOOKUP($K$25,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$25=0,0,VLOOKUP($F$25,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$26>0,VLOOKUP($E$26,HVI,2),0)","v":0},{"$f":"IF($K$26=0,0,+(VLOOKUP(($B$26*10+$C$26),LOANLOOK,VLOOKUP($K$26,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$26=0,0,VLOOKUP($F$26,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$27>0,VLOOKUP($E$27,HVI,2),0)","v":0},{"$f":"IF($K$27=0,0,+(VLOOKUP(($B$27*10+$C$27),LOANLOOK,VLOOKUP($K$27,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$27=0,0,VLOOKUP($F$27,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$28>0,VLOOKUP($E$28,HVI,2),0)","v":0},{"$f":"IF($K$28=0,0,+(VLOOKUP(($B$28*10+$C$28),LOANLOOK,VLOOKUP($K$28,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$28=0,0,VLOOKUP($F$28,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$29>0,VLOOKUP($E$29,HVI,2),0)","v":0},{"$f":"IF($K$29=0,0,+(VLOOKUP(($B$29*10+$C$29),LOANLOOK,VLOOKUP($K$29,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$29=0,0,VLOOKUP($F$29,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$30>0,VLOOKUP($E$30,HVI,2),0)","v":0},{"$f":"IF($K$30=0,0,+(VLOOKUP(($B$30*10+$C$30),LOANLOOK,VLOOKUP($K$30,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$30=0,0,VLOOKUP($F$30,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$31>0,VLOOKUP($E$31,HVI,2),0)","v":0},{"$f":"IF($K$31=0,0,+(VLOOKUP(($B$31*10+$C$31),LOANLOOK,VLOOKUP($K$31,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$31=0,0,VLOOKUP($F$31,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$32>0,VLOOKUP($E$32,HVI,2),0)","v":0},{"$f":"IF($K$32=0,0,+(VLOOKUP(($B$32*10+$C$32),LOANLOOK,VLOOKUP($K$32,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$32=0,0,VLOOKUP($F$32,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$33>0,VLOOKUP($E$33,HVI,2),0)","v":0},{"$f":"IF($K$33=0,0,+(VLOOKUP(($B$33*10+$C$33),LOANLOOK,VLOOKUP($K$33,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$33=0,0,VLOOKUP($F$33,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$34>0,VLOOKUP($E$34,HVI,2),0)","v":0},{"$f":"IF($K$34=0,0,+(VLOOKUP(($B$34*10+$C$34),LOANLOOK,VLOOKUP($K$34,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$34=0,0,VLOOKUP($F$34,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$35>0,VLOOKUP($E$35,HVI,2),0)","v":0},{"$f":"IF($K$35=0,0,+(VLOOKUP(($B$35*10+$C$35),LOANLOOK,VLOOKUP($K$35,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$35=0,0,VLOOKUP($F$35,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$36>0,VLOOKUP($E$36,HVI,2),0)","v":0},{"$f":"IF($K$36=0,0,+(VLOOKUP(($B$36*10+$C$36),LOANLOOK,VLOOKUP($K$36,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$36=0,0,VLOOKUP($F$36,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$37>0,VLOOKUP($E$37,HVI,2),0)","v":0},{"$f":"IF($K$37=0,0,+(VLOOKUP(($B$37*10+$C$37),LOANLOOK,VLOOKUP($K$37,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$37=0,0,VLOOKUP($F$37,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$38>0,VLOOKUP($E$38,HVI,2),0)","v":0},{"$f":"IF($K$38=0,0,+(VLOOKUP(($B$38*10+$C$38),LOANLOOK,VLOOKUP($K$38,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$38=0,0,VLOOKUP($F$38,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$39>0,VLOOKUP($E$39,HVI,2),0)","v":0},{"$f":"IF($K$39=0,0,+(VLOOKUP(($B$39*10+$C$39),LOANLOOK,VLOOKUP($K$39,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$39=0,0,VLOOKUP($F$39,STRENGTHLOOK,2))","v":0},{"$f":"IF(D39>0,VLOOKUP(D39,MIKE,IF(K39<33,1,2)+1),0)","v":0},{"$f":"IF(H39<1,0,IF(H39=0,0,IF(H39=1,ExMat1,IF(H39=2,ExMat2,NA()))))","v":0},{"$f":"IF(G39=0,0,VLOOKUP(G39,UNIFORMITY,2))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$40>0,VLOOKUP($E$40,HVI,2),0)","v":0},{"$f":"IF($K$40=0,0,+(VLOOKUP(($B$40*10+$C$40),LOANLOOK,VLOOKUP($K$40,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$40=0,0,VLOOKUP($F$40,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$41>0,VLOOKUP($E$41,HVI,2),0)","v":0},{"$f":"IF($K$41=0,0,+(VLOOKUP(($B$41*10+$C$41),LOANLOOK,VLOOKUP($K$41,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$41=0,0,VLOOKUP($F$41,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$42>0,VLOOKUP($E$42,HVI,2),0)","v":0},{"$f":"IF($K$42=0,0,+(VLOOKUP(($B$42*10+$C$42),LOANLOOK,VLOOKUP($K$42,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$42=0,0,VLOOKUP($F$42,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$43>0,VLOOKUP($E$43,HVI,2),0)","v":0},{"$f":"IF($K$43=0,0,+(VLOOKUP(($B$43*10+$C$43),LOANLOOK,VLOOKUP($K$43,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$43=0,0,VLOOKUP($F$43,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$44>0,VLOOKUP($E$44,HVI,2),0)","v":0},{"$f":"IF($K$44=0,0,+(VLOOKUP(($B$44*10+$C$44),LOANLOOK,VLOOKUP($K$44,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$44=0,0,VLOOKUP($F$44,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$45>0,VLOOKUP($E$45,HVI,2),0)","v":0},{"$f":"IF($K$45=0,0,+(VLOOKUP(($B$45*10+$C$45),LOANLOOK,VLOOKUP($K$45,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$45=0,0,VLOOKUP($F$45,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$46>0,VLOOKUP($E$46,HVI,2),0)","v":0},{"$f":"IF($K$46=0,0,+(VLOOKUP(($B$46*10+$C$46),LOANLOOK,VLOOKUP($K$46,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$46=0,0,VLOOKUP($F$46,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$47>0,VLOOKUP($E$47,HVI,2),0)","v":0},{"$f":"IF($K$47=0,0,+(VLOOKUP(($B$47*10+$C$47),LOANLOOK,VLOOKUP($K$47,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$47=0,0,VLOOKUP($F$47,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$48>0,VLOOKUP($E$48,HVI,2),0)","v":0},{"$f":"IF($K$48=0,0,+(VLOOKUP(($B$48*10+$C$48),LOANLOOK,VLOOKUP($K$48,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$48=0,0,VLOOKUP($F$48,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$49>0,VLOOKUP($E$49,HVI,2),0)","v":0},{"$f":"IF($K$49=0,0,+(VLOOKUP(($B$49*10+$C$49),LOANLOOK,VLOOKUP($K$49,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$49=0,0,VLOOKUP($F$49,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$50>0,VLOOKUP($E$50,HVI,2),0)","v":0},{"$f":"IF($K$50=0,0,+(VLOOKUP(($B$50*10+$C$50),LOANLOOK,VLOOKUP($K$50,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$50=0,0,VLOOKUP($F$50,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$51>0,VLOOKUP($E$51,HVI,2),0)","v":0},{"$f":"IF($K$51=0,0,+(VLOOKUP(($B$51*10+$C$51),LOANLOOK,VLOOKUP($K$51,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$51=0,0,VLOOKUP($F$51,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$52>0,VLOOKUP($E$52,HVI,2),0)","v":0},{"$f":"IF($K$52=0,0,+(VLOOKUP(($B$52*10+$C$52),LOANLOOK,VLOOKUP($K$52,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$52=0,0,VLOOKUP($F$52,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$53>0,VLOOKUP($E$53,HVI,2),0)","v":0},{"$f":"IF($K$53=0,0,+(VLOOKUP(($B$53*10+$C$53),LOANLOOK,VLOOKUP($K$53,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$53=0,0,VLOOKUP($F$53,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$54>0,VLOOKUP($E$54,HVI,2),0)","v":0},{"$f":"IF($K$54=0,0,+(VLOOKUP(($B$54*10+$C$54),LOANLOOK,VLOOKUP($K$54,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$54=0,0,VLOOKUP($F$54,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$55>0,VLOOKUP($E$55,HVI,2),0)","v":0},{"$f":"IF($K$55=0,0,+(VLOOKUP(($B$55*10+$C$55),LOANLOOK,VLOOKUP($K$55,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$55=0,0,VLOOKUP($F$55,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$56>0,VLOOKUP($E$56,HVI,2),0)","v":0},{"$f":"IF($K$56=0,0,+(VLOOKUP(($B$56*10+$C$56),LOANLOOK,VLOOKUP($K$56,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$56=0,0,VLOOKUP($F$56,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$57>0,VLOOKUP($E$57,HVI,2),0)","v":0},{"$f":"IF($K$57=0,0,+(VLOOKUP(($B$57*10+$C$57),LOANLOOK,VLOOKUP($K$57,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$57=0,0,VLOOKUP($F$57,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$58>0,VLOOKUP($E$58,HVI,2),0)","v":0},{"$f":"IF($K$58=0,0,+(VLOOKUP(($B$58*10+$C$58),LOANLOOK,VLOOKUP($K$58,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$58=0,0,VLOOKUP($F$58,STRENGTHLOOK,2))","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$59>0,VLOOKUP($E$59,HVI,2),0)","v":0},{"$f":"IF($K$59=0,0,+(VLOOKUP(($B$59*10+$C$59),LOANLOOK,VLOOKUP($K$59,STAPLELOOK,2)+1)))","v":0},{"$f":"IF($F$59=0,0,VLOOKUP($F$59,STRENGTHLOOK,2))","v":0},0,0,0,0]

{"sheet":"YieldAndReturnData","index":3,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[{"$f":"TestInfo!B5&\" Yield and Per Acre Returns\"","v":"2016 Example Loan Values Yield and Per Acre Returns"}]
[]
[null,null,null,"Estimated",null,null,null,"Picking"]
[null,"Lint",null,"Seed","Lint","Seed","Gross","& Moduling","Ginning","Net"]
[null,"Yield","Turnout","Yield","Value","Value","Return","Cost","Cost","Return"]
["Variety","(Lbs/Acre)","(%)","(Lbs/Acre)","($/Acre)","($/Acre)","($/Acre)","($/Acre)","($/Acre)","($/Acre)"]
[{"$f":"+COMPANY","v":"Variety 1"},736,35.799999999999997,{"$f":"ROUND(YieldAndReturnData!B7*TestInfo!$B$15,0)","v":1039},{"$f":"IF(HVIQualityData!Q7<1,0,ROUND(YieldAndReturnData!B7*HVIQualityData!Q7/100,0))","v":383},{"$f":"ROUND(YieldAndReturnData!D7/2000*TestInfo!$B$9,0)","v":96},{"$f":"E7+F7","v":479},{"$f":"IF(YieldAndReturnData!C7>0,ROUND(YieldAndReturnData!B7/(YieldAndReturnData!C7/100)*TestInfo!$B$11/100,0),0)","v":66},{"$f":"ROUND(YieldAndReturnData!B7*TestInfo!$B$13,0)","v":88},{"$f":"G7-H7-I7","v":325}]
[{"$f":"+HVIQualityData!A8","v":"Variety 2"},699,37.9,{"$f":"ROUND(YieldAndReturnData!B8*TestInfo!$B$15,0)","v":987},{"$f":"IF(HVIQualityData!Q8<1,0,ROUND(YieldAndReturnData!B8*HVIQualityData!Q8/100,0))","v":380},{"$f":"ROUND(YieldAndReturnData!D8/2000*TestInfo!$B$9,0)","v":91},471,{"$f":"IF(YieldAndReturnData!C8>0,ROUND(YieldAndReturnData!B8/(YieldAndReturnData!C8/100)*TestInfo!$B$11/100,0),0)","v":59},{"$f":"ROUND(YieldAndReturnData!B8*TestInfo!$B$13,0)","v":84},328]
[{"$f":"+HVIQualityData!A9","v":"Variety 3"},674,35.9,{"$f":"ROUND(YieldAndReturnData!B9*TestInfo!$B$15,0)","v":952},{"$f":"IF(HVIQualityData!Q9<1,0,ROUND(YieldAndReturnData!B9*HVIQualityData!Q9/100,0))","v":366},{"$f":"ROUND(YieldAndReturnData!D9/2000*TestInfo!$B$9,0)","v":88},454,{"$f":"IF(YieldAndReturnData!C9>0,ROUND(YieldAndReturnData!B9/(YieldAndReturnData!C9/100)*TestInfo!$B$11/100,0),0)","v":60},{"$f":"ROUND(YieldAndReturnData!B9*TestInfo!$B$13,0)","v":81},313]
[{"$f":"+HVIQualityData!A10","v":"Variety 4"},671,34.5,{"$f":"ROUND(YieldAndReturnData!B10*TestInfo!$B$15,0)","v":947},{"$f":"IF(HVIQualityData!Q10<1,0,ROUND(YieldAndReturnData!B10*HVIQualityData!Q10/100,0))","v":364},{"$f":"ROUND(YieldAndReturnData!D10/2000*TestInfo!$B$9,0)","v":88},452,{"$f":"IF(YieldAndReturnData!C10>0,ROUND(YieldAndReturnData!B10/(YieldAndReturnData!C10/100)*TestInfo!$B$11/100,0),0)","v":62},{"$f":"ROUND(YieldAndReturnData!B10*TestInfo!$B$13,0)","v":81},309]
[{"$f":"+HVIQualityData!A11","v":"Variety 5"},670,35.700000000000003,{"$f":"ROUND(YieldAndReturnData!B11*TestInfo!$B$15,0)","v":946},{"$f":"IF(HVIQualityData!Q11<1,0,ROUND(YieldAndReturnData!B11*HVIQualityData!Q11/100,0))","v":364},{"$f":"ROUND(YieldAndReturnData!D11/2000*TestInfo!$B$9,0)","v":88},452,{"$f":"IF(YieldAndReturnData!C11>0,ROUND(YieldAndReturnData!B11/(YieldAndReturnData!C11/100)*TestInfo!$B$11/100,0),0)","v":60},{"$f":"ROUND(YieldAndReturnData!B11*TestInfo!$B$13,0)","v":80},312]
[{"$f":"+HVIQualityData!A12","v":"Variety 6"},654,36.9,{"$f":"ROUND(YieldAndReturnData!B12*TestInfo!$B$15,0)","v":923},{"$f":"IF(HVIQualityData!Q12<1,0,ROUND(YieldAndReturnData!B12*HVIQualityData!Q12/100,0))","v":326},{"$f":"ROUND(YieldAndReturnData!D12/2000*TestInfo!$B$9,0)","v":85},411,{"$f":"IF(YieldAndReturnData!C12>0,ROUND(YieldAndReturnData!B12/(YieldAndReturnData!C12/100)*TestInfo!$B$11/100,0),0)","v":57},{"$f":"ROUND(YieldAndReturnData!B12*TestInfo!$B$13,0)","v":78},276]
[{"$f":"+HVIQualityData!A13","v":"Variety 7"},653,37.700000000000003,{"$f":"ROUND(YieldAndReturnData!B13*TestInfo!$B$15,0)","v":922},{"$f":"IF(HVIQualityData!Q13<1,0,ROUND(YieldAndReturnData!B13*HVIQualityData!Q13/100,0))","v":297},{"$f":"ROUND(YieldAndReturnData!D13/2000*TestInfo!$B$9,0)","v":85},382,{"$f":"IF(YieldAndReturnData!C13>0,ROUND(YieldAndReturnData!B13/(YieldAndReturnData!C13/100)*TestInfo!$B$11/100,0),0)","v":55},{"$f":"ROUND(YieldAndReturnData!B13*TestInfo!$B$13,0)","v":78},249]
[{"$f":"+HVIQualityData!A14","v":"Variety 8"},644,37.4,{"$f":"ROUND(YieldAndReturnData!B14*TestInfo!$B$15,0)","v":909},{"$f":"IF(HVIQualityData!Q14<1,0,ROUND(YieldAndReturnData!B14*HVIQualityData!Q14/100,0))","v":301},{"$f":"ROUND(YieldAndReturnData!D14/2000*TestInfo!$B$9,0)","v":84},385,{"$f":"IF(YieldAndReturnData!C14>0,ROUND(YieldAndReturnData!B14/(YieldAndReturnData!C14/100)*TestInfo!$B$11/100,0),0)","v":55},{"$f":"ROUND(YieldAndReturnData!B14*TestInfo!$B$13,0)","v":77},253]
[{"$f":"+HVIQualityData!A15","v":"Variety 9"},635,36.1,{"$f":"ROUND(YieldAndReturnData!B15*TestInfo!$B$15,0)","v":897},{"$f":"IF(HVIQualityData!Q15<1,0,ROUND(YieldAndReturnData!B15*HVIQualityData!Q15/100,0))","v":313},{"$f":"ROUND(YieldAndReturnData!D15/2000*TestInfo!$B$9,0)","v":83},396,{"$f":"IF(YieldAndReturnData!C15>0,ROUND(YieldAndReturnData!B15/(YieldAndReturnData!C15/100)*TestInfo!$B$11/100,0),0)","v":56},{"$f":"ROUND(YieldAndReturnData!B15*TestInfo!$B$13,0)","v":76},264]
[{"$f":"+HVIQualityData!A16","v":"Variety 10"},644,35.6,{"$f":"ROUND(YieldAndReturnData!B16*TestInfo!$B$15,0)","v":909},{"$f":"IF(HVIQualityData!Q16<1,0,ROUND(YieldAndReturnData!B16*HVIQualityData!Q16/100,0))","v":307},{"$f":"ROUND(YieldAndReturnData!D16/2000*TestInfo!$B$9,0)","v":84},391,{"$f":"IF(YieldAndReturnData!C16>0,ROUND(YieldAndReturnData!B16/(YieldAndReturnData!C16/100)*TestInfo!$B$11/100,0),0)","v":58},{"$f":"ROUND(YieldAndReturnData!B16*TestInfo!$B$13,0)","v":77},256]
[{"$f":"+HVIQualityData!A17","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B17*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q17<1,0,ROUND(YieldAndReturnData!B17*HVIQualityData!Q17/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D17/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C17>0,ROUND(YieldAndReturnData!B17/(YieldAndReturnData!C17/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B17*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A18","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B18*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q18<1,0,ROUND(YieldAndReturnData!B18*HVIQualityData!Q18/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D18/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C18>0,ROUND(YieldAndReturnData!B18/(YieldAndReturnData!C18/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B18*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A19","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B19*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q19<1,0,ROUND(YieldAndReturnData!B19*HVIQualityData!Q19/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D19/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C19>0,ROUND(YieldAndReturnData!B19/(YieldAndReturnData!C19/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B19*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A20","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B20*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q20<1,0,ROUND(YieldAndReturnData!B20*HVIQualityData!Q20/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D20/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C20>0,ROUND(YieldAndReturnData!B20/(YieldAndReturnData!C20/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B20*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A21","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B21*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q21<1,0,ROUND(YieldAndReturnData!B21*HVIQualityData!Q21/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D21/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C21>0,ROUND(YieldAndReturnData!B21/(YieldAndReturnData!C21/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B21*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A22","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B22*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q22<1,0,ROUND(YieldAndReturnData!B22*HVIQualityData!Q22/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D22/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C22>0,ROUND(YieldAndReturnData!B22/(YieldAndReturnData!C22/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B22*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A23","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B23*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q23<1,0,ROUND(YieldAndReturnData!B23*HVIQualityData!Q23/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D23/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C23>0,ROUND(YieldAndReturnData!B23/(YieldAndReturnData!C23/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B23*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A24","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B24*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q24<1,0,ROUND(YieldAndReturnData!B24*HVIQualityData!Q24/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D24/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C24>0,ROUND(YieldAndReturnData!B24/(YieldAndReturnData!C24/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B24*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A25","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B25*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q25<1,0,ROUND(YieldAndReturnData!B25*HVIQualityData!Q25/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D25/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C25>0,ROUND(YieldAndReturnData!B25/(YieldAndReturnData!C25/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B25*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A26","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B26*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q26<1,0,ROUND(YieldAndReturnData!B26*HVIQualityData!Q26/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D26/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C26>0,ROUND(YieldAndReturnData!B26/(YieldAndReturnData!C26/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B26*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A27","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B27*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q27<1,0,ROUND(YieldAndReturnData!B27*HVIQualityData!Q27/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D27/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C27>0,ROUND(YieldAndReturnData!B27/(YieldAndReturnData!C27/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B27*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A28","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B28*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q28<1,0,ROUND(YieldAndReturnData!B28*HVIQualityData!Q28/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D28/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C28>0,ROUND(YieldAndReturnData!B28/(YieldAndReturnData!C28/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B28*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A29","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B29*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q29<1,0,ROUND(YieldAndReturnData!B29*HVIQualityData!Q29/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D29/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C29>0,ROUND(YieldAndReturnData!B29/(YieldAndReturnData!C29/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B29*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A30","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B30*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q30<1,0,ROUND(YieldAndReturnData!B30*HVIQualityData!Q30/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D30/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C30>0,ROUND(YieldAndReturnData!B30/(YieldAndReturnData!C30/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B30*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A31","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B31*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q31<1,0,ROUND(YieldAndReturnData!B31*HVIQualityData!Q31/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D31/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C31>0,ROUND(YieldAndReturnData!B31/(YieldAndReturnData!C31/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B31*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A32","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B32*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q32<1,0,ROUND(YieldAndReturnData!B32*HVIQualityData!Q32/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D32/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C32>0,ROUND(YieldAndReturnData!B32/(YieldAndReturnData!C32/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B32*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A33","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B33*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q33<1,0,ROUND(YieldAndReturnData!B33*HVIQualityData!Q33/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D33/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C33>0,ROUND(YieldAndReturnData!B33/(YieldAndReturnData!C33/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B33*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A34","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B34*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q34<1,0,ROUND(YieldAndReturnData!B34*HVIQualityData!Q34/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D34/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C34>0,ROUND(YieldAndReturnData!B34/(YieldAndReturnData!C34/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B34*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A35","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B35*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q35<1,0,ROUND(YieldAndReturnData!B35*HVIQualityData!Q35/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D35/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C35>0,ROUND(YieldAndReturnData!B35/(YieldAndReturnData!C35/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B35*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A36","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B36*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q36<1,0,ROUND(YieldAndReturnData!B36*HVIQualityData!Q36/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D36/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C36>0,ROUND(YieldAndReturnData!B36/(YieldAndReturnData!C36/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B36*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A37","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B37*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q37<1,0,ROUND(YieldAndReturnData!B37*HVIQualityData!Q37/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D37/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C37>0,ROUND(YieldAndReturnData!B37/(YieldAndReturnData!C37/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B37*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A38","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B38*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q38<1,0,ROUND(YieldAndReturnData!B38*HVIQualityData!Q38/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D38/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C38>0,ROUND(YieldAndReturnData!B38/(YieldAndReturnData!C38/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B38*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A39","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B39*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q39<1,0,ROUND(YieldAndReturnData!B39*HVIQualityData!Q39/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D39/2000*TestInfo!$B$9,0)","v":0},{"$f":"E39+F39","v":0},{"$f":"IF(YieldAndReturnData!C39>0,ROUND(YieldAndReturnData!B39/(YieldAndReturnData!C39/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B39*TestInfo!$B$13,0)","v":0},{"$f":"G39-H39-I39","v":0}]
[{"$f":"+HVIQualityData!A40","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B40*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q40<1,0,ROUND(YieldAndReturnData!B40*HVIQualityData!Q40/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D40/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C40>0,ROUND(YieldAndReturnData!B40/(YieldAndReturnData!C40/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B40*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A41","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B41*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q41<1,0,ROUND(YieldAndReturnData!B41*HVIQualityData!Q41/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D41/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C41>0,ROUND(YieldAndReturnData!B41/(YieldAndReturnData!C41/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B41*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A42","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B42*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q42<1,0,ROUND(YieldAndReturnData!B42*HVIQualityData!Q42/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D42/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C42>0,ROUND(YieldAndReturnData!B42/(YieldAndReturnData!C42/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B42*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A43","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B43*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q43<1,0,ROUND(YieldAndReturnData!B43*HVIQualityData!Q43/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D43/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C43>0,ROUND(YieldAndReturnData!B43/(YieldAndReturnData!C43/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B43*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A44","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B44*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q44<1,0,ROUND(YieldAndReturnData!B44*HVIQualityData!Q44/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D44/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C44>0,ROUND(YieldAndReturnData!B44/(YieldAndReturnData!C44/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B44*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A45","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B45*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q45<1,0,ROUND(YieldAndReturnData!B45*HVIQualityData!Q45/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D45/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C45>0,ROUND(YieldAndReturnData!B45/(YieldAndReturnData!C45/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B45*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A46","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B46*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q46<1,0,ROUND(YieldAndReturnData!B46*HVIQualityData!Q46/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D46/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C46>0,ROUND(YieldAndReturnData!B46/(YieldAndReturnData!C46/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B46*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A47","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B47*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q47<1,0,ROUND(YieldAndReturnData!B47*HVIQualityData!Q47/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D47/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C47>0,ROUND(YieldAndReturnData!B47/(YieldAndReturnData!C47/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B47*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A48","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B48*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q48<1,0,ROUND(YieldAndReturnData!B48*HVIQualityData!Q48/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D48/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C48>0,ROUND(YieldAndReturnData!B48/(YieldAndReturnData!C48/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B48*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A49","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B49*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q49<1,0,ROUND(YieldAndReturnData!B49*HVIQualityData!Q49/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D49/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C49>0,ROUND(YieldAndReturnData!B49/(YieldAndReturnData!C49/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B49*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A50","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B50*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q50<1,0,ROUND(YieldAndReturnData!B50*HVIQualityData!Q50/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D50/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C50>0,ROUND(YieldAndReturnData!B50/(YieldAndReturnData!C50/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B50*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A51","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B51*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q51<1,0,ROUND(YieldAndReturnData!B51*HVIQualityData!Q51/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D51/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C51>0,ROUND(YieldAndReturnData!B51/(YieldAndReturnData!C51/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B51*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A52","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B52*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q52<1,0,ROUND(YieldAndReturnData!B52*HVIQualityData!Q52/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D52/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C52>0,ROUND(YieldAndReturnData!B52/(YieldAndReturnData!C52/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B52*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A53","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B53*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q53<1,0,ROUND(YieldAndReturnData!B53*HVIQualityData!Q53/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D53/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C53>0,ROUND(YieldAndReturnData!B53/(YieldAndReturnData!C53/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B53*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A54","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B54*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q54<1,0,ROUND(YieldAndReturnData!B54*HVIQualityData!Q54/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D54/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C54>0,ROUND(YieldAndReturnData!B54/(YieldAndReturnData!C54/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B54*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A55","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B55*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q55<1,0,ROUND(YieldAndReturnData!B55*HVIQualityData!Q55/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D55/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C55>0,ROUND(YieldAndReturnData!B55/(YieldAndReturnData!C55/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B55*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A56","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B56*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q56<1,0,ROUND(YieldAndReturnData!B56*HVIQualityData!Q56/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D56/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C56>0,ROUND(YieldAndReturnData!B56/(YieldAndReturnData!C56/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B56*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A57","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B57*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q57<1,0,ROUND(YieldAndReturnData!B57*HVIQualityData!Q57/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D57/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C57>0,ROUND(YieldAndReturnData!B57/(YieldAndReturnData!C57/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B57*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A58","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B58*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q58<1,0,ROUND(YieldAndReturnData!B58*HVIQualityData!Q58/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D58/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C58>0,ROUND(YieldAndReturnData!B58/(YieldAndReturnData!C58/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B58*TestInfo!$B$13,0)","v":0},0]
[{"$f":"+HVIQualityData!A59","v":0},null,null,{"$f":"ROUND(YieldAndReturnData!B59*TestInfo!$B$15,0)","v":0},{"$f":"IF(HVIQualityData!Q59<1,0,ROUND(YieldAndReturnData!B59*HVIQualityData!Q59/100,0))","v":0},{"$f":"ROUND(YieldAndReturnData!D59/2000*TestInfo!$B$9,0)","v":0},0,{"$f":"IF(YieldAndReturnData!C59>0,ROUND(YieldAndReturnData!B59/(YieldAndReturnData!C59/100)*TestInfo!$B$11/100,0),0)","v":0},{"$f":"ROUND(YieldAndReturnData!B59*TestInfo!$B$13,0)","v":0},0]

{"sheet":"LoanValueGraphs","index":4,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Price per Pound at \"&BASE&\" Cent Base and CCC Premiums and Discounts\"","v":"Price per Pound at 52 Cent Base and CCC Premiums and Discounts"}]
[null,null,null,{"$f":"\"Lint Value in Dollars per Acre at \"&BASE&\" Cent Base and CCC Premiums and Discounts\"","v":"Lint Value in Dollars per Acre at 52 Cent Base and CCC Premiums and Discounts"}]
[null,null,null,{"$f":"\"$ per Acre Net of Harvest & Ginning @ \"&BASE&\" Cent Base w/CCC Premiums and Discounts & $\"&SEEDPRICE&\" /Ton Seed\"","v":"$ per Acre Net of Harvest & Ginning @ 52 Cent Base w/CCC Premiums and Discounts & $185 /Ton Seed"}]

{"sheet":"B","index":5,"n_rows":61,"n_cols":38,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Variety Test",null,null,null,null,null,null,null,null,null,null,null,null,null,"startval"]
["Row width (Inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,"endval"]
["Company",null,null,null,null,null,null,null,null,null,null,null,null,null,"twochk",{"$f":"ROUND((P1+P2)/2,0)","v":0}]
["Check Variety"]
[null,null,null,null,null,null,null,null,"Plot","Plot Yield","Two"]
[null,null,null,null,"  Row","Sample","Percent","Turnout","Size","Per","Check","Adjustment","Adjusted"]
["Plot #","Company","Variety","Rows","Length (ft)","Weight","Turnout","Adjustment","Factor","Acre","Average","Factor","Yield"]
[1,null,null,null,null,null,null,null,{"$f":"IF(D8<1,0,(D8*E8*($C$2/12)/43560))","v":0},{"$f":"IF(D8<1,0,ROUND((F8/I8/100*(G8-H8)),0))","v":0},null,null,null,null,null,null,null,{"$f":"G8-H8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B8=\"Check\",J8,0)","v":0},{"$f":"IF(D8>0,IF(B8=\"Check\",1,0),0)","v":0}]
[2,null,null,null,null,null,null,null,0,0,{"$f":"IF(B9=\"Check\",0,P9)","v":0},{"$f":"IF(B9=\"Check\",0,ROUND(J9/K9,4))","v":0},"+@IF(B9<>\"Check\",@ROUND($CHECK_AVG*L9,0),0)",null,null,null,null,0]
[3,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B10<>\"Check\",@ROUND($CHECK_AVG*L10,0),0)",null,null,null,null,0]
[4,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B11<>\"Check\",@ROUND($CHECK_AVG*L11,0),0)",null,null,null,null,0]
[5,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B12<>\"Check\",@ROUND($CHECK_AVG*L12,0),0)",null,null,null,null,0]
[6,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B13<>\"Check\",@ROUND($CHECK_AVG*L13,0),0)",null,null,null,null,0]
[7,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B14<>\"Check\",@ROUND($CHECK_AVG*L14,0),0)",null,null,null,null,0]
[8,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B15<>\"Check\",@ROUND($CHECK_AVG*L15,0),0)",null,null,null,null,0]
[9,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B16<>\"Check\",@ROUND($CHECK_AVG*L16,0),0)",null,null,null,null,0]
[10,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B17<>\"Check\",@ROUND($CHECK_AVG*L17,0),0)",null,null,null,null,0]
[11,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B18<>\"Check\",@ROUND($CHECK_AVG*L18,0),0)",null,null,null,null,0]
[12,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B19<>\"Check\",@ROUND($CHECK_AVG*L19,0),0)",null,null,null,null,0]
[13,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B20<>\"Check\",@ROUND($CHECK_AVG*L20,0),0)",null,null,null,null,0]
[14,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B21<>\"Check\",@ROUND($CHECK_AVG*L21,0),0)",null,null,null,null,0]
[15,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B22<>\"Check\",@ROUND($CHECK_AVG*L22,0),0)",null,null,null,null,0]
[16,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B23<>\"Check\",@ROUND($CHECK_AVG*L23,0),0)",null,null,null,null,0]
[17,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B24<>\"Check\",@ROUND($CHECK_AVG*L24,0),0)",null,null,null,null,0]
[18,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B25<>\"Check\",@ROUND($CHECK_AVG*L25,0),0)",null,null,null,null,0]
[19,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B26<>\"Check\",@ROUND($CHECK_AVG*L26,0),0)",null,null,null,null,0]
[20,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B27<>\"Check\",@ROUND($CHECK_AVG*L27,0),0)",null,null,null,null,0]
[21,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B28<>\"Check\",@ROUND($CHECK_AVG*L28,0),0)",null,null,null,null,0]
[22,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B29<>\"Check\",@ROUND($CHECK_AVG*L29,0),0)",null,null,null,null,0]
[23,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B30<>\"Check\",@ROUND($CHECK_AVG*L30,0),0)",null,null,null,null,0]
[24,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B31<>\"Check\",@ROUND($CHECK_AVG*L31,0),0)",null,null,null,null,0]
[25,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B32<>\"Check\",@ROUND($CHECK_AVG*L32,0),0)",null,null,null,null,0]
[26,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B33<>\"Check\",@ROUND($CHECK_AVG*L33,0),0)",null,null,null,null,0]
[27,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B34<>\"Check\",@ROUND($CHECK_AVG*L34,0),0)",null,null,null,null,0]
[28,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B35<>\"Check\",@ROUND($CHECK_AVG*L35,0),0)",null,null,null,null,0]
[29,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B36<>\"Check\",@ROUND($CHECK_AVG*L36,0),0)",null,null,null,null,0]
[30,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B37<>\"Check\",@ROUND($CHECK_AVG*L37,0),0)",null,null,null,null,0]
[31,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B38<>\"Check\",@ROUND($CHECK_AVG*L38,0),0)",null,null,null,null,0]
[32,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B39<>\"Check\",@ROUND($CHECK_AVG*L39,0),0)",null,null,null,null,0]
[33,null,null,null,null,null,null,null,{"$f":"IF(D40<1,0,(D40*E40*($C$2/12)/43560))","v":0},{"$f":"IF(D40<1,0,ROUND((F40/I40/100*(G40-H40)),0))","v":0},0,0,"+@IF(B40<>\"Check\",@ROUND($CHECK_AVG*L40,0),0)",null,null,null,null,{"$f":"G40-H40","v":0}]
[34,null,null,null,null,null,null,null,0,0,{"$f":"IF(B41=\"Check\",0,P41)","v":0},{"$f":"IF(B41=\"Check\",0,ROUND(J41/K41,4))","v":0},"+@IF(B41<>\"Check\",@ROUND($CHECK_AVG*L41,0),0)",null,null,null,null,0]
[35,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B42<>\"Check\",@ROUND($CHECK_AVG*L42,0),0)",null,null,null,null,0]
[36,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B43<>\"Check\",@ROUND($CHECK_AVG*L43,0),0)",null,null,null,null,0]
[37,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B44<>\"Check\",@ROUND($CHECK_AVG*L44,0),0)",null,null,null,null,0]
[38,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B45<>\"Check\",@ROUND($CHECK_AVG*L45,0),0)",null,null,null,null,0]
[39,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B46<>\"Check\",@ROUND($CHECK_AVG*L46,0),0)",null,null,null,null,0]
[40,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B47<>\"Check\",@ROUND($CHECK_AVG*L47,0),0)",null,null,null,null,0]
[41,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B48<>\"Check\",@ROUND($CHECK_AVG*L48,0),0)",null,null,null,null,0]
[42,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B49<>\"Check\",@ROUND($CHECK_AVG*L49,0),0)",null,null,null,null,0]
[43,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B50<>\"Check\",@ROUND($CHECK_AVG*L50,0),0)",null,null,null,null,0]
[44,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B51<>\"Check\",@ROUND($CHECK_AVG*L51,0),0)",null,null,null,null,0]
[45,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B52<>\"Check\",@ROUND($CHECK_AVG*L52,0),0)",null,null,null,null,0]
[46,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B53<>\"Check\",@ROUND($CHECK_AVG*L53,0),0)",null,null,null,null,0]
[47,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B54<>\"Check\",@ROUND($CHECK_AVG*L54,0),0)",null,null,null,null,0]
[48,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B55<>\"Check\",@ROUND($CHECK_AVG*L55,0),0)",null,null,null,null,0]
[49,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B56<>\"Check\",@ROUND($CHECK_AVG*L56,0),0)",null,null,null,null,0]
[50,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B57<>\"Check\",@ROUND($CHECK_AVG*L57,0),0)",null,null,null,null,0]
[51,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B58<>\"Check\",@ROUND($CHECK_AVG*L58,0),0)",null,null,null,null,0]
[52,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B59<>\"Check\",@ROUND($CHECK_AVG*L59,0),0)",null,null,null,null,0]
[53,null,null,null,null,null,null,null,0,0,0,0,"+@IF(B60<>\"Check\",@ROUND($CHECK_AVG*L60,0),0)",null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Check Average->",{"$f":"ROUND(AVERAGEA(O8:O60),0)","v":{"$error":"#DIV/0!"}}]

{"sheet":"LoanTable","index":6,"n_rows":203,"n_cols":14,"rows_kept":203,"cut":false,"hidden":true,"merged":[]}
["STAPLE","PRICE"]
[]
[null,26,27,28,29,30,31,32,33,34,35,36,37,38]
[111,-285,-285,-285,-285,-285,-285,-210,-50,145,375,490,525,535]
[112,-285,-285,-285,-285,-285,-285,-210,-50,145,375,490,525,535]
[113,-350,-350,-350,-350,-350,-350,-235,-75,120,315,415,450,465]
[114,-395,-395,-395,-395,-395,-395,-255,-145,70,220,310,325,330]
[115,-505,-505,-505,-505,-505,-505,-355,-260,-65,135,190,200,200]
[116,-680,-680,-680,-680,-680,-680,-505,-425,-280,-205,-185,-185,-185]
[117,-755,-755,-755,-755,-755,-755,-595,-530,-385,-320,-300,-300,-300]
[118,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[121,-455,-455,-455,-455,-455,-455,-265,-115,80,230,335,340,350]
[122,-455,-455,-455,-455,-455,-455,-265,-115,80,230,335,340,350]
[123,-500,-500,-500,-500,-500,-500,-290,-130,65,190,295,305,315]
[124,-530,-530,-530,-530,-530,-530,-315,-215,-40,125,240,245,255]
[125,-645,-645,-645,-645,-645,-645,-470,-410,-235,-105,-75,-70,-70]
[126,-810,-810,-810,-810,-810,-810,-590,-540,-430,-350,-335,-330,-330]
[127,-890,-890,-890,-890,-890,-890,-685,-645,-535,-470,-455,-450,-450]
[128,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[131,-615,-615,-615,-615,-615,-615,-435,-375,-170,-105,-90,-90,-90]
[132,-615,-615,-615,-615,-615,-615,-435,-375,-170,-105,-90,-90,-90]
[133,-660,-660,-660,-660,-660,-660,-460,-400,-195,-130,-115,-115,-115]
[134,-690,-690,-690,-690,-690,-690,-535,-470,-245,-180,-165,-165,-165]
[135,-815,-815,-815,-815,-815,-815,-635,-595,-370,-305,-290,-290,-290]
[136,-930,-930,-930,-930,-930,-930,-715,-675,-445,-385,-370,-370,-370]
[137,-1005,-1005,-1005,-1005,-1005,-1005,-810,-755,-540,-485,-475,-475,-475]
[138,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[211,-285,-285,-285,-285,-285,-285,-210,-50,145,375,490,525,535]
[212,-285,-285,-285,-285,-285,-285,-210,-50,145,375,490,525,535]
[213,-350,-350,-350,-350,-350,-350,-235,-75,120,315,415,450,465]
[214,-395,-395,-395,-395,-395,-395,-255,-145,70,220,310,325,330]
[215,-505,-505,-505,-505,-505,-505,-355,-260,-65,135,190,200,200]
[216,-680,-680,-680,-680,-680,-680,-505,-425,-280,-205,-185,-185,-185]
[217,-755,-755,-755,-755,-755,-755,-595,-530,-385,-320,-300,-300,-300]
[218,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[221,-455,-455,-455,-455,-455,-455,-265,-115,80,230,335,340,350]
[222,-455,-455,-455,-455,-455,-455,-265,-115,80,230,335,340,350]
[223,-500,-500,-500,-500,-500,-500,-290,-130,65,190,295,305,315]
[224,-530,-530,-530,-530,-530,-530,-315,-215,-40,125,240,245,255]
[225,-645,-645,-645,-645,-645,-645,-470,-410,-235,-105,-75,-70,-70]
[226,-810,-810,-810,-810,-810,-810,-590,-540,-430,-350,-335,-330,-330]
[227,-890,-890,-890,-890,-890,-890,-685,-645,-535,-470,-455,-450,-450]
[228,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[231,-615,-615,-615,-615,-615,-615,-435,-375,-170,-105,-90,-90,-90]
[232,-615,-615,-615,-615,-615,-615,-435,-375,-170,-105,-90,-90,-90]
[233,-660,-660,-660,-660,-660,-660,-460,-400,-195,-130,-115,-115,-115]
[234,-690,-690,-690,-690,-690,-690,-535,-470,-245,-180,-165,-165,-165]
[235,-815,-815,-815,-815,-815,-815,-635,-595,-370,-305,-290,-290,-290]
[236,-930,-930,-930,-930,-930,-930,-715,-675,-445,-385,-370,-370,-370]
[237,-1005,-1005,-1005,-1005,-1005,-1005,-810,-755,-540,-485,-475,-475,-475]
[238,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[241,-805,-805,-805,-805,-805,-805,-625,-575,-350,-330,-330,-330,-330]
[242,-805,-805,-805,-805,-805,-805,-625,-575,-350,-330,-330,-330,-330]
[243,-805,-805,-805,-805,-805,-805,-625,-575,-350,-330,-330,-330,-330]
[244,-930,-930,-930,-930,-930,-930,-750,-675,-450,-430,-430,-430,-430]
[245,-1030,-1030,-1030,-1030,-1030,-1030,-850,-800,-575,-555,-555,-555,-555]
[246,-1180,-1180,-1180,-1180,-1180,-1180,-1000,-950,-730,-710,-710,-710,-710]
[247,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[248,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[251,-1065,-1065,-1065,-1065,-1065,-1065,-885,-835,-610,-590,-590,-590,-590]
[252,-1065,-1065,-1065,-1065,-1065,-1065,-885,-835,-610,-590,-590,-590,-590]
[253,-1065,-1065,-1065,-1065,-1065,-1065,-885,-835,-610,-590,-590,-590,-590]
[254,-1190,-1190,-1190,-1190,-1190,-1190,-1010,-935,-710,-690,-690,-690,-690]
[255,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[256,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[257,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[258,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[311,-370,-370,-370,-370,-370,-370,-230,-90,105,320,440,460,470]
[312,-370,-370,-370,-370,-370,-370,-230,-90,105,320,440,460,470]
[313,-415,-415,-415,-415,-415,-415,-245,-100,95,290,395,410,425]
[314,-475,-475,-475,-475,-475,-475,-275,-190,50,175,250,270,280]
[315,-555,-555,-555,-555,-555,-555,-380,-280,-115,80,130,140,140]
[316,-725,-725,-725,-725,-725,-725,-525,-430,-295,-240,-215,-210,-210]
[317,-820,-820,-820,-820,-820,-820,-615,-530,-390,-350,-325,-320,-320]
[318,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[321,-500,-500,-500,-500,-500,-500,-345,-190,-35,35,95,95,100]
[322,-500,-500,-500,-500,-500,-500,-345,-190,-35,35,95,95,100]
[323,-545,-545,-545,-545,-545,-545,-370,-210,-60,5,80,80,85]
[324,-595,-595,-595,-595,-595,-595,-430,-280,-155,-65,5,5,5]
[325,-715,-715,-715,-715,-715,-715,-570,-465,-310,-240,-210,-210,-210]
[326,-880,-880,-880,-880,-880,-880,-660,-600,-475,-425,-410,-410,-410]
[327,-985,-985,-985,-985,-985,-985,-760,-690,-585,-530,-520,-520,-520]
[328,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[331,-735,-735,-735,-735,-735,-735,-510,-450,-230,-185,-170,-170,-170]
[332,-735,-735,-735,-735,-735,-735,-510,-450,-230,-185,-170,-170,-170]
[333,-735,-735,-735,-735,-735,-735,-510,-450,-230,-185,-170,-170,-170]
[334,-810,-810,-810,-810,-810,-810,-585,-520,-280,-235,-225,-225,-225]
[335,-960,-960,-960,-960,-960,-960,-700,-640,-425,-365,-350,-350,-350]
[336,-1025,-1025,-1025,-1025,-1025,-1025,-785,-770,-495,-475,-465,-465,-465]
[337,-1100,-1100,-1100,-1100,-1100,-1100,-885,-825,-620,-575,-565,-565,-565]
[338,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[341,-820,-820,-820,-820,-820,-820,-640,-590,-365,-345,-345,-345,-345]
[342,-820,-820,-820,-820,-820,-820,-640,-590,-365,-345,-345,-345,-345]
[343,-820,-820,-820,-820,-820,-820,-640,-590,-365,-345,-345,-345,-345]
[344,-945,-945,-945,-945,-945,-945,-765,-690,-465,-445,-445,-445,-445]
[345,-1045,-1045,-1045,-1045,-1045,-1045,-865,-815,-590,-570,-570,-570,-570]
[346,-1195,-1195,-1195,-1195,-1195,-1195,-1015,-965,-745,-725,-725,-725,-725]
[347,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[348,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[351,-1080,-1080,-1080,-1080,-1080,-1080,-900,-850,-625,-605,-605,-605,-605]
[352,-1080,-1080,-1080,-1080,-1080,-1080,-900,-850,-625,-605,-605,-605,-605]
[353,-1080,-1080,-1080,-1080,-1080,-1080,-900,-850,-625,-605,-605,-605,-605]
[354,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[355,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[356,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[357,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[358,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[411,-545,-545,-545,-545,-545,-545,-330,-190,45,170,260,270,280]
[412,-545,-545,-545,-545,-545,-545,-330,-190,45,170,260,270,280]
[413,-545,-545,-545,-545,-545,-545,-330,-190,45,170,260,270,280]
[414,-595,-595,-595,-595,-595,-595,-350,-265,0,115,210,220,230]
[415,-630,-630,-630,-630,-630,-630,-460,-375,-195,-90,-20,-20,-20]
[416,-790,-790,-790,-790,-790,-790,-590,-515,-375,-305,-275,-275,-275]
[417,-905,-905,-905,-905,-905,-905,-695,-635,-495,-425,-410,-410,-410]
[418,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[421,-610,-610,-610,-610,-610,-610,-440,-330,-170,-80,-15,-15,-15]
[422,-610,-610,-610,-610,-610,-610,-440,-330,-170,-80,-15,-15,-15]
[423,-610,-610,-610,-610,-610,-610,-440,-330,-170,-80,-15,-15,-15]
[424,-660,-660,-660,-660,-660,-660,-500,-345,-205,-135,-70,-70,-70]
[425,-770,-770,-770,-770,-770,-770,-630,-505,-370,-285,-270,-270,-270]
[426,-985,-985,-985,-985,-985,-985,-730,-660,-505,-455,-445,-445,-445]
[427,-1065,-1065,-1065,-1065,-1065,-1065,-835,-755,-635,-570,-565,-565,-565]
[428,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[431,-785,-785,-785,-785,-785,-785,-630,-530,-375,-330,-315,-315,-315]
[432,-785,-785,-785,-785,-785,-785,-630,-530,-375,-330,-315,-315,-315]
[433,-785,-785,-785,-785,-785,-785,-630,-530,-375,-330,-315,-315,-315]
[434,-860,-860,-860,-860,-860,-860,-675,-575,-410,-350,-335,-335,-335]
[435,-985,-985,-985,-985,-985,-985,-775,-695,-550,-505,-500,-500,-500]
[436,-1075,-1075,-1075,-1075,-1075,-1075,-895,-825,-690,-670,-665,-665,-665]
[437,-1150,-1150,-1150,-1150,-1150,-1150,-1010,-915,-785,-760,-755,-755,-755]
[438,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[441,-940,-940,-940,-940,-940,-940,-760,-710,-480,-465,-465,-465,-465]
[442,-940,-940,-940,-940,-940,-940,-760,-710,-480,-465,-465,-465,-465]
[443,-940,-940,-940,-940,-940,-940,-760,-710,-480,-465,-465,-465,-465]
[444,-1015,-1015,-1015,-1015,-1015,-1015,-860,-760,-530,-515,-515,-515,-515]
[445,-1105,-1105,-1105,-1105,-1105,-1105,-935,-860,-630,-615,-615,-615,-615]
[446,-1255,-1255,-1255,-1255,-1255,-1255,-1080,-1030,-805,-785,-785,-785,-785]
[447,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[448,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[511,-700,-700,-700,-700,-700,-700,-535,-375,-230,-150,-130,-125,-125]
[512,-700,-700,-700,-700,-700,-700,-535,-375,-230,-150,-130,-125,-125]
[513,-700,-700,-700,-700,-700,-700,-535,-375,-230,-150,-130,-125,-125]
[514,-700,-700,-700,-700,-700,-700,-535,-375,-230,-150,-130,-125,-125]
[515,-750,-750,-750,-750,-750,-750,-625,-550,-370,-285,-250,-250,-250]
[516,-915,-915,-915,-915,-915,-915,-720,-655,-500,-445,-420,-420,-420]
[517,-1015,-1015,-1015,-1015,-1015,-1015,-795,-765,-620,-570,-550,-550,-550]
[518,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[521,-810,-810,-810,-810,-810,-810,-605,-475,-390,-320,-320,-320,-320]
[522,-810,-810,-810,-810,-810,-810,-605,-475,-390,-320,-320,-320,-320]
[523,-810,-810,-810,-810,-810,-810,-605,-475,-390,-320,-320,-320,-320]
[524,-810,-810,-810,-810,-810,-810,-605,-475,-390,-320,-320,-320,-320]
[525,-885,-885,-885,-885,-885,-885,-690,-610,-490,-430,-430,-430,-430]
[526,-1100,-1100,-1100,-1100,-1100,-1100,-845,-800,-670,-620,-620,-620,-620]
[527,-1175,-1175,-1175,-1175,-1175,-1175,-965,-925,-790,-745,-745,-745,-745]
[528,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[531,-955,-955,-955,-955,-955,-955,-790,-710,-545,-515,-510,-510,-510]
[532,-955,-955,-955,-955,-955,-955,-790,-710,-545,-515,-510,-510,-510]
[533,-955,-955,-955,-955,-955,-955,-790,-710,-545,-515,-510,-510,-510]
[534,-955,-955,-955,-955,-955,-955,-790,-710,-545,-515,-510,-510,-510]
[535,-1055,-1055,-1055,-1055,-1055,-1055,-885,-835,-670,-640,-640,-640,-640]
[536,-1175,-1175,-1175,-1175,-1175,-1175,-1050,-980,-820,-800,-795,-795,-795]
[537,-1250,-1250,-1250,-1250,-1250,-1250,-1120,-1090,-915,-900,-900,-900,-900]
[538,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[541,-1040,-1040,-1040,-1040,-1040,-1040,-885,-835,-605,-590,-590,-590,-590]
[542,-1040,-1040,-1040,-1040,-1040,-1040,-885,-835,-605,-590,-590,-590,-590]
[543,-1040,-1040,-1040,-1040,-1040,-1040,-885,-835,-605,-590,-590,-590,-590]
[544,-1040,-1040,-1040,-1040,-1040,-1040,-885,-835,-605,-590,-590,-590,-590]
[545,-1130,-1130,-1130,-1130,-1130,-1130,-960,-885,-675,-655,-655,-655,-655]
[546,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[547,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[548,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[611,-775,-775,-775,-775,-775,-775,-680,-625,-460,-405,-400,-400,-400]
[612,-775,-775,-775,-775,-775,-775,-680,-625,-460,-405,-400,-400,-400]
[613,-775,-775,-775,-775,-775,-775,-680,-625,-460,-405,-400,-400,-400]
[614,-775,-775,-775,-775,-775,-775,-680,-625,-460,-405,-400,-400,-400]
[615,-775,-775,-775,-775,-775,-775,-680,-625,-460,-405,-400,-400,-400]
[616,-925,-925,-925,-925,-925,-925,-815,-765,-650,-600,-580,-580,-580]
[617,-1025,-1025,-1025,-1025,-1025,-1025,-945,-870,-735,-685,-675,-675,-675]
[618,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[621,-935,-935,-935,-935,-935,-935,-810,-750,-625,-595,-595,-595,-595]
[622,-935,-935,-935,-935,-935,-935,-810,-750,-625,-595,-595,-595,-595]
[623,-935,-935,-935,-935,-935,-935,-810,-750,-625,-595,-595,-595,-595]
[624,-935,-935,-935,-935,-935,-935,-810,-750,-625,-595,-595,-595,-595]
[625,-935,-935,-935,-935,-935,-935,-810,-750,-625,-595,-595,-595,-595]
[626,-1125,-1125,-1125,-1125,-1125,-1125,-1000,-940,-805,-780,-780,-780,-780]
[627,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[628,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[631,-1175,-1175,-1175,-1175,-1175,-1175,-1020,-955,-755,-710,-705,-705,-705]
[632,-1175,-1175,-1175,-1175,-1175,-1175,-1020,-955,-755,-710,-705,-705,-705]
[633,-1175,-1175,-1175,-1175,-1175,-1175,-1020,-955,-755,-710,-705,-705,-705]
[634,-1175,-1175,-1175,-1175,-1175,-1175,-1020,-955,-755,-710,-705,-705,-705]
[635,-1175,-1175,-1175,-1175,-1175,-1175,-1020,-955,-755,-710,-705,-705,-705]
[636,-1250,-1250,-1250,-1250,-1250,-1250,-1130,-1055,-885,-860,-860,-860,-860]
[637,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[638,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]
[711,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[712,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[713,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[714,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[715,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[716,-980,-980,-980,-980,-980,-980,-980,-920,-775,-730,-730,-730,-730]
[717,-1070,-1070,-1070,-1070,-1070,-1070,-1015,-965,-815,-785,-785,-785,-785]
[718,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000,-4000]

{"sheet":"GraphData","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Variety 1",52]
["Variety 2",54.3]
["Variety 3",54.3]
["Variety 4",54.3]
["Variety 5",54.35]
["Variety 6",49.9]
["Variety 7",45.55]
["Variety 8",46.8]
["Variety 9",49.3]
["Variety 10",47.65]

{"sheet":"PremDisc","index":8,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Strength","P/D",null,"Mike","P/D",null,null,"Mike1","P/D",null,null,"Extraneous Matter",null,null,"Uniformity","P/D"]
[null,-500,null,null,"<=32",">=33",null,null,"<=32",">=33"]
[18,-255,null,null,-945,-945,null,2.4,{"$f":"E4","v":-945},{"$f":"F4","v":-945},null,"Bark1 - TX/NM/OK/KS",-320,null,null,-100]
[19,-255,null,2.4,-945,-945,null,2.5,{"$f":"E5","v":-895},{"$f":"F5","v":-895},null,"Bark2 - TX/NM/OK/KS",-505,null,77.900000000000006,-100]
[20,-255,null,2.5,-895,-895,null,2.7,-585,-585,null,null,null,null,78,-90]
[21,-255,null,2.7,-585,-585,null,3,-350,-350,null,"Bark1 - Other Locations",-445,null,79,-75]
[22,-210,null,3,-350,-350,null,3.3,-180,-180,null,"Bark2 - Other Locations",-705,null,80,0]
[23,-180,null,3.3,-180,-180,null,3.5,0,0,null,null,null,null,81,0]
[24,-170,null,3.5,0,0,null,3.7,15,15,null,null,null,null,82,5]
[25,-145,null,3.7,15,15,null,4.2,0,0,null,"ExMat1",{"$f":"M6","v":-445},null,83,15]
[26,0,null,4.3,0,0,null,5,-230,-230,null,"ExMat2",{"$f":"M7","v":-705},null,84,25]
[27,0,null,5,-230,-230,null,5.3,-375,-375,null,null,null,null,85,35]
[28,0,null,5.3,-375,-375,null,null,-375,-375,null,null,null,null,86,45]
[29,5,null,null,-375,-375,null,null,null,null,null,"Preparation - Level 1",-160,null,null,45]
[30,25,null,null,null,null,null,null,null,null,null,"Preparation - Level 2",-630]
[31,40]
[33,45,null,null,null,null,null,null,null,null,null,"Other Extraneous - Level 1",{"$f":"M6","v":-445}]
[null,45,null,null,null,null,null,null,null,null,null,"Other Extraneous - Level 2",{"$f":"M7","v":-705}]

{"sheet":"G","index":9,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Staple","Offset",null,null,"HVI","STAPLE"]
[]
[26,1,null,null,0.8,26]
[27,2,null,null,0.86,28]
[28,3,null,null,0.9,29]
[29,4,null,null,0.93,30]
[30,5,null,null,0.96,31]
[31,6,null,null,0.99,32]
[32,7,null,null,1.02,33]
[33,8,null,null,1.05,34]
[34,9,null,null,1.08,35]
[35,10,null,null,1.1100000000000001,36]
[36,11,null,null,1.1399999999999999,37]
[37,12,null,null,1.18,38]
[38,13,null,null,1.21,39]
[null,null,null,null,1.24,40]
[null,null,null,null,1.27,41]
[null,null,null,null,1.3,42]
[null,null,null,null,1.33,43]
[null,null,null,null,1.36,44]