It is used to convert luminous flux to radiant power.
A lot of the guys watching my posts yesterday thought I was saying your stuff does not work. I was confused because my formulas worked and my equivalent of your QER already worked. What I did not understand is you were going for Flux not PPFD. That's why our conversion factors did not march.
I was called sloppy and that's why my shit doesn't work. But my stuff worked, your stuff worked but the conversion numbers did not match. Not even close.
My revere engineering of the spreadsheet may have appeared that I was crazy, but any one that first meets me thinks I'm weird but interesting. Then they realize I'm just different and refer to me as a genius. Those that get to know me well understand I am crazy.
The rambling of my post is exactly how I think. I wrote everything that popped into my head and I wrote my exact thoughts.
I drank a 12 pack of Bud while I was reverse engineering the spreadsheet. It took many hours. I hate trying to figure out others code. I can duplicate in much faster by writing it from scratch. And in this case I already had the formulas. I just did not know what you were doing with them.
It is used to convert luminous flux to radiant power.
This is what confused me about cell F4. It cancels out B2 in row E formula. That makes no sense. That's why I stopped there.
You did not need to convert luminous flux to radiant. The sum of B2 is radiant. Column B2 is like the spectra of a 1 Watt LED where the spectra is expressed in radiometric Watts. You only needed to convert column B from radiometric to luminous.
When I posted asking this thread to help me and show me the math a couple of guys said it was explained in the first few posts of this thread. But it really was not explained the description was too vague. It was some formulas I recognized from Wikipedia. I did not understand that at first. When I write open source I explain a little bit about the coding. But I was impressed because not many people understand how to go from the energy of a photon to luminous flux. It is not simple until after you've done it the first time.
Sorry about .00836. Of course it is 10^-3/(N_a * h * c).
It's actually 1/c
•N
a, no
h
That's okay if you read my post, I did not remember what it was either. The post is the only reason I was able to tell you as I went back to my original formulas to find where it came from. I never documented my work because I could remember everything. Well those days are long gone.
Now what happened last night was funny. I am still using Win XP. I turned of updates in 2006 and do not use antivirus because the antivirus cure was worse than the disease. So there is a lot of stuff on my hard drive.
I saved your math spreadsheet in a folder called protons. Last night I went to review your spreadsheet and there were a couple other spreadsheets in that folder.
There is this guy David Wyble. I call him a colored guy. Not that I know his race. In the early 2000s he was very active in the CIE chromaticity x y z stuff. I call those guys colored. David was a student at University California San Diego and published some spreadsheets as open source. They would do things like take some spectra and calculate the CRI.
Ten years later in 2010 he published BlackBody.xls on Wikipedia as open source.
First thing I notice is the style of the formula there is like the ones you posted.
The constants are in almost the same place as yours
The formula that I called big and ugly that should be replaced in your spreadsheet, almost the same formula is in this spreadsheet.
I thought the was a cool story that a spreadsheet from way back ended up in the same folder with yours and they are almost identical in both programming and layout style.
I digitize the the view angle radiation pattern for a couple of my apps. I just enter the percentage the values on the graph at 10° intervals and my code fills in the other 9 degrees in between. Those parts of the slope are so linear it simple to do it that way.
I was looking at the SPD graphs wondering how I would digitize them.
It must be difficult to digitize when there are multiple CCT curves plotted on the same graph.
My idea was to do a web app where you upload the SPD and it gets displayed on the screen.
You click on 400nm 100% and 700nm 0% to identify the corners of the graph.
Then you click on a some points on the curved parts of the curve and then I can generate the the efficiency numbers from those points. I just need to know where the curves curve and in which direction. Then I can fill in everything in the linear portions between the x y coordinates that were clicked. If you are interested.
Well at least now you guys have all the detail of how the spreadsheet works if you can follow the way my mind works in my ramblings. It may not appear so at first but I kinda know what I am doing.
And those that criticized me and made fun of me, that's okay, I understand. And really, I don't give a fuck what anyone else thinks and I've got no fucks to give.
