How to change column headings in pivot table excel 2013 jobs

I need a skilled and experienced mobile app designer who can help me quickly change the background of my app. The specific details on the current background were not provided, so you might need to be flexible and creative in this task. Key Requirements: - Proficiency in mobile app design, particularly in changing backgrounds - Ability to work quickly and under tight deadlines The task is urgent and must be completed ASAP. I am looking forward to working with a professional who can deliver high-quality results under pressure.

I'm in need a freelancer to assist in the comprehensive design and development of a commercial electric car. This car will be a full hybrid, meaning it will be capable of self-charging, and will have a particular focus on energy efficiency. Key Responsibilities: - Full Exterior and Interior Design: This car needs to be visually appealing, and project a modern, sleek, and commercial image. - Mechanical and Electrical System Design: We need a team with a strong focus on engineering, able to create systems that are energy efficient and innovative. - Innovations: This is an important aspect of the project. We're looking for a team that can bring fresh ideas to the table, with a particular interest in self-driving capability, v...

I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Da...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as ...

I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable table...

Project Description: We are seeking a talented designer to create a visually stunning, engaging, and informative page that highlights our distinctive vanilla cultivation and preparation process. The page should take viewers on an immersive journey through our vanilla's lifecycle, from the lush fields of Maroantsetra, Madagascar to the final crafting of our premium product. The designer should use the attached infographic, process flow diagram, and vanilla cut styling guide as visual references to creat our own infographic ou design steps shaping the page's content and design. These resources provide comprehensive details on our process, including key steps, techniques, timing, and quality control measures. Project Goal: The ultimate goal is to creat...

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions wou...

...categories, but the main aim is to increase brand awareness, drive sales and conversions, and educate and engage my audience. The target audience for the content is primarily parents. Key Responsibilities: - Create engaging social media content and marketing videos - Ensure the content aligns with the brand's goals of awareness, sales, and education - Tailor the content to appeal to parents specifically - Edit and enhance existing video materials as necessary Ideal Skills and Experience: - Demonstrable experience in creating diverse and engaging social media content and marketing videos - Proficiency in video editing software - Understanding of effective content strategy and its applications across different platforms - Knowledge of the parent a...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs comple...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understand...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform...

Task 1: Write dynamic programming and recursive programs for a given problem obtained from 4 practical task selection test. • Implement a recursive program to solve the given problem. • Analyze time complexity of the recursive program (brute force) and dynamic programming approach using Big O and Omega notations. • Implement a dynamic programming approach by defining a table to store previously calculated values and using them to compute the next value in the sequence. Write recursive solution. • Test both programs for different input sizes and compare their performance. Task 2: Parallelize the algorithms for the second and third recursive equations obtained from the 1 practical selection test, and also parallelize second and third...

...developer to create a robust mobile application that offers real-time translation capabilities and includes an 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 Reac...

Seeking a skilled web developer to improve and update our existing Django-based website. The project involves: Menu Bar: Update and ensure consistency with multilingual support (Swedish, Danish, English). Contact Form: Implement validation, translations, CAPTCHA, and backend management. Multilanguage Support: Set up inputs for Swedish, Danish, and English without auto-translation. Articles and Blogs: Improve layout, image handling, and formatting consistency. Search Function: Enhance search to include titles and body text. Main Picture: Add functionality to change the main picture with size guidelines. Home and About Pages: Ensure consistent formatting and editable content. DNS and Email Setup: Correct domain pointers and enable email functionality on server. P...

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 am in need of a skilled web developer to create a web application to display my events and deadlines. I'm looking for a monthly view for a personal user experience. The project will require a developer who's experienced in creating user-friendly, visually appealing web applications. Key requirements: - A monthly calendar view, that is easily navigable and intuitive for personal use - Ability to clearly display a range of different events and deadlines - A clean and modern design that is mobile responsive, as most of my users will be accessing the app on their phones - Some experience with event scheduling software would be a plus I appreciate any insights or ideas that you can bring to the table. I'm looking forward ...

I'm in search of a skilled Python PHP developer with experience in backend development. If you have a good grasp of Python and backend systems, this project is for you. Essential skills and experience: - Proficiency in Python PHP - Proficiency in Firebase MySQL - Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communication skills - Experience in developing and maintaining a reliable backend system - A keen eye for detail and the ability to troubleshoot and solve problems quickly If you think you're a good fit for this project, please get in touch. I'm excited to see what you can bring to the table.

I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. 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 procedur...

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!

...for my brand. There are a few things I need to be considered in this project. - Logo Design: I'm looking for a logo that truly represents the essence of my brand. The design should be creative and memorable, while also being versatile enough to be used across various platforms. - Branding Elements: I'm in need of a complete branding design, which includes a color scheme and the selection of fonts. The branding elements should complement the logo and create a cohesive and consistent visual identity for my brand. I am open to suggestions regarding the logo design, and would appreciate a designer who can bring fresh and innovative ideas to the table. Ideal candidates for this project should have a strong background in gra...

I'm in need of a realistic apparel print for tee shirts, featuring a unique scene. The artwork should be in portrait style and include a group of animals - specifically a shark, tiger, golden bear, black knight and rainbow umbrella. This group will be depicted at a table, enjoying cigars and sipping glasses of scotch. The background for this scene should resemble a men's club, giving the impression of a sophisticated and exclusive setting. Key requirements: - Realistic artwork style - Unique and engaging animal choices - Men's club background

...are a curly hair ecommerce in Italy and we are looking for a AR beauty experience professional to create this type of videos We need Someone to add in our team who brings unique set of skills and idea to the table. We only have products pictures so the animate of the product will be recreated from a 'fake 3d' of the .png image You must find the video to use free from copyright so

I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web d...

I'm in need of a skilled photographer with their own studio or location to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for ach...

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

...who specializes in creating realistic illustrations. Key Requirements: - **Realistic Style:** The illustrations should be realistic in nature. - **Squirrel Character:** I have a specific squirrel character in mind. It will have to be designed with the following attributes: - **Wearing a Hat:** The squirrel should be depicted with a hat. - **Smoking a Pipe:** The squirrel should be smoking a pipe. - **Holding Cards:** The squirrel should be holding some cards. - **Other Ideas:** I'm also open to hearing any other creative ideas. Additional information: Need up to 50 different illustrated image of the character, and pls don’t bid for the project if its not what you can do Ideal Skills and Experience: - Strong portfolio of real...

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

I am looking for someone experienced in building tool websites with an emphasis on monitoring changes on various websites. The primary function is to detect and report on content changes, with users receiving notification of these adjustments via email & sms alerts. Ideal Requirements: - Proficiency in building tool websites for monitoring purposes. - Knowledge in setting up a system to detect website content changes. - Experience in integrating email alert notifications for users. - Loading Capacity 500+ Websites Searching per Hour - Foresight in creating an interface user-friendly even for non-technical users. This project will require strong analytical skills and a sharp eye for detail. I'm excited to work with someo...

Site Location: Parel East, Mumbai Date:19/5/24 I am in need of a videographer who can film the process of installing a surface protection film on marble dining table. Specifically, the project entails: - Filming the installation of a surface protection film on medium-sized marble surfaces such as a dining table. - Capturing promotional footage to demonstrate the efficiency and effectiveness of the installation. -Make a reel using the clips shot. The ideal candidate should have: - Experience filming in varied working environments, especially in work sites. - Attention to detail to accurately represent the installation procedure and product use in the video.

I am looking for someone experienced in building tool websites with an emphasis on monitoring changes on various websites. The primary function is to detect and report on content changes, with users receiving notification of these adjustments via email & sms alerts. Ideal Requirements: - Proficiency in building tool websites for monitoring purposes. - Knowledge in setting up a system to detect website content changes. - Experience in integrating email alert notifications for users. - Loading Capacity 500+ Websites Searching per Hour - Foresight in creating an interface user-friendly even for non-technical users. This project will require strong analytical skills and a sharp eye for detail. I'm excited to work with someo...

I have a vision for a logo that's modern and minimalistic. I've got some rough ideas in mind but I'm open to suggestions and want to see the creativity freelancers can bring to the table. Key Requirements: - Modern and Minimalist: The logo should reflect a contemporary and clean design aesthetic. - Company Name: The primary element to be included in the logo is the company name. Ideal Skills and Experience: - Proven experience in creating modern, minimalist logo designs. - Ability to take rough ideas and turn them into polished, professional designs. - Strong creativity and an eye for detail. Delivery Time: I'm looking for a quick turnaround on this project without compromising on quality. Please sh...

I'm looking for a talented WordPress developer to change our current website theme to Xstore and translate the site from English to Arabic using WPML. Our site has all the required pages and posts, and we want them to be aligned with the new theme's demo. Please note, we already have WPML installed and licensed, and the website has been fully translated. Website to Check : Key tasks include: - Implementing the Xstore theme (or Woodmart if more suitable) - Aligning with the theme demo - Changing layout, colors, and fonts as needed - Translating the site to Arabic using WPML and ensuring all content is correctly displayed The project does not require any additional custom functionalities beyond the theme, its demo, and the Arabic t...

...(website) and Mobile app to accept quotation from customers 2. Customer had to register and must submit following details : a) Mobile Number (Must verify through OTP) b) Email id (Must verify through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity...

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 skilled photographer to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for achieving appealing product shots. ...

...developer to create a social networking application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is a unique project and I am looking for a freelancer who can b...

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

...calculator's functionality. Interface appearance use graphic buttons (this may be the simplest graphic with a color change), the result of the operation can be presented in the form of binary, octal hexadecimal (additional buttons), enter the history button: opening a new window with information about the actions taken since the application was started, showing the actions in the following lines of the list. Project 2. Create a Music MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Project 3. Create a Mobile Application for a Cafe Restaurant to receive orders from its Customers. The Appl...

I need a sea...seasoned professional who can provide me with comprehensive support on major projects and tasks completion. The role involves assisting in project planning, task management, and troubleshooting, along with other related activities that could improve my efficiency and productivity. The ideal candidate should be proficient on following:- Task would related to this :- Load testing architecture Created infra in azure (VM's, synapse load balancer, DNS mapping) Internal VM configuration Nginx conf files change (private IP, domain) Azure VM network security group rules DNS mapping in Cloudflare Majorly daily daily work would be on :- Jenkins build, And Deploy in Azure (VMs, Tomcat) and Azure Devops Interaction with Cl...

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

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.

...skilled freelancer to help me transfer an application from my old Windows server to a new one. The server is currently running on Windows OS and the application is built with Visual FoxPro 9 and ASP.NET Key Requirements: - Proficiency in Windows server management and application migration. - Experience with Visual FoxPro 9 and knowledge of its compatibility requirements. The new server must have the following installed: - ASP.NET Framework 3.0 or higher - Visual FoxPro 9 - Office 2019 Please make sure to include in your proposal any related experience and specific skills that make you a suitable candidate for this project. Project Description I'm currently in a bit of a tight spot. A Windows Server 2016 web application () was recentl...

...have a worldpress site, I want to fully resign the landing page with fully custom design and also the menus should be redesigned and structured based on the requiremnt. I have a detailed document, The creative design skill is must to develop eye catching page, sense of design is must to choose font, color and other style elements. So I need the design and develop both skills. Please start your proposal with world "confident" so that I filter out random bids. I will provide text content for image, gif you have to use copyright free assets from internet. Task - Change the menu options and their styling to fit with the landing page - Header and Footer - Landing Page --- Vertical slider of 4 pages, paging enabled. When scroll up and down...

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'm seeking a digital marketing specialist to assist with managing my social media accounts and creating engaging content for my business. Key Responsibilities: - Social Media Management: The core of this position will be managing my Facebook, Instagram, and Google accounts. This includes creating and scheduling posts, monitoring engagement, and responding to comments/messages. - Content Creation: I need someone who can create compelling content for my digital marketing campaigns. This will involve creating posts across various platforms to engage with our audience and attract new customers. The Ideal Candidate: - Proficiency in managing various social media platforms, especially Facebook, Instagram, and Google. - Strong copywriting and content creation ...

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'm in need of a proficient PHP developer to take on a range of responsibilities for my project. You'll be handling both the front and back-end development, as well as maintaining the website. I'm looking for someone who has a strong background in PHP, not just with creating and managing dynamic and interactive web pages, but also maintaining them for optimised performance. Key Responsibilities: - Handling front-end and back-end development - Carrying out website maintenance You must provide examples of your past work in your application. We appreciate attention to detail and a deep understanding of PHP. Since I will provide all the content needed for the website, you can focus solely on the programming side of the task. Your expertise ...

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that i...