{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["T-Chart","User Guide","T-Chart example"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"T-Chart","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,2],[2,3,5,5],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,5],[7,0,7,2],[7,3,7,5],[26,0,27,2],[26,3,27,5]]}
["Conservation Practice Effects\nT-Chart"]
[]
["Name: ",null,null,"Resource Concerns/Benchmark Condition:  "]
["Location: "]
["Date:  "]
["Assisted By:  "]
["Conservation Treatment:  "]
["Positive Effects",null,null,"Negative Effects"]
["Reduced Cost",null,null,"Increased Cost"]
[null,0,{"$f":"IF(A5=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,0,{"$f":"IF(D5=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Increased Revenue",null,null,"Reduced Revenue"]
[null,null,{"$f":"IF(A8=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D8=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A9=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D9=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A10=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D10=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A11=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D11=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Other",null,null,"Other"]
[null,null,{"$f":"IF(A14=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D14=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Total Dollar Benefits",{"$f":"SUM(B10:B25)","v":0},"/ac/yr","Total Dollar Costs",{"$f":"SUM(E10:E25)","v":0},"/ac/yr"]
["Total Benefits - Total Costs = Net Benefits:",null,null,{"$f":"B26-E26","v":0}]

{"sheet":"User Guide","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["User Guide"]
["**Right click to add rows"]
["**Home --> Cells --> Delete to delete rows"]
["**Single click to edit cells"]
["**Double click to enter cursor into cells"]
[]
[]
[]
[]
["TechNote 200-ECN-1"]
["**For additional guidance using T-Charts, open the pdf below."]

{"sheet":"T-Chart example","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,2],[2,3,5,5],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,5],[7,0,7,2],[7,3,7,5],[26,3,27,5],[26,0,27,2]]}
["Conservation Practice Effects\nT-Chart"]
[]
["Name:  John Doe",null,null,"Resource Concerns/Benchmark Condition:  272 acres of cropland in a corn-soybean rotation producing 225 bu./ac. and 65 bu./ac. respectively.  Disk-ripper and mulch finisher for soybeans and mulch finisher for corn  and fall applied NH3. Resource concerns: Ephemeral gullies, water quality-nutrients and sediment, ponding.\n"]
["Location:  Anytown, Iowa"]
["Date:  1/15/2018"]
["Assisted By:  Jeff Matthias"]
["Conservation Treatment:  Residue Management (Strip-till and vertical tillage), Cover Crops\n"]
["Positive Effects",null,null,"Negative Effects"]
["Reduced Cost",null,null,"Increased Cost"]
["Reduced tillage passes",null,{"$f":"IF(A5=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"Strip-till rig",16.5,{"$f":"IF(D5=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["     disk-ripper  $23/2",{"$f":"23/2","v":11.5},{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"Salford machine w/seeder",17,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["     mulch finisher",15,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"Cover Crops (seed & termination)",22,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"Increased Management of Cover Crops",null,{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"     2 hrs. x $20 = $40/272 ac.",{"$f":"2*20/272","v":0.14705882352941177},{"$f":"IF(D7=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Increased Revenue",null,null,"Reduced Revenue"]
["Soybean yield increase by 5%",null,{"$f":"IF(A8=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},"Possible reduced corn yield (no estimate)",null,{"$f":"IF(D8=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["     65 bu/ac x 5% x $9/bu = $29.52/2",{"$f":"65*0.05*9/2","v":14.625},{"$f":"IF(A9=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D9=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A10=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D10=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A11=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D11=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Other",null,null,"Other"]
["Ephemeral gully erosion and sediment delivery reduced by 42 tons/year improving off-site water quality.",null,{"$f":"IF(A14=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D14=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Improved soil helath - SCI increases from 0.38 to 0.60",null,{"$f":"IF(A15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Increased infiltration may decrease ponding affect.",null,{"$f":"IF(A15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D15=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["May be eligible for cost share",null,{"$f":"IF(A16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
[null,null,{"$f":"IF(A16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"},null,null,{"$f":"IF(D16=\"Name\",  \" \", \"/ac./yr\")","v":"/ac./yr"}]
["Total Dollar Benefits",{"$f":"SUM(B10:B25)","v":41.125},"/ac/yr","Total Dollar Costs",{"$f":"SUM(E10:E25)","v":55.647058823529413},"/ac/yr"]
["Total Benefits - Total Costs = Net Benefits:",null,null,{"$f":"B26-E26","v":-14.522058823529413}]