Vba mathematics jobs
I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook. VBA-code: Sub StartColabScript() Dim colabLink As String colabLink = "" colabLink End Sub I cant get this code to run my Python-script. I also tried: # Add code to Colab Notebook !python /path/to/ !python (I dont know if the Notebook is called the right way. The name of my workbook is: Ny241028Hent33Tickers3Blokke5y I guess its .py How do I refer to this workbook from VBA, and how do I get to autoexecute
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 validation rules. Excel Reports: Gen...
...(Kepler’s laws). • Conservation of energy and angular momentum. • Electromagnetism • Light as electromagnetic waves. • Concepts of polarization, diffraction, and interference (important for telescopes and observations). • Thermodynamics and Statistical Mechanics • Blackbody radiation (Planck’s Law, Stefan-Boltzmann Law, Wien’s Displacement Law). • Energy distribution and star properties. 2. Mathematics Astronomy and astrophysics problems rely heavily on mathematical skills. • Calculus • Differentiation and integration for modeling motion and energy. • Understanding rates of change in celestial mechanics. • Trigonometry • Spherical trigonometry for celestial coordinates and angles. • ...
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'm looking for a mathematician/statistical analyst with expertise in predictive analysis using machine learning algorithms. The data you'll be working with is cross-sectional. Key Responsibilities: - Utilize machine learning algori...in predictive analysis using machine learning algorithms. The data you'll be working with is cross-sectional. Key Responsibilities: - Utilize machine learning algorithms for predictive analysis on cross-sectional data. - Provide insights and interpretations of the predictive outcomes. Ideal Skills: - Proficiency in machine learning techniques. - Strong background in statistical analysis and mathematics. - Experience with cross-sectional data. Please include relevant samples of your previous work with machine learning and predictive a...
I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me progre...
I'm experiencing an issue with a combobox in my MS Access database. It's directly bound t...experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am no...
...(Kepler’s laws). • Conservation of energy and angular momentum. • Electromagnetism • Light as electromagnetic waves. • Concepts of polarization, diffraction, and interference (important for telescopes and observations). • Thermodynamics and Statistical Mechanics • Blackbody radiation (Planck’s Law, Stefan-Boltzmann Law, Wien’s Displacement Law). • Energy distribution and star properties. 2. Mathematics Astronomy and astrophysics problems rely heavily on mathematical skills. • Calculus • Differentiation and integration for modeling motion and energy. • Understanding rates of change in celestial mechanics. • Trigonometry • Spherical trigonometry for celestial coordinates and angles. • ...
Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if it works as expected. 2. No...
...designed for high school students. The platform’s core functionality is to: - Personalized lesson creation: Using AI to create personalized lessons, assignments, and tests that aim to meet the unique learning needs of each student. The AI ​​must be adept at replicating the teaching methods of the best teachers. - Subject coverage: The platform should cover a wide range of subjects including mathematics, science, and literature, in addition to all core subjects in the Egyptian curriculum such as physics and chemistry. - Language support: The platform should support personalized lessons exclusively in Arabic. Ideal candidates for this project should have extensive experience in AI and educational software development, and preferably have an understanding of the Egyptian e...
I'm in need of a talented UI/UX designer for an educational portal project. This platform will publish content on various subjects like English, Mathematics, Physics, Chemistry, Botany, and Zoology. The primary content type will be the Study Guide, with other types including Q&A and Multiple Choice Questions. Key aspects of the design requirement include: - Prioritizing the Study Guide content type in the UI/UX design. - Adopting a modern and sleek design style, as opposed to a classic and professional or a fun and engaging style. - Focusing on facilitating quick access to study materials, as the primary goal for users visiting the portal. The ideal candidate for this project should have: - Proven experience in UI/UX design, particularly for educational platforms. - A str...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a solid portfolio demonstrati...
We are looking for a DLL written in C# that can be used with MS Access through VBA code using late binding. The library should be capable of sending controlled error emails from MS Access and returning a response confirming the success or failure of the sending.
I'm looking for a professional developer who can create a macro for my Excel file "Report1". Here's the functionality I need: - When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro sh...legacy forms, which may complicate things, but this needs to be handled. Considerations: - The software versions in use are Office 365. - Text fields from the Word file should match with the columns in the Excel file by field name. - If a field from the Word file does not exist in the Excel template, it should simply be ignored. Ideal skills for this job include advanced Excel and Word knowledge, VBA programming, and experience with legacy Word forms. Please provid...
I am looking for an Excel expert who ca...combinations that I will provide. Initially, I will supply a list of origins and destinations, but I need the matrix to be easily expandable for future use. Key Requirements: - Creation of a simple distance-only freight matrix - Integration of a user-friendly Excel form to add new locations - Incorporation of specific truck combinations into the route planning I am not familiar with programming or VBA, and I would like to know if this project is feasible before awarding it. Please, check the NHVR API tool link: Ideal candidates should have extensive experience with Excel and route planning tools, and should be able to provide a clear, user-friendly solution for future use.
I need an Excel macro that can automate the creation of product labels. The macro should be able to generate labels that include: - SKU number - SKU Description - UOM (Unit of Measure) - Up or Down Arrow The ideal freelancer for this project should have extensive experience in Excel and VBA (Visual Basic for Applications) for creating macros. Please provide examples of similar projects you have completed. The macro should recognize various size labels based on avery sheet label sizes. The Description, font size and number of characters should adjust based on size of label. I have existing file but would like to review as I speak to a developer to ensure needs are understood before sharing.
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!
...student in need of a dedicated online tutor for my introductory Signals and Systems course. As a visually impaired learner, I would greatly benefit from a patient, understanding teacher with a strong background in computer engineering, specifically in Signals and Systems and related mathematics. Key Requirements: - Comprehensive understanding of Signals and Systems, particularly the Fourier Transform, Laplace Transform, and Time and Frequency Domain Analysis. - Experience in teaching computer engineering and mathematics. - Familiarity with online tutoring platforms and tools. Preferred Teaching Style: I am inclined towards hands-on practice problems and theory-based lectures. I find it helpful to apply theories to practical problems, and I appreciate a tutor who can help...
I'm seeking a skilled professional with a strong background in financial mathematics, particularly in financial models and derivatives. The project will involve working with various financial models, specifically the application of vectors, matrices, and concepts of linear dependence and independence. Key Areas of Focus: - Financial models and derivatives - Application of vectors and matrices - Understanding linear dependence and independence Ideal Skills: - Proficient in financial mathematics - Strong understanding of financial models - Excellent in working with vectors and matrices - Able to explain concepts of linear dependence and independence clearly Experience with the Black-Scholes model, Binomial options pricing model, and Monte Carlo simulation would be bene...
I'm looking for an Excel VBA expert to help me with a local Excel file. The task involves creating a script that will filter data in a pivot table based on specific criteria. Ideal skills and experience: - Proficient in Excel VBA - Experienced in working with pivot tables - Strong understanding of data filtering techniques - Ability to write clean, efficient code
I'm looking for a skilled VBA programmer to create a dynamic filter function for my Excel pivot table. The data source is an Excel workbook and the pivot table is primarily dealing with numeric data. Key Requirements: - Create a VBA code that allows the pivot table to filter numeric data based on custom criteria. - The filter should be dynamic, adjusting as the data changes. Ideal Skills and Experience: - Proficiency in VBA programming with a strong understanding of Excel pivot tables. - Experience in creating dynamic Excel functions. - Ability to understand and implement custom filtering criteria.
...tutors based on specific criteria. - Messaging System: Include an integrated messaging system for seamless communication. - Browser/AI Chatbot: Develop a Browser/AI Chatbot for automated responses and guidance. Matching Process: - Preference-based Matching: The platform should match tutors and students based on personalized preferences. Subject Focus: - Programming, Digital Marketing, and Mathematics are the key subjects that are expected to have the highest demand on the platform. Ideal Skills: Applicants should have considerable experience in platform development, familiarity with AI Chatbot functionalities, and a strong understanding of back-end integrations for preference-based matching systems. They should also have a knack for developing user-friendly interfaces and have...
I'm seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.
I am seeking dedicated professionals to convert Maths and Science books into accessible ...alt text to images and ensuring proper formatting of headings and pointers. Key Details: - Work Type: Contract-based (Payment per page) - Payment: ₹30 per page Language Requirements: - Proficiency in Kannada is essential as the content is primarily in this language. - English proficiency is a plus as half the content is in this language. Content Type: - The job involves working with both Mathematics and Science texts. Alt Text Requirements: - The alt text for images should include basic descriptions. Ideal Skills and Experience: - Proficiency in Kannada and English - Familiarity with Maths and Science content - Experience in document remediation or accessibility formatting - Attention t...
PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/passwo...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) woul...
I require an Excel expert to create macros and VBA scripts to transform my imported Excel data into a specific format. The necessary modifications span across data formatting, calculations, and filtering. You will need to adjust: - Headers - Columns - Rows The data will be imported from another system, so I need a professional who is skilled in data manipulation and can ensure the output is consistently formatted according to my requirements. The format of excel before editing & after editing are attached for your final product should come with a button "Format" which can convert my excels to my required format. NOTE: I need to see your previous works in Excel macros & VBA before awarding this work
Do analysis and create data visualize for company product
I'm looking for an advanced Excel expert who can create a roster maker fo...shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts. - User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours. - Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros. Ideal Skills: - Expertise in Excel and VBA for Macros - Experience with creating complex scheduling tools - Ability to understand and implement conditional formatting and formulas The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have complet...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) woul...
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 an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatting and stylin...
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, the final output...
I'm looking for an AI module that can process school textbooks, specifically in Mathematics and Science. This module should be capable of identifying and extracting questions, answers, chapter titles, and key concepts from these textbooks. Key Requirements: - The AI module should be able to handle school-level Mathematics and Science textbooks. - It should be capable of extracting a variety of details from the textbooks, not just questions and answers, but also chapter titles and key concepts. Ideal Skills: - Proficiency in AI and machine learning. - Experience with natural language processing. - Familiarity with Mathematics and Science school textbooks.
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
...later, such as adding more text to specific sections or revising them. I am looking for very competitive pricing for this as well. Requirements: -Signing the NDA and agreement -Generating AI and plagiarism reports -Paraphrasing problematic text which flagged by Turnitin. - Ensure that no issues remain that could lead to the journal rejecting the paper. -Formatting the document. Adhere to the Mathematics journal's guidelines, using Microsoft Word. The availability of Word will facilitate easier future adjustments to specific sections. -- it must be done within 3 days send me your price as the following: 1. method Initial work: $0.** per word with three free revisions Revisions: $0.** per word for added or modified paragraph or 2. method The whole project price including un...
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I'm looking for a talented educator with significant experience in curriculum design to develop a comprehensive and engaging digital curriculum for a primary school. This curriculum should cover the key subjects of Mathematics, Science, and Languages. Key Requirements: - Design a curriculum that is age-appropriate and aligns with standard primary school education benchmarks. - Create engaging and interactive digital materials that will capture the attention of young learners. - Incorporate a variety of teaching strategies and methods to cater to different learning styles. Ideal Skills: - Extensive experience in primary school education and curriculum design. - Proficiency in using digital tools for creating educational content. - Strong understanding of teaching methodologies...
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
I'm seeking a professional with extensive knowledge in human and natural sciences, language, and/or advanced mathematics to review and validate a set of college-level questions. The task involves providing solutions to ensure the accuracy and integrity of the material, as if creating a comprehensive answer key for an advanced-level assessment. Key Responsibilities: - Review and validate a set of complex questions - Provide solutions to ensure accuracy and integrity - Create a comprehensive answer key for an advanced-level assessment Timeline: - Questions will be available on January 11th - Quick turnaround required on the same day Due to the nature of the project, timely and precise responses are critical to meet the project timeline. This task is part of an ongoing effort t...
Multiple analytical works and updating of codes and VBA
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write clean, efficient, and well-...
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I'm in need of a set of medium difficulty, multiple-choice mathematics questions. The questions should cover a variety of topics, specifically: - Algebra - Geometry - Statistics - Engineering Mathematics - Advanced Calculus Ideal candidates for this project should have a strong background in mathematics and experience in creating educational content. Please provide samples of your previous work in your bid.
I'm seeking a Mathematics professional with a Master's degree or PhD, specializing in Applied Mathematics, to assist with an academic research project. Ideal Candidates Should: - Have a profound knowledge of Applied Mathematics - Possess either a Master's degree or PhD - Prior experience in academic research - Excellent analytical and problem-solving skills - Ability to communicate complex mathematical concepts in a clear and concise manner. - Must be based in United States. Please note that expertise in Algebra, Calculus, or Statistics is not a requirement, though it may be beneficial.
I am in dire need of a Mathematics expert with either a Master's or PhD degree specializing in Calculus and Inferential statistics. Your responsibilities will include: - Developing new mathematical models tailored to our specific requirements - Conducting in-depth research to support our project objectives Ideal candidates should be: - Proficient in Calculus and Inferential statistics - Experienced in developing new models and conducting research - Able to deliver high-quality work under tight deadlines Please apply if you meet these qualifications. Your expertise is crucial to the success of this project.
I'm looking for a web developer to assist me in creating a random question paper generator website. Key Features: - A platform where teachers can input their own questions - Capability to handle a wide range of subjects: Mathematics, Science, Languages, and beyond - User-friendly interface Ideal Skills: - Proficient in web development - Experience in creating interactive and user-friendly websites - Knowledge in handling educational content and tools
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
