tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764789d1643000304-use-different-cells-for-calculation-when-data-is-manually-entered-in-them-over-production-forecast-sample
Sheet: Sample 

Montly Production Target | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Actual Production EOM | 9 | 10 | 0 | 5 | 15 | 9
Outsourced Extra Production
[NAME]
Actual Open Orders EOM | 60 | 58 | 71 | 73 | 79 | 66
Over Production
Recurring Monthly Orders
Month | 2021-07-30 00:00:00
Beginning Month Open Orders | 60
Average Recurring Monthly Orders | 11
Spreadsheet: 135580d1326131113-how-to-make-summary-from-many-sheets-students
Sheet: Summary

Student No | Student Name | Math | English | Science
1 | Student1 | 54 | 42 | 51
2 | Student2 | 59 | 64 | 64
3 | Student3 | 46 | 53 | 31
4 | Student4 | 61 | 35 | 41
5 | Student5 | 57 | 50 | 52
6 | Student6 | 57 | 46 | 53
7 | Student7 | 41 | 52 | 49
8 | Student8 | 48 | 48 | 52
9 | Student9 | 49 | 49 | 53
10 | Student10 | 46 | 62 | 42
11 | Student11 | 38 | 36 | 51
12 | Student12 | 30 | 58 | 54
13 | Student13 | 42 | 55 | 60
14 | Student14 | 47 | 48 | 42
15 | Student15 | 49 | 46 | 55
16 | Student16 | 56 | 58 | 44
17 | Student17 | 50 | 52 | 59
18 | Student18 | 46 | 67 | 53
19 | Student19 | 59 | 56 | 48
20 | Student20 | 50 | 66 | 41
Average |  | 49 | 52 | 50
Spreadsheet: stacey_white__39205__UBS Curve Codes
Sheet: By Curve Code

Power East and West Primary Curves and Basis Mappings
Sorted by Curve Code |  |  |  | WEST
Curve Code | Curve Name | Dependency |  | Curve Code | Curve Name | Dependency
PWCN | Cinergy Futures | R4 |  | R7 | WSCC-S/PV
PWQJ | PJM Futures | R1E |  | B42 | CRAIG | R7
[NAME] | Nepool Financial | R1B |  | B2 | WEST WING | R7
R1 | [NAME] |  |  | B4 | MEAD | R7
R1A | PJM West | R1E |  | B6 | 4 CORNERS | R7
R1B | Nepool |  |  | R8 | WSCC-N/COB
R1C | NY Zone A |  |  | R9 | MID COLUMBIA
R1D | PJM Eastern Hub | R1E |  | B1 | BPA BUSBAR | R9
R1E | PJM Western Hub |  |  | B7 | MONTANA | R9
R1Z | NY Zone J | R1 |  | B8 | MC DELIVERED | R9
R3 | SOCO |  |  | B19 | PG SYSTEM | R9
R3B | TVA | R4 |  | B22 | NOB | R9
R4 | Cinergy |  |  | B27 | JOHN DAY | R9
F4 | Cinergy Financial | R4 |  | R10 | NP15
R4C | Comed | R4 |  | R11 | SP15
F4C | Comed Financial | R4 |  | R12 | ZP26
R5 | Entergy
F5 | Entergy Financial | R5
R6 | South Texas
R6A | North Texas | R6
R20 | Ontario
Spreadsheet: 880674d1728507523-data-range-grab-last-data-cell-and-2nd-to-last-excel-forum
Sheet: Date Range

START DATE | 2024-03-11 00:00:00 |  | PERIOD
END DATE | 2024-05-17 00:00:00 |  | VALUE 1
PERIOD | WEEKLY |  | VALUE 2
 |  |  | VALUE 3
 |  |  | VALUE 3/2
 |  |  | VALUE 3/1
DATA
VALUE 1 | 200 | 300 | 300 | 1000 | 1400 | 1600 | 1600 | 2400 | 1940 | 600 | 0 | 0
VALUE 2 | 200 | 500 | 800 | 1800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VALUE 3 | 113.4 | 340.2 | 680.4 | 1134 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VALUE 3-2
 |  | < This looks at the data in row 19 and returns the last value
 |  | < I would now like to return the "next to last" value e.g. -120. This works if the blanks values don’t have #N/A in them, however there is a reason I need to have #N/A in these cells, I cant remember the full reason, maybe something to do with graphs or other equations but I need #N/A populated if no data in them
 |  | -1
 |  | 1
Spreadsheet: 57077d1257258703-comparing-grades-text-to-give-a-numerical-score-points-award-system
Sheet: Sheet1

 | Subject 1 |  | Points workings |  |  | Subject Points | Subject 2 |  | Points workings |  |  | Subject 1 Points |  |  | Workings Explanation
Pupil | Predicted | Actual | Predicted points | Actual Points | Difference | Points Score | Predicted | Actual | Predicted points | Actual Points | Difference | Points Score | Total Points |  | Grade | Scores
Pupil 1 | A* | A |  |  |  |  | A* | A |  |  |  |  |  |  | A* | 8
Pupil 2 | A | B |  |  |  |  | A | B |  |  |  |  |  |  | A | 7
Pupil 3 | B | A |  |  |  |  | B | A |  |  |  |  |  |  | B | 6
Pupil 4 | C | A |  |  |  |  | C | A |  |  |  |  |  |  | C | 5
Pupil 5 |  | C |  |  |  |  | A | C |  |  |  |  |  |  | D | 4
Pupil 6 | E | C |  |  |  |  | E | C |  |  |  |  |  |  | E | 3
Pupil 7 | U | A |  |  |  |  | U | A |  |  |  |  |  |  | F | 2
Pupil 8 | B | B |  |  |  |  | B | B |  |  |  |  |  |  | U | 1
Pupil 9 | U | U |  |  |  |  |  |  |  |  |  |  |  |  | Blank or anything else | 0
Pupil 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Point Score | Points Awarded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 grades above | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 grades above | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 grades above | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 grades above | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 grades above | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 grade above | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grade the same | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | -5
Spreadsheet: 845047d1696602836-help-with-formula-to-look-up-values-help
Sheet: Sheet1

Check these numbers: | Result: |  | Range 1 | Range 2 | Return
 |  |  | 0 | 40 | 175
20 |  |  | 41 | 64 | 200
41 |  |  | 65 | 79 | 235
53 |  |  | 80 | 89 | 240
90 |  |  | 90 | 100 | 250
99
Spreadsheet: 803950d1667819879-formula-for-9-box-grid-9-box-grid-aligw
Sheet: Sheet1

EMPLOYEE ID | NAME | DEPARTMENT | POSITION | YEARS OF EXPERIENCE | JOB LEVEL | AGE | PERFORMANCE | POTENTIAL | 9 BOX CATEGORIZATION | AliGW | Potential
1 |  |  |  |  |  |  | 3 | 1 | [NAME] |  |  | 3 | Potential Gem | High potential | Star
2 |  |  |  |  |  |  | 3 | 3 | Star |  |  | 2 | Inconsistent player | Core Player | High performance
3 |  |  |  |  |  |  | 1 | 3 | Potential Gem |  |  | 1 | Risk | Average performer | [NAME]
4 |  |  |  |  |  |  | 1 | 2 | Inconsistent player |  |  |  | 1 | 2 | 3
5 |  |  |  |  |  |  | 3 | 2 | High performance |  | Perfromacne
6 |  |  |  |  |  |  | 2 | 2 | Core Player
7 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
8 |  |  |  |  |  |  | 2 | 3 | High potential
9 |  |  |  |  |  |  | 3 | 1 | [NAME]
10 |  |  |  |  |  |  | 2 | 1 | Average performer
11 |  |  |  |  |  |  | 2 | 2 | Core Player
12 |  |  |  |  |  |  | 2 | 3 | High potential
13 |  |  |  |  |  |  | 3 | 1 | [NAME]
14 |  |  |  |  |  |  | 2 | 1 | Average performer
15 |  |  |  |  |  |  | 1 | 3 | Potential Gem
16 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
17 |  |  |  |  |  |  | 2 | 3 | High potential
18 |  |  |  |  |  |  | 1 | 1 | Risk
19 |  |  |  |  |  |  | 2 | 1 | Average performer
20 |  |  |  |  |  |  | 1 | 3 | Potential Gem
Spreadsheet: 176997d1346161249-how-to-get-my-spreadsheet-to-change-accordingly-spreadsheet-model-2
Sheet: Sports Plan

Day One
Activity | Time (hours) | Cals per hour | Cals burnt off
Fast Walking | 0.5 | 150 | 75
Squash | 1 | 140 | 140
Day Two
Activity | Time (hours) | Cals per hour | Cals burnt off
Five a side Football | 1 | 150 | 150
Kayaking | 0.5 | 190 | 95
Day Three
Activity | Time (hours) | Cals per hour | Cals burnt off
Kickboxing | 0.5 | 190 | 95
Mountain Climbing | 0.25 | 190 | 47.5
Day Four
Activity | Time (hours) | Cals per hour | Cals burnt off
Rugby Men | 1.75 | 140 | 245
Ice Hockey | 0.25 | 200 | 50
Day Five
Activity | Time (hours) | Cals per hour | Cals burnt off
Windsurfing | 1 | 150 | 150
Water Skiing | 1 | 200 | 200
Day Six
Activity | Time (hours) | Cals per hour | Cals burnt off
Weight Training | 1.5 | 200 | 300
Street Dance | 0.5 | 140 | 70
Day Seven
Activity | Time (hours) | Cals per hour | Cals burnt off
Rock Climbing | 1.75 | 140 | 245
Five a side Football | 2 | 150 | 300
Total calories burnt during week |  |  | 2162.5
Spreadsheet: 867160d1714044622-calculating-a-percentage-based-on-rows-above-and-below-test1
Sheet: Sheet1

This row is calculated with =[NAME]) | Full number (can have letters) |  |  |  |  |  |  |  | 8 rows up and below | 20 rows up and below |  |  |  |  |  |  |  |  |  |  |  |  | Grade | Value
2853 | 102853 | B0 | 0 | 0 | B0 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B0 | 0
2854 | 202854 | B0 | 0 | 0 | B2 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 | 0.15
2855 | 302855 | B0 | 0 | 0 | B2 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 | 0.15
2856 | 402856 | B2 | 1 | 4 | B0 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3 | 0.4
2858 | 602858 | B0 | 0 | 0 | B1 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4 | 0.9
2862 | 302862 | B0 | 0 | 0 | B4 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B5 | 1.5
2865 | 602865 | B0 | 0 | 0 |  | 0 |  | 0
2866 | 702866 | B0 | 0 | 0 | B3 | 2 Years, 5m |  | 0
2871 | 502871 | B0 | 0 | 0 |  | 0 |  | 0
2874 | 102874 | B0 | 0 | 0 | B3 | 2 Years, 4m |  | 0
2876 | 302876 | B0 | 0 | 0 |  | 0 |  | 0
2877 | 402877 | B0 | 0 | 0 | B4 | 2 Years, 4m |  | 0
2879 | 602879 | B5 | 1 | 10 |  | 0 |  | R | one out of 16 (C21 is a B5) total count of 8 rows up and 8 below), 6.25% | 3 out of 30 (12 up, 18 bellow) 10%
2880 | 702880 | B0 | 0 | 0 | B4 | 2 Years, 4m |  | 0
2883 | 302883 | B0 | 0 | 0 | B0 | 2 Years, 3m |  | 0
2884 | 402884 | B0 | 0 | 0 |  | 0 |  | 0
2885 | 502885 | B0 | 0 | 0 |  | 0 |  | 0
2886 | 602886 | B0 | 0 | 0 |  | 0 |  | 0
2889 | 202889 | B0 | 0 | 0 | B5 | 2 Years, 3m |  | 0
2892 | 502892 | B5 | 1 | 9 |  | 0 |  | R | 2 out of 16 C14 and C29 (8 row up and 8 below), 12.5% | 3 out of 30 (11 up, 19 bellow) 10%
2893 | 602893 | B0 | 0 | 0 | B4 | 2 Years, 3m |  | 0
2895 | 102895 | B0 | 0 | 0 |  | 0 |  | 0
2896 | 202896 | B0 | 0 | 0 |  | 0 |  | 0
2897 | 302897 | B0 | 0 | 0 | B3 | 2 Years, 3m |  | 0
2898 | 402898 | B0 | 0 | 0 |  | 0 |  | 0
2902 | 102902 | B0 | 0 | 0 |  | 0 |  | 0
2903 | 202903 | B0 | 0 | 0 | B0 | 2 Years, 2m |  | 0
2904 | 302904 | B3 | 1 | 5 | B4 | 2 Years, 2m |  | 0
2907 | 602907 | B0 | 0 | 0 | B0 | 2 Years, 2m |  | 0
2908 | 702908 | B0 | 0 | 0 | B4 | 2 Years, 2m |  | 0
2911 | 302911 | B0 | 0 | 0 | B2 | 2 Years, 2m |  | 0
Spreadsheet: 820921d1678350869-need-a-formula-to-count-down-hours-worked-vs-next-pay-increase-on-excel-timesheet-test
Sheet: Apr 1-15

[NAME]
 |  | 330 | STS-Thomas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 8
 |  |  |  |  |  |  |  |  |  |  |  |  | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step |  | April 1 - 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  | 2023
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER |  | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 | JAB | Thur | 27 | 12
 | sns | Fri |  | 10 |  |  |  |  |  |  |  | 2
 | JAB | Sat |  | Off
 | JAB | Sat | 29 | Off
 | JAB | Sun | 30 | Off
 | JAB | Mon | 1 | Holiday |  |  |  |  |  | 6
 | JAB | Tue | 2 | Off |  |  |  |  |  |  | 14
 | JAB | Wed | 3 | 12
 | JAB | Thur | 4 | 12
 | JAB | Fri | 5 | 12
 | JAB | Sat | 6 | 4 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 6 | 6
 | DLE | Sun | 7 | Off
 | DLE | Mon | 8 | Off |  |  |  |  |  |  | 12
 | DLE | Tue | 9 | Off |  |  |  |  |  |  | 12
 |  | Tue
 |  | TOTALS
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER | DAILY TOTAL | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 |  |  | reg hours forward |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% | 3% | 9%
 |  |  | available leave
 |  |  | I certify that the foregoing payroll is just, true and correct; that the person whose name appears [NAME]
 |  |  | actually worked or was on authorized leave as shown; and that the salaries are due and unpaid.
 |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  | DATE |  |  |  |  | AUTHORIZING SIGNATURE |  |  |  |  |  | DATE
Spreadsheet: 525351d1498674148-list-to-matrix-ef1107_list_to_matrix
Sheet: Sheet1

Job Number | Employee | Occurances | Uniq_job | Uniq_Emp |  | Job Number | Employee 1 | 1-Count | Employee 2 | 2-Count | Employee 3 | 3-Count | Employee 4 | 4-Count | Employee 5 | 5-count
AA1 | [NAME] | 3 |  |  |  | 1 | [NAME] | 7 | [NAME] | 4 | [NAME] | 3
AA1 | [NAME] | 4 |  |  |  | 2 | [NAME] | 9 | [NAME] | 5 | [NAME] | 4 | [NAME] | 3
AA1 | [NAME] | 7 |  |  |  | 3 | [NAME] | 8 | [NAME] | 4 | [NAME] | 3 | [NAME] | 2 | [NAME] | 1
BB2 | [NAME] | 3 |  |  |  | 4 | [NAME] | 9 | [NAME] | 6 | [NAME] | 4 | [NAME] | 1
BB2 | [NAME] | 4 |  |  |  | 5 | [NAME] | 12 | [NAME] | 4 | [NAME] | 2
BB2 | [NAME] | 9
BB2 | [NAME] | 5
CC3 | [NAME] | 4 |  |  |  | Job_num
CC3 | [NAME] | 3
CC3 | [NAME] | 1
CC3 | [NAME] | 2
CC3 | [NAME] | 8
DD4 | [NAME] | 4
DD4 | [NAME] | 6
DD4 | [NAME] | 9
DD4 | [NAME] | 1
EE5 | [NAME] | 2
EE5 | [NAME] | 4
EE5 | [NAME] | 12
Spreadsheet: 07141166-52fd-45bd-9b1b-682853940a2d
Sheet: 4ED OUT OF 69

ANON# | RANK
10610 | 14
12496 | 15
12543 | 13
13096 | 2
14900 | 9
16198 | 4
17067 | 1
19825 | 6
24994 | 17
26266 | 12
40312 | 8
46780 | 10
60611 | 5
69814 | 7
89040 | 16
91839 | 3
93834 | 11
Spreadsheet: daren_farmer__5855__accrued0500
Sheet: Sheet2

Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  |  | Sum of Quantity
Period | Total | Period | Total | Period | Total | Period | Total | Period | Total |  | Period | Total
01-MAY-2000 | -39780 | 01-MAY-2000 | -20454 | 01-MAY-2000 | -78770 | 01-MAY-2000 | -79659 | 01-MAY-2000 | -90176 |  | 01-MAY-2000 | -90608
02-MAY-2000 | -59817 | 02-MAY-2000 | -60808 | 02-MAY-2000 | -56595 | 02-MAY-2000 | -56535 | 02-MAY-2000 | -54382 |  | 02-MAY-2000 | -63760
Grand Total | -99597 | 03-MAY-2000 | -5218 | 03-MAY-2000 | -3242 | 03-MAY-2000 | -3182 | 03-MAY-2000 | -14822 |  | 03-MAY-2000 | -18409
 |  | Grand Total | -86480 | 04-MAY-2000 | 14191 | 04-MAY-2000 | 18947 | 04-MAY-2000 | 5461 |  | 04-MAY-2000 | 14056
 |  |  |  | Grand Total | -124416 | 05-MAY-2000 | -42697 | 05-MAY-2000 | -59838 |  | 05-MAY-2000 | -47380
 |  |  |  |  |  | 06-MAY-2000 | -34026 | 06-MAY-2000 | -31950 |  | 06-MAY-2000 | -43153
 |  |  |  |  |  | 07-MAY-2000 | -110720 | 07-MAY-2000 | -94435 |  | 07-MAY-2000 | -98617
 |  |  |  |  |  | Grand Total | -307872 | 08-MAY-2000 | -52630 |  | 08-MAY-2000 | -57744
 |  |  |  |  |  |  |  | Grand Total | -392772 |  | 09-MAY-2000 | 40566
 |  |  |  |  |  |  |  |  |  |  | 10-MAY-2000 | -38294
 |  |  |  |  |  |  |  |  |  |  | 11-MAY-2000 | -13145
 |  |  |  |  |  |  |  |  |  |  | 12-MAY-2000 | 277
 |  |  |  |  |  |  |  |  |  |  | 13-MAY-2000 | -104076
 |  |  |  |  |  |  |  |  |  |  | 14-MAY-2000 | -51817
 |  |  |  |  |  |  |  |  |  |  | Grand Total | -572104
Spreadsheet: 197096d1354210140-added-condition-that-broke-rank-and-listing-feature-on-spreadsheet-timer-score-sheets
Sheet: Day 1 PRINTOUT

Day 1 Results
2013-01-01 00:00:00
The Great White Crazy Race
Day 1 Post | Bib | Musher's Name | Day 1 Finish Time
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
Spreadsheet: 148547d1333462482-trouble-with-index-and-match-formula-eample
Sheet: Sheet1

 |  | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00
 | [NAME] | A | A | A | A | A | A
 | [NAME] | L |  | A
 | [NAME] |  | L |  |  |  | A
 | [NAME] |  |  |  | A
 | [NAME] | A
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 |  | -67425
60667
60749 |  | 42992
61206
61334 | -25143
62960
INDEX
2001-07-31 00:00:00 |  |  | 727828
2001-08-05 00:00:00
CBS Volume
 |  |  | 88624
Spreadsheet: 110034d1306837236-how-to-sum-categeory-wise-copy-of-test_budget
Sheet: Summery

Sum of Amount | Month
Catageory | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | (blank) | Grand Total
HOME | 300 | 4800 | 4500 |  | 9600
TRANSPORTATION | 2000 | 1500 | 500 |  | 4000
(blank)
EDUCATION |  |  |  | 8000 | 8000
#N/A
Grand Total | 2300 | 6300 | 5000 | 8000 | 21600
Spreadsheet: 696266d1600730329-dynamic-table-creation-template_111-bluya-
Sheet: Waiting

 | Package Unique number |  | Written here | In Sending | In Sent | Old date
 | A33 |  | 2020-07-23 00:00:00
 | A34 |  | 2019-01-01 00:00:00
 | [NAME] |  | 2020-09-01 00:00:00
 | A36 |  | 2020-05-02 00:00:00
 | A37 |  | 2021-05-15 00:00:00
 | A38 |  | 2020-12-04 00:00:00
 | A39 |  | 2027-12-09 00:00:00
 | A40 |  | 2021-10-09 00:00:00
 | A41 |  | 2022-10-08 00:00:00
Spreadsheet: kate_symes__18875__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
Spreadsheet: 72411d1273088602-formula-for-multiple-if-statements-and-lookup-functions-sample
Sheet: _Options

Yes | Allegany | Yes | Yes | Yes | 50-50 split | 50-50 split
No | [NAME] | No | No | No | Buyer pays | Buyer pays
 | Baltimore City |  |  |  | [NAME] Pays | [NAME] pays
 | Baltimore County
 | [NAME]
 | Caroline
 | Carroll
 | Cecil
 | [NAME]
 | Dorchester
 | [NAME]
 | Garrett
 | Harford
 | [NAME]
 | Kent
 | Montgomery
 | [NAME]
 | [NAME]
 | St. Mary’s
 | Somerset
 | Talbot
 | Washington
 | Wicomico
 | Worcester
Spreadsheet: 871243d1717620776-largest-and-average-gap-in-rows-formula-largest-and-average-gap-in-rows-formula
Sheet: Sheet1

ROUND | RESULT | Fileter>=10 | Largest | Average
1 | 4.49
2 | 1 | 13.84
3 | 1.23 | 23.21
4 | 1.83 | 40.96
5 | 10.7 | 66.94
6 | 1.12 | 105.24
7 | 6.33 | 29.74
8 | 8.17
9 | 1.03
10 | 3.51
11 | 1.49
12 | 1.49
13 | 1.23
14 | 3.16
15 | 2.3
16 | 1.45
17 | 5.2
18 | 1.37
19 | 1.81
20 | 1.62
21 | 2.27
22 | 1.33
23 | 13.84
24 | 2.13
25 | 2.89
26 | 1.56
27 | 2.25
28 | 1.2
29 | 1.05
30 | 1.39
31 | 4.62
32 | 4.24
33 | 4.47
34 | 1.36
35 | 1.48
36 | 1.69
37 | 1.93
38 | 2.28
39 | 23.21
40 | 8.29
41 | 1.92
42 | 1.12
43 | 1.06
44 | 4.16
45 | 1.78
46 | 4.59
47 | 2.64
48 | 1.25
49 | 40.96
50 | 1.6
51 | 2.49
52 | 1.35
53 | 1.19
54 | 2.99
55 | 1.53
56 | 1.06
57 | 1.29
58 | 1.24
59 | 1.96
60 | 2.5
61 | 8.76
62 | 1.31
63 | 66.94
64 | 1.51
65 | 1.4
66 | 1.05
67 | 1.41
68 | 2.24
69 | 2.18
70 | 5.66
71 | 1.32
72 | 1
73 | 1.97
74 | 105.24
75 | 1.96
76 | 9
77 | 1.33
78 | 1.13
79 | 4.33
80 | 3.79
81 | 1.26
82 | 1.45
83 | 1.75
84 | 1.9
85 | 1.87
86 | 1.55
87 | 2
88 | 1.63
89 | 1.38
90 | 1.69
91 | 1.31
92 | 2.04
93 | 2.49
94 | 1.77
95 | 1.93
96 | 7.25
97 | 2.01
98 | 1.68
99 | 29.74
100 | 1.22
Spreadsheet: 114311d1310070097-formula-to-create-a-random-date-rand
Sheet: Sheet1 (2)

Number | Exam / Year / Question | Date
1 | July 2001 / 1
2 | July 2001 / 2
3 | July 2001 / 3
4 | July 2001 / 4
5 | July 2001 / 5
6 | July 2001 / 6
7 | Feb 2002 / 1
8 | Feb 2002 / 2
9 | Feb 2002 / 3
10 | Feb 2002 / 4
11 | Feb 2002 / 5
12 | Feb 2002 / 6
13 | July 2002 / 1
14 | July 2002 / 2
15 | July 2002 / 3
16 | July 2002 / 4
17 | July 2002 / 5
18 | July 2002 / 6
19 | July 2003 / 1
20 | July 2003 / 2
21 | July 2003 / 3
22 | July 2003 / 4
23 | July 2003 / 5
24 | July 2003 / 6
25 | Feb 2004 / 1
26 | Feb 2004 / 2
27 | Feb 2004 / 3
28 | Feb 2004 / 4
29 | Feb 2004 / 5
30 | Feb 2004 / 6
31 | July 2004 / 1
32 | July 2004 / 2
33 | July 2004 / 3
34 | July 2004 / 4
35 | July 2004 / 5
36 | July 2004 / 6
37 | Feb 2005 / 1
38 | Feb 2005 / 2
39 | Feb 2005 / 3
40 | Feb 2005 / 4
41 | Feb 2005 / 5
42 | Feb 2005 / 6
43 | July 2006 / 1
44 | July 2006 / 2
45 | July 2006 / 3
46 | July 2006 / 4
47 | July 2006 / 5
48 | July 2006 / 6
49 | Feb 2007 / 1
50 | Feb 2007 / 2
51 | Feb 2007 / 3
52 | Feb 2007 / 4
53 | Feb 2007 / 5
54 | Feb 2007 / 6
55 | July 2007 / 1
56 | July 2007 / 2
57 | July 2007 / 3
58 | July 2007 / 4
59 | July 2007 / 5
60 | July 2007 / 6
61 | Feb 2008 / 1
62 | Feb 2008 / 2
63 | Feb 2008 / 3
64 | Feb 2008 / 4
65 | Feb 2008 / 5
66 | Feb 2008 / 6
67 | July 2008 / 1
68 | July 2008 / 2
69 | July 2008 / 3
70 | July 2008 / 4
71 | July 2008 / 5
72 | July 2008 / 6
73 | Feb 2009 / 1
74 | Feb 2009 / 2
75 | Feb 2009 / 3
76 | Feb 2009 / 4
77 | Feb 2009 / 5
78 | Feb 2009 / 6
79 | July 2009 / 1
80 | July 2009 / 2
81 | July 2009 / 3
82 | July 2009 / 4
83 | July 2009 / 5
84 | July 2009 / 6
85 | Feb 2010 / 1
86 | Feb 2010 / 2
87 | Feb 2010 / 3
88 | Feb 2010 / 4
89 | Feb 2010 / 5
90 | Feb 2010 / 6
91 | July 2010 / 1
92 | July 2010 / 2
93 | July 2010 / 3
94 | July 2010 / 4
95 | July 2010 / 5
96 | July 2010 / 6
97 | Feb 2011 / 1
98 | Feb 2011 / 2
99 | Feb 2011 / 3
100 | Feb 2011 / 4
101 | Feb 2011 / 5
102 | Feb 2011 / 6
Spreadsheet: 221446d1363554847-sum-and-cell-formatting-with-runtime-reach-songlist
Sheet: Total

#reach
Song | [NAME] | Show | Performers
Joy | [NAME] | - | All | 2:40
There's a Land | [NAME] | Myths and Hymns | All | 3:26
Breathe | [NAME] | In The Heights | [NAME] | 4:02
Therapy | [NAME] | tick, tick…BOOM! | [NAME], Lucas | 2:54
Louder than Words | [NAME] | tick, tick…BOOM! | [NAME], Lucas, Spence | 4:45
A Contact High | [NAME] | It's Only Life | Lucas | 0:51
Hero and [NAME] | [NAME] | Myths and Hymns | Lucas | 3:17
Unexpressed | [NAME] | It's Only Life | Lucas | 3:18
If I Sing | [NAME] | Closer Than Ever | Spence | 4:29
Spreadsheet: 713660d1610869790-look-up-using-two-pieces-of-criteria-but-need-the-nearest-match-book1
Sheet: Sheet1

Group   From    To      Count
Group1 | 0 | 1 | 1.25 |  |  | Group1 | 1
Group1 | 1 | 2 | 2.5
Group1 | 2 | 3 | 3.75
Group1 | 3 | 4 | 5
Group1 | 4 | 5 | 6.25
Group1 | 5 | 6 | 7.5
Group1 | 6 | 7 | 8.75
Group1 | 7 | 8 | 10
Group1 | 8 | 9 | 11.25
Group1 | 9 | 10 | 12.5
Group1 | 10 | 11 | 13.75
Group1 | 12 | 119 | 15
Group1 | 120 | 215 | 20
Group1 | 216 | 299 | 25
Group1 | 300 | 9999 | 30
Spreadsheet: 818814d1677067272-hour-computation-hour-computation
Sheet: Sheet1

 | Start | 22:00:00 | 21:00:00 | 23:00:00 | 18:00:00 | 21:00:00 |  | 20:00:00
 | End | 06:00:00 | 07:00:00 | 05:00:00 | 04:00:00 |  | 06:00:00 | 02:00:00
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 159735d1338830234-lookup-in-split-ranges-as-in-one-20120604-copy-1-
Sheet: Sheet2

 |  |  | 686 |  | <<< code goes here
 |  |  |  |  | <<< sample formula (failed)
 |  |  |  |  |  |  | 1. Need to find top 5 largest values FOR A GIVEN CODE (D3), ignoring tototals column
 |  |  |  |  |  |  | Separate formula necessary for value, product, segment
 |  |  |  |  |  |  | 2. Ideally, need a "combined" formula that would return either of the 3 parameters. Combined meaning result would be returned within ONE formula
 | Top X | Value | Product | Segment
 | 1
 | 2
 | 3
 | 4
 | 5
 |  |  |  | formulas here