tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: ARUBA-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 | 6704796 | 32931072
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 27782001 | 138485881
4 |  | Option Premiums
5 |  | Dmd Reimbursements | 0 | 1389607
 | Total Sales: |  | 34486797 | 172806560
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -3506499 | -15932751 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -31131503 | -153700145
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 152406 | 761543
 | Total Purchases: |  | -34485596 | -168871353
 |  |  | 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 | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -1201 | -5452.54
 |  |  | 0 | 0
23 | Fuel: |  | -152406 | -761543
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -40899
25 |  | Demand | 0 | -1389607
 | Total Transport Expense: |  | 0 | -1430506
 |  |  | 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 | 10826623.5614
31 |  | Prior Month Book Balance | 0 | -9772632.887499996
 |  | Total MTM Income | 0 | 1053990.673900008
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -583972.8961
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -1319014
 |  | TOTAL INTRA-MTH
Spreadsheet: 186786d1350220212-need-to-refer-to-alternate-rows-refertoalternatecells
Sheet: ManagedList

 |  |  |  |  | < |  |  | Due to the formatting problems when copying from webpages, there are unwanted rows between the important information rows.  How do I copy from the other sheet's alternate cells so as to remove all the empty ("0") cells?
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
 |  |  |  |  | <
Spreadsheet: 266299d1379576647-copying-a-specific-row-from-another-sheet-depending-on-a-cell-value-0a211
Sheet: September

 |  | Daily Takings |  |  | September
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | 38
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
Spreadsheet: 700378d1603176044-autofill-year-for-data-transformation-autofill-year-for-data-transform
Sheet: Sheet1

Name | Contract Start | Contract End |  |  | Name | Effective Contract
[NAME] | 2005 | 2020
[NAME] | 2006 | 2018
abc | 2001 | 2005
Spreadsheet: 112912d1308862779-pick-random-name-if-their-score-is-random-pick
Sheet: Sheet1

Name |  |  | [NAME] | bob 2 | sue 2 | [NAME] | bob 3 | sue 3 | [NAME] | bob 4 | sue 4 | [NAME] | bob 5 | sue 5 | [NAME] | bob 6 | sue 6 | [NAME] 6 | bob 7 | sue 7 | [NAME] | bob 8 | sue 8 | [NAME] | bob 9 | sue 9 | [NAME] 9 | bob 10 | sue 10 | [NAME] 10 | bob 11 | sue 11 | [NAME] | bob 12 | sue 12 | [NAME] | bob 13 | sue 13 | [NAME] | bob 14 | sue 14 | [NAME] 14 | bob 15 | sue 15 | [NAME] 15 | bob 16 | sue 16 | [NAME] | bob 17 | sue 17 | [NAME] | bob 18 | sue 18 | [NAME] | bob 19 | sue 19 | [NAME] 19 | bob 20 | sue 20 | [NAME] 20 | bob 21 | sue 21 | [NAME] 21 | bob 22 | sue 22 | [NAME] | bob 23 | sue 23 | [NAME] 23 | bob 24 | sue 24 | [NAME] 24 | bob 25 | sue 25 | [NAME]
Data |  |  | Data will go in the cells that will add up to the Score
Score |  |  | 0.4 | 3.4 | 0 | 1.8 | 0 | 9 | 7.6 | 5.6 | 1.2 | 38 | 5 | 12.8 | 20.8 | 3.8 | 8 | 0.2 | 8.8 | 13.2 | 8.8 | 19.2 | 1.2 | 0 | 3.8 | 0.2 | 18.2 | 0.2 | 25.2 | 4 | 0 | 1.4 | 0.4 | 13.4 | 8.6 | 20.6 | 12.2 | 0 | 9.4 | 19.6 | 7.8 | 0 | 33.8 | 0.2 | 1 | 14.8 | 8.4 | 0 | 1.2 | 0 | 0.2 | 2.6 | 0 | 0 | 0 | 2.8 | 6 | 2.6 | 0 | 3.6 | 0 | 2.2 | 23.4 | 0.2 | 1.6 | 16.4 | 19.8 | 8.4 | 1.6 | 4 | 0.2 | 8.8 | 63 | 1.2 | 1
Spreadsheet: 149711d1334090110-excel-2010-incorrect-axis-on-graph-it-runbook-march-2012-in-progress
Sheet: Help Desk

Help Desk KPI | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-02 00:00:00
Total Calls Answered | 1144 | 1147 | 1250 | 1194 | 1094 | 1427 | 1151 | 1435 | 3057 | 1998 | 1736 | 1752 | 2242 | 1977 | 2582 | 1966 | 2513 | 2890 | 2310 | 2780 | 2457 | 2408 | 2904 | 4108 | 4531 | 3477 | 8058
Total Tickets Created | 1010 | 835 | 970 | 819 | 772 | 921 | 769 | 806 | 2088 | 1077 | 993 | 875 | 1445 | 1198 | 1489 | 1150 | 1707 | 1997 | 1506 | 1914 | 1767 | 2255 | 2320 | 3072 | 3400 | 2854 | 7852
Resolved on First Call | 645 | 493 | 553 | 474 | 477 | 544 | 473 | 443 | 1476 | 625 | 482 | 417 | 893 | 745 | 671 | 532 | 969 | 1140 | 857 | 1109 | 1151 | 1167 | 858 | 1549 | 1766 | 1542 | 1335
Avg FTEs on Phone | 3.5 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.5 | 2.75 | 3 | 3 | 3 | 3 | 3.2 | 3.45 | 4.35 | 4.35 | 3.75 | 2.45 | 4.3 | 4.5 | 4.6 | 5.2 | 5.2 | 4.5 | 7.25
Abandonment Rate | 6.4 | 7.5 | 8.2 | 7.5 | 6.1 | 9.2 | 10.1 | 9.1 | 27.4 | 20.6 | 15.6 | 14.7 | 16.6 | 12.9 | 11 | 13.5 | 15.6 | 17.9 | 19 | 18.6 | 12.7 | 10.3 | 12.1 | 8.5 | 11.37 | 14.1 | 8.3
Survey | 4.82 | 4.74 | 4.82 | 4.8 | 4.6 | 4.8 | 4.77 | 4.74 | 4.77 | 4.76 | 4.69 | 4.5 | 4.64 | 4.64 | 4.57 | 4.54 | 4.73 | 4.75 | 4.78 | 4.69 | 4.74 | 4.66 | 4.8 | 4.9 | 4.86 | 4.8 | 4.7
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Block 9

Block 9
Sub-mainline Sizing and Pressure
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 0 | feet, Total Elevation Drop
 |  | feet, Length of Sub-mainline
 |  | ft/ft, Change in Elevation
 | 0.5 | GPH/emitter
 |  | GPM/emitter
 |  | ft, emitter spacing
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section A
Row | Row Length ft | GPM per Row | Pressure PSI | Length ft | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 0 | 25 | 0 | 51 | 2.193
1 | 179.2 |  |  | 2.2 |  | 2.193
 | 571.3 |  |  | 7.7 |  | 2.193
 | 572.3 |  |  | 7.7 |  | 2.193
 | 573.2 |  |  | 7.7 |  | 2.193
 | 574.2 |  |  | 7.7 |  | 2.193
 | 575.2 |  |  | 7.7 |  | 2.193
 | 576.2 |  |  | 7.7 |  | 2.193
 | 577.2 |  |  | 7.7 |  | 2.193
 | 578.2 |  |  | 7.7 |  | 2.193
 | 579.1 |  |  | 7.7 |  | 2.193
 | 580.1 |  |  | 7.7 |  | 2.193
 | 581.1 |  |  | 7.7 |  | 1.72
 | 582.1 |  |  | 7.7 |  | 1.72
 | 583.1 |  |  | 7.7 |  | 1.72
 | 584.1 |  |  | 7.7 |  | 1.72
 | 585.1 |  |  | 7.7 |  | 1.72
 | 586 |  |  | 7.7 |  | 1.72
 | 587 |  |  | 7.7 |  | 1.72
 | 588 |  |  | 7.7 |  | 1.72
 | 590 |  |  | 7.7 |  | 1.72
 | 590 |  |  | 7.7 |  | 1.72
 | 591 |  |  | 7.7 |  | 1.72
 | 591.9 |  |  | 7.7 |  | 1.72
 | 592.9 |  |  | 7.7 |  | 1.72
 | 593.9 |  |  | 7.7 |  | 1.72
 | 594.9 |  |  | 7.7 |  | 1.72
 | 595.9 |  |  | 7.7 |  | 1.72
 | 312.9 |  |  | 7.7 |  | 1.72
 | 293.4 |  |  | 7.7 |  | 1.72
 | 273.9 |  |  | 7.7 |  | 1.72
 | 254.4 |  |  | 7.7 |  | 1.72
Section B
 | 319.2 |  | 23 |  | 51 | 2.193
 | 234.8 |  |  | 83.7 |  | 2.193
 | 150.4 |  |  | 83.7 |  | 2.193
 | 66.1 |  |  | 83.7 |  | 2.193
 |  | Min P |  | PSI
 |  | [NAME] |  | PSI
 |  | Avg. P, PSI
 | Total GPM
 | Sub-Main Length, ft
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: Consolidated

INCOME STATEMENT - GENCO
('000 $) | 2000-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | Check
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Mobilization
Fixed Operation & Maintenance
Variable Operation & Maintenance
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
Spreadsheet: 866a1afc-c9d0-4e88-8718-0c3b9a9a1c62
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7784 | 57193 | Angelique | Vanderlinden | NED | 0 | 01:02:53 | 00:01:27 | 01:44:35 | 00:01:19 | 00:34:20 | 1 | 03:24:33
7784 | 16201 | Rahel | Bellinga | NED | 0 | 01:04:16 | 00:01:21 | 01:42:58 | 00:01:46 | 00:35:19 | 2 | 03:25:39
7784 | 57037 | [NAME] | [NAME] | LUX | 0 | 01:01:02 | 00:01:30 | 01:52:06 | 00:01:51 | 00:35:55 | 3 | 03:32:25
7784 | 57192 | Esther | Vanduijnhoven | NED | 0 | 01:12:16 | 00:01:51 | 01:56:45 | 00:02:09 | 00:41:58 | 4 | 03:54:58
7784 | 13004 | [NAME] | Bimmel | NED | 0 | 01:14:49 | 00:01:58 | 02:02:24 | 00:02:09 | 00:45:10 | 5 | 04:06:29
Spreadsheet: 828032d1683197686-average-timings-exercise-average-timings-updated
Sheet: Snapshot

 |  | 2023
 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total
 | Average Timings |  |  |  |  |  |  |  |  |  |  |  |  | Yearly Average
 | External |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between F2 and G2 by month. It is important to ignore if there are blank cells on G2.
 | Cash Received |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between B2 and E2 by month. It is important to ignore if there are blank cells on E2.
 | Letter To Authorities |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between C2 and D2 by month. It is important to ignore if there are blank cells on D2.
 | Authorities Response
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between B2 and D2 by month and by category (Column A). It is important to ignore if there are blank cells on D2.
 | Lim |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I also want to calculate the total average timings for each category on a yearly basis.
 | Paf
 | Lar
 | Amm
Spreadsheet: 118659d1313853118-how-to-extract-a-string-within-another-string-lookup-from-a-list-v2
Sheet: Sheet1

Full Name | Last Name | First name | Middle Name | Suffix | OR SUFFIX |  | JR. | JR
RAMOS, [NAME] |  |  |  | III | III |  | SR. | SR
 |  |  |  |  |  |  | III | III
 |  |  |  |  |  |  | II | II
SMITH, [NAME] |  |  |  |  |  |  | I | I
DE LEON, [NAME]. HENRY |  |  |  | JR. | JR
RAMOS, [NAME] |  |  |  | III | III |  | note:
SMITH, [NAME] |  |  |  |  |  |  | list in col h contains spaces
DE LEON, [NAME]. HENRY |  |  |  | JR. | JR |  | where needed
RAMOS, [NAME] |  |  |  | II | II
RAMOS, [NAME] |  |  |  | I | I
DE LEON, [NAME]. HENRY |  |  |  | SR. | SR
 |  |  |  | THIS RETURNS FROM COL H | THIS RETURNS FROM COL  I
Spreadsheet: 33830d1230668239-compound-if-statement-example
Sheet: Sheet1

Start | End | Total Derated Funding | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-02 00:00:00 | 2010-01-02 00:00:00 | 2010-02-02 00:00:00 | 2010-03-05 00:00:00 | 2010-04-05 00:00:00 | 2010-05-06 00:00:00 | 2010-06-06 00:00:00 | 2010-07-07 00:00:00 | 2010-08-07 00:00:00 | 2010-09-07 00:00:00 | 2010-10-08 00:00:00 | 2010-11-08 00:00:00 | 2010-12-09 00:00:00 | 2011-01-09 00:00:00 | 2011-02-09 00:00:00 | 2011-03-12 00:00:00 | 2011-04-12 00:00:00 | 2011-05-13 00:00:00 | 2011-06-13 00:00:00 | 2011-07-14 00:00:00 | 2011-08-14 00:00:00 | 2011-09-14 00:00:00 | 2011-10-15 00:00:00 | 2011-11-15 00:00:00 | 2011-12-16 00:00:00 | 2012-01-16 00:00:00 | 2012-02-16 00:00:00 | 2012-03-18 00:00:00 | 2012-04-18 00:00:00 | 2012-05-19 00:00:00 | 2012-06-19 00:00:00 | 2012-07-20 00:00:00 | 2012-08-20 00:00:00 | 2012-09-20 00:00:00 | 2012-10-20 00:00:00 | 2012-11-20 00:00:00 | 2012-12-20 00:00:00
2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 85000 | 28333.33333333333 | 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
Spreadsheet: 0a48d92e-9759-4ffb-b25c-7b0fad088764
Sheet: Sheet1

[NAME] (4-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 697142d1601216018-sum-data-but-separate-the-positive-and-negative-balance-sample1-4-ans
Sheet: Sheet1

USER | Value
A | 1
B | -1 |  | Table 1 details entry for Deposit and [NAME] |  |  |  |  |  |  | For +ve numbers
C | 2 |  |  |  |  |  |  |  |  | For -ve Numbers
D | -2 |  | Needed a formula that works out the total owe and total deposit
E | 3 |  | [NAME]
F | -3 |  | So it would be |  |  | Then
G | 4 |  | A |  |  | Holding |  | Hoping a formula to achive this value without step 2
A | -4 |  | B |  |  | Lending |  | Hoping a formula to achive this value without step 2
B | 3 |  | C
C | 7 |  | D
D | -5 |  | E
E | 4 |  | F
F | 2 |  | G
G | 5
Spreadsheet: chris_germany__2126__NPCMAR31ACTUALSENA
Sheet: Mar 31

 | NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-03-31 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME] |  |  |  |  |  |  |  |  |  |  | Sto | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 750 |  | 654 |  | 67694 |  |  |  |  |  | 42 | 1 | 41 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 2 | 36
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 4660 |  | 7497 |  | 67694 | 0.12 |  |  |  |  | 44 | 3 | 43 |  |  |  |  |  |  | 1064
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 4 | 38
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1821 |  | 2573 |  | 67694 | 0.16 |  |  |  |  | 47 | 5 | 46 |  |  |  |  |  |  | 387
 |  |  |  |  |  |  |  |  | 1300 |  | 1300 |  | 68915 | 0 |  | 0 |  |  | 46 | 6 | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 7 | 38
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 7415 |  | 8143 |  | 67694 | 0.12 |  |  |  |  | 47 | 8 | 45 |  |  |  |  |  |  | 251
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 9 | 41
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 675 |  | 807 |  | 67694 | 0.19 |  |  |  |  | 47 | 15 | 49 |  |  |  |  |  |  | 105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 35 | 39
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1560 |  | 2087 |  | 67694 |  |  |  |  |  | 43 | 39 | 38 |  |  |  |  |  |  | 172
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 2178 |  | 2926 |  | 67694 | 0.16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 303
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1055 |  | 1055 |  | 67694 | 0.12 |  |  |  |  | % |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2040 |  | 2321 |  | 67694 |  |  |  |  |  | #67694 |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.11
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 2846 |  | 3529 |  | 67694 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 155
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1917 |  | 2010 |  | 67694 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 271
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 31 |  | 36 |  | 67694 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11122 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54324 |  | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 6

Name | lbs | oz | Oz (total) | Points
 | 15 | 1
 | 13 | 4
 | 44 | 0
 | 55 | 0
 | 7 | 1
 | 12 | 3
 | 1 | 8
 | 8 | 0
 | 14 | 2
 | 10 | 0
 | 8 | 0
 | 9 | 0
 | 8 | 6
Spreadsheet: 64839d1265662673-how-to-write-a-macro-for-command-button-how-to-write-a-macro-for-command-button
Sheet: Sheet1

Sr. # |  |  | On Hold | Search Received
1 | [NAME] | In | Yes | No
2 | [NAME] | In | Yes | No
3 | [NAME] | In | Yes | No
4 | Scott | In | No | No
5 | Rita | Out | No | Yes
6 | Canaan | Out | No | Yes
7 | [NAME] | Out | No | Yes
8 | [NAME] | Out | No | No
9 | [NAME] | In | Yes | No
10 | [NAME] | In | No | No
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Feb 14 to 20

 | Week summary (Feb 14 to 20)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 835961d1689000904-dependent-drop-downs-across-rows-new-hire-template
Sheet: TEMPLATE

No | Preffered Name | First Name | Surname | NoEntry - Surname (no spaces) | Company [NAME] | Personal Email | Personal Phone Number | Start Date | Select Regional Group for AD | Select Department for AD | Select Job  Title ( add titles to sheet JobTitles) | The Manager for AD (Reports to) | Monitor (y or n) | Laptop (y or n) | Other Hardware (Specify) | End Date | Model User for Security Group
 |  |  |  |  | use [NAME] down |  | valid number | valid date | select 1st | select 2nd | select 3rd |  |  |  |  | valid date
1 | Example | Name | Name De Name |  |  | [EMAIL] |  |  | Cameroon | OpCo-Administration | Administrative Assistant
Spreadsheet: 66640d1267270296-linking-data-to-different-tabs-in-excel-staff-5
Sheet: employee 5

employee 5
task | date
Spreadsheet: 761280d1640795615-index-match-return-maximum-value-index-match-return-maximum-value
Sheet: Sheet1

Participant | Course | Score |  |  |  | A
annelies | A | 0.8 |  |  | annelies
francois | A | 0.7
jean | A | 0.7
geert | A | 0.9
sostene | A | 0.9
prince | A | 0.7
prince | A | 0.85
annelies | A | 0.85
esther | A | 1
[NAME] | B | 0.9
[NAME] | B | 0.71
rachel | B | 0.86
jiska | B | 0.86
telesphore | B | 1
[NAME] | C | 0.71
roreen | C | 0.86
jennifer | C | 0.86
[NAME] | C | 0.71
[NAME] | C | 0.86
Spreadsheet: 481920d1474746216-lookup-a-formula-example
Sheet: Main

 |  | Name | x | x2 | [NAME] | x4 | Result
 |  | A |  | 1 | 5 |  | = formula 1
 |  | B |  | 2 | 4 |  | = formula 2
 |  | C |  | 3 | 3 |  | = formula 3
 |  | D |  | 4 | 2 |  | = formula 4
 |  | E |  | 5 | 1 |  | = formula 5
 |  | Name | x | x2 | [NAME] | x4 | Result
 |  | A | 5 | 1 | 1 | Q
 |  | B | 5 | 2 | 2 | W
 |  | C | 5 | 3 | 3 | E
 |  | D | 5 | 4 | 4 | R
 |  | E | 5 | 5 | 5 | T
Spreadsheet: 197705d1354540231-linking-a-worksheet-to-a-pivot-table-example-1-
Sheet: Source data

Catagory | Month | Site 1 | Site 2 | Site 3
Sales | October | 1000
Sales | November | 2000
Direct Wages Gross | October | 800
Direct Wages Gross | November | 1600
Direct Wages ERS NIC | October | 100
Direct Wages ERS NIC | November | 150
Branch staff salaries and ERS NIC | October | 30
Branch staff salaries and ERS NIC | November | 60
Rent and Rates | October | 100
Rent and Rates | November | 100
Heat, Light and Power | October | 20
Heat, Light and Power | November | 22
Motor Expenses | November | 10
Travelling and Entertainment | October | 11
Printing and Stationery | October | 2
Printing and Stationery | November | 3
Professional Fees | October | 5
Professional Fees | November |  |  | 8
Bank Charges and Interest | October | 3
Bank Charges and Interest | November | 3
Bad Debts | October | 1
Bad Debts | November | 1
General Expenses | October | 2
General Expenses | November | 2
Suspense & Mispostings | November | 1
Insurances | October | 2
Insurances | November | 2
Repairs and renewals | October | 2
Repairs and renewals | November | 2
Hotels | October | 2
Hotels | November |  | 2
Staff Entertaining | October | 3
Staff Entertaining | November | 1
Work wear | October | 2
Work wear | November |  |  | 4
Vehicle Leasing | October | 2
Vehicle Leasing | November | 3
Telephone | October | 5
Telephone | November | 3
Computer maintenance and support | October | 3
Computer maintenance and support | November | 3
Other Pensions | October | 1
Other Pensions | November | 1
[NAME] Claims | October | 2
[NAME] Claims | November | 2
Advertising | October |  |  | 2
Advertising | November | 1
Staff Training | October | 2
Staff Training | November | 2
Depreciation | October | 2
Depreciation | November | 2
Class 1A NIC | October | 2
Class 1A NIC | November | 2
Clock Card Costs | October | 3
Clock Card Costs | November | 1
[NAME] | October | 2
[NAME] | November | 2
Workwear Deposits | November | 3
Parking Fine Contributions | October | 1
Parking Fine Contributions | November | 2