tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26553__Nov00pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Volume | Rate | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance
2000-11-01 00:00:00 |  |  |  |  |  | 0.1
 |  |  |  |  |  | 0.08
 |  |  |  |  |  | 0.03
 |  |  |  |  |  | 0.05
 |  |  |  |  | 12036 | 0.1
 |  |  |  |  | 34688 | 0.03
 |  |  |  |  |  | 0.03 |  |  |  | 866
 |  |  |  |  |  | 0.1
 | TOTALS
Spreadsheet: 839512d1692037536-marking-the-range-based-on-multiple-conditions-marking-range-based-on-conditions-solution-
Sheet: Hoja1

202330 | 202331 | 202332 | 202333 | 202334 | 202335 | 202336 | 202337 | 202338 | 202339 | 202340 | 202341
 |  | H | H |  | H | H | H |  | H | H
Start | End
202332 | 202333
202335 | 202337
202339 | 202340
Spreadsheet: 770410d1646055327-lookup-value-across-multiple-sheets-and-count-number-of-matching-occurrences-vlookupcount_sample
Sheet: Sheet3

[NAME] | Available from 8.03
[NAME] | On time
Mark | On time
[NAME] | On time
[NAME] | On time
Stephen | On time
[NAME] | On time
[NAME] | Available from 8.04
[NAME] | On time
Mark | On time
[NAME] | Available from 8.01
Spreadsheet: dd996438-bc3b-499d-8651-4e505ac9b142
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 23 April 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
Dry White Bordeaux | - | 2010 | Carbonnieux Blanc | - | 3 | - | 240 | CS | 75cl | 36 | 20
Dry White Bordeaux | - | 1999 | Domaine de Chevalier Blanc | - | 1 | - | 450 | CS | 75cl | 12 | 37.5
Dry White Bordeaux | - | 2012 | Haut Brion Blanc | - | 1 | - | 6700 | CS | 75cl | 12 | 558.33
Dry White Bordeaux | - | 2010 | Latour-Martillac Blanc | - | 3 | - | 220 | CS | 75cl | 36 | 18.33
Dry White Bordeaux | - | 2011 | Mission Haut Brion Blanc | - | - | 6 | 5600 | CS | 75cl | 6 | 466.67
Dry White Bordeaux | - | 2005 | [NAME] | - | - | 6 | 450 | CS | 75cl | 6 | 37.5
Spreadsheet: 125079d1318866688-vlookup-query-vlookup-query-17oct2011
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Team 1 | Team 2 | Team 3
 |  |  |  |  |  |  |  |  | A | [NAME] | [NAME] | [NAME] |  |  | A | 1
 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] |  |  | B | 2
 |  |  |  |  |  |  |  |  | B | [NAME] | [NAME] | [NAME] |  |  | C | 3
 |  | Selection |  |  |  |  |  |  |  | [NAME] | [NAME] | Grace
 |  | Area | A |  |  |  |  |  | C | Pauk | [NAME] | [NAME]
 |  | Team | 2 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  | Names | [NAME]
Spreadsheet: 682320d1592002597-indexing-entire-tables-from-multiple-sheets-in-one-excel-sheet-file-anxious-
Sheet: SHEET4

 | SELECT MONTH | December
 |  |  |  |  |  |  |  |  |  | October
 | PARTICULARS | AMOUNTS(SHS) | AMOUNTS(SHS)2 |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 476845d1472045910-medical-leave-spreadsheet-using-rolling-calendar-year-dropping-hours-used-as-they-roll-off-4-example-of-what-i-was-trying-to-come-up-with-in-excel
Sheet: Employee List

Employee Name | ID | Supervisor
Employee 1 | 1 | Supervisor1
Employee 2 | 2 | Supervisor1
Employee 3 | 3 | Supervisor1
Employee 4 | 4 | Supervisor1
Employee 5 | 5 | Supervisor2
Employee 6 | 6 | Supervisor2
Employee 7 | 7 | Supervisor2
Employee 8 | 8 | Supervisor2
Employee 9 | 9 | Supervisor2
Employee 10 | 10 | Supervisor2
Spreadsheet: 545570d1509554470-variable-data-data-pull-out-request-sites-created-with-different-country-after-spessific-date
Sheet: Sheet1

Customer ID | Customer Name | Country Site | Site creation Date
1111 | [NAME] | USA | 2006-01-01 00:00:00
1111 | [NAME] | USA | 2006-01-01 00:00:00
1111 | [NAME] | USA | 2008-01-01 00:00:00
1111 | [NAME] | Finland | 2017-11-01 00:00:00
2222 | Banana Ice | Canada | 2006-01-01 00:00:00
2222 | Banana Ice | Turkey | 2017-05-01 00:00:00
2222 | Banana Ice | Mexico | 2017-10-10 00:00:00
3333 | [NAME] inc | France | 2006-01-01 00:00:00
3333 | [NAME] inc | France | 2006-01-01 00:00:00
3333 | [NAME] inc | France | 2006-01-01 00:00:00
3333 | [NAME] inc | France | 2006-01-01 00:00:00
 |  |  |  |  |  |  | Example:
 |  |  |  |  |  |  | Customer ID | Country Site | Site creation Date
 |  |  |  |  |  |  | 2222 | Turkey | 2017-05-01 00:00:00
 |  |  |  |  |  |  | 2222 | Mexico | 2017-10-10 00:00:00
Spreadsheet: 07145a43-bee3-4767-ba3c-e2b490f78344
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I-WEST O‘AHU
FALL 1995 TO FALL 2005
 |  |  | TOTAL |  |  |  | Classified  Undergraduates |  |  |  |  |  | Unclassified |  |  |  |  |  | No
FALL SEMESTER |  |  | No. |  | % Chng |  | Subtotal |  | Junior |  | Senior |  | Subtotal |  | Undergrad |  | Grad |  | Data
 | 1995 .............................................. |  | 716 |  | -3.8 |  | 607 |  | 344 |  | 263 |  | 109 |  | 97 |  | 12
 | 1996 .............................................. |  | 648 |  | -9.5 |  | 553 |  | 305 |  | 248 |  | 95 |  | 85 |  | 10
 | 1997 .............................................. |  | 648 |  | 0.0 |  | 577 |  | 354 |  | 223 |  | 71 |  | 69 |  | 2
 | 1998 .............................................. |  | 685 |  | 5.7 |  | 626 |  | 381 |  | 245 |  | 59 |  | 54 |  | 5
 | 1999 .............................................. |  | 687 |  | 0.3 |  | 613 |  | 376 |  | 237 |  | 74 |  | 72 |  | 2
 | 2000 .............................................. |  | 665 |  | -3.2 |  | 621 |  | 328 |  | 293 |  | 44 |  | 43 |  | 1
 | 2001 ............................................. |  | 740 |  | 11.3 |  | 625 |  | 379 |  | 246 |  | 106 |  | 103 |  | 3 |  | 9
 | 2002 ............................................. |  | 834 |  | 12.7 |  | 724 |  | 446 |  | 278 |  | 109 |  | 96 |  | 13 |  | 1
 | 2003  1/ ............................................. |  | 810 |  | -2.9 |  | 636 |  | 274 |  | 362 |  | 43 |  | 43 |  | 0 |  | 131
 | 2004 ............................................. |  | 834 |  | 3 |  | 700 |  | 339 |  | 361 |  | 34 |  | 34 |  | 0 |  | 100
 | 2005  2/ ............................................. |  | 858 |  | 2.9 |  | 800 |  | 384 |  | 416 |  | 29 |  | 29 |  | 0 |  | 29
 | 1/  Migration to a new student registration system took place in Fall 2003.  Unclassified graduate level no longer available.
 | 2/  Headcount for juniors includes records which were coded in IRO Base as freshmen and sophomore ed level.
 | Coding of lower division may have resulted from late input of transfer credits.
Spreadsheet: 761237d1640754327-converting-fiscal-year-month-to-calendar-year-month-cy-to-fy-and-fy-to-cy_excelforum
Sheet: Sheet1

From | To | Begn CYQ | to FYQ | If version |  | From | To | [NAME] | to CYQ | If version
JAN | MAR | 1 |  |  |  | OCT | DEC | 1
APR | JUN | 2 |  |  |  | JAN | MAR | 2
JUL | SEP | 3 |  |  |  | APR | JUN | 3
OCT | DEC | 4 |  |  |  | JUL | SEP | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | start month FY | 9
Build Mon Descr | Begn CYMON_NUM | Build date from month | to FYMON_NUM | If version |  | Build Mon Descr | [NAME] | Build date from month | to CYMON_NUM | If version |  |  |  |  | month in FY | real month |  | quarters
 |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  | NOV | 2 |  |  |  |  |  |  |  | 2 |  |  | 2
 | 3 |  |  |  |  | DEC | 3 |  |  |  |  |  |  |  | 3 |  |  | 3
 | 4 |  |  |  |  | JAN | 4 |  |  |  |  |  |  |  | 4 |  |  | 4
 | 5 |  |  |  |  | FEB | 5 |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  | MAR | 6 |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  | APR | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  | MAY | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  | JUN | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  | JUL | 10 |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  | AUG | 11 |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  | SEP | 12 |  |  |  |  |  |  |  | 12
 |  | I need help figuring out to convert Fiscal year month (and quarter) to calendar year month (and quarter) using mod or similar function. I already know how to do this using the if function. I figured out how to convert CY to FY using mod but for the life of me cannot figure out FY to CY.
 |  | As an example for FY21, which began in 10/1/20 and ended in 9/30/21, CY Q1-4 converts to FY Q4,1,2,3. Refer to the attached xlsx. It includes my formulas for converting CY to FY and my attempts at doing this for FY to CY.
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 1

Financial highlights - Ambev consolidated |  |  | % As | % |  |  | % As | %
R$ million | 4Q10 | 4Q11 | Reported | Organic | YTD 10 | YTD 11 | Reported | Organic
Total volumes | 48038.70816253767 | 48145.48639807903 | 0.002222754100299262 | 0.008737813328277628 | 165142.5236231411 | 165043.9267237374 | -0.0005970412540661219 | 0.00793727439194977
Beer | 34426.62829913615 | 34553.62028230829 | 0.003688772018819009 | 0.01270109809687916 | 119158.5923566581 | 118729.7554027847 | -0.003598875627783715 | 0.007343922704099552
CSD and NANC | 13612.0798634015 | 13591.86611577076 | -0.001484985970813146 | -0.001484985970813264 | 45983.95226648293 | 46314.17132095271 | 0.007181180350834593 | 0.009233014559934655
Net sales | 7455.344000000002 | 8378.441 | 0.1238168218663014 | 0.115577397462591 | 25233.31 | 27126.719 | 0.07503609316415472 | 0.09911128343249244
Gross profit | 5002.923000000003 | 5841.087 | 0.1675348591213572 | 0.1463163489277846 | 16784.263 | 18333.412 | 0.09229770768010481 | 0.1116231183681191
Gross margin | 0.6710519326807725 | 0.6971567860894408 | 260 | 180 | 0.6651629532550426 | 0.6758433262791566 | 110 | 80
EBITDA | 3755.064 | 4492.650000000001 | 0.1964243485597053 | 0.2326400228666182 | 11590.123 | 13164.187 | 0.1358108106359179 | 0.161998331255169
EBITDA margin | 0.503674143003998 | 0.5362155083505392 | 330 | 510 | 0.4593183771768349 | 0.4852848956779476 | 260 | 260
Normalized EBITDA | 3822.003 | 4506.141999999999 | 0.1790001211406687 | 0.2139381853227869 | 11707.032 | 13141.083 | 0.1224948389993297 | 0.1483344214388994
Normalized EBITDA margin | 0.512652803143624 | 0.5378258317985408 | 250 | 440 | 0.4639514990304482 | 0.4844331892847049 | 200 | 210
Profit - Ambev holders | 2585.798000000003 | 3032.492 | 0.1727489927674153 |  | 7561.397000000003 | 8640.996000000003 | 0.1427777168689859
Normalized profit - Ambev holders | 2652.326000000003 | 3045.984 | 0.1484199151989603 |  | 7712.222000000002 | 8617.892000000003 | 0.1174330821908396
No. of share outstanding (millions) | 3103.22882 | 3117.189202 |  |  | 3103.22882 | 3117.189202
EPS (R$/shares) | 0.8332605005904795 | 0.9728289826149603 | 0.1674968175325451 |  | 2.436622446681197 | 2.772047328553528 | 0.1376597684754963
Normalized EPS | 0.8546988165700276 | 0.9771572409033388 | 0.1432766981294609 |  | 2.485225050210768 | 2.764635523076601 | 0.1124286401515777
Spreadsheet: 816093d1675362081-lookup-array-in-a-match-function-book1
Sheet: Sheet1

Employee Name | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
A | 446 | 387 | 983 | 801 | 59 | 794 | 547 | 10 | 485 | 649 | 741 | 558 | 441 | 380
B | 569 | 519 | 616 | 57 | 313 | 642 | 545 | 862 | 68 | 225 | 92 | 909 | 255 | 101
C | 721 | 280 | 142 | 535 | 297 | 660 | 55 | 896 | 492 | 718 | 402 | 910 | 163 | 156
D | 825 | 989 | 792 | 592 | 721 | 151 | 361 | 710 | 254 | 617 | 766 | 849 | 376 | 315
E | 922 | 148 | 918 | 88 | 219 | 137 | 336 | 371 | 128 | 560 | 173 | 512 | 637 | 997
F | 289 | 641 | 133 | 777 | 948 | 430 | 1000 | 896 | 75 | 735 | 316 | 211 | 489 | 365
G | 526 | 469 | 646 | 522 | 818 | 337 | 649 | 219 | 116 | 313 | 519 | 816 | 206 | 206
H | 125 | 569 | 143 | 500 | 818 | 596 | 988 | 315 | 987 | 284 | 41 | 248 | 493 | 521
I | 178 | 80 | 966 | 78 | 629 | 523 | 345 | 857 | 773 | 861 | 70 | 623 | 18 | 914
J | 61 | 241 | 471 | 981 | 17 | 619 | 738 | 300 | 631 | 195 | 92 | 443 | 505 | 381
K | 363 | 614 | 446 | 691 | 397 | 619 | 602 | 49 | 508 | 588 | 724 | 216 | 702 | 340
L | 986 | 723 | 765 | 674 | 745 | 626 | 214 | 644 | 83 | 579 | 43 | 233 | 955 | 760
M | 948 | 929 | 731 | 248 | 561 | 142 | 395 | 122 | 449 | 413 | 778 | 749 | 236 | 300
Value | 1000
Position |  | [NAME])
 |  | =MATCH(B17,H1:H14,0)
Spreadsheet: 141631d1329380097-i-need-the-total-sum-either-text-or-number-in-a-cell-if-posibble-sum-else-text
Sheet: Sheet1

x | x | x | x | x
4 | 4 | 4 | 4 | 4
3 | 3 | 3 | 3 | 3
m/c | m/c | m/c | m/c | m/c
Spreadsheet: 162307d1339789533-cross-categorize-product-data-who-can-help-with-this-cross-cat-example
Sheet: Products

NAME | Part Number | [NAME] | RETAIL_PRICE | URL
Speaker #1 | 1 | This is #1 | 100 | www.example.com/amp1
Speaker #2 | 2 | This is #2 | 20 | www.example.com/amp2
Speaker #3 | 3 | This is #3 | 300 | www.example.com/amp3
Spreadsheet: 125409d1319021994-forumla-help-vlookup-clarusd
Sheet: Sheet1

AGENT | [NAME]
TFER | OD | REF | SOLD | OUTCOME
ODS X-fer | Ade | 2050577 | Sold | Sold
ODS X-fer | Fahmida | 2052004 | Not Sold | Drop on transfer, called back but not available
ODS X-fer | Jon | 1972129 | Not Sold | financail adviser
ODS X-fer | Jon | 2051311 | Not Sold | Does not match criteria - Unsuitable creditors
ODS X-fer | Jon | 2051380 | Sold | Sold
ODS X-fer | [NAME] | 2051904 | Sold | Sold
ODS X-fer | Manny | 2051336 | Call Back | Call back 19/10/11 at 7.30pm
ODS X-fer | Nosheel | 2051271 | Sold | Sold
Spreadsheet: 140733d1328876440-referencing-and-using-data-already-calculated-book2
Sheet: Sheet1

LENGTH | No REQD | STOCK LENGTH | FROM 1 | TOTAL LENGTH REQUIRED PER BAR | NEEDED | TYPICAL R | NON TYPICAL R1 | NON TYPICAL R2 (1 off) |  |  |  |  |  |  |  |  |  | TOTAL LENGTH
9270 | 14 | 10000
9251 | 2 | 10000
9210 | 8 | 10000
8632 | 1 | 10000
8613 | 1 | 10000
7800 | 13 | 10000
5506 | 1 | 10000
5259 | 8 | 10000
3403 | 13 | 10000
2561 | 1 | 10000
1896 | 13 | 10000
1032 | 9 | 10000
803 | 13 | 10000
516 | 13 | 10000
306 | 13 | 10000
179 | 9 | 10000
TOTALS
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: INTV

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 |  |  |  | 90 | 70
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 1

 | December 20 | December 27 | January 3 | January 10 | January 17
Total Interest Rate* | 368660208 | 367274928 | 342535726 | 345289146 | 342354081
Cleared** | 224410384 | 223388590 | 199536842 | 202604498 | 202151426
Uncleared | 144249824 | 143886338 | 142998884 | 142684648 | 140202655
Total Cross-Currency | 14012142 | 14137477 | 14341303 | 14384232 | 14188171
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 14012142 | 14137477 | 14341303 | 14384232 | 14188171
Total Credit | 8870927 | 8580339 | 8561452 | 8794206 | 8700274
Cleared | 2066271 | 2032736 | 2018663 | 2036194 | 2004391
Uncleared | 6804656 | 6547603 | 6542789 | 6758012 | 6695883
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 429113277 | 427562744 | 403008481 | 406037584 | 402812526
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 838242d1690847994-dynamic-column-for-index-match-match-formula-index-match-match-example-tms-v2
Sheet: Sheet2

Customer 3
 |  | Code | Description
 |  | 4-Person Crew
 |  | 5-Person Crew
 |  | 6-Person Crew
 |  | 4-Person Crew
Spreadsheet: 0d1abfe3-6d81-424d-9af0-4b66511a1fd1
Sheet: Sheet1

Sex Offense Offenders | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Forcible Rape
Sex and Race
by Age, 2011
Age | Total Offenders1 | Sex |  |  | Race
 |  | Male | Female | Unknown | White | Black | American Indian/ Alaskan Native | Asian/Pacific Islander | Unknown
Total | 28455 | 26950 | 800 | 705 | 16689 | 8891 | 229 | 163 | 2483
15 and under | 1917 | 1798 | 100 | 19 | 1177 | 610 | 12 | 7 | 111
16 – 20 | 5797 | 5641 | 143 | 13 | 3663 | 1802 | 55 | 31 | 246
21 – 25 | 4525 | 4401 | 111 | 13 | 2808 | 1500 | 41 | 30 | 146
26 – 30 | 3207 | 3083 | 117 | 7 | 1988 | 1045 | 26 | 21 | 127
31 – 35 | 2477 | 2389 | 86 | 2 | 1569 | 798 | 24 | 11 | 75
36 – 40 | 2076 | 1996 | 75 | 5 | 1338 | 637 | 19 | 15 | 67
41 – 45 | 1648 | 1595 | 46 | 7 | 1068 | 504 | 17 | 6 | 53
46 – 50 | 1384 | 1344 | 26 | 14 | 865 | 435 | 12 | 16 | 56
51 – 55 | 818 | 800 | 15 | 3 | 515 | 273 | 2 | 6 | 22
56 – 60 | 497 | 482 | 13 | 2 | 331 | 140 | 4 | 5 | 17
61 – 65 | 228 | 221 | 7 | 0 | 160 | 51 | 3 | 4 | 10
66 and over | 281 | 269 | 4 | 8 | 213 | 41 | 4 | 0 | 23
Unknown Age | 3600 | 2931 | 57 | 612 | 994 | 1055 | 10 | 11 | 1530
1Does not include 1,433 incidents with Unknown Offenders.
Spreadsheet: 160609d1339140193-counting-total-quantity-for-a-group-of-variables-sample
Sheet: Taul1

 | Class | Quantity |  | Class | Total Quantity
 | 1 | 1123 |  | 1
 | 1 | 12 |  | 2
 | 2 | 421 |  | 3
 | 3 | 425
 | 1 | 612
 | 2 | 123
 | 3 | 526
 | 1 | 212
 | 2 | 521
 | 2 | 678
Spreadsheet: 356716d1415192784-help-needed-in-data-sorting-new-microsoft-office-excel-worksheet
Sheet: Sheet1

 |  | marks | English | Maths | Science | Social Science
 |  | 10 | [NAME] | [NAME] | Broody | [NAME]
 |  | 20 | [NAME] | [NAME] | [NAME] | [NAME]
 |  | 30 | [NAME] | Billy | [NAME] | [NAME]
 |  | 40 | [NAME] | [NAME] | [NAME] | Billy
 |  | 50 | Billy | [NAME] | [NAME] | [NAME]
 |  | 60 | [NAME] | Rambo | Billy | [NAME]
 |  | 70 | [NAME] | kelsey | [NAME] | Rambo
 |  | 80 | Rambo | Broody | [NAME] | kelsey
 |  | 90 | kelsey | [NAME] | Rambo | Broody
 |  | 100 | Broody | [NAME] | kelsey | [NAME]
Spreadsheet: 98930d1297743258-display-data-in-graphs-base-on-selected-priority-book1_select_priority
Sheet: Sheet1

 |  |  | Activity1 |  | Activity2 |  | Activity3 |  | Activity4 |  | Activity5 |  | Activity6 |  | Activity7
Name | ID | Priority | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual
 |  | P1 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-11 00:00:00
 |  | P1 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-11 00:00:00
 |  | P1 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-12 00:00:00
 |  | P1 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-15 00:00:00
 |  | P1 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-17 00:00:00
 |  | P1 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-21 00:00:00
 |  | P1 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-20 00:00:00
 |  | P2 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-19 00:00:00
 |  | P2 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-25 00:00:00
 |  | P2 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-27 00:00:00
 |  | P2 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-02-02 00:00:00
 |  | P2 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-22 00:00:00
 |  | P2 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-02-04 00:00:00
 |  | P2 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-11 00:00:00
 |  | P2 | 2011-02-01 00:00:00 |  | 2011-02-11 00:00:00
 |  | P3 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-12 00:00:00
 |  | P3 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-15 00:00:00
 |  | P3 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-17 00:00:00
 |  | P3 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-21 00:00:00
 |  | P3 | 2011-02-10 00:00:00 |  | 2011-02-20 00:00:00
 |  | P3 | 2011-02-11 00:00:00 |  | 2011-02-21 00:00:00
 |  | P3 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-20 00:00:00
 |  | P3 | 2011-02-07 00:00:00 |  | 2011-02-17 00:00:00
Spreadsheet: 805121d1668533704-return-multiple-certifications-completed-and-sum-of-certifications-in-separate-columns-need-formula
Sheet: Trained

EMP ID | First Name | Course attended | Course Certified | Certified Date
20291 | Vijay V | SC-900
20291 | Vijay V | SC-200
20291 | Vijay V | SC-300
20291 | Vijay V | SC-400
20291 | Vijay V | SC-100
20291 | Vijay V | AZ-900
20292 | Kiran Kumar | AZ-900
20292 | Kiran Kumar | SC-900
20293 | Madhu | MS-500
20293 | Madhu | SC-900
21534 | Hemanth | SC-300
21534 | Hemanth | SC-400
21534 | Hemanth | SC-100
21534 | Hemanth | AZ-900
21534 | Hemanth | MS-500
Spreadsheet: 824573d1680683501-transferring-data-from-other-sheets-to-main-sheet-sample-3
Sheet: Data

Task ID | Delivery # | Start | End | Volume
T1 | 1 | 07:09:00 | 07:33:00 | 12
T1 | 2 | 07:55:00 | 08:24:00 | 12
T1 | 3 | 08:28:00 | 08:54:00 | 12
T2 | 1 | 08:59:00 | 09:10:00 | 12
T2 | 2 | 09:20:00 | 09:32:00 | 12
T3 | 1 | 09:34:00 | 09:42:00 | 10
T4 | 1 | 09:50:00 | 10:00:00 | 10
T4 | 2 | 10:02:00 | 10:07:00 | 10
T4 | 3 | 10:10:00 | 10:40:00 | 10
T4 | 4 | 10:48:00 | 11:10:00 | 10
T5 | 1 | 02:34:00 | 02:47:00 | 12
Spreadsheet: john_lavorato__16558__East Schedule C LCRA 9-30-00
Sheet: Schedule C - LCRA

SCHEDULE C
DOCUMENTATION FORM
ITEM |  | DATA
Transaction or Book Name |  | EPMI-LT-ERCOT
Amount |  | -2968598
Entry Date |  | 2000-09-01 00:00:00
Reason for Using Schedule C (e.g., income adjustment) |  | Reserve for ERCOT transmission
Removal Date |  | as actual transmission is incurred
(If amortization is required, attach the appropriate
amortization schedule)
Methodology for Removal (e.g., amortization or one time removal) |  | amortization
Individual Using Schedule |  | [NAME]
Trader/Structuring |  | Business Analysis & Reporting
Energy Operations |  | [NAME]