How to pull data from a master sheet in excel 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.
Task 1. Take these pages away from the HTML- sitemap: Al – käyttöehdot Al – Kiinteistönvälittäjän kilpailutus Al – kiitos Al – rekisteriseloste Al – tulos Al – Välityspalkkiovertailu Task 2. Enable our text-logo () to all affiliate pages. It is not enabled on our affiliate templates now.
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.
Each year we do a t-shirt for our American Football event called Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. Project details are below. 1. Deliverables - 1 editable illustrator file with illustration for front of shirt 2. Last year's shirt is attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the football should match our previous styles, I will send a zip file with referenc...
I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.
...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-fr...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
I have a set of old drawings in IMG format that I need converted to PDF format that is acceptable to a building dept for upgrade permits. We want to add a deck in front of the garage which will be the width of the garage appx 19' x 15'. If you have experience in architectural drawing, drafting and design, and proficiency in working with PDF formats, then you're the freelancer I'm looking for. Unfortunately, I do not have specific features or elements that I want to incorporate in my deck plan. It'll be great if you can provide some suggestions on possible seating. I'm only looking for help with the drawing and end result would be something I can submit to city of San ...
I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI deve...
I have an html f...have an html form php file on my server. I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data i...
I'm looking for a skilled developer to create a Defi similar to Dextool/Dexscreener. The project will require a comprehensive understanding of cryptocurrency markets, and the ability to create a robust tracking and information system. Ideal skills and experience for this project include: - Proficiency with real-time data integration - Extensive experience with cryptocurrency-related projects - Strong analytical and problem-solving skills - Familiarity with blockchain technologies - The ability to design and develop user-friendly interfaces I need a clone of Dexscreener for the BASE chain. a. We need to pull data from various AMMs like UniSwap, base swap, Alien Base, PCS b. D...
I need an expert to retrieve a missing Excel document from my Windows configured laptop. This document has been missing since February 2024, and I have no backup available. The document was created using an unknown version of Excel, so the freelancer would need to check the specifics during the recovery process. Key requirements: - Recover the missing Excel document which was lost for unknown reasons - No backup available - The document was created using an unknown version of Excel Skills and experience needed: - Proficient in data recovery - Experience in retrieving files from Windows systems - Familiarity with different versions of Microsoft Excel Can pay 12 usd
...Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants fr...
- Moving from Iubenda to Mirasvit (I will buy and install extension) - Fixing Alpinejs and Google consent exceptions (as seen on Firefox), double check exceptions cross browser. - Check Mageplaza blog (): for example it seems that is needed by extension, I removed it because is useless in frontend, but need to be double checked.
I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides ...
I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency ...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
Hello, I'm looking for a professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline fo...
...am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time ...
I'm in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be f...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I have a sizable amount of numeric data that needs to be inputted from handwritten documents. This is a meticulous task that requires attention to detail as the data must be entered accurately. Key tasks include: - Transcribing data from handwritten documents into a digital format. - Ensuring the data is accurate during the entry process. Skills/Experience required: - Proficient in data entry, especially numeric data. - High level of accuracy and attention to detail. - Previous experience with handwritten document data entry is preferred. - Understanding and application of data validation techniques.
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.
Fixed cost & developers from Uttar Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. P...
We have a selection of AI images that need to have a transparent background to enable use within our business. Standard removal tools in Photoshop remove too much of the actual image.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the resp...
I browse to a text file containing a definition of a flowchart e.g. the intended flowchart is attached file It creates an image file of the flowchart. Simple example: See attached file The text file has 3 lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how g...
I am looking for help building my landing page design wordpress site. I have purchased the domain and theme plug-in (envato travel tour) but i need help installing it, and editing the home page. Then I need help editing a template for a tour page, where I can copy it and create similar other tour pages, along with a contact page and FAQ page after. I also need help installing a plug in where the site is GEO-blocked from Mexico and the US, along with yoast seo and maybe others.
Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.
Convert 2 page brochure from PDF to AI files. Recreate source files from PDF for easy editing. Create a layer from each section. Copy the text from each section. i.e. each image is a layer, each text block is a layer, each text heading is a layer For reference-page1 should contain approximately 19 layers.
I'm in need of a web crawler that can extract specific data from a large online ads website. The extracted data should then be neatly exported to a Google Sheet. Key requirements: - The crawler should not be intrusive to the host website. - I want the crawler to crawl current and expired ads based on links present in the site map, as historic data is also of importance to me - You should be able to provide a way for me to run this crawler myself at any time - ideally on a monthly basis. I haven't yet decided on the precise fields to be extracted. I'm looking for someone with the skills to recommend suitable fields that could be benefi...
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these are...
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't expli...
I'm seeking a professional auditor to conduct a comprehensive annual financial audit for my company in Vancouver, Canada. The primary goal of this audit is to validate financial statements, with a keen focus on the balance sheet, income statement, equity, and cash flow statement. Ideal Skills/Experience: - Proven experience in financial auditing, particularly annual audits - Excellent knowledge of financial regulatory compliance - Skilled at identifying financial irregularities - Proficient in reviewing and validating balance sheet, income statement, and cash flow statement. This engagement will require a meticulous individual who can handle the complexities of a comprehensive financial audit...
I'm in need of a skilled web scraping expert who can help me compile a database of local businesses. The data I need should include company name, physical address, email, phone numbers and their social media profiles. Key requirements: - Data extraction from multiple websites: I'm looking to collect this information from a variety of sources, not just a single site. This will require the ability to navigate various structures and formats, so experience with diverse web scraping is a must. - Targeting local businesses: The focus of this project is to gather data specifically from local businesses. This implies you should have the know-how to identify and extract...
I'm seeking a skilled developer to integrate a pixel into my WordPress website that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-u...
