Excel user defined function jobs

...planner redesign that comfortably accommodates two users. The main focus of the redesign would be to adjust the current layout and organizational structure to facilitate the use of the planner by two individuals. Features: - The main design adjustment required is a side-by-side layout. This will help distinguish sections for each user, making the planner user-friendly and easily comprehensible. - There should be separate, but equally functional, sections for each user. This could involve daily task lists, a shared goals section, and a personal notes area for each person. The ideal freelancer for this job should have experience in graphic design and planner design. A clear understanding of UX/UI principles, organization, and layout design are essential to ensure ...

I need a web scraping expert to scrape Title, Price, star ratings, delivery window from a specific e-commerce site on a regular basis. - The scraping should cover a range of products, ideally with the ability to specify categories for tracking. - The data needs to be scraped frequently, so automation and scheduling will be crucial. - It's important tha...used to inform pricing strategies and customer service. The ideal freelancer for this project should have: - Proficient experience in web scraping, particularly from E-commerce sites. - Proficiency in programming languages like Python or R for automation. - Good understanding of data management and quality control. - Ability to deliver a scraping tool that is user-friendly and maintainable in the long run. - Expertise in data...

...and mobile versions of Telegram Messenger. The primary function of this bot will be to facilitate wallet balance inquiries for users of the TON (Telegram Open Network) wallet. Key Requirements: - Develop a user-friendly Telegram bot that can be easily used by a wide range of users - Ensure that the bot is compatible with both the web and mobile versions of Telegram Messenger - Implement a secure and reliable system for retrieving and displaying wallet balances - Ensure that the bot can accurately and consistently retrieve and display wallet balance information - Ideally, integrate additional security features for interacting with the bot, such as two-factor authentication, PIN code verification, or biometric verification to enhance user security. Ideal Skills: -...

Need a multi user login where multiple users can connect to my server and access the server using apache gaucomole. It has to be scripted (csh) based as I need to execute on local machine once it is working.

Product information collection for vehicle display control device <Overview> Please collect product information on vehicles or service information that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology displays icon 1, which indicates the function corresponding to a short press, and icon 2, which indicates the function corresponding to a long press, on the display device when a steering wheel switch that allows short press and long press is pressed shortly. At this time, icon 1 will be displayed in a position that corresponds to the position of the short-pressed steering wheel switch, and icon 2 will be displayed in a different position from icon 1.（For example, if fou...

I am looking for an expe...the project: - Develop a minimal Flutter app for Android - Ability to scan iBeacons and display UUID, major and minor values, and signal strength - The app should continue to work in the background - Use a foreground service for background function - Provide a simple text notification from the foreground service - Implement constant detection (ranging) Ideal skills include: - Solid experience with Flutter - Proficiency in Android development - Strong understanding of iBeacons and background services - Good UI/UX skills with a focus on simplicity and user-friendliness - Attention to detail and commitment to providing quality work The successful candidate will have ample experience with similar tasks and will ensure the end product operates smoothly...

...reporting desktop application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of u...

I'm in need of a talented web designer to craft a unique blogging website that oozes Chinese aesthetics. Key Aspects: - Aesthetics: I'd like the website to prominently feature Chinese characters, traditional Chinese patterns, and perhaps even ink painting, all while maintaining a modern, clean look. - Functionality: The primary function of this website would be blogging, so ensuring a seamless, user-friendly interface for this purpose is crucial. Ideal Audience: - The target audience for this project is local Chinese speakers, so the design should cater to their cultural preferences and aesthetic sensibilities. Skills Required: - Proficiency in web design and development, with a strong portfolio showcasing similar, aesthetically unique sites - A deep understandin...

...Push Notification customisation with category link and ensuring the proper function - Item Category ON / OFF in vendor app with two separate timer modules with AM & PM - Need Playstore Or App Store Link (Based on user app platform) with referral code on sharing the referral code - Need two line category icons and need to suffel the icon on module index page - Display Offers Tag on the Category icon - Login page customisation with Otp flow for login - PopUp on index page – landing page - Need Popup screen with item link / store link / campagin link - Need live map moving for Delivery man location tracking on User App - Change Splash Screen - Payment Gateway Already integrated and need some changes (In Present version – User need to enter the UP...

I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be ...

...Scanner:** The main function of the QR code scanner in the app is to link to a website. The QR code scanner should be efficient, accurate, and seamlessly integrated into the app's UI. - **Location Services:** The app should employ location services to track user movement. This functionality is crucial for providing a personalized experience to users based on their real-time location. Ideal candidates should have the following skills and experience: - Proficient in Android app development, with a strong understanding of the Android SDK. - Prior experience with creating QR code scanning features in Android apps. - Expertise in integrating and utilizing location services in mobile applications. - A keen eye for UI/UX design to ensure the app is visually appealing and ...

...this is fixed promptly to restore our ability to analyze and report data effectively. Furthermore, you must connect the online version to the desktop version residing in server. In other words, when the user clicks the online tap, the desktop version starts working including all the functionalities. (local printer .......) Key requirements include: - Identifying the root cause of the loading issue - Resolving the issue in a timely manner to restore system functionality - Connect the online version to the desktop. The online version has a function called chemplan online. When the user click this option, desktop version should become active. The freelancer installed the system says he is busy for few days and can not do it now Skills and Experience: - Experi...

I'm in need of a website that is secure and provides my clients with the ability to register and login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems would also...

...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have proficient ex...

I'm looking for a skilled designer to create a panel for a Morse code puzzle in an escape room. The material for the panels can be either metal or acrylic. I have som...rooms - Ability to create functional designs with metal or acrylic There are no specific dimensions for the panels, I trust your judgement on what would work best for the purpose. Besides the design, two tables of essential data and a link to the Morse code transmitter will be provided, which you will need to incorporate into the panel design. Your primary focus will be marrying form and function, as these panels should not only look fitting for the escape room environment, but also serve perfectly as part of the Morse code puzzle. Experience in designing escape room puzzles would be a plus, however, it&rsq...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am in urgent need of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous. Due to the nature of the...

I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets

As an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA progr...

I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: ...help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...

I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skills and c...

...an experienced mechanical engineer specializing in thermal analysis and simulation to work on a project related to Li-ion batteries. I have already done some work. I don't know about battery modeling on ANSYS Fluent. I am trying to mimic TR using a thermal model. The geometry and the parameters are taken from the research paper (the research paper is attached). I propagated TR using a user-defined function (UDF) on ANSYS Fluent, but I couldn't get a higher cell temperature than the one mentioned in the paper. The UDF contains the data points and Time extrapolated from the research paper (Fig. 5). The heat generation is calculated using q''' = rho*Cp*dT/dt. (The work should be done on ANSYS Fluent). Key Tasks: - Conduct detailed thermal ...

I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.

I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skills and c...

I'm seeking a proficient developer to create an interactive online chat platform for both web and mobile app interfaces. Key Features Needed: -Direct messaging function -Group chat capabilities -Enable both audio and video calls Design Preference: The platform is expected to sport a fun and playful design to appeal to a broad range of users. Ideal Skills & Experience: The project requires a strong background in UI/UX design and the ability to work across both web and mobile environments. Experience in real-time communication platforms is highly desirable. Let your creativity shine and help me build an engaging and interactive platform.

We are currently seeking a skilled developer to create a Chrome extension and associated API. This project will involve the development of an extension designed to interface with a specified financial website, which features dynamic data changes. The primary function of this extension will be to monitor the data displayed on the website's user interface (UI). When any alterations in this data occur, the extension should perform API calls to transmit this data to an API that stores it within a database. Additionally, there may be instances where the extension needs to make API calls based on UI events, retrieve data from the database, and display this information on the UI. There will also be certain situations requiring the extraction of data from external sources ...

Here's a paraphrase of the summaries for the tasks: **Extracting data from images (Task 1a):** * You'll need to add a new function to existing code that can grab specific values from images stored on Google Earth Engine (GEE). * These values, representing features of the land, will be used to train a machine learning model later. **Creating a new feature (Task 1b):** * You'll write some new code to define a new feature based on existing data (called NDVI). * This involves creating a new class that inherits from existing ones to handle this specific feature extraction. **Training machine learning models (Task 2a):** * Using all the features you extracted in Task 1, you'll train different machine learning models for a client. * The client has collected soil s...

please read my comments fully I want to copy the entire of site not sure which flatform used for this site its e-commerce site all you have to do is copy entire site and paste to my wordpress (woocommerce) this is all design, banner, logo, desription, products image, layout, function, all of course,,,after all clear,,, I will work for changes (design, desription.....)

I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in ...

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous...

Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconcil...

I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.

...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...

I need an experienced fi...should include detailed financial projections based on the provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid. Time is of the essence, and I need this completed within 24 hours. Please only bid if you are confident in your ability to deliver accurate results in this very tight timeframe. This needs to be done in 24 hours or less, it cannot be done a...

...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...

I need an expert in graphic design who can create captivating and detailed product descriptions for electronic products. The work will entail conveying technical information about each product in an understandable, appealing way. Ideal Skills: - Strong graphic design skills with experience in product descriptions. - Familiarity with electronics, their function, and features. - Strong technical writing abilities. - Experience in creating content for retail/e-commerce platforms is a plus.

...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...

Seeking a skilled writer to construct an article less than 500 words in length. The specific subject area of this piece has not been defined, though it will undoubtedly delve into the realm of technology. The target audience is the general public. Ideal candidates will have: - Strong general knowledge of technology - Experience writing for the general public. - Ability to write engaging and accessible content about complex topics. - Proven ability to adhere to a word count and project deadline. Your expertise will help us simplify complex tech subjects for day-to-day tech enthusiasts, making technology approachable and interesting. Your writing style should be accessible and engaging, free from industry jargon. I look forward to collaborating!

I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.

I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...

Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.

...WordPress template and WooCommerce. The primary focus of this project is to enhance the existing website to function effectively as a portfolio. Key Features: - **Service Listings**: The main aspect of the website is to present my services, so ensuring that these are well-organized, visually appealing, and easy to update is crucial. External Integrations: - **Social Media Platforms**: I'd like seamless integration with social media platforms to increase the site's visibility and user engagement. - **Email Marketing Tools**: Integration with email marketing tools to help me stay connected with my clients and potentially attract new business. - **Payment Gateways**: Ensuring secure and user-friendly payment gateways for potential clients to easily acquir...

As we discussed in the chat, I will deliver the work within the given deadline.

I need a skilled and experienced fabricator to create a steel enclosure panel for me. - Material: The enclosure panel should be made from steel. - Function: The primary function of this panel will be to serve as an electrical housing. - Finish: The enclosure panel should be finished with a powder coating. The ideal freelancer for this task should have a solid understanding of metal fabrication, particularly working with steel, and experience in creating custom electrical housings. It is important that they are able to adhere to the specified finish requirements, in this case, a powder coating.

I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be deliver...

Kotylin and JAVA engineer is wanted for crypto wallet. 1. Detect the location in the files where connection information to DB is defined and analyze how app and DB are connected. 2. Change DB name and password on app and DB sides without causing any trouble and make the system work.

I am a Windows user looking for a Linux tutor to help me learn the basics of using this operating system. I would prefer to receive the lessons in the form of video tutorials. Key Requirements: - Teach the basics of using the Linux operating system - Lessons should be in the form of video tutorials Ideal Freelancer: - Proficient in Linux operating system - Experience in creating educational content - Ability to explain complex technical concepts in an easy-to-understand manner

I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...

Looking for a mascot for my business. I have attached examples of what I'm looking for, but it needs to be SIMILAR but DIFFERENT than these logos due to copyright. It just needs to be a black outline. A sun. With rays. Cute face with eyes defined (instead of a dot) Arms and legs. It needs to feel happy, empowering, and confident. It's going to be a mascot for my company. These might go on shirts as well as other materials. I've also attached my company logo so you can see the vibe. Please provide various versions of something similar. If you win, I'd likely pay you to create different versions/poses of the logo. Key Requirements: - Proven track record of creating minimalist designs - Strong aesthetic sense with an eye for detail

I need a full CRM software with access to the source code. The CRM should specifically provide excellent contact management functionalities. Core Features Required: - Contact Management: This should come with both contact categorization and history logging. The contact categorization should allow flexibility through both custom tags and pre-defined categories. Ideal Skills and Experience: - CRM Software Development - Database Management Systems - Customer Data Management - UI/UX Designing The final delivery should include source code and straightforward instruction for set-up and use. Having experience in CRM software development is mandatory. Please ensure your proposal includes relevant past works before bidding.