Import dat file using vba excel工作

筛选

我最近的搜索
筛选项:
预算
类型
技能
语言
    工作状态
    2,000 import dat file using vba excel 份搜到的工作,货币单位为 HKD

    Develop a sophisticated trading strategy utilizing Pine Script, a domain-specific language used for creating custom indicators and strategies on the TradingView platform. This project requires an expert-level understanding of Pine Script, technical analysis, and algorithmic trading concepts.

    $2661 (Avg Bid)
    $2661 平均报价
    1 个竞标

    I'm in the market for an experienced accounting professional who can competently handle a range of tasks. The scope of work will include: - Bookkeeping - Financial analysis - Tax preparation You should be well-versed in QuickBooks, Excel and Xero as they are the main tools for my accounting tasks. Your role also entails delivering weekly accounting updates and reports. Please only bid on this project if you have a clear understanding of these applications and tasks. Previous experience in similar positions is highly desirable.

    $806 (Avg Bid)
    $806 平均报价
    50 个竞标

    I am looking for a skilled and experienced Android developer proficient in Java, particularly with experience in multi-threading. description : one file downloading using multiple threads and saving the file. * User can Pause, Resume and Cancel the downloading file from the main UI. * Files should be able to download in the background and not Stopped by the android system. * multiple files can be downloaded at the same time. . I will share the rest after you bid. $$$ Absurd prices won't even be considered. $$ *Bid only if you know You can do this. Thanks

    $2716 (Avg Bid)
    $2716 平均报价
    10 个竞标

    I'm looking for an expert in data visualization who is experienced with Excel, particularly in creating interactive line graphs. I have a recurring monthly data set with complex multidimensional features that I'd like to transform into clear, understandable visual representations. Key Tasks: - Create line graphs from multi-variable, multidimensional monthly data - Ensure the graphs are as interactive and user-friendly as possible - Provide insights on the patterns and trends from the data Ideal Candidate: - Proficient in Microsoft Excel and data visualization tools - Must have experience dealing with complex data sets - Able to produce minimalistic, clear, and interactive graphs - Possesses excellent attention to detail and strong analytical skills Underst...

    $110 / hr (Avg Bid)
    加急
    $110 / hr 平均报价
    21 个竞标

    This project involves the creation of an Excel sheet that's intelligently designed to use multiple 'if' statements in order to compute which tier of payments is due, in accordance with the tier specifications provided. You'll be working with payment tiers that are consistent for all calculations. All the 'if' statement conditions will be based on the Payment Amounts; you'll need to structure your statements primarily around this element. Key project specifics: - The 'if' statements will be based on specific payment tier ranges. - Detailed guidance and specifications for these tiers will be provided. Ideal Skills: - Proficiency in Excel and excellent command over using 'if' statements - Exceptional attention to ...

    $198 - $2477
    加封 保密协议
    $198 - $2477
    38 个竞标

    ...para generar textos. - Mantener un lenguaje claro, concreto y consistente en todas las descripciones. Requisitos: - Cumplir con los plazos establecidos. - Las descripciones son en español. - Se puede utilizar software como Selenium, Puppeteer o Headless para las capturas de pantalla. - Familiaridad con el uso de herramientas de generación de contenido como ChatGPT. - Se entregarán todo en excel. ----------- Ejemplo de Estructura de Descripción: - Imagen captura de pantalla o logo. - Descripción: Breve introducción a la aplicación y su propósito. - Funcionalidades: Detalles sobre las características principales de la aplicación. - Ventajas: Beneficios específicos que ofrece la aplicación...

    $1041 (Avg Bid)
    $1041 平均报价
    41 个竞标
    Recopilación de datos 已经结束 left

    Necesito a alguien con un gran entendimiento y experiencia en la recopilación de datos. El proyecto consiste en obtener datos de texto de fuentes abiertas al público. Responsabilidades clave: Recopilar datos de texto específicos de diversas plataformas públicas. Garantizar una recopilación de datos precisa y detallada. Devolver los datos en formato Excel con una estructura concreta. Freelancer ideal: Debe ser detallista. Experiencia en la recopilación de datos de fuentes públicas. Fuertes habilidades de investigación.

    $1143 (Avg Bid)
    $1143 平均报价
    39 个竞标

    I'm in need of a proficient Excel expert to design a Point of Sale (POS) system with comprehensive features. These include: 1. Sales Tracking: The system should accurately note each sale's date and time, product names with their respective quantities, as well as the total sale amount and payment method. 2. Inventory Management: Real-time inventory updates are a necessity. I also need the ability to introduce new products into the system. 3. Customer Ledger: This is another essential feature. Ideal candidates should have extensive experience with Excel, have knowledge in POS systems, and understand sales and inventory management systems. It's important that you're detail-oriented and able to adhere to deadlines.

    $838 (Avg Bid)
    $838 平均报价
    14 个竞标

    I'm seeking a skilled data analyst to help with tasks including data cleaning and preprocessing, data visualization and reporting, and statistical analysis. The data they will be working with is of medium size, ranging between 1GB to 10GB. Prior experience with Python, SQL, and Excel is crucial for this project. Specifically, proficiency with the Python libraries Pandas and Matplotlib is required for the analytics components of the work. This project requires both strong technical skills and a thorough understanding of data analysis methodologies.

    $3514 (Avg Bid)
    $3514 平均报价
    59 个竞标

    I'm looking to convert an image that showcases buildings into an AutoCAD (.dwg) file for architectural planning purposes. Ideal Skills and Experience: - Proficiency in AutoCAD software and 2D drafting - Demonstrate understanding of basic architectural planning - Ability to accurately digitize buildings from images - Attention to detail and precision in keeping true to source material - Swift turnaround time to accommodate the planning schedule.

    $164 (Avg Bid)
    $164 平均报价
    49 个竞标

    I am seeking a skilled developer to import an FBX model with textures to my website. Key Requirements: - Expertise in functionalities, particularly in 3D modeling and rendering, creative and interactive animations, and VR integrations. - The ability to effectively import a provided FBX model and corresponding textures to a web platform, ensuring its interactive and smooth function on my personal website. Ideal skills and experience: - Proven experience in and 3D modeling. - An extensive background in integrating VR objects to websites. - Positive track record of working with FBX format and texture files.

    $501 (Avg Bid)
    $501 平均报价
    11 个竞标

    I am urgently in need of help with statistical modeling in XLSTAT. An understanding of a variety of statistical models is crucial for this task, as I did not specify the type of model I will be using. Skills and experience needed: - Proficiency in XLSTAT - Advanced understanding of differing statistical models - Ability to execute tasks in a timely manner - A strong background in statistics While this job needs to be done ASAP, I am also looking for quality work. Aiming to better understand the differences between salaries of graduates, the university has collected data from a sample 558 members of alumni. The data include salary of 186 Marketing majors, 186 HR and 186 Accounting graduates based on years of experience upon graduation from the School of Business. The data refl...

    $507 (Avg Bid)
    $507 平均报价
    14 个竞标

    Make ppt presentation for stakeholders using new mpp file and theses requirements: 2. The original plan is the baseline, updating the schedule with actual start and finish dates. 3. Initiate Milestone put 100% complete, what does the variance tells us? Are we ahead or not? 4. Critical Path – what is this telling us as we move to the next stage? 5. Activities with some flexibility / float? What can we shrink or expand the time scale and impact on the budget? 6. What if scenarios 7. Would working on weekends and holidays have a positive impact? Good Friday March 29th so no good 8. Project schedule will change based on resource availability, impact on the budget? 9. Special calendar, will it make the critical tasks before it disappear and what impact will it have, ...

    $172 / hr (Avg Bid)
    $172 / hr 平均报价
    1 个竞标

    ...individual to assist in reorganizing an array of financial data into an Excel table. The primary financial data fields to be included are related to the revenue and net profit. Below is what an ideal candidate for this project should possess and the tasks to be executed: Qualifications required: * Proficiency in Microsoft Excel … index match formulas Tasks to be performed: * Pull data from an existing set of records * Format that data into a predefined layout (I have created the table) * create graphs from table The objective of this project is to transform the financial data into a user-friendly format, thus enhancing its readability and comprehension. It is expected that the final deliverable would be a well-organized Excel table showcasing the rev...

    $931 (Avg Bid)
    $931 平均报价
    77 个竞标
    Trophy icon Logo Redesign for Rebranding 已经结束 left

    I need a logo for a brand named Aleeha-Logistics. Our brand will work with export, import, drop-shipping and e-commerce service. We will provide door to door service from China to Bangladesh. Key Characteristics for the logo: - Simplicity - Text-based - Any mix creative concept will be appreciated Check attached logo for inspiration. we're willing to keep the same design with our new e-commerce drop-shipping business concept. You need to submit at least 3-5 mock up to win the contest

    $86 (Avg Bid)
    加保
    $86
    255 项参赛作品

    The home page of your web site gives a brief introduction of your hotel (note the hotel shall be named after your real name or your team’s name) which includes the address, email, phone numbers, and direction to your hotel (can make up these information to protect your privacy) Your hotel website allows user to select check-in and check-out dates; select number of rooms; select number of adults and children. You shall validate user’s selection. For example, checkout date shall be later than check in date. Number of people shall be positive etc. Your website will only show available rooms for the duration of stay of the reservation. If there are no rooms available, then notice the user about that. When these rooms are displayed, make sure also display images for different type o...

    $959 (Avg Bid)
    $959 平均报价
    22 个竞标

    I'm in need of a competent freelancer well-versed in data entry to assist with a project. Key Responsibilities: - Inputting text data into Excel in a tabular format - Ensuring data accuracy during entry Skills & Experience: - Proven track record in data entry - Proficiency in Excel is a must - Detail-oriented with a high level of accuracy - Experience in handling tabular data In your bid, please demonstrate your understanding of the task and highlight your relevant skills and experiences. Don't forget to include your turnaround time as well.

    $85 / hr (Avg Bid)
    $85 / hr 平均报价
    102 个竞标

    Hello, I am in need of an Excel expert who specializes in financial planning. The goal of this project is to build a comprehensive financial plan specifically for a property investment I'm considering. Here are some more details: **Tasks** * Build an Excel model that projects income and expenses over a set period. * Configure the model to include a loan amortization schedule. **Income Projections** * The model should account for two primary sources of revenue. First, regular rental income. Second, potential income from the eventual sale of the property. **Expense Projections** * The model must also provide expense projections. This should include regular maintenance costs as well as costs associated with the property's development and conversion from a house ...

    $3728 (Avg Bid)
    $3728 平均报价
    61 个竞标

    Necesito un libro de Excel que, al introducir datos específicos en una hoja, haga una serie de cálculos en varias hojas y tenga un dashboard para consultar y comparar. En la hoja “RESPUESTAS RAW” iré introduciendo manualmente los valores “DNI”, “DNI_OCR”, “APELLIDOS”, “NOMBRE” , ”FECHA”, “QR1”, “QR2” y “OTRO”. Desde ahí pasamos a las columnas P1_R1, P1_A1 hasta la P1_R100 y P1_A100. Después de la P2_R1 y P2_A1 a la P2_R100 y P2_A100. Quiero que, en una segunda hoja que se llamará “RESPUESTAS PROCESADAS”, analice los datos de la hoja “RESPUESTAS RAW” desde la columna P1_R1 a P1_Rx y P2_R1 a P2_Rx y los compare ...

    $1581 (Avg Bid)
    加急 保密协议
    $1581 平均报价
    21 个竞标

    I am in need of an Excel template that can handle both numerical and date-oriented data. This template should be flexible and able to incorporate both rows and columns as data categories or entries, based on what suits the data best. Here are the specific requirements: 1. Data Types: The template must accept numbers and dates. It should ensure the data remains organized and easy to manage. 2. Flexible Structure: Rows and columns should be utilized selectively depending on the data at hand. I trust your judgment to decide when to use rows or columns as categories or entries. 3. Calculations/Formulas: While I am not certain about specific formulas or calculations that might be needed, I would like the template to be built with the capacity to easily include these if required in th...

    $157 / hr (Avg Bid)
    $157 / hr 平均报价
    33 个竞标

    I'm looking for a competent VBA programmer from Tamil Nadu to support me in various tasks for around 40-60 hours per month. I seek an expert who can aid in automating processes, creating macros, and performing data analysis. Key Responsibilities: - Developing and implementing VBA macros to automate processes. - Providing data analysis support using VBA. - Invoice-related tasks, concentrating predominantly on programming. Ideal Candidate: The ideal candidate should have a strong understanding of VBA (Visual Basic for Applications). Prior experience in automating tasks, data analysis and creating macros is a must. It would also be beneficial if the candidate has experience in invoice-related programming tasks. Being located in Tamil Nadu is mandatory...

    $744 (Avg Bid)
    $744 平均报价
    17 个竞标

    I have...project that involves converting data from PDF files. The data is specifically in text format and needs to be categorized into columns upon conversion to Excel. The type of data fields to be recognized and converted are alphanumeric. I am seeking a freelancer with an eye for detail and a deep understanding of alphanumeric systems. The freelancer should be skilled in data entry, data processing, and proficient in Excel. Experience with PDF data extraction will also be a huge plus. - Convert text in PDF to Excel - Organize data categorically in columns - Recognize and convert alphanumeric data fields The goal is to have an error-free Excel file, with all text data correctly categorized in columns for easy analysis. Ensure you can meet these r...

    $88 (Avg Bid)
    $88 平均报价
    67 个竞标

    I'm seeking a proficient Power BI Developer to aid in data analysis. Need final output in 12 hours, any higher time would be rejected. Key Tasks: - Import and analyze data from Excel spreadsheets - Work with relatively simplistic data structure, including a few columns with mostly numerical data - Create and implement compelling visual representations of this data. Specifically, using tables, matrices, charts, and graphs. Ideal Skills and Experience: - Proven experience with Power BI is a must. - Knowledge using Excel spreadsheets for data analysis. - Ability to create concise visualizations using tables and matrices, charts and graphs. - A detail-oriented mindset and ability to work with numerical data effectively. This is a straightforwar...

    $618 (Avg Bid)
    $618 平均报价
    41 个竞标

    For my business, I am seeking an Excel wizard capable of building formulas and functions for analyzing data. This data originates from a pair of our inventory databases which need to be matched with incoming inquiries. These inquiries include specific fields such as make, model, part name, and part number. Main Job Details: * Creating Excel formulas and functions for the specified data analysis * Focusing on indicating our inventory levels against these inquiries The ultimate goal is to have you shift all matched rows to a separate sheet within Excel based on the analysis. I am listing scenarios to solve for, by increasing complexity level Matching with available part numbers (exact matches) Matching with available part numbers (approx matches eg MAN B&W p...

    $626 (Avg Bid)
    $626 平均报价
    29 个竞标

    I am urgently in need of a detail-oriented and experienced professional who can help me with data entry tasks on Excel. This project will focus specifically on Excel tasks, which is where I am currently struggling the most. Ideal Skills and Experience: - Extremely proficient in Excel - Strong data entry skills - Prior experience in dealing with data cleaning, formatting or analysis is a plus Application Guidelines: I would appreciate if you could include information about your past work in your application. Evidence of similar jobs completed will be highly considered and greatly appreciated. I am looking forward to your applications and the experience you bring to the project.

    $141 / hr (Avg Bid)
    $141 / hr 平均报价
    91 个竞标

    I need someone to undertake an urgent data entry project. I have a printed directory that consists of approximately 400 names, house numbers, and email addresses that need to be transferred into various email address files. Here are my specific needs: -Import the data into email address files -Each email address should be separated by a comma -Ideally, the project should be completed as soon as possible Your background should include: -Previous experience in data entry jobs, ideally with directories -Proficiency in using Excel, Google sheets and CSV files -Good attention to detail, as accuracy is paramount -Ability to work under tight deadlines Your task will essentially involve transforming the physical directory into a digital, easy-to-navigate resource. Feel f...

    $117 / hr (Avg Bid)
    $117 / hr 平均报价
    8 个竞标

    I am seeking a highly versatile and efficient virtual administrative assistant to help maintain day-to-day operations for my business. Your duties and responsibilities will i...Managing my social media pages • Implementing email marketing plans - creating engaging emails and sending them out to interested parties I anticipate requiring assistance for 25-30 hours per week, though this may vary depending on the workload. The ideal candidate will have excellent communication skills and should be familiar with the following tools and software: • Microsoft Office (Word, Excel, PowerPoint) • Customer Relationship Management (CRM) software • Social media management tools • Jobber Previous experience in a similar position will be highly regarded. I look forwa...

    $57 / hr (Avg Bid)
    $57 / hr 平均报价
    61 个竞标

    However, can you Suggest such a tool? A tool that can manage a complex task demanding expertise in software development, blockchain technology, and cryptographics. An AI that not only offers code suggestions but also has the capability to import, review, and validate modifications to ensure they meet the requirements and rectify errors effectively

    $94 / hr (Avg Bid)
    $94 / hr 平均报价
    13 个竞标

    I need someone to undertake an urgent data entry project. I have a printed directory that consists of approximately 400 names, house numbers, and email addresses that need to be transferred into various email address files. Here are my specific needs: -Import the data into email address files -Each email address should be separated by a comma -Ideally, the project should be completed as soon as possible Your background should include: -Previous experience in data entry jobs, ideally with directories -Proficiency in using Excel, Google sheets and CSV files -Good attention to detail, as accuracy is paramount -Ability to work under tight deadlines Your task will essentially involve transforming the physical directory into a digital, easy-to-navigate resource. Feel f...

    $2873 (Avg Bid)
    $2873 平均报价
    190 个竞标

    Creating dashboards using power bi

    $2432 / hr (Avg Bid)
    $2432 / hr 平均报价
    3 个竞标
    Excel Formula Development 已经结束 left

    I'm in need of someone highly proficient in Excel to create a specialized formula for a particular task. This includes: - Creating a formula that can accurately detect if any of three specified texts are present within a cell, regardless of the order or placement. - Upon detecting any instance of these specified texts, the formula should automatically enter '0' into the cell. Ideally, you should have extensive experience with complex Excel operations. A deep understanding of text-related functions in Excel, including search functions and logical conditionals, is necessary for the successful completion of this project. Familiarity with large datasets and maintaining accuracy throughout could be helpful. Please ensure your bid reflects your understandin...

    $901 (Avg Bid)
    $901 平均报价
    92 个竞标

    I have files getting saved in google drive directory, I need google sheet to update File name, File creation Date, File Owner name, File link. The sheet should stay synced with Drive and upidate, for the existing files and and if new files get added in that google drive directory. Achieve this with google script Solution from Google Bard Complete and get best feedback

    $93 (Avg Bid)
    $93 平均报价
    19 个竞标

    ...my Windows computer. The ideal candidate should have expertise in handling Gmail API or similar tools and be proficient in implementing it on a Windows operating system to achieve the desired outcome. Considering there is no strict timeline for completion, the emphasis will be on ensuring quality and accuracy. Key Project Requirements: - Archive Gmail email threads in both HTML and Structured Excel format. - Ensure the archive is easily browsable and accessible on my Windows computer. - Must have done similar project before, and able to give demo on what was done as output. Practical experience with Gmail API or comparable tools to handle the email exports is a must. - Clear and timely communication throughout the project timeline. Please be ready for Zoom call interview to de...

    $211 (Avg Bid)
    $211 平均报价
    5 个竞标

    I require a highly skilled System Administrator with extensive knowledge of Magento 2, Linux, and MySQL. Your tasks will be to: - Install Magento 2, elastic search and import code and DB into new server. - I'm open to your recommendations on the Magento 2 version that would best suit our project. Successful applicants should have: - Proven experience with Magento 2 installations - A deep understanding of Linux server management Please, note that effective communication and strict adherence to deadlines are crucial for this project. I'm looking forward to your bid.

    $180 (Avg Bid)
    $180 平均报价
    27 个竞标

    Develop an automated system that allocates bus lines to interviewers based on their locations, interview quotas, and available transportation modes (buses, trains, metro, and walking). Key Features Import from Excel for interviewer locations and bus line data with quotas for interviews. A module for fetching and updating transportation data via API. An optimization algorithm for route planning. Output to Excel in specific format. Specific Scheduling Requirements Interview Frequency: An interviewer can conduct approximately one interview every 5 minutes. Interviews Per Bus: A maximum of 8 interviews is allowed per unique bus on a specific bus line per day. There is no identifier for each unique bus, so the system needs to be able to plan to catch another bus, based on...

    $2301 (Avg Bid)
    $2301 平均报价
    14 个竞标

    ...freelancer should be well-versed in web design and development, have experience creating simple websites, and ought to be able to complete the task within the given timeframe. A solid grasp of graphic design and illustration would also be beneficial, but not necessary for completing the job. Looking for MsSQL database , React and .Net developer with strong React knowledge. We run our test automation using robot framework for two websites. We need to show all test suites and test cases on the website when clicked on the test cases' menu. When the user clicks on the test suite, the website will run the robot framework command on the system. If the user clicks on the test case/testsuite, you will run the robot command. We need to show progress/command output on the UI. Also...

    $39 / hr (Avg Bid)
    $39 / hr 平均报价
    21 个竞标

    I’m looking for someone with a good grasp of Python development skills for a small-scale project. Your task will be primarily focused on file manipulation. Job Requirements: - Extensive Python knowledge. - Experience in handling file manipulation-related tasks. - Ability to write clean, efficient, and maintainable code. Specific Task: - The job involves the manipulation of files through the Python program, so prior experience in this domain will be helpful. This is a one-off project that could lead to a longer-term relationship if everything goes smoothly. I am looking forward to seeing your proposals, and don't hesitate to ask if you have any questions concerning this project!

    $2090 (Avg Bid)
    $2090 平均报价
    16 个竞标

    As a content curator, I require someone with a great sense of humor and a knack for spotting funny content to help me out. Your role will involve: - Watching a wide range of comedy and prank videos on YouTube. - Selecting the funniest ones and converting them into bite-sized videos (less than a minute long) using an AI tool I'll provide. - Reviewing the generated short-form videos, cherry-picking the funniest ones, and sending them to me via a Cloud Storage link. Ability to utilize AI tools and experience in content curation are a must. Taste for comedy and strong attention to detail will play to your advantage. Please bid if you're ready to entertain and make people laugh!

    $149 (Avg Bid)
    $149 平均报价
    22 个竞标

    Please read full requirement. We are requesting for a monthly quote. I require a skilled developer to assist me for approximately 2 hours daily, resulting in around 40-60 hours of work each month. The core tasks will include: - Programming in Excel, PowerPoint, and Outlook apps. - Scripting and automation - Data analysis and visualization The ideal candidate should be proficient in the following: - Excel, Outlook, Powerpoint automation . - Scripting and automation using Python, VBA or similar languages. - Invoice/Data entry - Analysis Please provide a quote for your expected monthly charges considering the mentioned workload when submitting your bid. Let's automize my workflow together! If you are really good in what you do, Salary is not a limit....

    $712 (Avg Bid)
    $712 平均报价
    21 个竞标

    I'm seeking a meticulous professional to perfect my DXF file. This 2D vector graphics file requires an expert's touch to address its flaws: notably, unusual roundings and lack of sharp points. It will be the foundation for a logo and website animation. The job: - Tackle the entire file, not just specific areas. - Normalise the roundings across the file. We're looking for uniformity rather than removal or reduction in roundness. I have uploaded a png with the graphic and some areas that need work. PLEASE NOTE I WANT IT ALL REDONE TO BE A SIMPLE, CRISP AND HIGH-QUALITY VECTOR.

    $102 (Avg Bid)
    $102 平均报价
    4 个竞标

    I have a video with me eating bananas with a green screen behind me. I want you to change the video so that there are lots of different images of fruit changing behind me. Use capcut to produce and send me the project and video. If you do well at this then you will get my future projects.

    $94 (Avg Bid)
    加保
    $94
    19 项参赛作品

    I am seeking a diligent freelancer with expertise in converting single column numeric data from PDF files to Excel. The ideal candidate should have: - Demonstrable experience with similar projects - Proficiency in data extraction or manipulation tools - Proven background in handling single column data specifically numeric Please make sure you include your past work in your application. Experience in the relevant field would be a plus. The tool is expected to accurately convert these numeric values, ensuring the integrity of the data remains intact. If you believe you're the right fit for this, I look forward to your proposals.

    $1778 (Avg Bid)
    $1778 平均报价
    126 个竞标

    I am seeking an experienced data input specialist who can expertly type extensive text data into an Excel sheet. The successful candidate should excel at organizing data. Here are the key elements of the job: - The data should be arranged in an alphabetical order. - Mastery in Excel data entry and alphabetizing tools. - Though there is no specific need for any formatting, a clean and easy-on-the-eyes layout would be appreciated. This assignment requires attention to detail and excellent organizational skills as accuracy is crucial. Previous experience in similar data entry roles would be beneficial.

    $31 / hr (Avg Bid)
    $31 / hr 平均报价
    141 个竞标

    ...into a single, clean CSV file with four columns compatible for upload to Xero. What You'll Do: - Extract customer Date, 2 x sales amount columns (Debit & Credit into 1 column), description and Balance from the supplied xlsx files. - Carefully organize extracted data into a well-structured, 4-column CSV output. The workload is small, consisting of a few hundred records. However, there are 2 fields for the amount$. One is Debit and one is Credit, they need to be combined ointo 1 column. Debt needs to be a minus symbol so using brackets will create this in accounting terms (50.00) will show as... -50.00 on the csv Ideal Skills: - Data entry expertise - Familiarity with Xero's data import requirements - Strong attention to detail - Proficiency in Mi...

    $139 (Avg Bid)
    $139 平均报价
    39 个竞标

    ...CSV file creation with the ability to handle both numerical and textual data. Here are the key requirements for my project: 1. Format of the CSV File: - The CSV file format should be strictly comma-separated (CSV). Therefore, the freelancer should be adept in working and manipulating data in this format. 2. Type of Data: - The CSV file will contain a mixture of both numerical and textual data. So, the preferred freelancer should have the ability and experience handling these two types of data. 3. Data Segmentation: - The data in the CSV file should be segmented by specific fields. If you have a clear understanding of categorizing data based on specific fields, it will expedite this project. The ideal professional for this project would hav...

    $107 (Avg Bid)
    $107 平均报价
    16 个竞标

    i am looking for someone to show me how to merge date and time in one cell

    $92 (Avg Bid)
    $92 平均报价
    18 个竞标

    ...clean CSV file with four columns compatible for upload to Xero. What You'll Do: - Extract customer information, sales transactions, and inventory items from the supplied xlsx files. - Carefully organize extracted data into a well-structured, 4-column CSV output. The workload is small, consisting of a few hundred records. However, there are 2 fields for the amount$. One is Debit and one is Credit, they need to be combined ointo 1 column. Debt needs to be a minus symbol so using brackets will create this in accounting terms (50.00) will show as... -50.00 on the csv Ideal Skills: - Data entry expertise - Familiarity with Xero's data import requirements - Strong attention to detail - Proficiency in Microsoft Excel and CSV formats Experience with ...

    $172 (Avg Bid)
    $172 平均报价
    56 个竞标

    I'm seeking a skilled Excel VBA expert to assist with automating data entry for my business. The main task would involve creating a system for automatic invoice generation based on the amount paid to suppliers. Key Responsibilities: - Develop a VBA script to automate the generation of invoices. - Ensure the system is adequately designed to eliminate manual data input. Ideal Skills and Experience: - Advanced knowledge of Excel VBA. - Proven experience in automating data entry and creating custom functions. - Familiarity with financial data, specifically pertaining to invoicing, is a crucial prerequisite for this job. Please note: This project involves working with sensitive financial data. Therefore, a high level of accuracy and acute attention to...

    $720 (Avg Bid)
    $720 平均报价
    18 个竞标

    I require a freelancer to create an Excel based tool capable of budgeting the manpower for less than 10 employees. The tool is needed only once to calculate a fixed one-time cost. The scope of this tool should include: * Budgeting of manpower and sales targets * Adding manpower on bump up The ideal candidate will be adept at Excel, more specifically with creating formulas, budget spreadsheets and tools within the application. A background in HR or business finance would be highly beneficial to fully understand the intricacies of employee costs.

    $92 (Avg Bid)
    $92 平均报价
    15 个竞标