tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 214691d1361053203-i-need-to-find-last-column-thet-contains-data-and-first-column-that-has-data-test
Sheet: Test

 | ACCOUNT NAME |  |  |  |  |  |  | SERIAL |  |  | Last | First | Number of Months | Row
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 | Account # |  |  |  |  |  |  | 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
Spreadsheet: 858318d1707048115-how-to-highlight-or-identify-non-unique-or-non-possible-combination-of-text-in-column-new-microsoft-excel-worksheet-3-
Sheet: Sheet1

IND | M1 | M2 | M3
P1 | AA | MISSING | GG
P2 | TT | CC | MISSING
IND1 | AA | GC | GT
IND2 | TA | CG | MISSING
IND3 | AT | GG | AA
IND4 | GG | CC | CC
IND5 | CC | GG | AT
 | 1 | 0 | 0
Here I would like to identify columns having not possible text combination from P1 and P2 of IND column; for example in culmn B GG of IND4 and CC of IND5 is not possible because [NAME] is AA and [NAME] is TT here possibilities are only AA, TT, TA or AT for IND1 to IND5. if there is any column contains not possible text combination then i would like to give for that column otherwise 0
Spreadsheet: 121847d1316454962-formula-to-remove-part-of-a-text-from-a-cell-by-lookin-at-a-table-adsfadsf
Sheet: ExampleWordsToRemove

[NAME]
Boardshorts
Crew Sock 3 Pk
[NAME]
[NAME]
Flex Fit Hat Twill
Gloves
Jacket
L/S Woven
Non-Denim Pants
Non-Denim Shorts
S/S TEE
S/S Woven Shirt
Screen Hooded Fleece
[NAME]
Tank Top
Web Belt
Denim Pants
Synthetic Wallet
[NAME]
Wallet
[NAME]
Flannel
Natural Wallet
Novelty Fleece
S/S Crew Knit
[NAME]
S/S Specialty
Screen Crew Fleece
L/S Knit Shirt
Novelty Knits
[NAME]
V-Neck Sweater
Pant
210 FIT HAT
Spreadsheet: 99721d1298310327-if-then-over-a-column-qaqc-waterpier1
Sheet: QAQC Table

Title
Parameter |  | [NAME] | Date | Time | Min | Date | Time
Temp | F
SpCond | mS/cm
Salinity | ppt
Depth | m
Battery | V
Chlorophyll | ug/L
Turbidity+ | NTU
ODO% | %
[NAME] | mg/l
Spreadsheet: 883299d1731892770-formula-to-find-the-total-of-stock-according-to-date-stock-control
Sheet: Tom

Date | Stock | Quantity | Price | Total
2024-11-07 00:00:00 | Coffee | 2
2024-11-08 00:00:00 | Sugar | 6
2024-11-14 00:00:00 | Milk | 1
Spreadsheet: tracy_geaccone__40496__2002 Plan Template
Sheet: PRMA

DETAIL OF PRICE RISK MANAGEMENT ACTIVITIES
(Millions of Dollars)
 |  | Unrealized (Gain) / Loss on Price Risk Management Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Cash Flow
Originations |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Unrealized Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income Stmt Management Overview |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Contract Monetization Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Contract Monetization Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Prepaid Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Prepaid Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transfers |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total Change in PRM Activities (line 89)
Spreadsheet: kate_symes__18199__EESSales_dailyfeb
Sheet: 2-24

NP15 | 2001-02-24 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 217.95 | Fixed Off Peak | 165 |  |  |  | Fixed Peak | 203.44 |  | Fixed Off Peak | 152.75 |  |  | Fixed Peak | 203.44 | Fixed Off Peak | 152.75
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -8.91 | -8.91 |  |  | 1 | -122.43 | 0 | -54 | -95.43 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | 0 | 0 | -8.03 | -8.03 |  |  | 2 | -123.73 | 0 | -54 | -88.73 |  |  | 2 | -1.94 | 0 | 0 | -1.94
3 | 0 | 0 | -7.43 | -7.43 | 0 |  | 3 | -124.62 | 0 | -44 | -85.62 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | 0 | 0 | -7.25 | -7.25 |  |  | 4 | -124.49 | 0 | -44 | -83.49 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | 0 | 0 | -7.43 | -7.43 |  |  | 5 | -123.98 | 0 | -44 | -85.98 |  |  | 5 | -1.92 | 0 | 0 | -1.92
6 | 0 | 0 | -8.09 | -8.09 |  |  | 6 | -123.1 | 0 | -54 | -97.1 |  |  | 6 | -1.94 | 0 | 0 | -1.94
7 | 0 | 0 | -9.54 | -9.54 |  |  | 7 | -176.13 | 0 | -54 | -87.13 |  |  | 7 | -2 | 0 | 0 | -2
8 | 0 | 0 | -11.55 | -11.55 |  |  | 8 | -173.48 | 0 | -54 | -94.48 |  |  | 8 | -2.09 | 0 | 0 | -2.09
9 | 0 | 0 | -13.51 | -13.51 |  |  | 9 | -172.3 | 0 | -54 | -106.3 |  |  | 9 | -2.17 | 0 | 0 | -2.17
10 | 0 | 0 | -14.11 | -14.11 |  |  | 10 | -171.39 | 0 | -54 | -117.39 |  |  | 10 | -2.2 | 0 | 0 | -2.2
11 | 0 | 0 | -14.35 | -14.35 |  |  | 11 | -170.51 | 0 | -54 | -123.51 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | 0 | 0 | -14.08 | -14.08 |  |  | 12 | -171.48 | 0 | -54 | -126.48 |  |  | 12 | -2.2 | 0 | 0 | -2.2
13 | 0 | 0 | -13.93 | -13.93 |  |  | 13 | -171.26 | 0 | -54 | -127.26 |  |  | 13 | -2.19 | 0 | 0 | -2.19
14 | 0 | 0 | -13.32 | -13.32 |  |  | 14 | -172.4 | 0 | -54 | -126.4 |  |  | 14 | -2.16 | 0 | 0 | -2.16
15 | 0 | 0 | -12.7 | -12.7 |  |  | 15 | -172.29 | 0 | -54 | -124.29 |  |  | 15 | -2.13 | 0 | 0 | -2.13
16 | 0 | 0 | -12.7 | -12.7 |  |  | 16 | -172.41 | 0 | -54 | -121.41 |  |  | 16 | -2.14 | 0 | 0 | -2.14
17 | 0 | 0 | -12.98 | -12.98 |  |  | 17 | -172.64 | 0 | -54 | -116.64 |  |  | 17 | -2.15 | 0 | 0 | -2.15
18 | 0 | 0 | -14.58 | -14.58 |  |  | 18 | -170.46 | 0 | -54 | -120.46 |  |  | 18 | -2.22 | 0 | 0 | -2.22
19 | 0 | 0 | -16.81 | -16.81 |  |  | 19 | -168.6 | 0 | -54 | -122.6 |  |  | 19 | -2.31 | 0 | 0 | -2.31
20 | 0 | 0 | -16.19 | -16.19 |  |  | 20 | -169.15 | 0 | -54 | -118.15 |  |  | 20 | -2.29 | 0 | 0 | -2.29
21 | 0 | 0 | -15.19 | -15.19 |  |  | 21 | -169.99 | 0 | -54 | -112.99 |  |  | 21 | -2.25 | 0 | 0 | -2.25
22 | 0 | 0 | -13.99 | -13.99 |  |  | 22 | -170.95 | 0 | -54 | -103.95 |  |  | 22 | -2.19 | 0 | 0 | -2.19
23 | 0 | 0 | -12.27 | -12.27 |  |  | 23 | -119.52 | 0 | -54 | -115.52 |  |  | 23 | -2.11 | 0 | 0 | -2.11
24 | 0 | 0 | -10.49 | -10.49 |  |  | 24 | -120.65 | 0 | -54 | -105.65 |  |  | 24 | -2.04 | 0 | 0 | -2.04
Spreadsheet: 176279d1345802569-vlookup-counta-to-draw-figures-for-certain-names-test-1
Sheet: Sheet1

Name | Site | Surveys Complete | Surveys Accepted
[NAME] | 1 | 2012-06-25 00:00:00 | 2011-12-13 00:00:00
[NAME] | 2 | 2012-06-25 00:00:00 | 2011-11-11 00:00:00
[NAME] | 3 | 2012-06-25 00:00:00 | 2011-11-14 00:00:00
[NAME] | 4 |  | 2011-12-22 00:00:00 |  |  |  |  | Name | Surveys Complete | Surveys Accepted
[NAME] | 5 | 2012-07-16 00:00:00 | 2011-12-12 00:00:00 |  |  |  |  | [NAME] | ? | ?
[NAME] | 6 | 2012-07-13 00:00:00 | 2011-12-09 00:00:00 |  |  |  |  | London | ? | ?
[NAME] | 7 | 2012-07-09 00:00:00 | 2011-11-18 00:00:00 |  |  |  |  | Southend | ? | ?
[NAME] | 8 | 2012-07-13 00:00:00
[NAME] | 9
[NAME] | 10 | 2012-07-03 00:00:00
[NAME] | 11 | 2012-06-29 00:00:00
[NAME] | 12 | 2012-07-09 00:00:00
[NAME] | 13 | 2012-07-11 00:00:00 | 2011-11-17 00:00:00
[NAME] | 14 | 2012-07-13 00:00:00 | 2011-11-18 00:00:00
[NAME] | 15 | 2012-06-19 00:00:00 | 2011-12-09 00:00:00
[NAME] | 16 | 2012-06-29 00:00:00 | 2011-12-09 00:00:00
[NAME] | 17 |  | 2011-11-14 00:00:00
London | 67 | 2012-06-19 00:00:00 | 2011-12-09 00:00:00
London | 68 | 2012-07-09 00:00:00 | 2011-11-11 00:00:00
London | 69 | 2012-06-18 00:00:00 | 2011-12-15 00:00:00
London | 70 | 2012-07-09 00:00:00 | 2011-11-18 00:00:00
London | 71 | 2012-07-13 00:00:00 | 2011-12-09 00:00:00
London | 72 | 2012-07-11 00:00:00 | 2011-12-15 00:00:00
London | 73 | 2012-06-26 00:00:00 | 2011-11-14 00:00:00
London | 74 | 2012-07-11 00:00:00 | 2011-11-18 00:00:00
London | 75 | 2012-06-26 00:00:00 | 2011-11-11 00:00:00
London | 76 | 2012-07-03 00:00:00 | 2011-12-12 00:00:00
London | 77 | 2012-07-05 00:00:00 | 2011-11-17 00:00:00
London | 78 | 2012-07-03 00:00:00
London | 79 | 2012-06-22 00:00:00 | 2011-11-11 00:00:00
London | 80 | 2012-06-25 00:00:00 | 2011-12-09 00:00:00
Southend | 100 |  | 2011-11-11 00:00:00
Southend | 101 | 2012-06-29 00:00:00 | 2011-12-22 00:00:00
Southend | 102 | 2012-07-05 00:00:00 | 2011-11-18 00:00:00
Southend | 103 | 2012-07-31 00:00:00 | 2011-11-11 00:00:00
Southend | 104 | 2012-07-31 00:00:00 | 2011-12-15 00:00:00
Southend | 105 | 2012-06-19 00:00:00 | 2011-11-14 00:00:00
Southend | 106 | 2012-06-28 00:00:00 | 2011-12-12 00:00:00
Southend | 107 | 2012-06-07 00:00:00
Southend | 108 | 2012-06-07 00:00:00 | 2011-11-11 00:00:00
Southend | 109 | 2012-06-12 00:00:00 | 2011-11-11 00:00:00
Southend | 110 | 2012-06-18 00:00:00 | 2011-11-11 00:00:00
Southend | 111 | 2012-06-18 00:00:00 | 2011-11-11 00:00:00
Spreadsheet: 214669d1361043114-count-number-of-rows-with-same-date-so-it-can-be-charted-event-help-jacc
Sheet: SOURCE

Device Name | Component Name | Event Name | Last Updated Time | Status | Date
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Cleared |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/900280-count-number-of-rows-with-same-date-so-it-can-be-charted.html
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:05:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Cleared |  |  |  |  |  | Row Labels | Count of  Event Name
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Active |  |  |  |  |  | 2012-12-26 00:00:00 | 2
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Active |  |  |  |  |  | 2012-12-27 00:00:00 | 3
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Active |  |  |  |  |  | 2012-12-28 00:00:00 | 20
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Active |  |  |  |  |  | Grand Total | 25
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 05:04:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 03:25:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 03:12:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 03:12:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 02:53:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 02:31:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-28 02:31:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-27 17:01:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-27 17:01:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-27 01:58:00 | Active
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-26 17:01:00 | Cleared
device name | IP addresses | 7021: D Channel Out Of Service | 2012-12-26 17:01:00 | Active
Spreadsheet: 64571112-f06c-495d-921d-84e9cd1b9875
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259087 | 71735 | Johannes | Du Plessis | RSA | 4 | 00:31:36 | 00:00:00 | 01:04:03 | 00:00:00 | 00:16:11 | 1 | 01:51:50
259087 | 33941 | Travis | Johnston | RSA | 5 | 00:31:35 | 00:00:00 | 01:04:03 | 00:00:00 | 00:17:28 | 2 | 01:53:06
259087 | 71749 | [NAME] | Randrianambinina | MAD | 7 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:55:35
259087 | 10863 | [NAME] | Mansilla | ARG | 1 | 00:32:47 | 00:00:00 | 01:10:35 | 00:00:00 | 00:18:01 | 4 | 02:01:23
259087 | 71736 | [NAME] | Botes | RSA | 3 | [NAME] | 00:00:00 | 01:11:01 | 00:00:00 | 00:18:44 | 5 | 02:04:38
259087 | 49772 | Martin | Mbofana | ZIM | 2 | 00:34:07 | 00:00:00 | 01:25:37 | 00:00:00 | 00:19:56 | 6 | 02:19:40
259087 | 6240 | [NAME] | Petkovic | CRO | 6 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 211906d1359986977-leaving-a-cell-blank-unless-referenced-cells-contain-a-value-time-card-ref
Sheet: Sheet1

 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday
 | Monday |  | 2013-01-01 08:00:00 | 2013-01-01 12:00:00 | 0 | 1 | 0 |  | THIS SHOULD BE 4 HOURS, NOT 16.
 | Tuesday |  | 08:00:00 | 16:30:00 | 0.5 | 0 | 2
 | Wednesday |  | 08:00:00 | 16:30:00 | 0.5 | 0 | 0
 | Thursday |  | 08:00:00 | 16:30:00 | 0.5 | 3.75 | 0
 | Friday |  | 08:00:00 | 16:30:00 | 2.5 | 0 | 1
 | Saturday
 | Total hours |  |  |  |  |  |  |  | THIS SHOULD TOTAL 36, NOT 56 HOURS
Spreadsheet: 102545d1300467208-final-touches-new-job-template-autofill
Sheet: Deposit

INVOICE
For Customer: |  |  |  |  |  | From: |  | Terms | Deposit
Name: | 0 |  |  |  |  | LaMorinda Tile and Stone
Address: | 0 |  |  |  |  | 2261 Commerce Ave., Suite B
City: | 0 |  |  |  |  | Concord, CA 94520 |  | Work Order#
Phone: | 0 |  |  |  |  | [PHONE]
Fax: | 0 |  |  |  |  | [PHONE] |  | Date | 2011-03-18 00:00:00
Phase/Date |  | Description |  |  |  |  |  |  | Price
TOTAL DUE: |  |  |  |  |  |  |  |  | 0
We Appreciate Your Prompt Payment.
Spreadsheet: 715597d1611772820-concatenation-of-a-column-based-on-another-column-entries-query
Sheet: ENTRY 2

NUMBER | serial | ext | survey | cropext | Survey Concatenation
721468155261 |  |  | 230-6 | 0.835 | 230-6, 217-10
721468155261 |  |  | 217-10 | 0.385
968047478678 |  |  | 182-11 | 0.14 | 182-11,215-2, 194-4
 |  |  | 215-2 | 1.84
 |  |  | 194-4 | 1.3
558862288012 |  |  | 31-2 | 0.965 | 31-2, 28-4
 |  |  | 28-4 | 0.53
597882830394 |  |  | 223-1B | 0.485 | 223-1B, 215-3
 |  |  | 215-3 | 0.16
399900960516 |  |  | 210-1 | 0.33 | 210-1, 208-1, 228-1D
 |  |  | 208-1 | 0.66
 |  |  | 228-1D | 0.15
394588931704 |  |  | 210-1 | 0.33 | 210-1,210-10,210-2, 210-9, 228-1B, 229-1B
 |  |  | 210-10 | 0.53
 |  |  | 210-2 | 0.475
 |  |  | 210-9 | 0.42
 |  |  | 228-1B | 0.15
 |  |  | 229-1B | 0.33
Spreadsheet: 793534d1661525007-return-a-number-based-on-text-price-selection
Sheet: Sheet1

Quote Amount | Selected | Price
894550 |  | 356739.8
356739.8 | x
870000
320139.8
784725
Quote Amount | Selected | Price
894550 |  | 870000
356739.8
870000 | Yes
320139.8
784725
Spreadsheet: 165477d1341243768-auto-populate-data-in-excel-student-information
Sheet: Sheet1

Field of Study | General Field | Sub-Field | Student  Name | Student Last Name
Forests And Nature Conservation |  |  | Andressa | Ford
Oceanography |  |  | Fernanda | Lima
Oceanography |  |  | Felipe | Smith
Game Art |  |  | [NAME] | Lyles
Agricultural Production |  |  | Gustavo | Mills
Design |  |  | Hellem | [NAME]
International Business |  |  | [NAME] | Menino
Fashion Design |  |  | Camila | [NAME]
Technology And Digital Media |  |  | Wagner | [NAME]
Techonology And Digital Media |  |  | Toshihiro | [NAME]
Spreadsheet: 109710d1306492070-index-match-and-count-results-match-and-count
Sheet: Sheet1

JobTitles | UK | Austria | Canada
IT Director
[NAME]
IT Analyst
I would like to match 2 columns (jobtitles & country) against "sheet2" data and count "email" column
so result would be
IT Director | 2 | 1 | 0
IT Manager | 0 | 1 | 0
IT Analyst | 1 | 0 | 2
Spreadsheet: 698802d1602179388-number-incrementor-formula-help-needed-book1
Sheet: Sheet1

 | Current Data |  |  |  |  |  |  |  |  | Result needed
 | Product | SHOP |  |  |  |  |  |  |  | Product | Identification because of the Shops
 | Apple | NY |  |  |  |  |  |  |  | Apple-01
 | Apple | NC |  |  |  |  |  |  |  | Apple-01
 | Apple | WC |  |  |  |  |  |  |  | Apple-02
 | Pear | PA |  |  |  |  |  |  |  | Apple-02
 | Pear | PA |  |  |  |  |  |  |  | Apple-03
 | Pear | PA |  |  |  |  |  |  |  | Apple-03
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Pear | PA |  |  |  |  |  |  |  | Pear-01
 | Mango | CA |  |  |  |  |  |  |  | Pear-01
 | Mango | LA |  |  |  |  |  |  |  | Pear-01
 | Mango | LA |  |  |  |  |  |  |  | Pear-01
 |  |  |  |  |  |  |  |  |  | Pear-01
 |  |  |  |  |  |  |  |  |  | Mango-01
 |  |  |  |  |  |  |  |  |  | Mango-01
 |  |  |  |  |  |  |  |  |  | Mango-02
 |  |  |  |  |  |  |  |  |  | Mango-02
 |  |  |  |  |  |  |  |  |  | Mango-02
Spreadsheet: 94820d1294584218-extend-index-match-billing-statement1
Sheet: Billing Statement

[Street Address] |  |  | STATEMENT NO. | [100]
[City, ST Post Code] |  |  | DATE | 2011-01-09 00:00:00
[Phone] [Fax] |  | CUSTOMER ID |  | [NAME]
[e-mail]
BILL TO | [Name] |  | COMMENTS
 | [Company Name]
 | [Street Address]
 | [City, ST  ZIP Code]
 | [Phone]
DATE | Reference |  | RECEIVED | AMOUNT | BALANCE
2010-09-24 00:00:00 | 662 |  | 2010-08-31 00:00:00 | 200 |  |  | 107
CURRENT | 1-30 DAYS PAST DUE | 31-60 DAYS  PAST DUE | 61-90 DAYS  PAST DUE | OVER 90 DAYS  PAST DUE | AMOUNT DUE
 | 0 | 0 | 0 | 0
REMITTANCE
Statement # | [100]
Date
Amount Due
Amount Enclosed
Spreadsheet: 142405d1329825971-counting-unique-values-in-a-named-range-using-countif-0234
Sheet: Sheet1

JANUARY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | FEBRUARY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | [NAME] | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | APRIL | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | MAY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | [NAME] | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | JULY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | AUGUST | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | SEPTEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | OCTOBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | NOVEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | DECEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE
 | 1 |  |  |  |  |  |  | 20
 | 2 |  |  |  |  | 9 |  | 21
 | 3 |  |  |  |  |  |  | 22
 | 4 |  |  |  |  | 9 |  | 23
 | 5 |  |  |  |  |  |  | 24
 | 6 |  |  |  |  |  |  | 25
 | 7 |  |  |  |  |  |  | 26
 | 8 |  |  |  |  |  |  | 1
 | 9 |  |  |  |  |  |  | 2
 | 1 |  |  |  |  |  |  | 3
 | 2 |  |  |  |  |  |  | 4
 | 3 |  |  |  |  |  |  | 5
 | 4
 | 5
TOTAL ACTIVE CLIENTS | #N/A
Spreadsheet: 0e43378e-0c3f-4306-b2ed-856481c1bdb3
Sheet: Sheet1

2014 Webelos Adventure Camp Menu
Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4
Breakfast
 |  |  | Breakfast Pizza: Sausage (turkey) & Gravy Bagel |  |  | Pancakes |  |  | Assorted Yogurt
 |  |  |  |  |  | Bacon* |  |  | Cereal
 |  |  | Fruit |  |  | Fruit |  |  | Fruit
 |  |  | Juice |  |  | Juice |  |  | Juice
 |  |  |  |  |  | *Turkey Bacon Available
Assorted Cereal and Milk availible daily - Coffee available daily for adults
Lunch
 |  |  | Sub Sandwich |  |  | Corn Dog
 |  |  | Turkey or Turkey Ham |  |  | Baked Beans
 |  |  | Lettuce / Tomato / Pickle |  |  | Fruit Cup
 |  |  | Fruit
 |  |  | Chips
Water and juice provided -  Salad bar available daily
Dinner
Spaghetti with Meatballs (Beef) |  |  | Hamburgers |  |  | Salisbury Steak
Roll |  |  | Lettuce / Tomato / Pickle |  |  | Gravy
Broccoli |  |  | Potato Wedges |  |  | [NAME]
Cookies |  |  | Warm Peach Delight |  |  | Corn
 |  |  |  |  |  | Roll
 |  |  |  |  |  | Apple
 |  |  |  |  |  | Ice Cream Bar
Water and juice provided -  Salad bar available daily
Spreadsheet: 161555d1339552261-check-for-escalation-after-consultation-brent_solution
Sheet: Sheet1

Case ID | Summary | Create date | Subscriber ID | Follow Up
HD0000000576495 | CR: Compliments | 2011-01-04 00:00:00 | 52064730
HD0000000576780 | CR: Consultation | 2011-01-04 00:00:00 | 64465750 | CR: Customer Issue (direct)
HD0000000576730 | CR: Consultation | 2011-01-04 00:00:00 | 50355684 | CR: Escalation
HD0000000576763 | CR: Customer Issue (direct) | 2011-01-04 00:00:00 | 74880147
HD0000000576780 | CR: Customer Issue (direct) | 2011-01-04 00:00:00 | 64465750
HD0000000576702 | CR: Escalation | 2011-01-07 00:00:00 | 50355684
Spreadsheet: 855334d1704933764-return-o-or-1-if-cell-value-is-found-in-2nd-worksheet-match-6-
Sheet: Main

Tract+Group | Target Market
531.15.2 |  | <----target market cells should return a "0" or "1".  If a tract+group # in column A is found in the "Target Groups" worksheet it should return a "1" and a "0" if it was not listed in the Target Groups worksheet.
535.07.2 | 0
529.05.2 | 0
536.20.1 | 0
541.16.2 | 0
541.13.1 | 0
545.02.1 | 1
534.21.2 | 0
521.02.2 | 0
541.19.1 | 0
531.09.2 | 0
527.07.2 | 0
540.11.2 | 0
531.10.2 | 0
542.22.3 | 0
529.03.2 | 0
537.29.2 | 0
541.21.1 | 1
544.04.1 | 1
528.10.3 | 0