{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Import","View","Data","Notes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Import","index":0,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["SLM Data import"]
[]
[]
[]
[]
[]
["How does this worksheet work?"]
["This worksheet allows you to import SLM (SPL) measurements stored on the Bedrock SMxx. Make sure that the SLM result files are copied onto your computer, or that the instrument is attached to USB and accessible as a mass storage device. Then press the button below (\"Import SLM\"). You can now select the measurement data files that you wish to import. NOTE: by using SHIFT and CTRL you can select multiple files for opening. The measurements are imported into the sheet named \"Data.\" Use the sheet named \"View\" to browse through these measurements, or copy data directly from the \"Data\" sheet to your own Worksheet for further calculations. Note that importing data changes this worksheet, overwriting earlier data imports. We recommend that you keep the original version of this worksheet in a safe location, and that you use a new copy of this original file for each new project."]
[]
["NOTE: if an underrange or overload condition occurred during a sound level measurement, a range warning is stored with the data. This worksheet will display results obtained from such measurements on a yellow background. "]
[]
["For support or to download the latest version of this file, please refer to our website"]
["www.bedrock-audio.com"]
[]
["Version 2.6.1"]
[]
[]
["COPYRIGHT (C) Bedrock Audio BV, 2021"]
["ALL RIGHTS RESERVED. This worksheet contains material protected under International and Federal Copyright Laws and Treaties. Any unauthorized use of this material is prohibited. No part of this worksheet may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage and retrieval system without express written permission from the author. "]
[" "]
["DISCLAIMER"]
["THIS DOCUMENT IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE"]

{"sheet":"View","index":1,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SLM measurement"]
[]
["Date",{"$f":"OFFSET(Data!B1,View!$B$39,0)","v":"2021-10-05"}]
["Time",{"$f":"OFFSET(Data!C1,View!$B$39,0)","v":"09:15:18"}]
["Location"]
[]
["Duration [s]",{"$f":"OFFSET(Data!D1,View!$B$39,0)","v":446.46399000000002}]
[]
[]
["LZeq",{"$f":"OFFSET(Data!Q1,View!$B$39,0)","v":76.057469999999995}]
["LAeq",{"$f":"OFFSET(Data!E1,View!$B$39,0)","v":71.333629999999999}]
["LCeq",{"$f":"OFFSET(Data!K1,View!$B$39,0)","v":75.825810000000004}]
[]
["LZfmax",{"$f":"OFFSET(Data!R1,View!$B$39,0)","v":91.023319999999998}]
["LAfmax",{"$f":"OFFSET(Data!F1,View!$B$39,0)","v":88.830860000000001}]
["LCfmax",{"$f":"OFFSET(Data!L1,View!$B$39,0)","v":91.036689999999993}]
[]
["LZsmax",{"$f":"OFFSET(Data!S1,View!$B$39,0)","v":86.901120000000006}]
["LAsmax",{"$f":"OFFSET(Data!G1,View!$B$39,0)","v":84.164169999999999}]
["LCsmax",{"$f":"OFFSET(Data!M1,View!$B$39,0)","v":86.891009999999994}]
[]
["LZimax",{"$f":"OFFSET(Data!T1,View!$B$39,0)","v":92.74915}]
["LAimax",{"$f":"OFFSET(Data!H1,View!$B$39,0)","v":90.844220000000007}]
["LCimax",{"$f":"OFFSET(Data!N1,View!$B$39,0)","v":92.767070000000004}]
[]
["LZpeak",{"$f":"OFFSET(Data!U1,View!$B$39,0)","v":105.58517000000001}]
["LApeak",{"$f":"OFFSET(Data!I1,View!$B$39,0)","v":106.19161}]
["LCpeak",{"$f":"OFFSET(Data!O1,View!$B$39,0)","v":105.38068}]
[]
["LZsel",{"$f":"OFFSET(Data!V1,View!$B$39,0)","v":102.55534}]
["LAsel",{"$f":"OFFSET(Data!J1,View!$B$39,0)","v":97.831509999999994}]
["LCsel",{"$f":"OFFSET(Data!P1,View!$B$39,0)","v":102.32368}]
[]
[null,"A yellow background in the cells above indicate a range warning"]
[]
[]
[]
["Filename",{"$f":"OFFSET(Data!A1,View!$B$39,0)","v":"MEAS0001"}]
["Index",1]
["Note",{"$f":"OFFSET(Notes!B1,View!$B$39,0)&\"\"","v":""}]
[]
[]
[]
[]
["Warn Z",{"$f":"IF(OFFSET(Data!AA1,View!$B$39,0)<>\"\",OFFSET(Data!AA1,View!$B$39,0),View!B$46)","v":"N"},{"$f":"IF(OFFSET(Data!AB1,View!$B$39,0)<>\"\",OFFSET(Data!AB1,View!$B$39,0),View!C$46)","v":"N"}]
["Warn A",{"$f":"OFFSET(Data!W1,View!$B$39,0)","v":"N"},{"$f":"OFFSET(Data!X1,View!$B$39,0)","v":"N"}]
["Warn C",{"$f":"IF(OFFSET(Data!Y1,View!$B$39,0)<>\"\",OFFSET(Data!Y1,View!$B$39,0),View!B$46)","v":"N"},{"$f":"IF(OFFSET(Data!Z1,View!$B$39,0)<>\"\",OFFSET(Data!Z1,View!$B$39,0),View!C$46)","v":"N"}]

{"sheet":"Data","index":2,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"date","time","duration","LAeq","LAfmax","LAsmax","LAimax","LApeak","LAsel","LCeq","LCfmax","LCsmax","LCimax","LCpeak","LCsel","LZeq","LZfmax","LZsmax","LZimax","LZpeak","LZsel","RangeWarningA","RangeWarningAMax","RangeWarningC","RangeWarningCMax","RangeWarningZ","RangeWarningZMax"]
["MEAS0001","2021-10-05","09:15:18",446.46399000000002,71.333629999999999,88.830860000000001,84.164169999999999,90.844220000000007,106.19161,97.831509999999994,75.825810000000004,91.036689999999993,86.891009999999994,92.767070000000004,105.38068,102.32368,76.057469999999995,91.023319999999998,86.901120000000006,92.74915,105.58517000000001,102.55534,"N","N","N","N","N","N"]

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