tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217209d1362001971-trouble-with-average-book2
Sheet: Sheet1

AVG | PLAYER | Mar. 4 | Dec.12 | 2012-11-01 00:00:00 | 2012-10-12 00:00:00 | 2012-08-01 00:00:00 | 2012-07-01 00:00:00 | 2012-06-01 00:00:00 | 2012-05-01 00:00:00 | 2012-04-01 00:00:00 | 2012-03-01 00:00:00 | 2011-12-11 00:00:00 | 2011-11-11 00:00:00 | 2011-10-11 00:00:00 | 2011-09-11 00:00:00 | 2011-08-11 00:00:00 | 2011-07-11 00:00:00 | 2011-06-11 00:00:00 | 2011-05-11 00:00:00 | 2011-04-11 00:00:00 | 2011-03-11 00:00:00 | 2011-12-10 00:00:00 | 2011-11-10 00:00:00 | 2011-10-10 00:00:00 | 2011-09-10 00:00:00 | 2011-08-10 00:00:00 | 2011-07-10 00:00:00 | 2011-06-10 00:00:00 | 2011-05-10 00:00:00 | 2011-04-10 00:00:00 | 2011-03-10 00:00:00 | 2011-12-09 00:00:00 | 2011-11-09 00:00:00 | 2011-10-09 00:00:00
 | BOB SMITH |  | DNP | 11 | 13 | 11 | DNP | DNP | DNP | 9 | 8 | DNP | 10 | 8 | DNP | 10 | 8 | 11 | DNP | DNP | 5 | DNP | 8 | DNP | 10 | DNP | 5 | 6 | DNP | 9 | 4 | DNP | DNP | DNP | 4
 | [NAME] |  | DNP | 17 | DNP | 18 | 12 | DNP | DNP | 12 | 8 | DNP | 11 | 19 | 16 | 10 | 15 | 14 | DNP | DNP | 12 | DNP | 17 | DNP | 20 | 12 | 15 |  |  |  |  | 10 | 4
 | MARK SMITH |  | 30 | 37 | 36 | 36 | 34 | DNP | DNP | 29 | 24 | 30 | 29 | 31 | 27 | 34 | 35 | 30 | 26 | 29 | 28 | DNP | 31 | 26 | 27 | 29 | 31 | 28 | 27 | 27 | 23 | DNP | 23 | DNP | 24 | 23 | 25
Spreadsheet: 848238d1698999412-formula-to-determine-if-a-text-ar-to-be-added-sample2-6-aligw
Sheet: Sheet1

 |  |  | S/No | Date | CAR Number | Expected Result | [NAME] | Changes using Table 2 |  | S/No | Imp Date | CAR Number1 |  | Imp Date | CAR Number1 | CAR Number2
 |  |  | 1 | 2023-12-12 00:00:00 | 7 | 07 AR |  |  |  | 1 | 2023-11-03 00:00:00 | 9 |  | 2023-11-03 00:00:00 | 9 | T9
 |  |  | 2 | 2023-10-02 00:00:00 | T7 | 07 |  |  |  | 2 | 2023-11-03 00:00:00 | T9 |  | 2023-11-03 00:00:00 | 7 | T7
 |  |  | 3 | 2023-10-15 00:00:00 | 7 | 07 |  |  |  | 3 | 2023-11-03 00:00:00 | 7 |  | 2023-12-12 00:00:00 | 10 | T10
 |  |  | 4 | 2023-11-03 00:00:00 | 7 | 07 AR |  |  |  | 4 | 2023-11-03 00:00:00 | T7 |  | 2023-12-10 00:00:00 | 23 | T23
 |  |  | 5 | 2023-11-03 00:00:00 | T7 | 07 AR |  |  |  | 5 | 2023-12-12 00:00:00 | 10
 |  |  | 6 | 2023-10-07 00:00:00 | 9 | 09 |  |  |  | 6 | 2023-12-12 00:00:00 | T10
 |  |  | 7 | 2023-10-04 00:00:00 | T9 | 09 |  |  |  | 7 | 2023-12-10 00:00:00 | 23
 |  |  | 8 | 2023-11-05 00:00:00 | T10 | 10 |  |  |  | 8 | 2023-12-10 00:00:00 | T23
 |  |  | 9 | 2023-12-01 00:00:00 | T7 | 07 AR
 |  |  | 10 | 2023-12-12 00:00:00 | 9 | 09 AR
 |  |  | 11 | 2023-11-03 00:00:00 | 23 | 23
 |  |  | 12 | 2024-01-01 00:00:00 | 23 | 23 AR
 |  |  | 13 | 2023-12-13 00:00:00 | 10 | 10 AR
 |  |  | 14 | 2023-12-14 00:00:00 | T10 | 10 AR
 |  |  | 15 | 2023-11-03 00:00:00 | T10 | 10
 |  |  | 16 | 2023-12-04 00:00:00 | 5 | 05
Spreadsheet: 766106d1643751161-essentially-best-of-5-sample-excel
Sheet: Sheet1

Date | [NAME]
2022-01-01 00:00:00 | Apples
2022-01-02 00:00:00 | Bananas
2022-01-03 00:00:00 | Apples |  | Fruit expected for 1/20/22
2022-01-04 00:00:00 | Apples
2022-01-05 00:00:00
2022-01-06 00:00:00 | Grapes
2022-01-07 00:00:00 | Bananas
2022-01-08 00:00:00 | Apples
2022-01-09 00:00:00 | Grapes
2022-01-10 00:00:00 | Apples
2022-01-11 00:00:00 | Apples
2022-01-12 00:00:00 | Bananas
2022-01-13 00:00:00 | Bananas
2022-01-14 00:00:00 | Bananas
2022-01-15 00:00:00 | Apples
2022-01-16 00:00:00 | Grapes
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00 | Apples
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: 81553d1281694235-pivot-boxes-disappear-from-drop-down-once-deselected-741391
Sheet: Sheet2

Region | Jan | Feb | Mar | Apr | May | Jun |  | Region | Value | Month
North | 99 | 34 | 7 | 88 | 93 | 83 |  | North | 99 | Jan
South | 36 | 59 | 3 | 82 | 4 | 35 |  | South | 36 | Jan
East | 9 | 70 | 38 | 76 | 86 | 65 |  | East | 9 | Jan
West | 92 | 32 | 49 | 92 | 18 | 7 |  | West | 92 | Jan
 |  |  |  |  |  |  |  | North | 34 | Feb
 |  |  |  |  |  |  |  | South | 59 | Feb
 |  |  |  |  |  |  |  | East | 70 | Feb
 |  |  |  |  |  |  |  | West | 32 | Feb
 |  |  |  |  |  |  |  | North | 7 | Mar
 |  |  |  |  |  |  |  | South | 3 | Mar
 |  |  |  |  |  |  |  | East | 38 | Mar
 |  |  |  |  |  |  |  | West | 49 | Mar
 |  |  |  |  |  |  |  | North | 88 | Apr
 |  |  |  |  |  |  |  | South | 82 | Apr
 |  |  |  |  |  |  |  | East | 76 | Apr
 |  |  |  |  |  |  |  | West | 92 | Apr
 |  |  |  |  |  |  |  | North | 93 | May
 |  |  |  |  |  |  |  | South | 4 | May
 |  |  |  |  |  |  |  | East | 86 | May
 |  |  |  |  |  |  |  | West | 18 | May
 |  |  |  |  |  |  |  | North | 83 | Jun
 |  |  |  |  |  |  |  | South | 35 | Jun
 |  |  |  |  |  |  |  | East | 65 | Jun
 |  |  |  |  |  |  |  | West | 7 | Jun
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2001 | -2139
2 | -79 | -2139
3 | -553 | -2453
4 | -1052 | -2453
5 | -1743 | -2453
6 | -1725 | -2453
7 | -1957 | -2139
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -394456
2001-08-07 00:00:00
CBS Volume
 |  |  | -67276
Spreadsheet: 197018d1354190949-emailing-an-attached-spreadsheet-car-log-12
Sheet: Graphs

 |  |  |  |  |  | CAR CHARTS - Updated to: |  |  |  | 2012-11-29 00:00:00
Month | Rsd | Cost
Jan | 4 | 30
Feb | 8 | 105
Mar | 5 | 255.12
Apr | 17 | 163.1
May | 21 | 886
Jun | 15 | 310.5
Jul | 13 | 237.5
Aug | 17 | 235
Sep | 19 | 612
Oct | 12 | 1269
Nov | 0 | 193.5
Dec | 145 | 0
 | Rsd | Closed | Still Open
AC | 19 | 19 | 0
AWP | 30 | 27 | 3
MB | 55 | 55 | 0
PW | 12 | 12 | 0
TT | 27 | 27 | 0
 | Closed | Open
<7 days | 110 | 0
7-28 days | 27 | 0
29-56 days | 2 | 0
57+ | 1 | 3
Category | Count Cat | Closed | Still Open
Def | 53 | 52 | 1
Shp | 25 | 25 | 0
[NAME] | 37 | 35 | 2
Cust | 20 | 20 | 0
Doc | 1 | 1 | 0
Other | 8 | 8 | 0
Spreadsheet: 763030d1641950779-creating-and-populating-a-fair-rota-use-power-query-to-produce-a-rota-spoonbillsquarepants-
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Cover for week
2022-02-14 00:00:00 | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 |  |  | Available Staff | Availability
 |  |  |  |  |  |  |  |  | Person 1 | Available Mon-Fri
 | Person 7 | Person 8 | Person 9 | Person 10 | Person 11 | Person 12 |  |  | Person 2 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 3 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 4 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 5 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 6 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 7 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 8 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 9 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 10 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 11 | Available Mon-Fri
 |  |  |  |  |  |  |  |  | Person 12 | Available Mon-Fri (alternating Mon/Fri off weekly, [NAME] 18/2 off, Mon 21/2 off and so on)
 |  |  |  |  |  |  |  |  | Parameters
 |  |  |  |  |  |  |  |  | 12 people in pool, all but 1 is available 5 days a week, every week.
 |  |  |  |  |  |  |  |  | 1 person of the 12 alternates Monday or Friday off (4 day week).
 |  |  |  |  | Bank Hol |  |  |  | 1 person per shift.
 |  |  |  |  |  |  |  |  | 1 shift per day, Monday – Friday, 5 days a week.
 | Bank Hol |  |  |  |  |  |  |  | Each person should have an equal & even distribution of shifts as far as possible, e.g. each person works 5 Tuesdays throughout the year but not in a row.
 |  |  |  |  |  |  |  |  | Also 1 person per week should be absence cover for that week, also evenly distributed through the year. That person should not be on the rota in the weeks they are absence cover.
 |  |  |  |  |  |  |  |  | Bank hol = no shift required
 | Bank Hol
 |  | Bank Hol | Bank Hol
 | Bank Hol
 | Bank Hol | Bank Hol
 | Bank Hol
Spreadsheet: 134474d1325321517-vlookup-samplevlookup
Sheet: Sheet1

Goddard, Carol | 502
[NAME] | 503
Iannelli, Denni | 504 |  | Mathamel, Marti | 258 | #N/A
Fargnoli, [NAME] | 505 |  | Planche, Patric | 882.34 | #N/A
Martini, Joy & | 506 |  | [NAME], [NAME] | 277.2 | #N/A
Batal | 507 |  | Feigelman, [NAME] | 28 | #N/A
[NAME], [NAME] | 508 |  | Lenehan, [NAME] | 153.11 | #N/A
[NAME], [NAME] | 509 |  | [NAME], [NAME] | 625.72 | #N/A
[NAME] | 510 |  | Harris, Gail & | 608.08 | #N/A
Riley | 511 |  | [NAME], [NAME] | 350 | #N/A
[NAME] | 512 |  | [NAME], [NAME] | 63.12 | #N/A
[NAME] | 513 |  | Polumbo, [NAME] | 114.45 | #N/A
Mathamel, [NAME] | 514 |  | Spence, Elizabe | 2425.28 | #N/A
McCollum | 515 |  | O'Donoghue, Hub | 350 | #N/A
Temkin, [NAME] | 516 |  | Scott, Eileen | 165.64 | #N/A
Benson | 517 |  | Goldinger, [NAME] | 705.31 | #N/A
Planche, Patric | 518 |  | Kahhale, [NAME] | 140 | #N/A
Wilder | 519 |  | [NAME], [NAME] | 467.6 | #N/A
[NAME], [NAME] | 520 |  | Banko-Phillips, | 350 | #N/A
Pasquariello | 521
Feigelman, [NAME] | 522
Swierzewski | 523
Swierzewski | 524
Benson | 525
Stearns | 526
McIntosh | 527
Lenehan, [NAME] | 528
Bell | 529
Giglio | 530
[NAME], [NAME] | 531
Harris, Gail & | 532
[NAME], [NAME] | 533
[NAME], [NAME] | 534
Rahaman | 535
Ed & Lucy Phillips | 536
[NAME] | 537
Van Dissel | 538
Polumbo, [NAME] | 539
[NAME] | 540
Pelletier | 541
Chesterton | 542
Steenbarger | 543
Spence, Elizabe | 544
O'Donoghue, Hub | 545
Watts | 546
Hecker | 547
Nueis-Eisen | 548
Scott, Eileen | 550
Goldinger, [NAME] | 551
Kahhale, [NAME] | 552
[NAME], [NAME] | 553
Spreadsheet: 547668d1510672220-using-excel-to-match-data-sample-excel-sheet
Sheet: Student Responses

[NAME] | Q1 Chemistry of Life | [NAME], Acids, and Bases | [NAME] | Q4 Ecology | Q5 Scientific Method
 |  |  | x
 |  |  |  |  | x
 | x |  | x
 | x |  |  |  | x
 |  |  | x
 | x
 |  |  | x |  | x
 |  |  | x |  | x
 |  |  | x
 |  | x |  |  | x
 |  |  | x |  | x
 |  | x |  |  | x
 | x |  | x | x
 |  |  | x
 |  |  | x
Spreadsheet: 479904d1473658656-calculating-hours-to-money-does-not-work-in-the-weekend-example
Sheet: Mei

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 |  |  | 07:00:00 |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24:00 / 7:00 |  |  | 7:00 / 19:00 |  |  | 19:00 / 24:00
 | 1 |  |  |  | 2016-09-29 00:00:00 |  | 06:00:00 |  | 07:00:00 |  | 34.00000000000001 |  |  |  | 01:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
 | 2 |  |  |  | 2016-10-01 00:00:00 |  | 06:00:00 |  | 07:00:00 |  | 0 |  |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
 | 3 |  |  |  | 2016-10-03 00:00:00 |  | 06:00:00 |  | 20:00:00 |  | 68.00000000000007 |  |  |  | 01:00:00 |  |  | 13:00:00 |  |  | 01:00:00
0
Spreadsheet: 98272d1297256184-column-to-row-test
Sheet: Sheet1 (2)

Intake Date | Firstname | Residence | Module | module 1
2010-01-01 00:00:00 | Augusta | UAE | Business Simulation - Part 1 | OpM
2010-01-01 00:00:00 | Augusta | UAE | Business Simulation - Part 1 | MIBS
2010-07-01 00:00:00 | Ramya | Kuwait | Business Simulation - Part 1 | OpM
2010-07-01 00:00:00 | Ramya | Kuwait | Business Simulation - Part 1 | PD
2010-07-01 00:00:00 | Ramya | Kuwait | Business Simulation - Part 1 | MIBS
2010-07-01 00:00:00 | katherine | Yemen | Business Simulation - Part 1 | PD
2010-07-01 00:00:00 | katherine | Yemen | Business Simulation - Part 1 | [NAME]
2010-07-01 00:00:00 | katherine | Yemen | Business Simulation - Part 1 | MIBS
2010-07-01 00:00:00 | katherine | Yemen | Business Simulation - Part 1 | SM
2010-07-01 00:00:00 | Pinky | UAE | Business Simulation - Part 1 | PD
2010-07-01 00:00:00 | Pinky | UAE | Business Simulation - Part 1 | MIBS
2010-07-01 00:00:00 | Pinky | UAE | Business Simulation - Part 1 | CF
2010-07-01 00:00:00 | Nour | UAE | Business Simulation - Part 1 | PD
2010-07-01 00:00:00 | Nour | UAE | Business Simulation - Part 1 | MIBS
2010-07-01 00:00:00 | Nour | UAE | Business Simulation - Part 1 | CF
Spreadsheet: 687292d1595082684-random-number-selection-with-blanks-forum-example-generator-additional-scenario
Sheet: One from list

 | Factor to test |  | 1 |  |  | Current example of test generator
 | Ariana Passed
 |  | 1 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 2
 |  | 3
 |  | 5
 |  | 6 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 9
 |  | 10
 |  |  |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x
 |  | 12
 | Test generator using random generator of tables passed (C23:C34) and random generator between 0 and 12
 | Ariana Passed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowed Values |  | Ariana Passed |  | Ashton Passed |  | Generate for
 |  | 1 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x |  |  |  |  |  | 1 |  | 1 |  | Ariana
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Ashton | y
 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  | Would it be possible to have the allowed values created based off the generate for selection above?  If AD24="y" then the allowed values us generated using x24:x:35, if AD24 is blank then use z24:z35 to generate the allowed values.
 |  | 6 |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x |  |  |  |  |  | 6
 |  | 8
 |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x |  |  |  |  |  |  |  | 11
 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: 756084d1637266144-count-based-by-a-list-of-conditions-and-skip-empty-cells-count_restarrt_skip
Sheet: Sheet1

conditions list |  |  | data cells |  | expected results
cond1 |  | cond5 | [NAME] |  | 1
[NAME] |  |  | data2 |  | 2
cond3 |  | cond3 | data3 |  | 1
cond4 |  |  | data4 |  | 2
cond5 |  |  | data5 |  | 3
 |  | cond1 | [NAME] |  | 1
 |  |  | data7 |  | 2
 |  |  | data8 |  | 3
 |  |  | data9 |  | 4
 |  | cond5 | data10 |  | 1
 |  |  | data11 |  | 2
 |  |  | data12 |  | 3
 |  | [NAME] | data 13 |  | 1
 |  |  | data14 |  | 2
 |  |  | data15 |  | 3
 |  |  | data16 |  | 4
 |  |  | data17 |  | 5
 |  |  | data18 |  | 6
Spreadsheet: f6821f6d-92a4-42e4-b86c-c20be2453541
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: [NAME] for all available years | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
Indicator | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007
Chlorophyll a | 71 | 59.69 | 48.77 | 53.62 | 55.03 | 53.84 | 51.12 | 62.5 | 66.36 | 76.98 | 51.34 | 20.81 | 66.67 | 37.14 | 57.72 | 54.35 | 55.32 | 49.76 | 62.26 | 48.4 | 53.33 | 47.44
Aquatic Grasses | 1.31 | 0.28 | ND | 0.36 | 0.26 | 0.26 | 0.33 | 0.38 | 0.57 | 1.45 | 1.77 | 7.22 | 28.28 | 6.52 | 26.92 | 23.27 | 21.44 | 24.44 | 19.75 | 22.39 | 34.73 | 39.95
[NAME] | 98.73 | 98.03 | 99.27 | 92.8 | 97.82 | 87.27 | 95.24 | 99.96 | 97.78 | 94.44 | 95.32 | 96.57 | 100 | 99.89 | 100 | 100 | 99.67 | 84.7 | 93.84 | 96.57 | 97.87 | 93.38
[NAME] | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 60 | 48 | 36 | 43.48 | 66.67 | 40.91 | 50 | 34.78 | 59.09 | 56.52 | 45.83 | 33.33
Water Clarity | 19.8 | 10.59 | 9.97 | 7.47 | 12.16 | 11.27 | 11.95 | 15.48 | 9.75 | 18.83 | 10.9 | 14.82 | 13.05 | 12.25 | 11.98 | 9.89 | 14.87 | 3.11 | 10.19 | 3.18 | 3.48 | 11.73
Phytoplankton Index | 30.88 | 30.82 | 8.53 | 29.78 | 2.32 | 20.73 | 19.12 | 34.38 | 8.52 | 8.91 | 17.05 | 38.63 | 28.35 | 25.5 | 23.38 | 14.88 | 17.04 | 54.26 | 34.38 | 29.44 | 33.03 | 36.18
Water Quality Index | 59 | 56.1 | 52.67 | 51.3 | 55 | 50.79 | 52.77 | 59.31 | 57.96 | 63.42 | 52.52 | 44.07 | 59.91 | 49.76 | 56.57 | 54.75 | 56.62 | 45.86 | 55.43 | 49.38 | 51.56 | 50.85
Biotic Index | 16.09 | 15.55 | Insufficient Data | 15.07 | 1.29 | 10.49 | 9.72 | 17.38 | 4.55 | 5.18 | 26.27 | 31.28 | 30.88 | 25.16 | 38.99 | 26.35 | 29.49 | 37.83 | 37.74 | 36.12 | 38 | 36.49
Bay Health Index | 31.82 | 35.83 | Insufficient Data | 33.18 | 28.15 | 30.64 | 31.25 | 38.35 | 31.25 | 34.3 | 39.4 | 37.68 | 45.39 | 37.46 | 47.78 | 40.55 | 43.06 | 41.84 | 46.59 | 42.75 | 45 | 43.67
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 30

1845
Name | Amount
Name 1 | 158
Name 3 | 191
Name 1 | 151
Name 2 | 135
Name 1 | 146
Name 2 | 187
Name 2 | 182
Name 1 | 187
Name 1 | 153
Name 1 | 128
Name 3 | 164
Name 1 | 111
Name 2 | 113
Name 1 | 179
Name 3 | 174
Name 1 | 197
Name 1 | 165
Name 2 | 166
Name 1 | 140
Name 2 | 135
Name 2 | 193
Name 2 | 119
Name 3 | 192
Name 1 | 130
Name 2 | 125
Spreadsheet: 782093d1653771151-taking-data-from-user-defined-source-data-search
Sheet: Sheet1

 | Database MP |  |  |  |  | Database BL
 | Point | coordinate | MP01 |  |  | Point | coordinate | BL01 |  |  |  | Point | coordinate | MP01 | BL01
 | 1 | X | 1572 |  |  | 1 | X | 1572.6 |  |  |  | 1 | X
 |  | Y | 3158 |  |  |  | Y | 3155.6 |  |  |  |  | Y
 |  | Z | 4845 |  |  |  | Z | 4841.5 |  |  |  |  | Z
 | 2 | X | -1572 |  |  | 2 | X | -1573.1 |  |  |  | 2 | X
 |  | Y | 3148 |  |  |  | Y | 3156.2 |  |  |  |  | Y
 |  | Z | 4846 |  |  |  | Z | 4934.2 |  |  |  |  | Z
 | 3 | X | 899 |  |  | 3 | X | 899.7 |  |  |  | 3 | X
 |  | Y | 3444 |  |  |  | Y | 3444.9 |  |  |  |  | Y
 |  | Z | -1250 |  |  |  | Z | -1215 |  |  |  |  | Z
 | 4 | X | -899 |  |  | 4 | X | -899.7 |  |  |  | 4 | X
 |  | Y | 3442 |  |  |  | Y | 3445.1 |  |  |  |  | Y
 |  | Z | -1249 |  |  |  | Z | -1214.3 |  |  |  |  | Z
 | Point | coordinate | MP02 |  |  | Point | coordinate | BL02
 | 1 | X | 1573 |  |  | 1 | X | 1572.4
 |  | Y | 3152 |  |  |  | Y | 3156.1
 |  | Z | 4845 |  |  |  | Z | 4941
 | 2 | X | -1573 |  |  | 2 | X | -1572.6
 |  | Y | 3146 |  |  |  | Y | 3153.4
 |  | Z | 4844 |  |  |  | Z | 4938.7
 | 3 | X | 899 |  |  | 3 | X | 899.8
 |  | Y | 3441 |  |  |  | Y | 3444.9
 |  | Z | -1247 |  |  |  | Z | -1212.8
 | 4 | X | -899 |  |  | 4 | X | -899.8
 |  | Y | 3440 |  |  |  | Y | 3445.1
 |  | Z | -1248 |  |  |  | Z | -1214.2
Spreadsheet: ade605c5-5999-43bd-acb6-a5c8b7aa5c13
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Summary of State & Local Taxes
 |  | Table 1 - Latest National Totals of State and Local Tax Revenue: U.S. Total
 |  | Not Seasonally Adjusted Total Taxes [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: October 31, 2014 (9:02 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
1992 | 135822 | 144154 | 130322 | 158733
1993 | 144699 | 150412 | 139186 | 159318
1994 | 154049 | 151821 | 142333 | 167533
1995 | 157896 | 161701 | 149534 | 178442
1996 | 170544 | 175449 | 161924 | 188453
1997 | 180444 | 186031 | 170327 | 197603
1998 | 190315 | 202369 | 174161 | 207206
1999 | 196889 | 208627 | 183337 | 223852
2000 | 215048 | 230440 | 192487 | 237412
2001 | 222853 | 235918 | 195374 | 240101
2002 | 221818 | 230568 | 200908 | 250397
2003 | 227915 | 229583 | 218266 | 268473
2004 | 245894 | 253143 | 230688 | 295676
2005 | 268565 | 289080 | 251878 | 320314
2006 | 289134 | 316468 | 263937 | 340479
2007 | 305855 | 336925 | 273650 | 358394
2008 | 311635 | 351774 | 285686 | 370456
2009 | 305960 | 314608 | 271984 | 372468
2010 | 306065 | 321866 | 283595 | 377885
2011
2012
Spreadsheet: 223259d1-a836-4945-95b3-531ac2e85ba9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
7172 | 5790 | [NAME] | [NAME] | GBR | 4 | 00:07:39 | 00:00:25 | [NAME] | 00:00:46 | 00:08:53 | 1 | 00:30:20
7172 | 5959 | Ran | Alterman | ISR | 5 | 00:07:40 | [NAME] | 00:13:16 | 00:00:43 | 00:08:37 | 2 | 00:30:41
7172 | 5836 | Leandro | [NAME] | BRA | 2 | 00:08:13 | 00:00:33 | 00:13:18 | 00:00:54 | 00:09:54 | 3 | 00:32:51
7172 | 11016 | Martin | Papista | CRO | 3 | 00:08:52 | 00:00:31 | 00:14:54 | 00:01:00 | 00:10:37 | 4 | 00:35:51
Spreadsheet: 162066d1339705256-quantity-and-cost-calculations-with-varying-unit-sizes-and-price-points-against-required-test-sheet
Sheet: Sheet1

 | Ingredient bulk prices
 | Ingredients | Qty Per Bucket | Qty per box | Ingr. Per Run (oz) | Boxes Per run | Buckets per run | Cost Per Box | Cost Per Bkt | unit price | Unit [NAME] (lb) | Cost / oz | qty | Ext wt oz | Req. Lbs | Actual Lbs | Total cost | unit size ratio
 | ingr 1 | 2.6 |  |  |  |  |  |  | 0.83 | 1 |  |  |  |  |  |  |  | bucket
 | ingr 2 | 1.6 |  |  |  |  |  |  | 2.99 | 1 |  |  |  |  |  |  | 10.5 | bucket
 | ingr 3 | 1.3 |  |  |  |  |  |  | 3.56 | 1 |  |  |  |  |  |  |  | divisor for ratio
 | ingr 4 | 1.2 |  |  |  |  |  |  | 4.04 | 1 |  |  |  |  |  |  |  | of box:bucket
 | ingr 5 | 0.6 |  |  |  |  |  |  | 4.37 | 1
 | ingr 6 | 0.6 |  |  |  |  |  |  | 2.61 | 1
 | ingr 7 | 0.3 |  |  |  |  |  |  | 3.18 | 1
 | ingr 8 | 24 |  |  |  |  |  |  | 22.64 | 25
 | ingr 9 | 16 |  |  |  |  |  |  | 40.4 | 25
 |  |  |  |  |  | 18
 | Boxes | Prd Cost | SRP | WHP 39 | 40-60 | 60-100 | 100+ | Bucket |  | Prd Cost | SRP | WHP 5 | 6-10 | 11-50 | 51+
 | ingredient cost |  |  |  |  |  |  | ingredient cost
 | packaging | 0.1 |  |  |  |  |  | packaging |  | 0.35
 | production | 0.15 |  |  |  |  |  | production |  | 0.25
 | Unit Cost |  |  |  |  |  |  | Unit Cost
 | retail price |  | 3.99 |  |  |  |  | retail price
 | profit/box |  |  |  |  |  |  | profit/bkt
 | profit/run |  |  |  |  |  |  | profit/run
 | Boxes per run |  |  | 39 | 60 | 100 | 200 | Buckets per run |  |  |  | 5 | 10 | 50 | 100
 | Qty/unit sliding scale
 | ingredient | [NAME] | cost | [NAME] | cost | [NAME] | cost | [NAME] | cost | [NAME] | cost
 | ingr 1 | 3 | 2.25 | 24 | 10.75 | 160 | 25 | 320 | 42.5 | 400 | 65.27
 | ingr 2
 | ingr 3
 | ingr 4
 | ingr 5
 | ingr 6
 | ingr 7
 | ingr 8
 | ingr 9
Spreadsheet: 116226d1311691449-index-match-duplicates-poker-league-standings
Sheet: Standings

 | Name | Points
Formula in question ==> | [NAME] | 150
 | [NAME] | 150
 | Rich | 140
 | Geno | 95
 | Kenny | 95
 | [NAME] | 90
 | Brett | 60
 | Kris | 40
 | [NAME] | 35
Spreadsheet: john_arnold__15207__Homer
Sheet: Weekly-Apr-Sep

 |  |  | Apr-Sep
 |  |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000
 |  | 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
Spreadsheet: 82821d1282833948-indexing-a-row-from-another-worksheet-within-workbook-dummybook
Sheet: Needed

 | *If Year = 2009
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Total
Units: | 0 | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | *If Year = 2011
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Total
Units: | 0 | 0 | 0 | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | *If Year = 2008
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Total
Units: | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 547307d1510485536-mortgage-paydown-projection-table-mortgage-paydown-projection-table-rental-valuation-breakdown-v2
Sheet: Schedule

Weekly pmt
Year | Int | Prin
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