tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828347d1683425809-calculate-normal-and-after-hours-from-start-and-finish-time-example-time-calculation-take-3
Sheet: original testing sheet

 |  |  |  | Using from 16:30 - 7:30 for after hours
 | Start & End |  | Tot. Hours | After Hours | Working (A/H) | Normal Hours | Manually Entered for reference |  |  |  |  | using after hours
 | Start | End |  |  | But need for XX:XX |  | [NAME] | A/H Correct | N/H Correct |  | with time() function | from 16:30 - 07:30
 | 23:00:00 | 08:00:00 |  |  |  |  | 09:00:00 | 00:30:00 | 08:30:00
 | 16:00:00 | 00:00:00 |  |  |  |  | 08:00:00 | 00:00:00 | 08:00:00
 | 04:00:00 | 11:00:00 |  |  |  |  | 07:00:00 | 03:30:00 | 03:30:00
 | 11:00:00 | 13:00:00 |  |  |  |  | 02:00:00 | 00:00:00 | 02:00:00
 | 20:00:00 | 04:00:00 |  |  |  |  | 08:00:00 | 00:00:00 | 08:00:00
 | 23:00:00 | 07:00:00 |  |  |  |  | 08:00:00 | 00:00:00 | 08:00:00 | <-- added test
 | 22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 00:30:00 | 09:30:00
 | 03:00:00 | 10:00:00 |  |  |  |  | 07:00:00 | 02:30:00 | 04:30:00
 | 22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 00:30:00 | 09:30:00
 |  |  | Original using 23:00 - 6:00 as A/H
 | Start & End |  | Tot. Hours | After Hours | Working (A/H) | Normal Hours | Manually Entered for reference |  |  |  |  | using after hours
 | Start | End |  |  | But need for XX:XX |  | [NAME] | A/H Correct | N/H Correct |  | with time() function | from 16:30 - 07:30
 | 23:00:00 | 08:00:00 |  |  |  |  | 05:00:00 | 02:00:00 | 03:00:00
 | 16:00:00 | 00:00:00 |  |  |  |  | 08:00:00 | 01:00:00 | 07:00:00
 | 04:00:00 | 11:00:00 |  |  |  |  | 07:00:00 | 02:00:00 | 05:00:00
 | 11:00:00 | 13:00:00 |  |  |  |  | 02:00:00 | 00:00:00 | 02:00:00
 | 20:00:00 | 04:00:00 |  |  |  |  | 08:00:00 | 05:00:00 | 03:00:00
 | 23:00:00 | 07:00:00 |  |  |  |  | 08:00:00 | 08:00:00 | 00:00:00 | <-- added test
 | 22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 07:00:00 | 03:00:00
 | 03:00:00 | 10:00:00 |  |  |  |  | 07:00:00 | 03:00:00 | 04:00:00
 | 22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 07:00:00 | 03:00:00
Spreadsheet: 802491d1666881733-needing-help-to-tweak-my-formula-rates-test
Sheet: Plastics_FISC2

Start Time | End Time | Duration | Duration (Rounded) | Overtime | Amount Due | Column1
06:00:00 | 06:12:00 |  |  |  |  | 360
06:00:00 | 06:20:00 |  |  |  |  | 405
06:00:00 | 06:38:00 |  |  |  |  | 450
06:00:00 | 06:47:00
06:00:00 | 07:00:00
06:00:00 | 07:30:00
06:00:00 | 08:00:00
06:00:00 | 08:30:00
06:00:00 | 09:00:00
06:00:00 | 09:30:00
06:00:00 | 10:00:00
06:00:00 | 10:30:00
06:00:00 | 11:00:00
06:00:00 | 11:30:00
06:00:00 | 12:00:00
06:00:00 | 12:30:00
06:00:00 | 13:00:00
06:00:00 | 13:30:00
06:00:00 | 14:00:00
06:00:00 | 14:30:00
06:00:00 | 15:00:00
Spreadsheet: 121810d1316434114-excel-2007-calculation-of-tbf-time-between-failure-book1_erter
Sheet: Sheet1

2011-09-13 00:00:00 | Helper1 | Helper2 |  | Date | Total Failures per Day | Stacker | Belt | Failure (Average Interval)
Stacker | 1 | 2011-09-13 00:00:00 |  | 2011-09-13 00:00:00 | 3 | 1 | 2 | 8hrs
1 |  | 2011-09-13 00:00:00
 |  | 2011-09-13 00:00:00
Belt | 2 | 2011-09-13 00:00:00
2 |  | 2011-09-13 00:00:00
 |  | 2011-09-13 00:00:00
2011-09-14 00:00:00 |  | 2011-09-13 00:00:00
Stacker | 0 | 2011-09-14 00:00:00 |  | 2011-09-14 00:00:00 | 0 | 0 | 0 | None
0 |  | 2011-09-14 00:00:00
 |  | 2011-09-14 00:00:00
Belt | 0 | 2011-09-14 00:00:00
0 |  | 2011-09-14 00:00:00
 |  | 2011-09-14 00:00:00
2011-09-15 00:00:00 |  | 2011-09-14 00:00:00
Stacker | 1 | 2011-09-15 00:00:00 |  | 2011-09-15 00:00:00 | 4 | 1 | 3 | 6hrs
1 |  | 2011-09-15 00:00:00
 |  | 2011-09-15 00:00:00
Belt | 3 | 2011-09-15 00:00:00
3 |  | 2011-09-15 00:00:00
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: Text

Princess Puff
PIB: 108214289 MB: 63296635 265-[PHONE]-14 Raiffeisen banka a.d. [NAME]
Laze Pačua 3, [NAME], 11000 [NAME] | DATUM:
 | BROJ FAKTURE
 | ZA: |  | prodaja kolača
Ispostavi račun:
Ime:
Adresa:
Telefon:
DEO GRADA:
Ime artikla | Cena | [NAME] |  | Ukupno
 |  |  | IZNOS | IZNOS
 | UKUPNO
Ako imate bilo kakvih pitanja u vezi sa ovom fakturom, obratite se na telefon [PHONE], [EMAIL] Fiskalni račun se izdaje tek pošto dostava preuzme novac- svoj fiskalni račun za ovu porudžbinu možete dobiti u našem lokalu uz navođenje broja porudžbine.
U ukupni iznos racuna uracunat je PDV po stopi od 10%
ZAHVALJUJEMO SE NA PORUDŽBINI!
Spreadsheet: 237360d1369198871-matching-and-moving-columns-based-on-day-number-excel-post-manual-adjustment-1
Sheet: Excel post manual adjustment 1

 |  | Obs |  |  |  |  |  |  | Preds
 | Day # Obs | Tmax | Tmin | VPD | Rainfall | Duration | Radiation | Day # Pred
1906-12-29 00:00:00 | 6572 | 35 | 25.5 | 9.87 | 0 | 0 | 18000 | 6572 | 0.0734 | 0.0736 | 0.0738 | 0.0744 | 0.0753 | 0.077 | 0.0794
1906-12-30 00:00:00 | 6573 | 33.5 | 24 | 6.27 | 0.017 | 0.1356403 | 19000 | 6573 | 0.0494 | 0.0495 | 0.0496 | 0.0499 | 0.0503 | 0.0511 | 0.0527
1906-12-31 00:00:00 | 6574 | 33 | 24 | 5.73 | 0.0001 | 0.03211259 | 23000 | 6574 | 0.0369 | 0.037 | 0.037 | 0.0372 | 0.0376 | 0.0382 | 0.0393
1907-01-01 00:00:00 | 6575 | 35.5 | 25 | 7.96 | 0.0002 | 0.03272518 | 21000 | 6575 | 0.03 | 0.0301 | 0.0301 | 0.0303 | 0.0306 | 0.0312 | 0.0322
 |  |  |  |  |  |  |  | 6575.165 | 0.1862 | 0.1857 | 0.1852 | 0.1838 | 0.1814 | 0.176 | 0.1653
1907-01-02 00:00:00 | 6576 | 35.5 | 25 | 7.96 | 0 | 0 | 22000 | 6576 | 0.0768 | 0.0771 | 0.0773 | 0.078 | 0.0791 | 0.0811 | 0.0842
 |  |  |  |  |  |  |  | 6576.0836 | 0.1634 | 0.1628 | 0.1622 | 0.1604 | 0.1573 | 0.1513 | 0.1403
1907-01-03 00:00:00 | 6577 | 36 | 26 | 9.17 | 0.0218 | 0.16504462 | 21000 | 6577 | 0.0695 | 0.0697 | 0.0698 | 0.0704 | 0.0712 | 0.0727 | 0.0751
 |  |  |  |  |  |  |  | 6577.0438 | 0.1002 | 0.0996 | 0.099 | 0.0974 | 0.0949 | 0.0907 | 0.0853
1907-01-04 00:00:00 | 6578 | 35.5 | 25 | 7.96 | 0.0085 | 0.08357015 | 21000 | 6578 | 0.0546 | 0.0547 | 0.0548 | 0.055 | 0.0555 | 0.0562 | 0.0574
 |  |  |  |  |  |  |  | 6578.1307 | 0.1808 | 0.1803 | 0.1797 | 0.1781 | 0.1754 | 0.1701 | 0.159
1907-01-05 00:00:00 | 6579 | 35.5 | 26.5 | 7.65 | 0.002 | 0.0437518 | 15000 | 6579 | 0.0765 | 0.0767 | 0.0769 | 0.0775 | 0.0785 | 0.0802 | 0.083
 |  |  |  |  |  |  |  | 6579.0578 | 0.1353 | 0.1346 | 0.1339 | 0.1318 | 0.1283 | 0.1221 | 0.1119
1907-01-06 00:00:00 | 6580 | 32.5 | 23.5 | 5.3 | 0.0162 | 0.13073958 | 13000 | 6580 | 0.0634 | 0.0635 | 0.0636 | 0.064 | 0.0646 | 0.0657 | 0.0674
1907-01-07 00:00:00 | 6581 | 33.5 | 24.5 | 8.2 | 0.0043 | 0.05784137 | 15000 | 6581 | 0.0453 | 0.0453 | 0.0454 | 0.0456 | 0.046 | 0.0466 | 0.0478
1907-01-08 00:00:00 | 6582 | 34 | 25 | 6.3 | 0.0003 | 0.03333777 | 20000 | 6582 | 0.0358 | 0.0359 | 0.0359 | 0.0361 | 0.0363 | 0.0368 | 0.0378
1907-01-09 00:00:00 | 6583 | 34.5 | 24.5 | 6.38 | 0.0002 | 0.03272518 | 19000 | 6583 | 0.0324 | 0.0324 | 0.0325 | 0.0326 | 0.0328 | 0.0331 | 0.0339
 |  |  |  |  |  |  |  | 6583.086 | 0.1515 | 0.1505 | 0.1496 | 0.1464 | 0.1413 | 0.1311 | 0.1112
1907-01-10 00:00:00 | 6584 | 33.5 | 24.5 | 5.86 | 0 | 0 | 14000 | 6584 | 0.0617 | 0.0618 | 0.0619 | 0.0622 | 0.0627 | 0.0635 | 0.0643
 |  |  |  |  |  |  |  | 6584.1424 | 0.1849 | 0.1844 | 0.184 | 0.1827 | 0.1804 | 0.1756 | 0.166
1907-01-11 00:00:00 | 6585 | 33 | 25 | 5.45 | 0.0089 | 0.08602051 | 15000 | 6585 | 0.0783 | 0.0786 | 0.0788 | 0.0794 | 0.0805 | 0.0824 | 0.0855
Spreadsheet: 09739517-cd18-44cb-a08f-0b0880f6df5d
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | 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
 | Area |  | Yield |  | Supply |  |  |  |  |  | Use
Year begin. | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
Sept. 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | ------Million acres------ |  | Bu./acre |  |  |  |  |  | ------------------------------------------------------Million bushels-----------------------------------------------
2010/11 | 77.404 | 76.61 | 43.45621981464561 | 150.885 | 3329.181 | 14.4489862517322 | 3494.514986251732 |  | 1648.043 | 130.1501321115322 | 1501.3088541402 | 3279.501986251732 | 215.013
2011/121 | 74.976 | 73.636 | 41.50187408332881 | 215.013 | 3056.032 | 15 | 3286.045 |  | 1660 | 116.0450000000001 | 1335 | 3111.045 | 175
2012/132 | 73.902 | 73 | 43.9041095890411 | 175 | 3205 | 15 | 3395 |  | 1645 | 125 | 1485 | 3255 | 140
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  |  | Supply |  |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
2010/11
Sep-Nov |  |  |  | 150.885 | 3329.181 | 3.7391313958929 | 3483.805131395893 |  | 587.6937876060929 |  | 618.0273437897999 | 1205.721131395893 | 2278.084
Dec-Feb |  |  |  | 2278.084 | --- | 4.8747842171721 | 2282.958784217172 |  | 481.1960085889718 |  | 552.9627756282 | 1034.158784217172 | 1248.8
Mar-May |  |  |  | 1248.8 | --- | 2.9332424794659 | 1251.733242479466 |  | 407.9605287787658 |  | 224.4897137007 | 632.4502424794658 | 619.283
Jun-Aug |  |  |  | 619.283 | --- | 2.9018281592013 | 622.1848281592013 |  | 301.3428071377012 |  | 105.8290210215 | 407.1718281592013 | 215.013
Total |  |  |  |  | 3329.181 | 14.4489862517322 | 3494.514986251732 |  | 1778.193132111532 |  | 1501.3088541402 | 3279.501986251732
2011/12
Sep-Nov |  |  |  | 215.013 | 3056.032 | 2.8441205983722 | 3273.889120598372 |  | 479.656604109672 |  | 424.3475164887001 | 904.0041205983721 | 2369.885
Dec-Feb |  |  |  | 2369.885 | --- | 3.1416916574442 | 2373.026691657445 |  | 527.1427264479922 |  | 473.6259652094524 | 1000.768691657445 | 1372.258
Total to date |  |  |  |  | 3056.032 | 5.9858122558164 | 3062.017812255816 |  | 1006.799330557664 |  | 897.9734816981525 | 1904.772812255817
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2012-06-13 15:47:26.380000
Spreadsheet: 117452d1312814075-date-time-validation-excel-turns-h-mm-into-h-mm-ss-maintenance-log
Sheet: Sheet1

Machine ID | Person Taking Call | Service Call Time | Problem | Working? | Call Back Time | Tech | Service Start | Service End | Down Time | Service Time | Parts | Pending | Notes
12345678 | DF | 2011-08-04 11:30:00 | Error Code | No | 2011-08-04 15:00:00 | [NAME] | 2011-08-04 15:00:00 | 2011-08-04 16:00:00 |  |  | N | N
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: EM

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 877693d1724506981-pivotby-function-pivotby-function
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Result Target
 |  |  | Desc | Period | Price | Quantity |  |  | Desc | Price/Quantity | Jan | Feb
 |  |  | A1, | Jan | 0.8577469887193099 | 10 |  |  | A1, | Price | 0.8577469887193099 | 0.8577469887193099
 |  |  | A1, (Actual) | Jan | 0.84 | 10 |  |  | A1, | Quantity | 10 | 15
 |  |  | B1 | Jan | 3.870321778367618 | 10 |  |  | A1, (Actual) | Price | 0.84 | 0.84
 |  |  | B1 (Actual) | Jan | 3.89 | 10 |  |  | A1, (Actual) | Quantity | 10 | 12
 |  |  | A1, | Feb | 0.8577469887193099 | 15 |  |  | B1 | Price | 3.870321778367618 | 3.870321778367618
 |  |  | A1, (Actual) | Feb | 0.84 | 12 |  |  | B1 | Quantity | 10 | 11
 |  |  | B1 | Feb | 3.870321778367618 | 11 |  |  | B1 (Actual) | Price | 3.89 | 3.89
 |  |  | B1 (Actual) | Feb | 3.89 | 9 |  |  | B1 (Actual) | Quantity | 10 | 9
 |  |  |  | Feb | Feb | Jan | Jan
 |  |  | A1, | 0.8577469887193099 | 15 | 0.8577469887193099 | 10
 |  |  | A1, (Actual) | 0.84 | 12 | 0.84 | 10
 |  |  | B1 | 3.870321778367618 | 11 | 3.870321778367618 | 10
 |  |  | B1 (Actual) | 3.89 | 9 | 3.89 | 10
Spreadsheet: 92931d1292447006-excel-2007-adding-positive-and-negative-hour-values-already-using-1904-date-system-cal1
Sheet: Sheet1

 | Contracted Weekly Hours | = |  | 25
 | Contracted Daily Hours | =
 | Contracted Yearly Holiday Hours | =
 | January | Monday | H | Tuesday | H | Wednesday | H | Thursday | H | Friday | H | Weekly Time Owed | Holiday Hours | Total Hours | Status |  | 0
 | Date | 3rd |  | 4th |  | 5th |  | 6th |  | 7th |  |  |  |  |  |  | 0.5
 | Hours Worked |  |  | 7 |  | 7 |  | 3 |  |  |  |  |  |  |  |  | 1
 | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
 | Date | 10th |  | 11th |  | 12th |  | 13th |  | 14th |  |  |  |  |  |  | 2
 | Hours Worked | 7 |  | 6 |  |  | 1 | 4 |  | 8 |  |  |  |  |  |  | 2.5
 | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Date | 17th |  | 18th |  | 19th |  | 20th |  | 21st |  |  |  |  |  |  | 3.5
 | Hours Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5
 | Date | 24th |  | 25th |  | 26th |  | 27th |  | 28th |  |  |  |  |  |  | 5
 | Hours Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
 | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Date | 31st |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5
 | Hours Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  | Monthly Totals
Spreadsheet: 377109d1423797544-generate-sheet-for-each-person-in-database-filters-student-info-revised-2
Sheet: Sheet3

Clients |  | Student Modules |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Completed Modules | [NAME] | Number of Partially Completed Modules | Partially Completed Modules
 |  | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2 | F1 | F2 | [NAME] | G2 | H1 | H2 | I1 | I2 | J1 | J2 | K1 | K2 | L1 | L2 | M1 | M2
 |  | A | A | A |  |  |  | P | P |  |  | A |  |  |  |  |  |  |  | A | A |  |  |  |  | P | P
 |  | A | A |  |  |  | A |  |  |  |  | A | A |  |  | A | A |  |  | P | P
 |  |  |  | A | A |  |  | A | P |  |  | P | P |  |  |  |  |  |  |  |  | A | P
 |  | P | P | P | P |  |  |  |  | P | P |  |  | A | A | A | P
 |  |  |  |  |  |  |  |  |  |  |  | A | P |  |  | P | P
 |  |  |  | A | achieved
 |  |  |  | P | Partially achieved
 |  |  |  |  | Not attempted
Spreadsheet: 766589d1643955928-check-data-from-conditio-check-data-ans
Sheet: Sheet1

 |  |  |  |  |  | Name | [NAME] | Check Name | Your output | I want output
 |  |  |  |  |  | iou | oip |  |  | oip
 |  |  |  |  |  | Jeeny TY
 |  |  |  |  |  | HEH KU-FU |  |  |  |  | *delete space (LTRIM & RTRIM)
 |  |  |  |  |  | HSIH EI-EN
 |  |  |  |  |  | HSU MY |  |  |  | HSU MY
 |  |  |  |  |  | HUAG AN-FU |  |  |  | HUAG AN-FU
 |  |  |  |  |  | HUNG SHIBN | opi |  |  | opi
 |  |  |  |  |  | Tiffany | - |  |  | Tiffany | copy data from Column Name
 |  |  |  |  |  | - | Jesss |  |  | Jesss
 |  |  |  |  |  | - | -
Spreadsheet: 115271d1310910354-excel-2007-need-help-with-summing-up-the-data-in-sheet-sales-summary
Sheet: June

MONTHLY SALES DATA SHEET - JUNE
CITY | PROD. | 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 | TOTAL
HOUSTON | SHOES | 500
 | SHIRTS | 300
 | PANTS | 250
 | SOCKS | 140
DALLAS | SHOES | 300
 | SHIRTS | 125
 | PANTS | 141
 | SOCKS | 35
AUSTIN | SHOES | 650
 | SHIRTS | 120
 | PANTS | 285
 | SOCKS | 55
Spreadsheet: 546971d1510271057-fill-summary-sheet-from-multiple-tabs-with-different-names-workers-comp-tracking-sheet
Sheet: NUNN, Kevin

NAME | [NAME] |  | INJURY | Fractured Finger |  | CAPACITY | Suitable |  | PIAWE
PHONE |  |  | DATE OF INJURY |  |  | NEXT REVIEW |  |  | ROSTER
[NAME] |  |  | SITE | TERM |  | COC EXPIRY |  |  | FINAL
INSURER |  |  | CASE MANAGER |  |  | REHAB PROVIDER |  |  | DOCTOR
UPDATES
Spreadsheet: 830299d1684848513-formula-to-extract-data-into-cols-g-and-h-split-data
Sheet: Sheet1

BR1 |  |  | 1 and 2                         9 and 10 |  |  |  |  | 9 and 10
BR2 |  | 3 and 4                        5 and 6 |  |  |  |  |  | 5 and 6
BR3
BR4
BR5 |  |  | 5  and 6                     11 and 12 |  |  |  |  | 11 and 12
BR6 |  |  | 7 and 8                      1 and 2 |  |  |  |  | 1 and 2
BR7 |  |  | 9 and 10                   7 and 8 |  |  |  |  | 7 and 8
BR8 |  |  | 11 and 12                   3 and 4 |  |  |  |  | 3 and 4
BR9 |  | 13 and 14                13 and 14 |  |  |  |  |  | 13 and 14
Spreadsheet: 843625d1695403168-calculate-the-duration-duration-of-ticket
Sheet: Sheet1

start | end | duration | without holidays | Holidays |  |  |  |  |  |  | with holidays
2023-09-15 09:00:00 | 2023-09-15 12:00:00 | 3 hours |  | 2023-09-04 00:00:00
2023-09-15 09:00:00 | 2023-09-18 12:00:00 | 1 day 3 hours |  | 2023-10-09 00:00:00
2023-09-15 09:00:00 | 2023-09-19 16:30:00 | 2 days 7 hours 30 Mins
2023-09-14 09:00:00 | 2023-09-15 10:00:00 | 1 day 1 hour
2023-09-14 09:00:00 | 2023-09-15 09:01:00
2023-09-01 09:00:00 | 2023-09-05 09:01:00
2023-09-01 00:00:00 | Friday
2023-09-02 00:00:00 | Saturday
2023-09-03 00:00:00 | Sunday
2023-09-04 00:00:00 | Monday
2023-09-05 00:00:00 | Tuesday
2023-09-15 00:00:00 | Friday
2023-09-16 00:00:00 | Saturday
2023-09-17 00:00:00 | Sunday
2023-09-18 00:00:00 | Monday
2023-09-19 00:00:00 | Tuesday
2023-09-20 00:00:00 | Wednesday
2023-09-21 00:00:00 | Thursday
Spreadsheet: 33592d1230050412-chart-only-a-part-of-a-large-data-set-666524
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
0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
2 | 1 | 0 | 0 | 1 | 4 | 1 | 1 | 3 | 1 | 1 | 6 | 2 | 2 | 5 | 2 | 3 | 0 | 2 | 5 | 2 | 3 | 4 | 1 | 1 | 1 | 4 | 0 | 0 | 6 | 4 | 2 | 6 | 0 | 2 | 4 | 2 | 1 | 3 | 3 | 1 | 1 | 5 | 0 | 3 | 2 | 2 | 0 | 2 | 1 | 0 | 1
2 | 13 | 5 | 7 | 11 | 6 | 3 | 3 | 10 | 6 | 7 | 10 | 7 | 5 | 5 | 5 | 9 | 5 | 5 | 5 | 3 | 1 | 2 | 5 | 2 | 1 | 3 | 6 | 1 | 4 | 5 | 2 | 3 | 6 | 5 | 4 | 5 | 2 | 10 | 4 | 5 | 3 | 5 | 8 | 1 | 5 | 5 | 10 | 0 | 2 | 7 | 0
Spreadsheet: 119171d1314235145-tipout-sheet-issues-ef789531-tip-out-teachable-
Sheet: Sheet1

 | Event | [NAME] Wedding
 | Date | 2011-05-29 00:00:00 | Tips | 1000
 | Role | Number of  People in Role | Total Hours | Percent  by Role
 | Kahuna |  |  | 0.1
 | Server |  |  | 0.3
 | Busser |  |  | 0.15
 | Bartender |  |  | 0.25
 | [NAME] |  |  | 0.1
 | Host |  |  | 0.1
 | Total
 | Role | Name | Hours Worked | Tip Out
 | Kahuna | [NAME] | 05:00:00
 | Server | Barb | 03:45:00
 | Server | Cain | 04:30:00
 | Server | [NAME] | 02:30:00
 | Server | [NAME] | 04:15:00
 | Busser | Fran | 05:00:00
 | Busser | [NAME] | 03:45:00
 | Bartender | Hana | 03:00:00
 | Bartender | [NAME] | 04:00:00
 | Bartender | [NAME] | 04:30:00
 | Bartender | Kent | 03:15:00
 | [NAME] | Leah | 03:15:00
 | [NAME] | Mark | 03:00:00
 | Host | Nina | 03:30:00
 | Host | Otto | 03:15:00
 |  |  | Total
Spreadsheet: kate_symes__18199__EESSales_dailyfeb
Sheet: 2-25

NP15 | 2001-02-25 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 0 | Fixed Off Peak | 167.44 |  |  |  | Fixed Peak | 0 |  | Fixed Off Peak | 146.09 |  |  | Fixed Peak | 0 |  | Fixed Off Peak | 146.09
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -8.92 | -8.92 |  |  | 1 | -57.86 | 0 | -54 | -80.86 |  |  | 1 | -1.98 | 0 | 0 | -1.98
2 | 0 | 0 | -7.97 | -7.97 |  |  | 2 | -58.86 | 0 | -54 | -74.86 |  |  | 2 | -1.94 | 0 | 0 | -1.94
3 | 0 | 0 | -7.49 | -7.49 | 0 |  | 3 | -58.76 | 0 | -44 | -71.76 |  |  | 3 | -1.91 | 0 | 0 | -1.91
4 | 0 | 0 | -7.33 | -7.33 |  |  | 4 | -59.44 | 0 | -44 | -71.44 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | 0 | 0 | -7.31 | -7.31 |  |  | 5 | -59.08 | 0 | -44 | -74.08 |  |  | 5 | -1.91 | 0 | 0 | -1.91
6 | 0 | 0 | -7.8 | -7.8 |  |  | 6 | -59.22000000000006 | 0 | -54 | -82.22 |  |  | 6 | -1.93 | 0 | 0 | -1.93
7 | 0 | 0 | -9.01 | -9.01 |  |  | 7 | -57.81 | 0 | -54 | -89.81 |  |  | 7 | -1.98 | 0 | 0 | -1.98
8 | 0 | 0 | -11.15 | -11.15 |  |  | 8 | -55.53999999999993 | 0 | -54 | -94.54 |  |  | 8 | -2.07 | 0 | 0 | -2.07
9 | 0 | 0 | -13.19 | -13.19 |  |  | 9 | -52.73 | 0 | -54 | -103.73 |  |  | 9 | -2.15 | 0 | 0 | -2.15
10 | 0 | 0 | -14.07 | -14.07 |  |  | 10 | -52.13 | 0 | -54 | -111.13 |  |  | 10 | -2.19 | 0 | 0 | -2.19
11 | 0 | 0 | -14.27 | -14.27 |  |  | 11 | -51.64 | 0 | -54 | -118.64 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | 0 | 0 | -14.25 | -14.25 |  |  | 12 | -52.52 | 0 | -54 | -121.52 |  |  | 12 | -2.21 | 0 | 0 | -2.21
13 | 0 | 0 | -14.27 | -14.27 |  |  | 13 | -51.54 | 0 | -54 | -122.54 |  |  | 13 | -2.21 | 0 | 0 | -2.21
14 | 0 | 0 | -13.9 | -13.9 |  |  | 14 | -51.98 | 0 | -54 | -122.98 |  |  | 14 | -2.19 | 0 | 0 | -2.19
15 | 0 | 0 | -13.27 | -13.27 |  |  | 15 | -52.7 | 0 | -54 | -121.7 |  |  | 15 | -2.16 | 0 | 0 | -2.16
16 | 0 | 0 | -13.33 | -13.33 |  |  | 16 | -52.89 | 0 | -54 | -121.89 |  |  | 16 | -2.17 | 0 | 0 | -2.17
17 | 0 | 0 | -13.77 | -13.77 |  |  | 17 | -52.73 | 0 | -54 | -123.73 |  |  | 17 | -2.18 | 0 | 0 | -2.18
18 | 0 | 0 | -15.01 | -15.01 |  |  | 18 | -51.34 | 0 | -54 | -130.34 |  |  | 18 | -2.23 | 0 | 0 | -2.23
19 | 0 | 0 | -17.57 | -17.57 |  |  | 19 | -48.36 | 0 | -54 | -132.36 |  |  | 19 | -2.34 | 0 | 0 | -2.34
20 | 0 | 0 | -17.35 | -17.35 |  |  | 20 | -48.72 | 0 | -54 | -127.72 |  |  | 20 | -2.33 | 0 | 0 | -2.33
21 | 0 | 0 | -16.23 | -16.23 |  |  | 21 | -50.22 | 0 | -54 | -121.22 |  |  | 21 | -2.29 | 0 | 0 | -2.29
22 | 0 | 0 | -14.58 | -14.58 |  |  | 22 | -51.7 | 0 | -54 | -113.7 |  |  | 22 | -2.22 | 0 | 0 | -2.22
23 | 0 | 0 | -12.39 | -12.39 |  |  | 23 | -52.56 | 0 | -54 | -103.56 |  |  | 23 | -2.13 | 0 | 0 | -2.13
24 | 0 | 0 | -10.1 | -10.1 |  |  | 24 | -57.07 | 0 | -54 | -90.07 |  |  | 24 | -2.02 | 0 | 0 | -2.02
Spreadsheet: a00e0d09-ad10-4a37-90b0-4267ef9a7a19
Sheet: Sheet1

3.2.8.6 - Evolución de las altas de empresas por estrato de asalariados. 1990-2010 | 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 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Sin asalariados |  |  |  |  |  |  |  |  | 219277 | 244301 | 245932 | 232577 | 242191 | 255835 | 267893 | 303379 | 311633 | 302769 | 249864 | 241374 | 254618
De 1 a 5 asalariados |  |  |  |  |  |  |  |  | 103367 | 84044 | 82870 | 79642 | 85689 | 93768 | 90415 | 96247 | 98470 | 93051 | 74002 | 70752 | 68157
De 6 a 9 asalariados |  |  |  |  |  |  |  |  | 8330 | 7941 | 8516 | 7998 | 8422 | 9204 | 8662 | 8932 | 9001 | 8540 | 5884 | 5244 | 5154
De 10 a 19 asalariados |  |  |  |  |  |  |  |  | 5208 | 5003 | 4827 | 4429 | 4600 | 5161 | 4773 | 4477 | 4828 | 4569 | 2940 | 2514 | 2243
De  20 o más asalariados |  |  |  |  |  |  |  |  | 2980 | 3143 | 2661 | 2422 | 2319 | 2375 | 2351 | 2240 | 2389 | 2046 | 1382 | 1296 | 1092
Total |  |  |  |  |  |  |  |  | 339162 | 344432 | 344806 | 327068 | 343221 | 366343 | 374094 | 415275 | 426321 | 410975 | 334072 | 321180 | 331264
Fuente: Elaboración [NAME] a partir de datos INE, Directorio Central de Empresas, varios años.