Libreoffice macros vba işler

...created in Photoshop for each block photograph. This involves placing the 3D model onto the photograph and adjusting it accordingly. Automation and Catalog Creation: A single Photoshop page containing all phone models is generated. Automation is achieved using a script or plugin in Photoshop. This ensures that when a block photograph is dragged onto the page, the mockup is automatically generated. Macros are recorded to save outputs in the desired format, labeled according to each model. Addition and Updates of New Models: When new phone models are introduced, the 3D models are provided and block photographs are taken. The Photoshop page is updated to include the new models. This workflow guides through the process starting from 3D model creation to mockup generation in Photosh...

...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 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 need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even if missi...

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...Resources: Include references to any documentation or resources needed to perform the maintenance tasks effectively. This could include equipment manuals, maintenance procedures, or safety guidelines. Review and Revision: Regularly review and revise the maintenance listing to ensure it remains up-to-date and effective in managing preventive maintenance activities. This spreadsheet needs to have macros, timelines and charts to illustrate the information inserted. Ideal Freelancer: - Experience in creating preventative maintenance spreadsheets for manufacturing environments. - Advanced skills in spreadsheet creation and management. - Understanding of machinery and equipment maintenance in a factory setting. - Ability to create a user-friendly and intuitive interface for the spre...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, nor... logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong understanding of Excel formulas, formatting, and da...

I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any questions.

I'm seeking a freelance professional to handle computer-related tasks including data entry, spreadsheet creation, word processing and software applications assistance. Requirements: - Proficiency in Windows, MacOS, or Linux operating systems - Experience with various software applications, including Microsoft Office, Adobe Creative Suite, and OpenOffice/LibreOffice - Ability to handle tasks in a timely manner This project is ideal for someone with a strong computer background and excellent attention to detail. Please apply if you meet these qualifications.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplica...macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specifically adjacent cells - Excellent problem-solving skills and attention to detail I will provide the working data sheets and a detailed explanation of the rules for adjacency-based merging to guide the creation of the macro. Any prior work regarding Excel macros for similar data manipulation tasks will be highly...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility wit...compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compa...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data A...Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you are interested in this project, please include any relevant experi...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac ...macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibil...

...I'm not entirely sure if I want the macro to automatically update the original workbooks if the grouped workbook data changes. However, the macro should have the potential for this functionality, so that it can be added at a later stage. The ideal freelancer for this project should have: - Proficient in Excel: An expert in Excel macros, specifically in handling data transfer and conditional logic. - Experience in similar projects: Prior experience in creating macros for data arrangement, especially with conditional logic. - Attention to detail: Given the importance of the data arrangement, the freelancer should have keen attention to detail to ensure the data is transferred correctly. Looking forward to collaborating with a proficient freelancer who can help me effi...

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

...using AWS (transmail) email automation, Zendesk and MailerLite Log-in: Site, Google & Facebook Domain name: Ionos (SSL) **THIRD PARTY APPS** These have been integrated: -Contabo or AWS server -AWS email -Braintree -PayPal -AWS email automation (all membership emails, notifications, requested reminders etc) -Zendesk (set up by Zendesk specialist in conjunction with web developer; API, macros, articles) -MailerLite (API syncing members for company newsletter) -Admin panel (custom) -Google Developer -Apple Developer -Facebook Developer -Userway (ADA) plug in -A few plug-ins text formatting etc. You will be required to sign an NDA. Chosen developer company will sign a monthly Service Agreement. This project is for hire. Completed project is our intellectual...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I need a professional adept at advanced Excel functions to create a spreadsheet, which w...ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more o...

I need a Graphic Designer who can compellingly create a 1 page PowerPoint. This PowerPoint is designed to introduce potential business partners to the steps in deliv...spreadsheet. It must be complete by 13:00 London Time today. The requirements are: - Create a one-page PowerPoint Slide - Tone must be Professional - The target audience is potential business partners - Slide must be completed by 13:00 London Time today - Include "qqq" in your response to show you've read and understand the project details - All parts of the slide must be editable in LibreOffice - Budget is USD 50.00 The spreadsheet will be sent to you before you bid. Ideally, you'll be an experienced Graphic Designer passionate about providing professional appearance and clarit...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or ...custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas,...

Como estas me gustaria cotizarte la creacion de un plugin de wordpress modo calculadora, tengo diseño de como debe verse y el documento con macros en excel que deberia de replicarse para realizar los calculos en el plugin. La idea es que el plugin es que desde la base de datos se alimenta una calculadora (Externa) y esa info se la pueda exportar como un PDF. Debe haber una seccion para alimentar la base de datos (Interna) que ya esta medio avanzada en php.

I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as refe...

...consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the pr...