tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142866d1330046309-how-sum-a-number-based-on-text-before-the-number-copy-of-leave
Sheet: Annual Leave 2012 Calculations

 | Before shows no formulas as I can't work out what to put.
 | After shows what it would look like from the data in January - March tab if there were formulas in C23/C24 and C25
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Before | person1 | person2 | person3 | person4 | person5 | person6 | person7 | person8 | person9
 | Overtime (Hours)
 | Overtime Acquired | 8 | 7 | 12 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Taken | 3 | 15 | 10 | 3 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Left | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | After | person1 | person2 | person3 | person4 | person5 | person6 | person7 | person8 | person9
 | Overtime (Hours)
 | Overtime Acquired | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Taken | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Left | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Note:  As you can see from above.  Overtime Acquired is in hours, so from the above example this person has worked 8 hours overtime. Which, if you look in the January - March tab,
 | that's what it totals to as I want it to add up q 5 and q 3 which equals 8 (hours) and is associated with 'overtime acquired.
 | They have also taken 3 hours overtime t 2 and t 1 from the January - March tab.   Therefore, this field 'Overtime Taken' should automatically say 3, like in the above example
 | Therefore, if these fields above are automatically calculating these two fields based on either q (number) and t (number) the 'Overtime Left' for this example should say 5
Spreadsheet: 201865d1356170513-calculated-field-problem-with-subtracting-start-end-total-trail
Sheet: Sheet1

office | client | cohort | start | end
glasgow | client 1 | WP JSA Early Access | 2012-01-31 00:00:00
glasgow | client 2 | WP JSA 25+ | 2011-12-16 00:00:00 | 2012-05-11 00:00:00
glasgow | client 3 | WP JSA 25+ | 2012-05-22 00:00:00
glasgow | client 4 | WP [NAME] 18-24 | 2012-06-28 00:00:00
Spreadsheet: 4584ee73-80da-4500-b764-06ba6186376d
Sheet: utah_100kb_5p

class | [NAME] | ncnv | a_rate | o_rate | ,c_rate | p_oa | sema_rate | semo_rate | semc_rate | a_totkb | o_totkb | c_totkb | p_totkb | sema_totkb | semo_totkb | semc_totkb
all | 100000 | 295 | 2.54286 | 1.73469 | 1.95161 | 0.08732 | 0.29088 | 0.20779 | 0.29844 | 783.99226 | 473.34739 | 738.43071 | 0.18693 | 126.13257 | 65.30957 | 173.99955
dels | 100000 | 123 | 1.2 | 0.97959 | 0.53226 | 0.00305 | 0.23479 | 0.16875 | 0.08517 | 343.98243 | 243.92102 | 116.21789 | 0.0031 | 95.50719 | 44.00518 | 23.31486
dups | 100000 | 172 | 1.34286 | 0.7551 | 1.41935 | 0.83762 | 0.19637 | 0.12209 | 0.28956 | 440.00983 | 229.42637 | 622.21282 | 0.86315 | 95.64912 | 50.16571 | 172.45826
x-all | 100000 | 24 | 0.286 | 0.184 | 0.081 | 0.117 | 0.133 | 0.063 | 0.035 | 83.968 | 35.223 | 19.428 | 0.126 | 42.376 | 13.184 | 9.326
x-dels | 100000 | 20 | 0.2 | 0.163 | 0.081 | 0.421 | 0.128 | 0.061 | 0.035 | 61.942 | 32.363 | 19.428 | 0.443 | 40.844 | 13.019 | 9.326
x-dups | 100000 | 4 | 0.086 | 0.02 | 0 | 0.084 | 0.048 | 0.02 | 0 | 22.026 | 2.86 | 0 | 0.084 | 14.413 | 2.86 | 0
y-all | 100000 | 9 | 0.114 | 0.061 | 0.032 | 0.208 | 0.055 | 0.035 | 0.023 | 107.026 | 14.774 | 11.314 | 0.205 | 77.44 | 10.383 | 8.419
y-dels | 100000 | 8 | 0.114 | 0.061 | 0.016 | 0.08 | 0.055 | 0.035 | 0.016 | 107.026 | 14.774 | 7.632 | 0.079 | 77.44 | 10.383 | 7.632
y-dups | 100000 | 1 | 0 | 0 | 0.016 | 0.25 | 0 | 0 | 0.016 | 0 | 0 | 3.682 | 0.25 | 0 | 0 | 3.682
auto-all | 100000 | 262 | 2.143 | 1.49 | 1.839 | 0.237 | 0.256 | 0.194 | 0.302 | 592.998 | 423.35 | 707.688 | 0.42 | 101.947 | 64.434 | 174.709
auto-dels | 100000 | 95 | 0.886 | 0.755 | 0.435 | 0.016 | 0.168 | 0.141 | 0.078 | 175.014 | 196.784 | 89.157 | 0.012 | 40.059 | 41.605 | 19.259
auto-dups | 100000 | 167 | 1.257 | 0.735 | 1.403 | 0.998 | 0.202 | 0.119 | 0.289 | 417.984 | 226.566 | 618.531 | 0.735 | 96.013 | 50.212 | 172.568
Spreadsheet: 768873d1645183485-excel-formula-to-translate-foreign-currency-foreign-exchange
Sheet: Sheet2

I am kindly ask for excel formula which can translate US$ revenue Column J6:J19 to ZWL column H6: H19, If column H is blank as shown in the desired solution. Use the data on Foreign Exchange Rates sheet.
 |  |  |  |  |  |  |  |  |  |  | DESIRED SOLUTION
 |  |  |  | Date | Name | Receipt | Revenue - ZWL | Expenses | Revenue - US$ |  | Date | Name | Receipt | Revenue - ZWL | Expenses | Revenue - US$
 |  |  |  | 2021-01-01 00:00:00 | A | 200 | 10260 |  |  |  | 2021-01-01 00:00:00 | A | 200 | 10260
 |  |  |  | 2021-01-25 00:00:00 | B | 201 |  |  | 275 |  | 2021-01-25 00:00:00 | B | 201 | 22735.79 |  | 275
 |  |  |  | 2021-01-28 00:00:00 | A | 202 |  |  | 234 |  | 2021-01-28 00:00:00 | A | 202 | 19346.0904 |  | 234
 |  |  |  | 2021-03-10 00:00:00 | B | 203 |  |  | 200 |  | 2021-03-10 00:00:00 | B | 203 | 16880.02 |  | 200
 |  |  |  | 2021-04-15 00:00:00 | A | 204 | 128000 |  |  |  | 2021-04-15 00:00:00 | A | 204 | 128000
 |  |  |  | 2021-04-20 00:00:00 | B | 205 | 30800 |  |  |  | 2021-04-20 00:00:00 | B | 205 | 30800
 |  |  |  | 2021-04-26 00:00:00 | A | 206 |  |  | 50 |  | 2021-04-26 00:00:00 | A | 206 | 4225.160000000001 |  | 50
 |  |  |  | 2021-04-26 00:00:00 | B | 207 |  |  | 100 |  | 2021-04-26 00:00:00 | B | 207 | 8450.320000000002 |  | 100
 |  |  |  | 2021-04-28 00:00:00 | A | 208 |  |  | 180 |  | 2021-04-28 00:00:00 | A | 208 | 15210.576 |  | 180
 |  |  |  | 2021-07-03 00:00:00 | B | 209 |  |  | 500 |  | 2021-07-03 00:00:00 | B | 209 | 42820.1 |  | 500
 |  |  |  | 2021-07-10 00:00:00 | A | 210 |  |  | 120 |  | 2021-07-10 00:00:00 | A | 210 | 10276.824 |  | 120
 |  |  |  | 2021-12-15 00:00:00 | B | 211 | 700000 |  |  |  | 2021-12-15 00:00:00 | B | 211 | 700000
 |  |  |  | 2022-12-20 00:00:00 | A | 212 | 35000 |  |  |  | 2022-12-20 00:00:00 | A | 212 | 35000
 |  |  |  | 25/12/201 | B | 213 |  |  | 300 |  | 25/12/201 | B | 213 | 32599.8 |  | 300
Spreadsheet: 720959d1614393994-method-to-estimate-missing-data-items-data-fill-example-2
Sheet: Sheet2

Date | Value |  |  | Desired change | Desired estimates
2019-02-12 00:00:00 |  |  |  |  |  |  | Change is applied to the first non-blank, which is 4994 in the data
 | 4994
 |  |  |  |  |  |  | Change is determined as the average daily change from February 14 to February 19
 | 6169
 | 3600
 | 4200
 | 4800
 | 5280
 | 6995
 | 5040
 | 4813
 | 5040
 | 4560
 | 4800
 | 5280
 | 5520
 | 5640
 |  |  |  |  |  |  | Change is determined as the one-day change from March 28 to March 29
Spreadsheet: 3965cbd8-7b1a-41c3-b97b-cdec6415f25c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42735035 | 2014-08-15 16:34:30 | ALLIES | 1 | 6 | 4 | 701256 | player701256 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42735212 | 2014-08-15 16:46:30 | AXIS | 1 | 6 | 2 | 701256 | player701256 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42738951 | 2014-08-15 22:27:52 | ALLIES | 0 | 6 | 10 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42739277 | 2014-08-15 23:01:38 | AXIS | 1 | 10 | 7 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42849700 | 2014-08-23 20:48:04 | AXIS | 0 | 3 | 4 | 1624680 | [NAME] | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42878438 | 2014-08-25 19:45:08 | ALLIES | 0 | 1 | 6 | 681429 | Caverne | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
Spreadsheet: 1b9c48f1-aa8c-4b03-892c-3000bd575438
Sheet: Survey

False
 |  | 2011-12 Legal Max CTE Hours: |  |  |  | Total Survey CTE Hours: |  |  |  | Difference:
 | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11 | Col 12 | Col 13 | Col 14
 | Daily | 9/20/2011 FTE | Total Salaries | Equipment |  |  | Student |  | CTE Student |  |  |  |  | Amount
Name and phone number of the person completing this report | Contact | Enrollment (Hrs) | and [NAME] | (hardware inc | Supplies | Training/Prof | Certification/ |  | Organizations |  | SUBTOTAL | Utilities | TOTAL | Per Pupil
Cluster/Pathway | Minutes | (Col. 1 ÷ 6 hrs.) | Benefits* | technology) | (Consumables) | Development | Assessments** | Transportation*** | (District Funds) | Other | (Col. 3 thru 10) | (5% of Col. 11) | (Col. 11 - 12) | (Col. 13 ÷ Col. 2)
Agriculture, Food & Natural Resources
Agriculture Science
Plant Systems
Power, Structural & Technical Systems
Architecture & Construction
Construction
Design & Pre-Construction
Arts, A/V Technology & Communications
AV Communications
Visual Arts
Business, Management & Administration
Business Entreprenuership & Management
Education & Training
Teaching/Training
Finance
Business Finance
Government & Public Administration
Government & Public Administration
Health Science
Health Science
Hospitality & Tourism
Restaurant & Event Management
Travel & Tourism
Human Services
Consumer Services
Early Childhood Development & Services
Family & Community Services
Information Technology
Information Support & Services
Network Systems
Programming & Software Development
Web & Digital Communications
Law, Public Safety, Corrections & Security
Corrections, Security & Law Enforcement Services
Emergency & Fire Management Services
Manufacturing
Maintenance
Production
Marketing
Marketing
Science, Technology, Engineering & Mathematics (STEM)
BioChemistry/Green/Hazmat
BioMedical
Cartography/Geospatial/Spatial Math
Engineering & Applied Mathematics
Transportation, Distribution & Logistics
Mobile Equipment Maintenance
*Include substitute teachers
**Industry recognized credentials (not state assessments) -- Use 2012-13 estimates
***Cost of transportation to and from approved program -- Use 2012-13 estimates
Spreadsheet: 802220d1666707449-calculate-numbers-backwards-from-total-sum-value-positions
Sheet: Sheet1

Position | Quantity | Price | Total Sum |  |  | Final Price |  |  |  | < Price | > Price | <P : Total Sum | >P:  Total Sum
Position 1 | 13 | 3.02 |  |  |  | ?
Position 2 | 22 | 3.039 |  |  |  | ?
Position 3 | 14 | 3.02 |  |  |  | ?
Position 4 | 23 | 3.039 |  |  |  | ?
Position 5 | 10 | 3.02 |  |  |  | ?
Position 6 | 18 | 3.039 |  |  |  | ?
Position 7 | 6 | 3.02 |  |  |  | ?
Position 8 | 5 | 3.039 |  |  |  | ?
Position 9 | 5 | 3.02 |  |  |  | ?
Position 10 | 19 | 3.039 |  |  |  | ?
Position 11 | 16 | 3.02 |  |  |  | ?
Position 12 | 8 | 3.039 |  |  |  | ?
Position 13 | 20 | 3.02 |  |  |  | ?
Position 14 | 20 | 3.039 |  |  |  | ?
Position 15 | 10 | 3.02 |  |  |  | ?
Position 16 | 25 | 3.039 |  |  |  | ?
Position 17 | 37 | 3.63 |  |  |  | ?
Position 18 | 37 | 3.63 |  |  |  | ?
Position 19 | 4095 | 0.133 |  |  |  | ?
Position 20 | 3969 | 0.133 |  |  |  | ?
Position 21 | 3807 | 0.133 |  |  |  | ?
Position 22 | 4636 | 0.133 |  |  |  | ?
Position 23 | 4413 | 0.083 |  |  |  | ?
Position 24 | 4367 | 0.083 |  |  |  | ?
Position 25 | 3825 | 0.083 |  |  |  | ?
Position 26 | 4162 | 0.083 |  |  |  | ?
Position 27 | 3528 | 0.163 |  |  |  | ?
Position 28 | 4438 | 0.163 |  |  |  | ?
Position 29 | 4169 | 0.351 |  |  |  | ?
Position 30 | 4842 | 0.351 |  |  |  | ?
Position 31 | 3943 | 0.351 |  |  |  | ?
Position 32 | 4925 | 0.351 |  |  |  | ?
Position 33 | 4816 | 0.429 |  |  |  | ?
Position 34 | 3941 | 0.429 |  |  |  | ?
Position 35 | 4485 | 0.534 |  |  |  | ?
Position 36 | 4718 | 0.534 |  |  |  | ?
Position 37 | 4256 | 0.534 |  |  |  | ?
Position 38 | 4527 | 0.656 |  |  |  | ?
Position 39 | 4393 | 0.656 |  |  |  | ?
Position 40 | 3738 | 0.229 |  |  |  | ?
Position 41 | 3504 | 0.229 |  |  |  | ? |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  |  | 30642.19
 |  |  | Initial Grand total sum |  |  | Final Grand total sum
Spreadsheet: 5c428341-de01-47d1-b097-07bfdc311411
Sheet: Sheet1

California Sales
 | Oakland | San Diego | Fresno | In-Store Sales Total | Online Sales Total | Total Sales
Week 1 | 3488 | 3205 | 2248 |  | 13822
Week 2 | 4215 | 3562 | 2394 |  | 15699
Week 3 | 4188 | 3479 | 2280 |  | 14663
Week 4 | 3670 | 3322 | 2594 |  | 13741
Recorded on:
2014-02-28 00:00:00
Reviewed on:
Spreadsheet: 726203d1617108726-bring-all-cells-data-to-consecutive-cells-sample-output
Sheet: Sheet1

OE1 | OE2 | OE3 | OE4 | OE5 | OE6 | OE7 | OE8 | OE9 | OE10 | OE11 | OE12 | OE13 | OE14 | OE15 | OE16 | OE17 | OE18 | Output Required
 |  |  |  |  | 98 |  |  |  |  | 5
 |  |  | 9 |  |  |  |  | 1 |  |  |  |  |  |  | 11
Spreadsheet: sara_shackleton__36500__EnMax Corp
Sheet: Sheet1

INDUSTRIAL MASTER SWAP WORKSHEET
 |  | ATTORNEY:
DATE: | 2000-07-19 00:00:00 | DEAL MAKER: | Derek Davies
COUNTERPARTY: | Enmax Energy Corporation | CONTACT: | [NAME]
ADDRESS: | 2808 Spiller Road S.E. | TITLE:
 | Calgary, [NAME] 4H3 | PHONE: | [PHONE]
 |  | FAX: | [PHONE]
Incorporation State | Calgary, Alberta | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) | Enmax Corporation **(A low) | Enron Corp.
LIMIT $ MILLIONS | $10MM | 10000000
Incorporation State | Alberta
COLLATERAL  THRESHOLD
 | 10000000 | 10000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000
Delivery Amount
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | Yes | Yes
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X
-Below = S&P/Moody's | **BBB | BBB-
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | $10MM | $100MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
**EnMax Corp has received a credit rating from DBRS (Dominion Bond Rating Service) although this information
has not been released yet.  This information should be received by the end of the week.  I want to wait until this
information has been received before the ISDA draft is sent out to ensure the credit rating of A (low) has been assigned.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7095
Spreadsheet: 438020d1451682030-putting-data-in-another-worksheet-filter-dates
Sheet: Sheet2

Day | Date
Spreadsheet: 105c7fe2-bcb9-4ec4-80c3-72827cf347c8
Sheet: Sheet1

Usability Testing Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
April
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
09:00:00
10:00:00 |  | Amber [NAME]  (LM) |  |  | [NAME] (MC) |  |  |  | [NAME](AA)
11:00:00 |  | [NAME] 11:30-12:30 (TH) |  |  |  |  |  |  |  | [NAME] 11:30-12:30 (GZ/AM)
12:00:00
01:00:00 |  | [NAME] (LM) |  |  |  |  |  |  |  | [NAME] (TH)
02:00:00 |  |  |  | Brett Few 2:30-3:30 (BT)
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
Pre-Test   [NAME] Friday, 4/10 1:00-2:00
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 01 Feb 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-02-01 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver |  |  | EFS | Annual
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 223320d1364162606-file-size-swells-after-macro-function-fileforsubtotals
Sheet: Diario

$B$23 | [NAME]: [NAME][NAME]: CuadroBotones / CopiaCeldas / CompletaAsnto |  |  | 6797.549999999999 | 6797.549999999999
Fecha | Asnto | Cuenta | [NAME] | Debe | [NAME] | Observaciones
2013-02-01 00:00:00 | 37 | 57201 Banco-1 | [NAME] | 778.32
2013-02-01 00:00:00 | 37 | 70500 Sueldos Percibidos | [NAME] |  | 778.32
2013-02-01 00:00:00 | 38 | 57201 Banco-1 | [NAME] | 722.13
2013-02-01 00:00:00 | 38 | 70500 Sueldos Percibidos | [NAME] |  | 722.13
2013-02-01 00:00:00 | 39 | 57201 Banco-1 | [NAME] | 722.13
2013-02-01 00:00:00 | 39 | 70500 Sueldos Percibidos | [NAME] |  | 722.13
2013-02-01 00:00:00 | 40 | 57201 Banco-1 | Estipendios del Obispado mes de Enero | 300
2013-02-01 00:00:00 | 40 | 70505 Estipendios y [NAME] | Estipendios del Obispado mes de Enero |  | 300
2013-02-01 00:00:00 | 41 | 11800 Aportación a Prvcia | Aportación a la Provincia | 4000
2013-02-01 00:00:00 | 41 | 57201 Banco-1 | Aportación a la Provincia |  | 4000
2013-02-05 00:00:00 | 42 | [NAME] | [NAME] | 103.57
2013-02-05 00:00:00 | 42 | 57201 Banco-1 | [NAME] |  | 103.57
2013-02-09 00:00:00 | 43 | [NAME] | [NAME] | 4.9
2013-02-09 00:00:00 | 43 | 57201 Banco-1 | [NAME] |  | 4.9
2013-02-11 00:00:00 | 44 | 57000 Caja | De banco a Caja Michaël | 150
2013-02-11 00:00:00 | 44 | 57201 Banco-1 | De banco a Caja Michaël |  | 150
2013-02-11 00:00:00 | 45 | [NAME], [NAME]. | Medicinas Michaël | 16.5
2013-02-11 00:00:00 | 45 | 57201 Banco-1 | Medicinas Michaël |  | 16.5
Spreadsheet: 774567d1648547527-highlight-time-in-a-weekly-booking-schedule-booking-schedule-copy
Sheet: Sheet1

WEEK | 13
TODAY | 2022-03-29 00:00:00 | Monday | 2022-03-28 00:00:00 | Tuesday | 2022-03-29 00:00:00 |  | Wednesday | 2022-03-30 00:00:00 | Thursday | 2022-03-31 00:00:00 |  | Friday | 2022-04-01 00:00:00 | Saturday | 2022-04-02 00:00:00 |  | Sunday | 2022-04-03 00:00:00
Time/Date |  | Left | Right | Left | Right | Time/Date | Left | Right | Left | Right | Time/Date | Left | Right | Left | Right | Time/Date | Left | Right
07:00:00 |  |  |  |  |  | 07:00:00 |  |  |  |  | 07:00:00 |  |  |  |  | 07:00:00
07:30:00 |  |  |  |  |  | 07:30:00 |  |  |  |  | 07:30:00 |  |  |  |  | 07:30:00
08:00:00 |  |  |  |  |  | 08:00:00 |  |  |  |  | 08:00:00 |  |  |  |  | 08:00:00
08:30:00 |  |  |  |  |  | 08:30:00 |  |  |  |  | 08:30:00 |  |  |  |  | 08:30:00
09:00:00 |  |  |  |  |  | 09:00:00 |  |  |  |  | 09:00:00 |  |  |  |  | 09:00:00
09:30:00 |  |  |  |  |  | 09:30:00 |  |  |  |  | 09:30:00 |  |  |  |  | 09:30:00
10:00:00 |  |  |  |  |  | 10:00:00 |  |  |  |  | 10:00:00 |  |  |  |  | 10:00:00
10:30:00 |  |  |  |  |  | 10:30:00 |  |  |  |  | 10:30:00 |  |  |  |  | 10:30:00
11:00:00 |  |  |  |  |  | 11:00:00 |  |  |  |  | 11:00:00 |  |  |  |  | 11:00:00
11:30:00 |  |  |  |  |  | 11:30:00 |  |  |  |  | 11:30:00 |  |  |  |  | 11:30:00
12:00:00 |  |  |  |  |  | 12:00:00 |  |  |  |  | 12:00:00 |  |  |  |  | 12:00:00
12:30:00 |  |  |  |  |  | 12:30:00 |  |  |  |  | 12:30:00 |  |  |  |  | 12:30:00
13:00:00 |  |  |  |  |  | 13:00:00 |  |  |  |  | 13:00:00 |  |  |  |  | 13:00:00
13:30:00 |  |  |  |  |  | 13:30:00 |  |  |  |  | 13:30:00 |  |  |  |  | 13:30:00
14:00:00 |  |  |  |  |  | 14:00:00 |  |  |  |  | 14:00:00 |  |  |  |  | 14:00:00
14:30:00 |  |  |  |  |  | 14:30:00 |  |  |  |  | 14:30:00 |  |  |  |  | 14:30:00
15:00:00 |  |  |  |  |  | 15:00:00 |  |  |  |  | 15:00:00 |  |  |  |  | 15:00:00
15:30:00 |  |  |  |  |  | 15:30:00 |  |  |  |  | 15:30:00 |  |  |  |  | 15:30:00
16:00:00 |  |  |  |  |  | 16:00:00 |  |  |  |  | 16:00:00 |  |  |  |  | 16:00:00
16:30:00 |  |  |  |  |  | 16:30:00 |  |  |  |  | 16:30:00 |  |  |  |  | 16:30:00
17:00:00 |  |  |  |  |  | 17:00:00 |  |  |  |  | 17:00:00 |  |  |  |  | 17:00:00
17:30:00 |  |  |  |  |  | 17:30:00 |  |  |  |  | 17:30:00 |  |  |  |  | 17:30:00
18:00:00 |  |  |  |  |  | 18:00:00 |  |  |  |  | 18:00:00 |  |  |  |  | 18:00:00
18:30:00 |  |  |  |  |  | 18:30:00 |  |  |  |  | 18:30:00 |  |  |  |  | 18:30:00
19:00:00 |  |  |  |  |  | 19:00:00 |  |  |  |  | 19:00:00 |  |  |  |  | 19:00:00
Spreadsheet: 774448d1648480594-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-how-to-count2_no-formulas-mariaoskars-
Sheet: Pivot Table

Nr | name | cost | nr1 | work | Sum of sum
3 | Name3 | M2125 |  | Vogaskóli | 393613.1319838057
4 | Name4 | D156 |  | Steinahlíð | 407770.1119838057
6 | Name6 | D126 |  | Heiðarborg | 434250.3819838057
8 | Name8 | M2140 |  | Breiðholtsskóli | 393613.1319838057
9 | Name9 | M2140 |  | Breiðholtsskóli | 393613.1319838057
14 | Name14 | D108 |  | [NAME] | 513691.1919838056
21 | Name21 | M2301 |  | [NAME] | 423158.1319838057
36 | Name36 | M2105 |  | Austurbæjarskóli | 262777.9923886639
37 | Name37 | M2105 |  | Austurbæjarskóli | 262777.9923886639
38 | Name38 | M2105 |  | Austurbæjarskóli | 262777.9923886639
44 | Name44 | D119 |  | Grandaborg | 434250.3819838057
48 | Name48 | M2162 |  | Engjaskóli | 404805.1319838057
49 | Name49 | D154 |  | [NAME] | 473970.2719838057
50 | Name50 | M2162 |  | Engjaskóli | 404805.1319838057
54 | Name54 | D114 |  | Fífuborg | 513691.1919838056
56 | Name56 | M2103 |  | Melaskóli | 375397.1319838057
57 | Name57 | M2104 |  | Hagaskóli | 375397.1319838057
58 | Name58 | M2122 |  | Breiðagerðisskóli | 393613.1319838057
59 | Name59 | M2122 |  | Breiðagerðisskóli | 393613.1319838057
63 | Name63 | D1104 |  | Sunnuás | 434250.3819838057
68 | [NAME] | M2125 |  | Vogaskóli | 393613.1319838057
70 | Name70 | M2125 |  | Vogaskóli | 393613.1319838057
72 | Name72 | M2125 |  | Vogaskóli | 393613.1319838057
74 | Name74 | M2120 | M656 | Birta | 393613.1319838057
75 | Name75 | M2120 | M656 | Birta | 393613.1319838057
76 | Name76 | M2120 | M656 | Birta | 393613.1319838057
77 | Name77 | M2120 | M656 | Birta | 393613.1319838057
79 | Name79 | M2120 | M656 | Birta | 393613.1319838057
81 | Name81 | M2120 | M656 | Birta | 393613.1319838057
82 | Name82 | M2120 | M656 | Birta | 393613.1319838057
87 | Name87 | M2120 | M656 | Birta | 393613.1319838057
88 | [NAME] | M2125 |  | Vogaskóli | 393613.1319838057
89 | Name89 | M2125 |  | Vogaskóli | 393613.1319838057
90 | Name90 | M2125 |  | Vogaskóli | 1144125.131983806
93 | [NAME] | D147 |  | Nóaborg | 252784.1450580297
95 | Name95 | M2120 | M656 | Birta | 393613.1319838057
97 | Name97 | M2120 | M656 | Birta | 393613.1319838057
99 | Name99 | D117 |  | Funaborg | 202650.1782591093
100 | Name100 | D117 |  | Funaborg | 239722.5562591093
106 | Name106 | M2120 | M656 | Birta | 393613.1319838057
107 | [NAME] | M2120 | M656 | Birta | 393613.1319838057
108 | Name108 | M2120 | M656 | Birta | 393613.1319838057
109 | Name109 | D126 |  | Heiðarborg | 217125.1909919028
110 | Name110 | M2120 | M656 | Birta | 196806.5659919028
111 | Name111 | D126 |  | Heiðarborg | 236985.1359919028
112 | [NAME] | M2120 | M656 | Birta | 196806.5659919028
113 | Name113 | D164 |  | Ösp | 513691.1919838056
114 | Name114 | M2143 |  | Fellaskóli | 393613.1319838057
119 | Name119 | M2120 | M656 | Birta | 393613.1319838057
121 | Name121 | M2168 |  | Ingunnarskóli | 393613.1319838057
123 | Name123 | M2120 | M656 | Birta | 393613.1319838057
124 | [NAME] | M2120 | M656 | Birta | 354251.818785425
Grand Total |  |  |  |  | 20166273.59583131