Create vba project iports data csvงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
ผมต้องการทำ Google data studio เพื่อแสดงข้อมูลรายงานรายได้ ค่าจอดรถของผม ซึ่งผมมี เวป คราวที่สามารถดึง CSV ออกมาได้แล้วก็นำมา สร้างเป็นหน้ารายงานสรุป
ฉันสามารถออกแบบสิ่งที่คุณต้องการโดนหาแรงบันดาลใจจากคุณ เปิดโอกาศให้ฉันได้ร่วมงานกับคุณ
...include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tas...
I have a CSV file that I need to be analyzed through visual data analysis in Python. The CSV file has a wide range of data, but the specifics of what data I'm interested in have been left open-ended. I need you to help me identify trends and patterns from this data and provide me with clear, insightful, and informative visualizations. Ideal skills: - Strong background in data analysis. - Proficiency in Python and data visualization libraries. - Experience with analyzing CSV files. - Ability to generate insights from data.
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
...position, I am looking for a seasoned Tableau Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinatin...
Not able to create new record. Only ftp available to access source code.
Hello : i need do a simple bot for aumatization of some simples task, please fell free to contact me. Thanks
I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share I can able to download as json file. I can able to download as yml file. But only CSV is blocking. So iwant CSV export web form Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.
Example link: I require the capture/extraction of 84x numerical values (table comprises of twelve events, seven results per event) from PDF file as ...There will be 1,000s of unique PDF's, so my guess is I'd copy/paste relevant addresses into an Excel file and a Python script would run from there (?). To my knowledge, PDF file is always four pages in length, relevant table to scrape is always located on page2. Required data is always located in the same position/same column in PDF files. (Possible) example output in CSV/Excel could look like: date | 1H | 21,114,900 | 291,000 | 719,400 | 119,200 | 71,000 | 17,900 | 12,600 That output line (above) would have twelve lines of data per daily PDF file (1H, 2H, 3H etc)
As an e-commerce site that sells physical goods, I am in need of a skilled WordPress Elementor Developer to create an engaging theme using Astra Pro. Key functionalities I'm looking for include: - A strong emphasis on product reviews to boost our user engagement and confidence. Ideal candidates will have a strong background in WooCommerce and experience in creating user-friendly, visually attractive WordPress themes for e-commerce sites. Knowledge and experience with Astra Pro is essential. Other necessary skills include: - Strong UX/UI design experience. - Proficient in HTML/CSS/JavaScript. - Understanding of SEO best practices. Please provide relevant work samples along with your bid.
Note before bids : my budget for whole project is 10$ Requirements Development/ design Socail media website for mobile ( UI / frontend / backend ) Requirements functionalites 1: Design landing page 2: Registration Signup sign-in 3: make profile ( like add picture ) 4: add friends that joined 5: users put anonymously suggestions event 6: system each Day randomly choices randomly event for randomly 2 or more users 7: users that system choice get Web notifications on their mobile devices or email 8: each users see name and picture of the other friend that system choice to do the event with him then accepted or declined the event. 9: the users that pressed decline they lose points the user that pressed accept they get points. Points meaning: system suggest more randomly ev...
Note before bids : my budget for whole project is 10$ Requirements Development/ design Socail media website for mobile ( UI / frontend / backend ) Requirements functionalites 1: Design landing page 2: Registration Signup sign-in 3: make profile ( like add picture ) 4: add friends that joined 5: users put anonymously suggestions event 6: system each Day randomly choices randomly event for randomly 2 or more users 7: users that system choice get Web notifications on their mobile devices or email 8: each users see name and picture of the other friend that system choice to do the event with him then accepted or declined the event. 9: the users that pressed decline they lose points the user that pressed accept they get points. Points meaning: system suggest more randomly ev...
...structured sales data. Key Project Details: - **Cloud Platform**: The ideal candidate should have proficiency in Azure to run machine learning models effectively. - **Primary Goal**: The primary purpose of this data analysis is to enhance our customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data...
1. The main document is "Pen Test Project Plan" a Word file with my main content. 2. Use the Word document to complete and update the timeline "Pen Test Project Plan" in PPT. 3. Use the Word document to complete "Kodiak Schedule Detailed Version." Update content and make it look nice and professional.
I am seeking a professional graphic designer to create a logo for a Christian conservative organization named "Vote Biblically." Your task will involve creating a modern-style logo, capturing the organization's identity as a Christian conservative group. Please don't feel limited for creative ideas as I've given you artistic freedom. Feel free to explore ideas if there are more suitable and aesthetically pleasing options. The logo’s color scheme is open, since it was not indicated in the survey. You are free to choose appropriate colors that represent and complement the modern aesthetic and the brand itself. However, strongly saturated colors are discouraged. A successful candidate for this project ideally: - Has strong experience in logo d...
I am looking for a skilled developer to create a fully tested and secure website (frontend, backend + admin panel) with no bugs or issues using the MERN Stack. The key features of the front end design include a responsive design, user-friendly navigation, and custom animations. For the backend it would be clean, and fast high quality code with comments and good organisation and readability. The ideal candidate will have experience working with tight deadlines, provide constant high quality updates and be able to deliver quality work within a short timeframe. Bids: Please provide 3 links to your recent MERN/MEAN projects and provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Front-end Framework: React.js with and State Manage...
I am seeking a highly skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering ...
We have custodial crypto wallet app and system on cloud environment. Please create design document for that. Language Java platform Heroku for app side and DB side on AWS
I need a skilled social media expert to create an engaging Facebook page specifically designed for my retail business promotion. This will require creativity and understanding of the retail industry. The page should include a professional logo and banner. Key project tasks include: • Designing a unique, captivating banner • Creating a relevant, professional logo • Incorporating all essential business details Since I didn't mention specific elements, you'll have free rein on the design. However, please ensure that everything reflects the nature of my retail business. Experience in social media optimization and graphic design is a must. Understanding of retail customer engagement strategies will be an added advantage. Let your portfolio show simil...
See PDF below for details Dimensions suitable for Instagram and Facebook posts
Hi, If anybody is interested to create an Api using bearer token and consume it using web forms in asp.net c#. Thank you.
I am looking for a skilled freelancer, adept in ETL (Extract, Transform, Load) operations. In this project, your task will be to extract CSV files from an SFTP server and load them onto a SharePoint Document Library. Key responsibilities: - Source the data from the SFTP server. - Ensure accurate and smooth extraction of CSV files. - Successful Load of the data to SharePoint Document Library. Ideal candidate skills and experience: - Solid background in ETL operations. - Prior experience with SFTP servers. - Proficiency with working CSV files. - Familiarity with SharePoint Document Library.
I'm urgently looking for a web scraping expert who can help me gather information...Requirements: - Extract doctor names, contact information, medical service details, and additional data such as phone numbers, specialties, and participating plans. - The information should be pulled from three specific websites - Website 1, Website 2, and Website 3. Your deliverable: - The scraped data should be compiled into a CSV format for easy analysis and integration into our system. Ideal Skills: - Proficient in web scraping and data extraction - Advanced knowledge in handling and exporting data formats like CSV - Experience in scraping medical websites or similar domains would be a plus. Please bid only if you can start immediately and provide a q...
i need the same colors and theme of the website you did
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
I'm in search of a skilled machine learning developer with expertise in GPT (Generative Pre-trained Transformer). My ...goal is to have an AI model that can both correct and standardize postal addresses. The addresses will be provided in CSV files and the output of the model should be accessible via an API for integration into our system. Key requirements: - Proficiency in machine learning with a focus on GPT - Experience in addressing data correction and standardization - Ability to work with CSV files - Familiarity with API integration - Strong communication skills for seamless collaboration The ideal candidate will have a proven track record of developing AI models, particularly in the realm of addressing data, and be able to provide a detailed timelin...
I'm looking for a skilled freelancer to assist with a project on air pollution modelling using RStudio. The primary tasks for this project include: - Data Collection & Analysis: I need help in collecting relevant data on air pollution and subsequently analyzing it. - Result Visualization & Interpretation: After the data analysis, I require support in visualizing the results and interpreting them. The data that will be provided to you for this task will be in CSV format. Therefore, you should be well-versed in handling and analyzing data in this format. The ideal candidate for this task should have a strong background in data analysis, particularly in the context of environmental science or air pollution. Profi...
Setup issue for web. Data is not showing after create. Only work with ftp.
I require an expert in both C# and AWS to build a AWS Lambda function using .Net Core. The function should create a simple message in the SQS queue. The deliverables should include: 1. AWS Lambda Function: The AWS Lambda function should be capable of both Asynchronous processing and Dead letter queue. It should be written in C#. 2. Serverless Template: A serverless template is required that will be used by our gitlab pipeline to create the queue on AWS account. This template should be comprehensive yet efficient. 3. Gitlab YAML: Lastly, a gitlab yaml will be needed to facilitate the Lambda's deployment. Ideal Experience: - Highly skilled in C# programming - Extensive experience using AWS services - Familiarity with serverless templates - Understanding of Gitlab YAML f...
Insert a log box ti report errors or exceptions in a Unity APP
Customize a built theme with demo content
SUMMARY OF PROJECT: The purpose of this project is to allow multiple users to complete a daily spreadsheet (split into 3 tabs). All users will share and complete the same spreadsheet daily. I have attached the following, please review before you bid: - SPREADSHEET SYSTEM - BRIEF V1.0, PHASE 1 - SPREADSHEET SYSTEM - FLOW CHART - SPREADSHEET TEMPLATE
...seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tas...
**Your Bidding Amount is Final. No change allowed later**##Please read the attached file for details## I have an exis...email verification system better. Further, I want to dedicate one user as Admin. Admin gets all features like common users. Only difference is Admin can see user details like their username, email ID and registration date and can export it. No seperate Admin panel needed. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop any new website or web design. Just a basic look will do. I need to deploy it in the Linux server. You need to give me the full copyright of the software and source code. Also help me to deploy it in server.
SUMMARY OF PROJECT: The purpose of this project is to allow multiple users to complete a daily spreadsheet (split into 3 tabs). All users will share and complete the same spreadsheet daily. I have attached the following, please review before you bid: - SPREADSHEET SYSTEM - BRIEF V1.0, PHASE 1 - SPREADSHEET SYSTEM - FLOW CHART - SPREADSHEET TEMPLATE
I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share - Implement a user-friendly CMS system with Drupal - Ensure the system is easy to navigate for non-technical staff - Customise the CMS to suit our business needs Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.
I have Excel sheet in the are all products added with al...in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This will be regular work per week to create 10-15 images.
I need a wide range of details about accommodations ...about accommodations on , downloaded for analytical purposes. This data should include room availability, pricing, customer reviews, accommodation rate variances, photos, addresses, and phone numbers. - Essential Skills and Experience: 1. A strong understanding of web scraping tactics and data extraction. 2. Proficiency with 's platform and data structures. 3. Data organizing skills to deliver finalized data in CSV format. The outcome I envision is a well-organized CSV file that can further my research and analysis goals. A successful delivery will require attention to detail to ensure all requested information is included. Please bring forward your innovative solutions ...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...
I'm looking for skilled professionals to help me take my Stripe integration to the next level on my website. Key Tasks: - Add new functionalities to enhance the abilities of our current payment system - Implement subscription-based services using Stripe's tools Ideal Candidate: - Must have proven experience in enhancing Stripe integrations - A solid background in creating subscription-based services - A keen understanding of the technicalities of Stripe's tools and features. Your expert assistance will greatly boost the functionality and convenience of our platform's payment process. Looking forward to your proposals.
I'm in need of an expert who can create a few data entry forms for my project, specifically less than 10 forms. In addition, I require scheduling and shipping reports delivered in an interactive web page format. Requirements: - Data Entry Forms: I need less than 10 forms created for my project. They should be clear, easy to understand, and user-friendly. - Scheduling and Shipping Reports: I need these turned into interactive web pages. This means the data should be presented in a dynamic and visually appealing manner. Ideal Skills: - Experience in creating data entry forms - Proficiency in designing interactive web pages - Strong understanding of scheduling and shipping logistics Please ensure that you have the capacity to deliver o...
Design a "letter" sized flyer for Farmers Market Vendors using the following text. Be sure to add pictures and graphics. Logo is also attached- you can change the color of the logo to match your design. You can change the fonts and size of the fonts to accommodate size of the flyer and importance of the information. You must actually submit a completed flyer with the text, blank templates will be rejected. __________________________________________________________ Join the "Made in NC" Farm Stand & Country Store! Celebrate North Carolina craftsmanship by showcasing your products at the grand opening of our exclusive "Made in NC" Farm Stand and Country Store on July 7th! Limited vendor space is available, so secure your spot today. Why Join MINCA? The...
As the client, I'm needing a proficient, detail-oriented developer to assist with the creation of a Custom Post Type (CPT) on my website. The purpose of the CPT is to organize and structure the website's content more effectively. The project will require: - Creation of a new CPT to enhance the website's functionality and structure. - Configuring undefined fields in the Advanced Custom Fields (ACF). This task would ideally suit a developer with experience in content organization, CPT, and ACF fields configuration. Please note: specific details on ACF field configuration and CPT display preferences have not been defined by the client. Potential candidates should be prepared to offer their professional advice in these areas.
The project involves: 1. Go to an FTP location and get the last 10 csv files. Input example attached as '' 2. Combine those newest 10 files and map to new structure. Mapping example attached as '' 3. Save new file as 'BooksRunImport YYYY-MM-DD ", place in production folder "C:LakesideBooksClientDownloads" as tab delimited .txt, with an additional copy in folder as a backup. Output example attached as '' I would prefer it be written in NodeJS and compatable with v14.16.1 as I am familiar with how to edit the structure and I have other similar scripts running. I will supply FTP location and login as well as folder locations.
I'm looking for a skilled developer to create a one-time scraper for the TruePeopleSearch website. The scraper should focus on extracting addresses and phone numbers, and the output should be in CSV format. Key Requirements: - Develop a scraper for TruePeopleSearch - Extract addresses and phone numbers - Output the data in CSV format Ideal skills and experience for this project: - Proficient in web scraping - Experience with scraping tools and techniques - Proficient in CSV formatting - Understanding of data extraction from websites
