Appendix 2: Most used Excel features and formulas (original) (raw)

If you click on the cell AA28 in the worksheet 1_calc_hum_demand you see that the value of this cell is equal to the column "Pop_shift" of the table called "gdp_pop_hist" when the year is lower or equal to 2015 and to the column "pop_shift_2000" from the table GdpPopTarget when the year is higher than 2015:

=IF([@year]<=2015,SUMIF(gdp_pop_hist[YEAR],[@year],gdp_pop_hist[POP_shift]),SUMIFS(G dpPopTarget[POP_shift_2000],GdpPopTarget[SCEN],[@[POP_scen]],GdpPopTarget[YEAR],[@y ear]))

You can easily find the table called gdp_pop_hist if you do an advanced search in the whole workbook looking for gdp_pop_hist in values. You will be directed to the cell where the name_gdp_pop_hist_ appears which is at the top of the worksheet where the table is introduced, and above the table. Or you can go to the worksheet Index Tables and look for the table name in the first column. If you click on it, you will be also directed to the table.

The most used formulas in the FABLE Calculator are:

• IF - e.g. in the table called calc_hum_demand, in the column popshift (calc_hum_demand[popshift]).
• IFERROR - e.g. in calc_crops[PlantArea]
• AND - e.g. in calc_livestocknb[FinalExports]
• SUMIF - e.g. in calc_hum_demand[popshift])
• SUMIFS - e.g. in calc_hum_demand[popshift])
• VLOOKUP - e.g. in calc_crops[Crop_scen]
• OFFSET - e.g. in calc_land_cor[Initpasture]

We encourage users who are not yet familiar with these formulas to look at the help within Excel and explanations in several forums and online Excel tutorials.