{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["N2O Flux","Sheet1","Jar calcs"],"not_rendered":{"charts":61,"images":0,"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":"part_too_large","date_system":"1900"}

{"sheet":"N2O Flux","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"read":"part_too_large"}

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

{"sheet":"Jar calcs","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"If jar is filled to 100 mm depth, that is 220 g air-dried manure"]
[]
[null,"Jar Size"]
[]
[null,750,"ml volume"]
[null,75,"mm diameter"]
[null,{"$f":"3.14159*B7^2/4","v":4417.8609374999996},"mm2 area/jar"]
[null,{"$f":"B8/1000/1000","v":4.4178609374999995E-3},"m2 area/jar"]
[]
[]
[]
[null,10,"tons/acre"]
[null,{"$f":"B13*2000","v":20000},"lbs/acre"]
[null,{"$f":"B14/43560","v":0.4591368227731864},"lbs/ft2"]
[null,{"$f":"B15*(3.28^2)","v":4.9395775941230475},"lbs/m2"]
[null,{"$f":"B16*B9","v":2.1822366900826441E-2},"lbs/jar"]
[null,454,"g/lb"]
[null,{"$f":"B17*B18","v":9.9073545729752048},"g/jar"]
[]
[null,"Fill jar to 100 mm depth of soil"]
[null,"Add 9.91 g manure to jars that receive manure"]
[]
[null,"Add additional soil to the \"soil only\" and \"soil plus N fertilizer\" to get same headspace as the other manure jars."]
[]
[]
[null,"How much N in 9.91 g manure?"]
[null,"From Experiment 19-02, total N = ",null,null,null,1.74,"%"]
[]
[null,{"$f":"B19*F28/100","v":0.17238796956976857},"g N in 9.91 g manure"]
[]
[null,"% N in Urea =",null,46,"%"]
[]
[null,"So, need to add:",null,{"$f":"B30/(D32/100)","v":0.37475645558645337},"g urea to each jar to obtain same N application rate as in manure"]
[]
[null,"This is equivalent to:",null,{"$f":"B14*F28/100","v":348},"lbs N/acre"]