Progecad 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.
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.
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 seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.
PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/passwo...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) woul...
I require an Excel expert to create macros and VBA scripts to transform my imported Excel data into a specific format. The necessary modifications span across data formatting, calculations, and filtering. You will need to adjust: - Headers - Columns - Rows The data will be imported from another system, so I need a professional who is skilled in data manipulation and can ensure the output is consistently formatted according to my requirements. The format of excel before editing & after editing are attached for your final product should come with a button "Format" which can convert my excels to my required format. NOTE: I need to see your previous works in Excel macros & VBA before awarding this work
Do analysis and create data visualize for company product
I'm looking for an advanced Excel expert who can create a roster maker fo...shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts. - User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours. - Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros. Ideal Skills: - Expertise in Excel and VBA for Macros - Experience with creating complex scheduling tools - Ability to understand and implement conditional formatting and formulas The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have complet...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) woul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatting and stylin...
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, the final output...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
Multiple analytical works and updating of codes and VBA
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write clean, efficient, and well-...
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
...Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payroll - button for creating print page in A5/A4 data on a company letter head based on data size This needs to be developed using excel macros and VBA. Those who are able...
...and contractors, and support client management. Work independently on tasks such as document creation and organization using G-Suite, Microsoft Office (Word, Excel, PowerPoint). Organization and Reliability: Stay organized, meet deadlines, and provide dependable support with minimal supervision. Additional Expertise (Preferred but not required): Experience with SuiteDash, advanced Excel (e.g., VBA, financial modeling), QuickBooks, Etsy, web design, and graphic design is a plus. Requirements: Language Skills: Excellent verbal and written communication in English. Proficiency in additional languages (e.g., Spanish) is a plus. Tech Skills: Proficient in G-Suite, Microsoft Office, Canva, and social media platforms. Reliable internet connection for seamless communication and ...
I'm looking for an Android-based mobile application to load jobs in our maintenance logbook and a Windows desktop management to manage our maintenance logbook. The database will be a spreadsh...such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and check buttons in mob...
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should ...notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, preferably in Python...
I'm looking for a VBA script that will help me manage my schedule more efficiently. The script should take a list of appointments from an attached file and do the following: 1. Insert the appointments into my Outlook calendar according to the specifications in cell B3. 2. Send the appointments to the email addresses listed in column M. The script should be set to run manually, not automatically. I also need assistance deciding on the format for the email notifications. The options are Plain text, HTML, or Rich text. Ideal skills for the job include: - Proficiency in VBA - Experience with Outlook - Knowledge of email formatting Please let me know if you need any further information to give a bid.
Multiple analytical works and updating of codes and VBA
I'm seeking an expert in financial analysis to assess our operational efficiency using historical data. The primary goal of this evaluation is to inform our performance review processes. Key Requirements: - Proficient in Excel, including Excel VBA for complex data manipulation - Experienced in Business Analysis and Data Processing - Able to present findings compellingly using PowerPoint - Skilled in developing pragmatic Business Plans based on the analysis The focus of this project is to evaluate our operational efficiency through specific financial metrics. A deep understanding of performance evaluation techniques is crucial. Please only apply if you can deliver high-quality analysis and clear, actionable insights.
I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks: - Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive. - In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard. - Open another SharePoint Excel file (Excel3) from online and paste the clipboard information. This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.
I need a proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - ...proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - Add new calculations and formulas - Set up automated reports - Fix incorrect calculations - Troubleshoot and rectify data updating issues Ideal skills and experience: - Strong proficiency in Excel and VBA - Experience in creating and modifying Excel macros - Ability to set up automated reports - Aptitude for accurate calculations - Problem-solving skills for troubleshooting d...
I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should include ...
...construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected Deliverables: • A practical and intuitive Excel-based tool that allows: • Budget planning and tracking based on WBS, tasks, and activities. • Monitoring expenses against the budget. •...
Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...
I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Previous wo...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
Excel VBA Macro for Data Capture & Email **Job Title:** Excel VBA Developer Needed for Automated Screenshot and Email Generation Task **Description:** We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks: 1. **Country-Based Data Selection**: - Read a country name selected in one sheet (e.g., "CountrySelection" sheet). - Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed. 2. **Dynamic Data Range Capture**: - Identify the relevant row and its associated columns dynamically. - Capture this data as a screenshot or export it as an image. 3. **Email Integration**: - Embed the screenshot/image into the body of an em...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please include e...
I'm looking for a skilled Python developer to create a script in PyCharm for me. The script needs to load a CSV file with specific headings: Brand, Product Name, Price, EAN/UPC/ASIN. Key Requirements: - The s...Output: - The final report should include: Brand, Product Name, Price, and Number of Bought Items. Ideal Skills and Experience: - Proficient in Python and familiar with PyCharm. - Prior experience with web scraping, particularly from Amazon, is a big plus. - Understanding of CSV file handling in Python. - Ability to deliver a clean, well-documented script. Issues i have faced while doing this in VBA: - amazon dont like more than 50 pings to their website - i made it stop once it get the error screen - sometimes no item identified , so i just skipped it as its not pr...
I want to list a product using sp-api in VBA. You must have your own credentials for development
