Vba database optimizeงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I'm seeking a comprehensive solution to track and analyze your basketball team's performance data. I need a robust and beautiful Power BI matrix designed specifically for basketball coaches and trainers to efficiently manage player data and optimize performance strategies. Key Features: 1. **Data Input and Management:** Easily input and manage player data including RPE (Rate of Perceived Exertion), wellness readiness, workload monitoring, games played, minutes played, training sessions attended, injuries, match statistics, and performance metrics such as height, weight, body composition, vertical jump, hot zone shooting, bench press repetitions etc 2. **Organization and Visualization:** With Power BI's intuitive interface, all player data is systematically orga...
I'm looking for an expert in setting up a Kannel SMS Gateway with a SIM box. The purpose of this project is to send marketing messages on a large scale of betwe...text-only, they will include both images and links as well. Ideal Skills: - Extensive experience with Kannel SMS gateway and SIM box configuration - Understanding of marketing message composition with text, image, and link - Knowledge of Bulk SMS sending Key Requirements: - Ability to send between 1,000 and 5,000 SMS daily - Ensure efficient delivery of all text, image, and link content - Optimize the system while maintaining high deliverability rates Your ability to effectively set this up can make a huge difference in our communication strategy. If these parameters accomplish what you can deliver, I am eager to...
Please apply only if you can start immediately Based on the information provided, it appears you're seeking expert assistance in creating an AWS (Amazon Web Services) solution. While the project details are not specified, the potential scope of the project could involve various AWS services such as EC2, S3, and Lambda. This suggests a focus on cloud computing services to develop and potentially optimize a solution for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They ...
I'm looking for a freelancer to assist me with data input tasks. The data to be inputted is sourced online, and it must be accurately and efficiently inputted into our system. Following data entry, the data will be used to update our database. Data Type: - Images - Text Requirements: - Min. 200 Full Described Entities per Week - Proficient in data input, especially sourcing from online databases - Skilled in database updating - Attention to detail to ensure data accuracy - Efficient and timely completion of tasks - Previous experience in similar roles would be beneficial
Please apply only if you can start immediately Based on the information provided, it appears you're seeking expert assistance in creating an AWS (Amazon Web Services) solution. While the project details are not specified, the potential scope of the project could involve various AWS services such as EC2, S3, and Lambda. This suggests a focus on cloud computing services to develop and potentially optimize a solution for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They ...
...profits from the store. Responsibilities: Product Selection: Utilize your expertise to choose products or categories that maximize profit. Your ability to identify and promote high-converting products is crucial. Store Design: Create a visually appealing and user-friendly layout for the store. A clean and minimalistic design is preferred to align with the aesthetic. Traffic Generation: Manage and optimize Search Engine Optimization (SEO) strategies to drive consistent and quality traffic to the store. Ideal Skills and Experience: Proven experience managing Amazon Affiliate Stores and driving growth. Strong understanding of SEO and its application in e-commerce. Proficiency in store design, particularly with a clean and minimalistic approach. A track record of successful produc...
I'm looking for a skilled professional to enhance my Google My Business profile. Key Responsibilities: - Ensure my phone number and business hours are correctly displayed. - Recommend and implement additional information that will benefit my business. Ideal Skills/Experience: - Experience in setting up and optimizing Google My Business profiles. - Knowledge of strategies to increase local search visibility. - Ability to enhance customer engagement. - Expertise in collecting and managing reviews.
Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.
I need an e-commerce website built on Shopify with a budget ranging from $500 - $1000. The website should target young adults aged 18-34, and will be selling a variety of products, primarily in the ...gateway integration - Mobile optimization Ideal skills and experience for this job: - Proficiency in Shopify development - Understanding of e-commerce and online consumer behavior, particularly for young adults - UI/UX design skills for an engaging e-commerce experience - Knowledge of product categorization and listing optimization - Prior experience with payment gateway integration - Ability to optimize the website for mobile devices Please provide examples of similar e-commerce websites you have built on Shopify, and a clear breakdown of your proposed approach and timeline for thi...
...ingenious web application using Angular + Laravel. Your primary task would be the initial creation of the application, yet this could potentially extend to long-term support. Key Responsibilities: - Create a robust, scalable, and highly interactive web application. - Develop efficient and reusable code that drives complex web applications. - Maintain a deep understanding of Angular + Laravel to optimize application capabilities. Ideal Skills & Experience: - Advanced proficiency in Angular + Laravel development. - Proven record of building highly interactive web applications. - Understanding of user roles for a web app is preferable. - Skilled in troubleshooting and improving existing and in-development applications. Time Frame: Since there were no specific answe...
I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: token refresh functionality ignore battery optimize permission run at startups functionality UI change 2 new api's refactor code for easier maintenance currently displayes persistent notification dont want it Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous relevant work.
I have a CS-Cart Multi-Vendor site that experienced a severe breakdown following a failed upgrade. This has led to a range of issues from broken layout to persistent error messages. Additionally, after the failed upgrade, the database is out of sync. The site needs urgent attention to get it back on track. Your primary role on this project will be: - Debug and fix the bad upgrade: This includes addressing the broken layout, error messages, and the out-of-sync database issue. - Server Configuration & Security Audit: Given that I've made changes to the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optim...
Looking for a seasoned SEO expert who can effectively optimize the on-page SEO for my built website. In the application, kindly include: • Examples of your past work, particularly highlighting website projects built with you’ve worked on. Ideal skills and experience: - Solid understanding of and SEO techniques - Extensive background in on-page SEO best practices - Good eye for detail in identifying SEO opportunities within a website structure.
I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular ...Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to suggest...
I need a Google Ads expert to set up and optimize Analytics 4 and AdWords campaigns for my online sales site. Key Requirements: - Proficiency in setting up and optimizing Google Analytics 4 and AdWords campaigns. - Proven track record in increasing website traffic and boosting online sales through successful campaign management. - Deep understanding of online consumer behavior and preferences for effective targeting. Please tailor your bid to reflect your relevant experience and expertise in these areas.
I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal cand...is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execut...
...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 without disrupting existing functionalities. Key Featu...
...email campaigns? Join our team to create personalized email marketing strategies that convert leads into loyal customers. E-Commerce Marketing Maven: Do you have a knack for driving sales in the e-commerce space? Join us to develop innovative e-commerce marketing strategies that drive revenue and growth. SEM/PPC Pro: Are you an expert in pay-per-click advertising? Join our team to manage and optimize PPC campaigns that deliver measurable results and ROI for our clients. Paid Advertising Aficionado: Are you experienced in managing paid advertising campaigns across various platforms? Join us to plan and execute paid advertising strategies that effectively target and acquire customers while maximizing ROI Requirements: Proven experience and expertise in your respective field o...
I'm in need of an experienced web designer to overhaul my website's outdated look and slow loading speed, while keeping it professional and authoritative. Key Requirements: - Address the outdated design by implementing modern and sleek design elements. - Optimize the site for faster loading speed. - Maintain a professional and authoritative look, aligning with my brand's personality. Ideal Skills: - Proven experience in redesigning websites with a focus on improving brand awareness. - Strong web design skills, with a keen eye for modern and sleek design elements. - Proficiency in optimizing websites for faster loading speed. Please include samples of your previous work in your proposal. I look forward to working with a talented designer who can transform my website...
I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: token refresh functionality ignore battery optimize permission run at startups functionality UI change 2 new api's refactor code for easier maintenance currently displayes persistent notification dont want it Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous relevant work.
I'm looking for a skilled DevOps Engineer experienced in AWS to help design a robust architecture for my Spark and Sagemaker Machine Learning models. Key Requirements: - **AWS Services**: Your primary focus will be...for the Machine Learning models. Ideal Skills: - Experience with Amazon S3 and Amazon Sagemaker are a must. - Proficiency in Python and R for fine-tuning or troubleshooting the models. - Familiarity with designing architectures for batch predictions and model training/retraining. - Strong understanding of DevOps principles and AWS best practices. I'm looking for a professional who can help me optimize the performance of my models while ensuring the scalability and reliability of the architecture. If you have a proven track record in similar projects, I'...
I'm seeking an experienced website designer to create an e-commerce platform for my bu...items. Key Project Elements: - An intuitive and attractive product listing and description feature, ensuring our customers can easily browse and understand our offerings. - A user-friendly and secure shopping system, giving clients confidence in their purchases. Ideal Skills Required: - Experience in web design, ideally with a portfolio of e-commerce sites. - Knowledge of SEO best practices to optimize product visibility. - Strong graphic design ability to ensure the site is visually appealing. - Experience in creating user-friendly interfaces for easy navigation. I'm excited to bring this project to life, and I look forward to hearing from designers who feel they could be the righ...
My website, , requires a thorough SEO overhaul as we aim for increased website traffic. You will be working on optimizing up to 50 keywords across Google, Bing, and Yahoo. Your tasks will entail: - On-page SEO Optimization: Enhance content quality, use relevant keywords, streamline site navigation, optimize metadata, and improve site speed. - Off-page SEO Optimization: Build high-quality backlinks, manage local listings, create engaging guest posts, and monitor social media mentions. The ideal freelancer should have a successful track record in delivering both on-page and off-page SEO strategies. I'm looking for data-driven individuals who have helped previous clients improve website visibility and increase website traffic. Proficiency in using SEO tools like Semrush
We are seeking a motivated and enthusiastic SEO Intern to join our team. This is an excellent opportunity for someone who is passionate about digital marketing and eager to gain hands-on experience in search engine optimization. Responsibilities: Assist in keyword research and analysis to identify new opportunities for content optimization Help optimize website content, including writing meta tags, meta descriptions, and optimizing on-page elements Support link building efforts by researching and identifying potential link opportunities Monitor and report on website performance using tools such as Google Analytics and Google Search Console Stay up-to-date with the latest trends and best practices in SEO and digital marketing Collaborate with team members on various SEO initiatives...
I'm seeking a Laravel developer who can integrate Dialogflow with my Laravel 7 application. Key Requirements: - The primary goal of the integration is to automate responses for user inquiri...account and project from scratch as I haven't done this yet. Your experience in Dialogflow will be instrumental in ensuring that the setup is seamless and optimized for my application's needs. Ideal Skills: - Proficiency in Laravel 7 or 8 - Extensive experience in Dialogflow, including setting up accounts and projects - Strong understanding of automation and how DialogFlow can be leveraged to optimize user inquiries I'm looking for a proactive and skilled developer who can efficiently handle this integration and ensure that the automation of responses works seamlessly wi...
...other changes necessary to achieve the >60% conversion target. A reference listing is: Ideal candidates will have experience in graphic design, copywriting and a good understanding of how to optimize the Google Play Store's listing requirements. An understanding of or background in South Asian classical music would be a bonus. Please only put forward a proposal if you are sure that you will be able to achieve a store listing conversion rate of >60%. If you are selected, your suggested changes will be made live on the Google Play Store and payment will only be made if the target is consistently
...charts, infographics, and tailored branding elements. Responsibilities: • Design visually appealing graphics that align with our brand identity. • Create detailed infographics that highlight product benefits and features. • Develop comparison charts to differentiate our products from competitors. • Work with our marketing team to ensure the content aligns with our promotional strategies. • Optimize content for mobile and desktop viewing to ensure a seamless customer experience. Requirements: • Proven experience in graphic design, specifically with e-commerce platforms like Amazon. • Strong portfolio showcasing expertise in digital content creation. • Excellent communication skills and responsiveness. • Ability to work to t...
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 ...
I'm in need of an experienced PPC specialist to help me generate leads for my business. The project will involve leveraging Google and Facebook Ads to target a broad audience within the age range of 18-44. Key Responsibilities: - Develop and execute PPC strategies to drive lead generation. - Optimize Google and Facebook Ads for maximum lead conversions. - Monitor campaign performance and identify opportunities for improvement. Skills and Experience: - Proven track record of successful lead generation through PPC campaigns. - Expertise in Google and Facebook Ads platforms. - Proficient in audience targeting, ad optimization, and campaign management. - Strong analytical skills to interpret campaign data and make data-driven decisions. Your goal will be to drive high quality ...
As a dedicated Amazon seller, my primary objective is to significantly boost my sales. To achieve this, I believe I need expert assistance in enhancing my inventory management. It's vital to underscore that my priority area is improving the SEO of my product listings - a mission-critical aspect of gaining visibility amongst the plethora of products on Amazon. Key Focus Areas: 1. **High-Quality Product Imaging:** A picture is worth a thousand words and, in the ecommerce space, it's worth more. The images should be sharp, well lit and from multiple angles to provide a comprehensive view of the product. 2. **Detailed Product Descriptions:** The descriptions need to be comprehensive and compelling, highlighting the key features and benefits of the product while simultaneously bein...
I am looking for a YouTube expert who can help optimize my YouTube channel and track the analytics. Key Responsibilities: - Channel Optimization: You should be able to maximize the visibility and appeal of my channel. This includes improving the channel's aesthetics, metadata, and overall structure. - Analytics Tracking: Your expertise in tracking the channel's analytics is crucial. You will be responsible for analyzing the performance data and identifying areas for improvement. Requirements: - Experience in YouTube channel optimization and analytics tracking. - Proven track record of boosting video views. - Strong understanding of YouTube's algorithms and best practices. Ideal Candidate: - A YouTube expert with a history of successful channel optimization and anal...
I'm looking for an expert in EA (Expert Advisor) to optimize the performance of my current EA system. In particular, I'm interested in: - Enhancing the trading algorithm: You should have a profound understanding of trading algorithms, as this task will require you to optimize my EA's functionality substantially. - Implementing better risk management: Your work should focus on improving the risk management aspect of the trading algorithm. This means you have extensive experience with risk analysis and how it's applied in trading algorithms. Having background knowledge in finance would be beneficial for this task but isn't necessary. However, strong analytical abilities, problem-solving skills, and an eye for detail are a must. Bring your expertis...
We are a home furniture customization supplier, and we need an SEO expert to help us optimize our website to get more customers and let them find us.
We are a home furniture customization supplier, and we need an SEO expert to help us optimize our website to get more customers and let them find us.
I have a website which requires a better pagespeed score. Right now its on 30 score for mobile and 60 for desktop. I want this to be 100 for both. Need someone that can do this with me either by modifying the website page or with plugins. I have some plugins installed but could not increase the score. Link will be shared in a seperate chat
I am looking for a skilled social media expert to manage my advertising campaigns on Facebook and Instagram. The primary goal of these campaigns is to significantly boost our sales and conversions. Key Responsibilities: - Strategize and execute targeted ad campaigns on Facebook and Instagram - Optimize campaigns to increase conversions and sales - Regularly monitor and report on the performance of the ads Ideal Candidate: - Previous experience in managing successful social media ad campaigns, particularly on Facebook and Instagram - Strong understanding of conversion optimization techniques - Familiarity with targeting professionals aged 25-40 - Analytical skills to assess and improve campaign performance Please provide a portfolio of your previous work and any relevant qualifica...
Seeking a highly skilled .Net Developer to upgrade the existing system's back-end, ensuring it's user-friendly and solid. Key requirements: - Enhance system navigation and ease of use. - Optimize system performance for heightened stability. - Bolster security features for increased protection. The revamped system should be able to integrate with current mobile applications seamlessly. While specific app functionalities have not been defined, the developer should have prior experience with real-time data synchronization, push notifications, and user authentication. In terms of project timeline, the expectation is for this to be completed within a month. Ideal Skills: - Extensive experience with .Net Development - Prior experience with system optimization and security e...
I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.
I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. ...the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating product databases will be a major advantage. Let’s ...
...help me create a new E-commerce website with 10 products. The chosen platform should be WordPress, and the site should utilize WooCommerce, Yoast SEO, and WPForms. Key requirements include: - Developing a professional and user-friendly E-commerce website - Customizing the Avada theme to align with the brand - Integrating WooCommerce for product listings and sales - Implementing Yoast SEO to optimize the site for search engines - Setting up WPForms for forms and lead capturing. The ideal candidate should have: - Proven experience in E-commerce website development on WordPress - Strong understanding of WooCommerce, Yoast SEO, and WPForms - Familiarity with the Avada theme is a plus - Ability to create a responsive and visually appealing website - Good communication skills and th...
I'm seeking a skilled developer to create an informational website primarily serving to present company i...development, particularly with informational websites, and understanding in creating user-friendly contact forms and detailed product/services pages. Proficiency in UI/UX design is an added advantage to ensure user-friendly design and navigation. Proven portfolio showcasing similar projects required. The focus here is not just a fully functional site, but also one with an engaging, intuitive design to optimize visitor experience and interaction. The look and feel should be of a professional nature, appealing to corporate customers. Our services are IT related in the finance field. Once the website is hosted, we want to be able to update it ourselves with new content fro...
I am in need of an expert in digital advertising, s...eye-catching display ads to attract potential customers and generate leads. - Experience with lead generation: It's important that the freelancer understands the fundamentals of lead generation and can tailor the ad content to achieve this goal. - Proficiency with Newspaper Advertising: As the ads are to run on Newspaper, the professional must have experience with this platform and be able to optimize the ad content effectively. Ideal Skills and Experience: - Proven track record in digital advertising, particularly in display ads. - Understanding of lead generation and how to translate that into effective ad content. - Experience with Newspaper advertising, and the ability to make the ad content engaging and optimized for...
