개인적으로 교육연구에서 자주하는 (통계)분석 몇 개를 자동으로 할 수 있는 간단한 R 패키지를 만들고자 합니다. 테스트데이터(Treatment/Control 그룹 사전/사후 데이터 셋(csv 파일)을 종류별로 인식하여 읽어들이고, 사전데스트/사후데스트로 구분할 수 있게 변수명을 바꾸고 (예: 수집된 데이터 문항 Q1, Q2, Q3...로 되어 있는데요, 사전테스트 데이터면 Q1_pre, Q2_pre, Q3_pre...로, 사후데이터면 Q1_post, Q2_post, Q3_post...로 변환), 해당 데이터별로 제가 이미 만들어 놓은 스크립트를 돌려 (Item Analysis, ANCOVA 등의) 분석을 자동 시행하고 결과를 출력하도록 하는 간단한 패키지입니다. 데이터셋을 종류별 구분해서 읽어들이는 것이 관건인데, 제가 이 부분에서 애를 먹고 있는 중입니다. 사용자로부터 (treatment pre, treatment post, control pre, control post) 인풋을 받아 If, For 등의 Function을 쓰면 될 듯 한데 (저의 짧은 소견입니다^^;), 제가 아직 R 함수에 익숙치 않아 주로 이 부분을 R 전문가의 도움을 받고자 합니다. 구체적으로 무엇을 구현하려고 하는지는 지금까지 제가 만들어 놓은 스크립트와 관련 문건들을 파일로 참고하시면 되실 듯 합니다. 다시 한번, 도움주실 내용의 핵심은 4종류의 데이터셋을 구분하여 읽어들이는 스크립트/함수가 되겠고요, 두번 째로 중요한 것은 스크립트가 완성되면 분석별로 스크립트를 묶어 함수화하는 것이 되겠습니다. 참고로, Item ...
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
I'm seeking to develop an engaging colour prediction game, primarily for entertainment purposes. I envision a game with an attractive cartoon-style aesthetic that is fun and vibrant yet user-friendly. Key Features Needed: - Implement Leaderboards: This requires creating a competitive environment for players where they can compare their scores and achievements with other players. Ideally, the leaderboard should be dynamic, updating in real-time, and easy for players to understand and navigate. Ideal Skills/Experience: - Laravel PHP Framework: Proficient skills and experience in Laravel development will be essential for this project. - Game Design: Experience in engaging game development, particularly in creating colour prediction games, is agreed. - Cartoon-style Graphic Desi...
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...
I need a professional to scrape data from the URL provided and deliver the extracted details in a CSV format. - The specific data elements required are the agent name and phone number. The scraping process does not require any filters or search criteria as it's a one-time extraction. The data should be organised and easily readable in a CSV document for further analysis. Ideal skills for this project would include: - Proficient in web scraping with experience in extracting data from similar websites - Strong expertise in delivering data in structured formats (CSV, Excel) - Attention to detail to ensure accuracy in the extracted data
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
Es ist eine Aufgabe die in Excel gemacht werden muss, bzw Excel Solver bis 10.05
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
I require an experienced professional to obtain text and images from a blog and store them in a CSV file. The ideal candidate should: - Have experience in scraping content from websites - Be adept at data management, specifically CSV files - Be proficient in handling both texts and images and store in easy way to manage and retrieve A strong track record of similar projects will be a plus. This job requires accuracy and attention to detail. I look forward to seeing your bids.
...manager , website manager, Transcriptionist, Editor or Proofreader. Various tasks: Chat gpt use. Copy paste. Data entry Research Industry research The tasks vary. As an example; I’d like to be able to find someone I can message saying, “ I need a list of all audiobooks I narrated available on audible, including title, author, publisher, price, link, rating, and one positive review from it. Then, compare that list to what is available on my website and finalize a list of those that are missing from the website. Send those to my Web master.” And then another time I might want to ask, “ please take this manuscript of an novel I’ve written. Send it through ChatGPT with the following prompt [insert prompt]. Return a document with the edited manuscript...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
...various types of media files. The ideal freelancer for this project would have a solid understanding of Python, machine learning, NLP, and experience with BERT models. Features of the Python Script: - Process text queries obtained from a CSV file (example CSV attached) - Detect entities such as: - Persons - Places - Events (e.g., weddings) - Dates - Number of individuals visible - Media type (Image, Video, Audio, Text) - Detailed type (Interview, Landscape, Close Up, Group, etc.) - Length - Content - Retraining should be based on a provided CSV file containing Sentence, Entity, and IOB Tagging training data. The model does not need to be trained - only provide the capability. I am looking for a detailed and accurate script that can efficiently...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
...Interactive Dashboards: Develop dashboards that allow real-time interaction with data. Ensure the dashboards are user-friendly and provide clear, actionable insights. Advanced Filtering and Drill-Down Functionality: Enable detailed examination of data down to individual product sales. Include robust filtering options to analyze data across various dimensions and timeframes. Implement features to compare sales by location on different bases, such as: Yesterday vs. the same day the previous week. Yesterday vs. the same weekday last year. Week to date vs. last week. Week to date vs. the same week last year. Week to date vs. the same week last year, accounting only for locations open during both periods (like for like). Yesterday vs. the same day last year, like for like basis. Skil...
I need a skilled Prestashop 1.7 expert for my project. I am specifically interested in customizing my product catalog. The main task will be: I need to add Display Condition on Product Page by default i use csv. I need to add extra product condition thats it 2 small works
...program to upload and save attachments Description: I created a program that uses HTML, CSS, and Javascript to enable patients to fill out their information, including the option to attach files. Upon submission, a PHP script is triggered to email the data to me as a CSV file. The attachments (typically JPEG’s or PDF’s) uploaded by the patients are not being included in the email. Objective: Adjust program to upload and transmit attachments with .csv Deliverables: - Updated program with ability to transmit attachments in csv - Documentation of all changes with code (unrestricted) - Format attachments as: o Insurance-patient’s last name-patient’s first name o ID- patient’s last name-patient’s first name Attachments: The HTML,...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
I have attached a logo I designed using Illustrator, and I am a little bit satisfied, but I feel there needs to be something more or something different *Strictly, Canva Designs will be rejected. *Please Dont Post The Same Design More than once* *Before submitting your design, please compare it with mine and ask yourself which is better, dont post if yours is not better* Calling all the best Logo Designers out There The 3 best logos will get a 5-star review with a detailed review comment. I decided to buy 3 best logo design, (Please dont recreate my logo, do something new) App Name: YoWaiter Logo Idea : YW integrated together and some kind of simple waiter design is expected, or a cloche but dont make it look too much like restaurant app; Its a food reservation app It would be ...
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...
I need a professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data management are highly desirable.
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hug...
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP ser...
Hi, Job Title: Senior Developer - SQ...for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office. - Work Location - Dubai - Number of Working Days - 6 days ( Monday to Friday ) - Number of Working Hours - 10hrs per day - N...
...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experien...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
...platform, where it becomes visible to registered service providers. 5. Receiving Quotes: 6. Registered service providers who are interested in the project receive notifications or alerts about new project postings that match their expertise and service area. Service providers review the project details and submit quotes or proposals to the customer through the platform. Customers can compare quotes from multiple service providers and review their profiles, ratings, and reviews before making a decision. 7. Communication and Selection: 8. We provide a platform for communication between customers and service providers, allowing them to discuss project details, ask questions, and negotiate terms. Customers can communicate with service providers directly through the p...
I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills ...Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your ...
