{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Welcome","Checklist","Your Company Details","Your Classes","Your Stamps","Your User Details","Extract Data","LMS Upload","Keys"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Welcome","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Carrier Onboarding Form"]
[]
[null,null,null,null,"This form is designed to facilitate your PPL onboarding experience. \nIf you have a query whilst completing the form, please refer to the guidance notes \nbefore contacting one of our onboarding coordinators."]
[null,null,null,null,"To contact one of our onboarding coordinators, please email us at:"]
[null,null,null,null,"pplenquiries@placingplatformlimited.com"]
[]
[]
[null,null,null,null,"Please ensure you are using the latest version of this onboarding form. "]
[null,null,null,null,"To download the latest version of this form and/or the guidance notes, please visit:"]
[null,null,null,null,"https://www.placingplatformlimited.com/useful-information"]
[]
[null,null,null,null,"Please enable the content of this form if asked to do so"]
[null,null,null,null,"This form contains dynamic content that depends on your responses. Enabling content will ensure the form works as intended"]

{"sheet":"Checklist","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Checklist"]
[]
[null,"Overall Onboarding progress",{"$f":"SUM(C6:C12)/4","v":0},{"$f":"IF(C4>99.9%,1,0)","v":0}]
[null,"This list will automatically populate to reflect your answers in the following tabs:"]
[null,"Your Company Details",{"$f":"'Your Company Details'!E4","v":0},{"$f":"IF(C6>99.6%,1,0)","v":0}]
[null,{"$f":"IF(D6=1,\"Thank you for completing this section\",\"You need to provide the full set of information and all the contacts required\")","v":"You need to provide the full set of information and all the contacts required"}]
[null,"Your Classes",{"$f":"'Your Classes'!E4","v":0},{"$f":"IF(C8>99.5%,1,0)","v":0}]
[null,{"$f":"IF(C8=100%,\"Thank you for completing this section\",\"Please ensure you have answered all the questions\")","v":"Please ensure you have answered all the questions"}]
[null,"Your Stamps",{"$f":"'Your Stamps'!M9","v":0},{"$f":"IF(C10>99.9%,1,0)","v":0}]
[null,{"$f":"IF(C10,\"Thank you for completing this section\",\"You need to add at least one stamp\")","v":"You need to add at least one stamp"}]
[null,"Your User Details",{"$f":"'Your User Details'!V75","v":0},{"$f":"IF(C12>99.9%,1,0)","v":0}]
[null,{"$f":"IF(C12,\"Thank you for completing this section\",\"You need to add at least one team and one user\")","v":"You need to add at least one team and one user"}]

{"sheet":"Your Company Details","index":2,"n_rows":162,"n_cols":7,"rows_kept":162,"cut":false,"hidden":false,"merged":[[172,1,172,3],[174,1,174,3],[176,1,176,3],[178,1,178,3],[160,1,160,3],[162,1,162,3],[164,1,164,3],[166,1,166,3],[168,1,168,3],[170,1,170,3]]}
[]
[null,"Your Company Details"]
[null,"Carrier Setup Form",null,null,"Progress"]
[null,"Once we have your completed form we will create your accounts. If we require more information, we will contact you.",null,null,{"$f":"G162/100","v":0}]
[]
[null,"Section 1: Information about your company"]
[]
[null,1.1000000000000001,"Registered Company Name:",null,{"$f":"IF(ISBLANK(D8),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D8),\"Please add your registered company name\",\"This is how your company will be displayed on PPL\")","v":"Please add your registered company name"},{"$f":"IF(ISBLANK(D8),\"0\",2.0833)","v":"0"}]
[null,1.2,"Company Address:"]
[null,null,"Address Line 1:",null,{"$f":"IF(ISBLANK(D10),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D10),\"Please add your company address\",\"\")","v":"Please add your company address"},{"$f":"IF(ISBLANK(D10),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Address Line 2:"]
[]
[null,null,"City",null,{"$f":"IF(ISBLANK(D14),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D14),\"Please add your city\",\"\")","v":"Please add your city"},{"$f":"IF(ISBLANK(D14),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Region"]
[]
[null,null,"Postcode",null,{"$f":"IF(ISBLANK(D18),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D18),\"Please add your Postcode\",\"\")","v":"Please add your Postcode"},{"$f":"IF(ISBLANK(D18),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Country","Please select",{"$f":"IF(D20=\"Please select\",\"û\",\"ü\")","v":"û"},{"$f":"IF(D20=\"Please select\",\"Please select your country\",\"\")","v":"Please select your country"},{"$f":"IF(D20=\"Please select\",0,2.0833)","v":0}]
[]
[null,1.3,"Company Logo:\nIf you wish your company logo to be \ndisplayed on the platform, please \npaste it here or send by email separately."]
[]
[null,1.4,"Are you member of an association?","Please select",{"$f":"IF(D24=\"Please select\",\"û\",\"ü\")","v":"û"},{"$f":"IF(D24=\"Please select\",\"Please confirm whether you are a member of an association\",\"\")","v":"Please confirm whether you are a member of an association"},{"$f":"IF(D24=\"Please select\",0,2.0833)","v":0}]
[]
[null,null,"If yes, which association?"]
[]
[null,"Section 2: PPL Contacts"]
[]
[null,"PPL Approval contacts:"]
[]
[null,"Approvers will authorise:",null,"Required and involved in providing authorisation:  \n• to users moving teams and account upgrades to Full Binding or Facility Admin (Manage Users) etc.\nIt is encouraged that you nominate 2 approvers."]
[null,null,null,"• new users setup;\n- if new users require approval, approvers will be contacted before they are setup. \n- if approval is not required, approvers will be notified by email after new users have been setup."]
[]
[null,"Is approval required to setup new users?",null,"Please select",{"$f":"IF(D35=\"Please select\",\"û\",\"ü\")","v":"û"},{"$f":"IF(D35=\"Please select\",\"Please confirm if an approval is required before setting up new users\",\"\")","v":"Please confirm if an approval is required before setting up new users"},{"$f":"IF($D35=\"Yes\",\"2.0833\",IF($D35=\"No\",\"2.0833\",IF($D35=\"Please select\",\"0\")))","v":"0"}]
[]
[null,2.1,"Primary Approver"]
[]
[null,null,"First name:",null,{"$f":"IF(ISBLANK(D39),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D39),\"Please confirm the first name of your Primary Approver\",\"\")","v":"Please confirm the first name of your Primary Approver"},{"$f":"IF(ISBLANK(D39),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last name:",null,{"$f":"IF(ISBLANK(D41),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D41),\"Please confirm the last name of your Primary Approver\",\"\")","v":"Please confirm the last name of your Primary Approver"},{"$f":"IF(ISBLANK(D41),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D43),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D43),\"Please confirm the email address of your Primary Approver\",\"\")","v":"Please confirm the email address of your Primary Approver"},{"$f":"IF(ISBLANK(D43),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D45),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D45),\"Please confirm the telephone number of your Primary Approver\",\"\")","v":"Please confirm the telephone number of your Primary Approver"},{"$f":"IF(ISBLANK(D45),\"0\",2.0833)","v":"0"}]
[]
[null,2.2000000000000002,"Secondary Approver"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D49),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D49),\"Please confirm the first name of your Secondary Approver\",\"\")","v":"Please confirm the first name of your Secondary Approver"},{"$f":"IF(ISBLANK(D49),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D51),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D51),\"Please confirm the last name of your Secondary Approver\",\"\")","v":"Please confirm the last name of your Secondary Approver"},{"$f":"IF(ISBLANK(D51),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D53),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D53),\"Please confirm the email address of your Secondary Approver\",\"\")","v":"Please confirm the email address of your Secondary Approver"},{"$f":"IF(ISBLANK(D53),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D55),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D55),\"Please confirm the telephone number of your Secondary Approver\",\"\")","v":"Please confirm the telephone number of your Secondary Approver"},{"$f":"IF(ISBLANK(D55),\"0\",2.0833)","v":"0"}]
[]
[null,"PPL contacts:"]
[]
[null,2.2999999999999998,"PPL Sponsor"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D61),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D61),\"Please confirm the first name of your PPL Sponsor\",\"\")","v":"Please confirm the first name of your PPL Sponsor"},{"$f":"IF(ISBLANK(D61),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D63),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D63),\"Please confirm the last name of your PPL Sponsor\",\"\")","v":"Please confirm the last name of your PPL Sponsor"},{"$f":"IF(ISBLANK(D63),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D65),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D65),\"Please confirm the email address of your PPL Sponsor\",\"\")","v":"Please confirm the email address of your PPL Sponsor"},{"$f":"IF(ISBLANK(D65),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D67),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D67),\"Please confirm the email address of your PPL Sponsor\",\"\")","v":"Please confirm the email address of your PPL Sponsor"},{"$f":"IF(ISBLANK(D67),\"0\",2.0833)","v":"0"}]
[]
[]
[null,2.4,"PPL C-Suite"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D72),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D72),\"Please confirm the first name of your C-Suite Contact\",\"\")","v":"Please confirm the first name of your C-Suite Contact"},{"$f":"IF(ISBLANK(D72),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D74),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D74),\"Please confirm the last name of your C-Suite of Contact\",\"\")","v":"Please confirm the last name of your C-Suite of Contact"},{"$f":"IF(ISBLANK(D74),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D76),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D76),\"Please confirm the email address of your PPL C-Suite Contact\",\"\")","v":"Please confirm the email address of your PPL C-Suite Contact"},{"$f":"IF(ISBLANK(D76),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D78),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D78),\"Please confirm the telephone number of your C-Suite Contact\",\"\")","v":"Please confirm the telephone number of your C-Suite Contact"},{"$f":"IF(ISBLANK(D78),\"0\",2.0833)","v":"0"}]
[]
[]
[null,2.5,"PPL Point of Contact"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D83),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D83),\"Please confirm the first name of your PPL Point of Contact\",\"\")","v":"Please confirm the first name of your PPL Point of Contact"},{"$f":"IF(ISBLANK(D83),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D85),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D85),\"Please confirm the last name of your PPL Point of Contact\",\"\")","v":"Please confirm the last name of your PPL Point of Contact"},{"$f":"IF(ISBLANK(D85),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D87),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D87),\"Please confirm the email address of your PPL Point of Contact\",\"\")","v":"Please confirm the email address of your PPL Point of Contact"},{"$f":"IF(ISBLANK(D87),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D89),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D89),\"Please confirm the telephone number of your PPL Point of Contact\",\"\")","v":"Please confirm the telephone number of your PPL Point of Contact"},{"$f":"IF(ISBLANK(D89),\"0\",2.0833)","v":"0"}]
[]
[]
[null,"Finance Manager contact:"]
[]
[null,2.6,"Finance Manager"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D96),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D96),\"Please confirm the first name of your Finance Manager\",\"\")","v":"Please confirm the first name of your Finance Manager"},{"$f":"IF(ISBLANK(D96),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D98),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D98),\"Please confirm the last name of your Finance Manager\",\"\")","v":"Please confirm the last name of your Finance Manager"},{"$f":"IF(ISBLANK(D98),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D100),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D100),\"Please confirm the email address of your Finance Manager\",\"\")","v":"Please confirm the email address of your Finance Manager"},{"$f":"IF(ISBLANK(D100),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D102),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D102),\"Please confirm the telephone number of your Finance Manager\",\"\")","v":"Please confirm the telephone number of your Finance Manager"},{"$f":"IF(ISBLANK(D102),\"0\",2.0833)","v":"0"}]
[]
[]
[null,"Publicity contact:",null,null,null,null,"Publicity contact"]
[]
[null,2.7,"PPL contact name at your firm who will be listed on the PPL website"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D109),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D109),\"Please confirm the first name of your Publicity Contact\",\"\")","v":"Please confirm the first name of your Publicity Contact"},{"$f":"IF(ISBLANK(D109),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D111),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D111),\"Please confirm the last name of your Publicity Contact\",\"\")","v":"Please confirm the last name of your Publicity Contact"},{"$f":"IF(ISBLANK(D111),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D113),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D113),\"Please confirm the email address of your Publicity Contact\",\"\")","v":"Please confirm the email address of your Publicity Contact"},{"$f":"IF(ISBLANK(D113),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D115),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D115),\"Please confirm the telephone number of your Publicity Contact\",\"\")","v":"Please confirm the telephone number of your Publicity Contact"},{"$f":"IF(ISBLANK(D115),\"0\",2.0833)","v":"0"}]
[]
[]
[null,"Business as usual contact (BAU):"]
[null,null,null,null,null,null,"BAU contact"]
[null,2.8,"PPL contact name at your firm who will be the main contact for BAU queries:"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D122),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D122),\"Please confirm the first name of your Publicity Contact\",\"\")","v":"Please confirm the first name of your Publicity Contact"},{"$f":"IF(ISBLANK(D122),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D124),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D124),\"Please confirm the last name of your Publicity Contact\",\"\")","v":"Please confirm the last name of your Publicity Contact"},{"$f":"IF(ISBLANK(D124),\"0\",2.0849)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D126),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D126),\"Please confirm the email address of your Publicity Contact\",\"\")","v":"Please confirm the email address of your Publicity Contact"},{"$f":"IF(ISBLANK(D126),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D128),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D128),\"Please confirm the telephone number of your Publicity Contact\",\"\")","v":"Please confirm the telephone number of your Publicity Contact"},{"$f":"IF(ISBLANK(D128),\"0\",2.0833)","v":"0"}]
[]
[]
[null,"Data Protection Officer (DPO):",null,null,null,null,"Data Protection Officer"]
[]
[null,2.9,"PPL contact name at your firm who will be the main contact for data protection queries:"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D135),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D135),\"Please confirm the first name of your Data Protection Officer\",\"\")","v":"Please confirm the first name of your Data Protection Officer"},{"$f":"IF(ISBLANK(D135),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D137),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D137),\"Please confirm the last name of your Data Protection Officer\",\"\")","v":"Please confirm the last name of your Data Protection Officer"},{"$f":"IF(ISBLANK(D137),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D139),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D139),\"Please confirm the email address of your Data Protection Officer\",\"\")","v":"Please confirm the email address of your Data Protection Officer"},{"$f":"IF(ISBLANK(D139),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D141),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D141),\"Please confirm the telephone number of your Data Protection Officer\",\"\")","v":"Please confirm the telephone number of your Data Protection Officer"},{"$f":"IF(ISBLANK(D141),\"0\",2.0833)","v":"0"}]
[]
[]
[null,"In-house Training:"]
[]
[null,"Do you have in-house training capabilities?",null,"Please select",{"$f":"IF(D146=\"Please select\",\"û\",\"ü\")","v":"û"},{"$f":"IF(D146=\"Please select\",\"Please confirm whether you have an in-house trainer\",\"\")","v":"Please confirm whether you have an in-house trainer"},{"$f":"IF($D146=\"Yes\",\"2.0833\",IF($D146=\"No\",\"10.4167\",IF($D146=\"Please select\",\"0\")))","v":"0"}]
[null,null,null,null,null,null,"In-house trainer"]
[null,"2.10","PPL contact name at your firm who will be the main contact for in-house training:"]
[]
[null,null,"First Name:",null,{"$f":"IF(ISBLANK(D150),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D150),\"Please confirm the first name of your in-house trainer\",\"\")","v":"Please confirm the first name of your in-house trainer"},{"$f":"IF(ISBLANK(D150),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Last Name:",null,{"$f":"IF(ISBLANK(D152),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D152),\"Please confirm the last name of your in-house trainer\",\"\")","v":"Please confirm the last name of your in-house trainer"},{"$f":"IF(ISBLANK(D152),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Email address:",null,{"$f":"IF(ISBLANK(D154),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D154),\"Please confirm the email address of your in-house trainer\",\"\")","v":"Please confirm the email address of your in-house trainer"},{"$f":"IF(ISBLANK(D154),\"0\",2.0833)","v":"0"}]
[]
[null,null,"Telephone number:",null,{"$f":"IF(ISBLANK(D156),\"û\",\"ü\")","v":"û"},{"$f":"IF(ISBLANK(D156),\"Please confirm the telephone number of your in-house trainer\",\"\")","v":"Please confirm the telephone number of your in-house trainer"},{"$f":"IF(ISBLANK(D156),\"0\",2.0833)","v":"0"}]
[]
[null,"Section 3: Line Conditions"]
[null,"Add you Line Conditions below:"]
[]
[]
[null,null,null,null,null,null,{"$f":"G156+G154+G152+G150+G146+G141+G139+G137+G135+G128+G126+G124+G122+G115+G113+G111+G109+G102+G100+G98+G96+G89+G87+G85+G83+G78+G76+G74+G72+G67+G65+G63+G61+G55+G53+G51+G49+G45+G43+G41+G39+G35+G24+G20+G18+G14+G10+G8","v":0}]

{"sheet":"Your Classes","index":3,"n_rows":142,"n_cols":6,"rows_kept":142,"cut":false,"hidden":false,"merged":[[12,1,12,2],[30,1,30,2],[38,1,38,2],[49,1,49,2],[58,1,58,2],[68,1,68,2],[83,1,83,2],[88,1,88,2],[102,1,102,2],[139,1,139,2],[112,1,112,2],[121,1,121,2],[126,1,126,2],[131,1,131,2]]}
[]
[null,"Your General Information"]
[null,"Please tell us about the classes you write:",null,null,"Progress"]
[null,null,null,null,{"$f":"F142/100","v":0}]
[]
[]
[null,"Accident & Health (A&H)","Please select",null,{"$f":"IF(C7=\"yes\",\"ü\",IF(C7=\"No\",\"ü\",IF(C7=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C7=\"Yes\",\"3\",IF($C7=\"No\",\"6\",IF($E7=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Personal Accident (including Travel)?","Please select",null,{"$f":"IF(C9=\"yes\",\"ü\",IF(C9=\"No\",\"ü\",IF(C9=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E9=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Contingency?","Please select",null,{"$f":"IF(C10=\"yes\",\"ü\",IF(C10=\"No\",\"ü\",IF(C10=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E10=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your A&H department?","Please select",null,{"$f":"IF(C11=\"yes\",\"ü\",IF(C11=\"No\",\"ü\",IF(C11=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E11=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Aviation","Please select",null,{"$f":"IF(C15=\"yes\",\"ü\",IF(C15=\"No\",\"ü\",IF(C15=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C15=\"Yes\",\"3\",IF($C15=\"No\",\"16\",IF($E15=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Satellite/Space?","Please select",null,{"$f":"IF(C17=\"yes\",\"ü\",IF(C17=\"No\",\"ü\",IF(C17=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E17=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"General Aviation?","Please select",null,"û","0"]
[null,"Airlines?","Please select",null,"û","0"]
[null,"Hull Deductible?","Please select",null,"û","0"]
[null,"Hull War?","Please select",null,"û","0"]
[null,"Excess War Liability?","Please select",null,"û","0"]
[null,"Products Liability?","Please select",null,"û","0"]
[null,"Airport Liability?","Please select",null,"û","0"]
[null,"Contingent Aviation?","Please select",null,"û","0"]
[null,"Contingent Hull?","Please select",null,"û","0"]
[null,"Contingent Liability?","Please select",null,"û","0"]
[null,"Bank / Lessors?","Please select",null,"û","0"]
[null,"Any other classes within your Aviation department?","Please select",null,"û","0"]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Bloodstock/Livestock (B/L)","Please select",null,{"$f":"IF(C33=\"yes\",\"ü\",IF(C33=\"No\",\"ü\",IF(C33=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C33=\"Yes\",\"3\",IF($C33=\"No\",\"6\",IF($E33=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Bloodstock","Please select",null,{"$f":"IF(C35=\"yes\",\"ü\",IF(C35=\"No\",\"ü\",IF(C35=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E35=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Livestock","Please select",null,{"$f":"IF(C36=\"yes\",\"ü\",IF(C36=\"No\",\"ü\",IF(C36=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E36=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your B/L department?","Please select",null,{"$f":"IF(C37=\"yes\",\"ü\",IF(C37=\"No\",\"ü\",IF(C37=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E37=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Casualty","Please select",null,{"$f":"IF(C41=\"yes\",\"ü\",IF(C41=\"No\",\"ü\",IF(C41=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C41=\"Yes\",\"3\",IF($C41=\"No\",\"9\",IF($E41=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"General Liability?","Please select",null,{"$f":"IF(C43=\"yes\",\"ü\",IF(C43=\"No\",\"ü\",IF(C43=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E43=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Employers' Liability/WCA?","Please select",null,"û","0"]
[null,"Public Liability?","Please select",null,"û","0"]
[null,"Product Liability?","Please select",null,"û","0"]
[null,"Medical Malpractice?","Please select",null,"û","0"]
[null,"Any other classes within your Casualty department?","Please select",null,"û","0"]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Construction","Please select",null,{"$f":"IF(C52=\"yes\",\"ü\",IF(C52=\"No\",\"ü\",IF(C52=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C52=\"Yes\",\"3\",IF($C52=\"No\",\"7\",IF($E52=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Onshore Construction?","Please select",null,{"$f":"IF(C54=\"yes\",\"ü\",IF(C54=\"No\",\"ü\",IF(C54=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E54=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Offshore Construction?","Please select",null,{"$f":"IF(C55=\"yes\",\"ü\",IF(C55=\"No\",\"ü\",IF(C55=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E55=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Mining?","Please select",null,{"$f":"IF(C56=\"yes\",\"ü\",IF(C56=\"No\",\"ü\",IF(C56=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E56=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your Construction department?","Please select",null,{"$f":"IF(C57=\"yes\",\"ü\",IF(C57=\"No\",\"ü\",IF(C57=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E57=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Energy","Please select",null,{"$f":"IF(C61=\"yes\",\"ü\",IF(C61=\"No\",\"ü\",IF(C61=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C61=\"Yes\",\"3\",IF($C61=\"No\",\"8\",IF($E61=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Onshore Energy?","Please select",null,{"$f":"IF(C63=\"yes\",\"ü\",IF(C63=\"No\",\"ü\",IF(C63=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E63=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Offshore Energy?","Please select",null,{"$f":"IF(C64=\"yes\",\"ü\",IF(C64=\"No\",\"ü\",IF(C64=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E64=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Energy Liability?","Please select",null,{"$f":"IF(C65=\"yes\",\"ü\",IF(C65=\"No\",\"ü\",IF(C65=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E65=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Power (Including Nuclear)?","Please select",null,{"$f":"IF(C66=\"yes\",\"ü\",IF(C66=\"No\",\"ü\",IF(C66=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E66=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your Energy department?","Please select",null,{"$f":"IF(C67=\"yes\",\"ü\",IF(C67=\"No\",\"ü\",IF(C67=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E67=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Facilities","Please select",null,{"$f":"IF(C71=\"yes\",\"ü\",IF(C71=\"No\",\"ü\",IF(C71=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C71=\"Yes\",\"1\",IF($C71=\"No\",\"2\",IF($E71=\"û\",\"0\")))","v":"0"}]
[null,"What percentage of your Facilities business are Binders?",null,null,{"$f":"IF(ISBLANK(C72),\"û\",\"ü\")","v":"û"},{"$f":"IF($E72=\"ü\",\"1\",\"0\")","v":"0"}]
[]
[null,"Financial and Professional Lines (FPL)","Please select",null,{"$f":"IF(C74=\"yes\",\"ü\",IF(C74=\"No\",\"ü\",IF(C74=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C74=\"Yes\",\"3\",IF($C74=\"No\",\"10\",IF($E74=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Directors and Officers (D&O)?","Please select",null,{"$f":"IF(C76=\"yes\",\"ü\",IF(C76=\"No\",\"ü\",IF(C76=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E76=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Financial Institutions (FI)?","Please select",null,"û","0"]
[null,"Professional Liability (PL)?","Please select",null,"û","0"]
[null,"Cyber?","Please select",null,"û","0"]
[null,"Medical Malpractice?","Please select",null,"û","0"]
[null,"Healthcare?","Please select",null,"û","0"]
[null,"Any other classes within your FPL department?","Please select",null,"û","0"]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Kidnap & Ransom","Please select",null,{"$f":"IF(C86=\"yes\",\"ü\",IF(C86=\"No\",\"ü\",IF(C86=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C86=\"Yes\",\"1\",IF($C86=\"No\",\"2\",IF($E86=\"û\",\"0\")))","v":"0"}]
[null,"Do you place any other classes within your K&R department?","Please select",null,{"$f":"IF(C87=\"yes\",\"ü\",IF(C87=\"No\",\"ü\",IF(C87=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E87=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Marine","Please select",null,{"$f":"IF(C91=\"yes\",\"ü\",IF(C91=\"No\",\"ü\",IF(C91=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C91=\"Yes\",\"1\",IF($C91=\"No\",\"10\",IF($E91=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Hull?","Please select",null,{"$f":"IF(C93=\"yes\",\"ü\",IF(C93=\"No\",\"ü\",IF(C93=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E93=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Marine Construction?","Please select",null,"û","0"]
[null,"War?","Please select",null,"û","0"]
[null,"Yacht?","Please select",null,"û","0"]
[null,"Cargo?","Please select",null,"û","0"]
[null,"Marine Liability?","Please select",null,"û","0"]
[null,"Ports and Terminals?","Please select",null,"û","0"]
[null,"Specie (including fine arts, jewellers block \nand cash in transit?","Please select",null,"û","0"]
[null,"Any other classes within your Marine department?","Please select",null,"û","0"]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Political Risks","Please select",null,"û",{"$f":"IF($C105=\"Yes\",\"2\",IF($C105=\"No\",\"7\",IF($E105=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Political Risks?","Please select",null,"û",{"$f":"IF($E107=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Contract Frustration?","Please select",null,"û",{"$f":"IF($E108=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Trade Credit?","Please select",null,"û",{"$f":"IF($E109=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Financial Guarantee?","Please select",null,"û",{"$f":"IF($E110=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your Political Risks department?","Please select",null,"û",{"$f":"IF($E111=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Property","Please select",null,{"$f":"IF(C115=\"yes\",\"ü\",IF(C115=\"No\",\"ü\",IF(C115=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C115=\"Yes\",\"3\",IF($C115=\"No\",\"7\",IF($E115=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Non-Marine Property?","Please select",null,{"$f":"IF(C117=\"yes\",\"ü\",IF(C117=\"No\",\"ü\",IF(C117=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E117=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Product Recall?","Please select",null,{"$f":"IF(C118=\"yes\",\"ü\",IF(C118=\"No\",\"ü\",IF(C118=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E118=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Mining?","Please select",null,{"$f":"IF(C119=\"yes\",\"ü\",IF(C119=\"No\",\"ü\",IF(C119=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E119=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your Property department?","Please select",null,{"$f":"IF(C120=\"yes\",\"ü\",IF(C120=\"No\",\"ü\",IF(C120=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E120=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Real Estate","Please select",null,{"$f":"IF(C124=\"yes\",\"ü\",IF(C124=\"No\",\"ü\",IF(C124=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C124=\"Yes\",\"1\",IF($C124=\"No\",\"2\",IF($E124=\"û\",\"0\")))","v":"0"}]
[null,"Do you place any other classes within your Real Estate department?","Please select",null,"û",{"$f":"IF($E125=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Reinsurance","Please select",null,"û",{"$f":"IF($C129=\"Yes\",\"1\",IF($C129=\"No\",\"2\",IF($E129=\"û\",\"0\")))","v":"0"}]
[null,"Do you place any other classes within your Treaty Reinsurance department?","Please select",null,"û",{"$f":"IF($E130=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,"Terrorism","Please select",null,{"$f":"IF(C134=\"yes\",\"ü\",IF(C134=\"No\",\"ü\",IF(C134=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($C134=\"Yes\",\"3\",IF($C134=\"No\",\"6\",IF($E134=\"û\",\"0\")))","v":"0"}]
[null,"Do you write:","Please select","ç","Easy selection tool."]
[null,"Terrorism?","Please select",null,{"$f":"IF(C136=\"yes\",\"ü\",IF(C136=\"No\",\"ü\",IF(C136=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E136=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Political Violence?","Please select",null,{"$f":"IF(C137=\"yes\",\"ü\",IF(C137=\"No\",\"ü\",IF(C137=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E137=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"Any other classes within your Terrorism department?","Please select",null,{"$f":"IF(C138=\"yes\",\"ü\",IF(C138=\"No\",\"ü\",IF(C138=\"Please select\",\"û\")))","v":"û"},{"$f":"IF($E138=\"ü\",\"1\",\"0\")","v":"0"}]
[null,"If 'Yes', please list :"]
[]
[]
[null,null,null,null,null,{"$f":"F138+F137+F136+F134+F130+F129+F125+F124+F120+F119+F118+F117+F115+F111+F110+F109+F108+F107+F105+F101+F100+F99+F98+F97+F96+F95+F94+F93+F91+F87+F86+F82+F81+F80+F79+F78+F77+F76+F74+F71+F72+F67+F66+F65+F64+F63+F61+F57+F56+F55+F54+F52+F48+F47+F46+F45+F44+F43+F41+F37+F36+F35+F33+F29+F28+F27+F26+F25+F24+F23+F22+F21+F20+F19+F18+F17+F15+F11+F10+F9+F7","v":0}]

{"sheet":"Your Stamps","index":4,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Your Stamps"]
[]
[null,"Section 1: Your Stamps setup"]
[]
[null,"Please list the stamps you wish to have setup to accept risks including any codes:"]
[]
[null,"No","Display Name (max. 250)","DUNS","Lloyds code","LBS Code","LORS Code","LIRMA","ILU","Permitted Territory\n(See key below)",null,"No Characters"]
[null,"Stamp 1",null,null,null,null,null,null,null,null,null,{"$f":"LEN(C9)","v":0},{"$f":"IF(L9=0,0,1)","v":0}]
[null,"Stamp 2",null,null,null,null,null,null,null,null,null,{"$f":"LEN(C10)","v":0}]
[null,"Stamp 3",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 4",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 5",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 6",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 7",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 8",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 9",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 10",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 11",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 12",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 13",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 14",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 15",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 16",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 17",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 18",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 19",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 20",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 21",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 22",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 23",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 24",null,null,null,null,null,null,null,null,null,0]
[null,"Stamp 25",null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"Section 2: PPL / SDC Integration"]
[]
[null,"Please select your PPL / SDC configuration settings:"]
[null,"Please select here",{"$f":"IF(B40=Keys!M3,Keys!N3,IF(B40=Keys!M4,Keys!N4,IF(B40=Keys!M5,Keys!NI5,IF(B40=Keys!M6,Keys!N6,IF(B40=Keys!M2,Keys!N2)))))","v":"See key to SDC configuration below"}]
[]
[null,"Category","Definition"]
[null,"A - Elective","Our company is PPL/SDC member. All stamps are sent to SDC (including LIC)"]
[null,"B - Elective","Our company is PPL/SDC member. All stamps are sent to SDC (excluding LIC)"]
[null,"C - Non Elective","Our company is not a PPL/SDC member. But LIC stamps only are sent to SDC"]
[null,"D - Non Elective","Our company is not a PPL/SDC member. Nothing is sent to SDC"]
[]
[]
[null,"Section 3: Key to Permitted Territory"]

{"sheet":"Your User Details","index":5,"n_rows":124,"n_cols":22,"rows_kept":124,"cut":false,"hidden":false,"merged":[[71,9,71,10]]}
[]
[null,"Your User Details"]
[null,"Carrier Teams and Users Setup"]
[null,"Once we have your completed form we will create your accounts. If we require more information, we will contact you."]
[]
[null,"Section 1: Your Teams"]
[]
[null,"Team 1"]
[null,"Team Name:",null,null,{"$f":"IF(ISBLANK(C9),\"0\",\"10\")","v":"0"}]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 2"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 3"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 4"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 5"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 6"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 7"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 8"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 9"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[null,"Team 10"]
[null,"Team Name:"]
[null,"Team Email:"]
[null,"Team visible to brokers:"]
[null,"Cover Written:"]
[null,"Email Notification:","Please select"]
[]
[]
[null,"Section 2: Your Users"]
[]
[null,null,null,null,null,null,null,null,null,"Extra Roles"]
[null,"User No.","First Name","Last Name","E-Mail Address","Telephone Number","Team\n(As in Section 1)","Stamps Access","Role","Internal Approver","Super User"]
[null,"Example:  1","John","Smith","john.smith@abcinsurance.com","0207 8765 4321","1, 2","1, 2, 3","Full-binding","Yes","Yes"]
[null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C75),\"0\",\"10\")","v":"0"},"0","0","0","0","0","0","0","0",{"$f":"(SUM(M75+N75+O75+P75+Q75+R75+S75+T75+U75)+E9)/100","v":0}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"Extract Data","index":6,"n_rows":149,"n_cols":7,"rows_kept":149,"cut":false,"hidden":true,"merged":[]}
["Line of business","Places business?"]
["Accident & Health (A&H)",{"$f":"'Your Classes'!C7","v":"Please select"}]
["Aviation",{"$f":"'Your Classes'!C15","v":"Please select"}]
["Bloodstock/Livestock",{"$f":"'Your Classes'!C33","v":"Please select"}]
["Casualty",{"$f":"'Your Classes'!C41","v":"Please select"}]
["Construction",{"$f":"'Your Classes'!C52","v":"Please select"}]
["Energy",{"$f":"'Your Classes'!C61","v":"Please select"}]
["Financial and Professional Lines (FPL)",{"$f":"'Your Classes'!C74","v":"Please select"}]
["Kidnap & Ransom (K&R)",{"$f":"'Your Classes'!C86","v":"Please select"}]
["Marine",{"$f":"'Your Classes'!C91","v":"Please select"}]
["Political Risks (PR)",{"$f":"'Your Classes'!C105","v":"Please select"}]
["Property",{"$f":"'Your Classes'!C115","v":"Please select"}]
["Real Estate (RE)",{"$f":"'Your Classes'!C124","v":"Please select"}]
["Reinsurance (RI)",{"$f":"'Your Classes'!C129","v":"Please select"}]
["Terrorism",{"$f":"'Your Classes'!C134","v":"Please select"}]
[]
[]
["Contacts"]
["Organisation","First Name","Last Name","Role","Email address","Telephone Number","Type"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D39),\"\",'Your Company Details'!$D39)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D41),\"\",'Your Company Details'!$D41)","v":""},"Approver",{"$f":"IF(ISBLANK('Your Company Details'!$D43),\"\",'Your Company Details'!$D43)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D45),\"\",'Your Company Details'!$D45)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D49),\"\",'Your Company Details'!$D49)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D51),\"\",'Your Company Details'!$D51)","v":""},"Approver",{"$f":"IF(ISBLANK('Your Company Details'!$D53),\"\",'Your Company Details'!$D53)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D55),\"\",'Your Company Details'!$D55)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D61),\"\",'Your Company Details'!$D61)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D63),\"\",'Your Company Details'!$D63)","v":""},"Sponsor",{"$f":"IF(ISBLANK('Your Company Details'!$D65),\"\",'Your Company Details'!$D65)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D67),\"\",'Your Company Details'!$D67)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D72),\"\",'Your Company Details'!$D72)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D74),\"\",'Your Company Details'!$D74)","v":""},"C-Suite",{"$f":"IF(ISBLANK('Your Company Details'!$D76),\"\",'Your Company Details'!$D76)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D78),\"\",'Your Company Details'!$D78)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D83),\"\",'Your Company Details'!$D83)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D85),\"\",'Your Company Details'!$D85)","v":""},"Point of contact",{"$f":"IF(ISBLANK('Your Company Details'!$D87),\"\",'Your Company Details'!$D87)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D89),\"\",'Your Company Details'!$D89)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D96),\"\",'Your Company Details'!$D96)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D98),\"\",'Your Company Details'!$D98)","v":""},"Finance Manager",{"$f":"IF(ISBLANK('Your Company Details'!$D100),\"\",'Your Company Details'!$D100)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D102),\"\",'Your Company Details'!$D102)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D111),\"\",'Your Company Details'!$D111)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D113),\"\",'Your Company Details'!$D113)","v":""},"Publicity",{"$f":"IF(ISBLANK('Your Company Details'!$D115),\"\",'Your Company Details'!$D115)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D117),\"\",'Your Company Details'!$D117)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D122),\"\",'Your Company Details'!$D122)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D124),\"\",'Your Company Details'!$D124)","v":""},"Business as usual",{"$f":"IF(ISBLANK('Your Company Details'!$D126),\"\",'Your Company Details'!$D126)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D128),\"\",'Your Company Details'!$D128)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D135),\"\",'Your Company Details'!$D135)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D137),\"\",'Your Company Details'!$D137)","v":""},"Data Protection Officer",{"$f":"IF(ISBLANK('Your Company Details'!$D139),\"\",'Your Company Details'!$D139)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D141),\"\",'Your Company Details'!$D131)","v":""},"Carrier"]
[{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D150),\"\",'Your Company Details'!$D150)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D152),\"\",'Your Company Details'!$D152)","v":""},"Trainer",{"$f":"IF(ISBLANK('Your Company Details'!$D154),\"\",'Your Company Details'!$D154)","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D156),\"\",'Your Company Details'!$D156)","v":""},"Carrier"]
[]
[]
["Registered Company Name",{"$f":"IF(ISBLANK('Your Company Details'!$D8),\"\",'Your Company Details'!$D8)","v":""}]
["Address Line 1",{"$f":"IF(ISBLANK('Your Company Details'!$D10),\"\",'Your Company Details'!$D10)","v":""}]
["Address Line 2",{"$f":"IF(ISBLANK('Your Company Details'!$D12),\"\",'Your Company Details'!$D12)","v":""}]
["City ",{"$f":"IF(ISBLANK('Your Company Details'!$D14),\"\",'Your Company Details'!$D14)","v":""}]
["Region",{"$f":"IF(ISBLANK('Your Company Details'!$D16),\"\",'Your Company Details'!$D16)","v":""}]
["Postcode",{"$f":"IF(ISBLANK('Your Company Details'!$D18),\"\",'Your Company Details'!$D18)","v":""}]
["Country",{"$f":"IF(ISBLANK('Your Company Details'!$D19),\"\",'Your Company Details'!$D19)","v":""}]
[]
[]
["Line Conditions"]
[{"$f":"IF(ISBLANK('Your Company Details'!B161),\"\",'Your Company Details'!B161)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B163),\"\",'Your Company Details'!B163)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B165),\"\",'Your Company Details'!B165)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B167),\"\",'Your Company Details'!B167)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B169),\"\",'Your Company Details'!B169)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B171),\"\",'Your Company Details'!B171)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B173),\"\",'Your Company Details'!B173)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B175),\"\",'Your Company Details'!B175)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B177),\"\",'Your Company Details'!B177)","v":""}]
[{"$f":"IF(ISBLANK('Your Company Details'!B179),\"\",'Your Company Details'!B179)","v":""}]
[]
[]
["Detailed Classes of business","Places business?"]
["Accident & Health (A&H)",{"$f":"'Your Classes'!C7","v":"Please select"}]
["Personal Accident (including Travel)?",{"$f":"'Your Classes'!C9","v":"Please select"}]
["Contingency?",{"$f":"'Your Classes'!C10","v":"Please select"}]
["Any other classes within your A&H department?",{"$f":"'Your Classes'!C11","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B13","v":0}]
["Aviation",{"$f":"'Your Classes'!C15","v":"Please select"}]
["Satellite/Space?",{"$f":"'Your Classes'!C17","v":"Please select"}]
["General Aviation?",{"$f":"'Your Classes'!C18","v":"Please select"}]
["Airlines?",{"$f":"'Your Classes'!C19","v":"Please select"}]
["Hull Deductible?",{"$f":"'Your Classes'!C20","v":"Please select"}]
["Hull War?",{"$f":"'Your Classes'!C21","v":"Please select"}]
["Excess War Liability?",{"$f":"'Your Classes'!C22","v":"Please select"}]
["Products Liability?",{"$f":"'Your Classes'!C23","v":"Please select"}]
["Airport Liability?",{"$f":"'Your Classes'!C24","v":"Please select"}]
["Contingent Aviation?",{"$f":"'Your Classes'!C25","v":"Please select"}]
["Contingent Hull?",{"$f":"'Your Classes'!C26","v":"Please select"}]
["Contingent Liability?",{"$f":"'Your Classes'!C27","v":"Please select"}]
["Bank / Lessors?",{"$f":"'Your Classes'!C28","v":"Please select"}]
["Any other classes within your Aviation department?",{"$f":"'Your Classes'!C29","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B31","v":0}]
["Bloodstock/Livestock (B/L)",{"$f":"'Your Classes'!C33","v":"Please select"}]
["Bloodstock",{"$f":"'Your Classes'!C35","v":"Please select"}]
["Livestock",{"$f":"'Your Classes'!C36","v":"Please select"}]
["Any other classes within your B/L department?",{"$f":"'Your Classes'!C37","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B39","v":0}]
["Casualty",{"$f":"'Your Classes'!C41","v":"Please select"}]
["General Liability?",{"$f":"'Your Classes'!C43","v":"Please select"}]
["Employers' Liability/WCA?",{"$f":"'Your Classes'!C44","v":"Please select"}]
["Public Liability?",{"$f":"'Your Classes'!C45","v":"Please select"}]
["Product Liability?",{"$f":"'Your Classes'!C46","v":"Please select"}]
["Medical Malpractice?",{"$f":"'Your Classes'!C47","v":"Please select"}]
["Any other classes within your Casualty department?",{"$f":"'Your Classes'!C48","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B50","v":0}]
["Construction",{"$f":"'Your Classes'!C52","v":"Please select"}]
["Onshore Construction?",{"$f":"'Your Classes'!C54","v":"Please select"}]
["Offshore Construction?",{"$f":"'Your Classes'!C55","v":"Please select"}]
["Mining?",{"$f":"'Your Classes'!C56","v":"Please select"}]
["Any other classes within your Construction department?",{"$f":"'Your Classes'!C57","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B59","v":0}]
["Energy",{"$f":"'Your Classes'!C61","v":"Please select"}]
["Onshore Energy?",{"$f":"'Your Classes'!C63","v":"Please select"}]
["Offshore Energy?",{"$f":"'Your Classes'!C64","v":"Please select"}]
["Energy Liability?",{"$f":"'Your Classes'!C65","v":"Please select"}]
["Power (Including Nuclear)?",{"$f":"'Your Classes'!C66","v":"Please select"}]
["Any other classes within your Energy department?",{"$f":"'Your Classes'!C67","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B69","v":0}]
["Facilities",{"$f":"'Your Classes'!C71","v":"Please select"}]
["What percentage of your Facilities business are Binders?",{"$f":"'Your Classes'!C72","v":0}]
["Financial and Professional Lines (FPL)",{"$f":"'Your Classes'!C74","v":"Please select"}]
["Directors and Officers (D&O)?",{"$f":"'Your Classes'!C76","v":"Please select"}]
["Financial Institutions (FI)?",{"$f":"'Your Classes'!C77","v":"Please select"}]
["Professional Liability (PL)?",{"$f":"'Your Classes'!C78","v":"Please select"}]
["Cyber?",{"$f":"'Your Classes'!C79","v":"Please select"}]
["Medical Malpractice?",{"$f":"'Your Classes'!C80","v":"Please select"}]
["Healthcare?",{"$f":"'Your Classes'!C81","v":"Please select"}]
["Any other classes within your FPL department?",{"$f":"'Your Classes'!C82","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B84","v":0}]
["Kidnap & Ransom",{"$f":"'Your Classes'!C86","v":"Please select"}]
["Do you place any other classes within your K&R department?",{"$f":"'Your Classes'!C87","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B89","v":0}]
["Marine",{"$f":"'Your Classes'!C91","v":"Please select"}]
["Hull?",{"$f":"'Your Classes'!C93","v":"Please select"}]
["Marine Construction?",{"$f":"'Your Classes'!C94","v":"Please select"}]
["War?",{"$f":"'Your Classes'!C95","v":"Please select"}]
["Yacht?",{"$f":"'Your Classes'!C96","v":"Please select"}]
["Cargo?",{"$f":"'Your Classes'!C97","v":"Please select"}]
["Marine Liability?",{"$f":"'Your Classes'!C98","v":"Please select"}]
["Ports and Terminals?",{"$f":"'Your Classes'!C99","v":"Please select"}]
["Specie (including fine arts, jewellers block \nand cash in transit?",{"$f":"'Your Classes'!C100","v":"Please select"}]
["Any other classes within your Marine department?",{"$f":"'Your Classes'!C101","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B103","v":0}]
["Political Risks",{"$f":"'Your Classes'!C105","v":"Please select"}]
["Political Risks?",{"$f":"'Your Classes'!C107","v":"Please select"}]
["Contract Frustration?",{"$f":"'Your Classes'!C108","v":"Please select"}]
["Trade Credit?",{"$f":"'Your Classes'!C109","v":"Please select"}]
["Financial Guarantee?",{"$f":"'Your Classes'!C110","v":"Please select"}]
["Any other classes within your Political Risks department?",{"$f":"'Your Classes'!C111","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B113","v":0}]
["Property",{"$f":"'Your Classes'!C115","v":"Please select"}]
["Non-Marine Property?",{"$f":"'Your Classes'!C117","v":"Please select"}]
["Product Recall?",{"$f":"'Your Classes'!C118","v":"Please select"}]
["Mining?",{"$f":"'Your Classes'!C119","v":"Please select"}]
["Any other classes within your Property department?",{"$f":"'Your Classes'!C120","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B122","v":0}]
["Real Estate",{"$f":"'Your Classes'!C124","v":"Please select"}]
["Do you place any other classes within your Real Estate department?",{"$f":"'Your Classes'!C125","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B127","v":0}]
["Reinsurance",{"$f":"'Your Classes'!C129","v":"Please select"}]
["Do you place any other classes within your Treaty Reinsurance department?",{"$f":"'Your Classes'!C130","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B132","v":0}]
["Terrorism",{"$f":"'Your Classes'!C134","v":"Please select"}]
["Terrorism?",{"$f":"'Your Classes'!C136","v":"Please select"}]
["Political Violence?",{"$f":"'Your Classes'!C137","v":"Please select"}]
["Any other classes within your Terrorism department?",{"$f":"'Your Classes'!C138","v":"Please select"}]
["If Yes, list",{"$f":"'Your Classes'!B140","v":0}]

{"sheet":"LMS Upload","index":7,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["LoginId","Password","EmailAddress","FirstName","LastName","AddressLine1","AddressLine2","City","State","Country","PostalCode","ContactNumber","IsActive","Broker or Underwriter","Organisation","Class of Business"]
[{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",'Your User Details'!E75)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",'Your User Details'!E75)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C75),\"\",'Your User Details'!C75)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D75),\"\",'Your User Details'!D75)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",\"Underwriter\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E75),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",'Your User Details'!E76)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",'Your User Details'!E76)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C76),\"\",'Your User Details'!C76)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D76),\"\",'Your User Details'!D76)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E76),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",'Your User Details'!E77)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",'Your User Details'!E77)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C77),\"\",'Your User Details'!C77)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D77),\"\",'Your User Details'!D77)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E77),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",'Your User Details'!E78)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",'Your User Details'!E78)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C78),\"\",'Your User Details'!C78)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D78),\"\",'Your User Details'!D78)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E78),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",'Your User Details'!E79)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",'Your User Details'!E79)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C79),\"\",'Your User Details'!C79)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D79),\"\",'Your User Details'!D79)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E79),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",'Your User Details'!E80)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",'Your User Details'!E80)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C80),\"\",'Your User Details'!C80)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D80),\"\",'Your User Details'!D80)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E80),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",'Your User Details'!E81)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",'Your User Details'!E81)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C81),\"\",'Your User Details'!C81)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D81),\"\",'Your User Details'!D81)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E81),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",'Your User Details'!E82)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",'Your User Details'!E82)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C82),\"\",'Your User Details'!C82)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D82),\"\",'Your User Details'!D82)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E82),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",'Your User Details'!E83)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",'Your User Details'!E83)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C83),\"\",'Your User Details'!C83)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D83),\"\",'Your User Details'!D83)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E83),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",'Your User Details'!E84)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",'Your User Details'!E84)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C84),\"\",'Your User Details'!C84)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D84),\"\",'Your User Details'!D84)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E84),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",'Your User Details'!E85)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",'Your User Details'!E85)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C85),\"\",'Your User Details'!C85)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D85),\"\",'Your User Details'!D85)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E85),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",'Your User Details'!E86)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",'Your User Details'!E86)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C86),\"\",'Your User Details'!C86)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D86),\"\",'Your User Details'!D86)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E86),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",'Your User Details'!E87)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",'Your User Details'!E87)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C87),\"\",'Your User Details'!C87)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D87),\"\",'Your User Details'!D87)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E87),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",'Your User Details'!E88)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",'Your User Details'!E88)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C88),\"\",'Your User Details'!C88)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D88),\"\",'Your User Details'!D88)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E88),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",'Your User Details'!E89)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",'Your User Details'!E89)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C89),\"\",'Your User Details'!C89)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D89),\"\",'Your User Details'!D89)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E89),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",'Your User Details'!E90)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",'Your User Details'!E90)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C90),\"\",'Your User Details'!C90)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D90),\"\",'Your User Details'!D90)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E90),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",'Your User Details'!E91)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",'Your User Details'!E91)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C91),\"\",'Your User Details'!C91)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D91),\"\",'Your User Details'!D91)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E91),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",'Your User Details'!E92)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",'Your User Details'!E92)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C92),\"\",'Your User Details'!C92)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D92),\"\",'Your User Details'!D92)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E92),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",'Your User Details'!E93)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",'Your User Details'!E93)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C93),\"\",'Your User Details'!C93)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D93),\"\",'Your User Details'!D93)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E93),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",'Your User Details'!E94)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",'Your User Details'!E94)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C94),\"\",'Your User Details'!C94)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D94),\"\",'Your User Details'!D94)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E94),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",'Your User Details'!E95)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",'Your User Details'!E95)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C95),\"\",'Your User Details'!C95)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D95),\"\",'Your User Details'!D95)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E95),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",'Your User Details'!E96)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",'Your User Details'!E96)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C96),\"\",'Your User Details'!C96)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D96),\"\",'Your User Details'!D96)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E96),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",'Your User Details'!E97)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",'Your User Details'!E97)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C97),\"\",'Your User Details'!C97)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D97),\"\",'Your User Details'!D97)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E97),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",'Your User Details'!E98)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",'Your User Details'!E98)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C98),\"\",'Your User Details'!C98)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D98),\"\",'Your User Details'!D98)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E98),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",'Your User Details'!E99)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",'Your User Details'!E99)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C99),\"\",'Your User Details'!C99)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D99),\"\",'Your User Details'!D99)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E99),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",'Your User Details'!E100)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",'Your User Details'!E100)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C100),\"\",'Your User Details'!C100)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D100),\"\",'Your User Details'!D100)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E100),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",'Your User Details'!E101)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",'Your User Details'!E101)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C101),\"\",'Your User Details'!C101)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D101),\"\",'Your User Details'!D101)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E101),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",'Your User Details'!E102)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",'Your User Details'!E102)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C102),\"\",'Your User Details'!C102)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D102),\"\",'Your User Details'!D102)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E102),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",'Your User Details'!E103)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",'Your User Details'!E103)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C103),\"\",'Your User Details'!C103)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D103),\"\",'Your User Details'!D103)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E103),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",'Your User Details'!E104)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",'Your User Details'!E104)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C104),\"\",'Your User Details'!C104)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D104),\"\",'Your User Details'!D104)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E104),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",'Your User Details'!E105)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",'Your User Details'!E105)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C105),\"\",'Your User Details'!C105)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D105),\"\",'Your User Details'!D105)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E105),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",'Your User Details'!E106)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",'Your User Details'!E106)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C106),\"\",'Your User Details'!C106)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D106),\"\",'Your User Details'!D106)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E106),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",'Your User Details'!E107)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",'Your User Details'!E107)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C107),\"\",'Your User Details'!C107)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D107),\"\",'Your User Details'!D107)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E107),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",'Your User Details'!E108)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",'Your User Details'!E108)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C108),\"\",'Your User Details'!C108)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D108),\"\",'Your User Details'!D108)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E108),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",'Your User Details'!E109)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",'Your User Details'!E109)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C109),\"\",'Your User Details'!C109)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D109),\"\",'Your User Details'!D109)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E109),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",'Your User Details'!E110)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",'Your User Details'!E110)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C110),\"\",'Your User Details'!C110)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D110),\"\",'Your User Details'!D110)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E110),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",'Your User Details'!E111)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",'Your User Details'!E111)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C111),\"\",'Your User Details'!C111)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D111),\"\",'Your User Details'!D111)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E111),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",'Your User Details'!E112)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",'Your User Details'!E112)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C112),\"\",'Your User Details'!C112)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D112),\"\",'Your User Details'!D112)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E112),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",'Your User Details'!E113)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",'Your User Details'!E113)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C113),\"\",'Your User Details'!C113)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D113),\"\",'Your User Details'!D113)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E113),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",'Your User Details'!E114)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",'Your User Details'!E114)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C114),\"\",'Your User Details'!C114)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D114),\"\",'Your User Details'!D114)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E114),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",'Your User Details'!E115)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",'Your User Details'!E115)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C115),\"\",'Your User Details'!C115)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D115),\"\",'Your User Details'!D115)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E115),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",'Your User Details'!E116)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",'Your User Details'!E116)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C116),\"\",'Your User Details'!C116)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D116),\"\",'Your User Details'!D116)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E116),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",'Your User Details'!E117)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",'Your User Details'!E117)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C117),\"\",'Your User Details'!C117)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D117),\"\",'Your User Details'!D117)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E117),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",'Your User Details'!E118)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",'Your User Details'!E118)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C118),\"\",'Your User Details'!C118)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D118),\"\",'Your User Details'!D118)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E118),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",'Your User Details'!E119)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",'Your User Details'!E119)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C119),\"\",'Your User Details'!C119)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D119),\"\",'Your User Details'!D119)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E119),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",'Your User Details'!E120)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",'Your User Details'!E120)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C120),\"\",'Your User Details'!C120)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D120),\"\",'Your User Details'!D120)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E120),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",'Your User Details'!E121)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",'Your User Details'!E121)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C121),\"\",'Your User Details'!C121)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D121),\"\",'Your User Details'!D121)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E121),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",'Your User Details'!E122)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",'Your User Details'!E122)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C122),\"\",'Your User Details'!C122)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D122),\"\",'Your User Details'!D122)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E122),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",'Your User Details'!E123)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",'Your User Details'!E123)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C123),\"\",'Your User Details'!C123)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D123),\"\",'Your User Details'!D123)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E123),\"\",\"Multiple\")","v":""}]
[{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",'Your User Details'!E124)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",\"P@ssw0rd\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",'Your User Details'!E124)","v":""},{"$f":"IF(ISBLANK('Your User Details'!C124),\"\",'Your User Details'!C124)","v":""},{"$f":"IF(ISBLANK('Your User Details'!D124),\"\",'Your User Details'!D124)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",\"Y\")","v":""},{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",\"Broker\")","v":""},{"$f":"IF(ISBLANK('Your Company Details'!$D$8),\"\",'Your Company Details'!$D$8)","v":""},{"$f":"IF(ISBLANK('Your User Details'!E124),\"\",\"Multiple\")","v":""}]

{"sheet":"Keys","index":8,"n_rows":231,"n_cols":14,"rows_kept":231,"cut":false,"hidden":true,"merged":[[1,13,1,17],[2,13,2,17],[3,13,3,17],[4,13,4,17],[5,13,5,17]]}
["General Information","Markets","Company Details",null,null,null,null,"Checklist text",null,"Role","Notification","Countries","SDC Configuration"]
["Please select","Please select","Please select",null,"General Information",{"$f":"'Your Classes'!E4","v":0},null,"This section has been fully completed",null,"Full-binding","Please select","Please select","Please select here","See key to SDC configuration below"]
["Yes","Yes","Qualifying",null,"Markets",0.12,null,"This section is almost completed",null,"Read-only","Notify team","United Kingdom ","A - Elective","Our company is PPL/SDC member. All stamps are sent to SDC (including LIC)"]
["No","No","Affiliate of Qualifying Company",null,"Test",0.25,null,"This section has been started",null,null,"Notify individual","-","B - Elective","Our company is PPL/SDC member. All stamps are sent to SDC (excluding LIC)"]
["Reset","N/A","Non-Qualifying Company",null,"Test",0.25,null,"This section is outstanding",null,null,"Notify both","Afghanistan ","C - Non Elective","Our company is not a PPL/SDC member. But LIC stamps only are sent to SDC"]
[null,null,null,null,"Test",null,null,null,null,null,null,"Albania ","D - Non Elective","Our company is not a PPL/SDC member. Nothing is sent to SDC"]
[null,"Yes",null,null,null,null,null,null,null,null,null,"Algeria "]
["Cascade response","No",null,null,null,null,null,null,null,null,null,"American Samoa "]
["Please select",null,null,null,null,null,null,null,null,null,null,"Andorra "]
["Yes to all/most",null,null,null,"Sum",{"$f":"SUM(F2:F9)","v":0.62},null,null,null,null,null,"Angola "]
["No to most",null,null,null,null,null,null,null,null,null,null,"Anguilla "]
["Reset",null,null,null,null,null,null,null,null,null,null,"Antigua & Barbuda "]
[null,null,null,null,null,null,null,null,null,null,null,"Argentina "]
["Permitted Territory",null,null,null,null,null,null,null,null,null,null,"Armenia "]
["Worldwide",null,null,null,null,null,null,null,null,null,null,"Aruba "]
["EEA & UK",null,null,null,null,null,null,null,null,null,null,"Australia "]
["Worldwide & UK but excluding EEA",null,null,null,null,null,null,null,null,null,null,"Austria "]
["UK only",null,null,null,null,null,null,null,null,null,null,"Azerbaijan "]
["EEA only",null,null,null,null,null,null,null,null,null,null,"Bahamas, The "]
["Worldwide incl EEA but excluding UK",null,null,null,null,null,null,null,null,null,null,"Bahrain "]
[null,null,null,null,null,null,null,null,null,null,null,"Bangladesh "]
[null,null,null,null,null,null,null,null,null,null,null,"Barbados "]
[null,null,null,null,null,null,null,null,null,null,null,"Belarus "]
[null,null,null,null,null,null,null,null,null,null,null,"Belgium "]
[null,null,null,null,null,null,null,null,null,null,null,"Belize "]
[null,null,null,null,null,null,null,null,null,null,null,"Benin "]
[null,null,null,null,null,null,null,null,null,null,null,"Bermuda "]
[null,null,null,null,null,null,null,null,null,null,null,"Bhutan "]
[null,null,null,null,null,null,null,null,null,null,null,"Bolivia "]
[null,null,null,null,null,null,null,null,null,null,null,"Bosnia & Herzegovina "]
[null,null,null,null,null,null,null,null,null,null,null,"Botswana "]
[null,null,null,null,null,null,null,null,null,null,null,"Brazil "]
[null,null,null,null,null,null,null,null,null,null,null,"British Virgin Is. "]
[null,null,null,null,null,null,null,null,null,null,null,"Brunei "]
[null,null,null,null,null,null,null,null,null,null,null,"Bulgaria "]
[null,null,null,null,null,null,null,null,null,null,null,"Burkina Faso "]
[null,null,null,null,null,null,null,null,null,null,null,"Burma "]
[null,null,null,null,null,null,null,null,null,null,null,"Burundi "]
[null,null,null,null,null,null,null,null,null,null,null,"Cambodia "]
[null,null,null,null,null,null,null,null,null,null,null,"Cameroon "]
[null,null,null,null,null,null,null,null,null,null,null,"Canada "]
[null,null,null,null,null,null,null,null,null,null,null,"Cape Verde "]
[null,null,null,null,null,null,null,null,null,null,null,"Cayman Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Central African Rep. "]
[null,null,null,null,null,null,null,null,null,null,null,"Chad "]
[null,null,null,null,null,null,null,null,null,null,null,"Chile "]
[null,null,null,null,null,null,null,null,null,null,null,"China "]
[null,null,null,null,null,null,null,null,null,null,null,"Colombia "]
[null,null,null,null,null,null,null,null,null,null,null,"Comoros "]
[null,null,null,null,null,null,null,null,null,null,null,"Congo, Dem. Rep. "]
[null,null,null,null,null,null,null,null,null,null,null,"Congo, Repub. of the "]
[null,null,null,null,null,null,null,null,null,null,null,"Cook Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Costa Rica "]
[null,null,null,null,null,null,null,null,null,null,null,"Cote d'Ivoire "]
[null,null,null,null,null,null,null,null,null,null,null,"Croatia "]
[null,null,null,null,null,null,null,null,null,null,null,"Cuba "]
[null,null,null,null,null,null,null,null,null,null,null,"Cyprus "]
[null,null,null,null,null,null,null,null,null,null,null,"Czech Republic "]
[null,null,null,null,null,null,null,null,null,null,null,"Denmark "]
[null,null,null,null,null,null,null,null,null,null,null,"Djibouti "]
[null,null,null,null,null,null,null,null,null,null,null,"Dominica "]
[null,null,null,null,null,null,null,null,null,null,null,"Dominican Republic "]
[null,null,null,null,null,null,null,null,null,null,null,"East Timor "]
[null,null,null,null,null,null,null,null,null,null,null,"Ecuador "]
[null,null,null,null,null,null,null,null,null,null,null,"Egypt "]
[null,null,null,null,null,null,null,null,null,null,null,"El Salvador "]
[null,null,null,null,null,null,null,null,null,null,null,"Equatorial Guinea "]
[null,null,null,null,null,null,null,null,null,null,null,"Eritrea "]
[null,null,null,null,null,null,null,null,null,null,null,"Estonia "]
[null,null,null,null,null,null,null,null,null,null,null,"Ethiopia "]
[null,null,null,null,null,null,null,null,null,null,null,"Faroe Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Fiji "]
[null,null,null,null,null,null,null,null,null,null,null,"Finland "]
[null,null,null,null,null,null,null,null,null,null,null,"France "]
[null,null,null,null,null,null,null,null,null,null,null,"French Guiana "]
[null,null,null,null,null,null,null,null,null,null,null,"French Polynesia "]
[null,null,null,null,null,null,null,null,null,null,null,"Gabon "]
[null,null,null,null,null,null,null,null,null,null,null,"Gambia, The "]
[null,null,null,null,null,null,null,null,null,null,null,"Gaza Strip "]
[null,null,null,null,null,null,null,null,null,null,null,"Georgia "]
[null,null,null,null,null,null,null,null,null,null,null,"Germany "]
[null,null,null,null,null,null,null,null,null,null,null,"Ghana "]
[null,null,null,null,null,null,null,null,null,null,null,"Gibraltar "]
[null,null,null,null,null,null,null,null,null,null,null,"Greece "]
[null,null,null,null,null,null,null,null,null,null,null,"Greenland "]
[null,null,null,null,null,null,null,null,null,null,null,"Grenada "]
[null,null,null,null,null,null,null,null,null,null,null,"Guadeloupe "]
[null,null,null,null,null,null,null,null,null,null,null,"Guam "]
[null,null,null,null,null,null,null,null,null,null,null,"Guatemala "]
[null,null,null,null,null,null,null,null,null,null,null,"Guernsey "]
[null,null,null,null,null,null,null,null,null,null,null,"Guinea "]
[null,null,null,null,null,null,null,null,null,null,null,"Guinea-Bissau "]
[null,null,null,null,null,null,null,null,null,null,null,"Guyana "]
[null,null,null,null,null,null,null,null,null,null,null,"Haiti "]
[null,null,null,null,null,null,null,null,null,null,null,"Honduras "]
[null,null,null,null,null,null,null,null,null,null,null,"Hong Kong "]
[null,null,null,null,null,null,null,null,null,null,null,"Hungary "]
[null,null,null,null,null,null,null,null,null,null,null,"Iceland "]
[null,null,null,null,null,null,null,null,null,null,null,"India "]
[null,null,null,null,null,null,null,null,null,null,null,"Indonesia "]
[null,null,null,null,null,null,null,null,null,null,null,"Iran "]
[null,null,null,null,null,null,null,null,null,null,null,"Iraq "]
[null,null,null,null,null,null,null,null,null,null,null,"Ireland "]
[null,null,null,null,null,null,null,null,null,null,null,"Isle of Man "]
[null,null,null,null,null,null,null,null,null,null,null,"Israel "]
[null,null,null,null,null,null,null,null,null,null,null,"Italy "]
[null,null,null,null,null,null,null,null,null,null,null,"Jamaica "]
[null,null,null,null,null,null,null,null,null,null,null,"Japan "]
[null,null,null,null,null,null,null,null,null,null,null,"Jersey "]
[null,null,null,null,null,null,null,null,null,null,null,"Jordan "]
[null,null,null,null,null,null,null,null,null,null,null,"Kazakhstan "]
[null,null,null,null,null,null,null,null,null,null,null,"Kenya "]
[null,null,null,null,null,null,null,null,null,null,null,"Kiribati "]
[null,null,null,null,null,null,null,null,null,null,null,"Korea, North "]
[null,null,null,null,null,null,null,null,null,null,null,"Korea, South "]
[null,null,null,null,null,null,null,null,null,null,null,"Kuwait "]
[null,null,null,null,null,null,null,null,null,null,null,"Kyrgyzstan "]
[null,null,null,null,null,null,null,null,null,null,null,"Laos "]
[null,null,null,null,null,null,null,null,null,null,null,"Latvia "]
[null,null,null,null,null,null,null,null,null,null,null,"Lebanon "]
[null,null,null,null,null,null,null,null,null,null,null,"Lesotho "]
[null,null,null,null,null,null,null,null,null,null,null,"Liberia "]
[null,null,null,null,null,null,null,null,null,null,null,"Libya "]
[null,null,null,null,null,null,null,null,null,null,null,"Liechtenstein "]
[null,null,null,null,null,null,null,null,null,null,null,"Lithuania "]
[null,null,null,null,null,null,null,null,null,null,null,"Luxembourg "]
[null,null,null,null,null,null,null,null,null,null,null,"Macau "]
[null,null,null,null,null,null,null,null,null,null,null,"Macedonia "]
[null,null,null,null,null,null,null,null,null,null,null,"Madagascar "]
[null,null,null,null,null,null,null,null,null,null,null,"Malawi "]
[null,null,null,null,null,null,null,null,null,null,null,"Malaysia "]
[null,null,null,null,null,null,null,null,null,null,null,"Maldives "]
[null,null,null,null,null,null,null,null,null,null,null,"Mali "]
[null,null,null,null,null,null,null,null,null,null,null,"Malta "]
[null,null,null,null,null,null,null,null,null,null,null,"Marshall Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Martinique "]
[null,null,null,null,null,null,null,null,null,null,null,"Mauritania "]
[null,null,null,null,null,null,null,null,null,null,null,"Mauritius "]
[null,null,null,null,null,null,null,null,null,null,null,"Mayotte "]
[null,null,null,null,null,null,null,null,null,null,null,"Mexico "]
[null,null,null,null,null,null,null,null,null,null,null,"Micronesia, Fed. St. "]
[null,null,null,null,null,null,null,null,null,null,null,"Moldova "]
[null,null,null,null,null,null,null,null,null,null,null,"Monaco "]
[null,null,null,null,null,null,null,null,null,null,null,"Mongolia "]
[null,null,null,null,null,null,null,null,null,null,null,"Montserrat "]
[null,null,null,null,null,null,null,null,null,null,null,"Morocco "]
[null,null,null,null,null,null,null,null,null,null,null,"Mozambique "]
[null,null,null,null,null,null,null,null,null,null,null,"Namibia "]
[null,null,null,null,null,null,null,null,null,null,null,"Nauru "]
[null,null,null,null,null,null,null,null,null,null,null,"Nepal "]
[null,null,null,null,null,null,null,null,null,null,null,"Netherlands "]
[null,null,null,null,null,null,null,null,null,null,null,"Netherlands Antilles "]
[null,null,null,null,null,null,null,null,null,null,null,"New Caledonia "]
[null,null,null,null,null,null,null,null,null,null,null,"New Zealand "]
[null,null,null,null,null,null,null,null,null,null,null,"Nicaragua "]
[null,null,null,null,null,null,null,null,null,null,null,"Niger "]
[null,null,null,null,null,null,null,null,null,null,null,"Nigeria "]
[null,null,null,null,null,null,null,null,null,null,null,"N. Mariana Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Norway "]
[null,null,null,null,null,null,null,null,null,null,null,"Oman "]
[null,null,null,null,null,null,null,null,null,null,null,"Pakistan "]
[null,null,null,null,null,null,null,null,null,null,null,"Palau "]
[null,null,null,null,null,null,null,null,null,null,null,"Panama "]
[null,null,null,null,null,null,null,null,null,null,null,"Papua New Guinea "]
[null,null,null,null,null,null,null,null,null,null,null,"Paraguay "]
[null,null,null,null,null,null,null,null,null,null,null,"Peru "]
[null,null,null,null,null,null,null,null,null,null,null,"Philippines "]
[null,null,null,null,null,null,null,null,null,null,null,"Poland "]
[null,null,null,null,null,null,null,null,null,null,null,"Portugal "]
[null,null,null,null,null,null,null,null,null,null,null,"Puerto Rico "]
[null,null,null,null,null,null,null,null,null,null,null,"Qatar "]
[null,null,null,null,null,null,null,null,null,null,null,"Reunion "]
[null,null,null,null,null,null,null,null,null,null,null,"Romania "]
[null,null,null,null,null,null,null,null,null,null,null,"Russia "]
[null,null,null,null,null,null,null,null,null,null,null,"Rwanda "]
[null,null,null,null,null,null,null,null,null,null,null,"Saint Helena "]
[null,null,null,null,null,null,null,null,null,null,null,"Saint Kitts & Nevis "]
[null,null,null,null,null,null,null,null,null,null,null,"Saint Lucia "]
[null,null,null,null,null,null,null,null,null,null,null,"St Pierre & Miquelon "]
[null,null,null,null,null,null,null,null,null,null,null,"Saint Vincent and the Grenadines "]
[null,null,null,null,null,null,null,null,null,null,null,"Samoa "]
[null,null,null,null,null,null,null,null,null,null,null,"San Marino "]
[null,null,null,null,null,null,null,null,null,null,null,"Sao Tome & Principe "]
[null,null,null,null,null,null,null,null,null,null,null,"Saudi Arabia "]
[null,null,null,null,null,null,null,null,null,null,null,"Senegal "]
[null,null,null,null,null,null,null,null,null,null,null,"Serbia "]
[null,null,null,null,null,null,null,null,null,null,null,"Seychelles "]
[null,null,null,null,null,null,null,null,null,null,null,"Sierra Leone "]
[null,null,null,null,null,null,null,null,null,null,null,"Singapore "]
[null,null,null,null,null,null,null,null,null,null,null,"Slovakia "]
[null,null,null,null,null,null,null,null,null,null,null,"Slovenia "]
[null,null,null,null,null,null,null,null,null,null,null,"Solomon Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Somalia "]
[null,null,null,null,null,null,null,null,null,null,null,"South Africa "]
[null,null,null,null,null,null,null,null,null,null,null,"Spain "]
[null,null,null,null,null,null,null,null,null,null,null,"Sri Lanka "]
[null,null,null,null,null,null,null,null,null,null,null,"Sudan "]
[null,null,null,null,null,null,null,null,null,null,null,"Suriname "]
[null,null,null,null,null,null,null,null,null,null,null,"Swaziland "]
[null,null,null,null,null,null,null,null,null,null,null,"Sweden "]
[null,null,null,null,null,null,null,null,null,null,null,"Switzerland "]
[null,null,null,null,null,null,null,null,null,null,null,"Syria "]
[null,null,null,null,null,null,null,null,null,null,null,"Taiwan "]
[null,null,null,null,null,null,null,null,null,null,null,"Tajikistan "]
[null,null,null,null,null,null,null,null,null,null,null,"Tanzania "]
[null,null,null,null,null,null,null,null,null,null,null,"Thailand "]
[null,null,null,null,null,null,null,null,null,null,null,"Togo "]
[null,null,null,null,null,null,null,null,null,null,null,"Tonga "]
[null,null,null,null,null,null,null,null,null,null,null,"Trinidad & Tobago "]
[null,null,null,null,null,null,null,null,null,null,null,"Tunisia "]
[null,null,null,null,null,null,null,null,null,null,null,"Turkey "]
[null,null,null,null,null,null,null,null,null,null,null,"Turkmenistan "]
[null,null,null,null,null,null,null,null,null,null,null,"Turks & Caicos Is "]
[null,null,null,null,null,null,null,null,null,null,null,"Tuvalu "]
[null,null,null,null,null,null,null,null,null,null,null,"Uganda "]
[null,null,null,null,null,null,null,null,null,null,null,"Ukraine "]
[null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates "]
[null,null,null,null,null,null,null,null,null,null,null,"United Kingdom "]
[null,null,null,null,null,null,null,null,null,null,null,"United States "]
[null,null,null,null,null,null,null,null,null,null,null,"Uruguay "]
[null,null,null,null,null,null,null,null,null,null,null,"Uzbekistan "]
[null,null,null,null,null,null,null,null,null,null,null,"Vanuatu "]
[null,null,null,null,null,null,null,null,null,null,null,"Venezuela "]
[null,null,null,null,null,null,null,null,null,null,null,"Vietnam "]
[null,null,null,null,null,null,null,null,null,null,null,"Virgin Islands "]
[null,null,null,null,null,null,null,null,null,null,null,"Wallis and Futuna "]
[null,null,null,null,null,null,null,null,null,null,null,"West Bank "]
[null,null,null,null,null,null,null,null,null,null,null,"Western Sahara "]
[null,null,null,null,null,null,null,null,null,null,null,"Yemen "]
[null,null,null,null,null,null,null,null,null,null,null,"Zambia "]
[null,null,null,null,null,null,null,null,null,null,null,"Zimbabwe "]