tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138444d1327664716-excel-2007-referencing-a-hyperlink-copy-of-tlc-client-progress-3-
Sheet: Home

Course | Client | Student |  | Initial Contact | Details on database | Evaluation | Eval Report Received | Follow Up  with Parent | Course O/view  Made | Teacher  Confirmed | Teacher Availability  Updated | Sent out  T&Cs/Welcome Pack | Add lessons to database | Send [NAME]to JF |  | Follow Up  1st class | Follow ups? | 1st  Follow up | 2nd  Follow up | 3rd  Follow up | Initial  Band Score | 1st  Follow Up | 2nd  Follow up
Santiago
[NAME]
Spreadsheet: 759125d1639335780-distribution-of-values-up-to-10-quoziente
Sheet: Foglio1

 |  |  |  | 15 | 23 | 32 | 36 | 33 | 19 | 14
 |  |  |  | 10
 |  |  |  | 5 | 5
 |  |  |  |  | 10
 |  |  |  |  | 8 | 2
 |  |  |  |  | 0 | 10
 |  |  |  |  | 0 | 10
 |  |  |  |  | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 6 | 4
 |  |  |  |  | 0 | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 0 | 9 | 1
 |  |  |  |  | 0 | 0 | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 0 | 0 | 8 | 2
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 10
Spreadsheet: 864444d1711614321-merging-multiple-tables-based-on-unique-id-query-3-
Sheet: X7

Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6 |  |  | Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6
1 | AAA | 1 | 1 | 1 | 3 | 1 | 1 |  |  | 1 | AAA | 1 | 1 | 1 | 3 | 1 | 1
2 | BBB | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 2 | BBB | 2 | 2 | 2 | 2 | 2 | 2
3 | CCC | 1 | 1 | 3 | 1 | 1 | 1 |  |  | 3 | CCC | 1 | 1 | 3 | 1 | 1 | 1
4 | DDD | 3 | 0 | 4 | 1 | 3 | 2 |  |  | 4 | DDD | 3 | 0 | 4 | 1 | 3 | 2
5 | EEE | 1 | 2 | 3 | 2 | 0 | 1 |  |  | 5 | EEE | 1 | 2 | 3 | 2 | 0 | 1
6 | FFF | 0 | 1 | 2 | 1 | 1 | 3 |  |  | 6 | FFF | 0 | 1 | 2 | 1 | 1 | 3
7 | GGG | 2 | 3 | 1 | 3 | 2 | 2 |  |  | 7 | GGG | 2 | 3 | 1 | 3 | 2 | 2
8 | HHH | 1 | 1 | 4 | 2 | 4 | 1 |  |  | 8 | HHH | 1 | 1 | 4 | 2 | 4 | 1
9 | III | 0 | 4 | 1 | 1 | 2 | 1 |  |  | 9 | III | 0 | 4 | 1 | 1 | 2 | 1
10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2 |  |  | 10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2
11 | KKK | 2 | 1 | 2 | 4 | 0 | 1 |  |  | 11 | KKK | 2 | 1 | 2 | 4 | 0 | 1
12 | LLL | 1 | 0 | 0 | 2 | 1 | 0 |  |  | 12 | LLL | 1 | 0 | 0 | 2 | 1 | 0
Spreadsheet: 861955d1709771025-simplify-formula-if-find-a-string-in-row-for-a-specific-value-search-tbd-for-id
Sheet: Sheet1

ID | "TBD" Found ?
77855000
78835700
65239087
ID | Color 1 | Color 2 | Color 3 | Color 4 | Color 5
77855000 |  | TBD | Green |  | Black
78835700 |  | Red
65239087 |  |  | Yellow | TBD
Spreadsheet: 149836d1334158649-excel-2007-need-cell-value-to-determine-result-of-column-rows-to-another-sheet-excel-help-examples
Sheet: SCIP 2

[NAME] |  | 2011-04-10 00:00:00 | 2011-05-10 00:00:00 | 2011-06-10 00:00:00 | 2011-07-11 00:00:00 | 2011-08-11 00:00:00 | 2011-09-11 00:00:00 | 2011-10-11 00:00:00 | 2011-11-11 00:00:00 | 2011-12-11 00:00:00 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-03-12 00:00:00 | 12 mo Rolling
DOE,[NAME] | n
 | d
 | Compliance | 0 |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.25
JECKLE,[NAME] | n
 | d
 | Compliance
ONLY PROVIDERS WITH LESS THAN 99% compliance in Column O (compliance)
 |  |  |  |  |  |  | 100
Spreadsheet: andy_zipper__165__DYNEGY-ICE VOL Apr9
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-9-01 thru Apr-9-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-09-01 | 100043565 |  | Bought | NG Fin, FP for LD1 | [NAME] | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | 5.45 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], J
Apr-09-01 | 802918409 |  | Bought | NG Fin, FP for LD1 | [NAME] | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 5.45 | USD / MMBtu | 5000 | Daily | 155000 | MMBtus | [NAME], J
Apr-09-01 | 839793449 |  | Bought | NG Fin, FP for LD1 | [NAME] | 2001-06-01 00:00:00 | Jun-01-01 | Jun-30-01 |  |  |  | AEP Energy Services, Inc. | 5.5125 | USD / MMBtu | 10000 | Daily | 300000 | MMBtus | [NAME], J
Apr-09-01 | 119642294 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | Morgan Stanley Capital Group, Inc. | 4.92 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
Apr-09-01 | 182884085 |  | Sold | NG Fin, FP for LD1 | [NAME] | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 5.495 | USD / MMBtu | 7500 | Daily | 232500 | MMBtus | [NAME], J
Apr-09-01  Deals
Spreadsheet: bfa7f507-9d72-4c8e-a771-b283e5630e17
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259853 | 74014 | Amelie | Vantomme | FRA | 233 | 00:17:12 | 00:01:41 | 01:14:19 | 00:01:01 | 00:26:57 | 1 | 02:01:12
259853 | 42899 | Anja | Jednak | GER | 234 | 00:19:01 | 00:01:09 | 01:17:00 | 00:01:13 | 00:29:02 | 2 | 02:07:27
259853 | 77980 | Tamara | Rautner | AUT | 235 | 00:20:40 | 00:02:10 | 01:31:22 | 00:01:21 | 00:33:06 | 3 | 02:28:40
Spreadsheet: 119f8147-d9cb-4684-8a67-2d69d8fab861
Sheet: Table 1.4

Monthly Statistical Bulletin
1.4 Long-term unemployment
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Long-term unemployed (a) (b) – '000
July | 99.9879021 | 110.8710098 | 112.4246724 | 112.1582038 | 137.1544773
August | 98.266734 | 106.907139 | 126.1442045 | 120.1871781 | 134.1166445
September | 98.5699935 | 116.8795909 | 111.1933692 | 122.3722344 | 133.2631075
October | 100.3542228 | 127.9499989 | 114.6444131 | 118.0951275 | 145.9280875
November | 106.9622702 | 116.1084203 | 109.5658276 | 130.6516737 | 145.9937229
December | 112.9822171 | 110.5957592 | 108.5328326 | 119.0632232 | 153.6266153
January | 108.0866378 | 107.6996228 | 126.8063383 | 120.5754746 | 150.1751291
February | 109.3048016 | 112.213817 | 113.90369 | 116.4876902 | 154.4406496
March | 106.9920296 | 117.0136736 | 115.8882063 | 120.7412284 | 163.5138425
April | 114.1131356 | 112.9285209 | 120.9907046 | 117.9715712 | 161.8076879
May | 111.3591974 | 119.2206608 | 111.7632347 | 126.8064116 | 169.2410629
June | 112.0086476 | 111.8552046 | 112.5305122 | 132.9191391 | 172.3509536
Annual average | 106.7938189583333 | 113.919219425 | 115.2809436916667 | 121.5399985416667 | 151.904305125
Percentage of total unemployed (b) – per cent
July | 15.33749755093036 | 17.93200495376223 | 18.57043209821688 | 17.93546940429561 | 19.81415607594652
August | 14.97258685654218 | 18.27233396940624 | 20.31406354492975 | 19.64255004642938 | 19.07867868033361
September | 15.12764060866894 | 19.69942256952591 | 17.85257962198988 | 18.46692708260689 | 19.20536093386235
October | 15.59223060832825 | 20.74546830323843 | 18.77923351583781 | 18.2936336656547 | 20.79665850844613
November | 16.75319295465646 | 19.33213598100966 | 17.64044247707765 | 20.70717614728495 | 20.7086292945034
December | 17.8377905068719 | 19.3287312821201 | 17.68826245970403 | 18.28274209660064 | 21.52508231051336
January | 17.74053703921322 | 18.13846333619541 | 20.97406872441625 | 18.34564199751208 | 20.58277552184203
February | 17.86928495245331 | 19.13894849824982 | 18.39298607739385 | 17.76244529070379 | 20.81677950626989
March | 17.15784186470632 | 20.25232804054044 | 18.82156001613116 | 17.77711632121654 | 22.86293650115259
April | 17.99702295846751 | 19.36294617312533 | 20.28901552923457 | 17.29793561764874 | 22.5790783810331
May | 18.53795588032619 | 20.30868039183526 | 18.02587921091621 | 18.73710637621931 | 23.46236643983968
June | 18.75650984320977 | 19.23985630790987 | 18.21994479306405 | 19.211305190018 | 23.2388003653055
Annual average | 17.00185190069184 | 19.28599124195199 | 18.7800546886211 | 18.52233725134591 | 21.23161725815737
(a) Unemployed for 52 weeks or more.
(b) Monthly figures are seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6291.0.55.001 |  |  |  |  |  |  |  | 2014-08-14 00:00:00
Spreadsheet: 783711d1655104135-deconstructing-a-cell-cells-breakdown
Sheet: Sheet1

Current Form | Name Only | Acc | Eco | Law | Sci
[NAME] ACC ECO
[NAME] SCI
J. Brumble LAW
[NAME] ECO
M. Wood ECO LAW
P. Ham SCI ECO
Spreadsheet: cbc9c50c-1671-4185-83d6-d2a5aa23f1ca
Sheet: GENERAL INFOMRATION

Enclosure 1
Reporting period: |  |  |  | 1 Jan 2011 |  | to | 31 Mar 2011
Quarterly Financial Report-TFI-POD
Tax Number (MB): |  | 0820431
Registration Number ([NAME]): |  | 040035070
Personal Identification Number (OIB): |  | [PHONE]
Issuer: |  | OT-OPTIMA TELEKOM d.d.
Postal Code and Location: |  | 10010 |  |  | BUZIN
Street and number: |  | BANI 75A
e-mail address: |  | [EMAIL]
Internet address: |  | www.optima.hr
Code and name for municipality/city |  | 133
Code and name for county |  | 21 |  |  |  |  | Number of employees | 193
 |  |  |  |  |  |  | (at the year's end)
Consolidated Report |  | NO |  |  |  | Business activity code:
Entities in consolidation (according to IFRS) |  |  |  | Registered seat: |  |  | Tax number (MB):
Book-keeping firm
Contact person |  | [NAME]
 |  | (unosi se samo prezime i ime osobe za kontakt)
Telephone |  | 01/5492 027 |  |  |  | Telefaks: | 01/5492 019
e-mail address |  | [EMAIL]
Surname and name |  | MATIJA MARTIĆ, JADRANKA SURUČIĆ
 |  | (osoba ovlaštene za zastupanje)
 | Documents for publication
 | 1. [NAME] (balance sheet, profit and loss account, cash flow statement, change in capital statement
 | and notes
 | 2. Management report
 | 3. Statements for persons responsible for composing financial statements
 |  |  |  | M.P. |  | (signature of authorized person)
Spreadsheet: 473338d1470157784-add-text-to-end-of-text-already-in-entire-column-of-cells-excel-help
Sheet: Sheet1

dei 0 | 10409 |  | abc123 | xyz123
 | 10480 |  | def456
 | 10417 |  | ghi789
 | 90400
 | 10113
 | 10235
 | 10466
 | 10485
 | 10636
 | 10230
 | 10414
 | 10421
 | 10470
 | 10476
 | 10477
 | 10418
 | 10849
 | 10405
 | 50510
 | 10408
 | 10329
 | 50501
 | 10410
 | 10401
 | 10400
 | 10490
 | 10491
 | 10460
 | 10391
Spreadsheet: 696422d1600801640-rolling-netting-formula-book1
Sheet: Sheet1

Part | Location | Date Needed | Qty Needed | Available Inv | Net Inv | Alternate Inv |  |  |  | Available Inv | Net Inv | Alternate Inv
ND-00006-001 | 10TE02 | 2020-09-21 00:00:00 | 84 |  |  |  |  |  |  | 142 | 58 | 142
ND-00006-001 | 10TE02 | 2020-09-26 00:00:00 | 244 |  |  |  |  |  |  | 58 | -186 | 142
ND-00006-001 | 10TW01 | 2020-09-26 00:00:00 | 20 |  |  |  |  |  |  | 0 | -20 | 142
ND-00006-001 | 10TE02 | 2020-09-26 00:00:00 | 12 |  |  |  |  |  |  | -186 | -198 | 142
ND-00006-001 | 10TE02 | 2020-09-26 00:00:00 | 391 |  |  |  |  |  |  | -198 | -589 | 142
ND-00006-001 | 10TW01 | 2020-09-28 00:00:00 | 108 |  |  |  |  |  |  | -20 | -128 | 142
ND-00006-001 | 10TE02 | 2020-10-07 00:00:00 | 46 |  |  |  |  |  |  | -589 | -635 | 142
ND-00006-001 | 10TE02 | 2020-10-27 00:00:00 | 170 |  |  |  |  |  |  | -635 | -805 | 142
Spreadsheet: 879941d1727540761-need-assistance-with-formulas-using-the-and-function-kh-project_example
Sheet: Table1

SELECT  CATEGORY | SELECT  TYPE | Total
CLOTHING | Outer Wear | 45.71
DEPOSIT | Checking | 35
DINING | Fastfood | 42.36
ENTERTAINMENT | Cable TV | 15
EQUIPMENT | Mower | 45
FUEL | Jeep | 62.5
HEALTH | Tooth Paste | 3.95
INSURANCE |  | 1540
LOANS | Visa Credit Card | 26.75
MAINT_REPAIR | Automobile | 74.5
[NAME] | Home | 225
PLANTS | Proerty | 8.75
UTILITIES | Electric | 216.35
VEHICLE | Yrly Inspection | 75
GROCERIES | Giant Foods | 48.5
Spreadsheet: 755915d1637178365-ifna-replacement-replace-ifna
Sheet: Sheet1

 |  | randomized test data
Spreadsheet: 236324d1368750779-how-do-i-create-a-calendar-drop-down-in-excel-benefit-tracker-fy14-v2
Sheet: Opex Project Tracker

CAPEX INITIATIVE TRACKER - RENEWAL
 |  |  |  |  |  |  |  |  | Initiatiave 1 | Initiatiave 2 | Initiatiave 3 | Initiatiave 4 | Initiatiave 1 | Initiatiave 2 | Initiatiave 3 | Initiatiave 4 | Initiatiave 1 | Initiatiave 2 | Initiatiave 3 | Initiatiave 4 | Initiatiave 1 | Initiatiave 2 | Initiatiave 3 | Initiatiave 4
Store # | Store Name | Project Code | Scheme | State | SOS Date | SOS Month | FOS | FOS Month
554
506
4482
786
880
639
4387
4388
4178
4507
4438
512
901
749
905
927
890
853
7611
4655
4598
394
7819
695
860
784
439
686
886
821
343
7705
299
494
621
381
8757
7784
297
603
4487
839
7606
4404
519
4550
335
7587
4660
854
670
4422
646
5736
622
4472
788
772
7735
571
4432
782
4430
968
7623
7616
4960
418
395
447
8741
7935
817
7868
4978
383
362
4553
835
4513
8770
627
4514
838
4529
Spreadsheet: tori_kuykendall__39961__DailyPrices
Sheet: Sheet2

 | [NAME] | Spread to HH | Prompt Basis | Winter | Summer |  |  |  | Firm Transport | % | Commodity | Surcharge | GRI | Distance
Socal |  |  |  |  |  |  |  |  | EPNG - SJ/Socal | 0.0388 | 0.0166 | 0.0022 | 0.0072
PG&E CG |  |  |  |  |  |  |  |  | EPNG - Permian/Socal | 0.0388 | 0.0341 | 0.0022 | 0.0072
Malin |  |  |  |  |  |  |  |  | TW - SJ/Socal | 0.0475 | 0.0164 | 0.0085 | 0.0072
Perm |  |  |  |  |  |  |  |  | TW - Permian/Socal | 0.05 | 0.0224 | 0.0085 | 0.0072
San Juan |  |  |  |  |  |  |  |  | Socal/City Gate | 0.013
Rockies |  |  |  |  |  |  |  |  | Malin/City Gate | 0.013 |  |  | 0.0072
Sumas |  |  |  |  |  |  |  |  | NWPL | 0.0084 | 0.03 | 0.0022 | 0.0072
Aeco |  |  |  |  |  |  |  |  | Kingsgate/Malin | 4.7e-05 |  | 0.0097 | 0.0072 | 612.46
Waha |  |  |  |  |  |  |  |  | Kingsgate/Stanfield | 4.7e-05 |  | 0.0097 |  | 277.37
PEPL |  |  |  |  |  |  |  |  | Stanfield/Malin | 4.7e-05 |  | 0.0097 | 0.0072 | 335.09
Dawn |  |  |  |  |  |  |  |  | EPNG- Perm/Midcon | 0.0388 | 0.003 | 0.0022 | 0.0072
[NAME] |  |  |  |  |  |  |  |  | EPNG- Perm/Waha | 0.0155 | 0.0058 | 0.0022
 |  |  |  |  |  |  |  |  | EPNG- Perm/NM | 0.0155 | 0.0149 | 0.0022 | 0.0072
Variable Rates |  | No GRI in # |  | IT Rates |  |  |  |  | EPNG- Perm/Ariz | 0.0388 | 0.0221 | 0.0022 | 0.0072
SJ/Socal - EPNG |  |  |  | SJ/Socal |  |  |  |  | EPNG- Perm/Nevada | 0.0388 | 0.0358 | 0.0022 | 0.0072
Perm/Socal - EPNG |  |  |  | Perm/Socal |  |  |  |  | EPNG- SJ/Waha | 0.0388 | 0.0031 | 0.0022 | 0.0072
Socal/PG&E CG |  |  |  | Malin/Socal | 0.5192 |  |  |  | CIG- Rox/Midcon | 0.033 | 0.0245 |  | 0.0072
Malin/Socal |  |  |  | Malin/PG&E CG |  |  |  |  | TW-SJ/Waha | 0.0156 | 0.0082 | 0.0088 | 0.0072
Stanfield/Malin
Kingsgate/Malin |  |  |  |  |  |  |  |  | Interruptible Transport
Kingsgate/Stanfield |  |  |  |  |  |  |  |  | EPNG - SJ/Socal | 0.0388 | 0.3876 | 0.0022 | 0.0072
Sumas/Stanfield |  |  |  |  |  |  |  |  | EPNG - Permian/Socal | 0.0388 | 0.3701 | 0.0022 | 0.0072
Rockies/Stanfield |  |  |  |  |  |  |  |  | EPNG - Anadarko/Socal | 0.0388 | 0.3918 | 0.0022 | 0.0072
Rockies/SJ |  |  |  |  |  |  |  | ? | TW - Perm / Socal |  | 0.3677 | 0.0022 | 0.0072
Spreadsheet: 65865801-ceed-4465-97cb-94a59cba3778
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: April 16, 2014 (9:43 am)
Period | Value
Q1-2000
Q2-2000
Q3-2000
Q4-2000 | 1128790
Q1-2001 | 1082233
Q2-2001 | 1116597
Q3-2001 | 1062443
Q4-2001 | 1033734
Q1-2002 | 994073
Q2-2002 | 1071574
Q3-2002 | 1068667
Q4-2002 | 1082128
Q1-2003 | 1072017
Q2-2003 | 1096910
Q3-2003 | 1109436
Q4-2003 | 1118800
Q1-2004 | 1145872
Q2-2004 | 1248717
Q3-2004 | 1250976
Q4-2004 | 1288495
Q1-2005 | 1258442
Q2-2005 | 1352179
Q3-2005 | 1384246
Q4-2005 | 1416600
Q1-2006 | 1397414
Q2-2006 | 1485624
Q3-2006 | 1467143
Q4-2006 | 1432485
Q1-2007 | 1405836
Q2-2007 | 1526484
Q3-2007 | 1539399
Q4-2007 | 1588312
Q1-2008 | 1566418
Q2-2008 | 1724172
Q3-2008 | 1682270
Q4-2008 | 1401261
Q1-2009 | 1196693
Q2-2009 | 1253821
Q3-2009 | 1305867
Q4-2009 | 1353446
Q1-2010 | 1349210
Q2-2010 | 1461717
Q3-2010 | 1463507
Q4-2010 | 1481530
Q1-2011 | 1532484
Q2-2011 | 1657405
Q3-2011 | 1650561
Q4-2011 | 1645072
Q1-2012 | 1648177
Q2-2012 | 1689523
Q3-2012 | 1656755
Q4-2012 | 1673633
Q1-2013 | 1626450
Q2-2013 | 1704235
Q3-2013 | 1705800
Q4-2013 | 1711652
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.15.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-15 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 14 | 0 | 4 | 1 | 0 | 0 | 1 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 7 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-15 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 0 | 1 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 0 | 1 | 2 | 1 | 0
 | ABC | 27 | 18 | 15 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 2 | 0 | 1 | 0 | 1 | 0 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 1 | 1.4 | 0
 | Total House Census
Spreadsheet: 749681d1632963363-looking-for-help-with-a-calculation-between-2-fields-build_reva
Sheet: Weekly Workload

Weekly schedule |  |  |  | Hours to do work |  |  | Total Hours worked
Name | Job | Hours |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | Shed |  | Shed | 2 | 3
[NAME] | House |  | House | 4 | 5
[NAME] | Shed
[NAME] | House
[NAME] | Shed
Spreadsheet: 844583d1696350107-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-stdar2-
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 20 | 50 | 80 | 110
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 30 | 60 | 90 | 20
 |  |  |  |  |  |  |  |  | Material | Material 3 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 2
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 |  |  |  |  |  | USA
 |  | Mexico | 30 |  |  |  |  |  | CANADA
 |  |  |  |  |  |  |  |  | Mexico
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 |  | Car 3
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 | APP | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4 | 0.0007 | 0 | 0.035 | 0.08988
 | Material 5 | 30 | 0 | 80 | 72
 | Material 6
 | Material 7
 | Material 8
 | AS | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4
 | Material 5
 | Material 6
 | Material 7
 | Material 8
Spreadsheet: 861798d1709637288-help-having-trouble-with-formulas-mock
Sheet: Sheet1

 |  |  |  |  | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
 |  |  |  | Days of month
 | DAILY COST | OFFHIRE REF | OFFHIRE DATE |  | Monthly projected costs
unit 1 | 6.7 |  | 2024-02-28 00:00:00
Unit 2 | 6.7 |  | 2024-03-03 00:00:00
Unit 3 | 6.7 |  | 2024-01-29 00:00:00
Unit 4 | 6.7 |  | 2025-03-15 00:00:00
Unit 5 | 6.7
Unit 6 | 6.7
Unit 7 | 6.7
Unit 8 | 6.7
Unit 9 | 6.7
Unit 10 | 6.7
Unit 11 | 6.7
Unit 12 | 6.7 |  | 2024-06-06 00:00:00
Unit 13 | 6.7
Unit 14 | 6.7
 |  |  |  | unit 1
 |  |  |  | Unit 2
 |  |  |  | Unit 3
 |  |  |  | Unit 4
 |  |  |  | Unit 5
 |  |  |  | Unit 6
 |  |  |  | Unit 7
 |  |  |  | Unit 8
 |  |  |  | Unit 9
 |  |  |  | Unit 10
 |  |  |  | Unit 11
 |  |  |  | Unit 12
 |  |  |  | Unit 13
 |  |  |  | Unit 14
 |  |  |  |  | Data should not be here as it should have gell out on the months stated at offhire
 |  |  |  |  | Data should be here as the offhire is not until 2025
 |  |  |  |  | Can you change the fields to capture IF currency is £, $, € then to change the currency in monthly projected costs fields (F to S)
Spreadsheet: 76172d1276711950-master-sheet-from-other-sheets-of-different-size-class-test-2
Sheet: Sheet1

name | reg | test a | test a%
nn | 17.1 | 1 | 0.001
jj | 15.5 | 2 | 0.002
rr | 18.7 | 2 | 0.002
ss | 19.1 | 2 | 0.002
gg | 14.3 | 4 | 0.004
pp | 17.9 | 4 | 0.004
aa | 12 | 5 | 0.005
ff | 13.9 | 5 | 0.005
hh | 14.7 | 5 | 0.005
vv | 20.3 | 5 | 0.005
bb | 12 | 6 | 0.006
ii | 15.1 | 6 | 0.006
dd | 13 | 8 | 0.008
cc | 13 | 10 | 0.01
ee | 13.5 | 10 | 0.01
kk | 15.9 | 12 | 0.012
uu | 19.9 | 15 | 0.015
tt | 19.5 | 22 | 0.022
xx | 21.1 | 22 | 0.022
yy | 21.5 | 33 | 0.033
aaa | 22.3 | 34.7138461538461 | 0.0347138461538461
bbb | 22.7 | 35.9063247863248 | 0.0359063247863248
[NAME] | 23.1 | 37.0988034188034 | 0.0370988034188034
dd | 23.5 | 38.291282051282 | 0.038291282051282
eee | 23.9 | 39.4837606837607 | 0.0394837606837607
[NAME] | 24.3 | 40.6762393162393 | 0.04067623931623929
ll | 16.3 | 41 | 0.041
ggg | 24.7 | 41.8687179487179 | 0.0418687179487179
hhh | 25.1 | 43.0611965811966 | 0.0430611965811966
zz | 21.9 | 45 | 0.045
[NAME] | 16.7 | 54 | 0.054
oo | 17.5 | 54 | 0.054
qq | 18.3 | 55 | 0.055
ww | 20.7 | 60 | 0.06
Spreadsheet: 844958d1696543997-convert-column-data-to-calendar-limited2022-calendar-v1
Sheet: Calendar

Fruit Distribution |  |  |  |  |  |  |  | Type | Assignment | Qty | Begin | Duration |  | Date | Holiday
Month of: | 2023-11-24 00:00:00 |  |  |  |  |  |  | Apples | 12345 | 195 | Green 29-Nov | 12 |  | 2023-11-23 00:00:00
 |  |  |  |  |  |  |  | Oranges | 23456 | 280 | 2023-11-15 00:00:00 | 7 |  | 2023-11-24 00:00:00
 |  |  |  |  |  |  |  | Pears | 34567 | 240 | Yellow 29-Nov | 2
 |  |  |  |  |  |  |  | Strawberries | 45678 | 206 | 2023-11-06 00:00:00 | 4
 |  |  |  |  |  |  |  | Grapes | 56789 | 300 | 2023-11-22 00:00:00 | 11
 |  |  |  |  |  |  |  | Oranges | 51347 | 155 | 2023-11-21 00:00:00 | 6
 | Strawberries  (45678)   206  (4) | Grapes  (89475)  220  (21) | Grapes  (89475)  220  (21) | Grapes  (89475)  220  (21) |  |  |  | Grapes | 89475 | 220 | 2023-11-07 00:00:00 | 21
 |  |  | Oranges  (23456)  280  (7) | Oranges  (23456)  280  (7)
 |  | Oranges  (51347)  155  (6) | Grapes  (56789)  300  (11)
 | Grapes  (56789)  300  (11) |  | Apples  (12345)  195  (12)  Green Pears  (34567)  240  (2)  Yellow | Apples  (12345)  195  (12)  Green