Spreadsheet: 148850d1333576827-area-between-weird-curves-made-out-of-lines-math-problem-copy-of-area-between-lines-1
Sheet: MrShortylinear

 | CALCULO DE DOSIFICACION OPTIMA PARA HORMIGONES
 |  |  |  |  |  | Para curva Bolomey
 |  | Tamanho maximo del arido, D ([NAME]): |  | 50 |  | Valor "a": | 11
 |  | [NAME] (ASTM: | 2" | 1 1/2" | 1" | 3/4" | 1/2" | 3/8" | No. 4 | No. 16 | No. 50 | No. 100 | No. 200
 |  | Tamiz, d (mm): | 50 | 37.5 | 25 | 19 | 12.5 | 9.5 | 4.75 | 1.18 | 0.3 | 0.15 | 0.075
 |  | Grava Retenido Parcial (%): | 4.8 | 8.5 | 13.4 | 10.8 | 15.1 | 10.4 | 22.4 | - | - | - | 13.9
 |  | Arena Retenido Parcial (%): | - | - | - | - | - | 0 | 1.7 | 13.8 | 50.6 | 23.9 | 6.1
 | %Ret Acum. | Grava: | 4.8 | 13.3 | 26.7 | 37.5 | 52.6 | 63 | 85.4 | 0 | 0 | 0 | 99.30000000000001
 |  | Arena | 0 | 0 | 0 | 0 | 0 | 0 | 1.7 | 15.5 | 66.1 | 90 | 96.1
 | %Pasa Acum. | Grava: | 95.2 | 86.7 | 73.3 | 62.5 | 47.4 | 37 | 14.59999999999999 |  |  |  | 0.6999999999999886
 |  | Arena | 100 | 100 | 100 | 100 | 100 | 100 | 98.3 | 84.5 | 33.90000000000001 | 10 | 3.900000000000006 |  |  |  |  |  |  |  |  |  | %grava | total difference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.68 | -225
 |  | Comb. [NAME] (%): | 96.11102079918058 | 89.22428679772952 | 78.36755319544196 | 69.61734999359825 | 57.38326959102049 | 48.95714798924507 | 30.4859251857113 | 16.03776198557474 | 6.434084394212825 | 1.897959998292869 | 1.30734719945371 |  |  |  |  | blue | red | difference |  |  | 0.75 | -104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total areas | 3504.366817173267 | 3504.366817173267 | 6.217248937900877e-14 |  |  | 0.8 | -18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.81 | -0.35
 | Porcentajes para dosificar: |  |  |  |  |  |  |  |  |  |  | blue curve |  |  | red curve |  |  |  |  |  |  |  | 0.82 | 17
 | %GRAVA: | 0.8102040001707131 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | area under |  |  |  |  | 0.9 | 155
 | %ARENA: | 0.1897959998292869 |  |  |  |  |  |  |  |  | d [NAME] (mm) | [NAME] | Fuller |  |  |  |  | blue | red | difference |  |  | 0.95 | 241
 |  |  |  |  |  |  |  |  |  |  |  | y | y |  | Comb. [NAME] (%):
 |  |  |  |  |  |  |  |  |  |  | 50 | 100 | 100 |  | 96.11102079918058 |  |  | 1175.476630855094 | 1158.345672480688 | -17.13095837440574
 |  |  |  |  |  |  |  |  |  |  | 37.5 | 88.07626093681503 | 86.60254037844386 |  | 89.22428679772952 |  |  | 1012.554777890111 | 1047.448999957322 | 34.89422206721076
 |  |  |  |  |  |  |  |  |  |  | 25 | 73.93250352560273 | 70.71067811865476 |  | 78.36755319544196 |  |  | 419.3873644560798 | 443.9547095671206 | 24.56734511104082
 |  |  |  |  |  |  |  |  |  |  | 19 | 65.86328462642389 | 61.64414002968977 |  | 69.61734999359825 |  |  | 394.4306750358776 | 412.752013650011 | 18.32133861413331
 |  |  |  |  |  |  |  |  |  |  | 12.5 | 55.5 | 50 |  | 57.38326959102049 |  |  | 157.941300896268 | 159.5106263703983 | 1.569325474130352
 |  |  |  |  |  |  |  |  |  |  | 9.5 | 49.794200597512 | 43.58898943540673 |  | 48.95714798924507 |  |  | 209.5363769129694 | 188.6772987905214 | -20.85907812244798
 |  |  |  |  |  |  |  |  |  |  | 4.75 | 38.43164231321195 | 30.82207001484488 |  | 30.4859251857113 |  |  | 112.6407859137863 | 83.0447816007456 | -29.59600431304067
 |  |  |  |  |  |  |  |  |  |  | 1.18 | 24.67243943120612 | 15.36229149573722 |  | 16.03776198557474 |  |  | 18.72919390648034 | 9.887612407106527 | -8.841581499373813
 |  |  |  |  |  |  |  |  |  |  | 0.3 | 17.8939103562492 | 7.745966692414834 |  | 6.434084394212825 |  |  | 2.532648083853389 | 0.624903329437927 | -1.907744754415462
 |  |  |  |  |  |  |  |  |  |  | 0.15 | 15.87473076179598 | 5.477225575051661 |  | 1.897959998292869 |  |  | 1.137063222747022 | 0.1201990199154967 | -1.016864202831525
 |  |  |  |  |  |  |  |  |  |  | 0.075 | 14.4469551781246 | 3.872983346207417 |  | 1.30734719945371
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | note: height of each trapeazoid on a linear scale