Excel control pivot tablespráce

I require assistance in converting a variety of file types including Word, Excel, and PowerPoint files, into PDF format. Here are some specifics about what I need: - I need the original formatting from the source files to be preserved during the conversion process. This will ensure that the PDF versions closely resemble the original documents, without any loss of visual integrity. - The files for conversion will be provided via a cloud storage link, such as Google Drive or Dropbox. I expect the freelancer to be proficient in accessing and handling files from these platforms. Ideal candidates for this project should have: - Proficient experience in converting different file types (e.g. Word, Excel, PowerPoint) into PDF format. - Strong attention to detail to ensure the prese...

I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...

I am in need of an experienced electrical engineer to assist with spec'ing an electrical system. The system design. -I am needing to control a Nema17 stepper motor and 300watt BLDC Motor. -I already have the motors selected and the drivers for each motor. -I am wanting to use an arduino microcontroller for the controls. -I require the power supply to be as small as possible, but still being well within in a safe range of the power demand of the system. Refer to addition info regarding the sizing, or have a discussion with me on possibilities. -Additional peripheral components: 3 x Push Button, 1 x power switch, 1 x small display screen. 2 x Limit switches. What I need done. I need a freelancer to design and spec the unspecified components around the ones that are al...

I'm in need of a developer to set up user roles in my new spring application like they were in the old struts application. Key Project Details: - Setting up roles: I require the creation of Admin, User, Manager, and ...Key Project Details: - Setting up roles: I require the creation of Admin, User, Manager, and Supervisor roles with the same permissions as in the old struts application. - No additional roles: The only additional role needed is 'Supervisor'. I do not require Developer or Guest roles. Ideal Freelancer: - Proficient in Java, particularly Spring Framework. - Proven experience in role-based access control. - Familiarity with legacy system migration. - Good understanding of the Struts framework (for comparison purposes). - Strong communication skills for c...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

...and project a modern, sleek, and commercial image. - Mechanical and Electrical System Design: We need a team with a strong focus on engineering, able to create systems that are energy efficient and innovative. - Innovations: This is an important aspect of the project. We're looking for a team that can bring fresh ideas to the table, with a particular interest in self-driving capability, voice control assistant, wireless charging, advanced safety features, and an innovative AutoCharging system using the car's tire motor. Ideal freelancers for this project should have experience in: - Industrial design and 3D modeling - Mechanical and electrical engineering, particularly in the automotive industry - A creative and innovative approach to design, with a keen eye for detail...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implem...

...variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based solution rather than one installed on my computer but on my phone would be ok....

...of Maroantsetra, Madagascar to the final crafting of our premium product. The designer should use the attached infographic, process flow diagram, and vanilla cut styling guide as visual references to creat our own infographic ou design steps shaping the page's content and design. These resources provide comprehensive details on our process, including key steps, techniques, timing, and quality control measures. Project Goal: The ultimate goal is to create a page that educates consumers on what makes our vanilla truly special and compellingly tells our unique brand story. The page should convey our deep commitment to quality, sustainability, and supporting our farming communities. It should engage viewers' senses and emotions, instilling a greater appreciation for the a...

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

I need to design a tracker control unit for the 137 MHz band antenna system of the ground station receiving weather information from the NOAA spacecraft on Arduino. The project must be modeled at https://projecthub.arduino.cc. Need your idea and help how to implement it.

I am in search of a...engineer to design a comprehensive home automation solution for a 4 room apartment. Key Requirements: - The scope will involve creating an AutoCAD file, a wiring plan, and a 2D structure for the products in the architecture plan. - You must also provide a list of quantities. Specific Features & Functions: - The automation project should include lighting control and temperature control. Integration: - There is no need for voice control or mobile app integration. Scalability: - The system should be designed to be scalable for future upgrades or additions. Ideal Skills: - Proficiency in KNX engineering with a portfolio demonstrating similar projects. - Strong AutoCAD skills. - Ability to design for scalability and future-proof the syst...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

...Ability to work full-time and communicate effectively - Experience working in a team environment I'm looking for an individual who is reliable, skilled and able to commit to a full-time role. Please include your relevant experience, portfolio and availability in your proposal. OVERVIEW: We have created our own web-based digital dignsge content and screen management system. The cms allpws us to control the content displayed in-store TV screens. The platform can be seen here: - If you have digital signage experience this will be ideal (this is not building a website) - Fluent English speaking - We would like to work with a freelancer, not a company (paid hourly) - Proven development experience (sample of similar works required) - Experience in Android: java | Windows:

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

Based in sketch dimensions and photos create 3 3D tables . Creations of 1 Scene and render the items inside. - singular renders items in scene - 3 Images each item - combo items in scene - 4 images

I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:*...should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding tables) - Automation and real-time data updates on websites. Please let me know your relevant experience and provide some examples of similar projects yo...

...a portfolio of released applications or games on the Google Play Store. 2. Proficiency in Java or Kotlin programming languages and Android SDK. 3. Strong understanding of mobile game development principles, including UI/UX design, performance optimization, and memory management. 4. Experience with game development frameworks such as Unity or Unreal Engine is a plus. 5. Familiarity with version control systems (e.g., Git) and Agile development methodologies. 6. Excellent problem-solving skills and attention to detail. 7. Ability to work independently and as part of a team in a fast-paced environment. 8. Good communication and collaboration skills. If you are passionate about creating fun and challenging puzzle games for the Android platform and meet the above requirements, we...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

...project: - **LED Display Design:** I don't have a specific design in mind for the LED display, so I'm open to creative suggestions. It would be great if the design can enhance the user experience and make the game more engaging. - **Programming Language:** I'd prefer the game to be developed using Python. Please ensure you're proficient with Python and can create a smooth and efficient game. - **Control Mechanism:** I'll need the game to be controlled via a web interface that's accessible through a network. This is essential for user interaction and convenience. Ideal skills and experience for this project include: - Proficiency in Python - Experience working with Raspberry Pi - Knowledge of web interfaces and networking If you're confident i...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...has to use our web app url as attached in WebView framework of android. We need to provide link for camera and upload from gallary feature from many pages of our web app. kindly let us know how will programmer provide it?. 2. We only need use camera and file upload from mobile gallary into our webserver file folder via ftp and related data entry in sql server database. we will provide necessary tables, fields, data types, views and database connection strings to programmer. We will provide the design which wil integrate with our MobileERP Software with its internal structures like DID. 3. Our following applications will us above camera and upload features with GPS Location storage in sql server database. a. When employee entering attendance when on site or on tour b. When emp...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

...through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requ...

I'm...and manage text and image content on the portal. User Roles: - Customers: The portal will be used by customers to interact with our services. Ensure seamless user experience and accessibility. - Employees: Employees should have access to specific tools and information. Develop an interface that is intuitive and geared towards productivity. - Administrators: The administrators should have full control over the content displayed on the portal. They should be able to upload, edit, and remove text and image content. Ideal candidates for this project should have: - Proficient in PHP development - Experience in creating user authentication systems - Strong understanding of CMS development - Prior experience in developing web portals is a big plus Looking forward to seeing ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I am seeking a skilled designer for a furniture project involving the creation of modern chairs and tables. Key Requirements: - Extensive experience in furniture design. - Proven track record in designing modern style furniture. - Proficiency in working with metal as the primary material. - Ability to share previous project samples as reference. Ideal Skills: - Sound knowledge of the latest trends in furniture design. - Excellent understanding of modern design principles. - Strong experience in working with metal. This is an incredible opportunity for furniture designers interested in modern design and metal work. Please share portfolios or examples of previous work that align closely with the requirements mentioned above.

I have an excel file, need add product categorie on a column - budget 100€

READ THIS CAREFULLY IF YOU DON'T UNDERSTAND ALL OF WHATS BEING REQUESTED YOU WILL NOT BE CONSIDERED. AI...client projects: Deliver projects in a timely manner that meets or exceeds client expectations. I'm particularly looking for a professional with a background in multiple tier management over contractors and a proven track record of delivering projects efficiently. Strong communication and leadership skills are a must, as you'll be managing a team of professionals. Your ability to effectively control and manage costs while maintaining quality and meeting deadlines will be highly valued. A keen eye for detail and problem-solving skills are essential. Please apply if you're confident in your ability to take on these responsibilities and make a positive impact...

Looking for an industrial / mechanical engineer pr...and to spec. Ideal Candidate: - Spoken and written fluent English - Proven experience in industrial and mechanical engineering, particularly in product design and manufacturing process management. - Previous experience in the skatepark industry or similar outdoor sports facilities would be a significant advantage. - Strong understanding of design principles, production processes, and quality control. - Excellent project management skills to be able to oversee the entire process from design to production. This is an ongoing project, so I'm looking for someone who can commit to working with me on multiple projects in a kind of full time position. If you have the necessary skills and experience, please get in touch.

...homeowners, and interior designers. The goal is not only to create strong brand awareness but to effectively generate sales leads. I refurbish second hand furniture and turn into modern functional furniture. Eg old pine wood tv cabinet into a unique modern functional one off desk for a teenager or dining with lots of storage and great to look at. Also refurbish pallets into potting tables, herb pot and tables for seniors, garage work benches. Also turn old tv cabinets into cat houses/averies. I sell everything for under $660. - Aesthetic: Incorporate a sleek, urban, and modern look to attract the eyes of our primary audience. - Goal: The end goal is to generate viable sales leads. - Engagement: Content should be strategic, compelling, and should effectively prompt...

I need a Blazor application, like a teleprompter, that allows users to control the scrolling of text by reading out loud the text. When the user stops reading, the scrolling stops. When the user starts reading again, the text should resume scrolling. It should be specifically designed for web browsers, being compatible with Google Chrome, Mozilla Firefox, and Microsoft Edge. Key requirements include: - A voice activated scroll feature that operates when the user finishes reading a line of text. The text should then automatically scroll upward. - If a user misses a word or line of text, but starts reading the next line, the scrolling should resume from the new line. - The application should be responsive, efficient, and user-friendly. The successful freelancer should have exper...

I am seeking a proficient freelancer to convert 1-5 Word documents to Overleaf Latex Journal Format. These documents include not only text but also graphics and tables, necessitating an eye for detail and good command of layout techniques. The ideal candidate will have extensive experience in Word-to-LaTeX conversions and dealing with documents that are graphically rich. The successful freelancer would demonstrate a deep understanding of LaTeX syntax and formatting, and the capacity to preserve the structure and aesthetics of the original Word documents in the process of conversion. Efficiency and accuracy will be key attributes for this task. I have 4 documents & Latex template. I want those documents to be converted into latex journal.

...with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, ...

fichier sur Excel reproduire le même identique sur Excel avec calcul automatique

Hello, I need complet the Amazon categories catalogue excel in french

...of UI/UX principles and best practices. Ability to create intuitive and user-friendly interfaces. Web Development Skills Solid understanding of HTML5, CSS3, and JavaScript. Familiarity with modern front-end build pipelines and tools (e.g., Webpack, Babel). Cross-Browser Compatibility Experience ensuring websites function correctly across different browsers. Version Control Systems Proficiency in using Git for version control. Attention to Detail Keen eye for detail to ensure design consistency and quality. Communication and Collaboration Strong communication skills to collaborate effectively with content writers, project managers, and other stakeholders. Ability to provide regular updates and seek feedback. Preferred Qualifications: Previous experience working on fina...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I'm seeking an expert consultant who specializes in quality control within the packaged food industry. The role will be focused on quality assurance process improvement, specifically to streamline and optimize these processes. The ideal candidate will have: - Extensive experience in the packaged food production industry - In-depth knowledge of quality control processes - Experience in quality assurance process improvement - Strong background in packaged food safety standards - Demonstrated success in optimizing quality control procedures Your expertise will be invaluable in helping to ensure the highest level of quality in our packaged food products.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...features for each area. Key Requirements: - Lighting Automation: I need the system to include dimming capabilities, color changing lights, and motion sensor lights. It should be able to adapt to different lighting needs and situations. - Heating/Cooling Automation: I have a smart thermostat and I would like it to be integrated into the system. The system should allow for optimal temperature control and adapt to my preferences. Ideal Skills: - Home Automation: Experience with setting up and integrating smart home features is a must. - Lighting Systems: Proficiency in configuring lighting systems with various functions. - HVAC Systems: Knowledge in working with smart thermostats and ability to set up heating/cooling automation effectively. Please share your previous experienc...

...platforms. This will help in identifying trends, analyzing performance, and making informed business decisions. - Order Processing: The software must be capable of processing orders efficiently and accurately. This will help in reducing errors, improving customer service, and maintaining a good reputation in the market. sending order to clients unleashed ready for shipping. - ISO27001 or similar control to protect data security. The ideal candidate should have: - Extensive experience in software integration, particularly in cloud-based systems. - Proficiency in Unleashed software is highly preferred. - Strong understanding of inventory management and sales tracking. - Excellent problem-solving and communication skills. - A proactive and customer-centric approach, with...

...management of walnut trees, with specific emphasis on nut quality improvement and pest/disease control. Key Responsibilities: - Designing and implementing effective irrigation systems tailored for a 5-20 acre walnut orchard - Developing and executing strategies for pest and disease control in walnut trees - Implementing machinery and equipment for efficient farm operations - Provide consultation and strategies for improving overall nut quality Skills and Qualifications: - Proven experience in agriculture engineering, particularly with walnut tree management - Proficiency in irrigation systems design and implementation - Strong knowledge of farm machinery and equipment - Expertise in pest and disease control in orchards - Ability to strategize and implement effecti...