{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Application","Application details","FILE NAMES MATRIX","CountryCodes","Reasons","ApplicationDE"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Application","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,1,6,3],[7,0,7,3],[8,0,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,2],[13,0,13,3],[14,0,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[28,1,28,3]]}
[]
[]
["Application for toll refund in Germany"]
[{"$f":" IF(ISERROR(FIND(\"TEMPLATE.xlsx\", CELL(\"filename\"))),\n\"Version \" & MID(CELL(\"filename\"), FIND(\".xlsx\", CELL(\"filename\")) - LEN(\".xlsx\"), 5),\n\"Version \" & MID(CELL(\"filename\"), FIND(\".xlsx\", CELL(\"filename\")) - LEN(\" TEMPLATE.xlsx\"), 5))","v":"Version v1.17"}]
["Important notice: \nThe BALM will charge on the refunded amount 20,00 euro administrative fee for each vehicle."]
[]
["Reference number (if any) "]
[]
["Customer Details"]
["Company name (*)"]
["Contract number"]
["Street / house number (*)","Street",null,"No."]
["City / ZIP code / Country code (*)","City","ZIP-code","- ? -"]
[]
["Bank Details"]
["Bank "]
["IBAN (*)"]
["SWIFT or BIC code (*)"]
["Account holder (if different)"]
[]
["List of needed Documents \n(please use standard file names of the FILE NAMES MATRIX)"]
["1) Application for refund (both scanned signed version and digitally filled version) (*)"]
["2) Details of the application (both scanned signed version and digitally filled version) (*)"]
["3) Authorisation to TLP (*)"]
["4) Registration certificate (*)"]
["5) Registration as non tollable vehicle (* if applicable)"]
["6) Additional proofs or statements from the client (if any). Only statements in German are allowed"]
[]
["(*) mandatory","Date and signature:  _____________________________________________"]

{"sheet":"Application details","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[32,0,32,8]]}
[]
["Details of the application"]
["(all columns are mandatory)"]
["Batch \nno.","Licence plate","Country","OBU ID \neg. '000490123456789","From \nDD.MM.AAAA hh:mm:ss","To \nDD.MM.AAAA hh:mm:ss","Total amount \n€","Telepass Invoices\neg. DE-12345/A","Reason"]
[1]
[{"$f":"A5+1","v":2}]
[{"$f":"A6+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[{"$f":"A30+1","v":27}]
[]
[{"$f":"Application!B29","v":"Date and signature:  _____________________________________________"}]

{"sheet":"FILE NAMES MATRIX","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
[]
["Standard file names for the application"]
["(simply copy & paste renaming)"]
["Document type","File name","Mandatory"]
["Application for toll refund form","Antrag.xlsx","Yes"]
["Application for toll refund form (signed and scanned)","Antrag.pdf","Yes"]
["Reimbursement request (signed letter)","Antrag - cover letter.pdf","No"]
["Authorisation form (signed)","Ermächtigung.pdf","Yes"]
["TLP Invoices (e.g. DE-12345/A)","DE-12345-A.pdf","Yes"]
["Toll Collect trip report (dated DD.MM.YYYY)","TC-Einzelfahrtnachweis_YYMMDD.pdf","Only for \ndouble charge"]
["Toll Collect toll statement (dated DD.MM.YYYY)","TC-Mautafustellung_YYMMDD.pdf","Only for \ndouble charge"]
["Other provider's toll statement (provider XXX, dated DD.MM.YYYY)","XXX-Mautafustellung_YYMMDD.pdf","Only for \ndouble charge"]
["Toll Collect registration as non tollable vehicle (licence plate e.g. AA123ZZ)","TC-Registrierung_AA123ZZ.pdf","Only for toll free vehicles"]
["Registration certificate of the truck (licence plate e.g. AA123ZZ)","Fahrzeugschein_AA123ZZ_VRC.pdf","Only for toll free vehicles or tariff errors"]
["COC of the truck (licence plate e.g. AA123ZZ)","Fahrzeugschein_AA123ZZ_COC.pdf","Only for toll free vehicles or tariff errors"]
["CIF of the truck (licence plate e.g. AA123ZZ)","Fahrzeugschein_AA123ZZ_CIF.pdf","Only for toll free vehicles or tariff errors"]

{"sheet":"CountryCodes","index":3,"n_rows":182,"n_cols":2,"rows_kept":182,"hidden":true}
["- ? -"]
["AD","ANDORRA"]
["AE","EMIRATI ARABI"]
["AF","AFGHANISTAN"]
["AL","ALBANIA"]
["AM","ARMENIA"]
["AN","ANTILLE OLANDESI"]
["AR","ARGENTINA"]
["AT","AUSTRIA"]
["AU","AUSTRALIA"]
["BA","BOSNIA E ERZEGOVINA"]
["BB","BARBADOS"]
["BD","BANGLADESH"]
["BE","BELGIO"]
["BG","BULGARIA"]
["BH","BAHRAIN"]
["BI","BURUNDI"]
["BJ","BENIN"]
["BN","BRUNEI DARUSSALAM"]
["BO","BOLIVIA"]
["BR","BRASILE"]
["BS","BAHAMAS"]
["BW","BOTSWANA"]
["BY","BIELORUSSIA"]
["BZ","BELIZE"]
["CA","CANADA"]
["CD","CONGO (REPUBBLICA DEMOCRATICA DEL)"]
["CF","CENTROAFRICANA (REPUBBLICA)"]
["CH","SVIZZERA"]
["CI","COSTA D'AVORIO"]
["CL","CILE"]
["CM","CAMEROON"]
["CN","CINA"]
["CO","COLOMBIA"]
["CR","COSTA RICA"]
["CU","CUBA"]
["CV","CAPO VERDE"]
["CV","CAPO VERDE"]
["CY","CIPRO"]
["CZ","CECA (REPUBBLICA)."]
["CZ","CECA (REPUBBLICA)"]
["DE","GERMANIA"]
["DK","DANIMARCA"]
["DM","DOMINICA"]
["DO","DOMINICANA (REPUBBLICA)"]
["DZ","ALGERIA"]
["EC","ECUADOR"]
["EE","ESTONIA"]
["EG","EGITTO"]
["ER","ERITREA"]
["ES","SPAGNA"]
["ET","ETIOPIA"]
["FI","FINLANDIA"]
["FJ","FIJI"]
["FO","FAER OER ISOLE"]
["FR","FRANCIA"]
["GA","GABON"]
["GB","REGNO UNITO"]
["GD","GRENADA"]
["GE","GEORGIA"]
["GG","GUERNSEY C.I."]
["GH","GHANA"]
["GI","GIBILTERRA"]
["GL","GROELANDIA"]
["GM","GAMBIA"]
["GQ","GUINEA EQUATORIALE"]
["GR","GRECIA"]
["GT","GUATEMALA"]
["GW","GUINEA BISSAU"]
["GY","GUYANA"]
["HK","HONG KONG"]
["HR","CROAZIA"]
["HT","HAITI"]
["HU","UNGHERIA"]
["ID","INDONESIA"]
["IE","IRLANDA"]
["IL","ISRAELE"]
["IN","INDIA"]
["IQ","IRAQ"]
["IR","IRAN (REPUBBLICA ISLAMICA DI)"]
["IS","ISLANDA"]
["IT","ITALIA"]
["JE","JERSEY C.I."]
["JM","GIAMAICA"]
["JO","GIORDANIA"]
["JP","GIAPPONE"]
["KE","KENYA"]
["KG","KYRGYZSTAN"]
["KH","CAMBOGIA"]
["KI","KIRATI"]
["KR","COREA DEL SUD (REPUBBLICA DI)"]
["KW","KUWAIT"]
["KZ","KAZAKISTAN"]
["LA","LAOS (REP DEMOCRATICA POP)"]
["LB","LIBANO"]
["LI","LIECHTENSTEIN"]
["LK","SRI LANKA"]
["LR","LIBERIA"]
["LS","LESOTHO"]
["LT","LITUANIA"]
["LU","LUSSEMBURGO"]
["LV","LETTONIA"]
["LY","LIBIA"]
["MA","MAROCCO"]
["MC","PRINCIPATO DI MONACO"]
["MD","MOLDAVIA (REPUBBLICA DI)"]
["ME","MONTENEGRO"]
["MG","MADAGASCAR"]
["MK","MACEDONIA"]
["ML","MALI"]
["MO","MACAO"]
["MQ","MARTINICA"]
["MR","MAURITANIA"]
["MT","MALTA"]
["MU","MAURITIUS ISOLE"]
["MW","MALAWI"]
["MX","MESSICO"]
["MY","MALAYSIA"]
["MZ","MOZAMBICO"]
["NA","NAMIBIA"]
["NE","NIGER"]
["NG","NIGERIA"]
["NI","NICARAGUA"]
["NL","PAESI BASSI"]
["NO","NORVEGIA"]
["NP","NEPAL"]
["NZ","NUOVA ZELANDA"]
["PA","PANAMA"]
["PE","PERU'"]
["PG","PAPUA NUOVA GUINEA"]
["PH","FILIPPINE"]
["PK","PAKISTAN"]
["PL","POLONIA"]
["PL","STRANIERO"]
["PR","PORTORICO"]
["PT","PORTOGALLO"]
["PY","PARAGUAY"]
["QA","QATAR"]
["RE","REUNION"]
["RO","ROMANIA"]
["RS","SERBIA"]
["RU","RUSSIA (FEDERAZIONE DI)"]
["RW","RWANDA"]
["SA","ARABIA SAUDITA"]
["SC","SEYCHELLES"]
["SD","SUDAN"]
["SE","SVEZIA"]
["SG","SINGAPORE"]
["SI","SLOVENIA"]
["SK","SLOVACCHIA"]
["SL","SIERRA LEONE"]
["SM","SAN MARINO"]
["SN","SENEGAL"]
["SO","SOMALIA"]
["SR","SURINAME"]
["SV","EL SALVADOR"]
["SY","SIRIA"]
["SZ","SWAZILAND"]
["TD","CIAD"]
["TG","TOGO"]
["TH","THAILANDIA"]
["TJ","TAGIKISTAN"]
["TM","TURKMENISTAN"]
["TN","TUNISIA"]
["TR","TURCHIA"]
["TT","TRINIDAD E TOBAGO"]
["TW","TAIWAN"]
["TZ","TANZANIA (REPUBBLICA DI)"]
["UA","UCRAINA"]
["UG","UGANDA"]
["US","STATI UNITI"]
["UY","URUGUAY"]
["VA","SANTA SEDE (CITTA' DEL VATICANO)"]
["VC","ST. VINCENTE E LE GRENADINE"]
["VE","VENEZUELA"]
["VN","VIETNAM"]
["VU","VANUATU"]
["WS","SAMOA"]
["YE","YEMEN"]
["ZA","SUDAFRICANA (REPUBBLICA)"]
["ZM","ZAMBIA"]
["ZW","ZIMBABWE"]

{"sheet":"Reasons","index":4,"n_rows":15,"n_cols":1,"rows_kept":15,"hidden":true}
[]
["Double charge (Telepass + other operator)"]
["Invoiced by Telepass twice"]
["LNG vehicle (Registration certificate + Toll Collect registration confirmation required)"]
["Zero Emission Vehicle (Registration certificate + Toll Collect registration confirmation required)"]
["Bus (Registration certificate required)"]
["Humanitarian transport (Toll Collect registration confirmation required)"]
["Other non tollable vehicle (Toll Collect registration confirmation required)"]
["Working in a construction site (proofs required)"]
["Trip never perfomed"]
["Tariff error: better CO2 class (proofs required)"]
["Tariff error: lower weight class (proofs required)"]
["Tariff error: better Euro class (proofs required)"]
["Other tariff error (additional proofs required)"]
["Other (see additional statement)"]

{"sheet":"ApplicationDE","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,1,6,3],[7,0,7,3],[8,0,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,2],[13,0,13,3],[14,0,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[27,1,27,3]]}
[]
[]
["Formular zur Erstattung der Lkw-Maut"]
[{"$f":"Application!A4","v":"Version v1.17"}]
["Wichtiger Hinweis: \nDas BAG wird pro Fahrzeug 20,00 Euro Verwaltungsgebühr vom Erstattungsbetrag abziehen."]
[]
[" ggf. Bezugsnummer ",{"$f":"IF(Application!B7=0,\"\",Application!B7)","v":""}]
[]
["Angaben zum Antragsteller"]
["Firma (*)",{"$f":"IF(Application!B10=0,\"\",Application!B10)","v":""}]
["Vertragsnummer ",{"$f":"IF(Application!B11=0,\"\",Application!B11)","v":""}]
["Adresse / Hausnummer (*)",{"$f":"IF(OR(Application!B12=0, Application!B12=\"Street\"),\"\",Application!B12)","v":""},null,{"$f":"IF(OR(Application!D12=0, Application!D12=\"No.\"),\"\",Application!D12)","v":""}]
["Ort / PLZ / Landeskennzeichen (*)",{"$f":"IF(OR(Application!B13=0, Application!B13=\"City\"),\"\",Application!B13)","v":""},{"$f":"IF(OR(Application!C13=0, Application!C13=\"ZIP-code\"),\"\",Application!C13)","v":""},{"$f":"IF(Application!D13=\"- ? -\",\"\",Application!D13)","v":""}]
[]
["Angaben zur Bankverbindung"]
["Bank ",{"$f":"IF(Application!B16=0,\"\",Application!B16)","v":""}]
["IBAN (*)",{"$f":"IF(Application!B17=0,\"\",SUBSTITUTE(Application!B17,\" \",\"\"))","v":""}]
["SWIFT or BIC code (*)",{"$f":"IF(Application!B18=0,\"\",SUBSTITUTE(Application!B18,\" \",\"\"))","v":""}]
["Kontoinhaber (falls abweichend)",{"$f":"IF(Application!B19=0,\"\",Application!B19)","v":""}]
[]
["Liste der benötigten Unterlagen"]
["1) Antrag (*)"]
["2) Details of the application (*)"]
["3) Ermächtigung zu TLP (*)"]
["4) Registrierung als nicht mautpflichtiges Fahrzeug (* falls zutreffend)"]
["5) ggf. Zusätzliche Unterlagen oder  Aussagen vom Kunden"]
[]
["(*) unbedingt notwendig",{"$f":"IF(Application!B29= \"Date and signature:  _____________________________________________\", \"Datum und Unterschrift: _________________________________________\", SUBSTITUTE(Application!B29, \"_\", \"\"))","v":"Datum und Unterschrift: _________________________________________"}]