tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873318d1719821900-counting-between-dates-and-extra-criteria-excel-help
Sheet: Reporting_2024

 |  |  |  |  |  |  |  |  |  |  | REPORTING - DFR (SOUTH Wales) 2024
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Flood Risk Activity Permits |  | INTERNAL |  | Jan | Feb | March | April | May | June | July | Aug | Sep | Oct | Nov | Dec |  | Yearly total to date | Outcome |  |  |  |  |  |  |  | Column1 | Column2 | Permit Type | Permit Holder | Site Address | Activity Description | Activity Category | Decision | Determination Date
 |  |  | Number of Flood Risk Activity Permit Applications Received
 |  |  | EXTERNAL |  | Jan | Feb | March | April | May | June | July | Aug | Sep | Oct | Nov | Dec |  | Yearly total to date | Outcome
 |  |  | Number of Flood Risk Activity Permit Applications Received
Spreadsheet: 800158d1665507774-variable-cell-references-xxx
Sheet: Sheet1

 | Date | Data
 | 2022-01-10 00:00:00 | 111
 | 2022-01-11 00:00:00 | 99
 | 2022-01-12 00:00:00 | 123
 | 2022-01-13 00:00:00 | 106
 | 2022-01-14 00:00:00 | 101
 | 2022-01-15 00:00:00 | 97
 | 2022-01-16 00:00:00 | 121
 | 2022-01-17 00:00:00 | 115 |  | Enter Count here -> |  | 7
 | 2022-01-18 00:00:00 | 105 |  | As of
 | 2022-01-19 00:00:00 | 121 |  | Since
 | 2022-01-20 00:00:00 | 119 |  | Average
 | 2022-01-21 00:00:00 | 118
 | 2022-01-22 00:00:00 | 107
 | 2022-01-23 00:00:00 | 104 |  | How do I get the "As of" and "Since" dates and the "Average" number to update automatically as new rows ar added to the bottom or the "Count" is changed
 | 2022-01-24 00:00:00 | 112
 | 2022-01-25 00:00:00 | 115
 | 2022-01-26 00:00:00 | 98
Spreadsheet: daren_farmer__5623__HPLN1212
Sheet: Sheet1

HPLN1212.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 12, 2000
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
HPL (FM) |  | LS HPL [NAME] |  | HPL | 30 | 30
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: e0333dca-d2ed-4743-8fa4-8757c6f00d73
Sheet: Sheet1

Adults Ages 18 Years and Over, Who Always Use a Seatbelt, by Selected Demographics, Maine 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Unweighted Number | Weighted Number | % | LCL | UCL
Sex
 | Female | 4466 | 481215.757188225 | 89.61755689200321 | 88.2473993937446 | 90.98771439026181
 | Male | 2445 | 379182.2104652913 | 76.68635586239424 | 74.51925658146318 | 78.8534551433253
Age
 | 18-24 | 149 | 79616.88428350662 | 71.09416416219295 | 64.08621031863264 | 78.10211800575327
 | 25-34 | 415 | 115433.7409246872 | 79.18968590374487 | 74.97419066994819 | 83.40518113754155
 | 35-44 | 789 | 140533.5965821121 | 81.62877665524249 | 79.04212145666236 | 84.21543185382262
 | 45-54 | 1466 | 184121.4346642002 | 86.49735578018517 | 83.854871060014 | 89.13984050035634
 | 55-64 | 1726 | 154159.8632142451 | 85.69169537815188 | 83.88795883544576 | 87.495431920858
 | 65+ | 2322 | 183043.2380505035 | 89.33376281779823 | 88.03373777328105 | 90.63378786231543
Education
 | Did not graduate High School | 434 | 52744.44300087342 | 81.18991203833608 | 76.19223256247994 | 86.1875915141922
 | Graduated High School | 2261 | 272954.7025448743 | 79.28529057909151 | 76.69494855363507 | 81.87563260454793
 | Attended College or Technical School | 1723 | 220917.1017423543 | 82.6386407207953 | 80.0385977993241 | 85.2386836422665
 | Graduated from College or Technical School | 2480 | 312731.0249784791 | 88.38919384054083 | 86.81215667471697 | 89.96623100636468
Income
 | Less than $15,000 | 772 | 73361.74309267655 | 78.0743064480765 | 72.12134508516334 | 84.02726781098964
 | $15,000 to less than $25,000 | 1172 | 126055.7063063102 | 82.09068794132845 | 78.85948806078953 | 85.32188782186738
 | $25,000 to less than $35,000 | 721 | 83693.903548314 | 83.18680005973496 | 79.44000849473653 | 86.93359162473341
 | $35,000 to less than $50,000 | 938 | 119653.8449307959 | 80.81281053729373 | 77.77365617435059 | 83.85196490023688
 | $50,000 or more | 2496 | 352876.1962886836 | 86.27809097410999 | 84.47145978326024 | 88.08472216495974
Data Source: Behavioral Risk Factor Surveillance System % = Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 56850d1256967429-radio-button-campaign_radio
Sheet: Tactics Q2

Initiative Name | Campaign Owner | Campaign Owner | Campaign Name – Standard | IO Number | Activity Owner | 30th Oct09 | 27th Aug09
Accelerate Exchange and Establish UC | ammeht | ammeht | Exchange Upgrade Program | 5612806 | ammeht | 8717.4929
Accelerate Exchange and Establish UC | Ritu | Ritu | Accelerate Exchange and Establish UC | 5612807 | ammeht | 12204.4902
Accelerate Exchange and Establish UC | Ritu | Ritu | Accelerate Exchange and Establish UC | 5612808 | ammeht | 42759.3051
Antipiracy Initiatives | vipuls | vipuls | Genuine Software Initiative (GSI) | 8049139 | rkatari | 240000.4769
Antipiracy Initiatives | vipuls | vipuls | Genuine Software Initiative (GSI) | 5612540 | ksdhakad | 152556.1266
Antipiracy Initiatives | vipuls | vipuls | Genuine Software Initiative (GSI) | 5612533 | [NAME] | 458055.7376
Antipiracy Initiatives | vipuls | vipuls | Genuine Software Initiative (GSI) | 5612534 | [NAME] | 643880.3379
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: IANUARIE

 |  |  | 6 morti
 |  | NR. CRT | DATA | NR. CAPETE | GREUTATE VIU | [NAME] | LOT | GREUTATE CARCASA CALAFAT | GREUTATE CARCASA DTS | GREUTATE CARCASA CU CAP | GREUTATE ORGANE | Randament
 |  | 1 | 2022-01-17 00:00:00 | 4 |  |  |  |  |  |  | 9.8
 |  | 2 | 2022-01-20 00:00:00 | 4 | 388 |  |  |  | 298 |  | 9.5
 |  | 3 | 2022-01-21 00:00:00 | 2 | 194 |  |  | 149 |  |  | 5.1
 |  | 4 | 2022-01-22 00:00:00 | 4 | 389 |  |  |  | 298 |  | 8.5
 |  | 5 | 2022-01-23 00:00:00 | 5 | 490 |  |  |  |  |  | 10
 |  | 6 | 2022-01-25 00:00:00 | 5 | 485 |  |  |  |  |  | 10.5
 |  | 7 | 2022-01-27 00:00:00 | 9 | 894 |  |  |  | 680 |  | 18
 |  | 8 | 2022-01-29 00:00:00 | 4 | 392 |  |  | 301 |  |  | 8.4
 |  | 9 | 2022-01-31 00:00:00 | 4 | 392 |  |  | 302 |  |  | 9.7
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | Total
Spreadsheet: 788285d1658384056-split-data-with-filter-xml-function-xml-filter
Sheet: Blad1

original | subsstring 1 | subsstring 2 | subsstring 3 | subsstring 4 | subsstring 5 | subsstring 6 | subsstring 7
10,20,30,40,50,60,70
15,20,30,40,50,60,71
10,20,30,40,50,60,72
10,20,30,40,50,60,73
10,20,30,40,50,60,74
16,20,30,40,50,60,75
10,20,30,40,50,60,76
10,20,30,40,50,60,77
10,20,30,40,50,60,78
10,20,30,40,50,60,79
Spreadsheet: 136327d1326542177-cell-sum-according-to-criteria-apa
Sheet: Week 2

 | [NAME] |  | Monday APA League 2012
 | VS.
 | Team | Player Name | Games Must win | 8-Break | 8-B & Run | Safty | Won | Lost
 |  | [NAME] |  |  |  |  |  | L
 |  | Team Played |  | Wins |  | Loss
Spreadsheet: 758046d1638603668-finding-missing-numbers-in-an-array-and-concatenating-them-into-one-cell-see-sheet-2
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 |  |  | RESULT
 | unwatnedtext Room 1 | unwatnedtext Room 2 | unwatnedtext Room 1 | unwatnedtext Room 1 | unwatnedtext Room 2 |  | Room 1 |  | <------ is present in this row !
 | unwatnedtext Room 2 | unwatnedtext Room 3 | unwatnedtext Room 2 | unwatnedtext Room 2 | unwatnedtext Room 3 |  | Room 2 |  | <------isn't present in this row !
 | unwatnedtext Room 1 | unwatnedtext Room 3 | unwatnedtext Room 3 | unwatnedtext Room 1 | unwatnedtext Room 3 |  | Room 3
Spreadsheet: 480723d1474034966-formula-for-see-data-a-k-excel-formula
Sheet: Main

 |  |  |  |  | September
 |  |  |  |  | Names | Location | Grade | Level | Date
 |  |  |  |  | Looking for a formula for automate my sheet.
 |  |  |  |  | This is a temporary file given for example. In this file In Main sheet If I select Particular month then below table data should be change automatically.
 |  |  |  |  | this data should be pulled from Data sheet. All data should be pulled for particular months
 |  |  |  |  | In Data sheet every month data will be added, So kindly help how can do this.
Spreadsheet: 867835d1714633424-copy-the-format-from-the-adjacent-cell-problem-cf-aligw
Sheet: Sheet1

 |  | [NAME] |  |  | [NAME]
 |  | UUU746560102316 |  |  | UUU746560102316
 |  | UUU746560202625 |  |  | UUU746560202625
 |  | UUU746560402641 |  |  | UUU746560402641
 |  | TTT8484301776
 |  | TTT8484405501
 |  | [NAME]
Problem - |  | TTT838482625
 | 6288 | [NAME] |  | 6288 | [NAME]
 | 2316 | UUU746560102316 |  | 2316 | UUU746560102316
 | 2625 | UUU746560202625 |  | 2625 | UUU746560202625
 | 2641 | UUU746560402641 |  | 2641 | UUU746560402641
 | 1776 | TTT8484301776
 | 5501 | TTT8484405501
 | 4912 | [NAME]
 | 2625 | TTT838482625
 |  | [NAME] |  |  | [NAME]
 |  | UUU746560102316 |  |  | UUU746560102316
 |  | UUU746560202625 |  |  | UUU746560202625
 |  | UUU746560402641 |  |  | UUU746560402641
 |  | TTT8484301776
 |  | TTT8484405501
 |  | [NAME]
 |  | TTT838482625
Spreadsheet: 35284f0b-8bab-4713-8fbf-9fd89453a1e3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-05 09:52:39.950000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.327 | 102.202 | 102.077 | 101.702
4.75 | 101.82 | 101.695 | 101.57 | 101.195 |  | Note: | Refer To Price [NAME]
4.625 | 101.076 | 100.951 | 100.826 | 100.451 |  |  | For all Price Adjs
4.5 | 100.142 | 100.017 | 99.892 | 99.267
4.375 | 99.156 | 99.031 | 98.906 | 98.281
4.25 | 98.412 | 98.287 | 98.162 | 97.537
4.125 | 97.577 | 97.452 | 97.327 | 96.702
4 | 96.548 | 96.423 | 96.298 | 95.673 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.566 | 102.441 | 102.316 | 101.941
3.875 | 101.834 | 101.709 | 101.584 | 101.209
3.75 | 101.125 | 101 | 100.875 | 100.5
3.625 | 100.705 | 100.58 | 100.455 | 100.08
3.5 | 100.177 | 100.052 | 99.927 | 99.302
3.375 | 99.423 | 99.298 | 99.173 | 98.548
3.25 | 98.694 | 98.569 | 98.444 | 97.819 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-12-19 09:52:39.950000
30 DAY | 2014-01-03 09:52:39.950000
45 DAY | 2014-01-18 09:52:39.950000
60 DAY | 2014-02-02 09:52:39.950000
90 DAY | 2014-03-04 09:52:39.950000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 99148d1297878485-pop-up-menu-appears-when-certain-option-is-picked-uploadtest_5
Sheet: Failure Analysis Report

 |  |  | FAILURE REPORT
 |  |  | CUSTOMER NAME: |  | [NAME] |  |  |  |  |  |  | UNIT NUMBER: |  | 5007110 |  | DATE: | 2/16/2011
 |  |  | WELL NAME & LOCATION: |  |  | ECA KAKWA 16-16-62-6 |  |  |  |  |  | STATION: | Grande_Prairie
 |  |  | UWI: | 100/ 16-16-062-06w6 |  |  |  |  | PROVINCE: | Alberta |  | CALMENA SUPERVISOR: |  |  | W Andrews |  | C Szeszorak
FIELD TICKET NUMBER: |  | 2109 | CUSTOMER REPRESENTATIVE: |  |  |  | [NAME] |  |  |  |  | BLASTERS CERTIFICATE NUMBER: |  |  |  | 9019
FAILURE TYPE |  |  |  | FAILURE INVESTIGATION REQUIREMENTS |  |  |  |  |  |  |  |  |  | LOST TIME HOURS
[NAME] |  |  |  | • Failed Component ID #  • Log Data   • Photos (if required)
Failure Description:
[NAME]
Field Correction Action:
lalalalalalalalfjklfj;afoaesjt
Spreadsheet: 29726d1224791864-bin-location-counting-for-inventory-copy-of-example
Sheet: Dis. Oct - 08

 | Consumables Distributed - Red River College |  |  |  |  |  | Month: | 2008-10-01 00:00:00
 | Model | Description | Supply  Number | Qty | Serial # | Date | Name | Location | Phone #
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD731308 | 2008-09-29 00:00:00 | [NAME] | F2-10A | 632-2499
 | WorkCentre 5655 | Staples | 108R00493 | 1 | [NAME] | 2008-09-29 00:00:00 | [NAME] | AB Copy Centre | 632-2039
 | WorkCentre 5655 | Staples | 108R00493 | 1 | WTD731357 | 2008-10-02 00:00:00 | [NAME] | M2-21 | 953-1860
 | WorkCentre 5655 | Toner | 6R1046 | 1 | [NAME] | 2008-10-01 00:00:00 | [NAME] | AB Copy Centre | 632-2039
 | WorkCentre 4150 | Toner | 6R01274 | 1 | L99359497 | 2008-10-06 00:00:00 | [NAME] | Outside E3-16 | 632-2444
 | WorkCentre 5655 | Staples | 108R00493 | 1 | [NAME] | 2008-10-07 00:00:00 | [NAME] | J1-12 | 632-2037
 | WorkCentre 5655 | Staples | 108R00493 | 2 | WTD728895 | 2008-10-07 00:00:00 | [NAME] | B2-01A | 632-3814
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD730372 | 2008-10-08 00:00:00 | [NAME] | C3-12 | 632-2319
 | WorkCentre 5655 | Toner | 6R1046 | 1 | [NAME] | 2008-10-10 00:00:00 | [NAME] | AB Copy Centre | 632-2039
 | WorkCentre 5655 | Staples | 108R00493 | 1 | [NAME] | 2008-10-14 00:00:00 | [NAME] | AB Copy Centre | 632-2039
 | WorkCentre 4150 | Toner | 6R01274 | 1 | L99359536 | 2008-10-14 00:00:00 | [NAME] | B1-01 | 632-2579
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD728895 | 2008-10-15 00:00:00 | [NAME] | B2-01A | 632-3814
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD728874 | 2008-10-15 00:00:00 | [NAME] | Across from C6-19 | 632-3750
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD729079 | 2008-10-16 00:00:00 | Patti-Ann Goods | C1-19B | 632-2188
 | WorkCentre 4150 | Toner | 6R01274 | 1 | [NAME] | 2008-10-20 00:00:00 | [NAME] | FM-28 | 632-2452
 | WorkCentre 5655 | Staples | 108R00493 | 1 | WTD731293 | 2008-10-20 00:00:00 | [NAME] | A4-25 | 632-2241
 | WorkCentre 5655 | Toner | 6R1046 | 1 | [NAME] | 2008-10-21 00:00:00 | [NAME] | J1-12 | 632-2037
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD731344 | 2008-10-22 00:00:00 | [NAME] | F2-15A | 632-2499
 | WorkCentre 5655 | Staples | 108R00493 | 1 | [NAME] | 2008-10-23 00:00:00 | [NAME] | AB Copy Centre | 632-2039
 | WorkCentre 5655 | Toner | 6R1046 | 1 | WTD730378 | 2008-10-23 00:00:00 | [NAME] | C2-11 | 632-2366
Spreadsheet: 885331d1734822965-index-match-depending-on-multiples-values-from-multiples-drop-down-lists-and-columns-index-match-if-or-switch-function-in-table-without-sensitive
Sheet: DATA

 |  |  |  |  |  |  | RM | RM
 |  |  |  |  |  |  |  |  |  | RM | RM
 |  |  |  |  |  |  |  |  |  |  |  |  | RM | RM
 |  | MP | Column1 | Column17 | Column16 | Column164 | Column165 | Column1653 | Column1642 | Column166 | Column167 | Column1643 | Column162 | Column1622 | Column172 | Column163 | Column1644 | Column1655 | Column16536 | Column16429 | Column16610 | Column16711 | Column164314 | Column16215 | Column162216 | Column173 | Column169 | Column16410 | Column16511 | Column165312 | Column164215 | Column16616 | Column16717 | Column164320 | Column16221 | Column162222 | Column163922
 |  | SAMPLE 1 |  | 2.8 | 10 | 20 |  |  | 20 |  |  |  |  |  | 23 | 10 |  |  |  |  |  |  |  |  |  | 2 | 3
 |  | SAMPLE 2 |  | 0.5 | 2 | 150 |  |  | 150 |  |  |  |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  | 0.8 | 1.5
 |  | SAMPLE 3 |  | 1 | 2 | 700 |  |  | 700 |  |  |  |  |  | 8 | 2 |  |  |  |  |  |  |  |  |  | 0.5 | 1
 |  | SAMPLE 4 |  | 8 | 15 | 13.33333333333333 |  |  | 13.33333333333333 |  |  |  |  |  | 13 | 15 |  |  |  |  |  |  |  |  |  | 3 | 5
 |  | SAMPLE 5 |  | 0.2 | 1 |  |  |  |  |  |  |  |  |  | 0.9 | 1.8 |  |  |  |  |  |  |  |  |  | 4 | 6
 |  | SAMPLE 6 |  | 2.3 | 5 |  |  |  |  |  |  |  |  |  | 9.6 | 1.2 |  |  |  |  |  |  |  |  |  | 0 | 2.5
 |  | SAMPLE 7 |  | 3 | 8 | 75 |  |  | 75 |  |  |  |  |  | 1 | 8 |  |  |  |  |  |  |  |  |  | 0 | 2.5
 |  | SAMPLE 8 |  | 4.5 | 8 |  |  |  |  |  |  |  |  |  | 1 | 8 |  |  |  |  |  |  |  |  |  | 35 | 45
 |  | SAMPLE 9 |  | 3 | 5 | 120 |  |  | 120 |  |  |  |  |  | 6.9 | 9
 |  | SAMPLE 10 |  | 5.5 | 12 |  |  |  |  |  |  |  |  |  | 1 | 12
 |  | SAMPLE 11 |  | 2 | 22 |  |  |  |  |  |  |  |  |  | 9 | 22
 |  | SAMPLE 12 |  | 8 | 10 | 70 |  |  | 70 |  |  |  |  |  | 1 | 10
 |  | SAMPLE 13 |  | 0.1 | 2.5 |  |  |  |  |  |  |  |  |  | 0.95 | 2.5
 |  | SAMPLE 14 |  | 1.6 | 2.6 |  |  |  |  |  |  |  |  |  | 3.6 | 2.6
 |  | SAMPLE 15 |  | 9.5 | 18 |  |  |  |  |  |  |  |  |  | 4.6 | 18 |  |  |  |  |  |  |  |  |  | 1 | 2
 |  | SAMPLE 16 |  | 9 | 1 |  |  |  |  |  |  |  |  |  | 20 | 1
 |  | SAMPLE 17 |  | 12 | 19 |  |  |  |  |  |  |  |  |  | 1 | 0.56
 |  | SAMPLE 18 |  | 9 | 3 |  |  |  |  |  |  |  |  |  | 4 | 12 |  |  |  |  |  |  |  |  |  | 27 | 35
 |  | SAMPLE 19 |  | 3.6 | 2.36 |  |  |  |  |  |  |  |  |  | 5.6 | 2.36
 |  | SAMPLE 20 |  | 5 | 10 |  |  |  |  |  |  |  |  |  | 1 | 23 |  |  |  |  |  |  |  |  |  | 3 | 6
 |  | SAMPLE 21 |  | 1.6 | 4 |  |  |  |  |  |  |  |  |  | 6 | 4
Spreadsheet: 57336d1257439281-subtotals-in-a-pivot-table-book1
Sheet: Pivot

Sum of USD Amount
Location | Full Name | Item | Total
Argentina | [NAME], [NAME] | Auto | 14130
Germany | Murphy, [NAME] | Auto | 19218
 |  | Childcare | -812
Italy | Smith, [NAME] | Auto | 29111
Netherlands | Marks, Carol | Entertainment | 2112
 | Johnston, Kath | Entertainment | 2567
 | Ryder, [NAME] | Entertainment | 1199
 | Wilson, George | Entertainment | 1744
Spain | [NAME], [NAME] | Auto | 1147
 | Becker, [NAME] | Auto | 1028
 | [NAME], [NAME] | Auto | 4480
 | Mendoca, [NAME] | Auto | 362
Grand Total |  |  | 76286
Spreadsheet: 00906b8a-6f25-48f7-8a5a-b3569f763a62
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 15b. MERCHANDISE [NAME], State and Australia, Customs 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 | A1829564W | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829565X | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829566A | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829567C | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829568F | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829569J | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829570T | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829571V | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A2529326T | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
Total (State of Final Destination) ; |  |  | Original | A1829572W | 1988-01-01 00:00:00 | 2012-01-01 00:00:00 | 289 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 126122d1319537978-if-statement-help-io-cargo-tracker
Sheet: Current IO Cargoes

 | Current Cargo Holding Positions
 | Origin | Status | Grade | Type | Quantity (tons) | Purchase Date | Purchase Price (CFR) | Market Price | P/L USD | Vessel Name | Date of Shipment | Expected Date of Arrival | CBW/High-Seas | Arrived at CBW | Storage Period At Present (Days) | Cost of CBW At Present
 | Malaysian |  | 61/60 | Fines | 42000 | DBT | 159 |  |  | JinHaiYu | June | 2011-08-30 00:00:00 | Tianjin | 2011-08-30 00:00:00
 | Goa |  | 62/62 | Fines | 57600 | DBT | 179 |  |  | Bintan Star | August | 2011-09-22 00:00:00 | Caofeidian | 2011-09-22 00:00:00
 | Iranian |  | 61 | B&L Fines | 53000 | DBT | 157 | 118 |  | Namrun | August | 2011-09-21 00:00:00 | [NAME] | 2011-09-19 00:00:00
 | Iranian |  | 57 | B&L Fines | 53000 | DBT | 119 | 95 |  | Namrun | August | 2011-09-21 00:00:00 | [NAME] | 2011-09-19 00:00:00
Renegotiating | Kandla |  | 58/58 | Fines | 55000 | DBT | 125 | 108 |  | DBT | 2011-10-10 00:00:00 | 2011-10-25 00:00:00 | Xiamen | 2011-10-24 00:00:00 | -
 | [NAME] |  | 59/59 | Fines | 50000 | 2011-09-15 00:00:00 | 160 |  |  | DBT | DBT | DBT | DBT | - | -
 | Number of Cargoes
 | Maximum Position (WMT) |  |  |  | 375000
 | Position Available (WMT)
 | Present Costs
 | Unrealized Losses
Spreadsheet: scott_neal__37939__STOR9818
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9818
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-02-09 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 277 | 267
(TX, LA, OK, KS, MS)
Market Area - East |  | 657 | 592
Market Area - West |  | 202 | 182
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 106519d1303792031-multiple-if-match-data-across-sheets-mis-format
Sheet: Database

UCC | Cust ID | Account number | Client Name | RM Name | [NAME] | ZH Name
3 | 1 | 45 | ABC Ltd
4 | 2 | 46 | ABC Ltd
5 | 3 | 47 | XYZ Ltd
6 | 4 | 48 | XYZ Ltd