Read text file save unicode file excel vba macros jobs
As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing mapping fu...
This task involves the critical redesign of an existing .fbx mesh file using AutoCAD. Specifically, the surface details need an overhaul to offer a more appealing and professional look. • Redesign: Utilize AutoCAD to modify the current .fbx mesh file. Special attention should be given to upgrade the surface details. • Create STP File: Once the mesh file is improved, I will need a corresponding STP file. Ideal candidates are individuals with significant skills and previous experience with AutoCAD, mesh and STP file conversions. Proficiency with surface detailing is a huge plus. I look forward to seeing portfolios demonstrating similar projects.
As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...
I need to include the content of a PHP file from from a remote server in a simple script on my main server. The script on the main server will execute the PHP to retrieve information from several other sites. I know that this is not the preferred method, but there are absolutely no security risks involved. This is a super simple script that runs a Woocommerce database update. I want to avoid to upload the script on every Woocommerce site for two reasons: 1. I would like to maintain only one single script, if changes are needed. 2. More important: I try to avoid any additional files in the root of a WordPress installation. This can sometimes cause trouble with malware scanners. Just to make this very clear: I don't need the scripts itself. This is all working fine. I need a s...
I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilit...
I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split...split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should h...
I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project b...
I need a proficient Laravel and PHP developer to modify certain elements of my website. It's an e-commerce store, and the specific area of focus is the "Add to Cart" section. Tasks: - Update the existing body text Ideal Skills: - Proficiency in Laravel and PHP - Expertise in editing website text - Familiarity with e-commerce structures, particularly the 'Add to Cart' function Experience in similar tasks would be advantageous.
I'm seeking a well-organized data entry expert who can gather information specifically from online sources and deliver it to me in a text file format. Your exceptional attention to detail and competency in the English language is essential to accurately extract and consolidate the data. Proficiency in using web-browsing tools is a must.
As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...
My Facebook account has been hacked, resulting in Facebook disabling it. Consequently, I created a new account after years, which is under a different user name. I would like to link the new Facebook account to my Facebook page. Additionally, I want to convert the new Facebook Ads account with my profile so that I can launch campaigns on Facebook. Thank you. please read and offer
Hello, I'm in need of an experienced software developer to create a Text Humanizer Software. My website is Users subscribe to be able to convert AI text to text that appears to be written by a human. The software needs to pass AI detection on I'd be testing the software in 15 random tests to determine a winner of the contest. Following the software completion, you'll either need to install it on the website or collaborate with my in-house developer to get it installed. Thanks, Phillip
I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.
I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.
As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generati...
I'm seeking a chef or skilled home cook who can teach me how to cook basic dishes. I am trying to take care of my health and am also going to the gym so I want to have a very strong control over my macros. As I am very new to the kitchen, I want someone to literally hold my hands and guide me. (Live online classes will also do, but highly prefer the classes to be in person) Key Requirements: - You should know how to cook basic dishes like pasta, rice and dal, roti sabzi, boil eggs etc - Your instruction methodology should work for live sessions - demonstrating recipes, guiding me as I try my hand at the dishes, and providing real-time feedback. - If you are someone who goes to the gym and knows high protein vegetarian dishes, that would be a huge plus Please write your propos...
I'm on the hunt for a proficient Facebook ad expert who will drive our digital agency forward on the basis of lead generation and sales. The successful candidate must: - Be knowledgeable and experienced in generating leads and sales through Facebook ad campaigns - Excel at developing and implementing ads targeted towards our tailored audience - Be proficient in designing and promoting compelling video ads Having a background in digital agencies would be highly advantageous. It's paramount for the candidate to be results-driven and have a track record of successful lead generation.
I am currently in need of a proficient system or tool that can methodically...documents. Below are my overall requirements: - The system should be specifically designed for searching document files, which excludes web and email searches. - It should have an excellent capability to find 'Dates' accurately within these documents. - I expect the tool/system to be reliable, fast, and efficient in its operations. The ideal candidate for this task will have a proven background in file searching systems, preferably within document files. They should possess notable skills in data analysis, and should be detail-oriented to ensure accuracy in the search results. Proficiency in programming languages such as Python, Java or similar that could be used to develop such a tool will b...
I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...
I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...
I am looking for a skilled data entry operator who can handle text data in varying formats. Your role involves: - Inputting text data from numerous formats like scanned documents, handwritten notes, and digital text files. - Handling a moderate volume of data with high accuracy and efficiency. Ideal operators should be adaptable, meticulous with a keen eye for detail, experienced in data entry across various formats, and have a substantial speed of typing. The ability to handle multiple types of near formats with ease will be highly valued.
I'm currently facing issues with updating files from SVN repository on SharePoint 2016 Server. After opening a file in Word and attempting to save, I keep receiving the error message "Upload Failed. We are sorry this does not work". Key Duties: - Diagnosis of Tortoise SVN and SharePoint 2016 server integration issue - Solving the aforementioned file update failure error - Implementing a solution to ensure future effective versioning and file saving Ideal Skills: - Proficiency in SharePoint 2016 Server - Extensive knowledge of Tortoise SVN software - Exceptional troubleshooting skills - Understanding of repository management and versioning - Ability to work with Microsoft Word and handle associated errors
I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make an inf...
DO NOT APPLY OR BID UNLESS YOU READ THIS IN DETAIL. ANY BIDS NOT COMPLIANT WILL BE DELETED Project Description: We are seeking an experienced Project Manager with a strong background in systems design to oversee the development of an innovative Wine Cellar Lighting Control System. This system will utilize ESP8266 components for WiFi-enabled control of RGB lighting strings, aimed at enhancing the visual appeal and functionality of wine cellars. Responsibilities: The Project Manager will be responsible for: Defining the project scope and objectives, ensuring technical feasibility. Documenting functional and non-functional requirements. Generating user interaction flows and sample wireframes to guide development. Hiring and managing a back-end developer (specializing in .NET latest ...
Attention: If your portfolio lacks the caliber demonstrated by projects like -> , don't waste your time or mine. Only proficient CSS experts with a strong track record need apply. No exceptions. Additionally, please note that a maximum of 4 hours of free time is required for this project.
I'm seeking a professional with excellent lip-reading abilities, specifically adept in English. I have a 15-minute video of a person conversing with another that needs to be lip-read. The conversation needs to be converted into written English. Key Requirements: • Decipher Standard Definition Video: The video quality is in standard definition, which requires a keen eye and proficient lip-reading skills. • English Language: The person on-screen is speaking English. As such, your communication skills in this language needs to be impeccable. • Focus on Conversations: The primary focus should be when the person on screen is engaged in conversation. This is the most crucial part of the video. This task needs specialized skills and experience in lip-reading Standard ...
As someone with a keen eye for detail and a knack for keeping things organized, I’m seeking an expert freelancer who is proficient in Excel for some important data entry work. Main responsibilities: - Entering mixed type data (both numerical and text) on an Excel sheet - Ensuring accuracy and precision in data entry - Clear understanding and implementation of data verification/validation rules during the process The ideal candidate should have: - A solid 4-5 years of experience in a similar role, preferably in freelancing - Competence in Excel and general data entry tasks - Ability to work efficiently and effectively without compromising on quality Kindly submit bids with proven track record and specific previous project details. Applications without th...
I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...
...signal is sent with LoRa. (RFM95 433MHz) The transmitter is powered by 3 AAA batteries or an equivalent battery. The power circuit is replaced with a circuit that draws very little power. see this video Create a Gerber file for the PCB. Receiver The receiver is an ESP32 Node MCU with both WiFi and LoRa. for example Heltec WiFi LoRa 32(V3). The receiver has relays, dimmers for led lights, (possibly a camera) and a button to pair the device. Power from USB. Cost of Gerber file is reported separately. Mating The ESP32 has a web page, which shows the last received signal from the transmitter (button identity). The user can put a name on this button in the web page. The signal is paired to a relay or dimmer on the receiver that has the pairing
...understanding of these requirements and provide evidence of past related works. The project should be modular and easy to edit and add functionalities in future. Tool working describe below : 1. User should be able to creat a new project, save, open and close 2. There will be a empty tree and user will drag and drop item from item list to add item to tree. This will create dynamic tree 3. When a new item is added there will be a dummy table created for that item. 4. When user clicks on item its correspinding dummy table should be visible. 5. User should be able to save and load this project as per their needs. The tree and tables will be saved and loaded. 6. There will be compile and transfer button 7. On click compile button, the tree and its table will be compiles to ...
I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.
I'm looking for a detail-oriented professional capable of typing data from a variety of sources, including online databases and software outputs, into Excel. The objective is to conduct data analysis. Though the typical size of each data entry has not been specified, a flexible approach to handle varying volumes of data will be beneficial. Ideal Skills: - Strong data entry skills - Proficient in Excel - Strong understanding of data analysis - Capable of adapting to varying data volumes - Experience with online databases and different software outputs.
I am seeking a proficient freelancer with solid Excel skills who can help me populate my Excel sheets. While no specific type of data is mentioned, good typing skills and attention to detail will be beneficial due to the nature of the project. The work would require timely and accurate typing of any kind of information whether it's text, numbers, or dates into Excel sheets. Since no further specific details were provided, showing an array of competencies, from past experience to detailed project proposals, in your application would set you apart. Ultimately, the main intent here is to organize information effectively without a specific analytical or reporting goal in mind.
As a visionary entrepreneur, I'm in need of a skilled logo designer who can bring my business branding to life. - The ideal logo will involve a compelling combination of text and symbol components. - The aesthetic style should capture a retro vibe, representative of our brand's rich and unique culture. - Please utilize warm colors such as reds and yellows, to reflect our company's passion and energy. - Please refer to the attached design to get the name and tagline. Potential designer should possess a well-rounded design portfolio, showcasing expertise in creating customized logos with a distinct retro style. A creative eye for color design particularly focused on utilization of warm tones is crucial for this project. Your prior experience in delivering high-quali...
I need a professional who is skilled in Excel data analysis. The project revolves around typing text data from an Excel sheet for the purpose of analyzing it. Here’s what you have to do: - The data to be typed is text data. - The data needs to be in tabular format. - You should be experienced in typing and data analysis. The ideal freelancer should know Excel inside out, be highly efficient in data typing, and have a strong track record in data analysis. Being detail-oriented and having strong organizational skills will be a plus.
I am on the search for a capable PART TIME virtual assistant to manage tasks for my small website company. The successfu...primarily through email communication. The following set of responsibilities are expected: - Conducting efficient email management. - Effectively managing calendar schedules. - Carrying out regular data entry tasks. Primarily, the assistant will be in charge of: - Scheduling essential meetings. - Assigning tasks and deadlines. - Keeping track of progress and deliverables. Ideal candidates should excel in project management, have strong attention to detail, be adept at multitasking, and possess excellent interpersonal and written communication skills. Previous experience in a similar role or in the midst of a team would be highly valued. Looking forward to ...
I am looking for an experienced software developer to build a system capable of automating tasks, specifically related to data entry. Key Responsibilities: - Develop a user-friendly software that automates and optimizes the process of textual data entry. The ideal candidate for this project would possess: - Proficiency in software development, specifically with automation software. - Experience in creating data entry related software. - Knowledge and understanding of handling textual data. - Strong problem-solving capabilities to figure out the most effective data entry methods. A deep understanding of data management and automation will be vital for success in this project. I encourage bids from seasoned professionals who can illustrate their understanding of this specific task.
...) Login, logout, roles (ACL if available in build) 2.) Users section with list, add, edit, delete, active and inactive user. Use ajex to check duplicate user email while adding and updating user. 3.) Categories and sub-categories 4.) Blogs (List, add, edit, delete, active and inactive), Meta title, Meta keywords, Meta description 5.) Page Manager 6.) Contact us list (With email) 8.) Export an excel having blog title, number of views, date created, user name columns and in last total of columns. Front-end: 1.) Landing page showing featured blogs and having menu of categories and sub-categories. 2.) Categories list page showing number of sub-categories of that category with categories. Sub category wies page showing number of blogs in that sub category. 3.) Blog list page (Cate...
...Crowded road 2) Accident 3) Road bump 1st Scenario: 1. Start with two cars and see if you can apply different routing protocols between them. 2. Add obstacle and see what will happen and try to measure different parameters (delay, throughput, PDR and packet retransmission). 3. Add more cars to the scenario and observe the output. 4. Search to find the codes of the routing protocol. 5. Try to add text to the codes of the routing protocol and see if you can see the output. 6. Modify the code to add one field to the routing message sent to other cars by adding the value (01,10 and 11). 7. Run the simulation again and see if other cars can see the sent value. 8. Make other cars react based on the received value. 9. This will be your first scenario outcome to show how you prove yo...
...kinds of expenses for my business. This should include: - An understanding of how to categorize expenses into staff salaries, subbie payments, materials, and individual staff hours on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A p...
I need virtual assistant, easy work just copy paste. More discusse with freelance chat...
I urgently require a proficient freelancer who can assist in entering text data ranging from 500-1000 pages. The ideal candidate must possess strong data entry skills and should be detail-oriented. Hot skills: - Typing speed and accuracy - Familiarity with data programs, or similar - Administrative skills - Attention to detail. Your end goal will be to efficiently digitize and catalog our information in the shortest time possible, as this project is time-sensitive.
I need a highly secure payment page developed which is capable of accepting credit card transactions. This page should also have capabilities to save users' payment information securely for future transactions. Here's what I expect: Key Requirements: - Ability to process credit card payments efficiently. - Feature to securely save user payment information for ease of future transactions. - Implementation of two-factor authentication to ensure the highest level of security to protect users' payment and personal information. Ideal Skills and Experience: - Proficient in developing secure payment portals. - Familiarity with handling credit card transactions online. - Experience in implementing two-factor authentication security measures. - Demonstrate ...
...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data hand...
I'm in search of a diligent translator who possesses a basic understanding of English, Spanish, and French. You'll be tasked with translating various written materials from English to either Spanish or French. Key Requirements: - Basic knowledge of English, Spanish and French...translating various written materials from English to either Spanish or French. Key Requirements: - Basic knowledge of English, Spanish and French. - Strong understanding of written grammar rules in the selected languages. - Ability to meet deadlines and work efficiently. Note: Being a native speaker isn't a prerequisite for this gig, but you must be comfortable reading and translating written English text into Spanish and/or French. Previous experience in translation projects would be a p...
I need an experienced video editor to work on a YouTube channel footage. Specifically, I'm after: - Documentary style video editing - Addition of text overlays Ideal candidates should have demonstrable experience with text overlays and documentary-style editing. Examples of previous work showcasing these skills will be highly appreciated. Please include them in your bid. Notably, the ability to work within tight deadlines is essential for success in this project.
You should have past experience to show or I will not award it to you. I need someone who knows how to create a print on demand merch store and to which platform to connect it with so that when someone buys the POD merch then on back-end that platform automatically for example if it is a T-shirt, it prints and ships it to the customer. If you can do it then good. If you expect to involve me into then you are not the right person for me.
...Features for candlesticks chart like: - Time frame series. (1,2,3,4... minutes; 1,2,3,4... Hours; 1,2,3,4... Days; 1,2,3,4... Weeks; 1,2,3,4... months; 1,2,3,4... Years). - Plotting type (Bars, Candles, Hollow candles, Area, Heikin Ashi, Renko, Range). - Indicator ( Rsi, Volume, MACD, ....And more). - Drawing Tool ( Trendline, Horizontal line, Vertical line, Channels ....And more). - Screenshot. - Save any drawing by the user for any Ticker. Ideal Skills and Experience: - Proficiency in JavaScript and ReactJS is required. - Experience in real-time data visualization. - Experience in Stock chart visualization. - Familiarity with financial stock market data is a plus. The purpose of this project is to facilitate user tracking and analysis of any ticker in the stock market. ...
I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understand...
...existing iOS app that can overlay, convert, and compress mp4 files. In particular, the capability to overlay dynamic text on videos is crucial. 2. the user selects a video locally on their device 3. and we display a timeline of the video, similar to a whatsapp status 3. the video can be trimmed. After trimmed a overlay (text and image) is added 4. the output mp4 file is played back, with overlay note: Check the screenshots attached Key Functionalities: - Overlay a dynamic text onto an MP4 video file, meaning the text will change contextually based on the video content. - Convert the video with text overlay to a different format if needed. - Compress the resulting file to ensure it remains optimally sized for mobile dev...