Spreadsheet: 752306d1634708085-conversion-of-formula-to-a-simpler-one-xxx
Sheet: Step2

Step 2: Volume indices from previous year=100
ISIC2d | ISIC4d | Variable | Measure | Price Index | Q1 2017 | Q2 2017 | Q3 2017 | Q4 2017 | 2017 | Q1 2018 | Q2 2018 | Q3 2018 | Q4 2018 | 2018 | Q1 2019 | Q2 2019 | Q3 2019 | Q4 2019 | 2019
41 | 4100 |  |  |  |  |  |  |  |  | 103.9117981845692 | 105.3290397366334 | 103.3304015733651 | 110.764688095766 | 105.8339818975834 | 91.74708486988287 | 99.5820217076876 | 113.8495304128018 | 114.4502583349249 | 104.9072238313243
42 | 4210 |  |  |  |  |  |  |  |  | 107.4937593594294 | 96.24211931895856 | 150.6334238439909 | 147.68102071915 | 125.5125808103822 | 110.6730602008997 | 69.35369538379548 | 73.5500075555305 | 52.77059670676201 | 76.5868399617469
42 | 4220 |  |  |  |  |  |  |  |  | 90.50951497053478 | 118.6500086305888 | 97.12494523463965 | 90.87637147425076 | 99.29021007750349 | 158.0539807950555 | 148.0719686472046 | 153.3117166557393 | 149.3404861826339 | 152.1945380701584
42 | 4290 |  |  |  |  |  |  |  |  | 89.97023667021028 | 117.1701901203173 | 91.8402757987154 | 132.7328871603236 | 107.9283974373916 | 81.78946010547253 | 70.35385178802672 | 73.05739115883064 | 93.8250195016332 | 79.75643063849077
43 | 4321 |  |  |  |  |  |  |  |  | 77.50179481349782 | 78.66235366484979 | 93.45038032843497 | 111.5245415590154 | 90.28476759144951 | 103.0218866633203 | 140.7499642117474 | 220.64537515451 | 270.3943938861535 | 183.7029049789328
43 | 4322 |  |  |  |  |  |  |  |  | 120.2025548047085 | 107.4639316131959 | 107.0269553335428 | 87.15125360351286 | 105.46117383874 | 79.39200892985723 | 87.24954459044632 | 125.811113187157 | 136.2809822954866 | 107.1834122507368
43 | 4329 |  |  |  |  |  |  |  |  | 80.785745344487 | 82.61880390590424 | 107.2236187233772 | 128.2239278902834 | 99.71302396601297 | 79.46827780677532 | 100.7919037844395 | 90.84926054673123 | 117.7042940796428 | 97.20343405439722
43 | 4330 |  |  |  |  |  |  |  |  | 53.75722713810362 | 76.91470635112479 | 101.4163719276297 | 41.97869287926119 | 68.51674957402982 | 100.6701927400937 | 77.9403372430555 | 66.43483820155707 | 53.23578067593178 | 74.57028721515951
43 | 4391 |  |  |  |  |  |  |  |  | 124.7994804589993 | 115.1098198575093 | 72.163369944533 | 80.24825030770427 | 98.08023014218647 | 125.4995731682567 | 84.13990395212171 | 50.83219609210372 | 83.24040515304833 | 85.92801959138262
44 | 4511 |  |  |  |  |  |  |  |  | 98.1050357157985 | 83.64273722589434 | 76.41605775627433 | 92.75626175985218 | 87.73002311445484 | 86.24860190723366 | 71.14164921525814 | 73.18339259465938 | 85.97025424024416 | 79.13597448934884
45 | 4512 |  |  |  |  |  |  |  |  | 83.17760808207402 | 108.4643483672634 | 97.48912869789854 | 107.9466072423362 | 99.26942309739303 | 112.4293354398221 | 109.5583134222921 | 101.9199594934189 | 121.0416825695702 | 111.2373227312758
45 | 4521 |  |  |  |  |  |  |  |  | 115.7168518332134 | 127.7643120412238 | 95.89714004994194 | 133.5522041853453 | 118.2326270274311 | 98.6247947346681 | 104.2791258845225 | 80.14985331937159 | 111.5397698973669 | 98.64838595898226
45 | 4529 |  |  |  |  |  |  |  |  | 101.4985597238814 | 80.58413508568734 | 81.69905897127951 | 99.56604603321395 | 90.83694995351554 | 88.56282874144847 | 71.72336377649458 | 74.73232376986073 | 103.5858811381072 | 84.65109935647773
45 | 4531 |  |  |  |  |  |  |  |  | 146.030317280365 | 140.989988127459 | 142.570589632637 | 138.976052059782 | 142.1417367750608 | 93.88813365585021 | 87.20170811531538 | 91.24930074072026 | 88.85720879385656 | 90.2990878264356
46 | 4610 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
46 | 4620 |  |  |  |  |  |  |  |  | 97.64883003031927 | 123.2808303769894 | 90.59956187153647 | 95.12660490682563 | 101.6639567964177 | 103.783666054542 | 123.5255971698915 | 88.54005062474248 | 99.35814430005993 | 103.801864537309
46 | 4632 |  |  |  |  |  |  |  |  | 91.31046544449013 | 91.06727162654268 | 85.46718743134966 | 102.7917129268292 | 92.65915935730294 | 95.19369639892004 | 91.5546561031 | 98.16763239854947 | 112.6012176644894 | 99.37930064126473
46 | 4641 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
46 | 4647 |  |  |  |  |  |  |  |  | 76.38340559731259 | 101.3345399209229 | 88.41958891043127 | 89.92769664571244 | 89.0163077685948 | 79.77826130905068 | 130.6473437190388 | 123.9377605634458 | 133.4448197704773 | 116.9520463405031
46 | 4648 |  |  |  |  |  |  |  |  | 117.604433351935 | 126.4972411978968 | 85.4084505837201 | 116.3823208237555 | 111.4731114893268 | 96.49052317789348 | 114.901234114972 | 61.81882615820273 | 85.19625841788357 | 89.60171046723795
46 | 4659 |  |  |  |  |  |  |  |  | 93.39874668293754 | 112.3947077473544 | 112.6104146024679 | 147.6300885689442 | 116.508489400426 | 113.5122055468201 | 138.4484939837348 | 123.5821351936017 | 174.3295440438698 | 137.4680946920066
46 | 4663 |  |  |  |  |  |  |  |  | 97.02529581381289 | 115.4080382626739 | 91.76189880336476 | 87.51934801651615 | 97.92864522409192 | 96.35169330397709 | 117.0480526716969 | 94.39438144532134 | 101.6283198506033 | 102.3556118178996
46 | 4690 |  |  |  |  |  |  |  |  | 97.86409144692749 | 103.7681798880234 | 86.1764903556656 | 92.78807056147424 | 95.14920806302268 | 101.8130722082425 | 95.30920540831 | 92.34401821282421 | 102.2558871706082 | 97.93054574999623
46 | 4691 |  |  |  |  |  |  |  |  | 86.40218404601659 | 90.50920657905237 | 85.69945784600701 | 91.45786705677051 | 88.51717888196161 | 69.84237935296603 | 118.5880578887434 | 69.4027353365125 | 77.51985383541043 | 83.83825660340808
46 | 4692 |  |  |  |  |  |  |  |  | 96.28081369298795 | 95.40614127073155 | 81.11208078571418 | 109.2074491166851 | 95.50162121652971 | 107.2171796595837 | 108.1585126101608 | 92.02380623639847 | 143.3953980759275 | 112.6987241455176
47 | 4712 |  |  |  |  |  |  |  |  | 97.6508970408133 | 109.8418524224892 | 94.77188084218653 | 100.3154020178251 | 100.6450080808285 | 99.02573293033437 | 104.9027289054926 | 90.65004726063873 | 97.05767940919175 | 97.90904712641436
47 | 4719 |  |  |  |  |  |  |  |  | 96.38555902308983 | 98.10611860480837 | 83.57762371444676 | 111.7776647422812 | 97.46174152115655 | 98.15878574717446 | 104.3625633716945 | 82.77922221053717 | 110.3360530090142 | 98.90915608460506
47 | 4730 |  |  |  |  |  |  |  |  | 113.8260447256969 | 127.7161887854833 | 137.015341518382 | 137.1682629071771 | 128.9314594841848 | 88.04717743179454 | 98.94516056218146 | 98.0062268496768 | 97.83707303848914 | 95.70890947053547
47 | 4741 |  |  |  |  |  |  |  |  | 95.52769111670551 | 100.7269416545021 | 91.03093000400952 | 78.48301665054623 | 91.44214485644083 | 83.5761581774251 | 63.35556010004129 | 70.82017400647716 | 77.9183539159523 | 73.91756154997395
47 | 4751 |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
47 | 4752 |  |  |  |  |  |  |  |  | 98.54580774047628 | 90.43700895630077 | 81.41992442665148 | 95.3138973563668 | 91.42915961994883 | 112.7510213717326 | 96.52369023525313 | 89.9866032247458 | 99.05364262668016 | 99.57873936460292
47 | 4755 |  |  |  |  |  |  |  |  | 76.06438978147841 | 85.19081453417905 | 66.44391564153179 | 57.38432965238098 | 71.27086240239257 | 101.3989503822528 | 101.5574996193555 | 98.15305928299432 | 102.285459490177 | 100.8487421936949
47 | 4763 |  |  |  |  |  |  |  |  | 76.53819565044803 | 111.1516849966994 | 101.066296613049 | 103.1788104533604 | 97.98374692838922 | 97.9459900183281 | 91.90284855615745 | 114.7479533139328 | 123.4254731004466 | 107.0055662472162
47 | 4771 |  |  |  |  |  |  |  |  | 86.70062596678957 | 95.97306076257422 | 93.87797907554676 | 74.86032045849478 | 87.85299656585133 | 108.8459025447666 | 136.5118007171497 | 125.2141671950798 | 99.77529645873464 | 117.5867917289327
47 | 4772 |  |  |  |  |  |  |  |  | 98.3988608356334 | 93.99335932377443 | 89.92651615729993 | 130.8828111815123 | 103.300386874555 | 80.63644788232257 | 93.12093970963544 | 98.30124070262883 | 133.8588251985571 | 101.479363373286
47 | 4775 |  |  |  |  |  |  |  |  | 107.1844690877556 | 84.37314670111216 | 85.94299536007044 | 66.5238436328992 | 86.00611369545935 | 99.86277429253653 | 92.49845724984873 | 71.89313705433943 | 103.3992732431548 | 91.91341045996988
47 | 4779 |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
47 | 4752 |  |  |  |  |  |  |  |  | 98.54580774047628 | 90.43700895630077 | 81.41992442665148 | 95.3138973563668 | 91.42915961994883 | 112.7510213717326 | 96.52369023525313 | 89.9866032247458 | 99.05364262668016 | 99.57873936460292
47 | 4772 |  |  |  |  |  |  |  |  | 98.3988608356334 | 93.99335932377443 | 89.92651615729993 | 130.8828111815123 | 103.300386874555 | 80.63644788232257 | 93.12093970963544 | 98.30124070262883 | 133.8588251985571 | 101.479363373286
49 | 4922 |  |  |  |  |  |  |  |  | 93.17835835569879 | 92.14856740941678 | 106.7737583254254 | 111.2927149900054 | 100.8483497701366 | 96.27116208246669 | 88.96951945182775 | 89.93124246780579 | 96.38397013334749 | 92.88897353386194
49 | 4923 |  |  |  |  |  |  |  |  | 93.74703308858636 | 92.41879222638082 | 79.46226750163397 | 83.62922763785902 | 87.31433011361506 | 94.92848708490106 | 89.0045953198142 | 86.8698248889485 | 95.43834243111314 | 91.56031243119422
49 | 4924 |  |  |  |  |  |  |  |  | 122.7393078451228 | 107.027010439584 | 72.20794308765488 | 120.0222392780291 | 105.4991251625977 | 123.600655234983 | 97.09962240132715 | 70.12168146176984 | 113.2145370160207 | 101.0091240285252
50 | 5010 |  |  |  |  |  |  |  |  | 95.49026595937222 | 95.13954680337181 | 93.44999096983236 | 100.7842215496389 | 96.21600632055382 | 96.48195248685549 | 94.6699573386023 | 98.09207500148452 | 108.3710160158088 | 99.40375021068778
51 | 5110 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52 | 5210 |  |  |  |  |  |  |  |  | 129.1347856825677 | 132.1087251421816 | 122.6267412015551 | 129.9047584442448 | 128.4437526176373 | 109.0273176725359 | 110.2886379343883 | 113.7140632790157 | 109.8508204127023 | 110.7202098246606
52 | 5224 |  |  |  |  |  |  |  |  | 108.3319439117965 | 100.045804712453 | 102.5544232395279 | 109.6476955703945 | 105.144966858543 | 91.932269064755 | 125.734437942253 | 85.19639364738511 | 112.4435682409318 | 103.8266672238312
52 | 5229 |  |  |  |  |  |  |  |  | 99.65441871603842 | 103.1660568988771 | 145.0444171310372 | 154.8663723759044 | 125.6828162804643 | 97.07878131665524 | 117.6345604038108 | 153.8119601029757 | 156.9386838932432 | 131.3659964291712
56 | 5611 |  |  |  |  |  |  |  |  | 96.68636001824483 | 103.7827496619818 | 90.24312653414482 | 100.227427176059 | 97.7349158476076 | 103.7399693005557 | 95.08999194887218 | 85.45751716060384 | 100.2081405751778 | 96.12390474630237
56 | 5612 |  |  |  |  |  |  |  |  | 94.17234365396375 | 91.34632435017333 | 84.5130366782422 | 93.56194715069624 | 90.89841295826888 | 102.6423627852928 | 91.78121537035285 | 86.76413676702064 | 100.2956788418878 | 95.37084844113852
56 | 5613 |  |  |  |  |  |  |  |  | 101.5385410941817 | 98.56305157079747 | 100.8670339023755 | 106.5141490142478 | 101.8706938954006 | 104.2105504610647 | 100.8138508019135 | 102.7264483298566 | 109.8814166695879 | 104.4080665656057
56 | 5622 |  |  |  |  |  |  |  |  | 103.0733178024876 | 89.26133496697996 | 111.6240418420933 | 139.5371580852456 | 110.8739631742016 | 126.2728877465463 | 113.1686247715943 | 113.1035672599792 | 173.0582455692933 | 131.4008313368533
56 | 5623 |  |  |  |  |  |  |  |  | 97.8736001491813 | 105.3468884314627 | 36.63331676595672 | 126.2208494235835 | 91.51866369254607 | 97.54636762620453 | 97.92332315963844 | 78.39901216658427 | 103.053179781223 | 94.23047068341258
64 | 6420 |  |  |  |  |  |  |  |  | 101.3175397438787 | 87.25175501936151 | 81.4741168897128 | 92.1119936150662 | 90.53885131700483 | 98.31412200961576 | 81.87302536476334 | 73.15947648777791 | 88.26103291840465 | 85.4019141951404
64 | 6492 |  |  |  |  |  |  |  |  | 93.91037915989955 | 93.42531824400923 | 87.7058855438007 | 88.93059465783679 | 90.99304440138656 | 98.08791324895655 | 98.75548655659261 | 101.7560504001219 | 104.4804832055723 | 100.7699833528108
64 | 6499 |  |  |  |  |  |  |  |  | 103.8349920490906 | 106.5992258956926 | 105.9140755041246 | 96.93067750921543 | 103.3197427395308 | 161.559525542725 | 133.0331278532074 | 84.90261289045876 | 256.1833231264677 | 158.9196473532147
68 | 6810 |  |  |  |  |  |  |  |  | 487.4654777991187 | 497.2476372383969 | 483.9192458391913 | 517.0843440936519 | 496.4291762425896 | 101.2424702984628 | 108.1287144774047 | 103.6177127442881 | 109.6880763194798 | 105.6692434599089
69 | 6910 |  |  |  |  |  |  |  |  | 91.45639316423011 | 104.1488086142983 | 113.7158120268041 | 107.9175673566061 | 104.3096452904846 | 126.6969976278397 | 103.4417715069681 | 124.0506388401673 | 144.3592743039987 | 124.6371705697435
69 | 6920 |  |  |  |  |  |  |  |  | 32.92067483226837 | 28.22333450524944 | 24.23894950150896 | 26.6496703287684 | 112.0326291677952 | 30.21669933234372 | 27.64900730708305 | 25.68861801210437 | 27.19446527230155 | 110.7487899238327
70 | 7020 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
71 | 7110 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
71 | 7120 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
73 | 7310 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
77 | 7710 |  |  |  |  |  |  |  |  | 99.11720319414982 | 93.97415974310368 | 88.72189280634808 | 100.3098051272323 | 95.53076521770846 | 95.9029166318367 | 91.86416631432213 | 82.06386165121825 | 93.6426290740025 | 90.8683934178449
77 | 7730 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
78 | 7810 |  |  |  |  |  |  |  |  | 103.7072390438909 | 107.480809128223 | 99.19498099254398 | 105.2408365483311 | 103.9059664282472 | 100.3189136066441 | 102.1122849399454 | 104.4782490527045 | 105.5705733858046 | 103.1200052462746
79 | 7911 |  |  |  |  |  |  |  |  | 79.0212837777764 | 108.4259535823 | 86.10248511356228 | 89.95664048796527 | 90.87659074040099 | 86.97340908798556 | 146.7960259796404 | 70.43154675659828 | 74.15438030975521 | 94.58884053349486
79 | 7912 |  |  |  |  |  |  |  |  | 181.6957599731133 | 102.7734460384979 | 50.18742067810427 | 159.5404951952979 | 123.5492804712534 | 219.7161365118487 | 112.7343948154427 | 55.40672460188669 | 175.33859501488 | 140.7989627360145
80 | 8010 |  |  |  |  |  |  |  |  | 105.0553571616682 | 102.9906561746147 | 103.6859126294388 | 104.3601007068441 | 104.0230066681415 | 97.46830315550696 | 95.3700328107911 | 90.63879774780249 | 88.92534532344959 | 93.10061975938754
81 | 8100 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
85 | 8514 |  |  |  |  |  |  |  |  | 99.9567608937656 | 96.08603945661208 | 87.69606893881858 | 94.22307844263925 | 94.49048693295887 | 99.91439181262733 | 94.00609066932057 | 92.27533494582734 | 96.85642356249731 | 95.76306024756815
85 | 8530 |  |  |  |  |  |  |  |  | 127.7791468705725 | 80.28301322839353 | 115.1110774700229 | 70.0827854367145 | 98.31400575142587 | 134.7760155159743 | 74.87277222572567 | 127.3850137184731 | 81.7341247490895 | 104.6919815523156
85 | 8544 |  |  |  |  |  |  |  |  | 100.3936861371161 | 91.3632081892267 | 89.21498953895075 | 88.79789586392184 | 92.44244493230383 | 92.19988038767939 | 80.77509343831932 | 85.58049702851666 | 92.68121619719273 | 87.80917176292702
85 | 8548 |  |  |  |  |  |  |  |  | 128.1169511931263 | 84.94470810327509 | 87.40168145546926 | 103.1073889501692 | 100.89268242551 | 95.62587003335472 | 73.04881504653031 | 72.81074524492263 | 86.72346890148607 | 82.05222480657342
86 | 8610 |  |  |  |  |  |  |  |  | 105.3559741551492 | 97.14444722007165 | 89.76523230203021 | 101.8750805298997 | 98.53518355178768 | 104.8093940087807 | 97.02361846033084 | 89.26482607992196 | 109.5674667155668 | 100.1663263161501
86 | 8621 |  |  |  |  |  |  |  |  | 103.485904182816 | 85.89172252746894 | 84.07604302124447 | 93.27622103664119 | 91.68247269204264 | 96.07017788955491 | 100.4714920491395 | 90.71499677039877 | 98.70071302365697 | 96.48934493318754
86 | 8622 |  |  |  |  |  |  |  |  | 79.4330500845747 | 99.90869783259852 | 80.02609085541795 | 86.7811585212005 | 86.53724932344792 | 102.7157985401171 | 104.0478311555387 | 97.82335832674801 | 105.6105782443808 | 102.5493915666961
86 | 8623 |  |  |  |  |  |  |  |  | 104.9342366305025 | 109.6854137169057 | 94.34916585340844 | 113.7450855192332 | 105.6784754300124 | 106.2353329249853 | 110.0063348098122 | 94.27497669459439 | 105.5844699647868 | 104.0252785985446
86 | 8690 |  |  |  |  |  |  |  |  | 86.90669027119726 | 81.05291874357088 | 84.21556913366639 | 75.20400672914039 | 81.84479621939374 | 86.09075931466174 | 80.44550380103787 | 96.76101179475341 | 90.70973290161632 | 88.50175195301735
91 | 9103 |  |  |  |  |  |  |  |  | 149.183172048484 | 95.76019245879004 | 112.5079940128585 | 217.0792766857649 | 143.6326588014743 | 190.5790038540437 | 168.065729696087 | 85.89969336256816 | 143.1001678921801 | 146.9111487012197
93 | 9312 |  |  |  |  |  |  |  |  | 88.34067098416497 | 83.80465732305838 | 85.94519210276913 | 99.56217781089568 | 89.41317455522204 | 105.4647832447999 | 92.2827619078628 | 122.6729606663643 | 130.33710380021 | 112.6894024048093
93 | 9321 |  |  |  |  |  |  |  |  | 82.6203816550938 | 87.90082579625278 | 116.6313555602285 | 70.50668642742373 | 89.41481235974969 | 81.54502857722562 | 98.88548346653955 | 98.18097651237207 | 80.44151614984281 | 89.763251176495
93 | 9329 |  |  |  |  |  |  |  |  | 107.2742015419358 | 114.4377820439508 | 104.0073615753178 | 111.6572253397441 | 109.3441426252371 | 103.0749105181039 | 101.2716385232893 | 91.09375308432902 | 109.1806663559523 | 101.1552421204186
95 | 9500 |  |  |  |  |  |  |  |  | 69.25232105590689 | 91.92092721541611 | 97.55828352856287 | 103.9446988515318 | 90.6690576628544 | 108.9533677757243 | 96.08169823918938 | 137.7036802595258 | 149.3170003436285 | 123.013936654517
96 | 9602 |  |  |  |  |  |  |  |  | 113.8910774357325 | 105.2064367552864 | 92.8665606886315 | 99.66453969304939 | 102.9071536431749 | 101.3416476909953 | 99.24115770667206 | 89.9082887566498 | 99.86464250510011 | 97.58893416485432
96 | 9609 |  |  |  |  |  |  |  |  | 105.7451009080621 | 77.01409779604163 | 75.66520572377358 | 97.18209804981771 | 88.90162561942377 | 100.3334622930619 | 80.31857192651334 | 87.83242398517747 | 95.8364765888974 | 91.08023369841254
41
42
43
44
45
46
47
49
50
51
52
56
64
68
69
70
71
73
77
78
79
80
81
85
86
91
93
95
96