{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Selection future payment","Datenbasis1","Hilfsvariablen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":63,"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":"Selection future payment","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[17,0,17,1],[18,0,18,1],[32,0,32,1],[18,3,39,3],[36,0,36,1],[39,0,39,1],[38,0,38,1],[35,0,35,1],[31,0,31,1],[19,0,19,1],[20,0,20,1],[33,0,33,1]]}
["Tariff-based future payment"]
[]
["Company",null,null,"<--- Select a company to start"]
["Entry date before 04 January 2022","yes"]
["Employee group","tariff-employee"]
["Pay scale group","E01"]
["Pay scale category","-"]
["Pay scale level","-"]
["Federal State","Bavaria"]
["Employment level on 03 January 2022 ( = actual working hours) ",1]
["Regular weekly working days 2022",5]
["Type of contract ","permanent contract"]
["Parental leave, sickness, partial retirement, leave of absence \n(compensatory time account) in 1/2022?","no"]
["No entitlement to remuneration on 03 January 2022 \n(e.g. parental leave, long-term sickness, …)","no"]
["Partial retirement on 03 January 2022","no"]
["Paid leave of absence (compensatory time account)  > 1 year 1/2022","no"]
[]
["Result for tariff-based future payment 2022",null,null,"Hints for usage"]
[{"$f":"Hilfsvariablen!B16","v":"Please select a company and then fill out the form from top to bottom!"},null,null,"- To simplify editing, a macro is necessary, click in the dialog <activate macros> or click in the yellow menu bar <activate content>\n\n- The form is to be filled out from top to bottom, because some choices depend on each other\n\n- If you change an entry afterwards, all the following selection options must be checked again for valid values"]
[]
["There are various possible intended uses available to you.\nHere you can test how the choice of uses affects your tariff-based future payment:"]
["Possible intended uses","-"]
["PlusCard tariff","select"]
["Would you like to insure family members as well?","no"]
["PlusCard tariff for family members","comfort"]
["Age of spouse","-"]
["Age of child 1","-"]
["Age of child 2","-"]
["Age of child 3","-"]
["Number of requested days off","1 day in lieu"]
[]
["Result of the selected use option 2022"]
[{"$f":"Hilfsvariablen!B27","v":"Please select a company and then fill out the form from top to bottom!"}]
["If you have chosen one of the above options for intended use, please fill in the election form and return it to CHR by 31.10.2021."]
[]
["Please note"]
["Further imformation about your options and the selection form can be found in the download area of our  website:\nwww.fresenius-benefits.de/en/future-payment"]
[]
["Disclaimer"]
["This document is a simplified representation of the provisions of the “Moderne Arbeitswelt” [modern working world] collective agreement of 22.11.2019 and the „Tariflicher Zukunftsbetrag“ [tariff-based future payment] company-wide works agreement of 12.08.2020 and is for information purposes only.\nOnly the collective agreement and the company-wide works agreement itself are legally binding. \n© Corporate Human Resources, Fresenius SE & Co. KGaA, August 2021"]

{"sheet":"Datenbasis1","index":1,"n_rows":501,"n_cols":48,"rows_kept":501,"cut":false,"hidden":true,"merged":[]}
["Gesellschaften","PassenderTarifvertrag",null,"Mitarbeitergruppe",null,"Tarifgruppe",null,null,null,null,null,"Tariftyp",null,null,null,null,"Bundesland",null,"Beschäftigungsverhältnis",null,"Ja/Nein",null,"ATZ",null,"Wochenarbeitstage",null,"Verwendungsmöglichkeiten",null,"PlusCard Tarife",null,null,"PlusCard Tarife Familienangehörige",null,null,null,"Alter Familienangehörige",null,null,null,null,"PlusCard Tariftabelle Familienangehörige",null,null,null,null,null,"Anzahl Freistellungstage"]
["Fresenius SE & Co. KGaA","yes",null,"tariff-employee",null,"E01","-",null,null,null,null,"E01","-",null,null,null,"Bavaria",null,"permanent contract",null,"yes",null,"no",null,5,null,"Days in lieu & Compensatory time account",null,"select",12.67,null,"comfort","select",null,null,"Ehepartner","-","19 - 67 years","from 68 years",null,{"$f":"CONCATENATE(AP2,\"_\",AQ2,\"_\",AR2)","v":"Ehepartner_-_comfort"},"Ehepartner","-","comfort",0,null,"1 day in lieu",1]
["Fresenius Medical Care AG & Co. KGaA","yes",null,"non-tariff employee",null,"E02","-",null,null,null,null,"E02","-",null,null,null,"other federal state",null,"fixed-term contract",null,"no",null,"working period",null,4,null,"Days in lieu & PlusCard",null,"premium",16.48,null,"comfort","select","premium",null,"Kind","-","0 - 18 years","19 - 25 years",null,{"$f":"CONCATENATE(AP3,\"_\",AQ3,\"_\",AR3)","v":"Ehepartner_19 - 67 years_comfort"},"Ehepartner","19 - 67 years","comfort",6.38,null,"2 days in lieu",2]
["Fresenius Medical Care Deutschland GmbH","yes",null,"executives",null,"E03","-",null,null,null,null,"E03","-",null,null,null,null,null,null,null,null,null,"retirement period",null,3,null,"Compensatory time account",null,"prevent",70.010000000000005,null,"comfort","select","premium","prevent",null,null,null,null,null,"Ehepartner_from 68 years_comfort","Ehepartner","from 68 years","comfort",8.2899999999999991,null,"3 days in lieu",3]
["Fresenius Medical Care GmbH","yes",null,"apprentice",null,"E04","-",null,null,null,null,"E04","-",null,null,null,null,null,null,null,null,null,null,null,2,null,"Compensatory time account & PlusCard",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_-_comfort","Kind","-","comfort",0]
["Fresenius Kabi AG","yes",null,"dual student",null,"E05","A, or 1","B, or 2","C, or 3",null,null,"E05","-",null,null,null,null,null,null,null,null,null,null,null,1,null,"PlusCard",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_0 - 18 years_comfort","Kind","0 - 18 years","comfort",2.46]
["Fresenius Kabi Deutschland GmbH (not Mihla/Bad Hersfeld)","yes",null,"Mini-Job",null,"E06","A, or 1","B, or 2","C, or 3","D, or 4",null,"E06","-",null,null,null,null,null,null,null,null,null,null,null,4.99,null,"Days in lieu & Payment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_19 - 25 years_comfort","Kind","19 - 25 years","comfort",6.38]
["Fresenius Digital Technology GmbH","yes",null,"Midi-Job",null,"E07","A, or 1","B, or 2","C, or 3","D, or 4",null,"E07","-",null,null,null,null,null,null,null,null,null,null,null,4.9800000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_-_select","Ehepartner","-","select",0]
["Fresenius Versicherungsvermittlungs GmbH","yes",null,null,null,"E08","A, or 1","B, or 2","C, or 3","D, or 4",null,"E08","-",null,null,null,null,null,null,null,null,null,null,null,4.97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_19 - 67 years_select","Ehepartner","19 - 67 years","select",22.97]
["Hyginus Publisher GmbH","yes",null,null,null,"E09","A, or 1","B, or 2","C, or 3","D, or 4",null,"E09","administrative","technical","foreman",null,null,null,null,null,null,null,null,null,4.96,null,"FreistellungMöglich_Befristet_AlterteilzeitPassivOderOhneEntgeltOderFreigestellt",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_from 68 years_select","Ehepartner","from 68 years","select",29.86]
["Fresenius HemoCare GmbH","yes",null,null,null,"E10","A, or 1","B, or 2","C, or 3","D, or 4",null,"E10","administrative","technical","foreman",null,null,null,null,null,null,null,null,null,4.95,null,"Ja_Ja_Nein","Days in lieu & Payment",null,null,null,null,null,null,null,null,null,null,null,null,"Kind_-_select","Kind","-","select",0]
["other Fresenius company","no",null,null,null,"E11","A, or 1","B, or 2","C, or 3","D, or 4",null,"E11","administrative","technical","foreman",null,null,null,null,null,null,null,null,null,4.9400000000000004,null,"Ja_Ja_Ja","Days in lieu & Payment",null,null,null,null,null,null,null,null,null,null,null,null,"Kind_0 - 18 years_select","Kind","0 - 18 years","select",8.84]
[null,null,null,null,null,"E12","A, or 1","B, or 2","C, or 3","D, or 4",null,"E12","administrative","technical","foreman",null,null,null,null,null,null,null,null,null,4.93,null,"Ja_Nein_Nein","Days in lieu & Compensatory time account","Days in lieu & PlusCard","Compensatory time account","Compensatory time account & PlusCard","PlusCard",null,null,null,null,null,null,null,null,"Kind_19 - 25 years_select","Kind","19 - 25 years","select",22.97]
[null,null,null,null,null,"E13","-",null,null,null,null,"E13","administrative","technical","foreman",null,null,null,null,null,null,null,null,null,4.92,null,"Ja_Nein_Ja","Days in lieu & PlusCard","PlusCard",null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_-_premium","Ehepartner","-","premium",0]
[null,null,null,null,null,"Azubi","1st year","2nd year","3rd year","4th year",null,"Azubi","-",null,null,null,null,null,null,null,null,null,null,null,4.91,null,"Nein_Ja_Nein",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_19 - 67 years_premium","Ehepartner","19 - 67 years","premium",27.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000004,null,"Nein_Ja_Ja",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_from 68 years_premium","Ehepartner","from 68 years","premium",36.299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8899999999999997,null,"Nein_Nein_Nein","Compensatory time account","Compensatory time account & PlusCard","PlusCard",null,null,null,null,null,null,null,null,null,null,"Kind_-_premium","Kind","-","premium",0]
["Entgelttabellen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.88,null,"Nein_Nein_Ja","PlusCard",null,null,null,null,null,null,null,null,null,null,null,null,"Kind_0 - 18 years_premium","Kind","0 - 18 years","premium",10.74]
[{"$f":"CONCATENATE(B19,\"_\",C19,\"_\",D19,\"_\",E19,\"_\",F19)","v":"2022_other federal state_E01_-_-"},2022,"other federal state","E01","-","-",2730,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_19 - 25 years_premium","Kind","19 - 25 years","premium",27.92]
[{"$f":"CONCATENATE(B20,\"_\",C20,\"_\",D20,\"_\",E20,\"_\",F20)","v":"2022_other federal state_E02_-_-"},2022,"other federal state","E02","-","-",2853,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8600000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_-_prevent","Ehepartner","-","prevent",0]
[{"$f":"CONCATENATE(B21,\"_\",C21,\"_\",D21,\"_\",E21,\"_\",F21)","v":"2022_other federal state_E03_-_-"},2022,"other federal state","E03","-","-",2911,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8499999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_19 - 67 years_prevent","Ehepartner","19 - 67 years","prevent",97.51]
["2022_other federal state_E04_-_-",2022,"other federal state","E04","-","-",2950,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehepartner_from 68 years_prevent","Ehepartner","from 68 years","prevent",126.76]
["2022_other federal state_E05_A, or 1_-",2022,"other federal state","E05","A, or 1","-",3035,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_-_prevent","Kind","-","prevent",0]
["2022_other federal state_E05_B, or 2_-",2022,"other federal state","E05","B, or 2","-",3111,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_0 - 18 years_prevent","Kind","0 - 18 years","prevent",37.51]
["2022_other federal state_E05_C, or 3_-",2022,"other federal state","E05","C, or 3","-",3187,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8099999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kind_19 - 25 years_prevent","Kind","19 - 25 years","prevent",97.51]
["2022_other federal state_E06_A, or 1_-",2022,"other federal state","E06","A, or 1","-",3113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8]
["2022_other federal state_E06_B, or 2_-",2022,"other federal state","E06","B, or 2","-",3300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.79]
["2022_other federal state_E06_C, or 3_-",2022,"other federal state","E06","C, or 3","-",3455,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.78]
["2022_other federal state_E06_D, or 4_-",2022,"other federal state","E06","D, or 4","-",3611,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7699999999999996]
["2022_other federal state_E07_A, or 1_-",2022,"other federal state","E07","A, or 1","-",3226,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.76]
["2022_other federal state_E07_B, or 2_-",2022,"other federal state","E07","B, or 2","-",3420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75]
["2022_other federal state_E07_C, or 3_-",2022,"other federal state","E07","C, or 3","-",3613,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.74]
["2022_other federal state_E07_D, or 4_-",2022,"other federal state","E07","D, or 4","-",3807,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7300000000000004]
["2022_other federal state_E08_A, or 1_-",2022,"other federal state","E08","A, or 1","-",3338,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.72]
["2022_other federal state_E08_B, or 2_-",2022,"other federal state","E08","B, or 2","-",3538,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.71]
["2022_other federal state_E08_C, or 3_-",2022,"other federal state","E08","C, or 3","-",3772,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7]
["2022_other federal state_E08_D, or 4_-",2022,"other federal state","E08","D, or 4","-",4006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6900000000000004]
["2022_other federal state_E09_A, or 1_administrative",2022,"other federal state","E09","A, or 1","administrative",3127,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.68]
["2022_other federal state_E09_B, or 2_administrative",2022,"other federal state","E09","B, or 2","administrative",3422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.67]
["2022_other federal state_E09_C, or 3_administrative",2022,"other federal state","E09","C, or 3","administrative",3760,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.66]
["2022_other federal state_E09_D, or 4_administrative",2022,"other federal state","E09","D, or 4","administrative",4225,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6500000000000004]
["2022_other federal state_E09_A, or 1_technical",2022,"other federal state","E09","A, or 1","technical",3439,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6399999999999997]
["2022_other federal state_E09_B, or 2_technical",2022,"other federal state","E09","B, or 2","technical",3764,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.63]
["2022_other federal state_E09_C, or 3_technical",2022,"other federal state","E09","C, or 3","technical",4136,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.62]
["2022_other federal state_E09_D, or 4_technical",2022,"other federal state","E09","D, or 4","technical",4647,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6100000000000003]
["2022_other federal state_E09_A, or 1_foreman",2022,"other federal state","E09","A, or 1","foreman",3430,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5999999999999996]
["2022_other federal state_E09_B, or 2_foreman",2022,"other federal state","E09","B, or 2","foreman",3754,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.59]
["2022_other federal state_E09_C, or 3_foreman",2022,"other federal state","E09","C, or 3","foreman",4125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.58]
["2022_other federal state_E09_D, or 4_foreman",2022,"other federal state","E09","D, or 4","foreman",4635,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.57]
[{"$f":"CONCATENATE(B50,\"_\",C50,\"_\",D50,\"_\",E50,\"_\",F50)","v":"2022_other federal state_E10_A, or 1_administrative"},2022,"other federal state","E10","A, or 1","administrative",3603,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5599999999999996]
["2022_other federal state_E10_B, or 2_administrative",2022,"other federal state","E10","B, or 2","administrative",3935,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.55]
["2022_other federal state_E10_C, or 3_administrative",2022,"other federal state","E10","C, or 3","administrative",4314,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.54]
["2022_other federal state_E10_D, or 4_administrative",2022,"other federal state","E10","D, or 4","administrative",4741,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.53]
["2022_other federal state_E10_A, or 1_technical",2022,"other federal state","E10","A, or 1","technical",3865,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5199999999999996]
["2022_other federal state_E10_B, or 2_technical",2022,"other federal state","E10","B, or 2","technical",4221,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.51]
["2022_other federal state_E10_C, or 3_technical",2022,"other federal state","E10","C, or 3","technical",4627,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
["2022_other federal state_E10_D, or 4_technical",2022,"other federal state","E10","D, or 4","technical",5085,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.49]
["2022_other federal state_E10_A, or 1_foreman",2022,"other federal state","E10","A, or 1","foreman",3815,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4800000000000004]
["2022_other federal state_E10_B, or 2_foreman",2022,"other federal state","E10","B, or 2","foreman",4167,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.47]
["2022_other federal state_E10_C, or 3_foreman",2022,"other federal state","E10","C, or 3","foreman",4568,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.46]
["2022_other federal state_E10_D, or 4_foreman",2022,"other federal state","E10","D, or 4","foreman",5020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.45]
[{"$f":"CONCATENATE(B62,\"_\",C62,\"_\",D62,\"_\",E62,\"_\",F62)","v":"2022_other federal state_E11_A, or 1_administrative"},2022,"other federal state","E11","A, or 1","administrative",4095,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4400000000000004]
["2022_other federal state_E11_B, or 2_administrative",2022,"other federal state","E11","B, or 2","administrative",4463,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.43]
["2022_other federal state_E11_C, or 3_administrative",2022,"other federal state","E11","C, or 3","administrative",4778,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.42]
["2022_other federal state_E11_D, or 4_administrative",2022,"other federal state","E11","D, or 4","administrative",5250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.41]
["2022_other federal state_E11_A, or 1_technical",2022,"other federal state","E11","A, or 1","technical",4315,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4000000000000004]
["2022_other federal state_E11_B, or 2_technical",2022,"other federal state","E11","B, or 2","technical",4702,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3899999999999997]
["2022_other federal state_E11_C, or 3_technical",2022,"other federal state","E11","C, or 3","technical",5034,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.38]
["2022_other federal state_E11_D, or 4_technical",2022,"other federal state","E11","D, or 4","technical",5532,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.37]
["2022_other federal state_E11_A, or 1_foreman",2022,"other federal state","E11","A, or 1","foreman",4220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3600000000000003]
["2022_other federal state_E11_B, or 2_foreman",2022,"other federal state","E11","B, or 2","foreman",4599,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3499999999999996]
["2022_other federal state_E11_C, or 3_foreman",2022,"other federal state","E11","C, or 3","foreman",4923,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.34]
["2022_other federal state_E11_D, or 4_foreman",2022,"other federal state","E11","D, or 4","foreman",5410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.33]
[{"$f":"CONCATENATE(B74,\"_\",C74,\"_\",D74,\"_\",E74,\"_\",F74)","v":"2022_other federal state_E12_A, or 1_administrative"},2022,"other federal state","E12","A, or 1","administrative",4399,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.32]
["2022_other federal state_E12_B, or 2_administrative",2022,"other federal state","E12","B, or 2","administrative",4794,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3099999999999996]
["2022_other federal state_E12_C, or 3_administrative",2022,"other federal state","E12","C, or 3","administrative",5189,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3]
["2022_other federal state_E12_D, or 4_administrative",2022,"other federal state","E12","D, or 4","administrative",5640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.29]
["2022_other federal state_E12_A, or 1_technical",2022,"other federal state","E12","A, or 1","technical",4662,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.28]
["2022_other federal state_E12_B, or 2_technical",2022,"other federal state","E12","B, or 2","technical",5080,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2699999999999996]
["2022_other federal state_E12_C, or 3_technical",2022,"other federal state","E12","C, or 3","technical",5499,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.26]
["2022_other federal state_E12_D, or 4_technical",2022,"other federal state","E12","D, or 4","technical",5977,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.25]
["2022_other federal state_E12_A, or 1_foreman",2022,"other federal state","E12","A, or 1","foreman",4537,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.24]
["2022_other federal state_E12_B, or 2_foreman",2022,"other federal state","E12","B, or 2","foreman",4944,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2300000000000004]
["2022_other federal state_E12_C, or 3_foreman",2022,"other federal state","E12","C, or 3","foreman",5352,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.22]
["2022_other federal state_E12_D, or 4_foreman",2022,"other federal state","E12","D, or 4","foreman",5817,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.21]
[{"$f":"CONCATENATE(B86,\"_\",C86,\"_\",D86,\"_\",E86,\"_\",F86)","v":"2022_other federal state_E13_-_administrative"},2022,"other federal state","E13","-","administrative",6033,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2]
["2022_other federal state_E13_-_technical",2022,"other federal state","E13","-","technical",6421,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1900000000000004]
["2022_other federal state_E13_-_foreman",2022,"other federal state","E13","-","foreman",6225,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.18]
["2022_other federal state_Azubi_1st year_-",2022,"other federal state","Azubi","1st year","-",1014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.17]
[{"$f":"CONCATENATE(B90,\"_\",C90,\"_\",D90,\"_\",E90,\"_\",F90)","v":"2022_other federal state_Azubi_2nd year_-"},2022,"other federal state","Azubi","2nd year","-",1093,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.16]
["2022_other federal state_Azubi_3rd year_-",2022,"other federal state","Azubi","3rd year","-",1153,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1500000000000004]
["2022_other federal state_Azubi_4th year_-",2022,"other federal state","Azubi","4th year","-",1239,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1399999999999997]
[{"$f":"CONCATENATE(B93,\"_\",C93,\"_\",D93,\"_\",E93,\"_\",F93)","v":"2022_Bavaria_E01_-_-"},2022,"Bavaria","E01","-","-",2701,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.13]
[{"$f":"CONCATENATE(B94,\"_\",C94,\"_\",D94,\"_\",E94,\"_\",F94)","v":"2022_Bavaria_E02_-_-"},2022,"Bavaria","E02","-","-",2821,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.12]
[{"$f":"CONCATENATE(B95,\"_\",C95,\"_\",D95,\"_\",E95,\"_\",F95)","v":"2022_Bavaria_E03_-_-"},2022,"Bavaria","E03","-","-",2886,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1100000000000003]
["2022_Bavaria_E04_-_-",2022,"Bavaria","E04","-","-",2949,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996]
["2022_Bavaria_E05_A, or 1_-",2022,"Bavaria","E05","A, or 1","-",3020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.09]
["2022_Bavaria_E05_B, or 2_-",2022,"Bavaria","E05","B, or 2","-",3096,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.08]
["2022_Bavaria_E05_C, or 3_-",2022,"Bavaria","E05","C, or 3","-",3171,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.07]
["2022_Bavaria_E06_A, or 1_-",2022,"Bavaria","E06","A, or 1","-",3088,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0599999999999996]
["2022_Bavaria_E06_B, or 2_-",2022,"Bavaria","E06","B, or 2","-",3273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.05]
["2022_Bavaria_E06_C, or 3_-",2022,"Bavaria","E06","C, or 3","-",3428,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.04]
["2022_Bavaria_E06_D, or 4_-",2022,"Bavaria","E06","D, or 4","-",3582,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.03]
["2022_Bavaria_E07_A, or 1_-",2022,"Bavaria","E07","A, or 1","-",3204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0199999999999996]
["2022_Bavaria_E07_B, or 2_-",2022,"Bavaria","E07","B, or 2","-",3396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.01]
["2022_Bavaria_E07_C, or 3_-",2022,"Bavaria","E07","C, or 3","-",3588,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.99]
["2022_Bavaria_E07_D, or 4_-",2022,"Bavaria","E07","D, or 4","-",3781,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.98]
["2022_Bavaria_E08_A, or 1_-",2022,"Bavaria","E08","A, or 1","-",3316,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.97]
["2022_Bavaria_E08_B, or 2_-",2022,"Bavaria","E08","B, or 2","-",3515,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.96]
["2022_Bavaria_E08_C, or 3_-",2022,"Bavaria","E08","C, or 3","-",3747,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.95]
["2022_Bavaria_E08_D, or 4_-",2022,"Bavaria","E08","D, or 4","-",3979,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.94]
["2022_Bavaria_E09_A, or 1_administrative",2022,"Bavaria","E09","A, or 1","administrative",3158,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.93]
["2022_Bavaria_E09_B, or 2_administrative",2022,"Bavaria","E09","B, or 2","administrative",3456,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.92]
["2022_Bavaria_E09_C, or 3_administrative",2022,"Bavaria","E09","C, or 3","administrative",3798,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.91]
["2022_Bavaria_E09_D, or 4_administrative",2022,"Bavaria","E09","D, or 4","administrative",4267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9]
["2022_Bavaria_E09_A, or 1_technical",2022,"Bavaria","E09","A, or 1","technical",3235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.89]
["2022_Bavaria_E09_B, or 2_technical",2022,"Bavaria","E09","B, or 2","technical",3541,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.88]
["2022_Bavaria_E09_C, or 3_technical",2022,"Bavaria","E09","C, or 3","technical",3891,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.87]
["2022_Bavaria_E09_D, or 4_technical",2022,"Bavaria","E09","D, or 4","technical",4372,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.86]
["2022_Bavaria_E09_A, or 1_foreman",2022,"Bavaria","E09","A, or 1","foreman",3235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.85]
["2022_Bavaria_E09_B, or 2_foreman",2022,"Bavaria","E09","B, or 2","foreman",3541,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.84]
["2022_Bavaria_E09_C, or 3_foreman",2022,"Bavaria","E09","C, or 3","foreman",3891,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.83]
["2022_Bavaria_E09_D, or 4_foreman",2022,"Bavaria","E09","D, or 4","foreman",4372,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.82]
["2022_Bavaria_E10_A, or 1_administrative",2022,"Bavaria","E10","A, or 1","administrative",3540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.81]
["2022_Bavaria_E10_B, or 2_administrative",2022,"Bavaria","E10","B, or 2","administrative",3866,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8]
["2022_Bavaria_E10_C, or 3_administrative",2022,"Bavaria","E10","C, or 3","administrative",4239,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.79]
["2022_Bavaria_E10_D, or 4_administrative",2022,"Bavaria","E10","D, or 4","administrative",4658,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.78]
["2022_Bavaria_E10_A, or 1_technical",2022,"Bavaria","E10","A, or 1","technical",3650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.77]
["2022_Bavaria_E10_B, or 2_technical",2022,"Bavaria","E10","B, or 2","technical",3986,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.76]
["2022_Bavaria_E10_C, or 3_technical",2022,"Bavaria","E10","C, or 3","technical",4371,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.75]
["2022_Bavaria_E10_D, or 4_technical",2022,"Bavaria","E10","D, or 4","technical",4803,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.74]
["2022_Bavaria_E10_A, or 1_foreman",2022,"Bavaria","E10","A, or 1","foreman",3617,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.73]
["2022_Bavaria_E10_B, or 2_foreman",2022,"Bavaria","E10","B, or 2","foreman",3950,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.72]
["2022_Bavaria_E10_C, or 3_foreman",2022,"Bavaria","E10","C, or 3","foreman",4331,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.71]
["2022_Bavaria_E10_D, or 4_foreman",2022,"Bavaria","E10","D, or 4","foreman",4759,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7]
["2022_Bavaria_E11_A, or 1_administrative",2022,"Bavaria","E11","A, or 1","administrative",3945,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.69]
["2022_Bavaria_E11_B, or 2_administrative",2022,"Bavaria","E11","B, or 2","administrative",4299,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.68]
["2022_Bavaria_E11_C, or 3_administrative",2022,"Bavaria","E11","C, or 3","administrative",4603,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.67]
["2022_Bavaria_E11_D, or 4_administrative",2022,"Bavaria","E11","D, or 4","administrative",5058,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.66]
["2022_Bavaria_E11_A, or 1_technical",2022,"Bavaria","E11","A, or 1","technical",4078,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.65]
["2022_Bavaria_E11_B, or 2_technical",2022,"Bavaria","E11","B, or 2","technical",4444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.64]
["2022_Bavaria_E11_C, or 3_technical",2022,"Bavaria","E11","C, or 3","technical",4757,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.63]
["2022_Bavaria_E11_D, or 4_technical",2022,"Bavaria","E11","D, or 4","technical",5228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.62]
["2022_Bavaria_E11_A, or 1_foreman",2022,"Bavaria","E11","A, or 1","foreman",3966,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.61]
["2022_Bavaria_E11_B, or 2_foreman",2022,"Bavaria","E11","B, or 2","foreman",4321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6]
["2022_Bavaria_E11_C, or 3_foreman",2022,"Bavaria","E11","C, or 3","foreman",4626,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.59]
["2022_Bavaria_E11_D, or 4_foreman",2022,"Bavaria","E11","D, or 4","foreman",5084,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.58]
["2022_Bavaria_E12_A, or 1_administrative",2022,"Bavaria","E12","A, or 1","administrative",4256,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.57]
["2022_Bavaria_E12_B, or 2_administrative",2022,"Bavaria","E12","B, or 2","administrative",4638,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.56]
["2022_Bavaria_E12_C, or 3_administrative",2022,"Bavaria","E12","C, or 3","administrative",5020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.55]
["2022_Bavaria_E12_D, or 4_administrative",2022,"Bavaria","E12","D, or 4","administrative",5456,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.54]
["2022_Bavaria_E12_A, or 1_technical",2022,"Bavaria","E12","A, or 1","technical",4405,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.53]
["2022_Bavaria_E12_B, or 2_technical",2022,"Bavaria","E12","B, or 2","technical",4800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.52]
["2022_Bavaria_E12_C, or 3_technical",2022,"Bavaria","E12","C, or 3","technical",5195,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.51]
["2022_Bavaria_E12_D, or 4_technical",2022,"Bavaria","E12","D, or 4","technical",5647,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
["2022_Bavaria_E12_A, or 1_foreman",2022,"Bavaria","E12","A, or 1","foreman",4266,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.49]
["2022_Bavaria_E12_B, or 2_foreman",2022,"Bavaria","E12","B, or 2","foreman",4649,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.48]
["2022_Bavaria_E12_C, or 3_foreman",2022,"Bavaria","E12","C, or 3","foreman",5031,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.47]
[{"$f":"CONCATENATE(B159,\"_\",C159,\"_\",D159,\"_\",E159,\"_\",F159)","v":"2022_Bavaria_E12_D, or 4_foreman"},2022,"Bavaria","E12","D, or 4","foreman",5469,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.46]
["2022_Bavaria_E13_-_administrative",2022,"Bavaria","E13","-","administrative",5858,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.45]
["2022_Bavaria_E13_-_technical",2022,"Bavaria","E13","-","technical",6075,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.44]
["2022_Bavaria_E13_-_foreman",2022,"Bavaria","E13","-","foreman",5858,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.43]
["2022_Bavaria_Azubi_1st year_-",2022,"Bavaria","Azubi","1st year","-",1031,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.42]
["2022_Bavaria_Azubi_2nd year_-",2022,"Bavaria","Azubi","2nd year","-",1095,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.41]
["2022_Bavaria_Azubi_3rd year_-",2022,"Bavaria","Azubi","3rd year","-",1155,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4]
["2022_Bavaria_Azubi_4th year_-",2022,"Bavaria","Azubi","4th year","-",1239,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5499999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5299999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4900000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4700000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3199999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2400000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0499999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0299999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1299999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1200000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0900000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01]

{"sheet":"Hilfsvariablen","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Entgeltschlüssel",{"$f":"CONCATENATE(\"2022\",\"_\",'Selection future payment'!B9,\"_\",'Selection future payment'!B6,\"_\",'Selection future payment'!B8,\"_\",'Selection future payment'!B7)","v":"2022_Bavaria_E01_-_-"}]
["Entgelt",{"$f":"VLOOKUP(B1,Entgelttabelle,7,FALSE)*'Selection future payment'!B10","v":2701}]
["Zukunftsbetraganspruch in Prozent vom Gehalt",0.23,null,"PlusCard","Tarif/alter","Kosten"]
["Zukunftsbetrag",{"$f":"IF(B15=\"\",\"0\",ROUND(B2*B3,2))","v":"0"},null,"Tarif",{"$f":"'Selection future payment'!B23","v":"select"},{"$f":"VLOOKUP(Hilfsvariablen!E4,Datenbasis1!AC2:AD4,2,FALSE)","v":12.67}]
["max. Tage Freistellung",{"$f":"ROUNDDOWN(3/5*'Selection future payment'!B11,0)","v":3},null,"FamilienTarif",{"$f":"'Selection future payment'!B25","v":"comfort"},"-"]
["Wert 1 Tage Freitstellung",{"$f":"ROUND(B4/'Selection future payment'!B11,2)","v":0},null,"Ehepartner",{"$f":"'Selection future payment'!B26","v":"-"},{"$f":"IF('Selection future payment'!B24=\"yes\",VLOOKUP(\"Ehepartner_\"&E6&\"_\"&E$5,PlusCardTariftabelleFamilie,5,FALSE),0)","v":0}]
["Gewählte Tage Freistellung",{"$f":"VLOOKUP('Selection future payment'!B30,Datenbasis1!AU2:AV4,2,FALSE)","v":1},null,"Kind1",{"$f":"'Selection future payment'!B27","v":"-"},{"$f":"IF('Selection future payment'!B24=\"yes\",VLOOKUP(\"Kind_\"&E7&\"_\"&E$5,PlusCardTariftabelleFamilie,5,FALSE),0)","v":0}]
["Betrag Freistellung",{"$f":"IF(B5>0,ROUND((B6*B7),2),0)","v":0},null,"Kind2",{"$f":"'Selection future payment'!B28","v":"-"},{"$f":"IF('Selection future payment'!B24=\"yes\",VLOOKUP(\"Kind_\"&E8&\"_\"&E$5,PlusCardTariftabelleFamilie,5,FALSE),0)","v":0}]
["PassenderTarifvertrag",{"$f":"VLOOKUP('Selection future payment'!$B$3,GesellschaftTarifvertrag,2,FALSE)","v":{"$error":"#N/A"}},null,"Kind3",{"$f":"'Selection future payment'!B29","v":"-"},{"$f":"IF('Selection future payment'!B24=\"yes\",VLOOKUP(\"Kind_\"&E9&\"_\"&E$5,PlusCardTariftabelleFamilie,5,FALSE),0)","v":0}]
["Eintrittsdatum vor 03.01.",{"$f":"'Selection future payment'!B4","v":"yes"},null,"Summe",null,{"$f":"SUM(F4:F9)","v":12.67}]
["Langzeitkonto möglich",{"$f":"IF(OR($B$9=\"no\",$B$10=\"no\",'Selection future payment'!$B$5<>\"tariff-employee\",'Selection future payment'!$B$12=\"fixed-term contract\",'Selection future payment'!$B$14=\"yes\",'Selection future payment'!$B$15=\"retirement period\",'Selection future payment'!$B$15=\"working period\",'Selection future payment'!$B$16=\"yes\"),\"Nein\",\"Ja\")","v":{"$error":"#N/A"}}]
["Freistellung möglich",{"$f":"IF(OR($B$9=\"no\",$B$10=\"no\",'Selection future payment'!$B$5<>\"tariff-employee\",'Selection future payment'!$B$14=\"yes\",'Selection future payment'!$B$15=\"retirement period\",'Selection future payment'!$B$16=\"yes\",B5<1),\"Nein\",\"Ja\")","v":{"$error":"#N/A"}}]
["PlusCard möglich",{"$f":"IF(OR($B$9=\"no\",$B$10=\"no\",'Selection future payment'!$B$5<>\"tariff-employee\",'Selection future payment'!$B$12=\"fixed-term contract\",'Selection future payment'!$B$14=\"yes\",'Selection future payment'!$B$15=\"retirement period\",'Selection future payment'!$B$16=\"yes\"),\"Nein\",\"Ja\")","v":{"$error":"#N/A"}}]
["Auszahlung möglich",{"$f":"IF(OR($B$9=\"no\",$B$10=\"no\",AND('Selection future payment'!$B$5<>\"tariff-employee\",'Selection future payment'!$B$5=\"apprentice\",'Selection future payment'!$B$5=\"dual student\"),'Selection future payment'!$B$14=\"yes\",'Selection future payment'!$B$15=\"retirement period\",'Selection future payment'!$B$16=\"yes\"),\"Nein\",\"Ja\")","v":{"$error":"#N/A"}}]
["Verwendungsmöglichkeiten 2022",{"$f":"IF(ISERROR(_xlfn.TEXTJOIN(\", \",TRUE,IF(B11=\"Ja\",\"Langzeitkonto\",\"\"),IF(B12=\"Ja\",\"Individuelle Freistellungstage\",\"\"),IF(B13=\"Ja\",\"Pluscard\",\"\"))),\"\",_xlfn.TEXTJOIN(\", \",TRUE,IF(B11=\"Ja\",\"Langzeitkonto\",\"\"),IF(B12=\"Ja\",\"Individuelle Freistellungstage\",\"\"),IF(B13=\"Ja\",\"Pluscard\",\"\")))","v":""}]
["Ergebnis Zukunftsbetrag 2022",{"$f":"IF('Selection future payment'!B3=\"\",\"Please select a company and then fill out the form from top to bottom!\",IF(OR(ISERROR(Hilfsvariablen!B2),ISERROR(Hilfsvariablen!B4),ISERROR(Hilfsvariablen!B15)),\"Please check your entries! \nPlease be sure to make your entries in top-to-bottom order.\",CONCATENATE(IF(Hilfsvariablen!B15=\"\",IF(AND(B14=\"Ja\",OR('Selection future payment'!$B$5=\"apprentice\",'Selection future payment'!$B$5=\"dual student\")),\"Based on your entries you can use your tariff-based future payment 2022 for the following options:\n\nPayment according to special regulation in the collective agreement.\",\"Based on your entries you have no entitlement to the tariff-based future payment 2022!\"),CONCATENATE(IF('Selection future payment'!$B$5<>\"non-tariff employee\",CONCATENATE(\"Based on your entries your tariff-based future payment 2022 amounts to\n\",TEXT(Hilfsvariablen!B4,\"0,00\"),\" € (gross).\",\"\n\n\"),\"\"),\"Prerequisite for an entitlement as of 03.01.2022 is that the employement relationship has not been terminated.\")))))","v":"Please select a company and then fill out the form from top to bottom!"}]
["Hilfsergebnis",{"$f":"IF(OR(B16=\"Based on your entries you have no entitlement to the tariff-based future payment 2022!\",B16=\"Please select a company and then fill out the form from top to bottom!\",B16=\"Please check your entries! \nPlease be sure to make your entries in top-to-bottom order.\"),\"Kein Zukunftsbetrag\",IF(NOT(ISERROR(FIND(\"special regulation\",B16,1))),\"Payment according to special regulation in the collective agreement.\",\"\"))","v":"Kein Zukunftsbetrag"}]
[]
["Hinweistext","- To simplify editing, a macro is necessary, click in the dialog <activate macros> or click in the yellow menu bar <activate content>\n\n- The form is to be filled out from top to bottom, because some choices depend on each other\n\n- If you change an entry afterwards, all the following selection options must be checked again for valid values"]
[null,null,"Restbetrag","PlusCard*12","Freistellung"]
["Ergebnis Freistellung & Langzeitkonto",{"$f":"IF(C21<0,\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nPlease make another selection.\",CONCATENATE(\"You choose \",'Selection future payment'!B30,\". \nThe remaining amount in the amount of \",TEXT(C21,\"0,00\"),\" € (gross) will be paid into the compensatory time account with the April 2022 payroll.\"))","v":"You choose 1 day in lieu. \nThe remaining amount in the amount of 0,00 € (gross) will be paid into the compensatory time account with the April 2022 payroll."},{"$f":"B$4-D21-E21","v":0},null,{"$f":"B$8","v":0}]
["Ergebnis Freistellung & PlusCard",{"$f":"IF(C22<0,CONCATENATE(\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of \",TEXT(ROUNDDOWN(C22/12*-1,2),\"0,00\"),\" € monthly will be deducted from your net salary.\"),CONCATENATE(\"You choose \",'Selection future payment'!B30,\". \nIn addition, an amount of \",TEXT(D22,\"0,00\"),\" € will be used for the PlusCard. \nThe remaining amount in the amount of \",TEXT(C22,\"0,00\"),\" € will be paid to you with your payroll.\"))","v":"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of 12,67 € monthly will be deducted from your net salary."},{"$f":"B$4-D22-E22","v":-152.04},{"$f":"F$10*12","v":152.04},{"$f":"B$8","v":0}]
["Ergebnis Langzeitkonto",{"$f":"IF(C23<0,\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nPlease make another selection.\",CONCATENATE(\"Your tariff-based future payment 2022 in the amount of \",TEXT(C23,\"0,00\"),\" € (gross) \nwill be transferred to the compensatory time account with the April 2022 payroll.\"))","v":"Your tariff-based future payment 2022 in the amount of 0,00 € (gross) \nwill be transferred to the compensatory time account with the April 2022 payroll."},0]
["Ergebnis Langzeitkonto & PlusCard",{"$f":"IF(C24<0,CONCATENATE(\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of \",TEXT(ROUNDDOWN(C24/12*-1,2),\"0,00\"),\" € monthly will be deducted from your net salary.\"),CONCATENATE(\"Your tariff-based future payment 2022 will be used in the amount of \",TEXT(D24,\"0,00\"),\" € for the PlusCard. \nThe remaining amount in the amount of \",TEXT(C24,\"0,00\"),\" € will be paid into the compensatory time account with the April 2022 payroll.\"))","v":"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of 12,67 € monthly will be deducted from your net salary."},-152.04,{"$f":"F$10*12","v":152.04}]
["Ergebnis PlusCard",{"$f":"IF(C25<0,CONCATENATE(\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of \",TEXT(ROUNDDOWN(C25/12*-1,2),\"0,00\"),\" € monthly will be deducted from your net salary.\"),CONCATENATE(\"Your tariff-based future payment 2022 will be used in the amount of \",TEXT(D25,\"0,00\"),\" € for the PlusCard.  \nThe remaining amount in the amount of \",TEXT(C25,\"0,00\"),\" € will be paid to you with your payroll.\"))","v":"The intended uses you have selected exceed the amount of your tariff-based future payment.\nThe outstanding remaining amount of 12,67 € monthly will be deducted from your net salary."},-152.04,{"$f":"F$10*12","v":152.04}]
["Ergebnis Freistellung & Auszahlung",{"$f":"IF(C26<0,\"The intended uses you have selected exceed the amount of your tariff-based future payment.\nPlease make another selection.\",CONCATENATE(\"You choose \",'Selection future payment'!B30,\". \nThe remaining amount in the amount of \",TEXT(C26,\"0,00\"),\" € (gross) will be paid to you with your April 2022 payroll.\"))","v":"You choose 1 day in lieu. \nThe remaining amount in the amount of 0,00 € (gross) will be paid to you with your April 2022 payroll."},0,null,0]
["Ergebnis der gewählten Verwendungsmöglichkeit 2022",{"$f":"IF('Selection future payment'!B3=\"\",\"Please select a company and then fill out the form from top to bottom!\",IF(B17=\"Kein Zukunftsbetrag\",\"Based on your entries, you do not have any available usage options for the future amount 2022!\",IF(B17=\"Payment according to special regulation in the collective agreement.\",\"Payment according to special regulation in the collective agreement.\",IF(OR(AND('Selection future payment'!B12=\"permanemt contract\",'Selection future payment'!B22=\"Days in lieu & Payment\"),AND('Selection future payment'!B12=\"fixed-term contract\",'Selection future payment'!B22<>\"Days in lieu & Payment\"),AND('Selection future payment'!B24=\"yes\",'Selection future payment'!B26=\"-\",'Selection future payment'!B27=\"-\"),AND(B5=0,OR('Selection future payment'!B22=\"Days in lieu & Compensatory time account\",'Selection future payment'!B22=\"Days in lieu & PlusCard\"))),\"Please check your entries! \nPlease be sure to make your entries in top-to-bottom order.\",IF('Selection future payment'!B22=\"Days in lieu & Compensatory time account\",Hilfsvariablen!B21,IF('Selection future payment'!B22=\"Days in lieu & PlusCard\",Hilfsvariablen!B22,IF('Selection future payment'!B22=\"Compensatory time account\",Hilfsvariablen!B23,IF('Selection future payment'!B22=\"Compensatory time account & PlusCard\",Hilfsvariablen!B24,IF('Selection future payment'!B22=\"PlusCard\",Hilfsvariablen!B25,IF('Selection future payment'!B22=\"Days in lieu & Payment\",Hilfsvariablen!B26,\"Please select a valid usage option!\"))))))))))","v":"Please select a company and then fill out the form from top to bottom!"}]
[]
[]
["Befristet",{"$f":"IF('Selection future payment'!$B$12=\"fixed-term contract\",\"Ja\",\"Nein\")","v":"Nein"}]
["AlterteilzeitOderOhneEntgeltOderFreigestellt",{"$f":"IF(OR('Selection future payment'!$B$14=\"yes\",'Selection future payment'!$B$15=\"retirement period\",'Selection future payment'!$B$15=\"working period\",'Selection future payment'!$B$16=\"yes\"),\"Ja\",\"Nein\")","v":"Nein"}]
["Freistellung möglich",{"$f":"IF(B5>0,\"Ja\",\"Nein\")","v":"Ja"}]
[]
[]
[]
["PrintMsg","This prints the form directly to the system's default printer without preview. To print with preview/printer selection please use the menu File->Print"]
["PrintTitle","Print on default printer?"]
["ResetMsg","All entries are lost. Do you really want to continue?\n\n(meanwhile Excel may not react for a short time!)"]
["ResetTitle","Reset everything?"]
["StartText","<--- Select a company to start"]
["ResetSuccessMsg","Form fields successfully reset!"]
["ResetSuccessMsgTitle","Reset all entries"]