Windsor Group

Notes

Friday, February 21, 2020 TEST

UNIT	ON HAND BEFORE		ON HAND AFTER
UNIT	Qty.	Sum	Qty.	Sum
$20	1	$20	2	$40
$10	2	$20	1	$10
$5	2	$10	2	$10
$2	6	$12	6	$12
$1	4	$4	4	$4
$0.25	36	$9.00	36	$9.00
$0.10	101	$10.10	1	$0.10
$0.05	71	$71	71	$3.55
TOTAL	$88.65		$88.65

Wednesday, February 19, 2020
- exchanged 2 rolls of 50 dimes (value of $10) and one of the two $10 bills for a $20 bill
UNIT ON HAND
BEFORE ON HAND
AFTER

$20 1 2

$10 2 1

$5 2 2

$2 6 6

$1 4 4

$0.25 36 36

$0.10 101 1

$0.05 71 71

TOTALS $88.65 $88.65

UNIT	ON HAND BEFORE	ON HAND AFTER
$20	1	2
$10	2	1
$5	2	2
$2	6	6
$1	4	4
$0.25	36	36
$0.10	101	1
$0.05	71	71
TOTALS	$88.65	$88.65

Thursday, February 13, 2020
- exchanged all 10 toonies for a $20 bill
UNIT ON HAND
BEFORE ON HAND
AFTER

$20 0 1

$10 2 2

$5 2 2

$2 10 0

$1 2 2

$0.25 33 33

$0.10 99 99

$0.05 71 71

TOTALS $73.70 $73.70

UNIT	ON HAND BEFORE	ON HAND AFTER
$20	0	1
$10	2	2
$5	2	2
$2	10	0
$1	2	2
$0.25	33	33
$0.10	99	99
$0.05	71	71
TOTALS	$73.70	$73.70

Monday, February 10, 2020 [NOTE 2/2]
- paid rent (used all 5 $20 bills):
UNIT ON HAND
BEFORE ON HAND
AFTER

$20 5 0

$10 2 2

$5 2 2

$2 10 10

$1 2 2

$0.25 29 29

$0.10 99 99

$0.05 71 71

TOTALS $172.70 $72.70

UNIT	ON HAND BEFORE	ON HAND AFTER
$20	5	0
$10	2	2
$5	2	2
$2	10	10
$1	2	2
$0.25	29	29
$0.10	99	99
$0.05	71	71
TOTALS	$172.70	$72.70

Monday, February 10, 2020 [NOTE 1/2]
- exchanged 10 loonies and a 40 unit roll of quarters for a $20 bill:
UNIT ON HAND
BEFORE ON HAND
AFTER

$20 4 5

$10 2 2

$5 2 2

$2 10 10

$1 12 2

$0.25 69 29

$0.10 99 99

$0.05 71 71

TOTALS $172.70 $172.70

UNIT	ON HAND BEFORE	ON HAND AFTER
$20	4	5
$10	2	2
$5	2	2
$2	10	10
$1	12	2
$0.25	69	29
$0.10	99	99
$0.05	71	71
TOTALS	$172.70	$172.70

Thursday, December 05, 2019 — 7th Totals to date including 7th from December 03, 2019 ($8.25)

UNIT	MySQL	ON HAND	FROM 7TH	NEW TOTAL (MySQL)	NEW TOTAL (on hand)
$20	n/a	3	0	n/a	3
$10	2	1	0	2	1
$5	7	3	1	8	4
$2	28	3	0	28	0
$1	75	15	3	78	18
$0.25	104	24	1	105	25
$0.10	64	64	7	71	71
$0.05	55	55	3	58	58
TOTAL	222.00	122.00	$8.25	230.25	130.25

Tuesday, December 03, 2019 — 7th Totals to date including 7th from November 26, 2019 (13.10)

UNIT	MySQL	ON HAND	FROM 7TH	NEW TOTAL (MySQL)	NEW TOTAL (on hand)
$20	n/a	3	0	n/a	3
$10	2	1	0	2	1
$5	6	2	1	7	3
$2	27	2	1	28	3
$1	72	12	3	75	15
$0.25	95	15	9	104	24
$0.10	64	64	7	71	71
$0.05	55	55	3	58	58
TOTAL	208.90	108.90	13.10	222.00	122.00

Tuesday, November 26, 2019 — 7th Totals to date including 7th from November 19, 2019 ($5)

UNIT	ON HAND	FROM 7TH	NEW TOTAL
$20	3	0	3
$10	1 [MySql: 2]	0	1
$5	2 [MySql: 6]	0	2
$2	2 [MySql: 27]	0	2
$1	7 [MySql: 67]	5	12 [72]
$0.25	15 [MySql: 95]	0	15 [95]
$0.10	64	0	64
$0.05	55	0	55
TOTAL	203.90	5.00	208.90

Tuesday, November 19, 2019 — 7th Totals to date including 7th from November 12, 2019 ($2.40)

UNIT	ON HAND	FROM 7TH	NEW TOTAL
$20	3	0	3
$10	1	0	1
$5	2	0	2
$2	2 (27 - 25 exchanged for loonies)	0	2
$1	6 [66 according to MySQL]	1	7 [67]
$0.25	12 [92 according to MySQL]	3	15 [95]
$0.10	58	6	64
$0.05	54	1	55
TOTAL	201.50	2.40	203.90

Friday, November 08, 2019 [NOTE 1/2]
- No meeting on November 5, 2019: St. Luke's not available.
Friday, November 08, 2019 [NOTE 2/2]
- Exchanged 25 toonies ($50) and 80 quarters ($20) for 70 loonies at RBC
  - I put 3 $20s and 1 $10 for a total of $70 in the bills can

Wednesday, October 30, 2019 [NOTE 3/3]
- gave St. Luke's $100 for rent
Wednesday, October 30, 2019 [NOTE 2/3]
- took all 4 $20 bills (the 3 that I had exchanged for loonies and the one from last night's 7th) and 4 of the $5 bills for a total of $100 to pay rent to St. Luke's
- NULL
Wednesday, October 30, 2019 [NOTE 1/3] — 7th Totals to date including 7th from October 29, 2019 ($29.95)

UNIT ON HAND FROM 7TH NEW TOTAL

$10 0 2 (actually, one $20 bill) 2

$5 4 1 5

$2 27 0 27

$1 4 (+ 60) 2 66

$0.25 84 8 92

$0.10 49 9 58

$0.05 53 1 54

TOTAL 171.55 29.95 201.50

UNIT	ON HAND	FROM 7TH	NEW TOTAL
$10	0	2 (actually, one $20 bill)	2
$5	4	1	5
$2	27	0	27
$1	4 (+ 60)	2	66
$0.25	84	8	92
$0.10	49	9	58
$0.05	53	1	54
TOTAL	171.55	29.95	201.50

Friday, October 25, 2019 — 7th Totals to date including 7th from October 22, 2019 ($6.90)

UNIT ON HAND FROM 7TH NEW TOTAL

$10 0 0 0

$5 4 1 5

$2 27 0 27

$1 3 (+ 60) 1 64

$0.25 81 3 84

$0.10 49 0 49

$0.05 50 3 53

TOTAL 164.65 6.90 171.55

UNIT	ON HAND	FROM 7TH	NEW TOTAL
$10	0	0	0
$5	4	1	5
$2	27	0	27
$1	3 (+ 60)	1	64
$0.25	81	3	84
$0.10	49	0	49
$0.05	50	3	53
TOTAL	164.65	6.90	171.55

Friday, October 18, 2019 [NOTE 2/2]
- exchanged 20 of the 23 loonies for a $20 bill
- therefore, there are 3 loonies left on hand but 63 according to MySQL database

Friday, October 18, 2019 [NOTE 1/2] — 7th Totals to date including 7th from October 15, 2019 ($8.00)
- 10s = 0 + 0 = 0
- 5s = 4 + 0 = 4
- $2 = 26 + 1 = 27
- $1 = 19 + 4 + 40 = 23 (63)
- $0.25 = 76 + 5 = 81
- $0.10 = 43 + 6 = 49
- $0.05 = 47 + 3 = 50
- TOTAL = $156.65 + $8.00 = $164.65

Thursday, October 10, 2019 — 7th Totals to date including 7th from October 08, 2019 ($6.60)
- 10s = 0 + 0 = 0
- 5s = 4 + 0 = 4
- $2 = 24 + 2 = 26
- $1 = 17 + 2 = 19 (59)
- $0.25 = 74 + 2 = 76
- $0.10 = 42 + 1 = 43
- $0.05 = 47 + 0 = 47
- TOTAL = $150.05 + $6.60 = $156.65

Monday, October 07, 2019 [NOTE 2/3] — 7th Totals to date including 7th from October 01, 2019 ($3.50)
- 10s = 0
- 5s = 4
- $2 = 24
- $1 = (55 + 2) - 40 = 17
- $0.25 = 71 + 3 = 74
- $0.10 = 36 + 6 = 42
- $0.05 = 44 + 3 = 47
- TOTAL = $146.55 + $3.50 = $150.05
Monday, October 07, 2019 [NOTE 1/3]: Because the loonie count was off by two (per the entry dated Monday, September 23, 2019), I added 2 loonies from the 40 that I exchanged for 2 twenty dollar bills (once on Tuesday, September 17, 2019 and then again on Monday, September 23, 2019), bringing the count back in accord with database totals for loonies (55 - 40 = 15

Monday, October 07, 2019 [NOTE 3/3] — 7th Totals to date including 7th from September 24, 2019 ($2.20)
- 10s = 0
- 5s = 4
- $2 = 0
- $1 = (54 - 40) = 14 + 1 = 15 (but only had 13 loonies)
- $0.25 = NULL
- $0.10 = NULL
- $0.05 = NULL
- TOTAL = $144.35 (- $2*) + $2.20 = $146.55

Monday, September 23, 2019 — 7th Totals to date including 7th from September 17, 2019 ($7.65)
- 10s = 0
- 5s = 4
- $2 = 24
- $1 = (49 - 40) + 5 = 12 (but I should have 14 -- see note dated Monday, September 23, 2019)
- $0.25 = 69
- $0.10 = 31
- $0.05 = 40
- TOTAL = $136.70 + $7.65 = $144.35 (- $2*)

Monday, September 23, 2019
- Exchanged a $20 bill for 20 loonies
- According to the MySQL database, I should have 9 loonies left (49 - 20 - 20) but I only have 7 loonies left

Tuesday, September 17, 2019
- Exchanged a $20 bill for 20 loonies. Note, this exchange was done before the seventh totals for the September 17th meeting were added -- the totals for the September 17th meeting were not added until Monday, September 23, therefore, after this exhange, there would have been 29 loonies left.

Wednesday, September 11, 2019 — 7th Totals to date including 7th from September 10, 2019 ($12.60)
- 10s = 0
- 5s = 4
- $2 = 24
- $1 = 49
- $0.25 = 61
- $0.10 = 26
- $0.05 = 37
- TOTAL = $124.10 + $12.60 = $136.70

Wednesday, September 04, 2019 — 7th Totals to date including 7th from September 3 ($4.05)
- TOTAL = $120.05 + $4.05 = $124.10

Wednesday, August 28, 2019 — 7th Totals to date including 7th from August 20 and 27, 2019 ($2 + $15.35 = $17.35)
- 10s = 0
- 5s = 3
- $2 = 22
- $1 = 42
- $0.25 = 59
- $0.10 = 25
- $0.05 = 36
- TOTAL = $102.70 + $17.35 = $120.05

Friday, August 16, 2019 — 7th Totals to date including 7th from Tuesday, August 13, 2019 ($2.75)
- 10s = 0
- 5s = 1
- $2 = 22
- $1 = 39
- $0.25 = 44
- $0.10 = 21
- $0.05 = 32
- TOTAL = $99.95 + $2.75 = $102.70

Friday, August 16, 2019 — 7th Totals to date including 7th from August 7, 2019 ($MEETING7TH)
- TOTAL = $94.20 + $5.75 = $99.95

Thursday, August 01, 2019 — 7th Totals to date including 7th from July 30, 2019 ($5.50)
- 10s = 0
- 5s = 1
- $2 = 21
- $1 = 34
- $0.25 = 38
- $0.10 = 21
- $0.05 = 32
- TOTAL = $88.70 + $5.50 = $94.20

Thursday, August 01, 2019 — 7th Totals to date including 7th from July 23, 2019 ($2.50)
- 10s = 0
- 5s = 1
- $2 = 19
- $1 = 33
- $0.25 = 36
- $0.10 = 21
- $0.05 = 32
- TOTAL = $86.20 + $2.50 = $88.70

Tuesday, July 23, 2019 — 7th Totals to date including 7th from July 16, 2019 ($13.00)
- 10s = not counted
- 5s = not counted
- $2 = not counted
- $1 = not counted
- $0.25 = not counted
- $0.10 = not counted
- $0.05 = not counted
- TOTAL = $73.20 + $13.00 = $86.20

Wednesday, July 10, 2019 — 7th Totals to date including 7th from July 9, 2019 ($17.05)
- 10s = 0
- 5s = 1
- $2 = 15
- $1 = 27
- $0.25 = 31
- $0.10 = 19
- $0.05 = 31
- TOTAL = $56.15 + $17.05 = $73.20

Thursday, July 4, 2019 — 7th Totals to date including 7th from July 3, 2019 ($12.90)
- 10s = 0
- 5s = 0
- $2 = 2
- $1 = 7
- $0.25 = 7
- $0.10 = 1
- $0.05 = 1
- TOTAL = $43.25 + $12.90 = $56.15

Wednesday, June 26, 2019
- Went down to TD and finally got banking straightened out
- Withdrew $100 for rent from ATM using new card
- paid St. Luke's $100 in rent

Wednesday, June 26, 2019 — 7th Totals to date including 7th from June 25, 2019 ($14.00)
- 10s = 0
- 5s = 1
- $2 = 6
- $1 = 18
- $0.25 = 20
- $0.10 = 18
- $0.05 = 29
- TOTAL = $29.25 + $14.00 = $43.25

Wednesday, June 26, 2019 — 7th Totals to date including 7th from June 18, 2019 ($2.75)
- 10s = 0
- 5s = 1
- $2 = 2
- $1 = 10
- $0.25 = 20
- $0.10 = 18
- $0.05 = 29
- TOTAL = $26.50 + $2.75 = $29.25

Thursday, June 13, 2019 — 7th Totals to date including 7th from June 11, 2019 ($2.00)
- 10s = 0
- 5s = 1
- $2 = 1
- $1 = 12
- $0.25 = 19
- $0.10 = 15
- $0.05 = 25
- TOTAL = $24.50 + $2.00 = $26.50
I didn't actually count everything since I was only adding two loonies

Saturday, June 8, 2019 — 7th Totals to date including 7th from June 4, 2019 ($8.55)
- 10s = 0
- 5s = 1
- $2 = 1
- $1 = 10
- $0.25 = 19
- $0.10 = 15
- $0.05 = 25
- TOTAL = $15.95 + $8.55 = $24.50

Thursday, May 30, 2019

Added May 28 seventh and counted totals by hand. Hand count matches database (wg7th__2019_0521) totals:
- 10s = 0
- 5s = 0
- $2 = 1
- $1 = 7
- $0.25 = 17
- $0.10 = 15
- $0.05 = 24
- TOTAL = $15.95

Thursday, April 04, 2019

just checked total loonies: total on hand, 65, matches record
substituting two $20 bills (i.e., $40) for 40 loonies
THERE ARE NOW 16 LOONIES ON HAND

at some point I'm pretty sure I exchanged loonies for a bill ($5 or $10 -- not sure)

Tue, Sep 18, 2018: took $5 bill from current 7th to pay for Chase the Ace and need to replace it

Sun, Oct 07, 2018: paid the $5 back from Tue, Sep 18, 2018

Thu, Oct 18, 2018: exchanged all 24 loonies and 4 quarters from the 'new' 7th for a $20 bill and a $% bill

Fri, Oct 19, 2018: deposited $123.05 into Windsor Group TD account5

Dec 18, 2018: Tyler L. opened and chaired meeting. 7th is documented in the log as being $10.75 but, for reasons I will describe below, may have been $10.80.

Jan 01, 2019: Al Q. opened and chaired meeting. 7th is documented in the log as being $5.25.

Wed, Jan 09, 2019: Al Q. brought me 7th from Dec 18, 2018 and Jan 01, 2019 meetings in an envelope with a note that says "7th -> 9.75 $" on one line and then below that "Jan 1st/2019 5.25 $" which should total $15 but envelope actually contains $16.80 in the following denominations:

$5 bill = 3 ($15.00/$15.00)
loonie = 1 ($1.00/$16.00)
quarters = 2 ($0.50/$16.50)
dimes = 2 ($0.20/$16.70)
nickles = 2 ($0.10/$16.80)

Fri, Jan 11, 2019: for record keeping purposes I have decided to enter into the database a total of $11.00 for Dec 18, 2018 ($5 bill x 2; loonie x 1) a total of $5.80 for Jan 09 ($5 x 1; quarters x 2; dimes x 2; nickles x 2

Thu, Jan 17, 2019: reconciled 7th on hand with info in database for October 23 to present

there were discrepancies with three denominations: twoonies (9 on hand versus 11 in database); loonies (27 on hand versus 25 in database; quarters (74 on hand versus 70 in database)
to reconcile the 7th on hand with the info in the database I: replaceed two loonies from the 7th with one of my twoonies; I took the four excess quarters out of the 7th and replaced them with another one of my twoonies
7th on hand now matches info in database:
- $5 = 5 ($25)
- $2 = 11 ($22)
- $1 = 25 ($25)
- $0.25 = 70 ($17.50)
- $0.10 = 72 ($7.20)
- $0.05 = 35 ($1.75)
total = $98.45