Excel vba select indirect range jobs
I'm in search of a talented illustrator who can bring to life my children's adventure book aimed at 8-10 year olds. The ideal candidate should have a strong portfolio of cartoonish style illustrations, as this is the preferred aesthetic for the book. Key requirements: - Proven experience in illustrating children's books, particularly in the 8-10 year age range. - Exceptional skills in creating engaging, high-quality cartoonish illustrations. - Ability to translate an adventure theme into captivating visuals. - Strong understanding of how to balance illustrations with the text for this age group. Experience with adventure-themed illustrations is a plus. The objective is to make the book visually appealing and accessible for young readers. Please attach relevant samp...
I'm looking for a video editor to create a 12-15 minute highlight reel of the top 10 funniest moments from the Kill Tony comedy show. Key Requirements: - Seamless editing with a moderate pacing and smooth transitions - Incorporation of subtle background music to enhance the viewing experienc...funniest moments from the Kill Tony comedy show. Key Requirements: - Seamless editing with a moderate pacing and smooth transitions - Incorporation of subtle background music to enhance the viewing experience - Adding captions for spoken words in a clear and engaging manner Ideal Skills and Experience: - Proven experience in video editing, particularly with comedy or highlight reels - Ability to select and integrate appropriate background music - Proficient in creating clear and well...
...(8-10) slides with Bible verses and questions which display along with an audio overlay during our break for group discussion (we stop filming). 3. They add our branded outro clip. 4. They upload the video to YouTube as a private video Another volunteer creates the YouTube title, video description with video chapters, and turn on subtitles. a. Prior to setting up the premiere or publishing, they select appropriate hashtags and video tags, they add video promotional cards and end screen, and create attractive and engaging custom thumbnails that feature the speaker. b. Create YouTube community post c. Create social media graphics and captions posts to promote the video premiere d. They also attempt create YouTube shorts to promote the long video using AI when possible Our fra...
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...Initial consultation and requirement gathering UX/UI design approval Development milestones Testing phase Launch preparation Go-live support Post-launch optimization Your Proposal Should Include: Your experience with similar projects Portfolio of relevant work Approach to project management Timeline breakdown Communication plan Pricing structure Post-launch support options Budget: [Your Budget Range] Payment Structure: 25% upon project initiation 25% upon design approval 25% upon development completion 25% upon successful launch Timeline: 8-10 weeks Looking for someone who can: Take full ownership of the project Provide regular updates Communicate effectively Problem-solve independently Deliver high-quality work Maintain long-term relationship for updates Please share exam...
...developer/team to create a mobile app for managing hospital admission details for employees and their dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
I'm seeking an Excel expert to help build a dashboard for a monthly employee task tracker. The excel sheet is on Google shared folder so we need to work together The dashboard will need to display: - Employee names and tasks completed - Performance metrics The visualization of the data will primarily involve: - Charts and graphs This dashboard will be used by: - Managers Ideal skills for this job include: - Advanced Excel proficiency - Experience with data visualization - Understanding of performance metrics Please bid if you have the relevant experience.
...multiple years. Key features of the project include: - Building the dashboard on a SQL server DB, with provided design and data. - Using DONT net framework 8, JavaScript, AJAX, and , without the use of BI tools. - Ensuring high performance and an excellent interface focused on superior UI/UX. - Creating multiple models based on available indicator data. - Allowing user interaction to select sectors, indicators, and filter by regions and years. - Providing flexibility for users to change chart types from linear to bar, pie charts, and others. The primary purpose of this dashboard is for thorough data analysis. It will be used by analysts, managers, and the general public, so it needs to be intuitive and accessible. Ideal skills for this job include: - Extensive experience wit...
... Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses and actionable recommendations based on campaign data. ...
I'm looking for a full-stack developer experienced with Magento2, Hyva Theme, and Elastic Suite. The task involves implementing a Vehicle Compatibility feature on our platform. Key Responsibilities: - Allow customers to select a manufacturer, model, and specific variant to filter compatible products. - Generate user-friendly URLs based on the selected vehicle. - Implement a memory function to remember the last selected vehicle for returning users. - Ensure smooth integration with Elastic Suite for efficient searching. - Create a solution for future brand or model imports via CLI. We can provide CSV files for vehicle manufacturers and models. The primary focus of this project will be improving ease of navigation for our users, so prior experience in UX design will be a plus. ...
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
...in need of a ready-made eSign solution for contract signing with my clients. This system must seamlessly integrate with my existing cloud-based predictive dialer through API and accommodate a custom in-house eSign solution. Key Features: - Admin User Capabilities: - Manage and design PDF templates - View real-time reporting on contracts - User management - User Agent Functionalities: - Select and send contract templates - Prompt for asking CC email - Track PDF report Ideal candidates for this project should possess: - Extensive experience with eSign solutions - Proficient in API integration and predictive dialers - Proven track record in creating user-friendly, efficient systems for contract management and tracking. I'm seeking a long-term developer who can i...
This project involves manually searching through a list of Facebook groups for posts containing offers and events (e.g., "Happy Hour," "Live Music"). The freelancer will identify relevant posts, extract key information such as location names and Facebook links, and compile the data into an Excel spreadsheet. They will also download and save images of the event locations. The search period for this project is from January 1st to January 7th. Evaluation Questions: 1) Describe your experience with manual data entry and data organization. 2) How would you approach the task of efficiently searching through multiple Facebook groups and identifying relevant posts within a short timeframe? 3) Imagine you encounter a Facebook post that mentions an event but does not ...
...Support Coordinator – Prague Overview: My Abroad Ally () is seeking a bilingual (Czech/English) freelance Local Support Coordinator in Prague to assist with student mobility projects. This is a part-time position (20 hours per week) with the potential for full-time engagement after six months. We offer competitive pay aligned with the local Prague market between 250-370 CZK range, depending on experience. Key Responsibilities: 1. Internship Placement: - Proactively connect with small to medium-sized companies in Prague to secure internships for Erasmus European students. - Comfortable making sales calls and building relationships. 2. Logistics Coordination: - Arrange local transportation, including airport transfers and public transport passes. 3. Group Support: - Provide
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
...troubleshooting I'm developing a Flutter app that will use native IOS AVFoundation for camera code. Below are the items i'm looking to add to my Existing starter project. Looking for someone to collaborate with me closely on the project. 1. **Video Capture** - **AVCaptureSession**: Use `AVCaptureSession` to manage the flow of data from input devices (like the camera) to outputs. - **AVCaptureDevice**: Select and configure the camera as the input device. - **AVCaptureVideoDataOutput**: This output allows you to access each frame of video data as it's captured. You can use a delegate method to process each frame. 2. **Buffering Frames with DispatchQueue** - **CMSampleBuffer**: Each frame is captured as a `CMSampleBuffer`. You can access the pixel buffer and metad...
I'm looking for a versatile worker to join our expanding team. Since 2009, we've been in the industry and now we're broadening our horizons. The ideal candidate should be proficient in a range of tasks, with a particular emphasis on Google Ads management and SEO. Key Responsibilities: - Overseeing and managing our Google Ads campaigns. - Conducting keyword research and optimization. - Implementing on-page SEO techniques. Skills and Experience: - Proven track record in Google Ads management. - Experience in keyword research and on-page SEO. - Versatile worker able to handle multiple tasks. - Prior experience in an ongoing SEO support role would be an advantage.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will be available IMMEDIATELY without delay and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify and Wordpress - Familiarity wit...amount of hours you have available for work today immediately. This part will be taken seroiusly and won't be open for negotiation. If you can't work full time in the US time zone or if you are not bidding with your correct hourly rate, then this project is NOT FOR YOU. If you bid with a placeholder bid or change, keep in mind that you will not be paid anything more than this budgets specified range and your bid serves as agreement to this condition. Th...
I'm aiming to develop a commission based sales model for a diverse range of physical products, primarily targeting the online e-commerce space. This will encompass everything from consumer electronics to clothing and home goods. Key Responsibilities: - Create a comprehensive, scalable sales strategy - Implement a commission-based incentive structure for sales representatives - Monitor and adjust the sales model based on market response and sales data Ideal Skills: - Extensive experience in online e-commerce - Proven track record in sales strategy development - Familiarity with a diverse range of physical products - Ability to analyze market trends and sales data
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
I'm looking for a skilled web developer to create an educational website that sells eBooks and educational materials. Key features of the site will include: - eBooks and Educational Materials: The primary content of the site will be a range of eBooks and other educational materials. - Shopping Cart: The website needs to have a smooth, user-friendly shopping cart for hassle-free purchases. - Online Access: Customers should be able to access their purchased materials through a secure online portal, rather than via direct download or email delivery. Ideal candidates should have a strong background in eCommerce website development, with specific experience in creating educational websites highly desirable. Skills in SEO and digital marketing would also be a plus, as I would like...
...Visualization and Reporting: - Create interactive dashboards using tools like Power BI or Tableau. - Provide meaningful visualizations such as charts, graphs, and heatmaps for easy interpretation. - Prepare a detailed final report with actionable recommendations. Requirements: - Proficiency in Python, R, or other statistical programming languages. - Experience with tools like Excel, Power BI, or Tableau for visualization. - Strong understanding of statistical methods and data modeling. - Ability to communicate insights effectively. Project Timeline: Expected completion within 3 days from the project start date. If you have the required skills and can deliver high-quality results within the timeline, we’d love to hear from you. Please include e...
I am looking for an experienced app developer to create a short video sharing app that is compatible with both iOS and Android platforms. Key Features: - The app's main focus is on facilitating social sharing and interactions. It should have capabilities similar to popular video sharing apps, with an emphasis on user engagement. - The app must include a range of both pre-made and customizable video filters and effects. The filters should be of high quality and enhance the overall user experience. - Allow users to create and customize personal profiles, including bio, profile picture, and personal details. - Enable following and follower functionalities so users can keep track of their favorite content creators. - Include features to like, comment, and share videos for enhanced...
I'm looking for an experienced SEO professional to help increase my website's Domain Authority (DA) from its current range of 20 to 40, to a target of 40 to 50. Skills and Experience Required: - Proficient in SEO, with a focus on Domain Authority enhancement - Previous experience with backlink building, as this is the strategy I have previously implemented - Knowledge of other SEO strategies such as content marketing and on-page SEO Please provide a detailed plan of how you intend to achieve this goal, along with your estimated timeline for the project. I am particularly interested in your strategies for backlink building, as I understand this can have a significant impact on Domain Authority.
I'm hosting a vibrant, inclusive dance party and need a talented designer to help me create around 10...increase event attendance. Key Requirements: - Experience in social media ad design, particularly for Facebook and Instagram - Proficiency in Canva, as the ads will be created using this platform for easy future edits - Understanding of the Queer community and its culture, to deliver ads with the appropriate tone and style - Ability to design engaging, eye-catching ads that appeal to a wide age range (18-80) Tone and Style: The ads should embody a 'Queer, kooky and cool' aesthetic. Arab cultural background a bonus. Target Audience: The ads should be designed to appeal to an inclusive dance party for the Queer community,. Please provide examples of your previo...
...each design from below. Submit 2 sample designs to be considered. Design Requirements: Animal Prints: 1. Leopard: Classic and chic; works well with trendy and fashionable outfits. 2. Zebra: Black-and-white stripes for a striking and modern design; minimalist yet bold. 3. Tiger: Fierce and adventurous with bold stripes; consider vibrant colors like orange, black, and white. 4. Cats: Designs can range from realistic to cartoonish. Appeal to casual wearers and feline lovers. 5. Dogs: Incorporate fun, playful elements like paw prints or dog faces. Appeal to pet lovers of all kinds. Creative Approach: Designs should combine playful and cute elements with bold, trendy patterns. Use the bright and vibrant Pantone palette provided for reference. Final File Format Requirements: File ...
...Barcode (see attachment) / recycling logo / CE Mark (Certified European) - The sides of the box should some real life images with people on the couch watch the projection of the beamer with a movie on it (if is possible) - The top of the package (where the packages closes and opens) should be our logo. Observations: - I am open to suggestions or if you have better idea just do it and I will select which one I think is better. - You can google Mini beamer projector to get more ideas about this product and his futures (smart tv, Netflix, Disney ...etc) - If you require more informations from me please text me. Key Requirements: - Experience in product package design, particularly for electronics - Strong branding and visual design skills - Proficiency in working with bold colo...
Embedded systems, PCB boards, mobile applications, websites, web solutions, products from scratch, CRM and ERP systems, as well as custom corporate solutions. We’re looking for a skilled engineer who excels in communication and has a confident command of spoken English at B2 level or higher. Responsibilities: PCB Design: -Design schematics and PCB layouts for Raspberry Pi-compatible peripherals. -Select components, including power management ICs, MOSFETs, relays, and ADCs. -Generate BOM and Gerber files for manufacturing. Embedded Firmware Development: -Write and debug firmware for STM32 microcontrollers (or equivalent). -Develop drivers for peripherals such as thermistors, solenoids, pumps, and actuators. -Implement communication protocols (I²C, SPI, UART, GPIO). ...
...I'm looking for an expert in Excel and astrology software integration. The primary task involves data import/export between the two platforms (excel and software). Please note, the data to be transferred/extracted encompasses specific fields from the astrolog software. Ideal Skills: - Proficiency in Excel and creating macros - Experience with software or with any astrology software that uses swiss ephemeris - Data management skills - programming skills to pull out data from () - be able to connect data from excel and the astrology software I will be placing dates and times into excel, and then I want to click a button and extract out info from software and paste it into the excel worksheet. The data I want
I'm in need of an experienced video editor for a variety of upcoming projects. Key responsibilities: - Editing a range of video types including promotional and tutorial videos, with advanced effects and animations. - Utilizing Adobe Premiere Pro exclusively for all editing tasks. Ideal candidates should: - Be proficient in using Adobe Premiere Pro. - Have a strong background in video editing, particularly with creating advanced effects and animations. - Be able to handle multiple projects in a timely manner. If you're passionate about video editing and have the skills necessary to bring my videos to life, I would love to hear from you! Contact on WhatsApp 7247827956
...templates, javascript and mysql database, I need an experience developper who can improve an existing page that shows a table layout with currently 8 columns and at the left hand side several filter options (form with submit button and dropdownlists and typeahead datalists). The goal is to significantly improve usability by having the filter options at the head of the columns and alllow the user to select/input data in the filters and have the software automatically filter the data (using javascript and fetch, but other suggestions are welcome). Some of the logic behind the filtering also needs to be changed, for example users can filter on one lastname using a typeahead freelist/datalist, but this filter should be modified to return all records found having this lastname (or ha...
I'm in need of a professional to create engaging and curriculum-aligned weekly lesson plans for my Pre-K students. Details: - The plans should cover a variety of subjects, including Math, Language Arts, and Science. - Each plan should include a diverse range of activities, such as hands-on activities, storytelling sessions, as well as music and movement. - Incorporate (SWBAT) - 'Students Will Be Able To' and (IOT) - 'In Order To' statements for each activity. - Each lesson should align with the Pennsylvania Pre-K learning standards. Ideal candidates should have a background in early childhood education, with specific expertise in Pre-K curriculum development. Experience with Pennsylvania's educational standards is a plus. Creativity and a pa...
...Collection:** - Use tools like Lusha, , and any additional necessary platforms. - Identify target companies and their main subsidiaries across the specified regions. - Gather detailed contact information, including **personal emails and phone numbers** of CEOs, CFOs, and key decision-makers. 2. **Data Organization and Delivery:** - Structure the information in an Excel sheet or database, ensuring it includes company details, locations, and contact hierarchy. - Deliver contacts progressively for quality verification and catalog integration. 3. **Verification:** - Cross-check all collected data for accuracy, reliability, and completeness. **Requirements:** - Expertise in tools like Lusha, , and other B2B data platforms. - Strong skills
...should seamlessly integrate both aspects, offering users a comprehensive travel information platform. Core Features: - A functional services booking system, razorpay payment page to be integrated. - Detailed information on travel services that I offer. Travel Blog: - The blog section will primarily host travel guides: These need to be well-written, engaging and informative, covering a wide range of destinations and travel tips. Ideal Skills & Experience: - Proven experience in web development, particularly for travel-related sites. - Strong skills in e-commerce and booking systems. - Excellent content creation and SEO skills for the travel blog. - Previous work showcasing clean, elegant website design would be highly beneficial. I'm looking for a freelancer who ca...
Hi there! I'm often working in Google Sheet and Microsoft Excel and need a formula or some random tips and advice on how to make my sheet better, make my formulas cleaner, or macros written. It's not a full time job, or even consistent work. I'm looking for something like a co-pilot, preferable on Slack that I message any time. There might be weeks or even months where I don't need the help, but I know there is someone to help on hand when needed.
I'm looking for a dedicated academic writer who can join me full-time for a monthly pay of SGD 500. This person will work for 8 hours a day and assist me with a variety of academic writing tasks across different subject areas. The role is diverse, covering the Sciences, Humanities, and Social Sciences. Responsibilities: - Writing and editing a range of academic papers - Conducting thorough literature reviews - Assisting with data analysis and interpretation - Completing various assignments Ideal Skills: - Strong command of English and excellent writing skills - Prior experience in academic writing - Proficient in conducting literature reviews - Competent in data analysis - Able to work full-time for 8 hours a day This is a great opportunity for someone looking to immerse the...
I'm looking for a web developer to assist me in creating a random question paper generator website. Key Features: - A platform where teachers can input their own questions - Capability to handle a wide range of subjects: Mathematics, Science, Languages, and beyond - User-friendly interface Ideal Skills: - Proficient in web development - Experience in creating interactive and user-friendly websites - Knowledge in handling educational content and tools
...sector. The ultimate objective of this campaign is to secure Letters of Intent (LOIs) from these companies. Key areas of focus: - Platforms: Your expertise should span across social media, email marketing and content marketing (including blogs and articles). I need a strategy that utilizes these channels effectively to reach and engage potential partners. - Content: The campaign will need a diverse range of content types. You should be able to create and deliver written content, visual content (like infographics) and videos. The aim is to deliver compelling, engaging content that encourages interaction and interest from the target audience. Ideal skills for this project would include: - Proven experience in digital marketing, particularly in customer engagement strategies. - S...
I'm looking for a data-savvy professional to assist me with analyzing and processing some wine investment fund data. Key Responsibilities: - Data entry: You'll be entering data from Excel spreadsheets into other required formats or systems. - Financial Analysis: You'll need to interpret the data and provide insights into trends, valuations, and potential investment opportunities. - Investment Research: I need you to conduct thorough research on possible investment opportunities within the wine market. Skills and Experience: - Proficient with Excel and other data processing tools. - Strong understanding of basic finance and investment concepts. - Prior experience in analyzing financial data and conducting investment research is a plus. - A passion for wine or...
I will add these features on the Form - * Please add the header content, logo & steps to use the form as provided in the reference excel sheet. * The user should be allowed to fill the form only if the selection is 'Yes' * Please check the verbiage in the first page (Specially under Residency information - Canadian tax return (also check the order of questions here) & Residency information -US tax return) * In UN25, the selection should be a tick mark instead of just a dot. * Changes regarding the appendix as discussed in the call and also as highlighted in #3 in our previous mail. *U9 to U39, UN1 to UN25 (when a user clicks on the 'Yes', the alert box is not changed as per the previous requirement. I guess you have missed from the previous requirement...
I'm in need of a Python script that can download an Excel report from a public website every hour and upload it to a designated portal folder without any modifications. - **Task**: Script should perform the following tasks - Download an Excel report from a public website every hour. - Upload the report to a specific portal folder without any modifications. Ideal Skills: - Proficient in Python programming. - Prior experience with web scraping and automating tasks. - Familiarity with working with Excel files in Python. - Knowledge of file upload protocols and processes.
I need help creating an automated process using make or Zapier and various tools. The following should be done: 1. we use the form system “Jotform”. There we use a form for telephone order acceptance. The orders are divided into 4 different categories. Locksmith service, vermin removal, pipe cleaning and electrician work. 2. we record the data and select the respective category from a drop-down menu. 3. depending on which category is selected, a different scenario or a different route must be taken. 4. for each route, the content of the form must be sent by message to 3 different numbers via Whatsapp. This works e.g. via Twilio and the Whatsapp Business API (I assume). 5. if the message “ok” has not come back from at least one person in the chat for the...
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I'm looking for a skilled Virtual/Administrative Assistant to support me, a busy C-Level Executive. The ideal candidate should possess 3-5 years of experience, particularly in: - Project Management - Business Calendar Management - Copywriting - Task Prioritization - Researching - Personal Task Management (Daily, Weekly, Monthly) - Proficiency in Microsoft Office Suite (Excel, Word) - Excellent Typing Skills - Coordinating Contacts Meetings - Outbound Phone Support - Data Entry (with Excellent Accuracy) - Other Related Business Tasks To start with, I require 5-10 hours a week. The most crucial skills for this role are Project Management, Calendar Management, and Copywriting. Your primary focus will be on managing my business calendar, so experience in this area is vital. Add...
I'm in need of a straightforward, user-friendly website for my construction company. It...primary goal is to facilitate lead capturing and communication with potential clients. Key Features: - A call us now button so customers can reach us directly - A simple contact form on the contact page, to streamline inquiries and requests for quotes. - An 'About Us' section, providing visitors with insight into our company's mission, vision and team. - A 'Services Offered' section, detailing the range of construction services we provide. Ideal Skills: - Proven experience in web development, particularly for service-oriented businesses. - Strong understanding of lead capture mechanisms and user-friendly design. - Excellent skills in conveying company informati...
