I like playing with spreadsheets and am happy to take a poke sometime this weekend.  :)

Emily



On Fri, Jun 3, 2022 at 5:57 PM <lauradi@rcn.com> wrote:
  Months ago, people requested a google sheet with our finances.  There is no template for that in Sheets (what the heck, google?) so I have asked youtube, but some things I am doing are not right.
The first problem is that I don't know how to share it with everybody on the attendance spreadsheet list. This is the link to the numbers from the last 2.5 years. I hope.
https://docs.google.com/spreadsheets/d/15SZzAuxhWkPWrCHGyTsrSsW1Bp68eAqDrPG8YWw20I8/edit 
I tried to put the formula =(g2-e3+f3)in cell g3, and it worked for that one line, but I can't figure out how to generalize. It seems possible that I should use a different formula and put negative signs in front of each expense number. 
   Somebody, please stop rolling your eyes and fix it, then share it. I made up an opening balance because it was a nice number and I'm a little queasy about telling the world how much money we actually have, but am happy to tell people privately. There will be two more entries almost immediately (June 4 wedding fee from newlyweds, wedding payment to ringers). I have many other money topics to discuss the next time we have a meeting.
   If you're buying pounds it seems like a pretty good time.

Laura Dickerson

_______________________________________________
Boston-change-ringers mailing list
Boston-change-ringers@cosmos.phy.tufts.edu
https://cosmos.phy.tufts.edu/mailman/listinfo/boston-change-ringers