tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75184d1275693089-dynamic-charts-on-excel-book1
Sheet: Sheet1

Data | Description | Details | Credit | Debit | TOTAL | 171 | 728.05 | 557.05
2007-12-06 00:00:00 | Levantamento |  | 40 |  | 40
2007-12-06 00:00:00 | Alimentaçao | Restaurant |  | 20 | 20
2007-12-08 00:00:00 | Alimentaçao | Restaurant |  | 25 | -5
2007-12-08 00:00:00 | Alimentaçao | Coffee Shop |  | 5 | -10
2007-12-09 00:00:00 | Alimentaçao | Coffee Shop |  | 5 | -15
2007-12-09 00:00:00 | Viagens | Rental |  | 21.5 | -15
2007-12-09 00:00:00 | Viagens | Tickets |  | 8.2 | -15
2007-12-09 00:00:00 | Outros | Tickets |  | 31.5 | -15
2007-12-09 00:00:00 | Viagens | Tickets |  | 4.5 | -15
2007-12-09 00:00:00 | Alimentaçao | Restaurant |  | 15 | -15
2007-12-10 00:00:00 | Viagens | Rental |  | 9.17 | -15
2007-12-10 00:00:00 | Recebi | Pay | 60 |  | 45
2007-12-10 00:00:00 | Viagens | Rental |  | 84.4 | 45
2007-12-10 00:00:00 | Other | Trip |  | 53 | 45
2007-12-10 00:00:00 | Other | Trip |  | 12.95 | 45
2007-12-10 00:00:00 | Viagens | Rental |  | 5 | 40
2007-12-10 00:00:00 | Alimentaçao | Coffee Shop |  | 8 | 32
2007-12-10 00:00:00 | Telecomunicaçoes | Other |  | 7.5 | 32
2007-12-10 00:00:00 | Viagens | Rental |  | 12.5 | 19.5
2007-12-10 00:00:00 | Alimentaçao | Restaurant |  | 14.5 | 5
2007-12-10 00:00:00 | Telecomunicaçoes | Other |  | 7.5 | 5
2007-12-10 00:00:00 | Entretendimento | Bar |  |  | 5
2007-12-11 00:00:00 | Alimentaçao | Restaurant |  | 6 | -1
2007-12-11 00:00:00 | Alimentaçao | Restaurant |  | 8 | -9
2007-12-11 00:00:00 | Entretendimento | Bar |  | 5 | -14
2007-12-11 00:00:00 | Alimentaçao | Restaurant |  | 5 | -19
2007-12-11 00:00:00 | Levantamento |  | 40 |  | 21
2007-12-11 00:00:00 | Alimentaçao | Restaurant |  | 10 | 11
2007-12-11 00:00:00 | Entretendimento | Bar |  | 4 | 7
2007-12-11 00:00:00 | Entretendimento | Bar |  | 18.5 | 7
2007-12-12 00:00:00 | Telecomunicaçoes | Other |  | 7.5 | -0.5
2007-12-12 00:00:00 | Outros | Other |  | 29.99 | -0.5
2007-12-12 00:00:00 | Alimentaçao | Coffee Shop |  | 6.36 | -0.5
2007-12-12 00:00:00 | Outros | other 2 |  | 27.9 | -0.5
2007-12-12 00:00:00 | Outros | other2 |  | 7.9 | -0.5
2007-12-12 00:00:00 | Alimentaçao | Restaurant |  | 8.8 | -0.5
2007-12-12 00:00:00 | Viagens | rental |  | 45.15 | -0.5
2007-12-12 00:00:00 | Viagens | Rental |  | 18.69 | -0.5
2007-12-12 00:00:00 | Alimentaçao | Restaurant |  | 3.5 | -4
2007-12-12 00:00:00 | Viagens | Rental |  | 12.5 | -16.5
2007-12-13 00:00:00 | Outros | other |  | 34.8 | -16.5
2007-12-13 00:00:00 | Outros | Other |  | 5 | -16.5
2007-12-13 00:00:00 | Outros | other2 |  | 94.5 | -16.5
2007-12-13 00:00:00 | Outros | Other2 |  | 6.9 | -16.5
2007-12-13 00:00:00 | Alimentaçao | Restaurant |  | 4.85 | -16.5
2007-12-14 00:00:00 | Outros | other2 |  | 4.99 | -16.5
2007-12-14 00:00:00 | Outros | other2 |  | 2 | -18.5
2007-12-18 00:00:00 | Recebi |  | 20 |  | 1.5
2007-12-18 00:00:00 | Recebi |  | 11 |  | 12.5
Spreadsheet: 491832d1480651885-tidy-exported-file-for-use-in-formulas-and-workings-sample
Sheet: What I Need

Name, Name | Department A |  |  |  | 12/11/2015 | 1.05 | 21.492 | 10
Name, Name | Department A |  |  |  | 18/12/2006 | 9.95 | 21.8707 | 20.5
Name, Name | Department A |  |  |  | 29/07/1996 | 20.34 | 21.8707 | 19.5
Name, Name | Department B |  |  |  | 20/10/1993 | 23.11 | 32.4026 | 36
Name, Name | Department B |  |  |  | 21/02/2005 | 11.77 | 21.8707 | 18
Name, Name | Department B |  |  |  | 04/07/2003 | 13.41 | 21.8707 | 28
Name, Name | Department B |  |  |  | 09/08/1993 | 23.31 | 29.4921 | 26.5
Name, Name | Department B |  |  |  | 15/05/2005 | 11.55 | 21.8707 | 22.5
Name, Name | Department B |  |  |  | 24/10/2005 | 11.10 | 21.8707 | 22.5
Name, Name | Department B |  |  |  | 22/12/2003 | 12.94 | 21.8707 | 35
Name, Name | Department B |  |  |  | 04/09/2000 | 16.24 | 21.8707 | 12.5
Name, Name | Department B |  |  |  | 26/10/2009 | 7.10 | 21.8707 | 35
Name, Name | Department B |  |  |  | 24/11/2008 | 8.02 | 21.8707 | 23
Name, Name | Department B |  |  |  | 21/05/2007 | 9.53 | 21.8707 | 27.75
Name, Name | Department B |  |  |  | 24/07/2006 | 10.35 | 21.8707 | 13
Name, Name | Department B |  |  |  | 13/11/2000 | 16.05 | 21.8707 | 28
Name, Name | Department B |  |  |  | 04/07/2005 | 11.41 | 24.3786 | 36
Name, Name | Department C |  |  |  | 12/11/2015 | 1.05 | 21.492 | 10
Name, Name | Department C |  |  |  | 18/12/2006 | 9.95 | 21.8707 | 20.5
Name, Name | Department C |  |  |  | 29/07/1996 | 20.34 | 21.8707 | 19.5
Department : 82, Town Centre
Spreadsheet: 3d63a74f-a6ce-4d42-829d-4ae913be3e58
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Finance: Financial and Investment Planning
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Financial and Investment Planning Pathway of the Finance [NAME]) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Financial and Investment Planning Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Accountant ►Brokerage Clerk ►Commodities Representative ►Development Officer ►Financial Analyst ►Financial Planner ►Foundation Manager ►Fund Manager ►Fund Raiser ►Investment Advisor ►Mutual Fund Manager ►Non-Profit Manager ►Personal Financial Advisor ►Planned Giving Director ►Sales Agent ►Securities Representative ►Tax Preparer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 34759d1232082583-extracting-rows-of-data-suggestedforumsolution
Sheet: Yellow

Name | Stat B | Stat C | Stat D | Stat E | Stat F | Stat G | Stat H | Stat I | Stat J | Stat K | Stat L | Stat M
Yellow | Stat B Row 3 | Stat C Row 3 | Stat D Row 3 | Stat E Row 3 | Stat F Row 3 | Stat G Row 3 | Stat H Row 3 | Stat I Row 3 | Stat J Row 3 | Stat K Row 3 | Stat L Row 3 | Stat M Row 3
Spreadsheet: gerald_nemec__11552__Sierra Pacific Power
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY: | [NAME]
DATE: | 2001-03-29 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Sierra Pacifc Power Company | CONTACT:
ADDRESS: | 6100 Neil Rd | TITLE:
 | Reno, NV 89151-0002 | PHONE:
 |  | FAX:
INCORPORATION STATE: | NV | S&P RATING: | BBB+
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | $10MM | $10MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | $15MM
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | $20MM
-Guarantor ($[NAME]) |  | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | D.Vanek | x31436
Spreadsheet: 847173d1698228459-how-can-compile-data-in-a-desired-format-test1-1
Sheet: Sheet1

What I have
 |  |  | ! | @ | # | $
 | 1 | A | 0.01 | 1.3 | 0.25 | 0.21
 |  | B | 0.32 | 0.55 | 0.2 | 1.2
 |  | C | 3 | 0.22 | 1.2 | 1.6
 |  | D
 |  | E
 | 2 | A | 0.33 | 2 | 1 | 0.39
 |  | B | 0.52 | 0.41 | 0.69 | 0.22
 |  | C | 2.3 | 0.66 | 0.88 | 3.2
 |  | D
 |  | E
 | 3 | A | 0.52 | 0.66 | 0.85 | 0.22
 |  | B | 2 | 2.4 | 0.35 | 0.89
 |  | C | 0.74 | 0.12 | 0.78 | 0.65
 |  | D
 |  | E
What I need
 |  | A |  |  |  | B |  |  |  | C
 |  | ! | @ | # | $ | ! | @ | # | $ | ! | @ | # | $
 | 1 | 0.01 | 1.3 | 0.25 | 0.21 | 0.32 | 0.55 | 0.2 | 1.2 | 3 | 0.22 | 1.2 | 1.6
 | 2 | 0.33 | 2 | 1 | 0.39 | 0.52 | 0.41 | 0.69 | 0.22 | 2.3 | 0.66 | 0.88 | 3.2
 |  | A | A | A | A | B | B | B | B | C | C | C | C
 |  | ! | @ | # | $ | ! | @ | # | $ | ! | @ | # | $
 | 1 | 0.01 | 1.3 | 0.25 | 0.21 | 0.32 | 0.55 | 0.2 | 1.2 | 3 | 0.22 | 1.2 | 1.6
 | 2 | 0.33 | 2 | 1 | 0.39 | 0.52 | 0.41 | 0.69 | 0.22 | 2.3 | 0.66 | 0.88 | 3.2
 | 3 | 0.52 | 0.66 | 0.85 | 0.22 | 2 | 2.4 | 0.35 | 0.89 | 0.74 | 0.12 | 0.78 | 0.65
Spreadsheet: ed3d45e6-1d2a-460e-aec9-1c89f64c0716
Sheet: TableS3

Table S3. Alternative start sites.
Transcribed Region ID | Left Coordinate | Right Coordinate | Strand (+/-) | Experimentally Identified TSS (y/n)
RTS_M_1175972_1176045 | 1175972 | 1176045 | - | n
RTS_M_1268638_1268737 | 1268638 | 1268737 | - | y
RTS_M_1297154_1297280 | 1297154 | 1297280 | - | n
RTS_M_1415183_1415374 | 1415183 | 1415374 | - | y
RTS_M_141767_141850 | 141767 | 141850 | - | n
RTS_M_1698211_1698461 | 1698211 | 1698461 | - | y
RTS_M_1780795_1781247 | 1780795 | 1781247 | - | n
RTS_M_411009_411446 | 411009 | 411446 | - | n
RTS_M_473944_474026 | 473944 | 474026 | - | y
RTS_M_538189_538353 | 538189 | 538353 | - | y
RTS_M_565908_566034 | 565908 | 566034 | - | n
RTS_M_694949_695026 | 694949 | 695026 | - | n
RTS_M_910772_910916 | 910772 | 910916 | - | y
RTS_P_1292350_1292435 | 1292350 | 1292435 | + | n
[NAME] | 1306593 | 1306802 | + | n
RTS_P_1415177_1415289 | 1415177 | 1415289 | + | y
RTS_P_150380_150523 | 150380 | 150523 | + | n
[NAME] | 157006 | 157480 | + | y
RTS_P_159992_160230 | 159992 | 160230 | + | y
RTS_P_1618887_1618996 | 1618887 | 1618996 | + | n
RTS_P_1664675_1664772 | 1664675 | 1664772 | + | n
RTS_P_1692002_1692210 | 1692002 | 1692210 | + | y
RTS_P_1763934_1764029 | 1763934 | 1764029 | + | y
RTS_P_202145_202299 | 202145 | 202299 | + | n
RTS_P_401718_402073 | 401718 | 402073 | + | n
RTS_P_421976_422154 | 421976 | 422154 | + | y
[NAME] | 593242 | 593332 | + | y
RTS_P_59717_60028 | 59717 | 60028 | + | y
Spreadsheet: 224242d1364496008-help-with-looking-up-data-across-multiple-sheets-example_alex
Sheet: June

 | Working Days |  | 23
Office 1 | Day Sick | % | Office 2 | Day Sick | % | Office 3 | Day Sick | % | Office 4 | Day Sick | % | Office 5 | Day Sick | % | Office 6 | Day Sick | %
a1 | 23 |  | b1 | 4 |  | c1 | 9 |  | d1 | 23 |  | e1 | 0 |  | f1 | 0
a2 | 23 |  | b2 | 4 |  | c2 | 0 |  | d2 | 3.5 |  | e2 | 0 |  | f2 | 0
a3 | 18 |  | b3 | 3 |  | c3 | 0 |  | d3 | 1 |  | e3 | 0 |  | f3 | 0
a4 | 3 |  | b4 | 3 |  | c4 | 0 |  | d4 | 1 |  | e4 | 0 |  | f4 | 0
a5 | 2 |  | [NAME] | 1 |  | c5 | 0 |  | d5 | 0 |  | e5 | 0 |  | f5 | 0
a6 | 2 |  | b6 | 1 |  | c6 | 0 |  | d6 | 0 |  | e6 | 0 |  | f6 | 0
a7 | 1 |  | b7 | 1 |  | c7 | 0 |  | d7 | 0 |  | e7 | 0 |  | f7 | 0
[NAME] | 1 |  | b8 | 1 |  | c8 | 0 |  | d8 | 0 |  | e8 | 0 |  | f8 | 0
a9 | 1 |  | b9 | 0 |  | c9 | 0 |  | d9 | 0 |  | e9 | 0 |  | f9 | 0
a10 | 1 |  | b10 | 0 |  | c10 | 0 |  | d10 | 0 |  | e10 | 0 |  | f10 | 0
a11 | 1 |  | b11 | 0 |  | c11 | 0 |  | d11 | 0 |  | Total Days YTD | 0 |  | f11 | 0
a12 | 1 |  | b12 | 0 |  | c12 | 0 |  | d12 | 0 |  |  |  |  | Total Days YTD
a13 | 1 |  | b13 | 0 |  | c13 | 0 |  | d13 | 0
a14 | 0.5 |  | b14 | 0 |  | c14 | 0 |  | d14 | 0
a15 | 0.5 |  | b15 | 0 |  | c15 | 0 |  | d15 | 0
a16 | 0 |  | b16 | 0 |  | c16 | 0 |  | d16 | 0
a17 | 0 |  | b17 | 0 |  | c17 | 0 |  | d17 | 0
a18 | 0 |  | b18 | 0 |  | c18 | 0 |  | d18 | 0
a19 | 0 |  | b19 | 0 |  | c19 | 0 |  | d19 | 0
a20 | 0 |  | b20 | 0 |  | c20 | 0 |  | d20 | 0
Total Days YTD | 0 |  | Total Days YTD | 0 |  | Total Days YTD | 0 |  | Total Days YTD | 0
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: H

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL  2012; |  | PURPLE  J-TERM;  GREEN BOTH FALL & J-TERM. |  |  | BOTH SPRING & J-TERM GREEN
History | AOK designation | CAR designation | comment
HIST 100 | Civilizations-History | See CAR list at bottom of this page
HIST 101 | Civilizations-History | See CAR list at bottom of this page
HIST 111 | Civilizations-History |  | requried for Education minor
HIST 112 | Civilizations-History |  | requried for Education minor
HIST 221 |  | Non-Western | cross-listed with JAPN 221
HIST 230 |  | Experiential-Research
HIST 251 |  | Non-Western
HIST 252 |  | Non-Western
HIST 281 |  | Non-Western
HIST 282 |  | Non-Western
HIST 290 |  | Non-Western | cross-listed with ASTU 290
HIST 320 |  | Non-Western; Experiential-Research
HIST 323 |  |  | Experiential-Research deleted 9/08
HIST 328 |  | Experiential-Research
HIST 332 |  | Non-Western
HIST 347 |  | Non-Western; Experiential-Research
HIST 348 |  | Non-Western; Experiential-Research
HIST 352 |  | Experiential-Research
HIST 354 |  | Experiential-Research
HIST 355 |  | Experiential-Research
HIST 361 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 365 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 367 |  | Non-Western | Multidisciplinary if taken before Spring 2007
HIST 371 |  | Experiential-Research
HIST 372 |  | Experiential-Research
HIST 375 |  | Experiential-Research
HIST 376 |  | Experiential-Research
HIST 381 |  | Experiential-Travel | Summer 08; J-term 2010 cross-listed with BLST 381
HIST 381 |  | Experiential-Travel | J-term 09; 10  cross-listed with BLST 381
HIST 382 |  | Non-Western; Experiential-Research | Fall 08 (Native American History)
HIST 386 |  | Experiential-Research
HIST 391 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 392 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 394 |  | Non-Western
HIST 396 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 397 |  | Non-Western; Experiential-Research | Multidisciplinary if taken before Spring 2007
HIST 401 |  | Capstone
HIST 450-451 |  | Experiential-Internship
HIST 481-482 |  | Experiential-Research
HIST 487-488 |  | Experiential-Research
HIST 491-492 |  | Experiential-Research
HIST 496-498 |  | Experiential-Research
HIST 100-101 CAR designations
HIST 100 | Modern Iraq |  | Non-Western
Spreadsheet: 875106d1721671566-trying-to-combine-data-fields-if-certain-conditions-exist-example-of-what-i-am-trying-to-do-etaf2
Sheet: Sheet1

Original data is formatted like this:
AB | Monday1, Monday2,Monday3
AB | Tuesday1, Tuesday2
AC | Wed1, Wed2, Wed3, Wed4
AC | Thur1, Thur2, Thur3
AD | Fri1, Fri2
AD | [NAME]
AD | Sun3, Sun4, Sun5
I want to transform it to this:
AB | Monday1, Monday2, Monday3, Tuesday1, Tuesday2
AC | Wed1, Wed2, Wed3, Wed4, Thur1, Thur2, Thur3
AD | Fri1, Fri2, [NAME], Sun3, Sun4, Sun5
For any fields in column A that are duplicate, combine the data in Column E, but separate the data with a comma and a space.
AC
AD
 |  |  | =LET(   f,B2:B13,   m,A2:A13,   u,UNIQUE(f),   TEXTJOIN(CHAR(10),,u&": "&BYROW(u,LAMBDA(x,ARRAYTOTEXT(FILTER(m,f=x))))) )
Spreadsheet: 677573d1589402901-remove-multiple-date-ranges-from-excel-generac
Sheet: Sheet2

Column1.2
OnShore [NAME]
OnShore Generac WS02
OnShore Generac WS03
OnShore Generac WS04
OnShore [NAME] WS05
OnShore Generac WS06
OnShore Generac WS07
OnShore [NAME] WS08
OnShore [NAME] WS09
OnShore Generac WS10
OnShore [NAME] WS11
OnShore Generac WS12
OnShore Generac WS13
OnShore Generac WS14
OnShore Generac WS15
OnShore Generac WS16
OnShore Generac WS17
OnShore Generac WS18
OnShore Generac WS19
OnShore Generac WS20
nShore Generac WS21
OnShore [NAME] WS22
OnShore Generac WS23
nShore Generac WS24
OnShore Generac WS25
OnShore [NAME] WS26
OnShore Generac WS27
nShore Generac WS28
OnShore [NAME] WS29
OnShore [NAME] WS30
Spreadsheet: 118015d1313352706-filling-apple-cases-with-remainders-applefillbuckets-2-
Sheet: Sheet1

 |  |  | bucket 1 | bucket 2 | bucket 3 | bucket 4 | bucket 5 | bucket 6 | bucket 7 | bucket 8 | bucket 9 | bucket 10 | bucket 11 | bucket 12 | bucket 13 | bucket 14 | bucket 15 | bucket 16 | bucket 17 | bucket 18 | bucket 19 | bucket 20
Start | 50 |  | 6 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] in bucket 1 | 6
[NAME] in rest | 4
Spreadsheet: 836406d1689327818-convert-date-in-mmm-yyyy-format-book1
Sheet: Sheet1

Date | conveted to 1/mm/yyy and formatted as [NAME] |  | Sorted.
2023-06-06 00:00:00
2023-11-26 00:00:00 |  |  | 2023-04-01 00:00:00
2023-06-24 00:00:00 |  |  | 2023-04-01 00:00:00
2023-10-27 00:00:00 |  |  | 2023-04-01 00:00:00
2023-04-16 00:00:00 |  |  | 2023-06-01 00:00:00
2023-11-26 00:00:00 |  |  | 2023-06-01 00:00:00
2023-09-08 00:00:00 |  |  | 2023-06-01 00:00:00
2023-04-23 00:00:00 |  |  | 2023-07-01 00:00:00
2023-02-05 00:00:00 |  |  | 2023-08-01 00:00:00
2023-12-01 00:00:00 |  |  | 2023-09-01 00:00:00
2023-06-24 00:00:00 |  |  | 2023-10-01 00:00:00
2023-04-15 00:00:00 |  |  | 2023-11-01 00:00:00
2023-08-29 00:00:00 |  |  | 2023-11-01 00:00:00
2023-07-03 00:00:00 |  |  | 2023-12-01 00:00:00
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 17119 | 21220
2 | 16609 | 18277
3 | 16587 | 16986
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -88198.25
2000-12-03 00:00:00
Spreadsheet: 12b0dd05-3d9d-42b8-93b3-e55b50b198be
Sheet: Page 11

Business Filers by Tax Year
Tax Year | C Corporations |  | S Corporations |  | LLCs or Business Trusts |  | Partnerships
1991 | 143277 |  | 51519 |  |  |  | 49924.47850678043
1992 | 141917 |  | 58158 |  |  |  | 48925.98893664483
1993 | 140794 |  | 63238 |  |  |  | 48338.87706940509
1994 | 141240 |  | 67962 |  |  |  | 49208.97685665439
1995 | 141761 |  | 73436 |  |  |  | 52063.09751434034
1996 | 143102 |  | 79294 |  |  |  | 54458
1997 | 137771 |  | 85439 |  |  |  | 66447
1998 | 140362 |  | 92740 |  | 3686 |  | 65694
1999 | 135980 |  | 102792 |  | 6949 |  | 69625
2000 | 134929 |  | 109220 |  | 9028 |  | 70202
2001 | 135834 |  | 115653 |  | 14682 |  | 67113
2002 | 140972 |  | 123187.6004163998 |  | 26139.39958360026 |  | 71349
2003 | 135074 |  | 133630.7583372307 |  | 36935.24166276925 |  | 72616
2004 | 133493 |  | 139591.0093093743 |  | 47860.99069062565 |  | 69935
2005 | 123757 |  | 140730 |  | 61900 |  | 75204
2006 | 115649 |  | 155059 |  | 75294 |  | 83291
2007 | 113565 |  | 159397 |  | 89791 |  | 81160
2008 | 109524 |  | 163008 |  | 103538 |  | 81721
2009 | 104369 |  | 163959 |  | 110969 |  | 80329
2010 | 101234 |  | 163926 |  | 119714 |  | 79149
Notes:
Tax years 2009 and 2010 are preliminary.
The data in this table have been updated and are not directly comparable to previous publications.
C Corporations include limited liability companies that elect to be taxed as a C Corporation for federal income tax purposes as well as S Corporations with taxable built-in gains.
Limited Liability Companies (LLCs) that are either formed under Pennsylvania law or that have Pennsylvania nexus and that file federal tax partnership returns are required to file both a corporate tax return to report capital stock and franchise tax and a Pennsylvania partnership return.  LLCs that filed both returns are shown as LLCs in this table and are not included in the partnership count.
Spreadsheet: 758114d1638656373-finding-missing-numbers-in-an-array-and-concatenating-them-into-one-cell-see-sheet-3
Sheet: Sheet3

 | Line | Line | Line | Line | Line
 | 1 | 2 | 3 | 4 | 5 |  |  | RESULT
 | [NAME] | ABC10B R02 | ABC2A R02 | ABC4A R01 | ABC2B R03 |  | R01 |  | <------what lines (1-5) does this room number (R01) not appear under?
 | ABC5A R02 | ABC10D R03 | ABC3C R03 | ABC7A R03 | [NAME] |  | R02 |  | <------what lines (1-5) does this room number (R02) not appear under?
 | ABC10C R04 | ABC5E [NAME] | [NAME] | ABC8C [NAME] | ABC2H R01 |  | R03 |  | <------what lines (1-5) does this room number (R03) not appear under?
 |  |  |  |  |  |  | [NAME] |  | <------what lines (1-5) does this room number ([NAME]) not appear under?
 |  |  |  |  |  |  |  | RESULT
 |  |  |  |  |  |  | R01 | 2 | <------ example correct result
Spreadsheet: 102676d1300657570-inventory-help-iventorymain
Sheet: wine

Item # | Description | Unit Price | Consignment Price |  |  |  |  | Qty | Qty sold | $ owed | Phys In
101 | Sunrise Merlot | 200 | 90 |  |  |  |  | 30
102 | Sunrise Carmenere | 200 | 90 |  |  |  |  | 10
103 | Rey de los Andes Merlot | 180 | 85
104 | [NAME] andes [NAME] | 180 | 85
105 | Santa Emiliana Cab Reserve | 180 | 85
106 | Unico [NAME] | 800 | 350
107 | Santa Rita 120 Merlot | 230 | 120
108 | Gato Negro Cab | 200 | 90
109 | Espiritu Criollo Malbec | 180 | 85
110 | Espiritu Criollo Shiraz | 180 | 85
111 | Espiritu Criollo Cabernet | 180 | 85 |  |  |  |  | 10
112 | Finca la linda Cabernet | 270 | 160
113 | Finca la [NAME] | 180 | 90 |  |  |  |  | 12
114 | Gran Irache Crianza | 240 | 130
115 | Casrillo Irache Reserva | 180 | 90
116 | [NAME] | 750 | 390
117 | Siglo [NAME] | 800 | 298
118 | Marques de Caceres | 490 | 230 |  |  |  |  | 10
119 | Rey de los Andes Chardonnay | 180 | 85
120 | Finca la linda Chardonnay | 270 | 160
121 | Espiritu Criollo Torrontes | 200 | 85
 |  |  |  |  |  |  |  | Total owes [NAME]
Spreadsheet: 272317d1382356301-ranking-with-criteria-ranking_expect-result
Sheet: Remaining Amnt

Central | [NAME] (column C)
Rank | Customer ID | Sum of  Remaining amnt.
1 | A3929 | 308146086.4699994 |  | cell B3 = A customer who has highest [NAME] amount, ranking within group of Central region.
2 | A1150 | 164069707.77
3 | A3932 | 157908561.9000015 |  | Column B = listing of Customer who has highest sum of remaining amount within region.  The list of rank 1-10 will not have duplicate customer.
4 | A0085 | 142454323.1299999
5 | A3930 | 72177539.56000006
6 | A0899 | 37856695.44
7 | [NAME] | 33183821.12
8 | A3931 | 27237832.41000002
9 | A1549 | 19040870.67000001
10 | A0613 | 15735083.44
East | [NAME] (column C)
Rank | Customer ID | Sum of  Remaining amnt.
1 | A4175 | 6726062.8
2 | A1824 | 947292.4
3 | A2566 | 939941.4999999998
4 | A2553 | 835220.5999999999
5 | A3002 | 792324.2999999999
6 | A2427 | 652871.2
7 | A4262 | 648334.3999999999
8 | A2457 | 607203.6000000001
9 | A1797 | 585118.8
10 | A7131 | 575381.8
Spreadsheet: 838840d1691438585-calendar-with-recurring-weekly-events-gov-calendar
Sheet: Calendar

 |  |  | Calendar of events
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 5 |  | <== Enter MONTH - 1 to 12
2 |  |  |  |  |  |  |  |  | Year | 2023 |  | <== Enter YEAR - 2018 to 2030
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10