{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Work order tracking form"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Work order tracking form","index":0,"n_rows":5,"n_cols":9,"rows_kept":5}
[null,"Work order tracker"]
[null,"Work order #","Description","Requested by","Assigned to","Start date","Due date","% Complete","Status"]
[null,"TR45878","Equipment Inventory","April Hansson","Michele Saaz",{"$f":"TODAY()-120","v":"2022-07-13"},{"$f":"TODAY()-1","v":"2022-11-09"},{"v":0.75,"d":"75%"},{"$f":"IFERROR(IF(WorkOrders[[#This Row],[% Complete]]=1,1,IF(ISBLANK(WorkOrders[[#This Row],[Due date]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Due date]],WorkOrders[[#This Row],[% Complete]]<>1),0,-1))), \"\")","v":0}]
[null,"YT9876","Build new customer database","Darnell Grau","Carlota Melgar",{"$f":"TODAY()-30","v":"2022-10-11"},{"$f":"TODAY()+15","v":"2022-11-25"},{"v":1,"d":"100%"},{"$f":"IFERROR(IF(WorkOrders[[#This Row],[% Complete]]=1,1,IF(ISBLANK(WorkOrders[[#This Row],[Due date]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Due date]],WorkOrders[[#This Row],[% Complete]]<>1),0,-1))), \"\")","v":1}]
[null,"TR7865","Upgrade desktop computer","Darnell Grau","Michele Saaz",{"$f":"TODAY()","v":"2022-11-10"},{"$f":"WorkOrders[[#This Row],[Start date]]+30","v":"2022-12-10"},{"v":0,"d":"0%"},{"$f":"IFERROR(IF(WorkOrders[[#This Row],[% Complete]]=1,1,IF(ISBLANK(WorkOrders[[#This Row],[Due date]]),\"\",IF(AND(TODAY()>WorkOrders[[#This Row],[Due date]],WorkOrders[[#This Row],[% Complete]]<>1),0,-1))), \"\")","v":-1}]