{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Countries and Currencies","Instructions","FTE Overview","Submission Overview","Definition of Terms"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Countries and Currencies","index":0,"n_rows":260,"n_cols":7,"rows_kept":260,"cut":false,"hidden":true,"merged":[]}
["CountryCode","Country","Currency","Code"]
["Central","Central",null,"GBP",null,null,"GBP"]
["International","International",null,"GBP",null,null,"USD"]
["LATAM","LATAM",null,"USD",null,null,"EUR"]
["MENA","MENA",null,"USD",null,null,"AUD"]
["APAC","APAC",null,"USD",null,null,"NZD"]
["GCC","GCC",null,"USD",null,null,"HKD"]
["DACH","Germany, Austria and Switzerland",null,"EUR",null,null,"CAD"]
["Benelux","Benelux",null,"EUR",null,null,"JPY"]
["ANZ","Australia & New Zealand",null,"AUD",null,null,"AFN"]
["NZ","New Zealand","New Zealand Dollars","NZD",null,null,"ALL"]
["CK","Cook Islands","New Zealand Dollars","NZD",null,null,"DZD"]
["NU","Niue","New Zealand Dollars","NZD",null,null,"XCD"]
["PN","Pitcairn","New Zealand Dollars","NZD",null,null,"ARS"]
["TK","Tokelau","New Zealand Dollars","NZD",null,null,"AMD"]
["AU","Australia","Australian Dollars","AUD",null,null,"ANG"]
["CX","Christmas Island","Australian Dollars","AUD",null,null,"AZN"]
["CC","Cocos (Keeling) Islands","Australian Dollars","AUD",null,null,"BSD"]
["HM","Heard and Mc Donald Islands","Australian Dollars","AUD",null,null,"BHD"]
["KI","Kiribati","Australian Dollars","AUD",null,null,"BDT"]
["NR","Nauru","Australian Dollars","AUD",null,null,"BBD"]
["NF","Norfolk Island","Australian Dollars","AUD",null,null,"BYR"]
["TV","Tuvalu","Australian Dollars","AUD",null,null,"BZD"]
["AS","American Samoa","Euros","EUR",null,null,"XOF"]
["AD","Andorra","Euros","EUR",null,null,"BMD"]
["AT","Austria","Euros","EUR",null,null,"INR"]
["BE","Belgium","Euros","EUR",null,null,"BOB"]
["FI","Finland","Euros","EUR",null,null,"BWP"]
["FR","France","Euros","EUR",null,null,"NOK"]
["GF","French Guiana","Euros","EUR",null,null,"BRL"]
["TF","French Southern Territories","Euros","EUR",null,null,"BND"]
["DE","Germany","Euros","EUR",null,null,"BGN"]
["GR","Greece","Euros","EUR",null,null,"BIF"]
["GP","Guadeloupe","Euros","EUR",null,null,"KHR"]
["IE","Ireland","Euros","EUR",null,null,"XAF"]
["IT","Italy","Euros","EUR",null,null,"CVE"]
["LU","Luxembourg","Euros","EUR",null,null,"KYD"]
["MQ","Martinique","Euros","EUR",null,null,"CLP"]
["YT","Mayotte","Euros","EUR",null,null,"RMB"]
["MC","Monaco","Euros","EUR",null,null,"COP"]
["NL","Netherlands","Euros","EUR",null,null,"KMF"]
["PT","Portugal","Euros","EUR",null,null,"CDF"]
["RE","Reunion","Euros","EUR",null,null,"CRC"]
["WS","Samoa","Euros","EUR",null,null,"HRK"]
["SM","San Marino","Euros","EUR",null,null,"CUP"]
["SI","Slovenia","Euros","EUR",null,null,"CYP"]
["ES","Spain","Euros","EUR",null,null,"CZK"]
["VA","Vatican City State (Holy See)","Euros","EUR",null,null,"DKK"]
["GS","South Georgia and the South Sandwich Islands","Sterling","GBP",null,null,"DJF"]
["UK","UK","Sterling","GBP",null,null,"DOP"]
["JE","Jersey","Sterling","GBP",null,null,"IDR"]
["IO","British Indian Ocean Territory","USD","USD",null,null,"ECS"]
["GU","Guam","USD","USD",null,null,"EGP"]
["MH","Marshall Islands","USD","USD",null,null,"SVC"]
["FM","Micronesia Federated States of","USD","USD",null,null,"ETB"]
["MP","Northern Mariana Islands","USD","USD",null,null,"EEK"]
["PW","Palau","USD","USD",null,null,"FKP"]
["PR","Puerto Rico","USD","USD",null,null,"FJD"]
["TC","Turks and Caicos Islands","USD","USD",null,null,"XPF"]
["US","US","USD","USD",null,null,"GMD"]
["UM","United States Minor Outlying Islands","USD","USD",null,null,"GEL"]
["VG","Virgin Islands (British)","USD","USD",null,null,"GIP"]
["VI","Virgin Islands (US)","USD","USD",null,null,"GTQ"]
["HK","Hong Kong","HKD","HKD",null,null,"GNF"]
["CA","Canada","Canadian Dollar","CAD",null,null,"GYD"]
["JP","Japan","Japanese Yen","JPY",null,null,"HTG"]
["AF","Afghanistan","Afghani","AFN",null,null,"HNL"]
["AL","Albania","Lek","ALL",null,null,"HUF"]
["DZ","Algeria","Algerian Dinar","DZD",null,null,"ISK"]
["AI","Anguilla","East Caribbean Dollar","XCD",null,null,"IRR"]
["AG","Antigua and Barbuda","East Caribbean Dollar","XCD",null,null,"IQD"]
["DM","Dominica","East Caribbean Dollar","XCD",null,null,"ILS"]
["GD","Grenada","East Caribbean Dollar","XCD",null,null,"JMD"]
["MS","Montserrat","East Caribbean Dollar","XCD",null,null,"JOD"]
["KN","Saint Kitts","East Caribbean Dollar","XCD",null,null,"KZT"]
["LC","Saint Lucia","East Caribbean Dollar","XCD",null,null,"KES"]
["VC","Saint Vincent Grenadines","East Caribbean Dollar","XCD",null,null,"KPW"]
["AR","Argentina","Peso","ARS",null,null,"KRW"]
["AM","Armenia","Dram","AMD",null,null,"KWD"]
["AW","Aruba","Netherlands Antilles Guilder","ANG",null,null,"KGS"]
["AN","Netherlands Antilles","Netherlands Antilles Guilder","ANG",null,null,"LAK"]
["AZ","Azerbaijan","Manat","AZN",null,null,"LVL"]
["BS","Bahamas","Bahamian Dollar","BSD",null,null,"LBP"]
["BH","Bahrain","Bahraini Dinar","BHD",null,null,"LSL"]
["BD","Bangladesh","Taka","BDT",null,null,"LRD"]
["BB","Barbados","Barbadian Dollar","BBD",null,null,"LYD"]
["BY","Belarus","Belarus Ruble","BYR",null,null,"CHF"]
["BZ","Belize","Belizean Dollar","BZD",null,null,"LTL"]
["BJ","Benin","CFA Franc BCEAO","XOF",null,null,"MOP"]
["BF","Burkina Faso","CFA Franc BCEAO","XOF",null,null,"MKD"]
["GW","Guinea-Bissau","CFA Franc BCEAO","XOF",null,null,"MGA"]
["CI","Ivory Coast","CFA Franc BCEAO","XOF",null,null,"MWK"]
["ML","Mali","CFA Franc BCEAO","XOF",null,null,"MYR"]
["NE","Niger","CFA Franc BCEAO","XOF",null,null,"MVR"]
["SN","Senegal","CFA Franc BCEAO","XOF",null,null,"MTL"]
["TG","Togo","CFA Franc BCEAO","XOF",null,null,"MRO"]
["BM","Bermuda","Bermudian Dollar","BMD",null,null,"MUR"]
["BT","Bhutan","Indian Rupee","INR",null,null,"MXN"]
["IN","India","Indian Rupee","INR",null,null,"MDL"]
["BO","Bolivia","Boliviano","BOB",null,null,"MNT"]
["BW","Botswana","Pula","BWP",null,null,"MAD"]
["BV","Bouvet Island","Norwegian Krone","NOK",null,null,"MZN"]
["NO","Norway","Norwegian Krone","NOK",null,null,"MMK"]
["SJ","Svalbard and Jan Mayen Islands","Norwegian Krone","NOK",null,null,"NAD"]
["BR","Brazil","Brazil","BRL",null,null,"NPR"]
["BN","Brunei Darussalam","Bruneian Dollar","BND",null,null,"NIO"]
["BG","Bulgaria","Lev","BGN",null,null,"NGN"]
["BI","Burundi","Burundi Franc","BIF",null,null,"OMR"]
["KH","Cambodia","Riel","KHR",null,null,"PKR"]
["CM","Cameroon","CFA Franc BEAC","XAF",null,null,"PAB"]
["CF","Central African Republic","CFA Franc BEAC","XAF",null,null,"PGK"]
["TD","Chad","CFA Franc BEAC","XAF",null,null,"PYG"]
["CG","Congo Republic of the Democratic","CFA Franc BEAC","XAF",null,null,"PEN"]
["GQ","Equatorial Guinea","CFA Franc BEAC","XAF",null,null,"PHP"]
["GA","Gabon","CFA Franc BEAC","XAF",null,null,"PLN"]
["CV","Cape Verde","Escudo","CVE",null,null,"QAR"]
["KY","Cayman Islands","Caymanian Dollar","KYD",null,null,"RON"]
["CL","Chile","Chilean Peso","CLP",null,null,"RUB"]
["CN","China","Yuan Renminbi","RMB",null,null,"RWF"]
["CO","Colombia","Peso","COP",null,null,"STD"]
["KM","Comoros","Comoran Franc","KMF",null,null,"SAR"]
["CD","Congo-Brazzaville","Congolese Frank","CDF",null,null,"SCR"]
["CR","Costa Rica","Costa Rican Colon","CRC",null,null,"SLL"]
["HR","Croatia","Croatian Dinar","HRK",null,null,"SGD"]
["CU","Cuba","Cuban Peso","CUP",null,null,"SKK"]
["CY","Cyprus","Cypriot Pound","CYP",null,null,"SBD"]
["CZ","Czech Republic","Koruna","CZK",null,null,"SOS"]
["DK","Denmark","Danish Krone","DKK",null,null,"ZAR"]
["FO","Faroe Islands","Danish Krone","DKK",null,null,"LKR"]
["GL","Greenland","Danish Krone","DKK",null,null,"SDG"]
["DJ","Djibouti","Djiboutian Franc","DJF",null,null,"SRD"]
["DO","Dominican Republic","Dominican Peso","DOP",null,null,"SZL"]
["TP","East Timor","Indonesian Rupiah","IDR",null,null,"SEK"]
["ID","Indonesia","Indonesian Rupiah","IDR",null,null,"SYP"]
["EC","Ecuador","Sucre","ECS",null,null,"TWD"]
["EG","Egypt","Egyptian Pound","EGP",null,null,"TJS"]
["SV","El Salvador","Salvadoran Colon","SVC",null,null,"TZS"]
["ER","Eritrea","Ethiopian Birr","ETB",null,null,"THB"]
["ET","Ethiopia","Ethiopian Birr","ETB",null,null,"TOP"]
["EE","Estonia","Estonian Kroon","EEK",null,null,"TTD"]
["FK","Falkland Islands (Malvinas)","Falkland Pound","FKP",null,null,"TND"]
["FJ","Fiji","Fijian Dollar","FJD",null,null,"TRY"]
["PF","French Polynesia","CFP Franc","XPF",null,null,"TMT"]
["NC","New Caledonia","CFP Franc","XPF",null,null,"UGX"]
["WF","Wallis and Futuna Islands","CFP Franc","XPF",null,null,"UAH"]
["GM","Gambia","Dalasi","GMD",null,null,"AED"]
["GE","Georgia","Lari","GEL",null,null,"UYU"]
["GI","Gibraltar","Gibraltar Pound","GIP",null,null,"UZS"]
["GT","Guatemala","Quetzal","GTQ",null,null,"VUV"]
["GN","Guinea","Guinean Franc","GNF",null,null,"VEF"]
["GY","Guyana","Guyanaese Dollar","GYD",null,null,"VND"]
["HT","Haiti","Gourde","HTG",null,null,"YER"]
["HN","Honduras","Lempira","HNL",null,null,"ZMK"]
["HU","Hungary","Forint","HUF",null,null,"ZWD"]
["IS","Iceland","Icelandic Krona","ISK",null,null,"AOA"]
["IR","Iran","Iranian Rial","IRR",null,null,"AQD"]
["IQ","Iraq","Iraqi Dinar","IQD",null,null,"BAM"]
["IL","Israel","Shekel","ILS",null,null,"GHS"]
["JM","Jamaica","Jamaican Dollar","JMD",null,null,"GGP"]
["JO","Jordan","Jordanian Dinar","JOD",null,null,"RSD"]
["KZ","Kazakhstan","Tenge","KZT"]
["KE","Kenya","Kenyan Shilling","KES"]
["KP","North Korea","Won","KPW"]
["KR","South Korea","Won","KRW"]
["KW","Kuwait","Kuwaiti Dinar","KWD"]
["KG","Kyrgyzstan","Som","KGS"]
["LA","Laos","Kip","LAK"]
["LV","Latvia","Lat","LVL"]
["LB","Lebanon","Lebanese Pound","LBP"]
["LS","Lesotho","Loti","LSL"]
["LR","Liberia","Liberian Dollar","LRD"]
["LY","Libyan Arab Jamahiriya","Libyan Dinar","LYD"]
["LI","Liechtenstein","Swiss Franc","CHF"]
["CH","Switzerland","Swiss Franc","CHF"]
["LT","Lithuania","Lita","LTL"]
["MO","Macau","Pataca","MOP"]
["MK","Macedonia","Denar","MKD"]
["MG","Madagascar","Malagasy Franc","MGA"]
["MW","Malawi","Malawian Kwacha","MWK"]
["MY","Malaysia","Ringgit","MYR"]
["MV","Maldives","Rufiyaa","MVR"]
["MT","Malta","Maltese Lira","MTL"]
["MR","Mauritania","Ouguiya","MRO"]
["MU","Mauritius","Mauritian Rupee","MUR"]
["MX","Mexico","Peso","MXN"]
["MD","Moldova","Leu","MDL"]
["MN","Mongolia","Tugrik","MNT"]
["MA","Morocco","Dirham","MAD"]
["EH","Western Sahara","Dirham","MAD"]
["MZ","Mozambique","Metical","MZN"]
["MM","Myanmar","Kyat","MMK"]
["NA","Namibia","Dollar","NAD"]
["NP","Nepal","Nepalese Rupee","NPR"]
["NI","Nicaragua","Cordoba Oro","NIO"]
["NG","Nigeria","Naira","NGN"]
["OM","Oman","Sul Rial","OMR"]
["PK","Pakistan","Rupee","PKR"]
["PA","Panama","Balboa","PAB"]
["PG","Papua New Guinea","Kina","PGK"]
["PY","Paraguay","Guarani","PYG"]
["PE","Peru","Nuevo Sol","PEN"]
["PH","Philippines","Peso","PHP"]
["PL","Poland","Zloty","PLN"]
["QA","Qatar","Rial","QAR"]
["RO","Romania","Leu","RON"]
["RU","Russia","Ruble","RUB"]
["RW","Rwanda","Rwanda Franc","RWF"]
["ST","Sao Tome and Principe","Dobra","STD"]
["SA","Saudi Arabia","Riyal","SAR"]
["SC","Seychelles","Rupee","SCR"]
["SL","Sierra Leone","Leone","SLL"]
["SG","Singapore","Dollar","SGD"]
["SK","Slovakia","Koruna","SKK"]
["SB","Solomon Islands","Solomon Islands Dollar","SBD"]
["SO","Somalia","Shilling","SOS"]
["ZA","South Africa","Rand","ZAR"]
["LK","Sri Lanka","Rupee","LKR"]
["SD","Sudan","Dinar","SDG"]
["SR","Suriname","Surinamese Guilder","SRD"]
["SZ","Swaziland","Lilangeni","SZL"]
["SE","Sweden","Krona","SEK"]
["SY","Syria","Syrian Pound","SYP"]
["TW","Taiwan","Dollar","TWD"]
["TJ","Tajikistan","Tajikistan Ruble","TJS"]
["TZ","Tanzania","Shilling","TZS"]
["TH","Thailand","Baht","THB"]
["TO","Tonga","PaÕanga","TOP"]
["TT","Trinidad and Tobago","Trinidad and Tobago Dollar","TTD"]
["TN","Tunisia","Tunisian Dinar","TND"]
["TR","Turkey","Lira","TRY"]
["TM","Turkmenistan","Manat","TMT"]
["UG","Uganda","Shilling","UGX"]
["UA","Ukraine","Hryvnia","UAH"]
["AE","UAE","Dirham","AED"]
["UY","Uruguay","Peso","UYU"]
["UZ","Uzbekistan","Som","UZS"]
["VU","Vanuatu","Vatu","VUV"]
["VE","Venezuela","Bolivar","VEF"]
["VN","Vietnam","Dong","VND"]
["YE","Yemen","Rial","YER"]
["ZM","Zambia","Kwacha","ZMK"]
["ZW","Zimbabwe","Zimbabwe Dollar","ZWD"]
["AX","Aland Islands","Euro","EUR"]
["AO","Angola","Angolan kwanza","AOA"]
["AQ","Antarctica","Antarctican dollar","AQD"]
["BA","Bosnia and Herzegovina","Bosnia and Herzegovina convertible mark","BAM"]
["CD","Congo (Kinshasa)","Congolese Frank","CDF"]
["GH","Ghana","Ghana cedi","GHS"]
["GG","Guernsey","Guernsey pound","GGP"]
["IM","Isle of Man","Manx pound","GBP"]
["LA","Laos","Lao kip","LAK"]
["MO","Macao S.A.R.","Macanese pataca","MOP"]
["ME","Montenegro","Euro","EUR"]
["PS","Palestinian Territory","Jordanian dinar","JOD"]
["BL","Saint Barthelemy","Euro","EUR"]
["SH","Saint Helena","Saint Helena pound","GBP"]
["MF","Saint Martin (French part)","Netherlands Antillean guilder","ANG"]
["PM","Saint Pierre and Miquelon","Euro","EUR"]
["RS","Serbia","Serbian dinar","RSD"]
["USAF","US Armed Forces","US Dollar","USD"]

{"sheet":"Instructions","index":1,"n_rows":165,"n_cols":23,"rows_kept":165,"cut":false,"hidden":false,"merged":[[7,2,7,3],[10,2,10,3],[17,2,17,3],[8,2,8,3],[13,2,14,3]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AFN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMD"]
[null,null,"UK",null,null,null,null,"Germany",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANG"]
[null,null,"Please enter AGENCY",null,null,null,null,"Netherlands version 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AOA"]
[null,null,null,null,null,null,null,"Netherlands version 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARS"]
[null,null,"Instructions",null,null,null,null,"Romania",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BHD"]
[]
[null,null,"Please ensure you have read the Instructions to the Commercial templates before completion, and referred to the outlined budget on the 'Submission Overview' tab ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BMD"]
[null,null,"Please complete the FTE Overview tab, ensuring this is completed to populate the Submission Overview tab effectively and refer to the Definition of terms and Scope of Work (Appendix B3)  throughout "]
[]
[null,null,"In all worksheets:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF"]
[null,null,"-Please read the instructions in each worksheet carefully before completion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHW"]
[null,null,"-Please complete all cells coloured in light blue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLF"]
[null,null,"-Please do not alter any of or paste over the options in the drop-down menus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLP"]
[null,null,"-Where you are asked for a number, only enter numbers. If a commercial element is free of charge, enter 0 under cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CNY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CZK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DZD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EEK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EGP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FJD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FKP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GBP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GMD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GNF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GTQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GYD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HKD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HNL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HRK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ILS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IQD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JMD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JPY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KHR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KMF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KPW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KRW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KYD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KZT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LBP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LKR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LRD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LVL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LYD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MDL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MKD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MVR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MXN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MXV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MYR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NGN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PGK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PKR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PYG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RSD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RWF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SBD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SGD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SZL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TMM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TWD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TZS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UGX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UYU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UZS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VUV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XAF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XAG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XAU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XBB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XBC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XBD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XCD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XDR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XFO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XFU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XOF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XPD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XPF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XPT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZMK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZWD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please enter CURRENCY"]

{"sheet":"FTE Overview","index":2,"n_rows":646,"n_cols":12,"rows_kept":646,"cut":false,"hidden":false,"merged":[[8,1,8,5],[9,1,9,5],[7,1,7,5],[1,1,1,11],[2,1,2,11],[3,1,3,11],[6,1,6,5],[9,10,9,11],[5,7,5,8],[5,10,5,11],[5,1,5,5],[13,1,13,5],[15,1,15,5],[12,1,12,5],[10,1,10,5],[11,1,11,5],[14,7,14,8],[15,7,15,8],[17,1,17,5],[18,1,18,5],[19,1,19,5],[14,1,14,5]]}
[]
[null,{"$f":"Instructions!C8","v":"UK"}]
[null,{"$f":"Instructions!C9","v":"Please enter AGENCY"}]
[null,"FIXED FEE FTE OVERVIEW"]
[]
[null,"You are required to complete the table below with all agency personnel providing the required fixed fee remunerated services to CCS for a 12 month period. ",null,null,null,null,null,"Overhead Factor",null,null,"Profit"]
[null,"You must complete the tables to the right with Office Locations (and associated Overhead Factors), as well as your proposed Profit Margin (including % Subject to PRF).",null,null,null,null,null,"Office Location","% Overhead Factor",null,"% Profit Margin"]
[null,"Please refer to the \"Definition of Terms\" sheet for defintions/further instruction.",null,null,null,null,null,"Office Location 1",null,null,"% Subject to PRF"]
[null,null,null,null,null,null,null,"Office Location 2"]
[null,"Please complete the Banded Direct Labour Cost column with an annual salary figure for a single 100% FTE. [Cost should be based on salary + benefits.]",null,null,null,null,null,"Office Location 3",null,null,"Total Agency Profit Cost"]
[null,"Please complete the % Time (FTE) column with the proposed number of FTEs per Deliverable and Level of Seniority. For example, 2 full time FTEs would be inputted as 200%. ",null,null,null,null,null,"Office Location 4",null,null,"Non PRF Related",{"$f":"IFERROR(L13*(100%-L8),0)","v":0}]
[null,"Where no resource is proposed against a specific Deliverable and Level of Seniority, enter 0 in the % Time (FTE) column.",null,null,null,null,null,"Office Location 5",null,null,"PRF Related",{"$f":"IFERROR(L13*L8,0)","v":0}]
[null,"It is permissible for FTE allocation against specific deliverables to be fractional, e.g. 75% FTE. However, the final FTE allocations under each scope of work must add up to at least 100%.",null,null,null,null,null,"Office Location 6",null,null,"Total",{"$f":"L21-J21","v":0}]
[null,"Office Location columns are fixed based on the information inputted within the Overhead Factor table. You must only select from the drop-down list."]
[null,"Definitions of Levels of Seniority can be found on the \"Definition of Terms\" sheet.",null,null,null,null,null,"Total Overhead Cost"]
[null,"Please refer to the \"Submission Overview\" tab to review your submission in full.",null,null,null,null,null,{"$f":"$J$21-$H$21","v":0}]
[]
[null,"The Fixed Fee FTE will be funded by the collection of a channel neutral  % on net media charged to clients using the framework agreement"]
[null,"From the amounts collected, the Agency will only retain amounts necessarily to meet its cost and proposed profit margin (subject to PRF). All other amounts are returnable to CCS and/or GCS"]
[null,"CCS, GCS and the Agency will manage the ongoing % increase or decrease annual in line with an annual review of the agency scope of work and FTE allocation"]
[null,null,null,null,null,null,null,{"$f":"SUM(H23:H1048576)","v":0},null,{"$f":"SUM(J23:J1048576)","v":0},null,{"$f":"SUM(L23:L1048576)","v":0}]
[null,"Scope of Work","Deliverable","Level of Seniority","Banded Direct Labour Cost","Office Location","% Time (FTE)","Total Direct Labour Cost","% Overhead Factor","Agency Cost","% Profit Margin","Agency Profit Cost"]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Managing Partner",null,null,null,{"$f":"IF(ISBLANK(F23),\"Please specify office location\",E23*G23)","v":"Please specify office location"},{"$f":"IFERROR(IF(G23>0,VLOOKUP(F23,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H23*(1+I23),0)","v":0},{"$f":"IFERROR(IF(G23>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J23/(1-K23),0)","v":0}]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Senior Director",null,null,null,{"$f":"IF(ISBLANK(F24),\"Please specify office location\",E24*G24)","v":"Please specify office location"},{"$f":"IFERROR(IF(G24>0,VLOOKUP(F24,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H24*(1+I24),0)","v":0},{"$f":"IFERROR(IF(G24>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J24/(1-K24),0)","v":0}]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","OOH Media Buying Servies ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Excluded Site List ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Director",null,null,null,{"$f":"IF(ISBLANK(F88),\"Please specify office location\",E88*G88)","v":"Please specify office location"},{"$f":"IFERROR(IF(G88>0,VLOOKUP(F88,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H88*(1+I88),0)","v":0},{"$f":"IFERROR(IF(G88>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J88/(1-K88),0)","v":0}]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Managing Partner",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Senior Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Director",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Senior Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Account Manager",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Senior Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ","Executive",null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F107),\"Please specify office location\",E107*G107)","v":"Please specify office location"},{"$f":"IFERROR(IF(G107>0,VLOOKUP(F107,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H107*(1+I107),0)","v":0},{"$f":"IFERROR(IF(G107>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J107/(1-K107),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F112),\"Please specify office location\",E112*G112)","v":"Please specify office location"},{"$f":"IFERROR(IF(G112>0,VLOOKUP(F112,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H112*(1+I112),0)","v":0},{"$f":"IFERROR(IF(G112>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J112/(1-K112),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F176),\"Please specify office location\",E176*G176)","v":"Please specify office location"},{"$f":"IFERROR(IF(G176>0,VLOOKUP(F176,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H176*(1+I176),0)","v":0},{"$f":"IFERROR(IF(G176>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J176/(1-K176),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F240),\"Please specify office location\",E240*G240)","v":"Please specify office location"},{"$f":"IFERROR(IF(G240>0,VLOOKUP(F240,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H240*(1+I240),0)","v":0},{"$f":"IFERROR(IF(G240>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J240/(1-K240),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F304),\"Please specify office location\",E304*G304)","v":"Please specify office location"},{"$f":"IFERROR(IF(G304>0,VLOOKUP(F304,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H304*(1+I304),0)","v":0},{"$f":"IFERROR(IF(G304>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J304/(1-K304),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F368),\"Please specify office location\",E368*G368)","v":"Please specify office location"},{"$f":"IFERROR(IF(G368>0,VLOOKUP(F368,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H368*(1+I368),0)","v":0},{"$f":"IFERROR(IF(G368>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J368/(1-K368),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F432),\"Please specify office location\",E432*G432)","v":"Please specify office location"},{"$f":"IFERROR(IF(G432>0,VLOOKUP(F432,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H432*(1+I432),0)","v":0},{"$f":"IFERROR(IF(G432>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J432/(1-K432),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F496),\"Please specify office location\",E496*G496)","v":"Please specify office location"},{"$f":"IFERROR(IF(G496>0,VLOOKUP(F496,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H496*(1+I496),0)","v":0},{"$f":"IFERROR(IF(G496>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J496/(1-K496),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F560),\"Please specify office location\",E560*G560)","v":"Please specify office location"},{"$f":"IFERROR(IF(G560>0,VLOOKUP(F560,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H560*(1+I560),0)","v":0},{"$f":"IFERROR(IF(G560>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J560/(1-K560),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F624),\"Please specify office location\",E624*G624)","v":"Please specify office location"},{"$f":"IFERROR(IF(G624>0,VLOOKUP(F624,$H$8:$I$13,2,0),0),0)","v":0},{"$f":"IFERROR(H624*(1+I624),0)","v":0},{"$f":"IFERROR(IF(G624>0,$L$7,0),0)","v":0},{"$f":"IFERROR(J624/(1-K624),0)","v":0}]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]
[null,null,null,null,null,null,null,"Please specify office location",0,0,0,0]

{"sheet":"Submission Overview","index":3,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,1,19,2],[18,1,18,2],[17,1,17,2],[24,1,24,2],[23,1,23,2],[22,1,22,2],[21,1,21,2],[20,1,20,2],[29,1,29,2],[28,1,28,2],[27,1,27,2],[26,1,26,2],[25,1,25,2],[1,1,1,7],[2,1,2,7],[3,1,3,7],[16,1,16,2],[15,1,15,2],[6,5,6,7],[7,1,7,2]]}
[]
[null,{"$f":"Instructions!C8","v":"UK"}]
[null,{"$f":"Instructions!C9","v":"Please enter AGENCY"}]
[null,"SUBMISSION OVERVIEW"]
[]
[null,"Please review your submission by Scope of Work in the table below."]
[null,"Proposed Effective Commission Rate has been calculated and can be found in the table to the right.",null,"Estimated Annual Net Media Spend",null,"Framework Commission"]
[null,"Please state if a discount off the Agency Profit Cost would be offered in the scenario that a central client would be willing to pay the Agency Profit Cost. Please complete cell G13. Please note: this will not be part of the scoring assessment.",null,23289000,null,"Framework Commission",{"$f":"SUM(G9:G11)","v":349335},{"$f":"G8/$D$8","v":1.4999999999999999E-2}]
[null,null,null,null,null,"CCS Levy",{"$f":"$D$8*H9","v":232890},0.01]
[null,null,null,null,null,"Contingency Surplus",{"$f":"$D$8*H10","v":116445},5.0000000000000001E-3]
[null,null,null,null,null,"Agency Profit Cost",{"$f":"$E$15","v":0},{"$f":"G11/$D$8","v":0}]
[]
[null,null,null,null,null,"% Discount on Agency Profit Cost"]
[null,"If % Time (FTE) is highlighted red against any specific Scope of Work, you must review your submission and ensure that at least 100% FTE is proposed."]
[null,null,null,{"$f":"SUM(D17:D30)","v":0},{"$f":"SUM(E17:E30)","v":0},{"$f":"SUM(F17:F30)","v":0},{"$f":"SUM(G17:G30)","v":0},{"$f":"E15/$D$8","v":0}]
[null,"Scope of Work",null,"Agency Cost","Agency Profit Cost","% Time (FTE)","% Total Fee","% Effective Commission Rate"]
[null,"OOH Media Implementation",null,{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B17)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B17)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B17)","v":0},{"$f":"IFERROR(D17/SUM($D$17:$D$30),0)","v":0},{"$f":"E17/$D$8","v":0}]
[null,"OOH Media Buying",null,{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B18)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B18)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B18)","v":0},{"$f":"IFERROR(D18/SUM($D$17:$D$30),0)","v":0},{"$f":"E18/$D$8","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please refer to table below for breakdown of submission by deliverable"]
[null,null,null,{"$f":"SUM(D40:D51)","v":0},{"$f":"SUM(E40:E51)","v":0},{"$f":"SUM(F40:F51)","v":0}]
[null,"Scope of Work","Deliverable","Agency Cost","Agency Profit Cost","% Time (FTE)","% Scope of Work Fee","% Effective Commission Rate"]
[null,"OOH Media Implementation","OOH Media Plan Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B40,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C40)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B40,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C40)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B40,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C40)","v":0},{"$f":"IFERROR(D40/SUMIFS($D$40:$D$51,$B$40:$B$51,B40),0)","v":0},{"$f":"E40/$D$8","v":0}]
[null,"OOH Media Implementation","OOH Market Insight Documents(s)",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B41,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C41)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B41,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C41)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B41,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C41)","v":0},0,{"$f":"E41/$D$8","v":0}]
[null,"OOH Media Buying","OOH Media Buying Servies ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B42,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C42)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B42,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C42)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B42,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C42)","v":0},0,0]
[null,"OOH Media Buying","Excluded Site List ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B43,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C43)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B43,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C43)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B43,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C43)","v":0},0,0]
[null,"OOH Media Buying","Campaign Optimisation Service(s)  ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B44,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C44)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B44,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C44)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B44,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C44)","v":0},0,0]
[null,"OOH Media Buying","Media Campaign Reporting Service(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B45,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C45)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B45,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C45)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B45,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C45)","v":0},0,0]
[null,"OOH Media Buying","Log of Value Accrual and Allocation Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B46,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C46)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B46,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C46)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B46,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C46)","v":0},0,0]
[null,"OOH Media Buying","Log of Media Buy Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B47,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C47)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B47,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C47)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B47,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C47)","v":0},0,0]
[null,"OOH Media Buying","Clash Management Procedure Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B48,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C48)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B48,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C48)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B48,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C48)","v":0},0,0]
[null,"OOH Media Buying","Log of Traffic Assets Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B49,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C49)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B49,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C49)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B49,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C49)","v":0},0,0]
[null,"OOH Media Buying","Repository of evidence of Live Activity Services ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B50,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C50)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B50,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C50)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B50,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C50)","v":0},0,0]
[null,"OOH Media Buying","Campaign Reporting Document(s) ",{"$f":"SUMIFS('FTE Overview'!$J$23:$J$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B51,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C51)","v":0},{"$f":"SUMIFS('FTE Overview'!$L$23:$L$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B51,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C51)","v":0},{"$f":"SUMIFS('FTE Overview'!$G$23:$G$1048576,'FTE Overview'!$B$23:$B$1048576,'Submission Overview'!B51,'FTE Overview'!$C$23:$C$1048576,'Submission Overview'!C51)","v":0},0,0]

{"sheet":"Definition of Terms","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,12,1],[13,1,14,1],[15,1,20,1],[1,1,1,3],[21,1,23,1]]}
[]
[null,"Definition of Terms"]
[]
[null,null,"Term","Definition"]
[null,"Direct Labour Cost","Managing Partner","Member of Group or Agency Board. Minimum experience 7+ years."]
[null,null,"Senior Director","Senior Director level/Team Lead and ultimate responsibility for the team output minimum experience 7+ years."]
[null,null,"Director","Director level, general management responsibility for team, unit, discipline, specialism within agency. Minimum experience 5+ years"]
[null,null,"Senior Account Manager","Day to day management responsibility for team, unit, discipline, specialism within agency. Minimum experience 5+ years."]
[null,null,"Account Manager","Manages 2 or more executives, reporting into senior manager/associate director. Minimum experience 3+ years."]
[null,null,"Senior Executive","No management responsibilities, reporting into Manager, between 1 and 3 years experience "]
[null,null,"Executive","No management responsibilities. Minimum experience 1+ years."]
[null,null,"Banded Direct Labour Cost","Base cost for the level of seniority detailed"]
[null,null,"Total Direct Labour Cost","Base cost for the level of seniority detailed multiplied by % FTE "]
[null,"Overhead Factor","Office Location","The Agency must enter office locations and corresponding overhead factor."]
[null,null,"% Overhead Factor","Services considered to be included in the overhead factor are as follows: all non specified Senior Leadership roles,  all Advertising Operation Services, all Travel and sustenance costs."]
[null,"Profit","Profit","The Agency fee shall be based upon an anually reviewed fixed cost plus an agreed upon profit margin %"]
[null,null,"% Profit Margin","The Agency can make a proposal on profit margin up to 20%. A percentage of the Agency's profit margin must be subject to PRF."]
[null,null,"% Subject to PRF","The Agency can made a proposal on profit margin subject to PRF between 1-50%. i.e. profit margin set at 15%, with 50% of this subject to RPF"]
[null,null,"Total Agency Profit Cost","Total Agency cost inclusive of overhead and profit "]
[null,null,"Non PRF Related","% of Agency profit not related to PRF "]
[null,null,"PRF Related","% of Agency profit subject to PRF "]
[null,"Framework Commission","Framework Commission","Sum of CCS Levy, Contingency Surplus and Total Agency Profit Cost "]
[null,null,"CCS Levy","1% levy applied to all media spend to support CCS "]
[null,null,"Contingency Surplus","0.5% CCS contingency to cover unexpected costs which can't be accounted for in advance"]