Total Energy Access - Instructions on data input
This questionnaire is being produced to provide information information on people's access to energy around the wo
It is based upon the minimum standards for Total Energy Access, as defined by Practical Action in the Poor People's
Energy Outlook (PPEO) 2010, which can be seen below.
Energy service Minimum standard
1 Lighting 300 lm for a minimum of 4 hours per night at household level
1 kg woodfuel or 0.3 kg charcoal or 0.04 kg LPG or 0.2 litres of
kerosene or ethanol per person per day, taking less than 30
Minimum efficiency of improved solid fuel stoves to be 40%
Cooking and water greater than a three-stone fire in terms of fuel use
2
heating
Annual mean concentrations of particulate matter (PM2.5) < 10
µg/m3 in households, with interim goals of 15 µg/m3, 25 µg/m3
3
and 35 µg/m
3 Space heating Minimum daytime indoor air temperature of 18ºC
Households can extend life of perishable products by a
4 Cooling minimum of 50% over that allowed by ambient storage
0
Maximum apparent indoor air temperature of 30 C
People can communicate electronic information from their
Information and household
5
communications People can access electronic media relevant to their lives and
livelihoods in their household
If you want more information on Total Energy Access, like a printable .pdf version of the questionnaire,
you may find it here:
https://energypedia.info/index.php/Totalenergywiki
This is also where all the data is stored, computed and compared. After you upload it there, the fulfilled
minimum standards and so on will be calculated.
Now feel free to move on to the sheet "Instructions data" and fill in your gathered data.
on data input
n on people's access to energy around the world.
ned by Practical Action in the Poor People's
Criteria
L1=1 AND L2=1
"CW1=1 OR"
CW2=1 AND CW4=1
CW2=1
CW2=1 AND CW3=1
S1=1 OR S2=1
C1=1
C2=1 OR C3=1
IC1=1 OR IC3=1
IC2=1 OR IC3=1
df version of the questionnaire,
you upload it there, the fulfilled
r gathered data.
Total Energy Access - Instructions on data input
Excel form to upload data to the Total Energy Access Wiki (https://energypedia.info/index.php/Totalenergywiki)
This workbook produces a ready made Excel table from your Total Energy Access Data to upload it to the wiki.
After inserting your data, please mail the file to info@energypedia.info
Please follow the instructions carefully:
Preliminary instructions:
i) Only work and make changes in the sheet "Data input"
ii) Be aware that the wiki doesn't accept special characters like ";" "€" "&" "?",
furthermore all the umlaute ("ä" "ü" and so on) and letters with stresses ("á", "è" and so on)
iii) Be sure to type the correct data in each column
iv) Be sure to give data where it is mandatory
1) Each dataset has its own, unique name which is made up the following:
Country TE consecutive number, e.g. "Kenya TE 67"
It is very important not to have datasets with the same name, you would overwrite existing data in the wiki.
So, check where the current numbering starts für your specific country before working on your new dataset:
https://energypedia.info/index.php/TEA_ESI_Overview
2) Copy & Paste or type in your data in the sheet "Data input"
You should use the number codes as they are explained in the top rows
(they are automatically translated into text in the sheet "Output")
Otherwise, the row "Possible input" tells you were you have to type in a text or give a number, e.g. for the month.
Be sure to give data where ever it is mandatory and to avoid special characters
3) Check if your data is coherent with a look at the sheet "Output"
Here, different colors of the cells give you a hint what might be wrong with your data given
in the sheet "Data input":
The cell contains an error, most likely that means you gave a non existent number code
The cell contains no number where a number is expected
The cell contains an unplausible high or low value
The cell lacks a value though it is mandatory
The cell contains one of the not allowed special characters
4) If necessary, correct the wrong cells in the sheet "Data input"
5) Finally, send this file to info@energypedia.info
We will take care of it and upload it to the Total Energy Access Wiki as soon as possible
d it to the wiki.
g data in the wiki.
your new dataset:
ber, e.g. for the month.
Question
Possible input
Field mandatory?
Field name Name of household
Field name in wiki (property name) Not existent in Wiki!
Name of the dataset Text Text Text Text
Built from "Country TE consecutive
number", e.g. Kenya TE 65
ATTENTION: It is very important that each
dataset has its own unique number. To
start with the right number, also
doublecheck with the already uploaded
datasets in the wiki, otherwise you
overwrite them:
https://energypedia.info/index.php/TEA_E
SI_Overview
mandatory
Interviewee details
TEA/ESI Int Name TEA/ESI Int Organisation TEA ESI
TEA ESI Int Job title Int Email
Do you have a fixed or portable electric
Number Number Text Text Number:
0 = No
1 = Yes
mandatory
Age No. people in household L1
TEA/ESI HH AgeTEA/ESI HH no people city
TEA ESI HH communityTEA ESI HH country TEA L1
How use this light lights do than 4 hours per day?
Do you feel that the In what youWhat preventsmostly yourliquid or yourfuel Doelectricity for co
lighting have isDo you you changeneeds? gas lighting? or smoke h
you like to NO OR DON’T have or you
for use your lighting?
Do you
IF YES – Do youmany electric for more you have in your house? ways wouldadequateIF from changing KNOWa–chimneyhave an “im
Number: Number: Number: Text Text Number: Number: Number:
0 = No 0 = None 1 = Very adequate 0 = No/Don't 0 = No/Don't 0 = No
1 = Yes 1 = One or two 2 = OK – but would like a know know 1 = Yes
2 = Three or four bit more 1 = Yes 1 = Yes
3 = More than four 3 = Poor
4 = Very bad
mandatory mandatory
L2 L3 L4 L5 L6 CW1 CW2 CW3
TEA L2 TEA L3 TEA L4 TEA L5 TEA L6 TEA CW1 TEA CW2 TEA CW3
household spend less than of minutes a day collectingyou do you use this you use for cooking?
How many time? per year do times per day do you cook
months How many firewood?
What mainly
Does your What fuel do you use most 30 theHow many times per dayis the other fuel fuel? using another fuel?
Number: Number: Number: Number Number Number:
0 = No 1 = Wood 0 to 12 1 = Wood
1 = Yes 2 = Charcoal [months] 2 = Charcoal
3 = Dung/residues 3 = Dung/residues
4 = Biogas 4 = Biogas
5 = Kerosene 5 = Kerosene
6 = LPG 6 = LPG
7 = Electricity 7 = Electricity
8 = Ethanol 8 = Ethanol
9 = Coal 9 = Coal
10 = Other 10 = Other
mandatory
CW4 CW5 CW6 CW7 CW8 CW9
TEA CW4 TEA CW5 TEA CW9
TEA CW6 TEA CW7 TEA CW8
If use for more than one stove
Using the list below, describe the type of stove you you use most of your cooking.for cooking, using the list above describe the seco
Number: Text Number: Text
1 = Traditional (3-stone) fire 1 = Traditional (3-stone) fire
2 = Traditional tripod stove 2 = Traditional tripod stove
3 = Traditional metal charcoal stove 3 = Traditional metal charcoal stove
4 = Improved biomass chimney stove 4 = Improved biomass chimney stove
5 = Improved biomass stove without chimney 5 = Improved biomass stove without chimney
6 = Improved charcoal stove with ceramic liner 6 = Improved charcoal stove with ceramic liner
7 = Biomass stove with smoke hood 7 = Biomass stove with smoke hood
8 = Ethanol stove 8 = Ethanol stove
9 = Kerosene wick stove 9 = Kerosene wick stove
10 = LPG stove 10 = LPG stove
11 = Electric stove 11 = Electric stove
12 = Kerosene pressure stove 12 = Kerosene pressure stove
13 = None 13 = None
14 = Other (please describe) 14 = Other (please describe)
CW10 CW11
TEA CW10 TEA CW11
TEA CW10 description TEA CW11 description
How long does it take you to Do you yourthat the stoves in your household burnprevents which youin your like to
fuel? obtain feel fuel each month, atPlease describe anycleanly or facilities would househ
your income on about the year? cooking are polluting?
cooking fuel?
What
How do you obtain your main Do you spend more than 10% ofHow do you feelthis time ofsafety ofways in you from changing your c
Number: Number [minutes] Number: Number: Number: Text Text
1 = Gather 0 = No 1 = Very clean 1 = Very safe
2 = Purchase 1 = Yes 2 = OK – but would 2 = OK – but would
3 = Gather and like to improve like to improve
purchase 3 = Rather polluting 3 = Rather
4 = Produce at home 4 = Very polluting dangerous
5 = Don’t know 4 = Very dangerous
5 = Don’t know
CW12 CW13 CW14 CW15 CW16 CW17 CW18
TEA CW12 TEA CW13 TEA CW14 TEA CW15 TEA CW16 TEA CW17 TEA CW18
you do water If ‘other’, from cookinglist in CW10, more than one option).
hot water for in describe.
Using the activities?
How regularly doWhatheatyou useseparately please the house? (Can be describe the type of stove you use for most of your water he
Number: Number: Text Number:
1 = More than two 0 = Not used 1 = Traditional (3-stone) fire
times a day 1 = Hot drinks 2 = Traditional tripod stove
2 = One to two times 2 = Bathing 3 = Traditional metal charcoal stove
a day 3 = Washing clothes 4 = Improved biomass chimney stove
3 = Less than once a 4 = Cleaning house 5 = Improved biomass stove without chimney
day and kitchenware 6 = Improved charcoal stove with ceramic liner
4 = Never 5 = Other (please 7 = Biomass stove with smoke hood
state) 8 = Ethanol stove
9 = Kerosene wick stove
10 = LPG stove
11 = Electric stove
12 = Kerosene pressure stove
13 = None
14 = Other (please describe)
CW19 CW20 CW21 CW22
TEA CW19 TEA CW20 TEA CW21 TEA CW22
of your water heating.
IF NO – do enough do year round without rooms fuel do house? many months per year do you heat
What all purpose-built heating device or heatingHow
If ‘other’ please describe
What in stove?
ribe the type of stove you use for most Is your house warm you have a you use to heat the heating? your you use for heating?
Text Number: Number: Number: Text Number: Number:
0 = No 0 = No 0 = None used 0 = None 0 to 12
1 = Yes 1 = Yes 1 = Open fire 1 = Wood [months]
2 = Normal cooking 2 = Charcoal
stove 3 = Dung/residues
3 = Purpose-built 4 = Biogas
heater 5 = Kerosene
4 = Multi-purpose 6 = LPG
cooker and heater 7 = Electricity
5 = Other 8 = Ethanol
9 = Coal
10 = Other
mandatory
CW22 description S1 S2 S3 S4 S5 S6
TEA
TEA CW22 description S1 TEA S2 TEA S3 TEA S4 TEA S5 TEA S6
an appliance cool–enough all appliance do you useplease anfood cool refrigerator,cool air in your house?
IF NO Do you use in air cooling most to (eg describe do you useconditioning)
What year round If ‘other’cooling? method in or air‘other’
without of keep electric
the If to coolbox)
Do you use Is your houseto keep food cool anyour house device?Whattime? (e.g.fan your home? please describe
Number: Number: Number: Number: Text Number: Text
0 = No 0 = No 0 = No 0 = None used 0 = None
1 = Yes 1 = Yes 1 = Yes 1 = Electric refrigerator 1 = Air conditioner
2 = Gas refrigerator 2 = Electric fan
3 = Coolbox 3 = Leave windows and doors
4 = Cool storage open
cupboard or room 4 = Keep light from coming
5 = Clay pot through windows
6 = Other 5 = Other
mandatory mandatory
C1 C2 C3 C4 C5 C6 C7
TEA C1 TEA C2 TEA C3 TEA C4 TEA C5 TEA C6 TEA C7
Do you have you use amobileor you in your house? ‘other’,apleaseor mobile phone outside ofdescribe…
year do you you your internet regular If
or radio Do house? house? your to you describe… ‘other’, please or TV outside of
phone your Do fixed If
How many months per Doa fixedDo cool haveTV inhaveaccess inaccesshouse? have regular access to a radioyour household? your h
Number: Number: Number: Number: Number: Text Number: Text
0 to 12 [months] 0 = No 0 = No 0 = No 0 = Do not have access 0 = Do not have access
1 = Yes 1 = Yes 1 = Yes 1 = In a neighbour’s or 1 = In a neighbour’s or
friend’s house friend’s house
2 = At a local 2 = At a local
shop/cafe/kiosk/ shop/cafe/kiosk/
community centre community centre
3 = At your place of work 3 = At your place of work
4 = Other 4 = Other
mandatory
mandatory mandatory
C8 IC1 IC2 IC3 IC4 IC5 IC6 IC7
TEA C8 TEA IC1 TEA IC2 TEA IC3 TEA IC4 TEA IC5TEA IC6 TEA IC7
If ‘other’, theSupply Index
Energy internet outside of your household? with (ESI): Discuss the options select the most suitable
Energy options
Do you have regular access toplease describe… (ESI): Discuss the Supply Index a household member andwith a household member a
Number: Text Number: Number:
0 = Do not have access 0 = Using non-standard solid fuels such 0 = No access to electricity at all
1 = In a neighbour’s or as plastics 1 = Access to third party battery charging only
friend’s house 1 = Using solid fuel in an open/three- 2 = Access to stand-alone electrical appliance
2 = At a local stone fire (eg solar lantern, solar phone charger)
shop/cafe/kiosk/ 2 = Using solid fuel in an improved stove 3 = Own limited power access for multiple home
community centre 3 = Using solid fuel in an improved stove applications (eg Solar home systems or power-
3 = At your place of work with smoke extraction/chimney limited off-grid)
4 = Other 4 = Mainly using a liquid or gas fuel or 4 = Poor quality and/or intermittent AC
electricity, and associated stove connection (remove 240V as non-standard)
5 = Using only a liquid or gas fuel or 5 = Reliable AC connection available for all uses
electricity, and associated stove (remove 240V as non-standard)
IC8 IC9 Household fuels Electricity
TEA IC8 E
TEA IC9 SI household fuels ESI electricity
Energy Supply Index (ESI): Discuss the options with a household member and select the most suitable
Number:
0 = No household access to tools or
mechanical advantages
1 = Hand tools available for household
tasks
2 = Mechanical advantage devices
available to magnify human/animal effort
for most household tasks
3 = Powered mechanical devices available
for some household tasks
4 = Powered mechanical devices available
for most household tasks
5 = Mainly purchasing mechanically
processed goods and services.
Mechanical Power COMMENTS ON ESI
ESI mechanical power ESI comments
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
ct the most suitable
TEA/ESI TEA ESI Int Job ESI
TEA TEA/ESI Age no ESI HH
TEA/ESI Int Name Int Organisation title Int Email HH TEA/ESI HH TEApeople community city
TEA
TEA ESI HH country L1 TEA L2 TEA L3 TEA L4 TEA L5 TEA L6 TEA CW1 TEA CW2
TEA CW3 TEA CW4 TEA CW5 TEA CW6 TEA CW7 TEA CW8 TEA CW9 TEA CW10 TEA CW10 description
TEA CW12
TEA CW11 TEA CW11 description TEA CW13 TEA CW14 TEA CW15 TEA CW16 TEA CW17 TEA CW18
TEA S1
TEA CW19 TEA CW20 TEA CW21 TEA CW22 TEA CW22 description TEA S2 TEA S3 TEA S4
TEA S5 TEA S6 TEA C1 TEA C2 TEA C3 TEA C4 TEA C5 TEA C6 TEA C7
TEA C8 TEA IC1 TEA IC2 TEA IC3 TEA IC4 TEA IC5 TEA IC6 TEA IC7 TEA IC8
TEA IC9 ESI electricity mechanical comments
ESI household fuels ESI ESI power