Run r script from excel vba jobs
Hiring Work-Nix Solutions to add reporting options to existing system.
...```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 seeking an expert in the field of market research and beverage formulation to conduct a full R&D on a non-alcoholic Ready-To-Drink (RTD) beverage. Key focuses will include: - Understanding market trends and consumer preferences within the Asian region. - Tailoring the beverage towards specific lifestyle segments, not just age groups or income levels. The ideal candidate will be well-versed in market analysis and have a deep understanding of lifestyle segments within Asia. Experience in the beverage industry is a significant plus. Please provide examples of similar projects you've completed in your proposal.
...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 ...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 and accuracy Ability to work 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 Or...
...to create an application that extracts and organizes links from *IFRAME HTML content*. The application should: 1. Gather all information from IFRAMES using *JavaScript* or *Python*. 2. Extract all links from the HTML content within the IFRAMES and compile them into a list. 3. From this list, generate a *unique list of 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. •...
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 need a skilled digital artist who can transform a photo into a cartoon-style drawing. This drawing should utilize a limited color palette, similar to 2-3 colors. From the picture, please remove the santa hats on the shirt and leave the day of the dead design on the wine glass in her hand. Can i get a couple of different options? one abstract, one more like a Cartoon drawing? with maybe blue (Like beach water blue) and sunset orange? Key Skills: - Proficient in digital drawing - Experience in creating cartoon-style illustrations - Ability to work with a limited color palette Please provide samples of your previous work in 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
...psychological defenses and coping styles. - Identify the individual's core values and belief system. - Contextualize entries within relevant historical or situational contexts. The ideal candidate for this project should have a strong background in psychology, particularly in profiling and analysis of personal writings. Experience with interpreting emotional, behavioral, and personality indicators from text is crucial. The final deliverable should be an in-depth analysis that provides a thorough understanding of the individual's psychological landscape. The final deliverable should be a comprehensive written report. The report should be between 20-30 pages. The final deliverable should be submitted in PDF format. The analysis should utilize cognitive-behavioral method...
I'm looking for a designer to give my current logo a modern and sleek overhaul while retaining some elements from the old design. Key Requirements: - The new logo should convey a modern and sleek aesthetic. - The upside down Treble Clef used as the letter 'R' should be incorporated from the existing logo - The letter i could be used upside down as an exclamation mark, or in capital letter - Color scheme is open to your creative interpretation, no b&w please Ideal Skills and Experience: - Strong portfolio of modern and minimalist designs. - Experience in logo design and brand identity. - Ability to creatively incorporate existing brand elements into a new design.
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.
READ EVERYTHING BELOW BEFORE APPLYING. I'm in need of a professional blog writer with a strong focus on SEO. The primary goal of these blog posts is to increase website traffic. Requirements *Must be from Central America, South America, or Jamaica ONLY *Must be fluent in English *Primary skill will be writing Tasks *We will give you a video course or training to watch and you will need to write what you learned *Once you write what you learned in your own words, then you will use AI to help you improve the content *Here is example of an article that I wrote We are looking for very high quality and original articles Please give me a quote on how much you would charge to do something similar
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 need 260 ID cards created from a PSD template. The only changes required are the first and last names and the corresponding pictures of the card holders. The job needs to be completed within the next 12 hours. - ID Card Information: Each ID card should display the first name, last name, and picture of the card holder. - Source Files: I will provide the PSD template, a zip file containing the images, and a spreadsheet with the names. Ideal freelancer for this project should: - Have experience with Photoshop and working with PSD files. - Be able to work quickly and efficiently under time pressure. - Have a keen eye for detail to ensure each ID card is accurate.
...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 Embed Forms plugin. 2. Handling Responses: o Jotform primarily saves data on its servers. To save data in WordPress, use a custom webhook that forwards the submitted responses from Jotform to your WordPress database. 3. Integration with AI via API: o Set up a webhook in Jotfor...
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 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.
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.
...the concepts of lighting and texturing will be required. The main visual elements that compose the scene will be a textured terrain and modified in height by a shader, the hot air balloons, as well as a setting sun. Virtual stage The scene will be composed of a series of 3D models, namely: Land Formed from a plan (its construction is specified in the following chapters) Balloons Made up of several primitives (their construction is specified in the following chapters) The Sun Formed from a sphere Camera positioning The camera will be perspective and must be placed so that it includes all the elements of interest in the scene (the terrain, the balloons, and the sun) in the frame. It is not necessary to allow control of the camera's position or rotation during appli...
I have public datasets in CSV format that I want to use to develop a machine learning model for predicting water potability. Ideal Skills and Experience: - Proficient in machine learning and data analysis - Experience working with public datasets - Comfortable with CSV file manipulation - Background in environmental science or water quality analysis is a plus - Excellent programming skill...datasets in CSV format that I want to use to develop a machine learning model for predicting water potability. Ideal Skills and Experience: - Proficient in machine learning and data analysis - Experience working with public datasets - Comfortable with CSV file manipulation - Background in environmental science or water quality analysis is a plus - Excellent programming skills, preferably in Python o...
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...
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.
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.
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 looking to transform a PDF file into 3D external views and videos. The main deliverables are 360-degree panoramas and a standard video. I need these 3D views and videos to highlight specific elements, namely: - Architectural details - Landscaping and surroundings - Lighting and shadows Ideal candidates for this project should have experience in 3D modelling and rendering, with a strong attention to detail. Proficiency in software capable of creating 360-degree panoramas and standard videos is a must.
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 ...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...
I need assistance comparing 3-4 structured Excel files. This task involves verifying data matches, specifically contract titles and numbers. We are talking about 3-4 columns only in total. Key requirements: - Expertise in data match verification - Proficiency in working with structured Excel files with headers - Ability to provide accurate analysis within an hour If you can commit to this task and deliver accurate results promptly, please place your bid. Please place your bid if you can dedicate the 1 hour of your time now
I am looking for a freelancer who can assist me with data entry work. The task involves extracting text data from various online articles and websites, and compiling it into a plain text file. Ideal Skills and Experience: - Proficient in data entry with a keen eye for detail - Familiarity with navigating online articles and websites for data extraction - Able to deliver work in a plain text file format - Good understanding of maintaining the integrity and confidentiality of the data Please note, the main focus is on text data entry, so a strong command of English is a plus.
I need assistance in downloading around 14 PDF documents from a specific website. These documents are currently not downloadable, and are only available in a read-only format. The task will need to be performed on my computer using AnyDesk. Key Requirements: - Proficiency with AnyDesk software - Experience in data retrieval tasks - Attention to detail Please note that the PDFs are not protected by any form of security, they are publicly accessible but cannot be downloaded directly from the website.
I'm seeking a logo for my home testosterone testing company, 'Check From Home'. The logo should prominently feature the brand name in strong, massive letters. Key Aspects: - Colour Scheme: Red and blue. - Design: A simple and attractive design that appeals to all people, not just bodybuilding enthusiasts. - Feelings/Values: The logo should convey 'Health and vitality'. Skills and Experience: - Graphic Design - Logo Design - Brand Development - Understanding of conveying brand values through design
