tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__16118__1_23_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 210 | 15.5 | 17.5 | 79.1 | 89.3 | 11.12 | 2002-01-23 10:12:00
 | NG H2 | 210 | 31.5 | 33.5 | 62.8 | 66.8 | 8.56 | 2002-01-23 10:12:00
 | NG J2 | 220 | 36.5 | 38.5 | 51.3 | 54.1 | 7.29 | 2002-01-23 10:12:00
 | NG K2 | 225 | 42 | 44 | 47.2 | 49.4 | 6.83 | 2002-01-23 10:12:00
 | NG M2 | 235 | 48 | 50 | 44.5 | 46.3 | 6.71 | 2002-01-23 10:12:00
 | NG N2 | 240 | 55.5 | 58 | 45.7 | 47.8 | 7.05 | 2002-01-23 10:12:00
 | NG Q2 | 245 | 62 | 64 | 45.8 | 47.3 | 7.17 | 2002-01-23 10:12:00
 | NG U2 | 245 | 66 | 69 | 45.2 | 47.3 | 7.12 | 2002-01-23 10:12:00
 | NG V2 | 250 | 73 | 76 | 46.2 | 48.1 | 7.41 | 2002-01-23 10:12:00
 | NG X2 | 275 | 85.5 | 88.5 | 46.5 | 48.1 | 8.18 | 2002-01-23 10:12:00
 | [NAME] | 295 | 96 | 99.5 | 46.6 | 48.3 | 8.8 | 2002-01-23 10:12:00
 | NG F3 | 305 | 105.5 | 109.5 | 47.5 | 49.4 | 9.29 | 2002-01-23 10:12:00
 | NG H3 |  |  |  |  |  |  | 2002-01-22 14:46:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 52997d1252922672-sum-total-from-different-sheets-given-certain-criteria-copy-of-rewards
Sheet: Total

 |  |  |  | Consultant Totals
Total Rewards Submitted | 853 |  |  | Consultant Name | AB # | Total Rewards Submitted
 |  |  |  | Marietjie | ABMH452
 |  |  |  | Alicia | EXAT130
 |  |  |  | [NAME] | ABLP420
 |  |  |  | [NAME] | ABBT137
 |  |  |  | [NAME] | EXBM282
 |  |  |  | [NAME] | ABCW433
 |  |  |  | Bernard | ABBC144
 |  |  |  | Carol | EXCM134
 |  |  |  | [NAME] | ABDV180
 |  |  |  | [NAME] | ABFH909
 |  |  |  | Glodean ([NAME]) | EXGM103
 |  |  |  | [NAME] | ABMMBKY
 |  |  |  | [NAME] | EXJT108
 |  |  |  | [NAME] | ABJO114
 |  |  |  | Kamo C | EXKM193
 |  |  |  | [NAME] | ABCMA2K
 |  |  |  | [NAME] | ABKMA78
 |  |  |  | Lehlohonolo | EXLL119
 |  |  |  | Lettah | EXRS129
 |  |  |  | Lindiwe Faith | ABFM329
 |  |  |  | [NAME] | [NAME]
 |  |  |  | Marinda | ABMP781
 |  |  |  | [NAME] | EXML129
 |  |  |  | Musiwalo [NAME] | EXMT148
 |  |  |  | Veronique | EXVL104
 |  |  |  | [NAME] | ABNMADZ
 |  |  |  | Matshidiso | EXMK126
 |  |  |  | Michelle | ABMD419
 |  |  |  | Mpho | ABMMBAO
 |  |  |  | Monchu | ABMN629
 |  |  |  | Naledi G | EXNK128
 |  |  |  | [NAME] | EXSK133
 |  |  |  | [NAME] | ABTR217
 |  |  |  | Noleen | EXNS241
 |  |  |  | Nozipho | EXNM105
 |  |  |  | Sibusiso | EXSS139
 |  |  |  | Nyadzawela Patricia | ABNMAD3
 |  |  |  | Phindile | ABPN476
 |  |  |  | [NAME] | ABPMA7M
 |  |  |  | Rachel | ABRM956
 |  |  |  | Roswil | EXRK111
 |  |  |  | Rowena | ABRS621
 |  |  |  | Shannon | ABSW334
 |  |  |  | Suzan | ABSD305
 |  |  |  | Theresa | EXTK127
 |  |  |  | Tsholofelo | ABTM617
 |  |  |  | [NAME] | EXBR103
 |  |  |  | Zenobia | EXZR100
 |  |  |  | TOTAL |  | 0
Spreadsheet: 141793d1329452457-transposing-data-transposedata
Sheet: Sheet1

1
2
3
4
5
6
15
20
25
35
46
78
15
98
87
Spreadsheet: kevin_hyatt__19599__Derailment_Summary
Sheet: Nov. Train derailment vols.

Transwestern Pipeline Company
November 2000
Train Derailment - Volumes Calculation for Fuel
 |  | Prior Week |  | Actual Daily |  | Displaced
 |  | Average Daily |  | Commodity | Displaced | 4-Day Daily
 |  | [NAME] |  | [NAME] | [NAME] | Average
West  :   1090
2000-11-01 00:00:00 |  | 1090 |  | 634.451
2000-11-02 00:00:00 |  | 1090 |  | 833.2839999999999
2000-11-03 00:00:00 |  | 1090 |  | 816.27
2000-11-04 00:00:00 |  | 1090 |  | 821.3410000000001
[NAME] to Blanco  :  624
2000-11-01 00:00:00 |  | 624 |  | 522.302
2000-11-02 00:00:00 |  | 624 |  | 500.922
2000-11-03 00:00:00 |  | 624 |  | 523.411
2000-11-04 00:00:00 |  | 624 |  | 567.788
San Juan to Thoreau
2000-11-01 00:00:00 |  |  |  |  | 100
2000-11-02 00:00:00 |  |  |  |  | 100
2000-11-03 00:00:00 |  |  |  |  | 100
2000-11-04 00:00:00 |  |  |  |  | 100
Thoreau to East
2000-11-01 00:00:00 |  |  |  |  | 100
2000-11-02 00:00:00 |  |  |  |  | 100
2000-11-03 00:00:00 |  |  |  |  | 100
2000-11-04 00:00:00 |  |  |  |  | 100
Spreadsheet: 57501d1257719357-summing-total-with-pushbutton-testtt4
Sheet: Total All

 | Surname | Forename | Gender | Class | Score A | Score B | Score C
 | Eight | [NAME] | G | RF | 7 | 7 | 7
 | Eight | [NAME] | G | RT | 7 | 7 | 7
 | Eight | [NAME] | G | 1A | 7 | 7 | 7
 | Eight | [NAME] | G | 1J | 7 | 7 | 7
 | Eleven | [NAME] | G | RF | 10 | 10 | 10
 | Eleven | [NAME] | G | RT | 10 | 10 | 10
 | Eleven | [NAME] | G | 1A | 10 | 10 | 10
 | Eleven | [NAME] | G | 1J | 10 | 10 | 10
 | Five | [NAME] | B | 2C | 4 | 4 | 4
 | Four | Devine | G | 2W | 4 | 4 | 4
 | Four | Devine | G | 3C | 4 | 4 | 4
 | Four | Devine | G | 3E | 4 | 4 | 4
 | Four | Devine | G | 4M | 4 | 4 | 4
 | Four | Devine | G | 4W | 4 | 5 | 4
 | Four | Devine | G | 5B | 4 | 4 | 4
 | Four | Devine | G | 5G | 4 | 4 | 4
 | Four | Devine | G | 6OK | 4 | 4 | 4
 | Four | Devine | G | 6L | 4 | 4 | 4
 | Nine | Simone | G | RF | 8 | 8 | 8
 | Nine | Simone | G | RT | 8 | 8 | 8
 | Nine | Simone | G | 1A | 8 | 8 | 8
 | Nine | Simone | G | 1J | 8 | 8 | 8
 | One | [NAME] | B | 2W | 1 | 1 | 1
 | One | [NAME] | B | 3C | 1 | 1 | 1
 | One | [NAME] | B | 3E | 1 | 1 | 1
 | One | [NAME] | B | 4M | 1 | 1 | 1
 | One | [NAME] | B | 4W | 1 | 1 | 1
 | One | [NAME] | B | 5B | 1 | 1 | 1
 | One | [NAME] | B | 5G | 1 | 1 | 1
 | One | [NAME] | B | 6OK | 1 | 1 | 1
 | One | [NAME] | B | 6L | 1 | 1 | 1
 | Seven | Jojo | G | 2C | 6 | 6 | 6
 | Six | [NAME] | B | 2C | 5 | 5 | 5
 | Ten | Lilly | G | RF | 9 | 9 | 9
 | Ten | Lilly | G | RT | 9 | 9 | 9
 | Ten | Lilly | G | 1A | 9 | 9 | 9
 | Ten | Lilly | G | 1J | 9 | 9 | 9
 | Three | [NAME] | B | 2W | 3 | 3 | 3
 | Three | [NAME] | B | 3C | 3 | 3 | 3
 | Three | [NAME] | B | 3E | 3 | 3 | 3
 | Three | [NAME] | B | 4M | 3 | 3 | 3
 | Three | [NAME] | B | 4W | 3 | 3 | 3
 | Three | [NAME] | B | 5B | 3 | 3 | 3
 | Three | [NAME] | B | 5G | 3 | 3 | 3
 | Three | [NAME] | B | 6OK | 3 | 3 | 3
 | Three | [NAME] | B | 6L | 3 | 3 | 3
 | Twelve | [NAME] | B | RF | 11 | 11 | 11
 | Twelve | [NAME] | B | RT | 11 | 11 | 11
 | Twelve | [NAME] | B | 1A | 11 | 11 | 11
 | Twelve | [NAME] | B | 1J | 11 | 11 | 11
 | Two | [NAME] | G | 2W | 2 | 2 | 2
 | Two | [NAME] | G | 3C | 2 | 2 | 2
 | Two | [NAME] | G | 3E | 2 | 2 | 2
 | Two | [NAME] | G | 4M | 2 | 2 | 2
 | Two | [NAME] | G | 4W | 2 | 2 | 2
 | Two | [NAME] | G | 5B | 2 | 2 | 2
 | Two | [NAME] | G | 5G | 2 | 2 | 2
 | Two | [NAME] | G | 6OK | 2 | 2 | 2
 | Two | [NAME] | G | 6L | 2 | 2 | 2
Spreadsheet: 271025d1381785907-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: WE 19th Jan

Date | Order # | Company | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
20.02.14 | 102498 | Inverell Bearing Centre | 2x A54 belts
 |  | Area: | Stock
 |  | Req'd By: | Daryl
 |  | Code: | 1A
 |  | Item Cost: | 100000
 |  | Request No. | 102498
20.02.14 | 104978 | Sapphire City Steel & Pipe | 40m - 12mm deformed bar | 2x sheets - 2400x1200x2mm
 |  | Area: | CAPITAL: Job #29 | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1B
 |  | Item Cost: | 80000
 |  | Request No. | 104978
20.02.14 | 106798 | Norgen | 2x air cyliners per sample
 |  | Area: | BSF
 |  | Req'd By: | [NAME]
 |  | Code: | 1C
 |  | Item Cost: | 20000
 |  | Request No. | 106798
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Hall Manor

 |  |  |  |  |  |  | 2013 Hall Manor F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every Thursday opposite Bedford Deliveries.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 856619d1705819478-travel-total-calculation-calculator
Sheet: Calculator

Total trip days: | 8
Trip date: | Jan 20 - Jan 27
Trip location: | Virginia, Washington DC (also the cities of Alexandria, Falls Church and Fairfax, and the counties of Arlington and Fairfax, in Virginia; and the counties of Montgomery and [NAME] in Maryland)
Per diem rates
 | Lodging | M&IE
January 20* | $193 | $79 | Breakfast $18 / Lunch $20 / Dinner $36 / Incidentals $5
January 21 - 26 | $1158 | $474 | Breakfast $108 / Lunch $120 / Dinner $216 / Incidentals $30
January 27* | $193 | $79 | Breakfast $18 / Lunch $20 / Dinner $36 / Incidentals $5
Trip totals:
Lodging total:
Meals total:
Incidentals total:
*The amount received on the first and last day of travel equals 75% of total M&IE
Spreadsheet: 103201d1300988303-nested-if-functions-example-commission
Sheet: Sheet1

Sales Rep | Role | Region |  | Rev YTD | GP Quota | GP Achieved to Date | YTD % of Quota Achieved |  | Current Commission Rate | Weighted Avg Commission Rate | Total Commission Earned | Comm. Earned up to 100% | Earned with 1st Accelerator | Earned with 2nd Accelerator | Earned with 3rd Accelerator | Earned with 4th Accelerator | Earned with 5th Accelerator | Earned with 6th Accelerator |  |  | S | E | 1 | S | E | 2 | S | E | 3 | S | E | 4 | S | E | 5 | S | E | 6 |  | 1st Tier Acc | 2nd Tier Acc | 3rd Tier Acc | 4th Tier Acc | 5th Tier Acc | 6th Tier Acc
 |  |  |  | 8567263 | 4200000 | 5000000 |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 1 | 100 | 120 | 1.5 | 120 | 9999999 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 11b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 203 | 153 | 30 | 76 | 22 | 47 | 44 | 575
Cross-Currency Fixed-Fixed | 6 | 27 | 3 | 3 | 4 | 7 | 22 | 72
Cross-Currency Fixed-Float | 5 | 60 | 0 | 0 | 2 | 2 | 413 | 482
TOTAL
Spreadsheet: 472643d1469693856-sum-based-on-working-days-asset-creations-2016-upload
Sheet: Summary

 | Month | on or Before WD-5 | WD -4 to -3 | WD -1 to -2 | Total
 | 2016-01-01 00:00:00
 | 2016-02-01 00:00:00
 | 2016-03-01 00:00:00
 | 2016-04-01 00:00:00
 | 2016-05-01 00:00:00
 | 2016-06-01 00:00:00
 | 2016-07-01 00:00:00
 | 2016-08-01 00:00:00
 | 2016-09-01 00:00:00
 | 2016-10-01 00:00:00
 | 2016-11-01 00:00:00
 | 2016-12-01 00:00:00
 |  |  |  |  |  |  |  | Month | (All)
 |  |  |  |  |  |  |  | Row Labels | Count of Work Day
 |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  | 2 | 38
 |  |  |  |  |  |  |  | 3 | 54
 |  |  |  |  |  |  |  | 4 | 75
 |  |  |  |  |  |  |  | 5 | 51
 |  |  |  |  |  |  |  | 6 | 33
 |  |  |  |  |  |  |  | 7 | 62
 |  |  |  |  |  |  |  | 8 | 56
 |  |  |  |  |  |  |  | 9 | 19
 |  |  |  |  |  |  |  | 10 | 106
 |  |  |  |  |  |  |  | 11 | 32
 |  |  |  |  |  |  |  | 12 | 184
 |  |  |  |  |  |  |  | 13 | 151
 |  |  |  |  |  |  |  | 14 | 47
 |  |  |  |  |  |  |  | 15 | 148
 |  |  |  |  |  |  |  | 16 | 199
 |  |  |  |  |  |  |  | 17 | 70
 |  |  |  |  |  |  |  | 18 | 55
 |  |  |  |  |  |  |  | 19 | 8
 |  |  |  |  |  |  |  | 20 | 14
 |  |  |  |  |  |  |  | 21 | 6
 |  |  |  |  |  |  |  | Grand Total | 1419
Spreadsheet: 115068d1310701194-if_true-false-cicihk_if_truefalse
Sheet: Sheet

2011-02-15 00:00:00 |  | Results | CAS # |  |  |  |  |  |  | Result | Result | Result | Result | Result | Result
 |  |  | Units | CFU/100mL | CFU/mL | CFU/mL | CFU/mL | CFU/mL | CFU/mL
WO# | ID 1 | Date Sampled | LOR | 1 | 1 | 10 | 10 | 10 | 10
HK1100152 | NTT TAI PO DATA CENTRE | 2011-01-03 00:00:00 |  |  | <1 |  |  |  |  |  |  |  |  |  |  | [NAME]
HK1100153 | NTT TAI PO DATA CENTRE BLEED | 2011-01-03 00:00:00 |  | <1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
HK1100155 | NTT TAI PO DATA CENTRE | 2011-01-03 00:00:00 |  |  |  | <10 | <10 | <10 | <10 |  |  |  |  |  |  | [NAME]
HK1100247 | HARBOUR GRAND HOTEL CT | 2011-01-03 00:00:00 |  |  | 280000 |  |  |  |  |  |  |  |  |  |  | FAI
HK1100250 | OI TUNG CT | 2011-01-03 00:00:00 |  |  | 580 |  |  |  |  |  |  |  |  |  |  | FAI
HK1100251 | GLC CT | 2011-01-03 00:00:00 |  |  | 520 |  |  |  |  |  |  |  |  |  |  | FAI
HK1100252 | I-TECH TOWER CT | 2011-01-04 00:00:00 |  |  | 16000 |  |  |  |  |  |  |  |  |  |  | [NAME]
HK1100253 | I-TECH TOWER CT | 2011-01-04 00:00:00 |  | <1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: louise_kitchen__22775__final
Sheet: Sheet1

 | Texas Gas Trading |  |  | [NAME] |  | 4
 | East Gas Trading |  |  | [NAME] |  | 6
 | Central Gas Trading |  |  | [NAME] |  | 5
 | West Gas Trading |  |  | [NAME] |  | 9
 | Nymex Desk Trading |  |  | [NAME] |  | 6
 | Derivatives Marketing |  |  | [NAME] |  | 7
 | Gas Outsourcing |  |  | [NAME] |  | 4
 | Texas Gas Origination |  |  | [NAME] |  | 2
 | East Gas Origination |  |  | [NAME] |  | 2
 | Central Gas Origination |  |  | [NAME] |  | 2
 | West Gas Origination |  |  | [NAME] |  | 5
 | Ercot Power Trading |  |  | [NAME] |  | 3
 | Northeast Power Trading |  |  | [NAME] |  | 6
 | Midwest Power Trading |  |  | [NAME] |  | 3
 | Southeast  Power Trading |  |  | [NAME] |  | 4
 | East Options Trading |  |  | [NAME] |  | 3
 | East Power Services |  |  | [NAME] |  | 1
 | Ercot Power Origination |  |  | [NAME] |  | 3
 | Northeast Power Origination |  |  | [NAME] |  | 4
 | Midwest Power Origination |  |  | [NAME] |  | 3
 | Southeast Power Origination |  |  | [NAME] |  | 3
 | Southwest Power Trading |  |  | [NAME] |  | 3
 | California Power Trading |  |  | [NAME] |  | 4
 | Northwest Power Trading |  |  | [NAME] |  | 3
 | West Power Services |  |  | [NAME] |  | 1
 | Southwest Power Origination |  |  | [NAME] |  | 2
 | California Power Origination |  |  | [NAME] |  | 3
 | Northwest Power Origination |  |  | [NAME] |  | 3
 | Western Canada Gas and Power Trading |  |  | [NAME] |  | 8
 | Western Canada Gas and Power Origination |  |  | Phillip Milnthorp |  | 8
 | Eastern Canada Gas and Power Trading |  |  | [NAME] |  | 2
 | Eastern Canada Gas and Power Trading |  |  | [NAME] |  | 2
 | Leadership |  |  | Whalley/Kitchen |  | 2 |  | <------------ | Total Commercial
 | Gas Risk Management |  |  | [NAME] |  | 25
 | Gas Volume Management |  |  | [NAME] |  | 2
 | Gas Logistics |  |  | Superty |  | 20
 | Gas Settlements |  |  | [NAME] |  | 5
 | Power Risk Management |  |  | Furrow |  | 9
 | Power Volume Management |  |  | Furrow |  | 4
 | Power Logistics |  |  | Furrow |  | 12
 | Financial Settlements |  |  |  |  | 8
 | Power Settlements |  |  | Furrow |  | 3
 | Documentation & Databases |  |  | Gossett/Furrow |  | 23
 | Power Real Time |  |  | Belden/Presto |  | 20 |  | <------------ | Total Operations
 | IT Development, Operations and Maintenance |  |  | Webb |  | 117
 | IT Infrastructure |  |  | Rub |  | 58
 | EOL Support |  |  | Forster |  | 29
 | Admins for IT |  |  |  |  | 5 |  | <------------ | Total IT and EOL
 | Accounting, Transaction Support |  |  | [NAME] |  | 42
 | Cash Operations |  |  | [NAME] |  | 6
 | Tax |  |  | [NAME] |  | 2 |  | <----------- | Total Accounting
 | Admins for Houston Commercial |  |  |  |  | 11
 | Admins for Portland Commercial |  |  |  |  | 4
 | Regulatory Affairs |  |  | [NAME] |  | 8
 | Fundamentals |  |  | Gaskill/Will |  | 32
 | Structuring |  |  | Aucoin |  | 3
 | Weather |  |  | [NAME] |  | 5
 | Credit |  |  | Bradford |  | 12
 | Market Risk |  |  | Port |  | 3
 | Research |  |  | Port |  | 2
 | HR |  |  | [NAME] |  | 9
 | Legal |  |  | [NAME] |  | 18 |  | <----------- | [NAME]
 | Canada Support |  |  | [NAME] |  |  | 30 | <---------- | Total Canada Support
Spreadsheet: 70923d1271683853-time-calculations-example
Sheet: Data

Ticket No | Assignment | Time | MyTime | CustTime | Remarks
MyTicket1 | CustQueue0 | 2004-03-17 20:19:22 | 0 | 0 | The ticket has entered the queue…Customer's stop watch starts
MyTicket1 | MyQueue0 | 2004-03-17 20:20:01 | 0 | 0.0004513888852670789 | The ticket is assigned to me. Time spent in customer's queue is calculated as diference between C3 and C2 (by seeing the change in values in column B)
MyTicket1 | MyQueue1 | 2004-03-18 12:16:31 | 0 | 0 | The ticket is still in my queue
MyTicket1 | MyQueue2 | 2004-03-18 12:16:35 | 0 | 0 | The ticket is still in my queue
MyTicket1 | CustQueue1 | 2004-03-18 12:16:49 | 0.664444444446417 | 0 | Pushed the ticket into customer's queue. Therefore, my time spent is difference between C6 (Changed B6) and [NAME] (Since it has been in my queue thus far)
MyTicket1 | MyQueue3 | 2004-03-18 12:28:00 | 0 | 0.007766203700157348 | The ticket is assigned back to me. Time spent in customer's queue is diference between C7 and C6 (B7 has changed to MyQueue* from CustQueue*)
MyTicket1 | CustQueue2 | 2004-03-18 12:34:14 | 0.004328703704231884 | 0
MyTicket1 | CustQueue2 | 2004-04-08 16:43:31 | 0 | 0
MyTicket1 | MyQueue4 | 2004-04-08 16:43:45 | 0 | 21.17327546296292
MyTicket1 | MyQueue5 | 2004-04-13 10:49:09 | 0 | 0
MyTicket1 | CustQueue3 | 2004-04-13 10:49:11 | 4.753773148149776 | 0
MyTicket1 | CustQueue3 | 2005-03-01 13:09:23 | 0 | 0
 |  |  | 5.422546296300425 | 21.18149305554834 | For each ticket, I'd like to see the total time I spent and the time that the customer spent (in columns against the ticket number). I could get the summary against a ticket out of a pivot table if I could make the individual calculations against each row above accurately.
Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #13. 23 June 2017

Paychecks Dated 23 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 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 2017-06-05 00:00:00 | 2017-06-05 00:00:00 | 2017-06-06 00:00:00 | 2017-06-06 00:00:00 | 2017-06-07 00:00:00 | 2017-06-07 00:00:00 | 2017-06-08 00:00:00 | 2017-06-08 00:00:00 | 2017-06-08 00:00:00 | 2017-06-09 00:00:00 | 2017-06-09 00:00:00 | 2017-06-11 00:00:00 | 2017-06-12 00:00:00 | 2017-06-13 00:00:00 | 2017-06-13 00:00:00 | 2017-06-13 00:00:00 | 2017-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-16 00:00:00
Job |  |  |  |  |  |  |  | > | 40 | > | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T&M |  | T&M |  |  | T&M | T&M | T&M |  | T&M | T&M
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  | X |  | X |  |  |  | X |  |  | X | X |  | X |  | X | X | X | X | X | X | X
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | X |  | X | X | X |  | X |  |  |  | X |  | X
3 | Shop,  Non-Billable |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | X
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 8.25 |  |  |  | 9.25 |  |  | 5.5 | 2.5 |  | 8.5 |  | 5.75 | 0 | 8.75 | 5.5 | 2.5 | 4.5 | 4
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2.5
 | Hours-Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0
 | Hours-Overtime
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 7.5 |  |  |  | 8 | 5 | 2 | 4.5 | 3.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 8.25 | 7 | 8 |  | 6 |  |  |  | 1.75
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75
 | Hours-Regular
 | Hours-Overtime |  |  |  |  |  |  |  |  |  |  |  | , |  |  |  |  |  |  |  |  |  |  | 1
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail |  |  |  |  |  |  |  |  |  |  |  | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
Sales
 | n/a | 0
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 38
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: CE-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 | 118310530 | 506294564
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 50611404 | 217669162
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 168921934 | 723963726
 | Purchases:
6 |  | 3rd Party / Inter Enron | -125740421 | -536704709 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -43573513 | -186858667
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 178409 | 718499
 | Total Purchases: |  | -169135525 | -722844877
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 92584 | 401217
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -35514 | -119517 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 57070 | 281700
 | 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:
21 | Shrinkage:
22 | UA4: |  | 156521 | -663649.04
23 | Fuel: |  | -178409 | -718499
 | Transport Expense:
24 |  | Commodity |  | -212416.1466000001
25 |  | Demand |  | -1777260
 | Total Transport Expense: |  | 0 | -1989676.1466
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  | 11822013.1623
31 |  | Prior Month Book Balance |  | -15976612
 |  | Total MTM Income | 0 | -4154598.837699998
32 |  | Prudency
33 |  | Financial Liquidations |  | 7700994
34 |  | Originations |  | 172538.1
35 |  | Broker Fees |  | 0
36 |  | Asset Group Demand Charges |  | 0
37 |  | [NAME] |  | 0
38 |  | Interdesk Charges |  | 1016486
39 |  | Canada |  | 0
40 |  | Miscellaneous |  | 333398
 |  | TOTAL INTRA-MTH |  | 0