Forum Discussion
formulla
Hello, Ismail from Iran. First, I want to emphasize what my friend HansVogelaar has said: all of us here are volunteers who happen to enjoy working with Excel as well as enjoying helping people like you learn how to use it.
In that connection, it seems to me that you are tackling a VERY BIG project here as a beginner with Excel. There are many things still to be learned...do you have access to any books about Excel and its applications in business? That could be very helpful for you in a task such as this. As just one example, the way you describe your current approach raises questions in my mind. It might, for example, make sense NOT to have 500 sheets, one for each of the gardeners from whom you buy product each year, and that is especially true if you only repeatedly buy one or two products (very few) from any one gardener. You might well be better served with a single data table that included all of them and your ordering history on one sheet.
It's hard to be certain about that, but it's a common design error on the part of beginners to design a spreadsheet as if they were working with paper ledger sheets. On paper, it's clearer to the human mind, more manageable, to have separate sheets for each client. But doing that with a spreadsheet design interferes with the computer's ability to manage big databases.
For example, if you have access to Amazon (or some other book seller) you might benefit from this book.
Is it possible for you to post images of what your sheets look like?
- Hello dear father. You mentioned a very interesting point that was very interesting to me. In 20 to 30 days, dates will be harvested in the south of Iran, which we often export to Pakistan with trailers. During the season, we have about 150 gardeners who produce Zahedi, Shahani, or Khasovi dates (a very high-quality and delicious type of date at a base price of 1 US dollar) and... ..they sell themselves to us as a whole, that every gardener needs a sheet to deliver the invoice, and partial purchases are collected in one sheet. Export and other items also need about 50 sheets, which becomes 200 sheets, and after the date product, we directly enter the citrus market, which includes oranges, tangerines, sweet lemons, stone lemons, and other products. Do I need this number of numbers? or not
- Hello again, one thing to remind you. I live in Iran and living in Iran, like driving the first series of Chevrolet, requires special skills. Because I have to bear the losses of a lawsuit that has no end. For my purchase, access to I don't have international banks, and there are three ways. First, if I put a restriction on it, it means that I will give up due to the inability to pay due to the embargo, which is the worst possible situation because I need it very much. Second, it will be sent to my address for free. sent that this is a high expectation and if it is sent, it will reach you. And thirdly, if it is other than these two things, if you offer it, I will gladly accept it.
