{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Hovedark","Baggrund"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Hovedark","index":0,"n_rows":126,"n_cols":22,"rows_kept":126,"cut":false,"hidden":false,"merged":[[92,18,92,19],[96,18,96,19],[104,7,104,9],[116,18,116,19],[118,18,118,19],[116,15,116,17],[115,15,115,17],[116,12,116,14],[117,12,117,14],[117,15,117,17],[105,17,105,18],[103,12,103,14],[118,15,118,17],[103,7,103,9],[98,14,98,16],[97,14,97,15],[97,16,97,17],[101,7,101,9],[100,7,100,9],[100,11,100,12],[2,6,2,11],[18,1,18,3],[23,19,23,21],[24,19,24,21],[8,0,8,21],[19,1,19,3],[20,4,20,9],[20,19,20,21],[21,19,21,21],[22,17,22,18],[22,1,22,3],[20,1,20,3],[21,1,21,3],[24,1,24,3],[23,1,23,3],[19,4,19,9],[24,4,24,9],[23,4,23,9],[21,4,21,9],[22,4,22,9],[11,5,11,7],[11,8,11,13],[18,4,18,9],[5,9,5,10],[25,19,25,21],[27,19,27,21],[18,17,18,18],[19,17,19,18],[20,17,20,18],[21,17,21,18],[22,19,22,21],[25,17,25,18],[27,17,27,18],[23,17,23,18],[24,17,24,18],[0,19,0,21],[7,5,7,7],[7,8,7,10],[19,19,19,21],[18,19,18,21],[16,17,17,18],[16,19,17,21],[2,3,2,5],[40,1,40,3],[31,1,31,3],[32,1,32,3],[25,4,25,9],[30,4,30,9],[31,4,31,9],[32,4,32,9],[35,1,35,3],[33,1,33,3],[34,1,34,3],[33,4,33,9],[34,4,34,9],[35,4,35,9],[25,1,25,3],[30,1,30,3],[0,0,0,18],[76,15,76,17],[68,1,68,4],[51,2,51,3],[52,2,52,3],[37,0,37,21],[51,16,51,17],[42,17,42,19],[47,17,47,19],[48,17,48,19],[49,11,49,13],[46,17,46,19],[40,12,40,14],[45,6,45,8],[46,6,46,8],[47,6,47,8],[48,6,48,8],[40,15,40,21],[43,17,43,19],[44,17,44,19],[45,17,45,19],[41,17,41,19],[51,19,51,21],[41,6,41,8],[42,11,42,14],[49,0,49,2],[42,0,42,3],[51,8,51,9],[66,5,66,7],[66,1,66,4],[59,7,59,9],[58,7,58,9],[65,4,65,8],[63,0,63,21],[66,10,66,12],[49,17,49,19],[96,1,96,3],[71,5,71,7],[70,1,70,4],[75,1,75,4],[92,16,92,17],[93,16,93,17],[96,14,96,15],[96,16,96,17],[78,2,78,4],[75,5,75,7],[74,5,74,7],[73,5,73,7],[76,1,76,4],[91,8,91,10],[91,16,91,17],[91,14,91,15],[92,14,92,15],[71,1,71,4],[90,8,90,10],[88,14,88,15],[87,14,87,15],[72,5,72,7],[88,8,88,10],[87,8,87,10],[118,3,118,5],[106,7,106,9],[110,8,110,10],[107,7,107,9],[116,0,116,2],[111,3,111,8],[111,11,111,19],[111,0,111,2],[103,0,103,6],[105,7,105,9],[125,3,125,5],[112,6,112,7],[117,3,117,5],[117,6,117,8],[121,5,121,19],[122,5,122,19],[117,9,117,11],[123,5,123,19],[118,6,118,8],[117,18,117,19],[116,6,116,8],[116,9,116,11],[113,0,113,21],[115,18,115,19],[115,0,115,2],[115,12,115,14],[117,0,117,2],[125,9,125,19],[116,3,116,5],[120,0,120,2],[118,12,118,14],[119,0,119,2],[118,0,118,2],[118,9,118,11],[5,11,5,13],[3,0,3,2],[3,3,3,5],[3,6,3,11],[5,3,5,5],[5,6,5,8],[29,4,29,9],[99,7,99,9],[68,5,68,7],[40,4,40,9],[49,6,49,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[97,6,97,8],[67,5,67,7],[96,10,96,12],[93,8,93,10],[95,10,95,12],[97,10,97,12],[92,8,92,10],[54,6,54,8],[67,1,67,4],[70,5,70,7],[71,15,71,17],[52,5,52,6],[51,5,51,6],[73,10,73,12],[75,10,75,12],[86,14,86,15],[67,15,67,17],[56,11,56,13],[67,10,67,12],[52,8,52,9],[62,7,62,9],[61,7,61,9],[86,8,86,10],[73,15,73,17],[69,5,69,7],[76,5,76,7],[81,4,81,8],[69,1,69,4],[72,1,72,4],[73,1,73,4],[74,1,74,4],[81,14,81,17],[74,15,74,17],[75,15,75,17],[86,18,86,19],[89,8,89,10],[88,16,88,17],[58,17,58,19],[59,17,59,19],[65,10,65,12],[66,15,66,17],[109,20,109,21],[107,20,107,21],[88,18,88,19],[86,16,86,17],[89,16,89,17],[89,18,89,19],[68,10,68,12],[81,10,81,11],[69,10,69,12],[71,10,71,12],[70,10,70,12],[72,15,72,17],[78,15,78,17],[89,14,89,15],[72,10,72,12],[76,10,76,12],[70,15,70,17],[87,16,87,17],[91,18,91,19],[52,13,52,14],[52,16,52,17],[51,13,51,14],[105,20,105,21],[93,18,93,19],[107,17,107,18],[109,17,109,18],[103,15,103,17],[90,18,90,19],[90,14,90,15],[90,16,90,17],[98,17,98,19],[95,14,95,19],[93,14,93,15],[97,18,97,19],[52,19,52,21],[68,15,68,17],[69,15,69,17],[83,0,83,21],[74,10,74,12],[54,17,54,19],[87,18,87,19]]}
["Anvisningsskema for offentlig hjælp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ver. 7"]
[]
[null,null,null,"Journalnummer",null,null,"Navn"]
["Hovedperson:",null,null,null,null,null,{"$f":"NavneOpslag(D4)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,"Civilstand",null,null,null,null,3]
[]
["Udbetaling:",null,null,"Fra og med",null,null,"2013-10-01",null,null,"T.o.m.",null,"2013-10-31",null,null,null,"Tidsperiode:",null,null,{"$f":"Dageregn(G6, L6)","v":{"$error":"#NAME?"}}]
[null,null,null,null,false,null,null,null,null,null,null,null,null,null,"NB:","1 måned = 30,4 dage"]
[null,null,null,null,null,"2004-06-01",null,null,"2004-06-30"]
["Familieforhold"]
[]
[null,null,null,null,null,"Cpr-nummer",null,null,"Navn"]
[null,"Samlever/ægtefælle:",null,null,null,null,null,null,{"$f":"NavneOpslag(F12)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Nej"]
[null,null,null,null,null,null,null,null,null,null,null,"Stempler hovedperson?"]
[null,null,null,null,null,null,null,null,null,null,null,"Stempler samlever/ægtefælle?"]
[]
[null,"Forsørgelsespligt over børn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Off. Børnetillæg/\nModt. A-bidrag",null,"A-bidrags-\npligt"]
[null,"Cpr-nummer",null,null,"Navn",null,null,null,null,null,"Forsørgelsesoplysninger"]
[1,null,null,null,{"$f":"NavneOpslag(B19)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"IF(N19=4,1,0)+IF(N19=5,1,0)+IF(N19=6,1,0)+IF(N19=7,1,0)","v":0},null,null,10,null,null,{"$f":"IF(BarnStotte(B19,N19,$F$8,$I$8,$S$4)=760,1000,0)","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($E$7=TRUE,(IF(N19=5,1000,0)+IF(N19=6,1000,0))/2,IF(N19=5,1000,0)+IF(N19=6,1000,0))","v":0}]
[2,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,{"$f":"IF(N20=4,1,0)+IF(N20=5,1,0)+IF(N20=6,1,0)+IF(N20=7,1,0)","v":0},null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q20+IF(N20=3,1000,0)-IF(N20=5,H15Y291000,0)-IF(N20=6,1000,0)+IF(N20=8,1000,0)+IF(N20=9,1000,0))/2,Q20+IF(N20=3,1000,0)-IF(N20=5,1000,0)-IF(N20=6,1000,0)+IF(N20=8,1000,0)+IF(N20=9,1000,0))+IF($S$4=1,IF(N20=2,1000,0),0)-IF($S$4=1,IF(N20=3,1000,0),0)+IF($S$4=1,IF(N20=6,1000,0),0)+IF($S$4=1,IF(N20=9,1000,0),0)+IF($S$4=2,IF(N20=2,1000,0),0)-IF($S$4=2,IF(N20=3,1000,0),0)+IF($S$4=2,IF(N20=6,1000,0),0)+IF($S$4=2,IF(N20=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[3,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q21+IF(N21=3,2000,0)-IF(N21=5,1000,0)-IF(N21=6,1000,0)+IF(N21=8,1000,0)+IF(N21=9,1000,0))/2,Q21+IF(N21=3,1000,0)-IF(N21=5,1000,0)-IF(N21=6,1000,0)+IF(N21=8,1000,0)+IF(N21=9,1000,0))+IF($S$4=1,IF(N21=2,1000,0),0)-IF($S$4=1,IF(N21=3,1000,0),0)+IF($S$4=1,IF(N21=6,1000,0),0)+IF($S$4=1,IF(N21=9,1000,0),0)+IF($S$4=2,IF(N21=2,1000,0),0)-IF($S$4=2,IF(N21=3,1000,0),0)+IF($S$4=2,IF(N21=6,1000,0),0)+IF($S$4=2,IF(N21=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[4,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q22+IF(N22=3,2000,0)-IF(N22=5,1000,0)-IF(N22=6,1000,0)+IF(N22=8,1000,0)+IF(N22=9,1000,0))/2,Q22+IF(N22=3,2000,0)-IF(N22=5,1000,0)-IF(N22=6,1000,0)+IF(N22=8,1000,0)+IF(N22=9,1000,0))+IF($S$4=1,IF(N22=2,1000,0),0)-IF($S$4=1,IF(N22=3,1000,0),0)+IF($S$4=1,IF(N22=6,1000,0),0)+IF($S$4=1,IF(N22=9,1000,0),0)+IF($S$4=2,IF(N22=2,1000,0),0)-IF($S$4=2,IF(N22=3,1000,0),0)+IF($S$4=2,IF(N22=6,1000,0),0)+IF($S$4=2,IF(N22=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[5,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q23+IF(N23=3,2000,0)-IF(N23=5,1000,0)-IF(N23=6,1000,0)+IF(N23=8,1000,0)+IF(N23=9,1000,0))/2,Q23+IF(N23=3,2000,0)-IF(N23=5,1000,0)-IF(N23=6,1000,0)+IF(N23=8,1000,0)+IF(N23=9,1000,0))+IF($S$4=1,IF(N23=2,1000,0),0)-IF($S$4=1,IF(N23=3,1000,0),0)+IF($S$4=1,IF(N23=6,1000,0),0)+IF($S$4=1,IF(N23=9,1000,0),0)+IF($S$4=2,IF(N23=2,1000,0),0)-IF($S$4=2,IF(N23=3,1000,0),0)+IF($S$4=2,IF(N23=6,1000,0),0)+IF($S$4=2,IF(N23=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[6,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q24+IF(N24=3,2000,0)-IF(N24=5,1000,0)-IF(N24=6,1000,0)+IF(N24=8,1000,0)+IF(N24=9,1000,0))/2,Q24+IF(N24=3,2000,0)-IF(N24=5,1000,0)-IF(N24=6,1000,0)+IF(N24=8,1000,0)+IF(N24=9,1000,0))+IF($S$4=1,IF(N24=2,1000,0),0)-IF($S$4=1,IF(N24=3,1000,0),0)+IF($S$4=1,IF(N24=6,1000,0),0)+IF($S$4=1,IF(N24=9,1000,0),0)+IF($S$4=2,IF(N24=2,1000,0),0)-IF($S$4=2,IF(N24=3,1000,0),0)+IF($S$4=2,IF(N24=6,1000,0),0)+IF($S$4=2,IF(N24=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[7,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q25+IF(N25=3,2000,0)-IF(N25=5,1000,0)-IF(N25=6,1000,0)+IF(N25=8,1000,0)+IF(N25=9,1000,0))/2,Q25+IF(N25=3,2000,0)-IF(N25=5,1000,0)-IF(N25=6,1000,0)+IF(N25=8,1000,0)+IF(N25=9,1000,0))+IF($S$4=1,IF(N25=2,1000,0),0)-IF($S$4=1,IF(N25=3,1000,0),0)+IF($S$4=1,IF(N25=6,1000,0),0)+IF($S$4=1,IF(N25=9,1000,0),0)+IF($S$4=2,IF(N25=2,1000,0),0)-IF($S$4=2,IF(N25=3,1000,0),0)+IF($S$4=2,IF(N25=6,1000,0),0)+IF($S$4=2,IF(N25=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[8,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,0,null,null,10,null,null,{"$error":"#NAME?"},{"$f":"IF($E$7=TRUE,(Q26+IF(N26=3,2000,0)-IF(N26=5,1000,0)-IF(N26=6,1000,0)+IF(N26=8,1000,0)+IF(N26=9,1000,0))/2,Q26+IF(N26=3,2000,0)-IF(N26=5,1000,0)-IF(N26=6,1000,0)+IF(N26=8,1000,0)+IF(N26=9,1000,0))+IF($S$4=1,IF(N26=2,1000,0),0)-IF($S$4=1,IF(N26=3,1000,0),0)+IF($S$4=1,IF(N26=6,1000,0),0)+IF($S$4=1,IF(N26=9,1000,0),0)+IF($S$4=2,IF(N26=2,1000,0),0)-IF($S$4=2,IF(N26=3,1000,0),0)+IF($S$4=2,IF(N26=6,1000,0),0)+IF($S$4=2,IF(N26=9,1000,0),0)","v":{"$error":"#NAME?"}},null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I alt",null,{"$f":"SUM(R19:S26)","v":{"$error":"#NAME?"}},null,{"$f":"SUM(T19:V26)","v":0}]
[null,"Andre personer i husstanden"]
[null,null,null,null,"Huslejekontrakt"]
[null,null,null,null,{"$f":"NavneOpslag(B31)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,"Antal voksne personer i husstanden:",null,null,null,null,null,null,1,{"$f":"Faktor(S31,S4)","v":{"$error":"#NAME?"}},{"$f":"S34+1+S31","v":{"$error":"#NAME?"}},{"$f":"S34+1+S31-IF($N$19=4,1,0)-IF($N$19=5,1,0)-IF($N$19=6,1,0)-IF($N$19=7,1,0)-IF($N$20=4,1,0)-IF($N$20=5,1,0)-IF($N$20=6,1,0)-IF($N$20=7,1,0)-IF($N$21=4,1,0)-IF($N$21=5,1,0)-IF($N$21=6,1,0)-IF($N$21=7,1,0)-IF($N$22=4,1,0)-IF($N$22=5,1,0)-IF($N$22=6,1,0)-IF($N$22=7,1,0)-IF($N$23=4,1,0)-IF($N$23=5,1,0)-IF($N$23=6,1,0)-IF($N$23=7,1,0)-IF($N$24=4,1,0)-IF($N$24=5,1,0)-IF($N$24=6,1,0)-IF($N$24=7,1,0)-IF($N$1=4,1,0)-IF($N$25=5,1,0)-IF($N$25=6,1,0)-IF($N$25=7,1,0)-IF($N$26=4,1,0)-IF($N$26=5,1,0)-IF($N$26=6,1,0)-IF($N$26=7,1,0)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S34+S31","v":{"$error":"#NAME?"}},{"$f":"S34+S31-IF($N$19=4,1,0)-IF($N$19=5,1,0)-IF($N$19=6,1,0)-IF($N$19=7,1,0)-IF($N$20=4,1,0)-IF($N$20=5,1,0)-IF($N$20=6,1,0)-IF($N$20=7,1,0)-IF($N$21=4,1,0)-IF($N$21=5,1,0)-IF($N$21=6,1,0)-IF($N$21=7,1,0)-IF($N$22=4,1,0)-IF($N$22=5,1,0)-IF($N$22=6,1,0)-IF($N$22=7,1,0)-IF($N$23=4,1,0)-IF($N$23=5,1,0)-IF($N$23=6,1,0)-IF($N$23=7,1,0)-IF($N$24=4,1,0)-IF($N$24=5,1,0)-IF($N$24=6,1,0)-IF($N$24=7,1,0)-IF($N$1=4,1,0)-IF($N$25=5,1,0)-IF($N$25=6,1,0)-IF($N$25=7,1,0)-IF($N$26=4,1,0)-IF($N$26=5,1,0)-IF($N$26=6,1,0)-IF($N$26=7,1,0)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,null,"Antal børn som hjælpsøgerne har",null,null,null,null,null,null,null,null,{"$f":"S34+IF(S4=1,1,0)+IF(S4=3,2,0)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,null,"forsørgelsespligt over",null,null,null,null,null,null,{"$f":"SeAntal(G6,B19,B20,B21,B22,B23,B24,B25,B26,B31,B32,B33,B34,B35,B36)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$error":"#NAME?"}]
[null,null,null,null,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,"Antal børn i husstanden",null,null,null,null,1]
[]
["Indtægt"]
["Hovedperson:",null,null,null,null,null,null,null,null,null,null,"Samlever/ægtefælle:"]
[null,"Cpr-nummer",null,null,"Navn",null,null,null,null,null,null,null,"Cpr-nummer",null,null,"Navn"]
[null,{"$f":"D4","v":0},null,null,{"$f":"NavneOpslag(B41)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"F12","v":0},null,null,{"$f":"NavneOpslag(M41)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,"Om måned",null,null,null,null,null,null,null,null,null,null,"Om måned"]
["Løn",null,null,null,null,null,null,null,null,null,null,"Løn",null,null,null,null,null,0]
["Børnetilskud",null,null,null,null,null,0,null,null,null,null,"Børnetilskud",null,null,null,null,null,0]
["A-bidrag",null,null,null,null,null,0,null,null,null,null,"A-bidrag",null,null,null,null,null,{"$f":"R60","v":{"$error":"#NAME?"}}]
["Skolepenge/uddannelsespenge",null,null,null,null,null,0,null,null,null,null,"Skolepenge/uddannelsespenge",null,null,null,null,null,0]
["Plejevederlag",null,null,null,null,null,0,null,null,null,null,"Plejevederlag",null,null,null,null,null,0]
["Offentligehjælp",null,null,null,null,null,0,null,null,null,null,"Offentligehjælp",null,null,null,null,null,0]
["Andet",null,null,null,null,null,0,null,null,null,null,"Andet",null,null,null,null,null,0]
["Indtægt i alt",null,null,null,null,null,{"$f":"SUM(G43:I49)","v":0},null,null,null,null,"Indtægt i alt",null,null,null,null,null,{"$f":"SUM(R43:T49)","v":{"$error":"#NAME?"}}]
[]
[null,null,"7 dage",null,null,"14 dage",null,null,"Om mdr",null,null,null,null,"7 dage",null,null,"14 dage",null,null,"Om mdr"]
[null,null,{"$f":"(G50/30.4)*7","v":0},null,null,{"$f":"(G50/30.4)*14","v":0},null,null,{"$f":"G50","v":0},null,null,null,null,{"$f":"(R50/30.4)*7","v":{"$error":"#NAME?"}},null,null,{"$f":"(R50/30.4)*14","v":{"$error":"#NAME?"}},null,null,{"$f":"R50","v":{"$error":"#NAME?"}}]
[]
["Indtægt i støtteperiode",null,null,null,null,3,{"$f":"Tilsvarer($S$6,F55,G50)","v":{"$error":"#NAME?"}},null,null,null,null,"Indtægt i støtteperiode",null,null,null,null,3,{"$f":"Tilsvarer($S$6,Q55,R50)","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,"Indtægt i alt i støtteperiode",null,null,null,null,null,{"$f":"SUM(G55,R55)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Børnetillæg til hovedperson",null,null,null,null,{"$f":"((0+IF(N19=1,1000,0)+IF(N19=3,1000,0)+IF(N19=8,1000,0)+IF(N20=1,1000,0)+IF(N20=3,1000,0)+IF(N20=8,1000,0)+IF(N21=1,1000,0)+IF(N21=3,1000,0)+IF(N21=8,1000,0)+IF(N22=1,1000,0)+IF(N22=3,1000,0)+IF(N22=8,1000,0)+IF(N23=1,1000,0)+IF(N23=3,1000,0)+IF(N23=8,1000,0)+IF(N24=1,1000,0)+IF(N24=3,1000,0)+IF(N24=8,1000,0)+IF(N25=1,1000,0)+IF(N25=3,1000,0)+IF(N25=8,1000,0)+IF(N26=1,1000,0)+IF(N26=3,1000,0)+IF(N26=8,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}},null,null,null,"Modtaget A-bidrag, hovedpers.",null,null,null,null,null,{"$f":"((0+IF(N19=8,1000,0)+IF(N20=8,1000,0)+IF(N21=8,1000,0)+IF(N22=8,1000,0)+IF(N23=8,1000,0)+IF(N24=8,1000,0)+IF(N25=8,1000,0)+IF(N26=8,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}}]
[null,null,"Børnetillæg til saml./ægtef.",null,null,null,null,{"$f":"((0+IF(N19=2,1000,0)+IF(N19=3,1000,0)+IF(N19=9,1000,0)+IF(N20=2,1000,0)+IF(N20=3,1000,0)+IF(N20=9,1000,0)+IF(N21=2,1000,0)+IF(N21=3,1000,0)+IF(N21=9,1000,0)+IF(N22=2,1000,0)+IF(N22=3,1000,0)+IF(N22=9,1000,0)+IF(N23=2,1000,0)+IF(N23=3,1000,0)+IF(N23=9,1000,0)+IF(N24=2,1000,0)+IF(N24=3,1000,0)+IF(N24=9,1000,0)+IF(N25=2,1000,0)+IF(N25=3,1000,0)+IF(N25=9,1000,0)+IF(N26=2,1000,0)+IF(N26=3,1000,0)+IF(N26=9,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}},null,null,null,"Modtaget A-bidrag, ægtef./sam.",null,null,null,null,null,{"$f":"((0+IF(N19=9,1000,0)+IF(N20=9,1000,0)+IF(N21=9,1000,0)+IF(N22=9,1000,0)+IF(N23=9,1000,0)+IF(N24=9,1000,0)+IF(N25=9,1000,0)+IF(N26=9,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}}]
[]
[null,"A-bidragspligt fra hovedperson",null,null,null,null,null,{"$f":"((0+IF(N19=5,1000,0)+IF(N20=5,1000,0)+IF(N21=5,1000,0)+IF(N22=5,1000,0)+IF(N23=5,1000,0)+IF(N24=5,1000,0)+IF(N25=5,1000,0)+IF(N26=5,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}}]
[null,"A-bidragspligt fra saml./ægtef.",null,null,null,null,null,{"$f":"((0+IF(N19=6,1000,0)+IF(N20=6,1000,0)+IF(N21=6,1000,0)+IF(N22=6,1000,0)+IF(N23=6,1000,0)+IF(N24=6,1000,0)+IF(N25=6,1000,0)+IF(N26=6,1000,0))/30.4)*S6","v":{"$error":"#NAME?"}}]
["Udgifter"]
[]
[null,null,null,null,"Udgiftsandel",null,null,null,null,null,"Periode",null,null,"Udgiftsandel i støtteperiode"]
[null,"Husleje - boligsikring",null,null,null,null,null,null,null,"pr.",{"$f":"IF(N67=1,7,0)+IF(N67=2,14,0)+IF(N67=3,30.4,0)+IF(N67=4,91.2,0)+IF(N67=5,182.4,0)+IF(N67=6,364.8,0)","v":30.4},null,null,3,null,{"$f":"(IF($S$4=1,(F67/K67)*$S$6,0)+IF($S$4=3,(F67/K67)*$S$6,0))/((IF($V$31-$S$34>2,$V$31,1))/(IF($V$31-$S$34>2,$V$32,1)))","v":{"$error":"#NAME?"}}]
[null,"El / Vand",null,null,null,null,null,null,null,"pr.",30.4,null,null,3,null,{"$error":"#NAME?"}]
[null,"Solar (varme)",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$error":"#NAME?"}]
[null,"Skorstensfejning",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$error":"#NAME?"}]
[null,"Renovation",null,null,null,null,null,null,null,"pr.",91.2,null,null,4,null,{"$error":"#NAME?"}]
[null,"Lovpl. brandfors.",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$error":"#NAME?"},null,null,{"$f":"SUM(P67:R72)","v":{"$error":"#NAME?"}}]
[null,"Daginstitution",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$f":"(IF($S$4=1,(F73/K73)*$S$6,0)+IF($S$4=3,(F73/K73)*$S$6,0))","v":{"$error":"#NAME?"}}]
[null,"(Andet)",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$f":"(IF($S$4=1,(F74/K74)*$S$6,0)+IF($S$4=3,(F74/K74)*$S$6,0))","v":{"$error":"#NAME?"}}]
[null,"(Andet)",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$f":"(IF($S$4=1,(F75/K75)*$S$6,0)+IF($S$4=3,(F75/K75)*$S$6,0))","v":{"$error":"#NAME?"}}]
[null,"(Andet)",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$f":"(IF($S$4=1,(F76/K76)*$S$6,0)+IF($S$4=3,(F76/K76)*$S$6,0))","v":{"$error":"#NAME?"}}]
[null,"(Andet)",null,null,null,0,null,null,null,"pr.",30.4,null,null,3,null,{"$f":"(IF($S$4=1,(F77/K77)*$S$6,0)+IF($S$4=3,(F77/K77)*$S$6,0))","v":{"$error":"#NAME?"}},null,null,{"$f":"SUM(P73:R77)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Udgifter i alt",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P67:R77)","v":{"$error":"#NAME?"}}]
[]
[]
[null,"Banks navn",null,null,null,null,null,null,null,"Reg:",null,null,"Konto:"]
[]
["Udmålt behov"]
[]
[null,null,"Udmålt behov i støtte periode",null,null,null,null,null,null,null,null,null,null,null,"Pr. uge",null,"Pr. 14 dag",null,"Pr. måned"]
[null,"Underholdshjælp efter takst",null,null,null,null,null,null,{"$f":"IF(E7=TRUE,(((IF((((0+IF(S4=1,1680,0)+IF(S4=2,1420,0)+IF(S4=3,2836,0)+H59+H60+T28+S72+S77)/30.4)*S6)<L57,0,(IF(S4=1,1680,0)+IF(S4=2,1420,0)+IF(S4=3,2836,0))))/30.4)*S6)/2,((IF((((0+IF(S4=1,1680,0)+IF(S4=2,1420,0)+IF(S4=3,2836,0)+H59+H60+T28+S72+S77)/30.4)*S6)<L57,(IF(S4=1,1680,0)+IF(S4=2,1420,0)+IF(S4=3,2836,0)),(IF(S4=1,1680,0)+IF(S4=2,1420,0)+IF(S4=3,2836,0))))/30.4)*S6)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Q87/2","v":{"$error":"#NAME?"}},null,{"$f":"IF(S87=3545,1772,0)+IF(S87=1772,886,0)+IF(S87=2028,1014,0)","v":{"$error":"#NAME?"}},null,{"$f":"Omregn(I87,3,$S$6)","v":{"$error":"#NAME?"}}]
[null,"Børnetillæg hovedpersonen",null,null,null,null,null,null,{"$f":"H59","v":{"$error":"#NAME?"}},null,null,null,null,null,250,null,500,null,1000]
[null,"Børnetillæg Samleveren",null,null,null,null,null,null,{"$f":"H60","v":{"$error":"#NAME?"}},null,null,null,null,null,250,null,500,null,1000]
[null,"A-bidragsindtægt",null,null,null,null,null,null,{"$f":"R59+R60","v":{"$error":"#NAME?"}},null,null,null,null,null,250,null,500,null,1000]
[null,"A-bidragspligt",null,null,null,null,null,null,{"$f":"H62+H63","v":{"$error":"#NAME?"}},null,null,null,null,null,250,null,500,null,1000]
[null,"Boligudgifter (- Boligsikring)",null,null,null,null,null,null,{"$f":"S72","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Omregn(I92,1,$S$6)","v":{"$error":"#NAME?"}},null,{"$f":"Omregn(I92,2,$S$6)","v":{"$error":"#NAME?"}},null,{"$error":"#NAME?"}]
[null,"Særudgifter",null,null,null,null,null,null,{"$f":"S77","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Omregn(I93,1,$S$6)","v":{"$error":"#NAME?"}},null,{"$f":"Omregn(I93,2,$S$6)","v":{"$error":"#NAME?"}},null,{"$error":"#NAME?"}]
[null,"Udmålt behov i alt",null,null,null,null,null,null,{"$f":"SUM(I87:K93)","v":{"$error":"#NAME?"}},null,null,null,null,null,757,null,1514,null,{"$error":"#NAME?"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Pr. måned",null,null,null,"Tre sidste måneders indtægt"]
[null,null,null,null,null,null,null,1,null,null,0,null,null,1,"1. måned",null,"2. måned",null,"3. måned"]
[null,null,null,null,null,null,{"$f":"IF(I94>B97,B97,I94)","v":{"$error":"#NAME?"}},null,null,null,0,null,null,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gennemsnit",null,null,{"$f":"(O98+Q98+S98)/O101","v":0}]
["Udmålt behov i alt",null,null,null,null,null,null,{"$f":"((IF(B97>G98,G98,(IF(I94<B97,I94,B97))))/30.4)*S6","v":{"$error":"#NAME?"}}]
["- Indtægt",null,null,null,null,null,null,{"$f":"L57","v":{"$error":"#NAME?"}},null,null,null,"Arts nr. til",null,null,{"$f":"IF(P101+R101+S101=0,1,P101+R101+S101)","v":1},{"$f":"IF(O98>0,1,0)","v":0},2,{"$f":"IF(Q98>0,1,0)","v":0},{"$f":"IF(S98>0,1,0)","v":0}]
[{"$f":"IF(H100-H101<0,Baggrund!B11,0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"H100-H101","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(Q101=3,Baggrund!C40,0)","v":0},null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q102=17,Baggrund!H53,IF(Q102=18,Baggrund!H54,0))","v":0},{"$f":"IF(Q102=9,Baggrund!H45,IF(Q102=10,Baggrund!H46,IF(Q102=11,Baggrund!H47,IF(Q102=12,Baggrund!H48,IF(Q102=13,Baggrund!H49,IF(Q102=14,Baggrund!H50,IF(Q102=15,Baggrund!H51,IF(Q102=16,Baggrund!H52,R103))))))))","v":0}]
["- Husleje/El/Vand/Varme/Daginstitution",null,null,null,null,null,null,{"$f":"IF(A117+D117+A119+G117<0,0,A117+D117+A119+G117)","v":{"$error":"#NAME?"}},null,null,{"$f":"IF((H102)<(I92+I93),H102,(I92+I93))","v":{"$error":"#NAME?"}},null,{"$f":"IF(Q101=3,Baggrund!C41,0)","v":0},null,null,{"$f":"IF(Q102=1,Baggrund!H37,IF(Q102=2,Baggrund!H38,IF(Q102=3,Baggrund!H39,IF(Q102=4,Baggrund!H40,IF(Q102=5,Baggrund!H41,IF(Q102=6,Baggrund!H42,IF(Q102=7,Baggrund!H43,IF(Q102=8,Baggrund!H44,S103))))))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H102-H104<0,0,H102-H104)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Art nr."]
["- A-bidrag i alt",null,null,null,null,null,null,{"$f":"A121","v":{"$error":"#NAME?"}},null,null,null,"Til anvisning af faste udgifter",null,null,null,null,null,{"$f":"H104+H107","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(Q101=1,455,0)+IF(Q101=2,443,0)+IF(Q101=3,133,0)","v":443}]
["- Skorsten./Renovation/Forsikring/Andet",null,null,null,null,null,null,{"$f":"M117+P117+J117+D119+G119+J119+M119","v":{"$error":"#NAME?"}}]
["Kontant udbetaling",null,null,null,null,null,null,{"$f":"H105-H106-H107","v":{"$error":"#NAME?"}},null,null,null,"Til anvisning af A-bidrag",null,null,null,null,null,{"$f":"H106","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(Q101=1,455,0)+IF(Q101=2,443,0)+IF(Q101=3,133,0)","v":443}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Heraf til kontant udbetaling",null,null,null,null,null,{"$f":"H108","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(Q101=1,449,0)+IF(Q101=2,437,0)+IF(Q101=3,133,0)","v":437}]
[]
[{"$f":"TODAY()","v":"2016-05-25"}]
[null,null,null,"Anvisning",null,null,null,null,null,null,null,"Attestation"]
["*Til anvisning og påligning af faste udgifter, månedligt beløb"]
[]
["Husleje",null,null,"El + vand",null,null,"Solar (varme)",null,null,"Skorstensfejning",null,null,"Renovation",null,null,"Brandforsiking",null,null,"I alt bolig"]
[{"$f":"IF(K104>P67,P67,K104)","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(($K$104-P67)>P68,P68,IF($K$104-P67<0,0,$K$104-P67))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(($K$104-P67-P68)>P69,P69,IF($K$104-P67-P68<0,0,$K$104-P67-P68))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106>$P$70,$P$70,IF($H$105-$H$106<$P$70,($H$105-$H$106),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117>$P$71,$P$71,IF($H$105-$H$106-$J$117<$P$71,($H$105-$H$106-$J$117),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117-$M$117>$P$72,$P$72,IF($H$105-$H$106-$J$117-$M$117<$P$72,($H$105-$H$106-$J$117-$M$117),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"SUM(A117:R117)","v":{"$error":"#NAME?"}}]
["Daginstitution",null,null,{"$f":"IF(B74=0,0,B74)","v":"(Andet)"},null,null,{"$f":"IF(B75=0,0,B75)","v":"(Andet)"},null,null,{"$f":"IF(B76=0,0,B76)","v":"(Andet)"},null,null,{"$f":"IF(B77=0,0,B77)","v":"(Andet)"},null,null,null,null,null,"I alt andet"]
[{"$f":"IF(($K$104-$P$67-$P$68-P69)>P73,P73,IF($K$104-$P$67-$P$68-P69<0,0,$K$104-$P$67-$P$68-P69))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117-$M$117-$P$117>$P$74,$P$74,IF($H$105-$H$106-$J$117-$M$117-$P$117<$P$74,($H$105-$H$106-$J$117-$M$117-$P$117),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119>$P$75,$P$75,IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119<$P$75,($H$105-$H$106-$J$117-$M$117-$P$117-$D$119),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119>$P$76,$P$76,IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119<$P$76,($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119),0))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119-$J$119>$P$77,$P$77,IF($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119-$J$119<$P$77,($H$105-$H$106-$J$117-$M$117-$P$117-$D$119-$G$119-J119),0))","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"SUM(A119:R119)","v":{"$error":"#NAME?"}}]
["A-bidrag"]
[{"$f":"IF(H105>T28,T28,IF(H105<0,0,H105))","v":{"$error":"#NAME?"}},null,null,null,null,"Bemærkninger"]
[]
[]
[]
[]
["Pålignet dato:",null,null,null,null,null,null,null,"Af:"]

{"sheet":"Baggrund","index":1,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,26,0],[24,1,24,7]]}
["Beregningsskema for offentlig hjælp"]
["Baggrundstal for støtteudregningen",null,"Pr. Uge","Pr. dag",null,"Pr. md"]
[null,"Enlig  ",468,66.849999999999994,null,2028]
[null,"Enlig samboende",409,58.42,null,1772]
[null,"Samliv/Ægteskab",818,116.85,null,3545]
[null,"Børnetillæg",350,50,null,1516]
[null,"Særbørn",175,25,null,758]
[]
[]
[]
[null,"Indtægtet er større end samlede hjælp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Uge","Enlig m/ egen bolig","Hovedpersonens",null,null,1,"Trangsvurderet hjælp"]
["14 dage","Enlig samboende/logerende","Samleverens",null,null,2,"Udvidet behovsvurderet hjælp"]
["Måned","Gift/samlevende","Fælles",null,null,3,"Andre kommuner / Interimskonto"]
["Kvartal",null,"Anbragt",null,null,4]
["Halvår",null,"Bidragspligt, hovedperson",null,null,5]
["År",null,"Bidragspligt, samlever",null,null,6]
[null,null,"Skolehjem",null,null,7]
[null,null,"Modtager bidrag, hovedpersonen",null,null,8]
[1,"Aasiaat","Modtager bidrag, ægtefælle/samleveren",null,null,9,null,"999999-1006"]
[2,"Ammassalik/Tasiilaq",null,null,null,10,null,"999999-1804"]
[3,"Ilulissat",null,null,null,null,null,"999999-1219"]
[4,"Ittoqqortoormiut","Hvilken Kommune?",null,null,null,null,"999999-1901"]
[5,"Kangaatsiaq","Kunde nr.:",null,null,null,null,"999999-0905"]
[6,"Maniitsoq",null,null,null,null,null,"999999-0700"]
[7,"Nanortalik",null,null,null,null,null,"999999-0107"]
[8,"Narsaq",null,null,null,null,null,"999999-0301"]
[9,"Paamiut",null,null,null,null,null,"999999-0506"]
[10,"Qaqortoq",null,null,null,null,null,"999999-0204"]
[11,"Qasigiannguit",null,null,null,null,null,"999999-1103"]
[12,"Qeqertarsuaq",null,null,null,null,null,"999999-1405"]
[13,"Sisimiut",null,null,null,null,null,"999999-0808"]
[14,"Qaanaaq/Thule",null,null,null,null,null,"999999-1707"]
[15,"Upernavik",null,null,null,null,null,"999999-1618"]
[16,"Uummannaq",null,null,null,null,null,"999999-1502"]
[17,"Danmarkskontoret",null,null,null,null,null,"999000-9997"]
[18]