Site templates quiz site aspnet jobs

I'm in need of a set of modern, cohesive templates that can be used across various platforms and for different communication purposes. These templates will be crucial for a consistent and professional customer communication strategy. Key elements of the project include: - A modern, minimalist style for all templates - A window sign template for properties that are for lease or available - An e-blast template - A report template suitable for leasing reports, project recaps, or e-blasts - A social media post template specifically designed for LinkedIn The e-blast and report templates should prominently feature: - Property details - Market statistics - Demographics - Other retailers in the market - Performance trends Ideal skills for this job include graphi...

I need a web design expert that can set up a very fast theme. For example Hello Elementor. I have a mockup to start from. You design the frame work. I am adding all the content such as text, pictures, testimonals and doing some minor adjustments. After that you are doing the responsive work and making it lightning fast. And doing the basic SEO work.

I'm looking for a professional web developer to create an E-commerce website dedicated to selling my own music tracks for corporate events. This platform should not only facilitate purchases but also allow for user accounts that offer extra features beyond guest checkout. Key Requirements: - Creation of an intuitive, user-friendly E-commerce interface. - Development of a secure, efficient system for user account creation and management. - Integration of features that enhance the user experience beyond simple purchasing and order tracking. The ideal freelancer for this project would be someone with extensive experience in E-commerce web development, a strong understanding of creating engaging, interactive user features, and a knack for developing secure, reliable systems. Prior exper...

These days a freelancer wanted to create a custom caching plugin for my site, but all he did was tamper with it completely. Now the site only shows up fine if I am logged in. There so o various problems: 1. the home page from non-logged in is banged up (photo 1) 2. The settings to block spam comments no longer work (the freelancer had made changes to Akismest, but they seem to be gone - photo 2) 3. The last published articles show up only if I am logged in, and if I am not logged in they show up after a long time

...our current design theme and color scheme, which is the same as our existing site colors. The primary purpose of these OG images will be promotional, so they should be visually appealing and designed with our branding in mind. The ideal candidate for this project should have: - Experience in graphic design, particularly in creating web templates - A keen eye for detail to match our existing design theme - Understanding of the purpose of OG images and how to design them for promotional use - Ability to deliver the source files at handover I will provide the necessary access to the site and any additional information needed to ensure the project is a success. The final deliverable should be a set of OG image templates that can be easily customised for differe...

We need to create an interactive mini-game within our WordPress site that users can participate in. Specifically, we would like to give users the ability to toss coins into a monumental water fountain. The animation should include the ability to choose throwing power and direction. Once the user hits the target, a feedback overlay will appear with congratulations, graphics of the city of Rome, and the option to enter a Name and Custom Message. After entering their name and custom text, users will be able to share their graphic feedback via WhatsApp or email. The effect is to create a personalized postcard with their name and inserted message. To participate in this mini-game, users will need to make a small tip that will be collected through PayPal or Stripe. We plan to allow don...

I'm looking for a graphic designer to create a series of promotional templates for my Instagram account. Ideal Skills: - Proficiency in graphic design software - Experience in creating social media templates - Strong understanding of Instagram's design standards and trends - Ability to create visually appealing, brand-consistent designs.

Digital Products Template Design: PowerPoint templates, Canva, or graphic design for social media. Ebook: Guidebook, tips, or tutorials in a specific field (for example digital marketing, health, or hobbies). Editing Presets: Presets for Adobe Lightroom or filters for video applications like Premiere Pro. Fonts and Illustrations: Custom fonts or illustrations created by yourself.

I'm embarking on a new business venture and need assistance in creating the entire brand. This includes: - A modern, minimalist logo - Comprehensive branding guidelines - Templates for documents In addition, I require a clear, interactive website with approximately three tabs. The site needs to have a booking timeslot system and support for both English and Polish. Key features of the website include: - A contact form & booking - Service descriptions - Client testimonials Based on the work-for-hire agreement, the drafts are ideally shared so that I can edit them later if needed. I'm looking only for an estimate of the total costs for this project, not the actual contractor yet.

...range of media formats, including the most common document types (PDFs, Word docs), images (JPEG, PNG), as well as audio and video files (MP3, MP4). - Student Management: Course Administrator login to create students and grant course access. Also to monitor each student's progress within the course. - Progress Tracking: The platform must keep track of completed slides/modules, progress percentages, quiz/assessment scores, and student time spent active (clicking between content). - Student Interface: A user-friendly front end for students to log on to their course and track their progress. This stored progress should be accessible for administrators. - Future Development: The platform should be designed with the potential for further development. Ideal Skills and Experience:...

Design a complete branding package: Business Cards: Double-sided layout with name, title, contact info, and branding. Letterhead: Clean, professional template, Word/PDF-compatible. Email Signature: Visual, professional, includes name, title, contact, logo. Envelopes: Branded designs for C4, C5, DL sizes. Social Media Kit: Profile pictures, banners, post templates. Extras: Invoice template, logo stickers/labels.

I operate an E-commerce website which needs immediate assistance. I've verified it with Google Search Console, but I've identified several pages that are currently not indexed. - Your task will be to diagnose the indexing issues and implement fixes to ensure all pages of my site can be indexed by Google. - Ideally, you're experienced with SEO, Google Search Console, and E-commerce platforms. - A history of successful website indexing projects will be highly regarded. Prompt resolution of this issue is crucial for my site’s visibility and sales potential. Please provide a timeline and an outline of your process with your bid.

I'm in need of bespoke templates for a couple magazine with a romantic and elegant theme. The templates should cater for sections including featured stories and photo galleries.

I'm looking for a talented designer to create hundreds or thousands of Canva templates for me. The templates should primarily be for social media posts on Instagram, with a focus on the following: - Professional quality, suitable for a formal presentation - Creative designs that fit a range of themed posts Ideal candidates for this project would be proficient with Canva, have a strong understanding of Instagram's aesthetics, and be able to produce high-quality, engaging templates in bulk. Experience in creating social media content and a portfolio demonstrating your skills would be highly advantageous.

...portfolio site for me. The site should be visually striking and embody a creative aesthetic while still being user-friendly and easy to navigate. Key Sections: - About Me: This section will need to succinctly communicate my professional background, skills, and personal story in an engaging way. - Project Gallery: I need a visually appealing and easy-to-navigate gallery to showcase my work. This will require an understanding of visual layout and design principles. - Testimonials: A section for client and colleague endorsements. This will require a design that highlights this content without overshadowing the rest of the site. Ideal Skills: - Web Design: Proven experience designing portfolio sites is a plus. - Creative Thinking: Ability to think outside the box and...

I need assistance in removing a persistent popup from my Wix site. Despite my efforts, I couldn't locate the source of the widget in the backend editor. Key Requirements: - Expert in Wix website management - Proficient in identifying and removing unwanted code or widgets - Ability to work swiftly and efficiently The popup contains text and images, and its removal is urgent. I am not certain whether it was added through a third-party app or custom code, so a comprehensive understanding of both would be advantageous. Please bid only if you are confident in your ability to resolve this issue quickly.

I need my current WordPress site deleted and rebuilt as a basic landing page. This landing page should simply state 'New website coming soon' along with some simple text and links. Key Requirements: - Retain my phone number and contact form on the new landing page. - Incorporate my company logo, social media links, and some images or graphics onto the page. Ideal Skills and Experience: - Proficiency in WordPress - Strong understanding of basic web design principles - Experience with integrating contact forms and social media links on web pages - Ability to effectively utilize images and graphics for web design

I'm in need of a skilled developer to create an extension for PerfexCRM that includes: - New Reporting Tools: These tools should be able to provide comprehensive insights on various aspects of the business. - Customizable Templates: Specifically, I need the extension to include customizable proposal templates. - Integration with Other Systems: The extension should be able to seamlessly connect with other systems we use.

I'm looking for a skilled WordPress Developer to help finalize my real estate website. Your main tasks will involve embedding iframe HTML for an MLS search and enhancing the UI across approximately 12 pages. This includes improving alignment, spacing, and overall user experience. Code snippets for each page and the site logo will be provided in a Google Doc. Responsibilities: - Embed iframe HTML code into designated pages. - Refine page alignment, spacing, and other UI elements to ensure a consistent and polished look. - Utilize Elementor and WP Forms for page enhancements and form integration. - Collaborate to ensure the website meets design and functionality expectations. Requirements: - Proven experience with WordPress, Elementor, and WP Forms. - Proficiency in HTML, CSS, ...

My WordPress site uses TranslatePress and the DeepL API for multilingual support, but I'm experiencing significant translation issues. Nearly all content, including text within pages, menu items, and widgets, is only partially translated. - Content Types: The issue affects both static and dynamically generated text. - Areas of Concern: Translation problems span across all areas of my site, from the homepage to blog posts and services pages. I'm seeking a WordPress expert with experience in troubleshooting TranslatePress and DeepL API issues to ensure my site is fully bilingual.

Description: I am looking for a reliable and detail-oriented virtual job assistant to help me apply for data engineer jobs on various job portals. Responsibilities: Review and understand job descriptions to tailor applications. Use my resume and cover letter templates to apply for relevant jobs.

please clean up code in charity online raffle both in version 1 and version 2 and do all the requirements for the different provinces. Clean code milestone 1 $200 Login / Register / forgot password Raffle List Active / Raffle List Close milestone 2 $300 charity dashboard Staff dashboard Worker dashboard milestones 3 $200 Order t...clean up code in charity online raffle both in version 1 and version 2 and do all the requirements for the different provinces. Clean code milestone 1 $200 Login / Register / forgot password Raffle List Active / Raffle List Close milestone 2 $300 charity dashboard Staff dashboard Worker dashboard milestones 3 $200 Order ticket Payment gateway cleanup Order list in all dashboard Email templates clean up code please create one of milestone i ...

I need professional to help me finish my INTERIOR DESIGN website. The tasks involve some design and layout adjustments, as well as functionality improvements. In addition to this, I also need SEO optimization for the site, and comprehensive social media management and posting for my Facebook, Instagram, and Pinterest accounts. Ideal skills and experience for the job include: - Expertise in e-commerce website design and development - Proficiency in SEO strategies with guaranteed high ranking - Proven track record in social media marketing - Familiarity with Facebook, Instagram, and Pinterest marketing strategies - Skills in making design and functionality improvements on websites

I need my current Wordpress site, which has between 1-5 pages, converted to an HTML site. The main reason for this transition is to make the site easier to maintain. Key Requirements: - Convert a 1-5 page WordPress site to HTML - Retain the functionality of the contact form in the HTML version Ideal Skills: - Proficiency in HTML and WordPress - Experience in website conversion - Ability to implement and retain dynamic functionalities

...stripe, PayPal Key Requirements: 1. Optimized Shopify Theme 2. Custom Logo 3. Professional Clean Design 4. Custom Banners / Images 5. Custom Coding To Improve User Experience 6. 4 Content Page Templates 7. 20 Test Products Uploaded 8. Mobile Responsive Design 9. Expert App Installation 10. Site Map Creation & Submission 11. Google Shopping Data Feed Creation 12. Analytics With Conversion Tracking 13. Webmaster Tools Account Setup 14. Custom Banners / Images 15. Custom Coding To Increase Conversions 16. 4 Content Page Templates 17. 20 Test Products Uploaded 18. Analytics With Conversion Tracking 19. Site Map Creation & Submission 20. Google Shopping Data Feed Creation 21. Mobile Responsive Design 22. Expert App Installation The custom coding should ...

We need a developer to build a web-based 3D PDF conversion platform that converts .dwg, .dxf, and .obj files into interactive 3D PDFs viewable in Adobe Acrobat Pro. The Frontend will integrate with WordPress, using a membership plugin (e.g., MemberPress) to manage access levels. Users must be able to upload files, select from customizable templates, and download branded 3D PDFs supporting zoom, rotate, and pan. Security is paramount, with files processed via HTTPS and deleted afterward. We want a white-labeled solution, removing any third-party branding. Experience with Python, CAD parsing, and PDF generation is essential. Key Requirements: - Development of an API for 2D and 3D PDF conversions (Python) - Conversion of DXF, DWG, and OBJ files -Python Installs: EZDXF, ODA, Trimesh, ...

...stripe, PayPal Key Requirements: 1. Optimized Shopify Theme 2. Custom Logo 3. Professional Clean Design 4. Custom Banners / Images 5. Custom Coding To Improve User Experience 6. 4 Content Page Templates 7. 20 Test Products Uploaded 8. Mobile Responsive Design 9. Expert App Installation 10. Site Map Creation & Submission 11. Google Shopping Data Feed Creation 12. Analytics With Conversion Tracking 13. Webmaster Tools Account Setup 14. Custom Banners / Images 15. Custom Coding To Increase Conversions 16. 4 Content Page Templates 17. 20 Test Products Uploaded 18. Analytics With Conversion Tracking 19. Site Map Creation & Submission 20. Google Shopping Data Feed Creation 21. Mobile Responsive Design 22. Expert App Installation The custom coding should ...

I'm seeking a proficient web developer and designer to create a website with functionality mirroring https://www.escort-ireland.com. The project entails maintaining a similar aesthetic while integrating unique design elements to create a distinctive site. Key Requirements: - Complete replication of all features from the reference site. - Integration of a secure and efficient token-based payment system. - Creation of a visually similar yet unique design to avoid copyright infringement. - Development of the site to accommodate various user roles: Visitor, Member, and Admin. - Meticulous attention to detail to ensure accurate feature replication. Skills & Experience Needed: - Advanced proficiency in web design and development. - Prior experience with creating ...

I'm looking for a skilled web developer proficient in HTML, CSS, JavaScript, Node.js, and MongoDB. The primary goal is to create a website centered around movies, series, and other related content. Key Requirements: - Expertise in front-end technologies (HTML, CSS, JavaScript). - Proficiency in back-end development with Node.js. - Experience with database management using MongoDB. - Ability to create a user-friendly, engaging web interface. Skills and Experience: - Previous work on entertainment or content-centric websites is a plus. - Strong understanding of web development best practices. - Excellent problem-solving skills and attention to detail. - Ability to work independently and meet deadlines.

I'm looking for a skilled data scraper to extract product details from a secure website. The data to be scraped includes: - Product name and price - Product description - Product specifications Ideal skills for this project include: - Proficiency in web scraping tools and techniques - Experience in handling secure sites - Strong understanding of JSON Please note, the primary focus of this project is on text content related to product details. Experience in scraping similar data will be an advantage.

I'm looking for a web developer to create an interactive app that generates personalized biographies using AI. Key Features: - Customizable Templates: Users should be able to tweak templates to fit their needs. - AI-Generated Suggestions: The app should provide intelligent suggestions to enhance the biography. - Photo Upload Capability: Users need the option to upload photos for inclusion in their biography. User Authentication: The app should have a simple and secure email and password authentication system. Ideal Skills: - Proficiency in web development languages (HTML, CSS, JavaScript, etc.) - Experience with AI integration in web apps. - Skills in designing user-friendly interfaces. - Knowledge in implementing secure authentication systems. Please provide exam...

I'm in need of a planning application drawing, specifically a detailed site plan. This should include: - An intermediate level of detail, encompassing landscape elements but not requiring comprehensive utilities and topographical information. - Specific landscape details, particularly fencing and boundaries. Ideal candidates for this project should have experience with site planning and landscape design, with a strong understanding of planning application requirements. Please include examples of similar projects in your proposal.

I'm seeking a developer to implement a single image upload functionality to my portfolio website. The upload option will be used for the addition of new images to the site. Ideal Skills: - Proficient in web development - Experienced with portfolio website enhancements - Skilled in implementing image upload features

I need a freelancer to create a Valentine’s Day product category on my Ecwid site. This category will exclusively feature physical must be OK with working with pleasure products, adult products. Key requirements for this project: - Add Valentine’s Day themed product category. Description about this category: “Spice up your Valentine’s Day with our exclusive, handpicked collection of must-have pleasure products – because love deserves a little extra glow-up this year!” -clean up the 'Featured Products' section on homepage: - Experience with Ecwid is essential, as is a clear understanding of e-commerce best practices. - Ability to create an engaging and user-friendly product category page. - Skills in e-commerce and product categoriz...

I need a classic and timeless logo, designed in warm colors, to form the cornerstone of my branding identity. This project specifically focuses on logo design, with potential for future work on business card design and social media templates. Ideal candidates for this project should have: - Proven experience in logo design with a classic and timeless aesthetic - A strong portfolio showcasing modern and minimalistic designs - Exceptional understanding and use of warm color palettes - Ability to create designs suitable for various brand touchpoints Freelancers with experience in minimalistic design are encouraged to apply, as I am looking for a logo that balances simplicity with classic elegance.

...experienced ecommerce developer to create a comprehensive online platform for my diagnostics lab. The website should cater to a wide range of services, including standard medical tests, specialized diagnostic packages, and home visit services. Key Features: - User Account Creation and Login: The site should allow users to create personal accounts to track their tests and bookings. - Online Payment Gateway: A secure and efficient online payment system is a must. - Appointment Scheduling System: The site should have a reliable system for scheduling appointments for tests. Ideal Skills and Experience: - Prior experience in developing ecommerce websites, particularly in the healthcare sector, will be highly regarded. - Proficiency in integrating secure payment gateways. - Kn...

I'm seeking a professional with extensive WordPress and LMS development experience to create a dynamic learning platform for academic courses. This site should cater primarily to students and administrators, with the potential for future user role expansion to include instructors. Key Requirements: - The LMS will need to incorporate a variety of key features, including: - Comprehensive quiz and assessment tools - Course tracking capabilities to monitor student progress and engagement - A certification system for course completion and competence verification Ideal Skills and Experience: - Proven track record in WordPress and LMS development - Experience in creating academic-focused e-learning platforms - Proficiency in implementing interactive and assessment tools...

I'm looking for a professional website designer who can create an engaging, user-friendly, and efficient e-commerce site on Shopify. Key Requirements: - Experience with designing Shopify e-commerce sites is a must. - Ability to integrate key features such as Product reviews, Live chat support, and Email marketing integration. Ideal Skills: - Proficient in UX/UI design principles. - Good understanding of e-commerce and Shopify functionalities. - Excellent communication skills for discussing design concepts and revisions.

Attached is a list of easy upgrades I need to have done to my site once these tasks are complete, I will need someone for ongoing work. Please be able to quote a flat rate, and turn around time for this project. Things I need from a dev. Forms Experience Development Some Design talent WP technical experience to help speed issues. Desktop is fast. Mobile is not. I believe removing the live chat which is an item on this project will help speed a little. but desktop speed 85-92 and mobile around 50. I am looking for someone that actually cares about the success of their clients. I need a ton of work done, and want someone that has a passion to do a good job. I also want someone from USA or Europe. No middle east because conversations and language barriers

I'm seeking a WordPress expert for a comprehensive redesign of my website. The primary goal is to modernize its overall aesthetic to align with a corporate and professional style. Key Focus Areas: - Navigation Menu: The current menu is not intuitive enough. I want a streamlined, user-friendly navigation system. - Typography and Colors: A fresh, corporate-friendly font and color palette is needed to enhance readability and maintain visual consistency. - Image and Media Layout: The placement of images and media needs to be optimized for a cleaner, more organized look. The ideal candidate will have: - Extensive experience with WordPress design and development - A strong understanding of corporate design principles - Exceptional skills in typography and color selection - A track record ...

I'm seeking a skilled Shopify developer to revamp and optimize our eCommerce platform, focusing on user experience, seamless integration, and modern functionality. The goal is to create a user-friendly, responsive, and visually appealing online store that promotes a superior shopping experience. Scope of Work: Home Page: Implement a clickable banner that redirects to specified collections or products without the need for a separate button. Integrate a live Instagram feed that links directly to our official account, showcasing real-time updates and promotions. Feature a customer reviews section to highlight positive feedback and testimonials. Membership : Customize the 'Earn Coins' missions to actively engage and incentivize users. Develop a VIP ranking system with exc...

...Block Types**: The plugin needs to support various custom block types. This includes pre-designed templates, interactive elements, and custom code blocks. The ability to seamlessly integrate these into the WordPress editor is crucial. - **Media Integration**: Media plays a significant role in my content. Therefore, the plugin should enable effective media integration. This encompasses image galleries, video embedding, and audio players. Ideal Skills: - Proven experience in WordPress plugin development. - Proficiency in JavaScript, PHP, HTML5, and CSS3. - Familiarity with creating custom block types and media integration in WordPress. - Experience with interactive elements and pre-designed templates. The successful candidate will deliver a plugin that not only meets these...

AI Tool Development Using Canva API Project overview: Seeking an experienced AI engineer to develop tools for manipulating design elements via Canva API. Requirements: - AI development focusing on integration with Canva API. - Tools should allow customization of colors, font sizes, logo images, and main pictures. - Utilize predefined templates for design parameters modifications. -------------------------------------- 1. Understanding the current operation and its issues (a) Current work content We recognize that the current workflow for banner production is roughly as follows. 1). Prepare product images, product descriptions, catchy copy, brand logo, etc. for the product for which you want to create a banner 2). Select a Canva template that matches the product image from a li...

I'm seeking a skilled artist to create a detailed pencil or pen rendering of a greenhouse on a wooded site. Key Requirements: - The primary focus of the rendering will be the overall layout and ambiance of the greenhouse within its wooded surroundings. - The style of the rendering should be realistic, not sketchy or abstract. - The rendering should include a ground-level view perspective. Ideal Skills: - Proficiency in pencil or pen techniques. - Experience in creating realistic architectural renderings. - Ability to depict the integration of structures with their environments. I look forward to seeing how you can capture the beauty and serenity of this setting.

We are seeking an experienced WordPress developer to update and restyle our website. Our website specializes in showcasing and selling Indian handcrafted products, home décor, and showpieces, primarily targeting international markets (US, UK, Canada, and Australia). Scope of Work: Website Restyling: - Modernize the design to make it more visually appealing and user-friendly. - Implement a clean, professional layout that highlights our products and brand identity. - Optimize for both desktop and mobile users. Feature Updates: - Enhance product listing pages for better navigation and visual appeal. Additional Suggestions: - Open to any creative ideas that align with the brand's goals and audience. Requirements: - Proven experience in WordPress development and customization....

I need help upgrading and installing Indexhibit on my site. I have a domain and hosting set up, but I haven't downloaded the CMS files yet and need assistance doing so. I'm also open to suggestions for themes or templates, as I don't have any specific ones in mind. Key Requirements: - Assistance with downloading Indexhibit CMS files - Installation of Indexhibit on my site - Suggestions for suitable themes/templates Ideal Skills: - Previous experience with Indexhibit - Web development skills - Knowledge of Indexhibit themes/templates

Looking to design 2 pages first to get an idea about the website and then possibly add more pages but for the moment 2. 1. Landing page/Home page 2. Result listing page Home page will me the main page, will include search/quote feature where cust...reviews, price per kilo and total price , courier delivery service / door to door or door to depot Show next available collection date Insurance goods or not . Minimum collection weight Some of this would be nice to have a design with an icon next to our something I have also attached logo and business name Also refer to for example of idea of our courier comparison site For the result page we will provide more information once home page done as prefer to start with one and if happy we continue to next page.

...asked to fix Github errors. App Details: - Profile Picture: Users should be able to upload a profile picture. - Bio/Description: Each profile should have a section for a brief bio or description about the user. - Contact Details: Users should have a space to include their demographic and personal data. - Artist Magnet will provide PDF design templates that the Coder will need to turn into figmas and share with the Developer. - Some of the design templates will need to be derived from the current web app and turned into figmas by the Coder before being implemented onto the respective apps. Required Skills: - Proficient in Flutter - Proficient in iOS and Android app development - Prior experience in developing social networking apps - Strong understanding of user interface...

I'm looking for a skilled developer to build a single vendor eCommerce website using Laravel. The site will sell physical goods and needs to include a quick commerce (q-commerce) checkout process. Key Features: - The website should have a seamless q-commerce checkout process to ensure fast delivery of goods. - Integration of multiple payment methods including Credit/Debit Card, Bank Transfer, and Razorpay gateway. - Implementation of Delhivery for all shipping needs. Ideal Skills: - Extensive experience with Laravel framework. - Proficiency in eCommerce website development. - Familiarity with q-commerce and its integration in web platforms. - Knowledge of integrating multiple payment gateways and shipping services. This project requires a professional who can ensure the webs...

Excel Data Cleaning...and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validation rules. Excel Reports: Generating comprehensive and structured reports for decision-making. Financial Modeling: Creating models for budgeting, forecasting, and performance tracking. Excel Templates: Designing reusable templates for recurring tasks. Data Consolidation: Combining data from multiple sheets or workbooks. Excel Integration: Connecting Excel with other tools or databases for seamless workflows. What-If Analysis: Using tools like Scenario Manager and Goal Seek for scenario planning. Error Troubleshooting: Identifying and fixing formula errors or inconsi...