Skip to content

xls-remaker is a command-line tool that simplifies the process of cleaning up and reformatting large sets of Excel data, particularly data generated by complex laboratory machines like X-ray fluorescence spectrometers or chromatographs. This powerful tool is user-friendly and saves time and resources for data analysts, researchers, and developers.

Notifications You must be signed in to change notification settings

deadpahn/xls-remaker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xls-remaker

Alt text

Summary

This software tool has been developed specifically to sort data for the Rigaku X-ray fluorescence spectrometer. Often, the spreadsheets generated by QuantEZ can be poorly formatted and difficult to work with. Our tool addresses this problem by extracting the relevant data and reformatting it in a more user-friendly manner. It is important to note that this tool is provided on an "as-is" basis, without any warranty or guarantee of performance. Additionally, please be advised that we are not affiliated with Rigaku or any other company.

Before you start

You'll need php installed on your PC. Check by running

php -v

or

which php

or

MAC

brew update brew install php

LINUX

I dunno bro you should know lol

HOW TO RUN

  1. put shitty excel files in the "data-to-process" folder

  2. run "process-text.sh"

    • cd /folder/where/you/downloaded/this
    • chmod +x process-text.sh
    • ./process-text.sh
  3. go listen to this with all the time you saved: https://www.youtube.com/watch?v=twBcMibg1Vs

LINKS

https://www.rigaku.com/products/edxrf/quantez

About

xls-remaker is a command-line tool that simplifies the process of cleaning up and reformatting large sets of Excel data, particularly data generated by complex laboratory machines like X-ray fluorescence spectrometers or chromatographs. This powerful tool is user-friendly and saves time and resources for data analysts, researchers, and developers.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published