tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846296d1697553258-calculating-hours-worked-overtime-kirsten
Sheet: Semester 1 2023

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours worked | Running total of overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2023-09-18 00:00:00 | Mon | 07:50:00 |  | 16:30:00
2023-09-19 00:00:00 | Tue
2023-09-20 00:00:00 | Wed | 07:50:00 |  | 16:30:00
2023-09-21 00:00:00 | Thu
2023-09-22 00:00:00 | Fri
2023-09-23 00:00:00 | Sat
2023-09-24 00:00:00 | Sun | 12:00:00 |  | 12:20:00
2023-09-25 00:00:00 | Mon | 08:15:00 |  | 16:50:00
2023-09-26 00:00:00 | Tue
2023-09-27 00:00:00 | Wed
2023-09-28 00:00:00 | Thu | 07:50:00 | 00:15:00 | 16:45:00
2023-09-29 00:00:00 | Fri | 07:00:00 | 00:30:00 | 14:15:00 |  |  | 00:15:00
2023-09-30 00:00:00 | Sat
2023-10-01 00:00:00 | Sun
2023-10-02 00:00:00 | Mon | 08:05:00 | 00:30:00 | 17:15:00
2023-10-03 00:00:00 | Tue | 07:05:00 | 00:15:00 | 17:30:00
2023-10-04 00:00:00 | Wed | 08:05:00 | 00:30:00 | 17:30:00
2023-10-05 00:00:00 | Thu | 08:00:00 |  | 17:00:00
2023-10-06 00:00:00 | Fri | 08:20:00 |  | 12:20:00 |  |  | 03:00:00
2023-10-07 00:00:00 | Sat
2023-10-08 00:00:00 | Sun | 10:50:00 |  | 11:30:00
2023-10-09 00:00:00 | Mon | 08:15:00 |  | 16:50:00
2023-10-10 00:00:00 | Tue | 08:15:00 |  | 16:45:00
2023-10-11 00:00:00 | Wed | 08:15:00 |  | 16:55:00
2023-10-12 00:00:00 | Thu | 08:05:00 | 00:30:00 | 16:50:00
2023-10-13 00:00:00 | Fri | 08:00:00 |  | 13:00:00 |  |  | 02:00:00
2023-10-14 00:00:00 | Sat
2023-10-15 00:00:00 | Sun | 08:15:00 |  | 11:40:00
2023-10-16 00:00:00 | Mon | 08:00:00 | 00:30:00 | 17:00:00
2023-10-17 00:00:00 | Tue | 09:30:00
2023-10-18 00:00:00 | Wed
2023-10-19 00:00:00 | Thu
2023-10-20 00:00:00 | Fri
2023-10-21 00:00:00 | Sat
2023-10-22 00:00:00 | Sun
2023-10-23 00:00:00 | Mon
2023-10-24 00:00:00 | Tue
2023-10-25 00:00:00 | Wed
2023-10-26 00:00:00 | Thu
2023-10-27 00:00:00 | Fri
2023-10-28 00:00:00 | Sat
2023-10-29 00:00:00 | Sun
2023-10-30 00:00:00 | Mon
2023-10-31 00:00:00 | Tue
2023-11-01 00:00:00 | Wed
2023-11-02 00:00:00 | Thu
2023-11-03 00:00:00 | Fri
2023-11-04 00:00:00 | Sat
2023-11-05 00:00:00 | Sun
2023-11-06 00:00:00 | Mon
2023-11-07 00:00:00 | Tue
2023-11-08 00:00:00 | Wed
2023-11-09 00:00:00 | Thu
2023-11-10 00:00:00 | Fri
2023-11-11 00:00:00 | Sat
2023-11-12 00:00:00 | Sun
2023-11-13 00:00:00 | Mon
2023-11-14 00:00:00 | Tue
2023-11-15 00:00:00 | Wed
2023-11-16 00:00:00 | Thu
2023-11-17 00:00:00 | Fri
2023-11-18 00:00:00 | Sat
2023-11-19 00:00:00 | Sun
2023-11-20 00:00:00 | Mon
2023-11-21 00:00:00 | Tue
2023-11-22 00:00:00 | Wed
2023-11-23 00:00:00 | Thu
2023-11-24 00:00:00 | Fri
2023-11-25 00:00:00 | Sat
2023-11-26 00:00:00 | Sun
2023-11-27 00:00:00 | Mon
2023-11-28 00:00:00 | Tue
2023-11-29 00:00:00 | Wed
2023-11-30 00:00:00 | Thu
2023-12-01 00:00:00 | Fri
Spreadsheet: 32603d1228786597-if-formula-question-payouts
Sheet: Sheet1

 | Threshold | Goal | Total | Revised |  |  |  | Threshold | Goal | Total |  |  |  | Threshold | Goal | Total
 | 3941 | 5053 | 4995 | 527 | 130 |  |  | 3621 | 4643 | 4210 | 294.5 | 228 |  | 2981 | 3821 | 5035 | 2241 | 1073
 | 3102 | 3977 | 6550 | 4297 | 3255 |  |  | 3686 | 4725 | 3760 | 37 | 327 |  | 3528 | 4523 | 7355 | 4745.5 | 4087
 | 6261 | 8027 | 7955 | 847 | 370 |  |  | 5413 | 6940 | 5115 | -149 | 334 |  | 4589 | 5883 | 6750 | 1947.5 | 1680
 | 5848 | 7499 | 10405 | 5184.5 | 1233 |  |  | 6408 | 8216 | 6770 | 181 | 200 |  | 4427 | 5675 | 5765 | 759 | 1108
 | 3301 | 4189 | 5750 | 2785.5 | 623 |  |  | 3418 | 4339 | 4360 | 492 | 1000 |  | 3333 | 4230 | 3995 | 331 | 399
 | 3234 | 4146 | 4345 | 754.5 | 1487 |  |  | 2987 | 3830 | 2050 | -468.5 | 0 |  | 2736 | 3508 | 2765 | 14.5 | 200
 | 2685 | 3442 | 4510 | 1980.5 | 1345 |  |  | 2890 | 3705 | 2790 | -50 | 0 |  | 2625 | 3365 | 3380 | 392.5 | 1170
 | 4838 | 6203 | 7580 | 2748 | 2645 |  |  | 3759 | 4819 | 4355 | 298 | 0 |  | 3818 | 4895 | 4385 | 283.5 | 0
 | 2537 | 3252 | 2820 | 141.5 | 85 |  |  | 1952 | 2502 | 2165 | 106.5 | 309.5 |  | 2282 | 2926 | 4450 | 2608 | 1278
 | 4510 | 5782 | 4190 | -160 | 0 |  |  | 2908 | 3729 | 3230 | 161 | 0 |  | 3710 | 4756 | 4405 | 347.5 | 148
 | 4386 | 5623 | 5495 | 554.5 | 178 |  |  | 3180 | 4077 | 2840 | -170 | 0 |  | 2445 | 3135 | 3170 | 397.5 | 732
 | 3422 | 4387 | 3480 | 29 | 200 |  |  | 2874 | 3684 | 3250 | 188 | 221 |  | 2297 | 2945 | 3030 | 451.5 | 1065
 | 1572 | 2016 | 2305 | 655.5 | 793 |  |  | 1601 | 2053 | 1300 | -150.5 | 200 |  | 2954 | 3787 | 3170 | 108 | 344
 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 2703 | 3466 | 3920 | 1062.5 | 1601
 |  |  |  | 20344.5 | 12344 |  |  |  |  |  | 770 | 2819.5 |  |  |  |  | 15689.5 | 14885
Payouts
0.5
1.5 |  |  |  |  |  | `
Revised Total
36804
Actual Total
30048.5
0
Spreadsheet: 149377d1333901245-using-vlookup-with-separate-worksheets-e02m3grades_ballardcharles
Sheet: Grades

[NAME]
Course: | CS 101 Intro to C# Programming
Section: | 601
Professor: | Dr. [NAME]
Passing Score | 70
Name | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A-Avg | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10 | L-Total | M1 | M2 | M-Avg | Final | Total Pts | Letter | Pass/Fail
Atkin | 100 | 95 | 85 | 100 | 95 | 90 | 85 |  | 10 | 10 | 10 | 9 | 10 | 9 | 8 | 10 | 8 | 9 |  | 90 | 84 |  | 88
Bailey | 90 | 90 | 100 | 90 | 85 | 100 | 95 |  | 10 | 9 | 10 | 10 | 10 | 10 | 8 | 9 | 9 | 10 |  | 94 | 90 |  | 96
Basquez | 75 | 90 | 75 | 85 | 0 | 75 | 60 |  | 10 | 10 | 8 | 10 | 10 | 8 | 7 | 7 | 8 | 7 |  | 78 | 70 |  | 68
Ethington | 65 | 75 | 70 | 60 | 50 | 70 | 75 |  | 5 | 7 | 8 | 0 | 10 | 7 | 3 | 5 | 8 | 9 |  | 60 | 64 |  | 58
Isham | 75 | 85 | 80 | 70 | 75 | 85 | 70 |  | 10 | 9 | 10 | 10 | 9 | 8 | 8 | 10 | 7 | 0 |  | 82 | 74 |  | 82
[NAME] | 90 | 95 | 95 | 100 | 85 | 80 | 85 |  | 10 | 10 | 10 | 9 | 10 | 9 | 9 | 9 | 10 | 10 |  | 84 | 90 |  | 80
[NAME] | 70 | 80 | 0 | 75 | 60 | 65 | 75 |  | 9 | 9 | 10 | 9 | 8 | 8 | 7 | 6 | 0 | 5 |  | 70 | 66 |  | 62
[NAME] | 75 | 80 | 80 | 85 | 70 | 65 | 75 |  | 8 | 10 | 10 | 9 | 10 | 8 | 8 | 8 | 7 | 8 |  | 74 | 76 |  | 80
Myers | 100 | 100 | 100 | 95 | 90 | 100 | 100 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  | 96 | 90 |  | 94
Noakes | 95 | 85 | 80 | 90 | 90 | 80 | 85 |  | 8 | 9 | 9 | 10 | 8 | 7 | 8 | 8 | 7 | 8 |  | 74 | 78 |  | 84
Nuvek | 75 | 75 | 85 | 85 | 80 | 70 | 75 |  | 8 | 8 | 10 | 9 | 10 | 8 | 9 | 8 | 7 | 8 |  | 82 | 78 |  | 74
O'Hair | 75 | 55 | 0 | 70 | 50 | 75 | 0 |  | 8 | 7 | 0 | 8 | 9 | 7 | 5 | 6 | 4 | 7 |  | 56 | 52 |  | 60
Peugh | 85 | 95 | 95 | 100 | 95 | 95 | 100 |  | 10 | 9 | 10 | 10 | 10 | 10 | 10 | 9 | 9 | 10 |  | 94 | 90 |  | 88
Pulley | 100 | 85 | 90 | 85 | 95 | 95 | 95 |  | 7 | 6 | 8 | 10 | 8 | 8 | 8 | 7 | 6 | 5 |  | 76 | 84 |  | 74
Rodarte | 90 | 85 | 90 | 75 | 85 | 90 | 90 |  | 8 | 9 | 7 | 10 | 10 | 8 | 10 | 8 | 9 | 7 |  | 82 | 76 |  | 86
Sager | 75 | 60 | 85 | 70 | 80 | 75 | 70 |  | 10 | 8 | 6 | 8 | 7 | 7 | 4 | 0 | 5 | 7 |  | 50 | 64 |  | 68
Smith | 85 | 70 | 70 | 75 | 80 | 75 | 0 |  | 6 | 0 | 8 | 8 | 7 | 8 | 0 | 6 | 5 | 8 |  | 54 | 50 |  | 48
Stanworth | 85 | 75 | 70 | 60 | 80 | 70 | 85 |  | 0 | 5 | 8 | 10 | 8 | 8 | 8 | 7 | 8 | 7 |  | 68 | 62 |  | 74
[NAME] | 80 | 100 | 95 | 95 | 90 | 85 | 95 |  | 10 | 10 | 9 | 9 | 10 | 9 | 10 | 9 | 9 | 10 |  | 98 | 96 |  | 100
Takahashi | 75 | 80 | 80 | 85 | 75 | 80 | 80 |  | 9 | 8 | 9 | 10 | 8 | 8 | 8 | 7 | 8 | 7 |  | 86 | 90 |  | 94
[NAME] | 55 | 70 | 75 | 75 | 70 | 80 | 0 |  | 0 | 5 | 8 | 8 | 9 | 8 | 9 | 6 | 7 | 7 |  | 78 | 74 |  | 74
Uribe | 100 | 95 | 95 | 100 | 90 | 100 | 80 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  | 96 | 100 |  | 100
[NAME] | 80 | 75 | 85 | 55 | 70 | 74 | 76 |  | 8 | 0 | 7 | 8 | 8 | 9 | 8 | 8 | 9 | 8 |  | 74 | 68 |  | 64
Statistics
Average
Median
Low Score
High Score
Categories | Weights
Assignments | 0.3
Labs | 0.1
Midterms | 0.35
Final Exam | 0.25
Spreadsheet: 801403d1666187954-data-retrieval-from-multiple-sheets-for-multiple-variables-excel-file
Sheet: 2320200

 |  |  | Text | Tr.Prt | Clearing | Pstng Date | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. |  | Deals | Amount in doc currency
 |  |  | MM UXRSTL 6605 Start |  |  | 2022-09-16 00:00:00 | 2022-09-22 00:00:00 |  |  | -80000000 | [NAME]
 |  |  | Reclass |  |  | 2016-11-25 00:00:00 | 2016-11-25 00:00:00 |  |  | 0 | [NAME]
 |  |  |  |  |  | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 |  |  | 0 | [NAME]
Spreadsheet: benjamin_rogers__1068__gencomodel
Sheet: IS

ID | 1 | Plant Type |  |  | Income Statement & Diagnostic Worksheet
Capacity
Disc. Rt.
Life
Unit |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | TV
Capacity
 | Revenue | 0
 | Fuel | 0
 | Variable O&M | 0
 | SO2 Costs | 0
 | NOx Costs | 0
 | Prod. Margin | 0
 | Fixed O&M | 0
 | Property Tax | 0
 | A&G | 0
 | Operating Income | 0
 | Depreciation | 0
 | Total Tax | 0
 | Net Margin | 0
 | Depreciation | 0
 | [NAME] | 0
 | Env Cap Ads | 0
 | Free Cash Flow
Unlevered | NPV ('00-'05) |  |  | Levered
 | NPV ('06-'19)
 | NPV (TV)
 | NPV
 | Net Income Calculation
Add Back: | Net Cash Income Per Above
 | Income Taxes (Per Cash Flow)
 | Tax Depreciation (Per Cash Flow)
 | EBITDA
Less: | Book Depreciation
 | Interest Expense
 | Earnings Before Income Taxes
 | Income Taxes
 | Net Income - GAAP Basis
Leveraged Cash Flows
Leverage Level
FMV of Assets/Borrowing
Amortization Period Years
Princ PMTS
Interest Rate
Beginning Balance
Interest Payment
Principal Payments
Total Payments
Ending Balance
Tax Benefit of Interest
Total Debt Payments (after-tax)
Cash Flows Modified for Leverage
 | NPV ('00-'05)
 | NPV ('06-'19)
 | NPV (TV)
 | Plus Leverage
 | NPV
Diagnostics
 |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Generation Data
 | Gen. (Mwh)
 | [NAME]. Factor
Vaiable Costs ($/Mwh)
 | Revenue
 | Fuel
 | Var. O&M
 | SO2
 | NOx
Fixed Costs ($/Kw)
 | Fixed O&M
 | PTax
 | A&G
 | [NAME]
 | Env. [NAME]
Spreadsheet: 03c397ab-585c-4830-9cc9-cdfd2b3aad40
Sheet: Sheet1

8(a) STARS Orders as of September 30, 2012 | Unnamed: 1
In Obligated Dollars
Agency Name | Total Order
ARMY | 249053612.65
CONSUMER PRODUCT SAFETY COMMISSION | 4188686.36
CORPS OF CIVIL ENGINEERS | 5284849.4
DEPARTMENT OF AGRICULTURE | 277168914.2800002
DEPARTMENT OF COMMERCE | 128498496.38
DEPARTMENT OF DEFENSE | 594790859.74
DEPARTMENT OF EDUCATION | 3842380.86
DEPARTMENT OF ENERGY | 15025294.87
DEPARTMENT OF HEALTH AND HUMAN SERVICES | 240050859.11
DEPARTMENT OF HOMELAND SECURITY | 167495039.22
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT | 196818623.1499999
DEPARTMENT OF INTERIOR | 153564419.4800001
DEPARTMENT OF JUSTICE | 288787182.05
DEPARTMENT OF LABOR | 39508416.86999999
DEPARTMENT OF STATE | 103856359.71
DEPARTMENT OF THE AIR FORCE | 244958465.3699998
DEPARTMENT OF THE NAVY | 145453994.7799999
DEPARTMENT OF THE TREASURY | 186523696.11
DEPARTMENT OF TRANSPORTATION | 56392105.76
DEPARTMENT OF VETERANS AFFAIRS | 107774026.55
ENVIRONMENTAL PROTECTION AGENCY | 150628610.6
EXECUTIVE OFFICE OF THE PRESIDENT | 6326519.63
FEDERAL COMMUNICATIONS COMMISSION | 755157.36
FEDERAL DEPOSIT INSURANCE CORPORATION | 2183757.6
FEDERAL MARITIME COMMISSION | 315925
FEDERAL MEDIATION AND CONCILIATION SERVICE | 1237950.18
GENERAL ACCOUNTING OFFICE | 2355719.18
GENERAL SERVICES ADMINISTRATION | 375037502.2399999
GOVERNMENT AGENCY - NOT OTHERWISE SPECIFIED | 267723373
INDEPENDENT U.S. GOVERNMENT OFFICES | 1944771.74
[NAME] OF CONGRESS | 6716869.67
NATIONAL AERONAUTICS AND SPACE ADMINISTRATION | 16204246.89
NATIONAL ARCHIVES AND RECORDS ADMINISTRATION | 681149.75
NATIONAL LABOR RELATIONS BOARD | 8542849.690000001
NATIONAL SCIENCE FOUNDATION | 10995664
NUCLEAR REGULATORY COMMISSION | 2520994.95
OFFICE OF PERSONNEL MANAGEMENT | 4163317.75
SECURITIES AND EXCHANGE COMMISSION | 5324009.060000001
SELECTIVE SERVICE SYSTEM | 1026793.16
SMALL BUSINESS ADMINISTRATION | 2296391.07
SMITHSONIAN INSTITUTION | 14306.5
SOCIAL SECURITY ADMINISTRATION | 17688437.57
STATE AND LOCAL GOVERNMENTS | 1663497.16
THE JUDICIAL BRANCH | 1477379.55
Grand Total | 4096861475.999999
Spreadsheet: 879425d1726919395-dept-and-date-to-auto-calculate-based-on-todays-date-book1-6-
Sheet: Sheet2

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery
 | Deli
 | Meat
 | Freezer
 | Produce
Spreadsheet: 86700d1286658643-sum-where-application-employees-diff-but-charge-code-same-dummy-sample-dupes-1-
Sheet: Data Dump Tab

 | Name | ID |  | Proj ID | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
 | [NAME] | 1111 | App 1 | 55555 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | [NAME] | 1111 |  | 121212
 | [NAME] | 1111 |  | 3232323
 | [NAME] | 2222 | App 2 | 55555 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
 | [NAME] | 2222 |  | 121212
 | [NAME] | 1111 | App 3 | 434343 | 1 | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 | 28 | 31 | 34
 | [NAME] | 1111 |  | 434356
 | [NAME] | 2222 |  | 68757
 | [NAME] | 2222 |  | 76578
 | Mart Doe | 3333 |  | 24565
 | Mart Doe | 3333 | App 1 | 55555 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48
 | Mart Doe | 3333 | App 2 | 3232323 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36
 | Mart Doe | 3333 |  | 345345
 | Mart Doe | 3333 |  | 654645
 | [NAME] | 2222 |  | 3232323
 | [NAME] | 2222 | App 1 | 55555 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80 | 88 | 96
 | [NAME] | 2222 |  | 343434
 | Mart Doe | 3333 |  | 34534636
 | Mart Doe | 3333 |  | 234324
Spreadsheet: 740182d1626213536-countif-not-working-with-true-criterion-functional-detailed-cs-schedule-sample
Sheet: Attendance

 | Contract Schools |  |  |  |  |  | Sheets
 | Name | A | UA | T | Notes |  | Sunday
 |  |  |  |  |  |  | Monday
 |  |  |  |  |  |  | Tuesday
 |  |  |  |  |  |  | Wednesday
 |  |  |  |  |  |  | Thursday
 |  |  |  |  |  |  | Friday
 |  |  |  |  |  |  | Saturday
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: Apr 19

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
 |  |  |  |  | 713/853-9781 (Phone)
 |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-04-19 00:00:00 |  | End Date: | 2002-04-30 00:00:00
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
17-1436-00 | Conger | Conoco System Supply | 0 | 0.01 | 0
17-1240-50 | NNG Sprayberry | 107903 | 5000 | 0.01 | 4950
17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01 | 0
17-7462-50 | [NAME] | 5268 | 0 | 0.01 | 0
17-0071-00 | [NAME] | at plant | 0 | 0.01 | 0
17-3000-00 | [NAME] |  | 25000 | 0.01 | 24750
DELIVERY POINT INFORMATION:
STATION # | [NAME] | DOWNSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 | 30000 |  | 30000
FYI:  Buy/Sell Information
17-1240-50 | NNG Sprayberry | 107903 | 5000 | 0.01 | 4950 | sold to TXU K501
17-1436-00 | Conger | Conoco System Supply | 10000 | 0.01 | 9900 | sold to TXU K501
Spreadsheet: 385745d1427401098-conditional-formatting-entire-row-based-on-date-test-cf
Sheet: Sheet1

A | B | C | Date
Pink | Tall | Dad | 2015-01-25 00:00:00
Red | Small | Mom | 2015-03-10 00:00:00
[NAME] | Furry | Puppy | 2015-04-01 00:00:00
[NAME] | [NAME] | Son | 2015-06-25 00:00:00
[NAME] | Fat | Meg | 1900-01-01 00:00:00
Spreadsheet: 677643d1589451163-means-to-identify-the-last-version-of-data-in-two-columns-excel-help
Sheet: Feuil2

 | Reference | Revision |  | Idea1 | Solution1
 | AAA-BB1111-CC-DDD-000-100004 | A
 | AAA-BB1111-CC-DDD-000-100004 | B
 | AAA-BB1111-CC-DDD-000-100004 | C
 | AAA-BB1111-CC-DDD-000-100004 | D
 | AAA-BB1111-CC-DDD-000-100004 | E
 | AAA-BB1111-CC-000-000-100003 | A
 | AAA-BB1111-CC-000-000-100003 | B
 | AAA-BB1111-CC-000-000-100003 | C
 | AAA-BB1111-CC-000-000-100003 | D
 | AAA-BB1111-CC-EEE-FFFF-000099 | A
 | AAA-BB1111-CC-EEE-FFFF-000099 | B
 | AAA-BB1111-CC-EEE-FFFF-000099 | C
 | AAA-BB1111-CC-EEE-FFFF-000099 | D
 | AAA-BB1111-CC-EEE-FFFF-000099 | E
 | AAA-BB1111-CC-EEE-FFFF-000099 | F
 | AAA-BB1111-CC-EEE-FFFF-000099 | G
 | AAA-BB1111-CC-EEE-FFFF-000099 | H
 | AAA-BB1111-CC-EEE-FFFF-000099 | I
 | Idea
 | One idea i had was to replace the letters in column C to numbers in column E but then i ran out of ideas.
 | Essentially, i was hoping to identify a formula in column F to identify the latest revision of a reference as identified in cells F7, F11 and F20.
Spreadsheet: 747718d1631661085-time-to-expiry-date-formula-not-working-training_log_sample
Sheet: Personnel Info

 |  | ?
 |  | PERSONNEL INFO
 |  | NAME | POSITION | TEAM/SECTION | Inactive?
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | Joiner | Repairs | No
 |  | [NAME] | Joiner | Repairs | No
 |  | [NAME] | Administrator | Admin Team | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | Plumber | Repairs | No
 |  | June May | Plumber | Repairs | No
 |  | [NAME] | Joiner | Repairs | No
 |  | [NAME] | Joiner | Repairs | No
 |  | Cecil Green | Joiner | Repairs | No
 |  | [NAME] | Joiner | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | Assistant Manager | Management Team | No
 |  | [NAME] | Assistant Manager | Management Team | No
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | Assistant Administrator | Admin Team | No
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | [NAME] | [NAME] | Repairs | No
 |  | Heather Small | Assistant Administrator | Admin Team | No
 |  | [NAME] | Surveyor | Survey Team | No
 |  | [NAME] | Surveyor | Survey Team | No
 |  | [NAME] | Surveyor | Survey Team | No
 |  | [NAME] | Surveyor | Survey Team | No
 |  | [NAME] | Deputy [NAME] | Management Team | No
 |  | [NAME] | Plumber | Repairs | No
 |  | [NAME] | Head [NAME] | Management Team | No
Spreadsheet: 779742d1652080816-index-match-with-multiple-criteria-blanks-and-drop-down-lists-index-match-multiple-criteria
Sheet: Sheet3

Person: | Person A | ß [NAME]-down list
Time Between: | Column 7 & Column 8 | ß [NAME]-down list
Total | Total | Total | Total | Total | Total | Total
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |  | ß Header changes based on cell B2
Spreadsheet: 129680d1321812000-excel-summary-from-another-tab-melanie
Sheet: 2011

Name | Birthday | Birthday | Anniversary | Current Address | Property Address | Phone | Type | Start Date | Close Date |  | today's date | number of days since start of contact | Email Total | phone call total | letter | text | note | total follow up |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Listing Price | Sale Price | Commission | Month | Stub # | Days since closing
ron | 2011-12-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-04 00:00:00 | 1000 state st | 150 north shore | [PHONE] | Buyer | 2011-09-01 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  | email |  |  |  |  |  |  |  |  |  |  |  | 150000 | 45000 |  |  | 123
[NAME] | 2011-12-01 00:00:00 | 2011-03-03 00:00:00 | 2011-04-05 00:00:00 | 118 scott | 12 [NAME] | [PHONE] | [NAME] | 2011-08-03 00:00:00 | 2011-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | phone | note |  |  |  |  |  |  |  |  |  |  | 130000 | 105000
[NAME] | 2011-05-04 00:00:00 | 2029-02-01 00:00:00 | 2011-07-15 00:00:00 | 30 jackson | 20 reynolds | [PHONE] | Rent Prospective | 2011-09-28 00:00:00 | 2011-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | email | note |  |  |  |  |  |  |  |  |  |  | 120000 | 30000 |  |  | 345
[NAME] | 1900-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-12-30 00:00:00 | 20 tennesee rd | 112 smith | [PHONE] | Rental | 2011-10-15 00:00:00 | 2011-10-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | text | text |  |  |  |  |  |  |  |  |  |  | 200000 | 195000 |  |  | 456
bill | 2011-12-03 00:00:00 | 2011-04-01 00:00:00 | 2011-12-08 00:00:00 | 37 Smith Street | 12 [NAME] | [PHONE] | Buyer Prospective | 2011-08-29 00:00:00 | 2011-11-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | note |  |  |  |  |  |  |  |  |  |  |  | 300000 | 280000 |  |  | 544
Spreadsheet: 466324d1466119119-search-for-multiple-words-or-values-simultaneously-sample-sheet-emails
Sheet: Sheet2

Possible Emails |  | Names | Emails
gmail |  | Shelia [NAME] | yahoo
hotmail |  | Curtis Barreto | hotmail
aol |  | Danae Cagney | bing
yahoo |  | Karon [NAME] | yahoo
bing |  | [NAME] Mize | aol
 |  | [NAME] Arceneaux | yahoo
Blacklist |  | [NAME] Winchenbach | gmail
 |  | [NAME] Browne | gmail
 |  | Bessie Moeckel | aol
 |  | [NAME] Caplan | hotmail
 |  | [NAME] | gmail
 |  | Zenaida Rosse | gmail
 |  | [NAME] | yahoo
 |  | Mitzi Lehman | hotmail
 |  | Keli Petti | gmail
 |  | Soo Easterly | bing
 |  | Deloras [NAME] | yahoo
 |  | [NAME] Ramirez | aol
 |  | Aura Sterrett | gmail
 |  | [NAME] Yoder | yahoo
 |  | [NAME] [NAME] | bing
 |  | Tana Garfinkel | yahoo
 |  | Charmain Biggers | gmail
 |  | Todd Starks | yahoo
 |  | Sharolyn Winfield | gmail
 |  | Orlando Ontiveros | yahoo
 |  | Savannah Pearsall | gmail
 |  | Maurine [NAME] | bing
 |  | [NAME] Baum | bing
 |  | Lauryn Cusumano | aol
 |  | Roseanna Rollins | gmail
 |  | Theresa Lauer | aol
 |  | Catina Lake | gmail
 |  | [NAME] Roby | hotmail
 |  | Deann Barcenas | hotmail
 |  | [NAME] | gmail
 |  | Rogelio [NAME] | aol
 |  | Emilee [NAME] | bing
 |  | [NAME] Kadlec | aol
 |  | Ione Alley | bing
 |  | Anitra Riva | aol
 |  | [NAME] [NAME] | gmail
 |  | [NAME] Iles | bing
 |  | [NAME] | hotmail
 |  | Salvador Costin | yahoo
 |  | [NAME] Mccrimmon | yahoo
 |  | [NAME] | yahoo
 |  | [NAME] [NAME] | hotmail
 |  | Lonnie Domina | yahoo
 |  | Era Sherrell | yahoo
Spreadsheet: 732295d1620870347-sorting-excluding-leading-the-sort-2-
Sheet: Sheet1

Title | Sort column
[NAME]
Accesary |  | The [NAME]
The [NAME] |  | [NAME]
The Book 3 |  | The Book 3
The University 1 |  | The University 1
University 2 |  | University 2
Spreadsheet: 2017c345-e54b-44df-85b3-fb90e50dd509
Sheet: Sheet1

SUMMER 1 2013 TIMESHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
GRADUATE ASSISTANTS & GRADUATE STUDENT WORKERS
(REMINDER: ULM POLICY IS THAT GA'S CAN WORK A MAXIMUM OF 20 HOURS A WEEK)
NAME: |  |  |  |  |  |  |  |  |  | DEPT:
CWID: |  |  |  |  |  |  |  |  |  | PAY PERIOD: |  |  | June 3 - July 2, 2013
[NAME] REPORT:
Jun 3 | [NAME] | [NAME] | Jun 6 | Jun 7 | Jun 8 | Jun 9 | Jun 10 | Jun 11 | Jun 12 | Jun 13 | Jun 14 | Jun 15 | Jun 16 | Jun 17 | Jun 18 | Jun 19
Jun 20 | Jun 21 | Jun 22 | Jun 23 | Jun 24 | Jun 25 | Jun 26 | Jun 27 | Jun 28 | Jun 29 | Jun 30 | July 1 | July 2
I CERTIFY THAT I HAVE WORKED MY NORMAL EMPLOYMENT SCHEDULE EXCEPT AS REFLECTED ABOVE.
GRADUATE ASSISTANT:
APPROVED BY:
SUPERVISOR |  |  |  |  |  |  |  |  | GRADUATE COORDINATOR
SUPERVISOR (IF APPLICABLE)
 | INSTRUCTIONS FOR COMPLETING TIME REPORT
1 | Please enter name, CWID, department, and the pay period to which the report applies.
2 | Entries should be made to the dates only if the GA/GWS did not complete their normal work schedule
 | and a pay adjustment is required.
3 | Time reports are due in the Payroll Office by 12:00 p.m. on Thursday, June 27, 2013.
 | The pay date is Monday, July 8, 2013.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. 5/9/2013
Spreadsheet: 164164d1340667044-lookup-formula-to-output-cells-with-values-only-how-to-status-cell-rev-2
Sheet: sheet 2

unit | STATUS |  |  | UNITS | STATUS
unit 6 | YES
unit 4 | NO
unit 2 | MAYBE
unit 1 | NA
unit 3 | NA
unit 5 | YES