Excel data manipulation script 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.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
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.
Moi, Mulla on nettisivu jossa on kolme välilehti. Kokonaisuudessa 240 sanaa! Haluan sinut korjaamaan oikein kirjoitukset sekä tekemään parannuksia myynti kirjoituksiini. Saat aikalailla vapaat kädet parannuksiin! Kirjoita biddiin "Suomi" varmistaakseni että olet lukenut ja ymmärtänyt budjekti: $24 Tässä on nettisivustoni siittä näkee kuinka vaativasta työstä on kyse
Minulla on jatkuvaa työtä, joka liittyy aikaisempaan projektiimme 'Video script copywriting'
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
...freelancer to develop a script that can navigate the Almaviva Egypt website just like a human would. The script must be capable of completing three key tasks: - Filling out all necessary appointment-related information - Selecting the date and time of the appointment - Submitting the request for the appointment Considering the constraints of the website, I require a script that can still function proficiently with a limited number of appointment slots. Moreover, it must be programmed to input login credentials. A crucial requirement is that it can bypass or solve captcha verifications, ensuring a smooth booking process. The essential skillset for this project comprises expertise in Python, as the script should be developed in this language. Familiarity wit...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I'm looking for a talented video editor who can proficiently use deepfake technology. The task requires replacing celebrities in a famous youtube video with the faces of Arab and other countries' leaders. Key requirements: - Advanced skills in deepfake technologies - Ability to replace faces seamlessly maintaining realism, not comedic effect - Experience in video editing and manipulation - Knowledge of the chosen youtube video (or willingness to get acquainted with it) Successful delivery of this project means a visually convincing result showing world leaders in place of real celebrities. If you have the necessary skills and experience, I invite you to bid.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...
...must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will also include: - Implementing validation requirements for all input fields. This will ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Understanding of user experience best practices - Experience with automatic email re...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
...give the classic poster of National Lampoon's Christmas Vacation a modern twist. The core task involves replacing the faces of the characters with 7 new ones. These replacements need to look as realistic as possible. Key Requirements: - Expertise in Photoshop with a strong portfolio of similar projects - Ability to create high-quality, realistic face swaps - Experience with detailed photo manipulation - Proficiency in editing text on images Text Modifications: The text changes on the poster are focused on: - Replacing the movie title - Altering the tagline and credits It is essential that the final result is polished, professional, and aligns with the original style of the poster. Please only apply if you have the necessary skills and experience to deliver a high-quality...
Just looking for someone who can be paid a low amount and read the script in a good English accent. Will get paid every 2 weeks. Very easy job. As easy as it sounds just read the text out loud and have it recorded! That is it!
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...
I'm in immediate need of a talented freelancer with exemplary scripting and animation skills. The project revolves around the creation of a 1-2 minute demo presentation with an engaging narrative. Key Aspects: • Animation Length: 1-2 minutes • Animation Style: Demo presentation • Script/Storyboard: You would be responsible for creating the script/storyboard. • Budget: $50 • Deadline: The project must be delivered within a day. Ideal Candidate: • Previous experience with animation video. • Strong scripting abilities • Exceptional knowledge in 2D Graphic animations or 3D Computer animations I encourage freelancers who can deliver high-quality work within the time and budget to apply.
I need a skilled PHP developer for a project that requires merging multiple images into a single template. The primary task is to overlay images on top of a template, creating a final image that is a combinat...overlaid is essential. While I prefer a simple drag and drop tool to adjust these parameters, the output should be precise. - Output Formats: The final image should be available in both JPEG and PNG formats. Ideal skills and experience for this job include: - Strong proficiency in PHP: Since this project will be executed primarily in PHP, a solid understanding of this language is a must. - Image manipulation: Experience in overlaying images onto a template and managing their positioning and sizes is crucial. - Output formatting: Ability to generate images in both JPEG and PN...
...eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simulta...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm uncertain whether my Windows system already has Python installed. I require assistance to get it up on my system, if it isn't already there. Primarily, I am looking for someone to help configure a Python script that will carry out automatic reservations on a specific website. This role will ideally suite someone with: - Proficiency in Python scripting - Strong understanding of automation using Python - Experience in setting up Python on the Windows platform - Knowledge of web interaction through code, in particular, reservation processes. here is the link to the script and its dependencies. I will need to work with you on zoom live to do this. I have node.js on windows
I'm looking for a skilled Photoshop editor with a creative eye for detail to help me with a project. My primary need is for photo manipulation. This will involve adding or removing elements from the image to create an entirely new composition. The edited images will be used for personal purposes, so attention to detail and quality is crucial. Ideal Skills: - Extensive experience in Photoshop - Ability to seamlessly add or remove elements from an image - Strong understanding of color balance and composition
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I need to create a script to consume a SOAP service with WSSecurity to Encrypt and Sign the XML, an example is the way SOAPUI is configured to consume the service. Preferably in Python, but the language is free. Necesito crear un script para consumir un servicio SOAP con WSSecurity para Encriptar y Firmar el XML, el ejemplo mas cercano que puedo dar es la forma en la que SOAPUI se configura para consumir el servicio. Preferiblemente que sea en python, pero el lenguaje es libre
...project. The source of data will be Excel files. The Project involves: - Designing and implementing Interactive filters in the dashboard to allow ease of navigation and data manipulation. - Integrating dynamic graphical elements which include Pie Charts, Line Graphs, Bar Graphs, and Box-and-wisker Plots. Ideal Skills & Experience: - Strong expertise in Tableau dashboard design and development - Prior experience working with Excel datasources - Excellent in designing interactive filters - Proficiency in creating different types of graphical data visualizations on Tableau - Attention to detail for error-free dashboard deployment - Strong communication for updates and clarifications If you meet these qualifications and have a keen eye fo...
I am looking for a skilled developer to create an execution script for me for the game, Roblox Jailbreak. Features: - Fast car speed - Unlimited ammo - Teleportation ability Auto Farming: This script should enable auto farming. It should be able to: - Collect in-game currency - Complete missions or tasks User Interface: I would like the UI to be customizable to fit my preferences. Ideal Skills: The freelancer should have proven experience in scripting for the Roblox platform and should be familiar with the mechanics of the Jailbreak game. An understanding of UI design and user-experience would also be a plus. Freelancer needs to demonstrate their ability to create scripts with similar complex functionality. I dont want it to have any mistakes!
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tab...
I am urgently in need of an experienced and dedicated script writer who can quickly deliver a high-quality movie script. You dont have to watch full movie. I will be providing a video which will be already explained in English, you just have to write the script of the same in Hindi. Price 300rs per script if it is under 15min, and 50rs+ for extra per minutes.
I have a private football manager game online. Written in PHP and TWIG. The script has already been adapted to PHP 7 (from PHP 5). 1. Now it has been noticed that 1 function, 1 module does not work properly under PHP 7. This module needs to be adjusted. 2. I need a few minor adjustments and functions in the game and in the admin area. 3. Then I would like to have a new module. A calendar where you can see the days and what matches you have on those days. (Read from the existing database and display). And with some functions. You have to know that every extension to this script will be written in modules. These are then copied into the directories and taken over by the main script. Who can help? Further information and sample images if you are interested and contac...
I'm looking for a talented video producer to create an engaging explainer video. Ideal Skills and Experience: - Proficient in creating explainer videos - Strong storytelling and script writing skills - Ability to create visually appealing animations - Familiarity with video editing software - Understanding of adult-focused content Key Requirements: - The video should be educational in nature, aimed at adults. - The content should be clear, engaging, and easily comprehensible. - It should be well-scripted, with a balance of visuals and narrative. - The video should be of professional quality, with smooth transitions and clear audio. - The final product should align with the objectives of an explainer video, which is to educate the audience. If you're confident in your ...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
I'm seeking a skilled logo designer who can adeptly adjust typography on my existing logo to make it communicate our brand better. The logo is a combination type, incorporating both text and symbols. Key Requirements: • Proficient in working with combination logos • Exceptiona...logo to make it communicate our brand better. The logo is a combination type, incorporating both text and symbols. Key Requirements: • Proficient in working with combination logos • Exceptional typography skills • Ability to understand the brand and reflect it in logo modifications The successful freelancer will have a strong portfolio demonstrating their ability in logo design and font manipulation. An appreciation for brand identity would be particularly valuable for ...
...sending student data to school coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single sch...
...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external AP...
I'm hunting for a talented scriptwriter to help me morph my autobiography into a compelling, cinematic drama. KEY REQUIREMENTS: - Understanding and analysing my life story - Skillfully infusing drama into the script - Ability to captivate a general audience - Prioritize cinematic appeal over strict accuracy Ideal candidates must have: - Significant experience in professional script writing, preferably in drama - Strong creative skills, to innovatively adapt real-life events into a dramatic format - Keen understanding of what engages a general audience - Open communication style, ready to walk the journey with me.
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particul...
I'm seeking a freelancer to assist with editing a PDF file. The project involves modifying both the text content, numerical data, and the graphical sliders within the document. Key Responsibilities: - Editing of text data within the PDF file. - Modification of numerical data. - Updating the graphical design of sliders/scales. You should be proficient in PDF editing and manipulation tools, as I already have the necessary software. Additionally, experience with modifying and designing graphical elements within PDF files is crucial. The ideal candidate should possess a keen eye for design, ensuring the graphical sliders are visually appealing and functional. Please share any relevant experience with similar projects in your proposal.
