tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813088d1673541856-hours-between-dates-including-weekends-but-only-during-certain-hours-example-book
Sheet: Sheet1

SVO Number Trimmed | Date Received | Time Received Raw | Time Received | Time / Date Received | Service Tech | Equipment ID | Date Started | Time Started Raw | Time Started | Time/Date Started | Status Date | Date Closed | Status | Svc Location | [NAME] | Onsite Response Time Not Accounting For Non Working Hours | Test Column - Attempting to Calculate for Only Time Elasped during workign Hours
175447 | 2021-01-04 00:00:00 | 804 |  | 1/04/21 08:04:00 | SL | CA-TCR | 2021-01-05 00:00:00 | 743 |  | 2021-01-05 07:43:00 | 2021-01-05 00:00:00 | 2021-02-04 00:00:00 | B | 001 | GEN
175458 | 2021-01-04 00:00:00 | 902 |  | 1/04/21 09:02:00 | RES | D-RTS | 2021-01-04 00:00:00 | 1450 |  | 1/04/21 14:50:00 | 2021-01-04 00:00:00 | 2021-01-21 00:00:00 | B | 001 | GEN
175460 | 2021-01-04 00:00:00 | 907 |  | 1/04/21 09:07:00 | RH | CV-VAULT | 2021-01-07 00:00:00 | 944 |  | 1/07/21 09:44:00 | 2021-01-07 00:00:00 | 2021-01-28 00:00:00 | B | 001 | GEN
175463 | 2021-01-04 00:00:00 | 917 |  | 1/04/21 09:17:00 | JMP | C-CAMERA | 2021-01-04 00:00:00 | 1456 |  | 1/04/21 14:56:00 | 2021-01-04 00:00:00 | 2021-01-21 00:00:00 | B | 001 | GEN
175466 | 2021-01-04 00:00:00 | 930 |  | 1/04/21 09:30:00 | ET | D-DRAWER | 2021-01-04 00:00:00 | 1406 |  | 1/04/21 14:06:00 | 2021-01-04 00:00:00 | 2021-02-12 00:00:00 | B | 001 | GEN
175467 | 2021-01-04 00:00:00 | 935 |  | 1/04/21 09:35:00 | OSE | AL-ALARMPACKAGE | 2021-01-07 00:00:00 | 923 |  | 1/07/21 09:23:00 | 2021-01-07 00:00:00 | 2021-01-29 00:00:00 | B | 001 | GEN
Spreadsheet: 754372d1636128706-excel-not-calculating-average-correctly-average-issue
Sheet: Sheet1

Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 500
60 | 60
 |  |  |  |  | Average should be 50% ????
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 0
60 | 60
 |  |  |  |  | Works OK
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 100
60 | 60
 |  |  |  |  | Works OK
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 20
60 | 60
 |  |  |  |  | Works OK
Spreadsheet: 130272d1322147489-score-sheet-help-data-chart-help
Sheet: Sheet1

 |  |  |  | Variable |  | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00 | 2012-01-06 00:00:00 | 2012-01-13 00:00:00 |  | etc.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | etc.
 |  |  | A | 25 |  | 10 |  | 15 | 25 |  |  |  |  |  |  |  |  | etc.
 |  |  | b | 5 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | etc.
 |  |  | c | 10 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  |  | etc.
 |  |  | d | 20 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | etc.
Spreadsheet: 48303d1247543061-calculate-amount-of-days-paid-in-advance-and-apply-percent-discount-coursefeespaidterm3
Sheet: Sheet1

Student Name | Course Code | Course Name | Date Course Commences | Date Paid | Course Fee | Days Paid in Advance
[NAME] | 43255 | Time Management | 2009-09-12 00:00:00 | 2009-09-11 00:00:00 | 250 | 1
[NAME] | 40847 | Office/Reception Skills | 2009-09-15 00:00:00 | 2009-08-31 00:00:00 | 300 | 15
[NAME] | 40288 | Workplace Assesment | 2009-09-01 00:00:00 | 2009-08-05 00:00:00 | 690 | 27
[NAME] | 40748 | Bookkeeping | 2009-09-09 00:00:00 | 2009-08-31 00:00:00 | 395 | 9
[NAME] | 40847 | Office/Reception Skills | 2009-09-15 00:00:00 | 2009-08-20 00:00:00 | 300 | 26
Spreadsheet: 857821d1706711255-need-help-with-kpi-reports-commerce-return-and-cancelled-orders-17012024-i_scarface-
Sheet: Sheet3

 | RESPONSIBLE DEPT. | REASON CATEGORY | FOREMAN REMARKS
 | Sales | FOR GRV PURPOSE
 | Sales | DOUBLE ORDER | ORDER CANCELLED DUE TO DOUBLE ORDER
 | Sales | AS PER SALESMAN | Cancel due to Space Issue As Per Salesmen.
 | Sales | LONG WAITING TIME OF DRIVER WITH ANOTHER CUSTOMER
 | Sales | GRV ISSUE | CANCELLED DUE TO GRV ISSUE
 | Sales | LPO DATE WRONG | CANCELLED DUE TO WRONG LPO DATE
 | Sales | [NAME] | CANCELLED DUE TO CUSTOMER DIDN’T ORDER
 | Sales | CUSTOMER SYSTEM NOT WORKING | PENDING DUE CUSTOMER RECEIVING SYSTEM NOT WORKING
 | Sales | DOUBLE ORDER | CANCELLED DUE TO DOUBLE ORDER
 | Sales | GRV ISSUE | CANCELLED DUE TO GRV ISSUE
 | Sales | LESS ORDER QUANTITY | PENDING DUE TO LESS ORDER QUANTITY
 | Sales | ALREADY DELIVERED | CANCELLED DUE TO ALREADY DELIVERED
 | Sales | CUSTOMER SYSTEM NOT WORKING | PENDING DUE CUSTOMER RECEIVING SYSTEM NOT WORKING
 | Sales | ALREADY DELIVERED | CANCELLED DUE TO ALREADY DELIVERED
 | Sales | WRONG ORDER | CANCELLED DUE TO WRONG ORDER
 | Sales | SPACE SHORTAGE AT OUTLET | CANCELLED DUE TO  SPACE NOT AVAILABLE AT CUSTOMER SITE
 | Planning | OUT OF STOCK | CANCELLED DUE TO OUT OF STOCK
 | NA | AREA IS [NAME] AND ORDERS ARE LESS SO KEPT UNASSIGNED | ORDER NOT ASSIGNED DUE TO IT IS AN WESTERN REGION DELIVERY DUE TO LESS QTY DIDN’T PLANNED
 | Logistics | MISSED WINDOW TIME | PENDING DUE TO TIMING ISSSUE
 | Logistics | ROAD BLOCKED - POLICE | PENDING DUE TO CUSTOMER SITE ROAD BLOCKED
 | DATA ENTRY | CORRECT DISCOUNT NOT SHOWING | CANCELLED DUE TO DISCOUNT NOT SHOWING IN INVOICE
Spreadsheet: 45621d1244445221-pivot-table-662009104516
Sheet: CUSTOMRPT_0718_662009104516

[Card_Number] | [Quantity] | [Invoice_Rate] | [Invoice_Amount] | [Fleet_No] | [Transaction_Date] | [Odometer] | [Vehicle_Number] | [Product_Name] | [Invoice_Month] | [Registration_Region]
5.93274071800001e+16 | 85 | 0.146 | 12.41 | IN-122 | 2009-01-05 00:00:00 | 38966 | 1456 | DIESEL | 5/31/2009 | AD
5.93274071800001e+16 | 85 | 0.146 | 12.41 | IN-122 | 2009-01-06 00:00:00 | 38966 | 1456 | DIESEL | 5/31/2009 | AD
5.93274071800001e+16 | 85 | 0.146 | 12.41 | IN-122 | 2009-01-07 00:00:00 | 38966 | 1456 | DIESEL | 5/31/2009 | AD
5.93274071800001e+16 | 85 | 0.146 | 12.41 | IN-122 | 2009-01-08 00:00:00 | 38966 | 1456 | DIESEL | 5/31/2009 | AD
5.93274071800002e+16 | 52 | 0.146 | 7.592 | IN-123 | 2009-01-05 00:00:00 | 84592 | 6298 | DIESEL | 5/31/2009 | KL
5.93274071800002e+16 | 52 | 0.146 | 7.592 | IN-123 | 2009-01-06 00:00:00 | 84592 | 6298 | DIESEL | 5/31/2009 | KL
5.93274071800002e+16 | 52 | 0.146 | 7.592 | IN-123 | 2009-01-07 00:00:00 | 84592 | 6298 | DIESEL | 5/31/2009 | KL
5.93274071800002e+16 | 52 | 0.146 | 7.592 | IN-123 | 2009-01-08 00:00:00 | 84592 | 6298 | DIESEL | 5/31/2009 | KL
5.93274071800002e+16 | 147 | 0.146 | 21.462 | IN-124 | 2009-01-05 00:00:00 | 95866 | 1455 | DIESEL | 5/31/2009 | PM
5.93274071800002e+16 | 147 | 0.146 | 21.462 | IN-124 | 2009-01-06 00:00:00 | 95866 | 1455 | DIESEL | 5/31/2009 | PM
5.93274071800002e+16 | 147 | 0.146 | 21.462 | IN-124 | 2009-01-07 00:00:00 | 95866 | 1455 | DIESEL | 5/31/2009 | PM
5.93274071800002e+16 | 147 | 0.146 | 21.462 | IN-124 | 2009-01-08 00:00:00 | 95866 | 1455 | DIESEL | 5/31/2009 | PM
Spreadsheet: 0ef0c66b-a900-41e3-b7f4-d7a8292c17b0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43995306 | 2014-11-12 21:29:22 | ALLIES | 1 | 7 | 5 | 366106 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43995608 | 2014-11-12 21:44:43 | AXIS | 0 | 2 | 7 | 366106 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44003295 | 2014-11-13 12:29:47 | ALLIES | 0 | 4 | 6 | 470347 | hilarion lefuneste | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44003487 | 2014-11-13 12:57:08 | AXIS | 1 | 6 | 4 | 470347 | hilarion lefuneste | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44009107 | 2014-11-13 21:59:35 | ALLIES | 1 | 6 | 4 | 1515794 | Bodega28 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44009526 | 2014-11-13 22:26:18 | AXIS | 1 | 6 | 2 | 1515794 | Bodega28 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44046074 | 2014-11-16 11:06:37 | ALLIES | 1 | 5 | 1 | 443634 | caty | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44046332 | 2014-11-16 11:21:08 | AXIS | 1 | 5 | 4 | 443634 | caty | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44096253 | 2014-11-19 21:12:26 | ALLIES | 1 | 10 | 6 | 366106 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44096619 | 2014-11-19 21:42:00 | AXIS | 0 | 6 | 10 | 366106 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44194473 | 2014-11-26 21:52:54 | AXIS | 1 | 10 | 5 | 13513 | Dreexxer | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44195125 | 2014-11-26 22:46:43 | ALLIES | 0 | 8 | 10 | 13513 | Dreexxer | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 754082d1635937636-date-range-on-master-sheet-to-populate-month-sheets-following-sample-comm-sheet
Sheet: Master

NAME | ROLE | CLIENT | START DATE | END DATE | DAYS WORKED | RESOURCE RATE | SECOND RATE | SELL RATE | TOTAL VALUE FOR IDPP PER MONTH | COMM EARNED PER PROJECT | 2020-02-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 2020-04-01 00:00:00 |  | 2020-05-01 00:00:00 |  | 2020-06-01 00:00:00 |  | 2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  | 2020-10-01 00:00:00 |  | 2020-11-01 00:00:00 |  | 2020-12-01 00:00:00 |  | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00
COMM. CALCULATION
[NAME] | Service Desk Analyst | The Company | 2021-01-01 00:00:00 | 2021-03-30 00:00:00 | 63 | 135 | 160 | 180 |  |  | 1
[NAME] | Desktop Support | The Company | 2021-03-01 00:00:00 | 2021-06-30 00:00:00 |  | 140 | 200 | 250 |  |  | 1
[NAME] | Service Desk Analyst | The Company | 2021-04-01 00:00:00 | 2021-09-11 00:00:00 |  | 155 | 183 | 210 |  |  | 1 |  | 17 |  | 20 |  | 19 |  | 5
[NAME] | PM | The Company | 2021-05-01 00:00:00 | 2021-08-01 00:00:00 |  | 525 | 585 | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
[NAME] | Desktop Technician | The Company | 2021-07-01 00:00:00 | 2021-12-11 00:00:00 |  | 220 | 260 | 299 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 21 |  | 9
[NAME] | Desktop Technician | The Company | 2021-09-01 00:00:00 | 2021-11-09 00:00:00 |  | 220 | 260 | 299 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 21 |  | 9
[NAME] | Desktop Technician | The Company | 2021-10-01 00:00:00 | 2021-12-17 00:00:00 |  | 272 | 340 | 402.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
Spreadsheet: 750491d1633485155-cell-contains-a-date-then-returns-a-certain-text-permit-register-example-5-10-2021
Sheet: Quotes

ABC Job Number | Address | Description | Client
 | Address 27 | Description 27 | Client 27
ABC-21028 | Address 28 | Description 28 | Client 28
ABC-21029 | Address 29 | Description 29 | Client 29
ABC-21030 | Address 30 | Description 30 | Client 30
Spreadsheet: 37801d1235829317-how-do-i-link-cell-contents-across-worksheets-example
Sheet: PC ONE

 | LAST REVIEWED BY: | MIKE
 | 2009-02-28 00:00:00 | PC NUMBER 1 |  | INTERNAL USE ONLY
 | COMPONENT | [NAME] |  | SUPPLIER | SKU | COST
 | PROCESSOR | INTEL PROCESSOR |  | A | 1234 | 1
 | MOTHERBOARD | ASUS MOTHERBOARD |  | B | 514 | 2
 | PROCESSOR COOLING | STANDARD PROCESSOR COOLING |  | X | 561651 | 4
 | PC CHASSIS | BLACK PC CHASSIS |  | B | 51 | 5
 | RAM MEMORY | 2GB RAM MEMORY |  | B | 51 | 6
 | HARD DRIVE | 160G HARD DRIVE |  | A | 5185 | 7
 | GRAPHICS | ONBOARD GRAPHICS |  | X | 1851 | 8
 | WIRELESS | INBUILT WIRELESS |  | X | 651 | 9
 | ADDITIONAL PORTS | ADDITIONAL PORTS |  | X | 891 | 10
 | OPERATING SYSTEM | VISTA OPERATING SYSTEM |  | A | 65 | 11
 | DISPLAY | 19-INCH DISPLAY |  | A | 89 | 12
 | OPTICAL DRIVE 1 | DVD-RWWRITER |  | A | 156 | 13
 | OPTICAL DRIVE 2 | DVD-RWWRITER |  |  | 418 | 14
 | 3.5" FLOPPY DRIVE | 3.5" FLOPPY DRIVE |  | X | 18 | 15
 | DIGITAL CARD READER | 20-IN-1 DIGITAL CARD READER |  | B | 16518 | 16
 | SOUND CARD | ONBOARD SOUND CARD |  | X | 5165 | 17
 | POWER SUPPLY | 500W POWER SUPPLY |  | X | 185 | 18
 | ALL PRICING IS GUARANTEED FOR 7 DAYS FROM THE DATE SHOWN |  |  | X | X | 19
 | TOTAL (INC.VAT) | 500 |  |  | TOTAL COST | 187
 | TOTAL (EXC.VAT) | 434.7826086956522 |  |  | TOTAL COST + VAT | 215.05
 |  |  |  |  | PROFIT | 247.7826086956522
 |  |  |  |  | MARGIN | 56.98999999999999 | %
 |  |  |  |  | SYSPRICE | 434.7826086956521
Spreadsheet: 132366d1323717568-problem-pain-with-offset-looking-for-other-formula-example_offset-to-pivot-table_jpr73
Sheet: Feuil2

Week | Date | H Teams | BHpts | HS | AS | Bapts | A Teams |  | Week | 4
1 | 2011-10-20 00:00:00 | Sherwood S.C. |  |  |  |  | Bye
1 | 2011-10-20 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME] |  | Date | H Teams | BHpts | HS | AS | Bapts | A Teams
1 | 2011-10-20 00:00:00 | Riley's A |  | 4 | 6 |  | Winning Post |  | 2011-11-24 00:00:00 | [NAME] |  | 5 | 5 |  | [NAME]
1 | 2011-10-20 00:00:00 | [NAME] |  | 5 | 5 | 1 | [NAME] |  |  | Bye |  |  |  |  | Riley's A
1 | 2011-10-20 00:00:00 | Spot on Badgers |  | 8 | 2 |  | Phoenix Master |  |  | [NAME] |  | 6 | 4 |  | Sherwood S.C.
1 | 2011-10-20 00:00:00 | Phoenix One |  | 7 | 3 |  | [NAME] |  |  | Phoenix One |  | 4 | 6 |  | The [NAME]
2 | 2011-10-27 00:00:00 | [NAME] |  | 4 | 6 |  | Spot on Badgers |  |  | Sherwood S.C. |  | 7 | 3 |  | The [NAME]
2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | Riley's A |  |  | Winning Post |  | 3 | 7 |  | Phoenix Master
2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME]
2 | 2011-10-27 00:00:00 | Bye |  |  |  |  | Phoenix One
2 | 2011-10-27 00:00:00 | Phoenix Master |  | 8 | 2 |  | Sherwood S.C.
3 | 2011-11-10 00:00:00 | The [NAME] |  |  |  |  | Bye
3 | 2011-11-10 00:00:00 | Riley's A |  | 4 | 6 |  | [NAME]
3 | 2011-11-10 00:00:00 | [NAME] |  | 2 | 8 |  | [NAME]
3 | 2011-11-10 00:00:00 | Spot on Badgers |  | 4 | 6 |  | Winning Post
3 | 2011-11-10 00:00:00 | Phoenix Master |  | 3 | 7 |  | [NAME]
3 | 2011-11-10 00:00:00 | Sherwood S.C. |  | 2 | 8 |  | Phoenix One
4 | 2011-11-24 00:00:00 | Winning Post |  | 3 | 7 |  | Phoenix Master
4 | 2011-11-24 00:00:00 | [NAME] |  | 5 | 5 |  | [NAME]
4 | 2011-11-24 00:00:00 | Bye |  |  |  |  | Riley's A
4 | 2011-11-24 00:00:00 | Phoenix One |  | 4 | 6 |  | The [NAME]
4 | 2011-11-24 00:00:00 | [NAME] |  | 6 | 4 |  | Sherwood S.C.
4 | 2011-11-24 00:00:00 | Sherwood S.C. |  | 7 | 3 |  | The [NAME]
5 | 2011-12-01 00:00:00 | [NAME] |  |  |  |  | Bye
5 | 2011-12-01 00:00:00 | Spot on Badgers |  | 6 | 4 |  | [NAME]
5 | 2011-12-01 00:00:00 | [NAME] |  | 4 | 6 |  | Phoenix Master
5 | 2011-12-01 00:00:00 | [NAME] |  | 5 | 5 | 1 | Winning Post
5 | 2011-12-01 00:00:00 | Riley's A |  | 3 | 7 |  | Phoenix One
5 | 2011-12-01 00:00:00 | Sherwood S.C. | 1 | 5 | 5 |  | [NAME]
5 | TBA | Winning Post |  |  |  |  | [NAME]
Spreadsheet: 830917d1685257852-most-frequent-value-based-on-criteria-edit-most-frequent-value-based-on-criteria-1-
Sheet: Sheet1

Client Number | Client Name | [NAME] | Amount | Sales Month
 | Client 1 | [NAME] | 12 | May |  | If [NAME] is empty, then exclude from calculation.
 | Client 2 | [NAME] | 45 | May |  | Also, if [NAME] is empty or includes the text "Unknown", then exclude from calculation.
 | Client 3 | [NAME] | 27 | May
 | Client 4 | [NAME] | 87 | May |  |  | [NAME] | Which Sales Person appears most frequently overall?
 | Client 5 | [NAME] | 19 | May
 | Client 6 | [NAME] | 52 | June |  |  | [NAME] | Which Sales Person appears most frequently in May?
 | Client 7 | [NAME] | 24 | June
 | Client 8 | [NAME] | 67 | June
 | Client 9 | [NAME] | 42 | June |  | Expected results: |  | [NAME] overall
 | Client 10 | [NAME] | 52 | June |  |  |  | [NAME] in May
 | Client 11 | [NAME] | 57 | June
 | Client 12 | [NAME] | 93 | May
 | Client 13 |  | 12
 | Client 14 |  | 42
 | Client 15 |  | 36
 | Client 16 |  | 91
 | Client 17 |  | 33
 | Client 18 |  | 18
 | Client 19 |  | 36
 | Client 20 |  | 43
 |  | Unknown PTT
 |  | RES Unknown
 |  | PLF Unknown
 |  | Unknown GRF
Spreadsheet: 60542d1261064019-help-with-sumprodcut-formulas-sumproduct-help
Sheet: Sheet1

Account | Account Manager | # User Licenses | Status | EOI Date | Registration Date | License Signed Date
Acct 1 | [NAME] | 2 | License Signed | 2009-04-12 00:00:00 | 2009-05-12 00:00:00 | 2009-06-12 00:00:00
Acct 2 | [NAME] | 1 | License Signed | 2009-08-07 00:00:00 | 2009-11-07 00:00:00 | 2009-12-07 00:00:00
Acct 3 | [NAME] | 1 | Registered | 2009-06-03 00:00:00 | 2009-10-08 00:00:00
Acct 4 | [NAME] | 3 | EOI | 2009-01-03 00:00:00
Acct 5 | [NAME] | 4 | EOI | 2009-02-26 00:00:00
Acct 6 | [NAME] | 4 | EOI | 2009-12-02 00:00:00
April 2009 - April 2010 Total Count
Total Users in EOI |  | 8
Total Users in Registered |  | 4
Total Users in [NAME] |  | 3
April 2009 - April 2010 Total Count - Bob
EOI Users |  | 6
Registered Users |  | 2
[NAME] |  | 2
April 2009 - April 2010 Total Count - Jill
EOI Users |  | 2
Registered Users |  | 2
[NAME] |  | 1
Current Count
Total Users Currently in EOI |  | 11
Total Users Currently in Registered |  | 1
Total Users Currently in [NAME] |  | 3
Spreadsheet: 120650d1315424330-help-with-if-formula-regarding-xy-scatter-chart-charts
Sheet: Sheet1

 |  | Bivariate Regression
 | Linear | Power | Ratio | Parabola
r | 0.9910553842966688 | 0.9903569052621833 | 0.9870877139546708 | 0.9915330709384456
r2 | 0.9821907747434179 | 0.9808067998004892 | 0.9743421550402579 | 0.9831378307646245
a | 97.71503169166392 | 0.919989517491822 | 4.787889254704424 | 73.02072452523375
b | 0.1319482759509732 | 0.7876881226277793 | 0.0003533354775170949 | 0.1470493819396853
c |  |  |  | -1.864636079309369e-06
SYX | 30.96462608692154 | 32.14526595119811 | 37.16664973418851 | 30.40273941700828
v | 0.05432770013016466 | 0.05639914282506699 | 0.06520920342889892 | 0.05334186518339364
F | 3088.437739047803 | 2861.69998842755 | 2126.568336813385 | 1603.369647678966
F-Test | Passes | Passes | Passes | Passes
Extrapolation Limits
(Man-Hours)
Upper | 1467.191527589812 | 1385.71874570853 | 1329.156081466385 | 1435.253287261344
Lower | 136.4235238112886 | 111.729557064874 | 95.44578417478415 | 124.5594309558649
[NAME] |  |  | 2830.171504506277
Parabola X-Apex |  |  |  | 39431.12105664875
Parabola Y-Apex |  |  |  | 2972.181714809788
Tests
Realistic | Passes | Passes | Passes | Fails
Economical | Passes | Passes | Passes | Passes
Extrapolation Range | 1330.768003778524
50% of Extrapolation Range | 665.3840018892619
a-value as % of [NAME] | 0.07342754816332839
Spreadsheet: 268365d1380600643-summing-multiple-criteria-across-rows-and-columns-book1
Sheet: Sheet1

 | Animal | Feb | March | Feb
 | cats | 8 | 23 | 1
 | dogs | 9 | 12 | 2
 | cats | 2 | 5 | 6
 | birds | 2 | 4 | 4
 | dogs | 5 | 8 | 3
 |  | Feb
 | dogs |  |  | only aggregates row references
 | dogs |  |  | sumproduct array
 | Need solution without an array
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9803

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-03-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.17 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.18
IFGMR (PEPL/TX/OK) |  |  | 2.15
IFGMR (ANR/LA) |  |  | 2.18
IFGMR (HENRY HUB) |  |  | 2.26
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: darrell_schoolcraft__7608__imball0201
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg
3 |  |  |  |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4
5
6 |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-12-31 00:00:00 |  |  | -68258
 |  |  |  | 2001-12-31 00:00:00
 | CBS Volume
 |  |  |  | -5084
Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: Heacount - 105660

 | ENRON NORTH AMERICA
 | ENA - Labor & Employment Law (105660)
 | HEADCOUNT AS OF 06-30-01
Employee | Co | Team | Job Title | Headcount
CASH,MICHELLE H | 413 | ENA - Legal | [NAME] | 1
 |  |  | Total | 1
GOODE, [NAME] | 413 | ENA - Legal | Other  Non-commercial | 1
 |  |  | Total | 1
 |  |  | Total for 105660
Spreadsheet: 454406d1459837461-index-match-reconcilatin-file-attached-qaabb_reconcilation_mar16
Sheet: CHABB

IG RECONCILIATION  March 2016 |  |  |  |  |  |  |  |  | chk
VENDOR | CHABB
VENDOR CODE
 |  | IGB CODE | USD | EUR | QAR | AED | CHF
VENDOR BALANCE AS PER STATEMENT OF ACCOUNT |  | IGB165 |  |  |  |  | 7797.7
 |  | IGB195
 |  | IGB705 |  |  |  |  | -333166.7
 |  | IGB235
QAABB SAP BALANCE AS OF 31st March 2016 |  | IGB255 |  |  |  |  | 1370456
 |  | IGB525 | 23215.41
 |  | IGB223
 |  | IGB615 |  |  |  |  | -100829.9
OPEN GR |  | IGB535 |  |  |  |  | -131579.47
TOTAL INVOICES NOT BOOK LESS GRN DONE ([NAME]) |  | IGB525
TOTAL QAABB BALANCE
UNRECONCILED INVOICES IN VENDOR STATEMENT OF ACCOUNT (INVOICES NOT BOOKED IN SAP)
Invoice no | Date | PO Ref | PC | Curr | Amount | Booked | Open GR | [NAME]
Booked in SAP not claiming by counter party
Invoice no | Date | PO Ref | PC | Curr | Amount | Booked | Open GR | [NAME]
PREPARED BY |  |  | APPROVED BY
[NAME] |  |  | Sajeesh.M
Spreadsheet: 134964d1325719349-excel-2007-problem-sorting-names-in-pivot-table-pivot-example
Sheet: Data

Year | Count | Family Name | Given Names
2003 | 1 | Aalders | Hxx
2008 | 1 | Aalders | Hxx
2007 | 1 | Abad | Pxx
2008 | 1 | Abad | Pxx
2010 | 1 | [NAME] | Hxx
2002 | 1 | Abdouka | Kxx
2002 | 1 | [NAME] | Axx
2001 | 1 | [NAME] | Sxx
2001 | 1 | Abernethy | Bxx
2010 | 1 | Abeyrathne | Cxx
2010 | 1 | Abeyrathne | Cxx
2007 | 1 | May | Dxx
2004 | 1 | Sun | Cxx
2004 | 1 | Sun | Cxx
2004 | 1 | Sun | Cxx
2005 | 1 | Sun | Cxx
2007 | 1 | Sun | Cxx
2009 | 1 | Sun | Jxx
2010 | 1 | Sun | Jxx
2010 | 1 | Sun | Jxx
2010 | 1 | Sun | Jxx
2011 | 1 | Sun | Jxx
2011 | 1 | Sun | Jxx
2010 | 1 | Sun | [NAME]