tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12026__Feb01
Sheet: Table2a

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (BCF) |  |  | ($US/MMBTU) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 |  |  | VARIATION |  |  | VARIATION | 1999/11 | 2000/11 | VARIATION | 1999/11 | 2000/11 | VARIATION
 | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN %
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 79.3 | 58.9 | -25.8 | 2.65 | 5.55 | 109.1 | 318.7 | 265 | -16.9 | 2.62 | 5.8 | 121.3
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 143.3 | 143.9 | 0.4 | 2.43 | 6.28 | 159 | 548.6 | 641.2 | 16.9 | 2.42 | 7.01 | 189.2
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 68.9 | 97.7 | 41.9 | 2.58 | 6.81 | 164.2 | 327.4 | 460.7 | 40.7 | 2.48 | 7.5 | 202.1
TOTAL - TERM/TERME | 291.6 | 300.5 | 3.1 | 2.52 | 6.31 | 150.2 | 1194.7 | 1366.9 | 14.4 | 2.49 | 6.94 | 178.5
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 57.2 | 46.5 | -18.7 | 2.26 | 7.63 | 237.3 | 247.9 | 217.4 | -12.3 | 2.36 | 7.35 | 211
MIDWEST/MIDWEST | 105.2 | 107.7 | 2.4 | 2.4 | 6.04 | 151.2 | 438.2 | 508 | 15.9 | 2.37 | 6.6 | 178.5
MOUNTAIN/ROCHEUSES | 4.3 | 0.9 | -78.6 | 2.3 | 3.84 | 66.8 | 12.2 | 5.3 | -56.3 | 2.25 | 4.71 | 109.5
NORTHEAST/NORD-EST | 83.1 | 97.4 | 17.3 | 2.97 | 6.1 | 105.7 | 320.6 | 446.4 | 39.2 | 2.84 | 6.67 | 135
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 41.8 | 48 | 14.9 | 2.33 | 6.12 | 162.9 | 175.7 | 189.8 | 8 | 2.37 | 8.08 | 240.9
TOTAL - REGION/RÉGION | 291.6 | 300.5 | 3.1 | 2.52 | 6.31 | 150.2 | 1194.7 | 1366.9 | 14.4 | 2.49 | 6.94 | 178.5
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 24.7 | 22.1 | -10.4 | 2.78 | 4.71 | 69.53 | 94.8 | 82.9 | -12.5 | 2.78 | 4.92 | 77.3
LDC/SDL | 77.7 | 65.3 | -16.1 | 2.54 | 6.11 | 140.17 | 313.6 | 295.4 | -5.8 | 2.54 | 6.57 | 158.6
MARKETING CO./DISTRIBUTEURS | 178.7 | 202.9 | 13.5 | 2.5 | 6.59 | 162.96 | 742.7 | 932.1 | 25.5 | 2.45 | 7.34 | 199.5
PIPELINE/PIPELINES | 10.4 | 10.2 | -67.3 | 2.08 | 5.24 | 151.58 | 43.4 | 49.7 | 14.3 | 2.24 | 5.26 | 134.4
TOTAL - CUSTOMER TYPE/CLIENT | 291.6 | 300.5 | 3.1 | 2.52 | 6.31 | 150.2 | 1194.7 | 1366.9 | 14.4 | 2.49 | 6.94 | 178.5
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED AVERAGE |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 207827d1358570461-using-the-values-in-last-column-to-return-the-values-in-the-first-column-basic-materials
Sheet: Nonmetallic Mineral Mining

Stock Quotes Provided by MSN Money
Click here to visit MSN Money |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AHGP
 |  |  | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market [NAME] | EPS | P/E Ratio | # [NAME] Out |  | AXU
Alliance Holdings GP LP | Chart | News | 49.98 | 50.02 | 50.74 | 49.94 | 29487 | -0.04 | -0.0008 | 54.4 | 36.97 | 2991952713 | 3.26 | 15.3 | 59863000 |  | CHGS
Alexco Resource Corp | Chart | News | 4.18 | 4.08 | 4.2 | 4.08 | 282559 | 0.1 | 0.0245 | 8.48 | 3.21 | 252592792 | 0.04 | 97.4 | 60428900 |  | HNRG
China Gengsheng Minerals Corp | Chart | News | 0.32 | 0.3 | 0.32 | 0.3 | 7123 | 0.02 | 0.0607 | 1.19 | 0.28 | 8576973 | -0.63 |  | 26803040 |  | HWD
Hallador Energy Co | Chart | News | 8.02 | 8.02 | 8.08 | 7.97 | 8496 | 0 | 0 | 11 | 6.55 | 227350973 | 0.97 | 8.3 | 28348000 |  | LLEN
[NAME] | Chart | News | 14.91 | 14.53 | 14.93 | 14.56 | 397001 | 0.38 | 0.0262 | 16.14 | 10.54 | 1265605964 | 0.43 | 33.9 | 84883030 |  | MDM
L & L Energy Inc | Chart | News | 1.75 | 1.72 | 1.77 | 1.74 | 106351 | 0.03 | 0.0174 | 3.25 | 1.3 | 65616775 | 0.6 | 3 | 37495300 |  | RNO
Mountain Province Diamonds Inc | Chart | News | 4.05 | 4.09 | 4.15 | 4.05 | 8650 | -0.04 | -0.0098 | 5.69 | 3.13 | 381381025 | -0.06 |  | 94168150 |  | SCOK
Rhino Resource Partners LP | Chart | News | 15.65 | 15.16 | 15.65 | 15.2 | 43064 | 0.49 | 0.0323 | 21.93 | 12.11 | 433957274 | 0.85 | 17.8 | 27728900 |  | WLB
[NAME] And Coke Chemical Industries Inc | Chart | News | 1.17 | 1.16 | 1.17 | 1.11 | 26880 | 0.01 | 0.0086 | 3.25 | 1.12 | 24712002 | 0.23 | 5.1 | 21121370
[NAME] | Chart | News | 10.02 | 9.99 | 10.05 | 9.9 | 29738 | 0.03 | 0.003 | 12.93 | 6.94 | 141907856 | -1.16 |  | 14162460
Symbol Lookup |  | MSN Money Home |  |  |  | Microsoft Office Tools on the Web
Find stocks, mutual funds, options, indices, and currencies. |  | Discover MSN Money's tools, columns, and more! |  |  |  | Get the latest from Microsoft Office
Terms of Use. © 2013 Microsoft Corporation and/or its suppliers. All rights reserved.
DATA PROVIDERS
Copyright © 2013 Microsoft. All rights reserved.
Quotes are real-time for NASDAQ, NYSE and AMEX. See delay times for other exchanges.
Fundamental company data and historical chart data provided by Thomson Reuters (click for restrictions). Real-time quotes provided by BATS Exchange. Real-time index quotes and delayed quotes supplied by Interactive Data Real-Time Services. Fund summary, fund performance and dividend data provided by Morningstar Inc. Analyst recommendations provided by Zacks Investment Research. StockScouter data provided by Verus Analytics. IPO data provided by Hoover's Inc. Index membership data provided by SIX Telekurs.
Japanese stock price data provided by Nomura Research Institute Ltd.; quotes delayed 20 minutes. Canadian fund data provided by CANNEX Financial Exchanges Ltd.
AHGP
AXU
CHGS
HNRG
HWD
LLEN
MDM
RNO
SCOK
WLB
Spreadsheet: 765844d1643636446-add-extra-filter-to-aggregate-report-example
Sheet: ORDERDISPLAY

 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44
 | Week | Day | Date | Status | Client | Destination | Pallets |  | Boxes |  | Content | Units | Formaat | Product | Land of origin | Bio | Certification | Class | Pallet | Fust | Tussen pallet | Branding | Sticker | Labeling | Palletkrt | Loading | Weighing | Lot | Order number | Trace | Price [NAME] | Pakwerk | Price/kg Branding | Price/kg Transport | Invoiced | Claim KG negative | Fust Total | Total KG | Total value | Intra Comm. | GN8 Code | Vervoers wijze | Transactie aard
 | 1 | MA | 2022-01-03 00:00:00 | SENT | TEST1 |  | 5 | x | 65 | x | 10 | [NAME] | 800-1200 | OR | NL | BIO | [NAME] | II | Euro | CBL 15 | No |  |  |  |  |  |  | L0501 | 1100343342 | QC01 | 1.9 | No | 0.05 | 0.08 | No |  | 325 | 3250 | 6175 | Yes | 07099390 | 3 | 11
 | 1 | DI | 2022-01-04 00:00:00 | OPEN | TEST2 |  | 5 | x | 48 | x | 10 | st | 1400-2200 | ZAD | EG | BIO | Naturland | I | Export | Netzak | No |  |  |  |  |  | 150 |  | 141612 | AJ | 2 | No | 0.03 |  | No |  | 240 | 150 | 300 | No | 12079920 | 3 | 11
 | 1 | WO | 2022-01-05 00:00:00 | FINISH | TEST3 |  | 5 | x | 99 | x | 14 | st | 8-12/6-8pcs | OR | NZ | BIO | QS | III | Pool | CBL 23 | No |  |  |  |  |  | 18200 |  |  | JB86 | 1.6 | No | 0.06 |  | No |  | 495 | 18200 | 29120 | Yes | 07099390 | 3 | 11
 | 1 | DO | 2022-01-06 00:00:00 | [NAME] | TEST4 |  | 5 | x | 68 | x | 100 | [NAME] | M | KAB | IT |  |  | I | Export | EPS 186 | No |  |  |  |  |  |  | L06D | 6546546 | TC | 2 | Yes |  |  | No | -200 | 0 | -400 | -800 | No | 07099390 | 3 | 21
 | 1 | VR | 2022-01-07 00:00:00 | RETURN | TEST5 |  | 5 | x | 52 | x | 900 | [NAME] | L | SP | RSA | BIO | [NAME] | II | Euro | EPS 156 | No |  |  |  |  |  |  |  | 464658475 | TE1 | 0.89 | No |  |  | No |  | -260 | -234000 | -208260 | Yes | 07099390 | 3 | 21
 | 1 | ZA | 2022-01-08 00:00:00 | CANCEL | TEST6 |  |  | x | 20 | x | 200 | [NAME] | XL | BN | DE | BIO | QS | I | [NAME] | EPS 246 | No |  |  |  |  |  |  |  | 16484 | B12 | 0.83 | Yes | 0.08 |  | No |  | 0 | 0 | 0 | No | 07099390 | 3
 | 2 | DI | 2022-02-01 00:00:00 | CHANGE | TEST7 |  | 5 | x | 5 | x | 1 | st | S | OR | DE | BIO | [NAME] | I | Euro | IFCO BL | No |  |  |  |  |  |  |  | 16546 | QC03 | 1 | No | 0.05 | 0.09 | No |  | 25 | 25 | 25 | Yes | 07099390 | 3 | 11
Spreadsheet: tori_kuykendall__39975__pasadena dec
Sheet: Sheet 1

City of Pasadena
Dec 2000 Invoice
 |  |  |  |  |  |  |  |  |  |  |  | Gas Daily | Gas Daily | Gas Daily | Gas Daily
 |  |  |  |  |  |  | Gas Daily | SoCal | Pasadena |  | Pasadena | Purchases | Purchases | Sales | Sales
[NAME] | 14.08 |  |  |  |  | Date | Mid | Usage | Net Nom | APEA | Imbalance | from EPMI | from EPMI | to EPMI | to EPMI
IFGMR EP San Juan | 6 |  |  |  |  |  | $/MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | $ | MMBtu | $
 |  |  |  |  |  | 2001-12-01 00:00:00 | 18.895 | 10218 |  | 3000
 |  |  |  | Amount |  | 2001-12-02 00:00:00 | 18.495 | 12984 |  | 3000
 | Border | Basin |  | Due |  | 2001-12-03 00:00:00 | 18.495 | 11363 |  | 3000
Pasadena | MMBtu | MMBtu | $/MMBtu | $ |  | 2001-12-04 00:00:00 | 18.495 | 12127 |  | 3000
Nomination |  |  |  |  |  | 2001-12-05 00:00:00 | 21.605 | 12149 |  | 3000
Fixed Price Nomination | 0 | ( this deal was sold back to enron for Dec.) |  |  |  | 2001-12-06 00:00:00 | 26.595 | 13800 |  | 3000
APEA Nomination |  |  |  |  |  | 2001-12-07 00:00:00 | 36.245 | 10710 |  | 3000
Net Nomination |  |  |  |  |  | 2001-12-08 00:00:00 | 42.02 | 13046 |  | 3000
 |  |  |  |  |  | 2001-12-09 00:00:00 | 54.655 | 15872 |  | 3000
Usage |  |  |  |  |  | 2001-12-10 00:00:00 | 54.655 | 10555 |  | 3000
Less APEA Usage |  |  |  |  |  | 2001-12-11 00:00:00 | 54.655 | 16772 |  | 3000
Net Usage |  |  |  |  |  | 2001-12-12 00:00:00 | 59.42 | 11687 |  | 3000
 |  |  |  |  |  | 2001-12-13 00:00:00 | 32.745 | 6437 |  | 3000
Gas Supply |  |  |  |  |  | 2001-12-14 00:00:00 | 20.26 | 11765 |  | 3000
NGI Purchases |  |  |  |  |  | 2001-12-15 00:00:00 | 19.03 | 13693 |  | 3000
Fixed Price Purchases | 25000 |  | 5.94 |  |  | 2001-12-16 00:00:00 | 17.06 | 10594 |  | 3000
Fixed Price Sold back to Enron | 25000 |  | 15.85 |  |  | 2001-12-17 00:00:00 | 17.06 | 12070 |  | 3000
Gas Daily Purchases from Enron |  |  |  |  |  | 2001-12-18 00:00:00 | 17.06 | 11405 |  | 3000
Gas Daily Sales to Enron |  |  |  |  |  | 2001-12-19 00:00:00 | 20.39 | 14507 |  | 3000
 |  |  |  |  |  | 2001-12-20 00:00:00 | 19.56 | 11588 |  | 3000
 |  |  |  |  |  | 2001-12-21 00:00:00 | 20.355 | 10893 |  | 3000
Kern River Station Purchases | 124496 |  |  |  |  | 2001-12-22 00:00:00 | 18.98 | 10411 |  | 3000
Total Purchases |  |  |  |  |  | 2001-12-23 00:00:00 | 18.025 | 7508 |  | 3000
El Paso Capacity Reimbursement |  |  |  |  |  | 2001-12-24 00:00:00 | 18.025 | 5433 |  | 3000
Fixed | 121472 |  |  |  |  | 2001-12-25 00:00:00 | 18.025 | 3834 |  | 3000
Variable |  |  |  |  |  | 2001-12-26 00:00:00 | 18.025 | 4187 |  | 3000
 |  |  |  |  |  | 2001-12-27 00:00:00 | 18.78 | 9670 |  | 3000
Net Due |  |  |  |  |  | 2001-12-28 00:00:00 | 16.635 | 9459 |  | 3000
 |  |  |  |  |  | 2001-12-29 00:00:00 | 14.44 | 6900 |  | 3000
El Paso Capacity Reimbursement | $/MMBtu |  |  |  |  | 2001-12-30 00:00:00 | 14.44 | 5071 |  | 3000
 |  |  |  |  |  | 2001-12-31 00:00:00 | 14.44 | 4282 |  | 3000
[NAME] |  |  |  |  |  | Totals
IFGMR San Juan
Spread
 | -0.015
Less Fuel
Less Variable | -0.026
Net Reservation Value
Spreadsheet: 265862d1379426847-copy-and-paste-the-data-one-sheet-to-another-sheet-if-the-condition-is-true-copy-and-paste-the-row-with-condition-one-to-other-sheet
Sheet: Sheet1

SL | EMP ID | DOJ | DEPT
1 | 12341 | 2010-09-17 00:00:00 | HR
2 | 12342 | 2010-09-17 00:00:00 | HR
3 | 12343 | 2010-09-17 00:00:00 | OPS
4 | 12344 | 2010-09-17 00:00:00 | OPS
5 | 12345 | 2010-09-17 00:00:00 | HR
Spreadsheet: 866879d1713797944-listing-data-from-one-sheet-to-another-while-liming-number-of-entries-sample-267-dv-restriction-aligw-bekwiet-
Sheet: main

parent | child | week 1 | week 2 | week 3
Lopez | [NAME] | W8 | W3 | W6
White | [NAME] | [NAME] | W8 | W1
Barnes | Jodi | W4 | W5 | W7
Fillmore | [NAME] | W8 | W1
[NAME] | Mark | W1 | [NAME]
Money | Shane
Fern | [NAME]
Spreadsheet: 821322d1678621005-similars-first-4-letters-same-similar-specials-001
Sheet: Sheet1

PERIGONE |  |  | LEPORENI |  | =LET(rng,A1:A20,a,UNIQUE(rng),r,[NAME],y,VSTACK(x,LET(m,INDEX(a,[NAME],DROP(a,y), IFERROR(m&"|"&FILTER(n,(LEFT(n,5)=LEFT(m,5))*(ISNUMBER( MAP(n,LAMBDA(s,SUM(FIND(MID(RIGHT(m,3),SEQUENCE(3),1), [NAME]"))
LEPORINE |  | LEPORINE | LEPORIEN
PEPERINO |  | PEPERINO | PEPERONI
PEPERONI |  | PEPERINO | PEPERNOI
RONEPIPE |  | PEPERINO | PEPERNIO
ISOPRENE |  | PEPERINO | PEPERION
PEREIONS |  | PEPERONI | PEPERNOI
PIONEERS |  | PEPERONI | PEPERNIO
PEPERNOI |  | PEPERONI | PEPERION
PEPERNIO |  | PEPERNOI | PEPERNIO
PEPERION |  | PEPERNOI | PEPERION
PEPERNOI |  | PEPERNIO | PEPERION
PEPERNOI |  | LEPORENI | LEPORIEN
PEPEIRON
PEPEONIR
PEPEONIR
ISOPRENE
ISOPRENE
LEPORENI
LEPORIEN
Spreadsheet: 105699d1302972042-vlookup-isnt-working-holdings-based-syle-hw-terri-lapointe
Sheet: Select

Schedule | of | Investments
DIAMOND | HILL | SELECT | FUND
2011-02-28 00:00:00
Net | Assets: | $ | 45390239 |  |  |  |  |  |  |  |  |  |  |  |  | $ Holdings
Cusip | Ticker | Security | Description | Shares | Market | Value | % | of | Net | Assets |  |  |  |  | Ticker | DH Select
205887102 | CAG | CONAGRA | FOODS | INC | 77143 | 1786632 | 0.0394
871829107 | SYY | SYSCO | CORP | 60105 | 1670318 | 0.0368
46625H100 | JPM | JPMORGAN | CHASE | & | CO | 34970 | 1632749 | 0.036
37411105 | APA | APACHE | CORP | 12900 | 1607598 | 0.0354
260003108 | DOV | [NAME] | CORP | 24115 | 1549389 | 0.0341
949746101 | WFC | WELLS | FARGO | & | CO | 47610 | 1535899 | 0.0338
25179M103 | DVN | DEVON | ENERGY | CORP | 16565 | 1514704 | 0.0334
585055106 | MDT | MEDTRONIC | 36501 | 1457120 | 0.0321
913017109 | UTX | UNITED | TECHNOLOGIES | CORP | 17315 | 1446495 | 0.0319
674599105 | OXY | OCCIDENTAL | PETROLEUM | CORP | 14055 | 1433188 | 0.0316
171798101 | XEC | CIMAREX | ENERGY | CO | 11945 | 1387173 | 0.0306
452308109 | ITW | ILLINOIS | TOOL | WORKS | INC | 24938 | 1349146 | 0.0297
742718109 | PG | PROCTER | & | GAMBLE | CO | 20565 | 1296623 | 0.0286
91324P102 | UNH | UNITEDHEALTH | GROUP | INC | 28352 | 1207228 | 0.0266
717081103 | PFE | PFIZER | 62215 | 1197017 | 0.0264
9158106 | APD | AIR | PRODUCTS | & | CHEMICALS | 12975 | 1193700 | 0.0263
71813109 | BAX | BAXTER | INTL | 22390 | 1190029 | 0.0262
902973304 | USB | US | BANCORP | DELAWARE | 42760 | 1185735 | 0.0261
2824100 | ABT | ABBOTT | LABS | 23670 | 1138527 | 0.0251
744320102 | PRU | PRUDENTIAL | FINANCIAL | INC | 16950 | 1115819 | 0.0246
478160104 | JNJ | [NAME] | & | [NAME] | 18015 | 1106842 | 0.0244
G0585R106 | AGO | ASSURED | GUARANTY | LTD | 74630 | 1084374 | 0.0239
594918104 | MSFT | MICROSOFT | 40055 | 1064662 | 0.0235
58933Y105 | MRK | MERCK | & | CO | INC | 32670 | 1064062 | 0.0234
32511107 | APC | ANADARKO | PETROLEUM | CORP | 12025 | 984006 | 0.0217
8.9417e+113 | TRV | TRAVELERS | COS | INC | 16260 | 974462 | 0.0215
88579Y101 | MMM | 3M | CO | 10310 | 950891 | 0.0209
580135101 | MCD | MCDONALD'S | CORP | 12095 | 915350 | 0.0202
370334104 | GIS | GENERAL | MILLS | INC | 24505 | 910116 | 0.0201
713448108 | PEP | PEPSICO | INC | 13815 | 876147 | 0.0193
931142103 | WMT | WAL-MART | STORES | INC | 16290 | 846754 | 0.0187
04621X108 | AIZ | ASSURANT | INC | 17895 | 727074 | 0.016
G0450A105 | ACGL | [NAME] | CAPITAL | GROUP | 7810 | 706805 | 0.0156
Y93691106 | VRGY | VERIGY | LTD | 53730 | 696878 | 0.0154
30225X103 | EXH | EXTERRAN | HLDGS | INC | 24815 | 563301 | 0.0124
845467109 | SWN | SOUTHWESTERN | ENERGY | CO | 11680 | 461126 | 0.0102
701094104 | PH | PARKER-HANNIFIN | CORP | 5140 | 458385 | 0.0101
17275R102 | CSCO | CISCO | SYSTEMS | INC | 22470 | 417043 | 0.0092
Spreadsheet: 83685d1283701525-filling-cells-based-on-two-criteria-book3_vxg
Sheet: Sheet2

fyear | cusip | conm | total assets
1997 | 87588Q109 | TANOX INC
1998 | 87588Q109 | TANOX INC | 43.422
1999 | 87588Q109 | TANOX INC | 55.328
2000 | 87588Q109 | TANOX INC | 290.978
2001 | 87588Q109 | TANOX INC | 277.534
2002 | 87588Q109 | TANOX INC | 251.211
1996 | 64115J106 | NETSOLVE INC
1997 | 64115J106 | NETSOLVE INC | 13.227
1998 | 64115J106 | NETSOLVE INC | 14.936
1999 | 64115J106 | NETSOLVE INC | 74.519
2000 | 64115J106 | NETSOLVE INC | 62.831
2001 | 64115J106 | NETSOLVE INC | 67.861
2002 | 64115J106 | NETSOLVE INC | 60.99
Spreadsheet: 878040d1725007821-text-joining-with-multiple-criteria-ian-mcpherson-example9-365-aligw
Sheet: Sheet1

1 | Sponsored by |  | Sponsored by [NAME] (Name1, Name2, Name3, Name4)
 | [NAME]
 | Name1 | Name3
 | [NAME] | Name4
2 | Sponsored by |  | Sponsored by [NAME] (Name1)
 | [NAME]
 | Name1
3 | Sponsored by |  | Sponsored by [NAME] (Name1, Name2)
 | [NAME]
 | Name1
 | [NAME]
4 | Sponsored by |  | Sponsored by [NAME] (Name1, Name2, Name3)
 | [NAME]
 | Name1 | Name3
 | [NAME]
5 | Sponsored by |  | Sponsored by Name1
 | Name1
6 | Sponsored by |  | Sponsored by Name1, Name2
 | Name1
 | [NAME]
7 | Sponsored by |  | Sponsored by Name1, Name2, Name3
 | Name1 | Name3
 | [NAME]
8 | Sponsored by |  | Sponsored by Name1, Name2, Name3, Name4
 | Name1 | Name3
 | [NAME] | Name4
9 | Sponsored by |  | Sponsored by [NAME]
 | [NAME]
Spreadsheet: 808128d1670317959-apply-different-penalty-rates-over-a-24-hr-period-pay-calculator_rev-08d-mike-geraghty-
Sheet: Penalty Rate Calculator

CALCULATOR # 1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!!
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES PRO-RATA ON AN HOURLY BASIS STARTING BEFORE 6.59AM AND FINISHING AFTER 7:00AM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM |  |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM
 |  | 1st. HALF |  |  |  |  |  |  |  | ROUNDED |  | 2nd. HALF |  |  |  |  |  |  |  | ROUNDED
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  |  |  | Start | End | Total | Normal | Penalty | Roundup | PAY VALUE
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:40:00
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
CALCULATOR # 2.
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES THAT START BEFORE 5:00PM AND FINISH AFTER 8:00PM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS
 |  | 1st. HALF |  |  |  |  |  |  |  |  |  | 2nd. HALF
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!!
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
Spreadsheet: 140083d1328620078-massive-if-together-with-date-formula-ef29_microsoft-excel-worksheet
Sheet: Sheet1

Year: | 4 |  |  |  |  |  |  |  |  | 4 | 4
 |  |  | Question is how to make date of return have fixed month and day |  |  |  |  |  |  | 5 | 3
Date of issue: |  |  | but change year depending on the year |  |  |  |  |  |  | L6 | 2
Required date of return: |  |  | 4 = +4 years |  |  |  |  |  |  | U6 | 1
 |  |  | 5 = +3 years
 |  |  | L6 = +2 yers
 |  |  | U6 = +1 year
 |  |  | This also only applies if today's date is not more that 31 december, because if
 |  |  | it is january, than;
 |  |  | 4 = +3 years
 |  |  | 5 = +2 years
 |  |  | L6 = +1 year
 |  |  | U6 = same year
Spreadsheet: 412d98b5-731d-4385-8d41-b5d7cc8a0907
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
 | 5671.0 Lending Finance, Australia
 | TABLE 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011