Format salary sheet仕事

...looking for a Japanese graphic designer who can help us create some graphic design for our Japanese game review site! it would be ideal if you are experienced self-motivated can create Japanese anime-themed comical designs would like to be a freelancer 【Details】 Job title: Japanese graphic designer (Freelancer) Certification: experienced. Place of work: Unspecified work hours: Unspecified Salary: Negotiable but it depends on the experience level 【Work Contents】 We currently have an open position for a Japanese graphic designer who can help us out create web designs for our Japanese game review site. what you would be doing is propose web designs when we are in need. Regarding the style of design, We would like some Japanese-themed comical designs. Although there is no rest...

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.

インターネット関連技術屋のための名刺のデザインをお願いします。 シンプルで思慮に富んだデザイン希望です。 成果物はイラストレータ形式のファイルでお願いします。 A business card design for IT company. Simple but thoughtful design is preferred. I need your help by the illustrator file format. thanks.

I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the u...captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to save the data in google ...

development of a new layout, salary guide.

...requirements： computer equipment and Internet in Portuguese (and preferably in English) and cheerful the face live Job salary: Fixed part: 2 hours of live broadcast every day, 10 US dollars per hour. If you are willing to broadcast for a third hour, the hourly wage for the third hour is $5. Commission part: During the live broadcast, you will get a commission by downloading games or paying for games in the live broadcast room. Due to the diversity of live broadcast content, we will determine the live broadcast content and live broadcast commission for this week before each live broadcast.Monthly. The salary of the current month will be submitted to the Kwai platform for review on the 10th of the next month. The review will take 7-10 working days. Wages will

I have a few guitar tabs that I'd like converted into the Rocksmith format. - The tabs can be a mix of genres. - I need these tabs to be converted to Rocksmith format, so that they can be easily playable within the Rocksmith software. - The guitar tabs may not be in standard tuning, so a knowledge of different tunings and how to adapt them for Rocksmith is preferred. Ideal skills and experience for this project include: - Proficiency in guitar. - Experience with Rocksmith and how to convert tabs to its format. - Knowledge of different guitar tunings and how they can be adapted for Rocksmith.

I'm looking for a Python develope...efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and updates to the project upon succes...

Hello, I'm looking for a professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline for delivery if interested. Thank you.

I'm in need of a freelancer who can create a realistic profile picture for my gaming platform account. The profile picture should be: - Realistic: I'm looking for a design that captures a lifelike quality. - Original: I don't want the design to be based on a photo I provide. I'm looking for a unique and creative concept. - Gaming Platform Ready:...looking for a unique and creative concept. - Gaming Platform Ready: The design should be tailored for use on a gaming platform. Ideal skills and experience for this job include: - Strong illustration skills with examples of realistic designs in your portfolio. - Ability to come up with original and creative concepts. - Understanding of design requirements for a gaming platform, such as size and format. Looking for...

I'm currently in need of an experienced image editor proficient in working specifically with JPEG files. The main tasks include: - Image cropping - Image resizing - Adding various image filters While I have not elucidated the purpose of the image editing, I anticipate the ...main tasks include: - Image cropping - Image resizing - Adding various image filters While I have not elucidated the purpose of the image editing, I anticipate the need for versatility in tackling a range of potential projects and tasks. Hence, adaptability and broad skills are strongly preferred. Ideal experience and skills: • Extensive image editing background • Familiarity with JPEG file format • Diverse portfolio demonstrating adaptability • Track record of meeting deadlines and...

...that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list of patients' names will be created by the dentist, during the recording session. - A webhook will be required to trigger the process each time a new audio f...

I have a sizable amount of numeric data that needs to be inputted from handwritten documents. This is a meticulous task that requires attention to detail as the data must be entered accurately. Key tasks include: - Transcribing data from handwritten documents into a digital format. - Ensuring the data is accurate during the entry process. Skills/Experience required: - Proficient in data entry, especially numeric data. - High level of accuracy and attention to detail. - Previous experience with handwritten document data entry is preferred. - Understanding and application of data validation techniques.

I'm in need of a talented video editor to assist me in creating a promotional video. The video is aimed at showcasing our products and services in a documentary-style format. Key Requirements: - The video must be engaging and professional, while maintaining a subtle promotional tone. - No voice-over is needed, so the editing should focus on visual storytelling and flow. - It's crucial that the final cut reflects our brand and values, therefore attention to detail is a must. Ideal Skills and Experience: - Proven experience in creating documentary-style promotional videos. - Proficiency in video editing software. - A keen eye for detail and storytelling. - Understanding of branding and promotional content. If you have any previous work that aligns with this project, plea...

Fixed cost & developers from Uttar Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. Please provide your quote for the project, along with your relevant experience...

I need a tool that will help me process a large amount of images by cropping them automatically to a landscape format. Project UI Link: Key Features: - Image formats supported: JPEG, PNG - Output dimensions: landscape (width > height) - Automatic detection and cropping of the main subject of the image is preferable or that can be selected as need. Ideal Freelancer: - Proficient in image processing and recognition - Experience with automation scripts - Strong background in image data manipulation - Familiarity with JPEG and PNG file formats. If you have the skills and experience necessary to develop such a tool, please get in touch.

I need help with data entry and formatting for a Go...need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to captur...

...investors, and stakeholders Responsibilities: Collaborate with our team to understand the project requirements and objectives Develop a creative and engaging storyboard based on the provided script Create high-quality animations that align with our brand and project goals Incorporate feedback and revisions as needed to ensure the final product meets our expectations Deliver the final animation in a format suitable for online sharing and presentations Requirements: Proven experience in creating animation videos, preferably for software or tech projects Strong portfolio showcasing previous animation work Proficiency in animation software (e.g., Adobe After Effects, Blender, etc.) Ability to work independently and meet deadlines Excellent communication skills to collaborate effect...

The project consists of an AI-based booking platform that receives booking orders from various text sources. The text does not have a predefined format. The AI analyzes the text to generate the corresponding booking order in a predefined format, enabling integration with a small ERP software. Input and output data must be defined and calling functions created in C# if required. The AI is desired to be working on a private local server running Microsoft Windows Server.

I am seeking a skilled and experienced designer who can h...color scheme will be essential in our rebranding process, helping us to align our products with the new brand identity. Ideal Skills: - Extensive experience with Photoshop, particularly with the Hue/Saturation tool - A good eye for aesthetic improvements - Experience with product image editing or e-commerce Deliverables: - All files should be high-resolution(similar to original photos) and in a format same as given image not same as sample color image. Please let me know if you're proficient with Photoshop and have experience with similar projects. I'm looking forward to seeing examples of your past work. Attached Zip file of images. It includes 12 colour variations and 2 products. It means, total 24 variatio...

I'm in need of a web crawler that can extract specific data from a large online ads website. The extracted data should then be neatly exported to a Google Sheet. Key requirements: - The crawler should not be intrusive to the host website. - I want the crawler to crawl current and expired ads based on links present in the site map, as historic data is also of importance to me - You should be able to provide a way for me to run this crawler myself at any time - ideally on a monthly basis. I haven't yet decided on the precise fields to be extracted. I'm looking for someone with the skills to recommend suitable fields that could be beneficial for my project. It's important that the extracted data is organized and easily readable once exported to Google Sheets. ...

Project Title: Service Architecture Diagram for Project Beta (Open-source format) Project Description: Project Beta, seeks a qualified freelancer to create a Service Architecture Diagram for our business. This diagram will visually represent the flow of data and interactions between various components within our system. See project requirement doc attached

I have a file sourced from the internet that was originally in a landscape format, but I need it to be converted into a portrait layout for a poster design. I need this new file to be compatible with CorelDRAW without losing any pixel quality. Requirements: - Convert a landscape design to a portrait layout - Ensure the new file is compatible with CorelDRAW - Maintain high quality and pixel resolution throughout the conversion Ideal Skills: - Proficiency in graphics design - Experience with CorelDRAW - Ability to maintain high-quality resolution - Strong understanding of design principles & layout Please let me know your background in graphics design and any similar projects you've worked on.

I require data entry services targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders should have the following: - Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract dat...Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract data from digital files. - Attention to detail, ensuring data is properly entered without errors. - Experience in the field of data entry, especially if done in multiple languages. Your role will primarily involve transferring data from digital files into our designated format. Please state any relevant experiences or skills in...

I am seeking a proficient and articulate PowerPoint wizard to create a specialized template. It should be capacious to showcase over 20 projects with their respective details in a stylish and easily comprehensible format for senior leadership. Ideal skills and experience: - Proficient in PowerPoint design features - Demonstrable experience in infographic and layout design - Expert in using color combinations to develop engaging slides Key Requirements: - Color scheme: Blue and white is the preferred choice for the PowerPoint slide template. - Project Detailing: Each project should display its Title, Timeline, Key Milestones, Goals, and Challenges. - Organization: Projects should be organized on the PowerPoint slide template based on project status (completed, ongoing). Your de...

I'm seeking a professional auditor to conduct a comprehensive annual financial audit for my company in Vancouver, Canada. The primary goal of this audit is to validate financial statements, with a keen focus on the balance sheet, income statement, equity, and cash flow statement. Ideal Skills/Experience: - Proven experience in financial auditing, particularly annual audits - Excellent knowledge of financial regulatory compliance - Skilled at identifying financial irregularities - Proficient in reviewing and validating balance sheet, income statement, and cash flow statement. This engagement will require a meticulous individual who can handle the complexities of a comprehensive financial audit while upholding the highest degrees of professionalism and integrity.

...soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). - Kno...

...demonstrating the process of account creation, duplication, and management. Objectives: To illustrate the ease of use and efficiency of for agencies. To demonstrate key features such as account creation, account duplication, and seamless account management. To encourage agencies to sign up for by showcasing its comprehensive toolset. Video Specifications: Length: Approx. 2 minutes Format: High-definition quality, suitable for both web & social media platforms and mobile viewing. Style: Modern, professional, with a direct focus on walkthroughs and screen captures of the platform in use. The color scheme for the video and logos will be attached as a separate document. Audio: Background music should be uplifting but not overpowering. Music should be royalty-free or licensed...

I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and p...generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and negotiati...

I'm seeking a skilled video editor for my YouTube channel. The goal is to convert my existing video content into engaging, fast-paced 1-minute clip...overlays or captions throughout the video - Ensuring the final product is suitable for YouTube and other social media platforms Ideal skills and experience: - Proficiency in video editing software (e.g. Adobe Premiere Pro, Final Cut Pro) - Previous experience in creating short form content for YouTube or other social media platforms - Strong understanding of pacing and storytelling in a short format - Ability to use text overlays and captions effectively - Understanding of YouTube content guidelines and best practices If you're a creative and experienced video editor who can bring energy and engagement to my content, I'...

I am in need of a proficient typist who can transcribe content from image files into English. The ideal candidate must have a typing speed of 60 words per minute to ensure efficiency. Key Requirements: - Typing Speed: A minimum of 60 words per minute is a must. - Document Type: The content to be transcribed is in image file format. - Language: The documents are primarily in English. Your responsibilities will include: - Accurately transcribing content from image files to English text. - Ensuring that the transcribed text is error-free and does not deviate from the original content. It's crucial to possess a high level of attention to detail to avoid any errors in the transcribed text. Previous experience in transcribing image files will be considered an advantage. Please inc...

I'm looking for a proficient spreadsheet expert to create a thorough forecast sheet for my new project. I will be providing all required information for our project. It’s a village that we building and we need proper professional spreadsheet done with ( cash in flow and cash out flow. . It should encompass data on sales, expenses, and profits, analyzing trends and variances, while also incorporating a break-even analysis. Key Requirements: - In-depth monthly analysis of sales, expenses, and profits. - Solid experience in applying trend analysis. - Capable of conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed year...

Can you get me a quote for this small app Audio Diary overview - Firebase Auth - List of my entries - Entry detail screen - Add / Edit / Delete entry Specific Diary Entry Features - Write text entry (markdown support) - Record audio diary entry - Store and transcribe audio - Display transcribed audio text in editable format - Include player to hear original recording within entry

I'm looking for a talented designer who can create a brand mascot that will represent our shipping company department. Key Requirements: - Mascot Type: Animal Character - Emotion/Trait: Friendliness - Design Format: Both digital illustrations and 3D model The mascot needs to be appealing, friendly, and easily recognizable. It will be used across various digital and physical platforms to promote our services. Skills and Experience: - Proven experience in mascot design, particularly animal characters - Proficiency in both digital illustration and 3D modeling - Ability to capture and convey emotions and traits through design - Strong understanding of brand representation and appeal Your design will play a crucial role in establishing our brand identity and enhancing customer...

I need an experienced Wordpress developer to create a custom online form on my website using WPForms. The form should save all submitted data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong comma...

I am seeking a skilled professional who can deliver realistic nature-inspired album artwork. Your work should evoke the emotions depicted in each song, which means the chosen color palette may vary from warm to cool to neutral tones as required. The ideal candidate should have: - Experience in creating album artwork, espe...required. The ideal candidate should have: - Experience in creating album artwork, especially within the music industry. - Ability to translate song emotions into compelling visual stories. - Proficiency in experimenting with color schemes. - A keen eye for detail and the ability to capture realistic depictions of nature. I highly value creativity and the ability to interpret music in visual format, so I welcome freelancers who can bring fresh ideas to th...

I have a Google document that I need converted into a Word document, specifically in .docx format. Special Requirements: - The Word document's formatting should mirror the existing Google document's formatting. - The Google document includes images that need to be accurately transferred into the Word document. - No other specific formatting is required. Ideal Skills: - Proficiency in Google Docs and Microsoft Word. - Experience in handling image transfers between different document software. - Attention to detail to ensure the final Word document looks identical to the original Google document.

I am on the hunt for a creative and talented freelancer to design an engaging company profile in PowerPoint format. This content rich profile will contain detailed information such as our company's history, mission and vision, and the products and services we offer. Given that the target audience is our potential customers, skills in marketing and great understanding of customer demographics will be highly regarded. Proficiency in PowerPoint is a must along with the ability to convey complex information in an easy-to-understand manner. A background in corporate storytelling or alike will be a significant plus. Ideal skills include: - Expertise in PowerPoint - Brilliant storytelling abilities - Understanding of customer demographics - Background in Marketing or related fiel...

I need an experienced designer who can convert 2 existing posters into vector format using Adobe Illustrator. This is to ensure that the posters can be printed at a size of 120 cm width and 180 cm hight without any loss of quality or pixelation, so the final product is crisp and clear. Key requirements: - Posters are ready and do not need any design changes - Conversion to vector format is the main task - I will be printing the posters at a size of 120 cm width and 180 cm hight, so the vectorization must be of high quality to accommodate this - The final deliverable should be in a format that will not lose quality when scaled, such as SVG or PDF. - Experience with large format printing is a plus The deadline for this project is ASAP. Please let me know if you ...

I need an expert to address mesh deformation problems in my 3D characters created in Blender. - The initial modeling was done in Blender. - The primary issue we are facing is mesh deformation. - The character files are in FBX format. Ideal candidates should have: - Proficient experience in Blender - Expertise in character modeling and skinning - A strong background in fixing mesh deformation issues - Knowledge of FBX format and compatibility - Good communication skills to understand the project requirements and provide updates on the progress. IMPORTANT :The main issue is in the mesh called headarms ,the model has many meshes that are disabled to make it easier for you to fix the headarms mesh ,the character has a rig already but when i added the headarms mesh this mesh...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.