How to insert multiple blank rows in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.
...application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be developed for Android. The general structure of the application and a sample of the answer sheet are attac...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are c...
I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.
I'm in need of a 3D artist who can create a basic product model for me. This model should be able to be viewed from different angles. Key Requirements: - The project involves product modeling, so experience in this area is essential. - The model needs to be created with basic shapes and forms. No complex detailing or textures are needed. - You must be able to generate multiple views of the model, allowing me to see it from different perspectives. Ideal Skills and Experience: - Proficiency in 3D modeling software, such as Blender, Maya, or 3ds Max. - A strong portfolio demonstrating previous experience with product modeling. - A keen eye for detail and the ability to follow design specifications accurately. - Excellent co...
...with a couple of issues on my site. Key Requirements: - Fixing a bug causing the website to load slowly. - Enhancing website speed by employing appropriate techniques. Specifics: - The main issue I need addressed is the slow loading time of my website. This should be the primary focus. - Speed optimizations should be applied to the homepage as a top priority, but I also require this across other pages of the site. Ideal Skills and Experience: - Proficiency in WordPress development and bug fixing. - Experience in optimizing website speed, including image and media optimization, content caching, and server response time reduction. - Proven track record of improving website performance across multiple pages, with a keen eye for detail and thorough te...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "P...
I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.
... user-friendly, and designed to cater to B2B customers. The primary purpose of this website is to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Design ability: keeping it simple, y...
...seeking a seasoned logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature pa...
...Specialist to join our dynamic marketing team. The ideal candidate will have a proven track record in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to va...
I'm in need of an expert blockchain developer, specifically experienced in Solana, to work on a bot development project. The key functionalities of this bot will focus on trade execution. Key Project Details: - Primarily, you will be working on a bot that executes trades within the Solana ecosystem. - Familiarity with Jito Bundles, Raydium, and Jupiter DEX is a huge plus. - The bot should be developed using Node.js. Requirements: - Proficient in Solana blockchain development. - Strong expertise in Node.js. - Proven experience in developing trading bots. - Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note:...
...Writer position offers a unique opportunity to further develop your career in the field of drug safety. Key Responsibilities: Independent authoring, editing and reviewing of various regulatory/clinical documents (e.g. aggregate reports, risk management plans and other documents needed throughout the product’s life cycle) with the responsibility for the quality and content of the document and compliance with internal and external standards. Active participation in trainings and development, implementation and maintenance of quality system documents for medical writing, including internal templates and formats required for standardized documentation. Support in all pharmacovigilance operations associated with medical writing. Continuous self-education ...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
...Script specialist with a proven track record in creating high-accuracy indicators for TradingView. The goal is to produce an indicator that can deliver buy and sell signals with exceptional precision, particularly when applied to short timeframes ranging from 1 to 5 minutes. Key Requirements: - Development of a Pine Script Indicator: The main task is to design an indicator that generates both buy and sell signals. The accuracy of these signals is crucial, and they should be specifically tailored for the 1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable ...
I'm in need of a specially developed Stream Deck plugin, tailored to capturing and instantaneously replaying in-game voice clips. This plugin will not need to integrate with any streaming software, but must have the ability to work seamlessly within gaming environments. Key aspects of this project include: - Development of a button functionality on the Stream Deck that allows clipping of in-game voices. - Instant replay feature for the captured voice clips. - Automatic saving of these voice clips without prompting the user. Firstly, I already use a plugin for the Streamdeck called “Sound Deck” for videogames and this plugin has a feature that allows me to record the voices, or sentences, of my teammates the voice chats and...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm seeking a skilled developer to create a versatile e-signing utility. This tool should allow users to select the DSC ( usb token) inserted to the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing ...
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to ...
...looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software developme...
...coaching sessions. The purpose of these sessions is to test and provide feedback on various adult-rated counselling techniques. Key Responsibilities: - Participate in individual or couple's counselling sessions focused on intimacy and relationship enhancement. - Engage with and provide honest feedback on different counselling techniques. - Maintain open communication with the counsellor to ensure the effectiveness of the methods used. - Ensure confidentiality and a respectful approach throughout the process. Qualifications: - Must be open-minded and comfortable discussing a wide range of intimate and sexual topics. - Strong communication skills and the ability to provide constructive feedback. - Willingness to participate in multiple...
...seeking a highly organized and tech-savvy Virtual Assistant to join our team for a 6-month fixed contract, with the possibility of renewal in 2025 based on performance. The ideal candidate will have experience with content creation and management, using tools such as ChatGPT, WordPress, and social media platforms. This role is perfect for someone who is passionate about technology, fashion, beauty, lifestyle, and the metaverse. Responsibilities: -Assist in planning and executing a comprehensive content calendar for our blog, podcast, and social media channels (LinkedIn, Instagram, TikTok). -Create engaging and high-impact content, including blog posts, social media updates, and podcast summaries. -Conduct thorough research on current trends in tech, fashion,...
I'm look...a skilled Flutter developer who can help me build a multi-platform application that is set to be a long-term project. My primary goal is to have a reliable app that includes a variety of features to provide a seamless user experience. the app which we building will be used 24/7/365 non stop always on Skills & Experience: - Proficiency in Flutter development across multiple platforms (Android & iOS , Windows , Web). - Strong understanding and experience with user authentication, push notifications, and local database management. - Prior work with Firebase authentication . - Experience in hardware and IoT integration . THIS IS A LONG TERM PROJECT IS NOT A ONE TIME THING AND IT MIGHT TAKE A YEAR TO FINISH PLEASE...
Looking for someone to develop a simple mobile app that will work on both iOS and android. That would mean utilizing one of those frameworks such as React Native or Cordova (or something else similar). The app will basically just allow the user to search for an order (done through a Rest API) and then select photos on the device and upload those to the selected order (also though a Rest API). Detailed Requirements: Setup screen where system URL and API key can be entered and then saved so subsequent uses of app doesn't require it to be reentered Ability to search and find order using order number, customer name, or company name Ability to select multiple photos and upload at once (although API call needs to be made for each ...
I am in need of an expert in Apache Camel 3.3.0 and Spring DSL for a project focused on system integration. Here's what I require: - A thorough familiarity with Apache Camel 3.3.0. - Strong proficiency in Spring DSL. - Capability to successfully integrate multiple systems. - Clear understanding of data transformation, routing, and error handling, although these are not the primary focus. The ideal candidate should have a working knowledge of the latest Apache Camel version and the utilization of Spring DSL. Any prior experience with system integration projects would be an added advantage. Looking forward to receiving bids from capable professionals.
I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the ...
I am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently
We are looking for freelancers who could help us with a 4 week pilot in one of the grocery stores in Cincinnati area. You would be responsible for capturing data in the store with use of our iOS app. - This task will require visiting the same store on multiple days or even everyday in case you're available for 4 consecutive weeks. - work: 2-8h per day depending on your availability - Pilot start day: likely June 23rd. Before this date you would need to install the app, read the guidelines and visit the store for a few times for some app testing. - Most of the store visits would need to happen at 9AM More info to be provided in the private message Requirement: iPhone 11 or higher Store address: to be provided in...
...digital advertising company based in Israel, seeking a talented and creative freelancer to join our team. We need a skilled copywriter and designer to create compelling ad banners in English for various advertising campaigns. Responsibilities: Write engaging and persuasive copy for advertising banners. Design visually appealing and effective ad banners. Collaborate with our marketing team to ensure the ads align with our branding and campaign goals. Meet deadlines and manage multiple projects simultaneously. Requirements: Proven experience as a copywriter and banner designer. Strong portfolio showcasing previous work in advertising. Excellent command of the English language. Proficiency in design software such as Adobe Photosho...
