{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Att göra-lista för projekt 1","Inställningar och beräkningar"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Att göra-lista för projekt 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Att göra-lista för projekt"]
[]
[null,"Ska slutföras senast:",null,null,"Tidsgräns:",null,"Markera aktiviteter"]
[null,"Anders Svensson",null,null,{"$f":"TODAY()+95","v":"2012-12-15"},null,"     De här veckan [18 jun - 24 jun]"]
[]
[null,"Projekt 1"]
[null,"Aktivitet","Förfaller","Budget","% slutfört","Förlopp","Anteckningar"," "]
[null,"Planering",{"$f":"TODAY()-90","v":"2012-06-13"},{"v":476,"d":"476.00 kr"},{"v":0.25,"d":"25%"},{"$f":"#REF!","v":{"v":0.25,"d":"25%"}}]
[null,"Förberedelse",{"$f":"TODAY()-2","v":"2012-09-09"},{"v":301,"d":"301.00 kr"},{"v":0.1,"d":"10%"},{"$f":"#REF!","v":{"v":0.1,"d":"10%"}}]
[null,"Aktivitet A",{"$f":"TODAY()-7","v":"2012-09-04"},{"v":429,"d":"429.00 kr"},{"v":0,"d":"0%"},{"$f":"#REF!","v":{"v":0,"d":"0%"}}]
[null,"Aktivitet B",{"$f":"TODAY()+20","v":"2012-10-01"},{"v":332,"d":"332.00 kr"},{"v":0.7,"d":"70%"},{"$f":"#REF!","v":{"v":0.7,"d":"70%"}}]
[null,"Aktivitet C",{"$f":"TODAY()+40","v":"2012-10-21"},{"v":471,"d":"471.00 kr"},{"v":0.1,"d":"10%"},{"$f":"#REF!","v":{"v":0.1,"d":"10%"}}]
[null,"Aktivitet D",{"$f":"TODAY()+45","v":"2012-10-26"},{"v":418,"d":"418.00 kr"},{"v":1,"d":"100%"},{"$f":"#REF!","v":{"v":1,"d":"100%"}}]
[null,"Pappersarbete",{"$f":"TODAY()+55","v":"2012-11-05"},{"v":150,"d":"150.00 kr"},{"v":0,"d":"0%"},{"$f":"#REF!","v":{"v":0,"d":"0%"}},"Starta när aktivitet B har slutförts"]
[null,"Avlämning",{"$f":"TODAY()+70","v":"2012-11-20"},{"v":330,"d":"330.00 kr"},{"v":0.25,"d":"25%"},{"$f":"#REF!","v":{"v":0.25,"d":"25%"}}]
[null,"Uppföljning",{"$f":"TODAY()+90","v":"2012-12-10"},{"v":353,"d":"353.00 kr"},{"v":0.5,"d":"50%"},{"$f":"#REF!","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Inställningar och beräkningar","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Markeringsinställningar"]
[null,"Nedanstående tabeller innehåller inställningar och beräkningar för den nedrullningsbara listan Markera aktiviteter.\nEventuella ändringar kan orsaka fel eller förlust av funktioner."]
[null,"Ingen markering",null,null,{"$f":"B5","v":"Ingen markering"}]
[null,"Intervall:","Start:","Slut:","Förfaller:"]
[null,"     Den här veckan",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-09-10"},{"$f":"C7+6","v":"2012-09-16"},{"$f":"B7&\" [\"&TEXT(C7,\"MMM D\")&\" - \"&TEXT(D7,\"MMM D\")&\"]\"","v":"     Den här veckan [sep 10 - sep 16]"}]
[null,"     Den här månaden",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-09-01"},{"$f":"EDATE(C8,1)-1","v":"2012-09-30"},{"$f":"B8&\" [\"&TEXT(C8,\"D\")&\" - \"&TEXT(D8,\"MMM D\")&\"]\"","v":"     Den här månaden [1 - sep 30]"}]
[null,"     Det här kvartalet",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"MMM D\")&\" - \"&TEXT(D9,\"MMM D\")&\"]\"","v":"     Det här kvartalet [apr 1 - jul 31]"}]
[null,"     Det här året",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"ÅÅÅÅ\")&\"]\"","v":"     Det här året [2012]"}]
[null,"Intervall:",null,null,{"$f":"B11","v":"Intervall:"}]
[null,"     Förra veckan",{"$f":"C7-7","v":"2012-09-03"},{"$f":"C12+6","v":"2012-09-09"},{"$f":"B12&\" [\"&TEXT(C12,\"MMM D\")&\" - \"&TEXT(D12,\"MMM D\")&\"]\"","v":"     Förra veckan [sep 3 - sep 9]"}]
[null,"     Förra månaden",{"$f":"EDATE(C8,-1)","v":"2012-08-01"},{"$f":"EDATE(C13,1)-1","v":"2012-08-31"},{"$f":"B13&\" [\"&TEXT(C13,\"D\")&\" - \"&TEXT(D13,\"MMM D\")&\"]\"","v":"     Förra månaden [1 - aug 31]"}]
[null,"     Förra kvartalet",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"MMM D\")&\" - \"&TEXT(D14,\"MMM D\")&\"]\"","v":"     Förra kvartalet [jan 1 - mar 31]"}]
[null,"     Förra året",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Förra året"}]
[]
[null,"Vald markering:",{"$f":"IFERROR(MATCH(Markera_aktiviteter,lista_Att_göra_markeringar,0),\"\")","v":""},{"$f":"Markera_aktiviteter","v":"     De här veckan [18 jun - 24 jun]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Markera start",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Markera slut",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]