tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873288d1719775663-do-not-count-in-range-average-if-cell-has-no-value-is-empty-blank-example_countif_notblank
Sheet: Sheet1

2024-06-25 00:00:00 |  | -5
2024-06-25 00:01:00 |  | 40.5
2024-06-25 00:02:00 |  | 34.4
2024-06-25 00:03:00 |  | 40.9 |  |  |  | G1 is not correct.
2024-06-25 00:04:00 |  | 28.7 |  |  |  | I1 is correct.
2024-06-25 00:05:00 |  | 19.6 |  |  |  | Value of 0.0 should be counted into the average.  Values of empty should not.
2024-06-25 00:06:00 |  | 39 |  |  |  | Thus, there are 55 valid readings, so sum and divide by 55 to get average.
2024-06-25 00:07:00 |  | 38.7 |  |  |  | However, G1 counts 60 readings so sum is divided by 60, which is incorrect.
2024-06-25 00:08:00 |  | 31.8
2024-06-25 00:09:00 |  | 42.4 |  |  |  | Column D simulates the data with a formula in it.
2024-06-25 00:10:00 |  | 43.9
2024-06-25 00:11:00 |  | 42.3
2024-06-25 00:12:00 |  | 33.7
2024-06-25 00:13:00 |  | 42.3
2024-06-25 00:14:00 |  | 25.7
2024-06-25 00:15:00 |  | 0
2024-06-25 00:16:00 |  | -5
2024-06-25 00:17:00 |  | -5
2024-06-25 00:18:00 |  | -5
2024-06-25 00:19:00 |  | -5
2024-06-25 00:20:00 |  | 38
2024-06-25 00:21:00 |  | 32.3
2024-06-25 00:22:00 |  | 15.4
2024-06-25 00:23:00 |  | 28.6
2024-06-25 00:24:00 |  | 35.7
2024-06-25 00:25:00 |  | 30.5
2024-06-25 00:26:00 |  | 19.6
2024-06-25 00:27:00 |  | 39.3
2024-06-25 00:28:00 |  | 42.7
2024-06-25 00:29:00 |  | 34.5
2024-06-25 00:30:00 |  | 33.9
2024-06-25 00:31:00 |  | 31.3
2024-06-25 00:32:00 |  | 34
2024-06-25 00:33:00 |  | 45.3
2024-06-25 00:34:00 |  | 37.1
2024-06-25 00:35:00 |  | 28.9
2024-06-25 00:36:00 |  | 29.1
2024-06-25 00:37:00 |  | 47.4
2024-06-25 00:38:00 |  | 39.7
2024-06-25 00:39:00 |  | 24.6
2024-06-25 00:40:00 |  | 44
2024-06-25 00:41:00 |  | 31.2
2024-06-25 00:42:00 |  | 39.3
2024-06-25 00:43:00 |  | 33.7
2024-06-25 00:44:00 |  | 28.5
2024-06-25 00:45:00 |  | 42
2024-06-25 00:46:00 |  | 36.6
2024-06-25 00:47:00 |  | 38.9
2024-06-25 00:48:00 |  | 25.4
2024-06-25 00:49:00 |  | 28.5
2024-06-25 00:50:00 |  | 40.6
2024-06-25 00:51:00 |  | 27.1
2024-06-25 00:52:00 |  | 27.3
2024-06-25 00:53:00 |  | 31.3
2024-06-25 00:54:00 |  | 31
2024-06-25 00:55:00 |  | 43.9
2024-06-25 00:56:00 |  | 22.5
2024-06-25 00:57:00 |  | 37.2
2024-06-25 00:58:00 |  | 29.8
2024-06-25 00:59:00 |  | 23.4
Spreadsheet: 866107d1713048770-index-and-matching-sample
Sheet: Bear

 | 2023-12-01 00:00:00
 | 31 JAN '24 | 31 JAN '23 | 31 JAN '22 | 31 JAN '21 | 31 JAN '20 | 31 JAN '19 | 31 JAN '18 | 31 JAN '17 | 31 JAN '16 | 31 JAN '15 | 31 JAN '14
Total revenues | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Subscription services | 90.962943 | 89.565141 | 88.470361 | 87.736344 | 85.365675 | 84.53639 | 83.424697 | 82.012124 | 79.944702 | 77.847335 | 75.525766
Professional services | 9.037057 | 10.434862 | 11.529642 | 12.263652 | 14.634322 | 15.463614 | 16.575302 | 17.987878 | 20.055303 | 22.152667 | 24.474238
Total costs and expenses | -97.478992 | -103.574754 | -102.266098 | -105.75728 | -113.846194 | -116.415827 | -114.149128 | -124.000469 | -122.769388 | -127.378218 | -132.687048
Costs of revenues | -24.3973 | -27.593762 | -27.790449 | -27.747407 | -29.368556 | -29.585286 | -29.369961 | -30.810683 | -32.213043 | -33.610411 | -37.704345
Cost of goods and services sold | -14.203058 | -16.272147 | -15.487163 | -14.171203 | -13.468024 | -13.460411 | -12.760365 | -13.596792 | -12.893666 | -13.006879 | -14.755682
Costs of professional services | -10.194242 | -11.321616 | -12.303287 | -13.576204 | -15.90053 | -16.124875 | -16.609598 | -17.213891 | -19.319377 | -20.603534 | -22.948663
Research & Development | -33.944069 | -36.530348 | -36.569253 | -39.861593 | -42.730024 | -42.939574 | -42.490094 | -43.362303 | -40.430648 | -40.218823 | -38.835838
Sales and marketing | -29.466869 | -29.732097 | -28.448697 | -28.558918 | -31.609673 | -31.583563 | -31.88759 | -37.203481 | -37.343099 | -40.088341 | -42.089361
General and administrative | -9.670754 | -9.718544 | -9.457698 | -9.589355 | -10.137941 | -12.307401 | -10.401483 | -12.624004 | -12.782597 | -13.460641 | -14.057509
Operating loss | 2.521008 | -3.574751 | -2.266094 | -5.757277 | -13.846195 | -16.415821 | -14.149133 | -24.000467 | -22.769383 | -27.378214 | -32.687051
Other income (expense), net
Other expense, net | 2.383248 | -0.607322 | 2.580993 | -0.614521 | 0.545406 | 1.400761 | -0.539558 | -2.066194 | -2.08561 | -3.842053 | -3.742286
Income (loss) before provision for (benefit from) income taxes
Loss before provision for / benefit from income taxes | 4.904257 | -4.182073 | 0.314899 | -6.371798 | -13.300788 | -15.01506 | -14.688692 | -26.066662 | -24.854993 | -31.220268 | -36.429336
Provision for (benefit from) income taxes
Provision for / benefit from income taxes | 14.120402 | -1.718181 | 0.256694 | -0.16899 | 0.048881 | 0.194672 | -0.30032 | 0.051867 | -0.087495 | -0.255121 | -0.35783
Net income / loss | 19.024659 | -5.900253 | 0.571593 | -6.540789 | -13.251908 | -14.820387 | -14.98901 | -26.014795 | -24.942488 | -31.475389 | -36.787167
Spreadsheet: 685942d1594287792-lookup-code-within-a-large-name-and-return-values-look-up
Sheet: Sheet1

 | VALUES |  | Desired Answers
6008 |  |  | 20 |  |  | LOOKUP TABLE
06062 |  |  | 35 |  |  | 06-HE-06008A | RENT | 20
06063A |  |  | 22 |  |  | 06-HE-06008A | FEE | 1
02119 |  |  | 32 |  |  | 06-HE-06062A | RENT | 35
03012 |  |  | 43 |  |  | 06-HE-06062A | FEE | 2
3013 |  |  | 22 |  |  | T1-L3-06063 | RENT | 22
06073 |  |  | 28 |  |  | 06-SS-002119 | RENT | 32
11501 |  |  | 27 |  |  | T1-L3-03102 | RENT | 43
 |  |  |  |  |  | 470-1-003013 | RENT | 22
 |  |  |  |  |  | 06-SO-006073 | RENT | 28
 |  |  |  |  |  | T1-L3-011501 | FEE | 2
 |  |  |  |  |  | T1-L3-011501 | RENT | 27
 | to look values from lookup table and picking up ones only related to "RENT"
 |  |  |  |  |  | 09-DA-009022
 |  |  |  |  |  | 229-1-009010
 |  |  |  |  |  | 703-1-006080
 |  |  |  |  |  | 703-1-006080
 |  |  |  |  |  | 06-CR-006082
 |  |  |  |  |  | T1-L3-031228
 |  |  |  |  |  | T1-L3-031228
 |  |  |  |  |  | 470-1-006032
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (10)

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (29) | (30) | (31)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9811

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-11-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.89 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 1.91
IFGMR (PEPL/TX/OK) |  |  | 1.95
IFGMR (ANR/LA) |  |  | 1.91
IFGMR (HENRY HUB) |  |  | 2
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  TRANSPORT
 |  |  | 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 | 15784027 | 46298293
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 4750308 | 13933581
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 20534335 | 60231874
 | Purchases:
6 |  | 3rd Party / Inter Enron | -15913928 | -46630843
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -4617010 | -13548941
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -20530938 | -60179784
 | 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: |  | -3397 | -8798.23
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 | -756466.4771017097
31 |  | Prior Month Book Balance | 0 | 1320182.09
 |  | Total MTM Income | 0 | 563715.6128982902
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -315848
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -32
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 3290
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 796865
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 877103d1723785663-spill-formula-for-doing-sum-at-sheet-1-from-sheet2-only-the-unique-values-sumifs-unique-values
Sheet: Sheet1

 |  |  | Result required : [NAME] unique Values of Col.C at D based on Sheet2
 |  | Match | Sum
 | Cat | 56346
 | Rabbit | 6364
 | Owl | 4263
duplicate> | Parrot | 56346
 | Nightangle | 45267 | 12.5
duplicate> | D Rabit | 6364
Spreadsheet: daren_farmer__5219__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Estimated |  |  |  |  |  |  |  |  |  | 0 | 0
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 350000
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 816323d1675513287-complex-unique-count-formula-count-4-
Sheet: Monthly Summary

 | Month: | 2022-03-01 00:00:00 | Zone: | [NAME]
 | Customer | CustomerSalesAccount | Agency | No. of LatePymt
 |  | CAM123 | AG_567
 | Haxelnut ltd | CAM67 | AG_01
 | Cubetronics | CAM123 | AG_13789
 | Foxtrotltd | CAMN459 | AG_389
 | Decagon Ltd | [NAME] | AG_1987
Spreadsheet: 24564255-102f-4f12-bf30-270487aba681
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSCA3 | Test | FSCA3 | [NAME] (SCA) Type 3 | SCA 3 DNA | Polymerase Chain Reaction (PCR)/Fragment Analysis by Capillary Electrophoresis | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender-top (EDTA) tube(s). Send whole blood at ambient temperature.   Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed By:  Athena Diagnostics 		         377 Plantation St. 		         Four Biotech Park 		        Worcester, MA  01605 | Wednesday | 7-14 days | 8-15 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FSCA3 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FSCA3 | Result | [NAME] | SCA 3 DNA | SCA 3 DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: WE-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 | 32342727 | 69312647
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 21139267 | 45804400
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0
 | Total Sales: |  | 53481994 | 115117047
 | Purchases:
6 |  | 3rd Party / Inter Enron | -30998801 | -64763316
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -22756694 | -49167379
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 278223 | 563822
 | Total Purchases: |  | -53477272 | -113366873
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -37334 | -107909
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 50948 | 130305
 | Total Imbalances: |  | 13614 | 22396
 | Storage:
17 |  | Injection (Sales to Stg) | 18826 | 36154
18 |  | W/D (Purchase from Stg) | -69727 | -129724
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -69727 | -129724
 | Total Storage: |  | -50901 | -93570
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 32565 | 67967.51263061557
23 | Fuel: |  | -278223 | -563822
 | Transport Expense:
24 |  | Commodity | 0 | -328269.08
25 |  | Demand | 0 | -1381591.64395
 | Total Transport Expense: |  | 0 | -1709860.72395
 | 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 | 4213356.81
31 |  | Prior Month Book Balance | 0 | -2029682
 |  | Total MTM Income | 0 | 2183674.81
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -23158
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 8921
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 139791d1328470071-help-on-function-vlookup-and-time-time-in-motion-study2
Sheet: Time + Motion 

Times | task duration
 | 5 mins | 10 min | 15 min | 20 min | 25 min | 30 min | 35 min | 40 min | 45 min | 50 min | 55 min | 0 min
08.00-09.00 |  |  |  |  |  |  |  |  |  |  | A | E
09.05-10.00 | E | TO | TO | TO | CA | CA | R | TO | R | R | TO | S
10.05 -11.00 | S | S | R | R | R | R | R | R | R | R | R | TO
11.05-12.00 | S | E | TO | TI | CO | R | TI | TI | TI | CA | CA | CA
12.05-13.00 | A | A | A | CA | CA | E | E | TO | B | B | B | B
13.05-14.00 | B | B | B | B | R | TI | TI | TI | TI | TI | TI | TI
14.05-15.00 | E | E | TO | TO | R | TO | TO | R | TO | TO | TI | CO
15.05-16.00 | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO | TO
16.05-17.00 | TO | TO | TI | TI | TO | TO | TO | TO | TO | TI | CA | CA
17.05-18.00 | A |  |  |  | A | A |  |  |  | A
time per task
total no of hours per task
this is the result I want
 | A is 8 x 5 = 40 spent on Admin
 | E - 7 X 5 - 35 ON EMAIL
 | poss use count to add the tasks then the other to multiply results ?
 | need TIME function in excel ?
Additional notes
admin | A
break | B
consultation | CO
emails | E
letters | L
Meetings | M
phone call in | PI
phone call out | PO
Cnotes | CA
research | R
supporting | S
Training | T
Travel | TR
T Process | TP
case research | CR
TASK DURATION = 5 MIN SLOTS
Spreadsheet: 813621d1673883686-partial-match-lookup-with-multiple-results-lookup-sample
Sheet: Sheet1

Title | Price |  | Match 1 | Match 2 | Match 3 | Match 4 |  | Match 1 Price | Match 2 Price | Match 3 Price
Allen-Bradley Uninterruptible Power Supply 1609-D1500N | 2419.260133655732
181294 New-No Box; NSK 40TAC90BSUC10PN7B Ball Screw Support Bearing; 40mm ID | 141.8864116672696
[NAME] 50 Ton Hydraulic Single Cylinder PN: RLS502 | 359.880433333968
[NAME] 1609-D1500N | 2119.26013365573
[NAME] 1734-IB8S POINT I/O Safety Input Module | 1078.670296822344
Thermo Dust Monitor (PN: [PHONE]) | 1999.388839175218
GE thermal printer PN 2097478-001 | 198.9395122136969
Siemens 6ES7315-2FJ14-0AB0 315F-2PN/DP 6ES7 315-2FJ14-0AB0 FS03 Neu versiegelt | 2522.624374083735
[NAME] CPU 1518-4 PN/DP 6ES7 518-4FP00-0AB0 | 7897.585819545722
A-B Power Supply PN 1609-D1500N | 1819.26013365573
Spreadsheet: 212377d1360109182-how-to-auto-populate-one-cell-based-on-the-selections-of-two-drop-downs-lookup
Sheet: hlookup data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Cement | Sand | Bricks | 5mm Stone | Blocks | Plaster | 4" Nails | 2" Screws
Bag | Bag | Each | Bag | each | Bag | Box | Box
8.5 | 4.5 | 0.5 | 5 | 1 | 6 | 3.5 | 3.75
Spreadsheet: 267399d1380064751-need-to-get-a-minimum-value-pt-min
Sheet: Sheet1

Name | Day | Minimum
Dawson | 6
Dawson | 10 |  |  | Row Labels | Min of Day
Dawson | 10 |  |  | Dawson | 6
Dawson | 7 |  |  | [NAME] | 5
Dawson | 8 |  |  | Grand Total | 5
[NAME] | 7
[NAME] | 11
[NAME] | 10
[NAME] | 5
[NAME] | 8
[NAME] | 7
Spreadsheet: 685226d1593818310-sumifs-problem-test
Sheet: Summary Tracking

Start date | 2020-07-01 00:00:00
Starting Balance | 123
Date | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-08-08 00:00:00 | 15/08/2020 | 22/08/2020 | 29/08/2020 | 2020-09-05 00:00:00 | 2020-09-12 00:00:00 | 19/09/2020 | 26/09/2020 | 2020-10-03 00:00:00 | 2020-10-10 00:00:00 | 17/10/2020 | 24/10/2020 | 31/10/2020 | 2020-11-07 00:00:00 | 14/11/2020 | 21/11/2020 | 28/11/2020 | 2020-12-05 00:00:00 | 2020-12-12 00:00:00 | 19/12/2020 | 26/12/2020 | 2021-01-02 00:00:00 | 2021-01-09 00:00:00 | 16/01/2021 | 23/01/2021 | 30/01/2021 | 2021-02-06 00:00:00 | 13/02/2021 | 20/02/2021 | 27/02/2021 | 2021-03-06 00:00:00 | 13/03/2021 | 20/03/2021 | 27/03/2021
Income
Expenses
Forecasted Amount
Spreadsheet: 130524d1322412139-tracking-player-10-to-10-from-win-and-lost-tracking-player
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10+
 | Results |  |  |  |  |  |  |  |  |  |  |  |  |  | 9+
 | Name1 | W | L | L | W |  |  |  |  |  |  |  | 0 |  | 8+
 | [NAME] | W | W | W | W |  |  |  |  |  |  |  | 4+ |  | 7+
 | Name3 | L | W | L | L |  |  |  |  |  |  |  | 2- |  | 6+
 | Name4 | L | L | L | L |  |  |  |  |  |  |  | 4- |  | 5+
 | Name5 | W | W | L | W |  |  |  |  |  |  |  | 2+ |  | 4+
 | Name6 | L | L | W | L |  |  |  |  |  |  |  | 2- |  | 3+
 | Name7 | W | W | W | L |  |  |  |  |  |  |  | 2+ |  | 2+
 | Name8 | L | W | W | W |  |  |  |  |  |  |  | 2+ |  | 1+
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-
 |  |  |  |  |  |  |  | I'm looking formulas to work with this. |  |  |  |  |  |  | 3-
 |  |  |  |  |  |  |  | Sample > All Name 1 to 8 start with 0. Name1 1st win =1+, 2nd Lost =0, |  |  |  |  |  |  | 4-
 |  |  |  |  |  |  |  | 3rd Lost = 1- , and 4th Win =0. [NAME] win all 4 become 4+. |  |  |  |  |  |  | 5-
 |  |  |  |  |  |  |  | Any idea with formulas? |  |  |  |  |  |  | 6-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-
Spreadsheet: 487520d1478116350-breaking-the-number-down-and-get-payment-convert
Sheet: Sheet1

Number of Cases | 1-300 CS | 301-400 CS | 401-500 CS | 501-600 CS | 600+ CS | TOTAL |  |  |  | 0 | 300 | 400 | 500 | 600 | 9999
 |  |  |  |  |  |  |  |  |  | 0 | 0.36 | 0.43 | 0.45 | 0.49 | 0.5
502 |  |  |  |  |  |  | CASE 1-300 | 0.36
341 |  |  |  |  |  |  | [NAME] | 0.43
416 |  |  |  |  |  |  | CASE 401-500 | 0.45
 |  |  |  |  |  |  | CASE 501-600 | 0.49
 |  |  |  |  |  |  | CASE 600+ | 0.5