Excel sheet cities worlddela

I need someone with access to Refinitiv Eikon DataStream to download data for all UK listed companies over the last 6 years. List of variables will be shared to the selected candidate. The ideal freelancer for this project should have: - Prior experience with Refinitiv Eikon DataStream - Expertise in financial data analysis - Proficiency in Excel Data Format: - I would like to receive the downloaded data in Excel format. Please provide your previous relevant experiences when bidding for this project.

I need an Excel expert to help me modify and randomize my data. The tasks include: 1. Changing all dates in the “Proc Date” column to only Tuesdays and Wednesdays from July 2024 to December 2024, excluding Christmas Eve, Christmas Day, and New Year’s Day. The dates can be random, in no particular order. 2. Updating the phone numbers in the “Phone” column to: (908) 730-8880 for the entire column. 3. Changing the address in the “Address of the Facility” column to: 1630 NJ-31, Clinton, NJ 08809 for the entire column. 4. Altering the ages in the “Ages of the Patients” column to random numbers between 12-89 for the entire column. 5. Modifying the name in the “Facility Name” column to: North Hunterdon Dental Associates for...

I'm seeking an experienced Wikipedia editor to create a comprehensive page for a prominent figure in religious criticism and human rights. Key Focus Areas: - Biography and Early Life: Detailing their formative years and influences. - Major Works and Achievements: Highlighting their significant contributions and milestones. - Advocacy and Impact: Illustrating their influence on the world and the causes they championed. Ideal candidates will have: - Prior experience in Wikipedia page creation. - A strong understanding of notability requirements. - Excellent research and writing skills. - Ability to convey information in a neutral, encyclopedic tone. - Familiarity with the subject matter would be a bonus.

...Scholarships Look for scholarships that support these specific PhD programs. Include scholarships that are region-specific, discipline-specific, or university-specific. Note any eligibility criteria and deadlines. Compile Information into Excel File Use the following columns/fields to structure the data: ID Number: Unique identifier for each program. Programme: Name of the PhD program. University: Institution offering the program. Duration: Length of the program (in months). Location: Country and city (if applicable). Tuition Fees Per Year: Total yearly cost (in USD). World Ranking: University’s global ranking. Entry Requirements: Admission criteria. Disciplines: Main areas of study offered. Flexibility/Mode of Study: Distance, hybrid, or fully online options. Prio...

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

...processes. Communication Logs: Automatic or manual logging of calls, emails, and meetings with clients. Reminders/follow-ups for client interactions. 4. ERP (Enterprise Resource Planning) Features Accounting Module: Income and expense tracking with detailed categories. Ability to generate invoices, record payments, and track receivables/payables. Automated financial reports (profit/loss, balance sheet, cash flow, etc.). Payroll Management: Generate salary slips and receipts for all employees. Salary calculation based on attendance, overtime, or other parameters. Option to email salary slips directly to employees. Leave & Vacation Management: Employees can submit vacation/leave requests online. Managers or HR can approve, reject, or comment on requests. System automatically up...

I'm seeking a talented designer to help me create a contemporary Christmas textile print. I have specific ideas, but I need your expertise in transforming them into a seamless pattern file suitable for printing. I have 1 design idea, which I have attached which I love the idea. I just need it to be in the correct file and made as a seamless pattern for printing using Tech Sheet. Experience in fashion textiles will help to bring the idea to life, give me suggestions when needed and make sure it is the right size for printing on a scrub top and pants and the colours will stand out. Key Requirements: - Understanding of modern/contemporary Christmas themes - Proficiency in creating minimalist shapes and abstract icons - Skill in using a maximum of 8 colors to create a ...

Necesito realizar un patrón profesional de camuflaje basado en la piel de un velociraptor. Tiene que tener continuidad y ser único basado en la saga de jurassic park/world. Lo necesito para usarlo de manera comercial en tela.

Retired senior needs help with keeping ongoing matters organized. Would need someone familiar with Word, Excel, willing to train for light duties in QuickBooks. At employer's residence (dealing with Parkinson's and really need some help) Personable, very laid back environment but employer needs help with filing, some calendaring, keeping appts straight etc, Offer needs to hire for a few weeks, maybe less.

...وبيانات سيتم تحديدها لاحقا الفروع: يمكن إضافة أكثر من فرع واحد لاستخدام هذا البرنامج مربع المسار: إنها مجموعة من الأسئلة. يتم تحديد عنوان الأسئلة ويتم وضع أكثر من سؤال واحد ويتم وضع أذونات للإجابة، سواء كان رقما أو كتابة أو تاريخا وما إلى ذلك. يمكنه إضافة أكثر من عنوان واحد داخل كل عنوان. أكثر من سؤال واحد (ستظهر هذه الأسئلة للشخص الذي سيستخدم النظام في شكل مربعات مملوءة (كل عنوان للأسئلة له ملف Excel أو نموذج تصميم خاص به. يتجاوز عدد عناوين الأسئلة 60 عنوانا أو أكثر ويندرج كل عنوان تحته. كل عنوان له وسيلة ولكل عنوان شكله أو نموذجه الخاص الذي يختلف عن الآخر. عند التنزيل، سيتم تزويدك بذلك (سيتم تزويدك بجميع الملفات ونريدك إدخالها مباشرة في النظام) مربع الإحصائيات: يمكنك اختيار أحد الأسئلة التي تم وضعها سابقا في مربع المسارات عن طريق الإدمان ثم تظهر جميع الأسئلة وفقا للعنوان ويحتوي...

I'm seeking an experienced freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive and accurate manner. Requirements: - Exceptional accuracy and attention to detail. - Proven experience in data collection and organization. - Proficiency in Excel or Google Sheets for organizing property data. - Ability to research reliable sources. Deliverables: - A well-organized spreadsheet with all the required property details. If you have experience in real estate data collection or similar projects, please provide examples of your previous work.

...(configuration, code, etc.) to facilitate movement. Task 3: Create an introductory screen within the basic virtual reality environment containing three interactive elements (e.g., buttons): enter the virtual world, instructions, and exit the application. Enable interaction with these elements by focusing and holding gaze on a specific element. Selecting the instructions option should display a brief guide on how to use the application, while selecting Exit should close the application. Then, create an ending screen with two options: Start Over and Exit. Start Over should allow re-entry into the virtual world (as with the corresponding option on the introductory screen), and Exit should terminate/close the application. Task 4: Provide at least three types of interactions ...

I'm in need of a proficient Excel expert who can design a custom Excel template for tracking my expenses. The main purpose of this template is to help me with financial tracking. Key Requirements: - Design a user-friendly Excel template with a focus on expense tracking - Incorporate built-in calculations or formulas for totals and subtotals Ideal Skills: - Proficient in Microsoft Excel - Experience in creating financial tracking templates - Strong understanding of expense tracking and budgeting Please, submit your proposal if you can assist with this task.

...(configuration, code, etc.) to facilitate movement. Task 3: Create an introductory screen within the basic virtual reality environment containing three interactive elements (e.g., buttons): enter the virtual world, instructions, and exit the application. Enable interaction with these elements by focusing and holding gaze on a specific element. Selecting the instructions option should display a brief guide on how to use the application, while selecting Exit should close the application. Then, create an ending screen with two options: Start Over and Exit. Start Over should allow re-entry into the virtual world (as with the corresponding option on the introductory screen), and Exit should terminate/close the application. Task 4: Provide at least three types of interactions ...

I need assistance with my Excel template for a UPS franchise. The template currently has projections and assumptions filled out, but I need help refining the future projections and assumptions with a strong focus on sales growth. Key tasks include: - Analyzing and refining future projections and assumptions - Assisting with sales growth predictions Ideal candidates should have: - Strong numerical skills - Proficiency in Excel - Experience with business projections - Understanding of franchise operations - Ability to interpret and analyze data

We are looking for a highly skilled freelancer or team to assist with launching a complete ICO (Initial Coin Offering) for an innovative platform. The project involves creating a crypto-token, developing a professional ICO website, and executing a marketing campaign to ensure the ICO reaches a global audience and attracts investors. The platform behind this ICO is designed to address a real-world need, connecting individuals and businesses with professionals for collaborative and project-based opportunities. The ICO will serve as a funding mechanism to accelerate platform development and future blockchain integration. Scope of Work: 1. Token Development Create a secure BEP-20 (Binance Smart Chain) or ERC-20 (Ethereum) token with basic functionalities: Token name, symbol, and tota...

This is a repost from earlier today, as the job was awarded and then the Freelancer and I didn't agree on terms. I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format...

Create an excel sheet with the names and email addresses of the employees of certain divisions.

I'm seeking a meticulous research expert to gather competitive pricing on Amazon, Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: -...Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: - Competitor Pricing - Unit Sales - Number of Reviews The collected data should be presented in a clear and organized spreadsheet. Ideal candidates should have strong analytical skills, experience with market research, and proficiency in using Excel or similar spreadsheet software. A keen eye for detail and the ability to interpret product images is also a plus. I'm looking f...

I'm seeking...seeking a professional to craft a comprehensive business plan aimed at securing a bank loan. This plan will be crucial in demonstrating the viability and potential of my business to the bank. Key Focus Areas: - Creation of a compelling narrative that conveys the business's potential and necessity for funding. - Detailed financial projections that align with the existing income statement and balance sheet. - A strategy for presenting the business plan in a manner appealing to a bank's loan officer. Ideal Candidate: - Proven experience in developing successful business plans, specifically for bank loans. - Strong financial acumen, able to create and interpret financial projections. - Excellent writing and communication skills, capable of crafting a persu...

...following pages: Freelancer Registration Page Employer Registration Page Create Task Page (Freelancer) Post Project Page (Employer) Freelancer Profile Page Employer Profile Page Task Search/Listing Page (for both Freelancers and Employers) Freelancer Search Page (used by Employers to find Freelancers) Connect State with City (Dependent Dropdown): Ensure that the City dropdown only shows cities from the selected State on the following pages: Freelancer Registration Page Employer Registration Page Create Task Page (Freelancer) Post Project Page (Employer) Freelancer Profile Page Employer Profile Page Task Search/Listing Page (for both Freelancers and Employers) Freelancer Search Page (used by Employers to find Freelancers) Update Queries for City and State Filter...

...Responsibilities: Design and build three user-friendly, real-time dashboards to track specified KPIs. Connect dashboards directly to DX1 data reports, Excel, and other relevant data sources. Enable real-time data updates to minimize manual data input and imports. Ensure the dashboards support multiple users and allow for direct data entry or seamless integration. Collaborate to ensure the dashboards align with business goals and provide actionable insights. Ideal Skills & Qualifications: Proficiency in Klipfolio, Google Looker Studio, or similar platforms for creating dashboards. Experience with data integration, particularly with DX1 reports and Excel. Strong understanding of sales, customer engagement, and operational KPIs. Ability to set up and manage real-time da...

I am seeking a skilled and Data Analyst to create comprehensive dashboards in Power BI for a financial project. The goal is to visualize and analyze key performance indicators (KPIs) that will help to make data-driven decisions and enhance financial performance tracking. Project Requirements: 1. Data Analysis & Visualization: o Analyze and structure financial data from various sources (Excel, SQL, etc.) o Create dynamic and interactive dashboards in Power BI to visualize KPIs such as revenue, expenses, profit margins, cash flow, and more. o Utilize data models, DAX, and Power Query to enhance the dashboards. o Provide clear insights and recommendations based on the dashboard data. 2. Customization and User Interactivity: o Develop filters, slicers, and other interactive features...

I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual corrections to be made to a...

Hi! Usual conditions - four groups so €50 Have you got the excel file still?

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with paymen...

I'm in need of custom Excel templates specifically designed for financial reporting. These templates will be used primarily for tracking and managing accounts receivable. Ideal skills for this project include: - Advanced Excel proficiency - Experience with financial reporting - Knowledge of accounts receivable management - Ability to create user-friendly templates

I'm looking for a freelancer who can help me automate the analysis of trading oi and volumes from the NSE using Excel. Key Tasks: - Automate the collection and analysis of NSE trading volume data within Excel - Use statistical analysis techniques to interpret the data The ideal candidate for this job should be proficient in Excel automation, have a strong understanding of statistical analysis techniques, and be familiar with NSE trading volumes.

I need assistance with using mathematical formulas in Excel, specifically 'Sum and Average' and 'Index and Match'. Your role will mainly involve data entry and creating charts. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with data entry and chart creation - Familiarity with mathematical formulas, specifically 'Sum and Average' and 'Index and Match' - Attention to detail and ability to work accurately.

...candidates' technical depth effectively. Responsibilities: Conduct in-depth technical interviews to evaluate candidates' knowledge and coding skills in MEAN, MERN, MEVN, or Node.js-based stacks. Assess expertise in front-end frameworks like Angular, React, or Vue.js and back-end technologies such as Node.js and Express.js. Design and administer coding challenges, system design problems, and real-world scenarios to test candidates' abilities. Evaluate candidates understanding of RESTful APIs, microservices, cloud platforms, and database optimizations (SQL or NoSQL). Provide detailed and constructive feedback to hiring teams on candidates' technical competencies. Stay updated on the latest trends in JavaScript and full-stack development to maintain a robust eva...

I need assistance with automating the comparison of numerical data from two different sites. The findings should be compiled into a new Excel sheet or page in a table format. Key Requirements: - The compiled data should be saved for 24 hours before being automatically deleted. - I should have the ability to sort the data based on various parameters. Ideal Skills: - Proficiency in data analysis and Excel - Familiarity with automation tools - Strong attention to detail

I'm seeking a proficient web scraper to extract contact details from the provided website. Ideal Skills: - Proficient in web scraping tools and software. - Experienced in data extraction from company websites. - Deliver the extracted data in Excel format.

As the owner of a premium limo service, I am seeking a skilled freelancer to craft an enticing proposal aimed at attracting new clients...enticing proposal aimed at attracting new clients. The proposal needs to be: - Formal and sophisticated in tone - Highlighting the luxury amenities, professional chauffeurs, and on-time reliability of our service - Polished and professional, befitting the luxury of our company Essential components of the proposal include an introduction letter, detailed service descriptions, a comprehensive rate sheet, and carefully selected, relevant photos. Ideal candidates will have: - Proven experience with creating compelling business proposals - Excellent writing skills - Ability to create a visually appealing document Please attach previous examples of ...

...instructional demonstrations. All hardware components should be neatly organized within the existing racks, but additional racks can be added if necessary. The entrance door is located in the middle of one of the 24-foot walls. While the door can be relocated, we would prefer minimal changes to the existing structure. We are looking for a designer to create a 3D layout of the lab that is both unique and world-class. The design should prioritize functionality, modern aesthetics, and efficient use of space. Key Requirements: - Design a tech-integrated multifunctional workstation for the teacher - Set up a projection-based smart board - Organize various types of hardware, including robotics kits, sensors and microcontrollers, 3D printers and tools, computers, and general tools I...

...your commitment to luxury and customer satisfaction. Value Proposition: Highlight what sets your service apart (e.g., experienced drivers, a range of vehicles, competitive pricing). Call to Action: Invite them to review the rate sheet and contact you for bookings. Closing: “We look forward to serving you,” followed by your name, title, and contact information. 3. Services Offered List various services (e.g., airport transfers, corporate events, weddings, special occasions). Brief descriptions for each service. 4. Rate Sheet Include a clear and organized rate sheet: Vehicle types (e.g., sedans, SUVs, stretch limos) Pricing (hourly rates, flat rates for specific destinations) Any special packages or discounts. 5. Testimonials Include a few quotes from sati...

...editor, with skill and agility in its use, no matter what version of the software you have installed. The project consists of capturing Google Street View images of the center of cities in the USA. With a resolution of 1920x1280 px, RGB, 8 bits/channel, with 72 dpi. With specific layers that must appear in all the finished photos that we will deliver to you in PSD and that will serve as a template. Each photograph of the center of each city must contain people and shops, eliminate the typical watermarks of Google Maps (Google logo, arrows, street names...) and not be backlit, cloudy, at night or in bad weather. Those cities that cannot be photographed through Google Street View because the Google car has not mapped it, you will use Google Images, always capturing photos ta...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I'm looking for a digital consultant who can help me enhance my online presence and visibility in the art world. I need assistance with improving my website, public and social image as an artist in order to attract more visibility and generate more money with my various artistic activities (career currently at a standstill). KEY AREAS OF FOCUS: - Personal Website: I need someone who can examine my whole website and give me advices (so I can redesign it myself) to make it appear more professional and user-friendly to visitors, while retaining my own style. Also, I have a new big project (a special NFT collection with a donation for a cause...) and I need advices to know if I should include it into my actual website or rather present it on a blog or something else apart. - ...

...Urgency**: Represents the critical need for rapid response in emergencies, tying to your focus on empowering students to act decisively. - **Energy & Empowerment**: The lightning bolt embodies the “spark” of confidence your training ignites in learners, transforming hesitation into action. - **Dynamic Innovation**: Suggests cutting-edge, adaptable training methods that keep pace with real-world emergencies. --- ### **4. Heart Symbol** - **Symbolism**: - **Compassion & Care**: The heart reflects Delta Emergency’s patient-centered philosophy, emphasizing empathy and humanity in emergency response. - **Life-Saving Mission**: Reinforces that first aid is not just technical skill but an act of care—saving lives and s...

I'm in need of assistance with data entry into an Excel sheet. The data is of mixed types - both text and numeric. Key tasks include: - Manual entry from various files - Ensuring the data is organized into standardized rows and columns Ideal candidates should have: - Proficiency in Excel - Attention to detail to ensure accurate data entry and formatting.

I’m seeking an experienced market researcher to compile a report on the use of legacy street lighting systems (not limited to high-voltage relay systems) and the market opportunity for affordable, simple, and easily maintainable control solutions. The focus is on Europe and North America, but insights into other regions are welcome. Key objectives: Identify cities, towns or regions (primarily in Europe and North America) still using legacy systems, including centralized control systems, relay-based systems, or other outdated technologies. Quantify the size of this market—number of municipalities, approximate streetlight counts, and current operating costs. Highlight common challenges with legacy systems (e.g., maintenance, energy inefficiency, obsolescence). Provide st...

I am in need of comprehensive data about lodges in the Serengeti ecosystem. This data should include both the latitude/longitude of these lodges and reviews. Your task will be to compile this information into an Excel spreadsheet. The completed data set will be used for a research paper, so accuracy and thoroughness are paramount. Ideal skills and experience for this job include: - Proficiency in data collection and analysis - Experience with Excel - Attention to detail - Ability to understand and meet academic research standards.

...package purchases. • Notifications for payment confirmations. 3. Advertisement Platform • Allow placement of ads for related services. • Dynamic ad slots for targeted promotions. 4. Device API Integration • Support for APIs from various tracking devices (e.g., Cantrack, Teltonika, Tramigo, Fifo, Baanooliot). • Real-time reporting and seamless communication. 5. Reports and Analytics • Graphical, Excel, and PDF report formats. • Exportable data for vehicle status, trip logs, fuel consumption, and driver behavior. • General statistics: number of users, location, sales, geozone activity, overspeed instances. 6. Notifications and Alerts • Email and SMS notifications for critical events. • Real-time pop-ups for geofence breaches, speed ...

I'm in need of an Excel expert to help me create a comprehensive savings tracker. This spreadsheet needs to have a variety of features and capabilities to assist in monitoring and managing my savings. Key Requirements: - The spreadsheet should automatically calculate various components, reducing the need for manual input and increasing efficiency. - It should have a user-friendly dashboard that presents key information clearly and succinctly. Calculations Needed: - The tracker should be able to calculate my monthly savings. - It should also project my total savings over a set time period. Ideal Skills: - Proficiency in Excel is a must, with experience in creating similar spreadsheets highly desirable. - Ability to design intuitive dashboards within Excel. - Str...

...booking. Admin Requirements: 1. Booking Management: Maintain a Google Sheet or lightweight CRM to log bookings, availability, and user details. 2. Availability Updates: Allow manual updates for unavailable time slots. 3. Payment Handling: Automatically log payments and flag unpaid bookings. 4. Scalable Solution: Ensure the system can handle multiple concurrent users. Tech Stack: WhatsApp Business API or tools like WATI/Twilio Studio. Payment integration (Razorpay/Paytm/Stripe). Google Sheets or any lightweight CRM for booking management. Deliverables: 1. Fully functional WhatsApp booking automation system. 2. Integration with payment gateways and OTP verification service. 3. Google Sheet/CRM integration for admin booking management. 4. Doc...

I'm in need of a freelancer with a strong mechanical background who can research and compile a detailed product catalog for various machines. The machines include, but are not limited to: - Mechanical Power Press - Mechanical Shearing - Hydraulic Shearing - Pneumatic Shearing - Pneumatic Power Press - Shearing Cutter Machines - Sheet Bending Press Break Machine - Lathe Machines - Trop Machine - Milling Machine - CNC Lathe - VMC - Press Break - Drilling Machines The catalog should include detailed technical specifications for each machine, specifically covering their performance and capabilities as well as maintenance and operational details. The final deliverable should be a well-organized PDF document. Key Requirements: - Research and compile specifications and features fo...

Busco desarrollar un módulo para Perfex CRM, orientado exclusivamente a desarrolladores con experiencia previa en esta plataforma. Funcionalidades principales del m...según los requerimientos fiscales locales. Generación de reportes: Crear reportes específicos requeridos por la dirección de impuestos. Los reportes deberán cumplir con plantillas oficiales establecidas (se proporcionarán detalles en formato Excel para mayor claridad). Asegurar que la generación de estos reportes sea compatible con las normativas fiscales aplicables. Nota importante: Este proyecto está dirigido únicamente a personas con experiencia comprobada en Perfex CRM. Proporcionaré detalles adicionales, como los formatos de los report...

As a newcomer to the online world, I need an expert to assist me in creating a website from scratch. The site is intended for research purposes, so it will need to be an intuitive, user-friendly platform with a search engine. Key Requirements: - Design and develop a comprehensive research-focused website - Integrate a functional and efficient search engine - Provide guidance, support, and education throughout the process Ideal Skills and Experience: - Proven experience in website creation - Proficiency in integrating search engines into websites - Excellent communication skills for teaching and support Your assistance is greatly appreciated as I navigate this journey.

Im want a 2d rpg mobile game with open world, and specific online zones for battles and trades.