{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Auswahl_ALG","Honorar","Honorarhilfe","HOAI","Pauschalhonorar","Rechner"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":209,"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":"Auswahl_ALG","index":0,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":false,"merged":[[29,0,29,5],[3,7,3,9],[15,0,15,6],[22,1,22,5],[23,1,23,5],[24,1,24,5],[26,0,26,6],[27,0,27,6],[28,0,28,6],[25,1,25,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[11,0,11,5],[14,0,14,6],[12,0,12,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[10,0,10,5],[13,0,13,6],[2,0,2,6],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6]]}
["Formular zur Erstellung eines TGA-Planervertrages"]
[]
["1. Geben Sie an, für welche Anlagengruppen Leistungen beauftragt werden sollen."]
["Klicken Sie dazu in ein gelbes Feld oder benutzen Sie die Vorauswahl-Schalter.",null,null,null,null,null,null,"Vorauswahl-Schalter"]
[]
["Anlagengruppe 1: Abwasser-, Wasser- und Gasanlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 2: Wärmeversorgungsanlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 3: Lufttechnische Anlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 4: Starkstromanlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 5: Fernmelde- und informationstechnische Anlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 6: Förderanlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 7: nutzungsspezifische Anlagen und verfahrenstechnische Anlagen",null,null,null,null,null,"nein"]
["Anlagengruppe 8: Gebäudeautomation und Automation von Ingenieurbauwerken",null,null,null,null,null,"nein"]
[]
["2. Wählen Sie aus, welche Leistungsphasen beauftragt werden sollen."]
["Klicken Sie dazu in ein gelbes Feld oder benutzen Sie die Vorauswahl-Schalter."]
[]
["LP 1","Grundlagenermittlung",null,null,null,null,"ja"]
["LP 2","Vorplanung",null,null,null,null,"ja"]
["LP 3","Entwurfsplanung",null,null,null,null,"ja"]
["LP 4","Genehmigungsplanung",null,null,null,null,"ja"]
["LP 5","Ausführungsplanung",null,null,null,null,"ja"]
["LP 6","Vorbereitung der Vergabe",null,null,null,null,"ja"]
["LP 7","Mitwirkung bei der Vergabe",null,null,null,null,"ja"]
["LP 8","Objektüberwachung - Bauüberwachung",null,null,null,null,"ja"]
["LP 9","Objektbetreuung",null,null,null,null,"ja"]
[]
["2. Geben Sie an, ob ein Umbauzuschlag gewährt werden soll."]
[]
["Umbauzuschlag",null,null,null,null,null,"nein"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ja"]

{"sheet":"Honorar","index":1,"n_rows":124,"n_cols":28,"rows_kept":124,"cut":false,"hidden":true,"merged":[[8,24,8,26],[8,9,8,11],[18,12,18,14],[22,24,22,26],[11,24,11,26],[21,27,21,29],[21,24,21,26],[20,24,20,26],[20,27,20,29],[22,21,22,23],[19,12,19,14],[20,15,20,17],[19,21,19,23],[21,21,21,23],[20,21,20,23],[22,27,22,29],[19,24,19,26],[19,27,19,29],[19,9,19,11],[18,21,18,23],[12,21,12,23],[9,21,9,23],[17,21,17,23],[18,27,18,29],[24,18,24,20],[90,0,90,2],[8,0,8,5],[9,0,9,5],[8,6,8,8],[9,6,9,8],[8,12,8,14],[8,15,8,17],[21,18,21,20],[19,18,19,20],[20,18,20,20],[19,15,19,17],[21,15,21,17],[23,18,23,20],[25,15,25,17],[22,15,22,17],[26,15,26,17],[22,18,22,20],[25,18,25,20],[29,18,29,20],[23,15,23,17],[24,15,24,17],[58,15,58,17],[67,15,67,17],[24,21,24,23],[27,27,27,29],[27,21,27,23],[27,24,27,26],[23,24,23,26],[25,24,25,26],[29,24,29,26],[29,27,29,29],[26,24,26,26],[26,27,26,29],[24,27,24,29],[28,24,28,26],[25,21,25,23],[23,21,23,23],[25,27,25,29],[23,27,23,29],[24,24,24,26],[28,27,28,29],[26,18,26,20],[27,18,27,20],[28,12,28,14],[64,21,64,23],[59,24,59,26],[30,21,30,23],[31,15,31,17],[63,18,63,20],[29,21,29,23],[28,15,28,17],[28,21,28,23],[26,21,26,23],[28,18,28,20],[27,15,27,17],[55,18,55,20],[33,21,33,23],[52,18,52,20],[36,12,36,14],[36,15,36,17],[55,12,55,14],[30,18,30,20],[32,21,32,23],[30,12,30,14],[60,27,60,29],[54,15,54,17],[66,15,66,17],[74,15,74,17],[74,18,74,20],[57,15,57,17],[57,18,57,20],[70,18,70,20],[70,24,70,26],[65,21,65,23],[65,18,65,20],[67,21,67,23],[72,18,72,20],[72,24,72,26],[72,21,72,23],[70,21,70,23],[69,18,69,20],[68,21,68,23],[66,24,66,26],[67,18,67,20],[69,21,69,23],[55,27,55,29],[68,15,68,17],[61,15,61,17],[76,27,76,29],[76,24,76,26],[72,27,72,29],[65,27,65,29],[70,27,70,29],[68,27,68,29],[66,27,66,29],[75,27,75,29],[63,27,63,29],[71,27,71,29],[64,24,64,26],[71,24,71,26],[68,24,68,26],[69,24,69,26],[69,27,69,29],[74,24,74,26],[73,27,73,29],[74,27,74,29],[75,21,75,23],[63,21,63,23],[34,21,34,23],[32,24,32,26],[57,24,57,26],[58,24,58,26],[63,24,63,26],[61,24,61,26],[62,24,62,26],[60,21,60,23],[60,24,60,26],[62,21,62,23],[61,21,61,23],[53,21,53,23],[52,21,52,23],[56,21,56,23],[74,21,74,23],[73,24,73,26],[67,24,67,26],[66,21,66,23],[65,24,65,26],[38,0,38,29],[32,6,32,8],[32,9,32,11],[58,27,58,29],[67,27,67,29],[57,27,57,29],[61,18,61,20],[60,18,60,20],[53,18,53,20],[54,21,54,23],[61,27,61,29],[53,27,53,29],[53,24,53,26],[54,27,54,29],[59,18,59,20],[54,18,54,20],[58,18,58,20],[56,18,56,20],[64,27,64,29],[62,27,62,29],[58,21,58,23],[64,18,64,20],[66,18,66,20],[59,27,59,29],[54,24,54,26],[56,24,56,26],[57,21,57,23],[33,27,33,29],[56,27,56,29],[31,21,31,23],[31,18,31,20],[37,18,37,20],[36,18,36,20],[33,18,33,20],[30,27,30,29],[30,24,30,26],[32,18,32,20],[31,27,31,29],[31,24,31,26],[35,24,35,26],[33,24,33,26],[35,18,35,20],[34,24,34,26],[73,12,73,14],[78,12,78,14],[78,15,78,17],[78,18,78,20],[78,21,78,23],[77,6,77,8],[77,9,77,11],[76,6,76,8],[75,6,75,8],[75,9,75,11],[73,6,73,8],[76,9,76,11],[74,6,74,8],[74,9,74,11],[73,9,73,11],[73,18,73,20],[73,21,73,23],[73,15,73,17],[76,21,76,23],[76,15,76,17],[76,18,76,20],[76,12,76,14],[74,12,74,14],[75,12,75,14],[72,9,72,11],[71,9,71,11],[69,6,69,8],[68,6,68,8],[71,6,71,8],[70,6,70,8],[72,6,72,8],[71,18,71,20],[71,21,71,23],[70,15,70,17],[69,15,69,17],[69,9,69,11],[68,9,68,11],[70,9,70,11],[70,12,70,14],[71,15,71,17],[68,12,68,14],[69,12,69,14],[71,12,71,14],[72,15,72,17],[72,12,72,14],[68,18,68,20],[67,6,67,8],[67,9,67,11],[64,12,64,14],[66,9,66,11],[66,12,66,14],[64,6,64,8],[60,6,60,8],[57,6,57,8],[61,6,61,8],[59,6,59,8],[63,6,63,8],[66,6,66,8],[65,6,65,8],[62,6,62,8],[61,9,61,11],[63,12,63,14],[58,6,58,8],[63,9,63,11],[67,12,67,14],[58,9,58,11],[65,15,65,17],[65,12,65,14],[62,15,62,17],[64,15,64,17],[63,15,63,17],[56,15,56,17],[59,15,59,17],[60,15,60,17],[54,0,54,5],[55,6,55,8],[56,6,56,8],[54,12,54,14],[55,15,55,17],[65,9,65,11],[64,9,64,11],[57,12,57,14],[56,9,56,11],[62,12,62,14],[57,9,57,11],[62,9,62,11],[60,9,60,11],[61,12,61,14],[53,9,53,11],[55,24,55,26],[52,9,52,11],[59,9,59,11],[56,12,56,14],[60,12,60,14],[58,12,58,14],[59,12,59,14],[62,18,62,20],[53,12,53,14],[55,21,55,23],[59,21,59,23],[37,0,37,5],[51,9,51,11],[52,27,52,29],[51,6,51,8],[51,0,51,5],[51,21,51,23],[51,24,51,26],[37,21,37,23],[39,6,39,29],[40,6,40,29],[46,5,46,29],[47,5,47,29],[48,5,48,29],[52,12,52,14],[51,15,51,17],[51,18,51,20],[50,0,50,29],[36,9,36,11],[34,27,34,29],[35,15,35,17],[34,15,34,17],[35,21,35,23],[35,27,35,29],[34,18,34,20],[36,27,36,29],[36,21,36,23],[36,24,36,26],[35,12,35,14],[34,0,34,4],[32,27,32,29],[35,0,35,4],[34,6,34,8],[49,0,49,29],[20,0,20,4],[29,12,29,14],[29,15,29,17],[34,5,35,5],[34,9,34,11],[34,12,34,14],[35,9,35,11],[37,12,37,14],[37,9,37,11],[33,12,33,14],[32,5,33,5],[32,12,32,14],[32,15,32,17],[33,15,33,17],[31,12,31,14],[30,5,31,5],[35,6,35,8],[36,6,36,8],[30,15,30,17],[36,0,36,4],[37,6,37,8],[37,15,37,17],[27,6,27,8],[18,0,18,4],[21,6,21,8],[20,6,20,8],[29,6,29,8],[29,9,29,11],[33,0,33,4],[33,6,33,8],[33,9,33,11],[32,0,32,4],[31,0,31,4],[31,6,31,8],[31,9,31,11],[30,0,30,4],[30,6,30,8],[30,9,30,11],[20,9,20,11],[19,0,19,4],[18,5,19,5],[28,5,29,5],[28,0,28,4],[28,6,28,8],[28,9,28,11],[29,0,29,4],[18,9,18,11],[6,0,6,5],[6,6,6,8],[6,12,6,14],[11,15,11,17],[23,0,23,4],[23,6,23,8],[23,9,23,11],[22,5,23,5],[20,12,20,14],[22,12,22,14],[7,15,7,17],[12,0,12,5],[7,6,7,8],[11,9,11,11],[10,9,10,11],[12,6,12,8],[11,0,11,5],[11,6,11,8],[7,0,7,5],[7,9,7,11],[10,0,10,5],[17,0,17,5],[19,6,19,8],[18,6,18,8],[6,9,6,11],[11,18,11,20],[7,18,7,20],[11,12,11,14],[7,12,7,14],[17,6,17,8],[12,9,12,11],[17,9,17,11],[9,9,9,11],[9,12,9,14],[9,15,9,17],[9,18,9,20],[6,15,6,17],[10,15,10,17],[12,18,12,20],[17,18,17,20],[10,12,10,14],[8,18,8,20],[12,15,12,17],[7,21,7,23],[12,12,12,14],[17,12,17,14],[10,21,10,23],[11,21,11,23],[8,21,8,23],[80,0,80,5],[6,27,6,29],[6,24,6,26],[10,27,10,29],[10,24,10,26],[7,27,7,29],[7,24,7,26],[6,21,6,23],[6,18,6,20],[8,27,8,29],[9,24,9,26],[9,27,9,29],[12,27,12,29],[12,24,12,26],[18,24,18,26],[10,6,10,8],[10,18,10,20],[18,18,18,20],[11,27,11,29],[17,24,17,26],[18,15,18,17],[17,27,17,29],[17,15,17,17],[25,6,25,8],[24,0,24,4],[73,0,73,5],[74,0,74,5],[37,27,37,29],[37,24,37,26],[21,0,21,4],[21,9,21,11],[24,9,24,11],[20,5,21,5],[23,12,23,14],[24,12,24,14],[25,12,25,14],[26,9,26,11],[26,12,26,14],[26,5,27,5],[26,0,26,4],[26,6,26,8],[27,0,27,4],[75,0,75,5],[76,0,76,5],[77,0,77,5],[78,0,78,5],[79,0,79,5],[39,0,39,5],[40,0,40,5],[41,0,41,29],[43,5,43,29],[45,5,45,29],[44,5,44,29],[51,27,51,29],[42,0,42,29],[53,15,53,17],[54,9,54,11],[52,15,52,17],[51,12,51,14],[52,6,52,8],[52,0,52,5],[53,0,53,5],[55,9,55,11],[52,24,52,26],[53,6,53,8],[54,6,54,8],[27,9,27,11],[27,12,27,14],[21,12,21,14],[24,5,25,5],[24,6,24,8],[25,0,25,4],[22,0,22,4],[22,6,22,8],[22,9,22,11],[25,9,25,11],[120,0,120,2],[94,24,94,26],[94,27,94,29],[93,0,93,5],[94,0,94,5],[94,6,94,8],[94,9,94,11],[94,12,94,14],[94,15,94,17],[94,18,94,20],[94,21,94,23],[93,6,93,8],[93,9,93,11],[93,12,93,14],[93,15,93,17],[93,18,93,20],[93,21,93,23],[93,24,93,26],[93,27,93,29],[109,24,109,26],[109,27,109,29],[105,0,105,2],[108,0,108,5],[109,0,109,5],[108,6,108,8],[108,9,108,11],[108,12,108,14],[108,15,108,17],[108,18,108,20],[108,21,108,23],[55,0,55,5],[56,0,56,5],[57,0,57,5],[58,0,58,5],[59,0,59,5],[60,0,60,5],[61,0,61,5],[62,0,62,5],[63,0,63,5],[64,0,64,5],[65,0,65,5],[66,0,66,5],[67,0,67,5],[68,0,68,5],[69,0,69,5],[70,0,70,5],[71,0,71,5],[72,0,72,5],[80,6,82,29],[82,0,82,5],[75,24,75,26],[75,15,75,17],[75,18,75,20],[79,6,79,8],[79,9,79,11],[79,12,79,14],[79,27,79,29],[79,18,79,20],[77,27,77,29],[79,15,79,17],[79,21,79,23],[79,24,79,26],[78,24,78,26],[78,27,78,29],[81,0,81,5],[77,15,77,17],[77,18,77,20],[77,21,77,23],[77,24,77,26],[78,6,78,8],[78,9,78,11],[77,12,77,14],[95,0,95,5],[96,2,96,5],[95,6,97,29],[110,0,110,5],[111,2,111,5],[110,6,112,29],[118,0,118,5],[121,0,121,5],[122,3,122,5],[120,3,120,5],[119,4,119,5],[117,6,123,10],[123,0,123,5],[97,0,97,5],[112,0,112,5],[117,0,117,5],[108,24,108,26],[108,27,108,29],[109,6,109,8],[109,9,109,11],[109,12,109,14],[109,15,109,17],[109,18,109,20],[109,21,109,23]]}
[]
[]
[]
[]
["1. Legen Sie die anrechenbaren Kosten, die Honorarzone und den Honorarsatz fest."]
[]
["Anlagengruppe",null,null,null,null,null,"ALG 1",null,null,"ALG 2",null,null,"ALG 3",null,null,"ALG 4",null,null,"ALG 5",null,null,"ALG 6",null,null,"ALG 7",null,null,"ALG 8"]
["anrechenbare Kosten"]
["mitzuverarbeitende Bausubstanz"]
["anrechenbare Kosten gesamt",null,null,null,null,null,{"$f":"SUBTOTAL(109,G8,G9)","v":0},null,null,{"$f":"SUBTOTAL(109,J8,J9)","v":0},null,null,{"$f":"SUBTOTAL(109,M8,M9)","v":0},null,null,{"$f":"SUBTOTAL(109,P8,P9)","v":0},null,null,{"$f":"SUBTOTAL(109,S8,S9)","v":0},null,null,{"$f":"SUBTOTAL(109,V8,V9)","v":0},null,null,{"$f":"SUBTOTAL(109,Y8,Y9)","v":0},null,null,{"$f":"SUBTOTAL(109,AB8,AB9)","v":0}]
["Honorarzone",null,null,null,null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl"]
["Honorarsatz",null,null,null,null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl",null,null,"Auswahl"]
["Honorar",null,null,null,null,null,{"$f":"IF(G8=0,0,IF(G12=\"Mindestsatz\",Rechner!D33,IF(G12=\"Viertelsatz\",Rechner!D34,IF(G12=\"Mittelsatz\",Rechner!D35,IF(G12=\"Dreiviertelsatz\",Rechner!D36,IF(G12=\"Höchstsatz\",Rechner!D37,\"\"))))))","v":0},null,null,{"$f":"IF(J8=0,0,IF(J12=\"Mindestsatz\",Rechner!D47,IF(J12=\"Viertelsatz\",Rechner!D48,IF(J12=\"Mittelsatz\",Rechner!D49,IF(J12=\"Dreiviertelsatz\",Rechner!D50,IF(J12=\"Höchstsatz\",Rechner!D51,\"\"))))))","v":0},null,null,{"$f":"IF(M8=0,0,IF(M12=\"Mindestsatz\",Rechner!D61,IF(M12=\"Viertelsatz\",Rechner!D62,IF(M12=\"Mittelsatz\",Rechner!D63,IF(M12=\"Dreiviertelsatz\",Rechner!D64,IF(M12=\"Höchstsatz\",Rechner!D65,\"\"))))))","v":0},null,null,{"$f":"IF(P8=0,0,IF(P12=\"Mindestsatz\",Rechner!D75,IF(P12=\"Viertelsatz\",Rechner!D76,IF(P12=\"Mittelsatz\",Rechner!D77,IF(P12=\"Dreiviertelsatz\",Rechner!D78,IF(P12=\"Höchstsatz\",Rechner!D79,\"\"))))))","v":0},null,null,{"$f":"IF(S8=0,0,IF(S12=\"Mindestsatz\",Rechner!D89,IF(S12=\"Viertelsatz\",Rechner!D90,IF(S12=\"Mittelsatz\",Rechner!D91,IF(S12=\"Dreiviertelsatz\",Rechner!D92,IF(S12=\"Höchstsatz\",Rechner!D93,\"\"))))))","v":0},null,null,{"$f":"IF(V8=0,0,IF(V12=\"Mindestsatz\",Rechner!D103,IF(V12=\"Viertelsatz\",Rechner!D104,IF(V12=\"Mittelsatz\",Rechner!D105,IF(V12=\"Dreiviertelsatz\",Rechner!D106,IF(V12=\"Höchstsatz\",Rechner!D107,\"\"))))))","v":0},null,null,{"$f":"IF(Y8=0,0,IF(Y12=\"Mindestsatz\",Rechner!D117,IF(Y12=\"Viertelsatz\",Rechner!D118,IF(Y12=\"Mittelsatz\",Rechner!D119,IF(Y12=\"Dreiviertelsatz\",Rechner!D120,IF(Y12=\"Höchstsatz\",Rechner!D121,\"\"))))))","v":0},null,null,{"$f":"IF(AB8=0,0,IF(AB12=\"Mindestsatz\",Rechner!D131,IF(AB12=\"Viertelsatz\",Rechner!D132,IF(AB12=\"Mittelsatz\",Rechner!D133,IF(AB12=\"Dreiviertelsatz\",Rechner!D134,IF(AB12=\"Höchstsatz\",Rechner!D135,\"\"))))))","v":0}]
[]
["2. Grundleistungen und Umbauzuschlag"]
["a) Grundleistungen"]
[]
["Anlagengruppe",null,null,null,null,null,"ALG 1",null,null,"ALG 2",null,null,"ALG 3",null,null,"ALG 4",null,null,"ALG 5",null,null,"ALG 6",null,null,"ALG 7",null,null,"ALG 8"]
["LP 1: Grundlagenermittlung",null,null,null,null,0.02]
["LP1: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G19,2)","v":0},null,null,{"$f":"ROUND($J$13*J19,2)","v":0},null,null,{"$f":"ROUND($M$13*M19,2)","v":0},null,null,{"$f":"ROUND($P$13*P19,2)","v":0},null,null,{"$f":"ROUND($S$13*S19,2)","v":0},null,null,{"$f":"ROUND($V$13*V19,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y19,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB19,2)","v":0}]
["LP 2: Vorplanung",null,null,null,null,0.09]
["LP 2: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G21,2)","v":0},null,null,{"$f":"ROUND($J$13*J21,2)","v":0},null,null,{"$f":"ROUND($M$13*M21,2)","v":0},null,null,{"$f":"ROUND($P$13*P21,2)","v":0},null,null,{"$f":"ROUND($S$13*S21,2)","v":0},null,null,{"$f":"ROUND($V$13*V21,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y21,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB21,2)","v":0}]
["LP 3: Entwurfsplanung",null,null,null,null,0.17]
["LP 3: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G23,2)","v":0},null,null,{"$f":"ROUND($J$13*J23,2)","v":0},null,null,{"$f":"ROUND($M$13*M23,2)","v":0},null,null,{"$f":"ROUND($P$13*P23,2)","v":0},null,null,{"$f":"ROUND($S$13*S23,2)","v":0},null,null,{"$f":"ROUND($V$13*V23,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y23,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB23,2)","v":0}]
["LP 4: Genehmigungsplanung",null,null,null,null,0.02]
["LP 4: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G25,2)","v":0},null,null,{"$f":"ROUND($J$13*J25,2)","v":0},null,null,{"$f":"ROUND($M$13*M25,2)","v":0},null,null,{"$f":"ROUND($P$13*P25,2)","v":0},null,null,{"$f":"ROUND($S$13*S25,2)","v":0},null,null,{"$f":"ROUND($V$13*V25,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y25,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB25,2)","v":0}]
["LP 5: Ausführungsplanung",null,null,null,null,0.22]
["LP 5: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G27,2)","v":0},null,null,{"$f":"ROUND($J$13*J27,2)","v":0},null,null,{"$f":"ROUND($M$13*M27,2)","v":0},null,null,{"$f":"ROUND($P$13*P27,2)","v":0},null,null,{"$f":"ROUND($S$13*S27,2)","v":0},null,null,{"$f":"ROUND($V$13*V27,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y27,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB27,2)","v":0}]
["LP 6: Vorbereitung Vergabe",null,null,null,null,7.0000000000000007E-2]
["LP 6: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G29,2)","v":0},null,null,{"$f":"ROUND($J$13*J29,2)","v":0},null,null,{"$f":"ROUND($M$13*M29,2)","v":0},null,null,{"$f":"ROUND($P$13*P29,2)","v":0},null,null,{"$f":"ROUND($S$13*S29,2)","v":0},null,null,{"$f":"ROUND($V$13*V29,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y29,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB29,2)","v":0}]
["LP 7: Mitwirkung Vergabe",null,null,null,null,0.05]
["LP 7: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G31,2)","v":0},null,null,{"$f":"ROUND($J$13*J31,2)","v":0},null,null,{"$f":"ROUND($M$13*M31,2)","v":0},null,null,{"$f":"ROUND($P$13*P31,2)","v":0},null,null,{"$f":"ROUND($S$13*S31,2)","v":0},null,null,{"$f":"ROUND($V$13*V31,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y31,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB31,2)","v":0}]
["LP 8: Objektüberwachung",null,null,null,null,0.35]
["LP 8: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G33,2)","v":0},null,null,{"$f":"ROUND($J$13*J33,2)","v":0},null,null,{"$f":"ROUND($M$13*M33,2)","v":0},null,null,{"$f":"ROUND($P$13*P33,2)","v":0},null,null,{"$f":"ROUND($S$13*S33,2)","v":0},null,null,{"$f":"ROUND($V$13*V33,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y33,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB33,2)","v":0}]
["LP 9: Dokumentation",null,null,null,null,0.01]
["LP 9: Teilhonorar",null,null,null,null,null,{"$f":"ROUND($G$13*G35,2)","v":0},null,null,{"$f":"ROUND($J$13*J35,2)","v":0},null,null,{"$f":"ROUND($M$13*M35,2)","v":0},null,null,{"$f":"ROUND($P$13*P35,2)","v":0},null,null,{"$f":"ROUND($S$13*S35,2)","v":0},null,null,{"$f":"ROUND($V$13*V35,2)","v":0},null,null,{"$f":"ROUND($Y$13*Y35,2)","v":0},null,null,{"$f":"ROUND($AB$13*AB35,2)","v":0}]
["Summe %",null,null,null,null,{"$f":"SUBTOTAL(109,F19:F36)","v":1},{"$f":"SUBTOTAL(109,G19,G21,G23,G25,G27,G29,G31,G33,G35)","v":0},null,null,{"$f":"SUBTOTAL(109,J19,J21,J23,J25,J27,J29,J31,J33,J35)","v":0},null,null,{"$f":"SUBTOTAL(109,M19,M21,M23,M25,M27,M29,M31,M33,M35)","v":0},null,null,{"$f":"SUBTOTAL(109,P19,P21,P23,P25,P27,P29,P31,P33,P35)","v":0},null,null,{"$f":"SUBTOTAL(109,S19,S21,S23,S25,S27,S29,S31,S33,S35)","v":0},null,null,{"$f":"SUBTOTAL(109,V19,V21,V23,V25,V27,V29,V31,V33,V35)","v":0},null,null,{"$f":"SUBTOTAL(109,Y19,Y21,Y23,Y25,Y27,Y29,Y31,Y33,Y35)","v":0},null,null,{"$f":"SUBTOTAL(109,AB19,AB21,AB23,AB25,AB27,AB29,AB31,AB33,AB35)","v":0}]
["Summe €",null,null,null,null,null,{"$f":"SUBTOTAL(109,G20,G22,G24,G26,G28,G30,G32,G34,G36)","v":0},null,null,{"$f":"SUBTOTAL(109,J20,J22,J24,J26,J28,J30,J32,J34,J36)","v":0},null,null,{"$f":"SUBTOTAL(109,M20,M22,M24,M26,M28,M30,M32,M34,M36)","v":0},null,null,{"$f":"SUBTOTAL(109,P20,P22,P24,P26,P28,P30,P32,P34,P36)","v":0},null,null,{"$f":"SUBTOTAL(109,S20,S22,S24,S26,S28,S30,S32,S34,S36)","v":0},null,null,{"$f":"SUBTOTAL(109,V20,V22,V24,V26,V28,V30,V32,V34,V36)","v":0},null,null,{"$f":"SUBTOTAL(109,Y20,Y22,Y24,Y26,Y28,Y30,Y32,Y34,Y36)","v":0},null,null,{"$f":"SUBTOTAL(109,AB20,AB22,AB24,AB26,AB28,AB30,AB32,AB34,AB36)","v":0}]
[]
["Summe Honorar Grundleistungen"]
[{"$f":"SUM(G38:AD38)","v":0}]
[]
["bb) Umbauzuschläge"]
[]
[]
[]
[]
[]
[]
[]
["Es werden folgende Umbauzuschläge vereinbart:"]
["Anlagengruppe",null,null,null,null,null,"ALG 1",null,null,"ALG 2",null,null,"ALG 3",null,null,"ALG 4",null,null,"ALG 5",null,null,"ALG 6",null,null,"ALG 7",null,null,"ALG 8"]
["LP1: Teilhonorar",null,null,null,null,null,{"$f":"G20","v":0},null,null,{"$f":"J20","v":0},null,null,{"$f":"M20","v":0},null,null,{"$f":"P20","v":0},null,null,{"$f":"S20","v":0},null,null,{"$f":"V20","v":0},null,null,{"$f":"Y20","v":0},null,null,{"$f":"AB20","v":0}]
["LP 1: Umbauzuschlag"]
["LP 1: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G53*G54,2)","v":0},null,null,{"$f":"ROUND(J53*J54,2)","v":0},null,null,{"$f":"ROUND(M53*M54,2)","v":0},null,null,{"$f":"ROUND(P53*P54,2)","v":0},null,null,{"$f":"ROUND(S53*S54,2)","v":0},null,null,{"$f":"ROUND(V53*V54,2)","v":0},null,null,{"$f":"ROUND(Y53*Y54,2)","v":0},null,null,{"$f":"ROUND(AB53*AB54,2)","v":0}]
["LP 2: Teilhonorar",null,null,null,null,null,{"$f":"G22","v":0},null,null,{"$f":"J22","v":0},null,null,{"$f":"M22","v":0},null,null,{"$f":"P22","v":0},null,null,{"$f":"S22","v":0},null,null,{"$f":"V22","v":0},null,null,{"$f":"Y22","v":0},null,null,{"$f":"AB22","v":0}]
["LP 2: Umbauzuschlag"]
["LP 2: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G56*G57,2)","v":0},null,null,{"$f":"ROUND(J56*J57,2)","v":0},null,null,{"$f":"ROUND(M56*M57,2)","v":0},null,null,{"$f":"ROUND(P56*P57,2)","v":0},null,null,{"$f":"ROUND(S56*S57,2)","v":0},null,null,{"$f":"ROUND(V56*V57,2)","v":0},null,null,{"$f":"ROUND(Y56*Y57,2)","v":0},null,null,{"$f":"ROUND(AB56*AB57,2)","v":0}]
["LP 3: Teilhonorar",null,null,null,null,null,{"$f":"G24","v":0},null,null,{"$f":"J24","v":0},null,null,{"$f":"M24","v":0},null,null,{"$f":"P24","v":0},null,null,{"$f":"S24","v":0},null,null,{"$f":"V24","v":0},null,null,{"$f":"Y24","v":0},null,null,{"$f":"AB24","v":0}]
["LP 3: Entwurfsplanung"]
["LP 3: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G59*G60,2)","v":0},null,null,{"$f":"ROUND(J59*J60,2)","v":0},null,null,{"$f":"ROUND(M59*M60,2)","v":0},null,null,{"$f":"ROUND(P59*P60,2)","v":0},null,null,{"$f":"ROUND(S59*S60,2)","v":0},null,null,{"$f":"ROUND(V59*V60,2)","v":0},null,null,{"$f":"ROUND(Y59*Y60,2)","v":0},null,null,{"$f":"ROUND(AB59*AB60,2)","v":0}]
["LP 4: Teilhonorar",null,null,null,null,null,{"$f":"G26","v":0},null,null,{"$f":"J26","v":0},null,null,{"$f":"M26","v":0},null,null,{"$f":"P26","v":0},null,null,{"$f":"S26","v":0},null,null,{"$f":"V26","v":0},null,null,{"$f":"Y26","v":0},null,null,{"$f":"AB26","v":0}]
["LP 4: Umbauzuschlag"]
["LP 4: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G62*G63,2)","v":0},null,null,{"$f":"ROUND(J62*J63,2)","v":0},null,null,{"$f":"ROUND(M62*M63,2)","v":0},null,null,{"$f":"ROUND(P62*P63,2)","v":0},null,null,{"$f":"ROUND(S62*S63,2)","v":0},null,null,{"$f":"ROUND(V62*V63,2)","v":0},null,null,{"$f":"ROUND(Y62*Y63,2)","v":0},null,null,{"$f":"ROUND(AB62*AB63,2)","v":0}]
["LP 5: Teilhonorar",null,null,null,null,null,{"$f":"G28","v":0},null,null,{"$f":"J28","v":0},null,null,{"$f":"M28","v":0},null,null,{"$f":"P28","v":0},null,null,{"$f":"S28","v":0},null,null,{"$f":"V28","v":0},null,null,{"$f":"Y28","v":0},null,null,{"$f":"AB28","v":0}]
["LP 5: Ausführungsplanung"]
["LP 5: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G65*G66,2)","v":0},null,null,{"$f":"ROUND(J65*J66,2)","v":0},null,null,{"$f":"ROUND(M65*M66,2)","v":0},null,null,{"$f":"ROUND(P65*P66,2)","v":0},null,null,{"$f":"ROUND(S65*S66,2)","v":0},null,null,{"$f":"ROUND(V65*V66,2)","v":0},null,null,{"$f":"ROUND(Y65*Y66,2)","v":0},null,null,{"$f":"ROUND(AB65*AB66,2)","v":0}]
["LP 6: Teilhonorar",null,null,null,null,null,{"$f":"G30","v":0},null,null,{"$f":"J30","v":0},null,null,{"$f":"M30","v":0},null,null,{"$f":"P30","v":0},null,null,{"$f":"S30","v":0},null,null,{"$f":"V30","v":0},null,null,{"$f":"Y30","v":0},null,null,{"$f":"AB30","v":0}]
["LP 6: Umbauzuschlag"]
["LP 6: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G68*G69,2)","v":0},null,null,{"$f":"ROUND(J68*J69,2)","v":0},null,null,{"$f":"ROUND(M68*M69,2)","v":0},null,null,{"$f":"ROUND(P68*P69,2)","v":0},null,null,{"$f":"ROUND(S68*S69,2)","v":0},null,null,{"$f":"ROUND(V68*V69,2)","v":0},null,null,{"$f":"ROUND(Y68*Y69,2)","v":0},null,null,{"$f":"ROUND(AB68*AB69,2)","v":0}]
["LP 7: Teilhonorar",null,null,null,null,null,{"$f":"G32","v":0},null,null,{"$f":"J32","v":0},null,null,{"$f":"M32","v":0},null,null,{"$f":"P32","v":0},null,null,{"$f":"S32","v":0},null,null,{"$f":"V32","v":0},null,null,{"$f":"Y32","v":0},null,null,{"$f":"AB32","v":0}]
["LP 7: Mitwirkung Vergabe"]
["LP 7: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G71*G72,2)","v":0},null,null,{"$f":"ROUND(J71*J72,2)","v":0},null,null,{"$f":"ROUND(M71*M72,2)","v":0},null,null,{"$f":"ROUND(P71*P72,2)","v":0},null,null,{"$f":"ROUND(S71*S72,2)","v":0},null,null,{"$f":"ROUND(V71*V72,2)","v":0},null,null,{"$f":"ROUND(Y71*Y72,2)","v":0},null,null,{"$f":"ROUND(AB71*AB72,2)","v":0}]
["LP 8: Teilhonorar",null,null,null,null,null,{"$f":"G34","v":0},null,null,{"$f":"J34","v":0},null,null,{"$f":"M34","v":0},null,null,{"$f":"P34","v":0},null,null,{"$f":"S34","v":0},null,null,{"$f":"V34","v":0},null,null,{"$f":"Y34","v":0},null,null,{"$f":"AB34","v":0}]
["LP 8: Umbauzuschlag"]
["LP 8: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G74*G75,2)","v":0},null,null,{"$f":"ROUND(J74*J75,2)","v":0},null,null,{"$f":"ROUND(M74*M75,2)","v":0},null,null,{"$f":"ROUND(P74*P75,2)","v":0},null,null,{"$f":"ROUND(S74*S75,2)","v":0},null,null,{"$f":"ROUND(V74*V75,2)","v":0},null,null,{"$f":"ROUND(Y74*Y75,2)","v":0},null,null,{"$f":"ROUND(AB74*AB75,2)","v":0}]
["LP 9: Teilhonorar",null,null,null,null,null,{"$f":"G36","v":0},null,null,{"$f":"J36","v":0},null,null,{"$f":"M36","v":0},null,null,{"$f":"P36","v":0},null,null,{"$f":"S36","v":0},null,null,{"$f":"V36","v":0},null,null,{"$f":"Y36","v":0},null,null,{"$f":"AB36","v":0}]
["LP 9: Dokumenation"]
["LP 9: Betrag Umbauzuschlag",null,null,null,null,null,{"$f":"ROUND(G77*G78,2)","v":0},null,null,{"$f":"ROUND(J77*J78,2)","v":0},null,null,{"$f":"ROUND(M77*M78,2)","v":0},null,null,{"$f":"ROUND(P77*P78,2)","v":0},null,null,{"$f":"ROUND(S77*S78,2)","v":0},null,null,{"$f":"ROUND(V77*V78,2)","v":0},null,null,{"$f":"ROUND(Y77*Y78,2)","v":0},null,null,{"$f":"ROUND(AB77*AB78,2)","v":0}]
["Summe €",null,null,null,null,null,{"$f":"SUBTOTAL(109,G55,G58,G61,G64,G67,G70,G73,G76,G79)","v":0},null,null,{"$f":"SUBTOTAL(109,J55,J58,J61,J64,J67,J70,J73,J76,J79)","v":0},null,null,{"$f":"SUBTOTAL(109,M55,M58,M61,M64,M67,M70,M73,M76,M79)","v":0},null,null,{"$f":"SUBTOTAL(109,P55,P58,P61,P64,P67,P70,P73,P76,P79)","v":0},null,null,{"$f":"SUBTOTAL(109,S55,S58,S61,S64,S67,S70,S73,S76,S79)","v":0},null,null,{"$f":"SUBTOTAL(109,V55,V58,V61,V64,V67,V70,V73,V76,V79)","v":0},null,null,{"$f":"SUBTOTAL(109,Y55,Y58,Y61,Y64,Y67,Y70,Y73,Y76,Y79)","v":0},null,null,{"$f":"SUBTOTAL(109,AB55,AB58,AB61,AB64,AB67,AB70,AB73,AB76,AB79)","v":0}]
[]
["Summe Umbauzuschlag:"]
[{"$f":"SUM(G80:AD80)","v":0}]
[]
["3. Besondere Leistungen"]
[]
["Werden Besondere Leistungen beauftragt?"]
[]
[]
[]
["nein"]
[]
[{"$f":"IF(BL_ob=\"ja\",\"Es wird je Anlagengruppe das folgende Pauschalhonorar (netto) für sämtliche Besonderen Leistungen der jeweiligen Anlagengruppe vereinbart.\",\"Es werden KEINE Besonderen Leistungen beauftragt.\")","v":"Es werden KEINE Besonderen Leistungen beauftragt."}]
["Anlagengruppe",null,null,null,null,null,"ALG 1",null,null,"ALG 2",null,null,"ALG 3",null,null,"ALG 4",null,null,"ALG 5",null,null,"ALG 6",null,null,"ALG 7",null,null,"ALG 8"]
["Pauschalhonorar netto"]
[]
["Summe:"]
[{"$f":"IF(A91=\"ja\",Honorarhilfe!B11,\"0\")","v":"0"}]
[]
["4. Beratungsleistungen"]
[]
["Werden Beratungsleistungen beauftragt?"]
[]
[]
[]
["nein"]
[]
[{"$f":"IF(BeratLeist_ob=\"ja\",\"Es werden je Anlagengruppe folgende Pauschalhonorar (netto) für sämtliche Beratungsleistungen der jeweiligen Anlagengruppe vereinbart.\",\"Es werden KEINE Beratungsleistungen beauftragt.\")","v":"Es werden KEINE Beratungsleistungen beauftragt."}]
["Anlagengruppe",null,null,null,null,null,"ALG 1",null,null,"ALG 2",null,null,"ALG 3",null,null,"ALG 4",null,null,"ALG 5",null,null,"ALG 6",null,null,"ALG 7",null,null,"ALG 8"]
["Pauschalhonorar netto"]
[]
["Summe:"]
[{"$f":"IF(A106=\"ja\",Honorarhilfe!C11,\"0\")","v":"0"}]
[]
["5. Nebenkosten"]
[]
["Honorar (netto) für Grundleistungen inkl. Umbauzuschlag"]
[{"$f":"SUM(A41,A83)","v":0}]
[]
["Nebenkostensatz:"]
[]
[]
["Nebenkosten:"]
[{"$f":"Honorar_GL_UZ*A121","v":0}]

{"sheet":"Honorarhilfe","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Besond. L","Berat.Leist"]
["ALG 1",{"$f":"Honorar!G95","v":0},{"$f":"Honorar!G110","v":0}]
["ALG 2",{"$f":"Honorar!J95","v":0},{"$f":"Honorar!J110","v":0}]
["ALG 3",{"$f":"Honorar!M95","v":0},{"$f":"Honorar!M110","v":0}]
["ALG 4",{"$f":"Honorar!P95","v":0},{"$f":"Honorar!P110","v":0}]
["ALG 5",{"$f":"Honorar!S95","v":0},{"$f":"Honorar!S110","v":0}]
["ALG 6",{"$f":"Honorar!V95","v":0},{"$f":"Honorar!V110","v":0}]
["ALG 7",{"$f":"Honorar!Y95","v":0},{"$f":"Honorar!Y110","v":0}]
["ALG 8",{"$f":"Honorar!AB95","v":0},{"$f":"Honorar!AB110","v":0}]
["Summe",{"$f":"SUBTOTAL(109,B3:B10)","v":0},{"$f":"SUBTOTAL(109,C3:C10)","v":0}]

{"sheet":"HOAI","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[[7,0,7,5],[8,0,8,5],[10,0,10,5],[11,0,11,5],[12,0,12,5],[7,6,7,7],[8,6,8,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[14,6,14,7],[15,6,15,7],[9,0,9,5],[9,6,9,7],[14,4,14,5],[15,0,15,5],[14,0,14,2],[13,6,13,7],[13,0,13,5]]}
[]
[]
[]
[]
[]
["Honorarberechnung nach HOAI"]
[]
["1. Honorarsumme für Grundleistungen aller beauftragten Anlagengruppen:",null,null,null,null,null,{"$f":"[0]!Summe_Honorar_GL","v":0}]
["2. Summe für Umbauzuschläge:",null,null,null,null,null,{"$f":"[0]!Summe_UZ","v":0}]
["3. Zwischensumme 1",null,null,null,null,null,{"$f":"SUM(G9,G8)","v":0}]
["3. Pauschalhonor für Besondere Leistungen",null,null,null,null,null,{"$f":"[0]!BL_Summe","v":"0"}]
["4. Pauschalhonorar für Beratungsleistungen",null,null,null,null,null,{"$f":"[0]!BeratLeist_Summe","v":"0"}]
["5. Nebenkosten",null,null,null,null,null,{"$f":"[0]!NK_Summe","v":0}]
["6. Zwischensumme 2",null,null,null,null,null,{"$f":"SUM(G10,G11,G12,G13)","v":0}]
["7. Mehrwertsteuer",null,null,0.19,null,null,{"$f":"ROUND((G14*D15),2)","v":0}]
["8. Honorarsumme gesamt brutto",null,null,null,null,null,{"$f":"SUM(G14,G15)","v":0}]

{"sheet":"Pauschalhonorar","index":4,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":true,"merged":[[15,0,15,4],[16,0,16,4],[17,0,17,4],[10,8,11,8],[30,7,30,8],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[6,0,6,10],[14,0,14,4],[13,0,13,4],[12,0,12,4],[10,0,11,4],[33,0,33,10],[35,0,35,6],[30,0,30,6],[37,0,37,10],[44,0,44,7],[35,8,35,10],[34,8,34,9],[34,0,34,7],[38,0,38,7],[38,8,38,9],[39,0,39,10],[40,0,40,10],[42,8,42,9],[43,0,43,7],[36,0,36,7],[36,8,36,9],[47,8,47,9],[47,0,47,7],[41,0,41,10],[45,0,45,7],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,0,46,6],[46,8,46,9],[42,0,42,7]]}
[]
[]
[]
[]
[]
["Pauschalhonorar"]
[]
["Angezeigt wird das Honorar für die Grundleistungen inkl. eines ggf. vereinbarten Umbauzuschlages."]
["Tragen Sie hier das zu vereinbarende Pauschalhonorar ein."]
[]
[null,null,null,null,null,"Stufe I","Stufe II","Stufe III","Summe"]
[null,null,null,null,null,"LPH 1 - 4","LPH 5 - 7","LPH 8 & 9"]
["ALG 1 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!G$20,Honorar!G$22,Honorar!G$24,Honorar!G$26),SUM(Honorar!G$53,Honorar!G$55,Honorar!G$56,Honorar!G$58,Honorar!G$59,Honorar!G$61,Honorar!G$62,Honorar!G$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!G$28,Honorar!G$30,Honorar!G$32),SUM(Honorar!G$65,Honorar!G$67,Honorar!G$68,Honorar!G$70,Honorar!G$71,Honorar!G$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!G$34,Honorar!G$36),SUM(Honorar!G$74,Honorar!G$76,Honorar!G$77,Honorar!G$79))","v":0},{"$f":"SUM(F13:H13)","v":0}]
["ALG 1 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 2 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!J$20,Honorar!J$22,Honorar!J$24,Honorar!J$26),SUM(Honorar!J$53,Honorar!J$55,Honorar!J$56,Honorar!J$58,Honorar!J$59,Honorar!J$61,Honorar!J$62,Honorar!J$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!J$28,Honorar!J$30,Honorar!J$32),SUM(Honorar!J$65,Honorar!J$67,Honorar!J$68,Honorar!J$70,Honorar!J$71,Honorar!J$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!J$34,Honorar!J$36),SUM(Honorar!J$74,Honorar!J$76,Honorar!J$77,Honorar!J$79))","v":0},0]
["ALG 2 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 3 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!M$20,Honorar!M$22,Honorar!M$24,Honorar!M$26),SUM(Honorar!M$53,Honorar!M$55,Honorar!M$56,Honorar!M$58,Honorar!M$59,Honorar!M$61,Honorar!M$62,Honorar!M$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!M$28,Honorar!M$30,Honorar!M$32),SUM(Honorar!M$65,Honorar!M$67,Honorar!M$68,Honorar!M$70,Honorar!M$71,Honorar!M$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!M$34,Honorar!M$36),SUM(Honorar!M$74,Honorar!M$76,Honorar!M$77,Honorar!M$79))","v":0},0]
["ALG 3 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 4 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!P$20,Honorar!P$22,Honorar!P$24,Honorar!P$26),SUM(Honorar!P$53,Honorar!P$55,Honorar!P$56,Honorar!P$58,Honorar!P$59,Honorar!P$61,Honorar!P$62,Honorar!P$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!P$28,Honorar!P$30,Honorar!P$32),SUM(Honorar!P$65,Honorar!P$67,Honorar!P$68,Honorar!P$70,Honorar!P$71,Honorar!P$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!P$34,Honorar!P$36),SUM(Honorar!P$74,Honorar!P$76,Honorar!P$77,Honorar!P$79))","v":0},0]
["ALG 4 -Pauschal",null,null,null,null,null,null,null,0]
["ALG 5 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!S$20,Honorar!S$22,Honorar!S$24,Honorar!S$26),SUM(Honorar!S$53,Honorar!S$55,Honorar!S$56,Honorar!S$58,Honorar!S$59,Honorar!S$61,Honorar!S$62,Honorar!S$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!S$28,Honorar!S$30,Honorar!S$32),SUM(Honorar!S$65,Honorar!S$67,Honorar!S$68,Honorar!S$70,Honorar!S$71,Honorar!S$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!S$34,Honorar!S$36),SUM(Honorar!S$74,Honorar!S$76,Honorar!S$77,Honorar!S$79))","v":0},0]
["ALG 5 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 6 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!V$20,Honorar!V$22,Honorar!V$24,Honorar!V$26),SUM(Honorar!V$53,Honorar!V$55,Honorar!V$56,Honorar!V$58,Honorar!V$59,Honorar!V$61,Honorar!V$62,Honorar!V$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!V$28,Honorar!V$30,Honorar!V$32),SUM(Honorar!V$65,Honorar!V$67,Honorar!V$68,Honorar!V$70,Honorar!V$71,Honorar!V$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!V$34,Honorar!V$36),SUM(Honorar!V$74,Honorar!V$76,Honorar!V$77,Honorar!V$79))","v":0},0]
["ALG 6 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 7 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!Y$20,Honorar!Y$22,Honorar!Y$24,Honorar!Y$26),SUM(Honorar!Y$53,Honorar!Y$55,Honorar!Y$56,Honorar!Y$58,Honorar!Y$59,Honorar!Y$61,Honorar!Y$62,Honorar!Y$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!Y$28,Honorar!Y$30,Honorar!Y$32),SUM(Honorar!Y$65,Honorar!Y$67,Honorar!Y$68,Honorar!Y$70,Honorar!Y$71,Honorar!Y$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!Y$34,Honorar!Y$36),SUM(Honorar!Y$74,Honorar!Y$76,Honorar!Y$77,Honorar!Y$79))","v":0},0]
["ALG 7 - Pauschal",null,null,null,null,null,null,null,0]
["ALG 8 - HOAI",null,null,null,null,{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!AB$20,Honorar!AB$22,Honorar!AB$24,Honorar!AB$26),SUM(Honorar!AB$53,Honorar!AB$55,Honorar!AB$56,Honorar!AB$58,Honorar!AB$59,Honorar!AB$61,Honorar!AB$62,Honorar!AB$64))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!AB$28,Honorar!AB$30,Honorar!AB$32),SUM(Honorar!AB$65,Honorar!AB$67,Honorar!AB$68,Honorar!AB$70,Honorar!AB$71,Honorar!AB$73))","v":0},{"$f":"IF(Auswahl_ALG!$G$30=\"nein\",SUM(Honorar!AB$34,Honorar!AB$36),SUM(Honorar!AB$74,Honorar!AB$76,Honorar!AB$77,Honorar!AB$79))","v":0},0]
["ALG 8 - Pauschal",null,null,null,null,null,null,null,0]
[]
[]
["Summe Pauschalhonorar Grundleistungen",null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I14,I16,I18,I20,I22,I24,I26,I28)","v":0}]
[]
["2. Nebenkosten"]
[]
["Das Gesamt-Honorar für Grundleistungen nach der HOAI beträgt:",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I13,I15,I17,I19,I21,I23,I25,I27)","v":0}]
["Nebenkostensatz:",null,null,null,null,null,null,{"$f":"[0]!Nebenkostensatz","v":0}]
["Die Nebenkosten belaufen sich auf:",null,null,null,null,null,null,null,{"$f":"ROUND((I35*H36),2)","v":0}]
[]
["Pauschalbetrag für Nebenkosten:",null,null,null,null,null,null,null,200]
[]
["3. Gesamt-Pauschalhonorar"]
[]
["1. Gesamt-Pauschalhonorar für Grundleistungen inkl. Nebenkosten",null,null,null,null,null,null,null,{"$f":"SUM(H31,I39)","v":200}]
["2. Gesamt-Pauschalhonorar für Besondere Leistungen",null,null,null,null,null,null,null,{"$f":"Honorar!A98","v":"0"}]
["3. Gesamt-Pauschalhonorar für Beratungsleistungen",null,null,null,null,null,null,null,{"$f":"Honorar!A113","v":"0"}]
["4. Zwischensumme",null,null,null,null,null,null,null,{"$f":"SUM(I43,I44,I45)","v":200}]
["5. Mehrwertsteuer",null,null,null,null,null,null,0.19,{"$f":"I46*H47","v":38}]
["6. Pauschal-Gesamthonorar brutto",null,null,null,null,null,null,null,{"$f":"SUM(I46,I47)","v":238}]

{"sheet":"Rechner","index":5,"n_rows":135,"n_cols":13,"rows_kept":135,"cut":false,"hidden":true,"merged":[[120,3,120,4],[122,8,122,9],[133,3,133,4],[134,3,134,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[125,3,125,4],[125,8,125,9],[123,8,123,9],[124,8,124,9],[127,3,127,4],[124,3,124,4],[126,3,126,4],[122,0,122,2],[122,3,122,4],[124,0,124,2],[118,3,118,4],[111,8,111,9],[111,3,111,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[109,8,109,9],[104,3,104,4],[108,8,108,9],[105,3,105,4],[108,0,108,2],[108,3,108,4],[117,3,117,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[110,0,110,2],[110,3,110,4],[116,3,116,4],[115,3,115,4],[119,3,119,4],[96,0,96,2],[96,3,96,4],[97,3,97,4],[96,8,96,9],[86,3,86,4],[90,3,90,4],[94,0,94,2],[94,3,94,4],[91,3,91,4],[94,8,94,9],[95,8,95,9],[97,8,97,9],[92,3,92,4],[89,3,89,4],[87,3,87,4],[88,3,88,4],[83,3,83,4],[83,8,83,9],[84,3,84,4],[85,3,85,4],[110,8,110,9],[106,3,106,4],[103,3,103,4],[102,3,102,4],[101,3,101,4],[80,0,80,2],[80,3,80,4],[80,8,80,9],[74,3,74,4],[75,3,75,4],[64,3,64,4],[68,8,68,9],[66,0,66,2],[82,0,82,2],[82,3,82,4],[70,3,70,4],[71,3,71,4],[78,3,78,4],[68,0,68,2],[68,3,68,4],[77,3,77,4],[72,3,72,4],[73,3,73,4],[82,8,82,9],[81,8,81,9],[60,3,60,4],[61,3,61,4],[69,3,69,4],[66,8,66,9],[67,8,67,9],[76,3,76,4],[69,8,69,9],[66,3,66,4],[62,3,62,4],[63,3,63,4],[43,3,43,4],[59,3,59,4],[48,3,48,4],[49,3,49,4],[54,0,54,2],[54,3,54,4],[54,8,54,9],[44,3,44,4],[45,3,45,4],[52,0,52,2],[52,3,52,4],[47,3,47,4],[50,3,50,4],[52,8,52,9],[53,8,53,9],[46,3,46,4],[55,8,55,9],[56,3,56,4],[57,3,57,4],[55,3,55,4],[58,3,58,4],[28,3,28,4],[29,3,29,4],[26,8,26,9],[27,8,27,9],[27,3,27,4],[40,0,40,2],[40,3,40,4],[42,3,42,4],[41,3,41,4],[41,8,41,9],[38,0,38,2],[38,3,38,4],[34,3,34,4],[35,3,35,4],[38,8,38,9],[39,8,39,9],[40,8,40,9],[36,3,36,4],[30,3,30,4],[33,3,33,4],[31,3,31,4],[32,3,32,4],[0,5,0,6],[24,8,24,9],[24,0,24,2],[24,3,24,4],[0,1,0,2],[0,3,0,4],[26,0,26,2],[25,8,25,9],[26,3,26,4]]}
[null,"Zone I",null,"Zone II",null,"Zone III"]
["anrechb. K.","Min-I","Max-I","Min-II","Max-II","Min-III","Max-III"]
[0,0,0,0,0,0,0]
[5000,2132,2547,2547,2990,2990,3405]
[10000,3689,4408,4408,5174,5174,5893]
[15000,5084,6075,6075,7131,7131,8122]
[25000,7615,9098,9098,10681,10681,12164]
[35000,9934,11869,11869,13934,13934,15869]
[50000,13165,15729,15729,18465,18465,21029]
[75000,18122,21652,21652,25418,25418,28948]
[100000,22723,27150,27150,31872,31872,36299]
[150000,31228,37311,37311,43800,43800,49883]
[250000,46640,55726,55726,65418,65418,74504]
[500000,80684,96402,96402,113168,113168,128886]
[750000,111105,132749,132749,155836,155836,177480]
[1000000,139347,166493,166493,195448,195448,222594]
[1250000,166043,198389,198389,232891,232891,265237]
[1500000,191545,228859,228859,268660,268660,305974]
[2000000,239792,286504,286504,336331,336331,383044]
[2500000,285649,341295,341295,400650,400650,456296]
[3000000,329420,393593,393593,462044,462044,526217]
[3500000,371491,443859,443859,521052,521052,593420]
[4000000,412126,492410,492410,578046,578046,658331]
[]
["anrechenbare Kosten Anlagengruppe 1:",null,null,{"$f":"Honorar!G10","v":0},null,"Zone:",{"$f":"Honorar!G11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G25=\"I\",2,IF(G25=\"II\",4,IF(G25=\"III\",6,IF(G25=\"IV\",8,IF(G25=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G25=\"I\",3,IF(G25=\"II\",5,IF(G25=\"III\",7,IF(G25=\"IV\",9,IF(G25=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$28+(($D$29-$D$28)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$31+(($D$32-$D$31)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L26-K26)*($D$25-$D$27))/($D$30-$D$27)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D25)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$28+(($D$29-$D$28)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$31+(($D$32-$D$31)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L27-K27)*($D$25-$D$27))/($D$30-$D$27)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D27,A$3:G$23,B26)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$28+(($D$29-$D$28)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$31+(($D$32-$D$31)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L28-K28)*($D$25-$D$27))/($D$30-$D$27)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D27,A$3:G$23,E26)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D25)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D30,A$3:G$23,B26)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D30,A$3:G$23,E26)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D28+((D25-D27)*(D31-D28))/(D30-D27))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K26+M26","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K27+M27","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K28+M28","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D29+((D25-D27)*(D32-D29))/(D30-D27))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 2:",null,null,{"$f":"Honorar!J10","v":0},null,"Zone:",{"$f":"Honorar!J11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G39=\"I\",2,IF(G39=\"II\",4,IF(G39=\"III\",6,IF(G39=\"IV\",8,IF(G39=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G39=\"I\",3,IF(G39=\"II\",5,IF(G39=\"III\",7,IF(G39=\"IV\",9,IF(G39=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$42+(($D$43-$D$42)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$45+(($D$46-$D$45)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L40-K40)*($D$39-$D$41))/($D$44-$D$41)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D39)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$42+(($D$43-$D$42)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$45+(($D$46-$D$45)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L41-K41)*($D$39-$D$41))/($D$44-$D$41)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D41,A$3:G$23,B40)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$42+(($D$43-$D$42)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$45+(($D$46-$D$45)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L42-K42)*($D$39-$D$41))/($D$44-$D$41)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D41,A$3:G$23,E40)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D39)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D44,A$3:G$23,B40)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D44,A$3:G$23,E40)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D42+((D39-D41)*(D45-D42))/(D44-D41))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K40+M40","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K41+M41","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K42+M42","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D43+((D39-D41)*(D46-D43))/(D44-D41))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 3:",null,null,{"$f":"Honorar!M10","v":0},null,"Zone:",{"$f":"Honorar!M11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G53=\"I\",2,IF(G53=\"II\",4,IF(G53=\"III\",6,IF(G53=\"IV\",8,IF(G53=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G53=\"I\",3,IF(G53=\"II\",5,IF(G53=\"III\",7,IF(G53=\"IV\",9,IF(G53=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$56+(($D$57-$D$56)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$59+(($D$60-$D$59)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L54-K54)*($D$53-$D$55))/($D$58-$D$55)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D53)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$56+(($D$57-$D$56)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$59+(($D$60-$D$59)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L55-K55)*($D$53-$D$55))/($D$58-$D$55)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D55,A$3:G$23,B54)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$56+(($D$57-$D$56)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$59+(($D$60-$D$59)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L56-K56)*($D$53-$D$55))/($D$58-$D$55)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D55,A$3:G$23,E54)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D53)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D58,A$3:G$23,B54)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D58,A$3:G$23,E54)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D56+((D53-D55)*(D59-D56))/(D58-D55))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K54+M54","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K55+M55","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K56+M56","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D57+((D53-D55)*(D60-D57))/(D58-D55))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 4:",null,null,{"$f":"Honorar!P10","v":0},null,"Zone:",{"$f":"Honorar!P11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G67=\"I\",2,IF(G67=\"II\",4,IF(G67=\"III\",6,IF(G67=\"IV\",8,IF(G67=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G67=\"I\",3,IF(G67=\"II\",5,IF(G67=\"III\",7,IF(G67=\"IV\",9,IF(G67=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$70+(($D$71-$D$70)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$73+(($D$74-$D$73)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L68-K68)*($D$67-$D$69))/($D$72-$D$69)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D67)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$70+(($D$71-$D$70)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$73+(($D$74-$D$73)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L69-K69)*($D$67-$D$69))/($D$72-$D$69)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D69,A$3:G$23,B68)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$70+(($D$71-$D$70)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$73+(($D$74-$D$73)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L70-K70)*($D$67-$D$69))/($D$72-$D$69)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D69,A$3:G$23,E68)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D67)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D72,A$3:G$23,B68)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D72,A$3:G$23,E68)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D70+((D67-D69)*(D73-D70))/(D72-D69))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K68+M68","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K69+M69","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K70+M70","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D71+((D67-D69)*(D74-D71))/(D72-D69))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 5:",null,null,{"$f":"Honorar!S10","v":0},null,"Zone:",{"$f":"Honorar!S11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G81=\"I\",2,IF(G81=\"II\",4,IF(G81=\"III\",6,IF(G81=\"IV\",8,IF(G81=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G81=\"I\",3,IF(G81=\"II\",5,IF(G81=\"III\",7,IF(G81=\"IV\",9,IF(G81=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$84+(($D$85-$D$84)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$87+(($D$88-$D$87)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L82-K82)*($D$81-$D$83))/($D$86-$D$83)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D81)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$84+(($D$85-$D$84)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$87+(($D$88-$D$87)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L83-K83)*($D$81-$D$83))/($D$86-$D$83)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D83,A$3:G$23,B82)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$84+(($D$85-$D$84)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$87+(($D$88-$D$87)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L84-K84)*($D$81-$D$83))/($D$86-$D$83)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D83,A$3:G$23,E82)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D81)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D86,A$3:G$23,B82)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D86,A$3:G$23,E82)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D84+((D81-D83)*(D87-D84))/(D86-D83))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K82+M82","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K83+M83","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K84+M84","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D85+((D81-D83)*(D88-D85))/(D86-D83))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 6:",null,null,{"$f":"Honorar!V10","v":0},null,"Zone:",{"$f":"Honorar!V11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G95=\"I\",2,IF(G95=\"II\",4,IF(G95=\"III\",6,IF(G95=\"IV\",8,IF(G95=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G95=\"I\",3,IF(G95=\"II\",5,IF(G95=\"III\",7,IF(G95=\"IV\",9,IF(G95=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$98+(($D$99-$D$98)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$101+(($D$102-$D$101)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L96-K96)*($D$95-$D$97))/($D$100-$D$97)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D95)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$98+(($D$99-$D$98)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$101+(($D$102-$D$101)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L97-K97)*($D$95-$D$97))/($D$100-$D$97)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D97,A$3:G$23,B96)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$98+(($D$99-$D$98)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$101+(($D$102-$D$101)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L98-K98)*($D$95-$D$97))/($D$100-$D$97)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D97,A$3:G$23,E96)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D95)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D100,A$3:G$23,B96)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D100,A$3:G$23,E96)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D98+((D95-D97)*(D101-D98))/(D100-D97))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K96+M96","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K97+M97","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K98+M98","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D99+((D95-D97)*(D102-D99))/(D100-D97))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 7:",null,null,{"$f":"Honorar!Y10","v":0},null,"Zone:",{"$f":"Honorar!Y11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G109=\"I\",2,IF(G109=\"II\",4,IF(G109=\"III\",6,IF(G109=\"IV\",8,IF(G109=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G109=\"I\",3,IF(G109=\"II\",5,IF(G109=\"III\",7,IF(G109=\"IV\",9,IF(G109=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$112+(($D$113-$D$112)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$115+(($D$116-$D$115)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L110-K110)*($D$109-$D$111))/($D$114-$D$111)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D109)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$112+(($D$113-$D$112)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$115+(($D$116-$D$115)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L111-K111)*($D$109-$D$111))/($D$114-$D$111)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D111,A$3:G$23,B110)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$112+(($D$113-$D$112)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$115+(($D$116-$D$115)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L112-K112)*($D$109-$D$111))/($D$114-$D$111)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D111,A$3:G$23,E110)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D109)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D114,A$3:G$23,B110)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D114,A$3:G$23,E110)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D112+((D109-D111)*(D115-D112))/(D114-D111))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K110+M110","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K111+M111","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K112+M112","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D113+((D109-D111)*(D116-D113))/(D114-D111))","v":{"$error":"#N/A"}}]
[]
["anrechenbare Kosten Anlagengruppe 8:",null,null,{"$f":"Honorar!AB10","v":0},null,"Zone:",{"$f":"Honorar!AB11","v":"Auswahl"},null,"Satzberechnung",null,"Wert A","Wert B","Wert C"]
["Spalte 1:",{"$f":"IF(G123=\"I\",2,IF(G123=\"II\",4,IF(G123=\"III\",6,IF(G123=\"IV\",8,IF(G123=\"V\",10,\"?\")))))","v":"?"},null,"Spalte 2:",{"$f":"IF(G123=\"I\",3,IF(G123=\"II\",5,IF(G123=\"III\",7,IF(G123=\"IV\",9,IF(G123=\"V\",11,\"?\")))))","v":"?"},null,null,null,"Viertelsatz",null,{"$f":"$D$126+(($D$127-$D$126)*25/100)","v":{"$error":"#N/A"}},{"$f":"$D$129+(($D$130-$D$129)*25/100)","v":{"$error":"#REF!"}},{"$f":"((L124-K124)*($D$123-$D$125))/($D$128-$D$125)","v":{"$error":"#REF!"}}]
["nächstniedriger Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D123)+1)","v":"anrechb. K."},null,null,null,null,"Mittelsatz",null,{"$f":"$D$126+(($D$127-$D$126)*50/100)","v":{"$error":"#N/A"}},{"$f":"$D$129+(($D$130-$D$129)*50/100)","v":{"$error":"#REF!"}},{"$f":"((L125-K125)*($D$123-$D$125))/($D$128-$D$125)","v":{"$error":"#REF!"}}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D125,A$3:G$23,B124)","v":{"$error":"#N/A"}},null,null,null,null,"Dreiviertelsatz",null,{"$f":"$D$126+(($D$127-$D$126)*75/100)","v":{"$error":"#N/A"}},{"$f":"$D$129+(($D$130-$D$129)*75/100)","v":{"$error":"#REF!"}},{"$f":"((L126-K126)*($D$123-$D$125))/($D$128-$D$125)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D125,A$3:G$23,E124)","v":{"$error":"#N/A"}}]
["nächsthöherer Tabellenwert:",null,null,{"$f":"INDEX($A$2:$A$23,COUNTIF($A$2:$A$23,\"<\"&D123)+2)","v":0}]
["Mindestsatz:",null,null,{"$f":"VLOOKUP(D128,A$3:G$23,B124)","v":{"$error":"#REF!"}}]
["Höchstsatz:",null,null,{"$f":"VLOOKUP(D128,A$3:G$23,E124)","v":{"$error":"#REF!"}}]
["Interpolierter Mindestsatz:",null,null,{"$f":"(D126+((D123-D125)*(D129-D126))/(D128-D125))","v":{"$error":"#N/A"}}]
["Interpolierter Viertelsatz:",null,null,{"$f":"K124+M124","v":{"$error":"#N/A"}}]
["Interpolierter Mittelsatz:",null,null,{"$f":"K125+M125","v":{"$error":"#N/A"}}]
["Interpolierter Dreiviertelsatz:",null,null,{"$f":"K126+M126","v":{"$error":"#N/A"}}]
["Interpolierter Höchstsatz:",null,null,{"$f":"(D127+((D123-D125)*(D130-D127))/(D128-D125))","v":{"$error":"#N/A"}}]