Project vba calculationcông việc
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
- 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
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
As a gift basket business owner, I'm seeking an experienced Woo-commerce developer who can resolve a shipping issue on my website. The problem lies with the incorrect calculation of delivery fees if the customer's billing and shipping address differ. - The Requirement: I need the system to accurately use both the billing and shipping addresses when determining the delivery fee. The rates must differ based on the zip codes entered. - Essential Skills: Deep understanding of Woo-Commerce, PHP, Javascript, and any other relevant programming language. Prior experience in handling shipping/delivery rates customization is a plus. In your proposal, please discuss your previous similar projects and your chosen approach to handle this task.
...Sheets module, specifically designed for the intuitive verification of GSTIN numbers. Key Responsibilities: - Crafting a module capable of validating GSTIN numbers to ensure they're correct. - Enabling lookup functionality to fetch respective company details using provided GSTIN numbers. - Designing formulae for automatic GST amounts calculation according to the obtained details. What I'm Looking for in the Proposals: - A comprehensive and detailed project approach indicating complete understanding of the module requirements and successful execution plan. Ideal Freelancer: - Proficient in Google Sheets, with substantial experience in building custom modules. - Basic understanding of GSTIN principles is a plus. - Able to deliver a standalone solution that does...
...solution for fraud protection. - A Review and rating system to obtain and show feedback from users. - Google map embed API for tracking , distance calculation, traffic status, ETA calculations. - Ability to handle complex fare calculations. - An automatic accept feature to streamline the booking processes. - Options to choose from various rates. - Driver and rider separate console. - Driver application form. - Feedback. - Vehicle condition monitoring. - KYC verification for drivers. - Verification for vehicle owner. - Automatic push notification. - Ride verification OTP. - End of ride confirmation. - Real time booking map. etc The project also calls for the creation of a comprehensive vehicle selection based on local rules, which includes: - Non-AC and AC Sedans. - N...
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.
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 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.
...in recapitalization efforts. Key tasks for this project include: - **Valuation Analysis**: I need someone who can perform a thorough valuation analysis based on the financial data available. - **Debt-to-Equity Ratio Calculation**: The ideal candidate will be able to calculate the current debt-to-equity ratio and provide recommendations for improvement. - **Return on Investment Analysis**: A comprehensive ROI analysis is necessary to evaluate the potential outcome of the recapitalization effort. I have all the relevant financial data in hand, so the focus will be on the calculations and recommendations based on this data. The primary goal of this recapitalization effort is to restructure the company. The perfect candidate for this project should possess a solid b...
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 engineeri...
As part of my project, I require a thorough analysis of the Sequential Search algorithm. Key Requirements: - An understanding and calculation of the time complexity under all cases: worst, average, and best. - Assessment of the algorithm when working with all types of list: sorted, unsorted, and randomized. The ideal candidate should possess strong problem-solving abilities, excellent mathematical skills, and a deep knowledge of algorithm efficiency. Proficiency in the use of mathematical induction to prove the correctness of algorithms is highly desirable. Your task will revolve around the comprehensive evaluation of the Sequential Search algorithm, making this role perfect for those seeking to apply and grow their knowledge in computer science and algorithm analysis.
We are carrying out a fire network project and need to carry out the calculation in software such as SprinCalc, FireCAD, AutoSprink, Firegrid or similar. It is necessary to meet FM Global standards, this requires factor k160. The pavilion to be calculated is 4310m². We are short on this project, which is why we need to: - Calculation memory (generated by the software); - List of materials; - Isometrics generated by the software. We will provide the necessary information for anyone preparing the project. We need the project between 24 and 48 hours after closing the proposal. Attached are some data to better understand demand.
...for my early stage biopharma company. Here's what the project entails: - **Drug Development Details:** My company is currently working on three drugs - Drug A, Drug B, and Drug C. Each of these is still in the early stages of development and is expected to take more than three years to complete. Your valuation model should take into account this extended timeline and the associated risks. - **Data Availability and Analysis:** As part of this project, you'll have access to our clinical trial data. It's essential that you can effectively incorporate this data into the model to accurately reflect the potential value of these drugs once they hit the market. - **WACC Calculation and Ratio Analysis:** The model should also include the calculation of...
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 to develop a 4-tier agency commission calculation system that hinges on the daily NAV (Net Asset Value) of the assets. The system should have the following key features: - **Tiered Commission Structure:** The system must support a 4-tier commission structure. These tiers should be clearly defined and adjustable by an administrator. - **Daily NAV Calculation:** The daily NAV should be calculated based on historical data. This data should be accurate and reliable, and the calculations should be precise. - **Automation:** The system should automatically trigger commission calculations at the end of each business day. This ensures that the process is efficient and error-free. The ideal freelancer for this project should have: - Proficiency in designi...
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.
I'm urgently seeking a proficient Android app developer to create a one-of-a-kind dialer app. I need a custom dialer app. My requirements are: Access to device's contacts, browse and search through contacts list within the app, Automatic disablement of default phone dialer or any other dialer apps upon installation,Unique call duration calculation starting at 50 seconds, incrementing by second for each second of the call, and Visible display of call duration during an ongoing call Ideal skills for this job: • Solid background in Android app development • Experience in creating dialer apps or similar • App design proficiency • Excellent time management skills • Strong problem-solving capabilities • Ability to work to tight deadlines • St...
...E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff was selected. The created account must be saved in the admin panel and on the user page. At the time of invoice generation, an email should be sent to the admin with the invoice tab and to the user with a link to the invoices page in the personal account. If there were registrations with a choice of tariff, fil...
...an existing indicator. The changes required include: - Adjusting the indicator's calculation formula: This involves fine-tuning the parameters and logic of the current formula. - Modifying the visual appearance of the indicator: Changing the color scheme and customizing the font or text size are some of the visual modifications needed. - Adding new features or functionality to the indicator: I'm looking to incorporate additional capabilities to the indicator to enhance its utility. The ideal candidate should have: - Demonstrable experience in Ninja Trader 8 development - A strong understanding of indicator calculation and visual customization - The ability to implement new features effectively This project is perfect for someone who enjoys tweaking exis...
...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...
Life safety plan. complete a set of plan comply with NJ building code. HVAC One RTU cooling and heating (natural Gas) for offices Need to show FA calculation and toilet exhaust . Warehouse heating Natural Gas Vertical Power Vented Unit Heater. Plumbing two bath room in office and small panty with one kitchen double sink and one toilet in warehouse. Electrical lighting and power . Specific power to office lab and fume hood . Exterior light building . Power to Hydraulic loading dock . Power to elevator . fire alarm and sprinkler show note to be submitted separate with calculation.
...quote for the architectural design and structural calculation services you require for your house plan. Based on the information you provided, the scope of services will include the following: Architectural Plans: This includes the site plan, floor plan, elevation plan,and structural engineering calculations. Basic Services: I will confirm the design criteria and provide the necessary drawings based on the basic drawing you sent me. If there are any issues with the submitted drawing and modifications need to be made, I will be responsible for revising the drawing until a full set of plans is approved. As part of my commitment to providing you with the best service, I will send you daily reports to keep you updated on the progress of the project. However, please note that...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualizati...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 previou...
...versatile in language support, specifically English and Arabic. As for payments, I would like to use Stripe as my primary payment gateway. It's also vital that the shop supports international shipping, rather than being limited to local shipping. Key Requirements: - Multi-Language Support: English and Arabic ( no google translation ) - Payment Gateway: Stripe - Shipping: local and Worldwide calculation - discount copons - similar products suggestions pepole also orderd - share product to friends - whatsapp chat link - social media links - social media share - pages : international standareds pages for online shop Ideal Skills: - Proficiency in e-commerce development - Experience with multi-language websites - Expertise in Stripe integration - Knowledge of inter...
Hello, I am looking for someone who can do static calculations for the building facade. Details will be given below. M profile (70 * 20 * 0.5 mm), L anchor (80 * 90 * 50 * 3 mm), box profile (30 * 20 * 2 ...calculations for the building facade. Details will be given below. M profile (70 * 20 * 0.5 mm), L anchor (80 * 90 * 50 * 3 mm), box profile (30 * 20 * 2 mm) in the lower carcass of the building facade. ) will preferably be of these dimensions and 12 mm fiber cement sheets will be placed on the carcass, but according to the static calculation, the most suitable and economical solution is desired, the building will be 26 floors. It is not a complex project, only the static calculation of the profile carcass to be made for the facade cladding needs to be made, I will ...
2 excel files with VBA macro as per customer requirement
I'm looking for an expert to assist with an important aspect of my Autocad project - calculating the material needed for ducts from drawing to excel sheet. Your main task will be to extract the dimensions and quantify each type of duct in the drawing. Key Responsibilities: - Extracting precise information from Autocad drawings - Accurately entering data in Excel for duct types and dimensions Skills and Experience: - Proficiency in Autocad and Excel - Strong understanding and experience in drafting and design - Excellent attention to detail - Experience with duct design or HVAC systems would be advantageous. Please note, material types are not specified for the ducts. This project primarily focuses on quantity and dimensions.
The project is to create Inverter automation to start export, stop export and charge the battery automatically using a microcontroller that can subscribe to the server to get spot prices to run the automation. Objectives: 1. Modbus read and write 2. ESP32 Webserver 3. Spot price subscribe 4. Calculation / rules 5. MQTT Service (Server) 6. Price Service (Server) 7. Device Dashboard (Server) Project scope and system architecture are referred to the project brief documentation "Inverter Automation Project "
...professional who can perform a detailed Finite Element Method (FEM) analysis on a non-linear structural model using Python. hi, there I have other project to work with its about FEM analysis(python)of the Implement a finite element procedure using 8-node trilinear element for three-dimensional linear elastic solid mechanics problem; Visualize the finite element simulation results for several example problems via the visualization toolkit Paraview; relevant results of the stress calculation , there are three problem parameters to solve. I can provide you detailed instruction and reference work as well if you are interested Key Points: - The project will primarily focus on analyzing stress distribution in a non-linear material setting. - You need to have experience ...
One excel file with macro as per the customer requirement
...where we can input the purchase price of the product from the supplier. The key requirements for this project include: Order Recording: Developing a system to record comprehensive details of each order, such as purchased products, quantity, price, customer contact information, etc. Marketing Expenses Tracking: Incorporating a feature to track marketing expenses (e.g., Google Ads, Facebook Ads, TikTok Ads) and associating them with each day's data. Integration with Urgent Cargus: Ensuring seamless integration with Urgent Cargus' delivery tracking system to display shipping costs and provide real-time updates on delivery status (delivered, out for delivery, refused, etc.). Calculation of Net Profit: Implementing functionality to automatically calculate the net...
