tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 292860d1390815893-conditional-formatting-i-think-with-multiple-sheets-example
Sheet: Recieved Product

SERIALNUM1 | Green
SERIALNUM2 | Green
SERIALNUM3 | Green
SERIALNUM4 | Green
SERIALNUM5 | Green
SERIALNUM6 | Green
SERIALNUM7 | Red
SERIALNUM8 | Red
SERIALNUM9 | Green
[NAME] | Green
SERIALNUM11 | Green
SERIALNUM12 | Green
SERIALNUM13 | Green
SERIALNUM14 | Green
SERIALNUM15 | Green
SERIALNUM16 | Red
SERIALNUM17 | Green
This list would have hundreds of serial numbers that are pulled from a report and which box it came from
Spreadsheet: 824828d1680876982-correction-of-the-indirect-timetable-formula-2023-draft-dailykode-
Sheet: TIMETABLE

 |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00
GR. 1 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME WORKED | TOTAL WORKED
 | 1 | 111 | Jhon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 2 | 112 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 3 | 113 | Adalyn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 4 | 114 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 5 | 115 | Beverly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
Spreadsheet: 760624d1640342138-compare-columns-in-one-spreedsheet-in-other-spreedsheet-estat2122-tp1-copy-3-
Sheet: Identificação

TRABALHO PRÁTICO de ESTAT:2021/22
(Não alterar esta folha de cálculo, exceto as células B7-B11 e C7-C11)
 | Colocar o número e nome de todos os elementos
 | do grupo na caixa abaixo [NAME] os dados
 | Número | Nome
 | 1190403 | [NAME]
 | 1190583 | [NAME]
 | 1200599 | [NAME]
 | 4444444
 | 5555555
 | Códigos
 | a
 | b
 | c
OBS. 1 | Os estudantes [NAME] os cálculos excel nos separadores
 | "Res1" - Resposta aos pontos 1.1 e 1.2  do enunciado
 | "Res2" - Resposta ao ponto 2 do enunciado
 | "Res3" - Resposta ao ponto 3 do enunciado
 | "Res4" - Resposta ao ponto 4 do enunciado
 | "Res5" - Resposta ao ponto 5 do enunciado
OBS. 2 | Nos separadores "Amostras NR" e "Amostras TR" constam os dados estatísticos
 | necessários para desenvolver o trabalho prático
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | média
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | delta
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pvalue
Spreadsheet: 218375d1362437353-finding-specific-text-in-a-cell-with-inexact-results-titles
Sheet: data

Chair | Professor | Assistant Professor | Title
 |  |  | Professor and Chair Department of Obstetrics Gynecology, and Women's Health
 |  |  | Staff
 |  |  | Assistant Professor, Obstetrics, Gynecology and Reproductive Sciences
 |  |  | Chair, Obstetrics and Gynecology
 |  |  | Chair of the Department of Obstetrics and Gynecology
 |  |  | [NAME] Professor of Obstetrics and Gynecology Chair, Department of Obstetrics & Gynecology Director, Obstetrics & Gynecology Services
 |  |  | Professor of Maternal/Fetal Medicine
Spreadsheet: 102275d1300231891-ref-on-auto-sort-table-mvcc-season3test2
Sheet: MVCC Season 2 Playoffs

 | RECORDS |  |  |  |  |  |  |  |  |  |  |  |  |  | SEASON  / PLAYOFF RULES
 | BEST SEASON RECORD |  |  | [NAME] Benny 25-5 |  |  |  |  |  |  |  |  |  |  | SEASON START/END |  |  | 1/12/2011  -  2/  /2011
 | MOST GOALS IN SEASON |  |  | [NAME] 102 |  |  |  |  |  |  |  |  |  |  | PLAYERS (7) |  |  | [NAME] [NAME], [NAME]
 | MOST G/A IN SEASON |  |  | Greg (102) [NAME] (93) |  |  |  |  |  |  |  |  |  |  |  |  |  | Seamus, [NAME], [NAME]
 | LEAST G/A IN SEASON |  |  | [NAME] (44) [NAME] (49) |  |  |  |  |  |  |  |  |  |  | PERIOD TIME |  |  | 4 minutes
 | MOST GOALS IN A GAME |  |  | Benny(10) [NAME] (10) |  |  |  |  |  |  |  |  |  |  | SPEED / LEVEL |  |  | Normal / Pro
 | MOST G/\A IN A GAME |  |  | Greg, Seamus,[NAME] (10) |  |  |  |  |  |  |  |  |  |  | PLAYOFF SERIES |  |  | Rounds 1&2 (3) Finals (5)
 |  |  |  |  |  |  |  | SEASON 2 PLAYOFFS
 |  | FRANKIE |  |  |  |  |  | Champion |  |  |  |  |  |  |  |  |  | BENNY
 |  | BYE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BYE
 |  |  |  |  | FRANKIE |  |  |  |  |  |  |  |  |  | BENNY
 |  |  | 8-0 Frank (H) |  |  |  |  | FRANKIE |  |  |  | BENNY |  |  |  | 2-1 OT Benny (H)
 |  |  | 6-0 Frank (A) |  |  |  |  |  |  |  |  |  |  |  |  | 1-0 [NAME] (A)
 |  |  |  |  |  |  |  |  | 2-1 OT Frank (H)
 |  |  |  |  | JAY |  |  |  |  |  |  |  |  |  | ANTHONY
 |  | JAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GREG
 | 5-0 Seamus (H) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-1 Ant (H)
 | 2-1 Jay (H) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-1 Greg (H)
 | 7-4 Jay (H) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5-2 Ant (H)
 |  | SEAMUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANTHONY
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q1 HELEN

HELEN
n | 8 |  | period | net worth at the end of the period |  | Intrinsic
P | 6000 |  | 0
X | 0 |  | 1
F |  |  | 2
rate | 0.015 |  | 3
(1 + rate)^n |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
Spreadsheet: 176762d1346091516-looking-up-different-data-sets-depending-on-option-selected-example2
Sheet: Sheet1

Customer | Department | Product |  | Result
Monday | Vegetables | A
Friday | Fruit | B |  |  |  | Vegetables | A | B | C | D | E | F | G
Thursday | Fresh | C |  |  |  | Monday | 25 | 25 | 25 | 25 | 25 | 25 | 25
Sunday | Frozen | D |  |  |  | Tuesday | 29 | 29 | 29 | 29 | 29 | 29 | 29
Saturday | Fresh | C |  |  |  | Wednesday | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  | F |  |  |  | Thursday | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  | G |  |  |  | Friday | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | Saturday | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | Sunday | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Fruit | A | B | C | D | E | F | G
 |  |  |  |  |  | Monday | 25 | 82 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | Tuesday | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | Wednesday | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | Thursday | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | Friday | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | Saturday | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | Sunday | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Fresh | A | B | C | D | E | F | G
 |  |  |  |  |  | Monday | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | Tuesday | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | Wednesday | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | Thursday | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | Friday | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | Saturday | 18 | 18 | 44 | 18 | 18 | 18 | 18
 |  |  |  |  |  | Sunday | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Frozen | A | B | C | D | E | F | G
 |  |  |  |  |  | Monday | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | Tuesday | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | Wednesday | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | Thursday | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | Friday | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | Saturday | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | Sunday | 46 | 46 | 46 | 46 | 46 | 46 | 46
Spreadsheet: 718025d1612958154-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Names

Student Name | System
Student 1 | System 1
Student 2 | System 6
Student 3 | System 7
Student 4 | System 5
Student 5 | System 8
Student 6 | System 2
Student 7 | System 7
Student 8 | System 3
Student 9 | No System
Student 10 | System 8
Student 11 | System 3
Student 12 | System 10
Student 13 | System 9
Student 14 | System 5
Student 15 | No System
Student 16 | System 8
Student 17 | System 9
Student 18
Student 19
[NAME]
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44024

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44024
Number of cores |  | 4
Spare cores |  | 1
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | Circuit Breaker indication to Transpower
Panel Number | CB6 (Old CC) |  | Panel Number |  | GCB4
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | CB6 (Old CC) | INITIAL | GCB4 | INITIAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes
Edition Notes
Spreadsheet: 105035d1302523775-help-with-a-sumproduct-query-stock-movement-sheet-1
Sheet: Tech Names

Intials | Technican Name | Role Designation
AE | [NAME] | Handyman
AF | [NAME] | Electrician
AM | Alasdair Marshall | Electrician
AZ | [NAME] | [NAME]
BM | [NAME] | [NAME]
[NAME] | Broken Stock
BS | [NAME] | Housekeeping
CARF | Carlisle Refridgeration | Contractor
CH | [NAME] | Handyman
CP | [NAME] | Electrician
CP13B1 | CP 13 Box 1 | Box Stock
CP13B2 | CP 13 Box 2 | Box Stock
CP1B1 | CP 1 Box 1 | Box Stock
CP1B2 | CP 1 Box 2 | Box Stock
CP34B1 | CP 34 Box 1 | Box Stock
CP34B2 | CP 34 Box 2 | Box Stock
CP5B1 | CP 5 Box 1 | Box Stock
CP5B2 | CP 5 Box 2 | Box Stock
CR | [NAME] | Plumber
Cubby DJ | [NAME] | Contractor
CW | [NAME] | Handyman
Del | DELIVERY | Delivery
DM | [NAME] | Manager
FE | [NAME] | Plumber
GB | [NAME] | Handyman
GS | [NAME] | Plumber
JB | [NAME] | PR Tech
[NAME] | [NAME] | Manager
JH | [NAME] | CB Manager
JI | [NAME] | Electrician
JP | [NAME] | IT
JS | [NAME] | Manager
KM | [NAME] | Electrician
KS | [NAME] | Manager
KW | [NAME] | Electrician
LH | [NAME] | Electrician
LODT | Logic [NAME] | Contractor
LOJH | [NAME] | Contractor
MBO | [NAME] | Handyman
MBR | [NAME] | Electrician
MH | [NAME] | Manager
MO | [NAME] | Handyman
PO | [NAME] | Plumber
RB | [NAME] | Grounds
Ret | Stock Returned | Returns
Ret Supp | [NAME] | Con Stock Returned to Supplier
Ret to Supp | Unrequired Stock | Stock returned to [NAME]
RH | [NAME] | Electrician
SA | Stock Adjustment
SA VC | Stock Adjustment VC
SA VIL | Stock Adjustment Lodges
SB | [NAME] | Manager
SC | [NAME] | Electrician
SE | [NAME] | Grounds
Sec | Security | Site Security
SH | [NAME] | [NAME]
SM | [NAME] | Handyman
SMC | [NAME] | IT
SR | [NAME] | Handyman
SRO | [NAME] | Green Room
SW | [NAME] | Technican
TA | [NAME] | Housekeeping
TR | Transfer | Transfer
TS | [NAME] | P/Room Tech
Spreadsheet: 43237d1241803260-pivottables-and-percent-of-total-pivotexample
Sheet: Sample Data

Date | Color | Sum
2009-01-01 00:00:00 | Red | 189
2009-01-01 00:00:00 | Blue | 833
2009-01-01 00:00:00 | Green | 960
2009-02-01 00:00:00 | Red | 505
2009-02-01 00:00:00 | Blue | 28
2009-02-01 00:00:00 | Green | 415
2009-03-01 00:00:00 | Red | 379
2009-03-01 00:00:00 | Blue | 648
2009-03-01 00:00:00 | Green | 719
Spreadsheet: e3c813bd-eaf6-412b-88b7-3d1a3f5062d5
Sheet: Sheet1

B&B Electronics - Isolatori USB | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cod. Interno | Cod. Produttore | Produttore | Descrizione
BB.260.09 | UH401 | B&B Electronics | USB To USB 1 Port Isolator - 4Kv
BB.260.10 | UH401-2KV | B&B Electronics | USB To USB 1 Port Isolator - 2Kv
BB.260.11 | UH401SL | B&B Electronics | USB To USB 1 Port Isolator - 4Kv, Low Speed
BB.260.12 | UH401SL-2KV | B&B Electronics | USB To USB 1 Port Isolator - 2Kv, Low Speed
BB.260.13 | UHR204 | B&B Electronics | USB 4 Port Industrial Hub (non isolato)
BB.260.14 | UHR304 | B&B Electronics | USB 4 Port Up/Down Isolated Hub - 4Kv
BB.266.56 | UHR401 | B&B Electronics | 1 Port Rugged USB Isolator
BB.268.25 | UH201 | B&B Electronics | Compact USB Port Guardian
BB.268.26 | UHR207 | B&B Electronics | 7 Port Non-Isolated USB Hub
BB.268.27 | UHR307 | B&B Electronics | USB 7 Port Up/Down Isolated Hub - 4Kv
BB.268.28 | UHR402 | B&B Electronics | 2 Port Rugged USB Isolator
Spreadsheet: mike_carson__27583__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 18.35 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 16.8571 |  | 1
 | Comed | -100 | 18.5 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 13.25 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
Spreadsheet: 854147d1704120332-return-based-on-group-results-book1
Sheet: Sheet1

Group ID | File_Status | Filename | Group_Status
0 | Good | 0001 | Green
0 | Good | 0001 | Green
0 | Good | 0001 | Green
1 | Good | 0002 | Green
1 | Good | 0002 | Green
1 | Good | 0002 | Green
2 | Good | 0003 | Yellow
2 | Corrupt | 0003 | Yellow
2 | Good | 0003 | Yellow
3 | Good | 0004 | Green
3 | Good | 0004 | Green
3 | Good | 0004 | Green
4 | Corrupt | 0005 | Red
4 | Corrupt | 0005 | Red
4 | Corrupt | 0005 | Red
5 | Good | 0006 | Green
5 | Good | 0006 | Green
5 | Good | 0006 | Green
6 | Corrupt | 0007 | Yellow
6 | Corrupt | 0007 | Yellow
6 | Corrupt | 0007 | Yellow
6 | Good | 0007 | Yellow
Spreadsheet: 92282d1291901335-lookup-for-specific-values-in-multiple-cells-export
Sheet: ItemIngredients

Item | Ingredient | LowerLimit | UpperLimit | LowerSecLimit | UpperSecLimit
3462.01 | [NAME] | 5 | 10 | 0 | 0
DIV4212C | TITANIUM | 0 | 0 | 0.018 | 0.023
122/152 | TITANIUM | 0 | 0 | 0.018 | 0.023
3462.01 | TITANIUM | 0 | 0 | 15 | 20
Spreadsheet: 747778d1631698786-if-formula-based-on-cell-color-parkingslot
Sheet: Sheet1

PARKING | 2021-10-03 00:00:00 | 2021-10-04 00:00:00 | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2021-10-07 00:00:00
1 | A | A | A | A | A
2 | B | B | B
3 | C | C | C | C | C
4 | D | D | D | D | D
5 | E |  |  | E | E
6 | F | F | F | F | F
7 | G | G | G | G | G
1ST priority
H
Spreadsheet: 0ebea137-e47c-41bf-b4d5-e23aa5283e06
Sheet: Table 5

TABLE 5
TAX FORGIVENESS BY COUNTY - 2010
(Money amounts are in thousands of dollars)
 | TOTAL NUMBER OF | FORGIVENESS | TOTAL | TAXABLE
COUNTY | TAX RETURNS | AMOUNT | INCOME | INCOME
TOTALS-ALL RETURNS | 1410177 | 316703 | 11736085 | 11413527
OUT-OF-STATE | 52405 | 10279 | 485136 | 370618
PENNSYLVANIA | 1357772 | 306424 | 11250949 | 11042908
ADAMS | 11011 | 2572 | 94650 | 92737
ALLEGHENY | 124437 | 24488 | 908340 | 887936
ARMSTRONG | 9158 | 1930 | 71171 | 69746
BEAVER | 20366 | 4074 | 151410 | 147180
BEDFORD | 6399 | 1605 | 58240 | 57480
BERKS | 46887 | 11062 | 404175 | 397480
BLAIR | 16043 | 3606 | 132012 | 129796
BRADFORD | 7528 | 1762 | 65654 | 64344
BUCKS | 52580 | 10604 | 396034 | 386877
BUTLER | 18279 | 3667 | 136880 | 133362
CAMBRIA | 19157 | 3678 | 135788 | 132502
CAMERON | 781 | 166 | 6058 | 5921
CARBON | 8121 | 1686 | 61896 | 60587
CENTRE | 11059 | 2342 | 86680 | 84305
CHESTER | 35137 | 8432 | 310263 | 303857
CLARION | 4847 | 1041 | 38489 | 37626
CLEARFIELD | 10612 | 2348 | 86122 | 84661
CLINTON | 4641 | 1070 | 39033 | 38398
COLUMBIA | 7510 | 1571 | 58386 | 57141
CRAWFORD | 11520 | 2807 | 101596 | 99771
CUMBERLAND | 23097 | 4621 | 172638 | 167815
DAUPHIN | 29752 | 6704 | 244908 | 240401
DELAWARE | 50572 | 11491 | 425077 | 417928
ELK | 4314 | 847 | 31498 | 30707
ERIE | 35759 | 8005 | 291845 | 286568
FAYETTE | 18689 | 4059 | 148422 | 145805
FOREST | 778 | 143 | 5315 | 5166
FRANKLIN | 17704 | 4237 | 156007 | 152570
FULTON | 1792 | 419 | 15461 | 15237
GREENE | 4055 | 887 | 32710 | 32136
HUNTINGDON | 5585 | 1272 | 46375 | 45828
INDIANA | 10540 | 2256 | 82484 | 81031
JEFFERSON | 6697 | 1527 | 55205 | 54342
JUNIATA | 2983 | 799 | 29133 | 28597
[NAME] | 25294 | 5447 | 200146 | 195955
LANCASTER | 55293 | 14855 | 539959 | 530493
[NAME] | 11757 | 2572 | 93690 | 92105
LEBANON | 16166 | 3783 | 137971 | 135272
LEHIGH* | 41138.8117 | 9304 | 342018 | 335050
LUZERNE | 39629 | 8466 | 311508 | 305203
LYCOMING | 14439 | 3173 | 117251 | 115169
MCKEAN | 5568 | 1146 | 42195 | 41380
MERCER | 15188 | 3302 | 120883 | 118484
MIFFLIN | 6510 | 1667 | 59889 | 59129
MONROE | 17167 | 4041 | 150717 | 147872
MONTGOMERY | 61759 | 12625 | 471709 | 461188
MONTOUR | 2128 | 445 | 16486 | 16065
NORTHAMPTON* | 31029.1883 | 6328 | 236755 | 231103
NORTHUMBERLAND | 12293 | 2653 | 97583 | 95523
PERRY | 5059 | 1255 | 45358 | 44529
PHILADELPHIA | 168137 | 47777 | 1714831 | 1702655
PIKE | 5907 | 1283 | 47920 | 46900
POTTER | 2363 | 543 | 20429 | 19968
SCHUYLKILL | 18245 | 3754 | 138291 | 135244
SNYDER | 4777 | 1228 | 44463 | 43678
[NAME] | 10229 | 2159 | 79782 | 78211
SULLIVAN | 893 | 177 | 6491 | 6357
SUSQUEHANNA | 5201 | 1218 | 45381 | 44530
TIOGA | 5136 | 1128 | 42788 | 41614
UNION | 4215 | 1058 | 38498 | 37815
VENANGO | 7433 | 1610 | 58735 | 57617
WARREN | 5538 | 1146 | 42276 | 41350
WASHINGTON | 23501 | 4578 | 169594 | 165873
WAYNE | 6743 | 1441 | 53307 | 51970
WESTMORELAND | 42258 | 7890 | 292936 | 285994
WYOMING | 3466 | 789 | 29471 | 28977
YORK | 44922 | 9806 | 361685 | 353793
*  Includes a representative share of the city of Bethlehem
Spreadsheet: 421e2d2a-0b07-45ae-9f74-0d781f02e43d
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
ØSTLIE TRANSPORT AS |  | 2640 | Vinstra
PER KOLLOEN TRANSPORT |  | 2642 | Kvam
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: DEN-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 3274023 | 8606573
2 |  | Liquidations
3 |  | Interdesk | 4456107 | 12231109
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 7730130 | 20837682
 | Purchases:
6 |  | 3rd Party / Inter Enron | -4504895 | -11360865
7 |  | Liquidations
8 |  | Interdesk | -3275375 | -8961759
9 |  | Option Premiums
10 |  | [NAME] | 12053 | 31740
 | Total Purchases: |  | -7768217 | -20290884
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -222 | -55
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -1 | 0
 | Total Imbalances: |  | -223 | -55
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 38310 | 97022.49788920008
23 | Fuel: |  | -12053 | -31740
 | Transport Expense:
24 |  | Commodity | 0 | -208859.95
25 |  | Demand | 0 | -388272.97
 | Total Transport Expense: |  | 0 | -597132.92
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0.03999999980442226
31 |  | Prior Month Book Balance | 0 | 186016
 |  | Total MTM Income | 0 | 186016.04
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -1376
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-Denver
 |  | Current Month MTM | 0 | -242499 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 134583d1325494535-help-needed-for-total-formula-master-bill
Sheet: Cost

Table Array
 | SUNDAY VALUES | SATURDAY VALUES | WEEKDAY VALUE
Value 1 | 1.5 | 1.5 | 1.2
Value 2 | 1.2 | 1.2 | 1.2
Value 3 | 2 | 1.5 | 1.5
Value 4 | 2 | 1.5 | 1.5
Value 5 | 1 | 1 | 1
Value 6 | 1.3 | 1.3 | 1.3
Value 7 | 1.3 | 1.3 | 1.3
Value 8 | 1.3 | 1.3 | 1.3
Value 9 | 1 | 1 | 1
Value 10 | 1.5 | 1.3 | 1.3
Value 11 | 1.5 | 1.3 | 1.3
Value 12 | 1.5 | 1.3 | 1.3
Spreadsheet: 816931d1675896123-help-with-formula-to-find-index-of-part-of-a-string-from-an-array-example-sieve-array
Sheet: Sheet1

125mm - Retained Mass (g)
100mm - Retained Mass (g)
75.0[NAME] (g)
63.0mm - Retained Mass (g)
53.0[NAME] (g)
37.5mm - Retained Mass (g)
26.5mm - Retained Mass (g)
19.0mm - Retained Mass (g)
16.0mm - Retained Mass (g)
13.2mm - Retained Mass (g)
9.5mm - Retained Mass (g) | 0
6.7mm - Retained Mass (g) | 0.8
4.75mm - Retained Mass (g) | 1.4
2.36mm - Retained Mass (g) | 101.5
1.18mm - Retained Mass (g) | 86.7
600µm - Retained Mass (g) | 43.9
300µm - Retained Mass (g) | 32.1
150µm - Retained Mass (g) | 24.6
75µm - Retained Mass (g) | 6.8 | WHAT I WANT HELP WITH:
Split1Sieve | 4-75MM | 1.Need to replace string "4-75MM" as 4.75mm 2.Find the index of the array (A1:A19) which contains the string 4.75mm - so in this example the index should be returned as 13
Split2Sieve | NONE
Split1Sieve Index | 13 | Replace 13 in Cell B22 with the correct formula