coeficiente de cobertura

Upload: joelvalladolidpravia

Post on 07-Jan-2016

214 views

Category:

Documents


0 download

DESCRIPTION

tabla de excel para determinar los coeficientes de cobertura

TRANSCRIPT

Coeficiente de coberturaLOTE ALOTE BLOTE CLOTE DLOTE ELOTE F

Q1AAREA (m2)CQ1BAREA (m2)CQ1CAREA (m2)CQ1DAREA (m2)CQ1EAREA (m2)CQ1FAREA (m2)CVereda0.992.2583.025Vereda0.969.7562.775Vereda0.969.7562.775Vereda0.992.2583.025Vereda0.962.2556.025Vereda0.962.2556.025Lotes 0.9900810Lotes 0.9506.25455.625Lotes 0.9506.25455.625Lotes 0.9900810Lotes 0.9400360Lotes 0.9400360REA TOTAL992.25893.025Calles 0.85174.125148.00625Calles 0.85174.125148.00625Calles 0.9388.5349.65Calles 0.9279251.1Calles 0.9268.5241.65C*0.900REA TOTAL750.125666.4060.910.59.45REA TOTAL1380.751242.675REA TOTAL741.25667.125REA TOTAL730.75657.675C*0.888REA TOTAL760.625675.85625C*0.9C*0.9C*0.9Q2AAREA (m2)CC*0.889Vereda0.992.2583.025Q2BAREA (m2)CQ2DAREA (m2)CQ2EAREA (m2)CQ2FAREA (m2)CLotes 0.9900810Vereda0.969.7562.775Q2CAREA (m2)CVereda0.992.2583.025Vereda0.962.2556.025Vereda0.962.2556.025Calles 0.9388.5349.65Lotes 0.9506.25455.625Vereda0.969.7562.775Lotes 0.9900810Lotes 0.9400360Lotes 0.9400360REA TOTAL1380.751242.675REA TOTAL576518.4Lotes 0.9506.25455.625REA TOTAL992.25893.025REA TOTAL462.25416.025REA TOTAL462.25416.025C*0.900C*0.900REA TOTAL576518.4C*0.9C*0.9C*0.9C*0.900Q3AAREA (m2)CQ3BAREA (m2)CQ3DAREA (m2)CQ3EAREA (m2)CQ3FAREA (m2)CVereda0.9152.25137.025Vereda0.9137.25123.525Q3CAREA (m2)CVereda0.9152.25137.025Vereda0.9152.25137.025Vereda0.9152.25137.025Lotes 0.921001890Lotes 0.91518.751366.875Vereda0.9137.25123.525Lotes 0.921001890Lotes 0.916001440Lotes 0.916001440REA TOTAL2252.252027.025REA TOTAL16561490.4Lotes 0.91518.751366.875REA TOTAL2252.252027.025Calles 0.85360.5306.425Calles 0.85360.5306.425C*0.900C*0.900Calles 0.85331.625281.881C*0.90.910.59.450.910.59.45REA TOTAL1987.6251772.281REA TOTAL2123.251892.9REA TOTAL2123.251892.9Q4AAREA (m2)CQ4BAREA (m2)CC*0.892Q4DAREA (m2)CC*0.892C*0.892Vereda0.976.12568.5125Vereda0.9137.25123.525Vereda0.9152.25137.025Lotes 0.91050945Lotes 0.91518.751366.875Q4CAREA (m2)CLotes 0.921001890Q4EAREA (m2)CQ4FAREA (m2)CCalles 0.85180.25153.2125Calles 0.85331.625281.881Vereda0.968.62561.7625Calles 0.85360.5306.425Vereda0.9152.25137.025Vereda0.9152.25137.025REA TOTAL1306.3751166.725REA TOTAL1987.6251772.281Lotes 0.9759.375683.43750.910.59.45Lotes 0.916001440Lotes 0.916001440C*0.893C*0.892Calles 0.9289.5260.55REA TOTAL2623.252342.9Calles 0.85360.5306.425REA TOTAL1752.251577.025REA TOTAL1117.51005.75C*0.8930.910.59.45C*0.9Q5AAREA (m2)CC*0.900REA TOTAL2123.251892.9Vereda0.976.12568.5125REA TOTAL DEL LOTE B4969.7504447.488REA TOTAL DEL LOTE D7248.56505.625C*0.892REA TOTAL DEL LOTE D5068.54543.625Lotes 0.91050945C* TOTAL DEL LOTE B0.895Q5CAREA (m2)CC* TOTAL DEL LOTE D0.898C* TOTAL DEL LOTE D0.896Calles 0.85180.25153.2125Vereda0.968.62561.7625REA TOTAL DEL LOTE D54504868.950.910.59.45Lotes 0.9759.375683.4375C* TOTAL DEL LOTE D0.893REA TOTAL1316.8751176.175Calles 0.9279251.1C*0.893REA TOTAL1107996.3AREA TOTAL DE LA URB35534.00031839.900C*0.900C* TOTAL DE LA URBANIZACION0.896

REA TOTAL DEL LOTE A7248.56505.625C* TOTAL DEL LOTE A0.898REA TOTAL DEL LOTE C5548.754968.5875C* TOTAL DEL LOTE C0.895