Vba excel sample projects 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.
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.
our customers, our company is looking for website optimization skilled people. We want to hear your views on how you could implement for our customers tehokaita and affordable SEO solutions. What kind of tools you can use? Reporting tools, monitoring tools etc etc. In addition, we would like to hear your views on whether järkeävää our clients to set up a landing page for different domain and optimize the separate sites for different search words. Sell yourself to us! What to give and you have the know-how for our company, and how and where you work consists of Reward
Sample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample InvoiceSample Invoice Sample Invoice
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I'm looking for a React and developer that integrate a Partical background to our website ASAP. We found this interesting sample: Although it looks like Vanilla implementation, we want it to be integrated into our react landing page. We are looking for someone to integrate the background exactly as it is just without a loading spinner at the top of our landing page instead of the big blue banner on our website:
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.
I am looking 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 Scope of Work: The Initiator engages the Creat...
Our team is seeking a talented WordPress developer with specialization in theme customization, plugin development, and website maintenance to join us in bringing exciting websites to life. You will be involved in: - Collaborating on versatile and innovative projects - Utilizing your expertise to enhance our digital presence Ideal Skills: - Deep understanding of WordPress - Proficiency in Theme Customization - Experience in Plugin Development - Knowledge in Website Maintenance In your application, please include your past work. Examples demonstrating your proficiency in WordPress, theme customization, plugin development, and website maintenance are especially welcomed. We look forward to reviewing your contribution to this creative journey.
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.
I'm looking for a skilled mobile app developer with experience in designing and developing cross-platform applications for both iOS and Android. Key Requirements: - The app will primarily focus on freight and logistics operations, hence, your understanding of this domain and relevant experience is highly desirable. - The key functionalities t...cross-platform mobile applications - Integrating and developing applications for logistics and supply chain - Implementing freight management and route optimization functionalities in apps - Delivering user-friendly and intuitive mobile applications. Your understanding of modern UX/UI principles and trends in the logistics sector will be considered a plus. Please share your relevant experience, sample works, and estimated timeline fo...
I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits t...
...transformation to leave an impression on potential partners and clients. Your task would be: - Implementing a modern design style across the presentation to ensure its engagement with the corporate world. - Emphasise image selection. Images play the main role in this Project. They need to be intriguing and powerful, reflecting the uniqueness of our work at Sniper Action Photo. I will provide all of the sample images. - While the main focus is on the images, typography and color schemes should not be overlooked. They should complement the images and strengthen the overall visual appeal of the presentation. Ideal Skills and Experience: - Excellent understanding of aesthetic and modern design style. - Proficient in PowerPoint (Or Canva or other tool) and graphic design. - Strong ...
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 need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file
...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 simultaneously without compromising quality. - Excellent time ...
...especially in creating high-quality Android applications - Strong knowledge and experience with internet radio app creation would be highly advantageous - Exceptional understanding of the Android development environment and tools Freelancers who feel confident they can realise these requirements should get in touch. Please provide information on similar projects you've completed or skills that are particularly relevant to this project. Attached is a sample...
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...
...and short format videos and posts, specifically: - video frames, - subtitles stylings, - thumbnails, - background images, - circular character frames. These elements should be eye-catching, diverse, and tailored to each franchise's unique visual identity. - We are 2 people in this project, and we each need a thematic personal profile picture as well (current, non-thematic images attached as sample). These should be suitable for Facebook, Instagram, Discord, YouTube, Twitch and TikTok We are actively avoiding AI-made content, so please avoid its use - or keep it to a minimum. Ideal candidates for this project should have: - Proficiency in graphic design and animation, with a strong portfolio showcasing previous work in a similar context. - A deep understanding of the v...
I'm looking for a skilled graphic designer to create a modern, visually appealing tri-fold menu for my pizza takeaway business. Content to be copied from our newly created website. I can provide sample menu card of our other store. It can be similar to that menu but design needs to be improved and eye catchy. Would be great if you can share sample of menu that you have. Timeline is very tight.
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 am in need of a skillful audio engineer who can do a high-quality job in removing background noise and isolating the dialogue on an audio file. This task will specifically target an MP3 file. To produce a top-tier result, it is ...capability to fulfill this job. This is what I am looking for in my ideal freelancer: - Extensive experience in noise reduction and dialogue isolation - Capable of working efficiently with MP3 formatted files - High attention to detail - Ability to deliver the project in a timely manner If you can meet these requirements, I'd be glad to hear from you. Please include your experience and relevant sample works in your proposal. I wish to have this project completed as soon as possible without compromising on the quality. Let's create somethi...
...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...
This is not a one time thing, We're looking for someone to hire on monthly salary to create flyers on demand as soon as a request is made online. The flyer must be done within 24 hours within our organization's color palette with flexibility with unlimited edits as requested. The budget is $100/Month, if you feel this budget is low please don't submit an offer. You need to create an alternative flyer from the below event from the attached color palette to show your designing skills to be considered for the position. I'm in need of a versatile designer who can create both eye-catching, Bright and colorful flyers, and engaging media designs for my various needs. Key Requirements: - Designing bright and colorful flyers that are striking and attention-grabbing - ...
...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. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement mathematical equations from research papers. - Expertise in sensitivity analysis and scale-up projects. - Ability to translate experimental data into practical, large-scale applications. Goals: - Evaluate key metrics such as C...
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 Tables: You will be required to create and ma...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
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 ...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 c...
I'm in need of a comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and ana...our data streams refresh every two weeks. and I will have two complete sets by then. After that, 30 days of testing, adds and changes, will follow. At this conceptual phase, it may not be a question of price, or product...... its probably going to be based on a simple reason to move forward ( like the developer has done it already with Home Depot, or a provided realistic not full functioning sample gets provided for assessment) Anything that has the name Crown Bolt 8979, a graph, a chart.... even done on the existing Ai created spreadsheet would be impressive to the stire lecel personel who will selec...
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 need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's n...with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to...
...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 APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
...Videos: 3 - A sample video will be provided - Video should be animated character I'm looking to target the younger audience and garner their interest in the promotional content. The project is on a tight schedule, so I'm looking for a professional who can deliver these videos as soon as possible. Please keep in mind that the budget for this project is fixed, so no additional costs should be incurred. Ideal skills and experience: - Proven experience in creating engaging and professional social media video content - Ability to create concise and compelling content within a 30-second timeframe - Familiarity with the interests and preferences of a young audience - Must be able to deliver quality work quickly and efficiently. If you have a portfolio of previous simil...
...activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Kepanjen, Malang • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....
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, particularly based on generated unique iden...
...working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) San Fabian, Pangasinan, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....
We need to create a plugin that will handle th...table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
