Excel power query pass parameter to sqldela

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'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power...

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and relate...

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquir...

You must to be at least 16 years old and live in Latin America or Eastern Europe. ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable. I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tool...

...worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months ...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, a...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...raw sensor to removal of noise & unwanted signal Algorithm / code for Digital Filter low bandwidth Real time Sensor Signals 1. Analogue Raw data acquisition in real time at 1000 samples per second in 24 bit precision 2. Raw data signal bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(narrow band) notch filter at 50 hz / 60 hz to remove power line interference a & b can be combined as band ...

...monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate f...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy...

Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.

I'm looking to sell a residential solar photovoltaic (PV) system that stands out for its energy storage capabilities and off-grid independence. The estimated space for installation is a medium-sized residence (1,000 - 2,000 sq ft). Ideal skills include: - Expertise in solar panel design and installation - Knowledge of battery energy storage systems - Understanding of off-grid solar systems - Experience with residential projects - Ability to estimate solar power needs based on space size Offer your skills to make this solar PV system stand out in the residential market.

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Pre...

..."Productivity Power Hour". The series is all about boosting productivity and efficiency, so I'm looking for a design that effectively represents this theme. Key Points: - Use the slogan Lead Smarter: Rise Above the Grind! - The logo should be minimalist in style - It should be bright and vibrant in color, to grab attention online - The slogan for the series is "Lead Smarter: Rise Above the Grind!" - this can be incorporated creatively into the design The intended use of this logo will be primarily for online purposes such as websites, social media channels, and emails. It needs to be easily recognizable and memorable, even at smaller sizes. Ideal Freelancer: - Graphic designer with experience in minimalist design - Strong understanding of...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

I'm on a quest to flatten my company's efficiency curve and reduce the hours we spend on manual tasks. I need a savant familiar with Power Apps to help me achieve this. Skills Required: - Proficient in Power Apps, preferably with experience in teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Office 365 integrations within these solutions. - Proficiency in constructing complex, efficient databases. The ideal candidate should have a comprehensive grasp of Power Apps and a passion for education. Seeking to build a one-on-one relationship that will deliver measurable results on the path to automation.

Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.

...projects when you have the time to complete them, take time off when you need (letting us know in advance is good practice). *Easy to work with: We reply to questions fast, will provide valuable input and feedback on every single task you complete. *We've been in the content writing and marketing business for 15 years and have worked with more than 2000 clients. As part of our team, you'll have the opportunity to learn from experienced team members on a daily basis. What we expect: *You'll be part of an International team with a base in Serbia that works for many clients which means you must be able and willing to research various topics. *Your English writing, spelling, and grammar skills need to be of a high standard. *Yo...

I am looking for...am looking for a specialist who can effectively write a RAK 4630 firmware with an emphasis on energy optimization. You should focus on minimizing power consumption when the device is in sleep mode. Key tasks include: - Implement changes in the RAK 4630 firmware to optimize its energy usage. - Concentrate on reducing power consumption when the device is in sleep mode. The ideal freelancer would have: - A comprehensive understanding of the workings of RAK 4630 firmware. - Proven experience in firmware development with a focus on energy optimization. - Familiarity with device sleep modes and their impact on power consumption. Your goal is to maximize efficiency while ensuring uncompromised performance. Please provide evidence of r...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing sour...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

... I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set Mobile App You have an access to the mobile app source code for 1 year. Please let me know your GitHub account username so we could send an invitation to the repository. The source code can be used for the app custom...

...arbeiten mit All-Inkl als Hosting Provider zusammen. Im Laufe der Zeit haben sich Projekte ergeben und es wird Zeit einen grundlegende Einrichtung und Organisation so aufzusetzen, dass wir icht mehr den Überblick verlieren. Hierzu gehört: - Organisation der Accounts - Organisation der Domains - Organisation des Webspace - Organisation der Emailspaces, -adressen, usw - Einrichtung der grundlegenden Parameter und Settings - Einrichten der Accounts für Administration und Entwicklung - evtl. Aufbau eines Spaces für Entwicklungen (sofern es Sinn macht diese vom der späteren Webseite zu trennen). Aufbau einer Entwicklungsumgebung. evtl. Aufbau einer Testumgebung - Grundlegende Einrichtung von Wordpress damit alle verschiedenen Webseiten damit laufen können...

...of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for r...

We're seeking an experienced developer company to help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, and admin panel. **OVERVIEW** The framework is built in versions that are several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, E...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

...looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable w...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or ...

I'm in need of a Power BI expert with solid experience in AI integration and advanced dashboard development. The project has multiple facets, including: - Data Cleaning and Transformation: The ideal candidate will have experience in working with large and complex databases. You should be able to clean and transform the data efficiently for integration into the dashboard. - Dashboard Design and Development: An eye for design is key. You will be creating a visually appealing and user-friendly dashboard, with the ability to customize as needed. - AI Model Integration: Extensive experience with AI integration is a must. You should be able to develop and integrate advanced AI models within the dashboard effectively. The main source of data for this project is ...

St...with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries wi...

...mechanical engineering. Our aim is to design a high-power attachable biking dynamo/alternator for bicycles. The primary objective of this project is to create a device that can generate and store significant power for storage in high-capacity batteries. This dynamo/alternator should deliver a high power output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role will be to: - Combine your expertise in...

...appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquiries Content Management: Stay updated on crypto news and investment projects by monitoring relevant Telegram channels and other sources. Respond to community messages, YouTube comments, and inquiries from followers. Email Newsletter Preparation: Prepare a weekly email newsletter based on the latest market news and developments. Ensure that newsl...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

...skilled writer to paraphrase an article originally generated using AI. The current version of the article is being flagged as 100% AI-generated by various AI detection tools. Your task will be to rewrite the content in a way that ensures it passes AI detection checks, while maintaining the original meaning and quality. Requirements: Strong command of the English language Excellent paraphrasing skills Ability to maintain the original context and intent of the article Experience with AI detection tools is a plus Deliverables: A paraphrased version of the article that can pass AI detection checks The final text will be evaluated using Turnitin to ensure compliance Special Note: Freelancer.com does not allow projects to be posted for less than ...

I'm in need of a skillful social media savant with extensive experienc...media savant with extensive experience in managing Facebook and Instagram platforms. The primary aim of this project is to generate leads, thus beneficial conversions for my business. For this role, the perfect fit would be someone who: - Is adept at curating and generating engaging product-promotion posts - Is proficient at managing and encouraging user-generated content - Can align content strategy and posts with our lead generation goal - Has a broad range of experience in increasing visibility and follower engagement - Is knowledgeable in social media analytics to track performance and conversion rates. Ultimately, I hope to leverage the power of social media to tap in...

...looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.