Need custom spreadsheet excelcông việc

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'm in need of a skilled Power Apps developer to create a custom business application with the following features: - Image Capture and Upload: The primary function of the app is to allow users to take pictures using their device's camera. - Integration with OneDrive: The images taken should be uploaded directly to a specific folder in OneDrive. - 4 Different Upload Buttons: I'd like the app to have 4 distinct buttons, each triggering the camera function on the end user's phone for specific image captures. here's a complete step-by-step guide with all the necessary Power Fx code for implementing a camera feature where the camera is triggered by an "Upload" button for each document section. Step 1: Initialize the App Start by creating a new...

I'm in need of an expert in Excel, Access or similarly powerful programs to handle a large spreadsheet task. Although the specific tasks that need to be handled were not decided upon, proficient data organization skills are essential as we may need to restructure large data sets. The ideal freelancer for this job should: - Have expert skills and proficiency in Excel and Access. Knowledge of other data organization tools will be considered a plus. - Showcase notable experience, specifically in dealing with large data sets and complex spreadsheets. - Since the specific tasks to perform were not mentioned, a flexible approach and ability to adapt with regard to potential data analysis and data entry tasks will be greatly appreciated. With your...

I want this background “ “ I wanna add like a little animation of girl ( look added file), Saki (cat) and Soju (cat) The idea is all of them backwards staring at mt fuji (Vulcan) The girl I'd have maybe here hair flowing or like a wanda cape flowing (flowing in the wind) And then saki and soju (cats) could have their little tails moving as they sit next to me. Be creative. Base it from earlier project.

I'm looking for a skilled developer who's adept at creating custom trading indicators for NinjaTrader 8. Key Requirements: - Proficiency in NinjaTrader 8: It's essential that you're well-versed in the specific requirements and capabilities of the NinjaTrader 8 platform. - Indicator Creation Experience: I need a custom indicator developed, so prior experience in creating a variety of indicators is crucial. - Understanding of Financial Markets: A good understanding of trading and financial markets would be beneficial. The project deadline is flexible, but I'm ideally looking for a developer who can deliver in a timely manner. Please provide samples of similar projects you've worked on. Please Review Charting Heads RSI Pivots for more inf...

...web designer to create a modern, bold portfolio website for my business. It's essential that you have a fresh, innovative approach and previous experience building portfolio websites. Key Features: - Custom buttons: Engaging and interactive buttons are an absolute must. - Bold Design: The style should be modern and bold to reflect my distinct identity. It must convey my brand purpose, show our professionalism, and stand out from the competition. Required Skills: - Strong understanding and experience in portfolio website design - Creativity and innovation - Experience in creating custom buttons - Understanding modern design trends and principles. If you're someone who knows their way around website design and can deliver a visually exciting and accessible...

Content and photos ready. Must me mobile responsive. One page of content, 4 photos. Generic information that applies to all listings. Same description will be used on all listing. Description will not contain product information.

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.

I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly those re...

...Desktop: PWA: For the design of our Progressive Web App, we used the OpenTable application as the inspiration. Similar applications that have the same functionality as our sites 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

...requirements: - Implement Amazon Cognito for user authentication and authorization - Utilize AWS Amplify for the app's development and deployment - Integrate AWS API Gateway for efficient data exchange - Integrate Stripe for payments. Need complete flow Our tech stack looks like: - Amazon Amplify for app backend, and front end - Gatsby JS coupled with AppSync for front end - Amplify UI and MUI Material for UI components Features that I need: - End to end user journey - from login/registration to offering profile capture, to custom subscriptions - User DMs, Push Messaging, Custom email notifications (using SES) - Analytics (details noted below) Data Analysis Requirements: - Predictive analytics: Capability to anticipate future trends based on histori...

...You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data collecting: You will nee...

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.

...cross-platform Juce VST3 plugin scanner. This tool should be compatible with Windows and macOS. Key Features: - The plugin scanner is meant to detect and organize installed VST3 plugins. It should be able to scan and identify all VST3 plugins on any user's system. It should add these plugins to a KnowPluginList and save this list to an AppProperties Object. It should be a standalone application and have a custom theme that we can discuss. Skills and Experience: - Extensive experience with C++ and Juce framework is a must. - Prior work on creating VST3 plugins or scanners is highly desired. - Familiarity with plugin detection and organizing algorithms. - Experience in creating cross-platform applications and ensuring consistent performance across Windows and macOS. Ideal ...

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...

...skilled trading view indicator developer to create an indicator based on fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert system that can be triggered by specific conditions. These conditions w...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

Monthly, we populate a spreadsheet with the over time of the technical team, and the weekend / night shifts of the tehnicians working outside the business hours. We have a template that we want to improve. 2 categories: 1. Managers doing overtime (regular / night / weekend) and being oncall. 2. 24h shifts: complement to the salary based on night / weekend hours we should be able to calculate monthly the amount to be added to the fixed salary attached template (with complicated formulas and errors)

...particularly in the context of YouTube production. Your bid should also clearly outline your experience in creating photorealistic 3D animations and graphics. If your work is excellent and your prices are low I might ask you to bid on more of the same type of projects I will post in the future. Each custom 3D Animation and 3D Graphic must be copyright free so I can own the copyright to each 3D Animation and 3D Graphic. You must sign my NDA before I can share any samples of exactly what I need made. I will own the copyright to all the images, graphics, files, programs, source code, coding, animations, text, lists, menu's, files, rendered files, native files, and source files. The Interactive 3D Graphic must also be saved in the proper files so I can use it in my video...

I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing 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 wi...

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...

...getting attacked, I need to create a windows service constantly checking a .txt log file for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts &n...

I have a registered domain for my clothing brand and plan to use Shopify as the platform for my online store. I need a skilled and experienced freelancer to help me set up the store. Key requirements include: - Developing a custom clothing brand store based on a design mockup I will provide - Setting up the Shopify store, including theme customization - Integrating necessary plugins for a smooth customer experience - Creating a simple and user-friendly product catalog for less than 50 clothing products The ideal candidate should have: - Proven experience with Shopify store setup and customization - Strong design skills to replicate the mockup effectively - Good understanding of e-commerce best practices - Excellent communication skills and ability to work collaboratively I...

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

I'm having an issue with the cookie bar on my landing page. It functions perfectly upon my primary website, but fails to operate as expected on my subdomain, specifically my landing page. I am using the exact same JavaScript and CSS script for both the website and landing page. All is built on custom HTML. Ideal skills for this job: - Expertise in JavaScript and CSS - Vast experience in handling cookie bars and similar web components - Ability to diagnose issues affecting custom HTML websites The selected freelancer will be tasked with: - Understanding the functionality of the cookie bar on my main website - Translating the same functionality to the landing page - Uncover and solve any underlying issues or differences causing the functionality mishap Please note that ...

I'm in need of a seasoned developer who has experience working with CMS systems and cloud services like AWS. The primary focus for this project is building an automated blog content system, leveraging GPT for content generation. Key Requirements: - Proficient in CMS (WIX is a plus) - Strong experience with GPT or similar AI tools - Able to design and implement highly customized content for different user profiles - Expertise in AWS is a big plus I need a developer who can seamlessly integrate these technologies to create a dynamic, user-friendly blog system. The ability to provide recommendations and creative solutions based on your experience is highly valued. Your work will be pivotal in creating a unique, engaging experience for our blog readers.

I am looking for a skilled developer to create an execution script for me for the game, Roblox Jailbreak. Features: - Fast car speed - Unlimited ammo - Teleportation ability Auto Farming: This script should enable auto farming. It should be able to: - Collect in-game currency - Complete missions or tasks User Interface: I would like the UI to be customizable to fit my preferences. Ideal Skills: The freelancer should have proven experience in scripting for the Roblox platform and should be familiar with the mechanics of the Jailbreak game. An understanding of UI design and user-experience would also be a plus. Freelancer needs to demonstrate their ability to create scripts with similar complex functionality. I dont want it to have any mistakes!

...Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, 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 - Aut...

...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...

Embedded Linux Engineer to assist in the creation of a kernel device tree for a custom board. You must expertise in embedded systems development, particularly in configuring and customizing Linux kernels and creating device trees. Please explain your relevant experience for this task in few sentences in your application.

...Requirements: - The technology for the configurator should be based on 3D modeling and rendering, not AR or VR. This should mirror the style of IKEA's PAX Planner. - The configurator should be accessible across different platforms, including web browsers, mobile apps, and desktop applications. - We already have the 3D models for the furniture products in .max and/or .3ds file types, so these will need to be integrated into the configurator. Ideal Skills and Experience: - Proficiency in 3D modeling and rendering is paramount. - Prior experience in developing similar product configurators is highly desired. - A strong understanding of web and mobile application development. - Fluent in the English language. Please provide examples of previous similar projects you have worked...

I am in need of an experienced watercolor artist to create a medium-sized (16x20 inches) coastal-themed painting for home decoration. The painting should have a serene, coastal feel, incorporating various elements such as houses, boats, sea life, etc. Key Requirements: - Watercolor Painting Expertise: I require a professional with demonstrated experience in creating watercolor paintings, particularly in coastal themes. The ability to blend colors and capture the essence of the coast is essential. - Attention to Detail: The painting should feature intricate details of houses, boats, sea life, and other elements. It should be visually engaging and evoke a calming, coastal atmosphere. - Timely Delivery: I am looking for a freelancer who can complete the painting within a reasonable ti...

I'm in need of a comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and trends. This will help us make data-driven decisions. - **Real-Time Bin Shrink:** I need to know if the quantity of items in the bin matches the recorded amount. - **Interface:** A mobile app interface will be ideal, making it easy for staff to work on the go. Inventory Tracking: - The system should involve manual entry for inventory tracking. The system should be user-friendly and easy ...

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 want something like this, with business name etc Painters & Blockers Custom resprays

I need an expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Da...

...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...

I need a skilled Discord developer to help me setup my server and create custom bots with specific functionalities. Requirements: - Server Setup: You will be responsible for the initial setup of the Discord server. - Custom Bots: I need custom bots to be created with the following functionalities: - Moderation: The bots should be equipped to perform actions like kick, ban, and mute. - Auto-moderation: The bots should prevent spam. - Custom Commands: Implement custom commands as per my requirements. Additional: - Integration: The custom bots need to integrate with Twitter and TikTok. Ideal skills and experience: - Proficiency in Discord API and server setup procedures. - Experience in creating custom bots with m...

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 uniq...

I need an experienced WordPress developer to create a custom plugin for my site. This plugin will communicate with the Transmission shipping company's REST API. Key Requirements: - 2 buttons are needed in backend wp. 1: ADR shipment (dangerous goods) 2: normal package - After generating the shipping label the custumor should receive the trackingcode. - After generating label is must be printed automatically on a zebra printer. - The plugin must be able to communicate with the Transmission shipping company's REST API. - Data exchange should be smooth and secure. - The plugin should be well-organized within WordPress, and easy to understand and use. Ideal Skills: - Strong experience with WordPress plugin development. - Good understanding of custom...

We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship 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: Abi...

I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will have experience in the US time zone and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify - Familiarity with app development for Shopify - Store setup and configuration Industry experience is not a requirement for this project, any industry experience is acceptable. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to work in the US time zone and have X hours left available TODAY!" - where "X" is the amount of hours you have available for work today immediately. Thanks!

I'm in need of a skilled developer to create a robust CodeIgniter module that integrates with multiple APIs. The main purpose of this module is to enable seamless communication with various services including calling contact, Google Meet, SMS, and Email. Key Details: - The module should include a custom API integration for calls, Google Meet, SMS, and Email. - For contact calls, the primary functionality required is a 'Click to call' API. This should allow users to conveniently initiate calls directly from within the system. Skills and expertise that are required for this job include: - Proficiency in CodeIgniter and understanding of MVC framework. - Prior experience in integrating APIs, preferably for contact calls, Google Meet, SMS, and Email. - A solid g...

I am seeking automation specialist with experience on (similar to Zapier) to setup triggers and workflows for a speaker/agenda management system we use. You will need to build scenarios and use Custom Field data. To be considered, please comment "SSM". Thanks!

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of ...

I need a skilled professional to set up Google Ads Conversion and Tag Manager specifically for tracking Needs - Google Ads Conversion Setup - Google Ads Conversion Tracking in Google Tag Manager Setuo - Google Tag Manager Setup Ga4 - Google Analytics Setup Key deliverables: - Implement proper tracking of 'Click on ads' - Ensure seamless tracking of 'Click on ads' across all landing pages and ad campaigns - Provide insights and recommendations for enhancing ad performance based on data analysis - Troubleshoot and resolve any potential issues with the tracking Ideal Candidate: - Proven experience with Google Ads and Tag Manager - Strong understanding of ad performance analysis - Ability to implement custom tracking solutions - Excellent troubleshooting...

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

** Please look the .PDF file have a full details of this simple project. I need this assistance Today or tomorrow day 19 or day 20 max limit.. If you can do this now....I prefer. The old website was on WordPress, but the guy used ACF and created some custom fields for company employees to register stores separated by state and city. There's also something about taxonomy; he created 2 custom post types: 'office' and 'officearea.' In the old WordPress, it worked like this: 1 - User goes to the offices menu, where all states are listed. 2 - User chooses a state, and that state's name is in the URL. 3 - It seems the guy made a PHP script that retrieves the chosen state from the URL, then loops through and displays only the offices in that ...