Turbo's PCBS Invoice Program

[Turbo]

I made an invoice program in Google Sheets so no pesky .exe files to worry about! Use it to your heart's content. If you run into any bugs with it, please post them here.

https://steamcommunity.com/sharedfiles/filedetails/?id=1593824512

[Turbo]

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 check 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.

[Turbo]

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

• 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.

[BonPadre]

Hi there
First PLEASE I want to make clear I'm not trolling nor agressing the work you do, because I'm pretty sure that what I'll ask may be misunderstood with a tone that sounds like that, so for real I'm asking a true question for my personal understanding. And I would love a serious answer.

Am I missing something on the gameplay that is important for the game's result ? or is this tool only for personal "compulsive records of useless numbers" ? (I told you it will sound agressive, but I truely have no idea on how to word it differently, with a more subtle tone and wording, as I'm not an english native speaker)

I mean, what is the purpose ? It's a lot of work from your side (but I know you do it for you mainly and share it) and it's a lot of work to fill them (or am I missing an automatic filling tool linked with game)
Is it only for immersion ? Or there is a real in game use ?

I mean, usually when you do things, it's because it's important, so if you do it... I have a felling I'm missing something important in game (actual or maybe to come in the future iterations ?)
And me looking at it, and asking myself why I should use it is making me more convinced I may be at the wrong side of the stick lol

Thanks anyway as usual for your job, keep the good stuff going, and as we are almost there, happy holidays moments to you, your family and beloved ones.

[Turbo]

What you said about me making it for me and sharing it is really what it comes down to more than anything else, though I will say that there would be far fewer gripes about budget issues if everyone used something like this. It makes even what seem to be nigh impossible jobs much easier. Using this thing is the biggest reason why I've been able to only reject a handful of jobs out of the hundreds I've done.

Ive also worked towards making it as easy to use as possible. The plan is to also incorporate an invoice history and OC database that can be used to search past jobs to reference for future jobs.

Considering the convo we had on selling PCs on PCBay, you might be most interested in what I'll probably be working on right after Christmas: a tab that will essentially work as a PCBay build tracker to keep track of all your expenses on PCs bought and sold on PCBay.

The eventually goal for this is to become a general multi-purpose tool that can be used in all aspects of the game. For example, the table that I've already incorporated that lists what fans and radiators can be used in what case. I'd also like to incorporate a benchmark calc eventually, but I'll need to figure out a way to speed up the calculations before I do that.

A very merry Christmas to you as well bud and I hope I answered your questions.

[BonPadre]

Thanks for your time and answer, and yes indeed, besides keeping track of those PCBay PC's I'm fairly certain I don't have the patience to fill up an invoice like that.

I don't know if I waste more time doing it my way, with a calculator for some less obvious jobs, and on simple ones I don't need much, and on full builds I rely on instinct and "raw" guesstimates for the gran total lol (always been bad at math and keeping my stuff clean, always have been pretty decent at guesstimate results in a fairly close range)

Will definitely check back for the used PC things then

[SwitchLove]

Hey there! I wanted to thank you for making this awesome invoice spreadsheet!

Two things though, first can we get a primary object for Hit X 3DMark score?

Second is I get an error when trying to use the End of Day reset button, sheets gets the following error:

Those rows are out of bounds. at showRows7_400(macros:98) at invoiceReset(macros:103)

Seems to be an issue with the show all rows function:

function showRows7_400()
{
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getActiveSheet().showRows(7, 400); <-- Line at fault
};

Though I'm not sure why it thinks that rows 7-400 arent valid, all those rows exist...

[Merck]

I want to thank you also.
I have always thought it would be good to have a basic invoice/worksheet tagged to each computer, so that you could keep track of what the buyers desires & wants for the specific job. Then you could have an easy to review sheet for each computer, that you could tag all notes about the machine, & any 'special' items (such as cables, or specific brands, etc..). Also would be nice to have a set of boxes for such things as the customer wants a 3DMark benchmark on the machine, or only new parts.

Another thing that I think would be great for the developers to impliment, would be a system of "boxes/tubs" for each job. Then all parts for that specific computer would be placed in the tub & follow that computer. No more mixing unlabled parts (although maybe adding a "labeling" system for parts might be easier??? But with the tubs, then everything from the specific computer would stay 'tagged' to that computer. And when finished with the job, you could then clear out the tub of extra parts - selling or storing anything left over.

But again, thanks for your work on this spreedsheat, it is definately a step in the right direction.

[Turbo]

Originally posted by SwitchLove:

I get an error when trying to use the End of Day reset button

Thanks for letting me know. I'll take a look at it later today and get this fixed.

For the 3DMark objective, I can add that to the list easily enough, but I'd probably keep the current score cell in place as it is.


@Merck, I hear ya. I've been asking for the ability to add custom notes to parts for months. It's all up to the devs to add features to the game at the end of the day though.

[Turbo]

Sorry I didn't get this done sooner, but the issue is fixed now.

[SwitchLove]

Thanks for the update! The Work Day Complete is resetting the invoices correctly now. However I am now seeing that when you mark a day as complete that the downwards arrow image under the 3DMark Results >> % Increase is now being hidden when the sheet collapses the day. See the following two images for what I am seeing.

https://imgur.com/a/nsl6kYp

[Turbo]

Well that's bizarre. I had to change out the images because the link for the old one broke. I'll have to try something different I guess.

[Turbo]

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.