Vba workbook pivot tables jobs

...and Python backend (see the 3 attachments to this post with the main job description is in the file MTQ - Upwork - Interactive Front Panel - and the other attachments are supporting documents). SUMMARY: Tabbed ReactJS forms with a Python backend that can interact with each other. The front-end can have a few input fields and a few interactive subcomponents in the form of either tables or images (with possibly overlaid hand-picked polygons), organized in a few columns. The layout can be customized (in the spirit of React-Json-Schema Form). The change in any Frontend component will be handled by a Python backend and the Python backend, in turns, can generate new data to update the interactive subcomponents of the front end. Key responsibilities and requirements include: - Profic...

Please Sign Up or Login to see details.

I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combi...

...features in upcoming releases (if your work suits us). Key Features: The integration with the sample data for Gemini has been implemented. The short term focus is: 1. User profile (simple, like change username, password, logout) 2. Admin portal (allowing our admin to upload sample practice questions and solution instructions via this portal UI; currently we directly load the sample data to database tables, no UI). I'm seeking a professional with experience in AI and chatbot development (especailly Gemini) who can develop these features effectively. Currently only one subject - Maths, but there will be more to come. The Q&A workflow is similar though as above for other subjects though, the sample contents feed to AI might be different. We set the boundary, provide samp...

Scope of work will include: Descriptive statistics Confirmatory factor analysis Path analysis Formatted graphs and tables - APA format Interpretation of the results

Develop macro-enabled Excel workbook

...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...

I am currently facing seve...loading at all at times The primary data source giving trouble is Google Sheets. To rectify the situation, an expert is required to restore my confidence that my dashboard will operate as expected. Moreover, it seems the tables of data specifically are not displaying correctly. This might entail performing checks, and implementing changes to the manner in which this particular format of visualization operates. Ideal Skills: - Proficient in Google Data Studio and Google Sheets - Experience in troubleshooting and resolving data visualization problems - Familiarity with data tables in dashboard representations Your job is to bring my data studio dashboard back to its optimal operation so that I can continue to make informed decisions based on t...

ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.

...touch screen. Calibration and screen use must be planned correctly All players will play on a single stage, simultaneously and sequentially. Score areas of the games will be recorded on Compact DB. There will be a timer in the games. For example, if the game lasts 20 minutes, it will give a warning to the end user at the 19th minute. Please insert a coin. we are ready for all game offers for these tables. -Text me for a detailed brief for games- All games must be prepared to run on GAMING TABLE. Device used: 43" Inch Touch Table(GAMING TABLE) 40 points PCAP touch CPU : Intel 5 6th Gen 6400T RAM:512GB screen : LG orignal A level screen panel Protect surface: 5mm tempered glass Resolution:3840*2160 view angles :178° horizon, 178 °vertical piexl : 0.28mm Contrast:4...

...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...

I'm looking for a professional who can type a short personal document of less than 1000 words into a Word file. Key Requirements: - The document should be typed in a standard text format. - No need for specific headings, subheadings, images or tables. - Accuracy and attention to detail are highly important. - Native English speakers are preferred for this task. Ideal Skills: - Fast and accurate typing skills - Attention to detail - Strong English language skills Personal Document Typing: I have a short personal document, less than 1000 words, that I need typed into a Word file. No special formatting required, just a simple text format. I'm looking for someone with excellent typing skills and attention to detail. Native English speakers are preferred for this task.

...export-import. Paradox DB files are in database folder. 2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it 3) review the mapping of the data fields between source and target databases. 4) Update the existing script which will update products on the server from source database on my desktop. Main tables for the import: inventory, invimages, invcategory. I need the data about the products in "inventory" and related tables imported to the online shop, including names, parsed descriptions, pictures, etc. 5) Script must parse item description in RTF format, split it to two part using tegs in the text, one for English description in the shop, another - for different language, delimiters --en-- and --ru-- 6) Script must...

I need a freelancer able to work effectively on PDF copy typing. The task would additionally require incorporating moderately complex tables and charts from the PDF into the typed document. Specific tasks include: - Copy typing from the PDF document - Inserting moderately complex tables and charts Ideal skills for this job: - Proficiency in PDF editing tools - Strong skills in data representation - Attention to detail Please provide examples of past work that involved similar tasks.

I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.

I'm looking for a skilled developer who can assist me in creating a basic function within OpenAI's ChatGPT. This function will retrieve a number from a table, aiding me in my AI related tasks. Key Requirements: - Create a function within ChatGPT that can extract a specific number from a table. The tabl...similarly to the example provided in this video: Ideal Skills and Experience: - Prior experience working with OpenAI's ChatGPT or similar AI assistants. - Strong programming skills, particularly in Python, which is the language used to interact with the OpenAI API. - Knowledge of data manipulation and extraction from structured data sources, like tables. - Ability to understand and implement the requirements specified in the video example.

Looking for someone proficient to create the design of my book. It is a book like a workbook or photo album. Book size: A5 (148 x 210 mm) The book consists on: - Introduction - Table of Contents - 100 activities. One activity per page (please see the example attached) - Quotes that intersperse the pages - Conclusion PLEASE READ - PLEASE READ - PLEASE READ Start your proposal with the budget and delivery time

I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.

I require a database model diagram based on a description I will provide. The diagram should serve as a basic overview, capturing key tables and relationships within a relational database. Key Requirements: - Relational Database: The diagram should be tailored for a relational database system. - Basic Overview: The scope of the diagram should be limited to key tables and relationships, providing a clear, high-level representation of the database. Skills and Experience: - Proficiency in database design and modeling - Experience with relational databases - Ability to translate abstract descriptions into structured database models Please note that I do not require documentation on the database model diagram. The focus here is on the clarity and accuracy of the visual repres...

I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and background in quality c...

...users. - Multiple Betting Markets: A wide range of sports and events to bet on. - Bet History Tracking: A feature that allows users to keep track of their betting history. - Exchange, Back and Lay: The website should support the exchange, back and lay functions for betting. Key Features for Casino Games: - Slot Machines: A variety of virtual slot machines for users to enjoy. - Poker Tables: Online poker tables for users who enjoy playing poker. - Roulette Wheel: A digital roulette wheel for users who like to play roulette. Ideal Skills and Experience: - Proven experience in developing betting websites. - Understanding of sports betting and casino game dynamics. - Familiarity with real-time betting systems. - Proficiency in creating user-friendly interfaces. - Strong know...

As the project pivot, I am seeking a proficient mobile application developer to create a React Native app that delivers real-time location tracking on both iOS and Android platforms. Key Features: • Device Tracking: The app should proficiently track a smartphone and provide real-time location tracking. • Map Integration: The location should be live-displayed using Google Maps. Security Features: • State-of-the-art security is vital. We anticipate integrating two key features: data encryption and two-factor authentication to ensure secured access. Ideal Profile: • Proficient in React Native • Capable of integrating a smartphone location • Knowledge and experience with implementing secure coding practices, especially with data encryption and two...

I am in need of an experienced ghost writer to craft a workbook consisting of 50 short activities. The workbook is for late teens age 17-19. The main objective of the workbook is to handle anger management and emotional regulation. Key tasks and outputs: - The activities should be a mix of mindfulness exercises, cognitive behavioural therapy (CBT) strategies, worksheets, journaling assignments, and self-reflection prompts. - The resource should aim to foster critical thinking, improve communication, and inculcate creativity in teens. - The writer should be skilled in working pedagogical theories into content that resonates with teens. Preferred skills: - Ghost writing experience, specifically in emotional health or wellness sector. - Effective communication, criti...

...Familiarity with email newsletter marketing management platforms. 2. Social Media Marketing Knowledge: Familiar with best practices and repurposing content (twitter, threads, youtube, etc) 3. Graphic Design Skills: Competence in creating visually appealing newsletter layouts using tools like Canva or Adobe Creative Suite. Design layouts as needed for other platforms. 4. Project Management and Strategy Pivot from Data: Strong organizational skills to manage newsletter schedules, content deadlines, and distribution lists. Monitor the effectiveness of each newsletter issue using analytics tools (open rates, click rates, and subscriber growth) and suggest improvements. Application Instructions: 1) Title your application as “Newsletter and Social Media Manager Application&rdquo...

...insights based on a provided case study. it should show the analysis, insights, and visualizations. Responsibilities: Build an interactive dashboard using Tableau. Construct a narrative around the provided case study. Perform various data analysis tasks such as regression, clustering, forecasting, etc. Uncover patterns and changes over time within the data. Develop clear and visually appealing tables, graphs, and dashboards to communicate results and insights. Ensure the reproducibility of the analyzed data. Requirements: Proficiency in Tableau with demonstrable experience in creating interactive dashboards and visualizations. Strong analytical skills with experience in data analysis techniques such as regression, clustering, and forecasting. Ability to construct a compelling...

I seek a skilled Python developer proficient in Jupyter for a specific task. Key Requirements: - **Output Format**: The extracted tables must be in PDF format. - **Complexity of Tables**: The tables to be extracted are relatively simple with straightforward data (the data is in arabic). Ideal candidate should have: - Proficiency in Python and Jupyter. - Past experience with extracting tables from Excel sheets. - Understanding of Arabic language is a plus, though not mandatory.

...limiting to prevent abuse and ensure security during OTP verification. JWT Authentication: Generate JWT tokens upon successful OTP verification for secure authentication between client apps and the server; Implement token-based authentication for subsequent API requests. Refer Code and Wallet Creation: Upon successful OTP verification, generate a unique referral code for each user; Create separate tables to manage user wallets, allowing users to perform transactions and manage their funds securely. Additional Requirements: Utilize Laravel 10 or 11 for development. Ensure the API endpoints are well-documented for seamless integration with client applications. Implement error handling and validation to enhance the security and reliability of the API. Adhere to best practices in ...

I need an expert typist who can transcribe text following the APA style guide into Google Docs. Key for this project: - Familiarity with APA formatting style - Proficiency in Google Docs - Attention to detail and high accuracy - Preferably a fast-typing speed This typing task involves text only, no images, tables or charts. The right candidate should ideally have a good track record with this kind of task and can deliver on time.

I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?

I'm urgently looking for an expert in creating an application capable of scanning and extracting key attributes from various documents, primarily invoices, receipts, and contracts. The intended app should smoothly identify and extract the following attributes: - Dates - Total Amount - Vendor Name - Tables - All other significant attributes - Clauses The ideal candidate should have proven experience in App development, Document Data Extraction, OCR and deep learning technologies. A sense of urgency is also crucial given the project needs to be completed ASAP. If you satisfy these requirements, I look forward to your bid.

I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.

...refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Proficiency in formatting Excel tables to improve visua...

I'm looking for a talented graphic designer who can help with two main tasks. Packaging Design: - The primary focus is on creating innovative and eye-catching packaging for furniture items. - The target market for this packaging is consumers interested in furniture products. Furniture 3D Design: - I need 3D designs for tables. These should be accurate and visually appealing to help with prototyping and marketing. - Experience with furniture design is a plus, but not mandatory. Ideal skills: - Proficient in graphic design, specifically packaging design. - Experience in 3D modeling, with a focus on furniture, is desirable. - Creative and able to understand the target consumer market. - Good communication skills to understand and implement feedback. Looking forward to...

I need an experienced professional to help design the interior arrangement of my new bar which is expected to house more than 100 patrons. Below are the key specifics of the project: - Furniture Placement: The design should include right-sized chairs, tables, bar stools, and lounges. We'll be working hand-in-hand with our resident furniture designer. - Style: The bar's aesthetic should be modern. Ideal candidates should have an eye for current design trends. - Final Output: I need the final results in the form of CAD designs for wall cladding and furniture placement. Furthermore, I would like to receive elevations and a 3D rendering of the entire bar. - Autonomy: I'm looking for someone who can take the reins on this project and see it through to the end with minima...

I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...

I need an experienced app developer to create a dine-in concept app. This platform is set to be both Android and iOS compatible. Your experience with these platforms, and with creating functional, user-friendly interfaces, will greatly contribute to this project. KEY FEATURES: - Table Reservation: Enable users to reserve tables with ease. - Menu Browsing: Users should be able to browse the menu thoroughly and conveniently. - Order Placement: Facilitate the entire ordering process through the app. - able to scan QR code to place order and pay. DESIGN PREFERENCES: - The aesthetic of application should lean towards the colorful side. I am expecting a lively interface that will leave an impression on the users. PLEASE NOTE: - I understand the risks of online scams. Therefore, I will ...

I need a freelancer able to work effectively on PDF copy typing. The task would additionally require incorporating moderately complex tables and charts from the PDF into the typed document. Specific tasks include: - Copy typing from the PDF document - Inserting moderately complex tables and charts Ideal skills for this job: - Proficiency in PDF editing tools - Strong skills in data representation - Attention to detail - Experience with graphic design and document formatting Please provide examples of past work that involved similar tasks.

Only HTML tags needs to be added. I'm l...freelancer to convert approximately 30 documents from DOC to HTML. This conversion should strictly include the content only, excluding any headers or footers. Key Requirements: - Conversion of 30 documents to HTML format - Ensure only content is included, no headers or footers - Implement a minimalistic style for the HTML files Additional Information: - The documents are simple in nature, with no tables or images, so the conversion process should be straightforward. Timeframe: I'm in need of this project completed ASAP. If you have the capacity for a quick turnaround, please feel free to bid. Ideal Skills: - Proficiency in HTML - Experience with document conversions - Ability to work efficiently and deliver quality results i...

Hi Kusmin K., I am trying to typeset a book on hajj but i need your help to setup a table settings at 90 degrees sideways because the page size is very small. Also i need help to setup a factbox. Also for some reason whenever i create a new text frame , there is a dark background and a dashed border . I just need help with the tables and the factboxes. and i will do the tepseting myself.

I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases

...be to rigorously test the relationships between the variables I've collected data on, as well as assess the moderation effect. - Report Writing: I expect a comprehensive and detailed report of the hypothesis testing results. The report should be clear, well-structured, and easy to understand, as the results will be crucial for my research. I also want the statistical results from the software (tables) and dataset. Ideal Skills and Experience: - Proficient in Structural Equation Modelling (SEM) and SmartPLS: It's essential that you have a deep understanding of SEM and specifically experience using SmartPLS, as this is the software we'll be using to conduct the analysis. - Strong Statistical Background: Sound knowledge of hypothesis testing and moderation analysi...

I need a wordpress plugin with a custom backend (API) The plugin is bascially a step by step registration form. Form must be made responsive. Data must be saved in seperate tables not in wordpress. The form must be a step by step form, with the design and colour i will show. Partical data must be encrypted into the database using non reversal encryption. I will explain more into details for the right coder.

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...

...some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understand and translate my content into engaging visuals. - Organizational and time management skills to deliver the...

...should also be optimized to assess strategy effectiveness and make necessary adjustments while trading. Strategy uses pivot points - the pivot points highlight a certain candle, specifically the high and low of that candle.

 A box is then drawn from that high and low of the candle all the way to the right until price trades back into it, then box stops and trades are entered. In a short trade for example with a risk/rewards set at 1:1, when price comes up to the low of that box we would enter short and the stop loss would be the high of the box and the take profit would be equal to the size of the box, but down. So if the candle which defines the Low and high of the pivot/ box is 10ticks in size from high to low then when we exit that trade the take profit wou...

I'm seeking an expert in Flutter and Firebase to develop a robust restaurant management app. The desired application will incorporate features for order management, table reservations, and menu displays. Key Features: 1. **Order Management:** This function will allow users to manage customers' orders easily. 2. **Table Reservations:** Users should be able to reserve tables via the app. 3. **Menu:** To enable customers to view different meals and their prices, the app will need a menu feature. System Integration: The app needs to seamlessly integrate with a POS system and an online reservation system. Your experience in API integration is desirable. User Roles: The app should support multiple user roles to accommodate administrators, managers, and waitstaff. Each role w...

I'm looking for a competent draftsman to assist in the creation of technical drawings for different pieces of residential furniture. This includes beds and wardrobes, tables and chairs, as well as cabinets and shelves. Although we have not finalized on a specific style or design as yet, the draftsman needs to be versatile and capable of adapting to changes. Ideal Skills and Experience: - Proven experience in drafting residential furniture - Proficiency in CAD or similar drafting software - Strong attention to detail and understanding of construction methodologies - Ability to translate design ideas into technical plans - Proactive communication

...responsible for designing the space. This involves arranging furniture, selecting wall materials, deciding on color schemes, and any other design elements necessary to create a cohesive and functional interior. 3. **"WITH AVAILABLE RESOURCES THAT I HAVE IN MY FURNITURE SHOP"**: The design should incorporate furniture and other items available in my furniture shop. This could include sofas, chairs, tables, lighting fixtures, and other furnishings. 4. **"AND WALL MATERIAL LIKE LOUVERE CHANNEL, PVC ETC"**: The design should also utilize available wall materials such as louvre channel, PVC panels, or any other materials we have in stock. These materials can be used for wall coverings, partitions, or other decorative elements. 5. **"OR IF ANY WALLPAPER DESI...

I need an expert to proofread a 200-page document intended for consulting in the Law Enforcement area of Public Safety. The task involves: - Correcting spelling and grammar, - Ensuring the logical flow and consistency of the narrative, - Checking alignment with charts, figures, tables, maps, and other visual aids. The ideal freelancer should have: - Exceptional English communication skills, - Strong attention to detail, - Experience in Law Enforcement or Public Safety consulting, - Familiarity with proofreading educational and research materials. This is a valuable opportunity to polish a crucial document that aids in developing efficient and effective public safety practices.

On our Django project, we're in need of a skilled professional that can help with small tasks improving the existing Django based Customer Register back-end solution and front-end - Frontend Development with Minimalistic Design: Some small form, text etc changes. - Database Management: Some new fields and tables must be added to register. - Django REST Framework Integration and API Development, we are interested in having REST based API on our Register back-end to have more flexible front-emd development. So wondering if "Django REST Framework" is the right one. So , we're looking for a Django specialist with deep understanding of frontend development, database design, and REST frameworks. The ideal candidate must have a keen eye for minimalist design, an i...