{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Zahlenmäßiger Nachweis","Beispieleintrag Nachweis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Daten","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2],[20,1,20,2],[22,1,22,2],[23,1,23,2],[21,1,21,2],[2,1,2,2],[25,0,26,0],[3,1,3,2],[5,1,5,2],[25,1,25,2],[4,1,4,2],[6,1,6,2],[26,1,26,2],[24,1,24,2],[7,0,17,0]]}
[]
[null,"Handreichung Verwendungsnachweis, Version 2.13"]
[]
[null,"Sehr geehrter Zuwendungsempfänger,\n\nfür den \"Zahlenmäßigen Nachweis\" Ihres Verwendungsnachweises empfiehlt sich der Einsatz dieser Handreichung.\n\nFüllen Sie dazu dieses Arbeitsblatt \"Daten\" und das Arbeitsblatt \"Zahlenmäßiger Nachweis\" vollständig aus.\n\nBeachten Sie bitte alle Hinweise in diesem Arbeitsblatt \"Daten\"."]
[]
[1,"Einen beispielhaften Eintrag finden Sie im Arbeitsblatt \"Beispieleintrag Nachweis\".\nDort ist die Handhabung im Prinzip zu erkennen.\n\nDie Eintragungen zu Ihrem Fördervorhaben können Sie in dem Arbeitsblatt \"Zahlenmäßiger Nachweis\" vornehmen.\n\nDurch die Verwendung des Buttons \"Filter ein/aus\" (in den beiden genannten Arbeitsblättern jeweils oben links in gelber Schrift) können Sie für eigene Überprüfungen verschiedenste Filterungen mit den zugehörigen Teilsummen bilden.\n\nBeispiele hierzu wären die Anzeige aller Einträge zu einer bestimmten Ausgabenposition des Ausgabenplans gemäß Förderbescheid (z.B. alle eingetragenen Ausgaben zur Ausgabenplan-Position Nr. 1 etc), die Anzeige aller Ausgaben eines bestimmten Rechnungsdatums oder -zeitraums (Excel-Filter-Option \"benutzerdefiniert\") oder alle Eintragungen bezogen auf einen bestimmten Lieferanten.\n\nVor dem Ausdruck Ihres fertiggestellten Nachweises empfiehlt es sich, die nicht genutzten, frei geblieben Zeilen im Arbeitsblatt \"Zahlenm. Nachweis\" zu löschen. Für den Ausdruck selbst genügt i.d.R. ein Ausdruck auf ein DIN A4-Blatt, welches danach auf einem Kopierer auf DIN A3 vergrößert wird. \n\nBei Fragen zur Handhabung wenden Sie sich gerne an Ihren Ansprechpartner bei der hessenENERGIE in Wiesbaden."]
[]
[2,"Zuwendungsempfänger:","Name,\nAdresse"]
[null,"Bezeichnung des Fördervorhabens:","Fördervorhaben xy, Bezeichnung"]
[null,"Adresse des Fördervorhabens:","Plz + Ort, Straße + Hausnummer"]
[null,"Aktenzeichen des Förderantrags:","LTH / ... / ..."]
[null,"Datum des Förderantrags:","2007-01-01"]
[null,"ggf. Datum des Änderungsantrags:","2007-01-01"]
[null,"ggf. Datum der Genehmigung zum vorzeitigen Vorhabenbeginn:","2007-01-01"]
[null,"Datum des Zuwendungsbescheids:","2007-01-01"]
[null,"ggf. Datum des Änderungsbescheids:","2007-01-01"]
[null,"Datum der Inbetriebnahme der Anlage:","2007-01-01"]
[null,"Datum Ihres Verwendungsnachweises:","2007-01-01"]
[null,"Summe der bisher abgerufenen Fördermittel:",10000]
[null,"Vorliegende Berechtigung zum Vorsteuerabzug (§ 15 Umsatzsteuergesetz):","nein"]
[]
[3,"Fügen Sie bitte Ihrem Verwendungsnachweis gemäß der Nebenbestimmungen Ihres Förderbescheids einen aktuellen Sachstandsbericht bei."]
[]
[4,"Ergänzen Sie Ihren Sachstandsbericht bzw. Verwendungsnachweis um eine eindeutige schriftliche Erklärung,\ndass bei dem Fördervorhaben die in dem zugehörigen Förderbescheid genannten Nebenbestimmungen\nbzgl. der Vergabe eingehalten wurden (Näheres siehe im Förderbescheid). "]
[]
[5,"Verwenden Sie für Ihren Verwendungsnachweis die jeweils aktuellste Version dieser Excel-Datei,\ndie im Internet bei der hessenENERGIE als Download zur Verfügung steht unter:"]
[null,"http://www.hessenenergie.de/Foerderung/Foer-Hessen/Verwendungsnachweis.zip"]
[]
[null,"2007-04-17","www.hessenENERGIE.de"]

{"sheet":"Zahlenmäßiger Nachweis","index":1,"n_rows":189,"n_cols":20,"rows_kept":189,"cut":false,"hidden":false,"merged":[[0,0,1,0],[1,8,1,17]]}
[{"$f":"\"V \"&RIGHT(Daten!B2,LEN(Daten!B2)-FIND(\".\",Daten!B2)+2)","v":"V 2.13"}]
[null,"Zahlenmäßiger Nachweis",null,null,null,null,null,null,{"$f":"Daten!C9&\"  -  \"&Daten!C10","v":"Fördervorhaben xy, Bezeichnung  -  Plz + Ort, Straße + Hausnummer"},null,null,null,null,null,null,null,null,null,{"$f":"Daten!C18","v":"2007-01-01"}]
[]
[null,"Spalte A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S"]
[null,"laufende\nNr.","Pos.-Nr.\ndes Aus-\ngabenplans","interne\nBeleg-Nr.","Datum der\nAuftrags-\nerteilung","Datum der\nAusführung,\nLeistung","Datum der Rechnung","Tag der\nZahlung","Rechnungs-\nnummer","Zahlungsempfänger (Name, Ort, ...)","Leistung, Grund der Zahlung","Postions-Nr. innerhalb\nder Rechnungen","Einnahmen","gesamter\nRechnungs-\nbetrag\nbrutto","anrechenbarer\nRechnungs-\nbetrag\nbrutto","dito","tatsächliche\nAusgaben\nbrutto","MwSt.-\nSatz","tatsächliche\nAusgaben\nnetto","Notizen"]
[null,"A n z a h l   d e r   E i n t r ä g e",null,null,null,null,null,null,null,null,null,null,"S u m m e",null,"S u m m e",null,"S u m m e",null,"S u m m e"]
[null,{"$f":"SUBTOTAL(3,B9:B190)","v":180},{"$f":"SUBTOTAL(3,C9:C190)","v":1},{"$f":"SUBTOTAL(3,D9:D190)","v":0},{"$f":"SUBTOTAL(3,E9:E190)&\" Einträge\"","v":"0 Einträge"},"0 Einträge","0 Einträge",{"$f":"SUBTOTAL(3,H9:H190)&\" Einträge\"","v":"0 Einträge"},"0 Einträge","0 Einträge","0 Einträge",null,{"$f":"SUBTOTAL(9,M9:M190)","v":0},null,{"$f":"SUBTOTAL(9,O9:O190)","v":0},null,{"$f":"SUBTOTAL(9,Q9:Q190)","v":0},null,{"$f":"SUBTOTAL(9,S9:S190)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"EUR","EUR","EUR","%","EUR","%","EUR"]
[]
[null,{"$f":"OFFSET(B10,-1,0)+1","v":1},"1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(N10),TYPE(N10)=2),\" - \",O10/N10*100)","v":" - "},null,19,{"$f":"IF(TYPE(Q10)=1,ROUND(Q10/(1+R10/100),2),\"-\")","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(N11),TYPE(N11)=2),\" - \",O11/N11*100)","v":" - "},null,19,{"$f":"IF(TYPE(Q11)=1,ROUND(Q11/(1+R11/100),2),\"-\")","v":0}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,34,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,53,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,54,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,55,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,56,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,57,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,58,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,59,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,61,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,62,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,63,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,64,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,65,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(N75),TYPE(N75)=2),\" - \",O75/N75*100)","v":" - "},null,19,{"$f":"IF(TYPE(Q75)=1,ROUND(Q75/(1+R75/100),2),\"-\")","v":0}]
[null,67,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,68,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,69,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,71,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,72,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,73,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,74,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,76,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,77,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,78,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,79,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,81,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,82,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,83,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,84,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,85,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,87,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,88,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,89,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,90,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,91,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,92,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,93,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,94,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,95,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,96,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,97,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,98,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,99,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,100,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,101,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,102,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,103,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,104,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,105,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,106,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,107,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,108,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,109,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,110,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,111,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,112,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,113,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,114,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,115,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,116,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,117,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,118,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,119,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,120,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,121,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,122,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,123,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,124,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,125,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,126,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,127,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,128,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,129,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,130,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(N139),TYPE(N139)=2),\" - \",O139/N139*100)","v":" - "},null,19,{"$f":"IF(TYPE(Q139)=1,ROUND(Q139/(1+R139/100),2),\"-\")","v":0}]
[null,131,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,132,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,133,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,134,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,135,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,136,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,137,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,138,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,139,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,140,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,141,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,142,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,143,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,144,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,145,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,146,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,147,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,148,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,149,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,150,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,151,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,152,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,153,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,154,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,155,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,156,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,157,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,158,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,159,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,160,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,161,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,162,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,163,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,164,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,165,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,166,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,167,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,168,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,169,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,170,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,171,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,172,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,173,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,174,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,175,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,176,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,177,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,178,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,179,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]
[null,180,null,null,null,null,null,null,null,null,null,null,null,null,null," - ",null,19,0]

{"sheet":"Beispieleintrag Nachweis","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,1,0],[1,8,1,17]]}
[{"$f":"\"V \"&RIGHT(Daten!B2,LEN(Daten!B2)-FIND(\".\",Daten!B2)+2)","v":"V 2.13"}]
[null,"Verwendungsnachweis",null,null,null,null,null,null,"Fördervorhaben Beispiel, Beispiel-Bezeichnung, Beispiel-Ort",null,null,null,null,null,null,null,null,null,"2007-04-17"]
[]
[null,"Spalte A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S"]
[null,"laufende\nNr.","Pos.-Nr.\ndes Aus-\ngabenplans","interne\nBeleg-Nr.","Datum der\nAuftrags-\nerteilung","Datum der\nAusführung,\nLeistung","Datum der Rechnung","Tag der\nZahlung","Rechnungs-\nnummer","Zahlungsempfänger (Name, Ort, ...)","Leistung, Grund der Zahlung","Postions-Nr. innerhalb\nder Rechnungen","Einnahmen","gesamter\nRechnungs-\nbetrag\nbrutto","anrechenbarer\nRechnungs-\nbetrag\nbrutto","dito","tatsächliche\nAusgaben\nbrutto","MwSt.-\nSatz","tatsächliche\nAusgaben\nnetto","Notizen"]
[null,"A n z a h l   d e r   E i n t r ä g e",null,null,null,null,null,null,null,null,null,null,"S u m m e",null,"S u m m e",null,"S u m m e",null,"S u m m e"]
[null,{"$f":"SUBTOTAL(3,B9:B35)","v":19},{"$f":"SUBTOTAL(3,C9:C35)","v":21},{"$f":"SUBTOTAL(3,D9:D35)","v":15},{"$f":"SUBTOTAL(3,E9:E35)&\" Einträge\"","v":"15 Einträge"},"15 Einträge","15 Einträge","15 Einträge","15 Einträge","15 Einträge","15 Einträge",null,{"$f":"SUBTOTAL(9,M9:M35)","v":15000},null,{"$f":"SUBTOTAL(9,O9:O35)","v":79500},null,{"$f":"SUBTOTAL(9,Q9:Q35)","v":78250},null,{"$f":"SUBTOTAL(9,S9:S35)","v":67525.87}]
[null,null,null,null,null,null,null,null,null,null,null,null,"EUR","EUR","EUR","%","EUR","%","EUR"]
[]
[null,null,"Nachstehend finden Sie verschiedene, beispielhafte Einträge."]
[null,null,"Verwenden Sie bitte für Ihr Vorhaben das leere Arbeitsblatt \"Zahlenmäßiger Nachweis\"."]
[]
[null,"Bsp. 1:","Leistungen von vier verschiedenen Firmen (A - D), die jeweils eindeutig einer Position des Ausgabenplans zu geordnet werden können:"]
[null,1,1,"1-1","2005-03-01","2005-03-15","2005-04-01","2005-04-15","08-15","Firma A, Ort A","Holzfeuerungsanlage; Gesamtrechnung","Gesamter Rechnungsbetrag\n(alle Positionen, inkl. Versand, ohne Abzug von Skonto)",null,10000,{"$f":"N14","v":10000},{"$f":"IF(OR(ISBLANK(N14),TYPE(N14)=2),\" - \",O14/N14*100)","v":100},{"$f":"O14","v":10000},16,{"$f":"IF(TYPE(Q14)=1,ROUND(Q14/(1+R14/100),2),\"-\")","v":8620.69}]
[null,{"$f":"OFFSET(B15,-1,0)+1","v":2},"2","2-1","2005-05-01","2005-05-15","2005-06-01","2005-06-15","4711","Firma B, Ort B","Elektroarbeiten; Gesamtrechnung","Gesamter Rechnungsbetrag\n(alle Positionen, inkl. Versand, inkl. Abzug von 3 % Skonto)",null,10000,{"$f":"N15","v":10000},{"$f":"IF(OR(ISBLANK(N15),TYPE(N15)=2),\" - \",O15/N15*100)","v":100},{"$f":"O15*0.97","v":9700},16,{"$f":"IF(TYPE(Q15)=1,ROUND(Q15/(1+R15/100),2),\"-\")","v":8362.07}]
[null,3,"3","3-1","2005-02-01","2005-02-15","2005-03-01","2005-03-15","007.08","Firma C, Ort C","Planung und Bauleitung; Gesamtrechnung","Rechnungsbetrag abzgl. Rechn.-Pos. 9 und\nabzgl. 5 % Einbehalt",null,11000,{"$f":"N16-2000","v":9000},{"$f":"IF(OR(ISBLANK(N16),TYPE(N16)=2),\" - \",O16/N16*100)","v":81.818181818181827},{"$f":"O16*0.95","v":8550},16,{"$f":"IF(TYPE(Q16)=1,ROUND(Q16/(1+R16/100),2),\"-\")","v":7370.69},"Rechn.-Pos. 9 (hier 2.000,- brutto) beinhaltet eine Maßnahme, die nicht förderfähig ist."]
[null,4,"4","4-1","2005-01-01","2005-01-15","2005-02-01","2005-02-15","2005.77","Behörde D, Ort D","Baugenehmigung","Gesamter Rechnungsbetrag;\nNettobetrag",null,500,{"$f":"N17","v":500},{"$f":"IF(OR(ISBLANK(N17),TYPE(N17)=2),\" - \",O17/N17*100)","v":100},{"$f":"O17","v":500},0,{"$f":"IF(TYPE(Q17)=1,ROUND(Q17/(1+R17/100),2),\"-\")","v":500}]
[]
[null,"Bsp. 2:","Für die gesamte Leistung einer Firma A, die einer einzelnen Ausgabenposition (1) zugeordnet werden kann, wurden zwei Abschlagrechnungen und eine Abschlussrechnung vorgelegt und gezahlt:"]
[null,1,1,"A7-01","2005-03-01","2005-03-15","2005-04-01","2005-04-15","08-15","Firma A, Ort A","Holzfeuerungsanlage; 1. Abschlagsrechnung","Gesamter Rechnungsbetrag\n(alle Positionen, inkl. Versand, ohne Abzug von Skonto)",null,10000,{"$f":"N20","v":10000},{"$f":"IF(OR(ISBLANK(N20),TYPE(N20)=2),\" - \",O20/N20*100)","v":100},{"$f":"O20","v":10000},16,{"$f":"IF(TYPE(Q20)=1,ROUND(Q20/(1+R20/100),2),\"-\")","v":8620.69}]
[null,2,1,"A7-02","2005-03-01","2005-04-15","2005-05-01","2005-05-15","08-16","Firma A, Ort A","Holzfeuerungsanlage; 2. Abschlagsrechnung","Gesamter Rechnungsbetrag\n(alle Positionen, inkl. Versand, ohne Abzug von Skonto)",null,10000,{"$f":"N21","v":10000},{"$f":"IF(OR(ISBLANK(N21),TYPE(N21)=2),\" - \",O21/N21*100)","v":100},{"$f":"O21","v":10000},16,{"$f":"IF(TYPE(Q21)=1,ROUND(Q21/(1+R21/100),2),\"-\")","v":8620.69}]
[null,3,1,"A7-03","2005-03-01","2005-05-15","2005-06-01","2005-06-15","08-17","Firma A, Ort A","Holzfeuerungsanlage; Gesamtrechnung","Gesamter Rechnungsbetrag\n(alle Positionen, inkl. Versand, ohne Abzug von Skonto)",null,5000,{"$f":"N22","v":5000},{"$f":"IF(OR(ISBLANK(N22),TYPE(N22)=2),\" - \",O22/N22*100)","v":100},{"$f":"O22","v":5000},16,{"$f":"IF(TYPE(Q22)=1,ROUND(Q22/(1+R22/100),2),\"-\")","v":4310.34}]
[]
[null,"Bsp. 3:","Ähnlich dem Bsp. 2; hier werden Teilbeträge der Rechnung(en) (inkl. Skonto) der Firma A jedoch drei verschiedenen Positionen des Ausgabenplans (1 - 3) zugeordnet. Es empfiehlt sich hier, die Schlussrechnung als Basis zu verwenden:"]
[null,1,"-","001","2005-03-01","2005-03-15","2005-04-01","2005-04-15","08-15","Firma A, Ort A","Holzfeuerungsanlage; 1. Abschlagsrechnung","1. Abschlagszahlung, Zuordnung (zu den Pos. den Ausgabenplans) siehe Beleg-Nr. 003",null,"in Beleg-Nr. 3 enthalten","in Beleg-Nr. 3 enthalten",{"$f":"IF(OR(ISBLANK(N25),TYPE(N25)=2),\" - \",O25/N25*100)","v":" - "},"in Beleg-Nr. 3 enthalten",16,{"$f":"IF(TYPE(Q25)=1,ROUND(Q25/(1+R25/100),2),\"-\")","v":"-"}]
[null,2,"-","002","2005-03-01","2005-04-15","2005-05-01","2005-05-15","08-33","Firma A, Ort A","Holzfeuerungsanlage; 2. Abschlagsrechnung","2. Abschlagszahlung, Zuordnung (zu den Pos. den Ausgabenplans) siehe Beleg-Nr. 003",null,"in Beleg-Nr. 3 enthalten","in Beleg-Nr. 3 enthalten",{"$f":"IF(OR(ISBLANK(N26),TYPE(N26)=2),\" - \",O26/N26*100)","v":" - "},"in Beleg-Nr. 3 enthalten",16,{"$f":"IF(TYPE(Q26)=1,ROUND(Q26/(1+R26/100),2),\"-\")","v":"-"}]
[null,3,1,"003","2005-03-01","2005-05-15","2005-06-01","2005-06-15","08-42","Firma A, Ort A","Holzfeuerungsanlage; Gesamtrechnung","Rechnungsbetrag Pos. 1. bis 4., inkl. Versand, anteiliger Abzug von 2 % Skonto auf den Gesamtbetrag von 25.000 EUR)",null,25000,10000,{"$f":"IF(OR(ISBLANK(N27),TYPE(N27)=2),\" - \",O27/N27*100)","v":40},{"$f":"O27*0.98","v":9800},16,{"$f":"IF(TYPE(Q27)=1,ROUND(Q27/(1+R27/100),2),\"-\")","v":8448.2800000000007}]
[null,4,"2","003","2005-03-01","2005-05-15","2005-06-01","2005-06-15","08-42","Firma A, Ort A","Holzfeuerungsanlage; Gesamtrechnung","Rechnungsbetrag Pos. 5. bis 7.3, inkl. Versand, anteiliger Abzug von 2 % Skonto auf den Gesamtbetrag von 25.000 EUR)",null,25000,10000,{"$f":"IF(OR(ISBLANK(N28),TYPE(N28)=2),\" - \",O28/N28*100)","v":40},{"$f":"O28*0.98","v":9800},16,{"$f":"IF(TYPE(Q28)=1,ROUND(Q28/(1+R28/100),2),\"-\")","v":8448.2800000000007}]
[null,5,"3","003","2005-03-01","2005-05-15","2005-06-01","2005-06-15","08-42","Firma A, Ort A","Holzfeuerungsanlage; Gesamtrechnung","Rechnungsbetrag Pos. 8. bis 10., inkl. Versand, anteiliger Abzug von 2 % Skonto auf den Gesamtbetrag von 25.000 EUR)",null,25000,5000,{"$f":"IF(OR(ISBLANK(N29),TYPE(N29)=2),\" - \",O29/N29*100)","v":20},{"$f":"O29*0.98","v":4900},16,{"$f":"IF(TYPE(Q29)=1,ROUND(Q29/(1+R29/100),2),\"-\")","v":4224.1400000000003}]
[]
[null,"Bsp. 4:","Einnahmen"]
[null,1,"Einnahme","B/27","-","-","-","2005-02-01","0815007","Bewilligungsbehörde E, Ort E","Abruf von Fördermitteln",null,5000,null,null,{"$f":"IF(OR(ISBLANK(N32),TYPE(N32)=2),\" - \",O32/N32*100)","v":" - "},null,16,{"$f":"IF(TYPE(Q32)=1,ROUND(Q32/(1+R32/100),2),\"-\")","v":0}]
[null,{"$f":"OFFSET(B33,-1,0)+1","v":2},"Einnahme","B/32","-","-","-","2005-03-01","0815012","Bewilligungsbehörde E, Ort E","Abruf von Fördermitteln",null,5000,null,null,{"$f":"IF(OR(ISBLANK(N33),TYPE(N33)=2),\" - \",O33/N33*100)","v":" - "},null,16,{"$f":"IF(TYPE(Q33)=1,ROUND(Q33/(1+R33/100),2),\"-\")","v":0}]
[null,{"$f":"OFFSET(B34,-1,0)+1","v":3},"Einnahme","B/44","-","-","-","2005-04-01","0815042","Bewilligungsbehörde E, Ort E","Abruf von Fördermitteln",null,5000,null,null,{"$f":"IF(OR(ISBLANK(N34),TYPE(N34)=2),\" - \",O34/N34*100)","v":" - "},null,16,{"$f":"IF(TYPE(Q34)=1,ROUND(Q34/(1+R34/100),2),\"-\")","v":0}]