tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683334d1592646876-pallet-caluclations-an-oldie-but-a-goldie-pallet-calculator
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Selected Shipping | Route | [NAME] | Half Pallet | Large Pallet
 | [NAME] ([NAME]) | [NAME] ([NAME]) | [NAME] ([NAME]) | [NAME] | Pallet's Required | Excess Space | Shipping Cost |  |  |  | A-B | 100 | 200 | 400
[NAME] | 1.2 | 0.8 | 0.8 |  |  |  |  |  |  | x | A-C | 200 | 400 | 800
Half Pallet | 1.2 | 0.8 | 1.1 |  |  |  |  |  |  |  | C-B | 300 | 500 | 1000
Large Pallet | 1.2 | 0.8 | 2
No | Description | [NAME] ([NAME]) | Box 1 - Length (Meter) | [NAME] ([NAME]) | Box 1 Cubic | [NAME]
SKU123 | Product 1 | 0.14 | 1.56 | 1.29
SKU124 | Product 2 | 0.12 | 0.4 | 0.4
SKU125 | Product 3 | 0.23 | 0.62 | 0.4
SKU126 | Product 4 | 0.2 | 0.5 | 0.4
Spreadsheet: 49506d1248867010-excel-2003-pivot-table-show-the-content-of-the-cell-non-calculation-679963_niconatu_v3
Sheet: Sheet1

Model | Version | Color | Dimension | Store | KEY
1 | a | zz | 5x8 | HH | 1:HH
2 | b | xx | 8x24 | QQ | 2:QQ
3 | c | OO | 18x4 | OO | 3:OO
4 | d | ww | 28x20 | PP | 4:PP
1 | c | OO | 25x40 | HH | 1:HH
2 | d | OO | 54x36 | HH | 2:HH
3 | b | zz | 35x4 | OO | 3:OO
4 | b | xx | 8x24 | QQ | 4:QQ
1 | a | zz | 81x36 | v | 1:v
2 | d | xx | 70x20 | PP | 2:PP
3 | b | xx | 55x40 | HH | 3:HH
4 | c | ww | 36x16 | HH | 4:HH
Spreadsheet: 689379d1596358890-nesting-formula-and-formatting-cells-as-text-not-numbers-numbers-query
Sheet: Numbers formatting

 |  |  |  |  |  |  |  | Candidate Santa Clause contact details: | Town: London | County: Greater London | Phone: [PHONE] | Mobile: | Email: [EMAIL]
 |  |  |  |  |  |  |  | Candidate [NAME] contact details: | Town: Cantelowes | County: Greater London | Phone: +[PHONE] | Mobile: +[PHONE] | [NAME]: [EMAIL]
 |  |  |  |  |  |  |  | Candidate Elf Numbertwo contact details: | Town: Charterhouse Square | County: Greater London | Phone: 07595-786718 | Mobile: 07595-786718 | Email: [EMAIL]
 |  |  |  |  |  |  |  | Candidate [NAME] contact details: | Town: london | [NAME] | Phone:0(44)79357 63128 | Mobile: 0(44)79357 63128 | Email: [EMAIL]
 |  |  |  |  |  |  |  | Candidate Chief Elf contact details: | Town: London | County: Greater London | Phone: [PHONE] | Mobile: [PHONE] | Email: [EMAIL]
Spreadsheet: 269462d1381167525-excluding-certain-duplicate-values-sample-spreadsheet
Sheet: Sheet1

BEFORE
ProjectNumber | ProjectName | EstimateRev | Designed by | Filtered Estimated Revenue
121853 | Jim & [NAME] | 270114 | [NAME] | 270114
121322 | [NAME] | 18690 | [NAME] | 18690
121335 | [NAME] | 85738 | [NAME] | 85738
121853 | Jim & [NAME] | 270114 | [NAME] | 270114
121340 | Ceres Solutions | 71087 | [NAME] | 71087
121853 | Jim & [NAME] | 270114 | [NAME] | 270114
121343 | [NAME] | 26838 | [NAME] | 26838
121376 | [NAME] | 39495 | [NAME] | 39495
121379 | [NAME] | 37932 | [NAME] | 37932
BEFORE
ProjectNumber | ProjectName | EstimateRev | Designed by | Filtered Estimated Revenue
121853 | Jim & [NAME] | 270114 | [NAME] | 270114
121322 | [NAME] | 18690 | [NAME] | 18690
121335 | [NAME] | 85738 | [NAME] | 85738
121853 | Jim & [NAME] | 270114 | [NAME] | 0 |  | Note the zeroed out revenue on Project Number 121853 because there was a duplicate of both job number AND "Designed by."
121340 | Ceres Solutions | 71087 | [NAME] | 71087
121853 | Jim & [NAME] | 270114 | [NAME] | 270114
121343 | [NAME] | 26838 | [NAME] | 26838
121376 | [NAME] | 39495 | [NAME] | 39495
121379 | [NAME] | 37932 | [NAME] | 37932
Spreadsheet: 882646d1731037386-sumifs-with-multiple-sum-range-and-criteria-in-different-sheets-sumifs-accross-mutiple-sheets
Sheet: Tom

Date | Name | Apple | Juice | Orange | Total
PRICE |  | 0.2 | 0.2 | 0.2
2024-11-01 00:00:00 | [NAME] | 1 | 3
2024-11-04 00:00:00 | [NAME] | 1 | 2
2024-11-08 00:00:00 | [NAME]
Spreadsheet: 142936d1330095614-auto-filter-using-macro-auto-filter-name-doc
Sheet: All CPS Contacts

tom |  |  |  |  |  | Temporary | Leaver
First Name | Last Name | Business Phone | [NAME] | E-mail | Job Title | Company | Parent Co. | Office Location | Manager's Name | Temp/Perm | Car Registration | Permit No. | Start Date | Leave Date | Comments
[NAME] | Bloggs | 0 | 0 | [EMAIL] | General | BB | BB | UK | [NAME] | Temp | AB01 CDE | 456 | 2012-02-02 00:00:00 |  | None
[NAME] | travolta
tom | cruise
tom | betten
Adam | smythe
[NAME] | Gilks
Adam | Law
Spreadsheet: 068302d6-aae7-4397-b547-39e3b697bb7b
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | [NAME],Jackson County, March 2007. |  |  |  | Accepting various easements and deeds in Jackson County and directing the City Clerk to record the acceptance.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | City Manager
 |  |  |  |  | Programs, | Water Services, &
 |  |  |  |  | Departments, | Public Works
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
Discussion (continued) |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
Details
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] ll,  ROW Services
Reviewed by:
Reference Numbers
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -13851 | -21407
2 | -20005 | -20000
3 | -20159 | -20000
4 | -20797 | -20000
5 | -20340 | -20000
6 | -20004 | -20000
7 | -20329 | -20000
8 | -20015 | -20000
9 | -20003 | -20000
10 | -26813 | -25815
11 | -19899 | -20000
12 | -23341 | -23611
13 | -19015 | -18997
14 | -19876 | -18890
15 | -20003 | -19169
16 | -19996 | -18830
17 | -19997 | -19071
18 | -20009 | -19572
19 | -20554 | -20000
20 | -20906 | -19514
21 | -20015 | -19411
22 | -19762 | -19089
23 | -19556 | -19036
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 151464
2001-09-23 00:00:00
CBS Dollars
 |  |  | 125521
Spreadsheet: 878266d1725334129-date-validation-issue-exampleworkbook-1-
Sheet: Sheet1

M2_MaterialCategories |  |  | M2_Materials
Categories |  | Category | Materials | Rate |  | Selected Category
[NAME] |  | [NAME] | 3mm Clear | 40.45
Bulkheads |  | [NAME] | 4mm Clear | 51.75 |  | 4mm Clear
Other |  | [NAME] | 4mm Clear Tough | 133.75 |  | 4mm Clear Tough
 |  | [NAME] | 5mm Clear | 65.7 |  | 5mm Clear
 |  | Other | CFC | 142.75
 |  | Other | Compact | 82.9
 |  | Bulkheads | MDF | 40
 |  | Bulkheads | Colour | 60
 |  | Bulkheads | Shadow | 30
Spreadsheet: 883059d1731543872-extracting-the-time-in-and-out-for-the-employee-report-extracting-the-time-in-and-out-for-the-employee-report
Sheet: Expected result (2)

Production / Fulfillment/OPEX
 | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
[NAME]
[NAME]
Divine Ale
[NAME]
IT Support
Production
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
9600 [NAME] Reyes
9602 [NAME]
Spreadsheet: 67887d1268400051-min-function-with-multiple-criteria-example
Sheet: Sheet1

Employee No | Start Time | Day | Event
233 | 07:00:34 | Monday | 765777
233 | 10:51:58 | Monday | 555838
233 | 13:08:08 | Monday | 666534
233 | 16:10:46 | Monday | 200003
233 | 17:11:37 | Monday | 578342
233 | 17:15:10 | Monday | 489894
233 | 07:53:16 | Tuesday | 223983
233 | 08:08:46 | Tuesday | 983928
233 | 12:19:03 | Tuesday | 759969
112 | [NAME] | Monday | 136986
112 | 13:25:13 | Monday | 155403
112 | 16:47:45 | Monday | 180120
112 | 17:22:02 | Monday | 204837
112 | 06:46:05 | Tuesday | 229554
112 | 08:44:36 | Tuesday | 254271
112 | 12:45:14 | Tuesday | 278988
675 | [NAME] | Monday | 303105
675 | 10:30:05 | Monday | 328122
675 | 12:29:43 | Monday | 353139
675 | 16:44:05 | Monday | 377156
675 | 17:24:59 | Monday | 402173
675 | 07:29:36 | Tuesday | 427190
675 | 17:04:57 | Tuesday | 707765
So for example I would like to obtain the even code for the earliest time of employee 233 on the Monday
Spreadsheet: 95983d1295472067-next-day-date-calander
Sheet: Calander

Day | Next Date | Next Next Date
SUNDAY
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
Spreadsheet: 270861d1381723205-counta-when-range-maybe-counta
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | c
 |  |  |  |  |  |  |  |  | d
 |  |  |  |  |  |  |  |  | r
counta -->
 | always evaluates as if ALL cells are populated.
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Jun

june expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 670624d1585994783-estimate-stock-at-risk-of-expiry-risk-of-non-sellable-stock
Sheet: Sheet2

 | [NAME] |  |  |  |  |  |  |  |  | Stock On Hand |  | Left Over Stock at Exit of Each Period
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Current | Sell By | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Non Sellable
Product A | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 2020-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Product A |  |  |  |  |  |  |  |  |  | 300 | 2020-06-01 00:00:00 | 300 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Product A |  |  |  |  |  |  |  |  |  | 500 | 2020-08-01 00:00:00 |  |  | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300
Product A |  |  |  |  |  |  |  |  |  | 600 | 2021-01-01 00:00:00 |  |  |  |  | 500 | 400 | 300 | 200 | 100 | 100
Spreadsheet: 0c6fcea2-0537-4bd6-9d92-ce900bd632e8
Sheet: Sheet1

METRO BANCORP, INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
8-K
01/25/2013
$3.5 MILLION; LOANS GROW 6% AND DEPOSITS UP 8%
Financial Highlights
(in millions, except per share data)
 | Quarter Ended |  |  |  |  |  |  |  |  | Year Ended
 |  |  |  |  |  |  | % |  |  |  |  |  |  |  |  | %
 | 12/31/12 |  |  | 12/31/11 |  |  | Increase |  |  | 12/31/12 |  |  | 12/31/11 |  |  | Increase
Total assets | 2634.9 |  |  | 2421.2 |  |  | 9 | %
Total deposits | 2231.3 |  |  | 2071.6 |  |  | 8 | %
Total loans (net) | 1503.5 |  |  | 1415 |  |  | 6 | %
Total revenues | 29.6 |  |  | 28.5 |  |  | 4 | % |  | 117.1 |  |  | 113.5 |  |  | 3 | %
Net income | 3.5 |  |  | 2.5 |  |  | 39 | % |  | 10.9 |  |  | 0.3 |  |  | 3670 | %
Diluted net income per common share | 0.24 |  |  | 0.18 |  |  | 33 | % |  | 0.77 |  |  | 0.02 |  |  | 3750 | %
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 1d088de3-7f0a-4970-afb3-49d4c59e4d6a
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8176 |  | 12.4 |  | 9343 |  | 16.6 |  | 2680 |  | 18.9 |  | 2091
September | 13.8 |  | 9172 |  | 13.7 |  | 10310 |  | 17.8 |  | 1458 |  | 17.6 |  | 2394
October | 13.9 |  | 11849 |  | 14.1 |  | 8703 |  | 15.7 |  | 2698 |  | 17 |  | 3367
November | 14 |  | 12784 |  | 13.9 |  | 7205 |  | 16 |  | 2988 |  | 17.7 |  | 4199
December | 14.1 |  | 11332 |  | 13.8 |  | 9947 |  | 16.1 |  | 3831 |  | 17.5 |  | 4677
January | 14.7 | 1/ |  |  | 13.6 |  | 9455 |  | 15.5 | 1/ |  |  | 17.8 |  | 5598
February |  |  |  |  | 13.3 |  | 9926 |  |  |  |  |  | 16.5 |  | 3629
March |  |  |  |  | 13 |  | 10050 |  |  |  |  |  | 16.5 |  | 4632
April |  |  |  |  | 13.3 |  | 9432 |  |  |  |  |  | 17.2 |  | 3879
May |  |  |  |  | 13.3 |  | 9698 |  |  |  |  |  | 16.5 |  | 3429
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.8 |  | 3381
July |  |  |  |  | 13.5 |  | 8037 |  |  |  |  |  | 16.6 |  | 3343
Average to date 2/ | 14.08333333333333 |  |  |  |  |  |  |  | 16.28333333333333
Season-average farm price | 14.3 | 3/ |  |  | 13.4 |  |  |  | 16.2 | 3/ 4/ |  |  | 17.1
Average marketings |  |  | 10662.6 |  |  |  | 9102.916666666666 |  |  |  | 2731 |  |  |  | 3718.25
Total volume marketed |  |  | 53313 |  |  |  | 109235 |  |  |  | 13655 |  |  |  | 44619
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated February 8, 2013.
Spreadsheet: 752881d1635063471-formula-for-data-entry-of-customer-and-products-reg-customer-list
Sheet: PRODUCT MASTER

CUSTOMER CODE | Name of the Customer | Product code | NAME OF THE PRODUCT
JAG | [NAME] | PEN | PENCIL
RAT | RATHAN | PE | PEN
CHA | [NAME] | STA | STAPLER
SMI | SMITH | SCA | SCALE
KAN | KANNAN | PAP | PAPER WEIGHT
Spreadsheet: 152837d1335546580-codnitional-formatting-across-two-cells-este994_cndl_fmtg_example1_27apr12_01
Sheet: Sheet1

1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | H
9 | I
10 | J
11 | K
12 | L
13 | M
14 | N
15 | O
16 | P
17 | Q
18 | R
19 | S
20 | T
21 | U
22 | V
23 | W
24 | X
25 | Z
26 | A1
27 | A2
28 | A3
29 | A4
30 | A5
31 | A6
32 | A7
33 | A8
34 | A9
35 | A10
36 | A11
37 | A12
38 | A13
Spreadsheet: 136802d1326828103-populate-table-from-other-sheets-based-on-drop-down-selection-fast-solutions-2012-scorecard-sue-1
Sheet: Total Machines Installed

Total Machines Installed
 |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank
 | 2012 YTD |  | January 2012 |  | February 2012 |  | March 2012 |  | April 2012 |  | May 2012 |  | June 2012 |  | July 2012 |  | August 2012 |  | September 2012 |  | October 2012 |  | November 2012 |  | December 2012
Ahub |  |  | 3000 |  | 1000
Dhub |  |  | 1000 |  | 1000
Hhub |  |  | 1000 |  | 1000
Ihub |  |  | 4100 |  | 1000
[NAME] |  |  | 1000 |  | 1000
Lhub |  | - |  | - | 1000 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Mhub |  |  | 1000 |  | 1000
Nhub |  |  |  |  | 1000
Ohub |  |  | 1000 |  | 1000
Shub |  |  | 1000 |  | 1000
Uhub |  |  |  |  | 1000
Vhub |  |  | 1000 |  | 1000
Wino |  |  | 1000 |  | 1000
Yhub |  | - |  | - | 1000 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Total |  | 13 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 9 |  | 10 |  | 11 |  | 8 |  | 13 |  | 12
Ahub
Dhub
Hhub
Ihub
[NAME]
Lhub
Mhub
Nhub
Ohub
Shub
Uhub
Vhub
Wino
Yhub
Total
Spreadsheet: eric_saibi__9846__100801
Sheet: Lost Creek 01

Owner Name | US Army Corps of Engineers
Station Name | Lost Creek Hydro Power Station
Unit Name | Hydro 01
NERC Region | WSCC
State | OR
Fuel Type | Hydro
Capacity | 25 MW
Start Date | 2001-10-09 00:00:00
End Date | 2001-10-29 00:00:00
Prv. Start Date | 2001-10-04 00:00:00
Prv. End Date | 2001-10-24 00:00:00
Comments | Annual Maintenance
SIC | 4911
Plant ID | 1028412
Unit ID | 1008339
Outage ID | 15858
Spreadsheet: 66cd180c-70a6-4c38-9b34-392b371b41cd
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
FPDF | Test | FPDF | Partial DMD Deletion/Duplication - Females only | Partial DMD Del/Dup Females | Southern blot/Gene dosage analysis | EDTA (lavender-top) tube: EDTA |  |  | 30 | mL | 30 mL whole blood collected in a lavender-top (EDTA) tube(s). Send whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed By:  Athena Dianostics, Inc. 		        377 Plantation St.                                         Four Biotech Park                                         Worcester, MA 01605 | Monday | 21-28 days | 21-28 days |  | Profile |  |  |  |  | Athena Diagnostics
FPDF | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FPDF | Result | Z0088 | Partial DMD Del/Dup Females | Partial DMD Del/Dup Females | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPDF | Billing Component | FPDF |  | sep and ID by high res |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
FPDF | Billing Component | FPDF |  | Mutation ID by enzymatic ligation or primer extension |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
FPDF | Billing Component | FPDF |  | amp, target multiplex, each |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
FPDF | Billing Component | FPDF |  | amp, target, [NAME], first 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
FPDF | Billing Component | FPDF |  | interp/report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
FPDF | Billing Component | FPDF |  | isolation/extraction |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 136553d1326720978-issues-with-average-formula-in-calculatedfield-pivottable-average_time_solution
Sheet: Sheet1

Date | Unique project | Task Category | Total time | Average time per month | Sum of unique projects within same month
2010-01-06 00:00:00 | 1 | 0 B - Transkit creation | 1:29:00
2010-01-07 00:00:00 | 0 | 0 D - Transkit update | 2:30:00
2010-01-08 00:00:00 | 1 | 0 D - Transkit update | 3:40:00
2010-01-09 00:00:00 | 1 | 0 B - Transkit creation | 1:50:00
2011-01-10 00:00:00 | 1 | 0 B - Transkit creation | 1:40:00 |  |  |  |  |  |  | Column Labels
2010-02-11 00:00:00 | 1 | 0 B - Transkit creation | 1:20:00 |  |  |  |  |  |  | 0 B - Transkit creation
2010-02-12 00:00:00 | 1 | 0 B - Transkit creation | 1:55:00 |  |  |  |  |  | Row Labels | Sum of Average time per month | Sum of Total time | Sum of Average project time
2010-02-13 00:00:00 | 1 | 0 B - Transkit creation | 0:45:00 |  |  |  |  |  | 2010
2010-02-14 00:00:00 | 0 | 0 D - Transkit update | 2:10:00 |  |  |  |  |  | Jan | 1:39:30 | 3:19:00 | 0:49:45
 |  |  |  |  |  |  |  |  | Feb | 1:20:00 | 4:00:00 | 0:26:40
 |  |  |  |  |  |  |  |  | 2011
 |  |  |  |  |  |  |  |  | Jan | 1:40:00 | 1:40:00 | 1:40:00
 |  |  |  |  |  |  |  |  | Grand Total | 4:39:30 | 8:59:00 | 0:38:30
Spreadsheet: 240897d1370444796-filter-by-entire-grouping-not-just-single-value-plant_breakdown_example
Sheet: Sheet1

Plant [NAME] by Line
Plant | Line | Job # | Job Name | total # of pieces | total # of pieces to revise | Total pieces in approval | Total pieces approved | % approved
Plant #1 | TOTAL ALL
Group 1 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
Group 2 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
Group 3 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
Group 4 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
 |  | Job # | Job Name #5
 |  | Job # | Job Name #6
 |  | Job # | Job Name #7
 |  | Job # | Job Name #8
 |  | Job # | Job Name #9
 |  | Job # | Job Name #10
 |  | Job # | Job Name #11
 |  | Job # | Job Name #12
Group 5 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
Group 6 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
Plant #2 | TOTAL ALL
Group 1 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
 |  | Job # | Job Name #5
 |  | Job # | Job Name #6
Plant #3 | TOTAL ALL
Group 1 | Line Name
 |  | Job # | Job Name #1
Plant #4 | TOTAL ALL
Group 1 | Line Name
 |  | Job # | Job Name #1
 |  | Job # | Job Name #2
 |  | Job # | Job Name #3
 |  | Job # | Job Name #4
 |  | Job # | Job Name #5
Spreadsheet: 53492d1253375895-populating-cells-with-the-result-of-a-drop-down-list-example-1-
Sheet: Sheet2

[NAME] |  |  |  | Child Nursing |  |  | choices |  |  |  |  | LIST CHOICES
10001 | Simpson | [NAME] |  | 20001 | Wales | [NAME] |  |  |  |  |  | choices
10002 | Jones | [NAME] |  | 2002 | Strauss | [NAME] |  |  |  |  |  | [NAME]
1003 | Smith | [NAME] |  | 2004 | [NAME] | [NAME] |  |  |  |  |  | Child Nursing
Spreadsheet: 814921d1674660799-sum-product-formula-over-2-sheets-sample-ss-ans2
Sheet: Rig 1 Monthly

Month | YEAR | Total Tonnage Sugar
January (52-4) | 2023
February (5-8) | 2023
March (9-13) | 2023
April (14-17) | 2023
May (18-21) | 2023
June (22-26) | 2023
July (27-30) | 2023
August (31-34) | 2023
September (35-39) | 2023
October (40-43) | 2023
November (44-47) | 2023
December (48-52) | 2023