{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Quote","Printable","Inventory & Pricing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[62,0,62,3],[66,0,66,3],[88,0,88,3],[93,0,96,0],[1,2,1,3],[8,0,8,3],[15,0,15,3],[22,0,22,3],[29,0,29,3],[34,0,34,3],[44,0,44,3],[0,2,0,3],[6,2,6,3],[5,2,5,3],[4,2,4,3],[3,2,3,3],[2,2,2,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'!C58/2)","v":0}]
["Firewall Security Appliance"]
["(1 to 4 Users): SonicWall SOHO Firewall with Wireless Access Point",0,{"$f":"B12*'Inventory & Pricing'!C3","v":0}]
["(5 to 10 Users): SonicWall TZ350 Firewall  ",0,{"$f":"B13*'Inventory & Pricing'!C4","v":0}]
["(11 to 20 Users): SonicWall TZ400 Firewall  ",0,{"$f":"B14*'Inventory & Pricing'!C5","v":0}]
["(21 to 40 Users): SonicWall TZ600 Firewall  ",0,{"$f":"B15*'Inventory & Pricing'!C6","v":0}]
["Network Switch"]
["HPE OfficeConnect 1920S 24G Power Over Ethernet Ports"]
["(1 to 4 Users): not needed if SonicWall SOHO Firewall is selected","n/a","n/a"]
["(5 to 10 Users): enter Qty=1 for typical setup   ",0,{"$f":"B19*'Inventory & Pricing'!C9","v":0}]
["HPE OfficeConnect 1950 48G Power Over Ethernet Ports"]
["(11 to 20 Users): enter Qty=1 for typical setup   ",0,{"$f":"B21*'Inventory & Pricing'!C11","v":0}]
["(21 to 40 Users): enter Qty=2 for typical setup   ",0,{"$f":"B22*'Inventory & Pricing'!C11","v":0}]
["Wireless Access Points"]
["Ubiquiti UniFi Controller (1 Required, except for 1-4 User using SonicWall SOHO)",0,{"$f":"B24*'Inventory & Pricing'!C13","v":0}]
["Ubiquiti UniFi Wireless Access Point"]
["(1 to 4 Users): n/a if SonicWall SOHO Firewall is selected","n/a","n/a"]
["(5 to 10 Users): enter Qty=1 for typical setup   ",0,{"$f":"B27*'Inventory & Pricing'!C14","v":0}]
["(11 to 20 Users): enter Qty=2 for typical setup   ",0,{"$f":"B28*'Inventory & Pricing'!C14","v":0}]
["(21 to 40 Users): enter Qty=3 for typical setup   ",0,{"$f":"B29*'Inventory & Pricing'!C14","v":0}]
["Uninterruptible Power Supply (UPS)"]
["APC UPS 700 VA Tower"]
["(1 to 4 Users): enter Qty=1 for typical setup   ",0,{"$f":"B32*'Inventory & Pricing'!C16","v":0}]
["APC UPS 1500 VA Rack Mount"]
["(5 to 10 Users), (11 to 20 Users) or (21 to 40 Users): enter Qty=1 for typical setup   ",0,{"$f":"B34*'Inventory & Pricing'!C17","v":0}]
["Network Accessories"]
["Wall Rack Kits"]
["(1 to 4 Users): 8U ",0,{"$f":"B37*'Inventory & Pricing'!C19","v":0}]
["(5 to 10 Users): 12U ",0,{"$f":"B38*'Inventory & Pricing'!C20","v":0}]
["(11 to 20 Users): 18U",0,{"$f":"B39*'Inventory & Pricing'!C21","v":0}]
["(21 to 40 Users): 22U ",0,{"$f":"B40*'Inventory & Pricing'!C22","v":0}]
["Patch Panel - Cat6 LED"]
["(1 to 4 Users), (5 to 10 Users) 1u 24 Port: enter Qty=1 for typical setup   ",0,{"$f":"B42*'Inventory & Pricing'!C23","v":0}]
["(11 to 20 Users) 1u 24 Port: enter Qty=2 for typical setup   ",0,{"$f":"B43*'Inventory & Pricing'!C23","v":0}]
["(21 to 40 Users) 1u 24 Port: enter Qty=4 for typical setup   ",0,{"$f":"B44*'Inventory & Pricing'!C23","v":0}]
["Laptop/PC/Monitors"]
["Premium"]
["Microsoft Surface Pro 12.3\" Tablet Core i5   ($1495.00)",0,{"$f":"B47*'Inventory & Pricing'!C29","v":0}]
["Dell Latitude 5590 15.6\" LCD Notebook  ($1300.00)",0,{"$f":"B48*'Inventory & Pricing'!C30","v":0}]
["Dell Latitude 3390 13.3\" Touchscreen LCD 2-in-1 Notebook   ($1090.00)",0,{"$f":"B49*'Inventory & Pricing'!C31","v":0}]
["HP ProBook 445 G6 14\" AMD  Laptop   ($915.73)",0,{"$f":"B50*'Inventory & Pricing'!C32","v":0}]
["Standard"]
["Dell Latitude 3500 15.6\" LCD Notebook   ($906.92)",0,{"$f":"B52*'Inventory & Pricing'!C34","v":0}]
["HP ProBook X360 440 G1 14\" Laptop   ($882.54)",0,{"$f":"B53*'Inventory & Pricing'!C35","v":0}]
["Dell Latitude 3000 3400 14\" Laptop   ($800.57)",0,{"$f":"B54*'Inventory & Pricing'!C36","v":0}]
["Budget"]
["Lenovo ThinkPad A485 14\" Laptop   ($738.32)",0,{"$f":"B56*'Inventory & Pricing'!C38","v":0}]
["HP ProBook 445R G6 14\"   ($705.82)",0,{"$f":"B57*'Inventory & Pricing'!C39","v":0}]
["Lenovo ThinkPad E595 15.6\"   ($660.49)",0,{"$f":"B58*'Inventory & Pricing'!C40","v":0}]
["Accessories"]
["24\" LED LCD Monitor - 16:9 - 8 ms - 1920 x 1080  (typically Qty = 2 per user)",0,{"$f":"B60*'Inventory & Pricing'!C42","v":0}]
["Universal Dock D6000",0,{"$f":"B61*'Inventory & Pricing'!C43","v":0}]
["Keyboard & Mouse - Wireless KM636 ",0,{"$f":"B62*'Inventory & Pricing'!C44","v":0}]
["Cabling"]
["3ft patch cables: enter Qty = (# users x2) for typical setup",0,{"$f":"B64*'Inventory & Pricing'!C24","v":0}]
["7ft patch cables: enter Qty = (# users x1) for typical setup",0,{"$f":"B65*'Inventory & Pricing'!C25","v":0}]
["Estimated Network Cabling Installation - per drop: enter Qty = ((# users x 2) + 2)",0,{"$f":"B66*'Inventory & Pricing'!C26","v":0}]
["Setup Services"]
["Network Assessment & Project Management Fixed Fee"]
["(1 to 4 Users)    ",0,{"$f":"B69*'Inventory & Pricing'!C53","v":0}]
["(5 to 10 Users) ",0,{"$f":"B70*'Inventory & Pricing'!C54","v":0}]
["(11 to 20 Users) ",0,{"$f":"B71*'Inventory & Pricing'!C55","v":0}]
["(21 to 40 Users)",0,{"$f":"B72*'Inventory & Pricing'!C56","v":0}]
[]
["Network Setup Fixed Fee"]
["(1 to 4 Users)    ",0,{"$f":"B75*'Inventory & Pricing'!C48","v":0}]
["(5 to 10 Users) ",0,{"$f":"B76*'Inventory & Pricing'!C49","v":0}]
["(11 to 20 Users) ",0,{"$f":"B77*'Inventory & Pricing'!C50","v":0}]
["(21 to 40 Users)",0,{"$f":"B78*'Inventory & Pricing'!C51","v":0}]
["Laptop Setup Fixed Fee - per unit",0,{"$f":"B79*'Inventory & Pricing'!C46","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Other Installation Services - Desktop Tech per hour",0,{"$f":"B87*'Inventory & Pricing'!C57","v":0}]
["Other Installation Services - Network Engineer per hour",0,{"$f":"B88*'Inventory & Pricing'!C58","v":0}]
["Monthly Services  ***Recurring charge***"]
["Managed IT: Security Management + Unlimited Help Desk - Per User",0,{"$f":"B90*'Inventory & Pricing'!C60","v":0}]
["Microsoft Intune Subscription - Secure Cloud Device Management - Per User",0,{"$f":"B91*'Inventory & Pricing'!C61","v":0}]
[]
["Notes:  pricing is for planning and estimation; actual quote would follow if site is approved","Sub Total",{"$f":"SUM(C10:C78)","v":0}]
[null,"Est Tax",{"$f":"C93*'Inventory & Pricing'!B64","v":0}]
[null,"Est Shipping",{"$f":"(SUM(B12:B62))*'Inventory & Pricing'!C63","v":0}]
[null,"Total Project Cost ",{"$f":"SUM(C93,C94,C95)","v":0}]
[null,"Total Monthly Recurring",{"$f":"SUM(C90:C91)","v":0}]

{"sheet":"Printable","index":1,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,2,27,2],[5,2,5,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[26,3,27,3],[8,3,9,3],[10,3,11,3],[12,3,13,3],[14,3,15,3],[16,3,17,3],[18,3,19,3],[24,1,25,1],[6,2,6,3],[20,3,21,3],[22,3,23,3],[24,3,25,3],[22,2,23,2],[24,2,25,2],[18,2,19,2],[20,2,21,2],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[8,2,9,2],[10,2,11,2],[12,2,13,2],[14,2,15,2],[16,2,17,2],[29,0,33,0],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[18,0,19,0],[18,1,19,1],[26,0,27,0],[26,1,27,1],[24,0,25,0]]}
[null,"Branch",{"$f":"Quote!$C$1","v":0}]
[null,"Contact Name",{"$f":"Quote!$C$2","v":0}]
["                                                       APM Branch Setup","Email",{"$f":"Quote!$C$3","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:C15)","v":0}]
[]
["Network Switch ",null,{"$f":"SUM(Quote!C19:C22)","v":0}]
[]
["Network Location Ancillary Equipment",null,{"$f":"SUM(Quote!C37:C44)","v":0}]
[]
["Wireless Access Points",null,{"$f":"SUM(Quote!C24:C29)","v":0}]
[]
["UPS - Protects Equipment",null,{"$f":"SUM(Quote!C32:C34)","v":0}]
[]
["Cabling",null,{"$f":"SUM(Quote!C64:C66)","v":0}]
[]
["Laptop/PC/Monitors",null,{"$f":"SUM(Quote!C47:C62)","v":0}]
[]
["Services",null,{"$f":"SUM(Quote!C69:C78)","v":0}]
[]
["Managed-IT - Monthly Service Fee  ***Recurring charge***",null,{"$f":"SUM(Quote!C90:C91)","v":0}]
[]
[{"$f":"Quote!A93","v":"Notes:  pricing is for planning and estimation; actual quote would follow if site is approved"},"Assessment Cost",{"$f":"SUM(C9)","v":0}]
[{"$f":"Quote!A94","v":0},"Sub Total",{"$f":"SUM(C9:C26)","v":0}]
[null,"Est. Tax",{"$f":"C30*'Inventory & Pricing'!B64","v":0}]
[null,"Est. Shipping",{"$f":"Quote!$C$95","v":0}]
[null,"Total Project Cost",{"$f":"SUM(C30:C32)","v":0}]
[null,"Total Monthly Recurring",{"$f":"SUM(C27)","v":0}]

{"sheet":"Inventory & Pricing","index":2,"n_rows":64,"n_cols":3,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Description",null,"Price"]
["Firewall Security Appliance"]
["(1 to 4 Users)        SonicWall SOHO  Firewall  w/ Wireless Access Point",null,745]
["(5 to 10 Users)      SonicWall TZ350   Firewall  ",null,1160]
["(11 to 20 Users)    SonicWall TZ400   Firewall  ",null,1380]
["(21 to 40 Users)    SonicWall TZ600   Firewall  ",null,2730]
["Network Switch"]
["HPE OfficeConnect 1920S 24G Ports",null,245]
["HPE OfficeConnect 1920S 24G Power Over Ethernet Ports",null,565]
["HPE OfficeConnect 1920S 48G Ports",null,475]
["HPE OfficeConnect 1950   48G Power Over Ethernet Ports",null,1570]
["Wireless Access Points"]
["Ubiquiti UniFi Controller (1 Required)",null,125]
["Ubiquiti UniFi Wireless Access Point",null,360]
["UPS"]
["APC UPS 700 VA Tower",null,145]
["APC UPS 1500 VA Rack Mount",null,590]
["Cabling"]
["8U Wall Rack Kit",null,170]
["12U Wall Rack Kit",null,250.5]
["18U Wall Rack Kit",null,313.5]
["22U Wall Rack Kit",null,333.75]
["1u 24 Port CAT6 Patch Panels LED",null,70]
["3ft Cat6 Ethernet Network Patch Cable (including 1st Class Postage)",null,5]
["7ft Cat6 Ethernet Network Patch Cable (including 1st Class Postage)",null,6.5]
["Estimated - Low voltage network cable installation - Per Drop",null,175]
["Laptop/PC/Monitors"]
["High"]
["Microsoft Surface Pro 12.3\" Tablet Core i5",null,1495]
["Dell Latitude 5590 15.6\" LCD Notebook",null,1300]
["Dell Latitude 3390 13.3\" Touchscreen LCD 2 in 1 Notebook",null,1090]
["HP ProBook 445 G6 14\" AMD  Laptop",null,915.73]
["Medium"]
["Dell Latitude 3500 15.6\" LCD Notebook ",null,906.92]
["HP ProBook X360 440 G1 14\" Laptop",null,882.54]
["Dell Latitude 3000 3400 14\" Laptop",null,800.57]
["Low"]
["Lenovo ThinkPad A485 14\" Laptop",null,738.32]
["HP ProBook 445R G6 14\"",null,705.82]
["Lenovo ThinkPad E595 15.6\"",null,660.49]
["Accessories"]
["Dell  24\" LED LCD Monitor - 16:9 - 8 ms - 1920 x 1080",null,150]
["DELL UNIVERSAL DOCK-D6000",null,190]
["Dell KM636 Keyboard & Mouse - Wireless RF",null,50]
["Services"]
["Laptop Set Up Fixed Fee - per unit",null,130]
["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 : Security Management + Unlimited Help Desk - Per User",null,63]
["Microsoft Intune Subscription - Secure Cloud Device Management - Per User",null,6]
[]
["Est. Shipping (per hardware unit)",null,13]
["Est. Tax (CA purchase)",8.2500000000000004E-2]