OpenOffice Calc Coder

[theibel]

I am looking to pay someone to help me with some OpenOffice formulas for several spreadsheets. One is ready to go right now, but more will follow. I normally hire through the Upwork community, and the ideal candidate would be a member of Upwork. However, I'm willing to work with anyone on theses various projects.

While I write some formulas myself, I don't always have the time to research new formulas, and that's where you come in. It's easier for me to pay someone else while I work on other projects.

Please see the attached spreadsheet and look at the "Print" tab to see what needs to be done.

Please contact me through this forum with your price if you can do this.

Attached is the actual spreadsheet you'll be working with for this project.

Thank you!
Tom Heibel

[RusselB]

While I don't have the knowledge to complete what you are asking for, a bit of free advice regarding your formulas for sheet Rebates in columns R, S & T.
The SUM function used in column R can be modified to

Code: Select all

=SUM($H5:$Q5)

making Calc use the range, rather than the individual cells.
This is the most efficient use of the SUM function.
Additionally using the SUM function in S & T, where you are actually performing a subtraction is not as efficient as just using the basic subtraction.
ie: Use

Code: Select all

=$g5-$h5

rather than

Code: Select all

=sum($g5-$h5)

The differences are minimal and for processing time, realistically, unnoticeable, but they are measurable.
If you're going to use the functions, you might as well use them in the most efficient method available.

[theibel]

@RusselB I like the way you think. Your mods are in.

[theibel]

Is there any way to print only non-empty fields using some type of MATCH or VLOOKUP? I'm still trying to find an answer to this spreadsheet formula. For example, how can I display an entire row from a formula search into the new worksheet in my file above? At least this way, I can simply print this worksheet in a mail merge with a Text document.