Excel macro yahoo historical data 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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.
I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID
I'm in need of a cross-platform (iOS and Android) mobile app that can track GPS via a specific tracker and set up geo-fencing. The main functionalities I require include: - R...tracking: The app should be able to provide live updates on the tracker's location. - Geo-fencing alerts: I need to be notified when the tracker leaves a pre-defined location. - Historical route data: The app should maintain a record of the tracker's past routes. Additionally, I want the app to have user authentication features via email and password. Ideal skills for this project include: - Mobile App Development (iOS and Android) - GPS and Geo-fencing integration - User Authentication implementation - Experience with creating apps with real-time data tracking - Knowledge of ...
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.
I'm seeking a...science-driven, environmental studies data related to modern history. Your tasks will include: - Finding and compiling information based on specific queries I pose - Ensuring the data is strictly factual and devoid of personal bias or interpretation - Focusing on the intersection of environmental studies and modern history Ideal candidates will have: - Strong research skills - a "lack of" interest in the research subject specifically as to not accidentally apply bias - An ability to comprehend and distill complex scientific data - Excellent attention to detail - A commitment to delivering objective, fact-based information Your goal will be to help me make sense of the historical context of our current environmental challenges,...
I'm seeking a freelancer adept at data entry, specifically from digital PDFs into an Excel spreadsheet. The task involves extracting solely text data from these documents. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experienced in data entry from PDFs Expectations: - Accurate and timely completion of the task - Ability to maintain data confidentiality - Effective communication for any clarifications needed
I'm seeking a trainer specialized in beginner-level medieval knight sword techniques for in-person sessions. The focus should primarily be on sword techniques. Ideal Skills: - Proficient in historical sword techniques - Experienced in teaching beginners - Able to conduct in-person training sessions Your primary responsibility will be to impart sword techniques to complete novices, ensuring they receive a comprehensive introduction to the discipline.
I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start proposal with PREMIER
I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly beneficial.
I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.
...10 compatible macro for an Online 2D Pixel Art game. The macro needs to control a player and manage various tasks, including mining, fighting spiders, and handling mine collapses. Key Features of the Macro: - Control a player near the screen center - Mine a rock wall with varied inputs - Move to the side and repeat mining - Return to the original position after a few cycles - Handle random events like spiders appearing or mines collapsing - If a spider appears, swap weapons and attack it - If a mine collapses, quickly head to the exit, re-enter and return to original position - Implement dynamic movement patterns to avoid detection from anti-cheat systems/game Admins lurking. Detection Methods: - Use pixel color detection to identify events Additional Requirement...
I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.
I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.
I need a skilled developer who can gather comprehensive trading data from various free sources and convert it into a REST API and Web Sockets for easy data retrieval. The data should encompass: - Forex - Cryptocurrency - Metals - Indices - Oils Preferred data sources are Yahoo Finance, Alpha Vantage, CoinGecko and any other reliable free source. The ideal freelancer should have: - Proficiency in API development - Experience with data collection and manipulation - Familiarity with trading data - Knowledge of the mentioned data sources Please provide a bid only if you have the required skills and experience.
Hi there I'm seeking a professional who can help me gather data from 100 UK websites. This data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. ...
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...
I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of...specifically cover the experimental results presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demonstrate experience in analyzing academic papers and their...
...Ads and TikTok Ads to retrieve real-time data (e.g.: campaigns, metrics, budget). Create an OAuth2 authentication system for these platforms. Real Authentication System: Replace the current mock with a secure system (e.g.: Auth0, Firebase Auth, or JWT + OAuth2). Add permission controls (e.g.: admin, analyst, client). Real-Time Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Create jobs to automatically update campaign data (e.g.: every 5 minutes). Store metrics history for temporal analysis. Automatic Insights Calculation: Develop algorithms to identify trends (e.g.: "CPA increased by 20% in the last week"). Report Export: Generate PDF/Excel with filter...
I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.
I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.
Must be able to create chibi caricatures of important people and historical scenes for coloring. Examples below of Chibi images. Prior experience required ,small,lustre,wall_texture,product, History and War.
...Handle random sales patterns Accurately predict sales & demand fluctuations Integrate with our in-house software through API to pull real-time inventory & sales data Provide actionable insights to prevent inventory shortfalls & overstocking. (if possible, model will tell the reasoning behind the predicted numbers) Key Challenges & Requirements ✅ Sales data is NOT linear or seasonal – our sales pattern is highly irregular, meaning a simple time-series model like ARIMA or SARIMA won’t be effective. ✅ The solution must incorporate multiple real-world factors affecting demand. ✅ We have an in-house API that will provide real-time data – you need to work with our developers to connect the forecasting model to this API. ✅ High accura...
I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail
I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.
Subject: Power Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in ...
I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe
I'm looking for an AutoHotKey, PowerAutomate,UIPath or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: 0- Create a simple dialogn box with a) Button Start/Stop mouse capture b) enter the name of target program (text box) 1- capture mouse events for 10 second and save in a file ( precisely , clicks, moves, click+move etc etc , with timestamps) 2- play all these mouse events save in a file on a target program (word, paint, canva, etc etc) target program will be specificed 3- The events recorded in file must play exactly on the target window . This is simple 1 hour job, and might be more next week.. use any tool of your choice
Produce an anniversary/historical video for a nonprofit organization
I am seeking an SEO specialist to enhance the search engine ranking of our tax law firm website. The primary objective is to improve our visibility and ranking on all relevant search engines, with a particular focus on Google, Bing, and Yahoo. We only want to see expert level people familiar with California and will do back links to high profile media in the US and not a bunch of back links to UK and INDIA. We need professional level talent that will achieve high results. We are professionals that are the top of our industry and need to have recognition and ranking accordingly. Key Responsibilities: - Implement on-page SEO strategies to optimize our website content and structure. - Execute off-page SEO techniques to increase our site's authority and relevance. Ideal Skills a...
Tenho umas tabelas de excel exportadas de um software para as quais precisava de criar Tabelas Dinâmicas e Dashbords para análise dos respectivos dados. Em resumo necessito de um freelancer para me esclarecer e ajudar a desenvolver uma forma de apresentar estes dados e poderem ser analisados por utilizadores muito básicos de excel.
...Instagram, and more. - AI-powered analysis to identify and highlight patterns or connections in the gathered data. - Multiple data export options including CSV, PDF, and other formats for easy reporting. - Historical data retrieval to access information that has been deleted or altered. - User-friendly interface that allows investigators to easily navigate and use the software. - Cross-platform compatibility to ensure the tool works on different operating systems. - Anonymity features to conduct research without revealing the investigator's identity. - Advanced search filters to narrow down searches by date, keywords, and other criteria. Ideal Skills: - Proficiency in software development and data analysis - Experience with creating surveillance ...
I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a fresh perspective is needed. 3. I don't need a lot ...
I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. I have added an explanation video and sample excel data sheet to the files. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analy...
...Diagnosis Data Collection: Manual input: Work absence history (dates, duration, reason). Self-reported workload levels and stress indicators. Integration with external sources: Wearables (smartwatches, fitness bands) to collect heart rate variability, sleep patterns, and daily activity. Email communication analysis (Gmail, Outlook) to assess volume, response time, and tone using AI-based sentiment analysis. Integration with HR management platforms (e.g., Workday, BambooHR) to fetch work schedules and performance reviews. Predictive Analysis: Machine learning models to identify correlations between absenteeism, workload, and employee well-being. Classification of work absences into "legitimate," "potential burnout risk," or "suspicious absenteeism." R...
I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.
I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.