Data cleaning using vbacô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

Using NFT ERC 721 to mint crypto currency ERC 20

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ạch đo công suất, năng lượng, góc pha và code tương ứng. Sử dụng MCU 8052

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

dự án monitor website, khi có lỗi hoặc kết nối time out sẽ trả về email của bạn

Em có 1 cái tiểu luận nhỏ và cần code cho chương trình tách biên dùng biến đổi wavelet chạy trên GUI. Liên hệ: email: penguin.0990@ yahoo: penguin.0990 sđt: 0902834913 Mong hồi âm sớm. Cám ơn anh

I want a comprehensive application that offers various home services by paying a membership. These include household cleaning, pet walking, carpentry, plumbing, electrician services, and even pet hosting. The primary aim is to connect users with professionals who specialize in these areas. Therefore, the successful candidate should have: 1. Proficiency in cross-platform mobile app development 2. Experience creating service marketplace apps 3. Strong skills in location-based features and real-time scheduling The app should have real-time chat and email functionality for user-professional interaction. Therefore, a background in implementing such communication solutions will be preferred. This project requires: - User and service professional profiles - Option to list, explore, a...

...seeking an experienced data scientist and analyst to support me in improving my business operations through a data-driven approach. The project will involve tackling tasks across data cleaning, statistical analysis, and data structuring and algorithm implementation. Ideal Skills and Experience: - Proficiency in data cleaning and preprocessing to ensure that the data is in its most usable, accurate, and complete state. - Strong statistical analysis and modeling skills to extract meaningful insights and make accurate predictions. - Excellent experience in structuring data and implementing algorithms that are tailored to business needs. Data Sources: - Social Media Data: You should be comfortable working with a ...

...institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advanced User Management: Implement a secure login system with multi-tier user roles and permissions. Dynamic Data Handling: Design the system to manage large volu...

...{useNavigation, useRoute} from '@react-navigation/native'; import BackButtonHandler from '../BackButtonHandler/BackButtonHandler'; import KeyCenter from '../../utils/KeyCenter'; import {UserType} from '../../UserContext'; const HostPage = () => { const {userId, setUserId} = useContext(UserType); const prebuiltRef = useRef(); const navigation = useNavigation(); const route = useRoute(); const data = ; const userID = userId; const liveID = userId; const userName = 'swapnil'; return ( <BackButtonHandler style={}> <ZegoUIKitPrebuiltLiveStreaming ref={prebuiltRef} appID={KeyCenter.LiveStreamKey.APP_ID} appSign={KeyCenter.LiveStreamKey.APP_SIGN} userID={userID} ...

I'm in need of an expert in software engineering, particularly in the realm of Windows game engine development using C#. The project requires the implementation of a robust physics engine into the game engine. Key Requirements: - Proficient in C# programming for Windows platform - Demonstrable experience in game engine development - Strong understanding of software engineering principles The main focus will be on integrating a physics engine into the existing framework of the game engine. If you have experience in creating 2D or 3D physics engines, that would be a huge plus. It is important that you are able to work independently and are self-driven, as the project will involve a lot of individual problem solving and innovation. Experience with multiplayer capabilities would...

I'm looking for an expert in digital marketing. Your role will be focusing heavily on converting leads to purchases and optimizing landing pages for enhanced User Experience (UX). Our mobile pages should be optimised to REDUCE BOUNCE and RETAIN CUSTOMERS. Key Responsibilities: - Develop highly effective digital marketing strategies - Lead generation and conversion through Google Ads - Optimizing landing pages for UX Ideal Candidate: - Proven experience in the above. Send examples of Landing Pages that you have designed. Your expertise with our target audience will be crucial for our campaign success. Let's convert leads into sales together!

I'm seeking a SPSS expert to help me with a comprehensive survey analysis. Key Project Details: - This will involve a full survey analysis aimed at measuring customer satisfaction specifically in relation to CSR. - Your objective will be to gain a solid understanding of how our customers perceive our CSR efforts and its impact on Customer loyalty. Ideal Skills and Experience: - Proficiency in SPSS and survey analysis. - Strong background in market research and customer satisfaction measurement. - Knowledge or experience in CSR evaluation is a definite plus. -Knowledge in Customer Loyalty.

Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis ...

Dental healthcare app using cam scanner 1. I want this project in flutter dart language with Firebase. 2. All patients and dentist data can be secure in this app. 3. One cam scanner in chatting session for click the picture of teeth disease at home or from anywhere and share to this on app with dentist and confirmed the appointment with dentist. 4. In this app there is payment option for emergency contact with dentist under 50₹. 5. I want the good UI/Ux in this app with all the good feature of flutter dart language.

No Framework Allowed.. only just Vanilla JS

I'm in need of an experienced 3D designer who is proficient in using 3ds Max. The project involves creating a modern styled 4BHK flat with a neutral toned color scheme. Key Requirements: - Expertise in 3ds Max is needed. - Experience in interior design, specifically in modern style. - Grasp of color theory, with an emphasis on neutral tones. The outcome has to echo sophistication, capturing the interplay of light and shape, and portraying a sense of effortless comfort. Stunning, realistic renderings are a must. The final design should be finely balanced in texture and form, creating an integrated neutral scheme. Your portfolio showcasing relevant works will be a great plus.

I need someone to gather a list of companies and individuals who offer cleaning services for the Bath, UK area. I need; Price per clean, name, email, telephone. This is for a 1 bedroom house. Dates will be random across the year and would need a cleaner with no contract, just a cleaner to call when needed. Need a list making of cleaners and prices for Airbnb turnover clean at Bath, UK.

Company name: Whiskers Carpet Cleaning Tag line: Premium Clean, Quality Unmatched Colors: Orange and Green Design:Rounded Cartoon Letters with Fur or tail or realiting to whiskers

I am in need of a professional who can help me in the data enrichment and cleaning of a set of merchant data. The data that requires the necessary cleansing and enhancing is primarily focused on merchant profiles. The main focus is on the verification process. Key tasks include: - Checking if the merchant meets our criteria list The ideal candidate for this project would have experience in data cleaning, enrichment, and verification. Your attention to detail and ability to cross-check,and verify data is crucial to the success of this project. Please share your relevant experience in your proposal and how you plan to approach this task. Your understanding of data quality and accuracy will be a major plus.

I urgently need an experienced WordPress developer to help with the cleaning of CSS files, JavaScript files, and PHP files in my WordPress plugin. There's been some situations of incorrect functionality alongside design issues that impair user experience. These include inconsistent styling and a non-functional search field. The ideal freelancer for this task should be skilled in WordPress bug fixing and coding and have a good eye for design. The tasks are as follows: - Clean up necessary CSS, JavaScript, and PHP files. - Correct inconsistent styling issues across the plugin. - Fix the search field that is not being intercepted correctly. If you have experience in these areas and a keen eye for detail, please submit a bid. I'm looking to get this job rolling as soon as ...

I'm looking for a detail-oriented professional who can help me with data entry from online databases. The data includes both text and numbers. Requirements: - Accurate data entry from online databases - Handling both text and numerical data - No data cleaning is required, so the task is straightforward and mainly requires meticulous attention to detail Ideal Skills and Experience: - Proven experience in data entry - Familiarity with handling both text and numerical data - Proficient in using online databases - Meticulous attention to detail and accuracy Please note, I need a quick turnaround time on this project, so prompt and timely completion is a key requirement. WATCH THIS LOOM FOR OUTLINE OF TASK:

1) Implement MOSSE with SCRFD for Java Android 2) Implement it in our app by replacing MLKit and connect it to our engine 3) Replace our engine with ARCface The App must be fast and robust. For the 1st milestone deliverables... implement MOSSE tracking with SCRFD for Java Android running the C++ libs. Create a demo app that runs detection and tracking and: 1. shows boxes and tracking ID for each face detected. 2. model size 3. fps 4. face confidence 5. screen resolution 6. Allow the app to run on Android's both front and back camera 7. add a zoom feature if supported by the device's camera. 8. add an option to upload and process recorded videos. no need to do ui/ux design key point is to integrate c++ library with android app Need to do some test before start Check SCRFD and...

I'm in need of a NASAL MASK design whose primary focus is to be both user-friendly and effective in treating sleep apnea. Key Requirements: - Detailed Design with Dimensions: I require a ...comprehensive design with precise measurements and specifications. This is crucial as the mask should fit comfortably and effectively for the user. - Adjustable Straps: The design must include adjustable straps. This is essential as it will allow the user to customize the fit, ensuring comfort and effectiveness during use. Ideal Skills: - Proficiency in Solidworks: The design should be created using Solidworks, so proficiency in this software is a must. - Experience in Medical Equipment Design: Experience in designing medical equipment, particularly for sleep apnea treatment, would be hig...

For my festival, I'm seeking a skilled web developer who is proficient in Bootstrap to create a website similar to the Festy Template. The primary functions of the website are to: - Promote the festival - Provide comprehensive information about the festival - Offer vendor signup with a contact form - Provide schedule and performer signup The project scope includes the development of less than 5 webpages with: - Textual content - Images - Videos A successful freelance web developer for this project should be experienced in Bootstrap and have a strong understanding of creating effective and engaging festival or event website pages. They should also be adept at incorporating various types of content, including text, images, and videos into their designs.

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.

...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 knowledge of VBAs, Macro, MS Office skills t...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.

We're in need of an experienced Data Science Engineer. The ideal candidate should have a strong background in data science, machine learning, and data analysis. Key responsibilities: - Data cleaning: The candidate should be able to clean and preprocess large datasets. - Data analysis: The candidate should be proficient in analyzing data and extracting actionable insights. - Machine learning modeling: The candidate should have experience in building and implementing machine learning models. Although specific programming language requirements were not provided, proficiency in Python, R, or Java would be a strong advantage. This project does not specify a particular industry domain, but any prior experience in Healthcare, Finance, or R...

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 interfac...

I'm a business owner in need of a professional with proven experience in managing Google AdWords campaigns, particularly those aimed at generating leads. My business specializes in dry vent air duct cleaning services, and I have a website already set up. Key objectives and requirements: - Your main goal will be to significantly boost the number of leads my business receives through the Google AdWords campaign. - The target audience for this campaign is homeowners. As such, the ideal candidate should be familiar with creating effective ad campaigns that resonate with this demographic. - We are primarily focusing on the local area around my business. Therefore, your experience in optimizing ad campaigns for local audiences is essential. Skills and experience that would be benef...

I'm in need of a savvy, adaptable assistant to help with various data entry tasks, project management, and miscellaneous admin duties. Responsibilities: - Data Entry: You will be tasked with cleaning and organizing data, as well as inputting and validating data. - Project Management: Your role will involve task scheduling, tracking, and ensuring smooth communication with team members. - Ad Hoc Administrative Duties: In addition, I'll need you to assist with document formatting and editing, as well as internet research. To excel in this role, you should have: - Proficiency in data handling and management tools - Strong organizational and multitasking skills - Excellent communication abilities for team coordination - A keen eye for deta...

I'm seeking a daily household helper and cook to support me with a variety of tasks around my home. Tasks: - Daily light cleaning of my home - Laundry (washing, folding, organizing) - Cooking for meals The ideal candidate will have experience in: - Household cleaning and organization - Laundry management - Cooking, with a focus on healthy and diverse meals I require the services daily, so commitment and reliability are key. If this sounds like you, I look forward to discussing further.