Goal seek vba işler

...numaralı kısımda bahsettiğim web servis aynı zamanda bir takım sorgulama ve raporlama imkanları verir (bir tür APİ). Bu web servis yapısı ve dokümanları var, çok karmaşık değil. Ben google spreadsheet ve excelde vba üzerinden rahatça çalışabiliyorum bunlarla. Bizim ihtiyacımız burada basit bazı tablolamaları belirli aralıklarla AİP'ler ile sorguladığımızda görebilmek. Ardından buradaki veriler ile canlı gelen verileri karşılaştırarak ve oradan çıkan sonuçlara göre yeni web servisler çalıştırmak. Not: Bütçe sembolik yazıldı, lütfen abartmadan (uzaya araç göndermeyecek, ben bunların hepsini VBA ile yapıyorum ama excel şişiyor ondan kurtulmaya çalışıyorum) kendi fiyat ...

Sütunları 2, 3, 4lü ... gruplandırıp grup benzerlik oranlarını hesaplayan VBA istiyorum. Aslında böyle bir VBA daha önce hazırlatmıştım, ama bu VBA belli sütun sayısından fazlasını yapamadı. Belki bu dosyada değişiklik yaparak da işimi görebilirsiniz. Ben 300 sütuna kadar karşılaştırma yapmayı istiyorum.

Hisse senedi, emtia ve yatırım fonu alım satımlarım için grafikler ile kar zararı gösterebilecek güncel fiyat bilgilerini internet üzerinden 15 saniye de bir çekip güncelleye bilecek excel tablosu istiyorum.

Excelde çeşitli ebatlarda olabilen bir tablonun hücrelerinde bulunan değerlere göre bir çarpanla çarparak satır ve sütünları değere göre sıralayacak. Rank order clustering isimli bir matematiksel bir çözüm yöntemi.

Excel VBA kodları olan bir excel türünde bazı sayfa ve hücreler şifreli durumda. Bu şifrenin kaldırılmasına ihtiyacım var.

...olabilecek kişilere daha da detay verebilirim. ------------------------------------------------------------------------------------------------------------------------ Hello there, Udacity training has been completed by the company for my name, but I cannot spare the time, so I give this job in order not to report negatively. In the project, there are flower photos that have been given us a folder. Our goal is to train the program with machine learning techniques and to ensure that it accurately identifies the photo we provide. Roughly, I can give more detail to those who can help in this way....

Merhabalar, Temel olarak, adı Matriks (MTX) olan bir masa üstü uygulamadan DDE veriler alabiliyorum. Bu sayede ilgili verileri excel’e çekebiliyorum ve aslında bundan sonra anlatacağım her şeyi VBA üzerinden yapabiliyorum ama excel'in sınırlamaları nedeniyle, eğer yapabilirsem excel'i aradan çıkartan bir uygulama yaz(dır)maya çalışıyorum. Yapmak istediğim şey kısaca; 1. MTX'in DDE verilerini al (excel olmadan doğrudan MTX'ten tercih edilir. Excel’e ben DDE linkle veri alıyorum, sonra da excel dosyasını python ile okuyabiliyorum ve CSV’ye yazabiliyorum, ama bu istediğim şey değil). Biliyorum DDE eski bir veri noktasıdır, ancak MTX'ten veri almanın başka bir yolu -yani TCPI veya başka bir yöntem- ol...

Mevcut bir excel dosyasında adlı siteden veri çekiyordum. Ancak 1 haftadır siteden veri çekemiyorum. Excel dosyasında module kısmı düzenlenerek dosyaya yeniden veri çekme işlemi gerçekleştirilecektir.

Yeni bir parakende mağaza açılışında giderleri tahmin etme ve kar zarar analizi yaparak mağaza açılıma uygundur veya değildir tarzında bir rapor sunacak excel istiyorum.

google excel sheet üzerinden birden fazla firmadan teklif alarak fakat verilen teklifler birbirinden gizli olacak şekilde açık arttırma ihalesi gibi bir makro excel oluşturmak istiyorum.

We seek for a freelancer to improve our brand in both social media and real market. Its a food brand and already active. Your references and profession education are important.

BENİM BELİRLEDİĞİM HÜCREYE GÖRE OTOMATİK FİLTRELEME YAPACAK EXCEL VBA YAZILMASINI İSTİYORUM

Makale üzerinden modelleme yapılarak vba programı ile ülke ligi ile ilgili program yapılacak

VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.

I'm looking for a talented designer to create a visually appealing presentation, portfolio or catalogue. The primary goal of this project is to showcase products and services in a compelling way. I put no restrictions on the theme or color scheme, so I'm open to your suggestions and creative inputs. This project will involve creating an engaging design that is both aesthetically pleasing and functional. The content will mainly consist of images and descriptions of products and services. I'm looking for a designer who can create a sleek, modern design that is both informative and visually appealing. You need to use the attached file and info provided there. Just need to redisign. Also need to remove all watermarks from original files or find new free pictures and ...

I require a seasoned video editor focused on basic polishing aspects such as trimming, merging and adding transitions. This video is intended for commercial advertising, ultimately enhancing our brand presence on our company's website. - Key Responsibilities: ...Responsibilities: - Trim and merge video clips - Add appropriate video transitions - Deliver a high-quality advertising video The ideal candidate will have prior experience in video editing for commercial advertising, and a good understanding of brand representation. The ability to work promptly on this project ensuring our website continues to provide engaging content, is desired. The goal is to have a compelling end-product that effectively markets our brand and translates our vision into a well-crafted...

I seek an experienced engineer equipped with both mechanical and aeronautical skills. The mission is to create a high-quality rendering for an octocopter drone, intending for agricultural chemical spraying tasks. Confidentiality is paramount so signing a Non-Disclosure Agreement (NDA) will be required. KEY DETAILS: - Purpose: Agriculture chemical spraying - Payload: Accommodate 250 lbs (not including drone weight) - Flight distance: Up to 5 miles Technical drawing skills, a solid understanding of drone aerodynamics, and experience in mechanical drone development will come in handy for this project. Reach out if you find this interesting and we can delve deeper into the specifications.

I am in need of engaging ...curriculum. - Implement nice interactive animations to make the presentations visually appealing. - The presentations should be lively, engaging, and suitable for an in-person classroom setting. Ideal Skills: - Proficiency in PowerPoint and creating engaging presentations. - Understanding of the Grade 5 Math curriculum. - Experience in educational or e-learning content creation is a plus. The goal of this project is to make the learning experience more interactive and enjoyable for my students. This is a long term bulk order, I will be paying $2 for 1 lesson of PowerPoint. If you are not ok with this, please DO NO BID. Please also bid for 10 Presentations. Also, type in the bid "OK WITH SAMPLE" as I will be asking for a sample to be made fr...

I'm seeking a skilled content creator with a strong focus on video content for social media, particularly Facebook, Instagram, and TikTok. Key Project Points: - Platforms: Your primary focus will be on creating content for Facebook, Instagram, and TikTok. - Objective: I'm looking to drive traffic to my website through your engaging video content on these platform...engaging and shareable video content is essential. - Brand Awareness: The ideal candidate should have a knack for promoting brand awareness through video content. - SEO Knowledge: Basic understanding of SEO to ensure your video content helps drive organic traffic to the website. Please provide examples of your previous work and explain how your approach to creating video content can help meet my goal of driv...

I'm currently in the process of verifying my Facebook Business page and securing a green tick for my WhatsApp API. My Facebook Business page verification application was rejected and I need assistance to successfully complete the process. The primary goal of this project is boosting my credibility on Facebook and securing the green tick for my WhatsApp API. Key points: - Expert Verification Assistance: I need an expert to guide me through the verification process appropriately. - Problem Resolution: Your expertise is required to identify the reasons for the previous rejection and help me overcome them. - WhatsApp API Verification: I need support in securing a green tick for my WhatsApp API. Ideal skills: - Profound understanding of Facebook's verification process f...

...notifications of temperature readings and changes every hour for remote monitoring. The perfect freelancer for this project is experienced in programming Arduino Opta PLCs, utilizing sensors, particularly those for temperature, and setting up efficient email notification systems. Beside technical proficiency, good understanding of thermodynamics would be a plus, but is not a requirement. The end-goal is an efficient and reliable remote temperature monitoring system....

I'm looking for a skilled network specialist to assist me in configuring my existing Unifi Gateway, CloudKey, and Access Points for enhanced security. Key Requirements: - Configuration of Unifi Gateway, CloudKey, and Access Points: The primary goal is to enhance the security of the network. Therefore, the specialist will need to ensure that the configuration aligns with this objective. Ideal Skills and Experience: - Proficiency with Unifi network devices: The specialist should have hands-on experience with Unifi Gateway and Access Points. Experience with CloudKey would be a plus. - Network Security Expertise: A strong understanding of network security principles and best practices is essential. Additional Information: - Although the Unifi Switch is part of my current setup, ...

I'm seeking a digital marketing expert to boost engagement Participation, reaching 100,000 subscribers, and the commitment to remain on the channel of these my biblical YouTube channel targeting aged 25-65 Christians. - Main goal: Increase engagement, not just views or subscribers. - Audience: Professionals aged 25-65, Christians so understanding this demographic is key. - Content: The channel is specifically focused on biblical content, so a solid comprehension of this niche would be beneficial. As a freelancer, your core responsibilities include: - Crafting and implementing effective AdWords strategies to boost the channel's engagement. - Understanding and catering to the 25-65 Christians demographic. - Ensuring that the content aligns with the biblical focus of the ...

I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make...in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a freelancer who can commit to a weekly update schedule and deliver consistently high-quality work. Your goal is to help build a loyal readership base among expe...

I'm looking for a video editor who can help me with basic editing tasks for a personal video. Key tasks: - Trimming: I have raw footage that needs to be shortened. - Cutting: Some parts of the video need to be removed entirely. - Merging: I want the edited segments to be combined into a seamless video. The end goal is to have a final video in MP4 format. Ideal skills: - Proficient in video editing software. - Experience with simple editing tasks. - Ability to deliver high-quality output in a timely manner.

The goal is to develop a “media gateway” device able to receive a panoramic video from 2 cameras (for wider field of view) in RTSP/RTMP format and produce “professional-like” broadcast video to OBS to be further mixed, add graphics and etc and late streamed to Youtube (RTMP). To do so, the system will be able to crop the original panoramic video in a way that “follows the action” and simulates the panning movement. This production needs to be fully automatic, with no human intervention beyond activating / deactivating the stream and calibration to the field. Example of open source program:

A project is available for a skilled freelancer. The main goal and specific tasks have not been defined, but the project's target audience information is missing. The client has skipped these questions, so the task may vary depending on your expertise. You will be required to: - Understand and define the specific goals of the project. - Implement tasks that align with the project's objectives. - Provide solutions that would appeal to the project's target audience. Your bid should include a brief statement of how your skills and experience will add value to the project. Make sure to include a portfolio that showcases your relevant work.

I am looking for a skilled and experienced marketer to help grow my YouTube channel to 100,000 subscribers. As a live music channel focusing primarily on Rock, my target audience are live music fans of all ages. The primary goal of this project is to generate more ad revenue through the growth of my channel. To achieve this goal, I am looking for someone who is proficient in utilizing Google AdWords for YouTube channel growth. The ideal candidate should have: - A proven track record of growing YouTube channels using Google AdWords - An understanding of the Rock music genre and the live music fan base - The ability to create targeted ad campaigns that reach my specific target audience - Excellent communication skills and the ability to work collaboratively The successful ...

I am on the seek for a talented Photoshop artist with experience in movie poster design and photo manipulation. Your task is to incorporate my image as a main character, specifically replacing Vito Corleone, on The Godfather movie poster. Ideal Skillset: - Strong command on Photoshop and photo editing. - Understanding of movie poster aesthetics and design. - Experience with image manipulation on pre-existing artwork. - Fan of The Godfather series - a plus. Project Specifics: - You are to replace Vito Corleone's face with mine. - Photo realism and seamless integration into the artwork is essential. - The final image should adequately capture the intensity and style integral to 'The Godfather.' This project demands precision, creativity and a keen eye for detail. ...

I need a professional 3D designer, ideally with experience in creating small-scale, intricate models. - The goal is to have a 3D model of a sign for visualization purposes prior to production. - The final 3D model is required in STL format. - The model should fit in less than 1 square foot space, keeping the dimensions proportionate and accurate. - Understandable knowledge of scale, proportions, and detail is necessary.

I am in search of an audio expert who can efficiently link a range of my audio devices. The devices in question, namely speakers and amplifiers, rely on a wired connection and are in quantity of o...quantity of over seven. Therefore, experience in linking several wired home audio devices is a must. Preferred skills and qualifications include: - Strong knowledge of various home audio devices, especially speakers and amplifiers - Thorough understanding in wired connectivity - Proven abilities to work with an extensive audio system - Detail-oriented with an ability to troubleshoot issues The goal is a seamless, well-connected home audio system that guarantees a high-quality sound production. Please bid, ensuring you've taken into account all system components and their specifi...

I'm in need of a creative and skilled developer to help me create an engaging platform for language translation between French, Algerian dialect, and vice versa. The goal is to enrich users' vocabulary. My primary requirements for this platform include: - A user-friendly search function that allows users to look up words in both languages. - A feature that enables users to record their pronunciation of words for feedback and improvement purposes. In terms of design, I envision the platform to follow a zoo and animal theme, presenting a fun, vibrant, and engaging visual experience for users. Ideal candidates for this project should have experience in: - Building interactive and engaging platforms - Integrating search functions - Implementing audio recording features Pl...

I am looking for a knowledgeable freelancer who can provide training on Factory Talk administration console and Factory Talk view studio. The main tasks for the training are: - Configuration and customization - Troubleshooting and support...on these modules: - User management - Data logging and reporting - Alarm management Ideal freelancer skills and experience: - Intermediate proficiency in Factory Talk administration console and Factory Talk view studio. - Proven experience in configuration, customization, troubleshooting and support. - Knowledgeable in user management, data logging, reporting, and alarm management. The goal of the project is to become proficient in using Factory Talk console and view studio after the training. The training session should ideally hap...

I'm in need of an expert who can help me with setting up Genie ACS on Ubuntu for managing routers and modems remotely. My ultimate goal is to have a seamless and efficient remote device management system. Key responsibilities: - configure Genie ACS on Ubuntu - Set up the system to manage routers and modems remotely - Ensure the system is fully functional and secure Ideal candidate: - Proficient in Ubuntu and network management - Extensive experience with Genie ACS for remote device management - A strong understanding of TR-069 protocol - Excellent troubleshooting skills - Strong security background to ensure the system is robust I'm looking for someone who can work efficiently and independently to deliver a reliable remote device management system. Your experience wit...

With the goal of setting up an E-commerce website, I'm in need of a skilled developer. The site's primary objective is to offer a platform for selling 50-100 products, a task which requires a professional who can incorporate key E-commerce features. The essential features needed are: - **Payment Gateway Integration**: The website should be able to securely process payments from various sources. This requires a developer with prior experience in setting up secure and efficient payment systems. - **Customer Review Functionality**: The inclusion of a customer review section is crucial for fostering trust and boosting sales. A freelancer who has experience in implementing such features is preferred. - **Live Chat Support Integration**: To provide real-time support to potenti...

I'm seeking a skilled o...increase my client base. This will be targeted towards all adults 18 and up. - Goal: Increase my client base significantly. - Target Audience: Adults age 18 and above. - Marketing Strategy: Primary focus on Search Engine Ads. The ideal candidate will have substantial experience in managing and optimizing search engine ads, as well as a deep understanding of adult audience targeting. Familiarity with the healthcare sector, particularly mental health, would also be beneficial. I would also like help in designing a website link for the search engines. I would like to have a presence on search engines such as Psychology Today, US News and World Report, , etc. which would encourage future patients to seek my practice and set up an initial appoin...

As a real estate investment professional, I'm seeking a skilled communicator to tactfully reach out to pre-foreclosure property owners and distressed property owners. The goal is not only to gain understanding about their current circumstances but also propose potential alternatives to foreclosure. Desired outcomes: - Collect data about the owners' current financial status and property specifics. - Determine if the owner is open to exploring unconventional financing solutions. - Encourage follow-up discussions to further delve into these options. You should be knowledgeable about foreclosure processes and creative financial solutions such as lease purchase agreements and title sales. Mastery of persuasive communication, excellent negotiation skills, and experience in r...

I seek a skilled graphic designer to create a new logo for my existing business. Key Requirements: - Design an engaging and professional logo: I need a logo that reflects my business values and resonates with my target audience. It should be unique and memorable. - Incorporate the existing color scheme: I have a specific color scheme in mind that I'd like the logo to follow. Ideal Skills and Experience: - Proficient in graphic design tools: The ideal candidate should have a strong command of graphic design software and tools. - Previous experience with logo design: Experience in creating professional logos for established businesses is a plus. - Strong understanding of branding: A good understanding of branding and how to visually represent a company's values and miss...

... Summary of the "Keep Fresh" Grocery Expiry App Project Project Overview "Keep Fresh" is a mobile application designed to help users track the expiry dates of their groceries. The app provides a simple and user-friendly interface for adding grocery items, viewing current inventory, and receiving notifications before items expire. The goal is to create a useful tool with AI features to help enhance user experience Key Features - Using Flutter + Gemini-API User Authentication: Sign in and create new accounts Edit profile and preferences Pantry Management: Display a list of scanned groceries Add new items via a plus button, redirecting to the camera for scanning food receipts or item barcodes Edit and delete existing items Overview

I am looking for a developer to create a chatbot for my hobby project. The primary goal of this chatbot is to engage users in conversation. To achieve this, I need the chatbot to exhibit an intermediate level of conversation complexity, which includes contextual understanding. Key Requirements: - Experience with Mistral, RAGs, DPO: These technologies will be pivotal in enabling the chatbot to engage in conversations and understand the context of user inputs. - Proficiency in chatbot development: I need a developer with a strong background in chatbot development, including the ability to create conversationally engaging bots. - Familiarity with conversational AI: Understanding of how conversational AI can be leveraged for improving user engagement is essential. - Ability to deploy w...

I have a collection of old book images that I wish to restore for print publication. I'm looking for an experienced image editor who can bring new life to these faded images. The book is available at and also provided as attachament of thsi job Key Requirements: - Image Restoration: The main goal of this project is to restore the old book images. The freelancer will need to digitally clean up the images and enhance them where necessary. This might involve repairing colors, removing scratches, and overall improving the image quality. - Print Publication: The images will be used for a print publication. It is important that the freelancer has an understanding of print quality standards and can ensure that the images are correctly formatted

I'm an entertainment-focused YouTuber with a subscriber base currently in the 1,000 - 3,000 range. My primary goal is to significantly grow my channel to 100k subscribers. Key Responsibilities: - Increase subscriber base to 100k - Increase video views - Improve audience engagement through compelling content creation The ideal freelancer for this project should have: - Proven experience in growing YouTube channels - Strong knowledge about entertainment content's appeal on YouTube - Expertise in video SEO and Google adword - Creative and engaging content creation skills - Strong analytics capabilities to track performance and adjust strategy accordingly If you're a growth specialist with a passion for entertainment and a track record of success on YouTube, I'd ...

We need to improve an already existing pitch deck. Our project is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitch deck. For the pitch deck, we need to go to the next level by improving the general design, and also making more clear what the investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and infographics (you can redesign the charts already put in the model). I...

...Overview: This project involves creating a Personalized News Dashboard that aggregates news from various sources and uses machine learning to curate content based on user preferences. The dashboard will feature an AI-driven recommendation system that not only presents news articles but also provides analytical insights into trending topics and sentiment analysis of news content. Objectives: Main Goal: Develop a web application that personalizes news content for users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create function...

I'm seeking a skilled crochet pattern designer with an expertise in amigurumi. The goal of this project is to create a set of intermediate-level amigurumi patterns which will be listed on my Etsy store. Here are the key details: - Type of Patterns: The scope of this project will involve the creation of patterns for amigurumi, as opposed to other crochet items like scarves, hats or blankets. - Target Audience: The end users of these patterns are primarily gift givers. Therefore, the designs should be appealing and suitable for people to create as gifts for others. - Level of Difficulty: The patterns should be of an intermediate level. This means that freelancers who take on this project should be comfortable creating more complex designs in the amigurumi style. Your role in th...

ooking for a women communicator with great English skills to complete easy chores. Responsibilities include having regular discussions across multiple dating platforms. The final goal is to quietly shift folks from dating applications to Instagram chat or Snapchat app. This gig runs on a per commission basis and will cost $5. My virtual assistant can close an appointment in 15 minutes or less. I'd imagine. Some minor fluff discussion is required. One out of every five leads to a sale in less time. So, for now, I'll put the fee at $5. A minimum of $200 to $300 a month can be earned from your phone. only working one hour or less per day I'll be delivering two canned lines. You simply use it multiple times, but you can customize it to suit your preferences. I am onl...

I am seeking a skilled professional to develop a facial biometric validation system that ensures high accuracy. This system will be integrated into both a mobile and web application for the sole purpose of identity verification. The primary goal of this system is to prevent fraudulent activities and provide enhanced security. Key Responsibilities: - Develop a robust facial biometric validation system with a high level of accuracy - Integrate the system seamlessly into both a mobile and web application - Implement features that support identity verification Ideal Skills and Experience: - Proficiency in developing biometric systems, particularly facial recognition technology - Prior experience in creating and integrating systems into mobile and web applications - Familiarity with va...

I'm looking for an experienced video animator who specializes in motion graphics. The goal of this project is to create 2D explanatory videos that educate viewers. Key Requirements: - Expertise in creating motion graphics-style animations - Solid experience in creating explanatory educational videos When applying for this project, please emphasize your experience with similar projects. Sharing some examples of your past work, especially related to education, will be highly appreciated. Let's create some exciting, informative videos together.

I'm looking for a professional who can guide me on filming a meeting with 3 iPhones and wireless lavalier mics. The goal is to have the video and audio well-synchronized for post-production editing. Key Responsibilities: - Set up 3 iPhones for optimal video quality - Configure wireless lavalier mics for clear audio - Advise on real-time synchronizing of video and audio Ideal Skills and Experience: - Extensive experience with video production - Proficiency in using iPhones for filming - Knowledge of wireless lavalier mic setup - Understanding of real-time video and audio synchronization Meeting Length: Less than 1 hour Environment: Indoors with controlled lighting I need assistance in all aspects of this setup, including ensuring that the video and audio match up perfectly i...

I'm seeking a lighting technician specialized in stage lighting, specifically for dance shows. The key requirement is expertis...the performance. Ideally, you should have: - Experience working with stage lighting for dance shows - Proficiency in creating compelling spotlighting effects - Great sense of timing and creativity to accommodate changing routines Your role will involve creating a spotlighting plan, setting up the equipment, running tests, and managing the lighting during the performance. Your ultimate goal is to highlight the dancers in a way that enriches the audience's experience. We have a children’s ballet show in a school theatre in weybridge. We need someone on 8 th June for rehearsal and show is Saturday 22 nd June all. lighting per...