Excel table formula 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.
I'm looking for a talented graphic designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform p...Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project is perfect for a designer who can bring fresh and modern ideas to the table. Items attached: 1. list of our current scope of works that is sent to clients. We want this to be visually appealing. 2. Current e-book "7 Things you should know before building a customer home". Please refer t...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
3D modeling and two photorealistic renders showing the assembly of the table
I require a professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - ...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and effici...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
...from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is all the data it had collected since using this module. Hopefully this makes sense but let me know if I can clear it up. I also ...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% How...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm looking for a talented graphic designer to revamp the current cover of my parenting book. The current one isn't quite hitting the mark and I'm looking for someone who can bring fresh, appealing ideas to the table. I like this cover, but maybe you can improve it.
I'm looking for a skilled carpenter or furniture maker to create a custom wardrobe with an integrated dressing table. Key Requirements: - Material: The wardrobe should be crafted entirely from high-quality wood. - Interior Features: The wardrobe must include shelves, hanging rods, and drawers for optimal storage and organization. The wardrobe should be elegant in design and functional in use. Please ensure it is sturdy and durable, suitable for daily use. It should be a balance between aesthetic appeal and practicality, ensuring it can comfortably accommodate my clothing and accessories. Ideal Skills: - Experienced in carpentry or furniture making, particularly in creating wardrobes. - Proficient in working with wood and able to translate the design into a quality finished...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I am in need of a freelance professional who can assist with the creation of a magazine to promote a small rural town in Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The ...read the magazine, so understanding of effective call-to-actions and market strategies in this setting is preferred. The ideal candidate for this job would have experience in both magazine production and outdoor advertising, with a keen understanding of how to tailor content to the business audience. Most importantly, I am looking for someone who can bring creativity and fresh ideas to the ...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I need to be able to create realistic tablecloth images on a table from flat images of the patterns. - Create a render template for realistic tablecloths which can be edited to change the pattern. - 2 shapes are required - rectangular and round - Ideally the table will be in a replaceable kitchen background environment - Finished image should be 4000x4000px allowing for zoom crops to be taken. - Example shape styles are attached
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
As the owner of Antilia Bistro Bar, I am looking for an expert web developer who can bring my vision to life. Key requirements: - Develop an intuitive reservation system allowing customers to: - Select their preferred table - Enter their contact details - Indicate special dietary requirements - Specify preference for indoor or outdoor seating - Ensure the website is user-friendly and easy to navigate. Ideal skills for this project would be: - Proficiency in web development - both front-end and back-end - Prior experience in developing restaurant websites or reservation systems would be an added advantage - Strong understanding of UX/UI designs to create an engaging user experience - Able to integrate the website with restaurant's operational system for seamless commu...
I'm aiming to enhance customer engagement and retention through my website and online digital presence. To achieve this, I am seeking a skilled professional who can bring innovative photography ideas to the table which will be used to update our website and marketing material. We have various sites around the UK and would like premises pictures and on the job professional shots taken. (Please note we are a bodyshop repairer). We are looking at around 50-100 professional shots that we can use, so please feel free to place your bid.
...- The ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging. - Strong knowledge of cocktail concoctions and mixology. - Creative writing style that can make the content engaging and entertaining. - Proficient in English with excellent grammar skills. - Bonus if you have experience in food photography or graphic design for ebook l...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
...their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references within the article, they will be provided upon awarding the article Ideal skills and experience for this job: - Strong research abilities - Excellent writing skills, particularly in crafting engaging, informative content - Experience in writing ab...
I'm looking for an experienced application developer who is also skilled in UI/UX design to create a futuristic, visually appealing, and user-friendly design for an app I'm developing. Key aspects: - Platforms: The app will be available on both iOS and Android, so you should have experience with both platforms. - Purpose: The ap...ideal candidate should have: - Proven experience in developing and designing productivity apps. - Strong portfolio demonstrating a futuristic design style. - Proficiency in both iOS and Android platforms. - Solid understanding of UI/UX principles. Your role will be pivotal in shaping the app's success, so I'm looking for an individual who can bring innovation, creativity, and functionality to the table. If you believe you fit the bi...
I'm seeking a talented video creator to produce a live-action video for me. The goal is to introduce our product to businesses in a specific industry. Key points and requirements: - The video should be creative and engaging, designed to capture the interest of potential ...creative and engaging, designed to capture the interest of potential business partners in the industry - Experience in creating similar type of videos or a strong portfolio showcasing your video production skills would be preferred - A good understanding of the product and the industry it is intended for will be a significant advantage - You should be able to bring fresh, creative ideas to the table on how to make the product introduction memorable and impactful for our target audience. I look forward to ...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.
...engaging article that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professional and engaging, keeping the reader interested from sta...
... Key points that should be covered in the article include: - Different designs and styles: The writer should explore the various design options available for square conference tables, discussing contemporary, minimalist, classic, or any other popular styles in the market. - Benefits and features: The article should highlight the practical and aesthetic benefits of choosing a square conference table over other shapes. This could include space-saving benefits, visual symmetry, or ease of communication between participants. - General information: The writer should provide a comprehensive overview of square conference tables, including their history, common materials used for construction, and any other relevant information. The ideal candidate for this project should have: - Prove...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on targ...
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...
I'm looking for a freelancer to be the model for ultrasound demonstrations at a medical conference. These demonstrations will not focus on diagnosing a medical condition, but rather show...are medically trained. - Physical characteristics are not a barrier to apply, we are not looking specifically for a sports or fashion model. Please note: - The purpose of this project isn't about detecting specific medical condition. It's solely for the purpose of demonstrating the usage of an ultrasound medical device. - The successful candidate should have abilities to get onto a scanning table, to lie on your back and on your sides. - Professionalism in presentation and ability to be discrete about the company's activities at the conference. _ Lunch and breaks will have ...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...
I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
