Excel vba chart csv 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...
web-lomakkeelta tulevaa .csv-imuotoista tietoa pitäisi lukea FreeCADiin, sen pohjalta avata ja päivittää oikea malli ja piirustus ja lähettää niistä exportit takaisin asiakkaalle. Csv-puoli on kunnossa ja paikka minne exportit menee. FreeCADin komentaminen siis puuttuu
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.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
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.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
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.
...kinds of expenses for my business. This should include: - An understanding of how to categorize expenses into staff salaries, subbie payments, materials, and individual staff hours on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A p...
I need virtual assistant, easy work just copy paste. More discusse with freelance chat...
...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. -...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...framework. This script will be built with the Basic features for any Candlstic chart inspired by the Tadingview chart platform. Features for candlesticks chart like: - Time frame series. (1,2,3,4... minutes; 1,2,3,4... Hours; 1,2,3,4... Days; 1,2,3,4... Weeks; 1,2,3,4... months; 1,2,3,4... Years). - Plotting type (Bars, Candles, Hollow candles, Area, Heikin Ashi, Renko, Range). - Indicator ( Rsi, Volume, MACD, ....And more). - Drawing Tool ( Trendline, Horizontal line, Vertical line, Channels ....And more). - Screenshot. - Save any drawing by the user for any Ticker. Ideal Skills and Experience: - Proficiency in JavaScript and ReactJS is required. - Experience in real-time data visualization. - Experience in Stock chart visualization. - Familiarity wit...
I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...
My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.
...in gathering emails of a list of companies I already have at hand. The job entails the following: - Extracting emails of the listed companies. Key job requirements include: - Proven experience in web scraping, data mining and Excel - High attention to detail and accuracy - Familiarity with email gathering processes The purpose of these emails is for sales and marketing purposes; thus, discretion and adherence to GDPR and other privacy laws are of utmost importance. The list I'll provide is in Excel format, therefore a good understanding and efficiency in Excel would be greatly beneficial. Please note that the turnaround time for this project is also very crucial, so your ability to work effectively within a given time frame is key. Please only bid if ...
I have a registration system where players sign up for a sports event. These entries are in Wordpress and when they register the data gets pushed to a different system. There are about 200 records that did not sync and I need someone to manually go through and resync these. I'll provide an Excel file of the records that need to be resynced. To do this: 1. Login to Wordpress 2. Go to: Forms > Entries > Choose 'Spring 2024 Flag Football Registration' 3. Search for the players last name 4. Hover over their entry and click 'Resend' 5. Wait for it to process, then do the next one 6. Here is a video of the process: 7. You need to wait for each to finish to start the next, but you can 'resync' multiple at a time
I'm planning to start a business and need an extensive research to be completed. I need data from US cities to be gathered, analyzed and published so the public can learn. Key Deliverables: - Collection of various data points such as population demographics, crime...the source, etc. - Starting point will be surveys published that will be provided to you on topics such as "Best place to retire in the US." Ideal freelancers for this project should have: - Experience in market research and data analysis. - Understanding of the U.S. regions and cities. - Ability to meet strict deadlines. - Clear and concise reporting skills. - Provide your research in an MS Excel document This project will require a keen eye for detail and the ability to present data in an understand...
...project: - Creation of tech packs that cater specifically to men's and women’s wear. This includes various items such as shirts, pants, jackets, and other typical men's and women’s clothing items. - Each tech pack should contain profound details of each clothing item’s materials and measurements. Make sure to include properties like fabric composition, trim details, color information, grading size chart, hardware details and placement. - The project focus is on the advanced level of information, so please ensure you're comfortable with providing more than just basic components and assembly details. Ideal freelancer for this job would be: - Experienced in Apparel Design and Manufacturing. - Familiar with creating detailed tech packs, preferably ...
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...
I need a skilled Python programmer to create a script that enables me to connect to a checkpoint MDS and CMA and panorama. I am looking to automate the process of analyzing a list of IP addresses in a CSV file and eliminate the obsolete objects from the rulebase of a specified policy package. The key functions for this project are: - Reading from a CSV file - Checking the existence of specific objects - Auto-deleting obsolete objects where required - Generating a detailed report upon task completion A deep understanding of Python is essential for this job, as well as familiarity with Network Security and Checkpoint Firewall. Experience in automation and reporting is also needed. I'm hoping for a solution that increases my work productivity by reducing manual tasks.
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...
I need someone that can make a simple webapp that takes my CSV data for data analysis using some LLM. Please write I KNOW LANGHCAIN in your description. Preferably someone who can code it along with me.
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
...board listing portal similar in functionality to "". The platform should primarily cater to the UK market. Key Features to Include: - Job Posting & Editing: This should be user-friendly, offering both a simple form with basic fields for quick job postings as well as an advanced form with additional fields for more comprehensive listings. Setting up a feature to import jobs from a CSV file will also be necessary. - Job Search and Filtering: A streamlined UX is essential here. Users should be able to conduct keyword and location-based searches easily. - Job Credit Sales: Quite importantly, the platform needs to be set up to sell job credits to our clients, allowing them to advertise their vacancies. The ideal candidate will have prior experience in developing simil...
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
My goal is to standardize the naming conventions of our products on our e-commerce site. To do this, I will be using a CSV file which contains the products' names, IDs, and descriptions. Ideal Candidate: • Proficient in manipulating data within CSV files • Experience with e-commerce platforms • Detail-oriented to ensure accurate standardization of product names The task will consist of: • Updating product names in the CSV file to adhere to our new naming conventions • Ensuring the revised naming conventions correspond accurately with the correct product IDs and descriptions • Testing and verifying the accuracy of these updates on the e-commerce site This job requires a keen eye for detail to ensure every product name is updated acc...
...encompassing the following areas: - Cover Page - Table of Contents - Executive Summary - Remediation Recommendations - Framework Alignment - Detailed Insights and Analysis The attached MS Word document provides sample content that will need be in included and editable in this Goggle Docs template. The image files should easily be copied from our source application then pasted in the document. A CSV should easily be imported where you see the tables. The Google Docs template must be fully editable and we must be able to add sections, text, and tables where necessary. The template should use Google Docs compatible fonts. Headers and primary content should be the "Bai Jamjuree" font. Pages should have a horizontal lay out as seen in the attached example. The formatt...
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be com...
...are part of. In brief, the Function App would need to: - Create a new folder in the SPO library for each new sales rep when hired, and set permissions on that folder (and any folders that get created under it) such that only that sales rep, and their manager, and their manager's manager up to the chief sales officer, have access to the content in that folder. Obviously, the further up the org chart someone is in the sales division, the more folders they will have access to for the people that report to them. As such the Function App will need to parse and loop through the hierarchy in AAD/Entra and store those relationships and then use those to assign the appropriate permissions in AAD. - 2nd use case: where someone that is a sales rep gets promoted to a management role. ...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Ex...Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in bre...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
We need people that have not been involved in this project to look at the website from a customer perspective(pc and mobile) and make a report on things that will not make them buy and why not and how would they fix it(just and idea of what you think, there is no right or wrong). Look at the whole site and make a document on it in .csv Part of the website(link) | Issues(trust or technical) | How can we make this a better experience for you?
I'm looking for an expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing func...functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI design with a focus on text fields and drop...
I'm looking for a highly skilled data analyst who specializes in data visualization. My project involves the following: * Visualization Type: I'm dealing with textual data that I nee...involves the following: * Visualization Type: I'm dealing with textual data that I need to have clearly visualized. * Preferred Method: I am interested in effectively presenting my data through a chart representation. * Chart Type: More specifically, I would like the chart to be circular. Ideal Skills for the Job: * Extensive experience in data visualization techniques. * Proficiency in creating charts, primarily circular-based charts. * Strong understanding and experience with visualizing textual data. Only bid if you have the necessary skills and are comfortable wit...
...a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number of connection requests in every month. The user should be given flexibil...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
I have a 17 page document with graphs and charts of all relevant data. I included some texts around it. I need the texts edited / rewritten/ rephrased into an economics ICT sector profile for Nova Scotia, based on the information. Included additional analysis if necessary, tying in the importance of certain metrics listed. The key task is correcting sentence struc...17 page document with graphs and charts of all relevant data. I included some texts around it. I need the texts edited / rewritten/ rephrased into an economics ICT sector profile for Nova Scotia, based on the information. Included additional analysis if necessary, tying in the importance of certain metrics listed. The key task is correcting sentence structure ensuring seamless flow and ensuring chart/graphs have the same...
I have a 17 page document with graphs and charts of all relevant data. I included some texts around it. I need the texts edited / rewritten/ rephrased into an economics ICT sector profile for Nova Scotia, based on the information. Included additional analysis if necessary, tying in the importance of certain metrics listed. The key task is correcting sentence struc...17 page document with graphs and charts of all relevant data. I included some texts around it. I need the texts edited / rewritten/ rephrased into an economics ICT sector profile for Nova Scotia, based on the information. Included additional analysis if necessary, tying in the importance of certain metrics listed. The key task is correcting sentence structure ensuring seamless flow and ensuring chart/graphs have the same...
...information. -Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the jo...