Spreadsheet: 797061d1663690746-calc-error-with-filter-function-pulling-from-other-formulas-filter-example
Sheet: Bid Information and Summary

 |  | Bid Information |  |  |  |  |  |  |  |  | Trade Information |  |  |  |  |  |  |  | New siding numbers updated
 | Bid Name | LUMBER |  |  |  |  |  |  |  | Company | L&S FRAMING (GSL)
 | Community Name  / Number | MOSAIC |  |  | 1553520000 |  |  |  |  | Preparer | [NAME]
 | Division | LSC |  |  |  |  |  |  |  | [NAME] | [EMAIL]
 | Trade / Vendor # | L&S Framing (GSL) |  |  | 12731038 |  |  |  |  | Telephone | [PHONE]
 | [NAME] | LBM |  |  |  |  |  |  |  | Date | 3.26.20
 | Bid Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan order is different on analysis
 | Summary Using Lennar Takeoffs
 | Community | Plan | Elev | Option | Material | Labor | Unitized | Turnkey | Material | Labor | Unitized | Turnkey | Tax | Subtotal | Total | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 | Summary Using Trade Takeoffs |  |  |  | COST CODES
 | Community | Plan | Elev | Option |  |  |  |  |  |  |  |  | Tax | Subtotal | Total | [NAME]
 | 1553520000 | 1230 | A |  | 12735.723 | 118.748 | 771.2682599999999 | 55.91694884999999 | 771.2682599999999 | 0 | 0 | 0 | 916.8399488499999 | 14452.92446885 |  |  | `
 |  |  |  |  | 13979.898075 | 130.3487 | 846.6148065000001 | 61.37957347125 | 846.6148065000001 | 0 | 0 | 0 | 1006.40764847125 | 15864.85596147125 |  |  | `
 |  |  |  |  | 13806.91455 | 128.7358 | 836.139021 | 60.62007902249999 | 836.139021 | 0 | 0 | 0 | 993.9546290225 | 15668.5484710225 |  |  | `
 |  |  |  |  | 12580.2963 | 117.2988 | 761.8557059999999 | 55.23453868499999 | 761.8557059999999 | 0 | 0 | 0 | 905.6508386849999 | 14276.541050685 |  |  | `
 |  |  |  |  | 15256.065825 | 142.2477 | 923.8988114999999 | 66.98266383374998 | 923.8988114999999 | 0 | 0 | 0 | 1098.27848883375 | 17313.09381183375 |  |  | `
 |  |  |  |  | 13162.674525 | 122.7289 | 797.1242054999999 | 57.79150489874999 | 797.1242054999999 | 0 | 0 | 0 | 947.5760298987499 | 14937.44334089875 |  |  | `
 |  |  |  |  | 14846.81055 | 138.4318 | 899.1145409999999 | 65.1858042225 | 899.1145409999999 | 0 | 0 | 0 | 1068.8163542225 | 16848.6572362225 |  |  | `
 |  |  |  |  | 16189.9452 | 150.9552 | 980.454024 | 71.08291674 | 980.454024 | 0 | 0 | 0 | 1165.50811674 | 18372.89136474 |  |  | `
 |  |  |  |  | 14005.3485 | 130.586 | 848.1560699999998 | 61.49131507499998 | 848.1560699999998 | 0 | 0 | 0 | 1008.239815075 | 15893.737955075 |  |  | `
 |  |  |  |  | 16672.645275 | 155.4559 | 1009.6860705 | 73.20224011124999 | 1009.6860705 | 0 | 0 | 0 | 1200.25751511125 | 18920.67555611125 |  |  | `
 |  |  |  |  | 15758.060175 | 146.9283 | 954.2993084999999 | 69.18669986625 | 954.2993084999999 | 0 | 0 | 0 | 1134.41687486625 | 17882.77379186625 |  |  | `
 |  |  |  |  | 16030.08907500001 | 149.4647000000001 | 970.7732265000003 | 70.38105892125002 | 970.7732265000003 | 0 | 0 | 0 | 1154.00013392125 | 18191.48128692126 |  |  | `
 |  |  |  |  | 13103.408175 | 122.1763 | 793.5350684999999 | 57.53129246624999 | 793.5350684999999 | 0 | 0 | 0 | 943.3094674662499 | 14870.18590446625 |  |  | `
 |  |  |  |  | 14259.80985 | 132.9586 | 863.5661070000001 | 62.6085427575 | 863.5661070000001 | 0 | 0 | 0 | 1026.5583927575 | 16182.5092067575 |  |  | `
 |  |  |  |  | 14370.652725 | 133.9921 | 870.2786895 | 63.09520498875 | 870.2786895 | 0 | 0 | 0 | 1034.53792998875 | 16308.29740898875 |  |  | `
 |  |  |  |  | 13030.68195 | 121.4982 | 789.130809 | 57.2119836525 | 789.130809 | 0 | 0 | 0 | 938.0739336524999 | 14787.6537516525 |  |  | `
 |  |  |  |  | 15693.09885 | 146.3226 | 950.3652869999999 | 68.90148330749999 | 950.3652869999999 | 0 | 0 | 0 | 1129.7403333075 | 17809.0535073075 |  |  | `
 |  |  |  |  | 15545.47995 | 144.9462 | 941.425569 | 68.25335375249999 | 941.425569 | 0 | 0 | 0 | 1119.1133037525 | 17641.5306417525 |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `