{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Työtilausten seurantalomake"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Työtilausten seurantalomake","index":0,"n_rows":6,"n_cols":10,"rows_kept":6}
[null,"Työtilausten seuranta",{"$nulls":7}," "]
[]
[null,"Työtilauksen numero","Kuvaus","Pyynnön tekijä","Vastuuhenkilö","Alkamispäivä","Määräpäivä","% valmiina","Tila"]
[null,"TR45878","Laitevarasto","Juha-Pekka Posti","Esko Sario",{"$f":"TODAY()-120","v":"2012-08-13"},{"$f":"TODAY()-1","v":"2012-12-10"},{"v":0.75,"d":"75%"},{"$f":"IF(WorkOrders[[#This Row],[% valmiina]]=1,2,IF(ISBLANK(WorkOrders[[#This Row],[Määräpäivä]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Määräpäivä]],WorkOrders[[#This Row],[% valmiina]]<>1),0,1)))","v":0}]
[null,"YT9876","Uuden asiakastietokannan luominen","Ari Suominen","Teemu Sallinen",{"$f":"TODAY()-30","v":"2012-11-11"},{"$f":"TODAY()+15","v":"2012-12-26"},{"v":1,"d":"100%"},{"$f":"IF(WorkOrders[[#This Row],[% valmiina]]=1,2,IF(ISBLANK(WorkOrders[[#This Row],[Määräpäivä]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Määräpäivä]],WorkOrders[[#This Row],[% valmiina]]<>1),0,1)))","v":2}]
[null,"TR7865","Pöytätietokoneen päivittäminen","Ari Suominen","Esko Sario",{"$f":"TODAY()","v":"2012-12-11"},{"$f":"WorkOrders[[#This Row],[Alkamispäivä]]+30","v":"2013-01-10"},{"v":0,"d":"0%"},{"$f":"IF(WorkOrders[[#This Row],[% valmiina]]=1,2,IF(ISBLANK(WorkOrders[[#This Row],[Määräpäivä]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Määräpäivä]],WorkOrders[[#This Row],[% valmiina]]<>1),0,1)))","v":1}]