tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 271139d1381841638-lookup-multiple-data-test-
Sheet: Result

 | Result
 | I need this page to return all the one in 2013 column and the date according to the year, is this possible?
 | for example:
 | return result should be something like this:
 | name 1 | 5 | 2013-01-24 00:00:00
 | name 2 | 10 | 2013-01-27 00:00:00
 | name 3 | 15 | 2013-02-11 00:00:00
 | name 5 | 10 | 2013-04-14 00:00:00
 | name 6 | 10 | 2013-04-14 00:00:00
 | name 7 | 5 | 2013-05-12 00:00:00
 | name 8 | 10 | 2013-08-11 00:00:00
 | name 9 | 15 | 2013-10-26 00:00:00
 | name 10 | 15 | 2013-10-05 00:00:00
Spreadsheet: daren_farmer__5483__hpl0916
Sheet: Sheet1

HPLN0916.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 16, 2000
 |  |  |  |  |  | ** Sat./Sun. | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 09/16-17/2000 | 2000-09-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | HPL | 0 | 10 | 10
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 860180d1708378045-time-interval-extraction-time
Sheet: Sheet1

12:08:22
12:08:50
12:08:51
12:09:11
12:09:13
12:09:35
12:09:37
12:10:38
12:11:06
12:11:27
12:11:30
12:11:51
12:11:57
12:12:19
12:12:29
12:14:02
12:14:06
12:17:52
12:17:56
12:18:41
12:18:45
12:19:12
12:19:14
12:20:14
12:20:17
12:20:36
12:20:38
12:20:56
12:21:02
12:21:03
12:21:26
12:21:28
12:21:46
12:21:48
12:22:08
12:22:10
12:22:26
12:22:28
12:23:03
12:23:07
12:23:23
12:23:27
12:38:12
12:38:14
12:38:43
12:38:45
12:39:05
12:39:07
12:39:25
12:39:27
12:39:50
12:39:51
12:40:12
12:40:14
12:40:43
12:40:45
12:41:37
12:41:39
12:42:00
12:42:02
12:42:19
12:42:21
12:42:32
12:42:34
12:42:49
12:42:51
12:43:05
12:43:07
12:43:55
12:43:59
12:45:23
12:45:26
12:45:48
12:45:54
12:46:24
12:46:26
12:46:41
12:46:43
12:47:05
12:47:07
12:47:47
12:47:49
12:47:56
12:48:28
12:48:36
12:48:50
12:48:54
12:49:23
12:49:25
12:49:47
12:49:49
12:50:31
12:50:38
12:54:46
12:54:48
12:55:05
12:55:07
12:55:22
12:55:24
12:55:40
12:55:43
12:56:08
12:56:12
13:06:38
13:06:44
13:09:55
13:10:03
13:10:12
13:10:17
13:10:32
13:10:35
13:10:48
13:10:51
Spreadsheet: 349224d1412255381-time-input-and-hours-worked-calculations-weeklyinv-ndmv3
Sheet: Sheet1

Day | Date | Start Time |  | Finish Time | Hours | [NAME] | Total
Monday |  | 07:00:00 | - | 17:00:00 |  | 6
Tuesday |  | 07:00:00 | - |  |  | 6
Wednesday |  | 07:30:00 | - | 17:00:00 |  | 6
Thursday |  |  | - |  |  | 6
Friday |  |  | - |  |  | 6
Saturday |  |  | - |  |  | 6
Sunday |  |  | - |  |  | 6
 |  |  |  | [NAME]: |  | hrs
 |  |  |  |  | Invoice Total:
Spreadsheet: 0ba995ac-806c-4eb8-91f6-e2eebbfca381
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: |  |  | 2012-07-27 09:40:02.530000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.643 | 101.518 | 101.393 | 101.018
3.75 | 101.429 | 101.304 | 101.179 | 100.804 |  | Note: | Refer To Price [NAME]
3.625 | 101.032 | 100.907 | 100.782 | 100.407 |  |  | For all Price Adjs
3.5 | 100.469 | 100.344 | 100.219 | 99.594
3.375 | 99.621 | 99.496 | 99.371 | 98.746
3.25 | 98.697 | 98.572 | 98.447 | 97.822
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.05 | 101.925 | 101.8 | 101.425
3.25 | 101.604 | 101.479 | 101.354 | 100.979
3.125 | 101.31 | 101.185 | 101.06 | 100.685
3 | 100.96 | 100.835 | 100.71 | 100.335
2.875 | 100.369 | 100.244 | 100.119 | 99.494
2.75 | 99.711 | 99.586 | 99.461 | 98.836
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | 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 | 2012-08-10 09:40:02.530000
30 DAY | 2012-08-25 09:40:02.530000
45 DAY | 2012-09-09 09:40:02.530000
60 DAY | 2012-09-24 09:40:02.530000
90 DAY | 2012-10-24 09:40:02.530000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 816005d1675304823-lookup-function-trial
Sheet: Sheet1

 |  |  | Predicted Collection Time
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 704057d1605328397-how-do-i-get-division-colum-to-to-fill-with-a-formula-how-do-i-get-division-to-to-fill-with-a-formula
Sheet: Sheet1

ENTRY | Date&Time | Who | [NAME] | Division
1690 | 2020-11-11 06:16:44 | [NAME] | [EMAIL]
1691 | 2020-11-11 06:35:03 | [NAME] | [EMAIL]
1692 | 2020-11-11 07:12:01 | [NAME] | [EMAIL]
1693 | 2020-11-11 07:18:55 | [NAME] | [EMAIL]
1694 | 2020-11-11 07:19:23 | [NAME] | [EMAIL]
1695 | 2020-11-11 07:35:30 | [NAME] | [EMAIL]
1696 | 2020-11-11 07:38:15 | [NAME] | [EMAIL]
1697 | 2020-11-11 07:41:35 | [NAME] | [EMAIL]
1698 | 2020-11-11 07:44:16 | [NAME] | [EMAIL]
1699 | 2020-11-11 07:54:43 | Therese [NAME] | [EMAIL]
1700 | 2020-11-11 08:16:20 | [NAME] | [EMAIL]
1701 | 2020-11-11 08:19:52 | Carly Correll | [EMAIL]
 |  |  |  |  | ANCC | allegra
 |  |  |  |  | Plym-image360 | 360ply
 |  |  |  |  | Troy-image360 | 360troy
Spreadsheet: 249778d1373622610-check-a-text-string-against-a-predefined-list-and-place-result-in-another-sheet-sample
Sheet: Sheet1

Product Decription | QTY
EEE X02 1234 Description text here | 5
EEE X04 1234 Description text here | 4
EEE Z04 5555 Description text here | 6
EEE Z06 5555 Description text here | 1
LPG Z04 7000 Description text here | 2
LPG Z06 7000 Description text here | 3
EEE 1234 Description text here X02 | 3
EEE  Description 1234 text here X02 | 4
Z06 5555 Description text here EEE | 6
LPG Description text here [NAME] 7000 | 7
Spreadsheet: 486247d1477400671-sort-data-smallest-to-largest-with-formula-index-match-sample
Sheet: Sheet2

LIST 1 | LIST 2 |  | TWO COLUMNS
A | BB
A | CC
B | CC |  |  |  |  |  |  |  |  |  |  |  |  | ONE COLUMN
C | D |  |  |  |  |  |  |  |  |  |  |  |  | A | BB
C | E |  |  |  |  |  |  |  |  |  |  |  |  | A | CC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | CC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C | E
Spreadsheet: 35934c70-1646-48ca-8765-0ca4e169576a
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Authorizing the submission of an |  | 2009-07-09 00:00:00 |  | 7-17-09 Deadline for Application Submission
 | application for Neighborhood Stabilization Program 2 funding.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Housing & Community
 |  |  |  |  |  |  |  |  | Development Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  | Housing & Community
 |  |  |  |  | or Groups |  |  | Development Department
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name:  [NAME] |  | Date:  June 18, 2009
 | Title
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 203236d1356988763-automatically-populate-data-to-multiple-sheets-populate-data
Sheet: All Content

Date | Day | Time | Content Pillar | Platform | Program | Status Update | Approval Date | Social Comments | Product Team Comments
2013-01-04 00:00:00 | Friday | 9AM CST | Entertainment | 1 | 1 | [NAME] | [NAME] yada |  |  |  | Upgrade
2013-01-04 00:00:00 | Friday | 4PM CST | Education | 1 | 2 | [NAME] | [NAME] yada |  |  |  | Education
 |  |  |  |  |  |  |  |  |  |  | Entertainment
2013-01-05 00:00:00 | Saturday | 11AM CST | Upgrade | 1 | 1 | [NAME] | [NAME] yada |  |  |  | Loyalty
2013-01-05 00:00:00 | Saturday | 5PM CST | Education | 1 | 2 | [NAME] | [NAME] yada
 |  |  |  | 1
2013-01-06 00:00:00 | Sunday | 11AM CST | Upgrade | 1 | 3 | [NAME] | [NAME] yada
2013-01-06 00:00:00 | Sunday | 6PM CST | Loyalty | 1 | 1 | [NAME] | [NAME] yada
2013-01-07 00:00:00 | Monday | 11AM CST | Education | 1 | 4 | [NAME] | [NAME] yada
2013-01-07 00:00:00 | Monday | 7PM CST | Entertainment | 1 | 5 | [NAME] | [NAME] yada
2013-01-08 00:00:00 | Tuesday | 9AM CST | Education | 1 | 2 | [NAME] | [NAME] yada
2013-01-08 00:00:00 | Tuesday | 6PM CST | Entertainment | 1 | 6 | [NAME] | [NAME] yada
2013-01-09 00:00:00 | Wednesday | 9AM CST | Entertainment | 1 | 2 | [NAME] | [NAME] yada
2013-01-09 00:00:00 | Wednesday | 4PM CST | Loyalty | 1 | 1 | [NAME] | [NAME] yada
2013-01-10 00:00:00 | Thursday | 11AM CST | Education | 1 | 5 | [NAME] | [NAME] yada
2013-01-10 00:00:00 | Thursday | 5PM CST | Entertainment | 1 | 8 | [NAME] | [NAME] yada
2013-01-11 00:00:00 | Friday | 10AM CST | Education | 1 | 2 | [NAME] | [NAME] yada
2013-01-11 00:00:00 | Friday | 4PM CST | Entertainment | 1 | 7 | [NAME] | [NAME] yada
2013-01-12 00:00:00 | Saturday | 10AM CST | Education | 1 | 2 | [NAME] | [NAME] yada
2013-01-12 00:00:00 | Saturday | 6PM CST | Upgrade | 1 | 1 | [NAME] | [NAME] yada
2013-01-13 00:00:00 | Sunday | 10AM CST | Entertainment | 1 | 4 | [NAME] | [NAME] yada
2013-01-13 00:00:00 | Sunday | 5PM CST | Education | 1 | 7 | [NAME] | [NAME] yada
2014-01-14 00:00:00 | Monday | 10AM CST | Entertainment | 1 | 1 | [NAME] | [NAME] yada
2014-01-14 00:00:00 | Monday | 5PM CST | Loyalty | 1 | 8 | [NAME] | [NAME] yada
Spreadsheet: 90148d1289916086-dedupe-records-having-unique-id-condition-on-another-field-book1-1-
Sheet: Sheet1

 |  | Account ID | Account Name | Industry | Desired | commentary
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 0013000000DWfgz |  | Professional & Consulting Services | Professional & Consulting Services | e6 is the first 'non no response' value for that set of ID, populate all F3:F10 with this value and continue the process down
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services | then after this process de dupe on C
 |  | 0013000000DWfgz |  | Service Provider/Telecommunications | Professional & Consulting Services | NOTE: there are many more fields not shown but this is the essence
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 0013000000DWfgz |  | No Response | Professional & Consulting Services
 |  | 00130000009bfqY |  | No Response | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | Service Provider/Telecommunications | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | Service Provider/Telecommunications
 |  | 00130000009bfqY |  | No Response | Service Provider/Telecommunications
Spreadsheet: 84533d1284579107-classifying-data-by-use-of-an-if-and-statement-help-1-
Sheet: Sheet1

Name | % From | % Of | Classification
[NAME] | -0.03 | 1 | Good | Good
[NAME] | -0.002366071428571472 | 2.001322052704689 | Fair | Fair
[NAME] | 0.04 | 4 | Poor | Poor
 |  |  |  |  |  | To be a Good: Column B has to be a negative (<0) AND Column C has to be less than 200%
 |  |  |  |  |  | To be Fair: Column B has to be between -4% and +4% AND Column C has to be between 200% and 300%.
 |  |  |  |  |  | To be classified as Poor - all else.
Spreadsheet: 695724d1600363291-formula-to-convert-time-text-to-excel-and-add-up-column-adam-timesheet
Sheet: Sheet1

h:m:s:ms
00:00:48:20
00:01:09:23
00:02:56:24
00:00:23:14
00:00:36:05
00:01:27:06
00:00:11:00
00:00:54:14
00:00:40:17
00:00:32:11
00:00:17:14
00:00:56:07
00:00:35:05
00:00:36:16
00:00:36:03
00:00:14:14
00:01:03:04
00:09:00:05
00:01:08:22
00:05:11:13
00:00:52:04
00:00:41:00
00:01:38:03
00:00:23:05
00:00:24:08
00:01:21:09
00:01:53:17
00:02:26:23
00:01:33:09
00:00:50:16
00:00:37:07
00:00:22:12
00:00:28:13
00:01:29:01
00:00:38:02
00:01:48:16
00:01:12:19
00:00:25:01
00:01:16:19
00:00:34:06
00:01:40:19
00:01:42:02
00:02:10:06
00:00:37:07
00:00:58:21
00:01:01:17
00:01:49:01
00:00:54:23
00:00:03:08
00:00:13:00
00:00:42:01
00:01:00:24
00:00:53:13
00:00:15:00
00:01:26:12
00:01:28:16
00:00:34:18
00:01:49:07
00:01:21:20
00:01:09:06
00:01:01:14
00:00:27:02
00:01:51:00
00:01:51:16
00:00:36:02
00:00:35:15
00:00:18:05
00:01:03:00
00:00:28:04
Spreadsheet: 809805d1671330780-match-values-in-columns-on-2-different-sheets-test-match
Sheet: Sheet2

Event date | ID | Event Type | Program | Name | Match?
2021-05-01 00:00:00 | 0002215/1 | Note | Group1 | [NAME]
2021-05-01 00:00:00 | 0023414/1 | Other | Group1 | [NAME]
2021-05-03 00:00:00 | 06695/1 | Note | Group5 | [NAME]
2021-05-02 00:00:00 | 0023414/1 | Note | Group6 | [NAME]
2021-05-03 00:00:00 | 000666/1 | Other | Group15 | Get Smart
2021-05-04 00:00:00 | 06695/2 | File | Group2 | [NAME]
2021-05-06 00:00:00 | 0023414/1 | Care | Group3 | [NAME]
2021-05-09 00:00:00 | 06695/1 | File | Group1 | [NAME]
2021-05-09 00:00:00 | 02222/2 | File | Group4 | [NAME]
2021-05-08 00:00:00 | 0023414/1 | Other | Group5 | Wiley Coyote
2021-05-08 00:00:00 | 06695/2 | Care | Group1 | [NAME]
2021-05-11 00:00:00 | 0023414/1 | Note | Group3 | [NAME]
2021-05-11 00:00:00 | 06695/2 | File | Group7 | [NAME]
2021-05-12 00:00:00 | 0023414/3 | Other | Group11 | Grow Up
2021-05-12 00:00:00 | 06695/1 | Note | Group15 | New Person
2021-05-13 00:00:00 | 0023414/1 | Note | Group19 | [NAME]
2021-05-13 00:00:00 | 001162/1 | Note | Group23 | [NAME]
2021-05-14 00:00:00 | 06695/1 | Care | Group27 | Jelly Fish
2021-05-15 00:00:00 | 004567/1 | Care | Group3 | [NAME]
2021-05-16 00:00:00 | 0023414/1 | Note | Group31 | [NAME]
Spreadsheet: 790861d1660034882-quartile-calculation-with-multi-condition-questions3
Sheet: 1

raw data |  |  |  |  |  | Calculation
distance(m) | line a | line b | line c | line d |  | distance(start)(m) | distance(end)(m) | expected result | Tried formula
1 | #N/A | 0.1 |  | #N/A |  | 0 | 5 | 1 | QUARTILE(IF(NOT(ISERROR($B$2:$E$22)),IF(($A$2:$A$22>=G3),IF(($A$2:$A$22<H3),$B$2:$E$22),3)))
2 | 2 | #N/A |  | #N/A |  | 5 | 10 | 2 | QUARTILE(IF(NOT(ISERROR($B$2:$E$22)),IF(($A$2:$A$22>=G4),IF(($A$2:$A$22<[NAME])))
3 | #N/A | 1 | #N/A | 0.5 |  | 10 | 15 | 4.75 | QUARTILE(IF(NOT(ISERROR($B$2:$E$22)),IF(($A$2:$A$22>=G5),IF(($A$2:$A$22<H5),$B$2:$E$22),3)))
4 | #N/A | #N/A | #N/A | 0 |  | 15 | 20 | 5.25 | QUARTILE(IF(NOT(ISERROR($B$2:$E$22)),IF(($A$2:$A$22>=G6),IF(($A$2:$A$22<[NAME])))
5 | #N/A | 0 | #N/A | 1
6 | #N/A | 4 |  | 1
7 | #N/A |  |  | 1
8 | #N/A | 6 |  | 2
9 | #N/A | 1 | 2 | 2.148784765809593
10 | 1 | 4 |  | 5.8405844649464
11 | 0 | 1 |  | 0
12 | 0 | 1 | 5 | #N/A
13 | 0 | 5 | 7 | #N/A
14 | 0 | 2 | 8 | #N/A
15 | 0 | 2 |  | #N/A
16 | 0 | 2 |  | 11.2938559702951
17 | #N/A | 2 |  | 8
18 | 0 | 5 |  | 6
19 | 0.2 | 0.2 |  | #N/A
20 | 8 | 9 | #N/A
Spreadsheet: 860918d1708941345-xlookup-approximate-multiple-criteria-lookup-id-question-aligw
Sheet: Sheet1

Name | Date of Birth | Lookup ID |  | Name | DOB | ID
Doa, [NAME], MR | 1994-02-01 00:00:00 |  |  | Doa, [NAME] | 1994-02-01 00:00:00 | 12345
Jackson, Amelia, MRS | 1990-03-19 00:00:00 |  |  | Jackson, Amelia | 1990-03-19 00:00:00 | 98213
[NAME], [NAME], SIR | 1980-01-01 00:00:00 |  |  | [NAME] | 1980-01-01 00:00:00 | 80123
Spreadsheet: 647465d1572453328-spreadsheet-interest-calculation-wog-calc-w-payments
Sheet: Balance

Date of Judgment |  | 2009-10-30 00:00:00 |  | Principal |  | 1000
Pre-Judgment Interest Begin |  |  |  | Pre-Judgment Interest |  | 0
Pre-Judgment Interest Rate |  |  |  | Accrued Court Costs |  | 0
Date Calculations Made |  | 2019-10-30 00:00:00 |  | Fee of Writ + Service |  | 0
Daily Interest Rate |  | 0.0002739726027397261 |  | Attorney Fee |  | 0
Post-Judgment Interest Rate |  | 0.1 |  | Post-Judgment Interest |  | 644.417108689239
Date of Last Payment |  | 2019-10-30 00:00:00 |  | Payments Made |  | -1644.42
Amount of Last Payment |  | 204.42 |  | Total Due and Owing |  | -0.002891310761242494
No. Payments Expected to Date |  | 108 |  | Daily Interest rate |  | 0.0002739726027397263
No. Actual Payments Received |  | 10 |  | Estimated Remaining Payments |  | -0.1
Arrearage |  | 15795.58 |  | Payoff in Years |  | -0.008333333333333333
Estimated Monthly Payment |  | 160 |  | Days since Judgment |  | 3652
Payment Date | Payment | Payment Number | Beginning Balance | Accrued Interest | Less Payment | Ending Balance
2010-10-30 00:00:00 | 160 | 1 | 1000 | 100 | 160 | 940
2011-10-30 00:00:00 | 160 | 2 | 940 | 94.00000000000001 | 160 | 874
2012-10-30 00:00:00 | 160 | 3 | 874 | 87.63945205479453 | 160 | 801.6394520547946
2013-10-30 00:00:00 | 160 | 4 | 801.6394520547946 | 80.16394520547946 | 160 | 721.803397260274
2014-10-30 00:00:00 | 160 | 5 | 721.803397260274 | 72.18033972602741 | 160 | 633.9837369863014
2015-10-30 00:00:00 | 160 | 6 | 633.9837369863014 | 63.39837369863015 | 160 | 537.3821106849316
2016-10-30 00:00:00 | 160 | 7 | 537.3821106849316 | 53.88543904402329 | 160 | 431.2675497289549
2017-10-30 00:00:00 | 160 | 8 | 431.2675497289549 | 43.1267549728955 | 160 | 314.3943047018504
2018-10-30 00:00:00 | 160 | 9 | 314.3943047018504 | 31.43943047018504 | 160 | 185.8337351720354
2019-10-30 00:00:00 | 204.42 | 10 | 185.8337351720354 | 18.58337351720354 | 204.42 | -0.002891310761043542
 |  |  | -0.002891310761043542 | 0
Spreadsheet: kim_ward__20933__RFP_Profile_CA_5_9_01
Sheet: Borden_Pricing_Pg1

Borden Chemical
Fremont, CA
Please submit your response to this RFP by completing and returning this sheet.
Please find attached a copy of the Borden Chemical base sales agreement.
Please bid according to the terms found in the base agreement.
Marketing Company:
Marketing Rep:
Date:
Term A: | July 1, 2001 - June 30, 2002
Price #1: |  |  | Index | plus |  | /$Dth
 | Please indicate whether inclusive of fuel to PG&E City gate.
 | Bid good through
Price #2: | NYMEX | plus |  | /$Dth
 | Please indicate whether inclusive of fuel to PG&E City gate.
 | Bid good through
Term B: | July 1, 2001 - June 30, 2003
Price #1: |  |  | Index | plus |  | /$Dth
 | Please indicate whether inclusive of fuel to PG&E City gate.
 | Bid good through
Price #2: | NYMEX | plus |  | /$Dth
 | Please indicate whether inclusive of fuel to PG&E City gate.
 | Bid good through
Additional Request: | Should customer choose an Index based pricing mechansim, customer has the right to switch to a NYMEX plus a fixed basis price at no additional cost to the customer.
 |  |  |  |  |  |  |  | Yes     or     No
Spreadsheet: 814187d1674219435-need-help-returning-a-value-from-a-tab-name-but-for-cell-to-look-for-that-tab-name-example-for-forum
Sheet: Summary

CONTROL PANEL |  | .      ------> | 2022-10-01 00:00:00 | <------ Type current month here
Items
 |  |  |  |  |  |  |  |  |  |  |  |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Running Total
Branch 1
Branch 2
Branch 3
Branch 4
Branch 5
Branch 6
Branch 7
Branch 8
Branch 9
Branch 10
Branch 11
Branch 12
Branch 13
Branch 14
Branch 15
Branch 16
 |  |  |  |  |  |  |  |  |  |  | The blue box (21) is the answer I need but when I type Nov-22 in top yellow box
 |  |  |  |  |  |  |  |  |  |  | the months will shift but then column N will still be reading Oct-22 tab.. How do I make it
 |  |  |  |  |  |  |  |  |  |  | rolling and automatically find Nov-22 tab (when it exists after created for the next month)
 |  |  |  |  |  |  |  |  |  |  | i.e =[NAME], 'FIND TAB THAT MATCHES CELL N5', table array [from that tab just identified], 2, false)