tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 19fcf937-686f-4dfd-bb26-54bc40ddc12a
Sheet: HomeInventory

 | Home Inventory
 | Mesa County Sheriff's Office Neighborhood Watch Program
 |  |  |  |  |  |  |  |  |  |  | [42]
Personal Information |  |  |  |  |  |  |  | Insurance Information
Name |  |  | Store a copy of your inventory and photos |  |  |  |  | Company
Address |  |  | in a secure location outside of your home |  |  |  |  | Agent Name
City, State, ZIP |  |  | and/or in a fireproof safe. |  |  |  |  | Phone
Phone |  |  |  |  |  |  |  | Policy Number
 |  |  |  |  |  |  |  | Total Estimated Value
 |  | Purchase Information
Location | Description | Date | Where | Wrnty | Price | Condition | Est. Value | Model | Serial # | Notes | Photo
Home Office | Books
Home Office | Chairs
Home Office | Computer
Home Office | Desk
Home Office | Monitor
Home Office | Other Electronics
Home Office | Printer
Home Office | Software
Home Office | Speakers
Family Room | Bookcases
Family Room | Books
Family Room | Chairs
Family Room | Computer
Family Room | Couches
Family Room | Curios
Family Room | Desk
Family Room | Electronics
Family Room | Entertainment center
Family Room | [NAME]
Family Room | [NAME]
Family Room | Miscellaneous
Family Room | Paintings / Art
Family Room | Rugs
Family Room | Tables
Family Room | TV: Panasonic Viera 65"
Living Room | Art
Living Room | Curios
Living Room | Furniture
Living Room | [NAME]
Living Room | Paintings / Art
Living Room | Piano
Living Room | Rugs
Kitchen | Appliances
Kitchen | China
Kitchen | Contents of cabinets
Kitchen | Cookbooks
Kitchen | Cutlery
Kitchen | Dishes
Kitchen | Glasses
Kitchen | Pots & Pans
Kitchen | Refrigerator/Freezer
Kitchen | Stove
Kitchen | Tables
Kitchen | Utensils
Hallways | Contents in closet
Hallways | Pictures/Paintings
Master [NAME] | Bedding
Master [NAME] | Bed
Master [NAME] | Books
Master [NAME] | Chests/contents
Master [NAME] | Contents in closet
Master [NAME] | Desk
Master [NAME] | Dressers/Contents
Master [NAME] | [NAME]
Master [NAME] | Misc items
Master [NAME] | Rugs
Bdrm Two | Bedding
Bdrm Two | Bed
Bdrm Two | Books
Bdrm Two | Chairs
Bdrm Two | Contents in closet
Bdrm Two | Desk
Bdrm Two | Dressers/Contents
Bdrm Two | [NAME]
Bdrm Two | Misc items
Bdrm Two | Rugs
Bdrm Three | Bedding
Bdrm Three | Bed
Bdrm Three | Books
Bdrm Three | Chairs
Bdrm Three | Contents in closet
Bdrm Three | Desk
Bdrm Three | Dressers/Contents
Bdrm Three | [NAME]
Bdrm Three | Misc items
Bdrm Three | Rugs
Bathrooms | Contents
Bathrooms | Electrical appliances
Bathrooms | Linens
Utility | Dryer
Utility | Ironing Board
Utility | Linens
Utility | Misc. Items
Utility | Washing Machine
Garage | Auto supplies
Garage | Deep freezer
Garage | Lawn Furniture
Garage | Lawn Mower
Garage | Luggage
Garage | [NAME]
Garage | Tools
Garage | [NAME]
Attic | Golf Clubs
Attic | Other storage
Basement | Chairs
Basement | Storage
Basement | Tables
Basement | Toys
Basement | Workbench
Other | Jewelry
Other | Collections
Spreadsheet: 168819d1342598753-summing-a-cf-range-0aaatestcf
Sheet: Calendar

Observed date | Public Holiday name | Actual/Ref date | Current year | FOM | Today's date
2011-12-28 00:00:00 | APS Holiday |  | 2012 | 2012-04-01 00:00:00 | 2012-07-18 00:00:00
2011-12-27 00:00:00 | Boxing Day | 2011-12-26 00:00:00
2011-12-26 00:00:00 | Christmas Day | 2011-12-25 00:00:00
2012-01-02 00:00:00 | New Year's Day | 2012-01-01 00:00:00
2012-01-26 00:00:00 | Australia Day | 2012-01-26 00:00:00
2012-04-06 00:00:00 | Easter Friday
2012-04-09 00:00:00 | Easter Monday
2012-04-25 00:00:00 | Anzac Day | 2012-04-25 00:00:00
2012-06-11 00:00:00 | Queen's Birthday | 2012-06-01 00:00:00
Spreadsheet: 859445d1707832766-how-to-populate-daily-sales-dynamically-based-on-the-week-ending-dates-and-daily-breakdo-daily-splits-tbc
Sheet: Days Pattern

 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
Days | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 7
D2C | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
5 | 0.214 | 0.204 | 0.194 | 0.194 | 0.194 | 0 | 0
6 | 0.1833333333333333 | 0.1733333333333333 | 0.1633333333333334 | 0.1633333333333334 | 0.1633333333333334 | 0.1533333333333333 | 0
7 | 0.16 | 0.15 | 0.14 | 0.14 | 0.14 | 0.13 | 0.14
Spreadsheet: 771068d1646404024-help-with-auto-populating-tables-ordering-sheet-2-new-
Sheet: Template Spares

Company Information
Date Customer Requested Order | Spok Number | Company Details |  | Delivery Address (if different)
[NAME] | Pending |  |  | MPN if available | Product Name |  |  | Price [NAME]. VAT | Refund Requested
 |  |  | Item 1
BT Order Reference |  |  | Item 2
Confirmed Delivery Date |  |  | Item 3
HRP Quote Ref |  |  | Item 4
Opay Invoice Number |  |  | Item 5
Sage Invoice Number |  |  | Item 6
HRP Invoice Number |  |  | Item 7
Date Payment Link sent |  |  | Item 8
Date Paid |  |  | Item 9
Date ordered |  |  | Item 10
Date Cancellation/Refund requested |  |  | Item 11
HRP Returns Reference |  |  | Item 12
Merchant Credit Note Number?? Waiting on [NAME] |  |  | Deliverey Charge
Date Refund Issued |  |  | Total Cost
Spreadsheet: 679794d1590632789-sumproduct-using-vlookup-calculation-help
Sheet: Sheet1

Animal | % Year 1 | % Year 2 | % Year 3
Dog | 0.2 | 0.7 | 1
Cat | 0.25 | 0.3
Elephant | 0.15 | 0.2
Sparrow | 0.15 | 0.2
Crow | 0.25 | 0.3
Rabbit | 0.15 | 0.2
 |  |  |  |  |  |  |  |  | Values Needed
Category | Animal | Value | Value | Value |  |  |  |  | Year 1 | Year 2 | Year 3
A | Dog | 10 | 10 | 10 |  |  |  | A
B | Dog | 20 | 20 | 20 |  |  |  | B
C | Dog | 30 | 30 | 30 |  |  |  | C
A | Cat | 5 | 5 | 5
B | Cat | 0 | 0 | 0
C | Cat | 10 | 10 | 10
A | Elephant | 0 | 0 | 0
B | Elephant | 0 | 0 | 0
C | Elephant | 5 | 5 | 5
A | Sparrow | 10 | 10 | 10
B | Sparrow | 0 | 0 | 0
C | Sparrow | 0 | 0 | 0
A | Crow | 50 | 50 | 50
B | Crow | 20 | 20 | 20
C | Crow | 0 | 0 | 0
A | Rabbit | 20 | 20 | 20
B | Rabbit | 10 | 10 | 10
C | Rabbit | 0 | 0 | 0
Spreadsheet: 148886d1333591008-totals-under-different-criteria-totals
Sheet: Sheet1

 | unit cost | unit cost | unti cost
fixed cost | 26.16666666666666 | 26.16666666666666 | 78.5
fixed cost | 39.25 | 26.16666666666666 | 39.25
variable cost | 19.625 | 7.85 | 9.8125
variable cost | 13.08333333333333 | 5.233333333333333 | 4.90625
variable cost | 13.08333333333333 | 5.233333333333333 | 6.541666666666666
fixed cost | 65.41666666666666 | 52.33333333333333 | 117.75
variable cost | 45.79166666666666 | 18.31666666666666 | 21.26041666666666
 | 111.2083333333333 | 70.64999999999999 | 139.0104166666667
Spreadsheet: 41891d1240428280-arranging-form-data-into-column-data-form-to-columns
Sheet: Result with blanks

Field 1 | Field 2 | Field 3 | Field 4 | Field 5
AA |  | AAAA |  | AAAAA
B | BBB | BBB | BB | B
C | C | CCC | CCCC
DDD | D | DD |  | DDDD
Spreadsheet: 89fee676-102c-4b57-9479-49e538acd099
Sheet: Sheet1

Release: Chicago Fed National Activity Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=219
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-25 10:23 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Chicago Fed National Activity Index | 2011-05-23 00:00:00 | Current
Link:
http://www.chicagofed.org/webpages/publications/cfnai/index.cfm | 2011-05-23 00:00:00 | Current
Source:
Federal Reserve Bank of Chicago | 2011-05-23 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-05-23 00:00:00
2011-06-23 00:00:00
2011-07-25 00:00:00
2011-08-22 00:00:00
2011-09-26 00:00:00
2011-10-24 00:00:00
2011-11-21 00:00:00
2011-12-22 00:00:00
2012-01-26 00:00:00
2012-02-21 00:00:00
2012-03-26 00:00:00
2012-04-26 00:00:00
2012-05-21 00:00:00
2012-06-25 00:00:00
2012-07-23 00:00:00
2012-08-20 00:00:00
2012-09-24 00:00:00
2012-10-25 00:00:00
2012-11-26 00:00:00
2012-12-21 00:00:00
2013-01-22 00:00:00
2013-02-25 00:00:00
2013-03-25 00:00:00
2013-04-22 00:00:00
2013-05-20 00:00:00
2013-06-24 00:00:00
2013-07-22 00:00:00
2013-08-20 00:00:00
2013-09-23 00:00:00
2013-11-12 00:00:00
2013-11-27 00:00:00
2013-12-23 00:00:00
2014-01-23 00:00:00
2014-02-24 00:00:00
2014-03-24 00:00:00
2014-04-21 00:00:00
2014-05-22 00:00:00
2014-06-23 00:00:00
2014-07-21 00:00:00
2014-08-25 00:00:00
2014-09-22 00:00:00
2014-10-23 00:00:00
Spreadsheet: a9a589dd-d64d-4b70-84e4-5132a678cd41
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
FLIPR | Test | FLIPR | Lipase, [NAME] | Lipase, [NAME] | [NAME] | [NAME], sterile container: SrwStlCont |  |  | 2 | mL | 2 mL random urine, no preservatives, in a sterile screw capped container shipped ambient. NOTE: 1) Also acceptable, 24 hour or first void clean catch.                 2) Indicate on container and request form collection duration. | 1 mL | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Adult:  4 U/L or less  Test Performed By:  Quest Diagnostics Nichols Institute                                          33608 [NAME]                                          San Juan Capistrano, CA  92690-6130 | 5 days per week; A.M. | 1day | 3-4 days | 1 | 83690 |  |  |  |  | Quest Diagnostics/Nichols Institute
FLIPR | [NAME] | URINE | [NAME] |  |  |  | Ambient | 7 days
FLIPR | Result | Z1559 | Lipase, [NAME] | Lipase, [NAME] | Alphanumeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Parts Shipments -  GE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  | * |  |  |  |  | * | * | * | * |  |  | * | * | *
 |  |  |  | CENTRE OF EXCELLENCE (COE) - OFF SHORE SUPPLIERS |  |  |  |  |  | PACING & LOGISTICS TEAM - SA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOGISTIC LEAD TIMES
 |  | No | Shipment Readiness - GESA Notified | [NAME] | GESA PO Line | Eskom PO Line | GESA PO | Shipment Value (GBP) | Shipment Value (EUR) | Shipment Status | Region | Power Station | Eskom Customer PO | Eskom End User | Delivery Note | Weight - Kg | Date : Sent to FF | Week | WBS | Actual Collection Date - Ex Works | Actual Date - Shipment docs received | Actual Date - Sent to Part team | Pacing Risk | GE Comments | GESA Notification - FF (Days) | GESA Notification - FF | Actual collection(Days) | Actual collection (Status) | Eskom-Actual collection(Days) | Eskom - Actual collection (Status) | Shipment Value (GBP to USD) | Shipment Value (EUR to USD) | Shipment Value (GBP to USD) | Shipment Value (EUR to USD) | Shipment Value (USD)
 |  | 1 | 2019-05-16 00:00:00 | 451769 |  |  | 4200168618 | 15014.72 |  | Delivered | UK | Tutuka | 4502848390 | Tsakani Pearl Shingange | 80548281 |  | 2019-05-16 00:00:00 |  | ES0-472917 | 2019-05-17 00:00:00 | 2019-05-24 00:00:00 | 2019-05-24 00:00:00 | Low | Sent docs : PF team to invoice request
Spreadsheet: andy_zipper__177__DYNEGY-ICE VOL Apr25
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 460000 |  | Carson , M | Firm-LD Peak | MWhs | 3 | 12000
Gagliardi, L | Gasoline Crack | bbl | 1 | 50000 |  | Dorland , C | Firm-LD Peak | MWhs | 9 | 58400
Grand Total |  |  | 2 | 510000 |  | [NAME], R | Firm-LD Peak | MWhs | 5 | 119200
 |  |  |  |  |  | Grand Total |  |  | 17 | 189600
Spreadsheet: 453934d1459522024-countif-function-for-every-column-where-header-equals-date-count-occurrences-in-column-example
Sheet: Sheet3

 | Date | Date | Date | Date | Date | Date
Sample Name | 2016-01-06 00:00:00 | 2016-01-13 00:00:00 | 2016-01-18 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-02-16 00:00:00
S21 | N/A | Down | N/A | N/A | Down | Down
S22 | N/A | Down | N/A | N/A | Down | Down
S23 | N/A | 0 | 0 | N/A | 0 | 0
S24 | N/A | 0 | 0 | N/A | 0 | 0
S25 | N/A | 0 | 1 | N/A | 0 | 0
S26 | N/A | 0 | 0 | N/A | 0 | 0
[NAME] | N/A | 1 | N/A | N/A | 0 | 0
S28 | N/A | 3 | N/A | N/A | 4 | 0
S29 | N/A | 0 | N/A | 0 | 0 | 0
S30 | N/A | 0 | N/A | 0 | 0 | 0
Spreadsheet: db6d44ba-abd3-4d3d-bdd6-b9dc1cc50877
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | McCoy-Davis | Regina | [EMAIL] | [PHONE] |  | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | McNair | Emilie | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Wilson | [NAME] | [EMAIL] | [PHONE] | 36-334-7264 | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Louis | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Hayford | [NAME] | [EMAIL] | [PHONE] |  |  |  | Raleigh | NC | 27695
UNC Asheville | Cutspec | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Covington | [NAME] | [EMAIL] | [PHONE] |  |  |  | Chapel Hill | NC | 27599
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Saxton | Tresa | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Bullard | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Wesner | Katrin | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | Potter | [NAME] | [EMAIL] | [PHONE] |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | [NAME] | Ether | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 759429d1639534446-sum-if-array-produces-zero-arrayproblem
Sheet: Worksheet 2

Date |  | Name |  |  | G | Min | Poss
2021-10-20 00:00:00 |  | P1 |  |  | 1 | 15.54
2021-10-20 00:00:00 |  | P2 |  |  | 1 | 23.47
2021-10-20 00:00:00 |  | P3 |  |  | 1 | 19.01
2021-10-20 00:00:00 |  | P4 |  |  | 1 | 41.26
2021-10-20 00:00:00 |  | P5 |  |  | 1 | 13.25
2021-10-20 00:00:00 |  | P6 |  |  | 1 | 2.15
2021-10-20 00:00:00 |  | P7 |  |  | 1 | 19.45
2021-10-20 00:00:00 |  | P8 |  |  | 1 | 34.12
2021-10-20 00:00:00 |  | P9 |  |  | 1 | 38.56
2021-10-20 00:00:00 |  | P10 |  |  | 1 | 33.44
2021-10-20 00:00:00 |  | P11 |  |  | 1 | 12.77
2021-10-20 00:00:00 |  | P12 |  |  | 1 | 4.95
2021-10-20 00:00:00 |  | P13 |  |  | 1 | 28.04
2021-10-20 00:00:00 |  | P14 |  |  | 1 | 33.33
2021-10-20 00:00:00 |  | P15 |  |  | 1 | 27.45
2021-10-20 00:00:00 |  | P16 |  |  | 1 | 12.88
2021-10-20 00:00:00 |  | P17 |  |  | 1 | 18.4
2021-10-22 00:00:00 |  | P18 |  |  | 1 | 3.6
2021-10-22 00:00:00 |  | P19 |  |  | 1 | 5.88
2021-10-22 00:00:00 |  | P20 |  |  | 1 | 6.9
Spreadsheet: 0d2dc6ba-9b03-4a1e-a87e-5273ef172cc2
Sheet: Instructions for Completion

Instructions for Completing Worksheet
for Adjustment of Claims
for Miscategorized At-Risk Students
 |  |  |  |  |  |  |  | Date
This form is provided by the Kansas State Department of Education (KSDE), Child Nutrition & Wellness.  For
assistance in completing this form, call [PHONE].
Instructions for Items to be Completed by KSDE Auditor
Sponsor Name and Number |  | Enter Sponsor's name and number.
School Year |  | Enter school year of report.
Student's Name |  | Name of student on district's at-risk count who is not eligible for free meals
 |  | or who had other category changes found during School Nutrition Program audit
[NAME] |  | Name of building where student attends
Benefit Change |  | Indicate the change made to the student's eligibility status.
Reason for Change |  | Indicate the income amount and number of people in household.
Instructions for Items to be Completed by Sponsor's Authorized Representative
Months Revised |  | Check all months in which it is necessary to revise your Claim for
 |  | Reimbursement for School Nutrition Programs.
Meals Claimed |  | For each month checked, indicate the number of meals revised due to the
 |  | eligibility change for this student.  If no meals were claimed for the student, put
 |  | "0".
Notification to Household of |  | Date the Notification to Household of Change or Termination in Benefits was
Change or Termination in |  | mailed
Benefits
Sponsor Representative |  | Signature of [NAME]'s representative completing this form.
Title |  | Title of [NAME]'s representative completing this form.
Date |  | Date this form was completed
The Sponsor's Authorized Representative should submit to School Finance within 30 days of this notice, the
Adjustment of Claims Worksheet for Miscategorized At-Risk Students along with a revised claim form for each
month changed by these adjustments. Actual claim revisions will be made by School Finance.  A copy of the
Adjustment of Claims Worksheet for Miscategorized At-Risk Students and revised claim forms should be kept on file
at the district for future review or audit of the School Nutrition Program.
The above information is due to School Finance on:
- 2 -
Spreadsheet: 778309d1650988882-convert-debit-value-to-a-negative-number-book2
Sheet: Sheet1

debit_ | or_c | redit value
CREDIT | GBP | 35548.19
DEBIT | GBP | 32111.45
CREDIT | GBP | 17957.74
DEBIT | GBP | 3362.38
CREDIT | GBP | 2012.23
DEBIT | GBP | 4041.13
Spreadsheet: 32880d1229039346-sumif-by-row-time-calculation-issues-sample
Sheet: Sheet1

 | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 | Activity | Start | Finish | Activity | Start | Finish | Activity | Start | Finish | Activity | Start | Finish | Activity | Start | Finish
[NAME] | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:00:00 | Night | 18:00:00 | 06:00:00 | Night | 18:00:00 | 06:00:00
[NAME] | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:30:00 | Night | 17:45:00 | 06:00:00 | Night | 18:00:00 | 06:00:00
[NAME] | Night | 18:00:00 | 06:00:00 | Night | 18:00:00 | 06:00:00 | Night | 18:00:00 | 06:00:00 | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:00:00
[NAME] | Night | 18:00:00 | 06:00:00 | Night | 18:00:00 | 06:00:00 | Night | 18:00:00 | 06:00:00 | Day | 06:00:00 | 18:00:00 | Day | 06:00:00 | 18:00:00
[NAME] | Holiday | 08:00:00 | 16:00:00 | Holiday | 08:00:00 | 16:00:00 | Holiday | 08:00:00 | 16:00:00 | Day | 06:00:00 | 18:00:00 | Night | 18:00:00 | 06:00:00
 | Day shifts | Day hours | Night shifts | Night hours | Holiday
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
How to calculate the number of day shifts and day hours, night shifts and night hours, and hours on holiday.
Shifts have differing start and finish times
Night shifts start in the evening of Day 1 (18:00) and finish on the morning of the following day (Day 2 - 06:00)
Spreadsheet: 76535d1277102562-sorting-a-football-soccer-league-table-football
Sheet: TABLE

 |  | PREMIER LEAGUE
POSTION |  | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS |  |  |  |  |  | Rank |  |  | STANDINGS
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  | CHAMPIONSHIP
POSTION |  | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS |  |  |  |  |  | Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 |  | LEAGUE ONE
POSTION |  | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 |  | LEAGUE TWO
POSTION |  | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 |  | PLAYERS PREDICTION TABLE
POSTION |  | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - CS-SPD BULK #2

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD BULK #3
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
 | *NO STAT HOLIDAYS
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-WRAPPER 36" |  |  |  | BP0005 |  | 20
20-WRAPPER 54" |  |  |  | BP0007 |  | 13
UPDATED:
June 17th 2009
Spreadsheet: 677365d1589314471-vlookup-with-wildcard-not-working-formula
Sheet: SHEET1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-30 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 200
2020-03-20 00:00:00 | CARD PAYMENT TO WILKO RETAIL LIMITED,1.50 GBP, RATE 1.00/GBP ON 18-03-2020 |  | 1.5
2020-03-19 00:00:00 | CARD PAYMENT TO SELCO TRADING CTR,64.56 GBP, RATE 1.00/GBP ON 17-03-2020 |  | 50
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO THAMES WATER REF 123456789, MANDATE NO 0080 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO MORTGAGES 999999A, MANDATE NO 0085 |  | 150
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO BG SERVICES REF 987654159D, MANDATE NO 0079 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO REF GHTY7415, MANDATE NO 0059 |  | 300
2020-03-11 00:00:00 | ARRANGED OVERDRAFT USAGE FEE |  | 20
2020-02-19 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 3000
2020-02-19 00:00:00 | MAINTAINING THE ACCOUNT - MONTHLY FEE |  | 5