As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I am seeking a skilled developer to create a platform that accommodates both professional and client users. Key areas of focus include: - Integrating dual login functionality, allowing both professionals and clients to access, manage their profiles, and post jobs seamlessly. This should be a high-priority feature. - Implementing a robust credit system for bidding on jobs. Privacy is paramount until a job has been accepted. - The platform should be optimized for mobile use. This is crucial as professionals and clients must receive real-time notifications regardless of where they are. Proficiency in UX/UI design, database management, web security, and mobile app development is desired. Previous experience in building similar platforms is ideal.
...specific features I want to see: FEATURES SPECIFICATION: - Variety of Jobs: The platform should cater to all employment types whether part-time, full-time, or freelance options. - Matchmaking System: The platform should allow users to connect through algorithm-based matching, manual selection by employers, and user-defined filters to ensure the most suitable matches are made. - Application Process: Job seekers should be able to apply for jobs via an online application form, by uploading their resume/CV or through third-party platforms. IDEAL CANDIDATE GUIDELINES: - Experience in building job platforms, particularly integrating algorithms and filters to enhance user experience - Strong understanding of third-party platform integrations - Ability to build intuitive online app...
I'm urgently looking for a skilled professional to help me secure my website against DDoS attacks, specifically focusing on DNS amplification. work over any disk only must be now !
I'm in need of a proficient developer to create an MRZ Passport scanner using ASP.NET VB.NET. The software will be hosted on a local server for mobile access and use to scan regular passports. Key tasks will include: - Creating a login interface for mobile users - Ensuring scanned passport information (Name, Nationality, Date of birth, Passport Issue Date, Expiry Date, and Date of birth) is accurately captured and saved in respective fields in a designated MySQL table The ideal candidate will have previous experience HR development using ASP.NET, VB.NET and a strong background in MySQL database manipulation and architecture. Familiarity with MRZ Passport scanning and parsing would be advantageous. This is a demo of a similar app:
As a wholesale distributor of advanced security camera models with AI capabilities, we're looking for a freelancer to h...understanding of advanced security camera technology, particularly AI capabilities. - Excellent communication and negotiation skills to present our product portfolio effectively. - The tenacity to secure deals and build long-term business relationships. Your primary responsibility will be to identify and engage potential clients, particularly those in the wholesale domain. Establishing trust and highlighting the unique benefits of our advanced security camera models with AI capabilities are essential. Ultimately, we're looking for someone who can drive sales, expand our business network, and secure long-term partnerships with wholesale clients...
I need a functional e-commerce website developed urgently. Key Requirements: - Development of an e-commerce website - Include all requisite features for a standard e-commerce site such as product listings, shopping cart, checkout process, etc. - The site must be user-friendly and responsive on all devices. Ideal Skills and Experience: - Extensive experience in e-commerce website development - Proficient in web design and user experience - Ability to work under tight deadlines.
I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and collaboration skills
...stream or CMSampleBufferRef audio stream) in real time and apply AI models to perform real-time voice change processing on the human voice. After processing, it outputs the completed voice change audio stream (PCM audio stream) and plays it in real time, so that it can hear the sound that simulates the sound change effect of the currently selected AI model. 2. No latency: The software needs to process audio with low latency to ensure that the sound change effect is synchronized with the input audio. 3. AI Model Switching: Supports switching between different AI models during runtime to achieve real-time switching of multiple sound effects. 4. User interface: A simple debugging interface that does not require aesthetics. It can select and apply different AI sound effects, and c...
I'm seeking experienced professionals who can help transition an established fan base from a previous Facebook page to a new one. My ...necessitating this move. Below are the specific tasks required: - Configuring settings of the new Facebook page - Expert fan transition from the old page to the new one - Addressing any potential issues encountered during the process The ideal candidate will have: - Exceptional knowledge of Facebook's policies and procedures, particularly fan migration - Proven experience handling similar projects successfully - Ability to handle possible difficulties arising during the transfer I do possess access to the old Facebook page which should ease the transition process. Your expertise and assistance are, however, fundamentally nece...
...developer who can help me deploy my PyTorch model into a standalone web application for real-time predictions. Key Project Details: - Purpose: The primary goal of this project is to make real-time predictions with my PyTorch model. The model is already trained and ready for deployment. The weights are in .pt format and it is a pose estimation model. I want to capture the realtime webcam input process the frames and plot out the output(Keypoints). I also want to display the FPS and latency of each frame. - Platform: I intend to use a standalone web application for this deployment. You should have experience in deploying machine learning models in web environments. - Model Maintenance: I do not foresee any updates or maintenance for the model. It will stay as is post-deployment. ...
...to be web-based and compatible with all major operating systems. Key functionalities and features include: - Ticket Purchasing: The system should allow customers to purchase tickets through a user-friendly interface. - Fare Calculation: It should have the capability to calculate fare based on distance, time, or any other parameters provided. - Payment Processing: The system will need to support secure and reliable payment processing for the purchased tickets. For this project, I need someone who is well-versed in Budibase development and has experience in creating similar fare collection or ticketing systems. A strong understanding of PostgreSQL for database management and back-end support is crucial. The project is urgent, and thus I am looking for someone who can complete it...
I'm spearheading an educational project that entails the adaption and translation of English rhymes into Spanish. These will serve an audience of preschool children aged between 3-5 years. The successful freelancer should be: - Proficient in bot...creating rhymes and song scripts especially for preschool education, thus grasping the level of comprehension and enjoyment for this age group. Critical tasks involve: - Translating English nursery rhymes into Spanish while maintaining the rhythm - Constructing age-appropriate rhymes with an educational undertone. Your expertise would contribute significantly to making learning an engaging and fun process for these preschoolers. Your proficiency in Spanish and familiarity with rhymes will be invaluable in creating an effective ed...
I am in search of a skilled and experienced PHP developer to join our team in Dubai. The ideal candidate will have extensive experience, specifically in CodeIgniter, and be able to handle various responsibilities including front-end, back-end, and database management.
We are extending an invitation to skilled professionals who are adept at driving client engagement and boosting sales. Our goal is to forge a partnership that is mutuall...independently contact potential clients. Post-commission, clients are to be directed to our team for further engagement. Compensation: For every successful sale, a 25% commission will be awarded. Upon receipt of your commission, you are responsible for referring clients to our official communication channel to initiate our service process. We believe in transparent and open communication. Should you have any inquiries or require further clarification regarding this process, please do not hesitate to reach out. We look forward to the prospect of working together and achieving shared success. Warm regards,...
I'm in need of a dynamic e-commerce website to list between 50 to 500 products. Not just any website...easy navigation, efficiency, and conversion. Key Features: * A seamless product catalog allowing for intuitive browsing of different products. * A robust shopping cart feature that holds products temporarily as customers continue shopping. * A secure payment gateway that supports various methods and ensures smooth transactions. Ideal freelancer should have: * Experience and proficiency in e-commerce website development. * Solid understanding of creating an easy-to-navigate product catalog. * Proven track record of integrating shopping carts and secure payment systems. Your portfolio showing similar previous works would be a plus. Looking forward to your creative and...
I require a talented UI/UX designer, with impressive skills in mobile app design. The job revolves around creating one login and Signup screen user-friendly and eye-catching interface for a new chatting mobile application. Key features of this app will include: - Login and SignUp functionality: It's crucial to design this in an intuitive manner. Specific skills and experience needed: - Proficiency in designing mobile app UI/UX from scratch. - Prior experience in designing chatting mobile applications is a plus. - Familiarity with designing Login and SignUp pages. - Strong understanding of the latest design principles and techniques. - Exceptional creativity and innovation. The designer needs to provide all the source files and have a solid portfolio to demons...
... Real estate, and BPO. Candidates are expected to have solid knowledge of the recruitment process and be able to deliver quality candidates in a timely manner. Key Responsibilities: - Recruitment for entry, mid, and executive roles - Understanding and meeting the unique requirements of each industry - Sourcing candidates through various channels - Conducting interviews and evaluating candidates' eligibility - Providing a diverse pool of qualified candidates Ideal Skills & Experience: - Proven experience as an HR Recruiter - Knowledge of various industries such as IT, Banking, Real estate, and BPO - Excellent communication and interpersonal skills - Understanding of the full cycle recruitment process - Ability to work effectively in a fast-paced environment. You...
I am seeking an experienced PLC programmer to automate specific processes for me. Ideally, you should have deep knowledge in using software to control a wide variety of motor types, as you may be tasked to work on a diverse set of projects. The details are as follows: - Task: You will mainly be responsible for automating certain processes using PLC programming software. Priority will be given to those who hold significant experience in this area. - Motors: While the specific motors or drives were not provided, it's important that you're well-versed in handling a versatile range. - Timelines: The project needs to be completed within a month. Please bear this in mind as you plan your schedule. Candidates with a strong background in automation and solid problem-solving skills wil...
I'm finding myself in need of a professional who can assist in recovering data from my external hard drive that fell. Unfortunately, this has resulted in some data loss which is of fair significance to me.... - Experience in data recovery, particularly with external hard drives. - Understanding of different reasons for hardware failures and data loss. - The capability to ensure not further damage occurs in the process. The data on the hard drive is somewhat important to me, hence I'm not in a dire rush. However, I'd appreciate a meticulous approach to maximize recovery possibilities. If you have a proven track record for similar works, I would be interested in discussing further. Please ensure your bid includes expected recovery time and assurances of data safety dur...
Dear Market Research Agency, We hope this message finds you well. We are reaching out to you regarding an exciting freelance opportunity to conduct market research in the field of factory and process automation, process control instruments, and industrial automation. Our company, specializes in providing high-quality services to clients in the industrial automation sector. With over 20 years of experience in the industry, we understand the importance of gathering accurate and actionable insights to drive business decisions. Project Overview: We are currently seeking a skilled freelancer to conduct a survey targeting companies in Southern India operating in the MSME segment with a turnover ranging from 2-10 Cr and 10-25 Cr. The survey will focus on distributors and dealers...
As a burgeoning project in demand, we're in need of a Full Stack PHP Developer with a good command of both frontend and backend development. For our backend development, we prioritize: - Proficiency in PHP, MySQL & Laravel When it comes to the frontend, we value: - Experience with Javascript & Web Designing using HTML & CSS. Knowledge on VueJs will be Plus. We're specifically looking for someone at an intermediate level, who has: - A solid grasp of Javascript & PHP. We're excited to welcome a competent, committed developer to our team. Bring your A-game, and let's create something great together.
I am in immediate need of a high skilled Matlab Simulink expert to develop a script for me. This project should be completed using the specified software(MATLAB), and your digital submission must include a comprehensively commented script. This script should clearly demonstrate your approach and the functionality of the script, outlining your problem-solving process. Include any additional work, such as scanned handwritten notes. Finally, consolidate your original MATLAB and Simulink files into a single zip archive. Also, include a PDF document containing screenshots of your scripts/block diagrams and the corresponding solutions. (Questions Attached below. This projects need to be completed within 8 hours from which this post is submitted(Melbourne,AU(AEST, UTC+10):11 PM). The...
We...customisations to their liking from the menu -Social media food trendy(popular items)- Customers can view social media posts that people have uploaded to see what dishes are good and view food inspiration. -Live feedback- Customers can track how long their order will come to the table. Reviews- Customers can leave reviews and rate the food. -Reservations- Customers can reserve a booking - User login - user page for accessing the customer view -Order history- Customers can view order history -Promotion and deals- Customers can view offers the restaurant is giving. -safe payment options - payment through card, UPI and cash seamlessly Ideal candidates should have a solid background in web development, preferably experienced in creating full stack websites. preferably working on M...
Project Description: We are seeking experienced software developers to create a comprehensive and secure remote access solution for home automation systems, similar to Nabu Casa. This project involves building a cloud-based intermediary service that allows users to connect to their home automation systems (specifically Home Assistant installations, referred to as "nrjhub") from external locations without requiring router configuration changes such as port forwarding. Objectives: - Develop a secure, scalable cloud service that facilitates connection from external networks to multiple nrjhub Home Assistant installations. - Implement a system that manages authentication and secure communication channels between users and their home automation systems. -...
As an existing business, we are in the process of expanding our mobile platform by onboarding new service providers. We're seeking a freelancer to assist in recruiting professionals from various industries to join our platform. Key responsibilities include: - Identifying and reaching out to potential service providers - Communicating the benefits of joining our platform - Explaining the onboarding process and answering provider queries Ideal candidates should have: - Experience in service provider recruitment or a related field - Excellent communication skills to effectively engage and persuade potential providers - A strong understanding of various industries to target relevant service providers Please note, we do not have specific qualifications or certifications re...
I'm seeking a talented Graphic Designer to develop a retro-themed logo for my company. Here are my specific requirements: - Color Scheme: The logo should primarily use the following color palette: White, Grey, Red, Black, and Silver. - Logo Style: A clear retro vibe should be maintained in the design. Embrace a retro style that's uniqu...need to be integrated into the design. However, your creativity in this aspect is encouraged. Ideal Skills: - Proven experience in Graphic Design. - Demonstrated ability to design logos in a retro style. - Mastery of color theory and composition. Please include work samples, preferably of retro-themed designs. This will provide insight into your understanding of the style and your creative process. Looking forward to your innovative an...
I am in need of a talented and experienced videographer who specializes in capturing cinematic-quality footage for a corporate event in London April 15 & 16. You will be responsible for filming a high-profile corporate event, capturing the essence of the occasion professionally and creatively. Please note that no editing services will be required, your role would purely involve the filming process. Desirable skills and experience: - Proven track record in filming corporate events - Expertise in crafting engaging, cinematic-style videography - Strong ability to work under pressure and meet deadlines - Detail-oriented to ensure all key moments are captured - High proficiency with professional filming equipment. Please provide a link to a portfolio of your previous work. Looki...
I'm looking for an experienced WordPress developer who can create a custom plugin. The main goal of the plugin would be to integrate external APIs and help manage and analyze content engagement metrics. Key Requirements: - Custom User Registration: The plugin should enable custom user registration, allowing users to have personalized experiences on the platform. - External API Integration: The primary purpose of the plugin is to integrate external APIs for content engagement metrics. It will require a developer who is proficient in API integration to ensure smooth data flow and analysis. Ideal Skills and Experience: - Proficiency in WordPress Plugin Development: I'm looking for someone with a strong background in WordPress plugin development. Previous experience...
I'm finding myself in need of a professional who can assist in recovering data from my external hard drive that fell. Unfortunately, this has resulted in some data loss which is of fair significance to me.... - Experience in data recovery, particularly with external hard drives. - Understanding of different reasons for hardware failures and data loss. - The capability to ensure not further damage occurs in the process. The data on the hard drive is somewhat important to me, hence I'm not in a dire rush. However, I'd appreciate a meticulous approach to maximize recovery possibilities. If you have a proven track record for similar works, I would be interested in discussing further. Please ensure your bid includes expected recovery time and assurances of data safety dur...
I'm in search of a skilled video editor to help me create content for my Instagram profile. Key Project Requirements: - **Editing Style:** The videos will need to be engaging and visually appealing, suitable for a wide audience. - **Effects and Transitions:** Experience in adding advanced effects and transitions is essential, as this will be a key aspect of the editing process. - **Understanding of Social Media:** Familiarity with Instagram's video format and requirements is crucial. - **Consistency:** The editor should ensure a consistent look and feel across all videos, aligning with the overall branding and tone of the profile. Ideal Candidate Qualifications: - **Proven Editing Experience:** Previous experience in video editing, especially for social media platforms...
I'm in need of a specialist with skills and experience in publishing productivity apps in Google's Play Store. Specifically, this project involves a task management app. Key responsibilities will include: - Full execution of app publication process - Setting up a developer account, as I currently don't have one - Providing console access post publication Therefore, a deep understanding of Google's Play Store policies, a knack for trouble-free app publication and an ability to communicate clearly and timely will be appreciated. Past experience with publishing productivity, especially task management apps will be a huge plus.
...Laravel PHP developer to assist me with maintenance tasks on my existing website. Key Aspects: - I need assistance with maintaining and enhancing an existing Laravel PHP website. The key tasks are: - Fixing bugs and errors: There are some broken links, page loading issues, form submission errors, and other functional deficiencies that need to be addressed urgently. - Updating plugins and extensions: The website relies on several plugins and extensions which need to be updated to ensure compatibility and optimal performance. - Optimizing website speed and performance: It's essential to improve the website's speed and performance, this may involve code optimization, database tuning, or other performance-enhancing techniques. Skills and Experience: - Profic...
I am in search of a professional who specializes in financial projection for securing funding. Your primary task would be to develop a cashflow analysis based on loan repayment amount for a product we are selling. Ideal Skills and Experience: -Business Finance -Financial Analysis -Financial Planning A strong background in discounted cash flow analys...strong background in discounted cash flow analysis will be highly appreciated because it is the specific financial analysis method we are interested in. This task requires precision and timely delivery. Therefore, an experienced freelancer who can work within our timeframe and come up with accurate projections will be selected for this project. Your input will greatly inform our decision-making process as we seek funding for ou...
I've been grappling with a login issue on my Pterodactyl panel, which is hosted on a Virtual Private Server (VPS). Whenever I try to login, an error page is displayed instead of allowing access to the panel. Furthermore, the Pterodactyl panel is integrated with a Content Management System. I'm seeking an experienced PHP developer who can diagnose and solve this issue efficiently and effectively. Key Skills and Experience Required: - Proficiency in PHP - Familiarity with Pterodactyl Panel - Experience handling VPS - Knowledgeable in resolving login issues - Experience with Content Management Systems is a plus Looking forward to receiving your informed bids, highlighting any similar issues you've resolved.
I'm in need of an experienced accountant who can take charge of my monthly payroll processing. Key Responsibilities: - Perform monthly payroll processing for my small business - Execute pay stub generation accurately - Ensure the entire process is conducted in QuickBooks either desktop or online Ideal Skills & Experience: - Proven experience in payroll processing - Proficiency in QuickBooks (desktop or online) - Attention to detail to ensure accurate pay stubs - Excellent understanding of tax filing requirements Please note that this project is specifically focused on monthly payroll processing for a small team (1-10 employees).
[Tìm coder người Việt giúp làm 1 trang web đơn giản] I need a proficient React developer who can code and deploy a simple website. This website will be functioning as a demo in Docker container. Key functionalities include: - User login and registration - Product listing and search - API integration for data retrieval and payment (Paypal) All data will be sourced from a specific API, details of which will be shared later. The freelancer should be able to complete this task within a maximum period of 2 weeks. Applicants are requested to share their past work showcasing their skills, specifically in React and API integration. Experience in setting up a Docker container is a plus.
I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.
...Design and develop a user-friendly scheduling/dispatching mobile app for both iOS and Android - Implement a dual method task assignment system: a combination of automated task assignment based on employee availability and manual task assignment by the admin - Integrate reporting features that will help in tracking task progress and overall dispatching performance - Ensure the application is robust, secure, and scalable - Provide post-launch technical support and maintenance as needed Ideal skills for this project: - Proficiency in mobile app development for both iOS and Android platforms - Prior experience in designing task assignment systems - Strong background in UI/UX design - Familiarity with data reporting and analysis - Excellent problem-solving and communication skills I...
I'm on the lookout for seasoned Laravel developers who can build an intricate web application for me. This isn't your run-of-the-mill project; it's a complex one with numerous features. Key Functionalities Required: • User registration and authentication system - I want a secure process where users can register and authenticate themselves before using the application. • Data visualization and reporting - There's a need for functional modules that can produce interactive reports and perform dynamic data visualization. • Integration with APIs - The application must have the flexibility to integrate with multiple APIs for additional functionalities. Ideal Skills and Experience: • Extensive experience building complex Laravel-base...
take the model from another location, draw up the concrete for the new location, combine the files, show the process for lifting , design a stability frame from my sketches.
As a decisive business owner, I am in search of a proficient Business Analyst who can assist me in gathering and analyzing requirements. This is predominantly for our stakeholders and investors who require detailed information about our business process. What You'll Be Doing: 1 ) Please describe the steps necessary to translate the request into functional requirements (NOTE: creating requirements documentation is not required for the purposes of this exercise) 2.) Create one ticket for the delivery team (e.g. in a form of a JIRA ticket) for any of the requirements of your choice Ideal Skills and Experience: - Proven experience as a Business Analyst. - Exceptional skills in requirement gathering and analysis. - Profound knowledge and understanding of sales ...
As an individual beginning a new project, I'm seeking a skilled blockchain expert proficient in Solidity. Your role will encompass the development of a custom blockchain solution on the Ethereum platform. Skills and Experience: - Strong proficiency in Solidity programming - Comprehensive knowledge of how Ethereum works - Proven experience in custom blockchain developm...Comprehensive knowledge of how Ethereum works - Proven experience in custom blockchain development - Be able to offer expert blockchain consultation as needed - Previous experience with Ethereum is highly desirable By joining this project, you'll have the opportunity to work on an exciting new project while using latest technologies. Your expertise and advice will be invaluable in creating a secure a...
...to build a comprehensive web API capable of handling user authentication, data retrieval, and storage. The API will handle two main types of data: user information and product data. X509Certificate: - Implement user authentication: The API should include X509Certificate Certificate user authentication capabilities to ensure secure access Key requirements: - Implement user authentication: The API should include robust user authentication capabilities to ensure secure access. - Data retrieval and storage: The API is expected to effectively retrieve and store user information and product data. - High-quality code: The project requires clean and well-commented code to ensure ease of maintenance and future scalability. - Testing: Comprehensive testing is essential to confirm ...
Wanting a tattoo design that uses my dental Office logo and/or knife making logo. Tattoo will be on tricep area. I am seeking a proficient tattoo artist to design a traditional-style tattoo that captures personal symbolism for my arm. The design should not just be aesthetic, but narrate my personal story in a unique and appeali...unique and appealing traditional style. Ideal Skills and Experience: - Proven experience in tattoo design, specifically traditional styles. - Strong understanding of tattoo placement and design relative to body anatomy. - Exceptional creative abilities to incorporate personal symbolism into design. Expectations: - Original and unique design concepts. - Clear communication throughout the design process. - Revisions until final design meets satisfactory ...
I'm in need of a skilled professional with experience in social media advertising on Instagram, and who can set up an automation process for lead management and communication via text message. Key Responsibilities: - Create and manage Instagram ads to generate leads. - Implement automation for immediate text message responses to generated leads. - Set up regular text messaging for lead follow-ups, booking, and appointment reminders. Ideal Skills and Experience: - Proven experience in Instagram advertising and lead generation. - Proficiency in automation tools for text messaging. - Strong understanding of social media ad analytics. - Excellent communication and organizational skills to manage lead follow-ups effectively.
Need help with MVP for mobile app and the creation of an admin portal. The mobile app will create meetings and allow users to send/accept meeting invites. This work will need to be done in React Native so I get Android and iOS. I have sketched out the look and functionality of the app in the attached pdf file. The app name, app logo and app icon will be given after project is awarded. Please plan to use shades of blue and white Please provide price and delivery time with quote. PAYMENT TERMS: Total will be paid over 3 milestones - deposit, testing and final acceptance Note: Freelancer will be asked to sign freelancer.com's standard IP Transfer Agreement as part of this project
I'm seeking a freelancer with experience in OpenAI's embedding models and GPT4, PHP, and the Github openai-php client. I have pre-existing PHP and code base, our prompts and functions we use, this all works perfectly, we're not needing you to integrate this into our existing system, simply modifying our functions to make use of the correct embeddings, preparing embeddings, and how to store them. What we want done: We are an SEO agency that has different clients, we want to be able to upload content pages and blog articles the client has on their website and then use this for context and understanding of what our clients do and the way they write. We have all this information stored for each client already, we need to format it and prepare it in the co...
