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

我们在利用Excel表格进行日常办公时，经常需要制作各种各样的表格，我们之前在教程当中给大家介绍了提取整数的方法，那么我们如果想要将整数也抹零，比如给整数抹去10位数或100位数为零，该如何操作呢，今天我们就来教大家，如何给整数抹去相应数值的方法，具体怎么操作呢，一起来学习一下吧。

<caption attachment_14565" align="aligncenter" width="615"] 给整数抹去十位数为零的方法

首先，我们看到如下表格，在这里给大家介绍一下对如下数据抹去十位数为零的方法。

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

在单元格当中输入函数公式=FLOOR，代表按给定基数进行向下舍入计算。

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

然后输入公式=FLOOR(D2,10)，单击回车。

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

回车后我们看到，3083就已经变为了3080，十位数3就已经被抹去了。

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

然后单击单元格向下拉动单元格填充框，完善如下表格，如下图所示。

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

那么，在Excel表格当中，给整数抹去十位数为零的方法，是不是非常简单呢，你学会了吗？

Description

Pure By Nicton Mint Extra Strong has a taste of mint and is free from tobacco. A brand new nicotine pouch from Pure by Nicton.

Weight: 9 grams
Flavour Description: Mint
Nicotine Level: 20 mg/g
Available in: single cans, rolls (10 cans)
Manufacturer: Nicton

在北京时间8月22日的新闻中，今天是夏洛特黄蜂队的主要球员拉梅洛-鲍尔，也被称为“三球”，迎来了他23岁的生日。我们在此祝福他生日快乐。

三球于2001年8月22日出生在美国加利福尼亚州安纳海姆，在2020年NBA选秀上，三球以探花的身份被黄蜂队选中，正式登陆NBA。2021年6月，三球当选2020-21赛季NBA最佳新秀，并入选NBA最佳新秀阵容一阵。2022年2月，三球入选全明星东部替补阵容。

2023-24赛季，三球共为黄蜂出战22场比赛，场均32.3分钟，可以得到23.9分5.1篮板8助攻1.8抢断，三项命中率为43.3/35.5/86.5%。

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

在工作中我们经常会用到一个软件，就是WPS软件，而且在其中Excel表格是我们最常用的，除了会用Excel做表格，那么你会用Excel中的数据透视图做动态图表吗？如果不会的话，一起来看看下面这篇文章吧！

首先我们把需要建立数据透视图的表格选中：

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

然后点击工具栏中的插入，在插入下面的子菜单中点击数据透视图：

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

然后如图所示，点击插入到现有工作表，再点击确定：

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

这时候我们就会看到有这样一个图：

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

然后我们按照所需，将标题拖动到下面的区域中：

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

这样就可以看到我们的数据透视图建立好了：

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

然后我们可以点击标题旁边的小三角号：

这样就可以看到辅助的菜单栏，我们需要哪一个就可以显示哪一个：

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

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

这个方法是不是非常简单呢？你学会了吗？

Introducing the JINPENG XD, an emblem of innovation and sustainability in the realm of personal transportation. Crafted with meticulous attention to detail, this EV trike combines practicality, style, and eco-friendliness to create a mode of travel that not only redefines your journey but also contributes to a greener future.

Unveiling the XD Advantage

Practical Design: The JINPENG XD is more than just an electric tricycle—it’s a statement of modern urban living. With dimensions measuring 2200mm in length, 970mm in width, and 1050mm in height, the XD is tailored for navigating bustling city streets with ease, bringing convenience to your daily commute.

A Vibrant Spectrum: Personalization meets sophistication with a range of optional colors available for the XD. From the timeless allure of red and blue to the warm embrace of brown, yellow, and the subtlety of grey, you can choose the hue that resonates with your individuality.

Eco-Friendly Brilliance: At the core of the XD’s design philosophy lies a commitment to sustainability. Powered by a 72V1000W electric motor, the XD generates zero emissions, contributing to cleaner air and a healthier planet while offering an efficient and economical mode of travel.

Journey in Comfort

Stability Defined: Built on three wheels, the XD provides a stable and secure foundation, ensuring a smooth and confident ride. No matter the terrain, the tricycle’s robust design promises a journey without compromise.

Seating Luxury: The XD offers more than just transportation—it’s a haven of comfort. With a thoughtfully designed seat, every ride becomes a moment of leisure, enabling you to relish both the voyage and the destination.

Embrace the Range: Empowered by a 72V20Ah battery, the XD transcends short distances. Covering an impressive 45-55km on a single charge, this tricycle ensures that your journey goes uninterrupted, whether it’s daily commuting, errands, or leisurely explorations.

A Glimpse into Tomorrow

Seamless Fusion: The JINPENG XD seamlessly integrates innovation with aesthetics, making it an elegant addition to the urban landscape. Its sleek design isn’t just about transportation—it’s a reflection of your commitment to a sustainable and stylish lifestyle.

Beyond the Streets: Beyond being a means of transport, the XD is a testament to choice—an emblem of conscious living that aligns personal well-being with environmental responsibility.

Conclusion

In a world where the horizon of personal mobility is changing, the JINPENG XD stands as a beacon of progress. As we steer towards a future that prioritizes sustainable transportation, the XD emerges as an embodiment of JINPENG’s ethos—to offer solutions that redefine journeys, elevate experiences, and lead us towards a cleaner, greener tomorrow. Experience the JINPENG XD and embark on a journey that encapsulates the essence of innovation, style, and sustainability.

As cities around the world strive for greener and more efficient transportation solutions, electric passenger tricycles have emerged as the ultimate choice for sustainable urban mobility. At JINPENG, we are proud to introduce our cutting-edge electric passenger tricycles, revolutionizing the way people commute and travel within cities. With their numerous advantages, these tricycles are reshaping urban transportation landscapes.

Advantages of Electric Passenger Tricycles

a. Environmentally Friendly Commuting

In an era where environmental sustainability is paramount, JINPENG electric passenger tricycles provide a remarkable solution. By utilizing electric power, our tricycles produce zero emissions, reducing carbon footprints and air pollution in urban areas. With increasing concerns about climate change, choosing electric passenger tricycles promotes a cleaner and healthier environment for both riders and the community.

b. Cost-Effective Transportation

Beyond their environmental benefits, JINPENG electric passenger tricycles offer significant cost advantages. Compared to traditional fuel-powered vehicles, the operational costs of electric tricycles are considerably lower. With reduced reliance on gasoline or diesel, users can save on fuel expenses, making electric tricycles an economical choice for daily commuting and transportation needs.

Additionally, the maintenance costs of electric tricycles are typically lower due to their simpler mechanical structure and fewer moving parts. With fewer components to service or replace, JINPENG electric passenger tricycles provide long-term cost savings for individuals and businesses alike.

c. Enhanced Maneuverability and Accessibility

JINPENG electric passenger tricycles are designed with maneuverability and accessibility in mind. Their compact size and three-wheel configuration enable easy navigation through crowded urban streets and narrow lanes that larger vehicles may struggle to access. Whether it’s weaving through traffic or finding parking spaces, our tricycles offer enhanced maneuverability, saving time and eliminating frustration for riders.

Moreover, JINPENG electric passenger tricycles prioritize rider comfort and accessibility. With ergonomic seating, spacious cabins, and user-friendly controls, these tricycles cater to passengers of all ages and abilities. Whether it’s daily commuting, running errands, or leisurely rides, JINPENG electric passenger tricycles provide a convenient and inclusive transportation solution.

Introducing JINPENG Electric Passenger Tricycles

At JINPENG, we take pride in our commitment to innovation, quality, and customer satisfaction. Our electric passenger tricycles embody the fusion of advanced technology, durable construction, and stylish design. With a focus on performance and reliability, JINPENG electric tricycles are engineered to deliver a seamless and enjoyable riding experience.

Powered by state-of-the-art electric systems, our tricycles feature long-lasting batteries that provide efficient and consistent power, allowing for extended travel distances on a single charge. The integration of cutting-edge safety features ensures the well-being of both riders and pedestrians, making JINPENG electric passenger tricycles a secure mode of transportation.

Conclusion

As cities embrace sustainable transportation solutions, JINPENG electric passenger tricycles emerge as the epitome of eco-friendly, cost-effective, and convenient urban mobility. With their advantages of environmentally friendly commuting, cost savings, and enhanced maneuverability, these tricycles offer a transformative way to navigate cities.Choose JINPENG electric passenger tricycles and experience the future of urban transportation today. Embrace the power of sustainability, efficiency, and comfort as you embark on your journeys with JINPENG, a brand dedicated to reshaping the way we move within our cities.

The landscape of urban transportation is undergoing a remarkable transformation, with JINPENG at the forefront of pioneering innovations. Established in 2004, JINPENG has consistently excelled in electric tricycle manufacturing, with a rich legacy of research, development, production, and distribution. One of our remarkable offerings, the JINPENG A6 EV tricycle, is poised to redefine personal urban mobility. This article delves into the distinctive features and advantages that position the A6 as an exemplar of efficient and eco-conscious transportation.

Design Tailored for Personal Transportation

At the heart of urban commuting lies the need for personal, efficient, and sustainable modes of transportation. The JINPENG A6 embodies these ideals:

Compact and Lightweight: With dimensions of 1780×680×1050 mm, the A6 emerges as a small, lightweight EV tricycle designed for urban environments. Its maneuverability in crowded spaces sets it apart as an ideal choice for navigating bustling city streets.

Efficient Electric Power: The A6 is empowered by a 48/60V 650W electric motor, showcasing JINPENG’s commitment to eco-conscious mobility. As cities worldwide strive for cleaner air and reduced emissions, the A6 responds as a symbol of environmentally friendly transportation.

Urban Exploration Made Effortless

As an EV tricycle, the JINPENG A6 masterfully caters to urban exploration:

Sustainable Short Trips: Designed for short trips within urban areas, the A6 is a testament to JINPENG’s dedication to sustainable urban mobility. Its electric power ensures zero emissions, aligning seamlessly with eco-conscious lifestyles.

Navigating Congested Areas: Urban congestion poses challenges, and the A6 serves as a nimble solution. With a top speed of 25-28 km/h, it adeptly navigates narrow streets and alleys, making daily commutes hassle-free and efficient.

Versatile Accommodations

The JINPENG A6 EV tricycle is more than a personal tricycle; it’s a solution tailored to various lifestyles:

Practical Passenger Capacity: Carrying both a driver and a passenger, the A6 presents itself as a practical option for urban duos. Whether for commuting or running errands, it offers a compact yet comfortable journey.

Urban Commuter’s Delight: The A6 is not just a means of transport; it’s a reflection of urban aspirations. Its lightweight design and efficient power come together to redefine personal mobility in urban settings.

Conclusion

In a world that seeks efficient, sustainable, and personalized transportation, the JINPENG A6 EV tricycle emerges as an embodiment of these ideals. With a focus on compactness, electric efficiency, and practicality, the A6 reshapes the urban mobility narrative. JINPENG’s commitment to innovation and sustainability finds its manifestation in the A6, ushering in an era of clean, comfortable, and convenient urban transportation.

Elevate your urban mobility experience with the JINPENG A6 EV tricycle. As cities evolve, make your mark as a conscientious urban dweller by choosing an electric solution that blends innovation with environmental responsibility. The A6 is more than a tricycle; it’s a testament to a future where efficient transportation meets sustainable living. Unlock the potential of urban exploration with the JINPENG A6 and embark on a journey that fuses personal mobility with environmental consciousness.

Click:Poly bag making machine

Welcome to the world of JINPENG, where innovation and quality meet convenience and comfort. In this article, we will dive into the remarkable features of our 3 Wheel Electric Tricycle. With its spacious cab, comfortable seating, and rainproof protection, this tricycle offers a unique and enjoyable transportation experience. Let’s explore these features in detail and discover why we are the brand of choice for reliable and convenient transportation.

Large Space for Flexible Operation

The generously sized cab of the JINPENG 3 Wheel Electric Tricycle is designed to prioritize both comfort and functionality. The spacious interior provides ample legroom and headroom, allowing the driver to sit and maneuver with ease. This ensures a comfortable and relaxed driving experience, even during long trips or extended periods behind the wheel.

The large cabin space also offers flexibility in terms of operation. It allows for easy entry and exit, making it convenient for drivers of different heights and body types. The ergonomic design of the seating and controls ensures that the driver can maintain a natural and comfortable posture, reducing fatigue and enhancing overall driving comfort.

Comfortable Experience for Passengers

Passenger comfort is a top priority for JINPENG, and the 3 Wheel Electric Tricycle reflects this commitment. The seats in the tricycle are designed with ergonomics in mind, offering a comfortable experience for passengers during their journey. The well-padded seats and supportive backrests ensure that passengers can relax and enjoy the ride, even on longer trips. JINPENG understands that a comfortable seating arrangement enhances customer satisfaction and makes every ride a pleasurable one.

Rainproof Protection for Passengers and Driver

The unpredictable weather should never hinder your travel plans. With JINPENG 3 Wheel Electric Tricycle, you can travel with confidence, rain or shine. The tricycle is equipped with a reliable rainproof feature that ensures the safety and comfort of both passengers and the driver during inclement weather. You can rest assured that you will arrive at your destination dry and protected from the elements, making every journey worry-free.

Conclusion

JINPENG 3 Wheel Electric Tricycle is a testament to our commitment to innovation, quality, and customer satisfaction. The large space, comfortable seating, and rainproof protection are just some of the remarkable features that set JINPENG apart. It’s no wonder that our tricycles have gained popularity among individuals and businesses alike. We invite you to explore JINPENG’s range of 3 Wheel Electric Tricycles and experience the convenience and comfort they offer. Choose JINPENG for reliable and enjoyable transportation solutions.

JINPENG is proud to introduce the revolutionary Cargo Electric Tricycle, designed to provide a seamless blend of safety, comfort, and versatility. With its three wheel linkage brake, 340mm box board height, smart P gear, and thickened box board, the JINPENG Cargo Electric Tricycle offers an unparalleled experience for both drivers and passengers. In this article, we will explore the exceptional safety features, unmatched comfort, and versatile transportation capabilities of the JINPENG Cargo Electric Tricycle.

Enhanced Safety Features for Secure Business Transportation

The JINPENG Cargo Electric Tricycle comes equipped with enhanced safety features to ensure secure transportation for your cargo and passengers. It boasts a three-wheel linkage brake system that provides superior stopping power, even on steep slopes. The thickened box board is designed to prevent your cargo from shifting around during transit, ensuring it stays secure and protected. The smart P gear provides a smooth and efficient driving experience, which is especially important when transporting passengers.

We understand that businesses need a reliable and safe transportation solution for their goods and passengers. That’s why we’ve invested in technology and engineering that enhances the safety and security of our Cargo Electric Tricycle. We believe that our tricycle is an excellent choice for businesses that prioritize safety and want to provide their customers with the best possible experience.

Versatile and Reliable Business Solution

The JINPENG Cargo Electric Tricycle is a versatile and reliable business solution. Its 340mm box board height makes it easy to transport various sized goods, while flexible seating options make it suitable for accommodating both passengers and cargo. It is also adaptable to different terrains and road conditions, making it an ideal choice for businesses operating in different settings.

Boosting Efficiency and Cost-Effectiveness in Business Operations

The JINPENG Cargo Electric Tricycle is an electric-powered tricycle, which means it reduces fuel costs. It also has an increased payload capacity, which allows you to optimize your deliveries and reduce the number of trips required to complete them. This results in higher efficiency and cost-effectiveness in your business operations. Moreover, the JINPENG Cargo Electric Tricycle requires low maintenance, resulting in long-term savings for your business.

Conclusion

The JINPENG Cargo Electric Tricycle is the perfect solution for businesses looking for a reliable, safe, and efficient mode of transportation. Its enhanced safety features, versatility, and cost-effectiveness make it an ideal choice for businesses of all sizes. With JINPENG Cargo Electric Tricycle, you can move your goods and passengers seamlessly, reduce costs, and increase profitability. Choose JINPENG Cargo Electric Tricycle for your business transportation needs today!

Machine shops contain a diverse collection of equipment for meeting the production needs of designers. This machinery can be used together to create an unlimited number of unique shapes for both simple and complex parts.

Without machining expertise, however, design engineers may not understand the capabilities and limitations offered by different kinds of CNC machining equipment. This can introduce unexpected production inefficiencies and increase manufacturing costs.

This article explains the differences between two types of CNC milling machines, specifically 3-axis and 4-axis CNC milling machines. The biggest difference between these machines is their ability to manipulate parts. The possibilities for more advanced movements mean more capabilities.

By understanding how 4-axis CNC milling is different from 3-axis milling, designers can better anticipate what equipment they will need to efficiently manufacture parts.

What is 3-Axis CNC Machining?

CNC machining almost always relies on a Cartesian coordinate system to define its positioning and movements. This means an x-axis, y-axis, and z-axis. The most basic milling equipment on the market is capable of 3-axis machining along these axes.

This means translation movement, or sliding, in 3 directions only: side to side, front to back, and up or down. We define these directions as the x-axis, y-axis, and z-axis respectively.

While 3-axis CNC machines can combine movement along different axes at the same time to create curved shapes, they have somewhat limited capabilities. Parts with features on multiple sides require manual repositioning and realignment between operations, which slows things down. Repositioning workpieces is simplified and sped up by using a separately designed jig, which may also be essential for features like angled grooves.

More complex features that incorporate curvature outside of a single xy-plane may not be even possible on a 3-axis milling machine. For example, helical grooves or the lobes of a camshaft. This means 3-axis CNC mills are best reserved for simple operations like drilling holes or milling slots.

What is 4-Axis CNC Machining?

A 4-axis CNC mill is capable of all the same movements as a 3-axis milling machine, but adds an additional rotary axis, known as the A-axis. This 4th axis is in line with the x-axis used for side-to-side motion. This means the A-axis allows the workpiece to roll forward or backward from the operator’s perspective.

While most 3-axis mills have a “flat” table for mounting parts, 4-axis CNC machines use either a chuck, a faceplate, or a tombstone fixture block. Chucks and faceplates grip an individual part from the side, which can then be rotated for 360° access to all sides. Tombstones hold multiple components simultaneously for batch production.

The A-axis is useful with either continuous movement for rounded features, or by indexing, which repositions and then fixes the part at a new angle. Either way, the 4th axis adds additional capabilities and improves efficiency on parts that need machining on more than one face.

Is 4-Axis Machining Better?

While a 3-axis CNC machine may be all that’s needed for small, simple machining jobs, a 4-axis CNC is sometimes preferred for three reasons:

1. The 4th axis adds the capability for machining more complex features.
2. When machining multiple faces, a 4-axis CNC mill improves efficiency by not requiring workers to reposition and realign parts.
3. Repositioning parts on a 3-axis CNC can introduce inaccuracies and affect the ability to meet design tolerances.

There are also 5-axis CNC machines available to further increase the allowable complexity of machined parts. Gensun uses a full range of high-precision machining equipment to manufacture the parts you need within tight tolerances. Check out our CNC services page to learn how we can help you bring your next product design to the market.