Excel sql query based on cell valuedela

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

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

need help with spreadsheet formula

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

...consumer services. The ideal candidate will have a knack for closing deals and a solid understanding of consumer behavior and preferences. I'm offering this role on a commission-only basis, with a lucrative percentage of the sales going directly to you. Some key details: - Selling services: The product in question is a range of consumer services. - Target market: Your focus will be on consumers. Therefore, your approach should be tailored to attract and engage individual customers rather than businesses. - Manual reporting: I prefer to track the sales through manual reporting. It is your responsibility to provide accurate and timely reports on the sales you've made. Skills and experience that would be ideal for this role include: - Proven experience in s...

The task must be done via anydesk or teamviewer! i will not share the code because the issue to fix is minor must have knowledge about laravel vite .. i am having an issue with updating the background colour of my app and i am unable to do a proper build.

I need a professional web designer to create a unique design in Figma. The design should be inspired by , , and Key requirements include: - Creation of a design with unique color scheme - The design must be unique, fresh and not a copy of any existing designs. - The style should be based on bespoke designs - a form with fields to get informations about the customer's car - it has to have social proof form google reviews - a stepflow with 3 steps - faqs - and sections containing information about my business

I am in need of a developer skilled in Python for a project concerning the creation of a tablet finder application compatib...skilled in Python for a project concerning the creation of a tablet finder application compatible with Windows. The primary feature of this application must be search filters, specifically, those able to find tablets based on their MAC addresses. Ideal candidate would posses: - Proficient in Python - Experience in creating search filters - Familiar with MAC addresses - Working knowledge of Windows compatibility - Detail-oriented and able to work autonomously. The focus of this project is the development of a reliable application that can perform complex searches based on a tablet's MAC address. This is a specialized task requiri...

...tasks, then update certain field data, like tracking status - When the project is created, auto copy the project’s name to Exhibition. Please see the screenshot. Same thing in task, once select the customer, it will update the title. - Once new task is created (saved), it will update the external MySql tables (there are different tables), send the Customer name, Tacking number, Status, etc… data(value) to there creating or updating the mysql database. Also once the task is updated, like Status, it will update the database in the related record. This is for our tracking system. Users do not need to update tracking system separately. They only need to update everything in Odoo system. Similar case in National Skill Competition module, do exactly the same thing for the...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

I’m seeking skilled machine learning experts capable of creating AI systems focused on preventing physical theft. The primary targets are retail stores, specifically, monitoring theft in aisles and the stock room. Ideal Skills/Experience: - Proficient in Machine Learning - Experience with AI security solutions - Background in retail security systems - Strong understanding of video surveillance tech Duties: - Devise advanced AI systems for theft detection - Prioritize monitoring of aisle and stockroom areas - Implement machine learning to enhance theft prevention - Ensure seamless integration with existing security infrastructure

Our client seeks a skilled contractor to manage a network of 40 WordPress blogs. This is a highly sensitive project due to the volume and value of the websites. Candidates have to send in identification and sign NDA. Key Responsibilities: Systems Administration: CPanel management, database administration (PHP), FTP, firewalls. WordPress Maintenance: Plugin updates, theme management, basic frontend/backend operations. Security Focus: WordPress hardening, malware/infection remediation, firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administra...

We are looking to develop a web-based application using Zoho Creator that allows users to scan QR codes of individual products and barcodes of outer cartons for inventory management purposes. The application will generate reports based on the scanned data, providing insights into the frequency of scans for each unique QR code. Sure, here's a detailed project requirement draft for your freelancing project: --- **Project Title:** QR Code and Barcode Scanning App for Inventory Management **Project Overview:** We are looking to develop a web-based application using Zoho Creator that allows users to scan QR codes of individual products and barcodes of outer cartons for inventory management purposes. The application will generate reports based on...

I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Feature Integration: The first task involves adding a basket feature to the site. The feature should incorporate the ability to both add and subtract items, and should clearly display the total cost of the items in the basket. Additionally, the basket should be designed to support Stripe payment integration so when when paying total cost will be on stripe showing the products. - Registration Redirection Fix: The second task is addressing a critical issue with the registration process. Currently, upon successful registration, the user remains on the registration page. This is not the intended behavior, and I need a solu...

...success fee equal to a % of grant funds awarded. Exact terms to be specified in contract. To Apply: Please submit a cover letter , and 2-3 writing samples demonstrating your grant writing abilities to [insert email address]. In your cover letter, please describe your experience with grant writing and why you would be a strong fit for our startup business. We are an equal opportunity employer and value diversity. All qualified applicants will be considered regardless of race, color, religion, gender, gender identity, sexual orientation, national origin, disability status, or any other characteristic protected by law. The contract freelance grant writer will work remotely but must be able to communicate fluently in English via email, phone and video conferencing. This is an exciti...

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication and session management.

Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria

...intricate elements which are best understood by those well-versed in Simulink. Leveraging your knowledge, I need assistance in modeling simulation, establishing an effective control system design, and performing signal processing. Key responsibilities: - Build a model simulation - Design a stringent control system - Perform signal processing Although the specific task was not clarified, I value a freelancer who can dynamically adjust to the task at hand. Hence, your application should highlight your past work, experience, and a detailed project proposal–these are essential components to your success in this project. The ideal freelancer should display: - Excellent knowledge of Simulink - Previous experience in model simulation, control system design, and signal proc...

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.

...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 th...

hello amazon sp installation do you have apibilgi When we query with asin, can we retrieve information about the products? Example: B01234345 brand, sales, ranking, seller, number of offers etc. information

...includes: - Identifying energy usage patterns to help us understand consumption trends. - Implementing anomaly detection techniques to flag any irregular or unexpected behavior in our system. - Providing actionable recommendations for energy optimization based on the patterns and anomalies identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the ...Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate websites you've created - Description of your experience with React and with real estate website development - A detailed proposal for the project, addressing all functionalities and anticipated challenges - Any suggestions for adding value to the project beyond the basic requirements I am excited about the possibility of collaborating with individuals who bring passion, expertise, and creativity to the table. Let's build somet...

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 need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

...this site will be to create a strong online presence for our business and show our target audience the value we provide. Key Deliverables: - A visually engaging and easy-to-navigate website - Proper display and descriptions of our services - Integration of informative resources for potential customers - SEO optimization for enhanced online visibility - Mobile-friendly design for easy access on all devices Ideal Skills and Experience: - Proven experience in web development and design - Extensive portfolio showcasing a variety of websites - Strong understanding of SEO best practices - Proficiency in modern web development tools and platforms - Experience in creating websites for service-based businesses would be a plus. Please include the following in your applicat...

...costs for feedstock and revenue by product including (renewable diesel, LCFS credit prices, RIN prices and any other revenue sources or applicable tax incentives) - Model Creation: Develop a financial cash flow model that can reliably forecast our cash position over the next 3-5 years. Specifically, I'd like to be able to determine the break evens for a particular feedstock price, or incentive value. Skills/Experience Required: - Strong Finance Background: Deep understanding of financial analysis and forecasting. - Research: Ability to find and interpret financial data to inform the model. - Modeling: Proficiency in creating financial models, preferably in the same or similar context. - Data Analysis: Experience in analyzing financial data and trends to make accurate finan...

My project needs an abstract illustration developed for an advertising campaign. It's ideal for a freelancer with innovative skills and experience in graphic design who appreciates the avant-garde: ATTACH is the image, dont need hand and cards. Instead of tshirt, HAT has to be written - Create a visually stri...pulsating with energy. - The illustration should be creatively dynamic yet clear enough to represent my brand's unique qualities. - This piece of work will be pivotal in our upcoming advertising campaign and can characterize our brand's distinctive visual identity. Previous experience with advertising campaigns and abstract visual design is highly desired. Understand my brand, immerse in our aesthetic value, and redefine it into a fascinating and revolutiona...

Project Overview: We are looking for a talented web developer or development 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 enh...

...Electrical Plan: I'm interested in incorporating energy-efficient lighting into my home. The plan should focus on maximizing energy savings while providing adequate lighting for all spaces. Additionally, I would like to include outdoor lighting in the plan. - Plumbing Plan: For the plumbing, I'm looking for a design that features dual-flush toilets and a hot water recirculation system. I'm particularly concerned about water efficiency and comfort, so I would appreciate a design that reflects these priorities. As a freelancer, you should have a strong background in electrical, plumbing, and HVAC design. Experience with energy-efficient solutions and water-saving fixtures is a bonus. I value clear communication and attention to detail, so please ensure t...

We need to create a web-page for an FX Currency Exchange. Its very comfort because we dont have to link any API or use a hard coding skills. We need the project have very good visuals looking for atract clients. All its made via WORDPRESS We going to bring admins acces to the wordpress project to let the editors make any change as they want. Remember the base of the project has to be the same as the websites examples.. Some examples:

I'm looking for a skilled trading view indicator developer to create an indicator based on fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert sy...

...is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing 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. Gi...

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 seeking a seasoned C++ programmer who can design an array-based heap effectively. The purpose of this project is to handle both max heap and min heap. Here are my specifications: - Implementation of the max heap and min heap within the same array-based heap structure. - The software should be able to execute both Insertion and Deletion operations. - It should facilitate Heapify operation, enabling the optimization of the heap structure. If you possess extensive knowledge and experience in heap data structures and can proficiently utilize this in C++, you are the right fit for this task.

...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 looking for someone who can create an engaging and intuitive design. Your previous experience and expertise in this area w...

...Problems: There are also vital concerns with the user interface layout. Some pages don't render correctly on different screen sizes, and the general responsiveness of the UI is inconsistent. The task would involve pinpointing these problems and implementing effective solutions. • Platform: The application is to be developed for both Android and iOS platforms. Therefore, experience with cross-platform app development will provide a definite advantage. Please apply only if you can work via remote desktop (AnyDesk), have a robust internet connection, start just after be awarded and you are experienced flutter dev. FIXED BUDGET 40 usd including site's fee. Error: Launching lib/ on sdk gphone64 x86 64 in debug mode... You are applying Flutter's app_plugi...

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 looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I'm looking for an experienced web developer to help me create a user area website. The functionalities of this platfor...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 orders, they will receive this value on their backend account after verification by admin - Messaging system: The platform should also have a built-in messaging system that allows users to send and receive messages. ...

...facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, 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 wit...

...a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. 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 ...

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