Comparing excel files using code jobs

You should be having a YouTube and a Facebook account. In this project, you will be primarily focusing on entering data into spreadsheets. This job comes with an important responsibility as the data provided must be organized and prepared for analysis. Here's what I'm looking for: - Expertise in data entry work, particularly with Excel. - Strong attention to detail when transferring data. - Knowledge in data analysis; however, no specific analysis method required. - A strong candidate for this job would have prior experience with similar tasks, as well as strong analytical skills to help transfer the data accurately. Here is the task. @VegasMatt/videos Order the videos by latest it will be easier Go through

As we dive deeper into data analysis, an improved visual representation of our findings is required. Consequently, we need someone proficient in Excel and experienced in conditional formatting. Your task will be: - To apply conditional formatting within a certain range on our Excel data. - To highlight values which fall within this range, rather than color coding them. Skills required: - Proficiency in MS Excel. - Experience in conditional formatting. - Attention to detail. We look forward to having a clearer and more streamlined view of our data.

I am in need of a highly proficient developer with expertise in JavaScript, Excel, and PHP for automation tasks associated with excel sheets. Though specific tasks directly related to JavaScript and PHP scripting were not defined, the focal task is oriented towards developing excel macros specifically designed for sheet automation. Key Responsibilities: - Macro development for excel automation - May also involve JavaScript coding and PHP scripting Ideal Candidate: - A demonstrated history of successful macro development and Excel automation - Solid understanding and command of JavaScript and PHP - Ability to provide a detailed project proposal Please include in your application your relevant experience, your past work particularly relating to macro de...

I require an audit expert to delve into a specific task concerning the inherent risk in the coal mining industry. This task involves comparing initial audits to repeat audits in relation to their impact on inherent risk. Furthermore, the qualified professional will also need to describe the impact of estimates and judgement required for accounts on inherent risks. Key responsibilities and parameters: - Assess the impact of initial vs repeat audits on inherent risk from a company's annual audited report - Describe the impact of estimates and judgement required for accounts on inherent risk - Develop and apply specific criteria and parameters for assessing this impact in the coal mining industry Ideal Expertise: - Expert knowledge in coal mining industry audits - Experienced i...

Creating an Accounting Excel Sheet and create an automation form.

...with expertise in reviewing and interpreting insurance policies to provide a comprehensive analysis of auto insurance policies, Commercial Property, Commercial General Liability Coverage, and Commercial Crime Coverage. Your responsibilities would involve: - Scrutinizing the details of each policy to provide an exhaustive understanding of the liability coverage and insurance claims processes - Comparing policies and identifying potential loopholes or areas where coverage may be defaulted or denied - Delivering your insights and findings in a well-structured written report, highlighting critical areas of concern Ideal experience and skills: - Extensive experience with commercial insurance policies, specifically auto, property, general liability, and commercial crime coverage -...

I'm seeking a skilled developer to create database or programme to accurately reconcile multiple csv files of data from different time periods into a single spreadsheet. Individual csv files need to be imported to create a single worksheet or report keeping the time period data distinct. The project includes: - Understanding of multiple CSV databases. - Accurate importation of each CSV file into a worksheet report. - Ensuring the integrity of the data during the importation process. Ideally, the candidate should possess: - Strong data analysis skills. - Experience with handling large CSV files. - Proficiency in Excel or similar spreadsheet application with understanding of database structures. - Attention to detail to maintain data accuracy. - Knowle...

I'm in need of a data analyst, capable of performing descriptive statistics and correlation tables, along with two linear regressions using Excel. I aim to identify trends and patterns that will help in improving operational efficiency and bolstering data-driven decisions. • The project involves analysis of data sourced from a Spreadsheet/Excel file. • The ideal freelancer should be skilled in Excel, descriptive statistics, linear regression and data interpretation. • The purpose of the research is not just to understand the current state of affairs but to make strategic decisions for the future. • A background in market research will be beneficial for the project. Your task will be to provide me with a comprehensive report deta...

I'm seeking a skilled web scraper to extract valuable data from Website 1. The data to be extracted includes the company name, address, location, phone number, and email. The priority of extraction should be the phone nu...location, phone number, and email. The priority of extraction should be the phone numbers and emails first, followed by the rest. - Extract information from Website 1 - Prioritize phone number and email extraction - Populate a single Excel sheet with all fields The ideal freelancer for this job should have robust skills and experience in data extraction, web scraping, and Excel. Timeliness and accuracy are of utmost importance. If this sounds like a project that matches your skills, I'd love to hear from you! Need to Extract data from attached...

I am looking for a proficient professional who can create an advanced Excel Gantt chart for me that is produced from a table extracted from Salesforce. This would involve: - Incorporating elements of task scheduling and progress tracking into the Gantt chart. - Completing the project within a span of 1-2 weeks. - Breaking down each task on a weekly basis to provide a comprehensive visualization of the project timeline. Skills needed for the job would include proficiency in Microsoft Excel, experience in creating Gantt charts, a good understanding of project management principles, excellent time-management skills and attention to detail. Familiarity with task scheduling and progress tracking would be essential.

My needs involve monitoring the geographical location of cars using a Bluetooth Low Energy (BLE) tracking device. I am specifically interested in the development of a device that's efficient, reliable, and precise in tracking and updating the location of cars in real time. Ideal skills and experience: - Extensive experience with Bluetooth Low Energy (BLE) technology - Expertise in vehicle GPS systems - Strong background in real-time data streaming and handling - Proven track record in hardware device development Responsibilities: - Design and development of the BLE tracking device - Ensuring real-time and precise tracking of car locations - Testing the device for efficiency and reliability - Providing support post-development.

I need a freelancer skilled in Excel who can create a sales tracking sheet for me. My focus is on monitoring the sales revenue of my business. Here's what I'm looking for: - A sheet where sales data can be manually input - A system that can effectively track AR from the customers Ideal Skills and Experience: - Advanced Excel expertise - Experience in data entry - Your role will involve not only creating the system, but also ensuring that it's easy for a person without a technical background to use. I'm hoping that this project can be completed efficiently, with minimal revisions needed.

I need a QR code specialist with strong skills in database design and web development to build a platform focused on static QR code generation and seamless database management. Key components of the platform will include: - Static QR Code Generation: The primary feature should allow the generation of static QR codes with embedded website URLs. - Database Management: The platform should be backed by a robust database. The database should store all generated QR codes and related data efficiently. Experience with barcode technologies, especially QR codes, and great proficiency in database management systems will prove integral to the success of this project. Knowledge of the best practices for embedding URLs in QR codes is also vital.

...take on fantasy romance. **What to Include in Your Proposal:** - A brief overview of your experience in fantasy and romance genres. - Samples of past work that showcase your storytelling skills and ability to capture the essence of fantasy romance. - Your approach to creating enchanting tales within the constraints of a short story format. This project is the perfect opportunity for writers who excel in delivering impactful narratives in a brief format. If you have a talent for creating worlds where love knows no bounds and every sentence is a step into the magical unknown, I invite you to submit your proposal. Let’s create something truly magical together....

In this project, I'm in need of a proficient Java developer who will perform a series of experiments comparing the efficiency of dictionary implementations using unsorted and sorted arrays. Key Responsibilities: • Implement both unsorted and sorted arrays based dictionary. • Assess the ease of implementation for both. Skills and Experience: • Proficiency in Java programming language is a must. • Strong understanding of arrays and dictionaries in Java. • Previous experience in performance testing will be highly beneficial. • Ability to document results in a clear, concise manner. The main outcome of this project is not just the efficiency measurements, but also an analysis of how simple or complex it is to implement these different dict...

I am needing someone to create 200 photoshop files created using a template along with questions from a spreadsheet. We have 5 different categories of questions, with 40 questions in each category. Each question will be transferred onto its own card. We already have created the photoshop templates for the 5 different categories. We just need the text transferred and centered on each document. If it would be easier for you, it could be done in Adobe Illustrator instead. Please see the Text Centering to see how we want the text centered. Please see the Text Centering to see how a sample of multiple cards with different amounts of text, all centered properly. Please see the File Naming to see how we want 1 file per card, and how it is to be named by the category

I am looking for an expert in chatbot development who can construct a bot capable of engaging in meaningful discourse based on the contents of differing PDF documents. The chatbot will need to be fully integrated into an existing website, and should excel in suggesting relevant content from PDF files based on user interaction. Major functionalities include: - Ability to parse and understand content from a series of PDF documents - Skilled at suggesting relevant PDF material based on user chat inputs - Capacity to adapt dynamically to regularly changing PDF content Ideal applicants should possess strong skills in artificial intelligence, natural language understanding, machine learning, and web development. Past experience with dynamic chatbot development would be a signific...

I'm seeking an experienced software developer to create a Microsoft Office Add-in or application that could function in Word and Excel. This digital tool should be designed with artificial intelligence capable of recognizing factual and procedural questions within the documents. With a foundation in machine learning and chatgpt, it should be apt in offering answers by analyzing previous documents and accessing website information. I'd like the system to be versatile in its response presentation; it should present suggested answers both within the document and/or in a pop-up window. Looking forward to working with someone who has: - Significant experience in AI and Machine Learning - Understanding of Natural Language Processing for question detection - Proven track recor...

I am experiencing some difficulties with my Stripe subscription code, which is written in Node.js and react. The way I'm doing it is, I'm importing stripe using import { loadStripe } from '@stripe/stripe-js' I'm creating a function called handleSubscribe. const handleSubscribe = async (priceId) => { const stripe = await stripePromise; try { const checkoutSessionResponse = await ('/api/create-checkout-session', { priceId: priceId, customerId: customerId, }); const sessionId = ; const { error } = await ({ sessionId: sessionId, }); if (error) { (error); } } catch (error) { ('Error creating or redirecting to

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: ...developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corpor...

We're a service organization that uses a customer database that can be exported into an excel format that we want our service paperwork to reference and auto-populate in specific text fields. Any changes in the spreadsheet need to be reflected in the service form PDFs. So, we're in need of a competent developer experienced in Excel, PDF manipulation, and integration. Your task will be to create functional PDFs with formulas that reference my Excel spreadsheets. Key Aspects: * Proficiency in using Microsoft Excel * Expertise in Lookup and reference formulas mainly VLOOKUP, INDEX * Ability to develop a system that integrates PDFs with Excel spreadsheet to reflect real-time changes. We're looking for an expert who can deliver thi...

I need to create an addon for excel where I will send email using the built in mailmerge and outlook will be used to send the email. The addon needs to: 1) monitor for replies sent from these email 2) if no email is received from the domains (as replies may come from a different person) where the email was sent, outlook will trigger a calendar reminder to send a follow up email 3) an email follow up template should be automatically created in the calendar and when I click it, I shouldn't have to add anything extra, except maybe to change the name of the recipient (or if the addon can pick up the name from the first email, that would be best) and then I can click send.

I'm seeking an expert who has comp...1688, Taobao and etc. - Regular usage of WeChat for communication. - Calculating the unit of economics and maintaining a table for each product Mandatory Skills: - Previous experience using 1688, Taobao and etc. - Proficiency in product analysis. - Ability to work with Russian text and marketplaces using a translator. - Understanding of how to use Keepa, Helium10, and JungleScout software to find trending product. - The ability to use Excel/Google Sheets In this task you will need to find 10 items and analyse them. I'm looking for long term business in case of successful completing the task. I'm pinning Excel with the template how it must be filled to calculate profit from the product. Also you will need to ...

I need a freelancer with adept skills in data entry to assist with entering single random words into an Excel spreadsheet. Expertise in Excel and keen attention to detail will be necessary. No particular categorization or field-specific organization is required. However, accuracy in entry is crucial. This task will involve: - Data entry of single, random words into Excel - Ensuring accurate and error-free input - Delivering the completed project on time. Experience in data entry, particularly with Excel, is greatly preferred. Familiarity with handling text data will also be beneficial. Please ensure you're comfortable with such requirements before making a bid.

I'm seeking a skilled individual who can create a complex mathematical Excel program for me. This program will need to perform functions related to 401(K) CONTRIBUTIONS, MATCHING CONTRIBUTIONS, IRS LIMITS AND SPILLOVER. Data visualization focused on financial data. Key Requirements: - Develop financial models within Excel - Design data visualization​ techniques to present this financial data - Implement interactive graphs, allowing for visible outcomes based on different inputs. - Facilitate 'what-if' scenario changes, which will impact the outcome and must update correspondingly - Implement a system where variable inputs are updating corresponding outputs effectively. Ideal Skills & Experience: - Experience in Excel programming - Strong backgro...

As an experienced developer in C programming, you will have the opportunity to produce a fully documented source code for reading and setting the time on DS1302 RTC interfaced with PIC16F887. This includes: - Creating both 'Read' and 'Set' functions for the time on the RTC. - Providing a Proteus simulation of the entire operation. - Delivering the completed, error-free code within a strict 6 hour timeframe. Previous experience with microcontrollers and real-time clocks is highly recommended, to guarantee prompt and accurate delivery.

...player's goal-scoring prowess. I'm seeking an Instagram video creator to craft engaging 1-minute videos highlighting an athlete's skills from soccer matches. The ideal candidate will extract compelling moments from VEO footage to create daily Instagram posts showcasing a particular player's talents. Payment will be per video, with potential for ongoing work based on efficiency and quality. If you excel at creating captivating sports videos and can deliver promptly, this opportunity is for you. Key Requirements: - Advanced video editing skills are mandatory. Expertise in motion graphics, advanced effects, and professional color grading will be highly valued. - In addition to showcasing the player's goal-scoring abilities, the videos should highlight gene...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I require an automated system, coded in Python, to perform checks on Visa card validity through the website Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverabl... Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverable: - A Python script that can automatically run these checks and save them. Project Outcomes: - Verification of card validity. - The results need to be saved in an Excel (*.xlsx) file format or in my attachment Experience: - Freelancers with familiarity in Visa APIs, Python, and know-how of working with Excel files will find this task in their field of expertise.

I'm in need of someone who can create permanent, menus in both Microsoft Excel and OneNote - For Excel: The permanent drop-down menu should consist of various colors, always displayed on the screen ,that I don't have to click to open. - For OneNote: The permanent drop-down menu should consist of an array of tags, always displayed on the screen, that I don't have to click to open.

I am looking for an expert with proficiency in Microsoft Excel to redesign and update my current invoice template on Excel. You will maintain the agreed-upon overall structure but give it a fresh, modern aesthetic. The document must be made from scratch on a new Excel as the old design isn't saving in colour when saving on PDF. Colours must be the same as existing template. Your responsibilities will include: - Redesigning the template in accordance with the modern design principles. However, the overall structure of the existing invoice should be retained to ensure similarity. - Updating the existing invoice template to a more contemporary design yet similar to the existing document. - Potentially modifying formulas or adding new columns if necessary. Ideal ...

I need a skilled programmer to build a background check code for my web application. This should be focused on retrieving criminal record information from public databases within a regional/national scope. Requirements: - Strong knowledge of database programming - Proficiency in data retrieval from multiple public databases - Prior experience building background check systems is a plus - Understand the legality and ethics of retrieving criminal record data Please note: As this is focused on regional/national data, a good understanding of local public database sources is essential. No international checks are needed.

I require the expertise of a Power BI maestro who is proficient in creating dynamic, interactive and visually appealing reports from sales data. This project specifically involves: - Analyzing sales data I will provide in Excel format. - Constructing and designing a Power BI matrix table for reporting purposes The ideal candidate is proficient in Power BI and Excel with an in-depth understanding of sales data reporting. You should be able to translate complex data into informative visuals & interactive reports. Producing accurate, error-free analysis within arranged timeline is critical for the success of this project.

I'm currently in the process of cloning an e-commerce website (shopify). The majority of the site is working splendidly - about 90% - but there are still some kinks in the code that need to be addressed. Areas needing attention: - images not showing Ideal skills and experience: - I'm really looking for freelancers who have substantial experience in website development and code correction. Prior experience in troubleshooting and problem resolution would be a bonus. Application information: - For your application to be successful, I'd like to know about your experience, specifically any similar projects you've worked on or any issues you've managed to solved in this area. I know it's just a small fix to do so my budget for this is around...

...will take advantage of an intuitive drag and drop interface and a Laravel backend setup. Key functional requirements include: 1. Drag and Drop Interface: The script should incorporate an easy-to-use, drag and drop interface. 2. Laravel Backend: The script will need to utilize Laravel on the backend. Familiarity and expertise with Laravel is a top priority. 3. Code Generation: The main purpose of the script is to generate code subjected to different flow diagrams. Mastery in this area is highly recommended. The platform compatibility is flexible as the question was skipped by me, making it acceptable across Windows, Mac, and Linux. Ideally, I am seeking a professional with prior experience in similar projects. I look forward to seeing your detailed proposal. What I�...

As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing map...

As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...

I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in ...

I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split in...who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should have relevant experience, and prof...

I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project b...

As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eli...

I am looking for an individual experienced in AI, preferably with knowledge of Microsoft Azure or a similar platform. The task requires the conversion of a dual-language book, found at the following link - into a .tmx file format through the use of AI. Essentials for this project are: - Knowledge and experience with AI, ideally with Microsoft Azure - Proficiency in English and some knowledge of German language - Ability to convert a book into .tmx format This is a personal project, however, it's associated with an NGO. It is beneficial if prospective freelancers have experience working on similar projects. There is the potential for recurrent work, contingent on the successful execution of this task. Due to the nature of the project, a commitment to quality and timeliness is a must...

I need someone to build me 3 different deepfake detection models trained on DFD Challenge dataset by Kaggle

I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...

I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...