{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tex-148-E","SOC% vs Absorbance","RX"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":56,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"SOC% vs Absorbance","index":1,"reason":"not_a_worksheet"}],"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":"Tex-148-E","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,4,6,5],[6,8,6,11],[7,4,7,5],[7,8,7,11],[20,5,21,5],[17,6,17,7],[12,4,12,5],[13,4,13,11],[14,4,14,11],[15,4,15,5],[15,8,15,11],[9,4,9,5],[9,8,9,11],[10,4,10,5],[10,8,10,11],[12,8,12,11],[22,1,22,2],[23,1,23,2],[11,4,11,5],[11,8,11,11],[8,4,8,5],[8,8,8,11],[20,1,20,2],[21,1,21,2],[29,1,29,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[49,1,49,2],[51,1,51,4],[47,1,47,4],[30,1,30,2],[43,3,43,5],[44,3,44,5],[38,1,39,11],[47,7,47,11],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[31,1,31,2],[41,3,41,5],[42,3,42,5]]}
["TxDOT Manuals >"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,"UPLC:",14,{"$f":"TODAY()","v":"2024-07-29"}]
[null,"SOIL ORGANIC CONTENT USING UV-VIS METHOD",null,null,null,null,null,null,null,null,null,null,null,"DLT:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SN:","tx148.xlsm::45502.574063"]
[null,"Tex-148-E"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"File Version: 07/29/24 13:46:39"}]
[null,null,null,"SAMPLE ID:",null,null,null,"SAMPLED DATE:"]
[null,null,null,"TEST NUMBER:",null,null,null,"LETTING DATE:"]
[null,null,null,"SAMPLE STATUS:",null,null,null,"CONTROLLING CSJ:"]
[null,null,null,"COUNTY:",null,null,null,"SPEC YEAR:"]
[null,null,null,"SAMPLED BY:",null,null,null,"SPEC ITEM:"]
[null,null,null,"SAMPLE LOCATION:",null,null,null,"SPECIAL PROVISION:"]
[null,null,null,"MATERIAL CODE:",null,null,null,"TYPE:"]
[null,null,null,"MATERIAL NAME:"]
[null,null,null,"PRODUCER:"]
[null,null,null,"AREA ENGINEER:",null,null,null,"PROJECT MANAGER:"]
[]
[null,null,null,"COURSE\\LIFT:",null,"STATION:",null,null,null,null,"DIST. FROM CL:"]
[]
[]
[null,"Sample ID",null,"Absorbance\n(y-values)","SOC%\n(x-values)"]
[null,"Blank",null,null,0]
[null,5.0000000000000001E-3,null,null,0.5]
[null,0.01,null,null,1]
[null,1.4999999999999999E-2,null,null,1.5]
[null,"Test Sample 1",null,null,{"$f":"IFERROR((D26-$D$34)/$D$33,\"\")","v":""}]
[null,"Test Sample 2",null,null,{"$f":"IFERROR((D27-$D$34)/$D$33,\"\")","v":""}]
[null,"Test Sample 3",null,null,{"$f":"IFERROR((D28-$D$34)/$D$33,\"\")","v":""}]
[]
[null,"R2 Value:",null,{"$f":"IFERROR(RSQ($D$22:$D$25,$E$22:$E$25),\"\")","v":""}]
[null,"SOC%:",null,{"$f":"IFERROR(($D$32-$D$34)/$D$33,\"\")","v":""}]
[null,"Avg. Absorbance:",null,{"$f":"IFERROR(AVERAGE($D$26:$D$28),\"\")","v":""}]
[null,"Slope:",null,{"$f":"IFERROR(LINEST($D$22:$D$25,$E$22:$E$25,TRUE,TRUE),\"\")","v":""}]
[null,"Y-Intercept:",null,{"$f":"IFERROR(AVERAGE($D$22:$D$25)-$D$33*AVERAGE($E$22:$E$25),\"\")","v":""}]
[null,"S. Dev.:",null,{"$f":"IFERROR(_xlfn.STDEV.S($E$26:$E$28),\"\")","v":""}]
[null,"Cv (%):",null,{"$f":"IFERROR(($D$35/$D$31)*100,\"\")","v":""}]
[]
[null,"Remarks:"]
[]
[]
[]
[null,null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,null,"TX100"]
[null,null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,null,"TX148"]
[]
[null,"Test Stamp Code:",null,null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:",null,"TxDOT:","District:","Area:"]
[]
[null,"Authorized By:",null,null,null,"Authorized Date:"]

{"sheet":"RX","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNTA(A3:A9090)","v":25}]
["Fld_nbr","Value","DESC_1","DESC_2","DESC_3","DESC_4","DESC_5","DESC_6","DESC_7"]
[1,{"$f":"IF(ISBLANK(Field1),\"\",Field1)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B38","v":"Remarks:"}]
[2,{"$f":"IF(ISBLANK(CourseLift),\"\",CourseLift)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D18","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF(ISBLANK(testperson1),\"\",testperson1)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D44","v":"Tested By:"},{"$f":"test1","v":"TX148"}]
[4,{"$f":"IF(ISBLANK(testdate1),\"\",testdate1)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!G44","v":"Tested Date:"},{"$f":"test1","v":"TX148"}]
[5,{"$f":"IF(ISBLANK('Tex-148-E'!D22),\"\",'Tex-148-E'!D22)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B22","v":"Blank"}]
[6,{"$f":"IF(ISBLANK('Tex-148-E'!D23),\"\",'Tex-148-E'!D23)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B23","v":5.0000000000000001E-3}]
[7,{"$f":"IF(ISBLANK('Tex-148-E'!D24),\"\",'Tex-148-E'!D24)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B24","v":0.01}]
[8,{"$f":"IF(ISBLANK('Tex-148-E'!D25),\"\",'Tex-148-E'!D25)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B25","v":1.4999999999999999E-2}]
[9,{"$f":"IF(ISBLANK('Tex-148-E'!D26),\"\",'Tex-148-E'!D26)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B26","v":"Test Sample 1"}]
[10,{"$f":"IF(ISBLANK('Tex-148-E'!D27),\"\",'Tex-148-E'!D27)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B27","v":"Test Sample 2"}]
[11,{"$f":"IF(ISBLANK('Tex-148-E'!D28),\"\",'Tex-148-E'!D28)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!D21","v":"Absorbance\n(y-values)"},{"$f":"'Tex-148-E'!B28","v":"Test Sample 3"}]
[12,{"$f":"IF(ISBLANK('Tex-148-E'!E22),\"\",'Tex-148-E'!E22)","v":0},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B22","v":"Blank"}]
[13,{"$f":"IF(ISBLANK('Tex-148-E'!E23),\"\",'Tex-148-E'!E23)","v":0.5},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B23","v":5.0000000000000001E-3}]
[14,{"$f":"IF(ISBLANK('Tex-148-E'!E24),\"\",'Tex-148-E'!E24)","v":1},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B24","v":0.01}]
[15,{"$f":"IF(ISBLANK('Tex-148-E'!E25),\"\",'Tex-148-E'!E25)","v":1.5},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B25","v":1.4999999999999999E-2}]
[16,{"$f":"IF(ISBLANK('Tex-148-E'!E26),\"\",'Tex-148-E'!E26)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B26","v":"Test Sample 1"}]
[17,{"$f":"IF(ISBLANK('Tex-148-E'!E27),\"\",'Tex-148-E'!E27)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B27","v":"Test Sample 2"}]
[18,{"$f":"IF(ISBLANK('Tex-148-E'!E28),\"\",'Tex-148-E'!E28)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!E21","v":"SOC%\n(x-values)"},{"$f":"'Tex-148-E'!B28","v":"Test Sample 3"}]
[19,{"$f":"IF(ISBLANK('Tex-148-E'!D32),\"\",'Tex-148-E'!D32)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B32","v":"Avg. Absorbance:"}]
[20,{"$f":"IF(ISBLANK('Tex-148-E'!D33),\"\",'Tex-148-E'!D33)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B33","v":"Slope:"}]
[21,{"$f":"IF(ISBLANK('Tex-148-E'!D34),\"\",'Tex-148-E'!D34)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B34","v":"Y-Intercept:"}]
[22,{"$f":"IF(ISBLANK('Tex-148-E'!D35),\"\",'Tex-148-E'!D35)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B35","v":"S. Dev.:"}]
[23,{"$f":"IF(ISBLANK('Tex-148-E'!D36),\"\",'Tex-148-E'!D36)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B36","v":"Cv (%):"}]
[24,{"$f":"IF(ISBLANK('Tex-148-E'!D30),\"\",'Tex-148-E'!D30)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B30","v":"R2 Value:"}]
[25,{"$f":"IF(ISBLANK('Tex-148-E'!D31),\"\",'Tex-148-E'!D31)","v":""},{"$f":"'Tex-148-E'!$B$5","v":"Tex-148-E"},{"$f":"'Tex-148-E'!B31","v":"SOC%:"}]