tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6407323c-d70f-47f2-9995-ccde84399491
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | 成长型企业老板要掌握的十门学问
 |  | 2012中小企业商业模式洞察力及世界级企业的营销品牌竞争力
 |  | 【报名详情】
 |  | 【培训时间】2012年8月25-26日上海
 |  | 【承办单位】企 业 学 习 网
 |  | 【培训对象】董事长、总经理等高层领导
 |  | 【培训费用】单次课程6800元/人（可获《郎咸平说·移动商学院》礼品一份）；《十门学问》整
 |  | 套系列课程36800元/人（含25日晚的极智会沙龙、《郎咸平说·移动商学院》、郎咸
 |  | 平签名书籍等大礼包）
 |  | 【北京－市场部】　０１０-５１６６８１２５
 |  | 【深圳－市场部】０７５５-６１２８８９０７
 |  | 【上海－市场部】　０２１-３１２６１５８０
 |  | 【课程前言】
 |  | [NAME]
 |  | 欧债危机，金融风暴，产业转型……您的企业还有戏吗？中小企业成长过程中，避不可免的总
 |  | 遇到瓶颈。各种危机来势凶猛，危机重重，需求的下降，原材料、人工和各种成本的上升，洋品牌
 |  | 纵横天下，直击本土品牌的架势，企业利润率跌至谷底；中央银行屡屡收缩银根，中小企业资金链
 |  | 断裂事件群起发生。外部险象环生，内部种种掣肘，企业要如何才能生存，实现永续经营？
 |  | 中国企业要摆脱困境，只会控制成本是死路，要懂得从“价格竞争”转变为“附加值供应商”，
 |  | 变革商业模式，是企业转型升级必经之路。
 |  | 为什么要选择《成长型企业老板要掌握的十门学问》高端课程?
 |  | 中小型企业在成长过程中遇到的五大瓶颈
 |  | 长不大---商业模式缺陷      养不肥---战略定位缺陷
 |  | [NAME]人才梯队缺陷      搞不定---制度执行缺陷
 |  | 放不开---企业家修养缺陷
 |  | 五大缺陷十门学问一一为您破解，帮助您突破瓶颈，跨越台阶！
 |  | 《成长型企业老板要掌握的十门学问》高端课程倾力为您解读！
 |  | 【导师简介】
 |  | 郎咸平  著名经济学家
 |  | 美国宾西法尼亚大学沃顿商学院金融学博士；
 |  | 他曾在07年率先断言“中国的八大危机”引起社会轰动；他提出的“二元经济理论”，抛出中
 |  | 国制造业的全面衰退造成股市泡沫、楼市泡沫的观点再次引起话题； 随后提出“6+1”理论以及如
 |  | 何建立工序流程系统为中国企业如何走出困境指明了方向
 |  | 陆亦琦   战略品牌营销专家
 |  | 美国范德比尔特大学博士；美国西北大学凯洛格管理学院工商管理硕士，师从菲利普·科特勒；
 |  | 毕业后常年在500强企业的全球总部与区域市场部任职，曾任：德国巴斯福化工集团北美市场战略经
 |  | 理、美国惠氏集团欧洲市场总监与全球市场总监、瑞士诺华集团亚太区首席市场官等职务:《解码财
 |  | 商》等媒体节目的主持嘉宾。
 |  | 【课程安排】
 |  | 8月25日   《中小企业商业模式洞察力》 郎咸平主讲
 |  | [NAME]。
 |  | 如何才能改变这种被动的局面？一是看清和把握行业的本质，二是善于在危机中寻找转机，变劣势
 |  | 为优势，探寻成长型企业的商业模式变化。在面对自由经济的冲击、国际化的冲击、高风险的冲击
 |  | 的时候我们又该如何处理？
 |  | 8月26日   《世界级企业的营销品牌竞争力》 陆亦琦主讲
 |  | 陆博士曾准确的预断出“柯达”的破产；曾在李书福收购沃尔沃期间坚定的表明要将沃尔沃“
 |  | 还给”瑞典人；多次在媒体中阐述自己对品牌营销独有的见解，从可口可乐百年之战的分析到小米
 |  | 手机的发展未来的箴言，都让受众者触及到了不一样的品牌营销思路。在面对很多企业把“品牌”
 |  | 与“广告”划上了等号。国人自信的缺乏又导致“进口货”与“品牌”划上了等号，使得中国企业
 |  | 的品牌营销陷入僵局，我们要如何打破这种格局，建立自己的品牌，赢得市场与消费者的心？
Spreadsheet: 700708d1603297791-if-formula-problems-parts-request-aging-master-base-year-1012020lkf
Sheet: Parts Back-up

PR# | DATE PR RECEIVED | DATE PART ORDERED | DATE PART RECEIVED | VENDOR | [NAME] | QUANTITY | PRIORITY | [NAME] | NOTES
753589752 | 2020-10-01 00:00:00 | 2020-10-09 00:00:00 |  | Commercial Filtration supply | Eaton model 72 HVAC electrical SOW |  |  |  | HVAC Sow
753607610 | 2020-10-01 00:00:00 | 2020-10-08 00:00:00 |  | Sisco | Bray series valves, HVAC electrical SOW |  |  |  | HVAC Sow
753622203 | 2020-10-01 00:00:00 | 2020-10-09 00:00:00 |  | Atlantec | Garlock parts, HVAC electrical SOW |  |  |  | HVAC Sow
753684221 | 2020-10-01 00:00:00 | 2020-10-08 00:00:00 |  | Rolled Alloys | Plate, HVAC electrical SOW |  |  |  | HVAC Sow
631265740 | 2020-10-01 00:00:00 |  |  |  | Rebuild parts for port diesel engine | Multiple | [NAME]
768033644 | 2020-10-01 00:00:00 | 2020-10-08 00:00:00 |  | Metals Depot | 2'x2'x1/4" thick plate, A36 steel, ASTM A 36 |  | [NAME] |  | HVAC Sow
773543584 | 2020-10-02 00:00:00 | 2020-10-07 00:00:00 |  | Knot & Rope | Line for shore power | 1 | [NAME]
776232890 | 2020-10-05 00:00:00 | 2020-10-15 00:00:00 |  | [NAME] | Car 35 boat release hook inspection/Exchange | 1 | [NAME]
779827587 | 2020-10-06 00:00:00 | 2020-10-09 00:00:00 | 2020-10-13 00:00:00 | Amazon | Foil Tape | 20 | Spares/Inventory |  | Cleared
780069598 | 2020-10-06 00:00:00 | 2020-10-13 00:00:00 | 2020-10-19 00:00:00 | Amazon | HDMI Cable male to male 6' long | 2 | [NAME] |  | Cleared
780507942 | 2020-10-06 00:00:00 | 2020-10-07 00:00:00 | 2020-10-07 00:00:00 | Sams | Food for storm Delta Not to exceed 1,890.00 | 1 | Urgent/Mission Critical |  | Cleared
781728752 | 2020-10-06 00:00:00 | 2020-10-09 00:00:00 | 2020-10-13 00:00:00 | Newegg | Uninterruptible power supply | 1 | [NAME] |  | Cleared
781907943 | 2020-10-07 00:00:00 | 2020-10-13 00:00:00 | 2020-10-15 00:00:00 | [NAME] | Air intake Sensor | 4 | [NAME] |  | Cleared
782549359 | 2020-10-07 00:00:00 | 2020-10-13 00:00:00 | 2020-10-14 00:00:00 | [NAME] | Taps, drill bit screws | 1 | [NAME] |  | Cleared
783980438 | 2020-10-07 00:00:00 | 2020-10-07 00:00:00 | 2020-10-07 00:00:00 | [NAME] | 404A Refrigerant | 1 | [NAME] |  | Cleared
794298099 | 2020-10-20 00:00:00 |  |  |  | HVAC fan belt | 10 | Spares/Inventory
796219034 | 2020-10-20 00:00:00 |  |  |  | Paper towels and hand sanitizer | 1 | [NAME]
782534863 | 2020-10-20 00:00:00 |  |  |  | Eye wash station refill 16 oz bottles | 28 | [NAME]
805143443 | 2020-10-20 00:00:00 |  |  |  | Bearings for GT fuel skid | 6 | Urgent/Mission Critical
Spreadsheet: 68739d1269305475-variable-list-from-another-sheet-cmj
Sheet: Sheet1

Original Wheel
Rim Width (in) | 7
Rim Offset (mm) | 45
New Wheel |  |  | Comparison
Rim Width (in) | 9.5 |  | [NAME] (mm) | 1.25 | [NAME] to [NAME]
Rim Offset (mm) | 12 |  | [NAME] (mm) | -64.75 | [NAME] to Fender
Tire Calculations |  |  | Tire Measurements
[NAME] ([NAME]) | 225 |  | Sidewall Height (mm) | 101.25
Aspect Ratio (%) | 45 |  | Tire Diameter (in) | 24.97244094488189
Rim Diameter (in) | 17
185 40 19
185 40 19
185 45 18
185 50 18
185 55 17
185 60 16
195 40 19
195 45 18
195 50 17
195 55 17
195 60 16
205 35 19
205 40 19
205 45 18
205 50 17
205 55 16
205 60 15
215 35 19
215 40 18
215 45 17
215 50 17
215 55 16
215 60 15
225 35 19
225 40 18
225 45 17
225 50 16
225 55 15
235 30 19
235 35 18
235 40 18
235 45 17
235 50 16
235 55 15
245 30 19
245 35 18
245 40 17
245 45 16
245 50 15
255 30 19
255 35 18
255 40 17
255 45 16
255 50 15
265 30 19
265 35 18
265 40 17
265 45 16
265 50 15
275 30 18
275 35 17
275 40 16
275 45 15
Spreadsheet: 826842d1682326277-combine-two-dynamic-dates-test
Sheet: Tabelle1

 |  | wanted outcome | wanted outcome | wanted outcome |  | my tries
Date | 2023-05-05 00:00:00
 |  | 01.06.2023 - 31.05.2024 | 01.06.2024 - 31.05.2025 | 01.06.2025 - 31.05.2026
Spreadsheet: 3e6fca2d-1d8d-4712-ab2c-3f7b81dc8cbd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FLUOX | Test | FLUOX | Fluoxetine, Serum | Fluoxetine, S | High-Turbulence Liquid Chromatography Mass Spectrometry (HTLC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top  [NAME]: 1 mL Collection Instructions: Spin down and separate serum from cells within 2 hours of draw. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Fluoxetine + norfluoxetine: 120-300 ng/mL | Wednesday | 2 days | 9 days | 1 | 80299 |  |  |  |  | Rochester
FLUOX | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FLUOX | Result | 80228 | Fluoxetine, S | Fluoxetine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3644-2
FLUOX | Result | 251 | Norfluoxetine, S | Norfluoxetine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3868-7
FLUOX | Result | 252 | Fluoxetine+Norfluoxetine | Fluoxetine+Norfluoxetine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10339-0
Spreadsheet: 110141d1306905281-running-calculations-by-date-example-1
Sheet: outstanding

Date | Outstanding
2011-05-01 00:00:00 | 13
2011-05-01 00:00:00 | 13
2011-05-02 00:00:00 | 14
2011-05-02 00:00:00 | 14
2011-05-03 00:00:00 | 15
2011-05-03 00:00:00 | 15
2011-05-04 00:00:00 | 16
2011-05-04 00:00:00 | 16
2011-05-05 00:00:00 | 17
2011-05-05 00:00:00 | 17
2011-05-06 00:00:00 | 13
2011-05-06 00:00:00 | 13
2011-05-07 00:00:00 | 14
2011-05-07 00:00:00 | 14
2011-05-08 00:00:00 | 15
2011-05-08 00:00:00 | 15
2011-05-09 00:00:00 | 16
2011-05-09 00:00:00 | 16
2011-05-10 00:00:00 | 17
2011-05-10 00:00:00 | 17
2011-05-11 00:00:00 | 13
2011-05-11 00:00:00 | 13
2011-05-12 00:00:00 | 14
2011-05-12 00:00:00 | 14
2011-05-13 00:00:00 | 15
2011-05-13 00:00:00 | 15
2011-05-14 00:00:00 | 16
2011-05-14 00:00:00 | 16
2011-05-15 00:00:00 | 17
2011-05-15 00:00:00 | 17
2011-05-16 00:00:00 | 13
2011-05-16 00:00:00 | 13
2011-05-17 00:00:00 | 14
2011-05-17 00:00:00 | 14
2011-05-18 00:00:00 | 15
2011-05-18 00:00:00 | 15
2011-05-19 00:00:00 | 16
2011-05-19 00:00:00 | 16
2011-05-20 00:00:00 | 17
2011-05-20 00:00:00 | 17
2011-05-21 00:00:00 | 13
2011-05-21 00:00:00 | 13
2011-05-22 00:00:00 | 14
2011-05-22 00:00:00 | 14
2011-05-23 00:00:00 | 15
2011-05-23 00:00:00 | 15
2011-05-24 00:00:00 | 16
2011-05-24 00:00:00 | 16
2011-05-25 00:00:00 | 17
2011-05-25 00:00:00 | 17
2011-05-26 00:00:00
2011-05-27 00:00:00
2011-05-28 00:00:00
2011-05-29 00:00:00
2011-05-30 00:00:00
2011-05-31 00:00:00
Spreadsheet: 683642d1592861178-formula-that-returns-a-value-under-specific-conditions-region-issuev2
Sheet: Sheet1

Entered Account # | Entered Date | Region (as returned from formula) |  |  |  |  | [NAME] that Returns a Value under Specific Conditions
ABC | 2018-02-01 00:00:00 |  |  |  |  |  | My problem is as below: I have some data that was dumped from a database and I need to return the "Region" from that data (for the "Entered Account #" and "Entered Date") under the following conditions: - IF "Void?" = "Y", THEN STOP, no need to look further.  But if record NOT voided, then: 1.  IF "Span Duration is = 365 or 366 and  2.  "Entered Date" is >= the "From Date" and  3.  "Entered Date" is <= the "To Date"THEN return "Region" from the "matched" row.  BUT only perform steps 1-3 when the "Entered Account #" is = the "Account #" from the Database Data.  Need to check all the date spans within that "Account #". That's Part 1. Part 2 is:  IF "Void?" is <> "Y" and "Span Duration" is < 365, THEN use the "Region" from the next row in the database data but ONLY if that next row is for the same "Account #"   I tried using all kinds of combinations of INDIRECT, ADDRESS, CELL, COLUMN, ROW, iNDEX and am not having any luck.   I can't use a macro for this and was wondering if it is able to be done with a formula. I'm probably/definitely biting off more than I can chew :) but any help you can provide will be hugely appreciated.  Thanks!
ABC | 2020-03-01 00:00:00
ABC | 2020-02-01 00:00:00 | Voided Record
DEF | 2018-06-30 00:00:00
ABC | 2019-02-01 00:00:00
DEF | 2019-02-01 00:00:00 | Voided Record
DEF | 2017-01-01 00:00:00
DEF | 2019-02-01 00:00:00
Database Data
Account # | Void? | Span Duration (Days) | From Date | To Date | Region
ABC | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Boston
ABC | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | New York
ABC | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Sacramento
ABC | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Tulsa
DEF | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Wichita
DEF | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | Sarasota
DEF | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Reno
DEF | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Denver
Spreadsheet: 692149d1598120962-calculate-next-payment-date-problem-datum
Sheet: Sheet1

Today | Next Billing Date |  |  |  | Holidays
2020-08-23 00:00:00 |  |  |  |  | 2020-08-31 00:00:00
2020-08-24 00:00:00
2020-08-25 00:00:00
2020-08-26 00:00:00
2020-08-27 00:00:00
2020-08-28 00:00:00
2020-08-29 00:00:00
2020-08-30 00:00:00
2020-08-31 00:00:00
2020-09-01 00:00:00
2020-09-02 00:00:00
2020-09-03 00:00:00
Spreadsheet: 874635d1721202603-how-to-autofill-rules-for-a-set-of-data-for-one-column-to-another-column-of-different-data-sierraloco89-savings-calculation-cf-aligw
Sheet: Sheet1

 |  | 5000 | -
 |  | 6500 | -
 |  | 25000 | -
 |  | - | 35000
 |  | - | 55000
 |  | - | 15000
 |  | 28000 | 28000
 | Total
 | Check 1 | 25000 | 25000
 | Check 2 | 35000 | 35000
 | Check 3 | 45000 | 45000
 | I set a condition for C19, that when C20:22 are added, and are less than or equal to C19 it would turn green, and if it was greater than it would turn red. I attempted to auto fill that over to Column D, E, F.. But it simply fills it for Column C still. Not sure how to get it to autofill to the following specific column and that columns data
Spreadsheet: 118446d1313694433-product-numbers-and-dist-channels-book1
Sheet: Sheet1

100 | 10
200 | 10
300 | 10
400 | 10
500 | 10
100 | 20
600 | 10
700 | 10
200 | 20
800 | 10
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: JUN

DATES: | DAY: | BOARD  £: | PAID (Y or N) | REASON FOR UNPAID? | DATE of UNPAID to be PAID? | NOW PAID  (Y or N) | UNPAID totals
1st | FRI |  |  |  |  |  | 0
2nd | SAT |  |  |  |  |  | 0
3rd | SUN |  |  |  |  |  | 0
4th | MON |  |  |  |  |  | 0
5th | TUE |  |  |  |  |  | 0
6th | WED |  |  |  |  |  | 0
7th | THU |  |  |  |  |  | 0
8th | FRI |  |  |  |  |  | 0
9th | SAT |  |  |  |  |  | 0
10th | SUN |  |  |  |  |  | 0
11th | MON |  |  |  |  |  | 0
12th | TUE |  |  |  |  |  | 0
13th | WED |  |  |  |  |  | 0
14th | THU |  |  |  |  |  | 0
15th | FRI |  |  |  |  |  | 0
16th | SAT |  |  |  |  |  | 0
17th | SUN |  |  |  |  |  | 0
18th | MON |  |  |  |  |  | 0
19th | TUE |  |  |  |  |  | 0
20th | WED |  |  |  |  |  | 0
21st | THU |  |  |  |  |  | 0
22nd | FRI |  |  |  |  |  | 0
23rd | SAT |  |  |  |  |  | 0
24th | SUN |  |  |  |  |  | 0
25th | MON |  |  | Wk finishs start of next month | 2012-07-01 00:00:00 |  | 0
26th | TUE |  |  |  |  |  | 0
27th | WED |  |  |  |  |  | 0
28th | THU |  |  |  |  |  | 0
29th | FRI |  |  |  |  |  | 0
30th | SAT |  |  |  |  |  | 0
TOTAL of PAID |  | 0
TOTAL of UNPAID |  | 0
 |  |  |  | #N/A
Spreadsheet: 151634d1335030425-need-help-with-formula-for-calculating-fees-based-on-product-selected-from-list-fees
Sheet: Products

Product | Version
Core CAL | Non-specific
Desktop Optimization Pack for SA | Non-specific
Enterprise CAL | Non-specific
Enterprise Desktop | Non-specific
Enterprise Desktop w MDOP | Non-specific
Office Professional | Non-specific
Office Professional Plus | Non-specific
Professional Desktop | Non-specific
Professional Desktop w MDOP | Non-specific
Win | Non-specific
[NAME] | Non-specific
Spreadsheet: 1651b6e7-8cb8-4eee-b65c-eb682a637bae
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Regnskapstjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Mazars [NAME] | Bogstadv. 27B | 0355 | Oslo | 23 19 63 00 | 23 19 63 01
[NAME] | Bogstadv. 30 | 0355 | Oslo | 22 20 04 00 | 22 20 04 10
Øko-Rom AS |  | 2013 | [NAME] | 63 84 41 50 | 63 84 54 80
[NAME] | Kongsv. 91 | 1177 | Oslo | 22 47 76 70 | 22 42 09 52
Råd & Regnskap Akershus AS | Holmav. 20 | 1339 | Vøyenenga | 21 62 70 00 | 850 29 500
[NAME] | Rådhusg. 23B | 0158 | Oslo | 22 47 76 70 | 22 42 09 52
Abaci AS | Grini Næringspark 1 | 1361 | Østerås | 67 14 10 30 | 67 14 32 33
NetLedger AS | Østensjøv. 39/41 | 0667 | Oslo | 06731 | 63 82 69 50
Aurskog Regnskapskontor AS | [NAME] | 1930 | [NAME] | 63 85 38 50
Pedersen & Skogholt AS | Idrettsv. 9 | 1400 | Ski | 64 85 15 00
Rakkestad Regnskapslag SA | Storg. 2 | 1890 | Rakkestad | 69 22 60 90 | 69 22 60 98
Tet Gruppen AS | Rjukan Næringspark | 3660 | Rjukan | 35 08 16 00
Vardens Revisjonskontor AS | Skipperg. 33 | 0154 | Oslo | 24 14 12 00 | 22 42 67 72
Østlandske Regnskapskontor AS | [NAME]. 21 | 3300 | Hokksund | 32 75 52 00 | 32 75 49 18
[NAME] | Banev. 32B | 3612 | Kongsberg | 32 77 14 20
[NAME] | Ant H Mysens g 13 | 1850 | Mysen | 69 84 60 90 | 69 84 60 99
[NAME] AS | Rådyrv. 2A | 3370 | Vikersund | 32 78 86 03 | 32 78 89 40
Erøy Regnskap AS | Idrettsv. 9 | 1400 | Ski | 64 91 14 00 | 64 87 57 01
Tet | Kjørbekkdalen 9A | 3735 | Skien | 35 50 85 50 | 35 50 85 60
Sjølyst Regnskap ANS | Drammensv. 126A | 0277 | Oslo | 22 55 59 78 | 22 55 66 96
Regnskapsførerene i Grenland AS | Sverres g 6B | 3916 | Porsgrunn | 993 81 122 | 35 56 06 81
Tune Regnskaps Consult AS | St. Marie g 52 | 1706 | Sarpsborg | 69 14 83 30 | 69 14 83 31
Steen & Jensen Økonomi AS | [NAME] 59 | 3036 | Drammen | 32 88 90 10
TomCon AS | [NAME]. 15 | 3117 | [NAME] | 33 00 48 80 | 33 31 02 77
Økonomihuset Tønsberg AS | [NAME]. 1 | 3117 | [NAME] | 33 00 37 37 | 33 00 37 38
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-26

Wednesday
Deal #s | 789439 |  | 789464 | 789472 | 789475 | 789490
2001-09-26 00:00:00 |  |  | NP | NP | SP | PV
Delivery Pt. | EPMI CA Pool |  | EES | [NAME] | EES | STSW
Counterparty | NP | SP | Sale | CA Imbal | Sale | CISO_EPMI_5000
Totals | -2064 | 2064 | -3640 | 800 | -2264 | -400
1 | -126 | 126 | -223 |  | -115
2 | -126 | 126 | -223 |  | -115
3 | -126 | 126 | -223 |  | -115
4 | -126 | 126 | -223 |  | -115
5 | -126 | 126 | -223 |  | -115
6 | -126 | 126 | -223 |  | -115
7 | -66 | 66 | -116 | 50 | -84 | -25
8 | -66 | 66 | -116 | 50 | -84 | -25
9 | -66 | 66 | -116 | 50 | -84 | -25
10 | -66 | 66 | -116 | 50 | -84 | -25
11 | -66 | 66 | -116 | 50 | -84 | -25
12 | -66 | 66 | -116 | 50 | -84 | -25
13 | -66 | 66 | -116 | 50 | -84 | -25
14 | -66 | 66 | -116 | 50 | -84 | -25
15 | -66 | 66 | -116 | 50 | -84 | -25
16 | -66 | 66 | -116 | 50 | -84 | -25
17 | -66 | 66 | -116 | 50 | -84 | -25
18 | -66 | 66 | -116 | 50 | -84 | -25
19 | -66 | 66 | -116 | 50 | -84 | -25
20 | -66 | 66 | -116 | 50 | -84 | -25
21 | -66 | 66 | -116 | 50 | -84 | -25
22 | -66 | 66 | -116 | 50 | -84 | -25
23 | -126 | 126 | -223 |  | -115
24 | -126 | 126 | -223 |  | -115
TIE POINTS
Spreadsheet: 797661d1664028506-generate-list-from-a-list-to-smallest-number-to-largest-number-formula-test-1-
Sheet: Sheet1

Product Name | % | Size | Litres | Qty | Base |  |  |  |  |  |  | Base Available | 1000 |  | Product Name | % | Size | Litres | Qty | Base
1 | 0.22 | 0.5 | 100 | 200 | 44 |  |  |  |  |  |  |  |  |  | 8 | 0.22 | 0.2 | 21.8 | 109 | 24
2 | 0.25 | 0.2 | 80 | 400 | 100 |  |  |  |  |  |  |  |  |  | 1 | 0.22 | 0.5 | 100 | 200 | 44
3 | 0.25 | 0.35 | 245 | 700 | 175 |  |  |  |  |  |  |  |  |  | 5 | 0.4 | 0.7 | 87.5 | 125 | 50
4 | 0.4 | 0.5 | 400 | 800 | 320 |  |  |  |  |  |  |  |  |  | 2 | 0.25 | 0.2 | 80 | 400 | 100
5 | 0.4 | 0.7 | 87.5 | 125 | 50 |  |  |  |  |  |  |  |  |  | 6 | 0.42 | 0.5 | 125 | 250 | 105
6 | 0.42 | 0.5 | 125 | 250 | 105 |  |  |  |  |  |  |  |  |  | 10 | 0.42 | 0.5 | 160 | 320 | 135
7 | 0.57 | 0.7 | 315 | 450 | 257 |  |  |  |  |  |  |  |  |  | 3 | 0.25 | 0.35 | 245 | 700 | 175
8 | 0.22 | 0.2 | 21.8 | 109 | 24 |  |  |  |  |  |  |  |  |  | 9 | 0.25 | 0.35 | 345.45 | 987 | 247
9 | 0.25 | 0.35 | 345.45 | 987 | 247
10 | 0.42 | 0.5 | 160 | 320 | 135
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colum U should equal or closest to Cell N1
Spreadsheet: 814459d1674409602-copy-project-data-to-respective-tabs-excel-example
Sheet: B

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5
B | 4889 | 5698 | 5301 | 4380 | 9062
B | 2970 | 8025 | 6926 | 771 | 8977
B | 9828 | 3140 | 9537 | 6618 | 9578
B | 2330 | 6398 | 5892 | 5444 | 8525
B | 324 | 7746 | 8531 | 9589 | 2768
Spreadsheet: 288691d1389282167-removing-spaces-from-data-testbook1
Sheet: Sheet1

PART | PRICE |  | qty |  | total price
R0099821 | 6093.35 |  | 3
296337 | 195.99 |  | 8
88-21040 | 7066.00 |  | 5
1917580 | 142.25 |  | 23
Spreadsheet: a64f9429-09f6-4bbe-b2fe-f3ddd76228cc
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 80688751548 | Various | Brown Live Love Give Ladies Small | 2008-02-26 | T-Shirt | Na | 14.99 | N | Available
Merch | 80688751746 | Various | Brown Live Love Give Ladies Large | 2008-02-26 | T-Shirt | Na | 14.99 | N | Available
Merch | 80688769079 | Various | [NAME] | 2008-05-20 | T-Shirt | Country | 14.99 | N | Available
Merch | 80688769055 | Various | [NAME] | 2008-05-20 | T-Shirt | Country | 14.99 | N | Available
Merch | 80688751647 | Various | Brown Live Love Give Ladies Medium | 2008-02-26 | T-Shirt | Na | 14.99 | N | Available
Merch | 80688751845 | Various | Brown Live Love Give Ladies Xlarge | 2008-02-26 | T-Shirt | Na | 14.99 | N | Available
Merch | 80688751944 | Various | Brown Live Love Give Ladies Xxlarge | 2008-02-26 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143015792 | Needtobreathe | Unisex Band [NAME] | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015808 | Needtobreathe | Unisex Band Logo Size Medium | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015815 | Needtobreathe | Unisex Band [NAME] Large | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015822 | Needtobreathe | Unisex Band [NAME] Xlarge | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052230 | Switchfoot | [NAME] | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052247 | Switchfoot | [NAME] [NAME]-West Ladies Medium | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052254 | Switchfoot | [NAME] [NAME]-West Ladies Large | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052261 | Switchfoot | [NAME] [NAME]-West Ladies Xlarge | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052216 | Switchfoot | [NAME] Medium | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052223 | Switchfoot | [NAME] Large | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143049247 | Skillet | Black Skillet 'Rise' Unisex Adult Medium | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049254 | Skillet | Black Skillet 'Rise' Unisex Adult Large | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049261 | Skillet | Black Skillet 'Rise'  Unisex Adult Xlarge | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049353 | Skillet | White Skillet 'Rise' Womens Adult Small | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049360 | Skillet | Black Skillet 'Rise' Unisex Adult Small | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049223 | Skillet | White Skillet 'Rise' Womens Adult Large | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049216 | Skillet | White Skillet 'Rise' Womens Adult Medium | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049230 | Skillet | White Skillet 'Rise' Womens [NAME] | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Spreadsheet: 782663d1654176187-index-and-match-formula-error-to-find-and-rank-high-to-low-value-top-to-lower-number
Sheet: Chart

 |  |  |  |  |  |  |  |  | IF(D7=0,"",(INDEX($C$7:$C$20,MATCH(LARGE($D$7:$D$20,ROWS($J$7:$J7)),$D$7:$D$20,0))))
 | S/N | Description | Mar-22 | Position | Apr-22 | May-22 |  | Poistion | Mar-22 | Mar-22 Expected Result | Apr-22 | May-22 |  |  | Month | Exc Do Not Count
 | 1 | Apple | 86 | 1 | 36 | 61 |  |  |  | Apple
 | 2 | [NAME] | 34 | 6 | 8 | 17 |  |  |  | [NAME]
 | 3 | Car | 32 | 8 | 9 | 11 |  |  |  | Fish
 | 4 | Door | 30 | 9 | 18 | 8 |  |  |  | Kite
 | 5 | Electric | 33 | 7 | 13 | 8 |  |  |  | [NAME]
 | 6 | Fish | 52 | 3 | 13 | 14 |  |  |  | North
 | 7 | Golf | 8 | 13 | 6 | 7 |  |  |  | [NAME]
 | 8 | Hat | 19 | 11 | 15 | 19 |  |  |  | Electric
 | 9 | Ice | 10 | 12 | 6 | 10 |  |  |  | Car
 | 10 | [NAME] | 35 | 5 | 13 | 12 |  |  |  | Door
 | 11 | Kite | 51 | 4 | 48 | 14 |  |  |  | Let
 | 12 | Let | 22 | 10 | 5 | 2 |  |  |  | Hat
 | 13 | [NAME] | 55 | 2 | 1 | 3 |  |  |  | Ice
 | 14 | North | 35 | 5 | 5 | 10 |  |  |  | Golf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Excl Do Not Count | A+C Train
 | *Category O (Others) include :
 | Bogie and Suspension Other (Train braking noise, sound, vibration);  Auto Wakeup Problem; Carbody…