{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["README","REV","RSS","Linear Interpolation","Grms"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"README","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
["Return to TOC"]
[]
["www.rouloconsulting.com"]
[]
[]
[]
[]
[]
[null,"Table of Contents"]
[null,"WorkSheet","Description"]
[null,"README","This worksheet describing the document and the Table of Contents (TOC)"]
[null,"REV","Revision Information"]
[null,"RSS","Root Sum of the Squares VBA Example"]
[null,"Linear Interpolation","Linear Interpolation VBA Example"]
[null,"Grms","Computing Grms with Steinberg Method"]

{"sheet":"REV","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Return to TOC"]
[]
["www.rouloconsulting.com"]
[]
[]
[]
[]
[]
[]
["Filename","Date","Rev","Author","Notes"]
["RCI_VBAexcel_20170518.xlsm","2017-05-18","-","Eric J. Roulo","Initial Release"]

{"sheet":"RSS","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Return to TOC"]
[]
["www.rouloconsulting.com"]
[]
[]
[]
[]
[]
[]
[null,"20 Random Numbers"]
[null,84]
[null,28]
[null,2]
[null,-94]
[null,-3]
[null,-64]
[null,74]
[null,38]
[null,81]
[null,-47]
[null,3]
[null,-55]
[null,-88]
[null,-46]
[null,16]
[null,56]
[null,-92]
[null,-87]
[null,96]
[null,93]
[]
["min",{"$f":"MIN(B11:B30)","v":-94}]
["max",{"$f":"MAX(B11:B30)","v":96}]
["avg",{"$f":"AVERAGE(B11:B30)","v":-0.25}]
["stdev",{"$f":"STDEV(B11:B30)","v":67.534688942248906}]
["rss (excel)",{"$f":"SQRT(SUMSQ(B11:B30))","v":294.37900740372095},"SQRT(SUMSQ(A11:A30))","all native excel"]
["rss (VBA)",{"$f":"rss(B11:B30)","v":294.37900740372095},"RSS(A11:A30)","uses VBA to call one excel function and one internal VBA function"]

{"sheet":"Linear Interpolation","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
["Return to TOC"]
[]
["www.rouloconsulting.com"]
[]
[]
[]
[]
[]
[null,"6061T6 Aluminum"]
[null,"Stress [psi]","Strain [in/in]"]
[null,0,0]
[null,35000,{"$f":"B12/(10*10^6)","v":3.5000000000000001E-3}]
[null,42000,0.1]
[]
[]
["Lookup Stress",37000,{"$f":"LInterpolateVLOOKUP(B16,$B$11:$C$13,2)","v":3.1071428571428573E-2},"LInterpolateVLOOKUP(B16,$B$11:$C$13,2)"]
[]
["Lookup Stress",0,{"$f":"LInterpolateVLOOKUP(B18,$B$11:$C$13,2)","v":0}]
["Lookup Stress",35000,3.5000000000000001E-3]
["Lookup Stress",42000,0.1]

{"sheet":"Grms","index":4,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Return to TOC"]
[]
["www.rouloconsulting.com"]
[]
[]
[]
[]
[]
[]
["Frequency","PSD","Slope","Cum RMS"]
["[Hz.]","[g2/Hz.]","[dB/octave]","[g]"]
[20,0.01]
[80,0.04,{"$f":"dbslope(A12:B13)","v":3.0102999566398116},{"$f":"grms($A$12:B13)","v":1.2238886542871954},"grms($A$12:B13)"]
[500,0.04,{"$f":"dbslope(A13:B14)","v":0},{"$f":"grms($A$12:B14)","v":4.2776048716650914},"grms($A$12:B14)"]
[2000,0.01,{"$f":"dbslope(A14:B15)","v":-3.0102999566398116},{"$f":"grms($A$12:B15)","v":6.7889525998969971},"grms($A$12:B15)"]
["overall grms",{"$f":"grms(A12:B15)","v":6.7889525998969971}]
[]
[]
["Frequency","Break Pt","PSD","Slope","Cum RMS"]
["[Hz.]","#","[g2/Hz.]","[dB/octave]","[g]"]
[20,1,0.01]
[80,2,0.04,{"$f":"dbslope(A21:C22,3)","v":3.0102999566398116},{"$f":"grms($A$21:C22,3)","v":1.2238886542871954},"grms($A$21:C22,3)"]
[500,3,0.04,{"$f":"dbslope(A22:C23,3)","v":0},{"$f":"grms($A$21:C23,3)","v":4.2776048716650914},"grms($A$21:C23,3)"]
[2000,4,0.01,{"$f":"dbslope(A23:C24,3)","v":-3.0102999566398116},{"$f":"grms($A$21:C24,3)","v":6.7889525998969971},"grms($A$21:C24,3)"]
[]
["overall grms",null,{"$f":"grms(A21:C24,3)","v":6.7889525998969971}]