#] 
#] *********************
#] "$d_web"'ToDos/history/00_ToDos a notes.txt'
# www.BillHowell.ca  01Jan2024 initial 
# view in text editor, using constant-width font (eg courier), tabWidth = 3

#48************************************************48




#24************************24
# Table of Contents, generate with :
# $ grep  "^#]"  "$d_web"'ToDos/history/00_ToDos a notes.txt' |  sed "s/^#\]/  /" 
#


#24************************24
# Setup, ToDos,   


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] ??Jan2024 


#08********08
#] 01Jan2024 finish my timesheet analysis, LibreCalc tricks
shorten Entertainment -> Entertain
search for cell errors : Err:520
sleep as a separate category, nt under Personal


#08********08
#] 01Jan2024 idiot! I had constructed "Analysis" sheet in data workbook
Don't use separate workbooks, so formula aren't general!

=IF(($Analysis.D3<C88727)&(C88727<$Analysis.D4)

#08********08
#] 01Jan2024 error code 540, reload of external sheets

='file:///home/bill/web/ToDos/history/0_ToDoz_historical_cumulative_timesheet.ods'#$TimeLog.C1

LibreCalc error code, see https://help.libreoffice.org/latest/en-US/text/scalc/05/02140000.html : 
540	External content disabled :
	A function that requires (re)loading of external sources is encountered and the user has not confirmed reloading of external sources yet.
Menu -> File -> reload -> check box
>> OK works


#08********08
#] 01Jan2024 history: '0_Todoz_summary.ods', must modify formulae
change : 
=DSUM('file:///home/bill/contacts/0_ToDoz_historical_cumulative_timesheet.ods'#Timesheet,"Net",M8:Q9)
to : 
=DSUM('file:///home/bill/web/ToDos/history/0_ToDoz_historical_cumulative_timesheet.ods'#Timesheet,"Net",M8:Q9)

named ranges
	Name			Range or formula expression	Scope
	Timesheet	$TimeLog.$A$8:$AC$84759			Document (Global)

change Timesheet range : 
from : $TimeLog.$A$8:$AC$84759
to   : $TimeLog.$A$8:$AC$88767

F9 					recalculate : won't be enough for some calcs (why?)
Ctrl+Shft+F9 hard recalculate : sometimes required 

see "$d_SysMaint"'LibreOffice/0_LibreOffice notes.txt'  
		01Jan2024 search "LibreCalc DSUM from external workbook"

DSUM(Database; DatabaseField; SearchCriteria)
=DSUM('file:///home/bill/web/ToDos/history/0_ToDoz_historical_cumulative_timesheet.ods'#$'Timesheet';'Net';M8:Q9)

NOTE period rather than comma separator :  .M8:Q9) instead of ,M8:Q9)

+-----+
simple test 

='file:///home/bill/web/ToDos/history/0_ToDoz_historical_cumulative_timesheet.ods'#$TimeLog.C1

LibreCalc error code, see https://help.libreoffice.org/latest/en-US/text/scalc/05/02140000.html : 
540	External content disabled :
	A function that requires (re)loading of external sources is encountered and the user has not confirmed reloading of external sources yet.

Menu -> File -> reload -> check box



# enddoc