tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60118d1260652325-sort-data-without-using-code-sample
Sheet: Sheet1

SOURCE DATA |  |  |  | CATEGORISED |  |  |  |  | DESIRED OUTCOME
 |  |  |  | A |  | B |  |  | A |  | B
 | Team | Position |  | Block | Tackle | Block | Tackle |  | Block | Tackle | Block | Tackle
Player A | A | Block |  |  |  |  |  |  | Player A | Player E | Player H | Player B
Player B | B | Tackle |  |  |  |  |  |  | Player C | Player G | Player M | Player D
Player C | A | Block |  |  |  |  |  |  | Player F | Player K | Player U | Player I
Player D | B | Tackle |  |  |  |  |  |  | Player J | Player O | Player W | Player L
Player E | A | Tackle |  |  |  |  |  |  | Player Q | Player V |  | Player N
Player F | A | Block |  |  |  |  |  |  | Player S | Player X |  | Player P
Player G | A | Tackle |  |  |  |  |  |  |  |  |  | Player R
Player H | B | Block |  |  |  |  |  |  |  |  |  | Player T
Player I | B | Tackle |  |  |  |  |  |  |  |  |  | Player Y
Player J | A | Block |  |  |  |  |  |  |  |  |  | Player Z
Player K | A | Tackle
Player L | B | Tackle
Player M | B | Block |  |  |  |  |  |  | Problem:
Player N | B | Tackle |  |  |  |  |  |  | Can the above array be produced from the
Player O | A | Tackle |  |  |  |  |  |  | Source Data without resorting to writng code?
Player P | B | Tackle
Player Q | A | Block |  |  |  |  |  |  | And if code has to be written, what is the simplest?
Player R | B | Tackle
Player S | A | Block
Player T | B | Tackle
Player U | B | Block
Player V | A | Tackle
Player W | B | Block
Player X | A | Tackle
Player Y | B | Tackle
Player Z | B | Tackle
Spreadsheet: 03f83cd6-f820-40cb-99c2-e7f190ab511f
Sheet: Industry

Churchill County Industry of  Employed (age 16+) 2005-2009
2009 |  |  |  |  |  |  |  | county
Agriculture, forestry, fishing and hunting, and mining: |  |  |  |  |  |  |  | 729
Agriculture, forestry, fishing and hunting |  |  |  |  |  |  |  | 542
Mining, quarrying, and oil and gas extraction |  |  |  |  |  |  |  | 182
Construction |  |  |  |  |  |  |  | 1125
Manufacturing |  |  |  |  |  |  |  | 656
Wholesale trade |  |  |  |  |  |  |  | 304
Retail trade |  |  |  |  |  |  |  | 1209
Transportation and warehousing, and utilities: |  |  |  |  |  |  |  | 738
Transportation and warehousing |  |  |  |  |  |  |  | 558
Utilities |  |  |  |  |  |  |  | 180
Information |  |  |  |  |  |  |  | 155
Finance and insurance, and real estate and rental and leasing: |  |  |  |  |  |  |  | 364
Finance and insurance |  |  |  |  |  |  |  | 242
Real estate and rental and leasing |  |  |  |  |  |  |  | 122
Professional, scientific, and management, and administrative and waste management services: |  |  |  |  |  |  |  | 875
Professional, scientific, and technical services |  |  |  |  |  |  |  | 482
Management of companies and enterprises |  |  |  |  |  |  |  | 0
Administrative and support and waste management services |  |  |  |  |  |  |  | 393
Educational services, and health care and social assistance: |  |  |  |  |  |  |  | 1453
Educational services |  |  |  |  |  |  |  | 779
Health care and social assistance |  |  |  |  |  |  |  | 674
Arts, entertainment, and recreation, and accommodation and food services: |  |  |  |  |  |  |  | 1198
Arts, entertainment, and recreation |  |  |  |  |  |  |  | 388
Accommodation and food services |  |  |  |  |  |  |  | 810
Other services, except public administration |  |  |  |  |  |  |  | 458
Public administration |  |  |  |  |  |  |  | 900
Spreadsheet: 153163d1335790104-excel-2007-vllookup-help-needed-quiz-2
Sheet: paycard

 | paycard
 | name | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | hourly pay
 | id |  |  |  |  |  |  |  |  |  |  |  |  |  | month
 | days | 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 | sum
 | worktime
 | overtime
 | sundays
 | worktime |  |  |  |  | overtime |  |  |  |  |  |  |  | sundays |  |  |  |  |  | salary advance |  |  |  |  |  | balance
Spreadsheet: 864741d1711870195-calculate-elapsed-time-in-days-hours-and-minutes-excluding-weekends-and-holidays-time-calculator-1-aligw
Sheet: RESULT

2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00 | 10d 01m
2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00 | 10d 01m
2024-01-18 00:00:00 | 02:45:00 | 2024-01-29 00:00:00 | 15:00:00 | 11d 15m
2024-01-19 00:00:00 | 10:19:00 | 2024-02-02 00:00:00 | 13:14:00 | 14d 1h 55m
2024-01-31 00:00:00 | 23:00:00 | 2024-02-02 00:00:00 | 13:40:00 | 2d 1h 40m
2024-01-26 00:00:00 | 10:00:00 | 2024-01-27 00:00:00 | 13:19:00 | 1d 2h 19m
2024-01-27 00:00:00 | 07:00:00 | 2024-01-27 00:00:00 | 13:19:00 | 5h 19m
2024-01-28 00:00:00 | 17:40:00 | 2024-01-29 00:00:00 | 09:12:00 | 3h 32m
2024-01-27 00:00:00 | 13:00:00 | 2024-01-29 00:00:00 | 09:12:00 | 5h 12m
2024-01-27 00:00:00 | 18:00:00 | 2024-01-29 00:00:00 | 09:12:00 | 1d 3h 12m
2024-01-28 00:00:00 | 10:36:00 | 2024-01-29 00:00:00 | 09:12:00 | 1d 2h 36m
2024-01-23 00:00:00 | 15:00:00 | 2024-01-30 00:00:00 | 08:15:00 | 4d 5h 15m
2024-02-01 00:00:00 | 11:30:00 | 2024-02-01 00:00:00 | 13:24:00 | 5h 42m
Spreadsheet: 888814d1739392245-pare-down-the-dates-to-just-the-year-given-and-shorten-to-yyyy-yyyy-in-column-c-sample-workbook-2
Sheet: Sheet1

1971-01-01 00:00:00 | 1979-12-31 00:00:00
1971-01-01 00:00:00 | 1995-12-31 00:00:00
1973-08-01 00:00:00 | 1976-08-31 00:00:00
1976-01-01 00:00:00 | 1983-12-31 00:00:00
1972-05-01 00:00:00 | 1985-12-31 00:00:00
1971-07-01 00:00:00 | 1975-06-30 00:00:00
1968-01-01 00:00:00 | 1992-12-31 00:00:00
1970-01-01 00:00:00
1950-01-01 00:00:00
1959-01-01 00:00:00 | 1987-12-31 00:00:00
1960-01-01 00:00:00 | 1980-12-31 00:00:00
1965-01-01 00:00:00 | 1983-12-31 00:00:00
1963-07-01 00:00:00 | 1966-12-31 00:00:00
1960-01-01 00:00:00 | 1979-12-31 00:00:00
1985-12-01 00:00:00 | 1990-12-31 00:00:00
1978-06-01 00:00:00 | 1982-05-31 00:00:00
1961-01-01 00:00:00 | 1982-12-31 00:00:00
1976-01-01 00:00:00 | 1985-12-31 00:00:00
1948-08-01 00:00:00 | 1950-08-30 00:00:00
1977-10-01 00:00:00 | 1978-09-30 00:00:00
1969-06-01 00:00:00 | 1976-12-31 00:00:00
1974-10-01 00:00:00 | 1979-06-30 00:00:00
1968-01-01 00:00:00 | 2001-12-31 00:00:00
1967-07-01 00:00:00 | 1982-12-31 00:00:00
1965-01-01 00:00:00 | 1974-12-31 00:00:00
1972-01-01 00:00:00 | 1980-11-30 00:00:00
1974-06-01 00:00:00 | 1975-12-31 00:00:00
1974-01-01 00:00:00 | 1982-12-31 00:00:00
1976-03-01 00:00:00 | 1984-06-30 00:00:00
1976-01-01 00:00:00 | 1999-01-30 00:00:00
1964-07-01 00:00:00 | 1967-09-11 00:00:00
1960-01-01 00:00:00 | 1969-12-31 00:00:00
1965-02-01 00:00:00 | 1979-12-31 00:00:00
1966-07-01 00:00:00 | 1967-06-30 00:00:00
1967-01-01 00:00:00 | 1970-04-30 00:00:00
1963-08-01 00:00:00 | 1989-12-31 00:00:00
1970-01-01 00:00:00 | 1981-12-31 00:00:00
1964-01-01 00:00:00 | 1998-12-31 00:00:00
1961-01-01 00:00:00 | 1979-12-31 00:00:00
1961-01-01 00:00:00 | 1979-12-31 00:00:00
1994-01-01 00:00:00 | 2004-12-31 00:00:00
1961-01-01 00:00:00 | 1971-01-04 00:00:00
1971-08-01 00:00:00 | 1975-01-31 00:00:00
1982-01-01 00:00:00 | 1983-03-31 00:00:00
1974-01-01 00:00:00 | 1974-12-31 00:00:00
1978-01-01 00:00:00 | 1980-12-31 00:00:00
1973-01-01 00:00:00 | 1996-12-31 00:00:00
1967-07-01 00:00:00 | 1969-06-30 00:00:00
1997-07-01 00:00:00 | 1999-07-31 00:00:00
1964-05-01 00:00:00 | 1999-12-31 00:00:00
1963-01-01 00:00:00 | 1969-06-30 00:00:00
1964-10-01 00:00:00 | 1971-08-31 00:00:00
1971-10-01 00:00:00 | 1993-05-30 00:00:00
1969-01-01 00:00:00 | 1972-12-31 00:00:00
1969-08-01 00:00:00 | 2016-05-31 00:00:00
1960-04-01 00:00:00 | 1965-07-31 00:00:00
1979-11-01 00:00:00 | 1994-12-31 00:00:00
1971-01-01 00:00:00 | 1982-12-31 00:00:00
Spreadsheet: 793785d1661716887-would-appreciate-help-creating-a-worksheet-for-income-expense-simple-budget-rons-monthly-budget-worksheet
Sheet: Sheet1

 | Monthly Income
 | Monthly Expenses
 | Balance
 | YTD + or -
 | Income ( Monthly) |  |  |  | Expenses (Monthly)
 | 1 Check |  | 3000 |  | Credit card | 2862
 | 2 Check | 1190 | 2500 |  | Bills | 1500
 | Savings Interest |  | 48
Spreadsheet: 888745d1739312531-multiple-conditions-for-status-of-training-sample-data
Sheet: Sheet1

Modality | Voucher Debit Date | Training Start Date | OnDemand Course Completed | OnDemand Percentage Completed | Complete | Pending/Future  Start Date | On Track | Not Started/ Watch List
OnDemand | 2024-09-06 00:00:00 | 2024-11-08 00:00:00 | True | 94
OnDemand | 2024-10-28 00:00:00 | 2025-01-12 00:00:00 | False | 64
OnDemand | 2024-10-14 00:00:00 | 2024-12-17 00:00:00 | True | 100
Live Online | 2024-09-09 00:00:00 | 2024-10-28 00:00:00 | 0 | 0
Live Online | 2024-09-15 00:00:00 | 2024-10-21 00:00:00 | 0 | 0
OnDemand | 2024-09-06 00:00:00 | 2024-11-15 00:00:00 | True | 83
Live Online | 2024-09-27 00:00:00 | 2024-10-21 00:00:00 | 0 | 0
OnDemand | 2024-12-29 00:00:00 | 2025-03-11 00:00:00 | False | 10
OnDemand | 2024-12-03 00:00:00 | 2025-01-19 00:00:00 | True | 100
OnDemand | 2024-09-19 00:00:00 | 2024-11-21 00:00:00 | False | 49
Live Online | 2024-09-09 00:00:00 | 2024-11-11 00:00:00 | 0 | 0
OnDemand | 2024-10-10 00:00:00 | 2024-12-11 00:00:00 | False | 65
OnDemand | 2024-11-01 00:00:00 | 2025-01-16 00:00:00 | False | 20
OnDemand | 2024-12-03 00:00:00 | 2025-02-16 00:00:00 | False | 11
OnDemand | 2024-12-03 00:00:00 | 2025-02-18 00:00:00 | False | 24
OnDemand | 2024-10-02 00:00:00 | 2024-12-12 00:00:00 | False | 1
Live Online | 2024-12-03 00:00:00 | 2024-09-04 00:00:00 | 0 | 0
Live Online | 2024-11-22 00:00:00 | 2024-12-02 00:00:00 | 0 | 0
OnDemand | 2024-12-06 00:00:00 | 2025-02-13 00:00:00 | True | 99
OnDemand | 2024-11-01 00:00:00 | 2025-01-03 00:00:00 | False | 30
OnDemand | 2024-10-28 00:00:00 | 2025-02-02 00:00:00 | False | 24
OnDemand | 2024-10-28 00:00:00 | 2025-02-03 00:00:00 | False | 0
OnDemand | 2024-10-22 00:00:00 | 2025-02-03 00:00:00 | False | 15
OnDemand | 2024-10-18 00:00:00 | 2025-01-02 00:00:00 | False | 0
OnDemand | 2024-10-28 00:00:00 | 2025-02-03 00:00:00 | False | 3
In Person | 2024-10-02 00:00:00 | 2024-11-11 00:00:00 | 0 | 0
OnDemand | 2024-10-22 00:00:00 | 2025-01-03 00:00:00 | True | 100
OnDemand | 2024-10-02 00:00:00 | 2024-12-04 00:00:00 | False | 20
OnDemand | 2024-10-02 00:00:00 | 2024-12-08 00:00:00 | False | 0
OnDemand | 2024-12-06 00:00:00 | 2025-02-07 00:00:00 | True | 91
OnDemand | 2024-09-05 00:00:00 | 2024-11-20 00:00:00 | False | 3
Live Online | 2024-10-07 00:00:00 | 2025-01-20 00:00:00 | 0 | 0
OnDemand | 2024-09-23 00:00:00 | 2024-12-07 00:00:00 | True | 100
OnDemand | 2024-10-29 00:00:00 | 2024-12-31 00:00:00 | False | 4
OnDemand | 2024-10-08 00:00:00 | 2025-01-11 00:00:00 | False | 28
OnDemand | 2024-09-05 00:00:00 | 2024-11-20 00:00:00 | False | 8
OnDemand | 2024-09-23 00:00:00 | 2024-11-30 00:00:00 | False | 13
Spreadsheet: 679152d1590226311-return-ids-of-account-managers-data-source
Sheet: Placements

Mountie_Placement_ID | Resource_Name | Service_Division | Account_Manager | Start_Date
1363 | [NAME] | Infrastructure | [NAME] | 2020-02-17 00:00:00
4458 | [NAME] | Data Services | [NAME] | 2017-08-12 00:00:00
4598 | [NAME] | Data Services | [NAME] | 2018-08-04 00:00:00
41 | [NAME] | Consulting | [NAME] | 2017-11-24 00:00:00
4635 | [NAME] | Data Services | Asa Nguyen | 2018-03-24 00:00:00
707 | [NAME] | Consulting | [NAME] | 2016-05-16 00:00:00
4319 | [NAME] | Business Analysis | [NAME] | 2021-03-29 00:00:00
1104 | [NAME] | Consulting | [NAME] | 2016-12-28 00:00:00
1103 | [NAME] | Consulting | Minnie Parsons | 2017-08-04 00:00:00
1102 | [NAME] | Consulting | Minnie Parsons | 2018-01-11 00:00:00
531 | [NAME] | Consulting | [NAME] | 2016-05-27 00:00:00
1989 | [NAME] Ruiz | Support | [NAME] | 2020-05-31 00:00:00
1968 | [NAME] Ruiz | Support | [NAME] | 2020-09-20 00:00:00
3417 | [NAME] | Testing | [NAME] | 2019-07-17 00:00:00
2087 | [NAME] | Support | Isabelle Oneal | 2018-04-21 00:00:00
1290 | [NAME] | Infrastructure | [NAME] | 2020-01-23 00:00:00
4691 | [NAME] | Data Services | [NAME] | 2021-02-19 00:00:00
4677 | [NAME] | Data Services | [NAME] | 2016-10-13 00:00:00
3589 | [NAME] | PMO | [NAME] | 2021-02-07 00:00:00
Spreadsheet: 821350d1678647314-complex-formulas-combining-sumif-and-ifs-table-3-cmccambridge-
Sheet: Sheet1

Employee Name | Job Position | Department | Start Date | Salary | Benefits | Employer Taxes | Total Yearly Costs | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  | 0.12 | 0.08 |  | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Hire 1 | Position 1 | Science | 2023-01-10 00:00:00 | 100000
Hire 2 | Position 2 | Product | 2023-06-01 00:00:00 | 200000
Hire 3 | Position 3 | Corporate | 2023-05-25 00:00:00 | 400000
Hire4 | Position 4 | Engineering | 2023-04-25 00:00:00 | 350000
Hire 5 | Position 5 | Product | 2023-10-05 00:00:00 | 200000
Hire 6 | Position 6 | Science | 2024-02-04 00:00:00 | 100000
 | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00
 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Science
Product
Corporate
Engineering
Spreadsheet: 831461d1685643742-sum-formula-stopped-working-book1
Sheet: Order of Merit

 |  | Colmworth | Oakland Park | Dunstable Downs | [NAME] |  | Daventry | Canons Brook | [NAME] |  | [NAME] | Drayton Park
No | MEMBER | ReUnion | Bucks | Beds | Memorial | Weekender | Northants | Essex | Pairs | European | [NAME] | Last Chance | Masters | Singles | TOTAL | WINS
1
2
3 |  |  |  | 3
4 |  |  |  | 7
5 |  | 2 | 9 | 6 |  |  |  |  |  |  |  |  |  | 1.25
6
7
8
9
10
11 |  |  |  | 12
12
13
14
15
16 |  |  | 3
17 |  | 9 | 1 | 15 |  |  |  |  |  |  |  |  |  | 1.25
18 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1.25
19 |  | 1 | 6 |  |  |  |  |  |  |  |  |  |  | 1.25
20
21
22 |  |  |  | 10
23 |  |  | 8
24
25 |  | 10 | 2
26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.25
28 |  | 7 | 5
29 |  | 6 | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 1
30 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 1.25
31
32
33 |  |  |  | 8
34 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1.25
35 |  | 12
36
37 |  | 15 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1
38 |  | 8
39
40 |  | 3 | 10 | 4
41 |  |  | 12
42 |  |  |  | 2
43 |  | 5
44
45 |  |  | 7 | 9
46 |  |  | 4
Spreadsheet: 167338d1341953280-parabolic-equation-generator-book2_edited
Sheet: Sheet1

X | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Y | 9 | 7 | 6 | 5 | 4 | 5 | 6 | 7 | 8 | 9 | 14 | 20
 |  |  |  |  |  | <======== | System of Equations
 | A = |  | (constant) | http://www.efunda.com/math/leastsquares/lstsqr2dcurve.cfm
 | B = |  | (x coef)
 | C = |  | (x^2 coef) | (see the website for details)
 | where, y= | A+Bx+Cx^2 |  | NOTE: this matches your equation.
Spreadsheet: 24389d1214621041-linking-two-fields-together-in-drop-down-box-temp
Sheet: Customers

LastName | FirstName | DateVisited | Mailing Address | City | State | Zip | Phone | Fax | [NAME]
alba | roedl | 2008-06-22 00:00:00 | sdfsdf | dsfsdf | sdf | sdfsd | sdfsd |  | sdfsdf
Conaway | [NAME] | 2008-06-16 00:00:00 | sdfsd | xcvcx | xc | xcvxcv
yable | mori
kd | mac
lopi | mardi
[NAME] | mac
Spreadsheet: 80fff34c-0d1d-4a6c-998a-9022ce5ccae4
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-08-12 14:01:22.390000
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.625 | 101.999 | 101.874 | 101.749 | 101.374 |  | and are added to price quote
4.5 | 101.192 | 101.067 | 100.942 | 100.567
4.375 | 100.347 | 100.222 | 100.097 | 99.722 |  | Note: | Refer To Price [NAME]
4.25 | 99.79 | 99.665 | 99.54 | 99.165 |  |  | For all Price Adjs
4.125 | 99.074 | 98.949 | 98.824 | 98.199
4 | 98.183 | 98.058 | 97.933 | 97.308
3.875 | 97.254 | 97.129 | 97.004 | 96.379
 |  |  |  |  |  | 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
3.875 | 101.986 | 101.861 | 101.736 | 101.361
3.75 | 101.658 | 101.533 | 101.408 | 101.033
3.625 | 101.305 | 101.18 | 101.055 | 100.68
3.5 | 100.834 | 100.709 | 100.584 | 100.209
3.375 | 100.143 | 100.018 | 99.893 | 99.268
3.25 | 99.377 | 99.252 | 99.127 | 98.502
3.125 | 98.49 | 98.365 | 98.24 | 97.615 |  | Minimum loan amount:
3 | 97.935 | 97.81 | 97.685 | 97.06 |  | 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-08-26 14:01:22.390000
30 DAY | 2013-09-10 14:01:22.390000
45 DAY | 2013-09-25 14:01:22.390000
60 DAY | 2013-10-10 14:01:22.390000
90 DAY | 2013-11-09 14:01:22.390000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 34913d1232368787-how-to-find-last-occurence-last-occurence
Sheet: Sheet1

Account | January | February | March | April | May | June | July | August | September | October | November | December | Last occurence Month | Last occurence Qty
[NAME] |  |  |  |  |  | 4 |  |  | 4 | 4
L0002 | 4 |  | 6 |  | 8
L0003 | 4 |  | 9 |  | 12 |  |  |  | 12 |  |  | 18
L0004 | 6 |  |  |  |  |  | 12 | 12 |  | 6 | 6
L0005 | 3 | 4 |  | 12 |  | 12
L0006 |  | 4 |  |  |  |  |  | 12 |  | 6 |  | 8
L0007 | 7 |  |  |  |  |  |  | 3 |  |  | 6
L0008 | 9 | 12 |  | 21 |  |  |  | 5 | 4
L0009 | 10 |  |  |  |  |  | 4
I want below result using Excel formula
Account | January | February | March | April | May | June | July | August | September | October | November | December | Last occurence Month | Last occurence Qty
[NAME] |  |  |  |  |  | 4 |  |  | 4 | 4 |  |  | October | 4
L0002 | 4 |  | 6 |  | 8 |  |  |  |  |  |  |  | May | 8
L0003 | 4 |  | 9 |  | 12 |  |  |  | 12 |  |  | 18 | December | 18
L0004 | 6 |  |  |  |  |  | 12 | 12 |  | 6 | 6 |  | Nonvember | 6
L0005 | 3 | 4 |  | 12 |  | 12 |  |  |  |  |  |  | June | 12
L0006 |  | 4 |  |  |  |  |  | 12 |  | 6 |  | 8 | December | 8
L0007 | 7 |  |  |  |  |  |  | 3 |  |  | 6 |  | Nonvember | 6
L0008 | 9 | 12 |  | 21 |  |  |  | 5 | 4 |  |  |  | September | 4
L0009 | 10 |  |  |  |  |  | 4 |  |  |  |  |  | July | 4
Spreadsheet: 217647d1362141436-vlookup-based-on-if-critria-vlookcomplex
Sheet: Sheet1

 | Customer |  |  |  |  | Cust Name | Scott
Product | Scott | [NAME] | [NAME]
ABC | 1.5 | 2 | 2.5 |  |  |  | Product code | Price
DEF | 1.75 | 2.25 | 2.75 |  |  |  | ABC
GHI | 2 | 2.5 | 3 |  |  |  | GHI
JKL | Not Available | 11 | 12 |  |  |  | JKL
Spreadsheet: 65867b25-7499-4ebf-a318-81cfb31dfe54
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2125 | 6007 | Lydia | Weydahl | NOR | 23 | 00:34:08 | 00:01:08 | 00:43:21 | 00:01:19 | [NAME] | 1 | 01:49:59
2125 | 10474 | Berthe Annette | Svenkerud | NOR | 24 | 00:36:52 | 00:01:22 | 00:45:50 | 00:01:27 | 00:32:08 | 2 | 01:56:16
Spreadsheet: 211480d1359757152-change-cell-color-based-on-row-number-signup-example
Sheet: Sheet1

After School Family Function
Name | Program | Time | Location
[NAME] | Parrot | 1PM | Gym
[NAME] | Cardinal | 1pm | Art Room
[NAME] | Parrot | 4pm | Music Room
[NAME] | Parrot | 9am
[NAME] | Cardinal | 2pm
[NAME] | Parrot | 430pm
[NAME] | Parrot | 1pm
Adam | Cardinal | 1pm
[NAME] | Parrot | 1130am
Nicole | Parrot
Elissa | Cardinal
[NAME] | Parrot
Destiny | Parrot
[NAME] | Cardinal
Amanda | Parrot
[NAME] | Parrot
Sean | Cardinal
[NAME] | Parrot
Damion | Parrot
Antonia | Cardinal
[NAME] | Parrot
[NAME] | Parrot
[NAME] | Cardinal
Scott | Parrot
[NAME] | Cardinal
Spreadsheet: 793876d1661782664-extract-entire-row-based-on-one-or-more-value-to-create-a-list-in-a-new-sheet-report-forum
Sheet: master25082022

Name | Availability User Requirement | Feasibility Delivery | Feasibility Approval | [NAME] | BBP delivery | [NAME] | Release to Final Acceptance | Intermediate  Go-Live  1 | Intermediate  Go-Live  2 | Intermediate  Go-Live  3 | Intermediate  Go-Live  4 | Intermediate  Go-Live  5 | Intermediate  Go-Live  6 | Final Go-Live | [NAME]
Project: A | 2020-10-13 00:00:00 | 2021-07-13 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-10-05 00:00:00 | 2021-11-17 00:00:00 | 2022-10-03 00:00:00 |  |  |  |  |  |  | 2022-12-07 00:00:00 | 2023-03-03 00:00:00
Project: B | 2021-01-12 00:00:00 | 2021-03-18 00:00:00 | 2021-03-25 00:00:00 | 2021-04-16 00:00:00 | 2021-06-14 00:00:00 | 2021-07-28 00:00:00 | 2021-10-08 00:00:00 |  |  |  |  |  |  | 2021-12-17 00:00:00 | 2022-02-28 00:00:00
Project: C | 2020-10-13 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-28 00:00:00 | 2021-07-16 00:00:00 | 2021-07-29 00:00:00 | 2021-10-19 00:00:00 |  |  |  |  |  |  | 2021-11-22 00:00:00 | 2022-04-18 00:00:00
Project: D
Project: E | 2021-10-11 00:00:00 | 2021-10-26 00:00:00 | 2021-11-03 00:00:00 | 2021-11-11 00:00:00 | 2022-03-21 00:00:00 | 2022-03-31 00:00:00 | 2022-07-04 00:00:00 | 2021-11-23 00:00:00 |  |  |  |  |  | 2022-07-11 00:00:00 | 2022-09-16 00:00:00
Project: F | 2021-12-10 00:00:00 | 2022-06-15 00:00:00 | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 | 2022-08-12 00:00:00 | 2022-09-09 00:00:00 | 2022-10-31 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 |  |  |  |  | 2022-12-16 00:00:00 | 2023-02-24 00:00:00
Project: G | 2021-12-10 00:00:00 | 2022-02-21 00:00:00 | 2022-02-22 00:00:00 | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 | 2022-04-14 00:00:00 | 2022-07-04 00:00:00 |  |  |  |  |  |  | 2022-09-01 00:00:00 | 2022-10-03 00:00:00
Project: H | 2022-04-12 00:00:00 | 2022-06-15 00:00:00 | 2022-08-05 00:00:00 | 2022-09-01 00:00:00 | 2022-09-30 00:00:00 | 2022-10-14 00:00:00 | 2022-11-14 00:00:00 |  |  |  |  |  |  | 2022-12-01 00:00:00 | 2022-12-21 00:00:00
Project: I | 2022-04-12 00:00:00 | 2022-05-05 00:00:00 | 2022-05-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-21 00:00:00 | 2022-06-28 00:00:00 | 2022-09-12 00:00:00 |  |  |  |  |  |  | 2022-10-10 00:00:00 | 2022-11-30 00:00:00
Spreadsheet: eric_saibi__9960__110801
Sheet: Gerald Gentleman 02

Owner Name |  | Nebraska Public Power
Station Name |  | [NAME]
Unit Name |  | [NAME] 02
NERC Region |  | MAPP
State |  | NE
Fuel Type |  | Coal
Capacity |  | 681 MW
Start Date |  | 2001-11-06 00:00:00
End Date |  | 2001-11-10 00:00:00
Comments |  | Boiler Problerm
SIC |  | 4911
Plant ID |  | 1014369
Unit ID |  | 1008639
Outage ID |  | 18833
Spreadsheet: 218921d1362607565-auto-populate-a-sheet-from-data-on-another-sheet-project-tracker-example
Sheet: MASTER

MASTER PROJECT CALENDAR
DEPT | SEASON | TASK | DUE DATE | START DATE | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | WEEK 7 | WEEK 8 | STATUS | PROJECT LEAD | NOTES
Dept. 1 | Summer 2013 | Task 1 | 2013-05-01 00:00:00 | 2013-04-01 00:00:00 |  |  |  |  |  |  |  | Completed | Employee 1
Dept. 1 | Fall 2013 | Task 2 | 2013-06-01 00:00:00 | 2013-05-01 00:00:00 |  |  |  |  |  |  |  | Open | Employee 2
Dept. 1 | Winter 2014 | Task 3 | 2013-07-01 00:00:00 | 2013-06-01 00:00:00 |  |  |  |  |  |  |  | Open | Employee 3
Dept. 2 | Summer 2013 | Task 4 | 2013-05-01 00:00:00 | 2013-04-01 00:00:00 |  |  |  |  |  |  |  | Completed | Employee 1
Dept. 2 | Fall 2013 | Task 5 | 2013-06-01 00:00:00 | 2013-05-01 00:00:00 |  |  |  |  |  |  |  | Open | Employee 2
Dept. 2 | Winter 2014 | Task 6 | 2013-07-01 00:00:00 | 2013-06-01 00:00:00 |  |  |  |  |  |  |  | Open | Employee 3