{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Lärarens lista"," Listinformation"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Lärarens lista","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"Lärarens lista",null,"Listinformation","Färgförklaringen för status finns i den här cellen: Ej påbörjad är normalt format, Pågår är R=91 G=133 B=49, Förfaller idag är R=118 G=88 B=0, Väntande är R=109 G=66 B=111, Slutförd är genomstruken, Avbruten är R=191 G=191 B=191, och försenad är R=191 G=33 B=28."]
[null,"POST","KATEGORI","STARTDATUM","SLUTDATUM","DAGAR KVAR","STATUS","ANTECKNINGAR"]
[null,"Rengör lådor","Kontors-",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":""},"Slutförd",null,null,"Statusutsnitt finns i den här cellen. Välj en status från utsnittet om du vill filtrera listan efter status. Tryck på och håll ned Ctrl för att markera flera alternativ."]
[null,"Beställa etiketter","material",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":""},"Slutförd"]
[null,"Moppa golv","Annan",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-15"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":""},"Slutförd"]
[null,"Skapa namnetiketter","material",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":""},"Väntande"]
[null,"Betygsätta uppsatser","Utvärderingar",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-05"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":-5},"Försenad"]
[null,"E-postpåminnelse för intyg","Telefonsamtal",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":""},"Avbruten"]
[null,"Betygsätta muntliga uppgifter","Kontors-",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":7},"Pågår"]
[null,"Vässa pennor","material",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(Lista[[#This Row],[STARTDATUM]]:Lista[[#This Row],[SLUTDATUM]])<>2,\"\",IF(OR(Lista[[#This Row],[STATUS]]=\"Slutförd\",Lista[[#This Row],[STATUS]]=\"Avbruten\",Lista[[#This Row],[STATUS]]=\"Väntande\"),\"\",Lista[[#This Row],[SLUTDATUM]]-TODAY())),\"\")","v":0},"Pågår"]

{"sheet":" Listinformation","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"Listinformation","Lärarens lista"]
[null,"Kategori"]
[null,"Kontors-"]
[null,"material"]
[null,"Saker att köpa"]
[null,"Telefonsamtal"]
[null,"Nya idéer"]
[null,"Utvärderingar"]
[null,"Grupp-"]
[null,"insatser"]
[null,"Dator"]
[null,"Privat"]
[null,"Annan"]