tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 687597d1595305606-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated1
Sheet: Data Collection 

Rejections
Assessment Date | Assessed By | Product: | Type / Variety: | Class: | Packed On: | Receival Temp: | Qty Received | Quantity Rejected | Unit Of Measurement | Defect | [NAME] | MAJOR | MINOR | No. Products With Defects | No. Products With Defects | Total Units Assessed | Total % Out of Spec | Total % Out of Spec | No Cartons used for Assessment | Quantity Rejected | Grower: | Comments:
Spreadsheet: 842417d1694507051-formula-to-determine-of-years-with-a-purchase-for-each-customer-count-of-years-purchasing
Sheet: Sheet1

PersonID | FirstName | PurchaseDate | Price
235 | [NAME] | 2005-06-15 00:00:00 | 86 |  |  | 8
234 | Amber | 2005-06-15 00:00:00 | 212 |  | Amber | 8
235 | [NAME] | 2006-06-21 00:00:00 | 20 |  | [NAME] | 5
234 | Amber | 2006-06-21 00:00:00 | 43 |  | Bettie | 5
235 | [NAME] | 2007-05-18 00:00:00 | 195
234 | Amber | 2007-05-18 00:00:00 | 98
123 | [NAME] | 2008-11-21 00:00:00 | 27
124 | Bettie | 2008-11-21 00:00:00 | 48
123 | [NAME] | 2008-12-15 00:00:00 | 127
124 | Bettie | 2008-12-15 00:00:00 | 228
235 | [NAME] | 2009-06-21 00:00:00 | 68
234 | Amber | 2009-06-21 00:00:00 | 194
123 | [NAME] | 2010-03-15 00:00:00 | 18
124 | Bettie | 2010-03-15 00:00:00 | 81
235 | [NAME] | 2010-05-18 00:00:00 | 161
234 | Amber | 2010-05-18 00:00:00 | 198
123 | [NAME] | 2011-04-21 00:00:00 | 228
124 | Bettie | 2011-04-21 00:00:00 | 85
235 | [NAME] | 2012-04-15 00:00:00 | 154
234 | Amber | 2012-04-15 00:00:00 | 118
123 | [NAME] | 2012-05-15 00:00:00 | 199
124 | Bettie | 2012-05-15 00:00:00 | 84
235 | [NAME] | 2013-04-25 00:00:00 | 88
234 | Amber | 2013-04-25 00:00:00 | 43
235 | [NAME] | 2014-04-18 00:00:00 | 37
234 | Amber | 2014-04-18 00:00:00 | 153
123 | [NAME] | 2016-05-21 00:00:00 | 107
124 | Bettie | 2016-05-21 00:00:00 | 25
Spreadsheet: 165729d1341328312-conidtional-formatting-across-columns-0aconditional-format-example
Sheet: Sheet1

 |  |  |  |  | col
col7 | [NAME] | 40000
hed2 | ton | 4000
apl1 | bike | 5362
col5 | apple | 3180
col5 | apple | 2818
scv3 | rome | 3000
hed4 | cake | 7878
scv3 | rome | 343
scv5 | take | 34342
apl2 | orange | 3434
Spreadsheet: 5f0373c1-e458-4a39-9e53-b39e7f05097c
Sheet: Sheet1

STATE SENATE DISTRICT NO. 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2000-11-07 00:00:00 | Burns, r | [NAME], d | [NAME]
Atkinson & Gilmanton Academy Grant | 0 | 0
Bean's Grant | 0 | 0
Bean's Purchase | 0 | 0
[NAME] | 327 | 673
[NAME] | 385 | 658
[NAME] 3 | 495 | 767 | 1
[NAME] 4 | 303 | 603 | 2
Bethlehem | 454 | 601 | 3
Cambridge | 1 | 0
Carroll | 241 | 175
[NAME]'s Purchase | 0 | 0
[NAME] | 72 | 36
Colebrook | 537 | 265
Columbia | 166 | 91
Crawford's Purchase | 0 | 0
Cutt's Grant | 0 | 0
[NAME] | 264 | 132
Dix's Grant | 0 | 0
Dixville | 25 | 1
Dummer | 105 | 67
Errol | 108 | 43
Erving's Location | 0 | 0
Franconia | 306 | 293 | 1
[NAME] | 580 | 824 | 1
Green's Grant | 0 | 0
Hadley's Purchase | 0 | 0
[NAME] | 355 | 159
Kilkenny | 0 | 0
Lancaster | 898 | 600
Lisbon | 356 | 233 | 1
Littleton | 1267 | 1214 | 4
Low & Burbank's Grant | 0 | 0
Martin's Location | 0 | 0
Milan | 331 | 281
[NAME] | 10 | 0
Northumberland | 475 | 476 | 2
[NAME] | 0 | 0
[NAME]'s Grant | 0 | 6
Pittsburg | 308 | 128
Randolph | 100 | 134
Sargent's Purchase | 0 | 0
Second College Grant | 0 | 0
Shelburne | 126 | 86
[NAME] | 137 | 105
Stewartstown | 199 | 96
[NAME] | 131 | 125
Success | 0 | 0
[NAME] | 172 | 196 | 1
Thompson & Meserve's Purchase | 0 | 0
Wentworth's Location | 9 | 7
[NAME] | 635 | 345 | 1
Totals | 9878 | 9420 | 17
Spreadsheet: 32935d1229098073-how-do-i-give-columns-a-value-and-calculate-the-total-of-the-highlighted-cells-calchrsworked
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
Spreadsheet: 687492d1595250157-extract-date-in-middle-test-sum-date
Sheet: Sheet1

 |  |  |  |  | SUM CONDITION DATE & DES | HANWORTH | WATFORD | BROCKLE
 |  |  | date extract |  | date | sum | sum | sum
BROCKLE CARD TXNS 290520 /SREF/020397 | 30 |  |  |  | 270520
HANWORTH DUALITY-E 270520 /SREF/123750 | 20 |  |  |  | 290520
[NAME] /SREF/020121 | 40 |  |  |  | 300520
HANWORTH DUALITY-E 270520 /SREF/123750 | 15 |  |  |  | 040620
BROCKLE CARD TRAN 040620 /SREF/010234 | 50
Spreadsheet: louise_kitchen__22843__Hot List Update 06-25-01
Sheet: E-Commerce -50

Deal Description Sheet - 6/25/01
[NAME]
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Andex | Andex | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement & accounting. | 50000 | 2001-05-22 00:00:00 | 0.2 | 2001-06-01 00:00:00 | ATS will close in June 2001.  ENA will close in June 2001.
[NAME] | EOTT | Back office accounting services. | *$500,000 | 2001-05-14 00:00:00 | 0.25 | 2001-10-01 00:00:00 | EOTT met HMS in mid-June.
[NAME] | Pure Resources | Integrated outsourcing products. | *$250,000 | 2001-06-11 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Meeting  with Pure Sr. Management scheduled for June 29th.
Gather Company | Gather Company | Monetization and metering services. | 200000 | 2001-05-10 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Follow up meeting in June, 2001.
Running Man | Marathon | Integrated outsourcing products. | *$1,000,000 | 2001-06-11 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Meeting in July.
Callon | Callon | Outsourcing | 100000 | 2001-06-19 00:00:00 | 0.1 | 2001-10-01 00:00:00
 |  |  |  |  |  |  | *Accrual
Spreadsheet: 136638d1326752663-auto-populate-work-order-forms-from-different-sheet-example
Sheet: New Generator

Date Called | Time | Employee | Report Provided | Return Call by | Appt Req'd | Service Date | Time | Company | Hours of operation
JAN 10 2012 | 09:00:00 | DP | NO | . | . | JAN 13 2012 | AM | SAFETY BOSS | .
Days of Operation | Contact | Acct Number | Acct Status | PO Req'd | Address |  | PO # | Payment Type | City | Province
. | AFSANEH | S0618 | CHARGE | NO | 2501 ALYTH ROAD SE |  | . | CHARGE | CALGARY | AB
Postal Code | Card Number | Exp | Phone | Cell | Job Number | Fax | [NAME] | Jobsite Address | Alternate Contact | Phone
. | . | . | [PHONE] | . | . | . | . | . | . | .
Last Service | Service Due | City Section | Information
JUNE 2010 | JUNE 10TH 2011 | SE1 | CHECK TO SEE IF THIS IS A MOVE OR A NEW BUILDING IN ADDITION TO THEIR DOWNTOWN LOCATION
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6 | -29789 | -29869 | -64157 | -63430
7 | -29899 | -29869 | -83960 | -83430
8 | -10720 | -10152 | -104080 | -104207
9 | -14972 | -15000 | -57592 | -56846
10 | -14997 | -15000 | -93909 | -93216
11 | -613 |  | -79398 | -78955
12 | -5137 | -5000 | -58921 | -59382
13 | -5527 | -5000 | -59922 | -59382
14 | -5814 | -5000 | -57766 | -57060
15 |  |  | -88029 | -87799
16 | -4789 | -4155 | -81538 | -80882
17 | -22716 | -22154 | -91857 | -91315
18 | -324 |  | -65366 | -64929
19 |  |  | -70622 | -72649
20 |  |  | -72881 | -72649
21 |  |  | -61292 | -62649
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9676
2002-01-21 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: 696011d1600540006-formula-to-sort-names-of-people-over-or-under-a-certain-number-help-sort
Sheet: Sheet1

Name | Score | Top performers | [NAME]
[NAME] | 0.95
jen | 1.2
caroline | 1.12
brittney | 0.97
andie | 1.02
skye | 0.28
rebecca | 0.7
joan | 0.65
Spreadsheet: 229501d1366407981-copying-values-in-filtered-cells-sample-2-
Sheet: Sheet1

Student Data
Sr No. | Roll No. | Name | Maths Grade | Maths | Science Grade | Science
1 | 1 | [NAME] |  | Register
2 | 2 | [NAME] |  |  |  | Register
3 | 3 | [NAME] |  | Register
4 | 4 | Manjaly |  |  |  | Register
5 | 5 | Sameer
6 | 6 | [NAME] |  | Register |  | Register
7 | 7 | Arup
8 | 8 | Naran |  | Register
 |  |  |  |  |  |  |  | Grades
 |  |  |  |  |  |  |  | Name of the student | Grade
 |  |  |  |  |  |  |  | [NAME] | AA
 |  |  |  |  |  |  |  | [NAME] | AB
 |  |  |  |  |  |  |  | [NAME] | BC
 |  |  |  |  |  |  |  | Naran | DD
Spreadsheet: 27608d1220990374-compare-two-excel-files-email1
Sheet: Sheet1

Master List | [NAME] |  |  |  |  |  |  | Pasted After Autofiltering Col C with NonBlanks
Email 1 | Email 22 | Email 1 |  |  |  |  |  | Email 1
[NAME] | Email 7 |  |  |  |  |  |  | [NAME]
[NAME] | [NAME] 13 | [NAME] |  |  |  |  |  | Email 5
[NAME] | [NAME] 18 |  |  |  |  |  |  | [NAME] 10
Email 5 | [NAME] | Email 5 |  |  |  |  |  | [NAME] 12
Email 6 | Email 23 |  |  |  |  |  |  | [NAME] 14
Email 7 | Email 6 |  |  |  |  |  |  | [NAME] 15
[NAME] | Email 19 |  |  |  |  |  |  | Email 17
[NAME] 9 | [NAME] 9 |  |  |  |  |  |  | Email 21
[NAME] 10 | Email 29 | [NAME] 10 |  |  |  |  |  | Email 25
[NAME] 11 | [NAME] |  |  |  |  |  |  | [NAME] 26
[NAME] 12 | [NAME] 11 | [NAME] 12 |  |  |  |  |  | Email 28
[NAME] 13 | [NAME] 24 |  |  |  |  |  |  | [NAME] 30
[NAME] 14 | [NAME] 27 | [NAME] 14 |  |  |  |  |  | Email 31
[NAME] 15 | [NAME] 16 | [NAME] 15
[NAME] 16 | [NAME] 20
Email 17 | [NAME] | Email 17
[NAME] 18
Email 19
[NAME] 20
Email 21 |  | Email 21
Email 22
Email 23
[NAME] 24
Email 25 |  | Email 25
[NAME] 26 |  | [NAME] 26
[NAME] 27
Email 28 |  | Email 28
Email 29
[NAME] 30 |  | [NAME] 30
Email 31 |  | Email 31
Spreadsheet: 288847d1389318133-consolidate-multiple-worksheets-into-one-reference-cover-sheet-excel-forum
Sheet: Cover Sheet

Name | Employee Number | Subbie Number | Invoice Created
TOM | 12388 | 2615 | YES
[NAME] | 12000 | 9634 | YES
NED | 12609 | 20076 | YES
FRED | 12001 | 20058 | NO
Spreadsheet: 693898d1599210599-formula-to-get-data-with-dates-in-columns-and-multiple-criteria-data-lookup
Sheet: Sheet1

Branch | Product | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00
NP000018 | A | 3 | 26 | 18 | 24 |  |  | 22 | 15
NP000018 | B | 2 | 12 | 16 | 14 |  |  | 12 | 13
NP000018 | C |  |  |  |  |  | 11
NP000018 | D |  |  |  |  | 13
NP000018 | E
NP000018 | F |  |  |  |  |  | 1
NP000018 | G |  |  |  |  | 12
NP000001 | A | 1 | 56 | 53 | 62 | 2 |  | 68 | 60
NP000001 | B |  | 13 | 16 | 11 |  |  | 6 | 8
NP000001 | C |  |  |  |  |  | 16
NP000001 | D |  |  |  |  | 13
NP000001 | E
NP000001 | F |  |  |  |  | 56 | 1
NP000019 | A |  | 9 | 3 | 8 |  |  | 5 | 2
NP000019 | B |  | 10 | 13 | 9 |  |  | 7 | 11
NP000019 | C |  |  |  |  |  | 30
NP000019 | D |  |  |  |  | 17
NP000019 | E
NP000019 | F
NP000019 | G |  |  |  |  | 3
Date | Branch | Product | SALE
2020-01-05 00:00:00 | NP000001 | C
Spreadsheet: 114604d1310373041-nested-if-comm-2
Sheet: Sheet4

 |  |  | Trip
 |  | Cartons Delivered | 1 | 2 | 3 | 4 | 5
 |  | <100 | 10 | 12 | 14 | 15 | 20
 |  | >=100 to < 200 | 20 | 23 | 25 | 27 | 30
 |  | >=200 to < 300 | 25 | 27 | 30 | 35 | 40
 | Driver | Trip No | Capacity - Delivered | Comm
 | A | 1 | 150
 | A | 2 | 200
 | B | 1 | 250
 | B | 2 | 100
 | B | 3 | 300
 | C | 1 | 80
 | C | 2 | 200
 | C | 3 | 120
 | C | 4 | 300
 | D | 1 | 260
 | D | 2 | 300
Spreadsheet: 488604d1478727129-code-help-transposing-from-2-d-structure-to-1-d-with-characters-and-symbols-calendar-transposition-2d-to-1d
Sheet: CHR

2016 | 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
2016-01-01 00:00:00 | 1 |  | 3 |  | 4 | 5 |  |  | 6 |  |  | 7 |  |  |  | 8 |  |  | 9 |  | 10 |  |  |  |  |  |  |  |  |  | 20
2016-02-01 00:00:00 |  | 21 |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
2016-01-01 00:00:00
2016-01-02 00:00:00
2016-01-03 00:00:00
2016-01-04 00:00:00
2016-01-05 00:00:00
2016-01-06 00:00:00
2016-01-07 00:00:00
2016-01-08 00:00:00
2016-01-09 00:00:00
2016-01-10 00:00:00
2016-01-11 00:00:00
2016-01-12 00:00:00
2016-01-13 00:00:00
2016-01-14 00:00:00
2016-01-15 00:00:00
2016-01-16 00:00:00
2016-01-17 00:00:00
2016-01-18 00:00:00
2016-01-19 00:00:00
2016-01-20 00:00:00
2016-01-21 00:00:00
2016-01-22 00:00:00
2016-01-23 00:00:00
2016-01-24 00:00:00
2016-01-25 00:00:00
2016-01-26 00:00:00
2016-01-27 00:00:00
2016-01-28 00:00:00
2016-01-29 00:00:00
2016-01-30 00:00:00
2016-01-31 00:00:00
2016-02-01 00:00:00
2016-02-02 00:00:00
2016-02-03 00:00:00
2016-02-04 00:00:00
2016-02-05 00:00:00
2016-02-06 00:00:00
2016-02-07 00:00:00
2016-02-08 00:00:00
2016-02-09 00:00:00
2016-02-10 00:00:00
2016-02-11 00:00:00
2016-02-12 00:00:00
2016-02-13 00:00:00
2016-02-14 00:00:00
2016-02-15 00:00:00
2016-02-16 00:00:00
2016-02-17 00:00:00
2016-02-18 00:00:00
2016-02-19 00:00:00
2016-02-20 00:00:00
2016-02-21 00:00:00
2016-02-22 00:00:00
2016-02-23 00:00:00
2016-02-24 00:00:00
2016-02-25 00:00:00
2016-02-26 00:00:00
2016-02-27 00:00:00
2016-02-28 00:00:00
2016-02-29 00:00:00
2016-03-01 00:00:00
2016-03-02 00:00:00
2016-03-03 00:00:00
2016-03-04 00:00:00
2016-03-05 00:00:00
Spreadsheet: 191203d1351968269-how-to-skip-blanks-in-col-b-to-return-list-items-from-col-a-example-attached-easiest-way
Sheet: Sheet1

ITEMS | QTYS | helper |  | DESIRED RESULT
A | 22 | 2 |  | A
B |  |  |  | C
C | 3 | 4 |  | F
D |  |  |  | J
E |  |  |  | K
F | 56 | 7 |  | L
G |  |  |  | O
H
I
J | 3 | 11
K | 4 | 12
L | 5 | 13
M
N
O | 9 | 16
P
Spreadsheet: 587485d1535040960-drag-down-list-built-from-search-text-search
Sheet: Sheet1

Result | Seach Item | String
|SeS item a nfadsjfnlksjnfandfklsanf | Item A | gasjh item e nfajslnfdsalnfd;sl
||||item b|| sdfdsdf itemb | Item B | |SeS item a nfadsjfnlksjnfandfklsanf
fndsnfs item cdssd | Item C | [NAME] item f nnnnnn      ffdsfds
sdf item d fjilsdjfais | Item D | sdf item d fjilsdjfais
gasjh item e nfajslnfdsalnfd;sl | Item E | ||||item b|| sdfdsdf itemb
[NAME] item f nnnnnn      ffdsfds | [NAME] | fndsnfs item cdssd
I'd like to search column C for the text in column B and drag down the fomula in column A
Spreadsheet: 702470d1604371156-index-match-2-criteria-and-return-all-matching-data-match-data
Sheet: Report

Account | Case# | First Name | Last Name | Customer First Name | Customer  Last Name | NA Balance | PA Balance | [NAME] | [NAME] | UP Balance | UD Balance | IV Balance | ME Balance | Codes | Desc
1970001295 | 910357395 | [NAME] | DOE | Spider | Man | 0 | 0 | 0 | 0 | 3705.19 | 0 | 0 | 0 | FC | FOOD COSTS
1970001295 | 910357395 | [NAME] | DOE | Spider | Man | 460.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | PROCESSING FEES
1970001295 | 910357395 | [NAME] | DOE | Spider | Man | 978 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | SERVICE FEES
1970001655 | 910345466 | [NAME] | DOE | Super | Man | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TR | TRANSPORTATION
1970001655 | 910345466 | [NAME] | DOE | Super | Man | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | PROCESSING FEES
1970001655 | 910345468 | Sissy | DOE | Super | Man | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | SERVICE FEES
1970001655 | 910345468 | Sissy | DOE | Super | Man | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FF | FUEL COSTS
1976001972 | 910344997 | Wonder | Woman | [NAME] | Smith | 25643.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FC | FOOD COSTS
1976001972 | 910344997 | Wonder | Woman | [NAME] | Smith | 435.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | PROCESSING FEES
1976001972 | 910344997 | Wonder | Woman | [NAME] | Smith | 604.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | SERVICE FEES
1978000658 | 910350447 | Potatoe | Head | Hulk | Breath | 0 | 0 | 0 | 0 | 4565.9 | 0 | 0 | 0 | TR | TRANSPORTATION
1978000658 | 910350447 | Potatoe | Head | Hulk | Breath | 460.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | PROCESSING FEES
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Sheet7

DALE INC COMMISSION REPORT / DAVIS WINDOWS AND DOOR SALES / JULY / 2024
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
1 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
2 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
3 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.2
4 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
5 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
6 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
7 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
8 | ???? | 44724.5 | 1 | EMERALD COAST | SECLUSION BAY / LOT #1 | WINDOWS & DOORS | QQ #11094 | 44724.5 | 33767 |  |  | 0.25
 |  |  |  | 01/23/24 - texted [NAME] for update…     01/16/24 - emailed Feb 1st Jeld-Wen Price Increase…     12/20/23 - emailed FL #'s…     09/13/23 - Kevin said in permitting…     08/31/23 - emailed estimate to [NAME]…
9 | ???? | 202134.63 | 1 | [NAME] | CAPE SAN BLAS | WINDOWS & DOORS | QQ #11094 | 190645.87 | 150610.24 |  |  | 0.2
 |  |  |  | 05/14/24 - emailed estimate…
10 | ???? | 0 | 1 | WENCO DEV | PROMINENCE | WINDOWS & DOORS | TBD | 0 | 0 |  |  | 0.3
 |  |  |  | 02/28/24 - Scott waiting on drawings…
11 | ???? | 0 | 1 | WENCO DEV | GRACE POINT #1 | WINDOWS & DOORS | TBD | 0 | 0 |  |  | 0.3
 |  |  |  | 04/24/24 - Scott said he was going to give me the rest of Grace Point…
12 | ???? | 0 | 1 | WENCO DEV | GRACE POINT #1 | WINDOWS & DOORS | TBD | 0 | 0 |  |  | 0.3
 |  |  |  | 04/24/24 - Scott said he was going to give me the rest of Grace Point…
13 | ???? | 0 | 1 | WENCO DEV | GRACE POINT #1 | WINDOWS & DOORS | TBD | 0 | 0 |  |  | 0.3
 |  |  |  | 04/24/24 - Scott said he was going to give me the rest of Grace Point…
14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
Spreadsheet: phillip_m_love__30648__9908_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0
3 |  | Cost of Inventory |  |  |  |  |  |  |  |  |  | -4241659 |  |  |  |  |  | -110180
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | -94192 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 123637
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | 0 |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | -1166544
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  |  |  |  |  | -376583
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 14354 |  | -14354
 |  | TOTAL
Spreadsheet: daren_farmer__6566__HPL-industrials
Sheet: Customer List

Customer | Primary Lead
Advanced Aromatics | Papayoti
Air Liquide | Papayoti
Air Products | Papayoti
Akzo Chemicals | Lamphier
Albemarle | Lamphier
Alcoa | Lamphier
[NAME] | Lamphier
Ameripol Synpol | Lamphier
Amoco - Refinery & Chemical | Lamphier
Aristech | Papayoti
Baroid Technology | Lamphier
BASF | Papayoti
BASF-FINA Petrochemicals LP | Papayoti
Bayer | Papayoti
[NAME] | Papayoti
BP Chemical | Lamphier
Calgon | Lamphier
Catalyst Resources | Papayoti
Celanese | Papayoti
[NAME] | Lamphier
Chemicals, Inc. | Papayoti
Chevron Chemical | Papayoti
Chusei | Lamphier
Citgo | Lamphier
[NAME] | Papayoti
Coastal Refining | Papayoti
Crown Central | Lamphier
Destec | Lamphier
Diamond Shamrock | Lamphier
Dianal Americas | Papayoti
Dixie Chemical | Lamphier
Donohue Industries Inc. | Lamphier
Dow | Lamphier
DuPont/Brandywine | Papayoti
Enichem Elastomers | Papayoti
Enron Methanol | Papayoti
Enron MTBE ([NAME]) | Papayoti
Enterprise | Lamphier
[NAME] | Papayoti
Eurecat | Lamphier
Exxon | Lamphier
Fina | Papayoti
Formosa | Lamphier
Geon | Papayoti
Georgia Gulf | Lamphier
Global Octanes | Papayoti
Goodyear | Papayoti
Griffin | Lamphier
Gulf Coast Fractionators | Papayoti
[NAME] | Lamphier
[NAME] | Papayoti
Huntsman | Lamphier
Javelina | Papayoti
Kaneka Texas | Lamphier
KMCO | Lamphier
LaRoche Vitamins | Papayoti
Liquid Carbonics | Papayoti
Lonza | Papayoti
Louisiana Pacific | Papayoti
Lubrizol | Papayoti
Lyondell - Bayport | Papayoti
Lyondell - Citgo | Lamphier
Marathon Oil | Lamphier
[NAME] | Lamphier
Mercado Gas Services | Lamphier
Mobil | Papayoti
[NAME] | Lamphier
Nisseki | Lamphier
[NAME] | Lamphier
Olin | Papayoti
OxyChem | Papayoti
Petrolite | Lamphier
Phillips | Lamphier
Praxair | Papayoti
Reynolds Metals | Papayoti
Rhodia Inc. | Lamphier
Rohm & Haas | Lamphier
Schenectady | Lamphier
[NAME] | Lamphier
Shell | Lamphier
Shintech | Lamphier
Solvay Polymers | Lamphier
Southern Ionic | Lamphier
Sterling Chemicals | Lamphier
Temple-Inland | Lamphier
Texas Industries | Papayoti
Union Carbide | Papayoti
United Salt | Lamphier
[NAME] | Lamphier
Velsicol | Lamphier
Wyman-Gordon Forging | Papayoti
Zeneca | Lamphier
Spreadsheet: 809410d1671069696-attendance-tracker-pto-tracker-ex-1-
Sheet: Holiday

 | Company holidays
 | Date | Description
 |  | New Year's Day
 |  | [NAME]
 |  | Memorial
 |  | Independence Day
 |  | Labor Day
 |  | Thanksgiving
 |  | Friday after Thanksgiving
 |  | Christmas Eve
 |  | Christmas Day
 |  | New Year's Eve
Spreadsheet: 32459d1228638341-how-to-reference-cells-in-different-rows-example-of-weekly-account-sheets
Sheet: Report

Account | Income | wages | Colors | inventory
1 | 100 | 200 | BLUE | 310
2 | 101 | 201 | RED | 311
3 | 102 | 202 | GREEN | 312
4 | 103 | 203 | WHITE | 313
 | Blue cells need formulas to pull information form a weekly spread sheets
 | Each week the information is copied and pasted into a weekly sheet.
 | Weekly spread sheets may not always have the same exact layout. What this means is some weeks one of the accounts or departments will be deleted as in week 2 account 2. The information will always be laid out identical within each account. How can I write a formula to find the information and pull it to my report without having to add or delete rows each week. My guess is I need to use OFFSET & LOOKUP together but I cannot get a formula to work.