tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c20fbe19-caf9-4afb-a518-da4778ea8fba
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75678696060 | Needtobreathe | Natural Splice Large Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678696053 | Needtobreathe | Natural Splice Medium Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678696046 | Needtobreathe | Natural Splice Xlarge Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678695971 | Needtobreathe | Black Scribble Stack Medium Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678695964 | Needtobreathe | Black Scribble Stack Large Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678695957 | Needtobreathe | Black Scribble Stack Xlarge Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Merch | 679143015822 | Needtobreathe | Unisex Band [NAME] Xlarge | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015815 | Needtobreathe | Unisex Band [NAME] Large | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015808 | Needtobreathe | Unisex Band Logo Size Medium | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015792 | Needtobreathe | Unisex Band [NAME] | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Spreadsheet: 779975d1652220878-i-need-help-formulas-working-different-on-different-computers-state-office-locator-sheet-for-forum
Sheet: Sheet2

City | County | [NAME] | Nearest Remote Office | Link to Remote Page
Aberdeen | Bingham | Pocatello | Aberdeen | https://idahomobile.wpcomstaging.com/aberdeen-office-hours/
Acequia | Minidoka | Burley | N/A | N/A
Addie | Boundary | Sandpoint | Moyie Springs | https://idahomobile.wpcomstaging.com/moyie-springs-office-hours/
Ahsahka | Clearwater | Lewiston | [NAME] | https://idahomobile.wpcomstaging.com/orofino-office-hours/
[NAME] | [NAME] | Sandpoint | Priest River | https://idahomobile.wpcomstaging.com/priest-river-office-hours/
Albion | Cassia | Burley | N/A | N/A
[NAME] | [NAME] | Pocatello | [NAME] | https://idahomobile.wpcomstaging.com/soda-spring-office-hours/
Almo | Cassia | Burley | N/A | N/A
Alpine | [NAME] | Boise | Midvale | https://idahomobile.wpcomstaging.com/midvale-office-hours/
Alridge | Bingham | Idaho Falls | Blackfoot | https://idahomobile.wpcomstaging.com/blackfoot-office-hours/
American Falls | Power | Pocatello | American Falls | https://idahomobile.wpcomstaging.com/american-falls-office-hours/
[NAME] | [NAME] | Idaho Falls | N/A | N/A
Amsterdam | [NAME] | [NAME] | N/A | N/A
[NAME] | Power | Pocatello | N/A | N/A
Spreadsheet: 4810325b-0300-4cff-bcd0-b3dfbc42af26
Sheet: Sheet1

Unnamed: 0 | ALLOCATION CATEGORY UPDATE CROSS-WALK, FY11 [NAME] in FY12 | Unnamed: 2
 | ALLOCATION CATEGORY - OLD - FY 2011 | COLLAPSED TO ALLOCATION CATEGORY IN FY 2012
 | ARRA AUTOMOTIVE | Expired
 | ARRA COMPUTER CERTIFICATION | Expired
 | ARRA CULINARY ARTS | Expired
 | ARRA Every Arts | Expired
 | IDEA ARRA CTT | TL Fair Student Funding
 | IDEA ARRA Mandatory CEIS - Schools | Expired
 | IDEA ARRA RELATED SERVICE IEP PARA | TL IEP Para
 | Title I ARRA Pre-K | Pre-K Title I
 | TITLE I ARRA SWP | TL Fair Student Funding
 | TITLE I ARRA TA | TL Fair Student Funding
 | TL CFES Ed Jobs Support Staff | TL Fair Student Funding
 | TL Children First Operating Funds | TL Fair Student Funding
 | TL DRA Stabilization | TL Fair Student Funding
 | TL DRA STABILIZATION HS | TL Fair Student Funding
 | TL Fair Student Funding Incremental | TL Fair Student Funding
 | TL FSF General Hold Harmless | TL Fair Student Funding or TL Funds Over Formula
 | TL IDEA ARRA OT PT THERAPIST SHARED | TL Therapist PS Shared
 | TL Open Schools Saved Jobs | TL Fair Student Funding
 | TL Open Schools Saved Jobs Additional | TL Fair Student Funding
 | Revised July 7, 2011
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 11

Name | lbs | oz | Oz (total) | Points
 | 27 | 0
 | 21 | 5
 | 16 | 0
 | 24 | 2
 | 0 | 0
 | 2 | 1
 | 23 | 0
 | 2 | 0
 | 11 | 0
 | 0 | 0
 | 36 | 0
 | 2 | 0
 | 32 | 5
 | 0 | 2
Spreadsheet: 798159d1664345414-data-manipulation-multiple-formats-newgen-test-aligw
Sheet: Sheet1

 |  | QUANTITY/ LENGTH |  | INTERNAL CODE
 | INPUT --> | 1 x 6.5 m |  | 1606067-059 |  | EXPECTED OUTPUT--> | 1606067-06500-059 |  | OUTPUT -->
 |  | 1 x 5.48 m |  | 1606076-059 |  |  | 1606076-05480-059
 |  | 1 x 4.75 m |  | 1608204-100 |  |  | 1608204-04750-059
 |  | 1 x 3 m |  | 1608206-098 |  |  | 1608206-03000-098
 |  | 1 x 5.45 m |  | 1608211-010 |  |  | 1608211-05450-010
 |  | 1 x 6.5 m |  | 1631011-0A5 |  |  | 1631011-06500-0A5
 |  | 1 pc |  | 1317025-031 |  |  | 1317025-031 |  | NO GOOD -->
 |  | 1 pc |  | 1317049-0A6 |  |  | 0317049-0A6
 |  | 1 pc |  | 1317050-0A6 |  |  | 1317050-0A6
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: EAST-MKT-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  LRC
REGION:  MARKET EAST
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 155756d1337027074-summing-arrays-sum
Sheet: Sheet1

d | a | d | s
1 | 2 | 3 | 4
 | #[NAME]! | 3 | #[NAME]! |  | 1st: Finds "d" in 1:1 and displays relevant values from 3:3
 | 0 | 3 | 0 |  | 2nd: Converts errors to 0. don’t ask why this way - it comes from real spreadsheet
 | 0 | 3 | 0 |  | 3rd: megaformula - 1st+2nd
 | 0 | 3 | 0 |  | 4rd: Sum function which Excel decides to ignore??????????????
Spreadsheet: 584914d1533524294-how-to-merge-rows-but-create-seperate-rows-for-data-copy-of-mock-up-example-yurbuddychris-
Sheet: PT

Sum of Amount |  |  | Year
Name | Address | Category | 2015 | 2016 | 2017 | 2018
[NAME] | 2 South 1st St | B | 10 | 20 | 30 | 40
[NAME] | 1 Main St | A | 200 | 250 | 300 | 350
[NAME] | 3 Maple Ave | A | 100 | 100 | 100 | 100
Spreadsheet: 818220d1676650920-im-tracking-temperature-for-the-days-looking-for-help-temperature-sample3
Sheet: Temp Sample

Temperature
 | High | Low
2022-12-30 00:00:00 | 80.67 | 77.71
2023-01-03 00:00:00 | 81.5 | 76.6
2023-01-04 00:00:00 | 77.42 | 72.73
2023-01-05 00:00:00 | 74.92 | 72.46
2023-01-06 00:00:00 | 75.47 | 73.24
2023-01-09 00:00:00 | 76.74 | 73.47
2023-01-10 00:00:00 | 75.92 | 73.84
2023-01-11 00:00:00 | 77.84 | 74.31
2023-01-12 00:00:00 | 79.16 | 77.1
2023-01-13 00:00:00 | 80.11 | 77.97
2023-01-17 00:00:00 | 81.23 | 78.53
2023-01-18 00:00:00 | 82.66 | 79.21
2023-01-19 00:00:00 | 81.49 | 78.45
2023-01-20 00:00:00 | 81.91 | 79.91
2023-01-23 00:00:00 | 82.64 | 81.05
2023-01-24 00:00:00 | 82.22 | 79.66
2023-01-25 00:00:00 | 81.23 | 79.45
2023-01-26 00:00:00 | 82.14 | 79.92
2023-01-27 00:00:00 | 82.48 | 79.04
2023-01-30 00:00:00 | 80.49 | 77.66
2023-01-31 00:00:00 | 79.25 | 76.55
2023-02-01 00:00:00 | 79.73 | 76.05
2023-02-02 00:00:00 | 77.24 | 74.97
2023-02-03 00:00:00 | 78 | 73.1
2023-02-06 00:00:00 | 74.51 | 72.25
2023-02-07 00:00:00 | 77.6 | 74.35
2023-02-08 00:00:00 | 78.57 | 77.08
2023-02-09 00:00:00 | 78.84 | 76.52
2023-02-10 00:00:00 | 80.33 | 77.47
2023-02-13 00:00:00 | 80.62 | 78.45
2023-02-14 00:00:00 | 79.61 | 77.46
Spreadsheet: a1d16878-79a4-4d03-9242-9d391fc76c9e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended March 31,
(In millions, except percentage information) |  |  |  |  |  | 2008 |  |  | 2007
Gross Sales |  |  |  |  | $ | 1006.7 |  | $ | 1024.8
[NAME] |  |  |  |  |  | -87.4 |  |  | -84.5
Net Sales |  |  |  |  | $ | 919.3 |  | $ | 940.3
The financial information included herein should be read in conjunction with Mattel's consolidated financial
statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 179399d1347236822-downloaded-xls-from-credit-union-wont-open-in-excel-2k-ach
Sheet: Sheet1

Post Date | Check | Description | Debit | Credit | Status | Balance
2012-08-03 00:00:00 |  | AUTOMATIC PAYMENT - THANK YOU |  | 240.76 | Posted
2012-08-03 00:00:00 |  | HARVEST HOUSE COLBERT WA | 32.41 |  | Posted
2012-08-01 00:00:00 |  | [NAME] OR | 59.99 |  | Posted
2012-07-26 00:00:00 |  | DTV*DIRECTV SERVICE [PHONE] CA | 104.7 |  | Posted
2012-07-20 00:00:00 |  | THREE AMIGO'S PLUMBING AN [PHONE] ID | 291 |  | Posted
2012-07-19 00:00:00 |  | HARVEST HOUSE COLBERT WA | 26.49 |  | Posted
Spreadsheet: 179670d1347350774-some-sort-of-sumifs-to-remove-pivot-table-sumifs-of-months
Sheet: Example

DATA |  |  | INPUT
Date | Amount |  | Month: | February
2012-01-01 00:00:00 | 1 |  | Year: | 2012
2012-01-08 00:00:00 | 2
2012-01-22 00:00:00 | 3 |  | OUTPUT
2012-01-31 00:00:00 | 4 |  |  | solved
2012-02-01 00:00:00 | 5
2012-02-03 00:00:00 | 6
2012-02-20 00:00:00 | 7
2012-03-06 00:00:00 | 8
2012-03-15 00:00:00 | 9
DATA |  |  |  |  |  |  |  |  |  |  |  |  |  | INPUT
Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Month: | March
2012-01-01 00:00:00 | 1 | 2 | 1 | 8 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 3
2012-01-08 00:00:00 | 2 | 5 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | OUTPUT
2012-01-22 00:00:00 | 3 | 6 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 1 |  |  | [NAME]?
2012-01-31 00:00:00 | 4 | 8 | 4 | 7 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 8
2012-02-01 00:00:00 | 5 | 7 | 5 | 5 | 5 | 5 | 1 | 5 | 5 | 5 | 3 | 9
2012-02-03 00:00:00 | 6 | 6 | 6 | 8 | 6 | 2 | 4 | 6 | 4 | 6 | 6 | 6
2012-02-20 00:00:00 | 7 | 8 | 7 | 7 | 7 | 4 | 1 | 7 | 2 | 7 | 8 | 8
2012-03-06 00:00:00 | 8 | 6 | 8 | 8 | 8 | 6 | 8 | 8 | 8 | 8 | 8 | 1
2012-03-15 00:00:00 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 3 | 3
Totals
Spreadsheet: 770463d1646087531-calculating-by-quarter-based-on-dropdown-testdoc_new
Sheet: Worksheet

 |  | All Departments |  |  |  | Q1 |  | 2021-01-01 00:00:00 | 2021-03-31 00:00:00 |  | <Independently working/calculating  based on department selection for Q1
Date | Location | Department | Sold |  |  | Q2 |  | 2021-04-01 00:00:00 | 2021-06-30 00:00:00 |  | <Independently working/calculating  based on all departments selection for Q1
2021-01-06 00:00:00 | One | Department 1 | 16 | [NAME] |  | Q3 |  | 2021-07-01 00:00:00 | 2021-09-30 00:00:00 |  | (SOLVED in H8) Need to merge these formulas so that the number is  changing in the same cell. It should be changing (for example) to 61 if Department 1 is selected and changing to 83 if All Departments is selected.
2021-01-06 00:00:00 | One | Department 2 | 7 | [NAME] |  | Q4 |  | 2021-10-01 00:00:00 | 2021-12-31 00:00:00
2021-02-07 00:00:00 | Two | Department 3 | 15 | [NAME]
2021-03-31 00:00:00 | One | Department 1 | 45 | [NAME] |  | Quarter Selected: | 1
2021-04-02 00:00:00 | One | Department 2 | 66 | [NAME]
2021-04-03 00:00:00 | Two | Department 3 | 7 | [NAME] |  |  |  | <<<<Calculation as expected when Q1 or Q2.
2021-07-03 00:00:00 | Three | Department 4 | 32 | [NAME]
2021-10-04 00:00:00 | Two | Department 3 | 66 | [NAME]
 |  |  |  |  | 1
Spreadsheet: 106560d1303827209-vlookup-and-if-and-wages
Sheet: Name 1

Date Invoiced | Payment Due | Amount | Paid | Overdue
2011-04-26 00:00:00 |  | 100
Spreadsheet: fa747234-dd3a-4c63-962a-c446283d518c
Sheet: Sheet1

STATE REPRESENTATIVES - BELKNAP COUNTY ---   REPUBLICAN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | page 1 of 2
District No. 1 (1) | Wendelboe, r |  | Others
Center Harbor | 90 |  | 1
New Hampton | 137 |  | 2
TOTALS | 227
District No. 2 (2) | Fields, r | Scott, r | [NAME], d | Others | Merry
Sanbornton | 164 | 98 |  |  | 38
[NAME] | 134 | 129 | 1 | 2 | 5
TOTALS | 298 | 227 | 1 | 2 | 43
District No. 3 (2) | [NAME], r | Nedeau, r | Merrill, [NAME], d | Merrill, [NAME], d | [NAME] | Others
Meredith | 216 | 313 |  |  | 46 | 7
District No. 4 (5) | [NAME], r | [NAME], Jr., r | Dewhirst, r | Flanders, r | [NAME], r
[NAME] | 155 | 143 | 144 | 178 | 159
[NAME] | 105 | 99 | 105 | 118 | 102
[NAME] 3 | 131 | 125 | 124 | 154 | 133
[NAME] | 96 | 92 | 97 | 110 | 102
[NAME] | 72 | 78 | 74 | 83 | 76
[NAME] 6 | 132 | 155 | 137 | 147 | 137
TOTALS | 691 | 692 | 681 | 790 | 709
STATE REPRESENTATIVES - BELKNAP COUNTY ---   REPUBLICAN |  |  |  |  |  |  |  | page 2 of 2
District No. 4 (5) | Allard, d | [NAME], d | [NAME], d | Reever, d | Stuart, d |  | Others
[NAME] |  |  | 1 | 2 | 1 |  | 7
[NAME] | 2 | 1 | 1 | 1 |  |  | 2
[NAME] 3 |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  | 2
[NAME] 6 |  | 1 | 2 | 2 |  |  | 4
TOTALS | 2 | 2 | 4 | 5 |  |  | 18
District No. 5 (7) | Bolster, r | Boyce, r | Bungert, r | Christiansen, r | [NAME], r | Pilliod, r | St. Cyr, r | Swinford, r
Alton | 246 | 291 | 234 | 229 | 234 | 251 | 321 | 212
Barnstead | 157 | 124 | 130 | 140 | 134 | 139 | 158 | 131
Belmont | 153 | 172 | 128 | 140 | 157 | 180 | 150 | 129
Gilford | 321 | 343 | 214 | 262 | 382 | 366 | 299 | 243
TOTALS | 877 | 930 | 706 | 771 | 907 | 936 | 928 | 715
District No. 5 (7) | Bourbeau, d | [NAME], d | Hammond, d | [NAME], d | [NAME], d | [NAME], d |  | Others
Alton |  |  |  | 1 |  |  |  | 13
Barnstead |  |  |  |  |  |  |  | 5
Belmont |  | 1 |  |  |  |  |  | 4
Gilford |  |  |  |  |  |  |  | 10
TOTALS
 |  | 1 |  |  |  |  |  | 32
District No. 6 (1) | [NAME], r |  | Others
Gilmanton | 186 |  | 5
Spreadsheet: 111106d1307571948-solved-conditional-formatting-based-on-date-and-time-time-conditional-formatting-example-for-hackerjl
Sheet: Sheet1

Expected Time | Expected Date | Actual Time | Actual Date
08:00:00 | 2011-06-01 00:00:00 | 07:30:00 | 2011-06-01 00:00:00
08:00:00 | 2011-05-01 00:00:00 | 08:30:00 | 2011-05-01 00:00:00
08:00:00 | 2011-05-15 00:00:00 | 07:30:00 | 2011-05-15 00:00:00
08:00:00 | 2011-06-05 00:00:00 | 08:30:00 | 2011-06-05 00:00:00
08:00:00 | 2011-05-30 00:00:00 | 08:15:00 | 2011-05-30 00:00:00
Spreadsheet: 214985d1361217685-create-an-array-based-off-values-in-another-array-exclude-blanks-book1
Sheet: Sheet1

Community Manager | [NAME] |  | Community Manager | [NAME]
Assistant Manager | [NAME] |  | Assistant Manager | [NAME]
Resident Service Manager |  |  | Leasing Manager | [NAME]
Leasing Manager | [NAME] |  | Bookkeeper 1 | [NAME]
Bookkeeper 1 | [NAME] |  | Bookkeeper 2 | [NAME]
Bookkeeper 2 | [NAME] |  | Leasing Consultant 1 | [NAME]
Leasing Consultant 1 | [NAME] |  | Leasing Consultant 2 | [NAME]
Leasing Consultant 2 | [NAME] |  | Community Assistant 1 | [NAME]
Community Assistant 1 | [NAME] |  | Community Assistant 3 | [NAME]
Community Assistant 2 |  |  | Community Assistant 7 | [NAME]
Community Assistant 3 | [NAME] |  | Lead Service Technician | [NAME]
Community Assistant 4 |  |  | Assistant Service Technician 1 | [NAME]
Community Assistant 5 |  |  | Assistant Service Technician 2 | [NAME]
Community Assistant 6 |  |  | Housekeeper, Grounds, Make-Ready 1 | [NAME]
Community Assistant 7 | [NAME] |  | Housekeeper, Grounds, Make-Ready 2 | [NAME]
Community Assistant 8 |  |  | Housekeeper, Grounds, Make-Ready 3 | [NAME]
Community Assistant 9 |  |  | Housekeeper, Grounds, Make-Ready 8 | [NAME]
Community Assistant 10 |  |  | Housekeeper, Grounds, Make-Ready 9 | [NAME]
Community Assistant 11 |  |  | Housekeeper, Grounds, Make-Ready 10 | [NAME]
Community Assistant 12
Lead Service Technician | [NAME]
Assistant Service Technician 1 | [NAME]
Assistant Service Technician 2 | [NAME]
Assistant Service Technician 3
Assistant Service Technician 4
Assistant Service Technician 5
Housekeeper, Grounds, Make-Ready 1 | [NAME]
Housekeeper, Grounds, Make-Ready 2 | [NAME]
Housekeeper, Grounds, Make-Ready 3 | [NAME]
Housekeeper, Grounds, Make-Ready 4
Housekeeper, Grounds, Make-Ready 5
Housekeeper, Grounds, Make-Ready 6
Housekeeper, Grounds, Make-Ready 7
Housekeeper, Grounds, Make-Ready 8 | [NAME]
Housekeeper, Grounds, Make-Ready 9 | [NAME]
Housekeeper, Grounds, Make-Ready 10 | [NAME]
Spreadsheet: 690839d1597316503-help-with-count-if-book1
Sheet: Sheet1

20/21 |  |  |  | Category
20/21 rate short <10p |  |  |  | 20/21 rate minus 14%
 |  |  |  | 20/21 rate minus non dep(s)
 |  |  |  | 20/21 rate short £17 - £99
20/21 rate |  |  |  | 20/21 rate short £21 - £99
 |  |  |  | 20/21 rate short <10p
20/21 rate |  |  |  | 20/21 rate short >£100
 |  |  |  | 20/21 rate assumed as higher than 19/20
20/21 rate short <10p
20/21 rate
20/21 rate
20/21 rate short <10p
20/21 rate short >£100 |  | No. customers who have updated to 20/21 rate with queries
20/21 rate
20/21 rate short £17 - £99
20/21 rate
20/21 rate short >£100
20/21 rate
20/21 rate short <10p
20/21 rate short £17 - £99
20/21 rate
20/21 rate minus 14%
20/21 rate short £17 - £99
Spreadsheet: 683738d1592921620-incremental-formulas-filling-horizontal-issue-summary
Sheet: SUMMARY

CSL | 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
Working | 5 | 3 | 4 | 5 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 4
Sick | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
Holiday | 0 | 1 | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1
 | 2020-06-22 00:00:00 |  |  | 2020-06-23 00:00:00
 | Working | Sick | Hols | Working | Sick | Hols
CSL
Total
Spreadsheet: 540140d1506543514-create-a-list-if-cell-0-then-display-cell-copy-of-smr-costings-domestic-roofing-quotation-master-qrx-27-09-2017-list-of-inclusions
Sheet: Roofer W.O.

 | WORK ORDER
P.O. Number |  |  |  |  | RF
DATE
 | Supplier NAME
 | Supplier NAME
 | Supplier ABN/ACN
 | Supplier Address Line 1
 | Supplier Address Line 2
 | [NAME]
Site Address
 | Delivery Date/Start Date | To be confirmed
 | Must be completed by | To be confirmed
Site Contact |  | Shane Treacy [PHONE]
DESCRIPTION OF GOODS/SERVICES
[NAME] |  | Qty |  |  | Total
INSTALL METAL ROOF COVER |  |  |  |  |  |  |  | ESTIMATED DURATION - ROOFING LABOUR
Install Metal Roof Cover - Roofing Iron |  |  | m2 |  |  |  |  |  | Install Roofing Iron |  |  |  | Fibreglass/Polycarbonate |  |  | Whirlyvent
 | Fibreglass/Polycarbonate |  | Lm |  |  |  |  |  | Sisalation Foil |  |  |  | Metal Battens
Install Metal Battens |  |  | Lm |  |  |  |  |  | Anticon Blanket |  |  |  | [NAME]
Sisalation Foil |  |  | m2 |  |  |  |  |  | Safety Mesh |  |  |  | Hip
Anticon Blanket |  |  | m2 |  |  |  |  |  |  |  |  |  | Valley
 | Safety Mesh |  | m2 |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  | Lm |  |  |  |  |  |  |  |  |  | [NAME]
Hip |  |  | Lm |  |  |  |  |  |  |  |  |  | Parapet Capping
Valley |  |  | Lm |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  | Lm |  |  |  |  |  | Total SQM |  |  |  | Total Flashing |  |  | Total Ea
[NAME] |  |  | Lm
Parapet Capping |  |  | Lm |  |  |  |  | 45 | [NAME] |  |  | 40 | Lm per Hr |  | 1 | Ea per Hr
 | [NAME] |  | Lm |  |  |  |  | 360 | [NAME] |  |  | 320 | Lm per Day |  | 8 | Ea per Day
 | Whirlyvent |  | Ea
 |  |  |  |  |  |  |  |  | HRS |  |  |  | HRS |  |  | HRS
 | SUBTOTAL EXCL GST |  |  |  |  |  |  |  | DAY |  |  |  | DAY |  |  | DAY
 |  |  |  | GST % | 0.1
No works to [NAME] or Downpipes included in this Work Order |  |  |  | GST Amount
Payment will be made 14 days after the invoiced date. |  |  |  | TOTAL INCL GST
 | Invoice number: |  |  |  |  |  |  |  | HRS
 |  |  |  |  |  |  |  |  | DAY
Spreadsheet: 75820d1276413187-how-to-calculate-hours-across-a-specified-shift-weighting
Sheet: Sheet1

Team leader [NAME] time |  |  | F/time staff | enter total on your shift | P/time Staff | enter total on your shift
700 |  |  | 700-1500 | 10 | 0700-1300 | 1 |  |  |  |  |  |  | 700 | 17.375
 |  |  | 900-1700 | 4 | 0800-1400 | 0 |  |  |  |  |  |  | 900 | 17.625
 |  |  | 1030-1830 | 2 | 1100-1700 | 1 |  |  |  |  |  |  | 1300 | 12.125
 |  |  | 1100-1900 | 3 | 1500-2100 | 2
 |  |  | 1300-2100 | 2
 |  |  | 0700 ref data
 |  |  | 700-1500 | 1 | 0700-1300 | 0.75
 |  |  | 900-1700 | 0.75 | 0800-1400 | 0.75
 |  |  | 1030-1830 | 0.5625 | 1100-1700 | 0.5
 |  |  | 1100-1900 | 0.5 | 1500-2100 | 0
 |  |  | 1300-2100 | 0.25
 |  |  | 0900 ref data
 |  |  | 700-1500 | 0.75 | 0700-1300 | 0.5
 |  |  | 900-1700 | 1 | 0800-1400 | 0.625
 |  |  | 1030-1830 | 0.5625 | 1100-1700 | 0.75
 |  |  | 1100-1900 | 0.75 | 1500-2100 | 0.25
 |  |  | 1300-2100 | 0.5
 |  |  | 1300 ref data
 |  |  | 700-1500 | 0.25 | 0700-1300 | 0
 |  |  | 900-1700 | 0.5 | 0800-1400 | 0.125
 |  |  | 1030-1830 | 0.6875 | 1100-1700 | 0.5
 |  |  | 1100-1900 | 0.75 | 1500-2100 | 0.75
 |  |  | 1300-2100 | 1
Total coverage across your shift |  |  | 17.375
Spreadsheet: 663519ee-e3b0-4a8f-be23-5aafc19da1a2
Sheet: Table 2

 | Total Occupied | Owner-Occupied | Renter-Occupied | [NAME]
[NAME] | 920796 | 674295 | 246501
Chicago | 1045560 | 469562 | 575998
DuPage | 337132 | 251835 | 85297
[NAME] | 170479 | 130570 | 39909
Kendall | 38022 | 32554 | 5468
Lake | 241712 | 185213 | 56499
McHenry | 109199 | 90722 | 18477
Will | 225256 | 187425 | 37831
Total | 3092325 | 2025801 | 1066524
Spreadsheet: 100251d1298652508-copy-a-row-the-number-of-times-listed-in-a-cell-book1
Sheet: Sheet1

SAMPLE_ID | INJECTIONS
Control | 2
Rinse | 1
STD 1 | 1
STD 2 | 1
STD 3 | 1
100001 | 2
100002 | 2
100003 | 2
100004 | 2
Control | 2
Rinse
Bracket
100005 | 2
100006 | 2
100007 | 2
100008 | 2
Control | 2
Rinse | 1
Bracket | 3
Product | 5
Control | 2
Rinse | 1
Bracket | 3
Spreadsheet: 219624d1362829918-closest-match-multiple-variables-closest-time
Sheet: Sheet2

DIRMKT | TIME | YEAR |  |  |  | [NAME] time | DIRMKT | TIME | YEAR
ALBDCA | 535 | 2012 |  |  |  |  | AGSDCA | 1940 | 2013
BDADCA | 1255 | 2012 |  |  |  |  | ALBDCA | 1153 | 2013
BDLDCA | 620 | 2012 |  |  |  |  | ALBDCA | 1710 | 2013
BDLDCA | 938 | 2012 |  |  |  |  | BDADCA | 1350 | 2013 |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/905570-closest-match-multiple-variables.html
BDLDCA | 1150 | 2012 |  |  |  |  | BDLDCA | 620 | 2013
BDLDCA | 1338 | 2012 |  |  |  |  | BDLDCA | 938 | 2013
BDLDCA | 1635 | 2012 |  |  |  |  | BDLDCA | 1152 | 2013
BDLDCA | 1939 | 2012 |  |  |  |  | BDLDCA | 1330 | 2013
BHMDCA | 1755 | 2012 |  |  |  |  | BGRDCA | 1727 | 2013
Spreadsheet: 781869d1653594943-filter-issue-with-date-dateissue
Sheet: Sheet1

Date | Amount
1/15/2021 | 800
1/29/2021 | 800
10/22/2021 | 800
10/8/2021 | 800
11/19/2021 | 800
11/5/2021 | 800
12/17/2021 | 800
12/3/2021 | 800
12/31/2021 | 800
2/12/2021 | 800
2/26/2021 | 800
3/12/2021 | 800
3/26/2021 | 800
4/23/2021 | 800
4/9/2021 | 800
5/21/2021 | 800
5/7/2021 | 800
6/18/2021 | 800
6/4/2021 | 800
7/16/2021 | 800
7/2/2021 | 800
7/30/2021 | 800
8/13/2021 | 800
8/27/2021 | 800
9/10/2021 | 800
9/24/2021 | 800