tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 701052d1603482835-using-powerquery-to-import-data-from-a-website-to-an-excel-spreadsheet-powerquery-finviz-example
Sheet: Sheet2

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
https://finviz.com/quote.ashx?t= & indirect(A3) &ty=c&ta=0&p=m&b=1 |  |  | Index | S&P 500 | P/E | 20.32 | EPS (ttm) | 4.22 | Insider Own | 0.001 | Shs Outstand | 112.64M | Perf Week | 6.00%
PNW |  |  | Market [NAME] | 9.63B | Forward P/E | 17.10 | EPS next Y | 5.01 | Insider Trans | 0 | [NAME] | 112.30M | Perf Month | 20.87%
 |  |  | Income | 475.80M | PEG | 6.02 | EPS next Q | 2.72 | Inst Own | 0.875 | Short Float | 1.83% | Perf Quarter | 5.35%
Note:  Place Code in A3 and then click on Refresh All |  |  | Sales | 3.45B | P/S | 2.79 | EPS this Y | -18.00% | Inst Trans | 0.0016 | Short Ratio | 2.29 | Perf Half Y | 11.14%
 |  |  | Book/sh | 48.74 | P/B | 1.76 | EPS next Y | 3.08% | ROA | 0.032 | Target Price | 85.08 | Perf Year | -8.94%
 |  |  | Cash/sh | 0.06 | P/C | 1415.68 | EPS next 5Y | 3.38% | ROE | 0.109 | 52W Range | 60.05 - 105.51 | Perf YTD | -4.67%
 |  |  | Dividend | 3.13 | P/FCF | - | EPS past 5Y | 0.50% | ROI | 0.05 | 52W High | -17.78% | Beta | 0.33
 |  |  | Dividend % | 3.65% | [NAME] | 0.50 | Sales past 5Y | -0.10% | Gross Margin |  | 52W Low | 44.46% | ATR | 1.91
 |  |  | Employees | 97 | Current Ratio | 0.80 | Sales Q/Q | 6.90% | Oper. Margin | 0.208 | RSI (14) | 77.74 | Volatility | 2.15% 2.48%
 |  |  | Optionable | Yes | Debt/Eq | 1.13 | EPS Q/Q | 34.00% | Profit Margin | 0.174 | Rel Volume | 0.86 | Prev Close | 85.73
 |  |  | Shortable | Yes | LT Debt/Eq | 1.08 | Earnings | [NAME] BMO | Payout | 0.579 | [NAME] | 900.09K | Price | 86.75
 |  |  | Recom | 2.70 | SMA20 | 8.66% | SMA50 | 14.22% | SMA200 | 0.075 | Volume | 716,826 | Change | 1.19%
Spreadsheet: 210313d1359435523-help-with-new-excel-system-need-guidance-or-information-frc
Sheet: SSS

Year | Month | Locations | Team | User Status | Week | Total Claims Audited | Errors | Overall Accuracy
2013 |  |  |  |  |  | 4582 | 122 | 0.9983915320820602
 | 1 |  |  |  |  | 4582 | 122 | 0.9983915320820602
 |  | Baltimore |  |  |  | 3186 | 57 | 0.9988355304457
 |  |  | Claim Operations | [NAME] | week 1 | 18 | 0 | 1
 |  |  | Claim Operations | Veteran | week 1 | 2954 | 51 | 0.998811
 |  |  | Forager | Veteran | week 1 | 45 | 3 | 0.999111
 |  |  | QA | [NAME] | week 1 | 64 | 0 | 1
 |  |  | QA | Veteran | week 1 | 105 | 3 | 0.998476
 |  |  |  |  | Month Total | 3186 | 57 | 0.9988355304457
 |  | India |  |  |  | 1349 | 64 | 0.9973610081541884
 |  |  | Claim Operations | [NAME] | week 1 | 122 | 5 | 0.99877
 |  |  | Claim Operations | Veteran | week 1 | 883 | 45 | 0.996896
 |  |  | Forager | Veteran | week 1 | 82 | 0 | 1
 |  |  | QA | [NAME] | week 1 | 38 | 2 | 0.996315
 |  |  | QA | Veteran | week 1 | 224 | 12 | 0.997633
 |  |  |  |  | Month Total | 1349 | 64 | 0.9973610081541884
 |  | San Antonio |  |  |  | 47 | 1 | 0.9978723404255319
 |  |  | Forager | [NAME] | week 1 | 5 | 0 | 1
 |  |  | Forager | Veteran | week 1 | 42 | 1 | 0.997619
 |  |  |  |  | Month Total | 47 | 1 | 0.9978723404255319
Spreadsheet: 13197445-c8b6-4f53-b47b-f32b6be3b67d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Broadmead Road Level Crossing Traffic Count Data |  |  |  |  |  |  | [NAME]
 | Eastbound
 |  | Pedestrians | Cars | Vans/ Small Lorries | Heavy Goods Vehicles | Buses | Tractors | Pedal Cycles/ Motor Cycles | Trains (Northbound)
 | Saturday 8th September | 4 | 770 | 89 | 19 | 16 | 2 | 10 | 20
 | Sunday 9th September | 7 | 748 | 61 | 9 | 10 | 3 | 16 | 12
 | Monday 10th September | 2 | 940 | 174 | 140 | 33 | 5 | 21 | 20
 | Tuesday 11th September | 0 | 917 | 179 | 137 | 41 | 2 | 14 | 22
 | Wednesday 12th September | 0 | 903 | 201 | 118 | 37 | 3 | 11 | 19
 | Thursday 13th September | 1 | 930 | 236 | 111 | 23 | 3 | 19 | 18
 | Friday 14th September | 2 | 937 | 210 | 112 | 29 | 2 | 19 | 22
 | Saturday 15th September | 9 | 779 | 102 | 31 | 15 | 2 | 13 | 26
 | Sunday 16th September | 1 | 700 | 47 | 9 | 12 | 1 | 19 | 0
 | Weekday Average | 1 | 925.4 | 200 | 123.6 | 32.6 | 3 | 16.8 | 20.2
 | Total Average | 2.888888888888889 | 847.1111111111111 | 144.3333333333333 | 76.22222222222223 | 24 | 2.555555555555555 | 15.77777777777778 | 17.66666666666667
 | Westbound
 |  | Pedestrians | Cars | Vans/ Small Lorries | Heavy Goods Vehicles | Buses | Tractors | Pedal Cycles/ Motor Cycles | Trains (Southbound)
 | Saturday 8th September | 4 | 669 | 81 | 21 | 17 | 2 | 11 | 20
 | Sunday 9th September | 6 | 642 | 45 | 9 | 10 | 4 | 18 | 13
 | Monday 10th September | 4 | 833 | 150 | 131 | 39 | 3 | 17 | 18
 | Tuesday 11th September | 1 | 841 | 159 | 124 | 37 | 1 | 18 | 20
 | Wednesday 12th September | 0 | 796 | 170 | 111 | 34 | 3 | 14 | 19
 | Thursday 13th September | 1 | 818 | 196 | 103 | 24 | 3 | 22 | 18
 | Friday 14th September | 2 | 832 | 166 | 108 | 31 | 2 | 14 | 22
 | Saturday 15th September | 8 | 716 | 84 | 33 | 16 | 2 | 16 | 27
 | Sunday 16th September | 2 | 705 | 54 | 7 | 12 | 1 | 18 | 0
 | Weekday Average | 1.6 | 824 | 168.2 | 115.4 | 33 | 2.4 | 17 | 19.4
 | Total Average | 3.111111111111111 | 761.3333333333334 | 122.7777777777778 | 71.88888888888889 | 24.44444444444444 | 2.333333333333333 | 16.44444444444444 | 17.44444444444444
Spreadsheet: 111108d1307573172-equalising-numbers-equalised-sets
Sheet: Sheet2

 | PRESS F9 TO RECALCULATE THE SETS |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Check | Check
Spreadsheet: 794627d1662151720-need-more-solutions-for-slow-calculations-solutions-for-faster-calculation
Sheet: Sheet1

 | Return to single specific value according to the specific items |  |  |  |  |  |  |  | Selection
 |  |  |  |  |  |  |  |  | apples | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | [NAME] | [NAME] | fruit4
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums |  |  |  | Solution 1
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes |  |  |  | ([NAME]: no need array formula CLRL+Shift+Enter)
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit |  |  |  | (Cons: take so long time in calculation if the data is big)
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-numbers
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas |  |  |  |  |  | Inv-numbers
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines |  |  |  |  |  | 3
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums |  |  |  |  |  | 5
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes |  |  |  |  |  | 7
 | 2015-05-10 00:00:00 | 10 | tomatoes | tomatoes | watermelons | tomatoes
Spreadsheet: 214912d1361186446-need-to-sum-multiple-values-based-on-match-test
Sheet: Project 1

 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24
Finance
[NAME]
[NAME]
[NAME]
[NAME]
HTML
Product Manager
Marketing
Total HC Man Months
Finance
[NAME]
[NAME]
[NAME]
[NAME]
HTML
Product Manager
Marketing
Total Cost
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19999 | -19885
2 | -20165 | -19885
3 | -20034 | -19885
4 | -19990 | -19952
5 | -20010 | -19952
6 | -19999 | -20000
7 | -20968 | -20000
8 | -20315 | -20000
9 | -20002 | -19153
10 | -19998 | -19490
11 | -20001 | -20000
12 | -19754 | -20000
13 | -19994 | -20000
14 | -20804 | -20000
15 | -20472 | -19589
16 | -19997 | -19794
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 176934
2001-12-16 00:00:00
CBS Dollars
 |  |  | 177562.79
Spreadsheet: 811637d1672718489-xlookup-display-next-non-zero-reading-columsn-from-top-down-xlookup-help-request
Sheet: Sheet1

10:30:00 | 109.5
10:31:00 |  | 109
10:32:00
10:33:00 |  | 109
10:34:00 |  | 109
10:35:00
10:36:00 | 108.5
10:37:00
10:38:00 |  | 109
10:39:00
10:40:00
10:41:00 | 109.5
10:42:00
10:43:00 |  | 109
10:44:00
10:45:00 |  | 109
10:46:00 |  | 109
10:47:00 |  | 109
10:48:00
10:49:00 | 108.5
10:50:00
10:51:00 |  | 109
10:52:00
10:53:00
10:54:00
10:55:00 | 109.5
10:56:00
10:57:00
10:58:00
10:59:00 |  | 109
11:00:00 |  | 109
11:01:00 | 108.5 | 109
11:02:00 |  | 109
11:03:00
11:04:00 | 109.5
11:05:00
Spreadsheet: 81756d1281929321-data-collation-find-out-the-values-in-a-column-updated-data-collation-find-out-the-values-in-a-column-updated-by-sunoffice
Sheet: Sheet1

 |  |  | Result (A) | Result (A) | If value of 'Result (A)' is repeated in the "Deal #' | Result (B) | Result (B) | If value of 'Result (B)' is repeated in the "Deal #'
Deal # | Package ID (A) | Package ID (B) | Available | Not Listed | Repetition Time | Available | Not Listed | Repetition Time
35454 | 36544 | 36544 | 36544 | 36544 | 1
34646 | 54541 | 32657 | 54541 | 54541 | 1
54451 | 565656 | 31186 | #N/A | Not Listed | 0
4485 | 34570 | 45412-1658 | 34570 | 34570 | 1
54541 | 31155-4588 | 34646 | 31155-4588 | 31155-4588 | 1
36544 | 54148-1524 | 38879 | 54148-1524 | 54148-1524 | 1
346896 | 39977 | 37775 | #N/A | Not Listed | 0
46546-1264 | 38641 |  | 38641 | 38641 | 1
56745-1518 | 32564 |  | 32564 | 32564 | 1
45412-1658 | 65124 |  | #N/A | Not Listed | 0
54148-1524 | 34576 |  | 34576 | 34576 | 1
349063 | 30021 |  | 30021 | 30021 | 1
46546-1265 | 34552 |  | 34552 | 34552 | 4
56745-1519 | 34552 |  | 34552 | 34552 | 4
45412-1659
37775
34515
38497
31451
31186
36518
34579
34576
34573
34570
34567
34564
34561
34558
34555
34552
34552
34552
34552
34573
34573
38879
34845
30021
300025
38641
35456
34645-5610
54249-8520
31155-4588
36621
362145
32564
32657
Spreadsheet: 290670d1389945766-highlightning-spesific-cell-based-on-paired-value-row-coloumn-compared-other-table-in-ot-sample
Sheet: Sheet2

Table 2
 | year
id | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
7201
7202
7203
7204
7205
7206
Spreadsheet: 232158d1367343093-sumif-help-clean
Sheet: ResourceList

 | AFCID | Name |  |  |  |  |  |  |  | Daily Rate | Daily Rate + Tax | Manager |  | Start Date | End Date |  |  | Secure
 | RAJU2 | [NAME] | Business | Sales & Public | BA | BA | Other | Daily | 1758 |  |  | [NAME] | Individual | 2012-04-01 00:00:00 | 2013-04-05 00:00:00 | Toronto (TDS-12) | Active | Secure
Spreadsheet: 790383d1659687030-cumulative-annualized-return-of-multiple-rows-based-on-multiple-conditions-sample-sheet
Sheet: Sheet1

Name | Fund Name | Units | Unit Purchase Price | Purchase Date | Current Unit Price | Total Purchase Value | Total Current Value | Current Price Date | Years Invested | Annualised Return
PLS | DSP Flexi Cap Fund | 277.367 | 72.103 | 2021-09-28 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00
PLS | DSP Flexi Cap Fund | 271.07 | 73.778 | 2021-10-27 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00
PLS | DSP Flexi Cap Fund | 283.152 | 70.63 | 2021-11-30 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00
PLS | Nippon India Small Cap Fund | 210.728 | 94.9042 | 2022-04-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00
PLS | Nippon India Small Cap Fund | 235.059 | 85.0806 | 2022-02-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00
PLS | Nippon India Small Cap Fund | 233.709 | 85.5723 | 2022-01-29 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00
PLS | Nippon India Small Cap Fund | 218.518 | 91.5212 | 2022-01-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00
BS | ICICI Prudential Exports & Services Fund | 104.888 | 47.67 | 2015-11-23 00:00:00 | 98.73 |  |  | 2022-08-05 00:00:00
BS | ICICI Prudential Exports & Services Fund | 419.903 | 47.63 | 2015-11-26 00:00:00 | 98.73 |  |  | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 14.279 | 700.31 | 2018-10-17 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 13.454 | 743.29 | 2018-12-03 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 12.823 | 779.87 | 2020-03-02 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 17.978 | 556.23 | 2020-04-01 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 15.867 | 630.23 | 2020-05-04 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00
Spreadsheet: 833066d1686759035-fields-updating-based-on-the-date-rota
Sheet: Main Sheet

2023-06-05 00:00:00 | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | DRIVER 5
MONDAY | DELIVERY RUN 1 | SPECIAL | DELIVERY RUN 2 | STAND BY
TUESDAY | DELIVERY RUN 3 | DELIVERY RUN 5 | DELIVERY RUN 6 | DELIVERY RUN 4 | DELIVERY RUN 9
WEDNESDAY | BIRMINGHAM | DELIVERY RUN 5 | DELIVERY RUN 6 | DELIVERY RUN 7
THURSDAY | BIRMINGHAM | HOLIDAY | DELIVERY RUN 10 | DELIVERY RUN 7 | 2nd DELIVERY RUN 2
FRIDAY | 2nd DELIVERY RUN 4 | HOLIDAY | STAND BY | DELIVERY RUN 7
nights out
12/06/2023 | [NAME] | GEOFF | DANNY | [NAME] | JERRY
MONDAY | HOLIDAY | STANDBY ? | DELIVERY RUN 1 | DELIVERY RUN 2 | STAND BY INTRO
TUESDAY | HOLIDAY | DELIVERY RUN 3/DELIVERY RUN 4 | DELIVERY RUN 8 | DELIVERY RUN 5 | DELIVERY RUN 9
WEDNESDAY | HOLIDAY | DELIVERY RUN 7 | DELIVERY RUN 8 | DELIVERY RUN 5 | DELIVERY RUN 9
THURSDAY | HOLIDAY | DELIVERY RUN 7 | DELIVERY RUN 8 | DELIVERY RUN 10 | 2nd DELIVERY RUN 2
FRIDAY | HOLIDAY | DELIVERY RUN 7 | STAND BY | 2nd DELIVERY RUN 4 | SPECIAL
nights out
2023-06-19 00:00:00 | [NAME] | GEOFF | DANNY | [NAME] | JERRY
MONDAY | HOLIDAY | STAND BY | DELIVERY RUN 1 | PICKUP | STAND BY
TUESDAY | HOLIDAY | DELIVERY RUN 8 | DELIVERY RUN 3 DELIVERY RUN 4 | DELIVERY RUN 9 | DELIVERY RUN 5
WEDNESDAY | HOLIDAY | DELIVERY RUN 8 | DELIVERY RUN 7 | TACHO | DELIVERY RUN 5
THURSDAY | HOLIDAY | DELIVERY RUN 8 | DELIVERY RUN 7 | DELIVERY RUN 10 | 2nd DELIVERY RUN 2
FRIDAY | STANDBY ? | SPECIAL | DELIVERY RUN 7 | STAND BY | 2nd DELIVERY RUN 4
nights out
2023-06-26 00:00:00 | [NAME] | GEOFF | DANNY | [NAME] | JERRY
MONDAY | STAND BY | DELIVERY RUN 2 | STAND BY | STAND BY | DELIVERY RUN 1
TUESDAY | DELIVERY RUN 5 | DELIVERY RUN 9 | DELIVERY RUN 8 | DELIVERY RUN 3 | DELIVERY RUN 4
WEDNESDAY | DELIVERY RUN 5 | STAND BY | DELIVERY RUN 8 | DELIVERY RUN 7 | STAND BY
THURSDAY | 2nd DELIVERY RUN 2 | DELIVERY RUN 10 | DELIVERY RUN 8 | DELIVERY RUN 7 | DELIVERY RUN 10
FRIDAY | STAND BY | 2nd DELIVERY RUN 4 | STAND BY | DELIVERY RUN 7 | STAND BY
nights out
Spreadsheet: 706379d1606672450-looking-for-a-formula-to-list-staff-names-from-shift-paterns-to-days-working-roster_template_demo
Sheet: Operator Shifts

Mon to Fri | Tue to Sat | Wed to Sun | Thur to Mon | Fri to Tue | Sat to Wed | Sun to Thur |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
12345 | 23456 | 34567 | 45671 | 56712 | 67123 | 71234
a | d | f | h | k | r | z
b | e | g | i | l | s | aa
c |  |  | j | m | t | ab
 |  |  |  | n | u | ac
 |  |  |  | o | v | ad
 |  |  |  | p | w | ae
 |  |  |  | q | x
 |  |  |  |  | y
Spreadsheet: 802583d1666930343-lazy-old-man-needs-formula-to-sum-values-by-month-need-formula-for-total-column-thanks-v2
Sheet: Sheet1

Input |  |  |  | Output
Dates | Numbers | Person |  | Months Away | Total | Total ([NAME]) | Month |  | Note the "OUTPUT" list will automatically calculate so that "Months Away" = 0 will always be the actual current month and the next 24 months (after the current month) will always be displayed. Each month will show the sum of "Numbers" in the [NAME] table that fall within that month.  Any data with dates before the current month will be ignored.  "Months Away" ("0" equals current month, 1= Next month, etc.)  "Total" is the sum of all the Numbers from the [NAME] table in the month (I need a formula for this). (GOT THIS NOT THANK YOU!)  "Total (Joe)" is the sum of only the Numbers from the [NAME] table in the month that have "[NAME]" in the Person column. (NOTE can you modify the formula in column F to yield this result.)  THIS IS THE ONE I NEED.  "Month" is the month and year of the month that is "Month's Away" number of months away from the current month. (GOT THIS NOW THANK YOU!)  I just use Edate() for the Month column.  What I need is the formula for the "Total" column.  If possible please provide it as a single formula rather than broken into parts in additional columns.
2023-03-10 00:00:00 | 186 | [NAME] | (current month)> | 0 |  |  | 2023-03-01 00:00:00
2023-08-16 00:00:00 | 70.96 | [NAME] | (next month)> | 1 |  |  | 2023-04-01 00:00:00
2024-12-24 00:00:00 | 50 | Shari | etc. | 2 |  |  | 2023-05-01 00:00:00
2024-05-20 00:00:00 | 88.44 | [NAME] | . | 3 |  |  | 2023-06-01 00:00:00
2024-12-03 00:00:00 | 96 | Shari | . | 4 |  |  | 2023-07-01 00:00:00
2023-04-02 00:00:00 | 43.27 | [NAME] | . | 5 |  |  | 2023-08-01 00:00:00
2023-03-24 00:00:00 | 499.33 | [NAME] | . | 6 |  |  | 2023-09-01 00:00:00
2024-07-04 00:00:00 | 7 | Shari | . | 7 |  |  | 2023-10-01 00:00:00
 |  |  | . | 8 |  |  | 2023-11-01 00:00:00
Note data pairs in list will be in random date order. |  |  | . | 9 |  |  | 2023-12-01 00:00:00
 |  |  | . | 10 |  |  | 2024-01-01 00:00:00
 |  |  |  | 11 |  |  | 2024-02-01 00:00:00
 |  |  |  | 12 |  |  | 2024-03-01 00:00:00
 |  |  |  | 13 |  |  | 2024-04-01 00:00:00
 |  |  |  | 14 |  |  | 2024-05-01 00:00:00
 |  |  |  | 15 |  |  | 2024-06-01 00:00:00
 |  |  |  | 16 |  |  | 2024-07-01 00:00:00
 |  |  |  | 17 |  |  | 2024-08-01 00:00:00
 |  |  |  | 18 |  |  | 2024-09-01 00:00:00
 |  |  |  | 19 |  |  | 2024-10-01 00:00:00
 |  |  |  | 20 |  |  | 2024-11-01 00:00:00
 |  |  |  | 21 |  |  | 2024-12-01 00:00:00
 |  |  |  | 22 |  |  | 2025-01-01 00:00:00
 |  |  |  | 23 |  |  | 2025-02-01 00:00:00
 |  |  |  | 24 |  |  | 2025-03-01 00:00:00
Spreadsheet: 115909d1311352759-lookup-required-to-check-codes-closure-dates-code
Sheet: Data

Name | Code | Date Closed
[NAME] | 11111 | 2011-07-20 00:00:00
George | 33333 | 2011-02-22 00:00:00
[NAME] | 22222 | 2007-01-13 00:00:00
Ringo | 11111 | 2011-07-20 00:00:00
[NAME] | 11111 | 2011-07-20 00:00:00
[NAME] | 44444 | 2011-05-05 00:00:00
[NAME] | 55555 | 2011-11-11 00:00:00
Fred | 11111 | 2011-07-20 00:00:00
[NAME] | 77777 | 2011-06-06 00:00:00
[NAME] | 33333 | 2011-02-22 00:00:00
Nicky | 88888 | 2011-09-09 00:00:00
[NAME] | 11111 | 2011-07-20 00:00:00
Faye | 22222 | 2007-01-13 00:00:00
Kathy | 11111 | 2011-07-20 00:00:00
[NAME] | 66666 | 2011-08-02 00:00:00
Heather | 33333 | 2011-02-22 00:00:00
[NAME] | 22222 | 2007-01-13 00:00:00
[NAME] | 11111 | 2011-07-20 00:00:00
[NAME] | 11111 | 2011-07-20 00:00:00
Fred | 44444 | 2011-05-05 00:00:00
[NAME] | 55555 | 2011-11-11 00:00:00
[NAME] | 11111 | 2011-07-20 00:00:00
Nicky | 77777 | 2011-06-06 00:00:00
[NAME] | 33333 | 2011-02-22 00:00:00
Faye | 88888 | 2011-09-09 00:00:00
Kathy | 11111 | 2011-07-20 00:00:00
[NAME] | 22222 | 2007-01-13 00:00:00
Spreadsheet: 677513d1589379606-ways-to-find-the-variation-in-a-set-of-values-sample
Sheet: Sheet1

Program | Month | Week | Date | Activity | ID | Tested By | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | Criteria 7
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | QA1 | 0 | 0 | 0 | 0 | 1 | 0 | 1
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | [NAME] | 1 | 0 | 1 | 0 | 0 | 0 | 1
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | [NAME] | 1 | 1 | 0 | 0 | 0 | 1 | 0
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | QA4 | 1 | 1 | 1 | 0 | 1 | 0 | 0
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | QA5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pilot | Feb | 9 | 2020-02-25 00:00:00 | [NAME] | 123 | QA6 | 0 | 0 | 0 | 0 | 1 | 1 | 0
Spreadsheet: lindy_donoho__22095__Prices10-24-01
Sheet: Socal-Avg

 |  |  |  |  | Permian |  |  |  |  |  |  | San Juan Blanco |  |  |  |  |  |  | SJ IG |  |  |  |  |  |  | SoCal |  |  |  |  |  |  | Waha*
Eff 10/24 | Nymex |  | Permian |  | Cash |  |  | Nymex |  | San Juan NB |  | Cash |  |  | Nymex |  | San Juan B |  | Cash |  |  | Nymex |  | Socal |  | Cash |  |  | Nymex |  | Waha |  | Cash
2001-11-01 00:00:00 | 2.681 |  | -0.22 |  |  |  |  |  |  | -0.225 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0625 |  |  |  |  |  |  | 0.005
2001-12-01 00:00:00 | 2.935 |  | -0.15 |  |  |  |  |  |  | -0.215 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.105 |  |  |  |  |  |  | -0.0225
Cal 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPREADS:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perm-SoCal | SJ-SoCal | SJ-Perm | Perm-Waha | SJ NB-SJ B
2002-01-01 00:00:00 | 3.11 |  | -0.155 |  |  |  |  |  |  | -0.2275 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0875 |  |  |  |  |  |  | -0.0325 |  |  | 2002-01-01 00:00:00
2002-02-01 00:00:00 | 3.117 |  | -0.15 |  |  |  |  |  |  | -0.2275 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0875 |  |  |  |  |  |  | -0.0275 |  |  | 2002-02-01 00:00:00
2002-03-01 00:00:00 | 3.074 |  | -0.14 |  |  |  |  |  |  | -0.2275 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0875 |  |  |  |  |  |  | -0.0225 |  |  | 2002-03-01 00:00:00
2002-04-01 00:00:00 | 2.982 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.02 |  |  | 2002-04-01 00:00:00
2002-05-01 00:00:00 | 3.013 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.025 |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 3.063 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.0375 |  |  | 2002-06-01 00:00:00
2002-07-01 00:00:00 | 3.103 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.05 |  |  | 2002-07-01 00:00:00
2002-08-01 00:00:00 | 3.145 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.055 |  |  | 2002-08-01 00:00:00
2002-09-01 00:00:00 | 3.145 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.045 |  |  | 2002-09-01 00:00:00
2002-10-01 00:00:00 | 3.175 |  | -0.125 |  |  |  |  |  |  | -0.285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1725 |  |  |  |  |  |  | 0.0125 |  |  | 2002-10-01 00:00:00
2002-11-01 00:00:00 | 3.36 |  | -0.125 |  |  |  |  |  |  | -0.19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1775 |  |  |  |  |  |  | -0.025 |  |  | 2002-11-01 00:00:00
2002-12-01 00:00:00 | 3.57 |  | -0.125 |  |  |  |  |  |  | -0.19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1775 |  |  |  |  |  |  | -0.0475 |  |  | 2002-12-01 00:00:00
Cal 2002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Waha is Inside FERC.
Spreadsheet: 71658d1272396302-how-to-add-scores-after-the-use-of-index-formula-dikkebeer1-tester-pages
Sheet: FINALE

 |  |  |  |  |  |  |  |  |  |  |  |  | FINALE
 |  |  | LAATSTE 8 |  |  |  |  |  | 36 |  |  | 8 |  |  |  | 4 |  |  | 2
 |  |  | A | a | 1 |  |  |  | 1 |  |  |  | a | 1
 |  |  | B | d | 2 |  |  |  | 2 |  |  |  | d | 2
 |  |  | C | f | 3 |  |  |  | 3 |  |  |  |  |  |  |  | d | 11
 |  |  | D | c | 4 |  |  |  | 4 |  |  |  |  |  |  |  | c | 12
 |  |  | E | g | 5 |  |  |  | 5 |  |  |  | f | 3
 |  |  | F | n | 6 |  |  |  | 6 |  |  |  | c | 4
 |  |  | G | L | 7 |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | c | 21
 |  |  | H | m | 8 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | m | 22
 |  |  |  |  |  |  |  |  |  |  |  |  | g | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | n | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | m | 8
 |  |  |  | INKOMENDE
 |  |  |  | TRANSPORT LIJN
 |  |  | A | a |  |  |  |  |  |  |  |  | for forum users that don't rad dutch it is not important for you to translate  the words   whit fields  are the  interactive parts Iplaced some scores in there to see if it works all you need to know is the names com from the "inschrijving" sheet
 |  |  | B | d
 |  |  | C | f
 |  |  | D | c
 |  |  | E | g |  |  |  |  |  |  |  |  | scorevakken - rekenwerk  eindscore rekenzooi nog verwerken waarbij 180 en hf op de pool moet staan (ook voor de in finale behaalde score daarvan)
 |  |  | F | n
 |  |  | G | L
 |  |  | H | m