Open office calc use excel macros työt

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more d...

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project i...

I'm in search of a creative freelancer who can put together a 2-minute video invitation for my birthday party. The theme of the party is hackers, and I want this reflected in the video. Key Elements: - You'll be required to incorporate personal photos and a...custom text messages in the video. This will help to make it more personal and engaging for the recipients. Ideal Skills and Experience: - Experience in video editing and production. - A knack for creating funny, engaging content. - Ability to work with personal photos and integrate them seamlessly into the video. - Comfortable with customizing text to fit the theme and tone of the video. I'm open to ideas and suggestions that can elevate the project and make it even more memorable. Looking forward to seeing...

I am looking for a sizable tabular dataset that consists of over 50,000 records and more than 100 features. The data should include a balance of categorical and numerical data types. Being specific, it could be related to the Healthcare or finance industry. It could be used for Data analysis, machine learning. I am open to diverse datasets that could support various investigations. The ideal freelancer for this project would be someone with impressive experience in data gathering or data creation, particularly in the healthcare field. They should have good knowledge of categorical and numerical data, and a good understanding of sizable databases. They should also be committed to maintaining the integrity and confidentiality of the information.

...schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a comprehensive Excel spreadsheet that includes the name and address of each school, along with their exact distance from the nearest Tube sta...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I am in need of someone to pick up an item for me. In this case, it is a dress from my office address. Key requirements: - Pick up the dress from my office address - While picking up, make sure to message the business and handle any needed deposits Skills and experience: - Good communication skills and reliability for the necessary messaging and handling of deposits - Prior experience with handling and ensuring safe pickup and delivery of items

The aim of this project is to commission the delivery one premium theme for Open Journal Systems (OJS), an open-source software platform for the management of peer-reviewed academic journals. This premium theme will enhance the visual appeal, functionality, and user experience of journals hosted on OJS, catering to the needs of scholarly publishers, editors, authors, and readers. I am open to discussing and revising the proposed pricing if necessary.

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

Hi. I have an app that is becoming very popular. We created videos on how to do certain things with the app to help users get started. The videos are now out of date. We would like to have ...videos on how to do certain things with the app to help users get started. The videos are now out of date. We would like to have a professional video created, (preferably with out spoken words), to accurately describe how to accomplish certain tasks within the app. We anticipate each video will be 1 to 2 minutes long. We want to start with one video to see how this goes, but could definitely use 12 or more to accurately help users. The app is for golfers and golf tournament managers. Fairly straight forward, but also powerful and can be complex. It's on iOS and Android, and ...

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Single Stop BOL's....

I am looking for a proficient web developer who can build an engaging interactive website for our medical office. This website will be used primarily for patient check-ins and scheduling appointments once they reach to office for the treament. Below are some key requirements: * Implementation of an online appointment scheduling feature that is easy to navigate for patients. * An integrated patient check-in system. * A feature providing current waiting time estimates to patients. * Send SMS to patient and doctor for the wait time. In our pursuit to facilitate seamless and efficient service, we need the website to collect patient contact information during the check-in process. Therefore: * The website should be designed in a way that allows patients to update their cont...

Hello! I have created a custom reinforcement learning (RL) environment using open ai's gym. I would like to transition this project from something that is readable by myself only, to a wider audience. The environment puts the agent in control of an F-16 aircraft. The task is to maneuver through "Tunnel" without hitting the walls. With some minor debugging and package install, the code should run. Here's what I'd like help with: 1. Simplification. I made this for my research. Thus there are likely portions that could be cut if it's a general environment. Also open to reorganization of the environment if there's a better way to accomplish. 2. "Branding." My plan is to make RL with high performance aircraft as accessible as A...

Expert in MS excel for automation of sheets

Am nevoie de extragerea unor anumite date dintr-un fisier pdf si exportul intr-un excel. Daca urc un pdf intr-un folder trebuie extrase anumite date si importate in excel, daca apare ualt pdf, va fi extras la fel, daca modific un pdf existent date trebuie sa se modifice in excel

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, including advanc...

...staging environments - Data for training and testing the model **Constraints and Assumptions:** - Constraints: Limited initial training data for the AI model. - Assumptions: The system's existing infrastructure is sufficient to support the AI integration. **Risks and Mitigations:** - Risk: AI model fails to accurately interpret complex queries. - Mitigation: Implement comprehensive testing phases, use advanced NLP techniques, and possibly retrain the model with additional data. **Approval:** - Project approval and final sign-off by the IT department head and project sponsor. This scope document outlines a clear path for the candidate to demonstrate his AI skills effectively within the context of your current technological setup. The focus on NLP to enhance query capabili...

I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals.

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry clearly indicat...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This proj...

I am in need of a highly skilled and qualified Virtual Assistant who has proficiency in communication, social media and content creation. This person will need to h...experience and skills in managing, strategizing, and creating content for various social media platforms. - Computer Proficiency: Basic knowledge to operate, troubleshoot, and maintain computers. Qualifications: - Proficient in Hindi or Punjabi and English in terms of speaking and listening - Proven experience with Microsoft Office The work schedule is standard office hours (9am-5pm) as per Mountain Standard Time zone. This position requires a candidate who can expertly use time management to complete tasks within this timeframe. I am looking for a devoted individual who is ready to bring his/her A-game...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I am in need of a Danish-speaking Administrative Assistant who can handle both written and spoken communication in Danish. The work primarily invo...phone-call handling and translating documents. Key Responsibilities: - Fluent in Danish (both written and oral) for phone-call handling - Capable of translating documents from English to Danish and vice versa - Pro-active and prompt in responding to queries and requests Ideal Skills: - Excellent verbal & written communication skills in Danish and English - Prior experience in admin assistance, office work or related areas - Ability to multi-task and excellent organizational skills The assistant is expected to work for less than 10 hours per week. If you are efficient, hardworking and meet the above requirements, I would love to ...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. I...

...the basics of computer skills, Microsoft Office applications, and Internet and email usage. Ideal candidates will: - Have experience in teaching or designing curriculum, particularly in computer skills or IT - Have a clear understanding of the beginner level explanations suited for high school students - Be knowledgeable in Microsoft Office and basic computer technology (latest version of Microsoft office) Primary Tasks: - Create comprehensive lecture notes covering basic computer skills - Develop content for Microsoft Office applications - Develop sections for hands on practice sessions. - Create explanations on Internet and email usage suitable for beginners - Create 3 assignments for lecture notes & an assignment for each Microsoft Office...

As an ambitious business that values the insights of potential customers, I'm looking for an expert survey creator. The purpose of this survey is to execute detailed market research. GCC-Based Family Office Investment Strategies in Different Asset Classes for 2024 1. Introduction Family offices in the Gulf Cooperation Council (GCC) region manage significant wealth and play a crucial role in the region's financial landscape. Understanding their investment strategies across various asset classes in 2024 can provide valuable insights into market trends and potential opportunities. This research aims to analyze the investment strategies of GCC-based family offices for the year 2024. 2. Research Objectives • Identify the primary asset classes targeted by GCC family offi...

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...trasladar 50 facturas en formato PDF a una hoja de Excel. Las facturas contienen información vital para mi negocio, por lo que es crucial que esta transcripción sea realizada con precisión. La información que necesito en mi hoja de Excel incluye: - Fecha - CIF - Nombre de la empresa - Importe Requerimientos: - Conocimiento y experiencia en el uso de Excel. - Habilidad para transcribir información de forma precisa y rápida. - Habilidad para trabajar con documentos en formato PDF. - Comprensión de la importancia de la confidencialidad en el tratamiento de información empresarial. Adicionalmente, necesito que la información transcrita sea organizada y categorizada por fecha. Finalmente, necesito q...

...intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Experience in developing online exam systems or similar educational platforms will be a strong advantage. A thorough...

...Brokerage website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge o...

Need a logo for our New Brand "BlissWave" which is going to be office related product brand. I have attached a sample logo for your reference.

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

I'm in the initial planning stages of a commercial roofing project, specifically focusing on flat roofs. I need to find someone who can help with research of plans and put together bids for the following types of buildings: - Office buildings - Retail spaces - Industrial facilities - Government contracts Ideal candidates for this job should have: - Extensive experience in commercial roofing, particularly with flat roofs. - Strong research skills to identify suitable plans and materials for different types of commercial buildings. - Excellent communication skills to put together professional, detailed bids. - An understanding of the bidding process and pricing structures for commercial roofing projects.

...Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of QR codes and 1D barcodes. If you have prior experience in developing sim...

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look forward to reviewing your bid!

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

Saludos, busco un experto en vba excel para la solución o complementación de un proyecto. Adjunto dejo una imagen del userform que funcionará cómo buscador y modificador de una base de datos en excel, la principal necesidad es lograr que el listbox genere la data con sus respectivas columnheads cómo se muestra en imagen, y que a su vez en el apartado del buscador, se pueda filtrar por el campo requerido y se genere correctamente la nueva fuente de datos. El error que se me ha presentado es que por usar el método .rowsource para mantener los encabezados, no me permite utilizar el método .additem.

I'm in need of a competent executive assistant fluent in English and Spanish. Your day-to-day tasks will include email correspondence, managing my calendar, and arranging travel. You'll also take up other responsibilities such as: - Making customer calls - Follow-up with clients - Preparation of documents - Posting on our social media platforms You must be proficient in using Microsoft Office Suite, Adobe Creative Cloud, and social media management tools. Experience in a similar role is a definite advantage. Your strong organizational skills and ability to juggle multiple tasks simultaneous will be crucial in this position.

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document cr...

En busca de un analista de datos freelance, estamos emocionados de ofrecer una oportunidad única para aquellos apasionados por la analítica y el crecimiento continuo en el dinámico mundo del Multinivel (MLM). Si te entusiasma generar reportes precisos, limpiar y administrar tablas de datos, y tienes un sólido entendimiento de Excel, DAX, PowerPivot y tablas dinámicas, ¡este podría ser el proyecto perfecto para ti! Necesitamos un analista junior que no solo posea habilidades en análisis de datos, sino que también tenga experiencia comprobada en el análisis de datos específicos de empresas de MLM. Es crucial que puedas interpretar planes de compensación y entender profundamente los volúmenes de ...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000

I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Familiarity with...

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to detail will be prized.

I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified conditions (Multiple conditions) are ...triggered when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and excel under limited supervis...