Excel vba automatically run script jobs
I'm looking for a skilled programmer based in the USA to help me with automating two key tasks: 1. Automatically updating a Google Sheets spreadsheet with our Shopify promotions on a daily basis. 2. Daily updates to another Google Sheets spreadsheet with our loyalty points/rewards categorized by product. This project is essential for feeding supplemental data to Google and streamlining our promotional and reward tracking.
...```python updated_qty[index + 10] = desired_qty[index] ``` - If `desired_qty[index] <= desired_qty[index - 1]`, then: ```python updated_qty[index + 5] = desired_qty[index] ``` - Ensure this is handled without using loops, `iterrows`, or `itertuples`. The entire process must be vectorized for performance. --- ### Deliverables: 1. A Python function/script implementing the vectorized solution using Pandas. 2. Verify correctness by ensuring the output matches the provided "before" and "after" CSV files. 3. Provide clean, well-documented, and maintainable code. --- ### Notes: - The solution **must not use loops** or row-based iteration functions like `iterrows` or `itertuples`. Efficiency is critical. - Use Panda...
I'm looking for an expert to integrate my MS 365 email alias with HubSpot Helpdesk. The goal is to have client tickets automatically generated from incoming emails. Scope of Work: 1. Email Alias Integration: - Integrate our existing email alias (e.g., support at ) with HubSpot Helpdesk. - Ensure emails sent to the alias automatically create tickets in HubSpot. - Configure email forwarding or direct connection for smooth integration. 2. Ticket Automation: - Set up rules for ticket creation, including auto-assignment, priorities, and tagging. - Ensure proper threading of email replies with corresponding tickets. - Testing and Validation: - Test the email integration to ensure that all emails create tickets accurately. Requirements: - Seamless integration between MS 365...
...Support multiple vehicles with a specific layout. 3. Incoming Invoices: • Add a column for “Client/Agent.” • Enable sorting by month/year/agent. • Fix errors when uploading and viewing receipts. • Repair functions in the status and action section (e.g., preview, editing, and downloading). 4. References and Transport Orders: • Add missing vehicle types and correct spelling errors. • Automatically refresh the page after adding a transport order. 5. Shipment Status: • Fix the error with “Pickup Scheduled.” 6. PDF Generation: • Enable generated documents to be sent directly via email with a pre-filled subject and message. 7. Multilingual Support: • Make the entire site available in multiple languages. ...
I'm in need of a Windows-based bot that can help me secure appointments with the BLS in Mauritania. The bot's responsibilities will include: - Entering the appointment calendar and monitoring for available slots - Sending me a push notification as soon as a slot is available - Automatically filling out and submitting the necessary forms - Skipping all setup steps before payment Ideal candidates for this project should have extensive experience in bot development, particularly for Windows, and a proven track record of creating reliable, automated systems. Understanding of BLS appointment procedures will be a plus.
...notifications. Push notifications are also desirable. - Advertising sections: There should be segments on the site for advertising various services, specifically funeral-related products, grief counseling services, and memorial planning services. It should also include advertising for upcoming funerals and anniversaries. The initial target market for the site is Ireland, but it is important that the script is adaptable for replication in other markets. Ideal skills for this job include: - Web Development: Proficient in creating user-friendly and responsive websites. - Backend Development: Experience in developing secure login systems for different user roles. - Notification Systems: Knowledge in integrating mass notification systems, especially with email and WhatsApp. - E-comm...
I'm seeking an Excel expert who can create a comprehensive spreadsheet for tracking employee utilization and project projections for 2025. This spreadsheet needs to accommodate various employee details and provide quarterly projections. Key Requirements: - Include specific employee details: Name and ID, Department and Role, Experience Level - Track utilization on an individual employee basis - Input employee rates and hours on projects - Incorporate fringe benefits and PTO - Provide functionality for quarterly projections Ideal Skills and Experience: - Proficient in Excel with advanced spreadsheet skills - Experience in creating utilization and projection spreadsheets - Strong understanding of employee management metrics - Ability to deliver a clear, user-friendly spre...
My Selenium-based Excel tool is giving an error message upon starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity with Chrome an...
I'd like to request a quote for "I need some support with my existing automation script... Automation scripts are already developed and my developer gave some feedback, so we need to update the script based on the feedback. Scripts are in javescript in cypress tool.
Executive Assistant Role Flexible schedule Need 2-3 days a week during pacific time to work on live task - from 10am till 1 pm PT Time Other tasks can be worked at your own time efficiently Required: Someone who can talk on the phone confidently and clearly Efficient Organized Honest Able to work on task with a quick turnaround High attention to detail an...independently with minimal supervision. Strong communication and interpersonal skills; making calls, getting quotes, making appointments STRONG follow up skills Job detail: Executive Assistant Varies from talking to vendors to researching Calling for quotes Coordinating with other parties complete tasks given in timely manner Paying for material cost Organize the expenses for materials on excel Organize to do l...
...links* (remove duplicates). 4. Associate each link with an image so that clicking the image will redirect to the corresponding URL. 5. Host the application on my domain, ensuring it's easily accessible online. I believe this project may require a *web crawler* or similar scraping technology to efficiently collect and process the data. *Deliverables:* • Fully functional application/script. • Hosting setup and configuration on my domain. • Documentation on how to use the application. *Skills Required:* • Proficiency in *JavaScript* or *Python*. • Experience with *web scraping* and *web crawlers*. • Understanding of *HTML* and *IFRAME structures*. • Expertise in *web hosting and deployment*. ...
...Each role should have its own unique interface and permissions. - Project Submission Functionality: The application needs to support project submissions complete with file uploads, an approval workflow, and submission tracking. - Auto Escalation: A pivotal feature of this application is its auto escalation capability. This means that if a project is stalled or not moving forward, it should automatically escalate to the next level in the hierarchy. Ideal Skills: - Proficiency in web application development is crucial. - Experience with creating role-based interfaces is highly desirable. - Familiarity with project management tools and their functionalities will be a significant advantage. The end goal is to have a seamless, user-friendly web application that can efficiently hand...
I'm seeking a talented scriptwriter to create a romantic and heartfelt ceremony script for my upcoming wedding. This should incorporate specific cultural elements, making the script resonate deeply with our heritage. Ideal candidates should: - Be skilled in writing emotional, romantic scripts - Have a good understanding of various cultural elements - Possess experience in writing wedding ceremony scripts Your role will be to craft a memorable script that guides us and our guests through our special day. Please submit examples of your previous work, particularly any wedding scripts or similar, along with your bid.
I'm having a problem with my Laravel application where the system is not saving certain order details during the create process. This issue is hampering the functionality of the application, and I need a professional who can debug the create functionality in the application and rectify the problem. Ideal Skills and Experience: - Extensive experience with Laravel framework - Proven track record in debugging and fixing Laravel applications - Proficient in working with order records and e-commerce systems - Strong problem-solving skills - Ability to work under tight deadlines
...backend, and the receptionist service powered by Twilio + Python, utilizing the OpenAI realtime API. Key features of the AI receptionist: - Basic inquiries handling using a knowledgebase provided by the customer - It should be able to book calendar appointments using the customer's Calendly (Calendly API may be required) - Support multiple languages (Realtime API should be able to do this automatically) Key features of the web app: - It should allow the user to purchase a phone number from Twilio, log information in MySQL database - It should allow the user to choose a service plan / price and pay with Stripe, log these transactions in MySQL database - It should allow the user to review past calls, see a call summary, review the entire call transcript, hear the call reco...
need multi sheets that have a list of materials per phase( lighting, branch power, fire alarm, risers ,telecom, site) into one master material list tat can be added to if phase list changes.
I have a landing page on with a lead generation form. This landing page will need to use several specific UTM links for each collaborators (downline). I need a javascript implemented that will automatically copy the entire UTM link that is used to access the landing page into a specific field of the form that I have chosen. - The UTM link should be copied into the 'downline' field of the form. - The purpose of this is to track referrals of new registered users. The ideal freelancer for this project should have: - Strong proficiency in JavaScript. - Previous experience with or similar platforms. - Understanding of UTM links and their tracking functionality. - Ability to deliver clean and efficient code.
I need assistance with fixing a nested IF(OR) function in Microsoft Excel. My current formula works for applying two IF(OR) conditions, but I am encountering an error when trying to add a third condition. - The formula is designed to check if a variable matches one of a set of names, returning one value, and if it matches another set of names, returning a different value. - The third condition involves matching the variable against specific text or names. - I have the specific names for the third condition ready to provide. I believe the issue is a syntax error, and with your expertise, it should be a quick fix. Your proficiency in Excel and experience with complex formulas will be key to resolving this issue swiftly. Here is the part that works: IF(OR(M2="CHINA&quo...
I'm in need of a talented developer who can integrate the Roblox MM2 (Murder Mystery 2) game onto my Shopify site, with a main focus on creating an Auto Delivery Bot. This bot should be able to send game items to players automatically, with the ability to select recipients based on their usernames. Key Requirements: - **Auto Delivery Bot**: This system needs to be efficient and reliable in dispatching game items to players. - **Tracking Deliveries**: The bot should be capable of monitoring the status of each delivery. Ideal Skills: - **Roblox Game Development**: A rich experience in Roblox game creation or modification is crucial. A deep understanding of game dynamics and items, as well as their integration into a website, is a must. - **Bot Development**: You should have a ...
...authomatic report. The queton sof jotform and the answer of jotform must be saved inside my mysql databese, so it is necessary make these changes. And it is necessry show the report inside a web page and create a pdf. The report must have an excellent design, chart and tables create with the information of report of AI. So it is necessary use inside the report page shortcode and connection with a chart script. I asked the steps to OpenAI how create connection to Ai using jotform. I think that is simple solve. I attach the answers. ________________________________________ Using Jotform for WordPress Steps: 1. Creating the Questionnaire on Jotform: o Sign up for a Jotform account and create the form using their editor. o Embed the form on your WordPress site using the Jotform ...
I'm in need of a skilled scriptwriter from India to help develop a script for a drama film. The primary focus of this role will be on character creation. Your task will be to help breathe life into the characters, making them relatable, interesting, and integral to the story. Ideal skills and experience for this job include: - A strong background in scriptwriting, particularly for drama films - Exceptional character creation skills - A deep understanding of Indian culture and sensibilities - Ability to write in English with a high level of proficiency - Experience working with scripts intended for film
I'm in a dire situation. I've lost everything on my WordPress website - blog posts, user data, e-commerce data, all of it. Although my site was backed up automatically, I'm currently unable to access these backups. I need an expert who can both gain access to my backup files and restore the site to its former state. Skills and Experience Required: - Proficient in WordPress - Experience in data recovery - Familiarity with WordPress backup systems - Excellent problem-solving skills - Capable of working under pressure This is an urgent project and I would appreciate a prompt response. Thank you.
...compatible with the Fyers API to execute my algorithmic trading strategies. Speed is of utmost importance due to the high-frequency nature of the trading environment—every millisecond counts. Key Features Required: 1. Real-Time Market Data Fetching: The program must fetch real-time market data for seamless execution of trading strategies. 2. Automated Order Execution: The program should automatically execute buy and sell orders based on the logic provided. 3. Custom Trading Strategy Implementation: The code should incorporate the following indicators to evaluate entry conditions effectively: - Volume and Moving Average on Volume - Open Interest and Moving Average on Open Interest - VWAP (Volume-Weighted Average Price) - RSI (Relative Strength In...
I'm looking for a Python developer with experience in financial markets and automated trading systems. I need a script that integrates with Interactive Brokers' API to execute a momentum trading strategy. The scope of the project includes: - Writing a Python code that automates trading based on momentum strategies - Ensuring the code integrates smoothly with Interactive Brokers - Implementing proper risk management protocols within the code - Making the code easy to understand and modify for future use The ideal freelancer for this project should have: - Proven experience in Python programming - Prior work with Interactive Brokers' API - Strong understanding of momentum trading strategies - Ability to implement risk management protocols in trading code - Good commun...
I need a skilled developer to create a WebADI solution for uploading quality collection records from an Excel spreadsheet into Oracle EBS tables. This will specifically involve inspection results. Ideal skills and experience: - Proficient in Oracle EBS and WebADI - Experienced in handling Excel spreadsheets - Familiar with quality control data - Able to create efficient data upload solutions - Experience in developing and using APIs for data integration
I'm looking for a VBA script that will help me manage my schedule more efficiently. The script should take a list of appointments from an attached file and do the following: 1. Insert the appointments into my Outlook calendar according to the specifications in cell B3. 2. Send the appointments to the email addresses listed in column M. The script should be set to run manually, not automatically. I also need assistance deciding on the format for the email notifications. The options are Plain text, HTML, or Rich text. Ideal skills for the job include: - Proficiency in VBA - Experience with Outlook - Knowledge of email formatting Please let me know if you need any further information to give a bid.
Bot 1: Automated Messaging Bot Objective: Create a bot that integrates with Instagram, Facebook Messenger, and WhatsApp to respond to incoming messages automatically based on predefined instructions and data. Requirements: 1. Platform Integration: Connect the bot to the APIs of Instagram, Facebook Messenger, and WhatsApp. Ensure the bot complies with the platforms' API policies, including rate limits and message types. 2. LLM Integration: Use a Large Language Model (e.g., ChatGPT, Claude) to process incoming messages and generate responses. The bot should send the generated response back to the user on the respective platform. 3. Configuration: Allow me to provide predefined instructions and data for the bot. Include an interface or simple method to update these inst...
I need assistance with data entry from my handwritten notes into an Excel spreadsheet. The task involves transcribing text data from these notes into the spreadsheet. Ideal Skills: - Proficient in Excel - Excellent typing skills - Attention to detail - Experience with data entry from handwritten notes Please ensure to maintain the confidentiality of the content of the notes.
I'm looking for an experienced programmer to convert 3 custom Pine Script indicators into Easy Language. The primary focus of these indicators is plotting line graphs. Key Requirements: - Proficient in both Pine Script and Easy Language - Experience with programming custom indicators - Able to accurately translate the logic and functionality of the Pine Script indicators into Easy Language - Capable of implementing line graph plotting in the Easy Language version The project involves taking my custom Pine Script indicators, which are currently designed to plot line graphs, and converting them into equivalent Easy Language indicators. Please reach out if you have the relevant skills and experience.
I'm looking for a professional who can create an engaging and comprehensive sales dashboard in Excel (or Power BI). The dashboard should feature: - Key Metrics: Total Sales, Sales by Region, Monthly Growth Rate, Sales by SKU, Conversion Rate, Average Deal Size, Sales Cycle Length, Sales by Channel Partner, Sales Forecast Accuracy, and AR (Cash Billed/Collected). - Features: Interactive charts, Automated updates, and an aesthetically pleasing design. Ideal candidates should have extensive experience with Excel and/or Power BI, and a good understanding of sales metrics. Proficiency in creating interactive, automated dashboards is crucial. A keen eye for design and the ability to present data in an engaging way is a must.
I have got this. Here is all information Want need is Do Full setup and installation which includes server setup, apps setup, branding and publishing to stores android and IOS
I have a confidential order flow strategy that I need converted into a script for GoChart to trigger alerts based on specific conditions. Although the specific conditions for the alerts have not yet been defined, I am open to suggestions based on the capabilities of GoChart and the nature of my strategy. Ideal Skills: - Experience with GoChart - Proficient in scripting for trading platforms - Understanding of order flow strategies - Ability to convert complex strategies into simple scripts - Good communication skills for discussing potential alert conditions Please note that the details of the order flow strategy are confidential and will be disclosed only after the project is awarded.
I have a football manager game. It runs under PHP 7.0 and TWIG. If you make extensions to this script, new files are created, which are then copied into the relevant directories and are then recognized and integrated by the script. NO changes need to be made to the existing script. So just program new files and copy them in. I am now looking for someone who can write me an appointment calendar module that can then be integrated into the game. I am interested in a long-term collaboration because I have other ideas that I would like to implement. Here is a description of the module I want. With example images: Calendar/appointment calendar module: The basic functions are: (I have attached various example images, overwritten with translations) INFO: The font that I ins...
... it must be possible to make specific (user) settings for every copied wallet. - Statistics for the user must be made visible on a dashboard view, with open positions per wallet and the PnL %. - From the statistics view, it must be possible to sell the position automatically, for x % , or 50 % or 100%. - Reporting about transactions must be possible either by e-mail or telegram. It must be editable by the user. Backend requirements: - The backends connects automatically with the popular exchanges like: Jupiter, Raydium, Orca and - The backend needs to be as fast as possible. The transactions of the wallet to be copied needs to be executed within milliseconds after the original wallet did the buy or sell, with t...
I need an experienced Excel professional to make some adjustments to my existing budget proforma. Key Tasks: - Update existing formulas to incorporate new data - Create complex formulas for advanced analysis - Add new sections for revenue projections, expense breakdown, and cash flow analysis Ideal Skills and Experience: - Proficient in Excel with advanced formula creation skills - Experience in budget planning and financial analysis - Able to work with and incorporate new data into existing frameworks
My Python Selenium script for checking emails, which integrates 2captcha and proxies, is taking longer than desired. I need a freelancer to help optimize the script for speed, potentially using multiprocessing. Current Script Runtime: The script currently runs for 1-5 minutes. Identified Bottleneck: The slowest part of the script is the Captcha solving. Requirements: - Extensive experience with Python and Selenium - Proficient in script optimization and multiprocessing - Familiar with 2captcha and proxy integration - Able to work within existing script parameters (no changing of captcha service) I am seeking a professional who can deliver a faster running script, improving my email checking efficiency.
I need two of my financial spreadsheets re-created in an editable Excel format. Key Requirements: - Both formulas and text need to be editable. - The recreated spreadsheets should visually match the originals. - No charts or graphs are included, which simplifies the project. Ideal Skills: - Proficiency in Excel is a must. - Attention to detail is crucial to ensure the recreated spreadsheets match the originals visually. - Experience with financial spreadsheets will be a plus.
...solution and can modify it to meet my needs quickly. The project budget is limited to $200. Key Requirements: - Pre-existing shopping mall solution: You should have a ready-to-go shopping mall solution that can be customized and deployed quickly. - Fast development: I need this project completed in a short time frame. - Automated product registration: The solution should include a function to automatically crawl and register shopping mall products. - Translator-based communication: As I do not speak English, all communication will need to be facilitated via a translator. - Web and PWA installation: The shopping mall will be developed as a web platform with a PWA installation app. Please note, responses to the questions regarding specific functionalities, platform support, and p...
Looking for a skilled developer to create a script for an online poker game by using Python or Javascript. Ideal Skills Include: - Proficiency in Python or Javascript - Expertise to create Script for the online Game. - Previous experience of developing online Game. I'm open to discuss more in chat. Thanks in advanced.
I'm seeking a professional web developer with strong PHP skills to create a web scraping script. This script will collect headings and images from a specific stock image site, primarily the vector website. Key Requirements: - The script should download images in a ZIP format, not individual files. - Along with the images, the script should also collect the "Image description" metadata. Ideal candidates should have: - Proven experience in creating web scraping scripts, particularly for stock images sites. - Strong proficiency in PHP or similar programming languages. Please, only apply if you have the required experience and skills. I look forward to your proposals.
...percentages. 2. Key Features and Functionalities 2.1 Backend Functionality 1. Auto Trailing Stop Loss (SL) Robo Order: o Auto Trailing SL: This feature will allow the stop loss to automatically trail the price as the market price moves in the favorable direction (either up or down). It will adjust based on user-defined points or percentage. Modified Operation (Price, Points, and %): Users can set the trailing stop loss to adjust based on a specific price level, number of points, or percentage. 2. Auto Trailing Buy Robo Order: o Auto Trailing Buy: Similar to the trailing stop loss, this feature will automatically place a buy order when the market price moves favorably, with the option to adjust based on points or percentage. Modified Operation (Price, Points, and ...
I'm seeking a financial analyst or Excel expert who can develop a comprehensive Excel-based model. The model should project profit and loss and balance sheet accounts, with the ability to link to ratio analysis. The model should utilize my historical financial statements, which include: - Income Statements - Balance Sheets - Cash Flow Statements These statements cover a time period of 5 years or more. Ideal candidates for this project should have extensive experience in financial modeling, particularly with Excel, and a strong background in finance or accounting. Excellent attention to detail is crucial, as is the ability to present complex financial data in a clear and understandable way. I have an excel model for financial analysis and ratios, so ideall...
Multiple analytical works and updating of codes and VBA
...details work description. I need a seasoned BI developer to create an interactive Power BI dashboard that connects to an Excel file for daily data entry. The focus of this dashboard will be on visualizing metrics related to operational efficiency. While I haven't specified other particular aspects of operational efficiency, I'm open to your expertise in determining what key indicators to include. Key requirements: - Proven experience with Power BI and Excel - Understanding of operational efficiency metrics - Ability to create interactive, user-friendly dashboards - Excellent communication skills for understanding and interpreting project needs Please note, the Excel file will be updated with new data daily. Therefore, the dashboard should be able to r...
I'm in need of an Excel specialist who can help me analyze data and create visualizations using pivot tables. The ideal candidate should be able to interpret the data and provide insights, as well as create interactive pivot tables that can help visualize trends and patterns in the data. Key Requirements: - Expertise in Excel, particularly with pivot tables - Experience in data analysis - Ability to provide insights based on data - Excellent communication skills - Detail-oriented and able to deliver accurate work Please reach out if you think you're a good fit!
I need an Excel system to track my expenses and income. The system will have a simple accounting framework, and will also include some light inventory management features, specifically sales reporting. Key Features: - An Excel system to track expenses and income - A simple accounting system - Basic inventory management features (Sales reporting) I also need assistance in analyzing data, specifically trend analysis. Ideal candidates will have extensive experience in Excel, creating accounting systems, and data analysis. Skills & Experience: - Proficient in Microsoft Excel - Experience in creating accounting systems - Familiarity with inventory management - Skills in data analysis (particularly trend analysis) - Ability to create dashboards
I'm in need of a talented scriptwriter who can help me create engaging scripts for my travel-themed content on YouTube and Instagram Reels. The ideal candidate will have: - A strong understanding of travel-related content and the specific appeal of travel personalities. - Proven experience in writing scripts for online platforms, particularly YouTube and Instagram. - Ability to write in a concise, engaging manner that captures the audience's attention. Your scripts will help me connect with my audience and share my travel experiences in a fun and entertaining way. If you have a passion for travel and a knack for scriptwriting, I'd love to hear from you!
