Shortening zip codes in excelpráce
Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Jedná se o projekt do školy. Vytvořte jednoduchou fungující dynamickou webovou aplikaci s využitím Fat-Free Frameworku (F3). Dynamická webová aplikace by měla: • načítat data pro jednotlivé strany webové aplikace z...databáze • vygenerovat menu, které zobrazí přehled stran daného webu • zobrazit dané stránky • NEmusíte programovat administrátorské rozhraní (back-end). Postačí prostředí pro zobrazení obsahu návštěvníkovi (front-end) • pro zobrazení jednotlivých stránek doporučuji v URL použít jejich ID, které webová aplikace z URL použije pro nač...
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data, such as companies, ...
I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.
I'm looking for a skilled iOS developer with experience in OpenCV to add an offline OMR (Optical Mark Recognition) feature to my existing iOS app. This feature should dynamically adapt to any template, with specific focus on reading QR Codes and using OCR. Key Requirements: - Template Reading: The OMR feature should effectively identify templates using QR Codes and OCR primarily. - Question Types: The system must be capable of handling True/False questions, Multiple Choice questions, and Matching questions. - Scoring Systems: Implement three scoring systems - Ideal Questions (ranging from 0 to 3 in 0.5 increments), Completion (scores of 0 or 1), and Perfection (scores ranging from 0 to 15). OMR Process: - Correct answers should be marked with green circl...
...looking for a professional with expertise in drafting Mechanical, Electrical, and Plumbing (M.E.P.) systems, including Fire Sprinkler and Fire Alarm systems, for an existing property. This property is intended to be converted into an assisted living senior center. Key Responsibilities: - Review existing M.E.P. systems and make necessary modifications for the new usage of the property. - Draft M.E.P. plans that comply with city codes and regulations. - Ensure designs are suitable for a senior living center. Additional Resources: - A walkthrough video explaining the layout and existing systems is available. - You will need to familiarize yourself with the required codes and regulations for the city of Laurel Maryland. Ideal Skills: - Strong background in ...
I'm looking for an experienced deve...selection, during the purchase process. - Implement automation for account creation on the IPTV server as soon as payment is confirmed in WHMCS. - Ensure immediate activation of the IPTV service account upon successful payment. Module Features: - The module should allow for service customization at the point of purchase. - Seamless interaction with the IPTV API for automated account creation. Deliverables: - A fully functional WHMCS module, ready for installation. - Complete development codes for the module. Ideal candidates for this project should have: - Extensive experience with WHMCS and module development. - Familiarity with IPTV service provisioning. - Proficient in API integration and automation. - Ability to deliver...
I need an expert to help me refine and reorganize my hair color chart. Key tasks: - Change names of existing colors on the chart - Improve the overall layout of the chart for better usability - Reorganize the chart by number codes The ideal freelancer for this project should have a keen eye for detail, experience with color chart editing, and ability to make the chart more user-friendly.
...seamlessly integrate with both the Lunar Client and Cheatbreaker, and be compatible with Minecraft versions 1.7, 1.8.9, and 1.21. Key Requirements: - Compatibility with Lunar Client and Cheatbreaker - A new ImGui menu - A tool for obtaining mappings for Lunar Client I will provide you with the source codes for all cheat modules, as well as a tool for getting mappings for Lunar Client. Your primary task will be to navigate and figure out Cheatbreaker. Ideal Skills and Experience: - Proficiency in Minecraft modding and client development - Experience with the Lunar Client and Cheatbreaker - Familiarity with Minecraft versions 1.7, 1.8.9, and 1.21 - Prior work with creating ImGui menus - Ability to work under a tight deadline with a budget of $500 Please note, I only requ...
...WEBSITE. ***THIS MAY REQUIRE YOU TO DELETE THE SITE BUT KEEP THE DATA**** If you do have to delete the site to restart everything again please note that you pay great attention to the required designs mentioned below and features that have been added to particularly the product page. - ACF: this help with categorising in the back end. Please use effectively. - payment gateway-woocommerce/stripe: We are currently using both but I would like to really know if you have some skill in using Stripe and using its powerful features. - shipping fees need to be adjusted (increase the current shipping fee by +£40). Sort by weight but also cheaper models of watches and dials under £1000 will have a different shipping fee (I will inform you of this) all shipping fees...
I am looking for a web developer to create a simpl...events. 2. Calendar Page A calendar view displaying the month's planned coaching releases and team events. 3. Tools Page A page for team members to download relevant tools or files. Requirements Clean, simple, and responsive design. Secure login system with individual codes. The ability to embed Vimeo videos seamlessly. The ability to update the calendar and coaching lists easily. Deliverables Fully functional website with the specified features. Guidance on how to manage and update the site after launch. If you are interested in this project, please provide: Your estimated timeline for completion. Examples of similar projects you’ve worked on. Your proposed budget for the project. Looking forward to working ...
Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days
I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.
I need my WordPress theme customized with my company's branding. Requirements: - Adjust the color palette to my specific color codes. - Edit texts to reflect my company's services. - Incorporate logos and adjust fonts accordingly. Please review the theme here: Skills Required: - Proficiency in WordPress - Experience with theme customization - Understanding of color theory and branding I have the color codes ready and would like to start as soon as possible. Please provide your quote for this project.
I'm looking for a skilled e-commerce developer who can create a Shopify-based online store for me, similar to www.coop.co.uk. Key Responsibilities: - Copy pro...product and promotion banners. - Implement specific features including: - Customer reviews - Wishlist functionality - Live chat support - Delivery area checker based on UK post codes - Schedule delivery setup (choice of delivery date and time) Ideal Skills and Experience: - Proficiency in Shopify - E-commerce website development experience - Graphic design skills for product and promotion banners - Familiarity with implementing interactive website features - Excellent attention to detail for copying product descriptions and images Please include examples of Shopify e-commerce websites you have devel...
...Activity: Users will log in by scanning a QR code with their device's camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user ...
I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)
I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accur...
...that reflects our brand identity while maintaining a clean, timeless look. Design Requirements: Color Theme: The primary theme should revolve around gold, silver, or earth tones (e.g., soft browns, greens, or taupes). Designers can choose one primary theme or blend two of the three (e.g., gold and earth tones, or silver and gold) for a harmonious and luxurious palette. Artistic Focus: The “V” in Veluve should be a focal point, with artistic detail that makes it stand out. Think elegant, intricate, yet not overly complex—details that subtly capture the eye and exude luxury. Logo Style: The design should depict elegance and simplicity. Avoid overly busy or ornate elements. The logo can either: Stand alone as a symbol/icon for representation. Be integrated int...
...some corrupted ZIP files. These files contain WinAce split files and RAR split files, which in turn hold various multimedia components, specifically game files. - Ideal Candidate: Someone with experience in file recovery, specifically with ZIP files, WinAce and RAR. - Skills Required: Proficiency in data recovery software, attention to detail, and understanding of multimedia and game files. Your expertise will help me recover these files for use. I need someone to help me to recover 120 mb of files that I really need to recover. I have tried to fix these corrupted files with repair software such as WinRAR, DataNumen Zip Repair, DiskInternals ZIP Repair, but it doesn't work. The only way we can do is extract the hex code from ...
I have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural language proc...
I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports for CSV data import I ...
...templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these closely. Skills needed for this project include: - Proficiency in Zoho Writer...
...animator to create a 40-second explainer video for my business, which specializes in customized water bottle labeling with QR code integration for marketing and branding purposes. The video should: 1. Visually demonstrate how our product works (e.g., scanning QR codes on water bottles to access menus, coupons, websites, etc.). 2. Highlight the branding benefits for cafes, restaurants, hotels, and event planners. 3. Be engaging and visually appealing, using a friendly and professional tone. --- Scope of Work: 1. 3D Animation: A water bottle with customizable labels (featuring QR codes and logos). Scenes include scanning QR codes, viewing digital content (menu cards, offers), and branded bottle designs in real-world settings. 2. Voiceove...
I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do ...problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues -...
...graphic designer to refine an existing low-fidelity logo and create a comprehensive set of deliverables, including a short style guide. The logo must be rendered in multiple high-fidelity formats suitable for use across various applications, such as business cards, websites, signage, and more. Scope of Work: 1. Logo Refinement: • Convert an existing low-fidelity logo into high-fidelity, professional quality. • Ensure the logo design is scalable and adaptable for various formats. • Make minor adjustments (if necessary) to enhance clarity and visual appeal. 2. Deliverable Formats: Provide the following file types for the logo in both color and black-and-white versions: • Vector Formats: .AI, .EPS, .PDF • Raster Formats (High Resolution): .PNG...
Living Room Redesign Project General Description: Our living room is the heart of our home, a space where we spend most of our time as a family. We are a family of four: myself (I return home late in the afternoon), my wife (a teacher and marketing consultant who often works from home), and two daughters aged 18 and 13 (who use the sofa and TV for leisure and study). We would like to optimize this space to meet everyone’s needs, combining functionality, aesthetics, and comfort. Project Objectives: 1. Space Optimization: Make the space welcoming, practical, and organized, maximizing every square meter. 2. Multifunctional Areas: Create well-defined zones (relaxation, study, socializing) without compromising the room’s openness and brightness. 3. Contemporary D...
I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.
I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions Saudi Days: Sunday to Thursday Session: 11:00 AM – 3:30 PM Daylight Saving Time: Not applicable UAE Days: Monday to Friday Session: 10:00 AM – 2:00 PM Daylight Saving Time: Not applicable London Days: Monday to Friday Session: Standard Time (October to March): 11:00 AM – 7:30 PM (AST) Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST) US Days: Monday to Friday Session: Standard Time (November to March): 5:30 PM – 12:00 AM (AST) Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST) I want to make excel template to -plan and track staff...
necesito ejecutar scripts python, estos scripts lo que hacen es : 01 - generarme archivos Excel, modificar módulos dentro del libro Excel, 02 - Subir a la base de datos que los archivos ya fueron generados 03 - Subirlos a Gdrive y obtener el enlace de descarga 04 - subir a la base de datos el enlace generado. todo esto ya esta hecho, lo que necesito poder hacer que mediante un botón en mi pagina web, php, ejecute los script python. Lo he estado haciendo con Flask y Ngrok de manera local.
I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns and fixed option...
I need assistance extracting data from PDF files into a structured Excel table. The data is primarily in table format and the formatting is consistent throughout the document. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data extraction from PDF - Attention to detail - Ability to follow instructions carefully
I need a professional to help me modify and reinforce an additional room on my mobile home to meet state inspection codes. This room is approximately 10 by 17 feet and will be used as an extended bedroom. Key Tasks: - Structural corrections to reinforce the room - Modifications to meet state inspection standards - Use of wood panels for exterior finishing Ideal Skills: - Expertise in structural engineering - Experience with mobile home modifications - Proficiency in using wood panels for construction
I need an architect draftsperson for ongoing design work including full sets of architectural plans, MEP and structural plans. Must be familiar with USA building codes and regulations
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
...Website and Software for our organization. The solution should include the following features: Core Features Domain & Hosting: Includes domain registration (.in) and hosting services. SSL Certificate: Secure website with SSL encryption. Business Emails: Set up two business email addresses. Membership Management: ID cards with QR codes for members. Appointment letters with QR codes. Certificates for members with QR codes. Donation Management: Donation receipts with QR codes. Accept donations via payment gateways (Razorpay or PhonePe). Cash donation management with QR-coded receipts. Visitor Engagement: Ability to issue certificates with QR codes to visitors. Option for visitors to donate without membership. Communication Tools: Admin messagi...
I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows: - One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements. - Data Type: The primary data being used in these sheets is a combination of text and numbers. Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorably if you can provide example...
I require assistance with data entry into an Excel sheet. The data is currently stored in databases and consists of a mix of numeric and textual information. The data needs to be categorized by department in the Excel sheet. Ideal skills for this job include: - Proficiency in Excel - Experience with data entry - Ability to categorize data effectively - Attention to detail - Familiarity with databases
