Joomla excel frame jobs

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm seeking a skilled programmer, proficient in Python, who can develop a trading algorithm according to my exact speci...specifications. The algorithm itself must integrate with the TD Ameritrade platform and take into consideration an array of varying factors such as: - Historical stock prices - Market trends - Earnings reports - The presence of candles twice as large as the previous candle sma cro - Ignoring red and green bars - 8 sma crossing 21 at any time frame - 20 sma crossing 200 at any time frame - 50 sma crossing 200 sma - Double tail bars at any time frame A solid understanding of financial markets as well as a proficiency in developing trading algorithms is necessary. This task is intricate and requires meticulous attention to detail, only experie...

...accessible format - Ensuring accurate extraction of information - Handling images or diagrams within the PDF files The extracted information will be used for further analysis and will significantly contribute to a larger project. Accuracy, speed, and precision are crucial for this task. So, I'm looking for a detail-oriented individual who can deliver high-quality work within the specified time frame. Skills required: - Proficiency in data entry - Experience with PDF files - Attention to detail - Ability to work independently - Good organizational skills If you have experience with similar projects and feel confident in your data extraction skills, I'd love to hear from you. Please include any relevant experience or previous projects that demonstrate your ability to ...

...in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and logical thinking - Ability to work independently and deliver high-quality results within the ...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm seeking a skilled political cartoonist to create a 3 to 4 frame, colored cartoon. This project focuses on liberal viewpoints regarding national political figures. I need someone who can humorously yet effectively convey political messages through their illustrations. Ideal skills and experience include: - Extensive background in cartoon drawing - Understanding of national politics and liberal perspectives - Ability to translate complex issues into easy-to-understand, engaging, and humorous visuals - Strong coloring skills to create vivid and appealing illustrations. Please provide samples of your previous work, especially if they involve political cartoons. This will greatly help me in making my decision. Thank you!

I have a raw data ...array. The primary goal is to process this data in real-time for monitoring purposes. It is crucial that the data is not copied between CPU and GPU memory. Key Requirements: - Acquire data stream from /dev/video0 on Nvidia Jetson Orin and store as an array - Use Python 3.9+ for the codebase - Process the data array for real-time monitoring - Do not copy data between CPU and GPU memory, as one frame is 17MB in size Ideal freelancer for this project should have: - Extensive experience with Python, particularly in real-time data processing - Prior experience with Nvidia Jetson devices and GPU computing - Proficiency in CUDA and CuPy for GPU memory management - Strong understanding of Grayscale data processing - Good communication skills for clear updates and coll...

I'm in need of an experienced interior designer who can assist me with designing 2bhk in my residential space. The style I'm aiming for is a traditional look. Key Responsibilities: - Design 2bhk in my residential space - Implement a traditional design style Ideal Skills and Experience: - Proven experience in interior design for residential spaces - A strong portfolio demonstrating tradition...experience in interior design for residential spaces - A strong portfolio demonstrating traditional design - Proficiency in creating visually appealing and functional spaces I'm looking for someone who can bring creativity and a traditional aesthetic to my home. The right candidate will have an eye for detail, excellent communication skills, and the ability to work within a set budg...

I'm in need of an experienced graphic designer to create a modern icon for my mobile app called Zemcos. Focus on icon for zemcos. It's not like a logo. It's a icon you can make as log...and innovation. - Color Scheme: You have the freedom to select the color scheme, but it should be visually appealing and align with the modern and tech-forward theme of the app. Ideal Skills and Experience: - Proven experience in creating modern and professional logos. - Strong understanding of color theory and design principles. - Ability to deliver high-quality work within a reasonable time frame. Please provide a portfolio of similar work you have done in the past, so I can get a sense of your style and expertise. Looking forward to working with a talented designer to bring my v...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm in search of an experienced developer to bring my e-commerce site- I am going to sell data list Competitor company list: https://www.data-broker.co.uk...be mobile responsive to cater to the growing number of mobile shoppers. - you should work from scratch not ready made template I would prefer a developer who has: - A strong portfolio showcasing previous e-commerce site designs. - Experience in setting up and customizing an e-commerce site. - Knowledge of SEO and mobile responsiveness best practices. Looking forward to your proposals. time frame - 2 weeks budget - $200

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm looking for a talented video editor capable of making a less than 5-minute video out of multiple videos. Key Tasks: - Remove certain unnecessary parts from my raw footage - Add effective transitions to enhance the viewing experience and emotional tone as well as music The video is supposed to be about our last year in high school - it needs an emotional ambiance with fitting mus...5-minute video out of multiple videos. Key Tasks: - Remove certain unnecessary parts from my raw footage - Add effective transitions to enhance the viewing experience and emotional tone as well as music The video is supposed to be about our last year in high school - it needs an emotional ambiance with fitting music Ideal freelancer would have: - Ability to work efficiently within a short ti...

...need to flex your creative muscles to ensure our video campaign stands out. Frame 1: Text: Summer School Adventures Begin! Registration Open Now! Footage: Energetic montage of children laughing, playing, and learning in various settings (classroom, outdoors, art projects). Frame 2: Text: Engaging Programs for Ages 3-17 Footage: Close-up shots of children of different ages actively participating in different types of activities (reading, science experiments, playing games, etc.). Frame 3: Text: July 7th - September 4th | New Sessions Every Two Weeks! Footage: A dynamic animation of a calendar flipping through the months, highlighting the summer dates. You could also show snippets of different themed sessions. Frame 4: Text: Flexible Schedule: Sunday - We...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

Hello, I need complet the Amazon categories catalogue excel in french

...Enhancement. I'm looking for an expert who can bolster the overall look and feel of my landing page’s navigation. The ideal candidate for this project is one who has profound experience in web design, particularly in the e-commerce sector. A portfolio showcasing past work in similar projects would be beneficial. The person should also have exceptional skills in graphic design, UX/UI design, and Joomla or WordPress. this is my website : and i want it to look like this :

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I'm searching for a creative and experienced 2D animator(opentoonz / other software who specializes in creating short animation film. The production should last between 1-3 minutes. This project does not require the integration of voice-overs, sound effects, or background music. The ideal freelancer for this task should have: - Demonstrated experience in 2D animation. - A strong portfolio featuring previously created cartoon-style animations. - The ability to meet deadlines. - Strong communication skills. Your bid should include a plan regarding how you would approach the project, examples of your previous work, and an estimated timeline for completion. I look forward to seeing what you've got in store!

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm in urgent need of an experienced Laravel developer for a VPS-hosted application. The application is facing some critical issues which need immediate attention. ...Responsibilities: - Quickly identify and resolve user interface issues. - Address database errors and ensure data integrity. - Implement necessary optimizations to ensure smooth running of the system. This project requires immediate action as the application is currently not functioning optimally. Hence, the ideal candidate should be able to work under pressure and deliver results within a limited time frame. Skills and Experience Required: - Proven experience with Laravel, particularly in debugging and fixing issues. - Strong knowledge of VPS hosting environments. - Ability to work under pressure and meet t...

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

...looking at an iPhone 14 Pro might think, “Wow! This is an expensive phone. Yeah, this guy has money. Let me get a bribe out of him.” Whereas, if he were to look at a few ESP32 development boards which cost less than $5 (Five Dollars) each? Meh. I doubt he’s even going to think about asking for a bribe for such items. I suppose corrupt local customs officials are greedy, not foolish.z ✻ TIME FRAME ✻ I am not in a rush. However, this project must be completed within the next 60 (sixty) days. ✻ BEING WRONG ✻ Stand in front of a mirror and practice saying, “I was wrong.” Learn to smile when you say this. I am not joking. I’ve worked with many engineers; only two of them were excellent engineers. Both of them said, “I was wrong&rdquo...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

A one time project to design a three part billet aluminium swingarm for a 2007 Triumph Bonneville. Ideally designer will have some experience in designing parts in the automotive field or an area when stress/strength etc are a safety factor. This will be the largest part I will have had designed and made for my motorbike. Attached are photos of some of the previous smaller parts we made, along with a bunch of photos of inspirational swingarm designs. Sadly my previous designer is away due illness and I would like to progress with the project ASAP. So far the current swingarm for the bike is welded and steel and has been 3D scanned and important planes and parts put into a 3D model. Ideally designer would have experience in designing parts to be capable for CNC, as that's how it w...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

I have a Node.js website where a critical bug has surfaced. Every time I log in with one ID, the session automatically switches to another ID after a page refresh. This is causing severe disruptions and needs urgent attention within 24 hours. Key Aspects: - Immediate resolution of the login bug that switches sessions. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting ...one ID, the session automatically switches to another ID after a page refresh. This is causing severe disruptions and needs urgent attention within 24 hours. Key Aspects: - Immediate resolution of the login bug that switches sessions. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting login related issues. - Quick turnaround to address the issues within the specified time ...

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

I need assistance with a data entry project where handwritten documents need to be accurately typed into Microsoft Word. Key Requirements: - Data entry: The task primarily involves typing data from handwritten documents into Microsoft Word. Accuracy is crucial. - Time efficiency: The project has a deadline, so the freelancer should be able to complete the t...Microsoft Word. - Excellent typing speed and accuracy. - Previous experience in data entry, especially with handwritten documents, would be a plus. - Attention to detail and ability to maintain formatting consistency. This project is perfect for someone who is meticulous and has a good eye for detail. If you have these skills and are capable of delivering high-quality work within a given time frame, I look forward to hearing...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I'm seeking a network engineer with expertise in using Cisco Packet Tracer for a small-scale ISP network project. - Tasks: The main responsibilities of the project will involve configuring and setting up the entire network structure including routers, switches, and other necessary network components. Additionally, I will require assistance in ensuring the network is secure and troubleshootin...using Cisco Packet Tracer. - Experience: The ideal candidate for this project should possess: - Proficiency in using Cisco Packet Tracer for network design and simulation. - Strong understanding of network configuration and security. - Proven experience in troubleshooting network issues. I'm looking for a reliable and skilled professional who can deliver quality work within the stipulate...