{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Tabeller","Uppdragsforskning","Uppföljning uppdrag","Bidragsforskning","Spec-indir-kostn-inst & -proj","Uppföljning bidrag","INDI FO 2018"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Tabeller","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[{"$f":"2019","v":2019},null,0,null,-0.05]
[{"$f":"A1+1","v":2020},null,{"$f":"C1+0.01","v":0.01},null,{"$f":"E1+0.01","v":-0.04}]
[{"$f":"A2+1","v":2021},null,0.02,null,{"$f":"E2+0.01","v":-0.03}]
[2022,null,0.03,null,-1.9999999999999997E-2]
[2023,null,0.04,null,-9.9999999999999967E-3]
[2024,null,0.05,null,0]
[2025,null,6.0000000000000005E-2,null,0.01]
[2026,null,7.0000000000000007E-2,null,0.02]
[2027,null,0.08,null,0.03]
[2028,null,0.09,null,0.04]
[2029,null,9.9999999999999992E-2,null,{"$f":"E10+0.01","v":0.05}]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]

{"sheet":"Uppdragsforskning","index":1,"n_rows":161,"n_cols":21,"rows_kept":161,"cut":false,"hidden":true,"merged":[[57,7,57,8],[57,9,57,10],[110,9,110,10],[67,7,67,8],[70,2,70,5],[71,2,71,5],[72,2,72,5],[73,2,73,5],[25,20,38,25],[2,20,24,25],[117,11,117,12],[117,13,117,14],[117,15,117,16],[78,7,78,8],[78,9,78,10],[78,11,78,12],[78,13,78,14],[78,15,78,16],[57,15,57,16],[93,15,93,16],[87,15,87,16],[82,15,82,16],[82,13,82,14],[44,7,44,8],[44,9,44,10],[44,11,44,12],[110,15,110,16],[140,20,161,25],[136,6,136,7],[101,13,101,14],[101,7,101,8],[101,9,101,10],[101,11,101,12],[136,9,136,10],[74,2,74,5],[75,2,75,5],[76,2,76,5],[87,7,87,8],[87,9,87,10],[82,7,82,8],[101,15,101,16],[110,11,110,12],[93,11,93,12],[93,13,93,14],[99,11,99,12],[120,20,138,25],[117,7,117,8],[117,9,117,10],[110,13,110,14],[99,2,99,6],[102,20,112,25],[105,2,105,5],[106,2,106,5],[101,2,101,4],[113,20,119,25],[114,2,114,5],[110,2,110,4],[110,7,110,8],[107,2,107,5],[99,15,99,16],[99,7,99,8],[99,9,99,10],[40,20,40,24],[41,20,64,25],[66,20,79,25],[80,20,101,25],[94,2,94,5],[88,2,88,4],[89,2,89,4],[91,2,91,4],[90,2,90,4],[84,2,84,4],[85,2,85,4],[93,7,93,8],[93,9,93,10],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[54,3,54,4],[59,2,59,5],[60,2,60,5],[55,3,55,4],[53,3,53,4],[52,3,52,4],[51,3,51,4],[87,11,87,12],[87,13,87,14],[99,13,99,14],[63,13,63,14],[63,15,63,16],[67,13,67,14],[57,13,57,14],[57,11,57,12],[95,2,95,5],[96,2,96,5],[97,2,97,5],[78,2,78,6],[67,9,67,10],[67,15,67,16],[67,11,67,12],[82,11,82,12],[63,9,63,10],[63,11,63,12],[68,2,68,5],[69,2,69,5],[82,9,82,10],[63,2,63,6],[63,7,63,8],[83,2,83,4],[5,1,20,17],[45,3,45,4],[46,3,46,4],[41,13,41,14],[35,3,35,4],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,15,41,16],[34,3,34,4],[33,3,33,4],[44,13,44,14],[44,15,44,16]]}
[null,"UPPDRAGSFORSKNING - FULL KOSTNADSTÄCKNINGSKALKYL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instruktioner\n\nGenerellt\nMed knappen under rubriken väljs typ av mall, uppdrag / bidragskalkylmall. Det går alltid att hoppa mellan olika mallar utan att förlora inmatade uppgifter.\n\nDe vita cellerna i mallen fylls i med värden och de färgade cellerna är beräkningar som filen gör automatiskt. Namn / beskrivningar som är ifyllda exempel bör raderas.\n\nGrupperingarna / plusknapparna (1, 2 och 3) ute till vänster i filen gör det möjligt att komprimera och expandera kostnads- / intäktsdetaljerna. Grupperingen / plusknappen längst upp (ovanför R kolumnen) ger utökade antal år.\n\nVid behov kan ytterligare rader och även kolumner (för år) infogas, men då med viss försiktighet då formler inte följer med automatiskt. Vid behov av ytterligare rader är rekommenderat att kopiera en hel rad  i mitten av de kostnader / intäkter där behov av ytterligare poster uppstår och sedan infoga hela den kopierade raden på samma rad. Vid behov av ytterligare år rekommenderas kontakt med EA eller att två seprata mallar nyttjas för uträkning men med olika projekt start år.\n\nOmf.%  innebär omfattning av heltid\nNyttj % innebär nyttjandegrad av resursen i procent\nFörbr % innebär förbrukningsgrad av resursen i procent\n"]
[]
[]
[null,"Inledning för uppdrag\n\nDenna mall ska enbart nyttjas internt för beräkning av pris för uppdrag inom forskning. Syftet med att uppdragsforskningsverksamheten ska nyttja denna modell är för att prissättningen ska leda till att full kostnadstäckning uppnås. Modellen är också godkänd av Ekonomistyrningsverket (ESV) via samråd som förnyas vartannat år. Samtliga uppdragskalkyler som överskrider 100 000 kr ska skrivas under av prefekt, eller av den till vilken prefekten delegerat beslutsrätten, samt av universitetsdirektören. I dessa fall ska även ett exemplar av kalkylen diarieföras och sparas.\n\nEnligt § 3 Avgiftsförordning (1992:191) får Karolinska Institutet (KI) endast ta ut avgifter för varor och/eller tjänster som myndigheten tillhandahåller om det följer av lag eller förordning eller av ett särskilt beslut av regeringen. Enligt regleringsbrevet som är en årlig skrivelse och styrande dokument från riksdagen får KI bedriva uppdragsforskning. Det ekonomiska målet är bestämt i regleringsbrevet till full kostnadstäckning. \n\nFull kostnadstäckning innebär enkelt uttryckt att verksamheten varken får generera ett överskott eller underskott över tid. Detta innebär i praktiken att målet för varje enskilt uppdrags resultat bör vara +/-noll vid uppdragets slut eller då samtliga till uppdraget hänförliga kostnader har allokerats (exempelvis; avvecklingskostnader eller avskrivningar kan kostnadsföras även efter åtagandet har fullföljts). Det är även viktigt att denna verksamhet inte bedrivs med underskott, d.v.s. att KI inte skulle få täckning för samtliga kostnader av beställaren. Därav behöver man uppskatta de förväntade kostnaderna med god eftertanke. Detta får dock heller ej leda till att uppdragsforskningsverksamheten bedrivs med ett överskott som överstiger 10 procent av omsättningen mätt i innevarande års intäkter."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"GRUNDLÄGGANDE UPPGIFTER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundläggande uppgifter\nHär väljs institutionskod i rullistan som påverkar de indirekta kostnaderna (INDI) både i denna mall men även värden i specifikations- och uppföljningsflikar.\n\nInnevarande år kommer upp automatiskt, men val av projektets start år påverkar Index av personal-, drift-, och lokalkostnader.\n\nFör uppdrag redogörs även om projektet är internt, statligt, externt eller övrigt uppdrag och där moms av annan anldening ska exkluderas.\n\nResten av fälten är fritextfält, men observera att framförallt projektnumret och även de andra fält hämtas upp av de övriga bladen."]
[]
[null,null,"Institutionskod"]
[null,null,"Innevrande år",{"$f":"Tabeller!$A$1","v":2019}]
[null,null,"Projektets start år"]
[]
[null,null,{"$f":"IF(LEFT(D28,2)=\"UF\",\"\",\"Internt/Statligt/Externt\")","v":"Internt/Statligt/Externt"}]
[]
[null,null,"Projektledare/-ansvarig"]
[null,null,"Projektnummer - UBW"]
[null,null,"Beskrivnig av projektet"]
[]
[]
[]
[null,null,{"$f":"\"PROJEKTKOSTNADER\"&\" - \"&LEFT($B$1,(LEN($B$1)-41))","v":"PROJEKTKOSTNADER - UPPDRAG"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personalkostnader"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Länk till stöd för beräkning av debiterbar månadsersättning"]
[null,null,"A. Personalkostnader",null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H42+1,\"\")","v":""},null,{"$f":"IFERROR(J42+1,\"\")","v":""},null,{"$f":"IFERROR(L42+1,\"\")","v":""},null,{"$f":"IFERROR(N42+1,\"\")","v":""},null,null,null,null,"Beräkningen baserar sig på total månadsersättning och omfattning av heltid i projektet.\n\nFör bidragsforksning nyttjas bruttolön och standardtiden anges automatiskt, vilket motsvarar 1680 timmar per år på KI.\n\nFör externa uppdrag ska månadsersättning baseras på debiterbar tid. Bruttolönen behöver beräknas om till debiterbar månadsersättning. Detta är högre än bruttolönen då avräkning för indirekt tid eller produktionsbortfall såsom egen- administration, utbildning och utvecklingsarbete görs. Mallen utgår ifrån en standard produktionsbortfall om 480 timmar, men denna kan enkelt justeras genom att ange nya siffror i beräkningsunderlaget längst ner i bladet. (se även länk ovan eller i rubriken för månadsersättning)\n\nIndex för personalkostnader är satt till 2% ökning per år.\n\n\n\n\n\nLKP\nLKP (Lönekostnadspålägg) är en kostnad som de flesta arbetsgivare har för den anställda utöver den individuella bruttolönen som den anställda har.\nDetta är en standardsats som revideras centralt årligen."]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Se fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H45+1,\"\")","v":""},null,{"$f":"IFERROR(J45+1,\"\")","v":""},null,{"$f":"IFERROR(L45+1,\"\")","v":""},null,{"$f":"IFERROR(N45+1,\"\")","v":""}]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Debiterbar månadsers. (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%"]
[null,null,null,"Projektledare1",null,{"$f":"IF(H47+J47+L47+N47+P47=0,0,IF($D$32=\"Internt\",(H47+J47+L47+N47+P47)*1680,(H47+J47+L47+N47+P47)*(1680-($D$156*8))))","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*H47*((1+(MID(I$46,12,2))/100)^(H$45-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*J47*((1+(MID(K$46,12,2))/100)^(J$45-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*L47*((1+(MID(M$46,12,2))/100)^(L$45-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*N47*((1+(MID(O$46,12,2))/100)^(N$45-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*P47*((1+(MID(Q$46,12,2))/100)^(P$45-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*H48*((1+(MID(I$46,12,2))/100)^(H$45-$D$29)))),0)","v":"År saknas"},null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,0,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[]
[null,null,"Summa Personalkostnader exkl. lönekostnadspålägg (LKP)",null,null,{"$f":"SUM(F$47:F56)","v":0},{"$f":"SUM(G$47:G56)","v":0},{"$f":"SUM(I$47:I56)","v":0},null,{"$f":"SUM(K$47:K56)","v":0},null,{"$f":"SUM(M$47:M56)","v":0},null,{"$f":"SUM(O$47:O56)","v":0},null,{"$f":"SUM(Q$47:Q56)","v":0}]
[]
[null,null,"Sociala avgifter  (LKP) - 2019",null,null,null,0.52159999999999995]
[null,null,"Semestertillägg",null,null,null,1.84E-2]
[null,null,null,null,null,"LKP Total",{"$f":"SUM(G60:G61)","v":0.53999999999999992}]
[]
[null,null,"Summa personalkostnad där lönekostnadspålägg (LKP) ingår",null,null,null,null,{"$f":"H58*(1+$G62)","v":0},null,{"$f":"J58*(1+$G62)","v":0},null,{"$f":"L58*(1+$G62)","v":0},null,{"$f":"N58*(1+$G62)","v":0},null,{"$f":"P58*(1+$G62)","v":0}]
[]
[null,null,"B. Driftkostnader"]
[null,null,"B.1 Direkta driftkostnader (Lokal- och KI-interna kostnader kommer under övriga drifkostnader)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drifkostnader\nHit förs alla typer av driftkostnader som är direkt förknippade med projektet. Detta kan innefatta för projektet nödvändig litteratur, kemikalier, laboratorieutrustning, konsultkostnader, resor (inkl. brutto av eventuella skattepliktiga traktamenten).\n\nBeloppet anges som en total kostnad för projektet på respektive rad sedan anges förbrukning av resursen för respektive år som procent, 100% motsvarar alltså hela kostnaden för det året."]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Se fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H68+1,\"\")","v":""},null,{"$f":"IFERROR(J68+1,\"\")","v":""},null,{"$f":"IFERROR(L68+1,\"\")","v":""},null,{"$f":"IFERROR(N68+1,\"\")","v":""}]
[null,null,"Driftkostnader - beskrivning",null,null,null,"Kostnad att fördela ->","Förbr. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 1%\")","v":"inkl. index 1%"},"Förbr. %","inkl. index 1,0%","Förbr. %","inkl. index 1,0%","Förbr. %","inkl. index 1,0%","Förbr. %","inkl. index 1,0%"]
[null,null,"Instrument",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G70)*H70)*((1+(MID(I$69,12,2))/100)^(H$68-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G70)*J70)*((1+(MID(K$69,12,2))/100)^(J$68-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G70)*L70)*((1+(MID(M$69,12,2))/100)^(L$68-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G70)*N70)*((1+(MID(O$69,12,2))/100)^(N$68-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G70)*P70)*((1+(MID(Q$69,12,2))/100)^(P$68-$D$29)))","v":"År saknas"}]
[null,null,"Konsulttid",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Litteratur",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Djur",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Resor",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[]
[null,null,"Summa Direkta driftkostnader",null,null,null,null,{"$f":"SUM(I$70:I77)","v":0},null,{"$f":"SUM(K$70:K77)","v":0},null,{"$f":"SUM(M$70:M77)","v":0},null,{"$f":"SUM(O$70:O77)","v":0},null,{"$f":"SUM(Q$70:Q77)","v":0}]
[]
[null,null,"B.2 Övriga driftkostnader (dessa exkluderas från INDI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Övriga driftkostnader\nAvskrivningar, Lokalkostnader och interna kostnader genererar ingen INDI i den mån kalkylen inkluderar detta.\n\nAnläggningar\nAnge den kvarvarande ekonomiska livslängden och investeringskostnaden (nettofakturabelopp) eller restvärde vid befintliga anläggningar. \nNyttjandegrad kan uppskattas eller beräknas genom att ta den totala tiden som anläggningen kommer nyttjas respektive år med den totala möjliga nyttjandetiden för anläggningen per år.\n\nLokalkostnader\nHit förs alla kostnader för de lokaler som nyttjas samt eventuella kostnader för städning och gemensamma ytor. Uppgifter om ytor och kostnd erhålls oftast från institutionens administration.\n\nInterna kostnader\nHit förs interna kostnader som uppstår av produkter eller tjänster som tillhandahålls från andra delar av KI, vilket ska inkludera motpartens indirekta kostnader (INDI)"]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Se fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H83+1,\"\")","v":""},null,{"$f":"IFERROR(J83+1,\"\")","v":""},null,{"$f":"IFERROR(L83+1,\"\")","v":""},null,{"$f":"IFERROR(N83+1,\"\")","v":""}]
[null,null,"Anläggning - beskrivning",null,null,"Eko. livslängd","Investeringskostnad","Nyttj. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 0%\")","v":"inkl. index 0%"},"Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((H$83-$D$30)>=((IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2)))*1),\"*livslängd < proj-tid\",(($G85/(IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2))))*H85)*((1+(MID(I$84,12,2))/100)^(H$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((J$83-$D$30)>=((IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2)))*1),\"*livslängd < proj-tid\",(($G85/(IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2))))*J85)*((1+(MID(K$84,12,2))/100)^(J$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((L$83-$D$30)>=((IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2)))*1),\"*livslängd < proj-tid\",(($G85/(IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2))))*L85)*((1+(MID(M$84,12,2))/100)^(L$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((N$83-$D$30)>=((IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2)))*1),\"*livslängd < proj-tid\",(($G85/(IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2))))*N85)*((1+(MID(O$84,12,2))/100)^(N$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((P$83-$D$30)>=((IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2)))*1),\"*livslängd < proj-tid\",(($G85/(IF(LEN($F85)=4,LEFT($F85,1),LEFT($F85,2))))*P85)*((1+(MID(Q$84,12,2))/100)^(P$83-$D$29))),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((H$83-$D$30)>=((IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2)))*1),\"*livslängd < proj-tid\",(($G86/(IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2))))*H86)*((1+(MID(I$84,12,2))/100)^(H$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((J$83-$D$30)>=((IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2)))*1),\"*livslängd < proj-tid\",(($G86/(IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2))))*J86)*((1+(MID(K$84,12,2))/100)^(J$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((L$83-$D$30)>=((IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2)))*1),\"*livslängd < proj-tid\",(($G86/(IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2))))*L86)*((1+(MID(M$84,12,2))/100)^(L$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((N$83-$D$30)>=((IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2)))*1),\"*livslängd < proj-tid\",(($G86/(IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2))))*N86)*((1+(MID(O$84,12,2))/100)^(N$83-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((P$83-$D$30)>=((IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2)))*1),\"*livslängd < proj-tid\",(($G86/(IF(LEN($F86)=4,LEFT($F86,1),LEFT($F86,2))))*P86)*((1+(MID(Q$84,12,2))/100)^(P$83-$D$29))),0)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Se fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H88+1,\"\")","v":""},null,{"$f":"IFERROR(J88+1,\"\")","v":""},null,{"$f":"IFERROR(L88+1,\"\")","v":""},null,{"$f":"IFERROR(N88+1,\"\")","v":""}]
[null,null,"Lokalkostnader - beskrivning",null,null,"Lokal yta kvm","Kvm kostnad / år","Nyttj. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 1%\")","v":"inkl. index 1%"},"Nyttj. %","inkl. index 1%","Nyttj. %","inkl. index 1%","Nyttj. %","inkl. index 1%","Nyttj. %","inkl. index 1%"]
[null,null,"Kontor1",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F90*$G90)*H90)*((1+(MID(I$89,12,2))/100)^(H$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F90*$G90)*J90)*((1+(MID(K$89,12,2))/100)^(J$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F90*$G90)*L90)*((1+(MID(M$89,12,2))/100)^(L$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F90*$G90)*N90)*((1+(MID(O$89,12,2))/100)^(N$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F90*$G90)*P90)*((1+(MID(Q$89,12,2))/100)^(P$88-$D$29)))","v":"År saknas"}]
[null,null,"Lab1",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F91*$G91)*H91)*((1+(MID(I$89,12,2))/100)^(H$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F91*$G91)*J91)*((1+(MID(K$89,12,2))/100)^(J$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F91*$G91)*L91)*((1+(MID(M$89,12,2))/100)^(L$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F91*$G91)*N91)*((1+(MID(O$89,12,2))/100)^(N$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F91*$G91)*P91)*((1+(MID(Q$89,12,2))/100)^(P$88-$D$29)))","v":"År saknas"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F92*$G92)*H92)*((1+(MID(I$89,12,2))/100)^(H$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F92*$G92)*J92)*((1+(MID(K$89,12,2))/100)^(J$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F92*$G92)*L92)*((1+(MID(M$89,12,2))/100)^(L$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F92*$G92)*N92)*((1+(MID(O$89,12,2))/100)^(N$88-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F92*$G92)*P92)*((1+(MID(Q$89,12,2))/100)^(P$88-$D$29)))","v":"År saknas"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Se fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H94+1,\"\")","v":""},null,{"$f":"IFERROR(J94+1,\"\")","v":""},null,{"$f":"IFERROR(L94+1,\"\")","v":""},null,{"$f":"IFERROR(N94+1,\"\")","v":""}]
[null,null,"Interna kostnader och eventuell INDI-befriad verksamhet - beskrivning",null,null,null,"Kostnad att fördela ->","Förbr. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 0%\")","v":"inkl. index 0%"},"Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%"]
[null,null,"Interntjänst1, inkl. motpartens INDI",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G96)*H96)*((1+(MID(I$95,12,2))/100)^(H$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G96)*J96)*((1+(MID(K$95,12,2))/100)^(J$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G96)*L96)*((1+(MID(M$95,12,2))/100)^(L$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G96)*N96)*((1+(MID(O$95,12,2))/100)^(N$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G96)*P96)*((1+(MID(Q$95,12,2))/100)^(P$94-$D$29)))","v":"År saknas"}]
[null,null,"IT avgift 9900 kr per anställd/anknuten och år (2017)",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G97)*H97)*((1+(MID(I$95,12,2))/100)^(H$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G97)*J97)*((1+(MID(K$95,12,2))/100)^(J$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G97)*L97)*((1+(MID(M$95,12,2))/100)^(L$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G97)*N97)*((1+(MID(O$95,12,2))/100)^(N$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G97)*P97)*((1+(MID(Q$95,12,2))/100)^(P$94-$D$29)))","v":"År saknas"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G98)*H98)*((1+(MID(I$95,12,2))/100)^(H$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G98)*J98)*((1+(MID(K$95,12,2))/100)^(J$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G98)*L98)*((1+(MID(M$95,12,2))/100)^(L$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G98)*N98)*((1+(MID(O$95,12,2))/100)^(N$94-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G98)*P98)*((1+(MID(Q$95,12,2))/100)^(P$94-$D$29)))","v":"År saknas"}]
[]
[null,null,"Summa Övriga kostnader",null,null,null,null,{"$f":"SUM(I$85:I86)+SUM(I$96:I98)+SUM(I$90:I92)","v":0},null,{"$f":"SUM(K$85:K86)+SUM(K$96:K98)+SUM(K$90:K92)","v":0},null,{"$f":"SUM(M$85:M86)+SUM(M$96:M98)+SUM(M$90:M92)","v":0},null,{"$f":"SUM(O$85:O86)+SUM(O$96:O98)+SUM(O$90:O92)","v":0},null,{"$f":"SUM(Q$85:Q86)+SUM(Q$96:Q98)+SUM(Q$90:Q92)","v":0}]
[]
[null,null,"Summa Driftkostnader",null,null,null,null,{"$f":"H100+H79","v":0},null,{"$f":"J100+J79","v":0},null,{"$f":"L100+L79","v":0},null,{"$f":"N100+N79","v":0},null,{"$f":"P100+P79","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemensamma kostnader\nIndirekta kostnader (INDI)\nDessa innefattar oftast universitets- och fakultetsgemensamma kostnader samt institutionsgemensamma kostnader.\n\nHär finns även möjlighet att göra ned- eller uppräkning av INDI (kan nyttjas vid flerårigt projekt)."]
[null,null,"C. Gemensamma kostnader"]
[]
[null,null,{"$f":"IF(LEFT($D$28,2)=\"UF\",$D$28,\"Universitetsgem.\")","v":"Universitetsgem."},null,null,null,{"$f":"IF($D$28=\"\",0,IF(LEFT($D$28,2)=\"UF\",VLOOKUP($C$106,'INDI FO 2018'!$C:$G,5,0),VLOOKUP(LEFT($D$28,2),'INDI FO 2018'!$A:$G,6,0)))","v":0}]
[null,null,{"$f":"IF(LEFT($D$28,2)=\"UF\",\"\",\"Institutionsgem.\")","v":"Institutionsgem."},null,null,null,{"$f":"IF($D$28=\"\",0,IF(LEFT($D$28,2)=\"UF\",\"\",VLOOKUP(LEFT($D$28,2),'INDI FO 2018'!$A:$G,4,0)))","v":0}]
[null,null,"Ned- / Uppräkning av INDI",null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G106:G108)","v":0}]
[]
[null,null,"Summa Indirekta kostnader",null,null,null,null,{"$f":"((H79+H64)*$G109)","v":0},null,{"$f":"((J79+J64)*$G109)","v":0},null,{"$f":"((L79+L64)*$G109)","v":0},null,{"$f":"((N79+N64)*$G109)","v":0},null,{"$f":"((P79+P64)*$G109)","v":0}]
[]
[null,null,"D. Riskpåslag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Riskpåslag/Säkerhetsmarginal\nRiskpåslag kan nyttjas när det finns väsentliga osäkerheter kopplade till uppskattning av kostnaderna. Rekommenderat riskpåslag är 3% på uppdrag, dock ska hänsyn tas till historiks utveckling inom verksamheten."]
[null,null,"Riskpåslag/Säkerhetsmarginal",null,null,null,0]
[]
[]
[null,null,"SUMMA PROJEKTKOSTNADER",null,null,null,null,{"$f":"(H64+H102+H111)*(1+$G115)","v":0},null,{"$f":"(J64+J102+J111)*(1+$G115)","v":0},null,{"$f":"(L64+L102+L111)*(1+$G115)","v":0},null,{"$f":"(N64+N102+N111)*(1+$G115)","v":0},null,{"$f":"(P64+P102+P111)*(1+$G115)","v":0}]
[]
[]
[null,null,"KOSTNADSSPECIFIKATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nKostnadsspecifikation\nHär redogörs de totala förväntade kostnaderna för projektet och som är underlag för prissättning.\n\nSumma exklusive moms debiteras internt och från statliga myndigheter samt utlandet i de flesta fall, och summa inklusive moms debiteras övriga organisationer och företag. Välj externt uppdrag i grundläggande uppgifter vid behov av moms och internt, statligt eller övrigt utan moms då moms inte ska debiteras.\n\n\n\n\n\nUnderskrifter\nOm nettoomsättnming överskrider 100 000 kr är godkännande från Universitetsdirektören obligatorisk för uppdrag."]
[]
[null,null,"Timkostnad (personalkostnad inklusive indirekta kostnader)",null,null,{"$f":"IFERROR(F58&\"h á \"&(ROUND(((SUM($H64:Q64)+SUM($H111:Q111))/$F58)*(1+$G115),0)&\"kr\"),\"\")","v":""},{"$f":"(ROUND((SUM($H64:Q64)+SUM($H111:Q111)),0)*(1+$G115))","v":0}]
[null,null,"Driftkostnad",null,null,null,{"$f":"ROUND(SUM($H102:Q102),0)*(1+$G115)","v":0}]
[]
[null,null,"SUMMA KOSTNADER (EXKL MOMS)",null,null,null,{"$f":"(SUM($H64:Q64)+SUM($H100:Q100)+SUM($H111:Q111)+SUM($H79:Q79))*(1+$G115)","v":0}]
[]
[null,null,{"$f":"IF(G128=\"\",\"Moms redogörs här vid externa uppdrag\",\"VARAV MOMS\")","v":"VARAV MOMS"},null,null,null,{"$f":"IF(G129=\"\",\"\",G129-G126)","v":0}]
[null,null,{"$f":"IF(G129=\"\",\"Internt, statligt och oftast utländska uppdrag debiteras exkl moms\",\"SUMMA KOSTNADER (INKL 25% MOMS)\")","v":"SUMMA KOSTNADER (INKL 25% MOMS)"},null,null,null,{"$f":"IF(OR($D$28=\"UF - Internt\",$D$32=\"Internt\",$D$32=\"Statligt\",$D$32=\"Övr. utan moms\",),\"\",G126*1.25)","v":0}]
[]
[]
[null,null,"Projektledare/-ansvarig",null,"Kontrollerad av inst.-ekonom / motsvarande",null,"Prefekt / med motsvarande beslutsrätt",null,null,"Universitetsdirektör"]
[]
[]
[null,null,"Signatur",null,"Signatur",null,"Signatur",null,null,"Signatur"]
[]
[]
[null,null,"Namnförtydligande",null,"Namnförtydligande",null,"Namnförtydligande",null,null,"Namnförtydligande"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nBeräkning av debiterbar månadsersättning och tid (exkl. LKP)\n\nI den mån det är ett externt uppdrag ska avärkning göras för indirekt tid eller produktionsbortfall såsom egen- administration, utbildning och utvecklingsarbete ske.\n\nDet som är individuellt och kan ändras i kalkylen är:\n- månadslön (här anger individens bruttomånadslön exkl. LKP) \n- antalet semesterdagar som individen har (ex. 7 veckor är 35 dagar)\n- övrig betald ledighet i dagar (ex. avtalad friskvårdstimmar eller liknande)\n\nI den mån projektet är ett externt uppdrag ska även hänsyn tas till övrig ineffektiv betald arbetstid (produktionsbortfall) som kan vara:\n- egen administration som inte är förknippad med något projekt\n- egen utveckling, så som utbildningar och annat\n- generella resor och arrangemang som är personalhälsofrämjande\n"]
[null,null,"BERÄKNING AV DEBITERBAR  MÅNADSERSÄTTNING OCH TID (Exkl. LKP)"]
[]
[null,null,"Ange månadslön (hela kronor):"]
[]
[null,null,"Arbetstid på årsbas","Dagar","Timmar totalt"]
[null,null,"52 veckor x 40 tim (heltid)",260,{"$f":"52*40","v":2080}]
[null,null,"- 2 veckor helgdagar avgår",10,{"$f":"2*40","v":80}]
[null,null,"Betald tid",{"$f":"D147-D148","v":250},{"$f":"E147-E148","v":2000}]
[null,null,"- betalda semesterdagar",35,{"$f":"D150*8","v":280}]
[null,null,"- övrig betald frånvaro",5,{"$f":"D151*8","v":40}]
[null,null,"STANDARDTID",{"$f":"D149-D150-D151","v":210},{"$f":"E149-E150-E151","v":1680}]
[null,null,"- egen administration",10,{"$f":"D153*8","v":80}]
[null,null,"- egen utveckling etc",25,{"$f":"D154*8","v":200}]
[null,null,"- resor, sammankomster",25,{"$f":"D155*8","v":200}]
[null,null,"Summa indirekt tid",{"$f":"SUM(D153:D155)","v":60},{"$f":"SUM(E153:E155)","v":480}]
[null,null,"DEBITERBAR TID (DIREKT TID)",{"$f":"D152-D156","v":150},{"$f":"E152-E156","v":1200}]
[]
[null,null,{"$f":"IF(G159=0,\"Ange månadslön\",\"Månadsersättning exkl. LKP Interna uppdrag:\")","v":"Ange månadslön"},null,{"$f":"E144/E157*E157","v":0},"kr per månad",{"$f":"ROUND(E144/(E152/12),2)","v":0},"kr/tim"]
[]
[null,null,{"$f":"IF(G161=0,\"Ange månadslön\",\"Månadsersättning exkl. LKP Externa uppdrag:\")","v":"Ange månadslön"},null,{"$f":"E144/E157*E152","v":0},"kr per månad",{"$f":"ROUND(E144/(E157/12),2)","v":0},"kr/tim"]

{"sheet":"Uppföljning uppdrag","index":2,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,1,7,14]]}
[null,"UPPDRAGSFORSKNING - STÖD FÖR BUDGET TILL UBW"]
[]
[null,"Inledning\n\nDenna flik summerar kostnader och intäkter som fyllts in i kalkylfliken och återvisar dem i en budget modell som kan enkelt föras in i UBWs Saldo tabell för uppföljningsändamål. Posterna hämtas till olika konton beroende på vad som fyllts i under respektive rubrik i kalkylen. \n\nDet är möjligt att välja antingen att föra in totala förväntad utfall på första året, det under första rubriken nedan, eller en årsfördelad from första året och framåt som finns under rubriken årsfördelad budget.\n\nOBS! Kopiera endast gråa fält och klistra in direkt i UBW (Ctrl + C & Ctrl + V). Se gärna UBW handbok på medarbetarportalen för ytterligare instruktioner om hur funktionen nyttjas."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL BUDGET"]
[]
[null,null,"RR2","Beskrivning","Konto","Inst","Proj","Fin","Anl","Mpt","Verks","Text","Per","Budget (BB)"]
[null,null,11,"Intäkter avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},{"$f":"N25+N32+N39+N46+N53","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},{"$f":"N26+N33+N40+N47+N54","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Uppdragsforskning!$D$35&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[]
[null,null,"ÅRSFÖRDELAD BUDGET"]
[]
[null,null,"RR2","Beskrivning","Konto","Inst","Proj","Fin","Anl","Mpt","Verks","Text","Per","Budget (BB)"]
[null,null,11,"Intäkter av avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},{"$f":"RIGHT(L25,4)&\"00\"","v":"et  00"},{"$f":"SUM(Uppdragsforskning!H118:I118)*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},{"$f":"RIGHT(L26,4)&\"00\"","v":"et  00"},{"$f":"SUM(Uppdragsforskning!H64:I64)","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!H111:I111)","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!I$90:I92)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!H79:I79)","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!I$96:I98)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!H$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!I$85:I86)","v":0}]
[null,null,11,"Intäkter av avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!J118:K118)*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!J64:K64)","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!J111:K111)","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!K$90:K92)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!J79:K79)","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!K$96:K98)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!J$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!K$85:K86)","v":0}]
[null,null,11,"Intäkter av avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!L118:M118)*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!L64:M64)","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!L111:M111)","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!M$90:M92)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!L79:M79)","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!M$96:M98)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!L$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!M$85:M86)","v":0}]
[null,null,11,"Intäkter av avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!N118:O118)*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!N64:O64)","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!N111:O111)","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!O$90:O92)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!N79:O79)","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!O$96:O98)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!N$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!O$85:O86)","v":0}]
[null,null,11,"Intäkter av avgifter",33,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!P118:Q118)*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!P64:Q64)","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!P111:Q111)","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!Q$90:Q92)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!P79:Q79)","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!Q$96:Q98)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Uppdragsforskning!$D$28=\"\",\"\",LEFT(Uppdragsforskning!$D$28,2))","v":""},{"$f":"Uppdragsforskning!$D$35","v":0},null,null,null,null,{"$f":"\"Budget \"&Uppdragsforskning!$D$35&\" \"&Uppdragsforskning!P$42","v":"Budget  "},"et  00",{"$f":"SUM(Uppdragsforskning!Q$85:Q86)","v":0}]

{"sheet":"Bidragsforskning","index":3,"n_rows":162,"n_cols":21,"rows_kept":162,"cut":false,"hidden":false,"merged":[[117,2,117,5],[118,2,118,5],[119,2,119,5],[2,20,23,25],[140,2,140,4],[141,2,141,4],[88,9,88,10],[43,20,43,24],[31,3,31,4],[30,3,30,4],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[88,7,88,8],[73,7,73,8],[73,9,73,10],[73,11,73,12],[73,13,73,14],[77,7,77,8],[140,7,140,8],[140,9,140,10],[140,11,140,12],[140,13,140,14],[140,15,140,16],[128,2,128,5],[100,13,100,14],[131,7,131,8],[131,9,131,10],[131,15,131,16],[134,7,134,8],[134,9,134,10],[105,20,123,25],[101,20,104,25],[88,20,100,25],[124,20,132,25],[100,2,100,6],[100,7,100,8],[100,9,100,10],[115,9,115,10],[110,2,110,4],[111,2,111,4],[113,2,113,4],[112,2,112,4],[109,7,109,8],[109,9,109,10],[104,7,104,8],[104,9,104,10],[77,9,77,10],[116,2,116,5],[153,2,153,4],[153,7,153,8],[153,9,153,10],[153,11,153,12],[153,13,153,14],[158,20,161,25],[160,6,160,7],[134,15,134,16],[148,7,148,8],[148,9,148,10],[148,11,148,12],[148,13,148,14],[148,15,148,16],[131,2,131,4],[151,7,151,8],[151,9,151,10],[151,11,151,12],[150,7,150,8],[150,9,150,10],[134,11,134,12],[134,13,134,14],[127,2,127,5],[82,15,82,16],[56,13,56,14],[62,7,62,8],[62,9,62,10],[141,13,141,14],[143,15,143,16],[145,15,145,16],[149,15,149,16],[150,15,150,16],[149,7,149,8],[149,9,149,10],[149,11,149,12],[149,13,149,14],[141,7,141,8],[141,9,141,10],[141,11,141,12],[150,13,150,14],[145,13,145,14],[142,13,142,14],[143,13,143,14],[142,11,142,12],[104,11,104,12],[104,13,104,14],[100,11,100,12],[43,3,43,4],[44,20,65,25],[47,3,47,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[56,7,56,8],[56,9,56,10],[56,11,56,12],[62,11,62,12],[62,13,62,14],[50,15,50,16],[56,15,56,16],[62,15,62,16],[115,7,115,8],[44,3,44,4],[67,2,67,4],[82,2,82,4],[80,3,80,4],[67,7,67,8],[67,9,67,10],[67,11,67,12],[67,13,67,14],[70,2,70,5],[82,7,82,8],[82,9,82,10],[63,3,63,4],[64,3,64,4],[65,3,65,4],[69,2,69,5],[78,3,78,4],[79,3,79,4],[77,11,77,12],[109,11,109,12],[109,13,109,14],[105,2,105,4],[82,11,82,12],[82,13,82,14],[88,15,88,16],[84,7,84,8],[84,9,84,10],[84,11,84,12],[88,11,88,12],[88,13,88,14],[106,2,106,4],[107,2,107,4],[89,2,89,5],[90,2,90,5],[91,2,91,5],[92,2,92,5],[93,2,93,5],[94,2,94,5],[95,2,95,5],[98,2,98,5],[5,1,20,17],[38,15,38,16],[42,15,42,16],[115,15,115,16],[121,15,121,16],[123,15,123,16],[131,11,131,12],[131,13,131,14],[141,15,141,16],[115,13,115,14],[84,13,84,14],[123,2,123,4],[123,7,123,8],[123,9,123,10],[123,11,123,12],[123,13,123,14],[115,11,115,12],[121,2,121,6],[121,7,121,8],[121,9,121,10],[121,11,121,12],[121,13,121,14],[126,2,126,5],[84,15,84,16],[143,9,143,10],[143,11,143,12],[142,2,142,4],[142,15,142,16],[145,2,145,4],[145,5,145,6],[151,2,151,4],[150,11,150,12],[143,2,143,4],[145,7,145,8],[145,9,145,10],[145,11,145,12],[148,2,148,4],[149,2,149,4],[150,2,150,4],[142,7,142,8],[24,20,37,25],[148,20,155,25],[137,20,146,25],[69,20,72,25],[77,20,80,25],[73,2,73,6],[67,15,67,16],[73,15,73,16],[77,15,77,16],[32,3,32,4],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[77,13,77,14],[100,15,100,16],[104,15,104,16],[109,15,109,16],[84,2,84,4],[142,9,142,10],[151,13,151,14],[151,15,151,16],[153,15,153,16],[143,7,143,8]]}
[null,"BIDRAGSFORSKNING - FULL KOSTNADSTÄCKNINGSKALKYL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instruktioner\n\nGenerellt\nMed knappen under rubriken väljs typ av mall, uppdrag / bidragskalkylmall. Det går alltid att hoppa mellan olika mallar utan att förlora inmatade uppgifter.\n\nDe vita cellerna i mallen fylls i med värden och de färgade cellerna är beräkningar som filen gör automatiskt. Namn / beskrivningar som är ifyllda exempel bör raderas.\n\nGrupperingarna / plusknapparna (1, 2 och 3) ute till vänster i filen gör det möjligt att komprimera och expandera kostnads- / intäktsdetaljerna. Grupperingen / plusknappen längst upp (ovanför R kolumnen) ger utökade antal år.\n\nVid behov kan ytterligare rader och även kolumner (för år) infogas, men då med viss försiktighet då formler inte följer med automatiskt. Vid behov av ytterligare rader är rekommenderat att kopiera en hel rad  i mitten av de kostnader / intäkter där behov av ytterligare poster uppstår och sedan infoga hela den kopierade raden på samma rad. Vid behov av ytterligare år rekommenderas kontakt med EA eller att två seprata mallar nyttjas för uträkning men med olika projekt start år.\n\nOmf.%  innebär omfattning av heltid\nNyttj % innebär nyttjandegrad av resursen i procent\nFörbr % innebär förbrukningsgrad av resursen i procent\n"]
[]
[]
[null,"Inledning för bidrag\n\nMed bidrag menas medel som tas emot utan krav på motprestation i form av till exempel varor, tjänster eller särskilda förmåner. Finansiären kan dock villkora vad bidraget får användas till och dessutom ställa krav på återrapportering av hur medlen nyttjats.\n\nDenna mall är ämnad för att stötta beräkning av ett forskningsprojekts kostnader samt finansiering och därmed även det eventuella samfinansieringsbehovet som kan uppstå. Med samfinansieringsbehov i detta sammanhang menas den del av kostnader som uppstår i projektet som inte har beviljats täckning från huvudfinansiärerna.\n\nTill skillnad från uppdragsforskningskalkylmallen kan denna mall med fördel även användas som underlag att bifoga en ansökan där bidragsgivaren så kräver. Detta kan ske då de inte själva tillhandahåller någon specifik mall. Mallen i sig kan skrivas ut i komprimerad form genom grupperingsfunktionen till vänster i bladet.\n\nMallen ska alltid skrivas under av prefekt, eller av den till vilken prefekten delegerat beslutsrätten, när det ansökta bidraget överstiger 100 000 kr. I dessa fall ska ett exemplar av ansökan och kalkylen diarieföras och sparas. Vid beviljade ansökningar ska kalkylen bifogas i Avtalsreskontran i KIs affärssystem."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundläggande uppgifter\nHär väljs institutionskod i rullistan som påverkar de indirekta kostnaderna (INDI) både i denna mall men även värden i specifikations- och uppföljningsflikar.\n\nInnevarande år kommer upp automatiskt, men val av projektets start år påverkar Index av personal-, drift-, och lokalkostnader.\n\nFör uppdrag redogörs även om projektet är internt, statligt, externt eller övrigt uppdrag och där moms av annan anldening ska exkluderas.\n\nResten av fälten är fritextfält, men observera att framförallt projektnumret och även de andra fält hämtas upp av de övriga bladen."]
[null,null,"GRUNDLÄGGANDE UPPGIFTER"]
[]
[null,null,"Institutionskod","C4 - Neuro"]
[null,null,"Innevrande år",{"$f":"Tabeller!$A$1","v":2019}]
[null,null,"Projektets start år"]
[null,null,"Projektledare/-ansvarig"]
[null,null,"Projektnummer - UBW"]
[null,null,"Beskrivnig av projektet"]
[]
[]
[]
[null,null,{"$f":"\"PROJEKTKOSTNADER\"&\" - \"&LEFT($B$1,(LEN($B$1)-41))","v":"PROJEKTKOSTNADER - BIDRAG"}]
[]
[null,null,"A. Personalkostnader",null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grundläggande uppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H39+1,\"\")","v":""},null,{"$f":"IFERROR(J39+1,\"\")","v":""},null,{"$f":"IFERROR(L39+1,\"\")","v":""},null,{"$f":"IFERROR(N39+1,\"\")","v":""}]
[null,null,"A.1 Medverkande personal med LÖN från KI"]
[]
[null,null,"A.1.1 - Projektledare"]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H43+1,\"\")","v":""},null,{"$f":"IFERROR(J43+1,\"\")","v":""},null,{"$f":"IFERROR(L43+1,\"\")","v":""},null,{"$f":"IFERROR(N43+1,\"\")","v":""},null,null,null,null,"Personalkostnader"]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Månadslön (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%"]
[null,null,"Professor1",null,null,{"$f":"(H45+J45+L45+N45+P45)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G45*12)*H45*((1+(MID(I$44,12,2))/100)^(H$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G45*12)*J45*((1+(MID(K$44,12,2))/100)^(J$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G45*12)*L45*((1+(MID(M$44,12,2))/100)^(L$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G45*12)*N45*((1+(MID(O$44,12,2))/100)^(N$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G45*12)*P45*((1+(MID(Q$44,12,2))/100)^(P$43-$D$29)))),0)","v":"År saknas"},null,null,null,"Beräkningen baserar sig på total månadsersättning och omfattning av heltid i projektet.\n\nFör bidragsforksning nyttjas bruttolön och standardtiden anges automatiskt, vilket motsvarar 1680 timmar per år på KI.\n\nFör externa uppdrag ska månadsersättning baseras på debiterbar tid. Bruttolönen behöver beräknas om till debiterbar månadsersättning. Detta är högre än bruttolönen då avräkning för indirekt tid eller produktionsbortfall såsom egen- administration, utbildning och utvecklingsarbete görs. Mallen utgår ifrån en standard produktionsbortfall om 480 timmar, men denna kan enkelt justeras genom att ange nya siffror i beräkningsunderlaget längst ner i bladet. (se även länk ovan eller i rubriken för månadsersättning)\n\nIndex för personalkostnader är satt till 2% ökning per år."]
[null,null,null,null,null,{"$f":"(H46+J46+L46+N46+P46)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G46*12)*H46*((1+(MID(I$44,12,2))/100)^(H$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G46*12)*J46*((1+(MID(K$44,12,2))/100)^(J$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G46*12)*L46*((1+(MID(M$44,12,2))/100)^(L$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G46*12)*N46*((1+(MID(O$44,12,2))/100)^(N$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G46*12)*P46*((1+(MID(Q$44,12,2))/100)^(P$43-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*H47*((1+(MID(I$44,12,2))/100)^(H$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*J47*((1+(MID(K$44,12,2))/100)^(J$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*L47*((1+(MID(M$44,12,2))/100)^(L$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*N47*((1+(MID(O$44,12,2))/100)^(N$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G47*12)*P47*((1+(MID(Q$44,12,2))/100)^(P$43-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*H48*((1+(MID(I$44,12,2))/100)^(H$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*J48*((1+(MID(K$44,12,2))/100)^(J$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*L48*((1+(MID(M$44,12,2))/100)^(L$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*N48*((1+(MID(O$44,12,2))/100)^(N$43-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G48*12)*P48*((1+(MID(Q$44,12,2))/100)^(P$43-$D$29)))),0)","v":"År saknas"}]
[]
[null,null,"A.1.2 - Doktorander"]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H51+1,\"\")","v":""},null,{"$f":"IFERROR(J51+1,\"\")","v":""},null,{"$f":"IFERROR(L51+1,\"\")","v":""},null,{"$f":"IFERROR(N51+1,\"\")","v":""}]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Månadslön (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%"]
[null,null,"Doktorand1",null,null,{"$f":"(H53+J53+L53+N53+P53)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G53*12)*H53*((1+(MID(I$52,12,2))/100)^(H$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G53*12)*J53*((1+(MID(K$52,12,2))/100)^(J$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G53*12)*L53*((1+(MID(M$52,12,2))/100)^(L$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G53*12)*N53*((1+(MID(O$52,12,2))/100)^(N$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G53*12)*P53*((1+(MID(Q$52,12,2))/100)^(P$51-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G54*12)*H54*((1+(MID(I$52,12,2))/100)^(H$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G54*12)*J54*((1+(MID(K$52,12,2))/100)^(J$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G54*12)*L54*((1+(MID(M$52,12,2))/100)^(L$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G54*12)*N54*((1+(MID(O$52,12,2))/100)^(N$51-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G54*12)*P54*((1+(MID(Q$52,12,2))/100)^(P$51-$D$29)))),0)","v":"År saknas"}]
[]
[null,null,"A.1.3 - Övrig forskande personal"]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H57+1,\"\")","v":""},null,{"$f":"IFERROR(J57+1,\"\")","v":""},null,{"$f":"IFERROR(L57+1,\"\")","v":""},null,{"$f":"IFERROR(N57+1,\"\")","v":""}]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Månadslön (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%"]
[null,null,"Forskningsassistent1",null,null,{"$f":"(H59+J59+L59+N59+P59)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G59*12)*H59*((1+(MID(I$58,12,2))/100)^(H$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G59*12)*J59*((1+(MID(K$58,12,2))/100)^(J$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G59*12)*L59*((1+(MID(M$58,12,2))/100)^(L$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G59*12)*N59*((1+(MID(O$58,12,2))/100)^(N$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G59*12)*P59*((1+(MID(Q$58,12,2))/100)^(P$57-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G60*12)*H60*((1+(MID(I$58,12,2))/100)^(H$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G60*12)*J60*((1+(MID(K$58,12,2))/100)^(J$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G60*12)*L60*((1+(MID(M$58,12,2))/100)^(L$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G60*12)*N60*((1+(MID(O$58,12,2))/100)^(N$57-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G60*12)*P60*((1+(MID(Q$58,12,2))/100)^(P$57-$D$29)))),0)","v":"År saknas"}]
[]
[null,null,"A.1.4 - TA-personal som ej ingår i det gemensamma stödet"]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H63+1,\"\")","v":""},null,{"$f":"IFERROR(J63+1,\"\")","v":""},null,{"$f":"IFERROR(L63+1,\"\")","v":""},null,{"$f":"IFERROR(N63+1,\"\")","v":""}]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Månadslön (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%","Omf. %","inkl. index 2%"]
[null,null,"Administratör1",null,null,{"$f":"(H65+J65+L65+N65+P65)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G65*12)*H65*((1+(MID(I$64,12,2))/100)^(H$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G65*12)*J65*((1+(MID(K$64,12,2))/100)^(J$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G65*12)*L65*((1+(MID(M$64,12,2))/100)^(L$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G65*12)*N65*((1+(MID(O$64,12,2))/100)^(N$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G65*12)*P65*((1+(MID(Q$64,12,2))/100)^(P$63-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G66*12)*H66*((1+(MID(I$64,12,2))/100)^(H$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G66*12)*J66*((1+(MID(K$64,12,2))/100)^(J$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G66*12)*L66*((1+(MID(M$64,12,2))/100)^(L$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G66*12)*N66*((1+(MID(O$64,12,2))/100)^(N$63-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G66*12)*P66*((1+(MID(Q$64,12,2))/100)^(P$63-$D$29)))),0)","v":"År saknas"}]
[]
[null,null,"Summa Personalkostnader exkl. lönekostnadspålägg (LKP)",null,null,{"$f":"SUM(F$45:F66)","v":0},null,{"$f":"SUM(I$45:I66)","v":0},null,{"$f":"SUM(K$45:K66)","v":0},null,{"$f":"SUM(M$45:M66)","v":0},null,{"$f":"SUM(O$45:O66)","v":0},null,{"$f":"SUM(Q$45:Q66)","v":0}]
[]
[null,null,"Sociala avgifter  (LKP) - 2019",null,null,null,0.52159999999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,"LKP\nLKP (Lönekostnadspålägg) är en kostnad som de flesta arbetsgivare har för den anställda utöver den individuella bruttolönen som den anställda har.\nDetta är en standardsats som revideras centralt årligen."]
[null,null,"Semestertillägg",null,null,null,1.84E-2]
[null,null,null,null,null,"LKP Total",{"$f":"SUM(G70:G71)","v":0.53999999999999992}]
[]
[null,null,"Summa personalkostnad där lönekostnadspålägg (LKP) ingår",null,null,null,null,{"$f":"SUM(H68)*(1+$G72)","v":0},null,{"$f":"SUM(J68)*(1+$G72)","v":0},null,{"$f":"SUM(L68)*(1+$G72)","v":0},null,{"$f":"SUM(N68)*(1+$G72)","v":0},null,{"$f":"SUM(P68)*(1+$G72)","v":0}]
[]
[null,null,"A.2 Övriga medverkande som har annan ersättning än lön (dessa exkluderas från LKP)"]
[null,null,"A.2.1 - Övriga medverkande "]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H78+1,\"\")","v":""},null,{"$f":"IFERROR(J78+1,\"\")","v":""},null,{"$f":"IFERROR(L78+1,\"\")","v":""},null,{"$f":"IFERROR(N78+1,\"\")","v":""},null,null,null,null,"Övriga medverkande (exkl. LKP)\nDetta är främst för stipendiater, men kan även användas för medverkande där LKP inte ska ingå av andra eventuella skäl."]
[null,null,"Namn/Roll","Arbetsmoment/Beskrivning",null,"Antal timmar","Månadsers. (kr)","Omf. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 0%\")","v":"inkl. index 0%"},"Omf. %","inkl. index 0%","Omf. %","inkl. index 0%","Omf. %","inkl. index 0%","Omf. %","inkl. index 0%"]
[null,null,"Stipendiat 1",null,null,{"$f":"(H80+J80+L80+N80+P80)*1680","v":0},null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G80*12)*H80*((1+(MID(I$79,12,2))/100)^(H$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G80*12)*J80*((1+(MID(K$79,12,2))/100)^(J$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G80*12)*L80*((1+(MID(M$79,12,2))/100)^(L$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G80*12)*N80*((1+(MID(O$79,12,2))/100)^(N$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G80*12)*P80*((1+(MID(Q$79,12,2))/100)^(P$78-$D$29)))),0)","v":"År saknas"}]
[null,null,null,null,null,0,null,null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G81*12)*H81*((1+(MID(I$79,12,2))/100)^(H$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G81*12)*J81*((1+(MID(K$79,12,2))/100)^(J$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G81*12)*L81*((1+(MID(M$79,12,2))/100)^(L$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G81*12)*N81*((1+(MID(O$79,12,2))/100)^(N$78-$D$29)))),0)","v":"År saknas"},null,{"$f":"IFERROR(IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G81*12)*P81*((1+(MID(Q$79,12,2))/100)^(P$78-$D$29)))),0)","v":"År saknas"}]
[]
[null,null,"Summa kostnader för övriga medverkande",null,null,null,null,{"$f":"SUM(I$80:I81)","v":0},null,{"$f":"SUM(K$80:K81)","v":0},null,{"$f":"SUM(M$80:M81)","v":0},null,{"$f":"SUM(O$80:O81)","v":0},null,{"$f":"SUM(Q$80:Q81)","v":0}]
[]
[null,null,"Summa samtliga personalkostnader",null,null,null,null,{"$f":"H83+H74","v":0},null,{"$f":"J83+J74","v":0},null,{"$f":"L83+L74","v":0},null,{"$f":"N83+N74","v":0},null,{"$f":"P83+P74","v":0}]
[]
[null,null,"B. Driftkostnader"]
[null,null,"B.1 Direkta driftkostnader (Lokal- och KI-interna kostnader kommer under övriga drifkostnader)"]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H89+1,\"\")","v":""},null,{"$f":"IFERROR(J89+1,\"\")","v":""},null,{"$f":"IFERROR(L89+1,\"\")","v":""},null,{"$f":"IFERROR(N89+1,\"\")","v":""},null,null,null,null,"Drifkostnader\nHit förs alla typer av driftkostnader som är direkt förknippade med projektet. Detta kan innefatta för projektet nödvändig litteratur, kemikalier, laboratorieutrustning, konsultkostnader, resor (inkl. brutto av eventuella skattepliktiga traktamenten).\n\nBeloppet anges som en total kostnad för projektet på respektive rad sedan anges förbrukning av resursen (kostnden) för respektive år som procent. 100% innebär alltså att hela kostnaden tas på det året."]
[null,null,"Driftkostnader - beskrivning",null,null,null,"Kostnad att fördela ->","Förbr. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 1%\")","v":"inkl. index 1%"},"Förbr. %","inkl. index 1%","Förbr. %","inkl. index 1%","Förbr. %","inkl. index 1%","Förbr. %","inkl. index 1%"]
[null,null,"Instrument",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G91)*H91)*((1+(MID(I$90,12,2))/100)^(H$89-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G91)*J91)*((1+(MID(K$90,12,2))/100)^(J$89-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G91)*L91)*((1+(MID(M$90,12,2))/100)^(L$89-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G91)*N91)*((1+(MID(O$90,12,2))/100)^(N$89-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G91)*P91)*((1+(MID(Q$90,12,2))/100)^(P$89-$D$29)))","v":"År saknas"}]
[null,null,"Konsulttid",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Litteratur",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Djur",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,"Resor",null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[]
[null,null,"Summa direkta driftkostnader",null,null,null,null,{"$f":"SUM(I$91:I99)","v":0},null,{"$f":"SUM(K$91:K99)","v":0},null,{"$f":"SUM(M$91:M99)","v":0},null,{"$f":"SUM(O$91:O99)","v":0},null,{"$f":"SUM(Q$91:Q99)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Övriga driftkostnader\nAvskrivningar, Lokalkostnader och interna kostnader genererar ingen INDI i den mån kalkylen inkluderar detta."]
[null,null,"B.2 Övriga driftkostnader (dessa exkluderas från INDI)"]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H105+1,\"\")","v":""},null,{"$f":"IFERROR(J105+1,\"\")","v":""},null,{"$f":"IFERROR(L105+1,\"\")","v":""},null,{"$f":"IFERROR(N105+1,\"\")","v":""}]
[null,null,"Anläggning - beskrivning",null,null,"Eko. livslängd","Investeringskostnad","Nyttj. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 0%\")","v":"inkl. index 0%"},"Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%","Nyttj. %","inkl. index 0%",null,null,null,"\nAnläggningar\nAnge den kvarvarande ekonomiska livslängden och investeringskostnaden (nettofakturabelopp) eller totala restvärdet vid befintliga anläggningar. \nNyttjandegrad kan uppskattas eller beräknas genom att ta den totala tiden som anläggningen kommer nyttjas respektive år med den totala möjliga nyttjandetiden för anläggningen per år.\n\nLokalkostnader\nHit förs alla kostnader för de lokaler som nyttjas samt eventuella kostnader för städning och gemensamma ytor. Uppgifter om ytor och kostnd erhålls oftast från institutionens administration.\n\nInterna kostnader\nHit förs interna kostnader som uppstår av produkter eller tjänster som tillhandahålls från andra delar av KI, vilket ska inkludera motpartens indirekta kostnader (INDI)"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((H$105-$D$30)>=((IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2)))*1),\"*livslängd < proj-tid\",(($G107/(IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2))))*H107)*((1+(MID(I$106,12,2))/100)^(H$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((J$105-$D$30)>=((IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2)))*1),\"*livslängd < proj-tid\",(($G107/(IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2))))*J107)*((1+(MID(K$106,12,2))/100)^(J$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((L$105-$D$30)>=((IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2)))*1),\"*livslängd < proj-tid\",(($G107/(IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2))))*L107)*((1+(MID(M$106,12,2))/100)^(L$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((N$105-$D$30)>=((IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2)))*1),\"*livslängd < proj-tid\",(($G107/(IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2))))*N107)*((1+(MID(O$106,12,2))/100)^(N$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((P$105-$D$30)>=((IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2)))*1),\"*livslängd < proj-tid\",(($G107/(IF(LEN($F107)=4,LEFT($F107,1),LEFT($F107,2))))*P107)*((1+(MID(Q$106,12,2))/100)^(P$105-$D$29))),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((H$105-$D$30)>=((IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2)))*1),\"*livslängd < proj-tid\",(($G108/(IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2))))*H108)*((1+(MID(I$106,12,2))/100)^(H$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((J$105-$D$30)>=((IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2)))*1),\"*livslängd < proj-tid\",(($G108/(IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2))))*J108)*((1+(MID(K$106,12,2))/100)^(J$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((L$105-$D$30)>=((IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2)))*1),\"*livslängd < proj-tid\",(($G108/(IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2))))*L108)*((1+(MID(M$106,12,2))/100)^(L$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((N$105-$D$30)>=((IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2)))*1),\"*livslängd < proj-tid\",(($G108/(IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2))))*N108)*((1+(MID(O$106,12,2))/100)^(N$105-$D$29))),0)","v":0},null,{"$f":"IFERROR(IF((P$105-$D$30)>=((IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2)))*1),\"*livslängd < proj-tid\",(($G108/(IF(LEN($F108)=4,LEFT($F108,1),LEFT($F108,2))))*P108)*((1+(MID(Q$106,12,2))/100)^(P$105-$D$29))),0)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H110+1,\"\")","v":""},null,{"$f":"IFERROR(J110+1,\"\")","v":""},null,{"$f":"IFERROR(L110+1,\"\")","v":""},null,{"$f":"IFERROR(N110+1,\"\")","v":""}]
[null,null,"Lokalkostnader - beskrivning",null,null,"Lokal yta kvm","Kvm kostnad / år","Nyttj. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 2%\")","v":"inkl. index 2%"},"Nyttj. %","inkl. index 2%","Nyttj. %","inkl. index 2%","Nyttj. %","inkl. index 2%","Nyttj. %","inkl. index 2%"]
[null,null,"Kontor1",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F112*$G112)*H112)*((1+(MID(I$111,12,2))/100)^(H$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F112*$G112)*J112)*((1+(MID(K$111,12,2))/100)^(J$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F112*$G112)*L112)*((1+(MID(M$111,12,2))/100)^(L$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F112*$G112)*N112)*((1+(MID(O$111,12,2))/100)^(N$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F112*$G112)*P112)*((1+(MID(Q$111,12,2))/100)^(P$110-$D$29)))","v":"År saknas"}]
[null,null,"Lab1",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F113*$G113)*H113)*((1+(MID(I$111,12,2))/100)^(H$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F113*$G113)*J113)*((1+(MID(K$111,12,2))/100)^(J$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F113*$G113)*L113)*((1+(MID(M$111,12,2))/100)^(L$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F113*$G113)*N113)*((1+(MID(O$111,12,2))/100)^(N$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F113*$G113)*P113)*((1+(MID(Q$111,12,2))/100)^(P$110-$D$29)))","v":"År saknas"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F114*$G114)*H114)*((1+(MID(I$111,12,2))/100)^(H$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F114*$G114)*J114)*((1+(MID(K$111,12,2))/100)^(J$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F114*$G114)*L114)*((1+(MID(M$111,12,2))/100)^(L$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F114*$G114)*N114)*((1+(MID(O$111,12,2))/100)^(N$110-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($F114*$G114)*P114)*((1+(MID(Q$111,12,2))/100)^(P$110-$D$29)))","v":"År saknas"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H116+1,\"\")","v":""},null,{"$f":"IFERROR(J116+1,\"\")","v":""},null,{"$f":"IFERROR(L116+1,\"\")","v":""},null,{"$f":"IFERROR(N116+1,\"\")","v":""}]
[null,null,"Interna kostnader och eventuell INDI-befriad verksamhet - beskrivning",null,null,null,"Kostnad att fördela ->","Förbr. %",{"$f":"IF($D$29=$D$30,\"inkl. index 0%\",\"inkl. index 0%\")","v":"inkl. index 0%"},"Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%","Förbr. %","inkl. index 0%"]
[null,null,"Interntjänst1, inkl. motpartens INDI",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G118)*H118)*((1+(MID(I$117,12,2))/100)^(H$116-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G118)*J118)*((1+(MID(K$117,12,2))/100)^(J$116-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G118)*L118)*((1+(MID(M$117,12,2))/100)^(L$116-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G118)*N118)*((1+(MID(O$117,12,2))/100)^(N$116-$D$29)))","v":"År saknas"},null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G118)*P118)*((1+(MID(Q$117,12,2))/100)^(P$116-$D$29)))","v":"År saknas"}]
[null,null,"IT avgift 9900 kr per anställd/anknuten och år (2017)",null,null,null,null,null,{"$f":"IF(OR($D$29=\"\",$D$30=\"\"),\"År saknas\",(($G119)*H119)*((1+(MID(I$117,12,2))/100)^(H$116-$D$29)))","v":"År saknas"},null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[null,null,null,null,null,null,null,null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas",null,"År saknas"]
[]
[null,null,"Summa Övriga kostnader",null,null,null,null,{"$f":"SUM(I$107:I108)+SUM(I$118:I120)+SUM(I$112:I114)","v":0},null,{"$f":"SUM(K$107:K108)+SUM(K$118:K120)+SUM(K$112:K114)","v":0},null,{"$f":"SUM(M$107:M108)+SUM(M$118:M120)+SUM(M$112:M114)","v":0},null,{"$f":"SUM(O$107:O108)+SUM(O$118:O120)+SUM(O$112:O114)","v":0},null,{"$f":"SUM(Q$107:Q108)+SUM(Q$118:Q120)+SUM(Q$112:Q114)","v":0}]
[]
[null,null,"Summa Driftkostnader",null,null,null,null,{"$f":"H122+H101","v":0},null,{"$f":"J122+J101","v":0},null,{"$f":"L122+L101","v":0},null,{"$f":"N122+N101","v":0},null,{"$f":"P122+P101","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemensamma kostnader\nIndirekta kostnader (INDI)\nDessa innefattar oftast universitets- och fakultetsgemensamma kostnader samt institutionsgemensamma kostnader.\n\nHär finns även möjlighet att göra ned- eller uppräkning av INDI (kan nyttjas vid flerårigt projekt)."]
[null,null,"C. Gemensamma kostnader"]
[null,null,{"$f":"IF(LEFT($D$28,2)=\"UF\",$D$28,\"Universitetsgem.\")","v":"Universitetsgem."},null,null,null,{"$f":"IF($D$28=\"\",0,IF(LEFT($D$28,2)=\"UF\",VLOOKUP($C$127,'INDI FO 2018'!$C:$G,5,0),VLOOKUP(LEFT($D$28,2),'INDI FO 2018'!$A:$G,6,0)))","v":0.14599999999999999}]
[null,null,{"$f":"IF(LEFT($D$28,2)=\"UF\",\"\",\"Institutionsgem.\")","v":"Institutionsgem."},null,null,null,{"$f":"IF($D$28=\"\",0,IF(LEFT($D$28,2)=\"UF\",\"\",VLOOKUP(LEFT($D$28,2),'INDI FO 2018'!$A:$G,4,0)))","v":7.9000000000000001E-2}]
[null,null,"Ned- / Uppräkning av INDI",null,null,null,0]
[null,null,null,null,null,"INDI Total",{"$f":"SUM(G127:G129)","v":0.22499999999999998}]
[]
[null,null,"Summa Indirekta kostnader",null,null,null,null,{"$f":"(H85+H101)*$G$130","v":0},null,{"$f":"(J85+J101)*$G$130","v":0},null,{"$f":"(L85+L101)*$G$130","v":0},null,{"$f":"(N85+N101)*$G$130","v":0},null,{"$f":"(P85+P101)*$G$130","v":0}]
[]
[]
[null,null,"SUMMA PROJEKTKOSTNADER",null,null,null,null,{"$f":"H85+H124+H132","v":0},null,{"$f":"J85+J124+J132","v":0},null,{"$f":"L85+L124+L132","v":0},null,{"$f":"N85+N124+N132","v":0},null,{"$f":"P85+P124+P132","v":0}]
[]
[]
[null,null,"FINANSIERING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finansiering\nHär redogörs för finansiering av de förväntade kostnader\n\n\nHuvudfinansiär\nHär redogörs för den förväntade huvudfinansieringen av projektets kostnader. Detta är oftast en finansiär men kan givetvis innefatta flera finansieringskällor.\n\nHuvudfinansiärerna är till majoritet KI-externa organisationer och föreningar.\n\nI fritexfält kan vid behov formler nyttjas för beräkning då finansiering baserar sig på regler kopplade till andra kostnadsposter, exempelvis INDI."]
[]
[null,null,"A. Huvudfinansiär"]
[null,null,"Beviljad finansiering",null,null,"Frivillig rubrik","Frivillig rubrik",{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H141+1,\"\")","v":""},null,{"$f":"IFERROR(J141+1,\"\")","v":""},null,{"$f":"IFERROR(L141+1,\"\")","v":""},null,{"$f":"IFERROR(N141+1,\"\")","v":""}]
[null,null,"Finansiär1"]
[null,null,"Finansiär2"]
[]
[]
[null,null,"Summa finansiering",null,null,null,null,{"$f":"SUM(H142:I144)","v":0},null,{"$f":"SUM(J142:K144)","v":0},null,{"$f":"SUM(L142:M144)","v":0},null,{"$f":"SUM(N142:O144)","v":0},null,{"$f":"SUM(P142:Q144)","v":0}]
[]
[null,null,"B. Samfinansiering"]
[null,null,"Samfinansiering / kapital från projekt",null,null,"Frivillig rubrik","Frivillig rubrik",{"$f":"IF($D$30=\"\",\"\",IF($D$29>$D$30,\"Fel i grunduppgifter\",$D$30))","v":""},null,{"$f":"IFERROR(H149+1,\"\")","v":""},null,{"$f":"IFERROR(J149+1,\"\")","v":""},null,{"$f":"IFERROR(L149+1,\"\")","v":""},null,{"$f":"IFERROR(N149+1,\"\")","v":""},null,null,null,null,"Samfinansiering\nInnan något har förts in här visar totalen eller uträkningen längst ner samfinansieringsbehovet som finns. Dvs totalen av de kostnader som inte täcks av huvudfinansiären / -finansiärerna.\n\nEfter behovet av samfinansiering visats kan här redogöras för varifrån och i hur stor omfattning samfinansieringen som kommer, allt eftersom samfinansiering förs in reduseras samfinansieringsbehovet totalt i filen."]
[null,null,"Projekt1"]
[null,null,"Projekt2"]
[]
[]
[null,null,"Samfinansieringsbehov (finansiering - kostnader + samfinansiering)",null,null,null,null,{"$f":"H146-H135+SUM(H150:I151)","v":0},null,{"$f":"J146-J135+SUM(J150:K151)","v":0},null,{"$f":"L146-L135+SUM(L150:M151)","v":0},null,{"$f":"N146-N135+SUM(N150:O151)","v":0},null,{"$f":"P146-P135+SUM(P150:Q151)","v":0}]
[]
[null,null,"Huvudansökanden",null,"Kontrollerad av inst.-ekonom / motsvarande",null,"Prefekt / med motsvarande beslutsrätt"]
[]
[]
[null,null,"Signatur",null,"Signatur",null,"Signatur",null,null,null,null,null,null,null,null,null,null,null,null,null,"Underskrifter\nMallen ska alltid skrivas under av prefekt, eller av den till vilken prefekten delegerat beslutsrätten, när det ansökta bidraget överstiger 100 000 kr."]
[]
[]
[null,null,"Namnförtydligande",null,"Namnförtydligande",null,"Namnförtydligande"]

{"sheet":"Spec-indir-kostn-inst & -proj","index":4,"n_rows":78,"n_cols":9,"rows_kept":78,"cut":false,"hidden":false,"merged":[[15,3,15,4],[16,3,16,4],[25,2,25,3],[26,2,26,3],[2,1,7,10],[14,3,14,4],[27,2,27,3],[28,2,28,3],[29,2,29,3],[44,2,44,3],[18,2,18,3],[30,2,30,3],[31,2,31,3],[42,2,42,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3]]}
[null,"BIDRAGSFORKSNING - BILAGA TILL FULL KOSTNADSTÄCKNINGSKALKYL"]
[]
[null,"Inledning\n\nDenna flik preciserar de gemensamma / indirekta kostnaderna (INDI) för myndigheten Karolinska Institutet, men även för utförande institution samt för det specifika projektet. Fördelningen görs på följande nivåer: Ledning, Utbildning-forskning, Ekonomi-personal, Infrastruktur-service, Bibliotek, Nivåspecifikt övrigt.\n\nSiffrorna i mallen hämtas automatiskt om uppgifterna i bidragsforksningsfliken är korrekt ifyllda."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"GRUNDLÄGGANDE UPPGIFTER"]
[]
[null,null,"Institutions kod",{"$f":"Bidragsforskning!$D$28","v":"C4 - Neuro"}]
[null,null,"Projektledare/-ansvarig",{"$f":"IF(Bidragsforskning!$D31=\"\",\"\",Bidragsforskning!$D31)","v":""}]
[null,null,"Projektnummer - UBW",{"$f":"IF(Bidragsforskning!$D32=\"\",\"\",Bidragsforskning!$D32)","v":""}]
[null,null,"Beskrivnig av projektet",{"$f":"IF(Bidragsforskning!$D33=\"\",\"\",Bidragsforskning!$D33)","v":""}]
[]
[null,null,"Fördelningsbas kostnadsunderlag i tkr:",null,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",VLOOKUP(LEFT(Bidragsforskning!$D$28,2),'INDI FO 2018'!K1:M27,3,0))","v":133500}]
[]
[]
[null,null,"INDIREKTA KOSTNADER KAROLINSKA INSTITUTET I TUSENTALS KR (KSEK)"]
[]
[]
[null,null,null,null,"Universitetsgem\nkostnader - totalt","Institutionsgem\nkostnader - totalt"]
[null,null,"Ledning",null,87994,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C26,'INDI FO 2018'!$T$37:$T$46)/-1000","v":4644.5619999999999}]
[null,null,"Utbildning-forskning",null,101591,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C27,'INDI FO 2018'!$T$37:$T$46)/-1000","v":156.91215}]
[null,null,"Ekonomi-personal",null,75115,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C28,'INDI FO 2018'!$T$37:$T$46)/-1000","v":4795.50569}]
[null,null,"Infrastruktur-service",null,113397,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C29,'INDI FO 2018'!$T$37:$T$46)/-1000","v":949.70945999999992}]
[null,null,"Bibliotek",null,114600,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C30,'INDI FO 2018'!$T$37:$T$46)/-1000","v":0}]
[null,null,"Nivåspecifikt mm",null,10238,{"$f":"SUMIF('INDI FO 2018'!$R$37:$R$46,'Spec-indir-kostn-inst & -proj'!$C31,'INDI FO 2018'!$T$37:$T$46)/-1000","v":0}]
[null,null,"Summa",null,{"$f":"SUM(E26:E31)","v":502935},{"$f":"SUM(F26:F31)","v":10546.6893}]
[]
[]
[null,null,null,null,"Inst andel av\nUniversitetsgem","Inst andel av\nInstitutionsgem","Totalt indirekta kostnader för Inst","% andel av total INDI för Inst"]
[null,null,null,null,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E43/E32)","v":3.8754511020310772E-2},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",100%)","v":1}]
[null,null,"Ledning",null,{"$f":"IF(E$36=\"\",\"\",E$36*E26)","v":3410.1644427212259},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F26*F$36)","v":4644.5619999999999},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E37+F37)","v":8054.7264427212258},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G37=0,0,G37/E$19)))","v":6.0335029533492325E-2}]
[null,null,"Utbildning-forskning",null,{"$f":"IF(E$36=\"\",\"\",E$36*E27)","v":3937.1095290643916},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F27*F$36)","v":156.91215},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E38+F38)","v":4094.0216790643917},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G38=0,0,G38/E$19)))","v":3.0666829056662109E-2}]
[null,null,"Ekonomi-personal",null,2911.0450952906435,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F28*F$36)","v":4795.50569},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E39+F39)","v":7706.550785290643},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G39=0,0,G39/E$19)))","v":5.7726972174461745E-2}]
[null,null,"Infrastruktur-service",null,4394.645286170181,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F29*F$36)","v":949.70945999999992},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E40+F40)","v":5344.354746170181},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G40=0,0,G40/E$19)))","v":4.0032619821499485E-2}]
[null,null,"Bibliotek",null,4441.2669629276143,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F30*F$36)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E41+F41)","v":4441.2669629276143},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G41=0,0,G41/E$19)))","v":3.3267917325300482E-2}]
[null,null,"Nivåspecifikt mm",null,396.76868382594171,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F31*F$36)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E42+F42)","v":396.76868382594171},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",(IF(G42=0,0,G42/E$19)))","v":2.9720500661119227E-3}]
[null,null,"Summa",null,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",VLOOKUP(LEFT(Bidragsforskning!$D$28,2),'INDI FO 2018'!K1:P27,4,0))","v":19491},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",VLOOKUP(LEFT(Bidragsforskning!$D$28,2),'INDI FO 2018'!K1:R27,8,0))","v":10546.5},{"$f":"SUM(G37:G42)","v":30037.689300000002},0]
[]
[null,null,"Andel av total fördelningsbas",null,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",E43/$E$19)","v":0.14599999999999999},{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",F43/$E$19)","v":7.9000000000000001E-2},{"$f":"ROUND(SUM(E45:F45),4)","v":0.22500000000000001},{"$f":"IF(AND(ROUND(SUM(H37:H43),4)=G45,G45=(ROUND(VLOOKUP(LEFT(Bidragsforskning!D28,2),'INDI FO 2018'!A2:G27,7,0),4))),\"VARIABEL CHECK - OK\",\"CONTACT EA\")","v":"VARIABEL CHECK - OK"}]
[null,null,"(Löner och drift; exklusive avskr, lokal och interna -kostnader)"]
[]
[]
[null,null,"INDIREKTA KOSTNADER FÖR SPECIFIKT PROJEKT I HELA KR (SEK)"]
[]
[]
[null,null,null,null,{"$f":"Bidragsforskning!H39","v":""},{"$f":"IFERROR(E52+1,\"\")","v":""},{"$f":"IFERROR(F52+1,\"\")","v":""},{"$f":"IFERROR(G52+1,\"\")","v":""},{"$f":"IFERROR(H52+1,\"\")","v":""}]
[null,null,"Proj. andel av Universitetsgem"]
[null,null,"Ledning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E37/$E$19)/$G$45)","v":0.1135302352965868},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D54*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D54*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D54*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D54*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D54*Bidragsforskning!P$132)","v":0}]
[null,null,"Utbildning-forskning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E38/$E$19)/$G$45)","v":0.13107314287355445},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D55*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D55*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D55*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D55*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D55*Bidragsforskning!P$132)","v":0}]
[null,null,"Ekonomi-personal",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E39/$E$19)/$G$45)","v":9.6913694391698488E-2},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D56*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D56*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D56*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D56*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D56*Bidragsforskning!P$132)","v":0}]
[null,null,"Infrastruktur-service",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E40/$E$19)/$G$45)","v":0.14630529458743838},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D57*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D57*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D57*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D57*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D57*Bidragsforskning!P$132)","v":0}]
[null,null,"Bibliotek",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E41/$E$19)/$G$45)","v":0.14785741033466882},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D58*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D58*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D58*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D58*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D58*Bidragsforskning!P$132)","v":0}]
[null,null,"Nivåspecifikt mm",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E42/$E$19)/$G$45)","v":1.3209111404941878E-2},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D59*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D59*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D59*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D59*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D59*Bidragsforskning!P$132)","v":0}]
[null,null,"Summa",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(E43/$E$19)/$G$45)","v":0.64888888888888885},{"$f":"SUM(E54:E59)","v":0},0,0,0,{"$f":"SUM(I54:I59)","v":0}]
[]
[null,null,"Proj. andel av Institutionsgem"]
[null,null,"Ledning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F37/$E$19)/$G$45)","v":0.15462545151893467},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D63*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D63*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D63*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D63*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D63*Bidragsforskning!P$132)","v":0}]
[null,null,"Utbildning-forskning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F38/$E$19)/$G$45)","v":5.2238751560549313E-3},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D64*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D64*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D64*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D64*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D64*Bidragsforskning!P$132)","v":0}]
[null,null,"Ekonomi-personal",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F39/$E$19)/$G$45)","v":0.15965062638368704},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D65*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D65*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D65*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D65*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D65*Bidragsforskning!P$132)","v":0}]
[null,null,"Infrastruktur-service",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F40/$E$19)/$G$45)","v":3.1617460174781523E-2},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D66*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D66*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D66*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D66*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D66*Bidragsforskning!P$132)","v":0}]
[null,null,"Bibliotek",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F41/$E$19)/$G$45)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D67*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D67*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D67*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D67*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D67*Bidragsforskning!P$132)","v":0}]
[null,null,"Nivåspecifikt mm",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F42/$E$19)/$G$45)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D68*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D68*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D68*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D68*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D68*Bidragsforskning!P$132)","v":0}]
[null,null,"Summa",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(F43/$E$19)/$G$45)","v":0.3511111111111111},{"$f":"SUM(E63:E68)","v":0},0,0,0,0]
[]
[null,null,"Proj. total indirekta kost "]
[null,null,"Ledning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G37/$E$19)/$G$45)","v":0.26815568681552143},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D72*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D72*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D72*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D72*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D72*Bidragsforskning!P$132)","v":0}]
[null,null,"Utbildning-forskning",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G38/$E$19)/$G$45)","v":0.13629701802960936},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D73*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D73*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D73*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D73*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D73*Bidragsforskning!P$132)","v":0}]
[null,null,"Ekonomi-personal",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G39/$E$19)/$G$45)","v":0.25656432077538555},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D74*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D74*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D74*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D74*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D74*Bidragsforskning!P$132)","v":0}]
[null,null,"Infrastruktur-service",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G40/$E$19)/$G$45)","v":0.17792275476221994},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D75*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D75*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D75*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D75*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D75*Bidragsforskning!P$132)","v":0}]
[null,null,"Bibliotek",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G41/$E$19)/$G$45)","v":0.14785741033466882},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D76*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D76*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D76*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D76*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D76*Bidragsforskning!P$132)","v":0}]
[null,null,"Nivåspecifikt mm",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G42/$E$19)/$G$45)","v":1.3209111404941878E-2},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D77*Bidragsforskning!H$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D77*Bidragsforskning!J$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D77*Bidragsforskning!L$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D77*Bidragsforskning!N$132)","v":0},{"$f":"IF(Bidragsforskning!$D$28=\"\",0,$D77*Bidragsforskning!P$132)","v":0}]
[null,null,"Summa",{"$f":"IF(Bidragsforskning!$D$28=\"\",0,(G43/$E$19)/$G$45)","v":1.0000063021223471},{"$f":"SUM(E72:E77)","v":0},0,0,0,0]

{"sheet":"Uppföljning bidrag","index":5,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,1,8,14]]}
[null,"BIDRAGSFORSKNING - STÖD FÖR BUDGET TILL UBW"]
[]
[null,"Inledning\n\nDenna flik summerar kostnader och intäkter som fyllts in i kalkylfliken och återvisar dem i en budgetmodell som enkelt kan föras in i UBWs saldo-tabell för uppföljningsändamål. Posterna till olika konton hämtas beroende på vad som fyllts i under respektive rubrik i kalkylen. \n\nNedan finns två alternativ som kan nyttjas för uppföljning i UBW. Det första som återfinns under rubiken TOTAL BUDGET summerar samtliga intäkter och kostnader för projektet till ett år, och det andra som återfinns under rubriken ÅRSFÖRDELAD BUDGET fördelarar intäkter och kostnader på respektive år.\n\nOBS! Kopiera endast gråa fält och klistra in direkt i UBW (Ctrl + C & Ctrl + V). Se gärna UBW-handbok på medarbetarportalen för ytterligare instruktioner om hur funktionen kan nyttjas."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL BUDGET"]
[]
[null,null,"RR2","Bskrivning","Konto","Inst","Proj","Fin","Anl","Mpt","Verks","Text","Per","Budget (BB)"]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},{"$f":"N26+N33+N40+N47+N54","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},{"$f":"N27+N34+N41+N48+N55","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget totalt \"&Bidragsforskning!$D$32&\"\"","v":"Budget totalt "},{"$f":"Bidragsforskning!$D$30&\"00\"","v":"00"},0]
[]
[null,null,"ÅRSFÖRDELAD BUDGET"]
[]
[null,null,"RR2","Bskrivning","Konto","Inst","Proj","Fin","Anl","Mpt","Verks","Text","Per","Budget (BB)"]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},{"$f":"RIGHT(L26,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!H$146*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},{"$f":"RIGHT(L27,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!H$85","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!H$132","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!I$112:I114)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!H101","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!I$118:I120)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!H$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!I$107:I108)","v":0}]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},{"$f":"RIGHT(L33,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!J$146*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},{"$f":"RIGHT(L34,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!J$85","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!J$132","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!K$112:K114)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!J101","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!K$118:K120)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!J$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!K$107:K108)","v":0}]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},{"$f":"RIGHT(L40,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!L$146*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},{"$f":"RIGHT(L41,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!L$85","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!L$132","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!M$112:M114)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!L101","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!M$118:M120)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!L$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!M$107:M108)","v":0}]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},{"$f":"RIGHT(L47,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!N$146*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},{"$f":"RIGHT(L48,4)&\"00\"","v":"et  00"},{"$f":"Bidragsforskning!N$85","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!N$132","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!O$112:O114)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!N101","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!O$118:O120)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!N$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!O$107:O108)","v":0}]
[null,null,12,"Intäkter av bidrag",35,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!P$146*-1","v":0}]
[null,null,21,"Personalkostnader",40,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!P$85","v":0}]
[null,null,211,"Gemensamma kostnader (INDI)",499,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!P$132","v":0}]
[null,null,22,"Lokalkostnader",50,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!Q$112:Q114)","v":0}]
[null,null,23,"Övriga driftskostnader",52,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"Bidragsforskning!P101","v":0}]
[null,null,23,"Interna kostnader",579,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!Q$118:Q120)","v":0}]
[null,null,24,"Avskrivningar",69,{"$f":"IF(Bidragsforskning!$D$28=\"\",\"\",LEFT(Bidragsforskning!$D$28,2))","v":"C4"},{"$f":"Bidragsforskning!$D$32","v":0},null,null,null,null,{"$f":"\"Budget \"&Bidragsforskning!$D$32&\" \"&Bidragsforskning!P$39","v":"Budget  "},"et  00",{"$f":"SUM(Bidragsforskning!Q$107:Q108)","v":0}]

{"sheet":"INDI FO 2018","index":6,"n_rows":834,"n_cols":25,"rows_kept":834,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Forskning/Forskarutbildning 2018",null,null,null,null,null,null,null,null,null,"Obs kostnadsunderlag är hämtad från INDI budgeten"]
["Inst","Namn",{"$f":"A2&\" - \"&B2","v":"Inst - Namn"},"Institution","Fakultet","Universitet","Summa",null,null,null,null,null,"Kostnadsunderlag (summa kostnadsunderlag FO)","Universitetsgemensam","Univgem andel av total","Fakultetsgemensam","Fackgem andel av total","Insitutionsgemensam","Summa","Andel av total","Uni",null,"Fak"]
["C1","MTC",{"$f":"A3&\" - \"&B3","v":"C1 - MTC"},8.1600000000000006E-2,null,0.14599999999999999,{"$f":"SUM(D3:F3)","v":0.2276},{"$f":"E3+F3","v":0.14599999999999999},null,null,"C1","C1 MTC",188200,{"$f":"M3*F3","v":27477.199999999997},{"$f":"N3/$N$28","v":5.5185480635692362E-2},0,{"$f":"P3/$P$28","v":{"$error":"#DIV/0!"}},{"$f":"D3*M3","v":15357.12},{"$f":"SUM(N3:P3)","v":27477.255185480633},{"$f":"S3/$S$28","v":5.5185591470758272E-2},{"$f":"M3*0.146","v":27477.199999999997},{"$f":"N3/M3","v":0.14599999999999999},{"$f":"M3*0","v":0},{"$f":"P3/M3","v":0}]
["C2","MBB","C2 - MBB",5.7500000000000002E-2,null,0.14599999999999999,{"$f":"SUM(D4:F4)","v":0.20349999999999999},{"$f":"E4+F4","v":0.14599999999999999},null,null,"C2","C2 MBB",233300,{"$f":"M4*F4","v":34061.799999999996},6.8410056494723842E-2,0,{"$f":"P4/$P$28","v":{"$error":"#DIV/0!"}},{"$f":"D4*M4","v":13414.75},34061.868410056493,6.8410193890158899E-2,{"$f":"M4*0.146","v":34061.799999999996},{"$f":"N4/M4","v":0.14599999999999999},{"$f":"M4*0","v":0},0]
["C3","FyFa","C3 - FyFa",7.9000000000000001E-2,null,0.14599999999999999,0.22499999999999998,{"$f":"E5+F5","v":0.14599999999999999},null,null,"C3","C3 Fysiologi & Farmakologi",111350,16257.099999999999,3.265092066304115E-2,0,{"$error":"#DIV/0!"},8796.65,16257.132650920661,3.2650986239473608E-2,16257.099999999999,0.14599999999999999,0,0]
["C4","Neuro","C4 - Neuro",7.9000000000000001E-2,null,0.14599999999999999,0.22499999999999998,0.14599999999999999,null,null,"C4","C4 Neurovetenskap",133500,19491,3.9145917454117593E-2,0,{"$error":"#DIV/0!"},10546.5,19491.039145917453,3.9145996075165938E-2,19491,0.14599999999999999,0,0]
["C5","CMB","C5 - CMB",7.8700000000000006E-2,null,0.14599999999999999,0.22470000000000001,0.14599999999999999,null,null,"C5","C5 CMB",141950,20724.699999999997,4.1623692753647877E-2,0,{"$error":"#DIV/0!"},11171.465,20724.741623692749,4.1623776351084676E-2,20724.699999999997,0.14599999999999999,0,0]
["C6","IMM","C6 - IMM",9.5799999999999996E-2,null,0.14599999999999999,0.24179999999999999,0.14599999999999999,null,null,"C6","C6 IMM",151000,22046,4.4277404760837129E-2,0,{"$error":"#DIV/0!"},14465.8,22046.044277404762,4.427749368801541E-2,22046,0.14599999999999999,0,0]
["C7","LIME","C7 - LIME",0.13250000000000001,null,0.14599999999999999,0.27849999999999997,0.14599999999999999,null,null,"C7","C7 LIME",66000,9636,1.9353037842485103E-2,0,{"$error":"#DIV/0!"},8745,9636.0193530378419,1.9353076711317991E-2,9636,0.14599999999999999,0,0]
["C8","MEB","C8 - MEB",0.1152,null,0.14599999999999999,0.26119999999999999,0.14599999999999999,null,null,"C8","C8 MEB",178150,26009.899999999998,5.2238540782404856E-2,0,{"$error":"#DIV/0!"},20522.88,26009.95223854078,5.2238645698807575E-2,26009.899999999998,0.14599999999999999,0,0]
["CC","KM","CC - KM",0.104,null,0.14599999999999999,0.25,0.14599999999999999,null,null,"CC","CC Komparativ Medicin",91800,13402.8,2.6918316271820186E-2,0,{"$error":"#DIV/0!"},9547.1999999999989,13402.826918316272,2.6918370334833207E-2,13402.8,0.14599999999999999,0,0]
["CD","ETV","CD - ETV",0.161,null,0.14599999999999999,0.307,0.14599999999999999,null,null,"CD","CD SweTox",37861,5527.7059999999992,1.1101899481126188E-2,0,{"$error":"#DIV/0!"},6095.6210000000001,5527.7171018994804,1.1101921778291068E-2,5527.7059999999992,0.14599999999999999,0,0]
["D1","KIDS","D1 - KIDS",7.4999999999999997E-2,null,0.14599999999999999,0.22099999999999997,0.14599999999999999,null,null,"D1","D1 KI vid Danderyds sjukhus",41300,6029.7999999999993,1.21103100438581E-2,0,{"$error":"#DIV/0!"},3097.5,6029.812110310043,1.2110334366324742E-2,6029.7999999999993,0.14599999999999999,0,0]
["H1","NVS","H1 - NVS",6.9000000000000006E-2,null,0.14599999999999999,0.215,0.14599999999999999,null,null,"H1","H1 Nerurobio, Vårdvet & Samhälle",192448,28097.407999999999,5.6431112525917766E-2,0,{"$error":"#DIV/0!"},13278.912,28097.464431112527,5.643122586272311E-2,28097.407999999999,0.14599999999999999,0,0]
["H2","BioNut","H2 - BioNut",9.0899999999999995E-2,null,0.14599999999999999,0.2369,0.14599999999999999,null,null,"H2","H2 Biovetenskaper & Näringslära",143000,20878,4.1931581992051055E-2,0,{"$error":"#DIV/0!"},12998.699999999999,20878.041931581993,4.1931666207855649E-2,20878,0.14599999999999999,0,0]
["H5","LABMED","H5 - LABMED",5.8999999999999997E-2,null,0.14599999999999999,0.20499999999999999,0.14599999999999999,null,null,"H5","H5 Laboratoriemedicin",160600,23447.599999999999,4.709239208338041E-2,0,{"$error":"#DIV/0!"},9475.4,23447.647092392082,4.7092486664207116E-2,23447.599999999999,0.14599999999999999,0,0]
["H7","MedH","H7 - MedH",5.8900000000000001E-2,null,0.14599999999999999,0.2049,0.14599999999999999,null,null,"H7","H7 Medicin - Huddinge",234446,34229.115999999995,6.8746095606352448E-2,0,{"$error":"#DIV/0!"},13808.8694,34229.184746095598,6.8746233676691776E-2,34229.115999999995,0.14599999999999996,0,0]
["H9","CLINTEC","H9 - CLINTEC",0.1016,null,0.14599999999999999,0.24759999999999999,0.14599999999999999,null,null,"H9","H9 Clintec",93200,13607.199999999999,2.7328835256357747E-2,0,{"$error":"#DIV/0!"},9469.119999999999,13607.227328835255,2.7328890143861164E-2,13607.199999999999,0.14599999999999999,0,0]
["K1","MMK","K1 - MMK",8.4000000000000005E-2,null,0.14599999999999999,0.22999999999999998,0.14599999999999999,null,null,"K1","K1 Molykylär medicin & Kirurgi",146800,21432.799999999999,4.3045847807224438E-2,0,{"$error":"#DIV/0!"},12331.2,21432.843045847807,4.3045934260931534E-2,21432.799999999999,0.14599999999999999,0,0]
["K2","MedS","K2 - MedS",8.4000000000000005E-2,null,0.14599999999999999,0.22999999999999998,0.14599999999999999,null,null,"K2","K2 Medicin - Solna",332937,48608.801999999996,9.7626399396416083E-2,0,{"$error":"#DIV/0!"},27966.708000000002,48608.89962639939,9.7626595470243605E-2,48608.801999999996,0.14599999999999999,0,0]
["K6","KBH","K6 - KBH",7.3999999999999996E-2,null,0.14599999999999999,0.21999999999999997,0.14599999999999999,null,null,"K6","K6 Kvinnors & barns hälsa",136000,19856,3.9878987069363242E-2,0,{"$error":"#DIV/0!"},10064,19856.039878987071,3.9879067162715866E-2,19856,0.14599999999999999,0,0]
["K7","OnkPat","K7 - OnkPat",9.2999999999999999E-2,null,0.14599999999999999,0.23899999999999999,0.14599999999999999,null,null,"K7","K7 Onkologi & Patologi",169347.01326799998,24724.663937127996,4.9657259943748942E-2,0,{"$error":"#DIV/0!"},15749.272233923997,24724.71359438794,4.9657359675881654E-2,24724.663937127996,0.14599999999999999,0,0]
["K8","CNS","K8 - CNS",6.9000000000000006E-2,null,0.14599999999999999,0.215,0.14599999999999999,null,null,"K8","K8 Klinisk neurovetenskap",270000,39420,7.9171518446529962E-2,0,{"$error":"#DIV/0!"},18630,39420.079171518446,7.917167745539179E-2,39420,0.14599999999999999,0,0]
["K9","PHS","K9 - PHS",0.104,null,0.14599999999999999,0.25,0.14599999999999999,null,null,"K9","K9 Folkhälsovetenskap",96000,14016,2.8149873225432876E-2,0,{"$error":"#DIV/0!"},9984,14016.028149873226,2.8149929761917079E-2,14016,0.14599999999999999,0,0]
["OF","DENTMED","OF - DENTMED",0.17399999999999999,null,0.14599999999999999,0.31999999999999995,0.14599999999999999,null,null,"OF","OF Odontologi",28753,4197.9380000000001,8.431180258863245E-3,0,{"$error":"#DIV/0!"},5003.0219999999999,4197.9464311802585,8.4311971921291855E-3,4197.9380000000001,0.14599999999999999,0,0]
["OV","Uni.tandv.","OV - Uni.tandv.",0.1656,null,4.9799999999999997E-2,0.21539999999999998,4.9799999999999997E-2,null,null,"OV","OV Universitetstandvården",28306.699999999997,1409.6736599999997,2.8312025412551341E-3,0,{"$error":"#DIV/0!"},4687.5895199999995,1409.676491202541,2.8312082274703602E-3,{"$f":"M26*0.0498","v":1409.6736599999997},4.9799999999999997E-2,0,{"$f":"P26/O26","v":0},"egen procent på OV"]
["S1","SÖS","S1 - SÖS",0.104,null,0.14599999999999999,0.25,0.14599999999999999,null,null,"S1","S1 KI vid Södersjukhuset",22720,3317.12,6.6621366633524467E-3,0,{"$error":"#DIV/0!"},2362.88,3317.1266621366631,6.6621500436537086E-3,3317.12,0.14599999999999999,0,{"$f":"P27/M27","v":0}]
["UF","Externt","UF - Externt",null,null,null,0.39,null,null,null,null,null,{"$f":"SUM(M3:M27)","v":3428968.7132680002},{"$f":"SUM(N3:N27)","v":497906.32759712788},null,{"$f":"SUM(P3:P27)","v":0},null,null,497906.32759712788]
["UF","Internt","UF - Internt",null,null,null,0.16]
[]
[]
[]
[]
[]
["All INDI budget",null,null,null,null,null,null,null,null,null,null,"Arbetsgivaransvar",null,null,null,"Beräkning för att få fördelningen på respektive nivå för inst"]
[null,null,null,null,null,null,null,null,null,null,null,"Hämtad från slutliga INDI budget",null,null,null,"Forskningsrelaterade projekt","Grp1","HuvudGrp","HuvudGrpEng"]
["Konto","Inst","Proj","Fin","Anl","Mpt","Verks","Text","Per","Budget (BB)",null,"Inst","arbetsgivaransvar i KSEK","arbetsgivaransvar i SEK",null,81008002,"Ledning","Ledning","Management",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P37)+SUMIF($L$38:$L$62,LEFT(Bidragsforskning!$D$28,2),'INDI FO 2018'!$N$38:$N$62)","v":-4644562},"Egen kalkylering på denna rad med arbetsgivaransvar"]
[39498,"C1","C181008001",null,null,null,18,"2019 Budget",201900,-207494.09,null,"C1",2450,{"$f":"M38*-1000","v":-2450000},null,81008012,"Ledning/Biomedicum FFU","Ledning","Management",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P38)","v":0}]
[40,"C1","C181008001",null,null,null,18,"2019 Budget",201900,159894.09,null,"C2",2450,-2450000,null,82008002,"Utb eller forskningsadmin","Utbildning-forskning","Education-research",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P39)","v":-156912.15}]
[49,"C1","C181008001",null,null,null,18,"2019 Budget",201900,25000,null,"C3",1380,-1380000,null,82008012,"FFU Administration Biomedicum","Utbildning-forskning","Education-research",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P40)","v":0}]
[50,"C1","C181008001",null,null,null,18,"2019 Budget",201900,17500,null,"C4",1500,-1500000,null,83008002,"Ekonomi-personal","Ekonomi-personal","Finances-staff",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P41)","v":-4795505.6900000004}]
[57,"C1","C181008001",null,null,null,18,"2019 Budget",201900,5000,null,"C5",1967.5,-1967500,null,83008012,"Ekonomi/Personal Biomedicum FFU","Ekonomi-personal","Finances-staff",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P42)","v":0}]
[69,"C1","C181008001",null,null,null,18,"2019 Budget",201900,100,null,"C6",0,0,null,84008002,"Infrastruktur","Infrastruktur-service","Infrastructure-service",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P43)","v":-33000}]
[39498,"C1","C181008002",null,null,null,28,"2019 Budget",201900,-3848796.47,null,"C7",483,-483000,null,84008012,"Infrastruktur/Biomedicum GU","Infrastruktur-service","Infrastructure-service",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P44)","v":-916709.46}]
[40,"C1","C181008002",null,null,null,28,"2019 Budget",201900,2944396.47,null,"C8",400,-400000,null,null,null,"Bibliotek","Library",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P45)","v":0}]
[49,"C1","C181008002",null,null,null,28,"2019 Budget",201900,475000,null,"CC",0,0,null,null,null,"Nivåspecifikt mm","Level specific, etc.",{"$f":"SUMIFS($J$38:$J$1397,$A$38:$A$1397,\"39498\",$C$38:$C$1397,LEFT(Bidragsforskning!$D$28,2)&'INDI FO 2018'!$P46)","v":0}]
[50,"C1","C181008002",null,null,null,28,"2019 Budget",201900,332500,null,"CD",0,0]
[57,"C1","C181008002",null,null,null,28,"2019 Budget",201900,95000,null,"D1",300,-300000]
[69,"C1","C181008002",null,null,null,28,"2019 Budget",201900,1900,null,"H1",1820,-1820000]
[39498,"C1","C182008001",null,null,null,18,"2019 Budget",201900,-387166.48,null,"H2",800,-800000]
[40,"C1","C182008001",null,null,null,18,"2019 Budget",201900,372916.47999999998,null,"H5",0,0]
[49,"C1","C182008001",null,null,null,18,"2019 Budget",201900,500,null,"H7",0,0]
[50,"C1","C182008001",null,null,null,18,"2019 Budget",201900,12500,null,"H9",90,-90000]
[57,"C1","C182008001",null,null,null,18,"2019 Budget",201900,1000,null,"K1",1460,-1460000]
[69,"C1","C182008001",null,null,null,18,"2019 Budget",201900,250,null,"K2",3329.37,-3329370]
[39498,"C1","C182008002",null,null,null,28,"2019 Budget",201900,-844072.86,null,"K6",0,0]
[40,"C1","C182008002",null,null,null,28,"2019 Budget",201900,573322.86,null,"K7",1425,-1425000]
[49,"C1","C182008002",null,null,null,28,"2019 Budget",201900,9500,null,"K8",2675,-2675000]
[50,"C1","C182008002",null,null,null,28,"2019 Budget",201900,237500,null,"K9",270,-270000]
[57,"C1","C182008002",null,null,null,28,"2019 Budget",201900,19000,null,"OF",0,0]
[69,"C1","C182008002",null,null,null,28,"2019 Budget",201900,4750,null,"OV",0,0]
[39498,"C1","C183008001",null,null,null,18,"2019 Budget",201900,-437470.23,null,"S1",0,0]
[40,"C1","C183008001",null,null,null,18,"2019 Budget",201900,296220.23]
[49,"C1","C183008001",null,null,null,18,"2019 Budget",201900,3500]
[50,"C1","C183008001",null,null,null,18,"2019 Budget",201900,17500]
[57,"C1","C183008001",null,null,null,18,"2019 Budget",201900,120000]
[69,"C1","C183008001",null,null,null,18,"2019 Budget",201900,250]
[39498,"C1","C183008002",null,null,null,28,"2019 Budget",201900,-8133808.2300000004]
[40,"C1","C183008002",null,null,null,28,"2019 Budget",201900,5450058.2300000004]
[49,"C1","C183008002",null,null,null,28,"2019 Budget",201900,66500]
[50,"C1","C183008002",null,null,null,28,"2019 Budget",201900,332500]
[57,"C1","C183008002",null,null,null,28,"2019 Budget",201900,2280000]
[69,"C1","C183008002",null,null,null,28,"2019 Budget",201900,4750]
[39498,"C1","C184008012",null,null,null,28,"2019 Budget",201900,-82339.199999999997]
[40,"C1","C184008012",null,null,null,28,"2019 Budget",201900,82339.199999999997]
[39498,"C2","C281008001",null,null,null,18,"2019 Budget",201900,-175255.8]
[40,"C2","C281008001",null,null,null,18,"2019 Budget",201900,167255.79999999999]
[49,"C2","C281008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"C2","C281008001",null,null,null,18,"2019 Budget",201900,3000]
[39498,"C2","C281008002",null,null,null,28,"2019 Budget",201900,-2665020.0099999998]
[40,"C2","C281008002",null,null,null,28,"2019 Budget",201900,2503020.0099999998]
[49,"C2","C281008002",null,null,null,28,"2019 Budget",201900,50000]
[50,"C2","C281008002",null,null,null,28,"2019 Budget",201900,38000]
[57,"C2","C281008002",null,null,null,28,"2019 Budget",201900,74000]
[39498,"C2","C282008001",null,null,null,18,"2019 Budget",201900,-381763.46]
[40,"C2","C282008001",null,null,null,18,"2019 Budget",201900,367763.46]
[69,"C2","C282008001",null,null,null,18,"2019 Budget",201900,14000]
[39498,"C2","C282008002",null,null,null,28,"2019 Budget",201900,-114117.56]
[40,"C2","C282008002",null,null,null,28,"2019 Budget",201900,114117.56]
[39498,"C2","C283008001",null,null,null,18,"2019 Budget",201900,-222314.86]
[40,"C2","C283008001",null,null,null,18,"2019 Budget",201900,153314.85999999999]
[49,"C2","C283008001",null,null,null,18,"2019 Budget",201900,3000]
[50,"C2","C283008001",null,null,null,18,"2019 Budget",201900,26000]
[57,"C2","C283008001",null,null,null,18,"2019 Budget",201900,40000]
[39498,"C2","C283008002",null,null,null,28,"2019 Budget",201900,-6295511.2599999998]
[40,"C2","C283008002",null,null,null,28,"2019 Budget",201900,4098511.26]
[49,"C2","C283008002",null,null,null,28,"2019 Budget",201900,47000]
[50,"C2","C283008002",null,null,null,28,"2019 Budget",201900,619000]
[57,"C2","C283008002",null,null,null,28,"2019 Budget",201900,1531000]
[39498,"C2","C284008001",null,null,null,18,"2019 Budget",201900,-93406.65]
[40,"C2","C284008001",null,null,null,18,"2019 Budget",201900,18406.650000000001]
[57,"C2","C284008001",null,null,null,18,"2019 Budget",201900,75000]
[39498,"C2","C284008002",null,null,null,28,"2019 Budget",201900,-578659.88]
[40,"C2","C284008002",null,null,null,28,"2019 Budget",201900,165659.88]
[57,"C2","C284008002",null,null,null,28,"2019 Budget",201900,413000]
[39498,"C2","C284008011",null,null,null,18,"2019 Budget",201900,-29979.51]
[40,"C2","C284008011",null,null,null,18,"2019 Budget",201900,9979.51]
[57,"C2","C284008011",null,null,null,18,"2019 Budget",201900,20000]
[39498,"C2","C284008012",null,null,null,28,"2019 Budget",201900,-1322610.71]
[40,"C2","C284008012",null,null,null,28,"2019 Budget",201900,189610.71]
[49,"C2","C284008012",null,null,null,28,"2019 Budget",201900,13000]
[57,"C2","C284008012",null,null,null,28,"2019 Budget",201900,1020000]
[69,"C2","C284008012",null,null,null,28,"2019 Budget",201900,100000]
[39498,"C3","C381008001",null,null,null,18,"2019 Budget",201900,-686716.48]
[40,"C3","C381008001",null,null,null,18,"2019 Budget",201900,586716.48]
[49,"C3","C381008001",null,null,null,18,"2019 Budget",201900,50000]
[57,"C3","C381008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"C3","C381008002",null,null,null,28,"2019 Budget",201900,-2658500]
[40,"C3","C381008002",null,null,null,28,"2019 Budget",201900,2188500]
[49,"C3","C381008002",null,null,null,28,"2019 Budget",201900,200000]
[50,"C3","C381008002",null,null,null,28,"2019 Budget",201900,120000]
[57,"C3","C381008002",null,null,null,28,"2019 Budget",201900,150000]
[39498,"C3","C382008001",null,null,null,18,"2019 Budget",201900,-753321.6]
[40,"C3","C382008001",null,null,null,18,"2019 Budget",201900,638321.6]
[49,"C3","C382008001",null,null,null,18,"2019 Budget",201900,50000]
[57,"C3","C382008001",null,null,null,18,"2019 Budget",201900,65000]
[39498,"C3","C382008002",null,null,null,28,"2019 Budget",201900,-380200]
[40,"C3","C382008002",null,null,null,28,"2019 Budget",201900,170200]
[49,"C3","C382008002",null,null,null,28,"2019 Budget",201900,40000]
[50,"C3","C382008002",null,null,null,28,"2019 Budget",201900,120000]
[57,"C3","C382008002",null,null,null,28,"2019 Budget",201900,50000]
[39498,"C3","C383008001",null,null,null,18,"2019 Budget",201900,-562000]
[40,"C3","C383008001",null,null,null,18,"2019 Budget",201900,545000]
[49,"C3","C383008001",null,null,null,18,"2019 Budget",201900,17000]
[39498,"C3","C383008002",null,null,null,28,"2019 Budget",201900,-3643990]
[40,"C3","C383008002",null,null,null,28,"2019 Budget",201900,2293990]
[49,"C3","C383008002",null,null,null,28,"2019 Budget",201900,150000]
[50,"C3","C383008002",null,null,null,28,"2019 Budget",201900,200000]
[57,"C3","C383008002",null,null,null,28,"2019 Budget",201900,1000000]
[39498,"C3","C384008001",null,null,null,18,"2019 Budget",201900,-100000]
[57,"C3","C384008001",null,null,null,18,"2019 Budget",201900,100000]
[39498,"C3","C384008002",null,null,null,28,"2019 Budget",201900,-734400]
[40,"C3","C384008002",null,null,null,28,"2019 Budget",201900,134400]
[57,"C3","C384008002",null,null,null,28,"2019 Budget",201900,600000]
[39498,"C4","C481008001",null,null,null,18,"2019 Budget",201900,-438595.81]
[40,"C4","C481008001",null,null,null,18,"2019 Budget",201900,424595.81]
[49,"C4","C481008001",null,null,null,18,"2019 Budget",201900,6000]
[50,"C4","C481008001",null,null,null,18,"2019 Budget",201900,8000]
[39498,"C4","C481008002",null,null,null,28,"2019 Budget",201900,-3144562]
[40,"C4","C481008002",null,null,null,28,"2019 Budget",201900,2624562]
[49,"C4","C481008002",null,null,null,28,"2019 Budget",201900,54000]
[50,"C4","C481008002",null,null,null,28,"2019 Budget",201900,66000]
[57,"C4","C481008002",null,null,null,28,"2019 Budget",201900,400000]
[39498,"C4","C482008001",null,null,null,18,"2019 Budget",201900,-693097.68]
[40,"C4","C482008001",null,null,null,18,"2019 Budget",201900,613097.68000000005]
[49,"C4","C482008001",null,null,null,18,"2019 Budget",201900,10000]
[50,"C4","C482008001",null,null,null,18,"2019 Budget",201900,50000]
[57,"C4","C482008001",null,null,null,18,"2019 Budget",201900,20000]
[39498,"C4","C482008002",null,null,null,28,"2019 Budget",201900,-156912.15]
[40,"C4","C482008002",null,null,null,28,"2019 Budget",201900,126912.15]
[49,"C4","C482008002",null,null,null,28,"2019 Budget",201900,10000]
[57,"C4","C482008002",null,null,null,28,"2019 Budget",201900,20000]
[39498,"C4","C483008001",null,null,null,18,"2019 Budget",201900,-505671.97]
[40,"C4","C483008001",null,null,null,18,"2019 Budget",201900,367671.97]
[49,"C4","C483008001",null,null,null,18,"2019 Budget",201900,10000]
[50,"C4","C483008001",null,null,null,18,"2019 Budget",201900,45000]
[57,"C4","C483008001",null,null,null,18,"2019 Budget",201900,83000]
[39498,"C4","C483008002",null,null,null,28,"2019 Budget",201900,-4795505.6900000004]
[40,"C4","C483008002",null,null,null,28,"2019 Budget",201900,2562505.69]
[49,"C4","C483008002",null,null,null,28,"2019 Budget",201900,190000]
[50,"C4","C483008002",null,null,null,28,"2019 Budget",201900,405000]
[57,"C4","C483008002",null,null,null,28,"2019 Budget",201900,1638000]
[39498,"C4","C484008002",null,null,null,28,"2019 Budget",201900,-33000]
[57,"C4","C484008002",null,null,null,28,"2019 Budget",201900,33000]
[39498,"C4","C484008012",null,null,null,28,"2019 Budget",201900,-916709.46]
[40,"C4","C484008012",null,null,null,28,"2019 Budget",201900,216709.46]
[49,"C4","C484008012",null,null,null,28,"2019 Budget",201900,100000]
[50,"C4","C484008012",null,null,null,28,"2019 Budget",201900,50000]
[57,"C4","C484008012",null,null,null,28,"2019 Budget",201900,550000]
[39498,"C5","C581008001",null,null,null,18,"2019 Budget",201900,-55500]
[40,"C5","C581008001",null,null,null,18,"2019 Budget",201900,55500]
[39498,"C5","C581008002",null,null,null,28,"2019 Budget",201900,-1748500]
[40,"C5","C581008002",null,null,null,28,"2019 Budget",201900,1748500]
[39498,"C5","C582008001",null,null,null,18,"2019 Budget",201900,-147200]
[40,"C5","C582008001",null,null,null,18,"2019 Budget",201900,147200]
[39498,"C5","C582008002",null,null,null,28,"2019 Budget",201900,-859550]
[40,"C5","C582008002",null,null,null,28,"2019 Budget",201900,859550]
[39498,"C5","C583008001",null,null,null,18,"2019 Budget",201900,-122850]
[40,"C5","C583008001",null,null,null,18,"2019 Budget",201900,122850]
[39498,"C5","C583008002",null,null,null,28,"2019 Budget",201900,-5993650]
[40,"C5","C583008002",null,null,null,28,"2019 Budget",201900,4093650]
[49,"C5","C583008002",null,null,null,28,"2019 Budget",201900,250000]
[50,"C5","C583008002",null,null,null,28,"2019 Budget",201900,550000]
[57,"C5","C583008002",null,null,null,28,"2019 Budget",201900,1100000]
[39498,"C5","C584008001",null,null,null,18,"2019 Budget",201900,-26750]
[40,"C5","C584008001",null,null,null,18,"2019 Budget",201900,26750]
[39498,"C5","C584008002",null,null,null,28,"2019 Budget",201900,-361500]
[40,"C5","C584008002",null,null,null,28,"2019 Budget",201900,361500]
[39498,"C5","C584008011",null,null,null,18,"2019 Budget",201900,-20000]
[40,"C5","C584008011",null,null,null,18,"2019 Budget",201900,20000]
[39498,"C5","C584008012",null,null,null,28,"2019 Budget",201900,-247000]
[40,"C5","C584008012",null,null,null,28,"2019 Budget",201900,247000]
[39498,"C6","C681008001",null,null,null,18,"2019 Budget",201900,-175656.95999999999]
[40,"C6","C681008001",null,null,null,18,"2019 Budget",201900,175656.95999999999]
[39498,"C6","C681008002",null,null,null,28,"2019 Budget",201900,-4354714.88]
[40,"C6","C681008002",null,null,null,28,"2019 Budget",201900,3431714.88]
[49,"C6","C681008002",null,null,null,28,"2019 Budget",201900,550000]
[50,"C6","C681008002",null,null,null,28,"2019 Budget",201900,173000]
[57,"C6","C681008002",null,null,null,28,"2019 Budget",201900,200000]
[39498,"C6","C682008001",null,null,null,18,"2019 Budget",201900,-1217749.57]
[40,"C6","C682008001",null,null,null,18,"2019 Budget",201900,1118749.57]
[50,"C6","C682008001",null,null,null,18,"2019 Budget",201900,99000]
[39498,"C6","C682008002",null,null,null,28,"2019 Budget",201900,-1146079.81]
[40,"C6","C682008002",null,null,null,28,"2019 Budget",201900,1023079.81]
[50,"C6","C682008002",null,null,null,28,"2019 Budget",201900,123000]
[39498,"C6","C683008001",null,null,null,18,"2019 Budget",201900,-92463.87]
[40,"C6","C683008001",null,null,null,18,"2019 Budget",201900,92463.87]
[39498,"C6","C683008002",null,null,null,28,"2019 Budget",201900,-5658707.9699999997]
[40,"C6","C683008002",null,null,null,28,"2019 Budget",201900,4086707.97]
[49,"C6","C683008002",null,null,null,28,"2019 Budget",201900,905000]
[50,"C6","C683008002",null,null,null,28,"2019 Budget",201900,317000]
[57,"C6","C683008002",null,null,null,28,"2019 Budget",201900,350000]
[39498,"C6","C684008001",null,null,null,18,"2019 Budget",201900,-53977.919999999998]
[40,"C6","C684008001",null,null,null,18,"2019 Budget",201900,53977.919999999998]
[39498,"C6","C684008002",null,null,null,28,"2019 Budget",201900,-3308807.04]
[40,"C6","C684008002",null,null,null,28,"2019 Budget",201900,2957807.04]
[50,"C6","C684008002",null,null,null,28,"2019 Budget",201900,230000]
[57,"C6","C684008002",null,null,null,28,"2019 Budget",201900,100000]
[69,"C6","C684008002",null,null,null,28,"2019 Budget",201900,21000]
[39498,"C7","C781008001",null,null,null,18,"2019 Budget",201900,-837980]
[40,"C7","C781008001",null,null,null,18,"2019 Budget",201900,666980]
[49,"C7","C781008001",null,null,null,18,"2019 Budget",201900,31000]
[57,"C7","C781008001",null,null,null,18,"2019 Budget",201900,140000]
[39498,"C7","C781008002",null,null,null,28,"2019 Budget",201900,-1915320]
[40,"C7","C781008002",null,null,null,28,"2019 Budget",201900,1534320]
[49,"C7","C781008002",null,null,null,28,"2019 Budget",201900,69000]
[57,"C7","C781008002",null,null,null,28,"2019 Budget",201900,312000]
[39498,"C7","C782008001",null,null,null,18,"2019 Budget",201900,-319000]
[49,"C7","C782008001",null,null,null,18,"2019 Budget",201900,196000]
[50,"C7","C782008001",null,null,null,18,"2019 Budget",201900,123000]
[39498,"C7","C782008002",null,null,null,28,"2019 Budget",201900,-710000]
[49,"C7","C782008002",null,null,null,28,"2019 Budget",201900,437000]
[50,"C7","C782008002",null,null,null,28,"2019 Budget",201900,273000]
[39498,"C7","C783008001",null,null,null,18,"2019 Budget",201900,-1621000]
[49,"C7","C783008001",null,null,null,18,"2019 Budget",201900,1483000]
[50,"C7","C783008001",null,null,null,18,"2019 Budget",201900,123000]
[57,"C7","C783008001",null,null,null,18,"2019 Budget",201900,15000]
[39498,"C7","C783008002",null,null,null,28,"2019 Budget",201900,-3607000]
[49,"C7","C783008002",null,null,null,28,"2019 Budget",201900,3300000]
[50,"C7","C783008002",null,null,null,28,"2019 Budget",201900,273000]
[57,"C7","C783008002",null,null,null,28,"2019 Budget",201900,34000]
[39498,"C7","C784008001",null,null,null,18,"2019 Budget",201900,-916000]
[49,"C7","C784008001",null,null,null,18,"2019 Budget",201900,417000]
[50,"C7","C784008001",null,null,null,18,"2019 Budget",201900,123000]
[57,"C7","C784008001",null,null,null,18,"2019 Budget",201900,376000]
[39498,"C7","C784008002",null,null,null,28,"2019 Budget",201900,-2027000]
[49,"C7","C784008002",null,null,null,28,"2019 Budget",201900,929000]
[50,"C7","C784008002",null,null,null,28,"2019 Budget",201900,273000]
[57,"C7","C784008002",null,null,null,28,"2019 Budget",201900,825000]
[39498,"C8","C881008001",null,null,null,18,"2019 Budget",201900,-153500]
[40,"C8","C881008001",null,null,null,18,"2019 Budget",201900,149500]
[50,"C8","C881008001",null,null,null,18,"2019 Budget",201900,4000]
[39498,"C8","C881008002",null,null,null,28,"2019 Budget",201900,-1704500]
[40,"C8","C881008002",null,null,null,28,"2019 Budget",201900,1604500]
[50,"C8","C881008002",null,null,null,28,"2019 Budget",201900,80000]
[57,"C8","C881008002",null,null,null,28,"2019 Budget",201900,20000]
[39498,"C8","C882008001",null,null,null,18,"2019 Budget",201900,-423500]
[40,"C8","C882008001",null,null,null,18,"2019 Budget",201900,420500]
[50,"C8","C882008001",null,null,null,18,"2019 Budget",201900,3000]
[39498,"C8","C882008002",null,null,null,28,"2019 Budget",201900,-755250]
[40,"C8","C882008002",null,null,null,28,"2019 Budget",201900,677250]
[50,"C8","C882008002",null,null,null,28,"2019 Budget",201900,58000]
[57,"C8","C882008002",null,null,null,28,"2019 Budget",201900,20000]
[39498,"C8","C883008001",null,null,null,18,"2019 Budget",201900,-457500]
[40,"C8","C883008001",null,null,null,18,"2019 Budget",201900,373500]
[49,"C8","C883008001",null,null,null,18,"2019 Budget",201900,10000]
[50,"C8","C883008001",null,null,null,18,"2019 Budget",201900,44000]
[57,"C8","C883008001",null,null,null,18,"2019 Budget",201900,30000]
[39498,"C8","C883008002",null,null,null,28,"2019 Budget",201900,-7990500]
[40,"C8","C883008002",null,null,null,28,"2019 Budget",201900,6430500]
[49,"C8","C883008002",null,null,null,28,"2019 Budget",201900,160000]
[50,"C8","C883008002",null,null,null,28,"2019 Budget",201900,830000]
[57,"C8","C883008002",null,null,null,28,"2019 Budget",201900,570000]
[39498,"C8","C884008001",null,null,null,18,"2019 Budget",201900,-203000]
[40,"C8","C884008001",null,null,null,18,"2019 Budget",201900,166000]
[49,"C8","C884008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"C8","C884008001",null,null,null,18,"2019 Budget",201900,30000]
[57,"C8","C884008001",null,null,null,18,"2019 Budget",201900,2000]
[39498,"C8","C884008002",null,null,null,28,"2019 Budget",201900,-2450000]
[40,"C8","C884008002",null,null,null,28,"2019 Budget",201900,1822000]
[49,"C8","C884008002",null,null,null,28,"2019 Budget",201900,20000]
[50,"C8","C884008002",null,null,null,28,"2019 Budget",201900,570000]
[57,"C8","C884008002",null,null,null,28,"2019 Budget",201900,38000]
[39498,"C8","C884008011",null,null,null,18,"2019 Budget",201900,-379500]
[40,"C8","C884008011",null,null,null,18,"2019 Budget",201900,304500]
[49,"C8","C884008011",null,null,null,18,"2019 Budget",201900,10000]
[50,"C8","C884008011",null,null,null,18,"2019 Budget",201900,40000]
[57,"C8","C884008011",null,null,null,18,"2019 Budget",201900,25000]
[39498,"C8","C884008012",null,null,null,28,"2019 Budget",201900,-7231500]
[40,"C8","C884008012",null,null,null,28,"2019 Budget",201900,5785500]
[49,"C8","C884008012",null,null,null,28,"2019 Budget",201900,140000]
[50,"C8","C884008012",null,null,null,28,"2019 Budget",201900,764000]
[57,"C8","C884008012",null,null,null,28,"2019 Budget",201900,535000]
[69,"C8","C884008012",null,null,null,28,"2019 Budget",201900,7000]
[39498,"CC","CC81008002",null,null,null,28,"2019 Budget",201900,-2476900]
[40,"CC","CC81008002",null,null,null,28,"2019 Budget",201900,1725900]
[49,"CC","CC81008002",null,null,null,28,"2019 Budget",201900,193000]
[50,"CC","CC81008002",null,null,null,28,"2019 Budget",201900,126000]
[57,"CC","CC81008002",null,null,null,28,"2019 Budget",201900,432000]
[39498,"CC","CC82008001",null,null,null,18,"2019 Budget",201900,-39000]
[40,"CC","CC82008001",null,null,null,18,"2019 Budget",201900,33000]
[49,"CC","CC82008001",null,null,null,18,"2019 Budget",201900,2000]
[57,"CC","CC82008001",null,null,null,18,"2019 Budget",201900,4000]
[39498,"CC","CC82008002",null,null,null,28,"2019 Budget",201900,-1287500]
[40,"CC","CC82008002",null,null,null,28,"2019 Budget",201900,1146500]
[49,"CC","CC82008002",null,null,null,28,"2019 Budget",201900,34000]
[50,"CC","CC82008002",null,null,null,28,"2019 Budget",201900,43000]
[57,"CC","CC82008002",null,null,null,28,"2019 Budget",201900,64000]
[39498,"CC","CC83008002",null,null,null,28,"2019 Budget",201900,-3464380]
[40,"CC","CC83008002",null,null,null,28,"2019 Budget",201900,2903380]
[49,"CC","CC83008002",null,null,null,28,"2019 Budget",201900,93000]
[50,"CC","CC83008002",null,null,null,28,"2019 Budget",201900,76000]
[57,"CC","CC83008002",null,null,null,28,"2019 Budget",201900,392000]
[39498,"CC","CC84008002",null,null,null,28,"2019 Budget",201900,-2317950]
[40,"CC","CC84008002",null,null,null,28,"2019 Budget",201900,1866950]
[49,"CC","CC84008002",null,null,null,28,"2019 Budget",201900,39000]
[50,"CC","CC84008002",null,null,null,28,"2019 Budget",201900,43000]
[57,"CC","CC84008002",null,null,null,28,"2019 Budget",201900,369000]
[40,"CC","CC84008012",null,null,null,28,"2019 Budget",201900,-977000]
[57,"CC","CC84008012",null,null,null,28,"2019 Budget",201900,977000]
[39498,"D1","D181008001",null,null,null,18,"2019 Budget",201900,-306000]
[40,"D1","D181008001",null,null,null,18,"2019 Budget",201900,260000]
[49,"D1","D181008001",null,null,null,18,"2019 Budget",201900,40000]
[57,"D1","D181008001",null,null,null,18,"2019 Budget",201900,6000]
[39498,"D1","D181008002",null,null,null,28,"2019 Budget",201900,-306000]
[40,"D1","D181008002",null,null,null,28,"2019 Budget",201900,260000]
[49,"D1","D181008002",null,null,null,28,"2019 Budget",201900,40000]
[57,"D1","D181008002",null,null,null,28,"2019 Budget",201900,6000]
[39498,"D1","D182008001",null,null,null,18,"2019 Budget",201900,-443500]
[40,"D1","D182008001",null,null,null,18,"2019 Budget",201900,443500]
[39498,"D1","D182008002",null,null,null,28,"2019 Budget",201900,-628750]
[40,"D1","D182008002",null,null,null,28,"2019 Budget",201900,178750]
[57,"D1","D182008002",null,null,null,28,"2019 Budget",201900,450000]
[39498,"D1","D183008001",null,null,null,18,"2019 Budget",201900,-825500]
[40,"D1","D183008001",null,null,null,18,"2019 Budget",201900,693500]
[57,"D1","D183008001",null,null,null,18,"2019 Budget",201900,132000]
[39498,"D1","D183008002",null,null,null,28,"2019 Budget",201900,-1609750]
[40,"D1","D183008002",null,null,null,28,"2019 Budget",201900,1477750]
[57,"D1","D183008002",null,null,null,28,"2019 Budget",201900,132000]
[39498,"D1","D184008001",null,null,null,18,"2019 Budget",201900,-159500]
[40,"D1","D184008001",null,null,null,18,"2019 Budget",201900,109500]
[57,"D1","D184008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"D1","D184008002",null,null,null,28,"2019 Budget",201900,-253000]
[40,"D1","D184008002",null,null,null,28,"2019 Budget",201900,203000]
[57,"D1","D184008002",null,null,null,28,"2019 Budget",201900,50000]
[39498,"H1","H181008001",null,null,null,18,"2019 Budget",201900,-1924455]
[40,"H1","H181008001",null,null,null,18,"2019 Budget",201900,1703318]
[49,"H1","H181008001",null,null,null,18,"2019 Budget",201900,10875]
[50,"H1","H181008001",null,null,null,18,"2019 Budget",201900,180665]
[57,"H1","H181008001",null,null,null,18,"2019 Budget",201900,29597]
[39498,"H1","H181008002",null,null,null,28,"2019 Budget",201900,-3824334.5]
[40,"H1","H181008002",null,null,null,28,"2019 Budget",201900,2103197.5]
[49,"H1","H181008002",null,null,null,28,"2019 Budget",201900,1510875]
[50,"H1","H181008002",null,null,null,28,"2019 Budget",201900,180665]
[57,"H1","H181008002",null,null,null,28,"2019 Budget",201900,29597]
[39498,"H1","H182008001",null,null,null,18,"2019 Budget",201900,-906971]
[40,"H1","H182008001",null,null,null,18,"2019 Budget",201900,906971]
[39498,"H1","H182008002",null,null,null,28,"2019 Budget",201900,-585000]
[40,"H1","H182008002",null,null,null,28,"2019 Budget",201900,585000]
[39498,"H1","H183008001",null,null,null,18,"2019 Budget",201900,-4639543]
[40,"H1","H183008001",null,null,null,18,"2019 Budget",201900,3086420]
[49,"H1","H183008001",null,null,null,18,"2019 Budget",201900,36250]
[50,"H1","H183008001",null,null,null,18,"2019 Budget",201900,602215]
[57,"H1","H183008001",null,null,null,18,"2019 Budget",201900,914658]
[39498,"H1","H183008002",null,null,null,28,"2019 Budget",201900,-5382043]
[40,"H1","H183008002",null,null,null,28,"2019 Budget",201900,3828920]
[49,"H1","H183008002",null,null,null,28,"2019 Budget",201900,36250]
[50,"H1","H183008002",null,null,null,28,"2019 Budget",201900,602215]
[57,"H1","H183008002",null,null,null,28,"2019 Budget",201900,914658]
[39498,"H1","H184008001",null,null,null,18,"2019 Budget",201900,-1994348.82]
[40,"H1","H184008001",null,null,null,18,"2019 Budget",201900,1552074.82]
[49,"H1","H184008001",null,null,null,18,"2019 Budget",201900,21750]
[50,"H1","H184008001",null,null,null,18,"2019 Budget",201900,361329]
[57,"H1","H184008001",null,null,null,18,"2019 Budget",201900,59195]
[39498,"H1","H184008002",null,null,null,28,"2019 Budget",201900,-1666215.48]
[40,"H1","H184008002",null,null,null,28,"2019 Budget",201900,1223941.48]
[49,"H1","H184008002",null,null,null,28,"2019 Budget",201900,21750]
[50,"H1","H184008002",null,null,null,28,"2019 Budget",201900,361329]
[57,"H1","H184008002",null,null,null,28,"2019 Budget",201900,59195]
[39498,"H2","H281008001",null,null,null,18,"2019 Budget",201900,-405470]
[40,"H2","H281008001",null,null,null,18,"2019 Budget",201900,321270]
[49,"H2","H281008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"H2","H281008001",null,null,null,18,"2019 Budget",201900,79200]
[39498,"H2","H281008002",null,null,null,28,"2019 Budget",201900,-1981420]
[40,"H2","H281008002",null,null,null,28,"2019 Budget",201900,1707420]
[49,"H2","H281008002",null,null,null,28,"2019 Budget",201900,10000]
[50,"H2","H281008002",null,null,null,28,"2019 Budget",201900,264000]
[39498,"H2","H282008001",null,null,null,18,"2019 Budget",201900,-195791]
[40,"H2","H282008001",null,null,null,18,"2019 Budget",201900,168791]
[49,"H2","H282008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"H2","H282008001",null,null,null,18,"2019 Budget",201900,22000]
[39498,"H2","H282008002",null,null,null,28,"2019 Budget",201900,-1273002]
[40,"H2","H282008002",null,null,null,28,"2019 Budget",201900,1046802]
[49,"H2","H282008002",null,null,null,28,"2019 Budget",201900,5000]
[50,"H2","H282008002",null,null,null,28,"2019 Budget",201900,211200]
[57,"H2","H282008002",null,null,null,28,"2019 Budget",201900,10000]
[39498,"H2","H283008001",null,null,null,18,"2019 Budget",201900,-310318]
[40,"H2","H283008001",null,null,null,18,"2019 Budget",201900,251318]
[49,"H2","H283008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"H2","H283008001",null,null,null,18,"2019 Budget",201900,44000]
[57,"H2","H283008001",null,null,null,18,"2019 Budget",201900,10000]
[39498,"H2","H283008002",null,null,null,28,"2019 Budget",201900,-5001719]
[40,"H2","H283008002",null,null,null,28,"2019 Budget",201900,4526719]
[49,"H2","H283008002",null,null,null,28,"2019 Budget",201900,25000]
[50,"H2","H283008002",null,null,null,28,"2019 Budget",201900,440000]
[57,"H2","H283008002",null,null,null,28,"2019 Budget",201900,10000]
[39498,"H2","H284008001",null,null,null,18,"2019 Budget",201900,-93749]
[40,"H2","H284008001",null,null,null,18,"2019 Budget",201900,52349]
[49,"H2","H284008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"H2","H284008001",null,null,null,18,"2019 Budget",201900,26400]
[57,"H2","H284008001",null,null,null,18,"2019 Budget",201900,10000]
[39498,"H2","H284008002",null,null,null,28,"2019 Budget",201900,-3943572]
[40,"H2","H284008002",null,null,null,28,"2019 Budget",201900,2791172]
[49,"H2","H284008002",null,null,null,28,"2019 Budget",201900,550000]
[50,"H2","H284008002",null,null,null,28,"2019 Budget",201900,316800]
[57,"H2","H284008002",null,null,null,28,"2019 Budget",201900,285600]
[39498,"H5","H581008001",null,null,null,18,"2019 Budget",201900,-474406.37]
[40,"H5","H581008001",null,null,null,18,"2019 Budget",201900,393945.77]
[49,"H5","H581008001",null,null,null,18,"2019 Budget",201900,11460.6]
[50,"H5","H581008001",null,null,null,18,"2019 Budget",201900,69000]
[39498,"H5","H581008002",null,null,null,28,"2019 Budget",201900,-2685991.01]
[40,"H5","H581008002",null,null,null,28,"2019 Budget",201900,2264148.61]
[49,"H5","H581008002",null,null,null,28,"2019 Budget",201900,45842.400000000001]
[50,"H5","H581008002",null,null,null,28,"2019 Budget",201900,276000]
[57,"H5","H581008002",null,null,null,28,"2019 Budget",201900,100000]
[39498,"H5","H582008001",null,null,null,18,"2019 Budget",201900,-3271911.3]
[40,"H5","H582008001",null,null,null,18,"2019 Budget",201900,2681911.2999999998]
[49,"H5","H582008001",null,null,null,18,"2019 Budget",201900,40000]
[50,"H5","H582008001",null,null,null,18,"2019 Budget",201900,500000]
[57,"H5","H582008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"H5","H582008002",null,null,null,28,"2019 Budget",201900,-1020141.5]
[40,"H5","H582008002",null,null,null,28,"2019 Budget",201900,1020141.5]
[39498,"H5","H583008001",null,null,null,18,"2019 Budget",201900,-681871.11]
[40,"H5","H583008001",null,null,null,18,"2019 Budget",201900,499987.11]
[49,"H5","H583008001",null,null,null,18,"2019 Budget",201900,112884]
[50,"H5","H583008001",null,null,null,18,"2019 Budget",201900,69000]
[39498,"H5","H583008002",null,null,null,28,"2019 Budget",201900,-5186674.57]
[40,"H5","H583008002",null,null,null,28,"2019 Budget",201900,4459138.57]
[49,"H5","H583008002",null,null,null,28,"2019 Budget",201900,451536]
[50,"H5","H583008002",null,null,null,28,"2019 Budget",201900,276000]
[39498,"H5","H584008001",null,null,null,18,"2019 Budget",201900,-98118.399999999994]
[40,"H5","H584008001",null,null,null,18,"2019 Budget",201900,36518.400000000001]
[49,"H5","H584008001",null,null,null,18,"2019 Budget",201900,20000]
[50,"H5","H584008001",null,null,null,18,"2019 Budget",201900,41600]
[39498,"H5","H584008002",null,null,null,28,"2019 Budget",201900,-575065.59999999998]
[40,"H5","H584008002",null,null,null,28,"2019 Budget",201900,328665.59999999998]
[49,"H5","H584008002",null,null,null,28,"2019 Budget",201900,80000]
[50,"H5","H584008002",null,null,null,28,"2019 Budget",201900,166400]
[39498,"H7","H781008001",null,null,null,18,"2019 Budget",201900,-108075]
[40,"H7","H781008001",null,null,null,18,"2019 Budget",201900,108075]
[39498,"H7","H781008002",null,null,null,28,"2019 Budget",201900,-2233025]
[40,"H7","H781008002",null,null,null,28,"2019 Budget",201900,2173025]
[57,"H7","H781008002",null,null,null,28,"2019 Budget",201900,60000]
[39498,"H7","H782008001",null,null,null,18,"2019 Budget",201900,-203175]
[40,"H7","H782008001",null,null,null,18,"2019 Budget",201900,16175]
[57,"H7","H782008001",null,null,null,18,"2019 Budget",201900,187000]
[39498,"H7","H782008002",null,null,null,28,"2019 Budget",201900,-1320525]
[40,"H7","H782008002",null,null,null,28,"2019 Budget",201900,693525]
[49,"H7","H782008002",null,null,null,28,"2019 Budget",201900,200000]
[57,"H7","H782008002",null,null,null,28,"2019 Budget",201900,427000]
[39498,"H7","H783008001",null,null,null,18,"2019 Budget",201900,-231625]
[40,"H7","H783008001",null,null,null,18,"2019 Budget",201900,208625]
[57,"H7","H783008001",null,null,null,18,"2019 Budget",201900,23000]
[39498,"H7","H783008002",null,null,null,28,"2019 Budget",201900,-7784875]
[40,"H7","H783008002",null,null,null,28,"2019 Budget",201900,3963875]
[49,"H7","H783008002",null,null,null,28,"2019 Budget",201900,20000]
[50,"H7","H783008002",null,null,null,28,"2019 Budget",201900,3500000]
[57,"H7","H783008002",null,null,null,28,"2019 Budget",201900,301000]
[39498,"H7","H784008001",null,null,null,18,"2019 Budget",201900,-101875]
[40,"H7","H784008001",null,null,null,18,"2019 Budget",201900,51875]
[57,"H7","H784008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"H7","H784008002",null,null,null,28,"2019 Budget",201900,-2476225]
[40,"H7","H784008002",null,null,null,28,"2019 Budget",201900,1456225]
[49,"H7","H784008002",null,null,null,28,"2019 Budget",201900,20000]
[57,"H7","H784008002",null,null,null,28,"2019 Budget",201900,1000000]
[39498,"H9","H981008001",null,null,null,18,"2019 Budget",201900,-1099800]
[40,"H9","H981008001",null,null,null,18,"2019 Budget",201900,726800]
[49,"H9","H981008001",null,null,null,18,"2019 Budget",201900,185000]
[57,"H9","H981008001",null,null,null,18,"2019 Budget",201900,188000]
[39498,"H9","H981008002",null,null,null,28,"2019 Budget",201900,-2483700]
[40,"H9","H981008002",null,null,null,28,"2019 Budget",201900,1446700]
[49,"H9","H981008002",null,null,null,28,"2019 Budget",201900,599000]
[57,"H9","H981008002",null,null,null,28,"2019 Budget",201900,438000]
[39498,"H9","H982008001",null,null,null,18,"2019 Budget",201900,-783200]
[40,"H9","H982008001",null,null,null,18,"2019 Budget",201900,783200]
[39498,"H9","H982008002",null,null,null,28,"2019 Budget",201900,-907510]
[40,"H9","H982008002",null,null,null,28,"2019 Budget",201900,897510]
[57,"H9","H982008002",null,null,null,28,"2019 Budget",201900,10000]
[39498,"H9","H983008001",null,null,null,18,"2019 Budget",201900,-1376450]
[40,"H9","H983008001",null,null,null,18,"2019 Budget",201900,934450]
[49,"H9","H983008001",null,null,null,18,"2019 Budget",201900,1000]
[50,"H9","H983008001",null,null,null,18,"2019 Budget",201900,136000]
[57,"H9","H983008001",null,null,null,18,"2019 Budget",201900,298000]
[69,"H9","H983008001",null,null,null,18,"2019 Budget",201900,7000]
[39498,"H9","H983008002",null,null,null,28,"2019 Budget",201900,-4625050]
[40,"H9","H983008002",null,null,null,28,"2019 Budget",201900,3218050]
[49,"H9","H983008002",null,null,null,28,"2019 Budget",201900,1000]
[50,"H9","H983008002",null,null,null,28,"2019 Budget",201900,544000]
[57,"H9","H983008002",null,null,null,28,"2019 Budget",201900,862000]
[39498,"H9","H984008001",null,null,null,18,"2019 Budget",201900,-692100]
[40,"H9","H984008001",null,null,null,18,"2019 Budget",201900,396100]
[50,"H9","H984008001",null,null,null,18,"2019 Budget",201900,296000]
[39498,"H9","H984008002",null,null,null,28,"2019 Budget",201900,-1364900]
[40,"H9","H984008002",null,null,null,28,"2019 Budget",201900,673900]
[50,"H9","H984008002",null,null,null,28,"2019 Budget",201900,691000]
[39498,"K1","K181008001",null,null,null,18,"2019 Budget",201900,-106196.21]
[40,"K1","K181008001",null,null,null,18,"2019 Budget",201900,91196.21]
[49,"K1","K181008001",null,null,null,18,"2019 Budget",201900,12000]
[50,"K1","K181008001",null,null,null,18,"2019 Budget",201900,2000]
[57,"K1","K181008001",null,null,null,18,"2019 Budget",201900,1000]
[39498,"K1","K181008002",null,null,null,28,"2019 Budget",201900,-2378718.21]
[40,"K1","K181008002",null,null,null,28,"2019 Budget",201900,2097718.21]
[49,"K1","K181008002",null,null,null,28,"2019 Budget",201900,156000]
[50,"K1","K181008002",null,null,null,28,"2019 Budget",201900,20000]
[57,"K1","K181008002",null,null,null,28,"2019 Budget",201900,105000]
[39498,"K1","K182008001",null,null,null,18,"2019 Budget",201900,-338030.26]
[40,"K1","K182008001",null,null,null,18,"2019 Budget",201900,44030.26]
[49,"K1","K182008001",null,null,null,18,"2019 Budget",201900,4000]
[57,"K1","K182008001",null,null,null,18,"2019 Budget",201900,290000]
[39498,"K1","K182008002",null,null,null,28,"2019 Budget",201900,-724096.9]
[40,"K1","K182008002",null,null,null,28,"2019 Budget",201900,697596.9]
[49,"K1","K182008002",null,null,null,28,"2019 Budget",201900,4500]
[57,"K1","K182008002",null,null,null,28,"2019 Budget",201900,22000]
[39498,"K1","K183008001",null,null,null,18,"2019 Budget",201900,-121794.52]
[40,"K1","K183008001",null,null,null,18,"2019 Budget",201900,108794.52]
[49,"K1","K183008001",null,null,null,18,"2019 Budget",201900,1000]
[57,"K1","K183008001",null,null,null,18,"2019 Budget",201900,12000]
[39498,"K1","K183008002",null,null,null,28,"2019 Budget",201900,-4315576.1500000004]
[40,"K1","K183008002",null,null,null,28,"2019 Budget",201900,3622576.15]
[49,"K1","K183008002",null,null,null,28,"2019 Budget",201900,53000]
[57,"K1","K183008002",null,null,null,28,"2019 Budget",201900,640000]
[39498,"K1","K184008001",null,null,null,18,"2019 Budget",201900,-112449.09]
[40,"K1","K184008001",null,null,null,18,"2019 Budget",201900,106449.09]
[49,"K1","K184008001",null,null,null,18,"2019 Budget",201900,1000]
[57,"K1","K184008001",null,null,null,18,"2019 Budget",201900,5000]
[39498,"K1","K184008002",null,null,null,28,"2019 Budget",201900,-3450768.14]
[40,"K1","K184008002",null,null,null,28,"2019 Budget",201900,2760968.14]
[49,"K1","K184008002",null,null,null,28,"2019 Budget",201900,85000]
[57,"K1","K184008002",null,null,null,28,"2019 Budget",201900,440000]
[69,"K1","K184008002",null,null,null,28,"2019 Budget",201900,164800]
[39498,"K2","K281008001",null,null,null,18,"2019 Budget",201900,-130185]
[40,"K2","K281008001",null,null,null,18,"2019 Budget",201900,119185]
[49,"K2","K281008001",null,null,null,18,"2019 Budget",201900,10000]
[50,"K2","K281008001",null,null,null,18,"2019 Budget",201900,1000]
[39498,"K2","K281008002",null,null,null,28,"2019 Budget",201900,-3750340]
[40,"K2","K281008002",null,null,null,28,"2019 Budget",201900,3075340]
[49,"K2","K281008002",null,null,null,28,"2019 Budget",201900,500000]
[50,"K2","K281008002",null,null,null,28,"2019 Budget",201900,50000]
[57,"K2","K281008002",null,null,null,28,"2019 Budget",201900,125000]
[39498,"K2","K282008001",null,null,null,18,"2019 Budget",201900,-1215219]
[40,"K2","K282008001",null,null,null,18,"2019 Budget",201900,1155219]
[49,"K2","K282008001",null,null,null,18,"2019 Budget",201900,10000]
[57,"K2","K282008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"K2","K282008002",null,null,null,28,"2019 Budget",201900,-6703797]
[40,"K2","K282008002",null,null,null,28,"2019 Budget",201900,6323797]
[49,"K2","K282008002",null,null,null,28,"2019 Budget",201900,300000]
[57,"K2","K282008002",null,null,null,28,"2019 Budget",201900,80000]
[39498,"K2","K283008001",null,null,null,18,"2019 Budget",201900,-144705]
[40,"K2","K283008001",null,null,null,18,"2019 Budget",201900,94705]
[49,"K2","K283008001",null,null,null,18,"2019 Budget",201900,20000]
[57,"K2","K283008001",null,null,null,18,"2019 Budget",201900,30000]
[39498,"K2","K283008002",null,null,null,28,"2019 Budget",201900,-11239292]
[40,"K2","K283008002",null,null,null,28,"2019 Budget",201900,8037907]
[49,"K2","K283008002",null,null,null,28,"2019 Budget",201900,2588885]
[57,"K2","K283008002",null,null,null,28,"2019 Budget",201900,600000]
[69,"K2","K283008002",null,null,null,28,"2019 Budget",201900,12500]
[39498,"K2","K284008001",null,null,null,18,"2019 Budget",201900,-66672]
[40,"K2","K284008001",null,null,null,18,"2019 Budget",201900,48672]
[57,"K2","K284008001",null,null,null,18,"2019 Budget",201900,18000]
[39498,"K2","K284008002",null,null,null,28,"2019 Budget",201900,-2958508]
[40,"K2","K284008002",null,null,null,28,"2019 Budget",201900,1028508]
[49,"K2","K284008002",null,null,null,28,"2019 Budget",201900,1100000]
[50,"K2","K284008002",null,null,null,28,"2019 Budget",201900,750000]
[57,"K2","K284008002",null,null,null,28,"2019 Budget",201900,80000]
[39498,"K6","K681008001",null,null,null,18,"2019 Budget",201900,-712000]
[40,"K6","K681008001",null,null,null,18,"2019 Budget",201900,482000]
[49,"K6","K681008001",null,null,null,18,"2019 Budget",201900,5000]
[50,"K6","K681008001",null,null,null,18,"2019 Budget",201900,210000]
[57,"K6","K681008001",null,null,null,18,"2019 Budget",201900,15000]
[39498,"K6","K681008002",null,null,null,28,"2019 Budget",201900,-3029400]
[40,"K6","K681008002",null,null,null,28,"2019 Budget",201900,1684400]
[49,"K6","K681008002",null,null,null,28,"2019 Budget",201900,10000]
[50,"K6","K681008002",null,null,null,28,"2019 Budget",201900,1300000]
[57,"K6","K681008002",null,null,null,28,"2019 Budget",201900,35000]
[39498,"K6","K682008001",null,null,null,18,"2019 Budget",201900,-773500]
[40,"K6","K682008001",null,null,null,18,"2019 Budget",201900,758500]
[57,"K6","K682008001",null,null,null,18,"2019 Budget",201900,15000]
[39498,"K6","K682008002",null,null,null,28,"2019 Budget",201900,-781500]
[40,"K6","K682008002",null,null,null,28,"2019 Budget",201900,751500]
[49,"K6","K682008002",null,null,null,28,"2019 Budget",201900,5000]
[57,"K6","K682008002",null,null,null,28,"2019 Budget",201900,25000]
[39498,"K6","K683008001",null,null,null,18,"2019 Budget",201900,-774000]
[40,"K6","K683008001",null,null,null,18,"2019 Budget",201900,729000]
[57,"K6","K683008001",null,null,null,18,"2019 Budget",201900,45000]
[39498,"K6","K683008002",null,null,null,28,"2019 Budget",201900,-4492250]
[40,"K6","K683008002",null,null,null,28,"2019 Budget",201900,3512250]
[49,"K6","K683008002",null,null,null,28,"2019 Budget",201900,25000]
[50,"K6","K683008002",null,null,null,28,"2019 Budget",201900,20000]
[57,"K6","K683008002",null,null,null,28,"2019 Budget",201900,935000]
[39498,"K6","K684008001",null,null,null,18,"2019 Budget",201900,-448200]
[40,"K6","K684008001",null,null,null,18,"2019 Budget",201900,433200]
[57,"K6","K684008001",null,null,null,18,"2019 Budget",201900,15000]
[39498,"K6","K684008002",null,null,null,28,"2019 Budget",201900,-1766200]
[40,"K6","K684008002",null,null,null,28,"2019 Budget",201900,1611200]
[49,"K6","K684008002",null,null,null,28,"2019 Budget",201900,5000]
[57,"K6","K684008002",null,null,null,28,"2019 Budget",201900,150000]
[39498,"K7","K781008001",null,null,null,18,"2019 Budget",201900,-207847]
[40,"K7","K781008001",null,null,null,18,"2019 Budget",201900,182847]
[49,"K7","K781008001",null,null,null,18,"2019 Budget",201900,5000]
[57,"K7","K781008001",null,null,null,18,"2019 Budget",201900,20000]
[39498,"K7","K781008002",null,null,null,28,"2019 Budget",201900,-3801412]
[40,"K7","K781008002",null,null,null,28,"2019 Budget",201900,2005412]
[49,"K7","K781008002",null,null,null,28,"2019 Budget",201900,996000]
[50,"K7","K781008002",null,null,null,28,"2019 Budget",201900,100000]
[57,"K7","K781008002",null,null,null,28,"2019 Budget",201900,700000]
[39498,"K7","K782008002",null,null,null,28,"2019 Budget",201900,-812400]
[40,"K7","K782008002",null,null,null,28,"2019 Budget",201900,502400]
[49,"K7","K782008002",null,null,null,28,"2019 Budget",201900,190000]
[50,"K7","K782008002",null,null,null,28,"2019 Budget",201900,100000]
[57,"K7","K782008002",null,null,null,28,"2019 Budget",201900,20000]
[39498,"K7","K783008001",null,null,null,18,"2019 Budget",201900,-193890]
[40,"K7","K783008001",null,null,null,18,"2019 Budget",201900,183890]
[57,"K7","K783008001",null,null,null,18,"2019 Budget",201900,10000]
[39498,"K7","K783008002",null,null,null,28,"2019 Budget",201900,-8635455]
[40,"K7","K783008002",null,null,null,28,"2019 Budget",201900,7305455]
[49,"K7","K783008002",null,null,null,28,"2019 Budget",201900,30000]
[57,"K7","K783008002",null,null,null,28,"2019 Budget",201900,1300000]
[39498,"K7","K784008001",null,null,null,18,"2019 Budget",201900,-22520]
[40,"K7","K784008001",null,null,null,18,"2019 Budget",201900,12520]
[57,"K7","K784008001",null,null,null,18,"2019 Budget",201900,10000]
[39498,"K7","K784008002",null,null,null,28,"2019 Budget",201900,-1075720]
[40,"K7","K784008002",null,null,null,28,"2019 Budget",201900,679720]
[57,"K7","K784008002",null,null,null,28,"2019 Budget",201900,396000]
[39498,"K8","K881008001",null,null,null,18,"2019 Budget",201900,-460400]
[40,"K8","K881008001",null,null,null,18,"2019 Budget",201900,366400]
[50,"K8","K881008001",null,null,null,18,"2019 Budget",201900,14000]
[57,"K8","K881008001",null,null,null,18,"2019 Budget",201900,80000]
[39498,"K8","K881008002",null,null,null,28,"2019 Budget",201900,-4046100]
[40,"K8","K881008002",null,null,null,28,"2019 Budget",201900,2690100]
[50,"K8","K881008002",null,null,null,28,"2019 Budget",201900,56000]
[57,"K8","K881008002",null,null,null,28,"2019 Budget",201900,1300000]
[39498,"K8","K882008001",null,null,null,18,"2019 Budget",201900,-633300]
[40,"K8","K882008001",null,null,null,18,"2019 Budget",201900,633300]
[39498,"K8","K882008002",null,null,null,28,"2019 Budget",201900,-903700]
[40,"K8","K882008002",null,null,null,28,"2019 Budget",201900,903700]
[39498,"K8","K883008001",null,null,null,18,"2019 Budget",201900,-1505585]
[40,"K8","K883008001",null,null,null,18,"2019 Budget",201900,1055585]
[49,"K8","K883008001",null,null,null,18,"2019 Budget",201900,50000]
[50,"K8","K883008001",null,null,null,18,"2019 Budget",201900,350000]
[57,"K8","K883008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"K8","K883008002",null,null,null,28,"2019 Budget",201900,-8964050]
[40,"K8","K883008002",null,null,null,28,"2019 Budget",201900,6140050]
[49,"K8","K883008002",null,null,null,28,"2019 Budget",201900,774000]
[50,"K8","K883008002",null,null,null,28,"2019 Budget",201900,1650000]
[57,"K8","K883008002",null,null,null,28,"2019 Budget",201900,400000]
[39498,"K8","K884008001",null,null,null,18,"2019 Budget",201900,-417900]
[40,"K8","K884008001",null,null,null,18,"2019 Budget",201900,287900]
[50,"K8","K884008001",null,null,null,18,"2019 Budget",201900,130000]
[39498,"K8","K884008002",null,null,null,28,"2019 Budget",201900,-2052300]
[40,"K8","K884008002",null,null,null,28,"2019 Budget",201900,1700300]
[50,"K8","K884008002",null,null,null,28,"2019 Budget",201900,352000]
[39498,"K9","K981008001",null,null,null,18,"2019 Budget",201900,-298200]
[40,"K9","K981008001",null,null,null,18,"2019 Budget",201900,248200]
[57,"K9","K981008001",null,null,null,18,"2019 Budget",201900,50000]
[39498,"K9","K981008002",null,null,null,28,"2019 Budget",201900,-2683800]
[40,"K9","K981008002",null,null,null,28,"2019 Budget",201900,2233800]
[57,"K9","K981008002",null,null,null,28,"2019 Budget",201900,450000]
[39498,"K9","K982008001",null,null,null,18,"2019 Budget",201900,-85360]
[40,"K9","K982008001",null,null,null,18,"2019 Budget",201900,117360]
[49,"K9","K982008001",null,null,null,18,"2019 Budget",201900,-105000]
[50,"K9","K982008001",null,null,null,18,"2019 Budget",201900,73000]
[39498,"K9","K982008002",null,null,null,28,"2019 Budget",201900,-786240]
[40,"K9","K982008002",null,null,null,28,"2019 Budget",201900,1056240]
[49,"K9","K982008002",null,null,null,28,"2019 Budget",201900,-930000]
[50,"K9","K982008002",null,null,null,28,"2019 Budget",201900,660000]
[39498,"K9","K983008001",null,null,null,18,"2019 Budget",201900,-442760]
[40,"K9","K983008001",null,null,null,18,"2019 Budget",201900,885760]
[49,"K9","K983008001",null,null,null,18,"2019 Budget",201900,-525000]
[50,"K9","K983008001",null,null,null,18,"2019 Budget",201900,73000]
[57,"K9","K983008001",null,null,null,18,"2019 Budget",201900,9000]
[39498,"K9","K983008002",null,null,null,28,"2019 Budget",201900,-4007840]
[40,"K9","K983008002",null,null,null,28,"2019 Budget",201900,7971840]
[49,"K9","K983008002",null,null,null,28,"2019 Budget",201900,-4705000]
[50,"K9","K983008002",null,null,null,28,"2019 Budget",201900,660000]
[57,"K9","K983008002",null,null,null,28,"2019 Budget",201900,81000]
[39498,"K9","K984008001",null,null,null,18,"2019 Budget",201900,-247200]
[40,"K9","K984008001",null,null,null,18,"2019 Budget",201900,249200]
[49,"K9","K984008001",null,null,null,18,"2019 Budget",201900,-295000]
[50,"K9","K984008001",null,null,null,18,"2019 Budget",201900,73000]
[57,"K9","K984008001",null,null,null,18,"2019 Budget",201900,220000]
[39498,"K9","K984008002",null,null,null,28,"2019 Budget",201900,-2232800]
[40,"K9","K984008002",null,null,null,28,"2019 Budget",201900,2242800]
[49,"K9","K984008002",null,null,null,28,"2019 Budget",201900,-2640000]
[50,"K9","K984008002",null,null,null,28,"2019 Budget",201900,660000]
[57,"K9","K984008002",null,null,null,28,"2019 Budget",201900,1970000]
[39498,"OF","OF81008001",null,null,null,18,"2019 Budget",201900,-1302182.04]
[40,"OF","OF81008001",null,null,null,18,"2019 Budget",201900,903017.54]
[49,"OF","OF81008001",null,null,null,18,"2019 Budget",201900,124720.2]
[50,"OF","OF81008001",null,null,null,18,"2019 Budget",201900,145834.29999999999]
[57,"OF","OF81008001",null,null,null,18,"2019 Budget",201900,128610]
[39498,"OF","OF81008002",null,null,null,28,"2019 Budget",201900,-1149162.3799999999]
[40,"OF","OF81008002",null,null,null,28,"2019 Budget",201900,905228.52]
[49,"OF","OF81008002",null,null,null,28,"2019 Budget",201900,76217.899999999994]
[50,"OF","OF81008002",null,null,null,28,"2019 Budget",201900,89120.960000000006]
[57,"OF","OF81008002",null,null,null,28,"2019 Budget",201900,78595]
[39498,"OF","OF82008001",null,null,null,18,"2019 Budget",201900,-659795.31999999995]
[40,"OF","OF82008001",null,null,null,18,"2019 Budget",201900,617369.31999999995]
[49,"OF","OF82008001",null,null,null,18,"2019 Budget",201900,-45129]
[50,"OF","OF82008001",null,null,null,18,"2019 Budget",201900,64655]
[57,"OF","OF82008001",null,null,null,18,"2019 Budget",201900,22900]
[39498,"OF","OF82008002",null,null,null,28,"2019 Budget",201900,-1298341.28]
[40,"OF","OF82008002",null,null,null,28,"2019 Budget",201900,1209447.28]
[49,"OF","OF82008002",null,null,null,28,"2019 Budget",201900,14256.84]
[50,"OF","OF82008002",null,null,null,28,"2019 Budget",201900,63637.16]
[57,"OF","OF82008002",null,null,null,28,"2019 Budget",201900,11000]
[39498,"OF","OF83008001",null,null,null,18,"2019 Budget",201900,-502745.02]
[40,"OF","OF83008001",null,null,null,18,"2019 Budget",201900,305742.27]
[49,"OF","OF83008001",null,null,null,18,"2019 Budget",201900,41078.699999999997]
[50,"OF","OF83008001",null,null,null,18,"2019 Budget",201900,50257.08]
[57,"OF","OF83008001",null,null,null,18,"2019 Budget",201900,105666.97]
[39498,"OF","OF83008002",null,null,null,28,"2019 Budget",201900,-361746.2]
[40,"OF","OF83008002",null,null,null,28,"2019 Budget",201900,244536.69]
[49,"OF","OF83008002",null,null,null,28,"2019 Budget",201900,25103.65]
[50,"OF","OF83008002",null,null,null,28,"2019 Budget",201900,30712.66]
[57,"OF","OF83008002",null,null,null,28,"2019 Budget",201900,61393.2]
[39498,"OF","OF83008011",null,null,null,18,"2019 Budget",201900,-727665.6]
[40,"OF","OF83008011",null,null,null,18,"2019 Budget",201900,496325.89]
[49,"OF","OF83008011",null,null,null,18,"2019 Budget",201900,61565.760000000002]
[50,"OF","OF83008011",null,null,null,18,"2019 Budget",201900,85750.38]
[57,"OF","OF83008011",null,null,null,18,"2019 Budget",201900,84023.58]
[39498,"OF","OF83008012",null,null,null,28,"2019 Budget",201900,-534902.61]
[40,"OF","OF83008012",null,null,null,28,"2019 Budget",201900,396967.98]
[49,"OF","OF83008012",null,null,null,28,"2019 Budget",201900,37623.519999999997]
[50,"OF","OF83008012",null,null,null,28,"2019 Budget",201900,52403.01]
[57,"OF","OF83008012",null,null,null,28,"2019 Budget",201900,47908.1]
[39498,"OF","OF84008001",null,null,null,18,"2019 Budget",201900,-1308518.8799999999]
[40,"OF","OF84008001",null,null,null,18,"2019 Budget",201900,400931.94]
[49,"OF","OF84008001",null,null,null,18,"2019 Budget",201900,20826]
[50,"OF","OF84008001",null,null,null,18,"2019 Budget",201900,291464.03999999998]
[57,"OF","OF84008001",null,null,null,18,"2019 Budget",201900,595296.9]
[39498,"OF","OF84008002",null,null,null,28,"2019 Budget",201900,-903951.1]
[40,"OF","OF84008002",null,null,null,28,"2019 Budget",201900,349314.64]
[49,"OF","OF84008002",null,null,null,28,"2019 Budget",201900,12727]
[50,"OF","OF84008002",null,null,null,28,"2019 Budget",201900,178116.91]
[57,"OF","OF84008002",null,null,null,28,"2019 Budget",201900,363792.55]
[39498,"OF","OF84008011",null,null,null,18,"2019 Budget",201900,-1079311.02]
[40,"OF","OF84008011",null,null,null,18,"2019 Budget",201900,515110.46]
[49,"OF","OF84008011",null,null,null,18,"2019 Budget",201900,16380]
[50,"OF","OF84008011",null,null,null,18,"2019 Budget",201900,86707.55]
[57,"OF","OF84008011",null,null,null,18,"2019 Budget",201900,461113]
[39498,"OF","OF84008012",null,null,null,28,"2019 Budget",201900,-753686.08]
[40,"OF","OF84008012",null,null,null,28,"2019 Budget",201900,411992.13]
[49,"OF","OF84008012",null,null,null,28,"2019 Budget",201900,10010]
[50,"OF","OF84008012",null,null,null,28,"2019 Budget",201900,52987.95]
[57,"OF","OF84008012",null,null,null,28,"2019 Budget",201900,278696]
[39498,"OV","OV81008001",null,null,null,18,"2019 Budget",201900,-3393170.71]
[40,"OV","OV81008001",null,null,null,18,"2019 Budget",201900,2173501.4]
[49,"OV","OV81008001",null,null,null,18,"2019 Budget",201900,381089.5]
[50,"OV","OV81008001",null,null,null,18,"2019 Budget",201900,445604.82]
[57,"OV","OV81008001",null,null,null,18,"2019 Budget",201900,392975]
[39498,"OV","OV81008002",null,null,null,28,"2019 Budget",201900,-987104.21]
[40,"OV","OV81008002",null,null,null,28,"2019 Budget",201900,632291.31999999995]
[49,"OV","OV81008002",null,null,null,28,"2019 Budget",201900,110862.39999999999]
[50,"OV","OV81008002",null,null,null,28,"2019 Budget",201900,129630.49]
[57,"OV","OV81008002",null,null,null,28,"2019 Budget",201900,114320]
[39498,"OV","OV83008001",null,null,null,18,"2019 Budget",201900,-1808731.01]
[40,"OV","OV83008001",null,null,null,18,"2019 Budget",201900,1222683.46]
[49,"OV","OV83008001",null,null,null,18,"2019 Budget",201900,125518.25]
[50,"OV","OV83008001",null,null,null,18,"2019 Budget",201900,153563.29999999999]
[57,"OV","OV83008001",null,null,null,18,"2019 Budget",201900,306966]
[39498,"OV","OV83008002",null,null,null,28,"2019 Budget",201900,-526176.29]
[40,"OV","OV83008002",null,null,null,28,"2019 Budget",201900,355689.73]
[49,"OV","OV83008002",null,null,null,28,"2019 Budget",201900,36514.400000000001]
[50,"OV","OV83008002",null,null,null,28,"2019 Budget",201900,44672.959999999999]
[57,"OV","OV83008002",null,null,null,28,"2019 Budget",201900,89299.199999999997]
[39498,"OV","OV83008011",null,null,null,18,"2019 Budget",201900,-2674513.06]
[40,"OV","OV83008011",null,null,null,18,"2019 Budget",201900,1984839.9]
[49,"OV","OV83008011",null,null,null,18,"2019 Budget",201900,188117.6]
[50,"OV","OV83008011",null,null,null,18,"2019 Budget",201900,262015.05]
[57,"OV","OV83008011",null,null,null,18,"2019 Budget",201900,239540.51]
[39498,"OV","OV83008012",null,null,null,28,"2019 Budget",201900,-778040.16]
[40,"OV","OV83008012",null,null,null,28,"2019 Budget",201900,577407.97]
[49,"OV","OV83008012",null,null,null,28,"2019 Budget",201900,54725.120000000003]
[50,"OV","OV83008012",null,null,null,28,"2019 Budget",201900,76222.559999999998]
[57,"OV","OV83008012",null,null,null,28,"2019 Budget",201900,69684.509999999995]
[39498,"OV","OV84008001",null,null,null,18,"2019 Budget",201900,-4546643.92]
[40,"OV","OV84008001",null,null,null,18,"2019 Budget",201900,1773461.61]
[49,"OV","OV84008001",null,null,null,18,"2019 Budget",201900,63635]
[50,"OV","OV84008001",null,null,null,18,"2019 Budget",201900,890584.56]
[57,"OV","OV84008001",null,null,null,18,"2019 Budget",201900,1818962.75]
[39498,"OV","OV84008002",null,null,null,28,"2019 Budget",201900,-1299785.17]
[40,"OV","OV84008002",null,null,null,28,"2019 Budget",201900,493041.23]
[49,"OV","OV84008002",null,null,null,28,"2019 Budget",201900,18512]
[50,"OV","OV84008002",null,null,null,28,"2019 Budget",201900,259079.14]
[57,"OV","OV84008002",null,null,null,28,"2019 Budget",201900,529152.80000000005]
[39498,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,-3778695.73]
[40,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,2059960.65]
[49,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,50050]
[50,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,264939.74]
[57,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,1393480]
[69,"OV","OV84008011",null,null,null,18,"2019 Budget",201900,10265.33]
[39498,"OV","OV84008012",null,null,null,28,"2019 Budget",201900,-1096270.6599999999]
[40,"OV","OV84008012",null,null,null,28,"2019 Budget",201900,599261.28]
[49,"OV","OV84008012",null,null,null,28,"2019 Budget",201900,14560]
[50,"OV","OV84008012",null,null,null,28,"2019 Budget",201900,77073.38]
[57,"OV","OV84008012",null,null,null,28,"2019 Budget",201900,405376]
[39498,"S1","S181008001",null,null,null,18,"2019 Budget",201900,-1040479.3]
[40,"S1","S181008001",null,null,null,18,"2019 Budget",201900,1040479.3]
[39498,"S1","S181008002",null,null,null,28,"2019 Budget",201900,-781046.78]
[40,"S1","S181008002",null,null,null,28,"2019 Budget",201900,781046.78]
[39498,"S1","S182008001",null,null,null,18,"2019 Budget",201900,-121461.3]
[40,"S1","S182008001",null,null,null,18,"2019 Budget",201900,121461.3]
[39498,"S1","S182008002",null,null,null,28,"2019 Budget",201900,-157760.07999999999]
[40,"S1","S182008002",null,null,null,28,"2019 Budget",201900,157760.07999999999]
[39498,"S1","S183008001",null,null,null,18,"2019 Budget",201900,-743811.16]
[40,"S1","S183008001",null,null,null,18,"2019 Budget",201900,743811.16]
[39498,"S1","S183008002",null,null,null,28,"2019 Budget",201900,-966099.56]
[40,"S1","S183008002",null,null,null,28,"2019 Budget",201900,966099.56]
[39498,"S1","S184008001",null,null,null,18,"2019 Budget",201900,-350000]
[40,"S1","S184008001",null,null,null,18,"2019 Budget",201900,130375.89]
[57,"S1","S184008001",null,null,null,18,"2019 Budget",201900,219624.11]
[39498,"S1","S184008002",null,null,null,28,"2019 Budget",201900,-458000]
[40,"S1","S184008002",null,null,null,28,"2019 Budget",201900,169338.8]
[57,"S1","S184008002",null,null,null,28,"2019 Budget",201900,288661.2]