A sample every 50 microseconds for 2 weeks is about 24 gigasamples, so possible but not really practical.
You don't necessarily need to store all high-rate measurement samples. Instead, you can integrate the energy consumption in real time and periodically log intermediate results for plotting or tracking trends. This significantly reduces data volume while still providing accurate long-term insights.
Yeah, this sounds like something one could whip together with an arduino and serial port without much trouble...
You might look at specialized coulomb counter chips like the LTC2944. Its measurement is based on a true analog integrator, so it should be able to accurately meter charge even in very fast pulses. The arduino would then read it via I2C and print to serial.
It's incredibly not trivial to measure power consumption on a device like this. Your measuring device needs to cover 7 orders of magnitude, and do that with range switching without UVLO to the DUT.
My bench meter only does an approximate and variable ~2.11 samples per second (probably less, and more variably, if logging over the network via script, which could be timestamped and post processed)
I feel like I'd need a large LC filter to get the bandwidth of the measurement well below 1Hz to make that sort of thing work.
You can make an RC filter <0.1Hz using resistors in the megaohm range and film capacitors with a capacitance of a few µF.
You can use several RC circuits to increase the attenuation of higher frequencies.
This resets the device when that 100mA pulse happens.
3.6V, 3uA normally up to to 100mA for several seconds at a time.
Small.
A bench power supply is fine to emulate a battery.
I can appreciate this issue, as I often have to do similar lifetime estimations. There are 2-3 tools that we have in the office to do these kind of things.
DMM6500 multimeter: Has fast 1MSPS sampling to capture peak current and accurate enough for sleep current. But not really suitable for this IMHO.
Nordic PPK power profiler kit: Low cost device to measure these RF sensors. Unfortunately it's not very reliable, I found it often times to measure the current incorrectly, depending on what the DUT does. Since the FW guys love this thing it's very frustrating when it does that, leading to endless discussions for days, writing reports and so on. I don't think this can do measurements for weeks out of the box. Though it comes with a python library so maybe you can make some software for it to do that measurement and filter/decimate/average the data to manageable amount.
Keithley 2280S: This is a precision power supply. It has a resolution of 0.1uA in it's 100mA range, and accuracy of maybe 3-4uA. I use it in trend plotting mode, and use the statistics to get an average current. It's a Keithley so it's almost good, but disappointing. When you are in statistics, it won't show you the number of points used for the statistics, or elapsed time. Also a 3000 EUR power supply with math functions somehow cannot calculate power. I don't think the statistics in this will go for weeks, you probably have to program it through SCPI and write your own code to calculate the average.
I almost bought the Julescope, but honestly after buying several PPKs I don't think I want to have yet another disappointing USB gadget.