Vba sum value column excelprá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.
Two years ago, I had a plugin created to calculate the price of pencil printing. After updating the woocommerce, my files were probably overwritten - the price with the print on the product page, in the cart and others is not displayed. You will need a good knowledge of the core o...good knowledge of the core of woocommerce and programming Link for example : input quantity 100 - select "potisk předmětu - online kalkulačka" click "zvolte technologii" select "tamponový tisk" click "Upřesněte technologii" select "jednobarevný potisk" click vypočítat cenu potisku ... now see only NaN Kč... Nan - It should be the sum of the price of the products + the price of the print Multiple files need to be modified for...
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.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
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
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic cont...
...edit any details. In this site if the user comes back to edit any details they need to create the profile from the scratch. i want the details to be editable at any point of time. Once the profile is created it would be available for public access on a url like No body but the logged in user can only be allowed to edit the profile. 4. I want the usersite In url to be a hash value of the user and not the username as it would be a vulnerablility by which anyone can access anyones profile and view their data. It would be shortened for the qr code anyway. 5. Once on the dashboard i want the user to be able to see analytics of the static link of the qr. 6. On the dashboard i want there to be a credit card like ui where user can quickly switch the link that the qr points to
...Minimum compensation for 2 hours is guaranteed per session • Payment is as a 1099 independent contractor and a W-9 IRS form will be filled out. • Potential for ongoing projects and long-term collaboration as new products are continuously introduced. About Me: I am experienced in photography, highly creative, and well-versed in digital editing tools. Known for my fun and quirky approach, I value originality and am eager to work alongside someone who can bring fresh ideas to the table. START DATE: ASAP How to Apply: If you're interested in this exciting opportunity, please contact me....
I need a skilled cameraman equipped for studio-style shooting of a leadership and management course. Ideally, you have experience in educational or instructional video capture, with a strong understanding of the balance between value content and compelling presentation. Here's what I’m looking for: - Filming in a studio interview-style setting - Utilizing a 4K camera for a high definition recording - Equipped with professional audio equipment for clear & crisp sound - Able to provide lighting setups for interviews would be a plus You may need to assist with scene setup to ensure the final output encapsulates a professional and conducive learning environment. Knowledge of teleprompter operation is beneficial though not mandatory. Your ability to edit the video for t...
I am searching for a professional, capable of accessing and securing contact details of a policy advisor in the Prime Minister's Office. If you have extensive experience and sound connections within governmental institutions, your expertise would be of great value. Key responsibilities include: - Information gathering, particularly contact details - Networking within the Prime Minister's Office The ideal person for this job must have: - Proven experience in governmental networking and information gathering - Credible connections within the Prime Minister's Office - A track record that demonstrates discretion and professionalism Please note that this task requires strict confidentiality and adherence to all relevant laws and regulations.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
I am looking for a talented and experienced claymation artist to design a unique, r...experienced claymation artist to design a unique, realistic, and engaging human-like character, primarily for entertainment purposes. Key Responsibilities: - Design and create a claymation character that mirrors human characteristics and features - Render the character in a realistic fashion, with attention to detail and accuracy - Should possess an exceptional creative flair, keeping the entertainment value high Ideal Candidate: - Proven expertise in claymation - Strong portfolio demonstrating a focus on realism and detailed work - Exceptional creativity and innovation - Experience in entertainment-centric projects would be favourable Looking forward to witnessing your unique vision for thi...
...indicators are below the stock chart in the order of PPO, ADX, Williams% R, Full Stochastics %K, ATR, RSI, Accumulation / Distribution and MFI. The stock chart will show the EMA(9) and the EMA(15), candlesticks and the Parabolic SAR. Also, I would like an alert sent to my cellphone when a stock meets the criteria above. Here is the script I have used with StockCharts where x means crossed over the value listed after the x. The StockCharts scan engine does not calculate using a one hour time period and a one month time frame. Below is the script. [type is stock] and [Open >= 1.00] and [Close <= 50.00] and [Volume >100,000] and [Parabolic SAR(0.02,0.2) < EMA(15)] and [yesterday's plus DI(7) <= yesterday's minus DI(7)] and [today's plus DI(7) x...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
Es ist eine Aufgabe die in Excel gemacht werden muss, bzw Excel Solver bis 10.05
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
...again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend services. I want to be able to make a small change in the script to scale up or down the number of servers. This servers need to run AWS Linux, Java 21, node js 12, and datadog agent. We will start with 1 EC2 instance but as I said I want to be able to change that value and scale up (or down as needed). - The EC2 instances need to upload a config file for Datadog agent, part of this we need to supply the datadog api_key, which will be supplied in the command line via variables. The script needs to update that key in the datadog config file. - There are also a few directories which need to be created under /etc/datadog-agent/conf.d/ and files ...
I'm looking for a proficient sales representative to sell my services. Mandatory Skills: - Exceptional customer service - In-depth technical knowledge - Superior negotiation skills - Perfect English and Spanish is a must! Compensation Strategy: The chosen representative will be paid on an hourly basis. Experience in selling services is a must, as they will need to convincingly communicate the value of our offerings. The ideal candidate should be able and ready to handle client inquiries effectively and meet the sales objectives. You must be able to thrive in customer service, possess technical knowledge, and have leading negotiation skills. Your experience will reflect your understanding of client needs and help meet our business goals.
...unprecedented growth and adoption, attracting interest from investors, businesses, and governments around the world. The value of Bitcoin has soared from mere cents to thousands of dollars per coin, making early adopters and investors incredibly wealthy in the process. Its decentralized nature and limited supply (capped at 21 million coins) have contributed to its status as a digital gold and a hedge against inflation and economic instability. Challenges and Criticisms Despite its widespread popularity, Bitcoin faces several challenges and criticisms. Its volatility and speculative nature have led to concerns about its suitability as a medium of exchange and store of value. Moreover, its decentralized nature has made it a target for regulatory scrutiny and government inte...
Hello our company has built an online open banking payment gateway. I need people that have Lloyds, HSBC, NatWest, Barclays, Standard bank accounts. I will create a link for you with 12GBP value , i would like you to record a video of the full procedure while you are paying it and what difficulties and describe what difficulties did you face. You will get paid 25GBP for your work , (12 of your payment + 13 for your 3 precius minutes)
...unprecedented growth and adoption, attracting interest from investors, businesses, and governments around the world. The value of Bitcoin has soared from mere cents to thousands of dollars per coin, making early adopters and investors incredibly wealthy in the process. Its decentralized nature and limited supply (capped at 21 million coins) have contributed to its status as a digital gold and a hedge against inflation and economic instability. Challenges and Criticisms Despite its widespread popularity, Bitcoin faces several challenges and criticisms. Its volatility and speculative nature have led to concerns about its suitability as a medium of exchange and store of value. Moreover, its decentralized nature has made it a target for regulatory scrutiny and government inte...
...working hours. The second placard needs to highlight the simplicity of our booking process. It should mention the ease of booking, and most importantly, our unique Pick & Drop Services to and from the airport. Additionally, we're considering incorporating a Barcode for Tipping on the placard. This feature is designed to make the tipping process easier, which can be appealing to travelers who value efficiency and convenience. Overall, the wording of these placards should be compelling, concise and designed to resonate with the needs of business travelers. The goal is to increase their trust in our services and, in turn, boost direct bookings. I wanted to share something with you that's been on my mind lately. Unfortunately, I recently lost my job, and as a resu...
...High ticket closer on a commission-based and a base salary. It will be a 12% commission on coaching programs of $7200 or higher commissions of %15 for a high closing rate above 25% We have a complete 12 months coaching and mentorship program and we already have a high ticket closer at the moment and we are looking to expand our team. All the leads come from a video sales letter that shows the value of our program and how it can shortcut their career to cybersecurity. I will provide you with the complete sales script, all the objection handling we use, the technical terms, all our coaching offers (for down-sells if needed). You have the space to add your own experience to the sales call process we use. This is a part-time to a full-time job and we are looking for someone who i...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must....
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex d...
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation mater...
...customs clearance procedures, ensuring seamless import and export processes for our clients. Documentation Services: We offer a full suite of import/export documentation services, streamlining the paperwork required for international shipments. Customs Bonded Warehouse: Benefit from our secure customs bonded warehouse facilities, providing a convenient storage solution for your goods. Additional Value Proposition: Tailored Solutions: We understand that every client is unique, and we pride ourselves on offering customized solutions tailored to meet their specific needs. 24/7 Support: Our dedicated team is available round-the-clock to address any queries or concerns, providing unparalleled support to our clients at every step of the way. Cutting-edge Technology: We leverage the la...
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final prese...
I am in need of an experienced full stack developer who is well-versed in .NET and Angular to assist with the backend and frontend development of my project. Essential Tasks: - I...processes - Providing valuable insights during project reviews Key Skills: - Strong competence in .NET and Angular - Proven experience in full stack development - A strong grasp of cloud technologies is advantageous - Excellent communication skills, as understanding and following project requirements are crucial Project Timeline: - There is no strict time frame for completion of this project. We value quality deliverability and careful attention to detail above speed. Ideally, you have a portfolio of previous projects to demonstrate your competency in these areas. Let's bring this project to...
As a website focusi...placed in a way that would appeal to male readers and customers. Ideal Skills and Experience: - SEO Expertise: The candidate should have a strong understanding of SEO principles and the fashion industry. - Backlink Building: Experience in acquiring high-authority backlinks in the fashion or related industries. - Content Marketing: Knowledge of how to effectively place backlinks in a way that adds value to the reader and the referring site. - Awareness of Male Fashion Trends: A plus would be knowledge or experience in male fashion trends, ensuring the backlinks are contextually placed and appealing to the target audience. I am looking for someone who can not only provide backlinks but also understands the importance of context and audience relevance in their ...
...Attachments: The HTML, relevant Javascript and PHP script I did not include the balance of the program that is not relevant to this project Additional Information: If you require any further details or access to specific files or systems, please don't hesitate to ask. Deadline: I am looking to have this issue resolved within 3 days. Timing is critical Budget: Partial work or incomplete outcomes have no value. I will not pay for a partial completion. Any need for review or revision must be included in initial quote PLEASE DO NOT BID A STARTER PRICE; I WILL ONLY HIRE A PROGRAMMER BASED ON THEIR INITIAL OFFER...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...
...about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, in which the conversation has a high entertainment value and the images are correspondingly attractive for the viewer. All 37 videos can be viewed in the attached YouTube list. To edit the videos, please use the original files, which I provide via WeTransfer 12.49GB. I also expect the videos back in HD. Please send the videos back to me via WeTransfer. Here are the rules for submitting the final files: - Only transfer the finished v...
