tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858947d1707418309-dynamic-unpivot-array-based-on-condition-dynamic-unpivot-array-based-on-condition-excelforum
Sheet: Sheet1

 | Activity Name | Type of Units | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 |  |  | Activity Name | Type of Units | Date | Units
 | Activity 1 | Planned Units | 4 | 5 | 3 |  |  |  | Activity 1 | Planned Units | 2024-01-01 00:00:00 | 4
 | Activity 2 | Planned Units |  | 2 | 5 | 7 |  |  | Activity 1 | Planned Units | 2024-01-08 00:00:00 | 5
 | Activity 3 | Planned Units | 2 |  | 5 | 6 |  |  | Activity 1 | Planned Units | 2024-01-15 00:00:00 | 3
 |  |  |  |  |  |  |  |  | Activity 2 | Planned Units | 2024-01-08 00:00:00 | 2
 |  |  |  |  |  |  |  |  | Activity 2 | Planned Units | 2024-01-15 00:00:00 | 5
 |  |  |  |  |  |  |  |  | Activity 2 | Planned Units | 2024-01-22 00:00:00 | 7
 |  |  |  |  |  |  |  |  | Activity 3 | Planned Units | 2024-01-01 00:00:00 | 2
 |  |  |  |  |  |  |  |  | Activity 3 | Planned Units | 2024-01-15 00:00:00 | 5
 |  |  |  |  |  |  |  |  | Activity 3 | Planned Units | 2024-01-22 00:00:00 | 6
Spreadsheet: 58349d1258625508-count-sum-bi-weekly-screeninglog
Sheet: DIAGNOSIS_DATA

CNS # | Date Inclusion | LAB Diagnosis | Clinical Diagnosis | Date of Discharge | Outcome | Sequalae | Month 1 FUP Date | Outcome | Month 6 FUP Date | Outcome
1 | 2009-08-25 00:00:00 | malaria | malaria |  | Discharged | N | 2009-01-10 00:00:00 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discharged | Y | DIED
2 | 2009-08-27 00:00:00 | none | meningoencephalitis | 2009-09-16 00:00:00 | Runaway | Y | 2009-10-16 00:00:00 | Lost 2 FUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Died | N | Lost 2 FUP
3 | 2009-08-31 00:00:00 | malaria | malaria | 2009-09-17 00:00:00 | Discharged | N | 2009-07-10 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Runaway | NA | N
4 | 2009-09-01 00:00:00 | none | viral encephalitis | 2009-09-04 00:00:00 | Discharged | N | 2009-09-30 00:00:00 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Still on Ward |  | [NAME]
5 | 2009-09-07 00:00:00 | malaria | malaria |  | Died |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
Spreadsheet: 880061d1727700349-master-excel-spreadsheet-form
Sheet: Sheet1

 | Minor Variations/ Small Works Request Form |  |  |  |  |  |  |  |  | Date Received:
 |  |  |  |  |  |  |  |  |  | ID No:
 | Date: |  |  |  |  |  | Contact Name:
 | Contact Email: |  |  |  |  |  | Contact Number:
 | Request Type
 |  | This request is a Small works Request |  | This request is a Service Variation Enquiry |  | This request is a Minor Variations Request |  | This requests is a Works Variation Enquiry
 | Request Details
 | Room No:
 | Room Name: |  |  |  |  |  | [NAME] location:
 | Division: |  |  |  |  |  | Department:
 | Details of works:
 | Reasons for works:
 | Change of room use: |  |  | Yes |  | No
 | Request Priority
 | Risk |  | Benefit |  | Funding |  | Political Imperative |  | Criticality |  | Overall (Estates Teams to Complete)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | 5 | 5 | 4 | 3 | 4 | 1 | 1 |  | Please select..
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Please select.. | Medium |  |  |  |  |  |  |  |  | 5
 | Budget Holder Approval to Quote |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Low |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  | 3
 | Approved by: |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 1 |  |  |  |  |  | 2
 | Cost Code/ Centre: |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please select…
 | Approval to Quote |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Approved: |  |  | Yes |  | No |  | N/A |  | Works under £200 |  |  |  |  |  | [NAME]
 | Comments: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Reviewed by: |  |  |  |  |  |  | Date: |  |  |  |  |  |  |  | Rose bonner
 |  |  |  |  |  |  |  | Date quote expected by |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trevor Mose
 | Service Provider Quote
 | SR No: |  |  |  |  | Total Cost:
 | Date:
 | Cost Approval
 | Approved: |  |  | Yes |  | No |  | Variation confirmation
 | Comments:
 | Approved by: |  |  |  |  | Date:
 | Budget Holder Cost Approval
 | Approved by: |  |  |  |  | Date:
 | Comments:
Spreadsheet: 678771d1590056146-query-to-upload-and-manage-in-an-existing-other-purpose-database-query-example
Sheet: Register

Jurisdiction | Name | Type | Description Raw | Description | Root cause | Impact | Identified date | Due Date | Coordinator | Progress | Status | ORC Issue number | closed date
Spain | Spanish Guitar | Project |  | Good summary | this | bad | 2019-12-01 00:00:00 | 2020-02-28 00:00:00 | [NAME] | all done | on track |  | 2020-03-01 00:00:00
France | [NAME] | Emerging Risk |  | overview | that | really deep | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | [NAME] | having problems | off track
UK | that risk | ORC Issue | something else | Manually summarised | the other |  | 2020-02-01 00:00:00 | 2020-06-01 00:00:00 | [NAME] |  | about this | 49177
Spain | Madrid thing | Business Engagement |  | Discussion about X | that | n/a | 2020-05-20 00:00:00 | 2020-05-31 00:00:00 | [NAME] | Goiing to be doing this before that | on track
 |  |  |  |  |  |  |  |  |  |  |  | 51802
Spreadsheet: 754956d1636591795-applying-data-validation-to-check-box-activity-or-alternative-solution-multi-run-length-calculator-11-07-21-b
Sheet: Final Calculation

Units |  |  | columns
Spreadsheet: 690585d1597177105-how-to-place-the-values-which-there-are-a-couple-of-empty-cells-between-them-side-by-side-placesidebyside
Sheet: Sheet1

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 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105
C | D# | G |  |  |  |  |  | B | D |  |  |  |  |  | F# | A |  |  |  |  |  |  | E |  |  |  |  | F
Spreadsheet: 110708d1307342014-if-a1-y-z-then-a2-y-z-book1_solved
Sheet: Sheet1

5500 | 148.775 |  | 5500 | 60.375
5600 | 89.85 |  | 5400 | 36.2
5700 | 47.7 |  | 5300 | 20.975
5800 | 22.4 |  | 5200 | 11.75
5900 | 9.8 |  | 5100 | 6.95
6000 | 4.574999999999999 |  | 5000 | 4.675
6100 | 2.1 |  | 4900 | 2.95
6200 | 1.35 |  | 4800 | 2.05
43.375
1.425
Spreadsheet: 845097d1696631928-formula-to-add-numbers-in-a-column-adding-the-new-line-each-time-diesel-data
Sheet: Diesel

Date | Odometer | [NAME] | Gallons Purchased | $ Purchased | Miles/Gallon | Total Miles Driven
2023-09-30 00:00:00 | 3088.1 |  | 152.851 | 625.5
2023-10-02 00:00:00 | 3582.7 |  | 100.146 | 395.48
2023-10-03 00:00:00 | 3872.2 |  | 56.36 | 247.93
2023-10-04 00:00:00 | 4119.6 |  | 43.746 | 183.5
Spreadsheet: jonathan_mckay__17197__us open
Sheet: The Entries

 |  |  |  |  |  |  | Unpaid
[NAME] |  |  | Paid |  |  |  | Paid Entrants
 | 143 |  |  |  |  | 25 | Entrants
 | 130
 | 115
 | 47
 | 90
 | 35
 | 36
Cliff Lawrick |  |  | Paid
 | 143
 | 154
 | 36
 | 115
 | 104
 | 47
 | 38
[NAME] |  |  | Paid
 | 143
 | 59
 | 38
 | 154
 | 39
 | 75
 | 115
[NAME]
 | 143
 | 115
 | 154
 | 75
 | 38
 | 127
 | 25
[NAME]
 | 143
 | 115
 | 154
 | 130
 | 47
 | 104
 | 36
[NAME]
 | 143
 | 130
 | 47
 | 149
 | 90
 | 36
 | 115
[NAME] |  |  | Paid
 | 143
 | 115
 | 154
 | 36
 | 149
 | 32
 | 130
[NAME] |  |  | Paid
 | 130
 | 143
 | 39
 | 115
 | 154
 | 47
 | 36
[NAME] |  |  | Paid
 | 143
 | 115
 | 83
 | 149
 | 90
 | 36
 | 47
[NAME] |  |  | Paid
 | 36
 | 101
 | 115
 | 130
 | 141
 | 143
 | 154
[NAME] |  |  | Paid
 | 143
 | 115
 | 36
 | 93
 | 47
 | 130
 | 39
[NAME] |  |  | Paid
 | 143
 | 115
 | 154
 | 39
 | 130
 | 93
 | 75
Cooper Richey |  |  | Paid
 | 143
 | 36
 | 110
 | 115
 | 154
 | 129
 | 74
[NAME] |  |  | Paid
 | 143
 | 115
 | 36
 | 47
 | 90
 | 130
 | 154
[NAME] |  |  | Paid
 | 143
 | 154
 | 115
 | 47
 | 36
 | 72
 | 104
[NAME] |  |  | Paid
 | 143
 | 36
 | 130
 | 89
 | 51
 | 72
 | 32
[NAME] |  |  | Paid
 | 143
 | 115
 | 36
 | 154
 | 59
 | 47
 | 75
[NAME]
 | 143
 | 36
 | 115
 | 47
 | 74
 | 154
 | 130
Brent Johnston
 | 143
 | 47
 | 10
 | 115
 | 154
 | 100
 | 110
[NAME]
 | 13
 | 39
 | 47
 | 83
 | 115
 | 130
 | 143
[NAME]
 | 36
 | 149
 | 143
 | 8
 | 130
 | 106
 | 115
[NAME]
 | 36
 | 143
 | 154
 | 115
 | 59
 | 39
 | 94
[NAME] |  |  | Paid
 | 143
 | 130
 | 82
 | 141
 | 47
 | 154
 | 127
Derek Davies
 | 143
 | 130
 | 109
 | 115
 | 36
 | 82
 | 59
Grant Oh |  |  | Paid
 | 47
 | 36
 | 39
 | 110
 | 115
 | 137
 | 143
Spreadsheet: 740cde4b-640c-4f27-901f-16b55fe72112
Sheet: 3.2 Table

3.2 Non-farm gross domestic product
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Current prices (a) – $ million
September | 307434 | 336931 | 359221 | 368961 | 382545
December | 313233 | 341678 | 362781 | 371162 | 386665
March | 322155 | 347172 | 364968 | 374169 | 390091
June | 330689 | 353804 | 367018 | 378084 | 392946
Annual (b) | 1271686 | 1378140 | 1456377 | 1492615 | 1551492
Chain volume prices (c)- $ million
September | 340851 | 348586 | 358510 | 371338 | 379727
December | 342685 | 350082 | 362665 | 373154 | 383169
March | 344654 | 351868 | 366026 | 374819 | 386485
June | 346791 | 354610 | 368953 | 376802 | 389592
Quarterly change (from previous quarter) (d) – per cent
September | 0.6 | 0.5 | 1.1 | 0.6 | 0.8
December | 0.5 | 0.4 | 1.2 | 0.5 | 0.9
March | 0.6 | 0.5 | 0.9 | 0.4 | 0.9
June | 0.6 | 0.8 | 0.8 | 0.5 | 0.8
Annual change (from same quarter of previous year) (d)  –  per cent
September | 1.61461982202215 | 2.269320025465673 | 2.846930169312595 | 3.578142869097097 | 2.259127802702659
December | 2.078294231892001 | 2.158542101346718 | 3.594300763821048 | 2.892200791363931 | 2.683878505925168
March | 2.312202217505529 | 2.093113673423201 | 4.02366796639649 | 2.402288362028927 | 3.112435602250686
June | 2.371611509134866 | 2.254672122402254 | 4.044725191054962 | 2.127371236986825 | 3.394355656286326
(a) Calculated on the trend series using current prices.
(b) 12 months ended June. Calculated on the quarterly original series using current prices.
(c) Calculated on the trend series using chain volume measures. Reference year for chain volume measures is 2011-12. Chain volume measures are generally not additive.
(d) Calculated on the trend series using chain volume measures.
 |  |  |  |  |  |  |  | Update
Source: ABS, Australian National Accounts: National Income, Expenditure and Product, Cat. no. 5206.0 |  |  |  |  |  |  |  | 2014-12-03 00:00:00
Spreadsheet: 842239d1694351997-random-pick-a-cell-content-in-a-range-ignoring-all-blank-empty-cells-in-that-range-random-20230910
Sheet: Blad1

9 | 12 | 42 | 34
45 | 10 | 21 | 46
51 | 32 | 48 | 3
14 | 44 | 29 | 33
46 | 39 | 45 | 31
43 | 51 | 16
33 | 38 | 6
30 | 45 | 13
44 | 5 | 20 | 14
47 | 30 | 46 | 11
15 | 22 |  | 16
34 | 28 | 39 | 18
2 | 37 | 36 | 50
24 | 15 | 44 | 20
49 | 31
7 | 23 | 14 | 32
26 | 49 | 41 | 27
21 | 46 | 11 | 13
29 | 7 | 12 | 5
41 | 21 | 4 | 35
6 | 43 | 38
23 | 34 | 25 | 41
42 | 8 | 51 | 37
13 | 29 | 52 | 51
8 |  | 3 | 4
37 | 20 | 26 | 47
36 | 25 | 31 | 2
10 | 11 | 24 | 21
39 | 2 | 18 | 24
17 | 48 | 15 | 15
48 | 47 | 34 | 44
52 | 33 | 35
25 |  | 8 | 42
28 | 41 |  | 28
5 | 6 | 50 | 9
4 | 3 | 33
 | 13 | 37 | 30
3 | 24
16 | 42 | 2 | 29
27 | 36 | 7 | 52
31 | 14 | 32 | 36
38 |  | 10 | 38
 | 18 | 27 | 26
50 | 9 | 30 | 48
32 | 4 | 23
12 | 26 | 22 | 43
20 |  | 47 | 12
40 | 27 | 9 | 8
22 | 16 | 5 | 6
11 | 35 | 28 | 23
35 | 52 | 43 | 22
18 | 50 |  | 7
Spreadsheet: 47602d1246655364-sort-remove-script-customers1
Sheet: ToCheck

Customer ID | Status Check|Phone # | Contact First Name | Contact Last Name | Possible [NAME]
[EMAIL] |  | Active | Active
[EMAIL] |  | Active | Active
[EMAIL] |  | Active | Active
[EMAIL] |  | Active | Active
[EMAIL] |  | Active | Active
Spreadsheet: 96095d1295545319-excel-2007-if-and-or-book1_theboybest
Sheet: EMPLOYEES

Employee Number | Title | Surname | First Name | Gender | DOB | Address | Town | County | Post Code | Start Date | Dept | Pay Grade | Pension | Tax Letter
 |  |  |  |  |  |  |  |  |  | 1991-08-10 00:00:00 | Production | G4 | Y | L | 19 | 2011-01-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 1991-08-22 00:00:00 | Production | G4 | Y | H | 19
 |  |  |  |  |  |  |  |  |  | 1991-12-09 00:00:00 | [NAME] | G4 | Y | H | 19
 |  |  |  |  |  |  |  |  |  | 1992-03-03 00:00:00 | Production | G4 | Y | L | 18
 |  |  |  |  |  |  |  |  |  | 1992-03-05 00:00:00 | Design | G4 | N | H | 18
 |  |  |  |  |  |  |  |  |  | 1993-06-14 00:00:00 | [NAME] | G4 | N | L | 17
 |  |  |  |  |  |  |  |  |  | 1994-02-10 00:00:00 | [NAME] | G4 | N | H | 16
 |  |  |  |  |  |  |  |  |  | 1994-12-01 00:00:00 | Production | G4 | Y | H | 16
 |  |  |  |  |  |  |  |  |  | 1995-01-11 00:00:00 | Production | G4 | N | H | 16
 |  |  |  |  |  |  |  |  |  | 1995-02-06 00:00:00 | Production | G4 | Y | H | 15
 |  |  |  |  |  |  |  |  |  | 1995-02-17 00:00:00 | Production | G4 | N | L | 15
 |  |  |  |  |  |  |  |  |  | 1995-11-08 00:00:00 | [NAME] | G4 | Y | L | 15
 |  |  |  |  |  |  |  |  |  | 1996-08-05 00:00:00 | Design | G4 | Y | H | 14
 |  |  |  |  |  |  |  |  |  | 1998-01-02 00:00:00 | Production | G4 | Y | L | 13
 |  |  |  |  |  |  |  |  |  | 1998-07-11 00:00:00 | Design | G3 | Y | L | 12
 |  |  |  |  |  |  |  |  |  | 1998-08-17 00:00:00 | [NAME] | G3 | Y | L | 12
 |  |  |  |  |  |  |  |  |  | 1998-12-18 00:00:00 | Production | G3 | N | L | 12
 |  |  |  |  |  |  |  |  |  | 1999-10-11 00:00:00 | [NAME] | G3 | N | H | 11
 |  |  |  |  |  |  |  |  |  | 1999-11-29 00:00:00 | Design | G3 | N | H | 11
 |  |  |  |  |  |  |  |  |  | 2002-07-29 00:00:00 | Production | G3 | N | H | 8
 |  |  |  |  |  |  |  |  |  | 2002-11-28 00:00:00 | Design | G3 | N | H | 8
 |  |  |  |  |  |  |  |  |  | 2002-12-22 00:00:00 | Production | G3 | Y | L | 8
 |  |  |  |  |  |  |  |  |  | 2004-02-29 00:00:00 | Design | G2 | Y | H | 6
 |  |  |  |  |  |  |  |  |  | 2004-04-26 00:00:00 | Production | G2 | Y | L | 6
 |  |  |  |  |  |  |  |  |  | 2004-07-19 00:00:00 | Production | G2 | Y | H | 6
 |  |  |  |  |  |  |  |  |  | 2006-04-24 00:00:00 | Production | G2 | Y | H | 4
 |  |  |  |  |  |  |  |  |  | 2007-05-19 00:00:00 | Production | [NAME] | Y | L | 3
 |  |  |  |  |  |  |  |  |  | 2008-03-01 00:00:00 | Design | [NAME] | N | H | 2
 |  |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00 | Production | [NAME] | N | L | 2
 |  |  |  |  |  |  |  |  |  | 2010-04-04 00:00:00 | Design | [NAME] | N | H | 0
Spreadsheet: 223894d1364363728-help-designing-a-huge-table-a
Sheet: Sheet1

SITE A |  |  |  |  | SITE B |  |  |  |  |  | VENDOR SPECS. |  |  |  |  | ANTENNA SPECS. |  |  | PATH CALCULATIONS
Site ID | Site NAME | LATITUDE | LONGITUDE | ELEVATION | Site ID | Site NAME | LATITUDE | LONGITUDE | ELEVATION | DISTANCE | VENDOR | BAND | CAPACITY | CHANNEL SPACING | MODULATION | ANTENNA TYPE | [NAME] (both ends) | EWP | AVAILABILITY (%) | DOWNTIME (min pa) | DOWNTIME (seconds pa) | IMPROVEMENT FACTOR
HUB002 | LEITONGO | 09 00 43.80 S | 160 03 50.90 E | 236 m ASL | HUB003 | AUKI Existing | 08 46 06.24 S | 160 42 10.86 E | 85 m ASL |  | Ericsson  [NAME] | 3.8GHz | 236T mbps | 40 MHz | 256QAM | HSX6-36/A | 1.8m all | EWP34
 |  |  |  |  |  |  |  |  |  |  | Ericsson  [NAME] | 3.8GHz | 236T mbps | 40 MHz | 256QAM | HSX8-36 | 2.4m all | EWP34
 |  |  |  |  |  |  |  |  |  |  | Ceragon  Evol. IP | 3.8GHz | 257 mbps | 40 MHz | 256QAM | HSX6-36/A | 1.8m all | EWP34
 |  |  |  |  |  |  |  |  |  |  | Ceragon  Evol. IP | 3.8GHz | 257 mbps | 40MHz | 256QAM | HSX8-36 | 2.4m all | EWP34
 |  |  |  |  |  |  |  |  |  |  | Ceragon  Evol. IP | 3.8GHz | 257 mbps | 56MHz | 256QAM | HSX6-36/A | 1.8m all | EWP34
 |  |  |  |  |  |  |  |  |  |  | Ceragon  Evol. IP | 3.8GHz | 257 mbps | 56MHz | 256QAM | HSX8-36 | 2.4m all | EWP34
Spreadsheet: 8613b1f6-5321-446f-8064-746c335b4dbd
Sheet: Purchase Order

 | CFK Instructor Supply Requests
Date:  ___________
Instructor:__________________________________________________
Last | First
Class Title:  __________________________________________
Session(s):  Circle all that apply     1     2     3     Jville
*  Every attempt will be made to accommodate specific requests from other vendors when necessary.
Item Name and [NAME] (please be specific) | Item # if known | Vendor (online when possible) |  | Unit Price | # needed | Line Total
 |  |  |  | For office use only: | Subtotal
 |  |  |  |  | Sales Tax
 |  |  |  |  | Total
 |  |  |  | Authorized by |  | Date
Spreadsheet: 716156d1612076565-unique-distinct-dependent-lists1-three-columns-test_unique-gk4
Sheet: Sheet1

order # id | Product | Continent |  | ID | Product | Continent
1010 | Graphics card | Europe |  | 1030 | Harddisk
1010 | Soundcard | Asia
1010 | Motherboard | Us
1010 | Soundcard | Europe
1020 | Graphics card | Asia
1020 | Keyboard | Us
1020 | Motherboard | Europe
1020 | Graphics card | Us
1020 | Keyboard | Us
1030 | Harddisk | *
 |  |  | No | INPUT | OUTPUT | Remark
 |  |  | 1 | 1010 | blank | Wrong output in column F
 |  |  |  |  |  | Correct output in column F  : Graphics card, [NAME]
 |  |  |  |  |  | If select Graphics card in column F, column G = Europe
 |  |  |  |  |  | If select [NAME] in column F, column G = Asia,Europe
 |  |  | 2 | 1020 | blank | Wrong output in column F
 |  |  |  |  |  | Correct output  : Graphic card  and column G = Asia, Us
 |  |  | 3 | 1030 | blank | Wrong output in column F
 |  |  |  |  |  | Correct output : [NAME] and if column C = "*", column G to lookup to Sheet3 and show dropdown in column G the list of 3 continents ie. Europe,Asia, Us
Spreadsheet: 97773d1296854894-if-statement-maybe-order
Sheet: Sheet1

 | Incident | Truck | On Scene
1 | 567 | E111 | 19:47:06
2 | 567 | E115 | 19:49:54
1 | 568 | M111 | 20:01:15
2 | 568 | E111 | 20:02:20
1 | 569 | E112 | 03:04:15
2 | 569 | E114 | 03:04:16
Spreadsheet: 274686d1383184754-assistance-with-a-lookup-formula-example-calculation
Sheet: Sheet1

 |  | Can I add a formula in column I to look at column F and identify if it matches any payees in column L and if it matches assign a number to it?
 |  |  |  |  |  |  | Month | Identifier
 |  | SALE | 2013-03-30 00:00:00 | 2013-03-31 00:00:00 | GIANT EAGLE #5839 | -140.8 | Mar |  |  |  | Payee
 |  | SALE | 2013-03-30 00:00:00 | 2013-03-31 00:00:00 | GIANT EAGLE #229 | -9.59 | Mar |  |  |  | [NAME] | 1
 |  | SALE | 2013-03-30 00:00:00 | 2013-03-31 00:00:00 | WALGREENS #5431 | -11.85 | Mar |  |  |  | Walgreens | 2
 |  | SALE | 2013-03-29 00:00:00 | 2013-03-29 00:00:00 | Amazon.com | -45.21 | Mar |  |  |  | Amazon | 3
 |  | SALE | 2013-03-29 00:00:00 | 2013-03-31 00:00:00 | MALLARD CREEK GOLF CLUB | -12 | Mar |  |  |  | Speedway | 4
 |  | SALE | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | SPEEDWAY 03694 210 | -43.88 | Mar |  |  |  | Pet supplies | 5
 |  | SALE | 2013-03-24 00:00:00 | 2013-03-26 00:00:00 | PET SUPPLIES PLUS #92 | -14.87 | Mar |  |  |  | Carters | 6
 |  | SALE | 2013-03-24 00:00:00 | 2013-03-26 00:00:00 | CENTER LASER WASH | -10 | Mar
 |  | SALE | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | GIANT EAGLE #5839 | -180.98 | Mar
 |  | SALE | 2013-03-22 00:00:00 | 2013-03-24 00:00:00 | [NAME]'S # 391 | -190.69 | Mar
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Logan

School |  |  | Scholarship | Experiation Date
Logan |  |  | Hino Motors Scholarship | March 7th
 |  |  | Foodland Scholarship Program | March 12th
 |  |  | Ohio Association of Garden Clubs Scholarship | March 15th
 |  |  | [NAME] Memorial Scholarship | March 29th
 |  |  | [NAME] | March 31st
 |  |  | Minority Journalism Scholarship | March 31st
 |  |  | [NAME] | April  5th
 |  |  | Ohio State Fair Scholarship | July 1st
Spreadsheet: 817508d1676289290-display-the-average-of-the-previous-10-games-dynamically-bostoncelticsplayers
Sheet: Last10Avgs

 | Name | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS | GMSC | PM
 | [NAME]
Spreadsheet: 036377ef-bea9-4160-91ae-9b5e857c60d4
Sheet: Sheet1

Category | July | Aug. | Sept. | Oct. | Nov. | Dec. | Jan. | Feb. | March | April | May | June | YTD
Vols. Add
"checklist | 72 | 78 | 106 | 60 | 74 | 84 | 54 | 52 | 80 | 74 | 46 | 79 | 859
"binding | 212 | 225 | 212 | 535 | 300 | 78 | 173 | 369 | 330 | 266 | 403 | 783 | 3886
"firm ord. | 175 | 165 | 383 | 272 | 175 | 316 | 174 | 221 | 433 | 414 | 130 | 22 | 2880
"approval | 344 | 335 | 306 | 320 | 195 | 215 | 192 | 185 | 170 | 217 | 488 | 0 | 2967
"s.o. | 17 | 17 | 37 | 22 | 14 | 22 | 29 | 17 | 32 | 12 | 17 | 7 | 243
"gifts | 0 | 410 | 340 | 78 | 79 | 153 | 130 | 21 | 144 | 460 | 214 | 436 | 2465
"total | 820 | 1230 | 1384 | 1287 | 837 | 868 | 752 | 865 | 1189 | 1443 | 1298 | 1327 | 13300
vol.wdraw | 128 | 179 | 57 | 119 | 122 | 38 | 67 | 2 | 7 | 59 | 5 | 113 | 896
III Activity
Bib.new | 30 | 3 | 5 | 5 | 1 | 0 | 1 | 54 | 15 | 1 | 2 | 4 | 121
"update | 1028 | 758 | 1663 | 1158 | 818 | 1144 | 958 | 1162 | 1601 | 1229 | 2829 | 3288 | 17636
"delete | 2245 | 697 | 314 | 114 | 95 | 79 | 69 | 24 | 40 | 74 | 19 | 76 | 3846
Item new | 636 | 430 | 805 | 629 | 924 | 792 | 723 | 796 | 632 | 782 | 601 | 494 | 8244
Item upd | 510 | 423 | 565 | 600 | 526 | 209 | 409 | 406 | 1900 | 991 | 3466 | 5869 | 15874
"delete | 1866 | 757 | 427 | 205 | 193 | 64 | 85 | 22 | 28 | 96 | 35 | 172 | 3950
Order new | 574 | 569 | 629 | 629 | 457 | 416 | 315 | 475 | 802 | 373 | 489 | 394 | 6122
"update | 347 | 98 | 1173 | 1238 | 555 | 1717 | 961 | 648 | 2206 | 476 | 958 | 2174 | 12551
"delete | 169 | 0 | 981 | 1225 | 360 | 339 | 2233 | 582 | 1878 | 218 | 549 | 2005 | 10539
Non-Book
Mfilm add | 13 | 17 | 14 | 24 | 9 | 30 | 32 | 26 | 12 | 16 | 14 | 17 | 224
Mfiche add | 1092 | 1114 | 1813 | 1281 | 1289 | 1451 | 1457 | 1257 | 1119 | 1079 | 1150 | 1164 | 15266
Media add | 36 | 17 | 8 | 28 | 14 | 29 | 10 | 10 | 8 | 2 | 5 | 40 | 207
Cat.
Cat. LC | 587 | 508 | 571 | 608 | 675 | 375 | 330 | 343 | 409 | 635 | 683 | 415 | 6139
Cat. Edit | 297 | 372 | 822 | 821 | 543 | 543 | 279 | 363 | 453 | 613 | 866 | 292 | 6264
Cat. Orig. | 99 | 52 | 43 | 46 | 33 | 78 | 158 | 111 | 220 | 319 | 82 | 29 | 1270
Inventory
bcod scan | 772 | 297 | 0 | 0 | 0 | 0 | 2263 | 1678 | 1800 | 2499 | 1072 | 1166 | 11547
corr. | 101 | 12 | 2 | 3 | 27 | 36 | 123 | 100 | 112 | 198 | 105 | 96 | 915
items fd | 5 | 1 | 245 | 152 | 98 | 117 | 39 | 28 | 19 | 22 | 13 | 9 | 748
Vol./proc. | 1755 | 899 | 811 | 1596 | 1156 | 513 | 978 | 1048 | 1336 | 1504 | 1450 | 441 | 13487
Spreadsheet: 856351d1705609414-transpose-with-conditions-example-1
Sheet: Sheet1

ID | Prio | Code | String |  |  | ID | Code4 | Code1 | Code1 | Code1 | Code1 | Code2 | Code3 | Code3 | Code5 | Code5 | Code5
1000 | 2 | Code1 | String0 |  |  | 1000 | String3 | String0 | String1 | String2
1000 | 3 | Code2 | String1 |  |  | 1001 |  | String4 | String5 |  |  | String6
1000 | 4 | Code3 | String2 |  |  | 1002 |  | String7 | String8 | String9 | String10
1000 | 1 | Code4 | String3 |  |  | 1003 |  | String11 |  |  |  |  | String12 | String13
1001 | 2 | Code1 | String4 |  |  | 1004 | String15 | String14 |  |  |  |  |  |  | String16 | String17 | String18
1001 | 2 | Code1 | String5
1001 | 3 | Code2 | String6
1002 | 2 | Code1 | String7 |  |  | Result
1002 | 2 | Code1 | String8
1002 | 2 | Code1 | String9
1002 | 2 | Code1 | String10
1003 | 2 | Code1 | String11
1003 | 4 | Code3 | String12
1003 | 4 | Code3 | String13
1004 | 2 | Code1 | String14 |  |  | Row Labels | fString
1004 | 1 | Code4 | String15 |  |  | 1000 | String0|String1|String2|String3
1004 | 5 | Code5 | String16 |  |  | 1001 | String4|String5|String6
1004 | 5 | Code5 | String17 |  |  | 1002 | String7|String8|String9|String10
1004 | 5 | Code5 | String18 |  |  | 1003 | String11|String12|String13
 |  |  |  |  |  | 1004 | String14|String15|String16|String17|String18