{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Category 2 Internal Connections","Recipients of Service","List of Errors","Flag","Dropdown","Performance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"Category 2 Internal Connections","index":0,"n_rows":8,"n_cols":23,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,8,1,13],[1,14,1,15],[1,16,1,20],[1,0,1,7],[1,21,1,22]]}
["Category Two - Internal Connections - Version 19.0"]
[null,null,null,null,null,null,null,null,"Identify the Monthly Costs",null,null,null,null,null,null,null,"Identify the One-time Costs"]
["Reference Number","Type of Internal Connection","Installation Included in Price?","Type of Product","Make","Enter the Make (If Other)","Model","Lease or Non-Purchase Agreement?","Monthly Recurring Unit Costs","Monthly Recurring Unit Ineligible Costs","Estimated Monthly Recurring Unit Eligible Costs","Monthly Quantity","Units","Estimated Total Monthly Eligible Recurring Costs","Estimated Months of Service","Estimated Total Eligible Recurring Costs","One-time Unit Costs","One-time Unit Ineligible Costs","Estimated One-time Unit Eligible Costs","One-time Quantity","Estimated Total Eligible One-time Costs","Estimated Pre-Discount Extended Eligible Line Item Costs","Do any of these conditions apply?"]
["For Reference only - Not Imported","Required","Required","Required","Required","Required if \"Other\" is selected as Make ","Required","Required","Required","Required","For Reference only - Not Imported","Required","Required","For Reference only - Not Imported","Required","For Reference only - Not Imported","Required","Required","For Reference only - Not Imported","Required","For Reference only - Not Imported","For Reference only - Not Imported","Required. Option \"A\" only applicable if you are a library system or a school district that is not ESA"]
[1,"Data Distribution","No","Switch","Brocade",null,"ICX7250-24P","No",0,0,0,0,"Each",0,1,0,1279.9000000000001,0,1279.9000000000001,5,6399.5,6399.5,"C. Neither A nor B applies"]
[2,"Data Distribution","No","Switch","Brocade",null,"ICX7150-24-2X10G","No",0,0,0,0,"Each",0,1,0,729.9,0,729.9,26,18977.400000000001,18977.400000000001,"C. Neither A nor B applies"]
[3,"Data Distribution","No","Switch","Brocade",null,"ICX6610-24","No",0,0,0,0,"Each",0,1,0,2059.9,0,2059.9,4,8239.6,8239.6,"C. Neither A nor B applies"]
[4,"Data Distribution","No","Switch","Brocade",null,"ICX6610-10G-LIC-POD","No",0,0,0,0,"Each",0,1,0,939.9,0,939.9,1,939.9,939.9,"C. Neither A nor B applies"]

{"sheet":"Recipients of Service","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3]]}
["Category Two - Internal Connections - Version 19.0"]
["Recipients of Service"]
["Reference Number","BEN","Name","Eligible Cost per BEN"]
["Required- Not Imported","Required","For Reference only - Not Imported","Required"]
[1,18080,"EAST HIGH STREET ELEM SCHOOL",2559.8000000000002]
[2,18080,"EAST HIGH STREET ELEM SCHOOL",4379.3999999999996]
[1,16063032,"BEAR CREEK SCHOOL",3839.7]
[2,16063032,"BEAR CREEK SCHOOL",14598]
[3,16063032,"BEAR CREEK SCHOOL",8239.6]
[4,16063032,"BEAR CREEK SCHOOL",939.9]

{"sheet":"List of Errors","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Category Two - Internal Connections - Version 19.0"]
["Tab","Column and Row","Error"]

{"sheet":"Flag","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Validate Button Clicked on ROS tab?","Error-free for list of Errors tab?"]
[1,1]

{"sheet":"Dropdown","index":4,"n_rows":82,"n_cols":17,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["Type_of_Internal_Connection","Cabling/Connectors","Caching","Data Distribution","Data Protection","Racks","Software","Wireless Data Distribution","Miscellaneous","Make","Unit","Boolean","Conditions_Apply",1,"License","Transceiver","Module"]
["Cabling/Connectors","Cabling","Caching Equipment","Router","Firewall Services & Components","Racks & Cabinets","Operating System Software of Eligible Equipment","Access Point","Installation, Activation, & Initial Configuration","3Com","Each","Yes","A. Product/Service is for all entities and the cost is split equally",2,"License","Transceiver","Module"]
["Caching","Connectors","Caching Service","Switch","UPS/ Battery Backup",null,null,"Antenna","Training","3M","Dozen","No","B. Product/Service is for only some entities, but the cost is split equally among them",3]
["Data Distribution",null,null,null,null,null,null,"LAN Controller","Fees, Taxes, etc.","Adtran","Foot",null,"C. Neither A nor B applies",4]
["Data Protection",null,null,null,null,null,null,"Wireless Controller",null,"Aerohive Networks","Hundred Feet"]
["Racks",null,null,null,null,null,null,null,null,"Airtight Networks","Hours"]
["Software",null,null,null,null,null,null,null,null,"Alcatel-Lucent",null,null,"Dropdown Values automatically populate into N. Please do not tamper.  >>"]
["Wireless Data Distribution",null,null,null,null,null,null,null,null,"Allied Telesis"]
["Miscellaneous",null,null,null,null,null,null,null,null,"American Power Conversion"]
["License",null,null,null,null,null,null,null,null,"AMS.NET"]
["Transceiver",null,null,null,null,null,null,null,null,"Apple"]
["Module",null,null,null,null,null,null,null,null,"ApplianSys"]
[null,null,null,null,null,null,null,null,null,"Aruba"]
[null,null,null,null,null,null,null,null,null,"Asante Technologies"]
[null,null,null,null,null,null,null,null,null,"Asus"]
[null,null,null,null,null,null,null,null,null,"Avaya"]
[null,null,null,null,null,null,null,null,null,"Barracuda"]
[null,null,null,null,null,null,null,null,null,"Belden"]
[null,null,null,null,null,null,null,null,null,"Belkin"]
[null,null,null,null,null,null,null,null,null,"Berk-Tek"]
[null,null,null,null,null,null,null,null,null,"Black Box"]
[null,null,null,null,null,null,null,null,null,"Brocade"]
[null,null,null,null,null,null,null,null,null,"Cambium"]
[null,null,null,null,null,null,null,null,null,"Checkpoint"]
[null,null,null,null,null,null,null,null,null,"Cisco Systems"]
[null,null,null,null,null,null,null,null,null,"CommScope"]
[null,null,null,null,null,null,null,null,null,"Compaq"]
[null,null,null,null,null,null,null,null,null,"Corning"]
[null,null,null,null,null,null,null,null,null,"CradlePoint"]
[null,null,null,null,null,null,null,null,null,"Dell"]
[null,null,null,null,null,null,null,null,null,"D-Link"]
[null,null,null,null,null,null,null,null,null,"Eaton"]
[null,null,null,null,null,null,null,null,null,"Enterasys"]
[null,null,null,null,null,null,null,null,null,"Extreme Networks"]
[null,null,null,null,null,null,null,null,null,"Fortinet"]
[null,null,null,null,null,null,null,null,null,"Foundry Networks"]
[null,null,null,null,null,null,null,null,null,"Great Lakes"]
[null,null,null,null,null,null,null,null,null,"Hewlett Packard"]
[null,null,null,null,null,null,null,null,null,"Huawei"]
[null,null,null,null,null,null,null,null,null,"Hubbell"]
[null,null,null,null,null,null,null,null,null,"IBM"]
[null,null,null,null,null,null,null,null,null,"ICC"]
[null,null,null,null,null,null,null,null,null,"Intel"]
[null,null,null,null,null,null,null,null,null,"Juniper Networks"]
[null,null,null,null,null,null,null,null,null,"K12USA"]
[null,null,null,null,null,null,null,null,null,"KEMP Technologies"]
[null,null,null,null,null,null,null,null,null,"Legrand"]
[null,null,null,null,null,null,null,null,null,"Leviton"]
[null,null,null,null,null,null,null,null,null,"Liebert"]
[null,null,null,null,null,null,null,null,null,"Linksys"]
[null,null,null,null,null,null,null,null,null,"Meraki"]
[null,null,null,null,null,null,null,null,null,"Meru"]
[null,null,null,null,null,null,null,null,null,"Minuteman"]
[null,null,null,null,null,null,null,null,null,"Mohawk"]
[null,null,null,null,null,null,null,null,null,"NEC"]
[null,null,null,null,null,null,null,null,null,"Netgear"]
[null,null,null,null,null,null,null,null,null,"Orion Power Systems"]
[null,null,null,null,null,null,null,null,null,"Ortronics"]
[null,null,null,null,null,null,null,null,null,"Palo Alto Networks"]
[null,null,null,null,null,null,null,null,null,"Panduit"]
[null,null,null,null,null,null,null,null,null,"Pomeroy"]
[null,null,null,null,null,null,null,null,null,"Proline"]
[null,null,null,null,null,null,null,null,null,"Proxim"]
[null,null,null,null,null,null,null,null,null,"Quicktron"]
[null,null,null,null,null,null,null,null,null,"Ruckus Wireless"]
[null,null,null,null,null,null,null,null,null,"Samsung"]
[null,null,null,null,null,null,null,null,null,"Seagate"]
[null,null,null,null,null,null,null,null,null,"SMC Networks"]
[null,null,null,null,null,null,null,null,null,"SonicWALL"]
[null,null,null,null,null,null,null,null,null,"Sophos"]
[null,null,null,null,null,null,null,null,null,"STI"]
[null,null,null,null,null,null,null,null,null,"Sun Microsystems"]
[null,null,null,null,null,null,null,null,null,"Superior Essex"]
[null,null,null,null,null,null,null,null,null,"Tripplite"]
[null,null,null,null,null,null,null,null,null,"Ubiquiti"]
[null,null,null,null,null,null,null,null,null,"Uniprise"]
[null,null,null,null,null,null,null,null,null,"Watch Guard Technologies"]
[null,null,null,null,null,null,null,null,null,"Waters Network Systems"]
[null,null,null,null,null,null,null,null,null,"Western Digital"]
[null,null,null,null,null,null,null,null,null,"Xirrus"]
[null,null,null,null,null,null,null,null,null,"ZyXEL"]
[null,null,null,null,null,null,null,null,null,"Other"]

{"sheet":"Performance","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Performance "]
["Category Tab"]
["#TotalRows",4]
["Start Time",43509.489525462966]
["End Time",43509.489525462966]
["Total Time ",{"$f":"(B5-B4)*86400","v":0},"seconds"]
["Average Time",{"$f":"B6/B3","v":0}]
[]
["ROS Tab "]
["#TotalRows",6]
["Start Time",43509.489525462966]
["End Time",43509.489525462966]
["Total Time ",{"$f":"(B12-B11)*86400","v":0},"seconds"]
["Average Time",{"$f":"B13/B10","v":0}]