tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49437d1248794574-help-with-how-to-get-formula-to-show-correct-amount-team-sheets
Sheet: Sheet1

YOUR NAME |  |  | [NAME] if problem with team:
TEAM NAME
YOUR EMAIL ADDRESS (if you want the table to be sent to you each week)
Pos | IMPORTANT Number | Player Last name | Listed Team                              (may not be current team) | Value(M)
GK
DEF
DEF
DEF
DEF
MID
MID
MID
MID / SKR
SKR
SKR
Money Left to spend (mil)  £ |  | 50 | Total (no more than £50 million) | 0
YOUR NAME |  |  | [NAME] if problem with team:
TEAM NAME
YOUR EMAIL ADDRESS (if you want the table to be sent to you each week)
Pos | IMPORTANT Number | Player Last name | Listed Team                              (may not be current team) | Value(M)
GK
DEF
DEF
DEF
DEF
MID
MID
MID
MID / SKR
SKR
SKR
Money Left to spend (mil)  £ |  | 50 | Total (no more than £50 million) | 0
YOUR NAME |  |  | [NAME] if problem with team:
TEAM NAME
YOUR EMAIL ADDRESS (if you want the table to be sent to you each week)
Pos | IMPORTANT Number | Player Last name | Listed Team                              (may not be current team) | Value(M)
GK
DEF
DEF
DEF
DEF
MID
MID
MID
MID / SKR
SKR
SKR
Money Left to spend (mil)  £ |  | 50 | Total (no more than £50 million) | 0
Spreadsheet: sally_beck__35152__Global Hot List 0914
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 3Q00 DEALS COMPLETED
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance |  |  |  |  |  | Global Risk Markets
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | Freight Liner |  | 250
 |  | SynFuel - Sempra |  | 0
 |  | NoxTech |  | 0
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: darrell_schoolcraft__7231__saledoc01_5TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power LLC
Deal Date: |  |  | 2002-01-07 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/08/01 |  |  | FAX Number:
Total Quantity |  |  | 21053 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 1.98
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/08/02 | 2002-01-08 00:00:00 | 21053 |  | 21053 |  | 21053
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 21053 |  | 27505 |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 896bb924-9715-4439-a64d-624fb23b3ca8
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Brash Music | 881410002521 | [NAME] | My Savior My God | 2006-06-27 | Distributed CD Trax | Praise | 9.98 | Y | Available
Spreadsheet: 27736d1221248468-seeking-to-average-numbers-in-single-column-broken-into-increments-of-5-age-of-respondees
Sheet: Sheet1

India
India
China
India
China
India
India
India
India
India
China
China
India
India
India
India
India
India
India
India
India
China
India
India
India
India
India
India
China
India
India
India
India
India
India
India
India
India
India
India
India
China
India
India
China
India
India
India
India
India
India
India
China
India
India
India
China
India
India
India
India
India
China
India
India
China
India
India
China
India
China
China
India
India
India
India
India
India
India
India
China
China
India
India
China
India
China
China
China
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T56

الجدول 56:  معدلات وفيات الرضع والاطفال حسب اخر تعداد و/او مسح متوفر
Table 56: Infant and child mortality rates according to the latest available census and/or survey
Country | السنة | معدل وفيات الرضع Infant mortality rates |  |  | معدل وفيات الاطفال Child mortality rates (U5M) |  |  | البلد
 | Year | اناث Girls | ذكور Boys | مجموع الجنسين Both sexes | اناث Girls | ذكور Boys | مجموع الجنسين Both sexes
Bahrain |  |  |  |  |  |  |  | البحرين
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Egypt |  |  |  |  |  |  |  | مصر
census | 2009 | 11.1 | 12.11 | 11.6 | 16.2 | 17.6 | 16.9 | التعداد
survey | 2008 | 15 | 16.4 | 15.7 | 19.6 | 21.6 | 20.6 | [NAME]
Iraq |  |  |  |  |  |  |  | العراق
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Jordan |  |  |  |  |  |  |  | الاردن
census | 2002 | 23 | 25 | 24 | 28 | 30 | 29 | التعداد
survey | 2007 | 20 | 20 | 20 | 23 | 22 | 22 | [NAME]
Kuwait |  |  |  |  |  |  |  | الكويت
census | 2009 | 9.7 | 11.3 | 10.5 | 11.1 | 13.77 | 12.5 | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Lebanon |  |  |  |  |  |  |  | لبنان
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Oman |  |  |  |  |  |  |  | عمان
census |  | … | … | … | … | … | … | التعداد
survey | 2009 | 7.8 | 11.2 | 9.6 | 9.9 | 14.1 | 12 | [NAME]
Palestine |  |  |  |  |  |  |  | فلسطين
census |  | … | … | … | … | … | … | التعداد
survey | 2010 | 17.8 | 23.3 | 20.6 | 20.9 | 29.2 | 25.1 | [NAME]
Qatar |  |  |  |  |  |  |  | قطر
census | 2004 | 8.3 | 8.8 | 8.6 | 10.2 | 10.6 | 10.4 | التعداد
survey | 2010 | 6.6 | 6.7 | 6.7 | 7.8 | 8.9 | 8.4 | [NAME]
Saudi Arabia |  |  |  |  |  |  |  | المملكة العربية السعودية
census | 2004 | 19 | 19.9 | 19.4 | 22.7 | 23 | 22.8 | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Sudan |  |  |  |  |  |  |  | السودان
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Syrian Arab Republic |  |  |  |  |  |  |  | الجمهورية العربية السورية
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
United Arab Emirates |  |  |  |  |  |  |  | الإمارات العربية المتحدة
census | 2005 | 7.4 | 8.1 | 7.74 | 9.4 | 10.3 | 9.9 | التعداد
survey | 2009 | 5.7 | 8.1 | 6.91 | 7.8 | 10.2 | 9.1 | [NAME]
Yemen |  |  |  |  |  |  |  | اليمن
census |  | … | … | … | … | … | … | التعداد
survey |  | … | … | … | … | … | … | [NAME]
Spreadsheet: 86163d1286198909-relative-cell-references-not-changing-in-an-array-unique-list-formula2
Sheet: Source

Source data (full list)
List | TRIM
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Edgar | Edgar
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: eric_saibi__9806__092001
Sheet: Turkey Point 04

Owner Name | Florida Power & Light Company
Station Name | Turkey Point Nuclear Power Station
Unit Name | Turkey Point 04
NERC Region | FRCC
State | FL
Fuel Type | Nuclear
Capacity | 760 MW
Start Date | 2001-09-20 00:00:00
End Date | 2001-09-23 00:00:00
Comments | Derated to 60% for valve testing. Should return to 100% by the end of the weekend.
SIC | 4911
Plant ID | 1500318
Unit ID | 1005037
Outage ID
Spreadsheet: 822044d1679066928-help-with-formula-to-calculate-no-of-cells-within-dates-query-sample-2
Sheet: Sheet1

N/A | N/A | Name | N/A | N/A | Total No of Meetings  in past 12 months (including this one) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Date of Meeting | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 01/04/23 -01/03/24
 |  | [NAME] |  |  |  | Should be 1 |  |  |  |  |  |  | 2023-05-06 00:00:00
 |  | [NAME] |  |  |  | Should be 2 |  |  |  |  |  |  | 2023-07-07 00:00:00
 |  | [NAME] |  |  |  | Correct but should be counting the one from previous sheet |  |  |  |  |  |  | 2023-11-08 00:00:00
 |  | [NAME] |  |  |  | Should be 3 |  |  |  |  |  |  | 2023-11-10 00:00:00
 |  | [NAME] |  |  |  | Should be 2 |  |  |  |  |  |  | 2023-12-12 00:00:00
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 2023-02-13 00:00:00
Spreadsheet: 838050d1690646085-help-formula-with-dropdown-list-combobox-dummy-data-glenn
Sheet: PT summary

 | Column Labels
 | Apr |  |  |  | May |  |  |  | Jun
Row Labels | Sum of OS | Sum of SI | Sum of ST | Sum of CI | Sum of OS | Sum of SI | Sum of ST | Sum of CI | Sum of OS | Sum of SI | Sum of ST | Sum of CI
East |  |  |  |  | 6 | 6 | 6 | 5
BHU |  |  |  |  | 1 | 1 | 1 | 1
DC-S1HGW-K |  |  |  |  | 1 | 1 | 1 | 1
GUW |  |  |  |  | 1 | 1 | 1 | 1
DC-S5KGW-K |  |  |  |  | 1 | 1 | 1 | 1
KOL |  |  |  |  | 1 | 1 | 1 | 1
DC-S5GW-K |  |  |  |  | 1 | 1 | 1 | 1
PAT |  |  |  |  | 1 | 1 | 1 | 1
DC-S5M2WGW |  |  |  |  | 1 | 1 | 1 | 1
RAN |  |  |  |  | 2 | 2 | 2 | 1
DC-S5M2KGW |  |  |  |  | 2 | 2 | 2 | 1
North | 14 | 14 | 14 | 10 | 4 | 3 | 3 | 40
CHA | 4 | 4 | 4 | 2
DMC-FZ2500GA | 4 | 4 | 4 | 2
DEL | 6 | 6 | 6 | 4 | 4 | 3 | 3 | 40
DC-FZ10002GW | 4 | 4 | 4 | 2
DC-S5GW-K | 2 | 2 | 2 | 2
DC-S5M2GW |  |  |  |  | 2 | 2 | 2 | 28
DC-S5M2XWGW |  |  |  |  | 2 | 1 | 1 | 12
GUR | 2 | 2 | 2 | 2
DC-S1HGW-K | 2 | 2 | 2 | 2
JAI | 2 | 2 | 2 | 2
DC-S5KGW-K | 2 | 2 | 2 | 2
South | 14 | 12 | 12 | 84 | 8 | 8 | 8 | 4
BAN | 2 | 2 | 2 | 2
DC-S5M2WGW | 2 | 2 | 2 | 2
CHE | 4 | 4 | 4 | 56
DC-S5M2GW | 4 | 4 | 4 | 56
COC | 4 | 2 | 2 | 24
DC-S5M2XWGW | 4 | 2 | 2 | 24
COI | 4 | 4 | 4 | 2
DC-S5M2KGW | 4 | 4 | 4 | 2
HYD |  |  |  |  | 4 | 4 | 4 | 2
DMC-FZ2500GA |  |  |  |  | 4 | 4 | 4 | 2
VIJ |  |  |  |  | 4 | 4 | 4 | 2
DC-FZ10002GW |  |  |  |  | 4 | 4 | 4 | 2
West-1 |  |  |  |  |  |  |  |  | 5 | 4 | 4 | 15
MUM |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
DC-S1HGW-K |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
NAG |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
DC-S5KGW-K |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
PUN |  |  |  |  |  |  |  |  | 3 | 2 | 2 | 13
DC-S5GW-K |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
DC-S5M2XWGW |  |  |  |  |  |  |  |  | 2 | 1 | 1 | 12
West-2 |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 30
AHM |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
DC-S5M2WGW |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
IND |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 1
DC-S5M2KGW |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 1
RAI |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 28
DC-S5M2GW |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 28
Spreadsheet: 884406d1733537686-formula-to-report-of-data-points-positive-or-negative-based-on-a-condition-golfshots-data
Sheet: Report

5% Test Combine (105 to 200 yards)
Iron | [NAME] | [NAME] | % of Shots -Lft | % of Shots +Rgt | Avg -Sht / +Lng | % of Shots -Short | % of Shots +Long | [NAME] From Pin | [NAME] from Pin | % of Shots  <2.5% | % of Shots <=5%
4i
5i
6i
7i
8i
9i
PW
50*
54*
58*
Spreadsheet: 154613d1336495761-survey-in-excel-survey
Sheet: Companies

NAME | GEOGRAPHY |  | MANAGER
Company Name | Geographical Region | Country | CEO
Please Select a Company
A | EUROPE | NL | AAA AAAAAAAAA
B | EUROPE | UK | BBB BBBBBBBBBBB
C | EUROPE | UK | CCC CCCCCCCC
D | EUROPE | NL | [NAME]
E | EUROPE | SP | EEE EEEEEEEEEEE
F | EUROPE | PO | FFF FFFFFFFFFFF
G | EUROPE | GE | GGG GGGGGG
H | EUROPE | GE | HHH HHHHHHHH
I | EUROPE | NL | III IIIIIIIIIIIIIIIIIIIIIIIIIIIII
J | EUROPE | NL | JJJ JJJJJJJJJJJJJJJJ
K | EUROPE | NL | KKK KKKKKKKKK
L | EUROPE | UK | [NAME]
M | AMERICA | US | [NAME]
N | AMERICA | US | [NAME]
O | ASIA PACIFIC | CH | OOO OOOOOO
P | ASIA PACIFIC | CH | PPP PPPPPPPPPPP
Q | ASIA PACIFIC | JP | QQQ QQQQQQ
R | EUROPE | UK | RRR RRRRRRRRRRR
S | EUROPE | UK | SSS SSSSSSSSSSS
T | EUROPE | UK | TTT TTTTTTTTTTT
U | EUROPE | PO | UUU UUUUUUUU
V | EUROPE | FR | VVV VVVVVVVVV
W | EUROPE | FR | [NAME]
X | EUROPE | NL | [NAME]
Y | EUROPE | FR | YYY [NAME]
Z | EUROPE | FR | ZZZ ZZZZZZZZZZZ
Spreadsheet: 275279d1383430361-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-1-
Sheet: Data

Daily | Date | Employee# | Name | task | # of hour |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
2013-10-28 00:00:00 |  | 1111 | Name1 | task1 | 5
 |  | 2222 | [NAME] | [NAME] | 10
 |  | 3333 | Namde3 | [NAME] | 15
2013-10-29 00:00:00 |  | 1111 | Name1 | [NAME] | 10
 |  | 2222 | [NAME] | [NAME] | 5
 |  | 3333 | Namde3 | task1 | 15
2013-10-30 00:00:00 |  | 1111 | Name1 | task1 | 5
 |  | 2222 | [NAME] | [NAME] | 7
 |  | 3333 | Namde3 | [NAME] | 6
 |  | 4444 | name4 | task3 | 10
2013-10-31 00:00:00 |  | 1111 | Name1 | task1 | 5
 |  | 2222 | [NAME] | [NAME] | 10
 |  | 3333 | Namde3 | [NAME] | 25
 |  | 4444 | name4 | task3 | 10
 |  | 5555 | name5 | task4 | 11
2013-11-01 00:00:00 |  | 1111 | Name1 | task1 | 111
 |  | 2222 | [NAME] | [NAME] | 222
 |  | 3333 | Namde3 | task1 | 333
2013-11-02 00:00:00 |  | 1111 | Name1 | task1 | 1111
 |  | 2222 | [NAME] | [NAME] | 2222
 |  | 3333 | Namde3 | task1 | 3333
Spreadsheet: drew_fossum__8882__MarchForecast
Sheet: ET&S-O&M

ENRON TRANSPORTATION & STORAGE
2000 O & M EXPENSE (000'S) - NET - 1st QUARTER
 |  | 1999 Actuals |  | Prior Forecast |  | Forecast |  | Plan |  | Var.from Plan |  | Description
Direct Costs
Executive
Finance & Accounting |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Systems |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Transportation Marketing |  |  |  |  |  |  |  |  |  |  |  | Savings distribution; $100 Keyex prepmt
Business Services |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Market Services
Regulatory Affairs & Administration |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
TW Commercial Group |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Operations |  |  |  |  |  |  |  |  |  |  |  | DOT fees reversal $1,226M;  Timing
General & Administrative |  |  |  |  |  |  |  |  |  |  |  | $(200) reduction of Fuji lease offset in  Corp. overview
Stretch
Total Direct Costs
GPG Allocations
Legal  (Co.  508) |  |  |  |  |  |  |  |  |  |  |  | OH reclass, Grynberg $(200)
Finance & Accounting  (Co. 422) |  |  |  |  |  |  |  |  |  |  |  | OH reclass
Operations Technical Services  (Co. 423)
Human Resources  (Co. 507) |  |  |  |  |  |  |  |  |  |  |  | To payroll taxes $(30), OH reclass
Executive |  |  |  |  |  |  |  |  |  |  |  | Aviation true-up $(35), OH reclass $439, Ad Val Taxes reclass $101, OH rev $201
Other
Total GPG Allocations
Corporate Allocations
MMF
ECM |  |  |  |  |  |  |  |  |  |  |  | Offset in Corp overview
Insurance
Direct - EMI Co 001
Direct - Corp Co 011 |  |  |  |  |  |  |  |  |  |  |  | Ad Valorem reclass  $(101)
Aviation
EIS |  |  |  |  |  |  |  |  |  |  |  | $(270) reserve reversal, savings $(200) offset in corp. overview
EPSC - Co 901 |  |  |  |  |  |  |  |  |  |  |  | Reclass to capital $(48)
EDS Delta |  |  |  |  |  |  |  |  |  |  |  | Capitalization deferred to 1st Qtr
Other
Total Corporate Allocations
Total O&M Expense
Spreadsheet: 36087d1233851563-how-to-deduct-holidays-and-take-multiple-projects-into-account-in-a-report-monthly-report-with-holidays
Sheet: report

Project Type | Started | Finished | Employee | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
International | 2008-11-11 00:00:00 | 2008-11-25 00:00:00 | Mr White | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-12 00:00:00 | 2008-11-26 00:00:00 | Mr Orange | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
International | 2008-11-18 00:00:00 | 2008-11-25 00:00:00 | Mr Blonde | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-24 00:00:00 | 2008-12-01 00:00:00 | Mr Pink | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-25 00:00:00 | 2008-12-02 00:00:00 | Mr Blue | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-26 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME] | 3 | 23 | 11 | 0 | 0 | 0 | 0 | 0
International | 2008-11-28 00:00:00 | 2008-12-19 00:00:00 | Mr Orange | 1 | 15 | 0 | 0 | 0 | 0 | 0 | 0
International | 2008-12-01 00:00:00 | 2009-01-16 00:00:00 | Mr Pink | 0 | 23 | 12 | 0 | 0 | 0 | 0 | 0
International | 2008-12-05 00:00:00 | 2008-12-19 00:00:00 | Mr Blonde | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-12-17 00:00:00 | 2009-01-19 00:00:00 | Mr White | 0 | 11 | 13 | 0 | 0 | 0 | 0 | 0
International | 2008-12-18 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME] | 0 | 10 | 11 | 0 | 0 | 0 | 0 | 0
International | 2009-01-07 00:00:00 | 2009-01-21 00:00:00 | Mr Orange | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0
Local | 2009-01-12 00:00:00 | 2009-02-09 00:00:00 | Mr Orange | 0 | 0 | 15 | 6 | 0 | 0 | 0 | 0
Local | 2009-01-14 00:00:00 | 2009-01-28 00:00:00 | Mr [NAME] | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0
International | 2009-01-19 00:00:00 | 2009-02-02 00:00:00 | Mr White | 0 | 0 | 10 | 1 | 0 | 0 | 0 | 0
International | 2009-01-23 00:00:00 | 2009-02-06 00:00:00 | Mr Pink | 0 | 0 | 6 | 5 | 0 | 0 | 0 | 0
Local | 2009-01-26 00:00:00 | 2009-01-29 00:00:00 | Mr Blonde | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
International | 2009-01-23 00:00:00 | 2009-02-10 00:00:00 | Mr [NAME] | 0 | 0 | 6 | 7 | 0 | 0 | 0 | 0
International | 2009-01-29 00:00:00 | 2009-02-06 00:00:00 | Mr Blue | 0 | 0 | 2 | 5 | 0 | 0 | 0 | 0
International | 2009-02-02 00:00:00 | 2009-03-13 00:00:00 | Mr Blonde | 0 | 0 | 0 | 20 | 10 | 0 | 0 | 0
Local | 2009-02-03 00:00:00 | 2009-02-10 00:00:00 | Mr Blue | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 56662 | - | 17048
Cross-Currency Fixed-Fixed | 0 | 8622 | - | 7282
Cross-Currency Fixed-Float | 0 | 6307 | - | 4958
TOTAL | 0 | 71591 | - | 29288
Spreadsheet: a743af12-22a9-4e07-bf66-cc4050b5f87b
Sheet: Sheet1

Whitefish Bulldogs | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2008 Football Roster
Number |  |  |  | Grade | Height | Weight | Position
#7 | [NAME] | Simmons |  | 11 | 5'11" | 190 | RB-DB
#11 | Mac | Roche |  | 10 | 6'0 | 170 | QB-DB
#12 | [NAME] | Knox |  | 12 | 6'2" | 190 | TE-DE
#15 | Federico | [NAME] |  | 12 | 6'0 | 155 | WR-DB
#17 | [NAME] | Elespuru |  | 12 | 5'10" | 175 | QB-DB
#19 | [NAME] | Tkachyk |  | 12 | 5'11" | 160 | WR-DB
#20 | [NAME] | [NAME] |  | 12 | 5'9" | 165 | WR-DB
#22 | [NAME] | [NAME] |  | 12 | 5'9" | 155 | WR-DB
#24 | [NAME] | [NAME] |  | 11 | 5'9" | 140 | WR-DB
#32 | Jeremy | Nielsen |  | 10 | 5'4" | 145 | RB-LB
#33 | Quentin | Menagazzi |  | 10 | 5'10" | 165 | RB-LB
#35 | Tanner | [NAME] |  | 11 | 5'7" | 175 | RB-LB
#40 | Kaleb | Prestegaard |  | 12 | 5'11" | 160 | RB-LB
#44 | Derek | [NAME] |  | 11 | 6'2" | 225 | TE-LB
#48 | [NAME] | Strunk |  | 12 | 5'11" | 180 | RB-LB
#50 | Geoff | Streeter |  | 11 | 6' | 190 | OL-DE
#51 | Nick | O'Dell |  | 11 | 5'9" | 175 | OL-NT
#52 | Joel | Snipes |  | 11 | 5'10" | 230 | OL-NT
#54 | Sean | Sagen |  | 12 | 6'1 | 220 | OL-DT
#55 | Tyson | Ferda |  | 11 | 6'1" | 220 | OL-DT
#59 | [NAME] | Backer |  | 12 | 6' | 195 | OL-DE
#62 | [NAME] | Washer |  | 11 | 6’1" | 230 | OL-NT
#64 | Dustin | Beck |  | 12 | 6' | 205 | OL-LB
#67 | Vic | Mauro |  | 10 | 5'9" | 170 | OL-LB
#71 | Ian | Cain |  | 11 | 6' | 230 | OL-DT
#75 | [NAME] | Watterud |  | 10 | 6'1 | 210 | OL-DT
#78 | [NAME] | Dryden |  | 12 | 6'3" | 210 | OL-DT
#80 | [NAME] | FauntLeRoy |  | 12 | 6'3" | 205 | WR-DE
#82 | Kalin | Hale |  | 11 | 6'1" | 165 | WR-DB
#83 | Willie | Roche |  | 11 | 6' | 160 | WR-DB
#84 | Bentley | Smith |  | 11 | 6'2" | 165 | WR-DB
#88 | Connor | Silliker |  | 11 | 6'5" | 190 | TE-DE
#89 | [NAME] | Whitehead |  | 12 | 5'9" | 175 | WR-DB
Spreadsheet: 193583d1352882458-filtering-problem-fx
Sheet: Sheet2

Project | Total Cost
1 | 903790955 |  | Row Labels | Sum of Total Cost
2 | 903790955 |  | 1 | 3658245609
3 | 903790955 |  | 2 | 7756609051
5 | 948863332 |  | 3 | 7646479314
6 | 948863332 |  | 4 | 8147553237
9 | 948863332 |  | 5 | 12712233755
4 | 873161482 |  | 6 | 12655788153
8 | 873161482 |  | 7 | 4503255712
6 | 873161482 |  | 8 | 6271070124
3 | 1028357159 |  | 9 | 7337878591
2 | 1028357159 |  | Grand Total | 70689113546
5 | 1028357159
9 | 1054349474
7 | 1054349474
4 | 1054349474
5 | 1015440456
6 | 1015440456
3 | 1015440456
2 | 928265311
1 | 928265311
4 | 928265311
5 | 926816014
6 | 926816014
9 | 926816014
8 | 976100958
3 | 976100958
9 | 976100958
6 | 817998734
8 | 817998734
7 | 817998734
4 | 903590367
5 | 903590367
6 | 903590367
3 | 897683641
2 | 897683641
1 | 897683641
5 | 730085416
9 | 730085416
8 | 730085416
6 | 771550706
7 | 771550706
4 | 771550706
8 | 782815062
5 | 782815062
6 | 782815062
9 | 638409071
8 | 638409071
7 | 638409071
4 | 671578974
5 | 671578974
6 | 671578974
3 | 703465702
2 | 703465702
1 | 703465702
2 | 423461537
3 | 423461537
6 | 423461537
9 | 62550780
8 | 62550780
7 | 62550780
9 | 314512815
8 | 314512815
7 | 314512815
4 | 344816923
5 | 344816923
6 | 344816923
3 | 598077259
2 | 598077259
6 | 598077259
5 | 618844132
9 | 618844132
7 | 618844132
4 | 2375200000
5 | 334733255
6 | 334733255
5 | 121129846
2 | 1725919
3 | 1725919
6 | 1725919
9 | 842306599
6 | 842306599
5 | 842306599
2 | 919776361
3 | 113490000
6 | 113490000
5 | 113490000
4 | 225040000
1 | 225040000
2 | 225040000
6 | 225040000
9 | 225040000
7 | 225040000
8 | 1075435806
5 | 1075435806
6 | 1075435806
2 | 1126965207
5 | 1126965207
5 | 1126965207
3 | 984885728
6 | 984885728
Spreadsheet: 486094d1477322028-variable-lookup-of-data-across-different-tabs-while-skipping-blanks-sample-box-numbering-for-multi-station-process-10-23-16
Sheet: Summary

 |  |  | Final Box # >>> | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 9 | 9 | 10 | 10 | 11 | 11 | 12 | 12
Product | Quantity | Expiration Date | Total Packed | [NAME] | [NAME] | [NAME] | Box A2 Expiration Date | [NAME] | [NAME] | [NAME] | Box C1 Expiration Date | [NAME] | Box C2 Expiration Date | [NAME] | Box C3 Expiration Date | [NAME] | Box C4 Expiration Date | [NAME] | Box E1 Expiration Date | Box E2 | Box E2 Expiration Date | Box E3 | Box E3 Expiration Date | [NAME] | Box E4 Expiration Date | Box E5 | Box E5 Expiration Date
SKU1 | 15 | 2017-10-10 00:00:00 |  | 5 | 2017-10-10 00:00:00 |  |  |  |  | 3 | 2017-10-10 00:00:00 |  |  | 3 | 2017-10-10 00:00:00 |  |  |  |  | 4 | 2017-10-10 00:00:00
SKU2 | 15 | 2017-10-20 00:00:00 |  | 2 | 2017-10-20 00:00:00 |  |  | 2 | 2017-10-20 00:00:00 |  |  | 4 | 2017-10-20 00:00:00 |  |  |  |  | 2 | 2017-10-20 00:00:00 |  |  | 4 | 2017-10-20 00:00:00 |  |  | 1 | 2017-10-20 00:00:00
SKU3 | 15 | 2017-10-30 00:00:00 |  |  |  |  |  | 5 | 2017-10-30 00:00:00 |  |  |  |  |  |  | 2 | 2017-10-30 00:00:00 |  |  | 4 | 2017-10-30 00:00:00 | 1 | 2017-10-30 00:00:00 | 3 | 2017-10-30 00:00:00
[NAME] | 15 | 2017-11-10 00:00:00 |  |  |  |  |  |  |  | 2 | 2017-11-10 00:00:00 |  |  |  |  |  |  | 6 | 2017-11-10 00:00:00 |  |  | 1 | 2017-11-10 00:00:00 |  |  | 6 | 2017-11-10 00:00:00
[NAME] | 15 | 2017-11-20 00:00:00 |  |  |  | 6 | 2017-11-20 00:00:00 |  |  |  |  | 1 | 2017-11-20 00:00:00 | 4 | 2017-11-20 00:00:00 |  |  |  |  |  |  |  |  | 4 | 2017-11-20 00:00:00
 |  |  |  |  |  | I can certainly do this manually, but I'm looking for an easy way to do this "dynamically" (formulas, lookups, etc.) without using VBA or Conditional Formatting.  I'm open to any ideas or even a slight "in-between step" format modification or using an "input/output" set of tabs, etc. (but the above format is how we finally need it).