tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78839d1279135465-excel-2007-min-ave-max-values-but-exclude-blanks-steel-price-comparison
Sheet: Steel

STEEL
[NAME] | Density | Length         m | Width           m | Weight       kg | Supplier A |  | Supplier B |  | Supplier C |  | Supplier D |  | Supplier E |  | Supplier F |  |  | LOWEST | 2nd | 3rd | HIGHEST | AVE
 |  |  |  |  | R / Sheet | R /  kg | R / Sheet | R / kg | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg
1.6 | 8045 | 2.45 | 1.225 | 38.63209000000001 | 319.33 | 8.265926073375786 | 336.26 | 8.704162782805692 | 331 | 8.568006545853459 |  | 0 | 320 | 8.283269168196698 | 310 | 8.02441700669055 |  | 0 |  |  | 8.704162782805692 | 6.974296929487029
2 | 8045 | 2.45 | 1.225 | 48.29011250000001 | 401 | 8.30397734111719 | 412.63 | 8.544813392182508 | 355 | 7.351401386774569 |  | 0 | 420 | 8.697432626606533 |  | 0 |  | 0 |  |  | 8.697432626606533 | 5.482937457780133
3 | 8045 | 2.45 | 1.225 | 72.43516875000002 | 500 | 6.902724306830581 | 611.31 | 8.439408792017204 | 585 | 8.076187438991779 | 580 | 8.007160195923474 | 510 | 7.040778792967192 | 505 | 6.971751549898887 |  | 6.902724306830581 |  |  | 8.439408792017204 | 7.573001846104852
4 | 7845 | 2.45 | 1.225 | 94.179225 | 773.46 | 8.212639252446598 | 812.83 | 8.630671997991065 |  | 0 | 750 | 7.963539729701535 | 760 | 8.069720259430888 | 765 | 8.122810524295565 |  | 0 |  |  | 8.630671997991065 | 6.833230293977608
5 | 7845 | 2.45 | 1.225 | 117.72403125 | 864.85 | 7.34641849091453 | 950 | 8.06972025943089 |  | 0 | 880 | 7.475109292946508 | 850 | 7.220276021596058 | 860 | 7.305220445379542 |  | 0 |  |  | 8.06972025943089 | 6.236124085044588
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: 3Plans-3Opt

 | Insured HRA Quote for:
 | Current Plans
 |  | Status | # |  |  |  | # |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Renewal Plans
 |  | Status | # |  |  |  | # |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Proposed Plan 1: Annual Savings Versus Renewal PH HMO
 |  | Status | Census | Medical |  | Insured HRA 250 Ded 80% to $750 |  |  |  |  | Total
 |  | Employee |  | 247.46 |  | 137.81
 |  | 2 Person |  | 593.89 |  | 263.48
 |  | Emp/Child |  |  |  | 0
 |  | Family |  | 742.37 |  | 373.27
 |  |  |  |  |  | 4Kdd/10K
 |  | Status | # |  |  |  | Insured HRA |  |  |  | Total
 | 12 | Employee
 | 0 | 2 Person
 |  | Emp/Child
 | 1 | Family
 |  | Status | # |  |  |  |  |  |  |  | Total
 | 28 | Employee
 | 10 | 2 Person
 |  | Emp/Child
 | 30 | Family
 |  | Proposed Plan Totals
 |  | Status | # |  |  |  |  |  |  |  | Total
 | 28 | Employee
 | 10 | 2 Person
 |  | Emp/Child
 | 30 | Family
 | Plan Summary
 |  | Proposed Plan 1: Annual Savings Versus Renewal
 |  | Proposed Plan 2:  Annual Savings Versus Renewal
 |  | Proposed Plan 2:  Annual Savings Versus Renewal
Spreadsheet: 718153d1613016058-sales-price-volume-mix-variance-analysis-who-can-explain-price-volume-mix-variance_1
Sheet: Sheet1

Channel: Online |  | Sales Volume |  |  |  | Price |  |  |  | Units |  |  | Mix |  |  | [NAME]
Product |  | Actual | Budget | [NAME] |  | Actual | Budget | [NAME] |  | Actual | Budget |  | Actual | Budget |  | Price | Volume | Mix | Total
#1 |  |  |  |  |  | 200 | 210 |  |  | 200 | 150
#2 |  |  |  |  |  | 100 | 180 |  |  | 600 | 50
#3 |  |  |  |  |  | 150 | 200 |  |  | 50 | 150
#4 |  |  |  |  |  | 50 | 70 |  |  | 300 | 150
Total
Price [NAME]:
Volume Proof Calculation:
Mix Proof Calculation:
Total Proof Calculation:
Channel: In-Store |  | Sales Volume |  |  |  | Price |  |  |  | Units |  |  | Mix |  |  | [NAME]
#1 |  | Actual | Budget | [NAME] |  | Actual | Budget | [NAME] |  | Actual | Budget |  | Actual | Budget |  | Price | Volume | Mix | Total
#2 |  |  |  |  |  | 150 | 210 |  |  | 250 | 150
#3 |  |  |  |  |  | 125 | 190 |  |  | 550 | 50
#4 |  |  |  |  |  | 135 | 210 |  |  | 75 | 150
Total |  |  |  |  |  | 90 | 70 |  |  | 380 | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | Mix |  |  | [NAME]
 |  | Sales Volume |  |  |  | Price |  |  |  | Units |  |  | Actual | Budget
Spreadsheet: 542292d1507794594-help-with-dropdown-list-one-more-pls
Sheet: DIARY

 |  | LEAVE THIS AN EMPTY SPOT
DATE:
TIME | Quantity | FOOD | THOUGHTS/PAIN | water
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
DATE:
TIME | Quantity | FOOD | THOUGHTS/PAIN | water
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
DATE:
TIME | Quantity | FOOD | THOUGHTS/PAIN | water
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
DATE:
TIME | Quantity | FOOD | THOUGHTS/PAIN | water
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
 |  | MANUKA HONEY + XAMOMΗΛΙ
Spreadsheet: 886335d1736352919-need-formula-book2
Sheet: Summary

 |  | S. No | Driver Name | RT1 |  |  | RT3-2 |  |  | RT4 |  |  | RT2 |  |  | RT3-1 |  |  | RT5
 |  |  |  | No. of Duties | Total Saving | Total Insentive | No. of Duties | Total Saving | Total Insentive | No. of Duties | Total Saving | Total Insentive | No. of Duties | Total Saving | Total Insentive | No. of Duties | Total Saving | Total Insentive | No. of Duties | Total Saving | Total Insentive
 |  | 1 | A Sanjay | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 | 0 | 0
 |  | 2 | Achari |  |  |  |  |  |  |  |  |  | 1 | 11 | 129
 |  | 3 | Anil |  |  |  |  |  |  | 2 | 39 | 652 |  |  |  | 1 | 25 | 488
 |  | 4 | Anjaneyulu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0
 |  | 5 | [NAME] |  |  |  |  |  |  | 3 | 0 | 0
 |  | 6 | [NAME] |  |  |  |  |  |  | 4 | 66 | 1086
 |  | 7 | Chandu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 25 | 635
 |  | 8 | D.K.Yadav | 3 | 0 | 0
Spreadsheet: 437370d1451310252-attempting-to-allocate-portions-of-the-week-randomly-to-colleagues-that-allocation-workbook_final
Sheet: Sheet1

 | That [NAME]
 |  | Monday | Tuesday | Wednesday | Thursday | Friday |  | Player | Name | Rank | Slot | Rand | Name
 | AM | 1 | 3 | 5 | 7 | 9 |  | 1 | A
 | PM | 2 | 4 | 6 | 8 | 10 |  | 2 | B
 |  |  |  |  |  |  |  | 3 | C
 | Day | Slot Number | Allocated Slot |  |  |  |  | 4 | D
1 | Monday AM | 1 | Monday AM |  |  |  |  | 5 | E
2 | Tuesday AM | 2 | Tuesday AM |  |  |  |  | 6 | F
3 | Wednesday AM | 3 | Wednesday AM |  |  |  |  | 7 | G
4 | Thursday AM | 4 | Thursday AM |  |  |  |  | 8 | H
5 | Friday AM | 5 | Friday AM |  |  |  |  | 9 | I
6 | Monday PM | 6 | Monday PM |  |  |  |  | 10 | J
7 | Tuesday PM | 7 | Tuesday PM
8 | Wednesday PM | 8 | Wednesday PM
9 | Thursday PM | 9 | Thursday PM
10 | Friday PM | 10 | Friday PM
 | Allocated Table
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | AM
 | PM
Spreadsheet: 60602d1261105263-payroll-taxes-missyreiber
Sheet: PENSION

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Current | LIMIT
 | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 | YTD TOTAL | Payroll | 41137
SMITH | 6275.918164231873 | 4920.881108277023 | 5100.287563500688 | 6524.290350450144 | 14000 |  |  |  |  |  |  |  | 36821.37718645972 | 4315.622813540278 | 4315.622813540278 | 0
Spreadsheet: 118365d1313624560-need-a-spreadsheet-for-computing-commissions-with-multiple-variables-commissionsplits
Sheet: Data

Date of Sale | Sales Price of Home | Commission % Paid to Broker | [NAME] | Procured | <Anniversary
2011-01-28 00:00:00 | 156666 | 0.027 |  | Agent
2011-02-03 00:00:00 | 64644 | 0.03 |  | Team
2011-01-27 00:00:00 | 1268879 | 0.0315 |  | Team
2011-01-28 00:00:00 | 646541 | 0.027 |  | Team
2011-02-08 00:00:00 | 647966 | 0.03 |  | Team
2011-02-17 00:00:00 | 1155696 | 0.0315 |  | Agent
2011-02-23 00:00:00 | 564852 | 0.027 |  | Team
2011-02-07 00:00:00 | 564852 | 0.03 |  | Team
2011-03-15 00:00:00 | 584852 | 0.0315 |  | Team
2011-03-04 00:00:00 | 564852 | 0.027 |  | Agent
2011-03-04 00:00:00 | 564652 | 0.03 |  | Agent
2011-02-24 00:00:00 | 564852 | 0.0315 |  | Team
2011-02-26 00:00:00 | 564852 | 0.027 |  | Team
2011-04-10 00:00:00 | 564852 | 0.03 |  | Team
2011-04-20 00:00:00 | 564852 | 0.0315 |  | Agent
2011-04-22 00:00:00 | 563852 | 0.027 |  | Agent
2011-05-20 00:00:00 | 564852 | 0.03 |  | Team
2011-06-18 00:00:00 | 564852 | 0.0315 |  | Team
2011-06-23 00:00:00 | 564852 | 0.027 |  | Team
2011-06-24 00:00:00 | 5662113 | 0.03 |  | Agent
2011-07-31 00:00:00 | 564852 | 0.0315 |  | Agent
2011-08-06 00:00:00 | 564852 | 0.027 |  | Team
2011-08-08 00:00:00 | 6877412 | 0.03 |  | Team
2011-09-15 00:00:00 | 564852 | 0.0315 |  | Team
2011-09-22 00:00:00 | 564852 | 0.027 |  | Agent
2011-09-29 00:00:00 | 564852 | 0.03 |  | Agent
2011-10-15 00:00:00 | 564852 | 0.0315 |  | Team
2011-10-29 00:00:00 | 564852 | 0.027 |  | Team
2011-11-28 00:00:00 | 2235858 | 0.03 |  | Team
2011-12-03 00:00:00 | 564852 | 0.0315 |  | Agent
2011-12-27 00:00:00 | 564852 | 0.027 |  | Agent
2011-12-28 00:00:00 | 564852 | 0.03 |  | Team
2012-01-08 00:00:00 | 564852 | 0.0315 |  | Team
2012-02-17 00:00:00 | 564852 | 0.027 |  | Team
2012-02-23 00:00:00 | 6486151 | 0.03 |  | Agent
Spreadsheet: c149a662-0ccf-4ab5-9e72-2c5084ee063e
Sheet: SF Caltrain

Site ID | Priority Ranking1 | Readiness | Street Name | Side of Street | Nearest Cross-street | Closest Property | Station Length2 | Sidewalk | Parking Lane | Private Property | Historical Site | Environmental Issues | Construction Needed | Comments (If applicable, explain construction/ environmental issues)
CSF001 | 1 | 1 | King Street | N | 4th (near landscaped area) | Caltrain Station | 16 docks | N | N | N | N | N | N | newly installed bollards may make location suboptimal by time of pilot launch
CSF002 | 1 | 1 | King Street | N | 4th (at station plaza, along station bldg) | Caltrain Station | 12 docks | N | N | N | N | N | N
CSF003 | 1 | 1 | Townsend | S | 4th (in front of Warm Planet) | Caltrain Station | 16 docks | N | N | N | N | N | N | possible pedestrian flow and circualtion impacts
CSF004 | 1 | 2 | Townsend | S | 4th (behind Warm Planet) | Caltrain Station | 25 docks | N | N | N | N | N | Y | removal of fencing
1. Only priority ranking 1 sites are being considered for the pilot program.
2. Assumes a kiosk at the station
Spreadsheet: 120637d1315418188-filling-series-column-based-on-if-condition-seriesfill_alphanumericwithblanks
Sheet: Sheet1

 | Cookstein |  | Marcol |  | Any Single Number In Any String
abc9 | A-01 |  | A-01 |  | ABC-D35-X
[NAME] | A-02 |  | A-02 |  | ABC-D36-X
abc6 | A-03 |  | A-03 |  | ABC-D37-X
[NAME] | A-04 |  | A-04 |  | ABC-D38-X
abc4 | A-05 |  | A-05 |  | ABC-D39-X
abc33 | A-06 |  | A-06 |  | ABC-D40-X
abc31 | #N/A |  | A-07 |  | ABC-D41-X
abc30 | #N/A |  | A-08 |  | ABC-D42-X
abc3 | #N/A |  | A-09 |  | ABC-D43-X
abc29 | #N/A |  | A-10 |  | ABC-D44-X
abc27 | #N/A |  | A-11 |  | ABC-D45-X
abc26 | #N/A |  | A-12 |  | ABC-D46-X
abc25 | #N/A |  | A-13 |  | ABC-D47-X
abc24 | #N/A |  | A-14 |  | ABC-D48-X
abc23 | #N/A |  | A-15 |  | ABC-D49-X
[NAME] | #N/A |  | A-16 |  | ABC-D50-X
abc2 | #N/A |  | A-17 |  | ABC-D51-X
abc19 | #N/A |  | A-18 |  | ABC-D52-X
abc180 | #N/A |  | A-19 |  | ABC-D53-X
abc17 | #N/A |  | A-20 |  | ABC-D54-X
abc16 | #N/A |  | A-21 |  | ABC-D55-X
abc15 | #N/A |  | A-22 |  | ABC-D56-X
abc13 | #N/A |  | A-23 |  | ABC-D57-X
abc12 | #N/A |  | A-24 |  | ABC-D58-X
abc100 | #N/A |  | A-25 |  | ABC-D59-X
abc10 | #N/A |  | A-26 |  | ABC-D60-X
abc1 | #N/A |  | A-27 |  | ABC-D61-X
Spreadsheet: 48b47d77-a12e-474b-9339-f63e3f375a41
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
FLASC | Test | FLASC | [NAME] and CSF Analysis | Lyme Ab Analysis Serum and CSF | Antibody Capture Enzyme Immunoassay | Plastic screw-cap vial: PlScr |  |  |  |  | [NAME] and CSF   Serum Draw blood in a red-top tube(s). Spin down and submit 2 mL refrigerate serum.   CSF Collect 1 mL CSF in a sterile plastic vial and submit refrigerate. | Serum: 0.2 mL; CSF: 0.5 mL | Specimens other than	Serum and CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed by: 	IMUGEN Reference Diagnostic Division 		           315 Norwood Park South 		           Norwood, MA 02062 | Monday through Friday | 1 - 2 days | 3 - 8 days |  | Profile |  |  |  |  | IMUGEN Reference Diatnostics Division
FLASC | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 5 days
FLASC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 5 days
FLASC | Billing Component | FLASC |  | IMMUNOASSAY INFECTIOUS AGENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 86317
FLASC | Billing Component | FLASC |  | IMMUNOASSAY INFECTIOUS AGENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 86317
FLASC | Component | FLAS | Lyme Antibody Analysis, Serum | Lyme Antibody Analysis, Serum | Not orderable by itself. See FLASC |  |  |  |  |  | Not orderable by itself. See FLASC |  |  | See FLASC |  |  |  |  |  |  |  | Yes | No
FLAS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 5 days
FLAS | Result | Z2602 | Lyme Antibody Analysis, Serum | Lyme Antibody Analysis, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FLASC | Component | FLAC | Lyme Antibody Analysis, CSF | Lyme Antibody Analysis, CSF |  |  |  |  |  |  | Not orderable by itself. See FLASC |  |  | See FLASC |  |  |  |  |  |  |  | Yes | No
FLAC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 5 days
FLAC | Result | Z2603 | Lyme Antibody Analysis, CSF | Lyme Antibody Analysis, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 797643d1664018948-formula-to-find-the-time-between-two-purchase-dates-recency-f_rs_ker-
Sheet: Transaction_export_2022-09-22 1

Customer ID | Purchase date and time | Purchase date - Month | Purchases |  | Customer ID | Expected result - Time between purchases - Months
d9e94420-3d19-449f-a471-af030119f773 | 2023-09-22 16:17:56 | 2023-09-01 00:00:00 | 1
d9e94420-3d19-449f-a471-af030119f773 | 2023-09-22 16:17:56 |  | 1 |  | 51a50013-a84f-4f2c-be93-ac9500a939b0 | 2
51a50013-a84f-4f2c-be93-ac9500a939b0 | 2022-09-22 15:45:44 |  | 1 |  | 146822c3-14ea-4c66-a603-aee100b0cbcb | 7
51a50013-a84f-4f2c-be93-ac9500a939b0 | 2022-09-22 15:45:44 |  | 1 |  | aac5a843-62ac-41ab-98a8-ae7700a07767 | 8
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-09-22 14:41:23 |  | 1 |  | 23fd7787-fb62-457a-9302-adec00feb15d | 1
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-09-22 14:41:23 |  | 1
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-09-22 14:41:23 |  | 1
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-09-22 14:41:23 |  | 1
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-09-22 14:41:23 |  | 1
aac5a843-62ac-41ab-98a8-ae7700a07767 | 2022-09-22 13:30:13 |  | 1
23fd7787-fb62-457a-9302-adec00feb15d | 2022-09-22 13:12:53 |  | 1
Customer ID - Second purchase |  |  |  |  | How do I get the time between their purchases?
d9e94420-3d19-449f-a471-af030119f773 | 2022-05-22 16:17:56 |  | 2
51a50013-a84f-4f2c-be93-ac9500a939b0 | 2022-07-22 15:45:44 |  | 2
146822c3-14ea-4c66-a603-aee100b0cbcb | 2022-02-22 14:41:23 |  | 2
aac5a843-62ac-41ab-98a8-ae7700a07767 | 2022-01-22 14:41:23 |  | 2
23fd7787-fb62-457a-9302-adec00feb15d | 2022-08-22 14:41:23 |  | 2
Spreadsheet: stacey_white__39000__Power CBO 2002 Plan Expense
Sheet: EPSC

 | ENRON PROPERTY & SERVICES CORP *
 | Use $500/month/FTE OR use details below to calculate an estimate
 | DESCRIPTIONS | ANNUAL AMOUNT | SQ FT | COST / SQ FT | Notes - Items to take into consideration
 | A / V & LOCKS / KEYS |  |  |  | Based on usage
 | CHURN/RELOCATION |  |  |  | Approx $400 Per Person per move (Phone-Lucent - $75, Boxes - $95, Furniture (chair) - $95, Flat Screen - $25, CPU - $50, [NAME]50, [NAME]50, [NAME]50, etc)
 | [NAME] |  |  |  | Based on usage
 | FORMS MANAGEMENT |  |  |  | Business cards, letterhead, etc.
 | MAIL CENTER |  |  |  | Based on usage
 | SHIPPING/RECEIVING |  |  |  | $10 per package - fed ex, UPS, etc
 | TRAVEL |  |  |  | When making reservations through TAP there are booking fees - $50 for domestic travel and $140 for international travel
 | PARKING |  |  |  | Enron subsidies approx $60 per month per FTE who parks
 | TRANSPORTATION SUBSIDY |  |  |  | Enron subsidies approx $100 per FTE who rides the bus
* | ENRON BUILDING |  | 100 | 2.08 | $2.08 per square foot per month - avg rent is $200 per cube per month (no est for Enron South at this time) - don't forget to budget for conference rooms *
 | BUILDING SERVICES |  | 100 | 0.03 | Based on square footage
 | FACILITY OPERATIONS |  | 100 | 0.05 | Based on square footage
 | SECURITY CHARGES |  | 100 | 0.07 | Based on square footage
 | FACILITY MAINT. |  | 100 | 0.04 | Based on square footage.  There is an additional cost of $20 per hour to have the A/C turned on after hrs - with a $40 min.
 | PHONE OPERATORS |  | 1 | 3.75 | Based on # of workplaces
 | CAFETERIA |  | 1 | 14.08 | Based on # of workplaces
 | * If you have questions regarding what to estimate for these services, please refer to the previous 3 months of EPSC invoices for
 | an average to project a 2002 plan.
Spreadsheet: 272381d1382368974-compare-date-in-formula-example
Sheet: Реєстр приходу

Дата приходу | [NAME] | [NAME] номер/ID модуля/МАС адреса/Номер смарт карти | Встановлено |  | Видано |  | [NAME] |  | Дублікат?
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB02421
2013-01-02 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB02421
Spreadsheet: 2eb56c63-6d23-414a-ba0a-fa600213d773
Sheet: DC SCH by District

Dual Credit Student Credit Hours (SCH)
Students 2007-08 through 2011-12
SCH By District
 | Student Credit Hours
School District | AY 2007-08 | AY 2008-09 | AY 2009-10 | AY 2010-11 | AY 2011-12
APS | 6610 | 8319 | 8170 | 9131 | 9847
Rio Rancho | 1909 | 1566 | 2119 | 1937 | 1676
State | 216 | 226 | 349 | 656 | 724
Other | 253 | 355 | 618 | 582 | 1071
 | Student Credit Hours
School District | AY 2010-11 | AY 2010-11 | AY 2009-10 | AY 2008-09 | AY 2007-08
APS | 9847 | 9131 | 8170 | 8319 | 6610
Rio Rancho | 1676 | 1937 | 2119 | 1566 | 1909
State | 724 | 656 | 349 | 226 | 216
Other | 1071 | 582 | 618 | 355 | 253
Spreadsheet: 220883d1363290955-i-need-to-find-the-average-of-separate-cells-greater-than-0-tempbook
Sheet: Sheet1

1st Sent Date | 1st Processed Date | Time Needed (1st) | 2nd Sent Date | 2nd Processed Date | Time Needed (2nd) | 3rd Sent Date | 3rd Processed Date | Time Needed (3rd) | 4th Sent Date | 4th Processed Date | Time Needed (4th) | Average Time Needed
2013-01-02 00:00:00 | 2013-01-13 00:00:00 |  | 2013-01-17 00:00:00 | 2013-01-31 00:00:00 |  | 2013-02-03 00:00:00 | 2013-02-14 00:00:00 |  |  |  |  | 0
2013-01-02 00:00:00 | 2013-01-08 00:00:00 |  | 2013-01-11 00:00:00 | 2013-01-19 00:00:00 |  | 2013-01-25 00:00:00 | 2013-02-04 00:00:00 |  | 2013-02-09 00:00:00 | 2013-02-19 00:00:00 |  | 0
2013-01-04 00:00:00 | 2013-01-23 00:00:00 |  | 2013-01-28 00:00:00 | 2013-02-20 00:00:00 |  |  |  |  |  |  |  | 0
2013-01-05 00:00:00 | 2013-01-13 00:00:00 |  | 2013-01-14 00:00:00 | 2013-01-25 00:00:00 |  | 2013-02-01 00:00:00 | 2013-02-10 00:00:00 |  |  |  |  | 0
2013-01-09 00:00:00 | 2013-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 859382d1707781288-formula-for-a-unique-group-invoice-number-based-on-multiple-invoices-in-table-book1
Sheet: Sheet1

 | Vendor | Invoice # | Group Invoice # |  | QB Pre-Fix
 | AAA | 100 |  |  | 020824 | *this is set for each weekly tracker based on date
 | AAA | 101
 | AAA | 102
 | BBB | 54
 | CCC | 205
 | CCC | 206
 |  |  | *Looking to create a formula in column D
Spreadsheet: 878724d1725980689-referencing-multiple-sheet-inorder-to-create-pt-pl-jt
Sheet: Pivot Table

Sheet Name > | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheets | Subjects
Subject > | Math |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lux | Math
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Science
 |  |  |  |  |  |  | Another way:
 |  |  |  |  |  |  | First convert the data into tables, naming the tables "Lux" and "[NAME]" respectively
 | Joshep |  |  |  |  |  | Then apply these formulas:
 | Aline |  |  |  |  |  | Name: =UNIQUE(INDIRECT(B1&"[Name]"))
 | [NAME] |  |  |  |  |  | Marks: =SUMIFS(INDIRECT(B1&"[Marks]"),INDIRECT(B1&"[Name]"),E5#,INDIRECT(B1&"[Subject]"),B2)
 |  |  |  |  |  |  | Name: =UNIQUE(FILTER(INDIRECT(B1&"[Name]"),INDIRECT(B1&"[Subject]")=B2))