{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Priser i utvärdering","Admin","SysAdmin"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"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":"Priser i utvärdering","index":0,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[23,6,23,7],[55,6,55,7],[65,1,66,4],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[62,6,62,7],[63,2,64,5],[61,6,61,7],[47,6,47,7],[49,6,49,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[45,6,45,7],[53,6,53,7],[54,6,54,7],[3,1,3,2],[6,1,6,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[12,1,12,2],[14,1,14,2],[8,3,8,7],[3,4,3,9],[5,4,5,9],[6,4,6,9],[41,6,41,7],[24,6,24,7],[25,6,25,7],[48,6,48,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[42,6,42,7],[43,6,43,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[44,6,44,7]]}
[null,null,null,null,null,null,null,null,"Mallen uppdaterades:","2020-03-12"]
[null,"Anbudspriser - Städtjänster, Stockholms län",null,null,null,null,null,null,"Datum och tid för PDF-dokument:","2020-03-12T13:39:49"]
[]
[null,"Gulmarkerade rutor fylls i av myndigheten vid avrop. Uppgifterna ska avse ett (1 år). Kontraktslängden anges som antal månader. ",null,null,"Anbudsgivaren ska fylla i priser i samtliga blå celler. Nollpris anges med siffran 0. Alla priser anges i SEK exklusive moms."]
[]
[null,"Avropare, namn",null,null,"Ramavtalsleverantörens namn"]
[null,null,null,null,"Välj leverantör"]
[null,"Bilaganr",null,null,null,null,null,null,"Utvärderingspriserna gäller från",{"$f":"RIGHT(B68,11)","v":"2020-04-01."}]
[null,null,null,{"$f":"IF(J66=\"\",\"OBS! Glöm ej att fylla i kontraktslängden.\",\"\")","v":"OBS! Glöm ej att fylla i kontraktslängden."}]
[null,"Diarienummer "]
[]
[]
[null,"Tidsperiod för volymberäkningar"]
[]
[]
[null,null,null,"Volym","Enhet","Takpris1)",null,null,"Anbudspris","Utvärderingspris"]
[null,"Kat. 1 - Servicecenter ≤ 2000 Användare",null,0,"År",{"$f":"IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),\"\"))","v":{"$error":"#REF!"}},null,null,700000,{"$f":"+D17*I17","v":0}]
[null,"Kat. 2 – Servicecenter 2001-4000 Användare",null,0,"År",{"$f":"IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),\"\"))","v":{"$error":"#REF!"}},null,null,1000000,{"$f":"+D18*I18","v":0}]
[null,"Kat. 3 – Servicecenter 4001-8000 Användare",null,0,"År",{"$f":"IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),\"\"))","v":{"$error":"#REF!"}},null,null,2500000,{"$f":"+D19*I19","v":0}]
[null,"Kat. 4 – Servicecenter 8001-16000 Användare",null,0,"År",{"$f":"IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),IF(Leverantor=#REF!,IF(#REF!=\"\",\"\",#REF!),\"\"))","v":{"$error":"#REF!"}},null,null,3500000,{"$f":"+D20*I20","v":0}]
[]
[]
[]
[null,"Avrop av timbaserade tjänster, daglig städning, fast timpris\nAntal timmar fastställs av myndigheten.","Ange Option*)","Se avrops-förfrågan, avsnitt","Antal timmar per tillfälle","Antal tillfällen/år","Totalt antal timmar",null,"Utvärderingspris, ramavtalsupp-\nhandlingen ¹⁾","Utvärderas i avropet"]
[null,null,null,null,null,null,{"$f":"IF(F25*E25=0,\"\",F25*E25)","v":""},null,{"$f":"IFERROR(IF(G25=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I25*G25,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F26*E26=0,\"\",F26*E26)","v":""},null,{"$f":"IFERROR(IF(G26=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I26*G26,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F27*E27=0,\"\",F27*E27)","v":""},null,{"$f":"IFERROR(IF(G27=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I27*G27,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F28*E28=0,\"\",F28*E28)","v":""},null,{"$f":"IFERROR(IF(G28=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I28*G28,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F29*E29=0,\"\",F29*E29)","v":""},null,{"$f":"IFERROR(IF(G29=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I29*G29,\"\")","v":""}]
[]
[]
[]
[null,"Avrop av timbaserade tjänster, daglig städning, fast timpris\nAntal timmar fastställs av leverantören.","Ange Option*)","Se avrops-förfrågan, avsnitt","Antal timmar per tillfälle","Antal tillfällen/år","Totalt antal timmar",null,"Utvärderingspris, ramavtalsupp-\nhandlingen ¹⁾","Utvärderas i avropet"]
[null,null,null,null,null,null,{"$f":"IF(F34*E34=0,\"\",F34*E34)","v":""},null,{"$f":"IFERROR(IF(G34=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I34*G34,\"\")","v":""},null,{"$f":"IF(AND(F34<>\"\",E34=\"\")=TRUE,\"Antal timmar per tillfälle behöver anges\",IF(AND(E34<>\"\",F34=\"\")=TRUE,\"Antal tillfällen/år behöver anges\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F35*E35=0,\"\",F35*E35)","v":""},null,{"$f":"IFERROR(IF(G35=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I35*G35,\"\")","v":""},null,{"$f":"IF(AND(F35<>\"\",E35=\"\")=TRUE,\"Antal timmar per tillfälle behöver anges\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F36*E36=0,\"\",F36*E36)","v":""},null,{"$f":"IFERROR(IF(G36=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I36*G36,\"\")","v":""},null,{"$f":"IF(AND(F36<>\"\",E36=\"\")=TRUE,\"Antal timmar per tillfälle behöver anges\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F37*E37=0,\"\",F37*E37)","v":""},null,{"$f":"IFERROR(IF(G37=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I37*G37,\"\")","v":""},null,{"$f":"IF(AND(F37<>\"\",E37=\"\")=TRUE,\"Antal timmar per tillfälle behöver anges\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F38*E38=0,\"\",F38*E38)","v":""},null,{"$f":"IFERROR(IF(G38=\"\",\"\",INDEX(TblLevPris,MATCH(Leverantor,TblLev,0))),\"\")","v":""},{"$f":"IFERROR(I38*G38,\"\")","v":""},null,{"$f":"IF(AND(F38<>\"\",E38=\"\")=TRUE,\"Antal timmar per tillfälle behöver anges\",\"\")","v":""}]
[]
[]
[]
[null,"Avrop av tjänster per kvadratmeter","Ange Option*)","Se avrops-förfrågan, avsnitt","Antal kvadrat-\nmeter per tillfälle","Antal tillfällen/år","Totalt antal kvadrat-\nmeter",null,"Anbudspris, kvadratmeter","Utvärderas i avropet"]
[null,null,null,null,null,null,{"$f":"IF(F43*E43=0,\"\",F43*E43)","v":""},null,null,{"$f":"IFERROR(I43*G43,\"\")","v":""},null,{"$f":"IF(AND(I43<>\"\",G43=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I43<>\"\",G43<>\"\")=TRUE,TRUE,FALSE),IF(AND(I43=\"\",G43=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L43<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F44*E44=0,\"\",F44*E44)","v":""},null,null,{"$f":"IFERROR(I44*G44,\"\")","v":""},null,{"$f":"IF(AND(I44<>\"\",G44=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I44<>\"\",G44<>\"\")=TRUE,TRUE,FALSE),IF(AND(I44=\"\",G44=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L44<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F45*E45=0,\"\",F45*E45)","v":""},null,null,{"$f":"IFERROR(I45*G45,\"\")","v":""},null,{"$f":"IF(AND(I45<>\"\",G45=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I45<>\"\",G45<>\"\")=TRUE,TRUE,FALSE),IF(AND(I45=\"\",G45=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,false]
[null,null,null,null,null,null,{"$f":"IF(F46*E46=0,\"\",F46*E46)","v":""},null,null,{"$f":"IFERROR(I46*G46,\"\")","v":""},null,{"$f":"IF(AND(I46<>\"\",G46=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I46<>\"\",G46<>\"\")=TRUE,TRUE,FALSE),IF(AND(I46=\"\",G46=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,false]
[]
[null,"Avrop av tjänster för specifikt objekt","Ange Option*)","Se avrops-förfrågan, avsnitt","Antal objekt per tillfälle","Antal tillfällen/år","Totalt antal objekts-\nstädningar",null,"Anbudspris","Utvärderas i avropet"]
[null,null,null,null,null,null,{"$f":"IF(F49*E49=0,\"\",F49*E49)","v":""},null,null,{"$f":"IFERROR(I49*G49,\"\")","v":""},null,{"$f":"IF(AND(I49<>\"\",G49=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I49<>\"\",G49<>\"\")=TRUE,TRUE,FALSE),IF(AND(I49=\"\",G49=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L49<>\"\"","v":false}]
[null,null,null,null,null,null,"",null,null,"",null,"",null,null,false]
[null,null,null,null,null,null,"",null,null,"",null,"",null,null,false]
[null,null,null,null,null,null,"",null,null,"",null,"",null,null,false]
[null,null,null,null,null,null,"",null,null,"",null,"",null,null,{"$f":"L53<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F54*E54=0,\"\",F54*E54)","v":""},null,null,{"$f":"IFERROR(I54*G54,\"\")","v":""},null,{"$f":"IF(AND(I54<>\"\",G54=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I54<>\"\",G54<>\"\")=TRUE,TRUE,FALSE),IF(AND(I54=\"\",G54=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L54<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F55*E55=0,\"\",F55*E55)","v":""},null,null,{"$f":"IFERROR(I55*G55,\"\")","v":""},null,{"$f":"IF(AND(I55<>\"\",G55=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I55<>\"\",G55<>\"\")=TRUE,TRUE,FALSE),IF(AND(I55=\"\",G55=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L55<>\"\"","v":false}]
[null,null,null,null,null,null,"",null,null,"",null,"",null,null,false]
[]
[null,"Avrop av hygienmateriel där priserna utvärderas","Ange Option*)","Se avrops-förfrågan, avsnitt","Volym, hygien-\nmaterial","Antal \nleveranser/år","Totalt antal leveranser",null,"Anbudspris","Utvärderas i avropet"]
[null,null,null,null,null,null,{"$f":"IF(F59*E59=0,\"\",F59*E59)","v":""},null,null,{"$f":"IFERROR(I59*G59,\"\")","v":""},null,{"$f":"IF(AND(I59<>\"\",G59=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I59<>\"\",G59<>\"\")=TRUE,TRUE,FALSE),IF(AND(I59=\"\",G59=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L59<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F60*E60=0,\"\",F60*E60)","v":""},null,null,{"$f":"IFERROR(I60*G60,\"\")","v":""},null,{"$f":"IF(AND(I60<>\"\",G60=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I60<>\"\",G60<>\"\")=TRUE,TRUE,FALSE),IF(AND(I60=\"\",G60=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,false]
[null,null,null,null,null,null,{"$f":"IF(F61*E61=0,\"\",F61*E61)","v":""},null,null,{"$f":"IFERROR(I61*G61,\"\")","v":""},null,{"$f":"IF(AND(I61<>\"\",G61=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I61<>\"\",G61<>\"\")=TRUE,TRUE,FALSE),IF(AND(I61=\"\",G61=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,false]
[null,null,null,null,null,null,{"$f":"IF(F62*E62=0,\"\",F62*E62)","v":""},null,null,{"$f":"IFERROR(I62*G62,\"\")","v":""},null,{"$f":"IF(AND(I62<>\"\",G62=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I62<>\"\",G62<>\"\")=TRUE,TRUE,FALSE),IF(AND(I62=\"\",G62=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,{"$f":"L62<>\"\"","v":false}]
[null,null,null,null,null,null,{"$f":"IF(F63*E63=0,\"\",F63*E63)","v":""},null,null,{"$f":"IFERROR(I63*G63,\"\")","v":""},null,{"$f":"IF(AND(I63<>\"\",G63=\"\")=TRUE,\"Anbudspris ska ej anges\",IF(OR(IF(AND(I63<>\"\",G63<>\"\")=TRUE,TRUE,FALSE),IF(AND(I63=\"\",G63=\"\")=TRUE,TRUE,FALSE))=TRUE,\"\",\"Anbudspris behöver anges\"))","v":""},null,null,false]
[null,null,{"$f":"IF(OR(O43:O63)=TRUE,\"Kontrollera att anbudspriser är angivna på rätt rader\",\"\")","v":""}]
[null,"*) Optionen är ett beräknat behov men är inte förpliktigande att utlösas.",null,null,null,null,null,null,"Utvärderingspris för ett (1) år:",{"$f":"SUM($J$25:$J$29,$J$34:$J$38,$J$43:$J$46,$J$49:$J$56,$J$59:$J$63)","v":0}]
[null,"¹⁾Observera att det är det aktuella fasta timpriset, 267,79 SEK som kommer att faktureras, inte utvärderingspriset från ramavtalsupphandlingen.",null,null,null,null,null,null,"Kontraktslängd, antal månader:"]
[]
[null,"Det fasta timpriset och utvärderingspriserna gäller från 2020-04-01.",null,null,null,null,null,null,"Summa, utvärderas i avropet: ",{"$f":"($J$65/12)*$J$66","v":0}]

{"sheet":"Admin","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"TblLev","TblLevPris",null,"TblOption"]
[null,"Välj leverantör"]
[null,"Activa Service i Sverige Aktiebolag",247.79,null,"Option*)"]
[null,"Fervent Cleaning Company Aktiebolag",247.89]
[null,"KUNDIA AB",248.79]
[null,"Lassila & Tikanoja Service AB",247.79]
[null,"MIAB AB",248.94]
[null,"Miljöpalatset AB",248.79]
[null,"PMI Clean AB",247.79]
[null,"Rengörare Näslund Aktiebolag",248.09]
[null,"Städgladen AB",247.79]
[null,"Teknostäd AB",248.04]

{"sheet":"SysAdmin","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["LockStatus",false]
["UKey","asdf",null,2,{"$f":"INDEX(E3:E5,D2)","v":"Avroppsblanketten är nu upplåst, klicka här för att låsa avropsblanketten."}]
["pkey","Förvaltning21",null,null,"Adminläge! Klicka här för att låsa vita celler."]
["Wkey","Förvaltning21","RGB",null,"Avroppsblanketten är nu upplåst, klicka här för att låsa avropsblanketten."]
["YColor"," ","255, 255, 153",null,"Avroppsblanketten är nu låst, klicka här för att låsa upp avropsblanketten."]
[null,null,"204, 255, 255"]
[null,null,"150, 150, 150",null,"Grund för tilldelning av kontrakt & Utvärderingsmodell"]
[null,null,"204, 255, 204",null,{"$f":"VALUE(IF(ISNUMBER(SEARCH(\"2\",DpDwnTDV))=TRUE,\"2\",\"1\"))","v":1}]
[null,null,"250, 191, 143",null,{"$f":"\"Alt\"&IF(ISNUMBER(SEARCH(\"1\",DpDwnUtvddrop))=TRUE,\"1\",IF(ISNUMBER(SEARCH(\"2\",DpDwnUtvddrop))=TRUE,\"2\",IF(ISNUMBER(SEARCH(\"3\",DpDwnUtvddrop))=TRUE,\"3\",IF(ISNUMBER(SEARCH(\"4\",DpDwnUtvddrop))=TRUE,\"4\"))))","v":"AltFALSE"}]