tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32567d1228762870-formula-and-percentages-against-user-set-numbers-defect_units
Sheet: Sheet1

Board No | DJ | BRD | MS | WV | MP | US | DC | Total Errors | % Errors |  | Total Boards
DU001 | 8 | 0 | 3 | 0 | 0 | 5 | 0 | 16 | 0.2388059701492537 |  | ???? | total of boards Inspected to be put here !!!!
DU002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Unnecessary, this LIST will now autoexpand
DU004 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | as you add entries at the bottom. Much easier.
DU005 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 8 | 0.1194029850746269
DU006 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 0.1194029850746269
DU008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Counts all errors in Column I, then
DU009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | divides the count in one row against the total
DU010 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 0.07462686567164178
DU011 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU012 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU014 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0.02985074626865672
DU015 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU016 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU019 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 0.08955223880597014
DU020 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0.07462686567164178
DU021 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU023 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU025 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU026 | 0 | 0 | 0 | 6 | 5 | 0 | 0 | 11 | 0.1641791044776119
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU028 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 6 | 0.08955223880597014
DU029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU031 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DU032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Errors | 13 | 0 | 8 | 22 | 5 | 11 | 8 | 67 | Total |  | these totals will self-adjust as rows add themselve above
% of Errors | 0.1940298507462687 | 0 | 0.1194029850746269 | 0.3283582089552239 | 0.07462686567164178 | 0.1641791044776119 | 0.1194029850746269 | 1
% of Passed | 0.8059701492537313 | 1 | 0.8805970149253731 | 0.6716417910447761 | 0.9253731343283582 | 0.835820895522388 | 0.8805970149253731 | ??
Overall % | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ?? |  |  | Isn't this always just 100%? Is it necessary? Please clarify.
Spreadsheet: 107382d1304571415-need-to-sum-scores-from-different-teams-mock-summary-by-team
Sheet: Sheet1

Team Scores
Name | Team # | Score
Player A | 1 | 55
Player B | 2 | 48
Player C | 1 | 18
Player D |  | 25
Player E | 2 | 44
Player F | 1 | 38
Player G |  | 60
Player H | 2 | 49
Player I |  | 41
Player J | 3 | 29
Player K | 3 | 33
Player L |  | 34
Player M | 3 | 50
Team | Team # & Player Names | Aggregate Score
1st Place | Team 2 (Player B, Player E, Player H) | 141
2nd Place
3rd Place
 | ^Need equations to automatically calculate
 | ^Sample output text/values included
Spreadsheet: errol_mclaughlin_jr__10070__Bkrqs821
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request # 821
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
NG-X-OPT-NG | NG-X-OPT-NG |  |  | X | )B | DESK | X | X | X | X |  |  | NG/MMBTU/USD | [NAME] | MTM | [NAME] | ASAP
NG-X-OPT-WTI | NG-X-OPT-WTI |  |  | X | )C | DESK | X |  |  |  |  |  | WTI/BBL/USD | [NAME] | MTM | [NAME] | ASAP
NG-X-OPT-PWR | NG-X-OPT-PWR |  |  | X | )D | DESK | X |  |  |  |  |  | PWRC/MWH/USD | [NAME] | MTM | [NAME] | ASAP
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JV
emclaug |  |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JV
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JV
kloibl |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
ghuan |  |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
 |  |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52465)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)
Spreadsheet: 691889d1597935100-max-formula-only-working-for-the-first-cell-samplespreadsheet2
Sheet: Sheet3

TeamName | Number of values for this team |  |  |  | [NAME] by [NAME] | What the value should be | Match?
TeamD | 1 |  |  | TeamD |  | 4
TeamD | 2 |  |  | TeamC |  | 1
TeamD | 3 |  |  | TeamB |  | 2
TeamD | 3 |  |  | TeamA |  | 1
TeamD | 4
TeamC | 1
TeamB | 1
TeamB | 2
TeamA | 1
Spreadsheet: 315ee1fc-10b9-4dd6-a85d-01f8d24e3d8b
Sheet: Country

Country | Titles | Percentage
France | 65
Germany | 44
Italy | 34
Spain | 30
Russia | 27
Sweden | 24
Argentina | 17
Japan | 17
Norway | 16
Israel | 14
South Korea | 13
Poland | 12
Turkey | 12
China | 11
Denmark | 10
Quebec | 10
Brazil | 9
Indonesia | 9
Netherlands | 9
Austria | 7
Finland | 6
Iceland | 6
Switzerland | 6
Algeria | 5
Chile | 5
Greece | 5
Mexico | 5
Cuba | 4
Hungary | 4
Iran, Islamic Republic of | 4
Iraq | 4
Lebanon | 4
Romania | 4
Belgium | 3
Bulgaria | 3
Czech Republic | 3
Egypt | 3
India | 3
Peru | 3
Various | 3
Estonia | 2
Ireland | 2
Lithuania | 2
Morocco | 2
Portugal | 2
Puerto Rico | 2
Saudi Arabia | 2
Syrian Arab Republic | 2
Taiwan | 2
Viet Nam (Vietnam) | 2
Albania | 1
Armenia | 1
Azerbaijan | 1
Belarus | 1
Cameroon | 1
Colombia | 1
Congo | 1
Costa Rica | 1
Croatia | 1
Dominican Republic | 1
Ecuador | 1
Guatemala | 1
Haiti | 1
Latvia | 1
Mozambique | 1
Oman | 1
Pakistan | 1
Serbia and Montenegro | 1
Slovenia | 1
South Africa | 1
Togo | 1
Ukraine | 1
Venezuela | 1
Wales | 1
Spreadsheet: 190462d1351661681-vlookup-using-text-in-multiple-cells-as-lookup-value-example
Sheet: Sheet2

Code | Name | Price
14520200 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X10PL | 24.15
14520300 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X12PL | 26.2
14520400 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X16PL | 30.28
14520600 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X20PL | 34.46
14520800 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X25PL | 39.58
14521000 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X30PL | 44.78
14521100 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X35PL | 50.27
14521200 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X40PL | 55.48
14521400 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X45PL | 60.59
14521500 | GB/T5781Hex Bolt FT CL4.8 M5-0.8X50PL | 65.79
14525400 | GB/T5781Hex Bolt FT CL4.8 M6-1x12PL | 43.04
14525500 | GB/T5781Hex Bolt FT CL4.8 M6-1x16PL | 48.54
14525700 | GB/T5781Hex Bolt FT CL4.8 M6-1x20PL | 54.05
14525900 | GB/T5781Hex Bolt FT CL4.8 M6-1x25PL | 59.27
Spreadsheet: 790442d1659707364-using-lookup-to-find-the-1st-2nd-3rd-and-4th-value-test-how-to-return-nth-value-in-lookup
Sheet: Sheet1

School name | Subject 1 | Price | Subject 2 | Price | Subject 3 | Price | Subject 4 | Price
St Marys School
St Peters School
London Free School
St Pauls Academy
Spreadsheet: 062dea67-04e5-42cf-a9ce-d9c06cfd813d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 0d559763-5d18-41d8-aacd-eba6e073d806
Sheet: 360 Sprints

360 Sprints
Place | Car # | Name | 2014-04-12 00:00:00
1 | 11 | [NAME] | 67
2 | 22 | [NAME] | 66
3 | 71 | [NAME] | 63
4 | 5N | [NAME] | 55
5 | 22R | [NAME] | 54
6 | 4 | [NAME] | 48
7&8 | 10 | [NAME] | 45
7&8 | 70 | [NAME] | 45
9 | 6A | [NAME] | 41
10 | 71JR | [NAME] | 38
11 | 28 | [NAME] | 37
12 | 16 | [NAME] | 15
Spreadsheet: 454b0dd6-3307-496e-9a9f-45881e692361
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-01-04 09:35:25.810000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.825 | 101.7 | 101.575 | 101.2
4.25 | 101.583 | 101.458 | 101.333 | 100.958 |  | Note: | Refer To Price [NAME]
4.125 | 101.089 | 100.964 | 100.839 | 100.464 |  |  | For all Price Adjs
4 | 100.661 | 100.536 | 100.411 | 99.786
3.875 | 100.124 | 99.999 | 99.874 | 99.249
3.75 | 99.288 | 99.163 | 99.038 | 98.413
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.522 | 101.397 | 101.272 | 100.897
3.625 | 101.27 | 101.145 | 101.02 | 100.645
3.5 | 100.956 | 100.831 | 100.706 | 100.331
3.375 | 100.551 | 100.426 | 100.301 | 99.676
3.25 | 99.999 | 99.874 | 99.749 | 99.124
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-01-18 09:35:25.810000
30 DAY | 2012-02-02 09:35:25.810000
45 DAY | 2012-02-17 09:35:25.810000
60 DAY | 2012-03-03 09:35:25.810000
90 DAY | 2012-04-02 09:35:25.810000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 33087d1229368456-list-without-repetitions-duplicates-listed-singly
Sheet: Sheet1

 |  |  |  |  | Names | Summary
 |  |  |  |  | bob | [NAME] 3 times |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 3 times
 |  |  |  |  | [NAME] | [NAME] 3 times |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 3 times
 |  |  |  |  | mark | [NAME] 4 times |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 4 times
 |  |  |  |  | lisa | [NAME] 7 times |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 7 times
 |  |  |  |  | mark | [NAME] 4 times
 |  |  |  |  | [NAME] | [NAME] 3 times
 |  |  |  |  | lisa | [NAME] 7 times
 |  |  |  |  | lisa | [NAME] 7 times
 |  |  |  |  | bob | [NAME] 3 times
 |  |  |  |  | mark | [NAME] 4 times
 |  |  |  |  | lisa | [NAME] 7 times
 |  |  |  |  | lisa | [NAME] 7 times
 |  |  |  |  | bob | [NAME] 3 times
 |  |  |  |  | [NAME] | [NAME] 3 times
 |  |  |  |  | mark | [NAME] 4 times
 |  |  |  |  | lisa | [NAME] 7 times
 |  |  |  |  | lisa | [NAME] 7 times
Spreadsheet: 828593d1683628921-pulling-data-across-sheets-in-workbook-squad-depth
Sheet: Config

 |  | Positions
 |  | GK | 1
 |  | RB | 2
 |  | RCB | 3
 |  | LCB | 4
 |  | LB | 5
 |  | DM | 6
 |  | RCM | 7
 |  | LCM | 8
 |  | RW | 9
 |  | LW | 10
 |  | CF | 11
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: All

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Abate | [NAME] | T503 | 7103 | 1003 | 3 | 78 | 76 | 75 | 90 | 70
Abbott | [NAME] | T103 | 1701 | 4501 | 1 | 100 | 100 | 68 | 100 | 100
Abel | [NAME] | T103 | 1101 | 1301 | 1 | 60 | 92 | 80 | 100 | 90
Abt | [NAME] | T203 | 5001 | 5301 | 1 | 88 | 84 | 70 | 100 | 70
Adams | Blaine | T103 | 1103 | 1303 | 3 | 100 |  | 100 | 80 | 100
Aguilar | [NAME] | T103 | 1701 | 1801 | 1 | 82 | 85 | 75 | 80 | 50 | 2,4,5,7,10 | 2010-11-08 00:00:00
Spreadsheet: 150970d1334749443-graph-format-825664
Sheet: Sheet3

 | 2010 | 2011 | 2012
Strongly Agree | -0.01 | 0.235632183908046 | 0.2241379310344828
Agree | -0.01 | 0.3620689655172414 | 0.5862068965517241
Neutral | -0.01 | 0.08620689655172414 | 0.1206896551724138
Disagree | -0.01 | 0.07471264367816093 | 0.06465517241379311
Strongly Disagree | -0.01 | 0.01149425287356322 | 0.004310344827586207
Spreadsheet: 214746d1361104286-assigning-numerical-value-to-text-in-data-validation-list-book1-autosaved-
Sheet: Sheet1

 |  | Example Calendar
 |  | Feb'13
 |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  | 1 | 2
 |  |  |  |  |  |  | Employee A 24 | Employee A Night
Emp A Day | 10 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Emp A 24 | 24 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  |  | Employee A Night
Emp A Night | 14 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  |  |  | Employee A Day
 |  | 24 | 25 | 26 | 27 | 28
 |  |  |  |  |  |  | Employee A Night | Employee A Day
 |  | Feb'13
 |  | S | M | T | W | T | F | S | Sum of Hours
Spreadsheet: 10001d64-c19e-44f3-b829-71a7f513c7eb
Sheet: Balance Sheet

The NASDAQ OMX Group, Inc.
Consolidated Balance Sheets
(in millions)
 |  |  |  | December 31, |  | December 31,
 |  |  |  | 2011 |  | 2010
 | Assets |  |  | (unaudited)
 | Current assets:
 |  | Cash and cash equivalents |  | 506 |  | 315
 |  | Restricted cash |  | 43 |  | 60
 |  | Financial investments, at fair value |  | 279 |  | 253
 |  | Receivables, net |  | 308 |  | 298
 |  | Deferred tax assets |  | 16 |  | 13
 |  | Open clearing contracts:
 |  | Derivative positions, at fair value |  | 1566 |  | 4037
 |  | Resale agreements, at contract value |  | 3745 |  | 3441
 |  | Other current assets |  | 110 |  | 93
 | Total current assets
 | Non-current restricted cash |  |  | 105 |  | 105
 | Property and equipment, net |  |  | 193 |  | 164
 | Non-current deferred tax assets |  |  | 392 |  | 433
 | Goodwill |  |  | 5061 |  | 5127
 | Intangible assets, net |  |  | 1648 |  | 1719
 | Other non-current assets |  |  | 119 |  | 149
 | Total assets
 | Liabilities
 | Current liabilities:
 |  | Accounts payable and accrued expenses |  | 164 |  | 142
 |  | Section 31 fees payable to SEC |  | 106 |  | 82
 |  | Accrued personnel costs |  | 132 |  | 122
 |  | Deferred revenue |  | 124 |  | 122
 |  | Other current liabilities |  | 121 |  | 119
 |  | Deferred tax liabilities |  | 27 |  | 26
 |  | Open clearing contracts:
 |  | Derivative positions, at fair value |  | 1566 |  | 4037
 |  | Repurchase agreements, at contract value |  | 3745 |  | 3441
 |  | Current portion of debt obligations |  | 45 |  | 140
 | Total current liabilities
 | Debt obligations |  |  | 2072 |  | 2181
 | Non-current deferred tax liabilities |  |  | 670 |  | 698
 | Non-current deferred revenue |  |  | 154 |  | 170
 | Other non-current liabilities |  |  | 179 |  | 198
 | Total liabilities
 | Commitments and contingencies
 | Equity
 | NASDAQ OMX stockholders' equity:
 | Common stock |  |  | 2 |  | 2
 | Additional paid-in capital |  |  | 3793 |  | 3780
 | Common stock in treasury, at cost |  |  | -860 |  | -796
 | Accumulated other comprehensive loss |  |  | -350 |  | -272
 | Retained earnings |  |  | 2391 |  | 2004
 | Total [NAME] stockholders' equity
 | Noncontrolling interests |  |  | 10 |  | 11
 | Total equity
 | Total liabilities and equity
Spreadsheet: 334d1aac-bcf3-45bc-8697-7f7e9e3243cd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C5AG | Test | C5AG | [NAME], Antigen, Serum | [NAME], Antigen, S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting 2. Spin down and separate serum from clot. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 10.6-26.3 mg/dL | Monday through Saturday; [NAME] with a 3 p.m. cutoff | Same day/1 day | 3 days | 1 | 86160 |  |  |  |  | Rochester
C5AG | [NAME] | SERUM | Serum |  |  |  | Frozen | 60 days
C5AG | Result | C5AG | [NAME], Antigen, S | [NAME], Antigen, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4505-4
Spreadsheet: fa3a962a-e3cd-409c-9f19-84f212f05652
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CAFF | Test | CAFF | Caffeine, Serum | Caffeine, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 5-15 mcg/mL Toxic concentration: > or =30 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80299 |  |  |  |  | Rochester
CAFF | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CAFF | Result | 8754 | Caffeine, S | Caffeine, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3422-3
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-7

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-17 00:00:00
 |  |  | Monitoring Well #: | MW-7 |  |  |  | Well Depth: | 7.46 |  | ft |  |  | Screened/Open Interval: | 2-8' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 4.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 0 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 1220 | x |  | 7.64 | NA | 12.5 | NA | 122 | NA | 4.23 | NA | 69.4 | NA | 44.6 | NA | 220 | 0.6
 | 1225 | x |  | 7.34 |  | 12.5 |  | 120 |  | 4 |  | 74.2 |  | 37.4 |  | 220 | 0.6
 | 1230 | x |  | 7.02 |  | 12.6 |  | 119 |  | 3.67 |  | 81.3 |  | 31.7 |  | 220 | 0.6
 | 1235 | x |  | 6.99 |  | 12.6 |  | 119 |  | 3.54 |  | 82.8 |  | 24.1 |  | 220 | 0.6
 | 1240 | x |  | 6.9 |  | 12.5 |  | 124 |  | 3.1 |  | 87.6 |  | 19.6 |  | 220 | 0.6
 | 1245 | x |  | 6.86 |  | 12.4 |  | 132 |  | 3.08 |  | 93.4 |  | 14 |  | 220 | 0.6
 | 1250 | x |  | 6.85 |  | 12.4 |  | 133 |  | 2.95 |  | 95 |  | 6.8 |  | 220 | 0.6
 | 1255 | x |  | 6.8 |  | 12.5 |  | 163 |  | 2.65 |  | 98 |  | 8.63 |  | 220 | 0.6
 | 1300 | x |  | 6.8 |  | 12.5 |  | 168 |  | 2.58 |  | 97.7 |  | 5.8 |  | 220 | 0.6
 | 1305 | x |  | 6.77 |  | 12.4 |  | 183 |  | 2.44 |  | 99.1 |  | 4.08 |  | 220 | 0.6
 | 1310 | x |  | 6.76 |  | 12.4 |  | 185 |  | 2.41 |  | 98.5 |  | 3.98 |  | 220 | 0.6
 | 1315 | x |  | 6.76 |  | 12.3 |  | 187 |  | 2.31 |  | 95.3 |  | 3.74 |  | 220 | 0.6
 | 1320 |  | x | 6.76 |  | 12.3 |  | 193 |  | 2.24 |  | 92.7 |  | 3.76 |  | 220 | 0.6
 | 1325 |  | x | 6.74 |  | 12.5 |  | 217 |  | 1.96 |  | 78.9 |  | 3.02 |  | 220 | 0.6
 | 1330 |  | x | 6.73 |  | 12.5 |  | 223 |  | 1.98 |  | 77.7 |  | 2.84 |  | 220 | 0.6
 | Comments:
 |  | Purge start: |  |  | 12:14:00 |  |  | Sample time: |  | 13:17:00
 |  | Purge end: |  |  | 13:15:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity