{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Outline","Tutorial","Navigation","Template","Allevo","Micro","Infos","Customizing"],"not_rendered":{"images":4,"macros":1,"external_links":1,"defined_names":60},"read":"whole","date_system":"1900"}

{"sheet":"Outline","index":0,"n_rows":13,"n_cols":28,"rows_kept":13}
[]
[null,900,"FC",{"$nulls":12},"BU"]
[null,"Cost Element","Year",1,2,3,4,5,6,7,8,9,10,11,12,"Year",1,2,3,4,5,6,7,8,9,10,11,12]
[null,420000,{"v":1766,"d":"1,766"},{"v":2056,"d":"2,056"},330,289,{"v":2296,"d":"2,296"},{"v":1805,"d":"1,805"},839,229,995,{"$nulls":4},{"v":18145,"d":"18,145"},{"v":2259,"d":"2,259"},188,{"v":1422,"d":"1,422"},{"v":2035,"d":"2,035"},{"v":1069,"d":"1,069"},{"v":1705,"d":"1,705"},{"v":1316,"d":"1,316"},{"v":1876,"d":"1,876"},{"v":1870,"d":"1,870"},{"v":2136,"d":"2,136"},{"v":1493,"d":"1,493"},776]
[null,430000,641,{"v":1393,"d":"1,393"},436,{"v":1896,"d":"1,896"},{"v":1531,"d":"1,531"},{"v":1721,"d":"1,721"},{"v":1306,"d":"1,306"},329,448,{"$nulls":4},{"v":16671,"d":"16,671"},290,{"v":1922,"d":"1,922"},437,{"v":1846,"d":"1,846"},{"v":1237,"d":"1,237"},{"v":1873,"d":"1,873"},{"v":2324,"d":"2,324"},{"v":1288,"d":"1,288"},349,{"v":1629,"d":"1,629"},{"v":1104,"d":"1,104"},{"v":2372,"d":"2,372"}]
[null,440000,705,838,530,{"v":1013,"d":"1,013"},{"v":2480,"d":"2,480"},190,965,{"v":1694,"d":"1,694"},{"v":2011,"d":"2,011"},{"$nulls":4},{"v":15077,"d":"15,077"},{"v":1754,"d":"1,754"},{"v":2301,"d":"2,301"},{"v":1901,"d":"1,901"},284,803,776,389,507,{"v":1900,"d":"1,900"},350,{"v":2068,"d":"2,068"},{"v":2044,"d":"2,044"}]
[null,"Wages",{"$f":"SUM(C4:C6)","v":{"v":3112,"d":"3,112"}},{"v":4287,"d":"4,287"},{"v":1296,"d":"1,296"},{"v":3198,"d":"3,198"},{"v":6307,"d":"6,307"},{"v":3716,"d":"3,716"},{"v":3110,"d":"3,110"},{"v":2252,"d":"2,252"},{"v":3454,"d":"3,454"},0,0,0,0,{"v":49893,"d":"49,893"},{"v":4303,"d":"4,303"},{"v":4411,"d":"4,411"},{"v":3760,"d":"3,760"},{"v":4165,"d":"4,165"},{"v":3109,"d":"3,109"},{"v":4354,"d":"4,354"},{"v":4029,"d":"4,029"},{"v":3671,"d":"3,671"},{"v":4119,"d":"4,119"},{"v":4115,"d":"4,115"},{"v":4665,"d":"4,665"},{"v":5192,"d":"5,192"}]
[null,450000,900,323,840,463,{"v":1715,"d":"1,715"},{"v":1663,"d":"1,663"},{"v":1452,"d":"1,452"},791,{"v":1041,"d":"1,041"},{"$nulls":4},{"v":16071,"d":"16,071"},{"v":1042,"d":"1,042"},586,{"v":1301,"d":"1,301"},{"v":1476,"d":"1,476"},922,{"v":1620,"d":"1,620"},{"v":2364,"d":"2,364"},963,{"v":1951,"d":"1,951"},{"v":1302,"d":"1,302"},{"v":2165,"d":"2,165"},379]
[null,460000,188,773,772,{"v":2387,"d":"2,387"},{"v":1642,"d":"1,642"},486,{"v":2004,"d":"2,004"},{"v":1645,"d":"1,645"},{"v":1856,"d":"1,856"},{"$nulls":4},{"v":16071,"d":"16,071"},778,877,{"v":1749,"d":"1,749"},{"v":1331,"d":"1,331"},{"v":1201,"d":"1,201"},720,{"v":1554,"d":"1,554"},{"v":1901,"d":"1,901"},{"v":1274,"d":"1,274"},{"v":1165,"d":"1,165"},{"v":2190,"d":"2,190"},{"v":1750,"d":"1,750"}]
[null,478000,{"v":1270,"d":"1,270"},{"v":1515,"d":"1,515"},{"v":1035,"d":"1,035"},{"v":1403,"d":"1,403"},{"v":1040,"d":"1,040"},{"v":2276,"d":"2,276"},{"v":1444,"d":"1,444"},943,{"v":1378,"d":"1,378"},{"$nulls":4},{"v":16071,"d":"16,071"},128,{"v":1152,"d":"1,152"},{"v":1550,"d":"1,550"},{"v":1566,"d":"1,566"},{"v":2169,"d":"2,169"},200,{"v":2080,"d":"2,080"},{"v":1462,"d":"1,462"},{"v":1757,"d":"1,757"},{"v":2290,"d":"2,290"},318,{"v":1703,"d":"1,703"}]
[null,490000,{"v":1178,"d":"1,178"},932,{"v":1516,"d":"1,516"},370,{"v":1209,"d":"1,209"},949,{"v":2038,"d":"2,038"},{"v":1152,"d":"1,152"},{"v":1714,"d":"1,714"},{"$nulls":4},{"v":16071,"d":"16,071"},{"v":1591,"d":"1,591"},682,405,369,{"v":1294,"d":"1,294"},{"v":1846,"d":"1,846"},{"v":1511,"d":"1,511"},{"v":1106,"d":"1,106"},{"v":2335,"d":"2,335"},{"v":2428,"d":"2,428"},{"v":1305,"d":"1,305"},{"v":1707,"d":"1,707"}]
[null,"Salary",{"$f":"SUM(C8:C11)","v":{"v":3536,"d":"3,536"}},{"v":3543,"d":"3,543"},{"v":4163,"d":"4,163"},{"v":4623,"d":"4,623"},{"v":5606,"d":"5,606"},{"v":5374,"d":"5,374"},{"v":6938,"d":"6,938"},{"v":4531,"d":"4,531"},{"v":5989,"d":"5,989"},0,0,0,0,{"v":64284,"d":"64,284"},{"v":3539,"d":"3,539"},{"v":3297,"d":"3,297"},{"v":5005,"d":"5,005"},{"v":4742,"d":"4,742"},{"v":5586,"d":"5,586"},{"v":4386,"d":"4,386"},{"v":7509,"d":"7,509"},{"v":5432,"d":"5,432"},{"v":7317,"d":"7,317"},{"v":7185,"d":"7,185"},{"v":5978,"d":"5,978"},{"$f":"SUM(AB8:AB11)","v":{"v":5539,"d":"5,539"}}]
[null,"Personnel",{"$f":"SUM(C7,C12)","v":{"v":6648,"d":"6,648"}},{"v":7830,"d":"7,830"},{"v":5459,"d":"5,459"},{"v":7821,"d":"7,821"},{"v":11913,"d":"11,913"},{"v":9090,"d":"9,090"},{"v":10048,"d":"10,048"},{"v":6783,"d":"6,783"},{"v":9443,"d":"9,443"},0,0,0,0,{"v":114177,"d":"114,177"},{"v":7842,"d":"7,842"},{"v":7708,"d":"7,708"},{"v":8765,"d":"8,765"},{"v":8907,"d":"8,907"},{"v":8695,"d":"8,695"},{"v":8740,"d":"8,740"},{"v":11538,"d":"11,538"},{"v":9103,"d":"9,103"},{"v":11436,"d":"11,436"},{"v":11300,"d":"11,300"},{"v":10643,"d":"10,643"},{"$f":"SUM(AB7,AB12)","v":{"v":10731,"d":"10,731"}}]

{"sheet":"Tutorial","index":1,"n_rows":24,"n_cols":40,"rows_kept":24,"merged":[[11,11,13,11],[17,11,19,11]]}
[]
[null,null,"SHOWROW","SHOWROW","SHOWROW","SHOWROW","FREEZE"]
[null,"SHOWCOLUMN",{"$nulls":11},"*","AB","B","B","B","B","B","B","B","B","B","B","B","B","AC","C","C","C","C","C","C","C","C","C","C","C","C"]
[null,"SHOWCOLUMN",{"$nulls":12},"D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D"]
[null,"SHOWCOLUMN"]
[null,"FREEZE",{"$nulls":12},"*"]
[]
[null,null,"*",2,3,4,null,null,"Filter Rule",{"$nulls":4},{"v":2000,"d":"2,000"},"FC",{"$nulls":12},"BU"]
[null,null,1,{"$f":"D$8","v":2},{"$f":"E$8","v":3},{"$f":"F$8","v":4},null,null,"Case","User",{"$nulls":3},"Cost Element","Year",1,2,3,4,5,6,7,8,9,10,11,12,"Year",1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,{"$f":"C$9","v":1},{"$f":"TYPE(N10)","v":1},{"$f":"E$8\n*($O10>=$N$8)","v":0},{"$f":"F$8\n*CHOOSE($I10,\n    J10,\n    1)","v":4},"*",null,{"$f":"TYPE(N10)","v":1},{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N10)","v":1},null,{"$f":"_xlfn.FORMULATEXT(I10)","v":"=TYPE(N10)"},null,420000,{"v":1766,"d":"1,766"},{"v":2056,"d":"2,056"},330,289,{"v":2296,"d":"2,296"},{"v":1805,"d":"1,805"},839,229,995,{"$nulls":4},{"v":18145,"d":"18,145"},{"v":2259,"d":"2,259"},188,{"v":1422,"d":"1,422"},{"v":2035,"d":"2,035"},{"v":1069,"d":"1,069"},{"v":1705,"d":"1,705"},{"v":1316,"d":"1,316"},{"v":1876,"d":"1,876"},{"v":1870,"d":"1,870"},{"v":2136,"d":"2,136"},{"v":1493,"d":"1,493"},776]
[null,null,{"$f":"C$9","v":1},{"$f":"TYPE(N11)","v":1},{"$f":"E$8\n*($O11>=$N$8)","v":0},{"$f":"F$8\n*CHOOSE($I11,\n    J11,\n    1)","v":4},null,null,{"$f":"TYPE(N11)","v":1},{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N11)","v":1},{"$nulls":3},430000,641,{"v":1393,"d":"1,393"},436,{"v":1896,"d":"1,896"},{"v":1531,"d":"1,531"},{"v":1721,"d":"1,721"},{"v":1306,"d":"1,306"},329,448,{"$nulls":4},{"v":16671,"d":"16,671"},290,{"v":1922,"d":"1,922"},437,{"v":1846,"d":"1,846"},{"v":1237,"d":"1,237"},{"v":1873,"d":"1,873"},{"v":2324,"d":"2,324"},{"v":1288,"d":"1,288"},349,{"v":1629,"d":"1,629"},{"v":1104,"d":"1,104"},{"v":2372,"d":"2,372"}]
[null,null,1,1,0,0,null,null,1,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N12)","v":0},null,{"$f":"_xlfn.FORMULATEXT(J12)","v":"=COUNTIFS(\n   User1[User];GLOBAL_USER;\n   User1[CostElement];N12)"},null,440000,705,838,530,{"v":1013,"d":"1,013"},{"v":2480,"d":"2,480"},190,965,{"v":1694,"d":"1,694"},{"v":2011,"d":"2,011"},{"$nulls":4},{"v":15077,"d":"15,077"},{"v":1754,"d":"1,754"},{"v":2301,"d":"2,301"},{"v":1901,"d":"1,901"},284,803,776,389,507,{"v":1900,"d":"1,900"},350,{"v":2068,"d":"2,068"},{"v":2044,"d":"2,044"}]
[null,null,1,2,3,4,null,null,2,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N13)","v":0},{"$nulls":3},"Wages",{"$f":"SUM(O10:O12)","v":{"v":3112,"d":"3,112"}},{"v":4287,"d":"4,287"},{"v":1296,"d":"1,296"},{"v":3198,"d":"3,198"},{"v":6307,"d":"6,307"},{"v":3716,"d":"3,716"},{"v":3110,"d":"3,110"},{"v":2252,"d":"2,252"},{"v":3454,"d":"3,454"},0,0,0,0,{"v":49893,"d":"49,893"},{"v":4303,"d":"4,303"},{"v":4411,"d":"4,411"},{"v":3760,"d":"3,760"},{"v":4165,"d":"4,165"},{"v":3109,"d":"3,109"},{"v":4354,"d":"4,354"},{"v":4029,"d":"4,029"},{"v":3671,"d":"3,671"},{"v":4119,"d":"4,119"},{"v":4115,"d":"4,115"},{"v":4665,"d":"4,665"},{"v":5192,"d":"5,192"}]
[null,null,1,1,0,0,null,null,1,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N14)","v":0},{"$nulls":3},450000,900,323,840,463,{"v":1715,"d":"1,715"},{"v":1663,"d":"1,663"},{"v":1452,"d":"1,452"},791,{"v":1041,"d":"1,041"},{"$nulls":4},{"v":16071,"d":"16,071"},{"v":1042,"d":"1,042"},586,{"v":1301,"d":"1,301"},{"v":1476,"d":"1,476"},922,{"v":1620,"d":"1,620"},{"v":2364,"d":"2,364"},963,{"v":1951,"d":"1,951"},{"v":1302,"d":"1,302"},{"v":2165,"d":"2,165"},379]
[null,null,1,1,0,0,null,null,1,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N15)","v":0},{"$nulls":3},460000,188,773,772,{"v":2387,"d":"2,387"},{"v":1642,"d":"1,642"},486,{"v":2004,"d":"2,004"},{"v":1645,"d":"1,645"},{"v":1856,"d":"1,856"},{"$nulls":4},{"v":16071,"d":"16,071"},778,877,{"v":1749,"d":"1,749"},{"v":1331,"d":"1,331"},{"v":1201,"d":"1,201"},720,{"v":1554,"d":"1,554"},{"v":1901,"d":"1,901"},{"v":1274,"d":"1,274"},{"v":1165,"d":"1,165"},{"v":2190,"d":"2,190"},{"v":1750,"d":"1,750"}]
[null,null,1,1,0,0,null,null,1,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N16)","v":0},{"$nulls":3},478000,{"v":1270,"d":"1,270"},{"v":1515,"d":"1,515"},{"v":1035,"d":"1,035"},{"v":1403,"d":"1,403"},{"v":1040,"d":"1,040"},{"v":2276,"d":"2,276"},{"v":1444,"d":"1,444"},943,{"v":1378,"d":"1,378"},{"$nulls":4},{"v":16071,"d":"16,071"},128,{"v":1152,"d":"1,152"},{"v":1550,"d":"1,550"},{"v":1566,"d":"1,566"},{"v":2169,"d":"2,169"},200,{"v":2080,"d":"2,080"},{"v":1462,"d":"1,462"},{"v":1757,"d":"1,757"},{"v":2290,"d":"2,290"},318,{"v":1703,"d":"1,703"}]
[null,null,1,1,0,0,null,null,1,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N17)","v":0},{"$nulls":3},490000,{"v":1178,"d":"1,178"},932,{"v":1516,"d":"1,516"},370,{"v":1209,"d":"1,209"},949,{"v":2038,"d":"2,038"},{"v":1152,"d":"1,152"},{"v":1714,"d":"1,714"},{"$nulls":4},{"v":16071,"d":"16,071"},{"v":1591,"d":"1,591"},682,405,369,{"v":1294,"d":"1,294"},{"v":1846,"d":"1,846"},{"v":1511,"d":"1,511"},{"v":1106,"d":"1,106"},{"v":2335,"d":"2,335"},{"v":2428,"d":"2,428"},{"v":1305,"d":"1,305"},{"v":1707,"d":"1,707"}]
[null,null,1,2,3,4,null,null,2,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N18)","v":0},null,{"$f":"_xlfn.FORMULATEXT(J18)","v":"=COUNTIFS(\n   User1[User];GLOBAL_USER;\n   User1[CostElement];N18)"},null,"Salary",{"$f":"SUM(O14:O17)","v":{"v":3536,"d":"3,536"}},{"v":3543,"d":"3,543"},{"v":4163,"d":"4,163"},{"v":4623,"d":"4,623"},{"v":5606,"d":"5,606"},{"v":5374,"d":"5,374"},{"v":6938,"d":"6,938"},{"v":4531,"d":"4,531"},{"v":5989,"d":"5,989"},0,0,0,0,{"v":64284,"d":"64,284"},{"v":3539,"d":"3,539"},{"v":3297,"d":"3,297"},{"v":5005,"d":"5,005"},{"v":4742,"d":"4,742"},{"v":5586,"d":"5,586"},{"v":4386,"d":"4,386"},{"v":7509,"d":"7,509"},{"v":5432,"d":"5,432"},{"v":7317,"d":"7,317"},{"v":7185,"d":"7,185"},{"v":5978,"d":"5,978"},{"$f":"SUM(AN14:AN17)","v":{"v":5539,"d":"5,539"}}]
[null,null,1,{"$f":"TYPE(N19)","v":2},3,4,null,null,2,{"$f":"COUNTIFS(\n   User1[User],GLOBAL_USER,\n   User1[CostElement],N19)","v":0},{"$nulls":3},"Personnel",{"$f":"SUM(O13,O18)","v":{"v":6648,"d":"6,648"}},{"v":7830,"d":"7,830"},{"v":5459,"d":"5,459"},{"v":7821,"d":"7,821"},{"v":11913,"d":"11,913"},{"v":9090,"d":"9,090"},{"v":10048,"d":"10,048"},{"v":6783,"d":"6,783"},{"v":9443,"d":"9,443"},0,0,0,0,{"v":114177,"d":"114,177"},{"v":7842,"d":"7,842"},{"v":7708,"d":"7,708"},{"v":8765,"d":"8,765"},{"v":8907,"d":"8,907"},{"v":8695,"d":"8,695"},{"v":8740,"d":"8,740"},{"v":11538,"d":"11,538"},{"v":9103,"d":"9,103"},{"v":11436,"d":"11,436"},{"v":11300,"d":"11,300"},{"v":10643,"d":"10,643"},{"$f":"SUM(AN13,AN18)","v":{"v":10731,"d":"10,731"}}]
[null,null,{"$f":"IF(GLOBAL_USER>0,C$8,)","v":"*"}]
[null,null,{"$f":"IF(GLOBAL_USER>0,C$8,)","v":"*"}]
[null,null,{"$f":"IF(GLOBAL_USER>0,C$8,)","v":"*"}]
[]
[{"$nulls":14},"GLOBAL_USER","Mueller"]

{"sheet":"Navigation","index":2,"n_rows":11,"n_cols":39,"rows_kept":11}
[null,"Sheets",{"$nulls":7},"Views",{"$nulls":19},"Custom Button",{"$nulls":6},"History"]
[]
[null,"Menu for Sheet",{"$nulls":7},"Basic",{"$nulls":3},"Ribbon Bar",null,null,"Filter Action",{"$nulls":3},"Macro",null,"View Specials",{"$nulls":6},"Custom Button",{"$nulls":6},"View Status"]
[null,"SheetName","SheetAlias","SheetIcon","MacroBeforeActivate","MacroAfterActivate","View","Tooltip",null,"Row","SheetName","View","NavigationCorner","ViewName","ViewNameL2","ViewIcon","ShowRow","ShowColumn","Freeze","Zoom","MacroBeforeFilter","MacroAfterFilter","AutoFilter","HyperLink","ColumnWidth","RowHeight","SizeUnit","Tooltip",null,"SheetName","View","Icon","MacroName","Caption","Tooltip",null,"Property","Last","Current"]
[null,"Tutorial",null,"Circle",{"$nulls":5},{"$f":"\"0\"&COUNTIFS($K$5:K5,K5)","v":"01"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial01"},"Navigation01","Year",null,"SumSign",1,"A","A",100,{"$nulls":16},"SheetName","Tutorial","Tutorial"]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"02"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial02"},"Navigation01","FC",null,"DetailsHouse",1,"B","A",100,{"$nulls":16},"View","Tutorial07","Tutorial07"]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"03"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial03"},"Navigation01","BU",null,"DetailsDelivery",1,"C","A",100,{"$nulls":16},"NavigationCorner","Navigation01","Navigation01"]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"04"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial04"},"Navigation01","all",null,"MarketingFlag",1,"D","A",100,{"$nulls":16},"ViewName","User","User"]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"05"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial05"},"Navigation01","Filter",null,"Filter-Standard",2,"D","A",100,{"$nulls":16},"ViewNameL2"]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"06"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial06"},"Navigation01","≥",null,"ProjectBranchEngineering",3,"D","A",100]
[{"$nulls":9},{"$f":"\"0\"&COUNTIFS(NavigationViews[[#Headers],[SheetName]] : NavigationViews[[#This Row],[SheetName]],NavigationViews[[#This Row],[SheetName]])","v":"07"},"Tutorial",{"$f":"NavigationViews[[#This Row],[SheetName]]&NavigationViews[[#This Row],[Row]]","v":"Tutorial07"},"Navigation01","User",null,"DetailsChair",4,"D","A",100]

{"sheet":"Template","index":3,"n_rows":16,"n_cols":27,"rows_kept":16,"hidden":true}
[]
[null,null,"SHOWROW","SHOWROW","FREEZE"]
[null,"SHOWCOLUMN",{"$nulls":4},"A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A"]
[null,"SHOWCOLUMN",{"$nulls":4},"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
[null,"FREEZE",{"$nulls":7},"*"]
[]
[{"$nulls":7},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:G7),4),1,)","v":"A"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:H7),4),1,)","v":"B"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:I7),4),1,)","v":"C"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:J7),4),1,)","v":"D"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:K7),4),1,)","v":"E"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:L7),4),1,)","v":"F"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:M7),4),1,)","v":"G"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:N7),4),1,)","v":"H"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:O7),4),1,)","v":"I"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:P7),4),1,)","v":"J"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:Q7),4),1,)","v":"K"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:R7),4),1,)","v":"L"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:S7),4),1,)","v":"M"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:T7),4),1,)","v":"N"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:U7),4),1,)","v":"O"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:V7),4),1,)","v":"P"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:W7),4),1,)","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:X7),4),1,)","v":"R"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:Y7),4),1,)","v":"S"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMNS($G7:Z7),4),1,)","v":"T"}]
[{"$nulls":6},{"$f":"ROWS(G$7:G7)","v":1}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G8)","v":2}]
[null,null,{"$f":"C$9","v":1},{"$f":"D$9","v":2},null,null,{"$f":"ROWS(G$7:G9)","v":3}]
[null,null,{"$f":"C$9","v":1},2,"*",null,{"$f":"ROWS(G$7:G10)","v":4}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G11)","v":5}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G12)","v":6}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G13)","v":7}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G14)","v":8}]
[null,null,1,2,null,null,{"$f":"ROWS(G$7:G15)","v":9}]

{"sheet":"Allevo","index":4,"n_rows":80,"n_cols":160,"rows_kept":80,"hidden":true,"merged":[[25,23,26,23],[25,26,26,26],[25,28,25,29],[25,30,25,32],[25,34,25,35],[25,36,25,37],[25,39,25,41],[25,43,25,50],[25,52,25,54],[25,55,25,56],[25,57,25,58],[25,59,25,60]]}
[]
[null,"01","SHOWROW","SHOWROW","FREEZE"]
[null,"SHOWCOLUMN",{"$nulls":21},"*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*"]
[null,"SHOWCOLUMN"]
[null,"FREEZE",{"$nulls":31},"*"]
[{"$nulls":5},"SETCLASS","OBJECT","COMPANYCODE","DESCRIPTION","RESPONSIBLE"]
[{"$nulls":5},{"$f":"KERNLOCAL(\"OBJECTTYPE\",LocalValue)","v":""},{"$f":"KERNLOCAL(\"OBJECT\",LocalValue)","v":""},{"$f":"KERNLOCAL(\"COMPANYCODE\",LocalValue)","v":""}]
[{"$nulls":5},{"$f":"KERNLOCAL(\"OBJECTTYPE\",LocalValue)","v":""},"01",{"$f":"KERNLOCAL(\"COMPANYCODE\",LocalValue)","v":""},{"$nulls":7},"ROW",{"$nulls":7},"ELEMENT","SUMLEVEL",null,"CATEGORY"]
[{"$nulls":6},"SUM",{"$nulls":27},"S","S","S","S",null,"S","S","S",null,null,"S","S",null,null,"S","S",null,null,"S","S","S","S","S","S","S","S","S",null,"S","S","S","S","S","S","S","S","S","S","S","S",null,null,"S","S","S","S","S","S","S","S","S","S","S","S"]
[{"$nulls":6},"FORMULA"]
[{"$nulls":6},"ALLOCATIONSET",{"$nulls":12},"WRITE",null,"READ"]
[{"$nulls":6},"STYLE",{"$nulls":16},"X",null,"X","X","X","X","X","X","X","X",null,"X","X","X","X",null,"X","X","X",null,"X","X","X","X","X","X","X","X",null,"X","X","X","X","X","X","X","X","X",null,"X","X","X","X","X","X","X","X","X","X","X","X","X",null,"X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[{"$nulls":15},"ROW"]
[{"$nulls":9},"GETKEYS",{"$nulls":6},"OBJECTTYPE","OBJECT",null,"ALLOCATIONSET_POST",null,"ALLOCATIONSET",null,"ELEMENT","SUMLEVEL","ELEMENTTEXT","CATEGORY",null,"SENDER","SENDERACTIVITY","RECEIVERTYPE","RECEIVER","RECEIVERACTIVITY"]
[]
[{"$nulls":12},"01","WRITE","READ","ROW"]
[{"$nulls":12},"WRITE",{"$nulls":3},"OBJECTTYPE","OBJECT",null,"ALLOCATIONSET_POST",{"$nulls":3},"ELEMENT"]
[{"$nulls":9},"FILLKEYS",null,null,"READ",{"$nulls":3},"OBJECTTYPE","OBJECT",{"$nulls":3},"ALLOCATIONSET",null,"ELEMENT",{"$nulls":3},"ADPRULE","SENDER","SENDERACTIVITY","RECEIVERTYPE","RECEIVER","RECEIVERACTIVITY"]
[{"$nulls":14},"PROPERTY",{"$nulls":3},"DESCRIPTION_OBJECT"]
[{"$nulls":13},"TIMESET_POST",{"$nulls":27},"CY_W1",{"$nulls":5},"CX_WW","CX_WW","CX_WW",{"$nulls":12},"CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CM_W1","CY_W1",null,"CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CX_WW"]
[{"$nulls":14},"TIMESET",{"$nulls":19},"CY_R2","CY_R2","CX_RR","CX_RR",null,"CY_R1","CY_R1",null,null,"CY_RW","CY_RW","CY_RW","CY_RW",{"$nulls":15},"CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CM_R1","CY_R1",null,"CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CM_X2","CY_RW"]
[{"$nulls":13},"DIMENSION","DIMENSION",{"$nulls":19},"Q","V","Q","V",null,"Q","V",null,null,"PF","Q","V","DKF","PF","Q","V",{"$nulls":24},"N",{"$nulls":13},"N"]
[{"$nulls":13},"PERIOD","PERIOD",{"$nulls":47},1,2,3,4,5,6,7,8,9,10,11,12,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[{"$nulls":13},"ACTIVITYTYPE","ACTIVITYTYPE",{"$nulls":42},{"$f":"BF26","v":""},{"$f":"BF26","v":""},{"$f":"BH26","v":""},{"$f":"BH26","v":""}]
[null,null,"*",2,{"$nulls":19},{"$f":"KERNLOCAL(\"OBJECT1\",LocalValue)","v":""},null,{"$f":"KERNLOCAL(\"DESCRIPTION\",LocalValue)","v":""},"EC","ADP","Sender",null,"Receiver",{"$nulls":3},{"$f":"CY_R2","v":{"$error":"#NAME?"}},null,{"$f":"CX_RR","v":{"$error":"#NAME?"}},null,null,{"$f":"CY_W1","v":{"$error":"#NAME?"}},{"$nulls":3},{"$f":"CX_WW","v":{"$error":"#NAME?"}},{"$nulls":8},"Activity Independent",{"$nulls":4},{"$f":"IF(COUNTA(MainActivityType)>1,INDEX(MainActivityType,1),\"\")","v":""},null,{"$f":"IF(COUNTA(MainActivityType)>2,INDEX(MainActivityType,2),\"\")","v":""}]
[null,null,"*",{"$f":"D$26","v":2},{"$nulls":21},{"$f":"KERNLOCAL(\"RESPONSIBLE\",LocalValue)","v":""},null,"Year","Object","Activity Type","Objecttype","Object","Activity Type",null,"Quantity","Value","Quantity","Value",null,"Quantity","Value","Input",null,"Price","Quantity","Value","DK","Price","Quantity","Value","DisKey",null,"Quantity","Value","DK","V fix","V var","V fix","V var","V fix","V var",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Comment",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Comment"]
[null,null,"*",{"$f":"D$26","v":2}]
[null,null,{"$f":"IF(X29>0,C$26,)","v":"*"},2,"*",{"$nulls":10},"X",{"$nulls":7},"Statistical Key Figure"]
[null,null,0,2,{"$nulls":6},"KF",{"$nulls":77},""]
[null,null,0,2]
[null,null,"*",2,{"$nulls":19},"Activity Type"]
[null,null,0,2,{"$nulls":6},"AT",{"$nulls":77},""]
[null,null,0,2]
[null,null,"*",2,{"$nulls":19},"Cost Element"]
[null,null,0,2,{"$nulls":6},"CE"]
[null,null,0,2]
[null,null,"*",2,{"$nulls":19},"Activity Output"]
[null,null,0,2,{"$nulls":6},"AO"]
[null,null,0,2]
[null,null,"*",2,{"$nulls":19},"Activity Input (Partner Object)"]
[null,null,0,2,{"$nulls":6},"AI"]
[null,null,0,2]
[null,null,"*",2,{"$nulls":19},"Activity Input (Source Object)"]
[null,null,0,2,{"$nulls":6},"AS"]
[]
[]
[]
[]
[{"$nulls":99},"01","SHOWROW","SHOWROW","FREEZE"]
[{"$nulls":99},"SHOWCOLUMN",{"$nulls":26},"I","I","I",null,null,"IO","IO","IO","IO","IO",null,null,"IO","O","O",{"$nulls":6},"IO","I","I","I","I","I","I","I","I","I","I","I","I"]
[{"$nulls":99},"SHOWCOLUMN"]
[{"$nulls":99},"FREEZE",{"$nulls":32},"*"]
[{"$nulls":120},"Satellite01"]
[{"$nulls":120},"Standard","ROW",{"$nulls":4},"KEY"]
[{"$nulls":120},"WRITE",{"$nulls":5},"ZEILE","PROJECT","INV_CAT",null,null,"INV_TYPE","QUANTITY","PRICE","VALUE_INV","MONTH_INV","LIFE_TIME_M","DEP_VALUE","CE_INV","ORDER_INV","ACCOUNT","CHECK_INV",null,"ALLOCTYPE1","OBJTYPE1","ALLOCTYPE2","OBJTYPE2","DEP_REST","VALUE01","VALUE02","VALUE03","VALUE04","VALUE05","VALUE06","VALUE07","VALUE08","VALUE09","VALUE10","VALUE11","VALUE12"]
[{"$nulls":120},"READ",{"$nulls":5},"ZEILE","PROJECT","INV_CAT",null,null,"INV_TYPE","QUANTITY","PRICE","VALUE_INV","MONTH_INV","LIFE_TIME_M","DEP_VALUE","CE_INV","ORDER_INV","ACCOUNT","CHECK_INV",null,"ALLOCTYPE1","OBJTYPE1","ALLOCTYPE2","OBJTYPE2","DEP_REST","VALUE01","VALUE02","VALUE03","VALUE04","VALUE05","VALUE06","VALUE07","VALUE08","VALUE09","VALUE10","VALUE11","VALUE12"]
[]
[{"$nulls":123},"Formula01"]
[{"$nulls":124},"ROW"]
[{"$nulls":123},"FORMULA",null,null,{"$f":"SUM(DW60,1)","v":1},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"IFERROR(Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]],)","v":0},null,{"$f":"IFERROR(IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"IFERROR((Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1,)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0),)","v":0},{"$f":"IFERROR(INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]]),)","v":0},{"$f":"IFERROR(INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]]),)","v":0},{"$f":"IFERROR(INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]]),)","v":0},{"$f":"IFERROR(INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]]),)","v":0},{"$f":"IFERROR(SUM(Invest[[#This Row],[1]:[12]]),)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0},{"$f":"IFERROR(\n(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)\n*Invest[[#This Row],[Month]:[Month]],)","v":0}]
[]
[]
[{"$nulls":100},1,{"$nulls":3},"InvestCategory",null,null,"InvestAsset",{"$nulls":4},"InvestControl",{"$nulls":13},"01","Investition",{"$nulls":7},"Depreciation",null,null,"Posting",null,null,"Check",null,"Allocation",{"$nulls":3},"Depreciation"]
[{"$nulls":100},1,{"$nulls":3},"Description","CostElement",null,"Category","AssetClass","UsefulLife","UsefulMonth",null,"AssetClass","Value","Boole","ALT1","ROT1","ALT2","ROT2",null,null,"X",null,null,"X",null,"Row","Description","Category","First","Last","Asset Class","Quantity","Price","Value","InflowMonth","UsefulMonth","Month","CostElement","Order","BalanceAccount","Boole","BooleX","ALT1","ROT1","ALT2","ROT2","Year","1","2","3","4","5","6","7","8","9","10","11","12"]
[{"$nulls":100},1,null,"*",null,"Buildings",481000,null,"Buildings","Admin building",20,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":240},null,1,1,{"$f":"InvestControl[[#This Row],[AssetClass]]&InvestControl[[#This Row],[Value]]","v":"11"},"PC","KS","AC","OR",{"$nulls":7},{"$f":"SUM(DW65,1)","v":{"v":1,"d":"1.0"}},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":3},"Intangible assets",483000,null,"Buildings","Production hall",20,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":240},null,1,0,{"$f":"InvestControl[[#This Row],[AssetClass]]&InvestControl[[#This Row],[Value]]","v":"10"},"NN","NN","NN","NN",{"$nulls":7},{"v":2,"d":"2.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":3},"Plant and office equipment",481100,null,"Buildings","Parking lots",12,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":144},null,0,1,{"$f":"InvestControl[[#This Row],[AssetClass]]&InvestControl[[#This Row],[Value]]","v":"01"},"NN","NN","NN","NN",{"$nulls":7},{"v":3,"d":"3.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":3},"Technical installations",482000,null,"Intangible assets","IT software",3,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":36},null,0,0,{"$f":"InvestControl[[#This Row],[AssetClass]]&InvestControl[[#This Row],[Value]]","v":"00"},"NN","NN","NN","NN",{"$nulls":7},{"v":4,"d":"4.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Intangible assets","Development & production procedures",20,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":240},{"$nulls":15},{"v":5,"d":"5.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Intangible assets","Licences and patents",15,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":180},{"$nulls":15},{"v":6,"d":"6.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Plant and office equipment","Fleet of cars & trucks",5,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":60},{"$nulls":15},{"v":7,"d":"7.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Plant and office equipment","Furniture",3,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":36},{"$nulls":15},{"v":8,"d":"8.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Plant and office equipment","Hardware",4,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":48},{"$nulls":15},{"v":9,"d":"9.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Technical installations","Machinery",5,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":60},{"$nulls":15},{"v":10,"d":"10.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Technical installations","Operating facilities",8,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":96},{"$nulls":15},{"v":11,"d":"11.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Technical installations","Conveying equipment",8,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":96},{"$nulls":15},{"v":12,"d":"12.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":6},"Technical installations","Moulds",3,{"$f":"InvestAsset[[#This Row],[UsefulLife]]*12","v":36},{"$nulls":15},{"v":13,"d":"13.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":25},{"v":14,"d":"14.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]
[{"$nulls":100},1,{"$nulls":25},{"v":15,"d":"15.0"},null,null,{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category],0),)","v":0},{"$f":"IFERROR(MATCH(Invest[[#This Row],[Category]],InvestAsset[Category]),)","v":0},{"$nulls":3},{"$f":"Invest[[#This Row],[Quantity]]*Invest[[#This Row],[Price]]","v":0},null,{"$f":"IF(Invest[[#This Row],[First]],INDEX(InvestAsset[UsefulMonth],Invest[[#This Row],[First]]),)","v":0},{"$f":"IFERROR(ROUND(Invest[[#This Row],[Value]]/Invest[[#This Row],[UsefulMonth]],),)","v":0},{"$f":"IFERROR(VLOOKUP(Invest[[#This Row],[Category]],InvestCategory[],2,0),)","v":0},null,null,{"$f":"(Invest[[#This Row],[First]]>0)*1&(Invest[[#This Row],[Value]]>0)*1","v":"00"},{"$f":"MATCH(Invest[[#This Row],[Boole]],InvestControl[Boole],0)","v":4},{"$f":"INDEX(InvestControl[ALT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT1],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ALT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"INDEX(InvestControl[ROT2],Invest[[#This Row],[BooleX]])","v":"NN"},{"$f":"SUM(Invest[[#This Row],[1]:[12]])","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[1]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[2]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[3]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[4]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[5]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[6]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[7]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[8]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[9]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[10]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[11]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0},{"$f":"(Invest[[#This Row],[InflowMonth]:[InflowMonth]]<=Invest[[#Headers],[12]]*1)*Invest[[#This Row],[Month]:[Month]]","v":0}]

{"sheet":"Micro","index":5,"n_rows":33,"n_cols":17,"rows_kept":33,"merged":[[5,16,7,16],[26,13,28,13]]}
[]
[null,"Strukturierte Tabellen",{"$nulls":8},"DE →",null,"ZÄHLENWENNS","Strg Return"]
[{"$nulls":10},"EN →",null,"COUNTIFS","Ctrl Return"]
[null,"User0",null,null,"User1"]
[null,"User",null,null,"User","CostElement",{"$nulls":6},"Parameter","User","CostElement","Result","Formulatext"]
[null,"Mueller",null,null,"Mueller",420000,{"$nulls":6},"User","Mueller",420000,{"$f":"COUNTIFS(\n  User1[User],User,\n  User1[CostElement],CostElement)","v":1},{"$f":"_xlfn.FORMULATEXT(P6)","v":"=COUNTIFS(\n  User1[User];User;\n  User1[CostElement];CostElement)"}]
[null,"Maier",null,null,"Mueller",430000,{"$nulls":8},440000,{"$f":"COUNTIFS(\n  User1[User],User,\n  User1[CostElement],CostElement)","v":0}]
[null,"Schmidt",null,null,"Maier",440000]
[{"$nulls":4},"Maier",450000]
[{"$nulls":4},"Schmidt",460000]
[{"$nulls":4},"Schmidt",478000]
[{"$nulls":4},"Schmidt",490000]
[{"$nulls":12},"TYP"]
[{"$nulls":12},"TYPE"]
[]
[{"$nulls":12},"Content","Value","Result","Formulatext"]
[{"$nulls":12},"Text","Salary",{"$f":"TYPE(N17)","v":2},{"$f":"_xlfn.FORMULATEXT(O17)","v":"=TYPE(N17)"}]
[{"$nulls":12},"Ziffer",420000,{"$f":"TYPE(N18)","v":1},{"$f":"_xlfn.FORMULATEXT(O18)","v":"=TYPE(N18)"}]
[]
[]
[]
[]
[{"$nulls":12},"WAHL"]
[{"$nulls":12},"CHOOSE"]
[]
[{"$nulls":12},"Formel","Formulatext"]
[{"$nulls":12},{"$f":"CHOOSE(O17,\n   Value1,\n   Value2)","v":"This is a text"},{"$f":"_xlfn.FORMULATEXT(M27)","v":"=CHOOSE(O17;\n   Value1;\n   Value2)"}]
[{"$nulls":12},{"$f":"CHOOSE(O18,\n   Value1,\n   Value2)","v":"Here is a number"}]
[]
[]
[{"$nulls":14},"Here is a number"]
[]
[{"$nulls":13},"This is a text"]

{"sheet":"Infos","index":6,"n_rows":54,"n_cols":57,"rows_kept":54,"hidden":true}
[null,"Global Information",{"$nulls":3},"Local Information"]
[]
[null,"Key","Value","Description",null,"Sheet","CONTROLLINGAREA","OBJECT","VERSION","PLANYEAR","SETCLASS","RESPONSIBLE","PERITO","TEXT","SYSID","DATE","ACTUALYEAR","TRANSACTION","LANGUAGE","LOGSYS","GROUP","PROFITCENTER","LSTARS","ADP","USER","LAYOUT","FROM","TO","OBJECTGROUP","PROJECT","STATUS","DESCRIPTION","AllevoVersion","COMPANYCODE","GROUPNAME","FCODE","REPRESENTATIVE","OBJECTTYPE","COSTCENTER","CUSTINFO1","CUSTINFO2","CUSTINFO3","CUSTINFO4","CUSTINFO5","CUSTINFO6","CUSTINFO7","CUSTINFO8","CUSTINFO9","CUSTINFO10","SHEETCOMMENT","ISOLANGUAGE","CURRCONTROLLINGAREA","CURROBJECT","TREEVIEW","CURRRATE","OfflineProcessing","OBJECT1"]
[null,"CONTROLLINGAREA"]
[null,"OBJECT"]
[null,"VERSION"]
[null,"PLANYEAR","2020","GLOBAL_PLANYEAR"]
[null,"SETCLASS"]
[null,"RESPONSIBLE"]
[null,"PERITO","8","GLOBAL_PERITO"]
[null,"TEXT"]
[null,"SYSID"]
[null,"DATE"]
[null,"ACTUALYEAR"]
[null,"TRANSACTION"]
[null,"LANGUAGE","EN","GLOBAL_LANGUAGE"]
[null,"LOGSYS"]
[null,"GROUP"]
[null,"PROFITCENTER"]
[null,"LSTARS"]
[null,"ADP"]
[null,"USER","Maier","GLOBAL_USER"]
[null,"LAYOUT","BDGT","GLOBAL_LAYOUT"]
[null,"FROM"]
[null,"TO"]
[null,"OBJECTGROUP"]
[null,"PROJECT"]
[null,"STATUS"]
[null,"DESCRIPTION"]
[null,"AllevoVersion"]
[null,"COMPANYCODE","1000","GLOBAL_COMPANYCODE"]
[null,"GROUPNAME"]
[null,"FCODE"]
[null,"REPRESENTATIVE"]
[null,"OBJECTTYPE"]
[null,"COSTCENTER"]
[null,"CUSTINFO1"]
[null,"CUSTINFO2"]
[null,"CUSTINFO3"]
[null,"CUSTINFO4"]
[null,"CUSTINFO5"]
[null,"CUSTINFO6"]
[null,"CUSTINFO7"]
[null,"CUSTINFO8"]
[null,"CUSTINFO9"]
[null,"CUSTINFO10"]
[null,"SHEETCOMMENT"]
[null,"ISOLANGUAGE"]
[null,"CURRCONTROLLINGAREA"]
[null,"CURROBJECT"]
[null,"TREEVIEW"]
[null,"CURRRATE"]
[null,"OfflineProcessing"]
[null,"OBJECT1"]

{"sheet":"Customizing","index":7,"n_rows":47,"n_cols":17,"rows_kept":47,"hidden":true}
[null,"Customizing",{"$nulls":6},"Colors",{"$nulls":5},"Placeholder"]
[]
[null,"Process","SubProcess","Parameter","Key","Description","Value",null,"#","R","G","B"," | ",null,"Usage","Placeholder","Relevance"]
[null,"UserExit","Macro","OPEN_IN_SAP",{"$nulls":4},"Navigation",0,80,150,"crnnav, Navigation: 0 | 80 | 150  #  200 | 230 | 255",null,"generell","<OPSYS>","Operating system according to requirements"]
[null,"UserExit","View","AFT_READ",null,null,"Main01",null,"Navigation",200,230,255,null,null,"generell","<INSTANCE>","Instance of the SAP System"]
[null,"UserExit","Macro","AFT_READ",{"$nulls":4},"Splasher",146,208,80,"crnspl, Splasher: 146 | 208 | 80  #  211 | 236 | 185",null,"generell","<SYSID>","Name of the SAP system"]
[null,"UserExit","View","WB_OPEN",{"$nulls":4},"Splasher",211,236,185,null,null,"generell","<DBSYS>","Database system"]
[null,"UserExit","Macro","WB_OPEN",{"$nulls":4},"Structure",255,210,100,"crnstr, Structure: 255 | 210 | 100  #  255 | 240 | 190",null,"generell","<SAPRL>","ERP Release"]
[null,"UserExit","Macro","AFT_LEAD_SAT",{"$nulls":4},"Structure",255,240,190,null,null,"generell","<HOST>","Computer name"]
[null,"UserExit","Macro","AFT_PLAN",{"$nulls":4},"Formula",190,225,150,"crnfor, Formula: 190 | 225 | 150  #  220 | 240 | 200",null,"generell","<CLIENT>","Client"]
[null,"UserExit","Macro","AFT_PLAN_S",{"$nulls":4},"Formula",220,240,200,null,null,"generell","<LANGUAGE>","Language in which the application was lodged, two digits"]
[null,"UserExit","Macro","AFT_READ_S",{"$nulls":4},"Style",210,185,235,"crnsty, Style: 210 | 185 | 235  #  235 | 225 | 245",null,"generell","<DATE>","Current date"]
[null,"UserExit","Macro","AFT_SHEET_GEN",{"$nulls":4},"Style",235,225,245,null,null,"generell","<YEAR>","Current calendar year, four digits (to be distinguished from <PLANYEAR>)"]
[null,"UserExit","Macro","AFT_SHEETS_GEN",{"$nulls":4},"Expand",255,120,60,"crnexp, Expand: 255 | 120 | 60  #  255 | 190 | 170",null,"generell","<SYEAR>","Current calendar year, two digits"]
[null,"UserExit","Macro","BEF_PLAN",{"$nulls":4},"Expand",255,190,170,null,null,"generell","<MONTH>","Current calendar month"]
[null,"UserExit","Macro","BEF_PLAN_S",{"$nulls":4},"Dialog",50,160,255,"crndia, Dialog: 50 | 160 | 255  #  220 | 240 | 255",null,"generell","<DAY>","Day"]
[null,"UserExit","Macro","BEF_READ",{"$nulls":4},"Dialog",220,240,255,null,null,"generell","<WEEKDAY>","Weekday"]
[null,"UserExit","Macro","BEF_READ_S",{"$nulls":4},"Satellite",140,200,255,"crnsat, Satellite: 140 | 200 | 255  #  190 | 225 | 255",null,"generell","<TIME>","Time"]
[null,"UserExit","Macro","BEF_SAVE",{"$nulls":4},"Satellite",190,225,255,null,null,"generell","<STIME>","Hour and minute"]
[null,"UserExit","Macro","MOD_TEMPLATE",{"$nulls":4},"Dynamics",80,140,240,"crndyn, Dynamics: 80 | 140 | 240  #  180 | 210 | 250",null,"generell","<HOUR>","hour"]
[null,"UserExit","Macro","WB_CLOSE",{"$nulls":4},"Dynamics",180,210,250,null,null,"generell","<MINUTE>","minute"]
[null,"Settings","Master adjustment after opening in SAP/Excel","Password",null,"No sheet and workbook protection if empty",null,null,"Custom",222,228,230,"crncus, Custom: 222 | 228 | 230  #  238 | 238 | 238",null,"generell","<SECOND>","Second"]
[null,"Settings","Master adjustment after opening in SAP/Excel","ShowCustomizing",null,"Show configuration and customizing sheets on Allevo startup",null,null,"Custom",238,238,238,null,null,"generell","<UNAME>","SAP user name"]
[null,"Settings","Master adjustment after opening in SAP/Excel","HideRibbon",null,"Hide Allevo ribbon",{"$nulls":8},"TimeSet","<YYYYY_VERSIONFR>","Version (from value)"]
[null,"Settings","Master adjustment after opening in SAP/Excel","HideFormBar",null,"Hide Form Bar",{"$nulls":8},"TimeSet","<YYYYY_VERSIONTO>","Version (to value)"]
[null,"Settings","Master adjustment after opening in SAP/Excel","LockShowAll",{"$nulls":10},"TimeSet","<YYYYY_PERIODFR>","Period (from value)"]
[null,"Settings","Settings for Multi and MultiObject","MOWO",null,"MO with assigned objects",{"$nulls":8},"TimeSet","<YYYYY_PERIODTO>","Period (to value)"]
[null,"Settings","Settings for Multi and MultiObject","NamingRule",null,"Naming rule for Multi Page",{"$nulls":8},"TimeSet","<YYYYY_YEARFR>","Year (from value)"]
[null,"Settings","Settings for Multi and MultiObject","CopyMultiSheet",null,"Protect digital signature when creating multi sheets",{"$nulls":8},"TimeSet","<YYYYY_YEARTO>","Year (to value)"]
[null,"Settings","Settings for Multi and MultiObject","FISH",null,"MO for ProfitCenter with fixed Sheets",{"$nulls":8},"Allevo","<KOKRS>","Controlling area"]
[null,"Settings","Settings for data format in Excel","FirstSheet",null,"Name of first sheet",{"$nulls":8},"Allevo","<OBART>","Object Type"]
[null,"Settings","Settings for data format in Excel","WriteTechnicalZero",null,"Delete-Option: Set Zero for definend Formats/Styles instead deleting ",{"$nulls":8},"Allevo","<LAYOUT>","Allevo Layout"]
[null,"Settings","Select a shortcut key","PickListKey",null,"Select a shortcut key","{F4}",{"$nulls":7},"Allevo","<OBJECT>","Object number in internal SAP representation (for example, with leading zeros)"]
[{"$nulls":14},"Allevo","<OBJECT_EXT>","Object number in external display"]
[{"$nulls":14},"Allevo","<PLANYEAR>","Plan year (from TimeSet, which works as a planning basis, for example CX_WW)"]
[{"$nulls":14},"Allevo","<VERSN>","Version (equivalent to <PLANYEAR>)."]
[{"$nulls":14},"Allevo","<BUKRS>","Company code assigned to the current object. In special application cases, it can happen that no object is available, such as when called up via a group in offline planning: in this case, Allevo uses the representative SAP object that is stored in the group properties in SAP reporting (see notes in Section 7.6.6 for 1:n groups)."]
[{"$nulls":14},"Allevo","<MAINGROUP>","Main group in the offline module that was entered in the initial screen of the offline transaction (if individual objects or From/To are selected, the entry is empty here).\nThe content is only available for export/import of a file, but not when determining the symbol Name for the Allevo-Master."]
[{"$nulls":14},"Allevo","<SUBGROUP>","Subgroup in the offline module: this is the group that is transferred from the execution mode (2) of offline transactions to the plan transaction. It results from the level selected to break down the main group."]
[{"$nulls":14},"Allevo","<OBJGROUP>","Group of the standard hierarchy that is entered in the master record of an object; for example, for a cost center If necessary, the determination is also time-dependent on the basis of the time period stored in the timeset that is used as the planning basis, such as CX_WW. Available for object types KS, PC, BP and also KX.\nUse case: depending on this assignment, offline files should be stored uniformly in a common subdirectory (of course, this only makes sense if the offline transaction is called in execution type 1)."]
[{"$nulls":14},"Allevo","<SUBFILE>","Only used when accessing the Allevo F1 Help: The placeholder is replaced at runtime by the name of a previously selected fixed value. Allevo then refers directly to the respective chapter in the help file."]
[{"$nulls":14},"Allevo","<FILESERVER>","This placeholder is filled at runtime with the contents of the user parameter /KERN/IPP_FILESERVER: The parameter was initially intended to create user-specific file names: however, it can be any text that is stored in the symbol file name or path (not necessarily just the name of a server)."]
[{"$nulls":14},"Allevo","<OFFL>","Flag for offline mode with the following contents:\n\"0\" if Allevo is called in dialog - This placeholder is useful e.g. if a different master is to be used depending on the call via an offline transaction.\n\"1\" if Allevo functions are called via offline transaction (e.g. /ALLEVO/OFFL_GEN)."]
[{"$nulls":14},"additional","<KOKRS(2)>","Returns the first two characters of the respective parameter: for controlling area ABCD, only AB appears in the file name."]
[{"$nulls":14},"additional","<KOKRS+1>","A parameter is transferred without the first character: controlling area ABCD becomes BCD in this case."]
[{"$nulls":14},"additional","<KOKRS+1(2)>","This combination is also possible: Controlling area ABCD is now BC."]
[{"$nulls":14},"additional","<SUBGROUP>!","The content of a placeholder is not replaced by assigned strings as described in Section 22.6.6. Instead, the current content (here e.g. the abbreviation of a group) is retained and used for further determination of a name or path.\nUse case: in the course of offline planning, files should be stored in specific directories depending on cost center groups, which are defined via character strings for <SUBGROUP>. At the same time, the abbreviation of the cost center group should also appear in the name of the created files: <SUBGROUP>! should be provided there (cost center group \"H1010\" appears with the abbreviation \"H1010\" in the name of the file)."]