Switching mode battery charger circuit diagram仕事
I'm looking for a realistic cover for my single "Love Calls". The design should depict an iPhone screen with the phone ringing and 'LOVE' as the caller. Key Requirements: - The iPhone screen should be set against a black background. - The screen should also feature the time and date, 2:30 Am battery icon 69% , and 10missed calls notifications,in addition to the caller name 'LOVE'. Ideal Skills: - Expertise in realistic digital art. - Strong understanding of iPhone aesthetics. - Ability to incorporate specific screen details accurately. Please share your portfolio showcasing similar work.
...educational project involving a PCB for a radio-controlled toy. I need someone to modify the PCB to suit my needs. The modifications include: - Changing the voltage from 12v to 5v - Adding a lithium battery charging circuit with overcharge protection, temperature monitoring, and over consumption safeguards - Incorporating an H-Bridge to control a medium load DC motor, typically suited for toy cars The modifications are 1. Replace Q3 transistor with more powerful one (as you new). 2. Remove the lock interfaces 3. No need for 12v, instead we are going to use 5v 4. Lithium battery charger circuit and capacity reading 5. Add H-bridge to control DC motors that need a range of voltage 3 to 6v. This means that The interface can run 6v or 3v dc motors. I d...
I am in need of a professional with a strong background in Integrated Circuit (IC) design. The project involves working with the Nordic nrF52832 MCU, integrating it with an OLED display and a weight sensor, and designing a corresponding PCBA. Key Responsibilities: - Design and implement the PCBA for the Nordic nrF52832 MCU, OLED display, and weight sensor. - Develop the protocol and firmware for the project. - Ensure seamless integration of all components. Ideal Candidate: - Extensive experience with Nordic nrF52832 MCU and PCBA design. - Strong understanding of IC design. - Experience with OLED displays and weight sensors. - Proficient in firmware and protocol development. - Previous work in wireless communication integration is a plus. Specific Requirements: - The OLED display ...
Hello, the inodes of my server on sda1 was 100% I have tried to remove some php sessions and the server has been rebooted during removing process, now the server not booting and showing Failed to start mailman services Failed to start exam is a mail failed to start channe...server on sda1 was 100% I have tried to remove some php sessions and the server has been rebooted during removing process, now the server not booting and showing Failed to start mailman services Failed to start exam is a mail failed to start channel queue services Dependency failed for /mnt/HC_volume Timed out waiting for device dev…. Dependency failed for /mnt/HC_volume… I have activated rescue mode and I need to fix now the boot to get cpanel services works again. I can’t share access,...
READ THE REQUIREMENTS CAREFULLY BEFORE APPLYING: DO NOT APPLY IF YOU DO NOT MEET THE REQUIREMENTS:- Need a Teacher for javascript who have good knowledge of HTML, CSS, JAVASCRIPT. - Daily 3 hours in two slots of 1.5 and 1.5 hours - Two Slots Timing: - 1) Between 10AM - 11:30 PM 2) Between 4PM - 5:30 PM - Mode of Teaching Hindi - Should have Good Teaching Skills
Hello, the inodes of my server on sda1 was 100% I have tried to remove some php sessions and the server has been rebooted during removing process, now the server not booting and showing Failed to start mailman services Failed to start exam is a mail failed to start channel queue services Dependency failed for /mnt/HC_volume I have activated rescue mode and I need to fix now the boot to get cpanel services works again. I can’t share access, I can provide anydesk
...Long battery life with easy USB-C charging. • Built for Tradesmen: Tough, durable construction for daily professional use. • Multiple Light Modes: Adaptable to various lighting needs (mention modes if any). • IPX Rating: If the product is water-resistant or waterproof, be sure to list the rating. 3. Side/Back of the Box Content • Product Description: A 2-3 sentence description emphasizing its practicality, durability, and the versatility of the ClipTorch. Example: “The ClipTorch Worklight Ultra is designed for professionals who need reliable, hands-free lighting on the go. Its compact, clip-on design allows for easy carrying, and its ultra-bright LED ensures you can work efficiently even in the darkest conditions.” • Technical Specifica...
...in consumer electronics. The PCB should be made from FR4 material and designed for surface mount (SMD) components. Attached are some general reference pics from internet, these are not the actual requirements. Start your proposal with the word PCB, so I know you have read this. Also before any milestone is created, you will have to send a 2D sketch of the PCB. The present system will include, a battery charging system (BMS), motor selection, on/off switch, led indicator etc. Key Project Requirements: - Design and fabricate a custom PCB for consumer electronics - Designing for Surface Mount Device (SMD) components - Experience with PCB design software and tools - Ability to produce high-quality, reliable PCBs Ideal skills and experience for the job would include a strong backgr...
READ THE REQUIREMENTS CAREFULLY BEFORE APPLYING: DO NOT APPLY IF YOU DO NOT MEET THE REQUIREMENTS:- Need a Teacher for javascript who have good knowledge of HTML, CSS, JAVASCRIPT. - Daily 3 hours in two slots of 1.5 and 1.5 hours - Two Slots Timing: - 1) Between 10AM - 11:30 PM 2) Between 4PM - 5:30 PM - Mode of Teaching Hindi - Should have Good Teaching Skills
I'm looking for an experienced professional who can create a technical AutoCad Electrical Schematic diagram for a residential solar installation. I have attached a mockup showing the connections required. Needs to be delivered in a professional format for use by electrical on site. AERL branding can be included (). DC PV Chargers 2 x AERL SRX 600/70-48 DC Chargers () Batteries 6 x AERL LiFe2 48V 5.1kWh Batteries in a LiFe2 6 Way Cabinet () Inverter 1 x Selectronic SP Pro SPMC482-AU () Comms Gateway 1 x AERL Nexus
When loading, the app must read whether the username is saved in async-storage, if it is, then the app does not display the form with the user texbox and the button...shakes. (you can program the code in anything, but to send all the data to the mysql server, the code must contain something similar to this code: const response = await ('', dataToSend); - so I could control and download data with php code) Also, the application should work in the background and perform all the above-mentioned processes in the background mode, plus the application should be added to the startup processes so that it starts itself when the device is turned on/restarted. The app must also scan and record if the application is forced to shut down (if it is possible to do so).
I'm looking for a Magento expert to modify an existing module. The modification involves changing the current SMS Gateway API configuration to a new one. Key Requirements: - You should have a deep understanding of Magento m...expert to modify an existing module. The modification involves changing the current SMS Gateway API configuration to a new one. Key Requirements: - You should have a deep understanding of Magento modules and their functionality. - Experience in modifying Magento modules is a must. - You should have prior experience with SMS Gateway APIs. Please note, the specific type of SMS Gateway API we are switching to has not been decided yet, but it could be either a REST API, SOAP API or GraphQL API. Your flexibility and adaptability to work with any of these w...
I'm working on an Arduino project involving a soft start module, primarily for current limiting. I need a freelancer to help me create a wiring diagram for this project. Key Task: - Develop a wiring diagram that incorporates the use of resistors and capacitors in the soft start module. Ideal Skills and Experience: - Proficiency in creating wiring diagrams, particularly for Arduino projects. - Understanding of soft start modules and their components (resistors and capacitors). - Knowledge of current limiting, as it pertains to the purpose of the module.
...can use an existing idea). Marketing support and attracting influencers. Community development and social media management. Who I'm Looking For: An enthusiastic game developer with experience or interest in the field of cryptocurrencies. Someone ready to dive into the project and work towards results. Ability to work in a team and openness to new ideas are welcome. Key Features: - **Multiplayer Mode**: The game should allow players to compete against each other in real-time, fostering a sense of competition and community. - **Leaderboard**: A ranking system is crucial for this game. It will not only encourage players to improve their skills but also to invest more time into the game to climb up the ranks. - **In-game Purchases**: The game should incorporate a system for in...
...and 12 months. - Include both retail and wholesale options for product purchases, including services and permanent hair extensions. - **Affiliate Marketing Program**: - Develop an affiliate marketing program similar to Amazon’s, allowing users to earn commissions by promoting products on their platforms. - **Thematic Design**: - Different themes for various festivals. - Light and dark mode options. - Service dropdown similar to FirstCry. ### Key Focus Areas - **Appointment Management**: Streamline appointment bookings and management. - **Retargeting and Remarketing**: Implement strategies to re-engage visitors. - **Branding**: Enhance brand visibility and recognition. ### Bug Fixes and UI/UX Improvements - Address header stickiness, footer balance, and servi...
...Authorization Login: Support phone verification, Google authorized login, and WeChat authorized login. • Real-name Verification System: Support personal and enterprise real-name verification to ensure the authenticity of users' identities. 8.3 Subscription and Payment Modes • Individual User Packages: Support subscription on a monthly or annual basis. • Enterprise User Packages: Support credit recharge mode, with a minimum recharge amount of 10,000 RMB. • Custom Packages: Allow contracts with the team for specific functions and services. • Subscription contents and functional usage permissions for all packages must be configurable in the back-end. 8.4 Contract Generation Feature • Contract Generation Module: Users can generate purchase and coope...
I need help developing a JavaScript solution that allows...developing a JavaScript solution that allows me to insert and commit formulas into Google Sheets through the browser’s Developer Tools (without using the Google Sheets API). I’ve successfully inserted the formula but am facing issues getting the formula to commit when switching cells. The task involves: Identifying the correct DOM element in Google Sheets for inserting formulas. Simulating the "Enter" key press or another method to commit the formula. Ensuring that the formula remains in the cell after switching cells. If you have experience working with Google Sheets DOM elements and JavaScript in the browser, I’d appreciate your assistance. This solution should work directl...
I'm seeking a detailed written article that serves as a beginner's tutorial for the Structurizr tool, specifically focused on creating a simple diagram. The tutorial should be easy to understand, guiding a novice step by step through the process of diagram creation. Ideal skills for this project include: - Proficient understanding of Structurizr - Excellent writing skills, particularly in technical writing - Ability to simplify complex concepts for beginners
I'm in need of a PCB designer who ha...area is crucial. Key Requirements: - 3d Manufacturing Design. - Proficient in WiFi technologies, as the PCB will support this wireless technology. - Knowledge of Bluetooth is also necessary, since the PCB will need to support this wireless technology too. - Familiarity with satellite internet systems is a must, as the PCB will need to interface with these systems. - Well-versed in batteries and Battery Management Systems (BMS). Ideal Skills: - PCB design experience specifically for security camera systems. - Strong understanding and experience with wireless camera systems. - Understanding of VI and AI model functionality. - Proficiency in WiFi and Bluetooth technologies. - Familiarity with satellite internet systems. - Expertise in bat...
I need process flows developed for 9 phases that align with their corresponding release notes. The process flows should be presented as Flowchart diagrams. Key Responsibilities: - Create clear and concise Flowchart ...with their corresponding release notes. The process flows should be presented as Flowchart diagrams. Key Responsibilities: - Create clear and concise Flowchart diagrams. - Align process flows with corresponding release notes. - Ensure diagrams are suitable for understanding by developers. Skills & Experience: - Proficiency in creating Flowchart diagrams. - Familiarity with software tools for diagram creation (Microsoft Visio, Lucidchart, ). - Previous experience in creating technical documentation for developers. Please use any software tool you are comfortabl...
This Project Includes Product Research for Australian market. Product must have high search volume/month, No Fragile, electrical or battery operated products, Easy to ship products, Light weight, Product cost must be less than $5 USD. Must have at least 30% Margin.
...are lots of examples & instructions on the web). Components I already have: 1. Linear encoder (output 1.3V) (A vernier calliper with a data output cable) 2. An ESP32 board (M5Stack Core S3 with battery module) (input 3.3V) 3. Logic level converter (voltage shifter) since output of the encoder and input of 2 the board are different. 4. Micro servos. 5. Breadboards, wires, connectors, soldering iron, various supplies. A bit more detail about the board: M5Stack Core S3 is a modular system. It's built around an ESP32 board. It has some peripherals included, e.g, - an LED touch screen - a battery module - a detachable module that plugs into the io pins, and connects them to lots of connector & ports for cleaner wiring. The ultimate purpose of the project...
I'm in need of an experienced app developer to create a utility app for both iOS and Android. The main function of this app will be to facilitate WiFi sharing. Key Features: - The app should have a user-friendly interface suitable for the general public. - It should enable easy and secure WiFi sharing am...Skills and Experience: - Proficiency in cross-platform app development, specifically using tools like Flutter or React Native. - Prior experience in developing utility apps is highly preferred. - Knowledge about implementing secure user authentication features. - Strong UI/UX design skills to create an intuitive interface for the general public. - Ability to incorporate push notifications and offline mode features. Please provide examples of similar apps you've develop...
...one specific item only. Key Features: - The vending machine will have a front touchscreen display. The API should manage the display and its interactive elements. - It will have a quantity selection component. The API should help keep track of the item quantity and allow for user selection. - The vending machine will operate in a cashless mode. The API should enable integration with a credit card terminal. - There will be a 'press button ready to use' mode. The API should facilitate this feature. The API needs to be developed in Python and should support cashless payment via both credit cards and mobile payment systems (like Apple Pay and Google Wallet). Ideal Skills: - Extensive experience in Python programming. - Prior experience with Raspberry Pi and vend...
...seeking an expert to review my PCB for layout, functional and EMI/EMC issues and suggest layout improvements. The primary aim is to ensure compliance with Australian regulations and produce a working end product. The product is a grain weightometer for measuring grain going over a convetor and into a truck using loadcells and a speed sensor. This will be used in a ag environment and fed from a 12v battery/12v alternator on a petrol motor. I can provide altium files for your review. Key Tasks: - Conduct a thorough EMI/EMC review of the PCB. - Conduct transient suppresion review - Propose layout improvements, particularly focusing on component placement and trace routing. - Advise on grounding strategies to enhance compliance and performance. -Advide on power input filtering -Gen...
...logistics operator to facilitate the transport of non-hazardous military collectibles from Russia to France, transiting through China. Key Responsibilities: - Ensure strict adherence to customs compliance throughout the journey. - Navigate and manage sanctions effectively, ensuring all operations are legal and above board. - Coordinate transportation logistics with flexibility, as the primary mode of transport may vary. Ideal Candidate: - Extensive experience in customs compliance. - Proven track record in sanctions management. - Strong background in transportation logistics. Skills and Experience: - Prior experience in handling military collectibles is a plus. - Familiarity with the logistics route from Russia to France via China is highly advantageous. - Exceptional problem...
I need an expert engineer who can connect an ESP32 to a 5V DC motor driver, powered by a 3.7V Li battery. The system should include a Power On/Off switch, and the ESP32 needs to control the motor speed using PWM (Pulse Width Modulation) control. And need to control rgb led, I want the pcb to equipped with cable sockets to motors and leds and li rechargeable battery. Ideal Skills and Experience: - Proficient in working with ESP32 - Extensive experience with DC motor drivers - Knowledge of PWM control - Circuit design and implementation - Battery powered system design Please ensure the design is compact and efficient to be powered by a 3.7 volts Li battery.
I'm looking for an experienced electrical engineer to design a compact linear power supply (I need the Schematic and the PCB layout done) with the following specifications: - Voltage Outputs: +5Vdc and +12 / -12 Vdc - Current Requirements: 8A for the +5vdc and .75 amp for the +/- 12 vdc lines Circuit Board AND Transformer must fit inside a 5 inch (D) X 8 inch (W) XC 5 Inch (H) location. - Application: Primarily for consumer electronics The power supply has to be compact and portable, so a deep understanding of space-efficient designs would be a significant advantage. Please provide examples of similar projects you've completed in your proposal.
Hi I'm looking for someone to make a small modification on a Chrome extension. The extension, is active only on 1 website (an online game) .... So it's basically a bot that helps with playing the game... it's activated/deactivated by pressing 'T' twice (i.e. TT ) The change I want you to do is to allow activating/deactivating by Right Mouse Button ... That's all, no othe...activated/deactivated by pressing 'T' twice (i.e. TT ) The change I want you to do is to allow activating/deactivating by Right Mouse Button ... That's all, no other changes... so I can use "TT" or use "RMB" to enable/disable the bot you can have a look at the sources here I do not plan to use this in chrome webs store... I will use it on ...
...interested in becoming a manufacturer or a manufacturer thinking about switching to a trusted brand, we’ve got the solution for you. As one of the oldest and most established companies in the market, we provide top-quality products backed by years of expertise. Now is the perfect time to consider your next step. **Is this the change you've been looking for?** Get in touch at 225-665-2949 or visit to learn more! --- Postcard 2 **Front:** **Thinking About Growth?** Whether you're an installer or a manufacturer, there’s a new opportunity on the horizon. **Back:** Are you ready to take the next step? Whether you're looking to shift from installing to manufacturing, or you're a tank manufacturer thinking of switching to a better product line, we...
...attached infrastructure diagram, including: Azure SQL Azure Key Vault Azure Databricks (Cluster, Workspace, and Jobs) Azure Data Lake Storage (ADLS) Microsoft Entra Identity (formerly Azure Active Directory) Unity Catalog (Databricks) The goal is to streamline the provisioning of our MeshEnv infrastructure and ensure security best practices are followed, including HITRUST compliance. Responsibilities: Review, update, and debug the existing Terraform scripts. Ensure scripts comply with HITRUST requirements. Automate the provisioning of Azure services listed above. Optimize existing infrastructure for performance and scalability. Work with secure cloud architectures, particularly in Azure. Ensure seamless integration of all services based on the provided infrastructure diagr...
I'm seeking a modern, combination style (text and symbol) logo with a complementary color scheme. Text /graphics logo should be content: MBM Janitorial Services NJ - Ideal Skills: - Graphic Design - Branding - Color Theory Understanding - - Experience: .../graphics logo should be content: MBM Janitorial Services NJ - Ideal Skills: - Graphic Design - Branding - Color Theory Understanding - - Experience: - Strong portfolio of modern logo designs - Previous work on combination logos - Proven track record with complementary color schemes IMPORTANT: Logo should be ready for edit on AI and Photoshop. Final product should be have dark mode (for background black) Final product should be send source files and fonts, Final product...
Hello, nice to work with you. Pls accept this quote Many thanks
I need UI design for a very simple landing/coming soon page for my upcoming start up & also a blog - Layout to look like this = - In dark mode - A nice background that has some motion e.g. - Short text description of what we do (I will provide) & the "tell me more" button - Blog & blog details same design - Very minimal Need it done asap! That's all
...No Capacitors: The design should avoid capacitors and still ensure reliable, noise-free operation. Noise-Free Performance: The fan regulator should function without any humming or buzzing noises. Minimal Components: Aim to use as few components as possible to minimize costs and complexity. Budget Constraint: The total production cost should remain within ₹200 per unit. Deliverables: Complete circuit schematic and PCB layout that meets the specifications. Bill of Materials (BOM) with a detailed cost breakdown, verifying the feasibility within the ₹200 budget. Prototype testing, ensuring the design operates without noise and without capacitors. Full documentation, including assembly instructions, troubleshooting guides, and programming details for the ESP8266 12F. Additional Terms...
...individuality of each person, but in a stylized manner. - Incorporation of clothing elements from the photos is required but can be simplified and stylized. 2. **Photos and Basis:** - Each team member will provide a photo taken in daylight with side lighting. These photos will serve as the base for the illustrations. - Ideally, the photo should be taken on a smartphone (without portrait mode), using a zoom of 1.5x-1.8x. 3. **Processing and Illustration:** - You will receive basic photos and preferences from each team member (for example, hairstyle, facial expression, etc.). - Each photo needs to be turned into a digital illustration that maintains a cohesive team style. 4. **Technical Requirements:** - Formats: PNG (high resolution), as well as source file...
I'm seeking a proficient Autocad drafter or engineer to assist in updating an Electrical Single Line Diagram and creating a detailed Site Plan. I will provide the necessary input, but the ideal freelancer must be capable of making the required amendments, including: - Amend and update existing Electrical Single Line Diagram. Symbol, format and presentation style must follow as per SLD sample as attach. - Native CAD file of existing SLD as attach - Sample of required SLD format as attach - Info input will be provided by me thru markup The Site Plan should clearly depict: - The location of the site - The positioning of the Main and Sub Distribution Board (DB) - The location of Electric Vehicle (EV) wall-box chargers - Sample of required Site Plan format as attach - Info...
I have an electrical circuit that needs to be redrawn for an academic project. This is quite urgent, so I would appreciate a quick turnaround. Requirements: - Redraw the circuit as a basic sketch - Deliver the redrawn circuit in PDF format Ideal Skills: - Proficient in circuit design and drawing - Quick and efficient - Able to deliver in specified format
I need a plug-and-play USB key for my LG SN11RG soundbar. The key should automatically select the E-ARC audio channel when plugged in and both the TV and soundbar are on. Key functionalities: - Auto-select E-ARC audio channel - Allow switching to Wi-Fi and Bluetooth using the remote control and ChromeCast icon More info: I need a plug-and-play USB key doing only one thing about the audio canal selected automaticaly by my LG sound bar (LG SN11RG). I want it, when plugged into my soundbar and when my TV is turned on and also when my soundbar is turned on, to select the E-ARC audio canal (when selected manually, first it displays on the soundbar "OPT/HDMI ARC" and then it' replaced by :"E-ARC) and to have the possibility to use 2 other audio canals : WiFi and Blu...
I'm seeking an experienced circuit designer for a consumer electronics project, specifically a battery-powered NIR LED and sensor package. Key Responsibilities: - Create a circuit design incorporating a Nordic BTLE SOC, which handles both data transmission and device control. - Design for integration with a rechargeable battery pack, ensuring power efficiency and longevity. Ideal Candidates Should Have: - Proven experience in designing circuits for consumer electronics. - Expertise with NIR LEDs and corresponding sensor packages. - Proficiency with Nordic BTLE SOCs. - Skills in designing for rechargeable battery packs. - A strong background in power management and circuit optimization.
Hi, I am in need of an engineer that can finish designing my innovative pooper scooper that catches dog poop instead of picking it up f...innovative pooper scooper that catches dog poop instead of picking it up from the ground. The pooper scooper I have created is electronic, it extends and retracts automatically with the push of a button. My engineer has designed the product with the handle being 4cm diameter. However we believe this is too thick and want the handle to be 3.5cm diameter. Therefore being able to fit all components (battery and everything else) inside. Is this something you are able to do? Below is a link to the 3D data of the pooper scooper: Thanks, Kyle
...- openvpn account setup for the player if user ordered (it can be set from backend only) and expire after X year (so vpn host,user,pass will be put in from admin backend) when its active the user restart iptv player and sees VPN is activated your VPN ip , country it should be cool glossy design with nice buttons in / white/gray/purple mixed combo template (of iptv player) also a night mode version ( dark mode) glossy The most things can be get from xtream api commands for examples: Get Account Info Max Connections: Status: Expire Date Creation Date Get All live streams list : A significant part of this project involves implementing a system for
We are a first-party insurance litigation law firm handling property damage claims nationwide, including comm...property damage claims nationwide, including commercial and residential claims in Wisconsin. We are looking to obtain 3D Matterport imaging services for several properties as part of our assessment process. Specifically, we are seeking: 3D Matterport imaging of both the exterior and interior of the properties Precise measurements of all windows, door openings, and rooms A detailed sketch or diagram of the roof Delivery of the file in a format that is Xactimate compatible If any specific requests or services incur additional costs, please specify which items and the associated costs. We would appreciate it if you could provide a detailed quote based on the above scop...
I need a set of Microsoft Word templates designed for various uses including cover pages, table of contents,...tags and photos, enhancing consistency and saving time. - Clear Instructions: Each template should contain explicit, easy-to-follow instructions that guide the user on how to utilize the template effectively. The overall design of the templates should reflect a corporate and professional style. Ideal skills for this project include advanced knowledge of Microsoft Word, experience with Word Design Mode/Developer, and a strong understanding of Word Styles. A background in corporate design will be beneficial in achieving the desired aesthetic. Ultimately, the goal is to produce templates that are not only functional, but also visually aligned with a corporate and professional...
I have a 1-page resume website I am building. I want you to force Dark mode so Dark mode so the website loads dark no matter what. See attached screenshot.
I am looking for a developer to create a custom, floating Webex icon that can be displayed on top of a Remote Desktop (RDP) session. The icon should have the following features: Always-on Display: The Webex icon must always be visible and float on top of other applications, even when the Remote Desktop is in full-screen mode. Movable Icon: The icon should be draggable, allowing the user to position it anywhere on the screen or desktop. Message Notifications: The icon must display notifications for unread messages, similar to how the Webex app icon behaves in the Windows taskbar (e.g., showing the number of unread messages or other notifications). Quick Access: When clicked, the icon should bring the Webex application to the foreground or open Webex if it's not already runni...
I have an electrical circuit that needs to be redrawn for an academic project. This is quite urgent, so I would appreciate a quick turnaround. Requirements: - Redraw the circuit as a basic sketch - Deliver the redrawn circuit in PDF format Ideal Skills: - Proficient in circuit design and drawing - Quick and efficient - Able to deliver in specified format
The aim of the project is t...address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck. During the day's import, only lines with “Mode of delivery” information beginning with the letter Q should be imported. A SQL table will be created in the database. Each day, with eac...
