tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73442d1274113277-multi-sheet-formula-auto-populate-updated-week-4
Sheet: BLANK WEEK

 |  | THE HIT PARADE
 |  | Monday |  |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | Player | Hits | Points |  | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points |  |  |  | TOTAL HITS
Cubie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Dwayne |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Kent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Nate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Scott |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 0 | 0
Not Hitter | 0 | 0
Total Points
Cubie |  | 4
Spreadsheet: 685652d1594128479-formula-help-insert-multiple-text-variables-in-new-sheet-sample-workbook-for-help
Sheet: Overview

Customer | Type | Year | Consumption | Savings | Costs | % saving | Estimert ROI
 |  |  |  |  |  |  |  | IFS('Datagrunnlag (1)'!A:A='Datagrunnlag (1)'!A:A;'Datagrunnlag (1)'!A:A;'Datagrunnlag (1)'!B:B='Datagrunnlag (1)'!B:B;'Datagrunnlag (1)'!B:B)
Spreadsheet: 29357d1224286901-formula-to-determine-schedule-cost-xlfrm-schedule
Sheet: Schedule

 | Schedule by Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Information
 | Name | Title | Standard |  | Burdened |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | TOTAL |  | The "Burdened" Rate is the default setting for the work-out, "Schedule by Cost." When overtime is hit for the week, costs will adjust automatically. To over-ride the default, place an "X" below.
 |  |  | [NAME] | OT Rate | [NAME] | OT Rate
 | [NAME] | Technician | 15 | 22.5 | 22.44 | 30.97 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 70
 | [NAME] | Shop Hand | 10 | 15 | 16.24 | 22.57 |  |  |  | 10 |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Over-ride? ("Use Standard Rate?") |  |  | X
 |  |  |  |  |  |  | 10 | 10 | 10 | 20 | 10 | 10 | 10 | 80
 | Schedule by Cost
 | Name | Title | Standard |  | Burdened |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | TOTAL
 |  |  | [NAME] | OT Rate | [NAME] | OT Rate
 | [NAME] | Technician | 15 | 22.5 | 22.44 | 30.97 | 150 | 150 | 150 | 150 | 225 | 300 | 375 | 1500
 | [NAME] | Shop Hand | 10 | 15 | 16.24 | 22.57 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 100
 | - | - | - | - | - | - | - | - | - | - | - | - | - | 0
 | - | - | - | - | - | - | - | - | - | - | - | - | - | 0
 | - | - | - | - | - | - | - | - | - | - | - | - | - | 0
 |  |  |  |  |  |  | 150 | 150 | 150 | 250 | 225 | 300 | 375 | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600
 | WEEKLY TOTAL: | 18779.76
 | PAYROLL %: | 0.08519810689806473
Spreadsheet: 714125d1611102573-iferror-formula-results-in-spill-sample
Sheet: Sheet1

SSN | EMPL ID | WNAME | CBID | POSIT16 | Unit | CLASS | SALPER | BASEPAY | NEW SAL RATE
111223333 | 108658062 | GONZALEZ, [NAME] | [NAME] | [PHONE]-002 | 219 | 1032 | M | 2758 | 2912
222334444 |  | GUTIERREZ, [NAME] | [NAME] | [PHONE]-001 | 220 | 1032 | M | 2777 | 2912
333445555 |  | Smith, [NAME] | [NAME] | [PHONE]-001 | 221 | 1032 | M | 2830 | 2912
Spreadsheet: 682058d1591889837-currency-formats-on-bank-downloads-how-to-correct-the-format-so-the-data-acts-as-normal-sample-number-downloads
Sheet: Sheet1

€0.00 | €300.00 | €0.00 | -€2.31 |  |  |  |  |  |  | €0.00 | €300.00 | €0.00 | -€2.31
€685.00 | €0.00 | €2.40 | €686.60 |  |  |  |  |  |  | €685.00 | €0.00 | €2.40 | €686.60
€0.00 | €110.00 | €0.00 | €7.00 |  |  |  |  |  |  | €0.00 | €110.00 | €0.00 | €7.00
Spreadsheet: 855069d1704785514-sum-of-columns-from-different-sheet-formula-copied-accross-to-more-sheets-area-140-relief-pharmacist-tracker
Sheet: Master

Relief 1 |  |  |  |  |  |  | Relief 2
Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First |  | Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First
 | Interventions | [NAME] | Stage 1 | Stage 2 ABPM |  |  |  | Interventions | [NAME] | Stage 1 | Stage 2 ABPM
January |  |  |  |  |  |  | January
February |  |  |  |  |  |  | February
March |  |  |  |  |  |  | March
April |  |  |  |  |  |  | April
May |  |  |  |  |  |  | May
June |  |  |  |  |  |  | June
July |  |  |  |  |  |  | July
August |  |  |  |  |  |  | August
September |  |  |  |  |  |  | September
October |  |  |  |  |  |  | October
November |  |  |  |  |  |  | November
December |  |  |  |  |  |  | December
Relief 3 |  |  |  |  |  |  | Relief 4
Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First |  | Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First
 | Interventions | [NAME] | Stage 1 | Stage 2 ABPM |  |  |  | Interventions | [NAME] | Stage 1 | Stage 2 ABPM
January |  |  |  |  |  |  | January
February |  |  |  |  |  |  | February
March |  |  |  |  |  |  | March
April |  |  |  |  |  |  | April
May |  |  |  |  |  |  | May
June |  |  |  |  |  |  | June
July |  |  |  |  |  |  | July
August |  |  |  |  |  |  | August
September |  |  |  |  |  |  | September
October |  |  |  |  |  |  | October
November |  |  |  |  |  |  | November
December |  |  |  |  |  |  | December
Spreadsheet: 680293d1590921442-calculate-months-withing-1st-and-2nd-half-of-the-year-depeding-on-changable-date-calculate-months-in-1st-and-2nd-half-of-the-year
Sheet: Sheet1

From | To |  |  | Year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026
2021-06-01 00:00:00 | 2025-05-31 00:00:00 |  |  | Month 1st half of the year | 1 | 6 | 6 | 6 | 5 | 0 | This is how the result should look like
 |  |  |  | months 2nd half of the year | 6 | 6 | 6 | 6 | 0 | 0
The dates can be changed by the user
Spreadsheet: 273876d1382953523-linest-function-forum-example
Sheet: Folha1

 |  | x | y
 |  | 10 | 5
 |  | 22 | 12
 |  | 35 | 15
 |  | 60 | 21
 |  | 85 | 35
 |  | 102 | 50
 |  |  |  |  |  |  |  |  |  |  |  | -0.3883730318934191
 |  |  |  |  |  |  |  |  |  |  | 0.05025055674834698 | 3.113777955372087
 |  |  |  |  |  |  |  |  |  |  | 0.951863638985157 | 4.084023639946655
 |  |  |  |  |  |  |  |  |  |  | 79.09726609301816 | 4
 |  |  |  |  |  |  |  |  |  |  | 1319.283003633428 | 66.71699636657249
 |  |  |  |  |  |  |  |  |  |  |  | 2.337793742460185
 |  |  |  |  |  |  |  |  |  |  | 0.01634947650952614 | 2.446943069158654
 |  |  |  |  |  |  |  |  |  |  | 0.9644479915771629 | 3.509810667046449
 |  |  |  |  |  |  |  |  |  |  | 108.5112244694051 | 4
 |  |  |  |  |  |  |  |  |  |  | 1336.724916325948 | 49.27508367405214
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 78448 | 77619
2 | 85041 | 84335
3 | 98229 | 102930
4 | 97181 | 96001
5 | 94830 | 94837
6 | 118505 | 116824
7 | 132898 | 134855
8 | 138859 | 138000
9 | 124179 | 120027
10
11 | 692 | 12248
12 | 39802 | 37000
13 | 98820 | 96392
14 | 125524 | 131334
15 | 132209 | 132373
16 | 123588 | 119922
17 | 108500 | 106912
18 | 142283 | 139594
19 | 104002 | 100610
20 | 126021 | 128758
21 | 119031 | 117082
22 | 124935 | 124297
23 | 129044 | 127800
24 | 130822 | 129990
25 | 104275 | 102951
26 | 111622 | 109724
27 | 111834 | 110374
28 | 151982 | 146300
29
30
31
2001-06-30 00:00:00 |  |  | 59179
2001-07-28 00:00:00
Spreadsheet: larry_campbell__20971__pg&esamp
Sheet: PG&E Page 6

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-15 00:00:00 | SLX-TW | 4-15-99-L |  |  |  |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-15 00:00:00 | PG&E-TW2 | 4-15-99-L |  |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-15 00:00:00 | PG&E-Top3 | 4-15-99-L |  |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-15 00:00:00 | PG&E-A6 | 4-15-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-15 00:00:00 | PG&E-B6 | 4-15-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
1999-04-15 00:00:00 | PG&E 10.84A | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line A
1999-04-15 00:00:00 | PG&E 10.84B | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-15 00:00:00 | PG&E 8.58A | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-15 00:00:00 | PG&E-TW4 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 1st Siphon
1999-04-15 00:00:00 | PG&E-TW5 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 2nd siphon
1999-04-15 00:00:00 | PG&E-TW6 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-22 00:00:00 | SLX-TW | 4-22-99-L |  |  |  |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-22 00:00:00 | PG&E-TW2 | 4-22-99-L |  |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-22 00:00:00 | PG&E-Top3 | 4-22-99-L |  |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-22 00:00:00 | PG&E-A6 | 4-22-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-22 00:00:00 | PG&E-B6 | 4-22-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
1999-04-22 00:00:00 | PG&E 10.84A | 4-22-99-L |  |  |  |  |  |  |  |  | PG&Es 34" Line A
1999-04-22 00:00:00 | PG&E 10.84B | 4-22-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-22 00:00:00 | PG&E 8.58A | 4-22-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-22 00:00:00 | PG&E-TW4 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 1st Siphon
1999-04-22 00:00:00 | PG&E-TW5 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 2nd siphon
1999-04-22 00:00:00 | PG&E-TW6 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 030c5383-125e-485e-8744-767adfcba7b4
Sheet: March 2013

Monthly Consolidated Revenues |  |  |  | (In NT$ million)
 | 2013 | 2012 | MoM Change | YoY Change
December | 21569.433 | 26362.776
January | 15536.282 | 16615.31
February | 11369.748 | 20294.435
March | 15882.487 | 30879.836
April | 19590.931 | 31031.952
May | 29000.57 | 30004.481
June | 22075.414 | 30004.443
July | 15728.367 | 25024.934
August | 13167.981 | 24019.109
September | 18151.219 | 21132.795
October | 14995.072 | 17213.683
November
December
Total
Spreadsheet: 882945d1731423755-v-lookup-return-value-based-on-contains-x-text-example-excel-help
Sheet: Sheet1

Ticket | [NAME] | Output Needed |  |  |  |  | Look up
1 | Deployed - aaaaa | 1 |  |  |  |  | Deploy | 1
2 | Deployed - yyyyyy | 1 |  |  |  |  | Deployed | 1
3 | Ready to Deploy - xxxxxxx | 1 |  |  |  |  | Ready to Deploy | 1
4 | Deployed - aaaaa | 1 |  |  |  |  | In Progress | 2
5 | In progress - ffjdksjflk | 2 |  |  |  |  | Preview | 2
6 | Projects- adsjkajdlksdj | 4 |  |  |  |  | In Q | 3
7 | In Q - adsjdasjlkadj | 3 |  |  |  |  | Projects | 4
8 | Preview - adasjdksjdl | 2
9 | Preview - fffjjjjjjjj | 2
10 | Projects- cxcccccccc | 4
11 | In progress - DFDSJSDKJSDKL | 2
12 | Deployed - aaaaa | 1
13 | Deployed - yyyyyy | 1
14 | Ready to Deploy - xxxxxxx | 2
15 | Deployed - aaaaa | 1
16 | In progress - ffjdksjflk | 2
17 | Projects- adsjkajdlksdj | 4
18 | In Q - adsjdasjlkadj | 3
19
20
21
22
Spreadsheet: 701946d1603997762-need-non-adjusting-reference-when-rows-added-test-excel-file
Sheet: combined

ID | Start time | Completion time | [NAME] | Name | Would you prefer to fill out this form in English or Spanish? | Today's Date: | Parents Name: | Home address:
Spreadsheet: 698481d1602000598-vlookup-returns-error-when-table-array-is-from-another-sheet-excel-settings-book1-example
Sheet: Sheet1

Table 1
Employee | Rate
Number 1
Number 2
Number 3
Number 4
Number 5
Number 6
Number 7
Number 8
Number 9
Number 10
Spreadsheet: 83763d1283799607-problems-with-excel-formulas-supplier-ranking-system
Sheet: Sheet1

 | Suppliers |  |  |  |  | Number of Reports | Manufact within 24 months | Marketing Materials | Samples | Manufact within 24 months | Marketing Materials | Samples | Supplier Total
364 | Supplier 1 | Products Added | 1 | San Jose | United States | 1 | 1 | 1 | 1 | 5 | 10 | 5 | 20 |  | 180
246 | Supplier 2 | Products Added | 1 | NULL | NULL | 7 | 1 | 1 | 1 | 5 | 10 | 5 | 20 | 0-1 | 1
345 | Supplier 3 | Products Added | 1 | San Antonio | United States | 5 | 1 | 1 | 1 | 5 | 10 | 5 | 20 | 1 10 | 2
1189 | Supplier 4 | Products Added | 1 | Chichester | United Kingdom | 7 | 1 | 1 | 1 | 5 | 10 | 5 | 20 | 10 50 | 3
812 | Supplier 5 | Products Added | 1 | New York | United States | 4 | 1 | 1 | 1 | 5 | 10 | 5 | 20 | 50-100 | 4
699 | Supplier 6 | Products Added | 1 | London | United Kingdom | 4 | 1 | 1 | 1 | 5 | 10 | 5 | 20 | 100+ | 5
315 | Supplier 7 | Products Added | 1 | London | United Kingdom | 5 | 1 | 1 | 1 | 5 | 10 | 5 | 20
1070 | Supplier 8 | Products Added | 1 | Basel | Switzerland | 3 | 1 | 1 | 1 | 5 | 10 | 5 | 20
3517 | Supplier 9 | Products Added | 1 | [NAME] | United Kingdom | 6 | 1 | 1 | 0 | 5 | 10 | 0 | 15
3076 | Supplier 10 | Products Added | 1 | Beijing | China | 6 | 1 | 0 | 0 | 5 | 0 | 0 | 5
6549 | Supplier 11 | Sent Contract | 0 | NULL | NULL | 1 | 1 | 1 | 0 | 5 | 10 | 0 | 15
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: BL

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 43e2037a-2605-4cec-a12f-f968a64fb794
Sheet: Circo2 legislative

[NAME] tour |  | Résultats provisoires pour la 2ème circonscription législative
2012-06-02 00:00:00
Commune | Bureau de vote | Inscrits | Abstentions | Votants | % Particip. | Blancs et nuls | [NAME] | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp
Papeeno
Papeeno
Tiarei
Tiarei
Mahaena
Hitiaa
Rairua
Mahanatoa
Anatonu
Vaiuru
Ahurei
Amaru
Matuaura
Anapoto
Moerai
Avera
Hauti
Mataiea
Mataiea
Papeari
[NAME]
Taahuaia
Mahu
TOTAL | Nbr bureau de vote | Inscrits | Abstentions | Votants | % Particip. | Blancs et nuls | [NAME] | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp | [NAME] | % Voix/Ins | % Voix/Exp
TOTAL CIRCO 2
Spreadsheet: 545183d1509349304-logging-sheet-and-date-formula-didnt-work-and-i-believe-it-could-be-a-bug-in-excel-test-logging-sheet-2018-01-to-2018-12
Sheet: January

Logging Sheet
Date YYYY-MM-DD | Column A formula | Time  Accept | Time  Decline | Name Print (First and Last) | Name Signature |  | How I fixed it | Column H formula
 | =Main!B1&"-01-01" Sheet: Main, Cell: B1 = 2018 | 06:00:00 | 18:00:00 |  |  |  |  | =Main!B1&"-01-01" Sheet: Main, Cell: B1 = 2018
 | =SUM(A3) | 18:00:00 | 06:00:00 |  |  |  |  | =SUM(H3+1)-1
 | =SUM(A4+1)
 | =SUM(A5) |  |  |  |  |  | So, why does substracting and adding 1 to a date value kicks the right date to come up?
 | =SUM(A6+1)
 | =SUM(A8+1)
 | =SUM(A9)
 | =SUM(A10+1)
Spreadsheet: 3b6eb84c-c8d8-4411-87a1-178412900ff7
Sheet: Sheet1

Historic prices | Cubist Pharmaceuticals | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Price | Date | High | Low | Volume
41.5 | 5/4/2012 12:00:00 AM | 42.32 | 41.36 | 714824
42.39 | 5/3/2012 12:00:00 AM | 42.71 | 42.13 | 743872
42.61 | 5/2/2012 12:00:00 AM | 42.79 | 41.89 | 1103986
42.3 | 5/1/2012 12:00:00 AM | 42.93 | 41.95 | 722011
42.28 | 4/30/2012 12:00:00 AM | 42.8 | 41.99 | 1057588
42.79 | 4/27/2012 12:00:00 AM | 43 | 42.34 | 588250
42.54 | 4/26/2012 12:00:00 AM | 42.59 | 41.87 | 1168446
42.16 | 4/25/2012 12:00:00 AM | 42.26 | 41.33 | 1010932
41.32 | 4/24/2012 12:00:00 AM | 41.76 | 40.86 | 675585
41.42 | 4/23/2012 12:00:00 AM | 41.61 | 40.94 | 644209
41.89 | 4/20/2012 12:00:00 AM | 42.55 | 41.86 | 916704
42.13 | 4/19/2012 12:00:00 AM | 44 | 41.64 | 1859394
40.69 | 4/18/2012 12:00:00 AM | 40.99 | 40.05 | 702767
40.22 | 4/17/2012 12:00:00 AM | 40.65 | 39.79 | 567308
39.9 | 4/16/2012 12:00:00 AM | 40.6 | 39.26 | 583489
40.1 | 4/13/2012 12:00:00 AM | 41 | 39.96 | 765933
40.86 | 4/12/2012 12:00:00 AM | 41.11 | 40.35 | 498098
40.6 | 4/11/2012 12:00:00 AM | 40.76 | 40.17 | 544653
40.19 | 4/10/2012 12:00:00 AM | 41.83 | 39.85 | 1159293
41.84 | 4/9/2012 12:00:00 AM | 42.37 | 41.57 | 547860
42.66 | 4/5/2012 12:00:00 AM | 42.9 | 42.45 | 442482
42.69 | 4/4/2012 12:00:00 AM | 43.66 | 42.4 | 817130
Spreadsheet: 32472d1228672926-excel-formula-excel-formula
Sheet: TASK 1

Employee Grade |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Number of Employees |  | 25 | 23 | 20 | 15 | 12 | 8 | 3
[NAME] |  | 15063 |  |  |  | [NAME] Perks |  | 612
Increment |  | 1694 |  |  |  | Increase in value of Perks between grades |  | 0.1
(From one grade to next)
 |  |  | NI Rate | 0.11
Employee Grade |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Number of Employees |  | 25 | 23 | 20 | 15 | 12 | 8 | 3
Annual Salary |  | 376575 | 346449 | 301260 | 225945 | 180756 | 120504 | 45189
National Insurance |  |  |  |  |  |  |  |  | < adding 11% on each column
Perks |  | 612 | 673.2 | 740.5200000000001 | 814.5720000000001 | 896.0292000000002 | 985.6321200000002 | 1084.195332 | < increasing by 10% on each column.
Cost per Employee |  | 602.52
Total Cost per Grade |  |  |  |  |  |  |  |  | < adding everything to work out the total
Overall Cost
What-If? Results
As things are
Option 1
Option 2
Option 3
Spreadsheet: 116247d1311697612-problem-with-matching-recognizing-specific-data-rows-columns-among-sheets-date-list
Sheet: TUESDAY

 |  |  | TUESDAY SCHEDULE
AGENT | Boat Details | TIME | T A X I  T R A N S F E R | TOTAL | B O O K I N G | HOLIDAY |  | TAXI ID | NET RATE
 |  |  |  |  |  |  |  | 5 | 40
 |  |  |  |  |  |  |  | 6 | 55
 |  |  |  |  |  |  |  | 8 | 34
 |  |  |  |  |  |  |  | 5 | 28
 |  |  |  |  |  |  |  | 7 | 40
 |  |  |  |  |  |  |  | 7 | 28
 |  |  |  |  |  |  |  | 6 | 30
 |  |  |  |  |  |  |  | 8 | 30
 |  |  |  |  |  |  |  | 5 | 40
Spreadsheet: daren_farmer__5232__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 770794
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 809751d1671279407-data-cleansing-query-compare-lookup-return-standard-value-data-cleansing-query-updated
Sheet: Sheet1

 |  |  |  | Can I create a table like this?
 | Current Data Example | DESIRED Result |  | RETURN THIS | opt1 | opt2 | opt3 | opt4 | opt5 | opt6 |  | Current Data Example | Desired Result
 | [NAME] | Floor 01 |  | Floor 01 | [NAME] | Flr 1 | [NAME] | Flr One | 1 | 1 |  | [NAME]
 | Flr 1 | Floor 01 |  | Floor 02 | [NAME] | Flr 2 | Floor Two | Flr Two | 2 | 2 |  | Flr 1
 | [NAME] | Floor 01 |  |  |  |  |  |  |  |  |  | [NAME]
 | Flr One | Floor 01 |  |  |  |  |  |  |  |  |  | Flr One
 | [NAME] | Floor 01 |  | CurrentData | UseData |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | 1 | Floor 01 |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | [NAME]
 | 1 | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr 1 | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr One | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | Location | Correct Location
 |  |  |  | Floor 01 | Floor 01
 |  |  |  | [NAME] | Floor 01
 |  |  |  | Flr 1 | Floor 01
 |  |  |  | Flr 2 | Floor 02
 |  |  |  | Floor Two | Floor 02
 |  |  |  | Flr Two | Floor 02
 |  |  |  | 1 | Floor 01