tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eric_saibi__9821__092601R
Sheet: Donald C Cook  02

Owner Name |  | American Electric Power
Station Name |  | [NAME]
Unit Name |  | [NAME] 02
NERC Region |  | ECAR
State |  | MI
Fuel Type |  | Nuclear
Capacity |  | 1,133 MW
Start Date |  | 2001-08-30 00:00:00
End Date |  | 2001-10-02 00:00:00
Prv. Start Date |  | 2001-08-30 00:00:00
Prv. End Date |  | 2001-09-30 00:00:00
Comments |  | Circ Water Pump repairs.  Expect to be back on line a few days after Cook 01 (09/29).
SIC |  | 4911
Plant ID |  | 1000365
Unit ID |  | 1005088
Outage ID |  | 18235
Spreadsheet: 8ed5240e-c022-4f75-bf6e-39b3c08adeaf
Sheet: Sheet1

ENCLOSURE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Reporting period: |  |  |  | 1 Jan 2010 |  | to | 30 Sept 2010
Quarterly Financial Report-TFI-POD
Tax number (MB): |  | 0820431
Registration number ([NAME]): |  | 040035700
Personal identification number (OIB): |  | [PHONE]
Issuer: |  | OT-OPTIMA TELEKOM DD
Postal code and location: |  | 10020 |  |  | BUZIN
Street and number: |  | BANI 75 A
E-mail: |  | [EMAIL]
Internet address: |  | www.optima.hr
Code and city / municipality |  | 133
Code and county |  | 21 | CITY OF ZAGREB |  |  |  | Number of employees: | 179
 |  |  |  |  |  |  | (at the end of trimester)
Consolidated Report |  | NO |  |  |  | Business activity code: |  | 6111
Entities in consolidation (according to IFRS) |  |  |  | Registered seat: |  |  | Tax number (MB):
Book-keeping office:
Contact person |  | IVANA GILJA
 |  | (name and surname of the contact person)
Telephone: |  | 015492023 |  |  |  | Fax: | 014817160
E-mail: |  | [EMAIL]
Name and surname: |  | [NAME], [NAME]
 |  | (authorized representatives)
 | Documents to be published:
 | 1. Financial Statements (Balance Sheet, Profit and Loss Account, Cash Flow Statement, Change in Capital Statement and
 | Notes to Financial Statements)
 | 2. Statement of persons in charge of making financial reports
 | 3. Management Board's  Report
 |  |  |  | SEAL |  | (signature of authorized representative)
Spreadsheet: 692724d1598525263-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum
Sheet: 24.08.2020

Emp No | Employee Name | Other Projects | Project Hours Total | Presence Hours | Absence Hours | Scheduled Hours
1 | [NAME] | Smith |  | 49 | 0 | 30
2 | [NAME] | Jones |  | 31.77 | 0 | 30
3 | Bobbi | [NAME] |  | 51 | 0 | 30
4 | [NAME] | Singh |  | 62 | 0 | 30
5 | [NAME] | [NAME] |  | 0 | 0 | 0
6 | Bertie | Davies |  | 31.47 | 0 | 30
7 | Obi | Stanley |  | 31.23 | 0 | 30
8 | Bobba | [NAME] | 36.62 | 36.62 | 0 | 30
9 | [NAME] | Bloggs |  | 47.08 | 0 | 0
Spreadsheet: 869904d1716456485-formula-to-pick-highest-value-form-multiple-columns-exampledata
Sheet: Sheet1

 | Name | Residential | Home | Nursing | Day | Domestic | Category
 | [NAME] | 150 |  |  |  |  | Residential
 | [NAME] |  |  |  | 75 | 100 | Domestic
 | [NAME] |  |  | 100 | 25 |  | Nursing
 | Geoff Green |  | 55 |  |  |  | Home
 | [NAME] | 89 |  |  |  |  | Residential
 | [NAME] |  |  | 100 |  | 25 | Nursing
Spreadsheet: 152567d1335439302-heatmap-heatmap-temp
Sheet: Sheet1

 |  | jan |  | feb |  | may
 | A | 10 | 20 | 9 | 21 | 7 | 20
 | B | 15 | 6 | 15 | 6 | 15 | 5
 | D | 13 | 21 | 14 | 21 | 21 | 22
 | E | 12 | 13 | 13 | 14 | 14 | 15
 | F | 20 | 12 | 15 | 13 | 20 | 14
 | G | 1 | 20 | 6 | 21 | 5 | 21
 | H | 12 | 6 | 13 | 6 | 15 | 6
 | J | 13 | 21 | 18 | 21 | 19 | 21
 | K | 1 | 13 | 3 | 14 | 7 | 14
 | L | 19 | 12 | 21 | 13 | 22 | 13
 | *key | less than 0
 |  | 0-19
 |  | 20+
 |  | so if cell D4 is less than 0 turn cell C4 red, if 0-19 turn amber, if20+ turn green
Spreadsheet: 71066d1271798757-assigning-values-from-fixed-data-set-to-variable-data-set-zipcode_class
Sheet: Fixed

Zip | Class
198 | R
199 | R
501 | U
544 | U
601 | R
602 | U
603 | U
604 | U
605 | U
606 | R
610 | U
611 | S
612 | U
613 | U
614 | U
616 | U
617 | U
622 | R
623 | U
624 | U
627 | U
631 | R
636 | U
637 | U
638 | U
641 | S
646 | U
647 | U
650 | U
652 | U
653 | U
656 | U
659 | U
660 | U
662 | U
664 | S
667 | U
669 | U
670 | R
674 | U
676 | U
677 | U
678 | U
680 | U
681 | U
682 | U
683 | U
685 | U
687 | U
688 | U
Spreadsheet: 82945d1282927528-cross-data-validation-new-item-change-form-atalanta
Sheet: Processing Type

Process Indicator Code | Name | Process Type Definition
D | Raw, Fresh Frozen | Product is in its natural state.  The product may be fresh Packaged and frozen.  Includes frozen de-headed "shell-on" shrimp, de-headed and/or gutted whole fish, etc.
E | Commercially Sterile | Packed in Hermetically sealed Containers; then heated to achieve commercial sterility.  Product is shelf stable.  Examples Include Canned Vegtables and Canned Fish Products. Canned Fruit, Most Tomato Products, and pickled Vegtables do not fall within here.
H | Dried Natural or Artificial | The product is either dried naturally or by using heat, cold, and/or chemicals.  [NAME], dried fruit mixes, nonfat dry milk, etc.
I | Acidified | Packed in Hermetically sealed containers; acids or acid foods added to low-acid food(s). May be heat treated or pasteurized.  Product is Shelf Stable.  Examples Include Vegtables such as Peppers, Pickles and Relish are acidified.
P | Cultured Or Cured | The product is cultured, fermented, salted (brined), (pickled), smoked cured, sugar cured or has an enzymatic reaction which may be the result of naturally occuring enzymes or chemicals.  Examples include sauerkraut, aged cheese (hard or soft).  This does not include products that have been processed by direct acidification (adding an acid ingredient, such as vinegar, directly to the product)
T | Packaged Food (not commercially sterile) | These Products are not commercially sterile but may be hermetically sealded.  This product may or may not be shelf stable.  Processing of the finished product may include any of the following processes:
Y | Not Elsewhwere Classified | This classification is for products that receive a new or unusual process that does not fit any of the other Process Indicator codes
Spreadsheet: 70073d1270734682-combining-spreadsheet-data-book1
Sheet: Sheet1

ClientID_Value | Area | Last Visited | What Dept? | Did they [NAME]? | How much spent?
12858 | Cardiff | 2010-03-30 00:00:00 | Toys | yes | £1.50
12857 | Cardiff | 2010-03-19 00:00:00 | Clothes | No | £1.51
12852 | Cardiff | 2010-03-30 00:00:00 | Hardware | yes | £1.52
12843 | Cardiff | 2010-03-29 00:00:00 | Toys | No | £1.53
12841 | Cardiff | 2010-03-29 00:00:00 | Clothes | yes | £1.54
12830 | Cardiff | 2010-03-28 00:00:00 | Hardware | No | £1.55
12827 | Swansea | 2010-03-26 00:00:00 | Toys | yes | £1.56
12827 | Swansea | 2010-03-26 00:00:00 | Clothes | No | £1.57
12820 | Swansea | 2010-03-26 00:00:00 | Hardware | yes | £1.58
12815 | Cardiff | 2010-03-25 00:00:00 | Toys | No | £1.59
12810 | Cardiff | 2010-03-25 00:00:00 | Clothes | yes | £1.60
12809 | Cardiff | 2010-03-25 00:00:00 | Hardware | No | £1.61
12808 | Swansea | 2010-03-24 00:00:00 | Toys | yes | £1.62
12808 | Swansea | 2010-03-24 00:00:00 | Clothes | No | £1.63
12800 | Swansea | 2010-03-24 00:00:00 | Hardware | yes | £1.64
12797 | Swansea | 2010-03-24 00:00:00 | Toys | No | £1.65
12796 | Swansea | 2010-03-24 00:00:00 | Clothes | yes | £1.66
12795 | Cardiff | 2010-03-24 00:00:00 | Hardware | No | £1.67
12792 | Cardiff | 2010-03-24 00:00:00 | Toys | yes | £1.68
12789 | Swansea | 2010-03-24 00:00:00 | Clothes | No | £1.69
12789 | Swansea | 2010-03-24 00:00:00 | Hardware | yes | £1.70
12786 | Cardiff | 2010-03-23 00:00:00 | Toys | No | £1.71
12784 | Cardiff | 2010-03-23 00:00:00 | Clothes | yes | £1.72
Spreadsheet: 53291d1253190234-matching-various-conditions-in-two-lists-example
Sheet: Sheet1

List 1 |  |  |  |  |  | List 2
ID | Name | Amt | Group |  |  | ID | Name | Amt | Group
123456789 | Smith A | 500 | AAA |  |  | 777777777 | Smith F | 3000 | CCC
123456789 | Smith A | 1000 | BBB |  |  | 333333333 | Smith C | 500 | EEE
222222222 | Smith B | 2000 | BBB |  |  | 444444444 | Smith Z | 300 | AAA
222222222 | Smith B | 5000 | BBB |  |  | 222222222 | Smith B | 6000 | AAA
333333333 | Smith C | 100 | DDD |  |  | 123456789 | Smith A | 1000 | AAA
333333333 | Smith C | 500 | EEE |  |  | 123456789 | Smith A | 500 | BBB
888888888 | Smith P | 7000 | YYY
Spreadsheet: 178537d1346833584-formula-that-shows-the-list-from-a-given-condition-dummy-file
Sheet: Master Tracker

Client Name | Candidate Name | Case Received | Case Due Date | Client SLA | Case TAT | Case Cost | Additional Cost | Total Case Cost | [NAME]
LA Lakers | [NAME] | 2012-02-03 00:00:00 | 2012-12-25 00:00:00 | 9 | 14 | 600 |  | 600 | [NAME]
LA Lakers | [NAME] | 2012-07-03 00:00:00 | 2013-06-12 00:00:00 | 9 | 11 | 600 |  | 600 | [NAME]
LA Lakers | [NAME] | 2012-01-02 00:00:00 | 2012-01-13 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
Chicago Bulls | [NAME] | 2012-01-02 00:00:00 | 2012-01-13 00:00:00 | 9 | 11 | 1600 |  | 1600 | [NAME]
New York Knicks | [NAME] | 2012-01-02 00:00:00 | 2012-01-13 00:00:00 | 9 | 13 | 1600 |  | 1600 | [NAME]
OKC Thunders | [NAME] | 2012-01-02 00:00:00 | 2012-01-13 00:00:00 | 9 | 22 | 1600 |  | 1600 | [NAME]
[NAME] | [NAME] | 2012-01-03 00:00:00 | 2012-01-16 00:00:00 | 9 | 17 | 1600 |  | 1600 | [NAME]
[NAME] | [NAME] | 2012-01-03 00:00:00 | 2012-08-24 00:00:00 | 9 | 18 | 1600 |  | 1600 | [NAME]
New York Knicks | [NAME] | 2012-01-04 00:00:00 | 2012-09-01 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
Washington Wizards | [NAME] | 2012-01-04 00:00:00 | 2013-05-25 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
Chicago Bulls | [NAME] | 2012-01-04 00:00:00 | 2012-01-17 00:00:00 | 9 | 30 | 1600 |  | 1600 | [NAME]
[NAME] | [NAME] | 2012-01-05 00:00:00 | 2012-01-18 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
LA Clippers | [NAME] | 2012-01-06 00:00:00 | 2012-01-19 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
OKC Thunders | Russel Westbrook | 2012-01-06 00:00:00 | 2012-01-19 00:00:00 | 9 | 10 | 1600 |  | 1600 | [NAME]
San Antonio Spurs | [NAME] | 2012-01-06 00:00:00 | 2012-01-19 00:00:00 | 9 | 14 | 1600 |  | 1600 | [NAME]
Spreadsheet: shelley_corman__38709__Locations
Sheet: By Market

Area | Pipeline | Location
Florida | Florida Gas Transmission | Washington Co., FL to Bay Co., FL
 | Southern Natural Gas | GA to FL
New England | Algonquin Gas Transmission | NY to CT
 | Iroquois Gas Transmission | NY to CT
 | Maritimes & Northeast | CN to ME
 | Portland Natural Gas Transmission | CN to NH
 | Tennessee Gas Pipeline | NY to CT, NY to MA
New York | Iroquois Gas Transmission | Connection to NYC Interconnected pipelines
 | Tennessee Gas Pipeline | Connection to NYC Interconnected pipelines
 | Texas Eastern Transmission | Connection to NYC Interconnected pipelines
 | Transcontinental Gas Pipe Line | Connection to NYC Interconnected pipelines
Northern Illinois | Alliance Pipeline | IA to IL
 | [NAME] | Sandwich Comp. Station, St. [NAME]. Station going west
 | Midwestern Gas Transmission | [NAME]. Station
 | Natural Gas Pipeline of America | Station 110, Station 311
 | Northern Border | Station 17
 | Northern Natural | Connection to NICOR at Galena
 | Panhandle Eastern | Connection to NICOR and/or Peoples Gas Light
 | Trunkline Gas | Connection to NICOR and/or Peoples Gas Light
California | El Paso Natural Gas | AZ to CA
 | Kern River Gas Transmission | NV to CA
 | PG&E Gas Transmission--Northwest | OR to CA (PG&E)
 | [NAME] | AZ to CA
[NAME] | [NAME] | SW Headstation
 | Natural Gas Pipeline of America | Station 193, Station 156 South (Toward Transok)
 | Northern Natural | [NAME]. Station
 | Panhandle Eastern | Haven Comp. Station
 | Reliant Energy Gas Transmission | Amber Junction Comp Station
 | Williams Gas Pipelines Central | [NAME]. Station, Woods Co., OK to Alfalfa Co., OK (3 Lines)
San Juan | El Paso Natural Gas | Out of San Juan Basin
 | Northwest Pipeline | Pleasant View Comp. Station
 | [NAME] | Gallup Comp. Station
Gulf Coast | [NAME] | LA to AR
 | Columbia Gulf | LA to MS
 | Florida Gas Transmission | Station 12
 | [NAME] | Entire System
 | Mississippi River Transmission | LA to AR
 | Natural Gas Pipeline of America | TX to AR
 | Southern Natural Gas | Zone 1 to Zone 2
 | Tennessee Gas Pipeline | LA to AR, LA to MS, Kemper Co., MS to Noxubee Co., MS
 | Texas Eastern Transmission | Atlanta Comp. Station, [NAME]. Station
 | Texas Gas Transmission | LA to AR
 | Transcontinental Gas Pipe Line | Station 90
 | Trunkline Gas | LA to AR
Spreadsheet: 552ad174-ea9d-4fd7-bb78-6d22be634c12
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259068 | 71916 | [NAME] | [NAME] | RSA |  | 00:38:23 | 00:00:00 | 01:18:07 | 00:00:00 | 00:19:40 | 1 | 02:16:10
259068 | 41707 | Marusa | Mason | RSA |  | 00:44:29 | 00:00:00 | 01:21:29 | 00:00:00 | 00:23:21 | 2 | 02:29:19
259068 | 71915 | [NAME] | Fisher | RSA |  | 00:44:48 | 00:00:00 | 01:24:36 | 00:00:00 | 00:23:33 | 3 | 02:32:57
259068 | 64024 | [NAME] | [NAME] | RSA |  | [NAME] | 00:00:00 | 01:23:27 | 00:00:00 | 00:25:35 | 4 | 02:33:05
259068 | 71917 | Theresa | Klopper | RSA |  | 00:43:32 | 00:00:00 | [NAME] | 00:00:00 | 00:24:38 | 5 | [NAME]
259068 | 71918 | Hanlie | Groenewald | RSA |  | 00:45:44 | 00:00:00 | 01:29:41 | 00:00:00 | 00:24:38 | 6 | 02:40:03
259068 | 71919 | [NAME] | Schoeman | RSA |  | 00:49:17 | 00:00:00 | 01:44:22 | 00:00:00 | 00:29:30 | 7 | 03:03:09
Spreadsheet: 53956d1253882449-if-name-name-and-dates-dates-then-get-value-example-1-
Sheet: Sheet1

 |  |  | WK 23 | WK 24 | WK 25 | WK 26 | Monthly Average | TEAM AVERAGE
 | [NAME] | [NAME] | 0.8 | 0.9 |  |  | 0.8500000000000001
 |  | [NAME] |  |  |  |  | #N/A
 |  | [NAME] | 1 | 0.95 |  |  | 0.975
 |  | Darren Davies | 0.95 | 0.95 |  |  | 0.95
 |  |  | WK 23 | WK 24 | WK 25 | WK 26 | Monthly Average | TEAM AVERAGE
 | [NAME] | [NAME] | 0.8 | 0.9 | 1 |  | 0.9
 |  | [NAME] |  |  | 0.8 |  | 0.8
 |  | [NAME] | 1 | 0.95 | 1 |  | 0.9833333333333334
 |  | Darren Davies | 0.95 | 0.95 | 0.95 |  | 0.9499999999999998
Spreadsheet: 815272d1674840695-splitting-row-by-values-into-multiple-rows-makearray-test3
Sheet: Post Count Processing - Multilo

Data Matrix |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MakeArray Attempt
ROWHEADER-1 | 7 | 7 | 10 | 8 | 4 | 13 | 8 | 6 | 16 | 18 | 12 | 4 |  |  |  | 10
[NAME] | 13 | 17 | 17 | 8 | 19 | 2 | 0 | 11 | 17 |  |  |  |  |  | 7
ROWHEADER-3 | 0 | 1 | 4 | 2 | 18 | 13 | 3 | 0 |  |  |  |  |  |  | 13
ROWHEADER-4 | 17 | 10 | 17 | 17 | 18 | 19 | 11 |  |  |  |  |  |  |  | 0
ROWHEADER-5 | 1 | 14 | 18 | 11 | 13 | 0 |  |  |  |  |  |  |  |  | 17
ROWHEADER-6 | 19 | 7 | 11 | 11 | 0 |  |  |  |  |  |  |  |  |  | 1
ROWHEADER-7 | 16 | 11 | 4 | 2 |  |  |  |  |  |  |  |  |  |  | 19
ROWHEADER-8 | 10 | 7 | 4 | 9 |  |  |  |  |  |  |  |  |  |  | 16
ROWHEADER-9 | 11 | 7 | 11 |  |  |  |  |  |  |  |  |  |  |  | 11
ROWHEADER-10 | 10 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 787685d1657963197-calculate-average-from-irregular-matrix-table-sample-data
Sheet: Sheet4

 |  | 9 | 10 | 11 |  |  |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 9 |  |  |  |  |  |  | 9 | 9 | 9 | 9 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 11
 | 10 |  |  |  |  |  | 9 | 2 | 4 | 0 | 6 | 32 | 2 | 2 | 7 | 2 | 3 | 32 | 2
 | 11 |  |  |  |  |  | 9 | 5 | 4 | 2 | 36 | 2 | 3 | 5 | 8 | 6 | 4 | 22 | 3
 |  |  |  |  |  |  | 9 | 2 | 6 | 1 | 7 | 7 | 7 | 6 | 43 | 3 | 34 | 4 | 4
 |  |  |  |  |  |  | 9 | 7 | 8 | 6 | 2 | 5 | 52 | 7 | 6 | 6 | 3 | 56 | 6
 |  |  |  |  |  |  | 10 | 8 | 3 | 5 | 3 | 5 | 7 | 3 | 27 | 7 | 4 | 56 | 6
 |  |  |  |  |  |  | 10 | 2 | 8 | 37 | 3 | 6 | 8 | 4 | 8 | 2 | 3 | 3 | 4
 |  |  |  |  |  |  | 10 | 9 | 2 | 9 | 4 | 99 | 66 | 7 | 5 | 7 | 34 | 2 | 3
 |  |  |  |  |  |  | 10 | 6 | 1 | 0 | 5 | 2 | 4 | 8 | 4 | 8 | 2 | 12 | 2
 |  |  |  |  |  |  | 11 | 4 | 7 | 53 | 7 | 3 | 3 | 4 | 3 | 76 | 2 | 3 | 1
 |  |  |  |  |  |  | 11 | 6 | 4 | 3 | 22 | 6 | 7 | 2 | 5 | 5 | 4 | 5 | 2
 |  |  |  |  |  |  |  | 9 | 10 | 11
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
Spreadsheet: 775973d1649423132-automating-workbook-to-log-incoming-enquiries-test-track
Sheet: Test

Auto Assigned Reference number here (once data is entered in Column C2,3,4 etc) | Auto date here at the same time as A1  (once data is entered into C2,3,4 etc) | From (Manual entry) | Enquiry (manual entry) | Refered to (manual entry) | Deadline | Response | Date completed | Open Closed (conditionally formatted open/closed)
defined text reference number Auto inserted here  when data is entered in column C | Auto inserted here  when data is entered in column C (same time as Auto reference number) | [EMAIL] | General information regarding the query will be manually entered here | Person that the enquiry forwarded to will be added manually here (possibly as a dropdown) | Deadline date manually added here | Response from "relevant" person added manually here | Mnaually added date here when response is sent | Simple conditionally formatted cells to add "open" or "Closed" drop down here
 |  | [EMAIL] | General information regarding the query will be manually entered here | Person that the enquiry forwarded to will be added manually here (possibly as a dropdown) | Deadline date manually added here | Response from "relevant" person added manually here | Mnaually added date here when response is sent | Simple conditionally formatted cells to add "open" or "Closed" drop down here
 |  | [EMAIL] | General information regarding the query will be manually entered here | Person that the enquiry forwarded to will be added manually here (possibly as a dropdown) | Deadline date manually added here | Response from "relevant" person added manually here | Mnaually added date here when response is sent | Simple conditionally formatted cells to add "open" or "Closed" drop down here
 |  | [EMAIL] | General information regarding the query will be manually entered here | Person that the enquiry forwarded to will be added manually here (possibly as a dropdown) | Deadline date manually added here | Response from "relevant" person added manually here | Mnaually added date here when response is sent | Simple conditionally formatted cells to add "open" or "Closed" drop down here
 |  | [EMAIL] | General information regarding the query will be manually entered here | Person that the enquiry forwarded to will be added manually here (possibly as a dropdown) | Deadline date manually added here | Response from "relevant" person added manually here | Mnaually added date here when response is sent | Simple conditionally formatted cells to add "open" or "Closed" drop down here
Spreadsheet: 781411d1653312655-using-filter-function-with-array-criterias-book1
Sheet: Sheet1

 | Name | Value |  |  |  | Paste Value | Ideal output |  |  | What I'm trying to do
 | a | 510 |  |  |  | b
 | a | 962 |  |  |  | e
 | a | 584 |  |  |  | f
 | a | 780 |  |  |  | f
 | a | 130 |  |  |  | f
 | a | 824 |  |  |  | c
 | a | 405 |  |  |  | e
 | a | 547 |  |  |  | f
 | b | 310 |  |  |  | a
 | b | 9 |  |  |  | f
 | b | 331
 | b | 443
 | b | 647
 | b | 149
 | c | 513
 | c | 592
 | c | 749
 | c | 126
 | c | 161
 | c | 394
 | c | 344
 | c | 39
 | c | 496
 | c | 540
 | c | 769
 | d | 723
 | d | 761
 | d | 868
 | d | 509
 | d | 401
 | d | 379
 | d | 971
 | e | 319
 | e | 478
 | e | 979
 | e | 918
 | e | 406
 | e | 969
 | e | 240
 | f | 3
 | f | 649
 | f | 841
 | f | 691
 | f | 436
 | f | 397
 | f | 742
 | f | 860
 | f | 711
 | f | 369
 | f | 543
 | f | 896
 | f | 601
 | f | 904
 | g | 962
 | g | 499
 | g | 182
 | g | 503
 | g | 622
 | g | 19
 | g | 383
 | g | 111
 | g | 304
 | g | 716
 | g | 61
 | g | 538
 | g | 834
 | g | 816
Spreadsheet: 691956d1597971111-return-month-on-month-growth-using-current-month-prior-month-prior-month-per-country-budget-dummy
Sheet: Period

Month
Month | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Period
2
Days
Working Days
Fiscal Period
AU
AT
BE
AE
FR
DE
IE
JP
LU
NL
SG
ES
CH
UK
US
HK
Spreadsheet: 126056d1319494942-layout-question-calendar-array
Sheet: Calendar

 | Month |  | Year
 | 9 |  | 2010
 | 2010-09-01 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-03 00:00:00 | 2010-09-04 00:00:00
 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00 | 2010-09-07 00:00:00 | 2010-09-08 00:00:00 | 2010-09-09 00:00:00 | 2010-09-10 00:00:00 | 2010-09-11 00:00:00
 | 2010-09-12 00:00:00 | 2010-09-13 00:00:00 | 2010-09-14 00:00:00 | 2010-09-15 00:00:00 | 2010-09-16 00:00:00 | 2010-09-17 00:00:00 | 2010-09-18 00:00:00
 | 2010-09-19 00:00:00 | 2010-09-20 00:00:00 | 2010-09-21 00:00:00 | 2010-09-22 00:00:00 | 2010-09-23 00:00:00 | 2010-09-24 00:00:00 | 2010-09-25 00:00:00
 | 2010-09-26 00:00:00 | 2010-09-27 00:00:00 | 2010-09-28 00:00:00 | 2010-09-29 00:00:00 | 2010-09-30 00:00:00
Spreadsheet: 732430d1620940782-formula-that-returns-1-2-or-blank-depending-on-matched-pairs-stock-short-term-comparison-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | result
13 | 18 | 22 | 31 | 34 | 36 | 41 | 45 | 48 |  |  |  |  | patt analysis
1 ext..most below occur with bal(1ci/1cd same pattern)
12 | 15 | 19 | 22 | 25 | 29 | 31 | 33 | 41
14 | 19 | 20 | 24 | 28 | 35 | 40
13 | 19 | 21 | 23 | 26 | 30 | 33 | 37
12 | 17 | 21 | 30 | 43 | 49
12 | 19 | 23 | 43 | 42 | 46
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
14 | 19 | 23 | 27 | 42 | 46
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
12 | 17 | 21 | 25 | 33 | 44 | 39 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
12 | 17 | 23 | 25 | 26 | 32 | 39 | 43
12 | 19 | 21 | 25 | 26 | 32 | 39 | 43
Spreadsheet: 802424d1666845938-counting-data-with-criterias-book2
Sheet: Sheet2

Seq | Eq 1 | Name | Eq 2 | Name | Eq 3 | Name | Eq 4 | Name |  | Eq | Scoring
1 | 10 | ABC | 15 | ABC | 28 | ABC | 20 | ABC |  | 10
2 | 15 | DEF | 10 | DEF | 13 | DEF | 17 | DEF
3 | 8 | GHI | 9 | GHI | 10 | GHI | 12 | GHI
4 | 5 | Dock | 7 | Dock | 8 | Dock | 10 | Dock
5 | 10 | ABC | 15 | ABC | 28 | ABC | 20 | ABC
6 | 15 | DEF | 10 | DEF | 13 | DEF | 17 | DEF
7 | 8 | GHI | 9 | GHI | 10 | GHI | 12 | GHI
8 | 5 | Dock | 7 | Dock | 8 | Dock | 10 | Dock
9 | 10 | ABC | 15 | ABC | 28 | ABC | 20 | ABC