Use script excel vba jobs
I need help with a Python script that downloads a Tableau dashboard as a PDF, and uploads it to a specific WebEx group. This script needs to be scheduled to run daily at 4 PM, using a GitLab job pipeline. Key requirements: - The script will need to use an API token for authentication with Tableau. - The naming convention for the downloaded PDF files should be "Dashboard name with date". - Experience with Python, Tableau and GitLab is necessary. -
I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features -...
I need an experienced Google Apps Script developer to modify my existing Google Sheets script. The script currently runs every 6 hours, but I need it to only execute when a specific condition is met. Key requirements: - The script should run a backup (using an already set up script) when the cell displays the number "0". - The script currently runs every 6 hours, and this time-based trigger should remain in place. Ideal skills for this job include: - Proficiency in Google Apps Script - Experience with Google Sheets - Strong problem-solving skills
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...
Hi everyone, I am looking for a freelancer who is able to create a script for me to import product images (with a CSV file) in Magento 1. Based on the product SKU, it needs to import the product image. This image will be used as first priority for all image display options. Current products already got an image, but our imported image should be the first priority. It needs to be imported in the default store, as my other store views will use the default store image (settings). New product images are available in var/import location on the server. We will first work on my develop server. When the import works, we will apply it on the live server. Looking forward to hearing from you. My maximum budget for this task is €30.
I'm seeking a skilled Python programmer to automate the handling of mixed data inputs into an Excel spreadsheet. The data, which encompasses both text and numerical components, needs to be updated on a weekly basis. Key Requirements: - Proficiency in Python, specifically in automating Excel processes. - Experience in handling and processing mixed data. - Ability to set up a weekly data update system. Ideal Skills: - Python programming - Excel automation - Data processing and handling I look forward to your bids.
I'm looking for an Excel expert with strong skills in data analysis and financial modeling. Key Responsibilities: - Conduct thorough data analysis using Excel - Build and implement valuation models - Utilize market data and economic indicators for the analysis Ideal Candidate: - Proficient in Excel with a focus on data analysis - Experienced in constructing and using financial models, specifically valuation models - Capable of sourcing and interpreting market data and economic indicators - Strong attention to detail and analytical thinking skills - Excellent communication skills to explain complex data in a simple way.
...data collection specifically aimed at tracking inventory. Key Features: - The app should allow for the input of data in the form of photos and manual entries. - It should combine this data and output it in the form of Excel spreadsheets and embedded graphs with pictures. - The app should generate pie charts based on the inventory data. Ideal Skills and Experience: - Strong background in Android app development and data collection apps. - Experience with integrating multimedia data (photos, manual entries) in apps. - Proficiency in creating apps that can output data into Excel and generate graphs. - Knowledge of designing apps with visualization tools like pie charts. This project requires a developer who is able to create an intuitive and efficient app for tracking inve...
Searching for a native Portuguese speaker to make calls through VOIP to leads in Brazil who have already expressed interest. You will be following a script that I provide. An average call lasts about 15 minutes. We can start from $10 per call. This position can potentially be permanent.
I'm seeking assistance in creating an Excel tracking sheet designed for work in the office. This sheet will primarily handle project timelines and needs to incorporate various advanced features such as macros, RAG rating codes based on project phases, and the ability to grey out areas or flag items. Key Requirements: - The tracking sheet will need to have macros to achieve RAG rating codes. These codes should categorize tasks based on the project phase. - The sheet should allow for grey-out of certain areas, specifically those marked as 'Task on Hold'. - There should be a separate sheet that automatically flags items marked as 'In Play'. Ideal Skills: - Advanced knowledge of Excel, particularly in creating and implementing macros. - Prior experience...
I'm in need of a professional who can prepare a comprehensive project progress report, to be delivered weekly in an Excel format. Key Components of the Report: - Task Completion Status: I want to know how far we've come in terms of task completion. - Deadlines and Milestones: It's crucial to track whether we're hitting our deadlines and milestones. - Resource Allocation: An overview of how resources are being used is also necessary. Ideal Skills and Experience: - Proficient in Excel with experience in project management reporting. - Strong understanding of task tracking, milestone setting, and resource allocation. - Excellent attention to detail and ability to present data clearly and concisely.
I'm looking for a creative and detail-oriented individual who can take a script and transform it into an engaging, visually enriched story with a natural-sounding voiceover. Key aspects of the project: Audience: The script is educational, aimed at adult learners, requiring a balance of professionalism and approachability. Tone: Storytelling should have a conversational, engaging tone with personality and occasional humor to keep the audience interested. Visual Content: Visual elements need to effectively complement and enhance the narrative, including appropriate graphics, animations, or stock footage. Voiceover: Voiceover can be AI-generated but must sound natural, warm, and engaging, avoiding overly robotic tones. Length: The final video will be approximately 15 ...
I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features -...
Looking for a person who can do accounting data entry in Tally and Excel and some easy to use software. Person should have his laptop and prior experience of tally and Excel. Monthly fee around 7000 depending upon profile..Only from India
Looking for an experienced proofreader to review my film script. It’s approximately 120 pages and has been through several edits already. Your focus should be on spotting errors, maintaining consistent tone, and polishing the dialogue and structure where necessary. Familiarity with screenwriting formats (like Final Draft or similar tools), attention to detail, and strong communication skills are crucial. I’m on a tight budget as a senior on Social Security, so affordability without compromising quality is key.
I'm looking for a skilled developer experienced with the Whisper JAX model for audio transcription. Primarily, I need this for translating audio recordings of conversations into written text. Key Requirements: - Transcription of audio file with accurate timestamp in English and Hindi - A static website to upload audio file either single or in batch. - Delivery of transcriptions in an Excel file Ideal skills and experience: - Proficiency with the Whisper JAX model - Experience in developing web-based transcription services - Excellent understanding of English and Hindi for accurate transcription - Ability to deliver transcriptions in a specified format.
...while also conveying simplicity and modernity. Key Requirements: - Design a primarily wordmark logo with the potential for a text-symbol combination. - Incorporate an elegant script font into the design. - Create a logo that conveys luxury, sophistication, simplicity, and modernity. The logo will be used across various mediums including social media, our website, business cards, and clothing tags and bags. Therefore, it needs to be versatile and visually appealing on all platforms. Ideal Skills: - Extensive experience in logo design, particularly for fashion brands. - Proficiency in working with elegant, script fonts and creating minimalistic designs. - Ability to convey complex emotions and messages through simple design elements. Please share your portfolio showca...
We are looking for experienced and passionate educators to join our team as faculty members for GPSC/UPSC exam preparation. We would love to hear from you if you have in-depth knowledge of the subjects, excellent teaching skills, and a commitment to helping students excel. Requirements: - Proven teaching experience in GPSC/UPSC coaching. - Expertise in History, Geography, Science & Technology, or Art & Culture. - Strong communication and presentation skills. - Ability to develop and share study resources (notes, PPTs, etc.). - Familiarity with UPSC/GPSC syllabus and exam trends.
...LinkedIn, Lusha, ZoomInfo, LinkedIn Recruiter, and Apollo.io. Identify potential candidates based on job titles like Inside Sales Representative, Lead Inside Sales, Inside Sales Manager, and Sales Coordinator. Collect and organize name, job title, company, location, LinkedIn profile, email, and phone number. Ensure data accuracy and relevance for headhunting. Deliver structured reports in CSV or Excel format. Requirements: Experience in data scraping, lead generation, or recruitment research. Proficiency in tools like Lusha, ZoomInfo, LinkedIn Recruiter, , and PhantomBuster. Strong research and analytical skills to verify and validate contact details. Ability to work independently and meet targets. Preferred Qualifications: Prior experience in recruitment, B2B sales intelligence,...
I'm in need of a Tamilnadu local professional who can help me gather contact information of potential life insurance customers in Tirupur. Requirements: - Collect and compile contact information of willing customers. - Deliver the information in a well-organized Spreadsheet (Excel/CSV). - Ensure all data is collected with customer consent via an online form. Ideal Skills: - Proficient in data collection and spreadsheet software. - Knowledge of online form tools for customer consent. - Experience in the insurance industry is a plus. I appreciate your attention to detail and commitment to ethical data collection. Looking forward to your proposals.
...compounds, such as OSR (Emeramide, NBMI). This research project will delve into different regions of the spectrum, including visible light, Raman, and potential low-frequency vibrations. Key Tasks: - Select appropriate software for the task. - Develop a suitable process (potentially a script) for analyzing any substance given its formula and structure. To be considered for this project, you must demonstrate: - Your expertise in computational chemistry. - Your proficiency with the software you're planning to use. Fields of Interest: While there are no specific compounds or spectrum types set in stone, a focus on organic compounds and the Raman spectrum could be beneficial. The key outcomes of this analysis will be to identify characteristic peaks, understand molec...
...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Ex...
I need an experienced developer to enhance my TradingView indicator by adding a specific alert feature. The source code is readily available. Details: - The alert should be triggered by price level alerts. - Notifications should be sent to my app on iOS, Android, and Desktop when the alert triggers. Ideal Skills: - Proficiency in TradingView Pine Script. - Experience with app notification systems. - Prior work on trading indicators would be a plus.
...elementor - ideally you are designer background with strong skills in WordPress - Strong understanding of e-commerce best practices - Ability to create engaging website content - Familiarity with PayPal integration for e-commerce sites Please note, the site must be fully prepared and content ready for launch. Extra info: It's just 18 products. Need to remove background from images and there is excel file with detail on that product. Rest of content you need AI assistance to generate data that is relevant. This job will suit someone who is to take ownership and launch site like their own and intend to continue to work on it in regular engagement after launch rather than a one of task. In your application, please send me link of 1-2 WooCommerce sites you have done in wome...
I need someone experienced with WordPress and product uploads to help me upload two Excel sheets of products to my site. - One sheet contains over 3,000 products with compressed images. - The other has about 40,000 products without compressed images. I would like to know if I can upload the compressed images later in bulk after the 40,000 products are uploaded. Please let me know if this is within your capabilities. Ideal candidates for this project should have: - Proven experience in WordPress product uploads - Ability to handle large data sets - Understanding of bulk image uploads - Excellent attention to detail to ensure every product is listed correctly. I have attached the file. Please import the products on your website to show me and apply for the job.
I'm seeking assistance with comprehensive data analysis in Excel, as well as generating reports and creating formulas. The job also involves sending multiple email attachments via Gmail. Ideal skills and experience for the job: - Expert level proficiency in Excel, particularly in data analysis, formula creation, and report generation. - Experience in managing and sending multiple email attachments through Gmail. - Strong attention to detail and ability to work efficiently.
I'm seeking a skilled data entry professional to assist with cleaning and formatting my Excel spreadsheets. The primary task will be identifying and removing duplicates from the data sets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data cleaning and formatting Please bid only if you can deliver quality work promptly. Thank you!
i need a website scraped in the craft area the headings are Name Description sku price image url Diamensions Weright isbn format page url pages Autoir in excel format url script built
...and export them automatically to Google Sheets, including carrier details, costs, and estimated delivery times in dedicated cells. Create shipping order: Generate the shipping order directly in Sendcloud using the data provided in the spreadsheet. Key Requirements: Strong knowledge of REST APIs and the ability to work with API documentation (specifically Sendcloud). Experience with Google Apps Script or similar tools to automate Google Sheets. Ability to implement conditional logic, such as applying percentage markups to calculated prices. Familiarity with the shipping workflow: rate calculations, listing options, and creating orders. Attention to detail and thorough testing to ensure smooth and reliable automation. Primary Tasks: Configure API calls for required functions (rat...
I need a skilled programmer experienced in Python or Node.js, who can create a script for me that will parse Google SERP data through our rotating proxy provider. The script needs to extract data points such as Titles and URLs, Meta descriptions, and Search result rankings. Key Requirements: - The script should run daily as an API enpoint which will get settings for scraping (google domain, language code, country code, proxy settings, keywords) - The output data needs to be in JSON format Since Google has recently updated its system to block bots/scrapers, the script needs to effectively navigate through this challenge. Experience with web scraping, working with proxies and understanding of Google SERP is a plus. Please apply if you have the relevant skills a...
I need a specific excel sheet made up for me. Instructions for excel sheet: First, there should be cell A designated for company name. Cell B will be "customer cost" where the "single letter" value will be entered (see values/definitions below). Cell C will be "number of licenses" and will be a numerical value input by the user. Cell D will be the product of cell B multiplied by cell C. cell B multiplied by cell C equals cell D (p) * 10 = 100 (p) = 10 (see values/definitions below) cell A = MOCK company A cell B = (p) cell C = 10 (numerical value input by user) cell D = 100 Then, cell E will be "MSP cost" and will be the "double letter" value entered. Cell F will be the product of cell C multiplied by cell E. cell E mul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I need a detailed proofreading of my adventure game script. The main focus areas will be the character dialogue and the overall story flow and coherence of the script.
I'm in need of an Excel expert to assist me with a data transfer task. This involves pulling information from one spreadsheet and adding it to a column in another. Key Tasks: - Transfer of text data from one spreadsheet to another - Matching of data based on an exact match in a single column - Formatting of some data during the transfer The data in the spreadsheets is a mix of both specific categories and plain text columns, and there are more than 1000 rows that need to be transferred. Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks - Ability to perform basic data formatting and transformation
I'm looking for a script that can help me manage my Snapchat friends on my iOS device. This script should automatically remove friends who are inactive. Key Features: - The script should only work on iOS. - It should remove friends who are identified as inactive. This includes friends who have not sent me any recent stories, have not sent me any recent messages, and have not been active for a set period. Ideal Skills: - Proficient in iOS scripting. - Familiar with Snapchat's friend and story interface. - Experience with creating scripts for social media management. Please provide examples of similar projects you've completed in your bid.
I'm looking for a freelancer who can compile a comprehensive list of stock codes for all companies per year from the specified website - A spreadsheet should be created with a tab for each yea...from Yahoo finance. For example, where the company name is Apple, I would expect the code AAPL to be returned. The specific requirements are: - The stock codes should be taken from Yahoo Finance - The data should only include the stock codes, not historical data or current status. - The final deliverable should be in an Excel file. Ideal skills and experience for the job: - Familiarity with stock exchanges and their coding systems. - Proficiency in data compilation and Excel. - Attention to detail for ensuring accuracy of stock codes.
I'm seeking assistance to extract data from a conference website. The task involves gathering information on all attendees and their respective companies. Key Requirements: - Extract a list of attendees and their in...attendance (one column: Company). The data needs to be extracted from a publicly accessible section of the conference website. The task needs to be completed before noon EST on January 21st. I will make a decision on whom to select by 9:00pm EST on January 19th. Ideal Candidate: - Previous experience with data extraction and web scraping is preferred. - Proficient in using tools like Python, Excel, or any other data extraction software. - Attention to detail to ensure accurate data collection. Successful execution of this project may lead to future work on a...
I have an Excel database consisting of 100,000 records of loan requests along with their acceptance status. I need a freelancer with strong expertise in Python, data manipulation and AI to develop an AI model that will evaluate new loan requests and predict their approval status based on the training from this dataset. Key aspects of the project: - Data Preprocessing: The data will require normalization, handling of missing values, and feature extraction. - Model Development: Using Python, you'll build an AI model to train on the database. - Prediction: The model will assess new loan requests and indicate if they should be accepted or rejected. The ideal candidate will have extensive experience with AI model development, and will be proficient in Python, and data manipulati...
I'm looking for an AppleScript expert who can help me automate the printing of a PDF document from my local storage. The project involves writing a script that will send the document to my printer when executed. Ideal Skills: - Proficiency in AppleScript - Experience with automating print commands - Familiarity with Mac OS Please provide examples of similar projects you've completed.
I'm looking for an expert in Excel to help me create a special spreadsheet that will collect and organize vital customer information. This project will involve detailed manual data entry. Key Requirements: - Collecting customer contact details (name, phone, email) and purchase history. - Organizing this data in an efficient and easy to understand manner in Excel. Ideal Skills: - Proficiency in Microsoft Excel. - Excellent attention to detail for data accuracy. - Experience with data entry and data organization. - Good understanding of customer data and purchase history. Please note, the data will need to be entered manually, so patience and diligence are essential for this task.
Modifying existing pine scrip codes
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. call required before offering job to go over important details of the job NO EXCUSES POOR QUALITY WORK WILL NOT BE PAID ANY CRYING OR ABUSE WILL NOT BE TOLERATED ALL I AM AFTER IS FAST HIGH QUALITY WORK FROM A PROFESSIONAL. IF U CANT DO IT DONT APPLY. REMEMBER IM HIRING YOU COS I DONT HAVE THE TIME TO DO IT MYSELF. I CAN DO THESE IN MAX 3 HOURS PER SHEET. 1 SHEET ON AVERAGE SHOULD TAKE 3 HOURS. LATE WORK WILL BE PAID AT A REDUCED RATE AND ALSO ANY MISTAKES MUST BE ELEMENTARY. WORK MUST BE ALMOST PERFECT ON FIRST DRAFT AND PERFECT ON SECOND DRAFT OR PAY WILL BE REDUCED. DO NOT DEMAND PAY FOR WORK FULL OF ERRORS IF I SAY THE WORK IS POOR T...
I'm looking to bui...comprehensive e-commerce site, ideally using a React.js Backend with a Tailwind front end, or PHP/Laravel. The site needs to have several key features including: - Shopping functionality - UPI payment integration - WhatsApp API integration - Ability to upload products via CSV/Excel sheets - User recommendation form connected through WhatsApp API for scheduling meetings I would prefer MySQL as the database for this project. The admin panel should specifically allow me to manage product inventory. User accounts will use standard email/password, social login authentication. New freelancers are welcome to bid, but you need to demonstrate your skills or provide a detailed plan on how you intend to execute this project. Please share any relevant projec...
I'm in need of a comprehensive database containing contact information for Real Estate Professionals (Agents and Brokers) associated with @properties, covering all cities they operate in. The data should be structured in an Excel spreadsheet and must include: - Name - Address - City - Email (Any email addresses available) - Phone number - Company name Key Requirements: - I'm looking for as many contacts as possible, ideally in the thousands. - The email addresses do not need to be verified, but any available email is acceptable. - Prior to engaging in further conversation, I would like to see at least 10 examples of the data you've gathered. Please note that this task may be straightforward for those experienced in data scraping. A successful completion of this pro...
I'm seeking a corporate and professional style promo video for a product targeting B2B clients. The video should succinctly showcase the product's features and benefits in a way that resonates with business clients. Ideal skills for this project include: - Video production and editing - Script writing and storyboarding - Understanding of corporate communication Experience with creating B2B product videos is a definite advantage. Please provide examples of similar work in your portfolio.
I have a PHP script that needs urgent work. The project involves integrating a third-party marketing API into the PHP script. Ideal Skills: - Expert in PHP script development - Experience with third-party API integration, particularly marketing APIs Please only bid if you can start working immediately. Thank you.
I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.
I'm seeking an expert v...voiceover artist to create a professional tutorial video demonstrating our sign-up process. This 30-45 seconds video, intended for both our customers and sales agents, will guide viewers on how to complete our sign-up link. Key Requirements: - The video should not just capture the screen but also include a voiceover (VO) in a formal and professional tone, ideally in an American accent. - I have a script that can assist, but I also expect your expertise in making the video engaging and clear. Branding: - The video will need to incorporate our company logo, brand colors, and brand fonts. Ideal skills for this project include video production, screen recording, voiceover, and understanding of brand consistency. Experience creating tutorial or promo vi...