How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 16842
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I want to use Google spreadsheets for keeping records of Gold

Customer Question

I want to use Google spreadsheets for keeping records of Gold i give and take from companies.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is Richard.

To clarify, you would like to know how to set up an account to use Google Spreadsheets?

Or are you having a particular issue doing this?

Thank you
Customer: replied 1 year ago.

no i have set up it already


i want to know how to setup all the things for keeping record.

Expert:  Richard replied 1 year ago.
ok, well it saves online to your Google Account Automatically as you use it.

You create a speadsheet (which you can do here)

https://drive.google.com/?pli=1#my-drive

You add the names of the companies, in the first Column and the details for this trade in the second column. It will then save this to your drive.

Is this what you need, to achieve this?
Customer: replied 1 year ago.

I know how to create a spreadsheet but i want to know the followings.


I'm a gold shop owner and individual workers and companies come to me to give gold jewelry and i give them gold so i want to keep record of all that now i want to know that how to setup all the things that at the end of the month if i want to check the how much gold i took from all those and have given them or how much is left to be given.i want to keep record of making charges i payed to them.

Expert:  Richard replied 1 year ago.
Thanks.

I can do an example, but either need access to your Google Sreadsheet, or I can do the example for you in Excel.

Let me know which please.

Customer: replied 1 year ago.

Can you do it in Apple's Number software.

Expert:  Richard replied 1 year ago.
No sorry it can't be done in that

do you have Excel installed?

If not, I can give you the trial version

Customer: replied 1 year ago.

Ok can you do it google spreadsheet.

Expert:  Richard replied 1 year ago.
yes, can you give me the link to your spreadsheet please.

Customer: replied 1 year ago.

OK can you do it in excel and send me the file i have excel installed.

Expert:  Richard replied 1 year ago.
Thanks, XXXXX XXXXX done

Go to www.wikisend.com

Click Download and use file ID 514578 to download it

One sheet has the Gold Bought by you

The other sheet has the Gold Sold by you

The third sheet provides the overview for all of this.

Review it and let me know please if you need anything changed.

Thank you
Customer: replied 1 year ago.

It's not buying or selling to or from customers it's from suppliers.


 


I want to keep record of suppliers.


 


For example



There is a company who supply me jewelry



1:Golden Crow




Golden crown company comes to my shop and show me the jewelry and I take some of it on credit.



Assume that I took 200 Grams of jewelry from them and for that jewelry they take 200$ making charges but i pay them 100$ making charges and say that payment of gold and and rest of the making charges I will give them next week or later.




Now after 2 days I give them 100 grams of gold


Now if I want I want to check that how much making I have to pay and how much gold I have to give how I will check.


 

Expert:  Richard replied 1 year ago.
ok, to be clear

you want to know at anytime, how much money and Gold you still owe them?

As you only pay a part of the price correct?
Customer: replied 1 year ago.

yes!

Expert:  Richard replied 1 year ago.
ok, like this?

wwww.wikisend.com

File ID 391388

Let me know please

Customer: replied 1 year ago.

Can we chat somewhere.

Expert:  Richard replied 1 year ago.
We cant sorry, only here.

But tell me what you did not like with the spreadsheet please

Customer: replied 1 year ago.

ok i want a different spread sheet for each company and i want to keep all the records at one place i mean like i should keep adding and when i want to print i should only get the amount i owe.

Customer: replied 1 year ago.

I take jewelry from many companies and i want to keep all the records in different spread sheets and amount i owe of all the companies should appear on a another spreadsheet.

Expert:  Richard replied 1 year ago.
ok, right click on the sheet, select copy and you can make a copy for a new company.

Is this what you want?

Let me know and I work on the printing requirement.

Customer: replied 1 year ago.

Customer: replied 1 year ago.

I meant that amount and gold still owing of all the companies should appear on an another single spreadsheet with their names.

Expert:  Richard replied 1 year ago.
ok, but I cannot do the third requirement until you have made all the spreadsheets for the other companies.

But is this what you want?

Go to www.wikisend.com

File ID 446146

But if you tell me all compaines, I can make the other sheets.

Customer: replied 1 year ago.

i will add all the companies and then can u complete my third required.

Expert:  Richard replied 1 year ago.
Thank you

Let me know when they are ready please.

Customer: replied 1 year ago.

Here is the name of All companies


 


Al-Rimal Fanja trading


Golden Crown


Arabian Jewellers


Al-mowaiji jewellers


Zahid Imran


Nadeem (Bangles)


Nadeem(Seeb)


Abdul Salam

Expert:  Richard replied 1 year ago.
ok, doing this now
Expert:  Richard replied 1 year ago.
Please go to www.wikisend.com

And download File ID 186706

Let me know if this is what you want please

Customer: replied 1 year ago.

This isn't what i want....Frown

Expert:  Richard replied 1 year ago.
Can you eloborate, as I did what you last asked
Customer: replied 1 year ago.

Change customer section into items i bought,Can You merge the bought and paid into one spreadsheet of each company and in overview i should i see the whole amount i bought from beginning to the last date and how much gold and amount i still own in overview i should also see the last date i bought gold and last date i paid….


There should be a gold purity section in each company spreadsheet so i can keep record of which purity of gold i paid.




This should be the sequence for gold bought



Date----Items-----gold purity-----Gold bought-------Making



This should be the sequence for gold Paid



Date------type------gold purity-------Gold Paid----making paid




This should be for the overview



Company name----Last date gold bought-------last date gold paid-------gold bought ever-----Making paid from begging to the the last date ------Gold to be paid-----Amount to be paid




Rest of the changes i will tell after.

Expert:  Richard replied 1 year ago.
ok, this is a lot more then initially requested, therefore I have requested a price increase.

Customer: replied 1 year ago.

I have increased the price,now please help me.

Expert:  Richard replied 1 year ago.
Thanks

Now please tell me the rest of the changes now, as this is important to know upfront.

thank you

Customer: replied 1 year ago.

Change customer section into items i bought,Can You merge the bought and paid into one spreadsheet of each company and in overview i should i see the whole amount i bought from beginning to the last date and how much gold and amount i still own in overview i should also see the last date i bought gold and last date i paid….


 


There should be a gold purity section in each company spreadsheet so i can keep record of which purity of gold i paid.


 



 



 


This should be the sequence for gold bought


 



 


Date----Items-----gold purity-----Gold bought-------Making


 



 


This should be the sequence for gold Paid


 



 


Date------type------gold purity-------Gold Paid----making paid


 



 



 


This should be for the overview


 



 


Company name----Last date gold bought-------last date gold paid-------gold bought ever-----Making paid from begging to the the last date ------Gold to be paid-----Amount to be paid


 



 



 


Rest of the changes i will tell after.

Expert:  Richard replied 1 year ago.
ok, looking now

Expert:  Richard replied 1 year ago.
Its not finished, but I want to make sure we are on the right Track

Go to www.wikisend.com

file ID is 153180

Is this how you want it?

Nothing works yet, I want to make sure this is how you want the sheets organised first.

Customer: replied 1 year ago.

Yes we are on right track.

Expert:  Richard replied 1 year ago.
Thanks, will continue on it

Expert:  Richard replied 1 year ago.
This is now done based on what you told me you wanted.

You can download it from www.wikisend.com

Under File ID #420722

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Customer: replied 1 year ago.

Please add category to put receipt number....

Expert:  Richard replied 1 year ago.
No problem

I have done this and you can download it from www.wikisend.com

File ID 483956

Customer: replied 1 year ago.

It's not showing the correct last date gold bought in overview.

Expert:  Richard replied 1 year ago.
Can you upload with your data in the sheet please.

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 1 year ago.

419388

Customer: replied 1 year ago.

419388 and remove nadeem (bangles) from everywhere

Expert:  Richard replied 1 year ago.
This is now all fixed and you can download it under File ID 873872

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions