Excel simulation vbapekerjaan
I'm seeking a freelancer with exceptional experience in business process automation to help automate my sales process specifically. Here's what I need your assistance with: 1. Data Entry Automation: We have copious amounts of data that require efficient and error-fr...Contact Management: Currently, we're looking for a solution that will automatically manage our leads, track correspondence, and schedule follow-ups primarily through phone calls. 5. Proposal Creation: In order to save time and effort, I would like an automated system that can generate and send proposals, customized based on the lead information obtained. Strong working knowledge of CRM systems, Excel, and programming languages used in automation such as Python or R is expected. Previous experience in ...
As an individual with a lot of paperwork that needs to be digitized, I am looking for a capable freelancer to carry out a variety of data entry tasks. This will involve entering data from handwritten, printe...needs to be digitized, I am looking for a capable freelancer to carry out a variety of data entry tasks. This will involve entering data from handwritten, printed, and digital documents. The number of documents to be worked on will be less than 100, making this a suitably compact project. I need the data to be precisely entered in a Microsoft Excel format. Ideal skills and experience for this project include: - Proficiency with Microsoft Excel - Previous experience with different styles of data entry - Ability to decipher handwriting effectively - Accuracy and att...
I'm in need of assistance to combine several XLS and CSV files into one inclusive XLS file. Each sheet within the file should represent the original file from which the data was drawn. Although some files maintain a consistent format, others vary, thus requiring the ability to manage and merge a mix of formats. - Skillset Necessary: Proficiency in Excel is critical along with the ability to manage data from a multitude of formats. - Task Summary: Translate multiple CSV and XLS files into one singular XLS file with each sheet equating to an original file. - Data Arrangement: Data organized according to the original file it was grouped with. Please ensure your final delivery maintains the integrity of the original data, keeping original files organized, despite the div...
I am looking for a freelancers with Tableau experience to help visualize some data from Excel. The current plan is to generate heat maps in Tableau based on the properties listed in Excel. The deliverable will be Tableau files and screenshot. Please include your hour rate in your reply.
I am seeking a specialist for an Excel Exploratory Data Analysis (EDA) project who can conduct data cleaning, preprocessing, data visualization, and statistical analysis. The project will involve working with both categorical and numerical data and variables. The required skills and experience include: - Mastery in Excel for data cleaning and preprocessing - Proficient in data visualization using Excel - Familiarity with statistical analysis The primary objectives for this EDA project are: - Identification of patterns and relationships within the data - Detection of outliers or anomalies in the data - Understanding the data distribution of variables Please ensure your proposal clearly illustrates your past experience with similar projects and how you intend to a...
I need someone skilled in data entry and Excel to help me create a comprehensive database. I'll provide an Excel file with a list of names that I'd like you to translate into an organised, efficient Excel sheet. For each name, I require the following additional information apart from their email, title, and job specialty: - Company name - Location - Phone number - Job description I don't have a specific excel template in mind, hence, your creativity and technical know-how in creating a user-friendly format will be an asset.
I am seeking a professional capable of accurately extracting attendee lists from a number of LinkedIn events. Details: - The LinkedIn events in question will vary, and a comprehensive list will be provided upon commencement of the project. - A detailed project proposal outlining your approach and methodology is a mandatory part of your bid. Skills and Experience: - Proficienc...provided upon commencement of the project. - A detailed project proposal outlining your approach and methodology is a mandatory part of your bid. Skills and Experience: - Proficiency in web scraping and data mining - Extensive experience with LinkedIn or similar professional networks - Strong attention to detail Please note that the extracted data should be neatly formatted and delivered as an Excel sp...
...of data collection. Work script: 1. Open Google maps in a specific area (provided by us) and search for a specific keyword 2. Collect to Excel table all the businesses related to the specified keyword 3. Find if there is a website and collect it's address if present on Google Maps 4. Find some contacts of high level manager of the company in LinkedIn 5. If you can not find contact details of high level manager, find generic email of the company End result is an Google Sheets table with all the collected data. We are looking for someone, who owns fast computer to do this work effectively. Requirements: * Basic Web browsing skills * Know how to use MS Excel or Google Sheets * Fast computer to have good browsing speed * Must have your own LinkedIn account Table to fil...
I'm in need of a talented web developer to create a portfolio website for my company. This website should be a static one, providing details of our services, a comprehensive company profile, an "About Us" section, and other relevant information. A few salient points to note: • Utilize a color scheme that combines blue and orange, reflecting our...display on various devices. Ideal candidates should have: • Proficiency in web development, particularly in creating portfolio websites • Competency in responsive web design • An eye for aesthetics, as represented by a strong portfolio • The ability to incorporate our requested features and color scheme into a compelling and professional website design. If this sounds like a project you'd exc...
I require assistance with automating pivot table creation in Excel, using Python scripts. The pivot tables would need to handle both numerical and textual data. The primary operations to be performed on the textual data are grouping and counting. Ideal Skills: - Proficiency in Python - Experience with Excel automation - Ability to work with both numerical and textual data - Understanding of grouping and counting operations for pivot tables Tasks: - Develop python scripts for automating pivot table creation - Ensure proper grouping and counting of textual data - Test scripts to ensure accurate pivot table outputs
...report on the grid codes concerning the connection of photovoltaic installations to both low voltage (LV) and high voltage (HV) grids, categorized by surface and power, whether ground-mounted or rooftop, across several European countries. The countries of interest are Poland, Bulgaria, Germany, Spain, Italy, Croatia, Serbia, Czech Republic, and Slovakia. Additionally, we require the creation of an Excel table summarizing the collected data for all these countries. Scope of Work: Conduct an in-depth analysis of the grid codes and regulations pertaining to the connection of photovoltaic installations to both LV and HV grids, characterized by surface and power categories. Identify and summarize the key requirements, restrictions, and standards applicable to PV grid connection in ea...
My project requires a skilled freelancer proficient with Excel to develop a dashboard focused on trip tracking. Key performance indicator that should be incorporated is the number of trips. Your expertise in dashboard and data analytics would be most ideal, while experience in sales, finance, or marketing is not necessary for this specific task. Kindly refrain from including other metrics or data visualization as I prefer to focus solely on tracking trips for this particular Excel dashboard.
I want a skilled CAD designer and simulation expert to create a nano quadcopter drone. The drone needs to be of compact size, composed of lightweight materials, and have high maneuverability. Specific requirements are as follows: - Drone Specifications: The drone should be designed with lightweight materials for efficient flight. Importantly, it needs to be compact yet highly maneuverable. - Flight Time: Ideally, the drone should be able to sustain a flight time of around 10 minutes. Please consider this while designing and simulating. - Control System: The drone must be operable through an easy-to-use smartphone app. Your previous experience in creating CAD designs and simulations for drones will be greatly advantageous for this project. Knowledge of smartphone app integratio...
As a business professional, I need assistance with Excel data entry. Specifically, I need expertise in compiling specific types of data from the web into an Excel format. The project's primary scope entails: - Compiling contact details from various online sources. Given your expertise, you ought to have: - Varied experience in Excel data entry. - A keen eye for detailed, accurate data compilation from the internet. - Strong organizational skills that aid in arranging data logically and usefully in Excel. - Knowledge of Excel functions and commands. - A proven track record in web research. I look forward to receiving well-informed bids from freelancers with matching skills and experience.
As a beginner in Excel, I am looking for a passionate and experienced tutor to give me less than 5 comprehensive lessons, primarily focusing on Excel formulas, functions and pivot tables. Here's what I'm expecting: - Introduction to Excel formulas and functions. We'll go over the basics and gradually delve into more complex usage. - Teach me how to build and manipulate Pivot Tables. This includes being able to understand my data better and make more effective decisions. Ideally, you should have: - Strong command over Excel and its nuances. - Experience in teaching or tutoring, with ability to explain complex concepts in a simple manner suitable for a beginner. - Patience and good communication skills to ensure I properly understan...
As someone new to Excel, I am seeking skilled and patient instruction in this powerful tool. Here's what I hope to learn: - Delve into Excel's formulas and functions - Understand and create pivot tables Through these lessons, I hope to bolster my work-related Excel skills. Therefore, tutors with experience in business applications of Excel will be preferred. Be ready to make these topics accessible to an absolute beginner.
The main goal of my project is to simulate both solar power shading and power quality compensation techniques. This includes both reactive power compensation and harmonic compensation simulations. Key Requirements: - Use Matlab for solar power shading simulation - Must include both reactive power compensation and harmonic compensation in the simulation Ideal Skills and Experience: - Proficient use of Matlab for simulations - Prior experience with power quality compensation techniques - In-depth understanding of solar power shading - Familiarity with reactive power compensation and harmonic compensation simulations would be a plus.
...membership form : It will contain basic details like name, address, district, Mobile number should be OTP verified. I can provide msg91 or smsalerts API Additionally it should have field for Voter ID. Once user submitted voter ID number it should validate using API and voter data is captured in backend and then proceed for final form submission. In admin panel, we can able to see all data, export in excel, filter entries by district, pin code , search using voter id. once user submits form, in end screen it should show application reference number with submitted date and time and they download it as acknowledgement. Ideal Candidate Skills: - Proficient in Angular - Experience in creating user-friendly forms - Comprehensive understanding of data storage and manipulation - Kn...
I have small task need help with excel work and few writing. This is bit urgent.
Task requires a skilled PHP Laravel developer, with expertise in both frontend and backend functionality enhancements. I am looking to make a few modifications/customizations to a script/website. You can view the script (message me). This task requires excellent PHP and Laravel framework skills, as well as good CSS experience. If you excel in these areas and are very knowledgeable, this task should take approximately 1-4 hours to complete. The maximum payment for this task is $30. No bids over $30 USD accepted. Time frame 2-4 days. Some modifications include: Allowing the use of HTML in the content boxes/sections of pages and homepage, Eg: to insert images, videos, info boxes, or any other HTML content. Currently, only plain text is allowed. The aim is to keep it very simple, (an...
You should be skillfull in excel to carry our: Performa DCF analysis of the company, which should include 1. Calculating the FCF 2. Forecasting the FCF 3. Calculating the TV and NPV oft he company
My project involves a comprehensive rearrangement of my existing Excel spreadsheet. The tasks include: - Altering the column order - Modifying the row order - Grouping data appropriately These changes must align with my specific needs, which will be communicated as we proceed - a clear understanding of my requirements is essential. The freelancer best suited for this task would have strong Excel skills and prior experience in customizing spreadsheets to client specifics. Please note, there might be a need for followers up attention, which might include rearranging specific columns. However, these details will be provided as the work progresses. Your ability to adapt to these changes whilst maintaining the quality of work is crucial.
...System Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: Th...
Hola, Tengo un software en un servidor que contiene la información de nuestro catálogo de productos, tieneunas reglas de cambio de ean, stock etc y necesito cambiar unos valores
I urgently need a specialist in Excel Macros to create a template that can swiftly convert my data from its current Excel format to a specified end format. What I require is: - Expertise in Excel Macros. Although my data is in Excel, this task will require more than basic or intermediate understanding of Excel functionalities. Thus, the ideal bidding freelancer should be adept in creating and applying complex Excel macros. - Fast turnaround. Due to the immediate nature of the project, I require completed work ASAP. Therefore, a freelancer with the ability to work quickly and efficiently would be ideal. - Examples to aid understanding. To make the job more comprehensible, I will provide 'before and after' examples of the data conversion. ...
Create an excel sheet where I can score my columns based on categories and sub-categories. There are Two major groups. Likelihood & Impact. The end goal is to get a final Likelihood and Impact score for a bunch of risks. the max allowed score is 9 for both these groups. Each group is divided into 6 categories. Each category can have a max score of 1.5. Each category has 3 sub categories. Each sub category can have a value of 0 or .5. The categories and its subcategoreis for likelihood score is shown below. I need an excel sheet that can help me do this calculation where I can select the value of each sub-category (0 or .5) and I should have a total score of the category and then finally a total Likelihood score. The same will apply for Impact scoring. I can share the I...
I’m looking to hire a proficient Microsoft Excel expert, specifically, someone who excels in automation tasks. Tasks for this project include: - Creating automation scripts for: - Data Formatting: The job will require you to set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and has extensive e...
Hola, necesito un software para mapear un archivo excel contenido en un servidor. Debe se tener un output mapeado con unas reglas
I need a realistic fluid simulation for an industrial process that must include fluid interaction with solid objects. The 3D animation should be rendered using Blender, and the level of detail should be high enough to convincingly demonstrate fluid dynamics within equipment. Details: This is a demonstration simulation. This is not a finite element analysis or computational fluid dynamic simulation. It's simply meant to start a conversation and convey the physics of a device that I have recently developed. The solid objects would be industrial piping that is interacting with a gas such as Helium. We would have to show an acoustic wave propagating through the helium but we can do so with artistic freedom. It could be as simple as a gas that is slowely moving back a...
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...
We are currently seeking English voice actors for male characters for a gaming project. Here are the desired skills and experience: - Voice acting experience - Ability to deliver a quick turnaround, as this project needs completing ASAP. - Understanding of audio recording and editing tools. - Excellent inter...and expressiveness, to ensure the audio captures listeners' attention. Due to the confidentiality of the project, we will send you the audition files upon receiving your application. If possible, you may also send your voice reel and contact information, so that we can reach out to you promptly for any suitable opportunities in the future. This is an exciting opportunity for voice actors who excel at creating intense, dramatic performances. Your voice could bring my p...
I'm looking for an expert to convert NX files to SolidWorks or STEP format, with no modifications to the design during the conversion process. Key Job Responsibilities: - Conversion of provided NX files (est 2GB) to either SolidWorks and/or STEP format. - Ensuring no modifications to the design during the conversion. Ideal Skills/Experience: - Solid understanding and pro...Skills/Experience: - Solid understanding and proficiency in SolidWorks and STEP format. - Proven experience in converting NX files. - Attention to detail to ensure total accuracy of existing file organization. - Good communication skills to report progress and any potential issues. - Willing to sign an NDA - Based in USA Please note, no additional tasks will be required post-conversion such as rendering or ...
...has a keen understanding of the top trends in the iconography. The creative direction for this project leans towards a clean, simplified look that better matches Windows applications such as the Microsoft Office suite icons, for example, Word, Excel, and PowerPoint. Key Project Requirements: - Your design should reflect a professional yet attractive flat design style - The color scheme should be sophisticated and simplistic, complementing Microsoft Office's aesthetic - Please incorporate design elements that resonate with Microsoft Office's Word, Excel, and PowerPoint icons Ideal Skills and Experience: - Demonstrable experience with flat icon design - A deep understanding of Microsoft Office's design aesthetics - Provable proficiency in graphic design sof...
I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations
I'm seeking a proficient freelancer to convert my Excel spreadsheet into a user-friendly form. This form will require expertise in creating interactive components for data entry, incorporating error checking devices, and embedding calculation functionality. Key Aspects: - I require text boxes and drop-down menus for the data entry fields, ensuring a smooth and efficient user experience. - The form must seamlessly check for errors as data is entered, flagging any inconsistencies or inaccuracies. - The ability to tally calculations within the form is a must-have feature. Ideal Skills: - Experience with Excel to form transformations - Proficiency in text boxes and drop-down menu creation - Strong aptitude for error detection and rectification As this is urgent, I need...
...especialista en macros de Excel para desarrollar un simulador interactivo de tasas de interés. El proyecto debe completarse lo antes posible. Sus principales responsabilidades son: - Crear una macro de Excel para análisis de datos e informes. - Automatizar tareas repetitivas dentro de la aplicación. - Desarrollar funciones personalizadas para satisfacer nuestras necesidades específicas. Aunque no se indica explícitamente, será beneficiosa una comprensión sólida de las tasas de interés, su cálculo y los conceptos financieros relacionados, preferiblemente con un enfoque en tasas de interés fijas, variables y compuestas. Su experiencia se reflejará en el diseño e implementació...
...history, performance metrics, risk levels, winning percentage, portfolio analysis, and other relevant data. 4. Paper Trading Simulation - Users can create virtual portfolios and trade with simulated funds to check expert traders accuracy. Even they can place orders individually to check own accuracy of trades. Mimics real market conditions to facilitate learning without risking real money. 5. Revenue Model - Subscription fees mechanism for access and privileges. Commission on Profitable Trades, Referral Registration and Multi-level Commission Structure. Apart from the core features, the app should integrate with Indian brokers and must sustain a paper trading simulation feature for no-risk trading practices. The ultimate objective of this app is to seamlessly connect n...
... This sector includes establishments like restaurants, bars, pubs, breweries, wineries, takeaways, hotels, and residences. Key Responsibilities: • Identify relevant companies in the stated sector • Accurately find and collate their email addresses and phone numbers • Meticulously organise data gathered into an Excel Spreadsheet Preferred Qualifications: • Proven experience in data mining or a similar position • Proficient in data collection and management • Familiarity with Excel and other data organisation tools • Ability to meet deadlines and maintain accuracy Ideal Application: Detailed project proposals would be highly appreciated. They should include your approach or method to the task, anticipated challenges, proposed solutions, ...
...the dropdown will populate with the values that will be sourced from the Excel file. The user will select one value from the dropdown. Based on that value the data will load from the access database. This data grid will be changed by the user and it needs to update the access database accordingly in real time.. There will be multiple users on the website, more than 350 and they will constantly be changing this. There is also a third factor, the main Excel data, and will all get changed according to that file, this needs to be updated every 10 minutes. We have a project in C# completed but it is not working on the multi-user environment, because changes are not made in real-time, and instead of MS access we use Excel to archive the data. Also, it is not convenie...
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...
Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, data visualization and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood
I'm looking for a Microsoft Excel guru who can re-arrange my numerical data, which is in multiple columns, in a random order. The purpose of this randomization is so i can call numbers in random order.
In need of a seasoned Excel VBA expert to develop a comprehensive techno-economic analysis tool for solar projects. The automated tool should accomplish the following: - Automate data entry - Generate informative reports - Perform data analysis to inform strategic decision-making Key functionalities to include: - Calculation of Return on Investment (ROI) - Estimation of energy production The tool should take the following inputs to calculate ROI and energy production: - Initial Investment Cost - Annual Energy Production - Energy Tariff - Maintenance Cost Ideal Candidate: - Mastery of Excel and VBA - Previous experience in creating financial/technical analysis tools - Understanding of solar energy industry would be a plus
I require a skilled freelancer to convert my PDF document, which is less than 10 pages long, into an Excel file. All data from the PDF needs to be included without exception. This task does not require replication of the original PDF format during conversion. Ideal Experience & Skills: - Experience in data entry - Proficiency in Excel - Detail oriented - Prior experience with PDF conversion to Excel will be a bonus. This task is simple and straightforward yet it requires precision; therefore, applicants with a keen eye for detail are preferred.
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...
...distributing content across my social media platforms and blog. This system should be compatible with Facebook, Instagram, YouTube, TikTok, and Wordpress, Using automations, having a control panel for editing each post if necessary All content is in Hebrew Language My objective it to: 1. Create a blog Article/post on my site though: A. A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a minimum 900 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) You may see an article format here :
This project will involve extracting data from the Collins Dictionary website for personal stud purposes. The goal is to scrape all the entries in the Italian-English and English-Italian sections of the site. The data will be used in a flashcard app (Anki), so would need to be put into 2x Excel files, with each dictionary entry on its own row, and columns containing all relevant grammatical information and example sentences. In need of a highly skilled web scraper. You need to avoid disrupting site functionality, which can lead to access denial or legal issues. Prior experience with data extraction from language-related or education websites is a plus. Key requirements include: - Extraction of Italian to English, and English to Italian translations from Collins Dictionary websi...
I'm looking for a skilled spreadsheet specialist who can meticulous...discrepancy is detected, the chosen freelancer should highlight it in the original CSV file rather than creating a new one or recording the differences in a separate document. Skills and Experience: - High proficiency in handling and managing CSV files. - Experience in data comparison and error spotting, especially in large datasets. - Advanced knowledge of spreadsheet software, such as Microsoft Excel or Google Sheets, to effectively highlight discrepancies. - Excellent attention to detail, providing accuracy in finding discrepancies based on exact match criteria. If you're detail-oriented and have a knack for data analysis, this project is your chance to shine. Please bid with relevant experience an...
I'm seeking an Excel professional with strong skills in exploratory data analysis (EDA). Key tasks include: - Performing data visualization - Applying descriptive statistics - Conducting missing data analysis The main goal of this project is to conduct a thorough EDA to find insights and anomalies within the data. This analysis needs to be done on an Excel file that is larger than 1GB. The ideal freelancer for this project would have significant experience working with large datasets, especially in Excel, a good understanding of EDA techniques, and a knack for uncovering hidden trends and patterns. Strong skills in data visualization, descriptive statistics, and missing data analysis are essential for this role. University project, serious individuals only as...
