Execute excel macro calcpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
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...
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 am looking for a skilled WordPress designer to create an engaging blog website. As client details were not provided, the site should be versatile enough to work for a personal, business, or news blog. - Design: While no specific design elements were specified, the site should be modern, user-friendly, and visually compelling. - Freelancer Applications: Potential fre... - Freelancer Applications: Potential freelancers should include examples of past work, their experience, and detailed project proposals when applying. Ideal Skills and Experience: - Advanced proficiency in WordPress. - Previous experience designing blog websites. - The ability to incorporate versatile features to suit various types of blogs. - Strong communication skills to comprehend and execute my vision ef...
I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving t...should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execute...
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 enhancements with...
As a DevOps developer with substantial experience in Azure, particularly in Azure infrastructure, Azure DevOps, and Azure networking, I need your immediate support in the following areas: Your responsibilities will include: - Implementing continuous integration and continuous deployment strategies. - Resolving any bugs in the CI/CD pipeline and identifying improvements. To successfully execute this project, you should: - Have 5+ years of experience in the Azure environment. - Be proficient in Azure infrastructure, Azure DevOps, and Azure networking. - Have a track record in Jenkins, GitLab, and Azure DevOps. If you possess the above-mentioned skills and experience, please apply for this project.
...clients' unique needs. From SEO and social media marketing to email marketing and e-commerce strategies, we leverage cutting-edge techniques to drive results and exceed expectations. Position Available: We are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about storytelling and creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth analysis and implement conversion rate optimization strategies that enhance user experience and drive conversions SMM Guru: Do you live and breathe social media? As our...
...Strong understanding of User Experience principles to ensure a seamless and enjoyable user journey on the web platform. The ideal candidate for this project would be someone who is not only creative but also has a deep understanding of the principles of design and the technical implications of their decisions. You should be able to come up with innovative and original ideas, but also be able to execute these ideas in a way that is practical and effective. As I'm open to suggestions, I'm looking for a designer who can bring their expertise to the table and help me shape this project in a way that is both unique and impactful. If you think you have what it takes to deliver this comprehensive design project, I'd love to hear from you. Please provide a portfolio o...
With over 10,000 followers, my quotes and sayings themed TikTok account demands a better revenue strategy. Seeking an experienced social media monetization expe...followers, my quotes and sayings themed TikTok account demands a better revenue strategy. Seeking an experienced social media monetization expert to explore, design and implement strategies excluding sponsored content. Your tasks: - Identify successful alternative monetization methods for TikTok(include but not limited to merchandising, shoutouts, donations, affiliate marketing). - Develop and execute an effective action plan. Ideal skills and Experience: - Proven experience in social media management and monetization. - Sound knowledge about TikTok specific earning strategies. - Exceptional creativity and problem-solvi...
...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 management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm seeking a seasoned C++ programmer who can design an array-based heap effectively. The purpose of this project is to handle both max heap and min heap. Here are my specifications: - Implementation of the max heap and min heap within the same array-based heap structure. - The software should be able to execute both Insertion and Deletion operations. - It should facilitate Heapify operation, enabling the optimization of the heap structure. If you possess extensive knowledge and experience in heap data structures and can proficiently utilize this in C++, you are the right fit for this task.
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
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'm in search of a professional based in Delhi/NCR to manage and maintain my website. The website is already developed, now I just need someone to maintain it and perform necessary updates and alterations. Key Responsibilities: - Execute content updates on the website as required. - Implement design modifications to enhance the user experience. - Improve website functionality to ensure it's always operating at its best. Requirements: - Proven experience in managing WordPress websites. - A keen eye for design and ability to implement changes effectively. - Understanding of website functionality and how to enhance it. - Availability to make changes as needed, so residing in Delhi/NCR is preferred.
I need a professional to create a bootable macOS Sierra 10.12 as I plan on downgrading my Mac system. Unfortunately, I do not have the macOS Sierra 10.12 installation file, which is why I require someone capable of tracking it down. The ideal freelancer would have experience in creating bootable macOS versions, a deep understanding of Mac systems and software, preferably with experien...downgrading processes. This may involve: - Source a macOS Sierra 10.12 installation file - Create a reliable and secure bootable macOS Sierra 10.12 - Guide me through the process of using the bootable macOS for a fresh installation on Macmini (late2018) Previous similar projects and reviews would be an added advantage. Please submit your proposal with a brief explanation of how you plan to execute...
...Posts should be made three times a week. You will need to schedule these posts for optimal engagement. • Content Creation: I require original content created. You should be adept at crafting engaging posts that align with our brand voice and ethos. Proficiency in using various social media tools for graphics and video creation is a plus. This role requires someone who can strategize, plan, and execute compelling content while tracking performance. If you have a knack for understanding what makes social media users tick, this is your job....
...With limited specifics to provide, it is crucial for interested candidates to demonstrate a well-rounded skill set. My expectations include: - A variety of past work samples showcasing your talent in 3D modeling, animation, or rendering. - Your experience level in the 3D field. - A detailed project proposal outlining your work process, your understanding of the requirement and how you intend to execute it. The timeline and deadlines for the project are flexible, but I am interested in knowing your general availability and how swiftly you work within a given timeframe. Your proposal should, therefore, include this information. Ideal candidates should be quick learners, possess excellent communication skills, and have a knack for bringing creative ideas to life in 3D. Looking fo...
...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 comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
I need the header on my WordPress site to be adjusted in its mobile version. The full header requires resizing. Key Responsibilities: - Resize the full header in the mobile version Ideal Skills and Experience: - Proficiency in WordPress development - Experience with responsive design, especial...requires resizing. Key Responsibilities: - Resize the full header in the mobile version Ideal Skills and Experience: - Proficiency in WordPress development - Experience with responsive design, especially mobile optimization - Strong understanding of CSS and possibly JavaScript for more complex adjustments In your application, please provide a detailed proposal on how you plan to approach and execute this task. Past work examples of similar mobile optimization projects will be highly 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...
I am in search of a graphic designer skilled in photo retouching and color correction. The project involves editing images for a product catalog. Key Tasks: - Apply skilled photo retouching techniques - Execute color correction to enhance product appearance The ideal freelancer for this project would have: - A proven track record in high-quality image editing - Strong skills in photo retouching and color correction - Experience in creating images for product catalogs. Please provide samples of your previous work, particularly in product image editing. This will greatly aid my decision in selecting the right candidate for the job.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
I'm in need of an experienced PPC specialist to help me generate leads for my business. The project will involve leveraging Google and Facebook Ads to target a broad audience within the age range of 18-44. Key Responsibilities: - Develop and execute PPC strategies to drive lead generation. - Optimize Google and Facebook Ads for maximum lead conversions. - Monitor campaign performance and identify opportunities for improvement. Skills and Experience: - Proven track record of successful lead generation through PPC campaigns. - Expertise in Google and Facebook Ads platforms. - Proficient in audience targeting, ad optimization, and campaign management. - Strong analytical skills to interpret campaign data and make data-driven decisions. Your goal will be to drive high quality ...
...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...
...email marketing, social media marketing, and search engine optimization. * Take on specific sales tasks such as cold calling and attracting Web Design clients. Ideal candidate must have: * Vast experience in B2B and B2C sales and lead generation. * Proven track record of executing successful lead generation campaigns. * Expertise in email, social media, and SEO marketing. * Ability to manage and execute cold calling strategies tactfully. * Excellent understanding and knowledge of the web design industry. Your primary task is to bring in new business from companies and individual consumers, as these are our primary targets. Your strategies and activities should align with this target audience. I look forward to your innovative strategies and methods to increase our lead generat...
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...
I am...Marketing, SEO, and Email Marketing for my business-to-business services. The ideal candidate or team for this project should have: - Profound knowledge of and experience in implementing and managing successful digital marketing campaigns targeting B2B clients - Specific skills in Social Media marketing on Instagram - Expertise in SEO and Email Marketing The primary task will be: - Develop and execute effective marketing strategies across the mentioned platforms - Track and analyze effectiveness of our digital campaign, subsequently making the necessary adjustments for optimization By bringing onboard your expert knowledge and innovative strategies, the goal is to significantly boost our brand visibility, reach more potential clients, and subsequently, drive more sales co...
...should be many-to-many, so we probably need a middle 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 in need of an experienced professional to strategize, create, and execute a cold email campaign targeting technology companies. The main aim of this campaign is to generate sales leads that can potentially be converted to loyal customers. Key Responsibilities: - Creation of engaging and informative cold emails to incite interest and redirect the recipient to a relevant landing page. - Ongoing management and tweaking of the campaign based on response rates and conversion data. Ideal Candidate: - Proven experience in email marketing, particularly cold emailing. - Knowledgeable about lead generation strategies. - Extensive understanding of the technology market segment and B2B marketing. - Outstanding copywriting and communication skills.
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
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I am looking for a skilled social media expert to manage my advertising campaigns on Facebook and Instagram. The primary goal of these campaigns is to significantly boost our sales and conversions. Key Responsibilities: - Strategize and execute targeted ad campaigns on Facebook and Instagram - Optimize campaigns to increase conversions and sales - Regularly monitor and report on the performance of the ads Ideal Candidate: - Previous experience in managing successful social media ad campaigns, particularly on Facebook and Instagram - Strong understanding of conversion optimization techniques - Familiarity with targeting professionals aged 25-40 - Analytical skills to assess and improve campaign performance Please provide a portfolio of your previous work and any relevant qualifica...
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.
Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
