tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 271359d1381919703-vlookup-and-match-vlookup-and-match
Sheet: Sheet3

Plant | SKU
2200 | 1170018 |  |  |  | When I put my SKU here
Component
6002545
4001775
6002670
6002671
6002672
6002673 |  | List of componets number that related to this SKU will appear here by referring to the table below:
4001772
6002548
7005587
7005839
7005595
7005506
7005645
7005650
7005693
7006070
Plant & SKU | Plant & SKU & Component | Plant | Mat.Type | Material | Material Description | Base Qty. | BUn | Usage | Alt.BOM | Level | Item | Component | Component Description
[PHONE] | 220011700186002545 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 3 | 10 | 6002545 | Fine Sugar
[PHONE] | 220011700184001775 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 2 | 10 | 4001775 | [NAME]
[PHONE] | 220011700186002670 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 2 | 20 | 6002670 | RM F&N ORANGE RSNJ (CAN & PET) Pt 1
[PHONE] | 220011700186002671 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 2 | 30 | 6002671 | RM F&N ORANGE RSNJ (CAN & PET) Pt 1B
[PHONE] | 220011700186002672 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 2 | 40 | 6002672 | RM F&N ORANGE RSNJ (CAN & PET) Pt 1C
[PHONE] | 220011700186002673 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 2 | 50 | 6002673 | RM F&N ORANGE RSNJ (CAN & PET) Pt 2
[PHONE] | 220011700184001772 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 10 | 4001772 | BS - F&N Orange RS
[PHONE] | 220011700186002548 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 20 | 6002548 | [NAME]
[PHONE] | 220011700187005587 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 30 | 7005587 | BOTTLE PET 500ML - SPLASH (Clear)
[PHONE] | 220011700187005839 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 40 | 7005839 | [NAME] (CSD)
[PHONE] | 220011700187005595 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 50 | 7005595 | LABEL OPP 500ML - F&N ORANGE MY/BN
[PHONE] | 220011700187005506 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 60 | 7005506 | [NAME] Orange MY/BN
[PHONE] | 220011700187005645 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 70 | 7005645 | GLUE - CARTON/TRAY
[PHONE] | 220011700187005650 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 80 | 7005650 | Glue - OPP Label
[PHONE] | 220011700187005693 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 90 | 7005693 | [NAME]
[PHONE] | 220011700187006070 | 2200 | ZFGB | 1170018 | F&N ORG 500MLPET | 24000 | PC | 1 | 1 | 1 | 100 | 7006070 | [NAME] (Machine) - 15 or 17 micron
Spreadsheet: larry_may__21910__ifercgraphBASIS
Sheet: CONTROL PANEL

PIPE 1 | chicago
PIPE2 | pepl
NYMEX LD
NYMEX L3
KCBOT LD
KCBOT L3
CHICAGO
PEPL
CIG
WAHA
EPNG PB
EPNG SJ
HSC
NORAM W
SUMAS
AECO $US
NGPL MC
NNG-TOK
NNG DEMARC
NORAM E
NGPL STX
NGPL LA
TGT SL
TETCO WLA
TETCO ELA
TRANSCO Z3
TRANSCO Z6
TETCO M3
MICHCON
CNG
CGT APP
SOCAL
Spreadsheet: kimberly_watson__20554__imbalsumm0108
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 136208 | 142148
2 | 91841 | 120259
3 | 95240 | 97445
4 | 116769 | 114074
5 | 108530 | 114453
6 | 119572 | 113703
7 | 112545 | 111866
8 | 112164 | 113431
9 | 113044 | 111560
10 | 116403 | 112898
11 | 103748 | 104833
12 | 107912 | 106898
13 | 120413 | 125960
14 | 113885 | 111354
15 | 116049 | 114316
16 | 112428 | 116998
17 | 107540 | 109346
18 | 103802 | 104079
19 | 93807 | 102057
20 | 92618 | 90965
21 | 103978 | 103248
22 | 136225 | 140467
23 | 134427 | 130259
24 | 130095 | 130206
25 | 108803 | 109705
26 | 92412 | 91396
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 54883
2001-08-26 00:00:00
CBS Dollars
 |  |  | 411751.53
Spreadsheet: 111511d1307892447-summarising-data-from-multiple-worksheets-cashbook-sample
Sheet: Lookups

Cost Centre |  | Transaction Type | Table |  | Budget Header | Transaction Type
_CP1112 |  | DD | Bank |  | Accommodation CC | CC
_[NAME] |  | BULKPAY | Bank |  | Accommodation CHQ | CHQ
_RG1112 |  | CHQ | Bank |  | Accommodation DD | DD
_RR11 |  | D/D | Bank |  | Breakdown cover | CC
_SE2011 |  | SO | Bank |  | CLP course | CC
_WV1112 |  | Petty Cash | Petty |  | Deputy Director | BULKPAY
_YPBG1112 |  | CC | Card |  | Fast Track Fiction | CC
_YW1112 |  |  |  |  | Festival | CHQ
OH12TF |  |  |  |  | Franking machine consumables | CHQ
OH13BC |  |  |  |  | Newspapers & Magazines | Petty Cash
OH15SAL |  |  |  |  | Office expenses | Petty Cash
OH17DC |  |  |  |  | Office sundries | BULKPAY
OH18PD |  |  |  |  | Parcels | CC
OH1PC |  |  |  |  | Parking CC | CC
OH2SU |  |  |  |  | Parking Cash | Petty Cash
OH6PO |  |  |  |  | Petty Cash | CHQ
 |  |  |  |  | Photography | BULKPAY
 |  |  |  |  | Previews | BULKPAY
 |  |  |  |  | Reader in Residence | BULKPAY
 |  |  |  |  | Reading Groups | CHQ
 |  |  |  |  | Research & Development B/PAY | BULKPAY
 |  |  |  |  | Research & Development CHQ | CHQ
 |  |  |  |  | Russia Day | Petty Cash
 |  |  |  |  | Service Charges | D/D
 |  |  |  |  | Staff Expenses | Petty Cash
 |  |  |  |  | Subscriptions | DD
 |  |  |  |  | Sundries CC | CC
 |  |  |  |  | Sundries Cash | Petty Cash
 |  |  |  |  | Telephone & Broadband | D/D
 |  |  |  |  | Website hosting | SO
 |  |  |  |  | Workshops | SO
 |  |  |  |  | Writer Lecturer | BULKPAY
Spreadsheet: 112863d1308841516-excel-2007-auto-populate-rows-based-on-preceeding-2-variables-example
Sheet: Sheet1

 | June | June 2011
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23nd | 24th | 25th | 26th | 27th | 28th | 29th | 30th
1 | Task 1 | Start | Shake | Rattle | Roll | End
1 | Task 2 | Start | Left leg in | Left leg out | In | Out | Shake about | Hokey coky | Turn Around | End
2 | Task 2 |  | Start | Left leg in | Left leg out | In | Out | Shake about | Hokey coky | Turn Around | End
3 | Task 3 |  |  | Start | [NAME] left | Step right | Hands on hips | Shake knees | Pelvic thrust | Insane | Time warp | End
3 | Task 4 |  |  | Start | Fun | Stay | Y | M | C | A | End
8 | Task 1 |  |  |  |  |  |  |  | Start | Shake | Rattle | Roll | End
10 | Task 2 |  |  |  |  |  |  |  |  |  | Start | Left leg in | Left leg out | In | Out | Shake about | Hokey coky | Turn Around | End
12 | Task 3 |  |  |  |  |  |  |  |  |  |  |  | Start | [NAME] left | Step right | Hands on hips | Shake knees | Pelvic thrust | Insane | Time warp | End
15 | Task 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Shake | Rattle | Roll | End
Spreadsheet: 682215d1591966525-multiple-layered-if-functions-or-better-use-of-small-largest-funtion-dexterstagg
Sheet: Sheet1

# | Job # | [NAME] Payment |  | Job # | Sorted DoP
1 | BS21 | 2020-06-02 00:00:00
2 | BS22 | 2020-06-01 00:00:00
3 | BS23 | 2020-06-03 00:00:00
4 | BS24 | 2020-06-04 00:00:00
5 | BS25 | 2020-06-01 00:00:00
6 | BS26 | 2020-06-07 00:00:00
7 | BS27 | 2020-06-03 00:00:00
Spreadsheet: 170207d1343206265-confused-as-to-where-the-data-gets-the-information-in-this-spreadsheet-amis-mini-audit
Sheet: Results

 | Key Ratios |  |  |  |  | Critical Success Areas
R6 | Maintenance labour costs vs materials costs |  | 1.936 |  | S | Strategy |  | 18
R9 | Stock turnover |  | 2 |  | W | Work Planning |  | 27.6
R5 | Maintenance expenditure vs replacement cost |  | 0.455 |  | R | Reliability |  | 45
R3 | Maintenance expenditure per craft |  | 5.986842105263158 |  | P | Performance |  | 50.8
R8 | Jobs per man per week |  | 0.05263157894736842 |  | C | Costs |  | 26
R37 | Level of unplanned work |  | 37 |  | M | Materials |  | 44
R99 | Maintenance employees as % total employed |  | 42.56198347107438 |  |  | Overall |  | 35.23333333333333
R97 | Overall Equipment Effectiveness |  | 52
R98 | Downtime |  | 10 |  |  | PAS 55 |  | 39.2
Spreadsheet: 43999d1242665561-need-formula-help-converting-military-time-in-time-card-abc-timecard
Sheet: JULY

 | NAME: | xxx |  |  |  | EMPLOYEE #: |  | xxx |  | MONTH/YR: | 2009-07-01 00:00:00
 | Day | Date | Time In | Time Out | Time In | Time Out | REG HRS | Trng Hours | OT Hours | OT PAY | Comp Time | VAC Used | SICK Used | COMP Used | Sub
[NAME]
 | Thu | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 26 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 27 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 28 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 29 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 30 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Wed | 1 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 3 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 4 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 6 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 7 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 8 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 9 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 10 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 11 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 12 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 13 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 14 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 15 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 16 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 17 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 18 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 19 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 20 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 21 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 22 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 23 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 24 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTALS: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | OT Pay | C | V | S | CU
NOTES: |  |  |  |  |  |  |  |  |  | Vac |  | Sick |  | Comp
 |  |  |  |  |  |  |  |  | Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  | Used this month | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Accumulated |  |  |  |  | 0 |  | *
 |  |  |  |  |  |  |  |  | New Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *this # includes time & a half
 |  |  |  |  |  |  |  | I CERTIFY THAT THE ABOVE HOURS ARE CORRECT.
Personal Day Off |  |  |  |  |  |  |  | EMPLOYEE: |  |  |  |  | DATE:
Initial for Pay ________ |  |  |  |  |  |  |  | SUPERVISOR: |  |  |  |  | DATE:
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 11969
2 | 11965
3 | 4507
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 447892.64
2001-09-22 00:00:00
CBS Volume
 |  |  | 50021
Spreadsheet: 478068d1472630800-avoiding-blanks-while-converting-a-range-to-a-single-column-convert-range-to-column
Sheet: RangeToColumn

C1A | C2 | [NAME] | [NAME] | C4 | [NAME] | C2 | C4 | C5 |  |  |  | C1A
 | C4 |  | C4A | C4 | C5 | C6 | [NAME] | C3A |  |  |  | C2
C1 |  | [NAME] | C2 | C4 | [NAME] | C4 | C2 | C3A |  |  |  | [NAME]
C2 | [NAME] | C4 | C1 | [NAME] |  | [NAME] |  |  |  |  |  | [NAME]
[NAME] | C5 | C6 | C7 | C8 | C4 | C4 | [NAME] | C2 |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C2
 | No. Of Rows | 5 |  |  |  |  |  |  |  |  |  | C4
 | No. Of Columns | 9 |  |  |  |  |  |  |  |  |  | C5
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | C4A
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | C5
 |  |  |  |  |  |  |  |  |  |  |  | C6
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C3A
 |  |  |  |  |  |  |  |  |  |  |  | C1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  | C3A
 |  |  |  |  |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | C1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C5
 |  |  |  |  |  |  |  |  |  |  |  | C6
 |  |  |  |  |  |  |  |  |  |  |  | C7
 |  |  |  |  |  |  |  |  |  |  |  | C8
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | C4
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | C2
Spreadsheet: 675872d1588530419-optimize-freight-distribution-by-priority-distance-and-mass-yield-freight-example-increased-complexity-
Sheet: DISTANCES (KM)

 | JOB 1 | JOB 2 | JOB 3 | JOB 4 | JOB 5 | JOB 6 | JOB 7 | JOB 8 | JOB 9 | JOB 10 | JOB 11 | JOB 12 | JOB 13 | JOB 14 | JOB 15 | JOB 16 | JOB 17 | JOB 18 | JOB 19 | JOB 20
JOB 1
JOB 2
JOB 3
JOB 4
JOB 5
JOB 6
JOB 7
JOB 8
JOB 9
JOB 10
JOB 11
JOB 12
JOB 13
JOB 14
JOB 15
JOB 16
JOB 17
JOB 18
JOB 19
JOB 20
Spreadsheet: 1942b07e-d70a-404d-933a-2b235d569f50
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  |  |  | LEED Online v2 Form Fix Log
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Materials Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Construction Cost
 |  |  |  | last updated: |  | 2011-12-05 00:00:00
 |  |  |  | The following issues have been addressed in LEED-Online v2 templates. This list will be periodically updated when fixed templates are deployed. Sample templates will not be revised at this time.  For all templates other than Core & Shell Precertification:
 |  |  |  | 1. | If no data has been saved in a template referenced on the following tabs, the new, revised template will appear by default when clicking "Download Template" within the credit page.
 |  |  |  | 2. | If data HAS been saved in a template referenced on the following tabs, and you wish to upgrade to a new template, click on the "Download Revised Template" link to the right of the template button. Please note that this action will result in the loss of all data that is saved in the current template.
 |  |  |  |  | Updated Core & Shell Precertification templates can be accessed here:
 |  |  |  |  | http://www.usgbc.org/DisplayPage.aspx?CMSPageID=2526
Spreadsheet: 753309d1635355347-excel-numbering-and-subnumbering-formula-function-auto-numbering-example
Sheet: Sheet1

 |  |  |  |  |  | Helper
 |  |  |  |  |  |  | = formula for main section
 | S/N | Family | Item | Color |  |  | = formula for subsection
 | 1.1.1 | Fruits | Orange | Orange |  |  | = formula for subsubsection
 | 1.2.1 | Fruits | [NAME] | Yellow
 | 1.3.1 | Fruits | Apple | Red |  |  | formula to be dragged down
 | 1.3.2 | Fruits | Apple | Yellow
 | 1.3.3 | Fruits | Apple | Green
 | 2.1.1 | Vegetables | [NAME] | Green
 | 2.2.1 | Vegetables | Tomato | Red
 | 2.2.2 | Vegetables | Tomato | Yellow
Spreadsheet: 85231d1285263349-auto-fill-based-on-other-sheet-autofill
Sheet: Sheet1

NAME | [NAME] |  |  |  | ID Number :
 |  |  |  |  | 1122
PROGRAM | Feb - May 2010 |  |  | LEVEL : | Intermediate 1
MONTH | COURSE (Rp) | COMP    (Rp) | BOOKS (Rp) | TOTAL   (Rp) | INVOICE | SIGNATURE
JUN | 920000 | 80000 | 40000 | 1040000 | 18941 |  | I can only make the first one to auto fill
JUL
AUG
SEP
PROGRAM | Oct - Jan 2011 |  |  | LEVEL : | Basic 1 |  | How to make the second until the end have auto fill when I enter ID Number? (in Turquoise color)
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
OCT | 920000 | 80000 | 40000 | 1040000 | 48941
NOV
DEC
JAN
PROGRAM | Feb - May 2011 |  |  | LEVEL : | Basic 2
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
FEB | 920000 | 80000 | 40000 | 1040000 | 12312
MAR
APR
MAY
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP    (Rp) | BOOKS (Rp) | TOTAL   (Rp) | INVOICE | SIGNATURE
JUN | 920000 | 80000 | 40000 | 1040000 | 36546
JUL
AUG
SEP
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
OCT
NOV
DEC
JAN
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
FEB
MAR
APR
MAY
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
JUN
JUL
AUG
SEP
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
OCT
NOV
DEC
JAN
PROGRAM |  |  |  | LEVEL :
MONTH | COURSE (Rp) | COMP (Rp) | BOOKS (Rp) | TOTAL (Rp) | INVOICE | SIGNATURE
FEB
MAR
APR
MAY
Spreadsheet: 32040d1228162484-one-cell-reading-from-different-locations-plus-minus-variables0112
Sheet: Sheet1

 |  |  | gradiant | 25
 |  |  |  |  |  |  |  |  | drop of blind |  |  |  | 1655
 |  |  | gradiant x 2 | 50 |  |  |  |  | minus headrail |  | 25
 |  |  |  |  |  |  |  |  | minus allowance for gear |  | 90
 |  |  |  |  |  |  |  |  | bottom bar |  | 40
 |  |  |  |  |  |  |  |  | take off |  | 155 |  | 1500 |  | 5.5
 |  | 2116 track | 25mm | Gradiant folds with Flaps |  |  |  |  |  |  |  | 3 | 272.7272727272727
 |  | gear drive | 90mm | i | ii | iii |  |  |  |  | 1 | 272.7272727272727 | 172.7272727272727 | 163.7272727272727
 |  | workable fabric 1500 mm | 1 | (272) -100 = | 172 - 9 = | 163 |  |  |  | minus above | 2 | 272.7272727272727 | 222.7272727272727 | 213.7272727272727
 |  |  | 2 | (272) - 50  = | 222 - 9 = | 213 |  |  |  | centre fold of blind | 3 | 272.7272727272727 | 272.7272727272727 | 263.7272727272727
 |  | take middle fold as datum | 3 | (272) ± 0 = | 272 - 9 = | 263 |  |  |  | plus below | 4 | 272.7272727272727 | 322.7272727272727 | 313.7272727272727
 |  |  | 4 | (272) + 50  = | 322 - 9 = | 313 |  |  |  |  | 5 | 272.7272727272727 | 372.7272727272727 | 363.7272727272727
finished drop of blind |  |  | 5 | (272) + 100 = | 372 - 9 = | 363
1655 mm |  |  | 1/2 flap | (136). | 186 | 182
 |  | 2004 bottom weight bar | 40mm
 |  |  |  | 1500 | 1546 | 1497
 | For example:- 1655[NAME] drop |  |  |  |  |  |  |  |  | 1/2 flaps |  | 136.3636363636364 | 186.3636363636364 | 181.8636363636364
i | 1655mm - 155mm = 1500[NAME] workable fabric
 | 25mm gradiant, 5 folds |  |  |  |  |  |  |  |  |  |  | 1500 | 1550 | 1500.5
 | 1500
 | 5.5  = | 272 mm rounded down to the nearest mm
ii | Adjust to form gradiant by adding or subtracting 2 x gradiant (50 mm) |  |  |  |  |  |  |  |  |  | stephen:
 | the new total is now 1546 mm but there is omly 1500 mm of workable fabric so there is a deficit of 46mm. |  |  |  |  |  |  |  |  |  | this value needs to change depending on how many flaps their are
 | 46 |  |  |  |  |  |  |  |  |  | at the moment  it shows 5 so it needs to read M14/2
 | 5.5 | spaces = 8.36 mm |  |  |  |  |  |  |  |  | If the flaps are increased or decreased it needs to read from M12, M16, the same goes for N19 and O19
 | Therefor adjust each space down by 9mm as in step iii.
 | The new Total will be 1497 mm and if you plan form the bottom it only increases the final top space by 3mm.
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 7b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 8280714 | 604809 | 2474021 | 2051461 | 371413 | 140446 | 242628 | 14165491
Fixed-Float | 75088792 | 64987532 | 12553244 | 19709096 | 5042414 | 4655786 | 12749719 | 194786584
FRA | 17865927 | 29223844 | 9582169 | 24252 | 259503 | 79610 | 4229165 | 61264470
OIS | 6395790 | 25462125 | 7001204 | 123551 | 1377614 | 1081170 | 823719 | 42265174
Swaption | 8165813 | 7555024 | 1395010 | 2304019 | 351572 | 21890 | 264747 | 20058076
OTHER* | 9808085 | 5830701 | 1141699 | 313756 | 131360 | 42696 | 231101 | 17499400
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 142908d1330084702-multiple-look-ups-index-and-match-trend-analysis-fredstyler
Sheet: Trends

 | 3
 | UK
 | FR
 | DE
 | US
 | IT
 | ES
 | AU
 | CN
 |  | Revenue | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | UK
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %
 | UK |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 116.781556682 | 95.19030925 | 47.852710576 | 67.983438385 | 56.209611739 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix % | 0.2 | 0.15 | 0.17 | 0.27 | 0.3
 |  | [NAME] | 0.3 | 0.25 | 0.4 | 0.33 | 0.34
 |  | [NAME] | 0.4 | 0.35 | 0.13 | 0.31 | 0.2
 |  | Melon Mix % | 0.1 | 0.25 | 0.3 | 0.09 | 0.16
 | FR |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 104.207648895 | 104.268260554 | 90.54533542 | 96.466926277 | 84.390973387 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix % | 0.3 | 0.3 | 0.27 | 0.17 | 0.2
 |  | [NAME] | 0.32 | 0.21 | 0.25 | 0.33 | 0.31
 |  | [NAME] | 0.22 | 0.33 | 0.3 | 0.3 | 0.29
 |  | Melon Mix % | 0.16 | 0.16 | 0.18 | 0.2 | 0.2
 | DE |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 102.248665901 | 101.656591889 | 85.920894485 | 97.956500572 | 90.351399408 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix % | 0.25 | 0.27 | 0.25 | 0.2 | 0.2
 |  | [NAME] | 0.25 | 0.2 | 0.35 | 0.31 | 0.29
 |  | [NAME] | 0.25 | 0.33 | 0.2 | 0.25 | 0.23
 |  | Melon Mix % | 0.25 | 0.2 | 0.2 | 0.24 | 0.28
 | US |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 94.029128524 | 98.303087015 | 80.255296014 | 97.738139724 | 93.114456105 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %
 | IT |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 74.143940353 | 76.619975575 | 44.508194795 | 87.791745329 | 108.030882778 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %
 | ES |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 93.637278863 | 81.205480066 | 78.077716445 | 87.600392203 | 102.815732113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %
 | AU |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 102.332691796 | 97.313446066 | 82.632092682 | 85.080690193 | 61.755286458 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %
 | CN |  | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  | Revenue | 93.791740943 | 99.67216016 | 85.781958704 | 89.98079517 | 108.625692017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Oragne Mix %
 |  | [NAME]
 |  | [NAME]
 |  | Melon Mix %