VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current d...
...Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business applications. HTML/CSS/JavaScript: For frontend development of the administration and configuration web application. Deliverables: Complete source code of the PHP application. Detailed documentation on installation, configuration, and usage of the application. User manual to guide administrators in using the application. Considerations: It is important to consider WhatsAp...
I'm in need of an experienced data entry specialist who can accurately transfer information from images into a PDF document. Key Requirements: - Data Entry: The main task involves typing documents from images. - Document Formatting: The deliverable should be a PDF file. Your Skills: - Proficiency in data entry. - Strong attention to detail and accuracy. - Experience with converting files to PDFs. Looking forward to working together.
MATLAB USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in 250...
I need a web scraping expert to help me get data from a third-party search site. The project is urgent and needs to be completed ASAP. Key Requirements: - Skilled in web scraping techniques - Proficient with tools for scraping - Able to work under tight deadlines - Excellent communication skills Please note that the specific search site is not mentioned, but the task involves scraping information from it. If you have the experience and can work quickly, please reach out.
I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I require a freelancer to extract and consolidate numeric data from existing databases. The data should be transformed and presented in a workable database file format. Key responsibilities include: - Extracting data from various data sources - Ensuring data integrity and quality - Transforming the data into a database file format Ideal Skills and Experience: - Proficiency in database management and data extraction - Strong understanding of data transformation - Attention to detail and precision - Ability to ensure data quality and integrity - Prior experience working with numeric data is a plus.
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.
Hello, I have a WordPress website with dokan and I want sellers to be able to obtain a donation, currently the site does it with a plugin but I want to keep a commission from those donations. It is acceptable to install another plugin. Currently it does this with a PayPal donation plugin and gravity forms. Write ragnar to know that you read the work, Knowledge of WordPress, Dokan and PayPal donations is essential.
Hello there, We will translate your Google Sheets (Crypto Ads for Spanish Translation) into Mexican Spanish. Thank you!
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...
...expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is cruc...
I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Her...
$150 USD. Deadline is April 20th, 2024
Ciao Laboni A., il tuo profilo mi ha colpito e mi piacerebbe assegnarti il mio progetto. Possiamo discutere i dettagli tramite chat.
import all the data from a json to custom compis all json data must be imported
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...
I have an AutoCAD DWG file for an urban design project. I'm looking for a 3D modeller to create a block model 3D representation of the design. Key Details: - The model should include the street, the buildings along it, and the design elements such as footpaths, bollards, junctions, along with the detailed 3D of a lake edge design. - Medium detail is required for the buildin...medium level of detail, staying faithful to the design's overall intent. - An understanding of spatial analysis in urban design would be beneficial. I have attached 2 reference images. These will be the final output which I will further detail out on Photoshop, for that I need the base model. If you're confident in your 3D modelling skills and have experience in similar projects, I'd love to he...
I need some easy work in Android I need some android apps using java I need easy work at low budget but for long term I need work from Pakistan freelancer
Translate from spanish to english a word with 2500 words
...freelancer who can help me with a data-oriented task. The project has two main aspects: - **Data Collection from Customer File**: The task involves searching for specific data (names and contact information, demographic information, purchase history) of customers on a sample customer file. The collected information will then be organized by customer name. - **Website Data Scraping**: In addition, the freelancer will be responsible for scraping data from a website. The main focus here will be customer data who use online payment methods. The specific data we're looking to extract is the 'Payment method'. This information will then be organized by customer name. **Ideal Skills and Experie...
I need a 3D modeler to create a straightforward product model based on provided photos. There's no need for intricate details or textures, just a model that captures the basic shapes and proportions of the product accurately. Key points: - The model is based on photographs only; I will not provide sketches or detailed drawings. - Th...modeler to create a straightforward product model based on provided photos. There's no need for intricate details or textures, just a model that captures the basic shapes and proportions of the product accurately. Key points: - The model is based on photographs only; I will not provide sketches or detailed drawings. - The aim is to create an 3D model (STL) - Leg from table. - Experience with product modeling and the ability to work ...
In this ...attractively laid-out business website with an engaging logo. - Building WP website (responsive design, one pager) from already purchased WP theme (). Using same sample FONTS, photos and design. Adding some icons if necessary, favicon and other design elements. - Creating simple LOGO to fit in website design (black on white and white on black), vector file - WP extract files with plugins needed at the end. Ideal skills and experience needed: - Experience in WordPress (WP) website design - Proven track record in designing for a professional target audience - Proficient in creating an intuitive user interface - Graphic design skills, specifically for logo creation - Experience in incorporating product/service showcases in website...
Assalam o alaikum, I hope you sisters and brothers are earning your halal rizq from this website. I am looking for mechanical engineers to be a part of my team and work on multiple projects. I am looking for long term work collaboration. Requirements: Freelancers must be proficient in mechanical engineering software's especially in SolidWorks and Ansys Freelancers must have good report writing skills
...extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Devel...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I need a creative and engaging video that showcases the core features of my productivity-focused Google Chrome extension. Key Details: - This video should be styled as a TikTok ad - The video should be highly visual and energetic, capturing the attention of viewers and highlighting the value and functionality of the extension - The main functionality of this extension is to extract leads from Google Maps related to businesses for cold-calling in SMMA (Social Media Marketing Agency) Ideal Candidate: - Prior experience creating TikTok ads or other social media marketing content - Strong understanding of video creation, especially for software products - Ability to creatively and effectively showcase key features of a Chrome extension in a short, engaging format - Familiarity...
This is a Pytho...Important Aspects: - The script needs to efficiently extract the full profile details of LinkedIn connections, including their names, job titles, locations, and industries. The data about any mutual connections between my friends and my existing client database is distinctly relevant. - I also need the parser to generate records of connections between my LinkedIn friends and contacts in my CRM. - I would require the output to be well-organized and easy to navigate. It should be exportable and storable both as a CSV file and an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in Python for web scraping and data handling - Experience in working with LinkedIn's data structure and APIs - Demonstrated expertise in managing and exp...
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I need a Data Enrichment (Entry) Specialist to help me with a project. - I have text and categorical data which need to be further extracted from LinkedIn - The data has to be entered into a specific format or template which will be provided - You'll be required to extract data from LinkedIn for 200-400 leads per day Ideal candidates for this project should have: - Ability to maintain high confidentiality of the data - Proven experience with data entry and enrichment, especially text and categorical data - A keen eye for detail and high accuracy in data entry - Familiarity with LinkedIn and data extraction from the platform (Mandatory) - The ability to work with provided templates and formats...
I am seeking a skilled 3D designer with experience in both furniture design and AI technology to create fewer than 10 highly realistic 3D images of kids' furniture. The furniture types will predominantly include kids' beds and indoor/outdoor playhouses. BASICALLY NEED IS: AN AI IMAGE IS SHARED, NEED 4-8 pictures of that from different angles and from inside and outside. It should be realistic wooden furniture. - Your MISSION: Translate my specific design ideas into detailed, realistic images. - REQUIRED SKILLS: 1. Excellent 3D modeling & rendering skills 2. Experience in creating furniture designs, preferably kids' furniture 3. A keen eye for detail and quality 4. Strong grasp of AI technology used in 3D design If you have a portfolio showcasing simi...
I'm looking for an experienced Flutter developer to create a cross-platform app compatible with both Android and iOS. Key Requirements: - Develop a seamless, efficient, and user-friendly app for both Android and iOS - Ensure the app is responsive across devices and screen sizes - Create a scalable architecture to support future updates and integrations Ideal Skills and Experience: - Proficient in Flutter and Dart - Prior experience in developing cross-platform apps for both Android and iOS - Knowledge of mobile app best practices, design principles and guidelines - Strong problem-solving skills and ability to troubleshoot and optimize app performance - Good understanding of APIs and integrations The timeline for this project is flexible, so you can work at your own pace. Looking fo...
I'm in need of a freelancer who is proficient in document verification services from Sasolburg and University of Pretoria. Your role is to help me authenticate the credibility of the documents I have from these institutions. Key Responsibilities: - Verify the authenticity of my identification documents, university certificates, and employment records from the respective institutions. - Provide a detailed report on the outcome of the verification process. Ideal Skills and Experience: - Prior experience in document verification services is highly desirable. - Knowledge of the procedures and systems of the institutions in Sasolburg and University of Pretoria. - Strong attention to detail and ability to accurately evaluate the authenticity of documents. - Excellent ...
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I need a WordPress expert to help me import posts from a JSON file to my website. I need to import posts from a JSON file to my WordPress site, without any media files, just the text content. This is a one-time job and I want the imported content to look exactly like the original. Key requirements: - Expertise in WordPress - Proficiency in handling JSON file imports - Attention to detail to ensure no data loss Please ensure that you have prior experience in handling similar projects.
As the client for this project, I urgently require an expert in VBA.
...web developer to convert my existing PDF design into a fully functional, responsive website. This project is for personal use and demands knowledge and expertise in HTML5, CSS3 and Bootstrap5. Key Points: - I require the site to be fully responsive on all devices, ensuring a flawless user experience. - The PDF only provides a design for the homepage. Creative insight will be appreciated for the remaining pages, although they largely echo the homepage design. - Matching the aesthetics of the provided design exactly is key. Ideal Qualities: - Proven experience in HTML5, CSS3, and Bootstrap5. - Strong portfolio of previous responsive web designs. - Ability to interpret and replicate design elements from a PDF. - Creative insight for designing secondary pages inspired by...
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 in need of a tool that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - ...
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I have to collect 200 cloth store and 200 footware store from each 52 usa state including company name website phone number address city state zip code hours category profile picture description 6 gallery photo. They are will be total 104 csv file. Eac file should contain 200 data.
As a company, we have created a Figma design fo...company, we have created a Figma design for our impending WordPress site and are seeking an experienced wordpress developer to bring this design to life. We will provide all the necessary copy for the site. Ideal candidates would have demonstrable Figma-to-Wordpress experience, as well as the ability to create responsive, user-friendly designs. Familiarity with implementing latest UX rich website designs and integrating brand elements smoothly into the site is also crucial. The site consists of: Home Product Pages Solution Pages Landing page Company Request a Demo Search Page (must integrate with the separate wordpress blog site) Backend Development Contact Forms Integration with HubSpot Book Demo (calendly) SEO Optimizatio...
i have many vietnamese handwriting scanned pdf doccument, i want have an python project could extract text from scanned pdf doccument (extract vietnamese handwriting text the most important and must be highest corrrect)
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I am in need of a seasoned web scraping expert to help me with a project involving Scraping a real estate website. The main focus is to extract a variety of data, including data points, numbers, and graphs. I need also advice on where is the best to store my data, to present it later on my wordpress website, I need someone who understands back-end architecture.
I'm searching for a freelancer who can deliver detailed information about a vintage limousine advertisement that was discovered in the Wall Street Journal. If you have experience with or access to archival research, especially involving old newspapers, your expertise would be invaluable for this project. Critical details that need to be uncovered from this ad include: - The price-listing - Any contact information available - Specifications of the limousine It is of significant importance to my project that the advertised car was allegedly used by Elvis's family during his funeral. Please note that this project requires thorough research and fact-checking skills to ensure the correctness and authenticity of the information obtained.
I have a task that involves extracting business logos from websites and resizing each one individually. The logos need to be exported as PNG files. Key Requirements: - Extract 10 business logos from different websites - Resize each logo - Rename image - Export each logo as separate PNG I only need the exported logos, each renamed, resized, and exported individually. There is no need for a combined file. Detailed instructions: - Where possible, only use the logomark - Rename the image to match the name of the firm - Export the logo as a png to 240x240 px - Keep default background white, unless logo requires a different color background - Logos don't need additional space around them; they can fill the container edge to edge as there will be padding built into th...
