Excel macros create text files excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ฉันสามารถออกแบบสิ่งที่คุณต้องการโดนหาแรงบันดาลใจจากคุณ เปิดโอกาศให้ฉันได้ร่วมงานกับคุณ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...aspects: Text to Speech and Speech to Text development: - fix existing code - API integrations - using elevenlabs and assemblyai - Integration of voice to text and text to voice features - Experience in developing RAG web applications Data Analysis: - Strong analytical skills and experience in handling data - Able to provide insights and make recommendations based on data - Proficient in Python data analysis libraries In particular, I need the voice to text and text to voice functionality to be focused on converting text to speech. Ideal candidates for this project should have: - Proficiency in Python, with a strong focus on web development and data analysis - Experience in creating user registration and login features, content manag...
...handle a variety of tasks. From scheduling my appointments and managing email correspondence to organizing my documents and files, this role is vital to the efficient running of my office. Key responsibilities include: - Scheduling appointments and meetings: You should be adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling sof...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
Project to create a digital memorial (mini social network) platform for people to honor their loved ones. Our prototype is ready, and we'll develop it using C#/.NET for robustness and scalability. Link to website prototype: (Copy)?type=design&node-id=0%3A1&mode=design&t=jfwDURBhWcI72r1x-1 You don't need to strictly adhere to the prototype design; it's meant to showcase the elements within it.
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
I'm looking for a developer who can replicate a person based on gpt. The functions I want are as follows. Development environment: Python 1. When I put in a YouTube link, I create a gpt model that has the person's personality, tone, and knowledge. 2. The model made in No. 1 and the app that can chat using gpt api (this is already made with flutter). What I want is to develop No. 1 into Python. If I have to use llm other than gpt, it doesn't matter if I can just get an answer with api. If I can't completely replicate a person with YouTube link alone, I welcome anyone who has other options. The key is to create a chatbot that has the way a particular person speaks, personality, and knowledge. An example is caryn ai on the market.
Project Description: We are looking for a skilled WordPress developer to build a website for , a company specializing in property and business loans overseas. The website should support multiple languages and feature a multi-currency loan calculator, secure loan application processing, and user account management. Objectives: Develop a clean, professional-looking website using WordPress. Include key functionalities such as a loan calculator, multi-language support, secure application forms, and customer login areas. Required Features: Multi-currency loan calculator Secure application processing User registration and management Responsive design for all devices SEO-friendly structure Skills Required: Proficient in WordPress, PHP, HTML, CSS, and JavaScript Experience with financial servi...
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
I'm in need of a professional who can create a 20x20 inch door decal for me by 7pm. I have the logo I need the hours and social media under the logo all of the text is provided, Put the hours directly under the logo. Please use instagram icon for Instagram instead of words. Put the mail icon for email. WHITE TEXT: Monday 12-7 Tuesday 12-7 Wednesday 12-7 Thursday 12-7 Friday 11-8 Saturday 11-8 Sunday 12-5:30 Instagram: @ lluxecafe Website: www. Email: lluxecafe @
I need a skilled Adobe Illustrator designer to modify existing image elements to more closely resemble another provided sample. The modifications required are: • Changing the layout by resizing and rearranging elements. • Textual changes: Changing the font type, adding new text content, and deleting unnecessary text. • Updating existing chart images with new data. Prior experience with layout modification and text editing in Adobe Illustrator is ideal.
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, y...
I'm urgently seeking a freelancer who can assist in modifying the formatting in a PDF file I have. Your responsibilities will include: - Adjusting the text charges in the document. Ideal candidates for this project will have excellent attention to detail, proficiency in working with PDF files, and the ability to work swiftly as this task needs to be completed ASAP. Knowledge of diverse formatting styles will be a real asset. Please provide examples of similar work you've done in your proposal.
I'm in need of a CV expert who can assist in both the formatting and design, as well as content improvement of a completely new CV from scratch. This new CV should be specifically tailored to highlight my skills and experience for management roles. Key aspects I am looking for are: - A clear, professional layout that meets standard formatting expectations for management roles. - Strong, compelling content that effectively showcases my achievements and capabilities. Content should be powerful yet succinct. - Solid understanding of what hiring managers in the management sector are looking for in potential candidates. In an ideal world, the freelancer should have strong experience in developing CVs for clients targeting management roles. A proven track record in creating successful C...
I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the right p...
...of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastName Email Phone Sex Company Date Created Date Updated 2 Forgot Password Email 3 Change Password Old Pass New Pass Confirm Pass 4 Admin Dashboard Screen to manage Users and User Roles a. Admin User have permission to create an another user. Page #1 can be used. b. View of Users and Assign Roles, Permission. Status, Last Login, Date Created/Updated/Deleted. 5 Logs - Admin to view the logs of all the users - like when they logged in , what actions they did for audit purpose. Just a view and search screen 1. Registration & Cancellation & View & Update 2. Configure Mail Communic...
...learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the Smartsheet and create Dashboards for multiple audiences. Ideal candidates should have: - Expertise in Smartsheet - linking Smartsheet plans to external data - Linking Multiple Smar...
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...
I'm in need of an experienced sales agent who will work as a representative for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with indiv...for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with individual clients - Providing expert advice on travel solutions You're a great fit if you: - From Taiwan - Have prior experience in sales, especially in the field of consulting - Understand the travel solutions market - Excel at building customer relationships over diverse clientele. I look forward to boosting my travel consultancy service s...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a modern, sleek logo that combines both text and an icon. The logo will be used primarily on my website and on product packaging. I have a preference for a black color scheme, though I'm open for suggestions. Key points: - Modern, sleek logo design - Combination of text and an icon - Primarily for website and product packaging - Preference for black color scheme, though open to suggestions
I require a skilled and experienced web developer to create a custom HTML emailer for me. The emailer should be compatible with both Outlook and Gmail. Here are the specifics of the project: - You will be provided with a JPG image that will form the basis of the emailer. Your task will be to incorporate a single line of hyperlinked text in the middle of this image. The hyperlink should lead to a designated URL. - The emailer should be designed to display correctly across different email clients, especially Outlook and Gmail. The ideal candidate for this project would have: - Proven experience with creating custom HTML emailers. - Proficiency in working with JPG images and integrating hyperlinks into them. - A good understanding of the unique constraints and requirements ...
I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.
Create LSTM model in python to predict price for six month in the future.
I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images and employing Adobe Illustrator's eye dropper tool to identify the hexcodes for each. Main objectives include: - Identifying hexcodes for main colors using Adobe Illustrator - Organizing the hexcodes by clothing type - Completing the provided Excel Sheet Your role is critical as the information will be utilized in color trend analysis for apparel. Therefore, a proven background in graphic design, color profiling, knowledge of Adobe Illustrator and an eye for fashion would be ideal. My budget for this project is 100 USD. Please, proficient users of the English language only for accurate communication.