tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  | 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 | 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
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  | 36408
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Sell Rate Struct.

Rebar - Sell Rate P/Hr (5059)
 |  |  |  |  |  |  |  |  |  | Combined |  |  | 5040 | 0.08052
 |  |  |  | Reg. Hours |  | OT Hours |  | DT Hours |  | Total Cost |  |  | 5059 | 0.222226
 |  |  |  |  |  |  |  |  |  |  |  |  | 5221 | 0.05766
Wage
Per Diem
Group Insurance
Sub or Cash Fringe
FICA |  | 0.0765
SUTA |  | 0.0179
FUTA |  | 0.008
Total
Subtotal 1
G/L |  | 0.065
W/C Code | 5221
Subtotal 2
Auto / Misc |  | 0.015
Small Tools |  | 0.015
Consumables |  | 0.02
Safety Supplies |  | 0.015
Subtotal 3
Overhead |  | 0.2
Profit |  | 0.15
Sell rate p/hr
Rebar - Sell Rate P/Hr (5040)
 |  |  |  |  |  |  |  |  |  | Combined
 |  |  |  | Regular Hours |  | Overtime Hours |  |  |  | Total Cost
Wage
Per Diem
Group Insurance
Sub or Cash Fringe
FICA |  | 0.0765
SUTA |  | 0.0155
FUTA |  | 0.008
Total
Subtotal 1
G/L
W/C Code | 5213
Subtotal 2
Auto / Misc
Small Tools |  |  |  |  |  |  |  |  |  |  |  |  |  | WC CODE FOR WALLS & COLUMNS
Consumables
Safety Supplies |  |  |  |  |  |  |  |  |  |  |  |  |  | WC CODE | COST P/HR | % |  |  | COST P/HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5221 |  | 0.8
Subtotal 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5213 |  | 0.2
Overhead
Profit |  |  |  |  |  |  |  |  |  |  |  |  |  | WC CODE | PRICE P/HR | % | Overhead | Profit | PRICE P/HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5221 |  | 0.8
Sell rate p/hr |  |  |  |  |  |  |  |  |  |  |  |  |  | 5213 |  | 0.2
Rebar - Sell Rate P/Hr (5221)
 |  |  |  |  |  |  |  |  |  | Combined
 |  |  |  | Regular Hours |  | Overtime Hours |  |  |  | Total Cost
Wage
Per Diem
Group Insurance
Sub or Cash Fringe
FICA |  | 0.0765
SUTA |  | 0.0155
FUTA |  | 0.008
total
Subtotal 1
G/L
W/C Code | 5222
Subtotal 2
Auto / Misc
Small Tools
Consumables
Safety Supplies
Subtotal 3
Overhead
Profit
Sell rate p/hr
Spreadsheet: 127883d1320671758-vlookups-with-multiple-choices-excel-help-sample-data-1-
Sheet: Sheet2

Entity | Customer | Product | Supplier | Customer Code
UK | Bausch & Lomb Inc |  |  | Bausch & Lomb Inc | BAU002 |  | Depending on what is in A, the lookup in E picks the correct data column on sheet 1 L-Q
GMBH | I have got this bit to work but now i need the code |  |  |  | #N/A
SING | I have got this bit to work but now i need the code |  |  |  | #N/A
GMBH | I have got this bit to work but now i need the code |  |  |  | #N/A
UK | I have got this bit to work but now i need the code |  |  |  | #N/A
UK | I have got this bit to work but now i need the code |  |  |  | #N/A
GMBH | I have got this bit to work but now i need the code |  |  |  | #N/A
Spreadsheet: mary_fischer__25620__77M
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  077M
COMPANY NAME    MEP Services, Inc.
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 823340d1679917414-how-to-automatically-copy-functions-when-inputting-values-example
Sheet: Taul1

 | Default working time |  | 06:00:00
PVM | Start | End | Working time | Balance +/- | Cumulative balance
2027-03-28 00:00:00 | 08:00:00 | 14:00:00
2027-03-29 00:00:00 | 07:00:00 | 13:57:00
2027-03-30 00:00:00
2027-03-31 00:00:00
2027-04-01 00:00:00
2027-04-02 00:00:00
2027-04-03 00:00:00
2027-04-04 00:00:00
2027-04-05 00:00:00
2027-04-06 00:00:00
2027-04-07 00:00:00
2027-04-08 00:00:00
2027-04-09 00:00:00
2027-04-10 00:00:00
2027-04-11 00:00:00
2027-04-12 00:00:00
2027-04-13 00:00:00
2027-04-14 00:00:00
2027-04-15 00:00:00
2027-04-16 00:00:00
2027-04-17 00:00:00
2027-04-18 00:00:00
2027-04-19 00:00:00
2027-04-20 00:00:00
2027-04-21 00:00:00
2027-04-22 00:00:00
2027-04-23 00:00:00
2027-04-24 00:00:00
2027-04-25 00:00:00
2027-04-26 00:00:00
2027-04-27 00:00:00
2027-04-28 00:00:00
2027-04-29 00:00:00
2027-04-30 00:00:00
2027-05-01 00:00:00
2027-05-02 00:00:00
2027-05-03 00:00:00
2027-05-04 00:00:00
2027-05-05 00:00:00
2027-05-06 00:00:00
2027-05-07 00:00:00
2027-05-08 00:00:00
2027-05-09 00:00:00
2027-05-10 00:00:00
2027-05-11 00:00:00
2027-05-12 00:00:00
2027-05-13 00:00:00
2027-05-14 00:00:00
2027-05-15 00:00:00
2027-05-16 00:00:00
2027-05-17 00:00:00
2027-05-18 00:00:00
2027-05-19 00:00:00
2027-05-20 00:00:00
2027-05-21 00:00:00
2027-05-22 00:00:00
2027-05-23 00:00:00
2027-05-24 00:00:00
2027-05-25 00:00:00
2027-05-26 00:00:00
2027-05-27 00:00:00
2027-05-28 00:00:00
2027-05-29 00:00:00
2027-05-30 00:00:00
2027-05-31 00:00:00
2027-06-01 00:00:00
2027-06-02 00:00:00
2027-06-03 00:00:00
Spreadsheet: 886119d1736155575-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms
Sheet: Stop List

 | STOP NUMBER |  | BUS STOP NAME | ON STREET / ROAD | POINT LETTER | ROUTES | Closure Type
 | 1
 | 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
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: 859291d1707733236-genrate-quantity-and-avg-rate-according-to-ammount-sample
Sheet: Sheet4

 |  | MIN | MAX
 |  | 39500 | 45500
NAME | QTY | AVG | AMT
AHATRAM-ALVPA1406A-CT | 130 |  | 5692989
MOHAMMAD HARIS-ACHPH4293F-CT | 59 |  | 2620328
[NAME] | 52 |  | 2299924
MOHAMMAD VAHID-ASOPV7368N-CT | 49 |  | 2175106
SHAH ALAM-CBLPA7824C-CT | 45 |  | 2000000
[NAME] | 23 |  | 986070
Bilal-CQAPB9152J-CT | 20 |  | 850523
SHADAB-MHNPS6867F-CT | 18 |  | 783922
[NAME] | 17 |  | 758181
ISHATYAK-ADFPI4620N-CT | 11 |  | 487064
NISHA-BOZPN3900E-CT | 10 |  | 437399
Mohd - Shadab-DVRPS9128C - CT | 10 |  | 403364
[NAME] | 10 |  | 403176
SHAHRUKH AHMAD-BNWPA4327A-CT | 9 |  | 391547
SHAHRUKH-FYQPS8848B-CT | 8 |  | 345911
ANAS-DLOPA6331Q-CT | 8 |  | 334738
Ms Food-OTWPS0408D-CT | 8 |  | 326653
AZAM-CALPA6053J-CT | 8 |  | 319776
MUSTAQEEM AHMAD-BEQPM7016B-CT | 7 |  | 300000
ALKMAL AHMAD-ASOPA3851D-CT | 5 |  | 200000
HASEEN-AQDPH6392K-CT | 5 |  | 200000
[NAME] | 5 |  | 200000
PRVEJ AALAM-DKCPP5184B-CT | 5 |  | 200000
SABIR-JBAPS4553Q-CT | 5 |  | 200000
SALMA-NOWPS6924A-CT | 5 |  | 191870
FARAZ-AGDPF2521J-CT | 4 |  | 171038
[NAME] | 4 |  | 157925
SHIBU VP-DHPPS4586E-CT | 4 |  | 150000
HUMA NAZ-BDZPN4074J-CT | 4 |  | 141476
FAIJAN-ADEPF3965E-CT | 3 |  | 110000
DILSHAD-EOAPD1454M-CT | 3 |  | 100000
KABIR TRADERS-ADCPF6604N-CT | 3 |  | 100000
MASHOOF ALI KHAN-AXQPK8398C-CT | 2 |  | 80000
KALIM-[PHONE]-BCT | 2 |  | 66580
SHAHZEB-[PHONE]-BCT | 2 |  | 65883
[NAME] | 2 |  | 58976
TABISH-BTUPT6938C-CT | 2 |  | 55737
MOHAMMAD INAM-[PHONE]-BCT | 2 |  | 51030
BILAL-COOPB0977H-CT | 2 |  | 50000
KALA-BUAPK8481Q-CT | 2 |  | 50000
[NAME]. Salman-RRHPS4240D-CT | 2 |  | 50000
nadeem-[PHONE]-BCT | 2 |  | 49500
PARVEJ-CQPPP9004C-CT | 2 |  | 49000
ISLAM-ACCPI1457M-CT | 2 |  | 48562
ASHRAF-AOVPA9300C-CT | 2 |  | 47530
[NAME] | 2 |  | 45542
VAQUAR-[PHONE]-BCT | 1 |  | 36314
[NAME] | 1 |  | 35000
FAHEEM-BCT | 1 |  | 23250
JUNAID ALAM-EGCPA3243P-CT | 1 |  | 20400
SHAHANAVAJ-FKFPS7069D-CT | 1 |  | 20000
[NAME] | 1 |  | 20000
 | 591
Spreadsheet: 121760d1316395041-looking-up-a-value-in-a-column-then-adding-its-value-to-a-different-column-mybills2011
Sheet: Sheet1

 | My Bills 2011
Date | Type | Amount |  | Total | Beginning Balance
 | [NAME] | 55 |  |  | 1
 | Deposit | 10
 | Paycheck | 1000
 | Withdrawal | 30
Spreadsheet: 160333d1339055907-cas-excel-que-je-narrive-pas-r-soudre-excel-suite
Sheet: Modèle

CREER UNE FACTURE D'AVOIR
Calcul des ristournes
TRAVAIL à FAIRE
 |  |  |  |  | TVA | 0.196
 |  |  |  | AVOIR n°
CA TTC |  |  |  | Dammarie le
CA HT
 |  | Tranche |  | Base de | % | Montant
 |  | Début | Fin | calcul | Ristourne | HT
Ristourne annuelle
Tranche A |  | 10000 | 20000 |  | 0.01
Tranche B |  | 20001 | 30000 |  | 0.02
Tranche C |  | 30001 | 50000 |  | 0.03
Tranche D |  | 50001 | et + |  | 0.05
 |  |  |  | Total HT
 |  |  |  | TVA
 |  |  |  | Net à votre crédit
Spreadsheet: darrell_schoolcraft__7264__saledoc02_20TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-20 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/21/2002 |  |  | FAX Number:
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.3
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/21/2002 | 2002-02-21 00:00:00 | 30000 |  | 30000 |  | 30000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 30000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 693195d1598850551-minifs-for-older-versions-of-excel-help-minifs-function-for-older-versions-answers
Sheet: Sheet1

Group | Team | Score | [NAME] UK | Nest IF CSE | SumProd? | [NAME] | Min of Group and team
1 | Ault | 7 |  |  |  |  | 4 | << Need a formula to find Min of Same group and Team
1 | Church | 6 |  |  |  |  | 6 | <Same group and team as row 5
1 | Ault | 4 |  |  |  |  | 4 | << Same group and team as row 2
1 | Church | 0.01 |  |  |  |  | 6
2 | Ault | 6 |  |  |  |  | 6
2 | Church | 5 |  |  |  |  | 5
2 | Ault | 7 |  |  |  |  | 6
2 | Church | 6 |  |  |  |  | 5
3 | Ault | 7 |  |  |  |  | 5
3 | Church | 6 |  |  |  |  | 3
3 | Ault | 5 |  |  |  |  | 5
3 | Church | 3 |  |  |  |  | 3
4 | Ault | 3 |  |  |  |  | etc
4 | Church | 4
4 | Ault | 5
4 | Church | 3
5 | Ault | 7
5 | Church | 5
5 | Ault | 4
5 | Church | 6
6 | Ault | 5
6 | Church | 7
6 | Ault | 6
6 | Church | 7
7 | Ault | 4
7 | Church | 7
7 | Ault | 5
7 | Church | 3
8 | Ault | 5
8 | Church | 3
8 | Ault | 6
8 | Church | 5
9 | Ault | 4
9 | Church | 5
9 | Ault | 5
9 | Church | 5
10 | Ault | 5
10 | Church | 3
10 | Ault | 6
10 | Church | 3
11 | Ault | 7
11 | Church | 5
11 | Ault | 3
11 | Church | 6
Spreadsheet: c9ebd0e8-befa-4316-bb87-37d97bd0ee2a
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 | Unnamed: 12 | Unnamed: 13
 |  | Draw | Adjustable | Limb | Talon | Riser | Barrel |  | Energy | Power | Mass
Item # | Model | Weight | Stock/Forearm | Warranty | [NAME] | Material | Material | F.P.S. | (ft. lbs.) | Stroke | Weight # | [NAME] | Length
CB870 | Fury (Bow Only) | 160 |  | 3 Year | Ultra | CNC Forged | CNC Machined Aluminum | 360 | 122 | 15 3/8" | 8.1 | 13" | 35 1/4"
CB871 | Fury Scope Package | 160 |  | 3 Year | Ultra | CNC Forged | CNC Machined Aluminum | 360 | 122 | 15 3/8" | 8.1 | 13" | 35 1/4"
CB880 | Havoc Scope Package | 175 |  | 3 Year | Ultra | CNC Forged | CNC Machined Aluminum | 325 | 96 | 14 1/4" | 8.3 | 9 7/8" | 34 1/2"
CB861 | Vision Scope Package - Compound | 175 |  | Lifetime | Ultra | CNC Machined Aluminum | CNC Machined Aluminum | 300 | 85 | 13" | 8.3 | 9 7/8" | 35 5/8"
CB517 | [NAME] | 175 | Stock & Forearm | 3 Year | Ultra | CNC Forged | CNC Machined Aluminum | 330 | 103 | 12 3/4" | 6.5 | 17 3/4" | 37 1/8"
CB514 | [NAME] Red Dot Package - Compound | 175 | Stock & Forearm | 3 Year | Ultra | CNC Forged | CNC Machined Aluminum | 330 | 103 | 12 3/4" | 6.5 | 17 3/4" | 37 1/8"
CB315 | Bone Collector Scope Package - Compound | 175 | Stock & Forearm | 3 Year | Ultra | Die Cast Aluminum | CNC Machined Aluminum | 325 | 97 | 14 1/4" | 8.6 | 21" | 35 5/8"
CB300 | Brotherhood Scope Package (Green) - Compound | 160 | Stock | 3 Year | Ultra | Die Cast Aluminum | Composite | 305 | 85 | 13 1/2" | 8.6 | 21 | 37"
CB305 | Brotherhood Scope Package (Camo) - Compound | 160 | Stock | 3 Year | Ultra | Die Cast Aluminum | Composite | 305 | 85 | 13 1/2" | 8.6 | 21 | 37"
CB731 | [NAME] | 225 | Collapsible Stock | Lifetime | Ultra | CNC Machined Aluminum | CNC Machined Aluminum | 317 | 95 | 15 3/8" | 7.8 | 28" | 37"-40"
CB724 | Legacy HD  Scope Package - Recurve | 175 | Stock | Lifetime | Ultra | CNC Machined Aluminum | CNC Machined Aluminum | 263 | 65 | 13 5/8" | 6.9 | 30" | 37"
Spreadsheet: 27447d1220628158-a-two-part-summation-subtot
Sheet: Feuille1

Produit | Qté
Product A | 2
Product A | 4
Product A | 3
Product A Somme | 9
Product B | 7
Product B Somme | 7
Product C | 1
Product C | 1
Product C Somme | 2
Product D | 9
Product D | 2
Product D | 3
Product D | 5
Product D | 6
Product D | 5
Product D Somme | 30
Total | 48
Spreadsheet: 662972d1581869085-finding-clashes-in-a-table-sixth-form-options
Sheet: Clash Matrix

 |  |  | BS | Bi | CP | Ch | DT | Dr | Ec | [NAME] | EngLa | FM | FS | Fr | Ge | Hi | Ma | Mu | PE | Ph | RS | Sp |  |  |  |  |  |  |  |  |  |  |  |  | D | E
 | Ar
 | BS
 | Bi
 | CP
 | Ch
 | DT
 | Dr
 | Ec
 | [NAME]
 | EngLa
 | FM
 | FS
 | Fr
 | Ge
 | Hi
 | Ma
 | Mu
 | PE
 | Ph
 | RS
 | Sp
Spreadsheet: 75093d1275619793-two-criteria-lookup-exact-and-closest-match-two_criteria_lookup
Sheet: Sheet1

Type | Fom | To | return value
A | 10 | 20 | 29.96539903625761 |  |  | Type | value | Return
A | 20 | 30 | 90.84020564065752 |  |  | B | 42
A | 30 | 40 | 3.792892250500834
A | 40 | 50 | 12.53612525091619
A | 50 | 60 | 50.97705375922958
A | 60 | 70 | 71.37822080756652
B | 10 | 20 | 87.83347604587715
B | 20 | 30 | 21.75331566750025
B | 30 | 40 | 52.80930449936125
B | 40 | 50 | 44.15669858249107
B | 50 | 60 | 4.123166789496358
B | 60 | 70 | 46.34243817102948
C | 10 | 20 | 38.44587506740685
C | 20 | 30 | 15.03237499186225
C | 30 | 40 | 99.03232317044743
C | 40 | 50 | 18.94407572898826
C | 50 | 60 | 15.1496195905128
C | 60 | 70 | 12.9935078526886
Spreadsheet: 145151d1331318433-automatic-sorting-sortingbycatagories
Sheet: Office Expense Breakdown

 |  |  | Office Expense - Meals |  |  |  |  |  |  | Office Expense - Groceries |  |  |  |  |  |  | Office Expense - Office
 |  |  |  | Date |  | Description |  | Amount |  |  | Date |  | Description |  | Amount |  |  | Date |  | Description |  | Amount
Spreadsheet: 82800d1282823340-vlookup-giving-wrong-answer-help
Sheet: CALCULATION PAGE

 |  | AREA 1 |  |  | AREA 2
 |  | DN8 5 |  |  | CO1 1 |  |  |  |  | AREA 1 |  |  |  | AREA 2
Age | Relation |  | Comp | TPFT | TPO |  |  |  | Comp | TPFT | TPO |  | Comp | TPFT | TPO
36 | WORKER 1 |  | 1325.270025513116 | 838.692881308699 | 714.3244997979784
40 | WORKER 2 |  | 1263.167400137619 | 791.9621929073342 | 674.5707885048736
Spreadsheet: 142544d1329904172-moving-annual-total-example-5
Sheet: Sheet1

2010-01-01 00:00:00 | 720
2010-02-01 00:00:00 | 989
2010-03-01 00:00:00 | 896
2010-04-01 00:00:00 | 1132
2010-05-01 00:00:00 | 817
2010-06-01 00:00:00 | 582
2010-07-01 00:00:00 | 501
2010-08-01 00:00:00 | 1254
2010-09-01 00:00:00 | 882
2010-10-01 00:00:00 | 1386
2010-11-01 00:00:00 | 1153
2010-12-01 00:00:00 | 760
2011-01-01 00:00:00 | 1080
2011-02-01 00:00:00 | 1046
2011-03-01 00:00:00 | 630
2011-04-01 00:00:00 | 989
2011-05-01 00:00:00 | 1465
2011-06-01 00:00:00 | 620
2011-07-01 00:00:00 | 1436
2011-08-01 00:00:00 | 576
2011-09-01 00:00:00 | 536
2011-10-01 00:00:00 | 1213
2011-11-01 00:00:00 | 820
2011-12-01 00:00:00 | 1052
Spreadsheet: 329684d1404383464-counting-no-of-unique-columns-couting-unique-columns
Sheet: Sheet1

Market 1 | Market 2 | Market 3 | Market 4 | Market 5 | Market 6 | Market 7 | Market 8
H1 | H1 | H1 | H1 | H1 | H1 | H1 | H1 | No. Of unique columns
H5 | H5 | H5 | H5 | H5 | H5 | H5 | H5 | 5
I7 | I6 | I7 | I6 | I6 | I7 | I6 | I7
I9 | I7 | I9 | I7 | I7 | I9 | I7 | I9
 | I9 |  | I9 | I9 |  | I9 | K2
 |  |  |  | K2 |  | K2 | K3
 |  |  |  | K3 |  | K3 | K5
 |  |  |  | K6 |  | K5 | K6 | [NAME] columns
 |  |  |  | M7 |  | K6 | M7 | 3
 |  |  |  | O1 |  | M7 | O1
 |  |  |  |  |  | O1
 |  |  |  |  |  |  |  | for calculting code I have used array formula…
 |  |  |  |  |  |  |  | so use ctrl + shift + enter   to enter the formula…
 |  |  |  |  |  |  |  | don't use only enter
 |  |  |  |  |  |  |  | I have used conditional formatting so do care of it…
 |  |  |  |  |  |  |  | please click * to appreciate…
290 | 363 | 290 | 363 | 744 | 290 | 819 | 746
3 | 2 | 3 | 2 | 1 | 3 | 1 | 1
Spreadsheet: 694371d1599572831-lookup-first-match-corresponding-to-any-combination-of-values-from-multiple-criteria-lists-lookup-first-match-corresponding-to-any-combination-of-values-from-multiple-criteria-ranges
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2 |  | Table3 |  | Table 4 |  |  |  | Table 5
Data_1 | Data_2 | Data_3 | Date | Time |  | Criteria for Data_2 |  | Criteria for Data_3 |  | Criteria for Data_1 | Table_1[Date+Time] from first match with Table_4[Data_1]*Table_3[Data_3]*Table_2[Data_2] in Table_1 |  |  | Matched row | Matched Data_2 | Matched Data_3 | Matched Date | Matched Time
Red | Boat | No | 2020-06-11 00:00:00 | 14:10:34 |  | Boat |  | No |  | Red |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:34
White | Helicopter | No | 2020-06-11 00:00:00 | 14:11:53 |  | Car |  |  |  | White |  |  |  |  | Boat | No | 2020-06-19 00:00:00 | 16:20:17
Blue | Tanks | No | 2020-06-11 00:00:00 | 21:26:42 |  | Train |  |  |  | Blue |  |  |  |  | Car | No | 2020-06-19 00:00:00 | 16:20:21
Green | Bicycle | No | 2020-06-11 00:00:00 | 14:12:19 |  |  |  |  |  | Green |  |  |  |  | Car | No | 2020-06-11 00:00:00 | 21:26:24
Yellow | Space shuttle | No | 2020-06-11 00:00:00 | 16:55:54 |  |  |  |  |  | Yellow |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:25
Orange | Helicopter | No | 2020-06-11 00:00:00 | 21:26:54 |  |  |  |  |  | Orange |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 19:11:47
Purple | Tanks | Yes | 2020-06-19 00:00:00 | 11:37:12 |  |  |  |  |  | Purple |  |  |  |  | Car | No | 2020-06-11 00:00:00 | 14:09:11
[NAME] | Bicycle | No | 2020-06-30 00:00:00 | 07:32:38 |  |  |  |  |  | [NAME] |  |  |  |  | Train | No | 2020-06-11 00:00:00 | 19:11:53
Black | Space shuttle | No | 2020-06-19 00:00:00 | 16:20:09 |  |  |  |  |  | Black |  |  |  |  | Boat | No | 2020-06-11 00:00:00 | 14:10:30
Red | Car | No | 2020-06-19 00:00:00 | 16:20:13
White | Boat | No | 2020-06-19 00:00:00 | 16:20:17
Blue | Car | No | 2020-06-19 00:00:00 | 16:20:21
Green | Train | Yes | 2020-06-11 00:00:00 | 21:31:58
Yellow | Airplane | No | 2020-06-11 00:00:00 | 21:32:01
Orange | Boat | No | 2020-06-11 00:00:00 | 19:11:47
Purple | Car | No | 2020-06-11 00:00:00 | 14:09:11
[NAME] | Train | No | 2020-06-11 00:00:00 | 19:11:53
Black | Boat | Yes | 2020-06-11 00:00:00 | 14:09:13
Red | Helicopter | No | 2020-06-11 00:00:00 | 19:11:56
White | Tanks | No | 2020-06-11 00:00:00 | 19:12:59
Blue | Train | Yes | 2020-06-11 00:00:00 | 14:10:15
Green | Car | No | 2020-06-11 00:00:00 | 21:26:24
Yellow | Boat | No | 2020-06-11 00:00:00 | 14:10:25
Orange | Airplane | No | 2020-06-11 00:00:00 | 19:13:07
Purple | Bicycle | No | 2020-06-11 00:00:00 | 14:10:27
[NAME] | Airplane | No | 2020-06-11 00:00:00 | 19:13:09
Black | Boat | No | 2020-06-11 00:00:00 | 14:10:30
Spreadsheet: 682140d1591915258-make-a-schedule-in-excel-schedule-sample
Sheet: Sheet1

 | Team | June | July | August | September | October | November | December | January | February | March
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 5a5b689b-7d83-4dba-b6e0-49316efb1996
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
[NAME] | Women's Soccer | [NAME] | L, 1-2
08/19/2012 | Women's Soccer | Western Carolina | W, 2-1
08/24/2012 | Women's Soccer | vs. Central Michigan (Penn State Invitational) | L, 0-2
08/26/2012 | Women's Soccer | vs. Stanford (Penn State Invitational) | W, 1-0
08/31/2012 | Women's Soccer | Penn State (WVU 90 Minute Classic) | L, 1-2 (2OT)
09/02/2012 | Women's Soccer | Miami (WVU 90 Minute Classic) | T, 0-0 (2OT)
09/06/2012 | Women's Soccer | Duquesne | T, 1-1 (2OT)
[NAME] | Women's Soccer | at Purdue | T, 2-2 (2OT)
09/14/2012 | Women's Soccer | Towson | W, 5-0
09/16/2012 | Women's Soccer | High Point | W, 6-0
09/21/2012 | Women's Soccer | Texas Tech* | W, 3-2
09/23/2012 | Women's Soccer | Oklahoma State* | W, 1-0
09/28/2012 | Women's Soccer | at TCU* | W, 2-1
[NAME] | Women's Soccer | at Kansas* | W, 1-0
10/07/2012 | Women's Soccer | at Iowa State* | W, 3-2
10/12/2012 | Women's Soccer | Baylor* | T, 1-1 (2OT)
10/18/2012 | Women's Soccer | Oklahoma* | W, 2-0
10/26/2012 | Women's Soccer | at Texas* | W, 1-0 (OT)
10/31/2012 | Women's Soccer | vs. TCU (Big 12 Quarterfinals) | L, 0-2
11/10/2012 | Women's Soccer | Princeton (NCAA First Round) | L, 1-2