tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152918d1335596430-conditional-format-5-or-more-consecutive-no-or-4-consecutive-yes-in-a-range-testyesno
Sheet: Sheet1

 |  |  |  | test1 | no
 |  |  |  | test2 | no
 |  |  |  | test3 | yes
 |  |  |  | test4 | nul
 |  |  |  | test5 | nul
 |  |  |  | test6 | no
 |  |  |  | [NAME] | no
 |  |  |  | test8 | yes
 |  |  |  | test9 | yes
 |  |  |  | test10 | yes
 |  |  |  | test11 | yes
 |  |  |  | test12 | yes
 |  |  |  | test13 | nul
 |  |  |  | test14 | nul
 |  |  |  | test15 | nul
 |  |  |  | test16 | nul
 |  |  |  | test17 | no
 |  |  |  | test18 | yes
 |  |  |  | test19 | nul
 |  |  |  | test20 | nul
 |  |  |  | test21 | no
 |  |  |  | test22 | no
 |  |  |  | test23 | no
 |  |  |  | test24 | no
 |  |  |  | test25 | no
 |  |  |  | test26 | no
 |  |  |  | test27 | no
 |  |  |  | test28 | yes
 |  |  |  | test29 | nul
 |  |  |  | test30 | nul
 |  |  |  | test31 | no
 |  |  |  | test32 | no
 |  |  |  | test33 | yes
 |  |  |  | test34 | nul
 |  |  |  | test35 | nul
 |  |  |  | test36 | no
 |  |  |  | test37 | no
 |  |  |  | test38 | yes
 |  |  |  | test39 | nul
 |  |  |  | [NAME] | nul
 |  |  |  | test41 | no
 |  |  |  | test42 | no
 |  |  |  | test43 | yes
 |  |  |  | test44 | nul
 |  |  |  | test45 | nul
 |  |  |  | test46 | no
 |  |  |  | test47 | no
 |  |  |  | test48 | yes
 |  |  |  | test49 | nul
 |  |  |  | test50 | nul
 |  |  |  | test51 | no
 |  |  |  | test52 | no
 |  |  |  | [NAME] | yes
 |  |  |  | test54 | nul
 |  |  |  | test55 | nul
 |  |  |  | test56 | no
 |  |  |  | test57 | no
 |  |  |  | test58 | yes
 |  |  |  | test59 | nul
 |  |  |  | test60 | nul
 |  |  |  | test61 | no
 |  |  |  | test62 | no
 |  |  |  | test63 | yes
 |  |  |  | test64 | nul
 |  |  |  | test65 | nul
 |  |  |  | test66 | no
 |  |  |  | test67 | no
 |  |  |  | test68 | yes
 |  |  |  | test69 | nul
 |  |  |  | test70 | nul
Spreadsheet: 87834d1287692821-copy-from-an-alternate-row-awalc
Sheet: ALCOHOL MASTER

Supp | Bin | Produc | t |  | O | rder  S | Conv | +/-Bal | Action |  | From
Code | Code | Code | Description | Pack | M | Qty | Fact | Cases | Requir | ed | Bincode
1466 | AJ25F01 | 60788 | [NAME] 70cl | 6 |  | 0 |  | 89
1466 | [NAME] | 69104 | [NAME] 70cl Sgl | 1 |  | 13 | 6 | 1
1466 | AK24G05 | 60832 | Southern Comfort 70cl | 6 |  | 0 |  | 21
1466 | MC23B05 | 60194 | Southern Comfort 70cl Sg | 1 |  | 3 | 6 | 1
1466 | AJ23H05 | 62580 | [NAME] 35cl | 6 |  | 0 |  | 55
1466 | MC11A01 | 60789 | [NAME] 35cl Sgl | 1 |  | 7 | 6 | 2
1466 | AJ24H04 | 62589 | [NAME] | 6 |  | 0 |  | 41
1466 | MC11A05 | 63553 | [NAME] | 1 |  | 4 | 6 | 1
1466 | AU08G04 | 66977 | Southern Comfort 35cl | 6 |  | 0 |  | 12
1466 | MC16B06 | 60369 | Southern Comfort 35clSgl | 1 |  | 4 | 6 | 0
1466 | AJ32E02 | 67861 | [NAME] | 6 |  | 0 |  | 29
1466 | MC14B06 | 69117 | [NAME] | 1 |  | 1 | 6 | 1
1466 | AK24D03 | 67997 | [NAME] | 12 |  | 0 |  | 6
1466 | MC25B03 | 69472 | [NAME] | 1 |  | 1 | 12 | 1
1724 | AJ26F02 | 66850 | Oyster Bay Sv/Blanc 75cl | 6 |  | 0 |  | 201
1724 | MC20A02 | 63922 | Oyster Bay Sv/Blc 75cSgl | 1 |  | 11 | 6 | 0
.
Spreadsheet: jeff_dasovich__14257__Strategy Master
Sheet: Regulators

Regulators
Nord
Target |  |  |  | Contact |  | Enron |  | Status
PA PUC |  |  |  | [NAME] |  | Shapiro
FLA PSC |  |  |  | [NAME] |  | Shapiro
TX PUC |  |  |  | [NAME] |  | [NAME]
Messages
 | Consumer protection resides in functioning competitive wholesale markets
 | When competition done right, it works!
 | Utilities are increasingly dependent on competitive wholesale markets to meet their needs
 | FERC needs to finish the job on opening the wholesale market
 | States have an important role to play in promoting wholesale markets
 | Ask utilities:  “What have you done to manage your customer’s bills this winter?”
 | Ask customers with choice: “What are you doing right now to manage your bill?”
Briefing Material
 | “What happened in California?” Talking Points
Action Items |  |  |  |  |  | Status
 | Letter to FERC
 | Agree to take media referrals
 | Make speeches
Spreadsheet: 92745d1292307101-iteration-continuously-increases-after
Sheet: Value

 |  |  |  |  |  |  | SuperBowl |  | Championship |  | Divisional |  | WildCard |  | Week 17 |  | Week 16 |  | Week 15 |  | Week 14 |  | Week 13 |  | Week 12 |  | Week 11 |  | Week 10 |  | Week 9 |  | Week 8 |  | Week 7 |  | Week 6 |  | Week 5 |  | Week 4 |  | Week 3 |  | Week 2 |  | Week 1 |  | PreSeason Week 3 |  | 2009 Week 16 |  | 2009 Week 15 |  | 2009 Week 14
Team | Conference | Wins | Losses | DiffValue | Margin | Opp Value | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff | Opp | Diff
Arizona Cardinals | NFC West
Atlanta Falcons | NFC South
Baltimore Ravens | AFC North
Buffalo Bills | AFC East
Carolina Panthers | NFC South
Chicago Bears | NFC North
Cincinnati Bengals | AFC North
[NAME] | AFC North
Dallas Cowboys | NFC East
Denver Broncos | AFC West
Detroit Lions | NFC North
Green Bay Packers | NFC North
Houston Texans | AFC South
Indianapolis Colts | AFC South
[NAME] | AFC South
Kansas City Chiefs | AFC West
[NAME] | AFC East
Minnesota Vikings | NFC North
New England Patriots | AFC East
New Orleans Saints | NFC South
New York Giants | NFC East
New York Jets | AFC East
Oakland Raiders | AFC West
Philadelphia Eagles | NFC East
Pittsburgh Steelers | AFC North
San Diego Chargers | AFC West
San Francisco 49ers | NFC West
[NAME] | NFC West
St. Louis Rams | NFC West
Tampa Bay Buccaneers | NFC South
Tennessee Titans | AFC South
Washington Redskins | NFC East
X | X |  |  |  | 0 | 0
Spreadsheet: 47102d1246013698-sum-of-income-by-month-help
Sheet: Sheet1

 |  |  |  |  |  |  |  | Sum of each month only if there is a complete date.
 |  |  | Order No. | Order Amount £ | Date Ordered | Date Complete |  | Jan Total | Feb Total | [NAME] | Apr Total
 |  |  | 1 | 50 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 |  | 0 | 162 | 80 | 222
 |  |  | 2 | 60 | 2009-01-03 00:00:00
 |  |  | 3 | 112 | 2009-01-22 00:00:00 | 2009-02-22 00:00:00
 |  |  | 4 | 35 | 2009-02-02 00:00:00 | 2009-03-02 00:00:00
 |  |  | 5 | 45 | 2009-02-13 00:00:00 | 2009-03-13 00:00:00
 |  |  | 6 | 50 | 2009-03-03 00:00:00 | 2009-04-03 00:00:00
 |  |  | 7 | 60 | 2009-03-05 00:00:00 | 2009-04-05 00:00:00
 |  |  | 8 | 112 | 2009-03-12 00:00:00 | 2009-04-12 00:00:00
 |  |  | 9 | 35 | 2009-03-25 00:00:00
 |  |  | 10 | 45 | 2009-03-27 00:00:00
Spreadsheet: 718469d1613146937-lookup-month-in-col-a-and-if-col-h-on-same-sheet-x-display-x-otherwise-blank-staff-changes-by-month-example-1-
Sheet: Mar

Staff Transferred Out |  |  |  |  |  |  |  |  | Mar
Spreadsheet: louise_kitchen__22533__3base329c
Sheet: Hawaii Summary

Summary of Hawaii Securitizations
Today
Series | Date | # of Warrants | Close Price | Notional | Debt | Debt O/S | Equity | Equity Rate | Days O/S | Equity O/S
A | 2000-03-31 00:00:00 | 33832 | 591 |  | 18023750 |  | 1976250 | 0.15
B/D | 2000-09-29 00:00:00 | 42291 |  |  | 86971504 |  | 3954146 | 0.15
C | 2000-08-28 00:00:00 | 13959 |  |  | 29111495 |  | 900355 | 0.15
Strike
Screen
Derivative Asset/Liability to Porcupine Summary
 | Receivable | Payable
A
B/D
C
TOTAL
 |  | 371496849
 |  | 263758095
Spreadsheet: 108231d1305281632-sorting-data-based-on-drop-down-lists-test-data_timheffo
Sheet: GUI

 | Select Level
 | Select Course
 | OCB
 | Course Contacts |  |  |  | Course Specifics
 | Course Admin Officer |  |  |  | Faculty
 | Course Coordinator |  |  |  | Level
 | Assessment Officer |  |  |  | Program Code
 | Client Service Officer - Admissions |  |  |  | TAC Code
 | Client Service Officer - Administration |  |  |  | [NAME]
 |  |  |  |  | Campus
 |  |  |  |  | Mode
 |  |  |  |  | Competitive
 |  |  |  |  | Defferable
 |  |  |  |  | Delegated Authority
 |  |  |  |  | Pathways
 |  |  |  |  | [NAME]
Spreadsheet: 681332d1591484609-vlookup-query-vlookup
Sheet: Sheet1

Location A | Location B | Distance |  |  |  | Table A | Distance
Birmingham | [NAME] | ? |  |  |  | London | 0
London | Liverpool | ? |  |  |  | [NAME] | 1
[NAME] | Cornwall | ? |  |  |  | Bristol | 2
[NAME] | Cheshire | ? |  |  |  | Cornwall | 3
Liverpool | [NAME] | ? |  |  |  | York | 4
Cornwall | [NAME] | ? |  |  |  | Birmingham | 5
 |  |  |  |  |  | Portsmouth | 6
 |  |  |  |  |  | Liverpool | 7
 |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  | Cheshire | 9
Spreadsheet: chris_germany__2606__contacts
Sheet:  Bulletin Boards

Bulletin Board
Pipeline/LDC | EBB | Internet/ProComm | Script/Phone #/Internet | ID | Password | Purpose
Algonquin | Link | ProComm | script 0:\common\prowin3\wax\nt\central\linkwin.wax | lnk5803 | chris9 | capacity release, notices, rate info
CNG (pipeline) | E-Script | ???? |  | es0527$ | cng12dec | capacity release, notices, rate info
Columbia Gas | Navigator | ??? |  | nav0409 | clg11nov | trust
Columbia Gulf | Altra | ??? |  | col0409 | col0409 | capacity release, notices, rate info
Tennessee Pipeline | Passkey | ??? |  | 000357D | prices | capacity release, notices, rate info
Texas Eastern Transmission | Link | ProComm | script 0:\common\prowin3\wax\nt\central\linkwin.wax | lnk6449 | chris1 | ECT Access - capacity release, notices, rate info
Transco | Transit | Internet | www.transit.twc.com | upnr010 | [NAME] | capacity release, notices, rate info
Transco | Transit | Internet | www.transit.twc.com | upnr140 | [NAME] | capacity release, notices, rate info | [NAME] Password
Texas Gas Transmission | Gasquest | Internet |  | $Germany_c | bayliner or flying OR fubatex
Network |  |  |  | cgermany | flying
Dow Jones Telerate |  |  |  |  | texas1
cpr |  |  |  |  | texas1
Synergi |  |  |  | cgerman | pipercub | Old password = columbus
Synergi 2nd password |  |  |  | cgerman | 453333235 | <== never changes
Unify |  |  |  | cgerman | clg07july
Unify |  |  |  | cgerman | houston
Performance Management |  |  |  | CHRISGERMANY3235 | clg07july
E Greetings |  |  | http://www.egreetings.com/e-products/m_main/cgi/homepage |  | duffy
Enron Online |  |  |  | [NAME] | chrisger
Spreadsheet: 41300d1239794881-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Jan 12-17

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2009-01-12 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2009-01-13 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2009-01-14 00:00:00 | 06:30:00 | 12:00:00 | 5.5 | 29001 |  | CNC P
 | 12:30:00 | 03:00:00 | 2.5 | SHOP | 8
2009-01-15 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2009-01-16 00:00:00 | 06:30:00 | 08:30:00 | 2 | 29003 |  | CNC M
 | 08:30:00 | 03:00:00 | 6 | SHOP | 8
 |  |  |  |  |  |  |  |  | VACATION 54.5 HRS
 |  | SHOP | 32.5
 |  | 29001 | 5.5
 |  | 29003 | 2
 |  |  | 40 | TOTAL | 40
Spreadsheet: 885417d1734964100-see-last-post-for-additions-need-help-with-autofilling-information-template
Sheet: Sources

 |  |  |  |  |  |  |  | Subnet |  | Combination 1 | Combination 2
 |  |  |  |  |  |  |  | 10.0. |  | 100 | 13
 |  |  |  |  |  |  |  |  |  | 101 | 14
IP |  |  |  |  |  |  |  |  |  | 102 | 15
010 |  |  |  |  |  |  |  |  |  | 103 | 16
IP Stripped |  |  |  |  |  |  |  |  |  | 104 | 17
 |  |  |  |  |  |  |  |  |  | 105 | 18
 |  |  |  |  |  |  |  |  |  | 106 | 19
 |  |  |  |  |  |  |  |  |  | 107 | 20
 |  |  |  |  |  |  |  |  |  | 108 | 21
 |  |  |  |  |  |  |  |  |  | 109 | 22
 |  |  |  |  |  |  |  |  |  | 110 | 23
 |  |  |  |  |  |  |  |  |  | 111 | 24
 |  |  |  |  |  |  |  |  |  | 112 | 25
 |  |  |  |  |  |  |  |  |  | 113 | 26
 |  |  |  |  |  |  |  |  |  | 114 | 27
 |  |  |  |  |  |  |  |  |  | 115 | 28
 |  |  |  |  |  |  |  |  |  | 116 | 29
 |  |  |  |  |  |  |  |  |  | 117 | 30
 |  |  |  |  |  |  |  |  |  | 118 | 31
 |  |  |  |  |  |  |  |  |  | 119 | 32
 |  |  |  |  |  |  |  |  |  | 120 | 33
 |  |  |  |  |  |  |  |  |  | 50 | 34
 |  |  |  |  |  |  |  |  |  | 51 | 35
 |  |  |  |  |  |  |  |  |  | 52 | 36
 |  |  |  |  |  |  |  |  |  | 53 | 37
 |  |  |  |  |  |  |  |  |  | 54 | 38
 |  |  |  |  |  |  |  |  |  | 55 | 39
 |  |  |  |  |  |  |  |  |  | 56 | 40
 |  |  |  |  |  |  |  |  |  | 57 | 41
 |  |  |  |  |  |  |  |  |  | 58 | 42
 |  |  |  |  |  |  |  |  |  | 59 | 43
 |  |  |  |  |  |  |  |  |  | 28 | 44
 |  |  |  |  |  |  |  |  |  | 29 | 45
 |  |  |  |  |  |  |  |  |  | 30 | 46
 |  |  |  |  |  |  |  |  |  | 31 | 47
 |  |  |  |  |  |  |  |  |  | 32 | 48
 |  |  |  |  |  |  |  |  |  | 33 | 49
 |  |  |  |  |  |  |  |  |  | 34 | 50
 |  |  |  |  |  |  |  |  |  | 35 | 51
 |  |  |  |  |  |  |  |  |  | 36 | 52
 |  |  |  |  |  |  |  |  |  | 37 | 53
 |  |  |  |  |  |  |  |  |  | 38 | 54
 |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  | 70
Spreadsheet: 757135d1638037584-how-to-xlookup-if-the-search-keys-are-comma-separated-excelforum
Sheet: Sheet2

Product ID | Quantity |  |  |  | Search | Result
AB001 | 1209 |  |  |  | AB001,HN002
HN002 | 3407 |  |  |  | AB001 |  |  | 1209
CN890 | 3340 |  |  |  | CN890 |  |  | 3340
MK003 | 5600 |  |  |  | MK003,CN890 |  |  | 8940
Spreadsheet: 846144d1697453313-blocking-info-sl-ckargranskning
Sheet: Sheet1

NN MultiTool |  |  | Asiakas:
[NAME] , 10600 Ekenäs
[PHONE]
FO-Nummer 2174260
Omistaja | Malli | No | Tyyppi | Valm.Vuosi | Vanhentuu | Tark/Huolto | 1,2 Tai 3 V | Huomautuksia | [NAME]
Tarkistaja:
Allekirjoitus:
Pvm:
Spreadsheet: 763151d1642010424-combining-different-if-fuctions-based-on-multiple-criterias-in-different-tabs-example-pl-act-bud-ly-and-departments
Sheet: P&L

Month: | December
Department: | Department 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | January | Department 1
 | MTD |  |  | YTD |  |  |  |  |  |  |  |  |  |  | February | Department 2
Category | Actual | Budget | 2020 | Actual | Budget | 2020 |  |  |  |  |  |  |  |  | March | Department 3
Revenue 1 |  |  |  | ? | ? | ? |  |  |  |  |  |  |  |  | April
Revenue 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
Total revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
Cost 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
Cost 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Total costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
1. I want a formula that returns values based on Month (B1), Department (B2), Actual/Budget/2020 on MTD and YTD and the categories (A5,A6,A8 and A9). So when I change the month and department, the values in my MTD and YTD table will change according to this.
2. In this example I have created 3 departments in 3 different tabs with unique values in actual, budget and 2020 numbers (the set up is the same in all tabs).
3. In the D1,D2 and [NAME] tabs I have set different categories (column A in each tab).
4. The formulas I have put in this tab (P&L) in cell B5, C5 and D5 is the correct numbers, and somehow how I want it, but the problem is that if i change Month and Department in Cell B1 and B2, the whole table wont update.
5. I also have an issue figuring out how I can get the Year-to-date numbers based on Month and Department.
Spreadsheet: 146305d1332076688-excel-2007-shift-data-up-if-there-is-any-empty-cell-book1
Sheet: after  Sheet1

 | first
 | second
 | third
 | fourth
 | fifth
 | sixth
 | seventh
 | eighth
 | ninth
 | tenth
 | eleventh
 | thirteenth |  | I have delete  twelfth from this sheet
 | fourteenth |  | and the last cell  (B25) it become empty    (data shift Up )
 | fifteenth
 | sixteenth
 | seventeenth
 | eighteenth
 | nineteenth
 | twentieth
 | twenty-first
 | twenty-second
 | twenty-third
 | twenty-fourth
 | twenty-fifth
 | twenty-sixth
 | twenty-seventh
 | twenty-eighth
 | twenty-ninth
 | thirtieth
 | thirty-first
 | thirty-second
 | thirty-third
 | thirty-fourth
 | thirty-fifth
 | thirty-sixth
 | thirty-seventh
 | thirty-eighth
 | thirty-ninth
 | fortieth
 | forty-first
 | forty-second
 | forty-third
 | forty-fourth
 | forty-fifth
 | forty-sixth
 | forty-seventh
 | forty-eighth
 | forty-ninth
 | fiftieth
Spreadsheet: 37602d1235655439-sumproduct-question-test-data-1
Sheet: Sheet1

.
.
. |  |  |  | Position | Account Manager | [NAME] | Outstanding Total Opportunity
. |  |  |  | # 01 | [NAME] | 38537 | 0
. |  |  |  | # 02 | [NAME] | 50400 | 1000
. |  |  |  | # 03 | [NAME] | 3773 | 0
. |  |  |  | # 04 | [NAME] | 1614 | 0
. |  |  |  | # 05 | [NAME] | 0 | 0
. |  |  |  | # 06 | Not Applicable | 0 | 0
.
. |  |  |  | Total | Northern | 94324 | 1000
.
.
. |  |  | Total | 3353 | 83367.73999999999 |  |  |  |  | 94324 | 0.5209982902568725
Account Manager | Hospital | Hospital Number | System | PHP Opportunity (€) | Takeout Opportunity (€) (non-PHP) | Permission to [NAME]? Yes / No                        Who |  | Audited? Yes / No | Returned Date | [NAME] | % Returned | Consignment Team Comments | Field Sales Manager & Account Manager Comments
[NAME] | [NAME] | 42227 | Retentive bore Cups | 1000 |  |  |  |  | 2009-01-01 00:00:00 | 900 | 0.9 | Items identified in PHP Takeout 24/09/2008
[NAME] | Woodlands | 34921 | C-Stem High Offset |  |  |  |  |  | 2009-01-07 00:00:00 | 1000
[NAME] | [NAME] | 32740 | PFC/Ultima/Cstem |  | 24705 |  |  |  | 2009-01-01 00:00:00 | 24705 | 1 | all hip and knee stock boxed a/w return 18/6/08 Cw says that still being used, but will assess in Oct 08 if we get new tender or not.8/12/08 won tender therefore being used however CW says Ultima to return JH
Spreadsheet: 138942d1328009671-conditional-formatting-formula-book1
Sheet: Sheet1

 |  | WEEK
 | NAME | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NO [NAME]
 |  | I need a formula like this one BUT ALL cells EXCLUDING number 0
 |  | WEEK
 | NAME | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0 | NO [NAME]
 | When I put any number (except zero) in cell [NAME], IF all cells from C4 to K4 have numbers on them (except zero) , cell [NAME] becomes RED
Spreadsheet: 0cb28636-11d5-4b90-bcc0-d95be0045d49
Sheet: W2calc

Last Paystub Reconciliation to W2
Gross YTD - per ECHO
Add: Group Term Life (Code C on W2)
Deduct YTD per ECHO:
(enter as positive numbers)
BJF1,BJF2
BJI1,BJI2
BJS1, BJS2
BJC1, BJC2
B2FA, B2FB
B2IA, B2IB
B2S1, [NAME]
[NAME], [NAME]
FLXM
FLXD
AFF1,AFF2
AFI1,AFI2
DNF1,DNF2
IAAC
Taxable Social Security and Medicare |  |  | 2012
Wages   (Box 3 and Box 5 on W2) |  | (Maximum Social Security Wages - $110,100)
Deduct YTD per ECHO:
(enter as positive numbers)
RADD,RAD$ |  |  | 0 | Medicare taxable wages
RREG,RRG$ | 0 |  | 0 | Gross Wages
457 b/RSRA,RSR$ | 0 |  |  | 457b
Taxable Federal and State Wages
(Box 1 and Box 16 on [NAME])
Spreadsheet: 689116d1596130980-formula-help-to-average-cells-based-on-set-number-of-entries-2020-07-14-oeldere4-marcellab-686590d1594703072-formula-to-average-and-count-excel-help-1-_r
Sheet: Sheet1 

Customer | Booking Date | SM
Project A | 2019-06-01 00:00:00 | 0.9
Project B | 2019-07-01 00:00:00 | 0.4
Project C | 2019-08-01 00:00:00 | 0.541
Project D | 2019-08-01 00:00:00 | 0.579
Project E | 2019-08-01 00:00:00 | 0.695 | (Recent project #5)
Project F | 2019-11-01 00:00:00 | 0.723 | (Recent project #4)
Project G | 2020-01-01 00:00:00 | 0.675 | (Recent project #3)
Project H | 2020-06-01 00:00:00 | 0.765 | (Recent project #2)
Project I | 2020-07-01 00:00:00 | 0.65 | (Recent project #1)
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
 | Average
Spreadsheet: chris_germany__2320__2001new03
Sheet: Pricing

CGAS |  | FTS |  | [NAME]
Index | CGAS | 5.29 |  | 5.29 |  | Storage Withdrawal: |  | 5.26
Index [NAME] |  | 0.0125 |  | 0.0125 |  | FOM |  | 0.0125
Comm |  | 0.0133 |  | 0.0133 |  | Withdrawal |  | -0.0153
Surcharges |  | 0.0092 |  |  |  | Less GRI & ACA on SST |  | 0.0092
Fuel |  | 0.02184 |  | 0.02184
Transport
 |  |  | Deal 649352 | 0.11
 |  |  |  |  |  |  |  | Deal 380571
CGLF |  | FT-1 | Volume |  |  |  |  | Monthly Vol | Daily
Index | CGLF | 5.02 | 1338 | Deal 551042 (bookout with deal 380571) |  |  | 2001-01-01 00:00:00 | 41486
Index [NAME] |  | 0.1 |  |  |  |  | 2001-02-01 00:00:00 | 36508
Comm |  | 0.017 |  |  |  |  | 2001-03-01 00:00:00 | 26671
Surcharges |  | 0.0022
Fuel |  | 0.0282 |  | Deals 551007
Transport
Deal 227081, 227113
Note:  New Power purchased gas from ENA at CGLF Mainline (deal 380571).  ENA will buy this gas back at the CGLF Onshore Index plus $.10,
 | and sell the gas back to New Power at CGAS pool at CGLFOnshore Index +$.10 + variable cost from Mainline to Leach, deal 551007,
 | ENA will buy the CGAS Pool gas back at the FOM price for CGAS.
 | Created deal 551027 to bookout with deals 376880, 380492, and 551007.
Spreadsheet: 14ceff22-d567-4921-8345-170ef93ba6aa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8774 | 29667 | Ilaria | Zavanone | ITA | 109 | 00:18:33 | 00:00:49 | 00:33:15 | 00:01:15 | 00:22:18 | 1 | 01:16:11
Spreadsheet: 812183d1673009555-multiple-vlookups-to-match-and-combine-data-book1
Sheet: Sheet1

Sheet1 |  |  |  |  | Sheet2 |  |  |  |  | Sheet3
Name | [NAME] | Working Day |  |  | Starting date | Department | Position | [NAME] |  | Name | [NAME] | Working Day | Starting date | Department | Position
[NAME] | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2023-01-01 00:00:00 | People DEPT | Manager | [EMAIL] |  | [NAME] | [EMAIL] | 2023-01-01 00:00:00
[NAME] | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2022-12-29 00:00:00 | Show DEPT | Actor | [EMAIL] |  | [NAME] | [EMAIL] | 2023-01-01 00:00:00
[NAME] | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2022-12-30 00:00:00 | [NAME] | Legend | [EMAIL] |  | [NAME] | [EMAIL] | 2023-01-01 00:00:00
[NAME] | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2022-12-31 00:00:00 | Show DEPT | Movie star | [EMAIL] |  | [NAME] | [EMAIL] | 2023-01-01 00:00:00
Elisabet Tailor | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2023-01-01 00:00:00 | Show DEPT | Singer | [EMAIL] |  | Elisabet Tailor | [EMAIL] | 2023-01-01 00:00:00
[NAME] | [EMAIL] | Off |  |  | 2023-01-02 00:00:00 | People DEPT | HR | [EMAIL] |  | [NAME] | [EMAIL] | Off
Houston Rocket | [EMAIL] | Off |  |  | 2023-01-03 00:00:00 | People DEPT | Architect | [EMAIL] |  | Houston Rocket | [EMAIL] | Off
[NAME] | [EMAIL] | 2023-01-01 00:00:00 |  |  | 2023-01-04 00:00:00 | Security DEPT | Security | [EMAIL] |  | [NAME] | [EMAIL] | 2023-01-01 00:00:00
Elisabet Tailor | [EMAIL] | Off |  |  |  |  |  |  |  | Elisabet Tailor | [EMAIL] | Off
[NAME] | [EMAIL] | 2023-01-02 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-02 00:00:00
Houston Rocket | [EMAIL] | 2023-01-02 00:00:00 |  |  |  |  |  |  |  | Houston Rocket | [EMAIL] | 2023-01-02 00:00:00
[NAME] | [EMAIL] | 2023-01-02 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-02 00:00:00
 |  |  |  |  |  |  |  |  |  | Elisabet Tailor | [EMAIL] | Off
Elisabet Tailor | [EMAIL] | Off |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-03 00:00:00
[NAME] | [EMAIL] | 2023-01-03 00:00:00 |  |  |  |  |  |  |  | Houston Rocket | [EMAIL] | 2023-01-03 00:00:00
Houston Rocket | [EMAIL] | 2023-01-03 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-03 00:00:00
[NAME] | [EMAIL] | 2023-01-03 00:00:00
 |  |  |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-04 00:00:00
[NAME] | [EMAIL] | 2023-01-04 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-04 00:00:00
[NAME] | [EMAIL] | 2023-01-04 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-04 00:00:00
[NAME] | [EMAIL] | 2023-01-04 00:00:00 |  |  |  |  |  |  |  | [NAME] | [EMAIL] | 2023-01-04 00:00:00
[NAME] | [EMAIL] | 2023-01-04 00:00:00 |  |  |  |  |  |  |  | Elisabet Tailor | [EMAIL] | 2023-01-04 00:00:00
Elisabet Tailor | [EMAIL] | 2023-01-04 00:00:00