tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 792453d1660913951-sum-amounts-based-on-multiple-conditions-sample
Sheet: Sample

CURRENT DATA |  |  |  |  |  | DESIRED OUTCOME
ID | DATE | AMOUNT |  |  |  | ID | DATE | AMOUNT
AR-1 | 2022-01-01 00:00:00 | 2 |  |  |  | AR-1 | 2022-01-01 00:00:00 | 12
AR-1 | 2022-01-01 00:00:00 | 3 |  |  |  | AR-1 | 2022-02-01 00:00:00 | 16
AR-1 | 2022-01-01 00:00:00 | 2 |  |  |  | AR-1 | 2022-03-01 00:00:00 | 13
AR-1 | 2022-01-01 00:00:00 | 5 |  |  |  | AR-1 | 2022-04-01 00:00:00 | 14
AR-1 | 2022-02-01 00:00:00 | 7 |  |  |  | AR-2 | 2022-01-01 00:00:00 | 6
AR-1 | 2022-02-01 00:00:00 | 9 |  |  |  | AR-2 | 2022-02-01 00:00:00 | 14
AR-1 | 2022-03-01 00:00:00 | 1 |  |  |  | AR-2 | 2022-03-01 00:00:00 | 16
AR-1 | 2022-03-01 00:00:00 | 3 |  |  |  | AR-2 | 2022-04-01 00:00:00 | 13
AR-1 | 2022-03-01 00:00:00 | 5
AR-1 | 2022-03-01 00:00:00 | 4
AR-1 | 2022-04-01 00:00:00 | 9
AR-1 | 2022-04-01 00:00:00 | 4
AR-1 | 2022-04-01 00:00:00 | 1
AR-2 | 2022-01-01 00:00:00 | 4
AR-2 | 2022-01-01 00:00:00 | 2
AR-2 | 2022-02-01 00:00:00 | 6
AR-2 | 2022-02-01 00:00:00 | 8
AR-2 | 2022-03-01 00:00:00 | 1
AR-2 | 2022-03-01 00:00:00 | 5
AR-2 | 2022-03-01 00:00:00 | 7
AR-2 | 2022-03-01 00:00:00 | 3
AR-2 | 2022-04-01 00:00:00 | 1
AR-2 | 2022-04-01 00:00:00 | 8
AR-2 | 2022-04-01 00:00:00 | 4
Spreadsheet: 699715d1602729342-calendar-for-multi-day-recurring-events-recurring-multiday-events
Sheet: Settings

 | Basic | Weekdays | Months | Recurrency
 | Yes | Sunday | January | One-Time
 | No | Monday | February | Daily
 |  | Tuesday | March | Weekly
 |  | Wednesday | April | Monthly
 |  | Thursday | May | Yearly
 |  | Friday | June
 |  | Saturday | July
 |  |  | August
 |  |  | September
 |  |  | October
 |  |  | November
 |  |  | December
 |  |  | Special
Spreadsheet: 57921d1258134984-calculate-point-of-intersection-707178-line-intersect
Sheet: INTER

 |  | Input |  |  | Computed using LINEST
 |  | X | Y |  | b | [NAME]) |  | m | xint | yint
 | Line 1 | 8.653043762365293 | 0.1617811086623862 |  | -0.6448202413497962 | -0.4300462569945107 |  | 0.6504790048236323 | 13.07705586339702 | 0.1239609938476788 | Line1 / Line2
 |  | 11.53739168315373 | 0.1343893275837862
 | Line 2 | 15.86391356433637 | 0.101479733490563 |  | -1.035820772705875 | 0.5751610694617755 |  | 1.77741679142513 | 21.90279705026375 | 0.07265608102934791 | Line2 / Line3
 |  | 21.63260940591323 | 0.07359625865914167
 | Line 3 | 25.95913128709588 | 0.05347654107134833 |  | -1.803870733023999 | 2.945835096850835 |  | 19.02654476149734
 |  | 28.84347920788431 | 0.04422040448444475
Spreadsheet: 720224d1614081155-vlookup-index-formula-help-excel-help
Sheet: Sheet1

Document Type | Document No | Tax Date | Accounting Year | Accounting Period | Customer Account No | Sales Event No | Despatch Note No | DespatchMethod | Carrier Reference | Cost of Carriage
INV | 00276330 | 2020-11-19 00:00:00 | 2020/21 | 5 | 03INT001 | 272867 | 00077754 | UK Standard | 5532125 |  |  |  |  |  |  | UK Standard | 50
INV | 00273085 | 2020-09-22 00:00:00 | 2020/21 | 3 | 03INT001 | 272867 | 00074587 | UK Standard | 5438978 |  |  |  |  |  |  | Mail-order | 7.5
INV | 00275031 | 2020-10-28 00:00:00 | 2020/21 | 4 | 03INT001 | 272867 | 00076660 | UK Standard | 5438978 |  |  |  |  |  |  | Ireland | 75
INV | 00276843 | 2020-11-27 00:00:00 | 2020/21 | 5 | 03INT001 | 272867 | 00078346 | Mail-Order | DPD
INV | 00273113 | 2020-09-22 00:00:00 | 2020/21 | 3 | 03INT001 | 262669 | 00074596 | Mail-Order | DPD
INV | 00274962 | 2020-10-27 00:00:00 | 2020/21 | 4 | 03INT001 | 262669 | 00076511 | UK Standard | 6834458782
INV | 00276168 | 2020-11-17 00:00:00 | 2020/21 | 5 | 03INT001 | 276696 | 00077722 | UK Standard | 5438978
INV | 00277650 | 2020-12-10 00:00:00 | 2020/21 | 6 | 03INT001 | 277922 | 00079094 | Ireland | Ireland
INV | 00276853 | 2020-11-27 00:00:00 | 2020/21 | 5 | 03INT001 | 277553 | 00078347 | Ireland | Ireland
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -14176
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -793499
58710 | -33375 | -22450
60921 | -352985 | -172334
78026
500084 | -20661 | -24000
500085
500097 | -9195 | -8000
INDEX
2001-11-30 00:00:00 |  |  | 521030.39
2001-12-08 00:00:00
CBS Volume
 |  |  | 198783
Spreadsheet: 854919d1704684732-add-2-hour-grace-period-to-conditional-formatting-formulas-conditional-formatting-sample-with-new-formulas
Sheet: Sheet1

Date/Scheduled Depart time | Start Time | End Time
2023-07-01 10:30:00 | 10:00:00 | 12:29:00 | correct
2023-07-01 10:30:00 | 10:00:00 | 12:30:00 | should be green
2023-07-01 10:30:00 | 10:30:00 | 13:30:00 | should be red 3 hrs past depart time
2023-07-02 01:30:00 | 22:00:00 | 23:48:00 | should be green
2023-07-02 02:30:00 | 01:30:00 | 04:45:00 | should be red
2023-07-02 03:30:00 | 03:29:00 | 04:45:00 | correct
Spreadsheet: rick_buy__32821__NP Daily Marks
Sheet: COB 092001

The New Power Company
Credit Exposure by Enron Entity
As of COB September 20, 2001
Enron Entity | Fin. MTM | Phy. MTM | Sales | Purchases | Net Del. (1) | Net Exp.
Enron Energy Services, Inc. | 4898242 | 43762648 | 301295 | 0
Enron North America Corp. | 50014704 | 5805892 | 7731749 | -804194
Enron Power Marketing, Inc. | 0 | 7870665
Totals
 |  |  |  |  | In Collateral (2) | -109300000
 |  |  |  |  | Treashold (3) | 0
 |  |  |  |  | Total Exposure (4)
(1) Net Del. For EPMI capacity payments have been adjusted to reflect EnPower's marks
(2) Per Master Netting Agreement Collateral in the amount of $109.3MM is applied across Enron Entities
(3) Not in compliance with unrestricted cash covenant
(4) Margin call made on 9/21/01
Spreadsheet: 877066d1723735288-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Install

Installed  On | MarkNo. | Qty (Nos) | [NAME]. | GROSS WEIGHT | Assembly Name
2024-06-23 00:00:00 | QLGF-C2001 | 1
2024-06-23 00:00:00 | QLGF-C2002 | 1
2024-06-24 00:00:00 | QLGF-C2002 | 1
2024-06-23 00:00:00 | QLGF-C2003 | 1
2024-06-24 00:00:00 | QLGF-BM2003 | 1
2024-06-24 00:00:00 | QLGF-BM2004 | 1 |  | 205.7
2024-06-24 00:00:00 | QLGF-HB2005 | 1
2024-06-24 00:00:00 | QLGF-HB2009 | 1
2024-06-25 00:00:00 | QL-1-BM2002 | 1 |  | 673.6
2024-06-25 00:00:00 | QL-1-BM2003 | 1
2024-06-25 00:00:00 | QL-1-BM2004 | 1
Spreadsheet: 780058d1652273569-search-multiple-columns-and-give-back-corresponding-values-forum-q1
Sheet: Sheet1

 |  |  |  |  |  |  | 9
 |  |  |  | Lookup Value |  |  | 2022-05-09 00:00:00 |  |  |  | MONDAY
 | Z3 | Z3 |  | B2 | B2 |  | Start Time |  | End Time
 | Start Time | End Time |  | Start Time | End Time |  | MORNING |  |  |  | 02M1 | 02M2 | 02M4 | MR01
 |  |  |  |  |  |  | 09:00:00 | — | 10:30:00
 |  |  |  |  |  |  | 10:45:00 | — | 12:15:00 |  | B2 | C2 | P3 | B1
 |  |  |  |  |  |  | 12:30:00 | — | 14:00:00 |  | Z1 | P3 | B1 | P1
 |  |  |  |  |  |  | 14:15:00 | — | 15:45:00
 |  |  |  |  |  |  | NOON |  |  |  | RM + TR1
 |  |  |  |  |  |  | 14:00:00 | — | 14:30:00 |  | P1
 |  |  |  |  |  |  | 14:30:00 | — | 15:00:00 |  | Z3
 |  |  |  |  |  |  | 15:00:00 | — | 15:30:00 |  | B2
 |  |  |  |  |  |  | 15:30:00 | — | 16:00:00 |  | [NAME]
 |  |  |  |  |  |  | EVENING |  |  |  | 02M3 | 02M5 | 02M6 | 02M7 | 02M8
 |  |  |  |  |  |  | 16:15:00 | — | 17:45:00 |  | Z3 | C2 | P2 | Z1 | B2
 |  |  |  |  |  |  | 18:00:00 | — | 19:30:00 |  | Z3 | P2 | B1 | C2 | Z1
 |  |  |  |  |  |  | S.B. PATIL |  |  |  | S.B. | PATIL
 |  |  |  |  |  |  | 10:50:00 | — | 12:20:00 |  | C4
 |  |  |  |  |  |  | 12:30:00 | — | 14:15:00 |  | C4 | B2
 |  |  |  |  |  |  | SNBP |  |  |  | SNBP
 |  |  |  |  |  |  | 11:00:00 | — | 12:30:00 |  | C4
 |  |  |  |  |  |  | 12:45:00 | — | 14:15:00 |  | C4
 |  |  |  |  |  |  | MAMCHAR |  |  |  | FS | OYM | TYM | CCM | 8TH | 9TH | 10TH
 |  |  |  |  |  |  | 11:00:00 | — | 12:30:00
 |  |  |  |  |  |  | 12:45:00 | — | 14:15:00 |  |  |  |  | B1 | B1 | B1 | B1
 |  |  |  |  |  |  | 14:30:00 | — | 16:00:00 |  |  |  |  | P1 | P1 | P1 | P1
 |  |  |  |  |  |  | 16:15:00 | — | 17:45:00 |  |  |  |  | B2
 |  |  |  |  |  |  | 18:00:00 | — | 19:30:00
Spreadsheet: 119289d1314299782-conditional-formatting-jw01-2011-08-25
Sheet: Sheet1

aaa | bbb | [NAME] | ddd | eee | 1 | 0.05 | hhh
aaa | bbb | [NAME] | ddd | eee | 10 | 0.08 | hhh
aaa | bbb | [NAME] | ddd | eee | 2 | 0.02 | hhh
aaa | bbb | [NAME] | ddd | eee | 9 | 0.03 | hhh
aaa | bbb | [NAME] | ddd | eee | 3 | 0.04 | hhh
aaa | bbb | [NAME] | ddd | eee | 8 | 0.05 | hhh
aaa | bbb | [NAME] | ddd | eee | 4 | 0.03 | hhh
aaa | bbb | [NAME] | ddd | eee | 7 | 0.04 | hhh
aaa | bbb | [NAME] | ddd | eee | 5 | 0.06 | hhh
aaa | bbb | [NAME] | ddd | eee | 6 | 0.01 | hhh
Spreadsheet: 1b2d452c-bf17-423a-868c-c083b3d39b8a
Sheet: Code Sheet

 |  | SFY 2014 UNREIMBURSABLE NONFEDERAL  SPECIAL EDUCATION EXPENDITURES CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk
UFARS Finance Dimensions (FIN) to EDRS Funding Source Codes (FSC)
UFARS FIN | EDRS FSC | [NAME]
317 | a | Unreimbursable Nonfederal Special Education Expenditures
335 | a | Unreimbursable Nonfederal Special Education Expenditures
372 | a | Unreimbursable Nonfederal Special Education Expenditures
740 | a | Unreimbursable Nonfederal Special Education Expenditures
741 | a | Unreimbursable Nonfederal Special Education Expenditures
799 | a | Unreimbursable Nonfederal Special Education Expenditures
UFARS Object Codes to EDRS Service Codes
UFARS OBJECT CODE | EDRS SERVICE CODE | [NAME]
See PTC | A | Payroll Personnel (Salaries Only)
305 | b | Contracted Personnel/Agency Services for Staff
365/366 | F | Travel & Travel Chargeback
430 | h | Non-Individualized Instructional Supplies
401 | I | Office Supplies and Materials
320 | K | Electronic Communication Services
195-295 & 397 | L | Fringe Benefits
329 | M | Dissemination
530 | O | Equipment for Office Supervision/ Management
820 | R | Dues/Membership (use with Activity Code V)
See PTC | U | Purchase of Services (salaried personnel from other districts)
401/430 | u | Purchase of Instrictional Supplies/Material
UFARS Object Codes to EDRS Personnel Type Code
Payroll Personnel - SERVICE CODE A
UFARS OBJECT CODE | EDRS PTC | [NAME] | EDRS SERVICE CODE
110 | 9 | Director of Special Education | A
110 | 10 | Assistant Director/Supervisor | A
170 | 22 | Secretary | A
UFARS Object Codes to EDRS Personnel Type Code
Contracted Services - SERVICE CODE b
UFARS OBJECT CODE | EDRS PTC | [NAME] | EDRS SERVICE CODE
305 | 9 | Director of Special Education | b
305 | 10 | Assistant Director/Supervisor | b
305 | 22 | Secretary | b
UFARS Object Codes to EDRS Personnel Type Code
Purchase of Services (Salaried Personnel from other Districts) - SERVICE CODE U
UFARS OBJECT CODE | EDRS PTC | [NAME] | EDRS SERVICE CODE
396 | 9 | Director of Special Education | U
396 | 10 | Assistant Director/Supervisor | U
396 | 22 | Secretary | U
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
401 | 401 | Speech or Language Impairments
402 | 402 | Developmental Cognitive Disability - Mild -Moderate
403 | 403 | Developmental Cognitive Disability - Severe-Profound
404 | 404 | Physically Impaired
405 | 405 | Deaf and Hard of Hearing
406 | 406 | Visually Impaired
407 | 407 | Specific Learning Disability
408 | 408 | Emotional or Behavioral Disorders
409 | 409 | Deaf-Blind
410 | 410 | Other Health Disabilities
411 | 411 | Autism Spectrum Disorders
412 | 412 | Developmentally Delayed
414 | 414 | Traumatic Brian Injury
416 | 416 | Severely Multiply Impaired
420 | 420 | Special Education - Aggregate (3 or more Disabilities)
 | EDRS Activity Codes
 | Activity code | [NAME]
 | V | Professional Membership/Dues Expenses (use with Service code R)
 | EDRS Time Unit Type Codes
 | Time Unit Type Codes | [NAME]
 | D | Days Worked
 | H | Hours Worked
Spreadsheet: 213195d1360367982-darts-scoreboard-cricket-game-cricketsol2
Sheet: Sheet1

 |  | Player 1
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5 | rd 6 | rd 7 | rd 8 | rd 9 | rd 10 | rd 11 | rd 12 | rd 13 | rd 14 | rd 15 | rd 16 | rd 17 | rd 18 | rd 19 | rd 20 | rd 21 | rd 22 | rd 23 | rd 24 | rd 25 | rd 26 | rd 27 | rd 28 | rd 29 | rd 30 | rd 31 | rd 32 | rd 33 | rd 34 | rd 35 | rd 36 | rd 37 | rd 38 | rd 39 | rd 40
 | Dart 1 | t20 | t19
 | Dart 2 | t20 | t18
 | Dart 3 | 20 | t18
 |  |  |  |  | 0
 | Times
 |  |  |  |  | 0
 | Value
 | points
 |  |  |  |  | 0
 |  | 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
25
20
19
18
17
16
15
 |  | Player 2
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5 | rd 6 | rd 7 | rd 8 | rd 9 | rd 10 | rd 11 | rd 12 | rd 13 | rd 14 | rd 15 | rd 16 | rd 17 | rd 18 | rd 19 | rd 20 | rd 21 | rd 22 | rd 23 | rd 24 | rd 25 | rd 26 | rd 27 | rd 28 | rd 29 | rd 30 | rd 31 | rd 32 | rd 33 | rd 34 | rd 35 | rd 36 | rd 37 | rd 38 | rd 39 | rd 40
 | Dart 1 | t19 | t17
 | Dart 2 | t19 | t17
 | Dart 3 | 19 | 17
 | Times
 |  |  |  |  | 0
 | Value
 | points
 |  | 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
25
20
19
18
17
16
15
501 |  |  | 301 |  |  | Cricket |  |  |  |  |  |  |  | High Dart |  |  | High Throw
Player 1 | Player2 |  | Player 1 | Player 2 |  | board | Player 1 | count | points | Player 2 | count | points |  | Player 1 | Player 2 |  | Player 1 | Player 2
 |  |  |  |  |  | 25 | 25 |  |  | 25
 |  |  |  |  |  | 20 | 20 |  |  | 20
 |  |  |  |  |  | 19 | 19 |  |  | 19
 |  |  |  |  |  | 18 | 18 |  |  | 18
 |  |  |  |  |  | 17 | 17 |  |  | 17
 |  |  |  |  |  | 16 | 16 |  |  | 16
 |  |  |  |  |  | 15 | 15 |  |  | 15
 |  |  |  |  |  | Closed
 |  |  |  |  |  | Scoring
 |  |  |  |  |  | Open
Spreadsheet: 803807d1667720850-how-to-insert-timestamp-in-excel-when-cell-changes-bookk1
Sheet: Daily Briefing

 |  |  |  | ABU DHABI SHOWROOM DAILY BREIFING
 |  | SHOWROOM SOP |  |  |  |  |  |  |  |  | ENTRY DATE |  | CUSTOMER FEEDBACK / CSD |  |  |  |  |  |  |  |  | ENTRY DATE
 |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  | DATE
 |  | Sold Products Must Have A Sold Tag Immediately After It Is Sold Or Blocked |  |  |  |  |  |  |  |  |  |  | Product Inquiry To Be Updated On The Same Day Of Inquiry
 |  | [NAME] To Be In Caps Letters |  |  |  |  |  |  |  |  |  |  | Pending Proforma Follow Ups
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer concerns,complaints & Feedback
 |  | PEOPLE / TRAINING |  |  |  |  |  |  |  |  | ENTRY DATE |  | VISUAL MERCHANDISE / PRODUCTS |  |  |  |  |  |  |  |  | ENTRY DATE
 |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  | DATE
 |  | Bath Collection Presenatation By [NAME]. |  |  |  |  |  |  |  |  |  |  | New Lh Pricelist With New Bar
 |  | Markdown Sales Products Grey Loucious Can Be Sold On Soa |  |  |  |  |  |  |  |  |  |  | New Pricelist Aro
 |  | [NAME] 15% Discount With Emirates Id |  |  |  |  |  |  |  |  |  |  | New Fef Price List.
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] As Is Basis
 |  | Dubai Half Marathon & 10 Km. Please Register If Interested
Spreadsheet: 741264d1626942631-help-on-xlookup-formula-with-multiple-criteria-book1
Sheet: PRODUCT

 |  |  | PRICE CATEGORY: PRICES PER PIECE
 | FRUIT | QTY PER PACKAGE | DISTRIBUTOR | TRADE | RETAIL
 | APPLE | 5 | 5 | 6 | 10
 | ORANGE JUICE | 1 | 10 | 12 | 15
 | [NAME] | 1 | 7 | 8 | 14
 | MANGO | 3 | 7 | 8 | 15
 | STRAWBERRY | 10 | 1 | 2 | 5
Spreadsheet: 847990d1698811448-formula-to-pickup-numbers-from-string-formula-needed-v2
Sheet: Sheet1

First Name | Last Name | Ticket date | Ticket Type | Language | Price | Remarks | Results
[NAME] | Joel | 2023-05-23 00:00:00 | Event | EN | 100 | Your ticket 124255 is pending | Your ticket 124255 is pending
[NAME] | [NAME] | 2023-07-19 00:00:00 | Show | EN | 100 | Your ticket 237171 is approved | 237171
[NAME] | [NAME] | 2023-10-08 00:00:00 | Show | EN | 100 | Your ticket 124268 is closed | Your ticket 124268 is closed
Spreadsheet: 868242d1714989357-lookup-table-with-lookup-reference-with-comma-separated-values-please-help-1-
Sheet: Sheet1

References Table |  |  |  |  | Desired Table
No. | Service Tag | Prices |  |  | Services Tag | Prices
1 | ABC123,UK90,PFX343 | 47.99 |  | example | PFX343 | 47.99 |  |  | 47.99
2 | XXC475,OPR767,AVX314,ANX715 | 18 |  |  | PUP117 | 20.45 |  | UK90 | 47.99
3 | PTY370 | 1.79 |  |  | PTY370 | 1.79 |  | PFX343 | 47.99
4 | PUP117,PIP190 | 20.45 |  |  | … | … |  | XXC475 | 18
5 | A7XYU | 19.9 |  |  | … | … |  | OPR767 | 18
 |  |  |  |  | … | … |  | AVX314 | 18
 |  |  |  |  | … | … |  | ANX715 | 18
 |  |  |  |  | … | … |  | PTY370 | 1.79
 |  |  |  |  | … | … |  | PUP117 | 20.45
 |  |  |  |  | … | … |  | PIP190 | 20.45
 |  |  |  |  | … | … |  | A7XYU | 19.9
Spreadsheet: 50f46f4e-8029-4fe7-a77b-352bef685b09
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: |  |  | 2014-02-28 09:34:34.100000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.692 | 102.567 | 102.442 | 102.067
4.5 | 101.78 | 101.655 | 101.53 | 101.155 |  | Note: | Refer To Price [NAME]
4.375 | 100.815 | 100.69 | 100.565 | 100.19 |  |  | For all Price Adjs
4.25 | 100.204 | 100.079 | 99.954 | 99.329
4.125 | 99.385 | 99.26 | 99.135 | 98.51
4 | 98.37 | 98.245 | 98.12 | 97.495
3.875 | 97.321 | 97.196 | 97.071 | 96.446
3.75 | 96.446 | 96.321 | 96.196 | 95.571
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.654 | 102.529 | 102.404 | 102.029
3.75 | 102.557 | 102.432 | 102.307 | 101.932
3.625 | 102.155 | 102.03 | 101.905 | 101.53
3.5 | 101.579 | 101.454 | 101.329 | 100.704
3.375 | 100.829 | 100.704 | 100.579 | 99.954
3.25 | 100.04 | 99.915 | 99.79 | 99.165 |  | 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 | 2014-03-14 09:34:34.100000
30 DAY | 2014-03-29 09:34:34.100000
45 DAY | 2014-04-13 09:34:34.100000
60 DAY | 2014-04-28 09:34:34.100000
90 DAY | 2014-05-28 09:34:34.100000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 93a00cae-30bb-42d3-b114-38b1d6865535
Sheet: Sheet1

Release: Chicago Fed National Activity Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=219
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-21 3:45 AM CDT
 | Real-Time | Period
Name: | Start | End
Chicago Fed National Activity Index | 2011-05-23 00:00:00 | Current
Link:
http://www.chicagofed.org/webpages/publications/cfnai/index.cfm | 2011-05-23 00:00:00 | Current
Source:
Federal Reserve Bank of Chicago | 2011-05-23 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-05-23 00:00:00
2011-06-23 00:00:00
2011-07-25 00:00:00
2011-08-22 00:00:00
2011-09-26 00:00:00
2011-10-24 00:00:00
2011-11-21 00:00:00
2011-12-22 00:00:00
2012-01-26 00:00:00
2012-02-21 00:00:00
2012-03-26 00:00:00
2012-04-26 00:00:00
2012-05-21 00:00:00
2012-06-25 00:00:00
2012-07-23 00:00:00
2012-08-20 00:00:00
2012-09-24 00:00:00
2012-10-25 00:00:00
2012-11-26 00:00:00
2012-12-21 00:00:00
2013-01-22 00:00:00
2013-02-25 00:00:00
2013-03-25 00:00:00
2013-04-22 00:00:00
2013-05-20 00:00:00
2013-06-24 00:00:00
2013-07-22 00:00:00
2013-08-20 00:00:00
2013-09-23 00:00:00
2013-11-12 00:00:00
2013-11-27 00:00:00
2013-12-23 00:00:00
2014-01-23 00:00:00
2014-02-24 00:00:00
2014-03-24 00:00:00
2014-04-21 00:00:00
Spreadsheet: 785768d1656679684-formula-to-rearranging-inputs-with-required-output-sample1
Sheet: Sheet2

 | Input
 | User | Test_Name
 | A | VITAMIN D (25-OH), VITAMIN B 12, HITECH COMPLETE BLOOD COUNT, CREATININE, POTASSIUM ( K +), GLUCOSE (FASTING), URIC ACID |  |  | Why I was not able to count the ","
 | Required Output
 | User | Test_Name | Required formula to get the below desire output
 | A | VITAMIN D (25-OH)
 | A | VITAMIN B 12
 | A | HITECH COMPLETE BLOOD COUNT
 | A | CREATININE
 | A | POTASSIUM ( K +)
 | A | GLUCOSE (FASTING)
 | A | URIC ACID
Spreadsheet: 858514d1707167969-comments-or-notes-on-calendar-calendar-1-month-per-tab
Sheet: February

 |  | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00
 |  | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00
 |  | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00
 |  | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00
 |  | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00 | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00
 |  | 2024-03-05 00:00:00 | NOTES