{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Abrechnung für Fachexperten","Abrechnung für BM-Experten"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Abrechnung für Fachexperten","index":0,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[28,16,28,20],[27,14,27,20],[24,15,24,17],[25,11,25,14],[29,15,29,20],[24,19,24,20],[25,15,25,17],[25,18,25,19],[25,20,25,21],[29,0,29,3],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,5,29,7],[4,6,4,7],[5,6,5,7],[8,6,8,7],[13,6,13,7],[4,8,4,9],[11,6,11,7],[5,8,5,9],[8,8,8,9],[11,8,11,9],[13,8,13,9],[6,17,6,20],[12,7,12,8],[21,20,21,21],[17,20,17,21],[17,18,17,19],[15,20,15,21],[16,20,16,21],[19,20,19,21],[18,20,18,21],[18,18,18,19],[19,18,19,19],[20,18,20,19],[19,6,19,8],[23,3,23,4],[21,6,21,8],[22,6,22,8],[20,3,20,4],[21,3,21,4],[22,3,22,4],[20,6,20,8],[23,11,23,14],[22,18,22,19],[22,11,22,14],[18,15,18,17],[18,11,18,14],[19,11,19,14],[22,20,22,21],[20,20,20,21],[23,20,23,21],[19,3,19,4],[18,6,18,8],[23,18,23,19],[21,15,21,17],[22,15,22,17],[23,15,23,17],[21,18,21,19],[23,6,23,8],[18,3,18,4],[19,15,19,17],[20,15,20,17],[20,11,20,14],[21,11,21,14],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[16,11,16,14],[14,11,14,14],[15,11,15,14],[17,11,17,14],[12,3,12,4],[17,6,17,8],[6,22,6,23],[7,19,7,23],[6,1,6,5],[7,1,7,5],[6,9,6,13],[7,9,7,13],[16,15,16,17],[15,15,15,17],[17,15,17,17],[15,18,15,19],[16,18,16,19],[14,15,14,17],[14,20,14,21],[14,18,14,19]]}
[{"$nulls":4},"Kanton Schaffhausen ",{"$nulls":17},"                Bitte leer lassen"]
[{"$nulls":4},"Erziehungsdepartement"]
["Berufsbildungsamt",{"$nulls":6},"Abrechnung für Fachexperten"]
["Ringkengässchen 18",{"$nulls":8},"   Bitte Entschädigungsrichtlinien beachten!"]
["8200 Schaffhausen"]
["Tel.: 052-632 72 97"]
["Name:",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$nulls":4},"Vorname:",null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$nulls":5},"AHV-Nr.:",null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,"Beruf:",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["Strasse:",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$nulls":4},"PLZ/Wohnort:",null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$nulls":5},"PC oder Bankkonto:",null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[" "]
["Entschädigung für:",null,null,null,"Lehrabschlussprüfung (LAP)",null,null,"Zwischenprüfung (ZP)",null,null,null,"Wiederholungsprüfung (WP)",{"$nulls":7},"Betriebsbesuch (BB)",null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",\"A\")","v":""}]
[{"$nulls":4},"Teilprüfung (TP)",null,null,"Augenschein (AS)",{"$nulls":11},"Expertensitzung/-kurs (EXP)",null,null,null,{"$f":"IF(OR(J20=\"\",K20=\"\"),\"\",\"A\")","v":""}]
[]
["Experte / in im Beruf:",{"$nulls":4},"Prüfungsjahr",{"$nulls":5},"Sommer",{"$nulls":7},"Winter"]
[]
["Jahr","Monat","Tag","Prüfungsort",null,"Einsatz",null,null,null,"Einsatz",null,"Stunden",null,null,null,"\u0081",null,null,"‚",null,"ƒ",null,"\u0081-ƒ"]
[{"$nulls":5},"Vormittag",null,null,null,"Nachmittag",null,"Total pro",null,null,null,"Entschädigung",null,null,"Fahrt-",null,"Verpflegung",null,"Total pro","Bitte"]
[{"$nulls":5},"von","bis",null,null,"von","bis","Tag",null,null,null,"Stunden x 25.--",null,null,"auslagen",null,null,null,"Tag","leer lassen"]
[{"$nulls":11},{"$f":"IF(OR(OR(F18=\"\",G18=\"\")*OR(J18=\"\",K18=\"\")),\"\",(G18-F18)+(K18-J18))","v":""},null,null,null,{"$f":"IF(L18=\"\",\"\",L18*25*24)","v":""},{"$nulls":6},{"$f":"IF(P18=\"\",\"\",SUM(P18,S18,U18))","v":""}]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":11},"",null,null,null,"",{"$nulls":6},""]
[{"$nulls":9},"Konto:",null,"----------",null,null,null,2258.3002102,null,null,null,2258.3002102,null,null,"----------"]
["Laufweg",null,null,null,"Datum","Visum",null,null,null,"Zwischentotal:",null,{"$f":"IF(L18=\"\",\"\",SUM(L18:O24))","v":""},null,null,null,{"$f":"IF(P18=\"\",\"\",SUM(P18:R24))","v":""},null,null,{"$f":"IF(S18=\"\",\"\",SUM(S18:T24))","v":""},null,{"$f":"IF(U18=\"\",\"\",SUM(U18:V24))","v":""},null,{"$f":"IF(W18=\"\",\"\",SUM(W18:W24))","v":""}]
["Experte/Expertin"]
["Chefexperte/Chefexpertin",{"$nulls":8},"„ Übrige Auslagen",null,null,"- Kopien:"]
["Prüfungsleiter",{"$nulls":8},"„ (Quittungen ",null,null,"- Prüfungsmaterial:",{"$nulls":10},{"$f":"SUM(W28:W30)","v":0}]
["Rechnungsführer",{"$nulls":8},"„   beilegen)",null,null,"- Diverses:"]
["(Visum Chefexperte/Expertin einholen)",{"$nulls":19},"Konto:",null,2258.3131013000002]
[{"$nulls":20},"Total „",null,{"$f":"IF(X29=0,\"\",SUM(W28:W30))","v":""}]
[]
[{"$nulls":20},"Total \u0081-„",null,{"$f":"IF(W26=\"\",\"\",SUM(W26,W32))","v":""}]

{"sheet":"Abrechnung für BM-Experten","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,5,13,5],[16,3,16,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[11,3,13,4],[14,3,14,4],[15,3,15,4],[16,0,16,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[11,2,13,2],[8,1,8,2],[9,1,9,2],[11,0,13,1],[14,0,14,1],[15,0,15,1],[28,0,28,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[23,3,23,4],[23,0,23,1],[11,6,13,6],[11,7,13,7],[11,8,13,8],[11,10,13,10],[11,9,13,9]]}
[]
[]
["HKV Handelsschule KV Schaffhausen, Baumgartenstrasse 5, 8201 Schaffhausen"]
["Abrechnung für externe Fachexperten Grundbildung, inklusiv Berufsmaturitätsprüfung"]
[]
["Bitte Abrechnung online über unsere Webseite ausfüllen (http://www.hkv-sh.ch/uebersicht-qv.html) und nur die weissen Felder ausfüllen"]
[]
[]
["Name:",null,null,"Vorname:"]
["Strasse:",null,null,"PLZ/Wohnort:"]
[" "]
["Datum",null,"Kandidatennummer","Kandidatenname",null,"mündl. Prüfung\n30'","Entschädigung\nFr. 40.–/Std","Anzahl\nkm","Fahrtauslagen\nFr. 0.70/km","Billete\nin Fr.","Total\nKandidat"]
[{"$nulls":7},"in Fr.","Fr. 0.70/km",null,"Kandidat"]
[]
[{"$nulls":5},0,{"$f":"IF(F15=\"\",\"\",F15/60*40)","v":0},null,{"$f":"H15*0.7","v":0},null,{"$f":"G15+I15+J15","v":0}]
[{"$nulls":5},0,{"$f":"IF(F16=\"\",\"\",F16/60*40)","v":0},null,{"$f":"H16*0.7","v":0},null,{"$f":"G16+I16+J16","v":0}]
[{"$nulls":5},0,{"$f":"IF(F17=\"\",\"\",F17/60*40)","v":0},null,0,null,{"$f":"G17+I17+J17","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G18+I18+J18","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G19+I19+J19","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G20+I20+J20","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G21+I21+J21","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G22+I22+J22","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G23+I23+J23","v":0}]
[{"$nulls":5},0,0,null,0,null,{"$f":"G24+I24+J24","v":0}]
[]
["Laufweg",null,"Datum","Visum",{"$nulls":5},"Gesamttotal Fr.",{"$f":"SUM(K15:K24)","v":0}]
["Experte / Expertin"]
["Prüfungsleiter"]
["Rektorin"]
[]
[]
[]
[" "]