How to fill blank cells in pivot tableงาน
หน้าแบบฟอร์ใบเสนอราคา 1. ดึงข้อมูลลูกค้าจาก Database หรือ สามารถเพิ่มรายชื่อลูกค้าใหม่ได้เลย ใช้ Select2 1.1 เมื่อดึงข้อมูลลูกค้าได้มากแล้ว ให้ Auto fill ข้อมูลที่เลือเช่นที่อยู่ใบกำกับภาษี 2. ค้นหาข้อมูลสินค้าในฟอร์ม 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง SKU ได้ และ Auto Fill ช่องอื่นๆเช่นรายละเอียดและราคา 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง Detail ได้และ Auto Fill 3. SUM ราคาสินค้าแยก VAT และราคารวม 4. ส่งเอกสารให้ ลูกค้าได้ในรูปแบบไฟล์แนบ PDF และ Email ได้ทันที ข้อมูลตามรูปแนบบ ใช้ Codeinater และ Boostrap4
I need you to fill in a spreadsheet with data. ทำงานค้าขายตามตลาดนัด
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
...Operation course, and I am looking for several TIKTOK creators who can face the camera to imitate and shoot simple oral videos. You don't need to have a lot of social media experience, as long as you're willing to try. Your main responsibilities include: - Execute video shoot according to the script we provided. - You can also write your own script based on the content we provide or improve. To increase brand awareness, your content should be engaging and cause widespread sharing and liking on the platform. The ideal candidate should have: - Look comfortable in front of the camera. - Fluent in English or Spanish - We cater to the North American market, which would be great if you are American or Mexican Ability to...
We are looking for a talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required L...
...delivered in a written document format. The guide need to be focused on drawings from building services/installations designs in constructions (HVAC & Plumbing area) With the following necessary instructions: - it need to treat primary 2D and in 2 chapters 3D modelling - It need to have table of contents - 14 chapters - image/text ratio maximum 35/75 - Each chapter will have to have 2 exercises to solve at the end, including the solutions, separately, for them - formated on A5 - gramitacally and tehnically correct text - verified in Turnitin, max 10% plagiarism. - images must be color. - minimum 100 pages Key Focus Areas: - Basics of Autocad interface: Explanation of the key tools, menus, and workspace within Au...
Make the website same as the existing website, studio.d-id.com. The Backend will be provided. Please share your thoughts on how you would approach this project and what experience you bring to the table.
Hola, Estamos finalizando la funcionalidad de una web. Actualmente hay páginas que tenemos que modificar para que se adapten a versiones table y móvil. Buscamos una persona con conocimientos html y ccs para hacer estas modificaciones. Es obligatorio hablar español. Y buscamos un precio bajo y competitivo. Gracias.
I'm in need of a skilled concept artist who specializes in creating realistic character designs. The aim is to create a concept art with some modifications from an existing cobcep art. Key project requirements include: The artist should show me a Realistic concept of the attached giant character in female form. The Giant needs to be exact height and pose but with a female version. So need to have female eye mask, beautiful female hands and female legs. You can take help of AI but the final render needs to match the attached artistic flow. That's it!!! The best and the most attractive image will be the winner. Ideal candidates will have: - Previous experience in the Concept arts/Character designs. - A strong portfolio of ...
I'm looking for a talented developer to create an online examination platform for my educational organization. Here are the main features and requirements: - Support for multiple question types: The system should be able to handle various question types such as multiple choice, true or false, and fill in the blanks. - Extensive subject coverage: The examination will cover more than 10 subjects or topics. - Automatic grading: The platform should have a robust automatic grading feature that can handle all types of questions, not just multiple choice and true or false. The ideal candidate is someone with a strong background in web development and experience in creating online examination systems. The ability to create a user-friendly ...
...can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a
I need an experienced HR freelancer in the city of Lucknow, who excels in recruitment and selection processes. My company is in the sales sector, and we are currently seeking to fill a position for a Sales Representative. Key tasks: - Identifying potential candidates - Conducting interviews - Facilitating the hiring process. The ideal candidate for this job would have ample experience in HR, particularly in the sales field. Their skill set would include an in-depth understanding of recruitment procedures, excellent people skills and the ability to recognize promising sales candidates.
Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.
...designer to create a jiu jitsu journal. This journal should be not only a place to log training and progress, but also a source of inspiration and mindfulness. It needs to have a clean and minimalist design. Here's a detailed list of what I am looking for: - Training log section per training session - Technique library or pages dedicated to techniques - Progress tracker which includes tracking for belts, stripes, seminars, competition history - Sections for gratitude, mindfulness, wellbeing, and meditation challenges - Pages with inspirational quotes - Blank pages filled with key questions and prompts about jiu jitsu eg: What are your short, medium and long term SMART goals. What does jiujitsu mean to you? Why should you compete? What les...
...hospitality industries. • Aim: This project's goal is delivering a bright, bold, and unique aesthetic that captivates and engages guests. • Preferred Style and Colors: The design should embody an eclectic mix of styles and a bold color palette to create a vibrant mood. Ideal skills for this project: • Proficiency in eclectic interior design • Experience in bright, bold color scheming • Experience designing for hospitality businesses. Your creative vision in blending different style elements can create an energetic, inviting atmosphere in our establishment. Interior Design Brief for Women's Salon 1. Overview: Design focus: Create a luxurious and functional space for a women's salon wit...
I'm in need of a talented content writer that can create engaging, short-form content for my audience. Key Requirements: - Ability to craft high-quality content that is less than 500 words in length - Understanding of how to engage an audience through writing - Strong grasp of the English language and grammar - Previous experience in creative writing, blog posts, or similar content The ideal candidate will be able to make my readers want to dive into the content and keep them interested in every piece. This content should be concise and captivating, designed to get the reader to react or respond. If you can bring these skills to the table, please get in touch with me.
I'm in need of a talented designer who can create realistic mockups of various tables for my home decor line. Key Responsibilities: - Designing and creating mockups for tables - Ensuring the mockups are of high quality and look realistic - Providing a variety of designs that align with my brand Ideal Skills & Experience: - Proficiency in design software such as Adobe Photoshop, Illustrator, or others - Experience in creating mockups, particularly for home decor items - A good understanding of my brand and design aesthetic - Strong attention to detail and ability to deliver high-quality, realistic designs %d7%a9%d7%95%d7%9c%d7%97%d7%a0%d7%95%d7%aa-%d7%a1%d7%9c%d7%95%d7%9f this is reference for the type of design I'm looking for
Always visible MENU with : 1. Webflow "7 categories" menu + "contact" and "about" 2. Webflow LIST/ filtering sorting each of the 7 categories. On a click the listed projects can be shown as ImageA or ImagesB PROJECT PAGE With Home buttons With 4 blocks of text on the top + max.10 images and text + links to PDF WEB DESIGN (layout) Provide or adapted from the draft CONTENT Instructions to fill it by us
...a dynamic individual to fill the role of YouTube Content Sr. Executive at Vativa Design & Development in Chennai. This position is ideal for someone passionate about crafting engaging content, managing video production, and optimizing strategies for YouTube channels. Responsibilities: - Is able to work full-time on the project and meet deadlines consistently - Upload 5 shorts per day with a focus on SEO keywords. - Implement SEO and keyword optimization techniques to boost subscribers and viewership - Is familiar with YouTube's algorithm and best practices for channel growth - Willingness to undergo a trial period. - Package: INR 35,000 - 40,000 per month - Need to reach 200 subscribers per week - Need to reach 10k viewer...
I am seeking a professional to develop a custom click funnel with the primary goal of lead generation. Key Requirements: - Your primary focus will be on capturing leads from individual consumers (B2C). - The follow-up phase of this project will specifically involve creating an automated email series for engaging with the captured leads. Ideal Skills: - Proven experience in building successful click funnels for lead generation. - Strong understanding of B2C lead generation tactics. - Proficiency in designing and implementing automated email sequences. This project is of great importance to me, and I am looking forward to working with someone who can bring their expertise to the table.
...multimedia expert to create visually engaging projections to accompany our performances. Key Requirements: - The content will be a mix of stills and videos, with approximately 30 pieces in total. - The resolution for each piece should be 1920x1080. - I need the content to fit a 4:3 aspect ratio to properly fill the back of the stage. Content Details: - I'm looking for a blend of abstract and realistic imagery. - Each piece should be more than 2 minutes in duration. Ideal Skills: - Proficiency in creating high-quality stills and videos. - Strong understanding of abstract and realistic visual styles. - Experience in creating content for live performances or events would be a huge plus. If you're a creative mult...
Model + render coffee and side table. Pictures and dimensions are provided in chat box.
...can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a
I'm lookin...business loan application forms to fill in and send back to me. Key requirements: -fill in the question and write a user-friendly loan application form for high success rate. - there are 2 forms to fill in 1- Business plan template 2- cash flow template, they are in Microsoft excell file, once filled in just save and return to me so it is ready for the application upload. Ideal freelancer will have: - Proven experience in English literature - Strong understanding of business planning and growth. The application form is an essential part of the loan application process, with few questions which asks how the business growth and planning , once is written I can revie...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
I'm in need of a talented designer to create a modern and minimalist logo for my brand. Additionally, I require a comprehensive brand manual to ensure consistency across all brand assets. Key Responsibilities: - Develop a modern and minimalist logo that aligns with my brand identity. - Create a detailed brand manual outlining the appropriate use of the logo, color palette, typography, and imagery. Ideal Skills and Experience: - Proficiency in graphic design and branding. - Strong understanding of modern design principles. - Previous experience in creating brand manuals. - Ability to work collaboratively and incorporate feedback. Please note, my target audience is the general public, especially kids, young adults and parents. The successful ...
As the client maneuvering through the competitive health supplement industry, I'm in search of a talented and creative freelancer to design my product packaging. Key Requirements: - Expertise in designing product packaging, specifically for health supplements. - Strong understanding of designing product visuals that effectively appeals to my target audience – adults and seniors. - Ability to bring creative ideas to the table, yet embody the wellness and trustworthiness of the product through design. - Keen awareness of industry trends and competition. The freelancer should be able to showcase a strong portfolio of product packaging designs, especially within the health supplements sector, demonstrate excellent communi...
...need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the docume...
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.
I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.
I want a skilled PHP developer with experience in form handling to create a script for me that will block a form's submit button until certain conditions are met. Key Requirements: - The button should only become active if the user types in any text. This means if the form is left blank or a field is left empty, the button should stay inactive. - After clicking the button, if the conditions are not met, I want an error message to be shown to the user. This is to ensure that they understand what is expected before the form is submitted. The form is working inside an wordpress website but was made with php
I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please ...
I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appealing, modern designs that align with our brand is crucial. - Functionality Enhancements: There are certain functionalities within the project that need to be revisited and improved. Your role will involve identifying areas for enhancement, suggesting necessary changes, and implementing these updates effectively. You should be well-versed in PHP developm...
...developer to make specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number&quo...
...the owner of an upcoming web application, I am in need of a professional UI designer who can develop an illustrative interface for my platform. Key responsibilities will include: - Designing a distinctive, illustrative UI that is both engaging and user-friendly - Implementing design principles which align with the functionality of the application - Ensuring that the design appeals to the platform's target market Ideal candidates should have: - Proven experience in designing interfaces for web applications - Demonstrated proficiency in creating illustrative UI designs - Solid understanding of user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to...
...calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static method. The other one should compare the performance of the two forecasting methods using the key performance indicators (KPIs) mentio...
I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount on this project.
...need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a p...
...designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform potential clients about our custom home building design process. Key elements for the brochure include: - A visually appealing, modern and sleek design that resonates with the target audience - A detailed explanation of our custom home building process in a clear and engaging manner Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project is perfect for a desig...
I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new se...
I am in need of a seasoned digital marketer who can proficiently handle SEO, social media management, and email marketing tailored to reach local customers. This role requires a keen understanding of how to effectively drive lead generation. Specific responsibilities include: * SEO: Optimize my website's organic search rankings to improve lead generation * Social Media Management: Craft and execute a strategic social media plan to connect with the local customer base * Email Marketing: Develop a captivating and result-driven email campaign The ideal freelancer: * Experience with SEO, social media management, and email marketing * Proven track record of lead generation * Understanding of local market demographics and trends * Strong analytica...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
3D modeling and two photorealistic renders showing the assembly of the table
...professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatt...
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task ...
I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
