tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-9D

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-18 00:00:00
 |  |  | Monitoring Well #: | MW-9D |  |  |  | Well Depth: | 24.01 |  | ft |  |  | Screened/Open Interval: | 15-25' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 23 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 1 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 1005 | x |  | 7.61 | NA | 15.15 | NA | 114 | NA | 5.78 | NA | 51 | NA | 35.1 | NA | 340 | 1.87
 | 1010 | x |  | 7.59 |  | 15.26 |  | 116 |  | 5.7 |  | 50.5 |  | 30.4 |  | 340 | 2
 | 1015 | x |  | 7.52 |  | 15.46 |  | 127 |  | 5.43 |  | 41.7 |  | 28.3 |  | 280 | 1.9
 | 1020 | x |  | 7.42 |  | 15.34 |  | 315 |  | 4.08 |  | 35.1 |  | 11.9 |  | 280 | 1.85
 | 1025 | x |  | 7.4 |  | 15.4 |  | 335 |  | 3.83 |  | 32.9 |  | 9.31 |  | 280 | 1.8
 | 1030 | x |  | 7.37 |  | 15.36 |  | 428 |  | 3.23 |  | 35.3 |  | 6.91 |  | 280 | 1.78
 | 1035 | x |  | 7.37 |  | 15.38 |  | 434 |  | 3.16 |  | 33.3 |  | 6.72 |  | 280 | 1.7
 | 1040 | x |  | 7.34 |  | 15.34 |  | 441 |  | 2.96 |  | 34.7 |  | 6.52 |  | 280 | 1.67
 | 1045 | x |  | 7.34 |  | 15.36 |  | 449 |  | 2.84 |  | 35.1 |  | 6.34 |  | 280 | 1.67
 | 1050 |  | x | 7.34 |  | 15.38 |  | 453 |  | 2.82 |  | 36.2 |  | 4.77 |  | 280 | 1.66
 | Comments:
 |  | Purge start: |  |  | 10:01:00 |  |  | Sample time: |  | 10:47:00
 |  | Purge end: |  |  | 10:45:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 123830d1317891952-pivot-table-customizing-and-updating-kennybonesexample
Sheet: Summary

Name | [NAME]
ArtNr/Name | Amount | Price
1445 - Pants | 45 | 9405
1446 - Jacket | 41 | 16318
1447 - Winter jacket | 12 | 5460
1448 - Shoes | 32 | 4992
1449 - Winter Shoes | 10 | 4560
1450 - Hard hat | 21 | 4914
Totalt
Spreadsheet: 59470d1259958366-league-spreadsheet-exampleleaguespreadsheet2009
Sheet: Week 3 Preview

Week 3 Preview
 |  | average | Handicap |  |  |  | average | Handicap
Blue | bill | 300 | - | vs. | yellow | erin | 273 | 21.6
 | bob | 297 | - | vs. |  | [NAME] | 251.5 | 36.4
 | [NAME] | 282.5 | - | vs. |  | elwood | 246 | 29.2
red | ray | 300 | - | vs. | green | gary | 277.5 | 18
 | [NAME] | 276 | - | vs. |  | grendel | 256.5 | 15.6
 | ron | 252.5 | - | vs. |  | greg | 241.5 | 8.8
Standings
Red | 2
Blue | 3
Yellow | 1
Green | 0
Spreadsheet: 268399d1380620024-seperate-a-info-in-a-cell-with-formula-or-script-extnumbers
Sheet: Sheet1

This is a collumn given by the export i run from a system. So hard data and also the first "code" of the link in cell [NAME] with an additional space | This is a collumn given by the export i run from a system. So hard data and i want to remove the letters from it (if it contains any) and have the output in cell C7 | This is what the formula for me should do. So remove the letters and version (if it contains any)
[NAME] | Link | Without letters
5348 A | 5348A-5360E | 5348-5360
4360 A | 4360A-9067C | 4360-9067
10477 G | 5698-854 | 5698-854
4684 A | 4684A-9056A-3 | 4684-9056
11296 B | 28521-1066 | 28521-1066
9095 B | 9095B-11071Z-2 | 9095-11071
 | 0987b
Spreadsheet: 675871d1588530081-group-by-column-and-transpose-rows-as-columns-transpose
Sheet: Sheet1

WHAT I HAVE |  |  |  |  |  |  | 1st duplicate values |  |  |  |  | 2nd duplicate values
UserID | Plan | StartDate | CancelDate |  |  | UserID | Plan | StartDate | CancelDate |  |  | UserID | Plan | StartDate | CancelDate
1 | A | 2019-05-24 | 2019-06-20
1 | B | 2019-06-20 | 0000-00-00
2 | A | 2019-12-19 | 0000-00-00
2 | B | 2020-01-30 | 0000-00-00
3 | C | 2019-03-06 | 0000-00-00
3 | C | 2019-03-06 | 2019-11-28
WHAT I WANT
UserID | Plan | StartDate | CancelDate | Plan | StartDate | CancelDate
1 | A | 2019-05-24 | 2019-06-20 | B | 2019-06-20 | 0000-00-00
2 | A | 2019-12-19 | 0000-00-00 | B | 2020-01-30 | 0000-00-00
3 | C | 2019-03-06 | 0000-00-00 | C | 2019-03-06 | 2019-11-28
Spreadsheet: 155369d1336772092-link-excel-to-word-using-relative-links-test-excel-table-data
Sheet: Sheet1

Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 1fdb0121-1e97-4967-b4bb-e46705ca2b70
Sheet: Sheet1

Městský úřad Hodkovice nad [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Odbor správní  a sociální
pí [NAME]
nám. [NAME] 1
463 42 Hodkovice nad [NAME]
Registrace k místnímu poplatku za provozovaný výherní hrací přístroj
(VHP) technické herní zařízení  (THZ)
A. ÚDAJE O POPLATNÍKOVI
Název obchodní firmy
Sídlo
IČ
Číslo bankovního účtu
Název a sídlo banky
Osoba oprávněná [NAME]
B. ÚDAJE O VHP nebo THZ
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Název a evidenční číslo VHP nebo THZ
[NAME] nebo THZ
(název a přesná adresa provozovny)
Datum uvedení do provozu
Počáteční stavy mechanických počítadel |  |  | IN |  |  | OUT
Počáteční stavy elektromechanických počítadel |  |  | IN |  |  | OUT
Datum ukončení provozu
[NAME] stavy mechanických počítadel |  |  | IN |  |  | OUT
[NAME] stavy [NAME] počítadel |  |  | IN |  |  | OUT
Prohlašuji, že mnou uvedené údaje jsou pravdivé a úplné.
V ................................................
Dne:
 |  |  |  |  |  | ...............................................
 |  |  |  |  |  | razítko a podpis
Spreadsheet: 031780e8-163b-4501-88e5-231d89391a26
Sheet: chisq

Table S2A. Statistical comparison of disorder content using [NAME] tests.
 |  | chloroplast L>=30 |  |  | mitochondria L>=30 |  |  | nuclear L>=30 |  |  |  | expected values
 |  | total | %dis | disordered | total | %dis | disordered | total | %dis | disordered |  | cp | mt | nucl |  | chi(cp) | chi(mt) | chi(nucl)
Vascular plants
Eudicots/Rosids/Brassicales
Arabidopsis [NAME] |  | 87 | 9.19 | 8 | 117 | 19.49 | 23 | 22175 | 52.65 | 11675
Carica papaya |  | 84 | 7.06 | 6 |  |  |  | 22067 | 43.73 | 9650
Eudicots/Rosids/Fabales
Glycine max |  | 82 | 6.02 | 5 |  |  |  | 28530 | 53.28 | 15201
Eudicots/Rosids/Malpighiales
Populus trichocarpa |  | 100 | 10.89 | 11 |  |  |  | 38835 | 40.21 | 15616
Eudicots/Rosids/Vitales
Vitis vinifera |  | 86 | 4.6 | 4 | 74 | 14.67 | 11 | 30534 | 40.11 | 12247
Monocots
Oryza sativa |  | 108 | 7.41 | 8 | 53 | 18.52 | 10 | 38227 | 49.35 | 18865
Sorghum bicolor |  | 84 | 7.06 | 6 | 32 | 12.12 | 4 | 32219 | 50.79 | 16364
[NAME] mays |  | 99 | 6.31 | 6 | 164 | 17.57 | 29 | 22271 | 56.17 | 12510
Bryophyta |  |  |  |  |  |  |  |  |  |  |  | 5.81 | 6.98 | 38.23
Physcomitrella_patens |  | 85 | 5.81 | 5 | 42 | 6.98 | 3 | 34271 | 38.23 | 13102
[NAME]
Chlamydomonas reindhardtii |  | 69 | 12.86 | 9 | 14 | 6.67 | 1 | 13201 | 45.42 | 5996
Micromonas sp RCC299 |  | 56 | 1.75 | 1 | 38 | 10.25 | 4 | 8989 | 52.91 | 4756
Ostreococcus tauri |  | 60 | 4.92 | 3 | 42 | 2.32 | 1 | 7396 | 52.52 | 3884
Spreadsheet: 889941d1741004309-automated-log-maintenance-log
Sheet: Lists

List 1 |  | List 2 |  | List 3 |  |  |  | Criticality
Staff |  | [NAME] |  | Electrical | Plumbing | Heating |  | Level of Urgencey
[NAME] |  | Electrical |  | Mr.[NAME] | Wet Drips | Make Me Warm |  | 1
[NAME] |  | Plumbing |  | Plugs R Us | Soaky Floor | Cold Outside |  | 2
Rachel |  | Heating |  | [NAME] | Drip Slip | Joes heaters |  | 3
Zoe |  | Carpentry |  |  |  |  |  | 4
Lexxie |  | Buildingworks |  |  |  |  |  | 5
[NAME] |  | Social
[NAME] |  | Financial
Spreadsheet: 92108d1291767907-summarizing-cost-data-from-list-by-unit-excel-example
Sheet: Sheet1

2011 Tractor Scorecard
 |  |  |  | VIN # |  |  |  |  |  |  |  |  |  |  |  | Tractor #
 |  |  |  | Make |  |  |  |  |  |  |  |  |  |  |  | C11013
 |  |  |  | Axles
KPM |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | YTD
Internal Labor Cost |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
External Labor Cost |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Parts Cost |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Tires Cost |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Cost |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Cost Per Mile |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
Miles Per Gallon |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
PM Completed
Spreadsheet: 154130d1336229682-display-string-according-to-specified-date-without-repetition-help-please_solution
Sheet: Sheet1

Start Date | 2012-01-01 00:00:00 |  | Sum of Amount |  |  |  | Sum of Amount
End Date | 2012-01-30 00:00:00 |  | Date | Client name | Total |  | Date | Client name | Total
 |  |  | Jan | ABC | 1500 |  | Jan | ABC | 1500
 |  |  |  | LMN | 600 |  |  | LMN | 600
 |  |  |  | XYZ | 900 |  |  | XYZ | 900
 |  |  | Jan Total |  | 3000 |  | Jan Total |  | 3000
Client | total amount |  | Grand Total |  | 3000 |  | Grand Total |  | 3000
ABC
Spreadsheet: 76345d1276853310-sort-data-numerically-whilst-ignoring-preceding-letters-book1
Sheet: Sheet1

A .......................B (results) ........... C
[NAME] ............1 .........................A??X
[NAME].................0 ........................GE?RG?
[NAME]............2..........................R?BERT
ALEX..................1..........................CH???S
......................................................?EORGE
 | [NAME] |  | 5 | A??X
 | CHRIS |  | 4 | GE?RG?
 | GEORGE |  | 3 | R?BERT
 | ALEX |  | 2 | CH???S
 |  |  |  | ?EORGE
Spreadsheet: 482634d1475164844-lookup-function-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W1 | 100 | P (white win)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 100 | P (black win)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | q | 0.5514124293785311 | P (draw)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lambda | 1.5 | Pw+Pd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2 | 50
 | x1 (Nash)
 | x2 (Nash)
 | Key |  |  |  |  |  |  |  |  | overall | win | draw | lose
 | expected payoff of P1 |  |  | expected payoff of P2 |  |  |  | what I get
 | value win for P1 |  |  | value win for P2 |  |  |  | what it should be |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 | P2
 | x* of P1 |  |  | x* of P2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | exp. Payoff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value win | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 is white
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | exp. Payoff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value win
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x*
 |  |  |  |  |  |  |  |  |  |  |  | P1 is black
 |  |  |  |  |  |  |  |  |  |  |  | exp. Payoff
 |  |  |  |  |  |  |  |  |  |  |  | value win
 |  |  |  |  |  |  |  |  |  |  |  | x*
 |  |  |  | P1 is white
 |  |  |  | exp. Payoff
 |  |  |  | value win
 |  |  |  | x*
 | P1 is black
 | exp. Payoff
 | value win
 | x*
Spreadsheet: 85a0990f-0da6-4d34-a31b-61b5b04d7a6b
Sheet: Sheet1

University of Idaho | Unnamed: 1 | Departmental Transfer Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Records Management Office
Student Union Building, Room 53
Moscow, ID  83844-4247
Phone (208) 885-2580
Full Name (Print): |  | E-mail: |  | Telephone Number: |  | Date:
Department Name: |  | Authorization Signature:
Box Information
Department Reference Name/Number |  |  |  | Comments:
Box Accession Number: |  | Set Number:
Records Series Information
Series Title |  | Start Date | End Date | Series Number | Retention Period | Disposition Date
Records Center Officer Signature: |  |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 23592 | 24000
2 |  |  | 24358 | 24000
3 |  |  | 24506 | 24000
4 |  |  | 24638 | 24000
5 |  |  | 24617 | 24000
6 |  |  | 24627 | 24000
7 |  |  | 24565 | 24000
8 |  |  | 24616 | 24000
9 |  |  | 24626 | 24000
10 |  |  | 24629 | 24000
11 |  |  | 24633 | 24000
12 |  |  | 23307 | 24000
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183022 | -128597
2001-12-31 00:00:00 | Balance | -1033420.01 |  | -571850.34
2002-01-12 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1164285.8 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -152764
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 166969d1341855952-vlookup-or-reference-problems-number-refrence
Sheet: Sheet1

Date: |  |  |  |  |  |  | MLR: |  |  |  |  |  |  | Rush Team:
80 | 81 | 82 | 83 | 93 | 94 |  | 84 | 85 | 86 | 77 | 78 | 79 |  | 87 | 88 | 89 | 90 | 91 | 92 |  | 95 | 96 | 97 | 98 | 99 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
Spreadsheet: 707384d1607241522-cell-reference-instead-hard-coded-values-example
Sheet: fdfd

Investment | Maturity | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | Total | Rate of profit
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
Spreadsheet: 746706d1630960829-help-creating-dynamic-drop-down-list-region_area
Sheet: Dropdown

Region |  | Region | Yorkshire and the Humber
North East |  | Area | North Lincolnshire
North West
Yorkshire and the Humber
East Midlands
West Midlands
East of England
London
South East
South West
North East | North West | Yorkshire and [NAME] | East Midlands | West Midlands | East of England | London | South East | South West
Hartlepool | Halton | Kingston upon Hull | Derby | Herefordshire | Peterborough | City of London | Medway | Bath and North East Somerset
Middlesbrough | Warrington | East Riding of [NAME] | Leicester | Telford and [NAME] | Luton | Barking and [NAME] | Bracknell Forest | Bristol
Redcar and Cleveland | [NAME] with [NAME] | North East Lincolnshire | Rutland | Stoke-on-Trent | Southend-on-Sea | Barnet | West Berkshire | North Somerset
Stockton-on-Tees | Blackpool | North Lincolnshire | [NAME] | Shropshire | Thurrock | Bexley | Reading | South Gloucestershire
Darlington | Cheshire East | York | Derbyshire | Birmingham | Bedford | Brent | Slough | Plymouth
[NAME] | Cheshire West and [NAME] | Barnsley | Leicestershire | Coventry | Central Bedfordshire | Bromley | Windsor and Maidenhead | [NAME]
Northumberland | [NAME] | Doncaster | Lincolnshire | [NAME] | Cambridgeshire | Camden | Wokingham | Swindon
Newcastle upon Tyne | Bury | Rotherham | Northamptonshire | Sandwell | Essex | Croydon | [NAME] | Cornwall
North Tyneside | [NAME] | Sheffield | Nottinghamshire | Solihull | Hertfordshire | Ealing | [NAME] and Hove | Isles of Scilly
South Tyneside | Oldham | Bradford |  | Walsall | Norfolk | Enfield | Portsmouth | Wiltshire
Sunderland | Rochdale | Calderdale |  | Wolverhampton | Suffolk | Greenwich | Southampton | Bournemouth, Christchurch and Poole
Gateshead | Salford | Kirklees |  | Staffordshire |  | Hackney | Isle of Wight | Dorset
 | Stockport | Leeds |  | Warwickshire |  | Hammersmith and Fulham | [NAME] | [NAME]
 | Tameside | Wakefield |  | [NAME] |  | Haringey | East Sussex | Gloucestershire
 | Trafford | [NAME] |  |  |  | [NAME] | Hampshire | Somerset
 | [NAME] |  |  |  |  | Havering | Kent
 | [NAME] |  |  |  |  | [NAME] | Oxfordshire
 | Liverpool |  |  |  |  | Hounslow | [NAME]
 | St. Helens |  |  |  |  | Islington | West Sussex
 | Sefton |  |  |  |  | Kensington and Chelsea
 | Wirral |  |  |  |  | Kingston upon Thames
 | Cumbria |  |  |  |  | [NAME]
 | Lancashire |  |  |  |  | Lewisham
 |  |  |  |  |  | Merton
 |  |  |  |  |  | Newham
 |  |  |  |  |  | Redbridge
 |  |  |  |  |  | Richmond upon Thames
 |  |  |  |  |  | Southwark
 |  |  |  |  |  | Sutton
 |  |  |  |  |  | Tower Hamlets
 |  |  |  |  |  | Waltham Forest
 |  |  |  |  |  | Wandsworth
 |  |  |  |  |  | Westminster
Spreadsheet: 146706d1332323706-sum-if-on-named-cells-sample
Sheet: Input - Data

 | Project Base Data - Information
 | Project Name
 | Project Code - once available
 | Project Period
 | Start Date of Project
 | [NAME]
 | Programme Manager - if applicable
 | Project Manager
 | Phases in the Project |  |  |  | Phase Period
 | Phase 1 |  | Preparation |  | Jan 2012 - March 2012
 | Phase 2 |  | Design |  | April 2012 - May 2012
 | Phase 3 |  | Pre-Implementation |  | June 2012 - July 2012
 | Phase 4 |  | Implementation |  | August 2012 - December 2012
 | Phase 5 |  | Operation/Use |  | Jan 2013 onwards
Spreadsheet: 605256d1547012227-match-item-with-invoice-and-replace-any-missing-item-auto-masterfile18-19
Sheet: Inv-DATA

Sales Tax Record
Inv + Item | Item Code | Inv No | Descp | Qty | SS.No | KIP-No
0010033MD-LA6EBU35 | MD-LA6EBU35 | 0010033 | RED CRESENT HOSPT | 1 | 43287
0010033MD-NCEUP3020 | MD-NCEUP3020 | 0010033 | RED CRESENT HOSPT | 1 | 43287
0010033MD-RINT30018 | MD-RINT30018 | 0010033 | RED CRESENT HOSPT | 1 | 43287
0010033MD-SPL20015X | MD-SPL20015X | 0010033 | RED CRESENT HOSPT | 1 | 43287
0010038MD-5392 | MD-5392 | 0010038 | MEDI SYSTEMS INTE | 1 | 43291
0010038MD-5433A | MD-5433A | 0010038 | MEDI SYSTEMS INTE | 1 | 43291
0010038MD-5433A | MD-5433A | 0010038 | MEDI SYSTEMS INTE | 1 | 43291
0010038MD-SPL12506X | MD-SPL12506X | 0010038 | MEDI SYSTEMS INTE | 8 | 43291
0010038MD-SPL12510X | MD-SPL12510X | 0010038 | MEDI SYSTEMS INTE | 1 | 43291
0010038MD-SPL15010X | MD-SPL15010X | 0010038 | MEDI SYSTEMS INTE | 1 | 43291
[NAME] | MD-SPL20010X | 0010038 | MEDI SYSTEMS INTE | 6 | 43291
0010038MD-SPL20015X | MD-SPL20015X | 0010038 | MEDI SYSTEMS INTE | 10 | 43291
0010041MD-REDRO1/45 | MD-REDRO1/45 | 0010041 | PESHAWAR INSTITUT | 3 | 43292
0010041MD-RESRO1 | MD-RESRO1 | 0010041 | PESHAWAR INSTITUT | 5 | 43292
0010043MD-REDRO1/45 | MD-REDRO1/45 | 0010043 | NATIONAL INSTITUT | 75 | 43293
0010044MD-DTBC2QQ/6 | MD-DTBC2QQ/6 | 0010044 | NATIONAL INSTITUT | 25 | 43293
0010055MD-500DM27 | MD-500DM27 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-505DA18 | MD-505DA18 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-505DA22 | MD-505DA22 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ENSP27518 | MD-ENSP27518 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX25015 | MD-ONYX25015 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX25026 | MD-ONYX25026 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX27518 | MD-ONYX27518 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX30012 | MD-ONYX30012 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX30022 | MD-ONYX30022 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX30026 | MD-ONYX30026 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX30030 | MD-ONYX30030 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX35026 | MD-ONYX35026 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX35030 | MD-ONYX35030 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-ONYX35038 | MD-ONYX35038 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-RINT30030 | MD-RINT30030 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-RINT30038 | MD-RINT30038 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-SESRO1 | MD-SESRO1 | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-SPL15015X | MD-SPL15015X | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293
0010055MD-SPL20020X | MD-SPL20020X | 0010055 | AZIZ TABBA FOUNDA | 1 | 43293