Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 11-02-2018, 06:23 AM
p45cal's Avatar
p45cal p45cal is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 10 Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by Marcia View Post
I suggest we maintain the status quo as is the instruction. Although there is plan to make representations before the approving authorities that we make our own symbol as long as the figures are correct. Could you please make the macro as flexible as possible so that in case the powers that be would approve on our proposal the codes would be easier to amend?
How are you going to display cutting classes am, late am, absent pm?

Besides being significantly more convoluted to code for, it'll confuse users trying to get what they want - they'll need the contradictions/exceptions explained, and it'll be more difficult to get the row and column totals correct (If the letters L, X & C in a cell all represent half days (not counting the L in the LE pair), then counting occurrences of these letters makes for simpler and more robust totals formulae.)

The 'authorities', 'powers that be', 'the higher ups', whatever, haven't put the thought into this that you (and I) have; their decisions are often ill-informed and ill-advised, sometimes they're just bloody-minded and want to show who's boss. It's up to you to advise and inform them what's best. At the moment I'm leaning strongly towards my last suggestion of the smaller triangles on top of the larger ones (If you want, we could even keep ALL cutting classes small red triangles, regardless of whether they're sittting atop another larger triangle, to maintain consistency).

I would prefer you to set things in concrete sooner rather than later - I don't want to have to revisit this too often. Remember, I'm doing this for nothing.

I think I might have to back-pedal a little on having something ready at the weekend, something's come up and it's already Friday afternoon here in the UK. Next week's very busy for me too. So you'll need patience, and I'm not giving up and I've made good progress.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
New learner need help - convert tables in word format to ppt slides. sas Word VBA 5 09-21-2017 08:33 PM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Good morning/afternoon/evening based on time dwirony Word VBA 1 01-03-2017 01:01 PM
Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formula UICOMP Excel 1 05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft