{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Digging Report","Yield Loss Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Digging Report","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["To use, enter number of samples and expected peanut price in the cells below.  For each sample, enter sample name, sample date, field size, potential yield, and days before optimal digging.  Once data has been entered, the remaing columns in a sample row will be calculated.  To clear all existing data and enter new data, click the \"Clear Table\" button located above and to the right side of the table."]
[]
["Number of Samples",5]
["Peanut Price ($/lb)",0.22]
[]
["Sample Name","Sample Date","Field Size\n(ac)","Potential Yield\n(lbs/ac)","Days Before Optimal Digging","Optimal Digging Date","Percent Potential Yield Gain","Potential Yield Gain\n(lbs/ac)","Economic Gain\n($/ac)","Field Economic Gain\n($)"]
["Front 40","2023-09-05",40,4200,5,{"$f":"tblDiggingReport[Sample Date]+tblDiggingReport[Days Before Optimal Digging]","v":"2023-09-10"},{"$f":"(49.5 -VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE))*0.01","v":0.05},{"$f":"(49.5-VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE) )* 0.01 *D7","v":210},{"$f":"tblDiggingReport[Potential Yield Gain\n(lbs/ac)]*PeanutPrice","v":46.2},{"$f":"tblDiggingReport[Field Size\n(ac)]*tblDiggingReport[Economic Gain\n($/ac)]","v":1848}]
["Back 20","2023-09-05",20,4800,10,{"$f":"tblDiggingReport[Sample Date]+tblDiggingReport[Days Before Optimal Digging]","v":"2023-09-15"},{"$f":"(49.5 -VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE))*0.01","v":0.115},{"$f":"(49.5-VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE) )* 0.01 *D8","v":552},{"$f":"tblDiggingReport[Potential Yield Gain\n(lbs/ac)]*PeanutPrice","v":121.44},{"$f":"tblDiggingReport[Field Size\n(ac)]*tblDiggingReport[Economic Gain\n($/ac)]","v":2428.8000000000002}]
["East 30","2023-09-05",30,4500,3,{"$f":"tblDiggingReport[Sample Date]+tblDiggingReport[Days Before Optimal Digging]","v":"2023-09-08"},{"$f":"(49.5 -VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE))*0.01","v":0.03},{"$f":"(49.5-VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE) )* 0.01 *D9","v":135},{"$f":"tblDiggingReport[Potential Yield Gain\n(lbs/ac)]*PeanutPrice","v":29.7},{"$f":"tblDiggingReport[Field Size\n(ac)]*tblDiggingReport[Economic Gain\n($/ac)]","v":891}]
["West 60","2023-09-05",60,4300,10,{"$f":"tblDiggingReport[Sample Date]+tblDiggingReport[Days Before Optimal Digging]","v":"2023-09-15"},{"$f":"(49.5 -VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE))*0.01","v":0.115},{"$f":"(49.5-VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE) )* 0.01 *D10","v":494.5},{"$f":"tblDiggingReport[Potential Yield Gain\n(lbs/ac)]*PeanutPrice","v":108.79},{"$f":"tblDiggingReport[Field Size\n(ac)]*tblDiggingReport[Economic Gain\n($/ac)]","v":6527.4000000000005}]
["South 45","2023-09-05",45,4600,14,{"$f":"tblDiggingReport[Sample Date]+tblDiggingReport[Days Before Optimal Digging]","v":"2023-09-19"},{"$f":"(49.5 -VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE))*0.01","v":0.17500000000000002},{"$f":"(49.5-VLOOKUP(tblDiggingReport[[#This Row],[Days Before Optimal Digging]],tblYieldLoss,3,FALSE) )* 0.01 *D11","v":805.00000000000011},{"$f":"tblDiggingReport[Potential Yield Gain\n(lbs/ac)]*PeanutPrice","v":177.10000000000002},{"$f":"tblDiggingReport[Field Size\n(ac)]*tblDiggingReport[Economic Gain\n($/ac)]","v":7969.5000000000009}]
["Summary",null,{"$f":"SUBTOTAL(109,tblDiggingReport[Field Size\n(ac)])","v":195},{"$f":"SUMPRODUCT(tblDiggingReport[Potential Yield\n(lbs/ac)],tblDiggingReport[Field Size\n(ac)])/SUM(tblDiggingReport[Field Size\n(ac)])","v":4430.7692307692305},{"$f":"SUMPRODUCT(tblDiggingReport[Days Before Optimal Digging],tblDiggingReport[Field Size\n(ac)])/SUM(tblDiggingReport[Field Size\n(ac)])","v":8.8205128205128212},null,null,{"$f":"SUMPRODUCT(tblDiggingReport[Potential Yield Gain\n(lbs/ac)],tblDiggingReport[Field Size\n(ac)])/SUM(tblDiggingReport[Field Size\n(ac)])","v":458.38461538461536},{"$f":"SUMPRODUCT(tblDiggingReport[Economic Gain\n($/ac)],tblDiggingReport[Field Size\n(ac)])/SUM(tblDiggingReport[Field Size\n(ac)])","v":100.84461538461539},{"$f":"SUBTOTAL(109,tblDiggingReport[Field Economic Gain\n($)])","v":19664.7}]

{"sheet":"Yield Loss Data","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Days to Optimal Digging Date","Daily Yield Gain (%/Day)","Yield Gain (%)"]
[30,2,{"$f":"C3-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":0}]
[29,2,{"$f":"C4-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":2}]
[28,2,{"$f":"C5-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":4}]
[27,2,{"$f":"C6-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":6}]
[26,2,{"$f":"C7-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":8}]
[25,2,{"$f":"C8-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":10}]
[24,2,{"$f":"C9-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":12}]
[23,2,{"$f":"C10-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":14}]
[22,2,{"$f":"C11-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":16}]
[21,2,{"$f":"C12-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":18}]
[20,2,{"$f":"C13-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":20}]
[19,2,{"$f":"C14-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":22}]
[18,2,{"$f":"C15-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":24}]
[17,2,{"$f":"C16-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":26}]
[16,2,{"$f":"C17-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":28}]
[15,2,{"$f":"C18-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":30}]
[14,1.5,{"$f":"C19-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":32}]
[13,1.5,{"$f":"C20-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":33.5}]
[12,1.5,{"$f":"C21-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":35}]
[11,1.5,{"$f":"C22-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":36.5}]
[10,1.5,{"$f":"C23-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":38}]
[9,1.5,{"$f":"C24-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":39.5}]
[8,1.5,{"$f":"C25-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":41}]
[7,1,{"$f":"C26-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":42.5}]
[6,1,{"$f":"C27-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":43.5}]
[5,1,{"$f":"C28-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":44.5}]
[4,1,{"$f":"C29-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":45.5}]
[3,1,{"$f":"C30-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":46.5}]
[2,1,{"$f":"C31-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":47.5}]
[1,1,{"$f":"C32-Table2[[#This Row],[Daily Yield Gain (%/Day)]]","v":48.5}]
[0,0,{"$f":"49.5","v":49.5}]