Property excel jobs
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous ...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I'm in need of an experienced architect or interior designer who can create a detailed renovation plan for my old waterfront home in Annapolis, Maryland. The property has gotten into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, which stands at 1300 sq ft, requires a full overhaul to bring it up to modern standards. This includes but is not limited to, flooring, walls, ceilings, and fixtures. - Exterior Painting: The exterior of the house will need a fresh coat of paint to restore it to its former glory and protect it against the elements. - Kitchen Renovation: A complete modernization of the kitchen is necessary to make the s...
App is completed but in that there is some issue regarding Zegocloud's library. I want only freelancer who can solve this issue. No company will be entertained. this is my code which show the error of : can not read property 'getPluginType' of null import {StyleSheet, Text, View} from 'react-native'; import React, {useContext, useRef} from 'react'; import ZegoUIKitPrebuiltLiveStreaming, { HOST_DEFAULT_CONFIG, ZegoMenuBarButtonName, } from '@zegocloud/zego-uikit-prebuilt-live-streaming-rn'; import ZIM from 'zego-zim-react-native'; import {useNavigation, useRoute} from '@react-navigation/native'; import BackButtonHandler from '../BackButtonHandler/BackButtonHandler'; import KeyCenter from '../../uti...
I'm looking for a professional to create detailed plans for the electrical, plumbing, and HVAC systems of my property. - Electrical Plan: I'm interested in incorporating energy-efficient lighting into my home. The plan should focus on maximizing energy savings while providing adequate lighting for all spaces. Additionally, I would like to include outdoor lighting in the plan. - Plumbing Plan: For the plumbing, I'm looking for a design that features dual-flush toilets and a hot water recirculation system. I'm particularly concerned about water efficiency and comfort, so I would appreciate a design that reflects these priorities. As a freelancer, you should have a strong background in electrical, plumbing, and HVAC design. Experience with energy-efficient s...
I'm looking for an experienced and creative irrigation system designer to plan an efficient system for my commercial property. Requirements: - The system should be tailored for grass. - The area needing irrigation is less than 1 acre. Ideal Skills and Experience: - Extensive experience in designing irrigation systems, especially for commercial properties. - A good understanding of the specific water needs of grass and how to meet them effectively. - Ability to create a detailed plan that takes into account the size of the area.
I am seeking a skilful Photoshop expert to introduce more trees to an image of a mound adorned with arborvitae along my property line. This task specifically entails: - Adding trees to the existing mound - The species of these additional trees should match the existing ones on the mound - The placement of these trees should be random, creating a natural and visually appealing look. The ideal freelancer should be proficient in Adobe Photoshop with a keen eye for the natural lay of landscapes and aesthetic presentation. Experience in architecture or landscaping designs would also be beneficial. I require absolute precision and attention to detail to ensure the added trees blend seamlessly with the existing environment.
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
...professional who can create an immersive and detailed virtual reality walkthrough for a real estate project, based on the map I'll provide. This walkthrough will be used for client presentations, hence it needs to be of the highest quality. Key Project Requirements: - The walkthrough must be highly detailed with full textures, realistic lighting, and furnishing to give the client a real sense of the property. - The final output should be in a Virtual Reality format. This is critical for the project as we aim to deliver a realistic and interactive experience to our clients. Ideal Skills and Experience: - Proven experience in creating high-quality Virtual Reality content, particularly in real estate. - Proficiency in using tools and software for detailed modeling, texturing,...
I am in need of a detailed research project that seeks to uncover the owner information of all shopping centers in Montgomery, AL. The scope of this task is broad – you will need to find information on more than 20 different centers. Primary research focuses: - Gathering contact details of the owners - Identifying the property management companies for each center I am considering candidates who are able to deliver detailed, accurate, and current information. Attention to detail is key. Previous experience in real estate research and data mining will be an advantage. If you have a background in this field and have the analytical skills to complete the task, please apply. Thank you.
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I own a vacant property and have basic sketches of it. I'm looking for a planning agent who is a member of RTPI to apply for full plan permission. The main changes I want to make are: - Change the unit from Use Class E to residential (C3) - Use a summer house for acupuncture, massage, and herbal treatments (Sui Generis) The right professional for this role should have experience and expertise in the following: - Knowledge of UK planning regulations - Proven track record of successful planning applications - Experience liaising with local planning authorities - Excellent communication skills to keep me updated throughout the process I'm open to suggestions and advice, but the goal is to secure the necessary permissions for these changes in a timely manner.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
I'm looking for a talented graphic designer to create a logo for my new property management company. This logo should stand out yet be minimalist in style. Key Specifics: - Ideal colors are warm and bold, such as peach, mild orange, and dark reds/burgundy. - The logo can incorporate a building silhouette. Or even an abstract building. - I prefer the logo not be too tall or too wide. More of a block shape. The ideal freelancer for this job is experienced in modern, minimalist logo design and is able to combine abstract ideas with strong design elements. Color sense is crucial for this task. I look forward to viewing your portfolios and working with a creative mind to bring my vision to life.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
...designer to create a modern and visually appealing design for a new real estate website. The website will showcase our property listings, connect potential buyers and sellers, and establish our brand identity in the real estate market. Target Audience: Our target audience includes both property buyers and sellers. Buyers: Individuals, families, and investors looking for residential or commercial properties. Sellers: Homeowners, real estate agents, and developers looking to sell their properties. Website Features Property Listings: A user-friendly interface to browse properties by location, type, price range, and other relevant filters. Property Details: Detailed property pages with high-quality photos, virtual tours (optional), descriptions, key fe...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm seeking the guidance of a legal expert in business law specifically focusing on contracts, torts, and property law. Key Project Points: - The main objective is to enhance my understanding of legal principles and their application in a business context. - I require assistance with: - Understanding the nuances of contract drafting and review - Knowledge on intellectual property protection especially in the context of business - Ensuring my business is compliant with employment laws If you have experience in business law, and a strong grasp of torts and property law, your assistance would be invaluable. I'm seeking a freelancer who can communicate legal information clearly and concisely, and who can help me navigate the complexities of busines...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As a visionary property developer, I'm looking for a skilled and creative architect to help me conceptualize a layout for a 5-hectare society. The goal is to craft a harmonious environment that integrates: • High-rise residential buildings (5+ floors): With your expert eye and creative design, we should offer a visually appealing and functional living space, taking into consideration aspects of safety, structural integrity, cost efficiency, and sustainability. • Outdoor recreational and functional areas: The project should incorporate well-designed playgrounds and parks, offering residents ample space for leisure and relaxation. Additionally, the plan should also ensure the organization of ample and efficient parking areas. Ideal candidates should possess: • ...
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
I'm looking to hire a React Native developer. I need a cross-platform app for both iOS and Android. The main focus of the app will be property Booking related. It will need to handle transactions, product listings, and user profiles. Further, the app should be multi-lingual, so support for multiple languages is required. Requirements: - Proficient in React Native, with a good understanding of its core principles - Experience in building and deploying E-commerce applications - Familiarity with UI/UX design, to ensure a user-friendly experience - Ability to work with and implement multi-language support - Understanding of mobile app security best practices. Your prior work on similar projects and willingness to provide a portfolio will be highly regarded.
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - Data Organization: Good data organization skills are also important to present
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
I need a legal scholar or professional with expertise in Intellectual Property law to undertake a comparative research study. Key Requirements: - Focus on the legal aspects and constraints governing Intellectual Property in the United States, the European Union, and the United Kingdom. - The research must be of high quality and provide a detailed analysis of the similarities and differences among the three jurisdictions concerning Intellectual Property law. - The study should not just provide the laws but also analyze the practical implications and applications of these laws. Ideal Skills and Experience: - A strong background in Intellectual Property law with previous experience in comparative legal studies. - Access to reputable and relevant legal databases. ...
Hi, we need a c# .net/ maui package...android projects; - the developer must provide c#, not hardcoded and fully commented source code; - the developer can't use third party components except for open source ones; - in case third parties components are involved, the develope must ensure us the licenses for third parties components allow distribution/use for commercial purposes; - the developer must sign the feelancer's intellectual property agreement. The payments will be: - 1/3 milestone after the developer provide sample projects for each platform with the compiled package, after we checked it's fully compliant - 2/3 milestone after the developer provide sample projects for each platform with the package's full source code, after we checked it's fully com...
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call for a creat...
I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. T...understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them will b...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
I'm looking for a design expert who can transform the facade of my property to create an appealing modern minimalist aesthetic. At the core of this project is enhancing the curb appeal of my home. Key elements include: - Creating a facade design overhaul using primarily timber cladding with a touch of concrete rendering - Creating a detailed plan which aligns with the modern minimalist aesthetic I'm after - Providing a complete materials list, showing where exposed timber and other materials will be used for enhancing the curb appeal The ideal freelancer for this job will have a great design sense, practical knowledge of materials, and a knack for modern minimalist design. Proficiency in architectural software like AutoCAD or Revit is a plus, but not a necessity. Relev...
Hi Ashish, this is for the tasks I emailed about.
