Excel vba if statement multiple conditionsdela
Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server
Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent
Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..
Pripravljamo obsežen program marketinških aktivnosti s poudarkom na video povezavi ( , ) si lahko natančno ogledate, kakšne video posnetke potrebujemo, pri tem pa upoštevajte, da imamo trenutno cca. 10 takšnih os...imamo trenutno cca. 10 takšnih oseb torej 10 različnih videov. Konkretneje bi nas zanimal: • Čas izvedbe, • pričetek dela, • cena. Vsi tisti ki menite da nam lahko v dotični zadevi pomagate, ste strokovni in konkurenčni, vas vabim k sodelovanju! Za vsa dodatna vprašanja smo vam na voljo na elektronskem naslovu: [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] Lep pozdrav, Sergej Merc
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
Description We are seeking an experienced and creative jewelry artist/designer to collaborate with us on creating unique tungsten ring designs for our business. The ideal candidate will have expertise in CAD software, a strong understanding of materials and manufac...SolidWorks) and other design tools. *Strong knowledge of materials, and manufacturing techniques relevant to jewelry production. *Creative flair and ability to translate conceptual ideas into tangible design concepts. *Good communication in English, and ability to work collaboratively in a remote way. Additional Information: * This is a freelance position with the potential for ongoing collaboration on multiple design projects. *Remote candidates are welcome . Budget: *Budget is negotiable based on experience and proj...
I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
...suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Knowledge of cybersecurity measures - Experience in dealing with compromised online accounts - Network security proficiency The project will entail: - setting up a closed in-home network in my home in Re...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
My Server that I access via remote desktop services has stopp...allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is available. REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at that server terminal to give you acce...
I'm looking for a talented...branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience in creating visual content for multiple platforms would be a big plus. Looking forward to seeing your portfolios and offers. Tasks Include : - Logo for the brand - Facebook - Cover + Profile Pic - Insta - Profile Pic - Twitter - Cover + Profile Pic - LinkedIn - Cover + Profile Pic All of the covers & profile pics will have some minor adjustments according to the platform, graphic...
Logo needed for brand offering fundraising services for charitable causes. Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Desig...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should ...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...I'm developing. The app will be available on both iOS and Android platforms, and is designed to provide users with medical opinions using AI. Key features to be included in the app are: - Diagnosis Suggestions: The app should provide users with accurate diagnosis suggestions based on their reported symptoms. - Symptom Checker: A symptom checker that helps users identify the possible medical conditions related to their symptoms. - Medical Records Storage: A secure and easy-to-use medical records storage system, allowing users to keep track of their health history. Ideal candidates for this project should have: - Proven experience in designing UI/UX for mobile applications, particularly in the medical or healthcare sector. - Proficiency in understanding and translating compl...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessa...
I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from ra... Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love ...
...predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a minimum of 10 representatives. - Provide the capability to handle "N&...
I'm searching for a proficient legal writer for contracts, specific to commission agreements. My project requires a detailed understanding of key terms and conditions such as commission percentages, payment terms, non-compete clauses, non-disclosure agreements, and confidentiality clauses. Ideally, you should have: - Significant experience in drafting contracts - A good understanding of commission agreements in the technology industry - The ability to draft clear, concise agreements, covering all necessary areas Your role will involve the formulation of a comprehensive and legally robust agreement. The perfect fit for this project ensures precision, respect of privacy, and clear communication.
...rotted wood, and what appears to be inadequate support or bracing. The ideal freelancer for this job should: - Be highly knowledgeable about structural engineering, especially for older constructions. - Have extensive experience with the assessment and treatment of damaged/rotten wood. - Be capable of designing and implementing robust structural supports. Being familiar with Michigan's weather conditions and how they impact a home's structure will be a plus. Your recommendations and solutions should effectively address and prevent any potential instability or damage. Please include any relevant experience, project estimates, and methodological approach in your bid. Completion timeline is flexible and can be negotiated based on your professional opinion and strategy....
I'm after a unique and eye-catching font design for my upcoming album release. The font needs to be of a Chrome style, with a metallic silver color scheme. The aim is to create a bold statement that perfectly captures the mood of my music. WORDS TO USE Heavy Heart || A1 (with a shooting star logo ?) Key Requirements: - Chrome Style Font: The font should resemble a sleek, polished chrome surface, ensuring it stands out and fits the theme of the album. - Metallic Silver Color Scheme: The font should be colored in a metallic silver shade, adding to the chrome-like feel and ensuring it's visually striking. - Bold Mood: The font should evoke a bold mood, reflecting the powerful and impactful emotions conveyed in my music. Ideal skills and experience for this project: -...
I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to...
I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.
We are looking for a developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L vi...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I am seeking a creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can
I need an email validator that validates multiple emails, preferably done in C#. As stated above, I need a system that validates whether the email exists or not. The system must be practical and easy and must have a license management system, which I can generate. I want only people who pay some plan for the system to be able to use the software.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I am seeking an experienced digital marketing professional who can effectively handle multiple areas of digital marketing. This includes: - SEO: Enhancing the visibility and ranking of my website on search engines. - SEM: Implementing strategies that increase the reach and visibility of my ads. - Social Media Marketing: Creating engaging and shareable content for various social media platforms to build strong relations with the audience and increase followers. - Blogging: Producing high-quality blog posts to engage readers and increase site traffic. - Web Editing: Tweaking and enhancing the website for a more user-friendly experience and better SEO performance. - Email Marketing: Developing and managing effective email marketing strategies to boost customer engag...
...textures, chair legs, and other features in real-time on our site. Requirements: Model Specifications: A highly detailed 3D model of a chair. Different textures and materials for customization (e.g., fabric, leather, wood). Multiple chair leg options (e.g., wooden, metal, various designs). UV unwrapped and properly textured for high-quality rendering. Technical Requirements: Formats: FBX, OBJ, and any other formats compatible with web-based 3D viewers. PBR Texturing: BaseColor, Normal, Roughness, and Metalness maps. Optimization for real-time rendering (low-poly options if necessary). Ensure compatibility with WebGL or similar web technologies for interactive customization. Functionality: Ability to switch between different textures and materials seamlessly. Ability to ...
I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.
I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.
I'm in need of a 3D artist who can create a basic product model for me. This model should be able to be viewed from different angles. Key Requirements: - The project involves product modeling, so experience in this area is essential. - The model needs to be created with basic shapes and forms. No complex detailing or textures are needed. - You must be able to generate multiple views of the model, allowing me to see it from different perspectives. Ideal Skills and Experience: - Proficiency in 3D modeling software, such as Blender, Maya, or 3ds Max. - A strong portfolio demonstrating previous experience with product modeling. - A keen eye for detail and the ability to follow design specifications accurately. - Excellent communication skills to ensure my requirements are met eff...
I'm looking for an Indian professional WordPress developer who can help me with a couple of issues on my site. Key Requirements: - Fixing a bug causing the website to load slowly. - Enhancing website speed by employing appropriate techniques. Specifics: - The main issue I ...optimizations should be applied to the homepage as a top priority, but I also require this across other pages of the site. Ideal Skills and Experience: - Proficiency in WordPress development and bug fixing. - Experience in optimizing website speed, including image and media optimization, content caching, and server response time reduction. - Proven track record of improving website performance across multiple pages, with a keen eye for detail and thorough testing. Please share your relevant experienc...
...professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a val...
I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.
...to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Design ability: keeping it simple, yet professional - Knowledge of SEO best practices to implement on the website. Please provide examples of your previous work, especially if you...
I'm seeking a seasoned logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature past examples of iconic logo design and demonstrate how you...
...Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads (Search, Display, YouTube) and Facebook Ads (Feed, Stories, Audience Network). Utilize advanced targeting techniques, including demographic, behavioral, and geographic targeting. Optimization and Analysis: Monitor and analyze campaign performance data to identify trends and insights. Perform A/B testing to continually refine ad copy, creatives, a...
...Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note: - The user interface for this bot should follow a simple and minimalistic design. It's essential for users to easily navigate and execute trades. - Experience with creating intuitive and user-friendly UIs is a plus. If you're well-versed in blockchain development, particularly in the Solana ecosystem, and have a track record of creating effective trading bots, I'm eager to hear from you. Neat description: The bot should have a login page. Where the admin can login with his password and email. And the dashboard where it should show select dex. And the admin selects between raydium and...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
...1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable tool. - Commitment to Non-Repaint Signals: It is important that the signals produced by the indicator do not repaint, ensuring that past signals remain consistent and reliable. The ideal freelancer for this project should have: - Extensive experience in developing Pine Script indicators for TradingView - A solid understanding of how to create indicators that perform well with short timeframes - A history of delivering high-accuracy buy and sell signals - The ability to work independently and produce a non-repainting indicator If you are confident in y...
...or generator mode. All datasheets and circuit diagrams will be provided. Key Responsibilities: Control and Regulation: Implement SVPWM on both grid and machine sides. Grid-side control: Adjustable power factor (cos(φ)), current, and power. Machine-side control: Adjustable field (Φ), torque, and speed. Overload Protection: Develop a feature to switch the device to idle mode during overload conditions. Measurement and Output: Provide optional output of all internal measurements, especially torque, speed, and power. User Interface: Implement a 4x20 LCD text display for function calls. Enable function calls through the RS232 interface using JSON format. Protect the interface with CRC for error-checking. Ensure PC commands are readable and outputs are optional and adjus...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
