tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: fd1c6d76-d816-4f6a-90b9-6ea316e612c4
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Internettoperatører
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] | [NAME]. 2 | 0159 | Oslo | 400 01 525
[NAME] | Langkaia 1 | 0150 | Oslo | 22 91 03 50
[NAME] Christian Brosstad | [NAME] 24 | 1407 | Vinterbro | 64 94 53 23
Tacky Products AS | Grefsenveien 26 | 0482 | Oslo | 22 97 05 50
Entertrainer AS | [NAME] 28B | 0661 | Oslo | 481 81 318
[NAME] | Torggata 16 | 0181 | Oslo | 905 06 137
All In Web | Strandgata 13C | 2815 | Gjøvik | 61 17 32 60
Skannex AS | Gaustadalleen 21 | 0349 | Oslo | 992 52 274
Silvados AS | [NAME] gate 9 | 0153 | Oslo | 978 91 488
Pro5 AS | Haugboveien 10B | 1384 | Asker | 416 03 606
Yoo DA | [NAME] 7 | 0190 | Oslo | 22 17 72 17
Nettmedia24 DA | [NAME] 28 | 1768 | Halden | 974 91 030
Poi Nordic AS | [NAME] | 2020 | Skedsmokorset | 472 42 617
Damaca-Trading [NAME] | [NAME] gate 4B | 2315 | Hamar | 942 56 932
[NAME] | Pilestredet 8 | 0180 | Oslo | 52 79 05 82
Mamma Media AS | [NAME] veg 9 | 2843 | Eina | 950 02 803
Helsekostbransjens Vareregister AS | Grenseveien 65 | 0663 | Oslo | 23 37 64 50
Player DA | [NAME] 7 | 0190 | Oslo | 22 17 72 17
[NAME] Torget AS | Grensen 5/7 | 0159 | Oslo | 22 86 44 10
Active Media AS | Lomnessjøen | 2485 | Rendalen | 480 68 283
Stk Marketing Ltd | Hesteskoen 2 | 0493 | Oslo | 920 97 060
[NAME] | Landingsveien 68 | 0767 | Oslo | 901 94 949
[NAME] | [NAME] | 1615 | Fredrikstad | 69 28 40 00
Bjørnstad Utvikling AS | Kringsjå 11A | 1605 | Fredrikstad | 911 07 116
Justis DA | [NAME] 7 | 0190 | Oslo | 22 17 72 17
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 59687d1260274019-extraxt-missing-data-2-column-copy-of-extract-missing-value
Sheet: Sheet1

 | MASTER | RESULT MONTH -1 |  | MISSING VALUES IN COL C COMPARING WITH COL B
 | 1 | 1 |  | 32 | 0 | 32
 | 2 | 2 |  | 0 | 0 | #N/A
 | 3 | 3 |  | 0 | 0
 | 4 | 4 |  | 0 | 0
 | 5 | 5 |  | 0 | 0
 | 6 | 6 |  | 0 | 0
 | 7 | 7 |  | 0 | 0
 | 8 | 8 |  | 0 | 0
 | 9 | 9 |  | 0 | 0
 | 10 | 10 |  | 0 | 0
 | 11 | 11
 | 12 | 12
 | 13 | 13
 | 14 | 14
 | 15 | 15
 | 16 | 16
 | 17 | 17
 | 18 | 18
 | 19 | 19
 | 20 | 20
 | 21 | 21
 | 22 | 22
 | 23 | 23
 | 24 | 24
 | 25 | 25
 | 26 | 26
 | 27 | 27
 | 28 | 28
 | 29 | 29
 | 30 | 30
 | 31 | 31
 | 32
Spreadsheet: 747962d1631805800-how-to-create-a-new-column-which-includes-the-last-value-in-rows-that-have-missing-values-example
Sheet: Sheet1

4 | 6 |  | 2 | 1 | 8 |  | 8
5 | 5 | 3 |  | 6 |  |  | 6 | I want to keep data in column A and then make a new column like H to include the last value in each row. For example, I want H1 to include 8 which is the last value in row 2 , and H3 to include 6 which is the last value in row 3.
7 |  | 1 |  |  |  |  | 1
9 | 2 |  | 1 |  |  |  | 1
2 | 7 | 2 |  |  |  |  | 2
1 |  | 5 |  |  |  |  | 5
3 |  | 1 | 5 |  |  |  | 5
Spreadsheet: 16649bec-42a3-40f6-b8fd-5963039009ff
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | Alter:
Antwort | 15-24 | 25-34 | 35-44 | 45-54 | 55-64 | [NAME] 65
[NAME] | 0.29 | 0.29 | 0.27 | 0.26 | 0.28 | 0.44
Neutral/Weiss nicht | 0.15 | 0.14 | 0.13 | 0.1 | 0.12 | 0.13
[NAME] | 0.55 | 0.57 | 0.6 | 0.64 | 0.6 | 0.42
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 139614d1328337304-excel-2010-bi-weekly-paycheck-tracker-income-calculator
Sheet: Nov 2012

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Creator Software
 | ◄ October |  |  |  | ~ November 2012 ~ |  |  |  |  |  |  |  | December ► |  |  |  |  |  |  |  |  |  |  |  | 2011 XLS Calendars
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 XLS Calendars
 |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 |  | 2012-11-02 00:00:00 |  | 2012-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | XLS Calendar Templates
 | 2012-11-04 00:00:00 |  | 2012-11-05 00:00:00 |  | 2012-11-06 00:00:00 |  | 2012-11-07 00:00:00 |  | 2012-11-08 00:00:00 |  | 2012-11-09 00:00:00 |  | 2012-11-10 00:00:00
 | 2012-11-11 00:00:00 |  | 2012-11-12 00:00:00 |  | 2012-11-13 00:00:00 |  | 2012-11-14 00:00:00 |  | 2012-11-15 00:00:00 |  | 2012-11-16 00:00:00 |  | 2012-11-17 00:00:00
 | 2012-11-18 00:00:00 |  | 2012-11-19 00:00:00 |  | 2012-11-20 00:00:00 |  | 2012-11-21 00:00:00 |  | 2012-11-22 00:00:00 |  | 2012-11-23 00:00:00 |  | 2012-11-24 00:00:00
 | 2012-11-25 00:00:00 |  | 2012-11-26 00:00:00 |  | 2012-11-27 00:00:00 |  | 2012-11-28 00:00:00 |  | 2012-11-29 00:00:00 |  | 2012-11-30 00:00:00 |  | Notes:
Spreadsheet: 682602d1592225221-why-wont-a-simple-formula-work-in-an-empty-cell-test1
Sheet: Sheet1

CURRENT | HIGHEST | FALLING | Highest Price
 |  | Today's Price
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
 | #[NAME]!
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 43413 | 45338
2 | 45284 | 45338
3 | 34397 | 34338
4 | 64090 | 66519 |  |  |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 66505 | 66519 | -21381 | -20000
6 | 62713 | 66519 | -21994 | -20000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 67373 | 66519 | -20031 | -20000
8 |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 116110
2002-01-07 00:00:00
CBS Dollars
 |  |  | 296376
Spreadsheet: 155942d1337112129-items-used-from-a-drop-down-list-1-time-master-equip-2
Sheet: JOB 11

 |  |  |  |  |  |  |  | Date |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | B&H Job #
 |  |  |  |  |  |  |  | Contract#/ PO#
 |  | Customer Name |  |  |  |  |  |  | WO#
 |  | Employee | Work Performed |  |  |  |  | Hours |  | Rate |  | Amount
 |  |  |  |  |  |  |  | ST | OT | ST | OT
 |  | 101 |  |  |  |  |  |  |  | 48.5 | 65.48 | 0
 |  | 102 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 103 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 104 |  |  |  |  |  |  |  | 48.5 | 65.48 | 0
 |  | 105 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 106 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 107 |  |  |  |  |  |  |  | 48.5 | 65.48 | 0
 |  | 108 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 109 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 110 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 111 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 112 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 113 |  |  |  |  |  |  |  | 48.5 | 65.48 | 0
 |  | 114 |  |  |  |  |  |  |  | 35 | 47.25 | 0
 |  | 115 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 116 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 117 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 118 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 119 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 120 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 121 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 122 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 123 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 124 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 125 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 126 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 127 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 128 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 129 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | 0 |  |  |  |  |  |  |  | 42 | 56.7 | 0
 |  | Total |  |  |  |  |  |  |  |  |  | 0
 |  | Equipment |  |  |  |  |  | HRS | Day | Week | Rate
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total |  |  |  |  |  |  |  |  |  | 0
 |  | Materials & 3rd party rentals |  |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Notes: |  |  |  |  |  |  |  |  | Total | 0
 |  |  |  |  |  |  |  |  |  | Total |  | 0
 |  | Signed By
Spreadsheet: phillip_allen__28830__routine
Sheet: matrix

Base Price | 2.77 |  |  |  | Morning | Noon Lull | [NAME]
 |  |  |  | Prices
 |  |  | -0.15
 |  |  | -0.14
 |  |  | -0.13
 |  |  | -0.12
 |  |  | -0.11
 |  |  | -0.1
 |  |  | -0.0900000000000001
 |  |  | -0.0800000000000001
 |  |  | -0.0700000000000002
 |  |  | -0.0600000000000002
 |  |  | -0.0500000000000002
 |  |  | -0.04
 |  |  | -0.03
 |  |  | -0.02
 |  |  | -0.00999999999999998
 |  |  | 0
 |  |  | 0.01
 |  |  | 0.02
 |  |  | 0.03
 |  |  | 0.04
 |  |  | 0.05
 |  |  | 0.06
 |  |  | 0.07
 |  |  | 0.08
 |  |  | 0.09
 |  |  | 0.1
 |  |  | 0.11
 |  |  | 0.119999999999999
 |  |  | 0.129999999999999
 |  |  | 0.139999999999999
 |  |  | 0.149999999999999
Spreadsheet: andy_zipper__452__11_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 18 | 262 | 270 | 66.1 | 68.1 | 0.76 | 2001-11-16 13:35:00
 | CL G2 | 18 | 360 | 375 | 61.9 | 64.5 | 0.72 | 2001-11-16 13:35:00
 | CL H2 | 18.5 | 415 | 435 | 57.4 | 60.1 | 0.68 | 2001-11-16 13:35:00
 | CL J2 | 19 | 455 | 475 | 53.5 | 55.8 | 0.65 | 2001-11-16 13:35:00
 | CL K2 | 19 | 490 | 510 | 51.2 | 53.3 | 0.62 | 2001-11-16 13:35:00
 | CL M2 | 19 | 520 | 540 | 50 | 52 | 0.61 | 2001-11-16 13:35:00
 | CL N2 | 19 | 540 | 560 | 48.1 | 49.9 | 0.59 | 2001-11-16 13:35:00
 | CL Q2 | 19 | 555 | 580 | 46.4 | 48.5 | 0.57 | 2001-11-16 13:35:00
 | CL U2 | 19 | 560 | 585 | 44.5 | 46.5 | 0.54 | 2001-11-16 13:35:00
 | [NAME] | 19 | 560 | 585 | 42.2 | 44.1 | 0.52 | 2001-11-16 13:35:00
 | CL X2 | 19 | 560 | 595 | 40.4 | 42.9 | 0.5 | 2001-11-16 13:35:00
 | [NAME] | 19.5 | 555 | 565 | 37.6 | 38.3 | 0.47 | 2001-11-16 13:35:00
 | CL M3 | 20 | 550 | 585 | 30.5 | 32.5 | 0.4 | 2001-11-16 13:35:00
 | CL Z3 | 20 | 550 | 590 | 27 | 29 | 0.35 | 2001-11-16 13:35:00
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Gas - Struct

 | Natural Gas Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000 | 2
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 274397d1383105102-if-then-statements-shows-list-1-
Sheet: Sheet1

Show Title | Episode Watched | Air Day | Air Date | Watched | Next Episode
American Horror Story Coven | S03E04 | Wed | 2013-11-30 00:00:00 | x
Amish Mafia |  | Done
Duck Dynasty | S04E09 | Wed | 2013-11-30 00:00:00 | x
Game of Thrones |  | Spring 2014
Gold Rush | S05E02 | Fri | 2013-11-01 00:00:00
Hardcore Pawn | S07E25 | [NAME] | 2013-11-29 00:00:00
Jungle Gold |  | Just Finished
Marvel Agents of S.H.I.E.L.D. | [NAME] | [NAME] | 2013-11-05 00:00:00
[NAME] |  | [NAME]
Sleepy Hollow | S01E05 | Mon | 2013-11-04 00:00:00
Sons of Anarchy | S06E08 | [NAME] | 2013-10-29 00:00:00
True Blood |  | Summer 2014
Walking Dead | S04E02 | Sun | 2013-11-03 00:00:00
Spreadsheet: 877689d1724499099-pay-calculation-form-junior-to-senior-scale-krixxx-salaries-2007-aligw
Sheet: Sheet1

 |  |  |  |  | Salary Month | Pay Scale after Promotion |  | Junior Programmer  Pay Scale | Senior [NAME]
Pay Scale on Date | 2024-08-08 00:00:00 | Pay Scale of Junior Programmer | 35830 |  |  |  |  | 29100 | 35700 |  | Remarks
 |  |  |  |  |  |  |  |  |  |  | Column F from Cell F2 onwards contains formula to return the months
Regular Increment Date/Month | 2025-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | Column I contains formula from Cell I3 onwards to calculate pay scale
 |  |  |  |  |  |  |  |  |  |  | Column J contains formula from Cell J3 onwards to calculate pay scale
In excel column I there is pay scale range starting from cell I2 to I33 which is 29100 in cell I2 and it increase by 3 percentage and rounded to ceiling 10, in I33 the pay scale is 73020 of Junior Programmer,  In column J there is pay scale range starting from J2 to J33 which is 35700 in cell J2 and increase by 3 percentage and rounded to ceiling 10, in J33 the pay scale is 89510 of Senior Programmer. In cell B2 there is present pay scale date which is in this example is 08-aug-2024 and the regular increment date is in cell B4 which is 01-apr-2025 in this case. The present pay scale of Junior Programmer is in cell [NAME] which is 35830 in this example and the pay scale fixation of promoted employee will be done as shown in column G starting from cell G2 onwards and Salary Months will be as per column F. The logic of pay fixation of promoted employee will be as below. In our example, The present pay scale of promoted employee is 35830, then he will get the increment in Junior Programmer cadre as per column I, which is 36910, and his regular increment month/date it 01-apr-2025, in column G the result will be from cell G2 to G9 will be 36910.  When the regular increment month Apr-25 will come in column F Cell (in this case Cell F10) the employee will received next increment in the Junior Programmer cadre which will be in this case is 38020 as per column I and will be fitted in the next higher scale of Senior Programmer  cadre as per column J which is 39030. So this employee will receive 39030 from Apr-25 onwards for next 12 months till mar-26 and then in apr-26 he will received next increment as per column J which will be 40210 in this case and that scale will be last for 12 months and so on. So basically by entering Data in Cell B2, B4 and D2 I expect the result as per Column G from cell G2 onwards. P.S. Colour coding and formatting is for better understanding only.
Spreadsheet: 779294d1651683735-to-let-cell-value-in-one-column-move-according-to-value-in-another-column-vlookup-data-book1
Sheet: Raw Data

 | *Data obtained and [NAME] from ERP source, the sequence will be different next time after adding new data in between the current sequence
 |  |  |  |  | My question: To enable the cell value in Column B move around according to cell value in Raw Data
 |  |  |  |  | Example: If next time the sequence is changed as below: any method to let Column B fixed according to Raw Data (Other than IF formula)?
 | Data to be input based on Raw data |  |  |  | After adding new raw data and the sequence is changed |  |  |  |  |  |  | Desired output:
 | Raw Data* | Column B |  |  | Raw Data* |  | Column B |  |  |  |  | Raw Data* |  | Column B
 | America | 1 |  |  | America |  | 1 |  |  |  |  | America | <---------- | 1
 | Brazil | 2 |  |  | Brazil |  | 2 |  |  |  |  | Brazil | <---------- | 2
 | Canada | 3 |  |  | Brunei |  | 3 |  |  |  |  | Brunei
 | Denmark | 4 |  |  | Canada |  | 4 |  |  |  |  | Canada | <---------- | 3
 | Egypt | 5 |  |  | Cambodia |  | 5 |  |  |  |  | Cambodia
 | France | 6 |  |  | Denmark |  | 6 |  |  |  |  | Denmark | <---------- | 4
 | Germany | 7 |  |  | Egypt |  | 7 |  |  |  |  | Egypt | <---------- | 5
 |  |  |  |  | France |  |  |  |  |  |  | France | <---------- | 6
 |  |  |  |  | Germany |  |  |  |  |  |  | Germany | <---------- | 7
Spreadsheet: 779158d1651601015-find-sum-of-overtime-worked-between-networkdays-and-holidays-in-a-month-overtime
Sheet: Vaidation

 | YEAR |  | MONTH
 | 2022 |  | JANUARY
 | 2023 |  | FEBRUARY
 | 2024 |  | [NAME]
 | 2025 |  | APRIL
 | 2026 |  | MAY
 | 2027 |  | [NAME]
 | 2028 |  | JULY
 | 2029 |  | AUGUST
 | 2030 |  | SEPTEMBER
 |  |  | OCTOBER
Spreadsheet: 300615d1393520111-overnight-time-graph-help-sleep-diary
Sheet: Sheet3 (2)

Date | Time got into bed | Time tried to sleep | Time fell asleep | Time woke up | Time got out of bed
2014-02-10 00:00:00 | 00:00:00 | 00:55:00 | 01:55:00 | 09:45:00 | 10:15:00
2014-02-11 00:00:00 | 01:00:00 | 01:20:00 | 01:30:00 | 10:30:00 | 10:45:00
2014-02-12 00:00:00 | 23:00:00 | 23:30:00 | 23:50:00 | 09:30:00 | 09:35:00
2014-02-13 00:00:00 | 23:30:00 | 23:45:00 | 00:10:00 | 07:30:00 | 07:45:00
2014-02-14 00:00:00 | 03:00:00 | 03:30:00 | 04:15:00 | 08:00:00 | 08:15:00
2014-02-15 00:00:00 | 23:00:00 | 11:40:00 | 00:55:00 | 10:00:00 | 10:15:00
2014-02-16 00:00:00 | 00:00:00 | 00:15:00 | 01:00:00 | 07:30:00 | 07:35:00
2014-02-17 00:00:00 | 02:00:00 | 02:45:00 | 03:15:00 | 08:30:00 | 08:50:00
2014-02-18 00:00:00 | 22:00:00 | 22:15:00 | 22:25:00 | 06:00:00 | 06:15:00
2014-02-19 00:00:00 | 23:30:00 | 23:45:00 | 23:55:00 | 10:15:00 | 10:25:00
2014-02-20 00:00:00 | 23:20:00 | 23:45:00 | 00:45:00 | 09:00:00 | 09:05:00
2014-02-21 00:00:00 | 22:45:00 | 22:55:00 | 23:15:00 | 09:00:00 | 07:10:00
2014-02-22 00:00:00 | 22:45:00 | 23:05:00 | 23:30:00 | 06:45:00 | 07:03:00
2014-02-23 00:00:00 | 23:30:00 | 23:40:00 | 00:20:00 | 07:40:00 | 07:50:00
Spreadsheet: kate_symes__18956__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800