tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834613d1687945514-i-need-som-help-with-my-excel-sheet-for-risk-management-example
Sheet: Konfigs

 | Hotkategori |  |  |  | [NAME] |  |  |  | Intention |  |  |  |  |  |  |  |  |  |  |  |  |  | PERT Beta Distribution
 | Personalbrist |  |  |  | Medarb (allm) |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E = (O + 4*M + P) / 6
 | Användarfel |  |  |  | Handläggare |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E = Expected amount of time or cost,
 | Handhavandefel |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O = Optimistic estimate,
 | Förvaltningsfel |  |  |  | Extern angripare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M = Most likely estimate,
 | Leverantörsfel |  |  |  | Intern angripare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P = Pessimistic estimate.
 | Angrepp
 | Yttre omständigheter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Deviation = (P – O) / 6
 | Försumlighet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exempel skadeuppskattning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O= | 3000000
 | Probability |  |  |  | Consequence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M= | 5000000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P= | 8000000
 | Sannoliksnivå | Kolumn1 | Kolumn2 |  | Konsekvensnivå | Kolumn1 | Kolumn2 |  | Exponeringsnivå | Kolumn1 |  | Risknivå |  | Riskbeslut |  |  |  |  |  |  |  |  |  | E=
 |  | 0 | 0.099 |  |  | 0 | 99 |  | Låg (Rv -1) | -1 |  | 1 |  | [NAME] accepteras
 |  | 0.1 | 0.99 |  |  | 100 | 999 |  | Måttlig (Rv +0) | 0 |  | 2 |  | [NAME] accepteras inte |  |  |  |  |  |  |  |  |  | Standardavvikelse |  | Låg | Hög
 |  | 1 | 9.99 |  |  | 1000 | 4999 |  | Hög ([NAME]) | 1 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 1σ (68.3%)=
 |  | 10 | 100 |  |  | 5000 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 2σ (95.5%)=
 |  | 100 |  |  | Anpassat, se motivering |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 3σ (99.7%)=
 | Anpassat, se motivering |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Probability Sannolikhetsnivå)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kolumn1 | Mycket låg | Låg | Måttlig | Hög | Mycket hög
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mycket allvarlig | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  | Consequense/Konsekevnsnivå |  |  | Allvarlig | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Måttlig | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ringa | 1 | 2 | 3 | 4 | 5
Spreadsheet: 101c02b0-a0e7-4b5e-97f0-b80c041926f6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-08-26 09:43:15.190000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.75 | 101.648 | 101.523 | 101.398 | 101.023
4.625 | 100.93 | 100.805 | 100.68 | 100.305 |  | Note: | Refer To Price [NAME]
4.5 | 100.039 | 99.914 | 99.789 | 99.414 |  |  | For all Price Adjs
4.375 | 99.108 | 98.983 | 98.858 | 98.233
4.25 | 98.452 | 98.327 | 98.202 | 97.577
4.125 | 97.662 | 97.537 | 97.412 | 96.787
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.708 | 101.583 | 101.458 | 101.083
3.75 | 101.049 | 100.924 | 100.799 | 100.424
3.625 | 100.673 | 100.548 | 100.423 | 100.048
3.5 | 100.127 | 100.002 | 99.877 | 99.252
3.375 | 99.405 | 99.28 | 99.155 | 98.53
3.25 | 98.632 | 98.507 | 98.382 | 97.757 |  | Minimum loan amount:
3.125 | 97.653 | 97.528 | 97.403 | 96.778 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-09-09 09:43:15.190000
30 DAY | 2013-09-24 09:43:15.190000
45 DAY | 2013-10-09 09:43:15.190000
60 DAY | 2013-10-24 09:43:15.190000
90 DAY | 2013-11-23 09:43:15.190000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 124237d1318264862-find-number-of-instances-data-is-with-with-a-range-dc-temp-1
Sheet: DC

Count Instances above |  | 3
Index | Date | Time | °C
1 | 2011-09-15 00:00:00 | 09:05:51 | 2.1
2 | 2011-09-15 00:00:00 | 09:07:51 | 3.1
3 | 2011-09-15 00:00:00 | 09:09:51 | 3.2
4 | 2011-09-15 00:00:00 | 09:11:51 | 3.1
5 | 2011-09-15 00:00:00 | 09:13:51 | 2.9
6 | 2011-09-15 00:00:00 | 09:15:51 | 2.7
7 | 2011-09-15 00:00:00 | 09:17:51 | 1.9
8 | 2011-09-15 00:00:00 | 09:19:51 | 3.6
9 | 2011-09-15 00:00:00 | 09:21:51 | 1.8
10 | 2011-09-15 00:00:00 | 09:23:51 | 1.9
11 | 2011-09-15 00:00:00 | 09:25:51 | 3.5
12 | 2011-09-15 00:00:00 | 09:27:51 | 3.7
13 | 2011-09-15 00:00:00 | 09:29:51 | 5
14 | 2011-09-15 00:00:00 | 09:31:51 | 2
15 | 2011-09-15 00:00:00 | 09:33:51 | 2.2
16 | 2011-09-15 00:00:00 | 09:35:51 | 2.3
17 | 2011-09-15 00:00:00 | 09:37:51 | 2.5
18 | 2011-09-15 00:00:00 | 09:39:51 | 2.6
19 | 2011-09-15 00:00:00 | 09:41:51 | 2.6
20 | 2011-09-15 00:00:00 | 09:43:51 | 1
Spreadsheet: daren_farmer__5950__WC580reveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | WC 580 | 28517 | 0 |  |  | 20145
1st of month DBQ = 20145/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 864107d1711427782-disaggregate-data-from-a-single-row-to-multiple-rows-and-copy-details-from-original-row-test-48-ans2
Sheet: Sheet1

CURRENT FORMAT |  |  |  |  |  |  |  |  | REQUIRED FORMAT
 |  |  | Hourly rate
Employee | Employment type | Total hours | Ord Time | 1.5 Times | 2 Times |  |  |  | Employee | Employment type | Total hours | Hourly rate
[NAME] | Casual | 11 | 8 | 2 | 1 |  |  |  | [NAME] | Casual |  | Ord Time
[NAME] | Casual | 12 | 8 | 2 | 2 |  |  |  | [NAME] | Casual | 2 | 1.5 Times
 |  |  |  |  |  |  |  |  | [NAME] | Casual | 1 | 2 Times
 |  |  |  |  |  |  |  |  | [NAME] | Casual | 8 | Ord Time
 |  |  |  |  |  |  |  |  | [NAME] | Casual | 2 | 1.5 Times
 |  |  |  |  |  |  |  |  | [NAME] | Casual | 2 | 2 Times
Spreadsheet: 841974d1694086781-sla-exclude-non-working-days-weekend-and-public-holidays-test
Sheet: Deelneme

Nr | Naam | Onderdeel | Starttijd |  | Onderdeel | Onderdeelnr |  | 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 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70
1 | Maam-1 | 160934 |  |  | 1 | 1 | 12:00:00
2 | Naam-2 | 80467 |  |  | 50000 | 2 | 12:00:00
3 | Naam-3 | 50000 |  |  | 80467 | 3 | 20:00:00
4 | Naam-4 | 100000 |  |  | 100000 | 4 | 18:00:00
5 | Naam-1 | 1 |  |  | 160934 | 5 | 12:00:00
Spreadsheet: 156494d1337315973-golf-handicap-handicapscorecards-master4
Sheet: result

Position | PLAYER | TOTAL |  | [NAME] | No | PLAYER | PAR 3 | TOTAL | S.I. > | 1 | 2 | 3 |  |  |  |  | A | Cut (a) | Cut (a+b) | Increase | TOTAL | New Adj | New H'Cap
 |  |  |  |  |  |  |  |  |  |  |  |  | No of Players
 |  |  |  |  |  |  |  |  |  |  |  |  | Bottom third
 |  |  |  |  |  |  |  |  |  |  |  |  | Top two-thirds
Spreadsheet: 583761d1532629190-returning-names-in-ranked-order-with-ties-leaderboard
Sheet: Leader Board

 |  | < [NAME] rank
 | Rank | Player | Points
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Spreadsheet: 28589d1222906031-counting-how-often-duplicate-items-have-occured-help
Sheet: Sheet1

numbers
1
2
1
1
1
2
1
1
2
1
1
1
1 |  |  | total number of 1 |  | 15
1 |  |  | total number of 2 |  | 8
2 |  |  | total number of 3 |  | 4
2 |  |  | total numbers all together |  | 27
1 |  |  | total unique groups of numbers that are in qroups of 4 or more |  | 3
1
1
1
3
3
2
2
3
2
3
[NAME] should give me the answer of 3…..but it doesn’t
27
Spreadsheet: 856680d1705892528-how-to-remove-names-text-if-repeated-in-another-cell-work-schedule
Sheet: Template

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2022-01-01 00:00:00
Location 1
Location 2
Location 3 | Class A
 | Class B
 | Class C
 | Class D
Location 4 |  | [NAME]
Location 5
Location 6
Location 7 |  | [NAME]
Location 8
Location 9
Location 10
Office
 |  | Names
 |  | Alicia
 |  | Ally
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 298318d1392757413-need-total-sum-of-hours-for-each-shift-assigned-to-each-day-with-no-breaks-help
Sheet: -4

 |  | Weekly Department Schedule |  |  |  | Weekly Allocated Hrs: |  |  |  |  | Pd / Wk:
 |  | Week Commencing Date: |  | 2013-12-15 00:00:00 |  |  | Department: | Fresh Foods |  | Week:
 | Dinners \/
 |  | Name | [NAME] | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Total
 | 3:00:00 |  | 24 |  |  |  |  | 10:30:00 | 10:30:00 | 10:30:00
 |  |  |  |  |  |  |  | 19:30:00 | 19:30:00 | 19:30:00
 |  |  | 16 | 12:00:00 |  |  |  | 09:30:00 | 09:30:00 | 09:30:00
 |  |  |  | 16:00:00 |  |  |  | 13:30:00 | 13:30:00 | 13:30:00
 | 4:00:00 |  | 39 | 09:00:00 |  | 09:00:00 | 09:00:00 | 09:00:00 | 12:00:00
 |  |  |  | 17:00:00 |  | 18:00:00 | 18:00:00 | 18:00:00 | 20:00:00
 | 1:00:00 |  | 20 |  | 09:30:00
 |  |  |  |  | 18:30:00
 | 2:00:00 |  | 16 |  |  |  |  |  | 10:00:00 | 10:00:00
 |  |  |  |  |  |  |  |  | 19:00:00 | 19:00:00
 |  |  | 12
 | 1:00:00 |  | 12 |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  | 16 | 11:00:00 | 17:30:00 | 17:30:00 |  |  |  | 12:00:00
 |  |  |  | 15:00:00 | 21:30:00 | 21:30:00 |  |  |  | 16:00:00
 |  |  | 16 | 13:00:00 |  |  |  |  |  | 16:00:00
 |  |  |  | 17:00:00 |  |  |  |  |  | 20:00:00
FOA |  |  | 15 |  | 16:30:00 | 16:30:00
 |  |  |  |  | 21:30:00 | 21:30:00
 |  |  |  | 13:30:00
 |  |  |  | 17:30:00
 |  |  |  |  |  |  | 17:30:00 | 17:30:00
 |  |  |  |  |  |  | 21:30:00 | 21:30:00
 |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  | 21:30:00
Code Checker |  |  | 39 |  | 14:00:00 | 14:00:00 | 13:00:00 | 13:00:00
 |  |  |  |  | 21:30:00 | 21:30:00 | 21:00:00 | 21:00:00
 | 0:30:00 |  |  | 10:00:00
 |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  | 23:00:00
 |  | Total
 | Dinners>> |  |  | 01:30:00 | 01:00:00 | 01:00:00 | 01:00:00 | 02:00:00 | 02:00:00 | 03:00:00
 |  |  |  |  | #
Spreadsheet: 33819d1230650391-sumif-referencing-another-cell-for-criteria-sumif-problem
Sheet: Sheet1

 |  | 2007-11-28 00:00:00
2007-12-01 00:00:00 |  | 18387944.265262
2007-11-01 00:00:00 |  | 34995489.68689937
2007-10-01 00:00:00 |  | 35471981.19541001
2007-09-01 00:00:00 |  | 27790229.43190563
2007-08-01 00:00:00 |  | 32234348.00011373
2007-07-01 00:00:00 |  | 36237558.91924573
2007-06-01 00:00:00 |  | 29275713.91319646
2007-05-01 00:00:00 |  | 27607435.60953781
2007-04-01 00:00:00 |  | 23444366.91735754
2007-03-01 00:00:00 |  | 28667583.96689032
2007-02-01 00:00:00 |  | 24667273.55084492
2007-01-01 00:00:00 |  | 27396777.11649989
 |  | 18387944.265262
Spreadsheet: efec613a-77ba-4845-b5ea-79ce7a24c8bf
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
ETHO | Test | ETHO | Ethotoin (Peganone) | Ethotoin (Peganone) | Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in plastic vial.  Serum Draw in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in plastic vial. | 0.25 mL | Hemolysis	NA Thawing 	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Anticoagulants other than Sodium heparin, EDTA, plain red-top | Reference Range: 8.0 - 20.0 ug/mL   Please note: The therapeutic range for ethotoin is not well established. Many patients respond well to ethotoin concentrations up to 60 ug/mL.   Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 2 days | 4 - 6 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
ETHO | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
ETHO | Result | Z1119 | Ethotoin (Peganone) | Ethotoin (Peganone) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: tracy_geaccone__40494__OM Schedule - IT 2
Sheet: Variance to Plan

DIRECT O&M VARIANCE
2001 PLAN vs. 2002 PLAN
 |  |  | 2001 RESTATED PLAN | 2001 ADJUSTED FOR 2002 BUDGET CHANGES (1)
2001 PLAN -  NET |  |  | 28 | 25.7
Variances:
SAN Monthly Fee |  |  | 1.8 | 2.8
O&E Support - Transfer of Funds (1) |  |  | 0.7 | 0.3
EPSC |  |  | 0.8 | 0.9
New License Fees |  |  | 0.5 | 0.5
NBP |  |  | -0.5
Software [NAME] (2) |  |  | 0.1 | 0.1
2002  PLAN - NET
(1) $.4 O&E Support Offset Should be Reflected in Operations 2002 Plan.
(2) Offset in Operations
Spreadsheet: 231512d1367102468-is-there-a-simplified-method-for-sorting-extracted-data-sample-sort-2
Sheet: MASTER

[NAME] | FRIDAY |  |  |  |  |  | AM/PM CRITERIA
 | 2013-04-05 00:00:00 |  |  |  |  |  | 0.5833333333333334 |  |  |  |  |  |  | The help columns F & H thru M are hidden.
STAFF | avail | IN | OUT | Position | EXTRACT CRITERIA | Hours | SORTING VALUES |  |  |  | SORTING COLUMN
Name 2 | ANY | 09:00:00 | 16:00:00 | B |  |  |  | B | 1 | 1 |  |  |  | I am just assuming what those "help" columns are for
Name 11 | ANY | 10:00:00 | 16:00:00 | C |  |  |  | C | 2 |  |  |  |  | so I titled them by what they seem to do.
Name 1 | ANY | 08:00:00 | 14:00:00 | B |  |  |  | D | 3
Name 5 | ANY | 18:00:00 | 01:00:00 | B |  |  |  | U | 4 |  |  |  |  | The "Extract Criteria" is based off "Position"(B,C,D,U), "AM or PM"(A or P) and sorted
Name 29 | ANY | 19:00:00 | 01:00:00 | U |  |  |  |  |  |  |  |  |  | by "IN" time from earliest to latest with the help of the "ROW VALUES" and "SORTING COLUMN"
Name 4 | ANY | 17:00:00 | 01:00:00 | B |  |  |  |  |  |  |  |  |  | Which is then extracted and sorted to its corresponding cells on the "FRIDAY" worksheet.
Name 9 | ANY | 09:00:00 | 15:00:00 | C
Name 24 | ANY | 11:00:00 | 19:00:00 | U |  |  |  |  |  |  |  |  |  | You will also notice that none of the data is in any order on this sheet. But when it is
Name 8 | ANY | 08:00:00 | 14:00:00 | C |  |  |  |  |  |  |  |  |  | extracted to the "FRIDAY" worksheet ,each position (AM BOX, PM BOX,ect…) is first sorted from
Name 12 | ANY | 14:00:00 | 21:00:00 | C |  |  |  |  |  |  |  |  |  | earliest to latest and is matched with the Staff name scheduled for that shift.
Name 17 | ANY | 09:00:00 | 16:00:00 | D
Name 7 | ANY | 07:00:00 | 12:00:00 | C
Name 14 | ANY | 17:00:00 | 01:00:00 | C |  |  |  |  |  |  |  |  |  | My question is: Is there a simplified method to accomplishing this without the use
Name 16 | ANY | 18:00:00 | 01:00:00 | C |  |  |  |  |  |  |  |  |  | of any or as many help columns (F,H thru M)
Name 19 | ANY | 16:30:00 | 01:00:00 | D
Name 15 | ANY | 17:00:00 | 01:00:00 | C
Name 23 | ANY | 10:00:00 | 18:00:00 | U
Name 13 | ANY | 16:00:00 | 01:00:00 | C
Name 20 | ANY | 17:00:00 | 01:00:00 | D
Name 18 | ANY | 09:30:00 | 16:00:00 | D
Name 22 | ANY | 09:00:00 | 16:00:00 | U
Name 28 | ANY | 18:00:00 | 01:00:00 | U
Name 10 | ANY | 09:00:00 | 16:00:00 | C
Name 3 | ANY | 10:00:00 | 17:00:00 | B
Name 21 | ANY | 08:00:00 | 16:00:00 | U
Name 6 | ANY | 18:30:00 | 01:00:00 | B
Name 27 | ANY | 17:00:00 | 01:00:00 | U
Name 25 | ANY | 11:30:00 | 18:30:00 | U
Name 26 | ANY | 16:00:00 | 22:00:00 | U
Name 30 | ANY | 19:30:00 | 01:00:00 | U
Spreadsheet: 648859d1573235609-formula-to-list-selected-items-testing-products-finished
Sheet: TAB 1

PRODUCT>>
\/ Compensation Level \/
Wholesaler
Reseller
Sales Rep 1
[NAME]
Regional Manager
Spreadsheet: 0b87b690-1ee8-48d5-bd83-9e60029cff1d
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 19. Selected output of division I transport, postal and warehousing, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  461 Road freight transport ; |  |  | Original | [NAME] | 1997-03-01 00:00:00 | 2012-03-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  471 Rail freight transport ; |  |  | Original | A2314067L | 1996-03-01 00:00:00 | 2012-03-01 00:00:00 | 65 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  481 Water freight transport ; |  |  | Original | A2314076R | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5021 Pipeline transport ; |  |  | Original | A2314103K | 2000-09-01 00:00:00 | 2012-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  510 Postal and courier pick-up and delivery services ; |  |  | Original | A3344046F | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  521 Water transport support services ; |  |  | Original | A2314115V | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5211 Stevedoring services ; |  |  | Original | A2314118A | 1996-03-01 00:00:00 | 2012-03-01 00:00:00 | 65 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5212 Port and water transport terminal operations ; |  |  | Original | A3343946V | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5219 Other water transport support services ; |  |  | Original | [NAME] | 1998-03-01 00:00:00 | 2012-03-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  522 Airport operations and other air transport support services ; |  |  | Original | A2314130T | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5291 Customs agency services ; |  |  | Original | A2314139L | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  530 Warehousing and storage services ; |  |  | Original | A2314145J | 1996-09-01 00:00:00 | 2012-03-01 00:00:00 | 63 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5301 Grain storage services ; |  |  | Original | A2314148R | 1996-03-01 00:00:00 | 2012-03-01 00:00:00 | 65 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5309 Other warehousing and storage services ; |  |  | Original | A2314151C | 1996-09-01 00:00:00 | 2012-03-01 00:00:00 | 63 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 143088d1330193347-subtotal-sample-file
Sheet: Sheet1

OrderDate | ContactFirstName | ContactLastName | BillingAddress | OrderID | Total
2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 2295
2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 3295
Spreadsheet: 102648d1300624311-gantt-style-schedule-768942
Sheet: Schedule

 | 2011-02-01 00:00:00
[NAME] | LON /1111 | LON /1111 | LON /1111 |  |  | NYC /4444 | NYC /4444 | NYC /4444 | NYC /4444 | NYC /4444
[NAME] |  | SYD / 2222 | SYD / 2222 | SYD / 2222 | SYD / 2222 |  |  | SYD / 6666 | SYD / 6666 | SYD / 6666 | SYD / 6666 | SYD / 6666
[NAME] |  |  | NYC /3333 | NYC /3333 | NYC /3333 |  |  | LA / 5555 | LA / 5555
[NAME]
[NAME]
[NAME]
Spreadsheet: 200006d1355387315-pivot-count-values-greater-than-zero-pivot
Sheet: Data

Item | Sales | Balance | CountBalance
ABC | 1250 | 10
ABC | 2500 | 5
ABC | 2541 | 2
ABC | 1500 | 0
ABC | 1020 | 20
BCD | 1110 | 4
BCD | 1010 | 8
BCD | 550 | 64
BCD | 450 | 24
BCD | 652 | 15
CDE | 148 | 0
CDE | 895 | 32
CDE | 657 | 15
CDE | 485 | 48
CDE | 541 | 54
CDE | 365 | 0
CDE | 154 | 0
Spreadsheet: 697524d1601392617-count-overlap-between-days-multiple-dates-book1-pea343-
Sheet: Sheet1

ID | Start | End | Overlap | Total Overlap
1 | 2020-06-01 00:00:00 | 2020-06-19 00:00:00
1 | 2020-06-01 00:00:00 | 2020-06-06 00:00:00
1 | 2020-06-10 00:00:00 | 2020-06-30 00:00:00
1 | 2020-06-16 00:00:00 | 2020-06-24 00:00:00
1 | 2020-06-24 00:00:00 | 2020-06-30 00:00:00
1 Total
1 and 2 have a 7 day overlap |  |  | ?? Seems as if 1 and 2 should have 6 days overlap i.e. 6/1 through 6/6
1 and 3 have a 10 day overlap
1 and 4 have a 4 day overlap
Spreadsheet: 239100d1369825059-program-to-generate-sales-production-and-stock-data-in-one-sheet-stock2
Sheet: Production

M/C # | Date | Item Code | Start | End | Total Daily Production
1 | 2013-04-13 00:00:00 | 4.0R/176 | 13148 | 45806
1
1 |  | 4.0R/176 | 45806 | 80000
1 |  | 4.0R/176 | 80000 | 106700
1 |  | 4.0R/176 | 106700 | 130000
1 |  | 4.0R/176
1 |  | 2.5F/21 | 16000 | 50000
2 |  | 4.0R/176 | 45898 | 76002
2
2 |  | 4.0R/176 | 76002 | 110000
2 |  | 4.0R/176 | 110000 | 145450
2 |  | 4.0R/176 | 145450 | 173126
2 |  | 4.0R/176 | 173126 | 198000
2 |  | 4.0R/176 | 198000 | 224000
3 |  | 4.5R/208 | 0 | 2818
3
3 |  | 4.5R/208 | 2818 | 10000
3 |  | 4.5R/208 | 10000 | 16606
3 |  | 4.5R/208 | 16606 | 27000
3 |  | 4.5F/182 | 0 | 18000
3 |  | 4.0F/144 | 0 | 28000
Spreadsheet: 38080d1236191850-auto-totaling-po-logic
Sheet: Sheet1

PO Number | Open/Closed | PO Amount |  |  |  |  |  | PO Lists | Amouts
1 |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
Total PO's for Project
Total Open PO's
Spreadsheet: 187257d1350390211-adding-colour-to-sections-of-a-line-graph-line-graph-with-colours
Sheet: Sheet1

 |  | Value | Cum Score
 | ataque - contraataque
Spreadsheet: 98367d1297288349-two-dimensional-lookup-help
Sheet: data

column 1 | column 2 | column 3
DOG | Green | [NAME]
CAT | Blue | [NAME]
FISH | Pink | [NAME]
CAT | Blue | Fred
CAT | Green | [NAME]
DOG | Blue | [NAME]
DOG | Pink | [NAME]