Create excel file openxml dataset jobs

I am looking to have a discounted cash flow model created in Excel for property valuation analysis This task should not take long to complete as all data and parameters are given Key Requirements: - Input Data: The project will require the use of the property data, - Model Parameters:DCF model will be for 10 years - Excel Model: The freelancer is expected to use the document provided and complete the rest of the remaining data. They will then be required to fill this in the Key Assumptions (Sheet 1) The ideal candidate for this project will have: - Proficiency in financial modeling, specifically in creating discounted cash flow analyses. - Expertise with Excel and a strong understanding of property investment principles. - Clear communication skills, as they will n...

Here's some information on how the API calls on how the "idToken" is received. Step 1 Login Flow & API call: 1. On the web page, Fill up the email & password on the login page. Press on "login" 2. A POST API call is made to "" with returns set-cookies in the response header. It contains the "APPSESSID" cookie. This cookie will be used in the next API call. Step 2 On the web page, Once you've landed on the homepage, Click on "Competitions" in the navigation tabs on the Left: 1. This would make a POST API call to "" which uses the "APPSESSID" cookie mentioned above. 2. The response of this API call should return "idToken" as one of the field Here are the Acceptance Criteria's (AC) that ...

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in ...

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for th...

I'm looking for a graphic designer to help me create my company's logo and brand and improve my website. The price is negotiable, depending on your experience. If you are interested, write me a private message. Thank you!

Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Try to seal Entries so nobody can see your work 5. Upload final work as .mp4 Dice: https...

...home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Manageme...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

...append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script should be able to handle files that already exist in the specified folder. - The script should be robust and reliable, able to handle a large number of files efficiently. Ideal Skills and Experience: - Proficient in Google Apps Scripting - Experience with Google Drive API - Strong understanding of file management on Google Dri...

I'm in need of a statistician who can perform an in-depth T-test analysis using SPSS. I have a dataset ready for analysis. Key requirements: - T-test analysis: The core of this project is performing T-test analysis. - SPSS expertise: Proficiency in SPSS is a must, as it's the preferred software. - In-depth analysis: I don't just need basic summary statistics. I'm looking for a detailed and insightful interpretation of the results. Experience and Skills: - Advanced statistical background, particularly in T-test analysis. - Proven experience with SPSS and the ability to use it for complex analyses. - Strong interpretation skills to provide meaningful insights from the analysis.

I'm looking for a skilled designer to create a bold and colorful sales web page. The page should be visually striking and engaging, as the design will play a significant role in attracting and maintaining visitors' interest. Key requirements: - Design Style: Bold and colorful - Mobile Responsive: The page must be mobile responsive, ensuring a seamless user experience across different devices - Elements: Your primary focus will be incorporating customer testimonials into the design. Ideal Skills and Experience: - Proven experience in designing sales-focused web pages that are bold and colorful - Proficiency in creating designs that are both visually appealing and user-friendly - Strong understanding of mobile responsive design principles - Experience in incorporating el...

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently ...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficient dete...

Have you ever done a webinar before? If yes, please show me I am starting a new business and need some webinars. I, myself, am not good at doing webinars. So I meed someone to do them for me

I'm in need of a capable statistician, proficient in Jamovi, to apply their expertise on a small dataset of both numerical and categorical nature for my research. Your responsibilities would include: - Conducting Descriptive Statistics to provide a clear overview of the data. - Performing Hypothesis Testing to scrutinise various assumptions. - Executing Regression Analysis, extracting possible relationships within the dataset. A strong statistical background is paramount, particularly in handling smaller datasets. Familiarity with academic or research-oriented projects will be regarded advantageous. Please be adept at presenting complex results in layman terms as I value comprehension and transparency.

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

The name will be 'Bendita', it will have images of hops and barley degraded in the background

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entrie...

I'm seeking a graphic designer to help craft a bold and vibrant label for my Liquid vitamin product. To take existing artwork and examples of art direction and create labels using requested art direction and existing logos. Key Responsibilities: - Create a distinct, DELICIOUS looking label - Reflect our unique brand and identity (logo) Ideal Skills: - Proficiency in graphic design software - Experience with food and beverage industry branding - Strong sense of color, style and typography - Ability to design vibrant, attention-catching labels

I'm looking for a skilled data analyst to help me with a comprehensive statistica...comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the results in a clear and...

I have a PNG file that I need to be revectored. The intended use of the revectored file will be for print materials. While I don't require any specific changes to the design during the revectoring process, I need a freelancer who can ensure that the quality of the image is maintained and that the final vector design is suitable for high-quality printing. Ideal Skills and Experience Include: - Proficient in vector software (e.g. Adobe Illustrator) - Experience in converting raster images to vectors - Understanding of print design and requirements - Attention to detail for maintaining image quality

...team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful performance insights. * Analysis reports with visualizations focused on: * Player performance over time * Our strengths and weaknesses * How we compare to top teams * Map rotation analysis with suggested changes * Final presentation summarizing ke...

Please fix my task that we spoke about

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrie...

I would like to have a routine to change font size without opening a word file. Also to be able to merge severall doc files into a single one.

...a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understand...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.

I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.

...classification. Key Tasks: - Data Preprocessing: You'll be responsible for cleaning and preparing a dataset of 1,000 - 10,000 images for training the model. - Model Selection and Evaluation: Your expertise in selecting the most appropriate model for this task will be crucial. - Feature Engineering: Extracting and selecting informative features from the images will be a key part of the project. Ideal Candidate: - Strong background in machine learning, particularly with Zero-shot Learning models. - Proficiency in data preprocessing and feature engineering, particularly with image data. - Experience with model selection and evaluation in a similar context. - Ability to handle a moderate sized dataset in the range of 1,000 - 10,000 samples. Please apply with a brief ...

I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.

We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.

...entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work: - Creating invoices: You will be responsible for creatin...

I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years

I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

I need a Gujarati dataset prepared for training the Llama 2 model, in order to later perform fine-tuning on it for language-specific tasks. Essential Requirements: - Curate a sizeable Gujarati dataset suitable for training NLP models, ideally around 5 GB - Utilize the Llama 2 model for the Gujarati fine-tuning, optimizing it for the specific task Key Skills: - Proficiency in NLP techniques and methodologies - Experience in curating or working with large datasets - Proficient in fine-tuning Llama 2 or similar models - Gujarati language proficiency is a plus Deadline: 2 days for the dataset curation and initial fine-tuning.

Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll hav...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your de...

I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a track recor...

I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific ne...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-fri...

I urgently require a freelancer to create a logistics management system for my business. The system must address the issues I'm currently facing with tracking shipments and managing inventory. Key Points: - The system should be able to efficiently track shipments and provide real-time updates. This is crucial to improve our customer service and overall business operations. - The inventory management module should be effective and user-friendly. As a business with 18 warehouses, we need to ensure all stock levels are accurately and efficiently maintained across all locations. Skills and Experience: - Proficiency in logistics software development - Strong understanding of inventory management systems - Prior experience with large warehouse networks - Ability to deliver a quick ...

I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.

I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching

I'm in need of a skilled professional to create a No-Code app on the Adilo platform or any other. It shall has three interface. 1. User Interface 2. Management Interface 3. Service Provider Interface App Idea: Chat based profile matching for Carpenters to work on hourly basis. User Interface Step 01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesion...

I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is develo...

I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific data fields like stock ...