Excel file optimisation

I did put the copyright sign there, but it's merely for fun, and, of course, if any of you find this type of file useful, I will be happy if you use it for your purposes. And also, I used lots of templates I found on the web to come up with this result.

I hope you see the irony in what you are saying, even if the copyright symbol is 'for fun'. I'm really glad that you'll be happy for us to use the things that we have helped you to create - that's very generous of you.

In terms of file optimisation, the excessive use of conditional formatting will make the file large and slow it down, so you need to cut back on that. Most of the 'interesting features' are what I would call 'unnecessary bells and whistles' and add nothing at all to the workings of the spreadsheet, as far as I can see. I do not really understand the purpose of the spreadsheet - much of it is in a language I don't speak (Russian?), and there are no instructions about how it is meant to be used or what it is supposed to do.

I do not understand your second point at all about things changing on a whim, unless you are constantly changing the format of the file between a Google Sheet and an Excel file - perhaps you could elaborate on this?

All in all, this is an apprentice piece, and it has been useful to you as a learning tool. However, it is overly complex, and bespoke to whatever it is you want it to do, so really cannot be seen as a template that could be adapted easily for someone else's purposes.

I hope this critique is useful to you.

Mixed russian/english
removed all not neccessary formats - 270 kb

edit: Times New Roman changed to Calibri , font size: 9 (I hate TNR)
freezing - removed
orientation - removed
merged cells - removed
two blank sheets (hidden also) - removed
Instruction "How to use it" - required

that's all ( I hope )

Originally Posted by AliGW

I hope you see the irony in what you are saying, even if the copyright symbol is 'for fun'. I'm really glad that you'll be happy for us to use the things that we have helped you to create - that's very generous of you.

I would truly advice you to take things in a more light hearted fashion. ) Yes, of course, people here helped me a lot with my understanding of formulas, and I did stated many times how grateful I am, and this is also why I shared the result, though, of course, far from everything I did there comes from the help I got here.

Originally Posted by Vitalite

I would truly advice you to take things in a more light hearted fashion. ) Yes, of course, people here helped me a lot with my understanding of formulas, and I did stated many times how grateful I am, and this is also why I shared the result, though, of course, far from everything I did there comes from the help I got here.

Who is not taking things in a light-hearted fashion? Did you not see the wink emoticon???

I see you are still cluttering threads with unnecessarily long quotations, which is ironic since the only thing you have responded to in my thread is the opening paragraph!

Have you read the other feedback I gave?

@1 No, you can use languages as many as you want but create dictionary for used languages and choice for users between them
@2 All backgrounds and some conditional foramtting. All borders - default,
@3 TNR was imposed by MS long time ago as default in Word. In Excel it was Ariel (If I remember well) - but it should be my choice which kind of font is used, isn't it?
@4 no problem, I asked for instruction because I don't know what I can do with this file
@Tables (structured or range?) Structured tables will increase file size. But this is your choice.

edit:
there is many DataValidation with many blank rows (look for DynamicDataValidation List on this forum)

dvwithblankrows.jpg

3) Why do you hate TNR? ) What's so bad about it?

It's a pretty well-known fact that serif fonts read better on hard copy prints (letters, etc.) and sans serif fonts read better on screen. I always use Calibri, which is a pleasant font on screen and not as hard on the eyes as Arial.

Thank you very much. I will switch to Calibri now, hopeful this will ease the great pressure on eyes, especially after 16 hours at the computer.

You're welcome!

Do you have any questions or can I delete the file?

no answer: file deleted

You want me to keep your file 4 days????
I can re-download file from your first post but without my correction of course.

If you correct something in your file then the first file will be outdated. If so attach a new updated file

Sandy - please do not delete solutions provided in workbook format. They need to stay here for future reference (not just for the OP, but others using this thread for help in the future) and are part and parcel of the thread. The only time we remove attachments is if someone has accidentally posted sensitive information. Please put the attachment back. Thanks.

Understood. Thanks.

There's a tiny blue link ("File") in your opening thread to a Google Drive document - you posted it there, I think, because it was too huge to post here.

your file is on Google Drive (yet, until you remove it) with link in the first post.

and I repeat: I didn't attach any file to this thread.