-----------------------------------------------------------
WP4 Meta-Analysis for CES: Guide to excel formulas:
- Last change: 23/03/23
- Changes: Clarifying process
- Data: Data_StepZero.csv
- Notes:
So, starting from StepZero this is how we added the extra columns.

-----------------------------------------------------------

Column: 2020_value_local_currency
Formula: = (Amount) * (CPI_2019 / CPI_historic)

Column: estimate_USD_2020
Formula: =2020_value_local_currency / PPP_conversion_factor_for_2019

Column: Variation_1_CPI_2020_value_local_currency
Formula: =(Variation) * (CPI_2019 / CPI_historic)

Column: variation_2_CPI_USD_2021
Formula: =(Variation 2) * (CPI_2019 / CPI_historic)

Column: variation_2_CPI_USD_2021
Formula: =(Variation 2) * (CPI_2019 / CPI_historic)

Column: PPP_variation_1
Formula: =Variation_1_CPI_2020_value_local_currency/ PPP_conversion_factor_for_2019

Column: PPP_variation_2
Formula: =variation_2_CPI_USD_2021/ PPP_conversion_factor_for_2019

Column: CI SD conversion
Formula: =IFERROR(SQRT(SampleSize) * (PPP_variation_2-PPP_variation_1) / (T.INV.2T(0.05, SampleSize-1)*2),"")