{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Entry","Calculations","About This Template"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":3,"defined_names":41,"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":"Data Entry","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,26,3],[28,2,28,9],[27,1,27,3],[0,0,0,2]]}
[]
[]
[null,"Paretodiagram"]
[]
[null,"Paretoanalyse er et prioriteringsverktøy i forbedringsarbeid for å kunne skille \"de vitale få\" årsakene til problemene fra \"de trivielle mange\". Ofte skyldes 80 % av problemene 20 % av årsakene; derfor kalles dette også 80/20-regelen. Ved å finne de årsakene som skaper flest problemer og feil og gjøre noe med dem, får man mest effekt av forbedringstiltakene. \n\nErstatt egen kategorier og forekomst i tabellene under. Diagrammet fremstilles så automatisk."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Eksempel er hentet fra et forbedringsarbeid om trykksår, hvor man ønsket en større forståelse for hvor på kroppen trykksårene oppstod. Denne oversikten ble sammen med innsikt i alvorligheten av trykksårene brukt til å prioritere videre innsats."]
[]
[null,null,"Category","Total",null,"Category","Total",null,"Category","Total"]
[null,null,"Sacrum",4]
[null,null,"Sittebensknute",25]
[null,null,"Hæl",16]
[null,null,"Bak øret",2]
[null,null,"Skulder",4]
[null,null,"Bakhodet",12]
[null,null,"Albu",3]
[null,null,"Indre ankelben",1]
[null,null,"Ytre ankelben",2]
[null,null,"Nese",1]
[null,null,"Annet sted",2]

{"sheet":"Calculations","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["Untied Rank","Activity","Days","Pareto X Axis","Bars","Ordered Rank",null,"Percentage"]
[{"$f":"IF(C7=\"\",\"\",RANK(C7,C$7:C$51)+COUNTIF(C$7:C7,C7)-1)","v":4},{"$f":"IF('Data Entry'!C32=\"\",\"\",'Data Entry'!C32)","v":"Sacrum"},{"$f":"IF('Data Entry'!D32=\"\",\"\",'Data Entry'!D32)","v":4},{"$f":"IF(C7=\"\",\"\",INDEX($A$7:$C$51,MATCH(F7,$A$7:$A$51,0),2))","v":"Sittebensknute"},{"$f":"IF(C7=\"\",\"\",INDEX($A$7:$C$51,MATCH(F7,$A$7:$A$51,0),3))","v":25},1,null,{"$f":"IF(E7=\"\",\"\",E7/SUM($E$7:$E$51))","v":0.34722222222222221}]
[{"$f":"IF(C8=\"\",\"\",RANK(C8,C$7:C$51)+COUNTIF(C$7:C8,C8)-1)","v":1},{"$f":"IF('Data Entry'!C33=\"\",\"\",'Data Entry'!C33)","v":"Sittebensknute"},{"$f":"IF('Data Entry'!D33=\"\",\"\",'Data Entry'!D33)","v":25},"Hæl",16,2,null,{"$f":"IF(E8=\"\",\"\",(E8/SUM($E$7:$E$51)+H7))","v":0.56944444444444442}]
[{"$f":"IF(C9=\"\",\"\",RANK(C9,C$7:C$51)+COUNTIF(C$7:C9,C9)-1)","v":2},{"$f":"IF('Data Entry'!C34=\"\",\"\",'Data Entry'!C34)","v":"Hæl"},{"$f":"IF('Data Entry'!D34=\"\",\"\",'Data Entry'!D34)","v":16},"Bakhodet",12,3,null,{"$f":"IF(E9=\"\",\"\",(E9/SUM($E$7:$E$51)+H8))","v":0.73611111111111105}]
[{"$f":"IF(C10=\"\",\"\",RANK(C10,C$7:C$51)+COUNTIF(C$7:C10,C10)-1)","v":7},{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":"Bak øret"},{"$f":"IF('Data Entry'!D35=\"\",\"\",'Data Entry'!D35)","v":2},"Sacrum",4,4,null,0.79166666666666663]
[{"$f":"IF(C11=\"\",\"\",RANK(C11,C$7:C$51)+COUNTIF(C$7:C11,C11)-1)","v":5},{"$f":"IF('Data Entry'!C36=\"\",\"\",'Data Entry'!C36)","v":"Skulder"},{"$f":"IF('Data Entry'!D36=\"\",\"\",'Data Entry'!D36)","v":4},"Skulder",4,5,null,0.84722222222222221]
[{"$f":"IF(C12=\"\",\"\",RANK(C12,C$7:C$51)+COUNTIF(C$7:C12,C12)-1)","v":3},{"$f":"IF('Data Entry'!C37=\"\",\"\",'Data Entry'!C37)","v":"Bakhodet"},{"$f":"IF('Data Entry'!D37=\"\",\"\",'Data Entry'!D37)","v":12},"Albu",3,6,null,0.88888888888888884]
[{"$f":"IF(C13=\"\",\"\",RANK(C13,C$7:C$51)+COUNTIF(C$7:C13,C13)-1)","v":6},{"$f":"IF('Data Entry'!C38=\"\",\"\",'Data Entry'!C38)","v":"Albu"},{"$f":"IF('Data Entry'!D38=\"\",\"\",'Data Entry'!D38)","v":3},"Bak øret",2,7,null,0.91666666666666663]
[{"$f":"IF(C14=\"\",\"\",RANK(C14,C$7:C$51)+COUNTIF(C$7:C14,C14)-1)","v":10},{"$f":"IF('Data Entry'!C39=\"\",\"\",'Data Entry'!C39)","v":"Indre ankelben"},{"$f":"IF('Data Entry'!D39=\"\",\"\",'Data Entry'!D39)","v":1},"Ytre ankelben",2,8,null,0.94444444444444442]
[{"$f":"IF(C15=\"\",\"\",RANK(C15,C$7:C$51)+COUNTIF(C$7:C15,C15)-1)","v":8},{"$f":"IF('Data Entry'!C40=\"\",\"\",'Data Entry'!C40)","v":"Ytre ankelben"},{"$f":"IF('Data Entry'!D40=\"\",\"\",'Data Entry'!D40)","v":2},"Annet sted",2,9,null,0.97222222222222221]
[{"$f":"IF(C16=\"\",\"\",RANK(C16,C$7:C$51)+COUNTIF(C$7:C16,C16)-1)","v":11},{"$f":"IF('Data Entry'!C41=\"\",\"\",'Data Entry'!C41)","v":"Nese"},{"$f":"IF('Data Entry'!D41=\"\",\"\",'Data Entry'!D41)","v":1},"Indre ankelben",1,10,null,0.98611111111111105]
[{"$f":"IF(C17=\"\",\"\",RANK(C17,C$7:C$51)+COUNTIF(C$7:C17,C17)-1)","v":9},{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":"Annet sted"},{"$f":"IF('Data Entry'!D42=\"\",\"\",'Data Entry'!D42)","v":2},"Nese",1,11,null,0.99999999999999989]
[{"$f":"IF(C18=\"\",\"\",RANK(C18,C$7:C$51)+COUNTIF(C$7:C18,C18)-1)","v":""},{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},{"$f":"IF('Data Entry'!D43=\"\",\"\",'Data Entry'!D43)","v":""},"","",12,null,""]
[{"$f":"IF(C19=\"\",\"\",RANK(C19,C$7:C$51)+COUNTIF(C$7:C19,C19)-1)","v":""},{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},{"$f":"IF('Data Entry'!D44=\"\",\"\",'Data Entry'!D44)","v":""},"","",13,null,""]
[{"$f":"IF(C20=\"\",\"\",RANK(C20,C$7:C$51)+COUNTIF(C$7:C20,C20)-1)","v":""},{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},{"$f":"IF('Data Entry'!D45=\"\",\"\",'Data Entry'!D45)","v":""},"","",14,null,""]
[{"$f":"IF(C21=\"\",\"\",RANK(C21,C$7:C$51)+COUNTIF(C$7:C21,C21)-1)","v":""},{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},{"$f":"IF('Data Entry'!D46=\"\",\"\",'Data Entry'!D46)","v":""},"","",15,null,""]
[{"$f":"IF(C22=\"\",\"\",RANK(C22,C$7:C$51)+COUNTIF(C$7:C22,C22)-1)","v":""},{"$f":"IF('Data Entry'!F32=\"\",\"\",'Data Entry'!F32)","v":""},{"$f":"IF('Data Entry'!G32=\"\",\"\",'Data Entry'!G32)","v":""},"","",16,null,""]
[{"$f":"IF(C23=\"\",\"\",RANK(C23,C$7:C$51)+COUNTIF(C$7:C23,C23)-1)","v":""},{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""},{"$f":"IF('Data Entry'!G33=\"\",\"\",'Data Entry'!G33)","v":""},"","",17,null,""]
[{"$f":"IF(C24=\"\",\"\",RANK(C24,C$7:C$51)+COUNTIF(C$7:C24,C24)-1)","v":""},{"$f":"IF('Data Entry'!F34=\"\",\"\",'Data Entry'!F34)","v":""},{"$f":"IF('Data Entry'!G34=\"\",\"\",'Data Entry'!G34)","v":""},"","",18,null,""]
[{"$f":"IF(C25=\"\",\"\",RANK(C25,C$7:C$51)+COUNTIF(C$7:C25,C25)-1)","v":""},{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""},{"$f":"IF('Data Entry'!G35=\"\",\"\",'Data Entry'!G35)","v":""},"","",19,null,""]
[{"$f":"IF(C26=\"\",\"\",RANK(C26,C$7:C$51)+COUNTIF(C$7:C26,C26)-1)","v":""},{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""},{"$f":"IF('Data Entry'!G36=\"\",\"\",'Data Entry'!G36)","v":""},"","",20,null,""]
[{"$f":"IF(C27=\"\",\"\",RANK(C27,C$7:C$51)+COUNTIF(C$7:C27,C27)-1)","v":""},{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""},{"$f":"IF('Data Entry'!G37=\"\",\"\",'Data Entry'!G37)","v":""},"","",21,null,""]
[{"$f":"IF(C28=\"\",\"\",RANK(C28,C$7:C$51)+COUNTIF(C$7:C28,C28)-1)","v":""},{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""},{"$f":"IF('Data Entry'!G38=\"\",\"\",'Data Entry'!G38)","v":""},"","",22,null,""]
[{"$f":"IF(C29=\"\",\"\",RANK(C29,C$7:C$51)+COUNTIF(C$7:C29,C29)-1)","v":""},{"$f":"IF('Data Entry'!F39=\"\",\"\",'Data Entry'!F39)","v":""},{"$f":"IF('Data Entry'!G39=\"\",\"\",'Data Entry'!G39)","v":""},"","",23,null,""]
[{"$f":"IF(C30=\"\",\"\",RANK(C30,C$7:C$51)+COUNTIF(C$7:C30,C30)-1)","v":""},{"$f":"IF('Data Entry'!F40=\"\",\"\",'Data Entry'!F40)","v":""},{"$f":"IF('Data Entry'!G40=\"\",\"\",'Data Entry'!G40)","v":""},"","",24,null,""]
[{"$f":"IF(C31=\"\",\"\",RANK(C31,C$7:C$51)+COUNTIF(C$7:C31,C31)-1)","v":""},{"$f":"IF('Data Entry'!F41=\"\",\"\",'Data Entry'!F41)","v":""},{"$f":"IF('Data Entry'!G41=\"\",\"\",'Data Entry'!G41)","v":""},"","",25,null,""]
[{"$f":"IF(C32=\"\",\"\",RANK(C32,C$7:C$51)+COUNTIF(C$7:C32,C32)-1)","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF('Data Entry'!G42=\"\",\"\",'Data Entry'!G42)","v":""},"","",26,null,""]
[{"$f":"IF(C33=\"\",\"\",RANK(C33,C$7:C$51)+COUNTIF(C$7:C33,C33)-1)","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF('Data Entry'!G43=\"\",\"\",'Data Entry'!G43)","v":""},"","",27,null,""]
[{"$f":"IF(C34=\"\",\"\",RANK(C34,C$7:C$51)+COUNTIF(C$7:C34,C34)-1)","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF('Data Entry'!G44=\"\",\"\",'Data Entry'!G44)","v":""},"","",28,null,""]
[{"$f":"IF(C35=\"\",\"\",RANK(C35,C$7:C$51)+COUNTIF(C$7:C35,C35)-1)","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF('Data Entry'!G45=\"\",\"\",'Data Entry'!G45)","v":""},"","",29,null,""]
[{"$f":"IF(C36=\"\",\"\",RANK(C36,C$7:C$51)+COUNTIF(C$7:C36,C36)-1)","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF('Data Entry'!G46=\"\",\"\",'Data Entry'!G46)","v":""},"","",30,null,""]
[{"$f":"IF(C37=\"\",\"\",RANK(C37,C$7:C$51)+COUNTIF(C$7:C37,C37)-1)","v":""},{"$f":"IF('Data Entry'!I32=\"\",\"\",'Data Entry'!I32)","v":""},{"$f":"IF('Data Entry'!J32=\"\",\"\",'Data Entry'!J32)","v":""},"","",31,null,""]
[{"$f":"IF(C38=\"\",\"\",RANK(C38,C$7:C$51)+COUNTIF(C$7:C38,C38)-1)","v":""},{"$f":"IF('Data Entry'!I33=\"\",\"\",'Data Entry'!I33)","v":""},{"$f":"IF('Data Entry'!J33=\"\",\"\",'Data Entry'!J33)","v":""},"","",32,null,""]
[{"$f":"IF(C39=\"\",\"\",RANK(C39,C$7:C$51)+COUNTIF(C$7:C39,C39)-1)","v":""},{"$f":"IF('Data Entry'!I34=\"\",\"\",'Data Entry'!I34)","v":""},{"$f":"IF('Data Entry'!J34=\"\",\"\",'Data Entry'!J34)","v":""},"","",33,null,""]
[{"$f":"IF(C40=\"\",\"\",RANK(C40,C$7:C$51)+COUNTIF(C$7:C40,C40)-1)","v":""},{"$f":"IF('Data Entry'!I35=\"\",\"\",'Data Entry'!I35)","v":""},{"$f":"IF('Data Entry'!J35=\"\",\"\",'Data Entry'!J35)","v":""},"","",34,null,""]
[{"$f":"IF(C41=\"\",\"\",RANK(C41,C$7:C$51)+COUNTIF(C$7:C41,C41)-1)","v":""},{"$f":"IF('Data Entry'!I36=\"\",\"\",'Data Entry'!I36)","v":""},{"$f":"IF('Data Entry'!J36=\"\",\"\",'Data Entry'!J36)","v":""},"","",35,null,""]
[{"$f":"IF(C42=\"\",\"\",RANK(C42,C$7:C$51)+COUNTIF(C$7:C42,C42)-1)","v":""},{"$f":"IF('Data Entry'!I37=\"\",\"\",'Data Entry'!I37)","v":""},{"$f":"IF('Data Entry'!J37=\"\",\"\",'Data Entry'!J37)","v":""},"","",36,null,""]
[{"$f":"IF(C43=\"\",\"\",RANK(C43,C$7:C$51)+COUNTIF(C$7:C43,C43)-1)","v":""},{"$f":"IF('Data Entry'!I38=\"\",\"\",'Data Entry'!I38)","v":""},{"$f":"IF('Data Entry'!J38=\"\",\"\",'Data Entry'!J38)","v":""},"","",37,null,""]
[{"$f":"IF(C44=\"\",\"\",RANK(C44,C$7:C$51)+COUNTIF(C$7:C44,C44)-1)","v":""},{"$f":"IF('Data Entry'!I39=\"\",\"\",'Data Entry'!I39)","v":""},{"$f":"IF('Data Entry'!J39=\"\",\"\",'Data Entry'!J39)","v":""},"","",38,null,""]
[{"$f":"IF(C45=\"\",\"\",RANK(C45,C$7:C$51)+COUNTIF(C$7:C45,C45)-1)","v":""},{"$f":"IF('Data Entry'!I40=\"\",\"\",'Data Entry'!I40)","v":""},{"$f":"IF('Data Entry'!J40=\"\",\"\",'Data Entry'!J40)","v":""},"","",39,null,""]
[{"$f":"IF(C46=\"\",\"\",RANK(C46,C$7:C$51)+COUNTIF(C$7:C46,C46)-1)","v":""},{"$f":"IF('Data Entry'!I41=\"\",\"\",'Data Entry'!I41)","v":""},{"$f":"IF('Data Entry'!J41=\"\",\"\",'Data Entry'!J41)","v":""},"","",40,null,""]
[{"$f":"IF(C47=\"\",\"\",RANK(C47,C$7:C$51)+COUNTIF(C$7:C47,C47)-1)","v":""},{"$f":"IF('Data Entry'!I42=\"\",\"\",'Data Entry'!I42)","v":""},{"$f":"IF('Data Entry'!J42=\"\",\"\",'Data Entry'!J42)","v":""},{"$f":"IF(C47=\"\",\"\",INDEX($A$7:$C$51,MATCH(F47,$A$7:$A$51,0),2))","v":""},{"$f":"IF(C47=\"\",\"\",INDEX($A$7:$C$51,MATCH(F47,$A$7:$A$51,0),3))","v":""},41,null,""]
[{"$f":"IF(C48=\"\",\"\",RANK(C48,C$7:C$51)+COUNTIF(C$7:C48,C48)-1)","v":""},{"$f":"IF('Data Entry'!I43=\"\",\"\",'Data Entry'!I43)","v":""},{"$f":"IF('Data Entry'!J43=\"\",\"\",'Data Entry'!J43)","v":""},{"$f":"IF(C48=\"\",\"\",INDEX($A$7:$C$51,MATCH(F48,$A$7:$A$51,0),2))","v":""},{"$f":"IF(C48=\"\",\"\",INDEX($A$7:$C$51,MATCH(F48,$A$7:$A$51,0),3))","v":""},42,null,""]
[{"$f":"IF(C49=\"\",\"\",RANK(C49,C$7:C$51)+COUNTIF(C$7:C49,C49)-1)","v":""},{"$f":"IF('Data Entry'!I44=\"\",\"\",'Data Entry'!I44)","v":""},{"$f":"IF('Data Entry'!J44=\"\",\"\",'Data Entry'!J44)","v":""},{"$f":"IF(C49=\"\",\"\",INDEX($A$7:$C$51,MATCH(F49,$A$7:$A$51,0),2))","v":""},{"$f":"IF(C49=\"\",\"\",INDEX($A$7:$C$51,MATCH(F49,$A$7:$A$51,0),3))","v":""},43,null,""]
[{"$f":"IF(C50=\"\",\"\",RANK(C50,C$7:C$51)+COUNTIF(C$7:C50,C50)-1)","v":""},{"$f":"IF('Data Entry'!I45=\"\",\"\",'Data Entry'!I45)","v":""},{"$f":"IF('Data Entry'!J45=\"\",\"\",'Data Entry'!J45)","v":""},{"$f":"IF(C50=\"\",\"\",INDEX($A$7:$C$51,MATCH(F50,$A$7:$A$51,0),2))","v":""},{"$f":"IF(C50=\"\",\"\",INDEX($A$7:$C$51,MATCH(F50,$A$7:$A$51,0),3))","v":""},44,null,""]
[{"$f":"IF(C51=\"\",\"\",RANK(C51,C$7:C$51)+COUNTIF(C$7:C51,C51)-1)","v":""},{"$f":"IF('Data Entry'!I46=\"\",\"\",'Data Entry'!I46)","v":""},{"$f":"IF('Data Entry'!J46=\"\",\"\",'Data Entry'!J46)","v":""},{"$f":"IF(C51=\"\",\"\",INDEX($A$7:$C$51,MATCH(F51,$A$7:$A$51,0),2))","v":""},{"$f":"IF(C51=\"\",\"\",INDEX($A$7:$C$51,MATCH(F51,$A$7:$A$51,0),3))","v":""},45,null,""]

{"sheet":"About This Template","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[7,2,7,4]]}