Turbo's PCBS Invoice

Hey all! I've been working on this for a bit and finally got it to a point that I feel it can be shared with everyone else. This invoice sheet will help you keep track of all those pesky parts for jobs in Career Mode.

At the moment, it's still a bit rudimentary, and as such, you'll have to reload a fresh worksheet after every five jobs, but I'm working on further features that will hopefully include an invoice reset button and invoice history tab as well as a few other goodies that I'd like to try.

To use this, click the link and once it loads, click 'File -> Make a Copy' to save it to your own Google Sheets. Enjoy and I hope it helps!

UPDATE: Feb. 1, 2019 @ 15:17 CST

• Added all new parts that came with PCBS v1.0.
  
• Added new 'Will it Run' programs that came with PCBS v1.0.

UPDATE: Jan. 1, 2019 @ 14:10 CST

• Added missing Pentium CPUs and MSI 370 GPUs.
  
• Fixed data validation error bug.

UPDATE: Dec. 28, 2018 @ 15:00 CST

• Fixed concat table bug.

UPDATE: Dec. 22, 2018 @ 18:09 CST

• Added an additional five blank invoices in case you have left over missions from the day before.
  
• Added a capacity column for the 'Upgrade RAM' and 'Upgrade Storage' objectives.
  
• Added the functionality to automatically unhighlight the requested 3DMark score when a score that matches or beats it is input in the 'Combined Score' fields under '3DMark Results'.
  
• Corrected several conditional formatting and validation list bugs.

UPDATE: Dec. 19, 2018 @ 15:17 CST

• Added 'Reset' button to reset the invoice back to default values.
  
• Added 'Job Complete' button to allow the hiding of invoice part rows when you're finished with a job.
  
• Added a support list that shows what fans and radiators can be used in what cases. I only checked this with AIOs though, so no guarantee that CWC radiators will be the same.

One note on the new buttons: there is currently no way to lock them in place, so if you right click on them, you will end up moving them.

Here's the link: Turbo's PCBS Invoice v2.3.8[docs.google.com]

[Alexis Bloodwood]

I cant seem to use the Job Complete button, Google wont let me verify the maco thing :( help?

[Madforce2k]

I wish the part list would pull in the price. So it can auto calculate.

@towalton1 You already can upgrade it, if you make a copy. The you can unhide sheets and edit as desired

[towalton1]

Would you mind making this upgradable? unhide sheets, etc? Great job order sheet, just no way to keep it up to date.

[Hazama]

There's a Replace Air Cooler objective that isn't available in the primary objective dropdowns.

[PBH｜ABZ]

God I wish this was updated, I can't live without this tool! Genuinely wish this was a tool included in the game.

[korazer]

Thanks a lot for making this

[bee-rye]

First off, thanks a ton for this awesome tool, it works amazingly!

Second:
I added a script to your existing code that you might find useful.
When the user selects "Build" as the Job Type, it automatically populates the first column of the Parts List with everything piece they'd need for the build. This auto-population is more or less in order of assembly/importance during component selection.

If you want to add my script to your sheet, send me a PM and I'll get you the code.

Thanks again for your awesome work!

[Quickhakker]

your missing number of rads

[Omegabigb]

@Zdeněk Slabý you could add the parts yourself, that's what I did, though be warned it will probalby cause some problems (if like me you have no experience in Google Drive)

[Turbo]

I'll be updating it when I can. At the moment, life is getting in the way of things so it could be a couple weeks before I can finally find time to get around to this.