{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2018 Q4 Total","RD 2018 Q4 Cap T","RD 2018 Q4 Cap S","Repossed Properties - Year","Repossed Properties - Quarter","LTV","LTV - Sectors","LTV - Classification","3m arrears","Borrower segmentation Nordic","Borrower Exposure to Int. rate"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":2},"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":"RD 2018 Q4 Total","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2018 Q4 - Total portfolio"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",457722.90431511222,null,169115.18427267988,null,125203.75318239981,null,46794.761846130001,null,798836.60361632193]
[null," - Number of loans",403332,null,35470,null,12193,null,13265,null,464260]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",175241.10725541998,null,76321.975122769974,null,20766.051230159996,null,8942.2385380899959,null,281271.37214643985]
[null," - repayment loans",127992.46762764,null,69514.822338249971,null,18968.299133519995,null,5597.452800549996,null,222073.04189995994]
[null," - interest-only ",47248.639627779979,null,6807.1527845200008,null,1797.7520966399993,null,3344.7857375400004,null,59198.330246479971]
[null,"FlexLån®",248733.42154006992,null,72030.724184829989,null,32898.326034999991,null,24619.174507369997,null,378281.64626726991]
[null," - repayment loans",109064.66422658993,null,48117.31759175998,null,19620.766583419994,null,8844.1157730500036,null,185646.86417481987]
[null," - interest-only ",139668.75731347999,null,23913.406593069998,null,13277.559451579995,null,15775.058734319993,null,192634.78209244998]
[null,"FlexGaranti®, Rentedyk TM",12624.696101740001,null,388.04730815999989,null,193.40934253,null,187.17644833000006,null,13393.329200760003]
[null," - repayment loans",10143.7339718,null,363.06681801999991,null,193.40934253,null,179.75989008000005,null,10879.970022430001]
[null," - interest-only ",2480.9621299400005,null,24.980490140000001,null,0,null,7.4165582499999996,null,2513.3591783300003]
[null,"FlexKort®",21049.203429700006,null,2103.9438235699995,null,2154.4686140900003,null,7968.9221607400023,null,33276.538028100003]
[null," - repayment loans",6147.3683703100014,null,1154.8623073699998,null,1371.3361105500003,null,2287.6542449799995,null,10961.22103321]
[null," - interest-only ",14901.835059390003,null,949.08151619999967,null,783.13250354000002,null,5681.2679157600032,null,22315.316994890003]
[null,"Other floating rate loans",74.475988179999987,null,18270.493833349996,null,69191.497960620007,null,5077.2501915999983,null,92613.717973749997]
[null," - repayment loans",48.202757489999996,null,6771.781925949992,null,32692.766528530017,null,2114.4833602299991,null,41627.234572200003]
[null," - interest-only ",26.273230689999998,null,11498.711907400002,null,36498.73143208999,null,2962.7668313699996,null,50986.483401549995]
[null," Total",457722.90431510989,null,169115.18427267994,null,125203.75318239999,null,46794.761846129986,null,798836.60361631971]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",205335.21585862988,null,65822.082234589994,null,51035.440710170005,null,3476.86496769,null,325669.60377107991]
[null," - Other Sealand",86814.805107809996,null,17207.555583669997,null,10217.831908570004,null,13173.156354160006,null,127413.34895421]
[null," - Region South Denmark",71178.70273225008,null,29766.544104619981,null,23699.991236729988,null,16058.702679629994,null,140703.94075323004]
[null," - Region Central Jutland",72080.900324229951,null,40357.144867079973,null,18534.221599440003,null,8612.87679518,null,139585.14358592994]
[null," - Region North Jutland",22312.704374159985,null,12748.079244380013,null,5614.2064035800013,null,5473.1610494700026,null,46148.151071589993]
[null," - Other area",0.57591803000000008,null,3213.7782383400004,null,16102.061323910004,null,0,null,19316.415480280004]
[null,"Total",457722.90431510995,null,169115.18427267997,null,125203.7531824,null,46794.761846130008,null,798836.60361631995]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",245273.25155709992,null,7770.5972103399981,null,3102.6149014300013,null,3092.2965109999973,null,259238.76017986992]
[null," 2 - 5",177083.82566606,null,11021.042515559995,null,4955.5120591399973,null,6281.0369351200034,null,199341.41717587996]
[null," 5 - 20",34258.173849510007,null,44901.966761929943,null,18677.142089460027,null,15271.067293030004,null,113108.34999392998]
[null," 20 - 50",999.75793373999977,null,38517.333077829928,null,18089.602279360013,null,14163.256883419999,null,71769.950174349928]
[null," 50 - 100",107.89530869999999,null,25466.930745170008,null,14651.662996809997,null,6068.4126321599979,null,46294.901682840005]
[null," 100 and above",0,null,41437.313961850006,null,65727.218856200008,null,1918.6915913999999,null,109083.22440945001]
[null,"Total",457722.90431510995,null,169115.18427267988,null,125203.75318240003,null,46794.761846130008,null,798836.60361631983]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",24163.55127894997,null,10054.244164410002,null,5179.3457333100023,null,1216.0766949400004,null,40613.217871609981]
[null,"> 12 - ≤ 24 months",25738.99265018999,null,7760.2435485099923,null,7163.9166756500017,null,1434.3885028100005,null,42097.541377159978]
[null,"> 24 - ≤ 36 months",23170.179812110044,null,7388.2538607399947,null,7670.0572755500043,null,1450.4726810299996,null,39678.963629430036]
[null,"> 36 - ≤ 60 months",41927.987032919991,null,12949.016795459998,null,16686.699898049992,null,2724.3794287000023,null,74288.083155129978]
[null,"> 60 months",342722.19354094117,null,130963.42590356016,null,88503.733599839805,null,39969.444538650074,null,602158.79758299119]
[null,"Total",457722.90431511117,null,169115.18427268014,null,125203.7531823998,null,46794.761846130074,null,798836.60361632111]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",171636.52167285819,null,71658.985559860099,null,51691.294918063744,null,18723.674248901974,null,313710.47639968403]
[null,"20 - 40%",144124.86304273404,null,46022.665498262861,null,43034.041678344292,null,15500.591561126977,null,248682.16178046819]
[null,"40 - 60%",96353.02393727687,null,28929.224729274403,null,24322.447124799684,null,9588.1171292716208,null,159192.81292062256]
[null,"60 - 80%",39154.15811366558,null,13116.438017613356,null,4011.8803804042136,null,2482.5634708948646,null,58765.039982578011]
[null,"> 80 %",6454.3375475347621,null,9387.8704683391079,null,2144.0890803579491,null,499.81543582458369,null,18486.112532056402]
[null,"Total",457722.90431406948,null,169115.18427334982,null,125203.75318196989,null,46794.761846020025,null,798836.60361540923]

{"sheet":"RD 2018 Q4 Cap T","index":1,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2018 Q4 - Capital center T"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",268919.94847622042,null,85351.882819910199,null,98765.663090559989,null,37460.311917240033,null,490497.80630393064]
[null," - Number of loans",222339,null,16107,null,8190,null,10165,null,256801]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",0,null,2.6378000699999999,null,83.310200969999997,null,0,null,85.948001039999994]
[null," - repayment loans",0,null,2.6378000699999999,null,0,null,0,null,2.6378000699999999]
[null," - interest-only ",0,null,0,null,83.310200969999997,null,0,null,83.310200969999997]
[null,"FlexLån®",247801.83336004009,null,65796.952443239978,null,32278.419444830004,null,24526.624703880007,null,370403.82995199005]
[null," - repayment loans",108821.61455034012,null,42567.648495469977,null,19462.618477460004,null,8798.7248806000043,null,179650.6064038701]
[null," - interest-only ",138980.21880969999,null,23229.303947770004,null,12815.800967370003,null,15727.89982328,null,190753.22354811998]
[null,"FlexGaranti®, Rentedyk TM",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"FlexKort®",21049.203429700006,null,2103.9438235699995,null,2154.4686140900003,null,7968.9221607399977,null,33276.538028100003]
[null," - repayment loans",6147.3683703100014,null,1154.8623073699998,null,1371.3361105500001,null,2287.6542449800008,null,10961.221033210002]
[null," - interest-only ",14901.835059390003,null,949.0815161999999,null,783.13250354000002,null,5681.2679157599978,null,22315.316994890003]
[null,"Other floating rate loans",68.911686479999986,null,17448.348753029997,null,64249.464830670026,null,4964.7650526200005,null,86731.490322800018]
[null," - repayment loans",42.638455790000002,null,6080.5273060499976,null,29560.354579540028,null,2001.9982212500008,null,37685.51856263003]
[null," - interest-only ",26.273230689999998,null,11367.821446979999,null,34689.110251129998,null,2962.7668313700001,null,49045.971760169996]
[null," Total",268919.94847622013,null,85351.882819909966,null,98765.663090560032,null,37460.311917240004,null,490497.80630393006]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",126606.25809274994,null,31359.069798719986,null,41612.479036329976,null,2743.52148971,null,202321.32841750988]
[null," - Other Sealand",49379.357756930018,null,7763.5853262699975,null,7381.3011816400021,null,10948.216556820003,null,75472.460821660017]
[null," - Region South Denmark",38446.874737070029,null,15639.67665641,null,18141.313241290009,null,12242.74016329,null,84470.604798060027]
[null," - Region Central Jutland",42165.519238819972,null,20578.99153281999,null,12521.114706650003,null,7073.7619807300052,null,82339.38745901997]
[null," - Region North Jutland",12321.938650650001,null,6997.4663031099981,null,3295.4156039100017,null,4452.0717266899992,null,27066.892284359998]
[null," - Other area",0,null,3013.0932025799998,null,15814.039320739999,null,0,null,18827.13252332]
[null,"Total",268919.94847621996,null,85351.882819909966,null,98765.663090560003,null,37460.311917240011,null,490497.80630392994]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",133009.60590498016,null,4710.4118642500034,null,1849.0041712699999,null,2017.6937368700003,null,141586.71567737014]
[null," 2 - 5",111139.77409635994,null,5533.8803675200024,null,3401.3461922600009,null,4946.645586249997,null,125021.64624238994]
[null," 5 - 20",24006.184999730009,null,20379.329318410015,null,13361.341796449989,null,12702.371337260003,null,70449.22745185002]
[null," 20 - 50",701.05333134999978,null,17846.543964320001,null,12652.393225290005,null,11380.075451100005,null,42580.065972060009]
[null," 50 - 100",63.330143799999995,null,13363.220819979993,null,10736.739268200001,null,4767.2795091599983,null,28930.569741139992]
[null," 100 and above",0,null,23518.496485430005,null,56764.838437089995,null,1646.2462965999998,null,81929.581219120009]
[null,"Total",268919.94847622007,null,85351.882819910024,null,98765.663090560003,null,37460.311917239997,null,490497.80630393012]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",12580.83182677,null,6964.3026937399973,null,3934.0777495499992,null,854.18371574999958,null,24333.395985809999]
[null,"> 12 - ≤ 24 months",14754.416361769992,null,5647.8508154299952,null,5306.1506883000011,null,991.54188368999996,null,26699.959749189991]
[null,"> 24 - ≤ 36 months",12759.312219349998,null,3594.2826139800018,null,6173.4083327500011,null,1036.3604150099998,null,23563.363581090001]
[null,"> 36 - ≤ 60 months",22597.761144569995,null,7859.8997979100059,null,14554.142488040003,null,2045.3293164800004,null,47057.132747000011]
[null,"> 60 months",206227.62692376011,null,61285.546898850022,null,68797.883831920015,null,32532.896586309987,null,368843.95424084016]
[null,"Total",268919.94847622007,null,85351.882819910024,null,98765.663090560032,null,37460.311917239989,null,490497.80630393018]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",100936.31236203955,null,32602.855884644596,null,42810.788789350467,null,15171.816872849984,null,191521.77390888458]
[null,"20 - 40%",85353.39109590702,null,25264.553833872662,null,33993.458287506146,null,12380.043767211386,null,156991.44698449722]
[null,"40 - 60%",56951.50792947063,null,16966.587975112176,null,17927.749787039294,null,7547.7364729110232,null,99393.582164533131]
[null,"60 - 80%",21793.838245004681,null,6878.6339123594526,null,2852.2385392705487,null,1972.2121133352709,null,33496.922809969954]
[null,"> 80 %",3884.8988435281099,null,3639.2512141911998,null,1181.4276868535264,null,388.50269068233939,null,9094.080435255175]
[null,"Total",268919.94847594993,null,85351.882820180079,null,98765.663090019996,null,37460.311916990016,null,490497.80630314013]

{"sheet":"RD 2018 Q4 Cap S","index":2,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2018 Q4 - Capital center S"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",175980.60473304012,null,50930.121019119957,null,21074.150987210014,null,8926.7530908899898,null,256911.62983026009]
[null," - Number of loans",153042,null,9816,null,2903,null,2597,null,168358]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",171193.73921030993,null,49955.709508509965,null,20415.805371169998,null,8827.9306670000005,null,250393.18475698991]
[null," - repayment loans",123974.95733871996,null,43148.556723989961,null,18701.363475499998,null,5483.1449294599988,null,191308.02246766991]
[null," - interest-only ",47218.781871589978,null,6807.1527845200008,null,1714.4418956699994,null,3344.7857375400004,null,59085.162289319982]
[null,"FlexLån®",931.58818002999999,null,888.51279741000008,null,619.90659016999996,null,79.035239619999999,null,2519.0428072300001]
[null," - repayment loans",243.04967625,null,204.41015211000001,null,158.14810596000001,null,31.876328580000006,null,637.48426290000009]
[null," - interest-only ",688.53850377999993,null,684.10264530000006,null,461.75848421000001,null,47.15891104,null,1881.5585443299999]
[null,"FlexGaranti®, Rentedyk TM",3855.2773427000002,null,85.898713200000003,null,38.439025869999995,null,19.787184270000001,null,3999.4022660400001]
[null," - repayment loans",1860.9200454300003,null,61.710189400000004,null,38.439025869999995,null,12.37062602,null,1973.4398867200002]
[null," - interest-only ",1994.3572972699999,null,24.188523800000002,null,0,null,7.4165582499999996,null,2025.9623793199999]
[null,"FlexKort®",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"Other floating rate loans",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null," Total",175980.60473303992,null,50930.121019119972,null,21074.150987209996,null,8926.7530908900007,null,256911.62983025989]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",75652.059286259959,null,24507.401594190003,null,8115.1368707000011,null,712.5643019900001,null,108987.16205313997]
[null," - Other Sealand",33586.180017640007,null,4688.6102297300013,null,2405.2983863499999,null,2122.3977951899997,null,42802.486428910008]
[null," - Region South Denmark",29947.921263830005,null,7488.4931626599973,null,3878.7479711399978,null,3641.2910096899991,null,44956.453407320005]
[null," - Region Central Jutland",27716.351317389999,null,11562.298732799998,null,4573.4935195499993,null,1469.8965952200003,null,45322.040164959988]
[null," - Region North Jutland",9078.0928479199956,null,2683.3172997399993,null,2101.4742394700006,null,980.60338880000029,null,14843.487775929998]
[null," - Other area",0,null,0,null,0,null,0,null,0]
[null,"Total",175980.60473303997,null,50930.121019119993,null,21074.15098721,null,8926.7530908899989,null,256911.62983025998]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100802.67267957996,null,2166.0052076300003,null,980.46121200000005,null,901.02079331000016,null,104850.15989251997]
[null," 2 - 5",64647.50044457995,null,3940.272555349999,null,1426.9148021500005,null,1249.9101737800006,null,71264.597975859942]
[null," 5 - 20",10187.161841589999,null,15848.736100629998,null,4852.9564311699978,null,2471.1820941899987,null,33360.036467579994]
[null," 20 - 50",298.70460238999999,null,11247.131162669994,null,4752.6545196599991,null,2737.7712596399992,null,19036.261544359993]
[null," 50 - 100",44.565164899999999,null,7064.8933364699997,null,3029.8812032699998,null,1295.0689961200003,null,11434.408700760001]
[null," 100 and above",0,null,10663.082656370001,null,6031.2828189599995,null,271.79977385000001,null,16966.165249180001]
[null,"Total",175980.60473303992,null,50930.121019119993,null,21074.15098721,null,8926.7530908899989,null,256911.62983025986]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",11570.754142289996,null,1825.4272988999996,null,1235.3642292500003,null,361.89297918999995,null,14993.438649629996]
[null,"> 12 - ≤ 24 months",10963.632813449998,null,2036.9883613999996,null,1821.3151733099996,null,441.73635243999996,null,15263.672700599998]
[null,"> 24 - ≤ 36 months",10388.611025500002,null,3713.1798789900004,null,1488.8617301500001,null,393.40845002999981,null,15984.061084670002]
[null,"> 36 - ≤ 60 months",19293.169858710004,null,4972.9879466400025,null,2119.1490476099998,null,671.16748427999994,null,27056.474337240004]
[null,"> 60 months",123764.43689309004,null,38381.537533189963,null,14409.460806889994,null,7058.5478249499993,null,183613.98305812001]
[null,"Total",175980.60473304003,null,50930.121019119964,null,21074.150987209992,null,8926.7530908899989,null,256911.62983026]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",64147.670840505532,null,25268.596865514788,null,7341.6847882915781,null,3291.4213189618195,null,100049.37381327373]
[null,"20 - 40%",55050.64293641589,null,12520.269575230133,null,7762.5845642205077,null,3027.9405346050999,null,78361.437610471636]
[null,"40 - 60%",37701.422164756863,null,7005.7684931061367,null,4970.1826995303763,null,2018.7396305069628,null,51696.112987900335]
[null,"60 - 80%",16767.602642436486,null,3321.1304477443077,null,581.61026478297936,null,487.379003632901,null,21157.722358596671]
[null,"> 80 %",2313.2661482851809,null,2814.3556377345994,null,418.08867046455657,null,101.2726032732147,null,5646.9830597575519]
[null,"Total",175980.60473239995,null,50930.121019329963,null,21074.150987289999,null,8926.7530909799971,null,256911.6298299999]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"End year","Stock","Repossed in year"]
[null,1986,471,933]
[null,1987,630,1238]
[null,1988,1562,2797]
[null,1989,2654,4209]
[null,1990,3201,4213]
[null,1991,2463,3950]
[null,1992,2331,3441]
[null,1993,1720,3264]
[null,1994,732,1479]
[null,1995,215,572]
[null,1996,97,265]
[null,1997,32,198]
[null,1998,24,107]
[null,1999,15,87]
[null,2000,28,109]
[null,2001,54,117]
[null,2002,51,169]
[null,2003,51,158]
[null,2004,26,101]
[null,2005,13,47]
[null,2006,1,16]
[null,2007,4,6]
[null,2008,23,46]
[null,2009,37,58]
[null,2010,164,235]
[null,2011,161,217]
[null,2012,156,198]
[null,2013,122,164]
[null,2014,70,108]
[null,2015,58,78]
[null,2016,51,81]
[null,2017,31,50]
[null,2018,29,43]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Quarter","Homeowner Segment","Corporate Segments","Total"]
[null,"2002 Q4",45,6,{"$f":"C5+D5","v":51}]
[null,"2003 Q1",48,7,{"$f":"C6+D6","v":55}]
[null,"2003 Q2",59,5,64]
[null,"2003 Q3",64,5,69]
[null,"2003 Q4",46,5,51]
[null,"2004 Q1",49,5,54]
[null,"2004 Q2",41,5,46]
[null,"2004 Q3",26,3,29]
[null,"2004 Q4",24,2,26]
[null,"2005 Q1",20,3,23]
[null,"2005 Q2",15,3,18]
[null,"2005 Q3",10,3,13]
[null,"2005 Q4",10,3,13]
[null,"2006 Q1",6,1,7]
[null,"2006 Q2",5,0,5]
[null,"2006 Q3",0,0,0]
[null,"2006 Q4",1,0,1]
[null,"2007 Q1",0,0,0]
[null,"2007 Q2",0,0,0]
[null,"2007 Q3",1,0,1]
[null,"2007 Q4",4,0,4]
[null,"2008 Q1",4,0,4]
[null,"2008 Q2",8,0,8]
[null,"2008 Q3",12,1,13]
[null,"2008 Q4",20,3,23]
[null,"2009 Q1",26,1,27]
[null,"2009 Q2",27,1,28]
[null,"2009 Q3",24,2,26]
[null,"2009 Q4",30,7,37]
[null,"2010 Q1",61,20,81]
[null,"2010 Q2",87,27,114]
[null,"2010 Q3",113,32,145]
[null,"2010 Q4",133,31,164]
[null,"2011 Q1",140,39,{"$f":"C38+D38","v":179}]
[null,"2011 Q2",130,34,{"$f":"C39+D39","v":164}]
[null,"2011 Q3",116,37,153]
[null,"2011 Q4",118,43,161]
[null,"2012 Q1",118,48,166]
[null,"2012 Q2",135,51,186]
[null,"2012 Q3",115,42,157]
[null,"2012 Q4",109,47,156]
[null,"2013 Q1",109,40,149]
[null,"2013 Q2",109,29,138]
[null,"2013 Q3",96,32,128]
[null,"2013 Q4",96,26,122]
[null,"2014 Q1",91,16,107]
[null,"2014 Q2",72,19,91]
[null,"2014 Q3",57,14,71]
[null,"2014 Q4",56,14,{"$f":"C53+D53","v":70}]
[null,"2015 Q1",53,14,67]
[null,"2015 Q2",55,12,{"$f":"C55+D55","v":67}]
[null,"2015 Q3",56,13,{"$f":"C56+D56","v":69}]
[null,"2015 Q4",45,13,58]
[null,"2016 Q1",47,10,57]
[null,"2016 Q2",44,12,{"$f":"C59+D59","v":56}]
[null,"2016 Q3",41,15,{"$f":"C60+D60","v":56}]
[null,"2016 Q4",38,13,{"$f":"C61+D61","v":51}]
[null,"2017 Q1",41,9,{"$f":"C62+D62","v":50}]
[null,"2017 Q2",36,9,{"$f":"C63+D63","v":45}]
[null,"2017 Q3",30,7,{"$f":"C64+D64","v":37}]
[null,"2017 Q4",26,5,{"$f":"C65+D65","v":31}]
[null,"2018 Q1",28,3,{"$f":"C66+D66","v":31}]
[null,"2018 Q2",24,3,{"$f":"C67+D67","v":27}]
[null,"2018 Q3",20,3,{"$f":"C68+D68","v":23}]
[null,"2018 Q4",26,3,{"$f":"C69+D69","v":29}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":57,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Loan to value %","2005 Q2","2005 Q3","2005 Q4","2006 Q1","2006 Q2","2006 Q3","2006 Q4","2007 Q1","2007 Q2","2007 Q3","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3","2017 Q4","2018 Q1","2018 Q2","2018 Q3","2018 Q4"]
[null,"Private",64.97,65.47,62.75,61.55,59.06,58.73,56.28,57.15,56.02,56.58,57.84,59.3,57.14,60.13,66.03,67.569999999999993,69.23,71.959999999999994,72.38,70.58,72.23,70.98,70.599999999999994,68.52,70.45,72.83,76.209999999999994,75.959999999999994,73.59,72.099999999999994,72.989999999999995,74.52,72.7,73.37,72.400000000000006,73.244,72.239999999999995,72.575999999999993,72.349999999999994,72.150000000000006,69.239999999999995,67.185000000000002,66.164000000000001,67,66.48,65.734999999999999,64.723202000000001,64.628,64.430000000000007,63.746000000000002,63.35,62.92,62.22,61.41,60.97]
[null,"Commercial",53.51,54.3,48.54,50.65,51.63,49.59,49,49.02,49.09,45.89,47.15,48.46,48.04,54.46,54.78,54.31,59.27,62.88,65.5,62.25,61.09,61.45,62.52,60.69,64.89,60.06,64.209999999999994,63.93,62.81,59.64,60.21,63.78,59.46,59.81,59.4,58.201000000000001,59.31,59.878,60.38,60.5,57.84,58.116999999999997,57.783000000000001,57.8,54.93,56.378999999999998,55.373230999999997,54.387,53,52.76,52.17,52.36,51.02,51.23,52.79]
[null,"Agriculture",59.45,58.76,56.45,56.1,55.16,53.87,51.21,52.33,52.31,51.76,53.22,52.13,51.31,54.91,49.92,53.32,57.56,59.24,61.03,59.03,60.92,60.43,61.94,60.21,60.49,61.62,61.43,60.4,63.42,63.17,63.71,64,63.18,63.14,64.2,59.475999999999999,60.07,59.557000000000002,59.78,58.63,58.7,58.494999999999997,58.84,58.3,57.59,59.05,58.872926,59.094000000000001,59.28,58.594000000000001,58.15,56.8,56.98,56.92,56.28]
[null,"Rental residential",94,96.46,68.72,62.18,61.5,62.66,59.74,60.99,59.82,56.41,57.98,58.79,61.47,63.05,66.13,67.87,71.83,76.05,76.02,74.87,76.510000000000005,78.48,74.41,74.11,73.63,75.59,79.3,79.540000000000006,77.67,85.24,84.34,79.930000000000007,80.739999999999995,77.16,78.400000000000006,75.965999999999994,78.180000000000007,76.644000000000005,78.349999999999994,75.760000000000005,74.37,74.665000000000006,71.064999999999998,71.61,70.61,70.709000000000003,70.689116999999996,68.769000000000005,69.680000000000007,67.759,69.56,68.099999999999994,67.36,67.36,66.400000000000006]
[null,"Total",69.260000000000005,70.3,62.09,60.27,58.53,58.27,55.91,56.8,55.83,55.12,56.33,57.42,56.42,59.53,63.26,64.64,67.38,70.44,71.23,69.34,70.55,70.19,69.47,67.8,69.489999999999995,70.61,73.930000000000007,73.72,71.989999999999995,72.040000000000006,72.47,73.12,71.73,71.44,71.099999999999994,70.578999999999994,70.66,70.62,70.91,70.25,67.87,66.759,65.433000000000007,65.87,65,64.956000000000003,64.221069999999997,63.621000000000002,63.51,62.624000000000002,62.68,62.12,61.36,60.94,60.74]

{"sheet":"LTV - Sectors","index":6,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,12]]}
[]
[]
[]
[null,"Realkredit Danmark 2018 Q4"]
[null,null," "]
[]
[null,"DKK billion ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Weighted distribution",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",171.63652167285818,null,71.658985559860099,null,51.691294918063747,null,18.723674248901975,null,0.39270919106595714,null,313.71047639968401]
[null," - 20-40%",144.12486304273403,null,46.02266549826286,null,43.034041678344295,null,15.500591561126978,null,0.31130541672098111,null,248.68216178046816]
[null," - 40-60%",96.353023937276873,null,28.929224729274402,null,24.322447124799684,null,9.5881171292716214,null,0.19928081938176201,null,159.19281292062257]
[null," - 60-80%",39.154158113665581,null,13.116438017613355,null,4.0118803804042136,null,2.4825634708948647,null,7.3563279044321028E-2,null,58.765039982578017]
[null," - >80%",6.4543375475347622,null,9.3878704683391074,null,2.1440890803579493,null,0.49981543582458371,null,2.314129378697866E-2,null,18.486112532056403]
[null,"Total",457.72290431406941,null,169.11518427334983,null,125.20375318196987,null,46.79476184602003,null,1,null,798.83660361540922]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",100.93631236203954,null,32.602855884644597,null,42.810788789350461,null,15.171816872849986,null,0.39046407842753789,null,191.52177390888457]
[null," - 20-40%",85.353391095907014,null,25.264553833872661,null,33.993458287506151,null,12.380043767211387,null,0.32006554355000011,null,156.9914469844972]
[null," - 40-60%",56.95150792947063,null,16.966587975112176,null,17.927749787039296,null,7.5477364729110228,null,0.20263817877934681,null,99.393582164533115]
[null," - 60-80%",21.793838245004682,null,6.8786339123594535,null,2.8522385392705489,null,1.9722121133352708,null,6.8291687301182374E-2,null,33.496922809969959]
[null," - >80%",3.8848988435281102,null,3.6392512141911997,null,1.1814276868535263,null,0.38850269068233939,null,1.8540511941932725E-2,null,9.0940804352551741]
[null,"Total",268.91994847594998,null,85.351882820180094,null,98.765663090019984,null,37.460311916990001,null,1,null,490.49780630314007]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",64.147670840505526,null,25.268596865514791,null,7.3416847882915786,null,3.2914213189618198,null,0.38943108133904653,null,100.04937381327372]
[null," - 20-40%",55.05064293641589,null,12.520269575230133,null,7.762584564220508,null,3.0279405346050998,null,0.30501319719283976,null,78.361437610471626]
[null," - 40-60%",37.701422164756863,null,7.0057684931061361,null,4.9701826995303762,null,2.0187396305069627,null,0.20122138115003976,null,51.696112987900342]
[null," - 60-80%",16.767602642436486,null,3.3211304477443075,null,0.58161026478297939,null,0.48737900363290099,null,8.2354085615341271E-2,null,21.157722358596679]
[null," - >80%",2.3132661482851811,null,2.8143556377345997,null,0.41808867046455656,null,0.1012726032732147,null,2.1980254702732595E-2,null,5.6469830597575514]
[null,"Total",175.98060473239994,null,50.930121019329974,null,21.07415098729,null,8.9267530909799966,null,0.99999999999999989,null,256.91162982999992]

{"sheet":"LTV - Classification","index":7,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,8]]}
[]
[]
[]
[null,"Realkredit Danmark 2018 Q4"]
[null,null," "]
[]
[null,"DKK billion ","Classification 1-3",null,"Classification 4-7",null,"Classification 8-11",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",83.542156793143633,null,218.46690205334619,null,11.701417553194988,null,313.71047639968481]
[null," - 20-40%",56.221374179215211,null,181.62042443277517,null,10.840363168477836,null,248.68216178046822]
[null," - 40-60%",31.105553803049993,null,119.47662654005474,null,8.6106325775180323,null,159.19281292062277]
[null," - 60-80%",11.059203611472872,null,43.145462147847716,null,4.560374223257349,null,58.765039982577939]
[null," - >80%",5.9004212585739477,null,10.055953306761566,null,2.5297379667208819,null,18.486112532056396]
[null,"Total",187.82870964545563,null,572.76536848078547,null,38.242525489169083,null,798.83660361541024]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",44.197471777054503,null,138.32674414318225,null,8.9975579886478982,null,191.52177390888465]
[null," - 20-40%",31.244664432323475,null,117.33511957455377,null,8.4116629776198852,null,156.99144698449714]
[null," - 40-60%",17.557559243098126,null,75.235125799304498,null,6.6008971221305828,null,99.3935821645332]
[null," - 60-80%",5.710256777687019,null,24.360022500448093,null,3.4266435318348663,null,33.496922809969973]
[null," - >80%",2.3303703088218839,null,4.7883192798820762,null,1.9753908465512138,null,9.0940804352551741]
[null,"Total",101.04032253898501,null,360.04533129737075,null,29.412152466784445,null,490.49780630314018]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",27.786622629357687,null,70.082807755078122,null,2.1799434288379573,null,100.04937381327377]
[null," - 20-40%",18.308150559234942,null,57.997816336453305,null,2.0554707147834086,null,78.361437610471654]
[null," - 40-60%",9.9682225519301433,null,39.951322699968394,null,1.7765677360018042,null,51.696112987900342]
[null," - 60-80%",3.1686554345688664,null,16.995120652605628,null,0.99394627142217817,null,21.157722358596672]
[null," - >80%",1.4398108361400954,null,3.7721638172331025,null,0.4350084063843524,null,5.6469830597575505]
[null,"Total",60.671462011231732,null,188.79923126133855,null,7.4409365574297013,null,256.91162982999998]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":47,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3","2017 Q4","2018 Q1","2018 Q2","2018 Q3","2018 Q4"]
[null,"Private",0.15656218014927964,0.17622091059825712,0.21226328148524881,0.23504379286900098,0.34621659433492169,0.48567081299722087,0.63763978533718857,0.70915120590311731,0.78891781003792383,0.884183102468585,0.66014775406359882,0.57160041949894835,0.55422562049590962,0.49518388603850316,0.49110552801689522,0.6619027318422005,0.4648789078035972,0.46832181852500976,0.43548524598554395,0.42244695436316571,0.43178507225390916,0.4489009708773069,0.42524190317220628,0.34556169541261328,0.39486932956755244,0.39165920483661149,0.38089192955661699,0.31589258394518216,0.30406651058489231,0.30220907955598109,0.31330024963699726,0.2642695530501542,0.28144963972229237,0.26251829878317595,0.27048180491465101,0.27092701552282933,0.29635580051520782,0.28999999999999998,0.3,0.27,0.26,0.22,0.22,0.19,0.22]
[null,"Commercial",0.14755295177431865,8.6561935281377345E-2,0.1302500765064474,0.19974043569052896,0.31830955393429977,0.45037133694297959,1.1985979832481644,1.5621732902413716,2.5952748166498667,1.523145417237034,1.7759759291753354,1.6899327680265703,1.4822631479958117,1.0176578563538299,1.6925160102921666,1.3822367058417195,1.2855621410685494,1.2198105515838669,1.0692050316506838,1.0873151068240114,1.2748021933757456,1.0704785438655486,1.1414629242385435,1.1262714491262065,0.99763191702061105,1.0855713883277764,0.91804284337792474,0.84431163831617229,0.89993952488976359,1.3313241780657834,1.7008584999681573,0.96409495539694856,1.0269371879108964,1.0999113706925037,0.93180996923328352,0.92435286165055541,1.2090339917170199,0.97,0.74,0.71,0.46,0.28999999999999998,0.24,0.11,0.38]
[null,"Agriculture",0.16492939721116656,0.16352636059288203,0.18131578827259506,0.18585644226829021,0.29156621157097973,0.33372263690950654,0.6566990574356345,1.0562629456645494,1.0257603538302378,1.6219284518633401,1.3613901254075007,1.3102129459712726,0.93905113371874971,1.1799230483352952,1.6199597092132287,1.5673729058140449,1.3765609345047594,1.4478763731756665,1.6000588751467346,2.0190195305098846,1.7009234277787137,1.5152123905496004,1.4393100918431909,1.2379810635040327,1.2534017927207908,1.4422602051639715,1.1279391584469076,0.9218002510970208,1.1901637995616265,0.95794405873716559,1.3614154268775058,1.4843503432483875,1.3626687376114672,1.754021390291743,2.0350763958207363,2.0258747749073289,1.4581695282698581,1.38,1.18,0.8,0.69,1.27,1.49,1.52,1.5]
[null,"Rental Residential",0.10881653835393289,7.2900290215380664E-2,0.20464014665077832,0.16571449515978301,0.67866484831018647,0.72076484713388633,2.4415707119300158,1.0415567313575762,3.1518579850978306,1.2613760651035448,1.9114554979658624,0.9980525218506836,1.5838617600771265,0.8097837561888761,1.2452133108466987,0.58315400331599609,0.827580373339592,1.094845259395181,1.2689464300675897,1.1091723102862634,1.3479556446765679,1.2856214843013938,1.4062204663942004,1.2159326565244508,1.0565290633750315,1.4551837062387438,0.65298416819966598,0.69949155353057135,0.62912291933402753,0.35436787495800426,0.39745870096644126,0.23296917886124544,0.43297702935824278,0.19531119152575055,0.23189962105621692,0.13492304160070345,0.20693631147950448,0.14000000000000001,0.21,0.09,0.12,7.0000000000000007E-2,0.13,0.09,0.11]
[null,"Total",0.14463063189580319,0.11360534965430442,0.18768779885976775,0.19728265752607319,0.4071896442411998,0.54574819260952367,1.1867057540503803,1.0427039051559712,1.7800927570175831,1.237627901612,1.2810736250868875,1.0071306927190868,1.0553341596738197,0.79360601023521704,1.0642564682134805,0.83359709968849593,0.83451995720702687,0.95372864815735314,0.90078809963093975,0.9399593444498533,0.97752861418901849,0.99680059202279458,0.93819550317166944,0.91259386488129202,0.7854081252307219,1.0557314295752029,0.64873671370510011,0.61802120893024015,0.61208062629723725,0.58280097381845619,0.76463115148218486,0.48189249819686247,0.58706260481597794,0.52098721825771332,0.57290758656015295,0.48564694492417804,0.58374279409140806,0.46,0.45,0.34,0.31,0.26,0.3,0.23,0.33]

{"sheet":"Borrower segmentation Nordic","index":9,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":true,"merged":[[22,4,22,5],[29,4,29,5],[36,4,36,5],[43,4,43,5]]}
[null,null,null,null,"Værdier"]
[null,null,"kapcenter","sektor4","Sum af kormar","Sum af kormar_non_Nordic"]
[{"$f":"B3&\"-\"&D3","v":"S-Boligudl"},{"$f":"IF(C3=\"\",B2,C3)","v":"S"},"S","Boligudl",50930121019.119957,50930121019.119957]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21074150987.209999,21074150987.209999]
["S-Landbrug","S",null,"Landbrug",8926753090.8899956,8926753090.8899956]
["S-Privat","S",null,"Privat",175980604733.03995,175980604733.03995]
["S Total-","S Total","S Total",null,256911629830.25989,256911629830.25989]
["T-Boligudl","T","T","Boligudl",85351882819.910202,82338789617.330154]
["T-Erhverv","T",null,"Erhverv",98765663090.560043,82951623769.820114]
["T-Landbrug","T",null,"Landbrug",37460311917.240059,37460311917.240059]
["T-Privat","T",null,"Privat",268919948476.21979,268919948476.21979]
["T Total-","T Total","T Total",null,490497806303.93005,471670673780.61011]
["Ø-Boligudl","Ø","Ø","Boligudl",32833180433.650002,32633596470.709999]
["Ø-Erhverv","Ø",null,"Erhverv",5363939104.6299973,5075917101.4599972]
["Ø-Landbrug","Ø",null,"Landbrug",407696838.00000012,407696838.00000012]
["Ø-Privat","Ø",null,"Privat",12822351105.850002,12822351105.850002]
["Ø Total-","Ø Total","Ø Total",null,51427167482.130005,50939561516.020004]
["Grand Total-","Grand Total","Grand Total",null,798836603616.31995,779521865126.88989]
[]
[]
[]
[]
[null,null,null,null,"Kapcenter T"]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D24","v":"T-Privat"},"Privat","Private",{"$f":"VLOOKUP(C24,$A$3:$F$18,6,FALSE)","v":268919948476.21979}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":82338789617.330154}]
[null,null,"T-Erhverv","Erhverv","Commercial",82951623769.820114]
[null,null,"T-Landbrug","Landbrug","Agriculture",37460311917.240059]
[null,null,{"$f":"RIGHT($E$23,1)&\" \"&D28","v":"T Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C28,$A$3:$F$18,5,FALSE)-SUM(F24:F27)","v":18827132523.319946}]
[]
[null,null,null,null,"Kapcenter S"]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D31","v":"S-Privat"},"Privat","Private",{"$f":"VLOOKUP(C31,$A$3:$F$18,6,FALSE)","v":175980604733.03995}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":50930121019.119957}]
[null,null,"S-Erhverv","Erhverv","Commercial",21074150987.209999]
[null,null,"S-Landbrug","Landbrug","Agriculture",8926753090.8899956]
[null,null,{"$f":"RIGHT($E$30,1)&\" \"&D35","v":"S Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C35,$A$3:$F$18,5,FALSE)-SUM(F31:F34)","v":0}]
[]
[null,null,null,null,"Kapcenter Ø"]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D38","v":"Ø-Privat"},"Privat","Private",{"$f":"VLOOKUP(C38,$A$3:$F$18,6,FALSE)","v":12822351105.850002}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":32633596470.709999}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",5075917101.4599972]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",407696838.00000012]
[null,null,{"$f":"RIGHT($E$37,1)&\" \"&D42","v":"Ø Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C42,$A$3:$F$18,5,FALSE)-SUM(F38:F41)","v":487605966.11000824}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":457722904315.10974}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":165902507107.1601}]
[null,null,null,null,"Commercial",109101691858.49011]
[null,null,null,null,"Agriculture",46794761846.130051]
[null,null,null,null,"Nordic",19314738489.429955]

{"sheet":"Borrower Exposure to Int. rate","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
["Sum af kormar",null,"sektor2"]
["afdr_fri","prodtyp2","Privat","Erhverv"]
["J","CapFloat",2480962129.9099998,32397048.399999999]
[null,"F1",19249575887.599998,3345298380.8000002]
[null,"F3",29675612691.360001,8448353033.5699997]
[null,"F5",79983963486.520004,23328136028.279999]
[null,"Fixed",47248639627.849998,11949690618.690001]
[null,"Floaters",14928108290.08,58373692106.419998]
[null,"Øv. flex",10759605247.889999,17844237336.330002]
["J Total",null,204326467361.20996,123321804552.49001]
["N","CapFloat",10143733971.76,736236050.73000002]
[null,"F1",14981313724.889999,17580368481.139999]
[null,"F3",21687147630.119999,8990841987.3899994]
[null,"F5",67158466568.540001,37640462211.769997]
[null,"Fixed",127992467627.61,94080574272.649994]
[null,"Floaters",6195571127.6599998,46392884477.540001]
[null,"Øv. flex",5237736303.0699997,12370527267.870001]
["N Total",null,253396436953.64999,217791894749.09]