Access large excel file jobs

Hi kindly read carefully and if you can do it contact with me please otherwise not. Read a vehicle elements like (make, model, version, company name) from car ecu (Electronic Control Unit) file which is written in hexadecimal format. so your job is to find a way to read the hexadecimal file by php and find car elements from the file. I have a reference site which is developed in php and if you upload any ecu hexadicimal file then they will find car elements from the file and you will show in a form. kindly see attached file. reference site: Kindly check video: Budget: 500 USD

...furniture that utilize electrical and mechanical components such as; electric recline mechanism, LED lighting, bluetooth stereo, and various other functionalities *Strong business acumen with a track record of successfully launching and scaling businesses *Excellent communication and collaboration skills to work effectively Benefits: By engaging your services, we anticipate the following benefits: * Access to your valuable industry knowledge and expertise * Streamlined operations and increased efficiency * Enhanced competitiveness in the luxury furniture market * Accelerated growth and profitability * sales development *Reduced risk and uncertainty associated with business startup Submission: If you have proven experience in the furniture industry, a deep understanding of fur...

We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!

I'm looking for an experienced developer to create a web app similar to Glide that will allow users to manipulate an Excel file. This file will be located in Microsoft sharepoint. Key Features: - The platform should be web-based for easier access. - Please ensure users can edit values in the app and it reflects the Excel file. - The developer should have experience with KPI Ideal Skills and Experience: - Demonstrable experience with web app development. - Familiar with financial records and Excel manipulation. - Previous experience on similar projects. Your proposal should demonstrate your understanding of the project and include a brief insight into how you plan to achieve this. Please highlight relevant skills and experiences.

...per minute 2 Creation of operators with profile photo and description and rate per minute 3 Administrator who manages the minute history and chat history in the plugin 4 Insertion of individual operators on the site each with a single code and chat command which allows you to make PayPal top-ups and access the chat 5 Operator status online offline pause 6 Access panel for operators with username and password generated by me where they receive the chats, see the history of the minutes 7 ) Access users to their personal area to top up, chat with other operators and see remaining minutes The plugin must work on several websites and not just one Ideal Candidate Should Have: - Proficiency in WordPress plugin development. - Experience with e-commerce and billing systems. ...

...subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Mevo Dotan, Israel • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact...

...project. The project involves developing a web application based on React. The Django backend is ready, and we need to develop the front-end with React. The backend of the project, along with the visual video and diagram of the desired project, is attached. Here are the specifications we are looking for: Key Features & API Integration: - The app should have User Authentication to ensure protected access. - A robust Course Management system is crucial, allowing for easy input, editing, deletion, and viewing of courses. - The application should also help with Content Organization. - Among APIs, the app requires CRUD functionality extensively. CRUD Functionality: - CRUD operations should be embedded for different entities: courses, students, instructors, and the admin. The in...

...create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model where users can access more adv...

I'm in need of an experienced designer proficient in creating both print and digital catalogues. This catalogue will primarily be used to showcase a multitude of products, thus the ideal candidate should be able to handle a large volume of items. Key requirements include: - Designing both print and digital versions of the catalogue - Proficiency in creating engaging product showcases - Experience in handling a catalogue with more than 100 products Previous experience in catalogue design will be highly valued and a portfolio showcasing such work will be a big plus.

I'm looking for an artist to create a large (20-30cm) anime-inspired rabbit design. Here are the details you need to know: - The rabbit should be white, with pink inner ears and toe beans, and blusher pink colouration. - It must be designed in a Pikachu-like style for both body and face. - The rabbit should be shown in a seated position on the floor joyfully eating a big bowl of noodles with chopsticks in the left hand. Right hand just put at the side of the bowl. - Although it's Anime-inspired, the overall feel should veer more towards a cute atmosphere. Skills and experience required: - Proven experience in Anime-style character design. - Proficient in creating artwork with a focus on detail and colour. - Understanding of the Pikachu-like aesthetic and expressions. ...

...Automatic updates based on sales and purchases. Low-stock alerts for inventory levels. Supplier management for ordering parts. 2. Service Management: Track service history for each vehicle. 3. Reporting and Analytics: Sales reports for revenue and profit margins. Inventory reports for stock levels and turnover rates. 4. User Management and Security: Secure login/authentication. Role-based access control to restrict access to sensitive information based on user roles (e.g., technician, manager, accountant). 5. Parts Catalog and Pricing: Add new parts and update pricing. Estimation Tools: Generate cost estimates for repairs. Integration with pricing databases. 6. Employee Time Tracking: Track employee hours and integrate with payroll systems with monthly reminder of salary 7...

I've described the issue here: I have a streamlit app running on a specific port. I'd like to have setup a reverse proxy using apache. You will not be given ssh access to the server. I'll send you the apache config and then you can suggest changes. Thank you!

The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadsheet with 20 participants. The complet...

...highly skilled interior designer who is adept at working with all design styles to create a complete look for my home. Here are the specifics: - Project Scope: This is a large-scale residential design project covering more than 1000 sq ft. - Design Styles: I am open to all types of design styles - from contemporary to traditional to rustic; the goal is to create a home that's unique, personal, and combines different elements harmoniously. - Skills and Experience: The ideal candidate should have a solid portfolio demonstrating their proficiency in diverse interior design styles. They should also have experience handling large-scale residential projects. Your ability to create spaces that are both functional and aesthetically appealing, no matter what design style, wi...

We are looking for talent to join our team in creating content for children on our YouTube channel. 1. Music Producer: We are looking for a music produce...are looking for a music producer who can create music for our videos. 2. Child Voice (or Modulable Adult Voice): We need a voice of a child, or an adult who can modulate their voice, specialized in creating videos for children. Responsibilities: Singing Composing Creating music Mixing and mastering We Offer: Price per project: $50 Possibility of long-term collaboration, as we need to create a large amount of material for our new channel. If you believe your work fits with our project and you are looking for long-term collaboration, we look forward to having you on our team! If you are interested, please send us your portfolio. ...

...individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Proven experience in data entry, analysis, and visualization - Proficiency in using excel for data tasks...

...professional and complex, so I'm not looking for just any React developer. You should have at least 6-7 years of experience. The development will be done remotely through remote access because the codebase is large and setting it up locally could take days. So, you will be worked on remotely. If the work is satisfactory, I will hire the developer on a regular basis, at least 3-4 days a week. Before starting the job, the code will be shown, and if it's believed that the developer can handle the task, they will be hired. Please bid if you mostly worked on projects from 2015 to 2016, mainly dealing with prop, experience with large react projects. I don't want to work with someone who complains while coding. Please don't tell me this code is too ...

As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks

...accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If this is not possible, then the field should be left empty. Please note that I do not want placeholders like "Unknown" used in the spreadsheet. Your responsibilities will include: - Typing in the book title and author accuratel...

I am looking for a skilled web developer to create a website for my transportation business. The primary purpose of the website will be for billing and inventory management. Key Features: - Employee Management: The website should allow me to manage the access of up to 5 employees to the billing and inventory management system. - Customer Database: The system should be able to store and manage customer information. - Invoice Generation: The website should have a feature that allows for the generation of invoices. The website will not require online payment support as this will be handled separately. Ideal Skills: - Strong experience in web development - Proficiency in creating user-friendly interfaces - Understanding of transportation or logistics business processes is a plus.

...focused on GenAI, SAP Fiori, and SAP BPT. The main goal of this project is to generate leads and conversions from SAP consultants and developers. Additionally creating content for the organisations website as well as other social media platforms Knowledge of Wordpress is beneficial Key responsibilities include: - Developing original and engaging content that is tailored to SAP customers and large enterprise industries running SAP -Knowlegde on SAP Migration - Creating a professional LinkedIn business page showcasing our expertise in GenAI, SAP Fiori, and SAP BPT - Implementing a strategy to generate leads and convert them into customers The ideal candidate for this project should have: - Proven experience in managing LinkedIn business pages and generating leads - Experience...

... The primary purpose of this software will be capturing various questionnaire data and integrating it into a database. The database will also be utilized for setting up Power BI. Key Requirements: - Data capture functionality: The software should be able to collect data from questionnaires. The volume of data is expected to be quite substantial, so the system should be robust enough to handle large-scale data capture (1000+ entries). - Database setup: The captured data needs to be stored efficiently in a database. The database should be secure and easily accessible for future analysis. - Power BI integration: Once the data is captured and stored, it should be integrated with Power BI. This will allow us to generate insightful reports and visualizations, aiding our team in making...

I'm looking for an experienced Android app developer to create an application that can streamline our business operations. The primary aim of this app is to aid in our internal Packing Management process. Essential features to be incorporated include: - Scanning Barcodes for Tracking: This feature should be designed in a user-friendly manner supporting ease of access and efficient operations. - Generating Shipping Labels: The application should also be capable of instantly generating shipping labels, saving us significant preparation time. The ideal candidate will have in-depth knowledge and experience in Android app development, particularly with inventory and packing management features. You should be able to effectively integrate barcode scanning capabilities and ha...

...suitable for Android, using Kotlin and Firebase. This application will not just be an order tracking platform, but a suite that includes features such as: - Order Management: This core function should not only create and track orders, but also be equipped to handle special requests and customizations from customers. - Multi User System: The system should support multiple user logins with varying access rights. - Point of Sale (POS): The system should have integrated POS capabilities - Printing: Thermal Print functionality is a must-have in order to generate customer bills and other essential hard copies. -Reports - sales report, profit etc. The preferred candidate would have prior experience in Kotlin and Firebase applications. Proficiency in creating Android applications and...

...of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understa...

...then be provided with additional details to complete the project. Key Requirements: : Develop engaging content and visually appealing design elements for the annual report. 2. Incorporation of Elements: Include graphs and content similar to those found in the Food Bank of Alaska's annual report, while ensuring originality. 3. QR Code: Include a QR code in the annual report for quick access to our website donation page. 4. Reflective of Our Organization: Utilize images and information from our website () to accurately represent our organization and its mission. 5. Attention to Detail: Ensure accuracy and professionalism in all aspects of the annual report. 6. To provide you with some context, we have distributed more than 580,000 pounds of food this

I am seeking a comprehensive analysis concerning the consumer perception of English-named vehicle brands in Chile. The primary f...brands. Key aspects of the project include: - Send the online survey to 50 precise respondents and collect the data, 50 from the Chile, totaling 50 completed surveys. - The survey should be specifically tailored to collect insights on the associations and perceptions related to the meanings of English automotive brand names. The project is exclusively focused on the Chile. We require surveyors with access to local logistics company owners or truck goal is to gather data that will help us better understand how our target market perceives the English names of automotive brands. Pls have the resources of local freight company owners and drivers in the UK

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.

I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data

I'm in need of an experienced market research assistant to conduct a detailed online survey focusing on the associations and perceptions related to English names of automotive brands. Key aspects of the proje...the project include: - Send the online survey to 50 precise respondents and collect the data, 50 from the United Kingdom, totaling 50 completed surveys. - The survey should be specifically tailored to collect insights on the associations and perceptions related to the meanings of English automotive brand names. The project is exclusively focused on the United Kingdom. We require surveyors with access to local logistics company owners or truck goal is to gather data that will help us better understand how our target market perceives the English names of automotive bra...

I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English

I am in need of a robust and efficient ERP solution for our educational institution that is capable of managing more than 100 users. This project requires expertise in creating modules for: - Student Management - Teacher Management - Course Management While specif...Course Management While specifics for the Overall Educational Management module were not provided, the developer should be prepared for potential requirements like Timetable Management, Attendance Tracking, and Grade Management. Ideal candidates for this project will have extensive experience with ERP system development, specifically for educational institutions. Experience handling systems with large numbers of users is crucial. Your proven track record in delivering high-quality, custom ERP solutions will be highly...

...customers to view different meals and their prices, the app will need a menu feature. System Integration: The app needs to seamlessly integrate with a POS system and an online reservation system. Your experience in API integration is desirable. User Roles: The app should support multiple user roles to accommodate administrators, managers, and waitstaff. Each role will have distinct permissions and access levels. The ideal freelancer will have proven experience in Flutter, Firebase, API integrations, and creating multi-role user systems. This is crucial to successfully building the required features and ensuring seamless performance and easy navigation. I recommend applicants familiarize themselves with the restaurant industry's operational needs to understand the app'...

I'm looking for an experienced artist who specializes in airbrush painting to create a background for a large (48x60 inches) painting. I want something bold and dramatic, painted in black. I have several smaller works that need to be touched up. Ideal Skills: - Proficient in airbrush techniques - must live in Orange county this project needs to be done in person.

Looking for a specialist with experience on examsoft xmzx files. Need to be timely since i need to be able to see the file in advance.

I need an experienced web developer to create a dynamic and user-friendly e-commerce website to sell a variety of physical goods. The primary features that need to be included in this initiative are: - A shopping cart for seamless buying and selling experience - A product filtering mechanism for easy access to various items - Customer review functionality to enable customer interaction and feedback. The perfect fit for this project will be a developer with a proven track record in crafting successful e-commerce sites, particularly those with the aforementioned must-have features. Your skills and expertise should include but not be limited to HTML, CSS, JavaScript, and e-commerce platforms such as WooCommerce or Shopify.

I need an...single-floor barn-dominium style house - Prioritize an open interior, characteristic of barn-dominiums - Ensure the design is structurally sound for the sloped land Specific features I want to include in the design: - A large master bedroom - A large walk-in closet - A large two-shower head master bath - see attached for a complete description Ideal skills and experience: - Proven experience in designing and engineering barn-dominium-style houses - Expertise in architectural and structural engineering, especially for sloped terrains - Ability to incorporate specific features like large master bedroom, walk-in closet, and baths into the design The design should not only be aesthetically pleasing and structurally sound but also functional and tailor...

I've been experiencing ...need a skilled server administrator or a Linux system expert to investigate the root cause of the Apache's erratic behavior and implement a permanent fix for the issue. Key Requirements: - Proficient in Linux server administration - Expertise in Apache server configuration and troubleshooting - Experience with identifying and resolving service disruption problems - Ability to work remotely and access server directly - Strong communication skills This project entails not only identifying the root cause of the issue but also providing a comprehensive solution that ensures the stable and consistent operation of the Apache service in my Linux server. I am eager to work with a professional who can efficiently address this problem and provide ongoing ...

I represent a company that caters to all types of industries - retail, healthcare, and manufacturin...4 hrs a day 5 days a week Ideal skills and experience: - Demonstrated experience in IT sales, particularly in software services. - Excellent networking skills; the ability to establish and maintain successful client relationships. - Understanding of software development, IT consulting, and support services. - Ability to tailor sales pitches to varying business sizes - small, medium, and large enterprises. - Good communication and negotiation skills. The ideal candidate will help us reach out to potential clients, explain the benefits of our services, and ultimately close deals. This is a challenging yet rewarding opportunity for someone with a passion for IT and a knack ...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I am seeking a seasoned salesperson with a strong background in CRM software, particularly those that are used for customer service functions. Your main responsibilities will be selling our CRM software to large corporations. Requirements: - Extensive experience in CRM software sales. - Deep understanding of customer service-oriented CRM tools. - Proven record of selling software to large corporations. Those who can demonstrate a solid track record of high value sales within this specific arena will be highly considered. This role requires an assertive, professional, and dynamic individual who is driven by beating sales targets. Your passion for customer service technology should shine through and inspire potential clients.

We're looking for multiple competent native English editors to trim content and help us improve English language usage across a large batch of tutorials. Starting with a paid trial. Please bid $18.

I'm searching for a competent freelancer who can create detailed, diagrammatic digital notes for Social Science. Key responsibilities: - Preparing comprehensive diagrammatic notes for Social Science topic - Organizing notes for easy access and comprehension Ideal Skills and Experience: - Prior experience in educational content development, especially in Social Science - Proficient in visualizing complex concepts and creating easy-to-understand diagrams - Detail-oriented and has the ability to simplify intricate concepts. In your application, please provide information about your relevant experience in similar projects.

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...

This project will require an in-depth study of 25 large and specific clients within the FMCG sector. Attention will be particularly given to those in the food and beverage, household products, and personal care products segments. Your tasks will involve: - Detailed web digging from platforms like LinkedIn, internal client sites, and recent publications to collect and analyze data. - Pinpointing company trends and identifying industry jargon currently in use by these particular clients. - Compiling this data into succinct, comprehensive one-page reports per client. The ideal freelancer for this job should have: - Solid business acumen and effective online research skills. - Research skills with data scrapping and leveraging LLMs to pull data effectively - Robust summary and repo...

I'm looking to develop an application that seamlessly connects travelers on both iOS and Android platforms. This app's core functionality is to foster a vibrant travel community and facilitate interaction between its users. Key Features: - Personalized Recommendations: The application shou... - Interests: The app should have a mechanism for users to list their travel interests and preferences, which can then be used for matching and recommendation purposes. Ideal candidates should have experience in developing cross-platform applications, particularly social networking or messaging applications. It's crucial that the app is user-friendly, stable, and able to manage a potentially large user base. Strong communication skills and a proactive approach to problem-solvi...

I'm in need of assistance modifying the HTAccess on my webserver. The goal is to have the /wordpress_portal sub...domain, , is accessed by a visitor. The ideal candidate for this job will possess: -Expert level understanding of HTAccess rules and webserver behavior -Proven experience in web development, particularly WordPress -Ability to complete the task promptly, as it's needed ASAP. In summary, you'll be tasked with: - Modifying my HTAccess file - Ensuring the /wordpress_portal subfolder appears as the frontpage - Ensuring visitor access to takes them directly to the aforementioned subfolder. I appreciate your interest in my project, and I look forward to working with a skilled professional who can complete this task accurately and in a timely manner.

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

...song in ENGLISH promoting unity and support for children in war zones. Specific roles include A GIRL lead singer, A BOY lead singer, AND A CHORUS. This exciting project requires natural, gifted singers with a great ear for music, and ideally previous experience or comfort in a recording studio setting. Requirements: - Singing experience preferred. - Ability to convey emotion through vocals. - Access to recording equipment/studio. - Able to take direction well - Remote collaboration and adherence to timelines required. Details: - Professionally composed melody and track available. - Selected singers will record vocals over the track. - Final product: animated music video spreading hope to war-affected children. (4:30 mins in total) Please answer the following questions when su...