Excel pivot tabelle database connectioncông việc

...HUAWEI S5731-h48T switches. Specifically, starting from a reset switch, we need to understand: A brief, concise introduction on how the configuration works in general. How to enable SSH connection on all switch ports: 2.a. How to change the default port for SSH connection. How to enable the WEB interface on all available Ethernet ports. How to set ports to TAG mode, both via command line and WEB interface. How to set ports to UNTAG mode, both via command line and WEB interface. How to export and reload the configuration. DETAILS: The support operation must be performed via TEAMVIEWER connection to a laptop that is connected via SERIAL to the reset switch. At the end of the work, we need specific commands along with comments and best practices. Upon comple...

Let's work on the upgrade of DiscoverChat as discussed and add the possibility to display images requested within the app + connection with the latest GPT4o API

...Geo-fencing: The device should support the creation of virtual geographic boundaries, and alert the control center when the vehicles breach these boundaries. - Fuel monitoring: It should be equipped with technology to monitor fuel levels in real-time, allowing for efficient fuel management. The device should support the following communication interfaces: - 4G/LTE: To ensure stable and fast connection for data transfer. - Bluetooth: To allow for wireless communication with other devices when needed. The ideal candidate for this project should have experience in: - GPS device development - Fleet management systems - Embedded systems - Communication protocols, particularly 4G/LTE and Bluetooth. Do you have what it takes to deliver the most efficient and reliable fleet managemen...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more...

I'm looking for a skilled developer to help us in creating a seamless connection between Wufoo (form builder) and our CRM Hirehop, using their respective APIs. Ideal Skills and Experience: - Proficient in working with APIs - Solid experience in integrations between Wufoo and CRMs - Skilled in real-time data synchronization - Familiar with creating triggers for data transfer Key Deliverables: - Set up a real-time synchronization process between Wufoo and Hirehop - Ensure that only 'Order Details' data is transferred - Create a trigger for data transfer upon form submission on Wufoo Prior to responding please take a look at the HireHop API documentation here:

...GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). - Knowledge of data handling and Excel automation. - Strong communication skill...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...

...offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, an...

I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and co...potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and ne...

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making technical funct...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....

I'm looking for an exhaustive list of Australian gym owners, with a focus on capturing between 100 to 500 individual records. The data needed includes, but not limited to: - Owner's Email Address - Gym's Name - Gym's Website Ideal candidates for this job are experienced data miners and researchers. Having a good understanding of the Fitness industry would be beneficial. Strong attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community He...

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

...WPForms. The form should save all submitted data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Exce...

...This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and experience for the job: - Proficiency in Laravel and PHP - Experience with database setup...

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and functional...

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I need an innovative and modern one-page A4 brochure designed for our new part "Smart Signal Adaptor". The brochure should ca...(attached) - Follow our brand guidelines and colours (attached) - Use the fonts in the attached pic - use the smart signal adaptor pics 1, 2 & 3. Ensure they have a 3D effect and pop out of the brochure - Blend the caravan photo into the brochure Description of part: - Modified 12 pin to 12 adaptor - Suited to newer vehicles such as Ford Ranger, Dodge Ram, Silverado, FTruck etc - No trailer brakes connection on their dash if the have factory fitted Towpack. - Brake system sends through 500 milliamps to the trailer plug - Resistance signal on dashboard Once job is completed i will need this sent to me in: - high res - low res - print rea...

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...

I am aiming to have a pi zero programmed to read voltage levels from a 12-volt battery bank. The trigger to start the generator should be a low voltage condition. The purpose of this project is to remotely start the generator, with a focus on maintaining efficiency and practicality through a direct physical connection. Key objectives include: - Programming the pi zero to accurately gauge low voltage conditions - Enabling the generator to automatically power up in case of a drop in voltage. - Continuing the generator input even after the voltage returns to normal, with this feature designed to maintain a steady and reliable power supply. Ideal Freelancer Skills: - In-depth understanding of Raspberry Pi Zero programming for hardware operations - Knowledge in direct physical conne...

I am seeking an experienced network professional for assistance with the initial setup of an ASA VPN. - The primary objective of this project is to establish secure remote access for employees. This means the VPN should be configured to provide a reliable and secure connection without any hiccups. - Your main task will be to correct the configuration errors that have hindered the proper setup. This includes ensuring the appropriate user access is in place and troubleshooting any existing configurations to guarantee smooth operations. The ideal candidate should have: - Proven experience with Cisco ASA VPN configurations - A strong understanding of network security practices - The ability to quickly and efficiently identify and rectify configuration issues This is a time-sensitive...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

business profit loss reporting excel(Jan, Feb & March)

I'm in need of a skilled web devel...The developer should be able to create interactive forms that are user-friendly and smoothly integrate with our current web page. This will involve a combination of design and programming skills to ensure a seamless user experience. - **Shopify Linking for Event Ticketing:** The main function that needs to be implemented is a robust ticket sales tracking system. This will involve setting up a connection between our web page and Shopify, ensuring that ticket sales data is accurately tracked and reported. Ideal skills and experience for this project include: - Proficiency in HTML/CSS and JavaScript. - Previous experience in creating interactive forms. - Experience in integrating Shopify with other systems, particularly for registration tick...

I'm looking for someone with experience with APIs and SDKs in Python who can guide me through successfully connecting to the Kwenta SDK. Your main task will be to help me connect it, so I can execute the order. I'm looking for someone who can explain things clearly and concisely, and is available to answer any follow-up questions I may have.

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...

...professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can populate with our financial data that will then pull into the brochure, i...

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

I need a skilled professional to install Mail-in-a-Box on my RackNerd server. You should set up all the necessary DNS records and ensure the installation is fully secured by implementing a Secure Connection SSL / STARTTLS. Key Requirements: - Installation of Mail-in-a-Box on RackNerd server - Setting up all necessary DNS records - Implementing Secure Connection SSL / STARTTLS Ideal Skills and Experience: - Proven experience with Mail-in-a-Box installations - Strong understanding of DNS management - Expertise in SSL/TLS configuration - Prior experience with RackNerd servers The primary purpose of this project is for educational/nonprofit use, so your help in ensuring the security and functionality of this setup is crucial. Please only apply if you have relevant experience a...

We are seeking an experienced developer or team to create a comprehensive web software and database system for the remote monitoring and control of cathodic protection stations (SKZ) equipped with TE-RCU control units. This project involves developing web applications, database design, and integration of communication modules for real-time data acquisition, SMS/GPRS control, and SCADA system interfacing. More details will be sent in private.

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I am in need of a seasoned digital marketer who can proficiently handle SEO, social media management, and email marketing tailored to reach local customers. This role requires a keen understanding of how ...Craft and execute a strategic social media plan to connect with the local customer base * Email Marketing: Develop a captivating and result-driven email campaign The ideal freelancer: * Experience with SEO, social media management, and email marketing * Proven track record of lead generation * Understanding of local market demographics and trends * Strong analytical skills to track success and pivot strategies as needed * Highly creative in developing engaging and innovative marketing strategies. Take your digital marketing skills to the next level in this multi-faceted role. ...

I'm looking ...create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient solution, as the ge...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...