Excel vba sql based column 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.
Rad bi izdelal kviz ki bi obsegal razlicna podrocja, za zacetek na primer vprasanja iz racunalnistva, excel-a, podjetnistva,.. V kolikor pa bolje spoznate na kaksno drugo podrocje in se vam zdi da bi bila vprasanja uporabna tudi za ostale, se lahko zmenimo tudi za kaksno drugo podrocje vprsanj. Poleg vprasanja bi bili ponujeni 3-je mozni odgovori, med katerimi bi bil en pravilen. Za vsako podrocje bi imeli vprasanja razlicnih tezavnostnih stopenj, na primer Lahka, Srednje in Tezka. Bonus tocke za: -Vprasanja niso predolga, da ne zahtevajo ravno predolgega branja -Nekaj vprasanj lahko vsebujejo tudi kaksen smesen ali pa nenavaden ponujeno odgovor
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'm an individual start-up seeking a dedicated team for ongoing maintenance and updates for my Flutter-based app, DropIn Surf. The app employs a Firebase backend, Google Maps API, and a Flutter-built admin panel. - The app's user interface and experience require the most attention. - The code can be complex, so I'm looking for someone flexible, patient, and capable of adjusting, fixing errors, and debugging as necessary. - As a start-up, budget is crucial. Ideal candidates would have extensive experience with Flutter, Firebase, and Google Maps API, with a knack for UI/UX improvement. I value a friendly and cooperative working relationship, with a team who understands the needs of a start-up. Please note that I have not yet determined a specific method for ...
...additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized for minimal databa...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
Project Title: Real Estate Cashback Platform Project Overview: This platform is designed to revolutionize the real estate industry by streamlining property sale registration while offering tangible benefits for buyers, developers, companies, and freelancers. It enables property buyers to receive 1.5% cashback of the property value directly into their digital wallet, accessible via a unique barcode. This cashback can be used freely, giving buyers greater flexibility and value. The platform also provides a legally compliant and efficient solution for developers and freelancers to register property transactions, ensuring transparency and accountability throughout the process. Key Features: For Developers and Real Estate Companies: Seamless Registration: Register as a verifi...
...with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - Extensive experience with Microsoft ...
...world’s first Simplified AI Agent Management Platform, designed to empower users by removing the burden of repetitive, labor-intensive tasks. DelegateX allows users to delegate their work to customized AI Agents—your X Bots—freeing up your time to focus on what truly matters. We are seeking design professionals to create a compelling brand identity that reflects our vision, highlights our unique value propositions, and inspires trust and excitement among our diverse audience. Challenge Goals We aim to establish a brand identity that: 1. Communicates Empowerment Through Delegation • Showcase how DelegateX enables users to “leave their worries behind” and delegate tasks to AI agents across various domains. • Examples include campaign me...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirem...skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data r...
? We’re Hiring: Short-Form Real Estate Video Editor (Fast Turnaround Needed!) ✨Offering pay for every edit completed✨ Are you a skilled short-form video editor who knows how to turn real estate talking head content into engaging videos under 60 seconds? Do you excel at delivering scroll-stopping edits quickly while maintaining quality? We’re looking for someone who specializes in short-form content that captures attention and drives engagement! What We’re Looking For: Expertise in editing short-form real estate talking head videos (less than 60 seconds) Strong knowledge of platform-specific trends (Instagram Reels, TikTok, YouTube Shorts) Ability to create dynamic captions, transitions, and hooks that capture viewers' attention in the first 3 seconds Ef...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
...secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformatio...
...throughout the transaction process, addressing any issues or delays promptly. Maintain meticulous records and follow up to ensure smooth deal closures. What We’re Looking For We value creativity, organization, and professionalism. The ideal candidate will: Have excellent communication skills (both written and verbal). Be confident making outbound calls and thrive on building connections. Possess a knack for design and marketing (experience with Canva and Constant Contact is a plus). Demonstrate exceptional organizational skills and attention to detail, especially when coordinating transactions. Be self-motivated and excel in a remote environment. Have interest or experience in real estate (wholesaling or transaction coordination experience is a bonus!). Why Join Us?...
I am seeking an experienced sales professional, specifically a senior-level candidate, to close sales for my consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience i...consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience in consulting industry - Experience in recruitment - Exceptional communication and negotiation skills - Ability to understand and convey the value of our services - Committed to making a positive impact Required: - Be located in the Pacific Northwest - Be open to commission-based work Desired: - Mission-based (you wa...
My web-based driving school management system built on PHP is facing some issues that need urgent attention. Ideal Skills and Experience: - Extensive experience in PHP development - Proven track record of troubleshooting web-based systems - Ability to improve system performance and user experience Please note, specific issues with the system have not been identified yet, and it would require a thorough examination of the system to determine the exact problems. The primary users of the system are students, instructors, and administrators.
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I am seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy and speed are of the essence in this project.
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
...presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flow. Please DM...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I'm seeking a medium-sized realistic tattoo design for my arm, to pay tribute to my late grandfather "Poppy", who was my greatest hero. The tattoo should incorporate an excavator, his name "Poppy", his birth and death years (1945 - 2014), and ball...symbolizing the ones we released at his memorial. Ideal skills and experience for this job include: - Proficiency in realistic tattoo design - Experience with sentimental and personal designs - Understanding of incorporating text and symbols within designs - Strong portfolio of previous work - Excellent communication skills to ensure the design meets my vision This tattoo holds significant sentimental value for me and I want it to reflect my love and respect for my grandfather. Please, only apply if you have t...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I'm in need of a seasoned PHP developer to create a user login system that caters to different user roles - 'seller' and 'buyer'. This system should incorporate essential features such as login, registration, profile editing, and password resetting. Key Requirements: - Use of MySQL as the database for the user login system. - Incorporation of an email verification service for added security and user authenticity. - Design of a modern, graphics and animation infused user interface for the login system. Ideal Skills: - Extensive experience with PHP and MySQL. - Proven track record in developing user login systems. - Proficiency in creating modern, animated interfaces. - Experience with integrating email verification services. Your expertise in these areas will be ...
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
...brands, About KSTAR: KSTAR, specializes in household disposable products such as kitchen rolls, toilet tissues, aluminum foils, disposable plates, and cleaning supplies. The brand represents modernity, reliability, and practicality, delivering high-quality solutions for everyday household needs. ________________________________________ Target Audience: KSTAR caters to individuals and families who value convenience, quality, and dependability in household products. ________________________________________ Key Design Elements: 1. Style: • Modern and Minimalist: Reflects professionalism and efficiency. • Dynamic and Memorable: Adaptable across various product types, from mono cartons to tissue rolls. 2. Typography: • Use a bold, clean sans-serif font that is easy ...
...step into this versatile role and make an impact. This position offers the chance to work on diverse projects and contribute directly to our success. --- Proposals that do not include answers to all of these questions will be ignored. While we love AI, please do not use AI to answer these questions—we want true, authentic responses. Don’t worry about spelling, grammar, or sounding perfect; we value honesty over perfection. 1. What experience do you have maintaining HubSpot CRM, ensuring data quality, and managing records? 2. If your working hours differ from your local time zone, which time zone do you primarily work in? 4. How many hours a month would you available/provide with your given proposal? 4. Will you be completing this work individually as an indepe...
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-related softwa...
I need a developer to create a new Ethereum-based, deflationary token for me. The token will have a web browser wallet with core functionalities including sending/receiving tokens, token swap features, and transaction history. Key Requirements: - A unique deflationary model where a percentage of tokens is automatically burned with each transaction. - Reflection rewards for holders, incentivizing long-term holding and distribution. - A buyback and burn mechanism to support the token's value and supply control. Skills and Experience: - Proficiency in Ethereum blockchain and smart contract development. - Prior experience in creating deflationary tokens and associated web wallets. - Knowledge of implementing unique token features such as burning mechanisms and reflection r...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
Develop AI backend based on existing templates
I'm in search of a seasoned photo editor who can enhance my furniture product images. This is not a one-off task, but a continuous collaboration; e...Correct any uneven lighting. - Retouching: Remove any imperfections and enhance the overall image quality. - Shadow Addition: Create realistic shadows to add depth. - Product Manipulation: Straighten lines, remove wrinkles and imperfections. You will need to put the edited images on a white background. I'm not looking for a quick edit to just put the image on a white background and send it back. I value quality work that makes each product look its absolute best. I can pay by the image, please let me know what your proposed per image rate is. In your response, please include the word "apple" to demonstrate that y...
Solicito apoyo para realizar llamadas a un listado de clientes ubicados en México, con el objetivo de presentar los servicios de mi empresa. Es necesario que se complete un formulario con la información proporcionada por los clientes, incluyendo un apartado de comentarios en formato Excel. El propósito principal de esta tarea es obtener los datos de contacto (nombre, teléfono y correo electrónico) de las personas encargadas de compras y de las áreas de laboratorio.
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
...script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning message, rather than throwing an error. Additional Details: Must be user-friendly and simple to operate. Ensure seamless interaction with MySQL, without causing unnecessary l...
I'm in need of an experienced app developer to help me create a web app focused on enhancing productivity. Key Requirements: - Expertise in web app development - Strong understanding of productivity tools - Ability to design intuitive and user-friendly interfaces - Experience in creating seamless, efficient, and high-performance applications Your bid will be evaluated based on your relevant experience, portfolio of similar projects, and understanding of productivity tools. Please include examples of previous web app projects you've completed, particularly those focused on productivity. Looking forward to your proposals.
...dedicated to cafés, restaurants, bakeries, pastries .... -------------------------------------- SET GOAL: 8 Sales COMPENSATION PACKAGE : 2920 USD ALLOCATED DURATION: 3 - 4 Weeks ---------------------------------------- PROJECT DETAILS 1. SCOPE OF WORK The Service Provider will provide full marketing services and content management to the Client, including: 1.1. Educate the audience about the app’s value through blogs, infographics, and explainer videos 1.2. Leverage paid ad platforms to increase app visibility and drive traffic to the website/app store. 1.3. Generate Email Marketing Campaigns 1.4. Build direct connections with potential users through partnerships and targeted outreach. 1.5. Leverage food and tech influencers to increase app credibility and awareness....
I'm seeking an experienced developer or team to create a cloud-based, multi-tenant (SAAS model), user-friendly CRM system. The front-end will be built using Angular, while the backend API will be developed using .NET Core. Key Requirements: - The CRM should manage various customer interactions, including email communications, phone call tracking, and live chat support. - It should incorporate sales pipeline management and automatic lead scoring as crucial sales tracking features. - The system needs to handle different types of leads: cold, warm, and hot. - The design must prioritize a user-friendly interface for end-users, coupled with a scalable backend. Ideal Skills and Experience: - Proficiency in Angular for front-end development. - Extensive experience with .NET Core for...
...Manager for Electrical Contracting and Generator Installation Business Description: We are a well-established electrical contracting and generator installation business seeking an experienced and creative Social Media Manager to enhance our online presence on Facebook, Instagram, and other platforms. The ideal candidate will have a proven track record in managing and creating content for service-based businesses, with a specific focus on: Generac generator installations Quotes, maintenance, and repairs Electrical contracting (residential, commercial, and industrial sectors) This role will involve strategy development, content creation, posting, engagement, and performance tracking. Scope of Work: Account Setup and Branding: Create and optimize new accounts for Facebook, Insta...
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
