tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770091d1645806461-create-counting-list-of-numbers-based-on-a-specific-value-book1
Sheet: Sheet1

 |  |  |  | 13 | Cats | 0
 |  |  |  | 14 | Dogs
 |  |  |  | 10 | Monkeys
 |  |  |  | 13 | Camels
 |  |  |  | 14 | Lions
 |  |  |  | 15 | Elelphants
Spreadsheet: 159797d1338847056-vlookup-on-another-sheet-cerca-2-oeldere2-
Sheet: Foglio2

 |  |  | 2012-05-01 00:00:00 | 1
MATTINA=  MORNING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helpcollomn
ADDETTI | Cod. turno | Turno | Straordinario | FERIE | [NAME] |  |  |  |  | By changing the date in E1, must enter their data in the columns ABF from sheet1 automatically.  The column C, I set myself.  The column D and E do not need  Only formulas thanks for your help
MANUELA | R | Riposo |  |  | MANUELA |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
EVELINA | 32 | 06.00-14.00 |  |  | FRANCESCO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
SERENA | 43 |  |  |  | MARIA |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
GIOVANNI | 42 |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
LORENZO | 35 | 08.00-16.00 |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
GIACOMO | 530 | 05.30-11.30 |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1
FRANCESCO | R | Riposo |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
PAOLA | 31 |  |  |  |  |  | 530 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
DALILA | 56 | 05.00-13.00 |  |  |  |  | 532 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
VALENTINA | 51 |  |  |  |  |  | 539 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
ANNA | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2
MARIA | R | Riposo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R3
POMERIGGIO= AFTERNOON
ADDETTI | Cod. turno | Turno | Straordinario | MALATTIA
SERENA | 43 | 15.00-23.00 |  |  |  |  | P
GIOVANNI | 42 | 13.30-21.30
PAOLA | 31 | 22.00-06.00 |  |  |  |  | 43
VALENTINA | 51 | 15.30-23.30 |  |  |  |  | 34
ANNA | 34 | 14.00-22.00 |  |  |  |  | 51
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 551
 |  |  |  |  |  |  | 545
 |  |  |  |  |  |  | 544
Spreadsheet: 170941d1343527087-populate-matrix-using-database-information-accounting
Sheet: Accounting

Prices Charged(old) |  |  |  |  |  |  | Cost of Photos |  |  |  |  |  |  | [NAME] Cost |  |  |  |  |  |  | Print sizes
Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package
15 min | 15 min | 45 min | 15 min | 15 min | 30 min |  |  |  |  |  |  |  | Profit Multiplier | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 | 2.25
6 | 35 | 35 | 77 | 42 | 30 |  | 1.15 | 16.55 | 12.33 |  | 33 |  |  |  |  |  |  |  |  |  | 4x6 | 8x10 |  |  | 11x14
5 | 48 | 45 | 77 | 65 | 50 |  | 1.72 | 38.25 | 25 | 22 | 42 |  |  |  |  |  |  |  |  |  | 5x7 | 10x20 |  | 11x14 | 10x20
8 | 64 | 65 | 105 | 75 | 100 |  | 2.84 |  | 23.39 | 28 | 56 |  |  |  |  |  |  |  |  |  | 8x10 |  |  | 16x20 | 16x20
12 | 112 | 75 | 110 | 85 | 175 |  | 10.67 | 25.4 | 33.39 | 45 | 68 |  |  |  |  |  |  |  |  |  | 11x14 | 11x14 |  | 24x30 | 20x24
29 | 128 | 150 | 165 | 110 |  |  | 27 | 43.85 | 49.07 |  |  |  |  |  |  |  |  |  |  |  | 16x20 | 16x20
49 | 166 |  |  |  |  |  | 24.35 | 66.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20x20
 |  |  |  |  |  | Print Shop | CPQ | WHCC | CPQ/WHCC |  | CPQ
 |  |  |  |  |  |  | Memory Box | 45 | Mounted Proof | 3.89 | 8 Wallets | 2
 |  |  |  |  |  |  | Digital File | 20 | [NAME] | 2.84 | iPhone Cover | 15
 |  |  |  |  |  |  | Proof Book | 14 | Quad | 51.96 | Accord. Album | 28
Target Salary/yr |  | 20000 | 40000 |  |  |  |  |  |  |  |  |  |  | Recommended Photo Prices |  |  |  |  |  |  | Difference
Hrs/week worked |  | 20 | 15 | 30 |  |  |  |  |  |  |  |  |  | $40k/30hr
Total Hrs/yr |  |  |  |  |  |  |  |  | Conference Recommended Multiplier |  |  |  |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package
 |  |  |  |  | 45 min | 30 min | 15 min |  | From Home | Own Studio
Hourly rate @ 20 hrs/week & $20,000/yr |  |  |  |  |  |  |  |  | 3 | 4
Hourly rate @ 20 hrs/week & $40,000/yr
Hourly rate @ 30 hrs/week & $40,000/yr
Hourly rate @ 15 hrs/week & $20,000/yr
[NAME] |  |  |  |  |  |  | Difference |  |  |  |  |  |  | Recommended Photo Prices incl tax
$20k/20hr |  |  |  |  |  |  |  |  |  |  |  |  |  | $40k/30hr
Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package
No multiplier Cost |  |  |  |  |  |  | Difference
$20k/20hr
Print Prices | [NAME] | Story Board | Canvas | Wrap | Package |  | Print Prices | [NAME] | Story Board | Canvas | Wrap | Package
Spreadsheet: 867322d1714142803-looking-for-shortcut-to-put-all-tab-names-on-one-tab-plus-data-template-completed
Sheet: Company Name 7

 |  |  |  |  |  | Company Name 7
 |  | Month ending
 |  | Enter month
 | Date | Invoice number | Total | Materials | Labour | Tax | [NAME] | Payable
 | 2024-04-26 00:00:00 | 4552 | 524
 |  | Totals
[NAME]
Company No. 06977736
Spreadsheet: larry_campbell__21575__SOCOgen2001
Sheet: NOVEMBER

INTO SOCO GENERATION
2001-11-01 00:00:00
MW | TERM | SOURCE | DATE
50 | PEAK | SCEGGEN-SCEGW-SCEG-DYPMI | 2001-11-01 00:00:00
50 | PEAK | DUKEG-DUKEW-DETM-SEMPRA-DYMPI | 2001-11-01 00:00:00
50 | PEAK | DUKEG-DUKEW-DUKE-CARGILL-DYMPI-MIRANT | 2001-11-01 00:00:00
50 | OFF | AECIG-AECIW-AECI-CARGILL-TVAW | 2001-11-01 00:00:00
50 | PEAK | DUKG-DETM-DUKW-DETM-CARGILL | 2001-11-02 00:00:00
50 | PEAK | SCEGG-SCEG-SCEGW-SCEG--DYPMI | 2001-11-02 00:00:00
50 | OFF | LGEG-LGE--LGEW-LGE-CARGILL-TVAW-CARGILL-DYPMI | 2001-11-02 00:00:00
50 | OFF | SCEGG-SCEGW-SCEG | 2001-11-03 00:00:00
50 | OFF | SCEGG-SCEGW-SCEG | 2001-11-03 00:00:00
50 | OFF | SCEGG-SCEGW-SCEG | 2001-11-04 00:00:00
50 | OFF | SCEGG-SCEGW-SCEG | 2001-11-04 00:00:00
50 | PEAK | SCEGG-SCEGW-SCEG-DYPMI | 2001-11-05 00:00:00
50 | OFF | MIZZ RIVER GEN-CARGILL-MAPPW-AMRNW-TVAW-CARGILL | 2001-11-05 00:00:00
50 | PEAK | GASTONGEN-SOCO-DYPMI | 2001-11-06 00:00:00
50 | OFF | EEI-DYPMI-TVAW-DYPMI- | 2001-11-06 00:00:00
50 | PEAK | MILLERGEN-SOCO-MIRANT-DYPM | 2001-11-07 00:00:00
50 | PEAK | [NAME] | 2001-11-07 00:00:00
50 | PEAK | MILLERGEN-SOCO-DYPM | 2001-11-07 00:00:00
50 | OFF | AECIG-AECIW-AECI-CARGILL-TVAW | 2001-11-07 00:00:00
50 | PEAK | GASTON-DYPMI | 2001-11-08 00:00:00
50 | PEAK | SCHERE-DYPMI | 2001-11-08 00:00:00
2 | PEAK | BRANCH-DYPM-MIR | 2001-11-08 00:00:00
2 | PEAK | BOWEN-DYPM-MIR | 2001-11-08 00:00:00
2 | PEAK | SCHERE-DYPM-MIR | 2001-11-08 00:00:00
2 | PEAK | [NAME] | 2001-11-08 00:00:00
2 | PEAK | GASTON-DYPM-MIR | 2001-11-08 00:00:00
50 | PEAK | BOWEN-DYPM-SCEG | 2001-11-08 00:00:00
50 | OFF | AECIGEN-AECIW-CARGILL-TVAW-CARGILL | 2001-11-08 00:00:00
Spreadsheet: 163990d1340592599-count-number-of-repeat-stays-repeat2-1-
Sheet: Sheet1

 |  |  | No. Of Repeat Stay in the Hotel |  |  |  | Desired Outcome:  1. a function to count the no. of members who have stayed in year 2010 and 2011/ year 2010,2011,2012 based on their tier membership 2. Count of Resort with the most no. of repeat stay per year - format: Resort Name and no. of count
Membership No. | Membership | Resort | 2010 | 2011 | 2012
5866 | Gold | BKK | 2 | 2
1292 | Red | BKK | 1 | 3 | 1
5623 | Platinum | MNL |  | 4 | 2
3235 | Gold | PVG | 1 | 2 |  |  | No. of Members with [NAME] in year 2010 & 2011
1231 | Black | BKK | 2 | 3 | 2
3232 | Black | DPS |  | 2 | 2
2235 | Platinum | CGK | 1 | 2 |  |  | Members with [NAME] in year 2010 & 2011 per Tier
1289 | Gold | MNL | 2 | 3 | 2 |  | Gold
3265 | Black | MNL |  | 2 | 2 |  | Platinum
3235 | Gold | BKK | 1 | 2 |  |  | Black
1231 | Gold | MNL | 2 | 3 | 2 |  | Red
3265 | Red | PVG |  | 2 | 2
3235 | Platinum | DPS | 1 | 2 |  |  | No. of Members with [NAME] in year 2010, 2011,2012
1231 | Red | MNL | 2 | 3 | 2
 |  |  |  |  |  |  | Members with [NAME] in year 2010,2011,2012 per Tier
 |  |  |  |  |  |  | Gold
 |  |  |  |  |  |  | Platinum
 |  |  |  |  |  |  | Black
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Resort with Most no. of repeat stay per year
 |  |  |  |  |  |  |  | Resort | Count
 |  |  |  |  |  |  | 2010
 |  |  |  |  |  |  | 2011
 |  |  |  |  |  |  | 2012
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Jayne 57

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-09-17 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-09-17 00:00:00
Spreadsheet: 786863d1657518991-formula-to-find-the-multiple-values-and-consolidate-in-new-row-consolidatemultiplelines
Sheet: Expected Result

 |  |  | ExpectedResult | [NAME]
Chars. | Task | Value | NewCol.
SKA1 | AA | TK01
SKA1 | BB | TE22
SKA1 | CC | VK10
SKA1 | DD | AS11 | AS11, AS26
SKA1 | DD | AS26 | AS11, AS26
SKA1 | EE | BA01
SKA1 | FF | BA02
SKA1 | GG | 122 | 122, 340, 520, 540
SKA1 | GG | 340 | 122, 340, 520, 540
SKA1 | GG | 520 | 122, 340, 520, 540
SKA1 | GG | 540 | 122, 340, 520, 540
SKA1 | HH
SKA1 | II
SKA1 | JJ
SKA1 | KK
SKA1 | LL
SKA1 | MM
SKA1 | NN
SKA1 | OO
SKA1 | PP
SKA1 | QQ
SKA1 | RR
SKA1 | SS
SKA1 | TT
SKA1 | UU
[NAME] | DD | AS22 | AS22, AS54,, AS59
[NAME] | DD | AS54 | AS22, AS54,, AS59
[NAME] | DD | AS59 | AS22, AS54,, AS59
[NAME] | EE
[NAME] | FF
[NAME] | GG | 220 | 220, 260
[NAME] | GG | 260 | 220, 260
[NAME] | HH
[NAME] | II
[NAME] | JJ
[NAME] | KK
[NAME] | LL
SKT2 | DD | AS19 | AS19
SKT2 | EE
SKT2 | FF
SKT2 | GG | 740 | 740
SKT2 | HH
SKT2 | II
SKT2 | JJ
SKT2 | KK
SKT2 | LL
Spreadsheet: 701623d1603857958-index-match-formula-problem-sample
Sheet: BOM

 | Code | PART NO | Item | Cost/unit | Qty | COST
 | Pre-delivery (CMV)
 | 100 | 70l | LABOUR  (16 HRS) | 137.5 | 16 |  |  |  |  | PART NO | BOM CODE | COST | TOTAL COST
 | 101 | SPGB01000LTR | ADBLUE (40 L) | 0.62 | 40 |  |  |  |  |  | 110
 | 101 |  | DIESEL (100 L) | 1.3 | 100
 | 102 | SPCT16C | Cable ties 368X7.6 MM (14) | 0.3 | 14
 | 102 | KW82524 | Suzi coil 7 Core 4.6M 4MM (1) | 77.11 | 1
 | Fire ex/air blower in cab (1.5 kg)
 | 110 | SPFC15ABE | Fire 1.5kg ABE | 34.38 | 1
 | 110 | SP5X16MG304PCRMT | G304 PAN CR MTS M5X16 (2) | 0.22 | 2
 | 110 | SP5MG304NYLN | G304 NYLOC NUT STD M5 (2) | 0.08 | 2
 | 110 | SP5X10X08MG304W | G304 WASHER M5X10X.08 (4) | 0.03 | 4
 | 110 | SP13CABH0SE | DUSTBLOWER | 26.85 | 1
 | 110 | SP371864X4 | 1/4 TUBE FEE | 10.08 | 1
 | 110 | 70l | LABOUR (1 HR) | 137.5 | 1
 | Fire ex/air blower in cab (2.5 kg) with vehicle brackets
 | 111 | SPFP25ABE | FIRE 2.5KG ABE WITH VEHICLE BRACKET | 48.13 | 1
 | 111 | SP13CABH0SE | DUSTBLOWER | 26.85 | 1
 | 111 | SP371864X4 | 1/4 TUBE FEE | 10.08 | 1
 | 111 | SP5X16MG304PCRMT | G304 PAN CR MTS M5X16 (2) | 0.22 | 2
 | 111 | SP5MG304NYLN | G304 NYLOC NUT STD M5 (2) | 0.08 | 2
 | 111 | SP5X10X08MG304W | G304 WASHER M5X10X.08 (4) | 0.03 | 4
 | 111 | 70l | LABOUR (1HR) | 137.5 | 1
Spreadsheet: cba91827-f32d-4cd3-8fd6-4c48c0549830
Sheet: Inputs

Timestamp
 |  | Inputs
 |  | Silver Price 2009 |  | 12
 |  | Silver price 2010 |  | 20
 |  | Silver Price 2011 |  | 28
 |  | Silver Pirce 2012 |  | 40
 |  | Silver Price 2013 |  | 38
 |  | Silver Price 2014-2015 |  | 35
 |  | Silver Price (Terminal) |  | 22
 |  | [NAME] |  | 0.06
 |  | Total Resources |  | 1160000
 |  | Current Reserves |  | 609000
 |  | Net Measured/Inferred Reserves
 |  | Reserve Multiple |  | 0.5
 |  | Resource Multiple |  | 0.1
 |  | Fully Diluted Shares |  | 329000
 |  | Net Debt |  | -239000
 |  | Tax Rate |  | 0.1
Spreadsheet: 792903d1661210678-summary-of-employee-data-for-meeting-of-quota-analysis-excelforumexample
Sheet: DataValidation

Employees | Hours Paid | Pay Period Ending
Emp1 | 80 | 2022-08-13 00:00:00
Emp2 | 80
Emp3 | 80
Emp4 | 80
Emp5 | 80
Emp6 | 80
Emp7 | 80
[NAME] | 80
Emp9 | 80
Emp10 | 80
Emp11 | 80
Emp12 | 80
Emp13 | 64
Emp14 | 80
Emp15 | 80
Emp16 | 80
Emp17 | 80
Emp18 | 80
Emp19 | 80
Emp20 | 80
Emp21 | 80
Emp22 | 80
Emp23 | 80
Emp24 | 80
Emp25 | 80
Emp26 | 80
Emp27 | 80
Emp28 | 80
Emp29 | 80
Emp30 | 80
Emp31 | 80
Emp32 | 80
Emp33 | 80
Emp34 | 48
Emp35 | 72
Emp36 | 80
Emp37 | 80
Emp38 | 80
Spreadsheet: 579039d1529651824-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1st-column-579037d1529650424-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1
Sheet: MasterList

Product | Region | Sales |  | <<< Master/Full list
Dynamic Heavy | East | 202
Dynamic Heavy | North | 202 |  |  |  |  |  |  |  |  |  |  |  | for dropdown:
Dynamic Heavy | South | 238 |  |  |  |  |  |  |  |  |  |  |  | Region
Dynamic Heavy | West | 250 |  |  |  |  |  |  |  |  |  |  |  | East
Dynamic Light | East | 220 |  |  |  |  |  |  |  |  |  |  |  | North
Dynamic Light | North | 203 |  |  |  |  |  |  |  |  |  |  |  | South
Dynamic Light | South | 243 |  |  |  |  |  |  |  |  |  |  |  | West
Dynamic Light | West | 206
Dynamic Medium | East | 216
Dynamic Medium | North | 248
Dynamic Medium | South | 250
Dynamic Medium | West | 238
Laser Heavy | East | 226
Laser Heavy | North | 238
Laser Heavy | South | 243
Laser Heavy | West | 225
Laser Light | East | 225
Laser Light | North | 235
Laser Light | South | 223
Laser Light | West | 242
Laser Medium | East | 215
Laser Medium | North | 235
Laser Medium | South | 244
Laser Medium | West | 245
Light [NAME] | East | 217
Light [NAME] | North | 216
Light [NAME] | South | 225
Light [NAME] | West | 236
Light [NAME] | East | 219
Light [NAME] | North | 223
Light [NAME] | South | 227
Light [NAME] | West | 207
Light Milli | East | 238
Light Milli | North | 233
Light Milli | South | 239
Light Milli | West | 211
Spreadsheet: 871176d1717583935-add-a-row-before-a-group-of-values-book11
Sheet: Sheet1

 |  |  |  |  | 4
 | Region | Employee |  | Product |  |  |  | REGIONS | EMP | PRO-1 | PRO-2 | PRO-3 | PRO-4
 | Region-1 | EMP-1 |  | PRO-1 |  |  | Central Region | Region-1 | 6 | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667
 | Region-1 | EMP-2 |  | PRO-2 |  |  | Sub Total Central Region | 1 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Region-1 | EMP-3 |  | PRO-4 |  |  | Eastern Region | [NAME] | 4 | 0 | 0.5 | 0.5 | 0
 | Region-1 | EMP-4 |  | PRO-2 |  |  | Eastern Region | Region-4 | 4 | 0 | 0.5 | 0.5 | 0
 | Region-1 | EMP-5 |  | PRO-1 |  |  | Eastern Region | [NAME] | 1 | 1 | 0 | 0 | 0
 | Region-1 | [NAME] |  | PRO-2 |  |  | Sub Total Eastern Region | 3 | #N/A | #N/A | #N/A | #N/A | #N/A
 | [NAME] | EMP-1 |  | PRO-3 |  |  | Western Region | Region-6 | 4 | 0.25 | 0.25 | 0.5 | 0
 | [NAME] | EMP-2 |  | PRO-2 |  |  | Western Region | Region-5 | 3 | 0.3333333333333333 | 0 | 0.6666666666666666 | 0
 | [NAME] | EMP-3 |  | PRO-3 |  |  | Western Region | Region-3 | 8 | 0.375 | 0 | 0.625 | 0
 | [NAME] | EMP-4 |  | PRO-2 |  |  | Sub Total Western Region | 3 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Region-4 | EMP-1 |  | PRO-3 |  |  | Total EMPs | 7 | 30 | 8 | 8 | 13 | 1
 | Region-4 | EMP-2 |  | PRO-2 |  |  | % Share | - | - | 0.2666666666666667 | 0.2666666666666667 | 0.4333333333333333 | 0.03333333333333333
 | Region-4 | EMP-3 |  | PRO-3
 | Region-4 | EMP-4 |  | PRO-2
 | Region-6 | EMP-1 |  | PRO-3 |  |  | Location | REGIONS | EMP | PRO-1 | PRO-2 | PRO-3 | PRO-4
 | Region-6 | EMP-2 |  | PRO-1 |  |  | Central Region | Region-1 | 6 | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667 | 2 | 3 | 0 | 1
 | Region-6 | EMP-3 |  | PRO-3 |  |  | Sub Total Central Region | 1 | 6 |  |  |  |  | 2 | 3 | 0 | 1
 | Region-6 | EMP-4 |  | PRO-2 |  |  | Eastern Region | [NAME] | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 2 | 2 | 0
 | Region-5 | EMP-1 |  | PRO-1 |  |  | Eastern Region | Region-4 | 4 | 0 | 0.5 | 0.5 | 0 | 0 | 2 | 2 | 0
 | Region-5 | EMP-2 |  | PRO-3 |  |  | Eastern Region | [NAME] | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 | Region-5 | EMP-3 |  | PRO-3 |  |  | Sub Total Eastern Region | 3 | 9
 | Region-3 | EMP-1 |  | PRO-1 |  |  | Western Region | Region-6 | 4 | 0.25 | 0.25 | 0.5 | 0 | 1 | 1 | 2 | 0
 | Region-3 | EMP-2 |  | PRO-3 |  |  | Western Region | Region-5 | 3 | 0.3333333333333333 | 0 | 0.6666666666666666 | 0 | 1 | 0 | 2 | 0
 | Region-3 | EMP-3 |  | PRO-3 |  |  | Western Region | Region-3 | 8 | 0.375 | 0 | 0.625 | 0 | 3 | 0 | 5 | 0
 | Region-3 | EMP-4 |  | PRO-1 |  |  | Sub Total Western Region | 3 | 15
 | Region-3 | EMP-5 |  | PRO-3 |  |  | Total EMPs | 7 | 30 | 8 | 8 | 13 | 1
 | Region-3 | [NAME] |  | PRO-1 |  |  | % Share | - | - | 0.2666666666666667 | 0.2666666666666667 | 0.4333333333333333 | 0.03333333333333333
 | Region-3 | EMP-7 |  | PRO-3
 | Region-3 | EMP-8 |  | PRO-3
 | [NAME] | EMP-1 |  | PRO-1
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: Assumptions

BENEFITS
 | 4800 |  | Annual flex dollars per US employee
 | 0.0375 |  | Cash Balance & SERP
 | 0.0125 |  | FAS 106
 | 0.03 |  | Savings Plan
 | 0.011 |  | Other
 |  |  | percent of annualized payroll for non-regulated companies
PAYROLL TAXES
 | 84500 |  | Annual FICA base earnings level
 |  |  | Tax rate for budgeted base salaries less than annual FICA base earnings level
 |  |  | Additional tax rate for budgeted base salaries greater than annual FICA base earnings level
Analyst & Associate**
 | 12000 |  | Associate
 | 8700 |  | 3rd Yr Analyst
 | 7800 |  | Analyst
 | 2400 |  | Tax Analyst
 | 3900 |  | Summer Analyst
 | 6900 |  | Summer Associate
Spreadsheet: 856292d1705585782-formula-to-flag-duplicates-only-under-certain-conditions-test-flag-cancellations-if-already-ordered
Sheet: Sheet1

School | Subject | Sales rep | Opportunity created date | Outcome | Concat (columns a-d) | Cancelled but already ordered?
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed won
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed won
[NAME] | Science | [NAME] | 2024-01-01 00:00:00 | Closed won
London Free School | English | [NAME] | 2024-01-01 00:00:00 | Closed lost
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed lost
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | French | [NAME] | 2024-01-01 00:00:00 | Open
Spreadsheet: 525170d1498574934-formula-to-transfer-data-from-one-range-of-cells-to-another-based-on-conditions-working-2
Sheet: Sheet2

 | 1 | 16
R | 6 | 2
S | 7 | 3
T | 2 | 6
U | 3 | 7
V1 | 10 | 9
v2 | 9 | 10
Spreadsheet: 470780d1468649522-time-calculation-formula-not-working-well-book16
Sheet: Sheet1

OPEN DATE | RECEIPT DATE | CLOSE DATE | Time period
2016-12-07 09:37:36 | 2016-12-07 09:39:18 | 2016-12-07 09:39:50
2016-12-07 09:33:20 | 2016-12-07 09:36:33 | 2016-12-07 09:37:19
2016-12-07 07:51:33 | 2016-12-07 07:52:33 | 2016-12-07 07:53:01
7/13/2016 9:48:47 | 7/13/2016 9:49:27 AM | 7/13/2016 9:49:40
2016-12-07 09:54:35 | 2016-12-07 10:08:48 | 2016-12-07 10:09:33
7/13/2016 11:08:27 AM | 7/13/2016 11:15:03 AM | 7/13/2016 11:15:37 AM
7/13/2016 11:41:45 AM | 7/13/2016 11:45:33 AM | 7/13/2016 11:46:10 AM
7/13/2016 11:32:25 AM | 7/13/2016 11:35:54 AM | 7/13/2016 11:36:21 AM
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 5Capital Costs

Table 5.2.41.  Capital Costs
Complete the areas shown in gray below.  Where shown, use pulldown menu to select options.  The spreadsheet will calculate the capital costs.
Alternative:
Project Administration ($):
Component | Unit Costa | Unit | Quantity | Total Cost
aUnit costs are in today's dollars, not future dollars. |  |  | Total Construction Cost:
 |  |  | Construction Contingency Cost:
 |  |  | Project Administration Cost:
 |  |  | Total Capital Costs:
Construction Contingency: | 0.1
Spreadsheet: 58586d1258826148-pivot-table-excel-help
Sheet: Sheet2

Count of Purpose | Motor Type
Purpose | 1 TON | 1/2 TON | 2 TON | Grand Total
Audio | 4 | 27 | 4 | 35
Lighting | 10 | 15 |  | 25
Lighting Audience | 9 |  | 1 | 10
Video |  | 6 |  | 6
(blank)
Grand Total | 23 | 48 | 5 | 76
Purpose
audio | A sum total of the total load in lbs for audio
lighting | A sum total of the total load in lbs for lighting
video | A sum total of the total load in lbs for video
 | sum total of total weight
Spreadsheet: a30b1228-240d-4f5d-9b72-e4cbd46c4ed3
Sheet: Disposition Form

Program for which the equipment was purchased:
Reason for disposition:
Board or Consortium policy/reference regarding disposition of equipment:
Date of disposition:
Method of disposition:
 |  | Transferred to other federal program |  |  |  | Program:
 |  | Transferred to consortium member district |  |  |  | District:
 |  | Traded in |  | Value received:
 |  | Sold at fair market value* |  |  | Amount received:
 |  | *Explain how fair market value was determined:
 |  | Discarded (broken/no market value)
Date of Purchase |  |  | Description of Equipment |  |  |  | Manufacturer and Model Number | Inventory Number | Original Cost
Name of person submitting the form:
Name of district/consortium/community college:
Spreadsheet: 149786d1334140210-checking-a-list-of-values-for-a-match-using-the-match-to-decide-where-to-take-data-from-dummy-excel-doc
Sheet: Sheet2

Contact Number | Participants | Voucher Details | Owed
[PHONE] | [NAME] | LAQA515646HOT
[PHONE] | [NAME] | LAQAJHDJFH878787
079191919 | [NAME] | MILLI4545KILLI
[PHONE] | [NAME] | DAMN6478
[PHONE] | [NAME] | HECATEPER
[PHONE] | [NAME] | ROUND0984957
[PHONE] | [NAME] | OVALDOME0909
[PHONE] | Picked A. Pepper | IANO3456543
077777778 | [NAME] | PARTAFRANKINTEN45ER
Spreadsheet: 731570d1620414795-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: QTUM

S.N. | Particulars | Bought  Units | Unit or QTUM Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] | 38.01214834 | 0.00390999 |  | -0.14899905 | 14740.1 | 2018-01-02 00:00:00 | 2018-01-02 00:00:00
2 | [NAME] | -38.01214834 | 0.00232505 |  | 0.08815957 | 11519.49 | 2018-03-05 00:00:00 | 2018-03-05 00:00:00
3
4
5
6
7
8
9
10
11
 | Next Buy
 | QTUM in [NAME] (MEW) | 0
 | QTUM in Bittrex | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 00637df4-d7f9-45e5-b5dc-662d9ad3c881
Sheet: Sheet2

INTERRATER |  | Fall 2011
RATER | A | B | C | D | E | F | G | H | I | J
1 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 2
2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
3 | 2 | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2
4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
6 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
7 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 2
8 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3
9 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3
10 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 3 | 2 | 2
11 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 2
PERCENT AGREEMENT
 |  |  | 100 | 100 | 100 | 64 | 64 |  |  | 55
 | A=KNOWLEDGE OF CONTENT AND PEDAGOGY
* | B=KNOWLEDGE OF/MAKES USEOF MATERIALS, RESOURCES AND TECHNOLOGY
 | C=DESIGNS ACTIVITIES THAT PROMOTE STUDENT LEARNING
 | D=CREATES AN ENVIRONMENT OF RAPPORT AND RESPECT
 | E=MANAGES CLASSROOM PROCEDURES AND BEHAVIOR
* | F=COMMUNICATES CLEARLY AND ACCURATELY
* | G=USES QUESTIONING AND DISCUSSION TECHNIQUES
 | H=ENGAGES STUDENTS IN LEARNING
* | I=ASSESS STUDENT LEARNING
* | J=REFLECTS ON TEACHING
 | Items B, F, G, I, and J show rater disagreement.
 | These items will be checked again during spring interater assessment.