Excel linedela

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...

PLEASE READ BEFORE BIDDING & BID THE EXACT VALUE. I am looking for a iOS & Android App that can work on Mobiles & Tablets I have attached a Salon Service list, this need to be developed as an App where the customers can view on Mobile and Tablets. ...SHARE YUR APP WORK SO THAT I CAN UNDERSATND YOUR COMPETENCY. Key Features: - The app should have a clean, modern and minimalist design. - It needs to be compatible with both iOS and Android platforms. Ideal Skills and Experience: - Proven experience in mobile app development, especially for both iOS and Android platforms. - Strong UI/UX design skills to create a modern and minimalist app in line with my vision. Please note that the app will not include any booking or review/rating functions - it will solely serve a...

...flyer should convey the necessary details for our grand opening and the introductory offer we'll be providing. - Our brand logo and name should be prominently featured. - Service we offer needs to be highlighted. - The flyer needs to be provided in color, and gray scale versions. - Review website for branding scheme and photos, etc. Style: - The design should have a modern and sleek aesthetic, in line with our brand image. Ideal Skills: - Graphic Design: Experience in creating engaging and modern flyers. - Branding: An understanding of how to incorporate our logo and maintain brand consistency. - Copywriting: Ability to succinctly convey the necessary details. - Marketing: Insight into creating a design that attracts attention and drives interest. If you have a portfolio...

I have a PNG, image-based image that I want to improve. The main task lies in making a certain curved line within the image extremely smooth. Skill Requirements: - Graphic design expertise - Strong Photoshop abilities - Experience in logo redesign and smoothing techniques Please ensure you can handle PNG files and can deliver the redesign retaining high-resolution quality. The attached image shows the curved line that needs to be improved. If selected I will send you the entire image.

...Ideal Skills: - Excellence in illustration and attention to detail is a must. - Prior experience in creating maps for fantasy games is not essential, only the result counts. The end result should be a game map that leaves players immersed in the game's world. Any AI generated elements must be blended in so the map doesn't look AI generated. - A few small "rendered" colorized sections of the line-drawn coastline must be submitted as a sample of what the final large map will look like. The expansion-maps have to be in the exact same illustration style as this first mediterranean one, and we would like to order the expansion-maps immediately after completion of the first map of the mediterranean (ideally everything would be completed by the end of 2024, but ...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I am in search of a proficient Flutter developer to create a sleek, minimalist mobile app that transcribes speech to text. This sophisticated app should be able to t...Expertise in Flutter development - Proven record in developing cross-platform mobile applications (Android & iOS) - A knack for creating minimalist and user-friendly interfaces - Experience in, or knowledge of real-time speech recognition technology. I am aiming for an intuitive user interface that leans toward a minimalist style. Thus, you should have excellent UI/UX design skills that are in-line with this aesthetic aesthetic. Once completed, I want to provide users the opportunity to transcribe their spoken words into text instantaneously in a stylish, minimalist environment, accessible from their Android o...

I'm in need of a skilled developer to create a small platform in ColdFusion that focuses on trading with interactive charts. Below are the main components and requirements for the project: - Development of three linear graphs: The platform will feature three line charts for displaying market data. These charts should be clean, visually appealing and designed to be easily readable by users. - Interactive graphic element: A key feature of the platform will be an interactive graphic element that users can draw anywhere on the screen. This element should be fully customizable, with the ability to be resized, dragged and dropped, and change color. It's important that this feature is intuitive and user-friendly. - Visual design: The platform should have a frontend that is vis...

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

Task 1.1: D...any paid service. • Use LLM inference API to gather some information or generate some insights from the 10K filings for a given company. • note: we are not giving instructions on a specific ”insight”. The judgment calls you need to make to decide on a ”good insight” is part of the assignment scoring. The assignment is deliberately vague as we want you to make some good judgment calls. • give 1-2 line explanation on why a user would care about this insight. • Construct a visualization from the generated insight/information. Task 2: Construct and Deploy Simple App • Using the Task 1 code as the backend, create a simple app that takes the company ticker as input and displays some visualization. PS: Mention the insights yo...

I'm seeking an experienced developer to create a web application. The purpose of this application is to extract table data from PDF documents and translate it into various chart formats, specifically bar graphs, pie charts, and line diagrams. I also need the application to be capable of handling data pivoting. Ideal candidates would have strong skills in data extraction techniques, chart creation, and web application development. Understanding of data manipulation and presentation is also a must.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

I'm in need of a TikTok Manager who can focus solely on growing engagement and reach of my TikTok account. Specifically, the key tasks include: - Content Strategy: The right candidate will develop a strategy that's tailored to my account's core theme - sports. This will involve understanding the latest trends and creating content that's not only engaging but also in line with what my followers would be interested in. - Engagement Growth: The primary goal of this role is to significantly increase my account's engagement. This includes increasing likes, comments, shares and ultimately attracting more followers. The right candidate should have a solid understanding of TikTok's algorithm and how to effectively boost engagement. - Daily Updates: I expect...

Good afternoon, I'm seeking suggestions for names and logos for my new fashion brand. I'm Jose Apolinar Pintos Caride, CEO of this company that will specialize in creating t-shirts for both casual and gym wear, hoodies, swimwear, sweatpants, and jeans. For the latter, the logo will be minimal, as I will place the brand name there. Ideas: Initially, I have considered that the use of acronyms, initials, or some element related to my name, as well as the exploration of references to the god Apollo, from which "Apolinar" comes, could have more chances of success. However, I am completely open to innovative and creative ideas that may surprise me and exceed my expectations. If the suggestions align with these directions, I consider they could have more potential, although ...

...skilled designer to create a minimalistic yet captivating logo and symbol for my new eyewear brand, Tavare. The brand's target audience is young adults aged 18-25 so the design should resonate with this demographic. Key Details: - The colors I'd like to see incorporated are black and white, along with a touch of gold. - The overall style of the logo should be clean, uncluttered, and modern in line with a minimalistic approach. Ideal Skills and Experience: - Proven track record in logo design, especially for fashion or lifestyle brands. - Strong understanding of minimalistic design principles. - Familiarity with the characteristics of the young adult and professional demographic. - Ability to create a design that resonates with the brand's target audience. ...

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...

I'm looking for a seasoned individual with expertise in Amazon listing optimization to help me list my physical product with various colors and sizes. Key Responsibilities: - Craft a compelling product description that resonates with individual buyers. - Optimize images for the listing in line with Amazon's guidelines. Ideal Skills and Experience: - Proven track record in optimizing Amazon listings for individual consumer products. - Proficiency in writing engaging product descriptions tailored to individual buyer personas. - Strong understanding of Amazon's image optimization standards.

I need an expert PowerPoint designer to take my Word document and convert it into a highly engaging PowerPoin...engaging slides Ideal candidates should be highly skilled in PowerPoint, have a keen eye for design and a proven track record of similar projects. Efficiency and attention to detail are crucial. I uploaded the Word doc. The design style must be easily editable using the Designer feature in Powerpoint for Mac. Show me some Powerpoints you have done in the past. Insert the letters MUL on the first line of your bid in order to show me that you have read the above and that you are not an annoying auto-bidder. Please place your final bid and time-frame in which you can deliver the slides. I will create a milestone but will only pay you after the files are sent to me and are...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

On-line | Anywhere Native English speakers GMT+8 (9:30-18:30) on weekday 8-hour working day on your computer 2~5 weekdays from Monday to Friday 3～6 months at least 80-100 usd per weekday Based on your working ability Monthly Payment based on your working weekdays in total.

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

...to handle their roles effectively. Project Goals: • Enhance Communication: Ensure that every team member clearly understands what is expected through direct and effective communication. • Improve Operational Efficiency: Streamline processes to increase productivity and reduce unnecessary overhead. • Maximize Profitability: Focus on strategic initiatives that have a direct impact on the bottom line. • Cultivate a High-Performance Culture: Develop a workplace environment that is challenging yet supportive, where high performance is recognized and rewarded. Ideal Candidate: The ideal candidate will be a seasoned leader with a proven track record in operational excellence, preferably in IT or software development environments. They should have robust experienc...

I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Idea...

webscraping cdiscount using python and export it into excel

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I am seeking knowledgeable and experienced e-commerce freelancers to guide an expansion of my product reach into several major marketplaces. The goal is to launch my line of home decor products made from semi precious stones on Amazon, eBay, Flipkart, Etsy, Walmart, and Target. For this project, your tasks would be to: - Set up and optimize my product listings on each platform - Develop a data-driven strategy to reach and engage the general public - Monitor performance and adapt the approach as necessary The ideal freelancer for this job has: - Proven expertise in leveraging multiple e-commerce platforms to maximize visibility and sales - A deep understanding of SEO and algorithm-based listing strategies - Experience in targeting the general market with a range of product types

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...

As an innovator in the dye industry, I'm in se...professional with a background in dye formulation, quality control, and color matching. Your role would primarily involve the development of specialized dye products. Here's what is expected: - Formulation and improvement of dye mixtures. - Implementation of quality control mechanisms. - Precise color matching to ensure product consistency and quality. - Development of specialized dye products in line with my innovative vision. Ideal candidates will have a strong history in the dye industry and a proven track record in product development. Your experience in dye formulation, quality control, and color matching will be critical to our success. I look forward to creating groundbreaking products together, let's re...

Location: Remote (EST Working Hours Required) Start Date: Immediate Job Summary: Join our dynamic digital marketing agency as a Project Manager and Virtual Assistant, supporting a diverse portfolio of small business owners and entrepreneurs in the e-commerce sector. This role demands exceptional project management ski...to work during Eastern Standard Time (EST) and maintain high responsiveness. Responsibilities: Host daily client check-ins via Zoom. Manage, edit, and upload e-commerce products. Schedule and oversee social media and email marketing campaigns. Develop and manage project outlines and timelines. Innovate and improve operational processes. Application: Email your resume with "SAmit" in the subject line. Include a summary of your relevant experience and sta...

...professional assistance with product photography for my line of hair care products. I have approximately 10-20 different items for which I need high-quality, clean, and minimalistic images. Requirements: - Experience with product photography, ideally within the beauty and hair care sector - Proficient in creating a clean, minimalistic photographic style that will emphasize the product features - Capable of managing a project involving 10-20 distinct products Expertise in lighting and the ability to capture images that will appeal to my customer base is essential. A portfolio showcasing previous work in similar style or industry would be advantageous. The aim is to ensure that these images highlight the quality and uniqueness of my hair care line while maintaining a sim...

...ahorros significativos que la implementación de un software de gestión de gastos, específicamente Rindegastos, puede ofrecer a la empresa. Formato del Modelo: Excel Adaptable: El caso de negocio debe estar en un formato de hoja de cálculo Excel, permitiendo personalizar y modificar los parámetros de ahorros y otros datos específicos de cada cliente. Presentación PowerPoint: La información del Excel debe trasladarse a una presentación en PowerPoint modelo, facilitando la exposición y discusión de los beneficios y datos financieros en reuniones con la gerencia o stakeholders de la empresa. Contenido Específico: Análisis de Costo-Beneficio: El Excel debe permitir comparar ...

I'm in need of an experienced audio editor to help clean up the sound of a 50-minute podcast. This requires particular attention to: - Removing static background noise. The podcast seems to have a consistent static noise that I want completely eliminated to improve the listener experience. - Adjusting volume levels: The podcast requires normalization of volume levels across its entirety. It'...and consistent. Ideal skills would be experience in audio editing, noise reduction techniques, and podcast production. Familiarity with professional audio editing software is a must. I appreciate a keen ear for detail and someone who can enhance the podcast audio quality to a professional standard. if work is done well, I would love to have this person be my personal podcast editor d...

...license keys for an Excel template product. Key responsibilities are: * Design and develop a License Key Generator using Python. * Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a d...

I'm looking for an Excel file that contains a list of companies in Dubai, specifically from the Technology and Hospitality industries. The file should include the following information for each company: - Company name - Address - Phone number - Category of business Key requirements: - Data should be accurate and up-to-date - Companies must fall into the Technology or Hospitality industry

I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.

I'm seeking a graphic designer with a knack for minimalistic, modern designs. The primary purpose of the flyers is to increase brand awareness, so they must: - Showcase my company's logo and tagline prominently - Feature images of specific products or services - Include our contact information and social media handles The designs should be sleek, clean, and in line with our company's aesthetic. If you've done similar projects in the past, please include examples in your bid. A solid understanding of branding principles will be crucial in this project.

...can assist me with various tasks in Microsoft Excel and content writing. The ideal candidate should be proficient in Python and C programming languages. In Excel, I require help with: - Data entry and organization: Assisting me in organizing existing data and entering new data into specific format. - Formulas and calculations: Creating formulas and performing calculations on the data. - Power point: Making power point presentation. - Programming: Automating specific tasks using Python and C programming. In terms of content writing, I need support with: - Copy paste: Help me in copy paste some data. - Story: Writing a story. - Resume: Writing a professional resume. The ideal candidate for this project should have a good understanding of Excel and programming, p...

I'm looking for an expert in Excel who can assist me with data analysis and spreadsheet design. The main objective of this project is to create compelling data visualizations. Key Tasks: - Analytical reviewing and summarizing of data - Design of clear and comprehensive Excel spreadsheets Objective: - Creating simple charts and bar graphs for data visualization The ideal freelancer for this project should exhibit solid skills and previous experience with data insights extraction, spreadsheet design, and data formatting. Familiarity with basic data visualizations such as charts and bar graphs is essential.

I'm in search of a talented and experienced content creator to develop engaging and modern content for my Instagram ads, which will primarily be image and video-based, working to drive traffic to my website. Key Responsibilities: - Creating image and video-based ads that are highly engaging and visually appealing - Ensuring the ads are in line with a modern, minimalist theme - Focusing on driving traffic to our website through the ads The ideal candidate for this project should have: - Proven experience in creating high-quality, engaging image and video-based content for Instagram - Experience in creating ads that drive website traffic - A strong understanding of modern, minimalist design principles - A solid portfolio demonstrating previous successful ad campaigns If you�...

...of RSP Advanced (content in first 1.5 page of the attached factsheet) in the same style as page 8 of the 19/20 yearbook. All of this is B2B communication for a professional audience. Deadline is May 7th 2024 5pm CET Key points: - Photos, logos and visuals can be provided or bought online ensuring proper license rights are secured. - The style of the advertisement should be modern and sleek, in line with with the LDC Corporate Identity and brand guidelines which will be provided to the selected designer. - The add should be an engaging, eye-catching design while fitting with the general theme of sustainability in agriculture Ideal skills and experience: - Proficiency in graphic design, with a strong portfolio of modern, sleek advertising design. - Excellent communication and ...

As the owner of an upcoming fashion boutique catering to men's and women's clothing, I'm looking for a creative professional to help develop an overall design concept in line with a modern and minimalistic aesthetic. Key tasks and responsibilities: - Strategically incorporate textures, patterns, or prints into the overall design to enrich the visual experience without compromising minimalism. - Integrate custom illustrations or graphics to define the unique personality of the boutique and the brands it hosts. - Achieve an overall minimal and clean style, ensuring the design reflects a modern, airy and sophisticated shopping environment. Ideal skills and experience: - Proven experience in boutique or retail store design, especially in the fashion sector. - Profici...

...deletion/Jim_Connors Ref References 1. Shelley, G. (1975, September). Bring on the Music. *TV Radio Talk*, (55856-0), 12, 58. 2. Deeb, G. (1974, February 22). 'WOLD' tells disk jockey's station in life. *Chicago Tribune*, Section 2. 3. Crowther, H. (1974, February 15). Connors Was The Model For 'WOLD'. *Buffalo Evening News*, p. 34, Section III. 4. Utterback, B. TV Personalities Man Picket Line. *Rochester Democrat & Chronicle (D&C)*. 5. Clements, G. Stereo 102. 6. Kennedy, E. M. United States Senator. 7. Simpson, K. (2017, October 3). Early 70s Radio - WMEX (Boston) Top 40. *Early 70s Radio*. Retrieved from 8. Recorded Historical Audio Interview - Jim Connors & Harry Chapin. (n.d.). Retrieved from https://youtu

...vehicles. Mainly I need the the pcb and electronics designed and I can make the housing and everything else. If you would also want to design the housing in ok with that. Needs to be almost waterproof. Mainly splash proof and heat resistant. It will be mounted in the engine bay. As far as the controller goes all it need to be able to do is check pressure from a pressure sensor that will be connected in line from the compressor and control a 12v output source(5a at 12v) to trigger the compressor to turn on as well as for deflating need a valve to be controlled to air down to set pressure. Looking for keep it as simple as possible. Only gonna need about 4 buttons. Maybe more if we add some other functions. Best bet is to call and discuss this as there are a couple other versions of...

Excel expert. In excel, I have the following columns: Tasks, Responsible, Workload hours, and one column for each month with deadlines. For each responsible, I need the summarized workload by week. This is to be able to evaluate (based on the estimated workload-hours) if each responsible has enough available hours to deliver the tasks.

...relating to text alignment on my canvas. What I need - 1. The text should be always in the center position within the wrapper. 2. There will be a variable that has 3 options: a) automatic b) shorten c) line break. if the variable value is "automatic" - Then the text should be in one line whatever the text length it is. That means you need to decrease the font size accordingly. if the variable value is "shorten" - Then the text should be in one line too but if there is no space at the end it will cut the text. if the variable value is "line break" - Then the text should go to the next line if there is no space at the end. **** I have uploaded a zip file. Here all the code is done but based on file in this folder...