Excel macro match databaseงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.
...developer to provide a ready-made webtrader platform for Forex CFD Trading integration into my website. It should cater to an efficient and user-friendly trading experience. Key features must include: - Real-time market data - Charting and technical analysis tools - One-click trading In addition, the platform needs to be integrated with payment gateways and have a customizable user interface to match my website's aesthetic. Whoever takes on this project should possess a deep understanding of Forex trading software and web integration techniques. The ability to make third-party integrations is crucial. While 24/7 support and maintenance isn't necessary right now, please outline your availability and turnaround times for potential future issues. If you have prior exper...
I'm looking for a talented recruiter who's capable of identifying and hiring any-level in any industry. Key Responsibilities: - Identify and approach potential cand...capable of identifying and hiring any-level in any industry. Key Responsibilities: - Identify and approach potential candidates. - Screen candidates through interviews and background checks. - Match candidates with the right job opportunities. - Coordinate with hiring managers to understand job requirements. Ideal Candidate: - Proven experience in recruiting mid-level professionals across diverse industries. - Strong networking and communication skills. - Familiarity with applicant tracking systems. - Adept at evaluating candidate skills and experience. - Able to understand job requirements and match...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I am seeking a skilful Photoshop expert to introduce more trees to an image of a mound adorned with arborvitae along my property line. This task specifically entails: - Adding trees to the existing mound - The species of these additional trees should match the existing ones on the mound - The placement of these trees should be random, creating a natural and visually appealing look. The ideal freelancer should be proficient in Adobe Photoshop with a keen eye for the natural lay of landscapes and aesthetic presentation. Experience in architecture or landscaping designs would also be beneficial. I require absolute precision and attention to detail to ensure the added trees blend seamlessly with the existing environment.
... Sunny Side Surplus. Here's what I'm looking for in the logo: - **Color Scheme**: Primarily yellow with any additional elements that can bring out the sunny and playful theme. - **Style**: A blend of playful and modern design elements is what I'm envisioning, so bringing your own creative flair to this would be much appreciated. - **Imagery**: The design should definitely incorporate a sun to match the brand's name and the associated positive, upbeat connotations. Ideal skills/experience for this job: - Proven track record in creating unique and memorable logos - Proficiency in blending different styles to create a fresh design - Strong understanding of color psychology and its application in branding - Ability to listen to client requirements and translate ...
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I need a web designer to have my website within the right theme, to match my main page pictures. WordPress. I'm seeking a skilled web designer to create a portfolio website that primarily showcases written content. The theme of the site should aesthetically align with the main page images. Here's what I am ideally looking for: - Strong understanding and experience in graphic and web design. - Experience with portfolio web design, preferably with writer portfolios. - Intuitiveness and creativity in matching site aesthetics to given image themes. - Solid grasp of user experience to ensure optimal site navigation. The purpose of this website is to professionally showcase my written work. The design should therefore make it easy for site visitors to access, read, and eng...
...designer to recreate a existing logo from a PNG file. The goal is to have the logo look completely identical but with editable text. It is critical that no design elements are changed and the colour scheme remains identical. If you are experienced in creating logos with editable text and have an eye for detail, this project is for you. Please note that I do not have the font file for the text, so a match will need to be found or a very similar looking font used. Please start your bid with "Celebrate little victories", otherwise it will be ignored. You will have to deliver the final version of the logo in an editable format (.ai, .psd or .cdr), all the fonts used in the design, the final palette with hexadecimal codes as well as printable files. We will select a bid...
...lugin-apply ../../../../../.pub-cache/hosted/:60:19: Error: No named parameter with the name 'primary'. primary: (), ^^^^^^^ ../../../../../dev/flutter/packages/flutter/lib/src/material/:22: Context: Found this candidate, but the arguments don't match. static ButtonStyle styleFrom({ ^^^^^^^^^ Target kernel_snapshot failed: Exception FAILURE: Build failed with an exception. * Where: Script '/home/beemo/dev/flutter/packages/flutter_tools/gradle/src/main/groovy/' line: 1419 * What went wrong: Execution failed for task ':app:compileFlutterBuildDebug'. > Process 'command '/home/beemo/dev/flutter/bin/flutter''
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm in need of a skilled designer for our YouTube channel. Your task is to create visually appealing green screen templates. The goal is to enhance the visual quality of our interview videos. Key requirements: - Professional & Sleek: The templates should match the channel's theme of professionalism and sleekness. - Subtle & Integrated: The handling of text and graphics should be subtle and integrated, without overpowering the video content. Ideal skills and experience: - Proficiency in green screen design - Prior experience in creating templates for YouTube or similar platforms - Ability to understand and work with a professional and sleek design style - Expertise in subtle and integrated text and graphic placement Your work will play a critical role in enhancin...
I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...
Our goal is to develop a Reactive Web App that would help match care-providers with care-seekers (similar to what SitterCity does). We have requirements specs that we can provide to help get started on the project. The App must have web and mobile user authentication, as well as e-commerce integration and social media integration. For the e-commerce aspect, we would need features like checkout, payment processing, billing, etc. The social media integration should include features like logging in using social accounts, etc. We’re looking for in-depth knowledge of Web App development process, someone who can develop efficiently and according to our design specifications. Experience with creating an App with similar functionalities is a major plus. Building must be done with late...
I'm a painter, interior and fashion designer with a substantial following on Instagram. While my Content Qualit...it. This will involve implementing a range of engagement strategies that are both interactive and interesting. Key Requirements: - Proven experience in increasing Instagram Engagement Rates and followers - A good understanding of art and design and its audience on Instagram - Creative and thoughtful approach to interaction and storytelling - Ability to work with me to develop strategies that match my style and goals While I haven't selected specific strategies from the list, I'm open to your suggestions and expertise. This could involve Instagram Stories, Polls, Quizzes, Collaborations, or other innovative approaches. Let me know how you would approach ...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I need to make a new version of the enclosed little explainer graphic. The changes must be: - Colors and style match better with our flyer - Easier to see the text - following points added (arrow can be to left side of the product): - No electricity needed - installed in 4 minutes As base you must use the photo of the product where the hose is grey - which is also enclosed. If you feel you need to understand the product better before you do this - have a look at our video: I need this in sufficient resolution to use both in print and online.
I'm looking for a skilled digital artist or graphic designer to modify an image of a motor. Current needs are: - Change the color of the motor: Currently the motor's outer color is blue, which I need changed to a specific shade of green - RGB: 102, 174, 86. Being able to accurately match the exact color specified is paramount. - Extend the wires: The motor has a group of wires and only part of them extend across the motor. I need all of these to extended so they run completely across the motor, maintaining the same thickness as the existing wires. The final image is required to be delivered in the PNG format. The successful freelancer will have skills in image editing and graphic design, with a keen eye for detail to ensure color and wire thickness accuracy. Experien...
