tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 202b7052-0b3c-4e3b-974a-c44810e48653
Sheet: Total US by Qtr & Year

 |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association
 |  |  |  |  | MoneyTree™ Report, Data: Thomson Reuters
 |  |  |  |  | Total U.S. Investments by Year Q1 1995 - Q4 2011
Quarter | 1995 |  | 1996 |  | 1997 |  | 1998 |  | 1999 |  | 2000 |  | 2001 |  | 2002 |  | 2003 |  | 2004 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010 |  | 2011
 | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested
1 | 504 | 1578285900 | 585 | 2197153200 | 774 | 2874050000 | 868 | 3822578500 | 935 | 5976254500 | 2168 | 27140038200 | 1315 | 12321056700 | 858 | 6478518000 | 721 | 4122584900 | 731 | 5213515500 | 753 | 5091992400 | 895 | 6404879700 | 892 | 7239963100 | 1047 | 7930923700 | 665 | 3767991900 | 797 | 5154823200 | 849 | 6613076100
2 | 464 | 2458149300 | 675 | 2969556500 | 777 | 3513430500 | 916 | 5320829300 | 1331 | 10097423800 | 2134 | 26294368600 | 1241 | 10585000200 | 875 | 5850644200 | 748 | 4751801600 | 873 | 6050596300 | 854 | 6226888500 | 997 | 7096668200 | 1085 | 7433549800 | 1089 | 9359935600 | 747 | 4793919500 | 1011 | 7190818700 | 1027 | 7960333500
3 | 432 | 1540843700 | 603 | 2389487200 | 758 | 3610311200 | 925 | 4853606400 | 1443 | 12868188600 | 1952 | 25242372300 | 1024 | 7620854200 | 705 | 4301640700 | 729 | 4385775800 | 708 | 4856128200 | 806 | 5932087100 | 940 | 6694961600 | 1033 | 7981091200 | 1031 | 7284305800 | 735 | 5290087600 | 857 | 5399133200 | 953 | 7285835100
4 | 489 | 1736167700 | 774 | 3012210300 | 915 | 4138758500 | 1019 | 5783191500 | 1881 | 22386835000 | 1778 | 20481632200 | 1002 | 7538409300 | 745 | 4219025700 | 806 | 5353671400 | 866 | 6235027800 | 849 | 5694747800 | 995 | 6397658200 | 1114 | 8171706100 | 944 | 5970350500 | 918 | 5893811700 | 861 | 5518529900 | 844 | 6565830700
Grand Total | 1889 | 7313446600 | 2637 | 10568407200 | 3224 | 14136550200 | 3728 | 19780205700 | 5590 | 51328701900 | 8032 | 99158411300 | 4582 | 38065320400 | 3183 | 20849828600 | 3004 | 18613833700 | 3178 | 22355267800 | 3262 | 22945715800 | 3827 | 26594167700 | 4124 | 30826310200 | 4111 | 30545515600 | 3065 | 19745810700 | 3526 | 23263305000 | 3673 | 28425075400
 | Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 456546d1460936535-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-a
Sheet: WED - VOLUNTEER

YOGH | [NAME] |  |  | SOUP | SAUS | CHICK |  |  | CHICK F | CHICKEN FILLET |  |  |  | BEEF | QUICHE |  |  |  |  |  |  |  | BEEF | QUICHE
B O T T O M |  |  |  |  |  |  |  |  | MIDDLE |  |  |  |  |  |  |  |  | TOP
NAME | ADDRESS | JUICE | DESSERT | SOUP | CURRY SAUSAGES | CRUMBED CHICKEN |  |  | NAME | ADDRESS | JUICE |  |  |  |  | SPECIAL ITEMS |  | NAME | ADDRESS | JUICE |  |  |  |  | SPECIAL ITEMS
PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS
 |  | OJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  | NO JUICE |  |  |  |  |  |  | MOFFAT |  | OJ | YOGHURT |  | CURRY SAUSAGES |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
LANGLANDS |  | NO JUICE | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE | [NAME]
 |  |  |  |  |  |  |  |  |  |  | AJ
 |  | AJ |  |  |  |  |  |  |  |  | NO JUICE
 |  | AJ |  |  |  |  |  |  |  |  | AJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  | NO JUICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | OJ |  |  |  |  |  |  |  |  | OJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JONES |  |  |  |  | CURRY SAUSAGES
 |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | OJ
 |  |  |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  | ROBINSON |  | AJ | YOGHURT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ
PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET
PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM
Spreadsheet: 93478d1293042401-help-with-sum-only-if-meets-both-criteria-11-2010-ot-stats
Sheet: Sheet1

2010-11-01 00:00:00 | C1ATO | 830 | 900
2010-11-01 00:00:00 | C1ATO | 900 | 1000
2010-11-01 00:00:00 | C2 ATO | 900 | 1000
2010-11-01 00:00:00 | C2 ATO | 1400 | 2200
2010-11-02 00:00:00 | C2 ATO | 2000 | 2030
2010-11-02 00:00:00 | C2 ATO | 1700 | 1900
2010-11-02 00:00:00 | C2 ATO | 1330 | 1830
2010-11-03 00:00:00 | TERM A ATO | 1000 | 1400
2010-11-03 00:00:00 | [NAME] | 900 | 930
2010-11-03 00:00:00 | C1ATO | 900 | 930
2010-11-03 00:00:00 | C1ATO | 900 | 930
2010-11-03 00:00:00 | C3ATO | 900 | 1000
2010-11-03 00:00:00 | TA | 1700 | 1800
2010-11-03 00:00:00 | TA | 2030 | 2130
2010-11-03 00:00:00 | TA | 1800 | 1830
2010-11-03 00:00:00 | TA | 1530 | 1730
2010-11-03 00:00:00 | TA | 1630 | 1930
2010-11-03 00:00:00 | C1 | 1600 | 1730
2010-11-03 00:00:00 | C1 | 1730 | 1930
2010-11-03 00:00:00 | C1 | 2000 | 2200
2010-11-04 00:00:00 | TERM A ATO | 930 | 1130
2010-11-04 00:00:00 | TERM A ATO | 930 | 1200
2010-11-04 00:00:00 | C2 ATO | 1900 | 2100
2010-11-04 00:00:00 | C2 ATO | 1530 | 1600
2010-11-04 00:00:00 | C2 ATO | 1500 | 1700
2010-11-04 00:00:00 | C2 ATO | 1730 | 1830
2010-11-04 00:00:00 | C2 ATO | 1700 | 2100
2010-11-04 00:00:00 | C2 ATO | 1400 | 1600
2010-11-05 00:00:00 | C3ATO | 930 | 1000
2010-11-05 00:00:00 | C2 ATO | 800 | 1300
2010-11-05 00:00:00 | C2 ATO | 1000 | 1400
2010-11-05 00:00:00 | C3ATO | 900 | 930
2010-11-05 00:00:00 | TA | 2030 | 2230
2010-11-05 00:00:00 | TA | 2130 | 2300
2010-11-05 00:00:00 | TA | 2200 | 2300
2010-11-05 00:00:00 | TA | 2130 | 2200
2010-11-05 00:00:00 | TA | 2130 | 2200
2010-11-05 00:00:00 | [NAME] | 1600 | 1630
2010-11-05 00:00:00 | [NAME] | 1900 | 2000
2010-11-05 00:00:00 | [NAME] | 2100 | 2130
2010-11-06 00:00:00 | C2 ATO | 1200 | 1230
2010-11-06 00:00:00 | C2 ATO | 1000 | 1030
2010-11-06 00:00:00 | C2 ATO | 12:00:00 | 14:00:00
2010-11-06 00:00:00 | C2 ATO | 12:00:00 | 14:00:00
2010-11-06 00:00:00 | C2 ATO | 1904-12-04 00:00:00 | 1905-06-22 00:00:00
2010-11-06 00:00:00 | C2 ATO | 1905-03-14 00:00:00 | 1905-06-22 00:00:00
2010-11-06 00:00:00 | C2 ATO | 1904-12-04 00:00:00 | 1905-04-13 00:00:00
2010-11-07 00:00:00 | C3ATO | 930 | 1000
2010-11-07 00:00:00 | C1ATO | 1330 | 1530
2010-11-07 00:00:00 | C1ATO | 1200 | 1500
2010-11-07 00:00:00 | C1ATO | 1200 | 1330
2010-11-07 00:00:00 | C1ATO | 1400 | 1500
2010-11-07 00:00:00 | C1ATO | 930 | 1000
2010-11-07 00:00:00 | C1ATO | 900 | 1100
2010-11-07 00:00:00 | C1ATO | 1200 | 1330
2010-11-07 00:00:00 | C3ATO | 1902-07-18 00:00:00 | 1902-09-26 00:00:00
2010-11-07 00:00:00 | C2 ATO | 1600 | 2000
2010-11-07 00:00:00 | [NAME] | 16:30:00 | 19:30:00
2010-11-07 00:00:00 | [NAME] | 17:30:00 | 19:30:00
2010-11-07 00:00:00 | [NAME] | 17:30:00 | 19:30:00
2010-11-07 00:00:00 | [NAME] | 18:30:00 | 20:30:00
2010-11-07 00:00:00 | [NAME] | 21:00:00 | 22:00:00
2010-11-07 00:00:00 | [NAME] | 22:30:00 | 23:00:00
11/8//10 | C1ATO | 1902-06-18 00:00:00 | 1902-09-26 00:00:00
2010-11-08 00:00:00 | C3ATO | 1903-10-31 00:00:00 | 1904-03-09 00:00:00
2010-11-08 00:00:00 | C3ATO | 1903-01-04 00:00:00 | 1903-07-23 00:00:00
Spreadsheet: 459388d1462552000-conditional-formatting-or-workbook-sub-example
Sheet: Sheet3

Breaker-A-04 | 208 | 24 | 6.7 | -17.3
Breaker-A-03 | 208 | 16 | 16.3 | 0.3
Breaker-A-01 | 208 | 24 | 3.5 | -20.5
Breaker-A-02 | 208 | 24 | 25.9 | 1.9
BreakerX-A-02 | 208 | 24 | 0 | -24
BreakerX-A-01 | 208 | 32 | 0 | -32
BreakerX-A-03 | 208 | 24 | 0 | -24
Spreadsheet: 867793d1714578978-substitute-with-array-of-criteria-substitute-with-array-of-criteria_v2
Sheet: Sheet1

 | Data |  |  | Criteria to remove in data set |  |  |  | Required Output |  | [NAME] |  | Spill |  | MAP |  | MAP
 | text1 abc |  |  | text1 |  |  |  | abc
 | def [NAME] text1 |  |  | text2 |  |  |  | def |  |  |  | def |  | #[NAME]! |  | def |  | def
 | 39734 sdlkdjs - text3 |  |  | - text3 |  |  |  | 39734 sdlkdjs |  |  |  | 39734 sdlkdjs |  | #[NAME]! |  | 39734 sdlkdjs |  | 39734 sdlkdjs
 | sksj [NAME] (50 mins) |  |  | (50 mins) |  |  |  | sksj [NAME] |  |  |  | sksj [NAME] |  | #[NAME]! |  | sksj [NAME] |  | sksj [NAME]
 | sksj [NAME] (50 mins) |  |  | text4 |  |  |  | sksj [NAME] |  |  |  | sksj [NAME] |  | #[NAME]! |  | sksj [NAME] |  | sksj [NAME]
 | (50 mins) ghi moretext |  |  | moretext |  |  |  | ghi |  |  |  | ghi |  | #[NAME]! |  | ghi |  | ghi
 | text1 - text3 jkl |  |  |  |  |  |  | jkl |  |  |  | jkl |  | #[NAME]! |  | jkl |  | jkl
Spreadsheet: 0f8f4635-3fb0-43f2-9042-96f2259f1a7a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PFRUT | Test | PFRUT | Passion Fruit, IgE | Passion Fruit, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m. Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PFRUT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PFRUT | Result | PFRUT | Passion Fruit, IgE | Passion Fruit, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10946-2 | Passiflora edulis [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Pacing In Transit 

Quarter | 3
Shipment Value (USD) |  |  |  |  |  |  | Pacing Risk
Region | Power Station | Shipment Status | WBS | Delivery Note | Mode of Transport | ETA SA | [NAME] | Cash In | Grand Total
France | Koeberg | Eskom : Await Transport PO | ES0-473163 | PKL 104545 | (blank) | TBA | 162400 |  | 162400
France | Lethabo | Eskom : In Transit | ES0-473201 | S809248/203169 | SEA | 2020-10-16 00:00:00 |  | 1059394.56 | 1059394.56
France | Lethabo | Eskom : In Transit | ES0-473201 | S809248/203169-1 | SEA | 2020-10-16 00:00:00 |  | 6627.040000000001 | 6627.040000000001
France | Lethabo | Eskom : In Transit | ES0-473200 | 80605495 | AIR | TBA | 216660.9984 |  | 216660.9984
France | Matimba | Eskom : In Transit | ES0-473267 | 80605409 | AIR | 2020-09-11 00:00:00 |  | 17875.2 | 17875.2
Germany | [NAME] | Eskom : Await Transport PO | ES0-473399 | 80607698 | (blank) | TBA | 105315.3472 |  | 105315.3472
Germany | [NAME] | Eskom : In Transit | ES0-473398 | 80605925 | AIR | 2020-09-12 00:00:00 |  | 4773.2832 | 4773.2832
Germany | [NAME] | Eskom : In Transit | ES0-473398 | 80605544 | AIR | 2020-09-12 00:00:00 |  | 10444.9184 | 10444.9184
Germany | Matimba | Eskom : In Transit | ES0-473351 | 80606957 | AIR | 2020-09-19 00:00:00 |  | 80925.5104 | 80925.5104
Germany | Matimba | Eskom : In Transit | ES0-473310 | 80605748 | AIR | 2020-09-19 00:00:00 |  | 17782.016 | 17782.016
Germany | Matimba | Eskom : In Transit | ES0-473353 | 80606959 | AIR | 2020-09-19 00:00:00 |  | 36415.68 | 36415.68
Germany | Matimba | Eskom : In Transit | ES0-472892 | 80607829 | AIR | 2020-09-19 00:00:00 |  | 6236.160000000001 | 6236.160000000001
Grand Total |  |  |  |  |  |  | 484376.3456000001 | 1240474.368 | 1724850.7136
Spreadsheet: 834739d1688046774-help-with-a-byrow-pb_byrow
Sheet: Feuil1

label+list1 |  |  |  |  |  |  |  | label | list2
Structure≡≡wires,[NAME],sushi,powder||Size≡≡30||Purity≡≡H |  |  |  |  |  |  |  | Structure | tubes
 |  |  |  |  |  |  |  | Form | paste,powder
 |  |  |  |  |  |  |  | Size
 |  |  |  |  |  |  |  | Another | nothing
 |  | A |  |  |  | B |  |  |  | C
 |  | label | list1 | list2 |  | missing (BYROW does not work) |  |  |  | missing (BYROW works)
 |  |  | wires,rods | tubes
 |  | Form | pasta,sushi,powder | paste,powder |  | pasta |  |  |  | pasta, sushi |  |  | pasta, sushi
Spreadsheet: 272123d1382215474-date-query-problem-question-book2
Sheet: Sheet2

2013-11-04 00:00:00 | TOTAL |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-05 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-06 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-07 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-08 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-09 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
2013-11-10 00:00:00 |  |  |  |  | 75 | 75 | 9000 |  |  | 1500 | 6840 | 105 | 0 | 105 | 0 | 0 | 6825 | 27000 | 3.956043956043956 | 3345 | 44.6
Spreadsheet: 293947d1391141547-best-way-to-aggregate-scores-xl4m
Sheet: Sheet1

Date of Birth | 2.01 | Must be before Date Joined Company | 0.9995927304249055 | 0.0004072695750945314 | 267636 | 109
 | 2.02 | Must be before Service Start Date | 0.9993722817558176 | 0.000627718244182397 | 267636 | 168
 | 2.03 | Possible dummy date of birth | TBD | TBD
 | 2.04 | Must be before Date Joined Fund | 0.9999551629825583 | 4.48370174415998e-05 | 267636 | 12
 | 2.05 | Must not be in the future | 0.9999962635818799 | 3.7364181201334e-06 | 267636 | 1
 | 2.06 | Must be more than 14 years and 9 months ago | 0.999861752529555 | -0.009861752529555068 | 267636 | 37
 | 2.07 | DOB must not be null | 0.999891655614294 | 0.0001083443857060132 | 267665 | 29
 | 2.08 | Should not be more than 90 years ago | 0.9999850543275194 | 1.49456724805333e-05 | 267636 | 4
 | 2.09 | Cannot be less than 14 years and 9 months before Date Joined Fund | 0.9979225515252058 | -0.007922551525205877 | 267636 | 556
Spreadsheet: 703445d1605006452-countif-range-of-cells-contains-text-from-column-a-countif-range
Sheet: Hoja1

 | Titular | Suplente | Banquillo |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Javier |  |  |  |  | Alboraya 0 - 0 Alzira | [NAME]
Mario |  |  |  |  | 13 Javier (P) | 1 Chover (P)
Dídac |  |  |  |  | 2 Mario | 2 Mario
PEPE |  |  |  |  | 3 Dídac | 3 Dídac  75'
Savall |  |  |  |  | 4 PEPE | 4 PEPE
 |  |  |  |  | 5 Savall (C) | 5 Savall (C)
 |  |  |  |  | 6 Victor | 6 Victor
 |  |  |  |  | 7 Sergio  85' | 7 Sergio
 |  |  |  |  | 8 Israel  71' | 8 Israel  56'
 |  |  |  |  | 9 [NAME]  71' | 9 [NAME]  67'
 |  |  |  |  | 10 Iker  75' | 10 Iker  75'
 |  |  |  |  | 11 Victor | 11 Victor
 |  |  |  |  | Suplentes | Suplentes
 |  |  |  |  |  | [NAME] "A"
 |  |  |  |  | 1 Chover | 12 Diego
 |  |  |  |  | 12 Diego | 13 Javier
 |  |  |  |  | 14 [NAME]75' | 14 Francesc
 |  |  |  |  | 15 Francesc | 15 Adrian  56'
 |  |  |  |  | 16 Adrian  71' | 16 Mario  67'
 |  |  |  |  | 17 Mario  85' | 17 [NAME]
 |  |  |  |  | 18 Miguel  71' | 18 [NAME]75'
 |  |  |  |  |  | 19 Sergio  75'
 |  |  |  |  |  | 20 Lucas
Spreadsheet: 115116d1310735443-words-hidden-inside-other-words-matchmulticriteriainstring
Sheet: Sheet1

String to search | Any Result | Contained within a word |  | Words to find
This is the street Ilive in | STREET |  |  | STREET
I live in a house | HOUSE |  |  | HOUSE
[NAME] housecoats are for the rich and famous | HOUSE | HOUSE |  | TREE
The car is next to the houses. | HOUSE |  |  | PEOPLE
Most people do | PEOPLE |  |  | FLOWER
The garden has flowers | FLOWER | FLOWER |  | CAR
Do you own a car? | CAR | CAR |  | TRACE
Cardboard | CAR | CAR |  | RAC
A carton of milk | CAR | CAR
I like cartoons | CAR | CAR
Okay does this work for you?
Use Evaluate Formula to trace errors | TRACE
Anti-aircraft tracers | TRACE | TRACE
Search single words only
Streetwise | STREET | STREET
Street | STREET
Cardboard | CAR | CAR
Trace | TRACE
Tracer | TRACE | TRACE
Racetrack | RAC | RAC
Spreadsheet: 848480d1699211912-find-total-values-based-on-the-match-a-specific-text-if-and-ifs
Sheet: Sheet1

Statement List
From | 2023-10-01 00:00:00 | To
 | Rent Branch 1 |  | 0 | 100
 | Rent Branch 2 |  | 0 | 100
 |  | 18239.331 |  | 0
11251 | Invoice | 2023-10-09 00:00:00 | 549.5999999999999 | 0
11252 | Invoice | 2023-10-11 00:00:00 | 439.4 | 0
11254 | Invoice | 2023-10-13 00:00:00 | 187.2 | 0
11255 | Invoice | 2023-10-18 00:00:00 | 18 | 0
11257 | Invoice | 2023-10-18 00:00:00 | 48 | 0
11258 | Invoice | 2023-10-18 00:00:00 | 48 | 0
11259 | Invoice | 2023-10-18 00:00:00 | 18 | 0
11260 | Invoice | 2023-10-19 00:00:00 | 533.0999999999999 | 0
11261 | Invoice | 2023-10-20 00:00:00 | 630 | 50
11262-11263 | Invoice | 2023-10-25 00:00:00 | 894.5999999999998 | 0
00221295 | Refund | 2023-10-09 00:00:00 | 200 | 90
00221295 | Refund | 2023-10-09 00:00:00 | 300 | 150
00221295 | Refund | 2023-10-09 00:00:00 | 100 | 400
Total of Invoices
Pending Payment |  |  | 3365.55
Rent Branches & Refunds Ammount
Total
Spreadsheet: 01058f62-35c2-40f7-928a-fd323d06140f
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: |  |  | 2011-10-31 09:34:36.010000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.658 | 101.533 | 101.408 | 101.033
4.25 | 100.931 | 100.806 | 100.681 | 100.306 |  | Note: | Refer To Price [NAME]
4.125 | 100.369 | 100.244 | 100.119 | 99.744 |  |  | For all Price Adjs
4 | 99.902 | 99.777 | 99.652 | 99.027
3.875 | 99.351 | 99.226 | 99.101 | 98.476
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.528 | 101.403 | 101.278 | 100.903
3.75 | 101.083 | 100.958 | 100.833 | 100.458
3.625 | 100.512 | 100.387 | 100.262 | 99.887
3.5 | 100.187 | 100.062 | 99.937 | 99.562
3.375 | 99.778 | 99.653 | 99.528 | 98.903
3.25 | 99.25 | 99.125 | 99 | 98.375
 |  |  |  |  |  | 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 | 2011-11-14 09:34:36.010000
30 DAY | 2011-11-29 09:34:36.010000
45 DAY | 2011-12-14 09:34:36.010000
60 DAY | 2011-12-29 09:34:36.010000
90 DAY | 2012-01-28 09:34:36.010000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 849344d1699876547-formula-to-calculate-amount-payable-at-nth-year-book1
Sheet: FV(2)

PV of first payment |  | 1000000 |  |  | Financial Year | Annual Payment
Assumed increase every 3 years |  |  |  | 1 | 2024-01-01 00:00:00
No of Payment Periods |  | 30 |  | 2 | 2025-01-01 00:00:00
 |  |  |  | 3 | 2026-01-01 00:00:00
Last payment |  |  |  | 4 | 2027-01-01 00:00:00
Error Check 1 |  |  |  | 5 | 2028-01-01 00:00:00
Error Check 2 |  |  |  | 6 | 2029-01-01 00:00:00
 |  |  |  | 7 | 2030-01-01 00:00:00
 |  |  |  | 8 | 2031-01-01 00:00:00
 |  |  |  | 9 | 2032-01-01 00:00:00
 |  |  |  | 10 | 2033-01-01 00:00:00
 |  |  |  | 11 | 2034-01-01 00:00:00
 |  |  |  | 12 | 2035-01-01 00:00:00
 |  |  |  | 13 | 2036-01-01 00:00:00
 |  |  |  | 14 | 2037-01-01 00:00:00
 |  |  |  | 15 | 2038-01-01 00:00:00
 |  |  |  | 16 | 2039-01-01 00:00:00
 |  |  |  | 17 | 2040-01-01 00:00:00
 |  |  |  | 18 | 2041-01-01 00:00:00
 |  |  |  | 19 | 2042-01-01 00:00:00
 |  |  |  | 20 | 2043-01-01 00:00:00
 |  |  |  | 21 | 2044-01-01 00:00:00
 |  |  |  | 22 | 2045-01-01 00:00:00
 |  |  |  | 23 | 2046-01-01 00:00:00
 |  |  |  | 24 | 2047-01-01 00:00:00
 |  |  |  | 25 | 2048-01-01 00:00:00
 |  |  |  | 26 | 2049-01-01 00:00:00
 |  |  |  | 27 | 2050-01-01 00:00:00
 |  |  |  | 28 | 2051-01-01 00:00:00
 |  |  |  | 29 | 2052-01-01 00:00:00
 |  |  |  | 30 | 2053-01-01 00:00:00
 |  |  |  | 31 | 2054-01-01 00:00:00