tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 465734d1465857439-sum-number-range-with-two-sets-of-criteria-listed-with-merged-cells-sum-number-range-with-two-sets-of-criteria-listed-with-merged-cells
Sheet: Data

Created By | Application | # of SRs
[NAME] | Calls | 32
 |  | 46
 |  | 33
 |  | 26
 |  | 24
 |  | 33
 |  | 49
 |  | 26
 |  | 29
 |  | 30
 |  | 38
 |  | 38
 |  | 52
 |  | 31
 |  | 38
 |  | 32
 |  | 36
 |  | 36
 |  | 22
 | Emails | 29
 |  | 11
 |  | 10
 |  | 9
 |  | 5
 |  | 1
 |  | 5
 |  | 4
 |  | 6
 |  | 6
 |  | 8
 |  | 8
 |  | 8
 |  | 10
 |  | 6
 |  | 6
 |  | 6
 |  | 9
 |  | 2
 | Outgoing Calls | 1
 |  | 2
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 4
 |  | 3
 |  | 1
 |  | 3
 |  | 1
 |  | 1
 | Outgoing Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
[NAME] | Calls | 41
 |  | 54
 |  | 27
 |  | 27
 |  | 39
 |  | 26
 |  | 32
 |  | 20
 |  | 29
 |  | 31
 |  | 33
 |  | 24
 |  | 20
 |  | 46
 |  | 22
 |  | 32
 |  | 42
 |  | 32
 |  | 43
 | Emails | 17
 |  | 9
 |  | 3
 |  | 7
 |  | 3
 |  | 3
 |  | 5
 |  | 6
 |  | 10
 |  | 5
 |  | 6
 |  | 7
 |  | 5
 |  | 5
 |  | 9
 |  | 2
 |  | 11
 |  | 5
 |  | 3
 | Outgoing Calls | 1
 |  | 4
 |  | 1
 |  | 2
 |  | 3
 |  | 1
 |  | 2
 |  | 2
 |  | 6
 |  | 7
 |  | 2
 |  | 2
 |  | 4
 |  | 4
 |  | 1
 |  | 2
 |  | 1
 |  | 9
 | Outgoing Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
[NAME] | Calls | 1
 |  | 2
[NAME] | Calls | 19
 |  | 5
 |  | 9
 |  | 14
 |  | 5
 |  | 8
 |  | 7
 |  | 9
 |  | 6
 |  | 8
 |  | 13
 |  | 13
 |  | 16
 |  | 9
 |  | 17
 |  | 15
 |  | 12
 |  | 10
 |  | 11
 | Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 5
 |  | 1
 |  | 1
 | Outgoing Calls | 35
 |  | 79
 |  | 36
 |  | 25
 |  | 24
 |  | 28
 |  | 32
 |  | 27
 |  | 36
 |  | 37
 |  | 29
 |  | 39
 |  | 35
 |  | 20
 |  | 59
 |  | 17
 |  | 33
 |  | 12
 |  | 22
 | Outgoing Emails | 1
 |  | 1
Spreadsheet: 876352d1723038561-check-different-values-over-other-worksheets-crosscheck-etaf
Sheet: Deutschland

Supplier no | Item no | Old Purchase price | Currency | NEW Price | NEW supplier item no | unit price incl 2% discount |  | Schweden | [NAME] | USA |  | Schweden
LT6898 | 5200 | 0.94 | EUR | 0.94 | 1408560 | 0.93
LT6898 | 5201 | 1 | EUR | 1 | 1408561 | 0.98
LT6898 | 5202 | 1.03 | EUR | 1.03 | 1408568 | 1.01
LT6898 | 5203 | 1.09 | EUR | 1.08 | 1408562 | 1.06
LT6898 | 5204 | 1.14 | EUR | 1.22 | 1408572 | 1.12
LT6898 | 5205 | 1.15 | EUR | 1.15 | 1408563 | 1.13
LT6898 | 5206 | 1.21 | EUR | 1.29 | 1408570 | 1.19
LT6898 | 5207 | 1.43 | EUR | 1.43 | 1408564 | 1.41
LT6898 | 5208 | 1.56 | EUR | 1.66 | 1408571 | 1.52
Spreadsheet: 735219d1622767678-creating-a-new-permit-register-permit-register-example-emma-03-06-21-revised
Sheet: Ready to Lodge (LSCO)

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP
 | Address 10 | Description 10 | Client 10 | 001/001/010 | ADMT READY | READY
ABC-21011 | Address 11 | Description 11 | Client 11 | 001/001/011 | READY | READY
ABC-21013 | Address 13 | Description 13 | Client 13 | 001/001/013 | ADMT READY | 0
Spreadsheet: 122710d1317082752-running-total-formula-example-sheet
Sheet: F1

 |  |  | Total should be :
 |  |  | [NAME] total :
 |  |  | Cell G27:G60 contains this formula =IF('[Weekly Sheets.xlsx]W29'!$E$8:$E$10000=0,0,SUM(IF('[Weekly Sheets.xlsx]W29'!$A$8:$A$10000=$D$1,IF('[Weekly Sheets.xlsx]W29'!$D$8:$D$10000="ABS",'[Weekly Sheets.xlsx]W29'!$C$8:$C$10000,'[Weekly Sheets.xlsx]W29'!$E$8:$E$10000))))
 |  |  | 34
 |  |  | 33
 |  |  | 32
 |  |  | 31
 |  |  | 30
 |  |  | 29
 |  |  | 28
 |  |  | 27
 |  |  | 26
 |  |  | 25
 |  |  | 24
 |  |  | 23
 |  |  | 22
 |  |  | 21
 |  |  | 20
 |  |  | 19
 |  |  | 18
 |  |  | 17
 |  |  | 16
 |  |  | 15
 |  |  | 14
 |  |  | 13
 |  |  | 12
 |  |  | 11
 |  |  | 10
 |  |  | 9
 |  |  | 8
 |  |  | 7
 |  |  | 6
 |  |  | 5
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 1 |  |  | 148 | 146 | 150
 |  |  | 34 |  |  | 173 | 152 | 159 | 484
 |  |  | 33 |  |  | 175 | 156 | 144 | 475
 |  |  | 32 |  |  | 130 | 198 | 143 | 471
 |  |  | 31 |  |  | 160 | 144 | 166 | 470
 |  |  | 30 |  |  | 140 | 179 | 151 | 470
 |  |  | 29 |  |  | 169 | 143 | 152 | 464
 |  |  | 28 |  |  | 142 | 156 | 162 | 460
 |  |  | 27 |  |  | 188 | 121 | 146 | 455
 |  |  | 26 |  |  | 131 | 150 | 174 | 455
 |  |  | 25 |  |  | 136 | 148 | 168 | 452
 |  |  | 24 |  |  | 167 | 145 | 139 | 451
 |  |  | 23 |  |  | 119 | 163 | 166 | 448
 |  |  | 22 |  |  | 141 | 157 | 150 | 448
 |  |  | 21 |  |  | 135 | 148 | 165 | 448
 |  |  | 20 |  |  | 152 | 138 | 156 | 446
 |  |  | 19 |  |  | 151 | 155 | 138 | 444
 |  |  | 18 |  |  | 142 | 135 | 158 | 435
 |  |  | 17 |  |  | 126 | 137 | 168 | 431
 |  |  | 16 |  |  | 141 | 160 | 130 | 431
 |  |  | 15 |  |  | 141 | 167 | 118 | 426
 |  |  | 14 |  |  | 159 | 127 | 139 | 425
 |  |  | 13 |  |  | 133 | 145 | 144 | 422
 |  |  | 12 |  |  | 129 | 132 | 161 | 422
 |  |  | 11 |  |  | 127 | 133 | 160 | 420
 |  |  | 10 |  |  | 143 | 135 | 142 | 420
 |  |  | 9 |  |  | 105 | 144 | 169 | 418
 |  |  | 8 |  |  | 144 | 106 | 168 | 418
 |  |  | 7 |  |  | 144 | 140 | 128 | 412
 |  |  | 6 |  |  | 137 | 154 | 116 | 407
 |  |  | 5 |  |  | 103 | 139 | 152 | 394
 |  |  | 4 |  |  | 143 | 119 | 126 | 388
 |  |  | 3 |  |  | 106 | 155 | 115 | 376
 |  |  | 2 |  |  | 116 | 133 | 123 | 372
 |  |  | 1 |  |  | 100 | 144 | 123 | 367
Spreadsheet: 206477d1358196597-dropdown-list-containing-dd-mm-yyyy-nova-planilha-rh_1
Sheet: Horas Extras (Overtime)

Mês/Ano (das [NAME]): |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] preencher todos os campos necessários, salve este arquivo usando seu nome (Save As…) e envie [NAME]) supervisor(a).
Funcionário: |  |  |  | (Seu nome completo)
ATTUID: |  |  |  | (Seu ATTUID)
Cargo: |  |  |  | (Seu cargo)
Horário de Trabalho:
Supervisor: |  |  |  | (Nome completo do supervisor)
Localidade: |  |  |  | (Selecione seu local de trabalho)
 |  | Horário Normal |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Para ser preenchido por RH
 |  | Início | [NAME] | Início | [NAME] | Início | [NAME] | Início | [NAME] | Motivo | Cliente | Servi�o | [NAME]o | Motivo: | Data | Total de Horas | Total de Horas/ 50% | Total de Horas/ 100% | Total de Horas/ Adicional Noturno
[NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A Compensar  Folga
RECONHEÇO A EXATIDÃO DESTAS ANOTAÇÕES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total de Horas:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: | OT Codes: | Services: | Region:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCALIDADE | Holiday | AVPN | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americana - SP | Intrusive LMAC | CS | CALA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LAN Migration | EVPN | EMEA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | GMIS | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Campinas - SP | Other - Customer | MLAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Curitiba - SC | Other - Internal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guarulhos – SP | PMACD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hortol�ndia - SP | Rack & Stack
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Joinville - SC | T&T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Time Zone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio de Janeiro - RJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S�o Paulo - SP
 |  | ______________________________________________________________________
 |  | ASSINATURA DO EMPREGADO
Spreadsheet: 773975d1648140142-sumifs-from-2-dynamic-arrays-sumifs-from-2-dynamic-array
Sheet: Sheet1

Name | Exclude? | 2021 | 2022 | 2023 | 2024 | 2025 |  |  |  |  |  | 2022 | 2023 | 2024 | 2025
[NAME] | Yes | 45 | 44 | 83 | 2 | 95
[NAME] |  | 91 | 38 | 23 | 34 | 74 |  |  |  | [NAME]
Doe | Yes | 45 | 50 | 61 | 77 | 53 |  |  |  | Doe
Doe | Yes | 79 | 72 | 70 | 81 | 62 |  |  |  | [NAME]
[NAME] | Yes | 81 | 74 | 100 | 48 | 22 |  |  |  | [NAME]
[NAME] | Yes | 90 | 81 | 99 | 56 | 93
Doe |  | 65 | 59 | 67 | 47 | 49
[NAME] |  | 29 | 64 | 20 | 98 | 13
Doe |  | 52 | 90 | 69 | 49 | 78
[NAME] | Yes | 19 | 15 | 17 | 77 | 81
[NAME] |  | 11 | 18 | 33 | 19 | 26
Doe | Yes | 26 | 22 | 2 | 10 | 73
[NAME] | Yes | 84 | 17 | 26 | 8 | 69
[NAME] |  | 72 | 46 | 25 | 65 | 36
[NAME] |  | 18 | 69 | 20 | 22 | 27
Spreadsheet: 287577d1388869963-locking-2-rows-then-sorting-by-column-book3
Sheet: Pivot

 | Rank All | Customer | Year | Sum of Sales
 | 1 | BBB | 2010 | 9000
 | 1 | BBB | 2011 | 9200
 | 2 | CCC | 2010 | 3200
 | 2 | CCC | 2011 | 9100
 | 3 | AAA | 2010 | 4000
 | 3 | AAA | 2011 | 4500
 | Grand Total |  |  | 39000
Spreadsheet: 100383d1298759743-excel-2007-two-formula-in-pivot-table-column-jumperanswer
Sheet: Summary

Date | (All)
Site | (All)
Unit | Packaging
Issue | (All)
 | Values
Ticket # | Total Agents Impacted | Total Prod Hours | Length of Outage
19291386 | 11 | 7.33337
19354991 | 13 | 8.7491
19365847 | 10 | 5.25
Grand Total | 34 | 21.33247
Spreadsheet: 125798d1319219057-track-rental-availability-master-template
Sheet: Legend

2011 RENTAL EQUIPMENT LEGEND
REBEL # | TRACKING #
Matts
REBEL1 | 1
REBEL2 | 2
REBEL4 | 4
REBEL5 | 5
REBEL 7 | 7
REBEL 10 | 10
REBEL 11 | 11
REBEL 12 | 12
REBEL 13 | 13
REBEL 14 | 14
REBEL 15 | 15
REBEL 16 | 16
REBEL 18 | 18
REBEL 20 | 20
REBEL 21 | 21
REBEL 22 | 22
REBEL 23 | 23
REBEL 24 | 24
REBEL 27 | 27
REBEL 29 | 29
REBEL 31 | 31
REBEL 32 | 32
REBEL 33 | 33
REBEL 34 | 34
REBEL 35 | 35
REBEL 36 | 36
REBEL 37 | 37
REBEL 38 | 38
REBEL 39 | 39
REBEL 40 | 40
REBEL 41 | 41
REBEL 50 | 50
REBEL 51
REBEL 52
REBEL 53
REBEL 54
REBEL 55
REBEL 56
REBEL 57
REBEL 58
REBEL 59
REBEL 60
REBEL 61
REBEL 62
REBEL 63
REBEL 64
REBEL 65
REBEL 66
REBEL 67
REBEL 68
REBEL 69
REBEL 70
REBEL 71
REBEL 72
REBEL 73
REBEL 74
REBEL 75
REBEL 76
REBEL 77
REBEL 78
REBEL 79
REBEL 80
REBEL 81
REBEL 82
REBEL 83
REBEL 84
REBEL 85
REBEL 86
REBEL 87
REBEL 88
REBEL 89
REBEL 90
REBEL 91
REBEL 92
REBEL 93
REBEL 94
REBEL 95
REBEL 96
REBEL 97
REBEL 98
REBEL 99
REBEL 100
REBEL 101
REBEL 102
REBEL 103
REBEL 104
REBEL 105
REBEL 106
REBEL 107
REBEL 108
REBEL 109
REBEL 110
REBEL 111
REBEL 112
REBEL 113
REBEL 114
REBEL 115
REBEL 116
REBEL 117
REBEL 118
REBEL 119
REBEL 120
REBEL 121
REBEL 122
REBEL 123
REBEL 124
REBEL 125
REBEL 126
REBEL 127
REBEL 128
REBEL 129
REBEL 130
REBEL 131
REBEL 132
REBEL 133
REBEL 134
REBEL 135
REBEL 136
REBEL 137
REBEL 138
REBEL 139
REBEL 140
REBEL 141
REBEL 142
REBEL 143
REBEL 144
REBEL 145
REBEL 146
REBEL 147
REBEL 148
REBEL 149
REBEL 150
REBEL 151
REBEL 152
REBEL 153
REBEL 154
REBEL 155
REBEL 156
REBEL 157
REBEL 158
REBEL 159
REBEL 202 | 202
REBEL 204 | 204
REBEL 160 | 160
REBEL 161 | 161
[NAME] | 162
REBEL 163
REBEL 164
REBEL 165
REBEL 166
REBEL 167
REBEL 168
REBEL 169
REBEL 170
REBEL 171
REBEL 172
REBEL 173
REBEL 174
REBEL 175
REBEL 176
REBEL 177
REBEL 178
REBEL 179
RR1 | 301
RR2
RR3
RR4
RR5
RR6
RR7
RR8
[NAME]
RR10
RR11
RR12
RR13
RR14
RR15
RR16
RR17
RR18
RR19
RR20
RR21
RR22
RR23
RR24
[NAME]
TANKS
REB001 | 401
REB002
REB003
REB004
REB005
REB006
REB007
REB008
REB009
REB010
REB011
REB012
REB013
REB014
REB015
REB016
REB017
REB018
REB019
REB020
REB021
[NAME]
REB023
REB024
REB025
REB026
REB027
REB028
REB029
REB030
REB031
REB032
REB033
REB034
REB035
REB036
REB037
REB038
REB039
Spreadsheet: 864829d1711973930-formula-to-work-out-the-invoice-due-date-sample-data
Sheet: Payment Terms

BP Code | BP Name | Payment Terms Code
S100134 | AA | 90 days EOM
S101445 | CC | 75 Days
S102866 | DD | 28 Days
S104867 | EE | 120 Days EOM
S105099 | MM | 30 Days
S105655 | FF | 30 Days
S106244 | GG | 60 Days EOM
S106623 | HH | 30 days EOM
S106655 | TT | 60 Days
S107877 | JJ | 60 Days
Spreadsheet: 84089d1284075386-determine-large-with-most-recent-data-point-excluded-excel-forum-test-sheet
Sheet: Sheet1

 | Prior | Current | Event | Event Date & Competitor Event Scores
Competitor | Best 8 | Best 8 | Count | 2010-01-01 00:00:00 |  | 2010-02-01 00:00:00 |  | 2010-03-01 00:00:00 |  | 2010-04-01 00:00:00 |  | 2010-05-01 00:00:00 |  | 2010-06-01 00:00:00 |  | 2010-07-01 00:00:00 |  | 2010-08-01 00:00:00 |  | 2010-09-01 00:00:00 |  | 2010-10-01 00:00:00 |  | 2010-11-01 00:00:00 |  | 2010-12-01 00:00:00
Mr A |  |  |  | 300 |  | 300 |  | 300 |  | 300 |  | 300 |  | 300 |  | 400 |  | 400 |  | 400 |  | 400 |  | 0 |  | 0
Mr B |  |  |  | 250 |  | 250 |  | 250 |  | 250 |  | 250 |  | 250 |  | 300 |  | 300 |  | 300 |  | 350 |  | 0 |  | 0
Mr C |  |  |  | 400 |  | 400 |  | 400 |  | 400 |  | 350 |  | 350 |  | 400 |  | 350 |  | 400 |  | 0 |  | 0 |  | 0
 | ^Mr A's value |  |  |  | ^spaces are |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^Mr C |  | ^Event |  | ^Event
 | should be 2700 |  |  |  | intentional as |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | did not |  | has not |  | has not
 |  |  |  |  | the real spreadsheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | attend |  | taken place |  | taken place
 | ^Mr B's value |  |  |  | has more data
 | should be 2150 |  |  |  | separating the |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^Since this is
 |  |  |  |  | score data entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the latest event
 | ^Mr C's value |  |  |  | so individual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this should be the
 | should be 3100 |  |  |  | cell reference |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | one removed from
 |  |  |  |  | is required. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the equation to
 | ^Only the value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calculate previous
 | in column W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | score.  The zero
 | should be |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value by Mr C
 | excluded from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is essentially
 | the total score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | his score and thus
 | as it is the most |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | his previous and
 | recent. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | current score are
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | equal.
 | ^Highlighted cell
 | is where I am
 | looking for a
 | solution
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 4

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
10-9 | 1
 | 2
 | 3
12-11 | 1
 | 2
 | 3
15-16 | 1
 | 2
 | 3
13-14 | 1
 | 2
 | 3
12-11 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 801703d1666329335-how-to-repeat-a-table-to-get-the-highest-score-and-grade-help10-21
Sheet: Sheet2

Item | score | subject | grade |  | subject | highest score | grade
1 | 99 | biology | B |  |  | 99 | D |  |  | 99 | B,D
2 | 83 | language | B |  | language | 99 | B,A |  | language | 99 | B,A
3 | 58 | politics | A |  | politics | 100 | B |  | politics | 100 | B
4 | 100 | math | A |  | math | 100 | A,C |  | math | 100 | A,C
5 | 78 | math | A
6 | 98 | biology | B
7 | 74 | politics | B
8 | 61 | language | A
9 | 99 | language | B
10 | 50 | math | B
11 | 50 | language | A
12 | 77 | politics | A
13 | 75 | biology | A
14 | 62 | math | A
15 | 78 | language | D
16 | 73 | language | A
17 | 100 | politics | B
18 | 57 | language | D
19 | 75 | politics | A
20 | 90 | language | A
21 | 99 | biology | D
22 | 84 | politics | C
23 | 53 | language | C
24 | 92 | language | C
25 | 97 | math | A
26 | 95 | politics | A
27 | 92 | politics | A
28 | 79 | politics | A
29 | 58 | math | A
30 | 99 | math | A
31 | 99 | politics | C
32 | 64 | biology | B
33 | 54 | language | B
34 | 72 | biology | A
35 | 84 | math | A
36 | 74 | biology | A
37 | 74 | math | D
38 | 96 | biology | C
39 | 58 | biology | B
40 | 85 | biology | D
41 | 52 | biology | A
42 | 99 | language | A
43 | 97 | language | D
44 | 60 | politics | C
45 | 76 | language | B
46 | 53 | politics | A
47 | 53 | math | D
48 | 85 | math | A
49 | 55 | math | B
50 | 52 | politics | B
51 | 87 | language | A
52 | 85 | language | A
53 | 93 | language | B
54 | 98 | politics | A
55 | 95 | math | B
56 | 53 | biology | A
57 | 77 | math | B
58 | 56 | politics | A
59 | 90 | biology | A
60 | 73 | math | B
61 | 61 | biology | D
62 | 66 | math | C
63 | 89 | politics | D
64 | 63 | politics | B
65 | 92 | biology | A
66 | 74 | language | C
67 | 78 | biology | C
68 | 93 | biology | A
69 | 57 | biology | C
70 | 66 | language | A
71 | 92 | math | D
72 | 100 | math | C
73 | 59 | language | B
74 | 86 | politics | B
75 | 92 | politics | B
76 | 86 | biology | B
77 | 60 | math | A
78 | 67 | politics | D
79 | 91 | math | B
Spreadsheet: 147024d1332480640-match-value-to-determine-lookup_vector-lookupexample
Sheet: Sheet1

Instrument | Total Movement (in)
E10
E-100A
E-100B
E-100F
E-101A
E-101B
E-101F
E10B
E-110A
E-110B
E-110C
E-110D
E-110F
E-111A
E-111B
E-111C
E-111D
E-111F
E-112A
E-112B
E-112C
E-112D
E-112E
E-112F
E-113A
E-113B
E-113C
Spreadsheet: 274561d1383149961-rearrange-list-in-an-alhabatical-order-book1
Sheet: Sheet1

 |  |  |  |  | a | a
 |  |  |  |  | b | a
 |  |  |  |  | g | b
 |  |  |  |  | f | b
 |  |  |  |  | d | d
 |  |  |  |  | v | d
 |  |  |  |  | g | d
 |  |  |  |  | h | d
 |  |  |  |  | r | d
 |  |  |  |  | d | f
 |  |  |  |  | d | f
 |  |  |  |  | b | g
 |  |  |  |  | n | g
 |  |  |  |  | t | g
 |  |  |  |  | d | h
 |  |  |  |  | a | h
 |  |  |  |  | d | n
 |  |  |  |  | f | r
 |  |  |  |  | g | t
 |  |  |  |  | h | v
Spreadsheet: sally_beck__33769__DEAL BREAKDOWN ANALYSIS 09-06-00 EM
Sheet: FINANCIAL

ENRON North American Gas - EOL vs NON-EOL Analysis
FINANCIAL
LTD
REGION | REGION |  | DEAL COUNT | % OF TOTAL DEAL COUNT | VOLUME | % OF TOTAL VOLUME | NOTIONAL VALUE | % OF TOTAL NOTIONAL VALUE
CENTRAL | EOL |  | 7813 | 78.05194805194805 | 6872022950 | 83.19837659201346 | 3456279659.605 | 70.59001080112104
 | NON-EOL |  | 2197 | 21.94805194805195 | 1387781185 | 16.80162340798654 | 1439993368.802173 | 29.40998919887895
 | TOTAL |  | 10010 |  | 8259804135 |  | 4896273028.407174
EAST | EOL |  | 6094 | 62.27263437563867 | 3169478661 | 44.80261039036417 | 2620439606.37175 | 53.72749032946456
 | NON-EOL |  | 3692 | 37.72736562436133 | 3904838289.25 | 55.19738960963583 | 2256839399.78105 | 46.27250967053546
 | TOTAL |  | 9786 |  | 7074316950.25 |  | 4877279006.1528
ECC-CANADA WEST | EOL |  | 3858 | 59.80468144473725 | 2244783824.559602 | 45.96507755469049 | 5229668608.894831 | 59.5550461452226
 | NON-EOL |  | 2593 | 40.19531855526275 | 2638888615.432908 | 54.03492244530952 | 3551566479.299867 | 40.4449538547774
 | TOTAL |  | 6451 |  | 4883672439.99251 |  | 8781235088.194698
ENA-CANADA EAST | EOL |  | 136 | 81.92771084337349 | 44583300 | 76.52694980801019 | 75417269.3369555 | 62.93327964411576
 | NON-EOL |  | 30 | 18.07228915662651 | 13675000 | 23.47305019198981 | 44419595.615 | 37.06672035588425
 | TOTAL |  | 166 |  | 58258300 |  | 119836864.9519555
G-DAILY-EST | EOL |  | 8153 | 73.57639202238066 | 1747479882 | 62.97425322319149 | 6234240560.98038 | 64.85136021410575
 | NON-EOL |  | 2928 | 26.42360797761935 | 1027431756.5813 | 37.02574677680852 | 3378881724.193179 | 35.14863978589424
 | TOTAL |  | 11081 |  | 2774911638.5813 |  | 9613122285.17356
NG-PRICE | EOL |  | 48441 | 56.28093412338794 | 19285776912 | 31.51994879649774 | 73241537383.8 | 33.40682137925535
 | NON-EOL |  | 37629 | 43.71906587661206 | 41900162939.98 | 68.48005120350226 | 145999726405.7589 | 66.59317862074464
 | TOTAL |  | 86070 |  | 61185939851.98 |  | 219241263789.5589
TEXAS | EOL |  | 3995 | 56.99814524183193 | 1416731500 | 39.65904465124398 | 1611073374.1405 | 55.1334899505457
 | NON-EOL |  | 3014 | 43.00185475816807 | 2155546936 | 60.34095534875602 | 1311058664.998724 | 44.86651004945431
 | TOTAL |  | 7009 |  | 3572278436 |  | 2922132039.139223
WEST | EOL |  | 17769 | 69.1051219227628 | 8387986600 | 59.03711513326609 | 3582122556.324561 | 51.63381354398131
 | NON-EOL |  | 7944 | 30.8948780772372 | 5820002020.489956 | 40.96288486673391 | 3355429234.75772 | 48.36618645601868
 | TOTAL |  | 25713 |  | 14207988620.48996 |  | 6937551791.082281
TOTAL | EOL |  | 96259 | 61.59156930243272 | 43168843629.5596 | 42.31527248993721 | 96050779019.45398 | 37.31740410459143
 | NON-EOL |  | 60027 | 38.40843069756728 | 58848326742.73416 | 57.68472751006279 | 161337914873.2066 | 62.68259589540857
 | TOTAL |  | 156286 |  | 102017170372.2938 |  | 257388693892.6606
Spreadsheet: 124079d1318066900-counting-number-of-agents-without-sales-no-of-agents-with-no-sales
Sheet: Sheet1

 |  |  |  |  |  | 2 | 0 | 1 | 1 |  |  | Number of agents without sales last 3 month
 |  |  | Agent | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
 |  |  | AA | 4283 | 5652 | 5022 | 6936 | 4824 | 4647
 |  |  | BB | 4914 | 6602 | 4120
 |  |  | CC | 6443 | 5279 | 6894 | 6508 | 5250 | 6518
 |  |  | DD | 6299 | 4918 |  |  |  | 5219
 |  |  | EE | 4801 | 6930 | 4599 | 4726 | 4268 | 4794
 |  |  | FF |  |  |  | 5578 | 5159 | 4939
 |  |  | GG |  |  |  | 4970 | 4475 | 5078
Spreadsheet: 6d3a10c0-a047-437a-a8a6-6fbd860172d4
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (2 [NAME]):
 | 8 Medizin/Gesundheitswesen 8.1 Diagnostika 8.1.8 Virologische Diagnostika
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | AID Autoimmun Diagnostika GmbH | Deutschland | Straßberg | 72479 | A2.429
2 | Luminex B.V. | Niederlande | Oosterhout | 4906 CR | A3.311
Spreadsheet: 80359d1280519754-pivot-table-copy-of-calcfield
Sheet: Sheet1

Project | Category | Costs | Acres | [NAME] | Sqft |  |  |  | Sum of Costs_Sqft | Column Labels
A | Site Work | 1000 | 12 |  |  |  |  |  | Row Labels | A | B | Grand Total
A | Flooring | 1000 |  |  | 200 |  |  |  | Site Work | 0 | 0 | 0
A | Roofing | 1000 |  |  | 200 |  |  |  | Flooring | 5 | 3.75 | 4.166666666666667
A | Sheetrock | 2000 |  |  | 200 |  |  |  | Roofing | 5 | 0 | 5
A | HVAC | 3000 |  | 4 | 200 |  |  |  | Sheetrock | 10 | 0 | 10
B | Site Work | 2000 | 18 |  |  |  |  |  | HVAC | 15 | 0 | 15
B | Flooring | 1500 |  |  | 400 |  |  |  | Grand Total | 10 | 8.75 | 9.583333333333334