Power bi connect to sharepoint folder jobs

I am currently working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control

...developer to create a comprehensive video software demo that can showcase our product for marketing purposes. Note: The software is not done yet. So you will have to use reference site as demo. The software demo is Y-Combinator meets Kickstarter for Black-Americans. Key features to display 1. crowdfunding platform, which allows people to raise money for creative projects and people to pledge money to projects 2. entrepreneur matchmaking- which allows entrepreneurs to connect with team members 3. online courses - to educate people on investment and other money-making topics Requirements: - The demo should be user-friendly, with a clear interface that highlights our product's key features and benefits. - The so...

I'm in search of a talented writer who can craft gripping, contemporary romance novels with dramatic twists and turns. I prefer novels that are s...novels that are short, less than 100 pages. If you have experience in romance writing and can deliver compelling narratives with characters that readers can connect with, I'd love to work with you. Key requirements: - Specialization in contemporary romance - Proven experience in writing dramatic and intense narratives - Ability to create short, yet captivating stories - Strong understanding of the romance genre - Good understanding of character development Please share samples of your previous work in your proposal, especially if it aligns with the requirements of this project. Looking forward to finding ...

...facilitates the rental of objects between users. We connect people interested in saving money by renting objects instead of buying, with people who have unused objects and who want to earn extra money. We are a Brazilian startup starting an online platform. Perhaps the scope of the project and all the information are not in the best shape, but we have done our best so far to help anyone developing it. What we need Pages developed in ReactJs according to the Figma project and documentation in Notion, using the best practices in the development market. We accept suggestions for adjustments and improvements to the project. Maybe the Figma project doesn't have the best structure because we're beginners, but we've created a way to m...

I'm looking for a skilled graphic designer with a mature yet creative aesthetic to create a poster. The target audience for this poster is adults. Key requirements: - You should have a portfolio that showcases different design styles. - Understanding of audience: You should understand how to create a design that appeals to the adult target audience. It's essential that the design is eye-catching and engaging. I need someone with a proven track record of creating successful modern posters. Please connect only if you have a portfolio*****

I'm in need of a qualified Electrical Engineer, specifically with a PE license to assist with the design of a 20-unit apartment complex of approximately 1500 sf each in Pomona, CA. Ideally, you should have experience in multi-dwelling residential projects. Project requirements include: - Lighting: Design needs to incorporate energy-efficient lighting, dimmable lighting options, and outdoor lighting. - Power outlets: Accurate estimation of the number of outlets per room, inclusion of USB outlets, and GFCI outlets in the design - HVAC System Wiring: Appropriate designs for efficient air conditioning and heating across all units. The project involves 3-4 typical units' designs - each featuring a kitchen, dining area, toilet and 2 bedrooms with bathrooms. Your ...

I am looking for an expert to put together a professional sales report using Sisense, solely based on my e-commerce platform data. Key Information: - The report should focus on sales statistics and trends, analyzing data collected from our e-commerce platform. - The main purpose of this reporting is to help us make strategic decisions and improve our sales performance. - I would appreciate if the report is visually appealing and easy to interpret, as this will be shared with different teams in our company. Skills & Experience: - Proficiency in Sisense or similar BI tools is a must. - Previous experience creating sales reports is highly desirable. - Understanding of e-commerce data, especially sales metrics, is crucial. Please note that the report you p...

...adept and experienced in Microsoft SharePoint and particularly MS Viva suites. The need is to improvise and enhance a few specific functions which include: - Document Management: However, it remains undecided whether the structure would be folder-based or metadata-based tagging. Suggestions are welcome. Also, make sure version control is facilitated. - Collaboration Tools: You would be required to include and set up some essential collaborative tools like document sharing, team calendars, and discussion boards to ease out internal communication and coordination. Moreover, a fundamental task would be to automate workflows to increase operational efficiency. The ideal candidate would be someone equipped with a scrupulous understanding of ...

...need a professional to create a Figma software demo. The purpose of this demo is to showcase the key features and functionalities of our product clearly and engagingly. The is of "Y-combinator meets Kickstarter" You should research Y-combinator and Kickstarter if you are not familiar with them. Key Requirements: - The demo should be a high-level overview focusing on the most important features and functionalities of the software of platform: which allows people to raise money for creative projects. ----2. people to browse projects and pledge money ----3. networking messaging for entrepreneurs to connect with and match with other entrepreneurs based on needs like seeking teams mates and skills ----4. online courses - The content s...

I'm in need of a bi-fold brochure that serves as an informational guide. - The primary goal of this brochure is to be a comprehensive informational guide - The target audience for this guide is the general public - Your design should be professional, sleek, and easy to read - It should creatively present complex information in an engaging and comprehensible manner. Ideal freelancer for this job should have experience in: - Graphic design for print - Brochure design, particularly bi-fold - Experience in creating informational guides - Understanding of effective visual communication for a general audience.

I'm in search of a skilled freelancer familiar with API integration and betting sites to help me with a project. - The main task is to connect our betting site with a sports betting API. - Following that, I'd like to expand our market to include Football, Basketball, and Tennis. - The integration should help retrieve two main types of information: live scores and odds & betting lines. The ideal candidate for this project should have: - Profound experience in API integration, particularly with sports betting APIs. - Strong knowledge of Football, Basketball, and Tennis betting markets. - Be capable of managing live data and converting it into meaningful information for our platform. - A good understanding of odds and betting lines would be ...

Hi I need VPN application to connect to v2ray configs For example, I have several servers with Vless, Vmess and Trojan configs from several different countries server, also I need to update servers through admin, sort servers, delete, add and hide Ability to use free and premium modes, connect to PayPal and Stripe payment gateways, etc. But I need Run this project step by step for example for first task just free plan and then add premium plans and gateways and etc. for example then I need create ios app and more I'm looking for a skilled developer to create a custom VPN application for my needs and upgrade it in future

I am looking for a creative and professional logo designer who can create a logo that will evoke trust, event planning, excellency, ease, power, and simplicity. The colors are up to you, but I would like the design to integrate elements that symbolize a sun, the "E" ampersand, and a symbol of excellence such as a grade. Key requirements are: - Ability to create a logo that evokes specific emotions and feelings - Understanding of the event planning industry - Proficient in symbol integration within logo design - Prior experience with corporate branding is a plus In order to be considered, we provided our Home Page With the a DUMMY LOGO placeholder. We will decide based on the proposed logo that makes this Home Page looks best so you must submi...

Hello! We're looking for an expert in Android or Flutter for an urgent project. Currently, we have the system connected on Android, but the app is lacking in many aspects. We need to connect the system on Flutter and develop the functionalities we need. In Android, we need to implement an ID confirmation and a dropdown category indicating products delivered in the main warehouse, among others. This will help us keep better control over the system. It's urgent, and we need to complete it today! If you have experience in Android or Flutter and can help us with this, please contact us as soon as possible!

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I'm looking for an experienced professional in Power Factory and Electronics. The project will involve a mix of tasks such as circuit design, power system analysis, PCB layout design, as well as potentially designing a circuit, simulating power systems, and developing control systems. Ideal Skills and Expertise: - Proficiency in Power Factory and Electronics - Prior experience in circuit design, power system analysis, and PCB layout design - Capability to undertake tasks related to designing circuits, simulating power systems, and developing control systems. - Strong problem-solving ability The task involves working on a project where knowledge and expertise in Power Factory and Electronics is crucial. The right candida...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- G...

I am looking for expertise in React Native. The first module of the application is straightforward: it involves taking a picture and saving it to a local folder. Subsequently, the pictures need to be uploaded to Google Drive or a similar shared drive. The goal is to take pictures, extract data using machine learning and OCR. I can make payments, but they will be small and incremental. Additionally, I am looking for someone proficient in leveraging ChatGPT and other AI/LLM development tools. Looking forward to your prompt response.

I am in need of a logo for my business, Warfighter Technology Services. It is essential that the logo conveys a theme of Strength and Power, while utilizing a color scheme that aligns with military aesthetics. Key Points: - Business Name: Warfighter Technology Services - Theme: Strength and Power - Color Palette: Military Colors Ideal Skills: - Experience in designing logos with a focus on conveying specific themes - Proficiency in creating visually appealing designs using military colors - Understanding of the needs and aesthetic preferences of the technology services industry If you are confident in your ability to create a logo that embodies these requirements, I would be interested in discussing this project with you.

I'm seeking an electrical engineer skilled in circuit design for consumer electronics. I want to design the schematic for a buck converter based on the Integrated circuit i chosed.

...developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier...

...blockchain developer to create a secure bridge crypto that will facilitate cross-chain transactions between BEP20 BSC and HECO chain. Key Requirements: - Design and develop a bridge crypto to connect BEP20 BSC and HECO chain. - Implement high-level security with multi-signature authentication to ensure the safety and integrity of transactions. - Ensure the bridge crypto is efficient, seamless, and able to handle transactions between the two chains smoothly. Ideal Skills and Experience: - Proficient in blockchain development and familiar with BEP20 BSC and HECO chain. - Experience in creating cross-chain bridges or similar projects. - Strong understanding of security protocols, particularly multi-signature authentication. - Excellent problem-solving a...

I am looking for an experienced electrical engineer who can perform a load flow analysis using Power Factory with moderate accuracy. Key Responsibilities: - Conduct a comprehensive load flow analysis of the electrical system specified. - Ensure moderate accuracy in the results obtained. - Provide detailed documentation of the analysis and results. Ideal Candidate: - Skilled and experienced in using Power Factory for load flow analysis. - Able to deliver accurate results while working independently. - Strong written communication skills for documentation.

I need a dedicated LinkedIn Specialist to refine and manage our company's LinkedIn presence. Responsibilities: - Post three times a week, maintaining a consistent and engaging schedule - Connect with HR professionals and key decision-makers, aiming to cultivate a strong network - Engage with content to enhance visibility - Track analytics to measure and improve our LinkedIn performance Your primary goal will be to nurture professional relationships within our industry. This role will require a strategic approach to networking, utilizing engaging content to foster connections. The content you'll be focusing on is mainly company updates and achievements. You must translate our successes and milestones into compelling, shar...

...PST files and cloud storage services to relocate my PST folder from OneDrive to Google Drive. - I use Microsoft Outlook for email and have been encountering storage space limitations with my current setup. - The size of the PST file is between 2GB and 10GB. - The main goal of this project is to alleviate the storage issue while ensuring a seamless transition of my email data to Google Drive. Ideal candidates should have: - Strong experience with Microsoft Outlook, including handling and migrating PST files. - Proficient knowledge of both OneDrive and Google Drive to efficiently move the PST folder. - A clear understanding of data migration best practices to ensure all data is securely transitioned without any loss or corrupti...

I'm looking for a skilled social media manager to handle our business's social media platforms. Job and responsibilities: 1. Instagram: 1.1 Perform Engagement activities 6 days a week. increase likes and comments until we reach 300 likes a day and 150 comments a day on 100 different accounts. target accounts are followers and people who liked my ads. 1.2 Upload 3 stories a day, using my material from Google Drive. 2. Write captions and hashtags for posts on about 50 posts a month (just write the caption and hashtags once a month) I can pay weekly , bi weekly tr month after the job is done, I can pay some of it in advance.

I have a photograph of a building mural which requires some thorough editing: • The first task needs precision and attention to detail, as it requires the elimination of obstructive elements in the photo. More specifically, I need the power lines and parking signs removed to highlight the mural. • Secondly, there are missing portions of the sign text that I would like restored. The complete text should read as: [Sharkey Issaquena Medical Clinic]. Freelancers must have excellent photo manipulation skills to integrate the missing text smoothly and convincingly. • Lastly, the picture lacks vibrancy, I want the colors and saturation adjusted for a more eye-catching and dynamic result. Expertise in Adobe Photoshop or similar graphic design software...

...seeking a skilled freelancer to help me connect them for a home automation project. Key Responsibilities: - Implement a system that can control lighting, monitor temperature and provide security surveillance - Ensure the system can be powered using solar, wind, battery and be connected to the internet. The ideal candidate should have experience in: - Arduino and BBC Micro:bit programming - Home Automation projects - Solar and wind energy integration - Internet of Things (IoT) connectivity - Strong understanding of security surveillance systems Your role will involve setting up a reliable, efficient and user-friendly home automation system. The ability to integrate multiple power sources and ensure the system is internet-connected is important. My g...

Seeking a front-end developer to connect with my Java backend. I require a front end that can handle real-time data interaction. The project is urgent, I need the work done in the next couple of days. Key Requirements: - Utilize Java back-end - Implement real-time data interaction - Ensure Continuous Integration (CI) - Setup Automated Testing The ideal candidate should be proficient in front-end technologies, Java, CI/CD processes, and have a good understanding of real-time data handling. Prompt availability is crucial for this project.

many lesson slides similar to power point created for spelling and reading

I am in urgent need of a proficient mobile app and web developer to create a robust platform titled 'Legal Connect' that will serve as a bridge for effective communication between lawyers and their clients. Crucial Task Details: * The app needs to be dynamic and accessible from iOS, Android, as well as Web platforms - a wide reach is essential. * Key features that need to be integrated include: secure document sharing, intuitive appointment scheduling, seamless case tracking, ensuring up-to-date case details at everyone's fingertips. * The project has a strict deadline and needs to be completed and ready for use within a month. Desired Skills & Experience: * Proven expertise in cross-platform app development * Strong und...

I'm seeking a talented copywriter with experience in translating complex medical concepts into Turkish for my pain management clinic's webs...testimonials, so the copywriter should be skilled in incorporating these into the overall content. - Language Level: The content should be highly technical to cater to medical professionals, ensuring a precise and accurate representation of our clinic and services. Your role will be crucial in helping us connect with our Turkish-speaking audience. A deep understanding of pain management and medical terminology is essential, as is the ability to deliver engaging and authentic patient stories. If you're a professional copywriter with a passion for medical writing and the ability to translate nuanced c...

Hi there, We are a travel agency looking for an expert in API integration to answer the following questions: Is it possible to connect and our own booking system to check and update automatically accommodation availability, rating, pricing and meals within our internal booking system? It should take into consideration a radius of 5-10km from a certain city point. Our own booking engine works automatically as follows, it sends a booking request to the accommodations on a certain accommodation list (from the first to the last one on that list) following a rule: if the first accommodation on the list denies our booking request, automatically the request will be sent to the second on the list, and so on. What will the requirements?

I'm seeking a skilled developer to integrate a pixel into my WordPress website that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected le...

I'm in search of a skilled WordPress developer to take our current web site, , grow its traffic flow exponentially, come up with innovative ways to connect our various social media channels to the site to boost traffic from social to web, add api feeds to save content creation writing articles time, and bring tactics and ideas to bring more engagement, with the following key features: - **API Content Feeds:** I need the site to display a variety of content types, including news articles, video content, social media updates and publically valuable content, sports, birth & death notices. The ideal candidate for this project should have: - **Experience with News Media Websites:** Experience in creating personalised new...

A leading Dynamics 365 and Power Platform consulting firm, is looking to partner with an experienced web design and content creation company. We aim to elevate our online presence with a professionally redesigned website, featuring enhanced UI/UX and compelling, industry-specific content. Our website is built on WordPress, so we'll be only looking for WordPress Developers. Key requirements: -Proven experience in design and development in WordPress. -Proven experience in UI/UX design for consulting firms -Expertise in creating engaging and informative content -Familiarity with Dynamics 365 and Power Platform Ideal skills and experience: - Strong portfolio showcasing previous graphic and UI/UX design work - Experience working on similar projects - Excellen...

I need assistance wi...electrical drafting for an industrial setting. You will work primarily with my team to develop an electrical plan mark up from an already finished design. We are looking forward to: - Incorporating the markup into the existing plans for clear visualization of electrical components. The ideal candidate should have expertise in electrical drafting, specifically for industrial projects. In-depth understanding of mark ups and visualization of electrical components is essential for this project. You should also have a strong command of drafting software and be able to collaborate effectively with a team. The project consists of 18 industrial units. The project entails single line diagrams, marking lighting and power plans and drawing undergr...

...should be able to ensure optimal performance and security. - API Integration: There is a need for the integration of an 'informative application' API. This task requires someone with prior experience in integrating custom APIs and a strong understanding of how to effectively connect APIs for seamless functionality. Ideal Skills and Experience: - Proficient in PHP for backend development. - Strong background in server configuration. - Demonstrated experience with API integrations, particularly information application API. - Ability to problem solve efficiently and effectively. - Excellent communication skills and ability to work under tight deadlines. If you're an experienced PHP developer who can confidently handle server configurati...

Develop a whistleblowing management platform for Spanish companies to efficiently handle reports of misconduct, ensuring compliance with current regulations. The platform should manage reports as tasks within the organisation, with defined states, assigned responsibilities, and status updates for the reporter. Additionally, it should include a Business Intelligence (BI) panel with detailed statistics on generated and managed reports. User Interface (UI) Report Form: An intuitive interface for reporters to submit their reports anonymously or with personal details. Reporter Portal: Access for reporters to track the status of their report using a unique code. Task Management for Reports Task States: Each report should go through various states (e.g., Rec...

I am seeking a proficient and reliable safety advisor for a substantial lineup of Music Concerts, Sporting Even...crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024 Expenses covered: Transportatio...

hello I am currently looking for an Amazon AWS expert. We are currently creating about 5 WordPress websites and are looking for someone to host them on Amazon AWS Lightsail and connect the domain/install SSL and TSL. Budget is around 10 dollars Please enter "ITaws" to confirm you are not a bot

...a skilled freelancer to develop a Procurement Management App using PowerApps. This comprehensive app will streamline various aspects of procurement, including sales, purchases, offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer ...

I'm seeking a skilled web developer to create a financial information website with features similar to forexfactory.com. The website will be designed with a modern and minimalist aesthetic. Key features include: - Live forums page: This will allow users to engage in financial discussions, share insights, and connect with other members of the community. - Economic calendar: We need a comprehensive economic calendar that notifies users of upcoming reports, events, and indicators that may impact the financial markets. We will need to find all the sources the main information comes from and scrape them using provided API's from the government sites that they provide usually. - SEC Insider Traders Page: This is a vital component of the website. It s...

I'm seeking a skilled professional to help me design a unique watch that will include a date, time, and moon phase display. The watch should be designed to run on a battery-powered system, and the display should be either a paper or LCD screen. Key requirements: - **Display:** The watch should feature a paper or LCD display that can show the date, time, and moon phase. The size of the display will be determined by the type of screen you select; please consider the optimal size for viewing these details. - **Power Source:** The watch should operate solely on battery power. - **Moon Phase Feature:** One of the key features of the watch is the moon phase display. This should be accurate and easy to see. Ideal Skills and Experience: - Previous expe...

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into act...

...familiar with OctoberCms to create a comprehensive hospital directory website. The site will serve as an important tool for patients, healthcare professionals, and the general public to find relevant information, connect with doctors, and explore hospital services. Key Features: - Doctor Profiles: A robust database of doctors' profiles. - Treatment Information: Detailed information about various treatments offered by the hospital. - Speciality Search: An intuitive search functionality for patients to find doctors based on their speciality. - Online Forms: Online forms for appointment booking and other requests. Key Objectives: - Provide Information: The website should serve as a reliable source of information for all visitors. - Booking Appointments: ...

I'm in need of an expert who can create a Power BI dashboard. Key Components: - The dashboard should integrate with Excel spreadsheets that contain our inventory data. - The primary goal of this dashboard will be to monitor and analyze instances of inventory loss. The ideal freelancer will be experienced with Power BI and data visualization, with a strong background in inventory management systems. You should have a proven track record in working with Excel spreadsheets and creating insightful monitoring dashboards. Your understanding of inventory management principles will be crucial in making this project a succes

I am looking for an experienced electrical engineer who can perform a load flow analysis using Power Factory with moderate accuracy. Key Responsibilities: - Conduct a comprehensive load flow analysis of the electrical system specified. - Ensure moderate accuracy in the results obtained. - Provide detailed documentation of the analysis and results. Ideal Candidate: - Skilled and experienced in using Power Factory for load flow analysis. - Able to deliver accurate results while working independently. - Strong written communication skills for documentation.

...help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage stability, and power transfer optimization ...