Excel power query sum columns jobs

...who is proficient in Autodesk Revit. My project requires: The Conversion of 3D laser scans with BLK360 into high quality, detailed Revit models. The objects is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, profiles, connections, gas pipes, equipment or elements that may present interference in case of reinforcement. The information must be presented in a 3...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tas...Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tas...Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

...skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient Mo...

...for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will create in Microsoft Access (locally) Administrator must be able to see for each voter the data each user entered for it (multiple users enter multiple data f...

...bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(narrow band) notch filter at 50 hz / 60 hz to remove power line interference a & b can be combined as band pass filter if possible also a , b & c can also be combines a single filter algorithm to obtain desired frequency response frequency response of all three signal enclosed 4. A 32 bit ARM processor of - 100 mhz / 186( mhz both option aval) with FPU & DSP instruction set will be used . b. processor progra...

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

I'm seeking a talented graphics designer to create captivating vintage-style t-shirt designs. Here's what you'll need to know: - The designs I'm envisioning include elements of Quotes, Landmarks, Animals, UFC, Cricket, Boxing players. A pop-culture awareness would be highly beneficial...fresh and appealing ways. - I've an open mind for colors. You are welcome to utilize warm colors like red, orange, yellow or cool like blue, green, purple. Neutral colors like black, white, gray are also a go. - Ideal candidate has clear understanding of vintage aesthetics, excellent at representing various design elements in cohesive, striking manner, and possess good knowledge of color theory. To sum it up, your design should be engaging and eye-catching. Vintage style lo...

I'm looking to sell a residential solar photovoltaic (PV) system that stands out for its energy storage capabilities and off-grid independence. The estimated space for installation is a medium-sized residence (1,000 - 2,000 sq ft). Ideal skills include: - Expertise in solar panel d...that stands out for its energy storage capabilities and off-grid independence. The estimated space for installation is a medium-sized residence (1,000 - 2,000 sq ft). Ideal skills include: - Expertise in solar panel design and installation - Knowledge of battery energy storage systems - Understanding of off-grid solar systems - Experience with residential projects - Ability to estimate solar power needs based on space size Offer your skills to make this solar PV system stand out in the resi...

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I'm in need of a minimalist logo for my video series, "Productivity Power Hour". The series is all about boosting productivity and efficiency, so I'm looking for a design that effectively represents this theme. Key Points: - Use the slogan Lead Smarter: Rise Above the Grind! - The logo should be minimalist in style - It should be bright and vibrant in color, to grab attention online - The slogan for the series is "Lead Smarter: Rise Above the Grind!" - this can be incorporated creatively into the design The intended use of this logo will be primarily for online purposes such as websites, social media channels, and emails. It needs to be easily recognizable and memorable, even at smaller sizes. Ideal Freelancer: - Graphic designer with experience in m...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

I'm on a quest to flatten my company's efficiency curve and reduce the hours we spend on manual tasks. I need a savant familiar with Power Apps to help me achieve this. Skills Required: - Proficient in Power Apps, preferably with experience in teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Office 365 integrations within these solutions. - Proficiency in constructing complex, efficient databases. The ideal candidate should have a comprehensive grasp of Power Apps and a passion for education. Seeking to build a one-on-one relationship that will deliver measurable results on the path to automation.

I am looking for a specialist who can effectively write a RAK 4630 firmware with an emphasis on energy optimization. You should focus on minimizing power consumption when the device is in sleep mode. Key tasks include: - Implement changes in the RAK 4630 firmware to optimize its energy usage. - Concentrate on reducing power consumption when the device is in sleep mode. The ideal freelancer would have: - A comprehensive understanding of the workings of RAK 4630 firmware. - Proven experience in firmware development with a focus on energy optimization. - Familiarity with device sleep modes and their impact on power consumption. Your goal is to maximize efficiency while ensuring uncompromised performance. Please provide evidence of related past projects in your pr...

...identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. An example of the required spreadsheet format is available – however it is simply 3 columns...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be a...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm in need of a Power BI expert with solid experience in AI integration and advanced dashboard development. The project has multiple facets, including: - Data Cleaning and Transformation: The ideal candidate will have experience in working with large and complex databases. You should be able to clean and transform the data efficiently for integration into the dashboard. - Dashboard Design and Development: An eye for design is key. You will be creating a visually appealing and user-friendly dashboard, with the ability to customize as needed. - AI Model Integration: Extensive experience with AI integration is a must. You should be able to develop and integrate advanced AI models within the dashboard effectively. The main source of data for this project is a database, so experi...

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

I'm in need of an engineer with expertise in both electrical and mechanical engineering. Our aim is to design a high-power attachable biking dynamo/alternator for bicycles. The primary objective of this project is to create a device that can generate and store significant power for storage in high-capacity batteries. This dynamo/alternator should deliver a high power output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role ...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I'm in need of a skillful social media savant with extensive experience in managing Facebook and Instagram platforms. The primary aim of this project is to generate leads, thus beneficial conversions for my business. For this role, the perfect fit would be someone who: - Is adept at curating and generating engaging prod...curating and generating engaging product-promotion posts - Is proficient at managing and encouraging user-generated content - Can align content strategy and posts with our lead generation goal - Has a broad range of experience in increasing visibility and follower engagement - Is knowledgeable in social media analytics to track performance and conversion rates. Ultimately, I hope to leverage the power of social media to tap into new markets and attract p...

...go around a circuit using the least amount of power in a given time, by calculating the forces acting on the vehicle at any point. The forces have been identified to be: Drag, Rolling resistance, Incline, Wind & Motor thrust. Rolling resistance, wind (set to 0 in data should be okay to plug values in later) and incline forces have been resolved in an excel file for every data point (every metre). Drag and motor thrust which depend on the current velocity of the vehicle (see matrix explanation below). The first lap is different to the remaining 9 laps, you can work around this however you like but, please ensure you use the correct data. Furthermore, all the constants relating to the vehicle forces must be able to be changed directly from an excel file page calle...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

... Adresse IP adresse scanned during the registration Telephone number Admin Interface (web only) • Enable/disable users • User password reset functionality (user will receive an email for a reset password) • View user historical orders with a scrolldown list of users • Pause of the application in case of maintenance, so the users could not make orders • Show the number of orders and sum per country per day • Define price per countries Order module • Create/import a letter (mport from a pdf or an other type format such as word or just flat text maximum number of pages per order is 2 A4 format) • Type in an address of destination • Select the country of destination • The price will be related to the country(defined in...

Please Sign Up or Login to see details.

I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced ...

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an experienced Senior Technical Consultant with knowledge in Microsoft Dynamics 365 F&O and expertise in Power Platform. Key Project Requirements: - **Dynamics 365 F&O Modules**: I need assistance in integrating Dynamics 365 F&O with Power Platform, particularly focusing on Financial Management and Supply Chain Management. - **Power Platform Integrations**: Require your support in: * Data integration: Ensuring seamless data exchange between the two systems. * Workflow automation: Developing and implementing automated workflows for various business processes. - **Vendor Invoice Creation**: The vendor invoice creation process should include: * Auto-population of vendor details: Ensure vendor information is correctly filled in. Idea...

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.

...experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consolidation is bet...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).