tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 385941d1427495426-problem-with-protecting-workbooks-which-have-lists-recording-sheet-version-8-ndm
Sheet: Micro Moths

Micro Moths |  |  |  |  | Please enter data in as many fields below as possible - leave blank where information not known. Required fields are highlighted with a blue cell below. Comments are also inserted in each header below giving extra user information.
ABH Log | BF Log | Status | Species [NAME] | Species Latin name | Place Name | [NAME]. | [NAME]. | [NAME] | Determiners Name | Date of Record | Qty Recorded | Method of Recording | [NAME] | Stage | Weather | Aspect | Altitude | [NAME]. | Notes
37.026 | 509 | None | - | [NAME] violacea |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2 | 3
37.028 | 510 | C | - | Coleophora juncicolella
37.029 | 511 | D | - | [NAME]
37.03 | 512 | D | - | Coleophora binderella
37.027 | 513 | None | - | [NAME] potentillae
37.031 | 514 | None | - | Coleophora ahenella
37.032 | 515 | C | - | [NAME]
37.033 | 516 | C | - | Coleophora trifolii
37.03 | 512 | D | - | Coleophora binderella
37.027 | 513 | None | - | [NAME] potentillae
37.031 | 514 | None | - | Coleophora ahenella
37.032 | 515 | C | - | [NAME]
37.033 | 516 | C | - | Coleophora trifolii
37.03 | 512 | D | - | Coleophora binderella
37.027 | 513 | None | - | [NAME] potentillae
37.031 | 514 | None | - | Coleophora ahenella
37.032 | 515 | C | - | [NAME]
37.033 | 516 | C | - | Coleophora trifolii
» | » | » | »
Spreadsheet: 729164d1618938266-build-delimited-list-from-column-values-samplesheet
Sheet: Sheet1

Username | columnA | columnB | columnC | columnD | Result
user1 | 1 |  | 2 | 1 | columnA:1|columnC:2|columnD:1
user2 |  | 1 | 1 | 3 | columnB:1|columnC:1|columnD:3
user3 |  | 1 |  |  | columnB:1
user4 | 1 | 1 | 1 | 1 | columnA:1|columnB:1|columnC:1|columnD:1
user5 |  |  | 1 | 1 | columnC:1|columnD:1
[NAME] | 2 | 2 | 2 | 3 | columnA:2|columnB:2|columnC:2|columnD:3
user7 | 3 | 1 |  |  | columnA:3|columnB:1
user8
[NAME] | 1 | 2 | 3 | 1 | columnA:1|columnB:2|columnC:3|columnD:1
user10 | 1 | 1 | 2 | 2 | columnA:1|columnB:1|columnC:2|columnD:2
Spreadsheet: 296478d1392108574-separating-multiple-data-w-delimiter-from-one-cell-to-many-cells-sample_workbook_v1
Sheet: Before

Name | Account # | Region | Country
Person A | "10001,10002,10003,10004" | North America | USA
Person B | "10005,10006" | Asia | China
Person C | "10007,10008,10009,10010,10011" | Europe | Germany
Person D | "10012,10013,10014" | Africa | South Africa
Person E | "10015,10016,10017" | Australia | Australia
Spreadsheet: d42393bb-85dd-4261-85c0-3f044687f24e
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
FHERV | Test | FHERV | Herpes Simplex Virus by PCR | Herpes Simplex Virus by PCR | Qualitative Polymerase Chain Reaction |  |  |  | 1 | mL | Submit only 1 of the following specimens:   Required:  Source   Serum  Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 1 mL of serum frozen in a plastic vial.   Plasma  Draw blood in a lavender-top (EDTA) or pink (K2EDTA) tube(s). ([NAME] tube is acceptable.) Spin down and send 1 mL of plasma frozen in a plastic vial. | 0.5 mL | Hemolysis:	Mild reject; Gross reject Thawing:	Warm reject; Cold OK Lipemia:	NA Icterus:	NA Other:	Heparinized specimen | Not Detected   This test is pursuant to an agreement with Roche Molecular Systems, Inc.   Test Performed By:  ARUP Laboratories                               500 [NAME]                               Salt Lake City, Utah  84108 | Sunday through Saturday | 1-3 days | 3-5 days | 1 | 87529 |  |  |  |  | ARUP Laboratories
FHERV | [NAME] | VARIES | Varies |  |  |  | Frozen | 90 days
FHERV | Order Question | [NAME] | Herpes Simplex Virus Source |  | Plain Text
FHERV | Result | [NAME] | Herpes Simplex Virus Source | Herpes Simplex Virus Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHERV | Result | Z2640 | Herpes Simplex Virus by PCR | Herpes Simplex Virus by PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 865723d1712739956-conditional-concatenated-list-forumq-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Expected answers
 | Arm ID | Arm Name | Bus Services |  |  |  | 1A | 1B | 1C | Bus Services Affected
 | 1A | A6181 Westgate | 633;634; |  |  |  | 1 | 0 | 0
 | 1B | [NAME] | 662;A3; |  |  |  | 0 | 1 | 1
 | 1C | B6144 Westgate | 617;618;620;621; |  |  |  | 1 | 0 | 1
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 1 | 1 | 1
Spreadsheet: 748568d1632219837-check-if-time-range-is-within-another-time-range-example2-1-kvs-1-
Sheet: Sheet1

 |  | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 |  | {=IF(ISNUMBER(SEARCH("*Test*";$A$2));IF(IFERROR(VALUE(RIGHT(C$2;5))>VALUE(LEFT(C$2;5)););IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Test | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL |  | {+IF(ISNUMBER(SEARCH("*Test*";$A$3));IF(IFERROR(VALUE(RIGHT(C$3;5))>VALUE(LEFT(C$3;5)););IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Different | Name | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00
Different | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL |  | As you can see the only thing that changed is, column A row number and columns C row number
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 |  | Problem | I have to do + untill I reach this 10th row which makes my formula too long if more rows will be added in the future
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 |  | Question | How to shorten the formula, so I can for example check 50+ rows in the future
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
 | 08:00-09:00
 | 09:00-10:00
 | 10:00-11:00
 | 11:00-12:00
 | 12:00-13:00
 | 13:00-14:00
 | 14:00-15:00
 | 15:00-16:00
 | 16:00-17:00
 | 17:00-18:00
 | 18:00-19:00
 | 19:00-20:00
 | 20:00-21:00
 | 21:00-22:00
 | 22:00-23:00
 | 23:00-24:00
Spreadsheet: 856567d1705768845-retrieving-and-moving-transferring-data-latest-problem-tashface-
Sheet: Feb

 | Main Total
2 | Week | Month | Year | Value
Spreadsheet: 98725d1297586328-finding-the-first-and-last-occurance-of-a-value-book1
Sheet: Sheet1

NO | CHPTR |  | 1ste # 2 | last # 2
5 | 1 |  | 9 | 10
2 | 1
8 | 1
10 | 2
6 | 1
1 | 1
7 | 1
4 | 1
9 | 2
3 | 1
Spreadsheet: 886088d1736088683-i-have-a-variable-list-of-items-and-then-want-to-rotate-that-list-with-functions-rotate-list
Sheet: Sheet1 (3)

A |  |  |  | B | C | D | E | F | G | H | I | J | K
B |  |  | K | A | B | C | D | E | F | G | H | I | J
C |  |  | J | K | A | B | C | D | E | F | G | H | I
D |  |  | I | J | K | A | B | C | D | E | F | G | H
E |  |  | H | I | J | K | A | B | C | D | E | F | G
F
G
H
I |  |  | Finding positions
J |  |  |  | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
K |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | 11 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 10 | 10 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 9 | 9 | 10 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | 8 | 8 | 9 | 10 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  | Finding values
 |  |  |  | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  | B | C | D | E | F | G | H | I | J | K
 |  | 11 | K | A | B | C | D | E | F | G | H | I | J
 |  | 10 | J | K | A | B | C | D | E | F | G | H | I
 |  | 9 | I | J | K | A | B | C | D | E | F | G | H
 |  | 8 | H | I | J | K | A | B | C | D | E | F | G
 |  |  | Combined formula
 |  |  |  | B | C | D | E | F | G | H | I | J | K
 |  |  | K | A | B | C | D | E | F | G | H | I | J
 |  |  | J | K | A | B | C | D | E | F | G | H | I
 |  |  | I | J | K | A | B | C | D | E | F | G | H
 |  |  | H | I | J | K | A | B | C | D | E | F | G
Spreadsheet: 157011d1337597034-how-to-count-consecutive-columns-dummy-sheet
Sheet: Sheet1

study number | A | B | C | D | E | F | G | H | I | J | K | L | Number of consecutive columns with data
1 | 1 |  | 3 | 4 |  | 7 | 3 | 2 |  | 1 | 1 | 1
2 | 2 |  |  | 5 | 4 |  | 4 | 4 |  | 1 |  | 1
3 |  | 1 |  | 4 |  | 4 | 4 |  | 2 |  | 8
4 | 3 | 5 | 5 | 5 |  | 1 | 1 |  | 3 | 6 |  | 6
5 | 1 | 1 |  |  | 2 |  | 1 |  | 1 | 4 | 5 | 1
I need to fill column N with a count of the number of consecutive columns containing data for each row.
Thanks!
Spreadsheet: 717984d1612938394-determine-duration-hrs-between-previous-occurrence-rounds-log-aligw
Sheet: Count

Monthly Count | Column Labels |  |  |  |  | Weekly Count | Column Labels
Row Labels | [NAME] | Travel [NAME] | (blank) | Grand Total |  | Row Labels | [NAME] | Travel [NAME] | (blank) | Grand Total
(blank) |  |  |  |  |  | (blank)
Jan | 18 | 20 |  | 38 |  | 1/3/2021 - 1/9/2021 | 5 | 6 |  | 11
Feb | 6 | 5 |  | 11 |  | 1/10/2021 - 1/16/2021 | 5 | 5 |  | 10
Grand Total | 24 | 25 |  | 49 |  | 1/17/2021 - 1/23/2021 | 4 | 5 |  | 9
 |  |  |  |  |  | 1/24/2021 - 1/30/2021 | 4 | 4 |  | 8
 |  |  |  |  |  | 1/31/2021 - 2/6/2021 | 5 | 5 |  | 10
 |  |  |  |  |  | 2/7/2021 - 2/13/2021 | 1 |  |  | 1
 |  |  |  |  |  | Grand Total | 24 | 25 |  | 49
Spreadsheet: 161870d1339664901-excel-2007-formula-counting-double-data-entries-as-one-copy-of-count1
Sheet: Countif

 |  |  |  | Data | Counting |  |  |  |  |  |  |  |  | Expected Result
 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 30 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 30 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 60 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 110 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 125 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 125 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 31 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  | 75 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  | 76 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  | 80 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  | 90 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  | 95 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  | 95 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  | 65 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  | 65 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  | 102 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  | 111 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  | 111 |  |  |  |  |  |  |  |  |  | 14
Spreadsheet: 107804d1304958033-formula-to-find-the-nth-value-copy-of-example-1
Sheet: Report

 | Description | Total Sold | Shop 1 Stock | Shop 1 Sold | Shop 2 Stock | Shop [NAME] | Shop 3 Stock | Shop 3 Sold
405 | DRINKS
04235100 | Cola |  | 3 | 5 | 0 | 0 | 0 | 0
04235101 | Lemonade |  | 3 | 5 | 12 | 20 | 106 | 232
04235102 | Orange |  | 0 | 0 | 23 | 32 | 432 | 123
04235103 | Apple |  | 2 | 2 | 43 | 12 | 453 | 168
Spreadsheet: 884740d1734004607-sliding-scale-scoring-function-based-on-time-time_based_scoring
Sheet: Sheet1

Airline | Dep | Arr | Duration | Dep | Arr | Duration | Total | Per person | Airline Quality | TripAdvisor rating | Outbound time | Duration | Inbound  time | Price | Reviews | Total
 | OUTBOUND |  |  | RETURN |  |  |  |  |  |  | SCORING
Qatar/BA | 14:55:00 | 12:05:00 | 14h 10m | 08:10:00 | 17:25:00 | 16h 15m | 2053 | 1026.5 | 7/10 | 4/5
Thai | 01:50:00 | 06:15:00 | 11h 25m | 00:05:00 | 06:40:00 | 13h 35m | 2047.24 | 1023.62 | 6/10 | 4/5
Oman | 20:05:00 | 17:05:00 | 14h 40m | 09:15:00 | 18:25:00 | 16h 10m | 1430 | 715 | 6/10 | 3.5/5
Spreadsheet: andy_zipper__128__DYNEGY-ICE VOL Jun7
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:   All
Instruments:   All
Trade Dates:   Jun-7-01 thru Jun-7-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Jun-07-01 | 104273337 |  | Sold | NG Fin BS, LD1 for GDM | Mich | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 0.17 | USD / MMBtu | 10000 | Daily | 1510000 | MMBtus | [NAME], G
Jun-07-01 | 576832484 |  | Sold | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Mirant Americas Energy Marketing, LP | 1.3 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
Jun-07-01 | 107661352 |  | Bought | NG [NAME], FP | TET ELA | Next Day Gas | Jun-08-01 | Jun-08-01 |  |  |  | AEP Energy Services, Inc. | 3.555 | USD / MMBtu | 5000 | Daily | 5000 | MMBtus | Goodell, S
Jun-07-01 | 811506913 |  | Sold | NG Fin BS, LD1 for GDM | Mich | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 0.1675 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
Jun-07-01 | 165768641 |  | Sold | NG Fin BS, LD1 for IF | Waha | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Aquila Risk Management Corp. | -0.05 | USD / MMBtu | 10000 | Daily | 1510000 | MMBtus | [NAME], E
Jun-07-01   Deals
Spreadsheet: 719479d1613676446-need-to-count-items-in-one-sheet-based-on-searching-for-that-criteria-in-another-sheet-updated-searchtest
Sheet: sale

TICKETS | SOLD | days
54279 | Y | 1
79217 |  | 1
77788 |  | 10
61368 | Y | 8
74268 | Y | 0
77720 |  | 1
50590 |  | 13
78664 | Y | 6
53408 |  | 3
92811 | Y | 7
74475 | Y | 24
89336 |  | 2
60643 |  | 5
Spreadsheet: 814324d1674281249-double-if-plug-y-double-if-001
Sheet: Sheet1

CONEPATL |  | s | 5274 | ACELNOPT
ANTELOPE | g | s | 1042 | AEELNOPT
PANTOFLE |  | s | 5308 | AEFLNOPT
GANTLOPE |  | s | 2918 | AEGLNOPT
ANTIPOLE | r | s | 273 | AEILNOPT
PENTANOL |  | s | 4660 | AELNNOPT
LAPSTONE |  | s | 1785 | AELNOPST
PLEONAST |  | es | 1786 | AELNOPST
POLENTAS |  |  | 1787 | AELNOPST
TOWPLANE |  | s | 5339 | AELNOPTW
TESTTTGS
Spreadsheet: 37858d1235960083-multiple-lookup-vlaues-sample
Sheet: Sheet1

Table array
 |  |  | Quantity
A | 1 | blue | 45
B | 2 | red | 65
C | 3 | green | 46
D | 2 | black | 34
E | 3 | orange | 53
F | 1 | yellow | 55
Lookup value 1
A | 1 | Blue | 45 | Should be returned - using what formula?
D | 2 | Black | 34 | Should be returned - using what formula?
Lookup value 2
A | #### | 1 | 45 | Should be returned - using what formula?
D | #### | 2 | 34 | Should be returned - using what formula?
Lookup value 2
A | Blue | #### | 45 | Should be returned - using what formula?
D | Black | #### | 34 | Should be returned - using what formula?
Spreadsheet: 265877d1379432259-formulae-for-golf-syndicate-problems-x3-below-can-anyone-help-copy-of-summary-sheets
Sheet: Weekly scores 2013

Member |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Guest | Group weekly average
Club H/Cap |  | 11 | 25 | 20 | 15 | 15 | 11 | 15 | 20 | 15 | 23 | 11 | 21 | 15 | 21 | 15 | 20 | 17 | 15 | 16 | 18
Adjusted H/Cap |  | 8 | 25 | 21 | 15 | 15 | 9 | 13 | 20 | 15 | 23 | 11 | 21 | 10 | 22 | 10 | 20 | 17 | 13 | 15 | 18
January | 5 | 25 | 25 |  |  | 24 |  |  |  |  |  | 31 |  | 24 | 31 | 37 |  | 21 |  |  |  | ?
 | 12
 | 19
 | 26
February | 2 | 30 |  | 24 |  | 26 |  |  |  | 24 | 22 | 28 |  |  |  |  |  | 17
 | 9 | 34 |  | 22 |  |  | 31 |  |  |  |  | 23
 | 16 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 | 23 | 30 |  |  |  |  |  |  | 28 |  |  | 35 |  | 35 |  |  |  | 29 |  | 25
March | 2 | 32 |  | 29 |  | 29 |  |  | 37 |  |  |  |  | 29 |  |  | 26 | 31 |  | 33
 | 9
 | 16
 | 23
 | 30 | 33 | 33 | 30 |  | 31 | 29 |  | 35 |  |  |  |  | 35 | 25 | 38 |  | 28 |  | 40
April | 6
 | 13
 | 20 |  |  | 23 |  | 26 | 28 | 30 | 34 | 26 | 37 | 34 |  | 34 | 34 | 31 | 30 | 28 |  | 25
 | 27
May | 4 | 20 |  | 25 |  | 32 | 26 |  | 31 |  |  | 34 | 25 | 36 | 32 | 29 | 22 | 27 | 19
 | 11
 | 18 | 33 |  |  |  | 29 |  |  |  | 32 | 23 | 27 | 23 |  | 32 |  |  | 30 |  | 36
 | 25
June | 1 | 38 | 28 |  |  | 38 |  |  | 22 |  | 34 | 28 | 30 |  | 22 | 35 | 27 | 35 | 30
 | 8 | 32 | 21 |  |  | 24 |  |  |  | 29 |  |  |  |  | 26 |  |  | 29
 | 15 | 28 |  | 22 |  | 29 | 29 |  | 33 |  |  | 29 |  | 29 | 32 | 36 | 19 | 20
 | 22 | 28 | 25 | 24 |  | 25 |  |  | 23 |  |  | 27 |  |  | 24 |  | 16 | 28
 | 29
July | 6
 | 13 |  |  | 23 |  | 28 | 31 |  | 30 | 36 |  |  |  | 39 |  | 37 |  | 35
 | 20
 | 27 |  | 20 | 20 |  | 23 | 29 | 39 |  | 29 |  |  | 32 |  | 28 |  |  | 32 |  |  | 35
August | 3 | 21 | 31 | 23 |  | 35 | 37 |  | 25 |  |  | 27 |  |  | 36 |  | 30 | 29 |  |  | 22
 | 10 | 35 | 33 | 34 |  | 31 | 34 |  |  |  |  |  |  |  | 26 | 40 | 23 | 34
 | 17
 | 24 | 30 |  |  |  | 23 |  | 25 |  |  |  | 31 |  | 36 | 24 | 35 |  | 30 | 39 | 34
 | 31 | 26 | 19 |  |  | 25 |  |  |  |  |  | 32 |  | 37 |  |  |  | 33 |  | 27
September | 7 | 33 | 29 |  |  | 31 | 26 | 28 |  |  |  | 35 | 24 | 35 | 36 | 37 | 28 | 34 |  | 28 | 27
 | 14 | 22 | 22 |  |  | 39 |  |  | 28 |  |  |  |  | 33 | 35 | 29 |  |  |  | 28
 | 21
 | 28
October | 5
 | 12
 | 19
 | 26
November | 2
 | 9
 | 16
 | 23
 | 30
December | 7
 | 14
 | 21
 | 28
Individual Average score for the year
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Imbal
1 | -3728 | -3387 |  | -25
2 | -3766 | -3387 |  | -25
3 | -3707 | -3387 | -4 | -25
4 | -3545 | -3387 |  | -25
5 | -3507 | -1910 | -14 | -25
6 | -3453 | -1910 |  | -25
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
index
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141715.48
2002-03-06 00:00:00
CBS Volume
 |  |  | 61661
Spreadsheet: 791563d1660461326-to-count-consecutive-more-6-days-with-a-result-return-of-yes-or-no-abc-hd
Sheet: Sheet2

 |  | Name | Date |  | Name | Consecutive more 6 days (Y/N)
 |  | ANTHONY AMALAN | 2022-07-03 00:00:00 |  | ANTHONY AMALAN |  |  |  | 44745
 |  | ANTHONY AMALAN | 2022-07-04 00:00:00 |  | RAMASAMI SURESH |  |  | ANTHONY AMALAN | 44746
 |  | ANTHONY AMALAN | 2022-07-04 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44746
 |  | ANTHONY AMALAN | 2022-07-05 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44747
 |  | ANTHONY AMALAN | 2022-07-06 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44748
 |  | ANTHONY AMALAN | 2022-07-07 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44749
 |  | ANTHONY AMALAN | 2022-07-08 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44750
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44751
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44751
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44751
 |  | ANTHONY AMALAN | 2022-07-10 00:00:00 |  |  |  |  | ANTHONY AMALAN | 44752
 |  | RAMASAMI SURESH | 2022-07-03 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44745
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44746
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44746
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44746
 |  | RAMASAMI SURESH | 2022-07-05 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44747
 |  | RAMASAMI SURESH | 2022-07-06 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44748
 |  | RAMASAMI SURESH | 2022-07-07 00:00:00 |  |  |  |  | RAMASAMI SURESH | 44749
Spreadsheet: 676756d1588955775-solved-dependent-dropdown-list-with-subheader-categories-subheaders-and-dropdown-list
Sheet: Sheet1

Company1 |  |  | Company2
ADDRESS | EMPLOYEES | EMPLOEMAILS | ADDRESS | EMPLOYEES | EMPLOEMAILS
Address1 | Employee1 | emplemail1 | Rua Maplewood | Priscilla | priflourenco
Address2 | Employee2 | emplemail2 | [NAME] | Priscilla | priscilla.burt
Company | Company1
ADDRESS
EMPLOYEES
EMPLOEMAILS
Spreadsheet: 844331d1696057322-how-to-calculate-bonus-based-on-year-of-service-bonus
Sheet: Anniversary

[NAME] | Start Date | Service Length | Call Date | [NAME]
Adam | 2022-10-01 00:00:00
[NAME] | 2023-07-18 00:00:00
Carrie | 2008-11-21 00:00:00
Cammy | 2021-11-15 00:00:00
[NAME] | 2023-09-04 00:00:00
Dawn | 2021-01-04 00:00:00
[NAME] | 2020-10-01 00:00:00
Spreadsheet: 300078d1393370055-single-formula-for-counting-in-the-range-lookup-formula-date-to-season
Sheet: Sheet1

Date | Season | Single Formula |  |  | Date | Season
 |  |  |  |  | 41629 | Winter
 |  |  |  |  | 41718 | Spring
 |  |  |  |  | 41811 | Summer
 |  |  |  |  | 41904 | Fall
 |  |  |  |  | 41994 | Winter
Spreadsheet: 708808d1608036456-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: For Internet Help

 |  |  |  |  |  | Monday
Jake |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02
Liam |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_04, 2675_Mechanism Drive_Guard Bottom_Fit _04
[NAME] |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _05
Background:
Project Overhead: 2675
Project: Mechanism Drive
Components Available: Guard Bottom, [NAME]
Actions: Fit, Weld
Time for action: 00-08 hours
PROJECT OVERVIEW
1 | 2675 |  | EXTRACT NUMERICAL SUM VALUES HERE
1.1 | Mechanism Drive | Term to Search | Fit | Weld
1.1.1 | Guard Bottom
1.1.1.1 | Fit |  | Should read: 11 (02+04+05) | Should read: 04
1.1.1.2 | Weld
1.1.2 | Guard Top
1.1.2.1 | Fit
1.1.2.2 | Weld
Spreadsheet: 795923d1663007050-sum-formula-for-same-cell-on-multiple-tabs-book1
Sheet: Monthly Totals

Warehouse Door Utilization Report - Monthly Totals Form |  |  |  |  |  |  |  |  |  | Number of days worked during the month:
Door # | 1st Shift Moves | 2st Shift Moves | BCA/292 | Actual Output | Design  Capacity | Effective  Capacity | Capacity  Utilization | Efficiency
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
32
Totals
Spreadsheet: 185791d1349839047-random-pairs-that-ignore-absent-students-random-pairs
Sheet: Sheet1

 |  | Names for Teams |  | [NAME]() | RANK | DESC RANK
 | 1 | a |  | 0.8678160070549477 | 4 |  |  | Team 1 |  | m
 | 2 | b |  | 0.03183788207606153 | 19 | m |  | Team 2 | l | a
 | 3 | c |  | 0.8309930844440782 | 9 | l |  | Team 3 | d | e
 | 4 | d |  | 0.8580211694700585 | 5 | a |  | Team 4 |  | s
 | 5 | e |  | 0.8515235867604268 | 6 | d |  | Team 5 | c
 | 6 |  |  | 0.8415882247445072 | 7 | e |  | Team 6 | t | n
 | 7 |  |  | 0.1030737070929343 | 16 |  |  | Team 7 | k | q
 | 8 |  |  | 0.5952380342333368 | 10 | s |  | Team 8 | p
 | 9 |  |  | 0.9887931463459213 | 1 | c |  | Team 9 | o
 | 10 |  |  | 0.0631109147681106 | 18 |  |  | Team 10 | b | r
 | 11 | k |  | 0.377017811720685 | 13 | t
 | 12 | l |  | 0.8680978175259377 | 3 | n
 | 13 | m |  | 0.9121647390786206 | 2 | k
 | 14 | n |  | 0.4056413781806002 | 12 | q
 | 15 | o |  | 0.09601547005148459 | 17 | p
 | 16 | p |  | 0.1079400782642466 | 15
 | 17 | q |  | 0.2404584882623588 | 14 | o
 | 18 | r |  | 0.01603262123596338 | 20
 | 19 | s |  | 0.8386140399586125 | 8 | b
 | 20 | t |  | 0.5614471894198411 | 11 | r