Excel表格技巧:如何限制表格重复值录入?

微信筛选

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

使用WPS Office打开表格。

依次点击“数据”—>“拒绝录入重复项”下拉箭头—>“设置”。

在“拒接重复输入”的弹出框选择需要设置的单元格区域,点击“确定”。

设置完成后在单元格输入相同内容则会提示“拒绝重复录入”。

 

Fall Dusk | Modern Gray Dress (松间照)

Tea bag making machine

DESCRIPTION

* Pre-Order 30 days

* A Set of Hanfu(3 pieces): Traditional – Tank Top + Skirt + Cover-up

                                                 Modern – Crop Top + Skirt + Blouse

* Material: 80% Lyocell, 20% Nylon

* Hemline: 10m

* Model: 162cm, 53kg, Size M

* Unit: cm

Modern Bust Sleeves Length Shoulder Waist Skirt Length

Suggested Height

Evonik invests in Interface Polymers

Pyramid tea bag packing machine

Evonik has invested in the British company Interface Polymers. This company’s additives simplify the processing of plastics such as mixtures with polyethylene or polypropylene.

The poor compatibility of polyethylene and polypropylene with other materials is a drawback. So far, costly and time-consuming surface preparation was the only solution. According to a press stement, the additive technology developed by Interface Polymers makes such preparation unnecessary. Moreover, it greatly reduces the amount of additives needed. As a result, mixed plastics are easier to recycle.

Using the technology in paints and coatings

Bernhard Mohr, head of Venture Capital at Evonik: “Many modern applications would be unthinkable without plastics, but recycling them is still a big challenge. Interface Polymers’ additive technology offers a solution and is an excellent fit with Evonik’s Circular Plastics Program.” The Sustainability Tech Fund launched by Evonik in 2022 is adding Interface Polymers to its investment portfolio. In addition to the investment by the Sustainability Tech Fund, Evonik’s Coating Additives business line has agreed an extensive development partnership with Interface Polymers with the aim of using its technology in paints and coatings.

BASF: NPG and PA with product carbon footprint of zero

map china guizhou province

According to the company, BASF for the first time offers neopentyl glycol (NPG) and propionic acid (PA) with a cradle-to-gate product carbon footprint (PCF) of zero. 

BASF achieves the zero PCF for NPG and PA by using renewable raw materials in its Verbund production system via its biomass balance (BMB) approach. For NPG, BASF additionally uses renewable energy for production.

“Drop-in” solutions

The new products are “drop-in” solutions: According to the company they are identical in quality and properties to the standard products, allowing customers to use them in their production without the need for adjustments to their existing processes.

An essential field of NPG application is powder coatings, especially for the construction and automotive industries as well as for household appliances. PA, which is fully biodegradable, is ultilised as a mold inhibitor for the preservation of food and feed grains. Other application areas include the production of crop protection agents, flavors and fragrances, pharmaceuticals, solvents and thermoplastics.

Antifouling properties of lignin for marine coatings

Click:裝潢

dog cake topper 4 inch

Study is based on preliminary findings that point toward lignin’s efficacy against seawater organisms.

Antifouling properties of unmodified kraft lignin for potential use in marine coatings were investigated in a new research project. The study was based on preliminary findings that pointed toward lignin’s efficacy against seawater organisms during laboratory tests. Coatings were formulated that contained lignin as a filler and had a pigment volume concentration above the critical pigment volume concentration. This ensured direct interaction between lignin and seawater organisms, as the lignin particles remained incompletely wetted by the binder.
Moreover, all formulations were water-borne to mitigate the release of volatile organic compounds. Despite the initial promise, the antifouling performance of the formulated lignin coatings during field experiments at the CoaST Maritime Test Center was limited, and the anticipated mechanism must be reconsidered. Additionally, it was found that high lignin concentrations, while facilitating organism interaction, compromised the coating’s mechanical properties.
Nevertheless, the water-borne coating formulation introduced here might provide a foundation for other researchers to further investigate lignin’s potential as a bio-based pigment or a filler in coatings.

Source of the study: Journal of Coatings Technology and Research, January 2024

Reading tip waterborne coatings

The EC Tech Report Waterborne Protective Coatings gives you an extensive up-to-date bundle on protective coatings, focusing on water-borne solutions, with articles, videos and other content handpicked by the European Coatings Team. In addition to cutting-edge technical articles, the Tech Report is rounded off with valuable market insights and key fundamentals on water-borne protective coatings.

5 Ways to Combat the Machinist Shortage in 2023

electric confetti cannon

Time to read: 5 min

Over the past few decades, there has been a steady increase in manufacturing demand, but simultaneously, there’s been a drop in the number of machinists entering the market. This shortage is hindering the growth of many businesses that have plenty of demand but simply cannot find the right people to drive growth on the manufacturing floor. 

There are many strategies to help your company attract machinists, such as offering increased rates, better work-life balance, and other perks like relocation assistance. However, at this point, these benefits are commonly offered, so it’s time to consider new strategies.

Combating the Machinist Shortage in 2023

With the demand for manufacturing only increasing, attracting new machinists and optimizing existing processes are critical to ensure your company stays competitive. Here are five methods to help your company overcome the machinist shortage in 2023:

Automation & Optimization

Automated systems are far from being capable of completely replacing machinists. Modern machinists still must program CNC machines, select the correct tools, spot potential challenges, and perform problem-solving tasks as they arise during normal machining activities. However, automated systems can be a force multiplier for existing machinists that significantly increases their productivity. Examples of physical automation can include ATCs (Automatic Tool Changers) and automated machine tending using robotic arms.

In terms of optimization, there are many potential interventions that can increase overall productivity. One example is the software used by machinists. Much of a machinist’s time is spent setting up programs for the machines to run. These programs are complex and require a thorough understanding of how to machine different materials, which tools to use, and how to set up a part to achieve the highest possible machining efficiency. However, newer software systems incorporate much of this knowledge into their systems, so machinists can spend less time setting up the program. 

As far as attracting the top talent goes, showcasing your repertoire of technological advancements goes a long way in recruiting. Machinists geek out on new tech, and upgrading to newer systems will make your current machinists happy and more productive. Using automation to improve the productivity of existing machinists can give you time to find long-term solutions to increase your machining workforce.

Internships & Apprenticeships

Internships and apprenticeships are common methods of finding potential candidates and filling gaps within a manufacturing environment. While an apprentice or an intern won’t have the required skills to hit the ground running on their own, as long as they have a solid understanding of the fundamentals of machining, they just need general supervision by more experienced machinists. As such, they can assist your machinists with simpler and repetitive tasks while learning more complex tasks.

Engaging with local trade schools is a good way to find potential interns or apprentices that are looking for work and have basic machining knowledge. So, attend job fairs, post on trade school job boards, or even go speak to a class — get creative! Interns aren’t a permanent solution, but when they have completed their studies you can offer them employment in an environment they already know. And internships provide valuable experience for up-and-coming machinists while giving them an inside look into your company before committing to a full-time position.

Reskilling Existing Employees

Another option for increasing your machinist workforce is to re-skill existing employees. Some employees may want to move from other departments into production, and training them up can help plug gaps. Plus existing employees already know how the company’s policies and procedures work and are a known culture fit.

Ideally, the employees that move are from a position that is easier to fill than a machinist or machinist assistant. However, training a machinist from scratch is a lengthy process and requires a deep understanding of a broad range of topics. Also, the person may need some formal training, which will not only cost money but also remove that person from the floor for a while. However, a reskilling program increases employee retention and provides a long term solution to the machinist shortage.

Build an Online Presence 

One of the most creative methods for recruiting machinists is to build a strong online presence. There are many groups of machinists who have created a strong following online — one of my favorites is Titans of CNC. Many of these influencers are from fully-fledged manufacturing companies that have social-media departments. The key is to find clever ways to show your company’s daily work without giving away any potential IP (intellectual property), and you can also create unique projects to market. 

Many companies find an audience on YouTube or Instagram, but in order to optimize your online presence, you’ll need a dedicated, social media expert — not only to make content that looks professional, but also to tweak and promote the content so it reaches your target market. 

When done well, social media improves your brand awareness and attracts potential machinists by showcasing the quality work your company is doing on a day-to-day basis. Make good enough content and you might even have skilled machinists reach out to you for a job!

Incorporate Cutting-Edge Technology

Machinists like to work on cutting-edge equipment, so it’s a good idea to incorporate cutting-edge machining equipment into your workflows. While this tech and the training required are expensive, not only will it attract experienced machinists who want to grow their skills, but it will also improve machining speed, productivity, and overall part quality — which can offset the initial capital investment over time.

Will Machinists Be Replaced by Robots?

You may think that, in a few years, machinists will no longer be needed because of the progress being made within the automation sphere. However, most of the easily automated machinist tasks have already been automated  by CNC tending robots — and there is still a machinist shortage. This is because machining is a complex task that requires a breadth of knowledge that cannot be programmed into a simple robot arm. For the foreseeable future, machinists will simply integrate more robots into their workflow to increase productivity and keep pace with ever-increasing manufacturing demand.

How Important Is a Machinist?

Machinists are required to program tool paths, set up equipment, and operate CNC mills, turning centers, and lathes. Without a machinist, it would be impossible for a layperson to operate these expensive machines, so machinists are absolutely critical – they’re the only people who can turn a CAD model into a finished part.

The machinist shortage in 2023 doesn’t show any signs of improvement in the short term and, while the strategies in this article can work, they require time and investment that you may not have. That’s why Fictiv is here to plug your gaps in production and help you stay competitive in the market. 

Fictiv is your operating system for custom CNC machined mechanical parts. Our expert engineers and machinists ensure you get quality components no matter how complex your designs. So, create an account and upload your design today to see what our instant, CNC machining quote process, DFM feedback, and intelligent platform can do for you — we deliver complex parts at ridiculous speeds!

Qt5-15 Fly Ash Bricks Machine Manufacturers in Raipur

block production 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.

170M3521

Glass bottles

The 170M3521,from Bussmann / Eaton,is Specialty Fuses.what we offer have competitive price in the global market,which are in original and new parts.If you would like to know more about the products or apply a lower price, please contact us through the “online chat” or send a quote to us!

  • Specifications
  • Package
  • Payment
  • Shipping
  • Contact US
Product Category :
Specialty Fuses
Manufacturer :
Bussmann / Eaton
Applications :
Approval Agency :
Breaking Capacity @ Rated Voltage :
Class :
Current Rating (Amps) :
delivery time :
24 hours
Fuse Type :
Specialty Fuses
Mounting Type :
Holder
Package :
Bulk
Package / Case :
Part Status :
Active
Response Time :
Fast Blow
Series :
170M Fuses
Size / Dimension :
2.323L x 1.772W x 2.008H (59.00mm x 45.00mm x 51.00mm)
Type :
HIGH SPEED FUSE
Voltage Rating – AC :

Engineering Fundamentals Refresh: Bernoulli’s Equation

Green tea bag packing machine

Time to read: 6 min

Fluid mechanics is one of the four branches of mechanics, the study of how fluids behave at rest or in motion — and you’re likely to use this knowledge as an engineer in real practice fairly often. I have used fluid mechanics to design heat exchangers for airplanes, to predict the flow of chemical solutions in a plating tank, determine the best method to dry parts after cleaning them, and to describe the impact that vortex generators have on fuel efficiency of an airplane. 

While you may not use fluid mechanics in your career as much as I have, it’s still a critical area to understand — it helps to explain phenomena in the world around us, including aerodynamics, propulsion, combustion, particle physics, meteorology, and astronomy.

Basis of Fluid Mechanics

Fluid mechanics encapsulates multiple pairs of concepts — first, statics and dynamics, then compressible and incompressible, then real and ideal flow types. And real flow is further divided into laminar and turbulent flow. 

The basis for fluid mechanics is based upon the interplay of five physics principles: 

  1. Second law of thermodynamics: limits the processes that can occur according to the first law of thermodynamics (law of conservation of energy) because energy also has a quality and not just a quantity to be preserved. Specifically, this law states that any naturally occurring process will always cause the universe’s entropy to increase; or the total entropy of an isolated system will not reduce over time. This law also provides a direction for heat transfer that always occurs from a hot body to a cold body (that’s why the HVAC system in your home adds heat in the winter and removes it in the summer — it doesn’t generate cold).
  2. Conservation of mass: in a chemical reaction, mass is neither created nor destroyed.
  3. Conservation of linear momentum: linear momentum is constant before and after a collision of two colliding objects (remember: linear momentum is equal to the mass of an object times the velocity of the object).
  4. Conservation of angular momentum: angular momentum is constant for a system with no external torque (remember: angular momentum is equal to the radius of rotation times the linear momentum).
  5. Conservation of energy: energy is neither created nor destroyed, it simply changes forms (think of a swinging pendulum).

These five principles are best understood when studying fluid dynamics, which is the study of how fluids move and interact with each other. It’s based on the principles of conservation of mass and energy, which states that the total mass and energy of an isolated system must remain constant. 

And the application of principle five to frictionless, laminar flow results in a relationship amongst pressure, velocity, and density which is known as Bernoulli’s Law — this law is defined by Bernoulli’s Equation or the Bernoulli Equation (sometimes referred to as the Bernoulli Principle or Bernoulli’s Principle). 

Origin of Bernoulli’s Equation

Daniel Bernoulli was a famous Swiss mathematician in the late 18th century, and he impacted many areas of scientific importance including atomic theory, the theory of risk, thermodynamics, and his most relevant work for our purposes, hydrodynamics, which was published in his book Hydrodynamica in 1738.

There are a few important relationships to understand about frictionless laminar flow before diving into Bernoulli’s Equation:

  1. As the speed of a fluid increases, the pressure decreases (same is true in reverse)
  2. Mass and energy are conserved
  3. The sum of pressure and kinetic plus pressure and potential energy densities is constant over time and over a streamline

Bernoulli’s Equation is rooted in common fluid mechanics concepts, especially conservation of energy. Read on for the derivation of Bernoulli’s Equation. 

Bernoulli’s Equation Explained

The core of Bernoulli’s Equation is the conservation of energy — which states that for a closed system, the total energy of the system must remain constant. For a moving fluid, the energy of the system can be broken down into two components which are measures of the amount of energy of the system at any given point: pressure and velocity. 

Let’s review the derivation of Bernoulli’s Equation to get a better understanding of its components and potential applications. For example, let’s consider an incompressible fluid (like water), moving through a frictionless, converging pipe, as shown below: 

Consider the following assumptions for Bernoulli’s Equation: 

  1. Fluid flow is one-dimensional and steady
  2. Fluid is inviscid (ideal fluid, all surface forces exerted on the boundaries of each small element of the fluid act normal to these boundaries); meaning there are no viscous forces in the fluid
  3. So, there is transfer of energy from kinetic to thermal energy within the fluid
  4. The flow is frictionless
  5. The stress tensor within the fluid is reduced to the pressure of the fluid and is a point function, scalar
  6. The fluid is homogenous
  7. There is no shear stress to account for

For the above scenario, we can define the following variables: 

  • F = force on the fluid to move it a certain distance
  • v = velocity of fluid
  • dx = defines the boundary layer for location 1 and 2 (gives distance ‘x’)
  • V = control volume represented by dV
  • y = height from ground

We can also define these variables for this scenario:

  • P = pressure 
  • = density
  • A = cross-sectional area of pipe
  • m = mass
  • K = kinetic energy
  • U = potential energy
  • g = force due to gravity (universal gravitational constant)

We know that the force at point one and point two are equal to the pressure of the fluid times the cross-sectional area of the pipe at that location: 

F=AP

F1 = A1P1

F2 = A2B2

Knowing that work is force times distance, we can calculate the change in work from point 1 to point 2 as: 

dW = F1dx1 – F2dx2

dW = P1A1dx1 – P2A2dx2

Knowing that volume is equal to cross-sectional area(A) times width (dx) gives:

dW = P1dV1 – P2dV2

dW = (P1 – P2) dV

Work on the fluid is a result of moving the fluid against the force of gravity and changing kinetic energy of the fluid. This change in kinetic energy can be expressed as:

The change in potential energy from location one to location two can be expressed as:

dU=m2gy2 – m1gy1 = pdVg(y2-y1)

Now, knowing that the work done is equivalent to the kinetic and potential energies, due to the Law of Conservation of Energy, we get the following relationship: 

dW=dK+dU

Substituting the above equations for W, K and U gives:

Dividing all the equation by dV gives:

Rearranging the equation so that all the location 1 variables are on the left and location 2 variables are on the right gives Bernoulli’s Equation:

From this last equation, we can see that the total mechanical change energy of any part of the fluid is a result of the work (potential and kinetic energy changes) done by the fluid external to the part, and is also a result of the changes in pressure from one location to another. Simplifying this for any point along the streamlined flow gives the more recognizeable form of Bernoulli’s Equation: 

P   –  

1
2

pv2 + pgy   =   constant

This constant is sometimes known as the Bernoulli Equation Constant, which means that the sum of the terms on the left-hand remains constant, regardless of what location along the flow’s path you choose. 

Bernoulli’s Equation in Real Life

If you are a mechanical engineer, biomedical engineer, aerospace engineer, or any type of engineer that deals with fluids, you will use Bernoulli’s Equation in real world applications. For example, in aeronautical engineering, Bernoulli’s Equation explains the flow of fluid over an aircraft and how an aircraft stays in the air. In simple terms, airplanes fly because air flows over the curved surfaces of the wings, which creates a low pressure area that accelerates the air traveling over the top of the wing and creates lift. 

In biomedical engineering, Bernoulli’s Law explains the flow of blood through veins and arteries in the cardiovascular system. Other common applications of Bernouilli’s Law include: 

  • flow through nozzles and channels
  • drag force in watercraft and automobiles
  • fluid flow measuring devices

Bernoulli’s Law is a fundamental principle of fluid dynamics that describes the relationship between the pressure, velocity, and density of a moving fluid. It has a wide range of applications in many different fields, ranging from aeronautical engineering to medicine. That’s why understanding Bernoulli’s Law is essential for anyone who wants to work with fluids.

Fictiv: Complex Parts at Ridiculous Speeds

Comprehensive understanding of Bernoulli’s Equation is key to crafting good designs  for parts involved with flowing fluids, but to get good parts, you also need a top-notch production parter. Fictiv is that partner who manufactures the quality, complex parts you need at ridiculous speeds. 

Fictiv is your operating system for custom manufacturing that makes part procurement faster, easier, and more efficient. In other words, Fictiv lets engineers, like you, engineer. Create an account and upload your part to see what our instant online CNC quote process, design for manufacturability feedback, and intelligent platform can do for you.

170M3815

confetti streamer cannon

The 170M3815,from Bussmann / Eaton,is Specialty Fuses.what we offer have competitive price in the global market,which are in original and new parts.If you would like to know more about the products or apply a lower price, please contact us through the “online chat” or send a quote to us!

  • Specifications
  • Package
  • Payment
  • Shipping
  • Contact US
Product Category :
Specialty Fuses
Manufacturer :
Bussmann / Eaton
Applications :
Electrical, Industrial
Approval Agency :
CSA, UR
Breaking Capacity @ Rated Voltage :
200kA
Class :
Current Rating (Amps) :
200A
delivery time :
24 hours
Fuse Type :
Specialty Fuses
Mounting Type :
Holder
Package :
Bulk
Package / Case :
Rectangular, Blade
Part Status :
Obsolete
Response Time :
Series :
170M Fuses
Size / Dimension :
2.717L x 1.772W x 2.283H (69.00mm x 45.00mm x 58.00mm)
Type :
HIGH SPEED FUSE
Voltage Rating – AC :
700V