You are browsing as a guest. Sign up (or log in) to start making projects!

andrei

@andrei

Joined June 1st, 2026

  • 43Devlogs
  • 5Projects
  • 1Ships
  • 0Votes
hello
Ship

i made an automated .csv bill of materials generator and .md table converter for github repos because i am mainly a hardware project builder and making bills of materials for my github repos took way too much time and hassle for what it’s worth.
my main problems with creating bills were that

  • there were too many things to keep track of manually at once
  • costs had to be manually calculated
  • parts weren’t categorised properly
  • a lot of the time there were additional things i had to express, but couldn’t do so.
  • i had to go through all that effort only to manually convert the .csv bill into .md compatible text to show in my readmes.
    so, to fix each of these issues i did the following:
  • automatically designated part numbers so the user doesn’t need to keep track of which part they last entered.
  • calculated the unit cost of parts using the total cost and quantity of parts needed.
  • used some standardized part number designators (PCB-XXX, 3DP-XXX etc.) but also allowed any custom 3 letter designator to be used for specific, niche parts.
  • created an algorithm that loops through each of the rows of the .csv bom that is created and generates a markdown table with the exact same information with nothing lost which can be easily copy and pasted into a github repo.
  • added a notes section, specifically for manufacturing notes or notes about pricing.
Try project → See source code →
Open comments for this post

1h 41m 35s logged

and the backend is completely finished!
i first replaced the amend option with just an exit program because i assume if amending needs to happen, the user can manually faster do it in a spreadsheet program.
then pretty much the rest of the time was spent doing the markdown conversion and it sucked going through iteration by iteration but i managed in the end to get it to an acceptable state wherein the table is easy to paste into any github repo and works without any issue!

0
0
20
Open comments for this post

23m 36s logged

just a quick devlog cause i added validations for each of the queries so things arent left blank or whatever.
just imagine loads of these sprinkled into the rest of the code.

0
0
12
Open comments for this post

1h 5m 4s logged

an hour of spaghetti code later and it works!!
i started by pre adding all the my columns from the bills of materials from other projects i’ve made.
then i made inputs for every single column type except item no. and unit cost because they can be automated with tracked variables.
finally, a bit of code to write them into the .csv file and voila, it shows up perfectly in excel!

0
0
7
Open comments for this post

44m 36s logged

alrighty so i’ve laid out a bit of a system in my head - would probably be better to actually flowchart it but im not bothered with all that lol.
currently i have just finished the main menu and have began the actual file creation system through pythons built-in open() function.
also imported datetime because i want the file to have the date of creation on it :)
for the actual file creation, the user types in the project name, then i ask the user to add the file path of where to put the boms, then put it all in a while loop so if paths r invalid it’ll just loop.
and finally the file actually gets created at the path with the name format ‘projectname-bom-dd-mm-yy.csv’.

nextly, i will pre-add all the columns that i use for the boms and allow the user to actually add items to the bom.

0
0
4
Open comments for this post

41m 46s logged

and so the design process comes to an end!
the readme has been finished and i’m very proud of how it looks - see for yourself in the images :)
now to submit the design for funding!!

0
0
7
Open comments for this post

40m 26s logged

renderring complete!
i made 5 renders in blender and i’m really happy with the results, which you can see in the images below.

all thats left is finishing off the repo, then i can ship it!!!

0
0
5
Open comments for this post

38m 11s logged

and that’s the base firmware complete!
i made sure all the gpio pins matched their assignment in qmk with the xiao documentation, and now have a (hopefully) functional piece of firmware to test the board with.

the firmware also includes encoder functionality and a basic rgb lighting pattern for the leds - although i will be further testing it once i actually physically build it!

the firmware does NOT include via functionality OR oled functionality YET - and i will be uploading both the non-oled firmware and the oled + via firmware to the repo when i get around to committing all the files to it.

for now - all that’s left is rendering and repo polishing!!

0
0
5
Open comments for this post

2h 2m 12s logged

so, pcb art am i right?
i finished off my silkscreen art and im honestly so happy with it and all the little references that i put in :)

also a little aesthetic choice that i tweaked because it’ll end up looking cooler than before - the solder mask and case are now going to be white with the art showing in a black silkscreen (like ulquiorra’s skin in bleach)

next up is making the firmware, which shouldn’t take all that long, rendering the model in blender and updating the repo with all production files and the finalised readme!

0
0
8
Open comments for this post

30m 7s logged

the readme is like 70% of the way there already! (all the blank parts are placeholders for art and images :upside-down: )
i really like the designs of some of my other readmes, especially peroxide and pentoxide
(wasted a really cool idea on pentoxide and im still fuming)
so i copied most of the formatting from them and then once i get some batteries for my pen - ill make some art for the readme and the pcb!
next on the agenda is obviously art, but also renders, qmk firmware writing AND making it via compatible are the next courses of action!

0
0
2
Open comments for this post

1h 53m 8s logged

downloaded the pcb’s step files and imported into onshape! designed a really low profile case - because i want the bare pcb kinda aesthetic - so its literally an angled plate with standoffs for heat set inserts.

spent a lot of time tweaking and tinkering with the case and also made some really quick of art to engrave in the case and encoder knobs :)

finally downloaded all the 3d models of the parts i will use, then assembled them using mates in my main assembly.

hackpad’s pretty much fully finished, so the next couple of devlogs will be dedicated to making art, a proper github page and firmware using qmk!

0
0
3
Open comments for this post

59m 36s logged

i came up with a design that i wanted to use before i began the project thats based off of bleach - so i began with that in mind.

i then looked at the hackpad website for all approved parts in the hackpad kit and placed in all of the components that i wanted in my schematic.

the schematic was easy enough to create as the pinouts for all the components are either widely available or on the hackpad website :)

after that, placed all the things i wanted down in the pcb editor roughly where i wanted to, tweaked a bit, routed traces and voila - bare pcb before i add any art to it!

0
0
13
Open comments for this post

16m 26s logged

lost like an hour of time because idk how to use lookout lmao but its fine because i have finished writing the instructions to build the product and have also uploaded all the parts to thingiverse BUT have to wait 24hrs to publish to the public - so when that is done i will finally submit to get funding! in the meantime, might make some visual lego-like instructions to make it easier to visualise the assembly!

0
0
5
Open comments for this post

1h 17m 37s logged

im back from exams and the full shifter is finished!
added the limit switches and slots for each of them to be glued down when i build it.
the pcb has also arrived, now all i need is to buy the components (hopefully can get them hardware funded) and 3d print the rest of the components (hopefully can get that funded too cause i dont have a printer)

0
0
4
Open comments for this post

56m 1s logged

exported a 3d model of the pcb from kicad and added it into the cad model with mounting hardware and mounting holes. also created a shift knob that has an m10 internal thread so it can be screwed on to the threaded rod.
will be slowing down a lot over the next week and a bit because i have a full week of exams - but will come back with more updates than ever afterwards!

0
0
6
Open comments for this post

51m 24s logged

main pcb designed and routed using an atmega32u4 and through-hole slots to wire each momentary switch to the board individually :)
if anyone sees mistakes in my pcb - it would be greatly appreciated to point them out for me as it is my first time making one!

update: the pcb has been ordered!

0
0
23
Loading more…

Followers

Loading…