Excel vba column contains text column contains number työt
...specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Ability to work independently and meet deadlines Duration and Budget: This mini-project is expected to require approximately 15 to 20 hours. The budget for the task is 200 EUR. How to Apply: Please submit examples of previously created financial models along with your applica...
The main goal of this project is to find relevant influencers using our Shopify Collabs. Influencers which you will contact, they need to call their followers to install our new android Dance APP. In our APP influencer need to create one new video, and call their followers to dance with them inside ou...Strong negotiation skills and the ability to build mutually beneficial relationships with influencers. If you have a track record of successful influencer marketing and want to help me take my APP to next level, I'd love to hear from you. I will pay you something symbolic for first 2 influencers you find. Around 50usd. If you do good job, we can continue to work and renegotiate. If you read this text until end please write your answer: I have used Shopify Collabs...and conti...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
...created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor ...
...We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It prints the original product name, the plural (if found) and the synonym (if found). I am looking for someone to help me create this list. I have the same list in English and French which the same thing needs to be done. Ideal Skills and Experience: - Advanced Excel skills. - Familiarity with impleme...
...supports and deflection check. Additionally calculations for one timber post (probably glue-lam) determining the demand stresses making sure the bending stresses about y and x axis are both 0, determine strength capacity (design for compressive and bending strength) check cross section resistance adequacy and check member stability Finally with a rough working out to calculate the transfer load of column needed for a clay stiff pad foundation in my design Skills & Experience: - Proven civil engineering background with a heavy bias on structural design - Proficiency in load calculations - Extensive experience in material specification - Sound understanding of technical manuals and structural design - Superior problem-solving abilities Involvement in similar projects in ...
I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.
Seeking sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are all a plus but not mandatory. Novices are also welcome to ap...
I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure the course. Look...
I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.
...safe to assume this would include common fields like name, email, phone number, etc. - Payment Gateway Integration: The form should support payment via Paypal, bank transfer, and credit card. Ensure the payment process is smooth and well-integrated. - The form should first let the user upload the file without requiring a payment initially. After uploading is completed, the user will be shown a number of options for documents review service options to choose from. This selection option will decide the payment amount for the next stage. - File upload process must be separable from payment. That is, if a user has uploaded the files but does not make the payment in the same session, the user should be emailed a unique number to allow the user to make the payment later. ...
Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!
I am seeking a professional adept at text and numeric data entry to assist in a project involving handwritten documents. Responsibilities will include: - Translating handwritten content into digitized form. - Inputting basic numeric data, such as integers and decimals. The ideal candidate will have excellent attention to detail, proficiency in handling handwritten documents, and a good understanding of numeric data entry. Experience with deciphering different handwriting styles for optimal data accuracy is a must. This role requires accuracy and efficiency coupled with the ability to meet tight deadlines.
I am looking for an expert who can create MIS rep...expert who can create MIS reports encompassing sales, financial, and inventory data. The frequency of these reports will be based on my requirements which can vary. Those equipped with excellent skills in data analysis, report generation, and detail orientation will be ideal for this role. Knowledge in handling Excel is a must as the reports need to be delivered in this format. Here's what is expected: - Data compilation and report generation as per my request - Proficiency in Excel for creating and delivering reports - Adherence to strict timelines for report submission - Maintain confidentiality of all the data involved If you have prior experience in creating MIS reports of these types, I would be very interested...
For this project, I require a meticulous freelancer with skills in data entry, and specifically in convertin...meticulous freelancer with skills in data entry, and specifically in converting images with somewhat legible handwriting into Excel data. Key Responsibilities: - Accurate conversion of handwritten text from images into digital format in Excel. - Ensuring the integrity of the data by carrying out data validation and verification. Required Skills: - Proven experience in data entry, particularly involving handwritten text. - An eye for detail for data accuracy. - Proficiency with Excel is mandatory. - Ability to decipher and transcribe somewhat legible handwritten text. This project suits someone with patience and diligence due to the...
Black And white Themed Account Details page with a side bar. Side bar includes: Account Details Security Billings Subscriptions Account Details Page allows to edit profile forname, lastname, contact No. without email verification code, contains dummy profile avatar and pic uploader. Security page allows to change password or email with email verification code Billings page shows payments done for past plans (dummy transactions) Subscriptions shows current running subscriptions (dummy plans) Sidebar when on mobile will not show but a small arrow shows which brings out the side bar in smooth animation.
I'm seeking guidance and support to excel in the AI certification, emphasizing on concepts and theories. - The primary focus of this project is on improving my understanding of AI principles, concepts, and theories. - As I'm aiming to complete the certification, I need a mentor who can explain complex AI concepts in a clear, concise, and readily understandable manner. - Given the current circumstances, I'm specifically looking for online resources to guide me through this journey. Ideal candidate for this project should have: - Proven experience in Machine Learning, ideally with certifications themselves. - Excellent teaching and mentoring skills, particularly in breaking down complex topics. - Good understanding of online learning platforms and resources, with the...
Add column to existing table Amend existing API. Only ftp will be provide for work
I'm seeking a developer to help me setup a simple PSD editing via API or similar. The task involves: - Replacing the text value of a text layer - Replacing an image in the PSD - Exporting the PSD in PNG/JPG format This could be accomplished using : []() or the Photoshop API. or any other library you suggest. ---- One guy started working on this for me, but from all of a sudden just disappeared and stopped answering completely, so all I have is this video he sent me of making such function, to edit the text via a form, and to export the image, check it out here: He made this in less than 1 hour. So this. task itself should be easy for someone knowing this. If you do a good job, this task is just the start, it's
I'm looking for a skilled freelancer to create a custom quoting template in Microsoft Excel for my business. The template should be intuitive, easy to use, and visually appealing. Key Features: - The template must be fully customizable in design, enabling me to adapt it according to my branding and specific needs. - I'd like the template to incorporate conditional formatting for data visualization. This feature will help better present the data, making it easier to understand and interpret. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly in creating templates. - Experience in designing visually appealing and user-friendly templates. - A strong understanding of how to implement conditional formatting for effective data visualization. I...
...a skilled editor to help me add inspirational quotes as text overlays to my Instagram posts. Key Responsibilities: - Adding text overlays: Your primary responsibility will be to add text overlays to my photographs. These will mainly consist of motivational quotes. - Customization: You should be able to match the style of the text overlays to the content of the image. This includes the selection of appropriate fonts and colors. Ideal Skills and Experience: - Strong Editing Skills: You should have prior experience in editing and post-production work. - Instagram Expertise: A good understanding of how Instagram works and what engages the audience would be a plus. - Creative: You should be able to come up with engaging and relevant text overlays for th...
...and agreements. • Experience with software audit tools and technologies. • Excellent analytical and problem-solving skills. • Detail-oriented with a strong ability to interpret data and documentation. • Effective communication skills, both written and verbal. • Ability to work independently and collaborate with cross-functional teams. • Proficiency in using spreadsheet software (e.g., Microsoft Excel) for data analysis. Preferred Qualifications: • Certified Software Asset Manager (CSAM) or similar certification. • Familiarity with IT asset management (ITAM) principles and practices. • Experience with conducting audits in enterprise environments. • Knowledge of software compliance frameworks and standards (e.g., ISO/IEC 19770). ...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requ...Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively...
I am in need of a proficient excel wizard who can simplify my day to day tasks. While the specifics aren't in place, ideally I'm looking for someone who can efficiently perform data entry, come up with efficient formulas and functions, and provide comprehensive data analysis. Proper data formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data analysis and visualizatio...
I am searching for a detail-oriented data entry operator to help with a monthly task of making small text changes to a series of PDF data booklets. The ideal candidate should have: - Previous experience with data entry - Proficiency in PDF editing tools - Strong attention to detail.
I need an expert data analyst to clean and integrate data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning the data to make it suitable for the dashboard - Identifying a...
Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.
I'm in need of a seasoned tattoo artist to design an intricate, Traditional tattoo for me. I intend to get it inked behind my left shoulder. I want the phrase "Non Dvcor Dvco" in a minimalist way (see reference) but feel free to come up with creative designs, special...minimalist way (see reference) but feel free to come up with creative designs, specially highlighting traces of aggressiveness or courage. Artistry with fonts and lettering is critical. Accompanying embellishments of traditional style ink would add an extra layer of personalization. Ideal skills and experience: • Must have prior experience with traditional style tattoos • Proficient in transforming text into visually appealing tattoo design • Ability to tailor make a design to fit appr...
I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.
I'm urgently in need of a contact form on my Divi website. I need the form to have fields for Name, Email, Phone number, and Message. The submissions should be directed to my email address. Key Requirements: - Set up a functional contact form on a Divi website - Include fields for Name, Email, Phone number, and Message Please ensure that you have experience working with Divi and setting up contact forms. This is an urgent task, so I will be looking to have it completed as soon as possible.
I require a detailed, easy-to-use Excel invoice template. The main features needed include: - Line items for products or services delivered: It's crucial that you add functionality for categorizing and detailing all the products or services delivered within the invoice. - Contact Information of both parties: The invoice must have dedicated sections to clearly present contact information of both the issuing and receiving party. - 1 page invoice in A4 size (fixed) with calculations based on user input amount. It's beneficial if you have profound knowledge of Excel and understand accounting principles to design the template in a highly organized and straightforward manner for ease of accounting tasks. Prior experience with invoice template design will be a great ad...
I'm looking to engage a freelancer skilled in data entry and Microsoft Excel to help type significant amounts of text data into an Excel sheet. Your responsibility will include: - Typing text data into an Excel sheet in an accurate and efficient manner. - Maintaining a consistent style and format throughout the entirety of the data entry. - Reviewing and proofreading your work to ensure absolute accuracy. You should display proficiency in Excel, attention to detail, and commitment to maintaining a consistent, professional style across all data. Please submit your bids along with an estimate of timeframe. Though the project completion timeframe was not specified, a timely delivery will still be appreciated.
...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 repo...
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 the extraction...
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...
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.
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
I have a billboard design that needs modifications in the text aliment and few other changes. It very urgent In order to complete the project, I require someone with a strong eye for detail to correct the spelling and grammar errors in the text of my billboard design. Additionally, I am seeking help in selecting appropriate font styles and sizes for the corrections made. Ideal skills and experience for this job include: - Proficiency in graphic design and editing software - Strong command of spelling and grammar - Ability to suggest suitable font styles and sizes This project involves working on one design, but in 9 different sizes for the billboard. The final output should be consistent and visually appealing across all sizes.
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 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...
I have a billboard design that needs a text update. While I do have the original design files, unfortunately, they're not in vector format. Key requirements: - Slight creative adjustment to the text to fit the design: The update will require minor modifications to maintain the overall design aesthetic and message of the billboard. - Non-vector file: As the original files are not in vector format, the freelancers will need to work with the available files and ensure the quality is maintained during the update. - Experience with billboards: Prior experience with billboard designing is preferred as the freelancer would need to understand the specific requirements and limitations of billboard designs. - Graphic design skills: Strong graphic design skills are crucial to ensu...
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
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)
I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...
I am seeking a freelancer with proficiency in Adobe Illustrator for a quick project. The task required is the modification of the text content in an existing file. I will provide you with the exact text content that should be included in the file. Key Skills and Experience: - Mastery of Adobe Illustrator - Attention to detail - Experience with text-editing in Illustrator I look forward to your proposals. Let's refresh this design together!
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product invent...Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yello...