tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164538d1340807370-skakes-in-the-summer-keyword-lookup
Sheet: Sheet1

Keywords | Items | key |  |  | Results: |  | Match items
an | [NAME] |  |  |  |  |  |  |  |  | Press CTRL-F3 to see the named range Keywords
iw | Pear |  |  |  |  |  |  |  |  | that creates itself based on how many items you
 | Apple |  |  |  |  |  |  |  |  | enter into column A.  That named range is used in
 | Kiwi |  |  |  |  |  |  |  |  | the formulas in column C to create the key.
 | Orange
 | Cantelope |  |  |  |  |  |  |  |  | Results on the right, formula in column H is copied
 |  |  |  |  |  |  |  |  |  | into all the yellow cells so you can see how the results
 |  |  |  |  |  |  |  |  |  | can expand / contract themselves based on your
 |  |  |  |  |  |  |  |  |  | actions in column A, in realtime.
Spreadsheet: 839229d1691760549-delete-or-empty-rows-based-on-specific-chain-of-values-org-chart-example
Sheet: Final

[NAME] | Reports to | Layer
Spreadsheet: 873712d1720256968-find-a-result-from-2-matrix-tables-matrix-example-1-
Sheet: Results

 | users / groups |  |  |  |  |  | functions / groups |  |  |  |  |  | results
 |  | Production | Sales | Finance | Management |  |  | Production | Sales | Finance | Management |  |  | Order | Quote | Job | Pay | PO's | Supplier
 | User1 | x |  |  |  |  | Order | x | x | x | x |  | User1 | x |  | x |  | x |  |  |  |  | x |  | x
 | User2 | x |  |  |  |  | Quote |  | x | x |  |  | User2 | x |  | x |  | x |  |  | x |  | x |  | x
 | User3 |  | x |  |  |  | Job | x | x |  |  |  | User3 | x | x | x |  | x |  |  | x | x | x |  | x
 | User4 |  | x |  |  |  | Pay |  |  | x |  |  | User4 | x | x | x |  | x |  |  | x | x | x |  | x
 | [NAME] |  | x |  |  |  | PO's | x | x | x |  |  | [NAME] | x | x | x |  | x |  |  | x | x | x |  | x
 | [NAME] |  |  | x |  |  | Supplier |  |  | x | x |  | [NAME] | x | x |  | x | x | x |  | x | x |  | x | x | x
 | User7 |  |  |  | x |  |  |  |  |  |  |  | User7 | x |  |  |  |  | x |  | x |  |  |  |  | x
 | User8 |  |  |  | x |  |  |  |  |  |  |  | User8 | x |  |  |  |  | x |  | x |  |  |  |  | x
 | [NAME] | x | x |  |  |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x |  |  | x | x | x |  | x
 | User10 | x |  |  |  |  |  |  |  |  |  |  | User10 | x |  | x |  | x |  |  | x |  | x |  | x
1 | find the group for the user (x indicates true)
2 | find the function to the group (x indicates true)
3 | show the result of user to function (x indicates true)
Spreadsheet: 58579a98-e1f3-4cc3-a64b-a8a87a8030af
Sheet: Sheet1

Securities | % of Assets
Bell Aliant Inc | 4.69%
Dollarama Inc. | 3.92%
Fairfax Financial Holding | 3.85%
Metro Inc. | 3.78%
BCE Inc. | 3.68%
Alimentatn Couche-Tard B | 3.59%
Empire Company Cl A NVS | 3.32%
Tim Hortons Inc. | 3.07%
RioCan REIT | 2.85%
Keyera Corp | 2.79%
Rogers Communications Inc | 2.76%
TELUS Corp. | 2.69%
TransCanada Corp. | 2.68%
Pembina Pipeline Inc | 2.68%
Canadian REIT | 2.64%
Intact Financial Corp | 2.55%
Cdn Utilities Cl A NVS | 2.52%
Enbridge Inc. | 2.52%
Weston(George) Ltd. | 2.49%
Emera Inc. | 2.44%
Inter Pipeline Ltd. | 2.36%
Shaw Communicatn Cl B Nvs | 2.33%
Loblaw Companies Ltd. | 2.31%
AltaGas Ltd | 2.15%
ATCO Ltd Class I | 2.11%
Franco-Nevada Corp | 2.04%
Catamaran Corporation | 2.01%
Fortis Inc. | 1.93%
Thomson Reuters Corp | 1.90%
Saputo Inc. | 1.88%
CGI Group Inc Cl A | 1.86%
Open Text Corp. | 1.84%
Valeant Pharmaceuticals | 1.84%
Canadian Tire Corp Cl A | 1.81%
H&R REIT | 1.80%
CI Financial Corp | 1.78%
West Fraser Timber Co Ltd | 1.73%
TransAlta Corp. | 1.58%
IGM Financial Inc. | 1.48%
CAE Inc. | 1.42%
Cash | 0.30%
Total Holdings in Portfolio | 41
Spreadsheet: 687543d1595268464-lookup-formula-to-output-all-values-tied-to-one-value-2020-07-20-oeldere2-roaml-687530d1595261371-lookup-formula-to-output-all-values-tied-to-one-
Sheet: Lookup Data

Project Num: | PR556000
Project Num | WO Num | Location | Submit Date
PR556000 | WO 3444 | Palm Springs | 2020-03-01 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-02 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-03 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-04 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-05 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-06 00:00:00
PR556001 | WO 3445 | Palm Springs | 2020-03-07 00:00:00
PR556002 | WO 3446 | Palm Springs | 2020-03-08 00:00:00
PR556003 | WO 3447 | Palm Springs | 2020-03-09 00:00:00
PR556004 | WO 3448 | Palm Springs | 2020-03-10 00:00:00
PR556005 | WO 3449 | Palm Springs | 2020-03-11 00:00:00
PR556006 | WO 3450 | Palm Springs | 2020-03-12 00:00:00
PR556007 | WO 3451 | Palm Springs | 2020-03-13 00:00:00
PR556008 | WO 3452 | Palm Springs | 2020-03-14 00:00:00
PR556009 | WO 3453 | Palm Springs | 2020-03-15 00:00:00
PR556010 | WO 3454 | Palm Springs | 2020-03-16 00:00:00
PR556011 | WO 3455 | Palm Springs | 2020-03-17 00:00:00
PR556012 | WO 3456 | Palm Springs | 2020-03-18 00:00:00
PR556013 | WO 3457 | Palm Springs | 2020-03-19 00:00:00
PR556014 | WO 3458 | Palm Springs | 2020-03-20 00:00:00
PR556015 | WO 3459 | Palm Springs | 2020-03-21 00:00:00
PR556016 | WO 3460 | Palm Springs | 2020-03-22 00:00:00
PR556017 | WO 3461 | Palm Springs | 2020-03-23 00:00:00
PR556018 | WO 3462 | Palm Springs | 2020-03-24 00:00:00
PR556019 | WO 3463 | Palm Springs | 2020-03-25 00:00:00
Spreadsheet: 797017d1663671745-count-function-to-not-count-blank-cells-with-formula-in-them-sortandcount-aligw
Sheet: Sheet1

NAME | Code |  |  | Status [good] | Status [Bad] | Status [In progress]
[NAME] doe | good
[NAME] | bad |  |  | name x | name xxxx
jane doe |  |  |  | name xx | name xxxxx |  |  | Count Good | [NAME] | Count In progress
[NAME] |  |  |  | name xxx
name x | good
name xx | good
name xxx | good
name xxxx | bad
name xxxxx | bad
 |  |  |  |  |  | Since there is  no in progress
 |  |  |  |  |  | staus, its blank
 | Input
 |  |  |  | outputs
 |  |  |  |  |  |  |  |  | This should be zero, how do I fix this? please
Spreadsheet: 883991d1732827505-incremental-cell-references-book1_2
Sheet: Sheet1

DATES | 2023-07-30 00:00:00
WEEK NUMBER
RESULT WANTED | 31
Spreadsheet: 155995d1337129662-excel-2007-data-migration-help-change-log-v2
Sheet: Change Log

Client_1 |  |  |  |  | Dispalying Entries from last |  | 5 | Days |  | Client_2 |  |  |  |  | Dispalying Entries from last |  | 5 | Days
Date | Action | Item | Qty | UoM |  |  |  |  |  | Date | Action | Item | Qty | UoM
2012-05-12 00:00:00 | In | Item_23 | 10 | EA |  |  |  |  |  | 2012-05-11 00:00:00 | In | Item_2_16 | 2 | EA
2012-05-12 00:00:00 | In | Item_24 | 11 | EA |  |  |  |  |  | 2012-05-11 00:00:00 | In | Item_2_17 | 1 | EA
2012-05-13 00:00:00 | In | Item_25 | 12 | EA |  |  |  |  |  | 2012-05-11 00:00:00 | Out | Item_2_18 | 1 | EA
2012-05-13 00:00:00 | Out | Item_26 | 1 | EA |  |  |  |  |  | 2012-05-12 00:00:00 | In | Item_2_19 | 10 | EA
2012-05-13 00:00:00 | Out | Item_27 | 3 | EA |  |  |  |  |  | 2012-05-12 00:00:00 | In | Item_2_20 | 3 | EA
2012-05-13 00:00:00 | In | [NAME] | 13 | EA |  |  |  |  |  | 2012-05-13 00:00:00 | In | Item_2_21 | 2 | EA
2012-05-13 00:00:00 | Out | Item_29 | 3 | EA |  |  |  |  |  | 2012-05-13 00:00:00 | In | Item_2_22 | 5 | EA
2012-05-13 00:00:00 | In | Item_30 | 6 | EA |  |  |  |  |  | 2012-05-13 00:00:00 | Out | Item_2_23 | 45 | EA
2012-05-13 00:00:00 | In | Item_31 | 1 | EA |  |  |  |  |  | 2012-05-13 00:00:00 | In | Item_2_24 | 3 | EA
2012-05-13 00:00:00 | In | Item_32 | 3 | EA |  |  |  |  |  | 2012-05-13 00:00:00 | In | Item_2_25 | 27 | EA
2012-05-15 00:00:00 | Out | Item_33 | 3 | EA |  |  |  |  |  | 2012-05-14 00:00:00 | In | Item_2_26 | 4 | EA
2012-05-15 00:00:00 | Out | Item_34 | 21 | EA |  |  |  |  |  | 2012-05-14 00:00:00 | Out | Item_2_27 | 16 | EA
2012-05-15 00:00:00 | In | Item_35 | 1 | EA |  |  |  |  |  | 2012-05-15 00:00:00 | Out | Item_2_28 | 23 | EA
2012-05-15 00:00:00 | In | Item_36 | 23 | EA |  |  |  |  |  | 2012-05-15 00:00:00 | In | Item_2_29 | 1 | EA
 |  |  |  |  |  |  |  |  |  | 2012-05-15 00:00:00 | Out | Item_2_30 | 6 | EA
Spreadsheet: 862179d1709925279-countifs-keeps-returning-zero-book2
Sheet: Sheet1

START | END | REP VIS | MECH |  | COUNT OF JOBS IN FEB'2024 WITH 1-2 REP VIS BY MECH: ENG1 & ENG3 ONLY
2024-02-01 00:00:00 | 2024-02-07 00:00:00 | 2 | ENG1 |  | MANUAL ANSWER = 3
2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 3 | ENG4
2024-02-05 00:00:00 | 2024-02-22 00:00:00 | 1 | ENG3
2024-02-18 00:00:00 | 2024-03-01 00:00:00 | 1 | ENG3
2024-02-22 00:00:00 | 2024-02-28 00:00:00 | 1 | ENG3 |  | COUNTIFS(A2:A7,">=01/02/2024",B2:B7,"<=29/02/2024",D2:D7,ENG1,D2:D7,ENG3,C2:C7,">=1",C2:C7,"<=2")
2024-02-17 00:00:00 | 2024-03-02 00:00:00 | 2 | ENG8
Spreadsheet: andy_zipper__527__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | Z | 255 | exp. | exp. | #[NAME]! | #[NAME]!
 | F | 295 | 60 | 62 | 0.9129999999999897 | -0.000299999999999967
 | G | 295 | 80 | 83 | 0.8468999999999893 | 0.008399999999999075
 | H | 290 | 83 | 86 | 0.7447999999999929 | -0.008399999999999075
 | J | 290 | 77 | 80 | 0.6132999999999914 | -0.01139999999999874
 | K | 290 | 80.5 | 82 | 0.5660999999999905 | -0.004799999999999471 |  |  | Z/H | 281.6666666666667 | #[NAME]!
 | M | 295 | 86 | 89 | 0.5493999999999902 | -0.01079999999999881 |  |  | J/V | 297.8571428571428 | 94.60714285714286
 | N | 300 | 93 | 97 | 0.5462999999999746 | -0.002399999999999736
 | Q | 300 | 99 | 104 | 0.5442499999999754 | -0.01109999999999878
 | U | 305 | 104 | 107 | 0.5313499999999768 | -0.01829999999999798
 | V | 305 | 110 | 116 | 0.5445499999999753 | -0.003299999999999637
 | X | 320 | 122 | 127 | 0.547399999999975 | -0.002399999999999736
 | [NAME] | 340 | 135 | 137 | 0.4738999999999831 | 0
 | H03 | 330
 |  |  | 2001-11-27 14:45:08.850000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | F | 1950 | 214 | 216 | 0.6413499999999842 | -0.02369999999999739
 | G | 1950 | 337 | 343 | 0.5859999999999912 | -0.02249999999999752
 | H | 1950 | 395 | 410 | 0.5543499999999928 | -0.02744999999999698
 | J | 2000 | 455 | 460 | 0.5351999999999928 | -0.01619999999999822
 | K | 2000 | 485 | 500 | 0.5082999999999932 | -0.01199999999999868
 | M | 2000 | 505 | 520 | 0.4822499999999945 | -0.01469999999999838
 | N | 2000 | 515 | 535 | 0.4613499999999942 | -0.01349999999999851
 | Q | 2050 | 520 | 540 | 0.4217499999999964 | -0.02834999999999688
 | U | 2050 | 525 | 545 | 0.4049999999999971 | -0.01859999999999795
 | V | 2050 | 530 | 550 | 0.384999999999997 | -0.01529999999999831
 | X | 2050 | 530 | 555 | 0.3713999999999874 | -0.01154999999999873
 | Z | 2050 | 535 | 565 | 0.3149999999999936 | 0
 | F03 |  |  |  | #[NAME]! | #[NAME]!
 |  |  | 2001-11-27 14:48:06.860000
Spreadsheet: 43e1dc63-e702-423b-a015-8a59c4977504
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
FVANG | Test | FVANG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FVANG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FVANG | Result | FVANG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 854101d1704083830-how-to-calculate-amount-for-each-working-day-excel-forum-beamer
Sheet: Sheet1

2023-12-28 00:00:00 |  | banking days |  | Forecast | Monthly Actual
Total | 2111588.44 | ÷ 20 |  | 103K | 106K
TP | 436834.74 | ÷ 20 |  | 23K | 22K
SITE | 1066710.22 | ÷ 20 |  | 50K | 53K
DOD | 608043.48 | ÷ 20 |  | 30K | 30K
 | Holidays
2023-01-01 00:00:00 | New Year’s Day*
2023-01-02 00:00:00 | New Year’s Day Additional Day
2023-01-26 00:00:00 | Australia Day
2023-04-07 00:00:00 | Good Friday
2023-04-08 00:00:00 | Easter Saturday
2023-04-09 00:00:00 | Easter Sunday
2023-04-10 00:00:00 | Easter Monday
2023-04-25 00:00:00 | Anzac Day
2023-06-12 00:00:00 | King’s Birthday
2023-08-07 00:00:00 | Bank Holiday**
2023-10-02 00:00:00 | Labour Day
2023-12-25 00:00:00 | Christmas Day
2023-12-26 00:00:00 | Boxing Day
Spreadsheet: 780813d1652796504-summarize-payroll-data-for-the-week-excel-help
Sheet: CURRENT WEEK

 |  |  |  |  |  |  |  | Week ending |  |  | 2022-05-15 00:00:00
 |  |  | MON |  |  | TUES |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT |  |  | SUN
Operative |  | Client | TRADE | RATE | HOURS | TRADE | RATE | HOURS | TRADE | RATE | HOURS | TRADE | RATE | HOURS | TRADE | RATE | HOURS | TRADE | RATE | HOURS | TRADE | RATE | HOURS | Total Hrs | Add | Ded | Total |  |  | Reference
Smith | [NAME] | A | Misc | 9.5 | 10 | Misc | 9.5 | 10 | Misc | 9.5 | 10 | Misc | 9.5 | 2
[NAME] | [NAME] | A | Misc | 9.5 | 10 | Misc | 9.5 | 10 | Misc | 9.5 | 10 | Misc | 9.5 | 10 | Misc | 9.5 | 10
Smith | [NAME] | B |  |  |  |  |  |  |  |  |  | Misc | 12 | 8
Spreadsheet: 79735d1279917350-tax-calculator-g-2bn-20pay1-1-
Sheet: Tax schedules

Head of House |  |  |  |  |  |  | Single | 1
4 | over | but not over | rate | of the amount over | 39000 |  | Married Filed Jointly | 2
 | 0 | 11950 | 0.1 | 0 | 1195 |  | Married Filed Separately | 3
 | 11950 | 45500 | 0.15 | 11950 | 4057.5 |  | Head of House | 4
 | 45500 | 117450 | 0.25 | 45500 | 0
 | 117450 | 190200 | 0.28 | 117450 | 0
 | 190200 | 372950 | 0.33 | 190200 | 0
 | 372950 | 0 | 0.35 | 372950 | 0
 |  |  |  |  | 5252.5
 | over | but not over | rate | of the amount over
Single | 0 | 8350 | 0.1 | 0
Single | 83.5 | 33950 | 0.15 | 8350
Single | 339.5 | 82250 | 0.25 | 33950
Single | 822.5 | 171550 | 0.28 | 82250
Single | 1715.5 | 372950 | 0.33 | 171550
Single | 3729.5 |  | 0.35 | 372950
 | over | but not over | rate | of the amount over
married filed jointly | 0 | 16700 | 0.1 | 0
married filed jointly | 16700 | 67900 | 0.15 | 16700
married filed jointly | 67900 | 137050 | 0.25 | 67900
married filed jointly | 137050 | 208850 | 0.28 | 137050
married filed jointly | 208850 | 372950 | 0.33 | 208850
married filed jointly | 372950 |  | 0.35 | 372950
 | over | but not over | rate | of the amount over
married filed separately | 0 | 8350 | 0.1 | 0
married filed separately | 8350 | 33950 | 0.15 | 8350
married filed separately | 33950 | 68525 | 0.25 | 33950
married filed separately | 68525 | 104425 | 0.28 | 68525
married filed separately | 104425 | 186475 | 0.33 | 104425
married filed separately | 186475 |  | 0.35 | 186475
 | over | but not over | rate | of the amount over
head of household | 0 | 11950 | 0.1 | 0
head of household | 11950 | 45500 | 0.15 | 11950
head of household | 45500 | 117450 | 0.25 | 45500
head of household | 117450 | 190200 | 0.28 | 117450
head of household | 190200 | 372950 | 0.33 | 190200
head of household | 372950 |  | 0.35 | 372950
Spreadsheet: 845411d1696942704-concatenate-data-using-condition-of-search-sample-1-
Sheet: Sheet1

DATA |  |  |  | RESULT
Name | Number |  |  | Result | Number | Name | Custom
Raju | 12 |  |  | Raju | 12,25 | Raju | 12, 25
Raju | 25 |  |  | Sharma | 94,85,487 | Sharma | 94, 85, 487
Sharma | 94 |  |  | [NAME] | 546,124 | [NAME] | 546, 124
Sharma | 85 |  |  | [NAME] | 124,48,474,854 | [NAME] | 124, 48, 474, 854
Sharma | 487 |  |  | Raj | 9 | Raj | 9
[NAME] | 546
[NAME] | 124
[NAME] | 124
[NAME] | 48
[NAME] | 474
[NAME] | 854
Raj | 9
Spreadsheet: 133845d1324685662-printing-only-rows-with-values-scrap-quotes
Sheet: Receipt

 | [NAME]
 | 123456 Main Street, Any Town, GA
 | 5555551212
 | Client: |  |  |  |  |  | Date:
 |  |  |  |  |  |  | Ticket:
 | Weight-Lbs |  | Scrap Type |  |  |  | Total
 | 27.5 |  | Bright & Shiny Copper |  |  |  | 14.3
 | 70.9 |  | # 1 Insulated Wire |  |  |  | 43.49
 | 15 |  | Aluminum Turnings |  |  |  | 15
 | 489.5 |  | No. 1 HMS Steel Scrap |  |  |  | 440.55
 | 235 |  | [NAME] |  |  |  | 225.6
 |  |  |  |  | Total Paid:
 | Customer Or Company Name
 | Customer Signature |  |  |  |  |  | Date
Spreadsheet: 830296d1684847936-excel-fomular_index-match-and-min-max-fomular
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AAA | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?
Spreadsheet: 843194d1695122514-formula-to-match-certain-data-in-large-dataset-sample-6
Sheet: Sheet1

 | Workbook #1 |  |  |  | Workbook #2
 | Current Room Number | Area Description |  |  | Current Room Number | Area Description
 | TF317 | Area #1 |  |  | [NAME] | Area #9
 | TF315 | Area #2 |  |  | TF316 | Area #4
 | [NAME] | Area #3 |  |  | TF337 | Area #16
 | TF316 | Area #4
 | TF318 | Area #5
 | TF330 | Area #6
 | TF328 | Area #7
 | TF329 | Area #8
 | [NAME] | Area #9
 | TF331 | Area #10
 | TF326 | Area #11
 | TF336 | Area #12
 | TF333 | Area #13
 | TF332 | Area #14
 | TF334 | Area #15
 | TF337 | Area #16
Spreadsheet: 275972d1383702547-populate-cells-if-there-is-a-min-and-max-value-leave-01
Sheet: Sheet1

Leave details
Staff member | Vacation Type | Start Date | End Date | On Leave
Fred | Sick | 2013-01-01 00:00:00 | 2013-01-04 00:00:00 | 3 Days
[NAME] | Unpaid | 2013-01-24 00:00:00 | 2013-01-26 00:00:00 | 2 Days
[NAME] | Annual | 2013-02-23 00:00:00 | 2013-03-03 00:00:00 | 8 Days
[NAME] | Annual | 2013-04-15 00:00:00 | 2013-04-26 00:00:00 | 11 Days
Spreadsheet: 792572d1660985282-retrieving-data-from-a-table-based-on-two-drop-down-box-values-sample1
Sheet: Department Report

1969
 |  |  | Department Costing Report
 |  | Supplier | Marketing |  | Month 1 | June
 |  |  |  |  | Month 2 | July
 |  | Total Spent inc. VAT
 |  | Total Spent ex. VAT
 |  | Total VAT
 |  |  |  |  | Difference +/-
 |  | Supplier Expenditure With Chosen Department
 |  |  | Total Inc. VAT |  |  | Difference +/-
 |  | All Suppliers
 |  | [NAME]
 |  | AJet
 |  | Amazon
 |  | Arboritom
 |  | Arleigh
 |  | Asgard
 |  | AvantiGas
 |  | Buildbase
 |  | Calor
 |  | [NAME]
 |  | Coast & County Ltd
 |  | Creative Play
 |  | DeeBee
 |  | Eden Farm Hulleys
 |  | EuroCell
 |  | Firestop Services
 |  | Foundations and Buildings
 |  | [NAME]
 |  | [NAME]'s Homeware
 |  | Keycraft
 |  | [NAME]
 |  | [NAME]
 |  | LincsPest Ltd
 |  | Miscellaneous Vendor
 |  | Office Stationary
 |  | S and A Colclough
 |  | Screwfix
 |  | SGS
 |  | Smart Spanner
 |  | SSE
 |  | Tesco
 |  | Veolia
 |  | Victorian Plumbing
 |  | Weldricks Pharmacy
 |  | Welton Aggregate
 |  | Windhager
 |  | Y Pellets
 | ------------------------------------------------------------------------------------------------------------------------------------------------------------
 |  | All Purchase Orders for selected "Month 1"
 |  | PO Number | Date of Purchase | Costing Code | Cost inc. VAT | Total VAT
 |  | All of the above figures are correct as of todays date, providing all Purchase Orders have been input into the [NAME] form.
Spreadsheet: 761675d1641147030-how-to-get-difference-between-two-numbers-based-on-condition-new-receipt-begin-difference-2
Sheet: Sheet1

SR | RECEIPT BATCH NO | RECEIPT FROM | RECEIPT TO | NEW RECEIPT BEGIN DIFFERENCE
1 | PLY 7851 | 167071 | 167119
2 | PLY 6970 | 234174 | 234275
3 | BJT 8155 | 182946 | 182999
4 | PLY 7851 | 167120 | 167155 |  | 1
5 | PLY 6970 | 234278 | 234361 |  | 3
6 | BJT 8155 | 183000 | 183162 |  | 1
7 | PLY 7851 | 167257 | 167193 |  | 2
8 | PLY 6970 | 234362 | 2344560 |  | 1
9 | BJT 8155 | 183063 | 183144 |  | -99
10 | PLY 6970 | 234457 | 234504 |  | -2110103
11 | BJT 8155 | 183146 | 183244 |  | 2
12 | PLY 6970 | 234507 | 234603 |  | 3
Spreadsheet: 841827d1693980461-copy-formulas-in-a-filtered-table-and-paste-as-values-visible-cells-only-filter-query
Sheet: FY24 Forecast

Project WBS | Planned Vs Actual | Jul-23 | Aug-23
C-CC22CC54-001 | Q1 Planned
C-CC22CC54-001 | Actual
C-CC22CC54-001 | Rolling | 5 | 4
C-CC24CC03-001 | Q1 Planned
C-CC24CC03-001 | Actual
C-CC24CC03-001 | Rolling | 7 | 7
C-CC23CC60-001 | Q1 Planned
C-CC23CC60-001 | Actual
 | Rolling | 2 | 2
 | Q1 Planned
 | Actual
 | Rolling
Spreadsheet: 1cc418a4-fc23-4af5-9927-d774f192f3b2
Sheet: Area 2

Location | Title | Name | Mobile | CRCs | CRC Mobile
Area 2 | Area Manager | [NAME] | 07764 960 391
Oxfordshire | RDO | [NAME] | 07715 856725 | [NAME] | 07803 011766
 |  |  |  | [NAME] | 07711 385907
Middlesex | RDO | [NAME] | 07764 336 718 | [NAME] | 07872 465422
 |  |  |  | [NAME] | 07711 385900
Middlesex | RDO | [NAME] | 07715 856 778 | [NAME] Jones | 07872 672 620
 |  |  |  | [NAME] | 07860 733 590
 |  |  |  | [NAME] | 07711 385 905
Middlesex | RDO | [NAME] | 07725 141 899 | [NAME] | 07738 029263
 |  |  |  | [NAME] | 07732 829972
 |  |  |  | [NAME] | 07894 489752
Hertfordshire | RDO | [NAME] | 07715 856769 | [NAME] | 07715 856943
 |  |  |  | [NAME] | 07894 489249
Buckinghamshire | RDO | [NAME] | 07764 960 408 | [NAME] | 07718 706585
 |  |  |  | [NAME] | 07711 385909
Hampshire | RDO | [NAME] | 07764 960 384 | [NAME] | 07850 982229
 |  |  |  | [NAME] | 07715 856940
 |  |  |  | [NAME] | 07711 385915
Hampshire | RDO | [NAME] | 07912 541 462 | [NAME] | 07843 343518
 |  |  |  | [NAME] | 07711 385917
Berkshire | RDO | [NAME] | 07738 648 918 | Toby Seward | 07872 827145
 |  |  |  | [NAME] | 07711 385919
Area 2 | URDO | [NAME] | 07738 029 261
Area 2 | WRDO | Clare Cooper | 07779 266 060