{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Forhandling","Ark1","Lønnshistorikk ","Kravberegning"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Forhandling","index":0,"n_rows":52,"n_cols":38,"rows_kept":52,"merged":[[0,0,0,2],[0,3,0,8],[0,9,0,13],[0,14,0,18],[0,19,0,23],[0,24,0,28],[0,29,0,33],[0,34,0,37],[44,3,44,7]]}
["Nåværende lønn og stilling",null,null,"AF 1. Krav",{"$nulls":5},"Arb.g. 1 Tilbud",{"$nulls":4},"AF 2.  Krav",{"$nulls":4},"Arb.g. 2 Tilbud",{"$nulls":4},"AF 3.  Krav",{"$nulls":4},"Arb.g. 3 Tilbud ",{"$nulls":4},"Resultat "]
["Navn","Stillingskode","Full stilling","Ny årslønn","Krav i %","Stillingskode","Prioritet","Økning kr","Datolønnsvekst","Årslønn","Tilbud i %","Stillingskode","Økning kr","Datolønnsvekst","Årslønn","Krav i %","Stillingskode","Økning","Datolønnsvekst","Årslønn","Tilbud i %","Stillingskode","Økning","Datolønnsvekst","Årslønn","Krav i %","Stillingskode","Økning","Datolønnsvekst","Årslønn","Tilbud i %","Stillingskode","Økning","Datolønnsvekst","Ny årslønn","Stillingskode","Økning ","Datolønnsvekst"]
["NN","Rådgiver",{"v":550000,"d":"kr 550,000.00"},null,4,"Rådgiver",1,{"$f":"IF(D3=0,$C3*E3/100)+IF(E3=0,D3-$C3)","v":{"v":22000,"d":"kr 22,000.00"}},{"$f":"H3/$C3*100","v":{"v":4,"d":"4.00"}},560000,null,"Rådgiver",{"$f":"IF(J3=0,$C3*K3/100)+IF(K3=0,J3-$C3)","v":{"v":10000,"d":"kr 10,000.00"}},{"$f":"M3/$C3*100","v":{"v":1.8181818181818181,"d":"1.82"}},600000,null,"Rådgiver",{"$f":"IF(O3=0,$C3*P3/100)+IF(P3=0,O3-$C3)","v":{"v":50000,"d":"kr 50,000.00"}},{"$f":"R3/$C3*100","v":{"v":9.090909090909092,"d":"9.09"}},570000,null,"Rådgiver",{"$f":"IF(T3=0,$C3*U3/100)+IF(U3=0,T3-$C3)","v":{"v":20000,"d":"kr 20,000.00"}},{"$f":"W3/$C3*100","v":{"v":3.6363636363636362,"d":"3.64"}},580000,null,"Rådgiver",{"$f":"IF(Y3=0,$C3*Z3/100)+IF(Z3=0,Y3-$C3)","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"AB3/$C3*100","v":{"v":5.454545454545454,"d":"5.45"}},580000,null,"Rådgiver",{"$f":"IF(AD3=0,$C3*AE3/100)+IF(AE3=0,AD3-$C3)","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"AG3/$C3*100","v":{"v":5.454545454545454,"d":"5.45"}},{"$f":"AG3+C3","v":{"v":580000,"d":"kr 580,000.00"}},{"$f":"AF3","v":"Rådgiver"},{"$f":"AI3-C3","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"AK3/$C3*100","v":{"v":5.454545454545454,"d":"5.45"}}]
[null,null,0,{"$nulls":4},{"$f":"IF(D4=0,$C4*E4/100)+IF(E4=0,D4-$C4)","v":0},{"$f":"H4/$C4*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$f":"M4/$C4*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$f":"R4/$C4*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$f":"AB4/$C4*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(AD4=0,$C4*AE4/100)+IF(AE4=0,AD4-$C4)","v":0},{"$f":"AG4/$C4*100","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"AK4/$C4*100","v":{"$error":"#DIV/0!"}}]
[null,null,0,{"$nulls":4},{"$f":"IF(D5=0,$C5*E5/100)+IF(E5=0,D5-$C5)","v":0},{"$f":"H5/$C5*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},{"$f":"IF(D6=0,$C6*E6/100)+IF(E6=0,D6-$C6)","v":0},{"$f":"H6/$C6*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},{"$f":"IF(D7=0,$C7*E7/100)+IF(E7=0,D7-$C7)","v":0},{"$f":"H7/$C7*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},{"$f":"IF(D10=0,$C10*E10/100)+IF(E10=0,D10-$C10)","v":0},{"$f":"H10/$C10*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(J10=0,$C10*K10/100)+IF(K10=0,J10-$C10)","v":0},{"$f":"M10/$C10*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(O10=0,$C10*P10/100)+IF(P10=0,O10-$C10)","v":0},{"$f":"R10/$C10*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(T10=0,$C10*U10/100)+IF(U10=0,T10-$C10)","v":0},{"$f":"W10/$C10*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$f":"AB10/$C10*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(AD10=0,$C10*AE10/100)+IF(AE10=0,AD10-$C10)","v":0},{"$f":"AG10/$C10*100","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"AK10/$C10*100","v":{"$error":"#DIV/0!"}}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},{"$f":"IF(D30=0,$C30*E30/100)+IF(E30=0,D30-$C30)","v":0},{"$f":"H30/$C30*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(J30=0,$C30*K30/100)+IF(K30=0,J30-$C30)","v":0},{"$f":"M30/$C30*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(O30=0,$C30*P30/100)+IF(P30=0,O30-$C30)","v":0},{"$f":"R30/$C30*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(T30=0,$C30*U30/100)+IF(U30=0,T30-$C30)","v":0},{"$f":"W30/$C30*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},0,{"$f":"AB30/$C30*100","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"IF(AD30=0,$C30*AE30/100)+IF(AE30=0,AD30-$C30)","v":0},{"$f":"AG30/$C30*100","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"AK30/$C30*100","v":{"$error":"#DIV/0!"}}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,0,{"$nulls":4},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
["Sum gruppe Akademikerforbundet",null,{"$f":"SUM(C3:C42)","v":{"v":550000,"d":"kr 550,000.00"}},{"$nulls":4},{"$f":"SUM(H3:H42)","v":{"v":22000,"d":"kr 22,000.00"}},{"$f":"SUMIF(I3:I42,\">0\")/COUNT(I3:I42)","v":{"v":4,"d":"4.00"}},{"$nulls":3},{"$f":"SUM(M3:M42)","v":{"v":10000,"d":"kr 10,000.00"}},{"$f":"SUMIF(N3:N42,\">0\")/COUNT(N3:N42)","v":{"v":1.8181818181818181,"d":"1.82"}},{"$nulls":3},{"$f":"SUM(R3:R42)","v":{"v":50000,"d":"kr 50,000.00"}},{"$f":"SUMIF(S3:S42,\">0\")/COUNT(S3:S42)","v":{"v":9.090909090909092,"d":"9.09"}},{"$nulls":3},{"$f":"SUM(W3:W42)","v":{"v":20000,"d":"kr 20,000.00"}},{"$f":"SUMIF(X3:X42,\">0\")/COUNT(X3:X42)","v":{"v":3.6363636363636362,"d":"3.64"}},{"$nulls":3},{"$f":"SUM(AB3:AB42)","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"SUMIF(AC3:AC42,\">0\")/COUNT(AC3:AC42)","v":{"v":5.454545454545454,"d":"5.45"}},{"$nulls":3},{"$f":"SUM(AG3:AG42)","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"SUMIF(AH3:AH42,\">0\")/COUNT(AH3:AH42)","v":{"v":5.454545454545454,"d":"5.45"}},{"$f":"SUM(AI3:AI42)","v":{"v":580000,"d":"kr 580,000.00"}},0,{"$f":"SUM(AK3:AK42)","v":{"v":30000,"d":"kr 30,000.00"}},{"$f":"SUMIF(AL3:AL42,\">0\")/COUNT(AL3:AL42)","v":{"v":5.454545454545454,"d":"5.45"}}]
[]
["Virkningsmåned ",null,5]
["Måneder med lønnsøking ",null,{"$f":"13-Virkningsdato","v":8}]
[]
[]
[]
[]
["Gjennomsnitt månedslønn nå",{"$f":"C3/12","v":{"v":45833.333333333336,"d":"kr 45,833.33"}}]
["Gjennomsnitt månedslønn krav ",{"$f":"D4/12","v":0}]

{"sheet":"Ark1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Lønnshistorikk ","index":2,"n_rows":15,"n_cols":15,"rows_kept":15}
["Navn ","Gjennomsnitt siste tre år ","Lønn d.å","Lønnsøkning i %","Lønnsøkning kr","Lønn minus ett år","Lønnsøkning i %","Lønnsøkning kr","Lønn minus to år","Lønnsøkning i %","Lønnsøkning kr","Lønn minus tre år","Lønnsøkning i %","Lønnsøkning kr","Lønn minus fire år"]
[null,{"$f":"(D2+J2+M2)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"E2*100/F2","v":{"$error":"#DIV/0!"}},{"$f":"C2-F2","v":0},null,{"$f":"H2*100/I2","v":{"$error":"#DIV/0!"}},{"$f":"F2-I2","v":0},null,{"$f":"K2*100/L2","v":{"$error":"#DIV/0!"}},{"$f":"I2-L2","v":0},null,{"$f":"N2*100/O2","v":{"$error":"#DIV/0!"}},{"$f":"L2-O2","v":0}]
[null,{"$f":"(D3+J3+M3)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"E3*100/F3","v":{"$error":"#DIV/0!"}},{"$f":"C3-F3","v":0},null,{"$f":"H3*100/I3","v":{"$error":"#DIV/0!"}},{"$f":"F3-I3","v":0},null,{"$f":"K3*100/L3","v":{"$error":"#DIV/0!"}},{"$f":"I3-L3","v":0},null,{"$f":"N3*100/O3","v":{"$error":"#DIV/0!"}},{"$f":"L3-O3","v":0}]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"},0]

{"sheet":"Kravberegning","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[0,0,0,2],[6,0,6,2],[11,0,11,2]]}
["Informasjon fra TBU",{"$nulls":3},"Finn datolønnsvekst (DLV)","%"]
[null,"ÅLV","DLV",null,"Årslønnsvekst ",{"v":3.7,"d":"3.70"}]
["\"Frontfag\"",{"v":3.7,"d":"3.70"},{"$f":"(B3*12)/(13-$B$8)","v":{"v":5.550000000000001,"d":"5.55"}},null,"Datolønnsvekst ",{"$f":"F2*12/Forhandling!C46","v":{"v":5.550000000000001,"d":"5.55"}}]
["Overheng"]
["Glidning"]
["Minimumresultat",{"$f":"B3-B4-B5","v":{"v":3.7,"d":"3.70"}},{"$f":"(B6*12)/(13-$B$8)","v":{"v":5.550000000000001,"d":"5.55"}},null,"Finn Årslønnsvekst (ÅLV)","%"]
["Informasjon fra forberedende møte",{"$nulls":3},"Datolønnsvekst ",5.55]
["Virkningsmåned",5,null,null,"Årslønnsveskt ",{"$f":"F7*Forhandling!C46/12","v":{"v":3.6999999999999997,"d":"3.70"}}]
["Overheng "]
["Gliding "]
["Disponibel ramme",{"$f":"B3-B9-B10","v":{"v":3.7,"d":"3.70"}},{"$f":"(B11*12)/(13-$B$8)","v":{"v":5.550000000000001,"d":"5.55"}}]
["Kravberegning "]
["Minimumresultat",{"$f":"B11","v":{"v":3.7,"d":"3.70"}},{"$f":"C11","v":{"v":5.550000000000001,"d":"5.55"}}]
["Inngangskrav ",null,{"$f":"(B14*12)/(13-$B$8)","v":{"v":0,"d":"0.00"}}]
["Forhandlingsrom ",{"$f":"B14-B13","v":{"v":-3.7,"d":"-3.70"}},{"$f":"C14-C13","v":{"v":-5.550000000000001,"d":"-5.55"}}]