tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877047d1723725648-automatic-time-scheduler-student-scheduler
Sheet: Output

 | Monday | Tuesday | Wednesday | Thursday | Friday
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
Spreadsheet: andy_zipper__633__11_21_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 19 | 250 | 258 | 65.9 | 68 | 0.8 | 2001-11-21 11:11:00
 | CL G2 | 19.5 | 355 | 370 | 58.7 | 61.2 | 0.73 | 2001-11-21 11:11:00
 | CL H2 | 19.5 | 415 | 430 | 55.9 | 58 | 0.7 | 2001-11-21 11:11:00
 | CL J2 | 19.5 | 460 | 475 | 53.8 | 55.5 | 0.67 | 2001-11-21 11:11:00
 | CL K2 | 19.5 | 500 | 520 | 51.7 | 53.8 | 0.65 | 2001-11-21 11:11:00
 | CL M2 | 20 | 525 | 540 | 48.5 | 49.9 | 0.62 | 2001-11-21 11:11:00
 | CL N2 | 20 | 535 | 555 | 45.7 | 47.4 | 0.59 | 2001-11-21 11:11:00
 | CL Q2 | 20 | 555 | 575 | 44.5 | 46.1 | 0.57 | 2001-11-21 11:11:00
 | CL U2 | 20 | 555 | 570 | 42.1 | 43.3 | 0.54 | 2001-11-21 11:11:00
 | [NAME] | 20.5 | 560 | 585 | 39.3 | 41.1 | 0.52 | 2001-11-21 11:11:00
 | CL X2 | 20.5 | 565 | 590 | 38 | 39.7 | 0.5 | 2001-11-21 11:11:00
 | [NAME] | 20.5 | 565 | 590 | 36.6 | 38.2 | 0.48 | 2001-11-21 11:11:00
 | CL M3 | 21 | 570 | 600 | 30.1 | 31.7 | 0.41 | 2001-11-21 11:11:00
 | CL Z3 | 21 | 570 | 600 | 26.8 | 28.2 | 0.36 | 2001-11-21 11:11:00
 | CL M4 | 21.5 | 570 | 600 | 23.9 | 25.2 | 0.33 | 2001-11-21 11:11:00
Spreadsheet: lisa_gang__22240__EPE_MARCH_2002
Sheet: MARCH(28)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-28 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | PALO VERDE |  | FOUR CORNERS
Pacific | Mountain | SALE | SALE |  | PURCHASE
Standard | Standard | EPMI | PNM |  | PNM
Time | Time | 22.25
 |  | CARRY OVER FROM 3/27 | CARRY OVER FROM 3/27 |  | CARRY OVER FROM 3/27
 |  | 3/1/02-3/31/02 | 2002-03-27 00:00:00 |  | 2002-03-27 00:00:00
 |  | EPMI TAG#41707 | MORGAN TAG#MS12409 |  | EPMI TAG#41726 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL
2400 | 0100 | 25 | 50 |  | -50
0100 | 0200 | 0 | 0 |  | 0
0200 | 0300 | 0 | 0 |  | 0
0300 | 0400 | 0 | 0 |  | 0
0400 | 0500 | 0 | 0 |  | 0
0500 | 0600 | 0 | 0 |  | 0
0600 | 0700 | 0 | 0 |  | 0
0700 | 0800 | 0 | 0 |  | 0
0800 | 0900 | 0 | 0 |  | 0
0900 | 1000 | 0 | 0 |  | 0
1000 | 1100 | 0 | 0 |  | 0
1100 | 1200 | 0 | 0 |  | 0
1200 | 1300 | 0 | 0 |  | 0
1300 | 1400 | 0 | 0 |  | 0
1400 | 1500 | 0 | 0 |  | 0
1500 | 1600 | 0 | 0 |  | 0
1600 | 1700 | 0 | 0 |  | 0
1700 | 1800 | 0 | 0 |  | 0
1800 | 1900 | 0 | 0 |  | 0
1900 | 2000 | 0 | 0 |  | 0
2000 | 2100 | 0 | 0 |  | 0
2100 | 2200 | 0 | 0 |  | 0
2200 | 2300 | 0 | 0 |  | 0
2300 | 2400 | 0 | 0 |  | 0
2400 | 0100 | 0 | 0 |  | 0
 | MST Total |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)PV |  | PNM(G)4C345
 |  | EPMI | PNM |  | EPMI
 |  | AZPS(T)FC3/PPD2 | EPMI |  | EPE
 |  | WALC(T)PPD2/COOLIDGE | NEVP |  | EPE(T4C345/4C345
 |  | CRSP(L)COOLIDGE | PAC |  | EPE(L)4C345
 |  |  | MORGAN
 |  |  | APX
 |  |  | ISO(T)PVD/SP15
 |  |  | [NAME]
Spreadsheet: 856887d1706053966-i-need-to-preserve-every-donors-last-two-donations-and-get-rid-of-the-rest-excel-problem
Sheet: Sheet1

Name | [NAME] | [NAME]
[NAME] | 930 | 2024-01-03 00:00:00 | Preserve
[NAME] | 1000 | 2023-12-10 00:00:00 | Preserve
[NAME] | 300 | 2022-03-01 00:00:00 | Delete
[NAME] | 740 | 2021-08-04 00:00:00 | Delete
[NAME] | 2000 | 2020-09-19 00:00:00 | Delete
[NAME] | 1500 | 2020-01-28 00:00:00 | Delete
[NAME] | 300 | 2023-12-31 00:00:00 | Preserve
[NAME] | 400 | 2022-12-10 00:00:00 | Preserve
[NAME] | 800 | 2022-11-01 00:00:00 | Delete
[NAME] | 300 | 2022-07-18 00:00:00 | Delete
[NAME] | 250 | 2021-11-23 00:00:00 | Delete
[NAME] | 100 | 2020-10-14 00:00:00 | Delete
Spreadsheet: 683517d1592805475-adding-indirect-function-to-an-existing-if-statement-no-need-for-indirct-aligw
Sheet: Draft Array

 |  | numteams:
 | Snake
Round
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
linear
Round
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 28

1537
Name | Amount
Name 3 | 191
Name 2 | 142
Name 1 | 180
Name 1 | 124
Name 1 | 191
Name 3 | 170
Name 3 | 140
Name 2 | 117
Name 2 | 103
Name 1 | 172
Name 1 | 196
Name 3 | 151
Name 1 | 139
Name 1 | 121
Name 2 | 142
Name 3 | 183
Name 2 | 119
Name 1 | 131
Name 2 | 199
Name 2 | 131
Name 3 | 185
Name 2 | 123
Name 2 | 129
Name 1 | 152
Name 1 | 131
Spreadsheet: 769673d1645634093-retrieve-value-based-on-multiple-criteria-sample-file
Sheet: Sheet1

Invoice Date | Invoice number | Trade/Legal name | Rate(%) | Taxable Value (₹) | Cess(₹) |  | Invoice Number | Invoice Date | Receiver Name | 0 | 5 | 12 | 18 | 28
21/01/2022 | 4749 | POORVIKA ENTERPRISES | 5 | 3714.23 | 0 |  | 4749
16/01/2022 | AK29IT2122A45252 | AMOLAKCHAND ANKUR KOTHARI ENTERPRISES PVT LTD | 12 | 395.26 | 0 |  | AK29IT2122A45252
20/01/2022 | Q291522709 | C H AGENCIES | 18 | 6814 | 0 |  | Q291522709
12/01/2022 | 1931 | LG CENTURY MARKETING | 5 | 2338.1 | 0 |  | 1931
26/01/2022 | 2067 | LG CENTURY MARKETING | 5 | 2295.24 | 0 |  | 2067
10/01/2022 | CKBIL2108783 | JEEVAN DISTRIBUTORS | 18 | 8550.63 | 0 |  | CKBIL2108783
10/01/2022 | CKBIL2108784 | JEEVAN DISTRIBUTORS | 18 | 5690.11 | 0 |  | CKBIL2108784
17/01/2022 | CKBIL2108951 | JEEVAN DISTRIBUTORS | 18 | 4568.87 | 0 |  | CKBIL2108951
31/01/2022 | CKBIL2109433 | JEEVAN DISTRIBUTORS | 18 | 9867.59 | 0 |  | CKBIL2109433
 |  |  |  |  |  |  | I need this
 |  |  |  |  |  |  | Invoice Number | Invoice Date | Receiver Name | 0 | 5 | 12 | 18 | 28
 |  |  |  |  |  |  | 4749 | 21/01/2022 | POORVIKA ENTERPRISES | 0 |  |  |  | 0
 |  |  |  |  |  |  | AK29IT2122A45252 | 16/01/2022 | AMOLAKCHAND ANKUR KOTHARI ENTERPRISES PVT LTD | 0 |  |  |  | 0
 |  |  |  |  |  |  | Q291522709 | 20/01/2022 | C H AGENCIES | 0 |  |  |  | 0
 |  |  |  |  |  |  | 1931 | 12/01/2022 | LG CENTURY MARKETING | 0 |  |  |  | 0
 |  |  |  |  |  |  | 2067 | 26/01/2022 | LG CENTURY MARKETING | 0 |  |  |  | 0
 |  |  |  |  |  |  | CKBIL2108783 | 10/01/2022 | JEEVAN DISTRIBUTORS | 0 |  |  |  | 0
 |  |  |  |  |  |  | CKBIL2108784 | 10/01/2022 | JEEVAN DISTRIBUTORS | 0 |  |  |  | 0
 |  |  |  |  |  |  | CKBIL2108951 | 17/01/2022 | JEEVAN DISTRIBUTORS | 0 |  |  |  | 0
 |  |  |  |  |  |  | CKBIL2109433 | 31/01/2022 | JEEVAN DISTRIBUTORS | 0 |  |  |  | 0
Spreadsheet: 482665d1475175738-how-to-return-column-header-based-on-a-value-from-a-table-elf607-msc-caseload-with-search-function-
Sheet: Valerie

[NAME] (60) | 7 PCSS | [NAME] (39) |  | [NAME] (40) | 3 PCSS | [NAME] (44) | 4 PCSS | [NAME] (12) | 1 PCSS
Abel, One  (LT) | 1 | [NAME], Babe * (P)  (LT) | 1 | Namath, [NAME]* | 1 | [NAME], [NAME] | 1 | Cumberbatch, [NAME] | 1
[NAME], Two (KL) | 1 | Berra, [NAME] (PCSS) (KL) | 1 | [NAME], [NAME] (PCSS)(TG) | 0.8 | [NAME], [NAME] | 1 | [NAME], [NAME] | 1
 |  | [NAME], [NAME] (PCSS) (LT) | 1 | Landry, Tom^ | 0.8 | Brooks, Victor | 1
 |  | [NAME], [NAME] * | 1 | [NAME], [NAME] | 0.3 | Carin, Victor | 1
Caseload: | 2 | Caseload: | 4 | Caseload: | 2.9 | Caseload: | 4 | Caseload: | 2
Spreadsheet: 2b029807-92e6-40f1-8bb3-e4b302a67b09
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2014-01-01 00:00:00 | 432 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2014
Spreadsheet: 274723d1383206663-mapping-data-to-different-spreadsheets-amanda_reply-2
Sheet: Funded

Funded
Current Status | Date | Last Name | Lender Name | Type of Loan | [NAME] | Purpose | Prop Type | Title Company | Loan Officer | Loan Amount | Processor | Notes |  | Match (All data Row)
Spreadsheet: 78613d1278974300-modifying-a-multiple-header-contact-list-to-standardize-data-columns-singleheader
Sheet: Sheet1

Last Name: | First Name: | MI: | Family Suffix: | 1st Designation | 2nd Designation | Address: |  | City: | State/Province: | Zip/Postal Code: | Country: | E-mail: | Phone:
Jones | [NAME] | A. | Jr. | LUTCF | CLTC | [NAME] | 555 [NAME] | Woodland Hills | CA | 91367 | United States | [EMAIL] | [PHONE]
Adams | [NAME] | A. |  |  |  | Adams Company | 111 Civic Dr. | Visalia | CA | 93291 | United States | [EMAIL] | [PHONE]
Smith | [NAME] | B. |  | CLU | ChFC | Smith Associates | 222 Main St. | Mountain View | CA | 94043 | United States | [EMAIL] | [PHONE]
Jones | [NAME] | S. |  | CLU |  | Jones Company | 333 World Dr. | Fallbrook | CA | 92028 | United States | [EMAIL]
Adams | Greg | R. |  |  |  | [NAME] | PO Box 99999 | Diamond Bar | CA | 91765 5739 | United States | [EMAIL] | [PHONE]
Smith | [NAME] |  |  |  |  | Paul Smith Co. | 333 Big St. | Claremont | CA | 91711 | United States | [EMAIL] | [PHONE]
Spreadsheet: c2eadff1-0a88-4c79-9e5b-0091afef9a51
Sheet: Sheet1

TOTALS:
Report only one row per stop location/time when one or more illegal pass(es) occurrred. | Time of Day (enter "X"  in AM, Mid-Day, or PM--only enter one per row) |  |  | # [NAME] at this Stop Location and Time | Passed From (enter "X" in Front, Rear, or both, as applicable ) |  | Side of Bus (enter "X" in Left, Right, or both, as applicable)
 | AM | Mid-Day | PM |  | Front | Rear | Left | Right
Spreadsheet: 97559d1296696142-insert-a-column-while-not-changing-formula-pricebook
Sheet: Sheet1

Item | Size | Average cost | Price/Unit | 2011-01-24 00:00:00 | 2011-01-17 00:00:00
Angelsoft TP | 4 pk Reg |  |  | 1
Apples | Per lb |  |  | 1.99
Bananas | Per lb |  |  | 0.54
Birdseye Steamed Veggies | 12 oz |  |  | 1
Blue Diamond Almonds Easy Pour | 8 oz |  |  | 3.99
Dannon  Danonino (1.76 oz) | 6 pk |  |  | 1.88
[NAME] (jar) | 24.5 oz |  |  | 2.55
[NAME] (0.75 oz) | 6 pk |  |  | 2.85
Duracell AAA | 4 pk. |  |  | 3.5
Fancy Feast (3 oz) | 24 pk |  |  |  | 10.99
Hillshire Farms Link Sausage | 14 oz |  |  | 3
[NAME] | 1 lb. |  |  | 2.5
Kellogs Crunchy Nut | 14.1 oz |  |  | 2.49
Kraft Mac n' Cheese Shapes | 5.5 oz |  |  | 1
Kraft Shredded Cheese | 8 oz |  |  | 3.49
Old El Paso Enchilada Sauce | 10 oz |  |  | 1
Pillsbury [NAME] | 16.3 oz |  |  | 2.29
[NAME] | 5 lb. |  |  | 0.99
Pringles Super Stack | 6.38 oz |  |  | 1.5
Progresso Soup | 18.5 oz |  |  |  | 1.11
Ragu Spaghetti Sauce | 26 oz |  |  | 0.99
Ruffles | 9.5 oz |  |  |  | 3.99
[NAME] | 8 pk. |  |  | 4.77
Startkist Tuna |  |  |  |  | 0.59
[NAME] | 15 oz |  |  | 1
Spreadsheet: 456057d1460625796-autofill-words-text-in-different-cells-in-a-text-based-document-in-excel-client-info
Sheet: Document 1

[NAME]
Company Name | Arnold Inc.
Security System | Mitel CCTV
Anrnold company blalbllsablalbalab
ablalqallablabl | ablalqallablabl |  | ablalqallablabl | ablalqallablabl
ablalqallablabl | ablalqallablabl |  | ablalqallablabl
ablalqallablabl | ablalqallablabl | ablalqallablabl | ablalqallablabl
ablalqallablabl | ablalqallablabl | ablalqallablabl | ablalqallablabl | ablalqallablabl
ablalqallablabl | ablalqallablabl | ablalqallablabl
Spreadsheet: 860779d1708772923-how-can-we-bring-max-and-second-max-values-to-mixed-table-on-different-sheet-example-data-v4-ans
Sheet: mixed product list

 | Product Code | maximum order receiving quantity value | second maximum order receiving quantity value
 | a126
 | a128
 | a129
 | a124
 | a125
 | a123
 | a127
 | a130
 | a123
 | a124
 | a125
 | a123
 | a127
Spreadsheet: 159602d1338771858-excel-2007-top-ten-and-adjacent-cell-sum-book2
Sheet: Sheet1

 | total points | 45 |  | 50 |  | 50 |  | 45 |  | 25 |  | 45 |  | 45 |  | 50 |  | 60 |  | 45 |  | 35 |  | 55
student |  |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | %
mark |  | 25 |  | 35 |  | 45 |  | 45 |  | 20 |  | 35 |  | 45 |  | 20 |  | 35 |  | 40 |  | 30 |  | 25
 |  | I NEED EXCEL TO TELL ME WHICH PERCENTAGES ARE THE TOP 8 AND THEN RETURN THE SUM OF THE CELL NEXT TO THE PERCENTAGE.
 |  | I USED THE CONDITIONAL FORMATTING TO HIGHLIGHT BUT  I DON’T KNOW  WHAT FORMULA TO USE WITHOUT DOING MANUALLY.
Spreadsheet: 42405d1240989657-matrix-help-risk-assesment-matrix
Sheet: MATRIX

 |  |  |  |  |  |  |  | LIKELIHOOD
 |  | Incidents or Accidents shall be categorised for both Actual and Potential Impact. Potential assessment should be the outcome that an experienced mariner would reasonably expect to happen if circumstances had been different. It is not the "Worst Case Scenario". |  |  |  |  |  | Could happen, but unforseeable that this will occur | Could happen, but only rarely | Could happen occasionally | Could happen frquently | Will happen, it is unlikely this will NOT occur
 |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4
 |  | People |  | Environmental Impact | Value ‡ |  |  | Rare | Unlikely | Possible | Likely | Almost Certain
 | SEVERITY | 4-20 Fatalities (or Permanent Partial Disability) |  | Loss of Containment  &  Loss Overboard - Hydrocarbon or Noxious Liquid > 1000 Litres | Major Damage greater than A$100,000 | A | Major | MEDIUM | MEDIUM | HIGH | HIGH | HIGH
 |  | 1-3 Fatalities (or Permanent Partial Disability) |  | Loss of Containment  & Loss  Overboard of Hydrocarbon or Noxious Liquid >200 Litres < 1000 litres | Very Serious Damage A$50,000 to A$100,000 | B | Very Serious | LOW | MEDIUM | HIGH | HIGH | HIGH
 |  | Major Injury/illness,  Permanent Partial Disability  or  LTI  4days or more |  | Loss of Containment  & Loss Overboard of Hydrocarbon or Noxious Liquid >79 Litres <200 Litres # [NAME] or Release of Ozone Depleting Substance. | Serious damage A$A$5,000 to A$50,000 | C | Serious | LOW | MEDIUM | HIGH | HIGH | HIGH
 |  | Minor Injury/illness Requiring Medical Treatment  or Restricted Work  or LTI  less than 4 days. |  | Loss of Containment  & Loss Overborad of Hydrocarbon or Noxious Liquid >10 litres < 78 Litres | Significant damage A$1,000 to A$5,000 | D | Significant | LOW | LOW | MEDIUM | MEDIUM | MEDIUM
 |  | Slight Injury / Illness or First Aid Case not affecting work performance. |  | Loss of Containment  & Loss Overboard of Hydrocarbon or Noxious Liquid > 1 Litre < 10 litres | [NAME] <A$1,000 | E | Slight | LOW | LOW | LOW | LOW | MEDIUM
 |  | No Injury |  | Loss of Containment of Hydrocarbon or Noxious Liquid, BUT NO Loss Overboard | No Damage | F | No Impact | LOW | LOW | LOW | LOW | LOW
 | ‡ Damage to Ship  and/or her equipment or Third Party Property. |  |  |  | # Loss of Ozone Depleting Substances means controlled substances defined in  paragraph 4 of article 1 of the Montreal Protocol on Substances that Deplete the Ozone Layer, 1987, listed in Annexes  A, B, C or E to the Protocal in force at the time of application of this annex. A list of Ozone Depleting Substances that may be found in ships is given in GO OFFSHORE GSM-04 Section 21.10
 | Risk Assessment
 | HIGH - DO NOT PROCEED WITH WORK until risk has been reduced to medium or low. If Risk Reduction cannot be achieved contact GO OFFSHORE.
 | MEDIUM - Specific monitoring or procedures required. Supervision responsibility MUST be defined. Observe all GO OFFSHORE  - GO HOME SAFE RULES,
 | LOW - Work may proceed - Manage through routine procedures. OBSERVE ALL GO OFFSHORE  - GO HOME SAFE RULES.
Spreadsheet: 753533d1635500288-search-column-find-others-with-same-value-and-output-cell-to-the-left-in-a-list-excel-problem123
Sheet: needed

ID | Group | Output
1 | Apple | 5, 8
2 | Orange | 4, 6, 10
3 | Pear | 7, 9
4 | Orange | 2, 6, 10
5 | Apple | 1, 8
6 | Orange | 2, 4, 10
7 | Pear | 3, 9
8 | Apple | 1, 5
9 | Pear | 3, 7
10 | Orange | 2, 4, 6
Spreadsheet: 036b3e7e-f9f7-4abf-992d-ad3f0cdea135
Sheet: CDS-E

E. ACADEMIC OFFERINGS AND POLICIES
E1 | Special study options: Identify those programs available at your institution. Refer to the glossary for definitions.
E1 | Accelerated program | x
E1 | Cooperative education program | x
E1 | Cross-registration
E1 | Distance learning | x
E1 | Double major | x
E1 | Dual enrollment | x
E1 | English as a Second Language (ESL) | x
E1 | Exchange student program (domestic)
E1 | External degree program | x
E1 | Honors Program | x
E1 | Independent study | x
E1 | Internships | x
E1 | Liberal arts/career combination | x
E1 | Student-designed major | x
E1 | Study abroad | x
E1 | Teacher certification program | x
E1 | Weekend college
E1 | Other (specify):
E2 | This question has been removed from the Common Data Set.
E3 | Areas in which all or most students are required to complete some course work prior to graduation:
E3 | Arts/fine arts | x
E3 | Computer literacy
E3 | English (including composition) | x
E3 | Foreign languages
E3 | History | x
E3 | Humanities | x
E3 | Mathematics | x
E3 | Philosophy
E3 | Sciences (biological or physical) | x
E3 | Social science | x
E3 | Other (describe):
 | Library Collections: The CDS Publishers will collect library data again when a new Academic Libraries Survey is in place.
Spreadsheet: 726163d1617091222-index-match-and-outstanding-receivable-days-debtor-age-analysis-2
Sheet: Age Analysis

I'm kindly asking for a formula for matching columns A to F  and calculating outstanding payment days
Customer Code | Customer Name | Invoice Date | Invoice | Invoice Amount | Amount Received | Outstanding Balance | Days Outstanding | Not yet Due | 1- 30 days | 31 - 60 Days | 61-90 Days | >90 Days
CT 002 | [NAME] | Opening Balance | C002 | 1750 | 1000
CT 002 | [NAME] | 2121-02-01 00:00:00 | C006 | 1200 | 1100 | 0
CT 002 | [NAME] | 2121-02-20 00:00:00 | C007 | 4000 | 0 |  |  |  |  | 37
CT 214 | THOKOZANI SIBANDA | Opening Balance | C003 | 1500 | 400
CT 214 | THOKOZANI SIBANDA | 2121-02-01 00:00:00 | C005 | 2000 | 0 |  |  |  |  | 43
CT 214 | THOKOZANI SIBANDA | 2021-02-15 00:00:00 | C008 | 500 | 0 |  |  |  |  | 42
H6: =IF($G6=0,"",IF(COUNT($C6)=0,"Previous Year",TODAY()-$C6-VLOOKUP($D6,TXs!$G:$I,3,0)))
Spreadsheet: 863800d1711195626-column-mont-and-year-excel-help
Sheet: Sheet1

 |  |  | *Key in date here
 | Project Name | Profit Value | Expecting  Close | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
 | Sales project AA | 500000 | 2025-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
 | Sales Project AB | 25800 | 2024-06-04 00:00:00 |  |  |  |  |  | 25800
 | Sales Project CC | 450000
 | Sales Project DD | 30000
Spreadsheet: 160165d1338994297-excel-2007-a-formula-calculates-a-cycle-open-and-close-same-day-an-extension-needed-different-day-the-case1
Sheet: The case

 | 2012-05-01 00:00:00
 | Date | Ascending Numbering | Direction | Amount  € | In | Out | Costs   € | P/L   €
 |  | 1 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 2 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 3 | ã | 100003 | 1.31
 |  | 3 |  |  |  | 1.25 | 100
Spreadsheet: 816904d1675879999-extract-multiple-text-fields-from-strings-of-various-lengths-s666-pq-extract-multiple-text-fields-from-strings-of-various-lengths
Sheet: Sheet2

TBD | TBTD | TAD.1 | TAD.2 | TAD.3 | TAD.4
DCC E01MJLL | IBM Rational Application Developer for WebSphere Software Authorized User Annual SW Subscription & Support Renewal | 777 | 11/1/2022 | 10/31/2023 | $144.44
DCC E01MKLL | IBM Rational Application Developer for WebSphere Software Floating User Single Install Annual SW Subscription & Support Renewal | 2 | 11/1/2022 | 10/31/2023 | $337.55
DCC E020VLL | IBM Optim High Performance Unload for Db2 Processor Value Unit (PVU) Annual SW Subscription & Support Renewal | 3,650 | 11/1/2022 | 10/31/2023 | $4.33
ACME E029TLL | IBM Business Monitor Processor Value Unit (PVU) Annual SW Subscription & Support Renewal | 590 | 11/1/2022 | 10/31/2023 | $62.08
ACME E02K5LL | IBM Db2 Connect Enterprise Edition 25 Authorized User Annual SW Subscription & Support Renewal | 9 | 11/1/2022 | 10/31/2023 | $176.54