tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 751090d1633869002-find-the-maximum-value-of-which-subject-is-the-score-of-different-subjects-excelhelp1010
Sheet: Sheet1

Name | subject | score | Table 1
sela | math | 94
hellen | math | 100 |  |  |  | Table2
[NAME] | math | 85 |  | Name | subject | score
dee | math | 99 |  | hellen,zucca | math
zucca | math | 100 |  | sela | Language
sela | Language | 96 |  | dee,zucca | English
hellen | Language | 81 |  | [NAME] | physics
[NAME] | Language | 81 |  | [NAME] | Chemical
dee | Language | 84 |  | [NAME] | politics
zucca | Language | 81
sela | English | 86
hellen | English | 96
[NAME] | English | 99
dee | English | 100
zucca | English | 100
sela | physics | 86
hellen | physics | 84
[NAME] | physics | 91
dee | physics | 86
zucca | physics | 83
sela | Chemical | 80
hellen | Chemical | 81
[NAME] | Chemical | 100
dee | Chemical | 86
zucca | Chemical | 92
sela | politics | 85
hellen | politics | 94
[NAME] | politics | 97
dee | politics | 95
zucca | politics | 80
Spreadsheet: a2bfde3b-11b8-476e-9f3e-b15fdcc42c1a
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Redningstjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Falck Terje Jakobsen Redning Dykkertjeneste | [NAME] | 1621 | Gressvik | 69 33 43 23
JS Dykkerservice [NAME] | [NAME] 70 | 4260 | Torvastad | 52 73 67 31
Stenvolds Undervannsservice | Eidvegen 413 | 9105 | Kvaløya | 957 20 320
Dykknor AS | Fearnleys gate 10 | 9900 | Kirkenes | 942 96 726
Redningshytten på [NAME] | [NAME] 4B | 5012 | Bergen | 55 90 04 30
Mekonomen | Lilleelvgata 34 | 3915 | Porsgrunn | 35 56 56 00
Møre Dykkerservice AS | Digernes | 6160 | Hovdebygda | 907 60 258
[NAME] AS | Nothjellvegen 6 | 9403 | Harstad | 77 06 10 01
Falck (Bilbjørn Redning AS) | [NAME] 262 | 3176 | Undrumsdal | 905 54 500
NAF Bilberging | Gamle Ravei 260 | 3270 | Larvik | 08505
Kragerø Sjøtjenester AS | [NAME] | 3770 | Kragerø | 459 04 966
[NAME] | [NAME] | 3117 | [NAME] | 33 31 08 88
[NAME] | Rådhusgata 1 | 3210 | Sandefjord | 33 46 63 50
Røde Kors Hjelpekors Sandefjord | Rådhusgata 1 | 3210 | Sandefjord | 33 46 30 78 | 33 47 33 75
Nordkapp Dykkerservice | Storgata 15 | 9750 | [NAME] | 913 66 605
[NAME] Atle Torvanger | Industrivegen 7 | 6900 | Florø | 57 74 24 85
Blindheim Slep AS | Bjorøyneset 32 | 5177 | Bjørøyhamn | 913 54 331
Bø Bilberging | [NAME] 382 | 3803 | Bø i Telemark | 971 77 000
Boa Offshore AS | Pir II nr 13A | 7010 | Trondheim | 73 99 11 99 | 73 99 11 98
Viking Halden | [NAME] 19 | 1788 | Halden | 69 17 54 90
Sør-Varanger Dykkerservice | Jakobsnes | 9900 | Kirkenes | 78 99 22 20
Sjøteknologi AS | Håkonshellaveien 223 | 5174 | Mathopen | 55 50 92 97
NAF Veitjenester |  | 5363 | Ågotnes | 951 93 090
Dykkersystem Trond Eidsten | Åsnesgrenda | 2270 | Flisa | 906 97 263
Redning Redningsselskapet - Norsk Selskab til Skibbrudnes | Strandvegen 7B | 9990 | Båtsfjord | 78 98 34 98
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 765545d1643382703-finding-a-wanted-value-in-cells-above-example
Sheet: Sheet1

 | The Highlighted labels are what AF needs to equal when AF is located underneath them
 | Given | Expected Results |  | Given | Expected Results
 | MB | MB |  | ARP | ARP |  | COUNTIF((INDIRECT(ADDRESS(ROW()-1,COLUMN()))),"MB"),"MB")
 | TR | TR |  | TR | TR
 | TR | TR |  | TR | TR |  | I had been using this as my equation but when the TR gets inbetween the ARP/MB and the AF this equation no longer works :(
 | AF | MB |  | AF | ARP
 | AF | MB |  | AF | ARP
 | AF | MB |  | AF | ARP
 | Another clarification is that this is a small portion of a long list of abbreviations. The equation I need will be used with a fill handle. The equation needs to recognize the AF in the Given and look up to see what it needs to equal for the result.
Spreadsheet: 481786d1474643593-how-to-write-a-macros-to-compare-to-columns-and-match-amounts-but-this-is-a-bit-more-tricky-ap-ar-balancing-test
Sheet: Sheet3

-551.16 |  | -7495.08
-826 |  | -922.72
-4268.72 |  | -2000
-1238.98 |  | -909.23
-2308 |  | -803
-3477 |  | -17157
-579 |  | -1883
-1351 |  | -1959.98
-1883 |  | -3063
-1367 |  | -3065
-3063 |  | -551.16
-1669 |  | -2636.09
-1408 |  | -826
-17157 |  | -2308
-144 |  | -10148.45
-826 |  | -1387.44
-803 |  | -10712.17
-52242 |  | -2000
3896 |  | -500
-3896 |  | -3477
826 |  | -5625.39
-317.2 |  | -39825.71
-387.5 |  | -4054.28
-909.23 |  | -606.01
-1387.44 |  | -144
-1672.63 |  | -1500
-4054.28 |  | -52242
-350.03 |  | -1669
-941.71 |  | -9459.66
-606.01 |  | -2585.49
-500 |  | -27375.83
11555.36 |  | -5822.19
-11555.36 |  | -1408
-203.44 |  | -2584.84
-1959.98 |  | -2660.52
-10712.17 |  | -2000
-120451.83 |  | -3122.96
-5625.39 |  | -2774.01
-2636.09 |  | -5414.2
-5822.19 |  | -2000
-4082.93 |  | -350.03
-1331.27 |  | -2000
-2774.01 |  | -1672.63
-3122.96 |  | -579
-2720.64 |  | -1238.98
-2080 |  | -200
-21082.18 |  | -640.42
-39825.71 |  | -7100
-9459.66 |  | -1250.22
-2660.52 |  | -1466.37
-10350 |  | -2720.64
-7100 |  | -387.5
-7495.08 |  | -21082.18
-640.42 |  | -24541.83
-10148.45 |  | -24519.96
-922.72 |  | -23523.75
-27377.87 |  | -24264.9
-1691.78 |  | -24213.42
-2600 |  | -23478.48
-1125 |  | -1315.86
-1600 |  | -2080
-2000 |  | -4268.72
-23478.48 |  | -7325
-24264.9 |  | -10350
-23523.75 |  | -1691.78
-864.08 |  | -3680
-24519.96 |  | -864.08
-24541.83 |  | -120451.83
-3680 |  | -941.71
-1250.22 |  | -203.44
-1466.37 |  | -2731
-24213.42 |  | -1351
-2000 |  | -317.2
-2585.69 |  | -1367
-2000 |  | -651.41
-200 |  | -500
-1500 |  | -1000
-2000
-2000
-500
-2000
-2584.84
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: SEPTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | Gross P/L | PIPS | DEPOSITS & WITHDRAWALS
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | TOTAL PIPS | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 744518d1629283626-highlight-date-range-on-calendar-399
Sheet: CAT Service Parts

CAT Service Parts
Code | Item | Unit £ | 3099 |  |  | 3099
P785394 | Air filter,  [NAME] | 79.09 | 1
P785395 | Air filter,  Safety | 32.5 | 1
SOS001P | Kit (1) | 17.98 | 1
1R-0749 | Filter AS FU | 25.72 | 2
1R-1808 | Filter AS-LU | 40.97 | 1
220-8678 | Seal | 0.76 | 1
308-1476 | Deo-ULS 10W-30 20L | 61.09 | 4
317-3081 | Deo-ULS 10W-30 4L | 15.26
326-1643 | Filter AS | 52.32 | 1
 | Element AS | 86.34
 | Element AS | 106.24
119-5152 | Anti | 11.58
326-4690 | Element | 51.23
COOL001 | Coolant | 17.29
 | Environmental charge | 14.98 |  |  |  | 14.98
 |  |  |  | Total Service Parts
CAT | Site | Transport / Travel | Serv Labour
Bristol | Crappers | 100 | 300
Winsford | Core | 231.12 | 350
Mileage | 1.46
Labour Weekday | 87.5
Saturday | 105
Travel | 58
TNT delivery charge | 50
Spreadsheet: 777749d1650576059-sum-of-values-in-column-based-on-unique-ids-in-another-column-test24
Sheet: Sheet1

ID | Total Tokens |  | Unique ID's with more than 1 token - Combined Total | 9
141508273044 | 1 |  | 4 unique ID's where Total Tokens > 1
144375885015 | 1
144375885015 | 1
147890650046 | 1
147890650046 | 1
159777699038 | 1
159777699038 | 1
162153917032 | 2
168131196045 | 1
168131196045 | 1
168539305040 | 1
168615082562 | 1
172888341044 | 2
172888341044 | 2
175149526048 | 1
175149526048 | 1
177907246041 | 1
181653732014 | 1
186048215567 | 2
186048215567 | 2
188146635563 | 3
188437741567 | 1
Spreadsheet: 887664d1737969805-find-and-sort-nearest-date-testing
Sheet: Monthly Ledger

Date | ID | Member [NAME] | Monthly Contribution | Late Days | Late Fee | Total Contribution | Loan ID | Loan Date | Need to Pay Intalment | [NAME] 2% | Intrest Paid Date | Late Intrest Days | Intrest Late Fee | [NAME] | [NAME] | Total Amount
Spreadsheet: 146582d1332262533-excel-2007-need-help-with-formula-book1
Sheet: fresh plant

Room 20 |  |  |  |  |  |  | Room 21
Empire |  |  | Romes |  |  |  | Empire
Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer |  | Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The receiver numbers came from the march page, but for room 20 I need
 |  |  |  |  |  |  |  |  |  |  |  |  |  | them to go to either empires or romes depending on which column they are in
 |  |  |  |  |  |  |  |  |  |  |  |  |  | on the march page.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | When I enter in a receiver number on the march page I want it to transfer to the
 |  |  |  |  |  |  |  |  |  |  |  |  |  | room which in this case is 20 and then depending on the variety transfer to the
 |  |  |  |  |  |  |  |  |  |  |  |  |  | column that is for them(empire or romes)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Right now I can get them to transfer to the room but I need them to sort by variety
 |  |  |  |  |  |  |  |  |  |  |  |  |  | too.
Total | 842 | 0 | Total | 567 | 553 |  | Total | 842 | 0 | Total | 567 | 553
Spreadsheet: 08c04032-0b6c-47b3-b038-6fa840d65f8a
Sheet: 2-Non-Grant Budget Detail

Expelled and At Risk Student Services Grant Budget
DISTRICT AND NON DISTRICT FUNDING BUDGET DETAIL
District/BOCES:
School:
Facility:
 | THIS WORKSHEET IS PROTECTED AND WILL NOT ALLOW SORTING OR INSERTING/DELETING ROWS
1 | 2 | 3 | 4 | 5 | 6
Program | Budget Object | District/Non Dist | Funding Year | Cost | Description
District and Non District Funding must be included for all four years of grant.  REQUIREMENT:  Each of the four years must be entered together for that year.  An example on Row 12 provides an allowable expenditure with the appropriate level of detail required for the Description.
Instructional Program | Salaries (0100) | District | (ALL FOUR YEARS MUST BE ENTERED)     Year1 | 25000 | .5  FTE Behavior Interventionist at ABC High School that will be supplemented by the EARSS grant.
Spreadsheet: 3e24fa34-a37f-4953-bff7-b440ec1d26cd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8214 | 60604 | Dominic | Rohan-Gates | GBR | 110 | 0:34:38 | 0:01:19 | 4:27:48 | 0:01:51 | 2:11:54 | 1 | 7:17:33
8214 | 51804 | Carles | [NAME] | ESP | 105 | 0:37:32 | 0:01:59 | 4:25:58 | 0:01:43 | 2:13:51 | 2 | 7:21:04
8214 | 57070 | [NAME] | [NAME] | NED | 114 | 0:33:41 | 0:01:13 | 4:36:37 | 0:01:26 | 2:10:20 | 3 | 7:23:18
8214 | 57197 | Jacco | Langerak | NED | 108 | 0:37:16 | 0:01:50 | 4:32:21 | 0:01:46 | 2:15:43 | 4 | 7:28:58
8214 | 63603 | Sascha | Wenzel | GER | 111 | 0:35:07 | 0:01:30 | 4:37:21 | 0:01:59 | 2:20:36 | 5 | 7:36:35
8214 | 63717 | [NAME] | [NAME] | RSA | 112 | 0:42:15 | 0:01:32 | 5:03:52 | 0:01:40 | 2:52:18 | 6 | 8:41:39
Spreadsheet: 71612d1272377168-sum-data-on-dupilcate-names-sample-data
Sheet: Sheet1

Emp | Start date | Term Date | 07 earnings | 08 earning | 09 earnings |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 25000 | 85000 | 86855 |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 8960 | 554 | 55 |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 68000 | 5500 | 554 |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 100 | 50 | 8700 |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 65000 | 8000 | 8000 |  |  |  |  |  |  | [NAME]
[NAME] |  |  | 9800 | 10100 | 120000
[NAME] |  |  | 8500 | 8500 | 8500
[NAME] |  |  | 10500 | 120000 | 150000
[NAME] |  |  | 7500 | 7500 | 8500
[NAME] |  |  | 10100 | 10100 | 10100
[NAME] |  |  | 50 | 20 | 20
[NAME]
Spreadsheet: 219611d1362814106-formula-to-identify-the-excess-usage-based-on-life-cycle-of-the-material-purchased-book1
Sheet: Sheet1

Year | Existing | In | Out | Total Manpower | Purchased
2005 | 120 |  |  |  | 120
2006 |  | 2 | 6 |  | 10
2007 |  | 5 | 3 |  | 15
2008 |  | 10 | 2 |  | 20
2009 |  | 8 | 1 |  | 25
2010 |  | 2 | 6 |  | 33
2011 |  | 3 | 8 |  | 22
2012 |  |  | 6 |  | 15
Spreadsheet: 876db03c-6b7c-43aa-9786-4893d62fa3f0
Sheet: Reference Cut-points

Baseline Data for AECS, 2009-11
 | PERCENTILE
Measure | 40th | 60th | 90th
3 Year CSAP Reading -  % Prof/Adv.
E | 16.7% | 29.4% | 31.6%
M | 15.5% | 21.4% | 46.7%
H | 26.7% | 35.4% | 54.8%
3 Year CSAP Writing - % Prof/Adv.
E | 12.3% | 14.3% | 35.3%
M | 8.4% | 16.7% | 32.1%
H | 10.0% | 14.6% | 28.6%
3 Year CSAP Math - % Prof/Adv.
E | 15.0% | 15.5% | 17.7%
M | 6.2% | 10.0% | 34.0%
H | 2.0% | 4.4% | 9.4%
3 Year CSAP Science - % Prof/Adv.
E | 16.8% | 37.0% | 43.8%
M | 8.0% | 12.1% | 44.0%
H | 10.8% | 16.4% | 30.3%
3 Year CSAP Reading - MGP
E | NA | NA | NA
M | 35.6 | 43.2 | 58
H | 41.2 | 46.8 | 57.4
3 Year CSAP Writing - MGP
E | N/A | N/A | N/A
M | 34 | 35.8 | 52.8
H | 38.6 | 43.4 | 57.2
3 Year CSAP Math - MGP
E | N/A | N/A | N/A
M | 25 | 31.8 | 57.6
H | 33.6 | 42 | 50.6
Completion Rate
Best of 4, 5, 6, 7yr | 44.2% | 55.4% | 70.9%
Graduation Rate
Best of 4, 5, 6, 7yr | 30.7% | 39.9% | 65.3%
3 Year Drop-out Rate
H | 17.7% | 11.4% | 4.6%
3 Year ACT Composite Score
H | 14.9 | 15.5 | 16.6
Attendance
ADA Rate | 81.3% | 86.2% | 92.5%
Truancy
[NAME] | 12.1% | 7.7% | 0.8%
Spreadsheet: 868617d1715300717-fishing-club-sheet-formula-help-index-broe-comp-sheet-chads-new-edit
Sheet: SunFig

Sussex Inlet Bowling Club Fishing Club B.R.O.E.
 |  |  |  |  |  |  | SUNDAY |  | date & year:
Bream |  | Drummer |  | Dusky |  | Flathead |  | Leatherjacket |  | Ludrick |  | Morwong |  | Salmon |  | Snapper |  | Tailor
Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm)
435 | 20 | 291 | 45 | 294 | 110 | 331 | 96 | 297 | 103 | 277 | 93 | 358 | 60 | 342 | 96 | 342 | 71 | 367 | 42
368 | 24 | 294 | 37 | 453 | 65 | 408 | 113 | 272 | 25 | 319 | 31 | 251 | 72 | 481 | 36 | 301 | 20 | 286 | 70
254 | 100 | 280 | 105 | 470 | 91 | 437 | 77 | 355 | 111 | 433 | 91 | 375 | 27 | 349 | 109 | 373 | 37 | 446 | 51
358 | 19 | 250 | 103 | 487 | 19 | 440 | 95 | 469 | 30 | 343 | 67 | 342 | 60 | 361 | 120 | 345 | 12 | 362 | 78
374 | 91 | 345 | 119 | 376 | 68 | 416 | 92 | 467 | 91 | 450 | 96 | 474 | 69 | 494 | 24 | 480 | 12 | 478 | 91
255 | 62 | 377 | 5 | 327 | 110 | 461 | 79 | 431 | 109 | 407 | 96 | 409 | 43 | 417 | 18 | 392 | 108 | 384 | 93
258 | 99 | 299 | 5 | 316 | 120 | 265 | 3 | 490 | 86 | 439 | 88 | 436 | 33 | 251 | 26 | 476 | 66 | 484 | 78
299 | 77 | 495 | 79 | 297 | 11 | 368 | 4 | 260 | 105 | 329 | 92 | 331 | 29 | 285 | 28 | 497 | 36 | 431 | 60
334 | 17 | 492 | 23 | 376 | 51 | 467 | 32 | 422 | 117 | 310 | 28 | 317 | 79 | 483 | 2 | 384 | 71 | 454 | 67
454 | 95 | 315 | 75 | 481 | 3 | 325 | 120 | 281 | 32 | 329 | 89 | 411 | 27 | 426 | 85 | 403 | 92 | 340 | 34
331 | 99 | 478 | 112 | 436 | 13 | 349 | 79 | 293 | 95 | 260 | 75 | 411 | 43 | 352 | 92 | 446 | 20 | 443 | 83
388 | 112 | 309 | 106 | 411 | 119 | 431 | 7 | 273 | 93 | 440 | 63 | 440 | 61 | 333 | 48 | 378 | 114 | 424 | 9
271 | 85 | 361 | 108 | 426 | 69 | 500 | 89 | 250 | 118 | 320 | 101 | 253 | 91 | 359 | 74 | 280 | 88 | 434 | 35
428 | 9 | 329 | 29 | 488 | 32 | 316 | 85 | 255 | 62 | 368 | 26 | 316 | 73 | 461 | 77 | 337 | 13 | 499 | 41
331 | 3 | 253 | 52 | 485 | 12 | 254 | 49 | 382 | 97 | 331 | 29 | 341 | 112 | 369 | 69 | 405 | 105 | 462 | 53
280 | 73 | 459 | 40 | 422 | 58 | 378 | 52 | 252 | 83 | 434 | 89 | 418 | 54 | 451 | 73 | 388 | 36 | 407 | 20
352 | 20 | 321 | 104 | 366 | 106 | 321 | 30 | 481 | 60 | 436 | 112 | 399 | 48 | 432 | 39 | 478 | 68 | 350 | 31
401 | 62 | 398 | 91 | 443 | 22 | 396 | 105 | 333 | 46 | 290 | 15 | 437 | 60 | 308 | 17 | 393 | 21 | 420 | 91
Spreadsheet: 143360d1330379780-displaying-different-data-types-on-same-graph-book1
Sheet: Sheet1

 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00
Blue | 11 | 3 | 6 | 3 | 9
Red | 5 | 12 | 7 | 3 | 4
Green | 3 | 6 | 12 | 8 | 6
White | 4 | 4 | 12 | 11 | 3
Yellow | 11 | 12 | 4 | 3 | 3
Orange | 12 | 10 | 4 | 10 | 4
Mean
[NAME]
Spreadsheet: 775087d1648818080-simplifying-a-vlookup-or-suggest-a-better-formula-sample-data
Sheet: TYPE 1

 |  | Other Value not required 1 | Other Value not required 2 | VALUE
1 | [NAME] |  |  | 1
2 | DATA2 |  |  | 2
3 | DATA3 |  |  | 3
4 | DATA4 |  |  | 4
5 | DATA5 |  |  | 5
6 | DATA6 |  |  | 6
7 | DATA7 |  |  | 7
8 | DATA8 |  |  | 8
9 | DATA9 |  |  | 9
10 | DATA10 |  |  | 10
Spreadsheet: 155952d1337113233-vlookup-problem-with-multiple-criteria-vlookup-problem
Sheet: Sheet1

ABC
2011-06-01 00:00:00
2011-06-15 00:00:00
2011-09-30 00:00:00
DEF
2011-06-01 00:00:00
2011-06-15 00:00:00
2011-09-30 00:00:00
GHI
2011-06-01 00:00:00
2011-06-15 00:00:00
2011-09-30 00:00:00
Column1 | Date | Y/N
ABC | 2011-06-01 00:00:00
DEF | 2011-06-09 00:00:00
XYZ | 2011-09-30 00:00:00
DEF | 2011-09-30 00:00:00
ABC | 2011-06-13 00:00:00
Spreadsheet: 11c5e348-fa4f-4322-8deb-80b9693a858a
Sheet: OneClick Audiobooks

OneClickdigital Audiobooks 2014
 | Collection Size |  | Patrons |  | Circulations |  | Top Book
 | Total Titles | Total Copies | Total | New | Total | Daily Average | By Checkout | By Holds
January | 4791 | 10152 | 20554 | 399 | 12992 | 419 | Fifty Shades of Grey | Takedown Twenty
February | 4851 | 10594 |  | 290 | 11909 |  | Fifty Shades of Grey | Takedown Twenty
March |  | 10831 |  | 368 | 13068 |  | Takedown Twenty | The Chase
April |  | 11318 |  | 254 | 12932 |  | Takedown Twenty | Divergent
May | 5162 | 11632 |  | 273 | 13137 |  | Takedown Twenty | Divergent
June | 5550 | 11946 |  | 299 | 13721 |  | The Target (baldacci) | Divergent
July |  |  |  | 294 | 14342 |  | Gone Girl | Top Secret Twenty-One
August * | 5599 | 12769 |  | 218 | 14054 |  | Fifty Shades of Grey | Top Secret Twenty-One
September | 5626 | 12812 |  | 216 | 13550 |  | The Chase (Evanovich & Goldberg) | Personal (Child)
October | 5697 | 12927 |  | 231 | 13370 |  | The Chase (Evanovich & Goldberg) | Personal (Child)
November | 5731 | 12986 |  | 225 | 12822 |  | Mockingjay | Gray Mountain (Grisham)
December
Year to date
Notes
*Collection includes multiuse titles.  These have unlimited simultaneous checkouts per title, but are reflected as 1 in the copies tally as of August 2014.
 | Type of multiuse book: |  |  |  | Titles #
 | Titles on one year lease/subscription |  |  |  | 400
 | Modern Scholar series (multiuse, no expiration) |  |  |  | 67
Collection Size blanks -- OCD has had a number of issues with this report recently, and completely rebuilt the report in September.
Spreadsheet: 164133d1340655427-excel-2007-need-help-pulling-info-from-several-tabs-into-one-final-tab-orders
Sheet: Thur

STORE # | 22
STORE | LOUIE |  |  |  |  | Date: | 2012-06-21 00:00:00
ORDER # | 689
# of Pages | 4
Puller | WM |  |  | QA | TH |  |  | Stacker | HH |  |  |  | TOTAL
Start | 06:15:00 |  |  | Start | 06:45:00 |  |  | Start | 06:30:00 |  |  |  | 0.4999999999999996
End | 06:25:00 |  |  | End | 06:50:00 |  |  | End | 06:45:00
Total | 0.1666666666666661 |  |  | Total | 0.08333333333333304 |  |  | Total | 0.2500000000000004
 | Over Pack | Full Case | Total
Units | 45 | 134
Lines | 3 | 10
Cartons | 1 | 33 | 34
STORE # | 23
STORE | DEWEY
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 24
STORE | PLUTO
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 25
STORE | GOOFY
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
Spreadsheet: 765631d1643440271-vlookup-number-of-items-to-person-item-distirbution-
Sheet: Sheet1

Name |  | Salary | Leave | Sick | Items
[NAME] | Adam | 28 | 0 | 0 | 1 | Boat |  |  |  |  | 3 | Car A | 2 | Wire A | 4 | Laptops
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Wire C | 3 | Computers
Smith | [NAME] | 35 | 1 | 5 |  |  |  |  |  |  | 7 | Car B | 5 | Wire A | 5 | Laptops
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Wire B | 10 | Computers
 |  |  |  |  |  |  |  |  | 3 | Bikes
Do | [NAME] | 50 | 2 | 3 |  |  |  |  |  |  | 2 | Car B | 3 | Wire C | 2 | Tablets
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Laptops
Desired Results
Laptops | Bob(4),Smith(5),Do(3)
Computers | Bob(3),Smith(10)
Tablets | Do(2)
Wire A | Bob(2),Smith(5)
Wire B | Smith(7)
Wire C | Bob(4),Do(3)
Car A | Bob(3)
Car B | Smith(7),Do(2)