tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b4787c01-690e-445f-b9fe-bce82cb72e81
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: November 24, 2014 (3:12 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340055
2014 | 324502 | 330908 | X | X
Spreadsheet: 833078d1686764838-showing-a-cell-as-blank-with-a-prefilled-formula-until-data-is-entered-on-another-sheet-master-project-template-help
Sheet: Project Invoicing

 |  |  | 25% Invoice |  |  | 50% Invoice |  |  | 100% Invoice
Project | Project Manager | Contract Date | 25% Sent | 25% Due | 25% Received | 50% Sent | 50% Due | 50% Received | 100% Sent | 100% Due | 100% Received
 |  |  | 2023-06-12 00:00:00 |  |  | 2023-06-12 00:00:00 |  |  | 2023-06-12 00:00:00
Spreadsheet: 725601d1616762404-how-to-sum-multiple-rows-of-info-using-index-and-match-help
Sheet: Sheet1

 | Date | Who | Reason | Amount
 | 2020-08-24 00:00:00 | C | Stuff | 908.11
 | 2020-08-24 00:00:00 | A | Stuff | 908.11
 | 2020-08-24 00:00:00 | B | Stuff | 500 |  | Total In (A) | Total In (B) | Total In (C) | Total In (D)
 | 2020-08-24 00:00:00 | B | Stuff | 408.11
 | 2020-08-25 00:00:00 | Z | Stuff | -4345
 | 2020-09-09 00:00:00 | C | Things | 7.8
 | 2020-09-28 00:00:00 | A | Things | 8
 | 2020-09-28 00:00:00 | B | Things | 7.8
 | 2020-09-16 00:00:00 | Z | Things | -39
 | 2020-10-06 00:00:00 | C | Things | 22.46
 | 2020-10-06 00:00:00 | A | Things | 22.46
 | 2020-10-06 00:00:00 | B | Things | 22.46
 | 2020-10-07 00:00:00 | C | Stuff | 405.55
 | 2020-10-07 00:00:00 | A | Stuff | 405.55
 | 2020-10-07 00:00:00 | B | Stuff | 405.55
 | 2020-10-07 00:00:00 | Z | Stuff | -1825
 | 2020-10-12 00:00:00 | Z | Things | -112.34
 | 2020-10-26 00:00:00 | A | Stuff | 40
 | 2020-10-26 00:00:00 | B | Stuff | 39.83
 | 2020-10-26 00:00:00 | D | Stuff | 40
 | 2020-10-26 00:00:00 | C | Stuff | 39.83
 | 2020-10-26 00:00:00 | B | Things | 365
 | 2020-10-27 00:00:00 | Z | Stuff | -238.98
 | 2020-10-30 00:00:00 | C | Things | 273.75
 | 2020-11-03 00:00:00 | A | Things | 365
 | 2020-11-03 00:00:00 | D | Things | 274
 | 2020-11-04 00:00:00 | Z | Things | -1825
 | 2020-11-06 00:00:00 | B | Things | 18.17
 | 2020-11-06 00:00:00 | B | Stuff | 18.13
 | 2020-11-06 00:00:00 | A | Stuff | 18.17
 | 2020-11-06 00:00:00 | A | Stuff | 18.09
 | 2020-11-10 00:00:00 | D | Stuff | 18.4
 | 2020-11-10 00:00:00 | D | Things | 18.1
 | 2020-11-10 00:00:00 | C | Stuff | 18.17
 | 2020-11-10 00:00:00 | C | Things | 18.1
 | 2020-11-11 00:00:00 | Z | Things | -109
 | 2020-11-16 00:00:00 | A | Things | 63.64
 | 2020-11-16 00:00:00 | B | Things | 63.64
 | 2020-11-17 00:00:00 | Z | Things | -108.6
 | 2020-11-19 00:00:00 | D | Stuff | 63.64
 | 2020-11-25 00:00:00 | Z | Stuff | -39.75
 | 2020-11-30 00:00:00 | C | Stuff | 63.64
 | 2020-11-30 00:00:00 | C | Stuff | 6.63
 | 2020-11-30 00:00:00 | C | Things | 273.75
 | 2020-12-01 00:00:00 | D | Stuff | 6.62
 | 2020-12-01 00:00:00 | D | Things | 273.75
Spreadsheet: 479789d1473587200-auto-numbering-column-with-sort-m_to_do_list
Sheet: To-Do-List - zirkelbezug

To-Do List
Nr. | Detected on | Detected by | Topic | Status | Responsible | Due Date | Due in Days | Finished Date |  | [NAME]
 | 2016-09-02 00:00:00 | 1-M | Test | in Arbeit |  | 2016-09-08 00:00:00
 | 2016-09-02 00:00:00 | 2-KJS | Prüfe | in Arbeit |  | 2016-09-22 00:00:00
 | 2016-09-02 00:00:00 | 3-LKU | Telefon | in Arbeit |  | 2016-09-06 00:00:00
 | 2016-09-02 00:00:00 | 4-UWP | Auto | Offen |  | 2016-09-12 00:00:00
Spreadsheet: 4a42a911-be0d-4d38-84eb-5d0c3024fe7c
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688874124 | Everfound | Never Beyond Repair | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Spreadsheet: 145176d1331341213-look-up-formulas-bedford-division-example-1-
Sheet: Low Bidder

Division 4 - Masonry
Low Bidder
Activity | Quantity | Unit | Labor Cost | Material Cost | Sub-Contract | Total Cost
Sub Total
Override
Activity | Quantity | Unit | Labor Cost | Material Cost | Sub-Contract | Total Cost
Sub Total
Spreadsheet: john_griffith__16060__EOL_Search
Sheet: EOL_SEARCH

 | PJM W Jul01
 | Product | ID | Bid | Offer | Mid | Bid Vol | [NAME] | Status |  | I | Inactive | A | Active | S | Suspended
 | US [NAME] Index PJM-W MWD Peak          Jul01           USD/MWh | 36481 |  |  | N/A |  |  | I
 | US Pwr Phy Firm  PJM-W Peak              Jul01           USD/MWh | 36484 | 79.25 | 81.75 | 80.5 | 50 | 50 | I
 | US Pwr Fin Swap  PJM DemPk 10/MW         02-06Jul01      USD/MW | 38517 |  |  | N/A |  |  | I
 | US Pwr Fin Swap  PJM DemPk 10/MW         09-13Jul01      USD/MW | 38519 |  |  | N/A |  |  | I
 | US Pwr Fin Swap  PJM W IntC Peak         Jul01           USD/MWh | 40717 |  |  | N/A |  |  | I
 | US Pwr Fin Swap  PJM-W MWD Peak          Jul01           USD/MWh | 40737 |  |  | N/A |  |  | I
 | US Pwr Phy Firm  PJM-W 7x24              Jul01           USD/MWh | 40981 |  |  | N/A |  |  | I
 | US Pwr Fin Swap  PJM DemPk 10/MW         02-06Jul01      USD/MW | 41489 | 36850 | 38200 | 37525 | 1 | 1 | I
 | US Pwr Fin Swap  PJM DemPk 10/MW         09-13Jul01      USD/MW | 41491 | 40200 | 41400 | 40800 | 1 | 1 | I
Spreadsheet: 594492d1539794253-duplicating-the-data-in-excel-based-on-certain-criteria-excel-forum-sample-data-17-10-2018
Sheet: After

www.example-1.com | 1
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-1.com
www.example-2.com | 1
www.example-2.com
www.example-2.com
www.example-2.com
www.example-2.com
Spreadsheet: 221561d1363613445-array-formula-cell-problems-bbng610
Sheet: Sheet1

Date | Name | Fruit | Remarks
2010-07-01 00:00:00 | bbng | apple | good
2012-07-01 00:00:00 | bbng | orange | bad
2013-07-01 00:00:00 | bbng | apple | so-so
2014-07-01 00:00:00 | bbng | grape | very good
Spreadsheet: 75985d1276585759-sumproduct-to-count-by-week-book13
Sheet: Sheet1

 |  |  |  | WEEK OF THE YEAR
DATE COMPLETED | WEEK NUMBER |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
2010-01-04 00:00:00 | 1 |  | NUMBER OF JOB DONE BY WEEK | 3 | 2 | 0 | 1 | 3 | 1 | 3 | 0 | 0 | 1
2010-01-05 00:00:00 | 1
2010-03-07 00:00:00 | 10
2010-02-01 00:00:00 | 5
2010-02-15 00:00:00 | 7
2010-02-15 00:00:00 | 7
2010-02-02 00:00:00 | 5
2010-02-07 00:00:00 | 6
2010-02-16 00:00:00 | 7
2010-01-05 00:00:00 | 1
2010-01-11 00:00:00 | 2
2010-01-12 00:00:00 | 2
2010-01-28 00:00:00 | 4
2010-02-17 00:00:00 | 7
2010-02-06 00:00:00 | 5
Spreadsheet: 120550d1315368214-comparing-data-in-2-tabs-data-comparison-1-
Sheet: Sheet2

Contract # | TYPE | AMOUNT
 | 32768 | 600
BD00003051 | 32768 | 1360
BD00002489 | 32768 | 140
BD00001929 | 49152 | 480
BD00000079 | 65536 | 1350
BD00002138 | 65536 | 300
BD00002289 | 49152 | 70
BD00000962 | 65536 | 210
BD00001929 | 32768 | 840
BD00002138 | 81920 | 300
BD00001958 | 32768 | 1200
BD00002138 | 49152 | 70
BD00002288 | 49152 | 70
BD00002288 | 65536 | 280
BD00002289 | 65536 | 280
BD00002487 | 32768 | 280
BD00000079 | 98304 | 864
BD00002887 | 49152 | 0
BD00001960 | 49152 | 840
BD00002025 | 32768 | 480
BD00000866 | 32768 | 420
BD00002489 | 65536 | 280
BD00002768 | 32768 | 150
BD00002768 | 49152 | 900
BD00002637 | 32768 | 320
BD00001960 | 32768 | 150
BD00000079 | 81920 | 0
BD00002489 | 49152 | 70
BD00002887 | 32768 | 1500
BD00003027 | 32768 | 960
BD00003027 | 49152 | 540
BD00002887 | 65536 | 960
BD00000851 | 65536 | 0
BD00000851 | 81920 | 2800
BD00000851 | 32768 | 4080
BD00000962 | 49152 | 420
BD00001230 | 180224 | 798
BD00000851 | 49152 | 3000
BD00001096 | 32768 | 1920
BD00001126 | 32768 | 420
BD00001126 | 49152 | 210
BD00001230 | 65536 | 1710
BD00001047 | 32768 | 1920
BD00001230 | 114688 | 0
BD00001230 | 131072 | 1368
BD00001230 | 147456 | 1140
BD00001230 | 163840 | 665
BD00001230 | 98304 | 399
BD00001278 | 32768 | 420
BD00001230 | 81920 | 798
Spreadsheet: 878625d1725801060-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration
Sheet: Sheet1 (4)

Calculate earliest start date and time based on deadline date and time and duration
[NAME]
Deadline Date/Time | Duration (hrs) | Start Date/Time | Computed Duration (hrs) | Check |  | Operational Days/Hours
 |  |  |  |  |  | Mon | Fri | Total Hrs
Workings for 1st item:
Deadline Date/Time |  | Random | With Deadline Date/Time in cell A5, Duration (hrs) in cell B5,
Hours in Deadline Date/Time |  |  | Start Date/Time in cell C5:
Remaining hours
No. of full working days
Remaining hours
Estimated Start Date
Computed Start Date/Time
Combined formula
[NAME] for 1st item:
Date
2024-01-01 00:00:00
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q4FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended March 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 1090 |  | 0 |  | -95 |  | 0 |  | 0 |  | 0 |  | 995
Cost of revenue | 328 |  | -3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 325
Gross profit | 762 |  | 3 |  | -95 |  | 0 |  | 0 |  | 0 |  | 670
Operating expenses:
Marketing and sales | 194 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 189
General and administrative | 75 |  | 0 |  | 0 |  | 0 |  | -8 |  | 0 |  | 67
Research and development | 328 |  | 0 |  | 0 |  | 0 |  | -25 |  | 0 |  | 303
Acquisition-related contingent consideration | 8 |  | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 13 |  | -13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | -1 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
Total operating expenses | 617 |  | -21 |  | 0 |  | 1 |  | -38 |  | 0 |  | 559
Operating income | 145 |  | 24 |  | -95 |  | -1 |  | 38 |  | 0 |  | 111
Interest and other income (expense), net | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4
Income before provision for (benefit from) income taxes | 149 |  | 24 |  | -95 |  | -1 |  | 38 |  | 0 |  | 115
Provision for (benefit from) income taxes | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 34 |  | 32
Net income | 151 |  | 24 |  | -95 |  | -1 |  | 38 |  | -34 |  | 83
Earnings per share |  |  |  |  |  |  |  |  | Earnings per share
Basic | 0.45 |  |  |  |  |  |  |  | Basic |  |  |  | 0.25
Diluted | 0.45 |  |  |  |  |  |  |  | Diluted |  |  |  | 0.25
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 333 |  |  |  |  |  |  |  | Basic |  |  |  | 333
Diluted | 336 |  |  |  |  |  |  |  | Diluted |  |  |  | 336
Spreadsheet: 773783d1648046060-if-between-numbers-test
Sheet: Sheet3

 | Name | daily rate | amount
 | a | 400
 | b | 600
 | c | 1200 |  |  |  |  |  |  | daily rate | amount to pay
 | d | 2500 |  |  |  |  |  |  | >=400 | Minim in LE-3500
 |  |  |  |  |  |  |  |  | Over 400>=600 | Minim in LE-4000
 |  |  |  |  |  |  |  |  | Over 600>=950 | Minim in LE-5000
 |  |  |  |  |  |  |  |  | = & over 1000 | Minim in LE-6000
 |  |  |  |  |  |  |  |  | Over 2000 | Maxim in LE-13000
Spreadsheet: 82720d1282748800-indexing-a-row-from-another-worksheet-within-workbook-dummybook
Sheet: Sheet1

* Here is a row used to index the year and life cycle of our acquisitions:
300 | 400 | 500 | 0 | 0 | 0 |  | Year = | 2009
Below is an example of what is needed:
*Assuming on separate worksheet:
2008 | 2009 | 2010 | 2011 | 2012 | 2013
0 | 300 | 400 | 500 | 0 | 0
OR depending on Year |  |  |  |  |  |  | Year = | 2011
2008 | 2009 | 2010 | 2011 | 2012 | 2013
0 | 0 | 0 | 300 | 400 | 500
Spreadsheet: 161861d1339663011-showing-cells-that-is-related-to-a-cell-multiple-result-formula-that-shows-each-store-when-clicked-data-validation
Sheet: Sheet1

Storename | Handled by this salesperson
MURAH | [NAME]
Cross | Ian
Soulmate | [NAME]
Generalized | [NAME]
Welcomm | [NAME]
The Alphabet | Wally
1 for 2 | [NAME]
Salesperson List
[NAME]
Ian
[NAME]
Wally
[NAME]
Spreadsheet: 674025d1587638127-issue-with-excel-solver-for-optimizing-smoothning-constant-in-winthers-forecasting-model-forecasting-case-thomas
Sheet: Regression BP

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.9553387404517267
R Square | 0.9126721090078918
Adjusted R Square | 0.9064344025084555
Standard Error | 346.0621927704611
Observations | 16
ANOVA
 | df | SS | MS | F | [NAME]
Regression | 1 | 17522584.10588235 | 17522584.10588235 | 146.3153338635551 | 8.442605020796971e-09
Residual | 14 | 1676626.577711397 | 119759.0412650998
Total | 15 | 19199210.68359375
 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95,0% | Upper 95,0%
Intercept | 2591.674080882353 | 215.2174955054744 | 12.04211616158515 | 8.94189217988136e-09 | 2130.078461515202 | 3053.269700249505 | 2130.078461515202 | 3053.269700249505
X Variable 1 | 227.0176470588235 | 18.76785747785605 | 12.09608754364629 | 8.442605020797003e-09 | 186.7645961795793 | 267.2706979380678 | 186.7645961795793 | 267.2706979380678
Spreadsheet: 271288d1381892678-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: WE 12th Jan

Date | Order # | Company | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
10.01.14 | 102498 | Bearing Centre | 2x B94 belts | (to suit [NAME] T810 pump) | 1x T5-380 (20[NAME] wide) timing belt
 |  | Area: | Stock |  | BSF
 |  | Req'd By: | Daryl |  | [NAME]
 |  | Code: | 21A |  | 30V
 |  | Item Cost: | 28.9 |  | 53.5
 |  | Request No. | 102498 |  | 102499
10.01.14 | 104978 | Southern Steel | 2m - 50mm round bar
 |  | Area: | CAPITAL: Job #02
 |  | Req'd By: | [NAME]
 |  | Code: | 14H
 |  | Item Cost: | 180
 |  | Request No. | 104978
10.01.14 | 106798 | Norgen | 2x air cyliners per sample
 |  | Area: | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1C
 |  | Item Cost: | 1200.9
 |  | Request No. | 106798
10.01.14
10.01.14
Spreadsheet: 036f14bc-efe6-4803-9087-a583de239dc8
Sheet: Sheet1

WISTCA EVENT CHAIR'S
Event Chair -- Sprints - Girls |  |  | [NAME] |  |  | Whitewater
Event Chair -- Sprints - Boys |  |  | [NAME] |  |  | Arrowhead
Event Chair --Horizontal Jumps |  |  | [NAME] |  |  | [NAME]
Event Chair --High Jump |  |  | [NAME] |  |  | Portage
Event Chair --Pole Vault |  |  | [NAME] |  |  | Mukwonago
Event Chair --Throws |  |  | [NAME] |  |  | Homestead
Event Chair --Hurdles |  |  | [NAME] |  |  | Black River Falls
Event Chair --Distances |  |  | [NAME] |  |  | Arrowhead
Spreadsheet: 174553d1345109104-input-sheet-output-form-can-i-do-it-weeklydata
Sheet: Form

SL | Name | Amount | Cash/Cheque
1 |  |  |  |  |  | Name |  | Amount |  | Cash/Cheque
2
3
4
5
6
7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet Name | Week1
9
10
11 |  |  |  |  |  |  |  |  |  |  |  |  | 5
12
13
14
15
16
17
18
19
20
21 |  |  |  |  |  |  |  |  | Signature
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 161906d1339671836-formula-help-increasing-values-to-reach-target-figure-including-capping-phased-modelling-example
Sheet: Sheet1

 |  |  |  |  | Variable | 15
 |  |  |  |  | Variable for formula | 115
 |  | Current | Year 1 | Year 2 | Year 3 | Target
 |  | 21630 | 21885 |  |  | 21885
 |  | 28000 | 28000 |  |  | 21885
 |  | 9750 | 11212.5 |  |  | 21885
 |  | 16527.5 | 19006.625 |  |  | 21885
 |  | 12460.35 | 14329.4025 |  |  | 21885
 |  | 11326.44 | 13025.406 |  |  | 21885
 |  | 25108.5 | 25108.5 |  |  | 21885
 |  | 27524.04 | 27524.04 |  |  | 21885
 |  | 26336 | 30286.4 |  |  | 41041.5
 |  | 14217.45 | 16350.0675 |  |  | 21885
 |  | 20949.94 | 21885 |  |  | 21885
 | Total | 213830.22 | 228612.941 | 475000 | 501000 | 259891.5
 | Target | 213830 | 225572 | 237500 | 250500 | 259891.5
 | Overage | 0.220000000030268 | 3040.940999999992 | 237500 | 250500 | 0
Spreadsheet: 930ff558-016a-47af-9983-c56fe3bca012
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258996 | 12413 | Clive | [NAME] | GBR |  | 00:17:03 | 00:00:45 | [NAME] | [NAME] | 00:09:45 | 1 | 01:00:23
258996 | 57000 | Roland | Jochem | GER |  | 00:21:12 | 00:01:00 | 00:34:58 | 00:00:49 | 00:12:08 | 2 | 01:10:05
258996 | 20785 | [NAME] | Smallwood | GBR |  | 00:22:06 | 00:01:17 | [NAME] | 00:00:59 | 00:12:29 | 3 | 01:12:07
258996 | 13372 | Hans | Frößler | GER |  | 00:21:46 | 00:00:55 | [NAME] | 00:00:44 | 00:12:05 | 4 | 01:12:53
258996 | 7682 | [NAME] | Nesseler | GER |  | 00:24:09 | 00:01:37 | [NAME] | 00:01:23 | 00:13:15 | 5 | 01:21:27
258996 | 82075 | Christian | Galtier | FRA |  | 00:25:47 | 00:01:53 | 00:41:52 | [NAME] | 00:15:10 | 6 | 01:26:22
Spreadsheet: 92125d1291782619-match-and-countif-match-and-countif-help
Sheet: W12

Player1 | X | X | X |  | X | X | X | 6
Player2 |  | X | X | X |  |  |  | 3
Player3 | X |  | X |  | X |  | X | 4
Player4 | X | X |  |  | X | X | X | 5
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb10-Feb16m

Main Arena
 | 2013-02-10 00:00:00 |  |  | Thru | 2013-02-16 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 64705d1265510237-time-sheet-calculations-time-sheets-100
Sheet: incidental

id | Total Incidental | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | Dates are fixed as the entire year…. |  |  |  | 2010-12-31 00:00:00
 |  | 6 | 1 | 2
ID's are fixed all employees are listed
Spreadsheet: 758928d1639156858-need-help-around-correct-formulae-nested-if-or-index-for-attached-query-excel-test
Sheet: Q5

 | Qestion 5
 | Score |  | FACILITY NAME | Usage (kWh)
 | 1. Create a pie chart that illustrates the Percent of Total Usage for each facility. |  | Operations Building | 545880
 | 2. Insert a legend that keys each wedge of the chart to the names of the facilities. |  | District 1 Station | 563793
 | 3. Format the chart so that a percentage value is displayed for each wedge of the chart. |  | District 2 Station | 107639
 | 4.Title the Chart "Percent of Electricity Use By Facility". |  | Materials Lab | 180000
 |  |  | [NAME] | 182980
 |  |  | District 3 Station | 12447
 |  |  | Construction Office | 133696
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 27686 | 27476
2 | 27971 | 27476
3 | 81478 | 81305
4 | 92416 | 92044
5 | 104180 | 107044
6 | 85005 | 84253
7 | 102170 | 103816
8 | 101849 | 97816
9 | 101901 | 101981
10 | 80229 | 79575
11 | 91609 | 91496
12 | 91776 | 91496
13 | 98890 | 98105
14 | 95006 | 95675
15 | 98127 | 90791
16 | 95603 | 94316
17 | 67072 | 66798
18 | 100738 | 99995
19 | 55492 | 54364
20 | 93233 | 93294
21 | 96401 | 95424
22 | 89787 | 94660
23 | 100699 | 99994
24 | 110724 | 108866
25 | 114730 | 114272
26 | 112198 | 111512
27 | 115788 | 115496
28 | 105783 | 112100
29
30
31
2001-06-30 00:00:00 |  |  | 48879.09
2001-07-28 00:00:00
Spreadsheet: 813509d1673828620-take-function-take-example
Sheet: Sheet1

 |  | review period (months) | -6
 |  | Jan | 5
 |  | Feb | 10
 |  | Mar | 15
 |  | Apr | 20
 |  | May | 25
 |  | Jun | 30
 |  | Jul | 35
 |  | Aug | 40
 |  | Sep | 45
 |  | Oct | 50
 |  | Nov | 55
 |  | Dec | 60
Average
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60
Average
Spreadsheet: 185863d1349864995-how-to-use-conditional-vlookup-0a1_fot_excel_query
Sheet: Required Data

Name | [NAME] | Status
A | 3 | Fail
B | 2 | Pass
C | 4 | Fail
D | 5 | Pass W/E
Name | [NAME] | Status
A
B
C
D
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 119

Ranking | First Name | Last Name | School | Section | Grade
1 | Nahshon | Garrett | Chico | NS | 12 | reno 1
2 | [NAME] | Knoblauch | Clovis West | CS | 12 | reno 2
3 | Martin | [NAME] | [NAME] | SJ | 11
4 | [NAME] | Miranda | Poway | SD | 11 | reno 8
5 | Justin | Jauregui | Clovis East | CS | 12
6 | Tyler | Adams | Tesoro | SS | 12
7 | [NAME] | [NAME] | De La Salle | NC | 11 | reno 7
8 | [NAME] | [NAME] | El Camino Real | LA | 10
9 | Silverio | Esparza | Lemoore | CS | 10 | reno t12
10 | Javier | Gasca | Central | CS | 10 | zink 1
11 | [NAME] | Greybill | Ponderosa | SJ | 12
12 | [NAME] | Gaytan | Clovis | CS | 10 | zink 2
13 | [NAME] | Polonco | [NAME] | CC | 11
14 | Tyler | [NAME] | Nevada Union | SJ | 12
15 | Grant | Burkhalter | [NAME] | SJ | 12
16 | [NAME] | Palacios | Calvary Chapel | SS | 11
Spreadsheet: 680981d1591284909-functions-to-link-data-over-multiple-sheets-excel-forum-example
Sheet: Stocklist

March
 |  |  |  |  |  | List of Month
Data A | Data B | Data C | Data D | Data E |  | January
Data 1 |  |  |  |  |  | February
Data 2 |  |  |  |  |  | March
Data 3
Data 4
Data 5
Data 6
Data 7
Data 8
Data 9
Data 10
Spreadsheet: 819726d1677668062-how-to-vertically-stack-two-range-vertically-stack-two-range
Sheet: Sheet1

Data1 | Data2 |  | Data1 | Data2
A | 1 |  | P | 20
B | 2 | - | Q | 21
C | 3 | - | R | 22
D | 4 | - | S | 23
E | 5 | - | T | 24
F | 6 |  | U | 25
0 |  |  |  | 0
0 |  |  |  | 0
0 |  |  |  | 0
My requirement is as follow :
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
P | 20
Q | 21
R | 22
S | 23
T | 24
U | 25