{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduksjon","Kontraktsregister","Kontraktsyklus","Backend_database_med_pivot"],"not_rendered":{"charts":2,"images":10,"macros":1,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":4},"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":"Introduksjon","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,3],[13,1,13,3],[3,1,3,3],[5,1,5,3],[7,1,7,3],[9,1,9,3],[10,1,10,3],[11,1,11,3]]}
[null,null,"Introduksjon og  veiledning - Kontraktsregister"]
[]
[null,"Formålet med verktøyet\n"]
[null,"Virksomheten bør ha kontroll på sine kontrakter for å kunne ha oversikt over forpliktelser og muligheter.\nKontraktsregistret understøtter en god struktur og samler nøkkelinformasjon om virksomhetens kontrakter - på et sted."]
[]
[null,"Kontraktssyklus gir oversikt over omsetning og antall kontrakter over en fireårs periode. Primært skal det støtte planlegging ifm fremtidige anskaffelsesprosesser. Hovedbruker vil derfor være innkjøpsansvarlig/innkjøpsavdelingen for virksomheten."]
[]
[null,"Veiledning - Generelt: \nFelter i gult er for utfylling.\nPlasser musepekeren over celler med rødt hjørne for å se kommentarer med utdypende informasjon."]
[]
[null,"Veiledning Kontraktsregister\nNår en ny kontrakt er inngått bør den registreres i kontraktsregisteret. Første steg er å fylle inn grunnleggende informasjon om kontrakten, vare- /tjenestegruppe, samt estimat av omsetning i Kolonne B-H. Denne dataen kan hentes fra en innkjøpsanalyse eller fra regnskap."]
[null,"De etterfølgende kolonne er gruppert i fem områder som skal oppsummere detaljer kring kontrakten. Det gårå skjule eller vise kolonner ved å benytte +-tegn\nNoen av nøkkeldataene fra kontraktsregisteret blir benyttet som kildedata for årshjulet. Disse cellene er markert med en klarere gul farge. "]
[null,"Veiledning Kontraktsyklus:\n'Velg fra rullgardinmeny første år i kontraktssyklus f.eks. 2014. Klikk deretter på knappen \"Oppdatert med data fra kontraktsregisteret\".\nFor at kontraktssyklus skal gi verdi for bruker må  \"Underkategori navn\", \"Totalverdi\", \"Status (=verdi \"Aktiv\") og \"Sannsynlig dato for anskaffelsesprosess\" i kontraktsregisteret være utfylt riktig."]
[null,"Det må alltid være en utløpsdato (Kolonne T i Kontraktsregsister) skal årshjulet fungere. 'Kontrakter med status satt til \"Terminert\" vil ikke bli inkludert i kontraktsyklusen"]
[null,"Formålet med kontraktssyklus er at virksomheten skal se, og kunne planlegge, når en ny anskaffelsesprosess skal startes. Det er derfor viktig å vurdere eksisterende kontrakter i god tid og ta hensyn til eventuelle opsjoner. Hvis virksomheten ikke er fornøyd med en kontrakt/leverandør bør dette noteres så at opsjoner ikke forlenges automatisk uten reforhandling eller ny konkurranseutsettelse.  "]

{"sheet":"Kontraktsregister","index":1,"n_rows":74,"n_cols":37,"rows_kept":74,"cut":false,"hidden":false,"merged":[[2,6,3,6]]}
[null,null,null,null,null,"Kontraktsregister"]
[]
[null,null,null,null,"Ansvarlig for kontraktsregister","\"Fyll inn navn\"","% under kontrakt og i dette register:"]
[null,null,null,null,"Estimert årlig totalverdi for virksomhetens anskaffelser  (100%)","\"Fyll inn verdi\""]
[null,null,null,null,"Estimert årlig totalverdi for kontrakter i dette register","\"Fyll inn verdi\"",{"$f":"IFERROR(F5/F4,\"\")","v":""}]
[null,"Veiledning",null,null,"Dagens dato",{"$f":"TODAY()","v":"2023-04-24"}]
[null,null,null,null,null,null,null,null,"Kontrakts-periode",null,null,null,null,null,"Kontrakts-administrasjon",null,null,null,null,null,"Leverandør- detaljer",null,null,null,null,"Kontrakts-forvalter",null,null,null,"Annet"]
["X","#","Kontraktsnr. eller saksnummer","Innkjøpskategori","Underkategori","Navn på kontrakten","Verdi (estimert, årlig i millioner)","Totalverdi (estimert, hele kontrakssyklus)","X","Kontrakt startdato","År - start","Kontrakt utløpsdato","År - slutt","Kontrakts lengde (ca måneder)","X","Status","Type avtale","Utløpsdato for opsjoner","Oppsigelsestid (ant. måneder)","Sannsynlig år (ÅÅÅÅ) ankaffelsesprosess neste gang","X","Leverandør navn","Leverandør kontaktperson","Leverandør telefon","Leverandør epost","X","Hvilken avdeling forvalter kontrakten?","Kontaktperson hos oss","Kontaktpersons epost","X","Hvor er orginalkontrakt lagret?","URL til kontrakt","Finnes det en egen kontrakts-oppsummering?","Ansvarlig anskaffelses-prosessen","Ansvarlig neste anskaffelses-prosess","Kommentarer til saker som vil påvirke forlengelse etc.","SLUTT"]
[null,"Eksempel",null,"Eiendom","Renhold 2",null,40,{"$f":"G9*N9/12","v":80},null,"2011-12-30",{"$f":"YEAR(J9)","v":2011},"2013-12-29",{"$f":"YEAR(L9)","v":2013},{"$f":"(L9-J9)*12/365","v":24},null,"Aktiv",null,"2015-12-30",null,{"$f":"M9","v":2013}]
[null,{"$f":"B7+1","v":1},null,null,null,null,null,{"$f":"G10*N10/12","v":0},null,"2011-12-31",2011,"2013-12-30",2013,{"$f":"(L10-J10)*12/365","v":24},null,"Aktiv",null,"2015-12-31",null,2013]
[null,1,null,"Eiendomsdrift","Facility management",null,32,64,null,"2012-01-01",2012,"2013-12-31",2013,24,null,"Aktiv",null,null,null,{"$f":"M11","v":2013}]
[null,2,null,"Eiendomsdrift","Kantine",null,6,11.983561643835616,null,"2014-01-01",2014,"2015-12-31",2015,23.967123287671232,null,"Aktiv",null,null,null,{"$f":"M12","v":2015}]
[null,3,null,"Eiendomsdrift","Kontorinventar",null,13,12.323287671232876,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,{"$f":"M13","v":2015}]
[null,4,null,"Eiendomsdrift","Renhold",null,10,19.479452054794518,null,"2014-01-22",2014,"2016-01-03",2016,23.375342465753423,null,"Aktiv",null,null,null,2016]
[null,5,null,"IKT","Software inkl. vedlikehold",null,32,94.421917808219177,null,"2014-01-22",2014,"2017-01-03",2017,35.408219178082192,null,"Aktiv",null,null,null,2017]
[null,6,null,"IKT","Hardware",null,10,9.4794520547945211,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,2015]
[null,7,null,"Personell","Hotellarrangementer",null,81,76.783561643835625,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,2015]
[null,8,null,"Personell","Møter, mat og underholdning",null,5,4.7397260273972606,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Terminert",null,null,null,2015]
[null,9,null,"Personell","Reise",null,34,32.230136986301368,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,2015]
[null,10,null,"Kontor og admin.","Trykksaker",null,4,3.7917808219178082,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,2015]
[null,11,null,"Kontor og admin.","Kontormateriale",null,33,31.282191780821918,null,"2014-01-22",2014,"2015-01-03",2015,11.375342465753425,null,"Aktiv",null,null,null,2015]
[null,12,null,"Rådgivning","IKT konsulenter",null,34,100.32328767123288,null,"2015-01-22",2015,"2018-01-03",2018,35.408219178082192,null,"Aktiv",null,null,null,2018]
[null,13,null,"Rådgivning","Ledelsesrådgivning",null,6,11.704109589041096,null,"2012-01-22",2012,"2014-01-03",2014,23.408219178082192,null,"Aktiv",null,null,null,2014]
[null,14,null,"Bemanning","Vikartjenester",null,32,30.421917808219177,null,"2012-01-22",2012,"2013-01-03",2013,11.408219178082192,null,"Aktiv",null,null,null,2013]
[null,15,null,"Bemanning","Rekruttering",null,2,5.9013698630136986,null,"2015-01-22",2015,"2018-01-03",2018,35.408219178082192,null,"Aktiv",null,null,null,2018]
[null,16,null,null,null,null,null,0,null,"2016-02-14",2016,"2018-02-14",2018,24.032876712328768,null,"Aktiv",null,null,null,2018]
[null,17,null,null,null,null,null,0,null,"2016-02-14",2016,"2019-02-14",2019,36.032876712328765,null,"Aktiv",null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(J73)","v":1900},null,{"$f":"YEAR(L73)","v":1900},0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,{"$f":"(L74-J74)*12/365","v":0},null,"Aktiv",null,null,null,1900]

{"sheet":"Kontraktsyklus","index":2,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Kontraktssyklus - hvilket år bør anskaffelsesprosess for de største kategorier gjennomføres?"]
[null,null,null,null,null,null,null,null,"Steg 1: Velg første år i kontraktssyklus\nSteg 2: Trykk deretter oppdateringsknapp"]
[null,null,null,"Veiledning",null,null,null,null,2014]
[]
[null,null,{"$f":"CONCATENATE(\"Kontrakt utløper \",D5)","v":"Kontrakt utløper 2017"},{"$f":"$I$3+3","v":2017},null,null,null,null,null,{"$f":"CONCATENATE(\"Kontrakt utløper \",K5)","v":"Kontrakt utløper 2014"},{"$f":"I3","v":2014}]
[null,null,"Største underkategorier","Verdi",null,null,null,null,null,"Største underkategorier","Verdi"]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C7)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C7)-ROW(C$6),1))","v":"Software inkl. vedlikehold"},{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":94.421917808219177},{"$f":"IFERROR(D7/D$22,\"\")","v":1},null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J7)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J7)-ROW(J$6),1))","v":"Ledelsesrådgivning"},{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":11.704109589041096},{"$f":"IFERROR(K7/K$22,\"\")","v":1}]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C8)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C8)-ROW(C$6),1))","v":""},{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},{"$f":"IFERROR(D8/D$22,\"\")","v":""},null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J8)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J8)-ROW(J$6),1))","v":""},{"$f":"IF(J8=\"\",\"\",VLOOKUP(J8,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},{"$f":"IFERROR(K8/K$22,\"\")","v":""}]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C9)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C9)-ROW(C$6),1))","v":""},{"$f":"IF(C9=\"\",\"\",VLOOKUP(C9,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J9)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J9)-ROW(J$6),1))","v":""},{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C10)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C10)-ROW(C$6),1))","v":""},{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J10)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J10)-ROW(J$6),1))","v":""},{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C11)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C11)-ROW(C$6),1))","v":""},{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J11)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J11)-ROW(J$6),1))","v":""},{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C12)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C12)-ROW(C$6),1))","v":""},{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J12)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J12)-ROW(J$6),1))","v":""},{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C13)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C13)-ROW(C$6),1))","v":""},{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J13)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J13)-ROW(J$6),1))","v":""},{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C14)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C14)-ROW(C$6),1))","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J14)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J14)-ROW(J$6),1))","v":""},{"$f":"IF(J14=\"\",\"\",VLOOKUP(J14,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C15)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C15)-ROW(C$6),1))","v":""},{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J15)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J15)-ROW(J$6),1))","v":""},{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C16)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C16)-ROW(C$6),1))","v":""},{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J16)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J16)-ROW(J$6),1))","v":""},{"$f":"IF(J16=\"\",\"\",VLOOKUP(J16,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C17)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C17)-ROW(C$6),1))","v":""},{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J17)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J17)-ROW(J$6),1))","v":""},{"$f":"IF(J17=\"\",\"\",VLOOKUP(J17,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C18)-ROW(C$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$J$12:$K$33,ROW(C18)-ROW(C$6),1))","v":""},{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J18)-ROW(J$6),1)=0,\"\",INDEX(Backend_database_med_pivot!$A$12:$B$33,ROW(J18)-ROW(J$6),1))","v":""},{"$f":"IF(J18=\"\",\"\",VLOOKUP(J18,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":""},""]
[null,null,"Verdi - største underkat.",{"$f":"SUM(D7:D18)","v":94.421917808219177},null,null,null,null,null,"Verdi - største underkat.",{"$f":"SUM(K7:K18)","v":11.704109589041096}]
[null,null,"Andel de største av total:",null,{"$f":"D19/D22","v":1},null,null,null,null,"Andel de største av total:",null,{"$f":"K19/K22","v":1}]
[]
[null,null,"Verdi alle som utløper:",{"$f":"Backend_database_med_pivot!K4","v":94.421917808219177},null,null,null,null,null,"Verdi alle som utløper:",{"$f":"Backend_database_med_pivot!B4","v":11.704109589041096}]
[null,null,{"$f":"CONCATENATE(\"Antall som utløper \",D5)","v":"Antall som utløper 2017"},{"$f":"Backend_database_med_pivot!J4","v":1},null,null,null,null,null,{"$f":"CONCATENATE(\"Antall som utløper \",K5)","v":"Antall som utløper 2014"},{"$f":"Backend_database_med_pivot!A4","v":1}]
[null,null,{"$f":"ROUND(D24,0)","v":94},{"$f":"Backend_database_med_pivot!K4","v":94.421917808219177},null,null,null,null,null,{"$f":"ROUND(K24,0)","v":12},{"$f":"Backend_database_med_pivot!B4","v":11.704109589041096}]
[null,null,{"$f":"CONCATENATE(\"Kontrakt utløper \",D25)","v":"Kontrakt utløper 2016"},{"$f":"$I$3+2","v":2016},null,null,null,null,null,{"$f":"CONCATENATE(\"Kontrakt utløper \",K25)","v":"Kontrakt utløper 2015"},{"$f":"$I$3+1","v":2015}]
[null,null,"Største underkategorier","Verdi",null,null,null,null,null,"Største underkategorier","Verdi"]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C27)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C27)-ROW(C$26),1))","v":"Renhold"},{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":19.479452054794518},{"$f":"IFERROR(D27/D$42,\"\")","v":1},null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J27)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J27)-ROW(J$26),1))","v":"Hotellarrangementer"},{"$f":"IF(J27=\"\",\"\",VLOOKUP(J27,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":76.783561643835625},{"$f":"IFERROR(K27/K$42,\"\")","v":0.43167395724231405}]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C28)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C28)-ROW(C$26),1))","v":""},{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},{"$f":"IFERROR(D28/D$42,\"\")","v":""},null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J28)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J28)-ROW(J$26),1))","v":"Reise"},{"$f":"IF(J28=\"\",\"\",VLOOKUP(J28,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":32.230136986301368},{"$f":"IFERROR(K28/K$42,\"\")","v":0.18119647587948981}]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C29)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C29)-ROW(C$26),1))","v":""},{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J29)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J29)-ROW(J$26),1))","v":"Kontormateriale"},{"$f":"IF(J29=\"\",\"\",VLOOKUP(J29,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":31.282191780821918},0.17586716776538719]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C30)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C30)-ROW(C$26),1))","v":""},{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J30)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J30)-ROW(J$26),1))","v":"Kontorinventar"},{"$f":"IF(J30=\"\",\"\",VLOOKUP(J30,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":12.323287671232876},6.9281005483334338E-2]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C31)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C31)-ROW(C$26),1))","v":""},{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J31)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J31)-ROW(J$26),1))","v":"Kantine"},{"$f":"IF(J31=\"\",\"\",VLOOKUP(J31,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":11.983561643835616},6.7371080032037442E-2]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C32)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C32)-ROW(C$26),1))","v":""},{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J32)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J32)-ROW(J$26),1))","v":"Hardware"},{"$f":"IF(J32=\"\",\"\",VLOOKUP(J32,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":9.4794520547945211},5.3293081141026419E-2]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C33)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C33)-ROW(C$26),1))","v":""},{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J33)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J33)-ROW(J$26),1))","v":"Trykksaker"},{"$f":"IF(J33=\"\",\"\",VLOOKUP(J33,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":3.7917808219178082},2.1317232456410568E-2]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C34)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C34)-ROW(C$26),1))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(C34,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J34)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J34)-ROW(J$26),1))","v":""},{"$f":"IF(J34=\"\",\"\",VLOOKUP(J34,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C35)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C35)-ROW(C$26),1))","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(C35,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J35)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J35)-ROW(J$26),1))","v":""},{"$f":"IF(J35=\"\",\"\",VLOOKUP(J35,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C36)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C36)-ROW(C$26),1))","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(C36,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J36)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J36)-ROW(J$26),1))","v":""},{"$f":"IF(J36=\"\",\"\",VLOOKUP(J36,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C37)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C37)-ROW(C$26),1))","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(C37,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J37)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J37)-ROW(J$26),1))","v":""},{"$f":"IF(J37=\"\",\"\",VLOOKUP(J37,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},""]
[null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C38)-ROW(C$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$G$12:$H$33,ROW(C38)-ROW(C$26),1))","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(C38,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":""},"",null,null,null,null,{"$f":"IF(INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J38)-ROW(J$26),1)=0,\"\",INDEX(Backend_database_med_pivot!$D$12:$E$36,ROW(J38)-ROW(J$26),1))","v":""},{"$f":"IF(J38=\"\",\"\",VLOOKUP(J38,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},""]
[null,null,"Verdi - største underkat.",{"$f":"SUM(D27:D38)","v":19.479452054794518},null,null,null,null,null,"Verdi - største underkat.",{"$f":"SUM(K27:K38)","v":177.87397260273977}]
[null,null,"Andel de største av total:",null,{"$f":"D39/D42","v":1},null,null,null,null,"Andel de største av total:",null,{"$f":"K39/K42","v":1}]
[]
[null,null,"Verdi alle som utløper:",{"$f":"Backend_database_med_pivot!H4","v":19.479452054794518},null,null,null,null,null,"Verdi alle som utløper:",{"$f":"Backend_database_med_pivot!E4","v":177.87397260273977}]
[null,null,{"$f":"CONCATENATE(\"Antall som utløper \",D25)","v":"Antall som utløper 2016"},{"$f":"Backend_database_med_pivot!G4","v":1},null,null,null,null,null,{"$f":"CONCATENATE(\"Antall som utløper \",K25)","v":"Antall som utløper 2015"},{"$f":"Backend_database_med_pivot!D4","v":7}]
[null,null,{"$f":"ROUND(D44,0)","v":19},{"$f":"Backend_database_med_pivot!H4","v":19.479452054794518},null,null,null,null,null,{"$f":"ROUND(K44,0)","v":178},{"$f":"Backend_database_med_pivot!E4","v":177.87397260273977}]

{"sheet":"Backend_database_med_pivot","index":3,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Dette arket er skjult i excel-arbeidsboken",null,null,null,null,null,null,null,null,null,null,null,null,null,"Årslutt_kontraktsregister"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MIN",{"$f":"MIN(Kontraktsregister!T12:T1048576)","v":1900},2013]
[{"$f":"Kontraktsyklus!K5","v":2014},null,null,{"$f":"Kontraktsyklus!K25","v":2015},null,null,{"$f":"Kontraktsyklus!D25","v":2016},null,null,{"$f":"Kontraktsyklus!D5","v":2017},null,null,"MAX",{"$f":"MAX(Kontraktsregister!T12:T1048576)","v":2019},{"$f":"IF(O2<$N$3-3,O2+1,\"\")","v":2014}]
[{"$f":"COUNTA(A12:A200)","v":1},{"$f":"SUM(B12:B200)","v":11.704109589041096},null,{"$f":"COUNTA(D12:D200)","v":7},{"$f":"SUM(E12:E200)","v":177.87397260273977},null,{"$f":"COUNTA(G12:G200)","v":1},{"$f":"SUM(H12:H200)","v":19.479452054794518},null,{"$f":"COUNTA(J12:J200)","v":1},{"$f":"SUM(K12:K200)","v":94.421917808219177},null,null,null,{"$f":"IF(O3<$N$3-3,O3+1,\"\")","v":2015}]
[{"$f":"COUNTIF(Kontraktsregister!$T:$T,C_år1)","v":1},null,null,{"$f":"COUNTIF(Kontraktsregister!$T:$T,Andre_år)","v":8},null,null,{"$f":"COUNTIF(Kontraktsregister!$T:$T,C_år3)","v":1},null,null,{"$f":"COUNTIF(Kontraktsregister!$T:$T,Fjerde_år)","v":1},{"$f":"COUNTIF(A5:J5,0)","v":0},null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["År - slutt",2014,null,"År - slutt",2015,null,"År - slutt",2016,null,"År - slutt",2017,null,null,null,""]
["Status","Aktiv",null,"Status","Aktiv",null,"Status","Aktiv",null,"Status","Aktiv",null,null,null,""]
["Liste med leverandører",null,null,"Liste med leverandører",null,null,"Liste med leverandører",null,null,"Liste med leverandører",null,null,null,null,""]
["Sum of Totalverdi (estimert, hele kontrakssyklus)",null,null,"Sum of Totalverdi (estimert, hele kontrakssyklus)",null,null,"Sum of Totalverdi (estimert, hele kontrakssyklus)",null,null,"Sum of Totalverdi (estimert, hele kontrakssyklus)",null,null,null,null,""]
["Underkategori","Totalt",null,"Underkategori","Totalt",null,"Underkategori","Totalt",null,"Underkategori","Totalt",null,null,null,""]
["Ledelsesrådgivning",11.704109589041096,null,"Hotellarrangementer",76.783561643835625,null,"Renhold",19.479452054794518,null,"Software inkl. vedlikehold",94.421917808219177,null,null,null,""]
[null,null,null,"Reise",32.230136986301368]
[null,null,null,"Kontormateriale",31.282191780821918]
[null,null,null,"Kontorinventar",12.323287671232876]
[null,null,null,"Kantine",11.983561643835616]
[null,null,null,"Hardware",9.4794520547945211]
[null,null,null,"Trykksaker",3.7917808219178082]