Vba basics for beginnersmunkák
approx. 2000 words per blog-post: I. Quantum computers (what it is, how does it work, its applications) II. Programming education (Programming Theory, C language basics) III. Tech news (New hardware gadets) IV. Educational games (Programming & Boolean Logic learning material for schools regarding computers)
SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...
Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.
Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successful...
...can provide a beginner level training on the MERN stack. The ultimate aim of the training is to equip learners with the skills needed to develop web based systems. Ideal Skills and Experience: - Knowledge of web development and software engineering - Understanding of both basic and complex coding concepts - Proficiency in teaching and mentoring, ideally with a teaching/mentoring background for beginners. - Good understanding and practical experience with MERN stack, this will be a plus. - Experience in practical web development and system design using MongoDB will be highly appreciated. - Can teach in a very interactive way, doesn't mind lots of dumb questions. Your ability to clearly explain concepts, provide practical examples and exercises, and foster a positive...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I'm seeking a skilled artist to conduct a 'sip and paint' workshop in a larger art exhibition context ...participants. Details: - The participants are novices in painting and hence, ideal candidate should be proficient in teaching beginners. - The key focus of the workshop will be to enage the guests, teach them few basic painting skills - oil, acrylic, landscape or fluid art. Skills Required: - Excellent painting skills - Strong teaching abilities, especially handling a large group - Prior experience in conducting workshops So, if you're someone who has experience in teaching novices the beautiful art of Landscape Painting, you could be just the one I need. Looking forward to work with a patient and engaging artist who could make this an unforgettable ex...
As the client for this project, I urgently require an expert in VBA.
Seeking a skilled developer capable of quickly creating a robust asp.net-based e-commerce web application. The application demands the following features: - Product listing - Shopping cart - Payment gateway - Admin access to data Data should be s...skilled developer capable of quickly creating a robust asp.net-based e-commerce web application. The application demands the following features: - Product listing - Shopping cart - Payment gateway - Admin access to data Data should be stored in MS Access 2007. As the design is not yet finalized, possessing a keen eye for detail and themes that resonate with users will be highly valued. This project is time-sensitive and must be completed within 1 day. Proficiency in Visual Basics and experience in speedy application development...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for a tutor who can guide me through my college course on computer organization. This course covers a wide range of topics including permission models, system architecture, concurrency, virtual memory, cryptographic primitives, and TCP/IP networking. I need a tutor who can help me understand difficult concepts and prepare for exams. Key Requirements: - Should be knowledgeable in all the topics listed. - Ability to explain past exam solutions. - Experience tutoring in computer organization or related subjects. - Able to communicate via instant messaging for convenience. - help in exam preparation Here is a list of all the topics covered in this course Building and Introduction - Basics of .o, .a, .so files, dynamic/static linking, and makefile...
I'm looking for a professional who can help me set up my video coaching program on Digistore. The program I'm offering is designed for beginners in the subject area. Key requirements for this project include: - Setting up the course on Digistore as a seller - Providing a seamless download experience as the program includes downloadable resources Ideal candidates for this project should: - Have experience in setting up courses on Digistore - Be able to cater to beginner-level audiences - Be able to integrate and manage downloadable resources on the platform.
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting ...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I am seeking a captivating and educational video podcast geared toward beginner podcast producers. Key requirements are: - Video Length: Under 10 minutes long for easy consumption and understanding. - Content: Technological topics to fuel interest and expand knowledge of these aspiring podcasters. - Language: English, clear diction imperative for non-native listeners. Ideally, the freelancer will have experience in creating engaging and educational technology content and knowledge of podcast production. Experience in teaching or coaching beginners will be valued. Your ability to distil complex subjects into easy-to-understand language will be key. Video editing and production skills are also important.
I have the following i need WIRING DIAGRAM to that connects ALL of these parts and that will actually make function when together. I will Test this before making any payment as to not waste my time. I would like the coding to use the (additional non power button) PiSugar 3 Button to turn on and off a solid bright white light from the Flora Neopixel . Upon Completion you are to send: In...bright enough Timeframe: open Attached are my EXACT parts as listed in post title: Need help with clear installing OS to Orange Pi Zero 2W as well Orange Pi Zero 2W PiSugar 3 Raspberry Pi Camera Module v1.3 github: PiSugar 3 Please do not say you can do this just to get the job, then not be able to actually not be able to understand the basics.
I'm looking for a skilled video creator who can teach me how to create a 15sec AI video. I make junk journal videos on TikTok and I would like to use an image from my journal videos to create a short AI generated video. I’m not tech savvy so you will need to teach me the basics. I would prefer a phone app to learn the video making on If you have a creative mind and are excited about working with AI technology to produce captivating content, I'd love to hear from you. My TikTok is junkjournalprincess
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills...
I'm seeking an online [western ,pop english singing]vocal coach to help beginners improve their singing skills. The focus of the training will include: - Teaching proper breath control techniques - Developing pitch accuracy - Working on vocal range expansion Ideally, you should have experience working with beginners and be able to provide supportive and encouraging guidance. The ability to effectively communicate and demonstrate techniques online is crucial. Your aim should be to nurture a beginner's passion for singing and build a solid vocal foundation.
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "...from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Bo...
I'm looking for an experienced tutorial creator to help me with making a video tutorial. Specifically, I need a step-by-step guide that's aimed at beginners with no prior knowledge. Key Requirements: - Video Tutorial: This tutorial will be in video format. - Guiding Through a Process: The main goal of this video is to guide viewers through a particular process or task. - Beginner-Friendly: It is essential for the content to be easily understandable for people with no prior knowledge on the topic. Ideal Skillset: - Proficient in creating video tutorials - Experience in guiding through a process or task - Understanding of how to apply beginner-friendly teaching methods Feel free to share any relevant experience you have in this area. Thank you.
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful outpu...
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
Hello Everyone, I have an automation issue for sending from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quan...
I am a beginner in Python looking for one-on-one tutoring sessions to help me understand the language's syntax and basic concepts. Key Requirements: - Patient and understanding tutor who can break down complex concepts into simpler terms - Proficient in explaining Python's unique syntax - Encouraging and able to provide constructive feedback Ideal Skills and Experience: - Proven experience in tutoring Python for beginners - Strong understanding of Python's syntax and basic concepts - Excellent communication and teaching skills Please note that I'm not looking for project-based learning or written guides, but rather interactive tutoring sessions where I can ask questions and receive immediate feedback.
...engaging and appealing for this demographic. Here's what the site should include: - Interactive creating of anti tamper proof labels: users should be able to design their labels live on the website, seeing their changes reflected in real time using our image templetes, customers will be entering details into each section boxes that will displace in real time on the image ive attached basic design to give you idea what im talking about. check out our current website on godaddy () to get idea of what kind of website we need at the minute running on basics needs upgrading badly. Also dropbox style so customers can add their own images to be designed by our team. - A checkout process that's as simplified as possible most be able to link up to sqaure payments ...
We urgently require d...urgently require dependable freelancers for an undefined project. Although the project type and main objectives haven't been specified yet, we encourage enthusiastic freelancers looking for dynamic opportunities to apply. Core basics may involve: - Web Development - Graphic Design - Mobile App Development Though the project is yet to be further defined, having skills and experience in these areas would be a strong advantage. When applying, while we can't direct you on specific information to include, traditionally comprehensive applications include details like: - Past work - Experience - Detailed project proposals Without these details, we still welcome your proposals and are interested in hearing about how you can contribute....
I'm seeking an experienced professional in optimization to develop an introductory document on this subject. Key Points: - Your experience in optimization is vital. - The content should be informative and engaging, targeting beginners in the field. - The final delivery has to be a written document. - Please include a brief overview of your relevant experience in your application. Looking forward to hearing from you.
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I'm looking for a Spanish tutor adept in instructing beginners, primarily adults. The focus should be on improving conversational skills rather than on vocabulary, grammar, or reading and writing abilities. Ideal Skills and Experience: - Previous experience teaching Spanish to adults - Skilled in initiating and holding engaging conversations in Spanish - Ability to simplify complex language training methods - Patience and understanding towards new learners Please provide your teaching method and past experience in your bid.
I'm looking for a Spanish tutor adept in instructing beginners, primarily adults. The focus should be on improving conversational skills rather than on vocabulary, grammar, or reading and writing abilities. Ideal Skills and Experience: - Previous experience teaching Spanish to adults - Skilled in initiating and holding engaging conversations in Spanish - Ability to simplify complex language training methods - Patience and understanding towards new learners Please provide your teaching method and past experience in your bid.
I'm looking for a competent copywriter who can craft engaging and informative scripts for a series of Youtube videos. Specifically, I need someone who can write in a way that's accessible to beginners in personal finance. The scripts should be: - Informative and educational: The primary goal of the videos is to educate our audience on personal finance topics. So, the writer must be able to convey complex financial topics in an understandable way. - Non-technical: While you should be well-versed in personal finance and crypto, the language used in the scripts should be easy for beginners to follow as you simplify the terminology and explain in a manner that is understandable by anyone. Ideal Skills: - Strong understanding of personal finance ...
I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, p...
...calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I...
I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.
Please read carefully - I will not respond to bids if the advertisement is not read and the freelancer does not mention my conditions in their proposal We're looking for creative videographers from around the globe to capture long-duration videos of "views from a window." Whether it's a scenic landscape, a bustling city square, or a lively construction site, we want to see what's happening outside your window. The footage should be filmed from a window, balcony, or roof, capturing the environment in a wide shot. Other filming locations can be discussed individually. Requirements: Minimum video length: 3 hours (longer is preferable). Resolution: 4K, filmed on any camera or smartphone. The camera must be stable (tripod or similar). Original ambient sound on...
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
I'm in need of a skilled individual who can create educational content for beginners who are learning Turkish. The lessons will be primarily written, and should be paired with interactive exercises to ensure optimal comprehension and retention. The content will need to cover a range of topics, including: - Vocabulary - Grammar - Conversational phrases The ideal freelancer for this job would have a strong background in Turkish language education and a knack for creating engaging, interactive learning materials. Please note that the target audience for these materials are beginners, so the content should be accessible and easy to understand.
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database system...
I am looking for a developer to further develop a chatbot website, using Next.js. Scope of work: 1. App page UI / API work. (No backend) 2. Landing page integration 3. Google Analytics Integration App page: I have already made a version 1 - shown on the right 4 - I will share full source code to make it easier for you. I want to convert it to the left three shown. See figma: (Copy)?type=design&node-id=206%3A2&mode=design&t=FF4CG64iJFrgALzd-1 I have made the backend APIs, so you will not need to do anything in the backend. I will share postman and specific instructions on how to use. Note that the model on the right will be supplied as a gltf file, you will need to use gltf loader to load it, orbitcontrols to show it around
