Cara membuat aplikasi excel untuk database jobs

I need a freelancer to help me gather real estate property addresses from public companies' websi...addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Understanding of rea...

...looking for a comprehensive database that can manage client information as well as requests for quotes and confirmed orders and/or projects. It should also be able to track project history, with an integrated time tracking application. Key Features: - Client Contact Information: The database should store all relevant client details for easy access and management. - Client Project History: It should keep a record of all past and current projects associated with each client. - Integrated Time Tracking: The time tracking app needs to be seamlessly integrated with the client management database. Quickbooks Time is a good starting point for this app. - Integrated work order form for jobsite clients to permit invoicing at a laterdate. Ideal Skills and Experience: - D...

...Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • For destinations within the Department of Lima and the Province of Lima: • Calculate shipping costs using the provided price table. • For destinations outside the Department of Lima and the Province of Lima: • Di...

...sheets linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Experience...

I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner

I need a methodical and detail-oriented freelancer to assist with data entry from supplied aerial site ...images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Excel - Previous experience with similar dat...

I am looking for a skilled VB.NET developer to assist in resolving issues (now and ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net w...ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net we also need an installer so we can push updates to clients. Key Requirements: - Develop a VB.NET application that can scan and read content from Excel and Word documents. - Implement functionality for the app to interpret different types of content such as text, tables, and charts. Ideal Skills: - Proficiency in VB.NET - Experience in developing applications for document scanning and reading - Familiarity with Excel and Word document structures -in...

I'm seeking a dedicated freelancer to help gather data ( or share already researched data) on international students currently attending U.S. universities. The data should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student First Name - Student Las...candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need this data regularly over the next few months. Delivery Format: The data should be delivered in a Spreadsheet (Excel/CSV). If you already have a database of this information, please let me know. Looking forward...

...criteria. • Data Capture: Capture and save key information about each target company into our database. • Financial Assessment: Conduct financial modeling, evaluate revenue streams, and assess growth potential for potential acquisitions. • Due Diligence: Collaborate with the team to conduct due diligence, reviewing key metrics, customer data, and operational details of target companies. • Collaboration: Work closely with the leadership team to refine acquisition strategies and contribute to portfolio growth. What We’re Looking For: • Strong interest in online businesses, digital assets, and entrepreneurship. • Exceptional analytical skills with a detail-oriented mindset. • Proficiency in Excel, financial modeling, and market rese...

I have numeric data that needs to be entered. The data is currently in Excel spreadsheets. I am looking for a freelancer who can assist me with data entry from these spreadsheets, ensuring accuracy and efficiency.

I have a project that involves transferring data from PDF documents into an Excel spreadsheet. The documents are about 100 pages long and contain a mix of text and numbers. The successful freelancer will need to: - Accurately input this information into Excel in both alphabetical and numerical order. - Use a pre-existing template, with potential for adding or deleting columns based on predefined rules or guidelines. Ideal candidates will have strong attention to detail, experience with data entry and proficiency in Excel. Prior experience dealing with PDF to Excel data transfer will be highly regarded.

I need an Excel spreadsheet that can perform specific calculations with my numeric data. - The spreadsheet should be able to multiply specific columns together: Column B with Column E to get G, Column C with Column F to get H. - It should then add these two results together to fill Column I. - Next, Column I should be multiplied by Column J to fill Column K. - This sequence should repeat with Columns L through P and a few additional columns. Ideal skills for this job include advanced knowledge of Excel, particularly in using formulas for multiplication and addition across various columns. Experience with data management and numerical data analysis would also be beneficial. Please ensure you have a strong understanding of Excel's capabilities before bidding.

I'm looking for a corporate strategy expert to develop an action plan for my collection department focusing on expediting dispute resolution. The primary goal of this plan is to enhance the efficiency of our dispute resolution process. Note - i have the excel file i can show you the data but not shareable you need to analysis the data and provide me the strategy and action plan. Key Requirements: - Analyze current collection & dispute resolution processes - Identify potential bottlenecks causing delays - Propose actionable strategies to streamline these processes Skills & Experience: - Proven track record in corporate strategy development - Experience within a collection department is a plus - Strong problem-solving skills - Excellent communication and presentation a...

...to customer inquiries, resolving issues, and ensuring a positive customer experience. - Research Tasks: Conducting online research for various projects and compiling findings in a clear and concise manner. - Social Media Management: Overseeing company social media accounts, posting updates, and interacting with followers. Ideal Skills and Experience: - Proficient in the Microsoft Office Suite: Excel, Word, PowerPoint, and Outlook. - Familiar with CRM Software: Experience with tools like Salesforce or HubSpot is a plus. - Knowledgeable in Project Management Tools: Comfortable using software like Trello, Asana, or Monday.com. - Strong Customer Service Skills: Previous experience in a customer support role is preferred. - Excellent Research Skills: Able to find and compile informat...

I'm looking for a diligent data entry expert to help transcribe text from PDF files into a database. This project requires attention to detail and a high level of accuracy. Ideal Skills: - Proficient in data entry - Excellent reading and typing skills - Able to work with PDF files - Detail-oriented - Able to maintain confidentiality

... and boost conversions. Dedicated to helping businesses grow their online presence and achieve measurable success. in-depth market research and competitive analysis to identify trends and optimize campaigns. , execute, and monitored multi-channel campaigns, including SEO, PPC, social media, and email marketing, resulting in 20% increase in lead generation. advanced Excel skills to analyze campaign performance, creating insightful reports for clients. visually appealing and professional presentations using PowerPoint to communicate marketing strategies and results effectively. engaging content for websites, blogs, and social media, increasing audience engagement by 15%. websites and landing pages for search engines, driving 40% growth

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

I need assistance with my business bookkeeping, with under 400 bank transactions across two accounts. All data is available in Excel sheets exported from my bank accounts. - Clean up and categorize the transactions. - Prepare a Profit and Loss (P+L) statement for the year 2024. The P+L statement will help me assess the financial performance of the business in 2024. I prefer using Excel for this task. Ideal candidates should have: - Proven experience in bookkeeping and financial analysis. - Proficiency in Excel. - Ability to categorize transactions at a basic level (e.g., income, expenses). - Capability to prepare a P+L statement without specific formatting requirements.

I need an existing Excel document converted into an updated fillable PDF. I have an original fillable PDF available for comparison. The project requires: - Updating form fields and layout - Adding new sections or fields The design elements from the original fillable PDF should be retained. The original fillable PDF is in Adobe Acrobat PDF format. Ideal skills for this project include: - Proficiency in Adobe Acrobat - Experience creating fillable PDFs - Strong attention to detail - Ability to work with Excel data

...achieving over 20% returns in the past month. - Profound knowledge and experience in options trading, specifically with the mentioned strategies. - Python programming expertise, with prior experience in developing trading programs. -Program must be continuously running and historic and live data should be from free api sources. (Or cost of service is considered against the month returns). -Daily dated excel file outputs of trades, costs, and gains preferred (not required) -Strategy must work with a max. account size of $30,000 (no margins). Summitions must be made by Feb. 1 and competition starts Feb 3. After all submitions, programs will be ran in paper trading account. Best performance over 20% gains after a month, wins. The last week, the top 3 will be live accounts and wi...

I'm seeking a MySQL specialist to help optimize my database primarily to reduce storage usage. The database is currently storing both text and numeric data. Ideal Skills: - Extensive experience with MySQL database optimization - Proficient understanding of data storage techniques Key Responsibilities: - Analyze the current database structure and usage - Implement effective strategies to reduce storage requirements without compromising data integrity

...between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with Excel files using Python (openpyxl, pandas). Experience with automating image processing tasks. Strong attention to detail and problem-solving skills. Project Details: This is a freelance task-focused project with flexible variations in screenshots. You’ll need to provide code for both cropping and conversion to Excel. So I can ...

I'm in need of a Java programmer who can create a small program for me. The program's purpose is to convert a PDF file into an Excel file in a tabular format. Key Requirements: - The program should be able to extract all data from the PDF and convert it into Excel. - The conversion should be straightforward, without any data processing or formatting applied to the Excel file. Ideal Skills: - Proficiency in Java - Experience with PDF to Excel conversion - Familiarity with data extraction from PDFs This is a simple project, but it requires attention to detail to ensure all data is accurately converted.

Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?

I'm looking for an Excel expert to optimize my spreadsheet for data analysis. The primary purpose of the Excel sheet is to optimize sales price calculations. The project requires the optimization of the sheet to facilitate specific analyses and reports, including sales price calculations. Skills and Experience: - Advanced Excel skills - Experience with data analysis - Ability to create and optimize complex spreadsheets Please provide examples of previous similar projects you have worked on.

...audience is potential employers, recruiters, and clients who are looking for a skilled and experienced Data Entry Specialist. I want to attract opportunities in industries such as finance, healthcare, and technology. Key Skills and Experience: - Data entry and management - Attention to detail and accuracy - Organizational and time management skills - Proficient in Microsoft Office, particularly Excel, Word, and Access - Experience with data entry software and systems, such as CRM and ERP - Strong typing skills, with the ability to work quickly and accurately - Ability to work independently and as part of a team Achievements: - Consistently met or exceeded data entry productivity and accuracy standards - Successfully implemented data quality control measures to improve data ac...

I'm working on my final year engineering project and I need to implement an offline feature. The project should be able to make certain content available without internet access, specifically Excel sheets and reports. Key Requirements: - The system should allow for editing and saving changes to these offline Excel sheets and reports locally. - Once back online, the system should ensure data synchronization. Ideal Skills: - Experience in software development with offline capabilities. - Proficiency in working with Excel and data synchronization techniques. - Understanding of engineering project requirements.

I'm looking for a professional who can set up a Google Form to send welcome emails with attachments. The content of the attachments will include an automatically generated reference number. Excel is already setup just need the welcome mail Key Requirements: - Expertise in Google Forms and email integration - Ability to configure automatic reference number generation - Experience with setting up email attachments - Knowledge of ensuring email deliverability Please provide examples of similar projects you've completed.

I need someone to match data between two Excel files and integrate relevant information into File A. Key Requirements: - Compare product names in File A and File B - Fill File A with corresponding data from File B (specifically UNIT SIZE, GST RATE, HSN CODE as per their product names ) Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data matching and integration. I look forward to your proposals.

I'm looking for an Excel spreadsheet that can help me track my daily sales, inventory, exports, imports, and expenses. Key Requirements: - Daily input fields for sales, inventory, export, import, and expenses - Monthly summary calculations for total sales, expenses, inventory balance, profit and loss, and exports/imports across multiple outlets - Detailed tracking capabilities for each product and product categories The ideal freelancer for this project would be well-versed in Excel, particularly in creating spreadsheets with complex formulas and functions. You should also have experience in designing user-friendly interfaces within Excel to make data entry straightforward and intuitive. Since the number of outlets is uncertain, the spreadsheet should be flexib...

Do assigned excel tasks, design and support my freelance gigs on fiverr

...Project Using SQL, Excel, and Power BI Dashboard Description: I am looking for a skilled data analyst to assist with a project that involves data processing, analysis, and visualization using SQL, Excel, and Power BI. The project will require: Data Extraction & Cleaning: Extract and clean data from multiple sources using SQL. Ensure the data is accurate, complete, and properly formatted for analysis. Data Analysis in Excel: Perform statistical and trend analysis. Create pivot tables, charts, and perform calculations to uncover insights. Power BI Dashboard: Build an interactive and visually appealing Power BI dashboard. Include key performance indicators (KPIs), filters, and drill-down capabilities for detailed insights. Deliverables: Clean and well-structure...

I have PDF files containing text data that needs to be transferred into an Excel spreadsheet. The final output will require the application of custom styles in the formatting. Ideal skills for the job include: - Proficiency in Excel - Excellent data entry skills - Attention to detail - Experience with custom formatting in Excel

I'm seeking a VBA macro expert who can help optimize my code for faster execution. The macro is currently used for generating reports from data stored in Excel sheets. The main goal is to reduce the runtime of the macro to improve efficiency. Ideal Skills and Experience: - Proficiency in VBA programming - Experience with Excel-based data manipulation - Skills in code optimization and performance improvement - Ability to enhance code readability for future use Freelancers who can deliver a fast, efficient solution will be prioritized.

I need a comprehensive list of Defence canteen dealer contact numbers from specific cities in Madhya Pradesh - namely Bhopal, Indore, Gwalior, and Bhind. The information needs to be meticulously compiled into an Excel sheet. Ideal Skills and Experience: - Proficient in internet research and data extraction - Excel spreadsheet skills - Ability to work independently and self-motivate - Previous experience in similar data collection tasks is a plus.

I'm seeking assistance with specific small tasks in Excel that may require the use of VBA coding and formulas. Key Requirements: - Creating macros to streamline processes - Using the macros for data validation and cleanup Ideal Skills: - Proficient in Excel with extensive knowledge of VBA - Experience in creating macros - Capable of performing data validation and cleanup tasks

excel data entry work

Details sent

I need help with data entry into my CRM system. The data consists of customer contact information, which is currently stored in Excel spreadsheets. Please note that the specific CRM system has not yet been determined, so flexibility and adaptability are key for this project. Ideal Skills: - Proficient in data entry - Familiarity with various CRM systems - Strong attention to detail - Excellent knowledge of Excel - Good understanding of customer contact information

Project Description: I am looking for a skilled professional to guide me through analyzing data in Excel in a structured and professional way. My goal is to improve my Excel proficiency and learn practical techniques while working on my existing data. What I Have: • An Excel sheet with data ready for analysis. • Basic knowledge of Excel. What I Need: • A professional to guide me step by step in: • Data cleaning and preparation. • Using advanced formulas and functions. • Creating pivot tables and charts. • Analyzing trends and insights. • Other relevant professional techniques based on my data. Requirements: • Expert-level proficiency in Microsoft Excel. • Ability to teach and explain concepts ...

...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Go...

READ BEFORE YOU BID!!! Don't waste time giving one fee, then increase it after we chat. +++ BUDGET $10 ++++ INSTRUCTIONS NEEDED In all of my research, a WP Multisite has ONE shared database for main and subdomain. 1. Why does my multisite creation have 2 databases? 2. Give me step by step OR video instructions on how to create a multisite with main and subdomain that have ONE database, different themes and tables for contents of each site. I will release the milestone ONLY after I repeat your steps and it works.

...content, which is critical for functionality and usability. I'm seeking a skilled professional/ content aggregator to develop a comprehensive database for auto spare parts content. The database will primarily need to store text descriptions and specifications, images and diagrams, as well as customer reviews and ratings. Objective: To populate the website with accurate and comprehensive product content, ensuring customers can easily search for and purchase the auto spare parts they need. For example, if a customer needs a Toyota Corolla Engine from 2005, they can search for it on the website and purchase it directly. Key Requirements: - The database must seamlessly integrate with our existing e-commerce platform. - It should support advanced search and fi...

I'm in need of a seasoned professional who can provide me with a list of mortgage foreclosure overages leads, with thor...County, Lincoln County, Jefferson County, and Warren County. However, as my business expands, so will the scope of this project. This is an ongoing opportunity, with added cash bonuses for quality work. The data I require for each lead includes: - Name and last known address - Phone number and email - Property details and foreclosure status - Date of foreclosure All leads must be delivered in an Excel spreadsheet. Accuracy is paramount, and I'm looking for someone who can grow with my company. Ideal skills for this job include: - Proficiency in skip tracing - Experience with mortgage foreclosure overages - Exceptional attention to detail - Ability to ...

We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.

I'm experiencing a configuration error with my vTiger database. The current charset or collation isn't compatible with UTF8, and I need to change it to 'utf8mb4' and 'utf8mb4_unicode_ci'. I'm using MySQL, and I have full access to the database. However, I have not yet taken any steps to resolve the issue. The ideal freelancer for this project would be an expert developer with extensive experience in working with vTiger and MySQL.

I'm looking for a skilled web developer proficient in HTML, CSS, JavaScript, Node.js, and MongoDB. The primary goal is to create a website centered around movies, series, and other related content. Key Requirements: - Expertise in front-end technologies (HTML, CSS, JavaScript). - Proficiency in back-end development with Node.js. - Experience with database management using MongoDB. - Ability to create a user-friendly, engaging web interface. Skills and Experience: - Previous work on entertainment or content-centric websites is a plus. - Strong understanding of web development best practices. - Excellent problem-solving skills and attention to detail. - Ability to work independently and meet deadlines.

I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data in a comprehensible format.

I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings. Key Requirements: - The CRC8 polynomial is x8 + x2 + x + 1. - The CRC16 polynomial is X16+X12+X5+1. - The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction. - I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet. As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex) This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81 (both can be checked usi...

I will develop a flutter app with backend and admin panel for diet tracking and other features as discussed. Deliverables are: Backend APIs and Database Admin Panel Android APK iOS IPA