tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: larry_campbell__21308__LFC0700V1
Sheet: ELZ E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
ELZ | E | 2000 |  | CUSTOM ALLOY |  | dth | 4400 |  |  |  |  | CUSTOM ALLOY CORP
ELZ | E | 2000 |  | GATX |  | dth | 11000 |  |  |  |  | GATX CORP
ELZ | E | 2000 |  | JANSEN |  | dth | 500 |  |  |  |  | JOHNSON & JOHNSON(Jansen)
ELZ | E | 2000 |  | MARGATE |  | dth | 1100 |  |  |  |  | MARGATE TENANT CORP
ELZ | E | 2000 |  | MARRIOTT-000 |  | dth | 0 |  |  |  |  | MARRIOTT LAUNDRY [PHONE]-001
ELZ | E | 2000 |  | MARRIOTT-015 |  | dth | 5500 |  |  |  |  | MARRIOTT LAUNDRY [PHONE]-001
ELZ | E | 2000 |  | MIDDLESEX |  | dth | 1600 |  |  |  |  | MIDDLESEX COUNTIES UTILITIES(Pump)
ELZ | E | 2000 |  | SBLINDEN |  | dth | 27000 |  |  |  |  | SB LINDEN
ELZ | E | 2000 |  | GTSCOMM |  | dth | 6000 |  |  |  |  | Med,Mul,Mul,Perth,Rolex,Solar,[NAME]
Spreadsheet: 35264d1232817476-within-2-day-lookup-and-ss-ss-2daylookup
Sheet: Sheet1

 |  |  |  |  |  |  | Table A |  |  |  |  |  | Table B
 |  |  |  |  |  | Date | Name | SS# | Status |  |  | Date | Name | SS# | Status
 |  |  |  |  |  | 2008-07-01 00:00:00 | [NAME] | 555 | OP |  |  | 2009-07-02 00:00:00 | [NAME] | 555 | [NAME] Here
 |  |  |  |  |  | 2008-07-02 00:00:00 | [NAME] | 555 | OP |  |  | 2008-07-03 00:00:00 | [NAME] | 555 | [NAME] Here
 |  |  |  |  |  | 2009-08-05 00:00:00 | [NAME] | 555 | IP |  |  | 2009-08-07 00:00:00 | [NAME] | 777 | [NAME] Here
 |  |  |  |  |  | 2009-08-06 00:00:00 | [NAME] | 555 | IP |  |  | 2009-09-07 00:00:00 | [NAME] | 777 | [NAME] Here
 |  |  |  |  |  | 2009-09-05 00:00:00 | [NAME] | 777 | OP
 |  |  |  |  |  | 2009-09-06 00:00:00 | [NAME] | 777 | IP
 |  |  |  |  |  | Trying to find formula that uses the SS# and a date within 2 days of each other that
 |  |  |  |  |  | compares table B with A and pull the status from Table A….
 |  |  |  |  |  | So in table B [NAME]'s status on 7/2 and 7/3 should be OP since the Soc # matches and the days
 |  |  |  |  |  | are within two days of each other.
 |  |  |  |  |  |  |  |  |  | Table B
 |  |  |  |  |  |  |  |  | Date | Name | SS# | Status
 |  |  |  |  |  |  |  |  | 2009-07-02 00:00:00 | [NAME] | 1 | OP
 |  |  |  |  |  |  |  |  | 2008-07-03 00:00:00 | [NAME] | 1 | OP
 |  |  |  |  |  |  |  |  | 2009-08-07 00:00:00 | [NAME] | 2 | IP
 |  |  |  |  |  |  |  |  | 2009-09-07 00:00:00 | [NAME] | 2 | IP
Spreadsheet: 14a6a2cb-da64-4544-9b06-81609e724330
Sheet: Sheet1

Table S12.  qRT- PCR.  Relative expression of selected genes when R. flavefaciens FD-1 is grown on cellulose or cellobiose as a substrate. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Substrate | [NAME] or Manatee i.d. | [NAME] | Mean Quantity | Normalized Quantity | Relative Expression
Cellobiose | ORF03896 | SIGN-GH11-CBM22-GH10-DOC-GH11-CE4 (tetrafunctional xylanase) | 7.56E-05 ± 5.93E-05 | 0.0136 | 1
 | ORF03925 | SIGN-GH48_DOC (exo-glucanase) | 1.99E-02 ± 1.51E-02 | 3.57 | 1
 | ORF03114 | scaA | 2.01E-01 ± 2.05E-01 | 36.17 | 1
 | [NAME] | [NAME] | 6.60E-03 ± 1.67E-02 | 1.19 | 1
 | ORF04112 | SIGN-UNK-DOC | 6.18E-02 ± 7.12E-02 | 11.12 | 1
 | gyrA | DNA gyrase, A subunit | 5.56E-03 ± 4.66E-03 | 1 | -
Cellulose | ORF03896 | SIGN-GH11-CBM22-GH10-DOC-GH11-CE4 (tetrafunctional xylanase) | 8.07E-03 ± 7.54E-03 | 5.21 | 383.55
 | ORF03925 | SIGN-GH48_DOC (exo-glucanase) | 1.75E-01 ± 6.26E-02 | 112.87 | 31.59
 | ORF03114 | scaA | 2.10E-01 ± 2.38E-01 | 135.59 | 3.75
 | [NAME] | [NAME] | 1.09E-02 ± 1.21E-02 | 7.02 | 5.91
 | ORF04112 | SIGN-UNK-DOC | 6.00E-05 ± 6.18E-05 | 0.0388 | 0.00349
 | gyrA | DNA gyrase, A subunit | 1.55E-03 ± 1.09E-03 | 1 | -
Spreadsheet: 782511d1654090443-copy-range-of-cells-based-on-cell-value-help-example-filter-table-aligw
Sheet: Master Inventory

Subcontractor | Part Number | Part Name | Location | Quantity Issued | Quantity Installed | Quantity On-Hand
Subcontractor 1 | 01-17500100 | Widget 1 | A | 50 | 15
Subcontractor 2 | 01-17500101 | Widget 2 | B | 100 | 25
Subcontractor 2 | 01-17500102 | Widget 3 | D | 250 | 0
Subcontractor 1 | 01-17500103 | Widget 4 | C | 45 | 0
Subcontractor 3 | 01-17500104 | Widget 5 | F | 650 | 350
Subcontractor 1 | 01-17500105 | Widget 6 | E | 550 | 275
Subcontractor 3 | 01-17500106 | Widget 7 | G | 400 | 150
Subcontractor 2 | 01-17500107 | Widget 8 | K | 250 | 140
Subcontractor 3 | 01-17500108 | Widget 9 | L | 150 | 75
Subcontractor 1 | 01-17500109 | Widget 10 | M | 700 | 275
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: BGC_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  Boston Gas
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 659407d1579867142-grouping-consecutive-days-consec-days-v2
Sheet: Input

Employee Number | ResID(T) | Date | Abs. code | Days
10000 | [NAME] | 2019-02-01 00:00:00 | SICK | 1
10000 | [NAME] | 2019-02-05 00:00:00 | SICK | 1
10000 | [NAME] | 2019-02-06 00:00:00 | SICK | 1
10000 | [NAME] | 2019-02-25 00:00:00 | SICK | 1
10000 | [NAME] | 2019-04-15 00:00:00 | SICK | 1
10000 | [NAME] | 2019-04-16 00:00:00 | SICK | 1
10000 | [NAME] | 2019-06-19 00:00:00 | SICK | 1
10000 | [NAME] | 2019-09-16 00:00:00 | SICK | 1
10000 | [NAME] | 2019-10-14 00:00:00 | SICK | 1
10000 | [NAME] | 2019-11-04 00:00:00 | SICK | 1
10000 | [NAME] | 2019-11-05 00:00:00 | SICK | 1
10000 | [NAME] | 2019-11-06 00:00:00 | SICK | 1
10000 | [NAME] | 2019-11-19 00:00:00 | SICK | 1
Spreadsheet: 884616d1733841039-find-min-qty-base-on-no-of-consecutive-days-sample-data-1-abc10-
Sheet: Rate Table 

[NAME] | Equip Desc | Type | Use Type | Rate Type | Hourly | Daily | Weekly | Monthly | Quarterly | Semi-Annual | Annual | Fixed | Rate Start | Rate End | Status | Errortxt | Memo
1934987 | HOSE -  QUICK CONNECT | MISC | SMALL | TIME |  | 1.9 | 9.5 | 47.5 |  |  |  |  | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | ACTIVE
1934657 | LOCK | MISC | SMALL | TIME |  | 4.45 | 29.815 | 102.35 |  |  |  |  | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | ACTIVE
Spreadsheet: 91078d1290767487-formula-to-hide-div-0-with-null-copy-of-tender-register-v4-0-nov-2010
Sheet: Averages

Per Estimator : |  | Estimator | Ave bid | ave winning tender | ave variance | % | ave finishing position | Strike/success rate
 |  | DW | 315000 | 300000 | -15000 | -0.05 | 2 | 0
 |  | JST | 0 | 0 | 0
 |  | KJL | 0 | 0 | 0
 |  | LH | 0 | 0 | 0
 |  | MAB | 0 | 0 | 0
 |  | MW | 0 | 0 | 0
 |  | SP | 0 | 0 | 0
 |  | Average | 45000 | 42857.14285714286 | -2142.857142857143 | -0.05 | 2 | 0
Per Client : |  | Client | Ave bid | ave winning tender | ave variance | % | ave finishing position
 |  | Craegmoor | 315000 | 300000 | -15000 | -0.05 | 2
 |  | EMC |  |  | #N/A | #N/A
 |  | Oxfam |  |  | #N/A | #N/A
 |  | Priory |  |  | #N/A | #N/A
 |  | Average | 315000 | 300000 | #N/A | #N/A | 2
Spreadsheet: 2f6a7b97-5bb8-466d-9010-f70c7f14fd82
Sheet: Sheet1

 |  | Lady Jaguar Basketball
 |  | Molina High School
 |  | 2011-2012 Schedule
Date | Opponent | Team(s) | Location | Time | Result
[NAME]. Nov. 1 | POP [NAME] (scrimmage) | V | Molina | 07:00:00 | N/A
Fri. Nov. 11 | Ft. Worth Polytechnic | JV/V | Molina | 6:00/7:30 | W 33-31
[NAME]. Nov. 15 | [NAME] | JV/V | Molina | 5:00/6:30 | L  35-60
Fri. Nov. 18 | FBA College Prep | V | Molina | 04:30:00
Mon. Nov. 21 | POP [NAME] | V | POP  [NAME] ([NAME]) | 07:30:00
[NAME]. Nov. 22 | Wilmer Hutchings | JV/V | Molina | 6:00/7:30
[NAME]. Dec. 6 | [NAME] * | JV/V | [NAME] | 6:00/7:30
Thur. Dec. 8 | Edgewood/Wills Point Tourney | V | Edgewood Main Gym | 07:00:00
Fri. Dec. 9 | Edgewood/Wills Point Tourney | V | Edgewood/Wills Point | TBA
Sat. Dec. 10 | Edgewood/Wills Point Tourney | V | Edgewood/Wills Point | TBA
[NAME]. Dec. 13 | [NAME] * | JV/V | Molina | 6:00/7:30
Fri. Dec. 16 | [NAME] * | JV/V | Molina | 6:00/7:30
Sat. Dec. 17 | Ft. Worth Polytechnic | JV/V | Ft. Worth Polytechnic HS | Noon/1:30
[NAME]. Dec. 20 | North Dallas * | JV/V | Cobb | 6:00/7:30
[NAME]. Dec. 27 | [NAME] vs. [NAME] | V | Skyline HS | 01:30:00
Wed. Dec. 28 | DISD [NAME] | V | TBA | TBA
Thur. Dec. 29 | DISD [NAME] | V | TBA | TBA
[NAME]. Jan. 3 | [NAME] * | JV/V | Molina | 6:00/7:30
Fri. Jan. 6 | Kimball * | JV/V | Kimball | 6:00/7:30
Fri. Jan. 13 | Seagoville * | JV/V | Molina | 6:00/7:30
[NAME]. Jan. 17 | [NAME] * | JV/V | Molina | 6:00/7:30
Fri. Jan. 20 | [NAME] * | JV/V | Molina | 6:00/7:30
[NAME]. Jan. 24 | [NAME] * | JV/V | SOC | 6:00/7:30
Fri. Jan. 27 | North Dallas * | JV/V | Molina | 6:00/7:30
[NAME]. Jan. 31 | [NAME] * | JV/V | [NAME] | 6:00/7:30
Fri. Feb. 3 | Kimball * | JV/V | Molina | 6:00/7:30
[NAME]. Feb. 7 | Seagoville * | JV/V | Seagoville | 6:00/7:30
Coaches: [NAME], [NAME], [NAME]
Athletic Director: [NAME]
Principal: [NAME]
 | Molina High School
 | 2355 Duncanville Rd. | phone: [PHONE]   Fax: [PHONE]
 | Dallas, TX 75211.
[NAME]: [NAME]
Colors: Black/Teal
Spreadsheet: michelle_lokay__26774__CREL_MARKET_2001
Sheet: Releases by Acquirer

MARKET Synopsis for Summer 2001
 | MDQ Acquired 2001 |  | MDQ Acquired 2001 April -- October |  |  |  |  |  |  | MDQ Acquired 2000 April - October
[NAME] | Apr - Oct |  | April | May | June | July | Aug | Sept | Oct | April | May | June | July | Aug | Sept | Oct
AL-CORN FUELS |  |  |  |  |  |  |  |  |  | 250 | 450 | 450 | 450 | 450 | 450 | 250
[NAME] |  |  |  |  |  |  |  |  |  | 20000 | 0 | 0 | 0 | 0 | 0 | 0
Cargill |  |  |  |  |  |  |  |  |  | 10000 | 0 | 0 | 0 | 0 | 0 | 0
City of Gilmore |  |  |  |  |  |  |  |  |  | 0 | 90 | 90 | 90 | 180 | 180 | 215
City of Ponca |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 65 | 65 | 0
City of Sac City |  |  |  |  |  |  |  |  |  | 200 | 0 | 0 | 125 | 100 | 100 | 0
CMS |  |  |  |  |  |  |  |  |  | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800
CXY Energy |  |  |  |  |  |  |  |  |  | 10000 | 0 | 0 | 0 | 0 | 0 | 0
City of Rolfe |  |  |  |  |  |  |  |  |  | 77 | 0 | 0 | 0 | 0 | 0 | 0
Dynegy |  |  |  |  |  |  |  |  |  | 0 | 26500 | 11500 | 6500 | 6500 | 6500 | 3500
El Paso |  |  |  |  |  |  |  |  |  | 0 | 0 | 2000 | 2000 | 2000 | 0 | 0
ENA |  |  |  |  |  |  |  |  |  | 0
Energyone |  |  |  |  |  |  |  |  |  | 0 | 0 | 200 | 800 | 0 | 0 | 0
Engage |  |  |  |  |  |  |  |  |  | 10000 | 0 | 0 | 0 | 0 | 0 | 0
Guardian |  |  |  |  |  |  |  |  |  | 2000 | 2500 | 2500 | 1400 | 1400 | 1400 | 1000
Heartland Corn |  |  |  |  |  |  |  |  |  | 0 | 100 | 100 | 100 | 200 | 200 | 100
Heartland Energy |  |  |  |  |  |  |  |  |  | 31 | 31 | 31 | 31 | 31 | 31 | 31
[NAME] | 31800 |  | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800
Interlink |  |  |  |  |  |  |  |  |  | 7000 | 6000 | 12000 | 5000 | 5000 | 5000 | 5000
Kn Marketing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Lake Park |  |  |  |  |  |  |  |  |  | 50 | 0 | 33 | 120 | 110 | 75 | 0
Nebraska Public | 8 |  | 8 | 8 |  |  |  |  |  | 10 | 10 | 8 | 8 | 8 | 8 | 8
OGE |  |  |  |  |  |  |  |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Oneok | 1 |  | 1 | 1 |  |  |  |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1
Reliant Energy Retail |  |  |  |  |  |  |  |  |  | 7726 | 6726 | 12487 | 5708 | 5708 | 5708 | 5708
Sheehan's Gas |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tenaska |  |  |  |  |  |  |  |  |  | 0 | 15000 | 0 | 0 | 0 | 0 | 0
Town of Waukee |  |  |  |  |  |  |  |  |  | 320 | 0 | 0 | 0 | 0 | 120 | 0
Transcanada | 20255 |  | 15255 | 15255 | 14255 | 14255 | 14255 | 14255 | 14255 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TXU | 425 |  | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 1550 | 575 | 575 | 575 | 425 | 425 | 1425
US Energy |  |  |  |  |  |  |  |  |  | 1760 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
Wicor | 800 |  | 800 | 450 | 350 | 350 | 350 | 350 | 350 | 0 | 0 | 0 | 0 | 0 | 2800 | 0
WPS Energy |  |  |  |  |  |  |  |  |  | 100 | 100 | 2100 | 2100 | 2100 | 3100 | 100
Total
Weighted Avg.  $0.1192
Spreadsheet: sara_shackleton__36756__Entity locations of trades
Sheet: Alternative D

 |  |  |  |  | Enron Corp
 | Enron Power Corp |  | Enron Europe LLC |  |  |  | ENAC
 | 0.863 |  | 0.137
 |  | ECT Europe Inc |  |  | External investors |  |  |  | ECTRC |  | Entity employing staff etc
 |  |  |  |  |  |  | 0.9
 |  | EEL |  |  | Investment vehicle
 |  |  | 0.9 | 0.1 |  | 0.1
 | EPOL |  | ECCL |  |  |  | ECCI
 |  |  |  |  |  |  |  |  | ECCX
 |  |  | Systems etc transferred to ECCL |  |  |  | Dedicated new entity for US trades (EnronCredit.com Inc) |  | Any other entities required in other jurisdictions
Ownership 100% unless otherwise stated
Key: | Dedicated trading |  | Shared trading |  | Shared operations |  | New
Spreadsheet: 792876d1661192892-hlookup-returning-multiple-dates-and-value-of-filled-cell-2022-08-22-oeldere2-jaapaap-schedule
Sheet: overview

 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 | name | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place | date | place
 |  | 2022-01-01 00:00:00 | ob | 2022-01-04 00:00:00 | bb | 2022-01-08 00:00:00 | ob | etc. | etc | etc. | etc.
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | -650000 |  |  |  | 32500
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | -37500
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | -32500 |  | -258387 |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258387 |  |  |  | 32229
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg) |  |  |  |  |  | -964410 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2444069
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 509708
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4125 |  |  |  |  |  | -14190
25 |  | Demand |  |  |  |  |  | 34003 |  |  |  |  |  | 0 |  |  |  |  |  | 93300 |  |  |  | 0 |  |  |  |  |  | -34003
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  | 24021
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 |  | -158773
34 |  | Originations
35 |  | Broker Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -4125
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 26963
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000
 |  | TOTAL
Spreadsheet: 198556d1354814651-how-to-select-non_fill-rows-book-how-many-hits2
Sheet: 8,3,2=10

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | X | X | X | X
2 | X |  |  | X | X | X
3 | X |  |  |  |  |  | X | X | X
4 |  | X |  |  |  | X | X |  | X
5 |  | X |  |  | X |  |  | X |  | X
6 |  |  | X |  | X |  | X
7 |  |  | X |  |  | X |  | X |  | X
8 |  |  |  | X |  |  |  |  | X | X
Spreadsheet: 711413d1609694315-complex-index-match-formula-help-test
Sheet: Sheet1

Account |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt Type Code | Expected Formula Result
2021001295 |  |  |  |  |  | 0 | 0 | 0 | 0 | 3565.19 | 0 | 0 | 0 | CS | Yes
2021001295 |  |  |  |  |  | 1460.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | Yes
2021001295 |  |  |  |  |  | 950 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | Yes
2022001655 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AL | Yes
2022001655 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | Yes
2022001655 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | Yes
2022001655 |  |  |  |  |  | 1425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SS | Yes
29776001972 |  |  |  |  |  | 16652.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CS | Yes
29776001972 |  |  |  |  |  | 435.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | Yes
29776001972 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | RT | Yes
29776001972 |  |  |  |  |  | 604.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | Yes
3988000658 |  |  |  |  |  | 0 | 0 | 0 | 0 | 4458.9 | 0 | 0 | 0 | CS | Yes
3988000658 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | Yes
3988000658 |  |  |  |  |  | 728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | Yes
19780006741 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CM | No
19780006741 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CS | No
19780006741 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MD | No
19780006741 |  |  |  |  |  | 460.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | No
19780006741 |  |  |  |  |  | 960 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | No
19780022132 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CM | Yes
19780022132 |  |  |  |  |  | 11048.71 | 176935 | 0 | 0 | 0 | 0 | 0 | 0 | CS | Yes
19780022132 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MD | Yes
19780022132 |  |  |  |  |  | 460.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PF | Yes
19780022132 |  |  |  |  |  | 924 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | Yes
Spreadsheet: 846881d1698032186-help-with-projections-money-projections-help
Sheet: TimeSheets

Workers | Weekday | Saturday | Sunday | Base+Super | Profit p/h Weekday | Profit p/h Sat | Profit p/h Sun | Weekday Hours | Saturday Hours | Sunday Hours | Fortnightly Profit
Staff A | 42.79 |  |  |  |  |  |  |  |  |  |  |  |  | Number of workers paid:
Staff B | 42.79 |  |  |  |  |  |  | 25 |  |  |  |  |  | Profit before expendetures
Staff C | 40.26 |  |  |  |  |  |  | 20 |  |  |  |  |  | SAFE Work SA
Staff D | 40.26 |  |  |  |  |  |  | 31 |  |  |  |  |  | Shift Care Cost
Staff E | 40.26 |  |  |  |  |  |  | 30 |  |  |  |  |  | Xero
Staff F | 40.26 |  |  |  |  |  |  | 8 |  |  |  |  |  | Insurance  (annual $2035) | 78
Staff G | 40.26 |  |  |  |  |  |  | 4
Staff H | 40.26
Staff I | 42.79 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (excl Expenses)
Spreadsheet: 725119d1616537598-calendar-date-update-by-year-calendar-by-year-update
Sheet: 2022

 | Payroll Calendar 2022
2022-01-01 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 124074d1318063057-adding-minutes-and-seconds-in-separate-columns-adding_time
Sheet: Sheet1

Start time |  | Duration
Minutes | Seconds | Minutes | Seconds
 | 0 | 0 | 16
 |  | 1 | 5
 |  | 3 | 20
 |  | 0 | 45
 |  | 2 | 44
 |  | 4 | 15
 |  | 5 | 40
 |  | 5 | 10
 |  | 2 | 10
 |  | 1 | 13
 |  | 3 | 0
 |  | 1 | 8
Spreadsheet: 480232d1473834300-calculation-error-in-regular-hrs-calculation-calculation-error-for-pay-slip
Sheet: Sheet1

 | Start Time | Regular Hours | Regular Pay (Hourly) | Overtime Pay (Hourly)
 | 07:00:00 | 8 | 15
 | In Time | [NAME] Out | Lunch Time In | Out Time | [NAME] | Net Working Hrs | Regular Hrs | PTO Hrs | [NAME] | Public Holiday | Make-Up Hrs | Un-Paid Hrs | Total Hrs | OT Hours | Total Pay | Status
 | 07:00:00 | 11:00:00 | 11:30:00 | 15:00:00 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | Present
Spreadsheet: 39087d1237299904-solved-formulas-stop-working-mlbbetsystem-version-3-
Sheet: Teams

ANA | Anaheim Angels
ARZ | [NAME]
ATL | Atlanta Braves
BAL | Baltimore Orioles
BOS | Boston Red Sox
CHC | [NAME]
CIN | Cincinnati Reds |  | VS | Win
CLE | Cleveland Indians |  | AT | Loss
COL | Colorado Rockies
CWS | Chicago White Sox
DET | Detroit Tigers
FLA | Florida [NAME]
HOU | Houston Astros
KAN | Kansas City Royals
LOS | Los Angeles Dodgers
MIL | [NAME]
MIN | Minnesota Twins
NYM | New York Mets
NYY | New York Yankees
OAK | Oakland Athletics
PHI | Philadelphia Phillies
PIT | Pittsburgh Pirates
SDG | San Diego Padres
SEA | Seattle Mariners
SFO | San Francisco Giants
STL | Saint Louis Cardinals
TAM | Tampa Bay Devil Rays
TEX | Texas Rangers
TOR | Toronto Blue Jays
WAS | Washington Nationals
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1023

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | [NAME]
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1023
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-07-15 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13266 | Peacoat | 0 | 2 | 2 | 2 | 1 | 0 | 7 | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7