Useful user defined functions exceldela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I need a professional with extensive experience in Fuzzy Logic and Matlab. Since I haven't defined the exact task or domain, I anticipate your ability to tackle various applications ranging from control system design, pattern recognition, forecasting, robotics, financial analysis, to traffic control. The final output, yet to be specified, could be anything from improved system performance, enhanced decision-making, or better data analysis. Since the assignment specifics are yet to determined, I require someone who is flexible, creative, and solutions-oriented. Matlab proficiency is a must.

I have a simple C/C++ program that needs debugging on an urgent basis. I need someone who's an expert in C and C++ and can quickly identify and fix any errors in the code. Ideal candidate should: - Be proficient in C and C++ - Have a good understanding of basic functions and structures in C/C++ - Be able to quickly debug and fix errors -Syntax and Analysis Parsing - Have good communication skills and be able to work under tight deadlines The project is simple in terms of function and structure, so it should be quick work for the right person.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

...share E-books, articles, online courses, case studies, white papers, and online applications. - User Interaction: The success of this community hinges on dynamic user interactions. Therefore, the forum should support posting comments and replies, creation and participation in groups, as well as private messaging between participants for more personal or in-depth discussions. Ideal Skills for the Task: - Strong experience in forum or website design and development - Familiarity with online resource sharing mechanisms and educational content - Proficiency in integrating messaging and group creation functions into a website - Understanding of user experience to ensure seamless navigation and user-friendly interface design If you find resonance with ...

I'm in need of a highly proficient developer to construct a movie website. The site involves various functions, namely: - User Login System: Subscribers should be able to create accounts, manage their details and alter passwords when necessary. - Subscription Management: An in-built system for users to opt for various subscription plans is required. - Dashboard Capabilities: The interface should include features to manage both users and subscriptions with ease. Content management is key too. - Email Verification System: The website should ensure user genuinity through a secure email verification approach. While I've not yet specified the genre, potential freelancers should possess an adaptable mindset to accommodate possible additions in the future. Moreover...

I'm in need of a highly proficient developer to construct a movie website. The site involves various functions, namely: - User Login System: Subscribers should be able to create accounts, manage their details and alter passwords when necessary. - Subscription Management: An in-built system for users to opt for various subscription plans is required. - Dashboard Capabilities: The interface should include features to manage both users and subscriptions with ease. Content management is key too. - Email Verification System: The website should ensure user genuinity through a secure email verification approach. While I've not yet specified the genre, potential freelancers should possess an adaptable mindset to accommodate possible additions in the future. Moreover...

I'm currently experiencing some issues with my website that require a developer experienced in CodeIgniter and PHPMyAdmin to resolve. Additionally, I require some new functions to be added to my website's admin panel. Key Areas of Work: - Fixing Error Messages: The site is currently displaying error messages related to database connections and functionality. These need to be debugged and resolved. - Adding New Functions: I'm looking to enhance the admin panel with new features in the following areas: - User Management: I need a more robust user management system to be implemented. - Content Management: The content management system should be optimized for smoother operation. - Reporting and Analytics: I require better tools for analytics an...

I'm lo...proficient in implementing JWT-authentication and integrating Keycloak with SpringBoot. The project aims to create a robust, secure user authentication system. Key project requirements: - Implementing JWT authentication. - Integrating Keycloak with SpringBoot. - Developing a secure login system for a large user base (more than 1,000 users). - Managing user roles and permissions dynamically, allowing admin users to control them. Ideal Skills and Experience: - Proficient in SpringBoot and Keycloak. - Strong experience in implementing JWT authentication. - Prior experience in developing secure systems for large user bases. - Knowledge in setting up dynamic user roles and permissions, especially in a SpringBoot environment. - Ability to deliv...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I'm in need of a skilled developer to integrate an SMS provider into my website. The main goal of m...provide SMS related services to our clients. The primary SMS provider we are planning on using is Plivo. Key Responsibilities: - Integrate the Plivo SMS API into the website, ensuring it functions seamlessly. - Implement the ability to receive messages through the API, giving our customers a full spectrum of SMS services. Ideal Skills: - Previous experience with the Plivo API is highly desirable. - Proficient in website development, specifically in integrating third-party APIs. - Strong understanding of SMS functionalities. - Excellent communication skills to translate the technical aspects into a user-friendly interface. - Familiarity with security measures, especial...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

I'm in need of an experienced token developer who can create a versatile set of tokens to cater to various needs. The project encompasses: - Crafting both utility tokens and security tokens to align with the diverse functions and requirements. - Developing stablecoins to ensure stability and reliability within the token ecosystem. The tokens are intended for: - Loyalty rewards: The tokens will serve as a form of incentive for loyal customers, encouraging repeat purchases and engagement. - Asset ownership: These tokens will represent ownership of real-world assets, providing a secure and transparent method for asset transfer and management. In terms of distribution, I'm looking for: - Initial Coin Offering (ICO): The developer should be able to manage the process of lau...

...team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advance...

Please apply only if you can start immediately Based on t...succinctly summarize and report on the developed solution, explaining its design, purpose, benefits, and potential areas of improvement. Please note that more detailed information is needed for a comprehensive freelancer proposal. This might include details about your scalability, security, and cost-efficiency requirements or the business context that the solution is intended for. It also would be useful to understand your goals or desired outcomes for the AWS solution and report, such as increased operational efficiency, streamlined processes, or improved data analytics. Despite the current lack of specifications, I'm ready to work with you to develop an AWS solution - tailored for your needs and then write an accom...

...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

I'm in need of a freelancer skilled in Windows server administration and virtualization technology, specifically VMware. Your task will be to set up a VPN server on my existing Windows virtual machine. Key tasks include: - Installing and configuring OpenVPN on the Windows server - Ensuring the VPN setup is secure and functions properly You should have deep knowledge and experience with Windows Server, VMware, and OpenVPN protocols. I'm expecting the project to be done efficiently and timeously without compromising on the server's security measures.

I need immediate help in implementing an OTP-based user authentication system. The project consists of - - OTP-based user authentication: The user should receive a unique OTP via SMS that they would enter to be authenticated. - React Native integration: The user interface needs to be seamlessly integrated and tested. - Node.js and MySQL: The backend should be designed to handle the OTP generation, validation and user details. I have a tight deadline and need this project completed as soon as possible. Ideal candidates should have: - Strong experience with React Native, Node.js and MySQL - Previous experience implementing OTP-based authentication - Able to work quickly and efficiently Please only apply if you're confident in delivering on time.

Please apply only if you can start immediately Based on t...succinctly summarize and report on the developed solution, explaining its design, purpose, benefits, and potential areas of improvement. Please note that more detailed information is needed for a comprehensive freelancer proposal. This might include details about your scalability, security, and cost-efficiency requirements or the business context that the solution is intended for. It also would be useful to understand your goals or desired outcomes for the AWS solution and report, such as increased operational efficiency, streamlined processes, or improved data analytics. Despite the current lack of specifications, I'm ready to work with you to develop an AWS solution - tailored for your needs and then write an accom...

...date and time. - Picture capture functionality: The app should provide an intuitive and user-friendly interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger's landing, and store it for the driver to ensure the accuracy of the pick-up time. The skills required for this job include: - Strong experience in app development, particularly in location-based services. - Proficiency in integrating GPS services, date and time functions, and camera functionalities. - An understanding of flight tracking systems and their integration into applications. As the user interface is of paramount importance, I'm lookin...

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

I'm having an issue with the cookie bar on my landing page. It functions perfectly upon my primary website, but fails to operate as expected on my subdomain, specifically my landing page. I am using the exact same JavaScript and CSS script for both the website and landing page. All is built on custom HTML. Ideal skills for this job: - Expertise in JavaScript and CSS - Vast experience in handling cookie bars and similar web components - Ability to diagnose issues affecting custom HTML websites The selected freelancer will be tasked with: - Understanding the functionality of the cookie bar on my main website - Translating the same functionality to the landing page - Uncover and solve any underlying issues or differences causing the functionality mishap Please note that I'...

Hello, I have a dating app that was developed 4 years ago and is published on Google Play. It was made in JAVA, but now the version is depreciated on the market. What I want for this app is to rewrite the code using Kotlin or Flutter, because this app was made in Java 4 years ago. Within the app it has many functions. Apply for this project and tell me the price at which you would do it. and The estimated time. - Implement in the app (Membership - payment plan with Google)

I'm looking for an experienced web developer to help me create a user area website. The functionalities of this platform should include: - Account Registration: The website must have an account registration feature that requires users to provide their email address, username and password to create their accounts. User data, - Users must verify themselves with documents (kyc) I don't want to use an external system like sumup, only internally, it's easy to verify documents, photo front back and selfie - the admin can create orders and generally activate them for all users or only for individual users - the user can accept orders and then has to rate them - excites have a value that should be displayed in the backend - If users have successfully completed ...

...Scientists BlogsLinks [ ] to an external site. to guide your approach. Each paragraph within the blog should have a clear topic sentence, body, and conclusion with transitions to move from one idea to the next. You will complete a rough draft and a final draft for this assessment. Content: You should focus on the information that you think would be most useful to students. You have two options: You can go for breadth, by including material from multiple topics (weeks) covered in the class; OR You can go for depth and include only material from 1 specific topic covered in the class. To demonstrate originality, include information from at least three sources shared with you within this course or the course you choose to highlight in your blog. You

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...

I’m looking for an experienced developer who can create a 3D product configurator for garage and workshop furniture. Market research has found that our customer base found IKEA's PAX Planner the most useful configurator style. Here, they could change the dimensions of their room, and then drag and drop IKEA's items into the space and 'clicking' together before generating a CPQ and bill of materials. This will require the writing of 'rules' that suggest the user adds products that are necessary for the construction and use of some units. Research has also shown that customers responded well to items rendered in Unreal Engine or Unity. Please consider the cost of this within your quote, or suggest similar alternatives at a lower cost. Key...

I have a private football...private football manager game online. Written in PHP and TWIG. The script has already been adapted to PHP 7 (from PHP 5). 1. Now it has been noticed that 1 function, 1 module does not work properly under PHP 7. This module needs to be adjusted. 2. I need a few minor adjustments and functions in the game and in the admin area. 3. Then I would like to have a new module. A calendar where you can see the days and what matches you have on those days. (Read from the existing database and display). And with some functions. You have to know that every extension to this script will be written in modules. These are then copied into the directories and taken over by the main script. Who can help? Further information and sample images if you are intereste...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

...Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient data flow throughout the application. Frontend Development: Design and develop a user-friendly e-commerce website where customers can browse and purchase generated images. Database Management: Set up a database to manage user data, transaction details, and maintain associations between prompt...

i need to change upload user image with user id from postgress db by using multer node js and also can be able to replace it work only by anydesk or teamveiwer with maximam 3 hours

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

I'm in need of a highly proficient professional who specializes in performing statistical data analysis, particularly descriptive statistics. The ideal candidate should be able to: - Process the data meticulously - Apply comprehensive descriptive statistical techniques - Gauge the data with an acute attention to detail. Although the specific descriptive statistical measures aren't defined just yet, I'm looking forward to your input, so your expertise in measures of central tendency, variability, and position would be highly advantageous. Your ability to provide valuable insights from raw data will be a key driver in our decision-making process. I'm looking forward to a systematic approach to our data processing needs. Please acknowledge your experience with ...

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...

...5 high-quality photos of the product that showcase its features and benefits, ultimately encouraging potential customers to make a purchase. - Develop a product demonstration video that highlights the key attributes of the product in an engaging and informative way. - The photos and video should be designed to enhance the listing's conversion rate, by effectively demonstrating how the product functions and why it's a worthy purchase. Ideal Skills and Experience: - Proven experience in creating Amazon product listings, particularly with a focus on increasing sales conversion. - Proficiency in product photography and videography, with a strong portfolio to match. - An understanding of e-commerce and the triggers that influence customer purchasing decisions. - Creative th...

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

Main notes: - can be developed a variety of ways, but mainly wordpress is what I'm looking for. - should be easily accessible and usable on pc, phone, tablet. - requires the user to make an account with the website before its use. I am currently designing the website, and looking for this program to be created externally on wordpress or whichever way will fit in the budget. Important: Please only consider this project if you will are okay with the budget, and have read through the project outline. Thank you. Project details: basic functions: (the main function is to show what time the user has to work on their goals, and generate a schedule for them to use, factoring in all their tasks in their daily lives) - asks for users input on 'how discipline...

...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...

I'm reaching out through this...which currently exists as a WhatsApp group, to have access to profiles where they can comment on products, engage in forums, and build communities. The functionality required is as follows: An internal client area providing information about the user's account (already created on () but requiring additional information specific to this platform). Image galleries and sliders. Social functions such as social media sharing buttons, activity feeds, or real-time comments. This will be a section within their own website, available in both Spanish and English. They have their own CRM system where any forms or information needed will be connected. They have a server hosting the current website, and this community platform will also be hosted on th...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.