tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 182397 | 183686 |  | -2731 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 175528 | 177265 |  | -2777 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 182010 | 183753 |  | -2998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 180954 | 183876 |  | -2864 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 177596 | 179509 |  | -3150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 173864 | 175668 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 191389 | 193580 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 200987 | 204150 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 167359 | 168959 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 167917 | 168981 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 167539 | 168891 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2002-01-31 00:00:00 |  |  |  | -35191
 | 2002-02-11 00:00:00
 | CBS Dollars
 |  |  |  | -533965.98
Spreadsheet: 789212d1658999138-business-fund-transfer-tracker-fund-transfer-tracker
Sheet: Fund Transfers

Date | Bank Account | From Account | To Account | Amount | Descriptions
2022-07-27 00:00:00 | KH -Trust Bank | [NAME] | Smith's | 10000 | Fund Transferred to Smith's account |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Account List
 | KH - Eastern Bank | Smith's | [NAME] | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KH -Trust Bank
 |  |  |  |  |  |  |  |  | [NAME] | Smith's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KH - Eastern Bank
 |  |  |  |  |  |  |  | Account Receivable | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KH - Bank Asia
 |  |  |  |  |  |  |  | Account Payable |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KH - Dutch Banlga Bank Limited
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SM - Sonali Bank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SM - Shahjalal Islami Bank Limited
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SM - Trust Bank
Spreadsheet: 60119d1260653266-updaing-background-of-cell-levels
Sheet: Sheet1

 | CONTRACT : |  |  |  | LEVELS :
 | FDAX : |  | 5755 |  | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10
 | Diff : | 5 |  |  | 5672 | 5692 | 5710 | 5732 | 5750 | 5773 | 5792 | 5816 | 5834 | 5860
 | CONTRACT : |  |  |  | LEVELS :
 | FESX : |  | 2833 |  | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10
 | Diff : | 3 |  |  | 2792 | 2798 | 2801 | 2810 | 2818 | 2834 | 2841 | 2852 | 2864 | 2870
 | CONTRACT : |  |  |  | LEVELS :
 | FGBL : |  | 122.8 |  | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10
 | Diff : | 0.05 |  |  | 122.3 | 122.4 | 122.5 | 122.6 | 122.7 | 122.9 | 123 | 123.1 | 123.2 | 123.3
Spreadsheet: 50d0d4a4-e23d-4430-a1fa-a7be91df2338
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-01-20 09:33:45.170000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.375 | 101.798 | 101.673 | 101.548 | 101.173
4.25 | 101.441 | 101.316 | 101.191 | 100.816 |  | Note: | Refer To Price [NAME]
4.125 | 100.977 | 100.852 | 100.727 | 100.352 |  |  | For all Price Adjs
4 | 100.549 | 100.424 | 100.299 | 99.674
3.875 | 99.976 | 99.851 | 99.726 | 99.101
3.75 | 99.105 | 98.98 | 98.855 | 98.23
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.753 | 101.628 | 101.503 | 101.128
3.625 | 101.453 | 101.328 | 101.203 | 100.828
3.5 | 101.145 | 101.02 | 100.895 | 100.52
3.375 | 100.781 | 100.656 | 100.531 | 99.906
3.25 | 100.182 | 100.057 | 99.932 | 99.307
3.125 | 99.557 | 99.432 | 99.307 | 98.682 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-03 09:33:45.170000
30 DAY | 2012-02-18 09:33:45.170000
45 DAY | 2012-03-04 09:33:45.170000
60 DAY | 2012-03-19 09:33:45.170000
90 DAY | 2012-04-18 09:33:45.170000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 385909d1427481040-how-to-sort-two-columns-but-one-has-formulas-ipad-inventory_test
Sheet: PivotTable

Row Labels | Count of New iPad
DC0135 | 3
(blank) | 3
NJ0224 | 2
TX0164 | 2
OK0062 | 2
DE0087 | 2
NC0136 | 2
LA0035 | 2
NJ0291 | 2
LA0300 | 2
RI0068 | 2
TX0165 | 2
CO0199 | 2
UT0220 | 2
WV0077 | 2
MO0047 | 2
MI0042 | 2
NY0052 | 1
IN0032 | 1
IL0152 | 1
MA0038 | 1
[NAME] | 1
MA0094 | 1
OH0059 | 1
ME0203 | 1
TX0074 | 1
CT0115 | 1
WA0112 | 1
AK0001 | 1
NV0295 | 1
CA0020 | 1
NY0231 | 1
MO0157 | 1
GA0026 | 1
MO0270 | 1
TX0073 | 1
MT0207 | 1
IL0277 | 1
N/A | 1
KS0092 | 1
CA0083 | 1
CA0214 | 1
FL0025 | 1
FL0088 | 1
MI0201 | 1
Grand Total | 64
Spreadsheet: 465227d1465500854-i-need-help-in-time-sheet-please-time
Sheet: Sheet1

Here are a couple of examples |  |  |  |  |  |  |  | 12:00:00
Working our the difference between two times:
Start time | End time | Hours
08:30:00 | 19:00:00 |  | If one time is later than the other on the same day, a simple subtract will work
19:00:00 | 08:30:00 |  | But if your time spans from one day to the next, you need to use the MOD formula as the subtraction will result in a negative figure (so you take the remainder and divide by 1)
Sometimes it helps to see how Excel is storing the times.  Here I have just taken the times shown above, and displayed them as a number format
Adding hours to a start time to get a finish time:
If you want to add 30 minutes to a time, this must be formatted as [h]:mm so that Excel knows you are adding hours and minutes, not adding a time to a time
23:45:00 | 0:30:00
 |  |  |  | When you see the calculation as numbers, you can see that the result is 1.0104 so Excel knows this is the next day
Adding 0.5 to the time isn't adding a half hour - Excel sees 0.5 as half a DAY, not half an HOUR so it adds 12 HOURS to your start time
23:45:00 | 0.5
 | 0.5
If you want to add half an HOUR as a decimal, you must make Excel see the correct number for 30 minutes by dividing it by 24
23:45:00
 | 0.5
Spreadsheet: 150660d1334652948-multiple-if-function-problem-example
Sheet: Sheet1

Random Number | Range | Price
752 | 100 | 10
582 | 150 | 15
682 | 200 | 20
698 | 300 | 30
125 | 400 | 40
 | 500 | 50
 | 600 | 60
 | 700 | 70
 | 800 | 80
Spreadsheet: 153895d1336089460-excel-formula-to-adjust-to-data-entered-hb062609
Sheet: Spotted Cars 

Date | Spotted Car # at Facility | PO or Rail BOL | Quantity [NAME] (tn) | Quantity [NAME] (lb) | Material | Net Unloaded | Shrinkage
2012-03-27 00:00:00 | DSIX 1234 | 1234 |  | 204000 | XYZ123 | 200000 |  |  | [NAME] has reported 4 rail cars spotted in Elmira, NY on 3-27-2012.  GR will take place in Plant 2006, Stg location 1004, Total: 800,000 lb . [NAME] plans to begin unloading these rail cars by 3-28-2012 based off our request and forecasting needs.
2012-03-27 00:00:00 | DSIX 5678 |  | 100 | 200000 | XYZ123
2012-03-27 00:00:00 | DSIX  9000 |  | 100 | 200000 | XYZ123
2012-03-27 00:00:00 | DSIX 1000 |  | 100 | 200000 | XYZ123
2012-03-28 00:00:00 | DSIX 1234 |  |  | 150000 | XYZ123 |  |  |  | Each rail car, when it begins to be unloaded, will be linked to Rail to [NAME]. Materials Coordinator will be in charge of filling out Quantity on spotted car report. Material will be assigned by the transloader, they receive this information from the MC weekly snapshots sent weekly.
2012-03-28 00:00:00 | DSIX 5678 |  |  | 150000 | XYZ123
2012-03-28 00:00:00 | DSIX  9000 |  |  | 150000 | XYZ123
2012-03-28 00:00:00 | DSIX 1000 |  |  | 150000 | XYZ123
2012-03-29 00:00:00 | DSIX 1234 |  |  | 100000 | XYZ123
2012-03-29 00:00:00 | DSIX 5678 |  |  | 100000 | XYZ123
2012-03-29 00:00:00 | DSIX  9000 |  |  | 100000 | XYZ123
2012-03-29 00:00:00 | DSIX 1000 |  |  | 100000 | XYZ123 |  |  |  | As each load leaves a rail car, (illustrated on rail to truck) the total amount for each rail car on the spotted rail car report will decrease (reference example on left). This will give us a real time amount of available inventory in each rail car. (This will be done from a link made in Excel.) |  |  |  |  |  |  | Our SAP stg location will match exactly what we physically have on hand in inventory.
2012-03-30 00:00:00 | DSIX 1234 |  |  | 50000 | XYZ123
2012-03-30 00:00:00 | DSIX 5678 |  |  | 50000 | XYZ123
2012-03-30 00:00:00 | DSIX  9000 |  |  | 50000 | XYZ123
2012-03-30 00:00:00 | DSIX 1000 |  |  | 50000 | XYZ123
2012-03-31 00:00:00 | DSIX 1234 |  |  | 0 (Empty) | XYZ123 |  |  | <----- | MC's will notice that these rail cars need to be sent back to supplier immediately. The MC looks at this report daily and is confident with this reporting.
2012-03-31 00:00:00 | DSIX 5678 |  |  | 0 (Empty) | XYZ123
2012-03-31 00:00:00 | DSIX  9000 |  |  | 0 (Empty) | XYZ123
2012-03-31 00:00:00 | DSIX 1000 |  |  | 0 (Empty) | XYZ123
Spreadsheet: 274470d1383130445-separating-out-row-excel-fourm
Sheet: Step-1

Part# | S | M | L | XL
1010 | 1 | 2 | 1 | 2
1011 | 4 | 4 | 2 | 2
1012 | 2 | 1 | 0 | 1
 | Note
 | 1.Just keep only this data
Spreadsheet: 823507d1679995259-how-can-i-convert-this-google-sheet-formula-to-excel-test-stock-portfolio-tracker
Sheet: Portfolio Summary

Total Portfolio Cost
Total Portfolio Value
Total Value Portfolio Cost
Total Value Portfolio Value
Total Value Portfolio Unrealised Gain/Loss
Total Value Portfolio Realised Gain/Loss
Total Value Portfolio Dividends Collected
Expected Value Portfolio Income
Expected Value Portfolio Income Yield on Cost
Total Special Situation Portfolio Cost
Total Special Situation Portfolio Value
Total Special Situation Portfolio Unrealised Gain/Loss
Total Special Situation Portfolio Realised Gain/Loss
Total Special Situation Portfolio Dividends Collected
Expected Special Situation Portfolio Income
Expected Special Situation Portfolio Income Yield on Cost
Total Growth Portfolio Cost
Total Growth Portfolio Value
Total Growth Portfolio Unrealised Gain/Loss
Total Growth Portfolio Realised Gain/Loss
Total Growth Portfolio Dividends Collected
Expected Growth Portfolio Income
Expected Growth Portfolio Income Yield on Cost
Total Dividend Portfolio Cost
Total Dividend Portfolio Value
Total Dividend [NAME] Gain/Loss
Total Dividend [NAME] Gain/Loss
Total Dividend Portfolio Dividends Collected
Expected Dividend Portfolio Income
Expected Dividend Portfolio Income Yield on Cost
Spreadsheet: 165079d1341004348-i-need-to-look-up-the-current-date-and-return-a-value-based-on-specific-criteria-excel-help-
Sheet: Sheet1

July Movements
Fund /Date | 2012-07-01 00:00:00
Account 1
Account 2 | -55000 | Transfer Out |  | 109000 | Fee |  | -89050 | Transfer Out |  |  |  |  |  |  |  | 166694.22 | Fee
Account 2 |  |  |  | 76000 | Transfer In |  |  |  |  |  |  |  |  |  |  | -600000 | Transfer Out
Account 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 254000 | Transfer In
Account 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68000 | Interest
Account 2
Account 3 | 89000 | Transfer In |  | -10000 | Fee |  | 89050 | Transfer In |  |  |  |  |  |  |  | -68376.77 | Fee
Account 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -68000 | Transfer Out
Account 3
Account 4 |  |  |  | -501.99 | Fee |  |  |  |  |  |  |  |  |  |  | -20984.1 | Fee
Account 4
Account 4
Account 5 |  |  |  | -31009 | Fee |  |  |  |  |  |  |  |  |  |  | -277.89 | Fee
Account 5
Account 5
Account 6 |  |  |  | -889 | Fee |  | 867 | Interest |  |  |  |  |  |  |  | -65642.23 | Fee
Account 6 | -122000 | Wages |  | -60000 | Transfer Out |  |  |  |  |  |  |  |  |  |  | -254000 | Wages
Account 6
Account 7 |  |  |  | -51090 | Fee |  |  |  |  |  |  |  |  |  |  | -884.14 | Fee
Account 7
Account 7
Account 8 |  |  |  | -9081 | Fee |  | -4000 | Transfer Out |  |  |  |  |  |  |  | -10321.58 | Fee
Account 8 | 551 | Interest
Account 8
Account 9 |  |  |  | -6000 | Fee |  |  |  |  |  |  |  |  |  |  | 0
Account 9
Account 9
Account 10 |  |  |  | -429.01 | Fee |  |  |  |  |  |  |  |  |  |  | -207.51 | Fee
Account 10
Account 10
Net Total
Fee
Transfer Out
Transfer In
Wages
Interest
Spreadsheet: 130852d1322619643-matching-dates-and-returning-another-column-instructor
Sheet: Sheet1

 |  |  |  | Instructor Sheet2 | Instructor Sheet3 | Total
 |  | Period 1
 |  | Period 2
 |  | Period 3
 |  | Period 4
 |  | Period 5
 |  | Period 6
 |  | Period 7
 |  | Period 8
 | 2012-01-16 00:00:00 | Period 9 |  | 1 |  | 1
 |  | Period 1
 |  | Period 2
 |  | Period 3
 |  | Period 4
 |  | Period 5
 |  | Period 6
 |  | Period 7
 |  | Period 8
 | 2012-01-17 00:00:00 | Period 9 |  | 2 |  | 2
 |  | Period 1
 |  | Period 2
 |  | Period 3
 |  | Period 4
 |  | Period 5
 |  | Period 6
 |  | Period 7
 |  | Period 8
 | 2012-01-18 00:00:00 | Period 9 |  | 1 |  | 1
 |  | Period 1
 |  | Period 2
 |  | Period 3
 |  | Period 4
 |  | Period 5
 |  | Period 6
 |  | Period 7
 |  | Period 8
 | 2012-01-19 00:00:00 | Period 9 |  | 2 | 1 | 3
 |  | Period 1
 |  | Period 2
 |  | Period 3
 |  | Period 4
 |  | Period 5
 |  | Period 6
 |  | Period 7
 |  | Period 8
 | 2012-01-20 00:00:00 | Period 9 |  | 1 | 2 | 3
Spreadsheet: 251ea124-ae04-48a9-a03a-624be6774d7f
Sheet: General Info (START HERE)

UNIVERSITY OF SOUTHERN CALIFORNIA
OFFICE OF FINANCIAL ANALYSIS
SERVICE CENTER RATE INITIAL QUESTIONNAIRE
 | Information Requested | Please Provide Responses Here
1 | Service Center Name | Sample Recharge Center Name
 | Fiscal Year of Analysis | 2013
 | Division/ Department | USC School of ???
 | Service Center Manager or Contact | <insert manager name>
 | Room Location | UGB 107
 | Brief Description of Services Provided | <insert description of the type of services that are being provided>
 | Provide all Account Numbers used to capture all financial information connected with the service center. | <provide all current 56 accounts being used as well as any other accounts that you use to charge some/all costs to operate this recharge center>
 | Provide a listing of Major Equipment (Asset No./USC Tag No) and Room Location for center.  Exclude equip less than$5K and more than 10 years old. | Please contact equipment management if necessary>
 | Basis for Determining Actual Billing Rate (What cost components are included in the rates charged that are being recovered? | <do you include salary/fb/m&s/depreciation>
 | Are your rates fully loaded?  Please provide copy of Rates charged or provide web location where they can be obtained. | <Indicate whether you charge the full rate or not> <provide information about current rates being charged>
 | Any Agreements or Understanding within the School/Division to Subsidize any Year-end Unrecovered Expenses? (Is there an agreed recovery target to achieve (e.g., 25%, 50%).  Does the income affect budgets for the following year? | <provide as much detail as you can>
 | If there are any year-end gains, what is done with the gains? | <brief description>
 | Any Customers given Discounts or Free Services? | <brief description>
 | Customer Base:  What % are USC/Non-USC?  What % of customers are Fed/Non-Fed? | 83% USC, 17% Non-USC; 50% Fed, 50% Non-Fed
 | Note:  After reviewing this initial information, additional or more detail information may be needed to complete the rate review process.
Spreadsheet: 708890d1608058925-look-up-the-nth-value-in-a-column-for-instance-the-2nd-number-tablelookup
Sheet: Sheet1

 |  |  |  |  |  |  |  | Table 1
 |  |  |  |  |  |  |  | 11
 |  |  | Find: | 2 |  |  |  | 16
 |  |  | Result: |  | <-- This should return 16 |  |  | 3
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 9
 |  |  | Find: | 3.5 |  |  |  | -2
 |  |  | Result: |  | <-- This should return 4 |  |  | 3
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 11
Spreadsheet: 50956d1250543345-vlookup-putting-all-names-in-order-slash-summer-series-points
Sheet: Sheet1

0 | 0 | 0
100 | 1 | 100
97 | 2 | 97
95 | 3 | 95
94 | 4 | 94
93 | 5 | 93
92 | 6 | 92
91 | 7 | 91
90 | 8 | 90
89 | 9 | 89
88 | 10 | 88
87 | 11 | 87
86 | 12 | 86
85 | 13 | 85
84 | 14 | 84
83 | 15 | 83
82 | 16 | 82
81 | 17 | 81
80 | 18 | 80
79 | 19 | 79
78 | 20 | 78
77 | 21 | 77
76 | 22 | 76
75 | 23 | 75
74 | 24 | 74
73 | 25 | 73
72 | 26 | 72
71 | 27 | 71
70 | 28 | 70
69 | 29 | 69
68 | 30 | 68
67 | 31 | 67
66 | 32 | 66
65 | 33 | 65
64 | 34 | 64
63 | 35 | 63
62 | 36 | 62
61 | 37 | 61
60 | 38 | 60
Spreadsheet: 119419d1314377063-sumifs-and-sumproduct-help-on-timesheets-or-other-formulas-to-solve-problem-time-sheet-testing
Sheet: Sheet1

BTH=Behind the Headlines, SF=Sports Files, FP=Family Plot, LC=Local Color, [NAME]=Miscellaneous
Convo= Conversation With, NM= NewsMakers, Pledge= Pledge
Date | Start Time | Stop Time | Project Name | Time Worked
2011-08-22 00:00:00 | 08:00:00 | 11:00:00 | Misc
2011-08-22 00:00:00 | 11:00:00 | 12:00:00 | SF
2011-08-22 00:00:00 | 13:00:00 | 17:00:00 | 1/2 Sick Day
2011-08-23 00:00:00 | 08:00:00 | 09:00:00 | Misc
2011-08-23 00:00:00 | 09:00:00 | 13:30:00 | SF
2011-08-23 00:00:00 | 13:30:00 | 17:30:00 | 1/2 Sick Day
2011-08-24 00:00:00 | 07:00:00 | 11:00:00 | 1/2 Sick Day
2011-08-24 00:00:00 | 11:00:00 | 13:00:00 | LC
2011-08-24 00:00:00 | 13:30:00 | 15:00:00 | LC
2011-08-24 00:00:00 | 15:00:00 | 16:15:00 | Misc
2011-08-25 00:00:00 | 08:15:00 | 11:00:00 | [NAME]
2011-08-25 00:00:00 | 11:00:00 | 11:30:00 | Misc
2011-08-25 00:00:00 | 12:30:00 | 14:30:00 | [NAME]
2011-08-25 00:00:00 | 14:30:00 | 15:30:00 | Misc
2011-08-26 00:00:00 | 08:15:00 | 10:15:00 | BTH
2011-08-26 00:00:00 | 10:15:00 | 11:45:00 | Misc
2011-08-26 00:00:00 | 12:00:00 | 16:00:00 | Misc
 |  |  | TOTAL HOURS
Week 1 | Week 2 | Week 3
WKNO Production Hourly Worksheet
WKNO-TV Production Hourly Payroll Sheet
FOR OFFICE USE ONLY - Employees Do Not write on this side.
 |  |  | 8/21/2011 | 8/27/2011
 |  |  | 8/28/2011 | 9/3/2011
 |  |  | 9/15/2011
Category Number |  |  |  | Regular Hours | Overtime Hours
121-5160  Misc.
507-5160  Behind the Headlines
508-5160  Sports Files
509-5160  Family Plot
510-5160  Local Color
525-5160   Conversation With…
534-5160  NewsMakers
[NAME]
Pledge
Sick or Vacation Time
 |  |  | Total
TV Production Manager |  |  | ________________________________________________
Overtime Pay Authorization: |  |  | Approved |  | Disapproved
Department Head
Division Director
Dir. Finance & Admin
Spreadsheet: 267fb417-2968-43e7-9cf6-547d81ab4dfb
Sheet: Thursday

Weighted Nutrient Analysis for Thursday
Number of Planned Meals for the Day |  |  | 0
Entrée or Food Item | Serving Size | Planned Servings | Weighting Factor      (Planned Servings ÷ Number of Planned Meals for the Day) | Calories per Serving | Saturated Fat (g) per Serving | Sodium (mg) per Serving |  | Weighted Calories        (Calories per Serving x Weighting Factor) | Weighted              Saturated Fat                        (Sat. Fat per Serving x Weighting Factor) | Weighted Sodium             (Sodium per Serving x Weighting Factor)
 |  |  |  |  |  | Average Daily Calories                     (add up all Weighted Calories)
 |  |  |  |  |  | Average Daily Saturated Fat      (add up all Weighted            Saturated Fat)
 |  |  |  |  |  | Average Daily Sodium                    (add up all Weighted Sodium)
Spreadsheet: daren_farmer__6652__Gas Assets Ops 03-00 Prelim O&M
Sheet: Input

Input
 |  |  |  | 2 | 1 | 2000-01-01 00:00:00
 |  |  |  |  | 2 | 2000-02-01 00:00:00
 |  |  |  |  | 3 | 2000-03-01 00:00:00
 |  |  |  |  | 4 | 2000-04-01 00:00:00
 |  |  |  |  | 5 | 2000-05-01 00:00:00
 |  |  |  |  | 6 | 2000-06-01 00:00:00
 |  |  |  |  | 7 | 2000-07-01 00:00:00
 |  |  |  |  | 8 | 2000-08-01 00:00:00
 |  |  |  |  | 9 | 2000-09-01 00:00:00
 |  |  |  |  | 10 | 2000-10-01 00:00:00
 |  |  |  |  | 11 | 2000-11-01 00:00:00
ENA |  |  |  |  | 12 | 2000-12-01 00:00:00
For the Month of January, 2000 and YTD
Spreadsheet: 471697d1469136347-conditional-formatting-counter-conditional-example
Sheet: Sheet1

 | YTD Plan | YTD Volume | % of Goal | MTD Plan | MTD Volume | % of Monthly Goal | US | Competition | Delta | Relationship
Company 1 | 1000 | 850 |  | 600 | 578 |  | 13.9 | 21.3
Company 2 | 2000 | 1950 |  | 500 | 550 |  | 1.3 | 1
Company 3 | 3000 | 3500 |  | 100 | 60 |  | -3.8 | 0.1
Spreadsheet: 774778d1648653615-according-to-the-selection-of-f1-and-then-id-calculate-the-number-of-class-in-descending-3029-1
Sheet: Sheet1

CLASS | ID | Date | ID | QTY | 2C | CLASS
1C | 1234 | 2022-02-01 00:00:00 | 1235 | 5 | Feb | Month
2C | 1235 | 2022-02-02 00:00:00
3C | 1236 | 2022-02-03 00:00:00
4C | 1237 | 2022-02-04 00:00:00
5C | 1238 | 2022-02-05 00:00:00 |  | 7
6C | 1239 | 2022-02-06 00:00:00 | 1243 | 3
7C | 1240 | 2022-02-07 00:00:00 | 1249 | 2
8C | 1241 | 2022-02-08 00:00:00
1C | 1234 | 2022-02-09 00:00:00
2C | 1235 | 2022-02-10 00:00:00
3C | 1236 | 2022-02-11 00:00:00
1C | 1234 | 2022-02-12 00:00:00
2C | 1235 | 2022-02-13 00:00:00
2C | 1235 | 2022-02-14 00:00:00
2C | 1235 | 2022-02-15 00:00:00
2C | 1235 | 2022-03-01 00:00:00
1C | 1234 | 2022-03-02 00:00:00
2C | 1235 | 2022-03-03 00:00:00
3C | 1236 | 2022-03-04 00:00:00
4C | 1237 | 2022-03-05 00:00:00
5C | 1238 | 2022-03-06 00:00:00
6C | 1239 | 2022-03-07 00:00:00
7C | 1240 | 2022-03-08 00:00:00
8C | 1241 | 2022-03-09 00:00:00
1C | 1242 | 2022-03-10 00:00:00
2C | 1243 | 2022-03-11 00:00:00
3C | 1244 | 2022-03-12 00:00:00
1C | 1245 | 2022-03-13 00:00:00
2C | 1243 | 2022-03-14 00:00:00
2C | 1249 | 2022-03-15 00:00:00
2C | 1243 | 2022-03-16 00:00:00
2C | 1249 | 2022-03-17 00:00:00