{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Projekt","Formas","Inställningar","Grafik"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"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":"Projekt","index":0,"n_rows":64,"n_cols":22,"rows_kept":64,"cut":false,"hidden":false,"merged":[[42,7,42,17],[43,7,43,17],[63,3,66,17],[57,3,57,6],[58,3,58,6],[55,3,55,6],[56,3,56,6],[31,7,31,17],[32,7,32,17],[8,19,22,33],[2,9,2,10],[18,7,18,17],[19,7,19,17],[20,7,20,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Startår",2020]
[null,null,null,null,null,null,null,null," Diarienummer","ÅÅÅÅ-XXXXXX",null,null,null,null,null,null,null,null,null,null,"Slutår",2023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antal medverkande parter",1]
[]
[]
[null,null,null,"Återrapportering för projekt diarienummer:",null,null,null,null,{"$f":"J3","v":"ÅÅÅÅ-XXXXXX"}]
[]
[null,null,null,"PROJEKTET TOTALT - Här räknas projektets totala kostnader ut automatiskt ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anvisningar för ifyllnad\nI excelmallen anges projektkostnader per part, år och kostnadsslag inklusive egenfinansiering. \nDet innebär att det är de totala kostnaderna som ska framgå i bilagan. \nProjektets medfinansiering specificeras sist i mallen. \n\nDen ekonomiska rapportering för projekt av den här typen sker genom att information om \nutbetalda, förbrukade och oförbrukade medel lämnas i Prisma samt att excelmallen med \ndetaljerade uppgifter ifylls och bifogas som pdf under fliken \"Kommentar och Bilaga\". \n\nMedelsföravaltare - koordinerande part är obligatorisk!\n\nAnvisningar för mallfunktioner\nIfyllt antal medverkande parten genererar automatiskt kontroller. För att ta bort en part\nanvänd knappen \"Ta bort projektpart\". \nIfyllt startår och slutår genererar automatiskt rapporteringskolumner i kostnadsredovisningen.\n\n\"Spara som PDF\" fungerar inte på MAC-datorer! Använd vanlig skriva ut och skriv ut som pdf."]
[null,null,null,"År",null,null,null,{"$f":"IF(rngStartår<>\"\",rngStartår,\"\")","v":2020},{"$f":"IF(H10<>\"\",IF(H10+1<=rngSlutår,H10+1,\"\"),\"\")","v":2021},2022,2023,"","","","","","","Totalt"]
[null,null,null,"Personalkostnader",null,null,null,{"$f":"SUMIF($D23:$D51,$D11,H23:H51)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H11:Q11)","v":0}]
[null,null,null,"Utrustning, mark, byggnader",null,null,null,{"$f":"SUMIF($D24:$D538,$D12,H24:H51)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Kostnader för konsulter, licenser, m.m.",null,null,null,{"$f":"SUMIF($D25:$D51,$D13,H25:H51)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Övriga direkta kostnader, inklusive resor",null,null,null,{"$f":"SUMIF($D26:$D51,$D14,H26:H51)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Indirekta kostnader",null,null,null,{"$f":"SUMIF($D27:$D51,$D15,H27:H51)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Totala kostnader",null,null,null,{"$f":"SUM(H11:H15)","v":0},{"$f":"SUM(I11:I15)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"MEDELSFÖRVALTARE - KOORDINERANDE PART"]
[null,null,null,"Organisationens namn"]
[null,null,null,"Organisationsnummer"]
[null,null,null,"Kontaktpersonens e-post"]
[null,null,null,"År",null,null,null,{"$f":"IF(rngStartår<>\"\",rngStartår,\"\")","v":2020},{"$f":"IF(H22<>\"\",IF(H22+1<=rngSlutår,H22+1,\"\"),\"\")","v":2021},2022,2023,"","","","","","","Totalt"]
[null,null,null,"Personalkostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H23:Q23)","v":0}]
[null,null,null,"Utrustning, mark, byggnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kostnader för konsulter, licenser, m.m.",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Övriga direkta kostnader, inklusive resor",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Indirekta kostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Totala kostnader",null,null,null,{"$f":"SUM(H23:H27)","v":0},{"$f":"SUM(I23:I27)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"*Här kan ni fylla i text som förklarar den mandatoriska parten"]
[]
[{"$f":"((ROW(C31)-rngProjectPartsStartRow)/rngTemplateProjectRowCount) + 1","v":1},null,null,{"$f":"IF(H32<>\"\",\"PROJEKTPART \" & A31 & \" - \" & H32,\"PROJEKTPART \" & A31)","v":"PROJEKTPART 1"}]
[null,null,null,"Organisationens namn"]
[null,null,null,"Organisationsnummer"]
[null,null,null,"År",null,null,null,{"$f":"IF(rngStartår<>\"\",rngStartår,\"\")","v":2020},{"$f":"IF(H34<>\"\",IF(H34+1<=rngSlutår,H34+1,\"\"),\"\")","v":2021},{"$f":"IF(I34<>\"\",IF(I34+1<=rngSlutår,I34+1,\"\"),\"\")","v":2022},{"$f":"IF(J34<>\"\",IF(J34+1<=rngSlutår,J34+1,\"\"),\"\")","v":2023},{"$f":"IF(K34<>\"\",IF(K34+1<=rngSlutår,K34+1,\"\"),\"\")","v":""},{"$f":"IF(L34<>\"\",IF(L34+1<=rngSlutår,L34+1,\"\"),\"\")","v":""},{"$f":"IF(M34<>\"\",IF(M34+1<=rngSlutår,M34+1,\"\"),\"\")","v":""},{"$f":"IF(N34<>\"\",IF(N34+1<=rngSlutår,N34+1,\"\"),\"\")","v":""},{"$f":"IF(O34<>\"\",IF(O34+1<=rngSlutår,O34+1,\"\"),\"\")","v":""},{"$f":"IF(P34<>\"\",IF(P34+1<=rngSlutår,P34+1,\"\"),\"\")","v":""},"Totalt"]
[null,null,null,"Personalkostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H35:Q35)","v":0}]
[null,null,null,"Utrustning, mark, byggnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kostnader för konsulter, licenser, m.m.",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Övriga direkta kostnader, inklusive resor",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Indirekta kostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Totala kostnader",null,null,null,{"$f":"SUM(H35:H39)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"((ROW(C42)-rngProjectPartsStartRow)/rngTemplateProjectRowCount) + 1","v":2},null,null,{"$f":"IF(H43<>\"\",\"PROJEKTPART \" & A42 & \" - \" & H43,\"PROJEKTPART \" & A42)","v":"PROJEKTPART 2"}]
[null,null,null,"Organisationens namn"]
[null,null,null,"Organisationsnummer"]
[null,null,null,"År",null,null,null,{"$f":"IF(rngStartår<>\"\",rngStartår,\"\")","v":2020},{"$f":"IF(H45<>\"\",IF(H45+1<=rngSlutår,H45+1,\"\"),\"\")","v":2021},2022,2023,"","","","","","","Totalt"]
[null,null,null,"Personalkostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H46:Q46)","v":0}]
[null,null,null,"Utrustning, mark, byggnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kostnader för konsulter, licenser, m.m.",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Övriga direkta kostnader, inklusive resor",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Indirekta kostnader",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Totala kostnader",null,null,null,{"$f":"SUM(H46:H50)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"SPECIFIKATION AV PROJEKTETS EGENFINANSIERING"]
[null,null,null,"Ange summan av alla projektparters bidrag i form av egen tid, kontanter och andra resurser."]
[null,null,null,"Kostnader",null,null,null,{"$f":"IF(rngStartår<>\"\",rngStartår,\"\")","v":2020},{"$f":"IF(H55<>\"\",IF(H55+1<=rngSlutår,H55+1,\"\"),\"\")","v":2021},2022,2023,"","","","","","","Totalt"]
[null,null,null,"Egen tid (kr)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H56:Q56)","v":0}]
[null,null,null,"Kontanter (kr)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H57:Q57)","v":0}]
[null,null,null,"Andra resurser (fritext)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H58:Q58)","v":0}]
[null,null,null,"Andra resurser (kr)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H59:Q59)","v":0}]
[null,null,null,"Total egenfinansiering*",null,null,null,{"$f":"H56+H57+H59","v":0},{"$f":"I56+I57+I59","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H60:Q60)","v":0}]
[null,null,null,"*Total egenfinansiering = summan av projektkoordinatorns och projektparternas egenfinansiering."]
[]
[null,null,null,"MOTIVERING AV RAPPORTERADE KOSTNADER"]
[null,null,null,"Här specificeras eventuella kostnader för publikationer, framtagning av data och open access, eller motivering av andra rapporterade kostnader."]

{"sheet":"Formas","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Inställningar","index":2,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Startrow project parts"]
[null,{"$f":"ROW(Projekt!A30) + 1","v":31}]
[]
[null,"Template project first row"]
[null,{"$f":"ROW(Projekt!A42)","v":42}]
[]
[null,"Template project rows"]
[null,{"$f":"ROWS(rngProjectPartTemplateRows)","v":11}]
[]
[null,"Number of generated projects"]
[null,{"$f":"COUNT(Projekt!A28:A42) - 1","v":1}]

{"sheet":"Grafik","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Rubrik"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rubrik"]
[]
[]
[]
[]
[]
[]
[]
[null,"R",249,72]
[null,"G",245,81]
[null,"B",230,85]