tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22451__Hanson Scheduling Model_5_23
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-05-23 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 23.232 | 23.244 | 23.208 | 23.304 | 23.448 | 23.856 | 24.228 | 24.108 | 23.652 | 23.232 | 23.712 | 23.196 | 23.976 | 23.784 | 23.772 | 23.448 | 24.528 | 25.164 | 26.532 | 29.484 | 30.372 | 30.108 | 30.66 | 30.336 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 28.72 | 28.72 | 28.72 | 28.72 | 29.47 | 29.47 | 29.67 | 29.25 | 29.25 | 29.25 | 29.25 | 29.25 | 15.825 | 15.825 | 16.575 | 15.695 | 16.115 | 16.115 | 28.59 | 28.59 | 29.47 | 29.47 | 28.72 | 28.72
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 831250d1685524848-index-match-on-multiple-results-try1_v2
Sheet: Discount % Approved

[NAME] | Discount Type | % | Customer Name | Date Approved
Spreadsheet: 755090d1636653004-how-to-automate-shift-pay-time-for-split-shifts-with-given-constraints-efsplitshift-2-
Sheet: Sheet1

Minimum Guarntee |  | 7.25 |  |  | Shift A |  |  |  |  | 1.  Report Allowance = 10 minutes
Gurantee | 08:00:00 | 8 |  |  | Span of Day |  |  |  |  | So.  Report tine should be before shift start
Report Allowance | 00:10:00 |  |  |  | 1st Report |  |  |  |  | G3 =G4-$B$3
Clear Allowance | 00:05:00 |  |  |  | First Shift Start | 05:00:00
[NAME] | 02:00:00 |  |  |  | First Shift End | 10:00:00 |  |  |  | 2.  Paid break between shifts = 2 hours
Day Span Bonus | 10:00:00 |  |  |  | Clear |  |  |  |  | [NAME])
or | 11:00:00
Maximum Allowed Day Span | 14:00:00 |  |  |  | Break |  |  |  |  | 3.  Report Allowance = 10 minutes
 |  |  |  |  |  |  |  |  |  | So.  Report tine should be before shift start
 |  |  |  |  | 2nd Report |  |  |  |  | G10 =G11-$B$3
 |  |  |  |  | Second Shift Start | 13:00:00
 |  |  |  |  |  |  |  |  |  | 3.  F19 = "Day Span"
 |  |  |  |  | Second Shift End | 16:45:00 |  |  |  | G19 = =[NAME]
 |  |  |  |  | Clear |  |  |  |  | I19 =IF(H19>14/24,"Breach","Allowed")
 |  |  |  |  | STRAIGHT TIME |  |  |  |  | 4.  F20  10 hour limit pay
 |  |  |  |  |  |  |  |  |  | I20 =MAX(G19-10/24,0)
 |  |  |  |  | TOTAL WORK HOURS
 |  |  |  |  | Day Span = |  |  |  |  | 5. F21     =8 Hour Work Bonus…......I read this as actual work time not 8 Hour Guarantee
Staff get the following; |  |  |  |  | 10 Hour Limit Pay |  |  |  |  | I21 =MAX(G19-10/24,0)
 |  |  |  |  | 8 Hour Work Bonus
10 minutes for Report Time | Ok |  |  |  | 11 Hour Limit Bonus |  |  |  |  | 6.  If someone works > 11 hours then automatically gets 12 hours pay as overtime
5 minutes for Clear time | Ok |  |  |  |  |  |  |  |  | I22 =IF(G19>11/24,0.5,0)
 |  |  |  |  | Hours to pay
If the break between both shifts is less than 2 hours then it is paid at straight time. | Ok |  |  |  |  |  |  |  |  | 7.  Overtime pay is the max of 4.  or 5. or 6.
 |  |  |  |  |  |  |  |  |  | H21=MAX(I20:I22)
The maximum day span allowed is 14 hours. | ok
 |  |  |  |  |  |  |  |  |  | 8. Hours to Pay
 |  |  |  |  |  |  |  |  |  | H24 = =[NAME]:H20)
All employees shall be paid for overtime at the rate of one and one‑half times the hourly rate for all work performed after the completion of eight (8) hours work or ten (10) hour day span daily. | Ok |  |  |  |  |  |  |  |  | I25 = =HOUR(H24) +MINUTE(H24)/60
Jobs having a day span in excess of eleven hours (11) minimum pay at the end of eleven (11) hours shall be eight (8) times the hourly rate and work performed thereafter shall be paid in addition to the minimum guarantee of eight (8) hours.
Spreadsheet: 886704d1736807833-filter-function-filter-example
Sheet: Sheet1

Code | Name | Active |  | Code | Name | Active | Date Contact Made |  | Code | Name | Active |  | Code | Name | Active | Date Contact Made
1234 | Test A | Y |  |  | Test A | Y | 2025-01-11 00:00:00 |  | 1234 | Test A | Y |  |  | Test A | Y | 2025-01-11 00:00:00
2345 | Test B | Y |  | 2345 | Test B | Y | 2025-01-12 00:00:00 |  | 2345 | Test B | Y |  | 2345 | Test B | Y | 2025-01-12 00:00:00
3456 | Test C | N |  | 5678 | Test E | Y | 2025-01-13 00:00:00 |  | 3456 | Test C | Y |  | 3456 | Test C | Y | 2025-01-13 00:00:00
4567 | Test D | N |  |  |  |  |  |  | 4567 | Test D | N |  | 5678 | Test E | Y
5678 | Test E | Y |  |  |  |  |  |  | 5678 | Test E | Y
Spreadsheet: 115297d1310953247-please-help-with-linking-data-from-one-table-to-another-copy_for_testing-chadoak-delivery-plan
Sheet: Site

 | 2011-07-18 00:00:00 |  | Site staff
 |  |  |  | cert |  |  | Team Leader
1 | GLENN | MANKS | SUPERVISOR | dip | A/Leave
2 | DANIEL | GRIFFIN | PLUMBER | dip | A/Leave | 28_6_11
3 | [NAME] | HIRT | PLUMBER | dip | Cat | 28_6_11
4 | [NAME] | CANAIDER | DRAINER PLANT OPERATOR | dip | Cat
5 | KURT | ROWE | PLUMBER | dip | [NAME] | 29_6_11
6 | ANDREW | GRIFFIN | EXCAVATOR OPERATOR | 3 | [NAME] | 28_6_11
7 | DAVID2 | GUTHERIE2 | APPRENTICE  4TH YEAR | 4 | E.T.P | 28_6_11 | [NAME] – 0447 522 505
8 | BRAD | FOWLER | PLUMBER - unregistered | 3 | E.T.P
9 | BRENT | GALLOW | PLUMBER | 4 | E.T.P | 29_6_11 | [NAME]0431 154 996
10 | CRAIG | LEWIS | PLUMBER | 4 | E.T.P | 29_6_11
11 | ROSS | [NAME] | EXCAVATOR OPERATOR | 3 | E.T.P | 29_6_11
12 | [NAME] | WATTS | PLUMBER | dip | E.T.P | 29_6_11
13 | JARED | SHERRARD-SMITH | [NAME]  YR | 4 | E.T.P | 28_6_11
14 | DANIEL | HUTCHINSON | PLUMBER-Unregistered | dip | E.T.P | 28_6_11
15 | DANIEL | HARPER | PLUMBER | dip | E.T.P | 29_6_11
16 | [NAME] | GILBERT | PLUMBER | dip | [NAME]
17 | [NAME] | CONDON | APPRENTICE-3RD YEAR | 4 | [NAME]
18 | [NAME] | GARDINER | PLUMBER FOREMAN | 4 | Knox | 29_6_11
19 | MARTIN | LAVIS | APPRENTICE PLUMBER-3rd YR | 4 | Knox
20 | [NAME] | EWER | PLUMBER | dip | MAB
21 | [NAME] | HARPER | PLUMBER | dip | Melb Uni | 29_6_11
22 | AARON | KUNST | EXCAVATOR OPERATOR | 3 | Paky | 28_6_11 | Super Adam Maxy - 0414 503 799
23 | MATTHEW | BISHOP | APPRENITCE 1ST YEAR | 4 | Paky | 28_6_11
24 | [NAME] | MAXWORTHY | PLUMBER | dip | Paky | 28_6_11
25 | BENJAMIN | SMITH | PLUMBER | 4 | Paky | 28_6_11
26 | BRENDON | OATES | PLUMBER | dip | Paky | 28_6_11
27 | [NAME] | VALHER | PLUMBER | 4 | Paky
28 | [NAME] | Gissing | [NAME] | dip | S/Leave
29 | [NAME] | HUMPHREY | Apprentice 1ST Year Plumber | 4 | School | 29_6_11
30 | [NAME] | CAPPADONA | APPRENTICE 1ST YEAR | 4 | School
31 | [NAME] | [NAME] | APPRENTICCE 1ST YEAR | 4 | School
32 | PAUL | COGAN | PLUMBER & SITE SUPERVISIOR | dip | Super | 28_6_11
33 | RAY | WOOD | SUPERVISOR | 4 | Super | 28_6_11
34 | Garrick | Beaurrain | Plumber | 3 | Syncatron
35 | CHAD | ONSLOW | PLUMBER | 4 | Syncatron | 29_6_11
36 | THOMAS | [NAME] | PLUMBER | dip | Syncatron | 29_6_11
37 | [NAME] | DEKA | PLUMBER | dip | VCA | 29_6_11 | [NAME] 0410 574 554
38 | [NAME] | RAWLINGS | APPRENTICE -3RD  YEAR | 4 | VCA | 28_6_11
39 | [NAME] | Ainsworth | Plumber | 4 | VCA | 28_6_11
40 | DOUGLAS | OATEN | PLUMBER | dip | VCA | 29_6_11
41 | RILEY | McCRACKEN | APPRENTICE-2ND  YEAR | 4 | Warleigh | 28_6_11 | [NAME] – 0418 527 463
42 | BRADLEY | PYERS | APPRENTICE PLUMBER-3rd YEAR | 4 | Warleigh | 14_7_11
43 | NICHOLAS | O'BRIEN | PLUMBER | dip | Warleigh | 28_6_11
44 | [NAME] | REID | PLUMBER | dip | Warleigh | 28_6_11
45 | WILLIAM (BILL) | PHILIPPZIG | PLUMBER | 4
46
47
48
 |  |  | Current Jobs
 | 694 | Packy |  | Pakenham
 |  | MAB
 |  | Cat
 |  | Warleigh
 |  | ETP
 |  | VCA
 |  | [NAME]
 |  | Sync
 |  | Knox
 |  | [NAME]
 |  | Lyric
 |  | Orrong
 |  | Pro Build
Spreadsheet: 100574d1298913945-time-between-status-time-between-status
Sheet: Sheet1

Job # | Date #1 | Date #2 | Status 1 | Status 2
158716 | 2011-02-14 18:56:26 | 2011-02-14 21:03:43 | New | Waiting for Partner Quote | 14
158716 | 2011-02-14 18:56:26 | 2011-02-16 20:50:33 | Waiting for Partner Quote | Partner [NAME] in SN | 14
158716 | 2011-02-14 18:56:26 | 2011-02-17 20:22:16 | Partner [NAME] in SN | Partner Quote OK to Send | 14
158716 | 2011-02-14 18:56:26 | 2011-02-21 20:46:51 | Partner Quote OK to Send | Quote at Customer | 7
164752 | 2011-02-15 21:11:11 | 2011-02-16 14:29:20 | Partner Quote OK to Send | Partner [NAME] in SN | 13
164752 | 2011-02-15 21:11:11 | 2011-02-16 14:41:24 | Partner [NAME] in SN | Quote at Customer | 1
175544 | 2011-02-16 18:56:26 | 2011-02-16 21:02:43 | New | Waiting for Partner Quote | 12
Spreadsheet: 373561d1422477506-easy-question-if-and-or-error-example-workbook_2
Sheet: Sheet1

 |  | IF YOU ARE UNHAPPY WITH THE SUGGESTED INCREASE, COMPLETE ONE OF THE BELOW COLUMNS - NOT BOTH
Current Salary | Suggested Increase Amount | Proposed Increase Amount | Proposed Increase % |  | New Salary
23000 | 100 |  | 0.04
45000 | 1700 | 0.075
16000 | 400 | 0.0375
1250000 | 2000
Spreadsheet: 838704d1691264865-transpose-rows-data-into-multiple-columns-data-transpose_rows_to_multicolumns
Sheet: Sheet1

Group | Value |  |  | Group |  |  |  |  | Group | Value
Group_01 | Val_A |  |  | Group_01 | Val_A | Val_B | Val_C |  | Group_01 | Val_A; Val_B; Val_C
Group_01 | Val_B |  |  | Group_02 | Val_X | Val_Y | Val_Z |  | Group_02 | Val_X; Val_Y; Val_Z
Group_01 | Val_C |  |  | Group_03 | Val_L | Val_M | Val_N |  | Group_03 | Val_L; Val_M; Val_N
Group_02 | Val_X |  |  | Group_04 | Val_Z |  |  |  | Group_04 | Val_Z
Group_02 | Val_Y |  |  | Group_05 | Val_L | Val_X |  |  | Group_05 | Val_L; Val_X
Group_02 | Val_Z
Group_03 | Val_L
Group_03 | Val_M
Group_03 | Val_N
Group_04 | Val_Z
Group_05 | Val_L
Group_05 | Val_X
Spreadsheet: 355690d1414760833-collating-information-from-multiple-worksheets-to-one-worksheet-lv-switchgear-new
Sheet: SURGE

COMP.REF. | DRG REF | [NAME] | MANUFACTURER | SUPPLIER | PART NUMBER | B&S Part Number | QUANT | REMARKS
 |  | Lightning/Surge Arrester 100kA (Type 1, 2 & 3 ) | Leutron | Surge protection Devices Ltd | 373962
 |  | Lightning/Surge Arrester 50kA (Type 1&2 ) | Leutron | Surge protection Devices Ltd | 381173
 |  | Lightning/Surge Arrester 50kA (Type 1&2 ) | Leutron | Surge protection Devices Ltd | 10651/LED |  | 1
 |  | Surge Arrester 40kA [NAME] (Type 2 ) | Leutron | Surge protection Devices Ltd | 381179
 |  | SURGE SUPPRESSION UNIT | FURSE | FURSE | ESP 415M3
 |  | WINDOW | RAYLEIGH | RAYLEIGH | DIN 96 WINDOW |  | 1
 |  | MISC | STOCK |  |  |  | 1
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
Spreadsheet: 174394d1345045607-print-same-doc-dated-with-all-week-days-of-that-month-daily-inspection-sheet
Sheet: Sheet1

Doc: 6.6.5 Daily Patrol Warehouse Inspection – HACCP Area. |  |  |  |  |  | pick month | September
 |  |  |  |  |  | pick year | 2012
Time:  …………….                   Checked By: ………………
Area | Cleaning |  | Defects
 | Frequency | Next clean/ action needed | What | Report raised | Action required
Welfare
Rest Room(s) | As needed | Action y/n
Toilet Facilities | As needed | Action y/n
Kitchen Facilities | As needed | Action y/n
External Area | Constant
Exterior skips | Weekly
Warehouse
Gangways | Daily
Load Assembly Areas | Daily
Waste skips | Weekly
Main floor | Weekly (winter)/ Fortnightly (summer)
Racking.
Areas under racking | Quarterly
Low level racking | Six monthly
All levels | Annual
Floor to Ceiling | Annual
Action taken
Action verified by:
Spreadsheet: 142d57c1-17e4-4a0b-a705-5dc37f9d50a4
Sheet: Docket

JURIS | TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | REST AMT | TOTAL AMT | TIME SERVED | PAID AMT | BALANCE | OFFENSE DT | ATTORNEY | BOND POSTED | COMPLAINANT
DPD | 1016417 | 3002 | 0 | ISSA,[NAME] | LIABILITY INSURANCE-FMFR | 0 | 309.1 | 0 | 309.1 | 0 | 0 | 309.1 | 2012-08-30 00:00:00 |  | 0 | C VINSON
Spreadsheet: 796626d1663407731-compare-content-of-2-columns-and-result-test1
Sheet: RECORDS1

 |  |  |  | REGS |  |  | RESULT YES OR NOT
 |  |  |  | SX-OAX
 |  |  |  | EI-DVN
 |  |  |  | EI-EDP
 |  |  |  | LV-GKO
 |  |  |  | N128AM
 |  |  |  | YL-AAT
 |  |  |  | YL-AAY
 |  |  |  | C-FPCA
 |  |  |  | EC-LPQ
 |  |  |  | EC-LPR
 |  |  |  | EC-LYR
 |  |  |  | EC-MKL
 |  |  |  | EC-MMX
 |  |  |  | EC-MMY
 |  |  |  | EC-MMP
 |  |  |  | EC-MPG
 |  |  |  | EC-MVY
 |  |  |  | EC-MXM
 |  |  |  | EC-NBM
 |  |  |  | EC-LKM
 |  |  |  | EC-LLR
 |  |  |  | F-GKXH
Spreadsheet: 873772d1720341191-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: ΙΟΥΝΙΟΣ 2024  ΓΙΑ ΕΚΤΥΠΩΣΗ

Σ. & Φ. ΔΙΑΚΟΣΑΒΒΑ Ο.Ε. |  |  | ΦΑΙΔΡΑ ΔΙΑΚΟΣΑΒΒΑ & ΣΙΑ Ο.Ε.
YAKIMIDI OLESSYA |  |  | SULTANOVA ZULFIΙA
[NAME] ΡΑΦΑΕΛΑ |  |  | YAKIMIDI OLESSYA
KROSHKINA MARIA |  |  | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
ΣΥΝΟΛΟ |  |  | ΣΥΝΟΛΟ
ΣΥΝΟΛΟ
Spreadsheet: 192019d1352289864-how-to-use-multiple-criteria-and-return-corresponding-value-help-please-indexmatch21
Sheet: Sheet1

 | a | b | c |  | 3 | b
1 | 24 | 26 | 29
3 | 30 | 34 | 39 |  | 34
7 | 35 | 40 | 47
13 | 40 | 45 | 52
19 | 49 | 57 | 63
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Hisham Maddah

Contract Terms (*)
 |  | 1- Revenue Target | Incentive
 |  | Procedures (After deducting consumables) | 0.5
 |  | Ulthera (After deducting consumables) | 0.5
 |  | Fractional Revenue | 0.4
 |  | Lab Revenue | 0.1
 |  | OHE deducted from net | 0.05
Doctor Calculation
 |  | Gross Revenue
 |  | Doctor Revenue | 230782.39
 |  | Consumables | 51833.61
 |  | Ulthera Consumables | 4096.23
 |  | Ulthera Depraciation | 500
 |  | Net Doctor Revenue
 |  | Net Amount to be Paid
 |  | LAB Revenue | 276
 |  | Future Lab Share (65%)
 |  | Clinics Share (35%)
 |  | Amount to be Paid
 |  | Fractional Revenue | 10605
 |  | Less: OHE (60%)
 |  | Net Amount To Be Paid
 |  | Total Refferal Revenue | 0
 |  | Amount to be Paid
 |  | Amount to be Paid
 |  | OHE 5%
 |  | Total Amount to be Paid
Prepared By …................. |  |  | CFO: | .....................
Spreadsheet: 815617d1675089512-formula-to-match-within-dates-and-criteria-book1-4-
Sheet: Sheet1

 |  |  | date | tobepay | cumtopay
 |  |  | 2021-12-28 00:00:00
 |  |  | 2021-12-29 00:00:00
 |  |  | 2021-12-30 00:00:00 | 6000
 |  |  | 2021-12-31 00:00:00
 |  |  | 2022-01-01 00:00:00
 |  |  | 2022-01-02 00:00:00
 |  |  | 2022-01-03 00:00:00 | 1000
 |  |  | 2022-01-04 00:00:00
 |  |  | 2022-01-05 00:00:00
 |  |  | 2022-01-06 00:00:00 | 5000
 |  |  | 2022-01-07 00:00:00
 |  |  | 2022-01-08 00:00:00
 |  |  | 2022-01-09 00:00:00
 |  |  | 2022-01-10 00:00:00 | 1000
Spreadsheet: 3e8743e3-b79d-401f-8392-b301cdc16b1b
Sheet: Sheet1

Onset and desistance of illict drug use among adults aged 16 to 59 - Drug Misuse Declared 2011/12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Sheet | Title | Period covered | National Statistics | Previous publication | Last updated
C.01 | Most common (mode) and average (mean) age when 16 to 59 year olds who had ever reported taking powder cocaine, ecstasy or cannabis, reported first taking each type of drug, by age and sex, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes | Table 2.11 (2009/10) | 2012-07-26 00:00:00
C.02 | Proportion of when 16 to 59 year olds who had ever reported taking powder cocaine, ecstasy or cannabis, reported first taking each type of drug, by age, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes |  | 2012-07-26 00:00:00
C.03 | Most common (mode) and average (mean) age when 16 to 59 year olds who had ever reported taking powder cocaine, ecstasy or cannabis and who hadn't done so in the last year, last took each type of drug, by age and sex, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes |  | 2012-07-26 00:00:00
[NAME] | Average (mean) duration of 16 to 59 year olds taking powder cocaine, ecstasy or cannabis who had ever reported taking but who hadn't done so in the last year, by age and sex, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes |  | 2012-07-26 00:00:00
[NAME] | Average duration of powder cocaine, ecstasy and cannabis use among adults aged 16 to 59 who had ever taken each drug but not in the last year, 2011/12 Crime Survey for England and Wales | 2011/12 | Yes |  | 2012-07-26 00:00:00
Spreadsheet: 769171d1645363714-filling-a-cell-with-only-the-last-available-data-measurement-of-a-sanple-sample-analyses-results
Sheet: Sheet1

Sample ID | Analysis Data |  | Sample ID | Repeated results | Reported results
Sample 1 | 10 |  | Sample 1 | 10 | 11
Sample 1 | 11
Sample 2 | 20 |  | Sample 2 | 20
Sample 2 | 22 |  |  | 22 | 23
Sample 2 | 23 |  | Sample 3 | 30
Sample 3 | 30 |  |  | 33
Sample 3 | 33 |  |  | 34 | 35
Sample 3 | 34 |  | Sample 4 | 50
Sample 3 | 35 |  |  | 53
Sample 4 | 50 |  |  | 55
Sample 4 | 53 |  |  | 56 | 57
Sample 4 | 55
Sample 4 | 56
Sample 4 | 57
Spreadsheet: 677514d1589380916-pivot-table-filter-1-
Sheet: SHEET 1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-17 00:00:00 | CARD PAYMENT TO MAGNET ACTURIS RECEIPT,579.03 GBP, RATE 1.00/GBP ON 13-03-2020 |  | 45
2020-03-14 00:00:00 | CARD PAYMENT TO TFL TRAVEL CH,3.00 GBP, RATE 1.00/GBP ON 12-03-2020 |  | 3 |  | NON
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2019-12-24 00:00:00 | CARD PAYMENT TO ISLEWORTH,9.99 GBP, RATE 1.00/GBP ON 21-12-2019 |  | 9.99 |  | REPAIRS 38
2019-12-18 00:00:00 | CARD PAYMENT TO FIREPROTECT,75.05 GBP, RATE 1.00/GBP ON 15-12-2019 |  | 15 |  | REPAIRS 38
Spreadsheet: 113640d1309466376-excel-2007-paid-time-off-automatically-geekygirl
Sheet: Sheet1

Employee | Week 1 Hours | Week 2 Hours | Week 3 Hours | Week 4 Hours | PTO
[NAME] | 38 | 39 | 40 | 42 | 7.95
[NAME] | 22 | 40 | 40 | 12 | 5.7
Marcy | 40 | 40 | 40 | 40 | 8
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 773895d1648109221-copy-vertical-data-into-horizontal-recognizing-different-rows-book1
Sheet: Sheet1

 | item 1
1
2
3
4
5
 | item 2
Q
W
E
 | Item 3
6
7
8
9
10
11
Spreadsheet: 145657d1331680364-sumif-type-formula-question-example2012_summer_internship
Sheet: Req History

Office | Department | 2012 Summer | 2012 Spring
Atlanta | Urban Touring
Dallas | Marketing | LIV1729 | LIV1541
Denver | Marketing | LIV1730 | LIV1536
Florida | Marketing | LIV1752 | LIV1537
[NAME] | Operations | [NAME]
[NAME] | Retail Sales | LIV1741 | LIV1549
Los Angeles | CW Marketing | LIV1755 | LIV1529
Los Angeles | El Rey Theatre | LIV1756 | [NAME]
Los Angeles | Festival Production |  | LIV1531
Los Angeles | Global Partnerships | LIV1731 | LIV1532
Los Angeles | GV Marketing | LIV1732 | LIV1525
Los Angeles | Interactive Marketing | LIV1733 | LIV1533
Los Angeles | Latin Marketing | LIV1734 | LIV1676
Los Angeles | Network Live | LIV1757
Los Angeles | Talent Buying | LIV1735 | [NAME]
Los Angeles | Ticketing
Los Angeles | Touring
Midland | Marketing
Midwest | Marketing
New York | Production
Philadelphia | Marketing | [NAME] | LIV1598
San Francisco | Marketing | LIV1749 | LIV1538
San Francisco | Ticketing | [NAME] | LIV1550
Showbox | Special Events & Admin. | LIV1754 | LIV1539
Showbox | Marketing | [NAME] | LIV1620
Showbox | Production |  | LIV1680
South Carolina | Marketing | LIV1751 | LIV1540
TMG Nashville | Marketing | LIV1746 | LIV1542
Spreadsheet: 55648d1255759530-lookup-w-multiple-values-book1
Sheet: Sheet4

Count of IP | Column Labels
Row Labels | Router-1 | Router-2 | Switch-1 | Switch-2 | (blank) | Grand Total
1 | 1 | 1 | 1 | 1 |  | 4
10.13.6.1 |  |  | 1 |  |  | 1
10.13.6.2 |  |  |  | 1 |  | 1
10.13.6.3 | 1 |  |  |  |  | 1
10.13.6.4 |  | 1 |  |  |  | 1
2 | 1 | 1 | 1 | 1 |  | 4
10.13.7.1 |  |  | 1 |  |  | 1
10.13.7.2 |  |  |  | 1 |  | 1
10.13.7.3 | 1 |  |  |  |  | 1
10.13.7.4 |  | 1 |  |  |  | 1
3 | 1 | 1 | 1 | 1 |  | 4
10.13.8.1 |  |  | 1 |  |  | 1
10.13.8.2 |  |  |  | 1 |  | 1
10.13.8.3 | 1 |  |  |  |  | 1
10.13.8.4 |  | 1 |  |  |  | 1
(blank)
(blank)
Grand Total | 3 | 3 | 3 | 3 |  | 12
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: SPR

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
SPRECHER ROOTB 1/12/16Z CN | 11166
SPRECHER CREAM 1/12/16Z CN | 11167
SPRECHER COLA 1/12/16Z CN | 11169
SPRECHER ORANG 1/12/16Z CN | 11168
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
SPRECHER ROOTB 1/12/16Z CN | 11166
SPRECHER CREAM 1/12/16Z CN | 11167
SPRECHER COLA 1/12/16Z CN | 11169
SPRECHER ORANG 1/12/16Z CN | 11168
Spreadsheet: 73923d1274459854-forecasting-model-forecasting-tb
Sheet: Sheet1

Month | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
1 | 16500000 | 16600000 | 16300000 | 16900000 | 17300000 | 17500000 | 17800000 | 18200000 | 18500000 | 18700000 | 18900000 | 19100000
2 | 10000000 | 12000000 | 11500000 | 12000000 | 12100000 | 11000000 | 13100000 | 14500000 | 14100000 | 15300000 | 12900000 | 13500000
Ratio
Slope
Spreadsheet: 805291d1668614441-multiple-if-in-1-cell-cats-multiple-ifs
Sheet: Sheet1

Client | Cat 1 | Cat 2 | Cat 3 | Total Cats | Start | End | Stay Days | Daily Rate | Transaction Income
[NAME] | Blue | Nala | George |  | 2015-04-22 00:00:00 | 2015-04-27 00:00:00
Ayesha | Simba |  |  |  | 2015-04-16 00:00:00 | 2015-04-19 00:00:00
[NAME] | Marshmallow |  |  |  | 2015-04-16 00:00:00 | 2015-04-19 00:00:00
Lyndsay | [NAME] | Po |  |  | 2015-04-09 00:00:00 | 2015-04-24 00:00:00
[NAME] | Savage | Pestroy |  |  | 2015-04-10 00:00:00 | 2015-04-14 00:00:00
 | Rate
 | Cat 1 | 90
 | Cat 2 | 175
 | Cat 3 | 230