{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["USER NOTES","LeafConcentrationsEntry","DRISCalculations","DRISIndices","ConcentrationsPlusDRIS","CriticalValues"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":0,"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":"USER NOTES","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Sugarcane DRIS Calculator Notes:"]
["1.  For the DRIS calculator to work properly it is important to have an entry for each of the first 9 listed nutrients, LeafN through LeafCu. LeafSi is included for comparison of entered values with critical values, but DRIS norms for silicon are not available at this time."]
[]
["2.  After you enter your leaf concentrations select the Calculate DRIS Indices button. Then you will be able to view the DRIS indices alone and paired with the concentrations for each nutrient."]
[]
["3.  Nutrient concentrations below the critical value are colored red and concentrations above the optimum range are colored blue. "]
[]
["4.  A negative DRIS index value indicates the nutrient is insufficient relative to other nutrient levels. A positive DRIS index value indicates the nutrient is excessive relative to other nutrients. A DRIS index value of zero or near zero indicates the nutrient is in optimum balance with other nutrients. DRIS index values less than -10 are colored red and DRIS index values greater than +10 are colored blue. "]
[]
["5.  Nutrient Balance Index (NBI = Sum of the absolute value of all DRIS indices for a sample) is used to indicate the overall nutrient balance for a sample; the higher the number the more imbalance. NBI values greater than 80 are bolded black. "]
[]
["6.  The DRIS values and NBI values designated out of range (red or blue) are best guess estimates at this point. Specific recommendations will be revised once analyses of research currently being conducted is completed."]

{"sheet":"LeafConcentrationsEntry","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,10,6,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[5,8,6,8],[5,9,6,9],[5,0,7,0],[5,4,6,4],[7,1,7,5],[7,6,7,9],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,5,6,5],[5,6,6,6],[5,7,6,7]]}
["Sugarcane Leaf Nutrient Concentration Entry Sheet"]
["Important!"]
[" All data entry should be in the correct units for each nutrient as shown below."]
["Note that mg/kg is the same as ppm. "]
["Also, for the DRIS calculator to work properly it is important to have an entry for each of first 9 listed nutrients (Si is optional)."]
["SampleID","LeafN","LeafP","LeafK","LeafCa","LeafMg","LeafFe","LeafMn","LeafZn","LeafCu","LeafSi"]
[]
[null,"---------------------------------%------------------------------",null,null,null,null,"-------------------------mg/kg-----------------------",null,null,null,"%"]
["Fielda",2.58,0.217,1.33,0.3,0.13,44,6,18,4.5999999999999996,0.6]
["Fieldb",2.44,0.24099999999999999,1.54,0.42,0.17,57,10,20,5.9,0.4]
["Fieldc",2.76,0.28899999999999998,1.78,0.37,0.21,60,16,21,7.3,0.8]
["Fieldd",2.61,0.224,1.6,0.36,0.18,64,10,21,7.6,0.2]
["Fielde",2.93,0.28299999999999997,1.7,0.44,0.14000000000000001,67,23,21,6.2,0.6]
["Fieldf",2.8,0.32500000000000001,1.75,0.51,0.17,63,78,21,5.5,0.5]
["Fieldg",2.62,0.27100000000000002,1.55,0.46,0.19,58,27,19,3.5,0.2]
["Fieldh",2.4700000000000002,0.22800000000000001,1.52,0.56000000000000005,0.26,91,10,29,9.1999999999999993,0.5]
["Fieldi",2.58,0.26100000000000001,1.55,0.46,0.22,67,11,21,6.8,0.57999999999999996]
["Fieldj",2.4700000000000002,0.253,1.98,0.52,0.17,74,8,22,8.6,0.68]
["Field1",2.2799999999999998,0.28000000000000003,1.56,0.28000000000000003,0.28000000000000003,74,17,19,5,1.2]
["Field2",2.4,0.23,1.51,0.21,0.15,81,11,16,6,1.5]
["Field3",1.84,0.25,1.38,0.26,0.26,74,13,13,7,1.8]
["Field4",2.12,0.26,1.35,0.26,0.3,74,17,16,3,2]
["Field5",2.08,0.25,1.65,0.27,0.28999999999999998,70,44,16,7,0.44]
["Field6",1.9,0.31,1.63,0.22,0.18,70,24,18,6,0.51]
["Field7",1.9,0.22,1.2,0.24,0.28000000000000003,67,46,17,7,0.49]
["Field8",1.82,0.3,1.19,0.2,0.26,69,25,14,6,0.75]

{"sheet":"DRISCalculations","index":2,"n_rows":26,"n_cols":82,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["This sheet is protected. It is used to calculate DRIS indices on other pages in this spreadsheet."]
[]
[]
[]
[]
[]
["LNP","FLNP","LNK","FLNK","LCAN","FLCAN","LMGN","FLMGN","LNMN","FLNMN","LFEN","FLFEN","LZNN","FLZNN","LNCU","FLNCU","LKP","FLKP","LCAP","FLCAP","LMGP","FLMGP","LPMN","FLPMN","LFEP","FLFEP","LZNP","FLZNP","LPCU","FLPCU","LCAK","FLCAK","LMGK","FLMGK","LKMN","FLKMN","LFEK","FLFEK","LZNK","FLZNK","LCUK","FLCUK","LCAMG","FLCAMG","LCAMN","FLCAMN","LFECA","FLFECA","LCAZN","FLCAZN","LCACU","FLCACU","LMGMN","FLMGMN","LMGFE","FLMGFE","LMGZN","FLMGZN","LMGCU","FLMGCU","LFEMN","FLFEMN","LZNMN","FLZNMN","LMNCU","FLMNCU","LZNFE","FLZNFE","LFECU","FLFECU","LZNCU","FLZNCU","N Index","P Index","K Index","Ca Index","Mg Index","Fe Index","Mn Index","Zn Index","Cu Index","NBI"]
[]
[{"$f":"LN/LP","v":11.889400921658986},{"$f":"IF(A9>9.905,((A9/8.706)-1)*(1000/13.8), IF(A9<7.507,(1-(8.706/A9))*(1000/13.8),0))","v":26.496809810150815},{"$f":"LN/LK","v":1.9398496240601504},{"$f":"IF(C9>1.783,((C9/1.526)-1)*(1000/16.8), IF(C9<1.269,(1-(1.526/C9))*(1000/16.8),0))","v":16.142795671072463},{"$f":"LCA/LN","v":0.11627906976744186},{"$f":"IF(E9>0.183,((E9/0.151)-1)*(1000/21.2), IF(E9<0.119,(1-(0.151/E9))*(1000/21.2),0))","v":-14.084905660377357},{"$f":"LMG/LN","v":5.0387596899224806E-2},{"$f":"IF(G9>0.141,((G9/0.113)-1)*(1000/24.8), IF(G9<0.085,(1-(0.113/G9))*(1000/24.8),0))","v":-50.105459057071961},{"$f":"(LN*100)/LMN","v":43},{"$f":"IF(I9>15.524,((I9/9.401)-1)*(1000/65.1), IF(I9<3.728,(1-(9.401/I9))*(1000/65.1),0))","v":54.899869298474805},{"$f":"LFE/(LN*100)","v":0.17054263565891473},{"$f":"IF(K9>0.408,((K9/0.351)-1)*(1000/16.2), IF(K9<0.294,(1-(0.351/K9))*(1000/16.2),0))","v":-65.31705948372614},{"$f":"LZN/(LN*100)","v":6.9767441860465115E-2},{"$f":"IF(M9>0.127,((M9/0.106)-1)*(1000/19.8), IF(M9<0.085,(1-(0.106/M9))*(1000/19.8),0))","v":-26.228956228956221},{"$f":"(LN*10)/LCU","v":5.608695652173914},{"$f":"IF(O9>6.883,((O9/4.998)-1)*(1000/37.7), IF(O9<3.113,(1-(4.998/O9))*(1000/37.7),0))","v":0},{"$f":"LK/LP","v":6.1290322580645169},{"$f":"IF(Q9>6.671,((Q9/5.633)-1)*(1000/18.4), IF(Q9<4.595,(1-(5.633/Q9))*(1000/18.4),0))","v":0},{"$f":"LCA/LP","v":1.3824884792626728},{"$f":"IF(S9>1.663,((S9/1.314)-1)*(1000/26.6), IF(S9<0.965,(1-(1.314/S9))*(1000/26.6),0))","v":0},{"$f":"LMG/LP","v":0.59907834101382496},{"$f":"IF(U9>1.268,((U9/0.984)-1)*(1000/28.9), IF(U9<0.7,(1-(0.984/U9))*(1000/28.9),0))","v":-22.232632419483625},{"$f":"(LP*100)/LMN","v":3.6166666666666667},{"$f":"IF(W9>1.772,((W9/1.086)-1)*(1000/63.2), IF(W9<0.4,(1-(1.086/W9))*(1000/63.2),0))","v":36.871265278846224},{"$f":"LFE/(LP*100)","v":2.0276497695852536},{"$f":"IF(Y9>3.595,((Y9/2.995)-1)*(1000/20), IF(Y9<2.395,(1-(2.995/Y9))*(1000/20),0))","v":-23.853977272727267},{"$f":"LZN/(LP*100)","v":0.82949308755760376},{"$f":"IF(AA9>1.124,((AA9/0.908)-1)*(1000/23.8), IF(AA9<0.692,(1-(0.908/AA9))*(1000/23.8),0))","v":0},{"$f":"(LP*10)/LCU","v":0.47173913043478261},{"$f":"IF(AC9>0.827,((AC9/0.588)-1)*(1000/40.6), IF(AC9<0.349,(1-(0.588/AC9))*(1000/40.6),0))","v":0},{"$f":"LCA/LK","v":0.22556390977443608},{"$f":"IF(AE9>0.285,((AE9/0.222)-1)*(1000/28.4), IF(AE9<0.159,(1-(0.222/AE9))*(1000/28.4),0))","v":0},{"$f":"LMG/LK","v":9.7744360902255634E-2},{"$f":"IF(AG9>0.215,((AG9/0.163)-1)*(1000/31.9), IF(AG9<0.111,(1-(0.163/AG9))*(1000/31.9),0))","v":-20.928381962864727},{"$f":"(LK*100)/LMN","v":22.166666666666668},{"$f":"IF(AI9>7.809,((AI9/4.615)-1)*(1000/69.2), IF(AI9<1.421,(1-(4.615/AI9))*(1000/69.2),0))","v":54.959220268998003},{"$f":"LFE/(LK*100)","v":0.33082706766917291},{"$f":"IF(AK9>0.67,((AK9/0.55)-1)*(1000/21.8), IF(AK9<0.43,(1-(0.55/AK9))*(1000/21.8),0))","v":-30.389908256880748},{"$f":"LZN/(LK*100)","v":0.13533834586466165},{"$f":"IF(AM9>0.2,((AM9/0.157)-1)*(1000/27.4), IF(AM9<0.114,(1-(0.157/AM9))*(1000/27.4),0))","v":0},{"$f":"LCU/(LK*10)","v":0.34586466165413532},{"$f":"IF(AO9>0.453,((AO9/0.33)-1)*(1000/37.3), IF(AO9<0.207,(1-(0.33/AO9))*(1000/37.3),0))","v":0},{"$f":"LCA/LMG","v":2.3076923076923075},{"$f":"IF(AQ9>1.754,((AQ9/1.373)-1)*(1000/27.7), IF(AQ9<0.992,(1-(1.373/AQ9))*(1000/27.7),0))","v":24.57640539681762},{"$f":"(LCA*100)/LMN","v":5},{"$f":"IF(AS9>2.591,((AS9/1.502)-1)*(1000/72.5), IF(AS9<0.413,(1-(1.502/AS9))*(1000/72.5),0))","v":32.122686992056565},{"$f":"LFE/(LCA*100)","v":1.4666666666666666},{"$f":"IF(AU9>3.048,((AU9/2.414)-1)*(1000/26.3), IF(AU9<1.78,(1-(2.414/AU9))*(1000/26.3),0))","v":-24.559281023159361},{"$f":"(LCA*100)/LZN","v":1.6666666666666667},{"$f":"IF(AW9>1.871,((AW9/1.473)-1)*(1000/27), IF(AW9<1.075,(1-(1.473/AW9))*(1000/27),0))","v":0},{"$f":"(LCA*10)/LCU","v":0.65217391304347827},{"$f":"IF(AY9>1.067,((AY9/0.743)-1)*(1000/43.6), IF(AY9<0.419,(1-(0.743/AY9))*(1000/43.6),0))","v":0},{"$f":"(LMG*100)/LMN","v":2.1666666666666665},{"$f":"IF(BA9>1.998,((BA9/1.129)-1)*(1000/77), IF(BA9<0.26,(1-(1.129/BA9))*(1000/77),0))","v":11.936395461639039},{"$f":"(LMG*100)/LFE","v":0.29545454545454547},{"$f":"IF(BC9>0.421,((BC9/0.329)-1)*(1000/28), IF(BC9<0.237,(1-(0.329/BC9))*(1000/28),0))","v":0},{"$f":"(LMG*100)/LZN","v":0.72222222222222221},{"$f":"IF(BE9>1.418,((BE9/1.1)-1)*(1000/28.9), IF(BE9<0.782,(1-(1.1/BE9))*(1000/28.9),0))","v":-18.099547511312224},{"$f":"(LMG*10)/LCU","v":0.28260869565217395},{"$f":"IF(BG9>0.78,((BG9/0.552)-1)*(1000/41.3), IF(BG9<0.324,(1-(0.552/BG9))*(1000/41.3),0))","v":-23.080648165393924},{"$f":"LFE/LMN","v":7.333333333333333},{"$f":"IF(BI9>5.493,((BI9/3.302)-1)*(1000/66.3), IF(BI9<1.111,(1-(3.302/BI9))*(1000/66.3),0))","v":18.414422875177497},{"$f":"LZN/LMN","v":3},{"$f":"IF(BK9>1.756,((BK9/1.008)-1)*(1000/74.2), IF(BK9<0.26,(1-(1.008/BK9))*(1000/74.2),0))","v":26.63329482736491},{"$f":"LMN/(LCU*10)","v":0.13043478260869565},{"$f":"IF(BM9>1.95,((BM9/0.998)-1)*(1000/95.4), IF(BM9<0.046,(1-(0.998/BM9))*(1000/95.4),0))","v":0},{"$f":"LZN/LFE","v":0.40909090909090912},{"$f":"IF(BO9>0.392,((BO9/0.312)-1)*(1000/25.6), IF(BO9<0.232,(1-(0.312/BO9))*(1000/25.6),0))","v":12.15581293706294},{"$f":"LFE/(LCU*10)","v":0.95652173913043481},{"$f":"IF(BQ9>2.426,((BQ9/1.733)-1)*(1000/40), IF(BQ9<1.04,(1-(1.733/BQ9))*(1000/40),0))","v":-20.294318181818184},{"$f":"LZN/(LCU*10)","v":0.39130434782608697},{"$f":"IF(BS9>0.723,((BS9/0.522)-1)*(1000/38.5), IF(BS9<0.321,(1-(0.522/BS9))*(1000/38.5),0))","v":0},{"$f":"(B9+D9-F9-H9+J9-L9-N9+P9)/8","v":31.659481901228723},{"$f":"(X9+AD9-B9-R9-T9-V9-Z9-AB9)/8","v":7.0576331451132877},{"$f":"(R9+AJ9-D9-AF9-AH9-AL9-AN9-AP9)/8","v":11.266839352208876},{"$f":"(F9+T9+AF9+AR9+AT9-AV9+AX9+AZ9)/8","v":8.3966834689570238},{"$f":"(H9-AR9+V9+AH9+BB9+BD9+BF9+BH9)/8","v":-18.385834881413132},{"$f":"(L9+Z9+AL9+AV9-BD9+BJ9-BP9+BR9)/8","v":-19.769491785024641},{"$f":"(BN9-J9-X9-AJ9-AT9-BB9-BJ9-BL9)/8","v":-29.479644375319634},{"$f":"(N9+AB9+AN9-AX9-BF9+BP9+BL9+BT9)/8","v":3.8324623808479816},{"$f":"(AP9-P9-AD9-AZ9-BH9-BR9-BN9-BT9)/8","v":5.4218707934015136},{"$f":"ABS(BU9)+ABS(BV9)+ABS(BW9)+ABS(BX9)+ABS(BY9)+ABS(BZ9)+ABS(CA9)+ABS(CB9)+ABS(CC9)","v":135.26994208351482}]
[10.124481327800829,{"$f":"IF(A10>9.905,((A10/8.706)-1)*(1000/13.8), IF(A10<7.507,(1-(8.706/A10))*(1000/13.8),0))","v":11.806627844538584},1.5844155844155843,{"$f":"IF(C10>1.783,((C10/1.526)-1)*(1000/16.8), IF(C10<1.269,(1-(1.526/C10))*(1000/16.8),0))","v":0},0.1721311475409836,{"$f":"IF(E10>0.183,((E10/0.151)-1)*(1000/21.2), IF(E10<0.119,(1-(0.151/E10))*(1000/21.2),0))","v":0},6.9672131147540992E-2,{"$f":"IF(G10>0.141,((G10/0.113)-1)*(1000/24.8), IF(G10<0.085,(1-(0.113/G10))*(1000/24.8),0))","v":-25.075901328273236},24.4,{"$f":"IF(I10>15.524,((I10/9.401)-1)*(1000/65.1), IF(I10<3.728,(1-(9.401/I10))*(1000/65.1),0))","v":24.507965701593008},0.23360655737704919,{"$f":"IF(K10>0.408,((K10/0.351)-1)*(1000/16.2), IF(K10<0.294,(1-(0.351/K10))*(1000/16.2),0))","v":-31.0201429499675},8.1967213114754092E-2,{"$f":"IF(M10>0.127,((M10/0.106)-1)*(1000/19.8), IF(M10<0.085,(1-(0.106/M10))*(1000/19.8),0))","v":-14.808080808080815},4.1355932203389827,{"$f":"IF(O10>6.883,((O10/4.998)-1)*(1000/37.7), IF(O10<3.113,(1-(4.998/O10))*(1000/37.7),0))","v":0},6.390041493775934,{"$f":"IF(Q10>6.671,((Q10/5.633)-1)*(1000/18.4), IF(Q10<4.595,(1-(5.633/Q10))*(1000/18.4),0))","v":0},1.7427385892116183,{"$f":"IF(S10>1.663,((S10/1.314)-1)*(1000/26.6), IF(S10<0.965,(1-(1.314/S10))*(1000/26.6),0))","v":12.266356221936642},0.70539419087136934,{"$f":"IF(U10>1.268,((U10/0.984)-1)*(1000/28.9), IF(U10<0.7,(1-(0.984/U10))*(1000/28.9),0))","v":0},2.4099999999999997,{"$f":"IF(W10>1.772,((W10/1.086)-1)*(1000/63.2), IF(W10<0.4,(1-(1.086/W10))*(1000/63.2),0))","v":19.290393267594467},2.3651452282157677,{"$f":"IF(Y10>3.595,((Y10/2.995)-1)*(1000/20), IF(Y10<2.395,(1-(2.995/Y10))*(1000/20),0))","v":-13.315350877192989},0.82987551867219922,{"$f":"IF(AA10>1.124,((AA10/0.908)-1)*(1000/23.8), IF(AA10<0.692,(1-(0.908/AA10))*(1000/23.8),0))","v":0},0.40847457627118644,{"$f":"IF(AC10>0.827,((AC10/0.588)-1)*(1000/40.6), IF(AC10<0.349,(1-(0.588/AC10))*(1000/40.6),0))","v":0},0.27272727272727271,{"$f":"IF(AE10>0.285,((AE10/0.222)-1)*(1000/28.4), IF(AE10<0.159,(1-(0.222/AE10))*(1000/28.4),0))","v":0},0.1103896103896104,{"$f":"IF(AG10>0.215,((AG10/0.163)-1)*(1000/31.9), IF(AG10<0.111,(1-(0.163/AG10))*(1000/31.9),0))","v":-14.940070071915912},15.4,{"$f":"IF(AI10>7.809,((AI10/4.615)-1)*(1000/69.2), IF(AI10<1.421,(1-(4.615/AI10))*(1000/69.2),0))","v":33.770877823633661},0.37012987012987014,{"$f":"IF(AK10>0.67,((AK10/0.55)-1)*(1000/21.8), IF(AK10<0.43,(1-(0.55/AK10))*(1000/21.8),0))","v":-22.291968453243207},0.12987012987012986,{"$f":"IF(AM10>0.2,((AM10/0.157)-1)*(1000/27.4), IF(AM10<0.114,(1-(0.157/AM10))*(1000/27.4),0))","v":0},0.38311688311688313,{"$f":"IF(AO10>0.453,((AO10/0.33)-1)*(1000/37.3), IF(AO10<0.207,(1-(0.33/AO10))*(1000/37.3),0))","v":0},2.4705882352941173,{"$f":"IF(AQ10>1.754,((AQ10/1.373)-1)*(1000/27.7), IF(AQ10<0.992,(1-(1.373/AQ10))*(1000/27.7),0))","v":28.859522227121762},4.2,{"$f":"IF(AS10>2.591,((AS10/1.502)-1)*(1000/72.5), IF(AS10<0.413,(1-(1.502/AS10))*(1000/72.5),0))","v":24.77616052160338},1.3571428571428572,{"$f":"IF(AU10>3.048,((AU10/2.414)-1)*(1000/26.3), IF(AU10<1.78,(1-(2.414/AU10))*(1000/26.3),0))","v":-29.609765859515711},2.1,{"$f":"IF(AW10>1.871,((AW10/1.473)-1)*(1000/27), IF(AW10<1.075,(1-(1.473/AW10))*(1000/27),0))","v":15.765256091121671},0.71186440677966101,{"$f":"IF(AY10>1.067,((AY10/0.743)-1)*(1000/43.6), IF(AY10<0.419,(1-(0.743/AY10))*(1000/43.6),0))","v":0},1.7,{"$f":"IF(BA10>1.998,((BA10/1.129)-1)*(1000/77), IF(BA10<0.26,(1-(1.129/BA10))*(1000/77),0))","v":0},0.2982456140350877,{"$f":"IF(BC10>0.421,((BC10/0.329)-1)*(1000/28), IF(BC10<0.237,(1-(0.329/BC10))*(1000/28),0))","v":0},0.85,{"$f":"IF(BE10>1.418,((BE10/1.1)-1)*(1000/28.9), IF(BE10<0.782,(1-(1.1/BE10))*(1000/28.9),0))","v":0},0.28813559322033899,{"$f":"IF(BG10>0.78,((BG10/0.552)-1)*(1000/41.3), IF(BG10<0.324,(1-(0.552/BG10))*(1000/41.3),0))","v":-22.173479561316054},5.7,{"$f":"IF(BI10>5.493,((BI10/3.302)-1)*(1000/66.3), IF(BI10<1.111,(1-(3.302/BI10))*(1000/66.3),0))","v":10.953642977015621},2,{"$f":"IF(BK10>1.756,((BK10/1.008)-1)*(1000/74.2), IF(BK10<0.26,(1-(1.008/BK10))*(1000/74.2),0))","v":13.263166901980918},0.16949152542372881,{"$f":"IF(BM10>1.95,((BM10/0.998)-1)*(1000/95.4), IF(BM10<0.046,(1-(0.998/BM10))*(1000/95.4),0))","v":0},0.35087719298245612,{"$f":"IF(BO10>0.392,((BO10/0.312)-1)*(1000/25.6), IF(BO10<0.232,(1-(0.312/BO10))*(1000/25.6),0))","v":0},0.96610169491525422,{"$f":"IF(BQ10>2.426,((BQ10/1.733)-1)*(1000/40), IF(BQ10<1.04,(1-(1.733/BQ10))*(1000/40),0))","v":-19.845175438596495},0.33898305084745761,{"$f":"IF(BS10>0.723,((BS10/0.522)-1)*(1000/38.5), IF(BS10<0.321,(1-(0.522/BS10))*(1000/38.5),0))","v":0},{"$f":"(B10+D10-F10-H10+J10-L10-N10+P10)/8","v":13.402339829056643},{"$f":"(X10+AD10-B10-R10-T10-V10-Z10-AB10)/8","v":1.0665950097890289},{"$f":"(R10+AJ10-D10-AF10-AH10-AL10-AN10-AP10)/8","v":8.8753645435990975},{"$f":"(F10+T10+AF10+AR10+AT10-AV10+AX10+AZ10)/8","v":13.909632615162394},{"$f":"(H10-AR10+V10+AH10+BB10+BD10+BF10+BH10)/8","v":-11.38112164857837},{"$f":"(L10+Z10+AL10+AV10-BD10+BJ10-BP10+BR10)/8","v":-13.141095075187536},{"$f":"(BN10-J10-X10-AJ10-AT10-BB10-BJ10-BL10)/8","v":-15.820275899177631},{"$f":"(N10+AB10+AN10-AX10-BF10+BP10+BL10+BT10)/8","v":-2.1637712496526964},{"$f":"(AP10-P10-AD10-AZ10-BH10-BR10-BN10-BT10)/8","v":5.2523318749890686},{"$f":"ABS(BU10)+ABS(BV10)+ABS(BW10)+ABS(BX10)+ABS(BY10)+ABS(BZ10)+ABS(CA10)+ABS(CB10)+ABS(CC10)","v":85.012527745192472}]
[9.5501730103806235,0,1.5505617977528088,0,0.13405797101449277,0,7.6086956521739135E-2,-19.562211981566819,17.25,12.825056523221784,0.21739130434782608,-37.938271604938279,7.6086956521739135E-2,-19.85569985569985,3.7808219178082192,0,6.1591695501730106,0,1.2802768166089966,0,0.72664359861591699,0,1.8062499999999999,10.493886518870779,2.0761245674740487,-22.129583333333326,0.72664359861591699,0,0.39589041095890409,0,0.20786516853932585,0,0.11797752808988764,0,11.125,20.384646697436725,0.33707865168539325,-28.975535168195726,0.11797752808988764,0,0.41011235955056174,0,1.7619047619047619,10.225697815917654,2.3125,0,1.6216216216216217,-18.579214195183773,1.7619047619047619,0,0.50684931506849318,0,1.3125,0,0.35,0,1,0,0.28767123287671237,-22.248356969906606,3.75,0,1.3125,0,0.21917808219178081,0,0.35,0,0.82191780821917804,-27.712083333333336,0.28767123287671231,-21.157699443413733,11.272654995678343,4.0779337315255129,6.1700227332040569,3.6006140013876786,-6.5045333459238854,-16.916835954373056,-5.4629487174411615,-5.1266749123891984,8.8897674683317085,68.021985860254603]
[11.651785714285714,24.519036632122067,1.6312499999999999,0,0.13793103448275862,0,6.8965517241379309E-2,-25.745967741935484,26.1,27.28572033141554,0.24521072796934865,-26.630979938271611,8.0459770114942528E-2,-16.031746031746032,3.4342105263157894,0,7.1428571428571432,14.567273817885507,1.607142857142857,0,0.80357142857142849,0,2.2400000000000002,16.813530083688836,2.8571428571428568,0,0.93749999999999989,0,0.29473684210526319,-24.507389162561566,0.22499999999999998,0,0.11249999999999999,0,16,35.649647104503408,0.4,-17.201834862385322,0.13125000000000001,0,0.47499999999999998,11.779998375172635,2,16.486073606243149,3.6,19.266265668763484,1.7777777777777777,-13.607414448669207,1.7142857142857142,0,0.47368421052631576,0,1.8,0,0.28125,0,0.8571428571428571,0,0.23684210526315788,-32.219531880548843,6.4,14.151120076227857,2.1,14.600179694519319,0.13157894736842105,0,0.328125,0,0.84210526315789469,-26.448437500000011,0.27631578947368424,-23.094619666048235,15.026681334436343,-5.8475211911100384,6.9548446762001994,6.1699692154594796,-9.3064466535909354,-8.7171933341372867,-15.970807869889807,-3.0657732504093684,14.756247073041411,85.81548459827485]
[10.353356890459365,13.711657215075441,1.723529411764706,0,0.15017064846416381,0,4.778156996587031E-2,-55.037442396313367,12.739130434782609,0,0.22866894197952217,-33.022848719366131,7.1672354948805458E-2,-24.189514189514192,4.725806451612903,0,6.0070671378091873,0,1.5547703180212016,0,0.49469964664310961,-34.224419179436467,1.2304347826086954,0,2.3674911660777389,-13.252611940298497,0.74204946996466437,0,0.45645161290322572,0,0.25882352941176473,0,8.2352941176470601E-2,-30.698611733094488,7.3913043478260869,0,0.39411764705882352,-18.143228810078057,0.12352941176470589,0,0.36470588235294121,0,3.1428571428571428,46.535877399805514,1.9130434782608696,0,1.5227272727272727,-22.25526360592475,2.0952380952380953,15.64552300012811,0.70967741935483875,0,0.60869565217391308,0,0.20895522388059704,-20.517857142857142,0.66666666666666674,-22.491349480968857,0.22580645161290325,-34.97751643030093,2.9130434782608696,0,0.91304347826086951,0,0.37096774193548387,0,0.31343283582089554,0,1.0806451612903225,0,0.33870967741935482,0,15.74518281503364,4.2206717380824408,6.1052300678965681,10.554583000732297,-30.560384220347096,-8.2695119916012878,0,-2.1679609635841803,4.3721895537876163,81.995714351065132]
[8.615384615384615,0,1.5999999999999999,0,0.18214285714285716,0,6.0714285714285721E-2,-34.724857685009482,3.5897435897435899,-24.867127496159753,0.22500000000000001,-34.567901234567891,7.4999999999999997E-2,-20.875420875420875,5.0909090909090908,0,5.3846153846153841,0,1.5692307692307692,0,0.52307692307692311,-30.490535314471806,0.41666666666666669,0,1.9384615384615385,-27.25198412698413,0.64615384615384619,-17.026810724289714,0.59090909090909094,0,0.29142857142857143,11.012018054271579,9.7142857142857156E-2,-21.252074497510598,2.2435897435897436,0,0.36,-24.209989806320088,0.12,0,0.31428571428571428,0,3,42.779651925610217,0.65384615384615385,0,1.2352941176470589,-36.281006699257652,2.4285714285714284,24.026839369677109,0.92727272727272725,0,0.21794871794871795,-54.28724216959511,0.26984126984126983,0,0.80952380952380953,0,0.30909090909090914,-19.028628400512744,0.80769230769230771,-46.579041873159525,0.26923076923076922,0,1.4181818181818182,0,0.33333333333333331,0,1.1454545454545455,0,0.38181818181818183,0,8.1626315373548124,9.3461662707182072,4.3062557811948885,14.262439506102069,-25.320373749088745,-21.111240467536163,15.7166764423643,-7.7411338711734619,2.378578550064093,108.34549617559674]
[9.6678966789667893,0,1.6903225806451614,0,0.17557251908396945,0,7.2519083969465645E-2,-22.508488964346359,9.7037037037037042,0,0.22137404580152673,-36.1451681566624,7.2519083969465645E-2,-23.317384370015954,7.4857142857142867,13.202704348128036,5.7195571955719551,0,1.6974169741697416,10.969689468240849,0.70110701107011064,0,1.0037037037037038,0,2.140221402214022,-19.969396551724138,0.70110701107011064,0,0.77428571428571424,0,0.29677419354838708,11.859883509133846,0.12258064516129032,0,5.7407407407407405,0,0.37419354838709679,-21.551724137931036,0.12258064516129032,0,0.22580645161290322,0,2.4210526315789473,27.557053951239805,1.7037037037037037,0,1.2608695652173914,-34.773829815130462,2.4210526315789473,23.837787120739915,1.3142857142857145,17.635105457842446,0.70370370370370372,0,0.32758620689655171,0,1,0,0.54285714285714282,0,2.1481481481481484,0,0.70370370370370372,0,0.77142857142857146,0,0.32758620689655171,0,1.6571428571428573,0,0.54285714285714282,0,11.896718229894095,1.1249633854354111,1.2114800785996487,15.829168665290915,-6.2581928644482705,-14.055014832681003,0,-5.8943964363444836,-3.85472622574631,60.12466071844014]
[10.833333333333334,17.706706796689733,1.625,0,0.22672064777327935,23.653832242059032,0.10526315789473684,0,24.700000000000003,24.998157695091109,0.36842105263157893,0,0.11740890688259108,0,2.6847826086956528,-22.854197317411042,6.6666666666666661,0,2.4561403508771931,32.677022203831292,1.1403508771929824,0,2.2800000000000002,17.396321421078394,3.9912280701754383,16.631520370207653,1.2719298245614035,16.840494602663693,0.24782608695652178,-33.808659579984429,0.36842105263157898,23.223742645536575,0.17105263157894737,0,15.2,33.144621396677081,0.59868421052631582,0,0.19078947368421054,0,0.60526315789473684,22.362755536171651,2.1538461538461542,20.531239501530401,5.6000000000000005,37.632581844896464,1.6249999999999998,-18.461538461538478,1.931034482758621,11.516795724488219,0.60869565217391319,0,2.6,16.921077151369449,0.2857142857142857,0,0.89655172413793105,0,0.28260869565217395,-23.080648165393924,9.1,26.484246030332184,2.9,25.296282034826508,0.10869565217391304,0,0.31868131868131866,0,0.98913043478260865,-18.801098901098907,0.31521739130434784,-17.038961038961038,-0.47539563346115399,-12.5335102665373,-1.5552345981288931,20.962094077985057,-3.3363513144443595,0.73164112973780648,-22.734160946783899,1.697627484255118,17.243290067377625,81.269305518711221]
[9.8850574712643677,0,1.6645161290322581,0,0.17829457364341086,0,8.5271317829457363E-2,0,23.454545454545453,22.963118206932354,0.25968992248062017,-21.704440759167124,8.1395348837209308E-2,-15.266955266955256,3.7941176470588238,0,5.9386973180076632,0,1.7624521072796935,12.830366649491692,0.84291187739463602,0,2.372727272727273,18.747337703208743,2.5670498084291187,0,0.80459770114942519,0,0.38382352941176479,0,0.29677419354838708,11.859883509133846,0.14193548387096774,0,14.090909090909092,29.671744847190581,0.43225806451612903,0,0.13548387096774195,0,0.43870967741935485,0,2.0909090909090908,18.87639890800379,4.1818181818181817,24.60919401091126,1.4565217391304348,-24.995176210203734,2.1904761904761907,18.040184819999261,0.67647058823529427,0,2,10.019210196358115,0.32835820895522388,0,1.0476190476190477,0,0.3235294117647059,-17.098833370019811,6.0909090909090908,12.739247071380895,1.9090909090909092,12.047700726946012,0.16176470588235295,0,0.31343283582089554,0,0.98529411764705888,-18.971641791044775,0.30882352941176472,-17.929499072356212,7.4918142791318418,0.73962138171463132,2.2264826672570921,13.901400513467948,-3.244502760208186,-6.6165014611293422,-16.349694095365994,-4.8986173040455903,6.7499967791776001,62.218631241498223]
[9.7628458498023729,0,1.2474747474747476,-13.289955658376698,0.21052631578947367,18.595000559000898,6.8825910931174086E-2,-25.879981024667938,30.875000000000004,35.087942894593532,0.2995951417004048,0,8.9068825910931168E-2,0,2.8720930232558146,-19.633801909384758,7.8260869565217392,21.159152939218224,2.0553359683794468,21.20987309539392,0.67193675889328064,-16.070018318746182,3.1625000000000001,30.254155302235585,2.924901185770751,0,0.86956521739130432,0,0.29418604651162794,-24.599388617379613,0.26262626262626265,0,8.585858585858587E-2,-28.165222201733354,24.75,63.048365783853853,0.37373737373737376,-21.634019340441355,0.1111111111111111,-15.072992700729928,0.43434343434343431,0,3.0588235294117645,44.326333003220029,6.5,45.897424124156288,1.4230769230769231,-26.476210050354542,2.3636363636363638,22.394115401583154,0.60465116279069775,0,2.125,11.457099145318807,0.22972972972972974,-15.432773109243696,0.77272727272727271,-14.654996946875638,0.19767441860465118,-43.401224896738356,9.25,27.169419694449086,2.75,23.290762846018911,9.3023255813953487E-2,0,0.29729729729729731,0,0.86046511627906974,-25.350675675675681,0.2558139534883721,-27.027154663518296,1.1811457240623895,-2.5805301288762492,20.296213578044178,22.362369529213606,-22.059181294488297,-3.8573390328473489,-29.525646223828257,-3.3185628716171038,17.50153072033709,122.68251910331452]
[8.1428571428571406,0,1.4615384615384615,0,0.12280701754385967,0,0.12280701754385967,0,13.411764705882351,0,0.324561403508772,0,8.3333333333333343E-2,-13.737373737373726,4.5599999999999996,0,5.5714285714285712,0,1,0,1,0,1.6470588235294119,0,2.6428571428571423,0,0.67857142857142849,-14.206103494029199,0.56000000000000005,0,0.17948717948717949,0,0.17948717948717949,0,9.1764705882352935,14.283251361278854,0.47435897435897434,0,0.12179487179487179,0,0.32051282051282048,0,1,0,1.6470588235294119,0,2.6428571428571423,0,1.4736842105263159,0,0.56000000000000005,0,1.6470588235294119,0,0.3783783783783784,0,1.4736842105263159,11.754772271982256,0.56000000000000005,0,4.3529411764705879,0,1.1176470588235294,0,0.34,0,0.25675675675675674,0,1.48,0,0.38,0,1.7171717171717158,1.7757629367536498,1.7854064201598567,0,1.469346533997782,0,-1.7854064201598567,-4.9622811879231472,0,13.495375216166007]
[10.434782608695651,14.389398355087868,1.5894039735099337,0,8.7499999999999994E-2,-34.23180592991914,6.25E-2,-32.58064516129032,21.818181818181817,20.289343696942751,0.33750000000000002,0,6.6666666666666666E-2,-29.797979797979803,4,0,6.5652173913043477,0,0.91304347826086951,-16.509129967776587,0.65217391304347816,-17.605536332179938,2.0909090909090908,14.641307826145921,3.5217391304347827,0,0.69565217391304346,0,0.38333333333333336,0,0.13907284768211919,-20.995975855130798,9.9337748344370855E-2,-20.089864158829684,13.727272727272727,28.533096798178612,0.53642384105960261,0,0.10596026490066225,-17.579835766423361,0.39735099337748347,0,1.4,0,1.9090909090909092,0,3.8571428571428572,22.73088317424115,1.3125,0,0.35000000000000003,-25.753604193971164,1.3636363636363635,0,0.18518518518518517,-27.735714285714295,0.9375,0,0.25,-29.24939467312349,7.3636363636363633,18.552841797221319,1.4545454545454546,0,0.18333333333333332,0,0.19753086419753085,-22.636718750000004,1.35,0,0.26666666666666666,-24.870129870129869,16.411146617652484,4.2958219713768226,10.899846572320307,-15.027674890129855,-15.907644326392216,11.457019750897096,-10.252073764811076,-11.86058302306663,9.9841410921530649,106.09595200879956]
[7.36,-13.252205419029602,1.3333333333333335,0,0.14130434782608695,0,0.14130434782608695,10.100038476337046,14.153846153846153,0,0.40217391304347827,0,7.0652173913043473E-2,-25.268065268065271,2.628571428571429,-23.910160304463144,5.52,0,1.04,0,1.04,0,1.9230769230769231,12.196029487448467,2.96,0,0.52,-31.351001939237236,0.35714285714285715,0,0.18840579710144931,0,0.18840579710144931,0,10.615384615384615,18.788897147980055,0.53623188405797106,0,9.420289855072464E-2,-24.329028635597979,0.50724637681159424,14.399738143764255,1,0,2,0,2.8461538461538463,0,2,13.250861180256967,0.37142857142857144,-22.94460127028934,2,10.019210196358115,0.35135135135135137,0,2,28.310789556464297,0.37142857142857144,0,5.6923076923076925,10.918505866035268,1,0,0.18571428571428572,0,0.17567567567567569,-30.312499999999993,1.0571428571428572,0,0.18571428571428572,-47.032967032967036,-2.7492923664705651,7.0999046057144133,3.5897734549767222,-1.2117175112540466,6.0537547786449322,5.1538757332544076,-6.4903303372277383,-24.981901701573598,13.535933343935472,70.866483833051902]
[8.1538461538461533,0,1.5703703703703704,0,0.12264150943396226,0,0.14150943396226415,10.173220797268108,12.470588235294118,0,0.34905660377358488,0,7.5471698113207544E-2,-20.429292929292934,7.0666666666666673,10.978750474548796,5.1923076923076925,0,1,0,1.1538461538461537,0,1.5294117647058822,0,2.8461538461538463,0,0.61538461538461542,-19.978991596638657,0.8666666666666667,11.672977893949044,0.19259259259259259,0,0.22222222222222221,11.389545978079932,7.9411764705882355,10.415196959488208,0.54814814814814816,0,0.11851851851851852,0,0.22222222222222221,0,0.8666666666666667,-21.09136351013607,1.5294117647058822,0,2.8461538461538463,0,1.625,0,0.8666666666666667,0,1.7647058823529411,0,0.40540540540540543,0,1.875,24.378735451399805,1,19.651191353475802,4.3529411764705879,0,0.94117647058823528,0,0.56666666666666665,0,0.21621621621621623,-17.304687499999993,2.4666666666666668,10.583766108867088,0.53333333333333333,0,2.6543528258217028,3.9564961863234629,-0.12179362732396548,-2.6364204387670087,10.835507136294964,3.4860567011083852,-1.301899619936026,-10.261463434666425,-6.6108357288550916,41.864825699097032]
[8.32,0,1.2606060606060607,-12.531478937728936,0.12980769230769232,0,0.1394230769230769,0,4.7272727272727275,0,0.33653846153846156,0,7.6923076923076927E-2,-19.090909090909086,2.9714285714285715,-18.090695776372169,6.6,0,1.08,0,1.1599999999999999,0,0.56818181818181823,0,2.8,0,0.64,-17.594537815126049,0.35714285714285715,0,0.16363636363636366,0,0.17575757575757575,0,3.75,0,0.42424242424242425,-13.597640891218875,9.696969696969697E-2,-22.593521897810223,0.42424242424242425,0,0.93103448275862077,-17.137317823238398,0.61363636363636365,0,2.5925925925925926,0,1.6875,0,0.38571428571428573,-21.24532789670404,0.65909090909090906,0,0.41428571428571426,0,1.8124999999999998,22.412708398867561,0.41428571428571426,0,1.5909090909090908,0,0.36363636363636365,0,0.62857142857142856,0,0.22857142857142856,-14.2578125,1,-18.325000000000003,0.22857142857142856,-33.344155844155843,-1.4414082028990023,2.1993172268907561,6.0903302158447543,-4.7978307149928048,4.9437532777632445,-2.2081035489023595,0,-16.161705693358595,11.375647439654006,49.21809632030552]
[6.129032258064516,-30.467581998474451,1.165644171779141,-18.401629072681715,0.11578947368421053,-14.343910806174952,9.4736842105263161E-2,0,7.916666666666667,0,0.36842105263157893,0,9.4736842105263161E-2,0,3.1666666666666665,0,5.258064516129032,0,0.70967741935483875,-32.012987012987011,0.58064516129032251,-24.036908881199544,1.2916666666666667,0,2.2580645161290325,-16.31785714285714,0.58064516129032262,-23.688141923436039,0.51666666666666672,0,0.13496932515337423,-22.704865556978241,0.11042944785276074,-14.923371647509583,6.791666666666667,0,0.42944785276073622,-12.876802096985582,0.11042944785276074,-15.391321978913217,0.36809815950920249,0,1.2222222222222223,0,0.91666666666666663,0,3.1818181818181817,12.093872275764335,1.2222222222222223,0,0.3666666666666667,-23.540450375312762,0.75,0,0.25714285714285712,0,1,0,0.3,-20.338983050847464,2.9166666666666665,0,0.75,0,0.4,0,0.25714285714285712,0,1.1666666666666667,0,0.3,-19.220779220779225,-4.3156625331226515,15.815434619869272,10.537248794133541,-13.087010753402163,-7.4124079474445743,-2.1375983705097985,0,-7.2875303903910602,7.8875265808674317,68.480419989740497]
[8.6363636363636367,0,1.5833333333333333,0,0.12631578947368421,0,0.14736842105263159,12.263924155235367,4.1304347826086953,0,0.35263157894736841,0,8.9473684210526316E-2,0,2.7142857142857144,-22.317464749406671,5.4545454545454541,0,1.0909090909090908,0,1.2727272727272729,10.153011250150259,0.47826086956521741,0,3.0454545454545454,0,0.77272727272727271,0,0.31428571428571433,-21.450962830273163,0.2,0,0.23333333333333336,13.526421396106194,2.6086956521739131,0,0.55833333333333335,0,0.14166666666666666,0,0.58333333333333337,20.58114658650852,0.85714285714285698,-21.726835138387496,0.52173913043478259,0,2.7916666666666665,0,1.411764705882353,0,0.34285714285714286,-26.767966360856267,0.60869565217391308,0,0.41791044776119407,0,1.6470588235294119,17.208519142164572,0.4,0,1.4565217391304348,0,0.36956521739130432,0,0.65714285714285714,0,0.2537313432835821,0,0.95714285714285718,-20.264925373134329,0.24285714285714285,-29.854851031321619,-4.322673613080255,-3.9504967600529275,-4.2634459978268389,-6.0618501874054704,9.3598388852554866,-2.5331156716417911,0,-5.8829212716857739,17.654664616437572,54.029007003386113]
[6.0666666666666673,-31.525720656155421,1.5294117647058825,0,0.10989010989010989,-17.646226415094333,0.14285714285714285,10.654133191957905,7.28,0,0.37912087912087911,0,7.6923076923076927E-2,-19.090909090909086,3.0333333333333332,-17.180167312793309,3.9666666666666668,-22.830654000730721,0.66666666666666674,-36.503759398496236,0.8666666666666667,0,1.2,0,2.2999999999999998,-15.108695652173921,0.46666666666666667,-39.735894357743099,0.5,0,0.16806722689075632,0,0.21848739495798322,10.671268526642539,4.76,0,0.57983193277310929,0,0.11764705882352941,0,0.504201680672269,14.152382863942561,0.76923076923076927,-28.335740072202164,0.8,0,3.45,16.317992949871002,1.4285714285714286,0,0.33333333333333331,-28.188073394495415,1.04,0,0.37681159420289856,0,1.8571428571428572,23.817013436390596,0.43333333333333335,0,2.76,0,0.56000000000000005,0,0.41666666666666669,0,0.20289855072463769,-21.004464285714281,1.1499999999999999,0,0.23333333333333334,-32.133580705009273,-2.8278607068629018,18.213090508162427,-5.9567881739144779,-15.873974028769894,9.1847694033991498,2.7767201979264202,0,-16.972732734470792,11.45677553453007,83.26271128803613]

{"sheet":"DRISIndices","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,4,7,4],[6,3,7,3],[1,0,1,10],[6,2,7,2],[6,1,7,1],[6,0,7,0],[0,0,0,10],[6,10,7,10],[6,9,7,9],[6,8,7,8],[6,7,7,7],[6,6,7,6],[6,5,7,5]]}
["DRIS Indices"]
["SUGARCANE LEAF DRIS INDICES"]
[" A DRIS index value of zero or near zero indicates the nutrient is in optimum balance with other nutrients. "]
["A negative DRIS index value indicates the nutrient is insufficient relative to other nutrient levels. "]
["A positive DRIS index value indicates the nutrient is excessive relative to other nutrients."]
["DRIS index values less than -10 are colored red and DRIS index values greater than +10 are colored blue. "]
["SampleID","N","P","K","Ca","Mg","Fe","Mn","Zn","Cu","NBI"]
[]
[{"$f":"LeafConcentrationsEntry!A9","v":"Fielda"},{"$f":"DRISN","v":31.659481901228723},{"$f":"DRISP","v":7.0576331451132877},{"$f":"DRISK","v":11.266839352208876},{"$f":"DRISCA","v":8.3966834689570238},{"$f":"DRISMG","v":-18.385834881413132},{"$f":"DRISFE","v":-19.769491785024641},{"$f":"DRISMN","v":-29.479644375319634},{"$f":"DRISZN","v":3.8324623808479816},{"$f":"DRISCU","v":5.4218707934015136},{"$f":"DRISNBI","v":135.26994208351482}]
[{"$f":"LeafConcentrationsEntry!A10","v":"Fieldb"},13.402339829056643,1.0665950097890289,8.8753645435990975,13.909632615162394,-11.38112164857837,-13.141095075187536,-15.820275899177631,-2.1637712496526964,5.2523318749890686,85.012527745192472]
[{"$f":"LeafConcentrationsEntry!A11","v":"Fieldc"},11.272654995678343,4.0779337315255129,6.1700227332040569,3.6006140013876786,-6.5045333459238854,-16.916835954373056,-5.4629487174411615,-5.1266749123891984,8.8897674683317085,68.021985860254603]
[{"$f":"LeafConcentrationsEntry!A12","v":"Fieldd"},15.026681334436343,-5.8475211911100384,6.9548446762001994,6.1699692154594796,-9.3064466535909354,-8.7171933341372867,-15.970807869889807,-3.0657732504093684,14.756247073041411,85.81548459827485]
[{"$f":"LeafConcentrationsEntry!A13","v":"Fielde"},15.74518281503364,4.2206717380824408,6.1052300678965681,10.554583000732297,-30.560384220347096,-8.2695119916012878,0,-2.1679609635841803,4.3721895537876163,81.995714351065132]
[{"$f":"LeafConcentrationsEntry!A14","v":"Fieldf"},8.1626315373548124,9.3461662707182072,4.3062557811948885,14.262439506102069,-25.320373749088745,-21.111240467536163,15.7166764423643,-7.7411338711734619,2.378578550064093,108.34549617559674]
[{"$f":"LeafConcentrationsEntry!A15","v":"Fieldg"},11.896718229894095,1.1249633854354111,1.2114800785996487,15.829168665290915,-6.2581928644482705,-14.055014832681003,0,-5.8943964363444836,-3.85472622574631,60.12466071844014]
[{"$f":"LeafConcentrationsEntry!A16","v":"Fieldh"},-0.47539563346115399,-12.5335102665373,-1.5552345981288931,20.962094077985057,-3.3363513144443595,0.73164112973780648,-22.734160946783899,1.697627484255118,17.243290067377625,81.269305518711221]
[{"$f":"LeafConcentrationsEntry!A17","v":"Fieldi"},7.4918142791318418,0.73962138171463132,2.2264826672570921,13.901400513467948,-3.244502760208186,-6.6165014611293422,-16.349694095365994,-4.8986173040455903,6.7499967791776001,62.218631241498223]
[{"$f":"LeafConcentrationsEntry!A18","v":"Fieldj"},1.1811457240623895,-2.5805301288762492,20.296213578044178,22.362369529213606,-22.059181294488297,-3.8573390328473489,-29.525646223828257,-3.3185628716171038,17.50153072033709,122.68251910331452]
[{"$f":"LeafConcentrationsEntry!A19","v":"Field1"},1.7171717171717158,1.7757629367536498,1.7854064201598567,0,1.469346533997782,0,-1.7854064201598567,-4.9622811879231472,0,13.495375216166007]
[{"$f":"LeafConcentrationsEntry!A20","v":"Field2"},16.411146617652484,4.2958219713768226,10.899846572320307,-15.027674890129855,-15.907644326392216,11.457019750897096,-10.252073764811076,-11.86058302306663,9.9841410921530649,106.09595200879956]
[{"$f":"LeafConcentrationsEntry!A21","v":"Field3"},-2.7492923664705651,7.0999046057144133,3.5897734549767222,-1.2117175112540466,6.0537547786449322,5.1538757332544076,-6.4903303372277383,-24.981901701573598,13.535933343935472,70.866483833051902]
[{"$f":"LeafConcentrationsEntry!A22","v":"Field4"},2.6543528258217028,3.9564961863234629,-0.12179362732396548,-2.6364204387670087,10.835507136294964,3.4860567011083852,-1.301899619936026,-10.261463434666425,-6.6108357288550916,41.864825699097032]
[{"$f":"LeafConcentrationsEntry!A23","v":"Field5"},-1.4414082028990023,2.1993172268907561,6.0903302158447543,-4.7978307149928048,4.9437532777632445,-2.2081035489023595,0,-16.161705693358595,11.375647439654006,49.21809632030552]
[{"$f":"LeafConcentrationsEntry!A24","v":"Field6"},-4.3156625331226515,15.815434619869272,10.537248794133541,-13.087010753402163,-7.4124079474445743,-2.1375983705097985,0,-7.2875303903910602,7.8875265808674317,68.480419989740497]
[{"$f":"LeafConcentrationsEntry!A25","v":"Field7"},-4.322673613080255,-3.9504967600529275,-4.2634459978268389,-6.0618501874054704,9.3598388852554866,-2.5331156716417911,0,-5.8829212716857739,17.654664616437572,54.029007003386113]
[{"$f":"LeafConcentrationsEntry!A26","v":"Field8"},-2.8278607068629018,18.213090508162427,-5.9567881739144779,-15.873974028769894,9.1847694033991498,2.7767201979264202,0,-16.972732734470792,11.45677553453007,83.26271128803613]

{"sheet":"ConcentrationsPlusDRIS","index":4,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,19],[6,9,6,10],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,11,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18]]}
[]
["SUGARCANE LEAF DRIS INDICES AND NUTRIENT CONCENTRATIONS"]
[" A DRIS index value of zero or near zero indicates the nutrient is in optimum balance with other nutrients. "]
["A negative DRIS index value indicates the nutrient is insufficient relative to other nutrient levels. A positive DRIS index value indicates the nutrient is excessive relative to other nutrients."]
["DRIS index values less than -10 are colored red and DRIS index values greater than +10 are colored blue. "]
["Nutrient concentrations below the critical value are colored red and concentrations above the optimum range are colored blue. "]
["SampleID","Leaf N",null,"Leaf P",null,"Leaf K",null,"Leaf Ca",null,"Leaf Mg",null,"Leaf Fe",null,"Leaf Mn",null,"Leaf Zn",null,"Leaf Cu",null,"NBI"]
[null,"%","DRIS","%","DRIS","%","DRIS","%","DRIS","%","DRIS","mg/kg","DRIS","mg/kg","DRIS","mg/kg","DRIS","mg/kg","DRIS"]
[{"$f":"LeafConcentrationsEntry!A9","v":"Fielda"},{"$f":"LN","v":2.58},{"$f":"DRISN","v":31.659481901228723},{"$f":"LP","v":0.217},{"$f":"DRISP","v":7.0576331451132877},{"$f":"LK","v":1.33},{"$f":"DRISK","v":11.266839352208876},{"$f":"LCA","v":0.3},{"$f":"DRISCA","v":8.3966834689570238},{"$f":"LMG","v":0.13},{"$f":"DRISMG","v":-18.385834881413132},{"$f":"LFE","v":44},{"$f":"DRISFE","v":-19.769491785024641},{"$f":"LMN","v":6},{"$f":"DRISMN","v":-29.479644375319634},{"$f":"LZN","v":18},{"$f":"DRISZN","v":3.8324623808479816},{"$f":"LCU","v":4.5999999999999996},{"$f":"DRISCU","v":5.4218707934015136},{"$f":"DRISNBI","v":135.26994208351482}]
[{"$f":"LeafConcentrationsEntry!A10","v":"Fieldb"},2.44,13.402339829056643,0.24099999999999999,1.0665950097890289,1.54,8.8753645435990975,0.42,13.909632615162394,0.17,-11.38112164857837,57,-13.141095075187536,10,-15.820275899177631,20,-2.1637712496526964,5.9,5.2523318749890686,85.012527745192472]
[{"$f":"LeafConcentrationsEntry!A11","v":"Fieldc"},2.76,11.272654995678343,0.28899999999999998,4.0779337315255129,1.78,6.1700227332040569,0.37,3.6006140013876786,0.21,-6.5045333459238854,60,-16.916835954373056,16,-5.4629487174411615,21,-5.1266749123891984,7.3,8.8897674683317085,68.021985860254603]
[{"$f":"LeafConcentrationsEntry!A12","v":"Fieldd"},2.61,15.026681334436343,0.224,-5.8475211911100384,1.6,6.9548446762001994,0.36,6.1699692154594796,0.18,-9.3064466535909354,64,-8.7171933341372867,10,-15.970807869889807,21,-3.0657732504093684,7.6,14.756247073041411,85.81548459827485]
[{"$f":"LeafConcentrationsEntry!A13","v":"Fielde"},2.93,15.74518281503364,0.28299999999999997,4.2206717380824408,1.7,6.1052300678965681,0.44,10.554583000732297,0.14000000000000001,-30.560384220347096,67,-8.2695119916012878,23,0,21,-2.1679609635841803,6.2,4.3721895537876163,81.995714351065132]
[{"$f":"LeafConcentrationsEntry!A14","v":"Fieldf"},2.8,8.1626315373548124,0.32500000000000001,9.3461662707182072,1.75,4.3062557811948885,0.51,14.262439506102069,0.17,-25.320373749088745,63,-21.111240467536163,78,15.7166764423643,21,-7.7411338711734619,5.5,2.378578550064093,108.34549617559674]
[{"$f":"LeafConcentrationsEntry!A15","v":"Fieldg"},2.62,11.896718229894095,0.27100000000000002,1.1249633854354111,1.55,1.2114800785996487,0.46,15.829168665290915,0.19,-6.2581928644482705,58,-14.055014832681003,27,0,19,-5.8943964363444836,3.5,-3.85472622574631,60.12466071844014]
[{"$f":"LeafConcentrationsEntry!A16","v":"Fieldh"},2.4700000000000002,-0.47539563346115399,0.22800000000000001,-12.5335102665373,1.52,-1.5552345981288931,0.56000000000000005,20.962094077985057,0.26,-3.3363513144443595,91,0.73164112973780648,10,-22.734160946783899,29,1.697627484255118,9.1999999999999993,17.243290067377625,81.269305518711221]
[{"$f":"LeafConcentrationsEntry!A17","v":"Fieldi"},2.58,7.4918142791318418,0.26100000000000001,0.73962138171463132,1.55,2.2264826672570921,0.46,13.901400513467948,0.22,-3.244502760208186,67,-6.6165014611293422,11,-16.349694095365994,21,-4.8986173040455903,6.8,6.7499967791776001,62.218631241498223]
[{"$f":"LeafConcentrationsEntry!A18","v":"Fieldj"},2.4700000000000002,1.1811457240623895,0.253,-2.5805301288762492,1.98,20.296213578044178,0.52,22.362369529213606,0.17,-22.059181294488297,74,-3.8573390328473489,8,-29.525646223828257,22,-3.3185628716171038,8.6,17.50153072033709,122.68251910331452]
[{"$f":"LeafConcentrationsEntry!A19","v":"Field1"},2.2799999999999998,1.7171717171717158,0.28000000000000003,1.7757629367536498,1.56,1.7854064201598567,0.28000000000000003,0,0.28000000000000003,1.469346533997782,74,0,17,-1.7854064201598567,19,-4.9622811879231472,5,0,13.495375216166007]
[{"$f":"LeafConcentrationsEntry!A20","v":"Field2"},2.4,16.411146617652484,0.23,4.2958219713768226,1.51,10.899846572320307,0.21,-15.027674890129855,0.15,-15.907644326392216,81,11.457019750897096,11,-10.252073764811076,16,-11.86058302306663,6,9.9841410921530649,106.09595200879956]
[{"$f":"LeafConcentrationsEntry!A21","v":"Field3"},1.84,-2.7492923664705651,0.25,7.0999046057144133,1.38,3.5897734549767222,0.26,-1.2117175112540466,0.26,6.0537547786449322,74,5.1538757332544076,13,-6.4903303372277383,13,-24.981901701573598,7,13.535933343935472,70.866483833051902]
[{"$f":"LeafConcentrationsEntry!A22","v":"Field4"},2.12,2.6543528258217028,0.26,3.9564961863234629,1.35,-0.12179362732396548,0.26,-2.6364204387670087,0.3,10.835507136294964,74,3.4860567011083852,17,-1.301899619936026,16,-10.261463434666425,3,-6.6108357288550916,41.864825699097032]
[{"$f":"LeafConcentrationsEntry!A23","v":"Field5"},2.08,-1.4414082028990023,0.25,2.1993172268907561,1.65,6.0903302158447543,0.27,-4.7978307149928048,0.28999999999999998,4.9437532777632445,70,-2.2081035489023595,44,0,16,-16.161705693358595,7,11.375647439654006,49.21809632030552]
[{"$f":"LeafConcentrationsEntry!A24","v":"Field6"},1.9,-4.3156625331226515,0.31,15.815434619869272,1.63,10.537248794133541,0.22,-13.087010753402163,0.18,-7.4124079474445743,70,-2.1375983705097985,24,0,18,-7.2875303903910602,6,7.8875265808674317,68.480419989740497]
[{"$f":"LeafConcentrationsEntry!A25","v":"Field7"},1.9,-4.322673613080255,0.22,-3.9504967600529275,1.2,-4.2634459978268389,0.24,-6.0618501874054704,0.28000000000000003,9.3598388852554866,67,-2.5331156716417911,46,0,17,-5.8829212716857739,7,17.654664616437572,54.029007003386113]
[{"$f":"LeafConcentrationsEntry!A26","v":"Field8"},1.82,-2.8278607068629018,0.3,18.213090508162427,1.19,-5.9567881739144779,0.2,-15.873974028769894,0.26,9.1847694033991498,69,2.7767201979264202,25,0,14,-16.972732734470792,6,11.45677553453007,83.26271128803613]

{"sheet":"CriticalValues","index":5,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,0,21,5],[22,0,22,5],[0,0,0,6],[3,2,3,4],[12,2,12,4],[20,0,20,5]]}
["Sugarcane leaf nutrient critical values and optimum ranges."]
[]
["Nutrient",null,"Critical Value",null,"Optimum Range"]
[null,null,"-----------------------------%----------------------------"]
["Nitrogen (N)",null,1.8,null,"2.00-2.60"]
["Phosphorus (P)",null,0.19,null,"0.22-0.30"]
["Potassium (K)",null,0.9,null,"1.00-1.60"]
["Calcium (Ca)",null,0.2,null,"0.20-0.45"]
["Magnesium (Mg)",null,0.12,null,"0.15-0.32"]
["Sulfur (S)",null,0.13,null,"0.13-0.18"]
["Silicon (Si)",null,0.5,null,">0.70"]
[]
[null,null,"----------------------------mg/kg-------------------------"]
["Iron (Fe)",null,"-----",null,"50-105"]
["Manganese (Mn)",null,"-----",null,"12-100"]
["Zinc (Zn)",null,15,null,"16-32"]
["Copper (Cu)",null,3,null,"4-8"]
["Boron (B)",null,4,null,"15-20"]
["Molybdenum (Mo)",null,0.05,null,"-----"]
[]
["From Anderson and Bowen (1990), except for Si values (J. M. McCray,"]
["unpublished data). All values are from Florida except S and Mo, which"]
["are from Louisiana."]