한국어 단어를 태국어, 네덜란드어, 유대어, 영어, 포르투갈어 등 다양한 언어로 변환할 수 있는 창의적인 마인드를 찾고 있습니다.
...테스트데이터(Treatment/Control 그룹 사전/사후 데이터 셋(csv 파일)을 종류별로 인식하여 읽어들이고, 사전데스트/사후데스트로 구분할 수 있게 변수명을 바꾸고 (예: 수집된 데이터 문항 Q1, Q2, Q3...로 되어 있는데요, 사전테스트 데이터면 Q1_pre, Q2_pre, Q3_pre...로, 사후데이터면 Q1_post, Q2_post, Q3_post...로 변환), 해당 데이터별로 제가 이미 만들어 놓은 스크립트를 돌려 (Item Analysis, ANCOVA 등의) 분석을 자동 시행하고 결과를 출력하도록 하는 간단한 패키지입니다. 데이터셋을 종류별 구분해서 읽어들이는 것이 관건인데, 제가 이 부분에서 애를 먹고 있는 중입니다. 사용자로부터 (treatment pre, treatment post, control pre, control post) 인풋을 받아 If, For 등의 Function을 쓰면 될 듯 한데 (저의 짧은 소견입니다^^;), 제가 아직 R 함수에 익숙치 않아 주로 이 부분을 R 전문가의 도움을 받고자 합니다. 구체적으로 무엇을 구현하려고 하는지는 지금까지 제가 만들어 놓은 스크립트와 관련 문건들을 파일로 참고하시면 되실 듯 합니다. 다시 한번, 도움주실 내용의 핵심은 4종류의 데이터셋을 구분하여 읽어들이는 스크립트/함수가 되겠고요, 두번 째로 중요한 것은 스크립트가 완성되면 분석별로 스크립트를 묶어 함수화하는 것이 되겠습니다. 참고로, Item Analysis는 사용자가 데이터셋 정보를 제공하면 해당 데이터셋별로 분석결과를 제공하는 것이고...
자동화 라인에서 설비간 Interface(MES)를 위해 Http Client 구축합니다. 통신 데이터는 JSON format의 RESTful 설계가 되어야 하며 가능한 C++로 구현하기 원합니다. 응용 프로그램에서 사용할 수 있도록 라이브러리화 해서 지원할 수 있으면 좋겠습니다. 작업량이 절대 많지 않고 복잡하지 않으나 처음 접하는 건이라 개념적으로 어려워 어려움을 겪고 있습니다.
영어 자막이 있는 유튜브 영상을 레딧에 게시물로 포스팅하고 싶습니다 I want to post a YouTube video with English subtitles to Reddit as a post
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
...so when when paying total cost will be on stripe showing the products. - Registration Redirection Fix: The second task is addressing a critical issue with the registration process. Currently, upon successful registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent
...and identify grant opportunities aligned with our business plan and funding needs * Write clear, persuasive grant proposals and applications * Collaborate with our team to gather necessary information and data to support grant submissions * Manage grant submission process, including meeting all required deadlines * Communicate progress updates to management and incorporate feedback * Assist with post-award reporting and compliance as needed Requirements: * Proven track record of securing grants, preferably for startups or businesses in the jewelry or creative industries * Exceptional writing skills in English with impeccable grammar and attention to detail * Strong research skills and ability to quickly understand our business and funding needs * Excellent project management ski...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I'm in need of someone skilled in PDF file structures who can determine if a particular PDF has undergone editing, and to identify the edited segments. To help successfully complete this task, you should: - Have in-depth experience navigating the structure of PDF files. - Capably discern changes or alterations made to a PDF. - Provide a report indicating any modifications, where they occurred. When applying, please exclusively focus on detailing your experience with manipulating PDF file structures. Past projects involving this will be highly advantageous. Ideally, you will have worked on similar projects, where the goal was to detect alterations in the document. Looking forward to a seamless collaboration.
lo que quiero hacer es lo siguiente: este es el panel ves donde sale créate radio pues desde hay se añade manual mente un post pero tiene que ir a de uno en uno y yo lo que quiero es crear otra opción que ponga importar y pueda subir una archivo m3u y añadir todos de una vez este es el tipo de archivo o este
...offered, request quotes, and schedule appointments. The website will have about 70 pages. Key Features and Functionalities: - Service Listing and Description: The website will have dedicated sections for each service category (Plumbing, Drains, Heating, Cooling, Pool Heaters, and Other Services), with detailed descriptions and breakdowns of specific services offered under each category. - Service Area Coverage: Clearly communicate the geographic areas served, allowing customers to check if their location falls within the service area. - Online Appointment Scheduling: Implement an intuitive appointment scheduling system that enables customers to book service appointments directly from the website, specifying their preferred date, time, and service required. - Quote Requ...
I need help with uploading an ODT file to IngramSpark. Key tasks include: - Aiding in the conversion of the ODT file to the format required by IngramSpark, if needed. - Ensuring the final file is correctly formatted. I don't need assistance with understanding IngramSpark's file format requirements, but any additional insights would be appreciated. Ideal freelancer should: - Be experienced with IngramSpark's file formats and specifications. - Possess skills in file conversion, particularly from ODT to other formats. - Be meticulous and detail-oriented to ensure the final file is correctly aligned with IngramSpark's requirements. Please note that I will be uploading the file myself, but require assistanc...
I need to connect ElevenLabs' text-to-speech API to another tool through Zapier. So far, Elevenlabs' response has been a binary. Instead, I need the audio URL so that the second app I want to connect with Elevenlabs can use the URL in an automation. To participate in this project, you'll need to create your own free accounts for both services. The participant will need to deliver a complete solution that, if possible, doesn't involve hosting the content in a third-party service. To participate, please start your message with "Bonjour". This way, I'll know you've read this instructions. If you need clarification, pleaset let me know.
I'm seeking expertise to develop an AI solution addressing specific communication challenges in my operations. This advanced technology will aid in requesting more specific information for document retrieval, task completion, and progress updates that are currently barriers. Key Features and Responsibilities: - Construct an AI system that can precisely request added details - The AI tool should nurutre informations mainly for document retrieval, tasks execution, and progress report. - Should work effectively with email platforms as the primary communication tool. Ideal Experience: - Proven experience in AI and machine learning technology - Familiarity with corporate communication systems - Experience in integrating AI with Email services. This project aims at enhancing effic...
...the failed upgrade, the database is out of sync. The site needs urgent attention to get it back on track. Your primary role on this project will be: - Debug and fix the bad upgrade: This includes addressing the broken layout, error messages, and the out-of-sync database issue. - Server Configuration & Security Audit: Given that I've made changes to the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optimization: Your focus here should be to enhance user experience. This could involve improving page loading speed, streamlining the user journey, or other UX-related optimizations. - Create and install a new v...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
DESIGN ME AN A5 FLYER - USE TEMPLATE ATTACHED AND OUR LOGO COLOUR SCHEME- TEAL COLOUR GRAPHICS- PHARMACY BASED FLYER DETAILS BELOW:- Penhill Pharmacy 257A PENHILL DRIVE, SWINDON, SN2 5HN Opening hours: Monday-Friday ( 08:30 - 17:30 ) T: 01793 723 534 E: info AT W: ...TEMPLATE ATTACHED AND OUR LOGO COLOUR SCHEME- TEAL COLOUR GRAPHICS- PHARMACY BASED FLYER DETAILS BELOW:- Penhill Pharmacy 257A PENHILL DRIVE, SWINDON, SN2 5HN Opening hours: Monday-Friday ( 08:30 - 17:30 ) T: 01793 723 534 E: info AT W: How to order your repeat prescription at Penhill Pharmacy 1. Hand in your repeat slip at the pharmacy 2. Request medication via the NHS APP 3. Email us at info AT 4. Call us on 01793 723 534
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I'm looking to hire a professional who can craft engaging promotional posts for my Instagram account. The ultimate goal here is to increase our brand awareness, thus the quality of content in terms of engagement and strategy should align with this. Key Requirements: - Proficiency in creating high-quality Instagram posts - Strong knowledge of Instagram algorithms - Prior experience in brand promotion through social media is essential - Creative with an understanding of what works and what doesn't on Instagram Ideally, the freelancer should be able to demonstrate their expertise with a portfolio of successful promotional content crafted for Instagram. Your creativity and strategic approach to promoting brand awareness will be critical to this project.
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I am in urgent need of a resourceful and detail-oriented expert to assist me with a specific image file editing task. This project involves fine-tuning the content of the image, requiring text editing and relocation of already existing graphic elements within the image. The ideal candidate: - Should be skilled in image editing, detail-oriented, and should have a strong grasp of image editing tools. - Should have demonstrated experience with editing text within images and rearranging graphic elements. - Needs to be careful not to distort the image or misalign the graphic elements during the editing process. Please bid only if you have the required experience and skills and can deliver high-quality results in a timely manner.
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
...installation. I am looking for a person/team with experience in installing the following software, there is a manual, please read the instructions. I am sending an installation request. I need to start the installation process as soon as possible. Downloading the software: Tutorial A comprehensive tutorial presented at NeurIPS 2023 - Seamless EXPO, the place to learn how to use the entire set of Seamless models. Feel free to play around with the notepad. Tutorial link: Request to install the programme from GitHUB: Seamless is a family of artificial intelligence models that enable more natural and authentic communication across languages. SeamlessM4T
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
...potential candidates using various online platforms and databases - Conducting interviews and evaluating candidate's skills, experience, and fit - Matching candidates to temporary mid-level healthcare roles in a timely manner - Acting as a liaison between our company and the candidates, providing full support throughout the recruitment process -submitting candidates on platform -pick up any new request from recruitment platform and put it on indeed for candidates, then submit them to clients for review Ideal Skills and Experience: - Proven experience as a recruitment consultant, particularly in healthcare - Strong knowledge and network within the healthcare industry - Ability to source and assess mid-level candidates effectively - Excellent communication and negotiation s...
...for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected status of groups that are joined or already joined. For unjoined groups that we have searched for, you can auto join. - Can Auto Post to Facebook Group Each feature has Add, Filter, Combobox options, check, delete in the required places Create ...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I am searching for someone who can just show me how can I set the HTTP request from inside ManyChat flow builder, so I became able to make POST/GET from ManyChat to Dialogflow. The image attached to this offer shows exactly the module I need to configure.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
Create an app and software that allows users to view their recorded game play footage. Hardware at sport facilities will record game play, controllers will be programmed to post recorded footage to servers. app needs to be developed so that this game play can be accessible for users to view/download etc. please review information before bidding, as well as budget. specified budget is maximum if your bid is higher please dont bid
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure effic...
...our requests are processed successfully at the other end without being flagged as PROXY IP users. Currently, we utilize web proxies, primarily residential proxies, for various purposes. However, we encounter frequent failures when the receiving system identifies our requests as originating from PROXY IPs. Challenges: 1. IP Score Impact: We’ve observed that IP scores play a significant role in request success. While requests from CLEAN or LOW Spam Score IP addresses often pass, those from HIGH SPAM score IPs face rejection. 2. Recognition as PROXY IP: Our solution must not only allow requests to pass but also prevent them from being recognized as PROXY IPs by the recipient system. Project Objectives: 1. Effective IP Masking: Develop a solution that effectively conceals our o...
I'm in need of a talented sales and lead generation expert with a multi-faceted approach to draw in new business from a B2B and B2C perspective. Key Responsibilities: * Implement effective and various lead generation strategies, focusing on email marketing, social media marketing, and search engine optimization. * Take on specific sales tasks such as cold calling and attracting Web Design cl...are our primary targets. Your strategies and activities should align with this target audience. I look forward to your innovative strategies and methods to increase our lead generation. NOTE- THIS IS A COMMISSION BASED WORK ONLY. FOR EACH CLIENT YOU BRING TO US YOU WILL GET 20% COMMISSION. NO HOURLY AND NO FIXED PAY UPFRONT. ONLY COMMISSION. PEOPLE WHO ARE TOO MUCH DEMANDING STAY AWAY FROM TH...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be ...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of those samples will result in a DNA ma...
I'm reaching out through this email to make another request. In this case, we have a very important client here in Spain, operating in the online product sales sector, very similar to TEMU. They are interested in having us develop a community site, very much like the following example: EXAMPLE They want their community, which currently exists as a WhatsApp group, to have access to profiles where they can comment on products, engage in forums, and build communities. The functionality required is as follows: An internal client area providing information about the user's account (already created on () but requiring additional information specific to this platform). Image galleries and sliders. Social functions such as social media sharing buttons, activity
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
