tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 330363d1404731736-bottom-to-top-counting-with-one-criteria-upto-blank-count-lbp-or-ubp
Sheet: Sheet1

LBP
LBP
LBO | 2
UBP
UBP
UBP
UBO | 3
UBP
UBP
UBO | 2
UBP
UBP
UBO | 2
UBP
UBP
UBO | 2
LBP
LBO | 1
UBP
UBP
UBO | 2
UBO | 0
UBP
UBO | 1
LBO | 0
LBP
LBO | 1
LBP
LBO | 1
UBP
UBO | 1
LBO | 0
LBO | 0
LBP
LBP
LBP
LBO | 3
LBP
LBP
LBP
LBO | 3
UBO | 0
UBP
UBP
UBP
UBO | 3
UBO | 0
LBP
LBP
LBO | 2
LBO | 0
UBP
UBO | 1
LBO | 0
UBP
UBP
UBP
UBO | 3
LBP
LBP
LBO | 2
LBP
LBO | 1
LBO | 0
LBP
LBP
LBP
LBP
LBP
LBP
LBO | 6
LBP
LBO | 1
LBP
LBO | 1
LBP
LBP
LBO | 2
UBP
UBO | 1
UBP
UBO | 1
UBP
UBP
UBP
UBO | 3
UBP
UBO | 1
UBP
UBP
UBO | 2
UBP
UBO | 1
UBO | 0
UBP
UBP
UBP
UBP
UBO | 4
UBO | 0
UBP
UBO | 1
LBO | 0
LBO | 0
LBP
LBO | 1
UBP
UBP
UBP
UBP
UBP
UBO | 5
UBP
UBP
UBO | 2
UBO | 1
UBP
UBP
UBP
UBP
UBO | 4
LBP
LBP
LBP
LBP
LBO | 4
LBP
LBO | 1
UBP
UBO | 1
UBP
UBP
UBP
UBP
UBO | 4
LBP
LBP
LBP
LBP
LBP
LBP
LBO | 6
LBP
LBP
LBP
LBO | 3
UBP
UBP
UBP
UBP
UBO | 4
LBO | 0
UBP
UBO | 1
UBP
UBP
UBO | 2
UBO | 0
UBP
UBO | 1
UBO | 0
UBP
UBP
UBP
UBO | 3
UBO | 1
Spreadsheet: 854161d1704129082-return-based-on-group-results-book1
Sheet: Sheet1

Group ID | File_Status | Filename | Group_Status
0 | Good | 0001
0 | Good | 0001
0 | Good | 0001
1 | Good | 0002
1 | Good | 0002
1 | Good | 0002
2 | Good | 0003
2 | Corrupt | 0003
2 | Good | 0003
3 | Good | 0004
3 | Good | 0004
3 | Good | 0004
4 | Corrupt | 0005
4 | Corrupt | 0005
4 | Corrupt | 0005
5 | Good | 0006
5 | Good | 0006
5 | Good | 0006
6 | Corrupt | 0007
6 | Corrupt | 0007
6 | Corrupt | 0007
6 | Good | 0007
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: RefWorks

RefWorks
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per unit
New Users | 8 | 19 | 60 | 75 | 23 | 11 | 10 | 78 | 16 | 21 | 8 | 6 |  | 12485
Repeat Users | 16 | 17 | 34 | 57 | 89 | 74 | 34 | 58 | 76 | 91 | 42 | 23 |  | 12485
Total Monthly Users | 24 | 36 | 94 | 132 | 112 | 85 | 44 | 136 | 92 | 112 | 50 | 29 |  | 12485 |  | per user
Total Sessions per month | 168 | 93 | 294 | 721 | 559 | 340 | 176 | 488 | 355 | 640 | 127 | 137 |  | 12485 |  | per session
Average Sessions Per User | 7 | 2.58 | 3.13 | 5.46 | 4.99 | 4 | 4 | 3.59 | 3.86 | 5.71 | 2.54 | 4.72 |  | 12485
Total Subscriber References added | 990 | 296 | 1903 | 1701 | 1408 | 597 | 466 | 1532 | 1367 | 1505 | 581 | 788 |  | 12485 |  | per reference added
Average References added per user | 41.25 | 8.22 | 20.24 | 12.89 | 12.57 | 7.02 | 10.59 | 11.26 | 14.86 | 13.44 | 11.62 | 27.17 |  | 12485
COUNTER-Compliant?: | No
Spreadsheet: 773782d1648045361-combining-different-sets-of-data-excel-example
Sheet: Sheet1 (3)

Name | Points
AB | 4
GH | 2
TT | 33
PWW | 56
FC | 111
TV | 4
NN | 234
PWW | 3
TTW | 22
UIP | 56
REW | 12
IOP | 3
Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: by Month

Customer Complaint Summary by Category
Complaint  Top category | Period
Foreign Body | 2
Foreign Body Total
Order Error | 1
 | 2
Order Error Total
Packaging | 1
Packaging Total
Quality | 1
Quality Total
[NAME] | 1
Allergen Total
Transport | 1
Transport Total
Other | 1
Other  Total
Grand Total
Spreadsheet: 61789d1262714201-2d-vlookup-test-files
Sheet: original format

[PHONE] | 29
[PHONE] | 42
[PHONE] | 44
10000000003 | 54
10000000003 | 41
10000000003 | 55
10000000003 | 65
10000000003 | 10
10000000003 | 65
10000000003 | 45
10000059505 | 85
10000059505 | 45
10000059505 | 55
10000059505 | 65
10000059505 | 89
10000059505 | 122
10000059505 | 552
10000061544 | 123
10000061544 | 589
10000061544 | 459
10000061544 | 332
Spreadsheet: 887578d1737823372-can-i-use-vlookup-when-lookup-value-is-in-every-other-column-excelforumvlookup
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected return
1 | 2024-11-23 00:00:00 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-07 00:00:00
 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-30 00:00:00
 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: 145445d1331582401-sum-different-sheet-based-on-2-criteria-book8
Sheet: February 2012

 |  | RTS | IS | DF | Ven
500100 | xx | 5 | 4 | 3 | 2
500104 | nn | 1 | 2 | 3 | 4
500031 | zz | 9 | 8 | 7 | 6
Spreadsheet: 184907d1349425440-counting-3-columns-including-1-date-clients
Sheet: Sheet1

League | Date | Reason
Spain | 2012-06-01 00:00:00 | Existing
France | 2012-07-24 00:00:00 | New
Spain | 2012-07-28 00:00:00 | Entertain
Spain | 2012-07-31 00:00:00 | Existing
Germany | 2012-08-03 00:00:00 | Existing
France | 2012-08-05 00:00:00 | New
Ireland | 2012-08-11 00:00:00 | Entertain
France | 2012-08-11 00:00:00 | New
Germany | 2012-08-11 00:00:00 | New
Ireland | 2012-08-14 00:00:00 | Entertain
Belgium | 2012-08-14 00:00:00 | Existing
Spain | 2012-08-17 00:00:00 | New
France | 2012-08-18 00:00:00 | Entertain
Spain | 2012-08-18 00:00:00 | Existing
Spain | 2012-08-18 00:00:00 | Existing
Germany | 2012-08-21 00:00:00 | New
France | 2012-08-21 00:00:00 | Entertain
Ireland | 2012-08-22 00:00:00 | New
France | 2012-08-25 00:00:00 | New
Germany | 2012-08-25 00:00:00 | Entertain
Ireland | 2012-08-25 00:00:00 | Existing
 |  | Ireland | France | Spain | Germany | Belgium
June | New
 | Entertain
 | Existing
July | New
 | Entertain
 | Existing
August | New
 | Entertain
 | Existing
Spreadsheet: 250b33ca-2fe2-4a34-8ed3-174547db2027
Sheet: bilgi

001 | Adana |  |  |  | 1 | T.C.MERKEZ BANKASI A.Ş.
002 | Adıyaman |  |  |  | 4 | İLLER BANKASI
003 | Afyon |  |  |  | 10 | [NAME]
004 | Ağrı |  |  |  | 12 | HALK BANKASI
005 | Amasya |  |  |  | 14 | T.SINAİ KALK. BANKASI A.S.
006 | Ankara |  |  |  | 15 | T.VAKIFLAR BANKASI T.A.O.
007 | Antalya |  |  |  | 16 | [NAME]
008 | [NAME] |  |  |  | 17 | T.KALKINMA BANKASI A.S.
009 | [NAME] |  |  |  | 29 | BIRLESIK FON BANKASI A.S.
010 | Balıkesir |  |  |  | 32 | [NAME]
011 | Bilecik |  |  |  | 46 | AKBANK T.A.S.
012 | Bingöl |  |  |  | 59 | ŞEKERBANK T.A.S.
013 | Bitlis |  |  |  | 62 | T.GARANTİ BANKASI A.S.
014 | Bolu |  |  |  | 64 | T.IŞ BANKASI A.S.
015 | [NAME] |  |  |  | 67 | YAPI VE KREDI BANKASI A.S.
016 | Bursa |  |  |  | 88 | THE ROYAL BANK OF SCOTLAND N.V.
017 | Çanakkale |  |  |  | 91 | ARAP TÜRK BANKASI A.S.
018 | Çankırı |  |  |  | 92 | CITIBANK A.S.
019 | Çorum |  |  |  | 96 | TURKISHBANK
020 | [NAME] |  |  |  | 98 | JP MORGAN CHASE BANK NA MERK COL.OH
021 | Diyarbakır |  |  |  | 99 | ING BANK A.S.
022 | Edirne |  |  |  | 100 | ADABANK A.S.
023 | Elazığ |  |  |  | 103 | FIBABANKA A.S.
024 | Erzincan |  |  |  | 106 | PORTIGON AG MER.DUSSELD.IST.MER.SB.
025 | Erzurum |  |  |  | 108 | TURKLAND BANK A.S.
026 | [NAME] |  |  |  | 109 | TEKSTIL BANKASI A.S.
027 | Gaziantep |  |  |  | 111 | FINANSBANK A.S.
028 | [NAME] |  |  |  | 115 | DEUTSCHE BANK A.S.
029 | Gümüşhane |  |  |  | 116 | TAIB YATIRIMBANK A.S.
030 | Hakkari |  |  |  | 121 | CREDIT AGRICOLE YATIRIM BANK.TURK
031 | Hatay |  |  |  | 122 | SOCIETE GENERALE
032 | Isparta |  |  |  | 123 | HSBC BANK A.S.
033 | İçel |  |  |  | 124 | ALTERNATIFBANK A.S.
034 | İstanbul |  |  |  | 125 | EUROBANK TEKFEN A.S.
035 | [NAME] |  |  |  | 129 | MERRILL LYNCH YATIRIM BANK A.S.
036 | Kars |  |  |  | 132 | IMKB TAKAS VE SAKLAMA BANKASI
037 | [NAME] |  |  |  | 134 | DENIZ BANK A.S.
038 | Kayseri |  |  |  | 135 | ANADOLUBANK A.S.
039 | [NAME] |  |  |  | 138 | DİLER YATIRIM BANKASI A.S.
040 | [NAME] |  |  |  | 139 | GSD YATIRIM BANKASI A.S.
041 | Kocaeli |  |  |  | 141 | NUROL YATIRIM BANKASI A.S.
042 | Konya |  |  |  | 142 | BANKPOZITIF KREDI VE KALK.BANK.A.S.
043 | Kütahya |  |  |  | 143 | AKTIF YATIRIM BANKASI A.S.
044 | Malatya |  |  |  | 203 | ALBARAKA TURK KATILIM BANKASI A.S.
045 | Manisa |  |  |  | 205 | KUVEYT TURK KATILIM BANKASI A.S.
046 | Kahramanmaraş |  |  |  | 206 | TURKIYE FINANS KATILIM BANKASI A.S.
047 | Mardin |  |  |  | 208 | ASYA KATILIM BANKASI A.S.
048 | [NAME] |  |  |  | 806 | MERKEZI KAYIT KURULUSU
049 | Muş
050 | Nevşehir
051 | Niğde
052 | Ordu
053 | Rize
054 | Sakarya
055 | Samsun
056 | Siirt
057 | Sinop
058 | [NAME]
059 | Tekirdağ
060 | Tokat
061 | Trabzon
062 | Tunceli
063 | Şanlıurfa
064 | Uşak
065 | Van
066 | [NAME]
067 | [NAME]
068 | Aksaray
069 | [NAME]
070 | Karaman
071 | Kırıkkale
072 | Batman
073 | Şırnak
074 | Bartın
075 | Ardahan
076 | [NAME]
077 | Yalova
078 | Karabük
079 | Kilis
080 | Osmaniye
081 | Düzce
Spreadsheet: 287691d1388944470-compare-two-sets-of-data-but-not-simply-across-the-row-workbook2
Sheet: Sheet1

4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 11 | Apple | Angry | Windy
4 | [NAME] | Happy | Sunny |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
11 | Apple | Angry | Windy |  |  | 4 | [NAME] | Happy | Sunny
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: Wednesday

Weekly [NAME] |  |  |  |  | Wednesday
Hour | T/C | TTL | TTL | Name | Shift Manager
0000 - 0100 | 0 | 0 | #N/A
0100 - 0200 | 0 | 0 | #N/A
0200 - 0300 | 0 | 0 | #N/A
0300 - 0400 | 0 | 0 | #N/A
0400 - 0500 | 0 | 0 | #N/A
0500 - 0600 | 0 | 0 | #N/A
0600 - 0700 | 3 | 54 | 18
0700 - 0800 | 9 | 104 | 11.55555555555556 |  | [NAME]
0800 - 0900 | 9 | 125 | 13.88888888888889 |  | [NAME]
0900 - 1000 | 15 | 227 | 15.13333333333333 |  | [NAME]
1000 - 1100 | 15 | 299 | 19.93333333333333 |  | [NAME]
1100 - 1200 | 7 | 201 | 28.71428571428572 |  | [NAME]
1200 - 1300 | 13 | 255 | 19.61538461538462 |  | [NAME]
1300 - 1400 | 16 | 272 | 17 |  | [NAME]
1400 - 1500 | 6 | 1262 | 210.3333333333333 |  | [NAME]
1500 - 1600 | 7 | 162 | 23.14285714285714 |  | [NAME]
1600 - 1700 | 3 | 96 | 32 |  | [NAME]
1700 - 1800 | 15 | 524 | 34.93333333333333 |  | [NAME]
1800 - 1900 | 15 | 395 | 26.33333333333333 |  | [NAME]
1900 - 2000 | 13 | 514 | 39.53846153846154 |  | [NAME]
2000 - 2100 | 8 | 141 | 17.625 |  | [NAME]
2100 - 2200 | 6 | 102 | 17 |  | [NAME]
2200 - 2300 | 2 | 21 | 10.5 |  | [NAME]
2300 - 0000 | 0 | 0 | #N/A
Spreadsheet: 108552d1305604765-help-with-grocery-who-owes-who-spreadsheet-grocery-sample-spreadsheet
Sheet: Sheet1

Name
[NAME] | 100 | Add | 100 |  | Cell D2  IF(C2="Add",B2,0) Simple of statement Testing Cell C2
[NAME] | 100 |  | 0
[NAME] | 100 | Add | 100
[NAME] | 100 |  | 0
[NAME] | 100 | Add | 100
[NAME] | 100 | Add | 100
Spreadsheet: 1af17408-c70e-4675-a425-b4903046df04
Sheet: PR90 - Absence Record

 |  |  |  |  |  |  | FORM PR90
 | ABSENCE RECORD/REQUEST |  |  |  |  |  | Rev. 5/1/2014
 | Employee Name |  | Employee ID | Pay Period Begin Date | Pay Period End Date
This is a request for record of my absence from KCTCS on the dates below for the purpose of:
Vacation Leave  (Requires preapproved - See personnel policy)
SELECT CORRECT EARNINGS CODE FROM DROP DOWN LIST
PS VAC Earnings Codes | [NAME] (Date) | Begin Time | Leave End (Date) | End Time | # hours
Temporary Disability (Sick) Leave ([NAME] to personnel policy)
SELECT CORRECT EARNINGS CODE FROM DROP DOWN LIST
PS SICK Earnings Codes | [NAME] (Date) | Begin Time | Leave End (Date) | End Time | # hours
Other Leave(s)
SELECT CORRECT EARNINGS CODE FROM DROP DOWN LIST
PS OTHER Ern Codes | Leave Being (Date) | Begin Time | Leave End (Date) | End Time | # hours
* Refer to complete list of established paysheet earnings codes for full listing and description of earnings codes.
* FML Note: SIC-FML, VAC-FML and LWO-FML codes should only be selected by employees on an HR approved
Family Medical Leave who are designating vacation, sick, or leave without pay hours as FML hours.
_______________________________________ |  |  | ________________
Employee Signature |  |  | Date
_______________________________________ |  |  | ________________
Approved by ([NAME] or [NAME]) |  |  | Date
_______________________________________ |  |  | ________________
Approved by (Higher Level of Approval if Required) |  |  | Date
Spreadsheet: phillip_m_love__30661__200002Trans_OA
Sheet: Pre2000 Value

PRE - 2000 TRANSPORT BOOK
As of Mar - 2000 GL
 | January |  | February |  | March |  | Total
 | [NAME] | Amount | [NAME] | Amount | [NAME] | Amount | [NAME] | Amount
Transport Revenue - Sharp | 0 | 0 | 0 | 0 | 0 | 0
Transport Revenue - Martin | 0 | 0 | 0 | 0 | 0 | 37174
Transport Revenue - Third Party
Compressor Fuel Expense | 0 | -238267 | 0 | -935406.78 | 0 | -26524.27
Transport Expense - Third Party
Unaccounted for Gas Loss | 0 | -307050 | 0 | 0 | 0
Originations | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 356145d1415006827-password-protection-for-a-range-of-cells-in-a-worksheet-a-required
Sheet: Sheet1

 |  |  |  |  | A
 |  |  |  |  | B
 |  |  |  |  | C
 |  |  |  |  | D
 |  |  |  |  | E
 |  |  |  |  | F
 |  |  |  |  | G
 |  |  |  |  | H
 |  |  |  |  | I
 |  |  |  |  | J
 |  |  |  |  | K
 |  |  |  |  | L
 |  |  |  |  | M
 |  |  |  |  | N
 |  |  |  |  | O
 |  |  |  |  | P
 |  |  |  |  | Q
 |  |  |  |  | R
 |  |  |  |  | S
 |  |  |  |  | T
 |  |  |  |  | U
 |  |  |  |  | V
 |  |  |  |  | W
 |  |  |  |  | X
 |  |  |  |  | Y
 |  |  |  |  | Z
Spreadsheet: paul_lucci__28366__Collar & Swap10_25_01
Sheet: SmryNov_Oct

Kennedy Oil
 | Curve Date | [NAME] |  | Bid | Offer
 | 2001-10-24 00:00:00 | 2001-10-24 00:00:00 | NYMEX | 0 | 0 | 3.23276490425257
 |  |  | Basis | 0 | 0
Basis Location | IF-CIG/RKYMTN
Index Location | none
[NAME] | IF-CIG/RKYMTN
Daily Volume | 10000
SWAP Value
Start | 2001-11-01 00:00:00 | Origination | 0 | 0
End | 2002-10-31 00:00:00
Offer | Swap price = | 2.737805836689541
COSTLESS COLLAR TRANSACTION
 |  | CALL |  |  |  | PUT
Origination | 0 | Call Offer | 0 | Phy1 Fin2 | 2 | [NAME] | 0 | Phy1 Fin2 | 2
Daily Volume | 10000 | [NAME] | 0 | Buy1 Sell2 | 1 | Vol Bid | 0 | Buy1 Sell2 | 2
Start | 2001-11-01 00:00:00
End | 2002-10-31 00:00:00
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2.437805836689541 | 0.235466240103468 | 859451.7763776582
CALL VALUATION | 3.185006845405029 | 0.2354662401043849 | -859451.7763810048
 |  | Total = | -3.346591256558895e-06
PARTICIPATING COSTLESS COLLAR TRANSACTION
 |  | CALL |  |  |  | PUT
Origination | 0 | Call Offer | 0 | Phy1 Fin2 | 2 | [NAME] | 0 | Phy1 Fin2 | 2
End | 37560 | [NAME] | 0 | Buy1 Sell2 | 1 | Vol Bid | 0 | Buy1 Sell2 | 2
Start | 2001-11-01 00:00:00 | Call Volume | 5000
End | 2002-10-31 00:00:00
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2 | 0.09019463984118498 | 329210.4354203251
CALL VALUATION | 3.424015016616689 | 0.1803892796853694 | -329210.4354257991
 |  | Total = | -5.473964847624302e-06
PUT VALUE
PUT
[NAME] | 0 | Phy1 Fin2 | 2
Vol Bid | 0 | Buy1 Sell2 | 2
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2 | 0.09019463984118498 | 329210.4354203251
BASIS SWAP
Basis Location | IF-CIG/RKYMTN |  | Basis Location | NGI-SOCAL
Cost | 0.6021834698105476
Total Cost | 2173431.956098975
Spreadsheet: 541374d1507246222-cant-unhide-rows-weekly-scorecard-template-copy
Sheet: P13

WEEKLY AREA SCORECARD |  |  |  |  |  |  | 2017
THIS FORM MUST BE EMAILED TO AREA COACH BY WEDNESDAY BY 10:00 AM EACH WEEK
Store: |  |  | Food Cost Goal: |  | Labor Goal:
Period #/ Week # | P13 / W1 |  | P13 / W2 |  | P13 / W3 |  | P13 / W4
Dates | 11/29 - 12/5 |  | 12/6 - 12/12 |  | 12/13 - 12/19 |  | 12/20 - 12/26
Customer
GES Overall Satisfied %
# of Surveys
Drive Thru OTD (#.##)
DT Menu Time (#.##)
DT Window Time (#.##)
Front Counter OTD (#.##)
Building Great Teams
Turn Over ( List Names at Bottom of  Sheet)
Crew Hires ( List Names at Bottom of Sheet)
Staffing Target
Current Staffing total
Learningzone Overall Team  %
Learningzone Food Safety %
ACT LIKE OWNERS
Net Sales
Last Year Sales
YOY Sales Growth %
2017 YTD Sales
2016 YTD Sales
YTD Sales Growth %
1 GFS invoice total
2 GFS invoice total
3 GFS invoice total
4 GFS invoice total
1 Pepsi invoice total
2 Pepsi invoice total
Total COS
Food Cost %
$ [NAME] From Target
Hours Used
Labor $
Sales Per Man Hour
Labor %
Labor -/+$$
Overtime $
Refunds $ | 0 |  | 0 |  | 0 |  | 0
Discounts $
Cash +/- $
1 Terminated Team Member Name
Phone Number
2 Terminated Team Member Name
Phone Number
3 Terminated Team Member Name
Phone Number
New Hires This Week
1 New Hire Name
2 New Hire Name
3 New Hire Name
4 New Hire Name
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: ONT_VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ALL
REGION:  ONTARIO
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 698776d1602170557-combining-formulas-indirect-and-lookup-and-vlookup-excel-indirect-lookup
Sheet: App5

Date | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Data9 | Data10
2020-10-05 00:00:00 | 6 | 3 | 4 | 4 | 3 | 5 | 5 | 3 | 3 | 4
2020-10-08 00:00:00 | 5 | 5 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 2
Spreadsheet: 135695d1326191133-excel-2007-using-countifs-to-count-muliple-criteris-from-the-same-column-muliple-counts-witin-one-column-100112
Sheet: Sheet1

MONTH | ACTION | ACTIONS
JAN | OPERATOR | 1
JAN | OUTSOURCE | 2
FEB | REPAIR | 1
JAN | REPAIR | 1
MAR | REPAIR | 1
 | count to obtain the Repair number
 | count to obtain the Operator number
How do i add the 2 together to get the right answer in 1 formula???
Spreadsheet: 268333d1380568551-countbycolor-help-to-change-formula-around-sample
Sheet: August

August | Thursday | Friday | Saturday | Sunday | Monday 5 | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday 6 | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday 7 | Tuesday | Wednesday | Thursdary | Friday | Saturday | Sunday | Monday 8 | Tuesday | Wednesday | Thursdary | Friday | Saturday
 | 1 | 2 | 3 | 4 | 5 | 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 |  | D | Day
[NAME] |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  | N |  |  | D | D | N | N |  |  |  |  | D | D | N |  | N | Night
[NAME] |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N |  | V | Vacation
Greg |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N |  | BD
[NAME] |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N |  | B$
[NAME] |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N | N |  |  |  |  | D | D | N |  | D / N | Overtime
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | Sick
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Office of the Chair

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Annualized | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 55000 | 3
ENATECH | Technology |  |  |  |  |  |  |  | COO | 250000 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | CEO | 250000 | 2
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 5 | 6 |  |  | Other Expense Calculation
 | A&A Headcount |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667
 | Other Expenses | 243106037
Spreadsheet: 483869d1475898550-how-to-lookup-a-cell-that-is-both-along-a-vertical-and-horizontal-logon-report
Sheet: Raw Data

[NAME]
Time logged on |  |  | 09:01:00
Time in status not ready |  |  | 59mins
Time logged off |  |  | 18:03:00
[NAME]
Time logged on |  |  | 08:30:00
Time in status not ready |  |  | 47mins
Time logged off |  |  | 16:37:00
[NAME]
Time logged on |  |  | 10:00:00
Time in status not ready |  |  | 61mins
Time logged off |  |  | 19:00:00