Professional accurate forex system jobs

I'm in need of a professional logo for my news website. I'm seeking a logo that conveys professionalism. Clean, modern, and sleek design with a touch of uniqueness would be perfect. The logo will be the face of my brand, so it should be memorable and easily recognizable. Ideal skills and experience for this job include: - Proven track record in graphic design, particularly logo design - Ability to interpret brand identity and values into visual design - Strong understanding of color theory and typography - Creativity and originality in design approach Need 2 - 3 variation. So client can choose final version.

I am seeking a proficient Revit and AUTOCAD user to create detailed structural plans. As a structural engineer, I have already completed all necessary calculations. Therefore, no additional computations are required for this project. The primary task will be to draw the plans according to my specifica...have already completed all necessary calculations. Therefore, no additional computations are required for this project. The primary task will be to draw the plans according to my specifications. Please note that this project solely involves drafting; all engineering aspects have been addressed. The successful candidate should have a strong understanding of Revit and be able to produce detailed, accurate plans based on the information provided. Looking forward to working with you. ...

I'm in immediate need of a talented 3D artist who can model characters with precision for an exciting project. Your creation will lay the lifeline for a captivating animated presentation. Your responsibilities will include: - Creating accurate and detailed 3D models of specified characters - Using creative freedom within given guidelines to bring each character to life You should ideally: - Have demonstrated experience in 3D modeling, specifically characters - Understand the nuances of character modeling for animated presentations - Be able to complete this project urgently, while maintaining quality It's an immediate requirement, so if you think you're the right fit, get in touch ASAP. Bring your skill and creativity to this engaging project.

I am in need of a skilled individual who can create a robust and highly functional ERP system for me. This system should encompass: - Inventory Management - Sales and Purchase Management - Human Resources Management In addition to the above, I also require the system to handle Manufacturing Management, with a focus on: - Production planning and scheduling - Inventory control - Quality assurance The ideal candidate for this project will have extensive experience in system development and a comprehensive understanding of ERP systems. You should be familiar with all the mentioned functionalities and able to deliver high-quality results. Kindly note that im looking for some in Riyadh KSA

...value. The game continues in turns until one player has no cards left. Winning Criteria: - The first player to play all their cards wins. Technical Requirements: - User Interface: - The app should have an intuitive and engaging interface. Smart, clever use of interactive elements like shaking the app to shuffle the cards or tilting the phone device downwards to deal? Gameplay Mechanics: - Accurate implementation of the game rules. - Smooth card-flipping animations and sound effects. - Mechanism to track and display the number of cards each player holds. Metrics/Scoring/tracking the play: - Display on who’s winning. - Gamification basics: - Leaderboard for when players are in play. - Display winners. - Add a series of ways to win - Like choosing ‘Best out ...

Thanks for your message and you're welcome? In Professional Training Band??????????. This one is one the professional interpreter and translator band. In case of interpretation we ask 50$/hour and that of translation we ask 10$/page. We're based on these languages: * english * spanish * french And national languages such as: * Kikongo * Lingala * Swahili. (Removed by Freelancer.com admin)

I need a competent writer with a strong understanding of computer science to help me research and write content for a web-based system. Key Requirements: - Proficiency in various areas of computer science, particularly in Artificial Intelligence, Data Science, or Cybersecurity. - Ability to thoroughly research and cover a range of topics within computer science, such as Machine Learning, Algorithms, or Network Security. - Excellent writing skills and the ability to articulate complex technical concepts in an engaging and easy-to-understand manner.

I need a capable and experienced writer to research and write about an IT-related topic for me. Key requirements: - Expertise in relevant IT fields such as Blockchain technology, Artificial intelligence, or Internet of Things - Strong research skills to ensure the content is informative, accurate and up-to-date - Ability to write in an engaging yet professional manner

I have a batch of PDF documents that need to be converted to fully editable Word documents. The PDFs contain complex tables and layouts that need to be accurately replicated in the Word files. The primary goal of this conversion is to enable easy editing of the text and layout in the Word documents. Ideal skills and experience for the job: - Proficiency ...and layouts that need to be accurately replicated in the Word files. The primary goal of this conversion is to enable easy editing of the text and layout in the Word documents. Ideal skills and experience for the job: - Proficiency in PDF to Word conversion - Expertise in handling complex tables and layouts - Attention to detail to ensure text and formatting consistency - Ability to deliver accurate and fully editable Word...

I'm looking for an experienced copywriter to transcribe a hand-written storybook with over 5000 words into a Word document. It's crucial that the transcribed content is clear and accurate. Key Requirements: - Transcription of handwritten notes into a Word Document - Content editing for clarity: Ensuring the text is coherent and flows well Ideal Skills: - Excellent copywriting and transcription abilities - Strong grasp of the English language, grammar, and storytelling - Previous experience in content editing and proofreading Please respond with a brief summary of your relevant experience and your proposed approach to managing this project. Feel free to provide any samples of your previous work. Thank you.

I have a draft form that I would like to convert into a professional, polished fillable PDF using Adobe Acrobat. The form is between 1-5 pages long. Key Requirements: - Incorporate text fields and checkboxes from the draft - Ensure the form is user-friendly and easy to navigate - Integrate my company's logo into the design Ideal Skills: - Proficiency in Adobe Acrobat with experience creating fillable PDF forms - Attention to detail and the ability to ensure the form is aesthetically pleasing and consistent with my brand - Ability to implement logical tabbing order and form fields for smooth navigation. Note: If you have a strong graphic design background and can suggest enhancements to the form's design, feel free to share your insights.

I'm seeking a highly skilled 3D renderer who is capable of creating a photorealistic, accurate render of a product. The product in question is a pair of smart glasses. I would specifically require material finishes involving plastic, glass and metal incorporated into the render. Ideal applicants should have: - Strong experience in photorealistic 3D rendering, especially of products. - Proficiency in applying various textures and materials to the model (in this case, glass, metal, and plastic). - Good knowledge of rendering software and tools to achieve high-quality results. - Fine attention to detail to recreate realistic representations of smart glasses. Your portfolio or samples of previous work will significantly influence our decision. Your understanding of reflective and l...

I'm looking for a detail-oriented professional to support my business with bookkeeping and budget management tasks. Key Responsibilities: - Accurate management of accounts payable and accounts receivable in QuickBooks - Regular bank reconciliations to ensure that all transactions are accounted for correctly Ideal Skills and Experience: - Proficiency in QuickBooks software - Prior experience in accounts payable/receivable and bank reconciliations - A keen eye for detail and accuracy - Strong organizational and time-management skills The role will require weekly input, but this may vary depending on the size of transactions. Please provide an estimate of your hourly rate in your bid.

I need a professional translator to assist in translating our legal documents from Arabic to English. Key Points: - The documents are legal in nature, so it's crucial that the translator has experience in this field. - The Arabic language proficiency required is basic, but having experience in legal translation is a must. Ideal Skills and Experience: - Prior experience in translating legal documents - Proficiency in both Arabic and English - Understanding of legal jargon and document structure - Ability to deliver accurate and high-quality translation - A professional who can maintain confidentiality of the documents If you meet the criteria and are available to take on this project, please get in touch.

I need an experienced CRM expert to develop a customer relationship management system tailored for my business needs. Key Functionalities: - Contact Management: In-depth contact organization, segmentation, and efficient communication tracking. - Lead Tracking: Robust lead capture, tracking, and conversion analysis. - Sales Forecasting: Accurate prediction of sales trends and opportunities based on the CRM data. User Base: - The CRM system will be used by 1-50 users, so it should be user-friendly, scalable, and efficient. Integration: - It's imperative that the CRM can seamlessly integrate with other systems, particularly: - Email Platforms: For streamlined communication and lead nurturing. - Social Media: To enhance customer engagement and acquisition. -...

I need someone with great skills in SketchUp to finish me an exterior design that I have Already started, we'll agree on the price but I need the work to be done in (4 hours max), message me I READ EVERYTHING just to verify you're not an automated reply *note : the file is too big to be uploaded, I'll send it to you on the chat

I'm looking for an experienced graphic designer to create a professional logo. The intention is to evoke brand recognition, professionalism, and visual appeal. Key requirements: - Use of blue, white, black, and silver colors predominantly. - The logo should be attractive and be easily remembered. - Designer who is creative, pays attention to fine details and has an understanding of brand identity. - Experience in creating logos in various formats is a must. The project should be completed within a month. A good eye for aesthetics and strong design fundamentals are the desired skills for this job. Looking forward to creating a captivating logo that enhances our brand image.

I'm in need of a reliable professional to conduct text data entry for magazine advertisements. The successful freelancer should have: - Strong attention to detail - Proficiency in English - Prior experience in data entry, particularly with swift and accurate text input While not required, experience with magazine ad placements could also be highly beneficial, as the task involves inserting advertisements directly into a magazine. However, please note the specific magazine has not been disclosed at this point. Applicants without such specific experience but with proven data entry skills are still encouraged to bid.

I am looking for a talented writer to create engaging and informative blog posts aimed at the general public. The content should be well-researched and accurate, with a focus on educating the readers on a variety of topics. The aim is to present complex information in a way that is easily understood, making it accessible to a wide audience. Ideal candidates should have: - Proven experience in writing informative and educational content - A knack for breaking down complex subjects for a general audience - Ability to conduct thorough research and produce high-quality, original content - Strong communication skills If you are a skilled writer with a passion for creating engaging, informative content, I would love to hear from you.

I am looking for a talented professional to develop a mobile application for both iOS and Android platforms. The primary function of this app would be AI-enhancement, particularly focusing on the Computer Vision feature. Ideal Experience and Skills: * Proficient in iOS and Android development * Strong background in AI, especially Computer Vision * Experience in integrating AI capabilities into mobile apps The app will also have an in-built feature to solve questions, further incorporating the AI function. Make sure that the AI is robust enough to provide accurate solutions. Please apply if you have a proven track record in developing AI-based mobile applications. Demonstration of a similar project in your portfolio will be a plus point.

I'm looking for a skilled web developer who can create a user-friendly, web-based tool that allows our internal staff to generate cost estimates quickly and accurately. Key Features: - The tool should be specifically designed to ...to use and accessible. - It should not support multiple currencies, as all our estimates will be in the same currency. Ideal Skills and Experience: - Experience in developing web-based tools or software, ideally with a focus on generating estimates. - Proficiency in UX/UI design to ensure the tool is user-friendly and intuitive. - Strong understanding of financial systems and tools, to ensure accurate cost estimates are generated. - Ability to communicate effectively and incorporate feedback, as the tool will need to meet the specific needs of our ...

...app that can run on both iOS and Android devices. The primary function of this app should be to generate estimates for pressure washing services. Key Requirements: - Cross-platform compatibility: The app should be designed to work seamlessly on both iOS and Android devices. - Estimate Generation: The app should have an easy-to-use interface which allows users to input key details and get an accurate estimate for a pressure washing job. - Customization Options: I want users to be able to customize their service requests within the app. This could include options for different types of pressure washing, areas to be cleaned, etc. Ideal Skills and Experience: - Prior experience in developing and deploying cross-platform mobile applications, especially in the realm of service-based...

Develop or sketches to run dual processors in circuit as described in schematic , The light, called Eos 24, has three use cases or modes: 1. SW1 is closed: The neopixel runs constantly until SW1 moved to open. 2. SW1 is open: The neopixel runs when the PIR is triggered until interval4 is elapsed. When SW1 is open and interval4 is elapsed Eos 24 is in standby mode and the Neopixel is dark. 3. SW1 is open and interval4 is elapsed. This is standby mode and the Neopixel is dark until the PIR is triggered again.

I am looking for a professional who can help me create a CV and cover letter that will stand out in the UK and Europe recruitment industry. Key information: - Industry: HR - Target roles: Recruitment Specialist, Human Resources Manager, HR Administrator - Essential certifications: SHRM-CP, CIPD, ATS I am looking for a collaborator who can help me secure interviews for these positions. The CV and cover letter will be the first impression employers will have of me, so they need to be outstanding. I prefer someone who is experienced in 1. UK and Europe recruitment 2. Environmental, water resources management, and sustainability field recruitment 3. using HR tools to increase the hiring rate, eg: Applicant Tracking Software ATS The ideal freelancer for this job should: - Have a st...

I'm in need of an experienced developer to create a single-page website for me using WordPress. The primary goal of this websit...disregarded. Key Requirements: - Development of a single-page WordPress website - Theme selection and customization to match a neutral and professional color scheme - Use a specific color scheme as the pages currently showcased on the website: https://prominencebank.com. - Inclusion of a 'Services' section The ideal candidate should have: - Proven experience in WordPress website development - A good eye for design, with the ability to match a neutral and professional color scheme - Strong communication skills to understand my requirements and provide feedback on the design and functionality of the website. Looking forward to work...

...diecut area I need a skilled designer to transform our finished display box design into smaller individual glossy cardboard boxes. The individual boxes need to perfectly mirror the display box design for just the front and back. Key Responsibilities: - Convert finished display box design onto small cardboard boxes - Ensure the design is glossy and visually appealing - Ensure the dimensions are accurate and suitable for small items Ideal Skills and Experience: - Graphic Design: Proficiency in software like Adobe Illustrator or InDesign for creating the designs is crucial. - Packaging Design: Experience in designing product packaging is a plus, as it will help in ensuring the individual boxes are functional and visually appealing. - Attention to Detail: Precision in translating...

I'm working to develop a series of 500 i...500 infographics aimed at UPSC students. These will cover a range of topics, primarily focusing on current affairs and geographical data. Specific Topics: - Economy and finance - Politics and governance - Environment and climate change Level of Detail: - Intermediate level analysis Key Responsibilities: - Creating infographics on the selected topics. - Ensuring the information is current and accurate. Ideal Skills: - Experience in creating educational infographics. - Knowledge of current affairs and geography. - UPSC exam preparation experience would be a plus. Please note that the graphics should be clear, concise, and engaging for a student audience. Your work should support students in understanding and retaining the informa...

I have a web application that runs on PHP and I'm looking to integrate it with APIs provided by multiple suppliers. These suppliers will send us three specific types of data through their ...these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - Detail-oriented to ensure accurate data extraction and display. - Ability to create a seamless user experience through webpage data presentation. This role will be pivotal in ensuring our system remains updated with the latest information from our suppliers and that our users can easily access th...

I'm looking for a skilled professional who can migrate an existing voicemail manager system from Google Script (Javascript) to Office365. The primary purpose of this migration is to rebuild the system on a completely different platform. Key Requirements: - Proficient in Google Script (Javascript) - Familiar with Office365 platform - Previous experience with voicemail manager systems is a plus The ideal candidate for this project should have a strong background in both Google Script and Office365, with a particular focus on migration projects. Since the goal is to enhance the system's reliability, it is important that the freelancer has a good understanding of the intricacies of voicemail manager systems. The project's success will depend on the free...

I'm in need of a professional virtual assistant to support me with a variety of tasks. My preferred mode of communication is through email. Key Responsibilities: - Email Management: Assist in managing my inbox, filtering important emails, and drafting responses - Data Entry: Help with inputting data into spreadsheets or databases as needed - Appointment Scheduling: Support in organizing my calendar and scheduling meetings or appointments Ideal Candidate: - Experience as a virtual assistant - Excellent organizational and time-management skills - Proficient in email communication - Prior experience in data entry and appointment scheduling would be a plus

...certain sectors such as Oil, Gas, IT, Engineering, Aviation, Procurement, Transportation, Architecture and Finance. Everyone else is yes needed. Key Requirement: You will need to find the contact name, position, email and LinkedIn account for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per company. - The information should be accurate and up to date. - If you have a strategy for obtaining this data, please share it in your bid. Skills/Experience: - Strong research skills - Data entry and data mining expertise - Proficient in Saudi Arabian business landscape - Attention to detail and accuracy - Web scraping - Web search - Leads Results should be in an excel sheet format, outlining the name, position, emai...

...discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. Provide guidance and support for the green card sponsorship process concerning tax requirements. Requirements: Licensed and certified accountant with expertise in both US and Canadian tax systems. Proven experience working with dual citiz...

I'm seeking a skilled individual to assist with...individual to assist with a multi-machine power system dynamics analysis and control. The primary goal of this project is to optimize power flow efficiency. Key Requirements: - Proficiency in power systems dynamics and control analysis - Experience with multi-machine systems - Ability to optimize for voltage levels Your responsibilities will include: - Conducting power system dynamics analysis - Implementing control measures to optimize power flow efficiency - Focusing on voltage levels optimization Ideal candidates should have a strong background in power systems, and be able to work on a multi-machine system. This project will require a good understanding of power flow and voltage levels in order to maximize ...

Create a presentation for an annual report in either a Microsoft product (Powerpoint, Word) or Google (Docs, Slides). The presentation will be based on data provided - a draft is attached but it is not yet final. Attached is a style of presentation that I am comfortable with, but another style could also be perfectly suitable. The ability to start on this immediately (after I provide the final draft) and finish it quickly is important.

I am looking for a talented writer to create engaging and informative blog posts aimed at the general public. The content should be well-researched and accurate, with a focus on educating the readers on a variety of topics. The aim is to present complex information in a way that is easily understood, making it accessible to a wide audience. Ideal candidates should have: - Proven experience in writing informative and educational content - A knack for breaking down complex subjects for a general audience - Ability to conduct thorough research and produce high-quality, original content - Strong communication skills If you are a skilled writer with a passion for creating engaging, informative content, I would love to hear from you.

I'm in need of a proficient business writer to assist me in crafting a compelling executive summary for my business plan. This is a specialized task and requires a detailed understanding of business storytelling, summarizing complex business ideas and value propositions into clear, concise language. Ideal Skills: - Proven experience in business writing - Expertise in writing business plan executive summaries - Excellent business acumen and ability to grasp complex ideas Experience: - Experience writing for various business industries would be an advantage - Demonstrated ability in achieving results in tight deadlines I look forward to reviewing your proposals.

I'm seeking a seasoned freelancer to devise a Derby car timer using Arduino ...lane to show timing results. - Winner Identification Feature: An 8x8 matrix screen for indicating 1st and 2nd place finishes. Ideal Skills and Qualifications: - Working knowledge of Arduino programming language. - In-depth understanding of microcontroller-based systems. - Hands-on experience with infrared sensor technology. - Ability to integrate multiple components into one cohesive, functioning system. - Practical knowledge of LED Display systems, specifically the 7-Segment LED HT16K33 Backpack. - Comfortable with crafting solutions for race-based project requirements. In bidding, please showcase your experience with Arduino Uno projects, and if possible, share examples of similar timing systems ...

I'm in need of professionally engineered plans for my existing pergola. The ultimate goal is to certify it for compliance with local council regulations. Unfortunately, I don't have any existing blueprints or architectural plan of the pergola. Ideal Skillset and Experience: - Expertise in creating accurate and detailed engineering plans - In-depth understanding of local council regulations regarding pergola constructions - Ability to work without existing plans or blueprints Your task will primarily involve creating a comprehensive plan to establish its certification for compliance. Please ensure that your design adheres strictly to local council regulations. Previous experience with similar projects required and California license.

Validation of Sample implementation of One Loan product (Business Loan) created by Transdigital team. - Help Transdigital team in End to end testing of the system after product configuration - Creation of Roles and Users - Generation of Reports - Conducting on the job training for Trasdigital Business Analysts

I'm in need of a skilled legal writer to create engaging, informative, and accurate content for my website and LMS module. The content will be primarily focused on criminal law, family law, and intellectual property law. Ideal Skills and Experience: - Proven experience in legal content creation - Understanding of various areas of law, particularly criminal, family, and intellectual property law - Ability to write for an educational audience - Good research skills to ensure the content is accurate - Excellent grammar and attention to detail The main audience for this content will be law students and legal professionals. It's crucial that the content is not only informative but also engaging. It should be accessible to individuals with varying levels of legal knowl...

I'm looking for a skilled developer to help me customize my current PHP SMS system. It's primarily used for sending notifications. I have the script and has been working with twilio, however all of a sudden it stopped working due to twilio changes I need assistance in modifying the script

I am in need of skilled photo editors to assist in improving my photos. Serv...photo editors to assist in improving my photos. Services needed will include: - Background removal and replacement - Color correction - High-end retouching The improved photos should feature solid-colored backgrounds. Ideal freelancers would possess profound skills and experience in photo editing, color correction, and proficient use of editing software. Knowledge pertaining to achieving a professional and clean finish is also a must. Although the specific color for the new backgrounds isn't chosen yet, it'd be beneficial if you could provide recommendations based on the content of the photos. Your input is encouraged! Thank you for considering my project. I eagerly look forward to transf...

I have a series of medical bills that need to be entered into a spreadsheet. The data is primarily textual, numeric Ideal Candidate: - Must have a keen eye for detail to ensure accurate transcription of the printed text into a digital format. - Proficiency in spreadsheet software for the efficient and organized entry of the data. I have attached an example bill and the expected excel format. I have 34 such pages of bill. Overall you will have ~200 rows to be entered.

I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion ...text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content transfer - Attention to detail to ensure a...

...Storybook into Word Document Description: We are seeking a skilled copywriter to transcribe a storybook into a Word document. The job involves typing out the entire content of a storybook into a digital format. The storybook is approximately 100 pages long and contains a mix of text and illustrations. Responsibilities: - Type out the entire content of the storybook into a Word document. - Ensure accurate transcription of text, including proper formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting or transcription preferred. - Attention to detail and abil...

I require an advanced database to streamline church operations. It must include: - Member management: This involves recording personal details of each member, tracking attendance, and allocating to the right departments. Each member's record should also include household and family details, with specific fields for spouse and child...fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database systems, with a keen understanding of how to translate our church's requirements into a user-friendly, efficient system. Knowledge of member management systems wi...

I am seeking an experienced web designer to create a platform that caters to professionals, sharing information in a user-friendly manner. Key Requirements: - Design a use...website is to provide a seamless experience for professionals seeking knowledge. The design should reflect this purpose. Ideal Skills and Experience: - Proven track record in web design: I'm looking for a professional who has a portfolio demonstrating their ability to create sleek and functional websites. - Understanding of user experience: Experience in creating websites that prioritize user experience and ease of navigation is essential. - Familiarity with information sharing platforms: Experience with designing websites that cater to information sharing, particularly in a professional context, ...

I'm in need of a professional QuickBooks Accountant, preferably with a solid background in the services industry. Your main responsibility will be to manage my business's bookkeeping. This isn't a typical bookkeeping role; you must understand the specifics of service-based accounting. Your ability to navigate QuickBooks with ease and deliver accurate results is crucial to this role. Any competent and experienced accountant should apply, but I'll be particularly keen on those with a proven background managing books for service-based businesses.

1. Create a customer registration system 2. Publish ads with a online payment gateway 3. Call button for mobile phone when scrolling needs to call the registered phone number for customer 4. Automatic email reminder for ad expiry and if there is no payment ad has to be removed automatically.

I'm looking for a machine learning expert to create a sentiment classification model for customer reviews. The main objective of this projec...customer reviews. - Sentiment Detail: The model should identify and categorize the sentiment of reviews into Positive, Negative, or Neutral. Ideally, you should have: - Proven experience in machine learning, particularly in sentiment analysis - A strong understanding of natural language processing and text analytics - Previous experience working with customer review data - A track record of building accurate and efficient classification models - Familiarity with platforms like Python, R, and relevant ML libraries If you have experience in similar projects, please share your previous work and let me know how you would approach this sp...