A2ZWEBDESIGNSUSA

Excel表格技巧:提取单元格内数字的个、十、百位数

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

用MIDB和LEN函数组合,MIDB返回文本字符串中从指定位置开始的特定数目的字符,该数目由用户指定。此函数用于双字节字符。LEN返回文本串的字符数。

=MIDB(A2,len(A2),1)是个位数

=MIDB(A2,len(A2)-1,1)是十位数

=MIDB(A2,len(A2)-2,1)是百位数

效果如下:

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

简单的提取小技巧,你学会了吗?

 

Fictiv Process Video: Anodizing

Time to read: 2 min

Anodizing increases corrosion resistance and enhances your product’s aesthetic appearance. Watch our video to see the anodizing process in action!

Anodizing Materials

Aluminum is the most ideal material for anodizing.

The Anodizing Process

Anodizing is an electrolytic passivation process that grows the natural oxide layer on cnc machining aluminum parts to protect them from wear and corrosion and make them look attractive. Known as a conversion coating (like Chem film or Alodine™), the anodizing process causes the surface of the aluminum to recede dimensionally, before the protective oxide layer is built up. When the anodizing process is complete, the oxide layer is chemically bonded to the aluminum substrate below, meaning it won’t chip or flake.

Anodizing is an electrolytic passivation process that grows the natural oxide layer on CNC machined aluminum parts to protect them from wear and corrosion and make them look attractive. This post-processing step in CNC machining is crucial, as it enhances both the functional and aesthetic qualities of the parts. Known as a conversion coating (like Chem film or Alodine™), the anodizing process causes the surface of the aluminum to recede dimensionally, before the protective oxide layer is built up.

Rinse Cycle

The first step in the anodizing process is the rinse cycle, during which a cleaning solution removes debris to ensure uniform coating.

Sulfuric Acid Bath

Next, electricity is used to drive the reaction and develop the coating. The name anodizing comes from the fact that the treated part forms an anode (positive electrode) in an electrical circuit. During this process, the part to be anodized is hung on a conductive rack, submerged in an electrolytic solution, and a direct current of electricity is introduced. While the acidity of the solution dissolves the oxide layer of the part, the electric current releases oxygen at its surface, which builds up a protective layer of aluminum oxide. By balancing dissolve rate with build-up rate, the oxide layer forms with nanopores, which allows continued growth of the coating beyond what is naturally possible.

Dye Bath

After primary coating and before sealing, dye can be applied in a variety of colors. The most popular colors are clear and black, followed by grey, red, blue, and gold. Fictiv offers approximate color matching at additional cost. Contact us for more information.

Sealant Bath

The final step of the anodizing process involves sealing the nanopores, so they can’t become passageways for corrosion initiation. Just before sealing, the nanopores are often filled with other corrosion inhibitors (or colored dyes, as mentioned above). After the process is complete, the coating will be 0.0002-0.0012” in thickness, in accordance with the common engineering spec MIL-A-8625 Type II.

See How It Works

Watch our latest video to see the anodizing process in action. Learn more about Fictiv’s anodizing capabilities on our anodizing capabilities page.

Excel表格技巧:快捷公式功能 提取身份证年龄信息

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

18位数的身份证号里面涵盖了很多的信息比如出生日期、性别、年龄还有所属区域代码等等,利用自动提取功能

可以减少人员信息录入的时间,那么如何根据身份证号码快速提取年龄呢?

■ 首先选中「年龄」列的单元格,然后点击「公式」选项卡下的「插入函数」按钮,接着选择「常用公式」—「提取身份证年龄」,在「参数栏」选择对应的身份证号码单元格,点击确定,此时就会自动计算出年龄。

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

 

■ 最后框选中需要计算年龄的单元格,点击「开始」选项卡下的「填充」按钮,选择「向下填充」,也可使用快捷键「Ctrl+D」一键填充,你学会了吗?

Fashion Hanfu Chinese Traditional Dress Chinese Attire Female

Drip Coffee Bag Packaging Machine

Fashion Hanfu Chinese Traditional Dress Chinese Attire Female Jin Dynasty Straight Train Yarn Clothes Women

The overall design of this Chinese Hanfu is light and fairy. The design of the inner dress is the infinite scenery of the south of the Yangtze River. There are mountains, water, and boats. The outer layer plus the yarn garment increases the hazy feeling, which is the hazy feeling of misty rain in the south of the Yangtze River.

Package Included:
One Dress Inside
One Dress Outside

Bella Hadid's Hair — and Entire Body — Is Covered in Swarovski Crystals

best travel agency in china

Give Bella Hadid a theatrical prop to work with on set and she'll produce an entire performance in the short span of an ad campaign cameo. That prop might come in the form of lengthy tresses such as the hair extensions Hadid debuted on social media in October or the Swarovski crystals that cover every inch of her body and hair in the behind-the-scenes photos she shared on Instagram November 27.  

The model was appointed as Swarovski's holiday muse in its most recent campaign and if you take a look at the jewelry brand's official Instagram page, you'll see photos of Hadid's neck and wrists adorned in a silhouette of gleaming jewels. And the jewels have been individually placed along her slicked-back Tinkerbell bun and actually cover the entire perimeter of her sheer, nude bodysuit. 

She gives ballerina energy as her arms are extended above her head in the first photo. The jewels on both of her wrists appear to be weightless as she sways her arms in a swan-like pose. And in the third of four photos, a village of creatives works on Hadid's final look for the campaign photo shoot with one setting the crystals into place holding a blowdryer with a diffuser attachment near her bun, while another works on Hadid's nails for a Swarovski-infused manicure. 

Instagram content

This content can also be viewed on the site it originates from.

Her hairstyle in particular has got me dreaming up a do-it-yourself project for the Christmas and New Year's holidays to come. I'll be adding the TikTok-viral gem stamper to my Amazon cart stat and re-creating Hadid's truly whimsical bun. 


More on a Sagittarius's astrology guide for the month to come:

  • Your December 2022 Monthly Horoscope Predictions Are Here
  • The 17 Best Gifts for Sagittarius Friends and Loved Ones
  • The Personality Traits of a Sagittarius, Explained

Now, watch Charly Jordan's 10-minute beauty routine for acne-prone skin:

Don't forget to follow Allure on Instagram and Twitter.

Aerospace Injection Molding: Custom Plastic Aerospace Prototypes and Parts

gender reveal popper confetti

Time to read: 6 min

Aerospace injection molding produces plastic prototypes and production-quality parts for aerospace applications. These custom components include brackets and mounts, ducts and vents, covers and panels, and guides and sleeves. From aircraft interiors to airframes; from cabins to engines; and from turbine blades to landing gear, aerospace plastic injection molding can turn your designs into reality – if you know where to look.

Injection molded aerospace parts can be found around aircraft, satellites, and spacecraft.

How to Find an Aerospace Injection Molder

Fictiv works with a carefully vetted network of injection molding partners who can meet the specific needs of aerospace customers. Importantly, we also provide design for manufacturing (DFM) assistance so you can optimize part designs for cost and performance. For faster cycle times, tighter tolerances, and AS9100 quality, companies like Honeywell Aerospace choose Fictiv. 

“Fictiv does an incredible job connecting my needs as a customer to those suppliers that have the capability, the right competitive cost, and the capacity to build my product and get it to me in a very rapid cycle time.” – Jon Hobgood, Vice President at Honeywell

Keep reading to learn more and request a quote for plastic aerospace prototypes and injection molded parts.

Why Aerospace Injection Molding is Different

All types of injection molding processes have commonalities. Whether for prototyping or production, the process begins when molten material is injected into the cavity of a mold. The part material, typically a thermoplastic, then solidifies into the shape of the mold before it’s ejected. Sometimes, secondary processes such as machining, painting, welding, assembly, and packaging are needed.

It’s important to remember that not all injection molders can produce plastic parts with the quality that aerospace customers need. When it comes to aerospace injection molding services, there are four things to look for in a potential partner.

  1. High precision
  2. Advanced materials
  3. AS9100 quality
  4. AS9102 first article inspections 

The following sections explain.

High Precision Aerospace Parts

Injection molded aerospace parts require a high degree of precision to ensure safety and performance. Accuracy refers to how close a measurement is to an accepted value, but precision refers to how close measurements of the same part are to each other. Even minor variations can represent manufacturing defects requiring designers to specify tight injection molding tolerances. In turn, injection molders need to use precision tooling and maintain tight controls over quality systems to ensure conformance.

Aerospace Tolerances

Most injection molds are machined to tolerances of ±0.127 mm, but aerospace parts may need tools machined to ±0.0508 mm or even ±0.0254 mm. However, parts with tight tolerances require steel molds, and steel injection molds cost more than aluminum. Usually, steel also takes longer to machine, so there’s a risk that projects with tight timetables could face delays. If a design change becomes necessary, there are additional costs and longer tool making time to consider.

Aerospace Injection Molds

When you partner with Fictiv, you’ll receive DFM assistance that can help you avoid these and other risks. Plus, you can get T1 samples in just two weeks – even using aerospace plastic injection molds that are made of steel. For prototype injection molding, tools made of soft and semi-hardened steels take less time to machine and provide the fine tolerances you need. For production runs, hardened steel molds can produce high-precision aerospace parts in higher volumes across many cycles.

Aerospace molds are made of soft steel, hardened steel, and semi-hardened steel.

Advanced Materials for Aerospace Injection Molding

Aerospace plastic injection molding services use advanced materials that meet strict standards for strength, durability, and resistance to extreme conditions such as high temperatures, pressures, and chemical exposure. Typically, high-performance thermoplastics, composites, and engineered resins are used. Sometimes, an aerospace designer can use less expensive materials during prototyping and more expensive options during production.

The table below describes advanced materials for aerospace injection molding.

Some aerospace plastics are also used in other applications. For example, glass-filled nylon provides strength and stiffness in aircraft parts, but it’s also used in automobile engine covers. PEEK comes in aerospace grades, but there are also grades for medical applications. Fictiv can help you choose the right resin for your project and works with manufacturing partners who can handle hard-to-process materials.

AS9100 certification demonstrates an injection molder’s commitment to quality. 

AS9100 Certified Injection Molding

AS9100 certification is a well-known quality management standard for the aerospace industry. It’s also used by defense industries. Not all injection molders are AS9100 certified, so it’s important to determine whether a potential partner can meet your standards for quality. AS9100 certification isn’t required for all aerospace parts production, but Fictiv’s global network of manufacturer partners includes AS9100 certified injection molders with deep industry experience.

AS9100 Quality

There are many advantages to choosing AS9100 certified injection molding: 

  • Quality Management System (QMS): Injection molders who establish, implement, and maintain an AS9100 QMS perform regular quality audits and are committed to continuous improvement.
  • Documentation and Traceability: AS9100 certification requires an aerospace injection molding service to collect and maintain detailed records of its processes. This includes material certifications, production controls, and inspection results.
  • Process Control: Molders that maintain strict process control can ensure consistency, precision, and adherence to design specifications. During the aerospace injection molding process, this includes monitoring equipment parameters such as temperature, pressure, and cycle times.
  • Risk Management: Aerospace injection molders with risk management processes are better able to identify, assess, and mitigate the risks associated with producing aerospace components. Examples include problems with tolerance stack-ups in assemblies.  
  • Supplier Management: AS9100 certified injection molders ensure their suppliers and subcontractors (such as toolmakers) also meet stringent quality requirements. In addition to performing regular evaluations, these molders audit supplier performance.

AS9102 First Article Inspection

AS9102 First Article Inspection (FAI) is part of the AS9100 standard and verifies that a manufacturing process, tool, and material can produce aerospace parts that meet all engineering specifications and requirements. Specifically, AS9102 ensures that the first piece is produced correctly and that a manufacturer can consistently produce conforming parts. In other words, it’s essential for high-precision parts with limited part-to-part variability.

AS9102 Forms for Aerospace Injection Molding

AS9102 encompasses documentation requirements for capturing data during the FAI process. This data includes dimensional measurements, material certifications, process validations, and functional tests. There are also three numbered forms for aerospace injection molders to complete.

  • Form 1: Part Number Accountability – Contains information about the part being inspected, such as part number and revision level.
  • Form 2: Product Accountability – Documents the materials, special processes, and functional tests that are required for the part.
  • Form 3: Characteristic Accountability – Captures detailed measurements and inspection results for part characteristics such as dimensions, tolerances, and notes from the engineering drawing.

FAI Inspections

FAI inspection involves a detailed examination and measurement of the first production part. Along with verifying that all design features and engineering specifications are met, an aerospace injection molder must verify each measurement and inspection result. Before full parts production begins, it’s essential to address and resolve any deviations. Sometimes, non-destructive testing (NDT) is used.

Traceability

In aviation, traceability is increasingly important because of how some recently manufactured jets contained components made from titanium that were sold using fake documentation. The FAI process is designed to ensure complete traceability of materials, processes, and inspection results for aerospace components. In turn, this helps identify the root causes of any problems so that suppliers can implement corrective actions.

Approvals, Revisions, and Changes

After the AS9102 FAI is complete, the data is reviewed. An approval signifies that the injection molded part meets all requirements and that the production process has been validated. Although FAIs are associated with new parts, they’re also used when there are significant changes to part design, materials, tooling, or manufacturing process.

From Aerospace Prototypes to Aerospace Parts

Choose Fictiv for aerospace injection molding that meets your requirements for high precision, advanced materials, AS9100 quality, and AS9102 FAIs. In addition to large corporations like Honeywell, we work with smaller aerospace companies like Heliospace that are pioneering cutting-edge technologies and need exceptional quality and fast production.   Are you ready to get started? Create your free Fictiv account and upload your design to see what our instant quote process, DFM expertise, and intelligent on-line platform can do for you. 

Anti-fouling strategy involving in-situ aeration and dielectrophoresis

polymer clay dog figurine

A novel method for treating oily wastewater uses superhydrophilic TiSe2 nanospheres and an electric field for in-situ aeration and dielectrophoresis. This strategy improves fouling resistance by 90% and achieves separation efficiencies of over 99% for oil-in-water emulsions. Utilizing the high salinity of seawater, the method remains effective even after four months of use.

Membrane fouling is a significant barrier to the development of membrane separation processes, particularly in the treatment of oily wastewater resulting from frequent offshore oil spills. A green and sustainable solution is imperative to address this environmental concern. This paper presents a novel method involving the in-situ growth of superhydrophilic TiSe2 nanospheres on foam titanium via a one-step hydrothermal method. Supported by an external electric field, a dual anti-fouling strategy involving in-situ aeration and dielectrophoresis was developed, resulting in a remarkably improved fouling resistance by 90 %.

Unlike prior methods focusing predominantly on developing super-wettability surfaces for passive anti-fouling, the strategy in this work leveraged the high salinity inherent in seawater to introduce in-situ aeration and dielectrophoresis forces to the filtration process. This innovative approach actively prevented oil droplets from contacting the filtration material surface, achieving effective active anti-fouling. The synthesized TiSe2/TF(TTF) demonstrated separation efficiencies of over 99 % for four different oil-in-water emulsions.


Event Tip: EC Conference Bio-based & Water-based Coatings

Unlock the future of sustainable coatings at the EC Conference Bio-based & Water-based Coatings 2024! This conference serves as a focal point for scientists and experts in bio-based, water-based coatings, and sustainability. Join us on November 5th – 6th, 2024, in Cologne, Germany, for a deep dive into the latest advancements, breakthroughs, and trends.
Connect with leading experts, researchers, and industry leaders who will share invaluable insights and knowledge. The conference provides a unique platform for networking, enabling you to ask questions and engage with the right people in the field. Hurry and take advantage of the early bird ticket offer available until September 3rd! Don’t miss this opportunity to secure your spot at the forefront of bio-based and water-based coatings technology! Register now!


Additionally, this work innovatively incorporated Transition State Theory (TST) and the extended Derjaguin-Landau-Verwey-Overbeek (XDLVO) theory as supplementary evidence for the hydrophilicity of the filtration material. It is worth mentioning that even after four continuous months of filtration experiments, the TTF material maintained a rejection rate of over 99 % with only a slight decrease in pure water flux, showcasing its exceptional durability. This work provided a feasible and innovative solution for treating daily and offshore oily wastewater, laying a foundation for future research and practical applications in environmental water treatment.

Source: Journal of Membrane Science, Volume 692, February 202

Evonik increases production capacities for matting agents

double chamber tea bag machine

Evonik’s Coating Additives business line is expanding the production capacity of precipitated matting agents at its manufacturing facility in Taiwan.

The significant capacity increase is intended to help meeting the rising demand for matting agents in Asia, with the capacity expansion scheduled for completion by the second half of 2023.

According to the company, the matting agents in question can enable formulators to reach the full spectrum of matting levels from semi gloss to ultra-deep matt, and the various industrial and transportation application areas range from textile to plastic, leather, can and coil coatings.

“Continuously expanding our position”

“The capacity expansion of our leading matting agents in Taiwan further emphasizes our commitment to the growing markets in Asia and to all our regional and multi-national customers,” says Maximilian Morin, Head of Industrial & Transportation Coatings at Evonik Coating Additives. “We are continuously expanding our position as a truly global partner for our coatings customers by offering the same high quality products from manufacturing locations in multiple regions. In times of rising logistical challenges, such an investment will also directly benefit our partners and customers across the globe by further improving our supply situation worldwide.”

BASF Automotive OEM Coatings secures 100% renewable energy across all China sites

China Tour Packages

BASF Shanghai Coatings Minhang and Caojing sites in Shanghai, and BASF Coatings’ resin plant in Caojing, Shanghai, have announced the use of 100% renewable energy usage across its operations in 2023.

According to company information, through combination of Renewable Direct Power Purchase (R-DPP), purchase of I-REC international renewable energy certificate and other measures, it’s estimated that BASF Automotive OEM Coatings will reduce the equivalent of approximately 19,000 tons of carbon emissions through the end of 2023 in China.

Net zero CO2 emissions by 2050

BASF’s climate goal is to reduce its CO2 emissions by 25 percent by 2030 compared with 2018 and achieve net zero CO2 emissions by 2050. As the company points out, increasing the use of renewable energy at its sites – including the headquarters in Münster, Germany – is a good example of how BASF Coatings explores innovative technologies and solutions to reduce climate impact.

Reading tip

Learn more about current approaches to produce coatings in a more environmentally friendly way and to give coated products a longer service life in the EC Tech Report Sustainability. In addition, its handpicked content dives deeply into the European Green Deal, its key points and main purpose as well as consequences for the coatings industry.

Qt5-15 Fully Automatic Concrete Hollow Paver Brick Making Machin

brick making machine

QT5-15 Fully Automatic Concrete Cement Brick Hollow Block Making Machine
Siemens brand PLC control system / Siemens motor / Omron switch/ International standard steel

QT5-15 block making machine is the latest developed equipment product, which is special purpose equipment for making building block making machine. The material can be fly ash, slag, gangue or other industrial waste, river sand, gravel, cement, etc. Make different sizes of hollow blocks, porous blocks, curbs, pavement blocks. If you add a color machine, you can make layer blocks.
QT5-15 block machine full automatic ,adopts Siemens brand PLC and Touch Screen .Vibrate motors also Siemens brand. So our machine runs stable and effective . Our machine makes the blocks with very good density and high quality. I am sure you will satisfied with it.

 

Technical specifications
Overall Dimension 5120*1950*2810mm
Cycle Time 15-25s
Total Power 26.5KW
Pallet Size 1100*550mm
Raw Materials Crushed stone, sand, cement, dust and coal fly ash, cinder, slag, ganaue, gravel, perlite and other industrial wastes.
Applied Products Concrete blocks, solid/hollow/cellular masonry products, paving stones with or without face mix, garden and landscaping products, slabs, edgers, kerbstones, grass block, slope blocks, interlocking blocks, etc.
Applied fields Widely used in buildings, road pavings, squares, gardens, landscaping, city constructions, etc.


——Details——

——Customer Project——

 

 

——Packing And Shipping——

——Company——

QINGDAO HF MACHINERY Co., Ltd is the professional manufacturer and exporter of technology block machines. We had exported to more than 116 countries from the Philippines, Russia, Egypt, South Africa, Ghana, Oman, India, Armenia,Israel, Chile, etc.

We have more than 50 technicians to guarantee superior installations and service after-sales to help customer install the machine and undergo proper trainingabroad.

We adopt advanced vibration technology, durable hydraulic pressure system and system advanced Siemens PLC intelligent control system. By adopting the technology and control system above, our block machine has higher production efficiency and lower failure rate. The blocks produced by our machines have higher density, higher strength, more beautiful and accurate dimensions. It is our honor to serve some large block factories and companies of construction in Mexico, Belize, Honduras, El Salvador, Panama, Colombia, Ecuador, Peru, Bolivia, etc. We have a wealth of experience in the South American market.

We warmly welcome customers from all over the world who come to visit our factory and discuss long-term cooperation.

 

If you interested in our block machine, please feel free to contact me.