tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9ed80b53-9d5b-4549-9a25-c4e1182ed4e1
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-03-13 09:31:01.500000
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.375 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.25 | 101.845 | 101.72 | 101.595 | 101.22
4.125 | 101.434 | 101.309 | 101.184 | 100.809 |  | Note: | Refer To Price [NAME]
4 | 100.965 | 100.84 | 100.715 | 100.34 |  |  | For all Price Adjs
3.875 | 100.074 | 99.949 | 99.824 | 99.199
3.75 | 99.261 | 99.136 | 99.011 | 98.386
3.625 | 98.796 | 98.671 | 98.546 | 97.921
 |  |  |  |  |  | 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.625 | 101.704 | 101.579 | 101.454 | 101.079
3.5 | 101.364 | 101.239 | 101.114 | 100.739
3.375 | 100.827 | 100.702 | 100.577 | 100.202
3.25 | 100.185 | 100.06 | 99.935 | 99.56
3.125 | 99.687 | 99.562 | 99.437 | 98.812
3 | 99.343 | 99.218 | 99.093 | 98.468
2.875 | 98.772 | 98.647 | 98.522 | 97.897 |  | 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-03-27 09:31:01.500000
30 DAY | 2012-04-11 09:31:01.500000
45 DAY | 2012-04-26 09:31:01.500000
60 DAY | 2012-05-11 09:31:01.500000
90 DAY | 2012-06-10 09:31:01.500000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 00e20d50-5d6f-4730-b744-aac67f3dfa0b
Sheet: Lancaster

BCTC Master [NAME]
 | MW | MW | MW | MW | MW | MW | MW | MW | MW | TR | TR | TR | TR | TR | TR | TR | TR | TR | F | F | Sat | Sat | Sun
 | 8:00-9:15 | 9:30-10:45 | 11:00-12:15 | 12:30-1:45 | 2:00-3:15 | 3:30-4:45 | 5:00-6:15p | 6:30-7:45p | 8:00-9:15p | 8:00-9:15 | 9:30-10:45 | 11:00-12:15 | 12:30-1:45 | 2:00-3:15 | 3:30-4:45 | 5:00-6:15p | 6:30-7:45p | 8:00-9:15p | 8:00-10:45 | 11:00-1:45 | 9:0-0-11:45 | 1:00-3:45 | 1:00-3:45
Spreadsheet: 759325d1639494924-unique-deduplication-testworksheet-ans
Sheet: Sheet1

Multiple * | FIRST | LAST | Concatenated |  |  | Unique list
 | [NAME] | Doe | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Smith
 | [NAME] | Doe
 | Willy | Wonka
 | George | Smith
 | Alfred | Neuman
 | [NAME] | [NAME]
 | [NAME] | Adams
 | George | Washington
 | [NAME] | Willis
 | [NAME] | Smith
 | [NAME] | Smith
 | Alfred | Neuman
 | MJ | Jones
 | [NAME] | Adams
 | [NAME] | Adams
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Clint | Eastwood
 | J | Doe
 | MJ | Jones
Spreadsheet: kate_symes__18143__Deal Correction 2-12
Sheet:  Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-02-12 00:00:00 | 2001-02-12 00:00:00 | 2001-02-08 00:00:00 | LTNW | MS | Houston | Amerex | Delivery Point: from Palo to SP |  | 517891 | SP-15 | Q3-01 | On [NAME] | 25 | 285 | BP Amoco
 |  |  | MS Count
2001-02-12 00:00:00 | 2001-02-12 00:00:00 | 2001-02-06 00:00:00 | LTSW | KS | Houston | Natsource | Broker fee: from 0 to .015 |  | 515365 | SP-15 | Cal-03 | [NAME] | 25 | 54.05 | EES
 |  |  | KS Count
2001-02-12 00:00:00 | 2001-02-12 00:00:00 | 2001-02-03 00:00:00 | STWH | BM | Houston | N/A | CTPY: from PGET to Pacificorp |  | 513066 | [NAME] | 2001-02-03 00:00:00 | RTC | 2 | 5.84 | Pacificorp
 |  |  | BM Count
 |  |  | Grand Count
Spreadsheet: 889578d1740455113-help-with-formulas-to-calculate-odds-weightss
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Greg
 |  |  | 1 | 1 | 1 | 1 | 1
 | Pgrm # |  | Factors | ACL | AvgSpd | [NAME] | Prm Power |  |  |  |  | Totals | Percentage | Odds |  | Totals | Percentage | Odds
 | 1 |  | 10 | 103.4 | 54.3333333333333 | 107 | 99.2
 | 2 |  | 17 | 109.6 | 71.4 | 107 | 113.3
 | 3 | x
 | 4 |  | 2 | 104.4 | 65.6 | 108 | 98.9
 | 5 | x
 | 6 | x
 | 7 |  | 23 | 106.9 | 70.2 | 109 | 111.5
 | 8 |  | 25.5 | 103.5 | 69 | 103 | 114.5
 | 9 |  | 21 | 107.1 | 71.2 | 107 | 111.5
 | 10 |  | 7 | 106.3 | 72.75 | 0 | 112
 | 11 |  | 0 | 103.3 | 59.6 | 102 | 99
 | 12 |  | 15 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Sum | X | [NAME] |  | Sum | X | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  | Greg
 |  |  | 1 | 1 | 1 | 1 | 1
 | Pgrm # |  | Factors | ACL | AvgSpd | [NAME] | Prm Power |  |  |  |  | Totals | Percentage | Odds |  | Totals | Percentage | Odds
 | 1
 | 2
 | 3 | x
 | 4
 | 5 | x
 | 6 | x
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 |  |  | SUM | SUM | SUM | SUM | SUM |  |  |  |  | Sum | X | [NAME] |  | Sum | X | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | Average | Average | Average | Average | Average
 |  |  | Start Points | Start Points | Start Points | Start Points | Start Points
 |  |  | multiplier | multiplier | multiplier | multiplier | multiplier
Spreadsheet: 65353d1266011630-validate-multiple-date-and-time-for-getting-tat-command-buttons-for-filtering-and-date-and-time-function-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | 12 | 01:59:59
Sr. # | Route File | Route Recd. Date and Time | Route Comp. Date and Time | Search Start Time | Search End Time | On Hold | Search Received | Remaining TAT | Escalated Hour(s) | TAT
1 | XYZ 99986789 | 2010-02-04 07:00:00 | 2010-02-04 10:30:01 | 2010-02-04 20:30:00 | 2010-02-04 22:30:00 | Yes | No | 02:00:00 | 02:00:00 | 1900-01-01 00:00:00
2 | ABC 99799758 | 2010-02-04 07:00:00 | 2010-02-04 10:30:01 |  |  | Yes | No |  |  | 03:30:01
3 | XYZ 12345678 | 2010-02-04 20:00:00 | Pending | 2010-02-04 20:30:00 | 2010-02-04 22:30:00 | Yes | No
4 | ABC 99799758 | 2010-02-04 09:10:00 | Pending | 2010-02-04 09:20:00 | 2010-02-04 10:30:00 | No | No
5 |  |  |  |  |  | No | Yes
6 |  |  |  |  |  | No | Yes
7 |  |  |  |  |  | No | Yes
8 |  |  |  |  |  | No | No
9 |  |  |  |  |  | Yes | No
10 |  |  |  |  |  | No | No
 |  |  |  |  |  |  |  | Thank you for your time and help.
Spreadsheet: 850454d1700781679-comparing-cells-on-multiple-sheets-looking-for-miss-matching-inventory-book2
Sheet: Results

Sku | Matched? | Title Matches | Qty Match | Cost Match
TLG-71017-20 | Yes | Yes | Yes | Yes
TLG-71017-19 | Yes | Yes | No | No
TLG-71017-18 | Yes | Yes | No | No
TLG-71017-Set | No | No | No | No
 | Searches 1-5 sheets matching the Sku. | Based on [NAME] match are titles identical | Based on Sku match are Qty's identical? | Based on [NAME] match are Cost identical?
 | 1 Sheet could be a "Master sheet", but ideally all looking for missing sku's listed on 1 sheet and not on the others.
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Aug

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 51095d1250671961-help-vlookup-in-populating-a-table-priv190809
Sheet: Sheet1

 | A
 | Date | Target | Private/Public | Country | Business Description
 | 2009-07-01 00:00:00 | Daisy Communications Ltd. | Private | UK | Provides communication and business services
 | 2009-06-01 00:00:00 | Carrillion IT Services Ltd | Private | UK | Provides a range of integrated solutions for infrastructure, buildings and services
 | 2009-06-01 00:00:00 | [NAME] | Public | Germany | IT security services provider
 | 2008-12-15 00:00:00 | Axon Group Plc | Public | UK | Consultancy designing, implementing and supporting solutions that address complex business issues on SAP platforms
 | B
 | Date | Target | Private/Public | Country | Business Description
 | C
 | Date | Target | Private/Public | Country | Business Description
 | 2009-07-01 00:00:00 | Daisy Communications Ltd. | Private | UK | Provides communication and business services
 | 2009-06-01 00:00:00 | Carrillion IT Services Ltd | Private | UK | Provides a range of integrated solutions for infrastructure, buildings and services
Spreadsheet: 275432d1383512808-age-bracket-using-lookup-formula-ex123
Sheet: Task 4

 | Price |  | 69.95
 | Number Bought |  | 5
 | Total Price
 | Discount %
 | Discount
 | Discount Price
 | DISCOUNT | TABLE
 | No. Bought | 1 | 5 | 10 | 20 | 30 | 50 | 100
 | Discount | 0 | 0.1 | `15% | 0.25 | 0.4 | 0.45 | 0.5
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339
78311 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
78308 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500238
500239
500293
500302
500303
500305
500307
500313
500314
500655
500657
INDEX
2002-02-28 00:00:00 |  |  | 94952.06
2002-02-28 00:00:00
CBS Volume
 |  |  | 57851
Spreadsheet: 696889d1601025533-how-to-increment-a-columns-cell-reference-by-1-then-by-2-then-by-1-etc-1-then-2-pattern-to-cell-references-new
Sheet: Sheet1

1 |  |  | *+1 cell ref |  |  |  |  | 1 |  | *+1 cell ref
6 |  |  |  |  |  |  |  | 6
9 |  |  |  |  |  |  |  | 9
14 |  |  |  |  | *+4 cell ref |  |  | 14 |  |  |  | *+2 cell ref
7 |  |  | *+1 cell ref |  |  |  |  | 7 |  | *+1 cell ref
8 |  |  |  |  |  |  |  | 8
3 |  |  |  |  |  |  |  | 3
10 |  |  |  |  | *+4 cell ref |  |  | 10 |  |  |  | *+2 cell ref
5 |  |  | *+1 cell ref |  |  |  |  | 5 |  | *+1 cell ref
2 |  |  |  |  |  |  |  | 2
9 |  |  |  |  |  |  |  | 9
16 |  |  |  |  | *+4 cell ref |  |  | 16 |  |  |  | *+2 cell ref
17 |  |  | *+1 cell ref |  |  |  |  | 17 |  | *+1 cell ref
32 |  |  |  |  |  |  |  | 32
77 |  |  |  |  |  |  |  | 77
32 |  |  |  |  | *+4 cell ref |  |  | 32 |  |  |  | *+2 cell ref
44 |  |  | *+1 cell ref |  |  |  |  | 44 |  | *+1 cell ref
67 |  |  |  |  |  |  |  | 67
54 |  |  |  |  |  |  |  | 54
99 |  |  |  |  | *+4 cell ref |  |  | 99 |  |  |  | *+2 cell ref
74 |  |  |  |  |  |  |  | 74
65 |  |  |  |  |  |  |  | 65
38 |  |  |  |  |  |  |  | 38
49 |  |  |  |  |  |  |  | 49
63 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  | 1 |  | *+1 cell ref |  |  |  | ORANGE IS NOT TO BE TAKEN INTO CONSIDERATION
1 |  | *+1 cell ref |  |  |  |  |  | 6
6 |  |  |  | *+2 cell ref |  |  |  | 9
9 |  | *+1 cell ref |  |  |  |  |  | 14 |  |  |  | *+5 cell ref
14 |  |  |  | *+2 cell ref |  |  |  | 7 |  | *+1 cell ref
7 |  | *+1 cell ref |  |  |  |  |  | 8
8 |  |  |  | *+2 cell ref |  |  |  | 3
3 |  | *+1 cell ref |  |  |  |  |  | 10 |  |  |  | *+5 cell ref
10 |  |  |  |  |  |  |  | 5 |  | *+1 cell ref
5 |  |  |  |  |  |  |  | 2
2 |  |  |  |  |  |  |  | 9
9 |  |  |  |  |  |  |  | 16 |  |  |  | *+5 cell ref
 |  |  |  |  |  |  |  | 17 |  | *+1 cell ref
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  | 32 |  |  |  | *+5 cell ref
 |  |  |  |  |  |  |  | 44 |  | *+1 cell ref
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 99 |  |  |  | *+5 cell ref
 |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 63
Spreadsheet: 838079d1690695555-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample
Sheet: T3

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
3 | Alleygators | Player7 |  |  |  |  |  | Week 1
 |  | Player8 |  |  |  |  |  | Week 2
 |  | Player9 |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  | Week 9
 | [NAME] |  | Average |  |  |  |  | Week 10
 |  | Player7 | 117 |  |  |  |  | Week 11
 |  | Player8 | 100 |  |  |  |  | Week 12
 |  | Player9 | 97 |  |  |  |  | Week 13
 |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  | Week 20
 |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  | Week 45
Spreadsheet: 757880d1638487378-assistance-with-if-countif-formulas-example-sheet
Sheet: Trades

Date | Ticker | Position | Entry Price | Exit Price | Stop Loss | Shares | P&L $ | P&L % | Exposure | Risked % | Risked $ | Commission | Stopped
2021-12-01 00:00:00 | IMGN | LONG | 7.13 | 7.64 | 6.82 | 7900 |  |  |  |  |  |  | NO
2021-12-01 00:00:00 | AHI | LONG | 4.76 | 5.28 | 4.49 | 10500 |  |  |  |  |  |  | NO
X
Spreadsheet: sally_beck__33712__Metrics 0623
Sheet: Generation

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Generation / IPP Investments
Results based on Activity through June 23, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 12
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 15 | 17 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 2 | 7 | 2 | 0 | 9 | 1 | 0 | 0 | 2 | 0
- Executions |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 1 | 12.6 | 12.6 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 7.2 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 1 | 19.216 |  |  | 3 | 29 |  | 7 | 67.5 |  |  |  |  | 1 | 7.5
Identified Margin
Budget |  | 18.7
$ Coverage
$ millions
Spreadsheet: 214359d1360870610-give-list-of-all-employees-having-sales-in-current-qtr-only-and-not-having-any-prior-sales-sample
Sheet: Sheet1

Employee Name | Category | Sales Date | QTR | YEAR | FLAG1 | FLAG2
Emily | A | 2012-06-10 00:00:00
[NAME] | A | 2008-06-04 00:00:00
[NAME] | A | 2010-06-14 00:00:00
[NAME] | B | 2012-11-12 00:00:00
[NAME] | B | 2013-02-01 00:00:00
[NAME] | A | 2012-08-12 00:00:00
[NAME] | B | 2007-04-19 00:00:00
[NAME] | B | 2011-10-26 00:00:00
Mitt | A | 2012-11-02 00:00:00
Mitt | B | 2012-11-05 00:00:00
[NAME] | B | 2008-06-27 00:00:00
 |  | If I select Q4, 2012 then the FLAG2 should give me the total number of first time sales by Employee in Q4-12
 |  | In this case, it is Mitt(2 sales), Jack(1 sale); So Total = 3
 |  | How can I get this 3 number automatically in Flag2
Spreadsheet: 206596d1358237337-arrangement-of-vehicle-in-form-of-report-report-of-vehicle-dummy
Sheet: Main Consolidated Data

TOUR PROGRAMME
Sno | Date. | From | To | Mode of Transport | [NAME]. | [NAME] | Officer's Name | Remarks
1 | 23.01.2013 | Delhi | Kolkata | By flight AI 020 | 14:30:00 | 1645 | [NAME] | Tour without Family
 | 26.01.2013 | Kolkata | Delhi | By flight 6E 206 | 16:50:00 | 1900
2 | 24.01.2013 | Bangalore | Kolkata | 6E 205 | 09:50:00 | 12.05 | Tan1
 | 26.01.2013 | Kolkata | Bangalore | S24364 | 17:55:00 | 20.35
3 | 23.01.2013 | [NAME] | Kolkata | Jet 9W-2282 | 19:10:00 | 2115 | Tan2
 | 26.01.2013 | Kolkata | [NAME] | iNdigo 6E-238 | 07:25:00 | 935
4 | 23.01.2013 | Delhi | Kolkata | Air India | 19:10:00 | 1645 | Tan3
 | 26.01.2013 | Kolkata | Delhi | Air India | 07:25:00 | 1745
5 | 24.01.2013 | Delhi | Kolkata | Spice Jet SG104 | 09:10:00 | 11.55 | Tan4
 | 26.01.2013 | Kolkata | Delhi | Air India AI 701 | 17:45:00 | 20.05
6 | 23.01.2013 | Delhi | Kolkata | Indigo Flight 6E-203 | 18:10:00 | 1740 | Tan5 | Mrs. [NAME]
 | 26.01.2013 | Kolkata | Delhi | Indigo Flight 6e-274 | 20:15:00 | 2000
7 | 23.01.2013 | [NAME] | Kolkata | Indigo 6E 252 | 18:10:00 | 19.3 | Tan6 | Tour without Family
 | 26.01.2013 | Kolkata | [NAME] | 12810 HWH-CSTM | 20:15:00 | 9.2
8 | 23.01.2013 | Delhi | Kolkata | AI-20 | 14:30:00 | 1645 | Tan7
 | 26.01.2013 | Kolkata | Delhi | AI-23 | 20:15:00 | 2230
9 | 23.01.2013 | Delhi | Kolkata | SG 104 | 15:05:00 | 11.15 | Tan8
 | 26.01.2013 | Kolkata | Delhi | 6E.206 | 13:30:00 | 15.35
10 | 23.01.2013 | Delhi | Kolkata | 9W7099 | 15:05:00 | 1605 | Tan9
 | 26.01.2013 | Kolkata | Delhi | 9W7117 | 13:30:00 | 1435
11 | 23.01.2013 | Delhi | Kolkata | AI-20 | 15:05:00 | 16.45 | Tan10
 | 26.01.2013 | Kolkata | Delhi | AI-701 | 13:30:00 | 20.05
Spreadsheet: 685864d1594234700-matching-cash-received-against-corresponding-invoice-matching-excel-sheet-pcb-
Sheet: Sheet1

 | INCOME LEDGER
Date | Code | Name | Invoice | Amount Paid
2020-02-01 00:00:00 | US001 | [NAME] | A0001 | 4000
2020-02-02 00:00:00 | US-0002 | [NAME] | A0002 | 2000
2020-02-03 00:00:00 | US-0003 | [NAME] | A0003 | 5000
2020-02-10 00:00:00 | US-0004 | Omega Jonnes | A0004 | 1000
11/02/202 | US-0005 | [NAME] | A0005 | 3000
A7 is NOT a date, but text
I woul like to match all cash paid to the ledger below for example by [NAME] $9000 ($4000 and $5000)
and to the the accounts receivable ledger
 | ACCOUNTS RECEIVEABLE LEDGER
Date | Code | Name | Invoice | Amount | #payments
 |  | [NAME]
 |  | [NAME]
 |  | Omega Jonnes
 |  | [NAME]
Spreadsheet: 728834d1618685680-not-sure-how-to-get-this-conditional-formatting-to-work-wine-list-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Location |  |  | Notes
Favorite | Name | Winery | Variety | Vintage | Color | Country | Region | Number of bottles |  | Section | Row | Column |  | Start | End | YELLOW | GREEN | RED
 |  |  | Beaujolais | 2010
 |  |  | Beaujolais | 2011
 |  |  | Beaujolais | 2012
 |  |  | Beaujolais | 2013
 |  |  | Beaujolais | 2014
 |  |  | Beaujolais | 2015
 |  |  | Beaujolais | 2016
 |  |  | Beaujolais | 2017
 |  |  | Beaujolais | 2018
 |  |  | Beaujolais | 2019
 |  |  | Beaujolais | 2020
 |  |  | Beaujolais | 2021
 |  |  | Beaujolais | 2022
 |  |  | Beaujolais | 2023
 |  |  | Beaujolais | 2024
Spreadsheet: 769716d1645649108-help-with-formula-to-pull-description-and-add-quantities-from-lookup-list-bom-template
Sheet: Access

ROOM | Quantity | Part No. | Brief Description | Purchase From | (NU) Labor Cost | (U) Labor Cost | ( C ) Labor Cost | Device Cost | Cable | (NU) Labor Total | (U) Labor Total | ( C ) Labor Total | Hardware Total | Labor Sell | Hardware Sell |  | Totals Sell |  |  | Totals Cost
ACCESS CONTROL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Sell |  |  | Labor Cost
Sallyport |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardware Sell |  |  | Hardware Cost
Door controller | 1 | 5200C
Spreadsheet: 296853d1392214425-how-to-classify-the-data-set-on-the-basis-of-matched-character-redistribution_challenge
Sheet: Sheet1

ColumnA | ColumnB | ColumnC | ColumnD | ColumnE | ColumnF | ColumnG
USA#California$ | USA#California$ | Beijing#China$ | NewDelhi#India | [NAME] | USA#Newyork | USA#Washington
Beijing#China$ | California#USA | China$Beijing | India#NewDelhi |  |  | USA#Washington
NewDelhi#India | California#USA |  | India#NewDelhi |  |  | USA#Washington
India#NewDelhi |  |  | NewDelhi#India
California#USA |  |  | NewDelhi#India
China$Beijing
[NAME]
California#USA
USA#Newyork
USA#Washington
India#NewDelhi
NewDelhi#India
NewDelhi#India
USA#Washington
USA#Washington
Spreadsheet: 76c24e92-0e7d-456a-ba74-cdb81f908a41
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | [NAME] XXXVIII.ročník | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | sobota 30.června 2012
Vrchní rozhodčí : |  |  | Michal KINDL |  |  | FINA
Vrchní časoměřič : |  |  | NOVÁKOVÁ Iveta |  |  | III.
Počítač : |  |  | Jan BAŽIL |  |  | FINA
Startér : |  |  | Michal KINDL |  |  | FINA
Pomocný startér : |  |  | [NAME] |  |  | III.
Časoměřiči : |  |  | Šárka STACHOVÁ |  |  | III.
 |  |  | [NAME] |  |  | III.
 |  |  | Lenka ZEMANOVÁ |  |  | III.
 |  |  | [NAME] |  |  | III.
[NAME] : |  |  | [NAME] |  |  | III.
Hlasatel : |  | ing. | Michal ŠTĚRBA
Technická četa : |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
[NAME] a protokol : |  |  | Tomáš NETERDA
Diplomy : |  |  | [NAME]
 |  |  | Šárka STACHOVÁ
[NAME] : |  |  | VZS Chrudim
Jury : |  | ing. | Michal Štěrba
 |  | Mgr. | [NAME]
 |  |  | [NAME]
Spreadsheet: 854177d1704148239-closest-date-with-criteria-with-maxifs-formula-closestdate-1-
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-30 00:00:00 | MULN |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10