Maximum drawdown formula vbacông việc

mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm

Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.

Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .

Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng

Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)

Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục

Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,

Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel

Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục

Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel

Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi

Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất

Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty

Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu

Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v

Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel

1 / auto scan amazon price, other sites (wallmart, homdeport ..) have changed and if you change, go to ebay and reprice with new price of amazon or other site (wallmart, homdepot ..) according to the formula prefilled. (ex: ebay price = amazon price * ) 2 / Get the new order output file 3 / Automatically increase the quality of the product after an order 4 / automatically evaluate feed back for customers 5 / Automatically send offers to customers who have watched the product (watching) 6 / Track if the product is about to expire (3 days left), it will scan to see if it is eligible or not, if not enough then end it (condition is sold within 27 days)

- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại

Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA

VBA code help

>>>>> đây là trang mẫu hoặc bạn có thể làm theo.đầy đủ tính năng. Có thể mua cource code web. Tối đa là $30 usd. Here is the sample page or you can do enough features. Cource can buy web code. The maximum is $ 30 usd

đây là trang mẫu hoặc bạn có thể làm theo.đầy đủ tính năng. Có thể mua cource code web. Tối đa là $30 usd. Here is the sample page or you can do enough features. Cource can buy web code. The maximum is $ 30 usd

đây là trang mẫu hoặc bạn có thể làm theo.đầy đủ tính năng. Có thể mua cource code web. Tối đa là $30 usd. Here is the sample page or you can do enough features. Cource can buy web code. The maximum is $ 30 usd

I am seeking an experie...it will be a platform that sells physical products and also allows for booking services. The project requires in-depth knowledge of WordPress as desired platform. Ideal skills and experiences for the job include: - Demonstrated experience in E-commerce website development - Proficiency in WordPress - Understanding of online sales and booking systems - Proven ability to optimize websites for maximum speed and scalability - Excellent analytical and multitasking skills Please bid if you have the requisite skills and experience in building E-commerce sites particularly on WordPress, and can deliver on time. Your proposal will be more favorable if you provide samples of similar projects you have executed in the past. I look forward to a successful working rel...

I'm looking for a skilled frontend developer to help create a website with a focus on gaming. Please check attached video for detail design which is needed. Need responsive design in 3-5 days with maximum CSS animation possible. Add what you see in video and what you understand in your message.

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

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 – 300 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 knowled...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm in need of experienced social media and search engine advertising specialists. My goal is to launch a comprehensive campaign that will increase brand awareness, bring in sales, drive traffic to my website, and generate leads. To achieve this, the ideal candidate will have a thorough understanding of: - Facebook advertising - Instagram advertising - Google advertisin...bring in sales, drive traffic to my website, and generate leads. To achieve this, the ideal candidate will have a thorough understanding of: - Facebook advertising - Instagram advertising - Google advertising My target audience is across multiple demographics, specifically focusing on individuals aged 18-44. I'm looking for a professional who can tailor campaigns to these audiences, ensuring maximum im...

...that effectively promotes our products/services and entices potential customers to engage with our brand. - Utilize your expertise in Meta Ads to strategically target and reach our specified audience demographics. In this instance, our target audience will consist of individuals aged between 25-34 and 35-44. - Monitor, analyze, and optimize the performance of our advertising campaign to ensure maximum lead generation and sales conversion. Ideal Candidate: - Proven track record of successfully running and managing Meta Ads campaigns, with a strong focus on lead generation and sales. - Proficiency in creating engaging ad content for Facebook and Instagram, with a keen understanding of the nuances that make ads successful on these platforms. - Experience in effectively targeting an...

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

I'm seeking a skilled designer to help create unisex incontinence underwear with a prime focus on high absorbency. The designer must have knowledge about textiles and it would be great if you had manufacturer contacts Key Requirements: - The product must cater to both men and women and kids - High absorbency is the main feature required, ensuring maximum comfort without leakage. Ideal Skills: - Experience in apparel design, specifically underwear. - Knowledge of materials best suited for high absorbency. While the material is yet to be determined, your expertise will be crucial in deciding what will best achieve the goal of high absorbency. Your input and suggestions based on your experience will play a key role in this project. Let's create a product that offers users...

...to be able to understand its environment in real-time by creating and updating a map of its surroundings. - Obstacle avoidance and path planning: It should be proficient in navigational decision-making to identify and avoid obstructions while effectively charting out its path. - Efficient navigation and movement: The robot should operate smoothly and proficiently, with minimal redundancies and maximum efficiency in its paths. Moreover, I'll provide a guide and a base GitHub repo, but will need you to skillfully integrate and customize the project according to requirements. I’m flexible regarding hardware choices and would appreciate suggestions. As for the environment, while it’s an indoor simulation, your solutions should be versatile enough to apply to variou...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formul...analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I would prefer someone who can dedicate their t...

I'm looking for a data entry specialist to assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have the required skills and are committed to high-quali...

I'm in need of a talented graphic designer to create a cohesive and professional A3-size tri-fold brochure and a standard 85x200 roll-up banner for my business. I need the final version by maximum Monday night. The main purpose of this marketing material is to provide general information about our business to the general public. Key requirements include: - A3 Tri-Fold Brochure: This brochure should be designed to be engaging and informative. It will serve as a snapshot of our business, highlighting our key services and values in a creative and visually appealing manner. - Roll-Up Banner: The roll-up banner should be designed to be eye-catching and informative. It will be displayed in various settings to attract attention and provide an overview of our business for those passi...

I'm searching for a freelancer with intermediate Matlab skills to help optimize the energy efficiency of a battery system for renewable energy applications. Key Project Requirements: - Optimize battery system for energy efficiency: The primary focus of this project is to ensure that our battery system operates with maximum energy efficiency. This involves assessing current battery performance and implementing improvements in its energy consumption. Ideal Candidate: - Intermediate Matlab Proficiency: The perfect candidate for this project should be proficient with Matlab, having experience in battery system optimization. Previous work in the field of renewable energy systems would be a bonus. The goal of this project is to enhance the energy efficiency of our battery system. ...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

Description: I am looking for a skilled freelancer to design several web pages (UI) in HTML and CSS (or any other styling framework) for my React project. The work should be developed to be React compatible. The design must closely match a reference website that I will provide. Details: Number of screens: 6 to 7 Budget: Up to $90 (maximum) Deadline: Must be completed within 1 day Requirements: Experience with HTML, CSS, and React Ability to closely replicate the look and feel of the reference website Interested freelancers, please contact me.

...me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based solution r...

I am looking for an accomplished Facebook ad expert with a strong track record in construction and renovation sectors. The goal is to generate both residential and commercial leads to foster business opportunities. Key Requirements: - Solid experience wit...both residential and commercial leads to foster business opportunities. Key Requirements: - Solid experience with lead generation in the renovation and construction industry. - Proficiency in creating engaging Facebook ads targeting both residential and commercial sectors. - Proven history of driving substantial lead generation through social media campaigns. - Expertise in optimizing ads for maximum visibility and conversion. Aptitude for understanding industry-specific conversion triggers is a plus. Let's construct su...

I'm in need of a freeware expert capable of building an efficient and user-friendly GUI in C for a Pacman game coded in C. The system should contain: - Data input forms to allow ease of data entry - Visual data displays to allow smooth and instant data interpretation - Interactive navigation menus for efficient browsing through the system Ideal candidates for this task would be...displays to allow smooth and instant data interpretation - Interactive navigation menus for efficient browsing through the system Ideal candidates for this task would be proficient in C, with a solid understanding of GUI design for Windows operating systems. Previous work with data input forms, visual data interfaces, and navigational system design will be advantageous. Project needs to be done in maxim...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

My primary objective is to design an engaging and effective Instagram ad focused on driving website traffic from adults. I aim to stimulate their interest and ultimately encourage them to purchase our product. Ideal Skills: - Expertise in Instagram Advertising - Strong understanding of adult consumer behavior - Success ...effective Instagram ad focused on driving website traffic from adults. I aim to stimulate their interest and ultimately encourage them to purchase our product. Ideal Skills: - Expertise in Instagram Advertising - Strong understanding of adult consumer behavior - Success in driving website traffic and conversion Responsibilities: - Develop Instagram ads relevant to adults - Optimization to ensure maximum website traffic - Track conversion of ad viewers to prod...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that all...automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface desi...

I have nearly completed my CV, but I'm looking for a professional to help me redesign it. The aim is to create a more modern, minimalist, creative, and visually appealing layout. Key Requirements: - Tweak the content organization for maximum impact - Implement a professional and elegant font choice - Craft a layout that's ideal for job applications. Ideal Skills and Experience: - Proven track record in revamping CVs with a creative touch - Strong understanding of design principles and typography - Ability to tailor CVs for job applications. Please share relevant samples of your previous CV design work.

As the project owner, I'm searching for a proficient AI engineer who can expertly manage the Stack AI platform. Your three main objectives would be: 1. **Data Processing & Model Training:** - You'll need to clean and preprocess data within Stack AI - Also, train and evaluate models for maximum performance. 2. **Implement Google Search and ChatGPT Workflow:** - Familiarity with Google Search API and its integration into ChatGPT is a must. - Implement natural language processing to handle user queries - Design an intuitive and user-friendly interface to facilitate user interaction with the search process. 3. **Professional Recommendation Creation:** - Lastly, your task is to create a recommendation system using Stack AI that will offer professional...

I'm looking for a Laravel expert to help me integrate my POS system with my existing website. No live tracking, no location or other. Maximum 2-3 days task Key deliverables of this project include: - Seamless integration of the POS system with the website. Order from website goes to POS. - Website order in POS to POS print receipt screen. - Website: Multiple login (Google, Facebook) - Website: Eway payment sandbox integrated but also want to save payment details. - Website: The website only provides delivery option. Add pickup option also. Please include relevant examples of your previous work in your bid. Budget maximum: 150 USD