# Create Customized Production Report using Omron FINS

**URL:** <https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077>\
**Category:** General\
**Tags:** database\
**Created:** [22 November 2023 08:31 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077 "2023-11-22T08:31:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jagades](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jagades/32/75744_2.png) [@jagades](https://discourse.nodered.org/u/jagades)\
**Post date:** [22 November 2023 08:31 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/1 "2023-11-22T08:31:17Z")

</div>

Hello, I am searching for ways to create customized reports from Omron PLC. Basically my plan is to use Omron FINS protocol, and I have done work related to creating reports on csv formatted file using Omron RS485, through the Node-Red platform. I will share the template below, please suggest if there are any ways for filling data into excel files of this type. Thanks!

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/d/1d19fa0474dfabbe4890459e6c558be5b6a764a6.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [22 November 2023 08:40 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/2 "2023-11-22T08:40:43Z")

</div>

> [@jagades](#):
>
> I have done work related to creating reports on csv formatted file using Omron RS485, through the Node-Red platform

If you are able to do it with serial data, then it should be pretty much identical except where you get the data from!

What part are you stuck on?

---

<div class="post-metadata">

**Author:** ![jagades](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jagades/32/75744_2.png) [@jagades](https://discourse.nodered.org/u/jagades)\
**Post date:** [22 November 2023 08:52 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/3 "2023-11-22T08:52:03Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/8/7888111cef2eeaee003a3cfbb88fb19b7d84d173.png)  
Hi Steve. For my previous work, I simply created 1 csv file per day with custom name and the data fill method was totally different from the current template I'm using. The old report that I made looks like the picture attached below :-  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/2/a29cb4de4c2a10df174db0fd290228bef65208e8.png)

My concern now is, as the report format I showed earlier had a specified format, how am I able to destine each data into a specified cell? For example, I want to fill data D1 to D10 from Omron PLC memory to the excel report specifically on cells B10 to B19. This is where I'm facing an issue.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [22 November 2023 09:05 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/4 "2023-11-22T09:05:07Z")

</div>

So this _really_ has nothing to do with Omron. The data could be random, or from a vacuum cleaner 😉

I guess the real question is how to generate formatted reports from data?

Have you tried anything? For example, there are several excel nodes in the [flow library](https://flows.nodered.org/search?term=excel&type=node&type=flow)?

Have a look at those, give the promising ones a go.

Head back with specific questions if you get stuck.

---

<div class="post-metadata">

**Author:** ![Paul-Reed](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/paul-reed/32/66906_2.png) [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Post date:** [22 November 2023 09:10 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/5 "2023-11-22T09:10:04Z")

</div>

> [@jagades](#):
>
> how am I able to destine each data into a specified cell?

I'm no excel expert, but couldn't that be achieved by excel itself, transferring data from your 'old' spreadsheet to the new template. Macro function?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [21 January 2024 09:10 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077/6 "2024-01-21T09:10:17Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.