...need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I ...
Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect ...
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I appreciate your...
Hey Mate, got a job for you. Please see attached sheet. Need to report on data sheet, data will be updated month to month. Not sure if this can be done with pivot table? but I'm not familiar with dealing with time calculations. Tab 1 Data table 1 + summary by driver: Average Total time (F) by driver (B). Tab 2 Data table 2 + summary by Sub function code: Average Total time by Sub Function (C). Need ability to exclude rows where F is blank or greater than 17 hours.
I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.
I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occur...
I'm looking for a seasoned copywriter to create an engaging online ad targeting college students. The main aim of this ad is to attract potential hires. Key Responsibilities: - Develop persuasive content that appeals directly to the college demographic - Incorporate company messaging, tone and style into the ad copy Skills & Experience: - Proven experience in ad copywriting - Strong understanding of the college market and their behaviors online - Prior work in recruitment advertising will be a major plus Your ultimate goal will be to create an ad that not only stands out but also inspires college students to explore job opportunities with us. Let's make hiring happen!
I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to d...
...that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a positive PCR test should be considered a covid19 patient from that moment. (Hint: copy old object data to the new object) a covid19 patient will be discharged if the PCR test result was negative. 4. Do rounds It will ask you to enter the current temperature for every Covid19 patient. It will treat all the patients currently admitted to the hospital and print out each patient’s id and what is the recommended treatment 5. Discharge patient It will remove the ...
...we receive receipt of email, we tick it and it's recorded with the date and hour that we receive receipt of email, the same way by WhatsApp or by SMS or by telegram or by Viber, when we do it by phone call we teck it when we start call, then we tick it if no answer or if there is an answer and it will be recorded with the date and hour for each task we can put a link to the message that we can copy and the past and send by email by SMS by WhatsApp by telegram or by Viber client page for category C are not the client page for category D and not as client page for category R, some Tasks are not the same, the numbers of Tasks is not the same When we define the client as categories C or D or R the client page change to C page or D page or R page when we receive a receipt from ...
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
As a growing company, I'm looking for an experienced financial analyst who can help analyze the liabilities on our balance sheet - specifically debt, payroll liabilities, and accounts payable. Ideal candidates will have: - Extensive experience in financial analysis, particularly on balance sheets and liabilities - Deep understanding of debt analysis, payroll liabilities and accounts payable - Ability to provide actionable insights based on the analysis - Strong communication skills to explain complex financial data in a clear and concise manner
I am seeking a proficient expert with skills in APA 7th edition format for configuring research tables. Even though proficiency in APA 7th edition standards is paramount in this project, having an insightful understanding of data organization and presentation will be appreciated. In this project, efforts will be channe...needed. Desired turnaround time is end of day (11:59 PM CDT; 23:59 UTC-05:00) on Friday, April 19th, 2024 in a Microsoft Word document. An example of table proficiency in APA 7th edition format would be greatly appreciated to inform the Freelancer selection process for this project. Selected Freelancer must be available after initial submission in case document upload/download, text transfer, or copy and paste causes formatting issues that need to be corrected or ...
I'm seeking a talented professional who can create an engaging and persuasive PDF presentation and sell sheet for my beverage product. - I'm targeting adults, so the content must be tailored to this demographic. - The key selling points of my product are its natural ingredients, variety of flavors, and inspiration from Hispanic culture. These aspects should be effectively highlighted and presented in an appealing way. - The finished product should be in PDF format, making it easy to share and distribute. Ideal candidates for this project should have: - Prior experience in creating marketing materials for F&B products, especially beverages - Strong design skills, with the ability to create visually appealing and engaging content - An understanding of adult consumer pr...
Hi, So i am here looking for some active participants to work on this task of listing. A test will be taken for the task. It's a one time task and won’t tale much of time. All the required information will be provided. Kindly make sure to ask everything to make things clear and the pay will ne given according to the task. Newbies are preferred. Thanks
Need to copy the design/content from my WordPress site to www.primepointpayments.com. I own both websites and urls. Everything will be the same except the logo and company name within site.
I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current demo code lacks a user-friendly interface. ...
...includes relevant copy. Your role would involve: - Creating an impactful graphical representation of the selected athlete. - Effectively incorporating provided copy into the design to align with the sports theme. - Finalizing graphics and layouts and preparing them for printing on t-shirts. Skills and Experience: - Proficiency in graphic design software. - Demonstrated experience in creating sharp and entertaining illustrations. - Experience in t-shirt graphics would be a plus. - Excellent communication and interpretive skills to fully understand and align with the project's vision. - Must supply Vector images I would provide reference photos and copy. I need you to put it together. I've attached a reference photo. I want a person drawn in this position ...
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
...set up and manage a Google Ads campaign aimed at generating leads from business professionals. Key requirements include: - Experience with Google Ads, specifically the Search Network - Proven track record in lead generation from similar target audience - Ability to craft compelling ad copy that resonates with business professionals - Structuring of the campaigns to reach maximum ROI Your work will primarily focus on: - Keyword research and selection to reach our target audience - Create effective ad copy and A/B testing - Regularly monitoring and optimizing the campaign for better results - Providing detailed reports outlining performance and your suggested changes The ideal freelancer will have a deep understanding of lead generation on Google Search, excellent commun...
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I need a comp...Formats: I would like the diary to be available both in physical printed form and as a digital application. - Manually Updatable: The diary needs to be designed for manual input by the drivers themselves. This means a user-friendly interface is a must. - Secure and Reliable: The information logged needs to be secure and reliable. This is especially important for the digital version. MUST BE AN IRELAND COPY OF THIS BOOK Ideal Skills: - Experience with creating tracking systems - App development, particularly in the transportation or tracking sector - User interface design for ease of manual input - Knowledge of secure data handling - Print production for physical version Please provide examples of similar projects you've worked on in the past.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...
As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.
Using PowerPoint or Google Slides, you are to create a presentation appropriate for use with other educators or parents. In this presentation you are to do the following: Identify each student and the issue he or she is facing. You must use the four student profiles provided below. Please DO NOT copy and paste the descriptions provided. Rather, you should explain what you feel are the core issues each face after reading the description. Identify the developmental impact of each issue. How is the issue impacting the student in the classroom? What does the teacher see that is interfering with learning? You will need to include the research that is directly related to the issues and aligned to the developmental goals for the students. For example, you might include a statement s...
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. ...
I'm seeking a freelance Python developer to improve the performance of a perspective correction script which is currently struggling with shapes that have more than 4 points. I have a Python script that does perspective correction of the images. It works in cases where the shape has 4 corners. If a shape has more than 4 corners, the script will not work. Please see attached Working-...and non-working cases. I need a solution that will work in most "non-working" cases. This script also has a function that saves points coordinates to JSON (before, after, and applied translations) It needs to be working and save only 4 points. Once a first working solution is submitted, I will make this contest "Guaranteed". Please don't post your code publically so othe...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I have a task for those skilled in data entry, particularly with respect to copy-pasting job. The work is to be done in Google Sheets, so excellent proficiency in Google Sheets is vital. The volume of data is less than 100 rows and columns total. Therefore, I'm also expecting a high level of accuracy and attention to detail. If you've been involved in similar projects previously, that'll be an added advantage, but it's not a must. Key Skills/Experience: - Excellent copy-pasting abilities - Proficiency in Google Sheets - High attention to detail - Previous experience in similar projects is a plus
Update Wordpress Child theme to work with latest version of X-Pro theme and PHP 8.2 First I would like you to estimate the work using the WPEngine credentials I supplied. Environment is: volleyball2stg From the ticket: I have tried again to update the staging site with the latest copy of the production and update the plugins and theme as well as the PHP version and here is the result. Updating the Pro theme have broken the existing layout of the pages and will need an overhaul of the child theme to match the new parent theme version when it comes to the structure. Updating the PHP version to 8.2 have generated and error on the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it had
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I have a website, , that I would like to copy for a new domain. However, I need this new site to have a similar structure, yet with a unique and bright and vibrant color scheme to avoid any SEO issues with Google. Key requirements for this project include: - Cloning the structure and layout of my current website , ensuring a similar user experience - Updating the design with a bright and vibrant color scheme - Ensuring the updated design is distinct enough from the original site to avoid any penalties from search engines Ideal skills and experiences for this job would include: - Proficiency in web design and development - Experience with creating SEO-friendly websites - Strong sense of aesthetics and understanding of color theory - Familiarity with cloning
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I'm in need of a talented copywriter to handle a variety of projects. - The ideal candidate for this role is someone who has a strong command of the English language and the ability to create engaging, compelling copy that will resonate with my target audience. - I'm looking for someone who has experience writing for a variety of mediums, including web content, social media, and marketing materials. - You should be able to adapt your writing style to suit different platforms and audiences, and have a good understanding of SEO principles. - It would be a bonus if you have experience writing for business professionals or young adults. If you're a creative, detail-oriented copywriter with a passion for engaging your readers, I'd love to hear from you.
$150 USD. Deadline is April 20th, 2024
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
I'm looking for a skilled motion designer who can work quickly to repurpose a video we have. The scope of the project will involve: - Using an existing video that we have as the foundation - Modifying the text and graphics within the video - Adding in new footage as needed - Altering the color scheme to fit our updated b...Modifying the text and graphics within the video - Adding in new footage as needed - Altering the color scheme to fit our updated branding - Ensuring the final video is succinct, being no more than 24 seconds in length Ideally, the freelancer will have experience in video editing and motion graphics, and can work creatively and effectively under a short timeline. Experience with rapid turnarounds and copy jobs is a bonus. We need this project completed as so...
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I need someone with accounting knowledge to copy instructions from a video onto paper. The video is about job costing and necessary journal entries and you will need to write each step down exactly as the shown in the video. Only apply if you can start right away as I need this job done fast.
I need someone with accounting knowledge to copy instructions from a video onto paper. The video is about job costing and necessary journal entries and you will need to write each step down exactly as the shown in the video. Only apply if you can start right away as I need this job done fast.
...compelling website copy that adheres to our brand guidelines. - Develop insightful blog articles that will keep our audience engaged. - Write product descriptions that effectively detail our offerings. Ideal Skills and Experience: - Proven experience in copywriting with a focus on business clients. - Exceptional writing and research skills. - Ability to write crisp, enticing and well-structured copy. - Excellent understanding of content optimization and SEO strategies. Though the main goal was not specified, a keen understanding of business trends and the ability to adjust the tone of content to resonate with the business audience will be of extreme importance. If you are quick on your feet and have a knack for speaking the language of businesses through compelling ...
