Spreadsheet: 696897d1601028665-if-date-is-within-1st-10-days-of-month-apply-1-x-percentage-otherwise-apply-1-y-custom-pro-rata-uplift-sample
Sheet: Adjustment Assumption

 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00
AU | 0 | -0.05555555555555555 | -0.1176470588235294 | -0.2222222222222222 | -0.02857142857142857 | 0.001969935497180419 | -0.1667128958673176 | 0.00138960467967039 | -0.05370504798243171 | 0.0338706010638179 | -0.0252571377632725 | -0.04206516880735253 | 0.1197761490005992 | 0.07862561639073005 | 0.139759659984038 | 0.108605862093722 | 0.06610994477151595 | 0.1654683574060637 | 0.06065944284890391 | 0.002674809919808381 | 0.02874897309183802 | 0.005387027050900176 | 0.01353837880200209
AT | -0.02222222222222222 | 0.01515151515151515 | 0 | -0.1417910447761194 | -0.06956521739130435 | -0.09345794392523364 | 0.1752577319587629 | -0.04385964912280702 | 0.0749363023275553 | 0.01692231872579049 | 0.02550669706610676 | -0.02337820644735322 | -0.05497827040195483 | 0.0141964417117719 | 0.0652306119207972 | 0.01617064709445866 | 0.02151481834166369 | -0.04420678192406505 | 0.004894011035916813 | 0.01442402170044736 | 0.1022114079088831 | 0.002235913731096949 | 0.02332711157200117
BE | -0.0688836104513064 | -0.01020408163265306 | -0.02061855670103093 | -0.05263157894736842 | 0.01111111111111111 | 0.01649318056008977 | -0.02199454631817132 | 0.0315531334548571 | -0.04341235931470989 | 0.008512276738338594 | -0.001494672672099089 | -0.03521624618419986 | -0.07211745193149402 | 0.01054545788384031 | 0.02164059352909999 | 0.02047277061927931 | 0.04351628207922174 | -0.01814332491963887 | 0.0337309883706098 | -0.004384316049548383 | 0.03396702299332251 | 0.03058708507660364 | 0.02027093124575829
AE | -0.146551724137931 | 0.01515151515151515 | -0.08955223880597014 | 0.1420765027322404 | -0.1339712918660287 | -0.3093922651933702 | -0.032 | 0.04132231404958678 | 0.1807307097547442 | 0.01038290944609141 | -0.008935073094106176 | -0.01844827705662393 | -0.009681069223622638 | 0.05080842580325385 | -0.02320197467150178 | -0.01007743789302408 | -0.003858820182043371 | 0.04182199200563703 | 0.04265562975187092 | 0.02490462033965074 | 0.05290531644302156 | 0.05649404156163489 | -0.02308688477223463
FR | -0.02018842530282638 | -0.03708791208791209 | 0.005706134094151213 | -0.07943262411347518 | -0.05546995377503852 | 0.002521762730488957 | -0.04027933210333113 | -0.02054576240247976 | 0.02277801361940028 | 0.007781341553324955 | 0.005678293265177597 | -0.07428671832940183 | -0.04876989305566028 | -0.02606963311721558 | -0.03389045631561904 | 0.02604947077564382 | 0.03150018082134229 | -0.03720584153139665 | -0.0004332744715656035 | -0.006548904756005191 | 0.005935101269859288 | 0.02908791520974869 | 0.03126212697773653
DE | -0.08246563931695126 | 0.03858374943259192 | 0.01573426573426574 | -0.0774526678141136 | -0.05923507462686567 | 0.01293157488975561 | -0.03326251869403651 | 0.03364551466190129 | 0.02956014782638744 | 0.01047648099172244 | 0.04450352241254674 | -0.05690120213602423 | -0.06680739709002276 | 0.06681542865865783 | 0.01613508835584401 | -0.00221823662094084 | 0.04366694695475371 | 0.003002443965852266 | -0.004748125042931988 | 0.03620171041993938 | 0.01809522465158194 | 0.009980916563054904 | 0.04811590629599578
IE | 0.03658536585365853 | -0.09411764705882353 | -0.09090909090909091 | 0 | -0.02857142857142857 | -0.01470588235294118 | 0 | 0 | -0.1035170485281083 | -0.01602652597962909 | 0.006005565940163108 | -0.09714076013004007 | 0.03740759198386039 | 0.0001582815161461234 | -0.0226356744758851 | 0.07516816729867112 | 0.03121793238953269 | 0.05440838342447829 | 0.01468220156451315 | -0.002238917255810449 | 0.03437240845023699 | 0.07040300065102333 | 0.0943777009664298
JP | 0 | 0.125 | -0.1111111111111111 | 0 | 0 | -0.07326007326007322 | 0.1682037768994291 | 0.09868421052631564 | -0.2548725552518953 | 0.09115257843719697 | -0.03653347605315823 | -0.04415290554753072 | -0.01324916653389878 | -0.1135194088525501 | -0.04226047836307372 | -0.08409694285914715 | -0.07099676863935071 | 0.01834318499533773 | 0.01205455433149234 | -0.05835086593918853 | -0.01659792757142706 | 0.01254425950134225 | -0.01787321557539973
LU | 0.02 | -0.196078431372549 | -0.1463414634146341 | -0.3142857142857143 | -0.125 | 0.1273911273911275 | -0.06643429187933118 | 0.01900020742584529 | -0.1357808571189808 | 0.0398504006969596 | 0.1022951773434275 | -0.0651402985349503 | -0.08267490578570286 | -0.1136797933421252 | -0.119427138314135 | -0.06351653379941861 | 0.01115604689852038 | 0.02087833361118284 | 0.06546437979913457 | 0.03463823570726245 | -0.04722718361760994 | 0.05292933158141182 | 0.1113106199496501
NL | -0.07206142941523921 | -0.01718650541056652 | -0.001295336787564767 | -0.06809338521400778 | -0.04314544189283229 | -0.004320450845349114 | -0.03610734032474895 | 0.01628137605327613 | -0.03001262439068426 | 0.0008451764800263251 | 0.01441803308858012 | -0.05270814864075377 | -0.05277083520366402 | 0.000573245065424832 | 0.02593571941888639 | 0.02903226527364069 | 0.007304744448933786 | 0.01700667558976106 | 0.01477519768147785 | 0.01720777246569227 | 0.03969537776337554 | 0.01228997205810269 | 0.02013884418559388
SG | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | -0.0009706853038244295 | -0.02644872853420725 | 0.0631542567347073 | 0.02629896945292287 | 0.001936499644493055 | -0.02789656139494601 | 0.01732994834469265 | 0.05082928559322966 | 0.02762820845235848 | 0.07332461055868722 | 0.05034422338202739 | 0.04113208226535126 | 0.04404418366307435 | 0.0003553659648476053 | 0.01825630545321867 | 0.007468623332647563
ES | -0.02040816326530612 | 0.08333333333333333 | 0.1538461538461539 | -0.06666666666666667 | -0.03571428571428571 | 0.06756453423120103 | -0.01923885618166527 | 0.01478067197865677 | -0.04576536886970423 | -0.005925572950231336 | -0.01053777678053707 | -0.06438765252951272 | -0.06207835890405996 | 0.1207438660652329 | 0.1561613922313831 | 0.08088460283902732 | -0.01750369208261943 | 0.02318707125417723 | -0.06840327143773163 | 0.0753672444496742 | 0.03344836699834001 | 0.07068379899881756 | 0.03035500534773044
CH | 0 | 0 | 0.03448275862068965 | 0 | 0.1 | -0.1086949855435746 | 0.06807804453821574 | 0.06296707819839344 | -0.03970756181953887 | 0.03322853998654295 | 0.04885552437442368 | -0.08329859584161071 | 0.02690215897375936 | 0.0448175668784277 | 0.008811990125584042 | -0.01205389889195476 | -0.008127754058902592 | 0.01725495983886319 | 0.06562213903029165 | 0.03491573991604597 | 0.02597672013427703 | 0.009963182377020893 | 0.02361740335242213
UK | 0.01140873015873016 | -0.01520353114271702 | -0.075199203187251 | -0.139472267097469 | -0.05882352941176471 | -0.00393787555851892 | 0.005351001767460698 | -0.003341272382705339 | -0.01964500811024548 | 0.005532907051384772 | 0.01875218442473166 | -0.0929386909746368 | 0.02437562612843932 | 0.02446324916849013 | -0.03136525651351491 | 0.01572964330125787 | 0.04499486519045109 | 0.02747141532695949 | 0.03072170506953188 | 0.0472863226149181 | 0.03085261214376851 | 0.0343568883931296 | 0.04371293548616017
US | -0.02870813397129187 | -0.009852216748768473 | 0 | -0.04975124378109453 | -0.0418848167539267 | 0.03647689258972787 | 0.03653557194047978 | 0.06917349690418303 | 0.000969721527996021 | 0.01553526065481367 | -0.005358980250471585 | -0.02073397276687629 | -0.005397384143365105 | 0.00848437949514236 | 0.01225827550707012 | 0.01809251337912242 | 0.01806220753699867 | 0.02185431607537601 | 0.01794808692842969 | 0.01806860929767673 | 0.01209817073511866 | 0.0108993992540828 | 0.00172853758922682
HK | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | -0.0009706853038244295 | -0.02644872853420725 | 0.0631542567347073 | 0.02629896945292287 | 0.001936499644493055 | -0.02789656139494601 | 0.01732994834469265 | 0.05082928559322966 | 0.02762820845235848 | 0.07332461055868722 | 0.05034422338202739 | 0.04113208226535126 | 0.04404418366307435 | 0.0003553659648476053 | 0.01825630545321867 | 0.007468623332647563
MY | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | -0.0009706853038244295 | -0.02644872853420725 | 0.0631542567347073 | 0.02629896945292287 | 0.001936499644493055 | -0.02789656139494601 | 0.01732994834469265 | 0.05082928559322966 | 0.02762820845235848 | 0.07332461055868722 | 0.05034422338202739 | 0.04113208226535126 | 0.04404418366307435 | 0.0003553659648476053 | 0.01825630545321867 | 0.007468623332647563
CA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0