tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 485407d1476873656-conditional-lookup-value-with-subtraction-penpencilrubber
Sheet: Sheet2

Name | Pen | Pencil | Rubber
A | 1 | 4 | 6
B | 1 | 4 | 6
C | 1 | 4 | 6
D | 1 | 4 | 6
E | 1 | 4 | 6
F | 1 | 4 | 6
G | 1 | 4 | 6
H | 1 | 4 | 6
I | 1 | 4 | 6
J | 1 | 4 | 6
K | 1 | 4 | 6
L | 1 | 4 | 6
M | 1 | 4 | 6
Mark | 50 | 20 | 60
n | 1 | 4 | 6
o | 1 | 4 | 6
p | 1 | 4 | 6
Spreadsheet: 22855d1212007767-search-for-a-file-and-bring-back-data-to-master-spreadsheet-job-cost-summary
Sheet: Sheet1

 | Materials-Steel & Misc |  |  |  | Materials-Joist & Deck |  |  |  | Fabrication Labor |  |  |  | Erection Labor |  |  |  | Subcontractors |  | Equipment Rental |  | Detailing |  |  |  | Detailing - Outside Contract
 | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid | Actual | Bid | Actual | Bid |  | Actual |  | Bid | Actual
Job # | Weight | Cost | Weight | Cost | Weight | Cost | Weight | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost | Cost | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost
4754 |  |  | 145116 | 93393 |  |  | 0 | 52140 |  |  | 624.75 | 11672 |  |  | 2733.75 | 59868 |  | 11850 |  | 26333 |  |  | 153.5 | 3900 |  | 1800
Spreadsheet: 859681d1707986581-inserting-subtotal-n-total-to-array-formula-subtotal-n-totel-4-
Sheet: End

Type | Subtype | Account Code | Description | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
 | Sales | #1 | Sales-Toy | 5150 | 4800 | 4800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Revenue | Sales | #2 | Sales-Furniture | 15800 | 15000 | 15500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Revenue | Sales | #3 | Sales-Hardware | 39000 | 32100 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal Sales |  |  | 59950 | 51900 | 27300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Revenue | F&B | #4 | Sales-F&B | 6905 | 8500 | 6500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal F&B |  |  | 6905 | 8500 | 6500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue |  |  |  | 66855 | 60400 | 33800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | [NAME] | #5 | COGS-Hardware | -26800 | -30000 | -30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | [NAME] | #6 | COGS-Furniture | -8700 | -9000 | -7900 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | [NAME] | #7 | COGS-F&B | -1500 | -1500 | -1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal COGS |  |  | -37000 | -40500 | -39400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Staff Cost | #8 | Salary | -3150 | -3150 | -4800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Staff Cost | #9 | Allowance | -900 | -650 | -1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Staff Cost | #10 | Medical Fee | -150 | -150 | -150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal Staff Cost |  |  | -4200 | -3950 | -6450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Misc | #11 | Depreciation | -480 | -480 | -480 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Misc | #12 | Utilities | -1100 | -1300 | -1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | Misc | #13 | Site Maintenance | -2100 | -2100 | -3200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] |  |  | -3680 | -3880 | -4680 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expenses |  |  |  | -44880 | -48330 | -50530 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Overall Balance |  |  |  | 21975 | 12070 | -16730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 136189d1326465983-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration-2-
Sheet: Schedule

Site 1 |  | 2012-01-01 00:00:00 |  | 2012-01-02 00:00:00 |  | 2012-01-03 00:00:00 |  | 2012-01-04 00:00:00 |  | 2012-01-05 00:00:00 |  | 2012-01-06 00:00:00 |  | 2012-01-07 00:00:00
Random Location, Anytown |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  |  | S | M | T | W | T | F | S | Totals
14327 | Doe, [NAME] |  |  | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
14327 | Doe, [NAME] |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00
13940 | Smith, [NAME] | 13:00:00 | 19:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
13940 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
15434 | Jones, [NAME] | 00:01:00 | 13:00:00
15427 | Random, Name |  |  | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
14327 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
9999 | [NAME], Glenn | 19:00:00 | 23:59:00
Spreadsheet: 877187d1723884713-map-filter-and-sumifs-of-two-different-ranges-sum-lookup1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Expected Result > Prefix>GO24 >
 |  |  | Lookup1 >Prefix >GO24 |  |  | [NAME] applied |  |  |  |  | Code | Name of Flower | Data | Diff.
 |  |  | 1 | 4600569 |  |  | Name of Flower | Data |  |  | 11 | Sunflower
 |  |  | 2 | 947505 |  | 11 | Sunflower | 1146798.66 |  |  | 36 | Jasmine | 947505
 |  |  | 3 | 219559 |  | 11 | Sunflower | 3453770.34 |  |  | 44 | Marigold | 219559
 |  |  | 4 | 758004 |  |  |  |  |  |  | 12 | Lily | 758004
 |  |  | 5 | 1134915.5 |  |  |  |  |  |  | 51 | Hibiscus
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 195744 | 58758 | 175451 | 119935 | 307312 | 174333 | 133002 | 17084 | 1181619
FRA | 67151 | 69619 | 211916 | 242789 | 5875 | 0 | 0 | 0 | 597350
OTHER* | 71513 | 37877 | 107270 | 48982 | 134543 | 54435 | 35040 | 9198 | 498858
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 57244d1257361511-interpolation-on-a-connected-scatter-plot-series_60
Sheet: 37.50ft

Station |  | SM | Function of Ordinates | Arm | Functions of Longitudinal Moment | Arm | Fuctions of Longitudinal Moment of Inertia | Cubes of Half-Ordinates | SM | Function of Half-Cubes
 | WL
 |  | 0.5
 |  | 2
 |  | 0.5
 |  | 2
 |  | 1.5
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 2
 |  | 4
 |  | 1.5
 |  | 2
 |  | 0.5
 |  | 2
 |  | 0.5
 |  | f(A) = |  |  |  | [f(M)]^2 = |  |  | f(I) =
 |  |  |  | f(M) = |  | f(A)
 |  |  |  |  |  | f(IL) =
Total Area = (M) x AWL =
Center of Gravity of waterplane from ordinate 5 = f(M)/f(A) x s =
Moment of waterplane about ordinate 5 = f(M) x 2/3 s^2 =
Longitudinal I of WP about axis through its center of gravity = f(IL) x 2/3 x s^3 =
Transverse I of WP about centerline = f(I) x 2/9 s =
Spreadsheet: 63710d1264589988-advanced-sum-macro-example
Sheet: Tabelle1

data |  | output data
Y |  | [NAME] | X1 | X2 | X3 | X4
X |  | 2 | 1 | 0 | 0 | 1
X
Y
[NAME]
Y
X
Xa
X
Yb
Y
Y
Spreadsheet: 9872df56-4808-4a2a-91f5-6f16fa663902
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 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
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October | 12.72 | 12.97 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November | 12.92 | 13.17 |  | 14.93 | 15.28 |  | 13.4 | 13.58
December | 12.62 | 12.86 |  | 13.9 | 14.21 |  | 14.5 | 14.67
January | 12.35 | 12.59 |  | 12.61 | 12.88 |  | 13.98 | 14.15
February | 11.77 | 12.43 |  | 11.81 | 12.2 |  | 12.68 | 13.35
March | 12.16 | 12.84 |  | 11.52 | 11.92 |  | 12.13 | 12.76
April | 12.18 | 12.86 |  | 11.15 | 11.54 |  | 11.76 | 12.36
May | 12.08 | 12.75 |  | 11.42 | 11.82 |  | 11.58 | 12.17
June 2/ | 12.16 | 12.84 |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.31272727272727 | 12.75 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated June 12, 2013.
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
Post retirement |  | -32063 |  |  |  |  |  | 32063 |  | 630
Post employee |  | -61500 |  |  |  |  |  | 61500 |  | 630
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 31692d1227630708-never-ending-time-sheet-time_sheets_2009
Sheet: 01-24-09

 |  |  |  |  | Employee Time Sheet
 | Station # | 20
 | Personnel Number | Employee Name | Date | Work Schedule Checked & Planned |  |  | AT | AL | SL | TR | AD | LD | other | Sta of OT | TOTALS
 | 555-555 | Mr [NAME] | 2009-01-24 00:00:00 | OFF | 7-SA | 0,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-25 00:00:00 | ASHF | 1-SO | 17,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-26 00:00:00 | BSHF | 2-MO | 7,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-27 00:00:00 | OFF | 3-TU | 0,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-28 00:00:00 | ASHF | 4-WE | 17,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-29 00:00:00 | BSHF | 5-TH | 7,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-01-30 00:00:00 | OFF | 6-FR | 0,00 |  |  |  |  |  |  |  |  | 0
 |  | TOTAL HOURS FOR THE WEEK |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | 555-555 | Mr [NAME] | 2009-01-31 00:00:00 | ASHF | 7-SA | 17,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-01 00:00:00 | BSHF | 1-SO | 7,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-02 00:00:00 | OFF | 2-MO | 0,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-03 00:00:00 | ASHF | 3-TU | 17,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-04 00:00:00 | BSHF | 4-WE | 7,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-05 00:00:00 | OFF | 5-TH | 0,00 |  |  |  |  |  |  |  |  | 0
 | 555-555 | Mr [NAME] | 2009-02-06 00:00:00 | ASHF | 6-FR | 17,00 |  |  |  |  |  |  |  |  | 0
 | TOTAL HOURS FOR THE WEEK |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | TOTAL HOURS FOR PAY PERIOD |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | Employee Signature:____________________________ |  |  |  |  |  | Supervisor Signature:____________________________
Spreadsheet: 02ffa3b1-c791-49ea-8d84-e0ccffa516b4
Sheet: Sheet1

1994 - 38th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Lech am [NAME], Schmelzhofwiesen, Austria |  |  |  |  | 1994-09-18 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | SUI | Spenger | [NAME] | Stoll | Christian | HB-BZH Stadt Will | Jerzu/Sardinia Italy | 825.14 | 1900-01-01 07:01:00
2 | AUT | Fürstner | [NAME] | Huber | Hans | D-OSTZ [NAME] | [NAME],Spirito/Italy | 375.74 | 1900-01-01 02:10:00
3 | AUT | Wagner | [NAME] | Lewetz | [NAME] | OE-ZZI | Sontuario-Savona/Italy | 343.67 | 1900-01-01 06:38:00
4 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-OCOL Columbus II | Casarza-Sestri/Italy | 329.42 | 1900-01-01 07:17:00
5 | AUT | Starkbaum | [NAME] | Starkbaum | Roland | OE-PZS Polarstern | Genua/Italy | 310.47 | 22:12:00
6 | AVI | Fraenckel | [NAME] | [NAME] | [NAME] | D-Caribbean | Perino/Italy | 271.2 | 1900-01-01 02:44:00
7 | GER | [NAME] | Heinz | Hutmacher | [NAME] | D-Columbus | Casalmoro/Italy | 216.75 | 17:16:00
8 | POL | Makne | [NAME] | [NAME] | [NAME] | SP-BZO Polonez | [NAME] della Luna/Italy | 135.26 | 14:22:00
9 | SUI | Najer | [NAME] | Fröhlin | Hansjörg | D-OCFT | Aprica/Italy | 116.59 | 14:32:00
10 | USA | [NAME] | [NAME] | Herschend | [NAME] | N1636S Spirit of Sprinfield | Cles/Italy | 111.51 | 13:42:00
11 | GER | Kuinke | Volker | Derks | Alfred | D-OZAM Zamek | [NAME] | 74.81 | 10:00:00
12 | USA | Kittinger | [NAME] | Snow | [NAME] | D-Queen | Kühtai/Austria | 73 | 08:06:00
13 | SUI | Sutter | Rolf | [NAME] | Kurt | HB-BTE Circus Knie | Plangeroß Austria | 59.81 | 06:59:00
14 | GBR | Bosanquet | Nick | Wilkinson | [NAME] | G-BIHP Belgica | Köfles/Ötztal Austria | 57.26 | 05:00:00
15 | USA | [NAME] | [NAME] | [NAME] | Mark | N69RW Aspen | [NAME] | 48.87 | 07:06:00
Spreadsheet: 91061d1290737300-can-you-sumifs-until-delays-bvj-
Sheet: Sheet1

Date | Shift | Delay Type | Duration | Fix date | fix shift | Fix delay type | Date | Delay1 | Delay2 | Delay3 | Delay4 | Delay5
2009-07-14 00:00:00 | Night | Delay1 | 120
 |  |  | 30
 |  |  | 50
 |  | Delay2 | 10
 |  |  | 60
 |  |  | 185
 |  | Delay3 | 10
 |  |  | 30
 |  |  | 40
 |  |  | 25
 |  |  | 60
 | Day | Delay5 | 480
 | Evening | Delay2 | 65
 |  |  | 20
 |  |  | 30
 |  |  | 40
 |  |  | 345
2009-07-15 00:00:00 | Night | Delay1 | 10
 |  |  | 15
 |  |  | 20
 |  | Delay4 | 90
 |  | Delay2 | 10
 |  |  | 270
 |  | Delay3 | 10
 |  |  | 40
 |  |  | 20
 |  |  | 10
 |  |  | 30
 | Day | Delay2 | 15
 |  |  | 150
 |  |  | 15
 |  |  | 40
 |  |  | 220
 |  | Delay5 | 40
 | Evening | Delay2 | 30
 |  |  | 20
 |  |  | 40
 |  |  | 290
 |  | Delay3 | 30
 |  |  | 15
 |  |  | 5
 |  |  | 10
 |  |  | 30
 |  |  | 35
2009-07-16 00:00:00 | Night | Delay4 | 15
 |  |  | 20
 |  |  | 10
 |  | Delay2 | 15
 |  |  | 20
 |  |  | 20
 |  |  | 320
 |  | Delay3 | 40
 |  |  | 20
 |  |  | 30
 |  |  | 30
 |  | Delay5 | 20
 | Day | Delay2 | 15
 |  |  | 25
 |  |  | 360
 |  | Delay3 | 5
 |  |  | 20
 |  |  | 35
 |  | Delay5 | 40
 | Evening | Delay2 | 10
 |  |  | 40
 |  |  | 235
 |  | Delay3 | 15
 |  |  | 180
Spreadsheet: 5b6986a8-b850-45fb-8d33-d46a0e62466f
Sheet: Calculations

New EFH Chapter 14 drainage curve method uses the formula Q=CM0.83
Where C is a constant with the value of 25 for pasture and 37 for cropland (grain crops)
Calculate some values for both pasture and cropland to see which curve (A,B,C,D) most correlates:
 | DA (acres) | D | C | B | A |  | DA (sq mi)
 | 10 |  |  |  |  |  |  |  |  |  | A Curve Equation = | 1.29 * ((DA in acres)^0.74) |  | (ADA < 400 ac)
 | 20 |  |  |  |  |  |  | Pasture = Old D Curve |  |  | A Curve Equation = | 150 * ((DA in acres)/640)^0.6) |  | (ADA 400-10000 ac)
 | 30 |  |  |  |  |  |  | Cropland = Old C Curve |  |  | B Curve Equation = | 70 * ((DA in acres)/640)^0.7)
 | 50 |  |  |  |  |  |  |  |  |  | C Curve Equation = | 37 * ((DA in acres)/640)^0.83)
 | 100 |  |  |  |  |  |  |  |  |  | D Curve Equation = | 25 * ((DA in acres)/640)^0.83)
 | 200
 | 300 |  |  |  | 87
 | 400 |  |  |  | 110
 | 500
 | 1000
 | 5000
 | 10000
Spreadsheet: 116143d1311624446-constructing-formula-for-matching-value-separate-spreadsheet-edi-lookup-table
Sheet: Sheet1

VDOE Project Name | Code
[NAME] | 1-2-2402640
ARRA Educational Technology Grant | 1-3-3302280
ARRA IDEA Part B Preschool Grant | 1-3-3302111
ARRA IDEA Part B State Grant | 1-3-3302191
ARRA St Fiscal Stabilization Fund - Education St [NAME] | 1-3-3303000
ARRA Title I Grants to LEAs | 1-3-3302111
At-Risk SOQ Payments | 1-2-2402650
Basic Aid - SOQ Payments | 1-2-2402020
Clinical Faculty & Mentor Teacher Prog. | 1-2-2402900
CTE Equipment/State Payments | 1-2-2402520
CTE Federal Payments | 1-3-3302240
[NAME] Payments | 1-2-2402520
Drug Free School Payments | 1-3-3302280
Early Intervention Payments | 1-2-2402280
Education Of The Gifted - SOQ Payments | 1-2-2402070
Education Technology [NAME] | 1-3-3302260
ESL | 1-2-2402990
Group Life-Instructional | 1-2-2402410
IDEA 611 Flow-through | 1-3-3302190
Industry Certification Costs | 1-2-2403090
ISAEP | 1-2-2402030
National Community Service Act | 1-3-3302700
NSLP Combined | 5-3-3302130
Preschool Handicapped Allocations | 1-3-3302110
Primary Class Size Payments | 1-2-2402750
Project Graduation Summer Regional Academy Grants | 1-2-2404180
Project Graduation/Senior | 1-2-2404180
Race to GED | 1-2-2402030
Race To GED-Expansion | 1-2-2402030
Regular Foster Children Education | 1-2-2402051
Remedial Education - SOQ Payments | 1-2-2402080
Remedial Summer School | 1-2-2402040
School Breakfast Incentive | 5-2-2403470
School Breakfast Program | 5-3-3302131
Social Security Benefits - Instructional | 1-2-2402210
Special Ed Foster Children | 1-2-2402590
Special Ed Regional Payments | 1-2-2402480
Special Education Payments - SOQ | 1-2-2402120
Teacher Retirement - Instructional | 1-2-2402230
Textbook Payments | 1-2-2402140
Textbooks Lottery Portion | 1-2-2402140
Title I - Local Education Agency | 1-3-3302020
Title II - Part A | 1-3-3302260
Virginia Preschool Initiative Payments | 1-2-2402810
[NAME] | 1-2-2402170
1/8% Sales Tax | 1-1-2402010
1% Sales Tax | 1-1-2402010
Spreadsheet: 113061d1309008006-show-me-the-oldest-date-and-adjacent-cell-contents-copy-of-csedate
Sheet: Sheet1

Asset Tag | Date | Type | End of Service
555 | 2000-01-01 00:00:00 | Computer | 2009-05-05 00:00:00
666 | 2001-02-02 00:00:00 | Apple | 2009-06-06 00:00:00
777 | 2004-03-03 00:00:00 | Tree | 2009-07-07 00:00:00
888 | 2006-05-05 00:00:00 | Car | 2009-08-08 00:00:00
999 | 2007-06-06 00:00:00 | Computer
 | 7/8/1901 (36526)
 | 7/8/1901 (36526)
 | The oldest computer STILL IN SERVICE is:
 | 2007-06-06 00:00:00 | <<[NAME] must be entered using Control+Shift+Enter
 | B9 should read "(999) 6/6/2007" (without quotes) or "6/6/2007 (999)" without quotes.  Ideally it would recognize that D6 does not have a date in it whereas D1, also a computer, does have a date in it.
Spreadsheet: 031780e8-163b-4501-88e5-231d89391a26
Sheet: tStudent

Table S2B. Statistical comparison of disorder content using Student's t tests.
 |  | chloroplast L>=30 |  |  | mitochondria L>=30 |  |  | nuclear L>=30 |  |  |  | t-Student
 |  | total | %dis | disordered | total | %dis | disordered | total | %dis | disordered
Vascular plants
Eudicots/Rosids/Brassicales
Arabidopsis [NAME] |  | 87 | 9.19 | 8 | 117 | 19.49 | 23 | 22175 | 52.65 | 11675
Carica papaya |  | 84 | 7.06 | 6 |  |  |  | 22067 | 43.73 | 9650
Eudicots/Rosids/Fabales
Glycine max |  | 82 | 6.02 | 5 |  |  |  | 28530 | 53.28 | 15201
Eudicots/Rosids/Malpighiales
Populus trichocarpa |  | 100 | 10.89 | 11 |  |  |  | 38835 | 40.21 | 15616
Eudicots/Rosids/Vitales
Vitis vinifera |  | 86 | 4.6 | 4 | 74 | 14.67 | 11 | 30534 | 40.11 | 12247
Monocots
Oryza sativa |  | 108 | 7.41 | 8 | 53 | 18.52 | 10 | 38227 | 49.35 | 18865
Sorghum bicolor |  | 84 | 7.06 | 6 | 32 | 12.12 | 4 | 32219 | 50.79 | 16364
[NAME] mays |  | 99 | 6.31 | 6 | 164 | 17.57 | 29 | 22271 | 56.17 | 12510
Bryophyta |  |  |  |  |  |  |  |  |  |  |  | n.d.
Physcomitrella_patens |  | 85 | 5.81 | 5 | 42 | 6.98 | 3 | 34271 | 38.23 | 13102
[NAME]
Chlamydomonas reindhardtii |  | 69 | 12.86 | 9 | 14 | 6.67 | 1 | 13201 | 45.42 | 5996
Micromonas sp RCC299 |  | 56 | 1.75 | 1 | 38 | 10.25 | 4 | 8989 | 52.91 | 4756
Ostreococcus tauri |  | 60 | 4.92 | 3 | 42 | 2.32 | 1 | 7396 | 52.52 | 3884
Spreadsheet: 92757d1292319647-select-next-blank-row-tictoc131210
Sheet: Sales ledger

Family ID | Child Name | Invoice Number | Month | Billing Date | Amount |  |  | Family ID | Child Name | Invoice Number | Month | Billing Date | Amount
Hend/3 | [NAME] | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 650 |  |  | Hend/3 | [NAME] | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 650
 |  |  |  |  |  |  |  | Hend/3 | Fíona Henderson | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 350
 |  |  |  |  |  |  |  | Hend/3 | [NAME] | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 350
 | [NAME] | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 650
Hend/3 | Fíona Henderson | Hend/3/1/2011 | 2011-01-01 00:00:00 | 2010-12-29 00:00:00 | 350
Spreadsheet: 719627d1613742866-count-distinct-values-in-two-columns-where-the-third-matches-a-value-pq-book2-aligw
Sheet: Sheet1

Month | id | Organisation |  |  |  |  | Feb | Mar
Jan | A | CNN
Jan | A | CNN |  |  | IBM
Feb | A | IBM |  |  | ABC
Feb | C | IBM
Mar | B | ABC
Mar | B | CNN
Month | id | Organisation |  |  | Organisation | Jan | Feb | Mar
Jan | A | CNN |  |  | ABC |  |  | 1
Jan | A | CNN |  |  | CNN | 1 |  | 1
Feb | A | IBM |  |  | IBM |  | 2
Feb | C | IBM
Mar | B | ABC
Mar | B | CNN
Spreadsheet: 727022d1617656298-add-an-index-column-number
Sheet: number

Horse | count | for col b
[NAME] |  | 1
[NAME] |  | 2
[NAME] |  | 3
[NAME] |  | 4
[NAME] |  | 5
[NAME] |  | 6
Horse
Port Noir |  | 1
Port Noir |  | 2
Port Noir |  | 3
Port Noir |  | 4
Horse
My Town Chicago |  | 1
My Town Chicago |  | 2
My Town Chicago |  | 3
My Town Chicago |  | 4
My Town Chicago |  | 5
Spreadsheet: 818fd1c5-c35b-4505-b991-f7e974b41c5d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | T4 (Thyroxine), Free by Dialysis, Serum | T4 (Thyroxine), Free by Dialysis, S | Equilibrium Dialysis/Tandem Mass Spectrometry (MS/MS) | Plain, Red-Top Tube: Red |  |  | 2.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2.6 mL Collection Instructions: Serum must be separated from gel within 4-6 hours of draw. Additional Information: Include name and telephone number of contact physician. | 1.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 0.8-2.0 ng/dL Reference values apply to all ages. | Monday, Wednesday, Thursday; 3 p.m. | 3 days | 8 days | 1 | 84439 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
[NAME] | Result | 8859 | T4 (Thyroxine), Free by Dialysis, S | T4 (Thyroxine), Free by Dialysis, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 6892-4 | Thyroxine.free:MCnc:Pt:Ser/Plas:Qn:Dialysis
Spreadsheet: 713855d1610980098-match-function-looking-up-number-value-20210718_su2xl_kalk-update_xl-help
Sheet: ELEV

ELEV | EBENE | H
ELEV_11 | 11
ELEV_10 | 10
ELEV_09 | 9
ELEV_08 | 8
ELEV_07 | 7
ELEV_06 | 6
ELEV_05 | 5
ELEV_04 | 4
ELEV_03 | 3
ELEV_02 | 2
ELEV_01 | 1
ELEV_EG | 0
ELEV_U1 | -1
ELEV_U2 | -2
ELEV_U3 | -3
ELEV_U4 | -4
ELEV_U5 | -5
Spreadsheet: 116438d1311838223-vlookup-based-on-two-criteria-sale-1-
Sheet: A

Inv | Date | [NAME] | Batch | quantity
1 | 2011-04-01 00:00:00 | WHITE | 8414 | 151.4
2 | 2011-04-01 00:00:00 | YELLOW | 828 | 175
3 | 2011-04-01 00:00:00 | RED | 840 | 191.4 | 840
4 | 2011-04-01 00:00:00 | GREEN | C041 | 107.3
5 | 2011-04-02 00:00:00 | WHITE | 851 | 75 | 851
6 | 2011-04-04 00:00:00 | WHITE | 8541 | 4000 | 8541
7 | 2011-04-04 00:00:00 | BLACK | 8534 | 8520 | 8423
7 | 2011-04-04 00:00:00 | BLACK | 8423 | 1500 | 8423
8 | 2011-04-04 00:00:00 | BLACK | 8531 | 9000 | 8531
990001 | 2011-04-04 00:00:00 | NAVY BLUE | 8530 | 279.1 | 8530
990002 | 2011-04-04 00:00:00 | GREY | 8518 | 1274.4
9 | 2011-04-05 00:00:00 | WHITE | 8439 | 500
10 | 2011-04-05 00:00:00 | YELLOW | 8523 | 100.6
11 | 2011-04-05 00:00:00 | YELLOW | 8551 | 25
12 | 2011-04-05 00:00:00 | MAGENTA | 8438 | 324.4 | 8438
13 | 2011-04-05 00:00:00 | BEIGE | 842 | 100.5 | 842