{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["KSSL Pedon Field Sheet","Request for Analysis","INSTRUCTIONS","Analysis Applicability Guide"," P Analysis Guide","Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"KSSL Pedon Field Sheet","index":0,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,4,5],[5,15,6,15],[5,7,6,7],[0,6,0,16],[3,14,3,15],[2,0,2,1],[2,2,2,5],[0,0,0,5],[2,16,2,17],[1,0,1,1],[3,6,3,7],[3,16,3,18],[3,0,3,1],[4,13,4,14],[4,15,4,20],[5,10,5,12],[4,6,4,9],[5,9,6,9],[5,13,6,13],[4,10,4,12],[2,19,2,20],[2,7,2,12],[1,2,1,6],[1,7,1,9],[3,2,3,3],[3,4,3,5],[3,19,3,20],[3,10,3,11],[3,12,3,13],[3,8,3,9],[1,19,1,20],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,10,1,12],[22,3,22,20],[24,0,24,20],[5,0,6,0],[5,3,6,3],[5,14,6,14],[5,8,6,8],[23,0,23,2],[23,3,23,20],[5,16,6,16],[21,0,21,2],[21,3,21,20],[5,6,6,6],[5,1,5,2],[5,4,6,4],[5,5,6,5],[22,0,22,2]]}
["Mouse over shaded cells for instructions",null,null,null,null,null,"KSSL Pedon Field Sheet - DSP"]
["User Pedon ID",null,null,null,null,null,null,"Pedon Type (characterization, main, or satellite)",null,null,null,null,null,"DSP Plot ID",null,null,null,"Sampled Date"]
["Soil Name",null,null,null,null,null,"Tax. Class.",null,null,null,null,null,null,"Datum",null,"Lat",null,null,"Long"]
["Ctrl Sect Top",null,null,null,"Ctrl Sect Bot",null,null,null,"MLRA Code",null,null,null,"SSA Code",null,null,null,"NASIS Pedon Record ID"]
["Field Observations",null,null,null,null,null,"Quantity of Samples",null,null,null,"Volume --  cm3",null,null,"Weight (lb or kg)",null," --------------------- Volume % (estimated) --------------------- "]
["Field       #","Horizon Depth",null,"Hzn  #","Horizon Desig","Field   Texture","Number of  Bulk Sample Bags","Number of Bulk Density clods    (3)","Number of Undis-turbed/ Agg Stab boxes      ","Number of Other Samples e.g. core, compliant cavity etc. (3)","Bulk density: field core, compliant cavity, can, other",null,null,"< 20 mm (<3/4 in)  less tare","20-76mm (3/4-3 in) less tare","Fine gravel     2-5mm","Medium gravel      5-20mm","Channers\n2-150mm (0.1-6 \")","Flagstones\n150-380mm (6-15.5\")","Stones\n380-600mm   (15.5-25\")","Boulders\n>600mm\n(>25 in)"]
[null,"Top     (cm)","Bottom   (cm)",null,null,null,null,null,null,null,"#1*","#2*","#3*",null,null,null,null,"Gravel\n20-76mm (3/4-3 in)","Cobbles\n76-250mm    (3-10 in)","Stones\n250-600mm   (10-25 in)","Boulders\n>600mm\n(>25 in)"]
[null,null,null,"1"]
[null,null,null,"2"]
[null,null,null,"3"]
[null,null,null,"4"]
[null,null,null,"5"]
[null,null,null,"6"]
[null,null,null,"7"]
[null,null,null,"8"]
[null,null,null,"9"]
[null,null,null,"10"]
[null,null,null,"11"]
[null,null,null,"12"]
[null,null,null,"13"]
[null,null,null,"14"]
["Reason For Sampling:"]
["Notes:"]
["Local Pedon ID:"]
["* Also record volume for each bulk density sample on the sample bag"]

{"sheet":"Request for Analysis","index":1,"n_rows":20,"n_cols":46,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[]
[]
["User Pedon ID","Field Label","Horizon","Top Depth (cm)","Bot. Depth (cm)","Analysis Groups","200 cm DSP Central pedon: Typical","200 cm DSP Central pedon w/ soluble salts","200 cm DSP Central pedon w/ Spodic properties","200cm DSP Central pedon w/ Andic properites (volcanic ash)","200 cm DSP Central pedon: Organic (peaty & mucky)","100 cm DSP Main Site","50 cm Satellite sites","Analyses in Selected Group(s) ","Calcium Carbonate Equivalent","Extractable Acidity, BaCl2 - TEA","CEC pH 7 and Cations","Total Nitrogen, Carbon, and Sulfur","KCl Extract","pH, Routine  (H2O & CaCl2)","pH, NaF","Gypsum, <2mm","Acid Oxalate Extract","Dithionite-Citrate Extract","New Zealand Phosphorus Retention","EC 1:2 (Salt Predict)","Saturated Paste and Soluble Salts","Water Retention, 15 Bar, <2mm ","PSDA, Air-dry, <2 mm","Fiber Analysis","Mineral Content  (LOI)","Soil Test Phosphorus - Select one:\nSee 'P Analysis Guide' tab for selection guidance. ","Phosphorus, Bray 1","Phosphorus, Mehlich 3","Phosphorus, Olsen","DSP Physical and Biological Analyses\nCheck appropriate analyses based on sample type","Bulk Density, Clod & 0.33 Bar Water Retention","Supplemental / Optional Analyses","pH, 1N KCl ","Fine Clay, PSDA Air-Dry, <2mm","    Mineralogy and Micromorphology","Clay Mineralogy, XRD  (control section)","Optical Analysis, Full Count  (control section)","Optical Analysis, Glass Count  (control section)","Other Analyses (specify)  / Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List Other Analyses, Notes, Instructions"]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E8=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A8=\"\",\"\",'KSSL Pedon Field Sheet'!A8)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E8=\"\",\"\",'KSSL Pedon Field Sheet'!E8)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B8=\"\",\"\",'KSSL Pedon Field Sheet'!B8)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C8=\"\",\"\",'KSSL Pedon Field Sheet'!C8)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E9=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A9=\"\",\"\",'KSSL Pedon Field Sheet'!A9)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E9=\"\",\"\",'KSSL Pedon Field Sheet'!E9)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B9=\"\",\"\",'KSSL Pedon Field Sheet'!B9)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C9=\"\",\"\",'KSSL Pedon Field Sheet'!C9)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E10=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A10=\"\",\"\",'KSSL Pedon Field Sheet'!A10)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E10=\"\",\"\",'KSSL Pedon Field Sheet'!E10)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B10=\"\",\"\",'KSSL Pedon Field Sheet'!B10)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C10=\"\",\"\",'KSSL Pedon Field Sheet'!C10)","v":""}]
[null,{"$f":"IF('KSSL Pedon Field Sheet'!A11=\"\",\"\",'KSSL Pedon Field Sheet'!A11)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E11=\"\",\"\",'KSSL Pedon Field Sheet'!E11)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B11=\"\",\"\",'KSSL Pedon Field Sheet'!B11)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C11=\"\",\"\",'KSSL Pedon Field Sheet'!C11)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E12=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A12=\"\",\"\",'KSSL Pedon Field Sheet'!A12)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E12=\"\",\"\",'KSSL Pedon Field Sheet'!E12)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B12=\"\",\"\",'KSSL Pedon Field Sheet'!B12)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C12=\"\",\"\",'KSSL Pedon Field Sheet'!C12)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E13=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A13=\"\",\"\",'KSSL Pedon Field Sheet'!A13)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E13=\"\",\"\",'KSSL Pedon Field Sheet'!E13)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B13=\"\",\"\",'KSSL Pedon Field Sheet'!B13)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C13=\"\",\"\",'KSSL Pedon Field Sheet'!C13)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E14=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A14=\"\",\"\",'KSSL Pedon Field Sheet'!A14)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E14=\"\",\"\",'KSSL Pedon Field Sheet'!E14)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B14=\"\",\"\",'KSSL Pedon Field Sheet'!B14)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C14=\"\",\"\",'KSSL Pedon Field Sheet'!C14)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E15=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A15=\"\",\"\",'KSSL Pedon Field Sheet'!A15)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E15=\"\",\"\",'KSSL Pedon Field Sheet'!E15)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B15=\"\",\"\",'KSSL Pedon Field Sheet'!B15)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C15=\"\",\"\",'KSSL Pedon Field Sheet'!C15)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E16=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A16=\"\",\"\",'KSSL Pedon Field Sheet'!A16)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E16=\"\",\"\",'KSSL Pedon Field Sheet'!E16)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B16=\"\",\"\",'KSSL Pedon Field Sheet'!B16)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C16=\"\",\"\",'KSSL Pedon Field Sheet'!C16)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E17=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A17=\"\",\"\",'KSSL Pedon Field Sheet'!A17)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E17=\"\",\"\",'KSSL Pedon Field Sheet'!E17)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B17=\"\",\"\",'KSSL Pedon Field Sheet'!B17)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C17=\"\",\"\",'KSSL Pedon Field Sheet'!C17)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E18=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A18=\"\",\"\",'KSSL Pedon Field Sheet'!A18)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E18=\"\",\"\",'KSSL Pedon Field Sheet'!E18)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B18=\"\",\"\",'KSSL Pedon Field Sheet'!B18)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C18=\"\",\"\",'KSSL Pedon Field Sheet'!C18)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E19=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A19=\"\",\"\",'KSSL Pedon Field Sheet'!A19)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E19=\"\",\"\",'KSSL Pedon Field Sheet'!E19)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B19=\"\",\"\",'KSSL Pedon Field Sheet'!B19)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C19=\"\",\"\",'KSSL Pedon Field Sheet'!C19)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E20=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A20=\"\",\"\",'KSSL Pedon Field Sheet'!A20)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E20=\"\",\"\",'KSSL Pedon Field Sheet'!E20)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B20=\"\",\"\",'KSSL Pedon Field Sheet'!B20)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C20=\"\",\"\",'KSSL Pedon Field Sheet'!C20)","v":""}]
[{"$f":"IF(OR('KSSL Pedon Field Sheet'!$C$2=\"\",'KSSL Pedon Field Sheet'!E21=\"\"),\"\",'KSSL Pedon Field Sheet'!$C$2)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!A21=\"\",\"\",'KSSL Pedon Field Sheet'!A21)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!E21=\"\",\"\",'KSSL Pedon Field Sheet'!E21)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!B21=\"\",\"\",'KSSL Pedon Field Sheet'!B21)","v":""},{"$f":"IF('KSSL Pedon Field Sheet'!C21=\"\",\"\",'KSSL Pedon Field Sheet'!C21)","v":""}]
[]
["Go to INSTRUCTIONS tab for workbook instructions."]

{"sheet":"INSTRUCTIONS","index":2,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["\"REQUEST FOR ANALYSIS\" INSTRUCTIONS"]
[]
["General:"]
["The User Pedon ID, Field Number, Horizon Designation and Horizon Depths on this sheet are auto-populated with information entered on the KSSL Pedon Field Sheet."]
["To see a list of analyses included in each Analysis Group or for more information about each individual analysis, hover the mouse pointer over cells with red triangles."]
["Requesting Analyses:"]
["Indicate the requested Analysis Group (Example:  200 cm DSP Central pedon, Typical, 50cm Satellite Site, etc.) for each horizon/layer by selecting the check mark (✔) from the drop-down menu on each row.  In the section, 'Analysis in Selected Group(s)', a check mark will show up automatically under each analysis that is included by default as part of the Analysis Group.  Cells highlighted in yellow indicate optional analyses that can be selected if appropriate based on the soil characteristics or data needs of the sampling project."]
[]
["Indicate any Physical Analyses requested that apply based on sample type(s) submitted.  \nIndicate any Supplemental/Optional Analyses requested for each horizon/layer.  For more information about which analyses might be applicable, please see the \"Analysis Applicability Guide\" tab of this workbook."]
[]
["If requesting Phosphorus analysis, please choose the appropriate soil test phosphorus analysis for each horizon/layer.  Refer to the \"P Analysis Guide\" tab of this workbook for more information about selecting an appropriate phosphorus analysis."]
[]
["Select a Mineralogy analysis if it is needed for characterization.  Select the appropriate mineralogy analysis for a representative horizon within the control section.  Refer to the \"Analysis Applicability Guide\" tab of this workbook for more information about selecting horizons for mineralogical analysis."]
[]
["If requesting an analysis that is not listed on the spreadsheet, indicate which analysis or analyses are requested and provide a justification in the 'List Other Analyses, Notes, Instructions' column.  If additional space is needed, please use the \"Notes\" section of the KSSL Pedon Field Sheet."]
[]
["To unselect/remove a check mark from an Analysis Group or Analysis:"]
["Click the cell where you wish to remove the check mark, right click, and select 'Clear Contents'.  Removing the check mark under the 'Analysis Group' for a row will remove all check marks under the analyses in the 'Analyses in Selected Group(s)' section."]

{"sheet":"Analysis Applicability Guide","index":3,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["LAB PROCEDURES WHICH ARE SUBJECT TO SCREENING CRITERIA OR HAVE RANGES OF LIMITED APPLICABILITY"]
[]
["Procedures Subject to Preliminary Screening Analyses:"]
["Samples must meet or exceed the screening criteria for KSSL to proceed with the analysis."]
[]
["Procedure","Screening Criteria","Rationale"]
["Calcium Carbonate Equivalent","Effervescence class \"very slight\" or greater, \npH CaCl2 ≥ 6.95","Excludes samples that are unlikely to contain CaCO3"]
["Extractable Acidity, BaCl2","Effervescence class \"very slight\" or \"none\"","Non-acid samples are unlikely to contain measurable extractable acidity."]
["Gypsum","1:2 EC predict ≥ 0.50 ds/m","Samples with lower electrical conductivity are unlikely to have measurable gypsum content."]
["KCl Extract","pH CaCl2 ≤ 5.05","Significant exchangeable Al+3 is not present when above pH 1:2 CaCl2 of 5.05.  Precipitation of aluminum occurs during analysis when samples are above 5.05 pH 1:2 CaCl2 (5.5 pH 1:1 H2O)."]
["Saturated Paste and Soluble Salts","1:2 EC predict ≥ 0.25 ds/m","Samples with low electrical conductivity samples are unlikely to have significant salt content."]
["PSDA < 2mm, air-dry","< 20% total carbon","Particle size classes are not applicable to organic soil material.  20% total carbon cut-off ensures that no possible mineral soil materials are excluded without having to determine clay percentage."]
["Carbonate clay","Effervescence class \"slight\" or greater","Excludes samples that are unlikely to contain significant carbonate clay."]
[]
["Procedures With Limited Applicability Depending on Soil Characteristics:"]
[]
["Mineralogy Procedure","Applicability","Rationale"]
["Clay Mineralogy, XRD","Mineralogy Control Section","Clay mineralogy, XRD is done on a representative portion of the mineralogy control section to determine mineralogy family.  If this analysis is needed for layers outside of the control section, specify which layers and explain why the additional layers need analyzed."]
[null,"Clayey textured soils (>35% clay)","For soil taxonomy, clay mineralogy family classes apply to control sections with >35% clay.  For samples with <35% clay, request Optical Mineralogy instead."]
[null,"Subsurface layers","XRD works poorly on surface horizons and/or horizons with high organic matter."]
[null,"Clay content >5%","Difficult to isolate clay in soils with <5% clay; Interference by non-clay minerals."]
["Optical Mineralogy","Mineralogy Control Section","Soil Taxonomy mineralogy family class for most non-clayey soils is assigned based on determination of mineral constituents of coarse silt, very fine sand, and/or fine sand fractions. If this analysis is needed for layers outside of the control section, specify which layers and explain why the additional layers are needed."]
[null,"Clay content <35%","For samples with clay content >35%, request Clay Mineralogy XRD instead."]
[]
["Physical Procedure","Applicability","Rationale"]
["Bulk Density, Clod","Requires minimum-sized, coherent clod without excessive saran saturation.  33 kPa water content is also determined (method 3B1b) when clod Db samples are submitted.","Small, broken, or cracked clods with excessively thick saran coatings will not give accurate bulk density measurements."]
[null,"Clod bulk density samples are required to calculate the coefficient of linear extensibility (COLE).  There is not a separate analysis request for COLE","COLE calculation is based on change of clod volume from 33 kPa water content to oven dry.  COLE is calculated automatically when clod Db analysis is requested.  "]
["Bulk density samples other than clod or confined core","Volume measurement of the sample must be provided.","Loose soil samples not in a clod or confined core must have the volume provided in order to calculate bulk density."]
["Water retention for clod samples (3C1a-d2) and confined core samples (3C1a-d3), pressure-plate extraction","Applicable to samples with textures finer than loamy sand and some sandy loams.  Intact clod samples or core samples in sleeves must be submitted.  Water contents at tensions of 6, 10, 33 or 100 kPa can be requested.","For soils with textures finer than sandy, macro pores make up a significant portion of the pore space.  Macro pores are disturbed when samples are sieved, so clods and intact cores give the most reliable water retention results especially at lower tensions like 33 kPa."]
["Water retention for <2mm sieved samples, pressure-plate extraction (3C1a-e1a)","Applicable to samples with loamy sand or coarser textures and some sandy loam textures (non-expanding soils).  6, 10, 33, 100 and 200 kPa measurements can be requested.","Most pore space in coarse-textured soils is inter-particle space rather than macro pore space.  The inter-particle pore space is not dependent on the preparation method or preservation of aggregates, so the <2mm sieved samples can give reliable water tension results."]
["Water retention, 15 bar (1500 kPa), <2mm sieved samples, pressure-membrane extraction (3C2a1a)","Applicable to all textures; uses <2mm soil for the analysis","Water held at 1500 kPa tension is held completely in inter-particle pore space, so it does not matter that macro pores are disturbed by grinding/sieving the sample because macro pores are not holding any 1500 kPa water."]
["Fine Clay, PSDA","Suspected presence of an argillic horizon, confirmation of illuvial clay","The fine clay to clay ratio is higher in illuvial horizons than adjacent eluvial horizons."]
["PSDA, Moist","Only appropriate for soils from continuously moist climates and mineralogy that hardens irreversibly when air dried.","Continuously moist soils may harden and form aggregates when dried.  This analysis is not applicable to other soil samples."]
[]
["Chemistry Procedure","Applicability","Rationale"]
["Acid Oxalate Extractable Aluminum, Iron and Silicon","Used as criteria for andic soil properties and spodic materials and in the Andic and Spodic subgroups in other orders.  The relative amounts of oxalate extractable iron and silicon are used to define the amorphic and ferrihydritic mineralogy classes.","This procedure extracts iron, aluminum, and silicon from organic matter and amorphous mineral material.  It is used in conjunction with dithionite citrate extractions to identify sources of iron and aluminum in the soil."]
["Optical Density of Oxalate Extract (ODOE)","Used in the definition of spodic material and in Spodic subgroups in other orders.  ODOE is not done for oxalate extracts related to andic soil properties.","Indicates an accumulation of translocated organic matter.  Relative content of ODOE is compared for adjacent horizons."]
["Dithionite Citrate Extractable Iron","Used to identify several iron-related mineralogy classes.  Also to indicate iron oxide distribution in soil profiles.","Measures iron oxides and oxyhydroxide.  Can be related to clay distribution within a pedon and related to the degree and patterns of soil weathering.  "]
["NaF pH","NaF pH of 8.4 or more is a criterion for the isotic mineralogy class.","Indicates the influence of short-range-order minerals. May be used in identifying andic or spodic influences."]
["Oxidized pH","Applicable for determination of sulfidic soil material.  Subaqueous sites require fresh, moist, sealed samples with air excluded to prevent oxidization of sulfides.  Samples not shipped immediately will require freezing for storage.","Oxidized pH is a test for the presence of sulfides which oxidize upon exposure to air/oxygen and is required to identify sulfidic soil material.  Subaqueous samples exposed to air can oxidize before the analytical procedure is started resulting in inaccurate results."]
[null,"Applicable to non-subaqueous samples such as spoil, Cr or R material where the presence of potentially oxidizable sulfides is suspected.","Non-subaqueous samples should be kept dry to prevent the initiation of biologic activity which can result in oxidization."]
["EC 1:5 by Volume, Subaqueous Soils","Applicable to subaqueous soils.","Required in soil taxonomy for differentiation of brackish and freshwater soil taxa.  The procedure also gives estimation of pore water EC."]
["Saturated Paste and Soluble Salts","Applicable to soils without oxidizable sulfides and mineral (non-organic) soil material.  Subject to preliminary screening criteria (EC predict 1:2).","Oxidization of sulfides to sulfates alters the ionic contents of samples.  Organic soil material contributes organic ion species not accounted for in the saturated paste analytical procedure."]

{"sheet":" P Analysis Guide","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["THE SOIL PROPERTIES AFFECTING SELECTION OF THE APPROPRIATE P TEST"]
["AND RECOMMENDED METHODS ARE OUTLINED IN THE FOLLOWING TABLE"]
[]
[]
[null,"Soil","pH","Methods"]
[null,"Acidic","< 6.0","Bray 1, Mehlich 3"]
[null,"Slightly acid to slightly alkaline","6.0 to 7.2","Bray 1, Mehlich 3, Olsen"]
[null,"Alkaline, calcareous","> 7.2","Olsen"]
[]
[]
["Factors such as compatibility with existing data and compatibility with widely-used methods in the local area "]
["can be considered in selecting tests where pH is in overlapping pH ranges or near pH limits."]

{"sheet":"Template","index":5,"n_rows":23,"n_cols":32,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Analysis Groups","Analyses in Selected Group(s)","Calcium Carbonate Equivalent, <2mm","Extractable Acidity, BaCl2-TEA","CEC pH 7 and Cations","Total Nitrogen, Carbon, and Sulfur","KCl Extract","pH, Routine","pH, NaF","Gypsum, <2mm","Acid Oxalate Extract","Dithionite-Citrate Extract","New Zealand Phosphorus Retention","EC 1:2 (Salt Predict)","Saturated Paste and Soluble Salts","Water Retention 15bar","PSDA Air-dry, <2mm","Fiber Analysis","Mineral Content","Soil Test Phosphorus","Phosphorus Bray 1","Phosphorus, Mehlich III","Phosphorus, Olsen","DSP Physical Analyses","Bulk Density, Clod & 0.33 Bar Water Retention","Supplemental/Optional Analyses","pH KCL","Fine Clay, PSDA Air-Dry, <2mm","Mineralogy and Micromorphology","Clay Mineralogy, XRD","Optical Analysis, Full Count","Optical Analysis, Glass Count"]
["200cm DSP Central Pedon: Typical","X","T","T","T","T","T","T","O","T","O","O","O","T","O","T","T",null,"O","X","O","O","O","X","T","X","O","O","X","O","O","O"]
["200cm DSP Central Pedon: Salt (soluble salts present)","X","T","T","T","T","T","T",null,"T",null,null,null,"T","T","T","T",null,"O","X","O","O","O","X","T","X","O","O","X","O","O"]
["200cm DSP Central Pedon: Spodic (spodic properties)","X","T","T","T","T","T","T","T","O","T","T","T","T","O","T","T",null,"O","X","O","O","O","X","T","X","O","O","X","O","O","O"]
["200cm DSP Central Pedon: Andic (volcanic ash influenced)","X","T","T","T","T","T","T","T","O","T","T","T","T","O","T","T",null,"O","X","O","O","O","X","T","X","O","O","X","O","O","O"]
["200cm DSP Central Pedon: Organic (peaty & mucky)","X","T","T","T","T","T","T",null,null,null,null,null,"T","O","T","T","T","T","X","O","O","O","X","T","X","O",null,"X"]
["100cm DSP Main Site","X","T","T","T","T","T","T",null,"T",null,null,null,"T",null,"T","T",null,null,"X","O","O","O","X",null,"X","O",null,"X"]
["50cm Satellite sites","X","T","O","O","T","O","T",null,null,null,null,null,"T",null,"T","O",null,null,"X","O","O","O","X",null,"X",null,null,"X"]
[]
[]
[null,"T","TRUE - The cell should be automatically checked"]
[null,"O","OPTIONAL - Checking the cell is optional"]
[null,null,"BLANK - The cell cannot be checked at all"]
[null,"X","BREAK - Indicates a break between sections"]
[null,"✔","USE THIS SYMBOL AS AN INDICATOR ON THE REQUEST SHEET"]
[]
["INSTRUCTIONS:"]
["To enable macros, select File>Options (bottom left), select Trust Center, Trust Center Settings, Macro Settings, Enable…"]
["To modify this template, Unprotect the sheet first."]
["   if adding rows/columns, use insert rows/columns so that formats and data validation are copied"]
["   make sure identical rows/columns are duplicated in Request and Template sheets"]
["   mark the cells for selection as desired"]
["   protect the sheet to prevent accidential changes"]