User Manual for Sustainable Development Interactive Tutorial
Contents
1. File Edit View Insert Format Tools Data Window Help Adobe PDF asso SA DSHLS SR Aa 2 x 2 l Gilad am 0p Arial 10 B Z u SS s a l5 A H15 se fe IF AND OR D15 lt gt F15 lt gt 015 F15 lt 0 YES B CG Lo E F 6 H I 1 View CCC View Module 3 View Instructions Return to Switchboard 2 3 E Project Add Build up Row Delete Build up Row Add Dravedown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention 8 conomic SELECT HERE 1 SELECT HERE YES g P1 Social SELECT HERE 1 SELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE YES 11 vw E SELECTHERE 1 SELECT HERE 121 nent SECTE 1 SELECT HERE YES KE Social F SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES 15 Economic SELECT HERE 1 SELECT HERE YES iI 16 P3 Social SELECT HERE 1 SELECT HERE YES il 17 Environment SELECT HERE 1 SELECT HERE YES 18 19 20 21 22 E 24 25 E 27 28 29 30 31 32 33 1N 45 SD Analyzer Draw 1 AutoShapes DOS 4 CEET ET Ready GC Page 23 of 36 12 If you want to review2. Economic Economic Environmental Social 4 4 NCCC Matrix pen L AutoShapes N OSB 432 08 9 24 A Ready Page 26 of 36 4 The resulting sustainable programs and projects are written down in the suggested List of Programs Projects by Sector under the appropriate sector category and distinguished as capital or non capital projects Just click on the Show Programs by 29 Sector button Microsoft Excel sustainableDeyt 19Dec 008_2130h xis 21 Ele gdt view Insert Format Tools Data Window Help Adobe PDF iDBEABAaIGRI7B 4 BB Gi9 Bez 66 Arial gt B Zu S o fe SELECT HERE A D Ch Generate CCC Matrix Sumi d Show Programs by Sector X as conflicting projects ha e O as complimentary projects N as compatible projects Conflict C ompatibility Complementation Matrix SELECT HERE 7 SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE M 4 HIN Matrix Draw g AutoShapes 5 Ready Dad g ASH saa If you want to review the 4 Module just select the View Module 4 button For the repackaging redesigning of the programs and projects interventions established as conflicting or with potential negative side effects you may revisit SD Analyzer by clicking on
3. Page 4 of 36 MS EXCEL WORKING WINDOW Microsoft Excel working window has the same features of working windows found on other Microsoft Office Applications such as Word and Powerpoint Below are marked items such as Title Bar Menu Bar Toolbar Control Box mouse pointer etc Menu Control Box Options Minimize Row i Heading ie Restore Exit Vertical Scroll Bar w Horizontal Column Scroll Bar Heading J Excet Feet fma Sech pea Window teb Adobe ror A AA SD A8 7 mm BZ u ESA a D L gt M gt e G D Na HA Navigation 3i Bar z s nN Shapta Steet Sheets 1 om aor SS OOU AS Md amp 4 A smEagB Status B Bees status Bar HOW TO ACCESS THE SD ITS 1 On your desktop double click the MS Excel icon with label Shortcut to sustainableDevt xls POCO Nas cals Page 5 of 36 2 If not found on the desktop go to the lower left of the MS Windows Screen Select Start All Programs Accessories and Windows Explorer Proceed to My computer and select Drive c SustainableDevt sustainableDevt xls Siistamnablepevt wr Search SU O C SustainableDevt Desktop My Documents B d My Computer B Se Local Disk C RECYCLE BIN bin amp Boot amp coolpro2 cygwin Documents and Settings amp dynamipsLabs QC GameRival E O games amp Inetpub
4. start a clean SD Type a question for help X IDSERBSBIGRIF Gs aA FI 41 KI lap 0 0p Arial a s e 293 G A H15 H 15 lt gt D15 F15 lt 0 YES A Cc D F G H A View CCC ViewM odule 3 View instructions Return to Switchboard 2 3 AddProject Delete Project Add Build up Row Delete Buildup Row Add Dravedown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7 Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention 8 conomic __ SELECT HERE 1 SELECT HERE YES g PI Social SELECT HERE 1 SELECT HERE YES 10 Environment _ SELECT HERE 1 SELECT HERE YES Ate i SELECT HERE 1 SELECT HERE 121 Economie FGELECTHERE T SELECT HERE yeg 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES BEA Economic SELECT HERE 1 SELECT HERI YES I 16 P3 Social SELECT HERE 1 SELECT HERE YES I 17 Environment SELECT HERE 1 SELECT HERE YES 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 F 33 J M 4 gt n SD Analyzer Jr J Draw g AutoShapes ball Ready NUM 3 Follow the prompt window for th
5. P answers into Questions this column Question 1 Question 2 Question 3 Question 4 Question 6 EEN Question 7 Question 8 Question 9 Question 10 Microsoft Excel Your score is 90 percent 9 out of 10 Page 9 of 36 2 Based on the grading system below SD ITS User may proceed to Enhanced Situational Analysis ESA Module if he is already satisfied with the score Try Again Knowledgeable Very knowledgeable 3 Ifnot satisfied with the score you may review the 1 Module by selecting the View Module 1 Once finish click on the Return to Switchboard SP ustainableDevt_21Dec2008 2300h xls d r Please input answers into Questions this column Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Page 10 of 36 File Edit View Document Tools Window Help modules pdf Adobe Reader dl RER C7 B 103 Overview This Handbook for Mainstreaming Sustainable Development in Public Sector Decision Making or SD Handbook explores how development decisions and actions can be implemented in a sustainable way to achieve intergenerational wellbeing or the wellbeing of all present and future Filipinos It looks into the social economic and environmental effects of development decisions and actions that lead to the attainment of intergenerational wellb
6. SELECT HERE Population or Area jwho where SELECT HERE SELECT HERE SELECT HERE SELECT HEF SELECT HERE SELECT HEI SELECT HERE SELECT HERE Si SELECT HERE K 4 Vi Enhanced Situational Analysis Draw gt g AutoShapes Ready Page 16 of 36 RANKING REPORT IIe 2 Ranking problems is intended to guide decisions on which problems to address immediately and which ones to put on hold Here SD ITS user may view Sectoral and Multisectoral Problems identified depending on the magnitude of the problems Microsoft Excel sustainableDevt 1 5ecZ008 2180h xis File Edit View Insert Format Tools Data Window Help Adobe PDF OBE RBSBIERIT BH XAA FI A z 21 4 lw Of Arial 10 8 z u Si Wee H Oo A B B3 X fe Rank DE C lt gt H Rank Problems Draw Lg AutoShapes SE Ready If you want to improve the ranking of problems you may click on the Return to ESA for the revisions Otherwise select the Return to Switchboard to proceed to next module E 050 e ainablene DecZ008 g SI File Edit View Insert Format Tools Data Window Help Adobe PDF Type aq DSUHRSSA YA EE 18 41 ligue Arial 10 8 z vu EBS of 98 SE se H Oo A B B3 H fe Rank RI C B F G TE J K EE N uestion
7. 19 3 Environmental 50 20 Forests conserved forest denudation prevented 300 300 200 400 K 4 gt HN Goals Analysis Matrix RC mr VOOR AC Em Ae Ready NUM Page 34 of 36 RANKED LIST OF PROPOSED PROJECTS FOR INVESTMENT PROGRAMMING 1 The projects are ranked according to their total scores from the GAM The highest score is ranked number one the next highest number two and so on This ranking represents the collective evaluation of the proposed project by the locality s various sector planners The ranked list of projects is transferred to the final list of programs and projects interventions as Ranked List of Proposed Projects for Investment Programming This now becomes the final investment plan of the locality which will be programmed for budgeting The values on the columns of Cost Estimates and the Capital or Non Capital originated from the table of List of Programs Projects by Sector Microsoft Excell sustainableDeyvi 1pDec 006 2130h xis SI pie Edit View Insert Format Tools Data Window Help Adobe PDF DSHRS3GRIT AIX RR YI9 0 18 z 24l wB el At Arial 10 lp Z U MIS E LS D6 be Fe 1660 spa E F ES K o re a R e Return to Goals Analysis Matrix Return to Switchboard Ranked List of Proposed Projects for Investment Programming Cost Estimate in PI Proposed Project Location Yr3 M I Yr6 Total Capital or 60
8. Enhanced Situational Analysis Worksheet Indicators Determinants Standard Reference Points Affected Target Population or Area jwho where Statement of Problem or Stren roximate Underlyis LECT HERE SELECT HERE F SELECT HERE SELECT HERE Hame SELECT HERE j SELECT HERE Outcome Results Rank SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE 321 em K 4 gt PN Enhanced Situational Analysis Draw Lg AutoShapes mOn 4m Ready 11 If you want to review the 2 Module just select the View Module 2 button For instructions on how to use this module click on the View Instructions If you want to go back to Main Menu click on the Return to Switchboard Microsoft Excel sustainableDeyt 15Pec2008 2130h xis GI file Edit View Insert Format Tools Data Window Help Adobe PDF DSUHbS SA d Arial el E a Show Ranking Report lal Add Outcome Row Delete Outcome Row Add Indicator Row Delete Indicator Row Enhanced Situational Analysis Worksheet Indicators Standard Affected Target Outcome Results Reference Points Statement of Problem or Stren
9. Project Sector Resource Build up Indicators Value Resource Draw down Indicators Valu Sustainable _ Non Sustainable Mitigating Intervention 8 Economic SELECT HERE TI SELECT HERE YES ESA Social SELECT HERE 1 SELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE mi CG SELECT HERE 1 SELECT HERE Ha Economic F SeLeECT HERE TT SELECT HERE Es 13 Social SELECT HERE 1 SELECT HERE eS 14 Environment SELECT HERE 1 SELECT HERE YES 15 Economic SELECT HERE 1 SELECT HERE YES I 16 P3 Social SELECT HERE 1 SELECT HERE YES 17 Environment SELECT HERE T SELECT HERE YES I 18 19 20 21 El 23 24 E 26 27 28 28 30 ER 32 33 z M 4 n SD Analyzer te Dem D Late E do gl A saab Ready NUM Page 22 of 36 10 If there are unsustainable programs and projects interventions which need to be prioritized input some mitigating interventions and adjust the numerical values of the resource build up and resource draw down so that the net effect will be recomputed to make said projects sustainable SI Ble Edt yew Insert Format Tools Data Window Help Adobe POF Type a question for help X DB HERBSIGRIY BB 4 B F 9 x 2 KL E 0p Arial sm B 7 u s ga G A H15 f
10. 1 SELECT HERE YES 14 Environment ELECT HERE 1 SELECT HERE YES 15 Economic ELECT HERE 1 SELECT HERE YES I 16 P3 Social 1 YES I Environment 1 YES 1 32 33 34 M 4 n SD Analyzer ij Draw 1 AutoShapes O Ac Te ap Ready NUM 7 To remove resource build up and draw down indicators click on Delete Build up Row and Delete Draw down Row respectively SI Ble Edt view Insert Format Tools Data OBE RaGRIValsaa g Window Help Adobe PDF Arial 10 B Zu Bs E H15 Sa f IF AND OR D15 lt gt F15 lt gt D15 F15 lt 0 YES A B G LD E F G H 1 1 View CCC ViewM odule 3 View Instructions Return to Switchboard 2 3 Add Project Delete Project Add Build up Ew Delete Buildup Row Add Drawdown R Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _ Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainablel Mitigating Intervention 8 Economic SELECT HERE 1 SELECT HERE YES g P1 Social SELECT HERE 4 SELECT HERE YES 10 Environment ELECT HERE 1 SELECT HERE YES do ELECT HERE 1 SELECT HERE al ten ELECT HERE 1 SELECT HERE Ts 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SE
11. 15 16 17 18 19 20 21 22 23 24 25 26 E L 28 nat uh Goals Analysis Matrix Ranked List of Projects T a ona T iDrawy Autoshapes 7 DOS AG aaa 2 A ERM ap Ready Sum 26703648 NUM Page 36 of 36
12. Economic __ SELECT HERE 4 SELECT HERE YES Il 16 P3 Social SELECT HERE 1 SELECT HERE YES I 17 Environment SELECT HERE 1 SELECT HERE YES 18 EN 20 21 22 23 24 25 26 27 28 29 30 31 32 33 M 4 gt n SD Analyzer Tt J Draw 1 AutoShapes 1 Si 42 ras Ready NUM Page 20 of 36 6 To insert additional resource build up and draw down indicators click on Add Build up Row and Add Draw down Row respectively HE Elle Edit View Insert Format Tools Data Window Help Adobe PDF DDASS Ra DR LL Daag 0p Arial GD AN H15 A B Cc ISS E F G 1 View CCC ViewM odule 3 View Instructions Return to Switchboard 2 3 AddProject Delete Project Add Build up Row lete Build up Row Add Drawdown Row Delige Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _Itervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention SI Economic SELECT HERE 1 SELECT HERE YES g P1 Social ELECT HERE 1 ELECT HERE YES 10 Environment ELECT HERE 1 SELECT HERE YES 11 ELECT HERE 1 SELECT HERE D Economie ELECT HERE 1 SELECT HERE vee 13 Social ELECT HERE
13. TOTAL value should be equal to 100 21 File Edit View Insert Format Tools Data Window Help Adobe PDF DBE RBBIEGRIV Gl Xaa 7 0 8 E Arial BZU Ba E16 2 KS 10 f 7 ag E D Show Ranked List of Projects Add Indicator Row Delete Indicator Row Type aquestionforhelp amp X z A m E amp A E H l J Return to Programs by Sector Return to Switchboard Goals Analysis Matrix Projects Value GC 100 Indicators TOTAL 15 1 Economic P1 P2 P5 16 Increased rural or urban income 2 Social Better future wellbeing 3 Environmental Forests conserved forest denudation prevented 30 50 31 33 34 35 36 M 4 MN Goals Analysis Matrix Draw g AutoShapes Ready DH ESEE A d Page 32 of 36 4 Input the values of the indicators goals or objectives on the columns of the programs and projects interventions KH File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help x D HRAISRI TA ET EE EEGEN Arial 10 B ZU BH s a Il ob AH F15 X f C D E F G H J K Show Ranked List of Projects Return to Programs by Sector Return to Switchboard Add Indicator Row Delete Indicator Row 11 Goals Analysis Matrix 12 Projects 13 Indicators Value P1 L i P5 P3 14 TOTAL 100 230 1210 530 380 15 1
14. amp kaspersky updates lotus QC Program Files Program Files x86 Program Files x86 Put a directory on PYTHONPATH here O Python24 amp Python2s CD RECYCLER Reflective Icons D SmartSound Software O SustainableDevt System Volume Information Winamp E O WINDOWS D S Local Disk D K d TS Folders Cz Then double click on sustainableDevt xls Microsoft Excel Worksheet 608 KB 3 For security purposes a pop up window will be prompted Click Enable Macros or press ALT E Security Warning C SustainableDevt sustainableDevt xls contains macros Macros may contain viruses It is usually safe to disable macros but if the macros are legitimate you might lose some functionality Disable Macros Enable Macros Se Page 6 of 36 4 The Main Screen Window will be shown as Switchboard As displayed below it has the following option buttons a Sustainable Development SD Manual b Assessment Exam c Enhanced Situational Analysis ESA d Sustainable Development Analyzer e Conflict Compatibility Complementation CCC Matrix f Programs by Sector g Goals Analysis Matrix h Ranked List of Projects i Restore Toolbars 1 ME SustainableDevt xis SD MANUAL 1 SD ITS user is expected to have read the modules of the SD Handbook prior to the usage of the system If you are not yet familiar with the said modules the Sustainable Devt Manual
15. and the factors that brought about these issues and concerns A thorough and correct understanding of the situation is important in the formulation of an SD enhanced development plan In this module we use the determinants outcome approach This approach tells us that a situation is likely to be the result or outcome of many interacting factors social economic environmental institutional and other factors It is a useful method of analyzing the determinants of an outcome or the result of interventions of the previous planning period i Also known as POPDEV approach NEDA IPDP 1993 Training Module on the Integrated Population and Development Planning Page 11 of 36 The following steps may be followed Identify a sector or sub sector desired outcome or result Identify indicators of each sector sub sector outcome Obtain data of each indicator Determine whether the outcome is desirable or not Identify the population affected by the situation Use projections population or area Validate SA with local community big mo ao op Find out what factors caused the situation to be the way it is 2 Using the SD ITS first click on the Clear Entire Sheet button to start a clean ESA Si File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help amp X DE ULS SRI TR aA J I e cr OF Arial 10 7 B EHS sl EIER H O A B C7 fe SELECT HERE B c D E F G H I J k A Show Ra
16. are two types of determinants proximate and underlying Microsoft Excel sustainableDeyt 15Pec2008 2130h xis GI file Edit View Insert Format Tools Data Window Help Adobe PDF DSUHbS SA 7 D AA ES Arial 10 B Zu g Show Ranking Report H Add Outcome Row Delete Outcome Raw Add Indicator Row Delete Indicator Row Enhanced Situational Analysis Worksheet Indicators Determinants Standard Affected Target Reference Statement of Population or Area Outcome Results g Points Problem or Strengti Proximate ing who where L SELECT HERE SELECT HERE SELECT HERE BEZ SELECT HERE SELECT HERE SELECT HERE Draw e AutoShapes Ready 9 Specify population groups by age and sex or specific areas as they will be affected by the problem situation EX 050 ainablepe D 008 0 SI File Edit view Insert Format Tools Data Window Help Adobe PDF Type a question for help xX OBHBAGAIT HB Aaa FI e hlm ei Arial 10 lp E U 8 A E H o A B B7 se f B c D E F D H J Ke Show Ranking Report View Module 2 View Instructions Return to Switchboard 2 Add Outcome Row Delete Outcome Row Add Indicator Row Delete Indicator Row Clear Entire Sheet Enhanced Situational Analysis Worksheet Indicators Determinants St
17. be classified as capital or non capital In general capital projects are those requiring relatively large permanent and tangible investments Non capital projects are those related to the installation or improvement of services and systems These include the introduction or adoption of new methodologies reorganization staff training and development research and development various health care services e g immunization feeding program and family planning and other interventions that add to the efficiency of the locality and improve people s welfare Microsoft Excel sustainableDevi 15Dec2008 77 30hi xls SI Eile Edit View Insert Format Tools Data Window Help Adobe PDF D HRAISA YA aD FI e 4118 l0 eh Arial 10 Bzu S seim A C13 m f P3 F G H l J K Generate GAM Return to CCC Matrix Return to Switchboard List of Programs Projects by Sector Project Title Sector M L Cost in PHP Non capital 3 4 2 Sao LATE ALAIN Total Estimated Capital or 7 8 SECTOR A ECONOMIC P1 DL SELECT HERE 9 P2 DL SELECT HERE 10 SECTOR A SOOAL a a E 11 PS DL SELECT HERE 12 SECTOR A ENVIRONMENTAL Hl SELECT HERE 31 M 4 gt n Programs by Sector Draw g AutoShapes NE Ne Ready Page 28 of 36 2 The user must in
18. button allows user to view the SD Handbook using the Adobe Acrobat Reader Page 7 of 36 sustainableDevt_13Dec2008_2000h xls Compatibility Mode Micra t Formulas Data Review View Enhanced Situational Analys is SD Anslyz Goals Analysis Matrix Ranked List ofPmjects Restore Toolbars or further information comments questions and suggestions please check the PCSD website iconuriaht December 2002 Dhiinnine Council for Sustainable Daualonmant mm SD Handbook Main pdf Adobe Reader Mainstreaming Sustainable Development in Public Overview This Handbook for Mainstreaming Sustainable Development in Public Sector Decision Making or SD Handbook explores how development decisions and actions can be implemented in a sustainable way to achieve intergenerational wellbeing or the wellbeing of all present and future Filipinos It looks into the social economic and environmental effects of development decisions and actions that lead to the attainment of intergenerational wellbeing A better understanding and knowledge of these interactions will help us examine the sustainability of different patterns of resource allocation Policymakers and planners need to be aware of the long term consequences of their policies and plans on social and environmental objectives Those who set environmental standards need to be conscious of the effects of these standards on human development as well as on the ec
19. for help amp X Retum to ESA Return to Switchboard T Rank of Sectoral and Multisector Rank Problems J BhesReesesssesREitleobelesh I Ss gt HN Rank Problems Draw e AutoShapes SE GE E IET Sr S Ready SS Page 17 of 36 SUSTAINABLE DEVELOPMENT SD ANALYZER 1 The module aims to deepen understanding of the planning process from the sustainable development perspective It also allows gaining of experience in the formulation of an SD enhanced Development Plan SDDP by assessing the sustainability of its vision goals objectives and targets and various interventions policies strategies programs and projects that address development concerns in the SA The project planning process includes the following steps a Problem identification and specification of objectives b Identification and designing of project activities c Planning project implementation and d Identifying monitoring and evaluation procedures SDDP introduces a way to assess the sustainability of plan interventions policies strategies programs and projects through the use of the SD Analyzer The SD Analyzer looks at the resource build up or drawdown and hence the sustainability of a development intervention to assist policymakers and planners decide on whether or not to implement such an intervention The SD Analyzer assesses the sustainability of plan interven
20. the Return to SD Analyzer If you want to return to Main Menu click on the Return to Switchboard Microsoft Excell sustainableDevyt 1 5 ec2008 21 30h xis Type a question for help 9 File Edit View Insert Format Tools Data Window Help Adobe PDF OSTERT IG BREET KE OG LEI 2k E HIE iB z ull 5 d A fe SELECT HERE Generate CCC Matrix Summary Show Programs by Sector Rss conflicting projects View Module 4 Retum to SD Analyzer O as complimentary projects N as compatible projects Conflict C ompatibility Complementation Matrix SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE M 4 HME Matrix Draw AutoShapesy x OOA Ready GGa o 4 4 zEaas Page 27 of 36 LIST OF PROGRAMS PROJECTS BY SECTOR 1 The List of Programs Projects by Sector is the outcome of the assessment among programs and projects in CCC Matrix Here user must input the estimated annual costs and the appropriate investment category as to capital or non capital Capital projects are marked C while non capital projects are marked NC The distinction is useful in the latter stages of investment programming and financing especially if national or foreign assistance grant or loan is availed of since these funding sources require projects to
21. 0 000 100 000 50 000 100000 750 000 Non Capital 000 000 2 000 000 3 000 000 _ 500 000 I 7 000 000 Capital 100000 200 000 _ 300 000 a 600 000 Non Capital 000 000 1 000 000 1 000 000 2 000 000 5 000 000 Capital 23 gt HA Goals Analysis Matrix Ranked List of Projects Draw AutoShapes IO AC Ready Page 35 of 36 2 If you want to re evaluate the GAM click on the Return to Goals Analysis Matrix button If you want to return to Main Menu click on the Return to Switchboard 21 File Edt View Insert Format Tools Data Window Help Adobe PDF Type a question for help x IDSA BSIEGRIT AI DR YI9 0 18 z i lw OB arial 70 B Ir U ESSRS WEE AD 06 E f 1660 E E G H I o P a R g 5 Return to Goals Analysis Matrix Return to Switchboard 2 3 Ranked List of Proposed Projects for Investment Programming 4 Cost Estimate in PHP Capital or 5 Rank Proposed Project Location Yri vr2 w3 vwa ves vre Total Non capital 6 1 1Ps 500 000 _100 000 50 000 100 000 D 0 _750 000 Non Capital F 1 000 000 2 000 000 3 000 000 500 000 500 000 7 000 000 Capital 8 Ze 100 000 200 000 300 000 D D DI 600 000 Non Capital Si HS 1 000 000 1 000 000 1 000 000 2 000 000 D O 5 000 000 Capital 10 11 12 13 14
22. Build up Indicators Value Resource Draw down Indicators Value Bustainable_ Non Sustainable Mitigating Intervention ST conomic SEET HERE TISPELECTHERE YES a P1 Social SELECT HERE FSELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE YES 11 E SELECTHERE 1 SELECT HERE dal Economic FE SELECTHERE 1 SELECT HERE Ge 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES 15 Economic SELECT HERE 1 SELECT HERE YES I 16 P3 Social SELECT HERE 1 SELECT HERE YES 1 17 Environment SELECT HERE 1 SELECT HERE YES 18 19 20 SN 22 23 24 E 26 27 26 E 30 ER 32 E 33 m 4 WASD Analyzer Draw l AutoShapes KE Ready NUM 9 The Net Effect of each program or project is computed by deducting the value for resource drawdown from the value of resource build up in each of the dimensions social economic environmental D Dec200 0 Ele Edt vew Insert Format Tools Data Window Help Adobe POF Type aquestionforhelp x O e Baiagiiveals4aa g 41 l play o0 0p Arial 10 B Z II G A H15 D 15 lt gt D15 F15 lt 0 YES I S D E F 6 H i 1 View CCC ViewModule 3 View instructions Return to Switchboard 2 3 AddProject Delete Project Add Build up Row Delete Buildup Row Add Dravedown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _ Intervention
23. E 1 SELECT HERE YES I 17 Environment SELECT HERE 1 SELECT HERE YES 1 18 19 20 21 22 23 24 25 26 27 28 E 30 31 32 33 K 4 n SD Analyzer Ft J Draw l AutoShapes Mea za ap Ready NUM 5 For each of the program or project intervention identify its social economic and environment indicators of resource build up as well as resource drawdown and fill in the column by selecting on the appropriate indicators E ge Edit View Insert Format Tools Data Window Help Adobe PDF Type a q 8X DUBAIJA AAA FI 18 4 l i E Arial 10 B ZU H15 fe IF AND OR D15 lt gt F15 lt gt D15 F15 lt 0 YES J 4 B Cc E F G H A View CCC ViewM odule 3 View Instructions Return to Switchboard 2 3 Add Project Delete Project te Build up Row Add Dravedown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention 8 Economic SELECT HERE 1 SELECT HERE YES g P1 Social ELECT HERE 4 SELECT HERE YES 10 Environment 1 SELECT HERE YES it i SELECT HERE YES 13 7 Socia T S YES 14 Environment 1 SELECT HERE YES 151
24. E File gdt View Insert Format Tools Data Window Help Adobe PDF Oma Bago ITA AR BAe Bes Show Ranked List of Projects Add Indicator Row Delete Indicator Row Indicators 1 Economic 3 Environmental SELECT HERE M 4 HN Goals Analysis Matrix Draw l AutoShapes CLOS Ready 2 First we get the social economic and environment development goals objectives of the locality and select the indicators in the first column Page 31 of 36 21 tie gdt View Insert Format Tools Data Window Help Adobe POF DSHBASA VAI aB FI9 0 I8 x 2 Arial 10 B Z U E H19 f o e 0 C D Show Ranked List of Projects Add Indicator Row Delete Indicator Row Type a question for help 4l Qi a oo Er A H J Return to Programs by Sector Return to Switchboard Goals Analysis Matrix Projects Indicators Value TOTAL 1 Economic SELECT HERE 2 Social SELECT HERE 3 Environmental SELECT HERE PI P2 P3 M 4 gt 1 Goals Analysis Matrix Draw L AutoShapes Zen Ready OB 40 BB 9 4 A EC ttl 3 Place the corresponding values of the indicators goals or objectives on the rows of Economic Social and Environmental Make sure that the
25. Economic 20 16 Increased rural or urban income 100 5000 2000 600 17 2 Social 30 18 Better future wellbeing 200 200 100 200 19 3 Environmental 50 20 Forests conserved forest denudation prevented 300 300 200 400 L M 4 gt HN Goals Analysis Matrix Reo iDrawy D Autoshapesy amp OOS di o w A Ready NUM 5 To insert more rows for the indicators click on the Add Indicator Row E Microsoft Excell sustainableDevt 1 50ecZ008 21G0h xis iE gie Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help amp LOSER SSR THE BB g 9 5 2 410 OB 10 B EF H Ki E A f T UE RC a M BEZE ts Return to Programs by Sector Return to Switchboard Add Indicator Row ete indicator Row 11 Goals Analysis Matrix 12 Projects 13 Indicators PI P2 a Se 14 TOTAL 230 1210 D 550 eg 15 1 Economic i 16 Increased rural or urban income 5000 17 2 Social 18 Better future wellbeing 200 10 200 3 Environmental Forests conserved forest denudation prevented 300 200 400 M 4 n Goals Analysis Matrix Draws L AutoShapess SS OOM di OE o w A Ready Page 33 of 36 6 Select on Show Ranked List of Projects button to view the new list of sustainable programs and projects interventions On this list are programs and p
26. LECT HERE 1 SELECT HERE YES 15 Economic__ SELECT HERE 4 SELECT HERE YES I 16 P3 Social ELECT HERE 4 SELECT HERE YES I 17 Environment SELECT HERE 1 SELECT HERE YES 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 4 4 M SD Analyzer Jr Draw gt L Autoshapes gt CIOS lc sw Ae zag Ready NUM Page 21 of 36 8 For each build up and draw down indicator determine the numerical value such as 1 10 or 1 100 with 10 and 100 being the highest The Net Effect of each program or project is computed by deducting the value for resource drawdown from the value of resource build up in each of the dimensions social economic environmental File Edt vew Insert Format Tools Data Window Help Adobe POF Type aquestionforhep x DHL SA T L DB nr EE Arial 10 B 7 U SEI H15 fe IF AND OR D15 lt gt F15 lt gt D15 F15 lt 0 YES I A B CG D E F a H i 1 View CCC ViewModule 3 View Instructions Returnto Switchboard 2 3 AddProject Delete Project Add Build up Row Delete Build up Row Add Drawdown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _Intervention Project Sector Resource
27. MC Matrix Dau g AutoShapes 5 Ready Page 25 of 36 3 Select the suitable sector to which the programs and projects interventions may be characterized Then generate the CCC Matrix Summary to view by group the programs and projects interventions Microsoft Excell sustainableDeyt 1 5 ec2008 21 30h xis 21 Ele Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help X iDG HEBaIEGRI7VG 4BB 9 9 B Zoe D s ee Be E SR a TS EE E EE h Generate CCC Matrix Summary X as conflicting projects View Module 4 Return to SD Analyzer as complimentary projects as compatible projects Conflict Compatibility Complementation Matrix ES SELECT HERE SELECT HERE SELECT HERE SELECT HERE M 4 gt ACCC Matrix Dau L AutoShapes 5 osso eil A A Roady Microsoft Excel sustainableDeyt 1 5Dec2008 2130h xls KH File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help DEURBRAAK AaB FI L 41 41 Allon OB Arial 5w sr EERE F H o A B C10 RO EE F LLL OO ER E Generate CCC Matrix Summary Show Programs by Sector X as conflicting projects View Module 4 Retum to SD Analyzer Return to Switchboard as complimentary projects N as compatible projects Conflict Compatibility Complementation Matrix
28. NTS The SD ITS is developed using Microsoft Excel version 2003 However it is compatible with MS Excel version 97 The recommended operating system is MS Windows XP The file size is approximately 800KB For reference below is the minimum system requirements for MS Excel release 2003 Processor Pentium 233 MHz or higher processor Pentium III recommended Operating system Microsoft Windows 2000 Service Pack 3 or later or Windows XP or later recommended Memory 64 MB RAM minimum 128 MB RAM recommended Disk space 245 MB including 115 MB of available space on the hard disk that contains the operating system Hard disk space usage varies depending up the configuration A local installation source requires approximately 2 GB of hard disk space during the installation the local installation source that remains on users computers requires as much as 240 MB of hard disk space beyond that required for Office Monitor Super VGA 800 x 600 or higher resolution with 256 colors Disk drive CD ROM drive Pointing device Microsoft Mouse Microsoft IntelliMouse or compatible pointing device Note None of the Microsoft Office editions in the 2003 release runs on the Microsoft Windows Me Windows 98 or Windows NT operating systems If any client computers are currently running one of these operating systems you must upgrade the operating system before installing Microsoft Office
29. RE El e K 4 Vi Enhanced Situational Analysis Draw Lg AutoShapes oog Ready 5 To enter the indicators per outcome result click on the Add Indicator Row button Also for each indicator record the corresponding values weights and its standard reference points on the next two columns to the right Microsoft Excel sustainableDeyt 15Pec2008 2130h xis G file gdt View Insert Format Tools Data Window Help Adobe PDF DSH BAERIT HB A aA 7I 8 24m ei Arial 10 B Zu p Show Ranking Report View Module 2 View instructions Return to Switchboard Ei Add Outcome Row Delete Outcome Rd LI Add Indioator Row D jete Indicator Row Clear Entire Sheet anced Situational Analysis Worksheet Indicator Determinants Standard Affected Target Reference jatement of Population or Area Name Points Praplem or Stren Rank Proximate Underlyi who where SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HER SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE al K 4 h Enhanced Situational Analysis Draw b AutoShapes
30. User Manual for Sustainable Development Interactive Tutorial Software copyright December 2008 Philippine Council for Sustainable Development TABLE OF CONTENTS User Manual for Sustainable Development Interactive Tutorial Software ee eee eee DEE 1 CAB 2 NT EEE 3 MICROSORNEXCEREN DENPRBOUIREMENTSSES EE 4 Rekter 1 1 HEEN eames 5 HOW TORACOESSHMHEBSDITS ER 5 DIEN EE MARN 7 Pee BS SMEN MBF 5i nn EE ieee 9 ENHANCED SITUATIONAL ANALYSIS ESA 11 PUA SRE DORT 7 17 SUSTAINABLE DEVELOPMENT SD ANATLN ZER 18 CONFLICT COMPATIBILITY COMPLEMENTATION CCC MATRIX 24 E 7 28 GOALS ANALYSIS MATRIX CAVE 31 RANKED LIST OF PROPOSED PROJECTS FOR INVESTMENT BERR OG R 1 fe 35 Page 2 of 36 INTRODUCTION The National Economic Development Authority Agriculture Staff with financial assistance from Philippine Council for Sustainable Development PCSD has introduced to government agencies the Handbook for Mainstreaming Sustainable Development in Public Sector Decision Making or Sustainable Development SD Handbook which will aid planners in their decisions and actions to make a development plan in a sustainable way achieving intergenerational wellbeing or the wellbeing of all present and future Filipinos In addition this SD Interactive Tutorial Software SD ITS was conceptualized as a tool to make it easier for SD planning Page 3 of 36 MICROSOFT EXCEL SYSTEM REQUIREME
31. YES 17 Environment SELECT HERE 1 SELECT HERE YES 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 nat n SD Analyzer Draw l AutoShapes TA d a 4 EGRET Ready NUM CONFLICT COMPATIBILITY COMPLEMENTATION CCC MATRIX 1 In the suggested Conflict Compatibility Complementation CCC Matrix the projects that are conflicting are marked X Complementary projects are marked O while compatible projects are marked N Projects that are not in harmony with many or most of the other projects are taken out of the master list Those that clash with some projects but are compatible or complementary with others may be redesigned to remove conflicting project components Complementary projects may be repackaged if needed Repackaging projects means that two or more complementary projects may be integrated into one proposal This applies especially for multidisciplinary and multi sectoral projects e g projects on poverty alleviation minimum basic needs or ecological security Conflicting projects have expected benefits that tend to nullify the gains of others or the implementation of which obstructs the execution of another Page 24 of 36 Complementary projects are those whose activities components or objectives mutually support each other Compatible projects are neutral neither conflicting with nor complementing each other These can be implemented without affec
32. andard Affected Target Value Reference Statement of Population or Area Outcome Results Hame feight Points Problem or Stren Rank Proximate Under ai ebe were SELECT HERE SELECT HERE SELECT SELECT HERE SELECT HERE SELECT SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE 12 13 14 15 16 17 18 19 20 21 22 23 24 E 26 27 28 L 29 30 ER EK K 4 gt HN Enhanced Situational Analysis SS Draw gt L AutoShapes IO 4 280 le Ready NUM A proximate determinant affects an outcome directly An underlying determinant affects an outcome indirectly by directly affecting the proximate determinant Page 15 of 36 10 The ranking report can be generated from the ESA Module by clicking the button Show Ranking Report The report will sort the identified problems with the given values on the rank column Microsoft Excel sustainableDeyt 1 5PecZ008 71 30h xis GI file Edit View Insert Format Tools Data Window Help Adobe PDF DAS SA TRARR y Arial HL WEI ame op amp amp 4 B View Module 2 Views Instructions Return to Switchboard K Show Ranking Report a Add Outcome Row Delete Outcome Row Add Indicator Row Delete Indicator Row
33. d out which among them ought to be dealt with during the plan period From these two 2 columns we need to record the problems or strength and its urgency extent as the common concern of the locality FE Edt View Insert Format Tools Data Window em WS i Type a question for help X DSUBAAAFA AAD JID Edl O Arial r10 B Z HlSS sl RIE Ee Haap Di f B G H 1 J K o o m bd Show Ranking Report View Module 2 View Instructions Return to Switchboard z Add Outcome Row Delete Outcome Row Add Indioator Row Delete Indicator Row Clear Entire Sheet Enhanced Situational Analysis Worksheet 5 Indicators Determinants Standard Affected Target Value Referens Statement of Population or Area 6 Outcome Results Name feight Point Problem or Stren Rank roximate Underlyi who where 7 SELECT HERE g PELECT HERE SELECT HERE 8 SELECT HERE P SELECT HERE SELECT HERE 9 SELECT HERE SELECT HERE SELECT HERE 10 SELECT HERE SELECT HERE SELECT HERE 11 SELECT HERE SELECT HERE SELECT HERE A SS K 4 N Enhanced Situational Analysis Wee Draw Lo AutoShapes OOg 42 Wa EHF EH Ready NUM Page 14 of 36 8 A determinant is a factor influencing or causing an outcome There
34. e IF AND OR D15 lt gt F15 lt gt D15 F15 lt 0 YES A B Cc D E E G H 1 View CCC ViewM odule 3 View instructions Return to Switchboard 2 3 AddProject Delete Project Add Build up Row Delete Buildup Row Add Drawedown Row Delete Drawdown Row et 6 Net Effect 7 _Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainab Mitigating Intervention 8 Economic SELECT HERE 1 SELECT HERE YES g P Social SELECT HERE 1 SELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE YES 11 SELECT HERE 1 SELECT HERE se Economie SELECT HERE T SELECT HERE vee 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES 16 Economic SELECT HERE It SELECT HERE YES I 16 P3 Social SELECT HERE 1 SELECT HERE YES Il 17 Environment SELECT HERE 1 SELECT HERE YES 1 18 mm 20 21 22 23 24 25 26 27 28 29 30 31 32 33 gt HILD Analyzer E tee Draw gt L Atetege S O doa A sesznglh Ready NUM 11 From this module the Conflict Compatibility Complementation CCC Matrix can be generated by clicking on the View CCC button The programs and projects interventions are further assessed to see whether they are compatible conflicting or complementary
35. e next step Microsoft Excel Sheet is now empty please use Add Project Button to add new project rows FS 4 As instructed click on the Add Project button to insert rows where you can input the programs and projects interventions Page 19 of 36 DI file gdt View Insert Format Data Window Help Adobe PDF OS W Bag RivalsaOe i9 c x 10 B Z u la Tools Bz Arial WEEK H15 bal E IF AND OR D15 lt gt F15 lt gt D15 F15 lt 0 YES A B C E F G H 1 View CCC ViewM odule 3 View Instructions Return to Switchboard 3 Add Project Del roject Add Build up Row Delete Build up Row Add Drawdown Row Delete Drawdown Row Clear Entire Sheet 6 Net Effect 7_ _Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention 8 Economic SELECT HERE 1 SELECT HERE YES g P1 Social SELECT HERE 1 SELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE YES at i SELECT HERE 1 SELECT HERE lp Economic SELECT HERE T SELECT HERE Ee 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES 15 Economic _ SELECT HERE 1 SELECT HERE YES J 16 P3 Social ELECT HER
36. eing A better understanding and knowledge of these interactions will help us examine the sustainability of different patterns of resource allocation Policymakers and planners need to be aware of the long term consequences of their policies and plans on social and environmental objectives Those who set environmental standards need to be conscious of the effects of these standards on human development as well as on the economy Finally policymakers and planners who deal with social development issues must be aware of the long term implications of human development on the economy and the environment Objective of the SD Handbook The handbook will enhance the understanding and capability of policymakers and planners in mainstreaming sustainable development SD in public sector decision making specifically in planning programming and budgeting Through a modular approach of lectures and workshops it will give policymakers and planners a hands on experience in improving their development plans and making them sustainable The guide consists of four modules ENHANCED SITUATIONAL ANALYSIS ESA 1 Situational Analysis is an assessment of the conditions of a locality and the social economic environmental physical political cultural and institutional factors affecting these conditions It is primarily undertaken to determine the key development issues and concerns of an area its strengths weaknesses opportunities and threats
37. ls i File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question forhelp x OMA REAIGRA FH saB F 9 B 2 41 lB ei Arial 10 B Z u e Bis MSIE A R Tn Es c E E O PaT O o O o o M L_N L 4 List of Programs Projects by SE Annual Coni MEHE Total Estimated Capital or LS Y5 Cost in PHP Non capital SECTOR A ECONOMIC P1 SELECT HERE P2 SELECT HERE SECTOR A SOCIAL SELECT HERE SECTOR A ENVIRONMENTAL SELECT HERE Draw gt o AutoShapes Ready Page 30 of 36 GOALS ANALYSIS MATRIX GAM 1 Prioritization is necessary because available resources especially capital resources are scarce and limited and may not be enough to fund all programs and projects identified in the local sustainable development plan Among methods for prioritizing and ranking programs and projects are Cost benefit analysis weighted Goals Analysis Matrix Problem structure approach Supply and demand projection Economic profitability indicators SS nn The SD handbook suggests the use of the weighted Goals Analysis Matrix GAM It is a means of validating the development priorities goals and objectives of the development plan and the relative values the locality places on these goals and objectives Microsoft Excell sustainableDeyt i SVecZ00B 71 30h xis
38. ms by Sector Draw g AutoShapes OOB4 amp Ready Sum 0 NUM Page 29 of 36 4 The new master list is now ready for Stage 3 of the investment programming process i e prioritizing and ranking programs and projects using the weighted Generate the Goals Analysis Matrix GAM Click on the Generate GAM button to process the matrix 21 tie Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help amp xX DSHLAGRIY IARR SI92 0 18 x 21 41810 OF Arial Sg SNS 3 PAIE E GD AH GEES J K LE M N 0 F Generate GAM Return to CCC Matrix Return to Switchboard whl EI ws 4 m m o m pa List of Programs Projects by Sector 4 Annual eona in EHE Total Estimated Capital or 6 Project Title Sector Yri Yr2 Y3 Yi Y5 KO Cost in PHP Non capital ae 8 9 SECTOR A ECONOMIC P1 DL SELECT HERE DL SELECT HERE 10 SECTOR A SOCIAL DL SELECT HERE P 12 SECTOR A ENVIRONMENTAL 13 P3 DL SELECT HERE M 4 MN Programs by Sector te Draw le AutoShapes OOM Ac ealo 2 A Ready Sum 0 NUM 5 If you wan to modify the CCC Matrix because of certain program and projects intervention click on the Return to CCC Matrix If you want to return to Main Menu click on the Return to Switchboard Microsoft Excel sustainableDevt 15Dec2008 71 30h x
39. nking Report View Module 2 View Instructions Return to Switchboard Add Outcome Row Delete Outcome Raw Add Indicator Row Delete Indicator Row Enhanced Situational Analysis Worksheet Clear Entire Sheet 5 D standard vate Reference 6 Outcome Results Hame Points z SELECT HERE Iv on 8 eS SELECT HERE SELECT Com Dee Affected Target Population or Area who where M 4 gt Hh Enhanced Situational Analysis Dram u AutoShapes 42 B o 4 A 32 E68 sk Ready 3 A pop up window will be shown for the next step Microsoft Excel Sheet is now empty please use Add Outcome Button to add new outcome rows Page 12 of 36 4 As instructed click on the Add outcome button to insert blank outcome rows Input outcomes results relative to concerned localities Microsoft Excel sustainableDeyt 15Pec2008 2130h xis GI file Edit View Insert Format Tools Data Window Help Adobe PDF Type a question For help USNAOa BA AE EZ Arial 10 B Zu Clear Entire Sheet Enhanced Situational Analysis Worksheet Indicators Determinants Standard Affected Target Reference Statement of Population or Area Outcome Results i Points Problem or Streng it jwho where L SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HE
40. onomy Finally policymakers and planners who deal with social development issues must be aware of the long term implications of human development on the economy and the environment Objective of the SD Handbook The handbook will enhance the understanding and capability of policymakers and planners in mainstreaming sustainable development SD in public sector decision making specifically in planning programming and budgeting Through a modular approach of lectures and workshops it will give policymakers and planners a hands on experience in improving their development plans and making them sustainable The guide consists of four modules Page 8 of 36 2 If an error window appears please ensure that the Portable Document File PDF files were copied in the directory of c SustainableDevt For the soft copies of said files please consult your PCSD focal person Microsoft Excel SD Manual File not Found Please make sure the file SD Handbook Main pdf is in the same directory as this file ASSESSMENT EXAM 1 SD ITS User may take the assessment exam to validate his knowledge on the concepts of SD planning Fill in your answers to the questions with letters a to e on the column provided Then click on the Grade Exam button to verify your understanding of SD concepts A pop up window will show your score sustainableDevt_21Dec2008_2300h xis Eek Grade Exam View Module 1 Retum to Switchboard
41. put the estimated annual costs of each program and project intervention Microsoft Excell sustainableDeyt 1 50ec200B 71 30h xls i File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help SUHBAISRITY MIE AD 7I 18 z 2w OB 10 B EH ES h Return to CCC Matrix Return to Switchboard SELECT HERE SELECT HERE SECTOR A SOCIAL P5 SECTOR A ENVIRONMENTAL SELECT HERE 1 4 4 n Programs by Sector Dram AutoShapes sw IO 42 Ready 3 Categorize the program and project intervention as to capital or non capital investment i File Edit View Insert Format Tools Data Window Help Adobe PDF Type aquestionforhelp X DBA RAGA Hs Bw gF 9 4 B OB Arial 10 BZU EIERE H o A B c13 X fe P3 c D Saal EE G H J K Ent M N 0 Fe Generate GAM Return to CCC Matrix Return to Switchboard List of Programs Projects by Sector 4 5 altele dlti Total Estimated Capital or 6 Project Title Sector Yri K Y3 Yrd Yrs Op Cost in PHP Non capital if 8 3 SECTOR A ECONOMIC P1 SELECT HERE P2 SELECT HERE 10 SECTOR A SOCIAL Im PS 12 SECTOR A ENVIRONMENTAL EIS o SELECT HERE ol e SELECT HERE M 4 N Progra
42. rojects interventions sorted according to the Total Weighted Score Microsoft Excell sustainableDeyt 1 5ec20068 2180h xls KH File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help X DUBASI AX aD FI e E tl klm OB ht E A a Show Ranked List of Projects Return to Programs by Sector Return to Switchboard P us Elvis Delete Indicator Row 10 Goals Analysis Matrix jects Increased rural or urban income 2 Social Better future wellbeing 3 Environmental Forests conserved forest denudation prevented M 4 MN Goals Analysis Matrix Draw L AutoShapes OOS 42 N IE ET AT SAE Ready 7 If you want to modify the programs by sector click on the Return to Programs by Sector If you want to return to Main Menu click on the Return to Switchboard eDe De O08 H KH File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help X DSHBSAISAITAILDR YI9 0 18 O E Arial 10 B rule el a z GD AH F15 Sa f Cc D E E G K Show Ranked List of Projects Return to Programs by Sector Return to Switchboard Add Indicator Row Delete Indicator Row 11 Goals Analysis Matrix 12 Projects 13 Indicators Value P1 L i PS P3 14 TOTAL 100 230 1210 530 380 15 1 Economic 20 16 Increased rural or urban income 100 5000 2000 600 17 2 Social 30 18 Better future wellbeing 200 200 100 200
43. the 3 Module just select the View Module 3 button For instructions on how to use this module click on the View Instructions If you want to go back to Main Menu click on the Return to Switchboard E oso e SEIL DeczO0B D DI File Edit View Insert Format Tools Data Window Help Adobe PDF DSOGSSGSGOGVAGAMG llil lee OB Arial 10 B zu s S ze H Oo A B H15 H fe IF AND OR D15 lt gt F15 lt gt 015 F15 lt 0 YES A B C D E F G H 1 ViewCCC ViewModule 3 View Instructions Return to Switchboard 2 3 Add Project Delete Project Add Build up Row Delete Buildup Row Add Drawdown Row Delete Drawdown Row Cle eet 6 Net Effect 7_ _Intervention Project Sector Resource Build up Indicators Value Resource Draw down Indicators Value Sustainable _ Non Sustainable Mitigating Intervention 8 Economic SELECT HERE 1 SELECT HERE YES g P Social SELECT HERE 1 SELECT HERE YES 10 Environment SELECT HERE 1 SELECT HERE YES A SELECT HERE 1 SELECT HERE lp Economie f SELEGTHERE 1 SELECT HERE ee 13 Social SELECT HERE 1 SELECT HERE YES 14 Environment SELECT HERE 1 SELECT HERE YES 15 Economic L SELECT HERE 1 SELECT HERE YES 16 P3 Social SELECT HERE 1 SELECT HERE
44. ting the costs or benefits of the other projects Microsoft Excel sustainableDeyt_15Dec2008 2130h xis 21 Eile Edt View Insert Format Tools Data D ERBaIEGRIT G4 Je zu RES FC Type a question forhelp amp X Generate CCC Matrix Summary Show Programs by Sector icti P View Module 4 Return to SD Analyzer R Return to to Switchboard as complimentary projects e compatible projects Conflict Compatibility compleMentatign Matix SELECT HERE l gt P SELECT HERE SELECT HERE SELECT HERE SELECT HERE SELECT HERE M 4 CCC Matrix ran L AutoShapes 5N DOS AO 891 A ses 08 Ready 2 SD ITS User must select the suitable value in comparing consolidating integrating and repackaging the programs and projects interventions Microsoft Excel sustainableDevt_15Dec2008 21 30h xis 21 Ele Edit vew Insert Format Tools Data Window Help Adobe PDF DAE BSGRFH 4B B G 9 B 21 48 li0x eh Be Jee rulslsesmis 8 a zma A SELECT HERE Type a question forhelp x EX a8 conflicting projects View Module 4 Retur to SD Analyzer Ri O as complimentary projects N as compatible projects SELECT HERE SELECT HERE SELECT HERE BS SELECT HERE M 4 gt H
45. tions policies strategies programs and projects It is an improvement from the traditional development planning process which does not explicitly assess whether or not a program project is sustainable The SD Analyzer provides assurance that the plan interventions we will implement contribute to the sustainable development goals of the locality Using the SD Analyzer the following steps may be your reference in assessing the programs and projects sustainability a Identify programs and projects based on sustainable policies and strategies b Identify its social economic and environment indicators of resource build up as well as resource drawdown project goals objectives or effects impact may be used as indicators c Determine the numerical values e g 1 10 or 1 100 with 10 and 100 being the highest of each indicator of resource build up drawdown d Decide whether the program or project is sustainable or not by adjusting the net effect of each program or project It is deemed sustainable if it has an over all positive net effect in the social economic and environmental sectors e If there are unsustainable programs or projects which need to be prioritized input some mitigating interventions and adjust the net effect to make said projects sustainable Page 18 of 36 2 Using the SD ITS first click on the Clear Entire Sheet button to Analyzer SI Eile Edt View Insert Format Tools Data Window Help Adobe PDF
46. w I 4 Ready Page 13 of 36 6 To delete an indicator per outcome result click on the Delete Indicator Row button 050 ainableDe D 008 0 GI ge Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help X DSHBESRATYHIARB YI2 0 18 oh llw ei EE 1 8 BSF A E F St H LU J K Arial si B Z HlS Selz Di i f B o o Show Ranking Report View Module 2 View Instructions Return to Switchboard Add Outcome Row Delete Outcome Row Add Indioator Delete Indicator Row Clear Entire Sheet Enh j j alysis Worksheet Indicators Determinants Standard Affected Target Value Reference Statement of Population or Area 6 Outcome Results Name light Points Problem or Stren Rank Proximate Underlyi who where 7 SELECT HERE SELECT HERE SELECT HERE 8 SELECT HERE SELECT HERE 9 SELECT HERE SELECT HERE 10 SELECT HERE SELECT HERE SELECT HERE 4 SELECT HERE SELECT HERE SELECT HERE 321 D i4 4 PN Enhanced Situational Analysis Sa Draw gt Lg AutoShapes DO 6 4 Ra d L A 5E0S Ready NUM 7 Since resources are scarce and implementation capabilities are limited we need to prioritize or rank the long list of identified problems to fin
Download Pdf Manuals
Related Search