Forum Home
Press F1
Thread ID: 137017	2014-05-13 08:36:00	Advice creating a Spreadsheet or smilar	Daniel.Drache (10574)	Press F1

Post ID	Timestamp	Content	User
1374884	2014-05-13 08:36:00	I've just graduated from my apprenticeship to a code based contract. Since I have a retainer that I have to exceed, I'm wanting to create a spreadsheet to keep track of the jobs I'm doing. I would like to use Google Docs because it will be easier to access & input since I use 3 computers - my current work Laptop is WinXP, My soon to arrive work Tablet will be Win8 & my Personal Laptop is Win8. I would like to track date, Job ID, Payment Code & Amount for that code. Ideally with a weekly total. I realise I'll need to enter the info manually, But since I have 50+ codes each with a different payment I was hoping I could type the code in & spreadsheet would automatically enter the payment amount. Would I be able to do something like this with Microsoft Spreadsheet? Or is there another program that would work? If I waited until I received my Win8 tablet (Or used my personal one) would it make it easier? A rough idea of what I'm thinking 5721 Thanks for any advise Daniel	Daniel.Drache (10574)
1374885	2014-05-13 09:22:00	Quite easy really. What you can do is for the Job ID and Code use a drop down menu. Filling out the values as required for each task. Found a video that shows you how to do it, just change the values as required. www.youtube.com To insert the date you can use keys, Ctrl + : in the cell you want.	wainuitech (129)
1374886	2014-05-13 20:40:00	Thanks, Ill give the video a watch after work	Daniel.Drache (10574)
1374887	2014-05-14 06:05:00	Job ID's are different every time so i don't need to worry about them Thanks for the video the drop down lists looks really handy. Is there a way to link the Code drop down list & Payment? IE if I select code 392 in column C row 3, $56 appears in Column D row 3 as it shows on the pic	Daniel.Drache (10574)
1374888	2014-05-14 21:03:00	Job ID's are different every time so i don't need to worry about them Thanks for the video the drop down lists looks really handy. Is there a way to link the Code drop down list & Payment? IE if I select code 392 in column C row 3, $56 appears in Column D row 3 as it shows on the pic You should be able to. Personally I'm not to sh1t hot on Excel formulas, someone who has a lot more knowledge will be able to post it. If not, I'll ask my son, hes actually good with Excel, I had one I was trying to do for over a day for my invoicing, he came along, said "really :illogical - move over" within a few seconds had it working. -- Smart $&%^^* :D	wainuitech (129)
1374889	2014-05-15 09:53:00	Ok, no ones answered the problem above ---- I asked My son who loves excel. Told him what you wanted to do -- got the usual look of "seriously" :illogical Opens a spread sheet, filled it out like the video, added in some madeup pricing and codes ( 10 lines ). EG Code 392 =$100 765 = $10 123= $21 etc, thumped out a formula using VLOOK and did exactly what you wanted. Me --> :waughh: :waughh: :confused: Couldn't keep up. So yes it can be done. :thumbs: Trying to write it out and explain so it makes sense -- That's a different matter. He said Theres a lot on the internet explaining vlook and things you can do.	wainuitech (129)
1374890	2014-05-15 20:35:00	Thanks, I'll have a big search around on the net	Daniel.Drache (10574)
1374891	2014-05-16 00:14:00	You should be able to. Personally I'm not to sh1t hot on Excel formulas, someone who has a lot more knowledge will be able to post it. If not, I'll ask my son, hes actually good with Excel, I had one I was trying to do for over a day for my invoicing, he came along, said "really :illogical - move over" within a few seconds had it working. -- Smart $&%^^* :D Young people, they just know everything!	Webdevguy (17166)
1374892	2014-05-16 00:17:00	Ok, no ones answered the problem above ---- I asked My son who loves excel. Told him what you wanted to do -- got the usual look of "seriously" :illogical Opens a spread sheet, filled it out like the video, added in some madeup pricing and codes ( 10 lines ). EG Code 392 =$100 765 = $10 123= $21 etc, thumped out a formula using VLOOK and did exactly what you wanted. Me --> :waughh: :waughh: :confused: Couldn't keep up. So yes it can be done. :thumbs: Trying to write it out and explain so it makes sense -- That's a different matter. He said Theres a lot on the internet explaining vlook and things you can do. Does your son have an interest in doing any other scripting like JavaScript, VB, .Net, PHP etc?	Webdevguy (17166)
1374893	2014-05-16 00:53:00	I was going to suggest lookup tables also. I muddle my way through excel with the help function and can usually get it to do what I want. Turns out all my attempts at BASIC programming about 100 yrs ago wasn't completely wasted either as a lot of Excel formulas and functions are very similar to BASIC. It's an incredibly flexible tool though and can do a lot more than I ever play with.	dugimodo (138)
1 2