tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 209973d1359330397-compare-and-line-up-similar-data-by-field-number-comparison-excel-2007-example-spreadsheet
Sheet: Sheet1

Bank Register |  |  |  |  |  |  |  | Bank Statement
Date | Check Number |  | Payee | Amount |  | Check Number | Date | Ref Number | Amount
2012-10-01 00:00:00 | 8728 | 605 | Payee 2 | 1633.6 |  | 8725 | Oct 15 | 9791874755 | 288
2012-10-01 00:00:00 | 8729 | 605 | Payee 3 | 2000 |  | 8726 | Oct 12 | 8894625309 | 3321.72
2012-10-01 00:00:00 | 8730 | 605 | Payee 4 | 180 |  | 8727 | Oct 10 | 8892810545 | 5280.4
2012-10-01 00:00:00 | 8731 | 618 | Payee 5 | 21.23 |  | 8728 | Oct 11 | 8893578445 | 1633.6
2012-10-01 00:00:00 | 8732 | 605 | Payee 6 | 36207.3 |  | 8729 | Oct 12 | 9190390708 | 2000
2012-10-01 00:00:00 | 8733 | 622 | Payee 7 | 4946.97 |  | 8730 | Oct 11 | 8893763654 | 180
2012-10-02 00:00:00 | 8734 | 156 | Payee 8 | 9451.06 |  | 8734 | Oct 11 | 9190259526 | 9451.06
Wanted output
Bank Register |  |  |  |  |  | Bank Statement
Date | Check Number |  | Payee | Amount |  | Check Number | Date | RefNumber | Amount
2012-10-01 00:00:00 | 8728 | 605 | Payee 2 | 1633.6 |  | 8728 | Oct 11 | 8893578445 | 1633.6
2012-10-01 00:00:00 | 8729 | 605 | Payee 3 | 2000 |  | 8729 | Oct 12 | 9190390708 | 2000
2012-10-01 00:00:00 | 8730 | 605 | Payee 4 | 180 |  | 8730 | Oct 11 | 8893763654 | 180
2012-10-01 00:00:00 | 8731 | 618 | Payee 5 | 21.23
2012-10-01 00:00:00 | 8732 | 605 | Payee 6 | 36207.3
2012-10-01 00:00:00 | 8733 | 622 | Payee 7 | 4946.97
2012-10-02 00:00:00 | 8734 | 156 | Payee 8 | 9451.06 |  | 8734 | Oct 11 | 9190259526 | 9451.06
Spreadsheet: 682616d1592229079-finding-all-the-non-empty-rows-in-a-column-depending-on-user-input-in-custom-order-tests
Sheet: Sheet1

 |  |  |  |  |  | DATE |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00
[NAME] | 2020-06-03 00:00:00 |  |  | TOTAL |  | country | name |  | AGE | BLOOD GRP |  |  | AGE | BG |  |  | AGE | BLOOD GRP |  |  | AGE | BG
russia | z |  |  |  |  | russia | z |  |  |  |  |  | 2 | AB |  |  | 1 | A
russia | l |  |  |  |  | french | y |  | 5 | A |  |  |  |  |  |  | 2 | B
french | y |  |  |  |  | japan | x |  |  |  |  |  | 3 | O
japan | x |  |  |  |  | china | v |  | 6 | O |  |  | 4 | c |  |  |  |  |  |  | 4 | C
china | v |  |  |  |  | india | w |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | D
china | x |  |  |  |  | russia | l |  |  |  |  |  | 5 | B
india | w |  |  |  |  | french | m
 |  |  |  |  |  | japan | n
 |  |  |  |  |  | china | x |  |  |  |  |  | 6 | C
OUTPUT |  |  |  | EXPECTED OUTPUT
NAME | AGE | BG | lol | NAME | AGE | BG
 |  |  |  | russia | 2 | AB
 |  |  |  | russia | 5 | B
 |  |  |  | japan | 3 | O
 |  |  |  | china | 6 | C
 |  |  | Finding all the non empty rows in a column depending on user input.
 |  |  | I have attached a sample file with expected output. Number of rows may extend upto 200 . I want to extract data based on user input with non blank cells . My target column is age column to find the non empty rows. If age column is blank then blood group will also be blank.
Spreadsheet: 214873d1361170674-using-vlookup-determine-the-round-of-the-competition-based-on-the-registration-reg
Sheet: GAME D

PSGN |  | NAMA PESERTA | NEGERI
 | No
 | #N/A | NP1- 1 | #N/A
 | #N/A | #N/A | Per 2
 | WP3- 1 | NP3- 1 | Per 3
1 | WP18 1 | NP18 1 | Per18
 | WP5- 1 | NP5- 1 | Per 5
 | WP6- 1 | NP6- 1 | Per 6
 | WP9- 1 | NP9- 1 | Per 9
 | WP13 1 | NP13- 1 | Per13
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP7- 1 | NP7- 1 | Per 7
 | WP17 1 | NP17- 1 | Per17
 | WP15 1 | NP15- 1 | Per15
2 | WP12 1 | NP12- 1 | Per12
 | WP14 1 | NP14- 1 | Per14
 | WP10- 1 | NP10- 1 | Per 10
 | WP16 1 | NP16- 1 | Per16
 | WP8- 1 | NP8- 1 | Per 8
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP5- 2 | NP5- 2 | Per 5
 | WP18 2 | NP18 2 | Per18
 | WP3- 2 | NP3- 2 | Per 3
3 | WP13 2 | NP13- 2 | Per13
 | WP9- 2 | NP9- 2 | Per 9
 | WP2- 2 | NP2- 2 | Per 2
 | WP1- 2 | NP1- 2 | Per 1
 | WP4- 2 | NP4- 2 | Per 4
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP8- 2 | NP8- 2 | Per 8
 | WP15 2 | NP15- 2 | Per15
 | WP17 2 | NP17- 2 | Per17
4 | WP7- 2 | NP7- 2 | Per 7
 | WP16 2 | NP16- 2 | Per16
 | WP12 2 | NP12- 2 | Per12
 | WP10- 2 | NP10- 2 | Per 10
 | WP14 2 | NP14- 2 | Per14
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP5- 3 | NP5- 3 | Per 5
 | WP18 3 | NP18 3 | Per18
 | WP3- 3 | NP3- 3 | Per 3
5 | WP13 3 | NP13- 3 | Per13
 | WP2- 3 | NP2- 3 | Per 2
 | WP1- 3 | NP1- 3 | Per 1
 | WP4- 3 | NP4- 3 | Per 4
 | WP6- 3 | NP6- 3 | Per 6
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP17 3 | NP17- 3 | Per17
 | WP16 3 | NP16- 3 | Per16
 | WP8- 3 | NP8- 3 | Per 8
6 | WP7- 3 | NP7- 3 | Per 7
 | WP12 3 | NP12- 3 | Per12
 | WP10- 3 | NP10- 3 | Per 10
 | WP14 3 | NP14- 3 | Per14
 | WP15 3 | NP15- 3 | Per15
PSGN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP11- 1 | NP11- 1 | Per11
 | WP2- 4 | NP2- 4 | Per 2
 | WP3- 4 | NP3- 4 | Per 3
7 | WP6- 4 | NP6- 4 | Per 6
 | WP9- 4 | NP9- 4 | Per 9
 | WP5- 4 | NP5- 4 | Per 5
 | WP18 4 | NP18 4 | Per18
 | WP4- 4 | NP4- 4 | Per 4
PUSINGAN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP15 4 | NP15- 4 | Per15
 | WP17 4 | NP17- 4 | Per17
 | WP7- 4 | NP7- 4 | Per 7
8 | [NAME] 4 | NP8- 4 | Per 8
 | WP12 4 | NP12- 4 | Per12
 | WP16 4 | NP16- 4 | Per16
PUSINGAN |  | NAMA PESERTA | NEGERI
 | WAU
 | WP4- 1 | NP4- 1 | Per 4
 | WP6- 2 | NP6- 2 | Per 6
 | WP9- 3 | NP9- 3 | Per 9
9 | WP13 4 | NP13- 4 | Per13
 | WP14 4 | NP14- 4 | Per14
 | WP1- 4 | NP1- 4 | Per 1
 | WP10- 4 | NP10- 4 | Per 10
Spreadsheet: 769706d1645645390-keep-a-52-week-average-across-2-worksheets-holiday-accrual-spreadsheet
Sheet: 2022-23

 | Person A | Person B | Person C | Person D
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Week 38
Week 39
Week 40
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52
Pay Rate | 10.5 | 9.25 | 10.85 | 8.91
Hours Accrued
Average Hours
Hours Accrued (£)
Holiday Taken | 0 | 0 | 0 | 0
Holiday taken (£)
Holiday Remaining
Holiday Remaining (£)
Ave Hours 21/22
Ave holiday 21/22
Spreadsheet: 701026d1603468558-data-from-one-form-to-another-example
Sheet: Sheet1

 |  | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
101 | Oregon | Apple | Orange | Apple |  |  | Apple |  |  | Apple | Apple |  |  | Apple
102 | Washington | Grape |  | Grape |  |  | Grape | Grape |  |  | Grape |  | Grape |  | Grape |  | A
103 | Alaska | Peach |  |  | Peach | Grape | Peach | Peach | Peach |  |  | Peach | Peach |  | Peach
104 | Hawaii | Melon | Apple |  | Melon |  |  | Melon |  |  | Melon |  | Melon | Melon
105 | California | Berries |  | Berries | Berries |  | Berries | Berries | Berries |  |  | Berries | Berries | Berries | Berries
106 | Idaho | Orange |  |  | Orange |  |  |  |  | Orange |  |  |  |  | Orange
107 | Nevada | [NAME] | Berries |  | Apple | Melon | [NAME] |  |  |  | [NAME] | [NAME]
 | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
Apple | 101 | 104 | 101 | 107 |  |  |  |  |  |  |  |  |  |  |  |  | B
Grape | 102 |  | 102 |  | 103
Peach | 103 |  |  | 103
Melon | 104 |  |  | 104 | 107
Berries | 105 | 107 | 105 | 105
Orange | 106 | 101 |  | 106
[NAME] | 107
 | Only did Sunday to Thursday as example, but would need entire 2 weeks
Spreadsheet: 151876d1335174522-vlookup-help-new-microsoft-office-excel-worksheet
Sheet: Master

Company | Instrument | Grade | Instrument | Grade
[NAME] | Loans | AA | Bonds | BB
abc | Bonds | BB | Loans | AA
Cauvery | Bonds | AA | Loans | BB
Ram | Loans | BB | Bonds | AA
Jai | Bonds | BB | Loans | AA
Spreadsheet: 134072d1324990365-carpenters-use-for-excel-book1_paulo333
Sheet: Sheet1

A | B | C |  | Equispace > | How  many standards? | Spacing c/c | Standard No | Height
935 | 1910 | 2210 |  |  | 2 | 636.6666666666666 | E | 1360
 |  |  |  |  |  |  | F | 1785
D | 2296.459231077269 |  |  |  | N.B
 |  |  |  |  | The first and last centres
E | 475 | 1252.081151832461 |  |  | are
F | 1192.5 | 1731.04057591623 |  |  | Spacing c/c - 1/2 std width
G
H
I
J
K
L
M
N
Spreadsheet: 880431d1728142674-how-to-get-results-in-minutes-cell-n-at-glance-from-sheet-1-to-sheet-2-forum-test
Sheet: Sheet2

NAME | MINUTES by week | MINUTES by month
DOE, [NAME] | [NAME],I,K,M | [NAME],F,K,M
DOE, [NAME] | [NAME],I,K,M | [NAME],F,K,M
DOE, [NAME] | [NAME],I,K,M | [NAME],F,K,M
DOE, [NAME] | [NAME],I,K,M | [NAME],F,K,M
FLORIDA, ANA | [NAME],I,K,M | [NAME],F,K,M
PARIS, ARTHUR | [NAME],I,K,M | [NAME],F,K,M
WASHINGTON, TED | [NAME],I,K,M | [NAME],F,K,M
NOTE:
IT IS LIKE FILTERING
SHEET 1 BUT HAVING
THE RESULTS HERE
IN "MINUTES"
AT GLANCE.
SINCE EACH WORSHEET
HAS ABOUT 40 TO 50 THOUSAND ROWS DOWN.
IMPORTANT:
I has 52 weeks and needs to be individualized
K has only two items (1 and 2), could be different numbers but only two per worsheet
M has 9 different items but could be more
Spreadsheet: cara_semperger__1437__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (18)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  | Mid Columbia Paths
2001-11-18 00:00:00
 | ALL HOURS
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | CHPD GEN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 64614dce-eeec-4837-8fb1-2d5fb565efd1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
267334 | 82871 | [NAME] | [NAME] | EGY |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | [NAME]
Spreadsheet: 216996d1361959117-adding-a-values-from-column-b-which-have-same-values-on-column-a-file
Sheet: T

Valia | 4000
Teresa | 5000 |  |  | Example | [NAME]
[NAME] | 3000 |  | Valia
Martin | 4000 |  | Teresa
Martin | 4650 |  | [NAME]
Carol | 1500 |  | Martin
Valia | 1300 |  | Carol
 |  |  | This is the result I
 |  |  | would like to have
 |  |  | with formulas
 |  |  | And this is my
 |  |  | dificulty
Spreadsheet: 162303d1339788840-counting-with-multiple-criteria-excel-question
Sheet: Sheet1

Event #: | 3 |  | Event # | Registrant ID
# of First Time Regisrants: | ? | (2) | 1 | 100
 |  |  | 1 | 101
 |  |  | 2 | 100
 |  |  | 2 | 102
 |  |  | 3 | 103
 |  |  | 3 | 104
 |  |  | 4 | 101
 |  |  | 4 | 102
Spreadsheet: 795235d1662570051-color-cells-of-one-sheet-based-on-contents-from-multiple-other-sheets-class-schedule
Sheet: Teacher 2

Teacher 2 | Monday | Tuesday | Wednesday | Thursday | Friday
08:00:00 | Free | Free | Free | Free | Free
08:30:00 | Free | Free | Free | Free | Free
09:00:00 | Busy | Free | Busy | Free | Busy
09:30:00 | Busy | Free | Busy | Free | Busy
10:00:00 | Free | Free | Free | Free | Free
10:30:00 | Free | Free | Free | Free | Free
11:00:00 | Free | Free | Free | Free | Free
11:30:00 | Busy | Free | Busy | Free | Busy
12:00:00 | Busy | Busy | Busy | Busy | Busy
12:30:00 | Busy | Free | Busy | Free | Busy
13:00:00 | Free | Free | Free | Free | Free
13:30:00 | Free | Free | Free | Free | Free
14:00:00 | Free | Free | Free | Free | Free
14:30:00 | Busy | Free | Busy | Free | Busy
15:00:00 | Busy | Free | Busy | Free | Busy
15:30:00 | Free | Free | Free | Free | Free
16:00:00 | Free | Free | Free | Free | Free
16:30:00 | Busy | Busy | Busy | Busy | Busy
17:00:00 | Busy | Busy | Busy | Busy | Busy
Spreadsheet: 27483d1220705830-iserror-sumproduct-question-discipline-log-08-09-9-05-8
Sheet: School

Student # | GR | HR | ESE | Last, First | Ethnic | Date | Time | Code | Step | Days/Susp. | Place | C |  | Comment
123456 | 2 | 204 | - | Student 1 |  | 2008-09-04 00:00:00 | 02:55:00 | 2.03 | 1 | - | Hallway | C
56478 | 1 | 1 | - | Student 2 |  | 2008-08-26 00:00:00 | 10:30:00 | 2.03 | 1 | - | Classroom | C
951753 | 4 | 155 | - | Student 3 |  | 2008-09-05 00:00:00 | 10:53:00 | 2.01 | 1 | - | Classroom | C
7727969 | 1 | 127 | - | Student 4 |  | 2008-08-26 00:00:00 | 10:45:00 | 2.03 | 1 | PC | [NAME] | PC | C
08259186 | 4 |  | - | Student 5 |  | 2008-09-03 00:00:00 | 12:10:00 | 2.03 | 1 | - | Classroom | NP | C
10741916 | 3 | 111 | - | Student 6 |  | 2008-08-27 00:00:00 | 11:45:00 | 2.01 | 3 | - | Classroom | PC | C
10741916 | 5 | 111 | - | Student 7 |  | 2008-08-19 00:00:00 |  |  | 1 | -
10741916 | 1 | 111 | - | Student 8 |  | 2008-08-28 00:00:00 | 12:30:00 | 2.03 | 2 | - | [NAME] | * | C
10741916 | K | 111 | - | Student 9 |  | 2008-09-03 00:00:00 | 12:05:00 | 2.01 | 4 | 1 | Classroom | *
9 |  |  |  |  |  |  |  |  | Total = | 1
 | Y08-09 |  | Y08-09 |  |  | PC | Parent Conference |  |  |  | Classroom | 5
Total         = | 0 |  | 0 |  |  | C | Copy sent home |  |  |  | [NAME] | 2
May           = |  | 0 |  | 0 |  | M | Message on machine |  |  |  | Hallway | 1
April          = |  | 0 |  | 0 |  | * | Called parent |  |  |  | Blanks | 3
March        = |  | 0 |  | 0
February   = |  | 0 |  | 0 |  | AP | Action pending
January     = |  | 0 |  | 0 |  | NP | No number or phone
December = |  | 0 |  | 0
November = |  | 0 |  | 0 |  | Present Student, information incomplete
October     = |  | 0 |  | 0
September = |  | 0 |  | 4 |  | Information complete
August       = |  | 0 |  | 5 |  | ESE Student
 |  |  |  |  |  | Student withdrawn
1 | 4 |  |  | [NAME] |  | 2005-12-02 00:00:00 |  | 2.2 | 1 | - | Lunchroom
Spreadsheet: c9fd81b7-0cf1-4a16-b901-307744b6ec86
Sheet: Sheet1

Jaekaubandusettevõtete jaemüügi mahuindeks [NAME] trend, jaanuar 2002 - mai 2012 (2005=100) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Retail trade enterprises retail sales volume index and its trend, January 2002 - May 2012 (2005=100)
 | Kuu | [NAME] mahuindeks, % | Trend, %
 | Month | Retail sales volume index, % | Trend, %
2002 | I | 61 | 69
 | II | 60 | 69
 | III | 66 | 70
 | IV | 68 | 70
 | V | 74 | 71
 | VI | 74 | 71
 | VII | 76 | 72
 | VIII | 76 | 72
 | IX | 73 | 73
 | X | 73 | 73
 | XI | 71 | 73
 | XII | 84 | 74
2003 | I | 66 | 74
 | II | 65 | 75
 | III | 72 | 75
 | IV | 73 | 76
 | V | 79 | 76
 | VI | 81 | 78
 | VII | 84 | 79
 | VIII | 83 | 79
 | IX | 78 | 80
 | X | 84 | 81
 | XI | 78 | 82
 | XII | 95 | 83
2004 | I | 76 | 84
 | II | 73 | 85
 | III | 82 | 86
 | IV | 90 | 87
 | V | 91 | 87
 | VI | 91 | 88
 | VII | 96 | 89
 | VIII | 95 | 91
 | IX | 91 | 92
 | X | 95 | 94
 | XI | 92 | 94
 | XII | 111 | 94
2005 | I | 82 | 94
 | II | 80 | 95
 | III | 92 | 96
 | IV | 95 | 97
 | V | 100 | 97
 | VI | 103 | 98
 | VII | 107 | 99
 | VIII | 106 | 101
 | IX | 100 | 102
 | X | 106 | 104
 | XI | 102 | 106
 | XII | 126 | 108
2006 | I | 98 | 110
 | II | 94 | 111
 | III | 109 | 113
 | IV | 111 | 114
 | V | 120 | 116
 | VI | 124 | 117
 | VII | 127 | 119
 | VIII | 126 | 121
 | IX | 121 | 123
 | X | 127 | 125
 | XI | 124 | 128
 | XII | 148 | 130
2007 | I | 119 | 133
 | II | 115 | 135
 | III | 133 | 136
 | IV | 130 | 136
 | V | 139 | 136
 | VI | 146 | 136
 | VII | 143 | 136
 | VIII | 143 | 136
 | IX | 135 | 137
 | X | 140 | 137
 | XI | 133 | 137
 | XII | 156 | 136
2008 | I | 120 | 136
 | II | 122 | 135
 | III | 129 | 135
 | IV | 131 | 134
 | V | 138 | 133
 | VI | 136 | 131
 | VII | 141 | 130
 | VIII | 136 | 129
 | IX | 125 | 128
 | X | 130 | 126
 | XI | 119 | 124
 | XII | 140 | 122
2009 | I | 107 | 120
 | II | 99 | 118
 | III | 111 | 116
 | IV | 113 | 115
 | V | 116 | 114
 | VI | 121 | 112
 | VII | 118 | 110
 | VIII | 114 | 108
 | IX | 103 | 106
 | X | 108 | 105
 | XI | 99 | 104
 | XII | 119 | 104
2010 | I | 94 | 104
 | II | 89 | 104
 | III | 100 | 105
 | IV | 103 | 105
 | V | 110 | 106
 | VI | 113 | 107
 | VII | 117 | 108
 | VIII | 113 | 108
 | IX | 105 | 108
 | X | 109 | 108
 | XI | 105 | 108
 | XII | 125 | 107
2011 | I | 92 | 106
 | II | 91 | 107
 | III | 105 | 108
 | IV | 107 | 109
 | V | 113 | 111
 | VI | 118 | 112
 | VII | 122 | 113
 | VIII | 120 | 113
 | IX | 110 | 113
 | X | 115 | 114
 | XI | 109 | 115
 | XII | 133 | 116
2012 | I | 106 | 117
 | II | 101 | 118
 | III | 111 | 117
 | IV | 114 | 117
 | V | 122 | 117
Spreadsheet: 51864d1251464026-conditional-formatting-with-a-tolerance-clearance-times
Sheet: Sheet1

Incident Type | Baseline Clearance Time minutes) | October 08 Clearance Times
a | 22 | 25
b | 65 | 65
c | 54 | 76
d | 22 | 30
e | 86 | 32
f | 6 | 4
g | 12 | 24
h | 91 | 25
i | 103 | 104
j | 33 | 43
k | 46 | 20
l | 80 | 116
Spreadsheet: 862841d1710427229-formula-to-take-coil-parameters-and-calculate-length-to-determine-volume-of-oil-coil-wt-and-length-calc
Sheet: scrap calc

 | TO FIND WEIGHT OF A SHEET or SAMPLE: (enter gauge, width and length)
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] x width = Weight
 | nom. | mill |  |  | find
 | gage (in.) | width (in.) | length (in.) | density | weight (lbs)
 | 0 | 0 | 0 | 0.2833
 | TO FIND THE LENGTH OF A COIL or SHEET: (enter gauge, width and weight)
 | nom. |  |  |  | find | find
 | gage (in.) | width (in.) | weight (lbs) | density | length (in.) | length (ft.)
 | 0.582 | 30.881 | 26893 | 0.2833
TO FIND THE WEIGHT LOSS AT THE PICKLE LINE: (enter width and incoming weight):
 |  |  |  |  |  |  | find
 | mill | edge trim | mill |  | trim | pickle | pickle
 | width (in.) | width (in.) | weight (lbs) | dif (in.) | loss (%) | loss (%) | loss (lbs)
 | 0 | 0 | 0 |  |  | 0.005
To Find Yield Weight of a Blanked Coil : (enter length,progression, Blanks per Hit, and weight)
 |  |  |  |  |  | Find Yield
 |  | Coil Length | Progression | Blanks per Hit | Net Piece | Weight
 |  | (in) | (in) |  | Weight | (Lbs)
 |  | 0 | 0 | 0 | 0
Time to Blank Coil : ( Enter Length,Progression, Strokes Per Minute)
 |  |  |  |  |  | Time to
 |  |  | Coil Length | Progression | SPM | Blank Coil
 |  |  | (in) | (in) |  | (Hours)
 |  |  | 0 | 0 | 0
Spreadsheet: 838100d1690715515-user-choice-consolidation-with-hierarchy-applied-result-and-then-given-a-number-dif
Sheet: Sheet1

USERS | User Name
1 | Name
2 | Name
3 | Name
4 | Name
5 | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULT
User choises |  | Difficulty |  |  |  |  | Importance |  |  |  |  | Frequency |  |  |  |  |  | Diff | Imp | [NAME] | Cat
 | Task 1 | Mod | Very | Very | Mod |  | Mod | Very |  | Very | Not | Mod | Mod | Inf | Very | Very
 | Task 2 | Not |  |  |  | Very |  |  | Not |  |  | Mod | Inf | Very
 | Task 3 |  | Very | Mod | Mod |  |  | Mod |  |  |  | Mod | Inf
 | Task 4
Spreadsheet: 268338d1380572477-create-a-average-out-of-cell-of-data-for-certain-days-excel-help
Sheet: Sheet1

2007-08-12 00:00:00 | 8 |  | 2013-08-12 00:00:00
2007-08-13 00:00:00 | 3 |  | 2013-08-13 00:00:00
2007-08-14 00:00:00 | 5 |  | 2013-08-14 00:00:00
2007-08-15 00:00:00 | 2 |  | 2013-08-15 00:00:00
2007-08-16 00:00:00 | 1 |  | 2013-08-16 00:00:00
2007-08-17 00:00:00 | 7 |  | 2013-08-17 00:00:00
2007-08-18 00:00:00 | 99 |  | 2013-08-18 00:00:00
2008-08-12 00:00:00 | 23
2008-08-13 00:00:00 | 356
2008-08-14 00:00:00 | 2534
2008-08-15 00:00:00 | 773
2008-08-16 00:00:00 | 2
2008-08-17 00:00:00 | 26
2008-08-18 00:00:00 | 9
2009-08-12 00:00:00 | 96
2009-08-13 00:00:00 | 4
2009-08-14 00:00:00 | 33
2009-08-15 00:00:00 | 78
2009-08-16 00:00:00 | 8568
2009-08-17 00:00:00 | 568
2009-08-18 00:00:00 | 8568
Spreadsheet: 777453d1650387057-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Pricing (2)

 |  |  |  |  |  |  |  | ns | gs | [NAME] | grw
[NAME] | 3.65 | Waste Factor | 1.6
Thickness | 2
[NAME] | 8 |  |  |  |  |  |  |  | Thickness * Width
Margin | 0.65 |  |  |  |  |  |  |  | Margin * Total Footage / Footage A mplus (calculator in mind)
Set up | 100
Run Charge | 0.55 | Other |  |  |  |  |  |  | Set up / Footage A
Knife Charge | 90 | K Width | 6.5 |  |  |  | [NAME] |  | Run charge
Freight Charge | 0.75 | Freight Cost |  |  |  |  |  |  | other run charge
[NAME] | Glue |  | 0.55 |  | list all items used to calculate this total |  |  |  | determining factor for run charge
Footage A | 800 |  |  |  |  |  |  |  | knife charge * kwidth +0.5 / footage A
Footage + | 30 |  |  |  |  |  |  |  | freight charge / .75 /  total footage
Total footage |  |  |  |  |  |  |  |  | freight charge
Sub total |  |  |  |  | 0 |  |  |  | determing cell for freight
Cells with boxes have drop downs all others are fillable |  |  |  |  | 0
Sell Price |  |  |  |  |  |  |  |  | SUM(G3*I5) |  | cost * (thickness* width)
 |  |  |  |  |  |  |  |  | SUM(I17/12) |  | cost * (thickness* width) /12
 |  |  |  |  |  |  |  |  | sum I18/margin |  | cost * (thickness * width) / 12 / margin
 |  |  |  |  |  |  |  |  | I19*total footage |  | cost * (thickness * width) / 12 / margin * total footage
selection from strip or gross * I5 = / 12 / I6 + I7 = +  I8 + I9 +I10 + C11 needs to be broken up |  |  | Not used |  |  |  | base cost |  | i20/footage a |  | cost * (thickness * width) / 12 / margin * total footage / footage a
+I8+I11+I12+I13+C11) |  |  | Not used |  |  |  |  |  |  |  |  | base cost not rounded
 |  |  | Not used |  |  |  |  |  | [NAME] (run charge determining factor)
 |  |  |  |  |  |  |  |  | I23 + knife charge*width…
Enter footage in cell B12 and enter the additional footage in B13. All cells require input that effect the formulas. There are dropdowns for each category that require you to select one or input their own info. Each blank field with a box outline needs to be filled or left blank
 |  |  |  |  |  |  |  |  | net strip cost sell based on brian numbers |  |  |  | I21  + I8 + I11 + I12 + I15 + D11
Spreadsheet: 209403d1359093936-formulas-in-a-table-that-do-not-change-when-being-sorted-book3
Sheet: Sheet1

Address | CAGR | Unit Price ($ psf) | Contract Date
1 (ENBLOC) [NAME] |  | 1505 | 2010-09-17 00:00:00
1 (ENBLOC) [NAME]  #11-01 ETC |  | 1595 | 2010-12-07 00:00:00
1 Ah Soo Garden |  | 342 | 2005-05-24 00:00:00
1 Akyab Road  #02-01 |  | 367 | 2006-07-14 00:00:00
1 Akyab Road  #02-01 |  | 709 | 2009-08-17 00:00:00
1 Akyab Road  #02-01 |  | 950 | 2011-05-03 00:00:00
1 Akyab Road  #02-02 |  | 990 | 2011-05-04 00:00:00
1 Akyab Road  #03-01 |  | 422 | 2003-10-21 00:00:00
1 Akyab Road  #03-01 |  | 355 | 2005-11-07 00:00:00
1 Akyab Road  #03-02 |  | 403 | 2006-02-02 00:00:00
1 Akyab Road  #03-02 |  | 984 | 2011-04-11 00:00:00
1 Akyab Road  #05-01 |  | 355 | 2005-03-23 00:00:00
1 Akyab Road  #05-02 |  | 598 | 1996-02-27 00:00:00
1 Akyab Road  #06-02 |  | 533 | 1995-08-01 00:00:00
1 Akyab Road  #06-02 |  | 492 | 2001-06-01 00:00:00
1 Akyab Road  #07-01 |  | 760 | 2008-03-17 00:00:00
1 Akyab Road  #09-01 |  | 549 | 1995-09-12 00:00:00