Livelihoods and Energy Control Panel
Guidance for the structure of Control Panel
Livelihoods Control Panel
Library ‘LM’
1.1 Common Components
1.2 Livelihoods Specific Component
Common Script
Livelihoods CONTROL PANEL (Parent)
2.1 GAS SCRIPT
2.2 HTML/JAVA SCRIPT
Energy Control Panel
Library ‘EM’
1.1 Common Components [Energy]
1.2 Energy Specific Component
Energy CONTROL PANEL (Parent)
2.1 GAS SCRIPT [Energy]
2.2 HTML/JAVA SCRIPT
Description of the main processes
Start and Refresh Control Panel
Modules of Start and Refresh Control Panel
Diagram on Start and Refresh Control Panel
GAS Functions for Start and Refresh Control Panel
Task scheduling and execution
Modules of Task scheduling and execution
Task status
Diagram on Task scheduling and execution
GAS Functions for Task scheduling and execution
Activation of automatic mode
Diagram on Activation of automatic mode
GAS Functions for Activation of automatic mode
Email notification
Modules of Email notification
Diagram on generationg Email notification
GAS Functions for Email notification
Extracting the PDF template
Modules of Extracting the PDF template
Diagram on Extracting the PDF template
GAS Functions for Extracting the PDF template
Extracting summary template table
Modules of Extracting summary template table
Diagram on Extracting summary template table
GAS Functions for Extracting summary template table
Deploying new surveys
Modules of Deploying new surveys
Diagram on Deploying new surveys
GAS Functions for Deploying new surveys
Updating the survey forms after deployment
Manual Module of Updating the survey forms after deployment
Diagram on Updating the survey forms after deployment
GAS Functions for Updating the survey forms after deployment
Updating the location file after deployment
Manual module of Updating the location file after deployment
Diagram on Updating the location file after deployment
GAS Functions for Updating the location file after deployment
CSV Customisation
Modules of CSV Customisation
Diagram on CSV customisation
GAS Functions for CSV customisation
Updating username
Manual module of Updating username
Diagram on Updating username
GAS Functions for Updating username
Autorizing user access
Manual module of Autorizing user access
Diagram on Autorizing user access
GAS Functions for Autorizing User Access
Suspending user access
Manual module of Suspending user access
Diagram on Suspending user access
GAS Functions for Suspending user access
Sample profiling
Modules of Sample profiling
Diagram on Sample profiling
GAS Functions for Sample profiling
Updating data for Beneficiary Survey
Modules of Updating data for Beneficiary Survey
Diagram on Updating data for Beneficiary Survey
GAS Functions for Updating data for Beneficiary Survey
Data Harmonization and Cleaning
Livelihoods Module - Data Cleaning and Harmonisation of Crop/Animal/Local Units and TOP/BOTTOM CODING
Modules of Data Cleaning
Diagram on Data Cleaning
GAS Functions for Data Cleaning
Livelihoods Module - UPDATE HARMONISATION LIST
Modules of updating harmonisation list
How to harmonise the CROP or ANIMAL NAME if you find “other” in column D of the HAM tab
Energy Module - Data Cleaning - KPT Day 1 - 2 matching, USD conversion and Top/Bottom coding
Modules of Data Cleaning for Energy Module
Diagram on Data Cleaning of Energy Module
GAS Functions for Data Cleaning of Energy Module
Country Analysis Note
Creating and updating a problem statement
Modules of Creating and Updating a problem statement
GAS Functions for Creating and Updating a problem statement
Extracting Country Analysis Note
Modules of Extracting Country Analysis Note
Diagram on Extracting Country Analysis Note
GAS Functions for Extracting Country Analysis Note
Generating PDF version
Modules of Generating PDF version
Generate PDF for beneficiary form
Updating the Global Indicators
Duplication process
Manage a Google Account
Set up a Google account
Google Account Settings
Set up a Google script account
System duplication methods
1. Complete system duplication with the new settings
Duplicate the monitoring sheet
Folder structure in Google drive account
Set up the kobo accounts
Enable API on Google script
Link kobo accounts to the script
Tests in the control panel
Troubleshooting
2. Creating an a child of Control Panel
Duplicate the monitoring sheet of Control Panel
Connect Library
Adjust parameters
Livelihoods and Energy Control Panel
»
Index
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
A
addCsvFileCountry() (built-in function)
addCsvMetaFileKobo() (built-in function)
addUserAccess() (built-in function)
addUserAccessCompletedTemplate() (built-in function)
adjustTrigger() (built-in function)
ALLDATAPS() (built-in function)
B
BackGround() (built-in function)
BR() (built-in function)
C
calculateCleaningProgress() (built-in function)
calculateOutlier() (built-in function)
catchToString() (built-in function)
changeEmailConfig() (built-in function)
changerow() (built-in function)
changerow2() (built-in function)
changerow3() (built-in function)
changeTrigger() (built-in function)
checkAnalysisNote() (built-in function)
checkYearParametors() (built-in function)
clearDupDetectorSheet() (built-in function)
clearKoboSheet() (built-in function)
clearKoboupSheet2018() (built-in function)
clearLogHistory() (built-in function)
clearTaskHistory() (built-in function)
CNOTEDIALOG() (built-in function)
compareNewExistData() (built-in function)
connectKoboEnketo() (built-in function)
connectKobotoolbox() (built-in function)
CONTEXTDIALOG() (built-in function)
convertDataOutliervToJson() (built-in function)
convertNumberToText() (built-in function)
convertSheet2Json() (built-in function)
convertToUSD() (built-in function)
copyDatasheet() (built-in function)
CopyLMtoEM() (built-in function)
countDataSubmissions() (built-in function)
countNumAnimalsIndicator4() (built-in function)
countNumBenefIndicator() (built-in function)
countNumBenefIndicator_energy() (built-in function)
countNumIndicator4Kitchen() (built-in function)
countNumItemsIndicator42Agr() (built-in function)
countNumItemsPartnerData() (built-in function)
countTotalNumAgeGroup() (built-in function)
countTotalNumCategoryIndicator2Agr() (built-in function)
countTotalNumIndicator2Dependency() (built-in function)
Countx() (built-in function)
createCsvFile() (built-in function)
createCsvMetaFile() (built-in function)
createCustomiseCSV() (built-in function)
createFile() (built-in function)
createFolder() (built-in function)
createNewBSurvey() (built-in function)
CREATEPARTNERDATA() (built-in function)
createPdfTemplateAll() (built-in function)
createUpdateAnalysisSheet() (built-in function)
createXML() (built-in function)
createXML_2018() (built-in function)
CSVDIALOG() (built-in function)
D
DATABRIDGE() (built-in function)
databridge() (built-in function)
datafilter() (built-in function)
deleteCsvMetaFileKobo() (built-in function)
deleteDataDupDetectorSheet() (built-in function)
deleteDataDupDetectorSheet2018() (built-in function)
deleteDataKoboupSheet() (built-in function)
deleteKey() (built-in function)
deletespace() (built-in function)
displayDataIndicator5Output2() (built-in function)
displayDataIndicator5Output2_energy() (built-in function)
displayDataIndicator6Output3() (built-in function)
displayDataIndicators123() (built-in function)
displayDataIndicators123_energy() (built-in function)
displayDataIndicators4Otput1() (built-in function)
displayEmailQuota() (built-in function)
displayKeyListing() (built-in function)
displayLabelIndicator4Ouput1() (built-in function)
displayMAP() (built-in function)
displayNarrative3SampleSize() (built-in function)
displayNarrativeIndicator3() (built-in function)
displayNarrativeIndicator41a() (built-in function)
displayNarrativeIndicator41Agriculture() (built-in function)
displayNarrativeIndicator41UtilisationStove() (built-in function)
displayNarrativeIndicator42Farming() (built-in function)
displayNarrativeIndicator42KPT() (built-in function)
displayNarrativeIndicator42Livestock() (built-in function)
displayNarrativeIndicator43Fuel() (built-in function)
displayNarrativeIndicator43Income() (built-in function)
displayNarrativeIndicator43Saving() (built-in function)
displayNarrativeIndicator4Output3() (built-in function)
displayNarrativeIndicator4OutputTable1() (built-in function)
displayNarrativeIndicator4OutputTable2() (built-in function)
displayNarrativeIndicator51Employment() (built-in function)
displayNarrativeIndicator52HHLighting() (built-in function)
displayNarrativeIndicator52Income() (built-in function)
displayNarrativeIndicator52Saving() (built-in function)
displayNarrativeIndicator52StreetSafety() (built-in function)
displayNarrativeIndicator53HHLighting() (built-in function)
displayNarrativeIndicator54HHSafety() (built-in function)
displayNarrativeIndicator56Interventions() (built-in function)
displayNarrativeIndicator61WageEmpl() (built-in function)
E
EMAILSAMPLEPROFILE() (built-in function)
excuteAllTask() (built-in function)
EXTERNALDATABRGE() (built-in function)
extractAllTemplates() (built-in function)
extractAnalysisNote() (built-in function)
extractCountryAnalysisNote() (built-in function)
extractCountryAnalysisNote_energy() (built-in function)
extractKoboForms() (built-in function)
extractMetaFiles() (built-in function)
extractPdfTemplate() (built-in function)
extractProblemStatement() (built-in function)
F
fetchSurvey() (built-in function)
fetchTemplate() (built-in function)
filterBenefAge() (built-in function)
filterInitial() (built-in function)
filterMain() (built-in function)
filterpage() (built-in function)
findDuplication() (built-in function)
findRowByName() (built-in function)
formatGraphArrow() (built-in function)
formatHeader() (built-in function)
formatNote() (built-in function)
formatTableHeader() (built-in function)
formatTables() (built-in function)
formatTables_energy() (built-in function)
formatTablesAddMerge_energy() (built-in function)
formatText() (built-in function)
FORMDIALOG() (built-in function)
G
generateEmailNotice() (built-in function)
generateLabelUnderTable() (built-in function)
generateTableIndicator41AgrEmpl() (built-in function)
,
[1]
generateTableIndicator42AgrProduc() (built-in function)
generateTableIndicator42AgrProducAnimal() (built-in function)
generateTablePercentIndicatorImpact() (built-in function)
generateTablePercentIndicatorImpact_energy() (built-in function)
generateTablePercentIndicatorImpactChange() (built-in function)
generateTablePercentIndicatorImpactChange_energy() (built-in function)
generateTemplateDataSpCountry() (built-in function)
getAllData() (built-in function)
getData() (built-in function)
getFile() (built-in function)
getKoboJsonData() (built-in function)
getListEmail() (built-in function)
H
harmoniseData() (built-in function)
header() (built-in function)
I
IndicatorYN() (built-in function)
initialFilter() (built-in function)
initialFilter_energy() (built-in function)
insertspace() (built-in function)
interventions() (built-in function)
L
loadCleanData() (built-in function)
loadDataTemplate() (built-in function)
LOCATIONDIALOG() (built-in function)
M
makeBackupParemetr() (built-in function)
mergeCells() (built-in function)
mergeText() (built-in function)
mergeText2() (built-in function)
N
Note() (built-in function)
O
openSidebar() (built-in function)
overwriteOutlier_energy() (built-in function)
P
PDFI() (built-in function)
PDFP() (built-in function)
putData() (built-in function)
Q
queryDataDupSheet() (built-in function)
queryDataKoboupSheet() (built-in function)
queryDataKoboupSheet2018() (built-in function)
queryDataSheet() (built-in function)
queryDataSheet2018() (built-in function)
R
recalculateTopBottomThresholds() (built-in function)
recalculateTopBottomThresholds_energy() (built-in function)
refreshBsurvey() (built-in function)
resetEmail() (built-in function)
S
SAMPLEPROFILE() (built-in function)
SAMPLEPROFILEDIALOG() (built-in function)
saveForm() (built-in function)
scheduleCreatePdfReport() (built-in function)
scheduleReminder() (built-in function)
scheduleTask() (built-in function)
sendReminder() (built-in function)
setApiSettings() (built-in function)
setKey() (built-in function)
shiftPosition() (built-in function)
showSidebar() (built-in function)
sortTable() (built-in function)
splitCells() (built-in function)
surveyreplace() (built-in function)
synchronizeAllForms() (built-in function)
syncroLHsHarmonization() (built-in function)
Syncrops() (built-in function)
T
takeUniqueDataBGsheet() (built-in function)
TEMPDIALOG() (built-in function)
TEMPLATEOUT_energy() (built-in function)
TEMPLATEREPORT_energy() (built-in function)
TEMPSUBMIT() (built-in function)
TEMPSUBMIT2() (built-in function)
TEMPSUBMIT3() (built-in function)
triggerAction4Hours() (built-in function)
triggerActionDaily() (built-in function)
triggerExecuteTask5Minutes() (built-in function)
TSORT() (built-in function)
U
UPDATADIALOG() (built-in function)
updateAllDataKobo() (built-in function)
updateCsvMetaFile() (built-in function)
updateDataHarmonizeDatabridge() (built-in function)
updateEmailAddress() (built-in function)
updateForm() (built-in function)
updateFormCreateBlob() (built-in function)
updateLog() (built-in function)
updateManuallyLocationFile() (built-in function)
updateOnCustomisation() (built-in function)
updateScriptChild() (built-in function)
updateTemplateSummaryTable() (built-in function)
updateUsername() (built-in function)
uploadNewForm() (built-in function)
USERDIALOG() (built-in function)
V
verifyKPTEnergy() (built-in function)