tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875155d1721729436-formula-required-for-value-book12
Sheet: Sheet1

pmpm from | pmpm to | growth | value |  | pmpm | growth | value req |  | rezult
0 |  | 170000 | 20000 |  | 1407568.281385282 | 250000 |  |  | 30000
800001 |  | 215000 | 25000 |  | 1166106.25 | 183843 |  |  | 0
1200001 |  | 250000 | 30000 |  | 1077405 | 428651 |  |  | 25000
1500001 |  | 300000 | 35000 |  | 1818614 | 310000 |  |  | 0
1800001 | 99999999 | 350000 | 40000 |  | 2299753.446280992 | 510000 |  |  | 40000
Spreadsheet: 624778d1558078470-google-sheets-how-to-match-data-and-return-needed-value-only-book1
Sheet: May

Full Name | 2019-05-02 00:00:00 | Login | Logout |  | Login | Logout |  | Login | Logout |  | Login | Logout |  | Login | Logout
 | Wednesday
Australia | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00 |  |  | 08:00:00
Germany | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00 |  |  | 07:00:00
Spreadsheet: louise_kitchen__23837__2QYTD Orig w notes
Sheet: Mexico

Mexico
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Mexico |  | 2138931.84
[NAME] |  | Gas |  | Mexico |  | 388431
Total
Spreadsheet: 834605d1687939993-maximum-drawdown-and-lambda-max-drawdown-aligw
Sheet: Sheet1

 | PRODUCT A | CUM | ROLL. MAX | DEV from MAX |  |  | START | END | MAX DRAWDOWN
2019-12-31 00:00:00 | -0.57861290846758 |  |  |  |  |  | 2020-12-31 00:00:00 | 2021-12-31 00:00:00
 | -3.590597718405362
 | 0.7494487010933701
 | 2.313996054078521
 | 1.594460980497281
 | -2.504119317371035
 | 0.5214285449261737
 | -3.582328339610863
 | -4.341948560645585
 | 2.809783807392531
 | -1.719229467161201
 | -0.6864038286669221
 | 2.224135315424497 | 0 |  |  |  |  |  | 2.224135315424497 | 0 | 0 | 0
 | -0.01527173662518511 |  |  |  |  |  | 2021-01-31 00:00:00 | -0.01527173662518511 | -0.01527173662518866 | 0 | -0.01527173662518866
 | 2.378054705894285 |  |  |  |  |  | 2021-02-28 00:00:00 | 2.378054705894285 | 2.362419799017612 | 2.362419799017612 | 0
 | 4.661159681791649 |  |  |  |  |  | 2021-03-31 00:00:00 | 4.661159681791649 | 7.13369563999573 | 7.13369563999573 | 0
 | -4.775167185182427 |  |  |  |  |  | 2021-04-30 00:00:00 | -4.775167185182427 | 2.017882561521445 | 7.13369563999573 | -4.775167185182417
 | 3.361289721034016 |  |  |  |  |  | 2021-05-31 00:00:00 | 3.361289721034016 | 5.446999161678434 | 7.13369563999573 | -1.574384667906115
 | -3.561089316044541 |  |  |  |  |  | 2021-06-30 00:00:00 | -3.561089316044541 | 1.691937340442329 | 7.13369563999573 | -5.079408739748404
 | -2.141225804925138 |  |  |  |  |  | 2021-07-31 00:00:00 | -2.141225804925138 | -0.4855166634195274 | 7.13369563999573 | -7.111872934000429
 | 4.125163667556905 |  |  |  |  |  | 2021-08-31 00:00:00 | 4.125163667556905 | 3.619618647138068 | 7.13369563999573 | -3.280085664799715
 | -4.607985322871996 |  |  |  |  |  | 2021-09-30 00:00:00 | -4.607985322871996 | -1.155158171737991 | 7.13369563999573 | -7.736925121660121
 | 2.488004230679637 |  |  |  |  |  | 2021-10-31 00:00:00 | 2.488004230679637 | 1.304105674757761 | 7.13369563999573 | -5.441415915331904
 | -3.23716843214557 |  |  |  |  |  | 2021-11-30 00:00:00 | -3.23716843214557 | -1.975278854612883 | 7.13369563999573 | -8.502436549204607
 | 1.338640635336978 |  |  |  |  |  | 2021-12-31 00:00:00 | 1.338640635336978 | -0.6630801046849766 | 7.13369563999573 | -7.277612984509019
 | 4.460280898448705
 | -4.244273360102114
 | 1.235959366317568
 | -1.178230496554038
 | -0.5222887226825081
 | 3.25359450990716
 | 0.9190951134371517
 | -4.642195152033653
 | 3.767401082542253
 | 0.7683136638498169
 | -0.7538937858272714
 | 4.212158379213635
 | 0.5736298715738544
 | 3.18529571214351
 | -0.2011605325859058
 | 0.9084418826879217
 | 1.978766747909637
Spreadsheet: 21472d1209044135-countif-with-two-conditions-aged-days
Sheet: Sheet1

Summary
A |  |  | 1 | 1 | 0 | 1
B |  |  | 0 | 2 | 0 | 0
C |  |  | 0 | 0 | 0 | 1
D |  |  | 0 | 0 | 0 | 0
ID | Start Date | Value | Aged Days |  |  |  | Today
 |  |  | 30 | 60 | 90 | 999
A | 2008-04-21 00:00:00 | 100 | 100 | 0 | 0 | 0 | 2008-04-24 00:00:00
A | 2008-01-23 00:00:00 | 110 | 0 | 0 | 0 | 110 | 2008-04-24 00:00:00
A | 2008-03-20 00:00:00 | 120 | 0 | 120 | 0 | 0 | 2008-04-24 00:00:00
B | 2008-03-23 00:00:00 | 130 | 0 | 130 | 0 | 0 | 2008-04-24 00:00:00
B | 2008-03-23 00:00:00 | 140 | 0 | 140 | 0 | 0 | 2008-04-24 00:00:00
C | 2007-09-10 00:00:00 | 150 | 0 | 0 | 0 | 150 | 2008-04-24 00:00:00
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Peak Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual | Fuel | Annual | VOM | Annual | SO2 | Annual | NOx | Annual
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | Revenue | Cost | Fuel | Cost | VOM | Cost | SO2 | Cost | NOx
2000-01-15 00:00:00
Spreadsheet: 795249d1662575081-how-to-use-vloop-up-formula-to-retrieve-the-values-from-different-work-sheet-test1
Sheet: Salary

 |  |  | Sr. # | Name | No. of Days | Salary | Commission |  | Commission
 |  |  | 1 | [NAME]
 |  |  | 2 | [NAME]
 |  |  | 3 | Michelle
 |  |  | 4 | [NAME]
 |  |  | 5 | [NAME]
 |  |  | 6 | Asmos
 |  |  | 7 | Senti
 |  |  | 8 | [NAME]
 |  |  | 9 | [NAME]
 |  |  | 10 | Nathan
 |  |  | On F2 to F9 I want "R2 to R10" value from Attendace sheet
 |  |  | On G2 to G9 I want "S2 to S10" value from Attendace sheet
 |  |  | On H2 to H9 I want "E2 to E7" value from Commission sheet
Spreadsheet: 858668d1707277532-to-map-old-code-to-new-code-base-on-date-sum-if-lookup-with-date-criteria
Sheet: Sheet1

Code | Tag | WEF |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00
300500 | 7000 | 2000-01-01 00:00:00 |  | 300500 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 |  | 7000 | 50000 | 50000 | 50000
300500 | 8000 | 2024-02-29 00:00:00 |  | 300501 | 12500 | 12500 | 12500 | 11000 | 11000 | 11000 |  | 8000 |  |  |  | 50000 | 50000 | 50000
300501 | 5000 | 2000-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 5000 | 12500 | 12500
300501 | 5500 | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | 5500 |  |  | 12500 | 11000 | 11000 | 11000
 |  |  |  | This is my Old Mapping |  |  |  |  |  |  |  | This is new Mapping
 |  |  |  |  |  |  |  |  |  |  |  | * How do I pas on A:C and do up M:S base on E:K?
 |  |  |  |  |  |  |  |  |  |  |  | Column A is Old Mapping
 |  |  |  |  |  |  |  |  |  |  |  | Column B is New Tagging
 |  |  |  |  |  |  |  |  |  |  |  | Column C is when the New Tagging take place
Spreadsheet: 795590d1662769410-calculate-average-but-exclude-weekend-and-public-holiday-book1
Sheet: Cal

 | May | Day | Total
 | 2022-05-01 00:00:00 |  | 5 |  |  | Date | Day | Holiday
 |  |  | 4 |  |  | 2022-01-01 00:00:00 | Saturday | New Year’s Day
 |  |  | 5 |  |  | 2022-02-01 00:00:00 | Tuesday | Chinese New Year
 |  |  | 4 |  |  | 2022-02-02 00:00:00 | Wednesday | Chinese New Year
 |  |  | 5 |  |  | 2022-04-15 00:00:00 | Friday | Good Friday
 |  |  | 6 |  |  | 2022-05-01 00:00:00 | Sunday | Labour Day
 |  |  | 7 |  |  | 2022-05-03 00:00:00 | Tuesday | [NAME]
 |  |  | 8 |  |  | 2022-05-15 00:00:00 | Sunday | [NAME]
 |  |  | 3 |  |  | 2022-07-10 00:00:00 | Sunday | [NAME]
 |  |  | 5 |  |  | 2022-10-24 00:00:00 | Monday | Deepavali
 |  |  | 6 |  |  | 2022-12-25 00:00:00 | Sunday | Christmas Day
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 3
 |  |  | 6
 |  |  | 8
 |  |  | 3
 |  |  | 6
 |  |  | 9
 |  |  | 5
 |  |  | 1
 |  |  | 4
 |  |  | 6
 |  |  | 7
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 5
 |  |  | 7
 |  |  | 8
 | Ave/mth
 |  |  |  |  |  |  | \
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: JUN

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1
 |  |  |  |  |  | 1 |  | 1 |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | 26
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  | 19 |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Entering '1' in the relevant row/column represents 0.5 of a day
Spreadsheet: 277786d1384434934-calculated-field-in-pivot-table-need-to-calculate-again-excel-forum
Sheet: Sheet3

Data
Branch | Account | Sales |  |  |  |  |  |  | Values
Branch-1 | Account-1 | 123135.38 |  |  |  |  | Branch | Account | Sum of Sales | %OF Total | Column-K*1000
Branch-1 | Account-2 | 71883.44 |  |  |  |  | Branch-1 | Account-1 | 123135.38 | 0.1032676428136941
Branch-1 | Account-3 | 65286.15 |  |  |  |  |  | Account-10 | 42063.61 | 0.03527669994549522
Branch-1 | Account-4 | 65250.36 |  |  |  |  |  | Account-11 | 36461.63 | 0.03057859230421894
Branch-1 | Account-5 | 55262.02 |  |  |  |  |  | Account-2 | 71883.44 | 0.06028513824491071
Branch-1 | Account-6 | 52525.05 |  |  |  |  |  | Account-3 | 65286.15 | 0.05475231260813308
Branch-1 | Account-7 | 51238.99 |  |  |  |  |  | Account-4 | 65250.36 | 0.0547222972791813
Branch-1 | Account-8 | 49003.63 |  |  |  |  |  | Account-5 | 55262.02 | 0.04634556325341442
Branch-1 | Account-9 | 43591.33 |  |  |  |  |  | Account-6 | 52525.05 | 0.04405019988707896
Branch-1 | Account-10 | 42063.61 |  |  |  |  |  | Account-7 | 51238.99 | 0.04297164403483747
Branch-1 | Account-11 | 36461.63 |  |  |  |  |  | Account-8 | 49003.63 | 0.04109695653202537
Branch-2 | Account-12 | 130307.39 |  |  |  |  |  | Account-9 | 43591.33 | 0.03655792426363463
Branch-2 | Account-13 | 42742.13 |  |  |  |  | Branch-1 Total |  | 655701.59 | 0.5499049711666242
Branch-3 | Account-14 | 111348.01 |  |  |  |  | Branch-2 | Account-12 | 130307.39 | 0.1092824581083417
Branch-3 | Account-15 | 53083.56 |  |  |  |  |  | Account-13 | 42742.13 | 0.03584574160518675
Branch-3 | [NAME] | 52896.26 |  |  |  |  | Branch-2 Total |  | 173049.52 | 0.1451281997135285
Branch-3 | Account-17 | 50306.96 |  |  |  |  | Branch-3 | Account-14 | 111348.01 | 0.09338214999373569
Branch-3 | Account-18 | 48163.37 |  |  |  |  |  | Account-15 | 53083.56 | 0.0445185950078629
Branch-4 | Account-19 | 47841.46 |  |  |  |  |  | [NAME] | 52896.26 | 0.04436151562499987
 |  |  |  |  |  |  |  | Account-17 | 50306.96 | 0.04218999589169902
 |  |  |  |  |  |  |  | Account-18 | 48163.37 | 0.04039227141593092
 |  |  |  |  |  |  | Branch-3 Total |  | 315798.16 | 0.2648445279342284
 |  |  |  |  |  |  | Branch-4 | Account-19 | 47841.46 | 0.04012230118561892
 |  |  |  |  |  |  | Branch-4 Total |  | 47841.46 | 0.04012230118561892
 |  |  |  |  |  |  | Grand Total |  | 1192390.73 | 1
 |  | What I want?
 |  | Is it possible to do Pivot calclulation of Highlighted RED column-L? (I Just want to Multiply Column-K with 1000)
 |  | 1.I have done Outside of Pivot - But I want this in Pivot table.
 |  | 2.This is Just sample of Data
Spreadsheet: tracy_geaccone__40514__EGS Q3-2001 Accounting Request
Sheet: India

Details of NBV for India
 |  |  | DPCOPS4
Details/Project |  | India | DPC I & II | [NAME] (69F)
Equity |  |  | 598491256 | -26830493
CTA |  |  | 0 | 0
OCI |  |  | 898000
Net I/C (Rec)/Pay
Net NBV - India
Excess Costs |  |  |  | 0
Loans to JV |  |  | 0 | 0
Mobilized/Trapped Cash |  |  | 0 | 0
 |  |  | Use May number for DPC
May NBV |  |  | 848931000 | 69890000
Spreadsheet: 098e3266-ca79-48f1-b28a-a1813574fa84
Sheet: Domestic and International

Federal Agency USPS Domestic and International Expenditure
 | Agency Name | Domestic Expenditure | International Expenditure
1 | Department of Agriculture | 15586882 | 597255
2 | Department of Commerce | 27019059 | 1039511
3 | Department of Defense | 68798329 | 537170
4 | Department of Education | 2543398 | 0
5 | Department of Energy | 6668738 | 787256
6 | Department of Homeland Security | 79376854 | 2240329
7 | Department of Housing and Urban Development | 1928388 | 0
8 | Department of Justice | 25447616 | 1653463
9 | Department of Labor | 11872327 | 0
10 | Department of State | 70310212 | 0
11 | Department of the Interior | 6286084 | 287884
12 | Department of the Treasury | 290380861 | 500000
13 | Department of Transportation | 8843496 | 697968
14 | Department of Veterans Affairs | 250601733 | 49864
15 | Environmental Protection Agency | 1965204 | 64395
16 | Equal Employment Opportunity Commission | 1001013 | 0
17 | Federal Deposit Insurance Corporation | 1783648 | 0
18 | General Services Administration | 9978153 | 289867
19 | Government Printing Office | 5402322 | 0
20 | Health and Human Services | 57695384 | 650069
21 | National Aeronautics and Space Administration | 1376007 | 102959
22 | National Archives and Records Administration | 2527886 | 0
23 | Office of Personnel Management | 14098228 | 112303
24 | Railroad Retirement Board | 1302299 | 5373
25 | Selective Service System | 13035000 | 0
26 | Small Business Administration | 1514853 | 4434
27 | Social Security Administration | 213436706 | 1531979
28 | The Library of Congress | 1327198 | 196318
Total
Spreadsheet: 88a0822a-eafe-4938-9144-e6e958c4b0dc
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
12/20/2014 | Gymnastics | Central Michigan (Atlantis Crown Invitational, Paradise Island, Bahamas)
01/09/2015 | Gymnastics | at Maryland with [NAME] | 07:00 PM
01/17/2015 | Gymnastics | at Ohio State with Michigan | 04:00 PM
01/25/2015 | Gymnastics | Iowa State*, [NAME] | 02:00 PM
01/31/2015 | Gymnastics | at NC State | 07:00 PM
02/08/2015 | Gymnastics | at New Hampshire with [NAME] and [NAME] | 01:00 PM
02/13/2015 | Gymnastics | Denver | 07:00 PM
02/22/2015 | Gymnastics | New Hampshire, Maryland, Rutgers | 02:00 PM
02/28/2015 | Gymnastics | at Pitt with North Carolina and Temple | 07:00 PM
03/08/2015 | Gymnastics | Penn State | 02:00 PM
03/14/2015 | Gymnastics | Pennsylvania, Cornell | 04:00 PM
03/21/2015 | Gymnastics | Big 12 Gymnastics Championship (Norman, Okla.) | 05:00 PM
04/04/2015 | Gymnastics | NCAA Morgantown Regional Championships | 04:00 PM
04/16/2015 | Gymnastics | NCAA National Championships (Fort Worth, Texas)
Spreadsheet: 862751d1710398080-add-a-rank-column-based-on-multiple-criteria-sample
Sheet: Sheet1

id | name | Crit_A | Crit_B |  | EXPECTED OUTPUT | EXPLANATION
12047 | name A | 1 | 0.1 |  |  | <--- col C is less than 5, so nothing should show here. Also, col D is less than 20% so nothing should show
12610 | name B | 7 | 0.2 |  | 6
12330 | name C | 12 | 0.21 |  | 5
12375 | name D | 1 | 0.14 |  |  | <--- col C is less than 5, so nothing should show here
12554 | name E | 7 | 0.77 |  | 3
12596 | name F | 8 | 0.9 |  | 1
11909 | name G | 9 | 0.88 |  | 2
12505 | name H | 13 | 0.66 |  | 4
12325 | name I | 19 | 0.15 |  |  | <--- col C is greater than 5, but col D is less than 20% so nothing should show here
12999 | name J | 1 | 0.01 |  |  | <--- col C is less than 5, so nothing should show here
Spreadsheet: 735956d1623277038-index-of-terms-based-on-overlapping-dates-gantt-chart-utilizing-conditional-distinct-values-lilybickel-
Sheet: Sheet3

name | variable 1 | start date 1 | end date 1 | variable 2 | start date 2 | end date 2 | variable 3 | start date 3 | end date 3 | variable 4 | start date 4 | end date 4 | variable 5 | start date 5 | end date 5 |  | Variable 1 | Variable 2 | Variable 3 | Variable 4 | Variable 5
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00 | B | 2014-01-01 00:00:00 |  | C | 2015-01-01 00:00:00 |  | A | 2018-01-01 00:00:00 |  | E | 2020-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00 | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | E | 2019-01-01 00:00:00 |  | A | 2019-01-01 00:00:00
Name | Variable | Start Date | End Date
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00
name1 | B | 2014-01-01 00:00:00
name1 | C | 2015-01-01 00:00:00
name1 | A | 2018-01-01 00:00:00
name1 | E | 2020-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
[NAME] | E | 2019-01-01 00:00:00
[NAME] | A | 2019-01-01 00:00:00
Name | Variable | Start Date | End Date
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00
name1 | B | 2014-01-01 00:00:00
name1 | C | 2015-01-01 00:00:00
name1 | A | 2018-01-01 00:00:00
name1 | E | 2020-01-01 00:00:00
[NAME] | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | E | 2019-01-01 00:00:00
[NAME] | A | 2019-01-01 00:00:00
Name | Variable | Start Date | End Date | A | B | C | D | E | F | G | Variable | Combination
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00
name1 | B | 2014-01-01 00:00:00
name1 | C | 2015-01-01 00:00:00
name1 | A | 2018-01-01 00:00:00
name1 | E | 2020-01-01 00:00:00
[NAME] | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | G | 2016-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | E | 2019-01-01 00:00:00
[NAME] | A | 2019-01-01 00:00:00
Spreadsheet: 790837d1660024676-the-number-of-unique-values-in-a-matrix-number-of-unique-values-hd
Sheet: Sheet1

emphasis | garbage | mud | feedback | accident | method | lake | gene | addition | cheek | library | addition
suggestion | worker | depth | teaching | meat | relation | birthday | pie | tradition | lake | addition | setting
audience | depth | income | physics | wife | wife | guest | community | birthday | physics | medicine | intention
community | wife | variation | historian | chest | meat | wife | article |  | meat | guest | photo
outcome | method | birthday | garbage | mud | variation | scene | equipment | garbage | article | accident | feedback
coffee | depth | gene | birthday | depth | language | river | language | medicine | photo | intention | garbage
pie | depth | user | garbage | garbage | accident | tradition | teaching | bonus | photo | scene | variation
pie | scene | relation |  | outcome | feedback | historian | feedback | physics | mud | gene | sympathy
article | intention | meat | language | addition | article | article | worker | equipment | user | marketing | wife
accident | marketing | tradition | chest | river | method | scene | chest | pie | sympathy | series | outcome
tradition | pie | bonus | birthday | teaching | disease | coffee | variation | photo | cheek | intention | guest
variation | sympathy | scene | feedback | worker | series | gene | lake | coffee | equipment | feedback | pie
#[NAME] values in A1:L12
 | please add other solutions, preferably simpler ones
Spreadsheet: 713025d1610533033-random-allocation-require-to-be-based-on-few-criteria-sample
Sheet: List of operatives working 

Worker | Packing | Putting
[NAME] | Y | Y
[NAME] | Y | Y
[NAME] | Y | N
[NAME] | Y | N
[NAME] One | Y | N
[NAME] | N | Y
Spreadsheet: 2eff087b-6164-4c72-b611-12e7fc61e556
Sheet: Sheet1

#17111 8" Ductile Iron Pipe #0510-3119 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
rev 8/11/03 ecb
 | Hughes Supply | Natl Wworks | Ferguson | Mtn States | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Price per section | 192.42 | 225 | 215.94 | 192.42 | 209.44
# of sections | 100 | 100 | 100 | 100 | 100
Total | 19242 | 22500 | 21594 | 19242 | 20944
Length of section | 18' | 20' | 20' | 18' | 20'
Price per foot | 10.69 | 11.25 | 10.797 | 10.69 | 10.472
Brand bid |  |  | American |  | American
Met specs? |  |  | Yes |  | Yes
Delivery |  |  |  |  | By 8/18
Spreadsheet: 831113d1685431620-how-to-use-the-minimum-or-equal-to-50-recursive-subtraction-5-30-aligw
Sheet: Sheet1

 |  |  |  |  |  | RESULT
A | 89 |  |  | 50 |  | A | 50
B | 72 |  | A | 39 |  | A | 39
C | 15 |  | B | 50 |  | B | 50
D | 21 |  | B | 22 |  | B | 22
E | 46 |  | C | 15 |  | C | 15
 |  |  | D | 21 |  | D | 21
 |  |  | E | 46 |  | E | 46
Spreadsheet: 701751d1603908368-how-to-track-production-target-date-job-work-production-tracking-akshay6s-
Sheet: Sheet2

MONTH | DAY | QUALITY | PRODUCTION |  | JANUARY
JANURAY | 1 | FLEUR | 50 |  | FEBRUARY
JANURAY | 2 | FLEUR | 20 |  | [NAME]
JANURAY | 3 | BASKET | 10 |  | APRIL
JANURAY | 4 | BASKET | 40 |  | MAY
JANURAY | 5 | DIAMOND | 50 |  | [NAME]
JANURAY | 6 | DIAMOND | 60 |  | JULY
JANURAY | 7 | DIAMOND | 200 |  | AUGUST
JANURAY | 8 |  |  |  | SEPTEMBER
JANURAY | 9 |  |  |  | OCTOBER
JANURAY | 10 |  |  |  | NOVEMBER
JANURAY | 11 |  |  |  | DECEMBER
JANURAY | 12
JANURAY | 13
JANURAY | 14
JANURAY | 15
JANURAY | 16
JANURAY | 17
JANURAY | 18
JANURAY | 19
JANURAY | 20
JANURAY | 21
JANURAY | 22
JANURAY | 23
JANURAY | 24
JANURAY | 25
JANURAY | 26
JANURAY | 27
JANURAY | 28
JANURAY | 29
JANURAY | 30
JANURAY | 31
Spreadsheet: 764873d1643046468-lookup-that-returns-vertical-array-in-horizontal-format-catalog-sample
Sheet: original data

Title & Author | Catkey | Barcode | IC2
Adventures of [NAME] Twain Mark 1835-1910 | 439090 | 31927001658027 | CHILD
Adventures of [NAME] Twain Mark 1835-1910 | 439090 | 37695000113617 | CHILD
Adventures of [NAME] Twain Mark 1835-1910 | 1270450 | 31449005011558 | [NAME]
Adventures of [NAME] Twain Mark 1835-1910 | 1270450 | 33701003175480 | ADULT
Adventures of [NAME] Twain Mark 1835-1910 | 53368 | 31927000814845 | ADULT
Adventures of [NAME] Twain Mark 1835-1910 | 189355 | 32793000239220 | [NAME]
Adventures of [NAME] Twain Mark 1835-1910 | 194137 | 31474001018803 | ADULT
Spreadsheet: 463561d1464637960-summary-sheet-for-drawings-log-with-multiple-revisons-drawing-log-chg1
Sheet: Summary

SHOP DRAWINGS - STATUS REPORT
Status as of
DISCIPLINE |  |  | TOTAL NO. OF DRAWINGS | APPROVAL STATUS |  |  | AWAITING APPROVAL
 |  |  |  | A | B | C | RECENT | OVERDUE | Remarks
Total Drawings
Strctural
Architectural
MECHANICAL Shop Drawings
ELECTRICAL Shop Drawings
TOTAL