本人是自僱人士。一向也有一個programme取數據運行來處理我嘅工作需要。現在要開發多一個程式處理新數據。用VBA或Python寫都可以。主要係用excel工作
Translating a spreadsheet list of terminologies (roughly 5,053 lines of file descriptions) from Chinese to English. Our request turnaround time is early this week. See below for an example of the project: File Description Pages 1 华英物回记账凭证2010年8月 1-24 第1册共1册 105 2 华英再生利用有限公司记账凭证2010年3月 1-20 第1册共1册 79 3 华英物回记账凭证2011年3月 1-23 第1册共1册 155 4 江苏利华铜业有限公司年产10万吨再生优质铜杆项目节能评估报告 60 5 漆包机说明书 549 6 利华铜业增值税发票扣税凭证2014年4月份 195 7 合格证明书 ...
大家好，我叫‘马克’，我是一个英国人 I would like to gather information about 100 companies in Dongguan, Guangdong, China, including: 1. 公司名 2. 地址 3. 城市 4. 省 5. 国家 6. 电子邮件 7. 电话1 8. 电话2 9. 手机1 10. 手机2 11. 传真 12. 网站 13. 来源 14. 公司简介 15. 招聘职位 I include the spreadsheet to complete here. **** NOTE: The successful Freelancer will state the top 10 job recruitment sites that they will use to gather information in their bid please. INSTRUCTIONS: 1. On any of the popular job-listing websites, locate details of an employee (company profile) 2. Complete the company profile columns B - M 3. Include any links to profiles on the job site (the source) 4. List the number of vacancies the employer is c...
簡單的數據鍵入，只需鍵入到一個簡單的Excel電子表格 可以在家裡工作，大約一個星期時間的工作可以完成 薪酬5,000元，我會向您發送電子表格樣本給你電子郵件看看是否對工作感興趣
项目： - 一个牙医软件模块； - 部分功能基于开源控件实现； - 开发环境为C#, MSSQL Server, MS Access (MDB)； - 1.1 版本已经完成并在使用； - 现按照用户要求有所改动； - 改动分为2个阶段，1.2版本和2.0版本； - 1.2版本预计一个月内完成； - 2.0版本预计二个月； 要求： - 熟识C#，.NET， MSSQL，MS ACCESS； - 使用第三方控件经验； - 懂看简单英文需求； 项目本身是加拿大外包的，我人在东莞，可以到我这里开会，也可以到深圳开会，让你了解该程序和其需求以便报价。 有兴趣的，请QQ 1073158942 联系，或电 15820998667 （何生）
将网上医院资料（名称，地址，电话）输入excel spreadsheets 大约有4000医院笔资料
需要 接过IB(interactive brokers)的case 用VBA建立过足以交易的程式 懂中文 将别人未完成的项目给完成 需要看得懂别人已写好的程式码 和我的需求之间的关係 具备编写IB 软件的能力 目前我需要的功能是 部位管理 和 部位显示 以 及交易过程纪录 修復已写好 但不能运作的资料输出功能 我希望能先讨论内容 我会尽量说明现有的文件与我的要求等等 再来讨论价格 付费机制 以及我能拿到的时间
Operating Theatre Scheduling Problem(手术室调度问题)
... 10,企业爱心精神体现之力作 倾情回馈社会 爱心“香”传 3维动画 Dressing Perfume The topic of the fresh: We want to express our fashion brand and luxurious by sharing the desigh trend of perfume around the world. Scene1: In a garden, flowers are blossom, dewdrops are slowlly rolling on the leave, the sun is shining on soft sensitive grass and trees(Simililar). Scene2: Extracting the essence of the above natural items by unique effects, all the extracting items are getting together to be the perfume, it looks like a human body. Scene3: Liking a lady dressing her headwear, her clothes, her scarves, the perfume body dressing her container as well, including the bottle cap, patten and design, dimante, etc... Scene4: Show the completed perfume, just like a beautiful woman showi...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high...
I'm seeking an expert to merge and de-dupe around 700 account / contact records to enable us to obtain a clear deduped prospec...encapsulates around 10 key fields: Customer type and association, Store Name, Contact Name, Email, Phone, Mobile, Email, Address, Job Title and notes. Ideal Skills and Experience: - Proficiency in Excel and other spreadsheet tools - Experience with data cleansing and deduplication - Attention to detail and accuracy - Experience with handling sensitive data securely Tasks Involved: - Merging duplicate contacts (based on a specific criteria which I will provide - manual deduplication may be required) - Removing duplicate records while retaining only unique entries - Ensuring no loss of data during the process (this is essential. ...
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
I need assistance with data entry. I have printed documents containing text data that I need to be accurately transcribed into a spreadsheet. Key Requirements: - The data is text-based and will require accurate transcription. - The data will be provided in printed documents. - The output format required is a spreadsheet. Ideal Freelancer: - Proficient in data entry with high attention to detail. - Experienced in working with printed documents. - Skilled in using spreadsheet software. Your role will be crucial in ensuring the accurate and efficient transfer of the information from these printed documents to a digital spreadsheet. The ability to maintain precision in transcription is key.
I require a freelancer who is savvy with setting up social media and Gmail accounts. Create 50 Google email (gmail) accounts with the names in a provided excel spreadsheet. I have not attached it here, I will provide it when the project starts, as I don’t want to make them public to others then the person that will create the accounts. It is real accounts for real people that do not use gmail today, and that do not have a social presence. In the spreadsheet there is also information about the backup email to be used for PW resetting etc. Create 50 Facebook and Instagram accounts matching the google accounts. Ad profile pictures. Ad 20 to 30 random pictures to each account. Follow 30 to 50 people for each account. Make the profiles otherwise private. Make half of th...
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detai...
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
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!
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.
I am looking for a proficient ASHE software expert to help with data analysis, report generation, and implementation support. - Task Overview: - Analyzing data and extracting meaningful insights. - Generating detailed and informative reports. - Providing implementation support for the software. Your experience in the field and familiarity with ASHE software will be crucial in ensuring the success of this project. Please provide evidence of previous similar projects you've undertaken.
First task is below 1) 1200 Youtube video link of recipes will be provided in google spreadsheet. for e.g each link with be 2) the person need to paste the link at 3) Cut and paste 3 windows record and 1 recipe image screenshot (from youtube) and then upload in a software ( a paid version will be provided) 4) expect to finish 1200 recipes in 60-100 hours. Please quote following if you want to try this project 1) how much for updating 1200 recipes as whole project? 2) How much is per hr rate?
You can see in this google drive folder: I have two spreadsheets: municipalities and duplicates. The duplicate spreadsheet contains all of the records in the municipalities spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am looking
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...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
...experienced Data Scientist who is particularly adept in R studio. The project involves approximately 3.5 million entries from an accounting firm's datasets and should follow the CRISP-DM framework. Responsibilities: - Data cleaning and preprocessing: Ensuring data is correctly formatted and that outliers, missing values, or inaccuracies are dealt with. - Exploratory data analysis: Extracting insights from the datasets, visualizing trends and discovering correlations. - Model development and evaluation: Carrying out predictive modeling and anomaly detection. Specifically, identifying potential financial transaction anomalies. More about the project: The goal is not predefined and can range from predictive modeling to anomaly detection based on ...
I am experiencing a problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I ente...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 successful...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thou...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
I have some data that requires entry from spreadsheets into a database. I specifically need: - A meticulous professional who understands the importance of data accuracy. - Someone who can efficiently convert the data on these spreadsheets into a structured format suitable for database management. Your responsibilities include: - Transferring data from spreadsheets into our database system while ensuring data integrity. - Performing data cleaning and verification to maintain high quality and accuracy. Ideal candidates will possess: - A proven track record in data entry, especially from spreadsheets. - Experience with database management and understanding of data cleaning and verification. - Strong attention to detail and ability...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
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 have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
This is a Python-based project involving LinkedIn connections parsing using a co...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 am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tabular format.
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
As the client for this project, I urgently require an expert in VBA.
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 need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel format:
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 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 the area the ima...
Looking for a skilled freelancer who can develop a simple process of click few buttons and select input file to extract numeric digits from JPEG images hosted on a cloud server using the Google Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed
I'm looking for an expert in creating comprehensive trading spreadsheets. This task requires not only solid experience in spreadsheet creation but also a deep understanding of cryptocurrency trading. Key Requirements: - Real-time data updates: The spreadsheet should allow for live updates of cryptocurrency trading data. - Performance tracking: It should have features to track trading performance over specified time periods. - Profit/loss calculation: It should be equipped with formulas to calculate profits or losses accurately. - Automatic multi-spreadsheet referencing: It needs to be able to link data across multiple spreadsheets automatically. The created spreadsheet should support all available cryptocurrencies, therefore a broad...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is...
...PDFs that I need to have data extracted from as well as images saved. The main purpose of this task is to extract the data from the PDFs for further processing, while also saving the images contained within for future use. Key Requirements: - Extracting data: The PDFs contain important data that I need to have extracted and organized. The data should be converted to text and saved in a spreadsheet. - Image saving: The images contained within the PDFs also need to be saved in a usable format. Please note that there are no specific requirements for the extracted text and images other than the data extraction and image saving. Ideal Skills and Experience: - Proficiency in PDF data extraction and image saving - Experience wit...
...these reporting processes to optimize the use of my data, improve efficiency, and determine profitability. Specifically, my current reports draw from spreadsheet files that need to be effectively manipulated and interpreted to gain actionable insights. I'm looking for a freelancer who can provide solutions to automate: - Data Extraction: Extract data from spreadsheet files and ensure it is prepared for analysis. - Data Analysis: Analyse the extracted data to determine information of relevance and note patterns, trends or anomalies. Freelancers bidding on this project should have the following: - Strong data analysis skills with a keen eye for detail - Proficiency with Excel and similar spreadsheet applications - Ex...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
