{"text_format":"1","workbook":"xls","n_sheets":4,"sheets":["Gebühr","Druck","TB1","Werte"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":16,"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","formulas":"cached_only"}

{"sheet":"Gebühr","index":0,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,9,1,11],[21,4,21,5],[30,1,30,7],[1,2,1,5],[3,2,3,5],[19,4,19,5],[20,4,20,5]],"flags":["formulas_cached_only"]}
[null,null,null,null,null,null,null,null,null,null,null,null,"=MAX(O1:P1) N1 >",1.3,1.3,0.8]
[null,null,"Anwaltliche Vertretung",null,null,null,null,null,null,"Eingabe des Gebührensatzes",null,null,"N2 >",1.3,"=N1"]
[]
[null,null,"Außergerichtliche Vertretung",null,null,null,null,null,null,null,null,null,"N4 >",631.8000000000001,"=TB1!B9"]
[null,null,null,null,null,null,null,null,null,null,null,null,"N5 >",0,"=TB1!B20"]
[null,null,"Fall",null,null,null,null,null,null,null,null,null,"N6 >",0,"=Werte!G5*N2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"N7 >",631.8000000000001,"=N4+N5"]
[]
["1 >",2300,1.3,"Geschäftsgebühr",1,"Auftraggeber",null,null,"< 1",1.3,null,null,"N9 >",1,"=C15"]
[null,"",null,null,"Wert:",10000,null,631.8000000000001,null,null,null,null,"N10 >",1.5,"=C16"]
["2 >","3101 Nr.2",0.8,"Verfahrensgebühr",1,"Auftraggeber",null,null,"< 2",0.8,null,null,"N11 >",1.3,"=C17"]
[null,"",null,null,"Wert:",0,null,null,null,null,null,null,"N12 >",1.5,"=MAX(N9:N11)"]
[null,"§ 15 Abs. 3","RVG","nicht mehr als 1,3","aus",0,null,null,null,null,null,null,"N13 >",1.5,"=N12"]
["2 >","1000",1.5,"Einigungsgebühr","Wert:",10000,null,729,"< 2",1.5]
["4 >","1000,1003",1,"Einigungsgebühr","Wert:",0,0,"","< 4",1,null,null,"N15 >",0,"=Werte!I5*J15"]
["5 >","1000",1.5,"Einigungsgebühr","Wert:",0,0,"","< 5",1.5,null,null,"N16 >",0,"=Werte!J5*J16"]
["6 >","1000, 1004",1.3,"Einigungsgebühr","Wert:",0,0,"","< 6",1.3,null,null,"N17 >",0,"=Werte!K5*J17"]
[null,"§ 15 Abs. 3","RVG","nicht mehr als 1,5","aus",0,"",0,null,null,null,null,"N18 >",0,"=Werte!L5*N13"]
[null,7003,1,"x Fahrtkosten PKW",10,"km x 0,30 €",null,3,null,null,null,null,"N19 >",0,"=N15+N16+N17"]
[null,7005,1,"x Tage- u. Abwesenheitsgeld","(nicht mehr als 4 Std.)",null,null,20]
[null,7005,0,"x Tage- u. Abwesenheitsgeld","(mehr als 4 bis 8 Std.)",null,null,0,null,null,null,null,"N21 >",2300]
[null,7005,0,"x Tage- u. Abwesenheitsgeld","(mehr als 8 Std.)",null,null,0,null,null,null,null,"N22 >",1008]
[null,7000,51,"Kopien Dokumentenpauschale",null,null,null,25.15]
[null,7002,null,"Auslagenpauschale",null,null,null,20,null,null,null,null,"N24 >","3101 Nr.2"]
[null,null,null,"Summe netto",null,null,null,1428.9500000000003,null,null,null,null,"N25 >",1008]
[null,7008,null,"Umsatzsteuer",null,0.19,null,271.5]
[null,null,null,"Summe",null,null,null,1700.4500000000003]
[null,null,null,"Gezahlt",null,null,null,100]
[null,null,null,"Gesamt",null,null,null,1600.4500000000003]
[]
[null,"Excel-Tabelle * Urheberrechte Uwe Zoschke"]

{"sheet":"Druck","index":1,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,10,5,11],[6,10,6,11],[7,10,7,11],[8,10,8,11],[1,10,1,11],[2,9,2,11],[3,10,3,11],[4,9,4,11],[1,2,1,5],[3,2,3,5],[38,1,38,7],[19,4,19,5],[20,4,20,5],[21,4,21,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"Anwaltliche Vertretung",null,null,null,null,null,null,"Vorher","(wenn nötig):"]
[null,null,null,null,null,null,null,null,null,"Nicht anfallende Gebühren:"]
[null,null,"Außergerichtliche Vertretung",null,null,null,null,null,null,null,"EUR-Werte (rechts) löschen mit \"Entf\""]
[null,null,null,null,null,null,null,null,null,"Überflüssige Zeilen ausblenden:"]
[null,null,null,null,null,null,null,null,null,"1.","Zeilen-Nummerierung mit"]
[null,null,null,null,null,null,null,null,null,null,"rechter MausTaste \"klick\""]
[null,null,null,null,null,null,null,null,null,"2.","Im AuswahlFenster mit"]
[null,2300,1.3,"Geschäftsgebühr",1,"Auftraggeber",null,null,null,null,"linker MausTaste \"Ausblenden\""]
[null,"",null,null,"Wert:",10000,null,631.8000000000001]
[]
[]
[]
[null,"1000",1.5,"Einigungsgebühr","Wert:",10000,null,729]
[null,"1000,1003",1,"Einigungsgebühr","Wert:",0,0,""]
[null,"1000",1.5,"Einigungsgebühr","Wert:",0,0,""]
[null,"1000, 1004",1.3,"Einigungsgebühr","Wert:",0,0,""]
[null,"§ 15 Abs. 3","RVG","nicht mehr als 1,5","aus",0,"",0]
[null,7003,1,"x Fahrtkosten PKW",10,"km x 0,30 €",null,3]
[null,7005,1,"x Tage- u. Abwesenheitsgeld","(nicht mehr als 4 Std.)",null,null,20]
[null,7005,0,"x Tage- u. Abwesenheitsgeld","(mehr als 4 bis 8 Std.)",null,null,0]
[null,7005,0,"x Tage- u. Abwesenheitsgeld","(mehr als 8 Std.)",null,null,0]
[null,7000,51,"Kopien Dokumentenpauschale",null,null,null,25.15]
[null,7002,null,"Auslagenpauschale",null,null,null,20]
[null,null,null,"Summe netto",null,null,null,1428.9500000000003]
[null,7008,null,"Umsatzsteuer",null,0.19,null,271.5]
[null,null,null,"Summe",null,null,null,1700.4500000000003]
[null,null,null,"Gezahlt",null,null,null,100]
[null,null,null,"Gesamt",null,null,null,1600.4500000000003,null,"Kopieren:",null,"in geöffnete (!) WordDatei"]
[null,null,null,null,null,null,null,null,null,"Markieren"]
[null,null,null,null,null,null,null,null,null,"1.","B9","mit linker MausTaste \"klick\""]
[null,null,null,null,null,null,null,null,null,"2.",null,"GrossbuchstabenTaste halten"]
[null,null,null,null,null,null,null,null,null,"3.","H29","mit linker MausTaste \"klick\""]
[null,null,null,null,null,null,null,null,null,"Kopieren"]
[null,null,null,null,null,null,null,null,null,"4.","mit","Ctrl + c kopieren"]
[null,null,null,null,null,null,null,null,null,"Einfügen"]
[null,null,null,null,null,null,null,null,null,"5.",null,"zu offener WordDatei wechseln"]
[null,null,null,null,null,null,null,null,null,"6.","mit","Ctrl + v einfügen"]
[null,"Excel-Tabelle * Urheberrechte Uwe Zoschke"]

{"sheet":"TB1","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,null,null,null,null,"Mandanten","erhöhter Satz","Filter","Wert erhöhter Satz","Filter"]
["B2 >",10000,"< Streitwert","=Gebühr!F10",null,"Wert","Erhöhung",1,1.3,1.3,631.8000000000001,631.8000000000001]
["B3 >",486,"< 1/1 Gebühr","=Werte!E5","F3 >",145.79999999999998,0.3,2,1.6,"",777.6,""]
["B4 >",1.3,"< Gebührensatz","=Gebühr!J9","F4 >",291.59999999999997,0.6,3,1.9,"",923.4000000000001,""]
["B5 >",631.8000000000001,"< SatzGebühr","=B3*B4","F5 >",437.40000000000003,0.9,4,2.2,"",1069.2,""]
["B6 >",1,"< Mandanten","=Gebühr!E9","F6 >",583.1999999999999,1.2,5,2.5,"",1215,""]
[null,null,null,null,"F7 >",729,1.5,6,2.8,"",1360.8000000000002,""]
["< ---     B8 >",1.3,"< erhöhter Satz","=J10","F8 >",874.8000000000001,1.8,7,3.1,"",1506.6000000000001,""]
["< ---     B9 >",631.8000000000001,"< Wert   \"     \"","=L10","F9 >",972,2,8,3.3,"",1603.8000000000002,""]
[null,null,null,null,"F10 >",972,2,"< Grenzwert",null,1.3,null,631.8000000000001]
[]
[null,null,null,null,null,null,null,"Mandanten","erhöhter Satz","Filter","Wert erhöhter Satz","Filter"]
["B13 >",0,"< Streitwert","=Gebühr!F12",null,"Wert","Erhöhung",1,0.8,0.8,0,0]
["B14 >",0,"< 1/1 Gebühr","=Werte!F5","F14 >",0,0.3,2,1.1,"",0,""]
["B15 >",0.8,"< Gebührensatz","=Gebühr!J11","F15 >",0,0.6,3,1.4,"",0,""]
["B16 >",0,"< SatzGebühr","=B14*B15","F16 >",0,0.9,4,1.7000000000000002,"",0,""]
["B17 >",1,"< Mandanten","=Gebühr!E11","F17 >",0,1.2,5,2,"",0,""]
[null,null,null,null,"F18 >",0,1.5,6,2.3,"",0,""]
["<     B19 >",0.8,"< erhöhter Satz","=J21","F19 >",0,1.8,7,2.6,"",0,""]
["<     B20 >",0,"< Wert   \"     \"","=L21","F20 >",0,2,8,2.8,"",0,""]
[null,null,null,null,"F21 >",0,2,"< Grenzwert",null,0.8,null,0]

{"sheet":"Werte","index":3,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,null,null,10000,0,0,10000,0,0,0,0]
[null,null,null,null,"=Gebühr!F10","=Gebühr!F12","=Gebühr!F13","=Gebühr!F14","=Gebühr!F15","=Gebühr!F16","=Gebühr!F17","=Gebühr!F18"]
[null,null,null,null,"VerfG1","VerfG2","Summe_VG","TermG","EinigG1","EinigG2","EinigG3","SummeEG"]
["Wert bis",null,null,"Summen >",486,0,0,486,0,0,0,0]
[0.01,"1/1",null,null,"Werte!E5","Werte!F5","Werte!G5","Werte!H5","Werte!I5","Werte!J5","Werte!K5","Werte!L5"]
[300,25,"Differenz","Differenz","","","","","","","",""]
[600,45,300,20,"","","","","","","",""]
[900,65,300,20,"","","","","","","",""]
[1200,85,300,20,"","","","","","","",""]
[1500,105,300,20,"","","","","","","",""]
[2000,133,500,28,"","","","","","","",""]
[2500,161,500,28,"","","","","","","",""]
[3000,189,500,28,"","","","","","","",""]
[3500,217,500,28,"","","","","","","",""]
[4000,245,500,28,"","","","","","","",""]
[4500,273,500,28,"","","","","","","",""]
[5000,301,500,28,"","","","","","","",""]
[6000,338,1000,37,"","","","","","","",""]
[7000,375,1000,37,"","","","","","","",""]
[8000,412,1000,37,"","","","","","","",""]
[9000,449,1000,37,"","","","","","","",""]
[10000,486,1000,37,486,"","",486,"","","",""]
[13000,526,3000,40,"","","","","","","",""]
[16000,566,3000,40,"","","","","","","",""]
[19000,606,3000,40,"","","","","","","",""]
[22000,646,3000,40,"","","","","","","",""]
[25000,686,3000,40,"","","","","","","",""]
[30000,758,5000,72,"","","","","","","",""]
[35000,830,5000,72,"","","","","","","",""]
[40000,902,5000,72,"","","","","","","",""]
[45000,974,5000,72,"","","","","","","",""]
[50000,1046,5000,72,"","","","","","","",""]
[65000,1123,15000,77,"","","","","","","",""]
[80000,1200,15000,77,"","","","","","","",""]
[95000,1277,15000,77,"","","","","","","",""]
[110000,1354,15000,77,"","","","","","","",""]
[125000,1431,15000,77,"","","","","","","",""]
[140000,1508,15000,77,"","","","","","","",""]
[155000,1585,15000,77,"","","","","","","",""]
[170000,1662,15000,77,"","","","","","","",""]
[185000,1739,15000,77,"","","","","","","",""]
[200000,1816,15000,77,"","","","","","","",""]
[230000,1934,30000,118,"","","","","","","",""]
[260000,2052,30000,118,"","","","","","","",""]
[290000,2170,30000,118,"","","","","","","",""]
[320000,2288,30000,118,"","","","","","","",""]
[350000,2406,30000,118,"","","","","","","",""]
[380000,2524,30000,118,"","","","","","","",""]
[410000,2642,30000,118,"","","","","","","",""]
[440000,2760,30000,118,"","","","","","","",""]
[470000,2878,30000,118,"","","","","","","",""]
[500000,2996,30000,118,"","","","","","","",""]
[550000,3146,50000,150,"","","","","","","",""]
[600000,3296,50000,150,"","","","","","","",""]
[650000,3446,50000,150,"","","","","","","",""]
[700000,3596,50000,150,"","","","","","","",""]
[750000,3746,50000,150,"","","","","","","",""]
[800000,3896,50000,150,"","","","","","","",""]
[850000,4046,50000,150,"","","","","","","",""]
[900000,4196,50000,150,"","","","","","","",""]
[950000,4346,50000,150,"","","","","","","",""]
[1000000,4496,50000,150,"","","","","","","",""]
[1050000,4646,50000,150,"","","","","","","",""]
[1100000,4796,50000,150,"","","","","","","",""]
[1150000,4946,50000,150,"","","","","","","",""]
[1200000,5096,50000,150,"","","","","","","",""]
[1250000,5246,50000,150,"","","","","","","",""]
[1300000,5396,50000,150,"","","","","","","",""]
[1350000,5546,50000,150,"","","","","","","",""]
[1400000,5696,50000,150,"","","","","","","",""]