tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53426d1253298649-find-matching-value-find-matching
Sheet: Sheet1

WW Division | Mapped Parts | Crosses that may need mapping
POWERWAVE TECHNOLOGIES - POWERWAVE OC | OPA2277UA | AM26C31IDR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HC02M96 | AM26C31IDR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HC125M96E4 | AM26C32IDR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | SN65HVD22DR | CC1021RSSR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HC393M96 | [NAME] | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TMP401AIDGKR | CD74HC02M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS3305-33D | [NAME] | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS54010PWP | CD74HC08M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS5450DDA | CD74HC125M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS74401KTWT | CD74HC14M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS77801PWP | CD74HC4040M | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | UA7812CKC | CD74HC4051M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | MSP430F1121AIPW | CD74HC4053M | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | OPA2277UA | CD74HC4094M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | REF3033AIDBZRG4 | CD74HC4538M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | SN74LVC244APWR | CD74HCT08M | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | SN74LVC2G07DCKR | CD74HC02M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TLK1201AIRCPR | CD74HCT4094M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HCT132M96 | CDC7005ZVAR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HCT4040M96 | CDCM7005RGZR | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CD74HCT4094M | [NAME] | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | SN74AHCT86PWR | DAC5652IPFB | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CDC7005ZVAR | CD74HC393M96 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CDCM7005RGZR | [NAME] | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | CDCM7005RGZT | GC5016-PB | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | DAC7571IDBVR | SN74LVC04AD | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | DAC7571IDBVT | TMP100NA/250 | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | DAC7571IDBVT | TPS77801PWP | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | GC5016-PB | OPA2277UA | N
POWERWAVE TECHNOLOGIES - POWERWAVE OC | TPS3823-50DBVR | DAC7571IDBVR | N
Spreadsheet: 55438d1255547080-date-references-copy2-of-powertrain-predictor-working_oct2009
Sheet: Tran Chg PT

Count of Unit |  | Month
Model | Year | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | Grand Total
D | 1998 |  |  | 1 |  |  |  | 4 |  | 1 |  | 3 |  | 9
 | 1999 | 2 | 4 | 4 | 1 | 4 | 2 | 1 | 6 | 3 | 6 | 7 | 2 | 42
 | 2000 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 3 | 4 | 1 | 19
 | 2001 | 1 | 2 |  | 1 |  |  |  |  |  |  |  | 1 | 5
D Total |  | 4 | 7 | 6 | 3 | 6 | 3 | 6 | 8 | 5 | 9 | 14 | 4 | 75
G | 2002 | 2 | 7 | 5 | 6 | 6 | 4 | 4 | 1 | 3 | 1 | 3 | 2 | 44
 | 2003 | 2 |  | 4 | 4 | 9 | 3 | 2 | 9 | 4 | 4 | 7 | 3 | 51
G Total |  | 4 | 7 | 9 | 10 | 15 | 7 | 6 | 10 | 7 | 5 | 10 | 5 | 95
M | 1998 | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
M Total |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
Grand Total |  | 9 | 14 | 15 | 13 | 21 | 10 | 12 | 18 | 12 | 14 | 24 | 9 | 171
Spreadsheet: 780158d1652318627-highest-number-of-sales-in-a-period-with-other-criteria-sales-ops-practice
Sheet: Promo Length

 |  | Promo Length (Months)
 |  | 1
Average Deal Size (SACV)
[NAME]
Expected Value
Expected Value per Month
Promo Months
Faster [NAME] (Actual) |  | 0
Sales Cycle Adjustment |  | 0.25 | 0.4 | 0.55 | 0.7 | 0.85 | 1
Faster [NAME] (Assumption)
Net Promo Months
Cost of Promo
Cost of Promo (% of Avg Deal)
Required Net Win Rate
Acceptance Rate |  | 0.6
Required Gross Win Rate
Current Gross Win Rate
Delta
Spreadsheet: 95118d1294789657-referencing-the-next-cell-in-an-array-that-is-not-a-particular-value-sample
Sheet: Sheet1

SAMPLE | Value 1 | Value 2 | Value 3
[NAME] | 100 | 200 | 300
[NAME] | 101 | 201 | 301
[NAME] | 102 | 202 | 302
100100 | 103 | 203 | 300
100101 | 104 | 204 | 301
100102 | 105 | 205 | 302
100103 | 106 | 206 | 306
100104 | 107 | 207 | 307
100105 | 108 | 208 | 308
100106 | 109 | 209 | 309
100107 | 110 | 210 | 310
100108 | 111 | 211 | 311
100109 | 112 | 212 | 312
[NAME] | 113 | 213 | 313
[NAME] | 114 | 214 | 314
 | 115 | 215 | 315
 | 116 | 216 | 316
 | 117 | 217 | 317
 | 118 | 218 | 318
 | 119 | 219 | 319
 | 120 | 220 | 320
 | 121 | 221 | 321
 | 122 | 222 | 322
 | 123 | 223 | 323
 | 124 | 224 | 324
[NAME] | 125 | 225 | 325
[NAME] | 126 | 226 | 326
 | 127 | 227 | 327
 | 128 | 228 | 328
 | 129 | 229 | 329
 | 130 | 230 | 330
 | 131 | 231 | 331
 | 132 | 232 | 332
 | 133 | 233 | 333
[NAME] | 134 | 234 | 334
[NAME] | 135 | 235 | 335
 | 136 | 236 | 336
100101 blue | 137 | 237 | 337
100127 red | 138 | 238 | 338
[NAME] | 139 | 239 | 339
[NAME] | 140 | 240 | 340
Spreadsheet: 730273d1619619853-a-lookup-table-that-varies-according-to-the-row-of-the-lookup-test332
Sheet: Sheet1

 | ProdRef | Group | width | height | TRUE HGHT | units sold | area |  |  |  |  | 21 | *LABELS PLAIN |  | Value in col E |  |  | I need a formula in Col F to give the value in the right row of Col E in ColP
 | 1 | 050 | 38 | 142 | 142 | 5000 |  |  |  |  |  | 050 | *Labels flexo |  | Value in col E
 | 2 | 050 | 143 | 143 | 143 | 10000 |  |  |  |  |  | 051 | *Labels digital |  | Value in col E |  |  | Something like INDEX(P:P,MATCH(C5,M:M,0))
 | 3 | 055 | 96 | 1000 | 300000 | 288 |  |  |  |  |  | 055 | BANDS |  | 300000 |  |  | But what can make it respond to the row  of the lookup call
 | 4 | 057 | 48 | 1000 | 200000 | 360 |  |  |  |  |  | 056 | TAPES |  | 66000
 | 5 | 050 | 220 | 236 | 236 | 15000 |  |  |  |  |  | 057 | GUMMED TAPES |  | 200000
 | 6 | 059 | 72 | 1000 | 200000 | 144 |  |  |  |  |  | 058 | continous rolls |  | Value in col E
 | 7 | 058 | 68 | 144 | 144 | 5000 |  |  |  |  |  | 059 | PRINTED GUM TAPES |  | 200000
 | 8 | 056 | 48 | 1000 | 66000 | 72 |  |  |  |  |  | 060 | [NAME] (sheet) |  | Value in col E
 | 9 | 056 | 48 | 1000 | 66000 | 1008
 | 10 | 057 | 72 | 1000 | 200000 | 360
 |  |  |  |  |  |  | The area in m2 by multiplying width x Height x units sold
 |  |  |  |  | True Height is either in col E or in the lookup table decided by value of Group
 |  |  |  | Height can be true height or 1000
Spreadsheet: 0ffbbf19-3513-43d9-b6f7-ba180395f4c9
Sheet: 3 | Exclusive

 |  | --> Return to first page
List of titles available only on SpringerReference
Library | Title Springerlink | Edition
Behavioral Science | Encyclopedia of Critical Psychology | 1
Behavioral Science | The Comprehensive Guide to Autism | 1
Biomedical and Life Sciences | Encyclopedia of Metagenomics | 1
Biomedical and Life Sciences | Encyclopedia of Metalloproteins | 1
Biomedical and Life Sciences | Encyclopedia of Systems Biology | 1
Biomedical and Life Sciences | Handbook of Global Environmental Pollution: Global Environmental Change | 1
Biomedical and Life Sciences | Wetlands Encyclopedia. Volume IV. World Wetlands | 1
Chemistry and Materials Science | Encyclopedia of Applied Electrochemistry | 1
Chemistry and Materials Science | Natural Compounds | 1
Chemistry and Materials Science | Natural Compounds | 1
Chemistry and Materials Science | Natural Compounds | 1
Chemistry and Materials Science | Polymer [NAME] | 2
Earth and Environmental Science | Encyclopedia of Earth Sciences Series: Remote Sensing | 1
Engineering | Handbook of Satellite Applications | 1
Humanities, Social Sciences and Law | Encyclopedia of Food and Agricultural Ethics | 1
Humanities, Social Sciences and Law | Encyclopedia of Global Archaeology | 1
Humanities, Social Sciences and Law | Encyclopedia of Indian Religions | 1
Humanities, Social Sciences and Law | Encyclopedia of Mathematics Education | 1
Humanities, Social Sciences and Law | Encyclopedia of Science Education | 1
Humanities, Social Sciences and Law | Handbook of the Philosophical Foundations of Business Ethics | 1
Mathematics and Statistics | Encyclopedia of Applied and Computational Mathematics | 1
Medicine | Abdominal Imaging | 1
Medicine | Encyclopedia of Ophthalmology | 1
Medicine | Handbook of Health Services Research | 1
Medicine | Nuclear Medicine | 1
Physics and Astronomy | Encyclopedia of Color Science and Technology | 1
Biomedical and Life Sciences | Encyclopedia of Pain | 2
--> Return to first page
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: United Utilities

UNITED UTILITIES | (Water)
MONTH | Year | Paymet
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009 | 14.5
2009-04-01 00:00:00 | 2009 | 21.06
2009-05-01 00:00:00 | 2009 | 21.06
2009-06-01 00:00:00 | 2009 | 21.13
2009-07-01 00:00:00 | 2009 | 18.57
2009-08-01 00:00:00 | 2009 | 18.5
2009-09-01 00:00:00 | 2009 | 18.5
2009-10-01 00:00:00 | 2009
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: ABU

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 55 | 00:01:43.461000 | 2 |  | 1 |  | 00:01:38.622000
2 | [NAME] |  |  | 18 | 55 | 00:01:43.914000 | 5 |  | 2 |  | 00:01:39.058000
3 | [NAME] |  |  | 15 | 55 | 00:01:43.154000 | 3 |  | 3 |  | 00:01:38.631000
4 | [NAME] |  |  | 12 | 55 | 00:01:42.612000 | 4 |  | 4 |  | 00:01:38.858000
5 | [NAME] |  |  | 10 | 55 | 00:01:44.288000 | 6 |  | 5 |  | 00:01:39.695000
6 | [NAME] |  |  | 8 | 55 | 00:01:43.993000 | 7 |  | 6 |  | 00:01:39.773000
7 | [NAME] |  |  | 6 | 55 | 00:01:44.916000 | 8 |  | 7 |  | 00:01:40.662000
8 | [NAME] |  |  | 4 | 55 | 00:01:44.709000 | 9 |  | 8 |  | 00:01:40.768000
9 | [NAME] |  |  | 2 | 55 | 00:01:44.120000 | 10 |  | 9 |  | 00:01:40.414000
10 | [NAME] |  |  | 1 | 54 | 00:01:43.521000 | 16 |  | 10 |  | 00:01:41.240000
11 | [NAME] |  |  | 0 | 54 | 00:01:44.566000 | 11 |  | 11 |  | 00:01:40.874000
12 | [NAME] |  |  | 0 | 54 | 00:01:44.438000 | 24 |  | 12
13 | [NAME] |  |  | 0 | 54 | 00:01:43.673000 | 12 |  | 13 |  | 00:01:40.919000
14 | Pastor Maldonado |  |  | 0 | 54 | 00:01:44.628000 | 23 |  | 14 |  | 00:01:41.760000
15 | [NAME] |  |  | 0 | 54 | 00:01:44.093000 | 15 |  | 15 |  | 00:01:41.162000
16 | [NAME] |  |  | 0 | 54 | 00:01:46.150000 | 14 |  | 16 |  | 00:01:41.079000
17 | [NAME] |  |  | 0 | 54 | 00:01:46.610000 | 17 |  | 17 |  | 00:01:42.979000
18 | Jarno [NAME] |  |  | 0 | 53 | 00:01:47.444000 | 18 |  | 18 |  | 00:01:43.884000
19 | [NAME] |  |  | 0 | 53 | 00:01:48.085000 | 19 |  | 19 |  | 00:01:44.515000
20 | [NAME] |  |  | 0 | 53 | 00:01:49.242000 | 22 |  | 20 |  | 00:01:45.159000
21 | [NAME] |  |  | - | 47 | 00:01:48.274000 | 20 |  | RET |  | 00:01:44.641000
22 | Sebastien Buemi |  |  | - | 18 | 00:01:47.094000 | 13 |  | RET |  | 00:01:41.009000
23 | [NAME] |  |  | - | 17 | 00:01:51.196000 | 21 |  | RET |  | 00:01:44.699000
24 | [NAME] |  |  | - | 1 |  | 1 |  | RET |  | 00:01:38.481000
Spreadsheet: 1c9707d8-5c1a-4f5c-aeb1-aecbe4f891b9
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
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
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
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2010-07-01 00:00:00 | 199 | Number | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: john_griffith__16096__1_18_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 54 | 300 | 400 | 42.1 | 56.1 | 1.67 | 2002-01-18 10:38:00
 | [NAME] | 56 | 670 | 770 | 46.7 | 53.7 | 1.77 | 2002-01-18 10:38:00
 | [NAME] | 63 | 1040 | 1070 | 49.1 | 50.5 | 1.97 | 2002-01-18 10:38:00
 | [NAME] | 64 | 1220 | 1260 | 46.9 | 48.5 | 1.92 | 2002-01-18 10:38:00
 | [NAME] | 64 | 1300 | 1400 | 43.4 | 46.7 | 1.81 | 2002-01-18 10:38:00
 | HU N2 | 64 | 1350 | 1450 | 41 | 44.1 | 1.71 | 2002-01-18 10:38:00
 | [NAME] | 63 | 1400 | 1500 | 39.7 | 42.6 | 1.63 | 2002-01-18 10:38:00
 | HU U2 | 61 | 1400 | 1500 | 38 | 40.8 | 1.51 | 2002-01-18 10:38:00
 | [NAME] | 58 | 1350 | 1450 | 36.4 | 39.1 | 1.38 | 2002-01-18 10:38:00
 | [NAME] |  |  |  | 34 | 37.8 | 1.31 | 2002-01-15 14:58:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 328169d1403802232-vlookup-with-rows-with-identical-numbers-formula-help-for-yes-1
Sheet: Inpect Semiannually

Loc # | MP # | MP Name | Inspect semi-annually
70 |  |  | Yes
81 |  |  | Yes
123 |  |  | Yes
125 |  |  | Yes
126 |  |  | Yes
128 |  |  | Yes
130 |  |  | Yes
131 |  |  | Yes
140 |  |  | Yes
142 |  |  | Yes
167 |  |  | Yes
175 |  |  | Yes
179 |  |  | Yes
181 |  |  | Yes
181 |  |  | Yes
184 |  |  | Yes
196 |  |  | Yes
196 |  |  | Yes
223 |  |  | Yes
228 |  |  | Yes
241 |  |  | Yes
258 |  |  | Yes
258 |  |  | Yes
259 |  |  | Yes
259 |  |  | Yes
292 |  |  | Yes
356 |  |  | Yes
419 |  |  | Yes
500 |  |  | Yes
505 |  |  | Yes
507 |  |  | Yes
508 |  |  | Yes
543 |  |  | Yes
798 |  |  | Yes
1024 |  |  | Yes
1044 |  |  | Yes
1078 |  |  | Yes
1120 |  |  | Yes
1130 |  |  | Yes
1153 |  |  | Yes
1174 |  |  | Yes
1202 |  |  | Yes
1278 |  |  | Yes
1384 |  |  | Yes
1385 |  |  | Yes
1444 |  |  | Yes
1466 |  |  | Yes
1473 |  |  | Yes
1482 |  |  | Yes
1590 |  |  | Yes
1655 |  |  | Yes
1658 |  |  | Yes
1677 |  |  | Yes
1707 |  |  | Yes
1710 |  |  | Yes
1712 |  |  | Yes
1713 |  |  | Yes
1714 |  |  | Yes
1715 |  |  | Yes
1716 |  |  | Yes
1716 |  |  | Yes
1721 |  |  | Yes
1727 |  |  | Yes
1763 |  |  | Yes
1770 |  |  | Yes
1789 |  |  | Yes
1809 |  |  | Yes
1810 |  |  | Yes
1813 |  |  | Yes
1821 |  |  | Yes
1830 |  |  | Yes
1854 |  |  | Yes
1857 |  |  | Yes
1860 |  |  | Yes
1861 |  |  | Yes
1875 |  |  | Yes
1879 |  |  | Yes
1880 |  |  | Yes
1901 |  |  | Yes
1914 |  |  | Yes
2012 |  |  | Yes
2021 |  |  | Yes
2022 |  |  | Yes
2184 |  |  | Yes
2233 |  |  | Yes
2233 |  |  | Yes
2233 |  |  | Yes
2398 |  |  | Yes
2419 |  |  | Yes
2420 |  |  | Yes
2420 |  |  | Yes
2421 |  |  | Yes
2421 |  |  | Yes
2423 |  |  | Yes
2427 |  |  | Yes
2432 |  |  | Yes
2435 |  |  | Yes
2570 |  |  | Yes
2687 |  |  | Yes
3354 |  |  | Yes
3357 |  |  | Yes
3398 |  |  | Yes
3759 |  |  | Yes
3808 |  |  | Yes
3809 |  |  | Yes
1590 |  |  | Yes
4171 |  |  | Yes
4245 |  |  | Yes
4328 |  |  | Yes
4387 |  |  | Yes
4441 |  |  | Yes
4594 |  |  | Yes
4659 |  |  | Yes
4660 |  |  | Yes
4668 |  |  | Yes
4698 |  |  | Yes
4717 |  |  | Yes
4769 |  |  | Yes
4770 |  |  | Yes
4897 |  |  | Yes
4917 |  |  | Yes
4917 |  |  | Yes
4918 |  |  | Yes
4957 |  |  | Yes
4965 |  |  | Yes
4966 |  |  | Yes
10103 |  |  | Yes
10104 |  |  | Yes
10105 |  |  | Yes
11501 |  |  | Yes
11507 |  |  | Yes
11508 |  |  | Yes
11509 |  |  | Yes
11595 |  |  | Yes
12503 |  |  | Yes
12506 |  |  | Yes
12515 |  |  | Yes
12529 |  |  | Yes
12548 |  |  | Yes
12550 |  |  | Yes
12586 |  |  | Yes
12611 |  |  | Yes
12862 |  |  | Yes
12920 |  |  | Yes
13405 |  |  | Yes
13637 |  |  | Yes
13828 |  |  | Yes
14088 |  |  | Yes
14553 |  |  | Yes
15253 |  |  | Yes
15260 |  |  | Yes
15701 |  |  | Yes
15705 |  |  | Yes
41000 |  |  | Yes
51501 |  |  | Yes
75401 |  |  | Yes
77698 |  |  | Yes
78100 |  |  | Yes
78100 |  |  | Yes
78401 |  |  | Yes
78601 |  |  | Yes
78602 |  |  | Yes
78900 |  |  | Yes
78900 |  |  | Yes
80601 |  |  | Yes
1787 |  |  | Yes
3345 |  |  | Yes
3711 |  |  | Yes
13460 |  |  | Yes
2150 |  |  | Yes
80230 |  |  | Yes
Spreadsheet: 264926d1379014187-dynamic-named-range-for-columns-moving-one-column-over-book1
Sheet: Sheet1

 | Feb | March |  |  |  |  | Quarter 1
Sales | 1 | 2 | 10 | 20 |  |  | X
Expense | 1 | 10 | 20 |  |  |  | X
Profit | 2 | 3 | 60 |  |  |  | X
Spreadsheet: 300500d1393494850-getting-list-of-numbers-from-value-of-2-cells-listing
Sheet: Sheet1

F1 | F15 |  |  | formula is yellow are array formula i.e. they need to be confirmed with control shift and enter
 |  |  |  | formula in column c needed to be dragged down till specified number in B1 or once it is dragged it is just a matter to change numbers in A1 and B1
 |  |  |  | these formula excepts letter in left and number in right I.e. [NAME]
 |  |  |  | but not 12355dsadasdasdasdasd
 |  |  |  | numbers in [NAME] should be less than numbers in B1
 |  |  |  | [NAME] is applied up to 9867th rows
Spreadsheet: 68072d1268644780-bonus-calculator-using-if-and-bonus-calculator
Sheet: Sheet1

 | Sales Target | Sales Achieved | Sales Conversion | Insurance 1 Target | Insurance 1 Sales | Insurance 1 Conversion | Insurance 2 Target | Insurance 2 Sales | Insurance 2 Conversion
 | 10 | 12 | 1.2 | 5 | 4 | 0.8 | 6 | 3 | 0.5
 | Bonus Band |  |  |  | Bonus Payable
 | 1 | 15 |  |  | 300
 | 1.1 | 20
 | 1.2 | 25
 | Insurance Target
 | Insurance 1 | 0.45
 | Insurance 2 | 0.5
 | * Bonus only payable (figures displayed) if D3 = 100%+, G3 = 45%+ and J3 = 50%+
Spreadsheet: 66045d1266679729-making-a-word-or-phrase-in-one-worksheet-do-a-function-on-a-different-worksheet-master
Sheet: Wed

Technican | ACCT# | Address | Zip | Install Date | Service call date | Days old | Reason for T/C | Resolution
Spreadsheet: phillip_m_love__30101__TRV Report & User List
Sheet: Sheet1

Region (category) | Report Name within Region | User First Name | User Last Name | User ID | [NAME] | View Rights | Publish Rights | Administrator
East Risk Region |  | Scott | [NAME] |  |  | Y
 |  | [NAME] | Jenkins |  |  | Y
 |  | [NAME] | Periera |  |  | Y
 |  | [NAME] | Ring |  |  | Y
 |  | Scott | Hendrickson |  |  | Y
 |  | [NAME] | Junek |  |  | Y
 |  | [NAME] | Germany |  |  | Y
 |  | [NAME] | Townsend |  |  | Y
 |  | [NAME] | Versen |  |  | Y
 |  | Vladi | Pimenov |  |  | Y
 |  | Kam | Keiser |  |  | Y | Y | Y
 |  | Scott | Palmer |  |  | Y | Y
 |  | Yuan | Tian |  |  | Y | Y
 |  | [NAME] | [NAME] |  |  | Y | Y
 |  | [NAME] | Royed |  |  | Y | Y
 |  | [NAME] | Lilly |  |  | Y | Y
 |  | Kulvinder | Fowler |  |  | Y | Y
 |  | Kimat | Singla |  |  | Y | Y
 |  | Luchas | [NAME] |  |  | Y | Y
West Risk Region |  | [NAME] | [NAME] |  |  | Y
 |  | [NAME] | [NAME] |  |  | Y
 |  | Monique | Sanchez |  |  | Y
 |  | [NAME] | Lenhart |  |  | Y
 |  | [NAME] | Scott |  |  | Y
 |  | [NAME] | Gay |  |  | Y
 |  | [NAME] | Tholt |  |  | Y
 |  | [NAME] | Ermis |  |  | Y
 |  | [NAME] | Reitmeyer |  |  | Y
 |  | [NAME] | Holst |  |  | Y
 |  | Tori | Kuykendall |  |  | Y
 |  | [NAME] | South |  |  | Y
 |  | [NAME] | Giron |  |  | Y | Y | Y
 |  | Anne | Bike |  |  | Y | Y
 |  | Carol | [NAME] |  |  | Y | Y
 |  | [NAME] | Ryder |  |  | Y | Y
 |  | [NAME] | O'Rourke |  |  | Y | Y
 |  | [NAME] "[NAME]" | Shim |  |  | Y | Y
 |  | Kristen | Klause |  |  | Y | Y
Central Risk Region | O:erms/1intra/central/CEP&L | Geoff | [NAME] | [NAME] | [EMAIL] | Y
 | O:erms/1intra/central/CEPositions | Martin | Cuilla | [NAME] | [EMAIL] | Y
 |  | [NAME] | Ruscitti | kruscit | [EMAIL] | Y
 |  | Patrice | Thurston | pmims | [EMAIL] | Y
 |  | [NAME] | [NAME] | jwillia | [EMAIL] | Y
 |  | [NAME] | Donohoe | tdonoho | [EMAIL] | Y
 |  | [NAME] | [NAME] | jparks | [EMAIL] | Y
 |  | Kelly | [NAME] | [NAME] | [EMAIL] | Y
 |  | [NAME] | Shively | hshivel | [EMAIL] | Y
 |  | [NAME] | [NAME] |  |  | Y
 |  | [NAME] | Lewis | alewis | [EMAIL] | Y
 |  | [NAME] | Ryder | pryder | [EMAIL] | Y | Y
 |  | Anna | [NAME] | skulic | [EMAIL] | Y | Y
 |  | Souad | Mahmassani | smahmass | [EMAIL] | Y | Y
 |  | [NAME] | Ames | cames | [EMAIL] | Y | Y
 |  | [NAME] | Mills | bmills | [EMAIL] | Y | Y
 |  | [NAME] | Love | plove | [EMAIL] | Y | Y | Y
 |  | Binh | [NAME] | bpham2 | [EMAIL] | Y | Y
Texas Risk Region |  | [NAME] | Martin |  |  | Y
 |  | [NAME] | Schwieger |  |  | Y
 |  | [NAME] | [NAME] |  |  | Y
 |  | [NAME] | [NAME] |  |  | Y | Y | Y
 |  | O'Neal | Winfree |  |  | Y | Y
 |  | Chance | Rabon |  |  | Y | Y
Financial Risk Region |  | [NAME] | [NAME] |  |  | Y
 |  | [NAME] | Maggi |  |  | Y
 |  | [NAME] | May |  |  | Y
 |  | [NAME] | Griffith |  |  | Y
 |  | Dutch | Quigley |  |  | Y
 |  | [NAME] | [NAME] |  |  | Y | Y
 |  | Bilal | Bajwa |  |  | Y | Y
 |  | Errol | McLaughlin |  |  | Y | Y | Y
All Regions | All Reports across All Regions | [NAME] | [NAME] |  |  | Y | Y | Y