I'm trying to make a spreadsheet that calculates lots of things about a common-emitter amplifier, in one point I try to make a convergence to know values without using a simulator. I had success with other 2 convergences (discover VB knowing IRC, and discover VBE and IRo for a lower voltage point), ie. I make a guess and iterate tens of times and it reaches a (very good) small error.
I'm not so familiar with how simulators reach convergence, so this is maybe the reason why I've been stuck for 2 weeks with this issue. I use large signal model because all I want to know is the operating point, which of course, wouldn't require an AC model.
The circuit I've been simulating is this: 
which can be simulated here.
So the equations I've been using and checked lots of times are (initiating with a guess and later the equation):
What I know to start:
IS=10 fA
Beta=100
VA (Early Voltage)=10 V
VCC=12 V
VB=1.573315 V
RC=10 kohms
RE=890.7143 ohms
Now I start iterating
VBE=make a guess
Collector current (dependent source): IC=IS*(e^(VBE/0.025865)-1)
Current through the resistance of Early effect: IRo=make a guess
Collector-emitter voltage: VCE=VCC-(IC+IRo)RC-(VB-VBE) also tried with VCE=VCC-(IC+IRo)RC-(IC(1/beta+1)+IRo)RE
(now that I know VCE, recalculate IRo): IRo=(VCE-VBE)*IC/VA
Emitter voltage: VE=(IRo+IC*(1/beta+1))*RE
Ending of first iteration
Calculate VBE: VBE=VB-VE
Now there's nothing new. Calculate IC knowing VBE, calculate VCE, IRo, VE, and so on (more iterations).
Explanation: I'm certain that if I make a guess and the next iteration gives a value that's closer (in modulus) to the real value, it's converging (might oscillate). That's what happens if I put the value I find through simulation (real value), which I don't want to depend. So if I put a different value by a small amount, it oscillates and diverges (doesn't matter if the change occurs in VBE or IRo). It also doesn't matter if I put other real values of VBE and IRo that are compatible with other VB (I did this with the other operation point, which has a lower VB and it worked). So it only is stable, but it doesn't converge.
Edit: The order of the calculation in the iterations matters. It seems that different ways of calculating the same things also matters. I'm tweaking between possible ways of doing the same thing.
*I checked through simulation is that VBE produces a current IC and IRo is a separate effect, scaling with IC and VCB.
I created a copy of the spreadsheet for view only, so if anyone is trying to help me, make a copy of this one https://workdrive.zohopublic.com/sheet/open/cxghkde4696f2596e480abe94daee4d3f2a59 and then you can edit it to try new things. The problem is the convergence below "Maximum values" at cell G60.
Image of the spreadsheet before Early effect was added:
There's more below that my screen couldn't capture at that time.


