Spreadsheet: 44982d1243783189-multiply-values-in-a-range-skipping-some-values-on-the-middle-of-the-range-rates2
Sheet: Database 2

 | Day | 2
 | Start | 2006JAN
 | End | 2007DEZ
 |  | 2006JAN | 2006FEV | 2006MAR | 2006ABR | 2006MAI | 2006JUN | 2006JUL | 2006AGO | 2006SET | 2006OUT | 2006NOV | 2006DEZ | 2007JAN | 2007FEV | 2007MAR | 2007ABR | 2007MAI | 2007JUN | 2007JUL | 2007AGO | 2007SET | 2007OUT | 2007NOV | 2007DEZ | 2008JAN | 2008FEV | 2008MAR | 2008ABR | 2008MAI | 2008JUN | 2008JUL | 2008AGO | 2008SET | 2008OUT | 2008NOV | 2008DEZ
 |  | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2006 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008
 | DAY | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ
 | 1 | 0.728 | 0.7338 | 0.5729000000000001 | 0.7083 | 0.5859 | 0.6897 | 0.6947 | 0.676 | 0.7448 | 0.6529 | 0.6884 | 0.6288 | 0.653 | 0.7200000000000001 | 0.5725 | 0.6885 | 0.6278 | 0.6697000000000001 | 0.5959 | 0.6476000000000001 | 0.6473 | 0.5354 | 0.6148 | 0.5593 | 0.5643 | 0.6015 | 0.5244 | 0.5411 | 0.596 | 0.5740000000000001 | 0.6152000000000001 | 0.6924 | 0.6582 | 0.6980000000000001 | 0.7519 | 0.6626000000000001
 | 2 | 0.7092 | 0.7626000000000001 | 0.5737 | 0.6895 | 0.5859 | 0.7295 | 0.6506000000000001 | 0.7097 | 0.728 | 0.629 | 0.717 | 0.6257 | 0.6282 | 0.7475 | 0.5644 | 0.6459 | 0.6305000000000001 | 0.7048 | 0.5694 | 0.6699 | 0.629 | 0.5668000000000001 | 0.6126 | 0.5267000000000001 | 0.5643 | 0.6225 | 0.5 | 0.5713 | 0.5615 | 0.5605 | 0.6422 | 0.7149 | 0.6641 | 0.7067 | 0.6940000000000001 | 0.6914
 | 3 | 0.7053 | 0.7577 | 0.5793 | 0.6435000000000001 | 0.6216 | 0.7243 | 0.6191 | 0.7273000000000001 | 0.6985 | 0.6607000000000001 | 0.6822 | 0.6527000000000001 | 0.6567000000000001 | 0.74 | 0.5696 | 0.6528 | 0.627 | 0.6701 | 0.6037 | 0.6679 | 0.5853 | 0.5952000000000001 | 0.5750000000000001 | 0.5267000000000001 | 0.5792 | 0.6022000000000001 | 0.5 | 0.6037 | 0.5812 | 0.5674 | 0.647 | 0.6519 | 0.7011000000000001 | 0.6985 | 0.6756 | 0.7297
 | 4 | 0.7402000000000001 | 0.7609 | 0.5773 | 0.6447 | 0.6068 | 0.6911 | 0.654 | 0.7372000000000001 | 0.6713 | 0.6613 | 0.6745 | 0.5909 | 0.6891 | 0.7008 | 0.5696 | 0.6887 | 0.6299 | 0.645 | 0.6363 | 0.6702 | 0.5962000000000001 | 0.5938 | 0.544 | 0.5577 | 0.5818 | 0.5815 | 0.5205000000000001 | 0.6188 | 0.526 | 0.5994 | 0.6461 | 0.6237 | 0.7455 | 0.7066 | 0.6827000000000001 | 0.7282000000000001
 | 5 | 0.7707 | 0.7256 | 0.5773 | 0.6742 | 0.6122000000000001 | 0.6554 | 0.6924 | 0.7461 | 0.6593 | 0.6785 | 0.6483 | 0.6299 | 0.6773 | 0.6757000000000001 | 0.5747 | 0.7221000000000001 | 0.6221 | 0.6438 | 0.6248 | 0.6216 | 0.6279 | 0.5847 | 0.5298 | 0.5870000000000001 | 0.5871000000000001 | 0.549 | 0.5407000000000001 | 0.6115 | 0.5024000000000001 | 0.629 | 0.6469 | 0.624 | 0.7356 | 0.6843 | 0.7135 | 0.7148
 | 6 | 0.7791 | 0.6919000000000001 | 0.5773 | 0.7159 | 0.6291 | 0.6653 | 0.6952 | 0.7071000000000001 | 0.6919000000000001 | 0.6851 | 0.6151 | 0.6672 | 0.6859000000000001 | 0.68 | 0.5670000000000001 | 0.7265 | 0.5893 | 0.6687000000000001 | 0.6337 | 0.6009 | 0.6615 | 0.5857 | 0.5319 | 0.5826 | 0.5462 | 0.549 | 0.5665 | 0.5810000000000001 | 0.5231 | 0.6458 | 0.6124 | 0.6582 | 0.7097 | 0.6467 | 0.7521 | 0.6832
 | 7 | 0.769 | 0.6916 | 0.5720000000000001 | 0.7153 | 0.5898 | 0.6920000000000001 | 0.6940000000000001 | 0.6755 | 0.7611 | 0.6857000000000001 | 0.6102000000000001 | 0.6675 | 0.6454000000000001 | 0.7078 | 0.5708 | 0.6891 | 0.5893 | 0.7024 | 0.6274000000000001 | 0.6039 | 0.6467 | 0.5614 | 0.5630000000000001 | 0.5803 | 0.523 | 0.5778 | 0.5787 | 0.5484 | 0.551 | 0.6468 | 0.5837 | 0.6927 | 0.675 | 0.6847000000000001 | 0.7284 | 0.6862
 | 8 | 0.7368 | 0.7252000000000001 | 0.5771000000000001 | 0.71 | 0.5564 | 0.7294 | 0.6901 | 0.6847000000000001 | 0.6919000000000001 | 0.6863 | 0.6509 | 0.6705 | 0.6086 | 0.7503000000000001 | 0.5656 | 0.6604 | 0.6252 | 0.6654 | 0.6112000000000001 | 0.6261 | 0.6219 | 0.5614 | 0.5864 | 0.5770000000000001 | 0.5161 | 0.5889 | 0.5741 | 0.5566 | 0.5654 | 0.6427 | 0.6171 | 0.7057 | 0.6674 | 0.7132000000000001 | 0.7232000000000001 | 0.639
 | 9 | 0.6970000000000001 | 0.7585000000000001 | 0.5708 | 0.6764 | 0.5845 | 0.7147 | 0.6699 | 0.7089000000000001 | 0.7129000000000001 | 0.6584 | 0.6873 | 0.6613 | 0.6206 | 0.7306 | 0.5706 | 0.6195 | 0.6545000000000001 | 0.668 | 0.5817 | 0.6617000000000001 | 0.6064 | 0.5826 | 0.5834 | 0.5466 | 0.5464 | 0.5802 | 0.5447000000000001 | 0.5874 | 0.5623 | 0.5747 | 0.6452 | 0.6972 | 0.6656000000000001 | 0.6908000000000001 | 0.7064 | 0.6691
 | 10 | 0.6943 | 0.7545000000000001 | 0.5613 | 0.6462 | 0.6203000000000001 | 0.7256 | 0.634 | 0.7533000000000001 | 0.6715 | 0.6899000000000001 | 0.6763 | 0.6325000000000001 | 0.6485000000000001 | 0.7482000000000001 | 0.5710000000000001 | 0.6243000000000001 | 0.6357 | 0.642 | 0.6149 | 0.6724 | 0.5516 | 0.6209 | 0.5823 | 0.5285000000000001 | 0.5803 | 0.5623 | 0.5447000000000001 | 0.6173000000000001 | 0.5690000000000001 | 0.5738 | 0.6546000000000001 | 0.6672 | 0.7027 | 0.7212000000000001 | 0.6661 | 0.6914
 | 11 | 0.7284 | 0.7382000000000001 | 0.5588000000000001 | 0.6426000000000001 | 0.6131 | 0.6931 | 0.6695 | 0.746 | 0.6304000000000001 | 0.7255 | 0.679 | 0.5995 | 0.6897 | 0.7005 | 0.5710000000000001 | 0.6502 | 0.6424000000000001 | 0.5966 | 0.6521 | 0.6608 | 0.5561 | 0.6228 | 0.5447000000000001 | 0.5595 | 0.5854 | 0.5254 | 0.5759000000000001 | 0.6037 | 0.5411 | 0.6061000000000001 | 0.6543 | 0.6434000000000001 | 0.7279 | 0.6986 | 0.6599 | 0.687
 | 12 | 0.7706000000000001 | 0.7191000000000001 | 0.5588000000000001 | 0.6721 | 0.6136 | 0.6545000000000001 | 0.6948000000000001 | 0.7455 | 0.6342 | 0.7276 | 0.6271 | 0.629 | 0.6861 | 0.6659 | 0.5714 | 0.6915 | 0.6448 | 0.6065 | 0.6463 | 0.6224000000000001 | 0.5869 | 0.6101 | 0.5161 | 0.5942000000000001 | 0.5925 | 0.518 | 0.5716 | 0.6037 | 0.5131 | 0.6274000000000001 | 0.6825 | 0.6485000000000001 | 0.735 | 0.6903 | 0.6890000000000001 | 0.7130000000000001
 | 13 | 0.7729 | 0.6721 | 0.5662 | 0.7083 | 0.6012000000000001 | 0.6534 | 0.679 | 0.715 | 0.6669 | 0.6933 | 0.6557000000000001 | 0.6655 | 0.6813 | 0.6711 | 0.5656 | 0.6963 | 0.6069 | 0.631 | 0.6439 | 0.6062000000000001 | 0.6128 | 0.5732 | 0.5464 | 0.5797 | 0.5604 | 0.5484 | 0.5870000000000001 | 0.5739000000000001 | 0.545 | 0.6378 | 0.6356 | 0.6739 | 0.7304 | 0.6284000000000001 | 0.7215 | 0.7063
 | 14 | 0.7529 | 0.6799000000000001 | 0.5538000000000001 | 0.7094 | 0.5805 | 0.6893 | 0.6963 | 0.6632 | 0.6939000000000001 | 0.6973 | 0.6316 | 0.6867000000000001 | 0.6458 | 0.7084 | 0.5792 | 0.6881 | 0.5791000000000001 | 0.6663 | 0.6479 | 0.6057 | 0.606 | 0.5474 | 0.5769000000000001 | 0.5856 | 0.5194 | 0.5829 | 0.5855 | 0.5576 | 0.5606 | 0.6458 | 0.6052000000000001 | 0.7038 | 0.7026 | 0.6679 | 0.727 | 0.6624
 | 15 | 0.713 | 0.7124 | 0.5643 | 0.6697000000000001 | 0.5805 | 0.7143 | 0.6923 | 0.6796 | 0.6938000000000001 | 0.6483 | 0.6608 | 0.6889000000000001 | 0.6191 | 0.7525000000000001 | 0.5650000000000001 | 0.666 | 0.6039 | 0.6641 | 0.6147 | 0.628 | 0.6267 | 0.526 | 0.6101 | 0.5732 | 0.531 | 0.5877 | 0.5742 | 0.5587 | 0.5638000000000001 | 0.6225 | 0.6401 | 0.7110000000000001 | 0.6849000000000001 | 0.7059000000000001 | 0.7451 | 0.6618
 | 16 | 0.7008 | 0.7536 | 0.5616 | 0.6429 | 0.6079 | 0.727 | 0.6783 | 0.7135 | 0.7042 | 0.6252 | 0.6673 | 0.73 | 0.62 | 0.7401 | 0.5739000000000001 | 0.6266 | 0.6356 | 0.6664 | 0.5829 | 0.6598 | 0.5796 | 0.557 | 0.5747 | 0.5708 | 0.5621 | 0.5911000000000001 | 0.5514 | 0.5797 | 0.5612 | 0.5959 | 0.6696000000000001 | 0.7128 | 0.6689 | 0.6936 | 0.6921 | 0.6904
 | 17 | 0.6984 | 0.7455 | 0.5679000000000001 | 0.5907 | 0.6425000000000001 | 0.6895 | 0.6522 | 0.7556 | 0.6673 | 0.6567000000000001 | 0.6742 | 0.6571 | 0.6479 | 0.7324 | 0.5707 | 0.6242 | 0.6495000000000001 | 0.6249 | 0.6162000000000001 | 0.6545000000000001 | 0.5591 | 0.5878 | 0.5814 | 0.549 | 0.5962000000000001 | 0.5670000000000001 | 0.5514 | 0.612 | 0.5618000000000001 | 0.5940000000000001 | 0.6566000000000001 | 0.6784 | 0.7062 | 0.7101000000000001 | 0.6741 | 0.7064
 | 18 | 0.7324 | 0.7407 | 0.5695 | 0.5991000000000001 | 0.6327 | 0.6813 | 0.6869000000000001 | 0.742 | 0.6641 | 0.6971 | 0.6789000000000001 | 0.6257 | 0.6869000000000001 | 0.6865 | 0.5707 | 0.6606000000000001 | 0.6442 | 0.6115 | 0.651 | 0.6547000000000001 | 0.5591 | 0.5771000000000001 | 0.5629000000000001 | 0.5796 | 0.5862 | 0.5205000000000001 | 0.5897 | 0.625 | 0.5577 | 0.6277 | 0.6758000000000001 | 0.6605000000000001 | 0.7260000000000001 | 0.6982 | 0.6692 | 0.7302000000000001
 | 19 | 0.7638 | 0.7098 | 0.5695 | 0.6371 | 0.641 | 0.6638000000000001 | 0.7307 | 0.7411 | 0.6328 | 0.6908000000000001 | 0.6329 | 0.6548 | 0.6738000000000001 | 0.6702 | 0.5707 | 0.6954 | 0.6327 | 0.6102000000000001 | 0.6414000000000001 | 0.6246 | 0.5907 | 0.5843 | 0.5185000000000001 | 0.62 | 0.5855 | 0.5257000000000001 | 0.5859 | 0.6208 | 0.5168 | 0.6494 | 0.6733 | 0.6483 | 0.7518 | 0.6747000000000001 | 0.6994 | 0.6869000000000001
 | 20 | 0.7646000000000001 | 0.679 | 0.5713 | 0.6755 | 0.6291 | 0.6718000000000001 | 0.7263000000000001 | 0.6991 | 0.6655 | 0.6907 | 0.625 | 0.7311000000000001 | 0.6597000000000001 | 0.6512 | 0.6075 | 0.6861 | 0.6104 | 0.6454000000000001 | 0.636 | 0.5746 | 0.6222 | 0.5656 | 0.5254 | 0.6038 | 0.5443 | 0.5567 | 0.5885 | 0.5856 | 0.5494 | 0.6656000000000001 | 0.6412 | 0.6841 | 0.7402000000000001 | 0.6381 | 0.7343000000000001 | 0.7029000000000001
 | 21 | 0.7776000000000001 | 0.6684 | 0.5677 | 0.6767000000000001 | 0.5889 | 0.6976 | 0.7232000000000001 | 0.6679 | 0.6978000000000001 | 0.6791 | 0.6023000000000001 | 0.6967 | 0.6542 | 0.6512 | 0.6308 | 0.6888000000000001 | 0.5886 | 0.6692 | 0.6526000000000001 | 0.5874 | 0.608 | 0.5652 | 0.5564 | 0.6138 | 0.5369 | 0.5833 | 0.5840000000000001 | 0.5675 | 0.5822 | 0.6264000000000001 | 0.6063000000000001 | 0.7065 | 0.6903 | 0.6681 | 0.7391000000000001 | 0.6597000000000001
 | 22 | 0.7259 | 0.7 | 0.5514 | 0.6366 | 0.5889 | 0.6923 | 0.7123 | 0.6706000000000001 | 0.6922 | 0.649 | 0.6322 | 0.6927 | 0.6261 | 0.6874 | 0.6181 | 0.6455000000000001 | 0.614 | 0.669 | 0.6077 | 0.6189 | 0.6246 | 0.529 | 0.5850000000000001 | 0.6051000000000001 | 0.5204 | 0.5888 | 0.5627 | 0.5675 | 0.6058 | 0.6103000000000001 | 0.6308 | 0.6925 | 0.6924 | 0.7015 | 0.7463000000000001 | 0.6344000000000001
 | 23 | 0.6874 | 0.73 | 0.5585 | 0.613 | 0.6248 | 0.731 | 0.6701 | 0.7042 | 0.6974 | 0.622 | 0.6809000000000001 | 0.6873 | 0.6258 | 0.6573 | 0.6288 | 0.6216 | 0.643 | 0.665 | 0.5845 | 0.6653 | 0.5936 | 0.5601 | 0.5700000000000001 | 0.5813 | 0.5511 | 0.5742 | 0.5266000000000001 | 0.5889 | 0.5859 | 0.6266 | 0.6543 | 0.7246 | 0.6916 | 0.7031000000000001 | 0.7277 | 0.6637000000000001
 | 24 | 0.6930000000000001 | 0.7471 | 0.5619000000000001 | 0.5594 | 0.6961 | 0.7261000000000001 | 0.6556000000000001 | 0.7407 | 0.6599 | 0.6533 | 0.6626000000000001 | 0.6934 | 0.6543 | 0.6725 | 0.6384000000000001 | 0.6288 | 0.6365000000000001 | 0.6239 | 0.6073000000000001 | 0.6517000000000001 | 0.5632 | 0.5859 | 0.5823 | 0.5487000000000001 | 0.5734 | 0.5611 | 0.5266000000000001 | 0.6239 | 0.5875 | 0.6274000000000001 | 0.6524 | 0.7077 | 0.7200000000000001 | 0.7079000000000001 | 0.6814 | 0.6973
 | 25 | 0.7272000000000001 | 0.7346 | 0.5571 | 0.5691 | 0.6647000000000001 | 0.6534 | 0.68 | 0.7259 | 0.6585000000000001 | 0.6889000000000001 | 0.6758000000000001 | 0.6594 | 0.6925 | 0.628 | 0.6384000000000001 | 0.655 | 0.6501 | 0.6049 | 0.6502 | 0.663 | 0.5675 | 0.5914 | 0.5417000000000001 | 0.5793 | 0.5783 | 0.5226000000000001 | 0.5524 | 0.612 | 0.551 | 0.6513 | 0.6695 | 0.6749 | 0.7574000000000001 | 0.6973 | 0.6784 | 0.7124
 | 26 | 0.7685000000000001 | 0.6938000000000001 | 0.5571 | 0.5967 | 0.6683 | 0.6683 | 0.7252000000000001 | 0.7404000000000001 | 0.6256 | 0.6738000000000001 | 0.6334000000000001 | 0.6594 | 0.7206 | 0.6088 | 0.648 | 0.6880000000000001 | 0.6446000000000001 | 0.6044 | 0.6433 | 0.6214000000000001 | 0.5889 | 0.5861000000000001 | 0.517 | 0.5773 | 0.6144000000000001 | 0.5217 | 0.5593 | 0.6153000000000001 | 0.5199 | 0.686 | 0.6672 | 0.6721 | 0.739 | 0.6665 | 0.7090000000000001 | 0.6646000000000001
 | 27 | 0.7588 | 0.677 | 0.5571 | 0.636 | 0.6973 | 0.6591 | 0.7167 | 0.7375 | 0.6581 | 0.6953 | 0.5991000000000001 | 0.6926 | 0.7213 | 0.6063000000000001 | 0.6299 | 0.676 | 0.6283000000000001 | 0.6392 | 0.6452 | 0.5884 | 0.6251 | 0.5914 | 0.5281 | 0.5708 | 0.5823 | 0.542 | 0.5568000000000001 | 0.5741 | 0.5527000000000001 | 0.6704 | 0.637 | 0.6990000000000001 | 0.7209 | 0.6276 | 0.7355 | 0.6923
 | 28 | 0.7552 | 0.6389 | 0.5865 | 0.6323000000000001 | 0.6339 | 0.6942 | 0.7229 | 0.669 | 0.6993 | 0.6811 | 0.6051000000000001 | 0.6668000000000001 | 0.6914 | 0.6331 | 0.629 | 0.6929000000000001 | 0.5835 | 0.6735 | 0.6483 | 0.5989 | 0.6126 | 0.5606 | 0.5592 | 0.5697 | 0.5578000000000001 | 0.5713 | 0.5715 | 0.5501 | 0.5873 | 0.6759000000000001 | 0.6078 | 0.7218 | 0.7135 | 0.6671 | 0.7273000000000001 | 0.659
 | 29 | 0.7338 |  | 0.7083 | 0.5859 | 0.6897 | 0.6947 | 0.676 | 0.7448 | 0.6529 | 0.6884 | 0.6288 | 0.653 | 0.7200000000000001 |  | 0.6885 | 0.6278 | 0.6697000000000001 | 0.5959 | 0.6476000000000001 | 0.6473 | 0.5354 | 0.6148 | 0.5593 | 0.5643 | 0.6015 | 0.5244 | 0.5411 | 0.596 | 0.5740000000000001 | 0.6152000000000001 | 0.6924 | 0.6582 | 0.6980000000000001 | 0.7519 | 0.6626000000000001 | 0.7160000000000001
 | 30 | 0.7338 |  | 0.7083 | 0.5859 | 0.6897 | 0.6947 | 0.676 | 0.7448 | 0.6529 | 0.6884 | 0.6288 | 0.653 | 0.7200000000000001 |  | 0.6885 | 0.6278 | 0.6697000000000001 | 0.5959 | 0.6476000000000001 | 0.6473 | 0.5354 | 0.6148 | 0.5593 | 0.5643 | 0.6015 |  | 0.5411 | 0.596 | 0.5740000000000001 | 0.6152000000000001 | 0.6924 | 0.6582 | 0.6980000000000001 | 0.7519 | 0.6626000000000001 | 0.7160000000000001
 | 31 | 0.7338 |  | 0.7083 |  | 0.6897 |  | 0.676 | 0.7448 | 0.6529 | 0.6884 |  | 0.653 | 0.7200000000000001 |  | 0.6885 |  | 0.6697000000000001 |  | 0.6476000000000001 | 0.6473 |  | 0.6148 |  | 0.5643 | 0.6015 |  | 0.5411 |  | 0.5740000000000001 |  | 0.6924 | 0.6582 |  | 0.7519 |  | 0.7160000000000001