{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Quote","Printable","Inventory & Pricing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"Quote","index":0,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[[33,0,33,3],[36,0,36,3],[47,0,47,3],[62,0,62,3],[66,0,69,0],[27,0,27,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,0,8,3],[10,0,10,3],[14,0,14,3],[21,0,21,3]]}
[null,"Branch"]
[null,"Contact Name"]
["                                                       APM Branch Setup","Email"]
["                                                            Onboarding Cost Estimating Tool","Phone"]
[null,"Quote#"]
[null,"Date"]
[]
["Description","Qty","Ext. Price"]
["Pre-Quote Computer Assessment (site has existing laptops/desktops)"]
["Assessment Charge - 30 min per unit",0,{"$f":"B10*'Inventory & Pricing'!C40/2","v":0}]
["Firewall Security Appliance"]
["(1 to 100 Users)   SonicWall TZ270 Wireless Firewall ",0,{"$f":"B12*'Inventory & Pricing'!C3","v":0}]
["(1 to 100 Users)   SonicWall TZ270 Non - Wireless ",0,{"$f":"B13*'Inventory & Pricing'!C4","v":0}]
["(100+ Users)    SonicWall TZ370  Firewall  ",0,{"$f":"B14*'Inventory & Pricing'!C5","v":0}]
["Network Switch"]
["Aruba InstanT On 24 Port Switches "]
["Aruba Instant ON 1930 24 Port Switch - No Power over Ethernet ",0,{"$f":"B17*'Inventory & Pricing'!C7","v":0}]
["Aruba Instant On 1930 24 Port Switch - With Power Over Ethernet Ports",0,{"$f":"B18*'Inventory & Pricing'!C8","v":0}]
["Aruba InstanT On 48 Port Switches "]
["Aruba Instant On 1930 48 Port Switch - No Power over ethernet ",0,{"$f":"B20*'Inventory & Pricing'!C9","v":0}]
["Aruba Instant On 1930 48 Port Switch - With Power over ethernet ",0,{"$f":"B21*'Inventory & Pricing'!C10","v":0}]
["Wireless Access Points"]
["Ubiquiti UniFi Wireless Access Point"]
["(1 to 4 Users): n/a if SonicWall W/WIFI Firewall is selected","n/a","n/a"]
["(5 to 10 Users): enter Qty=1 for typical setup   ",0,{"$f":"B25*'Inventory & Pricing'!C12","v":0}]
["(11 to 20 Users): enter Qty=2 for typical setup   ",0,{"$f":"B26*'Inventory & Pricing'!C12","v":0}]
["(21 to 40 Users): enter Qty=3 for typical setup   ",0,{"$f":"B27*'Inventory & Pricing'!C12","v":0}]
["Uninterruptible Power Supply (UPS)"]
["APC UPS 600 VA Tower"]
["(1 to 4 Users): enter Qty=1 for typical setup   ",0,{"$f":"B30*'Inventory & Pricing'!C14","v":0}]
["APC UPS 1500 VA - Required if Switch is used"]
["APC UPS 1500 VA Tower ",0,{"$f":"B32*'Inventory & Pricing'!C16","v":0}]
["APC UPS 1500 VA Rack Mounted",0,{"$f":"B33*'Inventory & Pricing'!C15","v":0}]
["Network Accessories"]
["Wall Rack Kit / Patch Panels / Patch Cables",0,{"$f":"B35*'Inventory & Pricing'!C18","v":0}]
["Estimated - Low voltage network cable installation - Per Drop",0,{"$f":"B36*'Inventory & Pricing'!C19","v":0}]
["Laptop/PC/Monitors"]
["Premium"]
["Dell Latitude 5000 5520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i7 11th Gen i7-1165G7 Quad-core (4 Core) 8GB Ram ",0,{"$f":"B39*'Inventory & Pricing'!C21","v":0}]
["Standard"]
["Dell Latitude 3000 3520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i7 11th Gen i7-1165G7 Quad-core (4 Core) 2.80 GHz - 8 GB Total RAM",0,{"$f":"B41*'Inventory & Pricing'!C22","v":0}]
["Budget"]
["Dell Latitude 3000 3520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i5 11th Gen i5-1135G7 Quad-core (4 Core) 2.40 GHz - 8 GB Total RAM)",0,{"$f":"B43*'Inventory & Pricing'!C23","v":0}]
["Accessories"]
["24\" LED LCD Monitor - 16:9 - 8 ms - 1920 x 1080  (typically Qty = 2 per user)",0,{"$f":"B45*'Inventory & Pricing'!C26","v":0}]
["Dell Thunderbolt Dock- WD19TB 130w Power Delivery - 180 W",0,{"$f":"B46*'Inventory & Pricing'!C24","v":0}]
["Dell KM7120W Keyboard & Mouse - Wireless",0,{"$f":"B47*'Inventory & Pricing'!C25","v":0}]
["Setup Services"]
["Network Assessment & Project Management Fee (estimated)"]
["(1 to 4 Users)    ",0,{"$f":"B50*'Inventory & Pricing'!C35","v":0}]
["(5 to 10 Users) ",0,{"$f":"B51*'Inventory & Pricing'!C36","v":0}]
["(11 to 20 Users) ",0,{"$f":"B52*'Inventory & Pricing'!C37","v":0}]
["(21 to 40 Users)",0,{"$f":"B53*'Inventory & Pricing'!C38","v":0}]
[]
["Network Setup Fee  (estimated)"]
["(1 to 4 Users)    ",0,{"$f":"B56*'Inventory & Pricing'!C30","v":0}]
["(5 to 10 Users) ",0,{"$f":"B57*'Inventory & Pricing'!C31","v":0}]
["(11 to 20 Users) ",0,{"$f":"B58*'Inventory & Pricing'!C32","v":0}]
["(21 to 40 Users)",0,{"$f":"B59*'Inventory & Pricing'!C33","v":0}]
["Estimated Labor - PC Set Up (~.5 - 1.5  Hours Per Device)",0,{"$f":"B60*'Inventory & Pricing'!C28","v":0}]
["Other Installation Services - Desktop Tech per hour",0,{"$f":"B61*'Inventory & Pricing'!C39","v":0}]
["Project Management & Other Installation Services - PM/Network Engineer per hour",0,{"$f":"B62*'Inventory & Pricing'!C40","v":0}]
["Monthly Services  ***Recurring charge***"]
["Managed IT: Security Management + Unlimited Help Desk - Per User",0,{"$f":"B64*'Inventory & Pricing'!C42","v":0}]
[]
["Notes:  pricing is for planning and estimation; actual quote would follow if site is approved","Sub Total",{"$f":"SUM(C10:C62)","v":0}]
[null,"Est Tax",{"$f":"C66*'Inventory & Pricing'!B45","v":0}]
[null,"Est Shipping",{"$f":"(SUM(B12:B47))*'Inventory & Pricing'!C44","v":0}]
[null,"Total Project Cost ",{"$f":"SUM(C66,C67,C68)","v":0}]
[null,"Total Monthly Recurring",{"$f":"SUM(C64:C64)","v":0}]

{"sheet":"Printable","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,3,25,3],[27,0,31,0],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,3],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,3,15,3],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3]]}
[null,"Branch",{"$f":"Quote!$C$1","v":0}]
[null,"Contact Name",{"$f":"Quote!C2","v":0}]
["                                                       APM Branch Setup","Email",{"$f":"Quote!C3","v":0}]
["                                                            Onboarding Cost Estimating Tool","Phone",{"$f":"Quote!$C$4","v":0}]
[null,"Quote#",{"$f":"Quote!$C$5","v":0}]
[null,"Date",{"$f":"Quote!$C$6","v":"00:00:00"}]
[]
["Description","Comment:","Ext. Price"]
["Pre-Quote Computer Assessment (site has existing equipment)",null,{"$f":"SUM(Quote!C10)","v":0}]
[]
["Firewall Security Appliance",null,{"$f":"SUM(Quote!C12:C14)","v":0}]
[]
["Network Switch ",null,{"$f":"SUM(Quote!C17:C21)","v":0}]
[]
["Network Location Ancillary Equipment",null,{"$f":"SUM(Quote!C35:C36)","v":0}]
[]
["Wireless Access Points",null,{"$f":"SUM(Quote!C23:C27)","v":0}]
[]
["UPS - Protects Equipment",null,{"$f":"SUM(Quote!C30:C33)","v":0}]
[]
["Laptop/PC/Monitors",null,{"$f":"SUM(Quote!C39:C47)","v":0}]
[]
["Services",null,{"$f":"SUM(Quote!C50:C62)","v":0}]
[]
["Managed-IT - Monthly Service Fee  ***Recurring charge***",null,{"$f":"SUM(Quote!C64:C64)","v":0}]
[]
[{"$f":"[1]Quote!A66","v":"Notes:  pricing is for planning and estimation; actual quote would follow if site is approved"},"Assessment Cost",{"$f":"SUM(C1)","v":0}]
[{"$f":"[1]Quote!A67","v":0},"Sub Total",{"$f":"SUM(C9:C24)","v":0}]
[null,"Est. Tax",{"$f":"C28*'Inventory & Pricing'!B45","v":0}]
[null,"Est. Shipping",{"$f":"Quote!$C$68","v":0}]
[null,"Total Project Cost",{"$f":"SUM(C28:C30)","v":0}]
[null,"Total Monthly Recurring",{"$f":"SUM(C25)","v":0}]

{"sheet":"Inventory & Pricing","index":2,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Description",null,"Price"]
["Firewall Security Appliance"]
["(1 to 100 Users)        SonicWall TZ270 Wireless Firewall ",null,1200]
["(1 to 100 Users)      SonicWall TZ270 Non - Wireless ",null,1050]
["(100+ Users)    SonicWall TZ370  Firewall  ",null,1400]
["Network Switch"]
["Aruba Instant ON 1930 24 Port Switch - No Power over Ethernet ",null,300]
["Aruba Instant On 1930 24 Port Switch - With Power Over Ethernet Ports",null,900]
["Aruba Instant On 1930 48 Port Switch - No Power over ethernet ",null,700]
["Aruba Instant On 1930 48 Port Switch - With Power over ethernet ",null,2200]
["Wireless Access Points"]
["Ubiquiti UniFi Wireless Access Point",null,180]
["UPS"]
["APC UPS 600 VA Tower",null,80]
["APC UPS 1500 VA Rack Mount",null,600]
["APC UPS 1500 VA Tower ",null,500]
["Cabling"]
["Wall Rack Kit / Patch Panels / Patch Cables",null,750]
["Estimated - Low voltage network cable installation - Per Drop",null,200]
["Laptop/PC/Monitors"]
["Dell Latitude 5000 5520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i7 11th Gen i7-1165G7 Quad-core (4 Core) 8GB Ram ",null,1800]
["Dell Latitude 3000 3520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i7 11th Gen i7-1165G7 Quad-core (4 Core) 2.80 GHz - 8 GB Total RAM",null,1200]
["Dell Latitude 3000 3520 15.6\" Notebook - Full HD - 1920 x 1080 - Intel Core i5 11th Gen i5-1135G7 Quad-core (4 Core) 2.40 GHz - 8 GB Total RAM",null,1000]
["Dell Thunderbolt Dock- WD19TB 130w Power Delivery - 180 W",null,350]
["Dell KM7120W Keyboard & Mouse - Wireless",null,82.51]
["Dell  24\" LED LCD Monitor",null,150]
["Services"]
["Estimated Labor - PC Set Up (~.5 - 1.5  Hours Per Device)",null,65]
["Network Set Up Fixed Fee (~$1,000 to $2,500)"]
["(1 to 4 Users)    ",null,1000]
["(5 to 10 Users) ",null,1500]
["(11 to 20 Users) ",null,2000]
["(21 to 40 Users)",null,2500]
["Assessment & Project Management"]
["(1 to 4 Users)    ",null,800]
["(5 to 10 Users) ",null,1000]
["(11 to 20 Users) ",null,1400]
["(21 to 40 Users)",null,2000]
["Other Installation Services - Desktop Tech per hour",null,65]
["Other Installation Services - Network Engineer per hour",null,95]
["Managed-IT - Monthly Service Fee - Recurring charge"]
["Managed-IT Platinum: Security Management + Unlimited Help Desk - Per User",null,45]
[]
["Est. Standard GROUND Shipping (per hardware unit)",null,13]
["Est. Tax (CA purchase)",8.2500000000000004E-2]