tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113794d1309646955-i-could-use-nested-if-statements-but-vlookupvalidation
Sheet: Sheet2

Property | Interest
Prop 1 | 2.111121883200028
Prop 2 | 2.775739733803401
Prop 3 | 2.639312478165305
Prop 4 | 2.970311274742321
Prop 5 | 2.670516020992621
Prop 6 | 1.7089259327987
Prop 7 | 1.518750565900707
Prop 8 | 1.735428387648065
Prop 9 | 1.889622364080798
Prop 10 | 2.104147301489595
Prop 11 | 1.25630128633084
Prop 12 | 2.150248957015088
Prop 13 | 2.445234620722027
Prop 14 | 2.199974278486629
Prop 15 | 1.308485153096115
Prop 16 | 2.694556110062238
Prop 17 | 1.14770925969395
Prop 18 | 2.91033021350991
Prop 19 | 1.942507552783237
Prop 20 | 2.103442537996433
Prop 21 | 1.417015456322628
Prop 22 | 1.324291256346062
Prop 23 | 2.857698363607872
Prop 24 | 1.698694223029586
Prop 25 | 1.320677156933449
Prop 26 | 2.67244558347509
Spreadsheet: 106918d1304070855-how-to-add-joining-lines-between-points-in-an-xyplot-773897b
Sheet: Sheet2

 | X | Y
A | -4.142857142857143 | 4.142857142857143
B | 2.571428571428572 | 2.571428571428572
D | 1.142857142857143 | -1.142857142857143
C | -3.142857142857143 | -3.142857142857143
Repeat | -4.142857142857143 | 4.142857142857143
 | -6 | 6
 | 6 | -6
 | 6 | 6
 | -6 | -6
 | 0 | 3.173252279635259
 |  |  |  |  |  |  |  |  |  |  |  |  | Series 1 |  |  |  |  | X | Y | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 3.173252279635259 |  |  |  | A | -4.142857142857143 | 4.142857142857143 | 5.858884758402823
 |  |  |  |  |  |  |  |  |  |  |  | B | 3.636549160387959 |  |  |  | B | 2.571428571428572 | 2.571428571428572 | 3.636549160387959
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | D | 1.142857142857143 | -1.142857142857143 | 1.616244071283537
 |  |  |  |  |  |  |  |  |  |  |  | D | 1.616244071283537 |  |  |  | C | -3.142857142857143 | -3.142857142857143 | 4.444671196029727
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | C | 4.444671196029727
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  | Side C | 6.895724792084097
 |  |  |  |  |  |  |  |  |  |  |  | A | 5.858884758402823 |  |  |  | Angle c | 31.82744657667311 | 13.17255342332689
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 0.969604863221884
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 3.173252279635259
Spreadsheet: 130782d1322581186-excel-fomulas-to-gather-data-from-multiple-spreadsheets-cost-analysis-corporate
Sheet: Sheet1

Expenses | FY09 | FY10 | FY11 | *FY12 | *Projection
Corporate
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J1
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DHRS
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J3
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DORRA
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DLA C
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DLA P
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DLA E
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J5
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J7
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
DCSO
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J8
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
J9
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
D
Labor
Travel
Transportation
Utilities
Printing
Contracts
Training
Supplies
Equipment
Interest
Spreadsheet: 123999d1317988563-is-it-possible-to-automatically-generate-unique-reference-numbers-for-a-row-of-data-book1_pharmakt4
Sheet: Sheet1

Ref No | New No
1234/56 | 1
1234/57 | 2
1234/58 | 3
1234/59 | 4
1234/60 | 5
1234/61 | 6
1234/62 | 7
1234/63 | 8
1234/64 | 9
1234/65 | 10
1234/66 | 11
1234/67 | 12
1234/68 | 13
1234/69 | 14
1234/70 | 15
1234/71 | 16
1234/72 | 17
1234/73 | 18
1234/74 | 19
1234/75 | 20
1234/76 | 21
1234/77 | 22
1234/78 | 23
1234/79 | 24
1234/80 | 25
1234/81 | 26
1234/82 | 27
1234/64 | 9
1234/65 | 10
1234/66 | 11
1234/67 | 12
1234/68 | 13
1234/69 | 14
1234/79 | 24
1234/80 | 25
1234/81 | 26
1234/82 | 27
1234/83 | 28
1234/84 | 29
1234/85 | 30
1234/56 | 1
1234/87 | 31
1234/88 | 32
1234/89 | 33
1234/90 | 34
1234/91 | 35
1234/92 | 36
1234/93 | 37
1234/94 | 38
Spreadsheet: 820551d1678167423-counting-available-beds-in-a-facility-sample
Sheet: Tabelle1

 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  |  |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr. [NAME]
 | 5 |  |  |  |  |  | Unisex
 | 6
 | 7
 | 7
Spreadsheet: 39402d1237557244-producing-automatic-reports-with-2-variables-example-44
Sheet: All

 | Today |  |  | 2009-03-20 13:46:38
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source Code | All |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | % | No | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 5fb5c5d0-03ca-4a84-aec2-a2e873ee167d
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
ICRU | Test | ICRU | Iodine/Creatinine Ratio, Random, [NAME] | Iodine/Creat Ratio, Random, U | ICR/32495: Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 16-40 years: 70-530 mcg/g Creatinine 41-70 years: 70-860 mcg/g Creatinine >70 years: 70-1,150 mcg/g Creatinine Reference values have not been established for patients that are <16 years of age. | Monday, Tuesday, Wednesday, Friday; 5 p.m. | 1 day | 3 days |  | Profile |  |  |  |  | Rochester
ICRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
ICRU | Component | ICR | Iodine/Creatinine Ratio, [NAME] | Iodine/Creat Ratio, U | Only orderable as part of a profile. For further information see #60440 Iodine/Creatinine Ratio, Random, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60440 Iodine/Creatinine Ratio, Random, [NAME] |  |  | Only orderable as part of a profile. For further information see #60440 Iodine/Creatinine Ratio, Random, [NAME] |  |  |  | 1 | 83789 |  |  | Yes | No
ICR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
ICR | Result | 32874 | Iodine/Creat Ratio, U | Iodine/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
ICR | Result | 32889 | I Concentration | I Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
ICRU | Component | CDCR | [NAME] | [NAME] | For further information see #8513 "Creatinine, U." |  |  |  | 5 | mL | Only orderable as part of a profile. For further information  see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 694980d1599931613-extract-unique-distinct-pairs-from-a-range-book1
Sheet: Sheet1

[NAME] | [NAME] |  | This is what the formula should return:
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
 |  | <---dynamic formula returns 7 unique pairs here, ignoring dupicates
Spreadsheet: 64637d1265416996-index-match-formula-to-find-multiple-data-example
Sheet: Team

Month | Manager
Jan | Smith
TM | Calls | Contacts | Sales
Nate
[NAME]
[NAME]
[NAME]
what I want is to type in Smith in B15 and it pulls the team members in cells A17:D20
Month | Manager
Jan | Smith
TM | Calls | Contacts | Sales
[NAME] | 231 | 42 | 15
[NAME] | 198 | 31 | 10
[NAME] | 267 | 48 | 14
[NAME] | 211 | 41 | 18
Spreadsheet: 166090d1341468609-excel-2007-need-help-with-a-pie-or-column-chart-pivotchart-example
Sheet: Sheet1

Type | Amount
extended | 14.7
VIP | 4.7
extended | 14.7
extended | 24.7
extended | 14.7
VIP | 4.7
extended | 14.7
VIP | 4.7
extended | 10.2
VIP | 4.7
dollars | 9.7
dollars | 14.7
Spreadsheet: 767823d1644663718-amortize-a-loan-that-is-interest-only-for-2-years-and-has-a-balloon-payment-amort-int-only-term
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Payment at End of Period (Day 2 to Day 1 next month) |  |  |  |  |  | Payment at Beginning of Period (Day 1 to last day of month)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Last Bal |  |  |  | [NAME] |  | Last Bal
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 64200.68 |  | 5933802.43 |  |  |  | 64200.68 |  | 5933802.43
 |  |  |  |  |  |  |  |  |  |  |  | Per# |  | Pmt | Int | End Bal |  | Per# |  | Pmt | Int | End Bal
 |  |  |  |  |  |  |  |  |  |  |  | 24 | 2016-08-01 00:00:00 |  |  | 10800000 |  | 24 | 2016-08-01 00:00:00 |  |  | 10800000
Spreadsheet: 161954d1339680830-comparing-multiple-cells-sample
Sheet: Before

Code | Name | Entry Date | Location | [NAME] | Line | Qty | Promise_Date
SSS1 | Sample Inc. | 20101117 | A | 21178 | 2 | 20657 | 2012-07-02 00:00:00
SSS1 | Sample Inc. | 20101117 | P | 21178 | 2 | 20657 | 2012-07-02 00:00:00
SSS1 | Sample Inc. | 20120116 | A | 31712 | 3 | 2500 | 2012-06-15 00:00:00
SSS1 | Sample Inc. | 20120116 | P | 31712 | 3 | 2500 | 2012-07-04 00:00:00
SSS1 | Sample Inc. | 20120116 | A | 31712 | 4 | 2000 | 2012-10-05 00:00:00
SSS1 | Sample Inc. | 20120116 | P | 31712 | 4 | 2000 | 2012-10-05 00:00:00
SSS1 | Sample Inc. | 20120127 | A | 18708 | 1 | 7 | 2012-07-27 00:00:00
SSS1 | Sample Inc. | 20120127 | P | 69050 | 16 | 250 | 2012-06-12 00:00:00
SSS1 | Sample Inc. | 20110801 | A | 16291 | 1 | 1 | 2012-06-08 00:00:00
SSS1 | Sample Inc. | 20120209 | A | 56381 | 1 | 2500 | 2012-06-22 00:00:00
SSS1 | Sample Inc. | 20120209 | P | 56381 | 1 | 2500 | 2012-06-22 00:00:00
Spreadsheet: 5cae12b5-2a77-4cab-aeb8-e60620679d93
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
FCASO | Test | FCASO | [NAME] ([NAME]) | [NAME] (CAS) | [NAME] dilution |  |  |  |  |  | Container/Tube: Agar slant or other appropriate media [NAME] Organism in pure culture  Collection Instructions: 1.	Organism must be in pure culture, actively growing 2.	Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. |  | Specimens other than	Actively growing mold in pure culture Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Test Performed by:  U.T. Health Science Ctr San Antonio                                        7703 [NAME]Department of Pathology                                        Fungal Lab                                        San Antonio, TX 79229-3900 | Monday | 4-10 days | 6-12 days |  | Profile |  |  |  |  | U.T. Health Science Ctr San Antonio
FCASO | [NAME] | VARIES | Varies |  |  |  | Ambient
FCASO | Order Question | Z2188 | Source |  | Plain Text
FCASO | Order Question | [NAME] | Received As (Organism) |  | Plain Text
FCASO | Result | Z2188 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCASO | Result | [NAME] | Received As (Organism) | Received As (Organism) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCASO | Result | Z2189 | Result | Result | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
FCASO | Result | Z2193 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCASO | Billing Component | FCASO |  | microdilution or agar dilution, minimum lethal concentration |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87187
FCASO | Billing Component | FCASO |  | microdilution or agar dilution |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87186
FCASO | Billing Component | FCASO |  | macrobroth dilution method |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87188
Spreadsheet: 794950d1662430508-formula-to-search-value-across-multiple-sheets-example
Sheet: Session 1

Attended |  | Awaiting Arrival | Cancelled | No Show
Course: [Course Name] |  |  |  | Course Status: | Tentative
Date: | Monday 26th September |  | Time: [Time]
Department: [Department] |  |  | Facilitator: [Facilitator]
Location: [Location]
 | Name | Role | Leader | Notes
1 | [NAME]
2 | [NAME]
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Select hyperlink to return to schedule → |  | Schedule
Spreadsheet: 40964cf3-b7b8-45a5-8b56-5acf84b2f564
Sheet: Sheet1

[NAME] | Shenzhen Riitek Technology Co.,LTD | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | 4/F, Block A1, Area A, Baoyunda Logistic Center, Baoan District, Shenzhen, China
 | Tel: 86-755-61191688，Fax: 0755-61586009-601
 | Web: www.riitek.com
Model NO. |  | i5
Brand |  | Rii
Product details（参数描述）
Receiver(dongle) |  | No
Connect port |  | With USB2.0 above
Processor(MCU) |  | BCM20730 Serials
Transmit mode |  | Bluetooth 3.0
Transmit Power |  | Less than +4db
Power  supply |  | Rechargeable 200mAh polymer Lithium-ion battery
Charging voltage |  | 4.4V ~ 5.25V
Charging current |  | 300mA
Sleeping Current class1 |  | 20uA
Operation Voltage |  | 3.7V
Operating Current |  | <50mA
Product weight |  | 125g
Product Size |  | 131mm*18mm*75mm
Color |  | Black+Silver
Accessories（配件清单）
USB cable for charging |  | 1pcs |  |  | Yes
User manual |  | 1pcs |  |  | Yes
Packing（装箱资料）
Unit packing Size |  | 154mm*97.5mm*60mm |  |  | Yes
Unit packing Weight |  | 240g |  |  | Yes
Unit/Carton |  | 50pcs |  |  | Yes
Unit [NAME] |  | xxxxxxx |  |  | Yes
Weight/Carton |  | xxxxxKG
Product descriptor(特色功能)
This is wonderful Bluetooth Bluetooth Mini QWERTY Keyboard, You can use it for e-mails, chat,or to enjoy your favorite games,it is compatible with desktop computers running windows or [NAME] but also with handhelds running Android ,Windows Mobile Pocket PCs or Symbian S60 Operating systems. It also supports the sony playstation3 .Use it with your HTPC on your Sofa or browse the internet in the most comfortable fashion. Built-in rechargeabler lithium-ion battery .We confident you enjoy using the Mini Bluetooth Keyboard and find it to be quite a useful solution .
Product Picture（产品图片）
Giftbox（包装图片）
MOQ, Price, Delivery（起订量，价格，交期）
MOQ |  | 500PCS
Prices |  | 23USD
Lowest Retail Price:
Delivery |  | 30 working days after receipt of 30% deposit
Remark
Spreadsheet: 107075d1304261130-excel-2007-pick-n-largest-values-and-return-subsequent-data-media_vs_return_condensed
Sheet: ∆media

 | ABG SUNDAL CLI.HLDG. | ACTA HOLDING | ACTIVE 24 DEAD - 06/10/2006 | ADELSTEN HOLDING 'A' DEAD - DELIST 09/09/99 | AF GRUPPEN 'A' | AGR GROUP | AGRESSO DEAD - T/O BY 676348 | AKER BIOMARINE | AKER DRILLING | AKER FLOATING PRODUCTION | AKER MARITIME DEAD - DELIST 18/02/02 | AKER RGI A DEAD - DELIST 16/02/00 | AKER SEAFOODS | AKER SOLUTIONS | AKTIV KAPITAL | AKVA GROUP | ALGETA | AMERICAN SHIPPING CO. | AMERSHAM (OSL) DEAD - 30/03/04 | ANDVORD TYBRING GJEDDE DEAD - 21/11/06 | APL DEAD - 15/06/07 | APPTIX | A-PRESSEN DEAD - DEAD-31/10/03 | AQUA BIO TECHNOLOGY | ARENDALS FOSSEKOMPANI | [NAME] 27/10/99 | ATEA | ATLANTIC CTNR.LINE DEAD - DELIST 01/03/02 | AUSTEVOLL SEAFOOD | AVENIR DEAD - DELIST 24/10/00 | AVOCET MINING (OSL) | AWILCO OFFSHORE DEAD - 16/10/08 | AXIS-SHIELD (OSL) | AXXESSIT DEAD - 08/09/05
Spreadsheet: 695684d1600343517-finding-greatest-date-and-two-dates-before-summation-of-values-of-last-3-dates
Sheet: Sheet1

Date | Company | Amount |  |  | Sum of the most recent 3 days
2020-09-02 00:00:00 | HR | 354
2020-09-03 00:00:00 | WM | 235 |  | Company | Amount
2020-09-11 00:00:00 | WM | 248 |  | WM | 1111 |  |  | Need a formula to find the greatest date, sum amount of greatest date and the previous 2 dates a amount occurred by company
2020-09-01 00:00:00 | WM | 347 |  | HR | 1570
2020-09-05 00:00:00 | HR | 348 |  | BH | 1502
2020-09-08 00:00:00 | WM | 374
2020-09-06 00:00:00 | HR | 421
2020-09-11 00:00:00 | BH | 426
2020-09-04 00:00:00 | BH | 437
2020-09-05 00:00:00 | HR | 482
2020-09-04 00:00:00 | BH | 483
2020-09-02 00:00:00 | HR | 485
2020-09-10 00:00:00 | WM | 489
2020-09-10 00:00:00 | HR | 495
2020-09-11 00:00:00 | HR | 503
2020-09-09 00:00:00 | HR | 572
2020-09-05 00:00:00 | WM | 586
2020-09-07 00:00:00 | HR | 586
2020-09-07 00:00:00 | BH | 593
2020-09-03 00:00:00 | BH | 670
2020-09-08 00:00:00 | HR | 694
2020-09-01 00:00:00 | WM | 982
Spreadsheet: 644f6685-07d9-4337-8869-aa8d8073f747
Sheet: Sheet1

All Cancers Excluding Non-Melanoma Skin Cancer (C00-97 Excl. C44): 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Number of New Cases, Crude and European Age-Standardised (AS) Incidence Rates per 100,000 Population, Ages 0 to 04 - 85+, UK
 |  | England | Wales | Scotland | Northern Ireland | United Kingdom
Male | Cases | 136372 | 9363 | 14036 | 4133 | 163904
 | Crude Rate | 529.4 | 636.5 | 554.7 | 467.3 | 534.9
 | AS Rate | 422.6 | 453.7 | 436.7 | 426.2 | 425.5
 | AS Rate - 95% LCL* | 420.3 | 444.5 | 429.5 | 413.2 | 423.5
 | AS Rate - 95% UCL* | 424.8 | 462.9 | 444 | 439.2 | 427.6
Female | Cases | 132386 | 8769 | 15413 | 4107 | 160675
 | Crude Rate | 500 | 571.1 | 572.6 | 448.9 | 508.2
 | AS Rate | 369.6 | 390.6 | 408.1 | 365 | 374
 | AS Rate - 95% LCL* | 367.6 | 382.4 | 401.7 | 353.8 | 372.1
 | AS Rate - 95% UCL* | 371.5 | 398.8 | 414.6 | 376.2 | 375.8
Persons | Cases | 268758 | 18132 | 29449 | 8240 | 324579
 | Crude Rate | 514.5 | 603.1 | 563.9 | 457.9 | 521.3
 | AS Rate | 390.8 | 416.3 | 417.2 | 388.5 | 394.4
 | AS Rate - 95% LCL* | 389.3 | 410.3 | 412.5 | 380.1 | 393
 | AS Rate - 95% UCL* | 392.3 | 422.4 | 422 | 396.9 | 395.8
* 95% LCL and 95% UCL are the 95% lower and upper confidence limits around the AS Rate
Please include the citation provided in our Frequently Asked Questions when reproducing this chart: http://info.cancerresearchuk.org/cancerstats/faqs/#How
Prepared by Cancer Research UK
Original data sources:
1. Office for National Statistics. [NAME]: Registrations Series MB1. http://www.ons.gov.uk/ons/search/index.html?newquery=series+mb1
2. Welsh Cancer Intelligence and Surveillance Unit. http://www.wcisu.wales.nhs.uk
3. Information Services Division Scotland. Cancer Information Programme. www.isdscotland.org/cancer
4. N. Ireland Cancer Registry. www.qub.ac.uk/nicr.
Spreadsheet: 31757d1227709227-add-cells-with-color-only-generic-hours-and-miles_2008
Sheet: October

OCTOBER | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 46020d1244799811-recurring-meetings-calender-recurring
Sheet: Meetings

Meeting | Frequency | Week | Day
MBU | Monthly | 2 | Monday
MMM | Weekly | 1,3,4 | Monday
QBU | Quarterly | 1 | Monday
Fiscal Close | Monthly | 4 | Friday
BPM | Monthly | 1 | Friday
Spreadsheet: 868961d1715670181-embedded-excel-file-not-working-on-website-funeral-landing-page_quote_v4
Sheet: Spouse_Child

Cover | (01-05) | (06-17) | (18-24) | (25-34) | (35-44) | (45-54) | (55-64) | (65-69) | (70-74)
2000 | 5 | 5 | 7 | 8 | 9 | 12 | 15 | 35 | 38
4000 | 9 | 9 | 12 | 14 | 17 | 24 | 29 | 69 | 76
10000 | 21 | 21 | 29 | 34 | 42 | 57 | 71 | 170 | 189
14000 | 30 | 30 | 40 | 48 | 59 | 80 | 99 | 238 | 265
20000 | 0 | 42 | 57 | 68 | 84 | 114 | 141 | 339 | 378
24000 | 0 | 50 | 67 | 79 | 99 | 133 | 164 | 394 | 441
30000 | 0 | 57 | 77 | 92 | 114 | 154 | 191 | 0 | 0
50000 | 0 | 88 | 119 | 140 | 175 | 237 | 293 | 0 | 0
100000 | 0 | 0 | 227 | 269 | 336 | 454 | 563 | 0 | 0
Age | Cover Amount |  | Premium
5 | 10000
Spreadsheet: 818365d1676769195-i-cant-have-my-formula-to-also-spill-to-other-columns-but-rows-dummydata-helpplease
Sheet: Totals

Desired Input | For desired input, I want to only use a single formula so I don't drag it to the right in case times extend.
 | Date |  | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00 | 1900-01-01 02:30:00 | 1900-01-01 03:00:00 | 1900-01-01 03:30:00 | 1900-01-01 04:00:00 | 1900-01-01 04:30:00 | 1900-01-01 05:00:00 | 1900-01-01 05:30:00 | 1900-01-01 06:00:00 | 1900-01-01 06:30:00
 | 2023-02-14 00:00:00
 | 2023-02-15 00:00:00
 | 2023-02-16 00:00:00
 | 2023-02-17 00:00:00
 | 2023-02-18 00:00:00
 | 2023-02-19 00:00:00
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -26847 | -26700
2 | -25036 | -25000
3 | -30383 | -30000
4 | -25426 | -25000
5 | -29173 | -28993
6 | -105729 | -105327
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
2002-02-28 00:00:00 |  |  | 16991
2002-03-06 00:00:00
CBS Volume
 |  |  | 6099
Spreadsheet: 712857d1610454910-consolidate-data-from-2-sheets-comparison-sample-data
Sheet: Sheet2

Code | Price
A | 10
A1 | 5
A2 | 4
A5 | 8
B | 3
B1 | 5
C | 7
C4 | 25
C6 | 30
D | 1
D1 | 5