tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A41

TABLE  A41 FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND TEN-MINUTE SPINNING RESERVE MARKET DURING JUNE, JULY, AND AUGUST OF 1998, 1999, AND 2000 AFTER ISO-NE REVISIONS
Price Equals or Exceeds | # of hours |  |  | # of hours |  |  | # of hours
 | % of available hours |  |  | % of available hours |  |  | % of available hours
 | 1998-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-06-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 1998-08-01 00:00:00 | 1999-08-01 00:00:00 | 2000-08-01 00:00:00
100 | NA | 21 | 1 | NA | 19 | 0 | NA | 0 | 0
 |  | 0.02917 | 0.00139 |  | 0.02554 | 0 |  | 0 | 0
250 | NA | 11 | 0 | NA | 13 | 0 | NA | 0 | 0
 |  | 0.01528 | 0 |  | 0.01747 | 0 |  | 0 | 0
500 | NA | 1 | 0 | NA | 8 | 0 | NA | 0 | 0
 |  | 0.00139 | 0 |  | 0.01075 | 0 |  | 0 | 0
750 | NA | 1 | 0 | NA | 4 | 0 | NA | 0 | 0
 |  | 0 | 0.00011 |  | 0.00139 | 0 |  | 0 | 0
1000 | NA | 0 | 0 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Source:  ISO-NE Website (www.iso-ne.com). Data was only available through August 15, 2000.
Spreadsheet: 173608d1344614642-drop-down-list-data-validation-matt
Sheet: Data

Vendor Number | Vendor Code
111 | AAA
222 | BBB
333 | CCC
444 | DDD
555 | EEE
666 | FFF
777 | GGG
888 | HHH
999 | III
1000 | JJJ
Spreadsheet: 41ef4739-f1f9-489d-b017-efd3a057c27c
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 5370 | 100 | 6087.563 |  | 2400 | 135 | 3122.563 | 5657.563 | 430
2012/132 | 430 | 5985 | 0 | 6415 |  | 2500 | 300 | 3115 | 5915 | 500
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-06-13 16:29:16.460000
Spreadsheet: 137993d1327461786-sum-cell-based-on-criteria-countif-formula-assistance-test-1-copyvlady
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | A |  | Y
 |  |  | A | B |  | A | B
 |  | x |  |  |  | A | B
 |  | y
 |  | z |  |  |  | A | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | Z
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  | A | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
Spreadsheet: 772887d1647512517-if-statement-makes-date-no-longer-chartable-book3-tms
Sheet: Sheet1

Date 1 | Value 1 |  |  | Date 2 | Value 2
2022-01-01 00:00:00 | 1 |  |  |  |  |  |  |  | dnrDates: | =Sheet1!$E$3:INDEX(Sheet1!$E:$E,MATCH(9.9E+307,Sheet1!$E:$E,1))
2022-02-01 00:00:00 | 2 |  |  |  |  |  |  |  | dnrValues: | =Sheet1!$F$3:INDEX(Sheet1!$F:$F,MATCH(9.9E+307,Sheet1!$E:$E,1))
2022-03-01 00:00:00 | 3
2022-04-01 00:00:00 | 6
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: Mergent

Mergent
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
MergentOnline
Logins | 10 | 1 | 101 | 148 | 487 | 124 | 17 | 57 | 40 | 190 | 9 | 10
Searches | 20 | 0 | 401 | 495 | 1717 | 700 | 326 | 258 | 132 | 347 | 11 | 32 |  | 13750
Companies Viewed | 7 | 0 | 250 | 174 | 678 | 410 | 130 | 158 | 109 | 1279 | 1 | 7
COUNTER-Compliant?: | No
Spreadsheet: 850065d1700469052-help-with-merging-data-from-two-tabs-training-tracker
Sheet: Master List

 | MASTER TRAINING TRACKER (AQGH & AQWCH)
 | NAME | ENTITY | DEPARTMENT | SPECIALTY | SESSION 1 | SESSION 2 | SESSION 3 | PERCENT COMPLETE | ASSESSMENT SCORE | RESULT
Spreadsheet: 104406d1302025932-conditional-formatting-for-future-dates-book1_just_tonight-
Sheet: Sheet1

Date Next Test Due
2011-02-19 00:00:00
2011-02-20 00:00:00
2011-02-21 00:00:00
2011-02-22 00:00:00
2011-02-23 00:00:00
2011-02-24 00:00:00
2011-02-25 00:00:00
2011-02-26 00:00:00
2011-02-27 00:00:00
2011-02-28 00:00:00
2011-03-01 00:00:00
2011-03-02 00:00:00
2011-03-03 00:00:00
2011-03-04 00:00:00
2011-03-05 00:00:00
2011-03-06 00:00:00
2011-03-07 00:00:00
2011-03-08 00:00:00
2011-03-09 00:00:00
2011-03-10 00:00:00
2011-03-11 00:00:00
2011-03-12 00:00:00
2011-03-13 00:00:00
2011-03-14 00:00:00
2011-03-15 00:00:00
2011-03-16 00:00:00
2011-03-17 00:00:00
2011-03-18 00:00:00
2011-03-19 00:00:00
2011-03-20 00:00:00
2011-03-21 00:00:00
2011-03-22 00:00:00
2011-03-23 00:00:00
2011-03-24 00:00:00
2011-03-25 00:00:00
2011-03-26 00:00:00
2011-03-27 00:00:00
2011-03-28 00:00:00
2011-03-29 00:00:00
2011-03-30 00:00:00
2011-03-31 00:00:00
2011-04-01 00:00:00
2011-04-02 00:00:00
2011-04-03 00:00:00
2011-04-04 00:00:00
2011-04-05 00:00:00
2011-04-06 00:00:00
2011-04-07 00:00:00
2011-04-08 00:00:00
2011-04-09 00:00:00
2011-04-10 00:00:00
2011-04-11 00:00:00
2011-04-12 00:00:00
2011-04-13 00:00:00
2011-04-14 00:00:00
2011-04-15 00:00:00
2011-04-16 00:00:00
2011-04-17 00:00:00
2011-04-18 00:00:00
Spreadsheet: 882191d1730459975-need-formula-to-return-names-in-a-list-example-list
Sheet: Sheet1

 | Basic data:
 | Wk/Name | 2024-45 | 2024-46 | 2024-47 | 2024-48 | 2024-49 | 2024-50 | 2024-51 | 2024-52 | 2025-01 | 2025-02
 | Name 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 | Name 2 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Name 3 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
 | Name 4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1
 | Name 5 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Name 6 | x | 0 | 1 | 1 | 1 | x | x | x | x | x
 | Name 7 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0
 | Need a formula to return the zero values i whatever kind of list that is suitable (want this list to occur in another spreadsheet):
 |  | 2024-45 | 2024-46 | 2024-47 | 2024-48 | 2024-49 | 2024-50 | 2024-51 | 2024-52 | 2025-01 | 2025-02
 |  | Name 3 | Name 3 | Name 5 | Name 2 | Name 2 | Name 4 | Name 4 |  | Name 1 | Name 1
 |  |  | Name 6 |  | Name 5 | Name 4 |  | Name 7 |  | Name 3 | Name 7
 |  |  |  |  |  | Name 5 |  |  |  | Name 7
Spreadsheet: 65678d1266359673-solution-data-sorting-data_sort
Sheet: Employee Sort

User Employee Number | Distinct User Name | Distinct Root Activity Name | Question Identifier | Result
2014564 | [NAME], [NAME] | MAPS 00 Assessment | Cat. | Correct
2012044 | Ponciano, [NAME] | MAPS 00 Assessment | Cat. | wrong
2012530 | Mitchell, [NAME] | MAPS 00 Assessment | Cat. | Correct
 | #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
 | #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: 850945d1701248353-vlookup-only-returning-first-value-and-sumif-returning-the-sum-twice-book29-1-aligw
Sheet: Sheet1

 |  |  | Sheet 1 |  |  |  |  | Sheet 2
 |  |  | IDs | Amount | sumif |  |  | IDs | Amount | Sumif
 |  |  | 96162 |  | 100 |  |  | 96162 | 100
 |  |  | 81180 | 50 | 50 |  |  | 81180 | 50
 |  |  | B3FLWH9 | 10 | 10 |  |  | B3FLWH9 | 10
 |  |  | 182704 | 20 | 45 |  |  | 182704 | 20
 |  |  | 182704 | 25 | 45 |  |  | 182704 | 25
 |  |  |  | 1) | I would like F8 to return 45 and for F9 to be zero or for [NAME] and F9=25
 |  |  |  | 2) | cell E9 to return 25
Spreadsheet: 119308d1314304393-nested-max-mins-sample-file
Sheet: Sheet1

Agent | Aux | [NAME] | [NAME] | Logout Date | Logout Time
[NAME] | 0 | 2011-08-14 00:00:00 | 08:05:29 | 2011-08-14 00:00:00 | 10:05:38
[NAME] | -1 | 2011-08-14 00:00:00 | 17:00:16 | 2011-08-14 00:00:00 | 17:00:16
[NAME] | 0 | 2011-08-15 00:00:00 | 07:59:42 | 2011-08-15 00:00:00 | 09:11:43
[NAME] | -1 | 2011-08-15 00:00:00 | 17:06:42 | 2011-08-15 00:00:00 | 17:06:42
[NAME] | 0 | 2011-08-18 00:00:00 | 07:59:48 | 2011-08-18 00:00:00 | 08:03:48
[NAME] | -1 | 2011-08-18 00:00:00 | 17:12:27 | 2011-08-18 00:00:00 | 17:12:27
[NAME] | 0 | 2011-08-19 00:00:00 | 08:00:09 | 2011-08-19 00:00:00 | 08:50:40
[NAME] | -1 | 2011-08-19 00:00:00 | 17:24:58 | 2011-08-19 00:00:00 | 17:24:58
[NAME] | 0 | 2011-08-20 00:00:00 | 08:00:07 | 2011-08-20 00:00:00 | 08:33:28
[NAME] | -1 | 2011-08-20 00:00:00 | 17:14:30 | 2011-08-20 00:00:00 | 17:14:30
Alejandro | 0 | 2011-08-18 00:00:00 | 12:06:48 | 2011-08-18 00:00:00 | 14:00:28
Alejandro | -1 | 2011-08-18 00:00:00 | 23:00:06 | 2011-08-18 00:00:00 | 23:00:06
Alejandro | 0 | 2011-08-19 00:00:00 | 12:00:43 | 2011-08-19 00:00:00 | 13:01:47
Alejandro | -1 | 2011-08-19 00:00:00 | 23:00:12 | 2011-08-19 00:00:00 | 23:00:12
Alejandro | 0 | 2011-08-20 00:00:00 | 12:03:16 | 2011-08-20 00:00:00 | 13:23:38
Alejandro | -1 | 2011-08-20 00:00:00 | 19:29:36 | 2011-08-20 00:00:00 | 19:32:46
Alejandro | 0 | 2011-08-20 00:00:00 | 19:32:46 | 2011-08-20 00:00:00 | 20:19:03
Alejandro | -1 | 2011-08-20 00:00:00 | 23:00:10 | 2011-08-20 00:00:00 | 23:00:10
Andres | 0 | 2011-08-15 00:00:00 | 15:00:24 | 2011-08-15 00:00:00 | 15:05:24
Andres | -1 | 2011-08-16 00:00:00 | 00:16:19 | 2011-08-16 00:00:00 | 00:16:19
Andres | -1 | 2011-08-16 00:00:00 | 00:16:19 | 2011-08-16 00:00:00 | 15:00:39
Andres | 0 | 2011-08-16 00:00:00 | 15:00:39 | 2011-08-16 00:00:00 | 17:06:29
Andres | -1 | 2011-08-17 00:00:00 | 00:01:55 | 2011-08-17 00:00:00 | 00:01:55
Andres | -1 | 2011-08-17 00:00:00 | 00:01:55 | 2011-08-17 00:00:00 | 15:00:36
Andres | 0 | 2011-08-17 00:00:00 | 15:00:36 | 2011-08-17 00:00:00 | 15:31:55
Spreadsheet: 157021d1337600987-how-to-define-the-x-and-y-axes-ranges-from-a-cell-input-832528
Sheet: Sheet1

Altitude | X | Y | Conditional Y
0 | 500 | 700 |  |  |  | Min Altitude | 0
10 | 525 | 775 |  |  |  | [NAME] | 150
15 | 550 | 850
20 | 575 | 925
25 | 600 | 1000
32 | 625 | 1075
38 | 650 | 1150
44 | 675 | 1225
50 | 700 | 1300
56 | 725 | 1375
62 | 750 | 1450
68 | 775 | 1525
74 | 800 | 1600
80 | 825 | 1675
86 | 850 | 1750
92 | 875 | 1825
98 | 900 | 1900
104 | 925 | 1975
110 | 950 | 2050
116 | 975 | 2125
122 | 1000 | 2200
128 | 1025 | 2275
134 | 1050 | 2350
140 | 1075 | 2425
Spreadsheet: 329924d1404458987-sales-projection-dc-final
Sheet: Africa Analysis

Indonesia | Phillipines | Srilanka |  |  | [NAME] | Focus | [NAME]
SOUTH AFRICA | SOUTH AFRICA | SOUTH AFRICA |  |  | SOUTH AFRICA | South africa | Egypt
EGYPT A RP | EGYPT A RP | EGYPT A RP |  |  | ALGERIA
ANGOLA |  |  |  |  | EGYPT A RP |  |  | EGYPT A RP | 1045 | 888 | 763 | 899 | 1730 | 1313
 |  |  |  |  | SENEGAL |  |  | EGYPT A RP | 906 | 934 | 1045 | 1106 | 587 | 623
 |  |  |  |  |  |  |  | EGYPT A RP | 5194 | 3845 | 4790 | 3125 | 4831 | 4594
 |  |  |  |  |  |  |  | Total I+P+S
 |  |  |  |  |  |  |  | EGYPT A RP Import | 6988 | 11410 | 9000 | 4695 | 11353 | 8555
 |  |  |  |  |  |  |  | Share of IPS
 |  |  |  |  |  |  |  | SOUTH AFRICA | 725 | 985 | 2162 | 1233 | 1687 | 1293
 |  |  |  |  |  |  |  | SOUTH AFRICA | 834 | 1556 | 603 | 758 | 1157 | 1220
 |  |  |  |  |  |  |  | SOUTH AFRICA | 628 | 358 | 200 | 118 | 387 | 0
 |  |  |  |  |  |  |  | Total IPS
 |  |  |  |  |  |  |  | SOUTH AFRICA | 5279 | 5562 | 5525 | 4518 | 5785 | 5264
 |  |  |  |  |  |  |  | Share of IPS
Spreadsheet: fc09c242-6ccf-483e-9f48-03cc0c8354ed
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7101 | 47678 | [NAME] | [NAME] | ESP | 73 | 00:27:18 | 00:02:05 | 01:50:36 | 00:00:59 | 00:24:17 | 1 | 02:45:15
7101 | 47645 | Santiago | [NAME] | ESP | 72 | 00:26:48 | 00:01:37 | 02:06:59 | 00:00:48 | 00:37:55 | 2 | 03:14:11
7101 | 40953 | [NAME] | [NAME] | GBR | 70 | 00:27:08 | 00:02:53 | 02:21:12 | 00:01:23 | 00:58:54 | 3 | 03:51:31
7101 | 12645 | Santos | Caballero | ESP | 71 | 00:30:55 | 00:02:41 | [NAME] | [NAME] | 01:06:57 | 4 | 05:21:25
Spreadsheet: 684838d1593568711-removing-duplicate-dates-from-multiple-cells-late-login-report-example-excel-help-forum
Sheet: Report Template

Agent ID
 | [NAME] | Calculated Late Times
[NAME] | 6/1/20 7:54:23 AM
[NAME] | 6/2/20 7:54:48 AM
[NAME] | 6/3/20 7:54:01 AM
[NAME] | 6/3/20 12:54:56 PM
[NAME] | 6/3/20 1:07:27 PM
[NAME] | 6/4/20 7:50:20 AM
[NAME] | 6/5/20 7:57:17 AM
[NAME] | 6/5/20 9:24:55 AM
[NAME] | 6/5/20 1:06:07 PM
[NAME] | 6/8/20 7:52:13 AM
[NAME] | 6/8/20 12:59:48 PM
[NAME] | 6/9/20 7:59:20 AM
[NAME] | 6/9/20 8:05:10 AM
[NAME] | 6/10/20 8:01:27 AM
[NAME] | 6/10/20 2:51:17 PM
[NAME] | 6/11/20 8:25:31 AM
[NAME] | 6/11/20 8:46:46 AM
[NAME] | 6/11/20 10:18:57 AM
[NAME] | 6/12/20 7:49:00 AM
[NAME] | 6/15/20 7:52:38 AM
[NAME] | 6/15/20 8:30:08 AM
[NAME] | 6/15/20 1:58:25 PM
[NAME] | 6/16/20 7:50:53 AM
aoneal | 6/1/20 6:06:11 AM
aoneal | 6/2/20 5:58:39 AM
aoneal | 6/4/20 6:02:59 AM
aoneal | 6/5/20 5:50:07 AM
aoneal | 6/5/20 6:34:27 AM
aoneal | 6/8/20 5:53:42 AM
aoneal | 6/9/20 6:01:07 AM
aoneal | 6/9/20 9:47:37 AM
aoneal | 6/10/20 5:53:36 AM
aoneal | 6/11/20 6:53:06 AM
aoneal | 6/12/20 6:01:45 AM
ahawthor | 6/1/20 5:49:56 AM
ahawthor | 6/1/20 12:13:20 PM
ahawthor | 6/2/20 6:06:16 AM
ahawthor | 6/2/20 8:08:07 AM
ahawthor | 6/3/20 6:03:11 AM
ahawthor | 6/4/20 6:03:57 AM
ahawthor | 6/5/20 6:10:30 AM
ahawthor | 6/8/20 5:58:45 AM
ahawthor | 6/8/20 10:18:23 AM
ahawthor | 6/8/20 1:21:07 PM
ahawthor | 6/9/20 6:03:22 AM
ahawthor | 6/9/20 7:45:03 AM
ahawthor | 6/10/20 6:07:15 AM
ahawthor | 6/10/20 9:23:58 AM
ahawthor | 6/10/20 9:28:50 AM
Spreadsheet: 12ff1e54-c6e4-4fa3-b187-6559446763dd
Sheet: Sheet1

Pennsylvania Three-Year (Fiscal) Average Weekly Wage | Unnamed: 1 | Unnamed: 2
for Unemployment Compensation (UC) Purposes
Three-Year Period | Average Weekly Wage 1/ | Applicable Calendar Benefit Year for UC Purposes 2/
July 2008-June 2011 | 863.83 | 2012
July 2009-June 2012 | 888.09 | 2013
July 2010-June 2013 | 912.53 | 2014
July 2011-June 2014 | 933.51 | 2015
1/ Statewide Average Weekly Wage (SAWW) to be used for UC purposes as designated under amendments from Act 6 of 2011 (signed into law June 17, 2011) and Act 60 of 2012 (signed into law June 12, 2012).
2/ Per Act 6 of 2011, starting in 2012, severance pay deductions from UC are based on the three-year (fiscal) average weekly wage calculation.  In addition, the maximum weekly benefit for calendar year 2012 was frozen at the rate calculated for calendar year 2011 ($573).    Act 60 of 2012 extended  the freeze on the maximum weekly benefit for calendar years 2013 through 2019 at the rate calculated for calendar year 2011.  For calendar years 2020 through 2023, the maximum weekly benefit rate will be calculated based on the three-year (fiscal) average weekly wage calculation with an 8 percent per year limit on increases to the maximum rate.  For calendar years 2024 and beyond, the 8 percent per year limit on increases will be removed.
Spreadsheet: 274156d1383036099-how-to-configure-vlookup-to-filter-first-one-or-two-key-words-flag-scenario-rambo2-
Sheet: File1

 | File [1]
flag # | business name | New column | flag rank
1 | amadeus corp.
2 | eion inc.
3 | ryo ltd.
4 | cat tech.
5 | drew usa
6 | drew ph.
7 | [NAME].
8 | regulis co.
9 | red orange violet
10 | iso pte. Inc.
Spreadsheet: 672552d1586905361-building-summary-report-find-multiple-matches-in-a-table-04-10-20-cattle-close-out-report-excel-forum
Sheet: Sheet1

Lot: | [NAME]
Head Days
 |  |  | Qty | [NAME] | %%
 | Total Head Purchased
 | Total Deaths
 | Total Realizers
 | Total Sold
 |  |  | Total | P/H | P/Lb
 | Total Puchase Cost
 | Total Realizer Income
 | Total Sales
Total Dry Matter Intake |  |  |  | Total Wt Gain (Dead's In)
Avg Per Head DMI |  |  |  | Total Wt Gain (Dead's Out)
DM Conv Rate - Deads In |  |  |  | Cost of Gain (Dead's In)
DM Conv Rate - Deads Out |  |  |  | Cost of Gain (Dead's Out)
 |  | ADG (Dead's In)
 |  | ADG (Dead's Out)
 | Total Sales
 | Total cattle Purchase Cost
 | Total Feed Cost
 | Total Med & Vet & Rendering
 | Total Supplemental Feed
 | Total Expense
 | Total Profit / (Loss)
 | Total Profit / (Loss) P/H
Purchase
 | Date | CMS | Qty | Description
Spreadsheet: 293354d1390956070-is-it-possible-to-inter-link-sheets-in-the-same-book-forum-example-bvj-
Sheet: Report Sheet

 |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Class | Previous Date | Months | Last Date
 |  |  |  |  |  |  | DOUBLE END TENONER
 |  |  |  |  |  |  | POST FORMER
 |  |  |  |  |  |  | SHEAR SAW
 |  |  |  |  |  |  | KIKIKAWA SAW
 |  |  |  |  |  |  | CROSSCUT SAWS
 |  |  |  |  |  |  | DRILL
 |  |  |  |  |  |  | FIRST AID
 |  |  |  |  |  |  | FIRE WARDEN
Spreadsheet: 1cf7fb3b-1dfd-44fc-8435-6791161da906
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RURAU | Test | RURAU | Urea, Random, [NAME] | Urea, Random, U | Kinetic Ultraviolet Assay | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | No established reference values | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 84540 |  |  |  |  | Rochester
RURAU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RURAU | Result | URCON | Urea, Random, U | Urea, Random, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 3092-4 | Urea:MCnc:Pt:[NAME]:Qn:
RURAU | Result | CREA5 | Creatinine Concentration | Creatinine Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2161-8 | Creatinine:MCnc:Pt:[NAME]:Qn:
RURAU | Result | RATO4 | Urea/Creatinine Ratio | Urea/Creatinine Ratio | Numeric |  |  |  |  | mg/mg |  |  |  |  |  |  |  |  |  | 56997-0 | Urea/Creatinine:MCrto:Pt:Ser/Plas:Qn:
Spreadsheet: 104930d1302382672-totals-across-16-sheets-lineup4
Sheet: Game 1

[NAME] | Player | 1st | 2nd | 3rd | 4th | 5th | 6th | Bench | Infield | Outfield |  |  |  | Bench | Infield | Outfield
1 | Garrett | P | SS | 2nd
2 | [NAME] | 3rd | LF | P
3 | Jonah | SS | B | C
4 | [NAME] | 1st | B | LF
5 | Kort | 2nd | CF | 3rd
6 | [NAME] | B | 3rd | RF
7 | Lukas | LF | C | 1st
8 | Tyler | RF | 1st | SS
9 | Kyler | CF | P | B
10 | Stuart | C | RF | B
11 | [NAME] | B | 2nd | CF
12
 | CF
 | RF
 | LF
 | P
 | C
 | 1st
 | 2nd
 | 3rd
 | SS
 | B
 | Num Players
 | 11
Spreadsheet: 814290d1674257601-look-up-same-requirements-output-different-results-automation-test-real-world
Sheet: Source

From | To |  |  |  |  | Leader | Activity | Unit | Booked | Product Code |  |  | The important details here are the dates, Leader, and Activity  Some of the sheets I would like to automate will have the same activities on the same dates, but different names need to populate based on the "Unit" number into different columns.
2022-06-13 00:00:00 | 2022-06-13 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 22 | ABC123
2022-06-13 00:00:00 | 2022-06-13 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-27 00:00:00 | 2022-06-27 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 19 | ABC123
2022-06-27 00:00:00 | 2022-06-27 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 19 | ABC123
2022-06-28 00:00:00 | 2022-07-01 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 19 | ABC123
2022-06-28 00:00:00 | 2022-07-01 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 19 | ABC123
Spreadsheet: 766931d1644172522-finding-multiple-criteria-in-nth-rows-draft-rota-example
Sheet: Data tables

 |  | JANUARY | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | Leave (inc emergency) | Unpaid | Sick | Covid related | Maternity | Overtime | Agency | Hours worked | Total hours accounted for | 1 to 2 January | 3 to 9 January | 10 to 16 January | 17 to 23 January | 24 to 30 January | 31 January | January Totals
 |  |  | 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 |  |  |  |  |  |  |  |  |  | Week 2 scheduled hours | Week 1 scheduled hours | Week 2 scheduled hours | Week 1 scheduled hours | Week 2 scheduled hours | Week 1 scheduled hours
 | Number of shifts covered |  | 1
 |  |  | 5
 |  | JANUARY | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | Leave (inc emergency) | Unpaid | Sick |  | Maternity | Overtime | Agency | Hours worked | Total hours accounted for | 1 to 2 January | 3 to 9 January | 10 to 16 January | 17 to 23 January | 24 to 30 January | 31 January | January Totals
 |  |  | 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 |  |  |  |  |  |  |  |  |  | Week 2 scheduled hours | Week 1 scheduled hours | Week 2 scheduled hours | Week 1 scheduled hours | Week 2 scheduled hours | Week 1 scheduled hours
 |  | Replacement
 |  | Replacement
 |  | Replacement
 |  | Replacement
 |  | Replacement
 |  | Replacements - earlies
 |  | Replacements - lates
Spreadsheet: 753316d1635359130-look-up-formula-to-find-and-return-value-eta-report
Sheet: Report

DELIVERY DATE REPORT
PO Number | SKU | Delivery Date | Quantity
573829 | ABE-43545 | 2021-10-28 00:00:00 | 100
532839 | VDE-46466 | 2021-11-04 00:00:00 | 172
572829 | DSS-45355 | 2021-11-18 00:00:00 | 754
592823 | DWD-43462
572293 | FSS-12144
562611 | JDS-34534
572822 | EFF-46363
524563 | BGR-56621
523442 | JJE-35355
Spreadsheet: 762035d1641372671-combine-columns-datas-for-identical-values-in-first-column-test5-2-
Sheet: test2

 |  | node | supp Type | other | value |  |  | TAG
130 | 140 | 139 | +Z |  |  | 0.35 |  | text1 text2 text3
130 | 140 | 139 | X |  |  | 0.35 |  | supp(0001)
130 | 140
130 | 140
130 | 140
130 | 140
180 | 185 | 185 | +Z |  |  | 0.35 |  | tag2
180 | 185 | 185 | Guide |  | 2 | 0.35 |  | tag3
180 | 185 | 185 | LIM |  | 4 | 0.35 |  | supp(0002)
180 | 185
180 | 185
180 | 185
370 | 380 | 380 | ANC |  |  |  | 2000 | supp(0003)
370 | 380
370 | 380
370 | 380
370 | 380
370 | 380
5174 | 10000 | 10000 | +Z |  |  | 0.35 |  | tag4
5174 | 10000 | 10000 | Guide |  | 2 | 0.35 |  | supp(0004)
5174 | 10000
5174 | 10000
5174 | 10000
5174 | 10000
5109 | 10020 | 10020 | +Z |  |  | 0.35 |  | tag5
5109 | 10020 | 10020 | Guide |  |  |  |  | tag6
5109 | 10020 | 10020 | LIM |  |  |  |  | supp(0005)
5109 | 10020
5109 | 10020
5109 | 10020
5200 | 6000 | 6000 | +Z |  |  |  |  | tag7
5200 | 6000 | 6000 | Guide |  |  |  |  | tag8
5200 | 6000 | 6000 | LIM |  |  |  |  | abcdefghijklmnopqrstuvz