search

zuri-training / Excel_comp_Team108_DataSYNC

A project that allows users compare multiples excel files easily.
2 stars 25 forks source link

readme

Team_108

Team108-DataSYNC Repo

Introduction

An Excel_comp project. Project carried out by Team 108.

This is a platform that enables users to compare the content of excel files easily.

Technology Used

This project is created with:

DEPLOYMENT INSTRUCTIONS

Deployment

  1. Install Python Environment/Python Virtual Environment
  2. In the Environment/Virtual Environment 2a) Ensure you are in your root folder where the requirement.txt file is located.
  3. Install all the dependencies in requirements.txt file with 3a) pip install -r requirements.txt
  4. Run Manage.py runserver
  5. Create a User
  6. Convert your files

It uses a DBSQlite3 Database in the interim.

~~Yes, its as easy as that~~.

Other files would be uploaded as we try to beautify it now:

Pictures for the Mission Page and the About Us Page

Contact Page consume
Convert
File Library
Account PAge
Other Two Functions (add-ons)

PROJECT TITLE

DATASYNC (spreadsheet compare solution.)

Team_108

BACKGROUND OF THE PROJECT

Spreadsheets are excellent tools for computing data and processing information. Existing ones like Microsoft Excel, Google Sheets, Smartsheet, etc. can perform from simple tasks, like basic arithmetic, to hard tasks like visual basic applications (VBA) codes.. However, in instances where two or more worksheets, particularly ones with large amounts of data, locating specific information like duplicates and differences can be difficult, even for the best eye. Although existing Spreadsheet packages can detect such errors, they’ll require formulas and low codes always, plus, users will still have to scrutinise the output themselves. It's a laborious process that does too little to increase productivity.

DESCRIPTION

In an age where we are increasingly relying on technology to boost productivity, being able to spot duplicates and find other specific Information in a large pool of data within spreadsheets, at the tap of a single button becomes a necessity. A tool like this gives data and information professionals a great advantage, and competitive edge. Which is where our solution comes in. Please say hello to DATASYNC.

DATASYNC is a responsive web app leveraging JavaScript, Django and CSS to build a platform that allows users to upload and compare multiple spreadsheets.

PRIMARY REQUIREMENT OF THE PROJECT:

  1. UNAUTHENTICATED USER
    • Visit the platform and view basic documentations on it.
    • Interact with the documentation
    • Register to know more, and use the platform
    • No access until registered
  2. AUTHENTICATED USERS
    • Full access to the platform
    • Allow upload csv/excel file
    • Users should get the option to:
    • Highlight duplicates in a single file
    • Remove duplicates and return a single file
    • Remove duplicates and return 2 files
    • Highlight duplicates and return 2 files

FEATURES ACCESSIBLE FOR USERS (AUTHENTICATED USERS ONLY)

  1. Merge excel sheets or workbooks efficiently by inserting and sorting the data in existing files.
  2. Make available the modified version of the document to the user.
  3. Users can upload and compare multiple files
  4. Users can convert files from one format to another
  5. Users can download their output in a format of their choosing, with any device connected to the internet
  6. Users can save their files to a custom library

FUTURE IMPROVEMENT ON THE FEATURES###:

  1. Protect document features that will allow user to protect their documents through passwording.

PROJECT STATUS

Completed.

HOW TO RUN THE PROJECT

INSTRUCTIONS ON HOW TO USE THE PROJECT

HOW TO HELP IMPROVE OR CONTRIBUTE FOR BETTERMENT OF THIS PROJECT

Thank you for your contibutions.

LINKS TO ALL RESOURCES RELATED TO THIS PROJECT.

  1. DESIGN: Figma was used to Implement all designs here is the figma link

SPECIAL CREDITS

Team members includes: Damilare Yetunde Jamjam

COPYRIGHT

Excel_comp_Team_108