User defined function excel mac jobs

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 Text1 - (And) Work Phase: This is a 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...

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with r...

We are a UK-based company in need of an experienced and capable electronics technician. Your role will involve servicing our storage lockers spread across different locations throughout the UK. I currently have service projects required in Camberly, Elstree, Enfield, Esher, Birmingham, Ipswic...working condition. - Troubleshooting and diagnosing locker problems, specifically in relation to mechanical faults and electronic component failures. Your knowledge and skill in handling storage lockers, coupled with your ability to adapt to different locations, will be pivotal to our operation's success. We look forward to leveraging your technical expertise to ensure our lockers' continuous function. Knowledge of electronic component failures and mechanical faults is a must ...

I'm in need of an IT professional who can not only assist me in integrating text generation GPTs into my current website but also aid in the development of an iOS mobile application that mirrors its functionality. - GPT Integration: Expertise in connecting and integrating text-generation GPTs is crucial. This will involve a thorough understanding of how GPTs function, and we can use an existing subscription model interface. - iOS App Development: I'm also looking for someone with a solid history in iOS app development to replicate my website's functionality in mobile application form. In conclusion, the ideal candidate will have deep experience in iOS app development and the use of existing subscription model interfaces and GPT integration. They will be adept in ...

I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts

Please Sign Up or Login to see details.

...collaborate with us in revamping our current website. Our website consists of seven pages, and while the fundamental structure is in place, we're looking to implement several updates to elevate its overall appeal. These updates include refining content placement, optimizing imagery, and enhancing the overall user flow for maximum engagement and conversion. Tasks: 1. Implement necessary updates as per provided requirements. 2. Elevate design aesthetics to create a visually stunning website. 3. Enhance user experience through intuitive layout and navigation improvements. 4. Optimize the website for responsiveness across all devices, ensuring seamless functionality. Requirements: (NOT WORDPRESS PROJECT) We require a freelancer with proven expertise in both website deve...

...requirements. Creating interactive reports and dashboards with Power BI for data visualization. Successfully ties together multiple data sets from various sources, including the development of custom connectors for third-party or in-house APIs. Develops and presents proofs of concepts to project stakeholders. Utilizes Power Virtual Agents to create AI-powered chatbots and virtual assistants to function in accordance with client/scope parameters, including those related to data security and other governance requirements. Provides technical support and maintenance for Power Platform environments. Acts as a presales consult to help a client identify appropriate solutions, determine project scope, tasks, and budget requirements for Professional Services engagements, interfacing...

I'm in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west ha...

...bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: • Maintain rigorous data accuracy • Finished product will closely replicate the information found in the original bank statements using...

I'm in search of a highly experienced SharePoint developer to handle the development of SharePoint workflows. Ideally looking for a Sharepoint developer with accompanying graphic design skills, but we also ha...but we also have in-house designers who can support the project. Key responsibilities: - Develop SharePoint workflows: Create efficient workflows that align with our business processes and enhance productivity. - Desktop user support: The workflows should be exclusively designed for desktop users. Ideal candidate: - Proficient in SharePoint: A seasoned expert in developing SharePoint workflows. - Strong problem-solving skills: Ability to understand and work around complex business processes. - Attention to detail: Ensure workflows are accurately implemented and fun...

I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.

Without a specific direction, I will need a competent React developer to build a versatile application using Vite. Given the skipped questions, adaptability is key for this project as the exact needs have not been defined yet. Key Aspects: - Creative input: Since there's no defined purpose, I welcome your impressions and suggestions for the application's purpose and direction. - Feature implementation: Familiarity with common React features like user authentication, search functionality, and payment gateway integration is necessary. - Design flexibility: A knack for various design trends—minimalist, modern and sleek, or colorful and vibrant—will be helpful. Ideal Skills: - Extensive experience in React.js and Vite. - Strong creativity and probl...

I have a function called loadJSON that reads a JSON file and loads features on a Google Map. This function seems to be limiting results on the map to 5,000 features. On the largest project, there are about 80,000 features that need to be loaded. Is there a way loadJSON can be modified to allow more than 5,000 features? Is there an alternative to loadJSON that can be used to read a JSON file and split it into feature objects? I am looking for somebody that has prior experience with this particular issue. A code sample or reference that leads me to the solution is all I am asking for - you do not have to make code changes. I must be 100% happy with the guidance given and it must lead me to a solution.

Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.

I need a skilled Arabic typist to enter data from PDF, into a single excel table .

I'm seeking a talented Wordpress developer who is flexible and creative to help craft a yet-to-be-defined website. Since I'm not certain of all the details at this point, your insights and experience will be crucial in giving the website both form and function. Key Requirements: - Expertise in Wordpress website development. - Ability to collaborate and provide design guidance. - Preparedness for an open-ended project, as the specific scope isn't defined. - Willingness to adjust project plans as needed. Ideal Skills and Experience: - Proven experience in developing engaging, efficient Wordpress websites. - Proven experience in considering and advising the purpose of a Wordpress website - whether it be blogging, e-commerce, or informational. - An aesthe...

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

I am seeking a seasoned PCB designer for my upcoming project. The project involves the design of a double-sided PCB to be used in an embedded system for a power electronics, consumer product. Key requirements are: - Profound understanding of PCB design for embedded systems - Experience with power electronics The primary function of this PCB is power management. Thus, proficiency in optimizing PCB designs for energy efficiency is highly desirable. The PCB should include the following features/components: - Microcontroller - Voltage regulator - Display interface - Resistance - Capacitor - Diodes - Integrated Circuits - Transistor - IGBT - MOSFET Experience in integrating these components on a double-sided PCB is mandatory. Please detail your related experience and skills in yo...

I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.

VM CREATION (1 VPS BIND) os CentOS 8 & 9 Stream MINIMAL Direct installation or converted from CentOS 8 Linux. (Recommended) panel add install: nginx server VARNICH APACH very important !!!!!snaphopt image creation just servers worki...(without admin panel)!!!I want to be able to do restores, for a new installation of another panel, if necessary.! !!! !! !!!!!! link to server add SSL ADD ALL PHP CGI AND FMP (latest 6 versions)PHP AVAILABLE FOR CUSTOMER FOR ALL SERVER ADD PHP VERSION 7.9 PACHT FMMPEG add latest version change SSH22 port verification example: ns1 . add IP.: add a Mac machine adds IP.: adds mac Example of adding HOSTENAME:

...top centre of the page. We already have a logo in mind. Text Options: Below the logo, there should be an option for the user to choose between "Full Text" or "Abbreviated Text." Full Text: When selected, the petition text will display in detailed, multi-paragraph format. Abbreviated Text: When selected, the petition text will be displayed in a concise, single-sentence format. Content Layout: Below the text option, there will be six stacked rectangles. Each rectangle will represent a key point or section of the petition. Rectangles: Each rectangle should have a clean and minimalist design with a defined border. Inside each rectangle, there will be a circle on the left side, contain...

I'm looking for a professional and experienced freelancer to set up a split test for a landing page using VWO.com. The primary goal of this test is to measure the conversion rate. Key Responsibilities: - Set up a 50% to 50% split test for a landing page using - Measure the conversion rate accurately and provide detailed insights Ideal Skills and Experience: - Proficient...accurately and provide detailed insights Ideal Skills and Experience: - Proficient in using for split testing - Demonstrated experience in setting and analyzing split tests - Strong understanding of conversion rate optimization - Ability to provide actionable insights based on test results Please note, the specific elements or variations to be tested in this split test have not been defined by the client...

I am in need of a skilled technician who knows all about the GoPro 12 setup and usage. Even though I'm not experiencing any specific issues or error messages during the setup, I still need help using it to its full potential. The ideal candidate is: - Well-versed in working with GoPro 12s - Capable of providing training for use and function - Able to offer general tech support I hope to gain a sound understanding and knowledge of this device, including all its features, after our session(s).

I am in need of a skilled React Native developer who is experienced in integrating NFC technology into cross-platform (iOS and Android) mobile applications. The primary function of the NFC feature in this app will be for Access Control purposes. Key Requirements: - Proficient in React Native and development for both iOS and Android platforms. - Experience with NFC technology and integrating it into mobile applications. - Prior projects or a strong understanding of Access Control systems. I'm looking for someone who can not only develop the app, but also advise on best practices and design considerations to ensure the NFC features are implemented in a seamless and secure manner.

I'm in need of someone who undrestands Windows Certificate Authorities. I am trying to setup Windows Hello For Business but am getting a KDC error: The client has failed to validate the domain controller certificate for SERVER.DOMAIN.local. The following error was returned from the certificate validation process: The revocation function was unable to check revocation because the revocation server was offline. Key Requirements: - [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] - This environment requires me to control the input. This means I can only give you view only of the server.

...Understand the principles of text recognition, and possess the skills in developing a feasible and efficient solution. - Must be capable of programming in Python or similar languages – necessary for integrating the algorithm with Raspberry Pi 4B. - Familiarity with image processing and Raspberry Pi is highly beneficial, though not strictly compulsory. - The algorithm should be versatile enough to function accurately in varying lighting conditions, both indoors and outdoors. Hence, a deep understanding of image manipulation and light conditions is required. By engaging in this project, you would leverage your coding skills to build an intricate system that can handle text extraction efficiently and effectively. This is not merely an exercise in technical depth but also crea...

I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.

Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.

This project focuses on the creation of an interactive and modern dashboard using React. The dashboard should be responsive, user-friendly, and equipped with advanced features for data visualization and analysis. Specifically, it will function as a viewer for analytics and statistics. The project should also include a login page, profile management, and preferences settings. Only graphic mockups are needed at this stage.

...showcased, locked up. The other location, some items (like shirts, sweaters..etc) can be left in the open to maybe try on? Maybe hung from a wall or case mounted hangar? -There will need to be some form of storage to house stock in either the cabinet or space. -The focus isn't so much the cabinet/storage, but the design of the space. As mentioned, this is a small space and are small parts of a function passenger terminal. But it needs to represent a small store. Some thoughts: - Maybe some vintage physical signs? Vinyl on the walls/cabinet? OTHER: - The airline is Air Tindi - Check out for colours and overall feel. - I'm thinking about calling the store "The Air Tindi Outpost" - I've attached some pictures of one our spaces. It's within our Floa...

...professional to 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. ...

I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.

I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this 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...

...the problem might stem from the following: - *Third-party plugins*: There's a possibility that one of the plugins embedded on the site is conflicting with Safari. - *Custom JavaScript*: Some custom JavaScript code may not be compatible with Safari's rendering. - *CSS animations*: The animations could be causing a conflict that halts the loading process. - *Api calling*: The API calling function might not be working correctly on Safari. **The Ideal Candidate:** - **Strong React JS Experience:** You should be well-versed in React JS and its compatibility with different browsers, especially Safari for iOS. - **Debugging Expertise:** Proficiency in debugging and identifying issues within complex web applications. - **Experience with Third-Party Plugins:** A good un...

We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...

As discussed I have delivered the excel workbook. Thanks!

...the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility

I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...

I am looking for a freelancer skilled in Google Maps in order to integrate a yet undefined functionality to either a website, mobile app, or desktop application. As the specifics of the Google Map project features and purposes have not yet been defined, I need a versatile professional, with a broad skill set in Google Maps, including, but not limited to: - Give 5 star rating and add comment only Critical thinking and problem-solving skills are paramount as the project requirements and purposes may change.

I am in need of an expert developer who can modify my user registration screen to be only accessible to administrators. Key Details: - The platform or framework of the user registration screen is unspecified. So, having significant experience in multiple frameworks like PHP, JavaScript/Node.js, Python/Django will be beneficial. - The registration screen currently has some security measures in place. Knowledge of secure coding practices is a must for this job. - The chosen developer will bestow full permissions to the admin. Therefore, the freelancer should understand well about user permissions and roles in a web application environment. The perfect freelancer for this job should demonstrate strong attention to detail, proficiency in multiple coding languages, an...

I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.

I'm looking for an experienced Java developer who can integrate a cloud-based da...Prior experience with database integration - Specifically, experience with cloud-based databases, Microsoft Azure in particular, is a big plus The Project: - Your primary task will be to integrate Microsoft Azure, a cloud-based database, into an existing Java project. - The project already has a well-defined structure and the database will serve as a key component. - The database integration should be secure, efficient, and scalable, meeting the highest standards. - There will be no need for user authentication or API integration, as this project is solely focused on database integration. Please only apply if you have good experience with Java and database integration, preferably with ...

...looking for a unique WordPress plugin development that will create and manage a comprehensive glossary, aiding in the improvement of site's SEO. Here's what I need: - A glossary plugin designed primarily to enhance the SEO of search terms. - Once glossary terms are defined, this plugin should be able to creatively use these terms to automatically create multiple posts. - To add an innovative and dynamic edge, I'd like these posts to be generated using a GPT-4 language model. - These generated posts will be interlinked, hence when a user clicks a term in the glossary, they get redirected to the respective post. Ideal candidates for this project should have: - Expertise in WordPress plugin development - Understanding of SEO principles and strategies - Exp...

We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

Data entry work from home part Tim e

...technology domain. The successful candidate will be responsible for: - Mainly assessing business needs and working together to identify the right solutions - Lending a hand in project management tasks when required - Documentation of a variety of business and functional requirements, using both the Business Requirements Document (BRD) and Function Requirements Document (FRD) formats - Diagramming, primarily creating Data Flow Diagrams (DFD), Use Case diagrams, User Journeys, and Entity Relationship Diagrams (ERD) - Having wireframing knowledge would be a distinct advantage Ideal skills required for this role include excellent analytical ability, communication skills, ability to grasp new concepts, and time management. A grounding in technology is critical for understandi...

I'm looking for an experienced developer who can help me set up the foundation of a Forge app in my Atlassian Jira Windows environment. The main aim of this Forge app is to introduce custom UI elements to our Jira platform. Key Requirements: - Operating System: I'm using Windows, so the setup should be tailored for this environment. - Primary Function: The Forge app should primarily focus on implementing custom UI elements, enhancing the user experience within Jira. Additional Details: - Mobile Support: While I do require the app to be accessible for mobile users, this is not an immediate priority. The main focus is on the desktop experience. Ideal Skills and Experience: - Proficiency in Atlassian Forge platform - Strong background in developing and implementing ...