{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Haystack","about","ops","formats","read","hisRead"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Haystack","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Paramètres"]
[]
["HaystackAPI","http://10.0.2.2:3000/haystack"]

{"sheet":"about","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["serverName","haystackVersion","productName","productVersion","tz","serverTime","serverBootTime","productUri"]
["haystack_us-east-2",3,"AWS Lambda Haystack Provider",1,"Europe/Paris","2021-01-04T16:22:02+01:00","2021-01-04T16:22:02+01:00","`https://10.0.2.2:3000/dev`"]

{"sheet":"ops","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["name","summary"]
["about","Summary information for server"]
["ops","Operations supported by this server"]
["formats","Grid data formats supported by this server"]
["read","The read op is used to read a set of entity records either by their unique identifier or using a filter."]
["hisRead","The his_read op is used to read a time-series data from historized point."]

{"sheet":"formats","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["mime","receive","send"]
["text/zinc","✓","✓"]
["application/json","✓","✓"]
["text/csv","✓","✓"]

{"sheet":"read","index":4,"n_rows":11,"n_cols":68,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,4]]}
[]
[]
["Filter",null,"his"]
["Limit",null,5]
[]
["id","air","phone","sensor","occupied","store","damper","enum","temp","tz","tariffHis","sp","area","site","weatherRef","elecCost","hisMode","kwSite","summary","fan","siteRef","primaryFunction","kind","cmd","geoCountry","elec","lights","geoStreet","occupiedEnd","yearBuilt","siteMeter","geoCoord","regionRef","occupiedStart","effective","equip","sitePoint","cool","ahu","hvac","costPerHour","unit","lightsGroup","discharge","zone","power","geoCity","rooftop","navName","outside","point","dis","energy","elecMeterLoad","geoAddr","cur","geoState","geoPostalCode","equipRef","meter","pressure","heat","return","storeNum","his","metro","stage","hisURI"]
["@p:demo:r:23a44701-bbc36976 Tariff His","","","","","","","","","New_York","✓","✓","","","","","","","","","@p:demo:r:23a44701-a89a6c66 Carytown","","Str","","","","","",null,"","","","",null,"","","","","","","","","","","","","","","","","✓","Tariff His","","","","","",null,"@p:demo:r:23a44701-092f16fa Carytown ElecMeter-Main","","","","","","✓","","","p:demo:r:23a44701-bbc36976.zinc"]
["@p:demo:r:23a44701-4ea35663 Carytown RTU-1 ZoneTempSp","✓","","","","","","","✓","New_York","","✓","","","","","cov","","","","@p:demo:r:23a44701-a89a6c66 Carytown","","Number","","","","","",null,"","","","@p:demo:r:23a44701-67faf4db Richmond",null,"✓","","","","","","","\\u00b0F","","","✓","","","","ZoneTempSp","","✓","","","","","✓","",null,"@p:demo:r:23a44701-7265b064 Carytown RTU-1","","","","","","✓","","","p:demo:r:23a44701-4ea35663.zinc"]
["@p:demo:r:23a44701-3940e690 Carytown ElecMeter-Main kW","","","✓","","","","","","New_York","","","","","","","sampled","✓","","","@p:demo:r:23a44701-a89a6c66 Carytown","","Number","","","","","",null,"","✓","","@p:demo:r:23a44701-67faf4db Richmond",null,"","","","","","","","kW","","","","✓","","","kW","","✓","","","","","✓","",null,"@p:demo:r:23a44701-092f16fa Carytown ElecMeter-Main","","","","","","✓","","","p:demo:r:23a44701-3940e690.zinc"]
["@p:demo:r:23a44701-27a8a001 Carytown RTU-1 ZoneTemp","✓","","✓","","","","","✓","New_York","","","","","","","sampled","","✓","","@p:demo:r:23a44701-a89a6c66 Carytown","","Number","","","","","",null,"","","","@p:demo:r:23a44701-67faf4db Richmond",null,"","","","","","","","\\u00b0F","","","✓","","","","ZoneTemp","","✓","","","","","✓","",null,"@p:demo:r:23a44701-7265b064 Carytown RTU-1","","","","","","✓","","","p:demo:r:23a44701-27a8a001.zinc"]
["@p:demo:r:23a44701-423ebf02 Carytown RTU-1 DischargeTemp","✓","","✓","","","","","✓","New_York","","","","","","","sampled","","","","@p:demo:r:23a44701-a89a6c66 Carytown","","Number","","","","","",null,"","","","@p:demo:r:23a44701-67faf4db Richmond",null,"","","","","","","","\\u00b0F","","✓","","","","","DischargeTemp","","✓","","","","","✓","",null,"@p:demo:r:23a44701-7265b064 Carytown RTU-1","","","","","","✓","","","p:demo:r:23a44701-423ebf02.zinc"]

{"sheet":"hisRead","index":5,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Entity",null,{"$f":"LEFT(read!A7,SEARCH(\" \",read!A7)-1)","v":"@p:demo:r:23a44701-bbc36976"}]
["Range",null,"today"]
[]
[]
["ts","val"]
["2020-02-01T01:00:00",740]
["2020-03-01T01:00:00",720]
["2020-04-01T02:00:00",680]
["2020-05-01T02:00:00",650]
["2020-06-01T02:00:00",620]
["2020-07-01T02:00:00",660]
["2020-08-01T02:00:00",620]
["2020-09-01T02:00:00",630]
["2020-10-01T02:00:00",600]
["2020-11-01T01:00:00",630]
["2020-12-01T01:00:00",670]
["2021-01-01T01:00:00",710]