tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164618d1340820205-counting-cells-with-multiple-conditions-sl-no-2-
Sheet: Sheet1

Normal Sl No | Status Confirmation |  | Req Sl No |  | Job | Job Phase | [NAME]
 |  |  | 0 |  |  | SS07950111 | Yes
 |  |  | 1 |  |  | SS07950112 | No
 |  |  | 0 |  |  | SS07960111 | Yes
 |  |  | 3 |  |  | SS07960112 | No
 |  |  | 4 |  |  | SS07960113 | No
 |  |  | 5 |  |  | SS07960114 | No
 |  |  | 0 |  |  | SS07970111 | Yes
 |  |  | 7 |  |  | SS07970112 | No
 |  |  | when the job number is different I just wanted to add 1 with the normal Sl No
Spreadsheet: 824361d1680525904-summary-of-timsesheets-tabs-john-timesheet-test
Sheet: MT

 | Year |  | Nr.[NAME]. | Project Number | Project Title | Total hrs/project | Pd. Nr. →
 |  |  |  |  |  |  | Wk. Nr. →
 | Week |  | 1 | 202201 | Job AAA |  | [NAME]
 | SheetList |  |  | 202202 |  |  | [NAME]
 |  |  |  | 202301 | Job CCC |  | [NAME]
 |  |  |  | 202302 | Job DDD |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Total hrs/wk.→
 |  |  | 1. Go to [NAME] Manager
 |  |  | 2. In the Name Manager dialog box, click New button,
 |  |  | 3. In the popped out New Name dialog, specify a name into the [NAME] text box, and then type the formula =GET.WORKBOOK(1)&T(NOW()) into the Refers to text box
 |  |  | 4. Then click Ok > Close to close the dialog box
 |  |  | 5. Now go to the sheet where you want to list all the sheet names and then enter the following formula into a blank cell: =IFERROR(INDEX(MID(SheetList,FIND("]",SheetList)+1,255)ROWS(&A&2:A2)),"")
 |  |  | Note: In the above formula, SheetList is the range name you created in step 3
Spreadsheet: chris_stokley__4010__Book2
Sheet: Sheet1

BUS_ASSOC_ID | TRADE_INT | CHG_TYP_ID | STLMT_SUM_ID | STLMT_TYPE | DOLLARS_RECEIVED | ADJ_COMMENT | LCTN_ID | TRADE_HR | TRADE_MIN | TOTAL_LOAD_EXPORT | PRICE | ZONE_ID | REF_ID | Percentage | Actual | SumOfFormula | SumOfTOTAL_LOAD_EXPORT | Percent
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -10655.9964542546 |  |  | 21 |  | 199.89
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -2516.130251123752 |  |  | 20 |  | 199.88
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -3939.907147113358 |  |  | 17 |  | 199.87
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -3459.318699371299 |  |  | 19 |  | 199.84
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -9857.002536864577 |  |  | 16 |  | 199.84
1011 | 2001-04-29 00:00:00 | 1480 |  | N | -6034.503450707317 |  |  | 18 |  | 199.85
Spreadsheet: b1b210b4-636a-487e-8d36-4eff79507d5a
Sheet: None compete

Regatta 2013 |  | [NAME] number and mark events not competing
non-Compete List |  | Ship No. | Ship No. | Ship No. | Ship No. | Ship No. | Ship No. | Ship No. | Ship No.
 |  | 10
 | Optional
O-1 | [NAME]
O-2 | Blinker
O-3 | Bos'n chair
O-4 | [NAME]
O-5 | Compass Cards
O-6
O-7 | [NAME]
O-8 | Piloting
[NAME] | Heaving Line
O-10 | Engines
O-11
O-12 | Sailmaking
O-13 | [NAME]
O-14 | Semaphore
O-15 | Splicing, Whip
O-16 | Swimming
O-17 | Taking out line
O-18 | Tug O War
O-19
O-20 | Safety Event
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1078

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | [NAME]
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1078
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-09-01 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13269 | Peacoat | 0 | 2 | 3 | 3 | 2 | 1 | 11 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 11
Spreadsheet: 739501d1625746903-lookup-with-multiple-entries-example-file
Sheet: Sheet1

Name | What | Comments |  |  |  |  | Name | Training 1 | Comment training 1 | Training 2 | Comment training 2
Client 1 | Training 1 | Comment A |  |  |  |  | Client 1
Client 1 | Training 2 | Comment B |  |  |  |  | Client 2
Client 2 | Training 1 | Comment C |  |  |  |  | Client 3
Client 3 | Training 2 | Comment D |  |  |  |  | Client 4
Client 4 | Training 2 | Comment E |  |  |  |  | Client 5
Client 2 | Training 2 | Comment F |  |  |  |  | Client 6
Client 6 | Training 2 | Comment G
Client 5 | Training 1 | Comment H
Client 4 | Training 1 | Comment I
Client 3 | Training 1 | Comment J
Spreadsheet: 847059d1698157388-relationship-between-tables-asa-long-sheet-no-duplicate_dates
Sheet: Sheet1

Program | Date | Weekday | Admission | Completion | Interal Transfers | Discharge | ASA | Census | Cenus Formula | ASA_Frequency | Relative_Frequency | Census=Census
Foundations | 2023-01-03 00:00:00 |  | 14 | 0 | 6 | N/A | 10 | 28
Foundations | 2023-01-04 00:00:00 |  | 7 | 0 | 4 | N/A | 1
Foundations | 2023-01-05 00:00:00 |  | 2 | 0 | 4 | N/A | 1
Foundations | 2023-01-06 00:00:00 |  | 8 | 0 | 2 | N/A | 2
Foundations | 2023-01-09 00:00:00 |  | 5 | 0 | 6 | N/A | 5
Foundations | 2023-01-10 00:00:00 |  | 7 | 0 | 4 | N/A | 2 | 26
Foundations | 2023-01-11 00:00:00 |  | 7 | 0 | 4 | N/A | 0 | 29
Foundations | 2023-01-12 00:00:00 |  | 8 | 0 | 6 | N/A | 2 | 29
Foundations | 2023-01-13 00:00:00 |  | 10 | 0 | 3 | N/A | 0 | 34
Foundations | 2023-01-17 00:00:00 |  | 13 | 0 | 7 | N/A | 4 | 36
Foundations | 2023-01-18 00:00:00 |  | 7 | 0 | 6 | N/A | 4 | 33
Foundations | 2023-01-19 00:00:00 |  | 6 | 0 | 4 | N/A | 1 | 34
Foundations | 2023-01-20 00:00:00 |  | 4 | 0 | 7 | N/A | 2 | 29
Foundations | 2023-01-23 00:00:00 |  | 10 | 0 | 0 | N/A | 1 | 38
Foundations | 2023-01-24 00:00:00 |  | 6 | 0 | 5 | N/A | 0 | 39
Foundations | 2023-01-25 00:00:00 |  | 4 | 0 | 5 | N/A | 1 | 37
Foundations | 2023-01-26 00:00:00 |  | 6 | 0 | 3 | N/A | 1 | 39
Foundations | 2023-01-27 00:00:00 |  | 3 | 0 | 7 | N/A | 1 | 33
Foundations | 2023-01-30 00:00:00 |  | 6 | 0 | 5 | N/A | 2 | 32
Foundations | 2023-01-31 00:00:00 |  | 4 | 0 | 4 | N/A | 5 | 27
Foundations | 2023-02-01 00:00:00 |  | 5 | 0 | 4 | N/A | 1 | 27
Foundations | 2023-02-02 00:00:00 |  | 5 | 0 | 10 | N/A | 2 | 20
Foundations | 2023-02-03 00:00:00 |  | 8 | 0 | 4 | N/A | 3 | 21
Foundations | 2023-02-06 00:00:00 |  | 10 | 0 | 3 | N/A | 4 | 24
Foundations | 2023-02-07 00:00:00 |  | 7 | 0 | 3 | N/A | 2 | 26
Foundations | 2023-02-08 00:00:00 |  | 6 | 0 | 4 | N/A | 1 | 27
Foundations | 2023-02-09 00:00:00 |  | 6 | 0 | 2 | N/A | 2 | 29
Foundations | 2023-02-10 00:00:00 |  | 3 | 0 | 4 | N/A | 2 | 26
Foundations | 2023-02-13 00:00:00 |  | 11 | 0 | 2 | N/A | 5 | 30
Foundations | 2023-02-14 00:00:00 |  | 11 | 0 | 6 | N/A | 2 | 33
Foundations | 2023-02-15 00:00:00 |  | 6 | 0 | 4 | N/A | 2 | 33
Foundations | 2023-02-16 00:00:00 |  | 3 | 0 | 3 | N/A | 2 | 31
Foundations | 2023-02-17 00:00:00 |  | 4 | 0 | 1 | N/A | 4 | 30
Foundations | 2023-02-20 00:00:00 |  | 13 | 0 | 5 | N/A | 3 | 35
Foundations | 2023-02-21 00:00:00 |  | 8 | 0 | 6 | N/A | 0 | 37
Foundations | 2023-02-22 00:00:00 |  | 2 | 0 | 3 | N/A | 3 | 33
Foundations | 2023-02-23 00:00:00 |  | 7 | 0 | 7 | N/A | 2 | 31
Foundations | 2023-02-24 00:00:00 |  | 4 | 0 | 3 | N/A | 2 | 30
Spreadsheet: 798118d1664309490-lookup-based-on-multiple-values-example
Sheet: Sheet1

Date | Name | Job Role | Location | Code
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury | ???
2022-10-15 00:00:00 | Mark | [NAME] | B&Q - Banbury | ???
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury | ???
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury | ???
2022-10-15 00:00:00 | [NAME] | Manager | B&Q - Banbury | ???
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Ayr | ???
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr | ???
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr | ???
2022-10-22 00:00:00 | [NAME] | Deputy Manager | B&Q - Ayr | ???
2022-10-22 00:00:00 | [NAME] | Manager | B&Q - Ayr | ???
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr | ???
Spreadsheet: 44593d1243367141-average-of-rolling-averages-undefined-data-points-rollingaveragetilzero
Sheet: Sheet2

1st formula | 2nd copied to right |  |  |  |  |  |  |  |  |  |  |  | Average
16 | 14 | 16 | 18 | 13 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.66666666666667
4 | 5 | 1 | 6 | 2 | 7 | 3 | 1 | 12 | 0 | 12 | 3 | 5
 |  | 10
Spreadsheet: 110f0c27-f52d-40a9-bf66-90724b1dd48d
Sheet: Sheet 1

MESA grant budget template
Project title:
Organisation name:
Project period:
Principal investigator:
All items must be direct costs, amounts must be in USD, FTE = full time equivalent
 |  |  | Budget by quarter
 |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Subtotal
Budget line items |  |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
Personnel
Job title, name | Salary | FTE
Equipment | Unit price
Supplies | Unit price
Sub-contracts
Travel | Unit price
GRAND TOTAL COSTS
Spreadsheet: 714335d1611176841-need-help-correcting-a-formula-to-detect-eomonth-in-range-to-apply-formula-timesheet-shared
Sheet: Sheet1

TIMESHEET
EMPLOYEE'S NAME: |  |  |  |  |  |  |  | FOR THE PAY PERIOD: |  |  |  |  | to
EMPLOYEE'S SIGNATURE: |  |  |  |  |  |  |  | BATTALION CHIEF SIGNATURE:
 |  |  |  |  |  |  |  | CHIEF SIGNATURE:
DAY: | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | TOTAL
DATE: | 2021-01-02 00:00:00
 | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
Regular Time (Hrs)
Overtime (Hrs)
Vacation (Hrs)
[NAME] (Hrs)
Holiday Pay (Hrs)
Total:
 |  |  |  |  |  | Disclaimer: Time-and-a-half is only paid after 106 total hours. Anything under 106 will be paid at straight time……….^^
 |  |  |  |  |  |  | Prior Balance |  | Used This Period |  | Added This Period |  | Total Remaining
 |  |  |  |  | Vacation (Days): |  |  | - |  | + |  | =
 |  |  |  |  | [NAME] (Days): |  |  | - |  | + |  | =
 |  |  |  |  | Comp Time (Days): |  |  | - | 0 | + | 0 | =
 | NOTES:
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: DEN-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 | 4188330 | 9835988
2 |  | Liquidations
3 |  | Interdesk | 4793099 | 11586227
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 8981429 | 21422215
 | Purchases:
6 |  | 3rd Party / Inter Enron | -5337442 | -11954334
7 |  | Liquidations
8 |  | Interdesk | -3870800 | -9286254
9 |  | Option Premiums
10 |  | [NAME] | 15734 | 36373
 | Total Purchases: |  | -9192508 | -21204215
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 4148 | 8691
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 4148 | 8691
 | 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: |  | 206931 | 483447.7913532659
23 | Fuel: |  | -15734 | -36373
 | Transport Expense:
24 |  | Commodity | 0 | -141551.28
25 |  | Demand | 0 | -371579.5
 | Total Transport Expense: |  | 0 | -513130.78
 | 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 | -9098.960000000196
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | -9098.960000000196
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 25575
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 | -187291
 |  | TOTAL INTRA-MTH
FT-Denver
 |  | Current Month MTM | 0 | 405697 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 240119d1370217366-help-setting-up-correctly-table-rows-columns-example1
Sheet: Sheet1

 |  | 2013-05-01 00:00:00 |  | 2013-05-02 00:00:00 |  | 2013-05-03 00:00:00 |  | 2013-05-04 00:00:00 |  | etc…
[NAME] | PORT # | Error1 | Error2 | Error1 | Error2 | Error1 | Error2 | Error1 | Error2
CWC-OME3 | 8-3-1-2 | 0 | 1 | 0 | 0 | 25 | 0 | 0 | 0
CWC-OME3 | 8-3-1-3 | 6 | 0 | 0 | 1 | 0 | 0 | 5 | 0
CWC-ABC1 | 8-3-1-4 | 0 | 2 | 1 | 0 | 0 | 3 | 0 | 20
CWC-ABC3 | 8-3-1-5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DLTJCT-OME1 | 2-1-5-1 | 0 | 0 | 0 | 65 | 0 | 5 | 10 | 0
DLTJCT-OME1 | 2-1-6-1 | 6 | 2 | 0 | 0 | 0 | 0 | 0 | 5
DMDD-OME2 | 2-1-2-2 | 1 | 0 | 3 | 0 | 1 | 4 | 0 | 0
DMDD-OME2 | 2-1-3-1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 65
DMDD-OME2 | 2-1-4-1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
Lets assume | 250
there are 250 total ports
 |  | Above is the table format we are currently using to enter daily counts for each port.
 |  | I want to be able to produce report to show total number of ports in the system
 |  | and then number of ports that are error free (not total counts).
 |  | My problem is that I cannot sort it by Day, as my days are in same column (above) as Error1/Error2
 |  | My goal is to produce graph based on data like this (even if possible to select date range for graph (there are 200-300 scanned ports)
 |  |  | 2013-05-01 00:00:00 | 2013-05-02 00:00:00 | 2013-05-03 00:00:00 | 2013-05-04 00:00:00 | etc
 |  | Total Ports | 250 | 250 | 250 | 250
 |  | Ports w/Erorr1 | 4 | 2 | 5 | 3
 |  | Ports w/Erorr2 | 4 | 3 | 3 | 3
 |  | Error Free Ports
Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #12. 09 June 2017

Paychecks Dated 09 June 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  |  | [NAME]-first week |  |  |  | [NAME]-second week
 |  | Total Hours | Total Hours | Regular Hours | Overtime Hours | Total Hours | Total Hours |  | Overtime Hours |  | Overtime Hours |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 4 | 2017-05-22 00:00:00 | 2017-05-23 00:00:00 | 2017-05-24 00:00:00 | 2017-05-25 00:00:00 | 2017-05-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-01 00:00:00 | 2017-06-02 00:00:00
Job |  |  |  |  |  |  |  | > | 40 | > | 40
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | X |  | X
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  | X | X | X
3 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  | X
4 | Shop,  Non-Billable |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | X |  |  | X
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 10.25
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25 | 10.25 | 9
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 4
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | Hours-Regular
 | Hours-Overtime
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 |  | 8.75
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9 | 8.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5 | 3.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5
 | Hours-Regular
 | Hours-Overtime
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail |  |  |  |  |  |  |  |  |  |  |  | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
Sales
 | n/a
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 55
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
 |  | regular | Overtime | Total
 | grand total hours
 | check
Spreadsheet: 219502d1362770622-lookup-not-working-correctly-example-wsykes-oeldere-
Sheet: All Talkgroups

Talkgroup ID (Decimal) | Talkgroup ID (Hex) | Talkgroup Description
1 | 1 | Default
2 | 2 | GVPD MAIN
3 | 3 | N B1 OHC
5 | 5 | N B2 OHC1
6 | 6 | GVPD TACT
7 | 7 | N B3 OHC2
9 | 9 | N B4 OHC3
11 | B | N B5 OHC4
13 | D | N B6 OW
15 | F | N B7 OW1
17 | 11 | N B8 OW2
19 | 13 | N B9 OW3
21 | 15 | N B10 OD
23 | 17 | N B11 OD1
25 | 19 | N B12 OD2
27 | 1B | N B13 OD3
29 | 1D | N B14 LD3
31 | 1F | N B15 LD2/TNT 7 GSE
33 | 21 | N B16 LD 1
35 | 23 | N C1 U&S
37 | 25 | N C2 U&S1/TNT 8 GSEM
39 | 27 | N C3 U&S2
41 | 29 | N C4U&S3
42 | 2A | VU SPE1
43 | 2B | N C5 TEST1/VU SPE2
45 | 2D | N C6 TEST2
47 | 2F | N C7 METER
49 | 31 | N C8 METER1
51 | 33 | N C9 RECNECT
53 | 35 | N [NAME]
55 | 37 | N C11 ENGNEER1
57 | 39 | N C12 ENGNEER2
59 | 3B | N C13 SAFETY/N D2 SPR
61 | 3D | N C14 GENSVCS
63 | 3F | N C15 FLEET
65 | 41 | N C16 SECURITY
67 | 43 | N D1 TEL
101 | 65 | N D5 911
103 | 67 | Z601 OHC
105 | 69 | Z602 OHW
107 | 6B | Z603 OHD
109 | 6D | Z604 LOAD
111 | 6F | Z605 U&S
113 | 71 | Z606 TST
115 | 73 | [NAME]
117 | 75 | Z608 RECONECT
119 | 77 | Z609 ENG
121 | 79 | Z610 SFT
123 | 7B | Z611 GS
125 | 7D | [NAME]
127 | 7F | Z613 SECURITY
129 | 81 | Z614 OP1
131 | 83 | Z615 OP2
133 | 85 | Z616 OP3
137 | 89 | N D4 L&F
139 | 8B | N D3 TEL2
505 | 1F9 | TNT6 OP3
507 | 1FB | TNT 4 OP1
513 | 201 | TNT5 OP2
519 | 207 | TNT 1 C&C
539 | 21B | TNT 2 TEMA
543 | 21F | TNT 3 LAW
625 | 271 | P110/P310/P410/P510 CWIDE D
Spreadsheet: matt_motley__26428__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-02-03 00:00:00 | 18.75 | 19.75 | 18.75 | 19.75
Mid-Columbia | 2002-02-03 00:00:00 | 18.75 | 19.75 | 18.75 | 19.75
COB | 2002-02-03 00:00:00 | 20 | 21.25 | 20 | 21.25
N. California | 2002-02-03 00:00:00 | 21.5 | 23.75 | 21.5 | 23.75
Midway/Sylmar | 2002-02-03 00:00:00 | NA | NA | NA | NA
S. California | 2002-02-03 00:00:00 | 20.25 | 24 | 20.25 | 24
Mead | 2002-02-03 00:00:00 | 21 | 23 | 21 | 23
Palo Verde | 2002-02-03 00:00:00 | 17 | 20 | 17 | 20
Inland SW | 2002-02-03 00:00:00 | 17 | 23 | 17 | 23
4-Corners | 2002-02-03 00:00:00 | 18 | 21 | 18 | 21
Central Rockies | 2002-02-03 00:00:00 | 15.75 | 18.25 | 15.75 | 18.25
NW/N. Rockies | 2002-02-04 00:00:00 | 19.75 | 20.75 | 18.75 | 19.75
Mid-Columbia | 2002-02-04 00:00:00 | 19.75 | 20.75 | 18.75 | 19.75
COB | 2002-02-04 00:00:00 | 23 | 23.5 | 20 | 21.25
N. California | 2002-02-04 00:00:00 | 24 | 27 | 21.5 | 23.75
Midway/Sylmar | 2002-02-04 00:00:00 | NA | NA | NA | NA
S. California | 2002-02-04 00:00:00 | 24 | 27.25 | 20.25 | 24
Mead | 2002-02-04 00:00:00 | 25 | 26 | 21 | 23
Palo Verde | 2002-02-04 00:00:00 | 23.75 | 25.5 | 17 | 20
Inland SW | 2002-02-04 00:00:00 | 23.75 | 27.25 | 17 | 23
4-Corners | 2002-02-04 00:00:00 | 23.5 | 26 | 18 | 21
Central Rockies | 2002-02-04 00:00:00 | 21.75 | 24.25 | 15.75 | 18.25
Spreadsheet: 72309d1272999977-vlookup-numeric-only-looup-test-for-alphanumeric_copy
Sheet: Sheet1

Item No | Item Description | Item Group | Correct Info/2 |  |  |  |  |  |  |  | item No Ref | [NAME] return
1 |  |  | return test info15 |  |  |  |  |  |  |  | 7 | return test info1
2 |  |  | return test info11 |  |  |  |  |  |  |  | 14 | return test info2
3 |  |  | return test info13 |  |  |  |  |  |  |  | 13 | return test [NAME]
4 |  |  | return test info14 |  |  |  |  |  |  |  | 12 | return test [NAME]
5 |  |  | return test [NAME] |  |  |  |  |  |  |  | 11 | return test info5
6 |  |  | return test info10 |  |  |  |  |  |  |  | 10 | return test [NAME]
7 |  |  | return test info1 |  |  |  |  |  |  |  | 5 | return test [NAME]
8 |  |  | return test info8 |  |  |  |  |  |  |  | 8 | return test info8
9 |  |  | return test info9 |  |  |  |  |  |  |  | 9 | return test info9
10 |  |  | return test [NAME] |  |  |  |  |  |  |  | 6 | return test info10
11 |  |  | return test info5 |  |  |  |  |  |  |  | 2 | return test info11
12 |  |  | return test [NAME] |  |  |  |  |  |  |  | 15 | return test info12
13 |  |  | return test [NAME] |  |  |  |  |  |  |  | 3 | return test info13
14 |  |  | return test info2 |  |  |  |  |  |  |  | 4 | return test info14
15 |  |  | return test info12 |  |  |  |  |  |  |  | 1 | return test info15
a16 |  |  | #N/A |  |  |  |  |  |  |  | a16
b17 |  |  | #N/A |  |  |  |  |  |  |  | b17
c18 |  |  | #N/A |  |  |  |  |  |  |  | c18
Spreadsheet: 487411d1478075449-sum-product-issue-copy-of-sumproduct-issue
Sheet: Overview

 |  |  | Today | CM | CY | LY
 |  |  |  |  | 2017
 |  |  |  | 1 | 2 | 3 |  | 4 | 5 | 6 |  | 7 | 8 | 9 |  | 10 | 11 | 12
 |  |  |  | January | February | March | Q1 | April | May | June | Q2 | July | August | September | Q3 | October | November | December | Q4 |  | S1 | S2 | YTD | YTG | 16vs15 | SI YTD | SI YTG | SO MAT | SO last 3M
Badoit | 0.5 | PET | Last year
 |  |  | Total
 |  |  | Baseline
 |  |  | Promo
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1 | S2 | YTD | YTG | Weight vs tot
 |  |  | AUTRES AFH 650052406 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | BRASSEURS 650052416 | 7200 | 4320 | 9360 | 0 | 1440 | 10800 | 2160 | 0 | 21419 | 8640 | 5760
 |  |  | CARREFOUR BE 650052393 | 0 | 0 | 0 | 0 | 2880 | 1440 | 4320 | 0 | 7920 | 2160 | 5760
 |  |  | DELHAIZE Le Lion/ De Leeuw 650052430 | 13680 | 0 | 11520 | 0 | 14400 | 23760 | 18720 | 0 | 5760 | 18720 | 45360
 |  |  | ETN FRANZ COLRUYT 650052425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GREY CHANNEL 650052435 | 2880 | 7200 | 11520 | 0 | 17280 | 9360 | 6480 | 0 | 6480 | 5760 | 12960
 |  |  | GROUPE MESTDAGH 650052439 | 0 | 0 | 0 | 0 | 720 | 0 | 0 | 0 | 1440 | 720 | 720
 |  |  | GROUPE OTHER CUSTOMERS DIVERS 650052440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | INTERMARCHE 650037538 | 0 | 0 | 0 | 0 | 2880 | 0 | 720 | 0 | 0 | 720 | 1440
 |  |  | [NAME] ([NAME]. 2044) 650037531 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5760 | 2880 | 720
 |  |  | PROVERA BE 650052464 | 0 | 0 | 1440 | 0 | 1440 | 2880 | 2880 | 0 | 2160 | 2880 | 2880
 |  |  | TRADITION TRADE 650052472 | 0 | 0 | 1440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DELHAIZE DISTRIBUTION Luxembourg 650052431 | 1440 | 0 | 2880 | 0 | 0 | 720 | 720 | 0 | 1440 | 720 | 2880
 |  |  | PROVERA LUX 650037660 | 720 | 0 | 720 | 0 | 1440 | 0 | 1440 | 0 | 1440 | 0 | 1440
 |  |  | RESUMA 650030144 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | SA COLRUYT GESTION LUX 650052426 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | ABND 650103417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Beer & Selected Beverages 650029069 | 0 | 0 | 1440 | 0 | 0 | 1440 | 0 | 0 | 0 | 720 | 0
 |  |  | Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 40494d1238793270-importing-data-conditionally-from-1-worksheet-to-another-book1
Sheet: Sprint1

 |  | Sprint | 1 | Backlog
ID | Story/Task | Project | Priority | Estimated Time | Start Date | Due Date | Sprint | Status
 |  |  | (1 - 10) | (In Man-Days)
1 | Example 1 | A | 10 | 3 | 2009-04-01 00:00:00 | 2009-04-03 00:00:00 | 1 | Done
2 | Example 2 | A | 10 | 3 | 2009-04-01 00:00:00 | 2009-04-07 00:00:00 | 1 | Done
3 | Example 3 | A | 10 | 4 | 2009-04-01 00:00:00 | 2009-04-07 00:00:00 | 1 | In Progress
4 | Example 4 | A | 9 | 5 | 2009-04-01 00:00:00 | 2009-04-15 00:00:00 | 1 | In Progress
5 | Example 5 | A | 9 | 6 | 2009-04-01 00:00:00 | 2009-04-15 00:00:00 | 1 | In Progress
6 | Example 6 | A | 9 | 4 | 2009-04-01 00:00:00 | 2009-04-15 00:00:00 | 1 | To Do
 | DATA
 | 6