Spreadsheet: 180378d1347571487-need-excel-2007-formula-to-check-for-accounting-errors-in-long-column-operational-profit_net-profit-check
Sheet: Check 5 or 6

Record # | Company # | Worksheet ID | LINE_NUM | CLMN_NUM | [NAME] | FY_BGN_DT | FY_END_DT
504082 | 100028 | G300000 | 300 | 0100 | 27505832 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 | 1
504082 | 100028 | G300000 | 400 | 0100 | 33043502 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00300
504082 | 100028 | G300000 | 500 | 0100 | -5537670 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00399
504082 | 100028 | G300000 | 2500 | 0100 | 828318 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00400
504082 | 100028 | G300000 | 3000 | 0100 | 115000 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00499
504082 | 100028 | G300000 | 3100 | 0100 | -4824352 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00500
504084 | 100202 | G300000 | 300 | 0100 | 60954142 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 00599
504084 | 100202 | G300000 | 400 | 0100 | 60363062 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 02500
504084 | 100202 | G300000 | 500 | 0100 | 591080 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 02599
504084 | 100202 | G300000 | 2500 | 0100 | 1076820 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 03000
504084 | 100202 | G300000 | 3000 | 0100 | 81914 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 03099
504084 | 100202 | G300000 | 3100 | 0100 | 1585986 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 03100
505570 | 460192 | G300000 | 300 | 0100 | 21660196 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | 03199
505570 | 460192 | G300000 | 400 | 0100 | 21516128 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00
505570 | 460192 | G300000 | 500 | 0100 | 144068 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | Check
505570 | 460192 | G300000 | 2500 | 0100 | 204330 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 |  | K4-K6
505570 | 460192 | G300000 | 3100 | 0100 | 348398 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00
506808 | 200048 | G300000 | 300 | 0100 | 17601480 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00 |  | (K4+K10)-(K6+K12)
506808 | 200048 | G300000 | 400 | 0100 | 15793118 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00
506808 | 200048 | G300000 | 500 | 0100 | 1808362 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00
506808 | 200048 | G300000 | 2500 | 0100 | 126672 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00
506808 | 200048 | G300000 | 3000 | 0100 | 2397632 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00
506808 | 200048 | G300000 | 3100 | 0100 | -462598 | 2009-10-01 00:00:00 | 2010-02-18 00:00:00
508800 | 380408 | G300000 | 300 | 0100 | 30219244 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
508800 | 380408 | G300000 | 400 | 0100 | 36018936 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
508800 | 380408 | G300000 | 500 | 0100 | -5799692 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
508800 | 380408 | G300000 | 2500 | 0100 | 90616 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
508800 | 380408 | G300000 | 3100 | 0100 | -5709076 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
508826 | 680290 | G300000 | 300 | 0100 | 11365900 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
508826 | 680290 | G300000 | 400 | 0100 | 12061262 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
508826 | 680290 | G300000 | 500 | 0100 | -695362 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
508826 | 680290 | G300000 | 2500 | 0100 | 52262 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
508826 | 680290 | G300000 | 3100 | 0100 | -643100 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
509144 | 460408 | G300000 | 300 | 0100 | 48870392 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
509144 | 460408 | G300000 | 400 | 0100 | 56661392 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
509144 | 460408 | G300000 | 500 | 0100 | -7791000 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
509144 | 460408 | G300000 | 2500 | 0100 | 3019446 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
509144 | 460408 | G300000 | 3000 | 0100 | 2940952 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
509144 | 460408 | G300000 | 3100 | 0100 | -7712506 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00
512292 | 460270 | G300000 | 300 | 0100 | 26518000 | 2010-01-01 00:00:00 | 2010-04-30 00:00:00
512292 | 460270 | G300000 | 400 | 0100 | 32604000 | 2010-01-01 00:00:00 | 2010-04-30 00:00:00
512292 | 460270 | G300000 | 500 | 0100 | -6086000 | 2010-01-01 00:00:00 | 2010-04-30 00:00:00
512292 | 460270 | G300000 | 2500 | 0100 | 1164000 | 2010-01-01 00:00:00 | 2010-04-30 00:00:00
512292 | 460270 | G300000 | 3100 | 0100 | -4922000 | 2010-01-01 00:00:00 | 2010-04-30 00:00:00
513592 | 740082 | G300000 | 300 | 0100 | 1135248 | 2009-10-18 00:00:00 | 2009-12-31 00:00:00
513592 | 740082 | G300000 | 400 | 0100 | 2308786 | 2009-10-18 00:00:00 | 2009-12-31 00:00:00
513592 | 740082 | G300000 | 500 | 0100 | -1173538 | 2009-10-18 00:00:00 | 2009-12-31 00:00:00
513592 | 740082 | G300000 | 2500 | 0100 | 814404 | 2009-10-18 00:00:00 | 2009-12-31 00:00:00
513592 | 740082 | G300000 | 3100 | 0100 | -359134 | 2009-10-18 00:00:00 | 2009-12-31 00:00:00
513876 | 520320 | G300000 | 300 | 0100 | 13509570 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
513876 | 520320 | G300000 | 400 | 0100 | 12424352 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
513876 | 520320 | G300000 | 500 | 0100 | 1085218 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
513876 | 520320 | G300000 | 2500 | 0100 | 31886 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
513876 | 520320 | G300000 | 3100 | 0100 | 1117104 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
514256 | 520002 | G300000 | 300 | 0100 | 320813690 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00
514256 | 520002 | G300000 | 400 | 0100 | 292732384 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00
514256 | 520002 | G300000 | 500 | 0100 | 28081306 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00
514256 | 520002 | G300000 | 2500 | 0100 | 6777134 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00
514256 | 520002 | G300000 | 3100 | 0100 | 34858440 | 2009-11-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 300 | 0100 | 29972974 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 400 | 0100 | 26640870 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 500 | 0100 | 3332104 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 2500 | 0100 | 1180714 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 3000 | 0100 | 81530 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
515320 | 760104 | G300000 | 3100 | 0100 | 4431288 | 2010-04-01 00:00:00 | 2010-06-30 00:00:00
517588 | 840110 | G300000 | 300 | 0100 | 92747970 | 2009-10-01 00:00:00 | 2010-07-06 00:00:00
517588 | 840110 | G300000 | 400 | 0100 | 83048154 | 2009-10-01 00:00:00 | 2010-07-06 00:00:00
517588 | 840110 | G300000 | 500 | 0100 | 9699816 | 2009-10-01 00:00:00 | 2010-07-06 00:00:00
517588 | 840110 | G300000 | 2500 | 0100 | 3210084 | 2009-10-01 00:00:00 | 2010-07-06 00:00:00
517588 | 840110 | G300000 | 3100 | 0100 | 12909900 | 2009-10-01 00:00:00 | 2010-07-06 00:00:00
518190 | 320016 | G300000 | 300 | 0100 | 61953518 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518190 | 320016 | G300000 | 400 | 0100 | 65346192 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518190 | 320016 | G300000 | 500 | 0100 | -3392674 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518190 | 320016 | G300000 | 2500 | 0100 | 1661450 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518190 | 320016 | G300000 | 3000 | 0100 | 965480 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518190 | 320016 | G300000 | 3100 | 0100 | -2696704 | 2009-10-01 00:00:00 | 2010-09-30 00:00:00
518666 | 100732 | G300000 | 300 | 0100 | 8959772 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518666 | 100732 | G300000 | 400 | 0100 | 9172570 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518666 | 100732 | G300000 | 500 | 0100 | -212798 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518666 | 100732 | G300000 | 2500 | 0100 | 1439108 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518666 | 100732 | G300000 | 3000 | 0100 | 36 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518666 | 100732 | G300000 | 3100 | 0100 | 1226274 | 2010-07-01 00:00:00 | 2010-08-05 00:00:00
518674 | 680192 | G300000 | 300 | 0100 | 79640136 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
518674 | 680192 | G300000 | 400 | 0100 | 82544128 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
518674 | 680192 | G300000 | 500 | 0100 | -2903992 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
518674 | 680192 | G300000 | 2500 | 0100 | 1531772 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
518674 | 680192 | G300000 | 3000 | 0100 | 205776 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
518674 | 680192 | G300000 | 3100 | 0100 | -1577996 | 2009-10-01 00:00:00 | 2010-06-30 00:00:00
519462 | 460518 | G300000 | 300 | 0100 | 94597670 | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
519462 | 460518 | G300000 | 400 | 0100 | 92222500 | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
519462 | 460518 | G300000 | 500 | 0100 | 2375170 | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
519462 | 460518 | G300000 | 2500 | 0100 | 7118724 | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
519462 | 460518 | G300000 | 3100 | 0100 | 9493894 | 2010-01-01 00:00:00 | 2010-06-30 00:00:00