I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule ...
As a business in Hamburg, Germany, we require a detail-oriented freelancer to conduct extensive pre-employment screenings. The main purpose is to examine potential gaps in employment, authenticate employee references, and confirm past employments. Key Areas: - Verification of Start and End Dates - Detailed check on Job Title and Responsibilities - Investigation into reasons for Leaving Ideal candidates should have experience in human resources, specifically employment verification. They should have meticulous attention to detail and understand German employment laws. Knowledge of local language and business practices in Hamburg is advantageous. Please include in your application any relevant work experience you may have in this field along with a detailed project proposal outli...
...scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable...
I already have a presentation, I just need a small modification, very small work. The powerpoint only needs minor edits. Changing color from green to blue, use same font on all slides. Improve team slide 13 and 14 as well as slide 15 as well as the pie chart on slide 10. Here is the existing file : I could do this in less than 1 hour, I'm busy right now. We do not ask for a full redesign.
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.
EXCEL COSTOS Y PRECIOS EN base al tipo de producto QUE SE ENUMERARARAN DEL 1 AL 10 (ELECTRONICA, SOFTWARE, ETC) , peso , volumen y costo pagamos unos ciertos impuestos de importacion SEGUN EL TIPO DE PRODUCTO NOSOTROS QUEREMOS QUE EN BASE A ESTOS DATOS QUE VAMOS A PREFIJAR PARA CADA CATEGORIA , YA NOS DE EL COSTO , CUANDO EGREGUEMOS PRODUCTOS NUEVOS COMPLENTANDO LA TABLA. CON LOS COSTOS DE ESTA TABLA , NECESITAMOS OTRA TABLA PARA CALCULAR MARGEN DE GANANCIA TOMANDO EL PRECIO DEL PRODUCTO Y NOSOTROS PODER SETEAR UN MARGEN MODIFICABLE PARA CADA ARTICULO DE NUESTRA TIENDA, ESTOS TIENE UNOS COSTOS FIJOS (FEE FIJO DE VENTA , GASTOS DE ENVIO , COMISIONES DE PLATAFORMA QUE VARIAN) ADEMAS NECESITAMOS QUE EN ESTA TABLA SE PUEDAN HACER ¨COMBOS¨ ES DECIR PONER VARIOS PRODUTOS Y Q...
I'm seeking a talented Django/React developer to assist with both front-end and back-end development of my web application for a week. Aside from the code writing, we'll also be doing a substantial amount of testing, idea sharing and brainstorming in a fun, team enviroment. If your an introvert whom just wants a task list - this will not suit, if you wish to spend a week having fun and blowing up a codebase till its happy - this is more for you. The project involves: - Front-end development - Back-end development - Deployment assistance - General development work Skills and experience needed: - Proficient in Django and React.js framework - Familiarity with testing and deployment processes - Strong problem-solving skills and ability to brainstorm creativ...
...com ) is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be involved in our pre-employment screening by conducting a visit to our candidates’ residential address with the candidate’s consent letter. JOB DESCRIPTIONS: • Conduct the site visit to the candidate’s residential address • Conduct the basic verification of the candidate’s residence & reputation with the neighbors, head of the local community, police stations, building operators, etc. &bull...
...business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating ...
I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly presented for easy understanding.
...for discounts. -Validating and applying coupon discounts during the payment process. Admin Panel: -Dynamic configuration of parameters (number of applications, profile validity duration, vacancy details view limit) for different packages. -Management of coupon codes and discounts. Addon development on Integration of zender maximum budget will be 12k pkr maximum fast one week Platform: Other (please specify) - Please specify the platform on which our job portal is built so that the addon can be developed accordingly. Timeline: ASAP - We need this project to be completed as soon as possible. Ideal skills and experience: - Experience developing addons for job portals
I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.
Project Description: We are seeking a highly skilled Photoshop expert to edit a series of van images that will be used for sales and marketing purposes. The primary task is to remove any existing graphics from the vans, making them appear as plain white vans, and adjust the images for a professional look. This includes modifying brightness, color temperature, and other necessary photo correct...any future adjustments. Skills Required: Proficient in Adobe Photoshop with a strong portfolio showcasing photo editing skills, particularly in object removal and color correction. Attention to detail and ability to adhere to specific editing guidelines. Ability to work independently and deliver high-quality results within tight deadlines. Project Duration: This project needs to be done within a ...
I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)
I'm looking to develop a modern and minimalist astrology website. The site must deliver the following functionalities: - Kundli generation, matchmaking, consultation services, educational resources & Services , ecommerce - Daily horoscope updates - In-depth birth chart analysis feature - Compatibility calculator for users interested in their relations with other signs - Reseller services, specifically subscription-based and customized ones (vvimp) Freelancers should possess strong web development skills, with expertise in creating user-friendly subscription models and customized services. A keen knowledge of, or experience in, astrology-themed websites could be advantageous.
I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp
I am looking to develop a web application which will primarily serve as a customer service platform. But, I also need this system to b...real-time data of the plants or whatever it is monitoring. - Automated Alerts: It should have the capability to send out alerts automatically when certain conditions or parameters are met. - Historical Data Analysis: The system should be able to store data over time and provide analysis tools to evaluate past performance. - I also need live weather forecast from google or live forecast for on going week This is a unique project that requires a developer with a good understanding of both customer service web applications and tracking or plant monitoring systems. You need to be skilled at integrating these systems seamlessly to ensure optimal pe...
I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.
I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.
Hello, I have a set of data of various roadways and their extents in excel each with the following primary fields (as well as other fields but not pertinent to this): Roadway Name, Roadway From, Roadway To (For example Name: Mission Avenue / From: Main Street / To: Broadway). I also have a larger polyine shapefile with the same fields as the excel however, the excel From and To extend beyond a single polyine in the shapefile. For Example in the excel the fields would say: Name: Mission Avenue / From: Main Street / To: Broadway In the Shapefile this would encompass multiple segments (ie multiple rows of data) for example: Name: Mission Avenue / From: Main Street / To: 1st Ave , Mission Avenue / From: 1st Ave / To: 2nd St, Name: Mission Avenue / From: 2nd St ...
...to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized members. It is mandatory to pass a short trial test / finish a task, that could last between 2-4 hours, with the possibility of extension to up to 1 week, if the cand...
...to create a comprehensive and highly interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data...
I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.
Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos
...databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play together. Do your best to answer this question using your Neo4j data model. 2. How often do players win in a particular position (relative to the dealer)? In other words, for each hand, consider the order of players starting from the player who is the small blind and ending with the dealer[P1 (SB), P2(BB), P3, ... Pn(Dealer)] (where N can be 8, 7, 6, 5 -- let's not consider games with less than 5 players). Then count how often players in the P1 position end up winning, then P2, and so on until Dealer. Construct a bar chart or something similar to present this information. Again do your best to answer...
...Data entry and research: Assist in organizing and inputting data into our systems. Research on various topics to support business decisions. - SOP Development: Help in developing procedures, growth plans, and policies. - Competitor Research: Conduct thorough research on our competitors, providing insights for business strategy. Expectations: - I require your support for more than 20 hours per week. - Your primary goal will be to help in improving operational efficiency, ensuring that our processes are streamlined and effective. Ideal Skills: - Excellent organizational and communication skills - Strong analytical capabilities for data handling and research - Experience with developing SOPs and growth plans - Previous work in a business development role - Experience in com...
I need an expert to create a proficient HTML website for booking different types of tours, specifically Sightseeing, Adventure, and Cultural tours. The design needs to include: - A user-friendly search engine to filter tours based on location, dates, and price range. - An integrated payment system for seamless transactions. Ideal bids will have a successful background in HTML website design, specifically for booking platforms, and have the ability to integrate a secure payment system. Familiarity with the tourism industry is a plus. Template ref: Ref:
...The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized members. It is mandatory to pass a short trial test / finish a task, that could last between 2-4 hours, with the possibility of extension to up to 1 week, if the candidate is involved in other projects, or not available to start immediately. Please note that the job duration is from 1 month to ongoing / undefined, between 10-30 hours per week (4-8 hours per day). Candidates will have to manage the related tasks, till completion. Therefore the listing should be online, for us to be able to review it. Payment, wo...
...‘Science and Sip’ experience. In this exclusive, immersive pop-up event, guests will be transformed into scientists to create exciting drinks, conduct science experiments, and compete in challenges against other scientists. Responsibilities: - Act as general event staff for monthly events and some ad-hoc events in London. - Event dates and times TBC. These will be shared at least 1 month in advance where possible, at which time you can accept or decline within 1 week. - Temporary / day work: 4-5 hours work. This is a pop-up event that changes locations. - Setup and clean-up: Moving and arranging chairs, tables, equipment and storage boxes etc. - Guest support: Provide guidance to guests based on the briefing. Engage with and encourage guests during the ac...
I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.
I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in...
...management - Attention to detail and accuracy - Proficiency in instant messaging platforms for efficient communication - Reliable and able to work independently - Any additional experience with administrative tasks would be a bonus. Requirements: -Fluent in English -Strong Wi-Fi Internet Connection -Quiet place to work -Have to own a computer that is stable without big issues -Is available 7 days per week -Hours are 7AM-9AM, 11AM-1PM, and 6PM-8PM but there can be some flexibility. -Hard-working and self-efficient -Looking for someone that wants to join a great team for a long-term role -Spanish-speaking and South American location are preferred Benefits: -Room for growth -Management role -Room to increase hours -Can earn an increase in pay -Some flexibility in hours -Country Ho...
I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in fi...
I require a Power Bi expert to assist with transferring and analyzing our sales data, currently stored in a spreadsheet format (CSV, Excel). The main element I need to focus on within the analysis is the sales trends over time. The ideal candidate would have: - Strong skills in data transfer and analysis in Power BI - Experience dealing with sales data - A keen eye to identify and present trends over time effectively. To confirm, your task will involve: - Transferring sales data from a CSV/Excel file to Power BI - Conducting detailed analysis focusing on sales trends over time - Presenting these findings in a useful and understandable format.
I am in need this by MAY 1 3PM max. an Android mobile application to contribute to my ongoing project - a leaf disease detection model which utilizes a streamlit UI. The sole purpose of the app should be to enable users to upload JPEG, PNG, JPG images to my model. Results will not be required to display extensively on the app, thus a minimalistic design would be most appropriate only showing the predicted class, cause and prevention which is already present in the UI. Key requirements include: - Proficiency in Android development - Experience in integration of image upload features - Ability to work with existing systems and models - Familiarity with JPEG, PNG, JPG image format Understanding of image-based machine learning models would be beneficial but is not a necessity.1
I need help with Excel It is advance level so please be careful when you apply. Thanks.
...if they wish to pursue particular job opportunities. We are looking for: Machine Learning Engineer Mission: The mission of the Machine Learning Engineer is to develop, deploy, and maintain a user-friendly and efficient web app for a CV screening solution based on large language models (LLMs). This system should ensure precise AI results and foster organic growth among users. Outcomes: - For 1 week: Create an MVP and launch it in production. The MVP will offer core functionality where a user uploads a candidate's CV and job description, and in return, the user receives a score to decide whether to proceed with the candidate. For the MVP, utilize the OpenAI API, apply proper prompt engineering, and deploy on cloud platforms such as GCP, AWS, etc. - For the next 1 month: Pre...
Responsibilities • Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). Candidates should live in Europe (all European countries), North America (US or Canada) and / or South America (Argentina, Colombia, Paraguay, Ur...
Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.
Hi Do you have experience with both mulesoft and salesforce? It iş sql and salesforce integration using mulesoft For now my task is to solve this error so let see how many hours it takes us and for the new project we will discuss the time per week I need indian time tomorrow morning 7:30 am This support will be on zoom meeting which we will provide u and u will connect with my consultant for support
I am in need of an experienced email marketing expert who can help me out with a campaign. The project entails sending out emails once a week that cater to a variety of content types. These include: - Promotional offers - Newsletters - Product updates The target audience for these emails will be a mixture of both existing customers and prospective customers. Key skills and experiences that I'm looking for in a freelancer include: - Proficiency in email marketing tools - A track record of successful email campaigns - An understanding of how to segment and target different audiences - Creativity in crafting engaging email content - Strong communication skills
Extract the industry data from the IBIS reports and populate the Excel template
I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal free...
I'm in need of a Windows-based inventory tracking program. It should be user-friendly, with specific features to streamline our inventory management process. Key Features: - Barcode Sc...devices used to scan items. - Easy Database Edits: Ensure the end users at the department level can easily make necessary edits to the inventory database. Dataset is roughly 900 items recording the item name (description), Item Number 7 digits, the cost of the item. Dataset can live in excel or access preferably I'm looking for a programmer with experience in developing Windows applications, particularly inventory management systems. It's essential that the program is intuitive and streamlined for easy use by multiple team members. Familiarity with barcode technology and da...
I'm in need of a skilled Flutter developer to swiftly convert my 6-10 screen Figma designs into a mobile application. The project is on a tight deadline, with completion expected within a week. Key Requirements: - Proficient in Flutter: It's crucial that you have a strong working knowledge of Flutter. Previous experience in developing mobile applications using this framework is a must. - Figma Expertise: You should be proficient in extracting design assets from Figma and implementing them accurately in the app. - Time Management: This is an urgent project, so excellent time management skills and the ability to work efficiently under pressure are essential. The successful candidate will have a keen eye for detail and be able to deliver high-quality work within the given t...
Hi Savi B., Here is the iOS documentation project as discussed. We will use DocC. Must document feature and their implementation with all implementation details. DocC documentation Link/URL to be set to All HTML to be converted/ exported to word. First Charity list feature must be done so that we are clear on the level of detail ad presentation ex...document feature and their implementation with all implementation details. DocC documentation Link/URL to be set to All HTML to be converted/ exported to word. First Charity list feature must be done so that we are clear on the level of detail ad presentation expected. On approval the same standard should be followed for entire app. To be delivered within 1 week
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
