tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220079d1363048454-finding-golf-handicaps-using-best-2-out-of-3-last-rounds-played-golf2012
Sheet: SCHED WRKSHT

Week # | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
1 | 2010-04-29 00:00:00
2 | 2010-05-06 00:00:00
3 | 2010-05-13 00:00:00
4 | 2010-05-20 00:00:00
5 | 2010-05-27 00:00:00
6 | 2010-06-03 00:00:00
7 | 2010-06-10 00:00:00
8 | 2010-06-17 00:00:00
9 | 2010-06-24 00:00:00
10 | 2010-07-01 00:00:00
11 | 2010-07-08 00:00:00
12 | 2010-07-15 00:00:00
13 | 2010-07-22 00:00:00
14 | 2010-07-29 00:00:00
15 | 2010-08-05 00:00:00
16 | 2010-08-12 00:00:00
17 | 2010-08-19 00:00:00
18 | 2010-08-26 00:00:00
Spreadsheet: 80239d1280425066-excel-2007-two-different-formulas-in-one-cell-to-play-with
Sheet: Template

 |  | Surname | First Name | ID
 |  |  |  |  | Cwrk |  |  | Exam |  |  | Total | Grade | Code
 |  |  |  |  | 1st M | 2nd M | 80% | 1st M | 2nd M | 20%
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 856209d1705547870-if-then-vlookup-defined-names-test-travel
Sheet: TRAVEL REQUEST

 |  |  |  | TRAVEL REQUEST WORKSHEET |  |  |  |  |  |  |  |  |  |  |  |  | TRAVEL ORDER NUMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N2
 |  |  |  | OFFICE | PPMD
 |  |  |  | TRAVELER NAME | MARK, MARK E |  |  |  |  |  |  |  |  |  |  |  | DATE OF REQUEST
 |  |  |  | EMPLOYEE ID
 |  |  |  | SPECIAL REQUESTS
 |  |  |  | SELECT IF APPLICABLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | ``
 |  |  |  | SELECT IF APPLICABLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | 2nd Mode Transport Check mark
 |  |  |  | DEPART FROM |  |  |  |  |  |  |  |  |  | DEPART DATE DD-MMM-YYYY
 |  |  |  | ARRIVAL LOCATION (TDY/ HOTEL LOCATION) |  |  |  |  |  |  |  |  |  | RETURN DATE DD-MMM-YYYY
 |  |  |  | Select Drop Down for ILPP Locations |  |  |  |  |  |  | SC - SHAW AFB, SUMTER (METRO AREA)
 |  |  |  | PURPOSE OF TRAVEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHECK IF A SECONDARY MAIN MODE OF TRANSPORT WILL BE USED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELECT THE SECONDARY MODE OF TRANSPORT (if used)
 |  |  |  | TRANSPORTATION MODE
 |  |  |  | SELECT THE MAIN MODE OF TRANSPORT
 |  |  |  | POV |  |  |  |  |  |  |  | SELECT ONE
 |  |  |  | IF POV IS SELECTED ENTER ESTIMATED MILAGE IN THE ESTIMATED COST SECTION
 |  |  |  | TYPE / TDY CATEGORY
 |  |  |  | SELECT ONE
 |  |  |  | REIMBURSEMENT TYPE
 |  |  |  | SELECT ONE
 |  |  |  | ESTIMATED COSTS
 |  |  |  | ESTIMATED FLIGHT |  |  |  |  |  |  |  |  | POC-AUTO - NO GOV avail
 |  |  |  | ESTIMATED RENTAL CAR |  |  |  |  |  |  |  |  |  | $ per mile |  |  | POV COST
 |  |  |  | ESTIMATED POV MILEAGE |  |  |  |  |  |  |  | x
 |  |  |  | ESTIMATED POV VICINITY MILEAGE |  |  |  |  |  |  |  | x
 |  |  |  | OTHER COST (explain) |  |  |  |  |  |  |  | 1 | X
 |  |  |  | CEFMS TOTAL ESTIMATE
 |  |  |  | CEFMS TOTAL ESTIMATE
 |  |  |  | FUNDING INFORMATION
 |  |  |  | LOG IN TRAVEL & TRAINING : |  |  |  |  |  |  | ORDERING WORK ITEM:
 |  |  |  | TOTAL COST: |  |  |  |  |  |  | FUNDING WORK ITEM:
 |  |  |  |  |  |  |  |  |  |  | WORK CATEGORY :
 |  |  |  | REMARKS
Spreadsheet: mary_fischer__25617__37D
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
ANALYSIS OF GOODWILL
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Goodwill |  | 40 |  | 76715431 |  |  |  | -1037880
Settlement to State of California |  |  |  |  |  | 118707
[NAME] Payment |  |  |  |  |  | 6063704
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 91878d1291584398-data-validation-and-conditional-formatting-draft_template
Sheet: Line Up

Forwards |  | [NAME]
1 | Crombeen, B.J. |  |  | [NAME]: | 59.4
2 | Stamkos, [NAME] |  |  | [NAME]:
3 | Burrows, [NAME] |  |  | [NAME]:
4 | Doan, Shane
5 | Ovechkin, [NAME]
6 | [NAME], Zach
7 | [NAME], [NAME] |  |  | Forwards [NAME]:
8 | Cullen, [NAME] |  |  | Defence Cap Hit:
9 | Oshie, T.J. |  |  | [NAME] Hit:
10 | [NAME], Valtteri |  |  | Reserve Cap Hit:
11 | Callahan, [NAME] |  |  | Active Cap Hit:
12 | MacArthur, Clarke |  |  | Total Cap Hit:
Defenceman
1 | [NAME], [NAME]
2 | Del Zotto, [NAME]
3 | Pronger, [NAME]
4 | Myers, Tyler
5 | [NAME], [NAME]
6 | Whitney, Ryan
Goalies
1 | [NAME], [NAME]
2 | [NAME], [NAME]
Reserve
1
2
3
4
5
Spreadsheet: 218613d1362509492-count-unique-occurrances-based-off-criteria-in-a-different-column-conultant
Sheet: Topics

 | TOPICS |  |  |  | TOTAL
CONSULTANT | Topic A | Topic B | Topic C | Topic D
Consultant 1
Consultant 2
Consultant 3
Consultant 4
Spreadsheet: 08aa72d9-4cfd-4cc2-9c4e-1e4cbb164206
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 30. LEASE FINANCE COMMITMENTS, By Industry: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2420286X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2420287A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2420288C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2420289F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2420290R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2420291T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2420292V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2420293W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2420294X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2420295A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2420296C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2420297F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2420298J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2420299K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 169788d1343059078-pulling-only-last-30-days-data-from-larger-all-time-table-ef132_list1
Sheet: Main

Recent | ID | Incident Date | Issue Title | Impact Time
- | 567 | 2012-07-20 00:00:00 | Slowness issues | 0.58
- | 561 | 2012-07-19 00:00:00 | Slowness issues | 0.57
- | 562 | 2012-07-19 00:00:00 | Update Not Received | 0
- | 563 | 2012-07-19 00:00:00 | Update Not Received | 0
- | 564 | 2012-07-19 00:00:00 | Update Not Received | 0
1 | 565 | 2012-06-12 00:00:00 | Update Not Received | 1
2 | 566 | 2012-06-11 00:00:00 | Update Not Received | 0
3 | 544 | 2012-06-10 00:00:00 | Slowness issues | 0
4 | 547 | 2012-06-09 00:00:00 | Slowness issues | 3
5 | 548 | 2012-06-08 00:00:00 | Update Not Received | 0
6 | 549 | 2012-06-07 00:00:00 | Update Not Received | 2.1
7 | 550 | 2012-06-06 00:00:00 | Update Not Received | 0
- | 551 | 2012-05-02 00:00:00 | Slowness issues | 0.5
- | 552 | 2012-05-01 00:00:00 | Update Not Received | 0
- | 542 | 2012-04-20 00:00:00 | Update Not Received | 0
- | 553 | 2012-04-15 00:00:00 | Update Not Received | 0
- | 560 | 2012-03-13 00:00:00 | Update Not Received | 6.3
- | 537 | 2012-03-13 00:00:00 | Update Not Received | 0
- | 538 | 2012-03-13 00:00:00 | Update Not Received | 0
-
-
-
-
-
-
-
-
-
-
-
Spreadsheet: 729549d1619161325-formula-to-count-days-worked-that-are-on-weekends-schedule-help-needed
Sheet: STATS

Company Name - Schedule
STATS
Total Days
Shifts Required
Employee | Shifts | Car 1 | Car 2 | Weekends | Stats
Spreadsheet: 551863d1513191111-pop-up-with-options-to-select-copy-of-sales-spreadsheet
Sheet: Drop Downs

[NAME] | Acquisition | CPVX-Central Station BA | [NAME]
[NAME] | Print | CVSG-Mercantile
[NAME] | Radio | UUFX-Central Station FA
 | Television | CRZH-NIS/UL2050
 | Word of Mouth | CVWX-Proprietary BA
 | Yellow Pages | UUJS-Local Mntr. Station
 | Direct Mail
 | Telemarketing
 | Personal Referral
 | Salesman Contact
 | Yard Signs
 | Home Shows
 | Prior Customer
 | Commercial Employee Program
 | Relocation Program
 | Relocation Program-$100 off
 | S&H Referral
 | No. Amer. Call Center
 | GE Leasing-Other
 | Comlete Home Coupon
 | Home Resource Coupon
 | Run for the Gold Promo
 | GE Lease [NAME]
 | T.I.E. Direct Mail
 | [NAME]
 | Your Home
 | Get1 Give1 Paid System
 | Get1 Give 1 Free System
 | American Legion
 | Pending Naitonal Accounts
 | Pending National Systems
 | Decentralized National Acc
 | Local Systems
 | EMSI
 | BUYERZONE
 | TRUEADVANTAGE
Spreadsheet: eb1f2bbe-0fc5-4f9d-a460-5b450220f6c6
Sheet: target

threshold | TP | FP | TN | FN | Pre | Rec | F1 | FPR
0.5 | 5.34 | 24.54 | 790.66 | 18.66 | 0.197055966145 | 0.2225 | 0.201332017814 | 0.0301464932206
1 | 2.62 | 4.9 | 810.3 | 21.38 | 0.341052725053 | 0.109166666667 | 0.159558535375 | 0.0660444964124
0.4 | 6.46 | 33.22 | 781.98 | 17.54 | 0.181561915046 | 0.269166666667 | 0.208498289759 | 0.0409090219321
0.8 | 3.12 | 5.68 | 809.52 | 20.88 | 0.370827755578 | 0.13 | 0.185400419399 | 0.007092325205
0.1 | 13.02 | 241.6 | 573.6 | 10.98 | 0.0532208402431 | 0.5425 | 0.0965231714713 | 0.295802010823
0.3 | 8.28 | 56.14 | 759.06 | 15.72 | 0.138596428087 | 0.345 | 0.192845473191 | 0.0691202484502
0.6 | 4.2 | 12.64 | 802.56 | 19.8 | 0.265258263335 | 0.175 | 0.205123437635 | 0.0154629940897
0.2 | 9.4 | 106.06 | 709.14 | 14.6 | 0.0886390393661 | 0.391666666667 | 0.142183206462 | 0.129786377009
0.9 | 2.72 | 5 | 810.2 | 21.28 | 0.358274947275 | 0.113333333333 | 0.165892571709 | 0.0262113343738
0.05 | 16.18 | 386 | 429.2 | 7.82 | 0.0412376279219 | 0.674166666667 | 0.0775607769291 | 0.472302642792
0.7 | 3.4 | 6.62 | 808.58 | 20.6 | 0.36327275992 | 0.141666666667 | 0.196089052837 | 0.00827266285617
Spreadsheet: 551827d1513177326-advanced-filter-greater-than-or-equal-to-another-cell-advanced-filter
Sheet: Sheet1

 |  |  |  |  | Values 1 | Values 2 | Values 3 | Values 4 | Values 5
 |  |  |  |  | 79 | 146 | 105 | 138 | 153
 |  |  |  |  | 177 | 127 | 179 | 115 | 67
 |  |  |  |  | 37 | 57 | 171 | 177 | 133
 |  |  |  |  | 58 | 65 | 185 | 50 | 27
 |  |  |  |  | 70 | 119 | 137 | 25 | 98
 |  |  |  |  | 182 | 118 | 154 | 117 | 20
 |  |  |  |  | 70 | 72 | 125 | 133 | 137
 |  |  |  |  | 145 | 133 | 52 | 50 | 52
 |  |  |  |  | 19 | 132 | 91 | 92 | 186
 |  |  |  |  | 137 | 184 | 39 | 29 | 171
 |  |  |  |  | 173 | 39 | 128 | 155 | 123
Values 1 | Values 2 | Values 3 | Values 4 | Values 5
Criterion
140
Spreadsheet: benjamin_rogers__1048__Consolidated 6 Peaker-051800-PE-1
Sheet: Allocation

ALLOCATION
Project |  | By Project Cost |  | By Cashflow
Brownsville |  | 0.125039438479223 |  | 0.1544055419784738
Caledonia |  | 0.1511835224699338 |  | 0.1558587124333399
New Albany |  | 0.145392174776267 |  | 0.1197550000844939
Sub Total
[NAME] |  | 0.170742065516558 |  | 0.1750496898264828
Wheatland |  | 0.1561848046993598 |  | 0.17174199460296
[NAME] |  | 0.2514579940586584 |  | 0.2231890610742496
Sub Total
Total
[NAME]
Franchise Tax - Brownsville, Caledonia, New Albany, Gleason, Wheatland
Solve Equity
Spreadsheet: 116113d1311608722-simple-vlookup-question-vlookup-question
Sheet: Table

Policy | Date AV Became Zero | Current Date | Benefit Limit | Benefit Limit Remaining (static) | Benefit Limit Remaining (running) | Monthly Payment | Number of Payments Remaining | Value of Last Payment | Date of Final Payment
3434 | 2011-01-05 00:00:00 |  | 100000 | 200000 |  | 2000
8500318918 | 2010-06-01 00:00:00 |  | 40085.80705009276 | 31723.87136672854 |  | 0
Spreadsheet: 729306d1619016405-conditional-formatting-that-involves-text-and-date-values-my-brain
Sheet: Timers

Identification |  |  | General [NAME] |  | End Dates |  | Parole Hearing Dates |  |  |  | Parole Plan |  |  |  |  | Transitional Funding |  |  |  |  | Interstate Compact |  |  |  | Services and Documents |  |  |  |  | Notes
Number | IDOC # | Name | Job | [NAME] | PED | FTRD | Pre-Board Hearing | PHO | Parole Hearing | Revocation Hearing | RFI Due | Submitted | Approved | Housing | Ride | TTF | Deposits | Submitted | Approved | Required Portion | Interstate Compact | Fee | Submitted | Approved | ID | [NAME] | SSC | Medicaid | Closet | Notes
1 | 69882 | Gittel, [NAME] | FS | 2021-03-11 00:00:00 | 2022-01-12 00:00:00 | 2027-05-09 00:00:00 |  |  | 2021-08-01 00:00:00 | N/A |  |  |  |  |  | No | N/A | N/A | N/A | 0
2 | 63485 | Higgins, Rebecca |  | 2021-03-11 00:00:00 | 2021-12-13 00:00:00 | 2026-12-12 00:00:00 | 2021-04-06 00:00:00 | [NAME] | 2021-05-21 00:00:00 | N/A |  |  |  |  |  | No | N/A | N/A | N/A | 0 |  |  |  |  |  |  |  |  |  | Janitor worker
3 | 130526 | [NAME], Christine | ILD | 2021-04-01 00:00:00 | 2021-01-09 00:00:00 | 2025-01-08 00:00:00 | 2021-03-04 00:00:00 | [NAME] | 2021-05-21 00:00:00 | N/A |  |  |  |  |  | No | N/A | N/A | N/A | 0 | No | N/A | N/A | N/A | N/A | Yes | N/A
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
Spreadsheet: 599357d1542988193-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Master Loan Summary

Master Loan & Recovery  Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum
 | Branch Information-► |  |  |  |  | Customer Information-► |  |  |  |  |  |  | Loan Information -►
Serial No | Loan Code | Branch Name | Branch Code | Officer's Name | Officer Code | Customer Name | NIC No. | Customer Status | Main City | Contact No | Distance to Center(Km) | Nearest Town | Date of Loan | Loan Amount (Rs.) | [NAME] | Payment Method | Period (Days) | % Effective Interest | Total Interest | Total with Interest | No of Instmnts | Loan Instalment | Sum of Instalmnt Paid | Sum of Amount Paid | Bank Deposits | Remaining Instalmnt | Recovered Loan Amt. | Loan Balance | Recovered Interest Amt. | Interest Balance | Total Balance | Excess/Sshort | Recovery Efficiency | Customer Status2
Total
Spreadsheet: 538254d1505485573-need-a-formula-or-code-to-replace-dates-inventory-accuracy-template
Sheet: Exempt - Closed

Cycle Count By Location - Period Ending August 31, 2017 - FY 18 - US EXEMPT/CLOSED LOCATIONS
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall | Notes
 |  |  | US TOTAL
Cycle Count By Location - Period Ending August 31, 2017 - FY 18 - CAN EXEMPT/CLOSED LOCATIONS
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | CAN TOTAL
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 275259 | 281503 | 69344 | 72956 | 70029 | 60311 | 80665 | 75085 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 286090 | 306045 | 63458 | 72956 | 59329 | 62968 | 93352 | 60047
3 | 294630 | 290625 | 56674 | 72956 | 58162 | 54990 | 61099 | 60047 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 305300 | 278666 | 45173 | 72956 | 50926 | 56783 | 70201 | 59892 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 296996 | 298827 | 72358 | 72955 | 60526 | 52457 | 106632 | 109953 |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 | 321837 | 320618 | 73894 | 72956 | 59574 | 58414 | 97078 | 96567 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 294336 | 288119 | 73085 | 72956 | 66209 | 59520 | 102596 | 108994 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 335913 | 313363 | 41184 | 57956 | 60789 | 60685 | 114585 | 113362 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 324398 | 316977 | 71825 | 72956 | 62342 | 62897 | 118352 | 115056 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 | 297356 | 324409 | 71852 | 72956 | 61608 | 63378 | 130859 | 119204 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 282398 | 250750 | 72080 | 72956 | 70350 | 64373 | 107979 | 115292
12 | 307301 | 313278 | 73385 | 72956 | 73231 | 69483 | 136385 | 129079
13 | 291092 | 300275 | 73005 | 72956 | 55147 | 57862 | 106009 | 89909
14 | 300435 | 306742 | 73860 | 72956 | 72059 | 64050 | 124226 | 122654
15 | 314672 | 318527 | 67111 | 72956 | 56443 | 55483 | 132628 | 123921
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  |  |  |  |  | 275390
2001-09-15 00:00:00
CBS Dollars
 |  |  | 1288237.99
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 104906d1302346562-a-countif-formula-to-pull-actual-value-complaintswithrank
Sheet: helper

concatenated | counted | unique ranked
REWARDSComplaint | 1 | 66
AVAF_ADMINARRANGEMENT | 0 | 59
FOREXDECLINE | 0 | 58
NAC_VIRGIN_MONEYASSISTANCE | 0 | 57
MARKETINGARRANGEMENT | 0 | 56
FINANCIAL_SERVICESARRANGEMENT | 0 | 55
REWARDSARRANGEMENT | 0 | 54
REWARDSATTITUDE | 0 | 53
REWARDSATTITUDE | 0 | 52
NAC_VIRGIN_MONEYDECLINE | 0 | 51
REWARDSARRANGEMENT | 0 | 50
REWARDSASSISTANCE | 0 | 49
REWARDSATTITUDE | 0 | 48
MARKETINGDECLINE | 0 | 47
REWARDSASSISTANCE | 0 | 46
NAC_VIRGIN_MONEYASSISTANCE | 0 | 45
FINANCIAL_SERVICESASSISTANCE | 0 | 44
REWARDSARRANGEMENT | 0 | 43
MARKETINGDECLINE | 0 | 42
NAC_VIRGIN_MONEYASSISTANCE | 0 | 41
MARKETINGARRANGEMENT | 0 | 40
FOREXDECLINE | 0 | 39
[NAME] | 1 | 65
NAC_VIRGIN_MONEYATTITUDE | 1 | 64
FINANCIAL_SERVICESASSISTANCE | 0 | 38
FINANCIAL_SERVICESASSISTANCE | 0 | 37
NAC_VIRGIN_MONEYARRANGEMENT | 0 | 36
REWARDSDECLINE | 0 | 35
FOREXDECLINE | 3 | 74
FINANCIAL_SERVICESASSISTANCE | 0 | 34
ATMASSISTANCE | 0 | 33
[NAME] | 0 | 32
NAC_VIRGIN_MONEYASSISTANCE | 0 | 31
ATMARRANGEMENT | 0 | 30
AVAF_ADMINARRANGEMENT | 0 | 29
MARKETINGDECLINE | 0 | 28
FINANCIAL_SERVICESASSISTANCE | 0 | 27
REWARDSARRANGEMENT | 0 | 26
FOREXARRANGEMENT | 1 | 63
AVAF_ADMINDECLINE | 0 | 25
REWARDSDECLINE | 0 | 24
FINANCIAL_SERVICESASSISTANCE | 0 | 23
FINANCIAL_SERVICESDECLINE | 0 | 22
MARKETINGDECLINE | 0 | 21
ATMARRANGEMENT | 0 | 20
NAC_VIRGIN_MONEYARRANGEMENT | 0 | 19
MARKETINGARRANGEMENT | 3 | 73
FINANCIAL_SERVICESDECLINE | 2 | 70
AVAF_ADMINARRANGEMENT | 3 | 72
REWARDSARRANGEMENT | 0 | 18
ATMARRANGEMENT | 0 | 17
[NAME] | 0 | 16
[NAME] | 0 | 15
FINANCIAL_SERVICESASSISTANCE | 0 | 14
NAC_VIRGIN_MONEYDECLINE | 2 | 69
REWARDSASSISTANCE | 3 | 71
[NAME] | 0 | 13
FINANCIAL_SERVICESASSISTANCE | 0 | 12
FOREXASSISTANCE | 1 | 62
REWARDSARRANGEMENT | 0 | 11
ATMARRANGEMENT | 4 | 77
FINANCIAL_SERVICESARRANGEMENT | 0 | 10
AVAF_ADMINDECLINE | 2 | 68
FINANCIAL_SERVICESASSISTANCE | 0 | 9
FINANCIAL_SERVICESASSISTANCE | 0 | 8
FINANCIAL_SERVICESASSISTANCE | 0 | 7
NAC_VIRGIN_MONEYASSISTANCE | 5 | 81
FINANCIAL_SERVICESARRANGEMENT | 0 | 6
REWARDSATTITUDE | 4 | 76
MARKETINGDECLINE | 0 | 5
NAC_VIRGIN_MONEYARRANGEMENT | 0 | 4
AVAF_ADMINATTITUDE | 1 | 61
REWARDSARRANGEMENT | 7 | 83
ATMASSISTANCE | 2 | 67
FINANCIAL_SERVICESARRANGEMENT | 0 | 3
FOREXATTITUDE | 1 | 60
NAC_VIRGIN_MONEYARRANGEMENT | 4 | 75
FINANCIAL_SERVICESARRANGEMENT | 5 | 80
REWARDSDECLINE | 0 | 2
REWARDSDECLINE | 0 | 1
MARKETINGDECLINE | 6 | 82
[NAME] | 5 | 79
REWARDSDECLINE | 5 | 78
FINANCIAL_SERVICESASSISTANCE | 12 | 84
Spreadsheet: 87516d1287410519-populating-a-list-using-selected-values-in-a-column-datesdue
Sheet: due in next x days

enter number of days below |  | results
9 |  | [NAME] | 2010-10-25 00:00:00 |  | this assumes you don’t want dates that have already passed
 |  | [NAME] | 2010-10-24 00:00:00 |  | I did 9 because it was easier to check with a small range of dates
 |  | [NAME] | 2010-10-23 00:00:00
 |  | martin 7 | 2010-10-18 00:00:00
 |  | [NAME] | 2010-10-19 00:00:00
 |  | [NAME] | 2010-10-21 00:00:00
 |  | [NAME] | 2010-10-18 00:00:00
 |  | [NAME] | 2010-10-26 00:00:00
 |  | martin 17 | 2010-10-22 00:00:00
Spreadsheet: 173560d1344601979-index-and-match-functions-demo
Sheet: Sheet1

[NAME] | North Bank | 12000
 |  |  |  | Banking Details | Salary
 | Staff List
 | Sali |  | Sali | North Bank | 10000
 | [NAME] |  |  | AC No 790408,
 | Mathew |  |  | St. Louis
 |  |  |  | MO 63179-0408
 |  |  | [NAME] | North Bank | 12000
 |  |  |  | AC No 790409,
 |  |  |  | St. Louis
 |  |  |  | MO 63179-0408
 |  |  | Mathew | North Bank | 13000
 |  |  |  | AC No 790429,
 |  |  |  | St. Louis
 |  |  |  | MO 63179-0408