Excel data validation extraction työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
...application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of user-friendly UX desig...
I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be ...
As a busy individual managing both personal and business activities, I am in need of assistance to streamline ...crucial information: specifically, the name and phone number for each contact. To accomplish this task smoothly and efficiently, the following skills and experiences will be beneficial: - Proven experience with data entry tasks, specifically involving contacts management. - Expertise in database management, data input, and validation. - Detail-oriented and meticulous approach to handle large volumes of data. - Familiarity with digital tools for document scanning. - Proactive communication to clarify any ambiguities in source data. This project is your chance to leverage your precise data management skills while helping to improve my ...
I'm in need of a website that is secure and provides my clients with the ability to register and login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems would also be a key advantage.
...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have...
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
...of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous....
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
...an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including adva...
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right fit with the necessary expertise.
I'm looking for a skilled developer to create an image texting software that can run on desktop computers exclusively. Ideal Skills: - Proficiency in image recognition and text extraction - Experience with software development for desktop applications - Ability to work with English language software
I'd like to extract the phone numbers of real estate agents from a particular website Key Requirements: - Extract agent contact information Ideal Skills and Experience: - Proficiency in web scraping - Experience with data extraction and automation - Strong understanding of data privacy laws and regulations Please note that the data is intended for internal use only and will not be shared with any third-parties.
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents ...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents ...
I am in need of a skilled developer who can create a functional scraping tool for me. The purpose of this tool is to download JPEG product images from a specified URL that increments numerically. ...continuously changing URL (i.e., www.****/asdasd/1234 then 1235, and so on). - Ability to tweak URL structure according to my needs. - Images must be saved in JPEG format. The ideal candidate for this task: - Has experience in web scraping and dealing with dynamic URLs. - Understands how to name files after the URL page number. Please note that the key goal is to download product images, not data extraction or process automation. Hence, your proposal should focus on delivering this specific requirement. Your understanding of this project and relevant skills will be evident in y...
...development of an extension designed to interface with a specified financial website, which features dynamic data changes. The primary function of this extension will be to monitor the data displayed on the website's user interface (UI). When any alterations in this data occur, the extension should perform API calls to transmit this data to an API that stores it within a database. Additionally, there may be instances where the extension needs to make API calls based on UI events, retrieve data from the database, and display this information on the UI. There will also be certain situations requiring the extraction of data from external sources for storage in the database. The stored data will then be utilized by the exten...
...tasks: **Extracting data from images (Task 1a):** * You'll need to add a new function to existing code that can grab specific values from images stored on Google Earth Engine (GEE). * These values, representing features of the land, will be used to train a machine learning model later. **Creating a new feature (Task 1b):** * You'll write some new code to define a new feature based on existing data (called NDVI). * This involves creating a new class that inherits from existing ones to handle this specific feature extraction. **Training machine learning models (Task 2a):** * Using all the features you extracted in Task 1, you'll train different machine learning models for a client. * The client has collected soil samples, and you can potentially c...
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're...
I'm on...the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your propos...
I am seeking a proficient Python programmer who can create a web scraper for Lazada. Key Responsibilities Include: - Develop a Python program that will enter query in search box and scrape Lazada for the following data: product name, images, price, description, seller, and URL. - The scraper should be able to handle pagination plus also bypass captcha using 2captcha api Ideal Skills and Experience: - Proficiency in Python and web scraping frameworks. - Familiarity with the Lazada's web structure and data extraction. - Experience creating scrapers for e-commerce platforms. Website lazada .
...sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data ...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.
...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 closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation with AI Tools: W...
I need an experienced fi...should include detailed financial projections based on the provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid. Time is of the essence, and I need this completed within 24 hours. Please only bid if you are confident in your ability to deliver accurate results in this very tight timeframe. This needs to be done in 24 hours or less, it cannot be done a...
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accur...
I need a skilled professional to analyze a given trajectory in .xyz format and specifically extract the non-Gaussian parameter. i will help you to understand the work. Ideal Skills: - Experience in scientific data analysis and trajectory interpretation - Ability to extract non-Gaussian parameters - Proficiency in using tools for data analysis The task involves: - Analyzing the trajectory in .xyz format - Extracting the non-Gaussian parameter (specifically, the kurtosis, skewness, or other higher moments)
I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accur...
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
Um Trabalho, que foi nescessario fazer uma contagem de pessoas e lugares influentes, e Tambem somar e totalizar, contagem de votos e estimativa de média e total de pessoas e votos. Dando atratividade a alguns nomes mais influentes
...an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the document ac...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I ne...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks. Key Responsibilities: - Data Processing: You will be required to process data including but not limited to sorting, filtering, and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods ...
I am urgent...in need of a freelancer with skills in web scraping, data extraction and web crawling. Your task will be to gather specific information from an online directory of race events throughout the world. Key Responsibilities: - Set up a weekly automated web scraping process. - Extract and deliver the following data points: Event name, Event date, Event location, online registration page, contact form page, and contact information along with some other info that we can grab. Required Skills and Experience: - Proficiency in web scraping and data extraction. - Capable of setting up an automated weekly process. - Ability to perform the task ASAP. - Strong attention to detail to ensure accuracy of information. Please note that timeliness and dat...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
