tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9460b957-4398-4431-bf55-55153965bbc8
Sheet: Sheet1

F/Y 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Unit B | [PHONE] | All | [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME]
 | [NAME], DE  19802
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME]
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 475 Bowers Beach Road | [PHONE] | Kent | [NAME] | [NAME]
 | Frederica, DE  19946
American Funding Services Corp. | 2062 New Castle Ave, Suite A |  |  | [NAME], [NAME], [NAME], [NAME] | [NAME]
CASH ONLY | New Castle, DE  19720 | [PHONE] | All |  | [NAME]
Axe Bail Bonds | 977 Lochmeath Way
 | Dover, DE  19901 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | Trinity Goldsborough | Trinity Goldsborough
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805 |  |  | [NAME]
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado | Brunilda Mercado
 | [NAME], DE  19805
Cutting Edge Bail Bonds, LLC | 315 South State Street
 | Dover, DE  19901 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in JP 7
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
[NAME], Jr. Bail Bonds | 411 S. Queen Street | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
 | Apt. 213
 | Dover, DE  19904
Fast Bail Bonds LLC | 1224 [NAME] | [PHONE] | All* | [NAME] | [NAME]
 | [NAME], DE  19801 |  | *Cannot post in JP 7
Gina's Bail Bonds | 307 S. State Street | [PHONE] | Kent
(T&H d/b/a) | Dover, DE  19901 |  | Sussex | [NAME] | [NAME]
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
No Bars Bail Bonds LLC | 1224 [NAME]
 | [NAME], DE  19801 | [PHONE] | All | [NAME] | [NAME]
Paragon Associates of Delaware | 583 N. Commerce Street | [PHONE] | Kent
 | Townsend, DE  19734 |  | Sussex | [NAME] | [NAME]
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | All | [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901
Top Bail Surety, Inc. | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME], [NAME] | [NAME]
 | [NAME], DE  19805 |  |  |  | [NAME]
Spreadsheet: 753821d1635777739-how-to-pull-weekly-data-from-a-turnstile-database-help-turnstiles
Sheet: Weekly Data

 |  | Sun | Sun | Mon | Mon | [NAME] | [NAME] | Wed | Wed | Thurs | Thurs | Fri | Fri | Sat | Sat | Total weekly Hours
 |  | First turnstile entry | Last turnstile Exit
Employee ID | Name | Time in | Time Left site
CL503 | [NAME]
CL502 | [NAME]
*CL573 | [NAME]
All information to be pulled in from the [NAME] via the employyee ID (due to us been a 3rd party company)
Spreadsheet: 842665d1694685838-creating-a-list-based-on-data-in-a-matric-class-registration-matrix
Sheet: Module delivery ties

 |  |  | Mod. Del. Id. | 12345 | 23456 | 34567
Student ID | Student Name |  | Module delivery title | Class 1 | Class 2 | Class 3
12345678 | [NAME] |  |  | RE | RE | RE
23456789 | [NAME] |  |  |  | RE | RE
34567891 | [NAME] |  |  | RE | RE | RE
45678912 | Fred |  |  |  |  | RE
56789123 | [NAME] |  |  |  | RE | RE
67891234 | Emma |  |  | RE | RE
 |  |  | 12345
 |  |  | Class 1
 |  |  |  |  | Week 1 | Week 2 | Week 2
 |  |  | Student ID | Student Name
 |  |  |  | [NAME]
 |  |  | 34567891 | [NAME]
 |  |  | 67891234 | Emma
 |  |  | 23456
 |  |  | Class 2
 |  |  |  |  | Week 1 | Week 2 | Week 2
 |  |  | Student ID | Student Name
 |  |  |  | [NAME]
 |  |  | 23456789 | [NAME]
 |  |  | 34567891 | [NAME]
 |  |  | 56789123 | [NAME]
 |  |  | 67891234 | Emma
 |  |  | 34567
 |  |  | Class 3
 |  |  |  |  | Week 1 | Week 2 | Week 2
 |  |  | Student ID | Student Name
 |  |  |  | [NAME]
 |  |  | 23456789 | [NAME]
 |  |  | 34567891 | [NAME]
 |  |  | 45678912 | Fred
 |  |  | 56789123 | [NAME]
Spreadsheet: 60630d1261132036-countif-over-different-fields-testabsence
Sheet: Data

ABSENCE SUMMARY
Surname | Forename | Location | Dept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Days | 2009-11-01 00:00:00 | CUM TOT
 |  |  | Team 1 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5
 |  |  | Team 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Head count for team 1 | 7 | 6
 |  |  | Team 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  |  | Team 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | Team 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
jane |  |  | Team 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Team 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 |  |  | Team 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 825190d1681163166-how-to-randomly-distripute-89-applications-to-10-reviewers-test-lfmwf
Sheet: Worksheet

Name (First) | Name (Last) | Reviewer 1 | Reviewer 3 | Reviewer 4 | Reviewer 5 | Reviewer 6 | Reviewer 7 | Reviewer 8 | Reviewer 9 | Reviewer 10
[NAME] | 1
[NAME] | 2
Kayla | 3
[NAME] | 4
[NAME] | 5
[NAME] | 6
Brittney | 7
[NAME] | 8
Travis | 9
[NAME] | 10
Molly | 11
Janelle | 12
[NAME] | 13
[NAME] | 14
Breanna | 15
Samantha | 16
Sara | 17
Alexis | 18
[NAME] | 19
Isabelle | 20
[NAME] | 21
[NAME] | 22
[NAME] | 23
Nathan | 24
[NAME] | 25
[NAME] | 26
[NAME] | 27
Rachel | 28
[NAME] | 29
Zachary | 30
Rebecca | 31
Erin | 32
[NAME] | 33
[NAME] | 34
Jordan | 35
[NAME] | 36
[NAME] | 37
Alyssa | 38
Heather | 39
Rachel | 40
[NAME] | 41
Lauren | 42
Danielle | 43
[NAME] | 44
[NAME] | 45
Kailer | 46
Haley | 47
[NAME] | 48
Amanda | 49
[NAME] | 50
[NAME] | 51
[NAME] | 52
[NAME] | 53
[NAME] | 54
[NAME] | 55
Alicia | 56
Casondra | 57
Alec | 58
[NAME] | 59
[NAME] | 60
Ritika | 61
Heather | 62
[NAME] | 63
[NAME] | 64
Samantha | 65
Brock | 66
[NAME] | 67
[NAME] | 68
Emily | 69
Dino | 70
[NAME] | 71
[NAME] | 72
Falon | 73
[NAME] | 74
Karina | 75
[NAME] | 76
Emily | 77
Kayla | 78
Lauren | 79
Jodi | 80
Connor | 81
Tanner | 82
Emily | 83
[NAME] | 84
[NAME] | 85
[NAME] | 86
Ellery | 87
Carrie | 88
[NAME] | 89
Spreadsheet: 880462d1728256579-power-query-find-text-in-a-list-in-another-list-match
Sheet: Sheet1

 |  |  |  |  |  | Customer | Customer Name |  |  |  | Customer | Customer Name
 |  |  |  |  |  | MOH North | Health GH |  |  |  | MOH North | Health GH
 |  |  |  |  |  | Sth MOE New | North Education Supply |  |  |  | Sth MOE New | North Education Supply
 |  |  |  |  |  | Central MO | Central K Health |  |  |  | Central MO | Central K Health
 |  |  |  |  |  | SDM | [NAME] |  |  |  | SDM | [NAME]
 |  |  |  |  |  | Search |  |  |  |  | Search
 |  |  |  |  |  | MOE |  |  |  |  | MOE
 |  |  |  |  |  | MOH |  |  |  |  | MOH
 |  |  |  |  |  | MO |  |  |  |  | MO
 |  |  |  |  |  | Health |  |  |  |  | Health
 |  |  |  |  |  | Supply |  |  |  |  | Supply
 |  |  |  |  |  | Education |  |  |  |  | Education
 |  |  |  |  |  |  |  |  |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  | Customer | Customer Name | Found
 |  |  |  |  |  |  |  |  |  |  | MOH North | Health GH | MOH, Health
 |  |  |  |  |  |  |  |  |  |  | Sth MOE New | North Education Supply | MOE, Education, Supply
 |  |  |  |  |  |  |  |  |  |  | Central MO | Central K Health | MO, Health
 |  |  |  |  |  |  |  |  |  |  | SDM | [NAME]
Spreadsheet: 82960d1282940702-caculating-the-difference-in-a-pivot-table-caculate-pivot-example
Sheet: Sheet1

Year | FY | Type | SubType |  |  | Pivot 1
2011 | 10 | Pet | Dog
2010 | 15 | Non Pet | [NAME] |  |  |  |  |  | Year
2011 | 8 | Pet | Dog |  |  | Type | SubType | Data | 2010 | 2011
2010 | 7 | Non Pet | [NAME] |  |  | Pet | Cat | Sum of FY | 118
2011 | 6 | Non Pet | Ferret |  |  |  |  | Diff |  | -118
2010 | 19 | Pet | Cat |  |  |  | Dog | Sum of FY | 55 | 125
2011 | 21 | Pet | Dog |  |  |  |  | Diff |  | 70
2010 | 33 | Non Pet | Ferret |  |  | Non Pet | [NAME] | Sum of FY | 22
2011 | 72 | Pet | dog |  |  |  |  | Diff |  | -22
2010 | 55 | Pet | Dog |  |  |  | Ferret | Sum of FY | 33 | 6
2011 | 76 | Non Pet | Snake |  |  |  |  | Diff |  | -27
2010 | 99 | Pet | Cat |  |  |  | Snake | Sum of FY | 13 | 76
2011 | 14 | Pet | Dog |  |  |  |  | Diff |  | 63
2010 | 13 | Non Pet | Snake
How I want |  |  |  |  |  |  |  |  |  |  |  | Pivot 2
 |  | Data | Year |  |  |  |  |  |  |  |  |  |  | Data | Year
 |  | Sum of FY |  |  |  |  |  |  |  |  |  |  |  | Sum of FY |  | Diff
Type | SubType | 2010 | 2011 | Diff |  |  |  |  |  |  |  | Type | SubType | 2010 | 2011 | 2010 | 2011
Pet | Cat | 118 |  | -118 |  |  |  |  |  |  |  | Pet | Cat | 118 |  |  | -118
 | Dog | 55 | 125 | 70 |  |  |  |  |  |  |  |  | Dog | 55 | 125 |  | 70
Non Pet | [NAME] | 22 |  | -22 |  |  |  |  |  |  |  | Non Pet | [NAME] | 22 |  |  | -22
 | Ferret | 33 | 6 | -27 |  |  |  |  |  |  |  |  | Ferret | 33 | 6 |  | -27
 | Snake | 13 | 76 | 63 |  |  |  |  |  |  |  |  | Snake | 13 | 76 |  | 63
Sum of FY |  | Year
Type | SubType | 2010 | 2011 | Diff
Non Pet | Ferret | 33 | 6 | -27
 | [NAME] | 22 |  | -22 |  | <<<<<<<<<<<<<<<<<<<<<<<<HERE IS MINE
 | Snake | 13 | 76 | 63
Pet | Cat | 118 |  | -118
 | Dog | 55 | 125 | 70
Spreadsheet: keith_holst__19343__All winters
Sheet: Conclusion

 | Sumas | Seattle | Chehalis | JP | Chehalis to Roosevelt | Washougal | Kelso | Roosevelt
Date | 1999-01-28 00:00:00 | 2000-11-15 00:00:00 |  | 2000-12-17 00:00:00 | 1998-12-20 00:00:00 | 1998-12-21 00:00:00 | 1998-12-05 00:00:00 | 2000-12-17 00:00:00
Min
Date | 2000-12-26 00:00:00 | 1999-01-28 00:00:00 | 1999-03-20 00:00:00 | 2000-11-15 00:00:00 | 1999-02-26 00:00:00 | 2001-03-24 00:00:00 |  | 1999-02-27 00:00:00
[NAME]
Maximum Demand Scenario
 | Sumas | Seattle | Chehalis | JP | Chehalis to Roosevelt | Washougal | Kelso | Roosevelt
Flow |  |  |  | 1000 |  |  |  | -498
 | Plug |  |  | Capacity |  |  |  | Capacity
Notes:
- When Chehalis to Roosevelt was 787, Kelso was only 8 (shows that demand balances itself throughout the system)
- When Seattle needed 833, only 502 was taken out of JP (shows that a high demand in the area can be well covered by storage)
- The highest demand between Chehalis and Roosevelt (aside from the 19-Dec-98 to 22-Dec-98 period) is only 663, and then it falls to 391!
- The Capacity at Roosevelt increased from 448 to 498 on Dec-3-99
- The Withdrawal Capacity at JP increased from 560 to 1000 on Sept-12-99
- The Receipt Capacity at Stanfield increased from 508 to 638 on Nov-1-99
- The Capacity at Kemmerer and Meacham didn't change since 98
- When [NAME] was very cold in Dec-98, [NAME] was still flowing 725
- Because pipeline capacity didn't chabge since last year, the price spikes we experienced at Sumas last winter was not due
to a pipeline problem as much as Utilities buying at ridiculous levels.
High Demand (More Realistic Scenario)
 | Sumas | Seattle | Chehalis | JP | Chehalis to Roosevelt | Washougal | Kelso | Roosevelt
Flow |  | -850 |  | 525 | -425 | -400 | -100 | -490
 | Plug |  |  | Capacity |  |  |  | Capacity
Spreadsheet: 390945d1429808116-index-match-function-using-a-table-and-named-ranges-biv2
Sheet: Memberships

Current-->
Report Period | MemBud | MemPur
2012-01-30 00:00:00 | 1700 | 1412
2012-02-01 00:00:00 | 630 | 977
2012-03-01 00:00:00 | 1050 | 915
2012-04-01 00:00:00 | 700 | 737
2012-05-01 00:00:00 | 730 | 602
2012-06-01 00:00:00 | 580 | 889
2012-07-01 00:00:00 | 500 | 446
2012-08-01 00:00:00 | 550 | 502
2012-09-01 00:00:00 | 1040 | 1034
2012-10-01 00:00:00 | 1040 | 640
2012-11-01 00:00:00 | 765 | 487
2012-12-01 00:00:00 | 420 | 546
2013-01-01 00:00:00 | 1117.86 | 1469
2013-02-01 00:00:00 | 834.45 | 425
2013-03-01 00:00:00 | 603 | 1128
2013-04-01 00:00:00 | 617.46 | 674
2013-05-01 00:00:00 | 456.54 | 395
2013-06-01 00:00:00 | 690.0600000000002 | 1066
2013-07-01 00:00:00 | 457.35 | 338
2013-08-01 00:00:00 | 396.45 | 502
2013-09-01 00:00:00 | 872.4300000000001 | 999
2013-10-01 00:00:00 | 734.43 | 570
2013-11-01 00:00:00 | 464.4 | 651
2013-12-01 00:00:00 | 508.35 | 376
2014-01-01 00:00:00 |  | 1738
2014-02-01 00:00:00 | 450 | 515
2014-03-01 00:00:00 | 1251 | 1051
2014-04-01 00:00:00 | 701 | 451
2014-05-01 00:00:00 | 431 | 362
2014-06-01 00:00:00 |  | 753
2014-07-01 00:00:00 |  | 376
2014-08-01 00:00:00 | 567 | 516
2014-09-01 00:00:00 |  | 1242
2014-10-01 00:00:00 |  | 571
2014-11-01 00:00:00 | 691 | 505
2014-12-01 00:00:00 | 625 | 478
2015-01-01 00:00:00 | 1754 | 1484
2015-02-01 00:00:00 | 496 | 488
2015-03-01 00:00:00 | 932 | 694
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
2015-07-01 00:00:00
2015-08-01 00:00:00
2015-09-01 00:00:00
2015-10-01 00:00:00
2015-11-01 00:00:00
2015-12-01 00:00:00
Spreadsheet: f2ed6464-e70b-4b2f-b456-a7a84b7c5d71
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | Liberty Memorial Museum Expansion |  |  |  | To get Liberty Memorial the Funds when needed
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor
 | To appropriate funds to the Liberty Memorial Project
 | for the Liberty Memorial Museum Expansion. |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 | Appropriate funds to the Liberty Memorial Museum
 | Expansion the funds will be reimbursed for such
 | expenditures made on and after the date hereof. |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  | X |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Reviewed by:
Reference Numbers
Spreadsheet: jeffrey_a_shankman__13928__JCC Swap Model-DPR (JH)
Sheet: JCC Fwd Curve Development

Daily JCC Forward Curve Generator
 | JCC(t) = (1+C+E) x JCC(t-1) - E x JCC(t-2) - (A x C) + (D x Brent(t)) + (-(B x C) - D + F) x Brent(t-1) - F x Brent(t-2)
 | Forward Date | Brent Swap Curve |  | [NAME] |  |  | Long-term Model | A
 |  | Settled | Forward | Settled | Model |  |  | B
 |  |  |  |  |  |  | Error Correction | C
 |  |  |  |  |  |  | Model | D
 |  |  |  | 25.87 |  |  |  | E
 |  | 0 |  | 0 |  |  |  | F
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
Spreadsheet: 816758d1675818674-populate-another-sheet-if-the-conditions-are-met-auto-populate
Sheet: ISABELLE

 |  |  |  |  |  |  |  | START |  | END/STOP
Unit | NAME | Requesting Unit | Name of Accounts | Classification of Transactions (Simple, Complex, Highly Technical) | No. of Collateral/s | Location | Appraised Value | Date of Receipt of Complete Documents | Date of Inspection  (Month-Date-Year) | Date of Approval | Date of Return | Number of Working Days (WD) Processed* | Number of incidence    beyond TAT | Remarks
REGION | ISABELLE | ABC | NOTES | SIMPLE | 1 | LONDON | 4250000 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 |  | 1 |  | DONE
 |  | ABC | NOTES | COMPLEX | 15 | AUSTRALIA | 27300000 | 2023-01-03 00:00:00 | 2023-01-20 00:00:00 |  | 2023-01-26 00:00:00 | 4 |  | RETURNED
 |  | ABC | NOTES | HIGHLY TECHNICAL | 1 | US | 21000000 | 2023-01-03 00:00:00 |  |  |  |  |  | WIP
1. Assuming that Sheet "ISABELLE" is the masterlist of the 3 other sheets: "Approved, Returned & Work-in-progress"
2. How can I populate the 3 other sheets using the dates as reference in Column K & L?
Given that:
Sheet "Approved" = "Date of Approval" Column K
Sheet "Returned" = "Date of Return" Column L
Sheet "Work-in-progress" = if both "Date of Approval" & "Date of Return" are empty
Spreadsheet: 32505d1228729240-too-many-arguments-maybe-vlookup-lookup-range
Sheet: Data List

cheese |  | -8
pie |  | -7
cheese |  | -6
pie |  | -5
cheese |  | -4
pie |  | -3
cheese |  | -2
pie |  | -1
cheese |  | 0
pie |  | 1
cheese |  | 2
pie |  | 3
cheese |  | 4
cheese |  | 5
pie |  | 6
cheese |  | 7
pie |  | 8
cheese |  | 9
pie |  | 10
cheese |  | 11
pie |  | 12
cheese |  | 13
pie |  | 14
cheese |  | 15
pie |  | 16
cheese |  | 17
cheese |  | 18
pie |  | 19
cheese |  | 20
pie |  | 21
cheese |  | 22
pie |  | 23
cheese |  | 24
pie |  | 25
cheese |  | 26
pie |  | 27
cheese |  | 28
pie |  | 29
cheese |  | 30
cheese |  | 31
pie |  | 32
cheese |  | 33
pie |  | 34
Spreadsheet: 698502d1602008960-lookup-column-header-based-on-cell-value-found-from-row-name-holiday-tracker
Sheet: Sheet1

Colleague Hols | 2020-08-23 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-29 00:00:00 | 2020-08-30 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-05 00:00:00
 | 2020-08-23 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-29 00:00:00 | 2020-08-30 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-05 00:00:00
Mandy |  |  |  |  |  |  |  |  | BH
[NAME] |  |  |  |  |  |  |  |  | BH
[NAME] |  |  |  |  |  | H |  |  | BH
[NAME] |  | H | H | H | H | H |  |  | BH |  | H
Grant |  | H | H | H | H | H |  |  | BH
[NAME]
Ric |  |  |  |  |  |  |  |  | BH
 | OUTPUT
 |  | Mandy | [NAME] | [NAME] | [NAME] | Grant | [NAME] | Ric
Spreadsheet: 210932d1359606247-selecting-rows-in-a-table-based-on-another-list-sample-1
Sheet: Result

Sheet1
no. | name | age | salary (k) | id
1 | [NAME] | 34 | 5 | 4975
2 | [NAME] | 23 | 8 | 5656
3 | [NAME] | 67 | 3 | 8888
4 | [NAME] | 43 | 7 | 7654
5 | [NAME] | 22 | 8 | 2343
6 | [NAME] | 44 | 2 | 6567
7 | romeo | 77 | 11 | 5786
8 | bridget | 44 | 14 | 5342
9 | lindsay | 22 | 5 | 4535
10 | henry | 66 | 7 | 7890
Spreadsheet: 375930d1423412407-need-help-cleaning-up-pasted-text-and-comparing-two-lists-packingnotecomparison-2-
Sheet: AfterPastingSheet

Page 1 Date:
Quantity
100
4
1
8
113
Packed By:
Signature
My Company name [NAME]
My company slogan
Ship To: Shipping Address: (If [NAME]) februari 8, 2015
[Name] [Name] Customer ID: [ABC12345]
[Company Name] [Company Name] Order Date
[Street Address] [Street Address] Purchase Order # [100001]
[City, ST ZIP Code] [City, ST ZIP Code] Salesperson [NAME]
[Phone] [Phone] Packing Date
Description
84455661
Lollipop
jklj888787
665466477
Snickers
hkjsdhjfkhsdf
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
54878454888
High sugar no vitamins drink
1234545
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name]
[Managers Signature]
Spreadsheet: 96547d1295932711-excel-2007-how-to-find-conditional-means-jaspalcheemadata
Sheet: Expected Results

 |  | Number of Detached [NAME] in November 2010 | 275
 |  | Average of sold prices of Detached Homes in November 2010 | 413357
 |  | Average sold price of the lowest 20% or 55 homes
 |  | Next 55
 |  | Next 55
 |  | Next 55
 |  | Average sold price of the remaining 55 homes (275 minus 55x4 = 55). The first 4 categories will have equal number of homes, and the last will have the remaining.
Spreadsheet: 854669d1704458485-data-validation-to-allow-only-alphanumerics-example-sheet-ans2
Sheet: Sheet1

Pickup Street | Pickup City | [NAME] | [NAME] | Dropoff Street | Trip Purpose | Dropoff City | Dropoff State | [NAME] |  | FORMULA
1234 Fake Street | Auburn | WA | 98072 | 4567 Fake Street | Groceries | Auburn | WA | 98072 |  | =IF(A2="",1,LET(l,[NAME],CODE(MID(A2,ROW(INDIRECT("1:"&l)),1)),b,[NAME]))
4567 Fake Street | Auburn | WA | 98072 | 1234 Fake Street | Shopping | Auburn | WA | 98007
4333 Faux Ave | Seattle | WA | 98032 | 8796 Not Real Ave | Groceries | Kent | WA | 98032
8796 Not Real Ave | Kent | WA | 98032 | 4333 Faux Ave | Shopping | Seattle | WA | 98032
Spreadsheet: dd34e18e-5423-4c68-a091-d0e992730514
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44404048 | 2014-12-11 23:43:55 | ALLIES | 0 | 2 | 5 | 971251 | [NAME] | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
44405314 | 2014-12-12 02:07:00 | AXIS | 0 | 3 | 5 | 1673324 | Massive Dragon | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
Spreadsheet: 96044d1295524016-lookup-formula-athletics
Sheet: JuniorMenEntries

60mH | 60mSprint | 200m | 400m | 800m | 1500m | 3000m | 3000m Walk | High Jump | Long Jump | Pole Vault | Shot | Triple Jump | Weight | Athlete # | Athlete Name | Athlete Club | Junior Men
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 60

कार्यक्रम PROGRAM |  |  | HIGH IMPACT SALES LEADERSHIP TRAINING PROGRAM | PROG CODE
 |  |  |  | IT 2306
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | Customer Centricity, Customer Engagement & Enhancing Cross selling Opportunities
लतक्षि समूह/TARGET GROUP |  |  | Scale I, II, III & IV
अर्तध/DURATION |  |  | 2 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Registration & Inauguration, Corporate Message & Ice Breaking, EASE Reforms
 | II | Introduction of Selling skill, Cross-selling & up-selling techniques
 | III | Situational  Marketing  Skills-   Understanding  positioning  of  right Product to right customer.
 | IV | Nurturing  Customer  Service  through  efficient  Communication  & Interpersonal Relationship
 | V | Product Penetration ,Wallet Share Maximization & Negotiation Skills & Win-win strategies
Day 2 | I | Team Building Activities & Problem solving and Decision Making
 | II | Motivation & Team Building
 | III | Augmenting CASA through Digital Products
 | IV | Sales Presentation skills
 | V | Ethical selling practices