tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847326d1698315532-index-match-if-and-or-unsure-of-if-this-is-possible-book1
Sheet: Sheet1

Name | Company | 1st Activity ID | Activity 1 Date | 2nd Activity ID | Activity 2 Date | 3rd Activity ID | Activity 3 Date | 4th Activity ID | Activity 4 Date | Earliest Date  Attended | Earliest Activity Attended | Earliest Basket Weaving Activity Date | Earliest WoodWork Activity Date | Earliest Plumbing Activity Date | Earliest Electrical Activity Date
Mr A | Acme | 15/08/2004 - Electrical - Venus |  | 11/05/1999 -WoodWork - Saturn |  | 16/01/2009 - Plumbing - Pluto
Mr B | Duff Beer | 18/04/2018 - Electrical - Earth |  | 15/08/2004 - Electrical - Venus
Miss D | Acme | 17/12/2008 - Basket Weaving - Mars |  | 18/04/2018 - Electrical - Earth
Mrs E | [NAME] | 18/04/2018 - Electrical - Earth |  | 17/12/2008 - Basket Weaving - Mars |  | 24/09/2021 - Plumbing - Venus |  | 16/01/2009 - Plumbing - Pluto
[NAME] | [NAME] | 11/05/1999 -WoodWork - Saturn |  | 15/08/2004 - Electrical - Venus
Spreadsheet: 740372d1626298763-counting-instances-with-criteria-but-if-dates-are-sequential-count-as-one-attendance
Sheet: Sample

[NAME] hrs/Wk |  |  |  |  |  |  |  | Sick |  |  |  | Holidays
Date | Day | Sick | Reason | Not Protected | Protected | Occurrences |  | Instances |  |  |  | 2018-01-01 00:00:00
2016-02-12 00:00:00 |  | 1.5 | Doc appt |  |  | -
2016-02-20 00:00:00 |  | x | Brother [NAME] | X |  | -
2015-02-04 00:00:00 |  | x | Brother [NAME] | X |  | -
2015-02-05 00:00:00 |  | x | Brother [NAME] | X |  | -
2015-02-06 00:00:00 |  | x | Brother [NAME] | X |  | -
2018-02-01 00:00:00 |  | 8 | Sick
2018-03-22 00:00:00 |  | 8 | Sick
2018-04-24 00:00:00 |  | 8 | Sick
2018-05-26 00:00:00 |  | 1.5 | Sick
2018-06-13 00:00:00 |  | 4.5 | Sick
2018-06-20 00:00:00 |  | 8 | Sick
2018-06-25 00:00:00 |  | 8 | Sick
2018-07-28 00:00:00 |  | 8 | Sick
2018-09-28 00:00:00 |  | 8 | Sick
2018-11-07 00:00:00 |  | 8 | Sick |  |  | 4
2018-11-08 00:00:00 |  | 8 | Sick
2018-11-09 00:00:00 |  |  | Sick
2018-11-12 00:00:00 |  |  | Sick
Spreadsheet: 842756d1694751157-sum-of-specific-number-of-columns-tickets_sample
Sheet: Export

R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | R11 | R12 | R13 | R14 | R15 | R16 | R17 | R18 | R19 | Total Tickets | count | Average | Total_first_3
 | 4 | 4 | 1 | 4 | 2 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 6 | 3 | 6 | 6 | 3 | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  |  | 12
 | 2 | 2 | 2 | 3 | 2 | 2 | 2 |  |  |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 3 | 4 | 4 | 4 | 4
 |  | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  | 2 |  |  | 2 | 2 |  | 2 | 2 | 2 |  | 2
2 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | 2 | 2 | 3 | 3 | 2 | 2 | 2
 | 2 |  |  | 2 | 2 | 2 | 2 |  | 2 | 2
 |  |  | 4 | 4 | 4 | 4 |  |  |  |  |  |  | 4 | 4 | 4
 |  |  | 2 | 2 | 2 | 2 |  |  |  |  |  |  | 4 | 4 | 4
 |  |  | 1 | 1 | 1 | 2 |  |  |  |  |  |  | 2 | 2 | 2
4 | 4 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4
4 | 4 | 4 | 4 | 5 | 4 | 5 | 4 | 4 | 6 | 4 | 4 | 7 | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 775145d1648840552-employee-attendance-tracker-employee-attendance-record
Sheet: List of Employees

 | List of Employees |  |  |  |  |  |  |  |  | years | hours earned | hours earned | years | sick time earned
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 40
 | Employee Names | Anniversary Date | Years of Service | Vacation Hours | Vacation Hours Remaining | Sick Time | Sick Time Remaining |  |  | 1 | 40 | 40 | 1 | 40
 |  | 2020-03-19 00:00:00 |  |  |  |  |  |  |  | 2 | 48 | 48 | 2 | 40
 |  | 2021-06-07 00:00:00 |  |  |  |  |  |  |  | 3 | 64 | 64 | 3 | 40
 |  |  |  |  |  |  |  |  |  | 4 | 72 | 72 | 4 | 40
 |  |  |  |  |  |  |  |  |  | 5 | 80 | 80 | 5 | 40
 |  | 2019-10-28 00:00:00 |  |  |  |  |  |  |  | 6 | 88 | 88 | 6 | 40
 |  |  |  |  |  |  |  |  |  | 7 | 96 | 96 | 7 | 40
 |  |  |  |  |  |  |  |  |  | 8 | 104 | 104 | 8 | 40
 |  |  |  |  |  |  |  |  |  | 9 | 112 | 112 | 9 | 40
 |  |  |  |  |  |  |  |  |  | 10 | 120 | 120 | 10 | 40
 |  |  |  |  |  |  |  |  |  | 11 | 128 | 128 | 11 | 40
 |  |  |  |  |  |  |  |  |  | 12 | 136 | 136 | 12 | 40
 |  |  |  |  |  |  |  |  |  | 13 | 144 | 144 | 13 | 40
 |  |  |  |  |  |  |  |  |  | 14 | 152 | 152 | 14 | 40
 |  |  |  |  |  |  |  |  |  | 15 | 160 | 160 | 15 | 40
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B3

Local 3
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 11
Réservé:
Prix: | 140
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 9c17f93c-e01c-40f9-ab31-9a143dea2385
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 7/23/2014 6:58:39 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
District 37 | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: fletcher_sturm__11008__fletch's new position manager
Sheet: Cash

 |  | Date
 |  | weekday
 |  | weekday
 |  | peak hours
 | CINERGY
 | INTO AEP
 | INTO COMED
 | INTO TVA
 | NEPOOL
 | NSP
 | NY EAST
 | NY WEST
 | SOCO
 | WESTERN HUB
 |  |  | BAL WEEK |  |  |  |  |  |  |  |  | NEXT WEEK
Spreadsheet: 692563d1598434712-creating-third-sheet-with-data-from-first-and-second-sheets-by-matching-a-unique-id-third-sheet
Sheet: Sheet1

Unique ID | Serial Number | Colour
434 | 453654654 | blue
45 | 645647545 | red
765 | 765756655 | yellow
567 | 876766767 | green
1111 | qw | d
3333 | qd | a
4444 | s | d
5555 | d | a
Spreadsheet: 746832d1631057240-excel-to-return-lookup-value-besides-the-first-matching-value-data-table-tms
Sheet: Data

KeyWord Deep Dive | Notes | [NAME]
Billing Explanation | breakdown of the charges |  | Total | %
Make payment |  | >>Disconnect<<
Transfer Services to Address |  | Can No Longer Afford
Return Shipping Label |  | Switch to Competitor
Can No Longer Afford | Offered a lower rate but decided to cancel still | Customer Care Issue
Phone Issues | Unable to connect call | Doesn't use enough
Transfer Services to Address |  | Port-Out
Updating Payment |  | Promotion Ended
Renew Value Plan | VP expiring and requesting to renew | Technical Issues
Billing Explanation |  | Customer Declined to say
Transfer Services to Address |  | Deceased
Billing Explanation |  | Moving - Services Included
Cable Issues |  | Moving - Secondary Address
Credit(s) | Refund process | Partial Disconnect
[NAME] |  | >>Moving<<
Wifi Speed/Connection | Slow | Moving Outside Footprint
Update Account Information |  | Moving to [NAME]
Updating Payment | Scam email to provide credit card information | Transfer Services to Address
Moving - Services Included |  | >>Technical<<
Switch to Competitor |  | Wifi Speed/Connection
Pricing/Plan Inquiry | customer have legacy INT and CBL svc inquired about upgrading all | Cable Issues
[NAME] | Signed up new VP this morning and has some questions | Phone Issues
Billing Explanation |  | Appointments
Partial Disconnect | Inquiried about cancelling home phone | MyShaw/Email
Account Balance |  | Return Shipping Label
 |  | Equipment Swap
 |  | Additional Equipment
 |  | >>Billing/Account<<
 |  | Billing Explanation
 |  | Payment Arrangement
 |  | Report Payment
 |  | Make Payment
 |  | Updating Payment
 |  | Update Account Information
 |  | Account Balance
 |  | Credit(s)
 |  | CC Reversals
 |  | UEF / Return Equipment Procedures
 |  | >>Package Changes<<
 |  | Add Channel
 |  | [NAME]
 |  | Downgrade Internet
 |  | Downgrade TV
 |  | Upgrade Internet
 |  | Upgrade TV
 |  | Renew Value Plan
 |  | Sign New Value Plan
 |  | Pricing/Plan Inquiry
 |  | New RGU
 |  | Home Phone Add On
 |  | >>Value Plan & Promotions<<
 |  | Promotion/VP Ending
 |  | [NAME]
 |  | Competitor [NAME]
 |  | Seeking Offers/Promotions
 |  | Marketing Offer
 |  | >>Mobile<<
 |  | Pricing/Plan Inquiry
 |  | SIM Activation
 |  | >>Other<<
 |  | TCIS
 |  | Non Related
 |  | Direct
 |  | Business
Spreadsheet: 746942d1631121818-add-up-the-first-3-largest-values-sun-max-3
Sheet: Foglio1

Cod |  | Imp |  | Cod | Tot>3 |  |  |  | Cod
1111 |  | 57309699 |  | 1111 |  |  |  |  | 111
1111 |  | 22158869 |  | 1112 |  |  |  |  | 211
1111 |  | 17915581 |  | 1113 |  |  |  |  | 311
1111 |  | 14557500 |  | 2111
1111 |  | 12104508 |  | 2112
1112 |  | 9743374 |  | 2113
1112 |  | 8636129 |  | 3111
1112 |  | 6987546 |  | 3112
1112 |  | 6428063 |  | 3113
1112 |  | 6173439
1112 |  | 4556434
1112 |  | 4211832
1113 |  | 3785921
1113 |  | 3475659
1113 |  | 3366809
1113 |  | 3283889
1113 |  | 2823032
1113 |  | 2519894
1113 |  | 2139123
1113 |  | 2085908
2111 |  | 28298476
2111 |  | 4266204
2111 |  | 4084703
2111 |  | 3506565
2111 |  | 3223488
2111 |  | 2457407
2111 |  | 2238009
2112 |  | 1453311
2112 |  | 1256900
2112 |  | 1226792
2112 |  | 1201426
2112 |  | 1055124
2112 |  | 705701
2112 |  | 619519
2113 |  | 605971
2113 |  | 517610
2113 |  | 483829
2113 |  | 417381
2113 |  | 376262
2113 |  | 344033
2113 |  | 334439
2113 |  | 310728
2113 |  | 299634
2113 |  | 279853
2113 |  | 275389
2113 |  | 267406
3111 |  | 6411168
3111 |  | 1974787
3111 |  | 1777662
3111 |  | 1662528
3111 |  | 1641322
3111 |  | 1440975
3111 |  | 1327106
3111 |  | 1206493
3111 |  | 1162147
3112 |  | 942487
3112 |  | 931173
3112 |  | 871938
3112 |  | 694520
3112 |  | 674973
3112 |  | 609589
3112 |  | 567677
3112 |  | 537519
3113 |  | 524440
3113 |  | 523844
3113 |  | 508131
3113 |  | 507698
3113 |  | 484169
3113 |  | 462960
3113 |  | 460785
3113 |  | 453113
3113 |  | 423417
3113 |  | 403511
Spreadsheet: 693201d1598858141-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency
Sheet: PARTY WISE

 | SS LOOMTEX |  |  |  |  |  | MITTAL DYEING
 |  |  |  | MTR RECEIVED | KGS RECEIVED |  |  |  |  |  | MTR RECEIVED | KGS RECEIVED
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 11th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9278 | 0830 | [NAME] Urbrae High | 83726955 |  |  |  |  |  |  | 1 | Urbrae High School | Pt Noarlunga Aquatic Centre | y | 200 | 0 |  |  | 32 |  |  |  |  | [NAME]
 | 1415 | [NAME] Urbrae High | 83726955 |  |  |  |  |  |  | 1 | Pt Noarlunga Aquatic Centre | Urbrae High School | no | 200 | 0 |  |  | 32 |  |  |  |  | [NAME]
 | 1500 | Megan Premiers Department |  |  |  | 1 |  |  |  |  | 200 [NAME] [NAME] | Flinders Uni Registry Rd OppositeCar Park 6 wait and return 1630 | n | 200 | 0 |  | acct | 10 |  |  |  |  | VIP JOB [NAME]
 | 0840 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | Hallett Cove school | Chalkers Pool Hall Glenelg 112 [NAME] | y | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1020 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | 112 Jetty Rd Glenelg Chalkers Pool Hall | Hallett Cove School | n | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 0930 | [NAME] carmel college |  |  |  |  | 1 |  |  |  | Mt Carmel College Rosewater | St Clair Woodville | y | 99 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1139 | [NAME] carmel college |  |  |  |  | 1 |  |  |  | St Clair | Mt Carmel College | n | 99 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1440 | Adelaide High School |  |  |  | 1 |  |  |  |  | Adelaide High | [NAME] Secondary | y | 77 | 0 |  | acct | 12 |  |  |  |  | [NAME]
 | 1630 | Adelaide High School |  |  |  | 1 |  |  |  |  | [NAME] Secondary | Adelaide High | n | 77 | 0 |  | acct | 12 |  |  |  |  | [NAME]
 | 1445 | Adelaide High School |  |  |  | 1 |  |  |  |  | Adelaide High | Mitcham Girls | y | 77 | 0 |  | acct | 12 |  |  |  |  | [NAME]
 | 1630 | Adelaide High School |  |  |  | 1 |  |  |  |  | Mitcham Girls | Adelaide High | n | 77 | 0 |  | acct | 12 |  |  |  |  | [NAME]
 | 1300 | Marryatville High School | ted |  |  |  |  | 1 |  |  | Marryatville High School | Vertical Reality Climbing Holden Hill | y | 100 | 0 |  | acct | 24 |  |  |  |  | Dom
 | 1500 | Marryatville High School | ted |  |  |  |  | 1 |  |  | Vertical Reality Climbing Holden ill | Marryatville High | n | 100 | 0 |  | acct | 24 |  |  |  |  | Dom
 | 0900 | Grove School 39 [NAME] West SA 5011 | [NAME] |  |  |  | 1 |  |  |  | The Grove School 39 [NAME] By the orange Fronted Bld | Henley High School- Via Woodville High School | y | 99 | 0 |  | acct | 20 |  |  |  |  | Cat
 | 1415 | Grove School 39 [NAME] West SA 5011 | [NAME] |  |  |  | 1 |  |  |  | Henley High School | The Grove School | n | 99 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Do [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Malaysian Airlines CXLD for today | No Transfers
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0800 Hotel
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0900 Apt
TOTAL
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: JANTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | GROSS P/L | PIPS | DEPOSITS & WITHDRAWALS
 |  |  |  |  |  |  |  |  | 36.97
Week Sub Total
Week Sub Total
 |  |  |  |  |  |  |  |  | 50
Week Sub Total
Week Sub Total
 |  |  |  |  |  |  |  |  | 50
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSE $ | WIN % | LOSE % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ (MONTH) |  |  |  |  |  | AV. PROFIT $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 1ba10c54-84eb-4025-87f9-fdfda6ea2a8f
Sheet: Sheet1

Unnamed: 0 | Total Cav | Yield | [NAME] | CM | RF Units
2006 | 40 | 0.7
2007 | 160 | 0.8 | 28
2008 |  |  | 128 | 3 | 1?
2009 |  |  |  | 16 | 1
2010 |  |  |  |  | 3
Spreadsheet: 884695d1733941816-count-if-of-non-zero-s-in-column-that-also-are-not-duplicates-in-another-column-unique-count-etaf
Sheet: Sheet1

Apple | User1 | 100
Apple | User2 | 0
[NAME] | User3 | 50
[NAME] | User4 | 60
[NAME] | User1 | 70
[NAME] | User4 | 0
Durian | User4 | 0
Durian | [NAME] | 10
Eggplant | [NAME] | 0
Spreadsheet: 85423d1285527845-pivot-table-test
Sheet: Sheet5

 |  |  |  |  | Required Pivot Table Format.
 |  |  |  |  |  | Year
 |  |  |  | [NAME] | Account Head | 2007 | 2008 | 2009 | Amount
 |  |  |  |  | I want to build the pivot table in the above format.
 | [NAME] | Account Head | 2007 | 2008 | 2009 | Amount
 | Sum of Amount
 |  |  | 2007 | 2008 | 2009 | Amount
 | 40765
 |  | Others |  | 15066 |  | 15066
 |  | Telephone Bill |  | 816 |  | 816
 |  | Uniform |  | 3290 |  | 3290
 | 47810
 |  | Water Bill | 2132 |  |  | 2132
 |  | Uniform | 760 |  |  | 760
 | 56840
 |  | Electricity Bill | 788 |  | 1232.33 | 2020.33
 |  | Insurance | 6767 |  |  | 6767
 |  | Interest Charges |  | 141.68 |  | 141.68
 |  | Others | 18757.01 | 220 | 13892 | 32869.01
 |  | Processing Fee | 203.01 |  |  | 203.01
 |  | [NAME] | 25.09 | 31.91 |  | 57
 |  | Travel Ticket | 2636.62 | 6235.26 |  | 8871.880000000001
 |  | Water Bill | 1147 | 3644.84 | 4050.63 | 8842.47
 |  | Uniform |  | 5590 |  | 5590
Spreadsheet: 157074d1337610453-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 3

 | # | Date | Description | Requested | Spent
 | 1 | 11/16-11/19 | Misc | 1798
 | 1 |  | Misc |  | 224
 | 1 |  | Misc |  | 787.8
 | 1 |  | Misc |  | 521.82
 | 1 |  | Misc |  | 20
 | 1 |  | Misc |  | 210.01
 | 1 |  | Misc |  | 34.5
 | 1 | 11/30 - 12/3 | Misc | 1048
 | 1 |  | Misc |  | 448
 | 1 |  | Misc |  | 600.2
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Expense
 | 2 | 2010-11-30 00:00:00 | Expense | 251.9 | 251.9
 | 2 | 2010-12-03 00:00:00 | Expense | 606.09 | 606.09
 | 2 | 2010-11-30 00:00:00 | Expense | 38 | 38
 | 2 | 2010-12-03 00:00:00 | Expense | 60 | 60
 | 2 | 2010-11-30 00:00:00 | Expense | 782.8 | 782.8
 | 2 |  | Expense
 | 2 | 2011-01-27 00:00:00 | Expense | 725.8 | 725.8
 | 2 | 2011-01-31 00:00:00 | Expense | 519.93 | 519.93
 | 2 |  | Expense | 224 | 224
 | 2 | 2011-02-11 00:00:00 | Expense | 46 | 46
 | 2 | 2011-02-11 00:00:00 | Expense | 49 | 49
 | 2 | 2010-02-08 00:00:00 | Expense | 20 | 20
 | 2 | 2011-02-09 00:00:00 | Expense | 158.12 | 158.12
 | 2 |  | Expense
 | 2 | 2011-02-08 00:00:00 | Expense | 347.8 | 347.8
 | 2 | 2011-02-08 00:00:00 | Expense | 317.2 | 317.2
 | 2 | 2011-02-09 00:00:00 | Expense | 212.4 | 212.4
 | 2 |  | Expense
 | 2 | 2011-02-22 00:00:00 | Expense | 275.4 | 275.4
 | 2 | 2011-02-22 00:00:00 | Expense | 275.4 | 275.4
 | 2 | 2011-02-10 00:00:00 | Expense | -142 |  | 142 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -56 |  | 56 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -290 |  | 290 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -62.6 |  | 62.6 | Req3
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3 |  |  |  |  | **Added back in due to the fact that [NAME] subtracted them from R#2
 | 3 |  |  |  |  | when they should not have been.  OFCA received the funds from DHS
 | 3 |  |  |  |  | and paid the reimbursements.
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 | 7
 | 7
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 40730d1239129410-adding-column-with-corresponding-names-target-recap2-2-
Sheet: Sheet1

 |  |  |  | TARGET RECAP |  |  |  | STORE | 2
 |  |  | MEAT | CHICKEN | GRILLED | NUGGET | POTATO | BACON | CRISPY | CMILK | WMILK | SPICY
MON | MGR | D
 | MGR | N
TUE | MGR | D
 | MGR | N
WED | MGR | D
 | MGR | N
THU | MGR | D
 | MGR | N
FRI | MGR | D
 | MGR | N
SAT | MGR | D
 | MGR | N
SUN | MGR | D
 | MGR | N
 |  | D
 | WEEK | N
 |  | T
TOT | MGR
 | MGR
 | MGR
 | MGR
 | + MEANS USED MORE THAN TARGET
Spreadsheet: 131a6e94-3233-4b88-9a3f-f7dc6f5864fb
Sheet: Sheet1

[NAME], Inc. and Subsidiaries | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Condensed Consolidated Statements of Income
(In thousands, except per share data)
 | Three Months Ended |  |  |  | Six Months Ended
 | June 30, |  |  |  | June 30,
 | 2010 |  | 2009 |  | 2010 |  | 2009
 | ([NAME]) |  |  |  | ([NAME])
Revenues
[NAME] sales | 764295 |  | 554612 |  | 1476169 |  | 1235652
Costs, expenses and other
Cost of coal sales | 570861 |  | 467521 |  | 1121611 |  | 1014647
Depreciation, depletion and amortization | 87759 |  | 68419 |  | 176278 |  | 141688
Amortization of acquired sales contracts, net | 5214 |  | 58 |  | 15967 |  | -170
Selling, general and administrative expenses | 35344 |  | 21627 |  | 62510 |  | 46741
Change in fair value of coal derivatives and coal trading activities, net | 4587 |  | -6458 |  | 10464 |  | -6986
Gain on Knight Hawk transaction | -41577 |  | 0 |  | -41577 |  | 0
Costs related to acquisition of Jacobs Ranch | 0 |  | 3025 |  | 0 |  | 6375
Other operating income, net | -4392 |  | -6889 |  | -7783 |  | -12524
 | 657796 |  | 547303 |  | 1337470 |  | 1189771
Income from operations | 106499 |  | 7309 |  | 138699 |  | 45881
Interest expense, net:
Interest expense | -35125 |  | -20657 |  | -70208 |  | -40675
Interest income | 623 |  | 417 |  | 961 |  | 6885
 | -34502 |  | -20240 |  | -69247 |  | -33790
Income (loss) before income taxes | 71997 |  | -12931 |  | 69452 |  | 12091
Provision for (benefit from) income taxes | 5723 |  | 2230 |  | 4948 |  | -3320
Net income (loss) | 66274 |  | -15161 |  | 64504 |  | 15411
Less: Net (income) loss attributable to noncontrolling interest | -118 |  | 35 |  | -144 |  | 42
Net income (loss) attributable to [NAME], Inc. | 66156 |  | -15126 |  | 64360 |  | 15453
Earnings (loss) per common share
Basic earnings (loss) per common share | 0.41 |  | -0.11 |  | 0.4 |  | 0.11
Diluted earnings (loss) per common share | 0.41 |  | -0.11 |  | 0.4 |  | 0.11
Weighted average shares outstanding
Basic | 162388 |  | 142815 |  | 162380 |  | 142802
Diluted | 163130 |  | 142815 |  | 163105 |  | 142924
Dividends declared per common share | 0.1 |  | 0.09 |  | 0.19 |  | 0.18
Adjusted EBITDA (A) (unaudited) | 199354 |  | 78846 |  | 330800 |  | 193816
(A) Adjusted EBITDA is defined and reconciled under "Reconciliation of Non-GAAP Measures" later in this release.
Spreadsheet: 112128d1308261335-excel-2007-calculating-numbers-needed-to-achieve-best-result-helpexample
Sheet: example

2010 | 51 |  | 0.5 | 5
39159 | 1065 |  | 0.8 | 0.75
3334 | 84 |  | 0.9 | 0.25
13272 | 366 |  | 0.1 | 2
12738 | 129 |  | 0.15 | 1
14336 | 115 |  | 0.87 | 0.57
2183 | 18 |  | 0.24 | 0.65
5902 | 39 |  | 0.972 | 0.76
29353 | 269 |  | 0.0165 | 0.8
13034 | 132 |  | 0.87 | 3
Spreadsheet: 724766d1616360476-index-aggregate-or-match-return-values-from-row-based-on-match-book5
Sheet: Sheet1

 | Component | Component | Component | Box | Label | Bag
Beverage | [Item] Tea | [Item] Juice |  | Box A | [NAME] | Bag S |  | Flower | [Item] Tulip |  |  | Box |  | 4
Flower | [Item] Tulip |  |  | [NAME] | [NAME] | Bag M |  | Flower | [NAME]
Furniture | [Item] Table | [Item] Chair | [Item] Couch | Box C | [NAME] | Bag L |  | Flower | [NAME]
Food | [Item] Bacon | [Item] Egg |  | Box D | [NAME] | Bag XL |  | Flower | Bag M
 |  |  |  |  |  |  |  | Beverage | [Item] Tea
 |  |  |  |  |  |  |  | Beverage | [Item] Juice
 |  |  |  |  |  |  |  | Beverage | Box A
 |  |  |  |  |  |  |  | Beverage | [NAME]
 |  |  |  |  |  |  |  | Beverage | Bag S
 |  |  |  |  |  |  |  | Food | [Item] Bacon
 |  |  |  |  |  |  |  | Food | [Item] Egg
 |  |  |  |  |  |  |  | Food | Box D
 |  |  |  |  |  |  |  | Food | [NAME]
 |  |  |  |  |  |  |  | Food | Bag XL
Spreadsheet: 51825d1251427689-mysterious-problem-facing-with-function-ratemacro
Sheet: Sheet2

Count of TAKA | TAKA
MOVEMENT AREA | 1300 | 1600 | 3600 | 3700 | 4200 | 4600 | 4800 | 5200 | 7200 | 9200 | Grand Total | REQUIRED VALUE
BOGRA |  |  | 2 | 1 | 1 |  |  |  |  | 1 | 5 | 3600*2+3700*1+4200*1+9200*1
CHITTAGONG |  |  |  |  |  |  | 2 |  |  |  | 2 | 4800*2
COX'S BAZAR |  |  |  |  |  |  |  |  |  | 2 | 2 | 9200*2
DINAJPUR |  |  |  |  |  | 2 | 1 |  |  |  | 3 | 4600*2+4800*1
KONABARI |  |  |  |  | 5 | 2 | 4 |  |  |  | 11 | 4200*5+4600*2+4800*4
KUSHTIA | 2 | 1 |  |  |  |  |  |  |  |  | 3 | 1300*2+1600*1
M. BAZAR |  |  |  |  |  |  |  |  | 1 |  | 1 | 7200*1
PABNA |  |  | 1 |  |  |  |  | 1 |  |  | 2 | 3600*1+5200*1
RANGPUR |  |  |  |  | 1 |  |  |  |  |  | 1 | 4200*1
TANGAIL |  |  |  |  |  | 1 |  | 1 |  |  | 2 | 4600*1+5200*1
Grand Total | 2 | 1 | 3 | 1 | 7 | 5 | 7 | 2 | 1 | 3 | 32