tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08b31235-fcae-4677-9f23-e8bdbf374516
Sheet: Sheet1

BADMINTON WORLD FEDERATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
PLAYER LOCATION FORM
QUARTERLY UPDATE: January to March 2011
Return to BWF before the start of the Quarter
All information is kept confidential and is solely for the use of BWF and WADA.  Please type or print legibly and be as accurate and thorough as possible.
PLAYER INFORMATION |  |  | BWF Player Number:
[NAME]
Family Name: |  |  |  | Given Name(s):
Gender: |  |  |  | Date of birth:
Home Address:
Telephone No: |  |  |  | Mobile No:
Fax No: |  |  |  | Email address:
Days when you do not train but will be at your primary address should be filled in with an A (Residence) on the Quarterly Schedule.
Daily Schedule
We realise that it is difficult for you to know where you will be for each day of the forthcoming quarter, but your best estimate will help significantly.
[NAME]
Name & Address:
Main Training Location Schedule:
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
AM
PM
Periods when you train according to the above mentioned should be filled in with an B (Main Training Location) on the Quarterly Schedule.
C. Secondary Training Location
Name & Address:
Secondary Training Location Schedule:
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
AM
PM
Periods when you train according to the above mentioned should be filled in with a C (Secondary Training Location) on the Quarterly Schedule.
D. Other Regularly Scheduled Activities
(work, school, etc.)
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
AM
PM
Periods when you regularly participate in other activities should be filled in with a D Other Regularly Scheduled Activities) on the Quarterly Schedule.
 |  |  |  |  | Page 1 of 3
Spreadsheet: 682665d1592244242-nested-if-statement-not-multiplying-formula-by-the-designated-cell-error-issue
Sheet: Sheet1 (3)

Commission Tier | [NAME] | [NAME] | Commission [NAME] | Commission Min | Commission Max
Tier 1 | 0 | 9999.99 | 0.15 | 0
[NAME] | 10000 | 29999.99 | 0.16
Tier 3 | 30000 | 49999.99 | 0.17
[NAME] | 50000 | 70000 | 0.18
 |  |  |  | F2+(B11-9999.99)*D3
Rate Calculator | Value
Revenue Generated | 30000 | <--- This cell can be edited to produce the comission calculation below
Comission Due |  | <--- This is the cell where the issue with the IF Statements is happening
Spreadsheet: 850853d1701182150-shading-weekend-cloumns-meeting-rooms
Sheet: November 2024

 | 2024-11-01 00:00:00 | 2024-11-02 00:00:00 | 2024-11-03 00:00:00 | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-09 00:00:00 | 2024-11-10 00:00:00 | 2024-11-11 00:00:00 | 2024-11-12 00:00:00 | 2024-11-13 00:00:00 | 2024-11-14 00:00:00 | 2024-11-15 00:00:00 | 2024-11-16 00:00:00 | 2024-11-17 00:00:00 | 2024-11-18 00:00:00 | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00 | 2024-11-25 00:00:00 | 2024-11-26 00:00:00 | 2024-11-27 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-11-30 00:00:00
 | 2024-11-01 00:00:00 | 2024-11-02 00:00:00 | 2024-11-03 00:00:00 | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-09 00:00:00 | 2024-11-10 00:00:00 | 2024-11-11 00:00:00 | 2024-11-12 00:00:00 | 2024-11-13 00:00:00 | 2024-11-14 00:00:00 | 2024-11-15 00:00:00 | 2024-11-16 00:00:00 | 2024-11-17 00:00:00 | 2024-11-18 00:00:00 | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00 | 2024-11-25 00:00:00 | 2024-11-26 00:00:00 | 2024-11-27 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-11-30 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 709037d1608138391-how-to-use-countifs-to-check-partial-contents-of-a-cell-and-also-multiple-criteria-in-range-testbook-1-
Sheet: Sheet1

Name | Task | ID# | Location
[NAME] | A | 4 | Top
[NAME] | A | 2 | Top |  | Total # of Task A for Top & Bottom:
[NAME] | B | 12 | Bottom
[NAME] | B | 14 | Top |  | Total # of Task B for Side:
[NAME] | A | 7 | Front
[NAME] | B | 99 | Side |  | Total # of Tasks A & C for Front
[NAME] | B | 71 | Front
[NAME] | A | 41 | Bottom |  | Total # of Tasks A & B for Side & Top:
[NAME] | B | 22 | Front
Sandy | C | 20 | Bottom
[NAME] | C | 19 | Top
[NAME] | A | 51 | Side
George | C | 0 | Front
[NAME] | A | 6 | Bottom
[NAME] | B | 44 | Side
[NAME] | C | 65 | Top
[NAME] | A | 25 | Bottom
[NAME] | B | 60 | Front
[NAME] | A | 33 | Side
[NAME] | C | 8 | Top
Spreadsheet: 847558d1698419171-bulk-substitute-in-a-spilling-array-bulk-substitute
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty |  | ID:aze|Size:32|Label:rty
Spreadsheet: 125436d1319031012-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-copy-of-afhendingase-lar-and-loadinfo-1-1
Sheet: ULD9&10

9 |  |  |  |  |  |  | 10
Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 4494dfa0-2515-43e8-bbf6-ab961fd9db43
Sheet: Sheet1

Release: Employment Cost Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=11
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-25 9:05 PM CDT
 | Real-Time | Period
Name: | Start | End
Employment Cost Index | 1996-10-29 00:00:00 | Current
Link:
http://www.bls.gov/ncs/ect/ | 1996-10-29 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 1996-10-29 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
1996-10-29 00:00:00
1997-01-28 00:00:00
1997-04-29 00:00:00
1997-07-29 00:00:00
1997-10-28 00:00:00
1998-01-27 00:00:00
1998-04-30 00:00:00
1998-07-30 00:00:00
1998-10-29 00:00:00
1999-01-28 00:00:00
1999-04-29 00:00:00
1999-07-29 00:00:00
1999-10-28 00:00:00
2000-01-28 00:00:00
2000-04-27 00:00:00
2000-07-27 00:00:00
2000-10-26 00:00:00
2001-01-25 00:00:00
2001-04-26 00:00:00
2001-07-26 00:00:00
2001-10-25 00:00:00
2002-01-31 00:00:00
2002-04-25 00:00:00
2002-07-25 00:00:00
2002-10-31 00:00:00
2003-01-30 00:00:00
2003-04-24 00:00:00
2003-04-29 00:00:00
2003-07-31 00:00:00
2003-10-30 00:00:00
2004-01-29 00:00:00
2004-04-29 00:00:00
2004-07-29 00:00:00
2004-10-29 00:00:00
2005-01-28 00:00:00
2005-04-29 00:00:00
2005-07-29 00:00:00
2005-10-28 00:00:00
2006-01-31 00:00:00
2006-04-26 00:00:00
2006-04-28 00:00:00
2006-07-28 00:00:00
2006-10-31 00:00:00
2007-01-31 00:00:00
2007-04-25 00:00:00
2007-04-27 00:00:00
2007-07-31 00:00:00
2007-10-31 00:00:00
2008-01-31 00:00:00
2008-04-29 00:00:00
2008-04-30 00:00:00
2008-07-31 00:00:00
2008-10-31 00:00:00
2009-01-30 00:00:00
2009-04-28 00:00:00
2009-04-30 00:00:00
2009-07-31 00:00:00
2009-10-30 00:00:00
2010-01-29 00:00:00
2010-04-28 00:00:00
2010-04-30 00:00:00
2010-07-30 00:00:00
2010-10-29 00:00:00
2011-01-18 00:00:00
2011-01-28 00:00:00
2011-04-27 00:00:00
2011-04-29 00:00:00
2011-07-29 00:00:00
2011-10-28 00:00:00
2012-01-31 00:00:00
2012-04-25 00:00:00
2012-04-27 00:00:00
2012-07-31 00:00:00
2012-10-31 00:00:00
2013-01-31 00:00:00
2013-04-30 00:00:00
2013-07-31 00:00:00
2013-11-19 00:00:00
2014-01-31 00:00:00
2014-04-28 00:00:00
2014-04-30 00:00:00
2014-07-31 00:00:00
Spreadsheet: 861555d1709445593-to-show-months-without-data-as-well-all-months-to-show
Sheet: Sheet1

Period | Amount |  | Period
2023-10-31 00:00:00 | 90 |  | 2023-10-31 00:00:00
2023-11-30 00:00:00 | 100 |  | 2023-11-30 00:00:00
2024-01-31 00:00:00 | 120 |  | 2023-12-31 00:00:00
2024-01-31 00:00:00 | 919 |  | 2024-01-31 00:00:00
2024-03-31 00:00:00 | 12 |  | 2024-02-29 00:00:00
 |  |  | 2024-03-31 00:00:00
 |  |  | 2024-04-30 00:00:00
 |  |  | 2024-05-31 00:00:00
 |  |  | 2024-06-30 00:00:00
 |  |  | 2024-07-31 00:00:00
 |  |  | 2024-08-31 00:00:00
 |  |  | 2024-09-30 00:00:00
 |  |  | 2024-10-31 00:00:00
 |  |  | 2024-11-30 00:00:00
 |  |  | 2024-12-31 00:00:00
Spreadsheet: 684270d1593251208-excel-table-lookup-named-range-lookup-multi-aligw
Sheet: DCM

Project | Date | Month | Goal | Phase | Threshold | Actual | Difference | Met Obj |  |  | Ref | Project | Goal | Date | Phase | Rule | Threshold
P2 | 2020-06-15 00:00:00 |  | Goal | Phase5 |  | 0.81 |  |  |  |  | P1 | P1 | Goal |  | Phase1 |  | 0.65
P2 | 2020-05-16 00:00:00 |  | Goal | Phase4 |  | 1.81 |  |  |  |  | P2 | P2 | Goal |  | Phase2 |  | 0.89
P2 | 2020-04-15 00:00:00 |  | Goal | Phase3 |  | 0.75 |  |  |  |  | P2 | P2 | Goal |  | Phase3 |  | 1
P2 | 2020-03-15 00:00:00 |  | Goal | Phase3 |  | 0.82 |  |  |  |  | P2 | P2 | Goal |  | Phase4 |  | 0.78
P2 | 2020-02-15 00:00:00 |  | Goal | Phase3 |  | 0.86 |  |  |  |  | P2 | P2 | Goal |  | Phase5 |  | 0.85
P2 | 2020-01-15 00:00:00 |  | Goal | Phase2 |  | 0.86
P1 | 2019-09-15 00:00:00 |  | Goal | Phase1 |  | 0.94
P1 | 2019-08-15 00:00:00 |  | Goal | Phase1 |  | 0.94
P1 | 2019-07-15 00:00:00 |  | Goal | Phase1 |  | 0.95
P1 | 2019-06-15 00:00:00 |  | Goal | Phase1 |  | 0.95
Spreadsheet: 390993d1429820585-calculating-a-due-date-based-on-a-range-of-payment-terms-test-sheet
Sheet: Before

APPLIC | COMPANY | SITE | AMOUNT | DATE | Due Date | Paid | Chq/BACs
1 | ABC | A | 79901 | 2012-01-23 00:00:00
2 | ADA | F | 128158 | 2012-01-24 00:00:00
3 | BCR | K | 135548 | 2012-02-02 00:00:00
4 | ADA | E | 84602 | 2012-02-04 00:00:00
5 | ADA | G | 93270 | 2012-02-05 00:00:00
6 | BCR | L | 103424 | 2012-02-07 00:00:00
7 | ABC | B | 148591 | 2012-02-12 00:00:00
8 | ABC | D | 147058 | 2012-02-13 00:00:00
9 | BCR | K | 18327 | 2012-02-15 00:00:00
10 | ADA | H | 121585 | 2012-02-18 00:00:00
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: 7.5

7.5 | [NAME] of Schwartz (1997) One Factor Model for a European Calendar Spread Option
 | S | a | m | l | s | mhat | K | T | s1 | s2 | N | r
 | 26.9 | 0.472 | 2.925 | 0 | 0.368 |  | 2.04 |  | 0.75 | 1.5 | 10 | 0.1
 | dt | lnS | P(0,T) |  |  |  |  | call_value |  | [NAME] |  | M
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 | t | 0
 | e
 | xt
 |  |  |  |  |  |  |  |  | ST | F(T,s1) | F(T,s2) | CT
 | Trials | [NAME] | e | xterminal | ST | F(T,s1) | F(T,s2) | CT | call
 | 1
Spreadsheet: 30445d1225963181-using-reference-points-through-worksheets-test
Sheet: Sheet1

customer | Origin & Carrier | Agent | Min | <45 | >45 | >100 | >250 | >300 | >500 | >1000 | >2000 | [NAME] | WRS | Xray Fee
 | CANKE | [NAME] |  |  |  | 4.04 |  | 3.89 |  |  |  | 0.45 | 0.15
Spreadsheet: 152521d1335423049-indexing-problem-idexproblem
Sheet: Sheet1

 | Array 1
 | 1 | d |  | a
 | 2 | b |  | b
 | 3 | a
 | 4 | a
 | 5 | b
 | 6 | c
 | 7 | d
 | 8 | a
 | 9 | b
 | 10 | b
 | In the yellow row, the numbers displayed in array 1 next to a letter identical to a letter in the blue array, are displayed. The order does not matter (I displayed them from small to large, but this does not matter).
 | In other words:
 | If a or b from the blue cells are found in Column C, display the corresponding number from Column B in the yellow array.
Spreadsheet: 214360d1360871372-building-complex-sales-projections-could-use-some-help-sales-projections-sample-solution
Sheet: Transaction Volumes

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Transaction Volume | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
Smith & Wesson |  | 1166.666666666667 | 2333.333333333333 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
ABC Company |  |  | 833.3333333333333 | 1666.666666666667 | 2500 | 3333.333333333333 | 4166.666666666667 | 5000 | 5000 | 5000 | 5000 | 5000
Total Transactions | 0 | 1166.666666666667 | 3166.666666666666 | 5166.666666666666 | 6000 | 6833.333333333333 | 7666.666666666667 | 8500 | 8500 | 8500 | 8500 | 8500
Spreadsheet: 756815d1637800160-drop-down-link-to-table-test2
Sheet: CALC SHEET

 |  | I want this column to update to 6min data from Sheet 1 when the drop down menu heading is changed depending on the storm event
 |  |  | Year
 | Intensities (mm/hr) | 1 Year  63% AEP | 1 | 6 min | 59.6
 |  |  |  | 30 min | 25.2
 |  |  |  | 1 hour | 16.3
 |  |  |  | 3 hour | 8.05
 |  |  |  | 6 hour | 5.17
 |  |  |  | 12 hour | 3.32
 |  | 2 Year  50% AEP | 2 | 6 min | 86.8
 |  |  |  | 30 min | 36.6
 |  |  |  | 1 hour | 23.4
 |  |  |  | 3 hour | 11.4
 |  |  |  | 6 hour | 7.36
 |  |  |  | 12 hour | 4.74
 |  | 10 Year  10% AEP |  | 6 min | 102
 |  |  |  | 30 min | 42.9
 |  |  |  | 1 hour | 27.4
 |  |  |  | 3 hour | 13.5
 |  |  |  | 6 hour | 8.72
 |  |  |  | 12 hour | 5.62
 |  | 100 Year  1% AEP |  | 6 min | 157
 |  |  |  | 30 min | 65.5
 |  |  |  | 1 hour | 42.3
 |  |  |  | 3 hour | 21.8
 |  |  |  | 6 hour | 14.5
 |  |  |  | 12 hour | 9.4
 |  |  |  | 24 hour | 5.73
 |  |  |  | 72 hour | 2.32
Spreadsheet: 728931d1618815992-how-to-sumif-with-criteria-sumif-with-criteria
Sheet: Sheet1

 | Qty | Pur / Sold | Sold / not sold | Con | Comment
 | 75 | Pur |  | [NAME] 15000  75
 | -75 | Sold |  | [NAME] 15000  75
 | 75 | Pur |  | [NAME] 15000  75
 | -75 | Sold |  | [NAME] 15000  75
 | 75 | Pur |  | [NAME] 15000  75
 | 75 | Pur |  | [NAME] 15000  75
 | -75 | Sold |  | [NAME] 15000  75
Spreadsheet: 883072d1731563227-automated-chronological-date-sorting-for-completed-bucket-list-goals-sample
Sheet: Bucket List

 |  |  |  | BUCKET LIST
 |  |  |  | Hobby 1
 |  |  |  | Goal | Completed | Date
 |  |  |  | bucket list goal 1 | √ | 2025-05-01 00:00:00
 |  |  |  | bucket list goal 2 | √ | 2024-03-01 00:00:00
 |  |  |  | bucket list goal 3 | √ | 2026-03-01 00:00:00
 |  |  |  | bucket list goal 4 | √ | 2025-01-01 00:00:00
 |  |  |  | bucket list goal 5 | √ | 2024-02-01 00:00:00
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: FG Apr 20

 | Daily |  |  | Last day of month
 |  |  |  | Jan | 800 | 504
2020-04-01 00:00:00 | 1261 | 800 |  | Feb | 800 | 562
2020-04-02 00:00:00 | 1293 | 800 |  | Mar | 800 | 794
2020-04-03 00:00:00 | 1297 | 800 |  | Apr | 800 | 794
2020-04-04 00:00:00 | 1300 | 800 |  | May | 800 | 673
2020-04-05 00:00:00 | 1327 | 800 |  | Jun | 800 | 857
2020-04-06 00:00:00 | 1334 | 800 |  | Jul | 800 | 954
2020-04-07 00:00:00 | 1289 | 800 |  | Aug | 800 | 1036
2020-04-08 00:00:00 | 1311 | 800 |  | Sept | 800 | 982
2020-04-09 00:00:00 | 1243 | 800 |  | Oct | 800 | 1008
2020-04-10 00:00:00 | 1266 | 800 |  | Nov | 800 | 913
2020-04-11 00:00:00 | 1286 | 800 |  | Dec | 800 | 800
2020-04-12 00:00:00 | 1289 | 800 |  | Jan | 800 | 683
2020-04-13 00:00:00 | 1307 | 800 |  | Feb | 800 | 818
2020-04-14 00:00:00 | 1339 | 800 |  | Mar | 800 | 759
2020-04-15 00:00:00 | 1333 | 800 |  | Apr | 800 | 1066
2020-04-16 00:00:00 | 1322 | 800 |  | May | 800 | 1170
2020-04-17 00:00:00 | 1251 | 800 |  | Jun | 800 | 931
2020-04-18 00:00:00 | 1252 | 800 |  | Jul | 800 | 1034
2020-04-19 00:00:00 | 1293 | 800 |  | Aug | 800 | 971
2020-04-20 00:00:00 | 1330 | 800 |  | Sep | 800 | 987
2020-04-21 00:00:00 | 1349.85119 | 800 |  | Oct | 800 | 855
2020-04-22 00:00:00 | 1331.49419 | 800 |  | Nov | 800 | 1041
2020-04-23 00:00:00 | 1341.52203 | 800 |  | Dec | 800 | 1062
2020-04-24 00:00:00 | 1419.13794 | 800 |  | Jan | 800 | 1139
2020-04-25 00:00:00 | 1402.31203 | 800 |  | Feb | 800 | 1291
2020-04-26 00:00:00 | 1433.73703 | 800 |  | Mar | 800 | 1303
2020-04-27 00:00:00 | 1477.13403 | 800 |  | April | 800 | 1376
2020-04-28 00:00:00 | 1404.76503 | 800 |  | May
2020-04-29 00:00:00 | 1370.64379 | 800 |  | June
2020-04-30 00:00:00 | 1361.068929999999 | 800 |  | July
2020-05-01 00:00:00 | 1375.62889 | 800
Total
Spreadsheet: 850294d1700661526-how-to-calculate-multiple-ratios-book1
Sheet: Sheet1

Client no. | Site No. | Sum of Total Pay Hours: | Sum of Total Holiday Hours: | Total | Count | %
720012 | CL20T018 | 20 | 0
720012 | CL20T057 | 20 | 0
720016 | CL20T018 | 20 | 0
720016 | CL20T033 | 21.32 | 0
720020 | CL20T004 | 40 | 0
720020 | CL20T020 | 20 | 0
720021 | CL20T018 | 20 | 0
720021 | CL20T033 | 21.32 | 0
720022 | CL20T007 | 15.5 | 0
720022 | CL20T018 | 20 | 0
720025 | CL20T032 | 25 | 0
720025 | CL20T033 | 21.32 | 0
720029 | CL20T029 | 45 | 0
720029 | CL20T032 | 25 | 0
720033 | CL20T038 | 22.5 | 0
720033 | CL20T081 | 20 | 0
720039 | CL20T031 | 29 | 0
720039 | CL20XT52 | 8 | 0
720046 | CL20T025 | 17.5 | 0
720046 | CL20T077 | 21 | 0
720055 | CL20T039 | 28 | 0
720055 | CL20T044 | 20 | 0
720060 | CL20T020 | 20 | 0
720060 | CL20XT52 | 4 | 0
720064 | CL20T032 | 16 | 0
720064 | CL20T036 | 20 | 0
720067 | CL20T032 | 22.5 | 0
720067 | CL20T042 | 22.5 | 0
720070 | CL20T020 | 25 | 0
720070 | CL20T045 | 25 | 0
720114 | CL20T040 | 30 | 0
720114 | CL20T056 | 40 | 0
720116 | [NAME] | 14 | 0
720116 | CL20T023 | 20 | 0
720120 | CL20T069 | 24 | 0
720120 | CL20T069 | 4 | 0
720128 | CL20T026 | 16 | 0
720128 | CL20T036 | 20 | 0
720147 | CL20T014 | 4 | 0
720147 | CL20T060 | 60 | 0
720148 | CL20T014 | 4 | 0
720148 | CL20T060 | 60 | 0
720158 | CL20T059 | 44 | 0
720158 | CL20T061 | 11 | 0
720162 | CL20T061 | 32 | 0
720162 | CL20T062 | 42 | 0
720163 | CL20T062 | 8 | 0
720163 | CL20T063 | 84 | 0
720170 | CL20T065 | 14 | 0
720170 | CL20T081 | 20 | 0
720173 | [NAME] | 32 | 0
720173 | CL20T081 | 18 | 0
720177 | CL20T033 | 16 | 0
720177 | CL20T034 | 18 | 0
720186 | [NAME] | 20 | 0
720186 | CL20T084 | 20 | 0
720189 | [NAME] | 40 | 0
720189 | [NAME] | 40 | 0
720205 | CL20T018 | 20 | 0
720205 | CL20T020 | 20 | 0
Spreadsheet: 792143d1660751022-find-detail-value-according-to-customer-code-find-detail-value-according-to-customer-code
Sheet: Sheet1

Time | Invoice | Customer code | Name | Product | Quantity |  | Result
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | Bánh quy | 1 |  |  |  | No1 | No1 | No1 | No2 | No2 | No2 | No3 | No3 | No3 | No4 | No4 | No4 | No5 | No5 | No5 | No6 | No6 | No6 | No7 | No7 | No7 | No8 | No8 | No8 | No9 | No9 | No9
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | 3 |  | Customer code | Name | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] socola | 4 |  | [NAME] | [NAME] | [NAME] | 3 | 8 | A03100 | 4 | 8 | A04100 | 3 | 16 | A06100 | 6 | 37 | A01200 | 1 | 10 | A02200 | 1 | 1 | A03200 | 1 | 10 | A12200 | 1 | 1 | A15200 | 1 | 10
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] socola | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh láng | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME] ngọt | 9
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME] | 4
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | Bánh nhân | 3
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy | 2
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt | 3
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt | 4
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh dứa | 5
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh nhân | 8
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh chíp | 9
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh bông lan | 5
2022-02-01 00:00:00 | A01200 | [NAME] | [NAME] | Bánh gối | 10
2022-02-02 00:00:00 | A02200 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-02-03 00:00:00 | A03200 | [NAME] | [NAME] | Bánh sữa | 10
2022-02-05 00:00:00 | A11200 | KH009 | Anh Hòa
2022-02-12 00:00:00 | A12200 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-02-15 00:00:00 | A15200 | [NAME] | [NAME] | Bánh sữa | 10
Spreadsheet: scott_neal__37850__STOR9790
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9790
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-07-28 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 |  | 468 | 484
(TX, LA, OK, KS, MS)
Market Area - East |  | 1019 | 1068
Market Area - West |  | 370 | 368
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