Excel simulation vba jobs
We want to automatically update a "Master Stock excel file by either uploading an "Additional" Stock file or by subtracting a "Subtract" stock file. This inventory system would ideally: - use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file). - Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly. - We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file. - We then want to be able to download the latest Master Stock File whenever needed. Important: It needs t...
I am in need of a customized Microsoft Excel spreadsheet for tracking employee departures. This tool is vital to manage efficiently and effectively the following data: - Employee Full Names - Departure Dates and Times - Bag Pull Information - Airline Information - Flight Information - Room Numbers The employee names should be formatted with both their first and last names for clarity and precision. As well as their guest names. Experience with creating functional and easy-to-navigate spreadsheets is key. Familiarity with airline industry operations or similar would be a great asset. Proficiency in Microsoft Excel is, of course, essential. I look forward to receiving your bids for developing this crucial tool for my operation.
Summary I'm looking for an SEO expert who can carry out keyword research using Ahrefs. I have a comprehensive video of the steps that I would like the freelancer to follow to generate the keyword research. Main Skills - Understand SEO basics - Feel comfortable with Microsoft Excel
I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.
Data Entry Project - Microsoft Excel Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet deadlines Description: I am looking for a freelancer to assist me with a data entry project using Microsoft Excel. The task involves entering data into Excel spreadsheets accurately and efficiently. The ideal candidate should have experience in data entry and be familiar with using Microsoft Excel. Key requirements for the job: - Proficiency in Microsoft Excel - Attention to detail and accuracy in data entry - Ability to meet the deadline of completing the task within a week If you have experience in data entry and are proficient in Microsoft Excel, please submit your proposal.
Make a game using flutter , will give u apis in node More details: What platform(s) should the Flutter app support? Android, Web What specific functionalities do you want the Flutter app to have? Game devlopment What type of game do you want to develop? Simulation
I am looking to develop a project description for a cross-platform simulation game spotlighting business management. The overall vision is for a simulation game that provides an immersive business management experience, highlighting key concepts and strategies in an enjoyable and interactive format. The goal is to create a game that is not just fun to play but also provides educational value in business management. It's important to have an intuitive user-interface design that can easily guide players through the game mechanics and further enrich the overall gaming experience. The ideal freelancer for this project should possess the following qualifications: - Significant experience in cross-platform game development, with emphasis on iOS and Android - Strong underst...
I will inflict on you about a thousand pictures of cookie cutters I produce, and an excell file where you will have to replace the existing name with the name that describes it and you will also have to divide them into categories.
scraping 80k of data using python and export it into excel file
I am seeking a data entry professional with strong keyboarding skills and attention to detail. The task involves entering both textual and numerical data into a spreadsheet. The project will entail managing 100-500 records. I need information from webiste to be copied to excel sheet Ideal skills/Experiences: - Proficiency in Microsoft Excel or other spreadsheet software - Strong data entry skills with emphasis on accuracy - Experience dealing with large amounts of data - Must be efficient and organised. Kindly bid if you have proven experience in similar projects and can deliver this task within the given timeline. Accuracy is absolutely critical in this role. Your work will directly impact data-driven decisions and enhance operations.
I need someone to convert 20 PDF files into Excel spreadsheet format. See attached of ONE pdf file (to give you an idea) that needs to be converted to Excel. Secondly, once converted to Excel format, I need a slightly new design (colour scheme and presentation) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert I also need the FAQ PDF and the "Quick Start Guide" PDF converted to word documents.
...Potential to earn significantly with dedication, achieving 3-5+ sales per week. • Remote role with flexibility to work from anywhere. • Supportive team committed to your success and growth. How to Apply: If you're ready to contribute to our business success, apply with your resume, cover letter. Highlight your sales and digital marketing experience, especially with Google Ads, and your ability to excel in a remote work environment in your cover letter....
...the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. (I translated it into Dutch on Google, it must apparently be proofread) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Netherlands. Some of the records include several
I am in need of an Excel expert to meticulously comb through my data and correct errors. The main task involves handling a phone numbers list riddled with duplicates. Key Responsibilities: * Identify duplicate entries in the phone numbers list. * Cleanse and correct information accordingly. Ideal Abilities: * Excellent Excel skills * Ability to spot errors quickly * Prior experience in data cleaning and error correction * Attention to detail is critical This job requires a keen eye and precision. Apply today if you have the necessary skills.
I am seeking a reliable individual with experience in data entry, particularly with entering text data, to assist with my project. Prior work with similar tasks is key, so please be sure to highlight any relevant experience in your proposal. Specific job requirements...entering text data, to assist with my project. Prior work with similar tasks is key, so please be sure to highlight any relevant experience in your proposal. Specific job requirements include: - Enter text data accurately - Must have past work demonstrating proficiency in data entry - Final format of data must be in an Excel spreadsheet The ideal freelancer for this task will have: - Strong attention to detail for accurate data entry - Demonstrated experience with Excel - Proven track record of punctuality...
...freelancer with intermediate Excel skills to accurately and efficiently perform data entry from online resources. - Task: Your main job will be to gather data from specified online resources and input this into Excel. Accuracy is key in this role. - Skills: Your Excel skills should be at an intermediate level. You should be able to use Excel functions efficiently, handle large datasets, and have good attention to detail for data accuracy. - Experience: Previous data entry experience will be highly beneficial, especially if you have performed data entry from online resources. Having familiarity with a variety of online platforms is also advantageous. This project requires diligence, accuracy, and efficiency. The right freelancer will be proficient in ...
I'm looking for a professional who can efficiently input a variety of data types into an Excel spreadsheet. The data will be both text and numeric, along with dates. Key Project Details: - The spreadsheet will contain less than 100 columns and rows. - Data will be sourced from online resources. - Please ensure accurate data entry and review all entries for completeness and consistency before delivery. Ideal Skills: - Proficient in Excel - Attention to detail - Strong research ability and adept at sourcing information online - Accurate data entry skills
I'm looking for a professional with broad experience in AutoCAD 2D drafting and Excel data entry. AutoCAD Drafting: - You will be working on mechanical design projects. - Your primary role will be to convert manual drafts into 2D AutoCAD drafts. - Meticulous attention to detail in replicating these designs in AutoCAD is crucial. Excel Data Entry: - Additionally, your role will also include meticulous data entry tasks in Excel. IDEAL SKILLS AND EXPERIENCE: - Proficient in AutoCAD 2D drafting with an emphasis on mechanical design. - Experienced in data entry in Excel. - Attention to detail is a must. - Experience in mechanical engineering design will be a plus. I look forward to working with someone who can meet these requirements and help me take my ...
I'm seeking a proficient professional with excellent data management skills. The project involves: - Data entry with primarily text data. - Utilizing Microsoft Excel for this data population task. - Reformatting the entered data into a well-organized database. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data entry involving text-based data. - Familiarity with database design and management - Attention to detail - Strong organizational skills This project emphasizes accurateness and adherence to detail, hence the perfect candidate would be someone highly meticulous with a proven track record in similar projects.
Job Description: We are seeking an experienced and dynamic Excel Data Management Coach to provide live coaching to our team. The ideal candidate should be proficient in all aspects of Excel, from basic functionality to advanced data management, and be capable of delivering engaging and informative sessions in Malay. Our goal is to significantly enhance our team's Excel skills for improved data management and analysis within our projects. Responsibilities: - Conduct live coaching sessions in Malay for a group of employees at times agreed upon with the team. - Provide a comprehensive syllabus or course outline that covers all aspects of Excel data management, -from introductory concepts to advanced techniques. - Ensure the course material is engaging, up-to-...
I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...
I'm in need of a specialist highly proficient in MATLAB, specifically one who can develop, perfect, and run a complex Maze Solver simulation. Key requirements include: - Highly skilled in using MATLAB for creating simulations - Know how to create a Maze solver program Your role includes: - Developing the maze solver simulation that is complex in nature - Running the simulation, observing results, and making necessary adjustments The freelancer would ideally have a deep understanding of the intricacies in MATLAB, alongside their application in real-world simulations. Experience in dealing with maze solver simulations will be seen as a major plus point. Candidates with proofs of similar tasks accomplished will be highly favored during the selection process. Y...
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I need 24 hours of your expertise in internet research to pinpoint distributors in the USA for Pergolas & outdoor furniture, the core products I aim to feature on my website. Finding these distributors is challenging, and your ability to uncover them would be invaluable. Upon identification, please add them to the provided Excel list, noting the number of brands they represent. Be aware that access to some sites might require a 'dealer login'. This task is an initial step towards a regular monthly assignment focused on supplier sourcing. Initially, my goal is to identify 1-2 very good distributors to kickstart the process. I would ask you to research 24 hours in 3 milestones, and each 2 days send me an excell with an update of about 8 hours of work. It could be that ...
I need a freelancer who excels in Excel to carry out some basic data entry tasks of 7 columns in 75 rows. I attach the excel sheet. Please note that you will get the information from the first page of the reports attached here. The pdf file name is the project id identifier. Note: appraisal_complete is basically closing date appraisal. You don't have to add any additional information apart from the ones I asked for in the excel. In essence, you will be entering numeric and date data, with formatting required for the date data. This task is simple, therefore no complex formulae or data validation will be needed. Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience in data entry This should be a straightforward job for...
I'm in need of an expert who can effectively use Interactive Brokers Excel API for streaming real-time options data. I need only 2 types of data 1 stocks last price 2 open interest of every option price
I'm in search of a professional to create an easy-to-use Excel inventory management system. This project focuses purely on the management of raw materials. Key Features needed: - Automated data entry and reporting/analytics will be key features of this system. - Capability to continually track stock levels. Preferred Skills and Experience: - Fluent in Excel - Experience in creating inventory management systems - Excellent UI/UX Design skills - Experience in data analysis and reporting - Familiarity with raw materials management will be a plus. This tool should improve our inventory management and provide clear analytics on our stock. Experts only, please.
...individual who can dive into the digital world to source viral, copyright-free videos for us. These videos will be reposted across various social media platforms, so we need someone with a keen eye for trends and the viral potential of content. Key Responsibilities: - Video Sourcing: Find viral videos that are engaging and have the potential to perform well on social media. - Excel Management: You'll be provided with an Excel file to fill out for each video, including the title, a brief description, and the URL of the video. - Video Requirements: Videos should be compatible with "Shorts" formats – this means they need to be less than 1 minute long and in a 9:16 format. Additional Instructions: - Content Variety: We're looking for videos across...
I'm seeking an experienced corporate and real estate paralegal who can assist with several operational tasks, predominantly involving: -Drafting of various legal documents, -Conducting comprehensive legal research, and -Assisting with contract negotiations. My business operates in the corporate and real estate legal fields. The individual I'm lookin...experience in corporate and real estate law sectors - Expertise in drafting a wide range of legal documents - Proficient in contract negotiation - Strong research skills - Broad understanding of business legalities. The right candidate will play a crucial role in my company, providing regular and diligent paralegal support to ensure smooth operations. If you have the experience and knowledge to excel in this role, I enc...
I'm seeking a professional with proficiency in Excel to interpret and visualize my company's sales data. The project involves transforming our monthly sales figures into an intuitive, easy-to-understand line graph. Key requirements include: - Ability to translate complex data into a clear, meaningful line graph. - Using the graph to indicate the highest and lowest sales periods, effectively allowing for product comparisons. - Proven experience with Excel is necessary, particularly graph creation and data visualization. The ideal candidate should have a solid background in data analysis and preferably in sales data interpretation. This project requires accuracy, attention to detail, and ability to deliver within tight deadlines. Graphing details are: 1. Revenue...
I'm in need of an expert who can effectively integrate Interactive Brokers Excel API for streaming real-time options data. I need only 2 types of data 1 stocks last price 2 open interest of every option price
I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible wi...
I need an Excel wizard to refine my availability calendar. The Calendar is Google Sheets-derived and ought to be fairly straightforward for a skilled Excel user. The tasks include: 1. Date Formatting: Revise the date format from its current mm/dd/yyyy to dd/mm/yy. Your expertise in Excel functions and formulae will be key to achieving this seamlessly. 2. Color Coding: Reconfigure the colour of booking designations based on the occupant. I want a color-coding system involving red, blue, green, pale blue and purple. Your keen eye for design and detail, as well as your understanding of conditional formatting, will enable you to implement this effectively. This engagement requires proficiency in MS Excel and Google Sheets. Familiarity with conditional formatting ...
I'm seeking a qualified game developer with a strong competency in creating engaging mobile simulation games, targeted towards an adult audience. Ideal Skills: • Expertise in mobile game development • Strong grasp of simulation genre • Understanding of adult gaming preferences Responsibilities: • Design and implement a captivating mobile simulation game • Validate designs to ensure it caters to adult gaming preferences • Iteratively test and refine game based on feedback In addition to the above, applicants who can bring creative ideas to improve upon the game concept will be highly regarded. Familiarity with the latest trends in the gaming industry, specifically within the simulation genre and the adult market is vital....
...below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your detailed proposals!...
I need an excel system for One Drive that will enable me to effectively monitor my business' trash expenses. The following features should be included: - Data entry for each individual bill spent on trash. I'll manually enter the amount spent on each bill. - Calculation of total trash expenses over a given period. - Monthly reporting of trash expenses, to aid financial planning and cost analysis. Having experience in Excel, formulas, complex calculations and reporting will be handy for this project. If you're familiar with One Drive, that's even better. Perfect for someone who is detail-oriented, precise, and efficient.
I am in need of a skilled freelancer to carry out web scraping in a professional and timely manner. The ideal candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. ...candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. Please ensure you highlight your experience in your application. Upon completion, I'll need the scraped data to be organized and delivered in an Excel Spreadsheet format for ease of analysis. Key Skills: - Web scraping - Data mining - Data extraction - Proficiency in Excel, for the clea...
Join our team as a Telemarketer and earn commission-based pay for your hard work! We do not require any upfront payment from our employees - all compensation is provided after the completion of tasks. If you are motivated, results-driven, and ready to excel in a dynamic sales environment, we want to hear from you. Contact us today to learn more about this exciting opportunity!
More details: What is the purpose of the Excel sheet data typing project? Data entry What type of data will be entered into the Excel sheet? Both numerical and textual data What is the source of this data? Manual entry
I'm looking for a professional experienced in Power Automate Desktop to autom...looking for a professional experienced in Power Automate Desktop to automate a task I regularly deal with. The task involves extracting specific 'pricing details' from multiple webpages, and subsequently transferring this data into an Excel file. Skills and Experience: - Proficiency in Power Automate Desktop - Expertise in web data extraction and management - Knowledge of Excel data handling Please note that the automation must be able to cover multiple pricing details - whether they are listed singularly or in package form, and accurately convey them into the Excel file. Prior experience with this type of automation is a plus. The successful candidate will have the capaci...
I need a professional to extract emails, phone numbers, and usernames from Instagram users' followers. These data are crucial to launching my marketing campaign. After the completion of extraction, I want the data to be delivered in an excel spreadsheet. Skills in Instagram API and data mining will come handy and are thus ideal for this job. An experience in extracting big data sets from social platforms will also be advantageous.
I need an expert with a strong background in Python to extract specific data from a PDF file. You'll need to accurately shift this data to a structured CSV or Excel spreadsheet. Key Responsibilities: - Browse a folder containing PDF files - Extract text-based information from the source files - Extract each line item and append it to the existing list if not add to the list - Focus on retrieving numeric data and dates specifically - Ensure the dates are formatted as 'DD/MM/YYYY' - Generate a log of processed files and errors if any Skills & Experience: - Python programming - Data extraction, wrangling, and analysis - Previous work with PDF data extraction strongly preferred - Attention to detail is vital, to ensure accurate data extraction - Understanding of d...
I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given th...
I'm in dire need of a proficient professional with strong skills in Microsoft Excel, particularly with linking and integrating data across spreadsheets. The focus is on nutritional data, specifically numerical data. Key Project Requirements: - Experience in managing numerical data in Excel - Ability to flawlessly link different Excel sheets for seamless data retrieval - Hands-on ability to import nutritional data from a database to an Excel sheet - Strong attention to detail to ensure accuracy and consistency of imported numbers Your efforts will greatly simplify my day-to-day management of nutritional data. An understanding of nutritional data or related fields will be a strong advantage, though is not entirely necessary. Speed and accuracy are of utmos...
...File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse it as required, and send appropriate responses. Ideal Skills & Experience: - Robust knowledge about APIs, specifically in relation to Excel integration. - Experience in handling Excel files wit...
I am in need of a unique yet straightforward website, primarily dedicated to sharing an event calendar and notes from various day trips. I would like it to be easy to update. Right now I have excel tables. Want easy to share and update (no public update). Can share what I have now. Want the ability to add a few links to other sites, to add a small number of pages or a subsite in case I start a small side gig - for example an airport shuttle service Key Features Required: Event Calendar: - The ability for me to add events, complete with crucial details like date and time. - Display of these events should be flexible, allowing both a monthly and weekly view. Day Trip Sharing: - Each day trip note needs to be in an individual blog post format. - I would also like an interactiv...
I am in urgent need of a dedicated virtual assistant fluent in data entry for text and numbers into Microsoft Excel. The task at hand will involve: - Populating an Excel database with text and numerical information. - Using five different fields for each entry. An ideal candidate should possess: - Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Please note ...
I need expert guidance and daily minimum 3 hours mentorship for at least 2 weeks to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI appl...
Looking for old Forex Excel files need IT, UK Leads if you have some lists give me the info how many have you got? info must have name, last name, email, phone number bulk needed around 1m per geo if you have it send me small image to see the fields, cost amount
