Macro script excel find data column jobs
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
...to create a custom indicator using Pine Script v5 for the TradingView platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. Expected Deliverables; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, trailing SL & trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of th...
2 excel files with VBA macro as per customer requirement
...role would also involve aiding in comparison and assessment of different cybersecurity measures. specific area of this topic: you will need to find it out of the 5 articles after you get them out of the internet. share them with first and we will agree on them. Research focus: first the freelancer should look for 5 articles and they should be from IEEE format. And then make a compares between the 5 articles on level of the cybersecurity CIA and these articles should be from 2020 to current only. note; i will share the topics with you. select topic and then google it looking for the research paper. then find the survey paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP....
I need a professional to list for rent my 2-bedroom, 2-bathroom condo in Long Beach, CA on Zillow. This includes: - Property Advertising: Increase property visibility to attract potential tenants. Create compelling listings complete with high-res photographs and detailed descriptions. - Tenant Screening: Review interested parties, check references, and conduct background checks to find reliable tenants. I'm seeking someone with experience in property management and familiarity with local rental laws. Knowledge of property advertising platforms is necessary, along with strong communication and decision-making skills.
I'm looking for a designer who can craft a modern, minimalistic logo for my IT support business. This unique logo should include a symbol referring to technology such as a computer/laptop symbol, circuits, or a cloud. Requirements: - Use of cool tones, specifically blues and grays, to communicate our corporate image. - A minimal, sleek sans-serif, serif or script typeface. The choice is yours as I don't have any specific preferences. - The design should be innovative, portraying my business as a cutting-edge, modern IT support firm. - I would like the logo to be an symbol next to the company name Ideal skills: - Creative graphic design - Knowledge in modern logo trends - Familiarity with tech - Attention to details Please include samples of your previous work, espec...
I am looking to hire an experienced researcher who can find and compile a list of DIY YouTube influencers within United States with 20,000 to 100,000 followers. Looking to gather a list of upto 1000 influencers. List should include a mix of home diyers, garden diyers, craft diyers etc - i can provide a list of categories. Your task: - Identify and list popular DIY influencers on YouTube within the follower range. - Collect their contact details including their email addresses and social media handles. - If available, find any agencies they are associated with. Ideal Candidate: - Proficient in online research - Understands the YouTube platform and its influencers - Has a keen eye for popular trends within the DIY community. - Respect for privacy and only using lawful methods...
I am seeking residents of Munich, Germany to conduct an in-store check for a well-known Dairy brand. Project in a Nutshell: 20 SKUS (Products) need to be assessed for the following: Tidiness of shelves, package quality, time to find product and etc. 3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. Consumer will assess 31 samples per a product in total. No purchases required Products include water, plant based and diary. All data will be captured via an App thus good quality photos are needed. Answer questions related to the product via the APP. Full training provided. Requirements of the consumer: Tech Savvy. Promptly answers emails. Flexibility with time 4 weeks to complete Fee for project 1: €600. There is ...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
...E-commerce Marketplace Pro. Below are the specific requirements and details for this project: - **Theme and Plugins Setup:** I will need help with the setup of the E-commerce Marketplace Pro theme, WooCommerce, and Dokan. - **Feature Implementation:** The main features I want to implement on my eCommerce marketplace include: - Product Search and Filtering: Customers should be able to easily find products on the platform through a search function and filters. - User Registration and Login: Users should be able to create accounts on the marketplace, log in, and manage their profiles. - Payment Gateway Integration: I'd prefer to use Stripe as the payment gateway, so it needs to be seamlessly integrated into the platform. want it to be set up like eBay and Etsy (mu...
...complex script that combines SMC schools, ICT schools, and commercial use elements into a single Tradingview indicator. Here are more details on what I'm looking for: - The script should include various elements from SMC and ICT schools, as well as classic trading methodologies for commercial use. - The primary feature of the script will be the creation of a custom indicator on Tradingview. - This indicator should accurately reflect the principles and strategies taught in SMC and ICT schools, while also incorporating classic trading approaches. Ideal skills for this project: - Proficiency in Tradingview script development - Understanding of SMC and ICT trading methodologies - Knowledge of classic trading indicators and strategies - Ability to create...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based researc...
Hello, how are you all? I need someone who can write a script, and another person (it can be the same person) who can create drawings for a motion graphics video, approximately 4 minutes long. The required style is as follows, both in the script and in the drawings. Here are the project files that we can build the video upon.
I am looking to hire an experienced researcher who can find and compile a list of DIY YouTube influencers within United States with 20,000 to 100,000 followers. Looking to gather a list of upto 1000 influencers. List should include a mix of home diyers, garden diyers, craft diyers etc - i can provide a list of categories. Your task: - Identify and list popular DIY influencers on YouTube within the follower range. - Collect their contact details including their email addresses and social media handles. - If available, find any agencies they are associated with. Ideal Candidate: - Proficient in online research - Understands the YouTube platform and its influencers - Has a keen eye for popular trends within the DIY community. - Respect for privacy and only using lawful metho...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
...containing form data that I need converted into both HTML and PDF. The PDF version should be static, without interactive elements. - The conversion process can be done manually, using HTML and PDF editors, or automatically, for which you can suggest a suitable script or tool. You're also welcome to combine both methods if you believe it would be more efficient. - The HTML output should be easy to read and navigate. The PDF should retain this readability in a static format, making it suitable for printing and viewing but without interactive features. - You will have creative control over how to best represent the JSON form in these two formats. The end goal is to make the content accessible and user-friendly. I'm looking for a professional with prior experien...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data ...
I am working with GridCore library from .NET Core. I am having issues getting the column headers to be displayed with the filters added. Now, I am only able to display the column headers titles. I need someone that has proven experience using this library and can give me the solution.
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
...Python script with a HTML front end to allow a user to upload a CSV list of “prompts” and have each one sent as a request to the OpenAI API. There will be multiple prompts on each row. The script will need to move through each column, retrieve the output from OpenAI API, before moving onto the next row. The script should insert the result/text output from each column/prompt/request into a prompt output column of the CSV, then over onto the next row & then automatically download the updated CSV file for the user. Technical Requirements - Server Type: Ubuntu 22.04 - Script Type: Python - Front End Type: HTML - Front End Functionality: - Input API Key into a text field - Upload CSV File - CSV file template will be provid...
...to create a custom indicator using Pine Script v5 for the TradingView platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. My requirement will be as below; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, Trailing SL/Trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code debug...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forwar...
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I'm looking to find a specialist in YouTube advertising to help increase the in-store traffic for my business. The ads should cater specifically to local customers and utilize compelling video content that showcases the uniqueness of my store. Key Undertakings: - Build and implement a YouTube ad campaign targeting local customers - Develop engaging video content that effectively showcases my store Ideal Skills & Experience: - Expertise in YouTube advertising - Proven track record of driving store traffic through digital ads - Proficiency in creating visually appealing and compelling video content.
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...
write a headless chrome python script which will visit given list of URLs/websites aftear each config delay in seconds. script will use different ip in each iteration of list urls visit. it will keep running untill ip list end .
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
We want to have all images on our website converted to webp. So please run a parser over all pages of Collect all png and jpg and jpeg images Convert them to webp Do NOT change their names, except for the extension
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
To record final script and deliver ready to use audio. Prior to recording: Please send a clean version of your final script. Please confirm the vocal style, tone and pace you want, based on a specific part of the commecial demo you like. Delivery will be by the end of the next working day from acceptance of this quote. Please note that any client amendments to the final script after it is sent and recorded will be charged at $10 per line changed.
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
I am in need of a skilled WordPress developer who can help wi...cloud servers for WordPress sites, specifically using Cloudways - Digital Ocean servers. - Ideal if you have experience with installing pre-designed real estate websites and managing content uploads for clients. Key Project Details: - The primary goal of the WordPress website is to create Real Estate platforms. - Specific features needed include: - Property search functionality to help users find listings easily. - Integration of pre-designed real estate websites. - Content and property upload for clients to navigate and manage. I am looking for a dedicated and experienced professional who can manage these tasks efficiently and effectively. Please make sure you have the right experience and time commitment befor...
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
We are searching for a highly skilled and experienced developer to assist us in building robust API integrations using CloudQuery. Our project involves extracting and integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean...
...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 during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will b...
...vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the 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 - Abil...
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 our app until the song is finished. App is a new type of "collab dance app" where each user record dance on one small segment of any song (2-4sec) creating a new cool unpredictable music video. You need to try and test our app as well to understand it a bit. Key Responsibilities: 1. Check our Shopify Collabs Account and optimize it using our website, pictures, videos, reels, etc. You can create some pictures, reels as well. 2. Find Influencers using our Shopify Accoun...
I'm seeking an experienced Urdu comedy script writer capable of creating engaging, 10-15 minute long episodes for a YouTube comedy series. Your work should revolve around stand-up comedy, sketch comedy, and sitcom themes. The humor should be primarily satirical. - **Skills Needed:** - Comedy writing - Urdu language proficiency - Experience with YouTube content creation - Understanding of satire humor Apply if your wit can generate laughs and keep our viewers entertained episode after episode.
I am in need of a networking expert proficient in Squid Proxy and Linux. The task involves creating a script that automatically turns a vps with a subnet into a residential proxy pool It's an ideal project for a developer who's well acquainted with Squid Proxy, understands network firewall setup, and has experience in dealing with Linux-based VPS. Running networking diagnostics would also come in handy as the task may involve troubleshooting any potential connectivity issues that may arise during setup.