tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b7e0d7b8-f8e8-457f-b18c-1bbdac0ec76a
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
TPO | Test | TPO | Thyroperoxidase (TPO) Antibodies, Serum | [NAME], S | Immunoenzymatic Assay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <9.0 IU/mL Reference values apply to all ages. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | 1 day | 3 days | 1 | 86376 |  |  |  |  | Rochester
TPO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TPO | Result | TPO | [NAME], S | [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 8099-4 | Thyroperoxidase Ab:ACnc:Pt:Ser:Qn:
Spreadsheet: 77931d1278423747-excel-2007-excel-formulae-wbds-new
Sheet: Expenses

Hart Hotels |  | Week Ending:
WBDS |  | Period:
Fife Arms |  | Week In Period:
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Gross Total | Vat Total | Nett Total
Department | Type of Expense
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
. | .
Expenses Total
Spreadsheet: 733794d1621827576-rental-calculation-for-a-list-of-shops-rental-question_revised-ans-2
Sheet: Rent Roll 

A. Monthly Rental |  |  |  |  |  |  |  | Rent Free
Floor | Shop | Tenant | Area |  | Start | End | Rental | Start | End | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | ABC | 1216 | Period 1 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00 | 100 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00
 |  |  |  | Period 2 | 2021-01-16 00:00:00 | 2022-12-15 00:00:00 | 150
B2 | 2 | DEF | 450 | Period 1 | 2018-07-20 00:00:00 | 2019-07-19 00:00:00 | 2000 | 2018-07-20 00:00:00 | 2018-09-19 00:00:00
 |  |  |  | Period 2 | 2019-07-20 00:00:00 | 2020-07-19 00:00:00 | 3000
 |  |  |  | Period 3 | 2020-07-20 00:00:00 | 2021-07-19 00:00:00 | 4000
 |  |  |  | Period 4 | 2021-07-20 00:00:00 | 2022-07-19 00:00:00 | 5000
Spreadsheet: 792336d1660841315-need-to-calculate-city-with-most-skyscrapers-and-how-many-skyscrapers-1-
Sheet: Sheet1

[NAME] | City | Country
Burj Khalifa | Dubai | [NAME] Uniti
[NAME] Shanghai | Shanghai | Cina |  |  |  |  | Which city has the most skyscrapers and how many are there
[NAME] | [NAME] | Arabia Saudita
Ping An Finance Centre | Shenzhen | Cina
Lotte World Tower | Seoul | Corea del Sud |  |  |  |  | Row Labels | Count of Skyscraper Name
One World Trade Center | New York | Stati Uniti |  |  |  |  | Dubai | 9
Guangzhou CTF Finance Centre | Canton | Cina |  |  |  |  | Canton | 4
Taipei 101 | Taipei | Taiwan |  |  |  |  | New York | 4
Shanghai World Financial Center | Shanghai | Cina |  |  |  |  | Hong Kong | 4
International Commerce Centre | Hong Kong | Hong Kong |  |  |  |  | Shanghai | 3
[NAME] | Kuala Lumpur | Malaysia |  |  |  |  | Shenzhen | 3
Nanjing Greenland Financial Center | Nanchino | Cina |  |  |  |  | Chicago | 2
Willis Tower | Chicago | Stati Uniti |  |  |  |  | Mosca | 2
[NAME] | Shenzhen | Cina |  |  |  |  | Kuala Lumpur | 2
Guangzhou International Finance Center | Canton | Cina |  |  |  |  | Seoul | 1
432 Park Avenue | New York | Stati Uniti |  |  |  |  | [NAME] | 1
Trump International Hotel and Tower | Chicago | Stati Uniti |  |  |  |  | Abu Dhabi | 1
[NAME] | Shanghai | Cina |  |  |  |  | Nanchino | 1
International Finance Centre | Hong Kong | Hong Kong |  |  |  |  | Dalian | 1
Princess Tower | Dubai | [NAME] Uniti |  |  |  |  | Taipei | 1
[NAME] | [NAME] | Kuwait |  |  |  |  | [NAME] | 1
23 Marina | Dubai | [NAME] Uniti |  |  |  |  | [NAME] | 1
CITIC Plaza | Canton | Cina
[NAME] | Dalian | Cina
[NAME] | Shenzhen | Cina
[NAME] | Abu Dhabi | [NAME] Uniti
Empire State Building | New York | Stati Uniti
Elite Residence | Dubai | [NAME] Uniti
Central Plaza | Hong Kong | Hong Kong
Federation Tower | Mosca | Russia
The Address the BLVD | Dubai | [NAME] Uniti
Bank of China Tower | Hong Kong | Cina
Bank of America Tower | New York | Stati Uniti
Almas Tower | Dubai | [NAME] Uniti
The Pinnacle | Canton | Cina
JW [NAME] Dubai Tower 1 | Dubai | [NAME] Uniti
Emirates Office Tower | Dubai | [NAME] Uniti
OKO Tower | Mosca | Russia
Forum 66 Tower 2 | [NAME] | Cina
JW [NAME] Dubai Tower 2 | Dubai | [NAME] Uniti
[NAME] | Kuala Lumpur | Malaysia
Spreadsheet: 809820d1671340001-cant-extract-date-from-a-string-s666-pq-extract-date-from-a-string
Sheet: Sheet1

ORDER NUMBER | SKU | order_date |  | order_date
[PHONE]-5211537/SKU | 2X-3C0F-KNJE | Sun, 18 Jul, 2021, 10:38 pm IST |  | 2021-07-18 00:00:00
[PHONE]-7850720/SKU | DN-0WDX-VYOT | Tue, 19 Oct, 2021, 6:05 pm IST |  | 2021-10-19 00:00:00
[PHONE]-4289117/SKU | DN-0WDX-VYOT | Sun, 28 Nov, 2021, 10:20 pm IST |  | 2021-11-28 00:00:00
[PHONE]-9557154/SKU | AH-J3AO-R7DN | Wed, 28 Jul, 2021, 4:06 am IST |  | 2021-07-28 00:00:00
[PHONE]-1215552/SKU | KL-7WAA-Z82I | Tue, 28 Sept, 2021, 2:50 pm IST |  | 2021-09-28 00:00:00
[PHONE]-6725123/SKU | HH-FOWV-5YWO | Thu, 17 Jun, 2021, 9:12 pm IST |  | 2021-06-17 00:00:00
Spreadsheet: 146340d1332121185-keep-a-running-percentage-2011-membership-attendance
Sheet: Members

Business Name | Contact Person | Stall Reservation Fee Receipt Number | Membership Fee Receipt Number | 2012-04-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall Percentage
 |  |  |  | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S | W | S
example |  |  |  | 5 |  |  |  | 6 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | only need formula to work on columns labeled S
Spreadsheet: 43745d1242356757-formula-to-append-a-certain-number-of-formulas-clockinclockout
Sheet: Sheet1

 | Clock in 1 | Clock in 2 | Clock in 3 | Clock in 4 | Clock in 5
Monday | 10:00:00
 | Clock out 1 | Clock out 2 | Clock out 3 | Clock out 4 | Clock out 5
 | 10:15:00
 | Clock in 1 | Clock in 2 | Clock in 3 | Clock in 4 | Clock in 5
Tuesday
 | Clock out 1 | Clock out 2 | Clock out 3 | Clock out 4 | Clock out 5
 | Clock in 1 | Clock in 2 | Clock in 3 | Clock in 4 | Clock in 5
Wednesday
 | Clock out 1 | Clock out 2 | Clock out 3 | Clock out 4 | Clock out 5
 | Clock in 1 | Clock in 2 | Clock in 3 | Clock in 4 | Clock in 5
Thursday
 | Clock out 1 | Clock out 2 | Clock out 3 | Clock out 4 | Clock out 5
 | Clock in 1 | Clock in 2 | Clock in 3 | Clock in 4 | Clock in 5
Friday
 | Clock out 1 | Clock out 2 | Clock out 3 | Clock out 4 | Clock out 5
Monday Total | Tuesday Total | Wednesday Total | Thursday | Friday
Spreadsheet: 216081d1361575010-time-log-for-various-employees-on-various-projects-on-various-days-labor-expense-reclass-to-afe-02_19_2012-example-pcb-
Sheet: 1873

Plant | A
Month | 2013-02-01 00:00:00 |  |  | AFE Description |  | Line # 3 Upgrade
Labor Expense reclass to AFE
AFE | Employee Name | Date | Rate | Reg Hours | OT Hours | Total | Reg $ | OT $ | Total
 |  |  |  |  |  |  | 0 | 0 | 0
1873 | [NAME] | 2013-02-14 00:00:00 | 11 |  | 8.5 | 8.5 | 0 | 140.25 | 140.25
1873 | [NAME] | 2013-02-14 00:00:00 | 22 |  | 1 | 1 | 0 | 33 | 33
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 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 | 9.5 | 9.5 | 0 | 173.25 | 173.25
Spreadsheet: 95191d1294851293-help-to-calculate-automatically-in-pivot-table-cyberuser-sol
Sheet: Sheet2

 | City | Data
 | gardena |  | new york |  | nova odessa |  | sao paulo
date | Sum of People | % | Sum of People | % | Sum of People | % | Sum of People | %
2010-10-01 00:00:00 |  | 0 |  | 0 |  | 0 | 10 | 0.2
2010-10-02 00:00:00 | 20 | 0.4 | 80 | 0.8 | 60 | 0.6 | 10 | 0.2
2010-10-03 00:00:00 | 30 | 0.6 | 20 | 0.2 | 40 | 0.4 | 30 | 0.6
Grand Total | 50 | 1 | 100 | 1 | 100 | 1 | 50 | 1
Spreadsheet: david_delainey__8079__082500
Sheet: summary

ENRON NORTH AMERICA
Energy Services |  |  |  |  |  |  |  |  | Report Date:
[NAME]
COST SUMMARY ($ thousands) |  |  |  |  |  |  |  |  | Expenditures to date: |  |  |  |  | As of 8/24/00
Revision # 05
 |  |  |  |  |  | Actuals
Construction Costs |  |  |  | Current Estimate |  | Actuals to Date |  | Estimate to Complete |  | Total to [NAME] |  | [NAME] |  | %
Excluding Financing Fee |  | MW |  | as of 8/24/00 |  |  |  |  |  |  |  | from CE |  | Complete
[NAME], Tx |  | 178
TOTAL PROJECTS
Target $$/MW
 |  |  |  |  |  | Actuals
Financing Costs |  |  |  | Current Estimate |  | Actuals to Date |  | Estimate to Complete |  | Total to [NAME] |  | [NAME]
Project |  |  |  |  |  |  |  |  |  |  |  | from CE
[NAME], IL |  |  |  | 1500 |  | 0 |  |  |  | 1500
 |  |  |  | 1500 |  | 0 |  |  |  | 1500
Wheatland, IN |  |  |  | 1500 |  | 0 |  |  |  | 1500
TOTAL PROJECTS
Changes to Current Estimate Explanations
8/25 $1.2MM Adjustment to Development Expenses and EE&CC fee
Current Estimate vs Actual [NAME] (000s)
Nothing planned for ENA travel expenses.
Spreadsheet: 157712d1337853671-index-match-vlookup-returning-values-from-worksheets-based-upon-matching-cells-test1
Sheet: 2

local LLN codes | Req. Ref. | Cust Ref
658430003 | NLD-76 | 4500633332
640570009 | DNK-69 | 4500632540
656530002 | NLD-69 | 123456
640530001 | NLD-39 | 4500632544
640730002 | NLD-30 | 4500632563
656430002 | NLD-77 | 4500636245
656577004 | SLO-6496 | 4500636242
640770004 | DNK-10 | 4500636244
640740003 | ESP-119 | 4500637921
640720001 | FRC-92 | 4500637199
640530001 | NLD-84 | 4500640467
640710001 | ITA-171 | 4500632557
640730002 | NLD-81 | 4500640471
640576001 | POL-104 | 4500642501
640776002 | POL-108 | 4500642499
640520001 | FRC-119 | 4500640465
640510002 | ITA-194 | 4500640464
656570008 | DNK-67 | 4500643521
656540008 | PRT-74 | 4500642834
Spreadsheet: 815612d1675088566-count-of-active-projects-by-month-active-project-list-sample
Sheet: Active Projects

Project Manager | Project Name | Project Phase | Project Start | Forecasted Project Complete
[NAME] | MyAccount Migration | Execution | 2022-04-05 00:00:00 | TBD
[NAME] | PMO Modernization | Planning | 2022-08-01 00:00:00 | 2023-06-01 00:00:00
[NAME] | IMS Teams Pilot | On-Hold | 2022-09-19 00:00:00 | 2022-12-31 00:00:00
[NAME] | Growth | Planning | 2022-07-01 00:00:00 | 2024-12-31 00:00:00
[NAME] | FL | Planning | 2022-11-29 00:00:00 | 2023-08-01 00:00:00
[NAME] | Carve Out | Initiation | 2023-01-31 00:00:00 | 2024-02-28 00:00:00
[NAME] | EVV | Execution | 2022-01-12 00:00:00 | 2023-06-01 00:00:00
[NAME] | VT | Execution | 2022-07-15 00:00:00 | 2023-06-01 00:00:00
[NAME] | Workday | On-Hold | 2022-09-16 00:00:00 | TBD
[NAME] | Year End Close Out | Execution | 2022-08-01 00:00:00 | TBD (early 2023)
[NAME] | KS | On-Hold | 2022-11-01 00:00:00 | 2023-02-28 00:00:00
[NAME] | Aetna | Execution | 2022-12-05 00:00:00 | 2023-03-31 00:00:00
[NAME] | Anthem EDI | Execution | 2022-04-20 00:00:00 | TBD
[NAME] | OH ODA | Execution | 2021-04-15 00:00:00 | TBD
[NAME] | CR850 | Closeout | 2022-08-22 00:00:00 | 2023-02-01 00:00:00
[NAME] [NAME] | AR | Initiation | 2022-10-31 00:00:00 | TBD
[NAME] [NAME] | Help | Execution | 2022-01-02 00:00:00 | 1/31/23 Phase II
[NAME] [NAME] | Ohio | Execution | 2021-08-26 00:00:00 | 6/6/23 Phase II
[NAME] [NAME] | MD | Execution | 2022-02-25 00:00:00 | 2023-07-17 00:00:00
[NAME] [NAME] | Garnish | Execution | 2022-09-01 00:00:00 | 2023-03-15 00:00:00
[NAME] [NAME] | Change Management | Execution | 2020-11-01 00:00:00 | Ongoing
[NAME] | PA | Initiation | 2022-10-31 00:00:00 | 2023-08-30 00:00:00
[NAME] | AZ | Closeout | 2020-11-03 00:00:00 | 2023-01-27 00:00:00
[NAME] | NJ PPP | Execution | 2022-08-29 00:00:00 | 2023-02-17 00:00:00
[NAME] | NJ | Execution | 2022-07-14 00:00:00 | 2023-02-17 00:00:00
[NAME] | Core Production | Execution | 2022-10-11 00:00:00 | 2023-03-15 00:00:00
[NAME] | Workforce | Planning | 2021-06-29 00:00:00 | TBD
[NAME] | Redesign | Execution | 2021-02-01 00:00:00 | 2023-04-01 00:00:00
[NAME] | PM | Execution | 2022-07-01 00:00:00 | 2023-06-30 00:00:00
[NAME] | PMO Modernization | Execution | 2022-08-01 00:00:00 | 2023-06-30 00:00:00
[NAME] | MS Project | Initiation | 2022-11-01 00:00:00 | 2023-06-01 00:00:00
[NAME] | Masking | Planning | 2023-01-16 00:00:00 | 2023-09-30 00:00:00
[NAME] | OR | Execution | 2022-09-23 00:00:00 | 2023-02-01 00:00:00
[NAME] | Reporting | Execution | 2022-11-01 00:00:00 | 2023-06-30 00:00:00
[NAME] | [NAME] | Initiation | 2022-12-05 00:00:00 | 2023-03-01 00:00:00
[NAME] | Marketing | Initiation | 2023-01-23 00:00:00 | 2023-11-01 00:00:00
Spreadsheet: 0a13b738-7c84-4380-84db-a550c2a76c60
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 45 | 1090 | 0 | 1135 |  | 982.057769447783 | 102.942230552217 | 1085 | 50
2012/131 | 50 | 1125 | 0 | 1175 |  | 1000 | 125 | 1125 | 50
2013/142 | 50 | 1015 | 0 | 1065 |  | 915 | 100 | 1015 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-05-14 11:07:02.690000
Spreadsheet: 776223d1649614058-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a
Sheet: Bonus GP

[NAME] |  | Floor |  | [NAME] |  | Marcel |  | Karel |  | [NAME] |  | Cor |  | [NAME] |  | Jan |  | [NAME]
1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7
8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9
10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12
13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13
14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14
15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15
16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16
17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17
18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18
19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19
20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20
21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21
22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22
23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23
Total
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: Duke

Duke
Contract  24268
2000-07-31 00:00:00 |  | -441281.49
2000-08-04 00:00:00
60874 | 374
500235
500248
500251
500254
500255 | -1342
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2000-07-31 00:00:00 |  | 124420.74
2000-08-05 00:00:00
9164 | 56680
9167 | -57425
Duke Energy Trading and Marketing
Contract  24361
2000-07-31 00:00:00 |  | 143695.66
2000-08-04 00:00:00
500241
500391 | 1020
500392 | 320
Total Duke imbalances
Spreadsheet: 8334cf91-7e37-4218-a6f3-d8d08fe53e68
Sheet: Tiestall

 |  |  |  | Large Breed Dairy Cow Including Replacements Producing
 |  |  |  | 20,000 lbs. & 24,000 lbs. of [NAME]
[NAME] |  |  |  |  | $$ Value |  |  |  |  | $$ Value
1. Components: | 200 | cwts. |  |  |  | 240 | cwts.
a. [NAME] |  | lbs. |  | $/lb. |  |  | lbs. |  | $/lb.
b. Protein |  | lbs. |  | $/lb. |  |  | lbs. |  | $/lb.
c. Other Solids |  | lbs. |  | $/lb. |  |  | lbs. |  | $/lb.
d. Producer Price Differential |  |  |  | $/cwt. |  |  |  |  | $/cwt.
e. Quality |  | SCC |  | $/thousand |  |  | SCC |  | $/thousand
f. Protein Premium |  |  | 0 | $/lb. |  |  |  |  | $/lb.
g. Volume |  |  | 0.185 | $/cwt. |  |  |  |  | $/cwt.
2. Capital Payout |  |  | 0 | $/cwt. |  |  |  |  | $/cwt.
3. Cull/cow (a) | 0.36 | head |  | per hd. |  | 0.39 | head |  | per hd.
4. Dairy calf | 0.51 | head | 150 | per hd. |  | 0.52 | head |  | per hd.
5. Replacement heifer calf | 0.18 | head | 450 | per hd. |  | 0.21 | head |  | per hd.
6. MILC payment |  |  |  | $/cwt.
GROSS RECEIPTS
II. VARIABLE COSTS
A. FEED COSTS (b) | Price/Unit |  | Amount |  | $$ Value |  | Amount |  |  | $$ Value
1. Corn equivalents |  | per bu. | 104.38 | bu. |  |  | 112.91 | bu.
2. Corn Silage |  | per ton | 8.04 | tons |  |  | 7.99 | tons
3. Hay equivalents |  | per ton | 6.09 | tons |  |  | 6.03 | tons
4. Salts and minerals | 0.14 | per lb. | 241.97 | lbs. |  |  | 323.23 | lbs.
5. Protein supplement |  | per lb. | 1284.83 | lbs. |  |  | 1855.08 | lbs.
6. Whole (linted) cottonseed |  | per lb. | 724.5 | lbs. |  |  | 1361.25 | lbs.
7. Fat |  | per lb. | 26 | lbs. |  |  | 111 | lbs.
8. Milk replacer, calf starter |  |  |  |  | 65 |  |  |  |  | 44
9. Total Feed Costs
B. LIVESTOCK COSTS |  |  |  |  | $$Value |  |  |  |  | $$Value
1. Milk marketing per cwt. | 0.3 |  | 200 | cwts. |  | 0.275 | 240 | cwts.
2. Veterinary and Health |  |  |  |  | 130 |  |  |  |  | 140
3. Fuel, utilities and repairs |  |  |  |  | 152 |  |  |  |  | 155
4. DHIA & accounting |  |  |  |  | 28 |  |  |  |  | 30
5. Breeding fees |  |  |  |  | 42 |  |  |  |  | 52
6. Bedding, supplies and [NAME]. |  |  |  |  | 160 |  |  |  |  | 170
7. Total Livestock Cost
8. Operating Capital Interest | 0.09 |  | 3 | months |  |  | 3 | months
9. Total Variable Costs
III. FIXED COSTS (c)
1. Machinery, equipment, facilities |  |  |  |  | 310 |  |  |  |  | 340
2. Interest & Ins. on Herd | 0.075 | annually |  |  | 126.82 |  |  |  |  | 152.25
3. Death Loss | 0.05 | x $1400.00 |  |  | 45.5 |  | 0.05 | x $1540.00 |  | 53.44
4. Total Fixed Cost
IV. TOTAL COST |  | per cwt. (d) |  |  | per cow |  | per cwt. (d) |  |  | per cow
(except for labor and management)
V. RETURNS |  | per cwt. (d) |  |  | per cow |  | per cwt. (d) |  |  | per cow
1. Gross receipts
2. Less variable costs
3. Returns above variable costs
4. Less fixed costs
5. Returns to labor & management
6. Less labor cost 70 hrs. @ $13/hr.
7. Returns to management
VI. BREAK EVEN MILK PRICE (e)
1. Budget break even per cwt.
2. Actual milk price received this month
3. Actual price received this month+MILC payment
Spreadsheet: 827398d1682669067-formula-that-add-score-to-the-existing-one-according-to-one-or-more-variables-formula-that-add-score-to-the-existing-one-based-on-one-ore-more-variables
Sheet: Sheet1

Restricted countries |  |  |  |  |  |  | The list of country in column E is a drop down listing all countries in the world. In case of certin countries from the column A are being selected (like Spain or Germany or France), FROM THE YELLOW MARKED CELLS ONLY, the result in G36 will  automatically become 100, even if just 1 countri of the list is selected. IF ONE OR MORE OF THE RESTRICTED COUNTRY IN COLUMN A are being selected in the cells E9, E12 or E15, the normal sum of column F applies
 |  |  |  | List of Country
Spain |  |  | Registered | Italy | 0.02
German |  |  | Managed | Romania | 0.05
France |  |  | Operating | Australia | 0.04
…. |  |  | UBO Nationality | Gibraltar | 0.06
…. |  |  | UBO Residency | USA | 0.02
…. |  |  | Jurisdiction Source of Wealth of UBO | [NAME] | 0.07
… |  |  | Licensed | Andorra | 0.02
 |  |  | Top 3 countries to receive | Cile | 0.03
 |  |  |  | UK | 0.07
 |  |  |  | Malta | 0.01
 |  |  | Top 3 countries to pay | Canda | 0.02
 |  |  |  | Russia | 0.08
 |  |  |  | Serbia | 0.01
Spreadsheet: 355755d1414773809-time-calculations-sample-workbook
Sheet: After

In time | Out time | Hours
2014-10-01 06:13:00 | 2014-10-01 06:17:00 | 0.07 |  |  |  |  | The "x" represents when a break occurs for lunch within a day
2014-10-01 06:17:00 | 2014-10-01 12:30:00 | 6.22
2014-10-01 13:01:00 | 2014-10-01 16:40:00 | 3.65
2014-10-02 06:00:00 | 2014-10-02 12:04:00 | 6.07 |  |  |  |  | What I'd like is an easy way to  calculate the hours worked before that break for that day
2014-10-02 12:34:00 | 2014-10-02 16:32:00 | 3.97
2014-10-03 06:14:00 | 2014-10-03 12:16:00 | 6.03 |  |  |  |  | I can do it manually, but I have over 2k entries and it's quite tedius
2014-10-03 12:36:00 | 2014-10-03 15:27:00 | 2.85
2014-10-06 06:01:00 | 2014-10-06 06:12:00 | 0.18
2014-10-06 06:12:00 | 2014-10-06 07:15:00 | 1.05
2014-10-06 07:15:00 | 2014-10-06 12:05:00 | 4.83
2014-10-06 12:35:00 | 2014-10-06 16:31:00 | 3.93
2014-10-07 06:11:00 | 2014-10-07 10:45:00 | 4.57
2014-10-07 10:45:00 | 2014-10-07 11:08:00 | 0.38
2014-10-07 11:08:00 | 2014-10-07 11:50:00 | 0.7
2014-10-07 12:20:00 | 2014-10-07 16:41:00 | 4.35
2014-10-08 05:30:00 | 2014-10-08 11:31:00 | 6.02
2014-10-08 12:01:00 | 2014-10-08 16:28:00 | 4.45
2014-10-09 05:35:00 | 2014-10-09 11:36:00 | 6.02
2014-10-09 12:06:00 | 2014-10-09 16:06:00 | 4
2014-10-10 05:35:00 | 2014-10-10 11:35:00 | 6
2014-10-10 12:05:00 | 2014-10-10 15:35:00 | 3.5
2014-10-13 05:15:00 | 2014-10-13 11:21:00 | 6.1
2014-10-13 11:51:00 | 2014-10-13 16:01:00 | 4.17
2014-10-14 06:00:00 | 2014-10-14 12:06:00 | 6.1
2014-10-14 12:36:00 | 2014-10-14 16:32:00 | 3.93
2014-10-15 06:00:00 | 2014-10-15 11:00:00 | 5
2014-10-15 11:00:00 | 2014-10-15 11:08:00 | 0.13
2014-10-15 11:08:00 | 2014-10-15 12:05:00 | 0.95
2014-10-15 12:35:00 | 2014-10-15 12:48:00 | 0.22
2014-10-15 12:48:00 | 2014-10-15 14:33:00 | 1.75