tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1fa4c9c8-9c31-4869-9557-c4c89f991ace
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Lewis & Clark College |  | Destination : |  |  | Name: |  |  | Mail   ______
Travel & Entertainment Expense Report |  | Dates of Travel: |  |  | Address: |  |  | E-Check ______
Effective as of June 1, 2013 |  | Purpose of Travel: |  |  | L&C ID #
 |  | Supervisor Travel Authorization:
TRAVEL: | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Totals
Date:
Destination:
Airfare |  |  |  |  |  |  |  | 0
Auto Mileage @ $0.57 |  |  |  |  |  |  |  | 0
Taxi, Car Rental |  |  |  |  |  |  |  | 0
Lodging |  |  |  |  |  |  |  | 0
Per Diem -Breakfast (see below) |  |  |  |  |  |  |  | 0
Per Diem -Lunch (see below) |  |  |  |  |  |  |  | 0
Per Diem -Dinner (see below) |  |  |  |  |  |  |  | 0
Other |  |  |  |  |  |  |  | 0
Entertainment (Complete Below) |  |  |  |  |  |  |  | 0
Totals: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ENTERTAINMENT: | (details to support entry above)
Date |  | Company/Individual |  |  | Description, Including Business Purpose |  |  | Amount
Per Diem Meal Rates for Travel Within the US: |  | These Rates in Effect through 12/31/13:
 |  | Breakfast | Lunch | Dinner | Total | Do not include meals provided by a third party.
Full Day, High Cost Areas (see below) |  | 12 | 18 | 30 | 60 | Do not include meals which could reasonably be eaten
Full Day, All Other Areas |  | 10 | 15 | 25 | 50 | at home on the dates of departure or return.
High Cost Metropolitan Areas: |  |  | Supervisor Authorization: |  | Date | Reimbursement Summary
Baltimore, Boston, Chicago, New York City, Philadelphia, |  |  |  |  |  | Total travel expense from above |  | 0 | (A)
San Francisco, Seattle, Washington D.C. |  |  | Print Supervisor Name: |  |  | Items paid with purchasing card*:
High Cost States: |  |  |  |  |  | Other items paid by College:
Alaska and Hawaii |  |  | Account** |  | Amount | Airfare (via travel agent)
 |  |  |  |  |  | Cash Advance
I hereby certify that all expenses on this report were incurred for [NAME] |  |  |  |  |  | Other
& Clark business purposes and conform to the College Travel and |  |  |  |  |  | Total Paid by College |  | 0 | (B)
Entertainment Policy. |  |  |  |  |  | If A > B, Reimbursement due traveler
 |  |  |  |  |  | If A < B, Due to College (attach receipt)
[NAME]'s signature |  | Date | ** Only Reimburseable Expenses not paid on a |  |  | *Includes all P-card travel related purchases including meals
 |  |  | Purchasing Card |  |  | even when using per diem for domestic travel
Spreadsheet: 724675d1616312356-excel-formula-to-match-variable-contributions-variable-contributions
Sheet: Sheet1

VARIABLE  DEDUCTIONS
 |  |  | PERIOD
Code | Name | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
CA1 | MARGARET MADEGA | Funeral | 52 | 55 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
CA1 | MARGARET MADEGA | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
CA1 | MARGARET MADEGA | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
CA1 | MARGARET MADEGA | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA2 | OLIVIA CHINAKA | Funeral | 61 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
CA2 | OLIVIA CHINAKA | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
CA2 | OLIVIA CHINAKA | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
CA2 | OLIVIA CHINAKA | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA3 | BEAUTY GAVHURE | Funeral | 55 | 56 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
CA3 | BEAUTY GAVHURE | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
CA3 | BEAUTY GAVHURE | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
CA3 | BEAUTY GAVHURE | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA4 | JULIUS RWAFA | Funeral | 59 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
CA4 | JULIUS RWAFA | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
CA4 | JULIUS RWAFA | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
CA4 | JULIUS RWAFA | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA5 | ENITA MATAMBO | Funeral | 51 | 53 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
CA5 | ENITA MATAMBO | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
CA5 | ENITA MATAMBO | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
CA5 | ENITA MATAMBO | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
I am kindly asking for excel formula to match column F, G & H using the above data. The desired outcome is in column E29 to E38
Date | Period | Code | Employee Name | Funeral | Medical AID | Trade Union | Others
2021-01-28 00:00:00 | 1 | CA3 | BEAUTY GAVHURE
2021-01-28 00:00:00 | 1 | CA5 | ENITA MATAMBO
2021-01-28 00:00:00 | 1 | CA4 | JULIUS RWAFA
2021-01-28 00:00:00 | 1 | CA1 | MARGARET MADEGA
2021-01-28 00:00:00 | 1 | CA2 | OLIVIA CHINAKA
2021-02-28 00:00:00 | 2 | CA3 | BEAUTY GAVHURE
2021-02-28 00:00:00 | 2 | CA5 | ENITA MATAMBO
2021-02-28 00:00:00 | 2 | CA4 | JULIUS RWAFA
2021-02-28 00:00:00 | 2 | CA1 | MARGARET MADEGA
2021-02-28 00:00:00 | 2 | CA2 | OLIVIA CHINAKA
2021-03-28 00:00:00 | 3 | CA3 | BEAUTY GAVHURE
2021-03-28 00:00:00 | 3 | CA5 | ENITA MATAMBO
2021-03-28 00:00:00 | 3 | CA4 | JULIUS RWAFA
2021-03-28 00:00:00 | 3 | CA1 | MARGARET MADEGA
2021-03-28 00:00:00 | 3 | CA2 | OLIVIA CHINAKA
Spreadsheet: 718377d1613128277-sum-vlookup-to-summarise-data-forum-sum-lookup
Sheet: SUMMARY

 | PROPERTY NAME | PROPERTY 1 | PROPERTY 2
 | ADDRESS | STITT | LITTLE
 | EXPENSES
 | MANAGEMENT FEES
 | MANAGEMENT SUPPLIES
 | RATES
 | INSURANCE
 | WATER | 185 | 175 | SOULD BE THIS AMOUNT WHICH IS CAPTURED FROM WORK SHEETS PROPERTY 1 AND PROPERTY 2
 | CLEANING
 | REPAIRS
 | MAINTENANCE
 | ADVERTISING
 | KEYS | 47 | 42
 | TAXES
 | [NAME]
 | [NAME]
Spreadsheet: 03c578b5-816f-4e22-bd5b-2f851060aec3
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2011/12 | 1140.6 | 1080.6 | 3385.702387562465 | 1515.939 | 3658.59 | 254 | 5428.529 |  | 2805 | 603.601 | 471.5970000000003 | 545 | 4425.198 | 1003.331
2012/131 | 1638 | 1608 | 4192.412935323383 | 1003.331 | 6741.4 | 115 | 7859.731 |  | 2798 | 655 | 591.7309999999998 | 1175 | 5219.731 | 2640
2013/142 | 1097 | 1063 | 3619.755409219191 | 2640 | 3847.8 | 65 | 6552.8 |  | 2880 | 500 | 422.8000000000002 | 650 | 4452.8 | 2100
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-08-23 11:15:43.620000
Spreadsheet: 40489d1238789008-importing-data-conditionally-from-1-worksheet-to-another-book2
Sheet: Sheet2

ALL LABEL 2
ID | Label | INFOA | INFOB | INFOC
4 | 2 | [NAME] | [NAME] | dsa
5 | 2 | asdf | asdf | asdf
6 | 2 | [NAME] | [NAME] | dsa
Spreadsheet: 789567d1659185851-sequential-occurrence-of-each-item-in-list-sequential_occurance_of_each_item_in_list
Sheet: Sheet1

 |  |  | Results
List of Fruits |  |  | List of Fruits | [NAME] occurance of each item
Apricots |  |  | Apricots | 1
Blackberries |  |  | Blackberries | 1
Blackcurrant |  |  | Blackcurrant | 1
Blueberries |  |  | Blueberries | 1
Breadfruit |  |  | Breadfruit | 1
Breadfruit |  |  | Breadfruit | 2
Breadfruit |  |  | Breadfruit | 3
Cantaloupe |  |  | Cantaloupe | 1
Carambola |  |  | Carambola | 1
Cherries |  |  | Cherries | 1
Apricots |  |  | Apricots | 2
Apricots |  |  | Apricots | 3
Avocado |  |  | Avocado | 1
[NAME] |  |  | [NAME] | 1
Blackberries |  |  | Blackberries | 2
Blueberries |  |  | Blueberries | 2
Breadfruit |  |  | Breadfruit | 4
Cantaloupe |  |  | Cantaloupe | 2
Carambola |  |  | Carambola | 2
Cherimoya |  |  | Cherimoya | 1
Apricots |  |  | Apricots | 4
Avocado |  |  | Avocado | 2
[NAME] |  |  | [NAME] | 2
Blackberries |  |  | Blackberries | 3
Blackcurrant |  |  | Blackcurrant | 2
Blueberries |  |  | Blueberries | 3
Spreadsheet: 780239d1652354249-two-sheets-schedule-and-vacations-value-true-in-vacation-change-value-in-schedule-sample
Sheet: Schedule

MORNING | [NAME] | DAY | DAY2 | FLEX | EVENING | EVENING2 | NIGHT | Away | SUN AB
07:00:00 | 08:00:00 | 09:00:00 | 18:00:00 | 08:00-10:00 | 19:00:00 | 20:00:00 | 21:00:00 |  |  |  | Since LEA, P-O and ROBYN have been approved to have vacation, corresponding cell in this sheet should be updated to [NAME].
Date | CARL | [NAME] | GINA | LAREB | LEA | P-O | STEFAN | ROBYN |  | HAL | ISURU | KIT | [NAME] | MIKA | SADA |  | KAZYS | TOMAS | LUKAS | ROKAS | PAULIUS |  | ELIN | FREDRIKA | [NAME] | ROBIEL | SEBASTIAN
2022-05-23 00:00:00 | [NAME] | EVENING | FLEX | DAY | FLEX | FLEX | DAY2 |  | 2022-05-23 00:00:00 | [NAME] | DAY2 | DAY | EVENING2 | MORNING | Away | 2022-05-23 00:00:00 | NIGHT | [NAME] | FLEX | FLEX | FLEX | 2022-05-23 00:00:00 |  | DAY2 |  | FLEX | EVENING2
2022-05-24 00:00:00 | [NAME] | FLEX | FLEX | DAY | EVENING | DAY2 | [NAME] |  | 2022-05-24 00:00:00 | [NAME] | DAY2 | DAY | EVENING2 | MORNING | DAY | 2022-05-24 00:00:00 | NIGHT | [NAME] | FLEX | FLEX | FLEX | 2022-05-24 00:00:00 |  | DAY2 |  | FLEX | EVENING2
2022-05-25 00:00:00 | [NAME] | DAY2 | FLEX | DAY | EVENING | [NAME] | FLEX |  | 2022-05-25 00:00:00 | DAY2 | [NAME] | DAY | EVENING2 | MORNING | DAY | 2022-05-25 00:00:00 | NIGHT | [NAME] | FLEX | FLEX | FLEX | 2022-05-25 00:00:00 |  | FLEX |  | DAY2 | EVENING2
2022-05-26 00:00:00 | [NAME] | DAY | FLEX | FLEX | EVENING | DAY2 | DAY |  | 2022-05-26 00:00:00 | DAY2 | [NAME] | DAY | EVENING2 | MORNING | DAY | 2022-05-26 00:00:00 | NIGHT | [NAME] | FLEX | FLEX | FLEX | 2022-05-26 00:00:00 |  | FLEX |  | DAY2 | EVENING2
2022-05-27 00:00:00 | [NAME] | DAY2 | FLEX | DAY | EVENING | [NAME] | FLEX |  | 2022-05-27 00:00:00 | DAY2 | MORNING | DAY | EVENING2 | Away | DAY | 2022-05-27 00:00:00 | NIGHT | [NAME] | FLEX | FLEX | FLEX | 2022-05-27 00:00:00 |  | EVENING2 |  | FLEX | DAY2
2022-05-28 00:00:00 |  |  |  |  |  |  |  |  | 2022-05-28 00:00:00 |  |  |  |  |  |  | 2022-05-28 00:00:00 |  |  |  |  |  | 2022-05-28 00:00:00
2022-05-29 00:00:00 |  |  |  |  |  |  |  |  | 2022-05-29 00:00:00 |  |  |  |  |  |  | 2022-05-29 00:00:00 |  |  |  |  |  | 2022-05-29 00:00:00 |  |  |  | SUN AB | SUN AB
Spreadsheet: 299821d1393297931-match-date-and-autimatically-add-to-another-sheet-test-1
Sheet: Sheet1

Product Type | Decription | Expected Shipment Date
A |  | 2014-03-10 00:00:00
A |  | 2014-03-11 00:00:00
A |  | 2014-08-22 00:00:00
B |  | 2014-12-03 00:00:00
B |  | 2014-03-19 00:00:00
A |  | 2014-03-03 00:00:00
D |  | 2014-03-12 00:00:00
C |  | 2014-04-01 00:00:00
E |  | 2014-06-14 00:00:00
A |  | 2014-11-15 00:00:00
Spreadsheet: 113955d1309850674-count-number-of-times-value-is-present-i-area-count
Sheet: Sheet2

Row Labels | Count of Area
11 | 3
22 | 2
33 | 4
44 | 2
55 | 1
66 | 1
77 | 1
88 | 2
99 | 5
Grand Total | 21
Area | Count
11 | 3
22 | 2
33 | 4
44 | 2
55 | 1
66 | 1
77 | 1
88 | 2
99 | 5
 | 21
Spreadsheet: phillip_m_love__30668__200003_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 134382 | 349320.9300000072
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0.6099999998696148
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 134382 | 349321.540000007
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | 0 | -10.77000001072884
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 4.879999999997381
 | Total Purchases: |  | 0 | -5.890000010731455
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 8.9200000166893
12 |  | Purchases | -134382 | -349396.3600000143
 | Total Intra CTS Sales / Purchases |  | -134382 | -349387.4399999976
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0.4499999999534339
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0.4499999999534339
 | Total Storage: |  | 0 | 0.4499999999534339
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 0 | 0
 |  |  | 0 | 0
23 | Fuel: |  | 15686 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 113001d1308943802-merging-duplicate-rows-but-summing-a-particular-column-testexcelhelp1
Sheet: Sheet1

Source Name | Date | Name Street1 | Name Street2 | Name City | Name State | [NAME] | Name Contact | Name Phone # | Name Fax # | Amount | ID/Status
John, Inc. | 2009-09-01 00:00:00 | 135 West Allis St. |  | West Grove | PA | 19456 | [NAME] | [PHONE] | [PHONE] | 135 | Customer
John, Inc. | 2009-09-04 00:00:00 | 135 West Allis St. |  | West Grove | PA | 19456 | [NAME] | [PHONE] | [PHONE] | 65 | Customer
John, Inc. | 2009-09-07 00:00:00 | 135 West Allis St. |  | West Grove | PA | 19456 | [NAME] | [PHONE] | [PHONE] | 50 | Customer
Marcus, Inc. | 2009-10-01 00:00:00 | [NAME] 4 |  | [NAME] | NJ | 2736 | [NAME] | [PHONE] | [PHONE] | 45 | Customer
Marcus, Inc. | 2009-10-02 00:00:00 | [NAME] 4 |  | [NAME] | NJ | 2736 | [NAME] | [PHONE] | [PHONE] | 55 | Customer
Marcus, Inc. | 2009-10-03 00:00:00 | [NAME] 4 |  | [NAME] | NJ | 2736 | [NAME] | [PHONE] | [PHONE] | 33 | Customer
Marcus, Inc. | 2009-10-07 00:00:00 | [NAME] 4 |  | [NAME] | NJ | 2736 | [NAME] | [PHONE] | [PHONE] | 77 | Customer
Ames, Inc. | 2010-11-05 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 65 | Customer
Ames, Inc. | 2010-11-06 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 55 | Customer
Ames, Inc. | 2010-11-07 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 75 | Customer
Ames, Inc. | 2010-11-12 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 100 | Customer
Ames, Inc. | 2010-11-15 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 200 | Customer
Ames, Inc. | 2010-11-25 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 65 | Customer
Ames, Inc. | 2010-11-26 00:00:00 | 333 Lucas Dr. |  | Jamestown | VA | 23454 | [NAME] | [PHONE] | [PHONE] | 65 | Customer
Spreadsheet: 062c8887-2533-4872-9de6-cdf647205986
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 | Unnamed: 12
KENTUCKY TRANSPORTATION CABINET
DEPARTMENT OF HIGHWAYS
DIVISION OF CONSTRUCTION
ASPHALT ADJUSTMENT @ 5% January 2006
 |  |  |  |  | SHEET
COUNTY: | 0 |  | Cont_ID | 0
LETTING DATE: | 00:00:00 |  | Contract Number: | 0 |  |  |  |  |  |  |  | FACTOR
 |  |  |  |  |  |  |  |  |  |  |  | 4.348
 |  |  | OLDASHPALT INDEX AT LETTING:
 |  |  | KY Asphalt Index KAPI (PL)
SUMMARY
 |  |  |  |  | QUANTITY | ADJUSTMENT
Page | SSCS | PAY ITEM |  |  | TONS | AMOUNT
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 |  |  | TOTAL |  | 0 | NO ADJ
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Nov - Inv

 | Month | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
 | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day
Child's Name | Parent's Name | Address
 |  |  | 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
Spreadsheet: 732958d1621338878-automatic-count-of-content-in-merged-cells-meeting_sheet
Sheet: Analysis

 |  | Type of Meetings
 | Date of Request | Meeting A | Meeting B | Meeting C | Meeting D | Meeting E | Meeting F | Meeting G | Meeting H | Meeting I | Meeting J | Meeting K | Meeting L | Meeting M | Meetings Not Accommodated | Number of Cancellations
Monday | 2021-05-10 00:00:00 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Tuesday | 2021-05-11 00:00:00 | 1 | 2 | 1 |  |  | 1 |  |  |  |  |  |  |  | 1 | 1
Wednesday | 2021-05-12 00:00:00
Thursday | 2021-05-13 00:00:00
Friday | 2021-05-14 00:00:00
Monday | 2021-05-17 00:00:00
Tuesday | 2021-05-18 00:00:00
Wednesday | 2021-05-19 00:00:00
Thursday | 2021-05-20 00:00:00
Friday | 2021-05-21 00:00:00
Monday | 2021-05-24 00:00:00
Tuesday | 2021-05-25 00:00:00
Wednesday | 2021-05-26 00:00:00
Thursday | 2021-05-27 00:00:00
Friday | 2021-05-28 00:00:00
Monday | 2021-05-31 00:00:00
Tuesday | 2021-06-01 00:00:00
Wednesday | 2021-06-02 00:00:00
Thursday | 2021-06-03 00:00:00
Friday | 2021-06-04 00:00:00
Monday | 2021-06-07 00:00:00
Tuesday | 2021-06-08 00:00:00
Wednesday | 2021-06-09 00:00:00
Thursday | 2021-06-10 00:00:00
Friday | 2021-06-11 00:00:00
Monday | 2021-06-14 00:00:00
Tuesday | 2021-06-15 00:00:00
Wednesday | 2021-06-16 00:00:00
Thursday | 2021-06-17 00:00:00
Friday | 2021-06-18 00:00:00
Monday | 2021-06-21 00:00:00
Tuesday | 2021-06-22 00:00:00
Wednesday | 2021-06-23 00:00:00
Thursday | 2021-06-24 00:00:00
Friday | 2021-06-25 00:00:00
Monday | 2021-06-28 00:00:00
Tuesday | 2021-06-29 00:00:00
Wednesday | 2021-06-30 00:00:00
Thursday | 2021-07-01 00:00:00
Friday | 2021-07-02 00:00:00
Monday | 2021-07-05 00:00:00
Tuesday | 2021-07-06 00:00:00
Wednesday | 2021-07-07 00:00:00
Thursday | 2021-07-08 00:00:00
Friday | 2021-07-09 00:00:00
Monday | 2021-07-12 00:00:00
Tuesday | 2021-07-13 00:00:00
Wednesday | 2021-07-14 00:00:00
Thursday | 2021-07-15 00:00:00
Friday | 2021-07-16 00:00:00
Monday | 2021-07-19 00:00:00
Tuesday | 2021-07-20 00:00:00
Wednesday | 2021-07-21 00:00:00
Thursday | 2021-07-22 00:00:00
Friday | 2021-07-23 00:00:00
Monday | 2021-07-26 00:00:00
Tuesday | 2021-07-27 00:00:00
Wednesday | 2021-07-28 00:00:00
Thursday | 2021-07-29 00:00:00
Friday | 2021-07-30 00:00:00
Monday | 2021-08-02 00:00:00
Tuesday | 2021-08-03 00:00:00
Wednesday | 2021-08-04 00:00:00
Thursday | 2021-08-05 00:00:00
Friday | 2021-08-06 00:00:00
Spreadsheet: 4a6b3734-fd70-446e-b574-aac935472ea5
Sheet: Sheet1

[NAME] | 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
UNIVERSITY OF ARKANSAS AT PINE BLUFF |  |  |  |  |  |  |  |  |  |  | Date |  |  | Req.#
 |  |  |  |  |  |  |  |  |  |  |  | NOT FOR DEPARTMENTAL USE
V |  |  |  |  |  |  |  |  |  |  |  | (1) Department
E
N |  |  |  |  |  |  |  |  |  |  |  | (2) Funds Available   Yes____  No ____
D |  |  |  |  |  |  |  |  |  |  |  | Checked By |  |  | Date
O |  |  |  |  |  |  |  |  |  |  |  | (3) Comments
R
 | Tax ID or Soc. Sec. #
 |  |  |  |  | (Required) |  |  |  |  |  |  | (2&3 for Fund Check use)
 | Ethnicity |  |  |  |  |  |  |  |  |  |  | OVERRIDE APPROVAL:
 |  |  | (Required for all individuals)
Delivery Information:  Building |  |  |  |  |  |  |  |  |  |  |  | Room #
Requester: |  |  |  |  |  |  |  | EX: |  |  |  | Budget Officer
QUANTITY |  | UNIT |  |  |  | [NAME] |  |  |  |  |  |  |  | UNIT PRICE | EXT. TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | ACCOUNT(S) TOTAL
*Use this section to charge the expense to one or more accounts
VICE CHANCELLOR:
 |  |  |  | (Required for consulting services, and purchases at or over $2500.00)
All signatures must be originally signed except "requester" this must be typed  or printed.
Spreadsheet: 541858d1507581944-complex-formula-using-countifs-and-sumifs-to-derive-a-value-across-tabs-quartermaster_matri_foumx
Sheet: Directions & Assumptions

Directions:
 | [NAME] :
 |  | Number of Nights
 |  | Food Input - Total
 |  | ONLY 1 Lodging Input (see Matrix)
 |  |  | Total | Total $ for all nights
 |  |  | RPN | Room $ Per Night
 |  |  | PPPN | $ Per Person Per Night
 |  |  | For instance, there are some trips we take that the lodging $ figure is based on per person, regardless of number of occupants ( winter steelhead)
 |  |  | Other trips it is $250 perday regardless of number of occupants ( Apartment @ Cannon's)
 |  |  | All scenarios are taken of in the calculations so only enter a figure for only one scenario
 |  | Tip Input
 |  | [NAME] to each name (across the row), place a "1" in the cells corresponding to which day(s) he/she will be present
 | Optional Inputs:
 |  | Dinner $ [NAME]
 |  |  | This column is to be used to record the amount someone spent on a prepared dinner
 |  |  | This figure will be subtracted from Total Food $ owed
 |  | FIR (Food Inflation Rate) Column
 |  |  | This column is used to identify folks who need to contribute extra to food costs
 |  |  | All FIR amounts will be totalled, divided by how many folks should not incur an FIR (based on FIR column), and then subtracted evenly across the same folks
Assumptions :
 | Food consumption is based on average/normal consumption; folks requiring more will incur a %5 inflation rate on food costs (i.e. [NAME])
 | Mark "1" in Column "FIR" where applicable
 | Incidentals are based on per-person basis for total duration of trip (i.e. Someone buys tippet for each person etc) - place $ value in Column O