Excel power query sum columnsdela

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 urgently need a specialist in Ubiquiti UniFi to help me revive my system, which has gone down following a power outage. I've been left without any internet connection and I desperately need a professional to come in and provide effective solutions ASAP. If you have experience in: - Setting up UniFi network - Troubleshooting UniFi network issues - Configuring UniFi devices and you're comfortable with dealing with various types of internet connections, as I'm unsure which one is used in my setup, your skill set is what I'm looking for. Your prompt help will be highly appreciated.

I'm in need of a network engineer with expertise in the Local Area Network (LAN) infrastructure for troubleshooting and optimization. Key Tasks: - Install, rack, and stack a Cisco Catalyst 8300 series device. This includes unboxing, physical mounting, and initial power-on to ensure the device is operational. - Network Troubleshooting: The freelancer should be able to identify and rectify any issues affecting the LAN's performance. - Installation: If necessary, the engineer should help in the setup of new equipment or software for the network. Ideal Candidate: - Proven experience in LAN network design and architecture. - Strong troubleshooting skills and experience in network optimization. - Good knowledge of network security will be a plus. Please note that the projec...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...

I need an experienced electrical designer with expertise in AutoCAD for an industrial project. The design needs to incorporate power distribution and include layouts for Solar and Wind OFC, WMS and CCTV. Ideal skills and experience: - Proficient in AutoCAD Electrical software - Previous experience with industrial projects - Deep understanding of power distribution - Capable of designing Solar and Wind OFC layouts, WMS and CCTV system Compliance: The design work must adhere to the following industry standards and regulations: - National Electrical Code (NEC) - International Electrotechnical Commission (IEC) Please, include actual experience and project samples that adhere to these standards in your bid.

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage stability, and power transfer optimization ...

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...

...extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...

I'm in need of a network engineer with expertise in the Local Area Network (LAN) infrastructure for troubleshooting and optimization. Key Tasks: - Install, rack, and stack a Cisco Catalyst 8300 series device. This includes unboxing, physical mounting, and initial power-on to ensure the device is operational. - Network Troubleshooting: The freelancer should be able to identify and rectify any issues affecting the LAN's performance. - Installation: If necessary, the engineer should help in the setup of new equipment or software for the network. Ideal Candidate: - Proven experience in LAN network design and architecture. - Strong troubleshooting skills and experience in network optimization. - Good knowledge of network security will be a plus. Please note that the projec...

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

I need a technical expert skilled in Raspberry Pi integrations to create a display...project are: - GPS module - IMU module - TBS satellite receiver The LCD display should show GPS coordinates and IMU data in real-time. It also needs to set the frequency for the TBS satellite receiver. The Raspberry Pi setup will be powered by a battery, so considering power consumption in the build is important. Ideal skills for this job would include: - Experience with Raspberry Pi integrations - Familiarity with GPS modules and IMU modules - Knowledge of frequencies for TBS satellite receivers - Proficient in power management for computer systems, particularly those powered by batteries. Please ensure your bid includes your experience with these components and any similar projects yo...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage stability, and power transfer optimization ...

I need an experienced electrician(s) for installation of 10 new standard 16 A plug points in indoor areas. - Purpose: The plugs would be used primarily for E-cycle charging. Hence, the capacity of points should be appropriate to handle such usage efficie...involves wiring from the main meter to these newly installed plugs. An estimate on the amount and type of cabling required would be appreciated. Racks and channels will be provided for chargers and need to be assembled. - Work Environment: To ensure safety, I prefer professionals who are well-versed in executing indoor projects while following all necessary precautions. Your understanding of power requirements for E-cycle charging, as well as your skill at ensuring wiring safety and efficiency, will be highly regarded for thi...

I need a symbolic logo designed for my fitness brand, Alea Alea. This logo should evoke a sense of power and strength, reflecting the core values of my brand. The ideal freelancer for this project: - Has experience in professional logo designing specifically symbolic types. - Understands how to depict power and strength in design. - Can suggest innovative ideas keeping brand connotation in mind. - Has an impressive portfolio demonstrating their expertise and creativity. Looking forward to finding someone passionate who can bring my vision to life. Remember, this logo will be the face of the Alea Alea brand, it must be unique, impactful, and clear. The logo is going on Gym clothes so I want it to be clean and slick not bulky preferably in black or white but open to other...

We're seeking a detail-...across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Familiarity with...

I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any questions.

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I will need to go through your flow and also have the appropriate access to troubleshoot the issue

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I am looking for someone with experience in Comsol simulation to help with piezoelectric energy harvester design at the earliest, ideally within a week. - Beyond the simulation work, I need someone with strong documentation skills. - Required: 1) Generated voltage and power for applied strain% (like in cantileve) 2) Device capacitance, resonance frequency & impedance 3) Piezo strain coefficients for device geometry 4) Displacement (actuation) for different voltage 5) Sensitivity (output) for different level of stimuli (added mass in grams and pressure)

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selli...

...competition for the 4 models Ideal candidates for this project will have: - Proven experience in generator design and engineering, with knowledge of the Canadian market being an added advantage. - A good understanding of the residential market, particularly with respect to power backup solutions. - Strong analytical skills to conduct a detailed product review and competitive analysis. Your design should cater to the needs of the target audience, which in this case, consists of homeowners looking for reliable backup power solutions. The design should be innovative compared to the current market offerings and must be put together in a cost-effective modular solution. Please apply if you believe you have the right skills and experience to craft a successful generator d...

I'm looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in...

...challenging and engaging. - Coin Collection & Power-Ups: There should be coins scattered throughout the levels that players can collect. These coins can be used to purchase in-game power-ups. I envision the power-ups having a direct impact on gameplay by either enhancing the player's abilities or increasing their health. Art Style: - I'm particularly interested in a Cartoonish 2D art style. This should give the game a fun and engaging aesthetic that will appeal to a wide audience. Desired Power-Ups' Functions: - Health Increase: Some power-ups should increase the player's health, allowing them to sustain more damage. - Ability Enhancement: Other power-ups should enhance the player's abilities. This could mean incre...

I'm seeking a seasoned back-end engineer with expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs ...scalability is crucial, even if it is not explicitly stated as such by the client. Ideal skills and experience for this job include: - Proven track record of API development in Node.js - Strong understanding of MongoDB - Experience in integrating various third-party services - Prior work on projects with high performance and scalability requirements If you believe you have the necessary skills to excel in this role, I encourage you t...

We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and...well-researched leads in specific industries. 2. Retainer: £1000 per month. PROCESS 1. Lead Research: Identify and research potential leads. 2. Email Outreach: Send emails to prospects. 3. Response Handling: Forward prospect responses to the business developer. 4. Scheduling: The business developer will schedule and conduct the sales calls. 5. Data Management: Upload researched data to our CRM in Excel format to ensure no duplications. If you are a driven lead generation professional with the required experience and skills, we would love to...

I need a professional to create a WordPress site for me. I will give you the design and pages, need to have an event management plugin menu is: Events | Retreats | Power Medicine | The family | Reviews | Media

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX for the programm...

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

...into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list of CRM numbers and a list of CID numbers. Process: Automate the lookup and data extraction process. Output: An Excel file with the compiled data. Skills Required: Web Scraping Python Programming...

...Appliances: - Fridge - Kettle - TV - Toaster - Coffee Machine - Oven - Microwave - Dishwasher - Washing Machine - Clothes Dryer - Iron - Vacuum Cleaner - Air Conditioner - Geyser/Water Heater - Pool Pump - Smart Plug - Smart Thermostat - Bar Meters to show usage - Usage Dials - Usage Meters Animated Diagrams: - Electric Vehicle Chargers - Solar Panels - Energy Utilities/Power Lines/Power Grids - House with Rooms - Electricity Lightning Bolt - Smart Car Animated Ant Tracks showing movement between the house, grid, solar panels, and electric car Technical Specifications: - Graphics should be high-resolution and optimized for web use. - Animations should be smooth and optimized for performance. - Preferred formats for static graphics: PNG,...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of V...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I'm seeking a skilled individual to assist with a multi-machine power system dynamics analysis and control. The primary goal of this project is to optimize power flow efficiency. Key Requirements: - Proficiency in power systems dynamics and control analysis - Experience with multi-machine systems - Ability to optimize for voltage levels Your responsibilities will include: - Conducting power system dynamics analysis - Implementing control measures to optimize power flow efficiency - Focusing on voltage levels optimization Ideal candidates should have a strong background in power systems, and be able to work on a multi-machine system. This project will require a good understanding of power flow and voltage levels in order to maximize ...

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately represents the updated data informa...

I'm in need of an electroni...need of an electronic circuit and PCB designer proficient in working with ESP32 based microcontrollers, particularly for IoT applications. The project involves creating an efficient, compact, and robust PCB design that supports Wi-Fi connectivity. Key Requirements: - Proficiency in ESP32 based microcontroller design - Prior experience with IoT applications - Familiarity with designing for low power consumption - Expertise in creating compact PCB layouts - Ability to design a PCB for a rugged environment Your expertise in these areas is crucial, as the final product should be both functional and durable. If you're confident in your ability to deliver a high-quality electronic circuit and PCB design for an ESP32 based microcontroller, I'...