How do i add a 0 to a zip code in excel jobs

I require a custom QR code generator that outputs in SVG format. These QR codes will encode vCard data for contact information. Additionally, I would like the following features: - The QR code should be in the shape of Porsche Crest logo. - The ability to customize the colors of the QR codes. - Support for integrating custom logos or images within the QR code design. Ideal skills and experience for this project include: - Proficiency in SVG format for QR code generation. - Experience with encoding vCard data. - Strong understanding of image manipulation for custom colors and logo integration in QR codes.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add...

I am currently working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I'm seeking a professional with expertise in Visual Software to adjust my company's quote template. Key responsibilities would include: - Adding permanent text, specifically our company's terms and conditions, to all of our quotations. Your skill in precision and attention to detail will be key as we need this text to always appear directly below the quote details. Ideal freelancer should have: - Proficient skills in Visual Software - Experience in document formatting - Strong attention to detail Your job will ensure our terms and conditions are always visible and clear, enhancing our business professionalism and clarifying our policies for our clients.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...for a Dafny developer to support me in the completion of existing code. I need him to pass verification of the code by the instructions exactly. it requires knowledge in proofs, using lemmas. Key Responsibilities: - Complete existing code in Dafny - Conduct code verification and ensure it passes successfully - Ensure the code is coherent and properly structured Requirements: - Proficient in Dafny - Extensive experience with complex algorithms and data structures - Able to work with well-documented code and project requirements - Strong problem-solving skills - Excellent communication skills, as we will need to discuss certain parts of the code Prior experience with ...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to wor...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore...

...always horizontal o Outlet_ID  Multiline text associated with the symbol  Text always horizontal  Background mask with drawing background color, offset 1.05  Text always renders at 3/32” in paper space  Block rotation 0° or 180° (vertical orientation) • Center of text aligned to center of top/bottom of triangle  Block rotation 90° or 270° (horizontal orientation) • If one or two lines of text o Aligned within the top/bottom boundaries of the triangle • More than two lines of text o Line from bottom of ID text to midpoint on edge of triangle o Default alignment has the bottom line of text aligned to 5% above the bottom corner of the triangle  Orthogonal rotation • Text moves away from triangle. Minimum di...

I'm seeking a skilled content writer with expertise in SEO and familiarity with ChatGPT to craft a 1000-1500 word article. The primary objective of this article is to ensure it's optimized for SEO to achieve high and fast ranking on search engines. The content should be informative and engaging and meet the needs of SEO professionals. Ideal skills and experience for this job include: - Proven track record in content creation, particularly SEO-optimized articles - Knowledge of LSI keyword extraction - Experience with ChatGPT or a similar AI writing tool - Strong understanding of current SEO best practices - Ability to use Visual Studio Code for collaboration and development The successful candidate will be ab...

...and finished, working. It is a website for buying and selling collectibles, the client uploads the product and puts the price along with photos. Right now the website allows the client to publish the product in a category (Example: Cards) and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a secon...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. I...

I'm setting up a WordPress WooCommerce store where I sell physical products. I'm looking to have the shipping costs calculated based on the distance to the delivery address, using postal/ZIP codes as the metric. Key Requirements: - WooCommerce Setup: Need someone who is well-versed in setting up eCommerce stores with WooCommerce. - Shipping Configuration: Experience in configuring shipping settings within WooCommerce, particularly for distance-based calculations. - Geolocation Skills: Proficiency in working with postal/ZIP codes to determine distances for shipping cost calculation. - Problem-Solving: Ability to troubleshoot and resolve any potential issues that may arise during the project. Your primar...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. ...

...always horizontal o Outlet_ID  Multiline text associated with the symbol  Text always horizontal  Background mask with drawing background color, offset 1.05  Text always renders at 3/32” in paper space  Block rotation 0° or 180° (vertical orientation) • Center of text aligned to center of top/bottom of triangle  Block rotation 90° or 270° (horizontal orientation) • If one or two lines of text o Aligned within the top/bottom boundaries of the triangle • More than two lines of text o Line from bottom of ID text to midpoint on edge of triangle o Default alignment has the bottom line of text aligned to 5% above the bottom corner of the triangle  Orthogonal rotation • Text moves away from triangle. Minimum ...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” i...

I'm looking for a skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of simi...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks ...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is pre...

Each year we do a t-shirt for our American Football event called Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. Project details are below. 1. Deliverables - 1 editable illustrator file with illustration for front of shirt 2. Last year's shirt is attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the football should match our previous styles, I will send a zip file with r...

**URGENT PROJECT** I need a freelancer to convert a single landing page Figma design into an Elementor website. The project involves: - Converting the Figma design to an Elementor website - Ensuring the website retains the design elements and is responsive across devices - Implementing any necessary plugins or custom code for specific features Ideal skills for this project: - Proficiency in Figma and Elementor - Experience in web design and development - Attention to detail and ability to replicate a design faithfully - Understanding of responsive design principles Please note that while this is a standalone project, successful completion may lead to more work in the future. Here is the ...

...Send me a message proving to me that you have read the project. ******************************************************************* If you are familiar with AWS programming, this should be a simple task for you. I have included an example C# solution using AWS Transcribe that I need to be working. Example Program: AWS Transcribe documentation: Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code succ...

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I have two projects to do on Android Studio by java language. I'm waiting good offers . Task : Create a Music / MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Task : Create a Mobile Application for a Cafe Restaurant to receive orders from its Customers. The Application should offer a list of menu items [For Example: Coffee, Garlic Bread, Cheese Sticks etc.] You can choose the menu items from 4-5 items as per your choice. Try to make the application visually appealing and interactive in terms of graphical user interface (GUI). Demons...

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - ...

...with Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants ...

I'm in need of a specialist capable of developing a moving average indicator in AFL. It needs to be customizable with these specifications: 1. Selection Method: The ability to specify moving average parameters such as Time Periods, Vertical Shift %, Horizontal Shift, Price Field, and Method 2. Adjustable Parameters: For the moving average, I want to edit parameters including Time periods, Vertical shift %, Horizontal shift, Price field, and Method. 3. Time Frame: It needs to accommodate a wide range of time periods from 0 to 1000. This requires proficiency in AFL, understanding of moving average indicators and excellent attention to detail to ensure the varying parameters can ...

I'm looking to add a static QR code to a Facebook post. This QR code should link to a social media profile, which will be provided. Key Requirements Include: - Placement: The QR code should be placed in a Facebook post. - Content: The QR code should contain the data for a specific social media profile. Ideal Freelancer: - Proficient in Facebook post management - Experienced in QR code generation - Knowledgeable in social media profile linking - Attention to detail and precision Please propose your approach to this task and any relevant experience you have with QR code integration on social media platforms.

I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google ...

Hello, I will need 2 different versions of a very simple booking android app. the important part is the communication with our simple Java (eclipse) backend. Analytical step-by-step details will be sent in doc, together with helpful code and matterial, as well as the java eclipse project of the backend. We will need 2 completely different versions of the same app (completely different gui, comments on code, approach where possibble, all variable and function names, structure and order) Budget is $200 USD for both (2 milestones $140 USD and $60 USD) Deadline: 27/5 for the first and 30/5 for the second

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python prog...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

More details: What is the primary purpose of the swiping functionality/screen in your app? Event browsing What content should be displayed on each swipe card? Event name and photo, Event description and date, Event location, Host photo How should the swiping functionality work? Swipe left to dislike, swipe right to like, Swipe up to view more details, swipe down to return to previous card Add swipe screen to menu on existing app, populate with dummy data, that calls backend api

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I have a iOS application with a few bugs that needs fixing and adding the function of inviting phone contacts to our app. iOS application built in: - Objective C - Native App and UIKit I will share the specification document when we speak in freelancer chat.

Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.

I am seeking a skilled and experienced designer who can help me with a simple yet crucial task: changing the color of my product images. I have 2 products with around total 9 images, all of which are currently yellow, and I need them to be transformed into Red, Blue, and many more variants. This project is straightforward for someone who is proficient in using the Hue/Saturation filter in Adobe Photoshop. Scope of Work: - Your task is to change the color of these products to given color, ensuring that the new colors look natural and appealing. - I will provide one reference image with the exact colors I desire. You will use this reference to match the colors accurately in the other images. T...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're pr...