{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduksjon","Kontraktsregister","Kontraktsyklus","Ark1","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":4,"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 rettleiing - Kontraktsregister"]
[]
[null,"Føremålet med verktøyet\n",null,"                                                                                        Oppdatert desember 2017"]
[null,"Verksemda bør ha kontroll på kontraktane sine for å kunne ha oversikt over forpliktingar og moglegheiter.\nKontraktsregisteret stør opp om ein god struktur og samlar nøkkelinformasjon om kontraktane til verksemda - på ein stad."]
[]
[null,"Kontraktsyklus gir oversikt over omsetning og talet på kontraktar over ein fireårsperiode. Primært skal det støtte planlegging i samband med framtidige anskaffingsprosessar. Hovudbrukar vil derfor vere innkjøpsansvarleg/innkjøpsavdelinga for verksemda."]
[]
[null,"Rettleiing - Generelt: \nFelt i gult er for utfylling.\nPlasser musepeikaren over celler med raudt hjørne for å sjå kommentarar med utdjupande informasjon."]
[]
[null,"Rettleiing Kontraktsregister\nNår ein ny kontrakt er inngått, bør han registrerast i kontraktsregisteret. Første steg er å fylle inn grunnleggande informasjon om kontrakten, vare- /tenestegruppe, og estimat av omsetning i Kolonne B-H. Desse dataa kan hentast frå ein innkjøpsanalyse eller frå rekneskap."]
[null,"Dei etterfølgande kolonnane er grupperte i fem område som skal oppsummere detaljar kring kontrakten. Det går å skjule eller vise kolonnar ved å nytte +-teikn\nNokre av nøkkeldataa frå kontraktsregisteret vert brukt som kjeldedata for årshjulet. Desse cellene er markerte med ein klarare gul farge. "]
[null,"Rettleiing Kontraktsyklus:\n'Vel frå rullegardinmeny første år i kontraktsyklus f.eks. 2014. Klikk deretter på knappen \"Oppdatert med data frå kontraktsregisteret\".\nFor at kontraktsyklus skal gi verdi for brukar, må  \"Underkategori namn\", \"Totalverdi\", \"Status (=verdi \"Aktiv\") og \"Sannsynleg dato for anskaffingsprosess\" i kontraktsregisteret vere utfylt riktig."]
[null,"Det må alltid vere ein utløpsdato (Kolonne T i Kontraktsregister), skal årshjulet fungere. 'Kontraktar med status sett til \"Terminert\", vil ikkje verte inkluderte i kontraktsyklusen"]
[null,"Føremålet med kontraktsyklus er at verksemda skal sjå, og kunne planlegge, når ein ny anskaffingsprosess skal startast. Det er derfor viktig å vurdere eksisterande kontraktar i god tid og ta omsyn til eventuelle opsjonar. Dersom verksemda ikkje er nøgd med ein kontrakt/leverandør, bør dette noterast slik at opsjonar ikkje vert forlenga automatisk utan reforhandling eller ny konkurranseutsetting.  "]

{"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,"Ansvarleg for kontraktsregister","\"Fyll inn namn\"","% under kontrakt og i dette registeret:"]
[null,null,null,null,"Estimert årleg totalverdi for anskaffingane i verksemda (100 %)","\"Fyll inn verdi\""]
[null,null,null,null,"Estimert årleg totalverdi for kontraktar i dette registeret","\"Fyll inn verdi\"",{"$f":"IFERROR(F5/F4,\"\")","v":""}]
[null,"Rettleiing",null,null,"Dagens dato",{"$f":"TODAY()","v":"2023-04-25"}]
[null,null,null,null,null,null,null,null,"Kontrakts-periode",null,null,null,null,null,"Kontrakts-administrasjon",null,null,null,null,null,"Leverandør-detaljar",null,null,null,null,"Kontrakts-forvaltar",null,null,null,"Anna"]
["X",0,"Kontraktsnr. eller saksnummer","Innkjøpskategori","Underkategori","Namn på kontrakten","Verdi (estimert, årleg i millionar)","Totalverdi (estimert, heile kontraktsyklus)","X","Kontrakt startdato","År - start","Kontrakt utløpsdato","År - slutt","Kontraktslengd (ca månader)","X","Status","Type avtale","Utløpsdato for opsjonar","Oppseiingstid (tal månader)","Sannsynleg år (ÅÅÅÅ) anskaffingsprosess neste gong","X","Leverandør namn","Leverandør kontaktperson","Leverandør telefon","Leverandør e-post","X","Kva for ei avdeling forvaltar kontrakten?","Kontaktperson hos oss","E-post til kontaktperson","X","Kvar er originalkontrakt lagra?","Vedlegg 2 til kontrakt.","Finst det ei eiga kontrakts-oppsummering?","Ansvarleg anskaffings-prosessen","Ansvarleg neste anskaffings-prosess","Kommentarar til saker som vil påverke forlenging etc.","SLUTT"]
[null,{"$f":"B8+1","v":1},null,null,"Eksempel 1",null,10,{"$f":"G9*N9/12","v":30},null,"2011-12-30",{"$f":"YEAR(J9)","v":2011},"2014-12-29",{"$f":"YEAR(L9)","v":2014},{"$f":"(L9-J9)*12/365","v":36},null,"Aktiv",null,null,null,{"$f":"M9","v":2014}]
[null,{"$f":"B9+1","v":2},null,null,"Eksempel 2",null,11,{"$f":"G10*N10/12","v":32.969863013698635},null,"2012-12-30",null,"2015-12-29",2015,{"$f":"(L10-J10)*12/365","v":35.967123287671235},null,"Aktiv",null,null,null,2015]
[null,3,null,null,"Eksempel 3",null,12,36,null,"2013-12-30",null,"2016-12-29",2016,36,null,"Aktiv",null,null,null,{"$f":"M11","v":2016}]
[null,4,null,null,"Eksempel 4",null,13,39,null,"2014-12-30",null,"2017-12-29",2017,36,null,"Aktiv",null,null,null,{"$f":"M12","v":2017}]
[null,5,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,{"$f":"M13","v":1900}]
[null,6,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,7,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,8,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,9,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,10,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,11,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,12,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,13,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,14,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,15,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,16,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,17,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,18,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,19,null,null,null,null,null,null,null,null,null,null,1900,0,null,"Aktiv",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,null,1900,null,1900,{"$f":"(L28-J28)*12/365","v":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,"Kontraktsyklus - kva for eit år bør anskaffingsprosess for dei største kategoriane gjennomførast?"]
[null,null,null,null,null,null,null,null,"Steg 1: Vel første år i kontraktsyklus\nSteg 2: Trykk deretter oppdateringsknapp"]
[null,null,null,"Rettleiing",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 underkategoriar","Verdi",null,null,null,null,null,"Største underkategoriar","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":"Eksempel 4"},{"$f":"IF(C7=\"\",\"\",VLOOKUP(C7,Backend_database_med_pivot!$J$12:$K$42,2,FALSE))","v":39},{"$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":"Eksempel 1"},{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,Backend_database_med_pivot!$A$12:$B$42,2,FALSE))","v":30},{"$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":39},null,null,null,null,null,"Verdi - største underkat.",{"$f":"SUM(K7:K18)","v":30}]
[null,null,"Del dei største av total:",null,{"$f":"D19/D22","v":1},null,null,null,null,"Del dei største av total:",null,{"$f":"K19/K22","v":1}]
[]
[null,null,"Verdi alle som går ut:",{"$f":"Backend_database_med_pivot!K4","v":39},null,null,null,null,null,"Verdi alle som går ut:",{"$f":"Backend_database_med_pivot!B4","v":30}]
[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":39},{"$f":"Backend_database_med_pivot!K4","v":39},null,null,null,null,null,{"$f":"ROUND(K24,0)","v":30},{"$f":"Backend_database_med_pivot!B4","v":30}]
[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 underkategoriar","Verdi",null,null,null,null,null,"Største underkategoriar","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":"Eksempel 3"},{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Backend_database_med_pivot!$G$12:$H$42,2,FALSE))","v":36},{"$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":"Eksempel 2"},{"$f":"IF(J27=\"\",\"\",VLOOKUP(J27,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":32.969863013698635},{"$f":"IFERROR(K27/K$42,\"\")","v":1}]
[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":""},{"$f":"IF(J28=\"\",\"\",VLOOKUP(J28,Backend_database_med_pivot!$D$12:$E$42,2,FALSE))","v":""},{"$f":"IFERROR(K28/K$42,\"\")","v":""}]
[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":""},{"$f":"IF(J29=\"\",\"\",VLOOKUP(J29,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(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":""},{"$f":"IF(J30=\"\",\"\",VLOOKUP(J30,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(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":""},{"$f":"IF(J31=\"\",\"\",VLOOKUP(J31,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(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":""},{"$f":"IF(J32=\"\",\"\",VLOOKUP(J32,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(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":""},{"$f":"IF(J33=\"\",\"\",VLOOKUP(J33,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(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":36},null,null,null,null,null,"Verdi - største underkat.",{"$f":"SUM(K27:K38)","v":32.969863013698635}]
[null,null,"Del dei største av total:",null,{"$f":"D39/D42","v":1},null,null,null,null,"Del dei største av total:",null,{"$f":"K39/K42","v":1}]
[]
[null,null,"Verdi alle som går ut:",{"$f":"Backend_database_med_pivot!H4","v":36},null,null,null,null,null,"Verdi alle som går ut:",{"$f":"Backend_database_med_pivot!E4","v":32.969863013698635}]
[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":1}]
[null,null,{"$f":"ROUND(D44,0)","v":36},{"$f":"Backend_database_med_pivot!H4","v":36},null,null,null,null,null,{"$f":"ROUND(K44,0)","v":33},{"$f":"Backend_database_med_pivot!E4","v":32.969863013698635}]

{"sheet":"Ark1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Backend_database_med_pivot","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"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":2017},{"$f":"IF(O2<$N$3-3,O2+1,\"\")","v":2014}]
[{"$f":"COUNTA(A12:A200)","v":1},{"$f":"SUM(B12:B200)","v":30},null,{"$f":"COUNTA(D12:D200)","v":1},{"$f":"SUM(E12:E200)","v":32.969863013698635},null,{"$f":"COUNTA(G12:G200)","v":1},{"$f":"SUM(H12:H200)","v":36},null,{"$f":"COUNTA(J12:J200)","v":1},{"$f":"SUM(K12:K200)","v":39},null,null,null,{"$f":"IF(O3<$N$3-3,O3+1,\"\")","v":""}]
[{"$f":"COUNTIF(Kontraktsregister!$T:$T,C_år1)","v":1},null,null,{"$f":"COUNTIF(Kontraktsregister!$T:$T,Andre_år)","v":1},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,""]
[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","Total",null,"Underkategori","Total",null,"Underkategori","Total",null,"Underkategori","Total",null,null,null,""]
["Eksempel 1",30,null,"Eksempel 2",32.969863013698635,null,"Eksempel 3",36,null,"Eksempel 4",39,null,null,null,""]