Web scraping stock data punët

I'm in urgent need of a competent web scraper. You will be responsible for extracting specific data from the Vahan Parivahan government website using vehicle numbers. Here's the information I am interested in: - Owner details - Vehicle payload - Mobile number (if possible) - Vehicle registration details Your primary task will be: - Extract the above data for each vehicle number provided - Ensure the integrity and accuracy of the extracted data Your deliverable should be in Excel format and code used The ideal candidate for this task should have: - Proven experience in web scraping, specifically from government websites - Proficiency in Excel and handling large volumes of data - Attention to detail to ensure acc...

I'm in need of an expert with robust website scraping skills, capable of extracting text content from different online platforms, mainly music-related sites. This project not only requires knowledge of these particular platforms but also the skill set to correctly interpret and manage the obtained information. Ideally, you'll have a successful track record in relevant data extraction tasks. Results should be precise and generated in a timely manner. Key attributes needed: - Exceptional web scraping skills. - Profound knowledge of music websites. - Proven experience in data interpretation and management. - Consistent and punctual in job completion. Please, only bid if you're confident in handling these requirements properly.

...Processing (NLP) and Machine Learning (ML) to join us in developing a sophisticated content analysis tool. This project aims to leverage AI technologies to classify and analyze text data efficiently. The tool will be able to categorize a news outlet's political orientation (Left, Center, Right) based on articles published in the past year. Technical Expertise: - Demonstrated proficiency in Python and experience with AI-driven development projects. - Solid experience in implementing NLP and ML algorithms, capable of managing the full data processing lifecycle from collection to analysis. - Expertise in web scraping and data extraction techniques, specifically related to extracting content from online sources. - Previous experience with technologi...

I am searching for a freelancer who can compile an introductory e-book on the dynamics of trading and investing on the stock market. This project should cover the following topics: - Stock Market Analysis: Explain different types of analysis such as fundamental and technical analysis, and how they can be applied in making investment decisions. - Investment strategies: Delve into various investment strategies including growth investing, value investing, and income investing. - Trading Psychology: Provide information on common psychological challenges faced by traders and investors, and provide practical strategies to overcome these. Even though I am searching for beginners, being equipped with basic knowledge on these topics would be an advantage. Your ideal traits would inc...

I require an expert in web scraping who can automate the process of scraping public profiles of professors from a list of 4000 universities. - The information that needs to be scraped includes: Name, Email address, Research areas, Bio, contact details, department, designation, and text/titles of their scientific publications. - The scraped data should be effectively stored in both a spreadsheet and a database, catering to my needs of structured and easy-to-navigate information management. - The expertise that will be ideal for this task includes: proficiency in web scraping techniques and tools, data management skills encompassing both spreadsheet and database handling, a meticulous eye for detail to ensure all the required fields are c...

...computer that can output the data from a company's B2B program as Excel and XML within a certain period of time. The B2B program installed on my computer was installed on my desktop with keys and passwords via remote connection. The information I want from this program; I want a program that can quickly capture the stock code of the product, product description, original number of the product, price of the product, image URL of the product, and stock quantities of the product in which warehouses within a certain period of time. After making this program, it should automatically upload this data to my own website, which I purchased with a ready-made theme, as soon as possible. I need someone who can integrate and do this. The ready-made themed site I purc...

Looking for proficient web scrapers that are capable of extracting text content and emails from Rocket Reach. I'm expecting robust and accurate deliverables from your end. Necessary Skills: - Experienced in Data Mining and Web Scraping - Familiarity with Rocket Reach, its structure, and content - Ability to extract large amounts of data accurately and quickly Expectations: - extraction of text content and emails - no repeat or empty data - accurate information without any inconsistencies - protection of data privacy principles When applying, please share a detailed project proposal outlining your strategies for scraping Rocket Reach and how you will ensure the quality of the extracted data. Note that only freelancers ...

I require an experienced professional to help manage my Amazon seller account efficiently. The tasks involved include: - Product Listing and Optimization: Applying competent knowledge of SEO to ensure listings are highly visible and attractive to the target market. - Inventory Management: Ensuring that stocks are up-to-date, avoiding sales of out-of-stock items to maintain a good seller reputation. - Order fulfillment: Handling all order-related tasks, from checking order status, packaging items, to arranging deliveries. I deal with less than 50 products predominantly in the North American market. Ideal candidates should demonstrate proven experience in Amazon account management along with a deep understanding of diverse Amazon marketplace facets.

I am seeking a skilled web scraper/developer to create a tool that will specifically extract data from Zillow. As a trusted online real estate marketplace, Zillow holds a wealth of property data that I need to acquire for my project. Key Deliverables: I need you to extract the address, price of the property and the contact information for all the houses on Zillow listed as for sale by owner that are listed for at least $10,000 less than their estimated market value. Afterwards, I need the information in a csv file formatted address, price, phone number. I want you to scrape every house listed for sale by owner on the entire website. You will have to write the script to scrape the website and then deliver the csv file to me. Afterwards, I want you to run the scri...

...experienced virtual assistant with strong capabilities in web scraping. Key project responsibilities include: - Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 2,500 websit...

I'm looking for a talented developer to design and build an Android and web-based app focused primarily on stocks and options trading. Key features should include: - Real-time market data: The app should have the ability to provide live and real-time market data and updates. - Interactive charts: Users should be able to interact with dynamic charts representing the data, helping them to analyse trends and make informed trading decisions. The ideal freelancer should have prior experience in developing finance-related applications and should be familiar with stock market operations. Demonstrated skills in Android and web development is essential. Due to the urgency of this project, I am looking for someone who can deliver this task ASAP. If ...

I'm seeking an expert to establish a seamless Walmart Canada integration for my WooCommerce platform. This must encompass: * **Product Synchronization:** Automatically update product details from WooCommerce to Walmart Canada in real-time, including price, stock quantity, and product specifications. * **Inventory Management:** Ensuring no discrepancies between our WooCommerce store's inventory and Walmart Canada's inventory records. * **Order Fulfillment:** Enable efficient order processing and delivery management. * **Product Creation:** Automatic importation and creation of products from WooCommerce to Walmart Canada. The ideal freelancer would have strong experience in WooCommerce to Walmart integrations, API usage, and strong knowledge of both platforms' i...

Scraping psychiatrists data from a website discussed in chat, approx. 10k-20k records, as per previous sample and some new fields. all the ones from the old + description, Top_Specialties Expertise, insurance, availability

I'm seeking an experienced developer to help create a unique TradingView indicator particularly for identifying trends in the stock market. - The indicator should be compatible specifically with the TradingView platform. - The main aim of this indicator is to identify trends rather than generating buy/sell signals or spotting divergences. - It must operate efficiently on stock trading instruments. Ideal qualifications for this project: - Proficient in coding TradingView indicators. - Experience in financial markets, specifically stocks. - Detailed Understanding of trend analysis.

I'm looking for an experienced developer to create ...practices - Implementing an integrated inventory system capable of tracking orders for optimal stock management - update google climb pages, e-commerce asap Your experience in e-commerce web development will be invaluable, especially understanding digital product presentation, shopping cart setup, secure payment mechanisms, and precise inventory management systems. Being well-versed in creating user-friendly and navigational interfaces will be highly regarded. Your deep-rooted knowledge in e-commerce platforms like WooCommerce, Shopify, Magento, or others is crucial, to provide the best technical recommendations. Please share your previous work on similar projects, focusing on the development of the stock m...

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

I have built out an Alteryx web scraping model that mostly works, however, there are some issues, i think it's due to something related to the latitude and longitude requirements of the API perhaps, some cities work and others don't. I am looking to query by city to see which dental services are available in that city. Within the attached model i have provided the list of cities, the website to query, some additional customizations required and some details on the issues. I mostly just want the Download tool configured to pull from all cities, i can cleanup the JSON outputs myself, though feel free to do that :) I would like to scrape the Sunlife Lumino Website.

I'm seeking someone who can help me with real estate data scrapping for my website. page should show stats of active listings, max price, minimum price, price per sq feet, and graph for each page on the site and if I create new pages, it should auto-populate there. the site was built in square space.

We need a Python developer to write a script to extract the following data from Raydium pools on Solana blockchain: - initial volumes of pool liquidity (SOL, created token) - historical transactions (price/volume) for a specific pool - description in words, if available, website, social networks, if added to the created pool And we need this both for historical pools (from January/December) and simply for actual pools. All these variables should be collected in tables. Please describe your experience, preferably with relevant examples. Please start your proposal with word SOLANA

I'm loo...group via API integration but currently, it isn't purchasing or selling as expected. Specifically, I'd require someone who could: - Identify and fix the issues that prevent it from purchasing and selling the scraped coins. - Make sure the bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot's feat...

as discussed C# code for scraping the data from the carjet

...automatic data transfer from a specified source to my WhatsApp group. This extension will adhere to the following parameters: - Compatibility: The extension must be specifically designed for smooth operation on Google Chrome. - Source: The source where the extension should transfer data from is my WhatsApp group. - Transfer Method: It's critical that the data is transferred automatically as a message to my WhatsApp group, removing the need for manual intervention. Ideal Candidate: I'm seeking a freelancer with a strong background in Google Chrome extension development who can deliver this project. A deep understanding of WhatsApp API and experience in automation will put you at an advantage. Your expertise must also lie in coding, software development...

I need an expert Shopify developer to create a highly-functional online store for me. This is primarily for selling physical products and my target a...highly-functional online store for me. This is primarily for selling physical products and my target audience are adults aged 24-55. Key requirements include: - Advanced product customization options to allow users personalize their shopping experience - Reliable payment gateway integrations to ensure transactions are seamless and secure - Efficient inventory management system to keep track of product stock and sales It would be great if you have extensive experience in Shopify store development and a good understanding of user preferences for my target age group. Knowledge and application of current e-commerce trends would be a m...

I'm seeking a skilled web developer to create an intermediate-level stock trading website. Having experience in financial projects, specifically related to stock trading will be valued highly. Key Features - Integral to the website, are live price updates to ensure real-time accuracy for traders. - Functionality for portfolio management is also a key component, with capabilities for users to view, manage, and evaluate their stock portfolio. Ideal Skills - Experience in developing web platforms targeted at intermediate users. - Understanding of financial markets, especially stock trading. - Capability to integrate live financial data updates. - Experience in developing portfolio management tools.

I'm seeking a skilled web developer to create an intermediate-level stock trading website. Having experience in financial projects, specifically related to stock trading will be valued highly. Key Features - Integral to the website, are live price updates to ensure real-time accuracy for traders. - Functionality for portfolio management is also a key component, with capabilities for users to view, manage, and evaluate their stock portfolio. Ideal Skills - Experience in developing web platforms targeted at intermediate users. - Understanding of financial markets, especially stock trading. - Capability to integrate live financial data updates. - Experience in developing portfolio management tools.

I need a skilled programmer to scrape content replies from a particular tweet on Twitter and return the data in a CSV file. Here are the specific requirements for the project: - The target platform is Twitter. - Only the content of the replies needs to be scraped, not the user's profile information or timestamps. - The CSV file should be formatted with one reply per line for clarity. - The CSV file should should contain two columns: Username and Reply The ideal freelancer for this job would be someone with experience in Python, as well as extensive knowledge of Twitter's API and CSV file manipulation. Experience with web scraping would also be highly beneficial. Please ensure your proposal specifies your experience with these requirements.

...for a data scraper who can help me with my project. The ideal candidate should have experience in web scraping and be familiar with SQL databases. Specifics: - The project involves scraping website URLs. - The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously (Every second), on an ongoing basis. Nature of Work: - Retrieve data continuously (every second) from below url's - Add option to change MSSQL login & pwd details - Attached Screenshots for Reference data Tables ,69,1081628,160,1,49776&curr-name-color=%230059B0&fields=1h Gold & Silver Ratios Data from Kitco url (attached screenshot) : Skills and Experience: - Proficient in web scraping...

I am looking to fill a longterm editor position for multiple projects for my agency. I run a short-format content agency that edits videos for various coaches, businesses and podcasts. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 8usd for every video-edit. The process is super streamlined. All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits the ratio 1:1 on In...

I am in search of a talented graphic designer with experience in creating vector designs suitable for both print and laser engraving/cutting. - The design should feature a caduceus similar to the one in the attached images, which is detailed on the snakes. I want it to look just like the one I submitted, not the standard stock basic ones that are on the internet. final file format should be .svg and .ai - The text "NAVY" is to be placed above the caduceus, "CORPSMAN" below it, and "84" to the left and "04" to the right. All text should be in bold and maintain the same color throughout. - The final design should be delivered in three color versions including black, silver, and blue. Your proficiency in vector graphics and understanding o...

Jeg leter etter å fylle en langsiktig editor for flere prosjekter for byrået mitt. Jeg driver et byrå for shortformcontent som redigerer videoer for ulike coacher, bedrifter og podcaster. Videoene er opptil 60 sekunder lange, og jeg forventer at du redigerersubtitles, b-roll, stock footage, dynamic motion/graphics og generelt gjør videoen underholdende og svært engasjerende. Jeg leter etter en person som kan være min heltidseditor i de neste 6-12 månedene, med mulighet for jevnlige lønnsøkninger når byrået vokser. Du vil få betalt 100kr for hver video redigert. Prosessen er svært effektiv. Alle videoer er tilpasset av meg -> du får råmaterialet, redigerer det og laster opp de redige...

I require an expert in data mining and scraping with the objective of extracting specific data from the car dekho website. Key Aspects of the Project: - The focus is on the city of Bongaigaon, Assam. - The key data required is mobile numbers of users visiting the car dekho website. - The need for this project completion is ASAP. Ideal Freelancer: - Proficient in data mining and scraping. - Familiarity with the car dekho website would be advantageous. - Demonstrated experience in projects with urgent deadlines.

I require an experienced individual to add manual trades and manage my positions using options trading software like "ThinkorSwim" and "InteractiveBrokers" on my own account. Expectations: - Assist with placing trades - Manage positions effectively Skills required: -Experiences in adding/managing stock options trades (Iron Condors, Iron Butterflies, Calendar Spreads and so on) according my guidance - Proficient in using ThinkorSwim and InteractiveBrokers software - Clear understanding of following Signal-Services strategies I am not seeking fully automated trading, but manual trading. Previous experience in a similar role is highly beneficial. You have to follow my given rules. You dont need to decide what to do. We tell you, what to do and you add/modify ...

I'm in need of an expert who possesses exceptional skills in Xpath web scraping techniques for a market research project. The primary task involves extracting meaningful data from a diversity of news websites. Skills & Experience: - Proven Xpath web scraping abilities - Familiarity with navigating news websites and recognizing valuable data - Experience with market research-oriented projects When applying, kindly highlight your experience in this field. Details of prior projects where similar skills were utilized will be greatly valued. Please note that this task requires precision and accuracy. Only those with a sound understanding of Xpath web scraping should apply.

...capability. 3. **Cross-Platform Compatibility:** The system should run smoothly on web browsers, Android, and iOS devices for maximum accessibility. 4. **Table Management:** Effortlessly manage table layouts, take orders directly on tablets, and enable tableside payments for efficient dine-in service. 5. **Analytics & Reporting:** Provide real-time insights into the restaurant's performance through a live dashboard, with customizable reporting options. 6. **Order Integration:** Integrate with leading food ordering platforms for streamlined menu management and order fulfillment. 7. **Inventory Management:** Manage inventory efficiently by calculating recipe costs, sending purchase orders, and tracking stock transfers with powerful reporting capabilities. 8. *...

Google Jobs Scraper project requiring skills in .NET, Python, Selenium and SQL. The task is to create a crawler to extract job listings based on predefined queries, manage the data in a structured manner, and provide an interface for controlling and monitoring the scraping process. The solution requires adept handling of rate limits and the use of rotating proxies for efficient data scraping. Data To Be Scraped: - Scrape all specified job listing data points. - Store and manage the scraped data in a SQL database for effective access and organization.

I'm seeking a proficient web scraper to extract specific text content from Website 1 and deliver it in CSV file format. Skills and experience in data mining and web scraping are crucial for this project. Key Requirements: - Ability to accurately scrape text content from the website URL provided, including all requested fields. - Proven experience working with large data sets - Proficiency in transforming scraped data into CSV format - Attention to detail, ensuring no essential content is missed. By delivering this project successfully, it opens up opportunities for similar, future projects.

Project Description: We are on the lookout for a talented web developer with expertise in platforms to create a sophisticated online form on our website. This form will integrate with an existing Excel spreadsheet to automatically generate instant service quotes for our clients, based on their specific needs. Our services cater to various room categories, with each category requiring a defined amount of time to service, as detailed in our Excel spreadsheet. Core Requirements: Wix Compatibility & Excel Integration: Seamlessly integrate the online form with our Wix website, pulling data from an Excel spreadsheet to calculate service quotes. The spreadsheet includes details like the number of minutes required for different room types (e.g., 30 classrooms, 10 bathrooms, 4...

...operations and effective inventory management. We need a comprehensive software solution that allows us to: Track Sales: Monitor daily, weekly, and monthly sales figures, including detailed breakdowns of services rendered and products sold. Manage Inventory: Keep tabs on inventory stock items, including real-time updates on quantities, reorder levels, and supplier information. Ability to manually adjust inventory levels as needed. In/Out Stock Management: Efficiently handle the movement of inventory in and out of stock, with easy-to-use features for manual input and tracking. Key Requirements: Experience in developing software solutions for small businesses, preferably in the automotive industry. Proficiency in programming languages and frameworks suitable for ...

...interact with web content, specifically product listings. The API should be smart enough to comb through vast sets of online data to find specific product listings quickly and efficiently. I need a complete developer who is capable of handling Java, Python, API, html, For the consumption of api and endpoint. More details to the correct developer Key Requirements: - Proficiency in Python and understanding of APIs - Expertise in web scraping and data extraction from web content - Knowledge in dealing with product listings from various sources - Implementing JavaScript functionality as needed - Quality assurance to ensure accurate and reliable search results This project demands a skilled developer with a knack for algorithm design and data...

I'm currently facing issues with my web crawler code. Specifically, it's not managing to scrape all the required data and it's throwing errors inconsistently. This code has been built to scrape information from certain e-commerce platforms. The ideal freelancer for this task should show: - Proficiency in Node.js - Extensive experience with Puppeteer and web crawling, especially focusing on e-commerce platforms - Exceptional debugging skills Your challenge will be to inspect the code, identify the underlying issues and then fix them to ensure a comprehensive and seamless data scraping process. I look forward to collaborating with someone who can effectively resolve the issues and optimize the performance of this web crawler.

I am looking for a skilled and experienced data scraper who can extract targeted information for a data analysis project. Key responsibilities include: - Extracting specific data from a designated website - The data includes product details such as price, product description, and pack size Ideally, you should have: - A firm grounding in web scraping or similar data extraction techniques - Experience in data analysis - A keen eye for detail to ensure accurate data extraction Your main task is to aid in competitive research through your data extraction efforts. An understanding of e-commerce and product data will be beneficial. Your efforts will contribute directly to our overall data analysis strategy.

...Downloads: We need to ramp up the number of users that are making good use of our cloud-based inventory management system. • Generate Impact: The goal is to get micro, small to medium-sized businesses to not only know who we are, but to be excited about our offerings. You can find more information about Scancloudsystem at www.scancloudsystem.com. The system is now in production, meaning that Barcode Stock Manager, the Android app can be downloaded from Google Play store and Scandesk, the Windows based application can be downloaded from www.scancloudsystem.com. Now, all the services are for free. To sum it up: My aim is to increase the number of downloads, reviews and to improve user engagement, thus I prefer paying after downloads, let's say if you improve the downloa...

I'm lookin...looking for a skilled data analyst who can transform my stock market derivative data into a useful excel sheet. Your main task will be to perform volatility analysis on option derivatives' data sourced from stock market databases. Key responsibilities: - Collecting and importing data from stock market databases - Creating an efficient excel sheet that could perform volatility analysis Ideal skills and Experience: - Strong experience working with stock market derivative data - Proficient in Excel - Strong background in volatility analysis - Knowledge and understanding of options as a derivative instrument is a bonus. Your work will help me make informed decisions about option derivatives and underst...

I'm seeking a talented professional to create an engaging 3D animated e-commerce we...menus that commercially and visually appeal to potential buyers. Additionally, the project requires an easy-to-use admin panel with the following capabilities: - Inventory management: Simplified, real-time tracking and updating of stock levels. - Order tracking: Efficient system for tracking orders from checkout to delivery. - Content management: Able to easily add, edit, and manage website content. - Sales reporting: Comprehensive report generation on sales data for strategic decision making. Ideal candidates should have a strong portfolio in 3D animation and web development, with proven experience in creating e-commerce websites and administrative systems. Familiarity with t...

I need an expert to help me connect my e-shop running on Woocommerce platform via API with to automate certain aspects of my business. The main features I want to automate include: - Automatic order processing - Bulk imports In terms of updating stock statuses, I would like to update product status (pre-orders, available, sold out). The ideal candidate should have experience working on the Woocommerce platform and its integration with various APIs. Knowledge of how to automate e-commerce processes is a must. It is important that you listen to my requirement and tailor a solution to my specific need. Thank you for your offer.

I Have python scprit to scrap a website, where i send post requests using requests, I input reg numbers into post form, it works fine however after 30-40 records it expire cookies so i manually update cookies and re-run, i want to modify scprit so it will do something with cookies that it will not expire or update cookies so scprit should keep running after 30-40 records I can provide you my scprit in chat wanted to do it right now

I urgently need a proficient freelancer to scrape data from a website. Unfortunately, the exact type of data and the particular website to be scraped haven't been mentioned. Although doesn't mean that this task lacks clarity. Skills and Experience: • Proven experience in web scraping. • Proficiency with programming languages (Python or JavaScript preferred) is a must. • Knowledge of HTML, CSS, DOM, and XPath. To Bid: • Include examples of past data scraping work. • Highlight your relevant experience. • Submit a detailed proposal outlining your approach towards this project. Due to the generic nature of this task, freelancers with flexibility and adaptability will be preferred. Strong problem-solving skil...

...would be able to: -Design and develop solutions within the realm of machine learning to enhance the functionality of circuit designs. -Preprocess and analyze data using Python in conjunction with machine learning methods for improved circuit analysis. Owing to the nature of this project, experience in the following areas would be beneficial: -Electrical Engineering: Specifically circuit design; knowledge in power distribution and control systems would be a plus. -Machine Learning: Experience in data preprocessing, model training, and model evaluation. -Python: Skilled in scripting and data analysis; understanding of web scraping would be advantageous. If you fulfill these requirements and are ready for an exciting project fusing Electrical Enginee...

...experienced virtual assistant with strong capabilities in web scraping. Key project responsibilities include: - Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 1,000 websit...

I'm ...tool that can extract all types of data from Websites. This includes not just user data, product data, and post or article data, but also comprehensive product information like product names, prices, descriptions, as well as the website's social links, mobile numbers, addresses, and countries. Ideal Skills & Experience: • Proficient in web scraping • Knowledgeable in data extraction and processing • Able to accurately extract product information • Familiarity with Website A would be a plus This project requires an attention to detail and the ability to handle extensive data. I look forward to receiving your bids. I am looking with the data to be aligned to proper excel format and n...