tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875285d1721872847-populate-invoice-sequence-at-each-change-in-order-number-excel-forum-test-data-formula-help
Sheet: Sheet1

Invoice | Order No | Code | Customer Name | Cost
INV-3000 | 888001506835701-A | 203684-WHT | [NAME] | 57
INV-3000 | 888001506835701-A | 203684-WHT | [NAME] | 57
INV-3001 | 888001506640401-A | 203684-WHT | Tas Pavlakis | 57
INV-3001 | 888001506640401-A | 203684-WHT | Tas Pavlakis | 57
INV-3002 | 888001506332001-A | 102188 | [NAME] | 196.2
INV-3003 | 888001495916101-A | TVS202 | [NAME] | 59.4
INV-3003 | 888001495916101-A | TVS202 | [NAME] | 59.4
 | 888001481187301-A | 4319-WHT | [NAME] oakes | 104.4
 | 888001506452301-A | 5290-WHT | [NAME] | 63
 | 888001505494901-A | 57946 | [NAME] | 50.4
 | 888001506748401-A | 203242-07 | Robyn Young | 55.8
 | 888001506748401-A | 203242-07 | Robyn Young | 55.8
 | 888001506748401-A | 203194 | Robyn Young | 54
 | 888001506553701-A | 502088 | [NAME] | 38.7
 | 888001506553701-A | 502088 | [NAME] | 38.7
 | 888001506848001-A | 63232 | [NAME] | 130.5
 | 888001506640501-A | MEU3880 | [NAME] | 81
 | 888001503176301-A | 5290-WHT | [NAME] | 63
 | 888001506656301-A | 2115-LSO | [NAME] | 113.4
 | 888001506365501-A | 203594-BLK | [NAME] | 100.8
 | 888001504447601-A | 203684-WHT | [NAME] | 57
 | 888001504447601-A | 203684-WHT | [NAME] | 57
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001505904201-A | 203684-WHT | [NAME] | 57
 | 888001506371201-A | 203684-WHT | [NAME] | 57
 | 888001506371201-A | 203684-WHT | [NAME] | 57
 | 888001506459101-A | 203684-WHT | [NAME] | 57
 | 888001506459101-A | 203684-WHT | [NAME] | 57
 | 888001506921401-A | 203684-WHT | [NAME] | 57
 | 888001506921401-A | 203684-WHT | [NAME] | 57
 | 888001506670101-A | 203683-BLK | [NAME] | 38.7
 | 888001506670101-A | 203683-BLK | [NAME] | 38.7
 | 888001506281601-A | 23669 | [NAME] | 130.5
Spreadsheet: 864454d1711625248-count-true-false-contunuesly-from-down-to-up-count-true-false-aligw
Sheet: Sheet1

 | True | True | True | True | True | True | True
 | True | True | True | True | True | True | True
 | False | False | False | False | False | True | False
 | True | True | True | True | True | True | False
 | True | True | True | True | True | True | False
 | False | False | True | False | False | False | False
 | False | False | True | False | False | False | False
 | True | False | False | False | False | False | True
 | True | True | True | True | False | True | True
 | False | False | False | False | False | True | False
 | False | False | False | True | False | False | False
 | False | True | False | False | False | False | False
 | False | True | False | False | False | False | True
 |  |  |  |  |  |  |  |  | This result is require from formula
 | "False" is 4 times continuous from bottom to top | "True" is 2 times continuous from bottom to top | "False" is 4 times continuous from bottom to top | "False" is 2 times continuous from bottom to top | "False" is 8 times continuous from bottom to top | "False" is 3 times continuous from bottom to top | "True" is 1 times continuous from bottom to top
Spreadsheet: 847590d1698441797-calculation-of-holiday-hours-holidays-calculator-magalela-
Sheet: LucasShift

Month | 2023-12-01 00:00:00
Date | Employee 1 |  |  |  | Employee 2 |  |  |  | Employee 3 |  |  |  |  | Annual Holidays
 | Time In | Time Out | Hours | Holiday Hours | Time  In | Time Out | Hours | Holiday Hours | Time  In | Time Out | Hours | Holiday Hours |  |  | Employee 1 | Employee 2 | Employee 3
 |  |  |  |  | 07:00:00 | 16:16:00 |  |  | 16:00:00 | 07:15:00 |  |  |  | 2023-01-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:22:00 |  |  | 16:00:00 | 07:19:00 |  |  |  | 2023-04-07 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00 |  |  |  |  |  |  |  | 2023-04-10 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:19:00 |  |  |  |  |  |  |  | 2023-04-19 00:00:00 | 0 | 0 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-04-25 00:00:00 | 0 | 0 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-05-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:11:00 |  |  |  | 2023-05-18 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:13:00 |  |  |  | 2023-07-22 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:11:00 |  |  |  |  |  |  |  | 2023-08-04 00:00:00 | 9 | 8 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:13:00 |  |  |  |  |  |  |  | 2023-08-06 00:00:00 | 8 | 0 | 9.25
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:12:00 |  |  |  | 2023-08-16 00:00:00 | 9 | 8 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:19:00 |  |  |  | 2023-08-31 00:00:00 | 0 | 9.25 | 0
 |  |  |  |  | 07:00:00 | 16:12:00 |  |  | 16:00:00 | 07:14:00 |  |  |  | 2023-12-25 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:19:00 |  |  | 16:00:00 | 07:17:00 |  |  |  | 2023-12-26 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:14:00 |  |  |  |  |  |  |  | 2023-12-28 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:17:00 |  |  |  |  |  |  |  | 2024-01-01 00:00:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:24:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:14:00
 |  |  |  |  | 07:00:00 | 16:24:00 |  |  | 16:00:00 | 07:15:00
 |  |  |  |  | 07:00:00 | 16:14:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 | 16:00:00 | 07:30:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
Spreadsheet: 709594d1608427862-change-formula-to-ignore-hidden-tabs-excelforum1335831programme-test
Sheet: Block 1

Item Name | Price | 52 | 53 | 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 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: c9a1683d-4cd7-413a-858d-d8b56f4f0bab
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
WRF | Test | WRF | Warfarin, Serum | Warfarin, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions: Spin down within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 2.0-5.0 mcg/mL Toxic concentration: > or =10.0 mcg/mL | Wednesday; 9:00 a.m. | 2 days | 7 days | 1 | 80299 |  |  |  |  | Rochester
WRF | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
WRF | Result | 8760 | Warfarin, S | Warfarin, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4098-0
Spreadsheet: 731128d1620205680-formulas-and-drop-down-lists-workload_dashboard_v2
Sheet: Resources

actiongroups
activityLogAlerts
AnalysisServices | AAS
applicationGateways | AGWAF
automationAccounts
availabilitySets
azureFirewalls | FW
components
connectionGateways
connections
disks
expressRouteCircuits | ERC
factories
metricalerts
networkIntentPolicies
networkInterfaces | NIC
networkSecurityGroups | NSG
networkWatchers
privateDnsZones
privateEndpoints
publicIPAddresses | PIP
restorePointCollections
routeTables
scheduledqueryrules
schedules
serverFarms
servers
sites
smartDetectorAlertRules
solutions
SqlVirtualMachines
storageAccounts
vaults
virtualMachines | VM
virtualNetworkGateways
virtualNetworks | [NAME]
workflows
workspaces
Spreadsheet: 167543d1342021341-how-to-automatically-add-5-minutes-to-a-time-h-mm-in-another-column-timesdiff
Sheet: Sheet1

 | 00:05:00
 |  | just typed in
 |  | v | b=c
imported> | 01:00:00 | 01:00:00 | 0 |  | difference is due to rounding and /or the other program calculated time
 | 01:05:00 | 01:05:00 | 0
 | 01:10:00 | 01:10:00 | 0
 | 01:15:00 | 01:15:00 | 0
 | 01:20:00 | 01:20:00 | 0
 | 01:25:00 | 01:25:00 | 0
 | 01:30:00 | 01:30:00 | 0
 | 01:35:00 | 01:35:00 | 0
 | 01:40:00 | 01:40:00 | 0
 | 01:45:00 | 01:45:00 | 0
 | 01:50:00 | 01:50:00 | 0
 | 01:55:00 | 01:55:00 | 0
Spreadsheet: 152142d1335273363-have-values-in-column-change-color-after-a-certain-total-is-reached-patrickmcdiver_forumsample_24apr12_01
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | This is the column! | Cumulative_Sum
April 13th | 1000 |  | 800
April 20th | 700 |  | 613
April 27th | 950 |  | 800 | 191
May 4th | 500 |  |  | 382
May 11th | 950 |  |  | 189 | 200 |  |  |  |  |  |  | 300
May 18th | 500 |  |  |  |  |  |  |  |  |  |  | 400
May 25th | 950 |  |  | 150 | 200 |  |  |  |  |  |  | 500
June 1st | 500 | 90 |  |  |  |  |  |  |  |  |  | 200
June 8th | 950 |  |  |  |  |  |  |  |  |  |  | 700
June 15th | 500 |  |  |  |  |  |  |  |  |  |  | 300
June 22nd | 950 |  |  |  |  |  |  |  |  |  |  | 200
June 29th | 500 |  |  |  |  |  | 200 |  |  |  |  | 200
July 6th | 950 | 90 |  | 150 | 200 |  | 100 |  |  |  |  | 100
Spreadsheet: 879388d1726860998-creating-an-if-formula-using-dates-and-multiple-criteria-formula-help
Sheet: Sheet1

Enrollment Begin Date | Enrollment End Date | 2024-07-01 00:00:00 |  | Notes
2020-02-01 00:00:00 |  |  |  | This would be a yes |  |  | If Col A is a date prior to the current month or is the 1st through the 3rd of the current month, AND if Col B is blank, a date greater than the current month, or the 28th-31st of the current month, then YES.
2023-05-06 00:00:00 | 2024-08-15 00:00:00 |  |  | This would be a yes |  |  | If any of these conditions are not met, then NO.
2024-07-02 00:00:00 |  |  |  | This would be a yes
2021-05-04 00:00:00 | 2024-07-30 00:00:00 |  |  | This would be a yes
2022-03-01 00:00:00 | 2024-07-15 00:00:00 |  |  | This would be a no
2024-07-20 00:00:00 |  |  |  | This would be a no
Spreadsheet: 866260d1713220093-importing-data-from-another-worksheet-when-you-type-a-name-test-blank-grade-form
Sheet: Grading Form

Date
Name | ATTCL | Name | Alpha |  | Density Spec |  | 360-440 |  | Density |  |  |  | Size | In spec | Out of Spec
 |  | Length |  |  |  |  |  |  |  |  |  |  | 14.85 - 18.15
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 9.45 - 11.55
 |  | Height |  |  |  |  |  |  |  |  |  |  | 9.45 - 11.55
 |  | No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Moisture
Spreadsheet: 883753d1732445977-calculating-average-price-in-a-stock-portfolio-stock-portfolio-jt-
Sheet: josephteh (2)

 | Individual Stock Transactions
 | TXN DATE | TICKER | TYPE | UNITS | PRICE | Cumulative Buy Units b/f | Buy Price Difference | FIFO Cost of Units Sold |  | Stock Name | Total Buy Qty | Holding Qty | Average Cost Price | Average Sell Price | Current Market Price | Value At Cost | Value At Market Price | Realized Profit/Loss | Unrealized Profit/Loss
 | 2023-07-13 00:00:00 | Stock2 | Buy | 120 | 167.4989166666666 |  |  |  |  | Stock1 |  |  |  |  | 389.25
 | 2023-07-13 00:00:00 | Stock2 | Buy | 179 | 167.543687150838 |  |  |  |  | Stock2 |  |  |  |  | 389.25
 | 2023-07-13 00:00:00 | Stock2 | Buy | 1 | 167.5
 | 2023-10-31 00:00:00 | Stock2 | Buy | 10 | 247.989 |  |  |  |  | First, convert source data into Excel Table to ensure formulas will self-adjust when new data are added.
 | 2023-10-31 00:00:00 | Stock2 | Buy | 44 | 247.9888636363636
 | 2023-10-31 00:00:00 | Stock2 | Buy | 146 | 248.0868493150685 |  |  |  |  | Added 3 Helper columns (G:I) with the following formulas:
 | 2024-06-04 00:00:00 | Stock1 | Buy | 15 | 297.2573333333333
 | 2024-06-04 00:00:00 | Stock1 | Buy | 185 | 297.3175135135135
 | 2024-06-04 00:00:00 | Stock1 | Buy | 50 | 297.2574
 | 2024-08-26 00:00:00 | Stock2 | Sell | 100 | 449.6101
 | 2024-09-26 00:00:00 | Stock1 | Buy | 150 | 385.3913333333333 |  |  |  |  | [NAME]
 | 2024-10-07 00:00:00 | Stock2 | Buy | 75 | 362.8173333333334
 | 2024-10-22 00:00:00 | Stock2 | Buy | 65 | 394.5436923076923
 | 2024-10-31 00:00:00 | Stock2 | Buy | 60 | 409.4145
 | 2024-11-13 00:00:00 | Stock1 | Buy | 50 | 385.3913333333333
 | Note: FIFO costing computation using formula from JohnTopley's posting below:
 | [NAME]
 | Calculating Average price in a stock portfolio
 | https://www.excelforum.com/excel-formulas-and-functions/1430813-calculating-average-price-in-a-stock-portfolio.html#post5996542
Spreadsheet: 825916d1681640756-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-newsample_ceepeebee-aligw
Sheet: Scenario 2 - not working

Week Date | 2023-05-04 00:00:00
Name | Team | Starting Weight | Starting Height | Starting BMI | Concurrent Week Losses | Hat-Trick | 2023-04-06 00:00:00
 |  |  |  |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
Stephan | White | 129 | 180 |  | 0 |  | 128 | 128 | 126 | 125 | 125
Stephan has lost weight 3 times in total since beginning, but has not lost weight this week compared to previous week - staying the same. This should NOT be a hat-trick as he was awarded that last week by hitting his 3rd total loss.
Spreadsheet: 286714d1388429308-insert-50-blank-columns-inbetween-insert-blank-rows-inbetween-excel-forum
Sheet: Sheet1

Raw data
id | date | p
009158AF3 | 12/01/1992 | 100
009292AA1 | 1972-12-08 00:00:00 | 102
010392AX6 | 1995-12-10 00:00:00 | 99
010392AZ1 | 2000-12-06 00:00:00 | 104
 |  |  |  |  | Target: to insert 50  blank columns inbetween
 |  |  |  |  |  | id | date | P
 |  |  |  |  |  | 009158AF3 | 12/01/1992 | 100
 |  |  |  |  | 50 blank columns inbetween
 |  |  |  |  |  | 009292AA1 | 1972-12-08 00:00:00 | 102
 |  |  |  |  | 50 blank columns inbetween
 |  |  |  |  |  | 010392AX6 | 1995-12-10 00:00:00 | 99
 |  |  |  |  | 50 blank columns inbetween
 |  |  |  |  |  | 010392AZ1 | 2000-12-06 00:00:00 | 104
 |  |  |  |  | 50 blank columns inbetween
Spreadsheet: 190643d1351726031-sumproduct-for-two-conditions-in-columns-and-rows-array-rentb23-oeldere-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] | Sara | Gemma | Nick
 |  | Date | Person | Hours |  |  | 2012-01-01 00:00:00
 | 1 | 2012-01-03 00:00:00 | [NAME] | 5
 | 2 | 2012-01-05 00:00:00 | Sara | 3
 | 3 | 2012-03-15 00:00:00 | [NAME] | 4
 | 4 | 2012-03-19 00:00:00 | Gemma | 5
 | 5 | 2012-02-15 00:00:00 | Nick | 6
 | 6 | 2012-02-05 00:00:00 | Nick | 7
 | 7 | 2012-02-05 00:00:00 | Gemma | 4
Spreadsheet: kate_symes__18184__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
Spreadsheet: 164139d1340656143-pulling-multiple-results-from-one-column-that-correspond-to-a-second-column-book4-nbvc-oeldere-
Sheet: Sheet1

Name | count | year
[NAME] | 5 | 2010
[NAME] | 5 | 2010
[NAME] | 6 | 2010
[NAME] | 7 | 2013
[NAME] | 5 | 2009
[NAME] | 7 | 2009
Sara | 6 | 2010
Sara | 6 | 2013
 | SUM of count | Collumn
 | Rijlabels | 2009 | 2010 | 2013 | Endtotal
 | [NAME] | 12 |  |  | 12
 | [NAME] |  | 16 | 7 | 23
 | Sara |  | 6 | 6 | 12
 | Endtotal | 12 | 22 | 13 | 47
Spreadsheet: 036b3e7e-f9f7-4abf-992d-ad3f0cdea135
Sheet: CDS-J

[NAME]
J1 | Degrees conferred between July 1, 2010 and June 30, 2011
J1 | For each of the following discipline areas, provide the percentage of diplomas/certificates, associate, and bachelor’s degrees awarded. To determine the percentage, use majors, not headcount (e.g., students with one degree but a double major will be represented twice). Calculate the percentage from your institution’s IPEDS Completions by using the sum of 1st and 2nd majors for each CIP code as the numerator and the sum of the Grand Total by 1st Majors and the Grand Total by 2nd major as the denominator. If you prefer, you can compute the percentages using 1st majors only.
J1 | Category | Diploma/Certificates | Associate | Bachelor’s | CIP 2010 Categories to Include
J1 | Agriculture |  |  |  | 1
J1 | Natural resources and conservation |  |  | 0.006 | 3
J1 | Architecture |  |  | 0.037 | 4
J1 | Area, ethnic, and gender studies |  |  | 0.001 | 5
J1 | Communication/journalism |  |  | 0.098 | 9
J1 | Communication technologies |  |  |  | 10
J1 | Computer and information sciences |  |  | 0.004 | 11
J1 | Personal and culinary services |  |  |  | 12
J1 | Education |  |  | 0.14 | 13
J1 | Engineering |  |  |  | 14
J1 | Engineering technologies |  |  | 0.024 | 15
J1 | Foreign languages, literatures, and linguistics |  |  | 0.018 | 16
J1 | Family and consumer sciences |  |  | 0.045 | 19
J1 | Law/legal studies |  |  | 0.007 | 22
J1 | English |  |  | 0.034 | 23
J1 | Liberal arts/general studies |  | 0.608 | 0.114 | 24
J1 | Library science |  |  | 0.001 | 25
J1 | Biological/life sciences |  |  | 0.023 | 26
J1 | Mathematics and statistics |  |  | 0.008 | 27
J1 | Military science and military technologies |  |  |  | 28 & 29
J1 | Interdisciplinary studies |  |  |  | 30
J1 | [NAME] and recreation |  |  |  | 31
J1 | Philosophy and religious studies |  |  | 0.006 | 38
J1 | Theology and religious vocations |  |  |  | 39
J1 | Physical sciences |  |  | 0.013 | 40
J1 | Science technologies |  |  |  | 41
J1 | Psychology |  |  | 0.031 | 42
J1 | Homeland Security, law enforcement, firefighting, and protective services |  | 0.004 | 0.033 | 43
J1 | Public administration and social services |  |  | 0.015 | 44
J1 | Social sciences |  |  | 0.041 | 45
J1 | Construction trades |  |  |  | 46
J1 | Mechanic and repair technologies |  |  |  | 47
J1 | Precision production |  |  |  | 48
J1 | Transportation and materials moving |  |  |  | 49
J1 | Visual and performing arts |  |  | 0.067 | 50
J1 | Health professions and related programs |  | 0.052 | 0.085 | 51
J1 | Business/marketing |  | 0.336 | 0.137 | 52
J1 | History |  |  | 0.012 | 54
J1 | Other
J1 | TOTAL (should = 100%)