tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM
EXTENSION: [PHONE]
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: db1336f8-e01b-4ee5-97b4-d9ddaed5e697
Sheet: Sheet1

Mileage Chart | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | PHCC | PSCC | WKCC | ENCC | EWCC | PRCC | OCC | LCCC | PCCC | PW | RC
PHCC |  | 28 | 45 | 35 | 30 | 54 | 72 | 36 | 19 | 7 | 95
PSCC | 28 |  | 17 | 63 | 32 | 26 | 44 | 53 | 45 | 21 | 88
WKCC | 45 | 17 |  | 80 | 33 | 26 | 44 | 54 | 62 | 38 | 85
ENCC | 35 | 63 | 80 |  | 71 | 87 | 107 | 47 | 52 | 40 | 102
EWCC | 30 | 32 | 33 | 71 |  | 26 | 44 | 20 | 19 | 26 | 131
PRCC | 54 | 26 | 26 | 87 | 26 |  | 18 | 47 | 45 | 46 | 100
OCC | 72 | 44 | 44 | 107 | 44 | 18 |  | 65 | 63 | 63 | 81
LCCC | 36 | 53 | 54 | 47 | 20 | 47 | 65 |  | 16 | 42 | 125
PCCC | 19 | 45 | 62 | 52 | 19 | 45 | 63 | 16 |  | 23 | 111
PW | 7 | 21 | 38 | 40 | 26 | 46 | 63 | 42 | 23 |  | 88
RC | 95 | 88 | 85 | 102 | 131 | 100 | 81 | 125 | 111 | 88
Spreadsheet: 685970d1594299145-keep-getting-my-formula-is-missing-parenthesis-example-dataxlsx
Sheet: EDGE Data

Product | Invoice Number | Income | Income Currency | Expenditure | Expenditure Currency | Day | Time Spent Packers | Time Spent Labellers | Total Amount paid
Doll | 12456 | 0 |  | 31.86 | £ | Tuesday | 10 | 0
Doll | 12456 | 0 |  | 39.83 | £ | Tuesday | 0 | 30
Doll | 12456 | 0 |  | 19.91 | £ | Tuesday | 0 | 15
Doll |  | 0 |  | 35.85 | £ | Tuesday | 5 | 15
Doll |  | 0 |  | 51.78 | £ | Tuesday | 10 | 15
Sandwich | 12456 | 0 |  | 31.86 | £ | Tuesday | 10 | 0
Sandwich |  | 0 |  | 6.64 | £ | Tuesday | 0 | 5
Sandwich | 12456 | 0 |  | 35.85 | £ | Tuesday | 5 | 15
Sandwich | 12489 | 0 |  | 44.02 | £ | Monday | 0 | 0
Sandwich | 12489 | 0 |  | 26.55 | £ | Monday | 0 | 20
Sandwich | 12489 | 0 |  | 39.83 | £ | Monday | 0 | 30
Sandwich | 12489 | 0 |  | 13.83 | £ | Monday | 0 | 0
Car | 12489 | 0 |  | 26.55 | £ | Monday | 0 | 20
Sandwich | 12489 | 0 |  | 19.91 | £ | Monday | 0 | 15
Car | 12489 | 0 |  | 16.35 | £ | Monday | 0 | 0
Car | 12489 | 0 |  | 83.64 | £ | Monday | 20 | 15
Car |  | 0 |  | 163.29 | £ | Monday | 45 | 15
Car | 12489 | 0 |  | 54.43 | £ | Monday | 15 | 5
Truck | 12489 | 0 |  | 115.5 | £ | Monday | 30 | 15
Truck |  | 0 |  | 13.28 | £ | Monday | 0 | 10
Truck | 12489 | 0 |  | 63.72 | £ | Monday | 20 | 0
Soldier | 12489 | 0 |  | 35.85 | £ | Monday | 5 | 15
Soldier | 12489 | 0 |  | 19.91 | £ | Monday | 0 | 15
Soldier |  | 0 |  | 51.78 | £ | Monday | 10 | 15
Soldier | 12489 | 0 |  | 31.86 | £ | Monday | 10 | 0
 | 12489 | 0 |  | 90.28 | £ | Monday | 20 | 20
Soldier |  | 0 |  | 35.85 | £ | Monday | 5 | 15
Spreadsheet: 103371d1301095018-find-vlookup-exceptions-vlookup-exception-help-day92
Sheet: What I Have

Team A | Pending
[NAME]
[NAME]
[NAME] |  | Example of what I have,
Pam |  | colored sections the master,
Totals |  | and paste data from pivot
Team B | Pending | table at A24, data pulls up great.
[NAME]
Shawn |  | Problem is, John & Stephanie down
Viv |  | there are left out.
[NAME]
[NAME]
[NAME]
Totals
Team C | Pending
Julie
[NAME]
[NAME]
Brooke
[NAME]
Totals
Office Total
emp | pend
[NAME] | 38
[NAME] | 42
[NAME] | 162
Pam | 211
[NAME] | 63
Shawn | 30
Viv | 140
[NAME] | 94
[NAME] | 304
[NAME] | 304
Julie | 6
[NAME] | 4
[NAME] | 84
Brooke | 344
[NAME] | 28
[NAME] | 47
[NAME] | 82
Spreadsheet: 694742d1599769848-how-to-use-sum-with-index-match-function-sum-using-index-match
Sheet: Sheet1

Item | Vol |  |  | Item | Total Vol
366 | 30 |  |  | 366
357 | 50 |  |  | 329
433 | 87 |  |  | 345
366 | 64 |  |  | 433
329 | 21
7060 | 89
345 | 35
7003 | 67
366 | 82
433 | 12
7060 | 3
Spreadsheet: 717759d1612835121-forecast-function-and-drop-down-electoralmargins
Sheet: Sheet2

Select state:
YEAR | MARGIN | FORECAST
1900 | 32.28
1904 | 49.55
1908 | 51.62
1912 | 63.28
1916 | 59.47
1920 | 35.8
1924 | 53.93
1928 | -3.67
1932 | 76.72
1936 | 74.76
1940 | 62.01
1944 | 54.78
1948 | 41.68
1952 | -6.44
1956 | -11.28
1960 | 2
1964 | 26.82
1968 | 1.27
1972 | -32.96
1976 | 3.17
1980 | -13.86
1984 | -27.5
1988 | -12.6
1992 | -3.48
1996 | -4.93
2000 | -21.32
2004 | -22.86
2008 | -11.75
2012 | -15.77
2016 | -8.97
2020 | -5.58
2024
2028
2032
2036
2040
Spreadsheet: 122029d1316565481-using-sum-and-count-to-determine-max-salestotalsleaderboardweb
Sheet: Sheet1

Salesperson | Product 1 | Product 2 | Product 3 | Totals
[NAME] 1 | 9 | 4 | 3
[NAME] 2 | 2 | 0 | 0
[NAME] 3 | 2 | 0 | 3
[NAME] 4 | 7 | 9 | 6
Salesperson 5 | 1 | 0 | 0
[NAME] 6 | 22 | 10 | 6
[NAME] 7 | 22 | 2 | 4
[NAME] 8 | 28 | 10 | 10
Spreadsheet: 163336d1340280071-pivot-tables-pivot-chart-data-839944
Sheet: Sheet1

Sum of Rate | District
Date | Birmingham | Carlisle | Grand Total
2011-07-01 00:00:00 | 10.6 | 3.6 | 14.2
2011-08-01 00:00:00 | 11 | 3.7 | 14.7
2011-09-01 00:00:00 | 11.1 | 3.7 | 14.8
Grand Total | 32.7 | 11 | 43.7
Spreadsheet: 168065d1342204489-excel-2007-help-pay-scale-calculation-sheet-help-hourly-timesheet-7-12-12
Sheet: JOB 1279

Description | Job Code | [NAME]
A/C MECHANIC | A/C M
A/C MECHANIC HELPER | A/C M H
A/C SERVICE MAN | A/C SRVC
A/C SERVICE MAN HELPER | A/C SRVC H
CARPENTER | CRPT | 10.64
ELECTRICIAN | ELEC | 19.51
ELECTRICIAN TECHNICIAN | ELEC T
ASBESTOS / INSULATION WORKER | INSUL | 21.17
IRON WORKER | IRON WRKR | 18.5
LABORER | LAB
LABORER SKILLED | LAB S
LABORER UN-SKILLED | LAB UN-S | 7.25
PLUMBER-PIPEFITTER (INCL. HVAC) | PLMB-PFTR | 29.78
PLUMBER-PIPEFITTER HELPER (INCL. HVAC) | PLMB-PFTR H
SHEET METAL WORKER | SMW
SHEET METAL WORKER (DUCT) | SMW DUCT | 25.18
SHEET METAL WORKER (DUCT) HELPER | SMW DUCT H
SHEET METAL WORKER (OTHER) | SMW OTHER | 11.62
SHEET METAL WORKER (ROOF) | SMW ROOF
SHEET METAL WORKER (ROOF) HELPER | SMW ROOF H
Spreadsheet: 830282d1684845353-lookup-match-structed-table-360-photos-required
Sheet: Unplanned orders

From |  |  | To |  |  |  |  |  |  | =VLOOKUP(Table_Query_from_Kerry_Live[[#This Row],[WarehouseProductGroup]],'Prod sites'!A:B,2,FALSE) | =SUMIFS('Current stock'!F:F,'Current stock'!B:B,Table_Query_from_Kerry_Live[[#This Row],[Product]]) | =IF(L4=K4,"picked",IF((K4-L4)>O4,"Possible Shortage","ok")) |  |  |  | Short warning formula previously~ | =IF(Table_Query_from_Kerry_Live[[#This Row],[OrderQty]]>=Table_Query_from_Kerry_Live[[#This Row],[Current stock ( all status)]],"POSSIBLE SHORTAGE","") |  | =IF(L473=K473,"picked",IF(R473>O473,"Possible Shortage","ok"))
Unplanned orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(L4=K4,"picked",IF((K4-L4)>O4,"Possible Shortage","ok")) | =IF((OR(L485=K485, R485<=O485)),"OK","Possible Shortage")
OrderNumber | OrderSalesNumber | DespatchDateODBC | LoadRef | DelPointName | CreateDateODBC | OrderType | OrderRef | CompleteDeleteFlag | DeliveryPoint
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | AAK Foods Ltd | 2023-05-22 00:00:00 | CUST | AK2300476 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Brakes - Yearsley Logistics | 2023-05-18 00:00:00 | CUST | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Brakes - Yearsley Logistics | 2023-05-18 00:00:00 | CUST | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Food flavor Plant Pepsico | 2023-05-23 00:00:00 | EXPT | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Frito-Lay Trad Co (Eur) [NAME] | 2023-05-15 00:00:00 | EXPT | 44094 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | GLOBAL FOODS LTD | 2023-05-22 00:00:00 | CUST | 152205 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | [NAME] Supply Chain Europe B. | 2023-05-22 00:00:00 | EXPT | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | [NAME] | 2023-05-16 00:00:00 | EXPT | 45339793 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | [NAME] BVBA | 2023-05-11 00:00:00 | EXPT | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Intersnack Poland | 2023-05-22 00:00:00 | EXPT | 293854 |  | [PHONE]
[PHONE] |  | 2023-05-24 00:00:00 |  | Kerry Ingredients & Flavours Ltd. | 2023-05-22 00:00:00 | TRAN |  |  | CC35301
[PHONE] |  | 2023-05-24 00:00:00 |  | KIF Ltd - Olesnica | 2023-05-22 00:00:00 | TRAN |  |  | CC35101
[PHONE] |  | 2023-05-24 00:00:00 |  | KIF Ltd - Olesnica | 2023-05-22 00:00:00 | TRAN |  |  | CC35101
[PHONE] |  | 2023-05-24 00:00:00 |  | KIF Ltd - Olesnica | 2023-05-23 00:00:00 | TRAN |  |  | CC35101
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | [NAME] | 2023-05-16 00:00:00 | EXPT | 428293 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | SLIGRO BS AMSTERDAM | 2023-05-22 00:00:00 | EXPT | 505621 |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Walkers Snack Foods Ltd | 2023-05-23 00:00:00 | CUST | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Walkers Snack Foods Ltd | 2023-05-23 00:00:00 | CUST | [PHONE] |  | [PHONE]
[PHONE] | [PHONE] | 2023-05-24 00:00:00 |  | Walkers Snack Foods Ltd | 2023-05-23 00:00:00 | CUST | [PHONE] |  | [PHONE]
Spreadsheet: 677517d1589382315-count-if-has-value-bring-value-of-a-cell-report
Sheet: Help

 | Start Hour
BUCATARU.MADALINA1 | 07:20-07:30
CEAPA.BIANCA1 | 11:20-11:30
FARCAS.ALINA1 | 10:00-10:10
GROSU.IONUT1 | 0
GROZDEA.MIHAELA1 | 0
IACOB.GEORGIANA1 | 10:50-11:00
LUCA.MANUEL1 | 08:20-08:30
LUNGU.IULIAN1 | 08:40-08:50
[NAME] | 09:20-09:30
MOIZE.ROBERT1 | 10:20-10:30
OPREA.ANDREEA1 | 10:00-10:10
PUSCUTA.BOGDANN1 | 08:50-09:00
SANDU.ADRIAN1 | 09:10-09:20
[NAME] | 09:50-10:00
Spreadsheet: 757864d1638474544-countifs-not-equal-multiple-values-in-same-column-countifs-not-equal-multiple-values-in-same-column
Sheet: Sheet1

Code | ID | Product Type | Unit Type | Date |  |  | 2021-03-01 00:00:00
MATH | S-02 | REG | 35' | 2021-03-31 00:00:00 |  |  | 6 | <-- | =SUM(COUNTIFS(tblData[Date],">="&$H$1,tblData[Date],"<="&EOMONTH($H$1,0), tblData[Product Type], {"SPEC","MODEL"}))
MATH | S-09 | MODEL | 35' | 2021-03-31 00:00:00 |  | 2STRYTH | 5
MATH | S-10 | STD | 42' | 2021-03-31 00:00:00 |  | 35' | 3
MATH | S-11 | SPEC | 42' | 2021-03-31 00:00:00 |  | 42' | 1
MATH | S-22 |  | 35' | 2021-03-31 00:00:00 |  | Total | 15 | <-- | =COUNTIFS(tblData[Date],">="&$H$1,tblData[Date],"<="&EOMONTH($H$1,0))
MATH | S-23 | UNQ | 35' | 2021-03-31 00:00:00
ENG | T28-19 | MODEL | 2STRYTH | 2021-03-31 00:00:00
ENG | T28-21 | REG | 2STRYTH | 2021-03-31 00:00:00 |  |  | Desired Result via formula
ENG | T28-22 | SPEC | 2STRYTH | 2021-03-31 00:00:00
ENG | T28-23 | REG | 2STRYTH | 2021-03-31 00:00:00
ENG | T29-24 | MODEL | 2STRYTH | 2021-03-31 00:00:00
ENG | T29-25 | REG | 2STRYTH | 2021-03-31 00:00:00 |  | Orange colored border (G2:G6) is a dynamic formula
ENG | T29-26 | SPEC | 2STRYTH | 2021-03-30 00:00:00
ENG | T29-27 | REG | 2STRYTH | 2021-03-30 00:00:00 |  | Note that DFH is determined by 'Product Type' = MODEL or SPEC
ENG | T29-28 | SRT | 2STRYTH | 2021-03-31 00:00:00
 |  |  |  |  |  |  | 15
 |  |  |  |  |  | 2STRYTH | 5
 |  |  |  |  |  | 35' | 3
 |  |  |  |  |  | 42' | 1
 |  |  |  |  |  | Total | 15
Spreadsheet: 858094d1706866186-formula-for-weekly-from-daily-test
Sheet: Weekly

 | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7
 | 2024-01-05 00:00:00
Opening Balance
Receipts
Payments
Closing Balance
Spreadsheet: 775407d1649086488-matching-information-on-two-sheets-formula-test-aligw
Sheet: Sheet1

Size | Cost | Margin | Profit | SP | Courier | Total Ex. | Total Incl. | Rounded
Small | 1220 | 1 | 1220 | 2440 | 400 | 2840 | 3266 | 3500
Medium | 1420 | 1 | 1420 | 2840 | 400 | 3240 | 3726 | 3800
Large | 1496 | 1 | 1496 | 2992 | 400 | 3392 | 3900.8 | 3950
X-Large | 1622 | 1 | 1622 | 3244 | 400 | 3644 | 4190.6 | 4200
XX-Large | 1815 | 0.9 | 1633.5 | 3448.5 | 400 | 3848.5 | 4425.775 | 4450
[NAME] | 1815 | 1 | 1815 | 3630 | 400 | 4030 | 4634.5 | 4650
Spreadsheet: phillip_m_love__30668__200003_OA
Sheet: BGC-EGM-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 | 0 | 0
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 0 | 0
 | Purchases:
6 |  | 3rd Party / Inter Enron | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
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
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
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 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 163eb075-38a7-49e3-8279-47c8e9c86efa
Sheet: Sheet1

WPU Value Fiscal Years 1976-2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | WPU | Dollar | Percent
Year | Value | Change | Change
1975-76 | 621 | 0 | 0
1976-77 | 683 | 62 | 0.0998389694041868
1977-78 | 732 | 49 | 0.07174231332357248
1978-79 | 795 | 63 | 0.0860655737704918
1979-80 | 852 | 57 | 0.07169811320754717
1980-81 | 946 | 94 | 0.1103286384976526
1981-82 | 1003 | 57 | 0.06025369978858351
1982-83 | 1103 | 100 | 0.09970089730807577
1983-84 | 1103 | 0 | 0
1984-85 | 1124 | 21 | 0.01903898458748867
1985-86 | 1180 | 56 | 0.0498220640569395
1986-87 | 1204 | 24 | 0.02033898305084746
1987-88 | 1204 | 0 | 0
1988-89 | 1204 | 0 | 0
1989-90 | 1240 | 36 | 0.02990033222591362
1990-91 | 1346 | 106 | 0.08548387096774193
1991-92 | 1408 | 62 | 0.04606240713224369
1992-93 | 1490 | 82 | 0.05823863636363636
1993-94 | 1539 | 49 | 0.03288590604026845
1994-95 | 1608 | 69 | 0.04483430799220273
1995-96 | 1672 | 64 | 0.03980099502487562
1996-97 | 1739 | 67 | 0.04007177033492823
1997-98 | 1791 | 52 | 0.02990224266820012
1998-99 | 1854 | 63 | 0.03517587939698492
1999-00 | 1901 | 47 | 0.02535059331175836
2000-01 | 2006 | 105 | 0.05523408732246186
2001-02 | 2116 | 110 | 0.05483549351944168
2002-03 | 2132 | 16 | 0.007561436672967864
2003-04 | 2150 | 18 | 0.008442776735459663
2004-05 | 2182 | 32 | 0.01488372093023256
2005-06 | 2280 | 98 | 0.04491292392300641
2006-07 | 2417 | 137 | 0.06008771929824561
Average increase from 1977 to 2006 |  |  | 0.0452
10 Year Increase from 1998 top 2007 |  |  | 0.3495
10 Year Average increase from 1998 to 2007 |  |  | 0.0336
Spreadsheet: 703742d1605147224-conditional-formatting-to-highlight-a-cell-red-when-checkbox-is-unchecked-spreadsheet-111120
Sheet: Sheet1

Priority 1 Equipment | Issue | Action Taken | Service State | In Service at Reduced Capacity
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh |  |  | False | True
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False |  | If [NAME]:
 |  |  | False |  | * E2: red
 |  |  | False |  | * Column D: red (unchecked), green (checked)
 |  |  | False |  | If [NAME]:
 |  |  | False |  | * E2: yellow
 |  |  | False |  | * Column D: no colour ( regardless checked or unchecked)
 |  |  | False |  | If yes,
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
 |  |  | False
Spreadsheet: 677733d1589488233-sum-totals-based-on-date-sample-bi-weekly-budget
Sheet: Dashboard

 | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
Income 1-15
Income 16-EOM
Expenditures 1-15
Expenditures 16-EOM
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Physician Asst-101

Physician Assistant: | 101
Job Title | Count |  | Employed Type | Count
CCMA | 1 |  | Independent - Retail | 1
Certified Surgical Assistant | 1 |  | Chain - Retail | 0
CMA | 1 |  | Hospital | 0
COA | 2 |  | Consultant | 0
CPhT | 6 |  | Institutional - Other | 0
CSA | 1 |  | Retired | 0
CST-FA | 1 |  | Unemployed | 0
CW2 | 1
etc | 1
m.b.b.s | 1
Medical assistant | 1
MHSA, PA-C | 1
MPAS PA-C | 1
ms | 2
N/A | 1
ogfrjro | 1
PA | 15
PA-C | 35
pac | 1
ph | 1
PHARM TECH | 1
Pharmacy Tech | 2
PhD | 1
Physican assistant | 1
physician assistant | 1
R.PA-C | 1
R.Ph | 2
RMA | 1
RN | 1
RN, PA-C | 1
RPA | 2
RPA-C | 3
RPH | 1
RPh, PA-C | 1
Rph., PA-C | 1
sophos | 1
store manager | 1
Student | 2
[NAME] | 1
technician | 1
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 156611 | 1023306 | 630256 | 4978889 | 6789062
FRA | 13509666 | 3061756 | 17019 | 12701359 | 29289800
IRS- [NAME] | 47525480 | 8411954 | 14575087 | 32873203 | 103385724
OIS | 11947674 | 3559090 |  | 3653251 | 19160015
VNS | 1984 | <1,000 |  | <1,000 | 1984
Zero Coupon | 95740 | 35591 | 34039 | 52698 | 218068
TOTAL | 73237154 | 16091698 | 15256401 | 54259400 | 158844654
Estimated gross notional amount outstanding, January 4 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 680215d1590858422-conditional-formatting-using-multiple-sheets-and-search-function-in-multiple-rows-and-column-2020-05-30-unlimited007-cf-680204d1590855331-conditional-formatting-using-multiple-sheets-and-
Sheet: Operators

Operator | Misc | Misc | Misc | License | Misc | Misc | Misc | Misc | A1 | A2 | A3 | A4 | B1 | B2 | B3 | B4
Alfons |  |  |  | A4
[NAME] |  |  |  | B4
[NAME] |  |  |  | B1
Raul |  |  |  | A4
[NAME] |  |  |  | B2
Blake |  |  |  | A1
Martin |  |  |  | B4
Spreadsheet: 886803d1736925830-list-and-sort-top-10-locations-in-a-descending-order-based-on-distance-test-sheet
Sheet: test

[NAME] | DISTANCE |  |  |  | 2500
HH | 3 |  |  |  | SUGGESTED LOCATION | DISTANCE
CC | 150 |  |  | 1 | BB | 2500
KK | 1337 |  |  | 2 | LL | 2119
AA | 1500 |  |  | 3 | FF | 1800
FF | 1800 |  |  | 4 | AA | 1500
LL | 2119 |  |  | 5 | KK | 1337
BB | 2500 |  |  | 6 | CC | 150
EE | 2900 |  |  | 7 | HH | 3
GG | 3500 |  |  | 8
JJ | 4500 |  |  | 9
II | 5900 |  |  | 10
DD | 7800
Spreadsheet: 104667d1302184020-applying-a-percentage-to-the-answer-after-adding-the-percentage-sample
Sheet: Full FC area Figs

Median Income decile 3 | 15621
Mortgage Multiplier | 2.87
Mortgage Borrowing Capacity | 44832.27 | A
Required Deposit % | 0.23
Required Deposit £ | 12683.049183 | B
Maximum Affordable House Price | 58500 | C | Both B8 and B10 should be the same
 |  |  | i.e. B5+B7
Combined Mortgage + Deposit | 57515.31918300001 | C | the problem is getting a formula for B7
 |  |  | and [NAME] needs to be 23% of C
 | A+B should equal C