{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["loonberek invullen promotor","tijdsregist invullen promotor","waarden lonen","voorbeeld tijdsreg","Voorbeeld loonberekening","In te vullen voorblad","facturen-kosten","."],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":3,"defined_names":33,"comments":4,"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":"loonberek invullen promotor","index":0,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[50,0,50,5],[59,0,59,5],[3,1,3,2],[4,1,4,6],[17,0,17,5],[25,0,25,5],[34,0,34,5],[42,0,42,5]]}
["Sjabloon loonberekening"]
[]
[]
["Projectcode",{"$f":" 'In te vullen voorblad'!B13","v":" "}]
["Naam van het project",{"$f":" 'In te vullen voorblad'!B12","v":" "}]
["Per persoon: de naam - brutoloon  - de periode (maand en jaartal)  en het aantal halve dagen in te vullen. De looncode wordt automatisch opgezocht en moet niet zelf ingevuld worden."]
["Enkel de groene vakken invullen!"]
["Het donkergroene vak overnemen in het tabblad facturen "]
["Naam personeelslid","Voltijds brutoloon (5/5)","De overeenkomstige dagkost","Looncode","maand + jaartal","aantal halve dagen in die maand gewerkt aan het project","In te brengen personeelskost"]
[]
[null,null,{"$f":"+IF(B11=\"\",\"\",IF(B11<1988.54,175.21,IF(B11>=1988.54,VLOOKUP(B11,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C11=\"\",\"\",VLOOKUP(C11,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C11=\"\",\"\",(F11/2)*C11)","v":""}]
[null,null,{"$f":"+IF(B12=\"\",\"\",IF(B12<1988.54,175.21,IF(B12>=1988.54,VLOOKUP(B12,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C12=\"\",\"\",VLOOKUP(C12,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C12=\"\",\"\",(F12/2)*C12)","v":""}]
[null,null,{"$f":"+IF(B13=\"\",\"\",IF(B13<1988.54,175.21,IF(B13>=1988.54,VLOOKUP(B13,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C13=\"\",\"\",VLOOKUP(C13,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C13=\"\",\"\",(F13/2)*C13)","v":""}]
[null,null,{"$f":"+IF(B14=\"\",\"\",IF(B14<1988.54,175.21,IF(B14>=1988.54,VLOOKUP(B14,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C14=\"\",\"\",VLOOKUP(C14,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B15=\"\",\"\",IF(B15<1988.54,175.21,IF(B15>=1988.54,VLOOKUP(B15,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C15=\"\",\"\",VLOOKUP(C15,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B16=\"\",\"\",IF(B16<1988.54,175.21,IF(B16>=1988.54,VLOOKUP(B16,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C16=\"\",\"\",VLOOKUP(C16,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B17=\"\",\"\",IF(B17<1988.54,175.21,IF(B17>=1988.54,VLOOKUP(B17,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C17=\"\",\"\",VLOOKUP(C17,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G11:G17)","v":0}]
[null,null,{"$f":"+IF(B19=\"\",\"\",IF(B19<1988.54,175.21,IF(B19>=1988.54,VLOOKUP(B19,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C19=\"\",\"\",VLOOKUP(C19,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C19=\"\",\"\",(F19/2)*C19)","v":""}]
[null,null,{"$f":"+IF(B20=\"\",\"\",IF(B20<1988.54,175.21,IF(B20>=1988.54,VLOOKUP(B20,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C20=\"\",\"\",VLOOKUP(C20,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C20=\"\",\"\",(F20/2)*C20)","v":""}]
[null,null,{"$f":"+IF(B21=\"\",\"\",IF(B21<1988.54,175.21,IF(B21>=1988.54,VLOOKUP(B21,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C21=\"\",\"\",VLOOKUP(C21,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B22=\"\",\"\",IF(B22<1988.54,175.21,IF(B22>=1988.54,VLOOKUP(B22,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C22=\"\",\"\",VLOOKUP(C22,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B23=\"\",\"\",IF(B23<1988.54,175.21,IF(B23>=1988.54,VLOOKUP(B23,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C23=\"\",\"\",VLOOKUP(C23,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B24=\"\",\"\",IF(B24<1988.54,175.21,IF(B24>=1988.54,VLOOKUP(B24,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C24=\"\",\"\",VLOOKUP(C24,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B25=\"\",\"\",IF(B25<1988.54,175.21,IF(B25>=1988.54,VLOOKUP(B25,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C25=\"\",\"\",VLOOKUP(C25,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G19:G25)","v":0}]
[null,null,{"$f":"+IF(B27=\"\",\"\",IF(B27<1988.54,175.21,IF(B27>=1988.54,VLOOKUP(B27,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C27=\"\",\"\",VLOOKUP(C27,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C27=\"\",\"\",(F27/2)*C27)","v":""}]
[null,null,{"$f":"+IF(B28=\"\",\"\",IF(B28<1988.54,175.21,IF(B28>=1988.54,VLOOKUP(B28,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C28=\"\",\"\",VLOOKUP(C28,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B29=\"\",\"\",IF(B29<1988.54,175.21,IF(B29>=1988.54,VLOOKUP(B29,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C29=\"\",\"\",VLOOKUP(C29,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B30=\"\",\"\",IF(B30<1988.54,175.21,IF(B30>=1988.54,VLOOKUP(B30,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C30=\"\",\"\",VLOOKUP(C30,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B31=\"\",\"\",IF(B31<1988.54,175.21,IF(B31>=1988.54,VLOOKUP(B31,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C31=\"\",\"\",VLOOKUP(C31,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B32=\"\",\"\",IF(B32<1988.54,175.21,IF(B32>=1988.54,VLOOKUP(B32,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C32=\"\",\"\",VLOOKUP(C32,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B33=\"\",\"\",IF(B33<1988.54,175.21,IF(B33>=1988.54,VLOOKUP(B33,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C33=\"\",\"\",VLOOKUP(C33,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B34=\"\",\"\",IF(B34<1988.54,175.21,IF(B34>=1988.54,VLOOKUP(B34,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C34=\"\",\"\",VLOOKUP(C34,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G27:G34)","v":0}]
[null,null,{"$f":"+IF(B36=\"\",\"\",IF(B36<1988.54,175.21,IF(B36>=1988.54,VLOOKUP(B36,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C36=\"\",\"\",VLOOKUP(C36,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C36=\"\",\"\",(F36/2)*C36)","v":""}]
[null,null,{"$f":"+IF(B37=\"\",\"\",IF(B37<1988.54,175.21,IF(B37>=1988.54,VLOOKUP(B37,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C37=\"\",\"\",VLOOKUP(C37,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B38=\"\",\"\",IF(B38<1988.54,175.21,IF(B38>=1988.54,VLOOKUP(B38,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C38=\"\",\"\",VLOOKUP(C38,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B39=\"\",\"\",IF(B39<1988.54,175.21,IF(B39>=1988.54,VLOOKUP(B39,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C39=\"\",\"\",VLOOKUP(C39,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B40=\"\",\"\",IF(B40<1988.54,175.21,IF(B40>=1988.54,VLOOKUP(B40,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C40=\"\",\"\",VLOOKUP(C40,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B41=\"\",\"\",IF(B41<1988.54,175.21,IF(B41>=1988.54,VLOOKUP(B41,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C41=\"\",\"\",VLOOKUP(C41,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B42=\"\",\"\",IF(B42<1988.54,175.21,IF(B42>=1988.54,VLOOKUP(B42,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C42=\"\",\"\",VLOOKUP(C42,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G36:G42)","v":0}]
[null,null,{"$f":"+IF(B44=\"\",\"\",IF(B44<1988.54,175.21,IF(B44>=1988.54,VLOOKUP(B44,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C44=\"\",\"\",VLOOKUP(C44,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C44=\"\",\"\",(F44/2)*C44)","v":""}]
[null,null,{"$f":"+IF(B45=\"\",\"\",IF(B45<1988.54,175.21,IF(B45>=1988.54,VLOOKUP(B45,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C45=\"\",\"\",VLOOKUP(C45,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B46=\"\",\"\",IF(B46<1988.54,175.21,IF(B46>=1988.54,VLOOKUP(B46,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C46=\"\",\"\",VLOOKUP(C46,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B47=\"\",\"\",IF(B47<1988.54,175.21,IF(B47>=1988.54,VLOOKUP(B47,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C47=\"\",\"\",VLOOKUP(C47,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B48=\"\",\"\",IF(B48<1988.54,175.21,IF(B48>=1988.54,VLOOKUP(B48,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C48=\"\",\"\",VLOOKUP(C48,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B49=\"\",\"\",IF(B49<1988.54,175.21,IF(B49>=1988.54,VLOOKUP(B49,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C49=\"\",\"\",VLOOKUP(C49,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B50=\"\",\"\",IF(B50<1988.54,175.21,IF(B50>=1988.54,VLOOKUP(B50,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C50=\"\",\"\",VLOOKUP(C50,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G44:G50)","v":0}]
[null,null,{"$f":"+IF(B52=\"\",\"\",IF(B52<1988.54,175.21,IF(B52>=1988.54,VLOOKUP(B52,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C52=\"\",\"\",VLOOKUP(C52,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C52=\"\",\"\",(F52/2)*C52)","v":""}]
[null,null,{"$f":"+IF(B53=\"\",\"\",IF(B53<1988.54,175.21,IF(B53>=1988.54,VLOOKUP(B53,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C53=\"\",\"\",VLOOKUP(C53,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B54=\"\",\"\",IF(B54<1988.54,175.21,IF(B54>=1988.54,VLOOKUP(B54,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C54=\"\",\"\",VLOOKUP(C54,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B55=\"\",\"\",IF(B55<1988.54,175.21,IF(B55>=1988.54,VLOOKUP(B55,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C55=\"\",\"\",VLOOKUP(C55,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B56=\"\",\"\",IF(B56<1988.54,175.21,IF(B56>=1988.54,VLOOKUP(B56,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C56=\"\",\"\",VLOOKUP(C56,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B57=\"\",\"\",IF(B57<1988.54,175.21,IF(B57>=1988.54,VLOOKUP(B57,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C57=\"\",\"\",VLOOKUP(C57,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B58=\"\",\"\",IF(B58<1988.54,175.21,IF(B58>=1988.54,VLOOKUP(B58,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C58=\"\",\"\",VLOOKUP(C58,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B59=\"\",\"\",IF(B59<1988.54,175.21,IF(B59>=1988.54,VLOOKUP(B59,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C59=\"\",\"\",VLOOKUP(C59,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G52:G59)","v":0}]

{"sheet":"tijdsregist invullen promotor","index":1,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,4],[8,1,8,4]]}
["Sjabloon tijdsregistratie"]
[]
["Projectcode",{"$f":"'In te vullen voorblad'!B13","v":" "}]
["Naam van het project",{"$f":"'In te vullen voorblad'!B12","v":" "}]
[]
["Per personeelslid een sjabloon invullen."]
[]
["Enkel de groene velden invullen"]
["Naam personeelslid"]
[]
["Korte omschrijving werkzaamheden per halve dag invullen","dag","maand","jaartal","1= halve dag PDPO  0=niet PDPO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaal aantal halve dagen gewerkt voor deze  maand ",null,null,null,{"$f":"SUM(E13:E52)","v":0}]

{"sheet":"waarden lonen","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Standaard loontabel PDPO III te gebruiken vanaf 1 juli 2018"]
["Deze code gebruiken om in te vullen",null,"om te vergelijken met de loonfiche",null,null,null,null,null,null,null,"Kosten om te gebruiken bij declaratie (verlof, ziekte reeds verrekend in de dagkost)"]
["Loon-code","Wedde","Bruto maandloon","Vakantie-geld ","Eindejaars-premie","RSZ werkgever","Verzekering AO","Vervoer-kosten (weg - werk)","Maaltijd-cheques","Jaarkost","Dagkost","Loon-code"]
["A001",23862.46,1988.54,1649.95,1502.88,7771.9401760000001,150.434642365,615.66,1241.1000000000001,36794.424818364998,175.21,"A001"]
["A002",26388.67,{"$f":"B5/12","v":2199.0558333333333},1820.24,1657.99,8593.4966239999994,166.31383264999999,615.66,1241.1000000000001,40483.47045665,192.78,"A002"]
["A003",27771.26,2314.2716666666665,1934.15,1761.74,9048.9112000000005,175.224824775,615.66,1241.1000000000001,42548.046024775009,202.61,"A003"]
["A004",28471.09,{"$f":"B7/12","v":2372.5908333333332},1960.62,1785.85,9270.7264159999995,179.40348285999997,615.66,1241.1000000000001,43524.449898859995,207.26,"A004"]
["A005",29341.61,2445.1341666666667,2019.3,1839.3,9553.8308240000006,184.87536938499997,615.66,1241.1000000000001,44795.676193384999,213.31,"A005"]
["A006",31082.65,2590.2208333333333,2136.66,1946.2,10120.039639999999,195.81914243499995,615.66,1241.1000000000001,47338.128782435,225.42,"A006"]
["A007",32311.62,2692.6349999999998,2178.09,1983.93,10508.156519999999,203.10346433999999,615.66,1241.1000000000001,49041.659984339996,233.53,"A007"]
["A008",33608.86,2800.7383333333332,2265.5300000000002,2063.58,10930.035616000001,211.25758594499999,615.66,1241.1000000000001,50936.023201945005,242.55,"A008"]
["A009",36305.760000000002,3025.48,2447.33,2229.17,11807.102552,228.20971481000001,615.66,1241.1000000000001,54874.332266810008,261.31,"A009"]
["A010",37603.01,3133.584166666667,2534.77,2308.8200000000002,12228.984712000001,236.36389209999999,615.66,1241.1000000000001,56768.7086041,270.33,"A010"]
["A011",38456.46,3204.7049999999999,2592.3000000000002,2123.7600000000002,12433.779408,240.40617762000002,615.66,1241.1000000000001,57703.465585620012,274.77999999999997,"A011"]
["A012",39736.629999999997,3311.3858333333333,2678.6,2194.46,12847.685975999999,248.40905876499997,615.66,1241.1000000000001,59562.545034764997,283.63,"A012"]
["A013",41016.81,3418.0674999999997,2764.89,2265.15,13261.592543999999,256.41188422499999,615.66,1241.1000000000001,61421.614428225002,292.48,"A013"]
["A014",42211.64,3517.6366666666668,2845.43,2331.14,13647.907792,263.88124738499999,615.66,1241.1000000000001,63156.759039384997,300.75,"A014"]
["A015",44857.33,3738.1108333333336,3023.78,2477.25,14503.315312000001,280.42052766,615.66,1241.1000000000001,66998.855839659998,319.04000000000002,"A015"]
["A016",47417.68,3951.4733333333334,3196.37,2618.64,15331.128447999999,296.42623426500001,615.66,1241.1000000000001,70717.004682265018,336.75,"A016"]
["A017",49978.03,4164.8358333333335,3368.96,2760.04,16158.944648000001,312.43199655499996,615.66,1241.1000000000001,74435.166644555007,354.45,"A017"]
["A018",52453.04,4371.086666666667,3535.79,2896.72,16959.166464000002,327.90418517500001,615.66,1241.1000000000001,78029.380649175,371.57,"A018"]
["A019",53391.83,4449.3191666666671,3599.08,2948.56,17262.695496,333.77293869499999,615.66,1241.1000000000001,79392.698434695005,378.06,"A019"]
["A020",55098.73,4591.5608333333339,3714.14,3042.83,17814.573984000002,344.44346545000002,615.66,1241.1000000000001,81871.477449450002,389.86,"A020"]
["A021",56805.63,4733.8024999999998,3829.2,3137.09,18366.449408,355.11393651999998,615.66,1241.1000000000001,84350.243344520015,401.67,"A021"]
["A022",57232.36,4769.3633333333337,3857.96,3160.66,18504.421328,357.78158212999995,615.66,1241.1000000000001,84969.942910130005,404.62,"A022"]
["A023",59365.98,4947.165,4001.79,3278.49,19194.265608000002,371.11969881000005,615.66,1241.1000000000001,88068.405306810018,419.37,"A023"]
["A024",61926.33,5160.5275000000001,4174.38,3419.88,20022.078743999999,387.12540541500005,615.66,1241.1000000000001,91786.554149415024,437.08,"A024"]
["A025",64486.68,5373.89,4346.97,3561.28,20849.894944000003,403.13116770499994,615.66,1241.1000000000001,95504.716111704998,454.78,"A025"]
["A026",67047.03,5587.2524999999996,4519.5600000000004,3702.67,21677.70808,419.13687430999994,615.66,1241.1000000000001,99222.864954310004,472.49,"A026"]
["A027",69607.38,5800.6150000000007,4692.1499999999996,3844.07,22505.524280000005,435.1426366,615.66,1241.1000000000001,102941.02691660002,490.2,"A027"]

{"sheet":"voorbeeld tijdsreg","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,4],[8,1,8,4]]}
["Sjabloon tijdsregistratie"]
[]
["Projectcode",{"$f":" 'In te vullen voorblad'!B13","v":" "}]
["Naam van het project",{"$f":" 'In te vullen voorblad'!B12","v":" "}]
[]
["Per personeelslid een sjabloon invullen."]
[]
["Enkel de groene velden invullen"]
["Naam personeelslid","Mevr. Christine Janssens"]
[]
["Korte omschrijving werkzaamheden per halve dag invullen","dag","maand","jaartal","1= halve dag PDPO  0=niet PDPO"]
[]
["leveranciers zoeken voor de restauratie",2,"februari",2015,1]
["bezoek aan de te restaureren bakoven",2,"februari",2015,1]
["verlof",3,"februari",2015,0]
["verlof",3,"februari",2015,0]
["niet PDPO ",4,"februari",2015,0]
["niet PDPO ",4,"februari",2015,0]
["verminderde prestaties",5,"februari",2015,0]
["verminderde prestaties",5,"februari",2015,0]
["PDPO project - leveranciers zoeken restauratie",6,"februari",2015,1]
["niet PDPO ",6,"februari",2015,0]
["niet PDPO ",9,"februari",2015,0]
["niet PDPO ",9,"februari",2015,0]
["verlof",10,"februari",2015,0]
["verlof",10,"februari",2015,0]
["verminderde prestaties",11,"februari",2015,0]
["verminderde prestaties",11,"februari",2015,0]
["PDPO project - contact met leveranciers voor de restauratie",12,"februari",2015,1]
["PDPO project - contact met leveranciers voor de restauratie",12,"februari",2015,1]
["PDPO project - contact met leveranciers voor de restauratie",13,"februari",2015,1]
["PDPO project - contact met leveranciers voor de restauratie",13,"februari",2015,1]
["PDPO project - voorbereiding restauratie",16,"februari",2015,1]
["PDPO project - voorbereiding restauratie",16,"februari",2015,1]
["PDPO project - voorbereiding restauratie",17,"februari",2015,1]
["niet PDPO ",17,"februari",2015,0]
["verminderde prestaties",18,"februari",2015,0]
["verminderde prestaties",18,"februari",2015,0]
["niet PDPO ",19,"februari",2015,0]
["niet PDPO ",19,"februari",2015,0]
["niet PDPO ",20,"februari",2015,0]
["PDPO project - voorbereiding restauratie bakoven",20,"februari",2015,1]
["PDPO project - voorbereiding restauratie",23,"februari",2015,1]
["PDPO project - voorbereiding restauratie",23,"februari",2015,1]
["niet PDPO ",24,"februari",2015,0]
["niet PDPO ",24,"februari",2015,0]
["verminderde prestaties",25,"februari",2015,0]
["verminderde prestaties",25,"februari",2015,0]
["niet PDPO ",26,"februari",2015,0]
["niet PDPO ",26,"februari",2015,0]
["Ziekte",27,"februari",2015,0]
["Ziekte",27,"februari",2015,0]
["Totaal aantal halve dagen gewerkt voor deze  maand ",null,null,null,{"$f":"SUM(E13:E52)","v":13}]

{"sheet":"Voorbeeld loonberekening","index":4,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[42,0,42,5],[50,0,50,5],[59,0,59,5],[3,1,3,2],[4,1,4,6],[17,0,17,5],[25,0,25,5],[34,0,34,5]]}
["Sjabloon loonberekening"]
[]
[]
["Projectcode",{"$f":" 'In te vullen voorblad'!B13","v":" "}]
["Naam van het project",{"$f":" 'In te vullen voorblad'!B12","v":" "}]
["Per persoon: de naam - brutoloon  - de periode (maand en jaartal)  en het aantal halve dagen in te vullen. De looncode wordt automatisch opgezocht en moet niet zelf ingevuld worden."]
["Enkel de groene vakken invullen!"]
["Het donkergroene vak overnemen in het tabblad facturen "]
["Naam personeelslid","Voltijds brutoloon (5/5)","De overeenkomstige dagkost","Looncode","maand + jaartal","aantal halve dagen in die maand gewerkt aan het project","In te brengen personeelskost"]
[]
["Christine Janssens",3250,{"$f":"+IF(B11=\"\",\"\",IF(B11<1988.54,175.21,IF(B11>=1988.54,VLOOKUP(B11,'waarden lonen'!C:K,9,TRUE))))","v":274.77999999999997},{"$f":"+IF(C11=\"\",\"\",VLOOKUP(C11,'waarden lonen'!K:L,2,FALSE))","v":"A011"},"2015-02-01",13,{"$f":"+IF(C11=\"\",\"\",(F11/2)*C11)","v":1786.0699999999997}]
[null,null,{"$f":"+IF(B12=\"\",\"\",IF(B12<1988.54,175.21,IF(B12>=1988.54,VLOOKUP(B12,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C12=\"\",\"\",VLOOKUP(C12,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C12=\"\",\"\",(F12/2)*C12)","v":""}]
[null,null,{"$f":"+IF(B13=\"\",\"\",IF(B13<1988.54,175.21,IF(B13>=1988.54,VLOOKUP(B13,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C13=\"\",\"\",VLOOKUP(C13,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C13=\"\",\"\",(F13/2)*C13)","v":""}]
[null,null,{"$f":"+IF(B14=\"\",\"\",IF(B14<1988.54,175.21,IF(B14>=1988.54,VLOOKUP(B14,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C14=\"\",\"\",VLOOKUP(C14,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B15=\"\",\"\",IF(B15<1988.54,175.21,IF(B15>=1988.54,VLOOKUP(B15,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C15=\"\",\"\",VLOOKUP(C15,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B16=\"\",\"\",IF(B16<1988.54,175.21,IF(B16>=1988.54,VLOOKUP(B16,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C16=\"\",\"\",VLOOKUP(C16,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B17=\"\",\"\",IF(B17<1988.54,175.21,IF(B17>=1988.54,VLOOKUP(B17,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C17=\"\",\"\",VLOOKUP(C17,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G11:G17)","v":1786.0699999999997}]
[null,null,{"$f":"+IF(B19=\"\",\"\",IF(B19<1988.54,175.21,IF(B19>=1988.54,VLOOKUP(B19,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C19=\"\",\"\",VLOOKUP(C19,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C19=\"\",\"\",(F19/2)*C19)","v":""}]
[null,null,{"$f":"+IF(B20=\"\",\"\",IF(B20<1988.54,175.21,IF(B20>=1988.54,VLOOKUP(B20,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C20=\"\",\"\",VLOOKUP(C20,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C20=\"\",\"\",(F20/2)*C20)","v":""}]
[null,null,{"$f":"+IF(B21=\"\",\"\",IF(B21<1988.54,175.21,IF(B21>=1988.54,VLOOKUP(B21,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C21=\"\",\"\",VLOOKUP(C21,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B22=\"\",\"\",IF(B22<1988.54,175.21,IF(B22>=1988.54,VLOOKUP(B22,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C22=\"\",\"\",VLOOKUP(C22,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B23=\"\",\"\",IF(B23<1988.54,175.21,IF(B23>=1988.54,VLOOKUP(B23,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C23=\"\",\"\",VLOOKUP(C23,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B24=\"\",\"\",IF(B24<1988.54,175.21,IF(B24>=1988.54,VLOOKUP(B24,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C24=\"\",\"\",VLOOKUP(C24,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B25=\"\",\"\",IF(B25<1988.54,175.21,IF(B25>=1988.54,VLOOKUP(B25,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C25=\"\",\"\",VLOOKUP(C25,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G19:G25)","v":0}]
[null,null,{"$f":"+IF(B27=\"\",\"\",IF(B27<1988.54,175.21,IF(B27>=1988.54,VLOOKUP(B27,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C27=\"\",\"\",VLOOKUP(C27,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C27=\"\",\"\",(F27/2)*C27)","v":""}]
[null,null,{"$f":"+IF(B28=\"\",\"\",IF(B28<1988.54,175.21,IF(B28>=1988.54,VLOOKUP(B28,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C28=\"\",\"\",VLOOKUP(C28,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B29=\"\",\"\",IF(B29<1988.54,175.21,IF(B29>=1988.54,VLOOKUP(B29,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C29=\"\",\"\",VLOOKUP(C29,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B30=\"\",\"\",IF(B30<1988.54,175.21,IF(B30>=1988.54,VLOOKUP(B30,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C30=\"\",\"\",VLOOKUP(C30,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B31=\"\",\"\",IF(B31<1988.54,175.21,IF(B31>=1988.54,VLOOKUP(B31,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C31=\"\",\"\",VLOOKUP(C31,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B32=\"\",\"\",IF(B32<1988.54,175.21,IF(B32>=1988.54,VLOOKUP(B32,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C32=\"\",\"\",VLOOKUP(C32,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B33=\"\",\"\",IF(B33<1988.54,175.21,IF(B33>=1988.54,VLOOKUP(B33,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C33=\"\",\"\",VLOOKUP(C33,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B34=\"\",\"\",IF(B34<1988.54,175.21,IF(B34>=1988.54,VLOOKUP(B34,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C34=\"\",\"\",VLOOKUP(C34,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G27:G34)","v":0}]
[null,null,{"$f":"+IF(B36=\"\",\"\",IF(B36<1988.54,175.21,IF(B36>=1988.54,VLOOKUP(B36,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C36=\"\",\"\",VLOOKUP(C36,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C36=\"\",\"\",(F36/2)*C36)","v":""}]
[null,null,{"$f":"+IF(B37=\"\",\"\",IF(B37<1988.54,175.21,IF(B37>=1988.54,VLOOKUP(B37,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C37=\"\",\"\",VLOOKUP(C37,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B38=\"\",\"\",IF(B38<1988.54,175.21,IF(B38>=1988.54,VLOOKUP(B38,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C38=\"\",\"\",VLOOKUP(C38,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B39=\"\",\"\",IF(B39<1988.54,175.21,IF(B39>=1988.54,VLOOKUP(B39,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C39=\"\",\"\",VLOOKUP(C39,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B40=\"\",\"\",IF(B40<1988.54,175.21,IF(B40>=1988.54,VLOOKUP(B40,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C40=\"\",\"\",VLOOKUP(C40,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B41=\"\",\"\",IF(B41<1988.54,175.21,IF(B41>=1988.54,VLOOKUP(B41,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C41=\"\",\"\",VLOOKUP(C41,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B42=\"\",\"\",IF(B42<1988.54,175.21,IF(B42>=1988.54,VLOOKUP(B42,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C42=\"\",\"\",VLOOKUP(C42,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G36:G42)","v":0}]
[null,null,{"$f":"+IF(B44=\"\",\"\",IF(B44<1988.54,175.21,IF(B44>=1988.54,VLOOKUP(B44,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C44=\"\",\"\",VLOOKUP(C44,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C44=\"\",\"\",(F44/2)*C44)","v":""}]
[null,null,{"$f":"+IF(B45=\"\",\"\",IF(B45<1988.54,175.21,IF(B45>=1988.54,VLOOKUP(B45,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C45=\"\",\"\",VLOOKUP(C45,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B46=\"\",\"\",IF(B46<1988.54,175.21,IF(B46>=1988.54,VLOOKUP(B46,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C46=\"\",\"\",VLOOKUP(C46,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B47=\"\",\"\",IF(B47<1988.54,175.21,IF(B47>=1988.54,VLOOKUP(B47,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C47=\"\",\"\",VLOOKUP(C47,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B48=\"\",\"\",IF(B48<1988.54,175.21,IF(B48>=1988.54,VLOOKUP(B48,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C48=\"\",\"\",VLOOKUP(C48,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B49=\"\",\"\",IF(B49<1988.54,175.21,IF(B49>=1988.54,VLOOKUP(B49,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C49=\"\",\"\",VLOOKUP(C49,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B50=\"\",\"\",IF(B50<1988.54,175.21,IF(B50>=1988.54,VLOOKUP(B50,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C50=\"\",\"\",VLOOKUP(C50,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G44:G50)","v":0}]
[null,null,{"$f":"+IF(B52=\"\",\"\",IF(B52<1988.54,175.21,IF(B52>=1988.54,VLOOKUP(B52,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C52=\"\",\"\",VLOOKUP(C52,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,{"$f":"+IF(C52=\"\",\"\",(F52/2)*C52)","v":""}]
[null,null,{"$f":"+IF(B53=\"\",\"\",IF(B53<1988.54,175.21,IF(B53>=1988.54,VLOOKUP(B53,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C53=\"\",\"\",VLOOKUP(C53,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B54=\"\",\"\",IF(B54<1988.54,175.21,IF(B54>=1988.54,VLOOKUP(B54,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C54=\"\",\"\",VLOOKUP(C54,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B55=\"\",\"\",IF(B55<1988.54,175.21,IF(B55>=1988.54,VLOOKUP(B55,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C55=\"\",\"\",VLOOKUP(C55,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B56=\"\",\"\",IF(B56<1988.54,175.21,IF(B56>=1988.54,VLOOKUP(B56,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C56=\"\",\"\",VLOOKUP(C56,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B57=\"\",\"\",IF(B57<1988.54,175.21,IF(B57>=1988.54,VLOOKUP(B57,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C57=\"\",\"\",VLOOKUP(C57,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B58=\"\",\"\",IF(B58<1988.54,175.21,IF(B58>=1988.54,VLOOKUP(B58,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C58=\"\",\"\",VLOOKUP(C58,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
[null,null,{"$f":"+IF(B59=\"\",\"\",IF(B59<1988.54,175.21,IF(B59>=1988.54,VLOOKUP(B59,'waarden lonen'!C:K,9,TRUE))))","v":""},{"$f":"+IF(C59=\"\",\"\",VLOOKUP(C59,'waarden lonen'!K:L,2,FALSE))","v":""},null,null,""]
["Totale loonkost - het totaal bedrag per persoon overnemen in de overzichtslijst met facturen / kosten",null,null,null,null,null,{"$f":"SUM(G52:G59)","v":0}]

{"sheet":"In te vullen voorblad","index":5,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,2,26,3],[18,2,19,3]]}
[]
[]
[]
[]
[]
[]
["Opgelet","Gelieve dit voorblad in te vullen identiek zoals in het plattelandsloket"]
["Datum aanvraag:","2020-01-15"]
[]
["Gegevens project"]
[]
["Projectnaam:"," "]
["Projectcode:"," "]
["Budgetjaar: ","……………………………………"]
["Overhead% bij personeelskosten",10,"Opgelet: overheadpercentage moet exact gelijk zijn aan het goedgekeurde %"]
[]
["Gegevens projectpromotor"]
[]
["Naam:","XXXXX","Opgelet: de schrijfwijze van de naam van de promotor moet exact overeenkomen met de schrijfwijze in het e-loket"]
["Adres:","……………………………………"]
["Contactpersoon:","……………………………………"]
["Telefoon:","……………………………………"]
["Email:","……………………………………"]
["Rekeningnummer:","……………………………………"]
[]
["(Indien van toepassing) Naam copromotoren invullen",null,"Opgelet: de schrijfwijze van de namen van de copromotoren moet exact overeenkomen met de schrijfwijze in het e-loket"]
[]
["Copromotor 1","……………………………………"]
["Copromotor 2","……………………………………"]
["Copromotor 3","……………………………………"]
["Copromotor 4","……………………………………"]
["Copromotor 5","……………………………………"]
[]
[]
["Ondergetekende, (naam)","……………………………………","projectpromotor van project  (naam project) …………………………....."]
["verklaart hierbij dat bijgevoegde facturen betrekking hebben op projectcode OVL17/…………………….."]
["en dat de aangevraagde subsidie het maximum van de goedgekeurde subsidie niet overschrijdt."]
["De aangevraagde Europese, Vlaamse en provinciale cofinanciering mag uitbetaald worden."]
["Datum"]
[]
["…………………………………………………………."]

{"sheet":"facturen-kosten","index":6,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[33,2,33,7],[0,3,0,5],[1,5,8,8]]}
[null,"Projectnaam",null,{"$f":" 'In te vullen voorblad'!B12","v":" "},null,null,null,null,null,"Rubrieken","ingediende kost","Promotor/ copromotor",null,"ingediende kost"]
[null,"Projectpromotor",null,{"$f":"'In te vullen voorblad'!B19","v":"XXXXX"},null,"Toelichting bij het gebruik van de knop 'Facturen Json (bulk)': Door het klikken op deze knop worden de gegevens op dit blad gekopieerd (rij 13 tot einde van tabel). Deze gegevens kunnen met behulp van de toetsencombinatie CTRL+V geplakt worden in het pop-upvenster in het e-loket (bij gebruik van de knop 'Facturen Json (bulk)' in het loket). \nOpgelet: Hiermee worden geen andere tabbladen of gegevens van dit bestand gekopieerd naar het loket. Als de knop niet werkt staat er wellicht bovenaan een opmerking i.v.m. 'inhoud inschakelen' (deze moet eerst ingeschakeld worden) of werkt het niet in deze Excelversie (facturen kunnen dan individueel ingegeven worden in het loket).",null,null,null,{"$f":"'.'!C3","v":"Investeringskosten"},{"$f":"SUMIF(J:J,J2,I:I)","v":0},{"$f":"'In te vullen voorblad'!B19","v":"XXXXX"},null,{"$f":"SUMIF(K:K,L2,I:I)","v":0}]
[null,"Projectnummer",null,{"$f":"'In te vullen voorblad'!B13","v":" "},null,null,null,null,null,{"$f":"'.'!C4","v":"Personeelskosten"},0,{"$f":"'In te vullen voorblad'!B28","v":"……………………………………"},null,0]
[null,"Budgetjaar",null,{"$f":" 'In te vullen voorblad'!B14","v":"……………………………………"},null,null,null,null,null,{"$f":"'.'!C5","v":"Werkingskosten"},0,{"$f":"'In te vullen voorblad'!B29","v":"……………………………………"},null,0]
[null,"Overhead%",null,{"$f":"'In te vullen voorblad'!B15","v":10},null,null,null,null,null,{"$f":"'.'!C6","v":"Externe prestaties"},0,{"$f":"'In te vullen voorblad'!B30","v":"……………………………………"},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"'.'!C7","v":"Bijdrage in natura"},0,{"$f":"'In te vullen voorblad'!B31","v":"……………………………………"},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"'.'!C8","v":"Inkomsten"},0,{"$f":"'In te vullen voorblad'!B32","v":"……………………………………"},null,0]
[]
[null,null,null,null,null,null,null,null,null,"Totaal",{"$f":"SUM(K2+K3+K4+K5+K6+K7)","v":0}]
[]
["Volgnr ","Boekhoud- kundig nummer van de factuur","Naam leverancier /                                                                       naam personeelslid","Onderwerp van de uitgave                                        ","FactuurDatum / Periode start","Periode einddatum","TotaalBedrag","Percentage dat het bedrag meetelt","Aangevraagd project-bedrag","rubriek ( in te vullen door een rubriek te selecteren , niet manueel intypen!!)","Aan wie is de factuur gericht promotor of copromotoren? (naam (co-)promotor selecteren of blanco indien promotor)","% Cofinanciering (max 65%)","totale cofinanc (totale overheidssteun)","Overhead Bedrag"]
["VolgNummer","BoekhoudkundigNummer","Leverancier","Onderwerp","FactuurPeriodeStartString","FactuurPeriodeEindString","TotaalBedrag","MeetelPercentage","AangevraagdProjectbedrag","KostenCategorie","Promotor","CofinancieringPercentage","TotaleCofinanciering","OverheadBedrag"]
[null,null,null,null,null,null,null,null,{"$f":"G13*H13","v":0},null,null,null,{"$f":"I13*L13","v":0},{"$f":"IF(J13=\"Personeelskosten\",M13*D$5%,0)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"I14*L14","v":0},{"$f":"IF(J14=\"Personeelskosten\",M14*D$5%,0)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"I17*L17","v":0},{"$f":"IF(J17=\"Personeelskosten\",M17*D$5%,0)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"I19*L19","v":0},{"$f":"IF(J19=\"Personeelskosten\",M19*D$5%,0)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"I23*L23","v":0},{"$f":"IF(J23=\"Personeelskosten\",M23*D$5%,0)","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
["Totaal",null,null,null,null,null,{"$f":"SUM(G13:G32)","v":0},null,{"$f":"SUM(I13:I32)","v":0},null,null,null,{"$f":"SUM(M13:M32)","v":0},{"$f":"SUM(N13:N32)","v":0}]

{"sheet":".","index":7,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"json"]
[null,null,"Investeringskosten",null,"{"]
[null,null,"Personeelskosten",null,"\""]
[null,null,"Werkingskosten",null,":"]
[null,null,"Externe prestaties",null,"}"]
[null,null,"Bijdrage in natura",null,","]
[null,null,"Inkomsten",null,"["]
[null,null,null,null,"]"]
[]
[]
[]
[]
[]
[null,null,{"$f":"'In te vullen voorblad'!B19","v":"XXXXX"}]
[null,null,{"$f":"'In te vullen voorblad'!B28","v":"……………………………………"}]
[null,null,{"$f":"'In te vullen voorblad'!B29","v":"……………………………………"}]
[null,null,{"$f":"'In te vullen voorblad'!B30","v":"……………………………………"}]
[null,null,{"$f":"'In te vullen voorblad'!B31","v":"……………………………………"}]
[null,null,{"$f":"'In te vullen voorblad'!B32","v":"……………………………………"}]
[]
[]
[]
[]
[]
[null,null,null,null,"{\"VolgNummer\":\"1\",\"\":\"\"\"Leverancier\":\"\"\"Onderwerp\":\"A007\"\"Factuurdatum\":\"jan-jun 2018\"\"TotaalBedrag\":\"137,772\"\"MeetelPercentage\":\"1\"\"AangevraagdProjectbedrag\":\"137,772\"\"KostenCategorie\":\"Personeelskost\"\"Promotor\":\"Plattelandscentrum Meetjesland vzw\"\"CofinancieringPercentage\":\"0,65\"\"TotaleCofinanciering\":\"89,5518\"}"]