Vba web spreadsheet işler
...da tabloya çekebileyim (bir tür lookup). 4-Hesaplama ve web servis çağırma: Mantıksız gelebilir ama evet gelen verilerle (ve benim örneğin bir excel sayfaya girdiğim verilerle) bazı hesaplamalar yapabilmeli ve belirli şartlar oluştuğunda bir web servis çağırılabilmeli. Web servis bir URL şeklindedir ve verilere göre değişen dinamik bir linktir. Basitçe bir web sayfası açma içi ama açmadan o sayfayı tıkladığınızı düşünün. [Zaten bunları bilenlerden özür. Çünkü biliyorum soracaklar var] 5-Raporlama ve kontrol sayfası; 4 numaralı kısımda bahsettiğim web servis aynı zamanda bir takım sorgulama ve raporlama imkanları verir (bir tür APİ). Bu ...
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.
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.
Opencart 2.3.0.2 versiyonunu kullanıyorum. Kullanıcı yetkilerini verirken bu işlemi yapmaya yetkili değilsiniz uyarısı alıyorum. Mysql üzerinden de yetki verme işlemlerini yapıyorum ancak yine de düzelmedi. Total import pro eklentisini yükleyince olan oldu.. Bu eklenti düzgün çalışıyor ancak sonrasındaki hiçbir eklentiyi çalıştırmıyor. Konu hakkında yardımcı olabilecek bir arkadaş var mı? Teşekkkürler..
(Sadece Türkçe Konuşan Freelancer'lar için) Ekte verdiğim csv dosyasında her satırda bir Wikipedia makalesine link bulunmakta. Sizden istediğim linke tıklayıp makaleye konu olan kişinin doğum ve ölüm yılını bulmanız ve dosyadaki ilgili sütuna yazmanız. Eğer doğum veya ölüm yılı metinde açıkça belirtilmiyorsa ama kişinin 1910'dan önce doğduğu anlaşılıyorsa (mesela 1905'te mezun olduysa) ya da 1935'ten sonra öldüğü anlaşılıyorsa (mesela 1955'te emekli olduysa) ilgili sütunlara "Evet" yazmalısınız. Bu adımı doğum ve ölüm yılı açıkça belirtilen kişiler için yapmanız gerekmiyor.
(Sadece Türkçe Konuşan Freelancer'lar için) Ekte verdiğim csv dosyasında her satırda bir Wikipedia makalesine link bulunmakta. Sizden istediğim linke tıklayıp makaleye konu olan kişinin doğum ve ölüm yılını bulmanız ve dosyadaki ilgili sütuna yazmanız. Eğer doğum veya ölüm yılı metinde açıkça belirtilmiyorsa ama kişinin 1910'dan önce doğduğu anlaşılıyorsa (mesela 1905'te mezun olduysa) ya da 1935'ten sonra öldüğü anlaşılıyorsa (mesela 1955'te emekli olduysa) ilgili sütunlara "Evet" yazmalısınız. Bu adımı doğum ve ölüm yılı açıkça belirtilen kişiler için yapmanız gerekmiyor.
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
This job requires Turkish knowledge so the rest of the text is in Turkish. Bir devlet kurumu sitesinde ücretisiz olarak yayınlanan verilerin siteden tek tek alınıp excel de istediğim formata getirilmesini istiyorum. Maksimum 3-4 saatte bitecek bir iş.
VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accounted fo...
I need trustworthy and diligent a...trustworthy and diligent assistance with a data entry project. This involves managing text-based data from spreadsheets and documents. - Responsibilities: The primary responsibility will be organizing the provided materials and grouping them by type. - Ideal Skills and Experience: The ideal candidate will have exceptional attention to detail, efficient typing skills, proficiency in Excel or other spreadsheet software, and an ability to distinguish between various types of documents. Experience in data entry would be a plus. Your hard work and organization skills will be vital in successfully completing this project. I look forward to collaborating with a professional who will uphold the standard of this project by providing excellent and timel...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
I'm seeking a professional who can assist me with populating a Google Sheets spreadsheet with text data from existing databases. This is for the purpose of conducting detailed data analysis. Key Responsibilities: - Locate and extract image links from existing databases - Ensure accurate and error-free input into the Google Sheets - Paste the image links into the right product row Ideal Skills and Experience: - Proficient in using Google Sheets and extracting data from databases - Strong attention to detail to ensure data accuracy - Familiarity with data analysis techniques is a plus - Ability to organize and structure data effectively for analytical purposes I'm looking for someone who can work efficiently and provide high-quality results.
I'm looking for a proficient web scraper who can extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with ...
I'm seeking a dependable freelancer for a weekly web data extraction task. The primary purpose of this extraction is for market research analysis. Key Responsibilities: - Conduct weekly web data extraction for market research purposes - Deliver the extracted data in an Excel spreadsheet format Ideal Skills and Experience: - Proficiency in web scraping and data extraction - Previous experience with market research data - Strong attention to detail and reliable turnaround time
I have a substantial amount of survey data, all neatly organized in a spreadsheet. I am looking for a professional with experience in descriptive statistical analysis to help me make sense of it. Key requirements are as follows: - Expertise in descriptive statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calcu...
Hi This is Ed. I need a new spreadsheet we are using with U.S. Government Contractors. It is similar to the project that we did last week and may be able to use that model and tweek it to work. The cells will have to be identifiable so it can be vetted that the calculator is working correctly.
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
I'm in need of a keen researcher who can delve into a provided spreadsheet of businesses for analysis. The data is varied and comprehensive, including but not limited to customer demographics, product descriptions, and pricing information. This is exclusively a RESEARCH project, and will take some time. Because of this I WILL ONLY PAY HOURLY. If you require a fixed price/contract, do not bid, I will not give you the job. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges based on the dat...
I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...
I'm in need of a skilled web scraper who can extract product details from Website 1 and deliver them to me in an Excel spreadsheet. Key requirements: - Extracting specific product details from Website 1. - Organizing and delivering this data in an Excel spreadsheet. Ideal skills and experience: - Proficiency in web scraping. - Strong understanding of data organization and delivery methods. - Experience in working with Excel for data delivery. Your role will be crucial in helping me access and utilize specific product data from Website 1. The neat and organized delivery in Excel will ensure I can efficiently work with this information.
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
...must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's on-brand. - User-Friendly Experience: As well as being visually appealing, the tracker should be easy to use, with an intuitive layout that makes navigation simple for any te...
I need help with a data entry task that involves extracting data from various websites and inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling ...
I have a PDF call log that I need digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational...
We need to develop a script that will massively create descriptions for ~5000 products in a Google spreadsheet. Descriptions should be created via GPT-4 with processing of the product photo, title and current description.
I'm in need of a Google Script expert to create a script for me. This script will primarily update a Google Slides presentation with data from a Google Spreadsheet. Here's what I need: - The script should update only specific slides within the presentation. - These specific slides will be identified by their slide numbers. - The data to be updated will vary, and may include both text and charts/graphs. Ideal skills and experience for this project include: - Proficiency in Google Apps Script, particularly with regards to Google Slides and Google Sheets integration. - Experience with updating specific slides in a Google Slides presentation. - A good understanding of how to handle and update different types of data within Google Slides, including text and graphical elements...
**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. ...
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
I'd like to have a Google Sheets-based Fixed-rate mortgage EMI calculator created. The calculator should require users to input the loan amount, interest rate, and loan term, and then provide the EMI for that mortgage. In addition, the calculator should also include: - An Amortization Schedule - An Extra Payment Calculator - An Affordability Calculator I am looking for an experienced spreadsheet professional who can create these functionalities in an easily understandable and user-friendly format. This project requires a strong understanding of mortgage calculations, Google Sheets and financial formulas. Please reach out if you have the relevant skills and experience.
I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.
...document that I'd like to have recreated in Google Sheets. This newly created spreadsheet should have an additional summary page. Key Requirements: - I require the spreadsheet to have automatic calculations. For example, I'd like the sheet to automatically sum up the tasks, highlight overdue tasks and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the sheet sh...
...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 spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professio...
...to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - 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 o...
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
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.
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
