tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4b18c6a0-0bb1-4356-bb4d-912842973abc
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
CYSWB | Test | CYSWB | Cysticercosis, IgG Antibody, Western Blot Assay, Serum | Cysticercosis, [NAME], West Blot, S | Western Blot Assay | Serum Gel Tube: SGT |  |  | 0.2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.2 mL | 0.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Tuesday, Thursday; 8 a.m. | Same day/1 day | 5 days | 1 | 86682 |  |  |  |  | Rochester
CYSWB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CYSWB | Result | 81354 | Cysticercosis, [NAME], West Blot, S | Cysticercosis, [NAME], West Blot, S | Alphanumeric |  |  |  |  | bands |  |  |  |  |  |  |  |  |  | 6374-3 | Taenia solium [NAME].IgG band pattern:ACnc:Pt:Ser:Ord:IB
Spreadsheet: 136548d1326718785-need-opinions-on-digital-timesheet-nxstr_time_sheet_01132012
Sheet: Sheet1

Daily Time Sheet
Technician #: | xxx | Date: | xx/xx/xxxx
Customer name
Dispatch number
Dispatch time
Arrival time
Completed time
RG/OT/CB/ST*
FR/TM/CS/PD/ES/WR/NS*
Service Charge? |  | Y
(C)omplete/(I)ncomplete |  |  |  |  |  |  |  |  |  | Contract | T&M | FR
Paid hours |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
FR on-job hours |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
Sold hours |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
Other hours |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
Flat Rate Sales |  |  |  |  |  |  |  |  |  |  |  | 0
Other Sales |  |  |  |  |  |  |  |  |  |  |  | 0
# [NAME] rate tasks sold |  |  |  |  |  |  |  |  |  |  |  | 0
# [NAME]'s sold |  |  |  |  |  |  |  |  |  |  |  | 0
# [NAME] generated leads |  |  |  |  |  |  |  |  |  |  |  | 0
* RG = Regular Time / OT = Overtime / CB = Callback / ST = Standby or Shop Time |  |  |  |  |  |  | Conversion Rate (Calls Sold / Calls Taken) |  |  |  |  | #N/A
 |  |  |  |  |  |  | # Flat Rate Tasks per Call (# Flat Rate Tasks Sold / Calls Sold) |  |  |  |  | #N/A
* FR = Flat Rate / TM = Time & Material / CS = Contract Sale / ES = Estimate / WR = Warranty |  |  |  |  |  |  | Average Dollars per Task (FR Sales / # Flat Rate Tasks Sold) |  |  |  |  | #N/A
NS = Non-standard |  |  |  |  |  |  | Sold Hours to On-Job Time (Sold Hours/On-Job Hours) |  |  |  |  | #N/A
Notes for payroll and bonuses: |  |  |  |  |  |  |  |  |  |  | For office use only
 |  |  |  |  |  |  |  |  |  |  | Type | HRS/MIN
 |  |  |  |  |  |  |  |  |  |  | RG
 |  |  |  |  |  |  |  |  |  |  | OT
 |  |  |  |  |  |  |  |  |  |  | TR/SHOP
Indicate how other hours were used (i.e. training, shop, gas, etc.):
 |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 273110d1382616292-simple-vlookup-assistance-don-sample
Sheet: Template

 |  |  |  |  | ABC Company
 |  |  |  |  | Technician Job Card
 |  |  |  |  |  |  | DB No.
 |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  | Fleet/Machine:
 |  | Client: |  | ________________________________________________________
 |  | Location: |  | ________________________________________________________
 |  | Contact: |  | ________________________________________________________
 |  | JOB Description
 |  | Product Code | Quantity | Description
 |  | Date:
 |  | Time Started: | 00:00:00
 |  | Time Finished: | 00:00:00
 |  | Total Reg: | 00:00:00
 |  | Total O/T: | 0
 |  |  |  |  |  | Job Order No:
 |  | [NAME] |  |  |  | Authorisation Signature:
 |  | [NAME]
 |  | Total Dist |  |  |  | Name: (print)
Spreadsheet: 64470d1265309391-vlookup-book2
Sheet: Sheet2

Route 19 | Name 1
Route 2 | Name 2
OFF | Name 3
Route 3 | Name 4
OFF | Name 5
Route 6 | Name 6
Route 12 | Name 7
Route 9 | Name 8
Route 8 | Name 9
Route 10 | Name 10
Route 11 | Name 11
Route 7 | Name 12
Route 13 | Name 13
Route 14 | Name 14
Flex | Name 15
Route 16 | Name 16
Flex | Name 17
Route 18 | Name 18
Route 1 | Name 19
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 3-2T

 | Section 3: Cost
 | Table 3-2Trend: Cost Breakdown by Category by Year*
 | Cost Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Depreciation | 591492852.97 | 890121517.34 | 1040616069.01 | 1013257546.06 | 996005634.74
 | Maintenance | 1197856338.89 | 1203848656.62 | 962801607.63 | 982432596.44 | 1148425950.49
 | Indirect | 150078649.29 | 397683480.97 | 252824284.39 | 247973007.56 | 261704149.11
 | Comm. Lease | 78938098.65 | 72307833.36 | 72971036.96 | 35647116.12 | 46009220.7
 | [NAME] | 1098311932.29 | 1140911564.13 | 1113145203.95 | 1083474423.68 | 1010492166.82
 | Fuel | 644278830.21 | 888401331.41 | 999016821.94 | 990613999.03 | 981176415.17
 | Total | 3760956702.32 | 4593274383.86 | 4441375023.9 | 4353398688.92 | 4443813537.06
 | *GSA Lease Cost above includes fuel. The line for Fuel therefore is only for non-GSA Fleet vehicles.  [NAME] and overhead for GSA Fleet vehicles are also included in the lease cost.
 |  |  | Cost Type | 2013
 |  |  | Depreciation | 996005634.74
 |  |  | Maintenance | 1148425950.49
 |  |  | Indirect | 261704149.11
 |  |  | Comm. Lease | 46009220.7
 |  |  | [NAME] | 1010492166.82
 |  |  | Fuel | 981176415.17
 |  |  | Total | 4443813537.06
Spreadsheet: 860660d1708671752-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 |  |  |  |  |  |  |  |  |  |  |  |  | a | 1
 |  | b |  |  |  |  |  |  |  |  |  |  |  |  | a | 5
 |  | c |  |  |  |  |  |  |  |  |  |  |  |  | a | 8
 |  | d |  |  |  |  |  |  |  |  |  |  |  |  | a | 4
 |  | e |  |  |  |  |  |  |  |  |  |  |  |  | b | 3
 |  | f |  |  |  |  |  |  |  |  |  |  |  |  | b | 7
 |  | g |  |  |  |  |  |  |  |  |  |  |  |  | b | 9
 |  | h |  |  |  |  |  |  |  |  |  |  |  |  | g | 1
 |  | i |  |  |  |  |  |  |  |  |  |  |  |  | g | 5
 |  | j |  |  |  |  |  |  |  |  |  |  |  |  | g | 7
 |  | k |  |  |  |  |  |  |  |  |  |  |  |  | g | 3
 |  | l |  |  |  |  |  |  |  |  |  |  |  |  | g | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 2
Spreadsheet: 757778d1638455383-filter-formula-over-multiple-sheets-permit-register-gk
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number | BUILDING PERMIT | Job Notes
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-09 00:00:00 | 001/001/005 | BP | Note 4
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-04-11 00:00:00 | 001/001/007 | BP | Note 6
ABC-22001 | Address 1 | Description 1 | Client 1 | 2022-01-01 00:00:00 | 001/001/2201 | BP | Note 9
ABC-22003 | Address 3 | Description 3 | Client 3 | 2022-01-03 00:00:00 | 001/001/2203 | BP | Note 11
Spreadsheet: 8b171791-978b-4ed3-a638-e35f38d6bd75
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 1/14/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2011/12 | Jun |  | 70554 |  | 2237 |  | 2000 |  | 1743 |  | 73048
 | Jul |  | 72573 |  | 2098 |  | 2000 |  | 1327 |  | 75344
 | Aug |  | 79317 |  | 2308 |  | 2000 |  | 2390 |  | 81235
 | Sep |  | 76269 |  | 2245 |  | 2000 |  | 1652 |  | 78863
 | Oct |  | 81402 |  | 2247 |  | 2000 |  | 1487 |  | 84162
 | Nov |  | 77915 |  | 2568 |  | 2000 |  | 1763 |  | 80720
 | Dec |  | 73135 |  | 2464 |  | 2000 |  | 1291 |  | 76308
 | Jan |  | 74522 |  | 2579 |  | 2000 |  | 1233 |  | 77868
 | Feb |  | 73931 |  | 2057 |  | 2000 |  | 1330 |  | 76658
 | Mar |  | 78437 |  | 2555 |  | 2000 |  | 1843 |  | 81149
 | Apr |  | 74497 |  | 2622 |  | 2000 |  | 1513 |  | 77606
 | May |  | 76171 |  | 2530 |  | 2000 |  | 2310 |  | 78390
2012/13 | Jun |  | 72876 |  | 2173 |  | 2000 |  | 1760 |  | 75290
 | Jul |  | 75861 |  | 2296 |  | 2000 |  | 2912 |  | 77245
 | Aug |  | 82910 |  | 2345 |  | 2000 |  | 2193 |  | 85063
 | Sep |  | 79725 |  | 2069 |  | 2000 |  | 2283 |  | 81511
 | Oct |  | 81567 |  | 2462 |  | 2000 |  | 1840 |  | 84189
 | Nov |  | 78073 |  | 2438 |  | 2000 |  | 1613 |  | 80897
 | Dec |  | 73283 |  | 2369 |  | 2000 |  | 1442 |  | 76210
 | Jan |  | 72290 |  | 2191 |  | 2000 |  | 1550 |  | 74931
 | Feb |  | 71716 |  | 2101 |  | 2000 |  | 1674 |  | 74143
 | Mar |  | 76088 |  | 2391 |  | 2000 |  | 1744 |  | 78734
 | Apr |  | 74750 |  | 2581 |  | 2000 |  | 1432 |  | 77899
 | May |  | 76429 |  | 2530 |  | 2000 |  | 2042 |  | 78917
2013/14 | Jun |  | 73123 |  | 2277 |  | 2000 |  | 2430 |  | 74970
 | Jul |  | 74417 |  | 2519 |  | 2000 |  | 1474 |  | 77461
 | Aug |  | 81332 |  | 2548 |  | 2000 |  | 1450 |  | 84431
 | Sep |  | 78207 |  | 2271 |  | 2000 |  | 1498 |  | 80981
 | Oct |  | 0 |  | 2700 |  | 0 |  | 1845 |  | 855
 | Nov |  | 0 |  | 2448 |  | 0 |  | 1612 |  | 836
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/Briefing/Wheat/wheatfooduse.htm for more information. Source: Data through the 2nd quarter of 2011 was calculated using data from U.S. Department of Commerce, Bureau of the Census’ Flour Milling Products (MQ311A) and U.S. Department of Commerce, Bureau of Economic Analysis’ Foreign Trade Statistics. Subsequent flour milling calculations are based on data from the North American Millers Association.
Date run: 1/13/2014
Spreadsheet: 806389d1669276788-copy-paste-data-based-on-group-name-and-group-head-copy-data-based-on-group-name-and-group-head
Sheet: Sheet1

Organized Data form: |  |  |  |  |  |  |  | Un-Orgainzed Data form … Actually data exist in working sheets. |  |  |  |  |  | [NAME]
Customer_Name | [NAME] | Group Name | Group Member ID | Group Head | Credit  Days | Desired Credit  Days |  | Customer_Name | [NAME] | Old New Dlr Business Group Name | Old New Dlr Business Group | Group Head of A/c | Credit  Days | Desired Credit  Days
AWAN A ELECTRONCIS | Group Dlrs | AWAN | G | H | 30 | 30 |  | AWAN A ELECTRONCIS |  | AWAN | G | H | 30
AWAN B ELECTRONCIS | Group Dlrs | AWAN | G |  |  | 30 |  | BROTHER B ELECTRONICS |  | BROTHER | G
AWAN C ELECTRONCIS | Group Dlrs | AWAN | G |  |  | 30 |  | CHAUDHARY B CORPORATION |  | CHAUDHARY | G
BROTHER A ELECTRONICS | Group Dlrs | BROTHER | G | H | 40 | 40 |  | ZAMINDARA A ELECTRONICS |  |  |  |  | 30
BROTHER B ELECTRONICS | Group Dlrs | BROTHER | G |  |  | 40 |  | BROTHER A ELECTRONICS |  | BROTHER | G | H | 40
BROTHER C ELECTRONICS | Group Dlrs | BROTHER | G |  |  | 40 |  | BROTHER C ELECTRONICS |  | BROTHER | G
CHAUDHARY A CORPORATION | Group Dlrs | CHAUDHARY | G | H | 50 | 50 |  | CHAUDHARY C CORPORATION |  | CHAUDHARY | G
CHAUDHARY B CORPORATION | Group Dlrs | CHAUDHARY | G |  |  | 50 |  | BUMBAY ELECTRONICS |  |  | G |  | 45
CHAUDHARY C CORPORATION | Group Dlrs | CHAUDHARY | G |  |  | 50 |  | AWAN B ELECTRONCIS |  | AWAN | G
ZAMINDARA A ELECTRONICS | Non-Group Dlrs |  |  |  | 30 | 30 |  | AWAN C ELECTRONCIS |  | AWAN | G
BUMBAY ELECTRONICS | Non-Group Dlrs |  |  |  | 45 | 45 |  | CHAUDHARY A CORPORATION |  | CHAUDHARY | G | H | 50
KOLKATA ELECTRONICS | Non-Group Dlrs |  |  |  | 90 | 90 |  | KOLKATA ELECTRONICS |  |  |  |  | 90
Need a formula to copy credit days's of column "E" to all other group member in column "F" based on Group name and group haed.
Spreadsheet: 2abc333d-dfea-4eed-baa5-334330438406
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Country |  | 2011/12 | 2010/11 | 2010/11 | 2009/10 | 2008/09 | 2007/08
or |  | as of | as of | market | market | market | market
region |  | April 2012 | April 2011 | year | year | year | year
 |  |  |  | 1,000 metric tons
ASIA |  | 405.354 | 385.555 | 529.789927 | 563.943544 | 536.401387 | 720.1501
China |  | 2.5 | 1.979 | 3.099664 | 3.786815 | 3.951477 | 122.996458
India |  | 81.226 | 64.718 | 96.454493 | 94.809691 | 74.049801 | 119.053533
Pakistan |  | 11.298 | 13.488 | 17.316937 | 19.386689 | 16.851572 | 19.37655
Thailand |  | 292.176 | 290.77 | 393.401422 | 400.976938 | 422.132044 | 454.383251
Vietnam |  | 16 | 12.177 | 15.901274 | 41.55395 | 17.477892 | 0.557244
Other |  | 2.153999999999996 | 2.423000000000002 | 3.616137 | 3.429461 | 1.938601 | 3.783064
EUROPE & FSU |  | 9.122 | 7.723 | 12.509634 | 9.410672 | 7.566448 | 8.544636
Italy |  | 5.954 | 4.868 | 7.529541 | 6.220285 | 5.73241 | 6.322959
Spain |  | 2.823 | 2.541 | 3.752805 | 1.55218 | 0.419219 | 0.419324
Russia |  | 0.006133 | 0.004275 | 0.034217 | 0.032442 | 0.064456 | 0.109972
United Kingdom |  | 0.037 | 0 | 0.00935 | 0.126368 | 0.429608 | 0.533302
Other |  | 0.3018669999999997 | 0.3097249999999994 | 1.183721 | 1.479397 | 0.920755 | 1.159079
WESTERN HEMISPHERE |  | 43.309 | 22.186 | 42.735403 | 30.357434 | 31.065164 | 28.463008
Argentina |  | 2.11 | 1.576 | 2.677326 | 2.466583 | 1.121503 | 2.633889
Brazil |  | 27.567 | 3.426 | 6.331146 | 3.51007 | 3.902248 | 2.440662
Canada |  | 3.026 | 2.365 | 17.067255 | 15.357974 | 18.035834 | 13.571453
Mexico |  | 0.633 | 0.765 | 1.263642 | 6.120591 | 6.094151 | 9.207343
Uruguay |  | 9.958 | 14.01 | 15.35029 | 2.871551 | 1.710958 | 0.257859
Other |  | 0.01499999999999346 | 0.04399999999999693 | 0.045744 | 0.030665 | 0.20047 | 0.351802
OTHER |  | 0.7150000000000176 | 3.336000000000006 | 3.532636 | 5.470538 | 39.298261 | 5.195028
Egypt |  | 0 | 0 | 0 | 0.644508 | 36.591199 | 2.714611
United Arab Emirates |  | 0.478 | 2.89 | 3.029955 | 4.441327 | 2.224564 | 2.161834
Other |  | 0.2 | 0.4 | 0.502681 | 0.384703 | 0.482498 | 0.318583
TOTAL |  | 458.5 | 418.8 | 588.5676 | 609.182188 | 614.33126 | 762.352772
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.  2/ Most recent month available.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated June 12, 2012.
Spreadsheet: 61224d1262041359-commission-report-commission-report-working-2010
Sheet: Payroll

Consultant |  | Start |  |  |  | [NAME] |  | Week |  | Acct Manager | Rate | [NAME] | Rate | Amount | Amount |  | Partnership
 |  | Date | Client | Pay | [NAME] | Reg | OT | Ending | Burden |  |  |  |  | Billed | To Be PAID | Hrly Profit | Hrly profit | Wkly PROFIT
[NAME], [NAME] | F | 2009-06-16 00:00:00 | Temp | 223 | 242 |  |  | 2009-12-31 00:00:00 | 0.05 | [NAME] | 0.3 | [NAME] | 0.1 | 0 | 0 | 7.849999999999994 | 19 | 0
Spreadsheet: 48112d1247265531-conditional-formatting-add-duplicates-add-20matching-1-
Sheet: Add matching

Customer Name | P/N | Amount | Total
[NAME] | OPA2277U | 103 | 1984
[NAME] | OPA2277U | 1881
[NAME] | PTH12010WAH | 3032 | 239664
[NAME] | PTH12010WAH | 44243
[NAME] | PTH12010WAH | 192389
[NAME] | PTH12050WAH | 3088 | 251951
[NAME] | PTH12050WAH | 48416
[NAME] | PTH12050WAH | 200447
[NAME] | PTN78000AAH | 1882 | 1882
ABC | PTN78000AAH | 15655 | 68820
ABC | PTN78000AAH | 53165
[NAME] | PTN78000HAH | 1852 | 69642
[NAME] | PTN78000HAH | 15423
[NAME] | PTN78000HAH | 52367
[NAME] | PTN78060WAH | 3492 | 258707
[NAME] | PTN78060WAH | 50840
[NAME] | PTN78060WAH | 204375
[NAME] | SN5404J | 21 | 21
[NAME] | SN5406J | 36 | 36
[NAME] | SN65LBC176D | 45 | 45
ABC | SN74LVC07ADR | 425 | 425
[NAME] | SN74LVC07ADR | 1063 | 1063
[NAME] | [NAME] | 405 | 1065
[NAME] | [NAME] | 660
[NAME] | SN74LVCC3245APWR | 6720 | 6720
Spreadsheet: 64448d1265299612-dynamic-worksheets-and-retrieving-values-for-non-blank-cells-sample2
Sheet: Questionnaire

 | [NAME]
 |  | A |  | 0
 |  | C |  | 0
 |  | E |  | 0
 |  | G |  | 0
 |  | I |  | 0
 |  | K |  | 0
 |  | M |  | 0
 |  | O |  | 0
 |  | B |  | 0
 |  | D |  | 0
 |  | F |  | 0
 |  | H |  | 0
 |  | J |  | 0
 |  | L |  | 0
 |  | N |  | 0
 |  | Total input |  | 0
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | 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 | 48787667 | 230002158
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2111677 | 10517579
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 50899344 | 240519737
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -55110380 | -256512519
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2696013 | -13380254
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 18622765 | 86432767
 | Total Purchases: |  | -39183628 | -183460006
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 64010931 | 319840398
12 |  | Purchases | -81914955 | -401896181
 | Total Intra CTS Sales / Purchases |  | -17904024 | -82055783
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 5741672 | 27963176
18 |  | W/D (Purchase from Stg) | -6373815 | -29767097
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -6373815 | -29767097
 | Total Storage: |  | -632143 | -1803921
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 6820451 | 30972894.24737842
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -2408210.76
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -2408210.76
 |  |  | 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 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
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: 728213d1618367054-countifs-returning-spill-or-value-error-test_12april21-1-
Sheet: Expected outcome

 |  |  | 2005598 | 2005459 | 2005653 | 2004879
 | HR |  |  |  |  |  |  |  |  |  | *Looking to identify which customres in AllCust list have already purchased a Support material for the same Product in the Support by prod list.
33569 | HR | 1
47869 | Commerce |  |  | 1
558896 | Sales |  |  |  | 1
558879 | Platform |  | 1
223564 | Service |  |  |  |  | 1
557896 | PoS
66989896 | LP
45478 | Accounting
111587 | Platform |  | 1
Spreadsheet: 526189d1499178614-dynamic-ranges-which-adds-column-test
Sheet: Sheet1

 | 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 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Inbound ZIG | 1263 | 887 | 827 | 609 | 1121 | 697 | 705 | 673 | 820 | 821 | 1368 | 773 | 533 | 716 | 786 | 608 | 852 | 844 | 933 | 630 | 509 | 411 | 612 | 403 | 753 | 500
Spreadsheet: 127778d1320558586-negative-times-roster-a
Sheet: Sheet1

Employ   Type | Base Hourly Rate B4 6pm      mon-fri |  | FOH ROSTER | MONDAY  AM |  | MONDAY  PM |  | TUESDAY AM |  | TUESDAY  PM |  | WEDNESDAY  AM |  | WEDNESDAY  PM |  | THURSDAY  AM |  | THURSDAY  PM |  | FRIDAY    AM |  | FRIDAY     PM |  | SATURDAY  AM |  | SATURDAY  PM |  | SUNDAY    AM |  | SUNDAY    PM
 |  | W.E. | 6.11.11 | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin | Start | Fin
Full Time1 |  |  | A | 12:00:00 | 19:00:00 | 19:30:00 | 01:00:00 | 06:00:00 | 15:00:00 | 17:00:00 | 23:30:00 | 08:00:00 | 14:00:00 | 16:00:00 | 00:00:00 | 07:30:00 | 09:30:00 | 14:00:00 | 20:30:00 | 08:00:00 | 14:00:00 | 21:00:00 | 00:30:00 | 06:00:00 | 13:30:00 | 15:00:00 | 01:00:00 | 08:00:00 | 13:30:00 | 15:30:00 | 00:00:00
Full Time3 |  |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 17:30:00
Full Time4 |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 00:30:00
19Y.O.Jnr
20Y.O.Jnr
Full Time1
 | ADD Total Rev
 | From budget
BUDGET $$$ | 65000
 |  |  |  |  |  |  |  |  |  |  | 0.041666667 | 60
 |  |  | FOH ROSTER | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  |  | SUNDAY |  | TOTAL HRS
 |  |  |  | AM | B4 6pm | Aft 6pm | AM | B4 6pm | Aft 6pm | AM | B4 6pm | Aft 6pm | AM | B4 6pm | Aft 6pm | AM | B4 6pm | Aft 6pm | AM B4  1PM | AM Aft  1PM | PM  B4 1pm | PM  Aft 1pm | AM | PM
 |  |  | FOH ROSTER | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  |  | SUNDAY |  | TOTAL $$$
 |  |  |  | AM    $$ | B4 6pm      $$ | $$     Aft 6pm | AM    $$ | B4 6pm      $$ | $$     Aft 6pm | AM    $$ | B4 6pm      $$ | $$     Aft 6pm | AM    $$ | B4 6pm      $$ | $$     Aft 6pm | AM    $$ | B4 6pm      $$ | $$     Aft 6pm | $AM B4  1PM | $AM Aft  1PM | PM  B4 1pm$ | PM  Aft 1pm$ | AM           $$ | $$            PM
Spreadsheet: 175730d1345630663-help-with-data-validation-example-data-val
Sheet: Sheet1

 |  |  |  |  | Life Science |  |  | Life Science | Public Sector | Corparate |  |  | 2011-06-01 00:00:00
Sector |  |  |  |  | Public Sector |  |  | Housing | NHS | Accounts |  |  | 2011-07-01 00:00:00
Month |  |  |  |  | Corparate |  |  | EHRC | PCT | Publishing |  |  | 2011-08-01 00:00:00
 |  |  |  |  |  |  |  | DVZT | Gov | Commercial |  |  | 2012-06-01 00:00:00
 |  |  |  |  |  |  |  |  | Schools | Advert |  |  | 2012-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Electrics |  |  | 2012-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Enterprise
Spreadsheet: 173878d1344831391-move-multiple-entrys-from-one-column-too-one-row-in-multiple-columns-pm-test
Sheet: Sheet1

Before
1234 | 13.02.2012
7890 | 01.12.2012
5678 | 09.05.2012
5678 | 25.08.2012
7890 | 21.03.2012
1234 | 09.07.2012
After
 | Jan | Feb | March | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
1234 |  | 13.02.2012 |  |  |  |  | 09.07.2012
7890 |  |  | 21.03.2012 |  |  |  |  |  |  |  |  | 01.12.2012
5678 |  |  |  |  | 09.05.2012 |  |  | 25.08.2012
5678
7890
1234