Vba for data miningJobs
Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.
I am in need of a professional data collector/detective who is well-established in Australian and Asian markets. I require verified contact information of 300 specific companies across these regions who own Hotels. The list of companies will be provided upon project initiation. Some contacts will be easily found in Linkedin, others will need deeper research. So please don't apply if you only use Linkedin for your research. Skills & Experience: • Familiarity with the business landscape in Australia and Asia • Proven experience in data mining and data verification • Effective communication and swift execution Your role involves not only finding the precise contact details but also ensuring their validity. Please pitch your propos...
...looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a no...
I'm in need of a versatile data engineer who can tackle various aspects of data analysis, AI development, and data engineering. - The ideal candidate should be proficient in Python and knowledgeable about Machine Learning algorithms, as these will be crucial to the AI development aspect of the project. - Sound experience in working with structured databases (e.g., MySQL, PostgreSQL) is essential. Introduction: Join our team as a Data Engineer, where you'll have the opportunity to contribute to cutting-edge projects and drive significant advancements in data analysis and machine learning. We are looking for a highly skilled professional who thrives in a dynamic environment and is passionate about transforming large volumes of data...
I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelanc...
...Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: Contact Name: Date Created: Ticket Number: The...
I'm on a mission to gather as many logo images as possible for my brand research. And that's where you come in. My project specifically revolves around: - Extracting high-quality logo images from a specified web app. - Ensuring the integrity of the image quality during the extraction process. This job would be a perfect match for a freelancer with extensive experience in: - Web scraping and data mining. - Handling different image file types and ensuring quality preservation. If you've completed similar data extraction projects and are versed in the art of web scraping, you might just be the perfect fit! So come on board, and let's revolutionize brand research together!
Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA
I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export...
I have a college assignment where I need to perform a data analysis task using Python. I have a specific dataset that I will provide. Key requirements: - Data Analysis: The task involves in-depth data analysis - not just basic statistical analysis but also some intermediate data processing and visualization. - Python Proficiency: You must be skilled in Python for this project. Experience in using Python for data analysis is a definite plus. - Dataset: I will provide the dataset which you will be working with, so you should be comfortable working with provided data. this is the question : In this question, you will use the dataset made available to the public by: S. Moro, R. Laureano and P. Cortez. Using Data Mining...
...experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of da...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I have a son, he's 15 years old. I want him to study as a supplement geology, namely Economic Geology (mining of minerals such as petroleum, gases, coal, etc.) I need a teacher who: 1) understands the subject himself; 2) is able to present these topics to the student in a competent way. The lessons will be done online, and the expected workload is +-5 lessons per week, one and a half hours each. The teacher will be responsible for the development of the course. We live in Chicago. - Desired Skills and Experience: Deep understanding of and experience in Petrology, Paleontology, Mineralogy, and Economic Geology are a must. Previous tutoring or teaching experience is a big plus.
I'm seeking a skilled professional to aid in the procurement plan for an upcoming mining project. We will be focusing on securing necessary services for optimal mining operations and production. The individual will need: - project plan and execution of early mine stage , mine development. - Expertise in procurement strategies and cost-effective solutions - equipment list - Professional communication and negotiation skills Through collaboration, we hope to secure the best services that will ensure the success of our mining project while maintaining conformity with set budget limitations. Prior experience in similar projects will be highly beneficial.
I am in need of an expert who has access to Rocket Reach for email procurement. Unfortunately, I do not have information on industry targeting or the exact number of emails needed at the moment, but this will be provided during the project process. Important skills: - Experience with Rocket Reach - Attention to detail - Experience in lead generation and email mining Please be prepared to discuss your approach to these tasks.
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I am in search of skilled data miners to assist with a project that involves extracting employer information from Indeed.com. The focus is on identifying businesses hiring in three specific categories: CDL drivers, accounts, and healthcare, located within the Bucks County addition to basic details, I require the extraction of contact numbers, email addresses, and website links for these businesses. If you have experience in similar data extraction projects and are interested in this opportunity, please respond with your availability and any relevant examples of your past you for your consideration.
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working w...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I am seeking a skilled data miner for a project involving business data extraction from the Yellow Pages. Specifically, I am interested in the category of 'Equipment Hire in Australia'. The scope of the data to be extracted includes: - Business Names - Phone Numbers - Physical Addresses - Email Addresses This project would be ideal for freelancers who have experience in data mining, data extraction, scraping Yellow Pages, and processing information through Python, R, or a similar language. Knowledge of the business environment in Australia would be a plus. Please note that accuracy is paramount; I need the completed dataset to be as error-free as possible. Looking forward to reviewing your bids.
...guidance and council for the development of my companies current forms, trackers, and databases - specifically the automation of processing and linking data from various inputs across multiple-departments within my construction company. We currently have multiple forms, trackers, and databases that have daily inputs from multiple field personnel and back-of-house departments. The workflow on my projects requires intricate and dynamic workflows that involve multiple individuals and departments. I am in the early stages of making "smart" tools for automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
...large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Australian Time Zone (NSW) 4pm to 1am (1hr OR 2 x 30min unpaid lunch or dinner break) Monday to Friday / possible weekend work. Personality traits for this role is someone who has a high value on the following: - very organised and likes following processes to complete a task - Someone who cares about strong attention to de...
I am seeking a proficient data collector who will assist me in acquiring vital information necessary for our sales and marketing campaigns. You'll be tasked with compiling a reliable list of emails and phone numbers for technology directors in K-12 school districts that I will specify. The ideal freelancer for this project: - Has a solid background in data-mining - Understands US K-12 Education System - Is meticulous and accurate The required data should include: - Technology Director's name - Their emails - Their contact numbers Accuracy and timeliness are critical for this project. Please only commit if you are confident you can deliver with great efficiency. This is a great opportunity for you to display y...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work effic...
I am currently seeking a professional who can obtain email contacts for facilities maintenance staff for business introductions. These introductions will focus on the services and physical products my company offers. Ideal candidates should be experienced in: - Data mining or gathering - Understand privacy and act compliantly The aim is to reach out to potential customers for vendor outreach. The successful freelancer will skillfully gather legitimate contact information without breaching privacy rules. Familiarity with the facilities maintenance industry would be a bonus but isn't essential.
...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a stron...
I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particular...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns f...
...CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programmi...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to L...archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables -...
...intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly ...
Looking for a proficient researcher to provide comprehensive research services e.g., market trends, competitive analysis, industry insights. The ideal candidate will have a knack for gathering and analyzing data, attention to detail, and the ability to deliver accurate and timely reports. Strong communication skills and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i...
As a specialist in the mining industry, I am seeking Australian Perth based dedicated Recruitment Consultant to handle the core responsibilities of sourcing candidates, conducting interviews and negotiating job offers. Key Responsibilities: - Sourcing Candidates: The ideal candidate will be actively sourcing and recruiting potential candidates within the mining sector. This involves identifying suitable candidates through various channels, such as job boards, social media, and networking. - Conducting Interviews: The selected consultant will be responsible for conducting thorough interviews with potential candidates. This includes screening, evaluating qualifications, and assessing competency against the desired criteria. - Negotiating Job Offers: The recruited consu...
DO NOT BID OFFERING FB ADS, DATA SCRAPE, LINKEDIN DATA, OR SOME OTHER MARKETING. I POSTED THIS PROJECT LOOKING FOR PEOPLE THAT HAVE THIS TYPE OF LISTS, AND ALSO FOR BROKERS THAT HAVE ACCESS TO THESE TYPES OF LISTS. I'm in need of lists of Real Estate Investors and Real Estate Owners from UAE (Dubai specifically), (or) the entire Gulf region, (or) UK, for a targeted marketing campaign. Key Requirements: - Detailed Lists: This should include the names, contact details, and investment preferences of the individuals. - Specific Criteria: The potential leads should be based on specific location and property types. I'm looking for an expert who can provide high-quality and comprehensive lists of Real Estate Investors and Real ...
I am in need of a freelancer experienced with lead generation within the business sector. The chosen freelancer should have prior experience in identifying business leads through various channels. Strong research and analytical abilities are required for this task. Key Responsibilities: - Using data-driven research strategies to identify potential business leads - Acquiring accurate and up-to-date contact information, with a preference for email Ideal Skill Set: - Experience in B2B Lead Generation - Proficiency in data mining and online research - Strong knowledge of lead generation tools and strategies - Expertise in email marketing and communication strategies Please submit any past experiences in this particular area and be ready to provide results...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm looking for an expert in data extraction and parsing, capable of developing a robust system for scanning resumes and extracting a multitude of details. The requirements will include pulling: - Personal Information: Name, Address, Date of Birth - Previous Client Information - Family Details - Educational Background - Language Proficiency (both native and acquired) - Marital status - Data on children After the extraction is completed, you'll also be responsible for parsing this data onto our website. It should be presented in a neat, tabular format that's easy for users to discern and understand. This job is perfect for freelancers with a knack for data mining, extraction and web page formattin...
...looking for an experienced data miner or online researcher who can compile a comprehensive contact list consisting of both industrial business owners and industrial property owners in the Charlotte market. The data points that you need to scrape are the following: For Business/tenant contacts: * Property address * Property city * Property size (square footage) * Business/tenant name * Business owner/executive contact name * Business owner/executive contact phone number * Business owner/executive contact email address * Business website (if any) For Property owners: * Property address * Property city * Property size (square footage) * Owner business name (unless individual owner) * Owner name * Owner phone number * Owner email address * Owner websi...
I need comprehensive details extracted from the Parivahan vehicle RC database. Data output must be within range upto 1k range at once. Specific requirements include the: - Owner's name - Registration number - Vehicle model and make - Insurance expiration date - Owner contact number The need is urgent, so a quick turnaround is vital. An adept hand at data mining, especially relative to the Parivahan database, would be an asset. Familiarity with Indian vehicle registration systems or similar projects will also be advantageous. The project should prioritize accuracy of data above all, and a proven record in precise information extraction is essential.
...network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new...
I am in need of a seasoned data analyst who can effectively work on a data visualization project for me. The main purpose of this project is: - Utilizing numerical data, categorical data, and time series data - Creating clear visual representations to aid in identifying trends and patterns - Spotting anomalies and outliers - Comparing various datasets An ideal candidate for this project would have a strong background in data analytics, preferably with previous experience in data mining and predictive modeling. Mastery in utilizing data visualization tools and software is also crucial. You should be able to understand and interpret complex data, and not only represent it visually but also spot anomalies, o...
...network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connecti...
