tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60690d1261193360-help-with-frequency-adambudget2009-dev
Sheet: PayCheck - DEC-09-B

Left Over | Date | Finger Print | Item Name | Categories | Tags | Tag Amount | Bank Amount | Comments
 | 2009-12-15 00:00:00 | 1 | PayCheck | Income | Income - Adam's PayCheck | 1284.23 | 1284.23
Filter
Blank | 2009-12-18 00:00:00 | 2 | WaffleHouse | Food |  |  | -13.19
Finger Print Check | 2009-12-18 00:00:00 | 2 | WaffleHouse | Food | Food - A&E Eating Out | 13.19
 | 2009-12-18 00:00:00 | 3 | WalGreens |  |  |  | -34.3
 | 2009-12-18 00:00:00 | 3 | WalGreens | Medical | Medical - Jen | 4.59
 |  | 3 | WalGreens | Medical | Medical - Adam | 29.71
 | 2009-12-18 00:00:00 | 4 | Special Money Pawn |  |  |  | -14.07
 | 2009-12-18 00:00:00 | 4 | Special Money Pawn | Entertainment | Entertainment - DVDS | 14.07
 | 2009-12-18 00:00:00 | 5 | [NAME] |  |  |  | -10.38 | Jen's Christmas Gift From Emma
 | 2009-12-18 00:00:00 | 5 | [NAME] | Gifts | Gifts - Christmas | 10.38
 | 2009-12-18 00:00:00 | 6 | Posh Car Wash |  |  |  | -14.99 | Cleaned my Car
 | 2009-12-18 00:00:00 | 6 | Posh Car Wash | Auto | Auto - Maintenance - VW | 14.99
 | 2009-12-18 00:00:00 | 7 | Albertsons |  |  |  | -3.94
 | 2009-12-18 00:00:00 | 7 | Albertsons | Food | Food - Household Groceries | 1.15 |  | [NAME]
 | 2009-12-18 00:00:00 | 7 | Albertsons | Food | Food - Adam's Groceries | 2.79 |  | [NAME]
 | 2009-12-18 00:00:00 | 8 | Double Daves Pizza |  |  |  | -12.21
 | 2009-12-18 00:00:00 | 8 | Double Daves Pizza | Food | Food - A&E Eating Out | 12.21
 | 2009-12-18 00:00:00 | 9 | [NAME] SOFTWA |  |  |  | -3.99 | New Music Service
 | 2009-12-18 00:00:00 | 9 | [NAME] SOFTWA | Entertainment | Entertainment - Online | 3.99
Spreadsheet: 71015d1271772406-sum-differences-of-time-total-time
Sheet: Sheet1

 |  |  | Start Time | End Time | Total Time
 |  |  | 10:00:00 | 13:57:00 | 03:57:00
 |  |  | 09:55:00 | 13:56:00 | 04:01:00
 |  |  | 10:38:00 | 14:42:00 | 04:04:00
 |  |  | 10:01:00 | 14:44:00 | 04:43:00
 |  |  | 10:04:00 | 14:21:00 | 04:17:00
 |  |  | 10:01:00 | 13:20:00 | 03:19:00
 |  |  | 13:31:00 | 14:55:00 | 01:24:00
 |  |  | 12:17:00 | 14:07:00 | 01:50:00
 |  |  | 09:57:00 | 15:01:00 | 05:04:00
 |  |  | 09:53:00 | 13:50:00 | 03:57:00
 |  |  | 11:03:00 | 14:11:00 | 03:08:00
 |  |  | 12:43:00 | 14:13:00 | 01:30:00
 |  |  | 09:51:00 | 14:51:00 | 05:00:00
 |  |  | 10:32:00 | 14:04:00 | 03:32:00
 |  |  | 09:39:00 | 15:14:00 | 05:35:00
 |  |  | 09:33:00 | 15:15:00 | 05:42:00
 |  |  | 09:19:00 | 15:55:00 | 06:36:00
 |  |  | 09:45:00 | 15:18:00 | 05:33:00
 |  |  | 10:13:00 | 15:29:00 | 05:16:00
 |  |  | 09:06:00 | 15:52:00 | 06:46:00
 |  |  | 08:35:00 | 15:18:00 | 06:43:00
 |  |  | 10:16:00 | 13:42:00 | 03:26:00
 |  |  | 08:48:00 | 15:45:00 | 06:57:00
 |  |  | 09:58:00 | 16:42:00 | 06:44:00
 |  |  | 08:43:00 | 15:27:00 | 06:44:00
 |  |  | 08:40:00 | 15:22:00 | 06:42:00
 |  |  | 09:05:00 | 15:02:00 | 05:57:00
 |  |  | 11:40:00 | 14:58:00 | 03:18:00
 |  |  | 11:04:00 | 15:19:00 | 04:15:00
 |  |  | 10:32:00 | 16:06:00 | 05:34:00
 |  |  | 09:06:00 | 16:34:00 | 07:28:00
 |  |  | 08:44:00 | 15:41:00 | 06:57:00
 |  |  | 08:32:00 | 15:30:00 | 06:58:00
 |  |  | 10:43:00 | 14:11:00 | 03:28:00
 |  |  | 09:08:00 | 16:29:00 | 07:21:00
 |  |  | 09:40:00 | 16:01:00 | 06:21:00
 |  |  | 08:21:00 | 16:00:00 | 07:39:00
 |  |  | 08:14:00 | 16:32:00 | 08:18:00
 |  |  | 08:07:00 | 16:13:00 | 08:06:00
 |  |  | 11:32:00 | 12:55:00 | 01:23:00
 |  |  | 14:04:00 | 18:20:00 | 04:16:00
 |  |  | 08:46:00 | 18:19:00 | 09:33:00
 |  |  |  | Total Time =
Spreadsheet: 171064d1343609592-match-and-determine-frequency-match-and-frequency
Sheet: Sheet1

 | Sample Table
 | Table / File 1 | Descriptions |  | Table / File 2 |  | Table / File 3 |  | Table / File 4 |  |  | Match Results File 1 & 2 |  | Match Results File 1 & 2
 | MNDJ17 | Description 1 |  | 769503 |  | 704706 |  | 769503
 | [NAME] | Description 2 |  | 769301 |  | 704747 |  | 769403
 | MNDJ17 | Description 3 |  | 711100 |  | 711100 |  | 769303
 | 769311 |  |  | 704747 |  | 769301 |  | MNDJ17
 | 769303 |  |  | 704706 |  | 769303 |  | [NAME] |  |  |  |  |  |  | If all possible - Match all 4 tables / columns & provide ID results
 | 769403 |  |  |  |  | 769403 |  | MNDJ17
 | 769503 |  |  |  |  | 769503 |  | 704706
 | Scenario or Situation |  |  |  |  |  |  |  |  |  |  |  | Looking for function that if 2 of the columns match, it will generate the ID number
 | I have 4 Excel files with a large list of IDs in them   -- Table 1 is organized by sales   -- Table 2 is organized by known products   -- Table 3 is QAs list of known product IDs   -- Table 4 is table that a department is working  I need to compare these files, match up product IDs & verify which list is more valid or confirm the product IDs that are in actual used |  |  |  |  |  |  |  |  |  |  |  | It would also be nice if it could add the description, but those may not match or be some variation
 |  |  |  |  |  |  |  |  |  |  |  |  | If possible - Match all 4 tables & provide ID results, along with associated description
 | After verifying Product IDs usage, looking to do the following: -- Develop some type of "Match" verification between 2 or all the    columns or files, which will be compiled into 1 worksheet -- Determine frequency of how many times an ID matches between    all of the tables or files -- Perhaps, prioritize product IDs by the frequency that the IDs     shows up
Spreadsheet: 197806d1354565176-data-extraction-help-practice-file-bb-
Sheet: Sheet2

 |  | Study |  | Task    # | Task Description | Participant | Unit | Unit Cost | Number of Units | Total Cost | CIPS Units | CIPS | Revised Units | Revised
LIST OF STUDIES |  |  |  |  |  |  |  |  |  |  |  | Cost (USD) |  | Cost (USD)
Fun
Library |  | Fun |  | 1 | task 1 | people | weeks | 3000 | 1 | 3000
Cars |  | Fun |  | 2 | task 2 | client | months | 5000 | 1 | 5000
Trees |  | Fun |  | 3 | task 3 | client | hours | 1000 | 22 |  | -10 |  | 12
 |  | Library |  | 1 | task 1 | people | weeks | 600 | 1
 |  | Library |  | 2 | task 2 | client | months | 3250 | 1
 |  | Library |  | 3 | task 3 | client | hours | 500 | 15 |  | -5
 |  | Cars |  | 1 | task 1 | people | weeks | 1200 | 1 | 1200
 |  | Cars |  | 2 | task 2 | client | months | 450 | 1 | 450
 |  | Cars |  | 3 | task 3 | client | hours | 750 | 50 |  | -15
 |  | Trees |  | 1 | task 1 | people | weeks | 4250 | 1
 |  | Trees |  | 2 | task 2 | client | months | 3450 | 1
 |  | Trees |  | 3 | task 3 | client | hours | 900 | 10 |  | 5
Spreadsheet: 823718d1680108474-how-to-get-a-formula-to-read-a-defined-name-from-a-cell-test-1
Sheet: Sheet2

 | JSN# | [NAME] | Qty |  |  |  |  |  |  |  |  | Defined Names
 |  |  |  |  | Department | Utility | Utility Legend | JSN# | Total |  | _286 | Plumbing1 | MedGas1
 |  |  |  |  | _262 | Plumbing2 | A | F2000 |  |  | _262 | Plumbing2 | MedGas2
Spreadsheet: 34462d1231770589-get-rid-of-value-scoreboard
Sheet: Sheet1

[NAME] ([NAME])
[NAME] Ayres 6-1 Darren Whittingham
[NAME] 6-1 John Quantock
[NAME] 6-3 [NAME]
[NAME]3 Norman Fletcher
[NAME] ([NAME])
[NAME]1 [NAME]
[NAME] 6-2 Peter Walford
[NAME] Sean Dowling
[NAME] 6-1 Sam Rooney
[NAME] ([NAME])
[NAME] 6-5 [NAME]
[NAME] 6-2 Darren Latham
[NAME]
[NAME] [NAME]
[NAME] 6-3 [NAME]
[NAME] Eames
[NAME] 6-5 [NAME]
[NAME]
[NAME] [NAME]
[NAME] 6-2 Paul Jodkin
[NAME] 6-3 Joe Cullen
First Round
[NAME] 6-1 Mark Carter
[NAME]
[NAME] 6-1 Andy Mason
[NAME] Ayres 6-5 Dennis Smith
Adrian Lewis 6-1 Andy Pearson
[NAME] 6-4 Simon Craven
[NAME] 6-2 Jacko Barry
[NAME] 6-2 Richie Burnett
[NAME] 6-0 Shane Cox
[NAME]
[NAME] 6-1 Kirk Shepherd
[NAME] 6-1 Brian Jones
[NAME] 6-1 [NAME]
Lionel Sams 6-2 Joey Palfreyman
[NAME] 6-4 Tony Eccles
[NAME] 6-2 [NAME]
[NAME] 6-0 Geoff Whitworth
[NAME] [NAME] Davies
[NAME] Darren Green
[NAME]
[NAME] [NAME]
[NAME] [NAME]
[NAME] 6-0 [NAME]
[NAME] 6-5 Jason Clark
[NAME] 6-5 [NAME]
[NAME] 6-3 [NAME]
[NAME] Justin Pipe
[NAME] [NAME]
[NAME] 6-3 [NAME]
[NAME] 6-0 [NAME]
[NAME] 6-3 Jan van der Rassel
[NAME] Chris Cooper
[NAME] 6-3 [NAME]
[NAME] 6-1 Andy Relf
Co Stompe 6-2 Robbie Newland
[NAME] 6-4 [NAME]
[NAME] 6-2 [NAME]
[NAME] 6-5 [NAME]
[NAME]
[NAME]
[NAME]-0 [NAME]
[NAME]-0 [NAME]
[NAME] ([NAME])
[NAME] 6-0 [NAME]
[NAME] 6-1 Frazer Hill
[NAME] 6-4 Mervyn King
[NAME] Arron Monk
[NAME]
[NAME] 6-4 Kieran Leal
[NAME] 6-2 Ian Jopling
[NAME]
[NAME] [NAME]
[NAME] 6-1 [NAME]
[NAME] 6-4 [NAME]
[NAME] [NAME]
[NAME] Chris Mason
[NAME] 6-2 Jimmy Dunlop
[NAME] 6-1 Davey Mansell
[NAME] 6-1 Chris Daglish
[NAME] 6-1 Ian Lilley
[NAME] Jim Withers
Par [NAME] 6-1 Adrian Gray
[NAME] 6-4 [NAME]
Russell Mason Bye ([NAME])
Second Round
[NAME] Wes Newton
[NAME] 6-5 Tony Ayres
Adrian Lewis 6-4 Gary Welding
[NAME] 6-3 Mark Jodrill
[NAME] 6-5 Colin Monk
[NAME] 6-3 [NAME]
[NAME] 6-2 Lionel Sams
[NAME] 6-3 [NAME]
[NAME] [NAME] [NAME]
[NAME] [NAME]
[NAME] [NAME]
[NAME] 6-3 Michael Barnard
[NAME] 6-4 Martyn Turner
[NAME] Ronnie Baxter
[NAME] 6-3 [NAME]
[NAME] 6-3 Louis Blundell
[NAME] 6-5 [NAME]
Co Stompe 6-1 [NAME]
[NAME] 6-3 David Fatum
[NAME]
[NAME] [NAME]
[NAME] 6-3 Stephen Hardy
[NAME] 6-0 [NAME]
[NAME] [NAME]
[NAME] 6-0 Alan Warriner-Little
[NAME]
[NAME] 6-4 [NAME]
[NAME] [NAME]
[NAME] 6-3 Mick McGowan
[NAME] 6-0 Darren [NAME]
[NAME] 6-2 Par Riihonen
[NAME] 6-2 [NAME]
Losers £200
Third Round
[NAME] [NAME]
Adrian Lewis 6-4 [NAME]
[NAME] 6-4 [NAME]
[NAME] 6-4 Steve Maish
[NAME] [NAME]
[NAME] Wayne Jones
[NAME] [NAME]
[NAME] Dave Askew
Co Stompe 6-2 Andy Hamilton
[NAME] 6-4 Kev Dowling
[NAME] 6-5 Dennis Priestley
[NAME] 6-2 Mark Lawrence
[NAME]
[NAME] 6-5 Brendan Dolan
[NAME] 6-3 Denis Ovens
[NAME] 6-1 Russell Mason
Losers £300
Fourth Round
Adrian Lewis 6-2 [NAME]
[NAME] 6-3 Mark Frost
[NAME]
[NAME]
[NAME] 6-4 Co Stompe
[NAME] 6-5 [NAME]
[NAME] 6-5 Barrie Bates
[NAME] 6-0 [NAME]
Losers £400
Quarter-Finals
[NAME] 6-5 Adrian Lewis
[NAME] Jelle Klaasen
[NAME] 6-5 Andy Jenkins
[NAME] 6-1 [NAME]
Losers £800
Semi-Finals
[NAME]
[NAME] 6-1 Kevin Painter
Losers £1,500
Final
[NAME] 6-1 [NAME]
Spreadsheet: 107773d1304936379-please-help-i-have-problem-with-tangency-portfolio-and-utility-book12
Sheet: ws10 (1)

m1 | 0.1 |  | Tangency portfolio
m2 | 0.15 |  | excess return | weight
sig1 | 0.2 |  | 0.05
sig2 | 0.25 |  | 0.09999999999999999
rho | 0.3
rf | 0.05 |  | mu | sig
 |  |  | 0.05 | 0
k | 1-k | mup | sigp
0 | 1
0.1 | 0.9
0.2 | 0.8
0.3 | 0.7
0.4 | 0.6
0.5 | 0.5
0.6 | 0.4
0.7 | 0.3
0.8 | 0.2
0.9 | 0.09999999999999998
1 | 0
Spreadsheet: 729725d1619288399-how-many-ids-in-column-a-match-two-criteria-in-column-b-free-and-paid
Sheet: Sheet1

User ID | Account type
23 | Free
24 | Free
25 | Free
25 | Paid
23 | Free
24 | Free
25 | Paid
23 | Paid
24 | Free
Spreadsheet: 101942d1300011017-subtraction-from-2-cells-weekly_blanket_wash_consumption_master_2
Sheet: wk 4

Blanket Wash / Materials. |  |  |  |  |  |  |  |  |  | BLANKET WASH / BLANKETS
 |  | Week | 8250102    514915-153-716
Date | 2011-02-25 00:00:00 | 4
Clean |  |  | Litres | Dirty |  |  |  | Litres
Stainless Tank |  |  |  | Renzmann wash / mach
1,000 Blue Tank ( 11 ) |  |  |  | Holding Stainless/Tank
Total Litres |  |  | 0 | 2nd holding tank(plastic)
Spare  Tanks  (18)
Total |  |  | 0 | Total |  |  |  | 0 |  | Filtered Blanket wash
 |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  | Tank Changed
Blankets- 595011. 153716 |  |  |  |  | Foils- 514915. 153716
Blue  Graffity |  |  |  | 0 |  | Foils
8251506 |  |  |  |  | 0 |  |  |  |  | DATE | 2011-02-25 00:00:00 |  |  | week | 4
Blue Vulcan Editor 20s |  |  |  | 16 |  | .18 RB Foils | 0 |  |  | WEEKLY BLANKET WASH USAGE
8251507 |  |  |  |  | 16 | 8252002 |  | 0 |  | DATE | CLEAN | DIRTY | TANK | DATE ON | TOTAL
28 up week 25 |  |  |  |  |  |  |  |  |  | 2011-02-18 00:00:00 | 0 | 0 | 0 |  | 0
Green Vulcan202Tower Blankets |  |  |  | 25 |  | .16 RB Foils | 0 |  |  | 2011-02-25 00:00:00 |  |  | 0 |  | 0
8251500 |  |  |  |  | 25 | 8252001 |  | 0 |  | TOTALS | 0 | 0 | 0
20 up week 25 |  |  |  |  |  |  |  | 30 in wk19
Green Vulcan 202 Newsman 40 |  |  |  | 44 |  | .18 RB Tower | 0 |  |  | TOTAL USED |  | DATE | 2011-02-25 00:00:00 |  | 0 | WEEK 1
8251508 |  |  |  |  | 44 | 8251511 |  | 0 |  |  |  |  |  |  |  | WEEK 2
30 up week 25 |  |  |  |  |  |  |  |  |  | SPARE TANK 1000 |  |  |  |  |  | WEEK 3
Brown Day International |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | WEEK 4
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WEEK 5
[NAME] |  |  |  |  |  | Aim Pre Packs |  |  |  |  |  |  |  |  | MONTH | TOTAL | 0
8251502   514940   153-716 |  |  |  |  |  | 8250101
 |  |  |  |  |  |  |  | 0 |  | CHEMPORT FOUNT SOL |  |  |  | AIM pre packs
Position A |  |  |  |  | Blanketwash Additives
 |  |  |  |  | 514915-153716 |  |  |  |  | DATE | TOTAL | USED |  |  | TOTAL | USED
Position B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 bought up
 |  |  |  |  | 8251501 | Parabar |  | 3 litres wk
Position C |  |  |  |  | 8250805 | Isowash |  | 50 litres wk
Spare |  |  |  |  | 8251825 | Surfactant |  | 8 litres wk
Total |  | 0 |  |  | xl  Pressroom/reports/originals/blanket wash totals
 |  |  |  |  |  |  |  |  |  | Total |  | 0 |  | Total |  | 0
xl  Pressroom/reports/originals/blanket wash totals
Spreadsheet: 124206d1318242567-find-max-time-between-dates-daddy-injury
Sheet: Sheet1

Date | Injury | Department |  |  | Injury | [NAME] free
2007-01-01 00:00:00 | LTI | Mining |  |  | LTI | 107
2007-01-01 00:00:00 | RWI | Mining |  |  | RWI | 56
2007-01-12 00:00:00 | MTI | Mining |  |  | MTI | 130
2007-02-12 00:00:00 | RWI | Mining
2007-02-23 00:00:00 | RWI | Geology
2007-02-25 00:00:00 | RWI | Mining
2007-03-04 00:00:00 | RWI | Mining
2007-03-21 00:00:00 | RWI | Mining |  |  | Injury | LTI | RWI | MTI
2007-04-18 00:00:00 | LTI | Mining |  |  | Dept
2007-04-21 00:00:00 | RWI | Geology |  |  | Mining | 107 | 112 | 130
2007-04-28 00:00:00 | RWI | Mining |  |  | Geology | 225 | 102
2007-05-05 00:00:00 | LTI | [NAME] |  |  | [NAME] | 139 | 156
2007-05-07 00:00:00 | LTI | Mining |  |  | Engineering |  | 132
2007-05-12 00:00:00 | RWI | Engineering |  |  | Projects |  |  | 216
2007-05-22 00:00:00 | MTI | Mining |  |  | HR & Admin | 245 |  | 226
2007-05-29 00:00:00 | MTI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-03 00:00:00 | MTI | Mining
2007-06-06 00:00:00 | RWI | [NAME]
2007-07-17 00:00:00 | MTI | Mining
2007-08-01 00:00:00 | LTI | Mining
2007-08-01 00:00:00 | RWI | Geology
2007-08-05 00:00:00 | MTI | Projects
2007-08-14 00:00:00 | LTI | Geology
2007-08-15 00:00:00 | MTI | HR & Admin
2007-09-03 00:00:00 | LTI | HR & Admin
2007-09-20 00:00:00 | RWI | Geology
2007-09-21 00:00:00 | LTI | Mining
Spreadsheet: 721992d1614978874-sumifs-formula-msk8tlyn-example_1
Sheet: Sheet2

Average for Total Services By Day
 | Delivery | Pickup | Return | Cancel
Day
Swing
Night
Spreadsheet: 853759d1703723693-function-for-permutation-and-combination-permutation-combination-dj
Sheet: Sheet1

Given numbers |  |  | function results Permutation & Combination Example |  |  |  |  |  |  |  |  |  | Example 2, if Col A data is replace by 2, 4,6,8
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  | 3 |  |  | Note |  |  |  |  |  |  |  |  | 4
5 |  | 5 |  |  | Small to large only, 1,3 if OK NOT 3,1 |  |  |  |  |  |  |  |  | 6
7 |  | 7 |  |  | Given number to change |  |  |  |  |  |  |  |  | 8
9 |  | 9 |  |  | Given  number , goes maximum up to two digits
 |  | 1,3
 |  | 1,5 |  |  | The way to go for a more mathematical solution:
 |  | 1,7 |  |  |  | 3,1 | 5,1 | 7,1 | 9,1
 |  | 1,9 |  |  | 1,3 | 3,3 | 5,3 | 7,3 | 9,3
 |  | 3,5 |  |  | 1,5 | 3,5 | 5,5 | 7,5 | 9,5
 |  | 3,7 |  |  | 1,7 | 3,7 | 5,7 | 7,7 | 9,7
 |  | 3,9 |  |  | 1,9 | 3,9 | 5,9 | 7,9 | 9,9
 |  | 5,7
 |  | 5,9
 |  | 7,9 |  |  | One cell solution:
 |  | 1,3,5
 |  | 1,3,7
 |  | 1,3,9
 |  | 1,5,7
 |  | 1,5,9
 |  | 1,7,9
 |  | 3,5,7
 |  | 3,5,9
 |  | 3,7,9
 |  | 5,7,9
 |  | 1,3,5,7
 |  | 1,3,5,9
 |  | 1,3,7,9
 |  | 1,5,7,9
 |  | 3,5,7,9
 |  | 1,3,5,7,9
Spreadsheet: 215849d1361515165-searching-for-a-value-in-multiple-sheets-fame1
Sheet: SN2(040912-21)

3.067 | 3.02 | 3.123 | TIC | 37961 | 0.56 | 14519 | 0.59 | 2.61 |  | Cyclohexane, 1,1'-[1-(2,2-dimethylbutyl)-1,3-propanediyl]bis- (CAS) HEPTAN, 1,3-DICYCLOHEXYL-5,5-DIMETHYL-
3.172 | 3.123 | 3.23 | TIC | 18225 | 0.27 | 5798 | 0.23 | 3.14 | V | Patchouli alcohol
3.527 | 3.52 | 3.573 | TIC | 4718 | 0.07 | 2496 | 0.1 | 1.89 |  | Retinol, acetate (CAS) Vitamin A acetate
3.577 | 3.573 | 3.587 | TIC | 817 | 0.01 | 2361 | 0.1 | 0.35 | V | DI-2-BENZOTHIAZOLE DISULFANE
3.613 | 3.587 | 3.633 | TIC | 9136 | 0.13 | 4770 | 0.19 | 1.92 | V | Tetradecanenitrile (CAS) Tetradecanonitrile
3.65 | 3.633 | 3.667 | TIC | 5420 | 0.08 | 4067 | 0.16 | 1.33 | V | Koiganal I
3.707 | 3.667 | 3.753 | TIC | 70116 | 1.04 | 32335 | 1.31 | 2.17 | V | methyl tetradecanoate
3.8 | 3.753 | 3.83 | TIC | 11119 | 0.16 | 3879 | 0.16 | 2.87 | V | 2-(METHYL-D3)-CYCLONONANONE
3.957 | 3.83 | 3.973 | TIC | 27274 | 0.4 | 4644 | 0.19 | 5.87 | V | (4aR,9aS,9bR)-4a,6,6,9a-tetramethyl-trans-perhydroindano[2,1-c]pyran
3.99 | 3.973 | 4.007 | TIC | 6701 | 0.1 | 3342 | 0.13 | 2.01 | V | 9-Oxa-bicyclo[3.3.1]nonane-2,7-diol
4.057 | 4.007 | 4.11 | TIC | 15826 | 0.23 | 2290 | 0.09 | 6.91 | V | 2-Cyclopenten-1-one, 3,4-dihydroxy-5-(3-methyl-2-butenyl)-2-(3-methyl-1-oxobutyl)-4-(4-methyl-1-oxo-3-pentenyl)-
4.123 | 4.11 | 4.13 | TIC | 3739 | 0.06 | 3851 | 0.16 | 0.97 | V | Androst-11-en-17-one, 3-formyloxy-, (3.alpha.,5.alpha.)-
4.137 | 4.13 | 4.14 | TIC | 2531 | 0.04 | 4949 | 0.2 | 0.51 | V | 4,5-Dihydro-4,4-tetradecamethylene-2-phenyl-1,3-oxazin-6-one
4.204 | 4.14 | 4.237 | TIC | 41584 | 0.61 | 8493 | 0.34 | 4.9 | V | Nonahexacontanoic acid, methyl ester (CAS) METHYL N-NONAHEXACONTANOATE
4.323 | 4.237 | 4.383 | TIC | 139393 | 2.06 | 47465 | 1.92 | 2.94 | V | 5-Octadecenoic acid, methyl ester (CAS)
Spreadsheet: 118765d1314000471-if-statement-to-compare-times-variation_calc
Sheet: Sheet1

1st Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
2nd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
3rd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 5-2T

 | Section 5: Fuel Consumption
 | Table 5-2Trend:  Fuel Cost by Fuel Type by Year
 | Fuel Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Gasoline | 704701673 | 939024357 | 1046695349 | 1032343383 | 1027624612
 | Diesel | 163984575 | 213360941 | 248901198 | 230639155 | 215654629
 | [NAME] (B100) | 15154 | 592 | 211104 | 772544 | 1269486
 | [NAME] ([NAME]) | 17477704 | 19255051 | 24822915 | 20040238 | 18586916
 | CNG | 1098131 | 1178322 | 1116769 | 876725 | 1265507
 | Electric | 13539 | 387128 | 468852 | 273744 | 315374
 | Ethanol/E-85 | 23071572 | 26392840 | 38496662 | 50545128 | 63169505
 | LNG | 69933 | 570 | 648 | 112 | 5036
 | LPG | 341874 | 292968 | 477127 | 359107 | 948317
 | Hydrogen | 14657 | 20509 | 17513 | 4118 | 3741
 | Grand Total: | 910788812 | 1199913278 | 1361208137 | 1335854254 | 1328843123
Spreadsheet: richard_ring__31563__SMALLC&I2001
Sheet: Jan

 | IN HOUSE REPORTING |  |  |  |  | SMALL C & I
 | [NAME] | 2001-01-01 00:00:00
 | [NAME] | 2001-01-31 00:00:00
 | Prepared By: | [NAME]  [PHONE] | 713 . 632. 8553
 | Clean Choice 20*
 | OPCOACCOUNTNUM | SAPARDATE | METER | RATECODE | Text20 | PESACCOUNTNUM | SERVICEPERIODEND | TOTALUSAGE
 | XNL9666802 | 1/29/01 6:56:59 PM | 5N6939 | A  1 | Linda & Chris  Craiker | 2000121700 | 1/25/01 | 1524
 | GJR5552004 | 1/27/01 2:27:45 PM | 56T256 | A  1 P | [NAME] | 2000128239 | 1/6/01 | -1948
 | GJR5552004 | 1/24/01 7:23:51 PM | 56T256 | A  1 P | [NAME] | 2000128239 | 1/6/01 | 1948
 | GJR5552004 | 1/29/01 6:56:59 PM | 56T256 | A  1 P | [NAME] | 2000128239 | 1/6/01 | 1948
 |  |  |  |  |  |  | 4
 | Clean Choice 50
 | Clean Choice 100*
 | RNL5856402 | 1/2/01 12:35:11 PM | N95311 | A  1 | Ira  Wolk | 2000591490 | 12/19/00 | 1466
 | RNL5856402 | 1/27/01 2:27:45 PM | N95311 | A  1 | Ira  Wolk | 2000591490 | 1/18/01 | -1256
 | RNL5856402 | 1/24/01 7:23:51 PM | N95311 | A  1 | Ira  Wolk | 2000591490 | 1/18/01 | 1256
 | RNL5856402 | 1/29/01 6:56:59 PM | N95311 | A  1 | Ira  Wolk | 2000591490 | 1/18/01 | 1256
 | QJQ6059504 | 1/27/01 2:27:45 PM | 8B8006 | A  1 | [NAME] | 2000591628 | 1/17/01 | -975
 | QJQ6059504 | 1/24/01 7:23:51 PM | 8B8006 | A  1 | [NAME] | 2000591628 | 1/17/01 | 975
 | QJQ6059504 | 1/29/01 6:56:59 PM | 8B8006 | A  1 | [NAME] | 2000591628 | 1/17/01 | 975
 | PVP3829300 | 1/27/01 2:27:45 PM | B45322 | A  1 | [NAME] | 2000591724 | 1/17/01 | -879
 | PVP3829300 | 1/24/01 7:23:51 PM | B45322 | A  1 | [NAME] | 2000591724 | 1/17/01 | 879
 | PVP3829300 | 1/29/01 6:56:59 PM | B45322 | A  1 | [NAME] | 2000591724 | 1/17/01 | 879
 | KHM5342401 | 1/27/01 2:27:45 PM | 5701J6 | A  1 | Diane L Cross | 2000592931 | 1/10/01 | -846
 | KHM5342401 | 1/24/01 7:23:51 PM | 5701J6 | A  1 | Diane L Cross | 2000592931 | 1/10/01 | 846
 | KHM5342401 | 1/29/01 6:56:59 PM | 5701J6 | A  1 | Diane L Cross | 2000592931 | 1/10/01 | 846
 | SNL6983001 | 1/27/01 2:27:45 PM | 99490T | A  1 P | [NAME] | 2000459025 | 1/19/01 | -3517
 | SNL6983001 | 1/24/01 7:23:51 PM | 99490T | A  1 P | [NAME] | 2000459025 | 1/19/01 | 3517
 | SNL6983001 | 1/29/01 6:56:59 PM | 99490T | A  1 P | [NAME] | 2000459025 | 1/19/01 | 3517
 | CRN3855302 | 1/5/01 3:49:27 PM | 87043T | A  1 P | [NAME] | 2000592464 | 1/3/01 | 365
 | YVT2718676 | 1/5/01 3:49:27 PM | 3T9721 | AG 1A | [NAME] | 2000399968 | 12/27/00 | 39
 |  |  |  |  |  |  | 18
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-11-30 00:00:00 |  | 1497337.92
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2001-12-31 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-11-30 00:00:00 |  | 275313.72
2001-12-31 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 363548 | 117857 | 173271
2001-11-30 00:00:00 |  | 811403.49
2001-12-31 00:00:00
500241
500391 | 10784
500392 | 2743
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 598784d1542719928-help-with-sumif-or-if-book8
Sheet: Sheet1

94 | ﻿94 | 2 |  |  | D1 sums if 94 shows only once in A:A
4 | 1 | 2
13 | 2 | 2
98 | 3 | 2 | 2 |  | How do I get cell D1 to SUM cell C1 once or multiple times if cell B1 matches once or multiple times in Column A (94 shows 3 times)
99 | 4 | 2 | 2
42 | 5 | 2
3 | 6 | 2
38 | 7 | 2 | 2
94 | 8 | 2
7 | 9 | 2
15 | 10 | 2
65 | 11 | 2
12 | 12 | 2 | 2
78 | 13 | 2 | 2
96 | 14 | 2
94 | 15 | 2 | 2
22 | 16 | 2
25 | 17 | 2
 | 18 | 2
 | 19 | 2
 | 20 | 2
 | 21 | 2
 | 22 | 2 | 2
 | 23 | 2
 | 24 | 2
 | 25 | 2 | 2
 | 26 | 2
Spreadsheet: 63433d1264357718-vlookup-using-skip-column-temp_avk
Sheet: LIST

code | NAME | CITY | DISTRICT
 | A TO Z ENGINEERING | ABCD | DCBA
 | A.A.ENARGY | BCDE | EDCB
 | A.D.C.C.PVT LTD. | CDEF | FEDC
 | A.D.STONE CRUSHER | DEFG | GFED
0001 | A.A. AUTOMOBILES
0002 | KUSUMBE A.D.
0003 | A.G.BIOTECH
0003 | SANGAM TRANSPORT & MATERIAL SUPPLIER
0004 | A.L.SUDHERSHAN CONSTRUCTION CO
0006 | A.M.S.E. (G.S.I.) | #N/A
Spreadsheet: 139154d1328107541-excel-2007-getting-data-from-other-worksheets-2011-stats
Sheet: Drivers Standings

Pos | Driver | Team | Nation | Wins | Total | MAL | CHN | TUR | ESP | MON | CAN | EUR | GBR | GER | HUN | BEL | ITA | SIN | JPN | KOR | IND | ABU | BRA
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | Sebastien Buemi
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | Pastor Maldonado
20 | [NAME]
21 | Jarno [NAME]
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | Narain Karthikeyan
27 | [NAME]
28 | Karun Chandhok