{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Procedure","General Order Form","Rate"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":30,"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":"Procedure","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,3],[6,0,6,3],[7,0,8,1],[0,0,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3]]}
["PROCEDURE Soil Hydro-Physics Lab work 2020"]
[]
[1,"Please fill in the Order Form"]
[2,"Mail the Order Form to the lab controller and indicate the preferred dates of lab use"]
[3,"The lab controller will contact you about planning and reservations"]
[4,"Please note that once a reservation is made, it is normative, even if a lab job impends to overrun its planned time or is delayed. Shifts in reservations can only be made after consulting the lab controller."]
[]
["Lab controllers:",null,1,"gerben.bakker@wur.nl"]
[null,null,2,"harm.gooren@wur.nl"]

{"sheet":"General Order Form","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[57,5,57,6],[58,5,58,6],[59,5,59,6],[57,7,57,8],[58,7,58,8],[59,7,59,8],[54,0,54,4],[54,5,54,7],[56,0,56,1],[55,1,55,8],[56,2,56,4],[56,5,56,8],[9,4,9,6],[53,0,53,7],[50,0,50,8],[52,0,52,8],[51,0,51,4],[9,0,9,1],[10,0,10,1],[41,0,41,8],[13,8,16,8],[13,5,16,5],[17,5,17,8],[13,6,15,7],[10,4,10,6],[11,4,11,6],[40,0,40,4],[39,0,39,4],[2,3,2,8],[7,1,7,2],[6,1,6,2],[5,1,5,2],[4,1,4,2],[3,1,3,2],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[38,0,38,4],[37,0,37,4],[36,0,36,4],[35,0,35,4],[34,0,34,4],[33,0,33,4],[11,0,11,1],[32,0,32,4],[31,0,31,4],[30,0,30,4],[29,0,29,4],[28,0,28,4],[21,0,21,4],[20,0,20,4],[19,0,19,4],[18,0,18,4],[27,0,27,4],[26,0,26,4],[25,0,25,4],[24,0,24,4],[23,0,23,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[13,0,16,4],[9,7,9,8],[10,7,11,8],[12,4,12,8],[49,0,49,4],[48,0,48,4],[47,0,47,4],[46,0,46,4],[45,0,45,4],[44,0,44,4],[43,0,43,4],[42,0,42,4],[22,0,22,4]]}
[]
["Order Form SHP-LAB 2020,  (proj.nr. 5500044477)"]
["Project Information:",null,null,"Billing Address:"]
["Project Manager:",null,null,"Institute:"]
["Project Number:",null,null,"Addressee:"]
["Project Name:",null,null,"Address:"]
["Research Group:",null,null,"Postal code:"]
["Lab Technician:",null,null,"City:"]
[null,null,null,"Country:"]
["I am a member of WENR-SWL, DOW-SLM, DOW-SBL, DOW-SGL",null,"(Y / N)",null,{"$f":"IF(OR(D10=\"N\",D10=\"n\",D10=\"Y\",D10=\"y\"),\"\",\"< -- Not a valid entry\")","v":"< -- Not a valid entry"},null,null,"Rate (%)"]
["I do the experiments myself",null,"(Y / N)",null,{"$f":"IF(OR(D11=\"Y\",D11=\"y\"),\"Indicate Assistance Need under Remarks\",IF(OR(D11=\"N\",D11=\"n\"),\"\",\"< -- Not a valid entry\"))","v":"< -- Not a valid entry"},null,null,{"$f":"IF(D13=FALSE,100,IF(OR(D11=\"N\",D11=\"n\"),100,IF(OR(D10=\"N\",D10=\"n\"),25,IF(OR(D12=\"N\",D12=\"n\"),0,18))))","v":100}]
["Experiment is part of a Contract Funded Project (3e geldstroom)",null,"(Y / N)",null,{"$f":"IF(OR(D12=\"N\",D12=\"n\",D12=\"Y\",D12=\"y\"),\"\",\"< -- Not a valid entry\")","v":"< -- Not a valid entry"}]
["Rate:","(M+IKP)/2",null,{"$f":"IF(AND(OR(D10=\"Y\",D10=\"y\",D10=\"N\",D10=\"n\"),OR(D11=\"Y\",D11=\"y\",D11=\"N\",D11=\"n\"),OR(D12=\"Y\",D12=\"y\",D12=\"N\",D12=\"n\")),TRUE,FALSE)","v":false}]
[{"$f":"Rate!A10","v":"Method, Complete Curves, or Other"},null,null,null,null,"Price per sample per point\n(Euro)","Amount of ",null,"Total\n(Euro)"]
[]
[]
[null,null,null,null,null,null,"Samples","Points"]
[{"$f":"Rate!A11","v":"Individual Methods:"}]
[{"$f":"Rate!A12","v":"Aggregate Stability per aggregate fraction"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B12,2)","v":93.57},null,1,{"$f":"IF(AND(G19>0,H19>0),F19*G19*H19,\"\")","v":""}]
[{"$f":"Rate!A13","v":"Air dry mass water content (h=-10^6 cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B13,2)","v":24.18},null,1,{"$f":"IF(AND(G20>0,H20>0),F20*G20*H20,\"\")","v":""}]
[{"$f":"Rate!A14","v":"Atterberg Limits"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B14,2)","v":644.94000000000005},null,1,""]
[{"$f":"Rate!A15","v":"Burette Hanging Water Column Manual (h=0 until -200cm) "},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B15,2)","v":82.92},null,null,""]
[{"$f":"Rate!A16","v":"Dry Bulk Density rho(d) (undisturbed samples) (T=105 dgr.C)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B16,2)","v":24.18},null,1,""]
[{"$f":"Rate!A17","v":"Evaporation (Wind) (h=-50 until -700cm) (fixed > 20 points) + data filter (excl fit)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B17,2)","v":806.71},null,1,""]
[{"$f":"Rate!A18","v":"Evaporation_Mualem-Van Genuchten Fit"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B18,2)","v":387.8},null,1,{"$f":"IF(AND(G25>0,H25>0),F25*G25*H25,\"\")","v":""}]
[{"$f":"Rate!A19","v":"Loss on ignition (OS) (T=550 dgr.C)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B19,2)","v":18.510000000000002},null,null,""]
[{"$f":"Rate!A20","v":"Multistep (h=0 until -1000cm) (fixed > 50 points)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B20,2)","v":125.53},null,1,""]
[{"$f":"Rate!A21","v":"Pipette Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)"},null,null,null,null,{"$f":"Rate!B21","v":104.78395939086293},null,1,""]
[{"$f":"Rate!A22","v":"Pipette Method per fraction (CBLB) (N.B: Preparation excl.) Only performed by lab personnel"},null,null,null,null,{"$f":"Rate!B22","v":20.834111675126902},null,null,""]
[{"$f":"Rate!A23","v":"Pore Volume (excl drying at 105 gr.C)  with air pycnometer"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B23,2)","v":49.52},null,1,""]
[{"$f":"Rate!A24","v":"Pressure Plate (h=-10^3 until -10^4cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B24,2)","v":92.13},null,null,""]
[{"$f":"Rate!A25","v":"Sandbox (h=0 until -100cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B25,2)","v":24.18},null,null,""]
[{"$f":"Rate!A26","v":"Saturated Hydraulic Conductivity Ksat (h=0)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B26,2)","v":342.05},null,1,""]
[{"$f":"Rate!A27","v":"Saturated Hydraulic Conductivity Ksat (h=0) at extreme low conductivities"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B27,2)","v":494.08},null,1,""]
[{"$f":"Rate!A28","v":"Shrinkage Characteristic (h=0 until -10^6cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B28,2)","v":28.79},null,null,""]
[{"$f":"Rate!A29","v":"Sieving Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)"},null,null,null,null,{"$f":"Rate!B29","v":104.78395939086293},null,1,{"$f":"IF(AND(G36>0,H36>0),F36*G36*H36,\"\")","v":""}]
[{"$f":"Rate!A30","v":"Sieving weight fraction (chemical preparation excl.)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B30,2)","v":19.579999999999998},null,null,""]
[{"$f":"Rate!A31","v":"Suction Plate (h=50 until -700cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B31,2)","v":42.62},null,null,""]
[{"$f":"Rate!A32","v":"Water Content or Wetness (Volumetric or Gravimetric Water Content) (T=105 dgr.C)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B32,2)","v":24.18},null,1,""]
[{"$f":"Rate!A33","v":"Water Repellency: Water or Alcohol Penetration Test"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B33,2)","v":24.18},null,1,""]
[{"$f":"Rate!A34","v":"Wetting rate"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B34,2)","v":115.17},null,1,""]
[{"$f":"Rate!A35","v":"Complete Curves:"}]
[{"$f":"Rate!A36","v":"Compression c.q. Uniaxial test (compression and pressure head in time at predefined forces up to 7 bar)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B36,2)","v":211.91},null,1,{"$f":"IF(AND(G43>0,H43>0),F43*G43*H43,\"\")","v":""}]
[{"$f":"Rate!A37","v":"pF curve (h = 3, 10, 30, 60, 100, 300, 1000, 3000, 14000, 1000 000 cm)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B37,2)","v":513.6},null,1,{"$f":"IF(AND(G44>0,H44>0),F44*G44*H44,\"\")","v":""}]
[{"$f":"Rate!A38","v":"Pipette Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)"},null,null,null,null,{"$f":"Rate!B38","v":104.78395939086293},null,1,""]
[{"$f":"Rate!A39","v":"Pipette Method fractions <2, <16, <50, >50u  (CBLB) (N.B: Preparation excl.) Only performed by lab personnel"},null,null,null,null,{"$f":"Rate!B39","v":89.68},null,1,""]
[{"$f":"Rate!A40","v":"Shrinkage Characteristic curve (h=0 until -10^6cm) 15 points"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B40,2)","v":431.89},null,1,""]
[{"$f":"Rate!A41","v":"Sieve curve weight fractions <63, <105, <150, <210, <420, <2000 (chemical preparation excl.)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B41,2)","v":117.46},null,1,""]
[{"$f":"Rate!A42","v":"Unsaturated hydraulic conductivity curve + pF curve ( = 4xSandb + Evap Method&filter + 2xPress.Plt + Air dry) (excl fit)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B42,2)","v":1111.8699999999999},null,1,{"$f":"IF(AND(G49>0,H49>0),F49*G49*H49,\"\")","v":""}]
[{"$f":"Rate!A43","v":"(Un)saturated hydraulic conductivity curve + pF curve ( = Ksat + 4xSandb + Evap Method&filter + 2xPress.Plt + Air dry + MvG-fit)"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B43,2)","v":1841.72},null,1,""]
[{"$f":"Rate!A44","v":"Other:"}]
[{"$f":"Rate!A45","v":"Other Lab experiments expressed per man hour of use"},null,null,null,null,{"$f":"ROUND(($H$11/100)*Rate!B45,2)","v":129.27000000000001},"Hours -->",null,{"$f":"IF(H52>0,F52*H52,\"\")","v":""}]
[]
["Administration costs",null,null,null,null,null,null,null,{"$f":"Rate!B4/2","v":53}]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I19:I54)","v":53}]
["Remarks:"]
["Manager SHP-lab",null,"Manager Project",null,null,"F&C"]
["Name:","G. Bakker","Name:",null,null,"Name:"]
["Date:",null,"Date:",null,null,"Date:"]
["Signature:",null,"Signature:",null,null,"Signature:"]

{"sheet":"Rate","index":2,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,4,1],[0,0,0,1]]}
["Price List "]
["Soil Hydro-Physics (SHP) Laboratory 2020"]
["Last update by Gerben Bakker on 03-02-2020"]
["Rate (M+IKP)/2=(120+92)/2=",{"$f":"(120+92)/2","v":106}]
["Experiments performed by yourself:"]
["Not a member of WENR-SWL, DOW-SLM, DOW-SBL, DOW-SGL","25% of normal total costs"]
["Member of  WENR-SWL, DOW-SLM, DOW-SBL, DOW-SGL","18% of normal total costs"]
["Non-contract  funded projects and member of WENR-SWL, DOW-SLM, DOW-SBL, DOW-SGL","0% of normal total costs"]
[]
["Method, Complete Curves, or Other","Normal total costs (Euro) per sample per point or fraction\n\nTotal (= Labor + Lab)\nT (= 0.82  * T + 0.18 * T)"]
["Individual Methods:"]
["Aggregate Stability per aggregate fraction",93.573356345177658]
["Air dry mass water content (h=-10^6 cm)",24.18]
["Atterberg Limits",644.93789847715732]
["Burette Hanging Water Column Manual (h=0 until -200cm) ",82.921378680203034]
["Dry Bulk Density rho(d) (undisturbed samples) (T=105 dgr.C)",24.180913705583752]
["Evaporation (Wind) (h=-50 until -700cm) (fixed > 20 points) + data filter (excl fit)",806.71]
["Evaporation_Mualem-Van Genuchten Fit",387.8]
["Loss on ignition (OS) (T=550 dgr.C)",18.509644670050758]
["Multistep (h=0 until -1000cm) (fixed > 50 points)",125.53197969543146]
["Pipette Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)",104.78395939086293]
["Pipette Method per fraction (CBLB) (N.B: Preparation excl.) Only performed by lab personnel",20.834111675126902]
["Pore Volume (excl drying at 105 gr.C)  with air pycnometer",49.524060913705583]
["Pressure Plate (h=-10^3 until -10^4cm)",92.128527918781714]
["Sandbox (h=0 until -100cm)",24.18]
["Saturated Hydraulic Conductivity Ksat (h=0)",342.05177664974616]
["Saturated Hydraulic Conductivity Ksat (h=0) at extreme low conductivities",494.07837563451773]
["Shrinkage Characteristic (h=0 until -10^6cm)",28.786802030456851]
["Sieving Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)",104.78395939086293]
["Sieving weight fraction (chemical preparation excl.)",19.57502538071066]
["Suction Plate (h=50 until -700cm)",42.615228426395937]
["Water Content or Wetness (Volumetric or Gravimetric Water Content) (T=105 dgr.C)",24.180913705583752]
["Water Repellency: Water or Alcohol Penetration Test",24.180913705583752]
["Wetting rate",115.16873096446699]
["Complete Curves:"]
["Compression c.q. Uniaxial test (compression and pressure head in time at predefined forces up to 7 bar)",211.91390862944158]
["pF curve (h = 3, 10, 30, 60, 100, 300, 1000, 3000, 14000, 1000 000 cm)",513.6]
["Pipette Preparation (CBLB): Dry, break, sieve <2000u, Remove OM (H2O2), Carbonates (HCl) (Only performed by Lab personnel)",104.78395939086293]
["Pipette Method fractions <2, <16, <50, >50u  (CBLB) (N.B: Preparation excl.) Only performed by lab personnel",89.68]
["Shrinkage Characteristic curve (h=0 until -10^6cm) 15 points",431.88812182741111]
["Sieve curve weight fractions <63, <105, <150, <210, <420, <2000 (chemical preparation excl.)",117.46091370558375]
["Unsaturated hydraulic conductivity curve + pF curve ( = 4xSandb + Evap Method&filter + 2xPress.Plt + Air dry) (excl fit)",{"$f":"4*B25+B17+2*B24+B13","v":1111.8670558375636}]
["(Un)saturated hydraulic conductivity curve + pF curve ( = Ksat + 4xSandb + Evap Method&filter + 2xPress.Plt + Air dry + MvG-fit)",{"$f":"B26+4*B25+B17+2*B24+B18+B13","v":1841.7188324873098}]
["Other:"]
["Other Lab experiments expressed per man hour of use",129.26619289340101]
[]
["Please contact:"]
["Gerben Bakker 0317-486537 (gerben.bakker@wur.nl)"]
["Harm Gooren 0317-483707 (harm.gooren@wur.nl)"]
["                                                                                                                                 "]