#### STICHTING BAKENS VERZET

#### 1018 AM AMSTERDAM, THE NETHERLANDS

Director,

T.E.(Terry) Manning,

Schoener 50,

1771 ED Wieringerwerf,

The Netherlands.

Tel: 0031-227-604128

Homepage: http://www.flowman.nl

E-mail: (nameatendofline)@xs4all.nl : bakensverzet

## MODEL FOR SUSTAINABLE SELF-FINANCING INTEGRATED RURAL AND POOR URBAN DEVELOPMENT FOR THE WORLD'S POOR

Incorporating innovative social, financial, economic, local administrative and productive structures, numerous renewable energy applications, with an important role for women in poverty alleviation in rural and poor urban environments.

"Money is not the key that opens the gates of the market but the bolt that bars them"

Gesell, Silvio The Natural Economic Order

Revised English edition, Peter Owen, London 1958, page 228

Edition 02: 31 October, 2007

(EN FRANÇAIS)

##### EXCEL FILES FOR THE PREPARATION OF GRAPHS

The files listed below are very simple technical files. They are designed to act as a guide to help users who are not familiar with Excel spreadsheets prepare the basic material for the various graphs included in the project documentation.

The spread-sheet information to be filled in will vary with each project. These variations will include budget item numbers, the amounts covered, and the periods over which the money is spent.

The graph type is usually “simple grouped columns” which are “organised in rows”. The legend is usually placed under the graph. The “X” or horizontal line is “Activity according to budget”. The “Y” or vertical line is the “Amount in (Euro)”.

EXCEL FILE FOR THE BUDGET

Excel file for the budget.

##### EXCEL FILES FOR TYPICAL QUARTERLY ACTIVITIES AND EXPENDITURE

A single graph covering totals for each individual project item is not readable.

Excel file showing total outgo for each quarter.

Excel file for activities first quarter.
Excel file for activities second quarter.
Excel file for activities third quarter.
Excel file for activities fourth quarter.
Excel file for activities fifth quarter.
Excel file for activities sixth quarter.
Excel file for activities seventh quarter.
Excel file for activities eighth quarter.

##### EXCEL FILES FOR TYPICAL BUDGETED ACTIVITIES QUARTER BY QUARTER

Excel file for personnel, items 1010101-20201.
Excel file for equipment, items 30101-3040104.
Excel file for vehicles, project offices, items 40101-40404.
Excel file for formalities, items 5010-50901.
Excel file for hygiene education, items 60101-60203.
Excel file for financial structures, items 60301-60505.
Excel file for productive structures, items 60601-60806.

Excel file for drinking water and sanitation facilities, items 60901-61006.
Excel file for other activities, including boreholes, items 61101-70101.
Excel file for supply contracts, items 70201-70221.
Excel file for consultants, items 70301-70306.

##### EXCEL FILE FOR THE MICRO-CREDITS DEVELOPMENT GRAPH.

Budget items involving interest-free loans for productivity purposes are paid back over a reasonable period of time, which is agreed between the project management and the beneficiaries concerned. Which items are included and the rate of repayment vary from case to case.

The average period for the repayment of loans under the interest-free micro-credit system is shown in the graph as 24 months, or 8 quarters. This is thought to be a very conservative estimate. Shorter average payback times will lead to a larger total value of loan transactions.

Excel file for the micro-credits graph.

##### EXCEL FILE FOR THE ACTIVITIES SHEET.

Excel file for the activities sheet.

Forward: Short analysis of the budget.

Back: quarterly expenditure.

Menu group 7 work files: Financial justification.

Main menu for project work file groups.

Complete index of the project work files.

Main menu for the Model.

Homepage Bakens Verzet