tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878131d1725106266-formula-for-intersection-of-rows-and-columns-extend-excel-8-365-wip-aligw
Sheet: Sheet1

Modules(columns) | T/F |  |  |  |  | Modules(columns) | Analytics | Systems Analyst | Business Analyst | Development | Product Manager | Department Manager | Team Leader
d3 | FALSE |  |  |  |  | d3 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Administration | FALSE |  |  |  |  | Administration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Obstetrics | FALSE |  |  |  |  | Obstetrics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Pharmacy | FALSE |  | Systems Analyst | 30.5 |  | Pharmacy | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS - Healthcare Monitoring | TRUE |  |  |  |  | BARS - Healthcare Monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS.STAR | TRUE |  |  |  |  | BARS.STAR | 1 | 2 | 3 | 4 | 5 | 6 | 7
Vaccination | TRUE |  |  |  |  | Vaccination | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF AKiNEO | TRUE |  |  |  |  | VIMIS RF AKiNEO | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Oncology | TRUE |  |  |  |  | VIMIS RF Oncology | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Prevention | FALSE |  |  |  |  | VIMIS RF Prevention | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF CVD | FALSE |  |  |  |  | VIMIS RF CVD | 1 | 2 | 3 | 4 | 5 | 6 | 7
HMP | FALSE |  |  |  |  | HMP | 1 | 2 | 3 | 4 | 5 | 6 | 7
Outside ARM | FALSE |  |  |  |  | Outside ARM | 1 | 2 | 3 | 4 | 5 | 6 | 7
Military registration | FALSE |  |  | Hard-50% |  | Military registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Hospital physician | FALSE |  |  |  |  | Hospital physician | 1 | 2 | 3 | 4 | 5 | 6 | 7
Diagnostics | FALSE |  | Positions |  |  | Diagnostics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Dispensary registration | FALSE |  | Analytics | TRUE |  | Dispensary registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Remote monitoring | FALSE |  | Systems Analyst | TRUE |  | Remote monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
Health diary | FALSE |  | Business Analyst | FALSE |  | Health diary | 1 | 2 | 3 | 4 | 5 | 6 | 7
Unified registry | FALSE |  | Development | FALSE |  | Unified registry | 1 | 2 | 3 | 4 | 5 | 6 | 7
User information support | FALSE |  | Product Manager | FALSE |  | User information support | 1 | 2 | 3 | 4 | 5 | 6 | 7
IPRA | FALSE |  | Department Manager | FALSE |  | IPRA | 1 | 2 | 3 | 4 | 5 | 6 | 7
IEMC | FALSE |  | Team Leader | FALSE |  | IEMC | 1 | 2 | 3 | 4 | 5 | 6 | 7
Call center | FALSE |  |  |  |  | Call center | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  | The formula should not only find numbers at the intersection of rows and columns and write them into the range starting from the green cell, but also multiply them by 3 and add percentages to the result depending on the complexity. There is data validation with the required percentages. The most important condition is that there is must be only one function and it calculates everything automatically.
Spreadsheet: 851871d1701987800-how-to-group-a-list-of-dates-to-corresponding-a-specific-weekday-book1
Sheet: Sheet1

 |  |  |  |  | Desire result
 | 2023-01-01 00:00:00 |  |  |  | 2023-01-02 00:00:00
 | 2023-01-02 00:00:00 |  |  |  | 2023-01-09 00:00:00
 | 2023-01-03 00:00:00 |  |  |  | 2023-01-16 00:00:00
 | 2023-01-04 00:00:00 |  |  |  | 2023-01-23 00:00:00
 | 2023-01-05 00:00:00 |  |  |  | 2023-01-30 00:00:00
 | 2023-01-06 00:00:00 |  |  |  | 2023-02-06 00:00:00
 | 2023-01-07 00:00:00
 | 2023-01-08 00:00:00
 | 2023-01-09 00:00:00
 | 2023-01-10 00:00:00
 | 2023-01-11 00:00:00
 | 2023-01-12 00:00:00
 | 2023-01-13 00:00:00
 | 2023-01-14 00:00:00
 | 2023-01-15 00:00:00
 | 2023-01-16 00:00:00
 | 2023-01-17 00:00:00
 | 2023-01-18 00:00:00
 | 2023-01-19 00:00:00
 | 2023-01-20 00:00:00
 | 2023-01-21 00:00:00
 | 2023-01-22 00:00:00
 | 2023-01-23 00:00:00
 | 2023-01-24 00:00:00
 | 2023-01-25 00:00:00
 | 2023-01-26 00:00:00
 | 2023-01-27 00:00:00
 | 2023-01-28 00:00:00
 | 2023-01-29 00:00:00
 | 2023-01-30 00:00:00
 | 2023-01-31 00:00:00
 | 2023-02-01 00:00:00
 | 2023-02-02 00:00:00
 | 2023-02-03 00:00:00
 | 2023-02-04 00:00:00
 | 2023-02-05 00:00:00
 | 2023-02-06 00:00:00
 | 2023-02-07 00:00:00
 | 2023-02-08 00:00:00
Spreadsheet: 873894d1720482580-sum-quarterly-and-yearly-from-vlookup-dynamic-array-result-legacy-sum-quarterly-and-yearly-bvj-
Sheet: Sheet1

 |  |  |  |  | Lookup "Date" Array | [NAME] (Dynamic) | Desired Result via Dynamic Array | [NAME]'s sol'n | Date | Amount
45444 |  | 2024-06-01 00:00:00 | 56 |  |  |  | 56 |  |  | 56
45474 |  | 2024-07-01 00:00:00 | 49 |  | 2024-07-01 00:00:00 |  | 49 |  | 2024-07-01 00:00:00 | 49
45505 |  | 2024-08-01 00:00:00 | 74 |  | 2024-08-01 00:00:00 |  | 74 |  | 2024-08-01 00:00:00 | 74
Q1FY25 Total |  | 2024-09-01 00:00:00 | 27 |  | Q1FY25 Total |  |  |  | 2024-09-01 00:00:00 | 27
45536 |  | 2024-10-01 00:00:00 | 51 |  | 2024-09-01 00:00:00 |  | 27 |  | 2024-10-01 00:00:00 | 51
45566 |  | 2024-11-01 00:00:00 | 82 |  | 2024-10-01 00:00:00 |  | 51 |  | 2024-11-01 00:00:00 | 82
45597 |  | 2024-12-01 00:00:00 | 58 |  | 2024-11-01 00:00:00 |  | 82 |  | 2024-12-01 00:00:00 | 58
Q2FY25 Total |  | 2025-01-01 00:00:00 | 62 |  | Q2FY25 Total |  |  |  | 2025-01-01 00:00:00 | 62
45627 |  | 2025-02-01 00:00:00 | 85 |  | 2024-12-01 00:00:00 |  | 58 |  | 2025-02-01 00:00:00 | 85
45658 |  | 2025-03-01 00:00:00 | 103 |  | 2025-01-01 00:00:00 |  | 62 |  | 2025-03-01 00:00:00 | 103
45689 |  | 2025-04-01 00:00:00 | 129 |  | 2025-02-01 00:00:00 |  | 85 |  | 2025-04-01 00:00:00 | 129
Q3FY25 Total |  | 2025-05-01 00:00:00 | 118 |  | Q3FY25 Total |  |  |  | 2025-05-01 00:00:00 | 118
45717 |  | 2025-06-01 00:00:00 | 18 |  | 2025-03-01 00:00:00 |  | 103 |  | 2025-06-01 00:00:00 | 18
45748 |  | 2025-07-01 00:00:00 | 17 |  | 2025-04-01 00:00:00 |  | 129 |  | 2025-07-01 00:00:00 | 17
45778 |  | 2025-08-01 00:00:00 | 49 |  | 2025-05-01 00:00:00 |  | 118 |  | 2025-08-01 00:00:00 | 49
Q4FY25 Total |  | 2025-09-01 00:00:00 | 82 |  | Q4FY25 Total |  |  |  | 2025-09-01 00:00:00 | 82
FY25 Total |  | 2025-10-01 00:00:00 | 84 |  | FY25 Total |  |  |  | 2025-10-01 00:00:00 | 84
45809 |  | 2025-11-01 00:00:00 | 30 |  | 2025-06-01 00:00:00 |  | 18 |  | 2025-11-01 00:00:00 | 30
45839 |  | 2025-12-01 00:00:00 | 78 |  | 2025-07-01 00:00:00 |  | 17 |  | 2025-12-01 00:00:00 | 78
45870 |  | 2026-01-01 00:00:00 | 87 |  | 2025-08-01 00:00:00 |  | 49 |  | 2026-01-01 00:00:00 | 87
Q1FY26 Total |  | 2026-02-01 00:00:00 | 73 |  | Q1FY26 Total |  |  |  | 2026-02-01 00:00:00 | 73
45901 |  | 2026-03-01 00:00:00 | 141 |  | 2025-09-01 00:00:00 |  | 82 |  | 2026-03-01 00:00:00 | 141
45931 |  | 2026-04-01 00:00:00 | 118 |  | 2025-10-01 00:00:00 |  | 84 |  | 2026-04-01 00:00:00 | 118
45962 |  | 2026-05-01 00:00:00 | 102 |  | 2025-11-01 00:00:00 |  | 30 |  | 2026-05-01 00:00:00 | 102
Q2FY26 Total |  | 2026-06-01 00:00:00 | 120 |  | Q2FY26 Total |  |  |  | 2026-06-01 00:00:00 | 120
45992 |  |  |  |  | 2025-12-01 00:00:00 |  | 78
46023 |  |  |  |  | 2026-01-01 00:00:00 |  | 87
46054 |  |  |  |  | 2026-02-01 00:00:00 |  | 73
Q3FY26 Total |  |  |  |  | Q3FY26 Total
46082 |  |  |  |  | 2026-03-01 00:00:00 |  | 141
46113 |  |  |  |  | 2026-04-01 00:00:00 |  | 118
46143 |  |  |  |  | 2026-05-01 00:00:00 |  | 102
[NAME] |  |  |  |  | [NAME]
FY26 Total |  |  |  |  | FY26 Total
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: Jan 2021

Subscriptions | [NAME] | [NAME]
Gas |  | 15
Gas |  | 20
Net Flix |  | 12.99
Cox |  | 246
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Amazon Prime | 59
Discovery plus | 7.78
Chewy | 56.71
club carwash | 21.75
Sprint | 135.23
Total
one half | 174.19 | 146.99 | 27.2 | luci owes
Spreadsheet: f0864f0a-5924-44d0-907e-d874dc2d26d1
Sheet: Sheet1

Unnamed: 0 | ELECTIVES | 2011/2012
Course | Period | Lecturer(s)
I Economics and Business
Globalization & Development | 110912-111117 | [NAME] (E&Y)
Leadership & Development | 110926-111028 | [NAME]
Audit and Taxation in Baltics | 110926-101203 | [NAME] (KPMG)
Intro to Business Reactor | 111017-111209 | [NAME]
Business Perspectives | 111121-111125 | [NAME], Fionn Dobbin
Business Reactor | 120312-120420 | [NAME]
Public Finance | 110314-110527 | Oleg Tkacev
Branding Communication | 120423-120518 | [NAME], BITE professionals
Time Series | 120507-120608 | Morten Hansen
II English
Presentation Skills (RI) | 111010-111028 | [NAME], [NAME]
Career Development (RI) | 111107-111125 | [NAME], [NAME]
Contract Drafting | 111128-111202 | [NAME]
Presentation Skills (RII) | 120123-120210 | [NAME], [NAME]
Career Development (RII) | 120220-120309 | [NAME], [NAME]
III General
Historical Introduction to Philosophy | 110905-111111 | Dr. [NAME]
Negotiation and Dispute Resolution | 120312-120420 | [NAME]
Visual Intelligence | 120514-120601 | Dr. [NAME]
IV Languages
French | 110923-120511 | [NAME]
German | 110923-120511 | [NAME]
Latvian | 110923-120511 | [NAME]
Russian | 110923-120511 | [NAME]
Spanish | 110923-120511 | [NAME]
Swedish | 110923-120511 | Ingrīda Tērauda
Spreadsheet: 132028d1323446040-get-name-from-other-sheet-examples
Sheet: Sheet1

 | Name 1 |  |  |  |  | Name 2 |  |  |  |  | Name 3 |  |  |  |  | Name 4 |  |  |  |  | Name 5
1
2
3
4
5 |  | What formula put name in box from Name list sheet? Any idea?
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: GNH - CS-SPD PACKS (#2)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS-SPD PACKS (2)
FACILITY: | GREY NUNS HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
LITHO GENERAL SURG |  |  |  | CP0016 |  | 4
DELIVERY PACK |  |  |  | CP0004 |  | 25
CYSTO PACK |  |  |  | CP0009 |  | 30
UG-LG SPLIT PACK |  |  |  | CP0026 |  | 15
G-MAJ LITHOTOMY |  |  |  | CP0034 |  | 3
UPDATED:
June 17th 2009
Spreadsheet: joe_parks__14881__TXULSP Avail Cap Elec Gen 2
Sheet: available capacity

 |  |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-07 00:00:00 | 3-08-02 to 03-10-02
From the Waha Area | 150000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Line L8A | 0
(Limestone and Freestone Cty)
Line  P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 742720d1627991276-input-date-calculate-in-condition-format-date
Sheet: Sheet3

Count of DATE
NAME | DATE | Total
AAA | 01/02/2021 | 1
 | 01/03/2021 | 1
 | 02/02/2021 | 1
 | 03/02/2021 | 1
 | 05/04/2021 | 1
 | 06/05/2021 | 1
 | 08/02/2021 | 1
 | 08/03/2021 | 1
 | 12/04/2021 | 1
 | 15/03/2021 | 1
 | 22/02/2021 | 1
 | 22/03/2021 | 1
 | 29/03/2021 | 1
 | 30/07/2021 | 1
BBB | 04/05/2021 | 1
 | 09/07/2021 | 1
 | 16/04/2021 | 1
CCC | 07/07/2021 | 1
DDD | 01/02/2021 | 1
Grand Total |  | 19
Spreadsheet: sally_beck__33972__Cut_Over_Calendar
Sheet: May 2001

MAY 2001
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | 1 | 2 | 3 | 4 | 5
 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 221433d1363550868-stock-report-help-me-to-rectify-the-error-stock-report
Sheet: 1

Item Code | Item Description | UOM | Sales | Closing Stock
101 |  |  | 10
110 |  |  | 20
101 |  |  | 30
124 |  |  | 40
101 |  |  | 10
110 |  |  | 10
120 |  |  | 10
124 |  |  | 10
125 |  |  | 10
126 |  |  | 10
Spreadsheet: 772750d1647451906-sum-in-range-if-criteria-are-met-sum-range-test
Sheet: Sum range test

 |  | 2022-02-02 00:00:00
18:01:09 | 2022-02-02 00:00:00 |  |  | 18:01:09 | 19:00:44
18:09:04 | 2022-02-02 00:00:00
18:12:12 | 2022-02-02 00:00:00
18:18:06 | 2022-02-02 00:00:00
18:23:11 | 2022-02-02 00:00:00
18:48:18 | 2022-02-02 00:00:00
18:52:05 | 2022-02-02 00:00:00
18:53:47 | 2022-02-02 00:00:00
18:57:14 | 2022-02-02 00:00:00
19:00:44 | 2022-02-02 00:00:00
19:03:16 | 2022-02-02 00:00:00
19:05:29 | 2022-02-02 00:00:00
19:09:30 | 2022-02-02 00:00:00
19:12:11 | 2022-02-02 00:00:00
19:14:18 | 2022-02-02 00:00:00
19:21:53 | 2022-02-02 00:00:00
18:41:11 | 2022-02-05 00:00:00
18:44:04 | 2022-02-05 00:00:00
18:57:38 | 2022-02-05 00:00:00
19:07:16 | 2022-02-05 00:00:00
Spreadsheet: 674691d1587989688-show-column-value-of-formula-result-1-column-example-makes-it-clearer-example-xxx-
Sheet: Sheet1

 |  |  | 2814 | 2791 |  |  |  |  | 2814
 |  |  | 2792 | 2781 |  |  |  |  | 2792
 |  |  | 2782 | 2775 |  |  |  |  | 2782
 |  |  | 2780 | 2775 |  |  |  |  | 2780
 |  |  | 2780 | 2778 |  |  |  |  | 2780
 |  |  | 2779 | 2769 |  |  |  |  | 2779
 |  |  | 2776 | 2771 |  |  |  |  | 2776
 |  |  | 2776 | 2773 |  |  |  |  | 2776
 |  |  | 2774 | 2766 |  |  |  |  | 2774
 |  |  | 2772 | 2767 |  |  |  |  | 2772
 |  |  | 2779 | 2773 |  |  |  |  | 2779
 |  |  | 2779 | 2767 |  |  |  |  | 2779
 |  |  | 2779 | 2770 |  |  |  |  | 2779
 |  |  | 2779 | 2747 |  |  |  |  | 2779
 |  |  | 2762 | 2749 |  |  |  |  | 2762
 |  |  | 2775 | 2757 |  |  |  |  | 2775
 |  |  | 2776 | 2766 |  |  |  |  | 2776
 |  |  | 2778 | 2770 |  |  |  |  | 2778
 |  |  | 2780 | 2770 |  |  |  |  | 2780
 |  |  | 2788 | 2774 |  |  |  |  | 2788
 |  |  | 2788 | 2779 |  |  |  |  | 2788
 |  |  | 2792 | 2783 |  |  |  |  | 2792
 |  |  | 2792 | 2785 |  |  |  |  | 2792
 |  |  | 2792 | 2783 |  |  |  |  | 2792
 |  |  | 2785 | 2778 |  |  |  |  | 2785
 |  |  | 2785 | 2777 |  |  |  |  | 2785
 |  |  | 2797 | 2780 |  |  |  |  | 2797
 |  |  | 2801 | 2792 |  |  |  |  | 2801
 |  |  | 2809 | 2791 |  |  |  |  | 2809
 |  |  | 2814 | 2801 |  |  |  |  | 2814
 |  |  | 2812 | 2800 |  |  |  |  | 2812
 |  |  | 2807 | 2802 |  |  |  |  | 2807
 |  |  | 2815 | 2804 |  |  |  |  | 2815
Spreadsheet: 220893d1363293138-validate-a-number-through-a-list-area-de-cobertura-e-sedex
Sheet: Plan1

nome | endereco + nº | complemento | bairro | CEP | cidade
AC Icoaraci - A/C Veronice dos Santos Nunes | [NAME] | 659 |  | Cruzeiro (Icoaraci) | 66810970 | [NAME] | 0
Ana Carolina Telles ME - A/C [NAME] | [NAME] | 70 | [NAME] 03 | Centro | 88200000 | Tijucas | 0
NOVA DIGITAL - Cirlene | RUA JUQUIS | 268 |  | INDIANOPOLIS | 04081010 | SAO PAULO | 0
JPE INFORMATICA LTDA ME A/C EVERTON DOS SANTOS | AV. [NAME] | 2003 | SALA | CENTRO | 89895000 | RIQUEZA | 0
[NAME] | x |  | Jurunas | 66025660 | Belem | 0
TECHNOPARTS COMERCIO E SERVICOS LTDA - OSMAR | x |  | TIJUCA | 20550012 | RIO DE JANEIRO | 0
ANDRE LUIS GAILHARD | x |  | CENTRO | 95760000 | SAO SEBASTIAO DO CAI | 0
Mayque [NAME] | x | Qd. 55A Lt. 20 | Setor Aeroporto | 74070030 | Goiania | 0
S A DA SILVA - MARCOS | x | TERREO | Da paz | 68515000 | PARAUAPEBAS | 0
[NAME] Junior | x | sl 01 | Visconde do [NAME] | 31535000 | [NAME] | 0
[NAME] | Rua 25 de julho | 513 | Loja 02 | Florestal | 95900000 | Lajeado | 0
Hospital do Note - Daiana | [NAME] | 491 |  | Escola Agricola | 89031200 | Blumenau | 0
[NAME] | AV CAMPO GRANDE | 705-N | PORTAL AGRONEGOCIO | Industrial | 78455000 | Lucas do Rio Verde | 0
Spreadsheet: 0a849468-b3f2-412c-a0b3-6ea795021c65
Sheet: UK non-MD

 | Table 9: Cases of pneumococcal meningitis in England and Wales: HES1 and NOIDS5 data (2007/8 to 2009/10)
 |  |  |  | Notifications of pneumococcal meningitis by calendar year (2007-2009)
 | Year | HES Admissions data G001 | Cleaned HES admissions data | England and Wales | England | Uplift required to convert English NOIDS to E&W NOIDS | Cleaned HES admissions data uplifted to include Wales
 | 2007-08 | 490 |  | 173 | 168
 | 2008-09 | 487 |  | 169 | 157
 | 2009-10 | 460 |  | 186 | 169
 | Average over past 3 years
 | Table 10: Cases of other bacterial meningitis in England and Wales: NOIDS5 data (2000 to 2009)
 | Year | Hi | TB men | Other causes
 | 2000 | 39 | 94 | 464
 | 2001 | 74 | 161 | 517
 | 2002 | 62 | 140 | 361
 | 2003 | 63 | 150 | 323
 | 2004 | 45 | 140 | 294
 | 2005 | 44 | 228 | 315
 | 2006 | 57 | 252 | 321
 | 2007 | 32 | 320 | 254
 | 2008 | 24 | 206 | 260
 | 2009 | 31 | 192 | 275
 | Average
 | Table 11: Cases of other bacterial meningitis in Northern Ireland sourced from PHA6,7 (2006 to 2009)
 | Year | Pneumococcal meningitis | Hib meningitis | TB meningitis | Other bacterial meningitis
 | 2006 | 5 | 0 | 0 | 63
 | 2007 | 1 | 1 | 1 | 39
 | 2008 | 3 | 0 | 1 | 40
 | 2009 | 2 | 0 | 0 | 36
 | Average
 | Table 12: Cases of other bacterial meningitis in Scotland sourced from HPS8,9,10 (2000 to 2009)
 | Year | Cases of Pneumococcal meningitis  reported to SPIDER | Haemophilus influenzae CSF isolates (and cases from 2002) | TB Meningitis Cases reported to ESMI | Other bacterial (CSF Isolates)
 | 2000 | 32 | 3 | 7 | 23
 | 2001 | 38 | 4 | 4 | 17
 | 2002 | 35 | 6 | 7 | 20
 | 2003 | 27 | 7 | 7 | 20
 | 2004 | 19 | 6 | 8 | 20
 | 2005 | 36 | 7 | 3 | 17
 | 2006 | 37 | 2 | 8 | 45
 | 2007 | 18 | 6 | 9 | 54
 | 2008 | 24 | 6 | 11 | 58
 | 2009 | 25 | 2 | 10 | 81
 | Average
Spreadsheet: 789373d1659064936-need-help-to-distribute-amount-as-per-day-difference-duty-exmp
Sheet: Scenario 1

 | Duty Amount | Debit | Credit | Duty Date |  | Duty Amount | Debit | Credit | Duty Date
 | 0 |  |  | 2020-09-19 00:00:00 |  | 0 |  |  | 2020-09-19 00:00:00
 | 528.08 |  |  | 2020-10-13 00:00:00 |  | 528.08 |  |  | 2020-10-13 00:00:00
 | 1252.08 |  |  | 2020-11-20 00:00:00 |  | 1252.08 | 1153.23 |  | 2020-11-20 00:00:00 |  | 35
 | 864.08 |  |  | 2020-12-14 00:00:00 |  | 864.08 | 864.08 |  | 2020-12-14 00:00:00
 | 854.09 |  |  | 2021-01-09 00:00:00 |  | 854.09 | 854.09 |  | 2021-01-09 00:00:00
 | 995.07 |  |  | 2021-02-12 00:00:00 |  | 995.07 | 995.07 |  | 2021-02-12 00:00:00
 | 628.11 |  |  | 2021-03-02 00:00:00 |  | 628.11 | 628.11 |  | 2021-03-02 00:00:00
 | 686.83 |  |  | 2021-03-27 00:00:00 |  | 686.83 | 686.83 |  | 2021-03-27 00:00:00
 | 791.2 |  |  | 2021-04-26 00:00:00 |  | 791.2 | 791.2 |  | 2021-04-26 00:00:00
 | 718.04 |  |  | 2021-05-25 00:00:00 |  | 718.04 | 718.04 |  | 2021-05-25 00:00:00
 | 727 |  |  | 2021-06-25 00:00:00 |  | 727 | 703.5483870967741 |  | 2021-06-25 00:00:00 |  | 30
 | 5812.24 |  |  | 2021-07-24 00:00:00 |  | 5812.24 |  |  | 2021-07-24 00:00:00
 | 7404.36 |  |  | 2021-08-26 00:00:00 |  | 7404.36 |  |  | 2021-08-26 00:00:00
 | 6131.32 |  |  | 2021-09-27 00:00:00 |  | 6131.32 |  |  | 2021-09-27 00:00:00
 | 5814.71 |  |  | 2021-10-30 00:00:00 |  | 5814.71 |  |  | 2021-10-30 00:00:00
 | 4130.82 |  |  | 2021-12-01 00:00:00 |  | 4130.82 |  | 3743.555625 | 2021-12-01 00:00:00
Extra Duty Collection Date From | 2020-10-17 00:00:00 | To | 2021-06-24 00:00:00
Duty Relief Date From | 2021-11-03 00:00:00 | To | 2023-06-24 00:00:00 |  | >> If Dates range are as shown in Cell B22, D22, B23 and D23 then expected result should be as shown in H2:I21
 |  |  |  |  | >> Please Check the Sheet Scenario 2 also
 |  |  |  |  | So I need the formula which can give the both results as per shown in Scenario 1 and Scenario 2
Spreadsheet: 77519d1277981750-countif-with-multiple-criteria-function-analysis_-of_dome_spec
Sheet: Sheet1

 |  |  |  |  |  | Spec (mm)
Dome | Spec |  |  |  |  | 95 | 100 | 105 | 110 | 115 | 120 | 125 | 130
(kg) | ([NAME]) |  | Less than
1.73 | 105 |  | 1.25 | Dome (kg) | 1.00>1.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.76 | 105 |  | 1.5 |  | 1.25>1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.775 | 105 |  | 1.75 |  | 1.50>1.75 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
1.785 | 110 |  | 2 |  | 1.75>2.00 | 1 | 1 | 6 | 1 | 0 | 2 | 0 | 0
1.835 | 95 |  | 2.25 |  | 2.00>2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.84 | 120 |  | 2.5 |  | 2.25>2.50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.88 | 105 |  | 2.75 |  | 2.50>2.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.88 | 100
1.9 | 120
1.915 | 105
1.87 | 105
1.79 | 105
Spreadsheet: 869210d1715845568-maxifs-to-pull-other-columns-as-well-dummy-8-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Existing Result |  |  | Required Result
Data1 | Country | Rating | [NAME] |  | Code | Sub category | Particulars | Group |  | qty |  |  |  |  |  |  | Price |  |  | Group | Price |  | Group | Price | Code | Rating
1 | USA | R-1 | East |  | 9242 | Fruits-A | Ram | Apple |  | 5268 |  |  |  |  |  |  | 50 |  |  |  |  |  | Apple | 98 | 10928 | R-4
5 | Austrial | B-5 | West |  | 9227 | Fruits-A | [NAME] | Orange |  | 0 |  |  |  |  |  |  | 60 |  |  | Orange | 124 |  | Orange | 124 | 16119 | S-23
3 | Canada | [NAME] | East |  | 9484 | Fruits-1 | [NAME] | Apple |  | 331 |  |  |  |  |  |  | 44 |  |  | Grapes | 33 |  | Grapes | 33 | 14845 | D-94
44 | China | R-4 | East |  | 10928 | Fruits-A | Hari | Apple |  | 126 |  |  |  |  |  |  | 98 |  |  | Mango | 54 |  | Mango | 54 | 64 | M-44
982 | Nepal | D-94 | North |  | 14845 | Fruits-B | Dinomorio | Grapes |  | 663 |  |  |  |  |  |  | 33 |  |  | Candy | 364 |  | Candy | 364 | 412 | A-25
63 | India | S-23 | North |  | 16119 | Fruits-K | [NAME] | Orange |  | 4521.63 |  |  |  |  |  |  | 124 |  |  | Guava | 24 |  | Guava | 24 | 985 | L-4
145 | Russia | M-44 | East |  | 64 | Fruits-B | [NAME] | Mango |  | 874.98 |  |  |  |  |  |  | 54
Alist | Dubai | A-25 | East |  | 412 | Furits-AB | Alkja | Candy |  | 12.36 |  |  |  |  |  |  | 364 |  |  |  | Price | Code | Rating
Tex-24 | Netherland | L-4 | South |  | 985 | Furits-AB | [NAME] | Guava |  | 84.44 |  |  |  |  |  |  | 24 |  |  | Apple | 98 | 10928 | R-4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange | 124 | 16119 | S-23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grapes | 33 | 14845 | D-94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mango | 54 | 64 | M-44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | 364 | 412 | A-25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guava | 24 | 985 | L-4
Spreadsheet: 544858d1509062964-stock-availability-conditional-formating-soh-avail-tick-demo
Sheet: Sheet1

Customer Quote
Date
Customer | [NAME]
QTY | Item Code | Item Description | Unit Cost | Stock Available
30 | FAD180 | Ferrule DIN Alum 18mm |  | 1402
30 | FAD220 | Ferrule DIN Alum 22mm |  | 853
30 | FAD240 | Ferrule DIN Alum 24mm |  | 696
30 | FAD260 | Ferrule DIN Alum 26mm |  | 760
30 | TAS1138-20 | Thimble AS1138 HDG 20mm |  | 349
Spreadsheet: 884602d1733834982-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User16

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date
Total