{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["QuoteSheet","Mobile Options","Tracked Options","Master"],"not_rendered":{"charts":0,"images":92,"macros":1,"external_links":0,"defined_names":94,"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":"QuoteSheet","index":0,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[[43,1,45,5],[16,1,42,5],[46,0,46,6],[47,0,47,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Machine Quote"]
[]
["Dealer Logo",null,null,null,"Model:","_RHD835EK16"]
[null,null,null,null,"Customer:    ","Customer Name"]
[null,null,null,null,"Date:               ","Date"]
[null,null,null,null,"Dealer:           ","Dealer Name"]
[null,null,null,null,"Quote #: ","Quote #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Lift capacities are stated in pounds. Values in brackets [ ] are stated in metric tons. Indicated figures are based on ISO 10567 and do not exceed 75% or tipping and 87% of hydraulic capacity and machine standing on firm, level supporting surface. Loads are valid for 360° with machine support on outriggers."]
[]
[]
["© SENNEBOGEN LLC, 1957 Sennebogen Trail, Stanley, NC 28164"]
["Under our policy of continuous improvements we reserve the right to change specifications without prior notice. The illustrations may show optional equipment and/or different series."]
[]
[]
[{"$f":"LEFT(F12,1)","v":"_"},{"$f":"IF(A51=\"M\",0,2)","v":2}]
[]
[]
[]
["Machine Quote"]
[]
[null,"Value","Cost",null,null,"Value","Cost"]
["Included Options*",null,null,null,"Uptime"]
[{"$f":"IF($B$51<1,'Mobile Options'!A9,'Tracked Options'!A9)","v":"Top Window Guards"},{"$f":"IF($B$51<1,'Mobile Options'!B9,'Tracked Options'!B9)","v":2000},{"$f":"IF($B$51<1,'Mobile Options'!C9,'Tracked Options'!C9)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E9,'Tracked Options'!E9)","v":"Uptime Maintenance Pro"}]
[{"$f":"IF($B$51<1,'Mobile Options'!A10,'Tracked Options'!A10)","v":"Front Window Guards"},{"$f":"IF($B$51<1,'Mobile Options'!B10,'Tracked Options'!B10)","v":3000},{"$f":"IF($B$51<1,'Mobile Options'!C10,'Tracked Options'!C10)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E10,'Tracked Options'!E10)","v":"Uptime Kit ABCD"}]
[{"$f":"IF($B$51<1,'Mobile Options'!A11,'Tracked Options'!A11)","v":"Upper Carriage Handrail"},{"$f":"IF($B$51<1,'Mobile Options'!B11,'Tracked Options'!B11)","v":2700},{"$f":"IF($B$51<1,'Mobile Options'!C11,'Tracked Options'!C11)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E11,'Tracked Options'!E11)","v":"Full Repair and Maintenance Program"}]
[{"$f":"IF($B$51<1,'Mobile Options'!A12,'Tracked Options'!A12)","v":"Bulletproof Windshield"},{"$f":"IF($B$51<1,'Mobile Options'!B12,'Tracked Options'!B12)","v":1100},{"$f":"IF($B$51<1,'Mobile Options'!C12,'Tracked Options'!C12)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E12,'Tracked Options'!E12)","v":"On the Ground, Anytime Maintenance"}]
[{"$f":"IF($B$51<1,'Mobile Options'!A13,'Tracked Options'!A13)","v":"Bulletproof Skylight"},{"$f":"IF($B$51<1,'Mobile Options'!B13,'Tracked Options'!B13)","v":650},{"$f":"IF($B$51<1,'Mobile Options'!C13,'Tracked Options'!C13)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A14,'Tracked Options'!A14)","v":"3 Micron Dual Filtration System "},{"$f":"IF($B$51<1,'Mobile Options'!B14,'Tracked Options'!B14)","v":2500},{"$f":"IF($B$51<1,'Mobile Options'!C14,'Tracked Options'!C14)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A15,'Tracked Options'!A15)","v":"Seat Heater"},{"$f":"IF($B$51<1,'Mobile Options'!B15,'Tracked Options'!B15)","v":1000},{"$f":"IF($B$51<1,'Mobile Options'!C15,'Tracked Options'!C15)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A16,'Tracked Options'!A16)","v":"Light Package on Cab Roof"},{"$f":"IF($B$51<1,'Mobile Options'!B16,'Tracked Options'!B16)","v":470},{"$f":"IF($B$51<1,'Mobile Options'!C16,'Tracked Options'!C16)","v":0},null,null,"Value","Cost"]
[{"$f":"IF($B$51<1,'Mobile Options'!A17,'Tracked Options'!A17)","v":"LED Light Package Boom"},{"$f":"IF($B$51<1,'Mobile Options'!B17,'Tracked Options'!B17)","v":920},{"$f":"IF($B$51<1,'Mobile Options'!C17,'Tracked Options'!C17)","v":0},null,"Training"]
[{"$f":"IF($B$51<1,'Mobile Options'!A18,'Tracked Options'!A18)","v":"LED Light Package Stick"},{"$f":"IF($B$51<1,'Mobile Options'!B18,'Tracked Options'!B18)","v":920},{"$f":"IF($B$51<1,'Mobile Options'!C18,'Tracked Options'!C18)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E18,'Tracked Options'!E18)","v":"Level I Factory Training"},{"$f":"IF($B$51<1,'Mobile Options'!F18,'Tracked Options'!F18)","v":5000},{"$f":"IF($B$51<1,'Mobile Options'!G18,'Tracked Options'!G18)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A20,'Tracked Options'!A19)","v":"Travel Alarm"},{"$f":"IF($B$51<1,'Mobile Options'!B20,'Tracked Options'!B19)","v":550},{"$f":"IF($B$51<1,'Mobile Options'!C20,'Tracked Options'!C19)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E19,'Tracked Options'!E19)","v":"Level II Factory Training"},{"$f":"IF($B$51<1,'Mobile Options'!F19,'Tracked Options'!F19)","v":7000},{"$f":"IF($B$51<1,'Mobile Options'!G19,'Tracked Options'!G19)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A21,'Tracked Options'!A20)","v":"Aluminum Ladder"},{"$f":"IF($B$51<1,'Mobile Options'!B21,'Tracked Options'!B20)","v":560},{"$f":"IF($B$51<1,'Mobile Options'!C21,'Tracked Options'!C20)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A22,'Tracked Options'!A21)","v":"Safety Catwalk w/ Handrails for Easy Access"},{"$f":"IF($B$51<1,'Mobile Options'!B22,'Tracked Options'!B21)","v":2750},{"$f":"IF($B$51<1,'Mobile Options'!C22,'Tracked Options'!C21)","v":0},null,null,"Value","Cost"]
[{"$f":"IF($B$51<1,'Mobile Options'!A23,'Tracked Options'!A22)","v":"Easy-access, Heavy Duty Sliding Cab Door for Safe Entry"},{"$f":"IF($B$51<1,'Mobile Options'!B23,'Tracked Options'!B22)","v":7850},{"$f":"IF($B$51<1,'Mobile Options'!C23,'Tracked Options'!C22)","v":0},null,"Support Services"]
[null,null,null,null,{"$f":"IF($B$51<1,'Mobile Options'!E24,'Tracked Options'!E24)","v":"Factory Technicians"},null,{"$f":"IF($B$51<1,'Mobile Options'!G24,'Tracked Options'!G24)","v":0}]
[{"$f":"IF($B$51<1,'Mobile Options'!A24,'Tracked Options'!A23)","v":"joystick steering for crawler "},{"$f":"IF($B$51<1,'Mobile Options'!B24,'Tracked Options'!B23)","v":2300},{"$f":"IF($B$51<1,'Mobile Options'!C25,'Tracked Options'!C24)","v":0},null,{"$f":"IF($B$51<1,'Mobile Options'!E25,'Tracked Options'!E25)","v":"Engineering Services"},null,{"$f":"IF($B$51<1,'Mobile Options'!G25,'Tracked Options'!G25)","v":0}]
[null,null,null,null,"CXS vist",null,0]
[]
[null,null,null,null,null,"Value","Cost"]
[null,null,null,null,"Parts & Warranty"]
[null,null,null,null,{"$f":"IF($B$51<1,'Mobile Options'!E30,'Tracked Options'!E30)","v":"98% Availability"},null,{"$f":"IF($B$51<1,'Mobile Options'!G30,'Tracked Options'!G30)","v":0}]
[null,null,null,null,{"$f":"IF($B$51<1,'Mobile Options'!E31,'Tracked Options'!E31)","v":"Standard Warranty 1yr 2000hrs"},null,{"$f":"IF($B$51<1,'Mobile Options'!G31,'Tracked Options'!G31)","v":0}]
[]
[null,null,null,null,null,"Value","Cost"]
[null,null,null,null,"Included Value"]
["Attachments",null,null,null,"Included Standard Options",{"$f":"SUM(B59:B83)","v":29270},{"$f":"SUM(C59:C83)","v":0}]
[null,null,null,null,"Attachments",{"$f":"SUM(B85:B91)","v":0},{"$f":"SUM(C85:C91)","v":0}]
[null,null,null,null,"Uptime",{"$f":"SUM(F59:F65)","v":0},{"$f":"SUM(G59:G65)","v":0}]
[null,null,null,null,"Training",{"$f":"SUM(F68:F70)","v":12000},{"$f":"SUM(G68:G70)","v":0}]
[null,null,null,null,"Support",{"$f":"SUM(F73:F76)","v":0},{"$f":"SUM(G73:G76)","v":0}]
[null,null,null,null,"Parts & Warranty",{"$f":"SUM(F79:F81)","v":0},{"$f":"SUM(G79:G81)","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F84:F89)","v":41270},{"$f":"SUM(G84:G89)","v":0}]
[]
[null,null,null,null,"Retail Price of Unit",null,480000]
[null,null,null,null,"Discounts",0]
[null,null,null,null,"Included Value",{"$f":"F90-G90","v":41270}]
[null,null,null,null,"Total",{"$f":"SUM(F93:F94)","v":41270}]
[]
[null,null,null,null,"Total Customer Price",null,{"$f":"G92-F93-F94","v":438730}]
["*Included standard options are not removable"]

{"sheet":"Mobile Options","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Machine Quote"]
[]
[null,"Value","Cost",null,null,"Value","Cost"]
["Included Standard Options",null,null,null,"Uptime"]
["Top Window Guards",2000,0,null,"Uptime Maintenance Pro",4000]
["Front Window Guards",3000,0,null,"Uptime Kit ABCD"]
["Upper Carriage Handrail",2700,0,null,"Full Repair and Maintenance Program"]
["Bulletproof Windshield",1100,0,null,"On the Ground, Anytime Maintenance"]
["Bulletproof Skylight",650,0,null,"Non-Electronic Magnet Controller"]
["3 Micron Dual Filtration System ",2500,0]
["Seat Heater",1000,0]
["Light Package on Cab Roof",470,0,null,null,"Value","Cost"]
["LED Light Package Boom",920,0,null,"Training"]
["LED Light Package Stick",920,0,null,"Level I Factory Training",5000,0]
["Drive Train Protection Guards",2600,0,null,"Level II Factory Training",7000,0]
["Travel Alarm",550,0]
["Aluminum Ladder",560,0]
["Safety Catwalk w/ Handrails for Easy Access",2750,0,null,null,"Value","Cost"]
["Easy-access, Heavy Duty Sliding Cab Door for Safe Entry",7850,0,null,"Support Services"]
[null,null,null,null,"Factory Technicians","Priceless",0]
[null,null,null,null,"Engineering Services","Priceless",0]
[]
[]
[null,null,null,null,null,"Value","Cost"]
[null,null,null,null,"Parts & Warranty"]
[null,null,null,null,"98% Availability","Priceless",0]
[null,null,null,null,"Standard Warranty 1yr 2000hrs"]
[]
[null,null,null,null,null,"Value","Cost"]

{"sheet":"Tracked Options","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Machine Quote"]
[]
[null,"Value","Cost",null,null,"Value","Cost"]
["Included Standard Options",null,null,null,"Uptime"]
["Top Window Guards",2000,0,null,"Uptime Maintenance Pro",4000]
["Front Window Guards",3000,0,null,"Uptime Kit ABCD"]
["Upper Carriage Handrail",2700,0,null,"Full Repair and Maintenance Program"]
["Bulletproof Windshield",1100,0,null,"On the Ground, Anytime Maintenance"]
["Bulletproof Skylight",650,0,null,"Non-Electronic Magnet Controller"]
["3 Micron Dual Filtration System ",2500,0]
["Seat Heater",1000,0]
["Light Package on Cab Roof",470,0,null,null,"Value","Cost"]
["LED Light Package Boom",920,0,null,"Training"]
["LED Light Package Stick",920,0,null,"Level I Factory Training",5000,0]
["Travel Alarm",550,0,null,"Level II Factory Training",7000,0]
["Aluminum Ladder",560,0]
["Safety Catwalk w/ Handrails for Easy Access",2750,0]
["Easy-access, Heavy Duty Sliding Cab Door for Safe Entry",7850,0,null,null,"Value","Cost"]
["joystick steering for crawler ",2300,0,null,"Support Services"]
[null,null,null,null,"Factory Technicians","Priceless",0]
[null,null,null,null,"Engineering Services","Priceless",0]
[]
[]
[null,null,null,null,null,"Value","Cost"]
[null,null,null,null,"Parts & Warranty"]
[null,null,null,null,"98% Availability","Priceless",0]
[null,null,null,null,"Standard Warranty 1yr 2000hrs"]
[]
[null,null,null,null,null,"Value","Cost"]

{"sheet":"Master","index":3,"n_rows":107,"n_cols":2,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
["Machine","Flag"]
["M818EK10"]
["M818EK9"]
["M818EK10ULM"]
["M818EK9ULM"]
[]
["_R818EK10"]
["_R818EK9"]
["_R818EK10ULM"]
["_R818EK9ULM"]
[]
["M821EK9"]
["M821EK11"]
["M821EK12"]
["M821EK11ULM"]
[]
["_R821EK11"]
["_R821EK11ULM"]
[]
["M825EK12"]
["M825EK12ULM"]
["M825EK13"]
[]
["_R825EK12"]
["_R825EK12ULM"]
["_R825K13"]
[]
["M830EK15"]
["M830EK14ULM"]
["MHDS830EK15"]
["MHDS830EK17"]
["MHDS830EB16"]
["MHDS830EK14ULM"]
["M830EK14MT"]
[]
["_RHD830EK15"]
["_RHD830K17"]
["_RHD830EB16"]
["_RHD830EK14ULM"]
[]
["M835EK16"]
["M835EK18"]
["M835EB18"]
["M835EK16ULM"]
[]
["_RHD835EK16"]
["_RHD835EK18"]
["_RHD835EB18"]
["_RHD835EK16ULM"]
[]
["M840EK17"]
["M840EK18"]
["M840EK19"]
["M840EB18"]
[]
["_RHD840EK17"]
["_RHD840EK18"]
["_RHD840EK19"]
["_RHD840EB18"]
[]
["M850EK17"]
["M850EK19"]
["M850EB17"]
["M850EB19"]
[]
["_RHD850EK17"]
["_RHD850EK19"]
["_RHD850EB17"]
["_RHD850EB19"]
[]
["M855EK17"]
["M855EK18"]
["M855EK19"]
["M855EK21"]
["M855EB19"]
["M855EB20"]
[]
["_RHD855EK17"]
["_RHD855EK18"]
["_RHD855EK19"]
["_RHD855EK21"]
["_RHD855EB19"]
["_RHD855EB20"]
[]
["M860EK18"]
["M860EK20"]
["M860EB21"]
["M860EB23"]
[]
["_RHD860EK18"]
["_RHD860EK20"]
["_RHD860EB21"]
["_RHD860EB23"]
[]
["M870EK18"]
["M870EK20"]
["M870EK22"]
["M870EK25"]
["M870EB21"]
["M870EB24"]
[]
["_RHD870EK18"]
["_RHD870EK20"]
["_RHD870EK22"]
["_RHD870EK25"]
["_RHD870EB21"]
["_RHD870EB24"]