Initiation of the sheet:
The total of [left over] sums of last month is divided in three categories [Forum decision].
What is to be [re-] inserted as 'O' [ Forum fund ], what is to be [re-] inserted as
'P' [
Community fund]
and what is to be deposited as Ba-in [as 'insentive' to the collective income to
the eminent cycle].
example:
Transferred from
last month ► € 841,- Forum decided: 'O'►€ 250,- 'P'►€ 350,-
Ba-in ►€
241,-
Open Excel
[ verify macro security setting to low (see
'readme.txt' in the zipfile)
] and open the sheet.
place cii0 in C5, 0 in C6, 40 in C7, 241,00 in C11, hit Save-iT [or
Opslaan], click reset.
place dsp in C5, 600,00 in C11, hit Save-iT [or Opslaan], click OK in
'Béko mi Dan'.
place ─350,00
in C11, hit Save-iT [or Opslaan], click reset [or Store File].
your sheet is ready.
Insert 1st member [replaces Cii0]
place i in C12 fill in column O20-O25, hit Save-iT [or Opslaan]
Insert
expences [see/click
B4
Quick steps in
the sheet]
place s in C12. fill in column G4-G9 correspondent to column
G12-G17
|