tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1ec343dd-95d9-4b4c-8fa1-0046064f389f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-09-04 09:40:47.060000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.767 | 101.642 | 101.517 | 101.142 |  | and are added to price quote
4.75 | 101.288 | 101.163 | 101.038 | 100.663
4.625 | 100.57 | 100.445 | 100.32 | 99.945 |  | Note: | Refer To Price [NAME]
4.5 | 99.679 | 99.554 | 99.429 | 99.054 |  |  | For all Price Adjs
4.375 | 98.748 | 98.623 | 98.498 | 97.873
4.25 | 97.998 | 97.873 | 97.748 | 97.123
4.125 | 97.208 | 97.083 | 96.958 | 96.333
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.022 | 101.897 | 101.772 | 101.397
3.875 | 101.308 | 101.183 | 101.058 | 100.683
3.75 | 100.61 | 100.485 | 100.36 | 99.985
3.625 | 100.179 | 100.054 | 99.929 | 99.554
3.5 | 99.633 | 99.508 | 99.383 | 98.758
3.375 | 98.911 | 98.786 | 98.661 | 98.036
3.25 | 98.139 | 98.014 | 97.889 | 97.264 |  | Minimum loan amount:
3.125 | 97.191 | 97.066 | 96.941 | 96.316 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-09-18 09:40:47.060000
30 DAY | 2013-10-03 09:40:47.060000
45 DAY | 2013-10-18 09:40:47.060000
60 DAY | 2013-11-02 09:40:47.060000
90 DAY | 2013-12-02 09:40:47.060000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: a470443f-e63f-451a-b511-4dcb65c6b3ed
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8006 | 11333 | [NAME] | [NAME] | UKR | 8 | 00:00:00 | 00:00:00 | 00:12:52 | 00:01:10 | 00:15:26 | 1 | 00:29:30
8006 | 21871 | [NAME] | [NAME] | NZL | 10 | 00:00:00 | 00:00:00 | 00:13:15 | 00:01:19 | 00:17:23 | 2 | 00:31:58
8006 | 30058 | Andreas | Schilling | DEN | 9 | 00:00:00 | 00:00:00 | 00:13:11 | 00:01:16 | 00:18:22 | 3 | 00:32:51
Spreadsheet: 801411d1666189663-how-to-use-conditional-formatting-to-highlight-column-with-same-short-term-real-trades-4-oct-2013-study-35
Sheet: Sheet1

 |  |  |  | large b/c 2X3.. |  |  |  |  | order: t5vs..2X3 next & 0/1..all 0 like beow.3456(like t8(t9 below) than 6X3
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 7 | 6 | 6 | 8 | 8 | 11
 |  |  | all | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 8 | 6 | 6 | 9 | 9 | 12
 |  |  | [NAME]) | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 3 | 4 | 9 | 6 | 7 | 10 | 11 | 14
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 2 | 4 | 5 | 11 | 10 | 9 | 16 | 15 | 19
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 3 | 4 | 6 | 12 | 13 | 12 | 21 | 19 | 26
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 6 | 13 | 16 | 15 | 28 | 22 | 32
 |  |  |  | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 7 | 14 | 17 | 17 | 30 | 26 | 36
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 3 | 2 | 4 | 4 | 6
 |  |  | all | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 4 | 4 | 3 | 5 | 5 | 7
 |  |  | [NAME]) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 5 | 5 | 7 | 7 | 9
 |  |  | all(s/fexp) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 8 | 5 | 9 | 8 | 11
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 3 | 2 | 2 | 4 | 7 | 6 | 10 | 12 | 15 | 16 | 20
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  |  |  | EXCEL STUDY
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5
 |  |  | all | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5
 |  |  | [NAME]) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 2 | 5 | 6
 |  |  | all(s/fexp) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 4 | 7 | 8
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 7 | 9 | 5 | 8 | 11 | 13
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18
 |  |  |  | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18
Spreadsheet: andy_zipper__533__11_28_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 |  |  |  |  |  |  | 2001-11-26 14:40:00
 | NG F2 | 290 | 58 | 60 | 91 | 94.1 | 16.87 | 2001-11-28 10:06:00
 | NG G2 | 295 | 80 | 82 | 84.1 | 86.2 | 15.79 | 2001-11-28 10:06:00
 | NG H2 | 290 | 84 | 86 | 74.7 | 76.5 | 13.78 | 2001-11-28 10:06:00
 | NG J2 | 285 | 75 | 79 | 59.3 | 62.5 | 10.91 | 2001-11-28 10:06:00
 | NG K2 | 290 | 78 | 82 | 54.1 | 56.9 | 10.12 | 2001-11-28 10:06:00
 | NG M2 | 295 | 85 | 89 | 52.7 | 55.2 | 10.01 | 2001-11-28 10:06:00
 | NG N2 | 295 | 92 | 96 | 53.3 | 55.6 | 10.1 | 2001-11-28 10:06:00
 | NG Q2 | 300 | 99 | 104 | 52.8 | 55.5 | 10.21 | 2001-11-28 10:06:00
 | NG U2 | 300 | 101 | 108 | 50.9 | 54.5 | 9.94 | 2001-11-28 10:06:00
 | NG V2 | 300 | 110 | 116 | 53 | 55.9 | 10.27 | 2001-11-28 10:06:00
 | NG X2 | 320 | 123 | 129 | 53 | 55.6 | 10.92 | 2001-11-28 10:06:00
 | [NAME] | 340 | 135 | 142 | 52.9 | 55.8 | 11.62 | 2001-11-28 10:06:00
 | NG H3 |  |  |  |  |  |  | 2001-11-19 14:44:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 732548d1621009833-calculate-and-return-decimal-value-between-range-calculate-and-return-decimal-value-between-range
Sheet: Aquarock

 |  |  |  | Enter Load | 259
 |  |  |  | Hours [NAME]. |  |  |  | Hours | 1 | 2 | 3 | 4 | 6 | 8 | 10 | 15 | 30
 |  |  |  |  |  |  |  | Mod calcs
 |  |  |  | Enter Total mods | 64
 |  |  |  |  |  |  |  | VPC | 5.7 | 4 | 2.95 | 2.33 | 1.58 | 1.19 | 0.94 | 0.6 | 0.25
Spreadsheet: 151645d1335035851-pulling-data-from-one-sheet-to-another-that-meets-certain-criteria-camp-sign-up-spreadsheet-1-
Sheet: Payment Sheet

 | Name | Total Amount Owed | Amount Paid | Amount Left
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
41
42
43
44
45
46
47
48
49
Spreadsheet: debra_perlingiere__8511__Notification Rpt 1200
Sheet: Apr 2000

 | Highlighted names = new to list since last distribution |  |  | Changes for April 2000 |  |  |  | GCP  Name Changes, Mergers, [NAME], and Acquisitions |  |  | N/C = No Change
GCP DB |  | OLD RECORD INFORMATION |  |  |  |  |  |  | NEW RECORD INFORMATION
Update |  |  |  |  |  | Type of | [NAME] of |  |  |  |  |  | System Chg Updated
Complete | COUNTERPARTY NAME | BA # | CP # | SHORTNAME |  | CHANGE | Change | COUNTERPARTY NAME | BA # | CP# | SHORTNAME | COMMENTS | Name | ERMS SN
 | Name Overlay Only
2000-04-26 00:00:00 | Petroleum Source & Systems Group, Inc. | 69348 | 2550 | PETROLEUMSOUSYS |  | NC | 1999-04-20 00:00:00 | PS Energy Group, Inc. | N/C | N/C | PSENEGRO |  | 2000-04-26 00:00:00 | 2000-04-26 00:00:00
2000-04-26 00:00:00 | Allegheny Power Service Corporation | 1885 | 47308 | ALLEGHPWRSVC |  | NC | 1999-07-16 00:00:00 | Allegheny Energy Service Corporation | N/C | N/C | ALLEGENESVC |  | 2000-04-26 00:00:00 | 2000-04-26 00:00:00
2000-04-26 00:00:00 | Societe Generale Australia Ltd. | 62662 | 62659 | SOCIETEGENAUS |  | NC | 1999-01-19 00:00:00 | SG Australia Limited | N/C | N/C | [NAME] |  | 2000-04-26 00:00:00 | 2000-04-26 00:00:00
2000-04-26 00:00:00 | Boral Energy Electricity Limited | N/A | 76161 | BORALENEELE |  | NC | 2000-02-17 00:00:00 | Origin Energy Electricity | N/C | N/C | ORIGINENEELE |  | 2000-04-26 00:00:00 | 2000-04-26 00:00:00
 | Record To be Inactivated 5/1/00 |  |  |  | Pending Inactivation Date
 | (Move contracts, deals, etc. as needed)
2000-05-02 00:00:00 | Noranda Forest Inc. | n/a | 57768 | NORANDAFOR | 2000-05-01 00:00:00 | Amalgamation | 1998-12-31 00:00:00 | Nexfor Inc. | 76981 | 76981 | NEXFOR | Have documents in hand.
2000-05-02 00:00:00 | TransCanada Power Corp. | 89562 | 47760 | TRANSCANPOWCOR | 2000-05-01 00:00:00 | Amalgamation | 1997-01-01 00:00:00 | TransCanada Energy Ltd. | 89564 | 53139 | TRANSCANENELTD | They formed a division for the power part named "TransCanada Power, a division of TransCanada Energy Ltd"
Spreadsheet: 872844d1719290732-rawdata-to-generate-graph-testrawdata_to_graph
Sheet: RawDataIO

00:00:00    %usr    %sys    %wio   %idle
00:20:00       8       6       0      86
00:40:00       5       6       0      89
01:00:00       3       6       0      90
01:20:00       4       7       0      89
01:40:00       2       6       0      92
02:00:00       2       6       0      92
02:20:00       1       6       0      93
02:40:00       2       7       0      91
03:00:01       2       6       0      92
[NAME]       3       6       0      91
03:40:00       2       6       0      92
04:00:00       2       6       0      92
04:20:00       3       8       0      89
04:40:00       3       6       0      91
05:00:00       2       6       0      92
05:20:00       2       6       0      92
05:40:00       3       6       0      91
06:00:00       2       6       0      92
06:20:00      10       8       0      82
[NAME]      12       7       0      81
07:00:01      94       6       0       0
07:20:00      94       6       0       0
07:40:00      94       6       0       0
08:00:00      94       6       0       0
08:20:00      94       6       0       0
[NAME]      94       6       0       0
[NAME]      94       6       0       0
09:20:00      94       6       0       0
Average       46       7       0      47
Spreadsheet: 78304d1278680987-filters-applied-to-creat-a-percentage-pie-chart-test
Sheet: Results

Year | Month | Day | Location | Course Title | Trainer | Q1.1 | Q1.2 | Q1.3 | Q1.4 | Q1.5 | Q1.6
2010 | Jan | 5 | Sheffield | Keystone | [NAME] | Good | Good | Good | Good | Good | Good
2010 | Jan | 5 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
2010 | May | 9 | Sheffield | Keystone | [NAME] | Poor | Poor | Poor | Poor | Poor | Poor
2010 | May | 9 | Sheffield | Keystone | [NAME] | Poor | Poor | Poor | Poor | Poor | Poor
2010 | May | 9 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent
2010 | May | 9 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average
2010 | May | 26 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average
2010 | June | 1 | Sheffield | Keystone | [NAME] | Average | Excellent | Excellent | Excellent | Excellent | Excellent
2010 | June | 1 | Sheffield | Keystone | [NAME] | Good | Good | Good | Good | Good | Good
Spreadsheet: 149321d1333841125-migrating-linked-cell-data-without-losing-calculations-excel-file
Sheet: Feeder file

 |  | Feeder file
 |  | Data value (eg., in kiloliters) | Unit converted in this file (to '000 b/d)
 | Days | Ethanol consumption | Ethanol consumption, 000 b/d
08 | 31 | 11024.43861
F | 29 | 10254.83145
M | 31 | 12626.59232
A | 30 | 12088.93712
M | 31 | 12249.46622
Spreadsheet: 339940d1408476723-using-countifs-match-index-formula-to-count-data-in-different-columns-book1
Sheet: Sheet1

 | Not Submitted | On Time |  |  | Week1 | Week2 | Week3 | Week4
Name1 |  |  |  | Name3 | On Time | On Time | On Time | On Time
[NAME] |  |  |  | Name1 | On Time | On Time | On Time | On Time
Name3 |  |  |  | Name6 | Not Submitted | Not Submitted | Not Submitted | Not Submitted
Name4 |  |  |  | Name4 | On Time | On Time | On Time | Not Submitted
Name5 |  |  |  | Name10 | On Time | On Time | Not Submitted | On Time
Name6 |  |  |  | [NAME] | On Time | Not Submitted | On Time | Not Submitted
Name7 |  |  |  | Name8 | On Time | On Time | On Time | On Time
Name8 |  |  |  | Name5 | Not Submitted | On Time | On Time | On Time
Name9 |  |  |  | Name9 | On Time | On Time | On Time | On Time
Name10 |  |  |  | Name7 | On Time | Not Submitted | On Time | On Time
Spreadsheet: 47680f6e-10e0-4b26-a604-5c88baf5805a
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-MAY | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | MAY | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 12088269 | 1343129
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 11876427 | 1319605
7 | AEA 267 | 28293632 | 2829366 | 25464294 | 2829338
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 17640612 | 1960036
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 24537024 | 2726323
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 44316963 | 4924063
12 | NORTHWEST AEA | 16359617 | 1635961 | 14723649 | 1635968
13 | GREEN HILLS AEA 13 | 16376170 | 1637617 | 14738553 | 1637617
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 13505580 | 1500582
 |  | 198768032 | 19876819 | 178891371 | 19876661
Spreadsheet: 793249d1661363787-creating-a-results-list-of-multiple-races-finn-resultaten-2022-hd
Sheet: 24 juli

 |  | Place | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd | 4e wedstrijd |  |  | place | sailnumber | points | points overall | count
 |  | 1 | 148 | 148 | 148 | 148 |  |  | 1 |  | 4 | 17
 |  | 2 | 8 | 200 | 8 | 250 |  |  | 2 | 8 | 13 | 16
 |  | 3 | 147 | 8 | 108 | 108 |  |  | 3 | 108 | 26 | 15
 |  | 4 | 19 | 250 | 47 | 140 |  |  | 4 | 250 | 28 | 14
 |  | 5 | 63 | 63 | 222 | 13 |  |  | 5 | 222 | 30 | 13
 |  | 6 | 151 | 140 | 250 | 8 |  |  | 6 | 13 | 31 | 12
 |  | 7 | 222 | 113 | 200 | 222 |  |  | 7 | 200 | 31 | 11
 |  | 8 | 13 | 147 | 63 | 200 |  |  | 8 | 63 | 35 | 10
 |  | 9 | 113 | 13 | 13 | 113 |  |  | 9 | 113 | 36 | 9
 |  | 10 | 108 | 108 | 19 | 145 |  |  | 10 | 140 | 39 | 8
 |  | 11 | 87 | 222 | 113 | 87 |  |  | 11 | 147 | 40 | 7
 |  | 12 | 1013 | 87 | 140 | 147 |  |  | 12 | 19 | 44 | 6
 |  | 13 | 145 | 151 | 87 | 151 |  |  | 13 | 151 | 46 | 5
 |  | 14 | 200 | 145 | 151 | 19 |  |  | 14 | 87 | 47 | 4
 |  | 15 | 47 | 1013 | 1013 | 1013 |  |  | 15 | 47 | 52 | 3
 |  | 16 | 250 | 19 | 145 | 47 |  |  | 16 | 145 | 53 | 2
 |  | 17 | 140 | 47 | 147 | 63 |  |  | 17 | 1013 | 57 | 1
 |  | 17
 |  | 17
Spreadsheet: e24a1c47-f3e3-43a4-8867-e3953e27eb09
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Not Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: April 17, 2014 (6:17 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 44 | 48 | 49 | 49 | 49 | 45 | 43 | 38 | 35 | 32 | 27 | 26
2009 | 24 | 29 | 31 | 32 | 34 | 37 | 38 | 36 | 30 | 33 | 26 | 24
2010 | 24 | 27 | 36 | 41 | 26 | 28 | 26 | 23 | 25 | 23 | 20 | 23
2011 | 21 | 22 | 28 | 30 | 28 | 28 | 27 | 25 | 24 | 25 | 23 | 24
2012 | 23 | 30 | 34 | 34 | 35 | 34 | 33 | 31 | 30 | 29 | 28 | 28
Spreadsheet: 708616d1607951159-finding-highest-value-across-sheets-book1
Sheet: Wk2

 |  |  |  |  |  |  |  |  |  | 122
 | 2020-11-01 00:00:00 |  |  |  |  |  |  |  |  | 541
 | 2020-11-02 00:00:00 |  |  |  |  |  |  |  |  | 380
 | 2020-11-03 00:00:00 |  |  |  |  |  |  |  |  | 269
 | 2020-11-04 00:00:00 |  |  |  |  |  |  |  |  | 674
 | 2020-11-05 00:00:00 |  |  |  |  |  |  |  |  | 865
 | 2020-11-06 00:00:00 |  |  |  |  |  |  |  |  | 207
 | 2020-11-07 00:00:00 |  |  |  |  |  |  |  |  | 959
 | 2020-11-08 00:00:00 |  |  |  |  |  |  |  |  | 284
 | 2020-11-09 00:00:00 |  |  |  |  |  |  |  |  | 259
 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  | 609
 | 2020-11-11 00:00:00 |  |  |  |  |  |  |  |  | 350
 | 2020-11-12 00:00:00 |  |  |  |  |  |  |  |  | 437
 | 2020-11-13 00:00:00 |  |  |  |  |  |  |  |  | 795
 | 2020-11-14 00:00:00 |  |  |  |  |  |  |  |  | 258
 | 2020-11-15 00:00:00 |  |  |  |  |  |  |  |  | 322
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 59
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 549
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 723
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 242
 | 2020-11-20 00:00:00 |  |  |  |  |  |  |  |  | 506
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 882
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 97
 | 2020-11-23 00:00:00 |  |  |  |  |  |  |  |  | 98
 | 2020-11-24 00:00:00 |  |  |  |  |  |  |  |  | 45
 | 2020-11-25 00:00:00 |  |  |  |  |  |  |  |  | 828
 | 2020-11-26 00:00:00 |  |  |  |  |  |  |  |  | 809
 | 2020-11-27 00:00:00 |  |  |  |  |  |  |  |  | 249
 | 2020-11-28 00:00:00 |  |  |  |  |  |  |  |  | 85
 | 2020-11-29 00:00:00 |  |  |  |  |  |  |  |  | 231
 | 2020-11-30 00:00:00
Spreadsheet: 36545d1234421338-color-changing-rows-chart
Sheet: Sheet1

Date: | 2009-02-11 00:00:00 | Time is:
Patient's Name | Facility | Unit | Room | Exam | Tech | Status | Time of call | Time Complete
[NAME] doe | many faces | 21 | 239 | cxr | me | stat | 19:00:00
Spreadsheet: 698200d1601852470-formula-to-sum-variable-ranges-based-on-headers-desens
Sheet: Sheet1

2 | C | C | C | F | F | F
3 | 1 | 1 | 2 | 3 | 4 | 1
4 | 2 | 3 | 3 | 3 | 3 | 1
5 | 4 | 4 | 4 | 4 | 5 | 1
6 | 5 | 5 | 5 | 5 | 5 | 1
7 | 6 | 6 | 6 | 8 | 6 | 7
Spreadsheet: 268940d1380896499-need-help-in-defining-the-formula-of-working-hours-and-excluding-non-working-hours-tat-management
Sheet: Holiday List

S. No. | Date | Holiday
1 | 2013-01-26 00:00:00 | Republic Day
2 | 2013-08-15 00:00:00 | Independence Day
3 | 2013-10-02 00:00:00 | [NAME]
4 | NA | NA
5 | NA | NA
6 | NA | NA
7 | NA | NA
8 | NA | NA
9 | NA | NA
10 | NA | NA
Total Holidays |  | 10
Spreadsheet: 96325d1295726085-averaging-calculation-for-excel-2003-can-i-combine-sick-days-to-worksheet-2011-tech-summary
Sheet: Compare All

TECH ID | Last Name | First Name | CSAT | [NAME] | VASP | Variance VASP | TPR | [NAME] | Completed Calls | Calls Variance | Recall % | [NAME] % | Repair Time | Variance Repair Time | Productivity | Variance Productivity
900316 | [NAME] | [NAME]
717553 | Berrospe | [NAME]
2220 | Brock | [NAME]
670844 | [NAME] | [NAME]
574517 | Cory | [NAME]
823088 | Ditore | [NAME]
506352 | Fiaccato | [NAME]
400616 | Flores | Migual
918615 | Guzman | Saul
737502 | Heineman | Russ
738294 | Knight | [NAME]
498139 | Lopez | Javier
756924 | Mazariegos | Sergio
10538 | Mendez | Hector | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
876524 | [NAME] | [NAME]
508465 | Shahov | Vlad
846022 | Simmons | Gene
506097 | [NAME] | [NAME]
613091 | Waitekus | [NAME]
TECH TEAM TOTALS:
 |  |  |  |  |  |  | YEAR TO DATE 2011
Spreadsheet: 223696d1364299798-dependent-data-validation-on-condition-data-validation-help
Sheet: INPUT

 | SUBMISSION | SCORE |  | PROCESS ADH.
 | Prompt | 1 | 1 | YES | YES
 | 24hrs Late | 0.98 | 0.98 | NO
 | 2days Late | 0.9 | 0.9
 | 3days Late | 0.85 | 0.85
 | 4days Late | 0.7 | 0.7
 | > 5days | 0.5 | 0.5
Spreadsheet: 187525d1350497466-function-that-lists-specific-rows-of-a-database-based-on-a-cell-value-excel-help
Sheet: Munka1

 |  |  |  |  | name | score |  |  | names with "1" as score | names with "2" as score | 3 | 4
 |  |  |  |  | apple | 1 |  |  | apple | orange | car | tree
 |  |  |  |  | orange | 2 |  |  | elephant | coconut | ball
 |  |  |  |  | car | 3 |  |  | baby |  | oil
 |  |  |  |  | elephant | 1
 |  |  |  |  | baby | 1
 |  |  |  |  | tree | 4
 |  |  |  |  | ball | 3
 |  |  |  |  | oil | 3
 |  |  |  |  | coconut | 2
Spreadsheet: 883073d1731564283-merging-in-out-with-absent-dates-into-a-single-pivot-table-formula-power-query-sample-emp
Sheet: Sheet1

First Table |  |  |  |  |  |  | Second Table
Employee | Date | Time | Status | Column1 |  |  | Employee | 1/1/2024 | 1/2/2024 | 1/3/2024
1 | 2024-01-01 00:00:00 | 08:00:00 | IN |  |  |  | 1 |  |  | A
1 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  | 2 |  | CL
1 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  | 3 | AL
1 | 2024-01-02 00:00:00 | 17:00:00 | OUT
2 | 2024-01-01 00:00:00 | 08:00:00 | IN
2 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  | below is the table like what I love to extract from the 2 data tables (Excel or Power Query)
2 | 2024-01-03 00:00:00 | 08:00:00 | IN
2 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00
3 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  | Employee Emp | IN | OUT | IN | OUT | IN | OUT
3 | 2024-01-02 00:00:00 | 17:00:00 | OUT |  |  |  | 1 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | AL | AL
3 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  | 2 | 08:00:00 | 17:00:00 | CL | CL | 08:00:00 | 17:00:00
3 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  | 3 | A | A | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
I did compiled the both but still I don’t know how to extract the data what I need.
Employee | Date | Time | Status | Column1
1 | 2024-01-01 00:00:00 | 08:00:00 | IN
1 | 2024-01-01 00:00:00 | 17:00:00 | OUT
1 | 2024-01-02 00:00:00 | 08:00:00 | IN
1 | 2024-01-02 00:00:00 | 17:00:00 | OUT
1 | 2024-01-03 00:00:00 | A
2 | 2024-01-01 00:00:00 | 08:00:00 | IN
2 | 2024-01-01 00:00:00 | 17:00:00 | OUT
2 | 2024-01-02 00:00:00 | CL
2 | 2024-01-03 00:00:00 | 08:00:00 | IN
2 | 2024-01-03 00:00:00 | 17:00:00 | OUT
3 | 2024-01-01 00:00:00 | AL
3 | 2024-01-02 00:00:00 | 08:00:00 | IN
3 | 2024-01-02 00:00:00 | 17:00:00 | OUT
3 | 2024-01-03 00:00:00 | 08:00:00 | IN
3 | 2024-01-03 00:00:00 | 17:00:00 | OUT
Spreadsheet: 865262d1712309744-place-individual-digits-from-a-number-into-seperate-cells-sample-etaf
Sheet: Sheet1

Number
1
234
4567
98765
123
Spreadsheet: 100085d1298546092-excel-2007-calculation-help-in-excel-2007-leave-overstay-2011ver2
Sheet: CalTable

Days | S | W
1 | 50 | 50
2 | 50 | 50
3 | 50 | 50
4 |  | 100
5 |  | 100
6 |  | 100
7 | 150 | 100
8 |  | 200
9 |  | 200
10 |  | 200
11 | 300 | 200
12 | 300 | 200
13 | 300 | 200
14 | 300 | 200
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180