Microsoft biztalk jobs

Please Sign Up or Login to see details.

...documents Communicate with clients, agents, and developers regarding documentation and updates Generate basic reports on listing activity, lead performance, and agent output Requirements: Minimum 1 year of admin experience in a Dubai real estate company Good knowledge of Dubai Land Department & RERA procedures Confident in cold calling and lead follow-up Proficient with CRM systems and Microsoft Office Fluent in English (Arabic is a plus) Highly organized and reliable Must be based in Dubai and ready to work hybrid What We Offer: Competitive salary AED 3,000 – 4,000 based on experience Attractive commission on closed deals Work-from-home flexibility (hybrid model) Supportive team, positive work culture, and career growth opportunities Exposure to hig...

...Orders above ₹2,000 get 30% discount. Future scope for more intelligent discount logic based on purchase history, frequency, and loyalty. 4. Technical Requirements Frontend: React.js / Angular (modern and responsive design) Backend: Node.js / Django / .NET (secure API support) Database: MySQL / MongoDB (to store products, users, and orders) AI Chatbot: Custom-built with Dialogflow / Rasa / Microsoft Bot Framework Hosting: AWS / Azure / any scalable cloud platform Payment Gateway Integration: Razorpay, Paytm, or UPI support 5. Additional Features Coupon code system for applying discounts manually. Email/SMS notifications for order updates. Loyalty points or wallet for regular customers. Analytics dashboard for sales tracking and customer behavior....

...Orders above ₹2,000 get 30% discount. Future scope for more intelligent discount logic based on purchase history, frequency, and loyalty. 4. Technical Requirements Frontend: React.js / Angular (modern and responsive design) Backend: Node.js / Django / .NET (secure API support) Database: MySQL / MongoDB (to store products, users, and orders) AI Chatbot: Custom-built with Dialogflow / Rasa / Microsoft Bot Framework Hosting: AWS / Azure / any scalable cloud platform Payment Gateway Integration: Razorpay, Paytm, or UPI support 5. Additional Features Coupon code system for applying discounts manually. Email/SMS notifications for order updates. Loyalty points or wallet for regular customers. Analytics dashboard for sales tracking and customer behavior....

I'm seeking an experienced freelancer to resolve an issue with Outlook's search function. Currently, the search is returning incomplete results, particularly for recent emails. Ideal Skills and Experience: - Expertise in Microsoft Outlook troubleshooting - In-depth knowledge of email indexing and search functionalities - Experience with fixing search issues in Outlook specifically - Ability to work efficiently and provide a timely solution Please provide a detailed approach to how you would tackle this issue.

I need help formatting Word documents that have been converted from PDF. Requirements: - Adjust text alignment - Modify font style and size - Set proper spacing and margins - Add footers - Include document title and page numbers in headers Ideal Skills and Experience: - Proficiency in Microsoft Word - Experience with PDF to Word conversion - Strong attention to detail - Good understanding of document formatting Please provide samples of similar work done.

...Overview: We are seeking a seasoned freelancer or agency with a proven track record in building AI-driven sign language solutions. Your primary deliverable will be a real-time (and pre-recorded audio) widget that ingests Speech-to-Text and renders American Sign Language (ASL) animations via a customizable avatar. This widget must seamlessly integrate with communication platforms (Webex, Zoom, Microsoft Teams) and standard web environments. Only apply if you have already delivered a comparable solution from start to finish. This is not an exploratory or R&D engagement. Key Responsibilities: ** Solution Deployment: Immediately implement an existing AI-powered ASL avatar engine, adapting it to our environment. ** Integration: Wrap the avatar engine into a lightweight JavaScrip...

I am looking for an expert in Microsoft Excel who can build a fully automated taxi ride ledger system along with a professional dashboard to manage my local taxi business. The sheet should automatically calculate commissions, driver payouts, and provide visual dashboards based on daily and monthly data. Key Requirements: 1. Master Ride Entry Sheet: Fields: Date, Driver Name, Vehicle Type, Ride Type, Fare, Commission (%) Auto-calculation: Commission amount, Net payout to driver Filters for date range, driver, vehicle, and ride type 2. Driver-wise Ledger (Auto-Updated) Total rides, fare earned, commission, final payout 3. Vehicle-wise Report Revenue by Etios / Ertiga / Innova etc. 4. Dashboard with Charts Pie chart for revenue vs commission Bar chart for daily/mont...

I'm seeking assistance with Power BI, specifically on report sharing and collaboration. The integration needs to be with Microsoft Teams. Key requirements include: - Enabling real-time report sharing during meetings within Teams. Ideal Skills & Experience: - Proficient in Power BI - Experience with Microsoft Teams integration - Strong in setting up collaborative environments

I need an experienced professional to submit a Windows utility program to the Microsoft Store. Requirements: - Must have past experience in placing products in the Microsoft Store. - Complete the task within three days. - Start work immediately. - Payment upon completion only. Ideal Skills & Experience: - Proven track record with Microsoft Store submissions. - Familiarity with Windows utility applications. - Ability to meet tight deadlines.

I need an experienced professional to submit a Windows utility program to the Microsoft Store. Requirements: - Must have past experience in placing products in the Microsoft Store. - Complete the task within three days. - Start work immediately. - Payment upon completion only. Ideal Skills & Experience: - Proven track record with Microsoft Store submissions. - Familiarity with Windows utility applications. - Ability to meet tight deadlines.

2. Store Submission Skills If you're submitting an app someone else...Skills If you're submitting an app someone else developed, you'll need: a. Microsoft Partner Center Account You need to register as a developer: Registration costs: One-time fee ($19 for individuals, $99 for companies) b. Product Metadata Preparation App name, description, category, screenshots, icons, pricing, age rating, etc. c. Privacy and Legal Requirements Prepare a Privacy Policy (especially if your app collects any data) Ensure your product meets Microsoft Store policies d. Submission Process Upload package Fill in metadata Choose regions, pricing, visibility, etc. Submit for certification review by Microsoft for any payment products must be in Microsoft store...

Hello, My name is Fabian Jones, and I am a CAD designer. I am s...resume along with my personal career resume to serve as references. I have also attached the 3DX Technology logos. Please use the attached logo design. The final version of the 3DX Technology resume should be delivered in Microsoft Word format. Please feel free to reach out if you have any questions. Thank you! Requirements: - Use of bright and bold color scheme - Include "Services Offered" section - Professional and modern design elements Attached: - Current 3DX Technology resume - Personal career resume for reference - 3DX Technology logos Final deliverable in Microsoft Word format. Ideal skills include: - Graphic design proficiency - Experience with resume design - Strong attention to detai...

Project Overview We require a skilled freelancer with expertise in Microsoft Power Automate to create a specific workflow for processing emails in a shared mailbox and saving attachments to SharePoint. The freelancer must develop the workflow in their own Microsoft 365 tenancy, as access to our tenancy will not be provided. The deliverable includes detailed, step-by-step written instructions in English, accompanied by screen captures, for both creating the workflow and modifying it to use different email addresses and SharePoint folders. The instructions must be clear and to be able to be used by a non-technical user. See the attached document for exact requirements

I need a solution to stream stock price data into Microsoft Excel from a remote server over WebSocket. Essential Data: - Ticker symbol - input subscription - Trade volume - Price change - OHLC (Open, High, Low, Close) - Best bids and offers - Total volume - Open Interest (OI) Ideal Skills and Experience: - Expertise in Excel - Experience with WebSocket integration - Familiarity with financial data and stock market metrics - Proficient in handling real-time data streams - NFR: 2000 messages per second received over websocket...50 concurrent excel users connected over remote websocket, each user subscribed for max 500 symbols Pls refer for more details

I need an expert in Microsoft Dynamics 365 CRM to implement and customize the Sales functionalities, specifically focusing on Lead and Opportunity Management. Key Requirements: - Set up and customize Lead and Opportunity Management features within Dynamics 365 CRM Sales module. -set up forms to work for our organisation - Ensure seamless integration with existing systems. - Provide documentation and training for my team. Ideal Skills and Experience: - Proven experience with Dynamics 365 CRM, particularly in Sales module. - Strong understanding of Lead and Opportunity Management processes. - Excellent customization and integration skills. - Prior experience in training and documentation.

I'm seeking an expert to troubleshoot and fix an outgoing email issue with my Microsoft Exchange on Alibaba Cloud. Requirements: - Experience with Microsoft Exchange Server 2025 - Familiarity with Alibaba Cloud network settings and firewalls - Ability to diagnose and resolve SMTP issues Ideal Skills: - Strong background in email server configuration - Networking knowledge, especially with cloud providers - Problem-solving skills to identify misconfigurations or blockages Please ensure you can verify and rectify any issues with outgoing emails.

I'm looking for someone who has good knowledge in Mathematics and good in using Microsoft Word / Publiser to create a custom set of math quizzes for 5th grade students. The quizzes should be: - Focused on Math: The questions should be exclusively based on Math, covering the topics that are taught to. I will be providing you with the Textbook - Problem-Solving Oriented: I'm looking for a format where the questions are not just multiple choice or fill in the blanks, but require students to solve problems actively. Ideal skills for this project include: - Proficiency in Mathematics: A deep understanding of the 5th grade math curriculum, and an ability to create engaging questions. - Experience in Educational Content Creation: A background in creating educational content, p...

I have an Excel workbook with over 74 worksheets that I created while learning Microsoft Excel, covering topics from basic to moderate level. The sheets include various practice exercises like formulas, functions, formatting, charts, pivot tables, lookups, and more. Right now, the workbook is not well organized. I need someone to help clean it up and arrange it properly so everything flows in a logical order. What Needs to Be Done: • Reorder related sheets like VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDEX-MATCH, etc., into the correct sequence. • Rename sheets where necessary to make them clear and readable. • Redesign the main index sheet with proper hyperlinks and categorize them neatly. • Highlight or mark any empty or duplicate sheets for my review. • ...

I need a branded manual template designed, which includes: - A cover page - Table of contents - Five sections - Reference page - Appendix section Additionally, I need the information for Sections 2 and 3 transferred into a table format. Ideal Skills and Experience: - Microsoft Word - Proficiency in document design and formatting - Experience with creating branded templates - Strong attention to detail, especially with table formatting

...Black, White, Grey tones with a subtle hint of Orange. Reference: Current logo attached. 2. Company Document Templates Objective: Create a cohesive suite of branded templates for both internal and client-facing documentation. Templates Required: - Specification Template - Client Proposal Template - Introductory client presentation - Formal contract proposal - Variation Template - Microsoft Word Templates - Microsoft Excel Templates Design Direction: Consistent with new brand look and feel. Easy to edit and use across the team. Polished and professional in presentation. 3. Company Brochures Objective: Design visually compelling and informative brochures that reflect NUVO Homes’ values and quality of work. Brochures Required: - Company Profile - Client Informatio...

...Adwords account. I need around 2 hours of someone's time to do a meeting [Removed by Freelancer.com Admin] and help me set things up properly. My business focuses on consulting for Microsoft Power Apps, Power Pages, Power Automate, and Power BI. I want to use Google Ads to increase traffic to my website powerappshub.co.uk. I already have a list of keywords, but I need assistance in refining them and setting everything up correctly. I would think that key word might be "power apps consultant", "power pages consulting" etc It would be great if someone has set up a Google Adwords campaign specifically for the Microsoft Power Platform I want the ads to display in the UK and am prepared to pay 200 USD for now and possibly more down the line. Maybe...

I need help to modify my Laravel 8 app, which currently supports Microsoft and Google social logins (Oauth) via socialite. The project requires two main changes: Add Apple Login (OAuth) Support: - The app should be expanded to use the Apple Oauth module. - Integration should ensure keys are auto-updated (refer to Socialite docs). - Guidance on setting up the necessary Apple account for authentication. Implement URL Encoding System: - Develop a simple encoding system to generate encoded keys. - Add an option to force encoding for the connecting app. Ideal Skills and Experience: - Proficient in Laravel, especially Laravel 8. - Experience with OAuth and Socialite. - Familiarity with Apple OAuth integration. - Strong understanding of URL encoding and security practices. Looking for...

I need a Microsoft Word plugin that automates cross-references, specifically for headings and sections. The plugin should update all references live as the document is being drafted. Key Requirements: - Automate cross-reference creation for headings and sections. - Automatically update all references upon document changes. Ideal Skills and Experience: - Experience in developing Microsoft Word plugins. - Proficiency in programming languages like C# or JavaScript. - Familiarity with Word's Object Model and automation. Looking for a freelancer who can deliver a robust and efficient solution. please refer to the clarification board for further functionality

I need a freelancer to help get our utility tool program listed on the Microsoft Store for both Windows 10 and 11. Requirements: - Recent experience with Microsoft Store submissions - Familiarity with utility tools - No special system requirements for our tool Ideal skills and experience: - Microsoft Store deployment - Windows application management - Strong technical documentation skills Please provide a portfolio and relevant experience. must be from India

I need a freelancer to manually enter data from Word documents. Requirements: - Accurately input data from Word documents - Ensure formatting is consistent - Meet deadlines Ideal Skills: - Experience with manual data entry - Proficiency in Microsoft Word - Attention to detail Please provide your experience and estimated completion time.

I need an expert to help get my fully developed software application into the Microsoft Store for both Windows Desktop and UWP platforms. Key Tasks: - Guide my employee on the submission process. - Provide insights and strategies based on recent success. Ideal Skills and Experience: - Proven track record of successfully publishing apps on the Microsoft Store. - In-depth knowledge of both Windows Desktop and UWP requirements. - Strong communication skills for effective guidance.

...below: - SharePoint Search vs Microsoft Search I followed the example in the link above creating the initial user directory with SharePoint search. Natively SharePoint Search does not allow me to identify enabled vs disabled users. This is critical as I need to be able to filter out disabled users. Microsoft Search should be able to provide this data since graph should be able to see the user's status. - Component Size I want to use the "Regular" component size, but by default only Display Name and Title are shown. I need the following fields to be displayed when using "Regular": Display Name, Title, Department, Phone, Email, EmployeeID - EmployeeID This also goes back to Microsoft Search. I

We need four short animated marketing videos (16:9) for our Microsoft Teams-integrated software, C-Suites Scorecards. The videos will promote: Hero Overview – All-in-one platform (Performance, Risk & Compliance) Employees Performance Management Risk Management Compliance Management Each video is 45–60 seconds, based on a completed script and storyboard. We're looking for: Clean, modern animation style AI voiceover synced to script Branded visuals (we provide logo, brand colors) Final exports (MP4) and editable Canva or Powtoon templates These videos will be embedded on our website and promoted via social media. We need high-quality, professional output with fast turnaround.

We are creating a professional Microsoft Excel course titled: "Master Microsoft Excel for Jobs & Real-World Work (2025 Edition)". We already have: A finalized course outline Detailed scripts for each lesson Voiceovers to be added later (or done post-edit if you provide raw versions) Now, we’re looking for a skilled video editor + screen recorder to produce the entire course based on our structure. Scope of Work: 1. Screen Recordings: Record clear, high-resolution videos (1080p minimum) of Excel being used as per our scripts. You must follow the exact steps given — no improvisation unless discussed. 2. Video Editing: Clean cuts, zooms/pan, highlight mouse movement/clicks. Use callouts or on-screen text when needed (like formulas, shortcuts, o...

I need a PowerApp expert to make small changes and integrate it with another system. Key Requirements: - Modify existing PowerApp - Integrate with a custom-built system - Call a custom connection upon order confirmation - Send confirmed order details to an inventory system Ideal Skills and Experience: - Proficiency in Microsoft PowerApps - Experience with system integration - Familiarity with creating and managing custom connections - Strong problem-solving skills Please provide past work and relevant experience.

I have an Excel workbook with over 74 worksheets that I created while learning Microsoft Excel, covering topics from basic to moderate level. The sheets include various practice exercises like formulas, functions, formatting, charts, pivot tables, lookups, and more. Right now, the workbook is not well organized. I need someone to help clean it up and arrange it properly so everything flows in a logical order. What Needs to Be Done: • Reorder related sheets like VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDEX-MATCH, etc., into the correct sequence. • Rename sheets where necessary to make them clear and readable. • Redesign the main index sheet with proper hyperlinks and categorize them neatly. • Highlight or mark any empty or duplicate sheets for my review. • ...

I need a detailed company profile created in a Word Document format. The profile should include: - Company history - Product/Service details - Management team profiles You're free to design it as you like, as I don't have any specific design or branding guidelines to follow. Ideal skills and experience: - Proficiency in Microsoft Word - Strong writing and research skills - Graphic design skills to create an appealing layout

I need 20 existing Canva presentation ...some of the photos and replace with some other photos to be provided some photos in template are of tropical locations and need them to be replaced - photos to be supplied The slides are from USA real estate market I want to convert some of the text where anything legal is mentioned in the slides relating to USA market so it is applicable to Toronto Canada market by using AI Cha GPT or free Microsoft AI by using this prompt; “revise the following text to make it high converting using AIDA formula and Caldini principles of persuasion and relative to the Toronto GTA market and Ontario real estate laws and make no more in length than the original

...Telegram, WhatsApp, and video communication platforms like Zoom and Microsoft Teams. The ideal candidate will be detail-oriented, tech-savvy, and able to work independently to ensure smooth operations and efficient workflow. **Key Responsibilities: - Manage emails, calendars, and appointments - Provide customer support and respond to inquiries - Conduct online research and compile reports - Develop and execute social media strategies across Instagram, TikTok, X, and Facebook - Create, schedule, and optimize content to increase engagement and reach** - Monitor trends, analyze performance metrics, and provide insights for improvement** - Follow up on leads via email, Telegram, WhatsApp, and video calls using Zoom, Microsoft Teams, or similar platforms - Handl...

I need assistance to configure my Windows 10 profile correctly. My profile is booting up differently, and it's missing files and folders. I need to add Photoshop and ILovePDF shortcut icons to my taskbar. Additionally, I want to sync my Gmail with Microsoft Outlook 2010. Ideal Skills and Experience: - Proficiency in Windows 10 - Experience with taskbar customization - Knowledge of Microsoft Outlook 2010 and Gmail integration - Problem-solving skills for profile issues

I need a tool that integrates speech recognition and GPT for task management. Key Requirements: - Convert my speech to text. - Send the converted text to GPT for understanding. - GPT stores the tasks on a chos...and GPT for task management. Key Requirements: - Convert my speech to text. - Send the converted text to GPT for understanding. - GPT stores the tasks on a chosen cloud platform (Google Cloud, AWS, Azure). - Retrieve stored tasks based on my voice requests. - Provide responses in both text and voice formats. Ideal Skills and Experience: - Experience with Speech-to-Text services (Google, IBM, Microsoft). - Familiarity with GPT and task management systems. - Knowledge of cloud storage solutions (Google Cloud, AWS, Azure). - Strong programming skills to integrate these tec...

I need assistance formatting a separation agreement in a Word document. This document is for legal purposes and must adhere to standard legal formatting. Requirements: - Must include: - Division of assets - Child custody arrangements - Spousal support details - Use standard legal format for the document Ideal Skills and Experience: - Proficiency in Microsoft Word - Experience with legal document formatting - Attention to detail and accuracy

I need dedicated individuals to convert Maths and Science books into accessible formats. This involves adding alt text to images and ensuring proper formatting of headings and pointers. Key Responsibilities: - Add accurate and descriptive alt text to images. - Format text, headings, and pointe...Maths and Science books into accessible formats. This involves adding alt text to images and ensuring proper formatting of headings and pointers. Key Responsibilities: - Add accurate and descriptive alt text to images. - Format text, headings, and pointers as per accessibility standards. Ideal Skills: - Proficiency in either or both languages (English and Kannada preferred) - Proficient in Microsoft Word - Experience with accessibility standards This is a contract-based role with payment...

I need assistance in creating a professional Word document for my business plan from my notes. The document should include: - Executive Summary - Market Analysis I also need suggestions on templates. Ideal Skills and Experience: - Proficiency in Microsoft Word - Experience in formatting professional documents - Knowledge of business plan structure, particularly executive summaries and market analyses - Ability to provide template suggestions I have several word and PP documents full of notes that need to be combined into 1 word document.

Hello! I am looking for freelance job opportunities on this platform. I have Skills in: * Data Entry & Typing Work * HTML *CSS *JavaScript *Microsoft Word, Excel, and PDF Conversion I am dedicated, hardworking, and ready to start immediately. I want part time job. I have developed a fully functional E commerce Shopping Mall Website by using html & CSS Simply design .In this Website I have included only two pages : Home and Shop please Support me and given Some small project for Part time Job Mobile Number:9908496393

I'm seeking a reliable personal assistant to help streamline my daily tasks. The ideal candidate will be organized, proactive, and able to manage multiple tasks efficiently. Key Responsibilities: - Administrative tasks: ...seeking a reliable personal assistant to help streamline my daily tasks. The ideal candidate will be organized, proactive, and able to manage multiple tasks efficiently. Key Responsibilities: - Administrative tasks: Organizing documents, managing emails, etc. - Scheduling and calendar management: Arranging appointments and coordinating schedules. Ideal Skills and Experience: - Proficiency in Microsoft Office Suite or Google Workspace - Excellent communication skills, especially via email - Prior experience in a similar role is a plus Looking forward to ...

...(Money) Masa dan Waktu (Time and Duration) Panjang, Jisim dan Isipadu Cecair (Length, Mass, and Volume) Perimeter dan Luas (Perimeter and Area) Data (Data Handling) Format Required: Each question must be clearly numbered (e.g. Soalan 1, Soalan 2…). Provide four multiple-choice options (A, B, C, D) for each question. Highlight the correct answer clearly (e.g. Jawapan: C). Format must be delivered in Microsoft Word or Google Docs....

...Project #2 - Cancer Related Deaths Purpose and Preparation The purpose of this project is to give you experience applying statistical concepts to a real-world scenario. Specifically, you will analyze the relationship between poverty rates and cancer-related death occurrence rates from a supplied data set of over 90% of counties in the United States. Your calculations will be executed in Microsoft Excel, and you will produce a written report that contains your analysis along with graphs, charts, and tables generated in Excel. To prepare for this assignment, you should: ● Download and review the associated Excel file ● Download and review the report template ● Watch the video guide for this project found in the Blackboard content folder. Instructions for Completing thi...

I'm looking for a dedicated personal assistant to help streamline my day-to-day tasks. Key responsibilities include: - Scheduling and calendar management - Email management Ideal skills and experience: - Proficiency in Google Calendar and Microsoft Outlook - Strong organizational and communication skills - Prior experience in a similar role Please communicate primarily via email.

I'm seeking an HR consultant to mentor my team, primarily focusing on: - Attendance management - Task delegation - Performance reporting Requirements include: - 30 mins to 1 hour daily, online via Microsoft Teams - Provide daily reports on attendance and tasks Ideal Skills & Experience: - Entry-level HR experience (0-3 years) - Familiarity with Microsoft Teams - Strong communication and reporting skills This project is for Indian consultants only

I'm seeking an experienced sales consultant to mentor my team. You will need to provide 30 minutes to 1 hour of guidance daily on report, focusing on sales strategy improvement. Communication will be through Microsoft Teams or Google Meet. Key Requirements: - Mentor on sales strategy - 30 mins to 1 hour daily - Provide daily progress reports - Online communication via Microsoft Teams or Google Meet - Indian based professionals only Ideal Skills and Experience: - Proven sales expertise - Strong communication skills - Experience in virtual mentoring

I'm looking for an expert in Microsoft Word to create and design professional documents. The primary focus will be on journals that are to be used as digital downloads, ebooks and physical books. Requirements include: - Proficient in Microsoft Word and LibreOffice - Strong skills in text formatting and styles - Ability to create and incorporate simple images and graphics Ideal Skills and Experience: - Previous experience in document creation and design - Attention to detail and creativity - Ability to meet deadlines and communicate effectively - Required to have knowledge of counselling/therapy/mental health issues. Please provide samples of previous work. Pay per hour is relatively low as approximately 90% of content is supplied.

I need a freelancer to recreate four flowchart imag...to recreate four flowchart images from the attached Word document into fully editable flowcharts within the same document. Key Requirements: - Recreate 4 Flowcharts: Accurately recreate the four flowcharts found in the attached document. - Fully Editable: Use Microsoft Word's native shapes and connectors. The final product should not contain any images. All text, shapes, and lines must be editable. - Match Original: The layout, content, and formatting of the new flowcharts should match the original images. Use the default Microsoft Word styles. - Deliverable: A single .docx file with each of the four editable flowcharts on a separate page. Please refer to the attached Word document for the images of the flowcharts y...

I need an existing Excel spreadsheet document recreated with our branding. The original document's formulas must be preserved and remain functional. The existing template is locked Requirements: - Recreate the spreadsheet in Microsoft Excel - Incorporate our branding elements (logo and colors) - Maintain and ensure all original formulas are intact and ready for use