I gang

Google Spreadsheet script

We have a Google Spreadsheet at [login to view URL]

It shows a simple accrual method on worksheet “Straight Accrual”

This is based on values in worksheet “Rate”

I would like you to add a dropdown range of values 1,2,3,4,5,6,7,8,9,10 at “Straight Accrual” Cell D1

Depending on which value is chosen (from the 1-10 range above), it will lookup the corresponding value of its row, from Column C of worksheet “Rate”. These values are summed and displayed in the red cells in Row 41 of worksheet “Straight Accrual”

Here is an example: the User has selected 5 as the step value. Starting from worksheet “Straight Accrual” E5, the lookup is performed at E9. We can see the corresponding rate for E9 is (Rate!C2). This is “1”

Then we continue to lookup rates at each 5 steps (E14, E19, E24, E29, E33), which we can see are C2, C2, C3, C3, C3. Sum these to get 6.3. This is displayed in the red cell at F41

Note, the step range is continual. It doesn’t restart at each month column, but flows in a sequence

Thank you

Evner: Databehandling, Excel, Visual Basic

Se mere: use script in google spreadsheet, google apps script spreadsheet, google script spreadsheet, export script command google spreadsheet, script print spreadsheet google, apps script copy google calendar spreadsheet, write spreadsheet google script, script email spreadsheet google, google check email script spreadsheet, spreadsheet google script sort, php script spreadsheet, php script checking google positions, script php google maps, clone script php google map, script mysql google map cms

Om arbejdsgiveren:
( 216 bedømmelser ) London, United Kingdom

Projekt ID: #13228384

Tildelt til:

javed1705

I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advanced use of MS Excel, I can gu Flere

$64 USD in 2 dage
(73 bedømmelser)
5.9
mikl43

Hello. I can make this work for you. I have extensive experience working with embedded macros to Basic for working with data in tables.

$77 USD in 3 dage
(1 bedømmelse)
0.0

31 freelancere byder i gennemsnit $124 på dette job

jaylancer43

Hello Dominic, Thank you soo much for inviting me to another prospect. I have placed my bid for the same and I am as well looking at the details. Meanwhile if you think there is any additional information that needs Flere

$150 USD in 2 dage
(585 bedømmelser)
8.2
$155 USD in 3 dage
(258 bedømmelser)
7.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Flere

$250 USD på 1 dag
(254 bedømmelser)
7.5
fabest

hello. please let me Know

$94 USD in 2 dage
(63 bedømmelser)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Flere

$100 USD in 0 dage
(201 bedømmelser)
6.8
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Flere

$100 USD in 3 dage
(253 bedømmelser)
6.4
emamulbd

Dear Client, Your job posting catches my attention and I submit the proposal as a desired candidate. I'm a full time freelancer experienced in Lead Generation, Virtual Assistant, PDF conversation, Social Media Marke Flere

$155 USD in 3 dage
(40 bedømmelser)
5.8
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Flere

$88 USD in 3 dage
(68 bedømmelser)
6.0
The24CarrotsInc

Greetings for the day!! We can do this quickly with 100% Quality. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc

$50 USD in 3 dage
(65 bedømmelser)
5.7
$108 USD in 2 dage
(129 bedømmelser)
5.8
axiomswb

We have expertise in Excel [login to view URL] have an expertise team to complete the job within the time span.. Client's satisfaction is my first priority and believe in long-term relationship with clients.

$88 USD in 2 dage
(41 bedømmelser)
5.7
qprotex

Dear Client, My name is Miguel Febres and you can find my CV and certifications in the following links: [login to view URL] [login to view URL] I have many years of exp Flere

$200 USD in 3 dage
(10 bedømmelser)
5.4
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Flere

$99 USD in 2 dage
(53 bedømmelser)
5.8
AlexandrUKR

please clarify possible next steps & budget

$250 USD in 3 dage
(20 bedømmelser)
5.1
royalcalif

Google spreadsheet [login to view URL] Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below vi Flere

$30 USD på 1 dag
(65 bedømmelser)
5.2
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$150 USD in 3 dage
(10 bedømmelser)
5.2
vsprybhanu

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from google Sheets, Advanced Formulas, Critical Programming, Dev Flere

$120 USD in 3 dage
(63 bedømmelser)
5.2
lillysoft

Sir i am really interested in your project . sir i am an expert of software and web development. i have already developed many web and windows applications and some are similar to your project . you can check my port Flere

$200 USD in 3 dage
(14 bedømmelser)
4.7
phongpp2000

Hi Sir, Please share to me your excel file. I add drop down list and lookup value like you request. You only paid to me when I finish your project thanks

$55 USD in 2 dage
(8 bedømmelser)
3.8
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format Flere

$150 USD in 3 dage
(19 bedømmelser)
3.6