VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
...integrating with their existing accounting software like quickbooks. Ideal Skills: - Proficiency in SaaS tool development using a no code tool flutterflow - Experience with real-time data processing - Previous work on financial reporting tools - Familiarity with integrating systems with accounting software User journey - Register with Google account - link with accounting platform like Quickbooks (1 click integration) - Extract data and save the data in AWS securely - Do some calculations on the data (we will provide it) - Display the information in widget formats in the platform - Client pays for premium features and payment is via stripe - Notification and Reports are emailed The selected freelancer should be able to develop a user-friendly, intuitive and accurate tool...
...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 experience in a similar role and can deliver a high-quality produ...
...developer to create a sophisticated, user-friendly birthday invitation system. I need talent Wordpress can create system to manage all users created birthday invitions , I need to send my customer link . with some fields he need to choose from some options . example : name, age , address, every option have some drop list text he can choose for the format . and then after he finish . he click created order birthday . then I need approve this . after approve . he can share the invite birthday to friends and family . the design of the birthday page is full wide on screen. open only on mobile ! can't open on desktop . Can edit the invite birthday from admin . I want also later to connect this system to AIRTBALE if you know what is . the invite birthday will...
...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 experience in a similar role and can deliver a high-quality produ...
...Operations Analyst at a top online advertising campaign management firm and I urgently require a professional skilled in Tableau. Your task will be to create a comprehensive dashboard that assists me in analyzing and strategizing our sales operations. Key Deliverables: - Present crucial data points including daily ad impressions and conversion rates. - Display key performance indicators such as Click-through rate (CTR), Cost per acquisition (CPA), and Return on ad spend (ROAS). - Use different visualization formats like line charts, bar charts, and pie charts to represent the information. Ideal Skills: - Proficiency in Tableau - Strong analytical skills - Experience in developing dashboards with extensive understanding of marketing and sales KPIs. Please bid if you can delive...
I need a skilled YouTube marketer to spearhead a campaign intended to drive significant traffic towards my website, specifically for a time-sensitive special offer. The goal is to attract and entice an audience within the age bracket of 35-49 and 50+. Key Responsibilities: - Develop and execute YouTube marketing strategies - Improve visibility and click-through rates - Generate website traffic Ideal Freelancer: - Proven experience in YouTube marketing - Understanding of SEO for video rankings - Ability to target and engage the specific age demographic 35-49 and 50+ - Experience in driving website traffic and promoting product sales. Your role is critical in promoting my website, which primarily serves to sell products and services. YouTube campaign to solicit pot...
I am looking for someone to create a digital scratch card that can be used seamlessly across mobiles, tablets, and computers. I will provide the background image - I am looking for someone to integrate the scratch element. The scratch card should be interactive, allowing users to scratch off with their finger, touchpad or mouse, and I need the final file to be shareable. Image 1 shows the background image, Image 2 shows what I'd like it to look like with scratch elements that can be scratched by the user.
...websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for… Jake The Plumber Minneapolis, MN … I see a link to Jake The Plumber’s website. Your script(s) will not submit the forms; rather, I will review each form and then manually submit each myself. In other words, I will click on, for example, the “Send” or “Submit” button. If I were to loop your script(s) X times, then your script(s) would open X tabs in Google Chrome. Each tab would contain a website for a particular business. For example, if I were to loop your script(s) 89 times, then your script(s) would open 89 tabs in Google Chrome. Each tab would...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Hi I have a python matplotlib script that allows user to scroll through a 3D image, in nifti file format. It has a slider that allows you to scroll through the z axis of the image. I would like for the image to have a text box that updates chosen coordinates that are selected by clicking on the image at a given slice. I would like for the chosen coordinates to only update if the user clicks on the canvas where the image is. I would also like for the text box to be outside the canvas and slider. If you have previous experience with Matplotlib, this should be no problem. Thank you!
...the below improvements. Birthday Pop Up (Modal/TBD): Currently titled as (openpop1) to be triggered upon selecting the “Caller is verified” #button# in the “Inbound Opening Call Script”. If the requirements are met that are currently in the script then it should populate on the screen. However, the end user should not have to interact with the pop up to make it go away. They should be able to click anywhere behind the pop up to make the pop up go away. Auto populate script based on VAR LiveCall = @call.skill_name@ Upon loading of a new call the script should automatically populate based on the VAR Livecall = @call.skill_name@ that populates. Based on that the script should populate the ID of the script as shown in the “Script Auto Pop Matrix_v1&rd...
I have a VBS script which downloads files from a server to the a folder on my local machine or onto AWS (MS Win Server 2012 R2). This script can be manually activated (double click) or via Task Scheduler. Recently the script stopped working. I think it has to do with AWS permission/read/write errors. I need to have this investigate and fixed. The person needs to understand AWS EC2 and VBS and JS scripting.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good eve...should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NO...
Using Bambu AMS printer and am looking to have a football field built. I need a field with 2 goal posts and the lines. In bambu slicer i can color blocks so goal is to click lines white then each grass segment and end zones varyong shades of green. File will be printed then placed inside stadium as a finished product Just like attached photo but with the yard lines drawn so they can be "painted" in bambu studio. More details: Football field. Not the stadium just the field. What dimensions do you want for the football field model? Standard dimensions (120 yards x 53.3 yards) What level of detail do you require for the field, such as textures and grass? Basic detail.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person
We are seeking an experienced email marketing professional to join our growing real estate company. The ideal candidate will have a proven track record of executing successful email campaigns with extremely low bounce rates and high open/click-through rates. Key Responsibilities: - Develop and execute targeted email marketing campaigns to our real estate client base - Leverage email marketing software to track key metrics like open rates, click-throughs, and conversions - Ensure email content is optimized to avoid spam filters and land directly in client inboxes - Analyze campaign performance data and provide recommendations for improvement - Stay up-to-date on email marketing best practices and implement new strategies as needed Required Qualifications: - 3+ years of exper...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Just like the title says, i currently have a script on my site that displays text on mouse over, just not sure why it wont let me add line breaks; i can not give you access to the site, but i can send you the script. I have tried adding... '<br>, n, b, ' not really sure why its doing it. Thanks,
Design and implement one page website. The website shall have a design similar to the included "reference ". Please also notice the "ref...ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that has ...
Hello Maicol, Hope you are doing well. We will improve your website traffic and give you a better ranking in your desirable search will never be disappointed with our work We have completed a lot of projects, with a very good experience - Website Technical Audit - Keyword Research - SEO Strategy - Content Creation - On-Page SEO - Link Building - (Only Quality Links) - GA Goal Setup: Phone click, Email Click, Form Submission, etc. - Conversion tracking - Google Rankbrain Optimization - Monthly Marketing Reports Thanks Jassi Thakur
... needs to be transferred to Shopify. Shop products and menu items are already there. SHOP page products wasn’t done correctly so need to redo. (Please note that there is a custom WooCommerce child product “Swarovski detail” pop up with ability for user to select a custom design on their main product which needs to be implemented). Go to > click on Swarovski and you’ll see what I’m talking about. There are accessories that are meant for each style. Please upload them accordingly. 4. Current WP and WooCommerce plugins need the BEST replacement plugins that are comparable of the best ones on Shopify, and the rest such as scroll, slider, gallery, social media links and shares, contact form, etc should be replaced with a plugin that offers
More details: What level of customization would you like to have for the websites built through the saas software? Limited customization What categories of te...What level of customization would you like to have for the websites built through the saas software? Limited customization What categories of templates should the software include? Business Which of the following authentication systems do you want to be implemented in your saas software? Email/password-based Modules that needs to be developed: Website Builder - Websites can be created in 1 click based on the type of the businesses 2. CRM - Where the users can keep a track of all the customers at 1 place. 3. Ai Assistant 4. AI Blog Builder Note: For more details go through the attached doc for full feature and functionality...
...links we have created, and make sure it is not shown when on the desktop site. -The testimonials section on the home page (mobile and desktop) is not displaying properly. Check and fix -Stop the rollover effect on the career sector, so that on rollover nothing changes. -Point the website contact form to the email address info@domain. set it up and test that it works throughout the site. -Disable the pop-up that appears on the home page when you scroll down. -Point this button so that when a user clicks it, it scrolls the page to the sector section on the home page. -Set up these 9 buttons so that they display the selected icon and text. Then set them up to point to the appropriate sector pages. The job will take a talented and e...
I'm looking for a skilled freelancer who can develop a program for the Click PLC to control a Variable Frequency Drive (VFD) hoist. Key tasks would include: - Implementing a start/stop control which can be manually triggered. - The program needs to possess speed control, allowing adjustments in the hoist's operating speed. - Including direction control within the program functionality would be vital as well. An understanding of PLC programming and specific proficiency with Click PLCs is crucial for this project. Previous experience with VFDs, industrial automation, and manual switch controls would give any potential freelancers a significant advantage.
I'm looking for a skilled freelancer who can create a system that automatically downloads building and road data from OpenStreetMap in CSV format on a monthly basis or with a html frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - Set up the system to run the download process on a monthly basis optimizely on html frotend with a download button Format of the csv: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Stron...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I'm looking for a professional who can help me enhance my web system. The enhancements I ...(name, address, phone, email, state ) -Admin manually help vendor create cash voucher - company name - address -State - Expired date voucher - Voucher amount or % Discount - Phone - Point deduct when redeem - Vendor joining until when - Admin dashboard will display who vendor will expired joining, or coming soon. Must have report -Admin can Disable/Enable vendor joining if no make payment. I'm in a bit of a hurry and would appreciate getting this done within a month. Ideal Skills: - Proficiency in web development - Experience with database management - Ability to implement user-friendly features - Strong project management and ...
I need a Flutter developer for a website, I want you to create an automation website that generates ( SMS iPhone videos ) the website is gonna be like this 1- there is an empty SMS template 2- the user adds the text in every part ( sender - receiver ) 3- click okay and the website generates the video 4- the video has to be like that ( one message at a time, voice over for every message, background video game ) here is an example of what I want exactly: @
1) Fix reset password when create new password need to double click on the reset button in order to work with a scucess reset. 2) The form of reset password should be open at home page not my account. 3) Make the full form responsive on all devices and open in the browser as responsive (as now on browser it's working for desktop) 3) Replace My account page form with the form we made. 4) Gather the full form codes and create a custom plugin and enter the code so the form be on a plugin
...Media Marketing: You'll be responsible for promoting my brand on both Facebook and Instagram. This includes creating engaging posts, monitoring engagement, and running targeted ad campaigns. - Search Engine Optimization (SEO): Your job will be to enhance the visibility of my website on search engines. This involves optimizing content, fixing technical issues, and building backlinks. - Pay Per Click (PPC): I need assistance in managing my PPC campaigns to increase traffic to my website. The goal of this project is to: - Enhance my website traffic - Generate more leads - Boost brand awareness The ideal candidate should have a proven track record in managing successful digital marketing campaigns, particularly in social media marketing, SEO, and PPC. Good communication skill...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
...advertisements to users according to the categories entered during registration, the last 10 advertisements at a certain time of day. It should be possible to enable/disable this newsletter from the admin panel * Create in the admin panel the ability to enable/disable automatic sending of invoices * Change the error text when entering incorrect login information on the site * Configure sending an email to the user after granting access to the site * Add a function for automatic publication of advertisements with a check for the presence of contact information in the advertisement. There should be an option to enable/disable this function in the admin panel. * Set a password on the accounts page in the admin panel and on the server on the database (folder) where...
1) Fix reset password when create new password need to double click on the reset button in order to work with a scucess reset. 2) The form of reset password should be open at home page not my account. 3) Make the full form responsive on all devices and open in the browser as responsive (as now on browser it's working for desktop) 3) Replace My account page form with the form we made. 4) Gather the full form codes and create a custom plugin and enter the code so the form be on a plugin
...automatically adjusts prices to my local currency, offering a seamless shopping experience for my customers. - **Inventory Management**: I prefer an integration that can hide out of stock products from my store. This maintains a clean and updated product catalog. - **Order Fulfillment**: I intend to only allow customers to order product variants that are available on Shein. The integration should disable the purchase option for variants that are not available. Ideal Candidate: - **Shopify and Shein Experience**: It's crucial that the freelancer has prior experience working with Shopify and Shein integrations. - **API Proficiency**: A strong command over API development and integration is required for this project. - **Inventory Management Skills**: Experience with inventory...
...branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and ignore the left panel. Second section: because this is sendkeys basically we will use the ...
Hello we are looking to make 2 simple changes to our shopify website order confirmation email. - We would like to add the product SKU in the email - We would like to make the product tile, image and sku clickable to it takes customer to the product page This is so when people need to reorder an item they can simply go to their previous order confirmation email and click on the item or search it on the website by the SKU. We will send you the code and you will edit it and send back to us and we will paste it into shopify. No shopify access will be given. Looking to have this done immediately. $50 budget.
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
I'm looking for a talented graphic designer to help me with my existing HTML CSS site and emails. The PHP developers have recently made some adjustments to the template which caused some issues with the layout. I need someone to fix the broken layout, realign any misaligned elements and improve the current design. Key responsibilities: - Rearrange ...improve the current design. Key responsibilities: - Rearrange the layout of the existing HTML and css - Fix broken layout and misaligned elements - Enhance the overall design Ideal skills and experience: - Proficiency in HTML and CSS - Experience with graphic design - Ability to fix broken layouts - Good eye for design aesthetics and layout - Familiarity with email best practices (add one click share options with the help of...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I am looking for a popunder ad expert to help me increase traffic to my website. The ad will be click-based, targeting a general audience. Key requirements: - Create a click-based popunder ad: The ad should be triggered by a user clicking on a specific element on a webpage. - Increase website traffic: The primary goal of the ad is to drive more visitors to my website. - Target general audience: The ad should be attractive to a broad range of internet users. Skills and experience: - Proven track record in creating effective click-based popunder ads. - A deep understanding of online advertising and user engagement. - Experience in targeting and engaging general audiences in the digital space.
2 excel files with VBA macro as per customer requirement
...skilled in generating and joining 3-second clips such as scenes of accidents or spills into a coherent, engaging video. To align with my project's focus, the videos should majorly revolve around the following themes: - Visitors' experiences in New Zealand - New Zealand landscapes, images, news in the cities put together - Scrapped content from other pages into fun engaging content that people click on, comment and share, pr tgat we get them to jump to a web landing page. Local news and stories Experience in 2D and 3D animations, as well as motion graphics, is highly desirable. A background in short-form social media content creation will set you apart. Creativity, attentiveness, and a high level of organisation, speed are also crucial for this task. We run 3 big soc...
...ecommerce website will be hosted on Amazon Web Services (AWS) servers, providing a scalable and reliable infrastructure. 2) Arabic Website: The website will be in the Arabic language, including Arabic text, and may include right-to-left (RTL) layout adjustments. 3). Feature to Create Landing Pages: Admin can create a promotion landing page, and can upload by admin panel so it will show to user on website as a discount banner. 4). Multiple One Click Upsell (Cash On Delivery Option): After a successful purchase, the system will present additional products or offers with a one-click option. This feature is particularly tailored for customers who choose cash on delivery as their payment method. 5). Order Bump Feature: The ability to offer additional products or service...
One excel file with macro as per the customer requirement
I need a full stack developer to create a digital marketing tracking website with specific features and a minimalistic design. Key Features: - Conversion tracking - Analytics dashboard - Ad campaign management - Click tracking - Ability to onboard new advertisers and publishers The ideal candidate should have experience in full stack web development, particularly in creating tracking and analytics tools. Your UI/UX design skills should also be top-notch to achieve the minimalistic style I'm looking for. Please include your relevant experience and example projects in your proposal. Examples:
...website for employability and finding work, focusing on cost-effective solutions and functionalities: Stage 1: Planning and Setup (1-2 weeks) Domain Name & Web Hosting: Choose a catchy domain name that reflects your brand and secure affordable web hosting that supports WordPress installation. WordPress Installation: Install WordPress on your web hosting platform. Most web hosting providers offer 1-click WordPress installation. Learning Management System (LMS) Plugin: Explore free or freemium LMS plugins like LearnDash or Tutor LMS. These offer basic course creation, enrollment, and content delivery functionalities. Theme Selection: Choose a free WordPress theme optimized for eLearning platforms. Popular options include Astra or OceanWP. These themes are customizable and...
