tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: TX-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 | 53372064 | 99510884.61
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 514697 | 984713.35
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 53886761 | 100495597.96
 | Purchases:
6 |  | 3rd Party / Inter Enron | -53004340 | -98347722.46
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2711686 | -5239910.5
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -55716026 | -103587632.96
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 33282477 | 70150974.94000001
12 |  | Purchases | -33509812 | -70573818.04
 | Total Intra CTS Sales / Purchases |  | -227335 | -422843.099999994
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | -497811 | -904662.3978783083
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -497811 | -904662.3978783083
 | Storage:
17 |  | Injection (Sales to Stg) | 4532382 | 7102748
18 |  | W/D (Purchase from Stg) | -1977971 | -3080609
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -1977971 | -3080609
 | Total Storage: |  | 2554411 | 4022139
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | -25000
 | Transport Expense:
24 |  | Commodity | 0 | -904705
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -904705
 | 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 | 1054678.81
31 |  | Prior Month Book Balance | 0 | -468909
 |  | Total MTM Income | 0 | 585769.81
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1279584
34 |  | Originations | 0 | 118667
35 |  | Broker Fees | 0 | -14678
36 |  | Asset Group Demand Charges | 0 | -10000
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 269286
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | 114066
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | -113464
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 82868d1282866514-grouping-results-using-multisheet-consolidation-testing2-2
Sheet: GlobalSummary

 | Country | State | Probability | Value | Month
 | Hungary |  | 0.9 | 10 | June
 | Sweden |  | 0.1 | 15 | June
 | France |  | 0.2 | 100 | May
 | Germany |  | 0.3 | 25 | August
 | England |  | 0.6 | 55 | April |  |  |  |  | Choose Month | All
 | USA | New York | 0.9 | 10 | June
 | USA | Florida | 0.1 | 15 | June |  |  |  |  | Choose probability
 | USA | Missouri | 0.2 | 100 | May
 | USA | Texas | 0.3 | 25 | August
 | USA | California | 0.6 | 55 | April
 | Abu Dhabi |  | 0.9 | 10 | June
 | Jordan |  | 0.1 | 15 | July
 | Oman |  | 0.2 | 100 | June
 | Dhubi |  | 0.3 | 25 | June
 | TOTAL VALUE |  |  | 560
Spreadsheet: 751852d1634378991-extract-number-of-days-present-from-the-attendance-report-test
Sheet: Sheet2

Date |  | In Time - Out Time
10100 KKKK SSSSS
2021-09-01 00:00:00 |  | 02:04 PM - -
2021-09-02 00:00:00 |  | 02:09 PM - 06:38 PM
2021-09-03 00:00:00 |  | 02:17 PM - -
2021-09-04 00:00:00 |  | 02:04 PM - -
2021-09-05 00:00:00 |  | -
2021-09-06 00:00:00 |  | -
2021-09-07 00:00:00 |  | 02:00 PM - 05:42 PM
2021-09-08 00:00:00 |  | 02:00 PM - 05:57 PM
2021-09-09 00:00:00 |  | 02:01 PM - 05:51 PM
2021-09-10 00:00:00 |  | -
2021-09-11 00:00:00 |  | -
2021-09-12 00:00:00 |  | -
2021-09-13 00:00:00 |  | 02:08 PM - 05:51 PM
2021-09-14 00:00:00 |  | 02:05 PM - 05:50 PM
2021-09-15 00:00:00 |  | 02:23 PM - 06:01 PM
2021-09-16 00:00:00 |  | 02:05 PM - 05:41 PM
2021-09-17 00:00:00 |  | 02:04 PM - -
2021-09-18 00:00:00 |  | -
2021-09-19 00:00:00 |  | -
2021-09-20 00:00:00 |  | 02:05 PM - -
2021-09-21 00:00:00 |  | 02:08 PM - 05:44 PM
2021-09-22 00:00:00 |  | 02:15 PM - 05:58 PM
2021-09-23 00:00:00 |  | 02:09 PM - 06:05 PM
2021-09-24 00:00:00 |  | 02:09 PM - 05:51 PM
2021-09-25 00:00:00 |  | 02:13 PM - 06:12 PM
2021-09-26 00:00:00 |  | 10:49 AM - 01:18 PM
2021-09-27 00:00:00 |  | -
2021-09-28 00:00:00 |  | 02:08 PM - 05:51 PM
2021-09-29 00:00:00 |  | 02:16 PM - 05:47 PM
2021-09-30 00:00:00 |  | 02:05 PM - 06:08 PM
10156 XXXX YYYYY
2021-09-01 00:00:00 |  | 07:24 AM - 01:38 PM
2021-09-02 00:00:00 |  | 07:23 AM - 01:32 PM
2021-09-03 00:00:00 |  | 07:14 AM - 03:48 PM
2021-09-04 00:00:00 |  | 07:24 AM - 01:30 PM
2021-09-05 00:00:00 |  | -
2021-09-06 00:00:00 |  | 07:16 AM - 01:38 PM
2021-09-07 00:00:00 |  | 07:29 AM - 03:37 PM
2021-09-08 00:00:00 |  | 07:20 AM - 01:33 PM
2021-09-09 00:00:00 |  | 07:13 AM - 01:31 PM
2021-09-10 00:00:00 |  | 07:13 AM - 01:29 PM
2021-09-11 00:00:00 |  | 07:15 AM - 01:40 PM
2021-09-12 00:00:00 |  | -
2021-09-13 00:00:00 |  | 07:16 AM - 01:39 PM
2021-09-14 00:00:00 |  | 07:12 AM - 01:33 PM
2021-09-15 00:00:00 |  | 07:15 AM - 01:34 PM
2021-09-16 00:00:00 |  | 07:19 AM - 01:37 PM
2021-09-17 00:00:00 |  | 07:13 AM - 01:34 PM
2021-09-18 00:00:00 |  | 07:16 AM - 01:40 PM
2021-09-19 00:00:00 |  | -
2021-09-20 00:00:00 |  | 07:25 AM - 01:34 PM
2021-09-21 00:00:00 |  | 07:27 AM - 03:17 PM
2021-09-22 00:00:00 |  | 07:20 AM - 01:30 PM
2021-09-23 00:00:00 |  | 07:24 AM - 01:43 PM
2021-09-24 00:00:00 |  | 08:17 AM - 01:33 PM
2021-09-25 00:00:00 |  | 07:21 AM - 01:49 PM
2021-09-26 00:00:00 |  | -
2021-09-27 00:00:00 |  | 07:32 AM - 01:39 PM
2021-09-28 00:00:00 |  | 07:23 AM - 01:35 PM
2021-09-29 00:00:00 |  | 07:31 AM - 01:24 PM
2021-09-30 00:00:00 |  | 07:28 AM - 01:35 PM
Spreadsheet: 114524d1310235219-list-multiple-values-in-same-cell-book1_katrinae
Sheet: Sheet1

Question | Category | Question Rank  in Category
1 | Finding Density
2 | Finding Volume
3 | Finding Density
4 | Finding Volume
5 | Finding Mass
6 | Finding Mass
7 | Finding Density
8 | Finding Mass
9 | Finding Volume
10 | Finding Density
Spreadsheet: chris_germany__1979__ENA-Reliant Prepay
Sheet: May 2002 FGT

ENA Purchases from Reliant - May 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  |  | [NAME]  [EMAIL]
City of Tallahassee |  |  | Pam McCullers [PHONE], cell [PHONE]
[NAME] |  |  | [NAME][PHONE]  [EMAIL]
[NAME] |  |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  |  | [NAME]  [PHONE]  [EMAIL]
Reliant Settlements |  |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Scheduled | Location | Price [NAME] | GD Post | Price | Total |  | Prepayments | Trunkline Sales | Balance
 |  |  |  |  |  |  |  |  |  | Balance from April 2002 | To Reliant
Wed | 2002-05-01 00:00:00 | 0 | 0 |  | [NAME] | 3.67 |  |  |  | 0
Thu |  | 0 | 0 | [NAME] | [NAME] | 3.785 |  |  |  | 0
Fri |  | 1196 | 2000 | [NAME] | [NAME] | 3.665 |  |  |  | 0
Sat |  | 1479 | 2000 | Z3 | [NAME] | 3.73 |  |  |  | 0
Sun |  | 0 | 2000 | Z3 | [NAME] | 3.73 |  |  |  | 10000
Mon |  | 0 | 2000 | Z3 | [NAME] | 3.73 |  |  |  | 0
Tue |  | 0 | 0 |  | [NAME] | 3.605 |  |  |  | 0
Wed |  | 692 | 2000 | [NAME] | [NAME] | 3.51 |  |  |  | 0
Thu |  | 0 | 0 | [NAME] | [NAME] | 3.78 |  |  |  | 0
Fri |  | 0 | 2000 | [NAME] | [NAME] | 3.745 |  |  |  | 0
Sat |  | 0 | 2000 | [NAME] | [NAME] | 3.735 |  |  |  | 0
Sun |  | 0 | 2000 | [NAME] | [NAME] | 3.735 |  |  |  | 0
Mon |  | 0 | 2000 | [NAME] | [NAME] | 3.735 |  |  |  | 0
Tue |  | 0 | 2000 | [NAME] | [NAME] | 3.625 |  |  |  | 0
Wed |  | 0 | 2000 | [NAME] | [NAME] | 3.755 |  |  |  | 0
Thu |  | 0 | 2000 | [NAME] | [NAME] | 3.63 |  |  |  | 0
Fri |  | 2000 | 2000 | [NAME] | [NAME] | 3.455 |  |  |  | 0
Sat |  | 0 | 0 |  | [NAME] | 3.435 |  |  |  | 0
Sun |  | 0 | 0 |  | [NAME] | 3.435 |  |  |  | 0
Mon |  | 0 | 0 |  | [NAME] | 3.435 |  |  |  | 0
Tue |  | 0 | 0 |  | [NAME] | 3.45 |  |  |  | 0
Wed |  | 0 | 0 |  | [NAME] | 3.35 |  |  |  | 0
Thu |  | 0 | 0 |  | [NAME] | 3.38 |  |  |  | 0
Fri |  | 0 | 0 |  | [NAME] | 0 |  |  |  | 0
Sat |  | 0 | 0 |  | [NAME]* | 0 |  |  |  | 0
Sun |  | 0 | 0 |  | [NAME]* | 0 |  |  |  | 0
Mon |  | 0 | 0 |  | [NAME]* | 0 |  |  |  | 0
Tue |  | 0 | 0 |  | [NAME]* | 0 |  |  |  | 0
Wed |  |  |  |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  |  | [NAME]* | 0 |  |  |  | 0
 |  |  |  |  | Sitara deal #1207304
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 774067d1648201164-apply-formula-over-existing-columns-and-rows-without-changing-some-values-book1
Sheet: Sheet1

Data |  |  |  |  | Desired Results
Emp ID | Value 1 | Value 2 |  |  | Emp ID | Value 1 | Value 2
1 AAX | 1 | 5 |  |  | 1 AAX | 2 | 10
1 AAZ | 2 | 6 |  |  | 1 AAZ | 4 | 12
2 AHH | 3 | 7 |  |  | 2 AHH | 3 | 7
2 AAH | 4 | 8 |  |  | 2 AAH | 4 | 8
Spreadsheet: 111935d1308163309-average-time-am-pm-when-various-criteria-are-met-sample
Sheet: WEEK 1

CALL LOG: WEEK OF
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7018 | h | 175 | 5:42:54 | 08:11:00 | 16:57:00 | 193 | 4:38:15 | 08:19:00 | 17:00:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00
7008 | d | 288 | 4:12:13 | 07:55:00 | 16:49:00 |  |  |  |  | 310 | 5:50:06 | 08:01:00 | 18:49:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 393 | 5:19:10 | 08:09:00 | 18:42:00
7032 | f | 234 | 4:16:13 | 10:09:00 | 18:53:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00 | 185 | 2:54:00 | 08:13:00 | 16:58:00 | 229 | 3:21:47 | 08:32:00 | 16:55:00 | 204 | 3:06:27 | 08:21:00 | 16:56:00
7023 | b | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 280 | 2:43:57 | 08:02:00 | 16:01:00 | 233 | 2:20:18 | 09:44:00 | 16:47:00 | 248 | 2:13:02 | 07:35:00 | 16:42:00 | 206 | 2:36:50 | 09:51:00 | 18:38:00
7014 | c | 238 | 4:43:29 | 07:58:00 | 16:51:00 | 237 | 3:42:17 | 07:42:00 | 16:49:00 | 339 | 2:40:37 | 08:02:00 | 17:14:00 | 182 | 2:23:23 | 14:11:00 | 18:52:00 | 117 | 1:00:01 | 16:04:00 | 18:53:00
7011 | e | 187 | 3:11:07 | 08:46:00 | 16:54:00 | 129 | 1:48:31 | 12:40:00 | 17:12:00 | 157 | 1:55:52 | 09:00:00 | 16:50:00 | 290 | 4:10:17 | 08:59:00 | 16:49:00 | 241 | 2:56:56 | 09:12:00 | 17:04:00
7016 | g |  |  |  |  | 288 | 4:12:13 | 07:55:00 | 16:49:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 186 | 4:45:41 | 08:31:00 | 18:40:00 | 288 | 4:12:13 | 07:55:00 | 16:49:00
7013 | j | 152 | 4:32:26 | 08:21:00 | 16:22:00 | 105 | 3:45:16 | 08:05:00 | 16:49:00 | 151 | 2:40:58 | 08:18:00 | 16:53:00 | 131 | 2:28:15 | 08:09:00 | 16:41:00 | 281 | 4:22:22 | 08:07:00 | 16:58:00
7015 | i |  |  |  |  |  |  |  |  | 219 | 2:54:29 | 07:53:00 | 16:58:00 | 288 | 4:12:13 | 07:55:00 | 16:49:00 | 175 | 5:42:54 | 08:11:00 | 16:57:00
7012 | a | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 157 | 1:55:52 | 09:00:00 | 16:50:00 |  |  |  |  | 288 | 4:12:13 | 07:55:00 | 16:49:00
COURT TOTALS
COURT AVERAGE
7010 | x | 361 | 5:29:16 | 08:07:00 | 18:52:00 | 393 | 5:19:10 | 08:09:00 | 18:42:00 | 338 | 4:37:59 | 08:03:00 | 18:45:00 | 282 | 4:00:05 | 08:17:00 | 18:43:00
7019 | z | 147 | 1:58:55 | 08:14:00 | 17:37:00 | 148 | 2:43:42 | 08:27:00 | 17:05:00 | 393 | 5:19:10 | 08:09:00 | 18:42:00 | 220 | 2:57:21 | 08:11:00 | 17:54:00 | 393 | 5:19:10 | 08:09:00 | 18:42:00
7022 | y | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 178 | 2:50:43 | 08:11:00 | 16:49:00 | 183 | 3:11:47 | 08:19:00 | 16:55:00 | 213 | 4:35:27 | 08:18:00 | 18:50:00 | 244 | 3:08:18 | 08:09:00 | 16:57:00
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 690722d1597252567-conditional-formatting-across-sheets-roster-test-3-
Sheet: Day

 | Today
E
L |  | names | names | names
Skills
Data | names | names | names
Excel | names | names | names
Staffing | Names | Names | Names
Spreadsheet: jim_schwieger__14492__Inv_WC_true_up
Sheet: Inv & WC Value Adj

Inventory and Working Capital Calculation Statement Reconciliation
as provided in
Purchase and Sale Agreement
between
Enron Corp. "Seller"
and
AEP Energy Services Gas Holding Company "Buyer"
dated as of December 27, 2000
[NAME] (b) (e) and 2.5 (b), (e) |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted
 |  |  |  |  |  |  | Enron Amounts |  |  | AEP Amounts |  | Difference |  | Difference
 |  |  | MMBtu |  | Rate |  | Value
Working Gas
 | Invoiced by Enron |  | 25924188 | (1) | 3.86
 | Actual |  | 25243641 | (2) | 3.26 | (3)
Working Gas Adjustment Due Buyer |  |  |  |  |  |  |  |  |  | 17773096.02
Add(Deduct):
 | Texas General Land Office |  | See attached Schedule I
 | Cannon |  | See attached Schedule I
 | Lyondell Citgo Adjustment |  | See attached [NAME] |  |  |  |  | -17000000
 | Centana Gas Payment |  | See attached [NAME] |  |  |  |  | See Note
 | Centana Ad Valorem Tax Proration |  | See attached [NAME] |  |  |  |  |  |  |  |  |  |  |  | ENE agreed to pay thru 7/31
 | Centana July Reimbursement |  | See attached [NAME] |  |  |  | 0 |  |  | 95130 |  |  |  | 0 | ENE paid July invoice
 | Gas Lift Deposits |  |  |  |  |  | 25000 |  |  | 25225 |  |  |  | -22
 | [NAME] |  |  |  |  |  | 91000 |  |  | 91000
 | SAP to PeopleSoft Conversion |  |  |  |  |  |  |  |  | -43001.25
Adjusted Working Gas Payment
 | Interest Payment (4) |  |  |  |  |  |  |  |  | 486415.08
Adjusted Payment
Additional Invoices
 | D.L. Peterson Trust |  |  |  |  |  | 0 |  |  | 22152
 | Gregg Engineering Services Ltd. |  |  |  |  |  | -107635 |  |  | -60000
Total
 | (1) Estimated [NAME] volume as of 05/31/01
 | (2) Actual [NAME] volume as of 05/31/01
 | (3) Published Price in Inside FERC (HSC) for the month of July 2001
 | (4) Interest Payment calculated based on an assumed pay date of 10/31/01 for Daily Prime for 153 days (Enron calulcate on "Additional
 | Payment" and AEP calculated on "Workking Gas Adjustment"
Spreadsheet: 217717d1362158479-trying-to-count-from-the-bottom-of-a-column-to-a-certain-number-approach
Sheet: Sheet1

 | Total Time | Approach | Hold
2013-01-13 00:00:00 | 1.5 | 3
2013-01-14 00:00:00 | 1.4 | 2
2013-01-16 00:00:00 | 1.8 | 1
2013-01-18 00:00:00 | 1.9 | 4 | 1
2013-01-19 00:00:00 | 1.8 | 3
2013-01-21 00:00:00 | 0.9 | 1
2013-01-25 00:00:00 | 1.5 | 3
Spreadsheet: 29b39392-64a7-48e0-b574-affa30e128db
Sheet: Sheet1

Program Fee | 0
(Check program's website to determine what is included in this fee)
Items NOT included in the above Program Fee
Categories | Amount
Administrative Costs
Education Abroad at UK Application fee ($50)
Education Abroad at UK Administrative fee ($100)
ISP 599 (1 credit hour of UK tuition)
(For UK tuition and fees visit http://www.uky.edu/Registrar/feesgen.htm )
Travel Documents, Health Insurance and Immunizations
Travel Medical Insurance (purchased through UK at $10/week)
Passport
Visa
Immunizations
Transportation
Airfare
Local transportation
(in country train, bus, subway, taxi, travel to and from program site)
Housing and Meals
Lodging (if NOT included in the Program fee)
Meals (if NOT included in the Program fee)
Housing and Meals during breaks (semester or year abroad, if applicable)
Books & Other Educational Supplies
Books
Other course supplies (if NOT included in the Program fee)
Essential Daily Living Expenses
Communication (phone, phone card, internet access)
Toiletries and laundry
Emergency cash
Other Expenses (explain)
Total Cost of Non-Included Expenses
Total Program Fee & Non-Included Expenses
List of Resources You Plan to Use
to Finance Your Education Abroad Program
(do NOT include EA at UK Scholarship)
Resource | Estimated Amount | Notes
Family Funds
Work
Scholarships
Personal Savings
Financial Aid
Student Loans (Federal Financial Aid)
Personal Loans (non-federal aid loans)
Other
Total Resources for EA Program
Remaining Total to Finance Your Education Abroad Program
(Total Program Fee & Non-Included Expenses
Minus Total Resources)
Spreadsheet: 73942d1274477363-trying-to-set-a-floor-and-a-ceiling-for-value-calculation-but-failing-increase-example
Sheet: Sheet1

EMPLOYEE | [NAME]
CURRENT POSITION | PRESIDENT & CEO
GRADE | 13
[NAME] | 50000
CY PERFORMANCE | 3.4
PY PERFORMANCE | 4.8
PREVIOUS INCREASE YEAR | 2009-09-01 00:00:00
PROPOSED POSITION | MANAGER
GRADE: | 15
MIN | 60000
MID | 102400
MAX | 125200
INCREASE CONSIDERATION | RECOMMENDED INCREASE AMOUNT
GRADE INCREASE %
TOTAL RECOMMENDED INCREASE
RECOMMENDED SALARY
Spreadsheet: 822811d1679547837-formula-to-automatically-calculate-a-value-in-decimal-format-from-a-range-book1
Sheet: Sheet1

Look Up Value |  |  | Value | Range
99.25 |  |  | 100 | 50
 |  |  | 99 | 49
Return Value |  |  | 98 | 48
 |  |  | 97 | 47
 |  |  | 96 | 46
 |  |  | 95 | 45
 |  |  | 94 | 44
 |  |  | 93 | 43
 |  |  | 92 | 42
 |  |  | 91 | 41
 |  |  | 90 | 40
Spreadsheet: 737765d1624591697-embedded-if-and-or-book3
Sheet: Components Inventory

A | B | C | D | Status
No | No | Yes | Machine
No | No | No | N/A
No | No | No | N/A
Yes | Yes | Yes | N/A
Yes | Yes | Yes | N/A
Yes | Yes | Yes | N/A
Spreadsheet: 114494d1310205181-excel-2007-dependent-chart-series-783520
Sheet: Graphs

 | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8
Criteria 1 | 13284270.31090034 | 32205820.35 | 20999847.39247475 | 28907592.22 | 19604460.86 | 24459471.76 | 23428670.8 | 31626002.62 |  | Criteria 1 to 5 use £ values
[NAME] | 1160691.606785902 | 3542037.14 | 2629282.08 | 2005878.268041 | 2134413.43 | 3360642 | 2966673.36 | 2772096.6995
Criteria 3 | 319680.33 | 1416387 | 2111272 | 1843925.326865 | 2671591.939999999 | 240166.48 | 1383935.387489178 | 3318255.22
[NAME] | 14764642.24768624 | 37164244.49 | 25740401.47247475 | 32757395.814906 | 24410466.23 | 28060280.24 | 27779279.54748918 | 37716354.5395
Criteria 5 | 311.3585991234215 | 309.6296686023035 | 296.2607027421914 | 260.3460109255365 | 285.8964220037654 | 231.7403141162839 | 280.1572461288156 | 278.1934773636416
Criteria 6 | 13 | 40 | 23 | 33 | 32 | 30 | 43 | 40 |  | Criteria 6 to 21 use numeric values
Criteria 7 | 14 | 28 | 26 | 50 | 46 | 30 | 52 | 31
Criteria 8 | 3 | 7 | 3 | 24 | 5 | 7 | 8 | 16
Criteria 9 | 5 | 8 | 9 | 3 | 14 | 6 | 6 | 12
Criteria 10 | 2 | 8 | 3 | 4 | 4 | 4 | 5 | 5
Criteria 11 | 1 | 13 | 2 | 0 | 0 | 6 | 14 | 3
Criteria 12 | 0 | 3 | 4 | 3 | 4 | 2 | 0 | 6
Criteria 13 | 3 | 16 | 4 | 4 | 19 | 4 | 3 | 16
Criteria 14 | 4 | 1 | 1 | 1 | 4 | 12 | 0 | 0
Criteria 15 | 2 | 0 | 6 | 1 | 5 | 6 | 3 | 12
Criteria 16 | 1 | 16 | 3 | 13 | 4 | 8 | 1 | 8
Criteria 17 | 0 | 9 | 5 | 4 | 10 | 13 | 18 | 49
Criteria 18 | 9 | 5 | 0 | 2 | 0 | 0 | 7 | 1
Criteria 19 | 5 | 8 | 21 | 82 | 26 | 29 | 19 | 21
Criteria 20 | 1 | 2 | 0 | 0 | 1 | 3 | 0 | 4
Criteria 21 | 0 | 1 | 0 | 2 | 3 | 11 | 8 | 1
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  | The problem is that if I format the Y axis to display £ values, when criteria 6 to 21 are displayed,
 |  |  |  |  |  | these are also diosplayed using £ rather than numeric values.
 |  |  |  |  |  | I am looking for a way to dynamically change the Y axis values displayed to reflect the source data
 |  |  |  |  |  | so that £ values will automatically be displayed for criteria 1 to 5 and numeric values
 |  |  |  |  |  | will be dispalyed for criteria 6 to 21, instead of all criteria displaying £ values.
Spreadsheet: 483017d1475428504-using-excel-to-write-wiring-connection-plan-sorting-wire-connection-gk-v3
Sheet: TABLE OF CONNECTIONS

 | Cable | Apparatus | Terminal | Terminal BLOCK | Terminal CONNECTION | Aparatus | Termianl | Cable
 |  |  |  | X220 | 1 | K7 | 11 | Cable : H07-black | 2.5
 |  |  |  | X220 | 2 | K11 | 21 | Cable : H07-black | 1.5
 |  |  |  | X220 | 5
 |  |  |  | X220 | 10 | S1 | 1 | Cable : H07-black | 1.5
 |  |  |  | X220 | 13 | S1 | 2 | Cable : H07-black | 1.5
 |  |  |  | X220 | 21 | X2 | 53 | Cable : H07-black | 1.5
 |  |  |  | X220 | 22 | X2 | 66 | Cable : H07-black | 1.5
 |  |  |  | X220 | 23
1.5 | Cable : H07-black | K4 | 59 | X220 | 24
 |  |  |  | X220 | 25
 |  |  |  | X220 | 26 | K7 | 12 | Cable : H07-black | 2.5
 |  |  |  | X300 | 1 | X50 | 11 | Cable : H07-black | 1.5
 |  |  |  | X300 | 2 | X50 | 12 | Cable : H07-black | 1.5
 |  |  |  | X300 | 3 | X50 | 21 | Cable : H07-black | 1.5
 |  |  |  | X300 | 4 | X50 | 22 | Cable : H07-black | 1.5
 |  |  |  | X300 | 5 | X51 | 11 | Cable : H07-black | 2.5
 |  |  |  | X300 | 6 | X51 | 12 | Cable : H07-black | 2.5
 |  |  |  | X300 | 67 | X51 | 21 | Cable : H07-black | 2.5
 |  |  |  | X300 | 68 | X51 | 22 | Cable : H07-black | 2.5
 |  |  |  | X500 | 150 | S102 | 1 | Elka wire red | 2.5
 |  |  |  | X500 | 151 | S102 | 2 | Elka wire black | 1.5
Spreadsheet: 777131d1650188898-problem-with-paste-value-of-not-counting-as-blank-cell-paste-value-blank-cell
Sheet: Sheet1

 |  |  |  |  |  |  |  | PASTE VALUE FROM
 |  |  |  | formula | COLUMN F |  |  | COLUMN F
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | =""
 |  |  |  | COUNTA |  |  | COUNTA
 |  |  |  |  |  |  |  | OUTCOME SHOULD BE ZERO "0"
Spreadsheet: 2dbca647-ee2a-4f38-bcf8-d237365a5031
Sheet: Liste de remises

 | COL_GRP | COL_NCPE | COL_NOM | COL_NAS | COL_CTRB_EMPL | COL_CTRB_EMPL_REV | COL_CTRB_EMPLR | COL_AUTRE_CTRB |  | COL_CODE_ABS
LN_NO_GROUPE |  |  | No. de l'employeur
 |  |  | [NAME]
LN_MOIS_REMISE |  |  |  |  |  |  | Mois de remise | 2013-02 |  |  |  |  |  |  | Description française | Code d'absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | B
 |  | * devant le nom indique que l'individu a une contribution de l'employeur seulement |  |  |  |  |  |  |  |  |  |  |  |  | CSST | C
 | Groupe |  | [NAME] | Référence | Contribution Employé | Contribution corrigée | Contribution Employeur | Autre contribution | Description | Code d'absence |  |  |  |  | Décès | D
LN_DATA_AREA |  |  | EMPLOYÉ 1      son N.A.S. | 111222333 |  |  |  |  |  |  |  |  |  |  | [NAME] | F
 |  |  | EMPLOYÉE 2 | 222111333 |  |  |  |  |  |  |  |  |  |  | Grève | G
 |  |  | EMPLOYÉE 3 | 333222111 |  |  |  |  |  |  |  |  |  |  | Lock out | L
 |  |  | EMPLOYÉ 4 | 222333111 |  |  |  |  |  |  |  |  |  |  | [NAME] | M
 |  |  | EMPLOYÉ 5 | 111333222 |  |  |  |  |  |  |  |  |  |  | Mise à pied (temporaire) | P
 |  |  | EMPLOYÉE 6 | 333111222 |  |  |  |  |  |  |  |  |  |  | Retraité-e | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arrêt permanent demandé par travailleur | S
 |  |  | Entrer les contributions dans cette colonne. |  |  |  |  |  |  |  |  |  |  |  | Arrêt temporaire demandé par travailleur | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacances | V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indéterminé | X
Spreadsheet: 796599d1663395398-sample-data-for-date-and-time-based-on-specific-person-sample-file_time
Sheet: Sheet2

Time | Date | Salesperson |  |  | Salesperson | 2020.08.10 | 2020.08.12 | 2020.08.13 | 2020.08.14 | 2020.08.16 | 2020.08.17
00:38:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  | [NAME] |  | 00:09:59.962000
00:20:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  | [NAME] |  |  |  | 00:22:59.981000
00:18:00 | 2020-08-12 00:00:00 | Nick |  |  | [NAME] | 00:58:00.019000
00:09:59.962000 | 2020-08-12 00:00:00 | [NAME] |  |  | Nick |  | 00:18:00 |  |  |  | 00:56:00.010000
00:33:59.990000 | 2020-08-13 00:00:00 | [NAME] |  |  | [NAME] |  |  |  |  | 00:49:00.019000
00:22:59.981000 | 2020-08-14 00:00:00 | [NAME] |  |  | [NAME] |  |  | 00:33:59.990000
00:49:00.019000 | 2020-08-16 00:00:00 | [NAME]
00:56:00.010000 | 2020-08-17 00:00:00 | Nick