tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40116d1238439548-compare-two-lists-and-highlight-differences-help-file
Sheet: Sheet1

Master List |  |  |  |  |  |  |  |  |  |  |  |  | Second List
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 |  |  | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11
M0221400001 | aaa |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | M0221400003 | cccc | asd | 8003 | 1 | 0 | 0 | 0 | 0 | 0
M0221400100 | dd | asd | 8042 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | M0221400002 | bb |  |  |  | 0 | 0 | 0 | 0 | 0
M0221400003 | cccc | asd | 8003 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | M0221400100 | cc | asd | 8042 |  | 0 | 1 | 0 | 0 | 0
M0221400004 | ssss | asd | 8006 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | M0221400004 | ssss | asd | 8006 | 1 | 0 | 0 | 0 | 0 | 0
M0221400002 | bbaxx |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | M0221400001 | aaa |  |  |  | 0 | 0 | 0 | 0 | 0
 | Need to compare both lists, Master [NAME] and Second List, each row and all columns (1 - 11), row by row.
 | If any of the columns is different in that particular row, highlight the entire row yellow.
 | If the entire row and all colums in that particular row are identical leave it alone.
 | e.g.
 | Row 3 in Master [NAME] is left alone because row 7 in Second List is identical both row and column.
 | Row 5 in Master [NAME] is left alone because row 1 in Second List is identical both row and column.
 | Row 4 in Master [NAME] is highlighted because row 5 in Second List is not identical both row and column.
 | Row 6 in Master [NAME] is highlighted because row 6 in Second List is not identical both row and column.
 | Row 7 in Master [NAME] is highlighted because row 4 in Second List is not identical both row and column.
 | Note:
 | It doesn’t matter if lists are sorted by any of the columns because the lists will never have consecutive numbers.
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Power Volume Management

Power Volume Management |  | ok
[NAME] | [NAME] | 1
[NAME] | Director | 1
[NAME] | Spec
[NAME] | Spec
Marci Mansfield | Spec | 3
[NAME] | Sr. Spec | 1
[NAME] | Staff
[NAME] | Staff | 2
Spreadsheet: mary_fischer__25403__wr594_data
Sheet: Comm Dates

Commissioning Dates
Turbine ID | Acceptance Date
840007001 | 2001-12-11 00:00:00
840007002 | 2001-12-11 00:00:00
840007003 | 2001-12-11 00:00:00
840007004 | 2001-12-11 00:00:00
840007005 | 2001-12-11 00:00:00
840007006 | 2001-12-11 00:00:00
840007007 | 2001-12-11 00:00:00
840007008 | 2001-12-11 00:00:00
840007009 | 2001-12-11 00:00:00
840007010 | 2001-12-11 00:00:00
840007011 | 2001-12-18 00:00:00
840007012 | 2001-12-11 00:00:00
840007013 | 2001-12-11 00:00:00
840007014 | 2001-12-11 00:00:00
840007015 | 2001-12-11 00:00:00
840007016 | 2001-12-18 00:00:00
840007017 | 2001-12-11 00:00:00
840007018 | 2001-12-11 00:00:00
840007019 | 2001-12-11 00:00:00
840007020 | 2001-12-11 00:00:00
Spreadsheet: 72960d1273659533-adding-data-according-to-date-sales-by-day-and-month
Sheet: Sheet1

 | Dates | Total Sales |  |  |  |  |  | Sales by Month
 | 2010-04-01 00:00:00 | 20 |  |  |  |  |  | Jan
 | 2010-04-02 00:00:00 | 30 |  |  |  |  |  | Feb
 | 2010-04-02 00:00:00 | 25 |  |  |  |  |  | Mar
 | 2010-04-03 00:00:00 | 60 |  |  |  |  |  | Apr
 | 2010-04-08 00:00:00 | 40
 | 2010-04-09 00:00:00 | 40
 | 2010-04-15 00:00:00 | 25
 | 2010-04-15 00:00:00 | 60
 | 2010-05-10 00:00:00 | 40
 | 2010-05-11 00:00:00 | 10
 | 2010-05-11 00:00:00 | 30
 | 2010-05-11 00:00:00 | 4
Spreadsheet: 70405d1271169130-counting-records-in-using-lookup-book1-2-
Sheet: email data

Id | Date | Time | Day | AM / PM | Week | Profile Code | Profile Description | email address (URN) | Postal address | Town | Postcode | Channel | Data Owner | Owner (Site) | Client name | Subject line | Creative | Offer | Product | Sector | Exisiting / New client
1 | 2010-04-08 00:00:00 | 13:11:00 |  |  |  | P3 |  |  |  |  |  | email | DMRI | win4now | Win4now registration | Thank you for your win4now membership |  |  | Win4now registration | Win4now registration | Existing |  |  |  |  |  |  |  |  |  | Data Owner | Owner Site
2 | 2010-04-08 00:00:00 | 13:17:00 |  |  |  | P3 |  |  |  |  |  | email | IPT | myoffers | Triple Prize Entries | [NAME], thank you for registering with MyOffers |  |  | [NAME] | Online Marketing | Existing |  |  |  |  |  |  |  |  |  | Acxiom | emailinform | New Client
3 | 2010-04-08 00:00:00 | 13:18:00 |  |  |  | P3 |  |  |  |  |  | email | DLG | surveys | Ciao Surveys | Last step to become a Ciao Surveys member |  |  | Ciao Surveys | Ciao Surveys | Existing |  |  |  |  |  |  |  |  |  | Experian | just-rewards | Existing
4 | 2010-04-08 00:00:00 | 13:35:00 |  |  |  | P3 |  |  |  |  |  | email | DLG | surveys | DLG Affiliates | Your DLG Affiliates account is being reviewed. |  |  | ? | ? | Existing |  |  |  |  |  |  |  |  |  | DMRI | win4now
5 | 2010-04-08 00:00:00 | 13:22:00 |  |  |  | P5 |  |  |  |  |  | email | Webclubs | webclubs | web clubs newsletter | webclubs.com Newsletter |  |  | ? | ? | Existing |  |  |  |  |  |  |  |  |  | IPT | myoffers
6 | 2010-04-09 00:00:00 | 08:17:00 |  |  |  | P5 |  |  |  |  |  | email | [NAME] | getmeaticket | Getmeaticket registration | Savanna you have registered, now enter the competitions. |  |  | Online Marketing | The Price Network | Existing |  |  |  |  |  |  |  |  |  | [NAME] | getmeaticket
7 | 2010-04-11 00:00:00 | 11:09:00 |  |  |  | P5 |  |  |  |  |  | email | [NAME] | getmeaticket | Getmeaticket | Savanna, win a BMW 1 Series |  |  | Online Marketing | Lifestyles | Existing |  |  |  |  |  |  |  |  |  | Webclubs | webclubs
8 | 2010-04-13 00:00:00 | 13:08:00 |  |  |  | P3 |  |  |  |  |  | email | DMRI | win4now | Win4now | Competition entry summary |  |  | Provence Holiday | Travel | Existing |  |  |  |  |  |  |  |  |  | DLG | surveys
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plumprizes | Plumprizes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Spreadsheet: 858925d1707411111-display-value-unknown-in-row-known-with-column-index-unknown-infinite-columns-book1
Sheet: Sheet1

 |  | 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 | Week 14 | Week 15
 |  |  | A
B |  |  |  |  |  | B
C |  |  |  |  |  |  |  |  | C
Spreadsheet: 883796d1732516611-returning-1-when-it-should-be-0-rows-unique-filter-function-returning-1-when-it-should-be-0-rows-unique-filter-function
Sheet: PivotTable

Month | No. of Participant
January | 126
February | 22
April | 20
June | 4
July | 49
August | 29
September | 79
October | 17
None | 2
Grand Total | 348
Spreadsheet: 751089d1633866344-how-many-fixed-numbers-in-a-column-fixed-numbers
Sheet: Sheet1

A |  | Number of Fixed numbers
571.9292133981157 |  | 8
3698.283653586786
2850
6697.314822547633
1847
6498.325476525631
4597.738459049485
740.3835734490849
4374.979356982096
6744
7575.967529597861
956.5485212158798
979
4669.439991643751
5144.639852852681
1940
2513.836640059512
5485
96.07969035634989
1028
2023.071747504869
522.1041921814085
4005.782874006964
4354
8519.976537446886
8967.455126862269
8898.570509307023
Spreadsheet: 218338d1362430650-is-it-possible-to-cross-match-duplicates-in-2-different-workbooks-with-a-formula-c-book2
Sheet: Sheet1

 |  | 2013-02-08 00:00:00 |  |  |  |  |  |  |  |  | tom | 1
 |  | 2013-02-02 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | 2
 |  | 2013-02-03 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | 3
 |  | 2013-02-04 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | 4
 |  | 2013-02-05 00:00:00 |  |  |  |  |  |  |  |  | jean | 5
 |  | 2013-02-06 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | 6
 |  | 2013-02-07 00:00:00 |  |  |  |  |  |  |  |  | jill
 |  | 2013-02-08 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-09 00:00:00 |  |  |  |  |  |  |  |  | fred
 |  | 2013-02-10 00:00:00 |  |  |  |  |  |  |  |  | mat
 |  | 2013-02-11 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-12 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-13 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-14 00:00:00 |  |  |  |  |  |  |  |  | michelle
 |  | 2013-02-15 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-16 00:00:00 |  |  |  |  |  |  |  |  | tom
 |  | 2013-02-17 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-18 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-19 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-20 00:00:00 |  |  |  |  |  |  |  |  | jean
 |  | 2013-02-21 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-22 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
 |  | 2013-02-23 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 738860d1625302673-adding-a-max-to-a-formula-to-prevent-a-return-of-a-minus-result-midshires-master
Sheet: Official

Official Handicap | PLAYER | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Stroke Index |  |  |  |  | HANDICAPPING ALTERATIONS
 |  | PAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Official H'Caps |  |  |  |  | catagory | BUFFER | css | Nett | adjustment
 |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/I 1 | S/1 2 | S/1 3 |  |  |  | ZONE |  | Differential |  | sss | css adj | "RO"
Spreadsheet: 875420d1721990561-sum-after-sort-unique-vstack-with-criteria-for-multiple-worksheet-vstack-with-criteria-3-
Sheet: P1

 |  |  |  | SN1 | SN2 | Particulars | ID |  |  |  |  |  |  |  |  |  |  | Header 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | 77 |  | Apple | 5263 |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  | 321 |  | Orange | 125 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  | 167 |  | Nuts | 3 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 402 |  | Apple |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  | 919 |  | Text1 | 26 |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  | 37484 | Jasmine
 |  |  |  | 45 |  | Orange | 125 |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  | 55 |  | Deep | 412 |  |  |  |  |  |  |  |  |  |  | 44
Spreadsheet: joe_parks__15052__BridgeDPR0614
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1446.949564000002 | 6601.949564000001 | 11892.949564
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1446.949564000002 | 6601.949564000001 | 11892.949564
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 232752d1367517055-one-excel-file-pages-will-not-print-other-excel-files-print-just-fine-sample-employee-list-2013
Sheet: Points 13

# | First Name | MI | Last Name | Jan  Pts | Feb  Pts | [NAME] | Apr  Pts | [NAME] | June  Pts | July  Pts | Aug  Pts | Sept  Pts | [NAME] | Nov  Pts | [NAME] | Total Points | Notes
0 | 0 | 0 | 0 | 5 | 5 |  | 15 |  |  |  |  |  |  |  |  | 25 | 25(V-4/26)
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 | 10 |  |  |  |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  | 10 | 5 |  |  |  |  |  |  |  |  | 15
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  | 10 |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  | 10 |  |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 |  | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  | 5 |  | 5 |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 | 5 |  | 5 |  |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  | 10 | 5 |  |  |  |  |  |  |  |  |  | 15
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  | 15 |  |  |  |  |  |  |  |  |  |  | 15
0 | 0 | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
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 |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 | 10 | 10 | 5 | 5 |  |  |  |  |  |  |  |  | 30 | 25(V-3/18)
0 | 0 | 0 | 0 | 10 |  |  |  |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  | 15 |  |  |  |  |  |  |  |  |  | 15
0 | 0 | 0 | 0 | 5 | 10 | 5 | 20 |  |  |  |  |  |  |  |  | 40 | 25(V-4/26)
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 | 5 |  |  | 5 |  |  |  |  |  |  |  |  | 10
0 | 0 | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 | 10 | 5 | 10 | 10 |  |  |  |  |  |  |  |  | 35 | 25(V-3/15)
0 | 0 | 0 | 0 |  |  |  | 10 |  |  |  |  |  |  |  |  | 10
 |  |  |  | Blue = 50 - 74 Points,   Green = 75 - 99 Points,  Red = 100 Points or More
Spreadsheet: 109850d1306657704-lookup-compare-and-copy-in-2-woorkbooks-match-and-copy
Sheet: Data

 | Description | Att-1 | Att-2 | Att-3 | Att-4
 | White | A1 | A2 | A3 | aaa
 | Blue | C2 | B2 | B3 | bbb
 | Green | C1 | C2 | [NAME] | [NAME]
 | Red | D1 | D2 | D2 | ddd
Spreadsheet: 781724d1653501222-filter-formula-with-multiple-conditions-test2
Sheet: Sheet2

 |  |  | Person | Region | Responsible | District
 |  |  |  | R | Single | 11
 |  |  | B | R | Multi | 11
 |  |  | C | R | Single | 11
 |  |  | G | R | Multi | 12
 |  |  | I | R | Multi | 14
 |  |  | Person | Region | Responsible | District
 |  |  |  | R | Multi | 11
 |  |  | G | R | Multi | 12
 |  |  | I | R | Multi | 14
 |  |  | Person | Region | Responsible | District
Spreadsheet: 61121d1261825039-filter-by-month-name-consumptionpattern-final
Sheet: kolkata

 | Items | Date when goods arrived at the warehouse | Date when the first lot/consignment of goods were dispatched from the warehouse to the site | Qty dispatched from the warehouse | Date when the last lot/consignment of goods were dispatched from the warehouse to the site | Qty dispatched from the warehouse
 | Indoor BTS | 2009-06-05 00:00:00 | 2009-06-06 00:00:00 | 10 | 2009-10-27 00:00:00 | 1
 |  | 2009-06-11 00:00:00
 |  | 2009-06-22 00:00:00
 |  | 2009-06-25 00:00:00
 |  | 2009-07-03 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-09-24 00:00:00
 |  | 2009-11-09 00:00:00
 | Outdoor BTS | 2009-06-05 00:00:00 | 2009-07-15 00:00:00 | 5 | 2009-11-09 00:00:00 | 2
 |  | 2009-06-12 00:00:00
 |  | 2009-09-24 00:00:00
 |  | 2009-11-09 00:00:00
 | MW Antenna | 2009-07-23 00:00:00 | 2009-07-14 00:00:00 | 19 | 2009-12-05 00:00:00 | 8
 |  | 2009-08-03 00:00:00
 |  | 2009-08-04 00:00:00
 |  | 2009-08-10 00:00:00
 |  | 2009-08-25 00:00:00
 |  | 2009-08-26 00:00:00
 |  | 2009-09-02 00:00:00
 |  | 2009-09-08 00:00:00
 |  | 2009-09-14 00:00:00
 | MW HOP | 2009-08-03 00:00:00 | 2009-07-14 00:00:00 | 1378 | 2009-12-05 00:00:00 | 442
 |  | 2009-08-04 00:00:00
 |  | 2009-08-10 00:00:00
 |  | 2009-08-25 00:00:00
 |  | 2009-08-26 00:00:00
 |  | 2009-08-28 00:00:00
 |  | 2009-09-02 00:00:00
 |  | 2009-09-03 00:00:00
 |  | 2009-09-04 00:00:00
 | BSC | 2009-06-09 00:00:00 | 2009-05-20 00:00:00 | 14 | 2009-11-27 00:00:00 | 1
 |  | 2009-06-05 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-06-10 00:00:00
 |  | 2009-09-19 00:00:00
 |  | 2009-06-10 00:00:00
 |  | 2009-09-19 00:00:00
 |  | 2009-06-10 00:00:00
 |  | 2009-06-10 00:00:00
 |  | 2009-05-26 00:00:00
 |  | 2009-05-27 00:00:00
 |  | 2009-05-26 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-05-27 00:00:00
 |  | 2009-09-18 00:00:00
 |  | 2009-05-27 00:00:00
 |  | 2009-05-27 00:00:00
 | MSC/MGW | 2009-06-05 00:00:00 | 2009-05-20 00:00:00 | 6 | 2009-08-11 00:00:00 | 1
 |  | 2009-08-13 00:00:00
 |  | 2009-05-27 00:00:00
 |  | 2009-06-10 00:00:00
 |  | 2009-06-29 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-06-05 00:00:00
 |  | 2009-09-03 00:00:00
 |  | 2009-11-14 00:00:00
 |  | 2009-11-14 00:00:00
 |  | 2009-11-14 00:00:00
 |  | 2009-11-14 00:00:00
Spreadsheet: 390782d1429762740-elo-rating-database-for-up-to-500-participants-elo-ratings
Sheet: Sheet1

Input |  |  |  | Temporary Calculated Values |  |  |  |  |  |  | Desire Output
Date | Winner | [NAME] |  | Winner Rating | [NAME] | Winner Games Played | Loser Games Played | Winner K factor | Loser K factor |  | Date | Players → | [NAME] | [NAME] | Cam | [NAME] | Eve
2015-04-15 00:00:00 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | (rating) | (rating) | (rating) | (rating) | (rating)
2015-04-15 00:00:00 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Elo rating formula
2015-04-15 00:00:00 | [NAME] | [NAME]
2015-04-15 00:00:00 | Cam | [NAME]
2015-04-15 00:00:00 | Cam | [NAME]
2015-04-18 00:00:00 | [NAME] | [NAME]
2015-04-18 00:00:00 | [NAME] | Cam
2015-04-19 00:00:00 | Eve | [NAME]
2015-04-19 00:00:00 | [NAME] | Eve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/(1+10^((Opponent-Player)/400))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K factor = 40 if Games played < 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K factor = 20 if Games played >= 20
 |  |  |  |  |  |  |  |  |  |  | For up to ~500 players and ~20,000 games
For up to ~500 players and ~20,000 games
Spreadsheet: 742308d1627655178-populate-column-d-if-condition-is-met-populate-column-if-condition-met_1
Sheet: Sheet1

Total Sales | 25 | Week # | Date |  | Date | Weekday | Week
 |  |  |  |  | 2021-01-31 00:00:00 | Sun | Week 1
 |  |  |  |  |  | Mon | Week 1
 |  |  |  |  |  | Tue | Week 1
 |  |  |  |  |  | Wed | Week 1
 |  |  |  |  |  | Thu | Week 1
 |  |  |  |  |  | Fri | Week 1
 |  |  |  |  |  | Sat | Week 1
 |  |  |  |  |  | Sun | Week 2
 |  |  |  |  |  | Mon | Week 2
 |  |  |  |  |  | Tue | Week 2
 |  |  |  |  |  | Wed | Week 2
 |  |  |  |  |  | Thu | Week 2
 |  |  |  |  |  | Fri | Week 2
 |  |  |  |  |  | Sat | Week 2
 |  |  |  |  |  | Sun | Week 3
 |  |  |  |  |  | Mon | Week 3
 |  |  |  |  |  | Tue | Week 3
 |  |  |  |  |  | Wed | Week 3
 |  |  |  |  |  | Thu | Week 3
 |  |  |  |  |  | Fri | Week 3
 |  |  |  |  |  | Sat | Week 3
 |  |  |  |  |  | Sun | Week 4
 |  |  |  |  |  | Mon | Week 4
 |  |  |  |  |  | Tue | Week 4
 |  |  |  |  |  | Wed | Week 4
 |  |  |  |  |  | Thu | Week 4
 |  |  |  |  |  | Fri | Week 4
 |  |  |  |  |  | Sat | Week 4
 |  |  |  |  |  | Sun | Week 5
 |  |  |  |  |  | Mon | Week 5
 |  |  |  |  |  | Tue | Week 5
 |  |  |  |  |  | Wed | Week 5
 |  |  |  |  |  | Thu | Week 5
 |  |  |  |  |  | Fri | Week 5
 |  |  |  |  |  | Sat | Week 5
Spreadsheet: ddc1ead4-1b69-451c-8cdb-3badd99a1280
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Union Hill Special Business District
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax) |  |  |  |  |  |  |  |  |  | General
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue |  |  |  | 27275
 | Enterprise
 |  |  | Total: | $ | 27275 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | This revenue is derived from a special assessment that is imposed on property owners within the
 | Union Hill Special Business District for the operation and maintenance of decorative streetlights and
 | entry markers on an annual basis.  Each property is billed $1.50 per front foot.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue |  |  |  | 27275
 | Enterprise/Other
 |  |  | Total: | $ | 27275 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | This appropriation is solely used for the maintenance and operation of the decorative streetlights and
 | entry markers on an annual basis.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 778742d1651279123-conditional-format-where-less-than-100-howardc1001-cf-in-col-e-where-not-100-in-col-e-in-same-row-as-total
Sheet: Sheet1

Details | Branch | YTD | 2022-03-31 00:00:00 | % Split
Shirts Cash Sale Turnover | BR1 | -263806 | -53836.25 | 0.25
Shirts Turnover -Trade | BR1 | -330357 | -68933.46 | 0.5614858736477882
Total Shirts BR1 | BR1 | -594163 | -122769.72
PTS Cash Sale Turnover | BR1 | -83344 | -13725.34 | 0.3798929445339034
[NAME] | BR1 | -105878 | -22404.16 | 0.6201070554660966
Total PTS NEC | BR1 | -189222 | -36129.51 | 1