Vba code excel data analysis 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.
in attached ....................................................
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.
...platform. With issues ranging from tracking errors, data discrepancies, to configuration setup, we require someone who can comprehensively correct these to maximize our utilization of the platform. - Issues at Hand - Our GA4 platform has been experiencing consistent tracking errors and data discrepancies. The configuration setup appears to be at fault. - Focal Areas - We need strong emphasis placed on event tracking, conversion tracking and user behaviour analysis. The current setup is inaccurate and needs revision and accuracy assurance. - Your Skills - You should be experienced with GA4, particularly in identifying and resolving tracking issues. Strong knowledge in data analysis will be essential in identifying and correcting data di...
I'm looking for a professional who can provide an in-depth traffic analysis for one road with the aim of identifying potential hazards related to vehicle collisions. You will be expected to: - Analyze traffic volume data - Determine the potential for vehicle collisions - Propose-methods to mitigate these hazards An ideal candidate would have experience in traffic safety analysis, specifically in predicting potential collision spots from high traffic volume data. Your insights will significantly contribute to the overall safety of this road.
...create custom AI-powered Flask web appsDo you have a project that requires intelligent automation?I can help you develop custom AI models and seamlessly integrate them into powerful Flask web is what I propose:Tailored AI Solutions: We will work together to understand your needs and create a custom AI model that addresses your specific challenge. (e.g. image recognition, sentiment analysis, predictive modeling)Seamless Flask Integration: I will create a user-friendly Flask web application that uses your AI model, allowing you to interact with its intelligence and options: choose from a range of packages adapted to your budget and the complexity of your project. All packages include basic functionality, with options for advanced features such as complex model
Cher Freelancer, Je suis à la recherche d'une personne femme/homme s'exprimant parfaitement en français dans le but de pouvoir appeler des casinos français d'une liste excel avec les numéros de téléphone. Votre mission sera la suivante : - Appeler chaque casino - Obtenir les informations demandées dans le fichier excel - Mettre à jour le fichier - Rappeler les casinos qui n'ont pas pu vous répondre au 1er appel - Répéter l'opération mensuellement ou à convenir Les appels peuvent être effectués en semaine comme en week-end. Cependant, ceux-ci devront être fait le soir dès 20h30. Je recherche une personne avec collaboration sur le long...
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
I'm on the for someone with knowledge of web security to produce a detailed analysis report on selected CVE vulnerabilities associated with WordPress. This report is specifically for an academic project. Here are the particular CVEs for review: 1. CVE-2023-32243 2. CVE-2023-0084 I can provide the older versions of those plugins with bugs you just need to execute and create output on docker environment and add screenshots of execution showing how it exploits security and then the share the proposed mitigations in the report. You must have to cover the below mentioned points in the reports: briefly describe the architecture of the web application/framework describe the type(s) of vulnerability that is considered describe the vulnerabilities in detail describe how to exploit...
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
...continuously scan and update its database of cryptocurrency projects, highlighting those that have significant pre-approved investor interest. - I require the bot to provide detailed information about each identified coin, including the number of pre-approved investors and relevant project details. **Technical Requirements:** - Utilize cryptocurrency APIs and blockchain data sources for real-time tracking and analysis. - Implement an efficient scanning algorithm to identify coins meeting the investor threshold. - Integrate with Telegram Bot API or Discord API for seamless message delivery and user interaction. If you have experience in blockchain development, bot creation, and integration with messaging platforms, please reach out to discuss the project...
...Google Ads, Facebook Ads, TikTok Ads) and associating them with each day's data. Integration with Urgent Cargus: Ensuring seamless integration with Urgent Cargus' delivery tracking system to display shipping costs and provide real-time updates on delivery status (delivered, out for delivery, refused, etc.). Calculation of Net Profit: Implementing functionality to automatically calculate the net profit for each order, considering production costs, shipping fees, taxes, and other associated expenses. Purchase Price Input: Including a feature where we can input the purchase price of each product from the supplier. This will help us accurately calculate profit margins. Reporting and Analysis: Building reporting and analysis features to evaluate the perform...
I need a Python developer who can work on a project with a focus on data analysis and visualization. This project is specifically aimed at producing Python code that can perform data analysis tasks and visualize the results. Key Responsibilities: - Implementing data analysis algorithms using Python - Creating visual representations of the analyzed data - Ensuring that the code provides accurate data analysis and visualization Ideal Skills and Experience: - Proficient in Python programming - Experienced in data analysis and visualization - Solid understanding of data structures and algorithms It's important that you have a strong attention to detail and the ability to deliver accurate ...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
...on the findings. The main objective here is to provide a detailed discussion on the trends and patterns identified within the financial data, alongside some data-driven recommendations. Key responsibilities: - Exploring and identifying trends, patterns, and anomalies in the financial dataset using Stata - Compiling a detailed report that covers the above, with a particular focus on generating actionable insights - Ensuring the report has a clear, concise and professional structure and presentation Ideal candidate should have: - Proficiency in Stata and prior experience with financial data analysis - Strong analytical skills and the ability to interpret data in order to derive meaningful insights - Excellent communication skills, particularly in the ...
...integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs...
...of the model is surveillance. This means that the model should be designed to be used in a surveillance context. - Real-Time Processing: The model must process in real-time. This means that it should be able to detect objects with minimal delay, crucial for surveillance applications. Other requirements include: - mAP, F1 Score & FPS Analysis: Provide a comprehensive evaluation of the model's performance through mAP, F1 score, and frames per second (FPS) analysis. This will help us gauge the model's accuracy and speed, two critical factors in its effectiveness. - Model Explanation: Offer an in-depth explanation of the model architecture. I would like to understand the internal workings of the model and how it detects objects in real-time. Ideal candidates fo...
...displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be...
...vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills...
I'm in need of detailed insights into various credit repair companies across the USA. The scope of this project is quite comprehensive and entails the following key areas: - **Reputation and Reviews**: I need a thorough analysis of the reputation and reviews for a range of credit repair companies. This data should be based on both customer feedback and industry standards. - **Services Offered**: A detailed breakdown of the services provided by each company would be crucial. This includes the scope of services, their unique selling points, and the quality of their offerings. - **Pricing and Fees**: An in-depth understanding of the pricing and fee structures of these companies is essential. This should cover both their standard packages and any additional costs th...
...to stimulate critical examination of capitalist principles and structures, fostering cross-cultural dialogue and Project Components:Literary Selection and Analysis:The project begins with careful curation of English literary works that explore various facets of capitalism, including wealth distribution, labor dynamics, and consumer culture. Each chosen work undergoes thorough analysis to uncover overarching themes, character portrayals, and narrative complexities reflective of capitalist and Adaptation:Skilled translators are tasked with the challenge of transforming these selected English literary pieces into Spanish, maintaining fidelity to the original text while ensuring cultural relevance and linguistic fluidity in the target language. This process
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
Hello, Look for a freelancer ...Responsibilities: - Develop and implement digital marketing strategies. - Managing advertising campaigns through social media and other digital channels. - Analyzing data and measuring the effectiveness of marketing campaigns. - Manage digital content and improve user experience. - Strong analytical skills and ability to understand data. - Deep knowledge of digital marketing tools. - Excellent communication skills in Arabic and English. If you believe you have the appropriate skills and experience, we look forward to working with you. Develop a marketing plan Supervising its implementation SWOT analysis Competitor analysis Objectives: Increase brand awareness (activity_place_ Services) Increase interaction Incre...
I'm currently seeking aid in the composition of a lab report that focuses on microbiology, specifically the identification of unknown bacteria. Responsibilities for this project will be: - Detailed explanation and analysis of the Gram-staining technique we used. - Outline and elaborate the biochemical tests conducted to identify the bacteria. - Relay the findings in a comprehensive, yet supervisor-friendly manner. - Diagrams where necessary to reinforce points or data. The ideal candidate should possess: - A strong background in microbiology. - Excellent writing and description ability. - An understanding of Gram-staining and biochemical tests. - High attention to detail. - Experience in lab report writing. This project will require attention to detail and proficient...
I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
...industry for an in-depth study on water circularity. Your main responsibilities include: 1. Data Collection: Gather comprehensive data on water usage, steel production, and wastewater treatment processes within the industry. 2. Quantitative Analysis: Conduct extensive analysis on the gathered data. Key metrics of interest are water consumption per ton of steel produced, water recycling rates, and energy consumption for water treatment. 3. Life Cycle Assessment (LCA): Delve into the steel manufacturing processes. Understand and document the usage and flow of water within these procedures. 4. Qualitative Analysis: After the metrics have been crunched, I want an interpretation and presentation of the data in an understandable and accessi...
I'm seeking an experienced OMNET++ specialist to develop a security simulation model for Intelligent Transport Systems. Key Qualifications: - Extensive experience with OMNET++ simulations, INET, Veins, and SUMO. - Knowledge of Machine Learning and Blockchain. A deep understanding of network analysis and protocols is also necessary. - Proficient in network modeling and event simulation. Bring your knowledge of OMNET++ to create a top-notch wireless network simulation model. This is your chance to showcase your deep understanding of the complex framework of Intelligent Transport Systems. The more detailed the model, the better!
...Element Model: The model should be based on beam theory, shell theory and thin shell theory. - Stress Distribution Analysis: The most important output data from the model should be the stress distribution. This is crucial for this project. - Industry specific: The intended application of this pulley is for the mining industry, so you need to be able to ensure that the model is tailored to this industry. Ideal Skills and Experience: - Solid Understanding of Finite Element Modeling: You should be proficient in creating and analysing finite element models, ideally with experience in industrial applications. - Stress Analysis: You should be familiar with stress distribution analysis and be able to provide accurate results. - Industry Specific Knowledge: Experien...
The principal objective of this assignment is to focus on quality control, specifically checking of final products in the process. To effectively execut...specifically checking of final products in the process. To effectively execute this project, you should be able to: - Conduct a comprehensive final product check, primarily with machinery parts. - Leverage your analytical skills and use best-practice quality control methods to ensure the machinery parts adhere to the strictest performance standards. - As an expert in materials testing, your analysis of machinery parts will inform process improvements. For this project, experience in quality control and a deep understanding of machinery parts are the ideal skills. Familiarity with CMM cosmos is a bonus though is not a strict re...
I need a seasoned LabVIEW developer who is skilled in handling data acquisition and processing as well as GUI design and user-interface development. Key tasks include: - Working on the interface that controls our vision camera. - Implementing features for image processing and analysis. - Developing functionality for object detection and tracking. Extensive experience with instrument control automation, particularly with vision cameras, is highly advised for this role. I'm expecting a meticulous eye for detail, excellent problem-solving abilities, and a deep understanding of LabVIEW. If you have handled similar projects in the past, that would put you at a strategic advantage.
...displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be...
I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of t...
...developing an AI Chatbot using the ChatGPT API integrated with Langchain, primarily for Customer support purposes. I'm looking for expert advice on enhancing and refining the existing code in the following key areas: - Handling User Input: I need guidance on improving the bot's ability to understand and process a wide variety of user inputs smoothly and effectively. - Generating Accurate Responses: I require assistance in fine-tuning the bot's response generation to ensure it provides relevant and accurate information to users' queries. - Performance Optimization: I am seeking recommendations on how to optimize the code for better speed, efficiency, and overall performance. The level of customization I'm aiming for in the Chatbot's responses...
I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.
Seeking sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are all a plus but not mandatory. Novices are also welcome to ap...
I'm looking to integrate Azure AI Studio with my existing system to enhance our data analysis capabilities. The ideal candidate should possess the following skills: - Proficient in Azure AI Studio and AI development - Experienced in integrating AI technologies into existing software systems - Strong background in data analysis, machine learning, and natural language processing The project will involve: - Adding Textual data, Image data, and Video data to the Azure AI Studio for analysis - Implementing Sentiment analysis, Entity recognition, and Keyphrase extraction functionalities for textual data. Please provide samples of your previous work and detail your experience with Azure AI Studio in your proposal.
...looking for an experienced freelancer able to create inviting content that can shape and enhance my brand's perception. My end game is to improve brand recognition and develop a loyal customer base. Even though I'm open to ideas, having a detailed strategy or proposal in the pitch will be highly advantageous. - **Required Skills:** Copywriting, creative writing, marketing strategy, audience analysis - **Deliverables:** 1. Strategy Proposal: Detail your approach and how you plan to execute it. 2. Creative Content: Develop content that will resonate with the general public while highlighting the brand. - **Evaluation Criteria:** Applications will be evaluated based on detailed project proposal and track record in creating successful copywriting campaigns. This ...
I am searching for an individual int...searching for an individual interested in a shared ownership of an exciting company. This potential long-term business partnership will transform our vision into reality. Key Responsibilities: * Spearhead technical aspects of the company * Offer expertise in software development Ideal Partner Skills and Experience: * Proven experience in software development * Excellent problem solving and tech-analysis skills * Open-minded, entrepreneurial spirit * Willingness to commit long-term Your role as a partner isn't just about tech skills; it's about taking ownership, bringing strategic insights to the table and steering our business towards growth. If you're innovative, driven and ready to make a real impact, let's discuss thi...
I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure th...
I am seeking a knowledgeable individual in the field of artificial intelligence who can assist me with forming opinions based on intensive research. The ideal candidate should embody: - Proven research abilities in the technology sector, specifically with a focus on artificial intelligence - Strong data analysis skills - Capacity to present info and data collected in a well-structured and concise manner - Passionate about current technology trends in artificial intelligence Remember, the main goal is to form a well-rounded, informed opinion on a select topic within artificial intelligence through rigorous research. I'm not looking for baseline information, but rather varied perspectives to aid in constructing a deep understanding of the topic.
...platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. Expected Deliverables; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, trailing SL & trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code debugging required if any. 6. Back testing in multiple timefr...