tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 731538d1620395572-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league
Sheet: VTC

S.N. | Particulars | Bought  Units | Unit or VTC Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received  Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] 1 | 443.05311246 | 0.00058921 |  | -0.26170799 | 13725.5 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00
2 | [NAME] | -433.05311243 | 0.00061596 |  | 0.26608085 | 13725.5 | 2017-12-06 00:00:00
3 | Fees for transferring VTC from Bittrex to Ledger | -0.02 |  |  |  |  | 2017-12-06 00:00:00
4 | Fees for transferring VTC from Ledger to Bittrex | -0.001 |  |  |  |  | 2018-01-13 00:00:00
5 | [NAME] | -9.97900003 | 0.00040154 |  | 0.00399695 | 11361.9 | 2018-01-27 00:00:00
 | Next Buy
 | VTC in Ledger Nano S | 0
 | VTC in Bittrex | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 356814d1415214932-totaling-throughout-ranges-total-loans-issued
Sheet: Sheet1

loan amount | issue date |  | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
948.98 | 2013-10-08 00:00:00 |  |  |  |  | Sums number granted for each month
1063.14 | 2013-10-17 00:00:00 |  |  |  |  | Total for each month ???
484.25 | 2013-11-27 00:00:00
1000 | 2013-11-28 00:00:00 |  |  |  |  | I want to total amount of loans issued for each month from a range. This is a shortened range as it could cover a full year
200 | 2013-12-13 00:00:00
2000 | 2013-12-20 00:00:00
800 | 2014-01-10 00:00:00
1038.29 | 2014-01-10 00:00:00
Spreadsheet: 157932d1337933383-calculating-unique-value-book2
Sheet: RAW

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROPOSED |  | PL |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPROVED |  | TWQ |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECLINED |  | VEHICLE |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REJECTED |  | PLBO |  | 0
 |  |  |  |  |  |  | ULTRA |  |  |  |  |  |  |  |  |  |  | EXPIRED |  | Credit Card
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SENT |  | FUND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DISBURSED |  | FD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | ULTRA
NO | NAME | ACCOUNT | TYPE | CODE | Amount | O/S | NET | STATUES | DATE
1 |  | 123456 | ULTRA | 0 | 10000 | 0 |  | DISBURSED | 2012-05-15 00:00:00
2 |  | 123456 | ULTRA | 0 | 10000 | 0 |  | DISBURSED | 2012-04-05 00:00:00
3 |  | 258147 | ULTRA | 0 | 10000 | 0 |  | DISBURSED | 2012-04-10 00:00:00
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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
 |  |  |  |  | 1000000 |  |  | DISBURSED
Spreadsheet: 05ba324e-5d48-4842-922f-4fdf27203ca1
Sheet: Blad1

planning [NAME]
12/03/2012 tot 16/03/2012
[NAME] in de Dokter Rubbenstraat
[NAME] in de Dokter Rubbenstraat
[NAME] in de Dokter Rubbenstraat
[NAME] toplaag +onderlaag + op hoogte trekken [NAME]
19/03/2012 tot 23/03/2012
[NAME] in de Dokter Rubbenstraat
[NAME]
[NAME] tussen Friswit en de Zandberg
[NAME] in de Dokter Rubbenstraat
26/03/2012 tot 30/03/2012
[NAME] in de Dokter Rubbenstraat
[NAME]
[NAME] tussen Friswit en de Zandberg
[NAME] in de Dokter Rubbenstraat
02/04/2012 tot [NAME]
[NAME] in Rinkhout - Stapstraat
[NAME]
[NAME] kasseien in de Dokter Rubbenstraat
[NAME] en [NAME] in de Dokter Rubbenstraat
16/04/2012 tot 20/04/2012
[NAME] in Rinkhout - Stapstraat
[NAME]
[NAME] kasseien in de Dokter Rubbenstraat
[NAME] en [NAME] in de Dokter Rubbenstraat
23/04/2012 tot 27/04/2012
[NAME] in Rinkhout - Stapstraat
[NAME]
[NAME] kasseien in de Dokter Rubbenstraat
[NAME] en [NAME] in [NAME]
29/04/2012 tot  [NAME]
[NAME] in Rinkhout - Stapstraat
[NAME]
[NAME] kasseien in de Dokter Rubbenstraat
[NAME] en [NAME] in de Dokter Rubbenstraat
2/05/2012 tot  4/05/2012
[NAME] en kantstrook te Rinkhout en de Stapstraat
[NAME] kasseien in de Dokter Rubbenstraat
[NAME] en [NAME] in de Dokter Rubbenstraat
7/05/2012 tot  11/05/2012
[NAME] [NAME] en [NAME]
[NAME] in Rinkhout en de Stapstraat
14/05/2012 tot  16/05/2012
afwerking [NAME] en [NAME]
[NAME] in Rinkhout en de Stapstraat
21/05/2012 tot  25/05/2012
[NAME] in Rinkhout en de Stapstraat
29/05/2012 tot 29/06/2012
afwerking [NAME] en [NAME]
[NAME] in Rinkhout en de Stapstraat
afwerking in Rinkhout en de Stapstraat
[NAME] onderlaag en toplaag
[NAME]
[NAME] belijning en straatmeubilair
later : [NAME] beplanting
bovenliggende planning is onder voorbehoud [NAME], onvoorziene omstandigheden en planning met de onderaannemers
Spreadsheet: 64940d1265743547-flexible-range-formula-max
Sheet: Sheet2

 |  |  | MAX | MIN
 |  |  | 12 | 9
 |  |  | 15 | 6
 |  |  | 0 | 0
 |  |  | 0 | 0
11 | 1 | 9 | 0 | 0
12 | 1 |  | 0 | 0
9 | 1 |  | 0 | 0
 | 0 |  | 0 | 0
12 | 2 | 6
11 | 2
15 | 2
6 | 2
11 | 2
 | 0 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 209567d1359137785-multi-data-validation-data-validation
Sheet: Sheet1

tom | yellow
Rich | red | bike
Rich | blue | cars
Rich | orange | motorcycle
[NAME] | yellow | book
[NAME] | green | coat
[NAME] | pink | ipad
[NAME] | black | laptop
I want the yellow highlighted drop down list to give the options that correspond to the persons name.
Basically need col 2 and 3 to make drop down lists to correspond to the choice in col 1
Spreadsheet: 694892d1599857920-sumif-not-working-properly-productn-materials-planning-template
Sheet: Eco 6mm

 |  |  |  | Total for 75 batches
100000024101 | 40
100000025436 | 4.37
100000024032 | 12.75
100000023979 | 159
100000023980 | 9.74
100000025444 | 10.33
100000025391 | 0.5
200000009481 | 133
100000002979 | 74
100000024051 | 20
100000025228 | 120
100000025380 | 0.5
100000025401 | 1.4
100000025424 | 3
100000025425 | 3
100000025873 | 136.39
100000029113 | 100
100000032512 | 1000.02
100000034290 | 200
100000040473 | 205
100000045271 | 100
Spreadsheet: 25b9b486-2239-41f3-bf4f-eb2158145ca7
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 080150 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Case No. 175-S-26
Brief Title |  |  | Approval Deadline |  | Reason
 | Amending the Major Street Plan by adding NW Prairie View Road as an arterial street and by adding a new appendix
 | which provides for widening, relocation and other street, highway and drive modifications
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], 2nd District
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | 2nd District
 |  |  |  |  | or Groups |  | (Ford, [NAME])
 | Reason for Legislation |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | City Development
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For |  | without conditions
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or |  | City Plan Commission |  |  |  |  |  |  |  | (8-0)    2-5-08
 |  |  |  |  | Commission |  | By |  |  | (Abend, Archie, [NAME], [NAME], Graf,
 |  |  |  |  | Recommendation |  | Krum, Macy, Myers)
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Fact Sheet Prepared By: |  |  | Date:   2-21-08
 | [NAME]
 | Planner
Reviewed by: |  |  | Date:   2-21-08
 | [NAME], Manager
 | Development Management
Reference Numbers
 | Case No. 175-S-26
 | [NAME] (continued)
Spreadsheet: b95668e1-3ef4-4f59-9df4-7dd7649bcbf6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | [NAME] | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Requested By: |  |  |  |  | Date:
Approved By: |  |  |  |  | Date:
 | (Department Head)
Element Id: |  |  | Associated Elements:
(Field Name)
 |  |  |  |  |  |  | Add, Delete
Value |  |  | Description |  |  |  | or Edit
Explanation (if needed)
Return Completed Form to:
 |  |  | Financial Systems |  | Phone: | 486-5887
 |  |  | [NAME] |  | Fax: | 486-0239
 |  |  | Budds Building
 |  |  | U2074
*************************************************************************************************************************
FRS SYSTEM ADMINISTRATOR USE
 |  |  | FRS Table:
 |  |  | Edit Date:
System Administrator |  |  | Update Date:
Spreadsheet: 31021d1226702850-item-organization-stringconcattester
Sheet: Sheet1

RawData | Low | High |  | Low | High
1 | 10 | 19999 |  | 60 | 19999 |  | Make choices here (or keep formula references manual, just an idea)
25000 | 20 | 29999
7 | 30 | 39999
10 | 40 | 49999 |  | shg's [NAME]:
26000 | 50 | 59999 |  | 61, 64, 67, 70, 73, 76, 79, 82, 85, 88, 91, 94, 97, 100, 103, 106, 109, 112, 115, 118, 121, 124, 127, 130, 133, 136, 139, 142, 145, 148, 151, 154, 157, 160, 163, 166, 169, 172, 175, 178, 181, 184, 187, 190, 193, 196, 199, 202, 205, 208, 211, 214, 217, 220, 223, 226, 229, 232, 235, 238, 241, 244, 247, 250, 253, 256, 259, 262, 265, 268, 271, 274, 277, 280, 283, 286, 289, 292, 295, 298, 301, 304, 307, 310, 313, 316, 319, 322, 325, 328
16 | 60 | 69999
19 | 70 | 79999
22 | 80 | 89999
25 | 90 | 99999
28 | 100 | 109999
31
34
37
40 |  |  |  |  |  |  |  | This sheet has a dynamic Name range called RawData…all entries in A
43
46
49
52
55
58
61
64
67
70
73
76
79
82
85
88
91
94
97
100
103
106
109
112
115
118
121
124
127
130
133
136
139
142
145
148
151
154
157
160
163
166
169
172
175
178
181
184
187
190
193
196
199
202
205
208
211
214
217
220
223
226
229
232
235
238
241
244
247
250
253
256
259
262
265
268
271
274
277
280
283
286
289
292
295
298
301
304
307
310
313
316
319
322
325
328
Spreadsheet: 862852d1710431563-help-with-stack-bar-gantt-gantt_mrshorty
Sheet: after1

 | Task | Start Date | Duration | End Date |  |  | Start Date | End date |  | add data for "dummy series"
 | Task 1 | 2024-02-01 00:00:00 | 37
 | Task 2 | 2024-02-09 00:00:00 | 379 |  |  |  |  |  |  | 2025-01-01 00:00:00 | 3
 | Task 3 | 2024-02-09 00:00:00 | 405
 | Task 4 | 2024-07-10 00:00:00 | 268
 | Task 5 | 2024-07-10 00:00:00 | 16
 | Task 6 | 2024-12-09 00:00:00 | 16
 | Task 7 | 2025-03-20 00:00:00 | 15
 | Task 8 | 2025-04-04 00:00:00 | 7
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, July 26 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 1315ad60-2f4b-405d-9f86-c003794c7f87
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
 | 8731.0 Building Approvals, Australia
 | TABLE 77. Value of Building Approved, Chain Volume Measures, Original - Queensland
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total houses ;  New ; |  |  | Original | A590497K | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total other residential building ;  New ; |  |  | Original | A590498L | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  New ; |  |  | Original | A590499R | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590500L | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590501R | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590502T | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590503V | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 5f7d9f66-4e24-40e0-80d0-532d5e7d1138
Sheet: Corporate VC Deal Stages

Total Venture Capital and Corporate Venture Capital by Deal Stage - Last Year
01/01/2012-12/31/2012
Company Stage as of Investment Round | Total # Deals | Average $M Per Deal | Total $M Invested in that Stage by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Stage Category
Seed | 276 |  | 725.5839 | 28 |  | 66.8786
Early Stage | 1643 |  | 7751.8816 | 227 |  | 510.5341
Expansion | 964 |  | 9417.1845 | 172 |  | 919.5944
Later Stage | 832 |  | 8633.1953 | 138 |  | 681.3987
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 117633d1312918186-return-multiple-values-excel-tracker-v1-modified
Sheet: Sheet1

 | Baseline | February | July |  | February | 1c | 1b | 1a | 2c | 2b | 2a | 3c | 3b | 3a | 4c | 4b | 4a | 5c | 5b | 5a
[NAME] | 1c | 1a | 2c |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 1c | 1b | 2c |  |  |  |  | [NAME] |  | [NAME] | [NAME]
[NAME] | 1a | 2c | 2b
[NAME] | 2b | 2a | 3c
[NAME] | 2a | 2b | 3c
[NAME] | 2c | 1a | 2b
[NAME] | 2c | 2b | 2a
[NAME] | 1b | 2a | 3c
Spreadsheet: 801978d1666536386-change-color-of-rows-depending-on-content-exceltest
Sheet: Asset Checklist

UID | Digital PDF | Audio | txt File | Print PDF | Web Questions | Video IDs RTF | Backpage | Column1
8-020323-S | x | ready | -- | -- | x | x |  | should be orange
8-020423 |  | ready | -- | -- |  |  |  | should be orange
8-020423-S |  | ready | -- | -- |  |  |  | should be orange
66-120123 | x | x | -- | -- | -- | -- | -- | should be green
18-112122 | ready | ready |  | -- | -- | -- |  | should be orange
2-120122 | ready | ready | -- | -- | -- | -- | -- | should be orange
22-120122 | ready | ready |  | -- | -- | -- | -- | should be orange
12-010123 | x | x | -- | x | -- | x | x | should be green
12-010123-LL | x | x | -- | x | -- | x | x | should be green
12-010123-S | x | x | -- | x | -- | x |  | should be orange
12-010223 | x | x | -- | x | -- | x | x | should be green
12-010223-LL | x | x | -- | x | -- | x | x | should be green
12-010223-S | x | x | -- | x | -- | x |  | should be orange
14-120522 |  |  |  | -- | -- | -- |  | should have no color
16-120522 |  |  |  | -- | -- | -- |  | should have no color
18-120522 |  |  |  | -- | -- | -- |  | should have no color
302-010123 | ready | ready | -- | -- | -- | ready |  | should be orange
14-121922 |  |  |  | -- | -- | -- |  | should have no color
16-121922 |  |  |  | -- | -- | -- |  | should have no color
300-010123 | ready | ready | -- | -- | -- | ready |  | should be orange
Spreadsheet: e776be39-f608-40ea-8a03-762434a560d4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Planet Footprint - Account Management Toolkit | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | This toolkit allows you to keep your council's supplier/utility accounts up to date on Planet Footprint's systems.
 | What you can do: |  |  |  |  | (Click blue links to go directly to the sheet you want to work on.)
 | 1. |  | Solve problems with High Priority accounts. |  |  |  |  | Sheet 2 |  | High Priority problems are those that may prevent your organisation or Footprinted Properties from being included in comparisons, benchmarks and targets.
 | 2. |  | Add accounts. |  |  |  |  | Sheet 3 |  | Use this section if you have discovered additional accounts or if you have opened new accounts due to a change of retailer or a new or newly acquired facility.
 | 3. |  | Change or close existing accounts. |  |  |  |  |  |  | Use these sections to add or change address, responsibility, cost centre, asset codes, Green Power percentages etc, or to notify Planet Footprint of closed, transferred or consolidated accounts
 |  |  |  | Change or close Electricity accounts |  |  | Sheet 4
 |  |  |  | Change or close Mains Gas accounts |  |  | Sheet 5
 |  |  |  | Change or close Bottled Gas accounts |  |  | Sheet 6
 |  |  |  | Change or close Water accounts |  |  | Sheet 7
 | 4. |  | Solve problems with Low Priority accounts. |  |  |  |  | Last Sheet |  | Problems with Low Priority accounts are worth solving in order to have high compliance but these problems usually detract little from the accuracy of your footprint reports.
 | Once completed, save the Excel workbook (File - Save) and email it to [EMAIL]
 |  | Issued on 29 Jan 2009 for Anywhere Council.
 |  | © 2009 Planet Footprint Pty Ltd
Spreadsheet: 93760d1293539388-how-to-sum-costs-associated-to-a-string-excel_help_758039
Sheet: Sheet1

Date | Category | Sub-category | Cost
27.11.2010 | Cars | Ferrari | 100
27.11.2010 | Meals | lunch | 1
27.11.2010 | [NAME] | BMW | 15
27.11.2010 | cars | Ferrari | 245
27.11.2010 | [NAME] | Honda | 12
27.11.2010 | meals | dinner | 2
28.11.2010 | cars | toyota | 9
07.12.2010 | Cars | ford | 25
08.12.2010 | [NAME] | Honda | 10
09.12.2010 | Cars | ford | 12
10.12.2010 | Meals | Dinner | 2
10.12.2010 | Meals | Dinner | 2
12.12.2010 | Meals | lunch | 1
1 | What is the total cost of cars in the whole period?
2 | What is the total cost of dinner in the whole period?
3 | What is the total cost of dinner in the December period?
Sum of Cost
Category | Sub-category | Total
Cars | Ferrari | 345
 | ford | 37
 | toyota | 9
Cars Total |  | 391
Meals | dinner | 6
 | lunch | 2
Meals Total |  | 8
[NAME] | BMW | 15
 | Honda | 22
[NAME] |  | 37
(blank) | (blank)
(blank) Total
Grand Total |  | 436
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Mining Tech Cert 3

MINING TECHNOLOGY
Certificates
Student Name:
ID #
Mining Technician Assistant II | Semester | Grade
___ MNG 123 (4) Mining Electricity I
___ MNG 125 (1) Mining Electricity I Lab
___ ELT 265 (3 Applied Fluid Power
OR ___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
Mining Technician I
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ MNG 160 (3) Elements of Underground Mining
___ MNG 161 (1-3) Elements of Underground Mining Lab
___ MNG 150 (3) Mining Laws
___ MNG 286 (3) [NAME] and Ventilation
Mining Technician II
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ MNG 123 (4) Mining Electricity I
___ MNG 125 (1) Mining Electricity I Lab
___ MNG 150 (3) Mining Laws
___ MNG 286 (3) [NAME] and Ventilation
___ MNG 190 (3) Mine Emergency Technician
OR ___ KHP 190 (2) First Aid and Emergency Care
___ IMT 100 (3) Welding for Maintenance
___ IMT 101 (2) Welding for [NAME]
Southeast Kentucky Community & Technical College | Updated Spring 2013