Excel pivot table data raw datadela

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

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

need help with spreadsheet formula

Details sent

I need a skilled developer to create an ASP.NET Web Forms project that connects with Power BI. The requirements are as follows: 1) Establish a connection between ASP.NET and Power BI. 2) Implement a login system where each user has a unique username and password and can only access their own information. 3) Ensure the display of user-specific data (Pid, Job_Name, Email, location) in Power BI in table format. I will provide the necessary SQL queries, but feel free to create stored procedures if you see fit. Ideal skills and experience for this job: - Proficiency in ASP.NET Web Forms. - Experience with Power BI integration. - Strong SQL skills. - Knowledge of creating secure, user-specific access in web applications.

I'm in need of a professional who can create a Classified Balance Sheet in Excel for internal review purposes. The balance sheet should be comprehensive and include the following sections: - Assets and Liabilities - Current and Non-Current - Equity The ideal freelancer for this project should have extensive experience in Excel, finance, and balance sheet preparation. The ability to present complex financial data in a clear, understandable manner is crucial.

I need help with data entry into my CRM system. The data consists of customer contact information, which is currently stored in Excel spreadsheets. Please note that the specific CRM system has not yet been determined, so flexibility and adaptability are key for this project. Ideal Skills: - Proficient in data entry - Familiarity with various CRM systems - Strong attention to detail - Excellent knowledge of Excel - Good understanding of customer contact information

I'm looking for an Excel expert to create a comprehensive workbook for analyzing our sales data. The primary purpose of this Excel book will be to aid in sales forecasting. Key Requirements: - Design and build an Excel workbook tailored for in-depth sales data analysis - Incorporate advanced Excel functions and techniques for accurate sales forecasting - Ensure user-friendly layout and functionality for office use Ideal Skills and Experience: - Proficient in Excel with a strong background in data analysis - Experience in creating tools for sales forecasting - Able to present complex data in a user-friendly manner

...platforms (YouTube, TikTok, Instagram, LinkedIn, Facebook, Twitter/X, Threads, and Bluesky). We’re looking for someone who: ✔ Understands the latest social media trends and algorithm updates ✔ Can create a content strategy that aligns with our business goals ✔ Knows how to optimize posts for maximum engagement, SEO, and virality ✔ Can analyze content performance and adjust the strategy based on data insights ✔ Is familiar with career coaching, job search trends, and professional growth content Responsibilities: ✅ Develop monthly content calendars and strategic posting schedules ✅ Research & apply viral trends (especially for TikTok, YouTube Shorts, and Instagram Reels) ✅ Optimize hashtags, captions, and social copy for each platform ✅ Track key performance metrics (re...

I need help with extracting text from a PDF document and organizing it into specific columns in an Excel spreadsheet. The task involves: - Text extraction: Pulling relevant text from a PDF file - Data organization: Sorting this text into designated columns in an Excel spreadsheet. The ideal freelancer for this project should have experience in data entry, particularly with PDF to Excel conversions. Attention to detail is crucial as the data needs to be accurately placed into specific columns.

...Level2:2000 Level3:5000 Level4:10000 Level5:20000 Level6:30000 Level7:40000 Level8:50000 no need to pay after level 8. 2. After transferring the amount to up-line user’s UPI transaction details need to submit the screen shots of payment 3. After approve from up-line user (confirm payment), registered user can move to further level Dashboard 1. Down-line list 2. User view their down-line user in the table view 3. Total amount available in wallet to each user 4. Total number donation credited from each user based on level. E-pin 1. 10digit e-pin Generated by admin and transferred to the user 2. Need active E-pain and inactive e-pin details 3. Up-line users can add the down-line user by purchase of e-pin from admin 4. At the time of registration user need to take E-pin...

...to guide me through analyzing data in Excel in a structured and professional way. My goal is to improve my Excel proficiency and learn practical techniques while working on my existing data. What I Have: • An Excel sheet with data ready for analysis. • Basic knowledge of Excel. What I Need: • A professional to guide me step by step in: • Data cleaning and preparation. • Using advanced formulas and functions. • Creating pivot tables and charts. • Analyzing trends and insights. • Other relevant professional techniques based on my data. Requirements: • Expert-level proficiency in Microsoft Excel. • Ability to teach and explain concepts clearly and pati...

Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe In...

I'm looking for a PHP expert to help modify my existing system. The project involves renaming elements and enhancing a form. The scope of work includes: - Renaming: Change all table and variable names from 'member' to 'beneficiary'. - Form Enhancement: Add additional questions regarding contact details, personal information, and beneficiary preferences to the 'add beneficiary' form. - Layout Changes: Implement specific layout changes on the pages form, which includes rearranging the order of form fields, changing the form style or theme, and adding sections or tabs to the form. Please note, I will need client-side validation for the new form fields. The ideal freelancer for this project should be proficient in PHP and have experience with form...

I need an experienced video editor to transform my drone footage into a polished video of my personal event. Ideal Skills: - Proficiency in video editing software - Experience with drone footage - Creative storytelling through editing Please note, no special effects like slow motion or time-lapse are required. The focus is on creating an engaging and memorable video from the raw drone shots.

I'm in need of a s...thorough skip tracing. Currently, my focus is on six counties in my state: St. Louis City, St. Louis County, Lincoln County, Jefferson County, and Warren County. However, as my business expands, so will the scope of this project. This is an ongoing opportunity, with added cash bonuses for quality work. The data I require for each lead includes: - Name and last known address - Phone number and email - Property details and foreclosure status - Date of foreclosure All leads must be delivered in an Excel spreadsheet. Accuracy is paramount, and I'm looking for someone who can grow with my company. Ideal skills for this job include: - Proficiency in skip tracing - Experience with mortgage foreclosure overages - Exceptional attention to detail - Abil...

I'm seeking a skilled video editor for my YouTube channel, which primarily focuses on gaming content. The main aim of the channel is to boost subscriber count, so the editor should have a keen understanding of what makes a gaming video engaging, shareable, and appealing to the YouTube audience. Key Responsibilities: - Edit raw gaming footage into enticing, fast-paced videos that hold viewer attention - Incorporate sound effects, voiceovers, and subtitles where needed to enhance the viewing experience - Understand and implement trends in gaming content on YouTube to keep the channel relevant and engaging Ideal Skills: - Proficiency in video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar - A good understanding of gaming and gaming culture - Previous exp...

We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.

I'm seeking a data entry clerk who can help me extract salah timetables from images and websites of approximately 50-100 mosques around the UK every month. This task involves: 1. Visiting the website of each mosque to screenshot the timetable for the current month. 2. Using any reliable tool to extract the data (I can provide access to ExtractTable if needed). 3. Copying and pasting the table columns into a provided template file. 4. Ensuring that the formatting is correct, with columns in the right order and times in 24h format. 5. Sending the completed file back to me. It takes approximately 2-5 minutes per mosque and so, I will pay £0.10 - £0.20 per file completed correctly. That means if you complete 50 timetables over 2 hours, you will earn &pou...

I'm in need of a tool that can take engine sound ramps (from idle to redline) and extract constant RPM sounds into looped samples. Key Requirements: - Input: RAW WAV engine sound ramps - Output: Separate files for each RPM, specifically every 500 RPM intervals Ideal Skills: - Experience with audio processing and sound engineering - Proficiency in software development for audio tools - Familiarity with engine sound characteristics and requirements for RPM sound extraction. example:

I'm seeking a professional to compile Material Safety Data Sheets (MSDS) for all raw materials required in the production of memory foam. The MSDS should cover commonly used materials, not specific formulations. Key Requirements: - MSDS for all raw materials used in memory foam production - Focus on commonly used materials - Delivery of MSDS in PDF format Ideal Skills and Experience: - Proficiency in compiling or sourcing MSDS - Familiarity with manufacturing materials, particularly in the foam industry, is a plus - Excellent attention to detail and ability to meet deadlines. Please ensure that all MSDS are comprehensive and adhere to standard safety regulations. Thank you.

I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts...financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data...

I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings. Key Requirements: - The CRC8 polynomial is x8 + x2 + x + 1. - The CRC16 polynomial is X16+X12+X5+1. - The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction. - I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet. As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex) This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81 (both can be checked usi...

as discussed in private chat - amended pouch size for design - update all information, - nutritional table - artwork update on back and front (small changes to bring theme into brand) - ensure all Labelling information is correct and up todat - barcode space ? (where to acquire a barcode)n

...operations and coordinating logistics. This includes managing a system where users can log in, upload documents, and access shared resources. Key Responsibilities: - Oversee login system which includes standard email and password login and Multi-factor Authentication (2fa) for enhanced security. - Facilitate the upload of various document types including PDF files, Image files (JPEG/PNG), and Excel sheets. - Manage access to uploaded documents, ensuring they're available to designated specific user groups. Ideal Skills: - Experience in operations coordination. - Proficiency in managing document systems. - Understanding of security measures in login systems. Please note, a crucial part of this role is to ensure smooth operation and coordination of logistics, wh...

I'm in need of a skilled video editor for my reality show concept. All of the footage was captured On “Zoom“ And screenshots. The editing style should be "raw and unfiltered", capturing the true essence of the footage. Ideal skills and experience for the job: - Proficient in video editing software (e.g. Adobe Premiere, Final Cut Pro) - Prior experience in editing reality shows or similar content - Ability to work with unfiltered, raw footage - Strong understanding of pacing and rhythm to maintain viewer engagement - Excellent communication skills for discussing edits and feedback.

...Precise Cuts: Make clean, precise cuts to improve pacing, ensuring the video is dynamic and engaging throughout. Applying Colour Grading: Apply basic colour grading to ensure the video has visual consistency and a polished, professional look. Skills Required: Medium-level experience with video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, or other equivalents). Ability to work with raw footage and enhance it by following guidelines for smooth pacing, flow, and visual consistency. Attention to detail to ensure all edits align with the channel’s style and tone. A basic understanding of pacing, visual storytelling, and the YouTube audience. This is a great opportunity to grow your skills and work on a consistent basis with the potential for more projects down the...

...marketplace, can distribute his songs via our platform and get daily & monthly reports on his tracks using official SPOTIFY API. User can also pay to order a custom artwork for his album/single. Can withdraw his stream earnings and so on. Must be done a complete & custom back-end to handle users modules such as distributed songs, stats and so on and admin modules such as earnings, reports, stats, excel exports, invoices and settings. Payments gateway, social logins etc must be integrated and implemented. Multi languages support. Laravel 8 & latest tecnologies must be used. Supporting cross website and devices. Eloquent Master & Seo friendly. Modern stylish & material design website. Must be used only up-to-date libraries. Must be provided an API to connec...

I'm looking for a professional video editor to refine my product assembly footage. The final edit should be an instructional video with a step-by-step guidance style. Key Tasks: - Shorten the raw footage (1 hour 30 minutes) into a concise, clear video. - Cut and arrange clips for a smooth flow. - Add simple text overlays labeling part names and sizes as mentioned in the video. - Remove unnecessary pauses and redundant sections. Final Deliverable: An MP4 or widely used format is good, video that is well-structured, professional, and easy to follow. Ideal Skills and Experience: - Proven experience in video editing, preferably for instructional content. - Proficient in adding text overlays. - Ability to maintain a clean, professional look throughout.

...will serve as a tool to manage information about cars, service jobs, and associated costs. It should also support multimedia attachments such as photos and videos. ### Requirements: 1. **Car Details Table:** - Fields: Car Make, Model, Year, VIN, License Plate, Purchase Date, and other relevant details. - Multimedia: Allow uploading photos and videos of the cars. 2. **Service Job Table:** - Fields: Date of Service, Job Description, Labour Cost, Parts Cost, and Total Cost. - Multimedia: Allow attaching photos and videos showing the work done. 3. **Summary Table:** - Automatically calculate and display summaries, such as: - Total spending on labour and parts. - Breakdown of costs per car. - Total number of servi...

I have a project requiring data extraction from a PDF file and input into an Excel spreadsheet. The data includes: - Text - Numbers - Tables The challenge is that each page of the PDF has a different layout. Your tasks will involve interpreting the varied formats and accurately transferring the information into a single sheet in Excel. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel and PDF handling - Able to interpret varied data formats Experience: - Previous experience in data extraction and entry - Able to complete task in timely manner A big factor in winning this contest will be who gets me the data back by 5pm EST 1/19/2025 or sooner

I have 2 different sheets in one workbook. I need to lookup item number in the first one on the second one, and return the count qty. I am struggling because on many, it is bringing in the exact same qty. I will also need a sum on both sheets to make sure they match the original data source.

- online exam software -user & admin not open -not opening in moblie

...This app enables foreign customers to check menus and place orders without language barriers, while also supporting payment and communication with waiters. Additionally, a scratch lottery feature offers users a chance to win free meals and various prizes. The main features are as follows: Main Features 1. Multilingual Menu Translation and Ordering Access the restaurant's menu page by scanning a table QR code or entering a specific number. Automatically detect the user's preferred language and translate the menu accordingly. Users can select and order food from the menu. 2. Chatting with Waiters Communicate with waiters through real-time in-app chat. Automatic translation in chats to resolve language issues. 3. Payment Features Make payments directly in the app using cr...

I'm in need of a meticulous professional for mI am writing to express my strong interest in the Data Entry Specialist position at ByteCraft. With my exceptional attention to detail, strong organizational skills, and passion for data accuracy, I am confident that I would be a valuable asset to your team. anual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromis...

...strong understanding of AI graphic tools, and the creativity to convey complex information in a simple, engaging way. Please include examples of similar projects you've worked on in your bid. Here are your detailed instructions: Certainly! Here's the revised document without introductory or concluding remarks. --- ## **Creating the Floating Trailer Explanatory Video: Integrated Guide** ### **Table of Contents** 1. **Workflow Overview** 2. **Chapter 1: Instructions for the Artist** 3. **Chapter 2: Midjourney Prompts and Use** 4. **Chapter 3: RunwayML Animation Instructions** 5. **Chapter 4: Post-Production Editing** 6. **Appendices** - A. Sample Prompts - B. Notes on Avoiding Confusion in Messaging - C. References and External Links --- ### **1. Workflow O...

I'm in need of a meticulous professional for manual data entry from digital files into Word documents. Key Requirements: - Proficient in handling digital files, especially PDFs and Excel. - Excellent attention to detail to ensure accurate data entry. - Familiarity with Microsoft Word for formatting documents. Ideal Skills: - Previous experience in manual data entry. - Strong organizational skills to manage and sort data effectively. - Ability to meet deadlines without compromising on quality.

...integrate smoothly with our existing systems. Collaboration with our team is essential to deliver valuable solutions. If you have a passion for problem-solving and a track record of successful Power Apps projects, we want to hear from you! You will be taking an existing Excel formula spreadsheet and converting it into a portal for external access. Consideration of the following is essential: Features of Power Apps Portals External User Access: Power Apps Portals are specifically built to provide external users access to select data and capabilities within a custom application, without requiring them to have a full user license for Dynamics 365 or Power Apps. Custom Domain Names: You can configure Power Apps Portals to use a custom domain name, making the portal...

Crear base de datos personalizable para introducir datos y consultar mediante busqueda especifica de palabras. Crear base de datos, para poner en servidor. Php mysql. Front end y backend, puede ser en laravel , CodeIgniter o cualquier. Usuarios. Admin y usuario invitado, en niveles. Ti...que se podra personalizar en el menu o en el codigo fuente. 2 secciones principales, primera, introduccion de datos, segunda buscador de palabras clave, indicando donde y cuantas hay en coincidencia. Y que se pueda acceder, ya sea en nueva ventana o lo mas practico. Pero que no se pierda la busqueda. Posibilidad de impresion en pdf, a valorar coste. Posibilidad de exportacion de datos, en doc o excel, a valorar. Visor de inagenes de datos adjuntos. Cualquier duda. Se prepara idea en grafico. Y text...

I'm seeking a developer to restyle one page of my wireframes to MUI (Material-UI) using a custom color scheme. Key Components: - The page primarily consists of a user table, styled cards, and an application header with navigation. - I have specific reference colors which will need to be incorporated into the design. - Color codes or hex values will be provided for the reference colors. Ideal Skills: - Extensive experience with MUI and wireframe styling. - Strong understanding of custom theme design. - Ability to accurately implement provided color codes.

I'm seeking a proficient Excel specialist to consolidate multiple spreadsheets into a comprehensive master template. The current spreadsheets contain real estate tracking data and your task will involve: - Merging data on property values, insurance replacement costs, and financial statement information. - Implementing key formulas to facilitate future analysis. This includes: - Sum totals for each category - Average values across properties - Percentage changes over time The ideal freelancer for this project should have advanced Excel skills, particularly with formula implementation and spreadsheet consolidation. Experience with real estate data would be a significant advantage. Please ensure that the master template retains all necess...

I'm looking for a developer to create a WooCommerce-based table booking system for my restaurant. Key Features: - The system should allow real-time availability checks, so customers can see which tables are free at any given time. - It should also facilitate customer pre-ordering, enabling diners to select their meals ahead of time. - The system needs to handle special requests from customers, such as dietary restrictions or seating preferences. Integration: - The booking system must seamlessly integrate with my existing POS system for smooth order processing and sales tracking. Ideal Skills and Experience: - Proficient in WooCommerce and WordPress. - Experience with developing booking systems. - Familiarity with POS system integration. - Understanding of restaurant operatio...

I'm seeking a video editor to enhance my gaming videos and vlogs. Your task will primarily involve creating highlight reels and edit videos from my footage. Key Responsibilities: - Edit gaming content into engaging vlogs. - Create highlight reels from raw footage. Ideal Skills: - Proficiency in video editing software. - Editing gaming content - Ability to create interesting highlight reels.

I need an Excel sheet for tracking vacation plans in my department. The sheet should be divided into three categories: resident, specialist, and consultant, each having its own separate sheet. The tracking should be done on a weekly basis for 2025 Key Features: - Under each category, there should be a count of the total remaining persons available. - I need to track for each person: their name and the dates of their vacation. - The sheets should use specific colors for each category: Red for residents, Green for specialists, and Blue for consultants. Ideal Skills: - Advanced Excel skills and experience in creating complex spreadsheets. - Knowledge of color coding and formatting in Excel. - Excellent attention to detail to ensure accurate tracking.

...just plain with basic functions. And I would like it to work in such a way that after entering a certain sequence of keys on the calculator, e.g. 2018, a menu appears with one option to choose from: "WolframAlpha". And after clicking the "ok" button, which will be button 5 on the calculator, an input is displayed where you can enter a mathematical problem and there is, in addition to the input, a table with special characters such as the fraction "/", a preview of special characters and what key combinations should be used press to get this character, for example the M- and 7 keys, and then the fraction appears on the input, and this is the case with other special characters, all the characters that I need to be taken into account including the lette...

Quiero poder ordenar de manera alfabetica la lista de estudiantes, pero que estos al ordenarse mantengan las notas que tienene en las otras columnas. para esto ocupo una macro. tambien otros arreglos en macros diferentes.

...catalogs for our raw material suppliers by surveying their websites. The project involves researching and organizing product data, including pictures and descriptions, into a professional catalog format. Project Scope: 1. Review the websites of approximately 10 suppliers (the exact number may vary). 2. Extract and organize the following information for each product: • Product Name • Product Description • Specifications (if available) • Packaging Sizes (if applicable) • Images (downloaded from the website or product sheets) 3. Prepare one catalog per supplier, ensuring clear formatting and organization. 4. Deliver the catalogs in Excel, PDF, or another agreed-upon format. Requirements: • Strong attention to detail and ability...

...construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting f...