tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53743d1253656792-automatically-update-another-cell-700416-automatically-update-another-cell
Sheet: Sheet1

 | Status |  | cancellation date
 | Cancelled |  | 2009-09-23 00:00:00
 | Live
 | Live
 | Live
 | Live
 | Cancelled |  | 2009-09-23 00:00:00
 | Live
 | Cancelled
 | Live
 | Live
 | Live |  | 2009-09-23 00:00:00
 | Live
 | Live
 | Live
 | Live
Spreadsheet: 54392d1254369507-designing-template-for-scatter-graphs-test
Sheet: Sheet1

type | x | y |  | A | A | B | B | C | C
A | 2 | 4
A | 1 | 4
A | 5 | 6
A | 7 | 8
C | 9 | 2
C | 1 | 7
 |  |  |  |  |  |  |  |  | A | A | B | B | C | C
 |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  | 1 | 4
 |  |  |  |  |  |  |  |  | 5 | 6
 |  |  |  |  |  |  |  |  | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7
Spreadsheet: 275052d1383318863-having-trouble-using-matching-vlookup-between-sheets-rip-times
Sheet: Sheet2

Thickness | Feedrate (Inches per min) |  |  | Feedrate (Inches per sec.) |  |  | Length in Inches |  |  | Time in Min. |  |  | Time in Hrs.
0.1875 | 250
0.25 | 225
0.3125 | 190
0.375 | 142
0.5 | 119
0.625 | 95
0.75 | 74
0.875 | 64
1 | 15
1.25 | 29
1.375 | 20
1.5 | 11
1.52 | 11
1.75 | 10
1.875 | 10
2 | 10
2.25 | 9
2.5 | 9
2.75 | 8
3 | 8
3.25 | 7
3.45 | 7
3.5 | 7
3.75 | 7
3.98 | 6
4 | 6
4.25 | 6
4.5 | 6
5.25 | 5
Spreadsheet: 866028d1712955536-adding-year-to-date-data-based-on-selected-month-test-file
Sheet: Sheet1

Performance dashboard - Actual vs. Budget |  |  |  |  |  |  |  |  |  |  |  |  | March
 | January |  |  | February |  |  | 2024-03-01 00:00:00 |  |  | 2024-04-01 00:00:00 |  |  | 2024-05-01 00:00:00 |  |  | 2024-06-01 00:00:00
 | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget |  | Actual | Budget | % | Actual | Budget | %
Sales
A | 3 | 5 |  | 8 | 6 |  | 7
B | 4 | 6 |  | 6 | 8 |  | 6
C | 7 | 3 |  | 7 | 5 |  | 13
D | 4 | 4 |  | 6 | 6 |  | 12
E | 2 | 7 |  | 3 | 4 |  | 17
Total
Spreadsheet: 846137d1697450666-the-figures-auto-insert-row-as-the-attachment-file-chi-tiet-hoa-don
Sheet: RESULT

 | STT | SIGN | INVOICE NO | VAT INVOICE NO | DATE INVOICE | THE CUSTOMER NAME | TAX CODE | DECRIPTION | DV | AMOUNT | THE PRICE
Spreadsheet: 23d1f743-8bea-4080-bead-502ad11a8725
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Tahlequah, OK
Payment [NAME]
Fiscal Year 2006
Check | Payment | Trip |  | Destination | Purpose | Mileage | Airfare | Lodging | Per Diem | Other | Total
No. | Date | Date |  |  |  | & Auto |  |  | & Meals
41329 | 2005-09-28 00:00:00 | 2005-10-05 00:00:00 | 2005-10-07 00:00:00 | Thackerville, Oklahoma | Five Civilized Tribes Qrtly Meeting | 243.08 |  | 120 | 77.5 |  | 440.58
53826 | 2006-01-18 00:00:00 | 2006-01-19 00:00:00 | 2006-01-20 00:00:00 | Durant, Oklahoma | Five Trives Inter Tribal Qrtly Meeting | 243.08 | 0 | 58.59 | 58.5 | 0 | 360.17
64583 | 2006-04-13 00:00:00 | 2006-04-20 00:00:00 | 2006-04-21 00:00:00 | Midwest City, Oklahoma | Five Trives Inter Tribal Qrtly Meeting | 116.3 |  | 86.86 | 73.5 |  | 276.66
71140 | 2006-06-14 00:00:00 | 2006-06-17 00:00:00 | 2006-06-22 00:00:00 | Saulte [NAME]. [NAME], Michigan | National Congress of American Indians Mid Year Conference | 1024.58 |  | 378.28 | 214.5 |  | 1617.36
 |  |  |  |  | TOTAL as of Sept. 30, 2006 | 1627.04 | 0 | 643.73 | 424 | 0 | 2694.77
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -98383 | -75000
2 | -98232 | -95000
3 | -47152 | -38250
4 | -5 | -5000
5 | -31
6 | 0
7 | -3
8
9
10
11
12 | -91
13 | -262
14 | -50241 | -34991
15 | -73751 | -59903
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | -173605
2001-09-15 00:00:00
CBS Volume
 |  |  | -86184
Spreadsheet: c9ef541f-c4e4-44eb-b67d-aae605709f41
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
LCWNV | Test | LCWNV | West Nile Virus, Molecular Detection, PCR | West Nile Virus PCR | Real-Time Polymerase Chain Reaction (PCR)/RNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Plain, Red-Top Tube: Red OR Sterile transport container: StlTrans OR |  |  | 0.8 | mL | Container/Tube: Sterile vial [NAME]: 0.8 mL Collection Instructions: Do not centrifuge.  Additional Information: The high sensitivity of amplification by PCR requires the specimen to be processed in an environment in which contamination of the specimen by West Nile virus DNA is not likely. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Not applicable | Monday through Saturday; Continuously 7 a.m.-8 p.m. (June through November) Mond | Monday through Thursday: 2 days Friday, Saturday: 3 days | 5 days | 1 | 87798 |  |  |  |  | Rochester
LCWNV | [NAME] | CSF | CSF |  |  |  | Refrigerated | 7 days
LCWNV | Result | SS013 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
LCWNV | Result | 86197 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34892-0 | West Nile virus RNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
LCWNV | Result | 24292 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
LCWNV | Result | 24293 | Report Status | Report Status | Alphanumeric
Spreadsheet: 750940d1633731412-finding-cost-per-month-with-multiple-date-ranges-and-variable-costs-gooutside-monthly-totals
Sheet: Sheet11

A | B | C | D | E
1 | Billing Start Date | Billing End Date | [NAME] | Days Between | Daily Amount |  | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00
2 | 2016-11-10 00:00:00 | 2016-11-14 00:00:00 | 20.75 | 4d | 5.19
3 | 2016-11-15 00:00:00 | 2016-12-14 00:00:00 | 109.88 | 29d | 3.79
4 | 2016-12-15 00:00:00 | 2017-01-13 00:00:00 | 151.71 | 29d | 5.23
5 | 2017-01-14 00:00:00 | 2017-02-14 00:00:00 | 146.31 | 31d | 4.72
6 | 2017-02-15 00:00:00 | 2017-03-16 00:00:00 | 136.54 | 29d | 4.71
A | B
1 | 2016-11-01 00:00:00
2 | 2016-12-01 00:00:00
3 | 2017-01-01 00:00:00
4 | 2017-02-01 00:00:00
5 | 2017-03-01 00:00:00
Spreadsheet: 264bbea0-c1da-41c7-82d7-5598219da7cd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8584 | 12512 | [NAME] | Bixenstine | USA | 183 | 01:11:30 | 00:01:29 | 01:27:38 | 00:02:44 | 00:38:34 | 1 | 03:21:53
8584 | 12233 | [NAME] | Leovic | AUS | 184 | 01:24:08 | 00:01:34 | 02:19:02 | 00:02:59 | [NAME] | 2 | 04:32:59
Spreadsheet: 0228cd57-2075-45bf-a9b6-5b7fd9d07203
Sheet: 9X

 | Vehicles with capital values greater than $75K will receive a unique rate; please contact FSR for details
 |  |  | Equipment |  |  | 2013 Monthly | 2013 Mileage
 | Class | Description | Code | SIN | Weight | Rate | Rate
 | 90 | Truck, [NAME]  5-10 Tons Towing | 9007 |  | 20,000 GVWR | 663 | 0.61
 | 90 | Truck, Wrecker 10-15 Tons Towing | 9008 |  | 30,000 [NAME] | 789 | 0.68
 | 90 | Truck, Wrecker 15-20 Tons Towing | 9009 |  | 40,000 GVWR | 944 | 0.71
 | 90 | Truck, Fuel Servicing Ground 2,000 gal. [NAME]. w/p | 9034 | 961C |  | 1027 | 0.44
 | 90 | Truck, Fuel Servicing Ground 2,000 gal. Dual Compt. w/2 p | 9038 | 962A |  | 1150 | 0.395
 | 90 | Truck, Fuel Servicing Ground 3,000 gal. Dual Compt. w/2 p | 9040 | 962B |  | 1578 | 0.31
 | 92 | Semi-Trailer: Low Bed, Multiple Axles | 9205 |  | 50,000  GVWR | 286 | 0
 | 92 | Semi-Trailer: Low Bed, Multiple Axles | 9209 |  | 100,000  GVWR | 340 | 0
 | 92 | Semi-Trailer: S & P, Multiple Axles | 9218 |  | 40,000  GVWR | 255 | 0
 | 92 | Semi-Trailer: Van, [NAME] | 9221 |  | 20,000  GVWR | 212 | 0
 | 92 | Semi-Trailer: Van, Multiple Axles | 9223 |  | 40,000  GVWR | 260 | 0
 | 92 | [NAME]: Refrig, Single Axle | 9226 |  | 20,000  GVWR | 351 | 0
 | 92 | [NAME]: Refrig, Multiple Axles | 9228 |  | 40,000  GVWR | 506 | 0
Spreadsheet: 89843d1289572008-chart-add-series-dynamically-no-macro-752998
Sheet: Foglio1

 |  |  | 2005 | 2006 | 2007 | 2008 |  |  |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  | gen | 19 | 1 | 81 | 9 |  |  |  | gen | 19 | 1 | 81 | 9 |  |  | 12
 |  | feb | 53 | 60 | 27 | 84 |  |  |  | feb | 53 | 60 | 27 | 84 |  |  | 12
 |  | [NAME] | 38 | 91 | 26 | 47 |  |  |  | [NAME] | 38 | 91 | 26 | 47 |  |  | 4
 |  | apr | 20 | 52 | 92 | 9 |  |  |  | apr | 20 | 52 | 92 | 9 |  |  | 6
 |  | mag | 29 | 70 | 79 | 46 |  |  |  | mag | 29 | 70 | 79 | 46 |  |  | 56
 |  | [NAME] | 69 | 14 | 10 | 98 |  |  |  | [NAME] | 69 | 14 | 10 | 98 |  |  | 56
 |  | lug | 91 | 92 | 73 | 56 |  |  |  | lug | 91 | 92 | 73 | 56 |  |  | 34
 |  | ago | 33 | 57 | 22 | 95 |  |  |  | ago | 33 | 57 | 22 | 95 |  |  | 34
 |  | set | 9 | 16 | 49 | 93 |  |  |  | set | 9 | 16 | 49 | 93 |  |  | 34
 |  | ott | 16 | 90 | 40 | 37 |  |  |  | ott | 16 | 90 | 40 | 37 |  |  | 54
 |  | nov | 63 | 50 | 89 | 66 |  |  |  | nov | 63 | 50 | 89 | 66 |  |  | 46
 |  | dic | 46 | 100 | 72 | 81 |  |  |  | dic | 46 | 100 | 72 | 81 |  |  | 45
Spreadsheet: john_griffith__16068__1_16_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL G2 | 18.5 | 35 | 55 | 94.5 | 107.1 | 1.2 | 2002-01-15 14:52:00
 | CL H2 | 19 | 230 | 240 | 54 | 56.4 | 0.66 | 2002-01-16 10:54:00
 | CL J2 | 19.5 | 315 | 330 | 51.2 | 53.6 | 0.64 | 2002-01-16 10:54:00
 | CL K2 | 19.5 | 390 | 400 | 50.8 | 52.1 | 0.63 | 2002-01-16 10:54:00
 | CL M2 | 20 | 430 | 435 | 47.8 | 48.3 | 0.6 | 2002-01-16 10:54:00
 | CL N2 | 20 | 465 | 480 | 46.1 | 47.6 | 0.59 | 2002-01-16 10:54:00
 | CL Q2 | 20 | 475 | 490 | 43.2 | 44.6 | 0.55 | 2002-01-16 10:54:00
 | CL U2 | 20 | 490 | 505 | 41.6 | 42.8 | 0.53 | 2002-01-16 10:54:00
 | [NAME] | 20 | 495 | 515 | 39.2 | 40.8 | 0.5 | 2002-01-16 10:54:00
 | CL X2 | 20 | 500 | 520 | 37.5 | 39 | 0.48 | 2002-01-16 10:54:00
 | [NAME] | 20 | 505 | 525 | 36.2 | 37.6 | 0.46 | 2002-01-16 10:54:00
 | CL F3 | 20 | 505 | 530 | 34.6 | 36.3 | 0.45 | 2002-01-16 10:54:00
 | CL M3 | 20 | 505 | 540 | 29.4 | 31.4 | 0.38 | 2002-01-16 10:54:00
 | CL Z3 | 20.5 | 515 | 535 | 25.5 | 26.6 | 0.34 | 2002-01-16 10:54:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 593027d1538897433-delete-the-duplicate-and-keep-the-latest-one-book1123455
Sheet: Sheet1

 |  | Emp NO. | Month | year |  | Emp NO. | Month | year |  | Emp NO. | Month | year
 |  | 123 | 7 | 2018
 |  | 123 | 9 | 2018
 |  | 123 | 8 | 2016
 |  | 124 | 1 | 2018
 |  | 124 | 2 | 2018
 |  | 124 | 3 | 2016
Spreadsheet: 770813d1646275876-sub-total-on-horizontal-forum2
Sheet: Sheet1

 |  |  |  | id | sold | total sold of an id
 |  |  |  | 1 | 2.4 | 2.4
 |  |  |  | 2 | 3.2 | 3.2
 |  |  |  | 3 | 4.2 | 4.2
 |  |  |  | 4 | 2.5 | 6
 |  |  |  | 4 | 3.5 | 6
 |  |  |  | 5 | 6 | 6
 |  |  |  | 6 | 0.04 | 0.04
 |  |  |  | 7 | 0.02 | 2.62
 |  |  |  | 7 | 2.2 | 2.62
 |  |  |  | 7 | 0.4 | 2.62
 |  |  |  | 8 | 5 | 5
 |  |  |  | 9 | 2.4 | 5.1
 |  |  |  | 9 | 1.6 | 5.1
 |  |  |  | 9 | 0.4 | 5.1
 |  |  |  | 9 | 0.6 | 5.1
 |  |  |  | 9 | 0.1 | 5.1
 |  |  |  | 10 | 2 | 2
Spreadsheet: 763403d1642157675-price-development-price-development-v2
Sheet: Sheet1

PN | Date | Price |  | PN |  | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00
A | 2022-01-01 00:00:00 | 30
A | 2022-11-28 00:00:00 | 15 |  | B
A | 2022-12-31 00:00:00 | 30 |  | C
B | 2022-01-01 00:00:00 | 15 |  | D
B | 2022-04-20 00:00:00 | 10 |  | E
B | 2022-10-06 00:00:00 | 7 |  | F
B | 2022-10-28 00:00:00 | 15
C | 2022-01-01 00:00:00 | 6
C | 2022-10-06 00:00:00 | 4
C | 2022-10-15 00:00:00 | 30
C | 2022-11-15 00:00:00 | 30
C | 2022-12-31 00:00:00 | 50
D | 2022-01-01 00:00:00 | 8
D | 2022-11-06 00:00:00 | 4
E | 2022-01-01 00:00:00 | 15
E | 2022-02-01 00:00:00 | 13
E | 2022-05-20 00:00:00 | 10
F | 2022-01-01 00:00:00 | 23
F | 2022-01-15 00:00:00 | 10
F | 2022-10-06 00:00:00 | 17
 |  |  |  |  | Correct Result
 |  |  |  | PN |  | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00
 |  |  |  |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 15 | 30
 |  |  |  | B | 15 | 15 | 15 | 15 | 10 | 10 | 7 | 7 | 15 | 15 | 15 | 15 | 15
 |  |  |  | C | 6 | 6 | 6 | 6 | 6 | 6 | 4 | 30 | 30 | 30 | 30 | 30 | 50
 |  |  |  | D | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 4 | 4 | 4 | 4
 |  |  |  | E | 15 | 15 | 15 | 13 | 13 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | F | 23 | 23 | 10 | 10 | 10 | 10 | 17 | 17 | 17 | 17 | 17 | 17 | 17
Spreadsheet: 766786d1644056209-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-test10
Sheet: TAB3

 | 11 | 22 | 07:00:00 | 33 | 44 | 07:00:00 | 55 | 66
What I have now
 |  |  |  | This should be 33 | This should be 44 |  | This should be 55 | This should be 66
When I drag the above 3 formulas to the right in E5 'TAB1'!B2 and 'TAB2'!A2 from B5 are not 'TAB1'!E2 + 'TAB2'!C2 but 'TAB1'!E2 + 'TAB2'!D2
Spreadsheet: 801996d1666552191-conditional-formatting-from-a-chart-to-a-table-example-excel
Sheet: Table

 | X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | X9 | X10 | X11 | X12 | X13
Y1 | Z1 | [NAME]
Y2 |  |  | Z3
Y3
Y4
Y5 |  |  |  | Z4
Y6 |  |  |  |  |  | [NAME] | Z7
Y7
[NAME]
Y9 |  |  |  |  |  |  |  | Z8
Y10
Y11
Y12 |  |  |  |  |  |  |  |  | Z9
Y13
Spreadsheet: john_griffith__16129__1_23_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 195 | 200 | 51.2 | 52.5 | 0.64 | 2002-01-23 14:47:00
 | CL J2 | 20 | 290 | 300 | 48.9 | 50.6 | 0.63 | 2002-01-23 14:47:00
 | CL K2 | 20 | 365 | 375 | 48.2 | 49.5 | 0.61 | 2002-01-23 14:47:00
 | CL M2 | 20 | 410 | 415 | 46.9 | 47.4 | 0.59 | 2002-01-23 14:47:00
 | CL N2 | 20 | 445 | 460 | 45.1 | 46.6 | 0.58 | 2002-01-23 14:47:00
 | CL Q2 | 20 | 465 | 475 | 43.1 | 44 | 0.55 | 2002-01-23 14:47:00
 | CL U2 | 20 | 475 | 490 | 40.9 | 42.2 | 0.52 | 2002-01-23 14:47:00
 | [NAME] | 20 | 480 | 495 | 38.5 | 39.7 | 0.49 | 2002-01-23 14:47:00
 | CL X2 | 20.5 | 490 | 505 | 36.2 | 37.3 | 0.47 | 2002-01-23 14:47:00
 | [NAME] | 20.5 | 495 | 505 | 34.9 | 35.7 | 0.45 | 2002-01-23 14:47:00
 | CL F3 | 20.5 | 500 | 520 | 33.7 | 35.1 | 0.44 | 2002-01-23 14:47:00
 | CL G3 | 20.5 | 505 | 525 | 32.7 | 34 | 0.43 | 2002-01-23 14:47:00
 | CL M3 | 20.5 | 525 | 535 | 30 | 30.5 | 0.39 | 2002-01-23 14:47:00
 | CL Z3 | 21 | 540 | 552 | 26.3 | 26.9 | 0.35 | 2002-01-23 14:47:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 760335d1640154711-find-duplicates-and-changes-in-column-b-from-unique-text-in-column-a-sample-data-student-and-class-list
Sheet: Sheet1

Customer ID | Class Name | Data Explanation
123456 | Saturday 11:00 Junior B1 Term 2-2021 | Student A Initial Data - Start of term | B2 was the original data from the first data extraction, B3 was pasted into this list during mid term to do data comparison to find changes for students and also to identify who is new
123456 | Sunday 12:00 Junior B1 Term 2-2021 | Student A Mid term change of class
125256 | Sunday 13:45 Junior B1 Term 2-2021 | Student B a new mid term registered student
292871 | Sunday 12:00 Junior B1 Term 2-2021 | Student C Initial Data - Start of term
292871 | Sunday 13:45 Junior B1 Term 2-2021 | Student C Mid term change of class
333545 | Sunday 13:45 Junior B1 Term 2-2021 | Student D Initial Data - Start of term | I want to know if each person has had changes in their class name more easily rather than looking at the top and bottom row of their old and new data to see if they made changes a class will have up to 20 people in it. There will always be a duplicate student ID and Class name in the data after pasting two different data together in one sheet.
333545 | Sunday 12:00 Junior B1 Term 2-2021 | Student D Mid term change of class
565543 | Saturday 11:00 Junior B1 Term 2-2021 | Student E Initial Data - Start of term
565543 | Saturday 11:00 Junior B1 Term 2-2021 | Student E NO CHANGES IN CLASS BOOKING
654321 | Monday 16:30 Senior [NAME] 2-2021 | Student F Initial Data - Start of term
654321 | Monday 16:30 Senior [NAME] 2-2021 | Student F who did not make any changes
Spreadsheet: 704834d1605770657-calculating-total-using-if-and-vlookup-chemical-inventory-control
Sheet: Stock Levels

 | Chemical Stock Levels
 | Product | Unit | Stock Levels | Stock Remaining
 | Product 1 | Lt | 17
 | Product 2 | Lt | 420
 | Product 3 | Lt | 82
 | Product 4 | Lt | 21
 | Product 5 | Lt | 94
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 25

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
-11 | سرمايه گذاريهای بلندمدت
 | سرمايه گذاريهای بلندمدت شامل موارد زيراست:
 |  |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ريال |  | ريال
سپرده های سرمايه گذاری بلندمدت |  |  |  | 11-1
سرمايه گذاريها درسهام شرکتها |  |  |  | 11-2
11-1 | سپرده های سرمايه گذاری بلندمدت بانکی درتاريخ ترازنامه به شرح زيرتفکيک می گردد:
 |  |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ريال |  | ريال
بانک ملت ملک الشعرا |  |  |  | 11-1-1 |  | 600000000 |  | 600000000
[NAME] جم |  |  |  | 11-1-1 |  | 120000000 |  | 120000000
بانک پاسارگاد سلیمان خاطر |  |  |  |  |  | 2899500000 |  | 1275000000
-11-1-1 | نرخ سود تضمين شده سپرده های فوق برای سال جاری براساس قانون [NAME] ربا به ميزان 17درصد [NAME] .
مبلغ 715،009،234ريال ازسپرده های ياد شده به منظورصدورضمانت نامه های بانکی به نفع کارفرمايان وثيقه [NAME].
11-2 | سرمايه گذاری درسهام [NAME] باشد:
 |  | 1390 |  |  |  |  | 1389/09/30
 |  | تعدادسهام | درصدسرمايه گذاری | [NAME] | بهای تمام شده |  | بهای تمام شده
 |  |  |  | ريال | ريال |  | ريال
[NAME] های [NAME] |  | 2 | 0.002 | 500000 |  |  | 1000000
[NAME] اتکائی ایرانیان |  | 1750000 | 0.23 | 1000 |  |  | 1750000000
[NAME] شرکتهای [NAME] |  | 5000 | 0 | 1000 |  |  | 5000000
شرکت ساخت و نصب صنایع بتنی و فلزی |  | 10000 | 100 | 1000 |  |  | 10000000
[NAME] |  | 1100000 |  | 1000 |  |  | 400000000
[NAME]
-11-2-1 | باتوجه به [NAME] دائمی درارزش  سرمايه گذاری [NAME] ای منظورنگرديده است.
Spreadsheet: lynn_blair__24414__NNGWKednotes
Sheet: July 4, 2001 Holiday

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
Wednesday |  |  | 2001-07-04 00:00:00
Mail distribution send to the above listing on Wednesday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | WED |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | WED |  |  | Extended time line to 8:25am to put UCU's nom in.
 | 8:00 AM Final Storage |  |  |  | There system was down.  ([NAME])
 | Gas Day: | WED |  |  | Storage Allocation Hung up.  [NAME] fixed  ([NAME])
 | 10:00 A.M. Intraday 1:
 | Gas Day: | WED |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | WED |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | WED |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | NBPL had problems transmitting EDI files to NNG, [NAME] had to
 |  |  |  |  | manually confirm during timely process for 7/5 and ID1 for 7/4.
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 792978d1661249461-trigger-payment-date-payment-date
Sheet: Sheet1

 |  |  |  | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | Payment Date
 |  |  | Case 1 |  |  |  | 5 | 5 | 5 | 5 | 5
 |  |  | Case 2 | 7 | 7
 |  |  | Case 3 |  |  |  |  |  |  |  |  |  |  | 9 | 9 | 9 | 9
Spreadsheet: 882257d1730536983-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-source-workbook-example
Sheet: Source workbook

 | Others | Machine | ID number | Others | Others | Cyceltime
 |  | Example1 | 12345 |  |  | =[NAME] goes here
 |  | Example2 | 67891 |  |  | 40
 |  | Example3 | 65743 |  |  | 60
 |  | Example4 | 97745 |  |  | 80
 |  | I need the cyceltime "column G" to be dynamicly updated based on 3 different criteras from the "input workbook."
 |  | I need the formula put in the "Source workbook" to look for matches by the rows in a dynamic way when I pull the formula down
 |  | First the the formula needs to look for matches in the current row  for the columns "C" and "D" in the source workbook "where the acutal formula goes. That will be Column "G"
 |  | if the criterias matches from column C and D. With the acutall values by row.
 |  | The matches from this in the current formula workbook. "source workbook" needs then to return the value from column "H" cyceltime from the "input workbook"
 |  | Based on the matching criteras mentioned earlier + the latest date from the entire column "G" from the "input workbook."
Spreadsheet: 149432d1333964848-recognising-date-then-exporting-data-to-correct-location-wb
Sheet: WB2

 | This would be workbook 2
 | 1100 | 1200 | 1300 | 1400 | 1500 |  |  | 1100 | 1200 | 1300 | 1400 | 1500
2012-04-01 00:00:00 | 2 | 5 | 12 | 22 | 15
Spreadsheet: 697399d1601337998-using-index-and-match-but-omitting-some-results-report-help
Sheet: Work_load

Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
2233412 | xxx-xxxx-xxxx | complete | canceled | complete | 123 Address | 2 | [NAME] | [NAME] | Ant
2233412 | xxx-xxxx-xxxx | pending | complete | complete | 1b basemment | 1 | Ant | Ant | Ant
2233412 | xxx-xxxx-xxxx | canceled | complete | complete | 23 flower garden | 4 | [NAME] | [NAME] | Ant
2233412 | xxx-xxxx-xxxx | complete | pending | - | 12 can place | 2 | [NAME] | [NAME] | [NAME]
2233412 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | 3 | [NAME] | [NAME] | [NAME]
2233412 | xxx-xxxx-xxxx | canceled | pending | complete | 19 fake St | 4 | [NAME] | [NAME] | Ant
2233412 | xxx-xxxx-xxxx | complete | complete | complete | 20 fake St | 1 | Ant | - | Ant
2233412 | xxx-xxxx-xxxx | pending | complete | complete | 21 fake St | 4 | [NAME] | - | -
2233412 | xxx-xxxx-xxxx | canceled | complete | - | 22 fake St | 2 | [NAME] | - | [NAME]
2233412 | xxx-xxxx-xxxx | complete | canceled | - | 23 fake St | 3 | - | [NAME] | -
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 162 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 163 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 164 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 165 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 166 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 167 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 168 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 169 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 170 Grand Ave