tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c46bb4d7-88a0-4838-8d45-3cf09bb1b20f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
June 2012 Labor Report
July 20, 2012
Unemployment in Kansas and MSAs
Place of Residence Data
Kansas |  |  |  | June 2012 |  | May 2012 |  | June 2011
Civilian Labor Force |  |  |  | 1512842 |  | 1491292 |  | 1517824
Employment |  |  |  | 1419096 |  | 1404563 |  | 1413904
Unemployment |  |  |  | 93746 |  | 86729 |  | 103920
Unemployment Rate |  |  |  | 6.2 |  | 5.8 |  | 6.8
[NAME]
(Douglas County)
Civilian Labor Force |  |  |  | 57979 |  | 61151 |  | 60378
Employment |  |  |  | 54299 |  | 57750 |  | 56513
Unemployment |  |  |  | 3680 |  | 3401 |  | 3865
Unemployment Rate |  |  |  | 6.3 |  | 5.6 |  | 6.4
[NAME]
(Jackson, Jefferson, Osage, [NAME] and Wabaunsee Counties)
Civilian Labor Force |  |  |  | 120650 |  | 120228 |  | 123548
Employment |  |  |  | 112438 |  | 112722 |  | 114806
Unemployment |  |  |  | 8212 |  | 7506 |  | 8742
Unemployment Rate |  |  |  | 6.8 |  | 6.2 |  | 7.1
[NAME]
(Butler, Harvey, [NAME] and [NAME])
Civilian Labor Force |  |  |  | 311922 |  | 305765 |  | 308670
Employment |  |  |  | 289083 |  | 284467 |  | 283290
Unemployment |  |  |  | 22839 |  | 21298 |  | 25380
Unemployment Rate |  |  |  | 7.3 |  | 7 |  | 8.2
Kansas City Area
(Franklin, [NAME], [NAME], Linn, Miami and Wyandotte Counties)
Civilian Labor Force |  |  |  | 442689 |  | 435719 |  | 448341
Employment |  |  |  | 415646 |  | 409863 |  | 416222
Unemployment |  |  |  | 27043 |  | 25856 |  | 32119
Unemployment Rate |  |  |  | 6.1 |  | 5.9 |  | 7.2
Manhattan MSA
(Geary, [NAME] and Riley Counties)
Civilian Labor Force |  |  |  | 60421 |  | 61369 |  | 61968
Employment |  |  |  | 56839 |  | 58184 |  | 58289
Unemployment |  |  |  | 3582 |  | 3185 |  | 3679
Unemployment Rate |  |  |  | 5.9 |  | 5.2 |  | 5.9
Source:  Kansas Department of Labor, Labor Market Information Services, in conjunction with the Bureau of Labor Statistics
Spreadsheet: 60931d1261511561-auto-fill-color-among-different-sheets-sample-androw-
Sheet: Master

 |  |  |  |  |  |  |  | choose |  | Behind Schedule
 |  |  |  |  |  |  |  | color for |  | Making Progress w/Challenges
 |  |  |  |  |  |  |  | progress |  | Complete /  On Track
Employee | Goal | Objective | Metrics | Q1 | Q2 | Q3 | Q4
[NAME] | Increase Profitability | Manage Budget | individual's plan
[NAME] | Increase Profitability | Manage Budget | individual's plan
[NAME] | Increase Profitability | Manage Budget | individual's plan
[NAME] | [NAME] | Develop Programs | individual's plan
[NAME] | [NAME] | Develop Programs | individual's plan
[NAME] | [NAME] | Develop Programs | individual's plan
Spreadsheet: 3b9a9c4a-0e65-4762-8fc4-7d40a1720921
Sheet: Sheet1

Income | 2011 Actual
Rollover | 6508.9
Spring Conclave | 3910
Fall Fellowship | 0
Fall Conclave | 5497
Winter Banquet | 2783.5
LLD | 630
Dues | 9828
Section Conclave | 0
Trading Post Sales | 2034.5
Program Supplies | 429
Transfer from Building Fund | 0
[NAME] | 0
Total | 31620.9
Expenses
Activities | 0
Camp Promotions | 0
Ceremonies | 977.15
Chapters | 0
Chief | 67.16
Dance Team | 0
Elangomats | 0
Executive Fund | 0
Fall Conclave | 6012.6
Fall Fellowship | 0
FOS | 743
Inductions | 0
LLD | 513.45
Membership | 0
Publications | 997.75
Recharter | 2229
Section Conclave | 0
Service Projects | 1560
Spring Conclave | 3100.5
Summer Camp Program | 37.89
Summer Camp Staff | 300
Trading Post/Restock | 3805.02
Training | 0
Troop Representatives | 0
[NAME] and Recognition | 590.48
Website | 76
Winter Banquet | 2147.12
Building Fund | 0
Program Supplies | 2357
[NAME] | 0
Donations | 75
Total Expenses | 25514.12
 | 6106.780000000002
Spreadsheet: 873788d1720357969-cant-make-the-formula-system-suitability-and-area-ration-calculation-sheet-for-fudrocortisone-acetate-usp-excel-for
Sheet: Sheet1

Respective Solvent ( |  |  |  |  |  |  |  |  | [NAME] |  |  | )
Average peak area of |  |  |  |  |  |  | in diluent |  |  | = | 10523
 |  |  | Area Ratio of |  |  |  |  |  |  |  | Results
Solution Name |  |  | Calculation |  |  |  |  | Area Ratio |  |  | Solution Name | Average | SD |  | % RSD
[NAME] 01 |  |  | = | 635686 | - |  |  | =
 |  |  |  | 236572 |  |  |  |  |  |  | [NAME]
[NAME] 02 |  |  | = | 639863 | - |  |  | =
 |  |  |  | 241450
[NAME] 03 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 236539 |  |  |  |  |  |  | Bracketing Standard Solution 01
[NAME] 04 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 238607
[NAME] 05 |  |  | = | 630036 | - |  |  | =
 |  |  |  | 238196
Bracketing Standard Solution 01 |  |  | = | -257242 |  |  |  | =
 |  |  |  | 82919
Spreadsheet: vkaminski__40831__SRMReport-3-31-01
Sheet: Sithe - MTM P&L

 |  | PV | Delta |  |  | Gamma | Vega | Rho | Theta | Liquidation | Adjustments | PV | P&L
 |  | 2001-03-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2001-03-20 00:00:00 | QTD
 |  | ($ 000s) |  |  | ($ 000s)
Physical Supply
Physical Gas |  |  |  | (Bcf)
Net Financial Power |  |  |  | (000 Mwh)
Tracking Account
Financial Gas |  |  |  | (Bcf)
Net Financial Power |  |  |  | (000 Mwh)
Tracking Account
Before Interest
Interest
Prime+1
Tracking Account
Post Interest
Plant Value |  | 250000 |  |  |  |  |  |  |  |  |  | 250000
Spreadsheet: 753137d1635265113-nested-if-function-formula-haep-data-help
Sheet: Sheet1

Level 1 Completed or withdrawl date | Provide the date the apprentice Completed/Withdrew Training #2. (MM/DD/YYYY) | Provide the date the apprentice Completed/Withdrew Training #3. (MM/DD/YYYY) | Training Milestone: Record the most recent date the participant had a satisfactory or better progress report towards established milestones from an employer/training provider (e.g., completion of on-the-job training (OJT), completion of one year of a registered apprenticeship program, etc.).                                                                                                                                                                                                                                                                Leave blank if this data element does not apply to the participant.    (MM/DD/YYYY) | Skills Progression: Record the most recent date the participant successfully completed an exam that is required for a particular occupation, or progress in attaining technical or occupational skills as evidenced by trade-related benchmarks such as knowledge-based exams.                                                                                                                                                                                                                                                                                                                                                                                                        Leave blank if this data element does not apply to the participant.      (MM/DD/YYYY)
2021-08-31 00:00:00 |  |  | 2021-08-31 00:00:00 | I need to populate the most current date of columns A,B,and C. I canot use MAX bc it returns a 1900 of not all three cells have data.
10/1/221 | 2021-10-25 00:00:00 |  | 2021-10-25 00:00:00
2021-01-30 00:00:00 | 2021-07-02 00:00:00 | 2021-10-15 00:00:00 | 2021-10-15 00:00:00
2021-06-17 00:00:00
2021-03-15 00:00:00
2021-04-05 00:00:00
4/7/2021
2021-06-11 00:00:00
2021-05-10 00:00:00 | 2021-08-23 00:00:00
2021-07-13 00:00:00
2021-08-27 00:00:00
2021-05-26 00:00:00 | 2021-10-11 00:00:00
2021-09-21 00:00:00
2021-05-27 00:00:00
Spreadsheet: 819873d1677743012-excel-formula-for-sorting-a-result-excel-data-1
Sheet: Sheet2

DATA 1 |  |  |  |  |  | DATA 2
Column1 | MATERIAL CODE | Column3 |  |  |  | MATERIAL CODE |  |  | MATERIAL CODE | Custom
2022-02-16 00:00:00 | N07.0002004.00082 | TECO |  |  |  | N07.0002004.00082 |  |  | N07.0002004.00082 | PR PO
2022-02-16 00:00:00 | N07.0002004.00143 | TECO |  |  |  | N07.0002004.00143 |  |  | N07.0002004.00143 | MO
2022-03-01 00:00:00 | N07.0002004.00196 | CANCEL |  |  |  | N07.0002004.00196 |  |  | N07.0002004.00196 | PR
2022-03-03 00:00:00 | N07.0002004.00202 | TECO |  |  |  | N07.0002004.00202 |  |  | N07.0002004.00202
2022-04-05 00:00:00 | N12.0007001.00003 | PO |  |  |  | N12.0007001.00003 |  |  | N12.0007001.00003 | PO
2022-05-05 00:00:00 | N15.0006001.00006 | SIV |  |  |  | N15.0006001.00006 |  |  | N15.0006001.00006 | SIV
2022-05-06 00:00:00 | N15.0006001.00008 | TECO |  |  |  | N15.0006001.00024 |  |  | N15.0006001.00024
2022-07-07 00:00:00 | N15.0006001.00025 | PR
2022-08-06 00:00:00 | N07.0002004.00082 | PR
2023-01-01 00:00:00 | N07.0002004.00143 | MO
2023-02-03 00:00:00 | N07.0002004.00196 | PR
2023-02-05 00:00:00 | N07.0002004.00082 | PO
Spreadsheet: 268667d1380729889-how-to-dynamically-synchronize-data-between-two-sheets-projects
Sheet: Project Build

Customer | ACME 1 | ACME 2 | ACME 3
KICK OFF MEETING | 2013-09-25 00:00:00 | 2013-09-27 00:00:00 | 2013-09-25 00:00:00
DBE | 0 | 0 | 0
FIRST ROUND CONTENT DUE | 7 | 7 | 10
LOGO DESIGN DUE | 0 | 7 | 7
LOGO REVISION 1 DUE FROM CLIENT | 0 | 3 | 3
LOGO REVISION 1 DUE TO CLIENT | 0 | 3 | 3
LOGO REVISION 2 DUE FROM CLIENT | 0 | 3 | 3
LOGO REVISION 2 DUE TO CLIENT | 0 | 3 | 3
LOGO SIGN OFF | 0 | 1 | 1
HP DESIGN DUE | 7 | 7 | 7
SECOND ROUND CONTENT DUE | 2 | 2 | 2
HP REVISIONS 1 DUE FROM CLIENT | 3 | 3 | 3
HP REVISIONS 1 DUE TO CLIENT | 3 | 3 | 3
HP REVISIONS 2 DUE FROM CLIENT | 3 | 3 | 3
HP REVISIONS 2 DUE TO CLIENT | 3 | 3 | 3
HP SIGN OFF | 1 | 1 | 1
INNER PAGE DESIGN DUE | 5 | 5 | 5
DESIGN PHASE INVOICE SENT | 1 | 1 | 1
INNER PAGE REVISIONS 1 DUE FROM CLIENT | 2 | 2 | 2
INNER PAGE REVISIONS 1 DUE TO CLIENT | 3 | 3 | 3
INNER PAGE REVISIONS 2 DUE FROM CLIENT | 3 | 3 | 3
INNER PAGE REVISIONS 2 DUE TO CLIENT | 3 | 3 | 3
INNER PAGE SIGN OFF | 1 | 1 | 1
ENTER DEV | 5 | 5 | 5
INTERNAL DEV REVIEW | 14 | 14 | 14
CLIENT DEV REVIEW | 5 | 5 | 5
DEVELOPMENT PHASE INVOICE SENT | 1 | 1 | 1
DEV REVISIONS DUE FROM CLIENT | 3 | 3 | 3
DEV REVISIONS DUE TO CLIENT | 3 | 3 | 3
DEV SIGN OFF | 5 | 5 | 5
Final Payment | 2 | 2 | 2
GO LIVE! | 2 | 2 | 2
Spreadsheet: 122501d1316876151-re-extracting-data-from-multiple-sheets-rows-793288-re-extracting-data-example
Sheet: Sheet1

Number | Date | Name | Random | Job | Business | Unit | Service | FT? | Random2 | Random3 | Location | Random4 |  | Revised COUNTIFS
1 | 2011-09-20 00:00:00 | [NAME] | 1 | Job 1 | D | A | A | FT | 1 | 1 | London | 1
2 | 2011-09-12 00:00:00 | [NAME] | 2 | Job 2 | F | B | A | FT | 2 | 2 | Rome | 2
3 | 2011-04-07 00:00:00 | [NAME] | 3 | Job 3 | E | C | B | FT | 3 | 3 | Paris | 3
4 | 2011-03-02 00:00:00 | [NAME] | 4 | Job 4 | D | A | C | FT | 4 | 4 | New York | 4
5 | 2011-03-01 00:00:00 | [NAME] | 5 | Job 5 | E | B | B | PT | 5 | 5 | Sydney | 5
6 | 2010-11-10 00:00:00 | [NAME] | 6 | Job 6 | D | C | A | FT | 6 | 6 | Beijing | 6
7 | 2009-07-07 00:00:00 | [NAME] | 7 | Job 7 | F | A | A | PT | 7 | 7 | Madrid | 7
Spreadsheet: 889965d1741037445-reference-a-table-object-in-let-merge-tables-with-inheritance
Sheet: Primary

Key Value | Primary | Value 2 | Value 3 | Value 4 | Value 5 | Value 6
1234561
1234562
1234563
1234564
1234565
1234566
1234567
1234568
1234569
1234570
1234571
1234572
1234573
1234574
1234575
1234576
Spreadsheet: 715663d1611821511-understanding-the-lookup-formula-forum-excel-22-jan-2021
Sheet: Projection

Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR
FT
PL
UR
Spreadsheet: 2a390e4b-ac59-4e02-893e-fe9c8e5bd29a
Sheet: Sheet1

Unnamed: 0 | Company Name | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Company Address
 | City | State | Zip
 | Company Website
 | Company Phone |  | Company Fax
 | Please complete your contact information.  Also indicate if your information should be published in the MCC Membership Directory.
 | Last Name | First Name | E-Mail | Phone | [NAME]?
 |  |  |  |  | Yes or No?
 | Return via e-mail to [EMAIL]
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 19565 | 19737
2 | 19701 | 19737
3 | 19719 | 19737
4 | 19712 | 19737 |  | -10000 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 19700 | 19737 |  | -50
6 | 19696 | 19737 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 22849 | 22895
8 | 19738 | 19737 |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 159450
2001-12-08 00:00:00
CBS Dollars
 |  |  | 416892
Spreadsheet: 785226d1656261534-conditional-lookup-based-on-two-cells-cadet-tracker
Sheet: Tracker

CADET Tracker |  |  |  |  | [NAME] |  |  | [NAME]
Student Status | Students | Sponsorship |  |  | Student Status | # of FO |  | Student Status | # of FO
 |  | MOHE | Self
[NAME] |  |  |  |  | Waiting for SIM |  |  | Assessment
SIM Phase - Advanced |  |  |  |  | Flight School Foundation -CK043 |  |  | Ground Introduction
SIM Phase - Intermediate |  |  |  |  | Flight School Night -CK044-047 |  |  | SIM
SIM Phase - Basic |  |  |  |  | [NAME] |  |  | [NAME] 1
Flight School CK51 - CK70 |  |  |  |  | Final Check |  |  | [NAME] 2
Flight School CK31 - CK50 |  |  |  |  |  |  |  | Completion Date
Flight School CK01 - CK30
GROUND SCHOOL
Total |  |  |  |  | Total |  |  | Total
Spreadsheet: 110810d1307404457-how-to-cross-referencing-two-lists-and-copying-relevant-information-book1
Sheet: Sheet2

Name | Phone | Address
[NAME]
Gordo
Stumpy
[NAME]
Suzy
[NAME]
Fred
Spreadsheet: 113064d1309009191-countif-for-two-criteria-countif-for-two-criteria
Sheet: Stats

 | Stats (desired result)-Credit Card
Item | Current Formula | Desired Result | Is formula ok?
Number of cells contain "may be RM" in remark column | 3 | 3 | ok
Number of cells contain "may be RM" in remark column G and PCT in column H (both criteria) | 2 | 2 | ok
number of blank cell, exclude Sav product | 6 | 2 | ok
number of blank cell | 10 | 6 | ok
 | Stats (desired result)-upg
Number of blank cell in column O with code PCT | (COUNTBLANK(INDEX(Data,,8)))-,COUNTIF("dataupg","pct") | 4 | not matched
Spreadsheet: 140176d1328641142-excel-2010-bi-weekly-paycheck-tracker-pay-check-total-mahju
Sheet: Payday

PAYDAY | PAYCHEQUE |  |  |  |  | EMPLOYER | HOURLY PAY RATE
 |  | >23 Feb
2012-02-09 00:00:00 |  | < 8Marh |  |  |  | Company 1 | 36
2012-02-23 00:00:00 | 5935
2012-03-08 00:00:00 | 1475
2012-03-22 00:00:00 |  |  |  |  |  | EMPLOYER | DAILY PAY RATE
2012-04-05 00:00:00
2012-04-19 00:00:00 |  |  |  |  |  | Company 2 | 35
2012-05-03 00:00:00
2012-05-17 00:00:00
2012-05-31 00:00:00
2012-06-14 00:00:00
2012-06-28 00:00:00
2012-07-12 00:00:00
2012-07-26 00:00:00
2012-08-09 00:00:00
2012-08-23 00:00:00
2012-09-06 00:00:00
2012-09-20 00:00:00
2012-10-04 00:00:00
2012-10-18 00:00:00
2012-11-01 00:00:00
2012-11-15 00:00:00
2012-11-29 00:00:00
2012-12-13 00:00:00
2012-12-27 00:00:00
Spreadsheet: 702321d1604288752-name-range-with-spaces-from-the-dropdown-state
Sheet: Report

 |  |  | State | PROD 1 | TOTAL
 |  |  | Negeri_Sembilan | 28
 |  |  | Kelantan | 26
 |  |  | Selangor | 26
 |  |  | Kedah | 25
 |  |  | Melaka | 25
 |  |  | Sarawak | 24
 |  |  | Johor | 23
 |  |  | Penang | 22
 |  |  | Terengganu | 22
 |  |  | Perlis | 22
 |  |  | [NAME] | 22
 |  |  | Sabah | 20
 |  |  | Perak | 18
 | Select State ► | Negeri_Sembilan
Spreadsheet: 877940d1724868772-calculating-new-activity-curves-compressed-or-extended-vs-the-benchmark-trends_question_v2
Sheet: Curves

 |  | Project activity profile
 |  |  |  |  | Start |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handover (H/O) |  | Completion
 |  | Months | Start | End (H/O) | -16 | -15 | -14 | -13 | -12 | -11 | -10 | -9 | -8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | Total
 |  | Activity_curve_1 | -15 | 0 | 0 | 0.05411575629178231 | 0.05158652752143032 | 0.01512872819684801 | 0.01246649084188669 | 0.0138721906000611 | 0.03137821447265159 | 0.0709604152302872 | 0.08244533033235057 | 0.09183439580406536 | 0.14981164140877 | 0.1140851975321505 | 0.0882764912578955 | 0.06520698378926312 | 0.04852596284779472 | 0.01518585296406682 | 0.03116827624979731 | 0.03197577232944946 | 0.03197577232944946
 |  | Activity_curve_2 | -14 | 0 | 0 | 0 | 0.004583326185896409 | 0 | 0.01512559364261994 | 0.06951034551256528 | 0.142587990681096 | 0.1269892296321082 | 0.06360068588023306 | 0.04469133036008435 | 0.07680171550401085 | 0.0885765868372832 | 0.08538548350082903 | 0.05861247768237304 | 0.06633160981647705 | 0.01688606367241609 | 0.02105741719207958 | 0.1192601438999282
 |  |  | Start | End (H/O) | -16 | -15 | -14 | -13 | -12 | -11 | -10 | -9 | -8 | -7 | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | Total
 |  | Activity_curve_3_Sample | -5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.3 | 0.3 | 0.2 | 0.1
 |  | Activity_curve_3_Solution | -10 | 0 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.075 | 0.075
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: EAST-MKT-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 61095079 | 190694190
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 10727276 | 35436239
4 |  | Option Premiums | 0 | -34485
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 71822355 | 226095944
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -55320374 | -170505188
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -17391173 | -57071058
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 181309 | 578910
 | Total Purchases: |  | -72530238 | -226997336
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 137910 | 421390
14 |  | Cash Out | 4 | 11
15 |  | Cash In | -173 | -510
16 |  | Synthetic Storage | -74737 | -3023
 | Total Imbalances: |  | 63004 | 417868
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 658408 | 1981783
18 |  | W/D (Purchase from Stg) | -9543 | -27555
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -9543 | -27555
 | Total Storage: |  | 648865 | 1954228
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -3986 | -12020.5802
 |  |  | 0 | 0
23 | Fuel: |  | -181309 | -578910
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -375983
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -375983
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 106722.6413
31 |  | Prior Month Book Balance | 0 | 3759148
 |  | Total MTM Income | 0 | 3865870.6413
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -3114152.2
34 |  | Originations | 0 | 140851
35 |  | Broker Fees | 0 | -460
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 868756d1715433735-check-multiple-sheets-for-data-and-when-found-displays-it-on-last-sheet-work-in-progress
Sheet: 17 Tables 

 | Inventory Count: |  |  |  |  |  |  | TABLE COUNT DATA
 | As of: |  |  | Cultivar | # of Tables |  |  | Table | BPR # | Initial # Plants Plugged | Kill | Current room Count | Harvest Amount | Harvest Date | Density | BPR Variation | Pinched
 |  |  |  |  |  |  |  | 1
 | Plug Date: |  |  |  |  |  |  | 2
 | Cycle: |  |  |  |  |  |  | 3
 | Room: |  |  |  |  |  |  | 4
 | Status: | Flower |  |  |  |  |  | 5
 | Estimated Harvest Date |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 | Room Total Counts |  |  |  |  |  |  | 8
 | Cultivar | Biotrack Count | Room Count | [NAME] | Initial # Plugged | % Remaining |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | Pillar Table | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 | Total |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 | Room Activity |  |  |  |  |  |  | Total
 | Date | Table | BPR # | Activity | Quantity
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User1

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-11-19 00:00:00 |  |  |  | 2024-12-10 00:00:00
 | Socket | 13 mm socket | 7.16 | Y | Socket Set | 3/8 Sockets | 16.94 | Y
 | Socket Set | 3/8 Sockets | 16.94 | Y
Total
 | The list in columns B,F,J,N,R,V and Z is again formed from the data in "Reference!"
 | This Record Sheet will need to be expanded with time
 | All "User" sheets should be identical and are required to meet the same criteria. Any variances are oversights on my part.
Spreadsheet: 682189d1591957480-find-a-high-low-avg-price-sales-2020-1-
Sheet: Sheet4

Vessel |  | BF800
[NAME] |  |  |  |  | Price per Kilo Summary |  |  |  |  |  | Price per Kilo Summary (All Vessels)
Species | Presentation | Boxes | Total (Kg) |  | Species | Grade | Lowest (Kg) Price | Highest (Kg) Price | [NAME] |  | Species | Grade | Lowest (Kg) Price | Highest (Kg) Price | [NAME]
 |  |  |  |  |  |  |  |  |  |  | COD | 1
 |  |  |  |  |  |  |  |  |  |  | COD | 2
 |  |  |  |  |  |  |  |  |  |  | COD | 3
 |  |  |  |  |  |  |  |  |  |  | COD | 4
 |  |  |  |  |  |  |  |  |  |  | COD | 5
 |  |  |  |  |  |  |  |  |  |  | ANF | 1
 |  |  |  |  |  |  |  |  |  |  | ANF | 2
 |  |  |  |  |  |  |  |  |  |  | ANF | 3
 |  |  |  |  |  |  |  |  |  |  | ANF | 4
 |  |  |  |  |  |  |  |  |  |  | ANF | 5
 |  |  |  |  |  |  |  |  |  |  | ANF | 6
Spreadsheet: 551594d1513032649-solved-help-with-sorting-and-deleting-data-valid_mean
Sheet: Before

Global Company Key | Data Date | Company Name | Price May | Year | Good
17185 | 20131231 | 22ND CENTURY GROUP INC | 0.59
17185 | 20141231 | 22ND CENTURY GROUP INC | 14.96
17185 | 20151231 | 22ND CENTURY GROUP INC | 18
137136 | 20071231 | 24/7 KID DOC INC | 22.7
137136 | 20081231 | 24/7 KID DOC INC | 0.15
137136 | 20101231 | 24/7 KID DOC INC | 161.18
19881 | 20141231 | 2U INC | 14.44
19881 | 20151231 | 2U INC | 16.84
19881 | 20161231 | 2U INC | 16.35
14898 | 20061231 | 3D SYSTEMS CORP | 19.8
14898 | 20101231 | 3D SYSTEMS CORP | 0.36
14898 | 20121231 | 3D SYSTEMS CORP | 30.4
14898 | 20131231 | 3D SYSTEMS CORP | 48.52