Zillow query bid işler

Yilmaz bey merhaba, bi custom made software a ihtiyacimiz var, foreclosure olan (haciz giden) ve yerel evlerin listelendiği bi siteden -- datayı alarak Zillow platformunu da kullanarak (online emlak marketplace) bize hızlı, karsilastirmali, refine edilmis içerken sunacak bi web application. Umuyorum siz yardimci olabilirisiniz.

...projeden beklenen fayda uzun vadede Prolog kullanılarak yazılabilecek olan dönüşümlerin sınıf modelleri üzerinde doğrudan çalışabilmesinin sağlanmasıdır. Projenin gereksinimlerin belirlenmesi aşamasında standartlar dairesinde üretilen hayali bir bilgi tabanına yöneltilebilecek sorgular (query) üzerinde durulmalı ve tasarım bu saptanan gereksinimlere yönelik olarak yapılmalıdır. · UML sınıf modelini içeren bir bilgi tabanına transformasyon amaçlı (veya benzer başka amaçlı) yöneltilebilecek sorgular (query) nelerdir? · Bu sorgulara cevap verebilecek Prolog önerme/kural modelleri nasıl olmalıdır? Prolog: Bu proje için temel Prolog bilgisi gerekmektedir. Prolog...

4-5 sayfalık bir restaurant websitesi; sadece html ve css kullanarak yapılmasına ihtiyacım var, javascript, query gibi seyler kullanmadan.

Hello there, On Mongodb, a filtering query will be printed using aggregate. You'll certainly be giving details of mongodb function while not reaching the expert friends on mongodb aggregate queries to be printed without sacrificing performance by using aggregate.

Linux PHP  Php, Smarty php, Mysqli bilenlere... Php ile yapılmış, Smarty Php kullanılmış, Mysqli alt yapılı , Scripte eklemeler yapılacak, Yarıda kalan bir script. Bozmadan karıştırmadan kodlar & Veri tabanı üzerinden devam edecek. Özel den detaylar verilecek, Uygun görülen kişilere geri dönüş sağlayacağım (Yoğunluk tan dolayı geri dönüşler gecikebilir, HTML Şablonu hazırlamışım .

Merhaba, Daha önce burdan baya proje konusu açtığım oldu ama amaca ulaşamadım, Amaca ulaşamama sebebi bilemedim hani teklif veriyorda seçiyorum bak diyorum verdiğiniz ücrette son kararınız mı evet diyor adam sonra nedense yapmıyor İngilizce dilim olaydı bak yabancılar hemende nasıl yapar, Türk insanımız sağolsun. Kısaca başka bir projeye yöneldim. Hemen isteğimi belirteyim. Bir sorgulama sitesi olacak şimdi Adresini inceleyiniz site sorgulama uzerine kurulmus fatura, isimden numara numaradan isim gibi v.b , site sadece yönlendirme yaparak link vererek hizmet vermektedir. benim istediğim bunların bot ile örneğin elektrik borcunu varsayın tedaş kurumundan botla veriler çekilerek sorgulanması sağlanacaktır herhangi bir yönlendirme olm...

Only those who speak turkish language, bid it. Merhaba , Kısa tutuyorum. Daha önce işi 5-6 yazılımcı aldı, Hiçbiri de zora gelemeyip kaçtı kimisi iade etti kimisi dolandırdı kaçtı, istediğim başka bir sitenin aynısını yaptırmak site mobil chat üzerine dir, baya detaylıdır admin paneli zahmetlidir, PHP Konusun da uzman kişiler teklif versin lütfen daha önce zor işler yapanlar versin teklif referansı olmayan hiç teklif vermesin , PHP de uzman arkadaşların tekliflerini bekliyorum. demo adresi de sunacağım görüntüler de de var , detaylarıda özel den anlatacağım.

Only those who speak turkish language, bid it. Merhaba , Kısa tutuyorum. Daha önce işi 5-6 yazılımcı aldı, Hiçbiri de zora gelemeyip kaçtı kimisi iade etti kimisi dolandırdı kaçtı, istediğim başka bir sitenin aynısını yaptırmak site mobil chat üzerine dir, baya detaylıdır admin paneli zahmetlidir, PHP Konusun da uzman kişiler teklif versin lütfen daha önce zor işler yapanlar versin teklif referansı olmayan hiç teklif vermesin , PHP de uzman arkadaşların tekliflerini bekliyorum. demo adresi de sunacağım görüntüler de de var , detaylarıda özel den anlatacağım.

Merhaba arkadaşlar öncelikle firma rehberi teması yaptırmak istiyorum. Temada Üye profili, Firma Ekleme, Ürün Ekleme, Mağaza oluşturma ve Giriş sayfası örneğin anlık iletileri sayfaya query ile anlık olarak göstermesi örneğin facebook anasayfası gibi.

1 web sayfalarımız wordpress de yer almaktadır, mysql veri tabanında toplanmış bilgilerin burada grafiğe dökülmesi (highcharts...2 chart örnek yeterli olacaktır, mysql de herhangi bir table dan data okuyan ve WP de bunu aktif olarak gösterebilen herhangi bir chart örneği bize yetecektir, highcharts bizim tercihimizdir. 2- Twitter API lerini kullanılarak twitter datasının mysql e yazılması a. Burada tercihimiz Python dili, burada iki örneğe ihtiyacımız var, stream api den real time data nın store edilmesi, ya da anlık query ler ile bilginin DB ye kaydedilmesi ni içerecek 2 örnek bize yetecektir, sequrity (sql injection vs) konularında günün standartlarında çözümlere ihtiyacımız var, net de bulduğumuz örnekl...

hello amazon sp installation do you have apibilgi When we query with asin, can we retrieve information about the products? Example: B01234345 brand, sales, ranking, seller, number of offers etc. information

We have a Larav...are: Airbnb Zillow Our application currently has approximately 20 screens and includes payment processing through our own custom gateway. QUALIFICATIONS Minimum 4 Years experience with Mobile App development, with at 2 years of experience with Flutter framework Provide at least THREE (3) live and working Mobile Apps that you have developed using Flutter or React Native Strong familiarity with both iOS and Android development environments, SDKs. Previous experience implementing user authentication systems. Experience with in-app purchases and familiarity with respective policies of Apple and Google Play. Scope of Work: CHECK EXISTING PWA PROJECT CODE WORD To ensure you have read this document full, please include the word ‘AFTERNOON’ with your b...

Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.

*** Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server managem...

Necesito alguien que puede dar un curso de power Bi en 10 sesiones en total 15 horas por sesion es de 1 hora y media, 2 sesiones por semana martes y jueves de 4 a 5:30 de la tarde hora Guatemala. Empezando 23 de abril y terminando 23 de mayo. Alrededor de 15 personas, las sesiones son por google meet. Temas a impartir. Editor de consultas de Power BI Extracción de datos: Extracción vs Direct Query Conectar datos alojados en diferentes orígenes Enlazar datos desde la consulta Entorno de trabajo para modelar con Power BI Introducción al modelado tabular con Power BI Tablas y relaciones Power BI – Modelos de datos Iniciación a DAX Fundamentos DAX 1. DAX en la práctica 2. Columnas calculadas y medidas 3. Tablas Calculadas ...

Hi, I need many rewrites. The first batch is of 200 articles. I will ask for a 100 -150 word sample rewrite on the topic given by me. (Removed by Freelancer) Interested candidates, please bid. Long-term work for the right candidate. We will hire multiple writers. Regards, B

I am in need of a seasoned professional who can expertly craft a compelling and persuasive business proposal for a government bid, pertaining to the Information Technology sector. Your task will be to develop a detailed and comprehensive proposal incorporating the following components: - Executive Summary: A concise, high-level overview of our company and its objectives viable for the bid. - Details of the Proposed Solution: An in-depth explanation of our IT solution designed for government application. - Company's Qualifications: A snapshot of our credentials, relevant experience, and metrics denoting our competency in IT. Ideal freelancers for this project should: - Have extensive experience in writing successful business proposals, specifically for government bids....

I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...

I need a professional to list for rent my 2-bedroom, 2-bathroom condo in Long Beach, CA on Zillow. This includes: - Property Advertising: Increase property visibility to attract potential tenants. Create compelling listings complete with high-res photographs and detailed descriptions. - Tenant Screening: Review interested parties, check references, and conduct background checks to find reliable tenants. I'm seeking someone with experience in property management and familiarity with local rental laws. Knowledge of property advertising platforms is necessary, along with strong communication and decision-making skills.

...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The complet...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the y...

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

I am ...view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

I want someone to scrape me all listings on this website: Please find attaced for data format. Thanks, Abhiram

I want someone to scrape me all listings on this website: Please find attaced for data format. Thanks, Abhiram

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

Daily tasks 5 days a week and possible on call if major issue Must understand linux, iptables, networking vpn, hosting, cpanel, plesk, website building, maintenance tasks, ideally python and php al round experience Must be able to work efficiently and be able to act on issues quickly and fix issues before they come a bigger issue. Eyes open at all times. Let me know what you can do and best price you can work for. in your bud proposal. Auto bids will be ignored

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...

... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...

...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers

...as peer the dashboard screen provided in figma file. The dashboard and others menus must be created in dynamic way as its menus items and widget in dashboards are different according with the user profile. - Menus and Submenus: The SaaS web app has about 18 screens that allow user to interact with some operations like add a new financial product, query data in tables or grids, update and delete data. All this screen must have filters for query and pagination capabilities. - Data Analytics and Reporting: It's essential that the platform has the capability to collect and analyze data, and present these insights in a user-friendly manner. Further details: - The design of the application should be sleek, intuitive, and responsive and must follow the figma design that...

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermediate-level ElasticSearch querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV...

...improvements to my existing Laravel application. The selected freelancer will be responsible for: - Backend Development: Your skills should allow you to work efficiently on my application's backend, ensuring all new integrations are seamless. - Database Optimization: I am specifically looking for you to boost the performance of my existing application by optimizing the database, which includes indexing, query optimization, and normalization wherever necessary. - API Integration: Your experience integrating APIs will be crucial, as a key part of this project will involve utilizing various APIs to extend the functionality of the application. - User Interface Improvement: The right candidate will not solely focus on the technical side, they must also be able to make necessa...

We're developing a scanner app coupled with an query response system. Seeking a Flutter expert with Django knowledge for UI and backend development, respectively. The ideal candidate will excel in Flutter UI design and possess the skills to manage data storage in Django backend, along with handling API integrations seamlessly.

Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other