India state wise cities excelmunkák

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.

...The primary task is to ensure that new columns added to the database are correctly displayed 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 ...

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 in need of a data entry expert in Andhra or Telangana who can assist with medium-sized projects. The tasks are of 2 main types: Spreadsheet data entry and Manual Data Entry. The data is currently in the form of Data Filtering and Processing. The ideal freelancer should have: - Fast hands and typing skills - Pr...entry and Manual Data Entry. The data is currently in the form of Data Filtering and Processing. The ideal freelancer should have: - Fast hands and typing skills - Proficiency in spreadsheet data entry - Experience in manual data entry - Previous experience in data filtering and processing - Availability to handle medium-sized tasks (100-500 entries) - Should be located in Andhra or Telangana, India Please bid only if you meet the above criteria. Looking forwar...

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.

Looking at implementing a hosted/private version of for multi-PDF generative AI. I'm looking to develop a state-of-the-art AI system that can analyze multiple PDF documents at once. Key Requirements: - The system must be able to analyze multiple documents to generate coherent and informative summaries Ideal Skills and Experience: - Proven experience in developing AI systems, particularly focused on content generation - Strong understanding of natural language processing and machine learning - Background in creating systems that can handle multi-document analysis - Previous work in generating content for professional audiences would be a plus Please feel free to reach out if you believe you have the right expertise for this project.

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 own an event hall in India, particularly a marriage hall. Currently, it is the off-season, and I am seeking a digital marketing specialist who can devise and implement a robust strategy to attract clients throughout the year. Key Responsibilities: - Plan and implement a comprehensive digital marketing strategy leveraging social media and SEO. - Analyze market trends to identify opportunities and challenges to optimize our marketing efforts. - Collaborate with the design team to create engaging content. - Monitor and report on the performance of marketing campaigns. Target Audience: - Couples getting married. - Event planners. - Local community. Unique Selling Points: - Spacious indoor space. - Beautiful outdoor garden area. Ideal skills: - Proven work experience in digital ma...

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 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€

I'm in need of a seasoned freelancer to help me effectively penetrate the Indian market with my line of leather bags. I intend to employ a multi-pronged approach, utilizing both online and physical retail outlets. Key Responsibilities: - Manage the offline advertising campaigns: As part of this project, the freelancer will be tasked with creating and executing effective offline advertising strategies. - Manage client interactions: You'll need to collect orders directly from potential clients and ensure timely delivery of the goods. - Develop and manage business relationships: I need a freelancer who can help me establish a strong foothold in the Indian leather bags market. Ideal Skills: - Experience in managing offline marketing campaigns - Strong networking and interperson...

I am excited to apply for the part-time Software Developer position. As a third year computer engineering with solid background in both front-end and back-end development, I am confident in my ability to contribute effectively to your projects. Technical Ski...creating responsive and visually appealing user interfaces. Back-end Development: Proficient in Python and Node.js, with a track record of building robust APIs and microservices. Database Management: Experienced with MySQL and MongoDB, capable of designing efficient database schemas and performing queries. Full-Stack Development: Able to integrate front-end and back-end systems seamlessly, handling state management, authentication, and real-time data. UI/UX Design: Knowledgeable in using Shadcn and other tools to enhance user ...

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,...

...to a text with the owner... this position is NOT for you. It will only result in a few hours of work and poor reviews. Instead, we want a person that is patient and is willing to slowly prove that they are better, more capable and "hungrier" than the people we currently are using. We have grown from one, to many locations in two years, and we need to upgrade the team with competence. Marketing wise, we rely over 90% on inbound calls from Google. We want to increase our platforms to include Bing, Yelp Trip Advisor, and so on... We also want to work closely to get really high ranked backlinks (preferably not a birdwatcher's blog from Siberia with 2 followers). Everything we post is authentic, including pictures, AI and videos. We never want to see a cross-post on ...

fichier sur Excel reproduire le même identique sur Excel avec calcul automatique

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

...thorough testing for responsiveness, navigation, and interactive features. Identify and resolve any issues during the testing phase. Required Skills and Qualifications: Figma Design Proficiency Extensive experience with Figma for creating modern and user-friendly web designs. Strong portfolio showcasing previous Figma designs. React.js Expertise Proficient in React.js development, including hooks, state management, and component-based architecture. Experience in converting Figma designs into React.js components. Responsive Web Design Demonstrated ability to create responsive designs that work across various devices. Knowledge of CSS frameworks like Bootstrap or Tailwind CSS. UI/UX Design Strong understanding of UI/UX principles and best practices. Ability to create intuitive ...

I'm in need of a sales consultant with professional experience in the hotel industry in India. Your main focus will be on customer acquisition. Key Responsibilities: - Devise strategies to attract hotels as our customers - Understand the unique selling propositions of our products - Build rapport and long-term relationships with hotel clients - Develop a strong understanding of the hotel industry's needs and demands - Provide innovative and result-driven sales strategies Ideal Skills and Experience: - Proven track record in sales within the hotel industry, particularly with targeting hotels in India - Strong understanding of customer acquisition in the hotel business - Well-versed in the mechanics of the hotel industry on a sales level - Exceptional communicatio...

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 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.

My education consulting company has been hired to do some marketing. This government department is the Newark Youth Career One-Stop Career center, they focus on getting young adults into jobs and career advancement. they have a summer program called the "Summer Youth Employment Program (SYEP)". This is the biggest summer employment program in the state of New Jersey since Newark is the largest city in NJ. I have attached their current department logo to this.. Now they hired my organization to run their SYEP Orientation. This orientation helps jump off their summer youth employment program, we will provide the youth with development workshops. for this contest, i need: 1) 2024 SYEP logo (this will be logo used at orientation and other environments. (this also needs t...

I'm seeking dedicated researchers to collaborate on a study revolving around the neuroscience of sleep, focus and resilience. This project aims to: - Understand the impact of sleep quality on cognitive function and its measurement, - Understanding of focus and flow state from a neuroscience-based perspective, proven techniques to improve focus and remaining in flow state, measurement - A cohesive analysis of mental resilience, its impact on cognitive function, proven techniques to improve mental resilience and measurement. Your responsibilities will include: - Conducting a comprehensive literature review on the topic, - Identifying the clinically proven strategies and practices to improve sleep quality, focus and mental resilience with the associated metrics ...

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...

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 ...

...primary goal is to generate customer leads and Direct selling Agent leads in Hyderabad, Delhi, and Mumbai. Key Tasks: - Keyword research: Identify and suggest relevant keywords that are likely to drive customer leads. - Budget Allocation: Determine an effective budget per city in rupees for the Google Ads , Facebook and LinkedIn campaigns. - Targeting: Tailor the strategy specifically to these cities, ensuring maximum reach and impact. Ideal Skills and Experience: - Extensive experience in Google Ads, Facebook and LinkedIn for lead generation. - A strong understanding of the Indian market and its nuances, particularly in Hyderabad, Delhi, and Mumbai. - Proven track record of delivering successful online marketing campaigns. - Excellent communication skills and the ability to ...

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!

Looking for a skilled calligrapher and illustrator to breathe life into a personal poem. Details: ...hidden, so you don't notice at a first glance). - No people in the illustration, just plants and cats. Ideal Skills and Experience: - Strong traditional calligraphy and illustration abilities - A playful and cute art style - A knack for interpreting and visually representing poetry in a meaningful way Poem: Dear Lovers Under this peach tree's fruit heavy branches you were coaxed to meet, too wise to consume blindly, yet eternally young enough to bloom and burn and sweeten. How not to break the branch? Already this love explains your lives, future, present, past. May you be blessed with trust that growing into your truest selves is now never different from growi...

I require professional assistance to transition the property deed, currently under an individual's name, to a trust. The property in question is a residential one in renton, wahsington state. - Transfer of Deed: Need to transfer residential property deed from an individual's name to a trust. - Deed expertise: Familiarity with property law, especially related to the transfer and change of deeds is crucial. The ideal applicant for this task would have a proven track record in handling such transitions with a deep understanding of the legal implications and process involved. Legal background and previous experience in real estate law are a must.

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.

...developer to work on a Marvel Zombies Board Game. The primary goal for the simulation is to test the game balance. Key Responsibilities: - Create a simulation for the Marvel Zombies Board Game - Test the character abilities and game mechanics for game balance - This includes ensuring that no single character or game mechanic dominates the game - Provide clear and detailed feedback on the current state of the game balance Ideal Candidate: - Extensive experience as a simulation developer working on board games - Expertise in testing character abilities and game mechanics - Knowledge and understanding of the Marvel Zombies universe is a plus - Strong analytical skills and the ability to provide clear feedback on game balance The successful candidate will be able to work indepe...

I'm seeking a skilled 3D artist to create high quality, photorealistic renderings. These will be used for marketing and advertising initiatives. The specifics are as follows: - Output: High-resolution JPEG images. - Style: As realistic as possible....initiatives. The specifics are as follows: - Output: High-resolution JPEG images. - Style: As realistic as possible. I'm after a lifelike representation. - Purpose: The renderings will be used in various marketing and advertising materials. Ideal Skills: - Exceptional ability to create photorealistic 3D renderings, preferably with prior experience in advertising contexts. - Proficiency in using state-of-the-art 3D modeling and rendering software. - Excellent attention to detail. Looking forward to your creative approach...

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.

...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...

I am in need of a content creator capable of creating educational videos suitable for all age groups - children, teenagers, and adults. Your task will primarily focus on: - Making clear, informative and engaging educational videos that captivate the viewers. - Ensuring the content is suitable and understandable for all age groups....clear, informative and engaging educational videos that captivate the viewers. - Ensuring the content is suitable and understandable for all age groups. The ideal freelancer for this job would have previous experience in graphic design, video production, along with a knack for aesthetics and appealing to masses. Your portfolio showcasing previous related projects will be highly appreciated. Please state in your bid how you can best fit this project'...

I have 6 photos that require fine editing. I have a (hopefully) temporary condition called Bell’s Palsy. This unfortunately came up right before graduation and has made my graduation photos something I am not excited to share. I need editing to make my face resemble its former state, of which I will attach a picture. Specifically, I need an expert with: - Proficiency in color correction and retouching. - Skills in facial structure manipulation, particularly in modifying eye shape, mouth shape, and ensuring symmetry on both sides of the face. This is a delicate and artistic task requiring precision in the reshaping of features without compromising the natural feel. Therefore, prior experience with such projects would be ideal. There is potential for additional pictures ne...

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.

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...

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...

Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.

I need a comprehensive franchisee agreement crafted for my startup in India. The ideal document will cover the following key aspects: - Royalty Fees: The agreement should specify the royalty fees the franchisee is expected to pay. Ensure that this is reasonable and in line with industry standards. - Territory Restrictions: I want to ensure that the franchisee operates within a defined geographical area. The agreement should clearly outline these restrictions to prevent conflict with other franchisees or myself. - Training & Support: The agreement should detail the kind of support and training to be provided to the franchisee. Please ensure that this includes marketing support, product training, and operational guidance. I anticipate this agreement to last for 5 years