THE SPREADSHEET CALCULATES AMOUNTS OWING FOR MAINTENANCE BY EACH PROPERTY OWNER ON A PRIVATE DEAD-END ROAD      Some screens here.        Download spreadsheet here.


Application:        
This spreadsheet calculates costs of snowplowing or road maintenance with options for seasonal/full-time and other weights.
                           
Cost sharing formula:     
Based on a pro-rata approach: Each parcel owner’s share of costs incurred is determined as follows: Pro-rated cost share is based upon the percentage of roadway extending from the start of the Private Road to the intersection of each driveway (can use mid-point) where a residence exists.
                           
Doubts on cost-sharing  approach?   
See the CostSharingOptions sheet. Please note that for a private road exiting at both ends onto a public road the best cost-sharing approach is probably an equal split among all property owners, barring other factors such as seasonal versus full-time use, commercial versus homes, etc.               

Where to start:   
Begin by inputting data on the InputSheet. You will enter a name/address, then the distance from the public road to each driveaway (driveway mid-point, say in miles, km, feet or metres, as you like) for each property access. Enter OTHER and SEASONAL WEIGHTS. For snow removal, for example, some residents may only use their properties a few times in winter, so they may be assigned a WEIGHT  between 0% & 100%. OTHER WEIGHTS can be used to account for hilly terrain, flat road, etc. This can be less than or more than 100%. Finally, place an X beside each OWNER's name that is participating in the cost-sharing, presumably all for summer road maintenance but maybe a smaller number of names if the sheet is being used for snow-removal cost-sharing.
                           
What happens:   
The InputSheet will calculate and filter the rows containing Active (X) OWNERS and produce side by side results. It will also output a table into the ACCOUNTS sheet where date and payment information can be entered for each owner against that OWNER's allocated cost. After all data has been entered on the InputSheet, only the ACCOUNTS sheet should be used. If changes to the number of ACTIVE OWNERS is made on the InputSheet, the ACCOUNTS figures may become misaligned, requiring re-entry.
The INVOICES Sheet can be used for keeping a record of Contractor costs.

Questions?    mail@georgezurakowski.com
(October, 2020)