Updating the Global Indicators

  1. Please go to GLOBAL SUMMARY Folder and find a data feed file.

Note

Data feed is a main source file used for updating the charts in the presentation

Note

Livelihoods > Livelihoods Monitoring Folder > GLOBAL SUMMARY> Livelihoods DATA feed

../_images/1_lhs.png

Note

Energy > Energy Monitoring Folder > GLOBAL SUMMARY> Energy DATA feed

../_images/1_energy.png

  1. Go to Link tab in data feed file and copy/paste the databridge file for the year you want to used

    ../_images/2_link.png

Warning

Only the countries with baseline and endline data are used to calculate the global indicators.

  1. Select Tools from the menu and click on Script Editor to open the Google Apps script.

    ../_images/3_open_gas.png

  2. Go to the NEW.gs file and select LINK function, then run it

../_images/4_link_run.png

Warning

Running the script could take more than 30 minutes

  1. After the script is finished, the charts in powerPoint need to be updated by clicking on Tools> Linked objects> Update All

../_images/5_update_ppt.png