Excel macro data manipulationpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
...affecting the sale of water heaters This project requires hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantag...
...- Support for bold, italics, underline, link insert, link remove, align, highlight, font size, font-family, tables, and more. - Support to format HTML tags automatically. Auto add/remove tags to make programmatic sense. Auto format text pasted from WordPress - Proper functions so that I can programmatically insert content in the editor. - Quickbar to show relevant tools, easily. Basic image manipulation like alignment and size. Preferably the toolbar is inline. - Support to have it as fullscreen with a click of button. - and anything else that free version of TinyMCE can implement - No libraries. Libraries make things heavy, and I would want a lightweight techstack. You can use jQuery, since WordPress already uses it, but any additional library would be a big no-no. - Functions: ...
...The ideal candidate would be proficient in market research with experience in the specific industry, customer profiling, and an understanding of energy appliances. Knowledge of the local market is crucial. Your insights will shape our market strategy, so accuracy and attention to detail are paramount. Deliverables: Comprehensive report with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project....
Necesitaria el código para integrar en mi web de un formulario que los clientes puedan rellenar y me vuelque los datos a un excel de google, o a varios pdfs
I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type...
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I have an Excel sheet that needs to be filled with a combination of text and numbers. The sheet is not too large, falling within the 10-50 rows and columns range. I would also like the data to have a specific formatting, including the use of particular fonts and colors. Key Points: - The task mainly involves typing text and numbers into an Excel sheet. - The sheet consists of 10-50 rows and columns. - The final output requires specific formatting with designated fonts and colors. Ideal Skills and Experience: - Proficiency in Excel and data input. - Understanding of basic design principles for formatting. - Attention to detail to ensure correct typing and formatting. - Able to follow specific instructions for fonts and colors. Candidates with experienc...
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a f...
I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.
I need assistance decrypting excel, word and pdf files effected by virus Key Requirements: - Decryption of affected files - Timely delivery due to the urgency of the task Please note that I'm looking for a professional with great experience in this field as I need my files back as soon as possible.
I have a project that involves typing text and numbers into an Excel sheet. - **Data Type**: The data is a mix of text and numbers. It's nothing overly complex - just straightforward typing. - **Sheet Size**: It's a medium-sized spreadsheet, containing 10-50 rows and columns. - **Formatting**: I don't need fancy formatting. Just simple data typing. Ideal candidates for this project would: - **Experience**: Demonstrated experience with data entry tasks in Excel. - **Accurate Typing**: Attention to detail is crucial, as the data is critical. - **Efficiency**: Completing the task in a timely manner is important for this project. Looking forward to working with you!
I have a set of handwritten notes that I need to be typed into an Excel sheet. The data is purely text - no numbers or dates. The final Excel sheet should have basic formatting applied. This includes: - Consistent font and text size - Proper spacing between entries - Clear cell borders Please ensure that the formatting is logical and enhances the readability of the information. The content itself is quite straightforward and does not require complex analysis or manipulation. Ideal skills: - Proficiency in Excel and data entry - Attention to detail - Basic understanding of formatting in Excel
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.
I need a proficient data analyst who can effectively perform basic operations such as calculating totals, averages, and percentages on my Excel sheet. The ideal candidate should have a strong background in Excel data entry and analysis and a keen attention to detail. Efficient data formatting to produce clear and concise analysis results in a spreadsheet format is crucial for this task. Please, only bid if you are confident in carrying out these operations accurately and effectively.
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 i...
...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 - Strong kno...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
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 form...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
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.
With a pressing need to secure our Laravel and MySQL voting system, we are looking for a skilled professional who can rectify the voting manipulation issue we are currently experiencing. Here's what we need: - Expert in Laravel and MySQL - Experience in securing web voting systems - Proficiency in server request handling is crucial. We have already introduced a new security measure related to server request handling, but our voting results are still being tampered with. We need an expert to identify the lacunae in the existing system and beef it up to prevent any future breaches. In addition to a strong technical skill-set, your knack for problem-solving would be greatly valued on this mission to restore integrity to our online voting system.
I require a savvy Excel specialist who can effectively perform data analysis for a small volume of data. The data set to be input and analyzed has less than 500 entries and is composed of both numerical and textual data. Ideal Skills and Experience: - Excel proficiency - Previous experience with data analysis - Ability to handle both textual and numerical data The task will involve data entry and thorough data analysis to extrapolate insights from the dataset. Accuracy, attention to detail, and a keen analytical mind are essential qualities for this project.
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 need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skill...
*READ the attached .docx it's better explained. * For this project, this is just meant to run on any given localhost machine as a project. I'm in need of a skilled developer to build an application for a project. The main focus will be on exploiting the 'Academic...which will be provided. Key Functionalities: - See .docx (My Approach) Section This is a project-based task, so I don't think there's a need to implement complex user authentication or intricate access control. Candidates with experience in web-based application development using MySQL, MongoDB, Neo4j will be ideal for this project. Understanding of library management systems and dataset manipulation will be highly valued. Your expertise in creating user-friendly interfaces will be instrument...
...Photoshop expert who can help me with high complexity image manipulation tasks for digital media. Key Tasks: - Merging Images: The project involves merging multiple images seamlessly. This requires great attention to detail and a keen eye for aesthetics. - Creating New Elements: You will be tasked with creating new visual elements within the images that are not present in the source material. This involves a high degree of creativity and skill. - Overall Image Transformation: The goal is to transform the original images into something new and visually compelling, suitable for digital media use. Ideal Skills and Experience: - Advanced Photoshop Skills: You should be an expert in using Photoshop, particularly in complex image manipulation tasks. - Creativity: A strong sen...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...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. Google Vision API supports offline asynchronous batch image annotation for all features. The Google Vision API supports offline asynchronous batch image annotation for all features. https://cloud
I am looking for an expert who can Photoshop a picture of one of my best friends to resemble a realistic Black Panther. Key features that must be incorporated into t...features that must be incorporated into the edited picture: - Sleek black fur - Claws on feet (you can make them paws) - Intense glowing cat eyes (keep them the same color as her human eyes, which are blue) - Catlike face that has fur - Panther ears and tail Ideal candidates should have: - Superior Photoshop skills - A keen eye for detail to ensure realistic representation - Experience in photo manipulation involving animal features. Your creativity will play a crucial role in transforming a human into a humanoid Black Panther, whilst maintain a realistic appearance. Show me what you can do! Attached is the pictu...
...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 on gene...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
...proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and c...
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
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.
