tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Legal

 | Legal
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Legal
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  | 0 | 3500000 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 52800 | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 63000 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Associate | 97200 | 0
 |  |  |  |  |  |  |  |  | Manager | 132000 | 1
 | Headcount |  |  | 111 |  |  |  |  | General Counsel Asst | 178800 | 9
 |  |  |  |  |  |  |  |  | Sr Counsel | 195600 | 2
 | A&A Headcount |  |  |  |  |  |  |  | VP - Counsel | 217200 | 4
 |  |  |  |  |  |  |  |  | MD | 345600 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667 |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 |  |  |  |  |  |  |  | Outside Legal - $5,000,000
Spreadsheet: 737200d1624278803-vlookup-formula-for-custom-column-book2-etaf
Sheet: Sheet1

# | Name | code | date | country
1 | Name1 | code1 | date1 | country1
2 | [NAME] | code2 | date2 | country2
3 | Name3 | code3 | date3 | country3
4 | Name4 | code4 | [NAME] | country4
5 | Name5 | code5 | date5 | [NAME]
6 | Name6 | code6 | date6 | country6
7 | Name7 | code7 | date7 | country7 |  |  |  |  |  | get country vlookup | get date vlookup | get code vlookup | I write name here
8 | Name8 | code8 | [NAME] | country8
9 | Name9 | [NAME] | date9 | country9
 |  |  |  |  |  |  |  |  |  | Country | Date | Code | Name
 |  |  |  |  |  |  |  | VLOOKUP | = |  |  |  | [NAME]
 |  |  |  |  |  |  |  | INDEX/MATCH | = |  |  |  | name7
Spreadsheet: 121048d1315809885-commission-calculation-commission-calculation
Sheet: Commission 

Team | Name | Position | Sold | Target Bonus
A | Salesman A | promotor | 300 |  | <-- Please help on a formula on Target commission based on the table below
A | Salesman B | senior promotor | 400 |  | <-- Please help on a formula on Target commission based on the table below
Target commission
 | achievement | Promoter | Senior Promoter
 | 0 | 0 | 0
 | 130 | 1000 | 0
 | 170 | 1500 | 1000
 | 250 | 2000 | 1500
 | 300 | 2500 | 2000
 | 350 | 3000 | 2500
Spreadsheet: 786060d1656954131-help-with-some-mathematics-stuff-in-excel-target-temp-time
Sheet: Sheet1

 | Example 1: decreasing temp/min (original) |  |  |  |  | Example 2: increasing temp/min
 |  | Time | Temp |  |  |  | Time | Temp
 | Sample 1 | 0:03:00 | 1406 |  |  | Sample 1 | 0:03:00 | 1400
 | Sample 2 | 0:05:00 | 1400 |  |  | Sample 2 | 0:05:00 | 1406
 | [NAME]/min |  |  |  |  | [NAME]/min
 | Target |  | 1370 |  |  | Target |  | 1436
 | Example 3: unrounded target time |  |  |  |  | Example 4: rounded target time
 |  | Time | Temp |  |  |  | Time | Temp
 | Sample 1 | 0:03:00 | 1407 |  |  | Sample 1 | 0:03:00 | 1407
 | Sample 2 | 0:06:00 | 1400 |  |  | Sample 2 | 0:06:00 | 1400
 | [NAME]/min |  |  |  |  | [NAME]/min
 | Target |  | 1370 |  |  | Target |  | 1370
 | Red and yellow fill: incorrect results, or correct only by coincidence Green fill: correct results
Spreadsheet: 0206efd8-f0d8-420d-b485-bd3bf75d849c
Sheet: +60 MS 

BWF World Senior Championships 2013
MS 60 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 86591 |  | IND |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 52506 |  | RUS |  | [NAME]
4 | 81220 |  | NOR |  | Helge Hansen
5 | 52421 |  | ENG |  | [NAME]
6 |  |  |  |  | Bye 9
7 | 55616 |  | FRA |  | [NAME]
8 | 88362 |  | FIN |  | [NAME]
9 | 65347 |  | SWE |  | [NAME] [5/8]
10 |  |  |  |  | Bye 5
11 | 78315 |  | CAN |  | [NAME]
12 | 84103 |  | TUR |  | [NAME]
13 | 84491 |  | GER |  | [NAME]
14 |  |  |  |  | Bye 13
15 | 84226 |  | RSA |  | [NAME]
16 | 90310 |  | JPN |  | Hideo Yamamoto
17 | 50074 |  | DEN |  | [NAME] [3/4]
18 |  |  |  |  | Bye 3
19 | 61110 |  | FRA |  | [NAME]
20 | 98294 |  | JPN |  | Katsuhiro Miyamoto
21 | 88848 |  | NED |  | [NAME]
22 |  |  |  |  | Bye 11
23 | 72704 |  | IND |  | [NAME]
24 | 52507 |  | RUS |  | [NAME]
25 | 2770 |  | ENG |  | [NAME] [5/8]
26 |  |  |  |  | Bye 7
27 | 5890 |  | BUL |  | Delcho Kolev
28 | 72302 |  | TUR |  | Mehmet Yavas
29 | 86070 |  | CAN |  | [NAME]
30 |  |  |  |  | Bye 15
31 | 52392 |  | SWE |  | [NAME]
32 | 77878 |  | GER |  | Dieter Eichhorn
33 | 84122 |  | ENG |  | [NAME]
34 | 71263 |  | CZE |  | [NAME]
35 | 86233 |  | SWE |  | [NAME]
36 | 58470 |  | JPN |  | Yoshio Terasaki
37 | 79961 |  | EST |  | Aavo Raig
38 | 52437 |  | GER |  | Claus-Peter Lienig
39 |  |  |  |  | Bye 8
40 | 52508 |  | RUS |  | [NAME] [5/8]
41 | 74939 |  | TPE |  | [NAME]
42 | 69406 |  | RSA |  | Harvey Pieter Christoffel Ferreira
43 |  |  |  |  | Bye 12
44 | 63860 |  | BUL |  | [NAME]
45 | 87839 |  | FRA |  | [NAME]
46 | 56827 |  | IND |  | Sushil Kumar Patet
47 |  |  |  |  | Bye 4
48 | 5083 |  | CAN |  | [NAME] [3/4]
49 | 97981 |  | JPN |  | [NAME]
50 | 60280 |  | CAN |  | [NAME]
51 |  |  |  |  | Bye 14
52 | 80496 |  | FIN |  | Lars-Henrik Nybergh
53 | 98822 |  | SRI |  | [NAME] Nallathamby
54 | 68742 |  | SWE |  | Per-Arnold Hoij
55 |  |  |  |  | Bye 6
56 | 89392 |  | ENG |  | [NAME] [5/8]
57 | 91575 |  | GER |  | [NAME]
58 | 97361 |  | TUR |  | [NAME]
59 |  |  |  |  | Bye 10
60 | 75708 |  | FRA |  | [NAME]
61 | 71987 |  | IND |  | [NAME]
62 | 89577 |  | RUS |  | Yury Pustyakov
63 |  |  |  |  | Bye 2
64 | 58209 |  | NOR |  | Terje  Dag Osthassel [2]
Spreadsheet: 468414d1467288302-combinations-of-options-on-the-table-excel-forum-upload
Sheet: Sheet1

 |  |  | Criteria | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6
 |  |  | Options | 0, 1, 2 | 0, 1 | 0, 1 | 0, 1 | 0, 1 | 0, 1, 2
 |  |  | No. of options | 3 | 2 | 2 | 2 | 2 | 3
 |  |  | Total no. of options
 |  |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | combination | total
 |  |  | Table | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  | 1 | 1 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 1 | 1 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 1 | 1 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 1 | 1 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 0 | 0 | 0
 |  |  |  | 0 | 1 | 1 | 1 | 0 | 0
 |  |  |  | 0 | 0 | 1 | 1 | 1 | 0
 |  |  |  | 0 | 0 | 0 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 0 | 0
 |  |  |  | 0 | 1 | 1 | 1 | 1 | 0
 |  |  |  | 0 | 0 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 0
 |  |  |  | 0 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 0 | 1 | 0 | 0 | 0
 |  |  |  | 0 | 1 | 0 | 1 | 0 | 0
 |  |  |  | 0 | 0 | 1 | 0 | 1 | 0
 |  |  |  | 0 | 0 | 0 | 1 | 0 | 1
 |  |  |  | 1 | 0 | 0 | 1 | 0 | 0
 |  |  |  | 0 | 1 | 0 | 0 | 1 | 0
 |  |  |  | 0 | 0 | 1 | 0 | 0 | 1
 |  |  |  | 1 | 0 | 0 | 0 | 1 | 0
 |  |  |  | 0 | 1 | 0 | 0 | 0 | 1
 |  |  |  | 1 | 0 | 0 | 0 | 0 | 1
 |  |  |  | 1 | 0 | 0 | 0 | 1 | 1
 |  |  |  | 1 | 0 | 0 | 1 | 1 | 0
 |  |  |  | 1 | 0 | 1 | 1 | 0 | 0
 |  |  |  | 1 | 0 | 0 | 1 | 1 | 1
 |  |  |  | 1 | 0 | 1 | 1 | 1 | 0
 |  |  |  | 1 | 0 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 0 | 0 | 1
 |  |  |  | 1 | 1 | 0 | 0 | 1 | 1
 |  |  |  | 1 | 1 | 0 | 0 | 0 | 1
 |  |  |  | 0 | 1 | 0 | 0 | 1 | 1
 |  |  |  | 1 | 0 | 1 | 0 | 0 | 1
 |  |  |  | 0 | 1 | 0 | 1 | 1 | 1
 |  |  |  | 0 | 0 | 1 | 0 | 1 | 1
 |  |  |  | 0 | 1 | 1 | 1 | 0 | 1
 |  |  |  | 1 | 1 | 0 | 1 | 0 | 0
 |  |  |  | 1 | 1 | 1 | 0 | 1 | 1
 |  |  |  | 0 | 1 | 1 | 0 | 0 | 1
 |  |  |  | 0 | 0 | 1 | 1 | 0 | 1
 |  |  |  | 1 | 1 | 0 | 0 | 1 | 0
 |  |  |  | 1 | 1 | 0 | 1 | 1 | 1
 |  |  |  | 0 | 1 | 0 | 1 | 0 | 1
 |  |  |  | 0 | 1 | 1 | 0 | 1 | 0
 |  |  |  | 1 | 1 | 0 | 1 | 0 | 1
 |  |  |  | 1 | 0 | 1 | 0 | 1 | 0
Spreadsheet: 772859d1647501454-how-to-calculate-interest-rate-paid-by-investment-with-loan-irr-for-plant-investment
Sheet: Sheet1

 |  | -240000 |  |  | -240000 |  |  | -240000 |  |  |  | annual sum of monthly payments for loan at 5%
 |  | 35000
 |  | -20000 |  |  | -20000 |  |  | -20000
Spreadsheet: 04608b3a-ff08-45d7-8c13-8b5212ea2ef7
Sheet: Lunch Production Record

Production Record-LUNCH
MENU PATTERN | MENU |  |  |  |  |  |  |  |  |  | GRADES:
Meat/Meat Alternate
Grains |  |  |  |  |  |  |  |  |  |  | ADULTS:
Vegetable
Fruit |  |  |  |  |  |  |  |  |  |  | TOTAL:
[NAME]
 | Planned |  |  |  |  |  |  | Actual
MENU COMPONENTS | STUDENT MEALS |  | ADULT MEALS OR A LA CARTE |  | TOTAL PLANNED SERVINGS | TOTAL PLANNED QUANTITY | PLANNED PURCHASE UNIT | QUANTITY PREPARED | PURCHASE UNIT | FOOD TEMPERATURE |  | ACTUAL SERVED | [NAME]
 | PLANNED | SERVING SIZE | PLANNED | SERVING SIZE | STUDENT+ADULT |  | (lbs., can, ozs.) |  | (lbs., can, ozs.) | PREP. | SERVING
Meat/ Meat Alternate:
Grains
Vegetables:
Fruit:
Milk:
Other: (Condiments and [NAME])
Spreadsheet: 843089d1695051039-how-can-i-condense-data-by-removing-blank-but-not-empty-cells-test
Sheet: Sheet1

Date | Daily [NAME]
2020-04-25 00:00:00
2020-04-26 00:00:00
2020-04-27 00:00:00
2020-04-28 00:00:00
2020-04-29 00:00:00
2020-04-30 00:00:00
2020-05-01 00:00:00
2020-05-02 00:00:00
2020-05-03 00:00:00
2020-05-04 00:00:00
2020-05-05 00:00:00
2020-05-06 00:00:00
2020-05-07 00:00:00
2020-05-08 00:00:00
2020-05-09 00:00:00
2020-05-10 00:00:00
2020-05-11 00:00:00
2020-05-12 00:00:00
2020-05-13 00:00:00
2020-05-14 00:00:00
2020-05-15 00:00:00
2020-05-16 00:00:00
2020-05-17 00:00:00
2020-05-18 00:00:00 | 0
2020-05-19 00:00:00
2020-05-20 00:00:00
2020-05-21 00:00:00
2020-05-22 00:00:00
2020-05-23 00:00:00
2020-05-24 00:00:00
2020-05-25 00:00:00
2020-05-26 00:00:00
2020-05-27 00:00:00
2020-05-28 00:00:00
2020-05-29 00:00:00
2020-05-30 00:00:00
2020-05-31 00:00:00
2020-06-01 00:00:00
2020-06-02 00:00:00
2020-06-03 00:00:00
2020-06-04 00:00:00
2020-06-05 00:00:00
2020-06-06 00:00:00
2020-06-07 00:00:00
2020-06-08 00:00:00
2020-06-09 00:00:00
2020-06-10 00:00:00
2020-06-11 00:00:00
2020-06-12 00:00:00 | 0
2020-06-13 00:00:00
2020-06-14 00:00:00
2020-06-15 00:00:00
2020-06-16 00:00:00
2020-06-17 00:00:00
2020-06-18 00:00:00
2020-06-19 00:00:00
2020-06-20 00:00:00
2020-06-21 00:00:00
2020-06-22 00:00:00
2020-06-23 00:00:00
2020-06-24 00:00:00
2020-06-25 00:00:00
2020-06-26 00:00:00
2020-06-27 00:00:00
2020-06-28 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
2020-07-01 00:00:00
2020-07-02 00:00:00
2020-07-03 00:00:00
2020-07-04 00:00:00
2020-07-05 00:00:00
2020-07-06 00:00:00 | 0
2020-07-07 00:00:00
2020-07-08 00:00:00
2020-07-09 00:00:00
2020-07-10 00:00:00
2020-07-11 00:00:00
2020-07-12 00:00:00
2020-07-13 00:00:00
2020-07-14 00:00:00
2020-07-15 00:00:00
2020-07-16 00:00:00
2020-07-17 00:00:00
2020-07-18 00:00:00
2020-07-19 00:00:00
2020-07-20 00:00:00
2020-07-21 00:00:00
2020-07-22 00:00:00
2020-07-23 00:00:00
2020-07-24 00:00:00
2020-07-25 00:00:00
2020-07-26 00:00:00
2020-07-27 00:00:00
2020-07-28 00:00:00
2020-07-29 00:00:00
2020-07-30 00:00:00 | 0.1
2020-07-31 00:00:00
2020-08-01 00:00:00
2020-08-02 00:00:00
2020-08-03 00:00:00
2020-08-04 00:00:00
2020-08-05 00:00:00
2020-08-06 00:00:00
2020-08-07 00:00:00
2020-08-08 00:00:00
2020-08-09 00:00:00
2020-08-10 00:00:00
2020-08-11 00:00:00
2020-08-12 00:00:00
2020-08-13 00:00:00
2020-08-14 00:00:00
2020-08-15 00:00:00
2020-08-16 00:00:00
2020-08-17 00:00:00
2020-08-18 00:00:00
2020-08-19 00:00:00
2020-08-20 00:00:00
2020-08-21 00:00:00
2020-08-22 00:00:00
2020-08-23 00:00:00 | 0
2020-08-24 00:00:00
2020-08-25 00:00:00
2020-08-26 00:00:00
2020-08-27 00:00:00
2020-08-28 00:00:00
2020-08-29 00:00:00
2020-08-30 00:00:00
2020-08-31 00:00:00
2020-09-01 00:00:00
2020-09-02 00:00:00
2020-09-03 00:00:00
2020-09-04 00:00:00
2020-09-05 00:00:00
2020-09-06 00:00:00
2020-09-07 00:00:00
2020-09-08 00:00:00
2020-09-09 00:00:00
2020-09-10 00:00:00
2020-09-11 00:00:00
2020-09-12 00:00:00
2020-09-13 00:00:00
2020-09-14 00:00:00
2020-09-15 00:00:00
2020-09-16 00:00:00 | 0
Spreadsheet: kate_symes__18146__11_14
Sheet: Sheet1

WEST | TRADE DATE | Counterparty | Buy/Sell from EPMI View | Buy/Sell from EES View | Trader | Location | Type (PFI) | Term | Peak, Off-peak, Super Peak, [NAME] or Flat | Volume | Price | Broker,EOL, Internal or Notes | EPMI TRADER Providing Sleeve | EPMI Deal # | EES DEAL Tracker # | EES Traders
1 | 2000-11-14 00:00:00 | EES | BUY | SELL | NB | SP | P | 2000-12-01 00:00:00 | PEAK | 25 | 100 | INTERNAL / MM |  |  | 6327 | JW = [NAME]
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB= [NAME]
3 |  | EES | BUY | SELL | NB | COB | P | Q3 01 | PEAK | 25 | 140 | EOL |  |  | 6328 | SS=Suneet Sharma
4
5 |  | EES | BUY | SELL | NB | SP | P | 2000-12-01 00:00:00 | PEAK | 25 | 101 | INTERNAL / MD |  |  | 6329
6
7 |  | EES | BUY | SELL | NB | SP | P | 2000-12-01 00:00:00 | PEAK | 25 | 100 | INTERNAL / MM |  |  | 6330
8
9 |  | EES | BUY | SELL | NB | SP | P | DEC | PEAK | 25 | 102 | INTERNAL / MM |  |  | 6332
10
11 |  | EES | BUY | SELL | JW | COB | P | Q4 2001 | PEAK | 25 | 84.25 | EOL |  |  | 6333
12
13 |  | AVISTIA | SELL | SLEEVE | CS | COB | P | Q4 2001 | OFF | -25 | -64 | AMEREX | SC |  | 6334
14 |  | EES | BUY | SELL | JW | COB | P | Q4 2001 | OFF | 25 | 63.95
15
16 |  | SMUD | SELL | SLEEVE | SS | COB | P | Q2 2001 | OFF | -50 | -51 | APB | BB |  | 6335
17 |  | EES | BUY | SELL | JW | COB | P | Q2 2001 | OFF | 50 | 50.95
18
19 |  | MORGAN | SELL | SLEEVE | TF | COB | P | Q2 2001 | OFF | -25 | -51 | AMEREX | SC |  | 6336
20 |  | EES | BUY | SELL | JW | COB | P | Q2 2001 | OFF | 25 | 50.95
21
22 |  | CONSTELLATION | SELL | SLEEVE | MH | COB | P | Q2 2001 | OFF | -50 | -53 | NATSOURSE | BB |  | 6337
23 |  | EES | BUY | SELL | JW | COB | P | Q2 2001 | OFF | 50 | 52.95
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
Spreadsheet: 374098d1422652828-need-help-combining-table-data-from-a-range-of-worksheets-to-a-separate-worksheet-orientation-roster
Sheet: ORIGINAL

 |  | Last Name | First Name | LAST FOUR DIGITS OF SOCIAL SECURITY NUMBER | PHONE NUMBER | BACKGROUND CHECK STATUS | COMPONENT NUMBER | POSITION HIRED FOR | [NAME]
1 |  | waring | [NAME] | 5555 | 8325555555 | 1 | RCCON_8961 | [NAME] | [EMAIL]
2 |  | jones | [NAME] | 9955 | 5556667878 | 0 | RSCAT_8177 | Banquet Captain | [EMAIL]
3 |  | heart | carol | 6666 | 5557876365 | 1 | RCCON_8961 | [NAME] | [EMAIL]
4 |  | blue | greg | 8965 | 4448966652 | -1 | [NAME] | Beverage Bar Back | [EMAIL]
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 99895d1298425102-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-trackingvera
Sheet: Jan 2011

 | Income and Expense Report
 |  | 2011-01-01 00:00:00
 |  | 18242.05 | PROFIT
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 25830 | 18242.05 | 7587.95 | 7587.95 | 0 | 0 | 0
 | 2011-01-11 00:00:00 | PIF-ROW | fA231415 | Denaoui | 9000 | [NAME] | 0
 | 2010-01-11 00:00:00 | PIF-ROW | fA225680 | Petridis | 16830 | High | 0
 | 2011-01-06 00:00:00 | Invoice Only | fA235292 | 5749 |  | [NAME] | 5483.5 | 5483.5
 | 2011-01-06 00:00:00 | Invoice Only | fA215434 | 5748 |  | Darebin | 2104.45 | 2104.45
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: 716405d1612197081-sum-values-with-criteria-sample
Sheet: SHPR TRACKER

 | DATE | PERCENTAGE | PAY |  |  | DATE | PAY AMOUNT
 | 2021-02-02 00:00:00 | 0.9 | 50 |  |  | Feb
 | 2021-02-21 00:00:00 | 1 | 60 |  |  | Mar
 | 2021-02-24 00:00:00 | 0.98 | 70 |  |  | Apr
 | 2021-03-05 00:00:00 | 0.65 | 50 |  |  | May
 | 2021-03-21 00:00:00 | 1 | 80 |  |  | Jun
 | 2021-03-29 00:00:00 | 0.98 | 50 |  |  | Jul
 | 2021-04-06 00:00:00 | 0.5 | 60 |  |  | Aug
 | 2021-04-23 00:00:00 | 1 | 85 |  |  | Sep
 | 2021-04-24 00:00:00 | 0.98 | 82 |  |  | Oct
 | 2021-05-02 00:00:00 | 1 | 72 |  |  | Nov
 | 2021-05-27 00:00:00 | 0.98 | 64 |  |  | Dec
 | 2021-05-20 00:00:00 | 0.1 | 18
Spreadsheet: 0429bf86-77e9-453b-b598-44c4cc2ce00c
Sheet: Sheet1

Direct and Local Meat Marketing Project | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | University of Kentucky | Unnamed: 5
 |  |  |  | Agricultural Economics
Direct Beef Budget
Days backgrounded | 180 | days
Days Finishing | 120 | days
interest rate | 0.08
Finished Weight | 1200 | lbs
Dressing % | 0.61
 | Quantity per day | Total Quantity | Unit | Price per unit | Total
Expected Returns per head
Carcass |  | 732 | lb | 1.75 | 1281
Variable Costs per head
Weaned Calf |  | 400 | lb | 1.1 | 440.0000000000001
BACKGROUNDING
(feed costs)
Hay fed | 5.5 | 990 | lb | 0.06 | 59.4
Grain Supplement | 8 | 1440 | lb | 0.08 | 115.2
Salt and Mineral | 0.15 | 27 | lb | 0.18 | 4.859999999999999
(other costs)
Vet and Medical |  | 1 | hd | 5 | 5
Death Loss |  | 0.03 | hd | 440.0000000000001 | 13.2
Interest charge |  | 637.6600000000001 | [NAME] | 0.03945205479452055 | 25.15699726027398
BACKGROUNDING TVC |  |  |  |  | 662.8169972602741
FINISHING
(feeding costs)
Corn | 20 | 2400 | lb | 0.04 | 96
Grain Supplement | 5 | 600 | lb | 0.12 | 72
Hay | 5 | 600 | lb | 0.04 | 24
Salt and Mineral | 0.25 | 30 | lb | 0.18 | 5.399999999999999
(other costs)
Vet and Medical |  | 1 | hd | 3 | 3
Death Loss |  | 0.03 | hd | 662.8169972602741 | 19.88450991780822
Processing Costs |  | 732 | lb | 0.3 | 219.6
Interest charge |  | 220.2845099178082 | [NAME] | 0.0263013698630137 | 5.793784370440983
FINISHING TVC |  |  |  |  | 445.6782942882492
TOTAL VARIABLE COSTS |  |  |  |  | 1108.495291548523
B.E.  VARIABLE COSTS |  |  |  |  | 1.514337829984321
Fixed Costs Per Head
Depreciation |  | 1 | hd | 10 | 10
Taxes and Insurance |  | 1 | hd | 2.5 | 2.5
Pasture Maintenance |  | 1 | Ac | 25 | 25
Operator and Family Labor |  | 2 | hr | 10 | 20
TOTAL FIXED COSTS PER HEAD |  |  |  |  | 57.5
TOTAL COST PER HEAD |  |  |  |  | 1165.995291548523
Return to land and management per head |  |  |  |  | 115.0047084514767
B.E. TOTAL COSTS |  |  |  |  | 1.592889742552627
For questions about the Direct and Local Meat Marketing Project,
please contact [NAME] or [NAME].
University of Kentucky
Agricultural Economics
400 Agricultural Engineering Bldg.
Lexington, KY  40546-0276
Fax: (859) 323-1913
[NAME]
Phone:  (859) 257-7272 ext. 254
e-mail: [EMAIL]
[NAME]
Phone: (859) 257-7276
e-mail: [EMAIL]
Spreadsheet: a1aef977-cfc5-4a51-972a-58212c0df24f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Trimethadione (Tridione) and Dimethadione | Trimethadione (Tridione) | Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 3 mL of sodium  heparin plasma refrigerated. Note:	1.	Indicate plasma on request form. 	2.	[NAME] specimen appropriately (plasma).  	3. Trough levels are most reproducible   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 3 mL of serum refrigerated. Note:	1.	Indicate serum on request form. 	2.	[NAME] specimen appropriately (serum). 	3. Trough levels are most reproducible | 0.6 mL NOTE: Submission of the m | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, sodium heparin, EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Trimethadione (Tridione): [NAME]: 3.0-42.0 ug/mL    Dimethadione Metabolite: [NAME]: 300-800 ug/mL   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 3 days | 5 - 7 days |  | Profile |  |  |  |  | Medtox Laboratories, Inc
[NAME] | Result | Z1147 | Trimethadione (Tridione) | Trimethadione (Tridione) | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | Z1163 | [NAME] | [NAME] | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Billing Component | [NAME] |  | Chromatography,QN,Column |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82491
[NAME] | Billing Component | [NAME] |  | Dimethadione |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82654
Spreadsheet: 861933d1709755314-index-match-formula-not-working-as-expected-examplebook
Sheet: Sheet2

Date | ID | Cost Center
2021-08-10 23:59:00 | 1 | LEVEL NINE-CPCU
2021-08-26 23:59:00 | 2 | LEVEL THREE-CICU
2021-08-23 23:59:00 | 3 | LEVEL NINE-CPCU
2021-08-24 23:59:00 | 3 | LEVEL NINE-CPCU
2021-08-25 23:59:00 | 3 | LEVEL NINE-CPCU
2021-08-26 23:59:00 | 3 | LEVEL NINE-CPCU
2018-11-08 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-15 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-16 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-17 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-18 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-19 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-20 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-21 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-22 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-23 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-24 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-25 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-26 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-27 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-28 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-29 23:59:00 | 4 | LEVEL THREE-PICU
2021-11-30 23:59:00 | 4 | LEVEL THREE-PICU
2021-12-01 23:59:00 | 4 | LEVEL THREE-PICU
2021-12-02 23:59:00 | 4 | LEVEL THREE-PICU
2023-02-21 23:59:00 | 4 | LEVEL THREE-PICU
2023-08-08 23:59:00 | 4 | LEVEL THREE-PICU
2023-08-09 23:59:00 | 4 | LEVEL THREE-PICU
2023-08-10 23:59:00 | 4 | LEVEL THREE-PICU
2022-11-02 23:59:00 | 5 | LEVEL THREE-PICU
Spreadsheet: 28074d1221908962-pivot-table-calculated-field-book11
Sheet: DATA

ID | OT
A | On Time
B | Late
C | Late
D | On Time
A | Late
A | On Time
A | Late
B | On Time
B | Late
C | Late