一种比较适用的电子表房屋公摊方法

1、,一幢比较典型的多功能房屋平面示意图,表一：原始数据输入表,楼层,用途,套内,共用面积,合计,共用面积服务对象说明,1单元梯,2单元梯,3单元梯,茶楼梯,外墙1/2,小计,1,商业,878.40 ,18.00 ,18.00 ,18.00 ,21.6,15.76,969.76 ,969.76 ,2,住宅+茶楼,878.40 ,18.00 ,18.00 ,18.00 ,21.6,15.76,969.76 ,969.76 ,1.黄色为通过商业区的住宅1单元专用梯,3,住宅,900.00 ,18.00 ,18.00 ,18.00 ,15.76,969.76 ,969.76 ,2.红色为通过商、茶区的住

2、宅2单元专用梯,4,住宅,900.00 ,18.00 ,18.00 ,18.00 ,15.76,969.76 ,969.76 ,3.深兰色为通过商、茶区的住宅3单元专用梯,5,住宅,900.00 ,18.00 ,18.00 ,18.00 ,15.76,969.76 ,969.76 ,4.天兰色为通过商业区的茶楼专用梯,6,住宅,900.00 ,18.00 ,18.00 ,18.00 ,15.76,969.76 ,969.76 ,5.绿色分别为住宅各功能区所在层的专用梯,屋面梯,19.84,19.84,19.84,59.52 ,59.52 ,6.土黄色为属于全摊分摊的屋顶梯和外墙1/2,合计,5

3、356.80 ,127.84 ,127.84 ,127.84 ,43.2,94.56,5878.08 ,5878.08 ,表二：表格法公摊计算表,编号,功能区,套内,共用面积（根据表一中的服务对象，确定分区与分级范围）,合计,公摊系数,1级区内,2级区间,3级区间,4级区间,5级区间,6级幢内,(自摊),(商+茶),(商+住1),(商+茶+住2),(商+茶+住3),(全幢楼),1,商业,878.40 ,878.40 ,12.02 ,890.42 ,8.09 ,898.51 ,11.23 ,909.74 ,9.92 ,919.67 ,24.76 ,944.42 ,0.075164 2,茶楼,67

4、8.41 ,21.60 ,700.01 ,9.58 ,709.58 ,8.87 ,718.45 ,7.84 ,726.29 ,19.55 ,745.84 ,0.099404 3,住宅1单元,999.98 ,90.00 ,1089.98 ,9.91 ,1099.88 ,29.61 ,1129.49 ,0.129517 4,住宅2单元,1200.00 ,72.00 ,1272.00 ,15.90 ,1287.90 ,34.67 ,1322.57 ,0.102140 5,住宅3单元,1600.02 ,72.00 ,1672.02 ,18.24 ,1690.26 ,45.50 ,1735.76 ,0.

5、084835 合计,5356.80 ,255.60 ,1578.41 ,21.60 ,1980.40 ,18.00 ,2880.10 ,36.00 ,3300.22 ,36.00 ,5724.00 ,154.08,5878.08 ,分摊原则：按梯步型原则：“从低到高、从小到大、从局部到整体。”,表三：公式法公摊计算表,编号,功能区,套内,通用公式表达式：Ki=（1+E1/F1）（1+E2/F2）（1+En/Fn）-1,公摊系数,公摊面积,还原面积1,商业,878.40 ,K=(1+21.60/1578.41)*(1+18.00/1980.40)*(1+36.00/2880.10)*(1+36.

6、00/3300.22) *(1+154.08/5724.00)-1,0.075164489,66.02 ,944.42 2,茶楼,678.41 ,K=(1+21.60/678.41)*(1+21.60/1578.41)*(1+36.00/2880.10)*(1+36.00/3300.22) *(1+154.08/5724.00)-1,0.099404479,67.44 ,745.84 3,住宅1单元,999.98 ,K=(1+90.00/999.98)*(1+18.00/1980.40)*(1+154.08/5724.00)-1,0.129517005,129.51 ,1129.49 4,住宅2单元,1200.00 ,K=(1+72.00/1200.00)*(1+36.00/2880.10)*(1+154.08/5724.00)-1,0.10214 ,122.57 ,1322.57 5,住宅3单元,1600.02 ,K=(1+72.00/1600.02)*(1+36.00/3300.22)*(1+154.08/5724.00