Excel表格技巧:巧用SMALL函数 查找数据集的最小值

本教程适用版本:WPS 365 点击免费使用

SMALL的中文含义是“小”,它的函数使用也与“小”有关。

运用这个函数,我们能够查找到一组数据中的最小值。以这个表格为例,我们来实际操作看看。

■ 选中B2单元格,点击插入函数,找到SMALL函数,点击确定。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

■ 在此,我们需要输入两个数值:

数组指我们要查找的数据区域

K指要返回的最小值点在数据区域的位次

假设我们要查找这个数据集的最小值

我们在数组中选择A列数据集填入

在K中填入1

点击确定,马上就找到了最小值。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

■ 假设我们要查找这个数据集的倒数第三的值,只需将K 的值填入3。

点击确定,马上就找到了数据集中倒数第三的值。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

这个函数在查找大数据集的时候非常实用,你学会了吗~

 

Keyword: 微信过滤

Excel表格技巧:巧用CHAR函数 将代码转换为字符

如何查询手机号是否注册过微信

本教程适用版本:WPS 365 点击免费使用

计算机内的每一个字符都有一个编码相对应,例如:字符A就有一个ANCI数字代码65相对应。大写字母A–Z相对应

的编码是65–90,小写字母a–z相对应的编码是97–122。

CHAR函数,就是根据其参数的ANCI数字代码返回字符。

我们在这个表格中实际操作一下帮助大家理解。

■ 选中B2单元格,点击插入函数,找到CHAR函数,点击确定。

在此,我们要输入数值。

数值是介意1至255之间的任意数字,该数字对应着要返回的字符。

我们选中A2填入,可以看到结果返回了该编码对应的字符。

>免费升级到企业版,赠超大存储空间

■ 将光标定位到B2单元格右下角,出现+字时选中下拉填充单元格,即可以批量的得出对应字符。

>免费升级到企业版,赠超大存储空间

是不是很神奇呢?

 

Excel表格技巧:如何隐藏或自定义设置数据透视表的错误值?

微信开通筛选

本教程适用版本:WPS 365 点击免费使用

数据透视表的“选项”可以设置数据透视表的布局格式、汇总筛选、显示和数据。

>免费升级到企业版,赠超大存储空间

▪以此数据透视表为例,我们可见该数据透视表中含有错误值。

那如何隐藏或者自定义设置错误值显示样式呢?

在插入数据透视表后,点击上方菜单栏分析-选项,此时弹出“数据透视表选项”对话框。

在布局和格式处,勾选格式“对于错误值,显示”并输入显示内容,这样就可以自定义设置显示错误值样式了。

 

A Beginner’s Guide to Post-Processing for Plastic Injection Molding

confetti streamer cannon

Time to read: 5 min

Post-processing improves the properties of plastic injection molded parts so that they are ready for end-use. It includes corrective actions that remove surface defects and secondary processes for decorative or functional purposes. For example, post molding operations can remove excess material (known as flash) or apply part numbers.

As its name suggests, post-processing always occurs after injection molding is complete. It adds costs, but these costs may be less than what you would pay by using more expensive tooling or materials. For example, painting parts after molding may cost less than using an expensive colored plastic. 

With injection molding, there are six common types of post-processing activities. 

  • Gate Trimming
  • Painting
  • Laser Marking
  • Pad Printing
  • Heat Staking
  • Ultrasonic Welding

Within each process, there may be variations. For example, there is more than one way to paint injection molded parts. By understanding all of your options, you can choose the right post-processing for your next project.  

Gate Trimming

Flash mars the finish of molded parts and can interfere with sealing, sealing, and assembly. Typically, this surface defect occurs when excess plastic is forced from a mold cavity at the parting line or ejector pin locations. Quality tooling limits the amount of flash that is created, but gate trimming may still be needed as a secondary operation.

Gates are openings that allow the molten plastic to enter the mold cavity. Although most of this plastic solidifies inside of the cavity to form the part, some material solidifies at the gates and protrudes. Gate trimming, or degating, removes these protrusions either inside the injection molding machine or after part has been ejected. 

Painting

Painting is a form of post-processing for plastic injection molding that adds colored coatings to molded parts. Injection molders can use colored plastic instead, but pigmented polymers tend to be more expensive. In-mold painting is another option but may not be as cost-effective as painting after the fact. Coatings that provide shielding against electromagnetic interference (EMI) are also considered to be post-process painting.

Typically, however, plastic injection molded parts are painted for decoration or to hide surface defects. Prior to painting, cleaning or sanding may be required so that the paint will more readily adhere. Plastics with low surface energy, such as polyethylene and polypropylene, require plasma treatment instead. This process increases surface energy so that there is a stronger molecular attraction between the paint and the plastic. Plasma treatment is cost-efficient, especially in comparison to deep cleaning. 

There are three parts-painting methods.

  • Spray painting is the simplest process and can use self-curing paints that air-dry. Two-part paints that cure with ultraviolet (UV) light are also available.
  • Powder coating applies a powdered plastic and requires UV curing to ensure surface adhesion and to help avoid chipping and flaking.
  • Silk screening is used when parts need two different colors. For each color, a screen is used to mask, or hide, the area that should remain unpainted.

With each of these processes, it’s possible to achieve virtually any color in a gloss or satin finish.   

Laser Marking

Laser marking is a fast, tool-less process that can eliminate the need for surface preparation while imparting high-resolution effects to plastic injected molded parts. Like painting, it provides an alternative to in-mold painting and mold-in graphics, both of which apply decorative effects during the injection molding process. 

During laser marking, injection molded plastics undergo visible surface changes made by a solid-state pulsed laser. For crisp, clear markings, the light from the laser needs to have a wavelength that the molded plastic will absorb. Often, laser marking is used to produce logos or apply unique identifiers to parts that require traceability. Examples include medical devices and aerospace parts.

Because the term “laser marking” is sometimes used to describe several different laser technologies, it’s important to discuss your requirements with your service provider. Traditionally, laser marking refers to the process of producing surface discoloration in black or gray to create letters, numbers, or logos. Laser marking provides an alternative to conventional printing but is not suitable for plastics that resist color changes.

Pad Printing

Pad printing is a conventional marking process that transfers a two-dimensional (2D) image onto a three-dimensional (3D) object. First, a transfer pad is pressed onto an ink-filled plate that has been etched with the desired image. The inked pad is then placed over the injection molded part and pressed against the part’s surface to transfer the ink and apply the image. 

Pad printing can be used on irregular shapes or surfaces. It’s ideal for transferring detailed images and provides good print quality. Quick-drying inks speed processing times and help to avoid problems with dripping, running, or smearing that can occur when ink is applied. Transfer pads and inks are subject to airborne contaminants, however, so quality assurance is a critical part of the process.

As a form of offset printing, pad printing can be used to add single-color or multi-color graphics and lettering to a wide range of plastic materials. Applications include toys, sporting goods, and housings for electronics and appliances. Although pad printing equipment varies, most machines have an ink cup, shuttle, and transfer pad. Process automation supports higher volumes.

Heat Staking

Heat staking installs metal inserts into plastic bosses and housings. Typically, these inserts are threaded to support the use of screws during product assembly. With thermoplastic staking, as this process is sometimes known, heat is applied to the metal insert so that the plastic softens as it is pushed into the part. Like the injection molding process itself, heat staking melts the plastic at a specific temperature and pressure to achieve optimal fill.    

Applications for heat staking include joining molded plastic housings to printed circuit boards (PCBs). This assembly technique is also used with the plastic bosses in automotive door panels. In addition, there are applications for heat staking with consumer appliances such as coffee makers. For almost any type of plastic, thermoplastic staking can produce strong joints. Its low insertion force also supports the use of metal inserts with thin plastics that could split or shatter.

Ultrasonic Welding

Ultrasonic welding is a joining process that uses high-frequency ultrasonic acoustic vibrations to create a solid-state weld between two pieces of plastic. An ultrasonic horn vibrates between 20,000 and 40,000 times per second while maintaining slight contact with the plastic. This vibration produces friction and, in turn, enough heat to melt the plastic. To ensure that parts don’t move as they cool, a clamping force is applied for a specific hold time.  

Like heat staking, ultrasonic welding provides an alternative to insert molding, the process of molding a plastic around a non-plastic part. Whether vibrations or heat are used to melt the plastic, the softened resin flows into voids and then hardens to form a  firm bond with the insert itself. Often, ultrasonic welds are used in medical devices because they eliminate the need for chemical solvents and adhesives that may raise biocompatibility concerns.

Preparing for Post-Processing

Post-processing for plastic injection molding is the last part of the production process. However, that doesn’t mean you have to wait until the end of your design process to consider flash removal, painting, laser marking, pad printing, or whether to handle threaded inserts with heat staking or ultrasonic welding. In fact, thinking about post-processing sooner rather than later could save you time and money in the end. Fictiv wants to help you with your next molding project, and our experts can help figure out which type of post-processing is right for you! Contact Fictiv for a quote today.

6 Holiday Reads for Designers

glitter cannon

Time to read: 2 min

There are a ton of books I’m excited to read this holiday, recommended to me by friends and colleagues, or lingering on a list I’ve carried for a while this year.

Here are my top reading picks, centered around design trends, uncovering creative potential, and the key elements of lean, user-centered design.

1. Imagine, Design, Create: How Designers, Architects, and Engineers Are Changing Our World, by Tom Wujec

This one takes a look at how design tools and processes have been changing and forecasts where design is headed in the coming years. Great one to stay on top of the trends and get a sense of how design fits into the future world we’re building.

2. inGenius: A Crash Course on Creativity, by Tina Seelig

In this book, Stanford Professor Tina Seelig — someone I greatly admire — argues that creativity is not a gift we’re born with, but rather a skill that can be learned. She works to demystify the nebula that is creativity to give anyone and everyone the tools neccesary to do creative work, and do it well. 

3. Talking to Humans, by Giff Constable

This book is all about customer-informed product development, which I see as the foundation of user-centered design. Great for Designers and hardware startup entrepreneurs alike.

4. UX for Lean Startups, by Laura Klein

“Lean” is a term most of us are familiar these days — here’s a guide to lean UX technqiues to design products customers love, and reduce the time it takes to get that product to market.

5. Creative Confidence: Unleashing the Creative Potential Within Us All, by Tom Kelley and David Kelley

This one explores similar themes to inGenius  — brothers David and Tom Kelley (IDEO founder and partner, respectively) explore how every person is inherantly creative and identify a few strategies for tapping into creative potential at work.

6. Creativity, Inc.: Overcoming the Unseen Forces That Stand in the Way of True Inspiration, by Ed Catmull

This one was actually given out to each Fictiv team member this year, so I’m excited to give it a read. It’s written by the Co-founder of Pixar, where he shares the working environment he fostered at Pixar to protect and fuel the creative process and defy convention.

As you can see, the major theme of my reading list this year centers around creativity. I’m excited to get inspired by some of these stories, reminding myself that creativity is a skill that’s fostered and forged. 

Hope this is helpful — add some inspirational reading to your holiday plan!

Wholesale Sherpa Throw Fleece Blanket

Cosmetic glass jar

Overview

Basic Info.

Model NO.
yc-1230

Material
Polar Fleece Fabric

Age Group
Anybody

Feature
Anti-Pilling, Portable, Wearable, Electric

Type
Blended Blanket

Knitting Method
Machine Weaved

Pattern
Brushed

Usage
Home, Travel, Airplane, Picnic, Hospital, Bath, Hotel

Fleece Blanket
Blanket

Solid Blanket
Solid Color Blanket

Polar Blanket
Picnic Blanket

Promotional Lblanket
Plain Blanket

Transport Package
1PCS/Polybag,

Specification
60*50*40CM/ctn size

Trademark
YC CLOTHING

Origin
China

HS Code
6301400000

Production Capacity
20000 Dozens Per Month

Product Description

Product Description

 

Brand Name YC clothing Meterial 100% polyester Size 125*150cm or customized Color According to customer requirements customized color Package 1 pc with a polybag MOQ 100pcs Sample Charge according to the situation, will be returned after the order confirmed. Sample Time Ready sample: in 3days. Custom sample: About 7-10 days Price Term FOB  China of main port Delivery In general,within 30 days after order confirmed, but it depends on the quantity of the order. Payment Term T/T, L/C (T/T: 30% deposit in advance, 70% against B/L copy; L/C at sight) Shipping By air or by sea. Provide shipping consult service by free

Packaging & Delivery

Packaging Details

Inner pacakge: 1pcs/PP bag .Outer pacakge: carton. or customized package.

Delivery Time:30 days after order confirmed for customrized production

pictures

 

  

 

Thick Double Layers Bed Blanket Home Winter Warm Soft Solid Col

Candle holder

Overview

Basic Info.

Model NO.
NTBMGT0002

Material
100% Polyester

Age Group
Adults

Feature
Portable

Type
Chemical Fibre Blanket

Knitting Method
Machine Weaved

Pattern
Printed

Usage
Home, Travel, Picnic, Hotel

Use
Decorative, Bedding

Color
Custom Color

MOQ
10 PCS

Logo
Accept Customized Logo

Technics
Knitted

Packing
Custom Packing

Product Name
Throw Blanket

Fabric
100% Polyester

Trademark
ZJGK

Origin
Tianjin, China

Production Capacity
1000 Piece/Pieces Per Week

Product Description

Product Description

Product Description

 

 

 

 

 

Product Name:

Throw Blanket

 

 

 

 

Material:

100% Polyester

 

 

 

 

Color:

Many solid color and pattern for you choose,and also accept customized color and design

 

 

 

 

Size:

150*200cm,180*200cm,200*230cm,custom

 

 

 

 

Feature:

Eco-Friendly, Wearable, Machine Washable

 

 

 

 

 
Sample time:

Existing colors for quality check 1-2 days

 

 

 

 

 

Customised Colors Sample Or Pre-production samples 3-4 days

 

 

 

 

Our Production Lline

Production Process

Company Introduction

Tianjin ZhongJian GuoKang Nano Technology INC., Ltd , which is a high-new technology enterprise with scientific research development production and sale . The company has collected senior experts, scientific researchers , professors from Academia Sinica and the country well-known research institution ,which devote themselves to the Nano high-end technique developing , development and application . Our corporation produces chiefly bedding set series: Home textiles, like Weighted Blanket, Quilt, Bed Heets, Mattress. Sports protection series: Posture corrector, Waist trainer, Sweat belt, Knee Support, nano, far infrared, Magnetic therapy waist & knee support, bamboo charcoal Fiber Textile Products and Tourmaline healthy products. And it provide OEM & ODM services and commissioned development of products.

FAQ

Q1. Are you a manufacture or Trading company?
A1: Manufacturer. Industry and trade integration.

Q2. How do I calculate or get the freight cost?
A2: The packaging size will be included in the quotation. Or we can get a quote from our forwarder for your reference. Please send the inquiry to us, Thanks.

Q3. Will it be too hot in the summer season?
A3: Yolanda weighted blanket is the most breathable one due to the unique technologies in cotton fabric. so it boosts better
temperature control than others. The glass beads trap significantly less heat than a pile of cotton quilts do when added for
weight. It traps more heat than a simple sheet, but no more than a light blanket in general.

Q4. Can you customize our requirements?
A4: Yes, we have our own product development department, we can also suggest many new products for you which is not common yet in the market .

Q5. Now, what do I do as a first step if I haven’t did weighted blanket before?
A5: No worry about this. We will have a professional service team to help you after receiving your inquiry.

Q6. Can I trust you?
A6: Absolutely YES. We are “Made in China” verified golden supplier. And I think I’m a nice guy.

Q7. May I visit your factory?
A7: Sure, you are welcomed any time. We can also pick you up at the airport and station.

療癒流租屋佈置法,回家一掃整天的疲勞!

Ceiling Light

現代上班族工作壓力大,心理師指出,過度焦慮會讓體內的壓力荷爾蒙上升,增加生病的可能。內在心理與外在健康常常是相互影響的,上班一整天面對壓力,回家更需要舒緩身心、保持愉悅心情,提升自身免疫力;但如果一回家只想慵懶放鬆,沒有時間種植物,更別說是養寵物了,居家生活可以怎麼減壓放鬆?就讓我們從簡單的居家佈置下手,開門瞬間就被療癒!讓整天的疲勞一掃而空!

NO.1超萌小動物當室友

居家風格千變萬化,不論是簡約風、鄉村風、古典風,或是工業風都各有所好。然而,小動物造型的居家佈置,總是能完美融入各種室內風格,不管用什麼樣的方式呈現在居家空間中,它們都能為你的家增添溫馨療癒的氣氛。最受大眾喜愛的兔子、小貓、小狗等寵物系,小熊、狐狸、小松鼠等森林系,企鵝、小海狗、北極熊等冰涼系,以及鯨豚、水母、小丑魚等海洋系,只要超萌小動物當室友,回到家就能被療癒!

NO.2給你愛的抱抱!

選擇特殊造型或圖案的抱枕,放在玄關椅上、客廳沙發上、臥室床上,或是和室的閱讀角落,隨時都可以享受愛的抱抱,讓療癒的抱枕天天向你散播愛的能量!

可養寵、可租補、台水台電計費等各種特色房源等你來搜尋