tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709288d1608232783-minimum-sum-value-excluding-value-0-min
Sheet: sheet1

Numero |  |  |  |  | A | A | B | B | C | C
123456 |  |  |  |  | 0 | 0 | 42.58 | 3 | 55 | 4 |  |  | <--45,58
321556 |  |  |  |  | 120.12 | 40.24 | 110.58 | 2.5 | 130 | 7
51984 |  |  |  |  | 75.21 | 12.2 | 252.2 | 0 | 170 | 12
Spreadsheet: louise_kitchen__22534__4base329c
Sheet: Financials QTR

Income Statement |  |  | Income Statement |  |  | Income Statement
For the period ending 9/11/00 to | 2001-06-30 00:00:00 |  | For the period ending 9/11/00 to |  |  | to
Option Premiums Earned | 34518969 |  | Option Premiums Earned |  |  | Option Premiums Earned
Permitted Investment Income | 2803647.312497389 |  | Permitted Investment Income |  |  | Permitted Investment Income
Interest Income--Harrier Note | 2838888.888888889 |  | Interest Income--Harrier Note |  |  | Interest Income--Harrier Note
Discount Amortization | 60578841.57325194 |  | Discount Amortization |  |  | Discount Amortization
Discount [NAME] | 3857367.10729805 |  | Discount [NAME] |  |  | Discount [NAME]
Interest Expense | -29451125.10995834 |  | Interest Expense |  |  | Interest Expense
 | 75146588.77197793
[NAME] / (Losses) | 214452925.5 |  | [NAME] / (Losses) |  |  | [NAME] / (Losses)
[NAME] / (Losses) [NAME] | 50517914.65999998 |  | [NAME] / (Losses) [NAME] |  |  | [NAME] / (Losses) [NAME]
Reserve for Shares | -410578841.573252 |  | Reserve for Shares |  |  | Reserve for Shares
[NAME] / (Losses) Derivative | 0 |  | [NAME] / (Losses) Derivative |  |  | [NAME] / (Losses) Derivative
[NAME] / (Losses) | 0 |  | [NAME] / (Losses) |  |  | [NAME] / (Losses)
Realized Gains / (Losses) | 0 |  | Realized Gains / (Losses) |  |  | Realized Gains / (Losses)
 | -145608001.413252
Net Gain/(Loss) | -70461412.64127406 |  | Net Gain/(Loss) |  |  | Net Gain/(Loss)
[NAME] |  |  | [NAME] |  |  | [NAME]
As of: | 2001-06-30 00:00:00 |  | As of: |  |  | Changes to:
Assets |  |  | Assets |  |  | Assets
Cash/Investment | 35104407.9569418 |  | Cash/Investment |  |  | Cash/Investment
Note due from Enron | 50000000 |  | Note due from Enron |  |  | Note due from Enron
Interest Receivable | 1069444.444444444 |  | Interest Receivable |  |  | Interest Receivable
Enron Shares | 0 |  | Enron Shares |  |  | Enron Shares
[NAME] | 197033302.487298 |  | [NAME] |  |  | [NAME]
ENE Share Derivative | 141147192 |  | ENE Share Derivative |  |  | March ENE Shares
Collar Receivable | 264970840.16 |  | Collar Receivable |  |  | Collar Receivable
Swap Receivable | 0 |  | Swap Receivable |  |  | Swap Receivable
Total | 689325187.0486842 |  | Total |  |  | Total
Liabilities & Owner's Equity |  |  | Liabilities & Owner's Equity |  |  | Liabilities & Owner's Equity
Option Obligation | 0 |  | Option Obligation |  |  | Option Obligation
Swap Obligation | 0 |  | Swap Obligation |  |  | Swap Obligation
Collar Obligation | 0 |  | Collar Obligation |  |  | Collar Obligation
Note Due to Enron | 770255283.4899583 |  | Note Due to Enron |  |  | Note Due to Enron
LJMII | 0 |  | LJMII |  |  | LJMII
Enron | -80930096.44127405 |  | Enron |  |  | Enron
Total | 689325187.0486842 |  | Total |  |  | Total
Spreadsheet: 475222d1471198931-if-and-match-dummy-if-and-match-
Sheet: Sheet2

 |  | [NAME] |  |  | 5th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Viviannee | 1000
 |  | [NAME] |  |  | 3th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 500
 |  | [NAME] |  |  | 7th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
 |  | [NAME] |  |  | 25th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1000
 |  | [NAME] |  |  | 11th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 800
 |  | Sylka |  |  | 1st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45
 |  | Viviannee |  |  | 2nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sylka | 300
Spreadsheet: 216041d1361565875-vlookup-will-not-update-from-dropdown-list-quarterly-data-tracking-example
Sheet: 2012 

2012  Data Tracking
Date of Event | Client | Date of Birth | Age | Type                    (Pick from dropdown) | System                         (Pick from dropdown) | Event                        (Pick from dropdown) | Length                      (Pick from dropdown) | Primary Diagnosis | [NAME] for Hospitalization | Admitting Hospital | Path                                (Pick from dropdown)
2012-10-06 00:00:00 | 1 |  | 6 | Hospital | Resp | Unplanned | > 48 hrs | [NAME] | RLL Pneumonia | Gillette | Hospital admit from ER
2012-10-08 00:00:00 | 3 |  | 46 | Hospital | Surgical | Planned | < 23 hrs | Chronic Respiratory Failure | Surgical | Abbott | Admit after [NAME] consult (no ER)
2012-10-29 00:00:00 | 6 |  | 26 | Infection | Urinary | Resolved at Home | N/A | Chronic Respiratory Failure | N/A | N/A | N/A
 | 4
 | 5
Spreadsheet: 140572d1328806537-working-out-capacity-between-two-dates-pet-bookings_table
Sheet: Booking

Booking | Today's Date
Surname | Pet's Name | [NAME] | Departure | No of Nights
Jones | Rover | 2012-01-01 00:00:00 | 2012-01-07 00:00:00
Smith | Tiddles | 2012-01-01 00:00:00 | 2012-01-04 00:00:00
Cooper | Toby | 2012-02-23 00:00:00 | 2012-02-28 00:00:00
[NAME] | [NAME] | 2012-01-22 00:00:00 | 2012-01-26 00:00:00
Richards | Prince | 2012-06-01 00:00:00 | 2012-06-10 00:00:00 |  |  | <[NAME] in Column E
[NAME] | [NAME] | 2012-08-01 00:00:00 | 2012-08-04 00:00:00
[NAME] | Bengie | 2012-04-03 00:00:00 | 2012-04-06 00:00:00
Reynolds | Snoopy | 2012-04-02 00:00:00 | 2012-04-05 00:00:00 |  |  | <Select last cell and tab to enter new record.
Spreadsheet: judy_townsend__17725__TETCOIMB
Sheet: May'01

TETCO MAY IMBALANCES
Gas Day | Scheduled Imbalances-oc710 |  |  |  |  | Interconnect Cuts/Judy Imbalances |  |  |  |  | Allocated Imbalances (2 day lag) |  |  |  |  | Total-cb05 |  |  |  | Gas Day |  | Transport
 | STX | ETX | WLA | ELA |  | STX | ETX | WLA | ELA |  | STX | ETX | WLA | ELA |  | STX | ETX | WLA | ELA |  |  | STX | ETX | WLA | ELA
1 | -157 | -135 | 315 | 224 |  |  | -48 |  | 34 |  |  | -516 | -480 | 301 |  |  |  |  |  | 1
2 | -1267 | -88 | 271 | -6323 |  |  | -1 |  |  |  | -57 | -632 | -301 | 1014 |  |  |  |  |  | 2
3 | -264 | -86 | -570 | -1198 |  | 1 |  |  | -1895 |  | -45 | -372 | -1297 | 2988 |  |  |  |  |  | 3
4 | 1706 | -86 | 1333 | 1674 |  |  |  |  | -340 |  | -64 | -458 | -1276 | 1130 |  |  |  |  |  | 4
5 | 13 | -562 | -967 | -2733 |  |  | -1 |  | -2897 |  | -83 | 228 | -105 | 3016 |  |  |  |  |  | 5
6 | 13 | -562 | -967 | -2733 |  |  | -1 |  | -2897 |  | -96 | 401 | 2095 | 2777 |  |  |  |  |  | 6
7 | 13 | -562 | -967 | -2733 |  |  | -1 |  | -2897 |  | -94 | 422 | 392 | 2187 |  |  |  |  |  | 7
8 | -537 | -61 | -66 | 35 |  |  |  |  | 10375 |  | -88 | 83 | 241 | -1165 |  |  |  |  |  | 8
9 | -852 | 39 | 124 | 1271 |  |  |  |  | 584 |  | -116 | 516 | 306 | -1243 |  |  |  |  |  | 9
10 | 42 | 39 | 167 | -13361 |  |  |  |  | -12366 |  | -119 | 793 | -578 | 11735 |  |  |  |  |  | 10
11 | 3587 | 39 | 850 | 3505 |  |  |  |  | 5048 |  | 117 | 651 | 272 | -5945 |  |  |  |  |  | 11
12 |  | 939 | 554 | 535 |  |  |  |  | 70 |  | -213 | 583 | 1926 | -799 |  |  |  |  |  | 12
13 |  | 939 | 554 | 535 |  |  |  |  | 70 |  | 1732 | 1363 | 2709 | -14094 |  |  |  |  |  | 13
14 |  | 939 | 554 | 535 |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  | 14
15 | -218 | 559 | 431 | -934 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
FILE NAME:  O:\logistics\capacity\east\ne\TETCOIMB |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage |  | 0.25 | 0.25 | 1.18 | 0.11
Spreadsheet: 215509d1361394950-lookup-help-using-indirect-problem-example
Sheet: Scorecard

 | 2013-01-12 00:00:00 | 2013-01-19 00:00:00 | 2013-01-26 00:00:00 |  | [NAME]
Routes:
Milwaukee
Green Bay
[NAME]
Lookup Area:
Paste!
 | Routes | Hours | Yards
 | C | D | E
Milwaukee | 5
Green Bay | 6
[NAME] | 7
Spreadsheet: 746372d1630666939-split-date-ranges-into-single-rows-per-month-dates
Sheet: Sheet1

2021-03-13 00:00:00 | 2021-06-25 00:00:00
2005-01-11 00:00:00 | 2021-06-16 00:00:00
Spreadsheet: 47090d1246002854-counting-problem-example
Sheet: Sheet1

MONTH | COMPANY | ADDRESS | POSTAL CODE
JAN | ABC | 90000 SANDAKAN, SABAH | 90000
JAN | XYZ | 47500 PETALING JAYA | 47500
JAN | ABC | 50000 KUALA LUMPUR | 50000
JAN | XYZ | KELANTAN | 17000
JAN | XYZ | SELANGOR | 47200
FEB | XYZ | 47600 SUBANG JAYA, SELANGOR | 47600
FEB | XYZ | 31450 IPOH, PERAK | 31450
FEB | ABC | 47100 PUCHONG BATU 14, SELANGOR | 47100
FEB | ABC | 41200 KLANG,SELANGOR | 41200
FEB | XYZ | 51000 KUALA LUMPUR | 51000
MAR | ABC | 31350 GUNUNG RAPAT, IPOH, PERAK | 31350
MAR | ABC | 91000 TAWAU SABAH | 91000
MAR | XYZ | 88300 KOTA KINABALU, SABAH | 88300
MAR | ABC | 91000 TAWAU SABAH | 91000
MAR | XYZ | NEGERI SEMBILAN | 72000
MAR | ABC | PERAK | 31400
APR | XYZ | PERAK | 31400
APR | ABC | 86000 KLUANG, JOHOR | 86000
APR | ABC | 28000 TEMERIOH,PAHANG | 28000
APR | ABC | 27000 JERANTUT, PAHANG | 27000
APR | ABC | 11000 P.PINANG | 11000
APR | XYZ | 14000 BKT MERTAJAM, P.PINANG | 14000
APR | XYZ | 56000 KUALA LUMPUR | 56000
APR | XYZ | 57000 KUALA LUMPUR | 57000
JAN | 5 | SELANGOR | 2 | RANGE OF POSTAL CODE: 40000 TO 49999
ABC | 2 | KUALA LUMPUR | 1 | RANGE OF POSTAL CODE: 50000 TO 60000
XYZ | 3 | [NAME] | 1
 |  | KELANTAN | 1
FEB
MAR
APR
Spreadsheet: 747912d1631779064-showing-the-whole-row-when-matched-1-1-
Sheet: Sheet2

Ref No | Case Desciption | Remarks | Status | Severity
12345 | Case 1 | Test | Open | High
89076 | Case 5 | Test | Open | Critical
Spreadsheet: 841431d1693601754-using-sumproduct-to-return-values-based-on-criteria-when-date-filter-changes-excel-formula-09-01-2023
Sheet: B Cases

Case Owner | Type of Request | Status | Date/Time Opened | Date/Time Closed | # of Days to [NAME] | Month | Year
[NAME] | Web Support/SCT | Completed | 2022-08-01 12:35:00 | 2022-08-01 12:35:00
[NAME] | Web Support/SCT | Completed | 2022-08-04 09:33:00 | 2022-08-04 10:08:00
[NAME] | Account Creation | Completed | 2022-07-06 16:26:00 | 2022-07-06 16:45:00
[NAME] | Account Revision/Updates | Completed | 2023-02-20 14:45:00 | 2023-02-20 16:14:00
[NAME] | Account Revision/Updates | Completed | 2023-01-09 13:56:00 | 2023-01-11 15:56:00
[NAME] | Account Creation | Completed | 2023-02-21 12:31:00 | 2023-02-21 16:21:00
[NAME] | Account Creation | Completed | 2023-01-18 13:08:00 | 2023-01-24 16:37:00
[NAME] | Account Creation | Completed | 2023-02-21 12:30:00 | 2023-02-21 16:30:00
[NAME] | Account Creation | Completed | 2023-07-07 07:03:00 | 2023-07-11 11:30:00
[NAME] | Account Creation | Completed | 2022-07-11 08:18:00 | 2022-07-11 08:24:00
[NAME] | Account Revision/Updates | Completed | 2022-07-18 08:27:00 | 2022-07-18 08:31:00
[NAME] | Account Creation | Completed | 2022-08-31 11:25:00 | 2022-09-19 08:34:00
[NAME] | Account Creation | Completed | 2022-07-05 08:58:00 | 2022-07-05 13:03:00
Spreadsheet: 713402d1610705105-finding-whichever-common-text-and-digits-between-two-lists-list-to-serach-text-with-text-string
Sheet: Find Matched Text

Serial | text | Find Here | Find Here
1 | 123 SELCO -
2 | SERVICE
3 | AAA B & Q 1
4 | MY LIVING/ INV 1197
5 | Q RANGE 1S
6 | APPLE [PHONE]
Spreadsheet: 92880d1292415536-excel-2007-data-table-problem-teylyn
Sheet: Data Table

 | Sensitivity Analysis
 |  | Rent | 1200 |  | Price Per Unit | 20
 |  | Utilities | 150 |  | [NAME] | 4500
 |  | Vehicle Expense | 200 |  | Unit Cost | 6.77
 |  | Insurance | 125 |  | Variable Cost | 30465
 |  | Professional Fees | 250 |  | Revenue | 90000
 |  | Advertising | 200
 |  | Wages and Salries | 3000
 |  |  |  |  |  | Variable Cost | Revenue | Profit
 |  | Total Month Expenses
 |  |  |  |  | 3500 |  | 90000 | -1965
 |  | Total Annual Expenses |  |  | 3750 | 30465 | 90000 | -1965
 |  |  |  |  | 4000 | 30465 | 90000 | -1965
 |  | Profit |  |  | 4250 | 30465 | 90000 | -1965
 |  |  |  |  | 4500 | 30465 | 90000 | -1965
 |  |  |  |  | 4750 | 30465 | 90000 | -1965
 |  |  |  |  | 5000 | 30465 | 90000 | -1965
 |  |  |  |  | 5250 | 30465 | 90000 | -1965
 |  |  |  |  | 5500 | 30465 | 90000 | -1965
 |  |  |  |  | 5750 | 30465 | 90000 | -1965
 |  |  |  |  | 6000 | 30465 | 90000 | -1965
Spreadsheet: michelle_lokay__26804__sharris0800fcst
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-08-04 09:53:28.960000
FORECAST ONLY |  | August, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.7867362287999999 | 0.01353622880000005
East Demand Revenues |  | 1.1254 | 0.9970535704 | -0.1283464296000002 |  | Burlington 24216--($53k), [NAME])
East Commodity Revenues |  | 0.1709 | 0.228034485464 | 0.05713448546399996 |  | Higher east volumes
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1682500212 | 0.1093500212 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 12.993985595864 | 0.355785595863999
[NAME] due to Price |  |  |  | 0.5740606000459046 |  | Current index price of $3.85
[NAME] due to net fuel retention. |  |  |  | -0.1984728893380845
Hedging Adjustment |  |  |  | -0.11625 |  | August info. not yet available. Using July estimate.
Unaccounted for Variance |  |  |  | -0.019
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.2403377107078204
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 0.5961233065718194
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through August) |  | 97.41619999999999 | 11.7072 | 109.1234
Actuals through June and July est. |  | 97.656885595864 | 14.3025 | 111.959385595864
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 0.240685595864008 | 2.595299999999998 | 2.835985595864006
 |  | ------------- | ------------- | -------------
Spreadsheet: 830332d1684858778-excel-fomular_index-match-and-min-max-fomular
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AAA | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?
Spreadsheet: 273448d1382714664-multiple-criteria-one-range-calleridavg_test
Sheet: Sheet1

Date | Time | Caller-ID Name | Caller-ID No. | Agent |  | Hold | Duration | Duration MM:SS
2013-10-01 00:00:00 | 07:05:05 | CallerID1 | [PHONE] | Agent | 1 | 6 | 552
2013-10-01 00:00:00 | 07:17:02 | CallerID2 | [PHONE] | Agent | 3 | 6 | 866
2013-10-01 00:00:00 | 07:33:13 | CallerID1 | [PHONE] | Agent | 1 | 6 | 305
2013-10-01 00:00:00 | 07:38:10 | CallerID3 | [PHONE] | Agent | 2 | 24 | 190
Spreadsheet: 188288d1350804995-pull-specific-data-from-multiple-dynamic-worksheets-into-one-report-sheet-sample
Sheet: ELMARK

ORDER DATE | SUPPLIER | PART NO | [NAME] | UM | QTY | PPU | EXPECTED DELIVERY DATE | ORDER STATUS |  | LEGEND
2012-09-26 00:00:00 | Elmark | 874.R8080 | SLOTTED CABLE TRUNK. 8080 GREY SH.PITCH | ml | 40 | 1 | 2012-10-15 00:00:00 | F/D |  | F/D -  FULL DELIVERY
2012-09-27 00:00:00 | Elmark | 570.4061 | PANEL MOUNTING SCHUKO SOCKET OUTLET 2P+E | ml | 20 | 2 | 2012-10-15 00:00:00 | F/D |  | P/D - PARTIAL DELIVEY
2012-09-28 00:00:00 | Elmark | 412.1663 | [NAME]. MOUNT. SOCKET 2P+E 16A IP44 | ml | 10 | 3 | 2012-10-15 00:00:00 | F/D |  | N/D - NOT DELIVERED
2012-09-29 00:00:00 | Elmark | 412.1667 | [NAME]. SOCKET 3P+N+E 16A IP44 | ml | 10 | 4 | 2012-10-15 00:00:00 | P/D
2012-09-30 00:00:00 | Elmark | 676.35100 | EMERGENCY SWITCHBOARDS WITH PUSH BUTTON | buc | 5 | 5 | 2012-10-15 00:00:00 | P/D
2012-10-01 00:00:00 | Elmark | 874.R4040 | SLOTTED CABLE TRUNK. 40X40 GREY SH.PITCH | ml | 140 | 6 | 2012-10-15 00:00:00 | P/D
2012-10-02 00:00:00 | Elmark | 874.R4060 | SLOTTED CABLE TRUNK. 40X60 GREY SH.PITCH | ml | 168 | 7 | 2012-10-15 00:00:00 | P/D
2012-10-03 00:00:00 | Elmark | 216.3237 | EUREKA PLUG 3P+N+E 32A IP67 | buc | 20 | 8 | 2012-10-15 00:00:00 | P/D
2012-10-04 00:00:00 | Elmark | 215.6337 | PLUG 3P+N+E 63A IP67 | buc | 10 | 9 | 2012-10-15 00:00:00 | P/D
2012-10-05 00:00:00 | Elmark | 512.3257 | EUREKA SURF.M.SOC. ANGLED BOX 3P+N+E 32A | buc | 20 | 10 | 2012-10-15 00:00:00 | P/D
2012-10-06 00:00:00 | Elmark | 675.5054B | FLUSH MOUNTING CONSUMER UNIT 54 DIN MOD. | buc | 3 | 11 | 2012-10-15 00:00:00 | N/D
2012-10-07 00:00:00 | Elmark | 654.0320 | EARTH/NEUTRAL IP20 TERMINAL BLOCK | buc | 30 | 12 | 2012-10-15 00:00:00 | N/D
2012-10-08 00:00:00 | Elmark | 820.710 | HALF SADDLE D.10-11 ZINC PLATED STEEL | buc | 1000 | 13 | 2012-10-15 00:00:00 | N/D
2012-10-09 00:00:00 | Elmark | 820.712 | HALF SADDLE D.12-13 ZINC PLATED STEEL | buc | 1000 | 14 | 2012-10-15 00:00:00 | N/D
2012-10-10 00:00:00 | Elmark | 820.714 | HALF SADDLE D.14-15 ZINC PLATED STEEL | buc | 1000 | 15 | 2012-10-15 00:00:00 | N/D
2012-10-11 00:00:00 | Elmark | 820.716 | HALF SADDLE D.16-17 ZINC PLATED STEEL | buc | 1000 | 16 | 2012-10-15 00:00:00 | N/D
2012-10-12 00:00:00 | Elmark | 820.720 | HALF SADDLE D.19-20 ZINC PLATED STEEL | buc | 1000 | 17 | 2012-10-15 00:00:00 | N/D
2012-10-13 00:00:00 | Elmark | 676.35100 | EMERGENCY SWITCHBOARDS WITH PUSH BUTTON | buc | 5 | 18 | 2012-10-15 00:00:00 | N/D
2012-10-14 00:00:00 | Elmark | 874.R2560 | SLOTTED CABLE TRUNK. 25X60 GREY SH.PITCH | ml | 140 | 19 | 2012-10-15 00:00:00 | N/D
2012-10-15 00:00:00 | Elmark | 874.R8080 | SLOTTED CABLE TRUNK. 80x80 GREY SH.PITCH | bax | 1 | 20 | 2012-10-15 00:00:00 | N/D
2012-10-16 00:00:00 | Elmark | 874.R6080 | SLOTTED CABLE TRUNK. 60x80 GREY SH.PITCH | bax | 1 | 21 | 2012-10-15 00:00:00 | N/D
Spreadsheet: 168648d1342534238-end-date-and-time-calculated-from-a-start-date-defined-schedule-and-required-run-time-d0192-07-run-time-calculator
Sheet: D0192-07 Calculator

 | D0192-07 Run Time Calculator
 | [NAME]
 | DAY | ON | OFF | RUN TIME (HR:MIN:SEC) |  |  | D0192-07 Test Start (Month/Day/Year HR:MIN) |  | D0192-07 Test End (Month/Day/Year HR:MIN)
 | Sunday | 0 | 0 | 0 |  | INPUT |  | OUTPUT
 | Monday | 2012-01-01 06:00:00 | 2012-01-01 23:59:59
 | Tuesday | 2012-01-02 00:00:00 | 2012-01-02 23:59:59
 | Wednesday | 2012-01-03 00:00:00 | 2012-01-03 23:59:59
 | Thursday | 2012-01-04 00:00:00 | 2012-01-04 23:59:59
 | Friday | 2012-01-05 00:00:00 | 2012-01-05 22:00:00
 | Saturday | 0 | 0 | 0
 |  |  |  |  | PER WEEK
 | D0192-07 Test Required Run Time (Hours) |  | 300
 | INSTRUCTIONS
 | Laboratory Technician shall input date and time that sample was placed in oven
 | Calculator will provide the end date and time of test based on test start and oven paramaters
Spreadsheet: robin_rodrigue__33345__Canada Power Positions_Jun19
Sheet: Sheet2

Historical MTM
(updated manually) |  |  | Previous Day
 | MTM - Power Book |  | Estimated Liquidation | Actual Liquidation | Actual less estimate
2000-04-30 00:00:00 | 0
2000-05-01 00:00:00
2000-05-02 00:00:00
2000-05-03 00:00:00
2000-05-04 00:00:00
2000-05-05 00:00:00
2000-05-06 00:00:00
2000-05-07 00:00:00
2000-05-08 00:00:00
2000-05-09 00:00:00
2000-05-10 00:00:00 | 1262688 |  | 26580 | 26305
2000-05-11 00:00:00 | 1252588 |  | 28868 | 64868
2000-05-12 00:00:00 | 1303538 |  | 27573 | 29433.62
2000-05-13 00:00:00 |  |  |  | 6000
2000-05-14 00:00:00 |  |  |  | 6000
2000-05-15 00:00:00 | 1280789 |  | 13522 | 14004
2000-05-16 00:00:00 | 1268121 |  | 15554 | 15614
2000-05-17 00:00:00 | 1257320 |  | 13481 | 14163
2000-05-18 00:00:00 | 1676533 |  | 11000 | 8042
2000-05-19 00:00:00 | 1666092 |  | 10500 | 11129.75
2000-05-20 00:00:00 |  |  |  | 10352.5
2000-05-21 00:00:00 |  |  |  | 9288.25
2000-05-22 00:00:00 | 1602507 |  | 4788 | 11531
2000-05-23 00:00:00 | 1591024 |  | 6170 | 13571
2000-05-24 00:00:00 | 1559495 |  | 10823 | 11103
2000-05-25 00:00:00 | 1539621 |  | 11897 | 12746
2000-05-26 00:00:00 | 1523110 |  | 12035 | 12306.75
2000-05-27 00:00:00 |  |  |  | 5939
2000-05-28 00:00:00 |  |  |  | 8342.75
2000-05-29 00:00:00 |  |  |  | 14129.25
2000-05-30 00:00:00 | 1481768 |  | 14133 | 16593
2000-05-31 00:00:00 | 1467850 |  | 11799 | 12864
2000-06-01 00:00:00 | 1367252 |  | 788 | -93.41
2000-06-02 00:00:00 | 1342831 |  | 7695 | 4010.54
2000-06-03 00:00:00 |  |  |  | 7954
2000-06-04 00:00:00 |  |  |  | 19614
2000-06-05 00:00:00 | 1304600 |  | 15510 | 15572
2000-06-06 00:00:00 | 1304801 |  | -27516 | -25573
2000-06-07 00:00:00 | 1287488 |  | 2700 | 2248
2000-06-08 00:00:00 | 1286827 |  | -10222 | -5370
2000-06-09 00:00:00 | 1274581 |  | -2580 | -499.55
2000-06-10 00:00:00 |  |  |  | -19359.3
2000-06-11 00:00:00 |  |  |  | -4140.3
2000-06-12 00:00:00 | 1248625 |  | 4041 | -4436
2000-06-13 00:00:00 | 1245473 |  | -76699.5 | -27912
2000-06-14 00:00:00 | 1205177 |  | -156667 | -126618
2000-06-15 00:00:00 | 1189921 |  | -14756 | -1594
2000-06-16 00:00:00 | 1182147 |  | -8067 | -26816.26
2000-06-17 00:00:00 |  |  |  | -11760
2000-06-18 00:00:00 |  |  |  | -4042
Spreadsheet: 114701d1310427349-line-up-columns-by-sort-and-leaving-blanks-for-no-data-staggered
Sheet: Sheet1

WW | XX | YY | ZZ | unique list
A | 1 | B | 11 | a |  | A | 1 |  |  | 1
B | 2 | C | 12 | b |  | B | 2 | B | 11 | 13
D | 3 | D | 13 | c |  |  |  | C | 12 | 12
E | 4 | F | 14 | d |  | D | 3 | D | 13 | 16
G | 5 | H | 15 | e |  | E | 4 |  |  | 4
H | 6 | I | 16 | f |  |  |  | F | 14 | 14
J | 8 | K | 17 | g |  | G | 5 |  |  | 5
K | 9 | L | 18 | h |  | H | 6 | H | 15 | 21
M | 10 | M | 19 | i |  |  |  | I | 16 | 16
N | 11 | N | 20 | j |  | J | 8 |  |  | 8
 |  |  |  | k |  | K | 9 | K | 17 | 26
 |  |  |  | l |  |  |  | L | 18 | 18
 |  |  |  | m |  | M | 10 | M | 19 | 29
 |  |  |  | n |  | N | 11 | N | 20 | 31
 | get unique list by copying col c below col a then use advanced filter unique values copy to another location f2 then sort  if needed
Spreadsheet: d4088125-d319-4877-b2b3-39f25654f48d
Sheet: TermTypes

Term Type Code | Term Type Description | [NAME] allowed/year/term type
Q | Quarter | 4
S | Semester | 2
T | Trimester | 3
Y | Full Year | 1
QM | Quinmester | 5
OT | Other Term | 48
H | [NAME] | 6
SU | Summer | 10