i made a spreadsheet to calculate proportional cost sharing for a space with private and common space:

https://docs.google.com/spreadsheet/ccc?key=0AktkZZru71ymdEFUSUtCSnQ5TXFfaE9wRWxTV1pSV2c&usp=sharing

anyone with the link above can edit the spreadsheet.  please feel free to make changes to get a feel for how it works, but put things back with undo unless you've made improvements.

feel free to fork it by making your own copy of it, either on google drive or by downloading it as a file and playing with it in a program such as libreoffice.

the way it works is that you start by entering in the total monthly costs that the omni collective is going to need to come up with.  Like many things in life, this number is something we can't directly control so we enter it in as a given.

the next info we enter are the various rooms/spaces that we predict might become sectioned off for non-common uses.  We enter the dimensions or square footage of those rooms and the other numbers change to reflect the proportion of total space used by those rooms / subcollectives / groups.

the other thing we can adjust is the "percentage of costs shared equally" because simply using the actual percentage of space that is not private may not result in equitable costs-sharing among the groups.  So while actual percentage is calculated and displayed, the number we use to calculate cost sharing is something you can type in whatever you want.

I put in 40% to see what it would come up with.

do you think this is helpful?

-jake
_______________________________________________
sudo-discuss mailing list
sudo-discuss@lists.sudoroom.org
https://lists.sudoroom.org/listinfo/sudo-discuss