tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216541d1361804712-multiple-logical-tests-required-sample-1-
Sheet: D&T - Formula

Type of Conductor: |  | Copper
S = | is the conductor cross-sectional area, in mm² |  |  |  |  | 100
I = | is the average fault current, in A r.m.s.; |  |  |  |  | 25000
t = | is the fault current duration, in s. |  |  |  |  | 3
I₁ = | is the fault current for 1 s duration, in A r.m.s.
k = | is the r.m.s. current density, in A/mm² |  |  |  |  | 144.3375672974065
 | square root of t multiplied by S |  |  |  |  | 173.2050807568877
 | Average fault current, in A r.m.s. (for verification) |  |  |  |  | 25000
Type of JointA) |  |  |  | Maximum Temperature B)  (°Cs) | U | R.M.S. current density, k
Welded | Brazed | Bolted | Soft Soldered
P | P | P | P | 150 | F) | 138
a | b | c | d | e | f | g |  |  | 0 | G | 14
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: $$ Professional Staff

[NAME] vs. [NAME]
Salaries & Wages Professional Staff
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 1818401 | 1105278 | 1690926 | 1493061 | 1522246
[NAME] University | 1186335 | 1337453 | 1501201 | 1896539 | 1954289
Montana State University - Bozeman | 1136329 | 679547 | 1251233 | U/A | 1251233
North Dakota State University - Main Campus | 814882 | 828365 | 884183 | 845276 | U/A | U/A
University of Maine | 1020001 | 1028896 | 1046460 | 1107519 | 1072280
University of New Hampshire - Main Campus | 1605117 | 2596086 | 2984568 | 2616328 | 2248337
University of Vermont and State Ag. Coll. | U/A | 2942645 | 3217991 | 2974527 | 3350672 | U/A
University of Wyoming | 2191904 | 2303766 | 2507000 | 2715220 | 2755091
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: hunter_shively__12738__EnovateDPR0116
Sheet: ENOVATE DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
ENOVATE
GAS TRADING |  |  | 10 Bcf |  |  | 20 Bcf |  |  |  | 2000
Short Term Trading
Long Term Trading |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  | MTD | QTD | YTD | MTD 12/12 |  | 114
 |  | ENOVATE | 1054.4947101 | 1054.4947101 | -249.9702899 |  |  |  |  | P&L 13th |  | 17
 |  |  |  |  |  |  |  |  |  | MTD 13th |  | 131
 |  | GAS TRADING | 1054.4947101 | 1054.4947101 | -249.9702899
 |  | Short Term Trading | 1054.4947101 | 1054.4947101 | -249.9702899 |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 52cd1485-e0f5-4a28-81f1-fea5b05ceabe
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
ALPA | Test | ALPA | Alprazolam, Serum | Alprazolam, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum gel tube | Therapeutic range: 5-25 ng/mL Some patients respond well to levels of 25-55 ng/mL. | Varies, batched 2 times per week | 1 day | 3 days | 1 | 80154 |  |  |  |  | New England
ALPA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
ALPA | Result | 11236 | Alprazolam, S | Alprazolam, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3312-6 | Alprazolam:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 46123d1245015286-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample2
Sheet: Bananas

Key | Date | Fruit | Units | Cost |  | Status: OK
1 | 2009-02-15 00:00:00 | Bananas | 3 | 30
2 | 2009-02-15 00:00:00 | Bananas | 7 | 70 |  | Key column in column A on each fruit page, you can hide this
3 | 2009-02-15 00:00:00 | Bananas | 2 | 20 |  | column once you've copied the formula down far enough.
4 | 2009-02-16 00:00:00 | Bananas | 9 | 90
5 | 2009-02-17 00:00:00 | Bananas | 8 | 80
6 | 2009-02-18 00:00:00 | Bananas | 7 | 70
7 | 2009-02-19 00:00:00 | Bananas | 8 | 80
8 | 2009-02-21 00:00:00 | Bananas | 3 | 30
9 | 2009-02-22 00:00:00 | Bananas | 6 | 60
10 | 2009-02-22 00:00:00 | Bananas | 5 | 50
Spreadsheet: 287299d1388752318-how-to-make-the-totals-row-automatically-move-up-and-down-as-list-grows-and-shrinks-subtotal-lookup
Sheet: Sheet1

Dogs | Blue | 2
Cats | Blue | 4
Giraffes | Blue | 1
Kanagroos | Red | 3
Elephants | Blue | 2
Mice | Blue | 3
Rats | Blue | 3
Birds | Blue | 4
Fish | Blue | 1
Frogs | Red | 5
cats | red | 8
Spreadsheet: 88563d1288357656-extract-multiple-numbers-from-string-labor-code-breakdown
Sheet: Sheet1

 |  | N | S | C | B | G | M | D | H | P | Q | Z | K | F | W | L | U | V | A | J | R | T | O | X
D12 |  | 10 | 10 | 10 | 10 | 10 | 10 | 12 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
S20F5N50W15D12 |  | 50 | 20 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 5 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A15N12D50N12 |  | 24 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 50 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
N5C13D4F5W12 |  | 5 | 0 | 13 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D20 |  | 16 | 16 | 16 | 16 | 16 | 16 | 20 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
S10 |  | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C10 |  | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B10 |  | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 12.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M10 |  | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Q10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Z145266 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 145266 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
W10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
V10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0
A10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0
J10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0
R10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0
T10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0
O10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0
U10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: PENNSYLVANIA-37

 | COUNTY | CODE
 | Adams | 1
 | Allegheny
 | [NAME]
 | Beaver
 | Bedford
 | Berks
 | Blair
 | Bradford
 | Bucks
 | Butler
 | Cambria
 | Cameron
 | Carbon
 | Centre
 | Chester
 | Clarion
 | Clearfield
 | [NAME]
 | Columbia
 | Crawford
 | Cumberland
 | Dauphin
 | Delaware
 | Elk
 | Erie
 | Fayette
 | Forest
 | Franklin
 | Fulton
 | Greene
 | Huntingdon
 | Indiana
 | [NAME]
 | Juniata
 | [NAME]
 | Lancaster
 | [NAME]
 | Lebanon
 | Lehigh
 | Luzerne
 | Lycoming
 | McKean
 | Mercer
 | Mifflin
 | Monroe
 | Montgomery
 | Montour
 | Northampton
 | Northumberland
 | [NAME]
 | Philadelphia
 | Pike
 | Potter
 | [NAME]
 | Snyder
 | Somerset
 | [NAME]
 | Susquehanna
 | Tioga
 | Union
 | Venango
 | [NAME]
 | Washington
 | Wayne
 | Westmoreland
 | Wyoming
 | York
Spreadsheet: 853658d1703583765-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans
Sheet: Step2.1

Search 1 |  | < input field
Search 2 |  | < input field
Search 3 | lumia | < input field |  | words like > |  | watch | 11 | 16 | wat
 |  |  |  | Search1 | Search2 | Search3 |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part | 2nd Sub | 2nd Sub IN | 2nd Part | HEader18
2023-09-13 00:00:00 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  |  | SALMON-50/TC-15 | <Missing
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75 |  | Shown
 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  | 792 | SALMON-50/TC-15 | <[NAME] by [NAME]
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 6

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
[NAME]: Chalk-It-Up Tag Clothespins |  |  |  |  | 24 | 0.88 | 21.12
CD952C | C) Natural [NAME] | 775749194951 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tag Clothespins |  |  |  |  | 24 | 0.88 | 21.12
CD952D | D) Chalk Bracket Border | 775749194968 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tag Clothespins |  |  |  |  | 24 | 0.88 | 21.12
CD952E | E) Moustache | 775749195354 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953A | A) [NAME] | 775749199789 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953B | B) Bag Tag | 775749199796 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953C | C) Heart | 775749199802 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953D | D) Star | 775749199819 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953E | E) Cloud | 775749199826 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/[NAME] |  |  |  |  | 24 | 0.88 | 21.12
CD953F | F) Bracket Border | 775749199833 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/Jute Cord x6 |  |  |  |  | 24 | 0.88 | 21.12
CD955A | A) Arrow | 775749199703 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tags w/Jute Cord x6 |  |  |  |  | 24 | 0.88 | 21.12
CD955B | B) Moustache | 775749199710 | CHINA | 9610.00.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960A | A) Neon Blue | 775749191349 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960B | B) Neon Pink | 775749191356 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960C | C) Neon Yellow | 775749191363 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960D | D) Neon Green | 775749191370 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960E | E) White | 775749191387 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960F | F) Neon Orange | 775749194203 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
[NAME] | G) Electric Blue | 775749203172 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960H | H) Hot Pink | 775749203189 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960I | I) Deep Purple | 775749203196 | KOREA | 9609.90.0000
[NAME]: Chalk Writer Blister-Carded |  |  |  |  | 36 | 0.98 | 35.28
CD960J | J) Silver | 775749203202 | KOREA | 9609.90.0000
Spreadsheet: 1ca304b6-5fd9-43b3-b092-8b8b9795e7f7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15a. MERCHANDISE EXPORTS, State and Australia, FOB Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829245L | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829246R | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829247T | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829248V | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829249W | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829250F | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829251J | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829252K | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A1829253L | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Re-exports ; |  |  | Original | A1829254R | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Total (State of origin) ; |  |  | Original | A1829255T | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 818152d1676623332-sum-return-look-daily-and-return-weekly-copy-of-psr-daily-report-2023
Sheet: Critical MC lost time

DATE | DEPARTMENT | Description | TIME LOST
2022-10-18 00:00:00 | Maintenance | [NAME] washes down due to being cleaned under temp | 120
2022-10-19 00:00:00 | Maintenance | Saftey kleen wash down due to door broken | 55
2022-10-24 00:00:00 | Maintenance | Blaster | 90
2022-10-24 00:00:00 | Maintenance | Bar polisher | 60
2022-10-25 00:00:00 | Maintenance | [NAME] washes down due to being cleaned under temp | 120
Spreadsheet: 713594d1610819243-translating-multiple-column-index-to-other-work-sheets-film-tester-1-
Sheet: Directors

Director | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME]
[NAME]
The Coen Brothers
[NAME]
[NAME]
Tyler Nilson, [NAME]
[NAME] Coppola
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tyler Nilson
Spreadsheet: 72357d1273042913-conditional-formatting-scheduledoc
Sheet: Intended output

 |  |  |  |  |  |  |  |  |  |  |  | Allocations
Course Name | Course Code | Semester | Category | Site | Min pers | [NAME] | Training days | Start Date | Finish Date | Application Close date | Late Application date | Company X | Company Y | Company Z | Other | Total
Course A | 123456 | Autumn | Networks | South | 4 | 8 | 10 | 2010-05-03 00:00:00 | 2010-05-15 00:00:00 | 2010-04-03 00:00:00 | 2010-04-26 00:00:00 |  | 4 | 2 | 2 | 8
Course A | 123456 | Winter | Networks | City | 4 | 8 | 10 | 2010-07-28 00:00:00 | 2010-07-15 00:00:00 | 2010-06-28 00:00:00 | 2010-07-21 00:00:00 | 2 |  | 4 | 2 | 8
Course A | 123456 | Spring | Networks | South | 4 | 8 | 10 | 2010-11-19 00:00:00 | 2010-11-03 00:00:00 | 2010-10-19 00:00:00 | 2010-11-12 00:00:00 |  | 4 | 2 | 2 | 8
Course A | 123456 | Summer | Networks | TBA | 4 | 8 | 10
Course B | 123457 | Autumn | Software | City | 8 | 12 | 5 | 2010-05-03 00:00:00 | 2010-05-08 00:00:00 | 2010-04-03 00:00:00 | 2010-04-26 00:00:00 |  | 2 | 2 | 2 | 6
Course B | 123457 | Spring | Software | City | 8 | 12 | 5 | 2010-09-03 00:00:00 | 2010-09-08 00:00:00 | 2010-08-03 00:00:00 | 2010-08-27 00:00:00 |  | 2 | 2 | 2 | 6
Course C | 123458 | autumn2 |  |  |  |  |  | date 1 | date2 | xx | xx | xx | x
Course C | 123458 | [NAME] |  |  |  |  |  | date 1 | date2 | xx | xx | xx | x
Course C | 123458 | [NAME] |  |  |  |  |  | date 1 | date2 | xx | xx | xx | x | x | x | x
Course C | 123458 | spring2 |  |  |  |  |  | date1 | date2 | xx | xx | xx | x
etc
etc
etc
etc……..
Spreadsheet: 266391d1379598686-how-to-lookup-values-on-a-table-and-get-column-headers-for-filtered-criteria-function-help
Sheet: Sheet1

DESIRED OUTPUT |  |  | In need of the ability to look up the part on the PARTSMODELS table
part | model |  | for options in the MODELS FILTER only:
76532 | C227E |  | If there is a >0 value in the part/model matrix, then put model values under model column
128817 | C232 |  | otherwise, leave blank
128819 | C232 C227E
 |  |  | note: there are 91 columns and 2500 rows in the complete PARTSMODELS table
 |  |  | note: the models filter helps us know what parts go with only a certain selection of models
 |  |  | note: some of the parts could go on all 91 models, so we use the models filter
 | PARTSMODELS
 | model |  |  |  |  |  |  |  |  | MODELS FILTER
part | C227 | C227 NR | C227 T4B | C227E | C232 | C232 NR | C232 T4A |  |  | C232
76344 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | C227E
76347 | 1 | 1 | 1 | 1 | 1
76350 | 2 | 2 | 2 | 2 | 2 | 2 | 2
76352 | 1 | 1 | 1 | 1
84570 | 1 | 1 | 1 | 1 | 1 | 1 | 1
86071 | 2 | 2 | 2 | 2 | 2 | 2 | 2
86526 |  |  |  |  | 1 | 1 | 1
100197 |  |  |  |  | 1 | 1 | 1
128817 |  |  |  |  | 1
128819 | 1 | 1 | 1 | 1 | 1 | 1 | 1
144124
Spreadsheet: 734967d1622624680-data-validation-across-multiple-sheets-convalida_dati
Sheet: foglio_2

123456808 | asder1
123456809 | asder2
123456810 | asder3
123456811 | asder4
123456812 | asder5
123456813 | [NAME]
123456814 | [NAME]
123456815 | asder8
123456816 | asder9
123456817 | asder10
123456818 | asder11
123456819 | asder12
123456820 | asder13
123456821 | [NAME]
123456822 | asder15
123456823 | [NAME]
123456824 | asder17
123456825 | asder18
123456826 | asder19
123456827 | asder20
Spreadsheet: 832455d1686330536-count-if-consecutive-values-are-true-skipping-blanks-formula-hansd-1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. # consecutive TRUEs:
 |  | VALUE | FORMULA |  |  |  |  |  | VALUE | HD | GLENN
 |  | False |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | True
 |  | False |  |  |  |  |  |  | False
 |  | False
 |  | True |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | False
 |  | True
 |  | True |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | True
 |  | False
 |  | True |  |  |  |  |  |  | True
 |  | True |  |  |  |  |  |  | True
 |  | False |  |  |  |  |  |  | True
 |  | True
 |  | True |  |  |  |  |  |  | False
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: November 3 & 4, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-11-03 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Financial Gas

 | Financial Gas
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 1
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000 | 2
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 06178bd6-4b3c-4559-872c-28861372c353
Sheet: Sheet1

Table 6.1: Number of [NAME] by country and year | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Country | 2000 | 2005 | 2010
Bahrain | 2 | 2 | …
Egypt | … | … | 54 (2009)
Iraq | 16 (2001) | … | …
Jordan | 4 | 4 | 4
Kuwait | … | … | …
Lebanon | … | … | …
Oman | 8 | 8 | 9
Palestine | 10 | 5 | …
Qatar | 5 (1999) | 5 | 4
Saudi Arabia | … | … | …
Sudan | … | 17 (2006) | 15(2009)
Syrian Arab Republic | … | … | …
United Arab Emirates | 7 | … | …
Yemen | … | 13 | 16 (2009)