tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860659d1708670804-update-cell-where-criteria-meet-cell-connection-test
Sheet: Sheet1

 |  |  | Number |  |  |  |  |  |  |  |  |  |  |  | Table
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  | Document | Number
 | Document | a | P |  |  | P | P |  |  | P |  |  |  |  | a | 1
 |  | b |  |  | P |  |  |  | P |  | P |  |  |  | a | 5
 |  | c |  |  |  |  |  |  |  |  |  |  |  |  | a | 8
 |  | d |  |  |  |  |  |  |  |  |  |  |  |  | a | 4
 |  | e |  |  |  |  |  |  |  |  |  |  |  |  | b | 3
 |  | f |  |  |  |  |  |  |  |  |  |  |  |  | b | 7
 |  | g | P |  | P |  | P |  | P |  | P |  |  |  | b | 9
 |  | h |  |  |  |  |  |  |  |  |  |  |  |  | g | 1
 |  | i |  | P |  |  | P |  |  |  |  |  |  |  | g | 5
 |  | j |  |  |  |  |  |  |  |  |  |  |  |  | g | 7
 |  | k | P | P | P | P |  | P |  | P | P |  |  |  | g | 3
 |  | l |  |  |  |  |  |  |  |  |  |  |  |  | g | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 2
Spreadsheet: 84961d1285060614-lookup-images-from-other-sheet-staff-in-confidence-1-
Sheet: Sheet2

ID No | Name | Passport No | Appt: | Age | DOB | Nationality | Gender | Religon | Height | Weight | Country of residence | Home country tel no | secondary No | Mob no UAE | email id | marital status | father name | mother name | name of wife | Next of kin | contact detail | tel no | fax no | mobile no | email | residence visa details |  | residence no | issue date | expiry date | NSI training | initial course date | result | NSI refresher | date | result | PSBD license no | exam date | result | education level | language proficency | spoken | written | any basic computer knowledg & skill | special skills if any | name of certification | 1 | 2 | 3 | center of certification | 1 | 2 | 3 | date of certification | 1 | 2 | 3 | name and address of employer | 1 | 2 | 3 | 4 | 5 | date of joining | 1 | 2 | 3 | 4 | 5 | date of leaving | 1 | 2 | 3 | 4 | 5 | position held | 1 | 2 | 3 | 4 | 5 | medical condition/illness | tuberculosis | yes | no | aids | yes | no | diabetic | yes | no | any physical disablity | yes | no | other illness | date of offence | 1 | 2 | nature of offence | 1 | 2 | sentence / outcome | 1 | 2 | image
1
2
3
4
5
1 | 2 | 3 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 |  | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Pictures\25743_109031499120697_100000415431088_168692_2983941_n.jpg
Spreadsheet: 0023efc8-913a-4e15-9cc7-ebc715d06f49
Sheet: Sheet1

Unnamed: 0 | Evaluation Review Committee | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
PersonalTitle | First Name | Last Name | BusInstitution | ERCOffice | ERCRepresents | ERCRepsStdBd | ERCOrigDate | ERCBegCurTerm | ERCEndCurTerm | ERCTerm
Dr. | [NAME] | [NAME] | SEKESC |  | School Administrators | Standards Board | 06.13.11 | 07.01.11 | 06-30-14 | Completing Term
Ms. | [NAME] | Becker-Wille | ANW Education Coop |  | Classroom Teachers |  | 06-11-12 | 07-01-12 | 06-30-15 | 1st Full Term
Mr. | [NAME] | Carnes | Herington High School |  | Classroom Teachers |  | 06-11-12 | 07-01-12 | 06-30-15 | 1st Full Term
Ms. | Becky | [NAME] | Tescott High School |  | School Administrators |  | 06-11-12 | 07-01-12 | 06-30-15 | 1st Full Term
Dr. | Lorie | Cook-Benjamin | Ft Hays State University |  | Higher Education |  | 02-11-13 | 07-01-13 | 06-30-16 | 1st Full Term
Ms. | Beverly | [NAME] | Sunflower Elementary |  | Classroom Teachers |  | 11-19-12 | 07.01.13 | 06-30-16 | 1st Full Term
Dr. | [NAME] | [NAME] | Bethel College |  | Higher Education |  | 11-19-12 | 11-19-12 | 06-30-13 | Completing Term
Mr. | Greg | [NAME] | Norton Public Schools |  | School Administrators |  | 06-11-12 | 07-01-12 | 06-30-15 | 1st Full Term
Ms. | [NAME] | [NAME] | Coleman Middle School |  | Classroom Teachers |  | 11-14-11 | 11-14-11 | 06-30-14 | 1st Full Term
Dr. | [NAME] | Reding | Benedictine College |  | Higher Education |  | 05.30-13 | 07.01.13 | 06.30.16 | 1st Full Term
Dr. | Martin | Stessman | [NAME] |  | School Administrators |  | 11-14-11 | 11-14-11 | 06-30-14 | 1st Full Term
Ms. | Kathy | Wagoner | Hays High School |  | Classroom Teachers | Standards Board | 11-19-12 | 11-19-12 | 06-30-15 | 1st Full Term
Dr. | [NAME] | White | Kansas State University |  | Higher Education |  | 06-13-11 | 07-01-11 | 06-30-14 | 1st Full Term
 | 07.01.13
Spreadsheet: 669003d1585157794-calculating-overtime-over-40-hours-overtime-example
Sheet: Regular & OverTime (Employee 1)

 |  | Rate of Pay: | 12
 | Day | Total  Hours | Regular | Over Time
 | Mon | 9.000000000000002
 | Tue | 9
 | Wed | 9
 | Thu | 9
 | Fri | 9
 | Sat | 4
 | Sun
 | Total Hours: |  |  |  | Total Pay
 | Pay:
Spreadsheet: 848399d1699115852-problem-with-formula-will-not-work-when-replacing-section-of-one-formula-with-another-formula-issue
Sheet: PR

Report Type: Year-to-Date
PERIOD START PERIOD END
Jan 01,2023 Nov 02, 2023
Report Created: 11/03/2023 02:34 PM
EARNINGS |  |  | EMPLOYEE TAXES |  | EMPLOYEE DEDUCTIONS |  | EMPLOYER TAXES |  | EMPLOYER DEDUCTIONS
TYPE REGULAR | VALUES 1,364.00 | GROSS PAY $29,822.00 | TYPE STATE-AZ FICA MEDFICA FED WTH | AMOUNT $450.61 $[NAME] $432.42 $0.00 | TYPE | AMOUNT | TYPE FUTA CO FICA CO MEDC CO UNEM-AZ | AMOUNT $42.00 $[NAME] $432.42 $111.20 | TYPE | AMOUNT
TOTAL: | 1,364.00 | $29,822.00 |  | $2,731.99 |  | $0.00 |  | $2,434.58 |  | $0.00
DOE, [NAME] PAY $52,462.06
EARNINGS |  |  | EMPLOYEE TAXES |  | EMPLOYEE DEDUCTIONS |  | EMPLOYER TAXES |  | EMPLOYER DEDUCTIONS
TYPE SALARY | VALUES 1,760.00 | GROSS PAY $76,280.00 | TYPE STATE-AZ FICA MEDFICA FED WTH | AMOUNT $267.15 $4,729.36 $1,106.06 $17,715.37 | TYPE | AMOUNT | TYPE FUTA CO FICA CO MEDC CO UNEM-AZ | AMOUNT $42.00 $4,729.36 $1,106.06 $111.20 | TYPE | AMOUNT
TOTAL: | 1,760.00 | $76,280.00 |  | $23,817.94 |  | $0.00 |  | $5,988.62 |  | $0.00
EARNINGS |  |  | EMPLOYEE TAXES |  | EMPLOYEE DEDUCTIONS |  | EMPLOYER TAXES |  | EMPLOYER DEDUCTIONS
TYPE SALARY | VALUES 1,760.00 | GROSS PAY $76,280.00 | TYPE STATE-AZ FICA MEDFICA FED WTH | AMOUNT $2,621.85 $4,729.36 $1,106.06 $9,425.60 | TYPE | AMOUNT | TYPE FUTA CO FICA CO MEDC CO UNEM-AZ | AMOUNT $42.00 $4,729.36 $1,106.06 $111.20 | TYPE | AMOUNT
TOTAL: | 1,760.00 | $76,280.00 |  | $17,882.87 |  | $0.00 |  | $5,988.62 |  | $0.00
YEAR-TO-DATE TOTALS                                                              NET PAY $137,949.20
EARNINGS |  |  | EMPLOYEE TAXES |  | EMPLOYEE DEDUCTIONS |  | EMPLOYER TAXES |  | EMPLOYER DEDUCTIONS
TYPE REGULAR SALARY | VALUES 1,364.00 3,520.00 | GROSS PAY $29,822.00 $152,560.00 | TYPE STATE-AZ FICA MEDFICA FED WTH | AMOUNT $3,339.61 $11,307.68 $2,644.54 $27,140.97 | TYPE | AMOUNT | TYPE FUTA CO FICA CO MEDC CO UNEM-AZ | AMOUNT $126.00 $11,307.68 $2,644.54 $333.60 | TYPE | AMOUNT
TOTAL: | 4,884.00 | $182,382.00 |  | $44,432.80 |  | $0.00 |  | $14,411.82 |  | $0.00
*Non-Cash Earnings are not included in the Net Pay amount, but are included in the Period Earnings and YTD Totals.
Spreadsheet: 876330d1723024701-picking-list-limit-results-based-on-required-amount-book1-1-
Sheet: Sheet1

 | List 1 |  |  |  |  | List 2
 | Item code | Location | Qty | [NAME] |  | Item code | Qty needed
 | 2533025 | [NAME] | 20 | 1 |  | 2533025 | 500
 | 2533025 | AA008G02 | 20 | 1 |  | 2666822 | 750
 | 2533025 | AA010J02 | 20 | 1
 | 2533025 | AA032C01 | 20 | 1
 | 2533025 | AA032E01 | 20 | 1
 | 2533025 | AA032E02 | 20 | 1
 | 2533025 | AA034C02 | 20 | 1
 | 2533025 | AA094J02 | 20 | 1
 | 2533025 | AA104E02 | 20 | 1
 | 2533025 | AA105E02 | 20 | 1
 | 2533025 | AB016C02 | 20 | 1
 | 2533025 | AB022G01 | 20 | 1
 | 2533025 | AB022J02 | 20 | 1
 | 2533025 | AB023J02 | 20 | 1
 | 2533025 | AB028E02 | 20 | 1
 | 2533025 | AB029E02 | 20 | 1
 | 2533025 | AB031G01 | 20 | 1
 | 2533025 | AB031G02 | 20 | 1
 | 2533025 | AB035C01 | 20 | 1
 | 2533025 | AB044J02 | 20 | 1
 | 2533025 | AB060J02 | 20 | 1
 | 2533025 | AB065C02 | 20 | 1
 | 2533025 | AC011J02 | 20 | 1
 | 2533025 | AC071E01 | 20 | 1
 | 2533025 | AC103E02 | 20 | 1
 | 2533025 | AE076G02 | 20 | 0
 | 2666822 | AA038C01 | 25 | 1
 | 2666822 | AA041C01 | 25 | 1
 | 2666822 | AA044C02 | 25 | 1
 | 2666822 | AA045C01 | 25 | 1
 | 2666822 | AA051C02 | 25 | 1
 | 2666822 | AA054J01 | 25 | 1
 | 2666822 | AA057E02 | 25 | 1
 | 2666822 | AA057J01 | 25 | 1
 | 2666822 | AA060C01 | 25 | 1
 | 2666822 | AA063C01 | 25 | 1
 | 2666822 | AA064C01 | 25 | 1
 | 2666822 | AA067C02 | 25 | 1
 | 2666822 | AA068C01 | 25 | 1
 | 2666822 | AA082G02 | 25 | 1
 | 2666822 | AA084C01 | 25 | 1
 | 2666822 | AA085C01 | 25 | 1
 | 2666822 | AA086C01 | 25 | 1
 | 2666822 | AA087C01 | 25 | 1
 | 2666822 | AA088C02 | 25 | 1
 | 2666822 | AA090C02 | 25 | 1
 | 2666822 | AA105C02 | 25 | 1
 | 2666822 | AB006C02 | 25 | 1
 | 2666822 | AB022J01 | 25 | 1
 | 2666822 | AB034L02 | 25 | 1
 | 2666822 | AB036J02 | 25 | 1
 | 2666822 | AB036L02 | 25 | 1
 | 2666822 | AB037J02 | 25 | 1
 | 2666822 | AB040E01 | 25 | 1
 | 2666822 | AB040G02 | 25 | 1
 | 2666822 | AB040J02 | 25 | 1
 | 2666822 | AB041J01 | 25 | 0
 | 2666822 | AB045C01 | 25 | 0
 | 2666822 | AC034G02 | 25 | 0
 | 2666822 | AC036L02 | 25 | 0
 | 2666822 | AC069E02 | 25 | 0
Spreadsheet: 840787d1692980618-sum-up-columns-based-on-specific-dates-test-34-ans
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  |  | 2022-05-01 00:00:00 | 2022-08-24 00:00:00
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 08:45:00 | 1.000000000116415 |  |  | Total downtime
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73641 | 2022-05-23 15:35:29 | 2022-05-23 16:35:54 | 1.006944444437977
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 |  | 10708.77714444447
Spreadsheet: 37786d1235795090-convoluted-excel-sum-formula-issues-report_commission-workfilev2
Sheet: ITEM-IDS

item_id | Old_Item | item_desc | extended_desc | price1 | CODE | COMM
Part-12765 |  | Description | [NAME] | 0 | 9999 | NO
Part-12766 |  | Description | [NAME] | 67 | 9999 | NO
Part-12767 |  | Description | [NAME] | 0 | 9999 | NO
Part-12768 |  | Description | [NAME] | 7400 | 9999 | NO
Part-12769 |  | Description | [NAME] | 9500 | 9999 | NO
Part-12770 |  | Description | [NAME] | 1894 | 9999 | NO
Part-12771 |  | Description | [NAME] | 1894 | 9999 | NO
Part-12772 |  | Description | [NAME] | 1894 | 9999 | NO
[NAME] |  | Description | [NAME] | 8 | 9999 | NO
Part-12774 |  | Description | [NAME] | 22 | 9999 | NO
Part-12775 |  | Description | [NAME] | 36 | 9999 | NO
Part-12776 |  | Description | [NAME] | 44 | 1010 | YES
Part-12777 |  | Description | [NAME] | 78 | 1010 | YES
Part-12778 |  | Description | [NAME] | 157 | 1010 | YES
[NAME] |  | Description | [NAME] | 188 | 1010 | YES
Part-12780 |  | Description | [NAME] | 642 | 1010 | YES
Part-12781 |  | Description | [NAME] | 281 | 1010 | YES
Part-12782 |  | Description | [NAME] | 860 | 1010 | YES
Part-12783 |  | Description | [NAME] | 467 | 1010 | YES
Part-12784 |  | Description | [NAME] | 986 | 1010 | YES
Part-12785 |  | Description | [NAME] | 654 | 1010 | YES
Part-12786 |  | Description | [NAME] | 841 | 1010 | YES
Column F was created to separate parts that receive a commission (1010) and parts that do not receive a commission (9999)
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: Apr

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: VERMONT-44

 | COUNTY | CODE
 | Addison | 1
 | Bennington
 | Caledonia
 | Chittenden
 | Essex
 | Franklin
 | Grand Isle
 | Lamoille
 | Orange
 | Orleans
 | Rutland
 | Washington
 | Windham
 | Windsor
Spreadsheet: f0cfa351-7edf-45fc-a9db-d258044558b3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6178 | 40903 | Albertus | [NAME] | RSA | 0 | 00:55:27 | 00:00:00 | 01:27:50 | 00:00:00 | 00:40:07 | 1 | 03:03:24
6178 | 40904 | Deon | [NAME] | RSA | 0 | [NAME] | 00:00:00 | 01:34:58 | 00:00:00 | 00:38:10 | 2 | 03:08:36
Spreadsheet: 47145d1246042097-lookup-and-result-on-condition-reopentek-lookupreferencestest-1
Sheet: Data

Supplier | Account | Month | Code | Date | Jef1 | Jef2 | Amount | Key
Dabs | 11010 | 1 | 20811 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 1 | 22525 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 1 | 22898 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 7 | 23393 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 8 | 23931 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 9 | 24429 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Currys | 13020 | 9 | 20811 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71 | 0
Currys | 13020 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71 | 0
Dell | 13021 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | RB Adjustment | -39.77 | 1
Dell | 13021 | 10 | 25025 | 2009-04-30 00:00:00 | JE:m/a journal | RB adjust P1-9 | 196.33 | 1
GB | 14010 | 1 | 23477 | 2009-01-01 00:00:00 | JE:m/a journal |  | 6099.43 | 0
GB | 14010 | 8 | 23478 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 0
GB | 14010 | 9 | 23479 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 0
GB | 14010 | 10 | 23480 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 0
Total | 14011 | 6 | 23089 | 2009-01-01 00:00:00 | JE:m/a journal |  | -3415.54 | 0
Total | 14011 | 7 | 23089 | 2009-01-01 00:00:00 | JE: S/J  2008091 | RB adjustment | 152.44 | 0
Total | 14011 | 7 | 23091 | 2009-01-01 00:00:00 | JE:m/a journal |  | -2591.15 | 0
Tech | 22010 | 1 | 23090 | 2008-07-01 00:00:00 | JE:INVOICING -OR |  | -192.72 | 0
Spreadsheet: 850082d1700479758-calculating-the-number-of-people-who-have-purchased-more-than-once-over-rolling-periods-repeat-purchase-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1415444-calculating-the-number-of-people-who-have-purchased-more-than-once-over-rolling-periods.html
Person's name | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
[NAME] | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 1
[NAME] | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Jake | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sue | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Number of people who made more than 1 purchase in the 3 month period - expected values
 | Jan - March | … | … | … | … | [NAME] | … | … | …. | … | Oct - Dec
 | 4 |  |  |  |  | 2 |  |  |  |  | 2
Spreadsheet: 53377d1253261848-excel-2007-bar-chart-x-axis-labels-show-up-vertical-699858
Sheet: Summary Table

 |  |  | Budget Year:
 |  |  | Profit & Loss Account
Spreadsheet: eric_saibi__9829__092801R
Sheet: Salem 01

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 01
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1,170 MW
Start Date |  | 2001-09-24 00:00:00
End Date |  | 2001-10-02 00:00:00
Prv. Start Date |  | 2001-09-24 00:00:00
Prv. End Date |  | 2001-09-28 00:00:00
Comments |  | Found another valve that had to be replaced.
SIC |  | 4931
Plant ID |  | 1018459
Unit ID |  | 1004455
Outage ID |  | 18526
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: January

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
January Report - BE SURE TO ENTER PRIOR PERIOD TOTAL IN "ENTRIES FOR BN" SECTION
Period 1 | January | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  |  |  |  |  |  |  |  |  | -500
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  |  | WIP Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 1 | January |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  | ONE TIME ENTRY - DECEMBER REPORT TOTAL (BE SURE TO SHOW (-) OR (+)
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 1 | January |  | Journal Entry      Dated January 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated February 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated January 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated February 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 0b463256-c43f-4d4e-a5dc-bc4e92d08a07
Sheet: Sheet1

DELTA AIR LINES INC /DE/ | Unnamed: 1
8-K
08/02/2013
ATLANTA
Preliminary Financial and Operating Results
July consolidated PRASM change year over | 3.0%
year
Projected September quarter fuel price | $3.05 - $3.10
per gallon, adjusted
July mainline completion factor | 99.5%
July on-time performance (preliminary | 74.5%
DOT A14)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 548589d1511215892-count-live-records-on-a-specific-day-countif-on-a-specific-day-2
Sheet: Sheet1

Start Date | End Date | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00
2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 0
2014-01-01 00:00:00 | 2015-06-01 00:00:00 | 1
2014-01-01 00:00:00 |  | 1
2016-01-01 00:00:00 | 2017-07-01 00:00:00 | 0
2016-01-01 00:00:00 |  | 0
2017-01-01 00:00:00 | 2017-06-01 00:00:00 | 0
2014-01-01 00:00:00 | 2017-12-31 00:00:00 | 1
Spreadsheet: 129315d1321545456-excel-2007-vlookup-with-critera-in-multple-columns-example
Sheet: Sheet2

 |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec
1120 |  |  |  |  |  |  |  |  | 3259.39
1140 |  |  |  |  |  |  |  |  | -2954
2110 |  |  |  |  |  |  |  |  | 26688.6
2130.1 |  |  |  |  |  |  |  |  | 7573.62
2320 |  |  |  |  |  |  |  |  | 1497864.76
1420 |  |  |  |  |  |  |  |  | 6104266.04
Spreadsheet: 538908d1505876134-adding-row-content-from-sheet-to-sheet-example-didierkassas-
Sheet: Broadcast

 |  |  |  |  | Broadcast
 |  |  |  |  | 2017-09-19 00:00:00
 | Session # | 8
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 9
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 10
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 11
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 12
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 13
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 14
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 15
 | 1 | Broadcast |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
Spreadsheet: stacey_white__38845__newbooksrequest
Sheet: Sheet1

 | 3 NEW COUNTERPARTIES AND DESKS IN THE WEST PORTFOLIO
 | 1 | Counter party name |  | ST West Services
 |  | Book = Desk name= Long name |  | ST West Services
 |  | Trader |  | [NAME], [NAME], [NAME], Jesse
 |  |  |  | [NAME], [NAME], [NAME], Geir
 |  |  |  | [NAME],[NAME], [NAME], [NAME],
 |  |  |  | [NAME], [NAME], [NAME]
 |  | Portfolio |  | West Power
 |  | Desk ID |  | Short term West
 |  | Sub-to-Legal Relationship |  | EPMI
 |  | Shortname |  | ST-WSERV
 |  | Systems needed |  | ENPOWER, EOL,
 |  | Enpower Links: |  | West Power - Houston & Power Desk -Houston
 | 2 | Counter party name |  | ST West Rockies
 |  | Book = Desk name= Long name |  | ST West Rockies
 |  | Trader |  | [NAME], [NAME], [NAME]
 |  | Portfolio |  | West Power
 |  | Desk ID |  | Short term West
 |  | Sub-to-Legal Relationship |  | EPMI
 |  | Shortname |  | ST-WROCKIES
 |  | Systems needed |  | ENPOWER, EOL,
 |  | Enpower Links: |  | West Power - Houston & Power Desk -Houston
 | 3 | Counter party name |  | LT West Options
 |  | Book = Desk name= Long name |  | LT West Options
 |  | Trader |  | [NAME]
 |  | Portfolio |  | West Power
 |  | Desk ID |  | [NAME]
 |  | Sub-to-Legal Relationship |  | EPMI
 |  | Shortname |  | LT-WOPTIONS
 |  | Systems needed |  | ENPOWER, EOL,
 |  | Enpower Links: |  | West Power - Houston & Power Desk -Houston