Vba apr function 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.
Hi. I could not check the last update. It is too late now. Beca...posting step-2 work. It is also a "pre-work." I mean, we will have at leat 2 more steps. All these 2-3 steps are only for preparing us to the biggest one, step-4. ------------- In this work, we will solve the Tick value issue (by working on the old code) And (the followings are simple) Will write the values on the chart by using the "Comment()" function of Meta Editor only. And Will check if our texts (that we wrote on chart with comment function) changes/updates real time and exactly same with the values of footPrint indicator. ------------- About reading from file and all other details, this website will help you (sure you know it): Please find the file also
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.
Merhaba, Elektrik panolarından kullanılmak üzere elektrik-elektronik malzeme üretimi yapan İstanbul - Gaziosmanpaşa' da bulunan bir firmayız. Aşağıda genel olarak belirttiğimiz özelliklerde koruma rölesi tasarımı yapacak elektronik mühendisi arıyoruz. (İstanbulda olması tercihimiz) Project name: Low voltage single phase protection relay 60A. Function : Over/under current (with built in mini current transformer), over/under voltage, time delay - two screens and 6 leds required ,-The design should be carried on with our case -The design should be carried on with our terminals, black one prototypes devices fully working design and schematics , BOM list, PCB design (Gerber), firmware and hex file, human interface program file(please let me know if...
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.
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.
Hello there, On Mongodb, a filtering query will be printed using aggregate. You'll certainly be giving details of mongodb function while not reaching the expert friends on mongodb aggregate queries to be printed without sacrificing performance by using aggregate.
Arkadaşlar aşağıdaki fonksiyonu kullanarak part sistemini kullanıyorum. function film_partlar($args = '') { $defaults = array( 'link_before' => '<span class="rad3">', 'link_after' => '</span>', 'echo' => 1 ); $r = wp_parse_args( $args, $defaults ); extract( $r, EXTR_SKIP ); global $page, $numpages, $multipage, $more, $pagenow, $pages; $output = ''; if ( $multipage ) { $output .= $before; for ( $i = 1; $i < ($numpages+1); $i = $i + 1 ) { $part_content = $pages[$i-1]; $has_part_title = strpos( $part_content, '<!--baslik:' ); if( 0 === $has_part_title ) { ...
Iyı günler Matlab/simulink de çalışacak s-function a ihtiyacım var. Aslında genel olarak C kodlarım var . Bunun üzerinde çalışılması gerek. Özellikle yapmak istediğim şey şu 1. Algebraic ricatti equation online çözülmesi (SDRE controller için) için method Schur decomposition of Hamiltonian Matrix method. Özet olarak C kodunun matlab/simulink s function için çalışacak olması
ffmpeg komutunun codeigniter içine entegre edemiyorum. sıkıntılı duruyor. codeigniter anlayan arkadaşlar lütfen başvursun. ffmpeg command is needed integrate in codeigniter 3.x it must be something like this ; $cmd = "ffmpeg -i bla bla "; exec($cmd); but exec() or shell_exec() function does not work in codeigniter 3.x
BENİM BELİRLEDİĞİM HÜCREYE GÖRE OTOMATİK FİLTRELEME YAPACAK EXCEL VBA YAZILMASINI İSTİYORUM
genel olarak iki tane ethernet araciligiyla baglanmis linux isletim sistemli bilgisayar arasinda komünikasyon saglamak. Bunun icin öncelikle tcp ve udp haberlesme protokolü icin bir c kodu yazilmasi lazim.(Ben se...sistemli bilgisayar arasinda komünikasyon saglamak. Bunun icin öncelikle tcp ve udp haberlesme protokolü icin bir c kodu yazilmasi lazim.(Ben server ve client olarak iki bilgisyara ayirabilcegimi düsündüm ama ne kadar dogru bilemiyorum tabii ve burdan sonraki adimlar icin pek bir bilgim yok ne yazik ki) Daha sonra ise bu c kodlarini Matlab/Simulinkte bulunan S-function bloguna implemente edilmesi gerekiyor. Yaratilan bu s-function bloklarinin yardimiyla bir Simulink modeli yaratilmali ve iki bilgisayar arasindaki...
We have a wordpress website. We want 2 pages with product add function and product sell functions. We have turkish languaged pages and our mobile payment provider gave us turkish php code library to add theese functions. We are waiting your bids. Thanks... ___________________________________________________________________________________________ Selamlar, Wordpress altyapılı sitemizde bir sayfamıza "mobil ödeme entegrasyonu" yapılmasını istiyoruz. İlgili Library dosyası ekte. Çok kapsamlı ve detaylı bir tasarım istemiyoruz. Özetlersek; Bir sayfadan ürün ve fiyatı eklenmeli, diğer bir sayfadan ödeme alınabilmeli. Tekliflerinizi bekliyoruz. Teşekkürler.
...çıktı aaallliii olmalıdır. c. İkilik tabanda bir string içinde verilen sayıyı onluk tabana çeviren recursive bir fonksiyon yazın. Örneğin girdi 01110 ise çıktı 14 olmalıdır. Eğer girdide 0 ve 1 harici bir karakter varsa exception atmayı unutmayın. 2. Recursion uygulaması a. ~lriddle/ifs/pythagorean/ sayfasını ziyaret edin ve orada iterated function system kısmında verilen iki adet fonksiyon vasıtasıyla formülün üzerinde bulunan binary tree fractallerini bir GUI programı ile çizdirebilen bir Java programı yazın. 3. Multithreading a. dosyasının içinde aralarında birer boşlukla ayrılmış N tane tamsayı olduğunu varsayın. Öncelikle ana thread içinde bu sayıları bir tamsayı dizisine okuyun. Ardından...
Makale üzerinden modelleme yapılarak vba programı ile ülke ligi ile ilgili program yapılacak
Flash Builder ile yazılmış mobil uygulamam var. Elimde file_get_contents metodu var. (Parse video name and url from JSON) bu kodu veri tabanım da belirlediğim id satırını ile birleştirmek ve gelen sonuçtaki video linklerine buton ile açtırmak. php kodu aşağıdadır. Bu kodu http://codepad.viper-... bu sayfada çalıştırarak sonucunu görülebilirsin. <?php $json = file_get_contents(''); $obj = json_decode($json); foreach($obj->videos as $video){ echo $video->name .' :: '. $video->url; echo '<br>'; } ?> Bunun için izle fonksiyonuna yukarında ki işlemleri yapacak script yazılabilir mi.? protected function indirVideo3(event:MouseEvent):void { navigateToURL(new URLReq...
Flash Builder ile yazılmış mobil uygulamam var. Elimde file_get_contents metodu var. (Parse video name and url from JSON) bu kodu veri tabanım da belirlediğim id satırını ile birleştirmek ve gelen sonuçtaki video linklerine buton ile açtırmak. php kodu aşağıdadır. Bu kodu http://codepad.viper-... bu sayfada çalıştırarak sonucunu görülebilirsin. <?php $json = file_get_contents(''); $obj = json_decode($json); foreach($obj->videos as $video){ echo $video->name .' :: '. $video->url; echo '<br>'; } ?> Bunun için izle fonksiyonuna yukarında ki işlemleri yapacak script yazılabilir mi.? protected function indirVideo3(event:MouseEvent):void { navigateToURL(new URLReq...
VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.
Türkçe Üye olan kişilerin sosyal medya adresleri SQL e kaydedilecek. Bir trigger vasıtası ile o kişinin platformunda paylaşım yapılacak. Bu yapı SQL server tarafında User sosyal medya adresi - paylaşım başlığı - paylaşım linki - paylaşım gövdesi - şeklinde parametre alacak bir SQL fonksiyonuna dönüştürüp. SQL içine fonksiyon olarak akta...şeklinde parametre alacak bir SQL fonksiyonuna dönüştürüp. SQL içine fonksiyon olarak aktarılmalıdır. English Addresses of persons who are members of social media will be saved to SQL. By means of a trigger that person to share platform. User SQL server side of this building social media to address - sharing the title - sharing the link - shared BODY - in the form of an SQL ...
...downloading them as PDFs. For more information, view our FAQ page and visit for any future documentation needs. Pega Cloud Support user roles have now changed! For more information, please review our support documents Understanding Support User Roles and Managing Support contacts This content is closed to future replies and is no longer being maintained or updated. Links may no longer function. If you have a similar request, please write a new post. Question 1 Replies 215 Views EmiliaA8 Member since 2019 3 posts Accenture SPA Posted: Feb 16, 2023 Last activity: Feb 16, 2023 CLOSED Integration with Social media Report Hello, for a request of our client, we need to integrate Pega with Facebook, Twitter, Instagram, Trustpilot, Apple Store, Google play, Google my business. T...
...downloading them as PDFs. For more information, view our FAQ page and visit for any future documentation needs. Pega Cloud Support user roles have now changed! For more information, please review our support documents Understanding Support User Roles and Managing Support contacts This content is closed to future replies and is no longer being maintained or updated. Links may no longer function. If you have a similar request, please write a new post. Question 1 Replies 215 Views EmiliaA8 Member since 2019 3 posts Accenture SPA Posted: Feb 16, 2023 Last activity: Feb 16, 2023 CLOSED Integration with Social media Report Hello, for a request of our client, we need to integrate Pega with Facebook, Twitter, Instagram, Trustpilot, Apple Store, Google play, Google my business. T...
...form of charts or graphs. Additional Features: - Alcohol Test Device Connection: Ability to connect with an alcohol test device through Bluetooth for added accountability. - Alcohol test result history management - Competition Rank Board: A competitive element where users can see how they rank against others in their sobriety journey. We need to refer to and we add some community function in the app. Ideal Skills: - Proficient in app development for both iOS and Android platforms - Experience in creating social networking or motivational apps - Ability to integrate Bluetooth functionality - Strong UI/UX design skills - Previous experience developing sobriety or health-related applications If you're a passionate developer with experience in creating engaging and user-fr...
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual reports. ...
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
I'm looking for an experienced AR developer to create a cross-platform AR application for Android and iOS. The primary function of the app will be product visualization, with a focus on making it a versatile tool that can be helpful in various sectors. Key Requirements: - Expertise in AR Development: You should have a strong track record of developing AR applications, ideally with a focus on product visualization. - Cross-Platform Development: The app needs to be compatible with both Android and iOS devices, so experience in cross-platform development is essential. - Versatile Visualization Tools: The app should not be limited to a specific product type. It should be designed to cater to various sectors, such as furniture, cars, clothing, and more. If you're confi...
I'm looking for a highly-skilled individual to take on a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsh...Strong design sense is absolutely essential. Being able to balance functionality with aesthetic appeal. - Understanding of typography. While I do not have a specific preference (Serif, Sans-serif, or Decorative), the chosen typeface should mesh well with the overall design of the spreadsheet. This is your chance to practice discretion and create an engaging spreadsheet experience that marries function with form. If you have a gifted eye for design and weaknesses to turn ordinary spreadsheets into beautiful ones, I want to...
... Here are the detailed requirements: - Platform Compatibility: The plugin should work seamlessly on both iOS and Android platforms. - Functionality: The primary functionality involves detecting volume button clicks even when the app is running in the background. The event-triggered by these clicks should be a callback function to the plugin. - Complexity: The event to be triggered is not a simple alert or notification. It involves interaction with a custom callback function enhancing the complexity level of the project. A developer with knowledge of would be ideal. Key Skills and Competences: 1. Proficient in Swift and Java. 2. Experience in plugin development. 3. Skilled in working with Capacitor.js. 4. Strong knowledge of handling callback functions. 5. Understanding ...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and I... - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow easy expansion for adding new sales data, inventory items, saved BOMs, assemblies, types or categories. **Skills Required:** - Demonstrated experience in BOM and Inventory system development. - Advanced Excel Macros and VBA skills. - An analytical approach with a focus on delivering simple and functional solutions. Candidates are encouraged to share examples of previous similar projects. This project aims to deliver a straightforward solution that supports our small home business operations effectively. Budget: Maximum o...
I'm in immediate need of an attendance application that can be used on Android devices and on the web. The main features I'm looking for are QR code scanning for attendance tracking and a robust reporting and analytics system. Key Features: - Android and Web Compatibility: The app should be accessible on Android devices and through a web interface. - QR Code Scanning: The primary function of the app is to scan QR codes for attendance. The UI should be intuitive and easy to use. - Reporting and Analytics: The app should have the capability to provide detailed reporting and analytics on attendance data. This includes but is not limited to: - Tracking attendance trends over time - Generating customizable reports - Exporting data - Visual representation of d...
I'm in need of a skilled Electron JS developer who can handle user interface design and development, as well as cross-platform compatibility testing for m...cross-platform compatibility testing, with a specific focus on ensuring the application works seamlessly on Windows systems. Requirements: - Proficient in Electron JS, with a proven track record of developing high-quality and user-centric user interfaces. - Experience in conducting successful cross-platform compatibility testing, with specific experience in Windows. - Adept at ensuring applications can function offline, as they will be required to support offline functionalities. If you have the necessary expertise and skills in these areas, please reach out. Your participation will be crucial in the successful completion...
I need someone to create a crypto currency buy and sell website for me. It should have the following functions - Secure transaction processing - User authentication and login - Real-time market prices display The site should support Bitcoin and Ethereum only. It is essential that the transactional aspect of the website is secure as this is the main function of the site. I am looking for a freelancer who has experience in developing similar websites and has a good understanding of crypto currency exchanges. A strong understanding of security protocols and procedures is also essential. The project should be completed within a month.
Please read all the photos before deciding whether to do it or not. Be sure to complete the function of selecting variants at the front desk and the data will be switched simultaneously. I'm looking for a skilled developer who can create a custom WordPress plugin for my personal e-commerce website. The main focus of this project is to enhance the user experience and streamline workflow by enabling: - Automatic synchronization of background variant products to tabpress and size guides. - Dynamic change of product attributes such as SKU, weight, length, width, and height based on selected variants on the product page. - Customization of product selection and display. The ideal candidate for this project should have: - Proficiency in WordPress development and plugin creation. -...
... Project Details: Objective: Extract text from provided PDF files and answer specific questions based on the content. Requirements: No use of external libraries for PDF reading and text extraction. Write custom code to parse and process the PDF files. Develop a method to accurately answer questions using the extracted text. Deliverables: Custom code/script for reading text from PDF files. A function or method to process the text and generate answers to the given questions. Documentation and comments in the code for clarity. Skills Needed: Strong programming skills (Python, Java, or any language of your choice). Experience with text processing and file handling. Ability to write clean and efficient code without relying on third-party libraries. Additional Information: Please ...
As a client, I need to embed multiple interactive calculators into my website using iframe. I have the links to calculators for embedding & will share. Ideal Skills: WIX web design, JavaScript, HTML, CSS, UI/UX Design. Experience in integrating applications using iframe on WIX websites will be an added advantage.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
...from specified landing pages. - Activity data of the landing pages from Google Search Console. - Historical data of keywords from linked Google Ads accounts. The model must function optimally regardless of whether data is available from one, several, or all sources, consistently delivering the best possible results. Requirements: - Data Integration: Build interfaces for the above-listed sources to fetch and process data dynamically. - AI Model Development: Develop a model that can predict keyword effectiveness and suggest optimizations based on integrated data sources. - The model must function optimally regardless of whether data is available from one, several, or all sources, consistently delivering the best possible results - User Input Handling: Design...
I need a skilled ERPnext developer who can deliver top-notch technical solutions to improve our system. The project is urgent and needs to be completed ASAP. Key Requirements: - Customization of Sales & CRM, Payroll, Project task management, HR modules: We are looking for someone to tailor these modules to our business needs, ensuring they function optimally. - Seamless integration with erpnext: We need the developer to integrate our system with erpnext seamlessly, without any disruptions in our current workflows. The ideal freelancer for this job would have: - Proficient in ERPnext: Experience working on ERPnext projects and a deep understanding of its functionality. - Integration Skills: Capable of integrating systems smoothly and efficiently. - Urgency: Able to work quickly...
I'm seeking an experienced Wix developer to create a custom block within my Wix account. This block will function as a Content Management System (CMS) with a focus on managing both text and articles as well as photos and videos. Requirements: - Build a custom Wix block CMS for text, photos, and videos - Ensure user-friendly interface for managing content - Allow for easy modification and updating of content - Integrate the CMS seamlessly into my existing Wix account Ideal Skills: - Expertise in Wix platform and Wix Velo - Previous experience developing custom Wix blocks - Strong understanding of content management systems - UI/UX design skills for user-friendly interface - Ability to integrate the block with third-party APIs, if necessary I'm looking for a reliable dev...
I'm using Star Wars Battlefront 2 (2017) on PC and require custom modded aesthetic skins. This will be based on an existing character but it's purely for my personal use. Key Requirements: - Development of a custom skin for a specific character in Star Wars Battlefront 2 (2017) - The skin should be unique and visually appealing, matching the game's overall aesthetic - The skin should function correctly in the game without any bugs or issues - It needs to be compatible with the PC platform - The design must be exclusively for my personal use and not for public distribution or showcase Ideal Skills and Experience: - Proficiency in game design and modding - Prior experience with creating custom game skins, especially for Star Wars Battlefront 2 (2017) - Strong understa...
I am looking for a skilled AI Chatbot Developer to create a customer service-oriented chatbot for both web and mobile platforms. Key Requirements: - Cross-Platform Development: The chatbot should seamlessly function on both web and mobile. - Customer Service: The primary focus of the chatbot's role will be to handle customer service inquiries, providing prompt and accurate responses. - Multilingual Support: The chatbot should be capable of understanding and responding in multiple languages. Ideal Candidate: - Proficient in AI Chatbot Development: You should have prior experience in creating and deploying AI chatbots. - Full Stack Development: Knowledge of full stack development is a plus, as it may facilitate the chatbot's integration into the platforms. - Multilingual ...
I'm looking for a proficient Python developer to create a Session Initiation Protocol (SIP) client for specific platforms. This client will cater to Windows and Linux operating systems. Key Requirements: * The core capability of the Python SIP client will be to facilitate audio calling. Therefore, the developer must focus primarily on this function. * For safety and security, a basic username and password system will suffice for user authentication. Ideal Skills & Experience: * Proficiency in Python language is mandatory. * Prior experience in developing communication applications, specifically in SIP, will be beneficial. * An in-depth understanding of user authentication using basic username and password systems is required. * Familiarity with Windows and Linux environm...
I'm looking for a skilled developer to help create a ...content management system for my website. Key Requirements: - **Purpose:** The main goal of this system is to manage content effectively on my website. - **Primary Users:** The system should be designed for use by the general public. This means it should be user-friendly and intuitive, to cater to a wide range of users. Key Features: - **Automated E-invoicing:** The system should include a function that can automatically issue e-invoices. This is a critical feature for my business operations. Ideal Skills & Experience: - Experience with developing content management systems, particularly for a wide user base. - Proficiency in e-invoicing systems and related technologies. - Strong attention to detail and a solutio...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I am seeking an experienced Python Django developer to take care of the back-end work for a web application intended for specific industry professionals. The required functionalities include: - User authentication and registration: Candidates should have experience implementing secure user authentication and registration systems....integration and management: We need someone with proficiency in integrating and managing databases, ensuring smooth operations for user data handling. - API Integration: Expert skills in API integration are required to establish seamless communication between applications. Your primary goal is to build a strong, reliable backend for our professional web app. We need an expert who can ensure excellent function and optimal performance. Looking forward to ...
