tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25623__31Y
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 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 |  | 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 |  |  |  | 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 |  | 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 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 89479379 | 230336937
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 39137924 | 101009075
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 128617303 | 331346012
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -100343382 | -257199518 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -28106245 | -72328753
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 345130 | 867585
 | Total Purchases: |  | -128104497 | -328660686
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -4473 | -177
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -18066 | -45399 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -22539 | -45576
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 50140 | 130199
18 |  | W/D (Purchase from Stg) | -544509 | -1455168
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -544509 | -1455168
 | Total Storage: |  | -494369 | -1324969
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 6908 | 17762.830536
 |  |  | 0 | 0
23 | Fuel: |  | -345130 | -867585
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -406932
25 |  | Demand | 0 | -2565922.5
 | Total Transport Expense: |  | 0 | -2972854.5
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 4506255.0187
31 |  | Prior Month Book Balance | 0 | -7591856
 |  | Total MTM Income | 0 | -3085600.9813
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 4552700
34 |  | Originations | 0 | 14359
35 |  | Broker Fees | 0 | -14519
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1145036
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 34886d1232310034-parabola-problem-book1
Sheet: Sheet1

X | X2 | X= | 2
-5 | 25 |  | -24
-4 | 16 |  | -20
-3 | 9 |  | -16
-2 | 4 |  | -12
-1 | 1 |  | -8
0 | 0 |  | -4
1 | 1 |  | 0
2 | 4 |  | 4
3 | 9 |  | 8
4 | 16 |  | 12
5 | 25 |  | 16
Spreadsheet: john_griffith__15605__Mesa Model 1_19_01
Sheet: Curves

Curves
As of:
Month | NG-P | LIBOR-AA | IF-ELPO/SJ-D | IF-ELPO/SJ-I
2001-02-01 00:00:00
Spreadsheet: 801205d1666112939-adding-quantity-into-different-sheets-by-monthly-buckets-cylinder-mrp-oct-2022-1-
Sheet: Main

 |  |  |  |  |  |  |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due |  |  | PO Due
Item | description | Total  On Order | On Hand | Available | Min | 12 mo History |  | Est. Sales | 2022-10-22 00:00:00 | Net | Est. Sales | 2022-11-01 00:00:00 | Net | Est. Sales | 2022-12-01 00:00:00 | Net | Est. Sales | 2023-01-01 00:00:00 | Net | Est. Sales | 2023-02-01 00:00:00 | Net | Est. Sales | 2023-03-01 00:00:00 | Net | Est. Sales | 2023-04-01 00:00:00 | Net | Est. Sales | 2023-05-01 00:00:00 | Net | Est. Sales | 2023-06-01 00:00:00 | Net | Est. Sales | 2023-07-01 00:00:00 | Net | Est. Sales | 2023-08-01 00:00:00 | Net | Est. Sales | 2023-09-01 00:00:00 | Net | Est. Sales | 2023-10-01 00:00:00 | Net | 12 mo History | under - over | Months on hand
420-DE |  |  | 1 | 1 | 90 | 220
MC200-06.00-051 |  |  | 42 | 42 | 17 | 30
MC250-20.00-003-SUB |  |  | 45 | 45 | 9 | 40
MC350-12.00-051 |  |  | 14 | 14 | 25 | 42
MCS250-10.00-000 |  |  | 119 | 119 | 200 | 424
MD200-08.00-029 |  |  | 5 | 5 | 20 | 27
MD200-15.00-000 |  |  | 20 | 20 | 7 | 16
MD225-06.88-078 |  |  | 7 | 7 | 8 | 16
MD225-48.00-846 |  |  | 40 | 40 | 40 | 56
MD250-10.00-000 |  |  | 55 | 55 | 25 | 37
MD300-10.00-000 |  |  | 54 | 54 | 70 | 80
MD300-10.00-180 |  |  | 52 | 52 | 40 | 78
MD300-10.00-387 |  |  | 193 | 0 | 80 | 220 |  | 18 |  |  | 93 |  |  | 150
MD400-10.00-000 |  |  | 126 | 46 | 120 | 340
MD400-12.00-000 |  |  | 96 | 96 | 30 | 20
MD400-22.00-013 |  |  | 12 | 12 | 4 | 12
MS150-16.00-086 |  |  | 16 | 16 | 10
MS200-07.88-078 |  |  | 8 | 8 | 8 | 16
MS200-10.00-000AB |  |  | 0 | 0 | 7 | 25
MS200-10.00-010 |  |  | 26 | 26 | 70 | 64
MS200-18.00-013 |  |  | 61 | 29 | 70 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
MS200-25.00-406 |  |  | 4 | 4 | 15 | 13
MS250-10.00-000 |  |  | 0 | 0 | 15 | 46
MS250-15.00-000 |  |  | 11 | 5 | 6 | 8
MS250-24.00-069 |  |  | 0 | 0 | 5 | 20
MS300-10.00-000AB |  |  | 0 | 0 | 12 | 25
MS300-10.00-000P |  |  | 56 | 56 | 60 | 95
MS300-10.00-021 |  |  | 19 | 19 | 16 | 1
MS300-10.00-170 |  |  | 30 | 30 | 25 | 0
MS300-18.00-000P |  |  | 16 | 16 | 6 | 2
MS350-16.00-170 |  |  | 40 | 40 | 60 | 110
Spreadsheet: 681567d1591637965-count-values-in-one-range-if-the-cells-in-a-corresponding-range-are-not-empty-forum-help
Sheet: Sheet1

[0-10 yrs/oed] | [11-15 yrs/oed] | [16-24 yrs/oed] | [25-34 yrs/oed] | [35-44 yrs/oed] | [45-54 yrs/oed] | [55-64 yrs/oed] | [65-74 yrs/oed] | [75+]
 | 1 | 2 |  | 2 | 1
2 |  | 3 | 1 |  | 2
 | 2 |  |  |  | 2
 |  | 3 |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 | 1 | 1 |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  | 1 |  | 1
 |  | 2 |  |  | 1 | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  |  | 2
2 | 2 |  | 1 | 1
1 | 1 |  |  |  | 1 | 1
 |  | 2 | 1 |  | 1 | 1
1 | 1 |  |  |  | 2
1 |  |  | 1 | 1
Spreadsheet: 849068d1699627008-unique-count-function-test-3-3-
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector | weight
No. of Holdings |  | 3 |  |  |  |  | Fund 1 | Apple | A | 0.098
 |  |  |  |  |  |  | Fund 1 | Apple | A | 0.062
Concentration of top 3 |  | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.081
 |  | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.059
 |  |  |  |  |  |  | Fund 1 | Alphabet | B | 0.033
Positions |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.093
1 | Alphabet | Mastercard |  |  |  |  | Fund 1 | TSMC | A | 0.035
2 | Apple | Meta |  |  |  |  | Fund 1 | AON | C | 0.045
3 | TSMC | Microsoft |  |  |  |  | Fund 1 | Tesla | D | 0.071
 |  |  |  |  |  |  | Fund 1 | Bond | Cash | 0.028
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.041
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.025
 |  |  |  |  |  |  | Fund 2 | Microsoft | A | 0.035
 | Alphabet | Mastercard |  |  |  |  | Fund 2 | Bond | Cash | 0.079
2 | Apple | Meta |  |  |  |  | Fund 2 | Bond | Cash | 0.042
3 | TSMC | Microsoft |  |  |  |  | Fund 2 | Mastercard | C | 0.05
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.052
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: West Gas

West Gas
Originator |  | Commodity |  | Team |  | Total |  | %Total
Tycholiz |  | Gas |  | West
Whitt |  | Gas |  | West
Lucci |  | Gas |  | West
[NAME] |  | Gas |  | West |  | 2009000
Ward |  | Gas |  | West
[NAME] |  | Gas |  | West
Fuller |  | Gas |  | West
Staab |  | Gas |  | West |  | 3013
Total
Spreadsheet: 883683d1732312327-extracting-row-contents-if-column-d-is-not-0-pull-data
Sheet: Materials

Item | Desciption | Quantity
SB-ADB160129 | ADB-160129 Seasoning Blend | 0
SB-BBQ161013 | [NAME] | 0
SB-BDA240820 | [NAME] | 0
SB-BFS | All Beef Weiner N/S #7455-R6 | 170.5464933333333
SB-BHLS | Beef Hot Link Seasoning | 0
SB-BLG160223 | BLG-160223 Seasoning Blend | 0
SB-BS2 | [NAME] | 8.665282499999998
SB-BWS | [NAME] | 0
abc | sbcd | 25
Spreadsheet: 43900d1242552701-average-column-depending-on-values-in-another-column-averages-example-sheet
Sheet: Sheet1

DATE |  | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | GROSS P/L | POINTS | DEPOSITS & WITHDRAWALS
MON |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
TUE |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
WED |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
THU | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 40
FRI | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Week Sub Total |  | 0 | 0 | 0 | 0 |  |  | 0 | 40
MON | 5 | 0 | 0 | 0 | 0 |  |  | 0 | 0
TUE | 6 | 0 | 0 | 0 | 0 |  |  | 0 | 30
WED | 7 | 0 | 0 | 0 | 0 |  |  | 0 | 30
THU | 8 | 0 | 0 | 0 | 0 |  |  | 0 | 0
FRI | 9 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Week Sub Total |  | 0 | 0 | 0 | 0 |  |  | 0 | 60
MON | 12 | 0 | 0 | 0 | 0 |  |  | 0 | 20
TUE | 13 | 0 | 0 | 0 | 0 |  |  | 0 | 0
WED | 14 | 0 | 0 | 0 | 0 |  |  | 0 | 60
THU | 15 | 0 | 0 | 0 | 0 |  |  | 0 | 0
FRI | 16 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Week Sub Total |  | 0 | 0 | 0 | 0 |  |  | 0 | 80
MON | 19 | 0 | 0 | 0 | 0 |  |  | 0 | 0
TUE | 20 | 0 | 0 | 0 | 0 |  |  | 0 | 30
WED | 21 | 0 | 0 | 0 | 0 |  |  | 0 | 30
THU | 22 | 0 | 0 | 0 | 0 |  |  | 0 | 0
FRI | 23 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Week Sub Total |  | 0 | 0 | 0 | 0 |  |  | 0 | 60
MON | 26 | 0 | 0 | 0 | 0 |  |  | 0 | 20
TUE | 27 | 0 | 0 | 0 | 0 |  |  | 0 | 20
WED | 28 | 0 | 0 | 0 | 0 |  |  | 0 | 20
THU |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
FRI |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Week Sub Total |  | 0 | 0 | 0 | 0 |  |  | 0 | 60
 |  | WINS | LOSSES | WIN $ | LOSE $ | WIN % | LOSE % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS |  | 0 | 0 | 0 | 0 |  |  | 0 | 300 | 0
 |  | ACTUAL WIN/LOSS $ (MONTH) |  |  | 0 |  |  | AV. PROFIT $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
 |  |  |  |  |  |  |  | 0 | 15 | #N/A
Spreadsheet: 682730d1592305331-need-formula-for-desired-increment-in-cell-reference-number-instead-of-1-new-microsoft-office-excel-worksheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | wrong result |  |  |  |  |  |  | right result
* | * | * | * | 1 | 8 | 0 | 1 | 0 | 6 | 4 | 0 |  |  |  |  |  |  |  |  | * | * | 9 | 7 | 6
3 | 0 | 3 | 6 | 0 | 6 | 4 | 9 | 0 | 7 | 5 | 4 |  |  |  |  |  |  |  |  | 6 | 12 | 15 | 16 | 11
8 | 7 | 5 | 2 | 6 | 0 | 3 | 1 | 6 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  | *
 |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  | * |  |  |  |  | What I need is, when I try to drag my formula right/down from n2, I get wrong results as shown in wrong result section, instead I want results as right result section which you can see from column U.
 |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  | 7 |  |  |  |  | in the same way, if I have the same data vertically in column M, right result should in a same way
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 158853d1338408698-excel-2007-determining-true-or-false-based-on-multiple-values-correct-example
Sheet: Sheet1

Server Name | Owner Name | Application | Shared? | Expected Result
Server 1 | Owner A | Application A |  | False
Server 1 | Owner A | Application B |  | False
Server 2 | Owner A | Application C |  | True
Server 2 | Owner B | Application D |  | True
Server 2 | Owner B | Application E |  | True
Server 3 | Owner B | Application F |  | True
Server 3 | Owner B | Application G |  | True
Server 3 | Owner B | Application H |  | True
Server 3 | Owner B | Application I |  | True
Server 3 | Owner B | Application J |  | True
Server 3 | Owner A | Application K |  | True |  |  |  |  | `
Spreadsheet: 125532d1319084581-calculating-times-when-the-end-time-could-be-before-the-start-time-cf-for-neg-times
Sheet: Sheet1

Time1 | Time2 | Difference
Spreadsheet: 53409da1-9f35-4c48-8d70-a8671ecbc14b
Sheet: Sheet1

created: 15 Friday November 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
NO | NAMESPACE | VARIABLE | VALUE | LABEL
1 | L | URN | 101082 | Unique Reference Number
2 | L | LA | 212 | Local authority Number
3 | L | ESTAB | 6385 | School number
4 | L | LAESTAB | 2126385 | DfE Number
5 | L | SCHNAME | Newton Preparatory School | School name
6 | L | STREET | 149 Battersea Park Road | Street
7 | L | LOCALITY |  | Locality
8 | L | ADDRESS3 |  | Address
9 | L | TOWN | London | Town
10 | L | POSTCODE | SW8 4BX | Postcode
11 | L | TELNUM | 020 77204091 | Telephone number
12 | L | ICLOSE | Open | Closed school
13 | L | OPENDATE |  | Date school opened since 12th September only
14 | L | CLOSEDATE |  | Date school closed since 12th September only
15 | L | ISNEW |  | New school
16 | L | MINORGROUP | Independent School | Type of school/college
17 | L | NFTYPE | Other Independent School | School type
18 | L | ISPRIMARY | 1 | Primary
19 | L | ISSECONDARY | 1 | Secondary
20 | L | ISPOST16 | 0 | 16-18
21 | L | AGEL | 3 | Lowest age of entry
22 | L | AGEH | 13 | Highest age of entry
23 | L | GENDER |  | Gender of entry
24 | L | SFGENDER | Mixed | Gender of entry to sixth form
25 | L | RELDENOM | Inter- / non- denominational | Denomination
26 | L | ADMPOL | Not collected | Current admissions policy
27 | L | NEWACFLAG | 6 | Flag for Academy
28 | [NAME] | URN | 101082 | Unique Reference Number
29 | [NAME] | LA | 212
30 | [NAME] | ESTAB | 6385
31 | [NAME] | [NAME] | 547 | Total number of pupils on roll (all ages)
32 | [NAME] | NORG | 235 | Number of girls on roll
33 | [NAME] | NORB | 312 | Number of boys on roll
34 | [NAME] | PNORG | 0.43 | Percentage of girls on roll
35 | [NAME] | PNORB | 0.5700000000000001 | Percentage of boys on roll
36 | [NAME] | TSENSAP | NP | Number of pupils SEN statement or on School Action Plus
37 | [NAME] | TSENA | NP | Number of pupils on roll with SEN on School Action
38 | [NAME] | PSENSAP | NP | Percentage of pupils with SEN statement or on School Action Plus
39 | [NAME] | PSENA | NP | Percentage of pupils on roll with SEN on School Action
40 | [NAME] | TOTPUPEALDN | NP | Number of pupils of compulsory school age and above
41 | [NAME] | NUMEAL | NP | Number of pupils with English not as first language
42 | [NAME] | NUMUNCFL | NP | Number of pupils where first language is unclassified
43 | [NAME] | PNUMEAL | NP | Percentage of pupils with English not as first language
44 | [NAME] | PNUMUNCFL | NP | % pupils where first language is unclassified
45 | [NAME] | TOTPUPFSMDN | NP | Number of pupils used in FSM calculation
46 | [NAME] | NUMFSM | NP | Total pupils eligible for free school meals
47 | [NAME] | PNUMFSM | NP | Percentage of  pupils eligible for free school meals
48 | [NAME] | NUMFSMEVER | NP | Number of pupils eligible for FSM at any time during the past 6 years
49 | [NAME] | PNUMFSMEVER | NP | Percentage of pupils eligible for FSM at any time during the past 6 years
Spreadsheet: 839705d1692174992-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-rick-r
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Mockup |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] | Latest
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | E1 | E2 | LP | Speed |  | E1 | E2 | LP | Speed |  |  | E1 | E2 | LP | Speed
 | 1 Smoke Wagon |  |  | 85/ 73 | 67 |  |  |  |  |  |  |  | 0 | 85 | 73 | 67 |  |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 |  | 71* |  |  |  |  |  |  |  | 86 | 0 | 0 | 71 |  |  |  | 0 | 0 | 71 |  | 86 | 0 | 0 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  |  |  | 66 |  |  |  |  |  |  |  | 0 | 0 | 0 | 66 |  |  |  | 0 | 0 | 66 |  | 0 | 0 | 0 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  | 85 | 87 | 75 | 72 |  |  |  | 87 | 75 | 72 |  | 85 | 87 | 75 | 72
 |  |  |  |  |  |  |  |  |  |  |  |  | Mockup |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] | Latest
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | E1 | E2 | LP | Speed |  | E1 | E2 | LP | Speed |  |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  |  | 85/ 57 * | 66* |  |  |  |  |  |  |  | 0 | 85 | 57 | 66 |  |  |  | 85 | 57 * | 66 |  |  | 85 | 57 * | 66
 | 2 R Girl Faith |  | 79 |  | 63* |  |  |  |  |  |  |  | 79 | 0 | 0 | 63 |  |  |  | 0 | 0 | 63 |  | 79 | 0 | 0 | 63
 | 5 Vaccina |  |  |  | 63* |  |  |  |  |  |  |  | 0 | 0 | 0 | 63 |  |  |  | 0 | 0 | 63 |  | 0 | 0 | 0 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * |  |  |  |  | 51 |  |  |  | 79 | 67 | 51 | 0 |  |  |  | 67 | 51 * | 0 |  | 79 | 67 | 51 * | 0
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  | 82 | 71 | 50 | 53 |  |  |  | 71 | 50 * | 53 |  | 82 | 71 | 50 * | 53
 | 6 Calvary Kat |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Silver Token |  | 81 | 77/ | 65* |  |  |  |  |  |  |  | 81 | 77 | 0 | 65 |  |  |  | 77 |  | 65 |  | 81 | 77 |  | 65
 | 7 R Boy Bode |  | 87 | / 76 * | 70* |  |  |  |  |  |  |  | 87 | 0 | 76 | 70 |  |  |  |  | 76 * | 70 |  | 87 |  | 76 * | 70
Spreadsheet: 861298d1709210595-finding-matches-from-different-sheets-and-gathering-them-in-one-sheet-sample
Sheet: Full list

Employee # | First Name | Middle Name | Last Name | Work Email | Location | Department | Job Title | Reporting to | Hire Date | Termination Date | Training1 | Training2
1 | [NAME] | [NAME] | [NAME] | [EMAIL] | NY | Dep1 | Title1 | Manager1 | 2023-08-01 00:00:00 |  | Group1 | Completed
2 | [NAME] | Green | [NAME] | [EMAIL] | London | Dep2 | Title2 | Manager2 | 2024-02-05 00:00:00 |  |  | Completed | Group1 | Completed
3 | Gloria | [NAME] | [NAME] | [EMAIL] | Berlin | Dep3 | Title3 | Manager3 | 2023-08-01 00:00:00 | 2023-12-04 00:00:00 |  | Completed |  | Completed
4 | Anette | J. | Steinrot | [EMAIL] | Paris | Dep4 | Title4 | Manager4 | 2023-07-03 00:00:00 |  | Group2 |  | Group2
Spreadsheet: 775414d1649090220-automation-for-excel-updations-from-one-sheet-to-another-some-dummy-data
Sheet: Pivot Table

Type | Network | Platform | Deal Status | Domestic / International
B'Cast Linear | A | DD | Target | Domestic
 |  | FF | DEAL | Domestic
 |  | SFAFSFS | Target | Domestic
 |  | tbyu | DEAL | Domestic
 |  | XX | DEAL | Domestic
 | B | gf86btff | DEAL | Domestic
 |  | ihgn7nff | Target | Domestic
 |  | jhhj | DEAL | Domestic
 |  | [NAME] | DEAL | Domestic
 |  | ytb786t6 | Target | Domestic
 | C | gf76rfrf | Target | Domestic
 |  | 9ug8tt8m | DEAL | International
 |  | fdtrsc63w | DEAL | Domestic
 |  | gyb6tft | Active | Domestic
 |  | hign8tf5tf | Target | Domestic
B'Cast Linear Total
vMVPD | A | fvfvvffngh | DEAL | Domestic
 |  | RSGSDFDS | DEAL | International
 | B | i0i0 | DEAL | Domestic
 |  | ijhn76t65rf | Active | International
 | C | hg6nm | Active | Domestic
 |  | huyn | DEAL | Domestic
 |  | junmgtgf | DEAL | Domestic
vMVPD Total
[NAME] | A | fhfu8fufh | DEAL | International
 |  | hvgvuvjhvu | DEAL | Domestic
 |  | XZXCFDDF | DEAL | Domestic
 | B | dddsdd | DEAL | Domestic
 |  | fiffis | DEAL | International
 |  | sfjsfsf9 | DEAL | Domestic
VOD Digital Total
Grand Total
Spreadsheet: 819094d1677212300-how-to-return-number-of-quarters-from-start-date-then-return-zero-after-end-date-passed-excel-model-date-question
Sheet: Sheet1

 | Start | End |  | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00
 | 2023-01-01 00:00:00 | 2023-07-01 00:00:00 |  | 1 | 2 | 0
 | Start | End |  | 1Q23 | 2Q23 | 3Q23
 | 1Q23 | 3Q23 |  | 1 | 2 | 0
Spreadsheet: 108182d1305235546-excel-2007-sumifs-inside-of-a-vlookup-budchevy_sumifs
Sheet: Sheet3

 |  | Legacy Style ID | Legacy Size | Units [NAME]