tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7787__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 17th = 50,000
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he 7 | 08:00:00 |  | 0 | 0 | 0 | 254 | 6.5
he8 | 09:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he9 | 10:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he10 | 11:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he11 | 12:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he12 | 13:00:00 |  | 0 | 0 | 0 | 485 | 6.5
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he14 | 15:00:00 |  | 0 | 0 | 0 | 485 | 6.5
he15 | 16:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he16 | 17:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he17 | 18:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he18 | 19:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he19 | 20:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he20 | 21:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he21 | 22:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he21 | 23:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he22 | 00:00:00 |  | 0 | 0 | 0 | 484 | 6.5
he23 | 01:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he24 | 02:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he1 | 03:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he2 | 04:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he3 | 05:00:00 |  | 0 | 0 | 0 | 234 | 6.5
he4 | 06:00:00 |  | 0 | 0 | 0 | 234 | 6.5
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 234 | 6.5
Spreadsheet: 796673d1663432130-how-to-display-remaining-values-referenced-in-the-row-associated-of-the-targeted-value-s666-pq-test4
Sheet: Feuil1

Country | Bank | Code bank | Name agency | Other | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 |  |  | Other 5
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba5 | azqffgds |  |  | daba11
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | [NAME] | azqffgds |  |  | daba12
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba7 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba8 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba9 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba10 | azqffgds
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
expected result
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
Country | Bank | Code bank | Name agency | Other | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
Spreadsheet: 841972d1694085060-index-match-help-index-match-example-ans
Sheet: Submission Template - Detail

 | 2.2 xxxx |  |  |  |  |  |  |  |  |  |  | A% | B% | C% | Total Staff
 |  | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 |  |  |  |  |  |  |  | [NAME] column P for Number.
 | Service Line 1
 | A | 100
 | B | 80
 | C | 70
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 2
 | A | 90
 | B | 70
 | C | 60
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 3
 | A | 80
 | B | 40
 | C | 30
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 4
 | A | 140
 | B | 150
 | C | 100
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 5
 | A | 80
 | B | 40
 | C | 30
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 6
 | A | 100
 | B | 70
 | C | 60
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 7
 | A | 80
 | B | 40
 | C | 30
 | Total Staff
 | A%
 | B%
 | C%
 | Service Line 8
 | A | 80
 | B | 40
 | C | 30
 | Total Staff
 | A%
 | B%
 | C%
 | Total
 | A
 | B
 | C
 | Total Staff
 | A%
 | B%
 | C%
Spreadsheet: 89439d1289236438-data-validation-link-to-pivot-automatically-update-dummy
Sheet: Summary

 |  |  |  |  |  |  |  |  | Date
Date: | 2010-10-01 00:00:00 |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-02 00:00:00
Supervisor | # of Agents |  |  |  |  |  |  |  | 2010-10-03 00:00:00
Beck, Julienne |  |  |  |  |  |  |  |  | 2010-10-04 00:00:00
[NAME], [NAME] |  |  |  |  |  |  |  |  | 2010-10-05 00:00:00
[NAME], [NAME] |  |  |  |  |  |  |  |  | 2010-10-06 00:00:00
Colton, [NAME] |  |  |  |  |  |  |  |  | 2010-10-07 00:00:00
Eby, Azurdee |  |  |  |  |  |  |  |  | 2010-10-08 00:00:00
England, [NAME] |  |  |  |  |  |  |  |  | 2010-10-09 00:00:00
Ensign, [NAME] |  |  |  |  |  |  |  |  | 2010-10-10 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-11 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-12 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-13 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-14 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-16 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-17 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-18 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-19 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-20 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-21 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-23 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-24 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-25 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-26 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-27 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-28 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-30 00:00:00
 |  |  |  |  |  |  |  |  | 2010-10-31 00:00:00
Spreadsheet: 63033d1264001379-auto-sort-pool-league-player-data
Sheet: Sylvain Mercier

 |  | Ligue de Billard De Cowansville
 |  | Points | Mon pointage | Pos. | Résultats | Pos. | Résultats | Pos. | [NAME]
 |  | Aujourdui | Aujourdui | Avant Noël |  | Après Noël
 | Joueurs |  |  |  |  |  |  | Pourcentage actuel
1 |  |  | Partie [NAME] = 2 pts
2 |  |  | Partie Perdue = 1 pts
3
4
5
6
7
8 |  | * * * * *
9
10
11
12
13
14 |  |  | Total Possible
15 |  |  | de la journée
16
17
18
19
20
21
22
23
24
25
Spreadsheet: b4701d33-16cf-435d-a8c2-53983bf0f49b
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
EUCL | Test | EUCL | Eucalyptus, IgE | Eucalyptus, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EUCL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EUCL | Result | EUCL | Eucalyptus, IgE | Eucalyptus, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6113-5
Spreadsheet: 104284d1301931298-how-to-make-excel-do-multiple-calculations-summer-11-pell-calculator-tester-
Sheet: DATA

Last | First | ID | EFC yr 1 | EFC yr 2 | Summer Credits | Fall Credits | Winter Credits | Spring Credits | Yr 1 Pell Used |  | [NAME] | Year
Smith | [NAME] | 900000001 | 0 | 50 | 5 | 12 | 0 | 12 | 5550
[NAME] | [NAME] | 900000002 | 5 | 150 | 6 | 0 | 0 | 9 | 2082
Jones | [NAME] | 900000003 | 0 | 0 | 9 | 9 | 0 | 9 | 4163
Spreadsheet: 16050b2a-bbd4-4e90-aed7-e8582f48be27
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Spanish
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 841683d1693855044-assign-two-fixed-values-randomly-in-a-column-fixed-values-in-random-rows
Sheet: Sheet1

 |  | Probability
Value 1 | 0.15 | 0.8
Value 2 | 0.4
Test:
Row # | Data
1 | 0.15
2 | 0.4
3 | 0.15
4 | 0.4
5 | 0.15
6 | 0.15
7 | 0.15
8 | 0.15
9 | 0.4
10 | 0.4
11 | 0.15
12 | 0.15
13 | 0.15
14 | 0.15
15 | 0.15
16 | 0.15
17 | 0.15
18 | 0.4
19 | 0.15
20 | 0.15
21 | 0.15
22 | 0.15
23 | 0.15
24 | 0.15
25 | 0.4
26 | 0.15
27 | 0.4
28 | 0.15
29 | 0.4
30 | 0.15
31 | 0.15
32 | 0.15
33 | 0.15
34 | 0.15
35 | 0.15
36 | 0.15
37 | 0.15
38 | 0.4
39 | 0.4
40 | 0.15
41 | 0.15
42 | 0.15
43 | 0.15
44 | 0.15
45 | 0.15
46 | 0.15
47 | 0.4
48 | 0.15
49 | 0.15
50 | 0.4
51 | 0.15
52 | 0.15
53 | 0.15
54 | 0.15
55 | 0.15
56 | 0.15
57 | 0.15
58 | 0.4
59 | 0.15
60 | 0.15
61 | 0.15
62 | 0.15
63 | 0.15
64 | 0.4
65 | 0.15
66 | 0.15
67 | 0.4
68 | 0.4
69 | 0.15
70 | 0.15
71 | 0.15
72 | 0.15
73 | 0.15
74 | 0.15
75 | 0.15
76 | 0.4
77 | 0.15
78 | 0.15
79 | 0.15
80 | 0.15
81 | 0.15
82 | 0.15
83 | 0.15
84 | 0.15
85 | 0.15
86 | 0.15
87 | 0.4
88 | 0.15
89 | 0.15
90 | 0.15
91 | 0.15
92 | 0.15
93 | 0.15
94 | 0.15
95 | 0.15
96 | 0.4
97 | 0.4
98 | 0.15
99 | 0.15
100 | 0.15
Spreadsheet: 680937d1591269641-need-formula-mimic-olympic-medal-award-process-olympic-medal-formula
Sheet: Sheet1

Item # | Organization (e.g., US State) | Priority | Need Formula Which Produces Outputs (e.g., Olympic Medal Process) | [NAME]
1 | CA | 1 | 1
2 | CA | 1 | 1
1 | FL | 1 | 1
2 | FL | 3 | 2
3 | FL | 3 | 2
4 | FL | 4 | 4
1 | IN | 1 | 1
2 | IN | 2 | 2
3 | IN | 5 | 3
4 | IN | 5 | 3
5 | IN | 6 | 5
6 | IN | 6 | 5
1 | KS | 1 | 1
2 | KS | 2 | 2
1 | MN | 2 | 1
2 | MN | 2 | 1
1 | NY | 1 | 1
2 | NY | 2 | 2
3 | NY | 3 | 3
4 | NY | 5 | 4
5 | NY | 5 | 4
6 | NY | 5 | 4
7 | NY | 5 | 4
8 | NY | 5 | 4
9 | NY | 6 | 5
10 | NY | 7 | 10
11 | NY | 9 | 11
1 | TX | 5 | 1
2 | TX | 5 | 1
3 | TX | 5 | 1
4 | TX | 5 | 1
5 | TX | 5 | 1
Spreadsheet: lynn_blair__24483__Nicorimb
Sheet: OCT

 | NICOR DAILY IMBALANCE
 | FOR OCTOBER, 2001
 | POI 234 | EAST DUBUQUE |  | DELIVERY
 | SCHEDULE |  | ACTUAL
 | VOLUME |  | VOLUME | VOLUME
DAY | DELIVERY |  | DELIVERY | [NAME] | PERCENT
1 | 235702 |  | 235999
2 | 220534 |  | 222567
3 | 240696 |  | 235377
4 | 240702 |  | 238927
5 | 215609 |  | 216885
6 | 235635 |  | 230753
7 | 235635 |  | 235676
8 | 235635 |  | 233052
9 | 235582 |  | 234030
10 | 238884 |  | 239960
11 | 240701 |  | 240082
12 | 240702 |  | 238639
13 | 212702 |  | 211546
14 | 212702 |  | 223534
15 | 212702 |  | 211498
16 | 225558 |  | 224803
17 | 227446 |  | 225784
18 | 205677 |  | 203950
19 | 225630 |  | 225887
20 | 213608 |  | 212329
21 | 213612 |  | 212474
22 | 213612 |  | 213466
23 | 205652 |  | 202754
24 | 200783 |  | 203645
25
26
27
28
29
30
31
TOTAL
 | DOLLAR VALUE IMBALANCE @2.0535 |  |  |  | ESTIMATE
 | 09/2001 DOLLAR & VOLUME IMBALANCE |  |  | -16800.59 | -6720 | ESTIMATE
 | NET DOLLAR & VOLUME IMBALANCE:
CR = DUE NNG
+ = DUE SHIPPER
Spreadsheet: 824147d1680335861-flag-4th-consecutive-occurrence-of-a-word-count-4-ans
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
magab
magab
magab
magab
magab
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
magab
magab
magab
magab
magab
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: CTG Assets

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | CTG Assets
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 14
+ Entrances |  | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 13 | 1 |  |  | 1 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
Identified Margin
Budget |  | 14.705
$ Coverage
Spreadsheet: 668328d1584738196-extracting-a-list-of-unfulfilled-orders-for-the-week-example-3-index-and-dropdownlist
Sheet: Shop Orders

Shop Orders for this week |  | Yellow
 |  | Green
 |  | select  shop
 |  | select  shop
Week Start | 2020-03-16 00:00:00 | Week Finish
Spreadsheet: 830218d1684803216-distinct-values-based-on-multiple-criteria-distinct-values-based-on-multiple-criteria
Sheet: Sheet1

[NAME] | Include In List | Include In Team A | Include In Team B | Include In Team C |  | List | Team A | Team B | Team C | Cake Makers List
Everyone | Yes | No | No | No
Team A | Yes | No | No | No |  | Team A | [NAME] | Simone | Hugh | Hugh
Team B | Yes | No | No | No |  | Team B | Shane | [NAME] | [NAME] | [NAME]
Team C | Yes | No | No | No |  | Team C |  |  |  | [NAME]
Hugh | Yes | No | No | Yes |  | Dwight |  |  |  | Rachel
[NAME] | Yes | No | Yes | No |  | Hugh |  |  |  | [NAME]
Lilly | No | No | No | No |  | [NAME] |  |  |  | Shane
[NAME] | No | No | No | No |  | [NAME] |  |  |  | Simone
Shane | Yes | Yes | No | No |  | Rachel |  |  |  | [NAME]
Rachel | Yes | Yes | No | No |  | [NAME]
Dwight | Yes | No | No | Yes |  | Shane
[NAME] | No | No | No | No |  | Simone
Simone | Yes | No | Yes | No |  | [NAME]
[NAME] | Yes | No | No | Yes
[NAME] | Yes | No | Yes | No
[NAME] | Yes | Yes | No | No
Yes | January | 1
No | February | 2
 | March | 3
 | April | 4
 | May | 5
 | June | 6
 | July | 7
 | August | 8
 | September | 9
 | October | 10
 | November | 11
 | December | 12
Spreadsheet: 771688d1646795760-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-statistics-2
Sheet: Statistics

Total Tasks
Simple
Medium
Complex
Total Scope
Simple
Intermediate
Complex
Average Tasks Per Project
Simple
Intermediate
Complex
Spreadsheet: 683104d1592489424-combining-3-array-formulas-to-one-collating-from-multiple-sheets-based-on-conditions5
Sheet: Sorted

Name | Phone | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Notes/ Special Reqs | Status | Collection Date | Time | Include
Spreadsheet: 165523d1341256531-variable-print-output-display-as-well-if-possible-example-1
Sheet: Master

Office # |  | Phone Number | Fax Number |  | Last Updated
Region Name (ohio, mid-atlantic, etc) |  | 0 | 0 |  | 2012-06-01 00:00:00
Street Address
City, State ZIP
 |  | Name | Cell Number | Home Number | Vehicle # | Manual 1 | Manual 2
Type 1 Manager
Type 2 Manager
Type 3 Manager
Type 4 Manager
Type 5 Manager
Type 6 Manager
Certified Workman
Administrative Assistant
Regional Administrator
Workman
Scheduler
Document Processer
Control Staff
Installation Technicians | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Measure Technicians | 1
 | 2
 | 3
 | 4
Service Technicians | 1
 | 2
 | 3
 | 4
Other Technicials | 1
 | 2
 | 3
 | 4
[NAME]
Spare Van
Work Van
Trailers | 1
 | 2
 | 3
 | 4
Spreadsheet: 52200d1251902544-combined-count-and-double-if-count-double-if
Sheet: Sheet1

Origin | Destination
16001 | 16006
16001 | 16004 |  |  |  | Destination
16001 | 16004 |  |  |  | 16001 | 16002 | 16003 | 16004 | 16005 | 16006
16001 | 16001 |  | Origin | 16001
16001 | 16003 |  |  | 16002
16002 | 16005 |  |  | 16003
16002 | 16004 |  |  | 16004
16002 | 16001 |  |  | 16005
16002 | 16002 |  |  | 16006
16002 | 16003
16002 | 16006
16002 | 16001
16002 | 16002
16002 | 16006
16003 | 16004
16003 | 16003
16003 | 16001
16003 | 16003
16003 | 16002
Spreadsheet: 699828d1602776603-help-with-extracting-data-from-a-table-example-1
Sheet: Sheet1

 |  |  |  | Main Table
Question |  |  |  | A1 | A2
1 |  | Highest common occuring number (Column A1), ignore 0 and spaces.  In this example id want 1 to display not 0. |  | 1 | 0.13
2 |  | Count of highest common occurring number. (Column A1), ignore 0 and spaces. |  | 2 | 0.14 |  | Example 1 |  |  | Example 2
3 |  | Percent of the highest common occuring number from the total count of the column of [NAME] (ignore 0 and spaces.) Ex 2. |  | 1 | 0.2 |  | A1 | A2
4 |  | Avg score of A2 value, for the highest common occurring number (Column A1).  [NAME]. 1 |  | 0 | 0.45 |  | 1 | 0.13 |  | Total Count Not inc  0 or spaces) | Count of highest  common occurring number. (Column A1) | Percentage of highest common  occurring number from total count.
 |  |  |  | 0 | 0.13 |  | 1 | 0.2 |  | 10 | 7 | 0.7
 |  |  |  | 0 | 0.15 |  | 1 | 0.45
 |  |  |  | 6 | 0.3 |  | 1 | 0.13
 |  |  |  | 0 | 0.4 |  | 1 | 0.15
 |  |  |  | 0 | 0.13 |  | 1 | 0.3
 |  |  |  | 4 | 0.14 |  | 1 | 0.45
 |  |  |  | 0 | 0.2 |  | 1 | 0.3
 |  |  |  | 1 | 0.45
 |  |  |  | 1 | 0.13 |  | Average:
 |  |  |  | 1 | 0.15
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.14
 |  |  |  | 0 | 0.2
 |  |  |  | 1 | 0.45
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.15
 |  |  |  | 1 | 0.3
 |  |  |  | 0 | 0.4
Spreadsheet: 826692d1682169838-data-formatting-example-a
Sheet: Problem

Data
ARTA1
STORE NO. 1
STORE NO. 2
ARTA2
STORE No.5
STORE No.6
STORE No.7
STORE No.8
STORE No.9
STORE No.1
STORE No.2
STORE No.3
ARTA3
STORE No.14
STORE No.15
STORE No.16
STORE No.17
STORE No.18
STORE No.19
STORE No.20
STORE No.5
STORE No.6
STORE No.7
ARTA4
STORE No.1
STORE No.2
STORE No.3
STORE No.4
STORE No.5
STORE No.6
STORE No.7
STORE No.8
STORE No.9
STORE No.10
STORE No.11
STORE [NAME]
STORE No.13
STORE No.14
STORE No.15
STORE No.16
STORE No.17
STORE No.18
STORE No.19
STORE No.20
Spreadsheet: 822963d1679616497-fill-in-between-s-on-left-and-right-in-a-row-excel_forum_example
Sheet: Sheet1

 | Start Date | End Date | Hdcnt/Month |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 | 2023-03-01 00:00:00 | 2023-07-01 00:00:00 | 0.2097142857142857
 | 2023-01-01 00:00:00 | 2023-09-01 00:00:00 | 0.2995918367346939
 | 2023-06-01 00:00:00 | 2023-08-01 00:00:00 | 0.4839560439560439
 | 2023-04-01 00:00:00 | 2023-12-01 00:00:00 | 0.8987755102040815
 | 2023-10-01 00:00:00 | 2023-12-01 00:00:00 | 0.3495238095238095
 | 2023-02-01 00:00:00 | 2023-07-01 00:00:00 | 0.06452747252747253
 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 0.2097142857142857
 |  |  | Is there a calculation or a macro that can identity the zeros between non-zero numbers in a row, then populate them with the numbers to the left and right?
Spreadsheet: 46419d1245289420-lookup-match-list-names-matchteamlistnames
Sheet: W1

 | Need Formula that will look up the team # look under [NAME] that matchs the team number then list the names under the correct team
Team #: | 1 |  |  | Week 1
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
Team #: | 8
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
Team #: | 2 |  |  | Week 1
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Opposing Captain's Signature
Team #: | 9
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 853457d1703318350-pulls-names-from-list-in-order-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Title
 |  |  | 2024-01-07 00:00:00 |  | Employee 1 |  |  |  |  | Employee 1
 |  |  | 2024-01-07 00:00:00 |  | Employee 1 |  |  |  |  | Employee 2
 |  |  | 2024-01-14 00:00:00 |  | Employee 2 |  |  |  |  | Employee 3
 |  |  | 2024-01-14 00:00:00 |  | Employee 2 |  |  |  |  | Employee 4
 |  |  | 2024-01-21 00:00:00 |  | Employee 3 |  |  |  |  | Employee 5
 |  |  | 2024-01-21 00:00:00 |  | Employee 3 |  |  |  |  | Employee 6
 |  |  | 2024-01-28 00:00:00 |  | Employee 4 |  |  |  |  | Employee 7
 |  |  | 2024-01-28 00:00:00 |  | Employee 4 |  |  |  |  | Employee 8
 |  |  | 2024-02-04 00:00:00 |  | Employee 5
 |  |  | 2024-02-04 00:00:00 |  | Employee 5
 |  |  | 2024-02-11 00:00:00 |  | Employee 6
 |  |  | 2024-02-11 00:00:00 |  | Employee 6
 |  |  | 2024-02-18 00:00:00 |  | Employee 7
 |  |  | 2024-02-18 00:00:00 |  | Employee 7
 |  |  | 2024-02-25 00:00:00 |  | Employee 8
 |  |  | 2024-02-25 00:00:00 |  | Employee 8
 |  |  | 2024-03-03 00:00:00 |  | Employee 1
 |  |  | 2024-03-03 00:00:00 |  | Employee 1
 |  |  | 2024-03-10 00:00:00 |  | Employee 2
 |  |  | 2024-03-10 00:00:00 |  | Employee 2
 |  |  | 2024-03-17 00:00:00 |  | Employee 3
 |  |  | 2024-03-17 00:00:00 |  | Employee 3
 |  |  | 2024-03-24 00:00:00 |  | Employee 4
 |  |  | 2024-03-24 00:00:00 |  | Employee 4
 |  |  | 2024-03-31 00:00:00 |  | Employee 5
 |  |  | 2024-03-31 00:00:00 |  | Employee 5
Spreadsheet: 148767d1333550338-conditional-lookup-from-a-list-difficult-formula-needed-sample_ginge_solved
Sheet: Sum

 |  |  |  |  |  |  |  |  |  |  |  | The values highlighted below indicate what I want copied down and across with a formula. They should be drawn from one of the "Holding" sheets, which indicates the leases that the companies hold (ie which lease numbers should have their total listed under each company on this sheet).
 | Tract | 1 | 2 | 3 | 4 | 5
Lease | Fractional Interest | 160 | 160 | 160 | 80 | 80 | Total | Check Total | ABC | DEF | GHI | JKL | MNO | PQR | STU | VWX | Y | Z
1 | 0.5 |  |  |  | 40 | 80 | 120
2 | 0.3125 |  |  | 50 |  |  | 50
3 | 0.05625 |  |  | 9 |  |  | 9
4 | 0.125 |  | 20 |  |  |  | 20
5 | 0.08333333333333333 |  | 13.33333333333333 |  |  |  | 13.33333333333333
6 | 0.08333333333333333 |  | 13.33333333333333 |  |  |  | 13.33333333333333
7 | 0.015625 | 2.5 |  |  |  |  | 2.5
8 | 0.015625 | 2.5 |  |  |  |  | 2.5
9 | 0.03125 |  |  |  | 2.5 |  | 2.5
10 | 0.25 |  | 40 |  |  |  | 40
11 | 0.125 |  | 20 |  |  |  | 20
12 | 0.01041666666666667 |  |  | 1.666666666666667 |  |  | 1.666666666666667
13 | 0.01041666666666667 |  |  | 1.666666666666667 |  |  | 1.666666666666667
14 | 0.01041666666666667 |  |  | 1.666666666666667 |  |  | 1.666666666666667
15 | 0.0625 |  |  | 10 |  |  | 10
16 | 0.0625 | 10 |  |  |  |  | 10
17 | 0.1666666666666667 |  | 26.66666666666666 |  |  |  | 26.66666666666666
18 | 0.015625 |  |  |  | 1.25 |  | 1.25
19 | 0.03125 |  |  | 5 |  |  | 5
20 | 0.5 | 80 |  |  |  |  | 80
21 | 0.09375 |  | 15 |  |  |  | 15
22 | 0.07291666666666667 |  | 11.66666666666667 |  |  |  | 11.66666666666667
23 | 0.0625 |  |  | 10 |  |  | 10
24 | 0.0078125 |  |  | 1.25 |  |  | 1.25
25 | 0.03125 |  |  | 5 |  |  | 5
26 | 0.03125 |  |  | 5 |  |  | 5
27 | 0.00390625 |  |  | 0.625 |  |  | 0.625
28 | 0.00390625 |  |  | 0.625 |  |  | 0.625
29 | 0.0078125 |  |  | 1.25 |  |  | 1.25
30 | 0.0078125 |  |  | 1.25 |  |  | 1.25
31 | 0.03125 |  |  | 5 |  |  | 5
32 | 0.015625 |  |  |  | 1.25 |  | 1.25
33 | 0.0625 |  |  | 10 |  |  | 10
34 | 0.078125 | 12.5 |  |  |  |  | 12.5
35 | 0.0234375 |  |  | 3.75 |  |  | 3.75