Excel control pivot tables jobs

...for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts – No need to restart the service when we change settings – Highly configurable, ban anything...

I require a proficient WPF developer to design and create a user-friendly desktop application w...desktop application with the functionality and design, on par with that of Visual Studio. My project would need your expertise in: - Data Binding: Connecting the software to a database for efficient processing and managing of information. - UI Design: As Visual Studio served as inspiration, the application must have a clean, intuitive user interface, prioritizing user experience. - Navigation and Control: Implement a logical, coherent system to smoothly navigate around the application. The ideal candidate should have experience developing desktop applications, data visualization tools, and creating user-friendly interfaces, particularly in WPF. Familiarity with Visual Studio's de...

I am looking for an SPSS expert who can help me with running Case-Control Matching analysis on my dataset. Key Requirements: - Advanced SPSS skills, particularly in Case-Control Matching. - Ability to troubleshoot and resolve errors efficiently. Your primary role will be to help me run the Case-Control Matching analysis and ensure it is correctly applied to my data.

I'm looking for a proficient develo...database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-down list should filter based on their text. Eg. if they type 'squat', the contents of the drop-down list should narrow to all exercises that contain the word 'squat'. - Exclusive admin rights: I would like to have sole control over the addition, deletion, and editing of exercise data. Regular users should not have access to these privileges. The successful freelancer should have expertise in working with MySQL databases and webpages. Efficient problem-solving skills and preciseness to details are essential. Previous experience in similar p...

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

...need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create a...

I am searchi...LabVIEW, or Labwindows. Your task will comprise the development of a CanOpen protocol program making use of an IXXAT USB-CAN Converter. It run on windows 2000 operating system Key Responsibilities: - Develop a program using VB.Net/LabVIEW/Labwindows, capable of implementing the CanOpen protocol - Program must be able to read and write data to the IXXAT USB to CAN converter - The software should control devices using the CanOpen protocol Ideal Skills: - Proficiency in VB.Net, LabVIEW, and Labwindows - Advanced understanding of CanOpen protocol - Experience with IXXAT Converters It's essential that the chosen candidate guide me through the installation and testing process until we have a successful operation. The program must be compatible with Windows 2000 Op...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

I need a comprehensive HTML/CSS solu...need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be d...

...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...

I'm looking for a skilled transcriptionist to convert my lengthy PDF manual into a typed format. Here are some key details: - The manual exceeds 100 pages, making the task time-consuming and demanding attention to detail. - The manual is text-based, with tables and diagrams. A Procedure Manual. The ideal candidate will: - Have prior experience in transcription, specifically with lengthy documents. - Be proficient in English, ensuring an accurate transcription. - Be detail-oriented and able to maintain high standards throughout the task. Ensuring the accuracy and completeness of the transcription is crucial. This will be the foundation upon which other team members will build on.

...programmer for translating our control strategy into a code compatible with a dsPIC microcontroller. This code should be able to handle inputs of both voltage and current. The key features of this project include: 1. Control Strategy: Implementing a Proportional-Integral (PI) controller into the dsPIC microcontroller. 2. Input signals of the system include voltage and current. Being proficient in handling such systems is paramount. 3. Beyond written code, you should provide thoughtful documentation and comments so we can understand your strategies and algorithms. I am not specific about setpoints for voltage and current, so the approach should be adaptable. Ideal freelancers should possess the following skills and experience: - Strong understanding of PI control ...

3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.

I'm looking for a se...implementing JWT-authentication and integrating Keycloak with SpringBoot. The project aims to create a robust, secure user authentication system. Key project requirements: - Implementing JWT authentication. - Integrating Keycloak with SpringBoot. - Developing a secure login system for a large user base (more than 1,000 users). - Managing user roles and permissions dynamically, allowing admin users to control them. Ideal Skills and Experience: - Proficient in SpringBoot and Keycloak. - Strong experience in implementing JWT authentication. - Prior experience in developing secure systems for large user bases. - Knowledge in setting up dynamic user roles and permissions, especially in a SpringBoot environment. - Ability to deliver a robust, scalable, and s...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

We are urgently developing a comprehensive marketing analytics tool designed to integrate data from various advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implemen...

...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...

I need a skilled statistician with expertise specifically in SPSS data analysis in the field of medicine. I have 2 Excel datasheets already prepared for SPSS induction containing about 20 variables. The first dataset contains the measurements for the control group (14 patients) and the second dataset contains the measurements for the disease group (29 patients). I need to analyze the data to find any meaningful differences between the 2 groups (comparing means, using t and x square test, regression analysis etc when applicable) Key Project Details: - Data: The data has been meticulously prepared for SPSS induction and contains approximately 20 variables. - Analysis: - I'm particularly interested in inferential statistics to identify relationships or differences b...

I'm seeking an individual who can create a one-time web scraper that can collect text, images, and tables from Website 1. The project involves: - Developing a tool to scrape text, images, and tables from the specified website. - Ensuring the tool can operate efficiently for a one-time scraping process. Key Skills: - Proficiency in web scraping tools and techniques. - Experience in scraping text, images, and tables. - Ability to create a custom scraper for a one-time scraping task.

I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...

Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.

Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!

I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on: Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird ‎...

Hello, i have python codes that fetchs some data.i need someone have experience in qt designer to create the win form To show the data as required some in lables and some tables and need the design visually so we can easly edit in future Will explain the required design privately sharescreen in anydesk..

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

Create Financial Project on Excel

...custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionality I need is for iPhone device enrollment and management. I do not have an existing solution that needs to be integrated, so will require a new solution to be built from scratch. Before showing interest on this job, Please read the below link and then you can bid for this job FYI: The ideal candidate has extensive experience developing mobile device management solutions and can create a solution that meets my needs in terms of the level of user access control. If you believe you can deliver the skills and experience necessary for the

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you

I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.

...information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - Data Organization: Good data organization skills are also important to present

I'm looking to have a specialist in ESP programming who can integrate motion sensors into a mechatronics project. You will be tasked with implementing motor control functionality and programming motor speeds. Writing and deploying a program. Key components are 2 step motors 1 proximity sensor 1 ESP32-S3 3.5 inch for control misc. electrical components Key aspects of the project include: - Sensor Integration: Specifically, I require the integration of proximity sensor. Your experience with such sensors will be crucial to the success of this project. - Motor A, Control from touch panel, the only variable setting is speed - Motor B, Control from touch panel, the user must be able to set the speed of the rotation, also this motor will have a proximity sensor,...

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.

I'm in need of a talented 3D designer that can create realistic renders of melamine furniture pieces. - The furniture type is melamine, and it will consist of a combination of kitchens, wardrobes and tables. - The finish for this furniture is a custom color, which will be provided by me. - I'll need the designer to work on standard dimensions for the pieces, as I don't have specific measurements. Ideal Skills: - Proficiency in 3D design software - Experience in rendering furniture with decorations - Ability to work with custom colors - Understanding of standard furniture dimensions - Attention to detail and a keen eye for realism Please provide samples of previous work in a similar vein.

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

Please Sign Up or Login to see details.

Fingerspot is a well-known Indonesian brand within the Fingerspot Group, which has been successfully serving businesses, entrepreneurs, and schools in Indonesia for 21 years by providing palm vein (Vena Telapak Tangan) sensing machines, as well as web services and sensing software based on desktop, laptop, and internet applications, software for monitoring, remote control access, and software development kits (SDK) that are tailored to meet the needs of Indonesian consumers. At the moment, Fingerspot is looking for programmers with strong programming skills in its various fields.

I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is on...

User Authentication: User Interface: - Implement role-based access control to ensure that users only have access to features relevant to their roles within the company assigned by administrators and can view dashboards, Statistics and data access based on role privileges. Adaptive Employee Management: - Provide flexibility in employee profile fields, allowing administrators to customize add/remove fields such as contact information, job history based on the company's specific needs and Enable employees to update personal information like contact details or emergency contacts. - Store and organize employee documents, contracts, policies in database and Display for compliance purposes. Flexible Leave Management: - Allow administrators to configure various leave types such as ...

Able to follow instruction, can be done in 3 days. CRUD for 3-4 tables only

Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call for a creat...

I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. T...understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them will b...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.