{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Trackingformulier werkorders"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Trackingformulier werkorders","index":0,"n_rows":6,"n_cols":10,"rows_kept":6}
[null,"Werkordertracker",{"$nulls":7}," "]
[]
[null,"Werkordernummer #","Beschrijving","Aangevraagd door","Toegewezen aan","Begindatum","Einddatum","% voltooid","Status"]
[null,"TR45878","Beschikbare apparatuur","Tomas Kobetic","Terry Adams",{"$f":"TODAY()-120","v":"2012-04-29"},{"$f":"TODAY()-1","v":"2012-08-26"},{"v":0.75,"d":"75%"},{"$f":"IF(WerkOrders[[#This Row],[% voltooid]]=1,2,IF(ISBLANK(WerkOrders[[#This Row],[Einddatum]]),\"\",IF(AND(TODAY()>WerkOrders[[#This Row],[Einddatum]],WerkOrders[[#This Row],[% voltooid]]<>1),0,1)))","v":0}]
[null,"YT9876","Nieuwe klantendatabase samenstellen","Yair Shmuel","Hao Chen",{"$f":"TODAY()-30","v":"2012-07-28"},{"$f":"TODAY()+15","v":"2012-09-11"},{"v":1,"d":"100%"},{"$f":"IF(WerkOrders[[#This Row],[% voltooid]]=1,2,IF(ISBLANK(WerkOrders[[#This Row],[Einddatum]]),\"\",IF(AND(TODAY()>WerkOrders[[#This Row],[Einddatum]],WerkOrders[[#This Row],[% voltooid]]<>1),0,1)))","v":2}]
[null,"TR7865","Upgrade van desktopcomputer uitvoeren","Yair Shmuel","Terry Adams",{"$f":"TODAY()","v":"2012-08-27"},{"$f":"WerkOrders[[#This Row],[Begindatum]]+30","v":"2012-09-26"},{"v":0,"d":"0%"},{"$f":"IF(WerkOrders[[#This Row],[% voltooid]]=1,2,IF(ISBLANK(WerkOrders[[#This Row],[Einddatum]]),\"\",IF(AND(TODAY()>WerkOrders[[#This Row],[Einddatum]],WerkOrders[[#This Row],[% voltooid]]<>1),0,1)))","v":1}]