Spreadsheet: 116134d1311618247-vlookup-challenge-master-spread-example-modified-by-tigeravatar-
Sheet: Acct Data Current Year

 |  | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale | scale
 |  | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts | Accounts
 |  | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Actual | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast | FY 11 Forecast
 |  | Jan | Feb | Mar | Qtr 1 | Apr | May | Jun | Qtr 2 | Jul | Aug | Sep | Qtr 3 | Oct | Nov | Dec | Qtr 4 | Fiscal Year
VA MMIS | XREV - Total Revenues | 2456.7562 | 2296.59117 | 2370.99779999999 | 7124.34517 | 2287.71681 | 3151.14439999999 | 3951.59105999999 | 9390.45227 | 2686.742 | 3027.754 | 2873.298 | 8587.794 | 2493.893 | 2493.893 | 2493.893 | 7481.679 | 32584.2704399999
VA MMIS | XDEXP - Direct Expenses | -1955.05474 | -2002.14222 | -2104.27398 | -6061.47093999999 | -2092.71468 | -2528.29427 | -2438.34604999999 | -7059.355 | -2318.43853104428 | -2378.68907461707 | -2339.14323179229 | -7036.27083745365 | -1974.7346769424 | -2001.70680031128 | -2000.21220074686 | -5976.65367800055 | -26133.7504554542
VA MMIS | XGM - Gross Margin | 501.70146 | 294.44895 | 266.723819999999 | 1062.87423 | 195.002129999999 | 622.850129999999 | 1513.24501 | 2331.09727 | 368.303468955713 | 649.064925382923 | 534.154768207703 | 1551.52316254634 | 519.158323057596 | 492.186199688712 | 493.680799253135 | 1505.02532199944 | 6450.51998454578
VA MMIS | XSAG - Selling, [NAME] and [NAME] | -5.91886 | -5.5164 | -6.00977999999999 | -17.44504 | -7.06404 | -5.81227 | -5.81378 | -18.69009 | -6.064373795 | -6.61316733199999 | -6.335180956 | -19.012722083 | -6.068674264 | -6.340877253 | -6.336268431 | -18.745819948 | -73.893672031
VA MMIS | XOPINC - Operating Income | 495.7826 | 288.93255 | 260.714039999999 | 1045.42919 | 187.938089999999 | 617.037859999999 | 1507.43123 | 2312.40718 | 362.239095160713 | 642.451758050923 | 527.819587251703 | 1532.51044046334 | 513.089648793596 | 485.845322435712 | 487.344530822135 | 1486.27950205144 | 6376.62631251478
VA MMIS | XPBT - Profit Before Tax and Eq Inc | 495.7826 | 288.93255 | 260.714039999999 | 1045.42919 | 187.938089999999 | 612.072509999999 | 1507.43123 | 2307.44183 | 362.239095160713 | 642.451758050923 | 527.819587251703 | 1532.51044046334 | 513.089648793596 | 485.845322435712 | 487.344530822135 | 1486.27950205144 | 6371.66096251478
Mississippi MMIS | XREV - Total Revenues | 2878.51292999999 | 2672.57243 | 2699.15463 | 8250.23999 | 2707.49863 | 2656.01759 | 2691.9069 | 8055.42311999999 | 2691.06507138512 | 2887.62492537862 | 2874.22492537862 | 8452.91492214237 | 3003.29084052143 | 2872.50751888973 | 2908.55861739278 | 8784.35697680395 | 33542.9350089463
Mississippi MMIS | XDEXP - Direct Expenses | -1921.70075999999 | -1867.30296999999 | -2008.55366 | -5797.55738999999 | -1928.88609 | -1743.32794 | -2040.30265 | -5712.51668 | -1863.47718595583 | -2155.1197804964 | -2063.52226912368 | -6082.11923557593 | -2109.17244476793 | -2055.60572337931 | -2132.02247069244 | -6296.80063883969 | -23888.9939444156
Mississippi MMIS | XGM - Gross Margin | 956.812169999999 | 805.26946 | 690.60097 | 2452.6826 | 778.61254 | 912.689649999999 | 651.604249999999 | 2342.90643999999 | 827.587885429287 | 732.505144882215 | 810.702656254936 | 2370.79568656643 | 894.118395753499 | 816.901795510424 | 776.536146700335 | 2487.55633796425 | 9653.9410645307
Mississippi MMIS | XSAG - Selling, [NAME] and [NAME] | -15.21932 | -0.74499 | -2.00506999999999 | -17.96938 | -4.35868 | -6.89077 | -6.91095999999999 | -18.16041 | -12.6273086473242 | -11.5397891739657 | -6.9246081399623 | -31.0917059612523 | -12.6320298198076 | -6.93086169081615 | -7.02580199967076 | -26.5886935102946 | -93.8101894715469
Mississippi MMIS | XOPINC - Operating Income | 941.592849999999 | 804.52447 | 688.595899999999 | 2434.71322 | 774.25386 | 905.798879999999 | 644.693289999999 | 2324.74602999999 | 814.960576781963 | 720.965355708249 | 803.778048114974 | 2339.70398060518 | 881.486365933691 | 809.970933819608 | 769.510344700665 | 2460.96764445396 | 9560.13087505915
Mississippi MMIS | XPBT - Profit Before Tax and Eq Inc | 941.592849999999 | 804.52447 | 688.595899999999 | 2434.71322 | 774.25386 | 905.798879999999 | 644.693289999999 | 2324.74602999999 | 814.960576781963 | 720.965355708249 | 803.778048114974 | 2339.70398060518 | 881.486365933691 | 809.970933819608 | 769.510344700665 | 2460.96764445396 | 9560.13087505915
DC MMIS | XREV - Total Revenues | 1190.49363 | 1193.68863 | 1190.66898 | 3574.85124 | 1191.6526 | 1189.10358 | 1420.65174 | 3801.40792 | 1842.8619 | 1859.67521 | 1789.38158 | 5491.91869 | 1777.34277 | 1785.05047 | 1691.5566 | 5253.94984 | 18122.12769
DC MMIS | XDEXP - Direct Expenses | -1030.18180999999 | -1005.7907 | -1142.80279 | -3178.7753 | -1152.78678 | -1172.14127999999 | -1114.25346 | -3439.18152 | -1474.76613574515 | -1444.94493729951 | -1407.7533417573 | -4327.46441480197 | -1381.78541612272 | -1457.3370556362 | -1318.76580512402 | -4157.88827688295 | -15103.3095116849
DC MMIS | XGM - Gross Margin | 160.31182 | 187.897929999999 | 47.8661899999995 | 396.075939999999 | 38.8658199999997 | 16.9623000000005 | 306.39828 | 362.2264 | 368.095764254846 | 414.730272700487 | 381.628238242697 | 1164.45427519802 | 395.557353877278 | 327.71341436379 | 372.790794875979 | 1096.06156311704 | 3018.81817831507
DC MMIS | XSAG - Selling, [NAME] and [NAME] | -2.6789 | -4.71106999999999 | -8.78870999999999 | -16.17868 | -6.63268999999999 | -6.94262999999999 | -7.04596 | -20.62128 | -3.61672173012211 | -3.93685164440288 | -3.77469274642115 | -11.3282661209461 | -3.61923033990384 | -3.77801559024808 | -3.77532710751538 | -11.1725730376673 | -59.3007991586134
DC MMIS | XOPINC - Operating Income | 157.63292 | 183.186859999999 | 39.0774799999995 | 379.897259999999 | 32.2331299999997 | 10.0196700000005 | 299.35232 | 341.60512 | 364.479042524723 | 410.793421056084 | 377.853545496275 | 1153.12600907708 | 391.938123537374 | 323.935398773542 | 369.015467768463 | 1084.88899007938 | 2959.51737915646
DC MMIS | XPBT - Profit Before Tax and Eq Inc | 157.1569 | 182.721039999999 | 38.6218899999995 | 378.499829999999 | 31.7877899999997 | 9.58461000000059 | 298.92758 | 340.29998 | 364.029042524723 | 410.343421056084 | 377.403545496275 | 1151.77600907708 | 391.488123537374 | 313.905738773542 | 368.565467768464 | 1073.95933007938 | 2944.53514915646
FL Third Party Liability | XREV - Total Revenues | 560.9273 | 805.83225 | 967.19322 | 2333.95277 | 815.56073 | 790.09109 | 1473.54236 | 3079.19418 | 948.72 | 917.217 | 886.847 | 2752.78399999999 | 903.589 | 879.689 | 903.104 | 2686.382 | 10852.31295
FL Third Party Liability | XDEXP - Direct Expenses | -669.30459 | -792.33979 | -929.07747 | -2390.72185 | -807.99815 | -805.41268 | -1432.03079 | -3045.44162 | -931.776054917285 | -903.162256536816 | -875.330091590288 | -2710.26840304439 | -887.219168117129 | -868.905791390375 | -896.911350062228 | -2653.03630956973 | -10799.4681826141
FL Third Party Liability | XGM - Gross Margin | -108.37729 | 13.4924599999999 | 38.1157500000001 | -56.7690800000004 | 7.56258000000002 | -15.3215900000001 | 41.5115699999998 | 33.7525599999999 | 16.9439450827145 | 14.0547434631836 | 11.516908409711 | 42.515596955609 | 16.3698318828702 | 10.7832086096244 | 6.1926499377713 | 33.3456904302661 | 52.8447673858736
FL Third Party Liability | XSAG - Selling, [NAME] and [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FL Third Party Liability | XOPINC - Operating Income | -108.37729 | 13.4924599999999 | 38.1157500000001 | -56.7690800000004 | 7.56258000000002 | -15.3215900000001 | 41.5115699999998 | 33.7525599999999 | 16.9439450827145 | 14.0547434631836 | 11.516908409711 | 42.515596955609 | 16.3698318828702 | 10.7832086096244 | 6.1926499377713 | 33.3456904302661 | 52.8447673858736
FL Third Party Liability | XPBT - Profit Before Tax and Eq Inc | -108.37729 | 13.4924599999999 | 38.1157500000001 | -56.7690800000004 | 7.56258000000002 | -15.3215900000001 | 41.5115699999998 | 33.7525599999999 | 16.9439450827145 | 14.0547434631836 | 11.516908409711 | 42.515596955609 | 16.3698318828702 | 10.7832086096244 | 6.1926499377713 | 33.3456904302661 | 52.8447673858736
SC Third Party Liability | XREV - Total Revenues | 286.063929999999 | 287.47776 | 426.60511 | 1000.1468 | 385.10654 | 267.664819999999 | 304.0041 | 956.77546 | 246 | 246 | 246 | 738 | 236 | 0 | 0 | 236 | 2930.92226
SC Third Party Liability | XDEXP - Direct Expenses | -254.627079999999 | -206.36431 | -355.228889999999 | -816.22028 | -283.08468 | -250.693909999999 | -272.850549999999 | -806.629139999999 | -224.121326933862 | -232.873712000437 | -231.445070694179 | -688.440109628479 | -224.189912585536 | -124.755205058926 | -8.32020660746003 | -357.265324251923 | -2668.5548538804
SC Third Party Liability | XGM - Gross Margin | 31.4368499999999 | 81.1134499999999 | 71.3762200000001 | 183.926519999999 | 102.02186 | 16.97091 | 31.15355 | 150.14632 | 21.8786730661376 | 13.1262879995623 | 14.5549293058207 | 49.5598903715207 | 11.810087414463 | -124.755205058926 | -8.32020660746003 | -121.265324251923 | 262.367406119597
SC Third Party Liability | XSAG - Selling, [NAME] and [NAME] | 0 | -4.35779 | 0 | -4.35779 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4.35779
SC Third Party Liability | XOPINC - Operating Income | 31.4368499999999 | 76.7556599999999 | 71.3762200000001 | 179.56873 | 102.02186 | 16.97091 | 31.15355 | 150.14632 | 21.8786730661376 | 13.1262879995623 | 14.5549293058207 | 49.5598903715207 | 11.810087414463 | -124.755205058926 | -8.32020660746003 | -121.265324251923 | 258.009616119597
SC Third Party Liability | XPBT - Profit Before Tax and Eq Inc | 31.4368499999999 | 76.7556599999999 | 71.3762200000001 | 179.56873 | 102.02186 | 16.97091 | 31.15355 | 150.14632 | 21.8786730661376 | 13.1262879995623 | 14.5549293058207 | 49.5598903715207 | 11.810087414463 | -124.755205058926 | -8.32020660746003 | -121.265324251923 | 258.009616119597
East New Business | XREV - Total Revenues | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East New Business | XDEXP - Direct Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East New Business | XGM - Gross Margin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East New Business | XSAG - Selling, [NAME] and [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East New Business | XOPINC - Operating Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East New Business | XPBT - Profit Before Tax and Eq Inc | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East Admin | XREV - Total Revenues | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
East Admin | XDEXP - Direct Expenses | -15.63008 | -5.71413 | -12.01568 | -33.35989 | -44.34348 | -68.45196 | -14.77186 | -127.5673 | -89.0246765230769 | -93.850661476923 | -98.6580417307692 | -281.533379730769 | -89.0570004692308 | -92.9019157153845 | -94.367274176923 | -276.326190361538 | -718.786760092307
East Admin | XGM - Gross Margin | -15.63008 | -5.71413 | -12.01568 | -33.35989 | -44.34348 | -68.45196 | -14.77186 | -127.5673 | -89.0246765230769 | -93.850661476923 | -98.6580417307692 | -281.533379730769 | -89.0570004692308 | -92.9019157153845 | -94.367274176923 | -276.326190361538 | -718.786760092307
East Admin | XSAG - Selling, [NAME] and [NAME] | -47.95664 | -48.7060899999999 | -56.9123 | -153.57503 | 4.36354999999998 | -5.02246999999999 | -96.31461 | -96.97353 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -250.54856
East Admin | XOPINC - Operating Income | -63.58672 | -54.42022 | -68.92798 | -186.93492 | -39.97993 | -73.47443 | -111.08647 | -224.54083 | -89.0246765230769 | -93.850661476923 | -98.6580417307692 | -281.533379730769 | -89.0570004692308 | -92.9019157153845 | -94.367274176923 | -276.326190361538 | -969.335320092307
East Admin | XPBT - Profit Before Tax and Eq Inc | -63.58672 | -54.42022 | -68.92798 | -186.93492 | -39.97993 | -73.47443 | -111.08647 | -224.54083 | -89.0246765230769 | -93.850661476923 | -98.6580417307692 | -281.533379730769 | -89.0570004692308 | -92.9019157153845 | -94.367274176923 | -276.326190361538 | -969.335320092307
MMIS East Closed Contracts | XREV - Total Revenues | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MMIS East Closed Contracts | XDEXP - Direct Expenses | 9.65469 | 0.09588 | 0.00018 | 9.75075 | 0 | 0 | 3.86503 | 3.86503 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.61578
MMIS East Closed Contracts | XGM - Gross Margin | 9.65469 | 0.09588 | 0.00018 | 9.75075 | 0 | 0 | 3.86503 | 3.86503 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.61578
MMIS East Closed Contracts | XSAG - Selling, [NAME] and [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | -3 | -3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3
MMIS East Closed Contracts | XOPINC - Operating Income | 9.65469 | 0.09588 | 0.00018 | 9.75075 | 0 | 0 | 0.86503 | 0.86503 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.61578
MMIS East Closed Contracts | XPBT - Profit Before Tax and Eq Inc | 9.65469 | 0.09588 | 0.00018 | 9.75075 | 0 | 0 | 0.86503 | 0.86503 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.61578
MMIS - East | XREV - Total Revenues | 7934.05863 | 7802.27938 | 8418.89784 | 24155.23585 | 8010.30241 | 8824.37727 | 11959.5646699999 | 28794.24435 | 9030.32397138512 | 9552.39613537862 | 9282.79650537862 | 27865.5166121423 | 9026.35061052142 | 8643.78998888974 | 8808.95221739278 | 26479.0928168039 | 107294.089628946
MMIS - East | XDEXP - Direct Expenses | -6332.52053999999 | -6354.94977999999 | -7068.93180999999 | -19756.4021299999 | -6821.48092 | -7207.61460999999 | -7894.36286999999 | -21923.4584 | -7400.59397069901 | -7716.1409601841 | -7513.5300599852 | -22630.2649908683 | -7158.34853278198 | -7102.1207033686 | -7058.5898335938 | -21319.0590697443 | -85629.1845906127
MMIS - East | XGM - Gross Margin | 1601.53809 | 1447.3296 | 1349.96603 | 4398.83372000001 | 1188.82148999999 | 1616.76266 | 4065.20179999999 | 6870.78595 | 1629.7300006861 | 1836.25517519452 | 1769.26644539341 | 5235.25162127404 | 1868.00207773943 | 1541.66928552113 | 1750.36238379898 | 5160.03374705955 | 21664.9050383336
MMIS - East | XSAG - Selling, [NAME] and [NAME] | -74.4737199999999 | -64.03634 | -73.71586 | -212.22592 | -13.69186 | -24.6681399999999 | -119.08531 | -157.44531 | -23.3084041724463 | -23.0898081503686 | -18.0344818423834 | -64.4326941651984 | -23.3199344237115 | -18.0497545340642 | -18.1373975381861 | -59.5070864959619 | -493.61101066116
MMIS - East | XOPINC - Operating Income | 1527.06437 | 1383.29326 | 1276.25017 | 4186.60780000001 | 1175.12962999999 | 1592.09452 | 3946.11648999999 | 6713.34064 | 1606.42159651366 | 1813.16536704415 | 1751.23196355103 | 5170.81892710884 | 1844.68214331572 | 1523.61953098707 | 1732.22498626079 | 5100.52666056359 | 21171.2940276724
MMIS - East | XPBT - Profit Before Tax and Eq Inc | 1598.55541 | 1498.59504 | 1400.49369 | 4497.64414 | 1300.22849999999 | 1747.68556 | 4107.62091999999 | 7155.53498 | 1765.97159651366 | 1972.71536704415 | 1910.78196355103 | 5649.46892710884 | 2004.23214331572 | 1673.58987098707 | 1891.77498626079 | 5569.59700056359 | 22872.2450476724
Texas MMIS | XREV - Total Revenues | 14520.15207 | 14471.26853 | -1190.01540999999 | 27801.4051899999 | 14152.02671 | 13643.37687 | 13877.7075099999 | 41673.11109 | 13773.9284176908 | 14083.1064010722 | 14192.4128140322 | 42049.4476327954 | 13544.2699570519 | 15319.0166731385 | 16194.625433838 | 45057.9120640285 | 156581.875976823
Texas MMIS | XDEXP - Direct Expenses | -13919.90633 | -12908.18695 | -13268.71319 | -40096.80647 | -13221.2802 | -14460.76916 | -14151.8156 | -41833.86496 | -12055.9110401098 | -12452.3061261264 | -12279.0669615334 | -36787.2841277697 | -11364.2962953944 | -14044.0786449187 | -13464.4951224953 | -38872.8700628085 | -157590.825620578
Texas MMIS | XGM - Gross Margin | 600.24574 | 1563.08158 | -14458.7286 | -12295.40128 | 930.746509999995 | -817.392289999999 | -274.108090000001 | -160.753870000007 | 1718.01737758103 | 1630.80027494579 | 1913.34585249879 | 5262.16350502562 | 2179.97366165751 | 1274.93802821975 | 2730.13031134274 | 6185.04200122002 | -1008.94964375437
Texas MMIS | XSAG - Selling, [NAME] and [NAME] | -23.92787 | -8.706 | 1.5 | -31.13387 | -5.23209 | -0.12 | -2.9952 | -8.34729 | -8.417 | -8.417 | -8.54325499999999 | -25.3772549999999 | -8.54325499999999 | -8.54325499999999 | -8.54325499999999 | -25.6297649999999 | -90.48818
Texas MMIS | XOPINC - Operating Income | 576.31787 | 1554.37558 | -14457.2286 | -12326.53515 | 925.514419999995 | -817.512289999999 | -277.103290000001 | -169.101160000007 | 1709.60037758103 | 1622.38327494579 | 1904.80259749879 | 5236.78625002562 | 2171.43040665751 | 1266.39477321975 | 2721.58705634274 | 6159.41223622002 | -1099.43782375437
Texas MMIS | XPBT - Profit Before Tax and Eq Inc | 573.17036 | 1551.64689 | -14459.84711 | -12335.02986 | 922.206779999995 | -819.911139999999 | -279.389450000001 | -177.093810000007 | 1709.60037758103 | 1622.38327494579 | 1904.80259749879 | 5236.78625002562 | 2171.43040665751 | 1266.39477321975 | 2721.58705634274 | 6159.41223622002 | -1115.92518375437