tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723304d1615620839-lookup-formula-to-return-sum-value-from-separate-workbook-daily-plod-tracker-test
Sheet: Febuary

Date | Location | Program ID - if applicable | Work Type - Rehab/Clearing | Machine type | Hours | Timesheet Number | Rate | cost
2021-02-01 00:00:00 | Moody's Reward |  | Clearing | HV mob | 2 | 5701
2021-02-01 00:00:00 | Moody's Reward |  | Clearing | Excavator 190, 170 | 3 | 5701
2021-02-01 00:00:00 | [NAME] |  | Rehab | Loader volvo | 1.5 | 5702
2021-02-01 00:00:00 | [NAME] |  | Rehab | Loader volvo | 10.5 | 5702
2021-02-02 00:00:00 | Moody's Reward |  | Rehab | Excavator 190, 170 | 5 | 5703
2021-02-02 00:00:00 | [NAME] |  | Rehab | Loader volvo | 12 | 5704
2021-02-03 00:00:00 | [NAME] |  | Rehab | Loader volvo | 12 | 5706
2021-02-05 00:00:00 | [NAME] |  | Rehab | Loader volvo | 7 | 5710
2021-02-05 00:00:00 | [NAME] |  | Rehab | HV mob | 2 | 5710
2021-02-09 00:00:00 | Moody's Reward |  | Clearing | Excavator 190, 170 | 6 | 5717
2021-02-09 00:00:00 | Moody's Reward |  | Clearing | HV mob | 2 | 5717
2021-02-10 00:00:00 | [NAME] sth |  | Misc | Bobcat | 2 | 5719 |  |  | Repair core shed entry
2021-02-10 00:00:00 | Whirling Dervish Sth |  | Rehab | Loader volvo | 2.5 | 5720
2021-02-11 00:00:00 | Luvironza |  | Misc | Excavator 190, 170 | 2 | 5723 |  |  | [NAME] recovery training ground
2021-02-11 00:00:00 | Whirling Dervish Nth |  | Rehab | Excavator 190, 170 | 3 | 5723
2021-02-12 00:00:00 | Memphis | ME02 | Clearing | Loader volvo | 8.5 | 5726
2021-02-12 00:00:00 | Memphis | ME02 | Clearing | Excavator 190, 170 | 3.5 | 5726
2021-02-13 00:00:00 | Memphis | ME02 | Clearing | Excavator 190, 170 | 10.5 | 5731
2021-02-15 00:00:00 | Luvironza |  | Misc | Bobcat | 2.5 | 5737 |  |  | [NAME] recovery training ground
2021-02-15 00:00:00 | Luvironza |  | Misc | 15t tipper | 2 | 5736 |  |  | [NAME] recovery training ground
2021-02-24 00:00:00 | Qena | QS02 | Clearing | Loader volvo | 4.5 | 5644
2021-02-24 00:00:00 | Qena | QS02 | Clearing | Excavator 190, 170 | 4 | 5644
2021-02-24 00:00:00 | Million Dollar | MD05 | Clearing | Bobcat | 2.5 | 5645
2021-02-24 00:00:00 | Million Dollar | MD05 | Clearing | HV mob | 3.5 | 5645
 |  |  |  |  |  |  |  |  | Months Total
Spreadsheet: 490414d1479847168-have-dates-update-book-4
Sheet: Sheet1

 |  |  |  | First biz day of next mo = | 2016-12-01 00:00:00
 |  |  | Quantity | Total Price |  |  |  |  |  |  |  |  | Quantity | Total Price
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1078636.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 2489654.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 915988.41
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 54479
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 83166
 |  |  | 100000 | 1000000
 |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 131247
 |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 131247
 |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 131247
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 131247
 |  |  |  |  |  |  |  |  |  |  |  |  | 228 | 131247
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Total invoices selected for payment here:
Spreadsheet: 791392d1660320300-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Nov

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Payments
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Allocated
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Newly Allocated
Spreadsheet: 475703d1471429735-copy-a-table-of-formulas-andmaintain-pattern-of-data-extraction-please-can-someone-help-q2-excel
Sheet: table to populate

Factor 1 | Factor 2 | Factor 3 | Factor 4 | Factor 5
Factor 6
Factor 7 | G | Factor 8
Factor 9
Factor 10
Factor 11
Factor 12
Factor 13
Factor 14
Factor 15
Factor 16
Factor 17
Factor 18
Factor 1 | Factor 2 | Factor 3 | Factor 4 | Factor 5 |  |  |  |  | Factor 1 | Factor 2 | Factor 3 | Factor 4 | Factor 5
 |  |  |  |  |  |  | should be like this>>> |  | A2 | B2 | C2 | D2 | E2
Factor 6 |  |  |  |  |  |  |  |  | Factor 6 | etc
Factor 7 | G | Factor 9 |  |  |  | <<not like this |  |  | Factor 7 | etc | Factor 9 | etc
Factor 9 |  |  |  |  |  |  |  |  | Factor 9 | etc
Factor 10 |  |  |  |  |  |  |  |  | Factor 10 | etc
Factor 11 |  |  |  |  |  |  |  |  | Factor 11 | etc
Factor 12 |  |  |  |  |  |  |  |  | Factor 12 | etc
Factor 13 |  |  |  |  |  |  |  |  | Factor 13 | etc
Factor 14 |  |  |  |  |  |  |  |  | Factor 14 | etc
Factor 15 |  |  |  |  |  |  |  |  | Factor 15 | etc
Factor 16 |  |  |  |  |  |  |  |  | Factor 16 | etc
Factor 17 |  |  |  |  |  |  |  |  | Factor 17 | etc
Factor 18 |  |  |  |  |  |  |  |  | Factor 18 | etc
 | I intend to drag and drop table/formula this way
Spreadsheet: 228579d1366148110-return-latest-reported-figure-by-firm-in-panel-data-excel-help-needed
Sheet: Input

What I want is the last reported employee figure per Firm ID, and the corresponding reporting date.
If no employee value ever entered for a given Firm ID, should still return a blank for that Firm ID, i.e. no Firm ID should be excluded.
SAMPLE INPUT |  |  |  |  |  |  | ACCEPTABLE SUMMARY OUTPUT |  |  |  |  | DESIRED SUMMARY OUTPUT
Firm ID | Date | Revenues | Profits | Employees |  |  | Firm ID | Date | Employees |  |  | Firm ID | Date | Employees
3 | 2011-12-31 00:00:00 | 52 | 32 |  |  |  | 500 | 2012-03-01 00:00:00 | 41 |  |  | 3
6 | 2008-12-31 00:00:00 |  |  | 97 |  |  | 36 | 2012-07-01 00:00:00 | 498 |  |  | 500 | 2012-03-01 00:00:00 | 41
17 | 2013-01-01 00:00:00 | 555 | 200 |  |  |  | 17 | 2011-08-01 00:00:00 | 477 |  |  | 36 | 2012-07-01 00:00:00 | 498
17 | 2011-08-01 00:00:00 | 23 | -10 | 477 |  |  | 6 | 2008-12-31 00:00:00 | 97 |  |  | 17 | 2011-08-01 00:00:00 | 477
17 | 2010-08-01 00:00:00 | 38 |  | 37 |  |  |  |  |  |  |  | 42
17 | 2009-08-01 00:00:00 | 33 | 10 |  |  |  |  |  |  |  |  | 6 | 2008-12-31 00:00:00 | 97
36 | 2012-07-01 00:00:00 | 666 | 150 | 498 |  |  |  |  |  |  |  | 57888
36 | 2012-05-01 00:00:00 | 888 | 77
36 | 2011-09-01 00:00:00 |  | 32 | 353
36 | 2011-08-01 00:00:00 | 777 |  | 350
42 | 2011-07-30 00:00:00 | 1000
42 | 2009-07-30 00:00:00 |  | 0
500 | 2012-04-01 00:00:00 | 23 | 1
500 | 2012-03-01 00:00:00 | 45 |  | 41
500 | 2012-01-01 00:00:00 |  |  | 42
57888 | 2008-12-31 00:00:00 |  | 37
Spreadsheet: 185230d1349588533-using-max-ranges-and-match-to-reference-cells-to-3-highest-numbers-records
Sheet: Compilation

RECORD |  | 2012
 | OWNER | PLAYER | TEAM | POINTS | DATE
Most points by a team, game
Most points game, QB |  | Eli Manning | NYG | 50
 |  | Eli Manning | NYG | 44.2
 |  | [NAME] | ATL | 32.46
Most points game, RB |  | [NAME] | KC | 44.8
 |  | [NAME] | MIA | 41.7
 |  | [NAME] | JAC | 35.3
Most points game, WR |  | [NAME] | ATL | 38.9
 |  | Hakeem Nicks | NYG | 35.9
 |  | A.J. Green | CIN | 35.4
Most points game, TE |  | [NAME] | SF | 19.3
 |  | [NAME] | BUF | 18.2
 |  | A.J. Green | DAL | 17.2
Most points game, K |  | [NAME] | DET | 21
 |  | [NAME] | DET | 21
 |  | [NAME] | ATL | 20
Most points game, DEF |  | Chicago | CHI | 26
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 19

TABLE 19
LARGEST CITY IN THE COUNTY
GOVERNMENT
City Government
Form (Structure), such as Mayor/Council
No. of Elected Officials
Mayor
Name
Years in Office
Next Election Date
City Manager (Yes or No)
County Government
Form (Structure), such as County Commission
No. of Elected Officials
Top Elected Officials
Name
Title
Years in Office
Next Election Date
County Manager (Yes or No)
State Government
Form (Structure), such as Assembly and Senate
No. of Elected Officials
Upper House Representing Area
Total Statewide Upper House
Lower House Representing Area
Total Statewide Lower House
Does legislature convene
Twice a Year
Once a Year
Every Two Years
Governor
Name
Years in Office
Current Term Expiration Date
Allowed to Run for Another Term (Yes or No)
Next Election Date
US Government Representation
Congressional Districts Listed by District No. in the Service Area
US Congresspersons Serving the Area
Name
Years in Office
Current Term Expiration Date
Next Election Date
US Senators
Name
Years in Office
Current Term Expiration Date
Next Election Date
Spreadsheet: 684996d1593654218-need-formula-for-dynamic-averaging-of-certain-values-and-range-forum-question
Sheet: 2020

 |  |  | Target: |  |  | Days remaining in Year:
Day | Date | Gross Profit | Helper
 |  |  | Column
 | 2020-06-22 00:00:00 | 1125
 | 2020-06-23 00:00:00 | 1875
 | 2020-06-24 00:00:00 | 762.5
 | 2020-06-25 00:00:00 | 537.5
 | 2020-06-26 00:00:00 | 975 |  |  |  | Average of Highest $ amount in each 5 day period:
 | 2020-06-29 00:00:00 | 1000
 | 2020-06-30 00:00:00 | 1000
 | 2020-07-01 00:00:00 | 725
 | 2020-07-02 00:00:00 | 500
 | 2020-07-03 00:00:00 | 2030
 | 2020-07-04 00:00:00 | 1000
 | 2020-07-05 00:00:00 | 2000
 | 2020-07-06 00:00:00 | 300
Spreadsheet: 46363d1245251388-vlookup-and-dates-copy-of-2009-catalog-tracker-1
Sheet: Catalog

Complete Sales Orders? |  |  | Notes | Epicor SO | ORDER_ID | ORDERED_BY | SHIPTONUM | SUBMITTED_DATE |  | Date Entered in Epicor | Option 3 | Recived? | HC WH | Sent | [NAME] date | Qty Lines Shipped | Qty Lines Backorder | PSG | Sent | [NAME] date |  | Main warehouse | Sent | Print | Sent | Who | Booked Job | Sent to Prod. | Pack Complete Date | [NAME] date | Packing slip approved | [NAME] Closed | Comments |  |  |  |  |  |  |  | # of Lines | # of Open Lines |  | #N/A | #N/A
 | 1 |  |  | 197773 | 36573 | [NAME] | 1231 | 2009-06-11 00:00:00 | 6/11/2009 | 2009-06-11 00:00:00 |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 7
 | 1 |  |  | 197775 | 36652 | [NAME] | 1231 | 2009-06-11 00:00:00 | 6/11/2009 | 2009-06-11 00:00:00 |  |  | 6 |  |  |  |  |  |  |  |  |  |  | 1
 | 1 |  |  | 197776 | 36575 | [NAME] | 1231 | 2009-06-11 00:00:00 | 6/11/2009 | 2009-06-11 00:00:00 |  |  | 1
 | 1 |  |  | 197906 | 36736 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  | 53 |  |  |  |  | 1
 | 1 |  |  | 198051 | 36938 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  | 7
 | 1 |  |  | 198055 | 36936 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  | 9
 | 1 |  |  | 198068 | 36864 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  |  |  |  |  |  | 1
 | 1 |  |  | 198070 | 36858 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  | 1
 | 1 |  |  | 198072 | 36852 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  |  |  |  |  |  | 3
 | 1 |  |  | 198074 | 36875 | [NAME] | 1231 | 2009-06-15 00:00:00 | 6/15/2009 | 2009-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 1 |  |  | 198092 | 37024 | [NAME] | 1231 | 2009-06-16 00:00:00 | 6/16/2009 | 2009-06-16 00:00:00 |  |  |  |  |  |  |  | 6 |  |  |  |  |  | 4
 | 1 |  |  | 198131 | 37007 | [NAME] | 1231 | 2009-06-16 00:00:00 | 6/16/2009 | 2009-06-16 00:00:00 |  |  |  |  |  |  |  | 1
 | 1 |  |  | 198150 | 36812 | [NAME] | 1231 | 2009-06-16 00:00:00 | 6/16/2009 | 2009-06-16 00:00:00 |  |  | 18 |  |  |  |  |  |  |  |  |  |  | 19
 | 1 |  |  | 198194 | 36470 | [NAME] | 1231 | 2009-06-16 00:00:00 | 6/16/2009 | 2009-06-16 00:00:00 |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 4
Spreadsheet: 673475d1587399543-formula-for-specific-days-in-a-date-range-by-month-daysinmonthovertime
Sheet: Sheet2

 |  |  |  |  |  |  | Year -> |  | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021
 |  |  | EDIT DATES IN YELLOW ONLY |  |  |  | Month Number -> |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  | Month Name -> |  | Oct | Oct | Oct | Oct | Oct | Oct | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Dec | Dec | Dec | Dec | Dec | Dec | Dec | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Feb | Feb | Feb | Feb | Feb | Feb | Feb
 |  |  | Start Date |  | End Date |  | Day Number -> |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Position |  | MM/DD/YYYY |  | MM/DD/YYYY |  | Day Abbr -> |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa
 | Job 1 |  | 2020-10-01 00:00:00 |  | 2020-10-31 00:00:00 |  | Days in Month ->
 | Job 2 |  | 2020-10-15 00:00:00 |  | 2020-10-31 00:00:00 |  | Days in Month ->
 | Job 3 |  | 2020-10-20 00:00:00 |  | 2020-12-15 00:00:00 |  | Days in Month ->
 | Job 4 |  | 2020-11-06 00:00:00 |  | 2021-02-07 00:00:00 |  | Days in Month ->
 | Job 5 |  | 2020-12-30 00:00:00 |  | 2021-05-20 00:00:00 |  | Days in Month ->
Spreadsheet: 095ed443-6f00-4a0e-b099-f4cf02a5ccb4
Sheet: Sheet1

Table KS14a National Statistics Socio-economic Classification - All People aged 16 to 74 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
* Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more information please visit our website: www.birmingham.gov.uk or the National Statistics Website:
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2005. Crown copyright material is reproduced with the permission
of the [NAME] of HMSO .
Spreadsheet: jeff_dasovich__14131__LoadResource2
Sheet: OffPeakMonthlyAvg

Month | [NAME]
Jan | 29197
Feb | 28874
Mar | 29893
Apr | 28426
May | 35437
Jun | 35431
Jul | 38087
Aug | 39246
Sep | 37628
Oct | 32596
Nov | 29621
Dec | 30813
Spreadsheet: 85419d1285519849-how-do-you-take-cell-data-from-18-different-worksheets-and-combine-them-in-another-sample-homework-list
Sheet: Teacher A

Teacher Name | Class | Period | Due Date | Student First Name | Student Last Name | Assignment
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | Kent | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | [NAME] | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | Wayne | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | Hal | Jordan | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | [NAME] | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | [NAME] | Chapter 1
Teacher A | Math 10 | 1 | 2010-09-08 00:00:00 | [NAME] | Prince | Chapter 1
Spreadsheet: 184a90d8-793b-4041-aa2b-c29a92df9b0c
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
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
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
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2011-06-01 00:00:00 | 492 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2011-06-01 00:00:00 | 456 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2011-06-01 00:00:00 | 456 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2011-06-01 00:00:00 | 492 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2011-06-01 00:00:00 | 456 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 824254d1680431726-how-to-show-n-a-for-multiple-if-conditions-book2
Sheet: Pivot-All

S e r i a l i s a t i o n  -  O p e n   D a t a   M a n a g e m e n t   S t a t i s t i c s
 |  |  |  |  |  |  |  | nRFT %
 |  |  |  |  |  |  |  | Month | Tasks Closed | nRFT Tasks | nRFT % |  |  | Win | Lose
 |  |  |  |  |  |  |  | Total
Spreadsheet: andy_zipper__769__summary
Sheet: Dynegy

Dynegy
 |  | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | 2001-10-22 00:00:00 | 2001-10-23 00:00:00
US Gas Daily     Nymex Lot-Volume        Nov01-Mar02     USD/MM-L |  |  |  |  |  |  | 6 | 9
US Gas Swap      Nymex                   Apr-Oct02       USD/MM |  | 14500 | 28000 | 30500 | 37000 | 39500 | 34500 | 51500
US Gas Swap      Nymex                   Dec01           USD/MM |  | 60000 | 70000 | 80000 | 107500 | 117500 | 120000 | 122500
US Gas Swap      Nymex                   Feb02           USD/MM |  | 50000 | 47500 | 52500 | 52500 | 32500 | 30000 | 67500
US Gas Swap      Nymex                   Jan-Dec02       USD/MM |  | 35000 | 25000 | 25000 | 25000 | 12500 | 13500 | 16000
US Gas Swap      Nymex                   Jan-Dec03       USD/MM |  | 7000 | 7000 | 6000 | 3000 | 3000 | 3000 | 8000
US Gas Swap      Nymex                   Jan02           USD/MM |  | 17500 | 17500 | 17500 | 27500 | 22500 | 22500 | 107500
US Gas Swap      Nymex                   Nov01           USD/MM |  | 312500 | 267500 | 187500 | 12500 | 47500 | 27500 | 60000
US Gas Swap      Nymex                   Nov01           USD/MM-L |  | -400 | -400 | -400 | -400 | -400 | -400 | -400
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM |  | 115000 | 107500 | 90000 | 67500 | 82500 | 77500 | 65000
US Gas Swap      Nymex Lot-Volume        Nov01           USD/MM-L |  |  |  | -10 | -15 | -18 | -18 | -18
US Gas Daily     Nymex Lot-Volume        Nov01-Mar02     USD/MM-L
US Gas Swap      Nymex                   Apr-Oct02       USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM
US Gas Swap      Nymex                   Feb02           USD/MM
US Gas Swap      Nymex                   Jan-Dec02       USD/MM
US Gas Swap      Nymex                   Jan-Dec03       USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM-L
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM
US Gas Swap      Nymex Lot-Volume        Nov01           USD/MM-L
US Gas Daily     Nymex Lot-Volume        Nov01-Mar02     USD/MM-L
US Gas Swap      Nymex                   Apr-Oct02       USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM
US Gas Swap      Nymex                   Feb02           USD/MM
US Gas Swap      Nymex                   Jan-Dec02       USD/MM
US Gas Swap      Nymex                   Jan-Dec03       USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM-L
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM
US Gas Swap      Nymex Lot-Volume        Nov01           USD/MM-L
Spreadsheet: 0fe969b2-18d7-405a-aa42-135728a9bfdf
Sheet: Sheet1

Demographic Composition - U.S. Population & Average Issue Readership 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Market/Release: Scarborough USA+ 2010 Release 1 Total (Feb 2009 - Mar 2010)
Base: Total Adults 18+
 | Total U.S. Adults | Average Issue -  Daily Newspaper | Average Issue - Sunday
Base Total
Target Pop | 232960964 | 95305254 | 108060592
Target % | 1 | 1 | 1
Index | 100 | 100 | 100
Men
Target Pop | 113056101 | 48060887 | 50823598
Target % | 0.485 | 0.504 | 0.47
Index | 100 | 104 | 97
Women
Target Pop | 119904863 | 47244367 | 57236994
Target % | 0.515 | 0.496 | 0.53
Index | 100 | 96 | 103
Adults 18 - 34
Target Pop | 69857082 | 18127761 | 21962532
Target % | 0.3 | 0.19 | 0.203
Index | 100 | 63 | 68
Adults 35 or older
Target Pop | 163103882 | 77177493 | 86098060
Target % | 0.7 | 0.81 | 0.797
Index | 100 | 116 | 114
[NAME] than $50K
Target Pop | 110537410 | 39459680 | 44599671
Target % | 0.474 | 0.414 | 0.413
Index | 100 | 87 | 87
HHI $50K - $99K
Target Pop | 74404143 | 32456220 | 37003301
Target % | 0.319 | 0.341 | 0.342
Index | 100 | 107 | 107
HHI $100K - $249K
Target Pop | 41745943 | 19896523 | 22833309
Target % | 0.179 | 0.209 | 0.211
Index | 100 | 117 | 118
HHI $250K +
Target Pop | 6273468 | 3492831 | 3624311
Target % | 0.027 | 0.037 | 0.034
Index | 100 | 136 | 125
High School graduate or less
Target Pop | 104161276 | 36653739 | 41393063
Target % | 0.447 | 0.385 | 0.383
Index | 100 | 86 | 86
Some college (1-3 years-not Grad or AA/Assoc)
Target Pop | 69017939 | 29431844 | 33796114
Target % | 0.296 | 0.309 | 0.313
Index | 100 | 104 | 106
College graduate (4 year college)
Target Pop | 33489636 | 15318517 | 17516277
Target % | 0.144 | 0.161 | 0.162
Index | 100 | 112 | 113
Some Post-Grad or More
Target Pop | 26292113 | 13901154 | 15355138
Target % | 0.113 | 0.146 | 0.142
Index | 100 | 129 | 126
Source: Scarborough Research, USA+, Release 1, 2010, 12 Months
Prepared by: Newspaper Association of America