[sudo-discuss] proposed costs-sharing spreadsheet for the omni collective

[Jake]

I think it would be even better if someone could color in the charts, 
map-style so that each room was a different color, and then use gimp or 
photoshop or whatever to actually measure the amount of square footage of 
each "region", and then that data could go in the spreadsheet.

the more complete and accurate this mapping is, the more easily we will be 
able to dynamically and fairly allocate space to whatever groups need it. 
For example, a sudoroom member might need a closet somewhere for stuff and 
be willing to pay for the space, and the Omni collective might want to 
"rent" some random utility closet to them for that purpose.  Having the 
ability to tick a box in a spreadsheet to section off that utility room 
(and automatically calculate its fair rental price) would be very useful.

here's a colored map of the USA, for reference:
http://i.imgur.com/GM0v1qm.png

On Fri, 25 Apr 2014, Patrik D'haeseleer wrote:

> Excellent! Here's the links to my annotated floor plan (1pixel = 1 inch) and spreadsheet with measured square footage:
> Omni_main_floor.png: https://drive.google.com/file/d/0Bx0m7X6dHC0mVjBfUDE2VjN4OW8/edit?usp=sharing
> 
> Omni_basement.png: https://drive.google.com/file/d/0Bx0m7X6dHC0mU0pTOFh5LW1CbFU/edit?usp=sharing
> 
> Omni_top_floor.png: https://drive.google.com/file/d/0Bx0m7X6dHC0mUUFCdmUtcXFVRUE/edit?usp=sharing
> 
> Omni_rooms spreadsheet: https://docs.google.com/spreadsheets/d/17DINigEczGwjfTdmdxl-MpYe1KJzJJDeCHRQnMC9usg/edit?usp=sharing
> 
> I sent these out before as files, but these are on google docs, so everyone can start editing the spreadsheet. Please use the same numbering of the rooms, so we have
> unique identifiers for them.
> 
> Patrik
> 
> 
> On Thu, Apr 24, 2014 at 9:13 PM, Jake <jake at spaz.org> wrote:
>       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 at lists.sudoroom.org
>       https://lists.sudoroom.org/listinfo/sudo-discuss
> 
> 
> 
>