tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 031cd13b-44d6-4096-a608-26f9a21dd508
Sheet: AMH CMH Patients Served

 |  | Adult Mental Health |  |  | Children's Mental Health
 |  | Number of adults served this Month | Number of adults served [NAME] |  | Number of children served this Month | Number of children served [NAME]
Region 1 | Benewah | 345 | 633 |  | 63 | 120
 | [NAME]
 | Boundary
 | Kootenai
 | Shoshone
Region 2 | Clearwater | 221 | 441 |  | 79 | 102
 | Idaho
 | Latah
 | Lewis
 | Nez Perce
Region 3 | Adams | 584 | 865 |  | 72 | 135
 | Canyon
 | Gem
 | Owyhee
 | Payette
 | Washington
Region 4 | [NAME] | 598 | 1596 |  | 154 | 264
 | Boise
 | Elmore
 | Valley
Region 5 | Blaine | 234 | 580 |  | 68 | 132
 | [NAME]
 | Cassia
 | Gooding
 | [NAME]
 | Lincoln
 | Minidoka
 | [NAME]
Region 6 | Bannock | 228 | 501 |  | 51 | 103
 | Bear Lake
 | [NAME]
 | Franklin
 | Oneida
 | Power
Region 7 | Bingham | 488 | 975 |  | 157 | 326
 | [NAME]
 | [NAME]
 | [NAME]
 | Custer
 | Fremont
 | [NAME]
 | Lemhi
 | [NAME]
 | Teton
Unknown |  | . | . |  | . | .
Statewide
 |  | AMH Clients Served October | AMH Clients Served SFY12 |  | CMH Clients Served October | CMH Clients Served SFY13
 |  | 318 | 516 |  | 57 | 95
 |  | 226 | 366 |  | 66 | 85 |  |  | 76 | 114 | 45 | 48
 |  | 444 | 634 |  | 58 | 102 |  |  | 83 | 147 | 68 | 66
 |  | 587 | 1224 |  | 126 | 208
 |  | 216 | 463 |  | 54 | 99
 |  | 213 | 399 |  | 54 | 90
 |  | 442 | 796 |  | 165 | 270
 |  | 2446 | 4398 |  | 580 | 949
 |  | 326 | 414 |  | 63 | 80
 |  | 205 | 266 |  | 69 | 75
 |  | 430 | 527 |  | 76 | 83
 |  | 605 | 830 |  | 114 | 147 | 63 | 69 |  |  |  |  | 186
 |  | 236 | 362 |  | 45 | 68 | 80 | 75 | 430 | 605 | 236 | 244 | 213
 |  | 244 | 315 |  | 48 | 66 |  |  | 527 | 830 | 362 | 315
 |  | 543 | 656 |  | 186 | 213
 |  |  |  |  |  |  | 326 | 205 |  |  |  |  | 543
 |  |  |  |  |  |  | 414 | 266 |  |  |  |  | 656
 |  |  |  |  |  |  | 326 | 414
 |  |  |  |  |  |  | 205 | 266
 |  |  |  |  |  |  | 430 | 527
 |  |  |  |  |  |  | 605 | 830
 |  |  |  |  |  |  | 236 | 362
 |  |  |  |  |  |  | 244 | 315
 |  |  |  |  |  |  | 543 | 656
Spreadsheet: 4dfd5064-6dce-458a-841f-ba7969bdc753
Sheet: Sheet1

TRÖÔØNG ÑAÏI HOÏC KHOA HOÏC TÖÏ NHIEÂN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | COÄNG HOØA XAÕ HOÄI CHUÛ NGHÓA VIEÄT NAM | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
PHOØNG ÑAØO TAÏO |  |  |  |  | ÑOÄC LAÄP - TÖÏ DO - HAÏNH PHUÙC
THÔØI KHOÙA BIEÅU HOÏC KYØ 2 NAÊM HOÏC 2011-2012
[NAME] CHÖÙC NGAØNH COÂNG NGHEÄ THOÂNG TIN KHOÙA 2011 -11HT(HK1)
LYÙ THUYEÁT BAÉT ÑAÀU TÖØ 27/2/2012 ÑEÁN 13/5/2012
THÖÏC HAØNH BAÉT ÑAÀU TÖØ 12/03/2012 ÑEÁN 6/05/2012
SOÁ SV | THÖÙ HAI | [NAME] | THÖÙ TÖ | THÖÙ NAÊM | THÖÙ SAÙU | CHUÛ NHAÄT | CHIEÀU CHUÛ NHAÄT | CHUÛ NHAÄT
 | 17h50-21h10 | 17h50-21h10 | 17h50-21h10 | 17h50-21h10 | 17h50-21h10 | 7h30-10h50 | 13g20-16g40 | 13g20-16g40
 | Thöïc haønh | [NAME] trò | NM Coâng ngheä | Thöïc haønh | [NAME] thuyeát ñoà thò | Anh vaên 3 | Thöïc haønh
60 | [NAME] | cô sôû döõ lieäu | phaàn meàm | NMCNPM |  |  | [NAME] thuyeát ñoà thò
 |  | TN Hoaøi Ñöùc | NBN Phöông |  | [NAME] | Thaày Trieát
 | F109,F110 | B11 | F205A | B44 | F205A | F205B | F109,F110
 |  |  |  |  | TPHCM,  NGAØY 21 THAÙNG 2 NAÊM 2012
 |  |  |  |  | TRÖÔÛNG PHOØNG ÑAØO TAÏO
Spreadsheet: 66cc9a88-9245-4dc2-a44c-15c065ea7a28
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Reporting period | Unnamed: 3 | Unnamed: 4
 | 20011-12
 | Category total | Number immunized | Number declined | Immunization Percentage
Employees
Care providers
Non-care providers
Total - Employee
Non Employee
Family members
MFR / Fire personnel
Total - Non Employee |  | 0
Vaccine Information
Vaccine Ordered (if applicable) | doses | administered | wasted
Injectable
[NAME]
Defintions
Period: | Year end numbers for benchmark. We continue immunizations through end of influenza season.
Employees: | Number of employees working in this category during the benchmark period. We do not include on leaves of absence.
Care Providers: | Employees who have prolonged contact with patients or client. We include our wheelchair van employees in this category.
Non-care providers: | Employees having little or short duration contact with our customers.
Number immunized: | Employees receiving influenza immunization from any source including personal physician, hospital, etc.
Number declined: | Employees declining immunization due to personal choice or other medical reason.
Spreadsheet: 679342d1590339207-index-match-duplicate-values-need-to-ignore-zeros-or-blanks-in-range-example-copy
Sheet: Sheet1

Team | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7
 |  |  |  |  |  |  |  |  | Top Team | Second Top Team
Score | 1 | 2 | 1 | 3 | 2 | 0 | 1 |  |  |  |  | (Array formula)
 | 4 | 3 | 3 | 0 | 3 | 1 | 2 |  |  |  |  | INDEX($B$4:$H$4,MATCH(LARGE($B7:$H7-COLUMN($B7:$H7)/10^10,COLUMNS($J7:J7)),$B7:$H7-COLUMN($B7:$H7)/10^10,0))
 | 2 | 4 | 2 | 2 | 3 | 4 | 3
 | 4 | 0 | 1 | 3 | 3 | 4 | 2
 | 4 | 1 | 3 | 2 | 3 | 4 | 1
 | 2 | 2 | 3 | 0 | 1 | 2 | 4
 | 1 | 4 | 4 | 3 | 2 | 3 | 0
 | 0 | 1 | 1 | 4 | 4 | 1 | 4
 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Requirement
 |  |  |  |  |  |  |  |  | I need the answers above, for both top team & second top team to only be teams that have scored greater than 0
 |  |  |  |  |  |  |  |  | See example of the bottom row, the only top score is 1. In this example, as all other scores are 0, the second top team result would be blank. However it is showing as "Team 1." I require it to be blank / ignore 0
Spreadsheet: 864606d1711707760-please-help-to-create-accounting-sheet-accounts-follow-up-list-2024
Sheet: Invoice

Invoices
Name: | Date: | Company: | Description: | PO Type: | PO Number: | Invoice Number: | Ammount: | GRN By: | GRN Date:
SS | 2024-03-26 00:00:00 | Company 1 | Where the PO number column I needd to see all the PO numbers entered in Purchase orders tab. As PO0001 was used 3 times on the list for 700 + 200 + 100 = 1000 the remaining balance on putchase order tab show 0. It need to auto deduct if I add new line. Dynamic list. | RecurringPO | PO0001 | 123 | 700 | SS | 2024-03-29 00:00:00
SS | 2024-03-26 00:00:00 | Company 1 |  | RecurringPO | PO0001 | 321 | 200 | SS | 2024-03-29 00:00:00
SS | 2024-03-26 00:00:00 | Company 1 |  | RecurringPO | PO0001 | 111 | 100 | SS | 2024-03-29 00:00:00
Spreadsheet: 681177d1591376559-how-to-use-excel-to-calculate-units-based-on-capacity-and-priority-by-hour-bakery-example-excel-board
Sheet: Sheet1

Time: | Cake Capacity (Units): | Cake Plan (Units): | Bread Capacity (Units): | Bread Plan (Units): |  |  | Values: |  |  |  | Time when cake/bread can be baked
06:30:00 | 100 |  | 500 |  |  | Priority | Description | Cake Units ordered | Bread Units ordered |  | Time: | Cake: | Bread:
07:30:00 | 1000 |  | 500 |  |  | 2 | 1h bake | 50 | 600 |  | 06:30:00 | No | No
08:30:00 | 1500 |  | 450 |  |  | 3 | 2h bake | 150 | 500 |  | 07:30:00 | No | No
09:30:00 | 1500 |  | 450 |  |  | 4 | 3h bake | 3000 | 500 |  | 08:30:00 | Yes | No
10:30:00 | 1500 |  | 450 |  |  | 5 | Light bake | 1000 | 1500 |  | 09:30:00 | Yes | No
11:30:00 | 2000 |  | 600 |  |  | 6 | Medium bake | 400 | 100 |  | 10:30:00 | Yes | No
12:30:00 | 1000 |  | 600 |  |  | 7 | Other | 50 | 10 |  | 11:30:00 | Yes | No
13:30:00 | 1000 |  | 350 |  |  | 1 | BACKLOGS | 1000 | 1000 |  | 12:30:00 | Yes | No
14:30:00 | 2000 |  | 200 |  |  |  | TOTAL |  |  |  | 13:30:00 | Yes | No
15:30:00 | 50 |  | 100 |  |  |  |  |  |  |  | 14:30:00 | Yes | No
16:30:00 | 5000 |  | 100 |  |  | Logic: backlogs always prioritised first and can be made from 06:30:00 if needed |  |  |  |  | 15:30:00 | Yes | Yes
17:30:00 | 600 |  | 250 |  |  |  |  |  |  |  | 16:30:00 | Yes | Yes
18:30:00 | 550 |  | 250 |  |  |  |  |  |  |  | 17:30:00 | Yes | Yes
19:30:00 | 200 |  | 450 |  |  |  |  |  |  |  | 18:30:00 | Yes | Yes
20:30:00 | 1000 |  | 1500 |  |  |  |  |  |  |  | 19:30:00 | No | Yes
21:30:00 | 1000 |  | 3000 |  |  |  |  |  |  |  | 20:30:00 | No | Yes
 |  |  |  |  |  |  |  |  |  |  | 21:30:00 | No | Yes
Spreadsheet: 03a57d19-c6d9-4afc-8a8f-36e656770dfd
Sheet: Sheet1

[NAME] | Selected Indicators | Yes (1) | No (0) | Score (yes=1; no=0) | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | average score
 |  |  |  | Assessment1 | Assessment2 | Assessment3 | Assessment4 | Assessment5
Health status
Mortality | Child mortality
 | Adult mortality
 | Causes of death
 | Maternal mortality
Morbidity | HIV prevalence
 | TB incidence
 | % of malaria cases diagnostically confirmed
 | Malaria incidence among children under 5 years of age
 | Eradication goal disease (acute flaccid paralysis / polio) number of case report or %
 | Notifiable disease 2
Disability | Blindness prevalence
Nutrition | Under weight prevalence among children
 | Anemia prevalence in general population or pregnant women!
Total assessment score for health status
Average assessment score = total score/12
Health services
Immunization | Measles
Maternity | Skilled birth attendant
Family planning | Contraceptive prevalence
Hospital admission | Hospital admission rate per 100,000 pop
This reflects health care utilization | Out patients ???
AIDS | 1. Number of persons receiving ART
 | 2. ART survival and
 | 3. ART adherence rates after one year
 | 4. percentage of pregnant women with HIV enrolled in PMTCT
 | Note:
 | Indicator # 1 &# 4 is simple that any country should has; #2 reflects quality of HIS & ART program desirable for policy decision regarding improvement of cost-effectiveness of ART program; # 3 is longitudinal data follow up applicable only for countries that have clinical trial on going.
TB | TB cure rate
Malaria | Prevention coverage
 | ·          Bed nets
 | ·          indoor residual spraying
Total assessment score for health service
Average assessment score = total score/x indicators
Health system
Human resources | Health workers per 1,000 population ( including Physicians / nurses, midwives)
Finances | Total/National health expenditure per capita or
 | Annual budget expenditure per capita
Facilities | % coverage of health centers
 | Number of in patient beds per 1,000 population
Total assessment score for health system
Average assessment score = total score/x indicators
Risk factors
NCD | Smoking
 | Hypertension
 | Obesity
Environment | Improved water supply this indicator means we consider % change
 | Sanitary facilities
Sexual behaviour | Condom use in higher risk sex
Total assessment score for risk factors
Average assessment score = total score/x indicators
Spreadsheet: 169835d1343071999-line-graph-not-picking-up-data-from-table-correctly-graphsdata
Sheet: Sheet1

Date | Qty
2012-04-02 00:00:00 | 10
2012-04-09 00:00:00 | 6
2012-04-16 00:00:00 | 8
2012-04-23 00:00:00 | 5
2012-04-30 00:00:00 | 4
2012-05-07 00:00:00 | 5
2012-05-14 00:00:00 | 7
2012-05-21 00:00:00 | 6
2012-05-29 00:00:00 | 8
2012-06-04 00:00:00 | 4
2012-06-11 00:00:00 | 2
2012-06-18 00:00:00 | 6
2012-06-25 00:00:00 | 8
2012-07-02 00:00:00 | 4
2012-07-09 00:00:00 | 3
2012-07-16 00:00:00 | 2
Spreadsheet: 131b27f8-9030-49aa-b7ee-fb22b8d92376
Sheet: Sheet1

NAMRU-6 Code | Genbank-Accession Number | Bankit Number
FLU9869 | EU555276 | 1067586
FLU9870 | EU555277 | 1067587
FLU6199 | EU522037 | 1063559
FLU9868 | JQ906833 | 1528532
FLA5618 | JQ906834 | 1528532
FLA4338 | JQ906835 | 1528532
FLA1234 | JQ906836 | 1528532
FLA2639 | JQ906837 | 1528532
FLA2645 | JQ906838 | 1528532
FLU5243 | JQ906839 | 1528532
FLA1228 | JQ906840 | 1528532
FLA2650 | JQ906841 | 1528532
FLA4341 | JQ906842 | 1528532
FLA4342 | JQ906843 | 1528532
FLE2524 | JQ906844 | 1528532
FLE2525 | JQ906845 | 1528532
FLU7817 | JQ906846 | 1528532
FLU7813 | JQ906847 | 1528532
FLU6211 | JQ906848 | 1528532
FLU6219 | EU521907 | 1528532
[NAME] | JQ906849 | 1528532
FLA6553 | JQ906850 | 1528532
FLA6546 | JQ906851 | 1528532
FLA5610 | JQ906852 | 1528532
FLU9873 | JQ914824 | 1528995
FLU7827 | JQ914822 | 1528995
IVE00080 | JQ914823 | 1528995
Spreadsheet: 831032d1685363073-trying-to-fill-dates-with-formula-andre-test-2-aferland-
Sheet: Sheet2

Name | Manager | shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Rows/Day |  | Name | Day |  |  | Date | name | Ticket # | Shift | Manager
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x |  |  |  | [NAME] | Monday |  | Start Date | 2023-05-21 00:00:00
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x |  |  |  | [NAME] | Tuesday
[NAME] | [NAME] | 8am - 5pm | x | x | x | x | x |  |  |  |  | [NAME] | Wednesday
Xavier | Rose | 8am - 5pm | x | x |  | x | x |  | x |  |  | [NAME] | Thursday
Ziad | [NAME] | 9am - 6pm | x | x | x | x |  |  | x |  |  | [NAME] | Friday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Monday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Tuesday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Thursday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Friday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sunday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Monday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Tuesday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Thursday
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | Sunday
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | Monday
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | Thursday
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | Saturday
 |  |  |  |  |  |  |  |  |  |  |  | Ziad | Sunday
 |  |  |  |  |  |  |  |  |  |  |  | Ziad | Monday
 |  |  |  |  |  |  |  |  |  |  |  | Ziad | Tuesday
 |  |  |  |  |  |  |  |  |  |  |  | Ziad | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  | Ziad | Saturday
Trying to fill dates with formula (excelforum.com)
Spreadsheet: 682701d1592279676-finding-the-value-throughout-whole-worksheets-in-google-worksheets-sample
Sheet: feb

Date | Column1 | Column2 | Column3 | Column4 | Column5 | Column6
2020-06-01 00:00:00 | Staff name | Month | customer | Feedback
2020-06-01 00:00:00 | sanju |  | raj | wants to renew
2020-06-01 00:00:00 | sanju |  | hari | out of city
2020-06-02 00:00:00 | sanju |  | [NAME] | wrong number
2020-06-03 00:00:00 | sanju |  | sking | wrong number
2020-06-04 00:00:00 | siru |  | yking | wrong number
2020-06-05 00:00:00 | sannu |  | zking | wants to renew
2020-06-06 00:00:00 | sanju |  | rraj | wrong number
2020-06-01 00:00:00 | sanju |  | yraj | wants to renew
Spreadsheet: chris_germany__2015__6-25-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Jun-25-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Transaction Description
2002-06-25 00:00:00 | 1280619.23 | City of Tallahassee | City of Tallahassee | C hris Germany | Phys | Payment for May swing and baseload gas.
2002-06-26 00:00:00 | -1892.15 | [NAME] | Natural Gas Pipeline Company | [NAME] | Phys | Cash requested 6/20/02. Note that the payment date has been changed.
2002-07-01 00:00:00 | -2371234.02 | Citrus | Citrus | [NAME]/[NAME] | Phys | Payment related to gas purchases.  Payment day changed, and will keep being pushed back until further notice.
Spreadsheet: 269655d1381242249-using-trim-function-to-remove-excess-space-in-sumif-function-using-trim-function
Sheet: Sheet1

Daily Sales Details
Date | Customer | "33" | STK | BTK | Hmalt | SUMIF | SUMPRODUCT
2013-01-01 00:00:00 | [NAME] | 32 | 45 | 59 | 75 |  | 1458
2013-01-02 00:00:00 | Jonah | 45 | 32 | 45 | 12
2013-01-03 00:00:00 | Emmanuel | 54 | 98 | 76 | 90
2013-01-04 00:00:00 | [NAME] | 56 | 90 | 87 | 45
2013-01-05 00:00:00 | [NAME] | 100 | 78 | 58 | 985
2013-01-06 00:00:00 | Papa | 561 | 984 | 86 | 567
2013-01-07 00:00:00 | Self Collection | 123 | 764 | 89 | 456
2013-01-08 00:00:00 | Jonah | 453 | 89 | 67 | 897
2013-01-09 00:00:00 | [NAME] | 321 | 685 | 989 | 612
2013-01-10 00:00:00 | Emmanuel | 594 | 433 | 342 | 432
2013-01-11 00:00:00 | [NAME] | 412 | 675 | 476 | 454
2013-01-12 00:00:00 | [NAME] | 596 | 354 | 357 | 334
2013-01-13 00:00:00 | Papa | 453 | 567 | 543 | 654
2013-01-14 00:00:00 | Self Collection | 968 | 876 | 765 | 356
2013-01-15 00:00:00 | [NAME] | 567 | 453 | 454 | 546
2013-01-16 00:00:00 | Jonah | 764 | 532 | 657 | 786
2013-01-17 00:00:00 | Emmanuel | 123 | 433 | 432 | 643
2013-01-01 00:00:00 | [NAME] | 543 | 342 | 431 | 453
2013-01-01 00:00:00 | [NAME] | 594 | 475 | 244 | 544
2013-01-02 00:00:00 | Jonah | 687 | 345 | 445 | 654
2013-01-03 00:00:00 | Emmanuel | 687 | 459 | 543 | 256
2013-01-04 00:00:00 | [NAME] | 575 | 345 | 342 | 443
2013-01-05 00:00:00 | [NAME] | 564 | 352 | 433 | 543
2013-01-06 00:00:00 | Papa | 687 | 346 | 665 | 345
2013-01-07 00:00:00 | Self Collection | 987 | 342 | 643 | 453
Spreadsheet: 858298d1707031176-convert-yahoo-finance-date-ormat-to-the-russian-format-yyyy-mm-dd-russian-format
Sheet: PQ

S&P 500 (^GSPC)
Link below
https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC
I need to reformat the Yahoo Finance format in Column A   to the Russian Format in Column B   yyyy.mm.dd
Date
Yahoo Finance Format | [NAME]yyyy.mm.dd
Jan 31, 2024 | 2024-01-31 00:00:00
Jan 30, 2024 | 2024-01-30 00:00:00
Jan 29, 2024 | 2024-01-29 00:00:00
Jan 26, 2024 | 2024-01-26 00:00:00
Jan 25, 2024 | 2024-01-25 00:00:00
Jan 24, 2024 | 2024-01-24 00:00:00
Jan 23, 2024 | 2024-01-23 00:00:00
Jan 22, 2024 | 2024-01-22 00:00:00
Feb 02, 2024 | 2024-02-02 00:00:00
Feb 01, 2024 | 2024-02-01 00:00:00
Hoping you can oblige     thank you in advance
Derek
I have deleted othe Columns of price data to make it clearer
Spreadsheet: 855867d1705338247-list-by-highest-including-joint-highest-ranking
Sheet: Sheet1

Team | Rank | Name | Dec | Best | Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
101 | 3 | [NAME] | 105 | 105 | 2.2 |  |  |  |  |  | 106 |  |  |  |  |  |  |  |  |  | 102
101 | 1 | [NAME] | 100 | 110 | 1.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
101 | 4 | [NAME] | 96 | 96 | 6.5 |  |  |  |  |  | Team | Rank | Name | Dec | Best | Cost |  |  |  |  | 104
101 | 1 | [NAME] | 92 | 109 | 3.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105
102 | 1 | Vicky | 109 | 109 | 1.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106
102 | 3 | [NAME] | 109 | 109 | 5
102 | 2 | [NAME] | 107 | 107 | 1.5
102 | 4 | Ian | 106 | 108 | 6
103 | 1 | [NAME] | 90 | 95 | 1.75
103 | 2 | [NAME] | 89 | 89 | 2.3
103 | 4 | [NAME] | 80 | 86 | 2.2
103 | 3 | [NAME] | 78 | 78 | 4
104 | 1 | [NAME] | 116 | 116 | 1.8
104 | 2 | Moh | 114 | 114 | 1.5
104 | 4 | [NAME] | 114 | 121 | 3
104 | 3 | Asif | 110 | 110 | 4
105 | 4 | [NAME] | 123 | 123 | 2.5
105 | 3 | Berti | 106 | 106 | 4
105 | 1 | Chess | 104 | 104 | 2
105 | 2 | Gaby | 75 | 75 | 6.6
106 | 1 | [NAME] | 121 | 121 | 1.4
106 | 2 | Asha | 121 | 122 | 2
106 | 3 | Greta | 111 | 111 | 2.4
106 | 4 | Simone | 110 | 110 | 3
Sort by  Team (col A) then Dec (col D)
Show total Number of Team (col A)
Show total Number that highest number in Dec has Rank =1 ( rank is top position by customers)
There are 2 occasions where there is a joint top highest number in Dec column
In the above there are 3 times that the highest number in Dec has a Rank = 1 however
In Team 102  and also  Team  106 there are 2 Name(s) which have the joint highest Dec figure.
We also need to add the Cost number where the highest Dec person is also the no 1 Rank
 | In the example this Vicky 1.8 + Vicky 1.75 + [NAME] 1.8 + Pierre 1.4 = 6.75
The result we are looking for is 3 times where Rank = 1 from a total of 7  (because of 2 x jt top) in Dec column
Display all the occasions that this occurs in new columns
 | Col H = Team
 | Col I  = Rank
 | Col J = Name
 | Col K = Dec  (number)
 | Col L = Cost
Total summary below each column
This is how the result should look like
101 | 3 | [NAME] | 105 | 2.2
102 | 1 | Vicky | 109 | 1.8
102 | 3 | [NAME] | 109 | 5
103 | 1 | [NAME] | 90 | 1.75
104 | 1 | [NAME] | 116 | 1.8
105 | 4 | [NAME] | 123 | 2.5
106 | 1 | [NAME] | 121 | 1.4
106 | 2 | Asha | 121 | 2
Total | 4 |  | 8 | 6.75
Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: Dash

 | Open Complaints
 | Date received | Product Code | Product Name | Customer | Complaint  Top category | Complaint Sub Category
 | 2022-02-08 00:00:00 | X325 |  |  | Order Error | Incorrect shelf life
 | 2022-02-07 00:00:00 | XT/F1883713 |  |  | Foreign Body | Other
 | 2022-02-02 00:00:00 | XT/F15067A10 |  |  | Order Error | Short
Spreadsheet: 39210d1237398706-vlookup-formula-signuplisting-5-
Sheet: ACOG

ACOG | Total Attendees: | 1 |  |  |  |  |  |  |  |  | Summary
[NAME] | RML |  |  |  | Location: | 0
 |  |  |  |  | Date: | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Tier 1 Meeting:
 |  |  |  |  | Committed:
 |  |  |  |  | Booth:
 |  |  |  |  | [NAME]: | 0 | Management
 |  |  |  |  |  | 0 | Medical Communications
 |  |  |  |  |  | 0 | Medical Directors
 |  |  |  |  |  | 0 | Medical Information
 |  |  |  |  |  | 1 | RMLs
 |  |  |  |  | Hotel Information:
 |  |  |  |  | Links:
Spreadsheet: 78080111-c23b-444d-8cd3-75f8f43fd58c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9273 | Test | 9273 | Subcutaneous Fat Aspirate | Subcutaneous Fat Aspirate |  |  |  |  |  | Varies | Container/Tube: [NAME] slides or sterile container [NAME] Minimum of 4 slides or 1 cubic mm Collection Instructions: 1. Sterilize and anesthetize a small area of the anterior abdominal wall. 2. Aspirate subcutaneous fat through a large bore needle. 3. Apply the fat obtained in the syringe directly to a glass slide and crush with a second slide. 4. Air dry the slides and send without fixative. 5. Alternately, send fat in small container of saline. Additional Information: The following information is required: a. Patient's date of birth [NAME] and telephone number of ordering physician c. Pertinent clinical information | 1 cubic mm fat/4 slides | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday through Friday; Varies | 1 day | 4 days | 1 | 88313 |  |  |  |  | Rochester
9273 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9273 | Result | 18712 | Accession Number | Accession Number
9273 | Result | 18713 | Referring Pathologist/Physician | Referring Pathologist/Physician |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46608-6
9273 | Result | 18714 | Ref Path/Phys Address | Ref Path/Phys Address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9273 | Result | 18715 | Material: | Material: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9273 | Result | 18748 | Tissue: | Tissue: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
9273 | Result | 18717 | Interpretation: | Interpretation: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9273 | Result | 18948 | Comment: | Comment: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
9273 | Result | 18718 | SP Signing Pathologist: | SP Signing Pathologist:
9273 | Result | 18719 | *Previous Report Follows* | *Previous Report Follows*
9273 | Result | 18720 | [NAME]: | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35265-8
9273 | Result | 19191 | [NAME] Comment: | [NAME] Comment: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22638-1
9273 | Result | 18721 | [NAME] Pathologist: | [NAME] Pathologist: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19139-5
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: first june

2011-06-03 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0