{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Lighting","Smart_Plugs","Garage","Switches","Irrigation","DATA"],"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":"Lighting","index":0,"n_rows":9,"n_cols":21,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,3],[3,2,3,3],[4,2,4,3],[6,2,6,4]]}
[null,null,null,null,null,null,null,null,null,"YES","L",1,"LG","S","L",1,"LG","DOWNLIGHT WHITE","L",1,"LG"]
[null,null,"Pre-Configured Form for Home Automation",null,null,null,null,null,null,"NO","L",1,null,null,"L",1,null,"DOWNLIGHT BLACK","L",1]
[null,null,"Company Name",null,"Enter Text",null,null,null,null,"PL",1,3,null,null,1,3,null,"DOWNLIGHT SILVER",1,3]
[null,null,"Purchase Order Number",null,"Enter Text",null,null,null,null,"GROUP ID",1,null,"iLIGHT",null,1,null,"iLIGHT","SCREW IN BULB",1,null,"iLIGHT"]
[null,null,"Client's Name",null,"Enter Text",null,null,null,null,"P",1,null,null,null,1,null,null,"BAYONET BULB",1]
[null,null,null,null,null,null,null,null,null,"GR",1,null,"BLANK","BLANK",1,null,"BLANK",null,1,null,"BLANK"]
[null,null,"Group and Lighting Information",null,null,null,null,null,null,"1 BUTTON","WHITE","ALL ON","ALL ON","AC","WHITE","ALL ON","ALL ON",null,"WHITE","ALL ON","ALL ON"]
[null,null,"Total number of Groups","[ Max 128 ]",{"$f":"DATA!I5 -3","v":0},null,null,"LIGHT SETUP",null,"2 BUTTON","OCEAN","ALL OFF","ALL OFF","AC ZONE","OCEAN","ALL OFF","ALL OFF",null,"OCEAN","ALL OFF","ALL OFF"]
[null,null,"Total number of Lights","[ Auto Calculates ]",{"$f":"SUM(E12:U13)","v":0},"OFFSET","CLEAR STOP","OFFSET","OFFSET","3 BUTTON","BLACK","GROUP","LIGHT",null,"BLACK","GROUP","LIGHT",null,"BLACK","GROUP","LIGHT"]

{"sheet":"Smart_Plugs","index":1,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,2,6,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL ON + ALL OFF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL ON ONLY"]
[null,null,"Smart Plug Information",null,null,null,null,null,null,null,null,null,null,null,null,"ALL OFF ONLY"]
[null,null,"Total number of Plugs","[ Auto Generates ]",{"$f":"DATA!K3 -1","v":0},null,null,null,null,null,null,null,null,null,null,"NO ACTION"]
[null,"a","Space"]

{"sheet":"Garage","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Garage Door Information"]
[null,"DO","Number of Garage Doors","[ Auto Generates ]",{"$f":"DATA!K6 - 1","v":0}]
[null,"DO","Space"]

{"sheet":"Switches","index":3,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["No Group"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"iLIGHT","iZONE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"BLANK",null,"BLANK"]
[null,null,null,"Switch Information",null,null,null,null,null,"1 BUTTON","WHITE","ALL ON","ALL ON","AC ON/OFF","AC"]
[null,null,"Total number of Switches","[ Auto Generates ]",{"$f":"DATA!P1 -1","v":0},null,null,null,null,"2 BUTTON","OCEAN","ALL OFF","ALL OFF","ZONE","ZONE_"]
[null,"i","space",null,null,"DO",null,null,null,"3 BUTTON","BLACK","GROUP","LIGHT"]

{"sheet":"Irrigation","index":4,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[57,8,57,9],[41,8,41,9],[49,8,49,9],[4,8,4,9]]}
[null,null,null,null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,null,null,"NO"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM"]
[null,null,null,"Irrigation Information"]
[null,null,"Total number of Stations","[Min 1 - Max 24]",{"$f":"DATA!Q3","v":0}]
[null,null,"Total number of Programs","[Min 1 - Max 9]",{"$f":"DATA!K5 -1","v":0},"DO"]

{"sheet":"DATA","index":5,"n_rows":52,"n_cols":28,"rows_kept":52,"cut":false,"hidden":true,"merged":[[37,23,37,24]]}
[null,null,null,null,null,"Individual Light Setup",null,null,"GO","YES","L",1,"LG",1,"S",1,0,"DOWNLIGHT WHITE",{"$f":"Lighting!E12","v":0},{"$f":"Lighting!E18","v":0}]
[null,"Number of Lights","[ Enter Number ]","Enter Amount",null,"Name for iLight 1","[ Auto Generates ]","Lounge1","i","NO","L",1,"MASTER GROUP",{"$f":"(K3+K4+K6) -3","v":0},null,1,null,"DOWNLIGHT BLACK"]
[null,"Light type","[ Choice ]","Drop Down List",null,"iLight Device ID","[ Auto Generates ]","L1",null,"PL",1,1,null,null,null,"ST",0,"DOWNLIGHT SILVER"]
["OFFSET","Page \\ Location","[ Max 12 Pages ]","Enter Number",null,"Type","[ Choice ]","Drop Down List","ALL","GROUP ID",1,1,"iLIGHT","iLIGHT","iZONE",null,null,"SCREW IN BULB"]
["OFFSET","Light Device ID","[ Auto Generates ]","L1",null,"Page \\ Location","[Max 12 Locations]","Page 1 / Ground Floor",{"$f":"SUM(K3,K4,K6)","v":3},"P",1,2,null,null,null,"ALL ON + ALL OFF","AM","BAYONET BULB"]
["OFFSET","Name of Page","[ Enter Text ]","Enter Page Name",null,"Group ID","[ Auto / Text ]","LG1",null,"GR",1,null,"BLANK",null,"BLANK","ALL ON ONLY","PM"]
[null,null,null,null,null,null,null,null,null,"1 BUTTON","WHITE","ALL ON","ALL ON","AC ON/OFF","AC","ALL OFF ONLY"]
[null,null,null,null,null,null,null,null,null,"2 BUTTON","OCEAN","ALL OFF","ALL OFF","ZONE","AC ZONE","NO ACTION"]
[null,null,null,null,null,null,null,null,null,"3 BUTTON","BLACK","GROUP","LIGHT"]
[]
[null,null,1]
[null,"Group \\ Room Name","[ Enter Text ]","Enter Name"]
[null,"Number of Lights","[ Enter Number ]","Enter Amount"]
[null,"Light type","[ Choice ]","Drop Down List"]
[null,"Page \\ Location","[ Max 12 Pages ]","Enter Number"]
[null,"OFFSET",null,"OFFSET"]
[]
[null,null,0,null,null,null,null,null,null,"Button 1  Setup ",null,null,null,"Button 2 Setup ",null,null,null,"Button 3 Setup "]
[null,"Location","[ Enter Text ]","Enter Room Name",null,null,null,null,null,"Button 1 Type","[ Choice ]","Drop Down List",null,"Button 2 Type","[ Choice ]","Drop Down List",null,"Button 3 Type","[ Choice ]","Drop Down List"]
[null,"Number of Buttons","[ Choice ]","Drop Down List",null,null,null,null,null,"Button 1 Action","[ Choice ]","Drop Down List",null,"Button 2 Action","[ Choice ]","Drop Down List",null,"Button 3 Action","[ Choice ]","Drop Down List"]
[null,"Facia Colour","[ Choice ]","Drop Down List",null,null,null,null,null,"Button 1 Label","[ Choice ]","Drop Down List",null,"Button 2 Label","[ Choice ]","Drop Down List",null,"Button 3 Label","[ Choice ]","Drop Down List"]
[null,"Occupancy Group","[ Match to Group ]","LG*",null,null,null,null,null,"Group Number","[Match to Group]","LG*",null,"Group Number","[Match to Group]","LG*",null,"Zone Number","[Min 1 - Max 14]","Zone"]
["OFFSET","Light Sensor Group","[ Match to Group ]","LG*"]
[null,"Device ID","[ Auto Generate ]","S1"]
[]
[]
[null,null,0]
[null,"Group \\ Room Name","[ Enter Text ]","Enter Name"]
[null,"Device Name ","[ Enter Text ]","Enter Device Name"]
[null,"Control Type","[ Choice ]","Drop Down List"]
["OFFSET","Page \\ Location","[ Max 12 Pages ]","Enter Number"]
[null,"Group","[ Auto Fill / Manual ]","LG*"]
[null,"Device ID","[ Auto Generates ]","L3"]
[]
[]
[null,"Name of Station ","[ Enter Text ]","Enter Station Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program",null,"Right Click to Select Day - Double Left Click to Reset"]
["OFFSET","Soak and Cycle","[ Choice ]","Drop Down List",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUN","MON","TUE","WED","THU","FRI","SAT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Name","[ Text ]","Enter Program Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Start Time","[ Choice ]","AM/PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",null,"[ Choice ]","1 - 12"]
[null,"Group \\ Device Name ","[ Enter Text ]","Enter Group Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"," Duration for",null,null,"[ Hours ]","0 - 3","[ Minutes ]","0 - 59"]
["OFFSET","Page \\ Location","[ Max 12 Pages ]","Enter Number"]
[null,"Device ID","[ Auto Generates ]","L4"]
[null,"Reed Switch ID","[ Auto Generates ]","S1"]
[null,"Group","[ Auto Generates ]","LG*"]
[]
[]
[null,null,"Setup for Irrigation"]
[null,"Number of Soaks","[ Min 0 - Max 15 ]","Enter Number"]
[null,"Soak Pause Time","[Min 1 - Max 240]","Enter Number"]
[null,"Test Run Time","[Min 1 - Max 240]","Enter Number"]
["OFFSET","Max Manual Run Time","[Min 1 - Max 240]","Enter Number"]