Parse state city state zipcode excel punët

...of a few specific features: - Allows player to input total points for each category - Ability to track and deduct cost from the players inputted total "points" for the category - Output purchased skills / spells into a final screen with buttons for each skill or spell purchased that when pressed are marked as "used" - Reset button which takes all current purchased skills or spells back to unused state - Ability to save "battle board" - the final screen of selected skills / spells - to be loaded later or switched with another battle board which was saved. The perfect candidate will have strong experience in mobile app development, with a portfolio displaying similar work. Understanding the dynamics of game tracking would be a great advantage. Experie...

I need a Python program to parse a JSON file and format it correctly to be JSON compliant. Key Requirements: - Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is attached. Pay attention to the backslashes (&...

My WordPress site was hacked and it's causing me a lot of trouble. Unfortunately, I'm not sure if I have a backup. I need a skilled professional to help me fix the issue as quickly as possible. Key Responsibilities: - Restore my WordPress site to its original state - Implement security measures to prevent future hacks Ideal Skills: - Proficient in WordPress - Experience in website restoration - Strong understanding of website security and hacking prevention - Ability to work quickly and effectively under pressure Please reach out if you're confident you can help me resolve this issue urgently.

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I require...listings. The primary task is to promote my Airbnb properties and to increase site traffic by targeting and enticing families and vacationers. Key responsibilities: - Enhancing the presence of my listings on the Airbnb website - Crafting and executing compelling social media campaigns - Ensuring constant visibility within families and vacationer segments The properties are located in the city center, hence a strategic approach to attract urban vacationers and families is essential. Ideal candidate: - Familiarity with Airbnb's algorithm - Acute understanding of social media trends - Expertise in geo-targeted promotion - Experience in the hospitality or real estate sector would be an asset. I look forward to driving my Airbnb business to new heights with ...

I'm seeking a skilled draftsperson or architectural designer to create conceptual drawings for a prospective RV park on a four-acre undeveloped land in Orange, CA. The design is strictly for presentation purposes to city officials and doesn't have to be to scale at the moment. Ideal candidate has experience in landscape design and space planning. Key requirements for this project include the following: - Creation of more than 100 RV parking spaces illustrated in the drawing - Drafting access roads within the property for easy navigation - Integration of a 10-foot pathway within a 30-foot easement - Landscaping concepts for further visual appeal - Elevation details and cross sections (if possible) - Preference for gravel surfaces for both RV parking spaces and access road...

I need a professional with expertise in assessing the structural integrity of steel towers. The main goal is to ascertain ho...structural integrity of steel towers. The main goal is to ascertain how well the tower is holding up and if it's safe for use. - Skills and Experience: - Proven experience assessing steel towers. - Understanding of load calculations and structural integrity. - Ability to provide clear, detailed reports on findings. Utilize an independent structural engineering resource registered in the State of Tennessee to conduct a comprehensive inspection of the water tower's surface to identify and report any structural defects or areas requiring repair and report such issues to ORNL representatives for concurrence and approval prior to initiatin...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm looking for immediate assistance with my Wordpress website. After installing Meta pixel for WordPress, the entire website layout broke. Unfortunately, I don't have a backup of the site prior to this issue. Key Responsibilities: - Diagnose and fix the broken website layout - Ensure all pages including homepage, product or service pages, and contact forms are restored to their original state Ideal candidate should have: - Proven experience in fixing and restoring Wordpress websites - Familiarity with Meta pixel for WordPress and its impact on site layout - Ability to work quickly and efficiently to resolve the issue Your prompt attention and quick turnaround on this project would be greatly appreciated.

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

...my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Knowledge of cybersecurity measures - Experience in dealing with compromised online accounts - Network security proficiency The project will entail: - setting up a closed in-home network in my home in Redwood City - Conducting a thorough investigation into the unauthorized access of my online accounts - Identifying the source of suspicious device activity - Making recommendations and implementing solutions to enhance security - Training me on best practices for keeping my accounts and devices secure in the future....

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

I need a civil engineer that can provide stamped plans in the state of Utah. Concept work is done. Need grading and drainage, parking lot details with specific requirements noted on plans as per county code ( I have all that ready to share)

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

We're in need of high-quality images and short films showc...showcasing our belt and roller conveyors for promotional purposes. Ideally, we'd like cinematic shots that highlight the key features and operations of the equipment. The short movies should be silent, with suitable, unobtrusive background music. Key Requirements: - Proficiency in photography and videography - Prior experience in industrial shooting and editing - Work on-site at DHL Waterfall City - Deliver attractive, high-resolution images - Create brief, engaging, non-narrative films of conveyor operations - Ability to select suitable background music for the videos - Deliver material suited for promotional purposes Your portfolio showing previous industrial photography and videography would be highly val...

We're in need of high-quality images and short films showc...showcasing our belt and roller conveyors for promotional purposes. Ideally, we'd like cinematic shots that highlight the key features and operations of the equipment. The short movies should be silent, with suitable, unobtrusive background music. Key Requirements: - Proficiency in photography and videography - Prior experience in industrial shooting and editing - Work on-site at DHL Waterfall City - Deliver attractive, high-resolution images - Create brief, engaging, non-narrative films of conveyor operations - Ability to select suitable background music for the videos - Deliver material suited for promotional purposes Your portfolio showing previous industrial photography and videography would be highly val...

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I'm looking for an experienced developer to create a Flag Status Alert app for both iOS and Android. The app will notify users when to fly the flag at full or half-staff based on their state. The information could be obtained from all 50 state and territory governor pages and the White House website or through a manually updated database. Key Features: - Development for both iOS and Android platforms - Implementation of user notification features including push notifications, email alerts, and SMS alerts. Ideal Skills and Experience: - Proven track record in developing and launching user-friendly mobile applications for both iOS and Android - Familiarity with APIs and web scraping to acquire real-time data from government websites or the ability to create a reliable, m...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

We're looking for a freelancer to take and upload live photos of 8 Rittenhouse / Center City bars in Philly. This is for a Philly bar iOS app, aimed at providing real-time updates to users regarding the bars' lines and interiors. Key Responsibilities: - Taking live photos of bars from 9pm-1am on Friday and Saturday night. - Uploading the photos to the app promptly. Photo Guidelines: - Photos must be taken on an iPhone and uploaded to our iOS app

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check th...

I am currently developing the field oriented control system for a permanent magnet synchronous motor. My goal is to improve the speed response, specifically the acceleration time, deceleration time, and steady state error. The project involves the tuning of PI controllers within the system, meant to enhance its overall performance. For this task, a proficient knowledge of control systems, system modeling, and tuning methods is required. Previous experience with PI tuning is beneficial. Currently, MATLAB/Simulink is being used for modeling and system simulation, hence proficiency in it is crucial. Ideally, the candidate will have extensive experience using MATLAB for complex motor control simulations. However, I haven't defined the specific tuning methods to be used which le...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

...strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance issues. - Maintain high code quality and adhere to best practices in Flutter development. **Requirements:** - Proven experience in developing Flutter applications, particularly in the ride-hailing or similar domains. - Strong understanding and practical experience with Bloc state...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on targ...

I'm in need of an experienced desk researcher based in UAE, to provide insights on the heavy machinery market in UAE. Key Research Areas: - Market Trends: Understanding the current state and forecasting trends in the heavy machinery industry in UAE. - Competitor Analysis: Identifying and analyzing major players in the market and their strategies. - Insurance for Heavy Machinery: Exploring the insurance landscape for heavy machinery in the region. - Legal Implications: Investigating the legal aspects and implications related to heavy machinery operations in the aforementioned countries. You should be adept at: - Conducting comprehensive desk research, utilizing industry reports, government websites, and trade publications. - Analyzing and synthesizing data to provide meaningfu...

I'm in need of an experienced desk researcher based in LATAM, to provide insights on the heavy machinery market in Brazil, Mexico, and Argentina. Key Research Areas: - Market Trends: Understanding the current state and forecasting trends in the heavy machinery industry in LATAM. - Competitor Analysis: Identifying and analyzing major players in the market and their strategies. - Insurance for Heavy Machinery: Exploring the insurance landscape for heavy machinery in the region. - Legal Implications: Investigating the legal aspects and implications related to heavy machinery operations in the aforementioned countries. You should be adept at: - Conducting comprehensive desk research, utilizing industry reports, government websites, and trade publications. - Analyzing and synthes...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...

Fix woocommerce reports and remove zipcode from shipping checkout

I am in need of a comprehensive list of British service providers who do not currently have a website. This list is intended to be used for direct marketing purposes, so it should be well-organized and easy to understand. IMPORTANT: This means if I google the business name an city, I should not be able to find a website on Google. Facebookpages etc are ok, but no www. The list should include basic contact information for each business, such as the name, phone number, and email address if available. Ideal Skills: - Proficiency in online research - Data entry and organization - Familiarity with UK businesses and service providers - Direct marketing experience Looking forward to your proposals.

Hello I am looking for an individual to BUILD brand awareness and sales for a BAR we operate in Glasgow City Centre, I am looking for an individual to create a B2C Marketing strategy and direct marketing plan using tested techniques of "On the Street" marketing and awarenes you will need to share an EXAMPLE of a hospitality marketing plan you have previously developed and be able to demonstrate its impact.

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm in need of a multi-user web portal that will facilitate the connection between trainers and students. The portal will have the following features: - **Multi-Login System**: There needs to be a seamless and secure multi-login system to accommodate both trainers and students. - **Search Functionality**: Users should be able to search for trainers or classes based on the city or trainer's name. This will make it easy for students to find trainers that are close to them or whom they may have heard of. - **User Profiles**: Each trainer or class should have a detailed profile which includes: - Biography: A brief description of the trainer and their training methods. - Reviews and Ratings: Users should be able to rate and write reviews about the trainers/classes. ...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...

i have Po...((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant is true then parse it as string otherwise leave it as it is now which integer. can i do that only on parser or i need to change the Pojo class as well (colorWsDTO) who can do it in summery and short let em know , thanks please consider error handling in this case

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

My WordPress website was recently defaced, and I'm seeking a professional to resolve the issue and prevent future occurrences. Key Tasks: - Investigate: Conduct a thorough review to understand how the defacing occurred and identify any vulnerabilities. - Repair: Fix the defaced content and restore the site to its original state. - Security Enhancement: Implement robust security measures to prevent similar incidents in the future. Skills and Experience: - Strong understanding of WordPress and its security vulnerabilities. - Proven experience in website security and hacking prevention. - Ability to investigate and resolve issues efficiently. - Good communication skills to explain the situation and preventive measures. I'm looking for a diligent professional who can not on...

I'm seeking a skilled SEO expert to enhance my Google profile. Here's the full scope of the project: - **Keyword Optimization**: My website currently has a moderate ranking on relevant keywords. I need you to optimize the keywords for better s...Google profile to better cater to local customers. This may involve changes in the description, contact information, or other details to make it more appealing to my local audience. Ideal candidates for this project should have: - Proven experience in SEO and Google profile optimization - A strong understanding of keyword research and optimization - The ability to analyze and act on the current state of my website's search engine ranking - A creative approach to tailoring a Google profile to a specific target audience, in th...

I am seeking an experienced SEO freelancer to elevate my website's position in search engine rankings and amplify its visibility on a national scale. Key Tasks: - Implement updated SEO strategies focusing specifically on national customers. - Use state-of-the-art tools and processes to monitor and report on our SEO performance. - Give expert recommendations on how to continually improve and maintain high visibility. It is not specified which content should be optimized, so a comprehensive approach - covering all areas such as blog articles, product descriptions, landing pages - will be beneficial. Required Skills & Experience: - Proven experience in successful SEO projects. - Ability to analyze and report on the effectiveness of SEO strategies. - Deep understanding of k...

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.