tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18383__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
 | 2000-12-09 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 187.04 | 810 | 148.98 | 1225
 | 2000-12-08 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 287.06 | 1430 | 175 | 390
 | 2000-12-07 00:00:00 |  | 312.11 | 2080 | 205.86 | 2776 | 246.51 | 172 | 138.05 | 519
 | 2000-12-06 00:00:00 |  | 267.18 | 2128 | 177.11 | 1344 | 260.08 | 529 | 151.35 | 911
 | 2000-12-05 00:00:00 |  | 237.02 | 2848 | 119.16 | 904 | 274.6 | 1057 | 172.84 | 1728
 | 2000-12-04 00:00:00 |  | 200.19 | 2080 | 131 | 800 | 227.66 | 1683 | 126.49 | 1488
 | 2000-12-03 00:00:00 |  | 150 | 800 | 118.5 | 0 | 127.99 | 2955 | 109 | 2055
 | 2000-12-02 00:00:00 |  | 148.68 | 1520 | 87.73 | 880 | 123.67 | 845 | 109.6 | 1885
 | 2000-12-01 00:00:00 |  | 148.68 | 1520 | 85 | 480 | 108.93 | 224 | 112.09 | 308
 | 2000-11-30 00:00:00 |  | 180 | 1280 | 85 | 0 | 123.62 | 2347 | 99.02 | 868
 | 2000-11-29 00:00:00 |  | 181.32 | 1520 | 120 | 200 | 136.18 | 765 | 118.06 | 134
 | 2000-11-28 00:00:00 |  | 130 | 240 | 82.5 | 0 | 117.7 | 755 | 108.98 | 215
 | 2000-11-27 00:00:00 |  | 155.42 | 1520 | 95 | 160 | 135.62 | 325 | 83.55 | 1118
 | 2000-11-26 00:00:00 |  | 140 | 240 | 87.5 | 0 | 112.97 | 2230 | 79.79 | 1068
 | 2000-11-25 00:00:00 |  | 142.5 | 960 | 114.53 | 680 | 92.23 | 2784 | 73.71 | 1461
 | 2000-11-24 00:00:00 |  | 142.5 | 960 | 114.53 | 680 | 77.58 | 480 | 54.79 | 349
 | 2000-11-23 00:00:00 |  | 130 | 320 | 101.5 | 0 | 74.14 | 1305 | 56.7 | 786
 | 2000-11-22 00:00:00 |  | 193.67 | 720 | 107.78 | 360 | 114.57 | 1518 | 77.31 | 839
Spreadsheet: 827222d1682556429-turn-horizontally-according-to-the-blank-data-in-column-a-20230427
Sheet: Sheet1

Data1 |  | Data1
Data2 |  | Data2 | Data3
Data3
Data4 |  | Data4
Data5 |  | Data5 | Data6 | Data7
Data6
Data7
Data8 |  | Data8 | Data9 | Data10
Data9
Data10
Data11 |  | Data11 | Data12
Data12
Data13 |  | Data13 | Data14 | Data15 | Data16 | [NAME]
Data14
Data15
Data16
[NAME]
Data18 |  | Data18 | Data19
Data19
Spreadsheet: sara_shackleton__37817__unwind value
Sheet: Sheet1

 |  | December |  |  |  | December Unwind
 |  | Trade Date | 2001-09-28 00:00:00 |  |  | Trade Date | 2001-11-01 00:00:00
 |  | Settle Date | 2001-10-03 00:00:00 |  |  | Settle Date | 2001-11-06 00:00:00
 |  | Expiration Date | 2001-12-31 00:00:00 |  |  | Expiration Date | 2001-12-31 00:00:00
 |  | Final Settle Date | 2002-01-04 00:00:00 |  |  | Final Settle Date | 2002-01-04 00:00:00
 |  | Day Count |  |  |  | Day Count
 |  | Spot Price | 66.571 |  |  | Spot Price | 66.571
 |  | Libor | 0.0259 |  |  | Libor | 0.0225
 |  | Spread | 0.01 |  |  | Spread | 0.01
 |  | Net Fin Rate |  |  |  | Net Fin Rate
 |  | Dividends | 0 |  |  | Dividends | 0
 |  | Gross Fwd Price |  |  |  | Gross Fwd Price
 |  | Financing Premium |  |  |  | Cr Financing Premium
 |  | Transaction fee | 0.005
 |  | Net Fwd Price
 |  | Cr Financing Premium
 |  | Commissions out | 0.01
 |  | Adj Net Fwd Price
 |  | (Early Termination)
 |  | Shares in tranche | 2434339
 |  | Old Notional
 |  | Early Settle Notional
Spreadsheet: 874847d1721360309-answer-questions-regarding-a-range-answer-questions-regarding-a-range
Sheet: Sheet1

B2:P56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count # cells | Result | [NAME]
 | 1 |  | 0 | 0.12 |  |  |  |  |  |  |  |  |  |  |  |  | all cells
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is blank
 | yyy
 |  |  | -20 |  |  |  |  |  |  |  |  |  |  |  |  |  | is not blank
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is error
 |  |  | -12.23 |  |  |  |  |  |  |  |  |  |  |  |  |  | is not error
 | AAA | -100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is formula
 |  |  |  | 123 |  |  |  |  |  |  |  |  |  |  |  |  | is not formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is value, not formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is text
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is text, not formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is not text
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is not zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is positive integer **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is negative integer **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Using SUMPRODUCT in place of SUM to circumvent use of CSE for older Excel versions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** I have to hit CSE with my Excel 2019 - can anyone help to amend the formula to circumvent CSE?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *** To refer range in cell A1, replace "B2:P56" with "INDIRECT(A1)" in formulas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Answer questions regarding a Range
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1426409-answer-questions-regarding-a-range.html
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: HOMELESS

Grant: |  | McKinney-Vento Homeless |  |  |  |  |  |  | McKinney-Vento Homeless
CFDA # |  | 84.196
GRANT NUMBER: |  | 5196
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]-866-6724  [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 274C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - November 15, 2014
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | July  2013 | August  2013 | September  2013 | October  2013 | November  2013 | December  2013 | January  2014 | February  2014 | March  2014 | April  2014 | May  2014 | June  2014 | July  2014 | August  2014 | September  2014
0020 | Adams 12 School District | 33000 |  |  |  |  |  | 303 | 4273 |  | 1887 | 2788 | 2233
0030 | Adams 14 School District | 33000 |  |  |  |  |  |  | 11287 | 2986 | 1445 | 3257 | 3206
0070 | Adams 50 School District | 37000 |  |  |  |  |  | 2425 | 3617 | 3369 | 4503 | 12442 | 3352
0123 | Sheridan School District | 25000 |  |  |  |  |  |  |  |  |  |  | 7620
0180 | Aurora Public School | 36000 |  |  |  |  |  |  | 5678 | 2770 |  | 5817 | 3047
0470 | St. Vrain Valley School District | 34000 |  |  |  |  |  |  |  | 889 | 6381 | 526 | 3922
0480 | Boulder Valley SD | 34000 |  |  |  |  |  |  | 3051 | 5380 | 2308 | 1998 | 3348
0880 | Denver Public Schools | 36000 |  |  |  |  |  |  |  |  |  |  | 17830
1000 | [NAME]. [NAME] | 27500 |  |  |  |  |  | 4207 | 8713 |  | 298 | 2267 | 2266
1420 | Jefferson County School District | 36000 |  |  |  |  |  |  |  |  | 6102 | 8545
1550 | Poudre School Disrict | 36000 |  |  |  |  |  |  |  |  | 2739
2000 | Mesa 51 School District | 37000 |  |  |  |  |  | 3884 | 4694 | 3963 | 2520 | 3077 | 2933
2690 | Pueblo City Schools | 36000 |  |  |  |  |  |  |  | 5000 |  |  | 1096
2790 | Mt. Valley Schools | 9000 |  |  |  |  |  |  |  |  |  |  | 6000
9035 | Centennial BOCES | 39000 |  |  |  |  |  |  | 2950 | 3400 | 3000 | 3000 | 3100
9055 | [NAME] | 33000 |  |  |  |  |  | 9692 | 2642 |  | 2642
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 8943

Checked | Qty | Part# | Colour | Description
 | 4 | 4544140 | White | Rubber Belt Small (Round Cross Section) - Approx. 2 x 2
 | 1 | 4142822 | Black | Technic, [NAME] x 3
 | 1 | 4107824 | Red | Technic, [NAME] x 3 - Axle Holes
 | 1 | 4184169 | Black | Technic, Pin with Friction Ridges and [NAME] with Round Pin Hole
 | 1 | 4211639 | Light Grey | Technic, Axle 5L
Spreadsheet: c4c72a0b-9a89-4d11-8d07-35ad18c00dd1
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Cactus Mobile AS Tvangsavviklingsbo | Granveien 24A | 3115 | [NAME]
[NAME] | Skrautvålsvegen 77 | 2900 | Fagernes
Ucit Nordic AS Konkursbo | [NAME] 36 | 0667 | Oslo
Hamelia AS | Majorstuveien 17 | 0367 | Oslo
Orkan AS | Darres Gate 20 | 0175 | Oslo
Telenor Ukraina II AS | Snarøyveien 30D | 1331 | Fornebu
[NAME] Seime | Oscars Gate 2B | 3725 | Skien
Lb Mobile Ltd | Torggaten 10 | 0181 | Oslo
Bbtele Norge Limited | [NAME] 61 | 0576 | Oslo
Boie Technology Limited | Skjølaasvegen 14 | 2860 | Hov
[NAME] | [NAME] | 0177 | Oslo
Consultant Tele Services Limited |  | 2975 | [NAME]
[NAME] | Snarøyveien 30D | 1331 | Fornebu
G A Installasjon Geir Andersen | Uranusveien 133 | 3055 | [NAME]
Kb Mast AS |  | 3528 | Hedalen
[NAME] | Snarøyveien 30D | 1331 | Fornebu
[NAME] | Snarøyveien 30D | 1331 | Fornebu
[NAME] | Uniongata 33 | 3732 | Skien
[NAME] | Langmyrgrenda 75 | 0861 | Oslo
Tap4taxi | Enebakkveien 164 | 0684 | Oslo
[NAME] | C/O Econpartner AS (Vec) Dr. [NAME] 15 | 0250 | Oslo
[NAME] | [NAME] | 0177 | Oslo
Multiplayer AS Tvangsavviklingsbo | Drammensveien 82 | 0271 | Oslo
Maneo Media AS Konkursbo | Ringeriksveien 191C | 1314 | Vøyenenga
Hamelia AS Tvangsavviklingsbo | Majorstuveien 17 | 0367 | Oslo
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: 844270d1695998949-need-help-with-excel-function-on-a-file-sample-of-how-i-need-it-beamer-
Sheet: Sheet1

2022 |  | Jan | Feb | Mar |  |  |  | 2022 | Import | $ | # |  | Row | Col | 2022 | Import | $ | #
Import |  |  |  |  |  |  |  | January | Trust Receipt Finance | 33451877.58 | 49 |  | 3 | 3
Trust Receipt Finance | Amt | 33451877.58 | 18187058.47 | 43282331.29 |  |  |  | January | Shipping Guarantee | 0 | 0
 | Item | 49 | 44 | 52 |  |  |  | January | Air Release | 0 | 0
Shipping Guarantee | Amt | 0 | 0 | 0 |  |  |  | January | Import Bills Discount | 0 | 0
 | Item | 0 | 0 | 0 |  |  |  | January | Import [NAME] under L/C | 12641899.3 | 28
Air Release | Amt | 0 | 0 | 0 |  |  |  | January | Import [NAME] under L/C | 42425228.32 | 107
 | Item | 0 | 0 | 0 |  |  |  | January | Sets |  | 137
Import Bills Discount | Amt | 0 | 0 | 721391.6 |  |  |  | January | Import L/C Amendments | 2029399.13 | 20
 | Item | 0 | 0 | 6 |  |  |  | January | Import LC Issuance | 26761661.72 | 47
Import [NAME] under L/C | Amt | 12641899.3 | 2279695.29 | 8230828.16 |  |  |  | February | Trust Receipt Finance | 18187058.47 | 44
 | Item | 28 | 27 | 38 |  |  |  | February | Shipping Guarantee | 0 | 0
Import [NAME] under L/C | Amt | 42425228.32 | 38103892.34 | 50027175.94 |  |  |  | February | Air Release | 0 | 0
 | Item | 107 | 80 | 120 |  |  |  | February | Import Bills Discount | 0 | 0
 | Sets | 137 | 102 | 150 |  |  |  | February | Import [NAME] under L/C | 2279695.29 | 27
Import L/C Amendments | Amt | 2029399.13 | 3619788.86 | 3626164.28 |  |  |  | February | Import [NAME] under L/C | 38103892.34 | 80
 | Item | 20 | 26 | 32 |  |  |  | February | Sets |  | 102
Import LC Issuance | Amt | 26761661.72 | 70214989.76 | 30726045.71 |  |  |  | February | Import L/C Amendments | 3619788.86 | 26
 | Item | 47 | 34 | 39 |  |  |  | February | Import LC Issuance | 70214989.76 | 34
Import Totals | Amt |  |  |  |  |  |  | March | Trust Receipt Finance | 43282331.29 | 52
Import Totals including sets | Item |  |  |  |  |  |  | March | Shipping Guarantee | 0 | 0
 |  |  |  |  |  |  |  | March | Air Release | 0 | 0
 |  |  |  |  |  |  |  | March | Import Bills Discount | 721391.6 | 6
 |  |  |  |  |  |  |  | March | Import [NAME] under L/C | 8230828.16 | 38
 |  |  |  |  |  |  |  | March | Import [NAME] under L/C | 50027175.94 | 120
 |  |  |  |  |  |  |  | March | Sets |  | 150
 |  |  |  |  |  |  |  | March | Import L/C Amendments | 3626164.28 | 32
 |  |  |  |  |  |  |  | March | Import LC Issuance | 30726045.71 | 39
Spreadsheet: 115081d1310714302-help-please-monthly-updating-example
Sheet: Overall Staff Summary

Staff Database |  | Updated 4 July 2011
Employee ID Number | Employee Name | Base | Position | Department | Active? | Entry Date | Current Contract Start Date | Contract End Date | Category | Level | Payment Base | Annual Leave Balance pre - 2010 | Annual Leave Earned June 2011 | Annual Leave Taken 2011 | Annual Leave Balance
ALK0001 | Assunta | Alek | [NAME] | WASH | Inactive | 2007-06-01 00:00:00 | 2010-10-18 00:00:00 | 2011-09-30 00:00:00 | Employee | 3 | Alek | 6 | 12 | 6 | 12
ALK0002 | [NAME] | Alek | [NAME] | Administration | Active | 2009-09-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 8 | 12 | 6 | 14
ALK0003 | [NAME] | Alek | [NAME] | Administration | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 0 | 12 | 10 | 2
ALK0004 | [NAME] | Alek | Food Security Outreach Worker | FSL | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 12.5 | 7.5 | 6 | 14
ALK0005 | [NAME] | Alek | Food Security Outreach Worker | FSL | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 8 | 12 | 12 | 8
ALK0006 | Ajith | Alek | Food Security Outreach Worker | FSL | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 20 | 12 | 22 | 10
ALK0007 | [NAME] | Alek | FSL Program Assistant | FSL | Active | 2007-05-07 00:00:00 | 2010-10-01 00:00:00 | 2011-09-30 00:00:00 | Technician | 6 | Alek | 2 | 12 | 10 | 4
ALK0008 | [NAME] | Alek | FSL Program Assistant | FSL | Active | 2007-05-07 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 8 | 12 | 17 | 3
ALK0009 | Santino | Alek | Food Security Outreach Worker | FSL | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 8 | 12 | 0 | 20
[NAME] | [NAME] | Alek | Food Security Outreach Worker | FSL | Active | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Alek | 8 | 12 | 12 | 8
Spreadsheet: 5412f457-63d7-440f-836a-4d823d900e39
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43607305 | 2014-10-16 18:57:01 | AXIS | 1 | 7 | 3 | 1281241 | bougui | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43607562 | 2014-10-16 19:14:20 | ALLIES | 1 | 7 | 3 | 1281241 | bougui | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43632662 | 2014-10-18 15:42:01 | ALLIES | 0 | 0 | 5 | 13513 | Dreexxer | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43633119 | 2014-10-18 16:21:30 | AXIS | 1 | 5 | 2 | 13513 | Dreexxer | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 262894d1378319315-how-to-adjust-salary-advances-of-different-months-against-last-unpaid-month-salary-sample
Sheet: Sheet1

M O N T H S | ETA | ETD | DAYS | L+TRAV DAYS | BASIC | GROSS | CASH ADVANCES |  | AIR /TICK |  | A/DUE | A/PAID | [NAME] | BALANCE  for the month | CUMMULATIVE BALANCE | SUN  DAY | P/MONEY
 |  |  |  |  | [NAME] | [NAME] | DEB./CRED. |  | DEB./CRED. |  |  |  | DATE |  |  |  | 100000
 |  |  |  |  | $ | Salxdays/30 | $ | NAIRA | $ | NAIRA |  |  |  |  |  |  | DUE | PAID | DIFF
J A N U A R Y |  |  | 30 |  | 4000 |  | 0 |  |  |  |  | 0
F E B R U A R Y |  |  | 30 |  | 4000
M A R C H |  | 24.3.13 | 24 |  | 4000
A P R I L |  |  |  |  | 4000
M A Y | 06.05.13 |  | 24 |  | 4000
J U N E |  |  | 30 |  | 4000
J U L Y
A U G U S T
S E P T E M B E R
O CT O B E R
N O V E M B E R
D E C E M B E R
 |  | TOTAL GROSS PAY
Spreadsheet: 877541d1724341184-merging-two-pivot-tables-book1
Sheet: Sheet1

Industry | Name | Code | Loss
1 |  | 1.1 | 1213.11156978085
1 |  | 1.2 | 1062.516350780713
1 |  | 1.3 | 668.608541625004
1 |  | 1.4 | 503.9750037202317
1 |  | 1.5 | 1646.183311325394
2 |  | 2.1 | 1819.408186856528
2 |  | 2.2 | 431.2354048941389
2 |  | 2.3 | 227.7854267872756
2 |  | 2.4 | 1166.539000375104
2 |  | 2.5 | 1964.795923653438
3 |  | 3.1 | 463.5189876958095
3 |  | 3.2 | 1450.109540179994
3 |  | 3.3 | 304.1999795001824
3 |  | 3.4 | 1993.645680490941
3 |  | 3.5 | 995.4858190361699
1 |  | 1.1 | 501.9683356009358
1 |  | 1.2 | 32.36728328410221
1 |  | 1.3 | 937.8393917662678
1 |  | 1.4 | 552.2021479755373
1 |  | 1.5 | 291.4669353384862
2 |  | 2.1 | 102.4001046553472
2 |  | 2.2 | 353.8740126743969
2 |  | 2.3 | 256.2567357474516
2 |  | 2.4 | 99.46490095613647
2 |  | 2.5 | 16.85459754341323
3 |  | 3.1 | 780.4961388492144
3 |  | 3.2 | 641.2513196589981
3 |  | 3.3 | 517.1265620222543
3 |  | 3.4 | 424.905397403487
3 |  | 3.5 | 592.1663067670142
Spreadsheet: 152151d1335274457-pivot-table-count-multiple-data-records-as-one-unic-book1
Sheet: Sheet1

company name | provider | product | value uni
[NAME] | Def | nothing | 200
[NAME] | Leppard | more | 350
[NAME] | Def | nothing | 400
[NAME] | Leppard | more | 100
[NAME] | Gun | more | 1000 |  | Row Labels | Count of company name
[NAME] | DAD | nothing | 240 |  | DAD | 3 | ** only 2 companies by, not 3
[NAME] | DAD | nothing | 50 |  | Def | 4 | ** only 2 companies by, not 4
[NAME] | DAD | more | 240 |  | Gun | 1
[NAME] | Def | more | 190 |  | Leppard | 2
[NAME] | Def | nothing | 170 |  | Grand Total | 10
Spreadsheet: 50928d1250524686-is-there-a-way-to-use-a-referenced-formula-for-different-data-functionproblem2
Sheet: Sheet1

1 | 10 |  |  | subtract |  | add
2 | 20 |  |  |  |  | multiply
3 | 30 |  |  |  |  | subtract
4 | 40 |  |  |  |  | divide
5 | 50
Spreadsheet: 292600d1390680003-faster-way-than-deleting-columns-one-by-one-to-reduce-my-data-to-the-correct-columns-master2-new-example
Sheet: New Data

Timestamp | First name | Guardian Name(s) | [NAME] | Last Name | Phone # (with area code) | Graduation Year | Street Address | Street Address 2 (if applicable) | City | State (two letter) | Zip Code | Departing School | Cumulative School GPA | What is your school's GPA range?
time10 | first10 | guard10 | email10 | last10 | phone10 | year10 | street10 | street2_10 | City10 | State10 | Zip10 | School10 | GPA10 | Range10
time11 | first11 | guard11 | email11 | last11 | phone11 | year11 | street11 | street2_11 | City11 | State11 | Zip11 | School11 | GPA11 | Range11
time12 | first12 | guard12 | email12 | [NAME] | phone12 | year12 | [NAME] | street2_12 | City12 | State12 | Zip12 | School12 | GPA12 | Range12
time13 | first13 | guard13 | email13 | last13 | phone13 | year13 | street13 | street2_13 | City13 | State13 | [NAME] | School13 | GPA13 | Range13
time14 | first14 | guard14 | email14 | last14 | phone14 | year14 | street14 | street2_14 | City14 | State14 | Zip14 | School14 | GPA14 | Range14
time15 | first15 | guard15 | email15 | last15 | phone15 | year15 | street15 | street2_15 | City15 | State15 | Zip15 | School15 | GPA15 | Range15
Spreadsheet: 438661d1452078862-duplication-question-mega-2015-without-trucks
Sheet: JANWk3

DRIVERS WORKING HOURS
W/C:
[NAME] |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
[NAME] |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
[NAME] |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
[NAME] BRACEGIRDLE |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
Saulius GASIUNUS |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
[NAME] |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
Rytis TERVYDIS |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
[NAME] |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTAL
Vehicle Registration:
Start Time:
Finish Time:
Total Hours:
Night Out Y/N:
Holiday Y/N:
Expenses:
Overtime Payments:
Total Work Value:
[NAME]:
 |  |  |  |  |  | Weeks work value total:
 |  |  |  |  |  | Total includes £'s from subbys: |  |  | 0
Spreadsheet: 96750d1296056664-worksheet-lookup-match-and-other-operations-email-s_sheet
Sheet: Sheet1

AAB2
DIMO
ADC4
[NAME]
ADP2
ADP3
[NAME]
ADP5
ADP6
AFN1
AHD3
[NAME]
ALJ1
ALP6
ALP7
ALP9
ALS1
APH1
TMP2
TMP1
MAD5
DPC1
AAM1
AAM1
AAB2
ADP5
ADP6
[NAME]
ALJ1
ALP6
ALP8
ALP9
ALS1
MAD5
SPF21
[NAME]