tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__6611__HPL-MAR
Sheet: Feb 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From | From | From | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-03-01 00:00:00 |  |  |  | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points
981258 | Industrial Tier 1 & 2 | CHAMPIONS | 0 | 0 | 0 | 0
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000 | 4000 | 4000 | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 25000 | 25000 | 25000 | 60000
Total  Midcon
PAYBACK |  |  | 0 | 0 | 0 | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910 | 910 | 910 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | existing | NGMS 308 | 10000 | 10000 | 10000 | 10000
016-41991-306 | Trans 6- Silsbee |  | 250 | 250 | 250 | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0 | 0 | 0 | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90 | 90 | 90 | 90
016-41991-311 |  | CNG | 250 | 250 | 250 | 250
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000 | 21000 | 21000 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7500 | 7500 | 7500 | 7500
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 2000 | 2000 | 2000 | 2000
016-41991-306 | VA Hospital | VA Hosp | 500 | 500 | 500 | 500
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000 | 4000 | 4000 | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000 | 8000 | 8000 | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800 | 2800 | 2800 | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 500 | 500 | 1000 | 1000
016-41991-301 | Trans 9 -Woodlands |  | 2500 | 2500 | 4000 | 4000
016-41991-301 | Trans 8 - Conroe |  | 0 | 0 | 0 | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 10000 | 10000 | 10000 | 10000
012-41991-203 |  | Firm Trsp
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | PG&E THOMPSONVILLE | 6296 | 10000 | 10000 | 10000 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000 | 5000 | 5000 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000 | 10000 | 10000 | 10000
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: Moss

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 89842d1289570684-conditional-formatting-book1
Sheet: Sheet1

Name | date1 | date2 | code | sta1 | sta2 | sta3 | sta4 | amount | date3 | [NAME] | code2 | [NAME] | overlap
AAA | 2010-10-20 00:00:00 | 2010-10-31 00:00:00 | RDO | R | D | Q | Q   85 | 36469 | 2010-10-27 00:00:00 | 2010-10-29 00:00:00 | HSP | 6531.51
BBB | 2010-10-20 00:00:00 | 2010-10-31 00:00:00 | RDO | R | D | Q | Q   85 | 36469 | 2010-10-08 00:00:00 | 2010-10-09 00:00:00 | HST | 7571.71 | 26th
CCC | 2010-10-05 00:00:00 |  | CCC |  | R | Q | Q   85 | 3 | 2010-10-08 00:00:00 | 2010-10-09 00:00:00 | HST | 7571.71 | 18th
DDD | 2010-10-01 00:00:00 | 2010-10-31 00:00:00 | RDO | R | D | Q | Q   85 | 35377 | 2010-10-08 00:00:00 | 2010-10-09 00:00:00 | HST | 7571.71 | 08th
FFF
GGG | 2010-10-01 00:00:00 | 2010-10-31 00:00:00 | CCC | E | D | Q | Q   85 | 98081.47 | 2010-10-28 00:00:00 | 2010-11-04 00:00:00 | MED | 104387.36
HHH
III | 2010-10-25 00:00:00 |  | PUL |  | R | P | P   52 | 763.54 | 2010-10-29 00:00:00 | 2010-11-02 00:00:00 | CTS | 105025.95
JJJ
KKK | 2010-10-01 00:00:00 | 2010-10-31 00:00:00 | RDO | R | D | P | P   52 | 22640 | 2010-10-06 00:00:00 | 2010-10-10 00:00:00 | HST | 5801 | 7th
Spreadsheet: john_arnold__15460__Book4
Sheet: Sheet1

 | Real Risk in BOLD
FUTURES POSITIONS
 | Cash-Oct | +10,000 | total
 | Nov-Mar | -13000 | total
 | Apr-Oct | -14000 | total
 | Cal 2 | -500 | per month
 | Cal 3 | +500 | per month
OPTION POSITIONS
 | Long |  |  |  | Short
1 | 500 | Dec-Jan 500 Put |  |  | 500 | Dec-Jan 700 Call
2 | 100 | Nov-Mar 350 Put
3 | 300 | Nov-Mar 300 Put |  |  | 300 | Nov 2-Mar 3 300 Put
4 | 15000 | Dec 300/250 Put Spread
5 | 500 | Cal 2 400 Put |  |  | 500 | Cal 2 600 Call
6 | 2000 | Mar 500 Call |  |  | 2000 | Feb 500 Call
7 | 1000 | [NAME] Call |  |  | 1000 | Feb 400 Call
8 |  |  |  |  | 100 | Cal 2 335 Straddle
9 | 10000 | Jan 400/350 Put Spread
10 | 1000 | Jan 400/300 Put Spread
11 | 1000 | Jan 400 Put
12 |  |  |  |  | 800 | Apr-Oct 350 Call
Goals today
1 | Buy 1/3 Apr-Oct position
2 | Liquidate 1/3 Cal 2/3 spread
3 | Buy 3000 Nov-Mar
Spreadsheet: 835748d1688783593-pmt-formula-incorporating-increased-yearly-payments-book1-dcshaw83-
Sheet: Sheet1

Pricinpal | 2000000 |  | Month | [NAME] | Payment | Balance
Annual Interest Rate | 0.12 |  | 1
Monthly Interest Rate |  |  | 2
Length of Loan in Years | 10 |  | 3
Length of Loan in Months |  |  | 4
Increase in Payments per Year | 0.06 |  | 5
Initial Payment | 10000 |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
 |  |  | 37
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41
 |  |  | 42
 |  |  | 43
 |  |  | 44
 |  |  | 45
 |  |  | 46
 |  |  | 47
 |  |  | 48
 |  |  | 49
 |  |  | 50
 |  |  | 51
 |  |  | 52
 |  |  | 53
 |  |  | 54
 |  |  | 55
 |  |  | 56
 |  |  | 57
 |  |  | 58
 |  |  | 59
 |  |  | 60
 |  |  | 61
 |  |  | 62
 |  |  | 63
 |  |  | 64
 |  |  | 65
 |  |  | 66
 |  |  | 67
 |  |  | 68
 |  |  | 69
 |  |  | 70
 |  |  | 71
 |  |  | 72
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
 |  |  | 88
 |  |  | 89
 |  |  | 90
 |  |  | 91
 |  |  | 92
 |  |  | 93
 |  |  | 94
 |  |  | 95
 |  |  | 96
 |  |  | 97
 |  |  | 98
 |  |  | 99
 |  |  | 100
 |  |  | 101
 |  |  | 102
 |  |  | 103
 |  |  | 104
 |  |  | 105
 |  |  | 106
 |  |  | 107
 |  |  | 108
 |  |  | 109
 |  |  | 110
 |  |  | 111
 |  |  | 112
 |  |  | 113
 |  |  | 114
 |  |  | 115
 |  |  | 116
 |  |  | 117
 |  |  | 118
 |  |  | 119
 |  |  | 120
Spreadsheet: 798139d1664321947-conditional-formatting-with-table-and-validation-visp-projects
Sheet: Robert Target Date

 | [NAME] | VISP Folder | 3/4 | HS | ECW Access | Training | P.M. | Target Date | SPI Order | SPI Arrived | SPI Config | [NAME] | Token arrived | [NAME] | EPCS - setup | Mic Order | Mic Access | Interface | Sig | S1 | S2 | S3 | Status
 | [NAME] | YES | PGE4550 | YES | YES | No | [NAME] | 2022-09-30 00:00:00 | YES | YES | No | YES | Yes | No | No | No |  | N/A | No | No | No | No | Pending
 | [NAME], MD | YES | HYA4774 | YES | YES | YES | [NAME] | 2022-09-30 00:00:00 | YES | YES | YES | YES | No | No | No | YES |  | No | YES | YES | No | No | Pending
 | [NAME], MD | YES | NAL4634 | YES | YES | No | [NAME] | 2022-09-30 00:00:00 | YES | No | No | YES | YES | No | No | No |  | No | No | No | No | No | Pending
 | [NAME], PA | YES | DHA4561 | YES | YES | No | [NAME] | 2022-09-30 00:00:00 | YES | YES | YES | YES | YES | YES | No | No |  | N/A | No | No | No | No | Pending
 | [NAME], MD | YES | [NAME] | N/A | YES | N/A | [NAME] | 2022-10-01 00:00:00 | YES | YES | YES | YES | No | No | No | No | YES | No | YES | N/A | N/A | N/A | Pending
 | [NAME], MD | YES | NRA5428 | YES | YES | No | Ana | 2022-10-01 00:00:00 | YES | YES | YES | YES |  |  | No | No |  |  |  |  |  |  | Pending
 | [NAME], MD | YES | CYO5769 | YES | YES | No | Ana | 2022-10-01 00:00:00 | YES | YES | YES | YES |  |  | No | No |  |  |  |  |  |  | Pending
 | [NAME], MD | YES | QSE4685 | YES | No | No | [NAME] | 2022-10-03 00:00:00 | YES | No | No | YES | No | No | No | YES |  | No | No | No | No | No | Pending
 | [NAME], MD | YES | [NAME] | YES | No | No | [NAME] | 2022-10-29 00:00:00 | YES | YES | No | YES | No | No | No | YES |  | No | No | No | No | No | Pending
 | Fritz Luma, NP | YES | MIT9089 | YES | No | No | [NAME] | 2022-10-31 00:00:00 | YES | YES | No | YES | YES | No | No | No |  | N/A | No | No | No | No | Pending
 | [NAME] APRN | YES | PUG7765 | N/A | No | N/A | [NAME] | 2022-11-01 00:00:00 | No | No | No | N/A | N/A | N/A | No | No |  | N/A | No | N/A | N/A | N/A | Pending
 | [NAME], MD | YES | HPO4789 |  | YES | No | Belkis | 2022-11-01 00:00:00 | No | No | No | No | No | No | No | No |  | No | No | No | No | No | Pending
 | [NAME] | N/A | QME8324 | YES | YES | YES | [NAME] | 2022-11-01 00:00:00 | YES | YES | YES | YES | YES |  | No | No | YES | N/A | YES | YES | N/A | N/A | Pending
 | [NAME], PA (Not for Visp) | N/A | [NAME] | N/A | YES | No | [NAME] | 2022-11-01 00:00:00 | YES | YES | YES | YES | No | No | No |  |  | N/A | YES | N/A | N/A | N/A | Pending
 | [NAME] (internal Med) | No | MUH4567 |  |  |  | [NAME] | 2022-11-01 00:00:00
Spreadsheet: 769330d1645473200-kindly-delete-this-please-export-detail-ms-test
Sheet: Country

CS Code # | Country | Port | CURRANCY
U | USA | MEMPHIS | US$
C | CANADA | PETERBOROUGH | US$
Z | CZECH REPUBLIC | PRAHA | US$
K | UNITED KINGDOM | LONDON | US$
J | JAPAN | TOKYO | US$
D | DENMARK | COPENHAGEN | US$
A | AUSTRALIA | MELBOURNE | US$
S | SWEDEN | MALMO | US$
N | NORWAY | OSLO | US$
P
A
Spreadsheet: 790916d1660060431-if-command-to-work-out-commissions-calc
Sheet: Sheet2

4 | 0 | 4000
5 | 4001 | 8000
6 | 8001 | 12000
7 | 12001 | 16000
8 | 16001 | 20000
9 | 20001 | 24000
10 | 24001 | 28000
11 | 28001 | 32000
12.5 | 32001+
Spreadsheet: 682133d1591911376-filter-with-multiple-partial-string-matches-book1
Sheet: Sheet1

ORIGINAL TABLE |  |  |  |  |  | FILTERED TABLE |  |  |  | Search for
Date | Account | Amount |  |  |  | Date | Account | Amount |  | trans
2018-07-31 00:00:00 | Pet Smart #109 | 47.1 |  |  |  |  | Transfer USD 33kjd0987 | 24.34 |  | wal
2018-08-01 00:00:00 | Pet Smart #34 | 120.95 |  |  |  | 2018-08-08 00:00:00 | Transfer USD AD2fdk0 | 13.62
2018-08-07 00:00:00 | Wal-Mart #1209 | 13.05 |  |  |  | 2018-08-31 00:00:00 | Transfer USD AD2fdk0 | 5.63
2018-08-08 00:00:00 | Wal-Mart #1203 | 12.09 |  |  |  | 2018-08-08 00:00:00 | Wal-Mart #1203 | 12.09
2018-08-08 00:00:00 | Transfer USD AD2fdk0 | 13.62 |  |  |  | 2018-08-29 00:00:00 | Wal-Mart #1203 | 8
2018-08-10 00:00:00 | Transfer USD 33kjd0987 | 24.34 |  |  |  | 2018-08-07 00:00:00 | Wal-Mart #1209 | 13.05
2018-08-17 00:00:00 | Global Electronics | 25
2018-08-24 00:00:00 | Samurai Electronics | 170.62
2018-08-24 00:00:00 | Electronic Surplus | 35.47
2018-08-27 00:00:00 | Incoming Wire Calmed Inc | 13.09
2018-08-29 00:00:00 | Wal-Mart #1203 | 8
2018-08-31 00:00:00 | Transfer USD AD2fdk0 | 5.63
2018-08-31 00:00:00 | Pet Smart #34 | 8.94
Spreadsheet: 757589d1638354405-want-to-add-additional-condition-to-if-and-countifs-function-query-if-countifs
Sheet: With Formula

Line | As Per | TIN | Trade Name | Remarks | GST |  | Match Portal and Books
1483 | PORTAL | 03BCWPK5798D9X4 | January |  | 950 |  | Remarks entered with =IF(COUNTIFS(C$2:C2,C2,F$2:F2,F2)=1,"Matched","Mismatch")
1484 | PORTAL | 03BCWPK5798D9X4 | January |  | 826 |  | If GST amounts of Portal and Books have a difference of +1/- or -1/- then also it is a match
2897 | Books | 03BCWPK5798D9X4 | Jan |  | 951 |  | If matched get "Matched"
2899 | Books | 03BCWPK5798D9X4 | Jan |  | 825 |  | If in Portal and not in Books "Books Not Entered"
561 | PORTAL | 06BBBCH0643R9XF | February |  | 4147.2 |  | If in Books and not in Portal "Not in Portal"
2162 | Books | 06BBBCH0643R9XF | Feb |  | 4147
1834 | Books | 06BBBCJ9939H9XW | March |  | 672
47 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 65.41
500 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 197
669 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 65.41
1268 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 130.82
3087 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 64.45
3088 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 65.41
3089 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED |  | 196.23
60 | PORTAL | 06BBCCV7495P9XV | April |  | 5454
356 | PORTAL | 06BBCCV7495P9XV | April |  | 13140
1716 | Books | 06BBCCV7495P9XV | APR |  | 5454.05
1847 | Books | 06BBCCV7495P9XV | APR |  | 13140
Spreadsheet: 711590d1609787879-countifs-ignoring-irrelevant-data-example
Sheet: Sheet1

 | Site A | CAT1
 | Site A | CAT2
 | Site A | CAT2
 | Site A | CAT2
 | Site B | CAT1
 | Site B | CAT3
 | Site B | CAT1
 | Site B | CAT3
 | Site C | CAT2
 | Site C | CAT3
 | Site C | CAT1
 | Site C | CAT3
 | Site D | CAT1
 | Site D | CAT2
 | Site D | CAT1
 | Site E | CAT3
 | Site E | CAT1
 | Site E | CAT3
 | Site F | CAT3
 | Site F | CAT3
 | Site F | CAT1
 | Site F | CAT3
 | Site F | CAT1
Spreadsheet: 86558d1286509667-solver-and-interger-programming-problem-33
Sheet: Sheet1

HW4 #33
Stores Within 2 Miles
Store | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sum
1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0
7 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1
9 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
Selections | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Month Rev | 127 | 83 | 165 | 96 | 112 | 88 | 135 | 141 | 117 | 94
Total
Spreadsheet: 880810d1728655182-text-string-count-and-word-search-sample-data-count-exact-text
Sheet: Data

First | Last | Comments
[NAME] | Smith | The customer called as a fraud case. I had to dispute fee charges
Billy | Jones | The customer called due to back service. dispute charges
[NAME] | Jones | The rep who assisted with th mortgage was excellent
Greg | Leone | The customer called stating fraud on the credit card
Sean | [NAME] | service
[NAME] | [NAME] | The mortgage process was excellent
[NAME] | Merrick | Rep states member called due to fraud on credit card.
[NAME] | Malone | Reps states discriminate
Syliva | Smith | Rude and unprofessional was the feel
[NAME] | Smith | Had to pay late fee
[NAME] | Merrick | The late fees are too high.
[NAME] | Jones | Increase rates
[NAME] | Struck | The rate was too high.
Spreadsheet: 862099d1709870540-populate-new-or-dropped-data-excel1-1-
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2
Month | Product ID | Product Name | Branch Name |  |  | Month | Product ID | Product Name | Branch Name | Status
Dec | 123456 | Product1 | Branch 1 |  |  | Jan | 123460 | Product5 | Branch 5 | [NAME]
Dec | 123457 | Product2 | Branch 2 |  |  | Jan | 123456 | Product1 | Branch 1 | [NAME]
Dec | 123458 | Product3 | Branch 3 |  |  | Jan | 123461 | Product6 | Branch 5 | New
Dec | 123459 | Product4 | Branch 4 |  |  | Feb | 123462 | Product7 | Branch 5 | New
Dec | 123460 | Product5 | Branch 5 |  |  | Mar | 123462 | Product8 | Branch 5 | New
Jan | 123457 | Product2 | Branch 2 |  |  | Apr | 123457 | Product2 | Branch 2 | [NAME]
Jan | 123458 | Product3 | Branch 3
Jan | 123459 | Product4 | Branch 4 |  |  |  | Product ID | Product Name | Branch Name | Status
Jan | 123461 | Product6 | Branch 5 |  |  | Jan | 123456 | Product1 | Branch 1 | [NAME]
Feb | 123457 | Product2 | Branch 2 |  |  | Jan | 123460 | Product5 | Branch 5 | [NAME]
Feb | 123458 | Product3 | Branch 3 |  |  | Jan | 123461 | Product6 | Branch 5 | New
Feb | 123459 | Product4 | Branch 4 |  |  | Feb | 123461 | Product6 | Branch 5 | [NAME]
Feb | 123462 | Product7 | Branch 5 |  |  | Feb | 123462 | Product7 | Branch 5 | New
Mar | 123457 | Product2 | Branch 2 |  |  | Mar | 123462 | Product8 | Branch 5 | New
Mar | 123458 | Product3 | Branch 3 |  |  | Apr | 123457 | Product2 | Branch 2 | [NAME]
Mar | 123459 | Product4 | Branch 4
Mar | 123462 | Product7 | Branch 5
Mar | 123462 | Product8 | Branch 5
Apr | 123458 | Product3 | Branch 3
Apr | 123459 | Product4 | Branch 4
Apr | 123462 | Product7 | Branch 5
Apr | 123462 | Product8 | Branch 5
Spreadsheet: 238701d1369680373-help-me-pivot-tables-sumif-vlook-up-excel-questionss
Sheet: Staff

 | Column1 | Hours worked | Holidays | Bonus £
 | Aliya | 95874 | 8 | 7500
 | [NAME] | 100000 | 5 | 10000000
 | [NAME] | 1245 | 18 | 2.5
 | Floss | 954100 | 5 | 15000
 | [NAME] | 54215 | 18 | 8500
 | Kris | 10000 | 3 | 50000
 | [NAME] | 4200 | 14 | 500
 | Mark | 98541 | 1 | 2365
 | Nicky | 15477 | 4 | 21351
 | [NAME] | 12000 | 0 | 5000
 | [NAME] | 650 | 10 | 1500
 | Simone | 5000 | 2 | 57000
 | Stacy | 10 | 20 | 10
 | Yesmin | 250 | 0 | 1000
Spreadsheet: richard_shapiro__32393__Lisa - EGM Budget
Sheet: Scenario 1

Cost Center Owner | [NAME]
Cost Center Number | 103886
 | Please use this form only for Outside Services
 | Scenario 1:  The "ideal" world
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | [NAME] * | 180000
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | To be determined | LNG-related FERC proceedings | 50000
 | To be determined | Improve competitive structure of US coal market | 50000
 | To be determined | Advocate weather derivative products in state proceedings | 50000
 | To be determined | Ocean Freight Due Diligence | 50000
 | To be determined | Due Diligence on New Markets | 100000
 |  | Total:
* includes all commodities provided by Global Markets:  freight, coal, weather, crude and products, etc.
Spreadsheet: 780615d1652615370-calculate-hours-worked-at-day-rate-and-night-rate-minus-breaks-example-schedule-ans
Sheet: Daily Rota

Name | Start | End | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours |  | 05:30:00 |  |  |  |  |  | Break rules | Hrs | Eligible
Staff Member 1 | 20:00:00 | 07:00:00 |  |  |  |  |  |  | Break Rules 4 hours or more but <6 hours = 15 minutes 6 hours or more but <8 hours = 30 minutes 8 hours or more but <9 hours = 45 minutes 9 hours or more but <11 hours = 1 hour 11 hours or more = 90 minutes |  |  |  |  |  |  | 0 | 0
Staff Member 2 | 1900-01-01 00:00:00 | 05:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.25
Staff Member 3 | 20:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.5
Staff Member 4 | 08:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0.75
Total Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 1.5
 |  |  | NOTE: | Break rule table added in Q:R column.
 |  |  |  | Cell J1 is having closing hoursof night hours.
Spreadsheet: 147008d1332465002-if-function-test1
Sheet: Summary Sheet

PAY PERIOD | START | 2012-03-18 00:00:00
 | END
Pay date
EMPLOYEE NAME | SUN | MON | TUES | WED | THU | FRI | SAT | TOTAL HOURS | 15 | 24 | 35 | 37 | 36 | PRB | [NAME] | 38 | 40 | 41 | CBS | ESL | TOTAL HOURS
 |  |  |  |  |  |  |  | WORKED | HSC | HSC | HSC | HSC | COL  PREP | COL  PREP | COL  PREP | PLPN | HC4 | CITI | COMP | CITI | PAID
Adepo, [NAME]
Amun-Rah, [NAME] |  |  | 3 |  | 3 | 3 |  |  |  |  |  |  |  |  |  | 9
[NAME], [NAME] |  |  | 3 |  | 3 |  |  |  |  |  |  | 6 |  | 1
Attard, [NAME]
[NAME], [NAME] |  | 3 |  | 3 |  |  |  |  |  |  | 3
Bubrow, Adam |  |  |  | 3 |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 9
[NAME], [NAME]
Byrnes, [NAME]
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 165115 | 173665 |  | 7230 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 157731 | 163949 |  | 5133 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 169391 | 176791 |  | 6746 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 182226 | 188682 |  | 8413 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-01-31 00:00:00 |  |  |  | -62640
 | 2001-02-04 00:00:00
Spreadsheet: 05005860-86e1-48ba-9f32-6ee14ab8bd9c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DESIP | Test | DESIP | Desipramine, Serum | Desipramine, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions:  1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose).  2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 100-300 ng/mL Toxic concentration: > or =300 ng/mL Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Saturday; Varies | 2 days | 4 days | 1 | 80160 |  |  |  |  | Rochester
DESIP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
DESIP | Result | 81854 | Desipramine, S | Desipramine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3531-1 | Desipramine:MCnc:Pt:Ser/Plas:Qn: