tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838967d1691570185-find-several-values-separated-by-a-comma-and-return-a-value-with-no-duplicates-search-dataset-save-file-mve
Sheet: Blad5

Art | RS | #
Intern | 5.01
Intern | 5.04
Intern | 5.08
Intern | 5.09
Intern | 6.02
Intern | 6.04
Intern | 6.06
Intern | 6.14
Intern | 6.15
Intern | 6.17
Intern | 6.26
Intern | 6.32
Intern | 6.38
Intern | 6.51
Intern | 6.60
Intern | 6.68
Intern | 6.74
Intern | 6.85
Spreadsheet: 709544d1608382023-change-formula-to-ignore-hidden-tabs-book1
Sheet: Sheet3

Thing 1 | Thing 2
A | 191 |  | Row Labels | Sum of Thing 2
A | 535 |  | A | 3103
A | 314 |  | B | 4120
A | 76 |  | Grand Total | 7223
A | 776
A | 725
A | 486
B | 806
B | 784
B | 231
B | 535
B | 809
B | 955
Spreadsheet: 689534d1596486697-ranking-by-date-and-time-rank-resets-daily-rank
Sheet: Sheet1

Scheduled time | Rank
2020-01-01 11:55:00 | 1
2020-01-01 11:55:00 | 1
2020-01-01 12:05:00 | 2
2020-01-01 12:05:00 | 2
2020-01-01 12:05:00 | 2
2020-01-01 12:05:00 | 2
2020-01-01 12:05:00 | 2
2020-01-01 12:05:00 | 2
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-01 12:10:00 | 3
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 11:45:00 | 1
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:15:00 | 2
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:30:00 | 3
2020-01-02 12:45:00 | 4
2020-01-02 12:45:00 | 4
2020-01-02 12:45:00 | 4
2020-01-02 12:45:00 | 4
2020-01-02 12:45:00 | 4
2020-01-02 12:45:00 | 4
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:20:00 | 1
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:30:00 | 2
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:40:00 | 3
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 12:50:00 | 4
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
2020-01-03 13:00:00 | 5
Spreadsheet: 215730d1361465436-need-help-creating-a-list-from-a-checkbox-condition-sub-punchlist
Sheet: Sheet1

Contractor | Punchlist A | Complete | Punchlist B | Complete | Punchlist C | Complete
[NAME] |  | False |  | False |  | False
AJ Lauer |  | True |  | True |  | True
A.J. Spanjers Company |  | False |  | False |  | False
Architectural Products |  | False |  | False |  | False
Architectural Sales |  | False |  | False |  | False
Bartley Sales |  | False |  | False |  | False
Central Door and Hardware |  | False |  | False |  | False
Duluth Steel Fabricators |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
Gage Architectural Products |  | False |  | False |  | False
Garage [NAME] |  | True |  | True |  | True
Grazzini |  | False |  | False |  | False
Haldeman-Homme |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
Maxx Steel |  | True |  | True |  | True
McArthur Tile |  | False |  | False |  | False
McDowall Company |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
Midwest Seeding |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
Northern Woodwork |  | False |  | False |  | False
Poblocki Sign |  | False |  | False |  | False
Protective Barrier Systems |  | False |  | False |  | False
PS Door |  | False |  | False |  | False
Rebarfab |  | False |  | False |  | False
Sticky Construction |  | False |  | False |  | False
THD Design |  | False |  | False |  | False
Thygeson Construction |  | False |  | False |  | False
[NAME] |  | False |  | False |  | False
 | Incomplete | List A |  | List B |  | List C
Spreadsheet: 2b779f86-304b-4011-909c-c6ef48d1f1a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2012
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 380 |  | 377 |  | 891 |  | 700
Florida | 108 |  | 105 |  | 960 |  | 210
Georgia | 1290 |  | 1285 |  | 1009 |  | 2700
North Carolina | 585 |  | 580 |  | 977 |  | 1180
South Carolina | 298 |  | 296 |  | 908 |  | 560
Virginia | 86 |  | 85 |  | 1045 |  | 185
Southeast | 2747 |  | 2728 |  | 974 |  | 5535
Arkansas | 590 |  | 580 |  | 1084 |  | 1310
Louisiana | 230 |  | 220 |  | 1025 |  | 470
Mississippi | 470 |  | 460 |  | 981 |  | 940
Missouri | 350 |  | 330 |  | 1018 |  | 700
Tennessee | 380 |  | 375 |  | 922 |  | 720
Delta | 2020 |  | 1965 |  | 1011 |  | 4140
Kansas | 57 |  | 52 |  | 508 |  | 55
Oklahoma | 305 |  | 175 |  | 411 |  | 150
Texas | 6600 |  | 4900 |  | 539 |  | 5500
Southwest | 6962 |  | 5127 |  | 534 |  | 5705
Arizona | 200 |  | 198 |  | 1576 |  | 650
California | 142 |  | 141 |  | 1617 |  | 475
New Mexico | 50 |  | 47 |  | 970 |  | 95
West | 392 |  | 386 |  | 1517 |  | 1220
Total Upland | 12121 |  | 10206 |  | 781 |  | 16600
Pima:
Arizona | 3 |  | 3 |  | 1120 |  | 7
California | 225 |  | 224 |  | 1350 |  | 630
New Mexico | 3 |  | 3 |  | 828 |  | 5
Texas | 8 |  | 8 |  | 960 |  | 15
Total Pima | 239 |  | 237 |  | 1328 |  | 657
Total all | 12360 |  | 10443 |  | 793 |  | 17257
Last update: 12/12/12.
Source:  USDA, December 2012 Crop Production report.
Spreadsheet: b3736972-f1d5-4af6-a6e8-f3befb94a7c2
Sheet: non-GAAP Net Income and Expense

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP to Non-GAAP Earnings and
Reconciliation of GAAP to Non-GAAP Operating Expenses
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | December 31, |  | September 30, |  | December 31,
 |  | 2010 |  | 2010 |  | 2009
GAAP Net Income attributable to NASDAQ OMX: |  | 137 | 43 | 101 |  | 43
Adjustments:
Professional fees |  | 1 |  | 0 |  | 2
Technology |  | 2 |  | 0 |  | 3
Occupancy |  | 1 |  | 2 |  | 8
Workforce reductions |  | 2 |  | 2 |  | 6
Merger and strategic initiatives |  | 3 |  | 1 |  | 0
Asset retirements |  | 0 |  | 2 |  | 0
Foreign currency revaluation |  | 0 |  | -3 |  | 0
Regulatory |  | 0 |  | 0 |  | -3
Gain on sales of businesses |  | 0 |  | 0 |  | -12
Impairment of unconsolidated investees |  | 0 |  | 0 |  | 87
Total Adjustments |  |  |  |  |  | 91
Adjustment to the income tax provision to reflect Non-GAAP adjustments(1) |  | -3 |  | -2 |  | -37
Non-recurring tax items, net |  | -33 |  | -2 |  | 2
Total Adjustments, net of tax |  |  |  |  |  | 56
Non-GAAP Net Income attributable to NASDAQ OMX: |  |  |  |  |  | 99
GAAP Diluted Earnings per Common Share: |  | 0.69 |  | 0.5 |  | 0.2
Total Adj. from Non-GAAP Net Income Above: |  | -0.14 |  | 0 |  | 0.26
Non-GAAP Diluted Earnings per Common Share: |  |  |  |  |  | 0.46
 |  | Three Months Ended
 |  | December 31, |  | September  30, |  | December 31,
 |  | 2010 |  | 2010 |  | 2009
GAAP Operating Expenses: |  | 225 |  | 207 |  | 220
Adjustments:
Professional fees |  | -1 |  | 0 |  | -2
Technology |  | -2 |  | 0 |  | -3
Occupancy |  | -1 |  | -2 |  | -8
Workforce reductions |  | -2 |  | -2 |  | -6
Merger and strategic initiatives |  | -3 |  | -1 |  | 0
Asset retirements |  | 0 |  | -2 |  | 0
Foreign currency revaluation |  | 0 |  | 3 |  | 0
Regulatory |  | 0 |  | 0 |  | 3
Total Adjustments |  |  |  |  |  | -16
Non-GAAP Operating Expenses |  |  |  |  |  | 204
(1) We determine the tax effect of each item based on the tax rules in the respective jurisdiction where the transaction occurred. The
foreign currency revaluation has no associated tax impact.
Spreadsheet: 146646d1332279789-combine-comments-from-four-tabs-into-one-column-inspection_tests_slar
Sheet: SW

E | EQUIP_NO | DSTRCT_CODE | EQUIP_GRP_ID | Defect Priority | Comment | Assessment
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Revisit
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Section 81
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Revisit
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Revisit
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Section 81
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Section 81
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Section 81
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
Spreadsheet: 102691d1300676916-index-match-fifthnpop
Sheet: Dec 10

 |  |  |  |  |  | Dec 10
 | Ordinary Income/Expense |  |  |  | Dec 10
 |  |  | Income |  | Dec 10
 |  |  |  | 4050 · Sales | Dec 10 | 32424
 |  |  | Total Income |  | Dec 10
 |  |  | Cost of Goods Sold |  | Dec 10
 |  |  |  | 5050 · Shop Supplies | Dec 10 | 6532
 |  |  |  | 5070 · Member Services | Dec 10
 |  |  |  | 5073 - Beer, Wine & Soda | Dec 10 | 2312
 |  |  |  | Total 5070 · Member Services | Dec 10
 |  |  | Total [NAME] |  | Dec 10
 |  | Gross Profit |  |  | Dec 10
 |  |  | Expense |  | Dec 10
 |  |  |  | Employee Awards | Dec 10 | 456
 |  |  |  | 1530 · Computer Hardware | Dec 10 | 234
 |  |  |  | 6020 · Advertising Expense | Dec 10 | 5643
 |  |  |  | 6120 · Bank Service Charges | Dec 10 | 345
 |  |  |  | 6135 · Credit Card Merchant Fees | Dec 10 | 3435
 |  |  |  | 6180 · Insurance | Dec 10 | 234
 |  |  |  | 6235 · Maintenance & Cleaning | Dec 10 | 634
 |  |  |  | 6250 · Postage and Delivery | Dec 10 | 13
 |  |  |  | 6260 · Printing and Reproduction | Dec 10 | 124
 |  |  |  | 6270 · Professional Fees | Dec 10
 |  |  |  | 6280 · Legal Fees | Dec 10 | 23
 |  |  |  | Total 6270 · Professional Fees | Dec 10
 |  |  |  | 6285 · Consulting Expense | Dec 10 | 23
 |  |  |  | 6290 · Rent | Dec 10 | 324
 |  |  |  | 6335 · Salon Supply Expenses | Dec 10 | 5234
 |  |  |  | 6340 · Telephone | Dec 10 | 234
 |  |  |  | 6341 · Website Services | Dec 10 | 643
 |  |  |  | 6342 · Email & Internet Services | Dec 10 | 5687
 |  |  |  | 6390 · Utilities | Dec 10
 |  |  |  | 6393 - CAM | Dec 10 | 65
 |  |  |  | 6400 · Gas and Electric | Dec 10 | 234
 |  |  |  | 6410 · Water | Dec 10 | 5
 |  |  |  | 6415 · Cable | Dec 10 | 675
 |  |  |  | 6390 · Utilities - Other | Dec 10 | 406.36
 |  |  |  | Total 6390 · Utilities | Dec 10
 |  |  |  | 6551 · Outsourced Services | Dec 10 | 234
 |  |  |  | 6560 · Payroll Expenses | Dec 10 | 456
 |  |  |  | 6820 · Taxes | Dec 10 | 56
 |  |  |  | 6862 · To be indentified | Dec 10 | 456
 |  |  | Total Expense |  | Dec 10
 | Net Ordinary Income |  |  |  | Dec 10
Net Income |  |  |  |  | Dec 10
Spreadsheet: 164620d1340820345-choose-and-match-a-number-with-a-segment-copy-of-disc
Sheet: Graph Sheets

 | Graph 1
 | Intensity | D | I | S | C | Segment
 | 28 | 27 | 28 | 26 | 24 |  | 7
 | 27 |  |  |  |  |  | 7
 |  |  |  |  |  | 7 | 7
 | 26 | 12 | 12 | 14 | 11 |  | 7
 | 25 | 11 | 11 | 13 | 12 |  | 7
 | 24 | 10 |  |  | 10 |  | 6
 | 23 |  | 10 | 12 | 9 |  | 6
 |  | 9 |  |  |  | 6 | 6
 | 22 |  | 9 |  |  |  | 6
 | 21 | 8 |  | 11 | 8 |  | 6
 | 20 | 7 | 8 |  |  |  | 5
 | 19 | 6 |  | 10 |  |  | 5
 |  |  |  |  | 7 | 5 | 5
 | 18 |  |  |  |  |  | 5
 | 17 |  |  | 9 |  |  | 5
 | 16 | 5 | 7 |  |  |  | 4
 | 15 |  |  | 8 | 6 |  | 4
 |  |  | 6 |  |  | 4 | 4
 | 14 | 4 |  |  |  |  | 4
 | 13 |  |  | 7 | 5 |  | 4
 | 12 | 3 | 5 |  |  |  | 3
 | 11 |  |  | 6 |  |  | 3
 |  |  |  |  |  | 3 | 3
 | 10 | 2 |  |  | 4 |  | 3
 | 9 |  | 4 | 5 |  |  | 3
 | 8 |  |  |  |  |  | 2
 | 7 |  |  | 4 |  |  | 2
 | 6 | 1 | 3 |  | 3 | 2 | 2
 | 5 |  |  |  |  |  | 2
 | 4 |  |  |  |  |  | 2
 | 3 |  | 2 | 3 | 2 |  | 1
 |  | 0 |  | 2 | 1 |  | 1
 | 2 |  | 1 | 1 |  | 1 | 1
 |  |  |  |  |  |  | 1
 | 1 |  | 0 | 0 | 0 |  | 1
 |  | 11 | 13 | 6 | 6
 |  | D | I | S | C
 | I | 7 | 7 | 3 | 4
 |  |  | D42 is 0 because "I" field do not have 13 anywhere :)
Spreadsheet: 15682d26-f107-4e1c-86fa-08700757b7f2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | RECRUITMENT
 |  |  |  |  |  |  | BRANCH: MASCOT
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1800 652 808 before 9am Thursday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 745 Springvale Road, MULGRAVE VIC 3170
August 2010
Spreadsheet: 294444d1391383282-looking-for-help-to-summarize-data-quick-summary
Sheet: Base Data

Item Number | SOH | On Order
CAEXCH4DR3R28 | 0 | 2
CAEXCH4DT3220 | 1 | 7
CAEXCH4DT32200 | 22 | 2
CAEXCH4DT3A220 | 56 | 0
CAEXCH4DT3F76 | 0 | 0
CAEXCH4RA31000 | 0 | 1
CAEXCH4RA32000 | 0 | 4
CAEXCH4RA32000TSK | 76 | 0
CAEXCH4RE22000 | 0 | 5
CAEXCH4RH12500 | 2 | 0
CAEXCH4RJ13000 | 3 | 0
CAEXCH4RK22500 | 0 | 0
CAEXCH4RL11500 | 55 | 2
CAEXCH4RR13000 | 0 | 7
CAEXCH4RR23000 | 0 | 4
CAEXCH6DB3A3000 | 0 | 3
CAEXCH6DB3R32 | 91 | 0
CAEXCH6DH3R35 | 0 | 2
CAEXCH6DJ3R40 | 2 | 1
Spreadsheet: 56667d1256813678-conditional-sums-help-project-date-example
Sheet: Project B

 |  | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Spreadsheet: louise_kitchen__23040__ENW IT Contacts2
Sheet: Sheet1

Enron Net Works - IT Development (Enron Americas)
Date Released:  10/30/01 |  |  |  | Date Revised:  11/05/01 |  | Revision Number:  3
Name |  | Responsibility | Work | Home | Cell | Pager
Stock | Stephen | Sr. Director | x5-8980 | [PHONE] | [PHONE] | [PHONE]
CPR/ERMS
Name |  | Responsibility | Work | Home | Cell | Pager
Lim | [NAME] | CPR/ERMS | x3-5906 | [PHONE] |  | [PHONE]
Wei | Zhiyong | CPR/ERMS | x3-3020 | [PHONE] | [PHONE] | [PHONE]
Credit Aggregation System
Name |  | Responsibility | Work | Home | Cell | Pager
Sung | [NAME] | Credit Aggregation System | x 3-1690 |  |  | [PHONE]
EnPower
Name |  | Responsibility | Work | Home | Cell | Pager
Nat | [NAME] | EnPower | x3-4597 | [PHONE] | [PHONE] | [PHONE]
Smith | Will | EnPower | x3-7486 | [PHONE] | [PHONE] | [PHONE]
Global Data
Name |  | Responsibility | Work | Home | Cell | Pager
[NAME] | [NAME] | Global Data | x5-7316 | [PHONE] | [PHONE]
[NAME]: [EMAIL]
Sitara
Name |  | Responsibility | Work | Home | Cell | Pager
Wei | Zhiyong | Sitara | x3-3020 | [PHONE] | [PHONE] | [PHONE]
Krish | [NAME] | Sitara | x3-5769 | [PHONE] | [PHONE] | [PHONE]
Lim | [NAME] | Sitara | x3-5906 | [PHONE] |  | [PHONE]
Unify
Sr. Director Energy Operations IT: Ramesh Rao |  |  | x5-4207 | [PHONE] | [PHONE] | [PHONE]
Name |  | Responsibility | Work | Home | Cell | Pager
Warner | [NAME] | Unify/DCAF/SCADA | x5-1756 | [PHONE] | [PHONE]
Ripley | [NAME] | EOS Strategic Projects | x5-4709 | [PHONE] | [PHONE]
Pena | [NAME] | Unify | x5-4209 | [PHONE] | [PHONE]
[NAME]: [PHONE]
Enron Net Works Systems Infrastructure
Name |  | Responsibility | Work | Home | Cell | Pager
Rub | [NAME] |  | x3-4771 | [PHONE] | [PHONE] | [PHONE]
Burchfield | [NAME] |  | x3-7454 |  | [PHONE]
EOL
Name |  | Responsibility | Work | Home | Cell | Pager
Webb | [NAME] | Technology | x3-5863 | [PHONE] | [PHONE]
Richter | [NAME] | Technology | x3-4893 | [PHONE] | [PHONE]
Puthigai | Savita | Operations | x3-1787 | [PHONE] | [PHONE]
[NAME] | [NAME] | Infrastructure | x3-0305 | [PHONE] | [PHONE]
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: S Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 06-01) 20-06-2019 | pdf |  | 08-01) 06-08-2019 | pdf |  | 06-01) 20-06-2019 | pdf |  | 09-01) 12-09-2019 | pdf |  | 03-01) 31-03-2020 | pdf
 | 07-01) 28-07-2019 | pdf |  | 02-01) 23-02-2020 | pdf |  | 09-01) 12-09-2019 | pdf |  | 02-01) 23-02-2020 | pdf |  | 05-01) 13-05-2020 | pdf
 | 09-01) 12-09-2019 | pdf |  | 05-01) 13-05-2020 | pdf |  | 02-01) 23-02-2020 | pdf
 | 02-01) 23-02-2020 | pdf
 | 03-01) 31-03-2020 | pdf
 | 05-01) 13-05-2020 | pdf
Spreadsheet: 694199d1599430414-if-formula-value-cannot-exceed-a-certain-value-sample
Sheet: Heimilisbókhald-grunnur

XY
 |  | x | June | July | Aug | Sept | total 4m |  | Avg.month |  | avg. yr
Rev
 | a | 512000
 | s | 85000
 | d | 5000
 | f | 670000
 | g
Cost
 | u | 220000
 | i | 1677.5
 | o |  | 120000 | 133000 | 110000 | 85000
 | p |  | 79000 | 370000 | 158000 | 62500
 | z | 50
 | x |  | 2000 | 5000 | 9500 | 9000
 | c |  | 123000 | 80000 | 145000 | 197500
 | v
 | b |  | 110000 | 110000 | 110000 | 110000
 | n
 | m
 | q
 | w | 180000
 | Euroz
 | ZZ | Eurro | 163.92 | 164.5 | 162.8 | 162.1
 | XX | Vís. | 263.2 | 262.6 | 263.4 | 263.6
Spreadsheet: 217514d1362086393-match-and-sum-with-date-range-neagtive-values-find-and-sum-shafiqe-oeldere2-
Sheet: Sheet1

 |  |  | Date Range |  | Source |  | Date Date | A | B | C |  | Kgs
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | A |  | 2013-02-02 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | B |  | 2013-02-03 00:00:00 | 0.03 | 0.02 |  |  | 100
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | C |  | 2013-02-03 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-01-01 00:00:00 | 2013-01-12 00:00:00 | A |  | 2013-01-01 00:00:00 | 0.03 | 0.04 |  |  | 100
Description |  |  | Match Date Range |  | Source |  |  |  |  |  |  | Kg
Sumif for this date range if negative % column K and source is A |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | A |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is B |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | B |  |  |  |  |  |  | 0 | Result
Sumif for this date range if negative % column K and source is C |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | C |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is A |  |  | 2013-01-01 00:00:00 | 2013-01-12 00:00:00 | A |  |  |  |  |  |  |  | Result
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9902

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-02-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.74 |  |  | No. of Days: | 28
IFGMR (TRKL/LA) |  |  | 1.75
IFGMR (PEPL/TX/OK) |  |  | 1.76
IFGMR (ANR/LA) |  |  | 1.75
IFGMR (HENRY HUB) |  |  | 1.81
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.5 |  | 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.5 |  | 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.5 |  | 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: 717008d1612450999-find-duplicate-items-whit-two-conditions-day
Sheet: Sheet1

Day | [NAME] | Sell | [NAME] |  | Day | [NAME]
1 | A | 100 | book |  | 1 | A
2 | B | 200 | pen
1 | A | 300 | Car
3 | B | 400 | Pen |  |  |  | I need the Result acording f2 & G2 sells
1 | A | 500 | book |  | Result
2 | B | 600 | Car |  |  |  | without vb & helper column,please
1 | A | 700 | pencel
2 | A | 800 | pencel
1 | A | 900 | Car
3 | A | 1000 | book
Spreadsheet: 70368d1271150884-lists-and-vlookup-cashbook-2010-2011
Sheet: Expenditure

Date | Transaction Type | Ref | Allocation | Paid To | Budget Header | Description | Amount | Check Total | Date Banked | Month banked
 | S/O |  | ADV1011P |  | budget header
 |  |  | BE1011p |  | rats
 |  |  | BS1011p |  | Postal supplies
 |  |  | CLP1011p
 |  |  | CP1011p
 |  |  | DBF10p
 |  |  | OH3TR
 |  |  | EBW0910p
Spreadsheet: 163823d1340474494-how-to-fine-top-10-customers-sample
Sheet: Sheet1

Customer Name | Amount
Abc Ltd | 7600
DG corporation | 118132.5
Xyz tex | 25846
Advanced Technology | 3815.624
Axis traders | 12290.46
XL Technical | 14200
KD Trading | 26125
PR Middle East | 73240.75
DP Trading | 62883.498128
DLL corporation | 2100
[NAME] | 0
Highest Customer Name
1
2
3
4
5
6
7
8
9