×

Introducing the Orbi 970 Series Mesh System with WiFi 7(BE) technology. For more information visit the NETGEAR Press Room.

Orbi WiFi 7 RBE973
Reply

More Fun with Excel and Attached Devices

SLK-Purdue
Luminary

More Fun with Excel and Attached Devices

Recent firmware V2.7.1.60 broke the Excel Orbi SOAP spreadsheet I posted earlier this year.  Problems have been corrected and the link below is a version that now supports all posted firmware versions.

 

https://www.dropbox.com/s/o0eaj5kjs3cpxcc/ORBI%20Soap%20Request.xlsm?dl=0 

 

Stay safe,

 

Scott

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 1 of 12
CrimpOn
Guru

Re: More Fun with Excel and Attached Devices

Thanks for keeping this up. One of my "go to" tools.

I did notice that both the previous version and this version report uptime as hhh:mm:ss, (mine is 645:112:51)

whereas the Orbi "debug" page reports uptime as dd:hh:mm:ss (mine is 26:21:12:39)

I'll bet the internal timer is defined in one unit of measure and the debug page is calculating the display results. (you may be, too).

Message 2 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

I keep forgetting to look at that. Will make a note. 

sxott

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 3 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

Just uploaded Version 2.1 that has uptime in the dd:hh:mm:ss format.

 

https://www.dropbox.com/s/o0eaj5kjs3cpxcc/ORBI%20Soap%20Request.xlsm?dl=0 

 

Thanks for the feedback.

 

Scott

 


Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 4 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

Recent firmware broke the original version.   The following link works with all firmware version up through 2.7.2.104

 

https://www.dropbox.com/s/o0eaj5kjs3cpxcc/ORBI%20Soap%20Request.xlsm?dl=0 

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 5 of 12
CrimpOn
Guru

Re: More Fun with Excel and Attached Devices


@SLK-Purdue wrote:

Recent firmware broke the original version.   The following link works with all firmware version up through 2.7.2.104

 

https://www.dropbox.com/s/o0eaj5kjs3cpxcc/ORBI%20Soap%20Request.xlsm?dl=0 


Not for me. Sorry. See attached error message.

Message 6 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

Curious.   Worked fine when I tested yesterday after correctly an end-case coding error on my part.

 

I will take a look.  What version of Windows and Excel?

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 7 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

Also please confirm the spreadsheet says Version 2.1.1 in the upper right corner.

 

Scott

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 8 of 12
CrimpOn
Guru

Re: More Fun with Excel and Attached Devices

Windows 10. Excel 2019 MSO (16.0.13530-20418) 64-bit

yes, version 2.1.1

Message 9 of 12
CrimpOn
Guru

Re: More Fun with Excel and Attached Devices

Debug takes me to this screen and highlights Send

Message 10 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

Thanks for the info. Looking into it. 

Scott

 

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 11 of 12
SLK-Purdue
Luminary

Re: More Fun with Excel and Attached Devices

I found the bug and update the spreadsheet.  Working version for all levels of firmware is:

 

https://www.dropbox.com/s/o0eaj5kjs3cpxcc/ORBI%20Soap%20Request.xlsm?dl=0 

 

Spreadsheet should read Version 2.2 in the upper right corner.

 

Scott

Model: RBR50|Orbi AC3000 Tri-band WiFi Router
Message 12 of 12
Top Contributors
Discussion stats
  • 11 replies
  • 910 views
  • 1 kudo
  • 2 in conversation
Announcements

Orbi WiFi 7