Vba loadPekerjaan
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first closes...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
...Interactive Call to Action (CTA): Incorporate engaging CTAs strategically placed throughout the website to encourage user interaction. Use compelling language and design elements to prompt visitors to take desired actions, such as applying for programs or exploring further information. Consider implementing hover effects, animated buttons, or interactive forms to enhance user engagement. Website easy to load: Optimize website loading speed by minimizing unnecessary elements, compressing images, and leveraging browser caching. Use efficient coding practices and consider utilizing content delivery networks (CDNs) to ensure quick delivery of website assets. Prioritize content loading to display essential information first, enhancing user experience. Main Front Page: which takes yo...
As a growing tech-based firm, we are eager to enhance our application's performance by employing AWS EC2's auto scaling feature. Our current system primarily involves using EC2 services. However, we are witnessing a s... - AWS EC2 services and how to maximize CPU usage. - Implementing AWS EC2’s auto scaling feature. The ideal candidate for this task will have: - Demonstrable experience in AWS EC2's auto scaling and optimizing CPU resource utilization. - Expertise in monitoring and interpreting CPU utilization metrics. - Experience in increasing application performance through auto scaling. - Understanding of load balancing and stress management on AWS platforms. We're excited to hear how you can help our application perform better, run smoother, and de...
I have a AWS Infrastructure setup project requiring expertise in Cloudfront NLB and protection using WAF. As the goal is targeted at content distribution and load balancing, proficiency in these areas is crucial. Some of the AWS services required are Amazon EC2, ELB, Cloudfront and Amazon S3. Familiarity with these services is crucial for a successful project. *** The main point to address is that I want end user to access website on EC2 IIS with custom ports like 8080, 5440 etc and not standard 80 or 443. User will be providing url with port number and on IIS different website is binded with different port number. For WAF, protective measures against DDoS attacks, SQL injections, and XSS attacks are necessary. Thus, an understanding of these areas is also needed. Skills and exp...
Seeking expertise in logistics and optimization to address a challenge in vehicle routing with time windows. As a company with an undetermined number of vehicles and undefined load capacity, I need a flexible solution that can adapt to varying conditions. The ultimate goal is to develop a strategy that optimizes routes given certain time constraints. Key tasks: - Determine the best utilization of an undetermined number of vehicles - Develop an adaptable model that takes vehicle load capacity into consideration - Design a method that respects and optimizes time windows for each delivery Ideal candidate: - Proven experience in logistics - Strong skills in mathematical modeling and optimization - Confident problem solver with capacity to build versatile solutions This project...
Seeking a Java developer to work on a dynamic project that needs some feature enhancement and functionality modification. The project requires: I have a Java script and all of the coding is in the .Jar file. It's a simple script that access a trucking site and continuously search for particular load via a filter. I want to add a couple more searches and add a notification feature
...purposed for delivery on tile flooring. Key requirements: -Scanning: The robot needs to be able to scan a QR code and deliver it’s contents to the matching QR code room. - Focus: The robot's main role will be to deliver items, not exceeding 5 kilograms, over tile flooring. - Terrain navigation: The robot should be able to smoothly and efficiently navigate on tile floors without any assistance. - Load capability: The designed robot must sustain a maximum weight up to 5 kilograms without affecting its performance. The ideal freelancer will possess significant experience in robotics, specifically in autonomous robots. A solid understanding of weight bearing technology and navigational systems for flat terrains, is crucial. Your experience will matter as much as your ...
...appointments with previous customers using marketing techniques and AI technology. The platform will allow for the automated or manual entry of customer data from an existing database, facilitating direct and automated interaction across multiple communication channels such as WhatsApp, Telegram, email, and SMS. The objective is to schedule an appointment Key Features: Data Importation: Ability to load customer data automatically in batches or enter it manually. Communication Connectors: Utilize existing connectors and develop new ones to integrate channels like WhatsApp, Telegram, email, and Google Calendar management. Automated Interaction: Develop an AI using language models (LLM) to interact with customers, applying marketing techniques to maximize re-engagement...
I need an Excel template...orders. Key Features: - Advanced Formulas & Conditional Formatting: I require this to ensure the template is robust and can visualize data effectively. - Data Points Tracking: I need the template to include sections tracking: - Product names and categories - Customer names and contact details - Delivery dates and quantities - Profits and balances on Purchase Orders (POs) - Daily load outs reports The ideal freelancer for this job should have: - Proficiency in Excel, with extensive experience in creating advanced templates with conditional formatting. - A good understanding of business processes, especially in sales, deliveries, and inventory management. - Excellent communication skills to ensure the template meets the specific needs o...
...updated, and have high ratings for performance and security. Avoid using outdated or unsupported plugins. 2. Performance Optimization 2.1 - Implement a robust caching strategy using a reputable caching plugin to reduce server load and speed up page loading times. 2.2 - Ensure all images are optimized for the web without compromising quality. Use tools or plugins to automate image compression. 2.3 - Minify CSS, JavaScript, and HTML to reduce file sizes and improve loading times. Ensure the theme and plugins do not add excessive bloat. 2.4 - Use a CDN to distribute the load, reduce latency, and improve the speed of content delivery globally. 2.5 - Regularly clean the database to remove unnecessary data and keep the website running smoothly. 3. Security Measures 3.1 - Imple...
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowled...
...Data Updates:** We need to enhance our software's current CRUD operations and introduce real-time data updates. You should be experienced in handling these functionalities with Vue.js and Laravel. - **Search Bar Enhancement:** We're keen on revamping our search bar. The new design should include: - Autocomplete suggestions. - Prompting automatic cursor placement on the search bar upon page load. This is essential for user convenience. - **User-Friendly Interface & Third-Party API Integration:** Besides the search bar, we also need your expertise to improve our software's user interface design and integrate it with third-party APIs. Your main goal in this project will be to enhance the software's usability and make it more efficient. The ideal cand...
...three shown. See figma: (Copy)?type=design&node-id=206%3A2&mode=design&t=FF4CG64iJFrgALzd-1 I have made the backend APIs, so you will not need to do anything in the backend. I will share postman and specific instructions on how to use. Note that the model on the right will be supplied as a gltf file, you will need to use gltf loader to load it, orbitcontrols to show it around and some clean up. Home page is a basic landing page, I will provide source code, you need to make sure auth works with google (provided) and able to integrate with the app page. You can check out to see how it looks like. The end goal is to deploy on Netlify with the updated website. I expect you can push it to vercel for me to quickly give
Description I am looking to work with someone who can design the electrical system for a web take-up and vacuum conveyor system. Currently, each product line and the waste web comes off the printer and falls into a tray for the operator to sort i...the roll onto the bed and the take-up, and letting the machine do the rest. The web will travel along the cutting belt, onto the vacuum conveyor, the waste material is then extracted onto a take-up and the finished stickers travel down the vacuum conveyor to a bagging station. The initial take-up design consists of the web feeding through a load cell and onto the take-up mandrel fixed to a motor. I require someone who can produce an electrical load list, cable sizing, breaker sizing and finally, produce a wiring diagram for al...
Silakan Daftar atau Login tuntuk melihat rincian.
...linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macr...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
Silakan Daftar atau Login tuntuk melihat rincian.
I'm looking for a skilled developer to create a React component that can load SCORM packages and interact with users. Key requirements: - The component should be able to load SCORM 1.2 and 2004 packages - It should be compatible with iSpring exported packages - It should listen and store all the events to an API - It should store the suspend data and resume the last state of the user - It should track the same events as on scorm debugger We will provide package examples that should be compatible
I am having several issues with my Wordpress websit, Elementor-based website hosted on Hostinger. The problems include slow loading time, high page size, and slow server re...current loading time of the website is more than 4 seconds, significantly slower than ideal. I am seeking a freelancer who can work on these issues and enhance the performance to make my website load faster. The ideal candidate should have proven experience in: - Wordpress - Elementor - Web Optimization - Understanding of high-quality images and video optimization - Knowledge of reducing page size and server response time. I expect the freelancer to provide a detailed plan of action and also explain their step-by-step approach to solve these issues. The end goal is to optimize my website to load in les...
I am in need of an experienced individual who can assist in calculating the electrical load for a commercial facility. Key Requirements: - The primary application of the load calculation is for a commercial facility. Task Details: - The calculation must be comprehensive, covering the electrical load for the entire service panel. Ideal Skills and Experience: - Proven experience in conducting electrical load calculations. - Proficiency in handling load calculations for commercial facilities. - Strong understanding of electrical systems and components. - Familiarity with the electrical requirements specific to commercial buildings. The individual must be able to provide accurate and thorough calculations, ensuring that the electrical system is capable o...
I'm looking for help speeding up the load time of my WordPress website, which currently takes between 3-5 seconds to load. The most critical area to focus on is the home page. I'm unsure which elements or features are causing the delay, so part of this project would be diagnosing that potential issue. Ideal candidates would be experienced in WordPress, website optimization, and able to perform diagnostic tests to identify problems. An understanding of how to make a website still look engaging while operating faster is also necessary. I need performance score in Green for mobile and desktop both on
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I'm in search of a proficient professional to take care of my website's maintenance and SEO needs. - Website Maintenance: The tasks will involve updating content, fixing broken links, and optimizing page load speed. I expect the content to be updated on a monthly basis. - SEO Strategies: I'm interested in a comprehensive SEO strategy. This will include keyword research and optimization, building backlinks, and crafting SEO content. - Suggestions on how to improve website performance. - This would be ongoing for the right person. Ideal candidates for this project should have: - Proven experience in website maintenance and SEO - Strong knowledge of content management systems - Understanding of on-page and off-page SEO techniques - Excellent communication and proj...
I need an Excel macro develop...Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...
Hello, Currently, the loading time is excessively long, taking approximately 7 seconds to fully display pages. This sluggishness negatively impacts user experience and compromises the overall performance of the site. Here are some key details about the site: Platform: WordPress Number of active plugins: 17 Security: Using Sucuri for site protection and cleanup Number of pages: Over 2000 Hosting: VPS at OVH RAM usage: 95% Note: The use of WP Rocket has been excluded due to past issues. Actions already taken to optimize the site: Image optimization with Imagify Implementation of lazy loading Cache setup (requiring revision) I expect the proposed freelancer to be able to: Offer concrete solutions to optimize loading speed, taking into account the current site configuration. Provide exp...
...Data Updates:** We need to enhance our software's current CRUD operations and introduce real-time data updates. You should be experienced in handling these functionalities with Vue.js and Laravel. - **Search Bar Enhancement:** We're keen on revamping our search bar. The new design should include: - Autocomplete suggestions. - Prompting automatic cursor placement on the search bar upon page load. This is essential for user convenience. - **User-Friendly Interface & Third-Party API Integration:** Besides the search bar, we also need your expertise to improve our software's user interface design and integrate it with third-party APIs. Your main goal in this project will be to enhance the software's usability and make it more efficient. The ideal cand...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human r...
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data...row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user-friendly interfaces within Excel for ease of customization by the end user w...
...Site Redesign: The layout needs a full makeover to meet modern standards and user expectations, offering a seamless navigation experience. 6. New Features and Functionality: Essential to this project is the addition of e-commerce capabilities. We're looking for smooth, streamlined user registration, login processes and an intuitive, secure buying experience. 7. Improved Performance: Our site should load quickly and run efficiently. It's key to minimize lag, glitches, or any form of downtime. 8. Ensuring SEO is operating smoothly. (We had some broken URL/Links which impacted our visibility peviously) Alternatively if it is faster to deploy a new template, we can do that as well if it works easier. Proficiency in WordPress development, web design, e-commerce integra...
I require a seasoned JMeter expert proficient in Load, Performance, and Stress testing. Need to fix an issue in Jmeter script. The project calls for immediate attention. Key Requirements: - Proficiency in JMeter: You should be able to design, execute, and analyze the results of load, performance, and stress tests. - Testing Experience: Prior experience in conducting HTTP and HTTPS testing through JMeter is a must. - Urgent Delivery: The project timeline is immediate. You should be able to start right away and work efficiently to deliver results in the shortest possible time. Your Experience: - Ideal candidates should have a strong track record of JMeter usage for similar purposes. - Experience in handling urgent projects and delivering prompt results is highly valued.
we've crafted a visually captivating website ensuring optimal performance and security based on client' requirement including.. Up to 6 Static Pages Image/Video Sliders Contact Form Social Profile Link Review/Testimonial Content Update Fast page load times Responsive Web Design Training and Support
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I need an experienced Chrome Extension developer to address a specific issue with my extension. The issue is that the extension fails to load after a Chrome update. Key Points: - The primary issue is the extension failing to load after a Chrome update. Your role will be to identify the cause and implement a solution. - The extension is primarily designed for custom searches. It is crucial that these search functionalities remain completely operational after the bug is fixed. Ideal Candidate: - Proven experience in developing Chrome extensions - Strong troubleshooting skills, especially with extension loading issues - Prior experience in implementing custom search functionalities within a Chrome extension
I have built this button with animated effects and have a cross-browser compatibility issue: It seems that on the newest WebKit the transparancies at the edges of the button are not working: The oval button is showing a rectangle around which the animation is not moving. To reproduce, you can download the latest beta version of Safari Browser or load the button in and select Iphone 15 with OS 17.4 (see screenshot with rectangle corners attached)
I need support in cleaning and organizing a dataset. - You should be proficient in Python. - Experience with data cleaning and manipulation. - Familiarity with data analysis would be an added advantage. Part A: Advanced Data Analysis Load '' into Jupyter or Colab. Compute Pearson's correlation coefficient for all attributes, save as corr_matrix. Sort and display correlation of all attributes with 'number_of_reviews'. Visualize with Seaborn's heatmap for corr_matrix and pandas' scatter_matrix for 'number_of_reviews', 'reviews_per_month', 'availability_365'. Part B: PCA with MNIST Dataset Discuss motivations and drawbacks of reducing dimensionality, including the curse of dimensionality. Explain if and how you can re...
...construct a high-performance database proxy and load balancer. This system should cleverly guide requests to compute engines in a manner that both reduces cost and heightens throughput. This system will run queries with minimal latency and virtually zero queuing. Key Aspects of Project: - Develop a robust database proxy using Python - Implement intelligent request routing to minimize cost and maximize throughput - Guarantee low latency and minimal to zero queuing while executing queries The ideal candidate will have the following experience and skills: - Proficiency in Python - In-depth understanding of database management systems, particularly Snowflake - Experience with handling structured data - Expertise in developing scalable load balancer systems - Demonstrate...
I need an effective solution to manage and balance DNS traffic over UDP and TCP on my Linux server. The solution needs a graphic user interface for easy management and real-time monitoring. This project suits professionals with experience managing backend servers, programming Linux interfaces, as well as knowledge of TCP/UDP DNS traffic load balancing on Linux Servers. PROJECT IS MARKED URGENT
I need a proficient WordPress developer who can help significantly improve the load time of my site, which currently stands at under three seconds. Necessary skills include: - An in-depth understanding of CSS, as bugs within our current code need fixing. - Advanced PHP knowledge, as there will be a requirement to enhance code efficiency. As well as addressing these specific bugs and inefficiencies, I'm looking for someone who can find and optimize other areas to streamline our performance further. Experience in conducting and applying findings from performance audits is desirable, with a clear focus on achieving faster load times without compromising functionality or user experience. We have a Wordpress website in a staging environment that needs to be perfected bef...
I'm currently in need of a skilled full stack developer with proficiency in Python and experience in GenerativeAI, particularly LLM. You will be primarily tasked with frontend and backend development. Job Summary: is seekin...Ensure efficient data exchange and API performance. 5. Continuous Integration and Delivery: • Develop CI/CD pipelines, leveraging tools like GitHub Actions to automate testing and deployment. • Maintain and improve continuous integration and deployment processes. 6. Kubernetes Orchestration (Nice to have): • Deploy and manage containerized applications with Kubernetes. • Configure auto-scaling and load balancing to enhance application reliability and availability. 7. Experience with large language model development and generative AI ...
...understanding and prior experience with mobile ad networks, especially AdMob - Experience with creating automation scripts or applications - Knowledge of the best practices and potential pitfalls when automating ad clicks. Admob Pilot is an amazing desktop application that can load and click AdMob ads automatically Admob Pilot features * Multi ad units With “Admob Pilot” you can add as many ad units as you want from all your AdMob accounts. * Automatic Load/Impression Simply by entering an Ad Unit in "Admob Pilot", the ad will load automatically and will increase ad impressions. * Auto Click With advanced features in "Admob Pilot", Ads will be clicked automatically like human clicks, and automatically your income will also increa...
hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by us...project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible...
I'm in need of a dedicated and experienced structural engineer who can provide a full suite of services for my residential building project. The ideal candidate should be able to efficiently handle structural analysis, foundation design, and load calculations. Project will be located in Florida, so Engineer must be licensed in FL and able to sign and seal plans. Key requirements: - Proficiency in structural analysis, foundation design, and load calculations - Experience in providing full structural design for residential buildings - Experience with Simpson portal or shear wall products - Strong communication skills - Ability to coordinate with engineered trusses and design conventional trusses as required. This project is on a tight timeline, so the successful appli...
...performance. If you know Browser automation with Html and Graphana report is enough. Just need to automate below test cases with html report and Graphana report for 10 vus in local and 100 in Grapahana. please read my amazon website as example. Example test case: Launch the - Calculte how much time i taking to load Enter username Enter Password click Login Button - Add check home page reached and Calculate how much time it is taking to Load the Amazon home page search any product in amazon - verify how much time application is taking to complete the search Select the Product -> Add check and 100$ displayed eg: iphone - 1000$ click on Cart button Goto cart page - -> Add check and cart is displaying and calculate time Verify how m...
I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.
I'm in need of a highly skilled web designer to provide a complete overhaul on my existing website. As it stands, the design is outdated, very slow to load, and I'm looking for a modern, fresh look to boost my online presence and increase business conversions. we also need to add/edit the entire product catalogue. Main changes will be in three areas: - Typography and Color Scheme: An absolute revamp is required in the current typography and color scheme to align with modern demands and user preferences. Use of modern, easily legible fonts and a consistent color palette that promotes better visibility and readability is a must. - Layout and Navigation: I am looking for a design that provides easy navigation and a layout that ensures a user-friendly experience. - Imagery ...
I need a Wordpress plugin that allows you to embed TikTok videos into a post. IMPORTANT: - It must be sufficient to only post the video URL for the TikTok video to be embedded. - The video must be inserted as a pop-up. - The loading time must be optimized because the videos take too long to load via normal embedding. - The whole thing should run via the API for developers provided by TikTok. - The embedded video should completely match the design of the respective website. A link to an example will be sent if interested.
