Vba mathematics jobs

Need to analysis current select columns using ChatGPT API

I'm seeking a dynamic Business Development Executive with a strong sales background in the academic assistance sector. The goal is to drive sales for our services aimed at undergraduate students across all subject areas, including Mathematics, English Literature, and Information Technology. Ideal Skills and Experience: - Proven track record in sales, preferably within the academic assistance industry - Strong understanding of undergraduate academic needs across various subjects - Excellent communication and networking skills - Capable of developing and implementing effective sales strategies - Ability to work independently and meet sales targets

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

Please Sign Up or Login to see details.

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understan...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions will be highly advantageous.

I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that ...template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro and...

I'm in need of a proficient Excel macro developer who can automate a series of tasks for me. The primary objectiv...usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability to integrate them with Excel. - Capability to create user-friendly macros that can be trig...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior ...

I'm in search of a meticulous freelancer who can help me compile and type previous year high school board exam questions, specifically in Mathematics and Science. Key Requirements: - Locate previous year high school board exam questions in Mathematics and Science - Accurately type the questions - Deliver the completed work in a PDF format Ideal Skills and Experience: - Strong typing skills - Attention to detail - Ability to work independently - Familiarity with Mathematics and Science at the high school level - Experience with locating and compiling exam questions

Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work

I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.

I'm seeking a professional math tutor with expertise in college-level calculus and linear algebra. - The primary aim of our one-on-one sessions will be to improve my grades in these subjects. - The ideal candidate will not only help me understand difficult concepts but also prepare me for exams and enhance my overall performance. - Prior experience with college mathematics tutoring, as well as a deep understanding of calculus and linear algebra, is essential. Your ability to provide personalized, engaging, and effective tutoring sessions will be key to the success of this project.

...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch file shoul...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

Junior Technical Support Assistant Limassol, Cyprus Responsibilities: Monitor and reply to incoming technical support tickets, chats, and frequently asked questions Manage and distribute incoming queries from clients and users Provide customer support by phone Assist with internal departmental workload as needed Requirements: Bachelor's or Master's degree in Mathematics, Finance, Computer Science, IT, or a related field Strong mathematical understanding High level of computer literacy and excellent knowledge of software for working on the Internet Excellent written and verbal command of the English language Ability to work effectively as part of a team Strong moral and ethical character Ability to provide clear explanations with sound reasoning Ability to learn fast - th...

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with payment based on the number...

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

Project. G

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deliver a w...

Answers key to mathematics problems.

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Please Sign Up or Login to see details.

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar dat...process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processin...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to select prev...

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing ok, the values ...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for different groups. Please note, th...

Create a Word document linked to populated Access tables. The project involves inserting data via bookmarks & VBA into a Word Template document that outputs a new Word report. This output report should have no bookmarks or VBA while maintaining the required table and text formatting & styles.

...professional mathematician who can create, record, edit, and upload engaging math videos to my YouTube channel. The videos should cover topics in Algebra, Calculus, and Geometry, aimed at elementary and high school level. Each video needs to be between 6 and 9 minutes in length and should feature the step-by-step solving of independently created math problems. Key Requirements: - Experience in mathematics with a deep understanding of Algebra, Calculus, and Geometry. - Ability to create engaging, educational content tailored for elementary and high school students. - Proficiency in video editing and able to use presentation slides to create the videos. - Capable of independently generating math problems and presenting their solutions clearly and concisely. - Serious, professional...

...professional mathematician who can create, record, edit, and upload engaging math videos to my YouTube channel. The videos should cover topics in Algebra, Calculus, and Geometry, aimed at elementary and high school level. Each video needs to be between 6 and 9 minutes in length and should feature the step-by-step solving of independently created math problems. Key Requirements: - Experience in mathematics with a deep understanding of Algebra, Calculus, and Geometry. - Ability to create engaging, educational content tailored for elementary and high school students. - Proficiency in video editing and able to use presentation slides to create the videos. - Capable of independently generating math problems and presenting their solutions clearly and concisely. - Serious, professional...

...professional mathematician who can create, record, edit, and upload engaging math videos to my YouTube channel. The videos should cover topics in Algebra, Calculus, and Geometry, aimed at elementary and high school level. Each video needs to be between 6 and 9 minutes in length and should feature the step-by-step solving of independently created math problems. Key Requirements: - Experience in mathematics with a deep understanding of Algebra, Calculus, and Geometry. - Ability to create engaging, educational content tailored for elementary and high school students. - Proficiency in video editing and able to use presentation slides to create the videos. - Capable of independently generating math problems and presenting their solutions clearly and concisely. - Serious, professional...

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR...components like charts, graphs, and summary tables for easy tracking of progress, KPIs, and pending tasks. User-friendly interface to import/export data and make updates seamlessly. Sections for tracking timelines, budgets, and overall project status. Deliverables: A fully functional, customizable Excel dashboard with instructions. Source file in Excel format. Freelancers with expertise in Excel, VBA, and data visualization are ...

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is crucial. Please ...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I'm looking for someone ...

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

I need a creative designer to design educational-themed artwork for glass banners at our school. The artwork should be suitable for the entrance of the school and represent various subjects like Science, Mathematics, and Literature. The design style should be identical to a provided reference design. Key Requirements: - Ability to design engaging, educational-themed artwork - Experience working with designs for school environments - Proficiency in creating designs that align with provided reference styles - Understanding of how to visually represent different subjects in a cohesive manner Please provide a portfolio with your relevant past work. Thank you.

I'm reaching out to find a skilled journalist who can help me disseminate my press release about a significant discovery in Mathematics to the global public. It's crucial that this information doesn't just reach academics and researchers, but also industry professionals and everyday people. The ideal freelancer for this project should have: - A robust network across all media platforms, including online news portals, television channels, and print newspapers. - Proven experience in journalism, particularly in writing and distributing press releases. - A knack for making complex information accessible and engaging for the general public. - Demonstrated ability to increase brand awareness through effective press release distribution. Your task will be to help me pro...

...excel in Cognitive Aptitude Analysis, demonstrating your reasoning and critical thinking abilities; proving your Mathematics Mastery through complex numerical challenges; showcasing your English Proficiency with advanced comprehension and communication skills; and leveraging AI & Machine Learning in Education to transform contemporary learning strategies. - Task: Completing a trial exam + five challenging online exams in Mathematics and English - Difficulty: Questions rated 10/10 - Time: Extremely limited - Integrity: Cheating with AI is strictly prohibited and easily detectable Based on your answers to the preliminary questions: 1. You seem particularly strong in Mathematics and English. Your proficiency in these areas will be beneficial. 2. Your experience w...

...includes six stages: concept, design, material collection, production, testing, and distribution. Game Design: Educational games are designed with interactive elements that engage players, such as playable characters and non-player characters (NPCs), as well as educational game maps. For example, the game "Linear Programming Adventure" is designed to train students' critical thinking skills in mathematics. Implementation of Learning: Educational games often incorporate various learning styles such as Visual, Auditory, Kinesthetic (VAK) to enhance student engagement. This helps children not only understand the material but also enjoy the learning process. Feasibility Testing: Results from feasibility tests indicate that educational games can improve student understa...

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing 4. Need a butt...

I’m am sealing a professor to help me build my framework called the Constant. It’s very unique and with AI I have the ability so it seems to do very interesting things in mathematics, whether it’s generating a quantum keys or predicting the weather. The algorithms I have developed need someone else’s eyes so I am told. I have been working on a framework with various ways of collecting data and performing tasks better than most. I have validated as much as I can. I am in discussions for patents and I need someone whom has the ability to discuss advanced mathematical and theoretical theory. I need the freelancer to be familiar with various libraries for pythons, to include the ability to test code for blockchain and encryption. Key generations etc. Under...

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

An excel file that will import images from a folder. According to a specified layout, and having a filter and sorting feature.