{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Projecttracker","Instellen"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Projecttracker","index":0,"n_rows":13,"n_cols":15,"rows_kept":13}
[null,"Projecttracker"]
[null,null,"Percentage meer/minder waarvoor vlag moet worden toegevoegd: ",{"v":0.25,"d":"25%"}]
[]
[null,"Project","Categorie","Toegewezen aan","Geschat\nStarten","Geschat \nVoltooien","Geschat werk (in uren)","Geschatte duur (in dagen)","Werkelijk \nStarten","Werkelijk\nVoltooien","Vlagpictogram voor meer/minder werkelijke hoeveelheid werk (in uren)","Werkelijke hoeveelheid werk (in uren)","Vlagpictogram voor meer/minder werkelijke duur (in dagen)","Werkelijke duur (in dagen)","Notities"]
[null,"Project 1","Categorie 1","Werknemer 1",{"$f":"TODAY()-65","v":"2023-02-05"},{"$f":"TODAY()-5","v":"2023-04-06"},210,{"$f":"IF(COUNTA(Projecttracker!$E5,Projecttracker!$F5)<>2,\"\",DAYS360(Projecttracker!$E5,Projecttracker!$F5,FALSE))","v":61},{"$f":"TODAY()-65","v":"2023-02-05"},{"$f":"TODAY()","v":"2023-04-11"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":1},300,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I5,Projecttracker!$J5)<>2,\"\",DAYS360(Projecttracker!$I5,Projecttracker!$J5,FALSE))","v":66}]
[null,"Project 2","Categorie 2","Werknemer 4",{"$f":"TODAY()-41","v":"2023-03-01"},{"$f":"TODAY()-10","v":"2023-04-01"},400,{"$f":"IF(COUNTA(Projecttracker!$E6,Projecttracker!$F6)<>2,\"\",DAYS360(Projecttracker!$E6,Projecttracker!$F6,FALSE))","v":30},{"$f":"TODAY()-41","v":"2023-03-01"},{"$f":"TODAY()-7","v":"2023-04-04"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},390,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I6,Projecttracker!$J6)<>2,\"\",DAYS360(Projecttracker!$I6,Projecttracker!$J6,FALSE))","v":33}]
[null,"Project 3","Categorie 1","Werknemer 2",{"$f":"TODAY()-100","v":"2023-01-01"},{"$f":"TODAY()-40","v":"2023-03-02"},500,{"$f":"IF(COUNTA(Projecttracker!$E7,Projecttracker!$F7)<>2,\"\",DAYS360(Projecttracker!$E7,Projecttracker!$F7,FALSE))","v":61},{"$f":"TODAY()-100","v":"2023-01-01"},{"$f":"TODAY()-27","v":"2023-03-15"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},500,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I7,Projecttracker!$J7)<>2,\"\",DAYS360(Projecttracker!$I7,Projecttracker!$J7,FALSE))","v":74}]
[null,"Project 4","Categorie 2","Werknemer 3",{"$f":"TODAY()-90","v":"2023-01-11"},{"$f":"TODAY()-80","v":"2023-01-21"},250,{"$f":"IF(COUNTA(Projecttracker!$E8,Projecttracker!$F8)<>2,\"\",DAYS360(Projecttracker!$E8,Projecttracker!$F8,FALSE))","v":10},{"$f":"TODAY()-90","v":"2023-01-11"},{"$f":"TODAY()-71","v":"2023-01-30"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},276,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(Projecttracker!$I8,Projecttracker!$J8)<>2,\"\",DAYS360(Projecttracker!$I8,Projecttracker!$J8,FALSE))","v":19}]
[null,"Project 5","Categorie 3","Werknemer 2",{"$f":"TODAY()-90","v":"2023-01-11"},{"$f":"TODAY()-50","v":"2023-02-20"},300,{"$f":"IF(COUNTA(Projecttracker!$E9,Projecttracker!$F9)<>2,\"\",DAYS360(Projecttracker!$E9,Projecttracker!$F9,FALSE))","v":39},{"$f":"TODAY()-90","v":"2023-01-11"},{"$f":"TODAY()-44","v":"2023-02-26"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},310,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I9,Projecttracker!$J9)<>2,\"\",DAYS360(Projecttracker!$I9,Projecttracker!$J9,FALSE))","v":45}]
[null,"Project 6","Categorie 4","Werknemer 4",{"$f":"TODAY()-60","v":"2023-02-10"},{"$f":"TODAY()-50","v":"2023-02-20"},500,{"$f":"IF(COUNTA(Projecttracker!$E10,Projecttracker!$F10)<>2,\"\",DAYS360(Projecttracker!$E10,Projecttracker!$F10,FALSE))","v":10},{"$f":"TODAY()-60","v":"2023-02-10"},{"$f":"TODAY()-45","v":"2023-02-25"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},510,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(Projecttracker!$I10,Projecttracker!$J10)<>2,\"\",DAYS360(Projecttracker!$I10,Projecttracker!$J10,FALSE))","v":15}]
[null,"Project 7","Categorie 5","Werknemer 1",{"$f":"TODAY()-44","v":"2023-02-26"},{"$f":"TODAY()-20","v":"2023-03-22"},750,{"$f":"IF(COUNTA(Projecttracker!$E11,Projecttracker!$F11)<>2,\"\",DAYS360(Projecttracker!$E11,Projecttracker!$F11,FALSE))","v":26},{"$f":"TODAY()-44","v":"2023-02-26"},{"$f":"TODAY()-15","v":"2023-03-27"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},790,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I11,Projecttracker!$J11)<>2,\"\",DAYS360(Projecttracker!$I11,Projecttracker!$J11,FALSE))","v":31}]
[null,"Project 8","Categorie 2","Werknemer 1",{"$f":"TODAY()-39","v":"2023-03-03"},{"$f":"TODAY()","v":"2023-04-11"},450,{"$f":"IF(COUNTA(Projecttracker!$E12,Projecttracker!$F12)<>2,\"\",DAYS360(Projecttracker!$E12,Projecttracker!$F12,FALSE))","v":38},{"$f":"TODAY()-45","v":"2023-02-25"},{"$f":"TODAY()-5","v":"2023-04-06"},{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},430,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(Projecttracker!$I12,Projecttracker!$J12)<>2,\"\",DAYS360(Projecttracker!$I12,Projecttracker!$J12,FALSE))","v":41}]
[null,"Project 9","Categorie 4","Werknemer 1","2016-02-05","2016-06-09",250,{"$f":"IF(COUNTA(Projecttracker!$E13,Projecttracker!$F13)<>2,\"\",DAYS360(Projecttracker!$E13,Projecttracker!$F13,FALSE))","v":124},"2016-03-05","2016-05-05",{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke hoeveelheid werk (in uren)]]-Projecttracker[[#This Row],[Geschat werk (in uren)]])/Projecttracker[[#This Row],[Geschat werk (in uren)]])>Vlagpercentage,1,0)),\"\")","v":0},200,{"$f":"IFERROR(IF(Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]=0,\"\",IF(ABS((Projecttracker[[#This Row],[Werkelijke duur (in dagen)]]-Projecttracker[[#This Row],[Geschatte duur (in dagen)]])/Projecttracker[[#This Row],[Geschatte duur (in dagen)]])>Vlagpercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(Projecttracker!$I13,Projecttracker!$J13)<>2,\"\",DAYS360(Projecttracker!$I13,Projecttracker!$J13,FALSE))","v":60}]

{"sheet":"Instellen","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[null,"Instellen"]
[]
[]
[null,"Categorienaam","Naam werknemer"]
[null,"Categorie 1","Werknemer 1"]
[null,"Categorie 2","Werknemer 2"]
[null,"Categorie 3","Werknemer 3"]
[null,"Categorie 4","Werknemer 4"]
[null,"Categorie 5","Werknemer 5"]
[null,"Categorie 6","Werknemer 6"]