Split excel into multiple files based on columnงาน
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
I want translate English to Japanese 1 page within 1 hr.
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 am intending to develop a data flow network using Lingo as the programming language. The main focus of this project is to build a network that primarily caters to service providers. Key requirements for potential freelancers inclu...to develop a data flow network using Lingo as the programming language. The main focus of this project is to build a network that primarily caters to service providers. Key requirements for potential freelancers include: - Proficiency in Lingo - Proven experience in the creation of data flow networks - Strong understanding of the service providers' operational needs - Ability to execute tasks on time and to standard This exciting project is an excellent opportunity for tech-savvy minds who are keen to demonstrate their skills and problem-sol...
My Excel file is very heavy and unorganized. I want it to get cleaned and effecient
I am seeking the expertise of a creative and skilled designer to construct a silicone candle mold that is inspired by the characteristics of Roman columns. Major details that should be incorporated into the design include: - Roman column fluting details - The final candle should be large, more than 12 inches in size Ideal candidates for this project should have: - Knowledge of Roman architecture, specifically column designs - Experience in the creation of 3D models, particularly those intended for silicone molds - An understanding of the properties of silicone and how it works in mold-making - Previous work in candle mold design is a significant plus This project is an opportunity to combine historical architecture and functional design in a unique and artistic wa...
I'm looking for a developer who is well versed in API apps, Claude AI's API, and deploying chatbots on Wordpress websites. I have a comprehensive set of rules that work as a prompt in Claude to turn it into a game. The game functions well in Claude's environment, but I need it to be playable on the web. Possibly with ad serving capabilities so users can play for free Key Features: - Chatbot with (my already created) custom instructions, capable of having a back and forth conversation with users - ads or login feature for paid users in order to monetize Ideal Candidate: - Proficiency in using Claude API and Wordpress platform - Previous experience in building chatbots or chatbot games
I'm currently seeking an individual who is not only proficient in VHDL coding but also in Quartus design implementation. Key Responsibilities: - Work on specific tasks related to VHDL coding - Implement design using Quartus While the overall aim of the project and the timeline aren't specified yet, I am eager to work with someone who is flexible and can adapt as per project needs. The ideal candidate for this role should be based in Pakistan, knowledgeable in FPGA programming, dependable, efficient, and proactive when it comes to troubleshooting and problem-solving.
...platform. Key Requirements: - Implement a role-based system with three specific roles: Admin, Supervisor, and User. - For authentication, basic login functionality will suffice. - Admin roles should have the capability to manage users. - The Supervisor role should only have view-only access. Please note that the usage of frameworks such as Cake or Bootstrap are not allowed for this project. Ideal Candidate: - Extensive experience in Linux development. - Demonstrable experience in building role-based login systems. - Skilled in secure authentication practices. - Strong understanding of user roles and permissions. - Demonstrated ability to adhere strictly to project specifications. The resulting system is expected to grant user abilities based on speci...
If you are bidding on this project you will need to register at and watch our presentation so that you can understand the full scope of our project. Inside the presentation there is an animated segment on our marketing video that you must pay special attention to. Please mention the name of the main character in the explainer video so I know you watched it. Bids that failure to register and mention the character’s name will receive no reply. I am looking to build an automotive marketplace app that will have a range of features to make it user-friendly for both buyers and sellers. Key Features: - User registration and login, Search functionality, Listing creation and management - 24-7 Ai agents support, API integrations from multiple service providers - In ap...
I'm looking for a skilled professional to simulate & test of my microcontroller based hardware design, using proteus and test its performance. Also, if there is any performance bugs, need to correct it and also, build pcb prototype and physically test the performance
Fix edit not saved issue. Able to remove column create with js. Follow fix one by one issue. Work with ftp.
...designer who can create a modern and minimalist, text-based logo for my business. My brand is "Mine&". The logo should be text based and say "Mine & His". It has to be horizontal - It'll be on a website too, and has to sit well within a header bar. The "Mine" should resonate well with a female - Initially I'm thinking something for more cursive in nature. The & should just suit the logo The "His" should resonate well with a male, maybe more bold and masculine. Most importantly all words should look like they sit well with each other In regards to colours, at this stage I have no preference as to whether they should be different colours, or all 1 colour. I'll leave that up to the designers disc...
I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a d...
We are seeking a software developer to create a solution that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the d...
We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and consistently delivers top-notch content showcasing our milkbag character. These animations should be both original and influenced by popular memes, adding a distinct flair to each creation. Responsibilities: - Craft engaging Instagram Reels and animated content featuring our milkbag character. - Take the lead in brainstorming ideas and concepts for new animations. - Maintain a steady workflow to meet deadlines consistently. - Collaborate closely with our team to ensure the animations resonate with our brand and vision. Requirements: - Profi...
I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes
We're in need of a skilled freelancer to tackle multiple tasks related to our website. Primarily, we require mobile optimisation to ensure our site is user-friendly and visually appealing on all devices. Additionally, there's a need to adjust pictures to fit seamlessly within the mobile layout without sacrificing quality. Moreover, there are some repairs needed on the website, such as fixing broken links, resolving layout issues, and addressing any other issues impacting functionality and user experience.
...create a modern yet bold logo for my brand. This logo will be used across multiple platforms, including my website, print materials, and social media. Key Project Requirements: - Modern Design: I have a preference for a modern style, so the ability to create sleek, contemporary designs is crucial. - Bright & Bold Colors: The logo should incorporate bright and bold colors to make it eye-catching and memorable. - Versatile Use: The final design should be clear and impactful across various mediums, from digital to print. Ideal Skills and Experience: - Proven track record in modern logo design. - Strong understanding of color theory, particularly in using bright and bold colors effectively. - Experience in designing for multiple platforms, ensuring the logo remains clear...
We are seeking a software developer to create a solution that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the d...
...functionality on an existing application for both Android and iOS platforms. The key features of this intercom functionality should include: - Two-way audio communication - Capability to support multiple users It is crucial that the two-way audio communication works seamlessly across both Android and iOS devices. The security and encryption requirement for this communication is basic encryption. Ideal Skills and Experience: - Proven experience in developing apps for both Android and iOS platforms - Prior experience with intercom functionality - Knowledge in basic encryption - Strong understanding of audio communication systems - Ability to optimize functionality for seamless performance across different devices Please share your relevant experience, and any past project...
I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation
...and log in to the site. - User Profiles and Membership Levels: Each user should be able to create and manage their profiles. The system should support multiple membership levels for different types of users, such as consumers and business users. - Access Control and Content Restriction: Depending on their membership level, users should have access to different sections of the site, with content being restricted accordingly. - API Integration: I currently do not have an API set up for accessing data from WebFlow's MySQL. This will need to be implemented on the WebFlow side. - Data Import: I'm looking to import specific data from the API into the WebFlow site. This includes membership level information and orders submitted. Ideal candidates for this ...
...site will offer features such as real-time messaging, file sharing, and group chat, enhancing communication and interaction among users. I also need a payment system integrated that accommodates credit card payments. Experience in creating websites with diverse user roles, building interactive communication features, and integrating secure payment gateways is required. Key Requirements: - Multiple User Roles: You should have experience building platforms that cater to a variety of users (students, teachers, parents). - Real-Time Messaging & File Sharing: Proven proficiency in coding real-time messaging and file sharing features is crucial, including group chat. - Payments: Experience with credit card payment integration is essential. The main objective is to create a...
...differentiated roles for administrators and standard users, each with a tailored dashboard. The platforms I'd like the application to be available on include: - Web Application - iOS App - Android App An important element of the application will be to incorporate comprehensive event management features. This will include: - User Registration: The application should allow for the registration of users with social login (google, X, facebook, linkedin) and verification mail. - Standard User profile definition with a set of info (Name, Surname, Photo, Address …..), selection of services thy are able to provide (multichoice from a list) e their availability (multichoice on 10 dates) - Event Registration: The application should allow for the registration of events....
...compiling reports and presentations, and providing general backend support. The role requires the ability to juggle multiple concurrent tasks and thrive in a fast-paced environment. Effective communication and interpersonal skills are a must to interface with both internal and external stakeholders. The virtual assistant will work closely with the managing director and other staff to streamline operations, identify growth opportunities, and ensure a superior customer experience. Remote working arrangement with occasional site visits to Buckinghamshire as required. This is an excellent opportunity for a highly organised and solutions-oriented virtual assistant seeking to take on expanded responsibilities and make a meaningful impact within a growing small business. The...
I'm in need of a large 24x36 inches family portrait illustration that looks like an impressionistic painting. The piece is unique in that I'm looking to merge all the family members into one image. This is particularly important as some of the family members have passed away. The illustration should still be recognisable as each individual but seamlessly integrated into the unified whole. Ideal skills for this job: - Proficiency in Impressionistic style of painting - Experience in creating large format illustrations - Ability to merge multiple subjects into a single harmonious composition - Sensitivity and understanding of the emotional significance of this project I have labeled grandmother, grandfather children Tyrone (children twins Ari and Ady)...
I'm looking for a skilled app developer to design a cross-platform application for both iOS and Android. Key Features: * Social Media Integration: Users should be able to sign-in with their social media accounts and share updates on multiple platforms simultaneously. * In-App Purchases: The application should have a feature that allows users to purchase premium content from within the app. * Real-Time Updates: The app should deliver real-time notifications and updates, ensuring swift communication. Primary Purpose: The primary purpose of the app is social networking. It should promote interaction and engagement between users. Skills and Experience: The ideal candidate should have experience in cross-platform app development, particularly iOS and Android. Social med...
I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this ro...
I've run into a problem with my WordPress PWA plugin. Even though I've enabled the "Add To Home Screen" feature, it's not showing up when tested on mobile devices and tablets. The issue seems prevalent on both Android and iOS platforms. The perfect candidate to assist in this project would have: • Expertise in WordPress and PWA plugins • Proficient troubleshooting skills for addressing platform-specific challenges on Android and iOS • Experience in customizing PWA plugin settings to ensure optimal functionality. The goal is a seamless implementation of the "Add To Home Screen" feature across multiple device platforms. Your input and expertise are greatly valued in fixing this issue. Let's make t...
