Integrate jira and excel jobs

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and h...

...involve refining the user interface and tailoring the menu categories and options to meet our specific needs. Key Responsibilities: - Implementing UI modifications: We require a fresh color scheme and branding throughout the app, as well as font and typography adjustments to enhance overall aesthetics and user experience. - Customizing menu categories: Your role will involve modifying existing menu categories and options to align with our unique requirements. Ideal Skills and Experience: - Proven experience in Flutter app development, with a portfolio showcasing similar projects. - Proficiency in UI/UX design, particularly in executing color, branding, font, and typography changes. - Strong understanding of backend systems and...

I'm facing an issue in Google Mercha...requirements: - The freelancers need to be well-versed with Google Merchant Center and its product listing requirements. - Experience in managing electronic products specifically within the platform is a plus. - Proficiency in integrating inventory data with eCommerce platforms is essential. Your main tasks will include: - Resolving the current issue of missing inventory data for the electronic product category. - Ensuring the inventory data is accurately synced with the eCommerce platform for seamless management. Ideal Skills & Experience: - Proficient in Google Merchant Center - Experience in managing electronic products' listings - Ability to integrate inventory data with eCommerce platforms - Strong attention to det...

I'm in need of an experienced .Net developer, with solid skills in MSSQL and C#, who can effectively handle front-end development tasks in my POS terminal project. Your primary tasks will be: - Implement business logic based on defined user stories. - Develop the user interface of the POS terminal using C# and associated .NET technologies. - Integrate the POS terminal with MSSQL database for data storage and management Ideal skills and experience: - Proficiency in .Net, MSSQL, and C#. - Previous experience in front-end development. This role requires both technical expertise and keen attention to detail. I am looking forward to your innovative solutions to meet our project requirements.

I'm looking for an expert in Power Apps to enhance my project with additional functionality. As with most Power Apps endeavors...my project with additional functionality. As with most Power Apps endeavors, this one aims to automate processes, create a mobile app, and manage data and workflows. The project has a broad scope and I need a detail-oriented professional who can ensure everything runs smoothly. Despite skipping a few questions about the specifics, I will provide complete details once we start our discussion. Ideal Skills: - Extensive experience in Power Apps - Strong understanding of automation processes - Excellent communication skills - Attention to detail - Ability to integrate systems - Experience in mobile application development - Proficie...

I'm in need of a skilled Flutter developer with knowledge of ONNX model integration for offline classification. I will provide the model in that format and also the flutter project. I need you to integrate so tbat it runs offline on device. They are finetunes distilbert model. My budget is 30 euros and 2 days maximum. If you are interested only then bid

I'm looking for a creative and professional logo design that's both bold and colorful. Here's what I envision: - Incorporation of my brand name, a distinct symbol, and a mascot. - A balance of professionalism with a vivid and artistic flair. - A design that communicates creativity while also instilling trust. The ideal freelancer for this job would have: - Experience in creating bold, colorful logos - Ability to integrate both a symbol and mascot into the design - A knack for communicating messages through design elements - Proven track record of professionalism and meeting deadlines.

Looking for a skilled developer proficient in Python, Node.js, Postgresql, and Next.js. The project involves integrating an existing Python bot into a website to automate product data input. Key requirements: -Bot Integration: Seamlessly integrate the Python bot with the website's Node.js backend and frontend. -Automated Data Input: Ensure the bot reliably inputs product-related data, leveraging expertise in Postgresql for database management. -Error Handling: Implement automatic bug reporting in case of data input errors. If you have relevant experience in bot integration and database management, please submit your bid.

I have a Wordpress based website and I'm looking for an expert who can integrate HubSpot and Moneris and donation forms and clean up a few other forms for a not-for-profit entity that helps people. Key Requirements: - Integration of HubSpot and Moneris with the existing Wordpress website. - Donation form should support recurring donations on a monthly and annual basis with An email dedication feature allowing donors to include a personalized message to honour or in memory of a person for their donation. Ideal Skills: - Proficiency in HubSpot and Moneris integration. - Experience with Wordpress websites and forms. - Familiarity with setting up donation forms and managing recurring donations. - Ability to implement...

...MATLAB and C++ syntax. The existing rules for translation from MATLAB to X10 need to be adjusted to C++. - **Add Support for C++ Specific Libraries**: The modified application should be able to integrate commonly used C++ libraries seamlessly. Accuracy and Time: - **Accuracy is Key**: The conversion of MATLAB code to C++ needs to be precise. While I'm open to additional development time, the primary goal is to ensure the accuracy of the conversion. - **No Specific Library Requirements**: Though the modification needs to support C++ libraries, I have no specific libraries in mind for the conversion process. Ideal Skills and Experience: - Proficiency in Java. - Previous experience with code translation tools or projects - Strong understanding of synta...

I want to integrate my online shop shipping with api from

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated wit...

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar pro...

I'm looking for a talented video editor w...YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling, even though I've not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, t...

I'm seeking a skilled developer who can seamlessly integrate Radius Manager with Sage One, with two primary augmentation features: 1. Account Status Notifications: The system must automatically update clients about their account status. The notification methods should include Email, SMS, and WhatsApp messages. 2. Client Suspension/Activation: Depending on the payment status, the system should have the ability to either suspend or activate the client's accounts. 3. DMA Radius handles 4 companies the integration needs to get the needed information from Sageone per company and suspend or activate the client. Proficiency in application integration, knowledge of Radius Manager & Sage One, experience with diverse notification channels, and a good u...

I'm in need of a comprehensive presentation that will both inform and train its audience. Key aspects of the project: - The final presentation should be over 20minutes long. - It must integrate video segments with animations. The ideal freelancer for this project should have: - Proficiency in creating engaging and interactive presentations. - Experience in creating educational content. - Strong animation skills. Looking forward to receiving your bids.

I'm looking for a skilled Odoo developer who can help me seamlessly integrate Magento 1.9's user authentication with my existing Odoo 16 installation. Key Requirements: - Allow Magento users to log in to Odoo using their existing credentials - Ensure a smooth, secure, and seamless synchronization between the two systems Ideal Skills and Experience: - Proficiency in Odoo module development - Experience with Magento 1.9 and its user authentication system - Strong understanding of authentication protocols and security best practices Job Description: We are in need of a skilled software developer proficient in Magento 1.9 (now OpenMage 20.2.0) and Odoo 16 CE to create a module that facilitates user authentication between the two platforms...

We are looking for a skilled developer to integrate a Python program with our WordPress site. The program requires user login and forms to feed data, which will then trigger API calls to display output on the site. The main task is to ensure smooth integration between WordPress and the Python program. The project requires the following skills: - WordPress development - Python programming - API integration - User login implementation - Form development and data feeding If you have experience in these areas and can deliver high-quality work within the given timeframe, we would love to hear from you.

I am looking for a skilled developer to create an engaging and user-friendly informational website, with a focus on presenting documentation forms and messages. The website should include a contact form for people to reach out easily. I am keen to find someone who can create a website that makes these documents easily accessible and clear to read. Ideal Skills and Experience: - Experience developing informational websites - Ability to integrate and develop a functional contact form - Exceptional ability in presenting text-based content - Detail-oriented and with a strong sense of website navigation and architecture.

...experienced Android app developer to create exciting puzzle and simulation games. My vision is for games that are innovative, fun, and have the potential to become addictive and want to launch in google play store. Ideal Skills: - Robust knowledge of Android game development. - Excellence in creating puzzle and simulation games. Key Features: - In-app purchases: Integrate microtransactions that provide players with the ability to purchase extra content within the game. - Leaderboards: Implement a competitive feature that tracks and displays player scores and rankings. As the ideal candidate, your portfolio should demonstrate a range of engaging puzzle and simulation games with similar features. Proven experience with in-app purc...

I'm looking to integrate a one-to-one video call feature with a recording capability. The video calls will be of standard definition (SD) quality. Key Requirements: - Implement a one-to-one video call feature using WebRTC. - Incorporate a local recording function for these video calls. Ideal Skills: - Proficiency in MERN stack. - Experience with WebRTC and video call integration. - Knowledge of video recording and storage mechanisms. - Strong understanding of video quality standards.

I'm in need of a skilled Photoshop designer who can add a modern and sleek text overlay to an existing design. The work is straightforward and should be easy for someone with the right skills. Key Requirements: - Add a modern and sleek text overlay to an existing Photoshop layered file. The design should be in a monochrome color scheme, specifically black, white, and grays. Ideal Skills and Experience: - Proficient in Photoshop, with a strong understanding of layered files. - Experience in text overlay design, ideally in a modern and sleek style. - Ability to work with a monochrome color scheme effectively. This project is perfect for someone who enjoys working on design details. The final outcome should seamlessly integrate the ...

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

...need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize acc...

We are in need of a skilled and experienced individual to seamlessly integrate plumbing components to our existing design. Although we didn't specify the exact components, it is essential that they are determined and added with precision. Key Responsibilities: - Identify and add necessary plumbing fixtures - Ensure the design remains aesthetically pleasing - Troubleshoot potential issues - Provide a high-quality solution that meets industry standards Ideal Skills: - Proficient in plumbing design and installation - Attention to detail - Strong problem-solving skills - Excellent communication and collaboration abilities Please note that as the purpose of these additions wasn't specified, the freelancer will need to be flexible and...

...complete a landing page with order function and integrate Stripe payment gateway. Landing page is designed already and has some initial PHP code already. The landing page is part of our Affiliate program. Each Affiliate gets their own landing page with their own contact details displayed. Affiliates promote this page and earns a commission on each sale through the page. All this should be recorded in the DB. They way it should work is like this: The code should then take the "username" and use it as a variable to select the right Affiliate in the DB with the corresponding username. Now it takes the details for that Affiliate and shows on the landing page. You have to check that this works. 1. Check the code in the landing pa...

...thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching storm theme. Ideal freelancers for this project are those experienced with graphic design, particularly in creating Twitch streaming overlays. A goo...

...thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching storm theme. Ideal freelancers for this project are those experienced with graphic design, particularly in creating Twitch streaming overlays. A goo...

I'm looking to create a 5-minute video presentation for my personal proj...5-minute video presentation for my personal project. I already have some initial parts of the video, which I will provide, and I'd like you to extract the contents from a very detailed website and mockup graphics. Key Requirements: - The video should follow a specific style of presentation (details will be provided). - The final video should be around 5 minutes long. - Some parts of the video are already completed and will be shared with you to integrate with the new materials. Target Audience: I will share detailed information about the target audience via messages. Ideal Freelancer: - Experience in creating engaging presentations - Proficiency in video editing and ...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I need a Po...need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent...

...central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and familiar with Filezilla - Experience with network secu...

...Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits...

I'm in search of a skilled and experienced web designer who specializes in blog website creation. I intend to utilize this platform primarily for sharing resources and tutorials. Key Requirements: - Develop a blog-type website - Professionally designed layout - User-friendly interface Additional Functionality: - Add functionality for user registration and login - Integrate a subscription list feature Ideal candidates would possess high proficiency in creating user-engaging web designs and have a keen understanding of incorporating specified features. Knowledge and experience in website usability and functionality are vital. The main goal is to foster a smooth user experience and promote continuous interactions.

...Integration and Personalized Marketing System Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system aims to provide ins...

I urgently need a professional to integrate SunPay Payment Gateway into my Android app. Gateway is already working. Just need to fix few integration related issues. Key responsibilities: - Establish a fluid and secure payment process through the SunPay system - Ensure optimal user interface for the payment process - Execute rigorous testing to guarantee a flawless user experience Ideal candidate will have: - Extensive experience in Android app development - Proficiency in PHP, Java and Kotlin - Proven record with integrating payment gateways, particularly SunPay, into Android apps - An ability to work under a tight deadline. This project needs to be completed ASAP.

...algorithmic trading and API integration to assist in setting up automated trading signals. Our algorithm, currently operating on the TradingView platform, generates precise buy and sell signals. However, we require assistance in seamlessly translating these signals into actionable trades on our trading platform. The primary objective of this project is to integrate our existing algorithm with the trading platform's API to automate the execution of trades based on generated signals. The selected freelancer will be responsible for establishing a robust connection between the algorithm and the trading platform's API, ensuring timely and accurate execution of orders. Key tasks include: 1) API Integration: Configure and establish a secur...

...involve integrating APIs for KYC, Wallet, Payin, and Payout functionalities. Key features include user management, contract management, and notifications. Requirements: Proficiency in app development with a focus on security and user experience. Ability to integrate APIs seamlessly. Familiarity with KYC processes and payment gateways. Strong communication skills and a proactive approach. Project Scope: Develop the app based on the Figma design. Implement sign-in, sign-out, and user management features. Integrate KYC, Wallet, Payin, and Payout APIs. Create a contract management system. Set up notification functionality. Note: Chat functionality is not required. Project Budget: The project budget is 25,000 INR. How to App...

...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical anal...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from ...of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suit...

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.

I'm in need of a WordPress web...website for my fashion clothing business. I'm looking for a skilled web developer that can integrate an accounting system into the site. The main function of this accounting system should be to track sales and expenses. Additionally, I'm looking for the following features to be integrated into the site: - Customer Reviews - Live Chat Support - Membership Registration The ideal candidate should have experience in building e-commerce websites, particularly on the WordPress platform. The candidate should also have a good understanding of accounting systems and be able to implement a robust tracking system for sales and expenses. Experience with integrating customer review systems, live chat support, and membe...

I'm seeking an experienced app developer who can create a telemedicine app for both iOS and Android platforms. The app needs to include the following features: - Video consultations: To enable patients to have video calls with healthcare providers. - Prescription management: To enable patients to easily view, manage, and refill their medication. - Appointment scheduling: To allow patients to book, reschedule, or cancel appointments with healthcare providers. Additionally, the app needs to integrate with: - Electronic Health Records (EHR) system: To enable seamless information flow between the app and EHR system. - Payment gateway: To provide patients with an easy method to make payments for consultations or prescriptions. - Pharmacy database: To ensure p...

I'm urgently in need of a Python...specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom ...

I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.

I've been assigned the task of building a web application where users can input company names, and any publicly available information (uploaded on MCA portal by registered companies ) about those companies will be retrieved. There are already existing web apps that do this, for example [India fillings search]() [quick company company search]() [MCA portal]() However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](),

...developing a CRM system, creating a trustworthy company logo, and setting up a website with a contact form. CRM SYSTEM: - The primary focus of the CRM is customer management, so it must be tailored for this purpose. - It should be intuitive and easy to use, as it will be accessed by multiple team members. LOGO DESIGN: - My company's logo should reflect trustworthiness. It needs to be simple, elegant, and professional. - Should be easily recognizable and suitable for use across various platforms. WEBSITE DEVELOPMENT: - The website should have a sleek, modern design. - Its primary function is to inform visitors about my company and offer a means of contact. - The website needs a contact form. This is essential for potential leads to reach out ...

Project Description: I am seeking an experienced Magento developer to integrate advanced filtering capabilities into our Magento 1.9.2.1 e-commerce platform, which focuses on children's products. This enhancement aims to streamline the shopping experience, allowing users to perform precise searches and thus improve overall user satisfaction and conversion rates. Key Requirements: Size Filter: Implement a filter for children's clothing sizes ranging from 0-6 years. This should include a series of checkboxes allowing selection from predefined sizes available in our product database. Shoe Size Filter: Similar to the clothing size filter but specifically for children's shoes, covering German shoe sizes 17 to 28. The filter should dynamically display only ...

...the processing and analysis of text data. Prior experience with this data type is a definite advantage. - Goal: The main objective of this project is to perform in-depth data analysis. I need the freelancer to assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code for the following calculation of Code Synchronization adoption rate: I've 4 excel files, 2 Jira extracts and 2 solman extracts. 1 for Jira Support state(support user stories & bugs) and 1 for Solma...