You may try Hybrid Renewable and Distributed Generation Design Software from "www.homerenergy.com". A few of my students have used this software successfully in their research projects.

See Development of a Smart Residential Load Simulator for Energy Management in Smart-grids.

Smart residential load simulator. Downloads | Power and Energy Systems Group University of Waterloo

https://uwaterloo.ca/power-energy-systems-group/downloads

Simulates wind, solar and battery sources for power generation in residential houses in microgrid. Impact of variables such as ambient temperature, solar radiation and household activity levels that contribute to energy consumption are also considered. The simulator allows to model the way appliances consume power an compile aggregated dataset for electrical energy consumption (only) for the house or dwelling. 

and time series probabilistic synthetic  load curve model for  residential customers

https://www.researchgate.net/publication/224258418_A_time_series_probabilistic_synthetic_load_curve_model_for_residential_customers

and finally community-scale residential energy demand simulation 

http://www.ibpsa.org/proceedings/bs2013/p_1265.pdf

FC

Conference Paper A time series probabilistic synthetic load curve model for r...

http://sel.me.wisc.edu/trnsys/

Probably this would help

Faizal

Thank you FC, Mohammed this helps

Yes I use TrnSys in my thermodynamic and thermoelectric modelling. To test and evaluate the TrnSys models in terms of user demand response I do need realistic dataset, archive data or load similation data.

Colleague suggested to me CASAnova 3.3, educational software for heating and cooling energy demand as well as the temperature behaviour in a house or building http://nesa1.uni-siegen.de/index.htm?/softlab/casanova_e.htm

and Microgrid Simulation Tool RAPSim  http://sourceforge.net/projects/rapsim/

RAPSim - Microgrid Simulator is an easy to use GUI enables electric source and grid simulation. Quick introduction how to use the Renewables Alternative Power System Simulation (RAPSim) is given here 

https://www.youtube.com/watch?v=bo9t6Tnsqjk

RAPSim was developed at the Alpen-Adria-Universität Klagenfurt within the Lakeside Labs project Smart Microgrid. The architect of RAPSim Manfred Rabl-Pöchacker gives an ultra-fast introduction to the tool in three minutes.

Gerro

You may try Hybrid Renewable and Distributed Generation Design Software from "www.homerenergy.com". A few of my students have used this software successfully in their research projects.

There is an excellent anonymised smart-meter data set with the half-hourly consumption of over 1000 households (with half-hourly interval) for over 1-year available on request from the ISSDA:

http://www.ucd.ie/issda/data/commissionforenergyregulationcer/

This may be of some use to you, although these will be for typical urban/rural households in Ireland so may not be suitable for the remote/island applications you are interested in.

There is a flag indicating whether each user is residential or SME (Small-to-Medium Enterprise) but other than that there is no locational or other details information on the users.

Another possibly useful source of data is that which was used for the GEFCOM (Global Energy Forecasting COMpetition) 2012. It was hosted on Kaggle so data still available there:

https://www.kaggle.com/c/global-energy-forecasting-competition-2012-load-forecasting/data

This data-set has been extensively used (for forecasting at least) so is something like a 'standard' electrical demand data set. The same goes for the 2014 competition which was hosted on CrowdAnalytix:

https://crowdanalytix.com/contests/global-energy-forecasting-competition-2014-probabilistic-electric-load-forecasting

Kind regards,

- Khalid.

Dear Khalid

Thank you so much, your response is most useful ! I appreciate your answer.

very good, regards

Gerro

For those following this question, I managed to find some interesting domestic household Appliance Simulators and Appliance Emulators that outputs energy consumption for testbed evaluation of renewable energy microgrid systems and optimization algorithms 

The SRLS is a tool developed under the auspices of NSERC-Canada that facilitates the study of energy management systems in Smart Grids based on Matlab-Simulink-GUIDE toolboxes, providing a complete set of user-friendly graphical interfaces to properly model and study Appliance loads

https://ece.uwaterloo.ca/~ccanizar/software/srls.htm

Computer program simulator for smart load management of standard household appliances as a base for later on-chip integration or to optimize and balance the overall power consumption of a household:

http://www.thinkmind.org/download.php?articleid=simul_2012_1_10_50043

The Hybrid Sunshine Solar Energy Simulator (SES) simulates electricity consumption by your appliances, electricity generation by Solar or Wind Systems and electricity stored by Batteries. See video on link 

http://www.hybridsunshine.com/solar-energy-simulator/

there is also a full Matlab appliance load emulator source code software on this link

https://github.com/keirstead-group/simelec

trust this helpful

Some work we recently completed, Scoping exercise to determine load profile archetype reference shapes for solar co-generation models in isolated off-grid rural African villages

https://www.researchgate.net/publication/306098038_Scoping_exercise_to_determine_load_profile_archetype_reference_shapes_for_solar_co-generation_models_in_isolated_off-grid_rural_African_villages

Article Scoping exercise to determine load profile archetype referen...

Novel method determine rural load profiles for rural villages

https://www.researchgate.net/publication/294086442_Novel_procedure_to_formulate_load_profiles_for_off-grid_rural_areas

Novel procedure to formulate load profiles for off-grid rural areas describes behavior of the electrical appliances, implemented in the procedure in a software tool (LoadProGen), which can support the off-grid systems design process for rural electrification. 

Article Novel procedure to formulate load profiles for off-grid rural areas

Thanks for the attention to our (loadprogen) procedure: actually a first release of the code is available at https://it-it.facebook.com/energy4growing2014/

Thank you so much for this input Marco, very interesting concept and operating principles suitable for rural energy system modelling.

Gerro

The database available with NREL, USA is the best dataset available online for simulation with HOMER or any other software.

Important procedures in post-processing datasets

Electricity Load Forecasting for Residential Customers: Exploiting Aggregation and Correlation between Households

https://infoscience.epfl.ch/record/188682

Forecasting household consumer electricity load profiles with a combined physical and behavioral approach

https://www.researchgate.net/publication/263812508_Forecasting_household_consumer_electricity_load_profiles_with_a_combined_physical_and_behavioral_approach

Article Forecasting household consumer electricity load profiles wit...

Readers may also find this paper interesting

Scoping exercise to determine load profile archetype reference shapes for solar co-generation models in isolated off-grid rural African villages

https://www.researchgate.net/publication/306098038_Scoping_exercise_to_determine_load_profile_archetype_reference_shapes_for_solar_co-generation_models_in_isolated_off-grid_rural_African_villages

The dataset with rural energy consumption data to download excel spreadsheet is on this link

Scoping Rural Load Profile Electricity n Hot Water Energy Profile Reference Datasets and Excel Data Corpus

https://www.researchgate.net/publication/307509610_Scoping_Rural_Load_Profile_Electricity_n_Hot_Water_Energy_Profile_Reference_Datasets_and_Excel_Data_Corpus

Gerro

Article Scoping exercise to determine load profile archetype referen...

Data Scoping Rural Load Profile Electricity n Hot Water Energy Pr...

Dear Colleagues

Data upload as we received many requests for the data.

Data Rural Village Disaggregated Load Profile from Smart Village ...

Hi Gerro J. Prinsloo I'm looking for a tool that helps me to simulate home/buildings energy consumption. Looking at the comments it looks like you have tried many. Could you please recommend me the one you found more complete/useful?

Dear Ricardo

you can try https://www.loadprofilegenerator.de

mostly for load profiling in developed coutry contexts though.

Gerro