{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"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":"Sheet1","index":0,"n_rows":86,"n_cols":17,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,"Iterative peak fitting using Solver (2 component solution)"]
[null,"Type or paste your data into columns A and B, rows 22-122."]
[null,"Type your first guesses for peak positions and widths in the Proposed model table."]
[null,"Click Data, click Solver, enter C12 into \"Set Objective\", click \"min\", then select the cells"]
[null,"in this table that you want to optimize, add any constraints, then click the Solve button."]
[null,"Proposed model with 2 components (Gaussian bands)"]
[null,null,"Component 1","Component 2"]
[null,"Position",null,null," "," ",0]
[null,"Width",null,null," "," ",0]
[]
[null,"n=",{"$f":"COUNT(A22:A86)","v":0},"Adjusted R2=",{"$f":"E12-(1-E12)*(N25/(C11-N25-1))","v":{"$error":"#VALUE!"}}]
[null,"% fitting error",{"$f":"STDEV(J22:J121)/MAX(I22:I121)","v":{"$error":"#VALUE!"}},"R2=",{"$f":"M24","v":{"$error":"#VALUE!"}}]
[null,"Calculated peak amplitudes"]
[null,null,"Component 1","Component 2"]
[null,"Amplitude",{"$f":"N22","v":{"$error":"#VALUE!"}},{"$f":"M22","v":{"$error":"#VALUE!"}},0]
[null,"Standard error",{"$f":"N28","v":{"$error":"#VALUE!"}},{"$f":"M28","v":{"$error":"#VALUE!"}}]
[null,null," "]
[null,null,"For help, see http://www.solver.com/excel-solver-help"]
[null,null,"© Tom O'Haver, 2013, 2014"]
["Type or paste your data below",null,"Unit spectra of the pure components normalized to 1.0",null,null,"Unit spectra x Amplitudes (B6:F6)",null,null,{"$f":"MAX(I22:I101)","v":{"$error":"#VALUE!"}},null,null,null,"Amplitude calculation using LINEST function: \"=LINEST(B22:B86,C22:D86,FALSE,TRUE)\""]
["X","Y","Component 1","Component 2","Component 3","Component 1","Component 2","Component 3","Mixture","Residuals"," ",null,"Component 2","Component 1",null," "," "]
[null,null,{"$f":"EXP(-1*(($A22-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$f":"C$15*C22","v":{"$error":"#VALUE!"}},{"$f":"D$15*D22","v":{"$error":"#VALUE!"}},{"$f":"E$15*E22","v":0},{"$f":"SUM(F22:H22)","v":{"$error":"#VALUE!"}},{"$f":"B22-I22","v":{"$error":"#VALUE!"}},null,null,{"$f":"LINEST(B22:B86,C22:D86,FALSE,TRUE)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Relative percent standard errors of each component (mirrored in cells B17-F17)"]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$f":"M23/M22","v":{"$error":"#VALUE!"}},{"$f":"N23/N22","v":{"$error":"#VALUE!"}},{"$f":"O23/O22","v":{"$error":"#VALUE!"}},{"$f":"P23/P22","v":{"$error":"#VALUE!"}},{"$f":"Q23/Q22","v":{"$error":"#VALUE!"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$f":"#REF!-M22","v":{"$error":"#REF!"}},{"$f":"#REF!-N22","v":{"$error":"#REF!"}},{"$f":"E15-O22","v":{"$error":"#VALUE!"}},{"$f":"#REF!-P22","v":{"$error":"#REF!"}},{"$f":"C15-Q22","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"EXP(-1*(($A32-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"EXP(-1*(($A42-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"EXP(-1*(($A52-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$f":"C$15*C54","v":{"$error":"#VALUE!"}},{"$f":"D$15*D54","v":{"$error":"#VALUE!"}},{"$f":"E$15*E54","v":0},{"$f":"SUM(F54:H54)","v":{"$error":"#VALUE!"}},{"$f":"B54-I54","v":{"$error":"#VALUE!"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"EXP(-1*(($A62-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"EXP(-1*(($A72-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"EXP(-1*(($A82-C$8)/(0.6006*C$9))^2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"0","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$f":"SUM(F86:H86)","v":{"$error":"#VALUE!"}},{"$f":"B86-I86","v":{"$error":"#VALUE!"}}]