Automatic graphs excel vbaงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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)
...- Persons with interest in Japanese tourism - Candidates may be offered more work if their results are good so we look forward to many applicants - Japanese speaking candidates are welcome but candidates who don't speak Japanese are still considered ■Prohibition - Copying or rewriting of any existing content or article already submitted - Submitting products that copied from any result from automatic translation tools or software - Reprinting or leaking of any contents to a third party Plagiarism is crime, and please be aware that there is a case of termination of the contract and legal procedures when such act including "copy and paste" would be discovered....
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...should have a basic understanding of digitazation and you are a critical thinker who can analyse the above matter of the position. You'll need to have expertise in lead generation, particularly in the industries mentioned above. If you had already some experience with lead generation in Switzerland or at least for European companies, this would be a great plus. the data structure should be an excel with minimum the following information: - company name - Some address or city - company website - Industry (one of the 4 above or more detailed) - Some short text about their product (can be e.g. the subtitle of company linkedin page) - contact person name - contact person position - contact person email - some telephone number (can be company or contact person) We ideally ne...
**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to s...have no confidence here in a working tool with proof as you need to communicate. 2. What key strengths that you bring to the table that make you the right fit. 3. Your experience / skills 4. Set the duration of your bid to 30 days. 5. Bid your rate for a total of 30 days, NOT hourly or daily. The budget is ~$10 a month (per 30 days) for internship. Compensation increase after 30 days. Automatic or generic bids will be ignored. No agencies or firms, only individuals. Happ...
I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.
I'm looking for a skilled professional to assist with a data entry project. The aim is to input various contact details into a spreadsheet, with a range of essential and additional information. Key responsibilities include: - Entering Name, Email IDs, Phone/Mobile Numbers, and Website Links for each entry. - Including LinkedIn profile links, Other correlated details, and Remar...for each entry. - Including LinkedIn profile links, Other correlated details, and Remarks for each entry. Ideal freelancers for this project should: - Have a background in data entry. - Possess excellent attention to detail. - Be able to work efficiently and accurately. - Familiarity with LinkedIn and other social media platforms. - Experience working with data on spreadsheet platforms like Excel or...
**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to s...have no confidence here in a working tool with proof as you need to communicate. 2. What key strengths that you bring to the table that make you the right fit. 3. Your experience / skills 4. Set the duration of your bid to 30 days. 5. Bid your rate for a total of 30 days, NOT hourly or daily. The budget is ~$10 a month (per 30 days) for internship. Compensation increase after 30 days. Automatic or generic bids will be ignored. No agencies or firms, only individuals. Happ...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
Deseo un sistema de ventas que me permita crear una base de datos para mis clientes , registrar inventario de bidones , registrar los pagos en efectivo Transferencia y los que deben , registrar compras , Cuento con un cuaderno con informacion de los meses de enero febrero y marzo quisiera ingresar esa informacion . Adjunto un formato de excel donde llevo prácticamente ingresando datos manuales , necesito llevar control de los ingresos y egresos
I'm in need of an Excel Calculation Expert. I have data spreadsheets that need to do the calculations using Excel Your primary task will be to: - I've dataset (excel file), that needs to do the calculation using excel - Once it done then you need to write report as per following requirement Deadline: 10 hours or less
I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours
I am seeking a talented pop vocalist with a knack for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal a...for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal abilities - Previous songwriting experience or ability to translate poetry into musical form. This is a fantastic opportunity for those who excel in conjuring up catchy pop melodies and are skilled at breathing new life into writ...
I'm in need of a professional to help design an e-commerce website for my physical product business. KEY REQUIREMENTS: - **Product Type**: I'll be selling physical products. So, the site should be optimized for showcasing and selling items. - **User Reviews & Ratings**: I wan...applicants for this job should have: - **Ecommerce Website Design Experience**: A solid portfolio showcasing ecommerce websites they have designed will be an advantage. - **Understanding of User Experience**: I'd like to work with someone who understands the importance of user experience in ecommerce. - **Proficiency with Inventory Management Systems**: Experience with setting up and managing automatic inventory systems is a big plus. Please provide details about your experience with th...
I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.
...maintaining viewer interest. - Motivational Music: I specifically prefer an Inspirational Cinematic style for the background music. The track should complement the visuals and elevate the overall impact of the reel. - Screenshots: The reel should include screenshots of the Robinhood balance increasing 15-20 times over the 15 days. These screenshots should be a mix of static images and animated graphs, creating a dynamic visual representation of the account's progress. The ideal candidate for this project would have experience in video editing, a creative eye for storytelling, and a strong understanding of how to pair visuals with music for maximum emotional impact. Experience with financial or motivational content creation would be a plus. Please provide samples of your pre...
I'm looking for an AI expert who can develop a comprehensive solution to automate the reading, interpretation, and writing of environmental reports. We have Phase 1 and Phase 2 ESA reports (or PSI and DSI reports in Australia) - and others. They have general templates, and summarise information from pdf, excel and other document formats. I initially want to develop a pathway to do this and whether AI is ready for it, and how much time it might take to create. I want to build an algorithm, and know what AI tools can train on existing reports we have/online and help generate paragraphs in sections of the report by reviewing information documents provided. I can supply example reports and document formats for entrants after the NDA is signed. Competition deliverables - you ...
In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.
I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.
...OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices&quo...
We need to ...investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and infographics (you can redesign the charts already put in the model). Incorporate interactive visuals for digital presentations if possible. Highlight key figures with distinct colors and larger font sizes. Present trends over multiple years to show growth or changes in metrics. If you need additional figures ask us. We would need this to be finished...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
I am looking for a proficient developer to promptly provide critical updates to an existing WordPress plugin. After ensuring that these updates are successfully completed, I would like the plugin to be set for automatic future updates. Key areas to be focused on include: - Functionality enhancements: While specific changes haven't been identified, a comprehensive analysis and improvement of any weak spots is crucial. Your expertise in assessing and enhancing functionality is of immense value. - User interface: The project entails making necessary modifications in the UI design to ensure user-friendliness. Ideal skills for this role would include: - Advanced WordPress knowledge - Extensive experience in plugin development and updates - Strong troubleshooting abilities - Ver...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
The goal is to develop a “media gateway” device able to receive a panoramic video from 2 cameras (for wider field of view) in RTSP/RTMP format and produce “professional-like” broadcast video to OBS t...receive a panoramic video from 2 cameras (for wider field of view) in RTSP/RTMP format and produce “professional-like” broadcast video to OBS to be further mixed, add graphics and etc and late streamed to Youtube (RTMP). To do so, the system will be able to crop the original panoramic video in a way that “follows the action” and simulates the panning movement. This production needs to be fully automatic, with no human intervention beyond activating / deactivating the stream and calibration to the field. Example of open source program:
I'm looking for a professional who can set up an automatic download of mainly .csv files from FTP, SFTP, https and webscraping-login. The script should be configured to run daily/weekly at pre-defined time - configurable for each file. Requirement: Check after each download that the download has actually been downloaded. Notify user if any errors occur. Key Requirements: - Configure FTP download automation on Windows enviroment or hosted. - Schedule the download to occur at defined day/hour. - Check if download has been succesful. - Clear commented code. I only respond to bids where the bidder clearly has read the description...sorry (not really sorry, lets not waste each others time :) ) I prefer fixed price, but have entered hourly - let me know your suggestion.
...task will specifically focus on: - Changing the layout of the style sheet and VB code. This modification is needed to appropriately accommodate some new fields that have been added to an import file. - Improving the style sheet so as to automatically map the new fields from the import file. The ideal candidate for this job should have experience with layout adjustments in XSL style sheets, automatic mapping of new fields and VB coding. Your skills and experience in rearranging content layout, updating fonts & colors, and altering data display formats will be highly appreciated. Don't hesitate to place your bid if you can deliver this effectively and efficiently. This is fairly simple task each year but neither of us have time to do this today and we are in a time c...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I search anharmonic indicators that can find custom harmonics, i've also find one that its okay and i have collected interesting information on non-traditional harmonics: they have an impressive win rate! The indicator name is Custom XABCD Validation and Backtesting Tool (open source), but for the purpose of completing the search, it would be useful for me to be able to insert m...the same time (5/6), as well as in BC/AC, and so on, in so that the indicator is activated as soon as a combination of those values matches. having already a code base, I believe that for a pinescript developer it is a piece of cake! if anyone have the time to give me a hand, I will gladly share with you all the results collected, so that we can both benefit from it, and maybe one day build an automatic...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
