tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0c4e17a7-e647-4461-bf59-713bb6011559
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 15. HOUSING FINANCE SEASONAL FACTORS, BY STATE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ;  Number of Commitments ; |  |  | Original | A2433086W | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
New South Wales ;  Value of Commitments ; |  |  | Original | A2433087X | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Victoria ;  Number of Commitments ; |  |  | Original | A2433088A | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Victoria ;  Value of Commitments ; |  |  | Original | A2433089C | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Queensland ;  Number of Commitments ; |  |  | Original | A2433090L | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Queensland ;  Value of Commitments ; |  |  | Original | A2433091R | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
South Australia ;  Number of Commitments ; |  |  | Original | A2433092T | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
South Australia ;  Value of Commitments ; |  |  | Original | A2433093V | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Western Australia ;  Number of Commitments ; |  |  | Original | A2433094W | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Western Australia ;  Value of Commitments ; |  |  | Original | A2433095X | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Tasmania ;  Number of Commitments ; |  |  | Original | A2433096A | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Tasmania ;  Value of Commitments ; |  |  | Original | A2433097C | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Northern Territory ;  Number of Commitments ; |  |  | Original | A2433098F | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Northern Territory ;  Value of Commitments ; |  |  | Original | A2433099J | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Number of Commitments ; |  |  | Original | A2433100F | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Value of Commitments ; |  |  | Original | A2433101J | 1975-10-01 00:00:00 | 2013-02-01 00:00:00 | 449 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 127476d1320360765-excel-2007-copying-totals-of-values-from-one-sheet-to-another-braexample
Sheet: Ball Make Up - Sizes

 | AAA | AA | A | B | C | D | DD | E | F | FF | G | GG | H | HH | J | JJ | K | L | M | N | Total
28 |  | 2 |  |  |  | 2 | 4 | 2 | 1 |  | 3 |  | 1 |  | 1
30 |  | 2 |  |  | 2 |  | 1 | 3 |  |  | 3 |  |  |  |  |  | 1 |  | 1
32 |  | 2 | 17 | 19 | 10 | 8 | 10 | 6 | 15 |  | 3 | 3 | 1 |  | 1 |  |  |  | 1
34 |  | 2 | 6 | 23 | 30 |  | 14 | 7 | 4 |  | 4 | 3
36 |  |  | 22 | 44 | 47 | 24 | 2 | 1 | 3 | 6 | 3 | 3
38 |  | 3 | 9 | 17 | 13 | 26 | 13 | 4 | 6 |  | 6 |  |  |  |  |  |  | 1
40 |  |  | 2 | 5 | 2 | 10 | 1 | 1 | 1
42 |  |  |  |  | 1 |  | 6
44 |  |  |  | 1 | 1 |  |  |  | 1 |  |  |  |  |  | 1
46 |  |  |  |  |  |  |  |  |  |  |  |  | 1
48
50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
52 |  |  |  |  |  |  |  |  | 1
54 |  |  |  |  |  |  |  |  |  |  | 1
56 |  |  |  |  | 3 |  |  | 1
58
Spreadsheet: 689235d1596204647-redundancy-pay-calculations-wip-redundancy-schedule-v1
Sheet: Sheet1

Name | Date of Birth | Age  (as at 31.07.2020) | Start Date | Years of Service | Annual Pay | Weekly Pay | Weekly Pay (Statutory Cap) | Termination Date | Redundancy Entitlement | Redundancy Pay ([NAME] £16,140) | Statutory Notice Period (Cap 12 weeks)
1 | 1960-11-06 00:00:00 |  | 1994-10-01 00:00:00 |  | 18001.36 | 1501.126153846154 |  | 2020-09-01 00:00:00
2 | 1965-03-28 00:00:00 |  | 2000-01-24 00:00:00 |  | 78058.76 | 346.1753846153846 |  | 2020-09-01 00:00:00
3 | 1945-05-16 00:00:00 |  | 1996-05-01 00:00:00 |  | 19851 | 39.22 |  | 2020-09-01 00:00:00
4 | 1962-08-08 00:00:00 |  | 1998-09-07 00:00:00 |  |  | 135.1661538461539 |  | 2020-09-01 00:00:00
5 | 1962-11-25 00:00:00 |  | 1998-12-07 00:00:00 |  |  | 912.75 |  | 2020-09-01 00:00:00
6 | 1969-04-10 00:00:00 |  | 2000-03-15 00:00:00 |  |  | 255.2492307692308 |  | 2020-09-01 00:00:00
7 | 1970-07-31 00:00:00 |  | 2000-03-31 00:00:00 |  |  | 67.10230769230769 |  | 2020-09-01 00:00:00
8 | 1944-08-26 00:00:00 |  | 2002-11-11 00:00:00 |  |  | 181.1430769230769 |  | 2020-09-01 00:00:00
9 | 1973-02-22 00:00:00 |  | 2004-07-17 00:00:00 |  |  | 112.3669230769231 |  | 2020-09-01 00:00:00
10 | 1987-10-31 00:00:00 |  | 2004-11-24 00:00:00 |  |  | 455.6353846153846 |  | 2020-09-01 00:00:00
11 | 1977-01-26 00:00:00 |  | 1999-01-03 00:00:00 |  |  | 478.786923076923 |  | 2020-09-01 00:00:00
12 | 1965-05-29 00:00:00 |  | 1981-12-17 00:00:00 |  |  | 633.3761538461538 |  | 2020-09-01 00:00:00
13 | 1965-07-19 00:00:00 |  | 1997-04-01 00:00:00 |  |  | 583.0392307692308 |  | 2020-09-01 00:00:00
Spreadsheet: 721111d1614499808-find-last-and-first-non-zero-value-for-particular-lookup-criteria-book2
Sheet: Sheet1

Date | Product | Value
2020-01-01 00:00:00 | Ship | 10
2020-01-01 00:00:00 | Car | 50
2020-01-01 00:00:00 | Train | 0
2020-01-01 00:00:00 | Boat | 0
2020-01-01 00:00:00 | Van | 20
2020-01-01 00:00:00 | Trailer | 0
2020-01-01 00:00:00 | Motocycle | 30
2020-01-01 00:00:00 | Plain | 40
2020-02-01 00:00:00 | Ship | 0
2020-02-01 00:00:00 | Car | 20
2020-02-01 00:00:00 | Train | 30
2020-02-01 00:00:00 | Boat | 0
2020-02-01 00:00:00 | Van | 10
2020-02-01 00:00:00 | Trailer | 0
2020-02-01 00:00:00 | Plain | 0
2020-03-01 00:00:00 | Ship | 30
2020-03-01 00:00:00 | Car | 0
2020-03-01 00:00:00 | Train | 0
2020-03-01 00:00:00 | Boat | 0
2020-03-01 00:00:00 | Van | 0
2020-03-01 00:00:00 | Trailer | 40
2020-03-01 00:00:00 | Motocycle | 0
2020-03-01 00:00:00 | Plain | 10
2020-04-01 00:00:00 | Ship | 20
2020-04-01 00:00:00 | Car | 0
2020-04-01 00:00:00 | Train | 0
2020-04-01 00:00:00 | Boat | 0
2020-04-01 00:00:00 | Van | 0
2020-04-01 00:00:00 | Trailer | 0
2020-04-01 00:00:00 | Motocycle | 20
2020-04-01 00:00:00 | Plain | 0
2020-05-01 00:00:00 | Ship |  |  |  |  |  |  | 20 |  | 2020-04-01 00:00:00
2020-05-01 00:00:00 | Car |  |  |  |  |  |  | 20 |  | 2020-02-01 00:00:00
2020-05-01 00:00:00 | Train |  |  |  |  |  |  | 30 |  | 2020-02-01 00:00:00
2020-05-01 00:00:00 | Boat |  |  |  |  |  |  | 0 |  | 0 | because there is no value greater than zero
2020-05-01 00:00:00 | Van |  |  |  |  |  |  | 10 |  | 2020-02-01 00:00:00
2020-05-01 00:00:00 | Trailer |  |  |  |  |  |  | 40 |  | 2020-03-01 00:00:00
2020-05-01 00:00:00 | Motocycle |  |  |  |  |  |  | 20 |  | 2020-04-01 00:00:00
2020-05-01 00:00:00 | Plain |  |  |  |  |  |  | 10 |  | 2020-03-01 00:00:00
 |  | Last non zero value |  |  |  |  |  | Last non zero value |  | Date of last non zero value
Spreadsheet: 745791d1630213042-conditional-formatting-for-highlighting-month-if-dates-are-not-matched-sample1234556
Sheet: Sheet1

 |  |  | Month |  | Start Date | End Date
 |  |  | 2021-08-01 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00
 |  |  | 2021-08-02 00:00:00 |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00
 |  |  | 2021-08-03 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00
 |  |  | 2021-08-04 00:00:00 |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | Dates are not matching with the month
 |  |  | 2021-08-05 00:00:00 |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | Dates are not matching with the month
 |  |  | 2021-08-06 00:00:00 |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00
 |  |  | Start date and end date should fall within the month which is there in column D. If its not matching then the month column should be highligted. Here [NAME] and D8 is highligted because start date and end date is not matching as per that month.
Spreadsheet: 86707d1286665542-find-the-most-effective-manufacturer-per-sold-items-carpicker
Sheet: Sheet1

Manufacturer | Item: |  |  | Family car
Toyota | Motorcycle |  |  | Motorcycle
Hyundai | Family car |  |  | Bicycle
Toyota | Motorcycle
Hyundai | Family car
Honda | Family car
Kawasaki | Motorcycle | Table cannot be sorted!
Hyundai | Family car
Honda | Family car
Hyundai | Family car
Raleigh | Bicycle
Reynolds | Bicycle
 |  | [NAME] with
 |  | Data Validation |  | [NAME] needed here
First runner-up seller of |  | Bicycle | is: | Raleigh
When Family car is selected the result should be: Hyundai
When [NAME] is selected the result should be: Toyota
When [NAME] is selected the result should be: Raleigh BECAUSE IT IS THE FIRST MATCH FROM TWO POSSIBLE EQUAL MATCHES
Spreadsheet: 544221d1508816321-sorting-multiple-columns-individually-without-it-linking-all-of-the-other-rows-excel-forum-1
Sheet: Sheet1

Sun | Mon | Tue | Wed | Thu | Fri | Sat
29-Oct | 30-Oct | 31-Oct | 01-Nov | 02-Nov | 03-Nov | 04-Nov
Spreadsheet: andy_zipper__151__ICE - Mar26 Power & Gas VOL
Sheet: Enron Activity

Enron North America |  |  |  |  |  | Enron Power Marketing
 |  |  | Data |  |  |  |  |  | Data
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 16 | 25350000 |  | Carson , M | Firm-LD Peak | MWhs | 3 | 4000
[NAME], S | Crude | bbl | 2 | 660000 |  | Dorland , C | Firm-LD Peak | MWhs | 5 | 36000
 | Crude Diff | bbl | 1 | 600000 |  | Fischer, M | Firm-LD Peak | MWhs | 1 | 10000
Grand Total |  |  | 19 | 26610000 |  | [NAME], R | Firm-LD Peak | MWhs | 9 | 436000
 |  |  |  |  |  | Grand Total |  |  | 18 | 486000
Spreadsheet: 230153d1366704188-drop-down-list-using-multiple-worksheets-house-clearance-log-new-formula
Sheet: Raw Data

Customer Name | Customer Address | Date Enquiry Taken | Heard of us how? | Call Centre Member | Viewing Booked? Y/N | Viewing Date & Time | Viewer | Price Quoted | Clearance Booked? Y/N | Clearance Date | Clearance Time | [NAME]? Y/N | Amount Received |  |  |  |  |  |  |  |  |  |  |  | Viewing Booked | Viewers | Clearance Booked | Callcentre | Clearance Completed
Mr. [NAME] | 23 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-15 00:00:00 |  | Anne | yes | 2011-05-20 00:00:00 | Siôn | 300 | Yes | 2011-05-25 00:00:00 | 10am | Yes | 300 |  |  |  |  |  |  |  |  |  |  |  | Yes | Siôn | Yes | Anne | Yes
Mr. [NAME] | 24 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-16 00:00:00 |  | Anne | yes | 2011-05-21 00:00:00 | Siôn | 200 | Yes | 2012-07-10 00:00:00 | 10am | Yes | 200 |  |  |  |  |  |  |  |  |  |  |  | No | Shaun | No | [NAME] | No
Ms. [NAME] | 25 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-17 00:00:00 |  | [NAME] | yes | 2011-05-22 00:00:00 | Siôn | 250 | Yes | 2012-07-10 00:00:00 | 2pm | Yes | 250 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Leanne
 | 26 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-18 00:00:00 |  | [NAME] | yes | 2011-05-23 00:00:00 | Siôn | 200 | Yes | 2012-07-12 00:00:00 | 10am | Yes | 200 |  | Total Prices Quoted |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 27 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-19 00:00:00 |  | Leanne | yes | 2011-05-24 00:00:00 | Siôn | 300 | Yes | 2012-07-17 00:00:00 | 10am | Yes | 300 |  | Total Amounts Received |  |  |  |  |  |  |  |  |  |  |  |  | Sue
 | 28 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-20 00:00:00 |  | Sue | yes | 2011-05-25 00:00:00 | Siôn | 250 | Yes | 2012-07-26 00:00:00 | 10am | No | 0
Spreadsheet: phillip_allen__29456__Phillip Allen Muni Bond Proposal
Sheet: Enter

(000) |  |  |  |  |  |  | [NAME]. | [NAME]. Call | Par | Pre-Re
Par | DTD | Settlement | Rating | Description | Coupon | Maturity | Call | Price | Call | Y=Yes | Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SC
100 | 2001-12-01 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | NEW ORLEANS SWR | 0.05 | 2016-06-01 00:00:00 | 2011-06-01 00:00:00 | 101 | 2013-06-01 00:00:00 |  | 100
100 | 2001-12-15 00:00:00 | 2001-12-27 00:00:00 | AAA/AAA | LAFAYETTE IND PARK | 0.05 | 2017-01-15 00:00:00 | 2009-07-15 00:00:00 | 101 | 2011-07-15 00:00:00 |  | 99.997
100 | 1998-04-01 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | DALLAS TX CIVIC | 0.05 | 2018-08-15 00:00:00 | 2008-08-15 00:00:00 | 101 | 2010-08-15 00:00:00 |  | 99.993
100 | 2001-04-15 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | DENTON TX UTIL REV | 0.05125 | 2018-12-01 00:00:00 | 2011-06-01 00:00:00 | 100 |  |  | 100.929
100 | 1997-10-01 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | TX WTR DEV BRD | 0.05 | 2019-07-15 00:00:00 | 2007-07-15 00:00:00 | 101 | 2008-07-15 00:00:00 |  | 99.996
100 | 2001-11-01 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | HOUSTON TX CCD REVS | 0.05 | 2020-04-15 00:00:00 | 2011-04-15 00:00:00 | 100 |  |  | 99.399
100 | 2001-12-01 00:00:00 | 2001-12-27 00:00:00 | AAA/ | BENBROOK TX W/S REV | 0.05125 | 2021-12-01 00:00:00 | 2012-12-01 00:00:00 | 100 |  |  | 101.038
100 | 2001-11-15 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | GRANT CO WASH PUD | 0.05 | 2022-01-01 00:00:00 | 2007-01-01 00:00:00 | 100 |  |  | 98.752
100 | 2001-09-01 00:00:00 | 2001-12-20 00:00:00 | AAA/AAA | HOUSTON TX G.O. | 0.05 | 2022-03-01 00:00:00 | 2011-03-01 00:00:00 | 100 |  |  | 98.74
100 | 2001-12-01 00:00:00 | 2002-01-10 00:00:00 | AAA/AAA | MICHIGAN PUB PWR | 0.0525 | 2024-01-01 00:00:00 | 2012-01-01 00:00:00 | 100 |  |  | 100
 |  | Settlement |  | Enter Account/Broker Name: |  | [NAME]:
 |  | 2001-12-20 00:00:00 |  | HS-E4369-ME PHILLIP ALLEN |  | 1.538 |  |  |  |  | SC=
Spreadsheet: 20602743-7f2d-4eaf-ad68-eaec18e5266f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Contents |  | Page
Budget and Council Objectives |  | 2-3
Revenue Expenditure |  | 4
Summary - Gross Expenditure |  | 5
Summary - Gross Income |  | 6
Summary - Net Expenditure |  | 7
Analysis of Change in Budget from 2012/13 - 2013/14 |  | 8
Summary by type of expenditure/income |  | 9-10
Capital Expenditure |  | 11-13
Employee Numbers |  | 14-15
Directorate Budget Analysis:
Adults & Communities |  | 16-18
Children, Young People & Families |  | 19-23
Corporate Resources |  | 24-26
Development  & Culture |  | 27-29
Local Services |  | 30-32
Districts |  | 33-38
Council Tax |  | 39-40
Glossary |  | 41
Spreadsheet: 693608d1599056101-random-calculation-error-with-adding-and-subtracting-times-timesheet-problem
Sheet: Jan

January 2020
 |  |  | Hours worked |  |  |  |  | Total |  |  | Travel |  |  |  | Total |  |  | Adjustment | Adjusted total | Top-up | Total with top-up |  |  | Total hours |  |  |  |  |  | Overtime accrued
Date | Day | Day type | Morning |  | Afternoon |  | Private appointment |  |  |  | First travel |  | Second travel |  |  |  |  |  |  |  |  |  |  | Overall |  |  |  |  |  | Total
 |  |  | Start | Finish | Start | Finish |  |  |  |  | Start | Finish | Start | Finish |  |  |  |  |  |  |  |  |  | Total | Diff | Total | Diff | Total | Diff
2020-01-01 00:00:00 | Wed | Public holiday
2020-01-02 00:00:00 | Thu | Working day | 10:00:00 | 16:05:00 |  |  |  |  | 03:00:00
2020-01-03 00:00:00 | Fri | Working day | 09:30:00 | 15:35:00 |  |  |  |  | 02:00:00
2020-01-04 00:00:00 | Sat | Weekend
2020-01-05 00:00:00 | Sun | Weekend
2020-01-06 00:00:00 | Mon | Working day | 10:30:00 | 12:45:00 | 13:30:00 | 17:20:00 |  |  | 02:00:00
2020-01-07 00:00:00 | Tue | Working day | 09:45:00 | 15:50:00 |  |  |  |  | 02:00:00
2020-01-08 00:00:00 | Wed | Working day | 11:00:00 | 17:05:00 |  |  |  |  | 01:00:00
2020-01-09 00:00:00 | Thu | Working day | 10:15:00 | 13:15:00 | 13:25:00 | 16:40:00 |  |  | 00:15:00
2020-01-10 00:00:00 | Fri | Working day | 09:10:00 | 13:15:00 | 13:30:00 | 15:30:00 |  |  | 00:15:00
2020-01-11 00:00:00 | Sat | Weekend
2020-01-12 00:00:00 | Sun | Weekend
2020-01-13 00:00:00 | Mon | Working day | 09:50:00 | 12:00:00 | 12:15:00 | 16:10:00 |  |  | 00:15:00
2020-01-14 00:00:00 | Tue | Working day | 11:00:00 | 13:15:00 | 13:30:00 | 17:05:00 |  |  | 03:00:00
2020-01-15 00:00:00 | Wed | Working day | 10:10:00 | 16:15:00 |  |  |  |  | 01:30:00
2020-01-16 00:00:00 | Thu | Working day | 09:55:00 | 16:15:00 |  |  |  |  | 02:30:00
2020-01-17 00:00:00 | Fri | Working day | 09:30:00 | 15:35:00 |  |  |  |  | 02:30:00
2020-01-18 00:00:00 | Sat | Weekend
2020-01-19 00:00:00 | Sun | Weekend
2020-01-20 00:00:00 | Mon | Annual leave
2020-01-21 00:00:00 | Tue | Annual leave
2020-01-22 00:00:00 | Wed | Annual leave
2020-01-23 00:00:00 | Thu | Annual leave
2020-01-24 00:00:00 | Fri | Annual leave
2020-01-25 00:00:00 | Sat | Weekend
2020-01-26 00:00:00 | Sun | Weekend
2020-01-27 00:00:00 | Mon | Working day | 08:35:00 | 15:00:00 |  |  |  |  | 01:00:00
2020-01-28 00:00:00 | Tue | Working day | 10:00:00 | 12:50:00 | 13:30:00 | 16:50:00 |  |  | 02:40:00
2020-01-29 00:00:00 | Wed | Working day | 09:30:00 | 16:10:00 |  |  |  |  | 01:30:00
2020-01-30 00:00:00 | Thu | Working day | 09:30:00 | 15:00:00 | 16:00:00 | 17:00:00 |  |  | 02:00:00
2020-01-31 00:00:00 | Fri | Working day | 10:25:00 | 16:40:00 |  |  |  |  | 00:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To carry forward:
 |  | Signatures
 |  | Employee |  |  |  |  |  | For ALLEA
 |  | Date | 3.02.2020 |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | (type name here)
 |  |  |  |  |  |  |  |  | (type job title here)
Spreadsheet: 33406d1229705298-if-query-book2-2
Sheet: Sheet1

 | Green | Amber | Green | Green | Green | Amber | Green | Green | Amber | Red
 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  | Green | 6
 |  |  |  |  | Amber | 3
 |  |  |  |  | Red | 1
Spreadsheet: 193510d1352855055-multiple-formulas-needed-in-one-cell-to-create-a-value-in-a-new-cell-media-tracking-percentage-comparison1
Sheet: Tables - Avg Daily Sales

Avg Daily Sales (Avg)
 |  |  |  |  |  |  |  |  |  | Vlookup Table
Medium |  |  |  |  |  |  |  |  |  | Points Score |  |  | Sales - excluding campaigns
 | TV | Radio |  |  |  |  |  |  |  | -100 | 1 |  | Avg daily sales compared to all sales
Brisbane |  |  |  |  |  |  |  |  |  | -0.3 | 2 |  |  | Low | High | Pts
Adelaide |  |  |  |  |  |  |  |  |  | -0.1 | 2.5 |  |  | 1 | + | 5
Perth |  |  |  |  |  |  |  |  |  | 0.1 | 3 |  |  | 0.3 | 1 | 4
Sydney |  |  |  |  |  |  |  |  |  | 0.3 | 4 |  |  | 0.1 | 0.3 | 3
Melbourne |  |  |  |  |  |  |  |  |  | 1 | 5 |  |  | -0.1 | 0.1 | 2.5
Newcastle |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3 | -0.1 | 2
Gold Coast |  |  |  |  |  |  |  |  |  |  |  |  |  | + | -0.3 | 1
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Reach % |  |  |  |  |  |  | TV Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Radio Reach % |  |  |  |  |  |  | Radio Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Spreadsheet: 755151d1636700636-can-you-use-vlookup-to-return-value-if-conditions-are-met-timeline-2021_test-copy
Sheet: Summary

 |  |  |  |  | 2021-11-07 00:00:00
 |  |  |  |  | SUN | MON | TUE | WED | THU | FRI | SAT |  |  | <-------- | this row needs to be a rolling 7 days starting with one day before today
 |  |  |  | Activity | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 |  |  |  | So if today was 11/27, then the first day to show would be 11/26  and of course the weekday would need to reflect that correct day of the week as well
 |  | This needs to be any activity that has a count  greater than or equal to 1 in the 7 days that are being displayed here | ----> | COMMUNICATION | 1 |  |  | 1 |  |  |  |  |  | <-------- | This row needs to reflect the count shown for that day if there is one Since the raw data tab has a formula to calculate that number, this  summary needs to be just the value
 |  |  |  |  | 2021-11-26 00:00:00
 |  |  |  |  | FRI | SAT | SUN | MON | TUE | WED | THU
 |  |  |  | Activity | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 |  |  |  | OPPERATION HOURS |  |  |  |  |  | 1
 |  |  |  | BRIDGE DETAILS | 1 | 1
 |  |  |  | HOLIDAY SUPPORT |  |  | 1 | 1
Spreadsheet: 628909d1560957683-help-calendar-correction-employee-absence-schedule-current-6-13-19-amaramassage-
Sheet: July

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | July | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 | [NAME]
 | Lynda |  |  |  |  |  |  |  |  |  |  | v | v | v
 | [NAME]
 | Heather |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  | p |  | p
 | [NAME]
 | Emili | v | V |  |  |  |  |  |  |  |  | p | v |  |  |  |  | p |  | p
 | Amber |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | v |  | p
 | Meredith |  |  |  |  |  |  |  |  |  |  |  | p
 | Julie
Spreadsheet: 67685d1268246693-excel-2007-how-to-add-only-positive-numbers-in-my-sumif-statement-test3-10
Sheet: Inventory

ModelName | ModelNumber |  | Description |  |  | SerialNumber | Qty Ordered | Qty Received | Qty On Hand
xyz | 1234 |  | THING |  |  | 456asd4561 | 1
ABC | 4567 |  | RADIO |  |  | 111AAA3333 | 1
CP200 | AAH50RDC9AA1 - CP200  UHF  4CH |  | UHF RADIO |  |  | 222SSS3333 | 1
COAX | LMR400 |  | COAX CABLING |  |  |  | 1000
BATTERY | [NAME] |  | Something that holds a charge |  |  |  | 15
Spreadsheet: 286568d1388378212-how-can-i-create-a-drop-down-menu-special-instructions-item-list
Sheet: Sheet1

 | item number |  | column a | column b | column c
 |  |  | 1 | 1a | 1b
 |  |  | 2 | 2a | 2b
 |  |  | 3 | 3a | 3b
 |  |  | 4 | 4a | 4b
 |  |  | 5 | 5a | 5b
 |  |  | 6 | 6a | 6b
 |  |  | 7 | 7a | 7b
 |  |  | 8 | 8a | 8b
 |  |  | 9 | 9a | 9b
 |  |  | 10 | 10a | 10b
Spreadsheet: 135059d1325792766-excel-2007-using-array-search-to-compile-data-in-a-clean-format-array-search-problem
Sheet: Inspections

T# |  |  | Comments
SD4615 |  |  | COS HAS XYZ
SD4629 |  |  | DEF
SD5947 |  |  | ABC
SD6511 |  |  | GTR
SD6596 |  |  | COSM HAS DEF
SD6634 |  |  | SDF
SD6690
SD6747
SD6762 |  |  | S
SD6779 |  |  | COSMOMAC HAS 456
SD6780
SD6860
SD6878 |  |  | SDF
SD6919 |  |  | COSMMACH WORKING ON TOP
SD6923
SD6924
SD6952
SD6959 |  |  | COSMAC DOING BOTT
SD7043
SD7086 |  |  | SDFSD
SD7109
SD7138 |  |  | COSMOP HAS XYZ
SD7191
SD7285
SD7288 |  |  | SDF
SD7315
SD7316 |  |  | DFSDFSFSFFEE
SD7334
SD7339 |  |  | COSMOP HAS 123
Spreadsheet: 852468d1702495266-formula-to-generate-a-to-z-if-the-qty-is-entered-sample-7-
Sheet: Result

No | Item | Qty
A |  | 1
B |  | 2
C |  | 3
D |  | 4
E |  | 5
F |  | 6
G |  | 7
H |  | 8
J |  | 9
K |  | 10
L |  | 11
 |  | 338