{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Settings","Predictions","OPUS Output"],"not_rendered":{"charts":0,"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":"Instructions","index":0,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Workbook to organize OPUS prediction output"]
[]
[1,"In Opus click <Quant 2 Analysis / File List>"]
[2,"On \"Methods\" Tab:"]
[null,null,"either <Add Methods> or <Load Methods List> "]
[3,"On \"Spectra\" Tab:"]
[null,null,"either <Add Spectra> or <Load Spectra List>"]
[null,null,"Click <Add Component Columns> (even if there are no laboratory data)"]
[null,null,"Add any laboratory data into the table"]
[null,null,"Check data lines up with the correct samples"]
[4,"On \"Analysis Results\" Tab:"]
[null,null,"Check <Spectral residulas>"]
[null,null,"Click <Analyze>"]
[null,null,"Wait for analysis to complete"]
[null,null,"Click top left cell (above row numbers and left of column headings) to select all the output (i.e. predicted soil data)"]
[null,null,"Copy"]
[6,"In this workbook on \"Settings\" worksheet: "]
[null,null,"Fill in yellow cells"]
[7,"On \"OPUS Output\" worksheet: "]
[null,null,"Delete any existing data from row 2 down"]
[null,null,"Paste data from OPUS into Cell A1"]
[null,null,null,"NOTE: Column headings in row 1 should stay the same"]
[8,"On \"Predictions\" worksheet"]
[null,null,"Delete any existing data from row 5 down"]
[null,null,"Enter parameter names in row 1 replacing parameter names already shown"]
[null,null,null,"NOTE: Parameter names must me EXACTLY the same as the Method names in OPUS"]
[null,null,null,"NOTE: Order of parameter names must be the same as in OPUS"]
[null,null,"Enter Units in row 2, replacing units already shown"]
[null,null,null,"NOTE: Units must be EXACTLY the same as those in the OPUS Method"]
[null,null,"For each parameter enter in rows 3 and 4 the minimum and maximum values found in the laboratory data used for calibration"]
[null,null,"For particle size fractions use -9999 as the minimum and 9999 as the maximum"]
[null,null,"Click <Organize> button above"]
[null,null,null,"This will average the replicate predictions for each sample for each soil parameter"]
[null,null,null,null,"Excluding any predictions marked as \"Outliers\" by OPUS"]
[null,null,null,null,"If the number of valid predictions falls below \"QC_Threshold\" the average is rejected and marked \"No Data\""]
[null,null,null,"Check the averages against the range of values in the calibration samples"]
[null,null,null,null,"Any averages outside the range will be marked \"No data\""]
[null,null,null,"Insert the results on the \"Predictions\" sheet"]
[null,null,null,"Sort the data by Sample ID"]
[9,"Any predicted particle size data can be corrected so the total equals 100 as follows"]
[null,"On \"Predictions\" worksheet"]
[null,null,"Add 3 columns for corrected sand, silt and clay"]
[null,null,"Select the 3 cells in these columns in row 6"]
[null,null,"Enter the following formula:"]
[null,null,null,"=PSA_Correction(R6, S6, T6, NoData)"]
[null,null,null,"where, in this example, R6, S6 and T6 are the particle size fractions"]
[null,null,null,"When finished press <Ctrl><Shift><Enter> to enter the formula as an array calculation"]
[null,null,null,"The formula will enter the corrected particle size fractions in the three cells (in the same order as R6, S6, T6)"]
[null,null,"Copy the formula to the other rows in \"Predictions\""]

{"sheet":"Settings","index":1,"n_rows":15,"n_cols":41,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Settings for organizing OPUS Output"]
[]
["QC Threshold:",2,"(No. acceptable replicate predictions for mean to be acceptable)"]
["No data:",{"$f":"NA()","v":{"$error":"#N/A"}},"(How to mark cells with no data)"]
[]
[]
[]
["Parameter:","pH (H2O)","EC","OC","Olsen P","PBI","Exch Ca","Exch Mg","Exch K","Exch Na","Exch Acid","Sum Exch","ECEC","Base saturation","ESP","Ca:Mg","ECEC:Clay","Sand","Silt","Clay","Sand","Silt","Clay","Ln(Sand/Silt)","Ln(Clay/Silt)","Ln(Silt/Sand)","Ln(Clay/Sand)","Ln(Sand/Silt)","Ln(Clay/Silt)","Ln(OC)","Ln(PBI)","Sqrt(PBI)","Ln(Exch Ca)","Ln(Exch Mg)","Ln(Exch K)","Ln(Exch Na)","Ln (Sum Exch)","Ln(ECEC)","Ln(ESP)","Ln(Ca:Mg)","Ln(ECEC:Clay)"]
["Units:",{"$f":"IF(ISBLANK(B13),\" \",B13)","v":" "},{"$f":"IF(ISBLANK(C13),\" \",C13)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["Calibration minimum:"]
["Calibration maximum:"]
["Parameter:"]
["Units:"]
["Outliers, no."]
["Outlier sample IDs"]

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

{"sheet":"OPUS Output","index":3,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"File Name","Sample Name","Method","Component",true,"Prediction","Unit","Outside","Mah. Dist.","Limit","Outlier","Residual","F Value","F Prob","Component Value Density"]