本人是自僱人士。一向也有一個programme取數據運行來處理我嘅工作需要。現在要開發多一個程式處理新數據。用VBA或Python寫都可以。主要係用excel工作
We are a high-tech company located in Shanghai, China, and we would like to recruit American automotive chip purchasing managers and sales managers in the United States. This person must be an American with more than 10 years of working experience in the US chip industry, and have held positions such as sales, procu...would like to recruit American automotive chip purchasing managers and sales managers in the United States. This person must be an American with more than 10 years of working experience in the US chip industry, and have held positions such as sales, procurement or automotive chip research and development. Our company now has a commercial representative office in Virginia, USA, and is currently opening a chip technology company in Austin, Texas. Our working language i...
需要 接过IB(interactive brokers)的case 用VBA建立过足以交易的程式 懂中文 将别人未完成的项目给完成 需要看得懂别人已写好的程式码 和我的需求之间的关係 具备编写IB 软件的能力 目前我需要的功能是 部位管理 和 部位显示 以 及交易过程纪录 修復已写好 但不能运作的资料输出功能 我希望能先讨论内容 我会尽量说明现有的文件与我的要求等等 再来讨论价格 付费机制 以及我能拿到的时间
Operating Theatre Scheduling Problem(手术室调度问题)
I need a custom size chart for our mens shorts product page. The measurements we need are ATTACHED. We want you to create a clean size chart style design as picture below from another brand. We want you to use the following header for the top of the size chart " Script Shorts Size Chart (cm) but for the inseam section we want you to use inches not cm for that row.. Also...size chart for our mens shorts product page. The measurements we need are ATTACHED. We want you to create a clean size chart style design as picture below from another brand. We want you to use the following header for the top of the size chart " Script Shorts Size Chart (cm) but for the inseam section we want you to use inches not cm for that row.. Also we want you to remove the "bottom ...
**Project Overview:** We are seeking a professional video editor to create a dynamic and engaging 30-second video for social media. The video will feature the opening of a box of trading cards and will highlight the value of each card pulled to demonstrate the potential profit or loss from the initial purchase price of $140. **Objectives:** - Create an engaging 30-second video suitable for social media platforms. - Visually represent the starting cost of $140 on screen. - Highlight and count the value of each significant card pulled from the box. - Display the cumulative value towards the initial purchase price. - Conclude the video with the final profit or loss from the box. **Video Requirements:** 1. **Introduction:** - Start with a clear display of the initial purchas...
I'm in need of a skilled developer who can create a Windows GUI application. This app should be capable of opening and editing a pre-formatted CSV file. Key Features: - The app should have interfaces for inputting free-form English text in certain fields and selecting options from drop-down menus in others. - It must offer normal file saving and opening functionalities. - The design should incorporate a professional and corporate-looking splash screen graphic and an about page. User Interaction: I aim for a straightforward user experience. The app should be intuitive and easy to navigate without the need for an extensive guided walkthrough. Ideal Skills: - Proficiency in Windows GUI app development - Experience working with CSV files and handling user inputs - Strong ...
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.
...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....
I need a professional mailer who can help me forward international mail. I'm looking to have all sizes of mail includin...need you to have a physical mailbox for this purpose, preferably at your nearest post office. I can reimburse your expense for opening a mailbox upon receiving proof (like a receipt from your post office). Ideal Skills: - Resourcefulness in managing a physical mailbox - Strong communication skills and high availability for frequent communication over text - Preferably familiar with filling out customs forms and sending mail internationally - Preferably familiar with crypto (ie Bitcoin) If you have prior experience with international mail forwarding and are confident that you can handle all sizes of packages, please reach out. This is expected to be a lon...
**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, ...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simp...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: Ma...
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 a 3D scale model of our coffee kiosk urgently. Key Project Details: - We want the Kiosk to look like an LA county lifeguard tower - The ramp going up from the left side not the front. with 2 stairs coming down from the right side - the tower will be monted on top of an 8.5 x 12ft flatbed trailer and will be centered in the middle leaving 3ft of decking space either side. The building itself will be 8 x 12ft. - There will be an additional 3ft wide deck at the front of the buiding (off the side of the trailer) with a fence going around the whole building like in the picture
...-replacement of two windows to two larger windows with new header to carry load of second floor above -replacement of a double front door with glass block sidelights to a single pivot door with larger glass sidelights with new header to carry load of second floor above. Window and door manufacturer to supply engineering specs to engineer -removal of upstairs fireplace and replace with wall and new opening to primary bath (non-load bearing) -re-framing of shower wall to accomodate bench (non-load bearing) -additional items to be discussed. I have already met with the city and they are satisfied with my electrical and plumbing drawings that will be stamped by an electrical contractor and a plumbing contractor to be included in my submission. I would like to work with a structural...
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 missing phot...
I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on...from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fin...
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'm seeking a USA citizen to assist me with opening both personal and business accounts. The business entities I require accounts for are an LLC and a Corporation. Key Requirements: - Account Opening: I require the selected individual to guide me through the process of opening personal and business accounts. The ideal candidate should be familiar with the necessary documentation and procedures when dealing with LLCs and Corporations. - Strong Understanding of Banking Procedures: A strong understanding of banking procedures, especially those relevant to business entities, is essential for this task. - Good Communication Skills: The ability to communicate effectively and clearly about financial matters is crucial. This project is only open to individuals...
I'm looking for a proficient video editor who can cut three video tracks of an interview from into a 20-40 minute video podcast. The major tasks include: - Add existing opening and closing graphic - Edit between 2-shot and two single recordings of interviewer and interviewee - Add intro/ outro music - Removing unwelcome background noise - Adjusting the overall mix to yield a clearer sound If compatible, this could be a recurring job 1-2x per month.
I'm seeking a skilled PLC programmer to develop a timed sequence for pneumatic valves used to operate four dampers in a wave pool. This PLC program aims to control the intensity of the waves. The functionality should include: - Sequential opening and closing of the dampers - Pneumatic valve control via PLC interface Ideal skills and experience: - Significant experience in PLC programming - Understanding of pneumatic valve control - Knowledge on wave pool operation preferred - Ability to optimize for energy efficiency and performance - Problem-solving and analytical abilities to troubleshoot and improve system functionality. This challenging task calls for a solution-oriented mindset and innovative thinking. Increased wave control will result in a more engaging and enjoya...
Reques...records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., 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) &bu...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I'm seeking a Macrodroid expert to handle two key tasks: - Automating the opening and closing of certain apps on my Android device. - Automating specific device settings, such as WiFi and Bluetooth toggling, and screen brightness adjustment. The project has a high priority, so I need someone who can start immediately. The ideal freelancer should be well-versed with Macrodroid, particularly in creating complex automation sequences, and be experienced in Android device settings customization.
I'm currently facing an issue where my website isn't opening in a secured connection. I require a proficient software developer who can address this problem by fitting the: - SSL certificate - Firewall settings - HTTPS redirect I've identified these elements as potential causes for the issue. The platform my website utilizes is WordPress, and the SSL certificate in current use is Extended Validation (EV). Ideal skills and expertise for the project would be: - Extensive experience in web security, particularly WordPress platforms - Familiarity with HTML, CSS, JavaScript – particularly, comfort with altering WordPress settings related to these languages - Ability to perform cybersecurity audits and suggest improvements - Hands-on experience with SSL ce...
I'm looking for a talented animator to create an opening title sequence for my YouTube channel, which focuses on philosophy and self-improvement. The sequence should be visually engaging and convey an energetic mood. Key Requirements: - Theme: My channel's content revolves around philosophy and self-improvement. The opening sequence needs to reflect this theme appropriately. - Visual Elements: I'm particularly interested in incorporating symbols into the sequence. It should be done in a way that is not only visually appealing but also carries some significance or meaning related to the channel's content. - Mood: The overall mood of the sequence should be energetic. This is crucial as it will set the tone for the content that follows on the channel. Idea...
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... finishing and aesthetics. Also a small locking design is needed to be implemented. To complete this project, you'll need: - Proficient knowledge in mechanical design - Expertise in working on metallic surfaces intended for functionality - Ability to make an esthetically appealing yet robust design You should be able to take my basic conceptual design, refine the aesthetics and add the necessary technical details for manufacturing, including lock and secure opening mechanism. Your deliverables will be a complete design package, suitable for presenting to potential manufacturers. Project is almost finished, just a few details to finalize are needed. Successful completion of this project might lead to more collaboration opportunities as I have m...
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.
...security. Below are the specifications for the PCB controller: • Automation of the security system: This project requires designing a custom PCB controller which will integrate with various elements of the security system for automation. • Incorporation of alarm systems: The controller should easily synchronize with alarm systems, enabling automated responses in case of triggered alerts. • Seamless integration with access control systems: I wish to automate the access system in my shop, hence the PCB controller must be compatible with modern digital access mechanisms. • Door sensor compatibility: The controller should also connect flawlessly with door sensors, to monitor and log the opening and closing activities. The ideal freelancer for this tas...
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.
Computer Software – Virtual Assistant April 18, 2024 I have 4 computers, that need computer support to make them it work. WHAT I EXPEXT: E...listing 1, I have on older HP laptop, have not used since 2021, run on Microsoft Office Enterprise 2007 Can’t go online: “YOUR CLOCK IS BEHING” - I go to “Update Date and Time” - Go to “Change date and Time” - “X Unable to continue” you don’t have a permission to perform this task. - I tried on Youtube, that was not helpful: “How to Fix Windows 10 Errors 2021 | Start Menu Not Working ~ Settings Not Opening - 100% Fix” 2, LENOVO laptop: IdeaPad 3 15IIL05, Model 81WE, computer running, NO SCREEN, I think malware infection. 3, DELL desktop: don’t have sign in...
I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later...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 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 compatibilit...
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, er...the dataset. Ideal Skills: - 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...
Project 1: You should write a program implementing the calculator's functionality. Interface appearance use graphic buttons (this may be the simplest graphic with a color change), the result of the operation can be presented in the form of binary, octal hexadecimal (additional buttons), enter the history button: opening a new window with information about the actions taken since the application was started, showing the actions in the following lines of the list. Project 2. Create a Music MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Project 3. Create a Mobile Application for a Cafe Restaurant to receiv...
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 Requir...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 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 compatibility issue...
It works only when open the Extensions Settings tab in browser need to fix it to work without opening the extension tab
I've been having an issue with the tabs on my website. They're not opening when clicked. Site: Some more details: - There are no error messages displayed when attempting to open the tabs. - I've tested the tabs on Chrome, Firefox, and Safari. I'm looking for a skilled developer who could troubleshoot the issue and make the tabs functional again. The ideal candidate should possess: - Proficiency in HTML and JavaScript. - Experience in debugging and troubleshooting similar issues. - Familiarity with cross-browser compatibility testing. This is a relatively small project and shouldn't take much time for someone with the right expertise.
...Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to the courier for confirmation. Technical Requirements: Platform: Microsoft Excel and Outlook. Preferred Me...
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
I'm seeking a knowledgeable professional who can guide me through how to view HTTPS calls in Fiddler on Windows that have originated from an Android mobile application (running on either Bluestacks or Nox emulator) This may (or may not) need: - SSL unpinning - ProxyCap to route the traffic to fidd...either Bluestacks or Nox emulator) This may (or may not) need: - SSL unpinning - ProxyCap to route the traffic to fiddler port The session can be conducted remotely, either through detailed instructions or a shared screen conference call for a more interactive experience. Please demonstrate via a video/screen record that you are able to do this otherwise I won't respond. This should show you opening an app (not a browser) in Nox/Bluestacks and the HTTPS calls then being d...
I'm in need of an expert to help me build and implement an automated trading bot specifically for the Binance exchange. The Bot should: - Open position at the opening of specific bar based on EMA: The rules are simple, when bar closes above/below EMA it is counted as a first bar, any other candle after the first bar which do not close again above/below EMA is counted along. When 5th candle is still above/below EMA the bot should open position at opening price of 6th candle. If any candle again closes above/below EMA, counting is restarted. - SL will always be placed at High or Low of one bar back from the candle when position was opened depending on If it is short or long; - TP will always be equal to price difference betwen Open Price and SL price multipied by 6....
I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.
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:...
