tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677529d1589385219-excel-help-3rd-non-blank-cell-from-right-in-row-example1
Sheet: Sheet1

[NAME] | Lvl2 | Lvl3 | Lvl4 | Lvl5 | Lvl6 | Lvl7 | Lvl8 | Lvl9 | Lvl10 | Lvl11 | Result
a | b | c | d | e | f | g | h | i
a | b | c | d | e | f
a | b | c | d | e | f | g
a | b | c | d | e | f | g | h
a | b | c | d | e | f | g | h | i | j
Spreadsheet: 390784d1429762777-formula-for-concurrent-services-test
Sheet: After

To Date | From Date | Person ID | prov id | Concurrent
2012-01-05 00:00:00 | 2012-01-05 00:00:00 | 11111111 | 55555 | Yes
2012-01-01 00:00:00 | 2012-01-10 00:00:00 | 11111111 | 33333
2012-01-03 00:00:00 | 2012-01-03 00:00:00 | 33333333 | 55555 | No
2012-04-12 00:00:00 | 2012-04-15 00:00:00 | 33333333 | 33333
2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 44444444 | 77777
2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 44444444 | 55555 | No
Spreadsheet: 695546d1600271971-is-there-way-to-count-if-one-or-both-columns-havent-been-filled-evaluation-counter
Sheet: Sheet1

To Evaluate: A, B, C
Date Open | Press officer | Open/ Closed | Date closed | Outcome | Sentiment
2020-09-16 00:00:00 | B | Closed | 2020-09-16 00:00:00 |  | Positive
2020-09-16 00:00:00 | B | Closed | 2020-09-16 00:00:00 | [NAME]
2020-09-15 00:00:00 | C | Closed | 2020-09-16 00:00:00 | No Story | Negative
2020-09-15 00:00:00 | A | Closed | 2020-09-15 00:00:00 | [NAME]
2020-09-14 00:00:00 | A | Closed | 2020-09-15 00:00:00 | No Story
2020-09-14 00:00:00 | C | Closed | 2020-09-14 00:00:00 |  | Positive
A2 is where I would like the evaluation counter to be placed. I am looking to have the counter increase for each 'Press Officer' by 1 when at least one of the two columns is blank (Outcome or Sentiment) is blank. | This is not a true counter per se. More of a reminder that at least one of the columns has not been filled.
Outcome & Sentiment Blank = +1
Outcome filled & Sentiment Blank = +1
Outcome Blank & Sentiment Blank = +1
Spreadsheet: 676322d1588757584-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: Scheduled Payments

Car Tax |  |  |  | Council Tax |  |  |  | Car Insurance |  |  |  | [NAME] |  |  |  | Loan |  |  |  | Rent
Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount
May | 2020 | 16.02 |  | April | 2020 | 110.4 |  | April | 2020 | 28.62 |  | June | 2020 | 30 |  | June | 2019 | 61.2 |  | April | 2020 | 72.39
June | 2020 | 15 |  | May | 2020 | 125 |  | May | 2020 | 25 |  | July | 2020 | 30 |  | July | 2019 | 62 |  | May | 2020 | 72.39
July | 2020 | 15 |  | June | 2020 | 125 |  | June | 2020 | 25 |  | August | 2020 | 30 |  | August | 2019 | 62 |  | June | 2020 | 72.39
August | 2020 | 15 |  | July | 2020 | 125 |  | July | 2020 | 25 |  | September | 2020 | 30 |  | September | 2019 | 62 |  | July | 2020 | 72.39
September | 2020 | 15 |  | August | 2020 | 125 |  | August | 2020 | 25 |  | October | 2020 | 30 |  | October | 2019 | 62 |  | August | 2020 | 72.39
October | 2020 | 15 |  | September | 2020 | 125 |  | September | 2020 | 25 |  | November | 2020 | 30 |  | November | 2019 | 62 |  | September | 2020 | 72.39
November | 2020 | 15 |  | October | 2020 | 125 |  | October | 2020 | 25 |  | December | 2020 | 30 |  | December | 2019 | 62 |  | October | 2020 | 72.39
December | 2020 | 15 |  | November | 2020 | 125 |  | November | 2020 | 25 |  | January | 2020 | 30 |  | January | 2020 | 62 |  | November | 2020 | 72.39
January | 2021 | 15 |  | December | 2020 | 125 |  | December | 2020 | 25 |  | February | 2021 | 30 |  | February | 2020 | 62 |  | December | 2020 | 72.39
February | 2021 | 15 |  | January | 2021 | 125 |  | January | 2021 | 25 |  | March | 2021 | 30 |  | March | 2020 | 62 |  | January | 2021 | 72.39
March | 2021 | 15 |  | February | 2021 | 125 |  | February | 2021 | 25 |  | April | 2021 | 30 |  | April | 2020 | 62 |  | February | 2021 | 72.39
April | 2021 | 15 |  | March | 2021 | 125 |  | March | 2021 | 25 |  | May | 2021 | 22.75 |  | May | 2020 | 62 |  | March | 2021 | 72.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 2020 | 62
Spreadsheet: 701598d1603831454-adjustment-on-index-match-formula-to-accommodate-more-transactions-students-payment
Sheet: Students Payment History

Waterford Primary School
12 Shephereds Way
[NAME]
Bulawayo
Tel: 879120
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance |  |  | Sheet | Row
Desired Outcome
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
2020-01-01 00:00:00 |  | C001 | 400
2020-01-10 00:00:00 |  | 1 | 2000
2020-01-12 00:00:00 | R010 | C001 |  | 300
2020-01-14 00:00:00 | R012 | 3 |  | 1000
2020-05-12 00:00:00 |  | 5 | 2300
2020-09-09 00:00:00 |  | 9 | 2500
Spreadsheet: 888220d1738691328-autofill-holiday-calendar-for-individual-people-holiday-calendar-fill
Sheet: Name 1

Name: |  | Name 1
Core Hours:
Holiday Entitlement: |  | 20
Holiday Year Start:
From | To | Days | Remaining |  |  | [NAME] | [NAME]
2025-05-05 00:00:00 | 2025-05-09 00:00:00
2025-02-03 00:00:00 | 2025-02-07 00:00:00
Spreadsheet: phillip_allen__28942__west gas prices
Sheet: Sheet1

 | Nymex | SoCal | PG&E | Malin | EPSJ | Permian |  | SoCal | PG&E | Malin | EPSJ | Permian
Feb-Mar | 9.35 |  |  |  |  |  |  | 0 |  | -0.1 | -0.8 | -0.35
Q2 | 6 |  |  |  |  |  |  | 0.65 |  |  | -0.56 | -0.14
Q3 | 5.75 |  |  |  |  |  |  | 1.5 |  |  | -0.55 | -0.05
Q4 | 4.3 |  |  |  |  |  |  | 0.81 |  |  | -0.4 | -0.05
Cal 2 | 4.6 |  |  |  |  |  |  | 0.95 |  |  | -0.33 | -0.02
Cal 3 | 3.92 |  |  |  |  |  |  | 0.65 |  |  | -0.26 | -0.01
Cal 4 | 3.8 |  |  |  |  |  |  | 0.4 |  |  | -0.22 | 0
Cal 5 | 3.8 |  |  |  |  |  |  | 0.4 |  |  | -0.22 | 0
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: R3

 |  | Sum =
 | Ref |  | Net
[NAME] | Period | Curve Code | Qty
 | 2000-05-01 00:00:00 | CGPR-DAWN | -66
 | 2000-05-01 00:00:00 | GDM-DAWN | 72
 | 2000-05-01 00:00:00 | IF-ANR/LA | 6
 | 2000-05-01 00:00:00 | IF-CGT/APPALAC | 12
 | 2000-05-01 00:00:00 | IF-CNG/APPALACH | 9
 | 2000-05-01 00:00:00 | IF-HEHUB | -24
 | 2000-05-01 00:00:00 | IF-TENN/LA | -3
 | 2000-05-01 00:00:00 | MICH_CG-GD | -3
 | 2000-05-01 00:00:00 | NGI/CHI. GATE | 3
Spreadsheet: 690356d1597066125-highlight-columns-with-duplicates-highlight-duplicates-in-columns
Sheet: Sheet1

Name | Surname | Known As | DOB
Rayne | Smythe |  | 2014-04-20 00:00:00 |  | I need to show duplicates in dates AND duplicates in Name and Surname
[NAME] | [NAME] |  | 2014-05-13 00:00:00
[NAME] | [NAME] |  | 2014-05-13 00:00:00
Holly | Green |  | 2014-05-13 00:00:00 |  | This is how it looks if I use CF Duplicates on each column
[NAME] | Smith |  | 2014-06-12 00:00:00
[NAME] | Symon |  | 2014-07-18 00:00:00
[NAME] | Smith |  | 2014-07-21 00:00:00
Name | Surname | Known As | DOB
Rayne | Smythe |  | 2014-04-20 00:00:00 |  | This is what I want it to look like
[NAME] | [NAME] |  | 2014-05-13 00:00:00
[NAME] | [NAME] |  | 2014-05-13 00:00:00
Holly | Green |  | 2014-05-13 00:00:00 |  | Note:- this is a sample of a much larger sheet with a few thousand lines and several columns
[NAME] | Smith |  | 2014-06-12 00:00:00
[NAME] | Symon |  | 2014-07-18 00:00:00
[NAME] | Smith |  | 2014-07-21 00:00:00
Spreadsheet: 708360d1607759565-functions-on-excel-search-and-copy-if-it-is-found-excel-1-
Sheet: Categories

List of Services/Functions
Area & Speed Notification
Area Notification
b-Call
Charging Stations
Cubic Data Plan
Departure Planner
Driving Data
e-Call
Functions on Demand
Google EarthTM**
Gracenote
Honk & Flash
[NAME]
Invoice
[NAME]
Login CWP
[NAME]
[NAME]
My Points Of Interest
News
[NAME]
Online Destination Import
Online Map Update
Online Personalization
Online POI Search (Text)
Online POI Search (Voice)
Online Route Calculation
Online Route Import
Online System Update
Online Traffic Information
Online Voice-Control
Order Cancellation
[NAME]
Parking Postion
Parking Spaces
Payment & Billing
Petrol Stations
RAH
Registration CWP
Registration MDA
[NAME]
Remote Air Conditioning
Remote Charging
RLU
Service Scheduling
SIM Card issue (CUBIC)
SIM Card issue (VF)
SmartLink/SmartLink+
Speed Notification
Vehicle Status
VHR
Weather
WEBSHOP
Spreadsheet: 212954d1360294221-formula-publishing-multiple-entries-originating-from-multiple-criteria-test
Sheet: Hendrick_27_7

Date | Chemical Name | Type | Injection Point | Injection  Basis | Production  Basis | Recommended Rate |  | Actual Rate (QPD) | Inventory (Gallons) | Days Remaining  on Invetory | Injection  Method | Comments | Previous Service Date
 |  |  |  |  |  | (PPM) | (QPD)
2013-01-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | - | -
2013-01-14 00:00:00 | CLAS89 | Dispersant | Power Oil Suction | 60 | Produced Oil | 225 | 8 | 8 | 10 | 5 | [NAME]
2013-01-18 00:00:00 | rgdfg | 5454 | 8 | 48 | 6 | 15 | 651 | 541 | 861 | 51 | 31 | 521
Spreadsheet: 95195d1294851771-merge-and-sort-non-adjacent-cells-excel-help
Sheet: Report I want

Employee | Event | Log Time | Minutes |  | Tardy?
A | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
B | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
C | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
D | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  |  | 0 | No
 | [NAME]
 | Lunch Ends |  |  | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  |  | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
E | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  |  | 0 | No
 | [NAME]
 | Lunch Ends |  |  | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  |  | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
F | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | Break 1 Ends |  |  | 0 | No
 | [NAME]
 | Lunch Ends |  |  | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  |  | 0 | No
 | End of Day
Spreadsheet: 230953d1366910934-sales-journal-rapports-semaine
Sheet: Flyers

 |  |  | Édition :
Client | Format | [NAME] | Prix | Comm
 |  |  | 0
 |  | TOTAL
Spreadsheet: 12b0dd05-3d9d-42b8-93b3-e55b50b198be
Sheet: Page 18

2010 Personal Income Tax
Taxable Income by County
($ thousands)
 | Number of |  | Taxable |  |  | Number of |  | Taxable
County | Returns 1 |  | Income 2 |  | County | Returns |  | Income
Total All Returns | 5842709 |  | 310368447 |  | [NAME] | 20889 |  | 771030
Out-Of-State | 342161 |  | 17375804 |  | Juniata | 10477 |  | 390746
Pennsylvania | 5500548 |  | 292992643 |  | [NAME] | 94109 |  | 4062341
Adams | 46081 |  | 2068706 |  | Lancaster | 236994 |  | 11574850
Allegheny | 551384 |  | 31773581 |  | [NAME] | 39353 |  | 1662532
[NAME] | 31127 |  | 1571021 |  | Lebanon | 63080 |  | 2685631
Beaver | 77167 |  | 3277621 |  | Lehigh 3 | 161929.293 |  | 8031279
Bedford | 21659 |  | 774314 |  | Luzerne | 143506 |  | 5998571
Berks | 184059 |  | 8733625 |  | Lycoming | 52164 |  | 2108173
Blair | 54867 |  | 2210238 |  | McKean | 17897 |  | 709218
Bradford | 27191 |  | 1243043 |  | Mercer | 49157 |  | 1895718
Bucks | 294713 |  | 21414647 |  | Mifflin | 19941 |  | 679378
Butler | 84391 |  | 4876171 |  | Monroe | 66196 |  | 2985581
Cambria | 62361 |  | 2405091 |  | Montgomery | 374432 |  | 32387452
Cameron | 2298 |  | 74826 |  | Montour | 8642 |  | 445796
Carbon | 28757 |  | 1088125 |  | Northampton 3 | 133603.707 |  | 6848707
Centre | 54377 |  | 2784492 |  | Northumberland | 41017 |  | 1476799
Chester | 221688 |  | 20174555 |  | [NAME] | 21167 |  | 866328
Clarion | 16467 |  | 649037 |  | Philadelphia | 525166 |  | 21435934
Clearfield | 34508 |  | 1262513 |  | Pike | 21898 |  | 985672
[NAME] | 15445 |  | 564315 |  | Potter | 7228 |  | 298603
Columbia | 27893 |  | 1140429 |  | [NAME] | 64676 |  | 2546098
Crawford | 36224 |  | 1344009 |  | Snyder | 16650 |  | 621698
Cumberland | 111579 |  | 5898039 |  | Somerset | 34054 |  | 1327590
Dauphin | 123832 |  | 5927294 |  | [NAME] | 2858 |  | 122572
Delaware | 238760 |  | 16845415 |  | Susquehanna | 18319 |  | 796288
Elk | 15746 |  | 642963 |  | Tioga | 17811 |  | 747555
Erie | 119278 |  | 4940651 |  | Union | 16161 |  | 748483
Fayette | 59276 |  | 2205877 |  | Venango | 23655 |  | 849183
Forest | 2244 |  | 70042 |  | [NAME] | 18171 |  | 665263
Franklin | 66933 |  | 2832345 |  | Washington | 96106 |  | 5232730
Fulton | 6447 |  | 239140 |  | Wayne | 22473 |  | 893958
Greene | 14547 |  | 679578 |  | Westmoreland | 165675 |  | 7978466
Huntingdon | 18212 |  | 657196 |  | Wyoming | 13226 |  | 567320
Indiana | 35275 |  | 1494800 |  | York | 197081 |  | 9731401
1  The number of returns does not include returns reporting $0 taxable income.
2  Details may not add to totals due to rounding.
3  Includes a representative share of the city of Bethlehem.
Spreadsheet: 33738d1230461395-how-do-you-calculate-entries-between-months-how-do-you-calculate-entries-between-months
Sheet: Sheet1

Surname | Forename | D.O.B | Date(date name entered)
[NAME] | Doe | 1974-10-27 00:00:00 | 2008-01-06 00:00:00 | 5
[NAME] | Smith | 1953-11-06 00:00:00 | 2008-01-14 00:00:00 | 4
Vera | Dough | 1955-03-31 00:00:00 | 2008-02-05 00:00:00 | 1
[NAME] | Loaf | 1954-11-01 00:00:00 | 2008-02-27 00:00:00 | 2
[NAME] | [NAME] | 1968-03-18 00:00:00 | 2008-02-08 00:00:00 | 2
[NAME] | Fish | 1974-05-05 00:00:00 | 2008-02-02 00:00:00 | 2
[NAME] | Doe | 1951-07-25 00:00:00 | 2008-02-21 00:00:00 | 1
[NAME] | Smith | 1962-05-14 00:00:00 | 2008-02-28 00:00:00 | 2
[NAME] | Doe | 1960-08-31 00:00:00 | 2008-01-13 00:00:00 | 5
[NAME] | Smith | 1968-12-28 00:00:00 | 2008-01-03 00:00:00 | 4
Vera | Dough | 1965-10-15 00:00:00 | 2008-01-03 00:00:00 | 2
[NAME] | Loaf | 1974-07-31 00:00:00 | 2008-02-10 00:00:00 | 2
[NAME] | [NAME] | 1959-11-03 00:00:00 | 2008-01-27 00:00:00 | 1
[NAME] | Fish | 1970-06-11 00:00:00 | 2008-02-12 00:00:00 | 2
[NAME] | Doe | 1974-04-17 00:00:00 | 2008-01-07 00:00:00 | 5
[NAME] | Smith | 1966-09-23 00:00:00 | 2008-01-13 00:00:00 | 4
[NAME] | Doe | 1976-07-04 00:00:00 | 2008-01-02 00:00:00 | 5
[NAME] | Smith | 1964-07-23 00:00:00 | 2008-01-08 00:00:00 | 4
Vera | Dough | 1959-09-13 00:00:00 | 2008-01-20 00:00:00 | 2
[NAME] | Loaf | 1962-02-05 00:00:00 | 2008-01-20 00:00:00 | 1
[NAME] | [NAME] | 1963-01-14 00:00:00 | 2008-02-16 00:00:00 | 2
[NAME] | Fish | 1961-07-25 00:00:00 | 2008-01-12 00:00:00 | 1
[NAME] | Doe | 1973-01-22 00:00:00 | 2008-01-16 00:00:00 | 5
[NAME] | Smith | 1953-03-29 00:00:00 | 2008-02-07 00:00:00 | 2
Spreadsheet: 773826d1648056725-conditional-formatting-for-date-values-between-1st-of-each-month-and-15th-16th-and-eom-condformattingdates
Sheet: Dates

Date | Other
2022-01-01 00:00:00 | 92.74
 | 98.41
 | 104.08
 | 109.75
 | 115.42
 | 121.09
 | 126.76
 | 132.43
 | 138.1
 | 143.77
 | 149.44
 | 155.11
 | 160.7799999999999
 | 166.4499999999999
 | 172.1199999999999
 | 177.7899999999999
 | 183.4599999999999
 | 189.1299999999999
 | 194.7999999999999
 | 200.4699999999999
 | 206.1399999999998
 | 211.8099999999998
 | 217.4799999999998
 | 223.1499999999998
Spreadsheet: 161637d1339586427-excel-2007-help-needed-for-a-data-mining-formula-0-datamining
Sheet: 1

10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
1 | 2010-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Date | Ticker | Buy | B.Time | Sell | s.Time | Expenses | Result | Date | Ticker | Buy | B.Time | Sell | s.Time | Expenses | Result
2010-01-01 00:00:00 | 2010-01-01 00:00:00 | G-101 | 250 | 10:30:00 | 255 | 12:30:00 | 1.5
2010-01-02 00:00:00 | 2010-01-01 00:00:00 | G-101 | 255 | 11:30:00 | 250 | 13:30:00 | 1.5
2010-01-03 00:00:00 | 2010-01-02 00:00:00 | G-102 | 252 | 12:30:00 | 257 | 14:30:00 | 1.5
2010-01-04 00:00:00 | 2010-01-03 00:00:00 | G-103 | 253 | 13:30:00 | 258 | 15:30:00 | 1.5
2010-01-05 00:00:00 | 2010-01-15 00:00:00 | G-104 | 254 | 14:30:00 | 259 | 16:30:00 | 1.5
2010-01-06 00:00:00 | 2010-01-25 00:00:00 | G-105 | 255 | 15:30:00 | 260 | 17:30:00 | 1.5
2010-01-07 00:00:00
2010-01-08 00:00:00
2010-01-09 00:00:00
2010-01-10 00:00:00
2010-01-11 00:00:00
2010-01-12 00:00:00
2010-01-13 00:00:00
2010-01-14 00:00:00
2010-01-15 00:00:00
2010-01-16 00:00:00
2010-01-17 00:00:00
2010-01-18 00:00:00
2010-01-19 00:00:00
2010-01-20 00:00:00
2010-01-21 00:00:00
2010-01-22 00:00:00
2010-01-23 00:00:00
2010-01-24 00:00:00
2010-01-25 00:00:00
2010-01-26 00:00:00
2010-01-27 00:00:00
2010-01-28 00:00:00
2010-01-29 00:00:00
2010-01-30 00:00:00
2010-01-31 00:00:00
Spreadsheet: 54503d1254483834-pivot-chart-page-field-filtering-filter-pivot
Sheet: Pivot

Country | (All) |  | << Select Country from here
City Filter | (All) |  | << Only the Cities for that Country should appear in this [NAME]-down
Sum of Population
City | Total
Barcelona | 54651 |  |  |  | Note: A Macro has been put on this sheet to refresh the data everytime it is updated
Granada | 4541 |  |  |  | The Formulae are on the next sheet
[NAME] | 4511
London | 10000
Madrid | 543413
Malaga | 4541
Sheffield | 3000
York | 20000
Grand Total | 644657
Spreadsheet: 694800d1599803262-formula-for-repetitive-data-per-row-sample-data
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | Expected Result
NO | NO | NO | YES | NO | YES | YES
NO | NO | NO | YES | NO | NO | YES
YES | YES | NO | YES | NO | YES | YES
NO | NO | NO | NO | NO | NO | NO
YES | YES | YES | YES | YES | YES | NO
YES | YES | YES | NO | NO | NO | NO
YES | YES | YES | YES | YES | NO | NO
YES | NO | YES | YES | YES | YES | YES
NO | NO | YES | YES | YES | YES | NO
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: FG Mar 20

 | Daily |  |  | Last day of month
 |  |  |  | Jan | 800 | 504
1 | 1313 | 800 |  | Feb | 800 | 562
2 | 1339 | 800 |  | Mar | 800 | 794
3 | 1333 | 800 |  | Apr | 800 | 794
4 | 1268 | 800 |  | May | 800 | 673
5 | 1267 | 800 |  | Jun | 800 | 857
6 | 1263 | 800 |  | Jul | 800 | 954
7 | 1258 | 800 |  | Aug | 800 | 1036
8 | 1299 | 800 |  | Sept | 800 | 982
9 | 1337 | 800 |  | Oct | 800 | 1008
10 | 1340 | 800 |  | Nov | 800 | 913
11 | 1357 | 800 |  | Dec | 800 | 800
12 | 1360 | 800 |  | Jan | 800 | 683
13 | 1352 | 800 |  | Feb | 800 | 818
14 | 1357 | 800 |  | Mar | 800 | 759
15 | 1387 | 800 |  | Apr | 800 | 1066
16 | 1421 | 800 |  | May | 800 | 1170
17 | 1450 | 800 |  | Jun | 800 | 931
18 | 1452 | 800 |  | Jul | 800 | 1034
19 | 1490 | 800 |  | Aug | 800 | 971
20 | 1440 | 800 |  | Sep | 800 | 987
21 | 1415 | 800 |  | Oct | 800 | 855
22 | 1449 | 800 |  | Nov | 800 | 1041
23 | 1486 | 800 |  | Dec | 800 | 1062
24 | 1428 | 800 |  | Jan | 800 | 1139
25 | 1404 | 800 |  | Feb | 800 | 1291
26 | 1399 | 800 |  | Mar | 800 | 1303
27 | 1407 | 800 |  | April
28 | 1303 | 800 |  | May
29 | 1325 | 800 |  | June
30 | 1359 | 800 |  | July
31 | 1303 | 800
Total
Spreadsheet: 271531d1381963958-need-to-count-occurances-over-time-range-in-a-night-shift-providerproductivity_samplereport
Sheet: Report

 |  |  |  |  |  |  |  | For Cond. Formats |  | TARGETS>
BEMC Emergency Department Provider Report
Daily Summary for |  | 2013-10-15 00:00:00
Providers On-Shift |  |  |  |  |  |  |  | Patient Counts
Providers On-Shift |  | Shift | Zone | Total Visits | Pts/Hr. | %Admit | Avg. ESI | [NAME] (T/R) | Admitted/Obs Patients | Pt. [NAME] (AMA/Elop) | Shift Length | Provider Type | Zone
C MD, DON |  | 6a-4p (P) | Yellow |  |  |  |  |  |  |  | 10 | Physician | Yellow
DOE MD, JOHN |  | 7a-5p (P) | Blue |  |  |  |  |  |  |  | 10 | Physician | Blue
G MD, NANCY |  | 7a-7p (P) | Orange |  |  |  |  |  |  |  | 12 | Physician | Orange
Y MD, [NAME] |  | 9a-6p (P) | Green |  |  |  |  |  |  |  | 9 | Physician | Green
M MD, ANN |  | 10a-8p (P) | Purple |  |  |  |  |  |  |  | 10 | Physician | Purple
M MD, ANN |  | 4p-2a (P) | Yellow |  |  |  |  |  |  |  | 10 | Physician | Yellow
P MD, DAVE |  | 6p-4a (P) | Green |  |  |  |  |  |  |  | 10 | Physician | Green
X MD, JOE |  | 7p-3a (P) | Blue |  |  |  |  |  |  |  | 8 | Physician | Blue
H DO, [NAME] |  | 7p-7a (P) | Orange |  |  |  |  |  |  |  | 12 | Physician | Orange
S MD, TOM |  | 8p-6a (P) | Purple |  |  |  |  |  |  |  | 10 | Physician | Purple
A PA, PAUL |  | 6a-4p (MLP) | Blue |  |  |  |  |  |  |  | 10 | Mid-Level | Blue
B PA, CINDY |  | 9a-7p (MLP) | Purple/Blue |  |  |  |  |  |  |  | 9 | Mid-Level | Purple/Blue
A PA, PAUL |  | 11a-9p (MLP) | Lavendar |  |  |  |  |  |  |  | 10 | Mid-Level | Lavendar
K PA, [NAME] |  | 3p-1a (MLP) | Purple |  |  |  |  |  |  |  | 10 | Mid-Level | Purple
B PA, DON |  | 5p-3a (MLP) | Blue |  |  |  |  |  |  |  | 10 | Mid-Level | Blue
OVERALL
Spreadsheet: 07141166-52fd-45bd-9b1b-682853940a2d
Sheet: 1RD OUT OF 215

ANON# | RANK
11430 | 6
11860 | 43
12980 | 37
16530 | 29
16793 | 8
16920 | 4
17400 | 34
17900 | 26
17970 | 17
18215 | 39
18592 | 48
19110 | 40
19190 | 2
19830 | 30
23374 | 22
26458 | 21
27140 | 24
34063 | 25
35377 | 7
42436 | 10
43204 | 31
45240 | 28
46476 | 47
48040 | 3
48440 | 23
49116 | 15
51445 | 15
55690 | 46
59360 | 20
60862 | 49
61052 | 40
63516 | 5
63536 | 9
63796 | 50
64124 | 52
65084 | 19
68820 | 45
69488 | 35
70099 | 33
70939 | 1
70963 | 11
78173 | 14
78387 | 12
78738 | 18
79490 | 38
80104 | 53
80720 | 42
84488 | 53
89048 | 35
89280 | 13
91829 | 51
98579 | 44
99010 | 27
99998 | 32