{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tidsplanen","Gantt Chart","Grafisk præsentation","Opsætning"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tidsplanen","index":0,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tidsplan for Projekt Eksempel"]
[]
[null,"Startdato","2012-01-01",null,"Estimeret timer"]
[null,"Slutdato","2012-08-01",null,{"$f":"SUM(K:K)","v":1620}]
[]
[]
[null,null,null,null,"adskilt af ; tegn","dd-mm-yyyy","dd-mm-yyyy","Udregnet","Kan skjules","Kan skjules","Kan skjules"]
[null,"Aktivitet","Type","Ansvarlig","Personer","Start","Slut","Dage","Arbejdsdage","Personer","Estimeret timer","Bemærkninger"]
[null,"Forberedelse inden afklaringsfase",null,null,null,"2012-01-02","2012-02-29",{"$f":"IF(F10<$C$4,0,(IF(F10=G10,1,(G10-F10)+1)))","v":59},{"$f":"IF(F10<$C$4,0,(IF(F10=G10,1,(NETWORKDAYS(F10,G10)))))","v":43},{"$f":"IF(E10<>\"\",LEN(E10)-LEN(SUBSTITUTE(E10,\";\",\"\"))+1,0)","v":0},{"$f":"IF(AND(J10>0,I10>0),J10*I10*Opsætning!$F$5,0)","v":0}]
[null,"Møde med kundens projektleder",null,"Leverandør","PL1;MED1","2012-01-02","2012-01-02",{"$f":"IF(F11<$C$4,0,(IF(F11=G11,1,(G11-F11)+1)))","v":1},{"$f":"IF(F11<$C$4,0,(IF(F11=G11,1,(NETWORKDAYS(F11,G11)))))","v":1},2,{"$f":"IF(AND(J11>0,I11>0),J11*I11*Opsætning!$F$5,0)","v":15}]
[null,"Kontraktsforhandling",null,"Leverandør","PL1;MED1","2012-01-03","2012-01-10",8,{"$f":"IF(F12<$C$4,0,(IF(F12=G12,1,(NETWORKDAYS(F12,G12)))))","v":6},2,{"$f":"IF(AND(J12>0,I12>0),J12*I12*Opsætning!$F$5,0)","v":90}]
[null,"Kunde modtager revideret kontraktsoplæg",null,"Leverandør","PL1;MED1","2012-01-17","2012-01-17",1,{"$f":"IF(F13<$C$4,0,(IF(F13=G13,1,(NETWORKDAYS(F13,G13)))))","v":1},2,{"$f":"IF(AND(J13>0,I13>0),J13*I13*Opsætning!$F$5,0)","v":15}]
[null,"Kundens frist for kontraktsændringer",null,"Kunde",null,"2012-01-30","2012-01-30",1,1,0,{"$f":"IF(AND(J14>0,I14>0),J14*I14*Opsætning!$F$5,0)","v":0}]
[null,"Endelige udgave af kontrakt sendes til godkendelse",null,"Leverandør","PL1;MED1","2012-02-15","2012-02-15",1,1,2,{"$f":"IF(AND(J15>0,I15>0),J15*I15*Opsætning!$F$5,0)","v":15}]
[null,"Kontraktsunderskrift","Kritisk","Leverandør","PL1","2012-02-29","2012-02-29",1,1,1,{"$f":"IF(AND(J16>0,I16>0),J16*I16*Opsætning!$F$5,0)","v":7.5}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J17>0,I17>0),J17*I17*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J18>0,I18>0),J18*I18*Opsætning!$F$5,0)","v":0}]
[null,"Projekt start",null,null,null,"2012-03-01","2012-03-11",11,7,0,{"$f":"IF(AND(J19>0,I19>0),J19*I19*Opsætning!$F$5,0)","v":0}]
[null,"Projektopstartsmøde",null,"Leverandør","PL1;MED1","2012-03-05","2012-03-05",1,1,2,{"$f":"IF(AND(J20>0,I20>0),J20*I20*Opsætning!$F$5,0)","v":15}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J21>0,I21>0),J21*I21*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J22>0,I22>0),J22*I22*Opsætning!$F$5,0)","v":0}]
[null,"Afklaringsfase",null,null,null,"2012-03-12","2012-03-30",19,15,0,{"$f":"IF(AND(J23>0,I23>0),J23*I23*Opsætning!$F$5,0)","v":0}]
[null,"Gennemgang af den tilbudte løsning",null,"Leverandør","PL1;MED1","2012-03-12","2012-03-13",2,2,2,{"$f":"IF(AND(J24>0,I24>0),J24*I24*Opsætning!$F$5,0)","v":30}]
[null,"Gennemgang af den tilbudte organisation",null,"Leverandør","PL1;MED1","2012-03-14","2012-03-15",2,2,2,{"$f":"IF(AND(J25>0,I25>0),J25*I25*Opsætning!$F$5,0)","v":30}]
[null,"Gennemgang af tilbudte prøver, change management osv.",null,"Leverandør","PL1;MED1","2012-03-16","2012-03-19",4,2,2,{"$f":"IF(AND(J26>0,I26>0),J26*I26*Opsætning!$F$5,0)","v":30}]
[null,"Fremsendelse af opdateret bilag",null,"Leverandør","PL1;MED1","2012-03-23","2012-03-23",1,1,2,{"$f":"IF(AND(J27>0,I27>0),J27*I27*Opsætning!$F$5,0)","v":15}]
[null,"Frist for kommentering af opdateret bilag",null,"Kunde",null,"2012-03-27","2012-03-27",1,1,0,{"$f":"IF(AND(J28>0,I28>0),J28*I28*Opsætning!$F$5,0)","v":0}]
[null,"Fremsendelse af endelig bilag til styregruppe",null,"Leverandør","PL1;MED1","2012-03-28","2012-03-28",1,1,2,{"$f":"IF(AND(J29>0,I29>0),J29*I29*Opsætning!$F$5,0)","v":15}]
[null,"Afklaringsfasen er endelig godkendt af styregruppen","Betaling","Kunde",null,"2012-03-30","2012-03-30",1,1,0,{"$f":"IF(AND(J30>0,I30>0),J30*I30*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J31>0,I31>0),J31*I31*Opsætning!$F$5,0)","v":0}]
[null,"Udviklingsfasen",null,null,null,"2012-04-02","2012-05-31",60,44,0,{"$f":"IF(AND(J32>0,I32>0),J32*I32*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 0 - Kickstart af udviklingsforløb",null,"Leverandør","PL1;MED1;MED2","2012-04-02","2012-04-14",13,10,3,{"$f":"IF(AND(J33>0,I33>0),J33*I33*Opsætning!$F$5,0)","v":225}]
[null,"Sprint 0 - Sprint planning",null,"Leverandør",null,"2012-04-02","2012-04-02",1,1,0,{"$f":"IF(AND(J34>0,I34>0),J34*I34*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 0 - Review af kunde",null,"Leverandør",null,"2012-04-13","2012-04-13",1,1,0,{"$f":"IF(AND(J35>0,I35>0),J35*I35*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 0 - Retrospective",null,"Leverandør",null,"2012-04-13","2012-04-13",1,1,0,{"$f":"IF(AND(J36>0,I36>0),J36*I36*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 0 - Godkendelse af kunden",null,"Kunde",null,"2012-04-14","2012-04-14",1,1,0,{"$f":"IF(AND(J37>0,I37>0),J37*I37*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 1 - Kickstart af udviklingsforløb",null,"Leverandør","PL1;MED1;MED2","2012-04-16","2012-04-27",12,10,3,{"$f":"IF(AND(J38>0,I38>0),J38*I38*Opsætning!$F$5,0)","v":225}]
[null,"Sprint 1 - Sprint planning",null,"Leverandør",null,"2012-04-16","2012-04-16",1,1,0,{"$f":"IF(AND(J39>0,I39>0),J39*I39*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 1 - Review af kunde",null,"Leverandør",null,{"$f":"G38-1","v":"2012-04-26"},{"$f":"G38-1","v":"2012-04-26"},1,1,0,{"$f":"IF(AND(J40>0,I40>0),J40*I40*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 1 - Retrospective",null,"Leverandør",null,{"$f":"G38-1","v":"2012-04-26"},{"$f":"F41","v":"2012-04-26"},1,1,0,{"$f":"IF(AND(J41>0,I41>0),J41*I41*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 1 - Godkendelse af kunden",null,"Kunde",null,{"$f":"G38","v":"2012-04-27"},{"$f":"G38","v":"2012-04-27"},1,1,{"$f":"IF(E42<>\"\",LEN(E42)-LEN(SUBSTITUTE(E42,\";\",\"\"))+1,0)","v":0},{"$f":"IF(AND(J42>0,I42>0),J42*I42*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 2 - Kickstart af udviklingsforløb",null,"Leverandør","PL1;MED1;MED2","2012-04-30","2012-05-11",12,10,3,{"$f":"IF(AND(J43>0,I43>0),J43*I43*Opsætning!$F$5,0)","v":225}]
[null,"Sprint 2 - Sprint planning",null,"Leverandør",null,"2012-04-30","2012-04-30",1,1,0,{"$f":"IF(AND(J44>0,I44>0),J44*I44*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 2 - Review af kunde",null,"Leverandør",null,{"$f":"G43-1","v":"2012-05-10"},{"$f":"G43-1","v":"2012-05-10"},1,1,0,{"$f":"IF(AND(J45>0,I45>0),J45*I45*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 2 - Retrospective",null,"Leverandør",null,{"$f":"G43-1","v":"2012-05-10"},{"$f":"F46","v":"2012-05-10"},1,1,0,{"$f":"IF(AND(J46>0,I46>0),J46*I46*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 2 - Godkendelse af kunden",null,"Kunde",null,{"$f":"G43","v":"2012-05-11"},{"$f":"G43","v":"2012-05-11"},1,1,0,{"$f":"IF(AND(J47>0,I47>0),J47*I47*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 3 - Kickstart af udviklingsforløb",null,"Leverandør","PL1;MED1;MED2","2012-05-14","2012-05-25",12,10,3,{"$f":"IF(AND(J48>0,I48>0),J48*I48*Opsætning!$F$5,0)","v":225}]
[null,"Sprint 3 - Sprint planning",null,"Leverandør",null,"2012-05-14","2012-05-14",1,1,0,{"$f":"IF(AND(J49>0,I49>0),J49*I49*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 3 - Review af kunde",null,"Leverandør",null,{"$f":"G48-1","v":"2012-05-24"},{"$f":"G48-1","v":"2012-05-24"},1,1,0,{"$f":"IF(AND(J50>0,I50>0),J50*I50*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 3 - Retrospective",null,"Leverandør",null,{"$f":"G48-1","v":"2012-05-24"},{"$f":"F51","v":"2012-05-24"},1,1,0,{"$f":"IF(AND(J51>0,I51>0),J51*I51*Opsætning!$F$5,0)","v":0}]
[null,"Sprint 3 - Godkendelse af kunden",null,"Kunde",null,{"$f":"G48","v":"2012-05-25"},{"$f":"G48","v":"2012-05-25"},1,1,0,{"$f":"IF(AND(J52>0,I52>0),J52*I52*Opsætning!$F$5,0)","v":0}]
[null,"Al udvikling er færdig og godkendt","Betaling","Leverandør",null,"2012-05-31","2012-05-31",1,1,0,{"$f":"IF(AND(J53>0,I53>0),J53*I53*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J54>0,I54>0),J54*I54*Opsætning!$F$5,0)","v":0}]
[null,"Prøver",null,null,null,"2012-06-01","2012-06-30",30,21,0,{"$f":"IF(AND(J55>0,I55>0),J55*I55*Opsætning!$F$5,0)","v":0}]
[null,"Fremsendelse af udkast til en prøveplan til kunde",null,"Leverandør","PL1;MED1;MED2","2012-05-20","2012-05-20",1,1,3,{"$f":"IF(AND(J56>0,I56>0),J56*I56*Opsætning!$F$5,0)","v":22.5}]
[null,"Kundens frist til at kommenterer på prøveplan",null,"Kunde",null,"2012-05-23","2012-05-23",1,1,0,{"$f":"IF(AND(J57>0,I57>0),J57*I57*Opsætning!$F$5,0)","v":0}]
[null,"Fremsendelse af endelig prøveplan til kunde",null,"Leverandør","PL1;MED1;MED2","2012-05-25","2012-05-25",1,1,3,{"$f":"IF(AND(J58>0,I58>0),J58*I58*Opsætning!$F$5,0)","v":22.5}]
[null,"Endelige godkendelse af prøveplan","Kritisk","Kunde",null,"2012-05-31","2012-05-31",1,1,0,{"$f":"IF(AND(J59>0,I59>0),J59*I59*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J60>0,I60>0),J60*I60*Opsætning!$F$5,0)","v":0}]
[null,"Gennemførsel af prøve",null,"Leverandør","PL1;MED1;MED2","2012-06-01","2012-06-15",15,11,3,{"$f":"IF(AND(J61>0,I61>0),J61*I61*Opsætning!$F$5,0)","v":247.5}]
[null,"Rapportering af prøve",null,"Leverandør","PL1","2012-06-18","2012-06-22",5,5,1,{"$f":"IF(AND(J62>0,I62>0),J62*I62*Opsætning!$F$5,0)","v":37.5}]
[null,"Godkendelse af prøve og dermed leverance","Betaling","Kunde",null,"2012-06-29","2012-06-29",1,1,0,{"$f":"IF(AND(J63>0,I63>0),J63*I63*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J64>0,I64>0),J64*I64*Opsætning!$F$5,0)","v":0}]
[null,"Idriftsættelse",null,null,null,"2012-07-02","2012-07-18",17,13,0,{"$f":"IF(AND(J65>0,I65>0),J65*I65*Opsætning!$F$5,0)","v":0}]
[null,"Klarmelding af driftsmiljø fra hosting leverandør","Kritisk","Hosting",null,"2012-07-02","2012-07-02",1,1,0,{"$f":"IF(AND(J66>0,I66>0),J66*I66*Opsætning!$F$5,0)","v":0},"Iflg selvstændig tidsplan med underleverandør"]
[null,"Installation på driftsmiljø","Kritisk","Leverandør","PL1;MED1;MED2","2012-07-04","2012-07-06",3,3,3,{"$f":"IF(AND(J67>0,I67>0),J67*I67*Opsætning!$F$5,0)","v":67.5}]
[null,"Installationsprøve afvikles for at sikre driftsmiljø","Kritisk","Leverandør","PL1;MED1;MED2","2012-07-09","2012-07-10",2,2,3,{"$f":"IF(AND(J68>0,I68>0),J68*I68*Opsætning!$F$5,0)","v":45}]
[null,"Godkendelse af driftsmiljø","Kritisk","Kunde",null,"2012-07-13","2012-07-13",1,1,0,{"$f":"IF(AND(J69>0,I69>0),J69*I69*Opsætning!$F$5,0)","v":0}]
[null,"Udmelding til brugere","Kritisk","Kunde",null,"2012-07-16","2012-07-16",1,1,0,{"$f":"IF(AND(J70>0,I70>0),J70*I70*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J71>0,I71>0),J71*I71*Opsætning!$F$5,0)","v":0}]
[null,"Idriftsættelse færdig og leverance endelig godkendt","Betaling","Kunde",null,"2012-07-18","2012-07-18",1,1,0,{"$f":"IF(AND(J72>0,I72>0),J72*I72*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J73>0,I73>0),J73*I73*Opsætning!$F$5,0)","v":0}]
[null,"Vedligeholdelse af produkt (4 år)",null,null,null,"2012-07-18","2016-07-17",1461,1043,{"$f":"IF(E74<>\"\",LEN(E74)-LEN(SUBSTITUTE(E74,\";\",\"\"))+1,0)","v":0},{"$f":"IF(AND(J74>0,I74>0),J74*I74*Opsætning!$F$5,0)","v":0}]
[null,"Vedligeholdelse af produkt (4 år)","Betaling",null,null,null,null,{"$f":"IF(F75<$C$4,0,(IF(F75=G75,1,(G75-F75)+1)))","v":0},0,0,{"$f":"IF(AND(J75>0,I75>0),J75*I75*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AND(J76>0,I76>0),J76*I76*Opsætning!$F$5,0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(F77<$C$4,0,(IF(F77=G77,1,(NETWORKDAYS(F77,G77)))))","v":0},0,{"$f":"IF(AND(J77>0,I77>0),J77*I77*Opsætning!$F$5,0)","v":0}]

{"sheet":"Gantt Chart","index":1,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"G2","v":40909}]
[null,null,null,null,{"$f":"G3","v":41122},"Startdato på Chart","2012-01-01"]
[null,null,null,null,null,"Slutdato på Chart","2012-08-01"]

{"sheet":"Grafisk præsentation","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Projekt tidsplan overordnet"]
[]
[null,null,2012,"Januar","Februar","Marts","April","Maj","Juni","Juli","August","September"]
[]
[null,null,"Forberedelse inden afklaringsfase"]
[null,null,"Projekt start"]
[null,null,"Afklaringsfase"]
[null,null,"Udviklingsfasen"]
[null,null,"Prøver"]
[null,null,"Idriftsættelse"]
[null,null,"Vedligeholdelse af produkt (4 år)"]

{"sheet":"Opsætning","index":3,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Opsætning"]
[]
[null,"Typer af aktiviteter",null,"Ansvarlige",null,"Arbejdstimer på en dag"]
[null,"Kritisk",null,"Leverandør",null,7.5]
[null,"Betaling",null,"Kunde"]
[null,null,null,"Hosting"]