{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Enable Macros","Financing Quick Quoter","Express Application","Data"],"not_rendered":{"charts":0,"images":45,"macros":1,"external_links":1,"defined_names":147,"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":"Enable Macros","index":0,"n_rows":92,"n_cols":3,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Please follow five steps below to enable macros"]
[]
[null,null,"Step 1. Click the Office button in the upper left corner of the screen. "]
[null,null,"At the bottom of this menu, click the Excel Options button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Step 2. Click the Trust Center button on the left. Then, at the bottom right, select Trust Center Settings."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Step 3. In the new window, choose Macro Settings from the sidebar and select Disable all macros with notification"]
[null,null,"This option keeps macros disabled but notifies users when macros attempt to run, allowing users to decide "]
[null,null,"on a case-by-case basis which macros to enable. "]
[null,null,"Click OK to exit this window."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Step 4. For the new settings to take effect, it will be necessary to close Excel and reopen it. "]
[null,null,"A security dialog box should appear beneath the Office ribbon the next time you attempt to run a spreadsheet that contains macros."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Step 5. When the notification appears, click the Options button. "]
[null,null,"Choose Enable this content from the options that appear to allow macros to run within the current spreadsheet. "]
[null,null,"Click OK to close the window."]

{"sheet":"Financing Quick Quoter","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Express Application","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Data","index":3,"n_rows":91,"n_cols":29,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Navitas Deal Builder",null,null,null,"Buttons",null,"Input_5","Input_22","Input_23","Input_24","Input_25",null,"Payments Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Password",null,"Locked"]
["Text Box","Section","Input descrription","Input","http://dabuttonfactory.com/",null,"Input_13","12 Months","FMV","0 Down","0 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ken2013",null,"Unlocked"]
["Input_1","Customer profile","Company Name","A",null,null,"AL","24 Months","$1 Buyout","1 Down","1 Point",null,"Purchase Option: $1.00",null,null,null,null,null,null,null,"Purchase Option: FMV",null,null,null,null,null,null,null,1]
["Input_2","Customer profile","First Name","B",null,null,"AK","36 Months","Both plans","2 Down","2 Points",null,"Equipment Cost","Cost category",12,24,36,48,60,null,12,24,36,48,60,null,"Loaded",null,2]
["Input 2a","Customer profile","Last Name",null,null,null,"AZ","48 Months",null,null,"3 Points",null,"$1,000 - $3,001",1,0.10119999999999998,5.3129999999999997E-2,3.7489999999999996E-2,null,null,null,8.4984999999999991E-2,4.6804999999999999E-2,3.4269999999999995E-2]
["Input_3","Customer profile","Address",null,null,null,"AR","60 Months",null,null,"4 Points",null,"$3,001 - $10,000",2,9.5480000000000009E-2,4.9500000000000002E-2,3.4430000000000002E-2,2.6950000000000002E-2,2.2550000000000004E-2,null,7.9750000000000001E-2,4.3340000000000004E-2,3.1350000000000003E-2,2.5520000000000001E-2,2.1780000000000004E-2]
["Input_4","Customer profile","City",null,null,null,"CA","All Terms",null,null,"5 Points",null,"$10,001 - $20,000",3,9.3744000000000008E-2,4.8600000000000004E-2,3.3804000000000001E-2,2.6460000000000004E-2,2.2140000000000003E-2,null,7.8299999999999995E-2,4.2552E-2,3.0780000000000002E-2,2.5055999999999998E-2,2.1384000000000004E-2]
["Input_5","Customer profile","State",null,null,null,"CO",null,null,null,null,null,"$20,001 - $25,000",4,9.2008000000000006E-2,4.7699999999999999E-2,3.3178000000000006E-2,2.5970000000000003E-2,2.1730000000000003E-2,null,7.6850000000000002E-2,4.1764000000000003E-2,3.0210000000000004E-2,2.4591999999999999E-2,2.0988000000000003E-2]
["Input_6","Customer profile","Zip",null,"Buttons",null,"CT",null,null,null,null,null,"$25,001 - $50,000",5,9.1140000000000013E-2,4.725E-2,3.2865000000000005E-2,2.5725000000000001E-2,2.1525000000000002E-2,null,7.6124999999999998E-2,4.1369999999999997E-2,2.9925000000000004E-2,2.436E-2,2.0790000000000003E-2]
["Input_7","Customer profile","Telephone Number","c",{"$f":"MONTH(TODAY())&DAY(TODAY())&YEAR(TODAY())&\"BA\"","v":"3132014BA"},null,"DE",null,null,null,null,null,"Over $50,000",6,9.0272000000000005E-2,4.6800000000000001E-2,3.2552000000000005E-2,2.5480000000000003E-2,2.1320000000000002E-2,null,7.5399999999999995E-2,4.0975999999999999E-2,2.9640000000000003E-2,2.4128E-2,2.0592000000000003E-2]
["Input_8","Customer profile","Email","d",null,null,"FL"]
["Input_9","Dealer profile","Vendor Name",null,"Apply",null,"GA",null,null,null,null,null,"Advanced Rentals",null,1,2,2,2,2,null,1,2,2,2,2]
["Input_10","Dealer profile","Vendor Sales Contact",null,null,null,"HI"]
["Input_11","Dealer profile","Address",null,null,null,"ID",null,null,null,null,null,"Equipment Cost",{"$f":"v_input_18","v":50000},null,"Purchase Option: $1.00",null,null,"#",null,"Purchase Option: FMV"]
["Input_12","Dealer profile","City",null,null,null,"IL",null,null,null,null,null,"Cost Category",{"$f":"MAX(N16:N21)","v":6},null,12,{"$f":"IF($N$15=0,0,INDEX($O$5:$S$10,$N$15,S15)*$R$21)","v":9.0272000000000005E-2},{"$f":"IF(I_PLAN=\"FMV\",\"\",Q15*$N$14)","v":4513.6000000000004},1,null,12,{"$f":"IF($N$15=0,0,INDEX($U$5:$Y$10,$N$15,S15)*$R$21)","v":7.5399999999999995E-2},{"$f":"IF(V15=0,\"\",V15*$N$14)","v":3769.9999999999995}]
["Input_13","Dealer profile","State",null,"Changed",null,"IN",null,null,null,null,null,"$1,000 - $3,001",{"$f":"IF(AND($N$14>=1000,$N$14<3000),1,\"\")","v":""},null,24,{"$f":"IF($N$15=0,0,INDEX($O$5:$S$10,$N$15,S16)*$R$21)","v":4.6800000000000001E-2},{"$f":"IF(I_PLAN=\"FMV\",\"\",Q16*$N$14)","v":2340},2,null,24,{"$f":"IF($N$15=0,0,INDEX($U$5:$Y$10,$N$15,S16)*$R$21)","v":4.0975999999999999E-2},{"$f":"IF(V16=0,\"\",V16*$N$14)","v":2048.7999999999997}]
["Input_14","Dealer profile","Zip",null,1,null,"IA",null,null,null,null,null,"$3,001 - $10,000",{"$f":"IF(AND($N$14>=3000,$N$14<10000),2,\"\")","v":""},null,36,{"$f":"IF($N$15=0,0,INDEX($O$5:$S$10,$N$15,S17)*$R$21)","v":3.2552000000000005E-2},{"$f":"IF(I_PLAN=\"FMV\",\"\",Q17*$N$14)","v":1627.6000000000001},3,null,36,{"$f":"IF($N$15=0,0,INDEX($U$5:$Y$10,$N$15,S17)*$R$21)","v":2.9640000000000003E-2},{"$f":"IF(V17=0,\"\",V17*$N$14)","v":1482.0000000000002}]
["Input_15","Dealer profile","Sales Contact Phone",null,null,null,"KS",null,null,null,null,null,"$10,001 - $20,000",{"$f":"IF(AND($N$14>=10000,$N$14<=20000),3,\"\")","v":""},null,48,{"$f":"IF($N$15=0,0,INDEX($O$5:$S$10,$N$15,S18)*$R$21)","v":2.5480000000000003E-2},{"$f":"IF(I_PLAN=\"FMV\",\"\",IF(Q18=0,\"\",Q18*$N$14))","v":1274.0000000000002},4,null,48,{"$f":"IF($N$15=0,0,INDEX($U$5:$Y$10,$N$15,S18)*$R$21)","v":2.4128E-2},{"$f":"IF(V18=0,\"\",V18*$N$14)","v":1206.4000000000001}]
["Input_16","Dealer profile","Sales Contact Email",null,null,null,"KY",null,null,null,null,null,"$20,001 - $25,000",{"$f":"IF(AND($N$14>=20000,$N$14<25000),4,\"\")","v":""},null,60,{"$f":"IF($N$15=0,0,INDEX($O$5:$S$10,$N$15,S19)*$R$21)","v":2.1320000000000002E-2},{"$f":"IF(I_PLAN=\"FMV\",\"\",IF(Q19=0,\"\",Q19*$N$14))","v":1066},5,null,60,{"$f":"IF($N$15=0,0,INDEX($U$5:$Y$10,$N$15,S19)*$R$21)","v":2.0592000000000003E-2},{"$f":"IF(V19=0,\"\",V19*$N$14)","v":1029.6000000000001}]
["Input_17","Equipment description","Equipment description",null,0,{"$f":"128-v_input_17_sym&\" symbols remaining\"","v":"128 symbols remaining"},"LA",null,null,null,null,null,"$25,001 - $50,000",{"$f":"IF(AND($N$14>=25000,$N$14<50000),5,\"\")","v":""}]
["Input_18","Cost Builder","Equipment Cost",50000,null,null,"ME",null,null,null,null,null,"Over $50,000",{"$f":"IF($N$14>=50000,6,\"\")","v":6},null,"Commission Points",null,{"$f":"IF(v_Input_25=\"\",1,VLOOKUP(v_Input_25,$P$22:$Q$27,2,0))","v":1}]
["Input_19","Cost Builder","Software  Costs",null,null,null,"MD",null,null,null,null,null,null,null,null,"0 Points",1]
["Input_20","Cost Builder","Soft  Costs",null,null,null,"MA",null,null,null,null,null,"Monthly payment",0,null,"1 Point",1.01]
["Input_21","Cost Builder","Other Costs",null,null,null,"MI",null,null,null,null,null,null,null,null,"2 Points",1.02]
[null,"Cost Builder","Total Costs",0,null,null,"MN",null,null,null,null,null,null,null,null,"3 Points",1.03]
["Input_22","Payment Builder","Finance Term",null,null,null,"MS",null,null,null,null,null,null,null,null,"4 Points",1.04]
["Input_23","Payment Builder","Finance Plan",null,null,null,"MO",null,null,null,null,null,null,{"$f":"PAYMENT_SELECTION","v":0},null,"5 Points",1.05]
["Input_24","Payment Builder","Advance Payments",null,null,null,"MT"]
["Input_25","Payment Builder","Commission Points",null,null,null,"NE",null,null,null,null,null,null,null,null,null,"PO","FMV"]
[null,null,null,null,null,null,"NV",null,null,null,null,null,null,null,null,null,4513.6000000000004,3769.9999999999995]
["Input_26","NAVITAS Contact Information","Representitative Name ","Amy Whipple",null,null,"NH",null,null,null,null,null,null,null,null,null,2340,2048.7999999999997]
["Input_27","NAVITAS Contact Information","Tittle ","Certified Financing Professional",null,null,"NJ",null,null,null,null,null,null,null,null,null,1627.6000000000001,1482.0000000000002]
["Input_28","NAVITAS Contact Information","Phone Number                   ","904-543-2575 x 208",null,null,"NM",null,null,null,null,null,null,null,null,null,1274.0000000000002,1206.4000000000001]
["Input_29","NAVITAS Contact Information","Fax Number","904-543-2574",null,null,"NY",null,null,null,null,null,null,null,null,null,1066,1029.6000000000001]
["Input_30","NAVITAS Contact Information","Email","amywhipple@navitaslease.com",null,null,"NC"]
[null,null,null,null,null,null,"ND"]
["Customer Finance Proposal",null,null,null,null,null,"OH"]
[{"$f":"v_Input_1&CHAR(13)&v_Input_2&\" \"&v_Input_2a&CHAR(13)&v_Input_3&CHAR(13)&v_Input_4&\", \"&v_Input_5&\" \"&v_Input_6&CHAR(13)&v_Input_7&CHAR(13)&v_Input_8","v":"A\rB \r\r,  \rc\rd"},null,null,null," ",null,"OK"]
[{"$f":"\"Dear \"&v_Input_2&\",\"","v":"Dear B,"},null,"Current Selection","Initial Selection","12 Months",1,"OR"]
["Initial selection",{"$f":"IF(OR(I_TERM=\"\",I_TERM=\"All Terms\",I_PLAN=\"\",I_PLAN=\"Both plans\"),\"\",\"Choise_\"&VLOOKUP(I_PLAN,E45:F46,2,0)&\"_\"&VLOOKUP(I_TERM,E39:F43,2,0))","v":"Choise_1_3"},{"$f":"IF(OR(AND(I_TERM=\"All Terms\",CURR_CHOISE=\"\"),AND(I_TERM=\"All Terms\",CHANGED=0)),\"\",OFFSET(LIST_INPUT_22,RIGHT(CURR_CHOISE,1)-1,0))","v":{"$error":"#VALUE!"}},"36 Months","24 Months",2,"PA"]
["Current selection",null,{"$f":"IF(OR(AND(I_PLAN=\"Both Plans\",CURR_CHOISE=\"\",),AND(I_PLAN=\"Both Plans\",CHANGED=0)),\"\",IF(RIGHT(LEFT(CURR_CHOISE,8),1)=\"2\",\"Fair Market Value\",\"$1 Buyout\"))","v":"$1 Buyout"},"$1 Buyout","36 Months",3,"RI"]
[null,null,1,null,"48 Months",4,"SC"]
[{"$f":"v_Input_9&CHAR(13)&v_Input_10&CHAR(13)&v_Input_11&CHAR(13)&v_Input_12&\", \"&v_Input_13&\" \"&v_Input_14&CHAR(13)&v_Input_15&CHAR(13)&v_Input_16","v":"\r\r\r,  \r\r"},null,null,{"$f":"IF(OR(I_TERM=\"\",I_TERM=\"All Terms\",I_PLAN=\"\"),\"\",\"Choise_1_\"&VLOOKUP(I_TERM,E39:F43,2,0))","v":"Choise_1_3"},"60 Months",5,"SD"]
[{"$f":"\"Navitas Lease Corp.\"&CHAR(13)&v_Input_26&CHAR(13)&v_Input_27&CHAR(13)&\"T: \"&v_Input_28&CHAR(13)&\"F: \"&v_Input_29&CHAR(13)&v_Input_30","v":"Navitas Lease Corp.\rAmy Whipple\rCertified Financing Professional\rT: 904-543-2575 x 208\rF: 904-543-2574\ramywhipple@navitaslease.com"},null,null,{"$f":"IF(OR(I_TERM=\"\",I_TERM=\"All Terms\",I_PLAN=\"\"),\"\",\"Choise_2_\"&VLOOKUP(I_TERM,E39:F43,2,0))","v":"Choise_2_3"}," ",null,"TN"]
[null,null,null,null,"$1 Buyout",1,"TX"]
["Express Application",null,null,null,"FMV",2,"UT"]
["START_DATE","Lessee information","Business Start Date",null,null,null,"VT"]
["Input_31","Lessee information","Company Name","B",null,null,"VA"]
["Input_32","Lessee information","Street Address",null,null,null,"WA"]
["Input_33","Lessee information","City",null,null,null,"WV"]
["Input_34","Lessee information","State",null,null,null,"WI"]
["Input_35","Lessee information","Zip",null,null,null,"WY"]
["Input_36","Lessee information","Telephone Number","c"]
["Input_37","Lessee information","Contact Name","A"]
["Input_38","Lessee information","Email","d"]
["Input_38a","Lessee information","Federal Tax Number"]
["Input_39","Business Owner Personal Profile","Principal Name"]
["Input_40","Business Owner Personal Profile","Street Address"]
["Input_41","Business Owner Personal Profile","City"]
["Input_42","Business Owner Personal Profile","State"]
["Input_43","Business Owner Personal Profile","Zip"]
["Input_44","Business Owner Personal Profile","Tittle"]
["Input_45","Business Owner Personal Profile","Telephone Number"]
["Input_46","Business Owner Personal Profile","Social Security"]
["Input_47","Business Owner Personal Profile","Ownership"]
[]
["Autopopulate Express Application"]
["Input_31","Input_1","Company Name",{"$f":"v_Input_1","v":"A"}]
["Input_32","Input_3","Street Address",{"$f":"v_Input_3","v":0}]
["Input_33","Input_4","City",{"$f":"v_Input_4","v":0}]
["Input_34","Input_5","State",{"$f":"v_Input_5","v":0}]
["Input_35","Input_6","Zip",{"$f":"v_Input_6","v":0}]
["Input_37","Input_2 and Input 2a","Contact Name",{"$f":"v_Input_2&\" \"&v_Input_2a","v":"B "}]
["Input_38","Input_8","Email",{"$f":"v_Input_8","v":"d"}]
["Input_36","Input_7","Telephone Number",{"$f":"v_Input_7","v":"c"}]
[]
["Email #1 Acceprt Quote"]
["To",{"$f":"p_Input_38","v":"d"},{"$f":"v_Input_30","v":"amywhipple@navitaslease.com"}]
["Subject","Financing Quote Acceptance"]
["Attachment"]
["Body",{"$f":"\"This email signifies my selection of the attached financing quote provided to my company. I would like to move forward and take the necessary next steps. Please contact me at your earliest convenience. I look forward to hearing from you.\"","v":"This email signifies my selection of the attached financing quote provided to my company. I would like to move forward and take the necessary next steps. Please contact me at your earliest convenience. I look forward to hearing from you."},null,null," "]
["Email #2 Submit Application"]
["To",{"$f":"v_Input_30","v":"amywhipple@navitaslease.com"},{"$f":"v_Input_16","v":0},{"$f":"email_1_to3","v":0}]
["Subject","Financing Credit Application Submittal"]
["Attachment"]
["Body",{"$f":"\"This email contains my finance application. Please contact me with any additional information you may require. I look forward to hearing from you.\"","v":"This email contains my finance application. Please contact me with any additional information you may require. I look forward to hearing from you."},null,null," "]
[]
["Email #3 Acceprt Quote"]
["To",{"$f":"v_Input_30","v":"amywhipple@navitaslease.com"},{"$f":"v_Input_16","v":0},{"$f":"email_1_to3","v":0}]
["Subject","Equipment Financing Quote"]
["Body","Thank you for your interest in financing our equipment\nsolution. Attached you will find our affordable monthly payment options to\nselect from. Choose the payment that best meets your budget and email back\nto us at your earliest convenience. To expedite the process, please\ncomplete the credit application that is included with your quote. \n\n\n\nPLEASE NOTE: AFTER YOU OPEN THE ATTACHMENT PLEASE RENAME IT AND SAVE IT\nBEFORE REPLYING.",null,null," "]