Spreadsheet: 133439d1324395926-excel-2007-extracting-largest-variances-formulatest
Sheet: Data Sheet Mth

 |  |  |  |  | PL_21000 |  |  |  |  |  |  | UBM_PROD |  | REVENUE & COSTS
Segment | Business Unit Hyperion Code | Business Unit Name | U/L,DIS,ETC | Revenue/Cost |  |  |  |  |  |  |  |  |  | RANKING | Business Segment | UL/ACQ/NPD/DIS | AG + AH | [NAME] | Business Unit | REV/CST/OHD | GL Account
ABC | ProductA | ProductA | U/L | REV | Rev1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev2 | 585000 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev3 | -272914.700000002 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev4 | 1323171.97 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev5 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev6 | -1323171.000000002 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev7 | 272914.68 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev8 | 441299.11 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev9 | -441299 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev10 | 15467.92 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev11 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev12 | -585000 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev13 | 40231.15 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev14 | -40231.42 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev15 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev16 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev17 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | Rev18 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | REV | [NAME] | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost2 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost3 | -33121.92 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost4 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost5 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost6 | -14469 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost7 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost8 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost9 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost10 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost11 | -5713.88 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost12 | -3873.1 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost13 | -2995.14 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost14 | -17897.75 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost15 | -82055 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost16 | -23290 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost17 | -3300 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost18 | -84214.19 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost19 | -7025.56 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost20 | -1434 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost21 | -1000 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost22 | -13186 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost23 | -12959 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost24 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost25 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost26 | -15214.54 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost27 | -219542.45 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost28 | -34913.68 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost29 | -15352.21 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost30 | -42970.13 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost31 | -88152.62 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost32 | -49282.45 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost33 | -38714.23 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost34 | -72942.25 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost35 | -136925.19 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost36 | -35886.44 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost37 | -104131.51 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost38 | -64258.97 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost39 | -32995.72 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | [NAME] | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost41 | -59828.23 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost42 | -74837.52 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost43 | -5065.98 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost44 | -20327.4 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost45 | 219542 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost46 | 201420 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost47 | 59828 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | [NAME] | 100631 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost49 | 64259 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost50 | 5387 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost51 | 76010 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost52 | 35886 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost53 | 23290 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost54 | 14469 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost55 | 5714 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost56 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost57 | 4590 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost58 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost59 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost60 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost61 | 7026 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost62 | 32996 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost63 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost64 | 33062 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost65 | 492153 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost66 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | [NAME] | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost68 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost69 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost70 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost71 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | [NAME] | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost73 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost74 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost75 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost76 | 795000 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost77 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost78 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | CST | Cost79 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -95842 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -396965 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -276403 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 388000 | 0 | -30875 | -32716.66000000003 | -11725
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -1605.060000000001 | -1789.070888975999 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | 0 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -179.8699999999953 | -5018.368868594014 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -134988 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -110558 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -89740 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -17800 | 0 | 0 | 0 | 0
ABC | ProductA | ProductA | U/L | OHD | Overhead1 | -32893 | 0 | 0 | 0 | 0
 |  |  |  |  | Check | 5.820766091346741e-11 | -1.455191522836685e-10 | 0 | 3.492459654808044e-10 | 0