Fiat Coupe Forum
- Founded by Kayjey & James Northam
- Funded by the Club for the benefit of all owners
Fiat Coupe Club UK
join the club
Fiat Coupe Forum
 
» Announced
    Posting images


» Related sites
    Main club site
    fiatcoupe.net


» External data
    owners listed
 
Who's Online Now
0 registered members (), 151 guests, and 0 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums68
Topics110,922
Posts1,315,440
Members2,216
Most Online731
Jan 14th, 2020
Top Posters(All Time)
barnacle 32,449
stan 32,098
Theresa 22,989
bockers 21,027
PeteP 19,819
JimO 17,914
Nigel 17,234
Jim_Clennell 16,392
RSS Feeds
Club Events
Club Information
Track Events
Rolling Road/RWYB
Social Events
Non-UK Events
Coupé Related Chat
Coupé Spotting
Coupé News/Press
Buying/Selling Advice
Insuring a Coupé
Basic FAQ's
How to Guides
Forum Issues
Technical Problems
General Maintenance
Styling
Tuning
Handling
ICE and Alarm
Coupés for Sale
Coupés Wanted
Parts for Sale
Parts Wanted
Group Buys
Business Forum
Other Vehicles for Sale/Wanted
Other Items for Sale/Wanted
Haggling/Offers
Ebay links
Other Cars
Other Websites
General Chat
Previous Thread
Next Thread
Print Thread
Experienced Spreadsheet Person Needed #1637815
27/12/2019 00:51
27/12/2019 00:51
Joined: Jun 2006
Posts: 22,989
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,989
North Wales
Hi all smile

I've always hand written my timesheet out for work, but now I've changed departments, I have more varied hours, with varied overtime, etc and somebody in work said it was easier and neater to fill in the timesheet electronically, which it is, but there's a couple of things annoying me that I don't know how to change.

They have sent me the template, but there's a couple of columns the wrong way around compared to the original/standard timesheet and my printer is cutting off some of the left hand side, etc. Also, when I type in December 2019, it keeps changing it to 01/12/19, which is annoying.

I've had a mess around, but don't really know what I'm doing, so I was wondering if someone could sort it for me so I can just type in my details and worked hours and print it off each month

Not sure if it makes a difference, but Microsoft Office doesn't work on my laptop so I use Open Office.

Thanks.

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637816
27/12/2019 09:27
27/12/2019 09:27
Joined: Sep 2009
Posts: 4,674
ation
szkom Offline
Forum is my job
szkom  Offline
Forum is my job

Joined: Sep 2009
Posts: 4,674
ation
Some easy fixes, hopefully smile

Select all the cells that have the wrong date formate in. Right click and select '"Format" from the list. Go to the numbers tab and select date in the category box. You can now choose the preferred format. Click okay when finished.

Fixing the columns is just as easy. Click on the column letter to the right of where you want the misplaced column to go (ie, if you want it between B an C click on C), right click and select insert columns. Click on the letter of the column you want to move (it should all highlight in blue), right click and select cut. Click back on the letter of the column you created and right click. Select paste.

Getting the print area set correctly should also be straightforward. However it's a while since I used OpenOffice so remembering where the correct options are. If you select all the cells you want to print, then go to the format tab and select page ranges, then select define from that list. Once you've done that you can go back to the format tab and select page from the menu. You'll be able to adjust for portrait/landscape, size, etc.

I'd save the file as a different name to allow you test what you've done is correct. Click file on the header and select Save as to do this and type your file name into the dialog box. The only problem you'll find is that you'll have to use an old excel file format to save the document. Generally this causes no problems unless you're sharing the document for edit with other people who use excel and the document has lots of formula and formating in it.

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637817
27/12/2019 09:59
27/12/2019 09:59
Joined: Dec 2005
Posts: 17,234
Staffordshire
Nigel Offline
Club Member 123
Nigel  Offline
Club Member 123
Forum veteran

Joined: Dec 2005
Posts: 17,234
Staffordshire
Hi T

If it’s easier, send me a copy of the spreadsheet and I’ll fix it for you, but it won’t be for a few days


[Linked Image]
Re: Experienced Spreadsheet Person Needed [Re: Nigel] #1637819
27/12/2019 10:58
27/12/2019 10:58
Joined: Jun 2006
Posts: 22,989
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,989
North Wales
Thanks szkom. I managed to change the date format by following your instructions. I tried the columns, but nothing is happening when I right click on the column letter and when I tried a couple of other things, it says the cells are protected and can't be changed.
I'll wait until those are sorted and then play with the print options.

In the meantime, I've emailed you the file I was sent Nigel. I just need the date and day columns on the left side to be swapped around please.

If it can't be done, it's not massively important as the person who sent me the file obviously fills in their timesheet as it is and it gets accepted, but ideally, to stay in line with everyone else, the date and day should be swapped.

Thanks smile

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637820
27/12/2019 11:18
27/12/2019 11:18
Joined: Mar 2007
Posts: 11,652
Auld Reekie
Edinburgh Offline
Club Board member
Edinburgh  Offline
Club Board member
I AM a Coop

Joined: Mar 2007
Posts: 11,652
Auld Reekie
I sympathise T, have to fill in more and more complicated pay claims at uni, it's a pain in the backside. First they "expire" any password you might have, then they change the system - and terminology - and the latest was when instructed to click on Internet Explorer there was suddenly no such thing in existence....I had to ask a passing student to show me the ropes!

I seem to remember in some of the old formats that there were "protected" areas and oddities like when filling in signature and date they couldn't be entered in boxes next to "date" and "signature".

In forty-odd years of filling in pay claims it's actually got harder and takes longer rolleyes laugh


Thanks again, Photobucket.
BumbleBee under restoration, emerging from lockdown smile
Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637913
04/01/2020 00:00
04/01/2020 00:00
Joined: Jun 2006
Posts: 22,989
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,989
North Wales
Nigel has very kindly helped me out with this - thank you Nigel smile

Thanks also szkom smile

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637920
04/01/2020 08:33
04/01/2020 08:33
Joined: Dec 2005
Posts: 17,234
Staffordshire
Nigel Offline
Club Member 123
Nigel  Offline
Club Member 123
Forum veteran

Joined: Dec 2005
Posts: 17,234
Staffordshire
No problem - the worksheet was password protected, so I had to use a password breaker to allow the swapping of the columns.

Microsoft spent a fortune adding a special new type of protection when they rolled out Office 2010 - it now takes at least 30 seconds to open a password-protected sheet, rather than the ten seconds it used to take..... rolleyes


[Linked Image]

Powered by UBB.threads™ PHP Forum Software 7.7.1
(Release build 20190129)
PHP: 7.3.20 Page Time: 0.021s Queries: 14 (0.011s) Memory: 0.7722 MB (Peak: 0.8601 MB) Data Comp: Off Server Time: 2020-08-10 02:00:31 UTC