Excel system alert vba jobs
I'm looking for a proficient Excel expert to help me set up and automate an inventory in Excel software. Key requirements: - I need to track between 100-500 different types of items. - The inventory should be able to update and transfer data to different worksheets automatically. - I'm also interested in adding automatic calculations, like the total value of the stock. Ideal Skills: - Proficiency in Excel and experience in setting up complex inventories. - Automation skills in Excel to ensure smooth and efficient data updates. - A good understanding of inventory management principles to ensure the system is effective and user-friendly. Please reach out if you have the right skills and are interested in tackling this project.
I'm in need of a freelancer with experience in using Crystal Reports - particularly with Excel, Google Sheets, and Web Services/APIs. Requirements: - Expertise in Crystal Reports: I require a freelancer who is somewhat familiar with Crystal Reports; this is non-negotiable as I need someone who can hit the ground running. - Data Sources: I need the reports to connect to both Spreadsheets (Excel, Google Sheets) and APIs/Web Services. - Report Quantity: The project includes less than 10 reports. Ideal Skills: - Proficiency with Crystal Reports. - Experience in connecting to Excel, Google Sheets, and Web Services.
I'm seeking an Excel Macro specialist to automate several repetitive tasks specific to engineering. The qualified individual needs to have: - Proven experience in creating efficient and complex macros - A solid grasp of engineering needs in relation to Excel functions - An ability to work with dense datasets and create tailored reports Tasks include, but are not limited to: - Automating repetitive engineering report creation - Streamlining data organization This project requires both expertise in Excel and understanding of engineering principles, hence any experience in the field can be a significant bonus. High efficiency and attention to details are of prime importance. Macro will need to be in word file and will change depending of the test - test A to J....
...existing business, our primary need is a state-of-the-art ticket booking system, entrenched within a web application, which fundamentally operates to book flights. In addition to the central feature, our checklist of desired systems/functionalities includes: - Integrated payment system: to provide a simplified and secure transaction process. - Passenger information system: for well-organized customer data management. - User registration and login system for agencies: to build a network of interlinked agencies. - Flight search and booking functionality: to enable users to find and book flights effortlessly. - API addition: for seamless integration with other systems. - Fully functioning ADMIN panel: for efficient system control and management. - Flu...
...our Street and Zipcode Database: We have a comprehensive database that should serve as the master template for the address checks. You'll need to integrate this into the API for accurate validation. - Handle incorrect addresses: It's crucial that the API is programmed to suggest corrections automatically when an incorrect address is identified. - Accept Excel and CSV files: The API should have the capacity to check addresses from both Excel and CSV files. We need an html frontend, to Upload files. The result shoud be added in the file The api should also react on soap requests and deliver the correct address back The request should be locked by costumer keys and the amount of requests per key should be logged in some table Ideal Skills: - Proficiency in API ...
...time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled...
I require a highly efficient individual ...efficient individual to complete a swift data entry project. Involving on-screen text extraction of phone numbers from a 10-minute video, the data needs to be meticulously transferred into Excel. It's a project needing completion as soon as possible, therefore excellent time-management skills are essential. SKILLS: - Data Entry - Proficiency in Excel - Video Data Extraction - Strong attention to detail - Proven time management capabilities EXPERIENCE: Prior experience in a similar role is greatly advantageous, although not a deal-breaker. Deadline adherence, a meticulous approach, and proficiency in Excel and video data extraction are crucial for this role. I look forward to hearing from you and working together on...
I'm in need of a custom Excel workbook that can handle RFQ (Request for Quotation) analysis and purchasing. The ideal candidate will be able to create this tool for me from scratch. Key Features: - Data Import/Export Functionality: The workbook should accommodate easy import and export of data from Excel spreadsheets. - Automated Data Analysis: The tool should be designed to perform automated analysis of data imported. This will involve calculation of vendor prices, comparison and evaluation. - Generation of Reports: The tool should be able to automatically generate reports or dashboards based on the imported data. Ideal Skills: - Proficient in Excel: Advanced knowledge of Excel functionalities and VBA is a must. - Experience in RFQ Analysis: A b...
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf that you get from a sup...
I am looking for someone experienced in integrating Telegram messages to Excel file. Consequently, I'd like you to help me complete the following tasks: - Extract specific details from the Telegram messages such as text content, the date and time the message was sent, and the sender's name - Integrate these details into an Excel files, putting the information in the correct cells - This work particularly involves dealing with text messages from Telegram Experience with Telegram API and advanced Excel capabilities will be beneficial for this task.
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
Partnumber Generating Hello, we have Parts which we produce self with different options: Categorie - Modell - Length in cm - Warning Moduls - Design - option 1 - option 2 - option 3 - option 4 - option 5 ........... option 15 We work with ERP System, but it is diffcult, can you help us ? What is a solution for produce in excel or what is a solution for this problem to produce easy differenz part numbers but with structure ?
I'm looking for an experienced machine learning expert with a focus on predictive modeling. The goal of this project is to utilize the fully cleaned and labeled image data I have to create an effective predictive model. Key Responsibilities: - Develop a predictive model using the given image data. - Implement an effective machine learning algorithm that can predict outcomes accurately. Requirements: - Proficiency in Predictive Modeling: You should have a strong background in building predictive models. - Experience With Image Data: A history of working with image data in a predictive modeling context is highly desirable. - Data Preparation Skills: While the data is already fully cleaned and labeled, being able to perform additional data preparation may be necessary for the project&#...
I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunctional Excel Macro that's compatible with Windows. - The macro should be able to generate sales reports, calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past wo...
...time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are fille...
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
I'm looking for a detail-oriented Excel expert to help with data entry. Your main task will be to enter text and dates into an Excel spreadsheet. Key Requirements: - You'll be working on a single column in the spreadsheet. - There are 1500 entries in total. - Prior experience in Excel data entry is highly preferred. - Attention to detail and accuracy is a must. The data needs to be entered following a specific format or template. I'll provide you with this guidance. If you're a skilled Excel user who can work efficiently and accurately, I'd like to hear from you.
Assalam o alaikum, I am looking for a MATLAB expert with good expertise in the field of control system design. Freelancer should be capable of writing reports too with detailed explanation of the circuit and complete project. Final report should be well structured and properly formatted with cover page, table of contents, list of figures, references. If you use any figure, table or diagram in the report, there should be a proper caption for it. Plagiarism should be below 10% using ChatGPT or AI is highly discouraged.
Kita membutuhkan Sales Freelance untuk bisa mendapatkan Client B2B, terutama untuk Hotel sistem seperti Booking Engine, Channel Manager, Website, PMS, POS & Purchase. Kami menyediakan: Hospitality Digital Partnership Online Marketing & Digital Solution Website:
Overview We aim to replace our current Excel-based process with a robust internal order confirmation system. This system will automate and streamline the management of weekly orders and confirmations, increasing efficiency, reducing errors, and maintaining a structured approach to sales operations. Objective Develop a web-based system that allows salespeople to manage product and customer information efficiently, generate order templates, and automate the creation of confirmation documents, mimicking the structure and data from the "example weekly order " and "example order " provided. Key Features Weekly Order Template Generation: Automate the creation of weekly order templates based on the weeks, with the capability to product details, w...
I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.
I need assistance with compiling a comprehensive database based on various online directories. Key Requirements: - You will be collecting data on the names and contact information of individuals. - Each entry should include the person's name, phone number, and email address. Skills & Experience: - Proficiency in Excel and data entry is crucial for this task. - Experience with online research and data gathering from various sources is a plus. I'm looking for a reliable and detail-oriented freelancer who can help ensure the accuracy and completeness of this database.
I'm in need of a hydroponic grow building expert to design, set up, and potentially maintain a system that will help increase the growth rate of fruits, such as tomatoes and strawberries. This system should be highly effective in boosting the growth of these fruit-bearing plants. Key aspects of this project include: - Maximize plant growth rate: It's crucial that the system is designed to significantly increase the growth rate of fruit plants. I'm looking for someone who has a proven record of optimizing hydroponic systems for rapid plant growth. - Fully automated: I'm keen on having a hydroponic system that's fully automated. This means it should handle tasks such as watering and nutrient dosing without the need for manual intervention...
I'm in need of someone with access to the Australian Bureau of Statistics who can assist me in gathering specific data related to aged care planning within Melbourne. Key Deliverables in Excel: - Total population of each SA3 in Eastern and Southern Melbourne - High Income per week ($2,000 and $3,000+) of each SA3 - Age distribution within the following groups: 50+, 60+, 70+, 80+, 85+ Ideal Candidate: - Previous experience working with Australian Bureau of Statistics - Proficient in data collection and analysis - Excellent research skills - Strong communication and reporting abilities - Able to complete the project promptly, within a month - Access to ABS table builders This project is crucial for understanding the aged care market in Melbourne and will serve as a foundation ...
...Arduino Nano in combination. The aim of this project is to create a calculation and display system, primarily based on timer measurements and pre-stored factors. Skills and Experience: - Strong understanding of Nextion HMI and Arduino Nano - Experience handling calculations and display systems Project Tasks: - Develop a system using Arduino Nano for accurate timing - Implement calculations based on timer measurements and stored factors - Display results on Nextion Intelligent series HMI This project does not involve processing of sensor data, business metrics. The focus is on timer measurements and stored factors to calculate, display and store results. The ultimate goal is to devise a system that is reliable, efficient, and accurate. Anyone bidding on this...
I'm seeking a skilled developer for my current WordPress website. The roll involves coding a bespoke and secure online client triage system for our website to allow clients to self triage to the right psychologist depending on their selections/needs. Different questions will lead to different possible next questions (if/then rules).. Responsibilities include: - Implementing systems for client data input and storage. - Creating triage assessment questions presented in an intuitive congruent with our online booking software (see attached screenshot). - Building in functionalities to compile reports based on collected data. - Ensuring it is customisable in the back end, as it will need to be edited as staff skills change and new members join the team. Ideal candidate ...
I am in need of someone who can collect data on NFL Quarterbacks listed in the excel sheet I have attached. Many quarterbacks will appear multiple times because I am treating each season as its own entity. I need age (changes by season), weight (changes by season), height (stays same), wonderlic scores (stays same because its only taken one time). In summary, I need data for the quarterbacks listed in four areas: age, weight, height, and wonderlic scores.
I have an Excel file where the preventive and corrective maintenance services of some equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose functionality or copy the dat...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
...specifically Word & Excel, who can assist me in managing specific tasks. In Microsoft Word, the following tasks are needed: - Formatting Documents: Your skills should be top-notch in bringing out an excellent document format that is pleasing to the eyes and understandable. - Creating Templates: I need help in creating various templates for different types of documents. In Microsoft Excel, your tasks would include: - Data Analysis: I require someone with exceptional skills in analyzing data, to extract useful information that will guide my decisions. - Creating Formulas: You should be fluent in the use of various Excel formulas to facilitate swift and accurate calculations. The ideal candidate must have substantial experience in handling such tasks in Microso...
I'm looking for a skilled Excel professional to help create a spreadsheet that will serve as a route tracker for my delivery business. Key Requirements: - The primary purpose of the spreadsheet is to track the various routes that my delivery personnel drive. - I need the spreadsheet to detail the start and end points of each route, the distance traveled, and the time taken for each route. Skills and Experience: - Proficiency in Excel, particularly in creating complex but user-friendly spreadsheets. - Familiarity with data tracking and analysis, particularly in the context of logistics or similar fields, would be a significant advantage. - The ability to accurately incorporate the different data types and calculations required for route tracking.
i need 2 menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. example: STARTERS - ONION BHAJI - 4.50 - Our own onion fritters with salad and sauce. Contains gluten. i have started the process for u to make life easier no time wasters if u do nice job i can give u more menus in the future
...of a skilled developer to create an additional layer of alert logic for a 3-part custom indicator I use. This is a unique and private indicator. The alerts should be based on a combination of the indicator logic and 3 separate conditions (1, 2, 3). Here are a few points to consider: - The alert system should be able to trigger based on the indicator's signals and the three conditions. - Familiarity with the traditional indicators (Moving Average, RSI, Stochastic Oscillator) could be advantageous, but the main focus will be on my custom indicator. - The code should be robust and well-documented for potential future modifications. I'm particularly interested in seeing your past work, especially if you've worked on similar custom alert systems. ...
I am seeking an expert who can accurately and efficiently convert two PDF files with around 110 pages into an Excel document. The PDF contains data tables as low-resolution images. No data transformation is required, just a transcription. The successful freelancer should have: - Either AI software to automatize the conversion - Or transcription skills to the the labour manually - A high degree of accuracy is needed - The capability to finish the project in a timely manner Please ensure that your bid accurately reflects your ability to handle a large-scale transcription job like this. Attached you'll find an extract of the document due to size limitations. There are in total 106 pages of the same table.
I am in need of a well-crafted wedding speech. As the groom, my speech needs to capture the laughter, love, and sentiment of our relationship. The speech should include: - A humorous story from when we first met - A loving account of why I fell in love with my bride-to-be - A sentimental anecdote that captures our relationship's essence. An ideal candidate for this project would excel in creative writing, possess a strong understanding of tone and pacing, and have experience writing wedding speeches. The ability to balance humor, sentiment, and heartfelt words is crucial.
I'm looking for someone who is well-versed in Tableau, Alteryx, Excel, and Access to assist me with the visualizations needed for the two research cases provided below. All of the instructions and case files will be attached so that you can complete all of the necessary tasks. I will complete the memos independently, so you do not have to worry about doing the memos, only the technological aspects of the research cases. Please contact me as soon as possible if you want to work on these tasks. I will need them finished by May 6th.
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...
I'm seeking a proficient freelancer with an analytical mindset for my Excel project. You will be tasked with interpreting numerical data through pattern analysis. Key Responsibilities: - Data Conditioning: Your primary task will be to condition the numeric data in my Excel project. - Analysis and Interpretation: Execute pattern analysis on the conditioned data to decipher meaningful insights. Skills and Experience: - Proficiency in Excel numeric data handling - Strong experience in pattern analysis - Remarkable numerical competency - Excellent analytical skills If you have a knack for translating raw data into insightful findings, this project is for you. I look forward to your bids!
I seek a solution-oriented software developer to create a specialized software for my Windows system, which can apply multiple prediction models to an Excel sheet. Key Functions: - Incorporating various prediction models: This includes not only regression, classification, and clustering models, but also decision trees, neural networks, random forests, and support vectors. Ideal Candidate: - Expertise in developing Windows compatible software - Strong understanding of data prediction models - Knowledgeable in Excel functionalities - Ability to integrate sophisticated prediction algorithms The final outcome should be a user-friendly software that enhances my productivity by allowing me to apply versatile prediction models to my data effortlessly.
I have a massive inventory I need help with. I want to transfer the data from the website to an Excel spreadsheet. This involves both text and numeric data, which includes fields such as Vendor Name, Address, City, State, Zip, Dimensions, Country, Memo, and Remarks. Key Responsibilities: - Complete copying and pasting the required data from the website to the Excel spreadsheet - Maintaining the accuracy of the data - Ensuring the data is organized properly in the spreadsheet You should have: - Proficiency in Excel - Experience in data entry - Attention to detail - Good organizational skills - Ability to follow instructions accurately If you have a good internet connection, a reliable computer, and a decent amount of time to spare, this task is right for you. Please...
I am in need of an experienced programmer for my networked Honeywell Pro-Watch system. The main tasks include system configuration and access control customization. Key Responsibilities: - Configuring the Pro-Watch access control software to suit our organization's needs. - Customization of access control to facilitate basic user permissions. Ideal Skills and Experience: - Proficiency in programming and configuring Honeywell Pro-Watch systems. - Deep understanding of access control systems, particularly in the context of networked configurations. - Prior experience with customizing access control for basic user permissions.
This app will cover the following things (we will give detailed instructions what to do and what the app is about): Some highlights of the app 1. We will provi...make sure our APi's are sent values from the phone (especially that the user has logged in using fingerprints everytime- some way to authenticate that and conform to our API). 3. We will not upload the app to google play store but still want the app to be able to vibrate the phone and display to the user that there is a notification waiting for him to read (so suggest is there any way to still alert the user of any events that we want to trigger through apk) we are considering publishing it as private app on google play. We want someone who can be available for quick chats etc, we want to finish first phase of this a...
I'm seeking a professional to help develop a smart irrigation system. I want it to have the following features: - Remote monitoring and control, allowing me to manage the system from afar. - Soil moisture sensing, to ensure optimum watering for my plants. The system will be used for irrigating small amounts of soil, so it should be built to accommodate that scale. As to the type of plants, the system should be versatile enough to work with any type. Ideal skills and experience required include: - IoT development and programming skills. - Experience with agricultural technology or a strong knowledge of irrigation systems. - Knowledge on soil moisture dynamics. This is a unique project that requires creativity, technical skill, and an understanding of m...
Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at ag...
Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at a...
...original document is attached. GlobalPowerUSAspecsheetsolareye360.pdf. We would like to make the spec sheet look more modern and use a green coloring as per the Globe Power USA corporate layouts. This competition is for a 1 page document and designer should look to create a modern base template that we can use for the other products we sell. We have a very high quality solar powered security system that I want to feature in a brochure. All our products have one brochure/specification sheet that outlines the main features and dimensions. We would like to take our existing template and change it up to look more professional. I need an effective, eye-catching flyer created for my product, designed to appeal specifically to middle-aged adults. The purpose of this flyer is to p...
I'm seeking a proficient developer for implementing comprehensive changes in an existing Smart School Management System on Codecanyon. I envision the project as a long-term contractual relationship. The system is based on codeigniter. The scope primarily includes wide-ranging modifications and additions to the system. Experienced coders with a strong understanding of school management processes will be given priority. Key Tasks: -Customize the lesson plan module - Revamp Examinations module - Fully functional accounting system, - Enhance academic syllabus, lesson plans and assessment - Upgrade Examinations, School fees, Accounting, Academics, and Transport modules Examinations: - Develop functionalities for more efficient result management and gradin...
