tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879497d1727083189-if-or-xlookup-with-multi-conditions-including-return-highest-value-and-closest-text-match-xlookup-multi-conditions-highest-no-closest-text-match
Sheet: Sheet1

 |  |  |  | Position | Employee ID | PAAF No. | Name | [NAME] |  |  |  |  |  | Emp ID | No | Name | LOC | Position
 |  |  |  | PCM | 50563 |  | C [NAME] | 023-1 |  | 1st formula - As there is an employee ID in column F look that up in colum O & return HIGHEST corresponding no. in column P
 |  |  |  | PCM |  |  | [NAME] | 048-1 |  | 2nd formula - Lookup name in column H, find closest match in column Q & return highest corresponding no. in column P |  |  |  |  | 048-0 | Kelsall, [NAME] | 1 | PCM
 |  |  |  | ABC |  |  |  | 050-1 |  | 3rd formula - As no employee ID nor name, lookup position in column E & find match in column S & return highest no. in column P |  |  |  |  | 048-1 | Kelsall, [NAME] | 1 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50563 | 023-0 | Norris, [NAME] | 2 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50563 | 023-1 | Norris, [NAME] | 2 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 050-1 |  |  | ABC
 |  |  |  |  |  |  |  |  |  | Join 1st, 2nd & 3rd formula together, eg IF there's a value in column F then do 1st formula otherwise do either 2nd formula (based on name) or 3rd formula (lookup the position in E to S)
Spreadsheet: 99452d1298060653-delete-n-a-row-sample1
Sheet: PERFORMANCE

 |  |  | [NAME] or [NAME] or [NAME] |  |  | Adam
Week | ID | Employee | Hour
Spreadsheet: e3bcc62f-aa2f-463b-a991-840feecb1f8f
Sheet: OCTOBER

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-10-01 00:00:00 | TO | 2015-10-31 00:00:00 |  | MO. NO.: |  | 10
Holiday Pay |  |  |  | HP
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 88 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  | 4 |  | 4
 |  |  |  |  |  |  |  | Mass of Holy Spirit | 1 |  | 2 |  | 3
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 18 | Time sheets due | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 25 |  | 26 |  | 27 |  | 28 |  | 29 | Pay day | 30 |  | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 216118d1361595185-workbook-if-formula-not-sure-if-correctly-used-edit_franpietrowski_ver1
Sheet: SHOP_PARTS_TRACKER

auto scrap- inventory log
Part Name/PN | IN-STOCK |  | FULL KITS RECEIVED |  |  |  |  |  | SENT UNITS |  |  | CURRENT INVENTORY/ WEEKLY
Large Backup Ring | 20 | 2 | 12115649R |  |  |  | 3 |  | 4 |  |  | Large Backup Ring | 12
N900004312 |  |  |  |  |  |  |  |  |  |  |  | N900004312
Small Backup Ring | 14 | 2 | 0 |  |  |  |  |  |  |  |  | Small Backup Ring | 14
N900004286 |  |  |  |  |  |  |  |  |  |  |  | N900004286
large O-Ring | 14 | 2 | 0 |  |  |  |  |  |  |  |  | large O-Ring | 14
N900000228 |  |  |  |  |  |  |  |  |  |  |  | N900000228
Small O-Ring | 14 | 2 | 0 |  |  |  |  |  |  |  |  | Small O-Ring | 14
N900000123 |  |  |  |  |  |  |  |  |  |  |  | N900000123
Inlet/Outlet O-RING | 14 | 2 | 0 |  |  |  |  |  |  |  |  | Inlet/Outlet O-RING | 14
N904000020 |  |  |  |  |  |  |  |  |  |  |  | N904000020
Hammer Union Seals | 28 | 4 | R |  |  |  | 1 |  | 2 |  |  | Hammer Union Seals | 20
10182792 |  |  |  |  |  |  |  |  |  |  |  | 10182792
Bearing [NAME] | 56 | 8 | 0 |  |  |  |  |  |  |  |  | Bearing [NAME] | 56
N056010825 |  |  |  |  |  |  |  |  |  |  |  | N056010825
Inlet/Outlet screws | 56 | 8 | 0 |  |  |  |  |  |  |  |  | Inlet/Outlet screws | 56
N900004386 |  |  |  |  |  |  |  |  |  |  |  | N900004386
[NAME] | 65 | 3 | 0 |  |  |  |  |  |  |  |  | [NAME] | 65
N900004265 |  |  |  |  |  |  |  |  |  |  |  | N900004265
[NAME] | 7 | 1 | 0 |  |  |  |  |  |  |  |  | [NAME] | 7
N900004824 |  |  |  |  |  |  |  |  |  |  |  | N900004824
[NAME] | 7 | 1 | 0 |  |  |  |  |  |  |  |  | [NAME] | 7
N900002990 |  |  |  |  |  |  |  |  |  |  |  | N900002990
Actuator [NAME] | 28 | 4 | 0 |  |  |  |  |  |  |  |  | Actuator [NAME] | 28
N900002058 |  |  |  |  |  |  |  |  |  |  |  | N900002058
Actuator Electrical Caps | 8 | 1 | 0 |  |  |  |  |  |  |  |  | Actuator Electrical Caps | 8
N900004119 |  |  |  |  |  |  |  |  |  |  |  | N900004119
CAN BUILD WITH PARTS AVAILABLE |  | 8
 |  | 7
Spreadsheet: 51795d1251393949-average-values-that-contain-text-characters-in-cell-avg_calc
Sheet: Sheet1

Date | Data1 | Data2 |  | Problem
2007-01-01 00:00:00 | 1000 | 1000 |  | 1 | Column B is my data set.  The AVERAGE function ignores the last 4 values that contain the "<" character
2007-04-01 00:00:00 | 900 | 900 |  | 2 | Column C contains the *values* I want to be used for purposes of the AVERAGE function
2007-07-01 00:00:00 | 800 | 800 |  | 3 | Cell C14 contains the *result* I want, but I am unsure how to go about doing this.
2007-09-01 00:00:00 | 700 | 700 |  | 4 | I want to be able to enter a single formula/array in cell B14 to return the value in C14.
2008-01-01 00:00:00 | 600 | 600
2008-04-01 00:00:00 | 500 | 500
2008-07-01 00:00:00 | 400 | 400
2008-09-01 00:00:00 | 300 | 300
2009-01-01 00:00:00 | <100 | 50
2009-04-01 00:00:00 | <100 | 50
2009-07-01 00:00:00 | <50 | 25
2009-09-01 00:00:00 | <50 | 25
Average: | 650 | 445.8333333333333
Spreadsheet: 0bebcf6b-c4aa-4fbc-a6e5-dd8cfb8de3c0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Center for School Options and Finance
Office of Quality School Choice and Funding
SF-6
School-Age Attachment Two
To be used only for those students with EMIS status codes 19 or 1B and
who were NOT included on the SF-14H Form
To be filed by educating district (3323.14 [NAME]) for school year 2011-2012
A. |  |  |  |  |  |  |  |  | IRN
 | Educating District - City, Exempted Village or Local
B. |  |  |  |  |  |  |  |  | IRN
 | Resident District - City, Exempted Village or Local
 |  |  |  |  | Disability |  | EMIS Status |  | Dates of
SSID |  |  |  | Grade | Condition |  | Code |  | Enrollment |  | *Total
Number |  |  |  |  | From |  | From |  |  |  | Days
 |  |  |  |  | Section I C |  | Section I D |  | From | To | Enrolled
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
* A full membership school year is 180 days.
Spreadsheet: kate_symes__18955__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-28 00:00:00 |  | 132.83 | 2768 | 74.97 | 1544
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.89 | 1432 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
Spreadsheet: 42000d1240533152-div-0-error-messages-in-formulas-book1
Sheet: Sheet1

Open/Transfer/Reopen | TRANSFER
Restaurant #
Benchmark Sales | 5000 |  |  |  |  |  |  |  |  |  |  |  | Open | Transfer | Reopen
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN |  |  | -0.7336
Wk 1 (Net 3) | 444 | 444 | 444 |  |  |  |  | 1332 | -0.7336 |  | TRANSFER
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 | -1 |  | REOPEN
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0 | -1 |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Open/Transfer/Reopen | REOPEN |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Restaurant # |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Benchmark Sales |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN |  |  | #N/A
Wk 1 (Net 3) |  |  |  |  |  |  |  | 0 | #N/A |  | TRANSFER | Averages |  | #N/A | #N/A
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 | #N/A |  | REOPEN |  | 0 | 1 | 0
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0 | #N/A |  |  |  | 0 | #N/A | #N/A
Open/Transfer/Reopen | TRANSFER
Restaurant #
Benchmark Sales
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN
Wk 1 (Net 3) |  |  | 444 |  |  |  |  | 444 | #N/A |  | TRANSFER
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 | #N/A |  | REOPEN
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0 | #N/A
Spreadsheet: louise_kitchen__22731__0202MarginRequirements
Sheet: 0204

FUTURES MARGIN REQUIREMENTS
2002-02-05 00:00:00
2002-02-04 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.6990000053192489 |  | 0.6990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.6990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4387232.163952487 |  | 4387232.163952487 | 0 | 0 |  | 0 |  |  |  | 4387232.163952487 |  |  |  | 0
CREDIT SUISSE FIRST BOSTON | 29883.61000000313 |  | 29883.61000000313 | 0 | 0 |  | 0 |  |  |  | 29883.61000000313 |  |  |  | 0
EDF MAN | 8393692.295999765 |  | 8393692.295999765 | 0 | 0 |  | 0 |  |  |  | 8393692.295999765 |  |  |  | 0
FIMAT | 2275935.16 |  | 2275935.16 | 0 | 0 |  | 0 |  |  |  | 2275935.16 |  |  |  | 0
HSBC - US$ | -2131.681408999983 |  | -2131.681408999983 | 0 | 0 |  | 0 |  |  |  | -2131.681408999983 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | 0.3928424186306074 |  | 0.3928424186306074 | 0 | 0 |  | 0 |  |  |  | 0.3928424186306074 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS | 95658494.73538579 | 0 | 95658494.73538579 | 0 | 0 | 0 | 0 |  | 0 |  | 95658494.73538579 |  | 64204.5 | 0 | 0
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 95658494.73538579
 |  |  |  |  |  |  |  |  |  |  |  |  | 95658494.73538579
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: Summary L1

 | LLC |  | Life Cycle Costs Analysis |  |  | 60 | Years
 |  | Ref | BCIS | Annual Amount | Life Cycle Cost | Escalated Life Cycle Cost | Total Present Value
 | Construction Costs | 1.0 | Construction Costs
 |  | 1.1 | Construction works costs
 |  | 1.2 | Other construction related costs
 |  | 1.3 | Client definable costs |  | 0
 |  |  | Total Construction Costs
 | Maintenance, Operations and Occupancy Costs | 2.0 | Maintenance Costs
 |  |  | Total Maintenance Costs
 |  | 3.0 | Operations Costs
 |  |  | Total Operations Costs
 |  | 4.0 | Occupancy Costs
 |  |  | Security
 |  |  | Total Occupancy Costs
 | End of Life | 5.0 | End of Life Costs
 |  | 5.1 | Disposal Inspections
 |  | 5.2 | Demolitions
 |  | 5.3 | Reinstatement costs
 |  | 5.4 | Salavge costs
 |  | 5.5 | Client definable costs
 |  |  | Total End of Life Costs
 | [NAME] | 6.0 | Non Construction Costs
 |  | 6.1 | Land and enabling works
 |  | 6.2 | Finance costs
 |  | 6.3 | Rent costs
 |  | 6.4 | Strategic estate management
 |  | 6.5 | Space charges
 |  | 6.6 | Taxes on costs
 |  | 6.7 | Client definable costs
 |  |  | Total Non Construction Costs
 |  | 7.0 | Income
 |  | 7.1 | Income from Sales
 |  | 7.2 | Third party income during occupation
 |  | 7.3 | Taxes on income
 |  | 7.4 | Loss of income
 |  | 7.5 | Client definable costs
 |  |  | Total Income
 |  | 8.0 | Externalities
 |  |  | Total Externalities
 | WLCC |  | [NAME] (Not Including Construction Costs)
Spreadsheet: 785381d1656381173-returning-array-data-filtered-and-in-a-specific-format-sample
Sheet: Sheet1

DATA_ARRAY
 | Alpha | [NAME]
 | Beta
 | Gamma | [NAME] | Kiwi | Orange
 | Delta
 | Tau | Lemon | Grape
RETURNED
 | Alpha | [NAME]
 | Beta
 | Gamma | [NAME]
 | Gamma | Kiwi
 | Gamma | Orange
 | Delta
 | Tau | Lemon
 | Tau | Grape
Spreadsheet: 901142a8-924b-4962-aeda-4d283ed754da
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
SENIOR HIGH SCHOOL - LUNCH MENU
 |  | JUNE 2012
HOT LUNCH MENU
MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY
 |  |  |  | 1
 |  |  |  | BIG DADDY'S PIZZA             (plain or pepperoni)
 |  |  |  | CHICKEN NUGGETS   MEATBALL HERO
 |  |  |  | TOSSED SALAD    BAKED FRIES
4 | 5 | 6 | 7 | 8
NACHOS SUPREME W/TACO MEAT & CHEESE | STEAKUM W/CHEESE | PIZZA MAXX STIX W/MARINARA SAUCE | CHOICE OF 2: HAMBURGER, HOT DOG OR CHICKEN PATTIE | BIG DADDY'S PIZZA             (plain or pepperoni)
 | CHICKEN DELUXE ON BUN | SPICY BUFFALO CHICKEN SANDWICH | MEATBALL HERO | CHICKEN NUGGETS   MEATBALL HERO
VEGETABLE [NAME] | HASH BROWN POTATO | STRING BEAN SALAD | TOMATO SALAD          BAKED FRIES | TOSSED SALAD    BAKED FRIES
11 | 12
CHICKEN NUGGETS | LAST DAY OF LUNCH
PIZZA (PLAIN OR PEPPERONI | COLD SANDWICHES
HOT CORN | POTATO SALAD
COMPLETE LUNCHES INCLUDE: 1 ENTRÉE, 2 SIDES & MILK OR 1 SALAD PLATE ENTRÉE, 1 SIDE & MILK
SIDES VARY DAILY AND MAY INCLUDE: POTATOES, [NAME], [NAME], PASTA, VEGETABLES, CANNED OR FRESH FRUIT, JUICE OR [NAME]
SALAD LUNCHES & LUNCH WRAPS
 |  | CHOICES:
EGG SALAD, TUNA SALAD, CHEF SALAD, CHICKEN CEASAR SALAD
TURKEY WRAP, TUNA WRAP, ASSORTED CHICKEN WRAPS (SELECTIONS WILL CHANGE DAILY)
 | A LA CARTE CHOICES
BAGELS, ROLLS, FRESH FRUIT, ICE CREAM, CHIPS, COOKIES, LOW FAT MUFFINS, SOFT PRETZELS, YOGURT,  CHOICE OF HEALTHIER  SNACKS & DRINKS
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | 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
Spreadsheet: 19a25403-f00a-4f85-913c-024c0d67fcc5
Sheet: Part-time and part-year 2

 | PART-TIME, PART-YEAR STAFF: CALCULATING FTE AND HOLIDAY ENTITLEMENT
 | ALL LEAVE TO BE TAKEN OUTSIDE OF THE CONTRACTED WORKING WEEKS
 |  |  |  |  | C | A | B
 | This calculator will pro-rata the holiday entitlement for a part-time member of staff who works for a defined number of weeks in the year. Cells shown in orange will be completed by the calculator.
(a) | Grade of employee (pick from list)
 | Holiday entitlement (fte - shown in days )
 | Enter hours the part-timer works per week
 | Enter number of weeks worked in the year
 | Proportion of FTE
 | Pro-rata entitlement in hours |  |  | Formula = (A + D x B) x (E / C x 100) / 100
 | Including all Bank and University Holidays (round up to nearest hour)
 | Back to menu
Spreadsheet: 691736d1597847847-vlookup-and-count-excel
Sheet: Sheet2

Input colour
Red
 |  |  |  |  |  |  |  | I tried like this but not working
firsttry |  | secondtry |  | thirdtry |  |  |  | firsttry |  | secondtry |  | thirdtry
pass | 3 | pass | 5 | pass | 3 |  |  | pass |  | pass |  | pass
fail | 3 | fail | 1 | fail | 3 |  |  | fail |  | fail |  | fail
Spreadsheet: 874323d1720894071-textjoin-function-and-value-error-mc
Sheet: CM

 |  | C Statement | M Count | Linked Ms | Weightage
 | C-1 | dfadsf | 18 | MLO-2.2.1 - - MLO-2.3.3 - - MLO-3.3.1 - - MLO-4.1.2 - - MLO-5.3.2 - - MLO-5.4.2 - - MLO-6.2.1 - - MLO-6.3.1 - - MLO-7.1.1 - - MLO-8.3.2 - - MLO-9.4.3 - - MLO-9.6.2 - - MLO-10.1.2 - - MLO-11.1.2 - - MLO-12.2.2 - - MLO-12.3.2 - - MLO-13.1.2 - - MLO-14.1.1 | 0.1224489795918367
 | C-2 | sdfsdf | 21 | #[NAME]! | 0.1428571428571428
 | C-3 | sfasd | 18 | MLO-1.1.3 - - MLO-1.2.1 - - MLO-2.8.1 - - MLO-3.4.2 - - MLO-3.4.3 - - MLO-3.5.1 - - MLO-3.6.1 - - MLO-3.7.1 - - MLO-3.7.2 - - MLO-5.1.1 - - MLO-5.2.2 - - MLO-7.2.1 - - MLO-7.2.2 - - MLO-10.5.1 - - MLO-10.6.1 - - MLO-10.6.2 - - MLO-11.3.2 - - MLO-12.1.2 | 0.1224489795918367
 | [NAME] | fsdfgfdgfh | 28 | #[NAME]! | 0.1904761904761905
 | C-5 | hghgf | 33 | #[NAME]! | 0.2244897959183673
 | C-6 | fhfg | 29 | #[NAME]! | 0.1972789115646258
Spreadsheet: 44488d1243253362-conditional-v-lookup-at-multiple-lines-book2
Sheet: Sheet2

doc_type | doc_no | doc_date | item no | fdesp | finvqty
PUR | 967 | 2008-10-29 00:00:00 | ABC | Mattress | 8
PUR | 789 | 2008-09-20 00:00:00 | ABC | Mattress | 15
PUR | 567 | 2008-06-29 00:00:00 | ABC | Mattress | 10
PUR | 123 | 2008-05-20 00:00:00 | ABC | Mattress | 10
Spreadsheet: 478693d1472985630-rag-using-conditional-formatting-use-a-formula-to-determine-which-cells-to-format-rag
Sheet: RAG

 | Used | Unused | Total
 | 13 | 21 |  |  | =B2/C2<50
 | 20 | 14 |  |  | =AND(B3/D3>=50,B3/D3<80)
 | 30 | 4 |  |  | =B4/C4>=80
 | >=80 % highlight it with Green
 | >=50% but <80% highlight it with Amber
 | <50% highlight it with Red
Spreadsheet: 40521d1238854699-multiple-conditions-example_excel_forum
Sheet: July

Date/Time | Data |  |  |  | Day
2008-07-01 00:00:32 | 0.5 |  |  |  | 1 | 2.5
2008-07-01 00:01:32 | 0.3 |  |  |  | 2 | 0
2008-07-01 00:02:32 | 0.2 |  |  |  | 3 | 0
2008-07-01 00:03:32 | 0.1 |  |  |  | 4 | 0
2008-07-01 00:04:32 | 0 |  |  |  | 5 | 0
2008-07-01 00:05:32 | 0 |  |  |  | 6 | 0
2008-07-01 00:06:32 | 0 |  |  |  | 7 | 0
2008-07-01 00:07:32 | 0 |  |  |  | 8 | 9.36
2008-07-01 00:08:32 | 0 |  |  |  | 9 | 0
2008-07-01 00:09:32 | 0.5 |  |  |  | 10 | 0
2008-07-01 00:10:32 | 0.9 | 2.5 |  |  | 11 | 0
2008-07-08 03:32:30 | 0.72 |  |  |  | 12 | 0
2008-07-08 03:33:30 | 0.72 |  |  |  | 13 | 0
2008-07-08 03:34:30 | 0.72 |  |  |  | 14 | 0
2008-07-08 03:35:30 | 0.72 |  |  |  | 15 | 0
2008-07-08 03:36:30 | 0.72 |  |  |  | 16 | 0
2008-07-08 03:37:30 | 0.72 |  |  |  | 17 | 0
2008-07-08 03:38:30 | 0.72 |  |  |  | 18 | 0
2008-07-08 03:39:30 | 0.72 |  |  |  | 19 | 0
2008-07-08 03:40:30 | 0.72 |  |  |  | 20 | 0
2008-07-08 03:41:30 | 0.72 |  |  |  | 21 | 0
2008-07-08 03:42:30 | 0.72 |  |  |  | 22 | 0
2008-07-08 03:43:30 | 0.72 |  |  |  | 23 | 0
2008-07-08 03:44:30 | 0.72 | 9.36 |  |  | 24 | 0
 |  |  |  |  | 25 | 0
 |  |  |  |  | 26 | 0
 |  |  |  |  | 27 | 0
 |  |  |  |  | 28 | 0
 |  |  |  |  | 29 | 0
 |  |  |  |  | 30 | 0
 |  |  |  |  | 31 | 0
Spreadsheet: 758704d1639025187-using-sumif-with-criteria-and-sorted-by-month-pyplynr-example
Sheet: Monthly

Livestock Costs | 2021-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | YEAR
Shipping
Office supplies
Maintanance
Subtotal