tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 735485d1623029372-how-to-automate-capturing-the-cell-references-optimise
Sheet: Sheet1

 | DATA 1
 | 78 | 21 | 81 | 92
 | 7 | 68 | 89 | 82
 | 75 | 55 | 14 | 31
 | 16 | 78 | 65 | 73
 | 98 | 10 | 53 | 65
 | 47 | 98 | 96 | 67
 | 40 | 9 | 94 | 27
 | 61 | 62 | 24 | 50
 | 80 | 85 | 46 | 11
 | 17 | 96 | 36 | 54
 | 7 | 80 | 50 | 39
 | 62 | 87 | 83 | 17
 | 18 | 75 | 27 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | 86 | 52 | 3 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 31 | 51 | 70 | 85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 97 | 65 | 88 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 20 | 47 | 28 | 75
 | 59 | 50 | 92 | 75
 | 77 | 40 | 89 | 65
 | 78 | 73 | 79 | 24
 | 92 | 27 | 50 | 63
 | 70 | 93 | 48 | 54
 | 19 | 16 | 56 | 33
 | 83 | 18 | 9 | 8
 | 91 | 47 | 61 | 66
 | 44 | 59 | 51 | 5
 | 66 | 47 | 53 | 57
 | 76 | 32 | 59 | 95
 | 3 | 8 | 91 | 92
 | 79 | 95 | 49 | 77
 | 25 | 9 | 64 | 22
 | 97 | 99 | 13 | 81
 | 37 | 2 | 73 | 2
 | 55 | 54 | 15 | 29
 | 65 | 11 | 39 | 89
 | 2 | 30 | 38 | 58
 | 27 | 68 | 47 | 63
 | 71 | 12 | 37 | 99
 | 5 | 61 | 6 | 8
 | 11 | 82 | 61 | 58
 | 86 | 64 | 31 | 81
 | 83 | 70 | 46 | 42
 | 42 | 95 | 78 | 48
 | 83 | 72 | 50 | 47 |  | Want to automate listing down the cell references of the DATA 1 top 10% values in the yellow row below.
 | 53 | 6 | 74 | 70 |  | DATA 1 values will change and cell references to be updated.
 | 50 | 74 | 32 | 84
 | 65 | 32 | 67 | 84 |  |  |  |  |  |  |  |  | etc | etc
 |  |  |  |  |  | i.e., =B6 | =B17
 |  |  |  |  |  | Need the cell references, not the cell values
Spreadsheet: 41715d1240257409-finding-highest-value-in-a-week-from-daily-data-test
Sheet: Rollover Month

Date | Month | High | Low | Pit Close | Glx Close |  | 3D High | 3D Low | Prev Close | 3DUp Basic Calculation | 3DUp Basic Calculation | 25 [NAME]
2009-03-04 00:00:00 | J09 | 4576 | 4104 | 4538 | 4549
2009-03-03 00:00:00 | J09 | 4207 | 3944 | 4165 | 4150
2009-03-02 00:00:00 | J09 | 4449 | 3984 | 4015 | 3997
2009-02-27 00:00:00 | J09 | 4491 | 4255 | 4476 | 4412
2009-02-26 00:00:00 | J09 | 4530 | 4227 | 4522 | 4472
2009-02-25 00:00:00 | J09 | 4283 | 3940 | 4250 | 4231
2009-02-24 00:00:00 | J09 | 4013 | 3765 | 3996 | 3994
2009-02-23 00:00:00 | J09 | 4149 | 3787 | 3844 | 3800
2009-02-20 00:00:00 | J09 | 4013 | 3754 | 4003 | 3980
2009-02-19 00:00:00 | J09 | 4027 | 3712 | 4018 | 3959
2009-02-18 00:00:00 | J09 | 3895 | 3722 | 3741 | 3752
2009-02-17 00:00:00 | J09 | 4170 | 3801 | 3854 | 3819
2009-02-16 00:00:00 | J09 | 4272 | 4098 | 4159 | 4159
2009-02-13 00:00:00 | J09 | 4289 | 4134 | 4197 | 4210
Spreadsheet: paul_y'barbo__28502__Margin Projections
Sheet: FLASH99

ProCaribe
Division of The Protane Corporation |  |  |  | LPG/C Victoire pricing calculation
Description |  |  | May | June | July
Revenue
COS
Gross Margin
LPG Volume
LPG - Selling Price
LPG - Margin
 |  |  | ASSUMPTIONS
LPG- Sales (Volume) |  |  | May | June | July
ProGas Co. |  |  | 1100 | 1100 | 1100
San Juan Gas |  |  | 210 | 210 | 210
Empire Gas |  |  | 0 | 0 | 0
Centro Gas |  |  | 130 | 130 | 130
Total LPG-Propane (Gallons)
Selling Price
ProGas Co.
San Juan Gas
Empire Gas |  |  | 0 | 0 | 0
Centro Gas
Mont Belvieu |  |  | 0.515 | 0.515 | 0.5175
Premium
ProGas Co. |  |  | 0.12 | 0.12 | 0.12
San Juan Gas |  |  | 0.13 | 0.13 | 0.13
Empire Gas |  |  | 0 | 0 | 0
Centro Gas |  |  | 0.18 | 0.18 | 0.18
Import Tax ($4.00/barrel) |  |  | 0.09523809523809523 | 0.09523809523809523 | 0.09523809523809523
Revenue Calculation ($ USD) |  |  | May | June | July
[NAME]
San Juan Gas
Empire Gas
Centro Gas
Total Revenue (US$)
Cost Calculation |  |  | Gallons | Cost | Amount
Beginning Balance as of 4-27-01 |  |  | 795789 |  | 566934
Borrowing
Reversing (April/01) |  |  | -1045120 | -0.70524 | -737060
Return |  |  | 1045120 | 0.67127
Vessel Recived
LPG/C Victoire |  |  | 5291620 |  | 3552123.99
Average Cost of Sales
Total COS
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 12c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending November 23, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 192154d1352321091-data-from-multiple-columns-when-using-large-book2
Sheet: Sheet2

 |  | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 |  |  | Highest | Date
 | [NAME] | 68025 | 67170 | 78799 | 69777 |  | [NAME] |  | 2012-09-10 00:00:00
 | [NAME] | 174433 | 156675 | 169796 | 154421 |  | [NAME] |  | 2012-09-08 00:00:00
 | George | 40122 | 46895 | 34377 | 26600 |  | George |  | 2012-09-09 00:00:00
 | Ringo | 78530 | 83452 | 109523 | 93998 |  | Ringo |  | 2012-09-10 00:00:00
Spreadsheet: 110034d1306837236-how-to-sum-categeory-wise-copy-of-test_budget
Sheet: Daily_Spendings

Sr.N | Month | Date | Details | Catageory | Amount
1 | 2011-01-01 00:00:00 | 2011-01-05 00:00:00 | Petrol | TRANSPORTATION | 500
2 | 2011-01-01 00:00:00 | 2011-01-10 00:00:00 | Gas Car | TRANSPORTATION | 1000
3 | 2011-01-01 00:00:00 | 2011-01-15 00:00:00 | Gas Cylender | HOME | 300
4 | 2011-01-01 00:00:00 | 2011-01-21 00:00:00 | College Bus | TRANSPORTATION | 500
5 | 2011-02-01 00:00:00 | 2011-02-05 00:00:00 | House Rent | HOME | 4500
6 | 2011-02-01 00:00:00 | 2011-02-05 00:00:00 | Petrol | TRANSPORTATION | 500
7 | 2011-02-01 00:00:00 | 2011-02-10 00:00:00 | Gas Car | TRANSPORTATION | 1000
8 | 2011-02-01 00:00:00 | 2011-02-15 00:00:00 | Gas Cylender | HOME | 300
9 | 2011-03-01 00:00:00 | 2011-03-21 00:00:00 | College Bus | TRANSPORTATION | 500
10 | 2011-03-01 00:00:00 | 2011-03-05 00:00:00 | House Rent | HOME | 4500
 |  |  | University/TAFE fees | EDUCATION | 5000
 |  |  | Transportation | EDUCATION | 2000
 |  |  | School fees | EDUCATION | 1000
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
Spreadsheet: 0d32323d-9dfb-456c-9b0b-b6c781ed4549
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
the United States, 2010-2011
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate  International Students | Graduate  International Students | Non-degree-seeking International Students | Optional Practical Training
#1 | China | 157558 | 56976 | 76830 | 10484 | 13268
#2 | India | 103895 | 14004 | 63624 | 1602 | 24665
#3 | South Korea | 73351 | 37944 | 22486 | 6895 | 6026
#4 | Canada | 27546 | 13154 | 11618 | 570 | 2204
#5 | Taiwan | 24818 | 5994 | 13269 | 1818 | 3737
#6 | Saudi Arabia | 22704 | 10946 | 4604 | 6772 | 382
#7 | Japan | 21290 | 10544 | 4650 | 4276 | 1820
#8 | Vietnam | 14888 | 11054 | 2420 | 894 | 520
#9 | Mexico | 13713 | 8163 | 3908 | 903 | 739
#10 | Turkey | 12184 | 3532 | 6435 | 1024 | 1193
Total of All Places of Origin | Total | 723227 | 291439 | 296574 | 59233 | 76031
Source:  Institute of International Education. (2011). Open Doors Report on International Educational Exchange.
Spreadsheet: 197a2932-1e20-4d13-a8ff-10e74180c9ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 12A. Average Weekly Earnings, New South Wales (Dollars) - Seasonally Adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761471J | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761474R | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761480K | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761472K | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761475T | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761481L | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761473L | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761476V | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  New South Wales ; |  |  | Seasonally Adjusted | A2761482R | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 788528d1658510675-text-doesnt-wrap-up-as-intended-in-the-cells-containing-copied-formula-2022-07-22-oeldere-jigneshbharati-formula-formatting-problem
Sheet: Sheet1

Age | Prescribed medicine | Theoretical dose | Prescribed dose | Correct dose | Under-dosed | Over-dosed
67 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
70 | Dabigatran 150mg cap
87 | Dabigatran 150mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
69 | Dabigatran 150mg cap
Spreadsheet: 7e51f3ed-1b9e-4df9-b27f-380aa43be3fb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8610 | 57001 | [NAME] | Santos | BRA | 0 | 00:08:16 | 00:00:00 | 00:16:41 | 00:00:00 | 00:09:44 | 1 | 00:34:45
8610 | 43088 | Fred | Lima | BRA | 0 | 00:08:23 | 00:00:00 | 00:17:03 | 00:00:00 | 00:09:36 | 2 | 00:35:02
8610 | 33644 | Diego | [NAME] | BRA | 0 | 00:09:08 | 00:00:00 | [NAME] | 00:00:00 | 00:10:34 | 3 | 00:37:17
8610 | 51303 | Marcelo | De Almeida | BRA | 0 | 00:09:25 | 00:00:00 | 00:18:10 | 00:00:00 | 00:10:22 | 4 | 00:37:59
Spreadsheet: 703765d1605167650-use-formulas-to-show-visibility-of-employees-shift-visibility-test
Sheet: Shift

2020-11-11 00:00:00 |  |  | Trained |  |  | Needed for Option 1.
Employee | Shift |  | D/E | Sales | A/S
[NAME] | 09:00-17:00 |  | x | x
Sophie | 12:00-20:00 |  | x | x
Janice | 09:00-17:00 |  | x
[NAME] | 12:00-20:00 |  | x |  | x
[NAME] |  |  | x |  | x
[NAME] |  |  | x | x | x
[NAME] | 09:00-17:00 |  | x |  | x
Spreadsheet: 853743d1703697668-formula-in-power-pivot-asking-for-pwrpvt-help
Sheet: Check

TOTALS CHECK |  |  |  |  |  |  |  | use these pivots to check for errors
 | Passes | Errors |  |  |  |  |  | MARPasses |  |  |  | Errors
Residential |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Total Errors
Apartments |  |  |  |  |  |  |  | stillActive | All |  |  | Apartments
DayPrograms |  |  |  |  |  |  |  |  |  |  |  | House CC | 1
Total |  |  |  |  |  |  |  | Row Labels | Count of PassID |  |  | Day
 |  |  |  |  |  |  |  | Administered | 960 |  |  | Day Program | 2
 |  |  |  |  |  |  |  | Grand Total | 960 |  |  | Residential
Should be | 960 | 9 |  |  |  |  |  |  |  |  |  | House AAA | 6
Difference |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 9
Spreadsheet: 967a430d-6b12-435b-b47f-22ae325f5743
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6759 | 51488 | [NAME] | Chauvin | USA | 0 | 00:28:48 | 00:03:10 | 03:22:12 | 00:02:13 | 01:58:42 | 1 | 05:55:07
Spreadsheet: 23812d1213613965-timeline-sample
Sheet: template

 |  |  | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00
 |  | AfterCallWork
 |  | CallConsult
 |  | CallInbound
 |  | CallOnHold
 |  | CallOutbound
 |  | LoggedOut
 |  | NotReadyForNextCall
 |  | WaitForNextCall
Spreadsheet: 03bf0f68-372f-4540-82d4-ebbe63becbab
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Enter District Number:
District Name
CALCULATION ELEMENTS | DISTRICT | Charter School Totals |  | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL | CHARTER SCHOOL
Funded Pupil Count |  | 0
Less: Charter School Count | 0
District Adjusted Pupil Count
Total Formula Per Pupil Funding
At-risk Pupil Count |  | 0
Total At-Risk Funding
District Per Pupil At-Risk Funding
K-12 Membership |  | 0
Percentage of Pupils Eligible for Free Lunch (At-risk Pupil Count divided by K-12 Membership)
Adjusted At-risk Per Pupil Funding
Total Program Funding
Negative Factor Total/Per Pupil
Revised Total Program Funding
District Per-Pupil Revenue
Minimum Floor Funding
Adjusted Charter Per-Pupil Revenue
Charter Per-Pupil Revenue (greater of floor or adjusted)
Adjusted District Per-Pupil Revenue
Charter Total Program (Adjusted)
Charter Total Program (Unadjusted)
At-risk Funding to (from) Charter
TOTAL PROGRAM
Instructions:
Step 1 - Enter district number
Step 2 - Enter charter school fields indicated by yellow highlight.
Spreadsheet: 798395d1664461251-sumif-values-based-on-lookup-date-example-data-copy-2-copy
Sheet: Sheet1

 |  | Start Date | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00 |  |  | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | … | 2024-04-01 00:00:00
Employee A | Department A | 2022-12-01 00:00:00 | 50000
Employee B | Department B | 2022-11-01 00:00:00 | 75000 |  |  |  | Target Total Answer
Employee C | Department A | 2023-05-01 00:00:00 | 60000 |  |  |  | Target Deparment A Answer
 |  |  |  |  |  |  | Target Deparment B Answer
Spreadsheet: 39116d1237319442-hyperlink-generator-hyperlink-question
Sheet: Blad1

Project number | Sheetname | Hyperlink
P0001 | Accounting | GO
P0002 | Building | GO
P0003 | [NAME] | GO
P0004 | Timeplan | GO
P0005 | Timeplan | GO
P0006 | [NAME] | GO
P0007 | Timeplan | GO
P0008 | [NAME] | GO
Spreadsheet: 285809d1387861242-need-all-sheet-to-be-change-if-i-change-the-master-sample10
Sheet: Bevrages

Item Number | Item Description | Packing | Brand | Category | Total
SOLMTEORIG | SOL MATE ORIGINAL | 12x330 ml | SOL MATE | BEVRAGES | 3141
SOLMTELIME | SOL MATE LEMON/LIME | 12x330 ml | SOL MATE | BEVRAGES | 3140.92
MINTAORIG | MINTA ORIGINAL | 1 CR X 24 UNITS | MINTA | BEVRAGES | 2458.12
WHYNATTE01 | WHYNATTE LATTE | 24x240ml | WHYNATTE | BEVRAGES | 1910.67
GIZESPARK2 | GIZE SPARKLING 200ML | 12x200 ml | GIZE | BEVRAGES | 697.83
GIZE200ML | GIZE STILL 200 ML | 12x200 ml | GIZE | BEVRAGES | 695.67
WHYNATTE02 | WHYNATTE LATTE 6 BOXES 4 UNITS | 1 CR X 6BX X 4UN | WHYNATTE | BEVRAGES | 640
GIZE750ML | GIZE STILL 750 ML | 6x750 ml | GIZE | BEVRAGES | 468.83
GIZESPARK7 | GIZE SPARKLING 750 ML | 6x750 ml | GIZE | BEVRAGES | 352.83
GIZERAS200 | GIZE RASPBERRY GINSENG 200 ML | 12x200 ml | GIZE | BEVRAGES | 173.84
GIZEPV200 | GIZE PEAR - VINEGAR 200 ML | 12x200 ml | GIZE | BEVRAGES | 173.75
GIZEPAC200 | GIZE PINEAPPLE COCONUT 200 ML | 12x200 ml | GIZE | BEVRAGES | 172.58
GIZEPV750 | GIZE PEAR - VINEGAR 750 ML | 6x750 ml | GIZE | BEVRAGES | 120.67
GIZERAS750 | GIZE RASPBERRY GINSENG 750 ML | 6x750 ml | GIZE | BEVRAGES | 120.67
GIZEPAC750 | GIZE PINEAPPLE COCONUT 750 ML | 6x750 ml | GIZE | BEVRAGES | 120.5
 |  |  |  | Total | 14387.88
Spreadsheet: 863273d1710834127-combining-two-dates-formula-using-if-condition-combining-two-formula-using-if-condition-1-aligw
Sheet: Sheet1

General format (by default all the below are in DD/MM/YYYY) | Rremove '/' | [NAME] |  | [NAME] to MM/DD/YYYY
22/06/2026
4/10/2026
8/9/2026
18/9/2026
 |  |  |  | Q: How do I combine D4 and D6 formulas in E4
Spreadsheet: 707320d1607178794-drop-down-list-selection-based-on-column-title-selection-template-ans
Sheet: Passive Fire

Status |  |  | Service | Type | Description |  |  | Structure |  | Sticker | Passive Fire Treatment |  |  | Picture 1 | Picture 2
Inspected | Compliance | Non-Compliance |  |  | Level | Area | ID | Wall/ Slab | Type |  | Manufacturer | Product | Aplication
YES | NOT COMPLIANT | Not A Tested System | Fire | Hydraulic | Basement | Garbage Room | FDB.1 | Slab | Speedpanel | Not Compliant | BOSS Fire
Spreadsheet: 845060d1696607468-how-to-add-a-percentage-based-on-the-result-of-a-cell-hotel
Sheet: Clients

[NAME] | Prénom | Direct ou Booking | Gite No. | Date d'arriver | Date de départ | Duration | Prix par jour | Prix de séjour | No. d'adultes | No. d'enfants | Ménage? | Serviettes? | Taux de taxe | Taxe a payé | Total Prix de Séjour | Acompte 1 | BACS, Chèque, Espèces | Acompte 2 | BACS, Chèque, Espèces | Total à payer
Rojas | Sébastien | Direct | 12 | 2024-01-01 00:00:00 | 2024-01-10 00:00:00 |  |  |  | 2 | 1 | 30 |  | 1 |  |  | 118 | BACS
Peace | Iain | Booking | 1 | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 |  |  |  | 2 | 1 | 30 |  | 1 |  |  | 118 | BACS
Spreadsheet: 84290d1284341953-excel-2007-display-result-from-combination-of-two-dropdown-lists-sample
Sheet: Sheet2

[NAME] | [NAME]
 | 3 mm | 4 mm | 5 mm | 6 mm | 7 mm | 8 mm | 9 mm | 10 mm | 11 mm | 12 mm | 13 mm | 14 mm | 15 mm | 16 mm | 17 mm | 18 mm | 19 mm | 20 mm | 21 mm | 22 mm | 23 mm | 24 mm | 25 mm | 26 mm | 27 mm | 28 mm | 29 mm | 30 [NAME] | 31 mm | 32 [NAME] | 33 mm | 34 [NAME] | 35 mm | 36 [NAME] | 37 [NAME] | 38 [NAME] | 39 mm
6 mm | 0.5 | 0.75 | 0.85 | 1 | 1.2 | 1.3 | 1.5
7 mm | 0.75 | 0.85 | 1 | 1.25 | 1.3 | 1.5 | 1.75
8 mm | 1 | 1.25 | 1.3 | 1.35 | 1.6 | 1.8 | 1.85
9 mm | 1.25 | 1.36 | 1.58 | 1.9 | 2 | 2.25 | 2.35
10 mm
11 mm
12 mm
13 mm
14 mm
15 mm
16 mm
17 mm
18 mm
19 mm
20 mm
21 mm
22 mm
23 mm
24 mm
25 mm
26 mm
27 mm
28 mm
29 mm
30 [NAME]
31 mm
32 [NAME]
33 mm
34 [NAME]
Spreadsheet: 644876d1570792239-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis-1-
Sheet: Input &required output

OID | Quote_Weight | Distance(In Miles) | Cost -output required without fuel surcharge | Cost Output -with fuel surcharge
3634 | 138 | 74.666448
3676 | 368 | 1052.471069
3718 | 270 | 732.056664
3760 | 213 | 279.1653
3802 | 10 | 1512
3886 | 400 | 2142.846402
3928 | 333 | 2551
Spreadsheet: 736372d1623562383-sum-formula-cell-error-formatting-sum-formula-error
Sheet: Sheet3

Date | [NAME] | Name | Total Amount | Receipt | Cash Receipt | Bank Deposit | Total Due
2021-04-01 00:00:00 | 1 | Kasthuri Enterprises | 566 | 600
2021-04-01 00:00:00 | 2 | Algreen Cottage Industries | 1523 | 1550
2021-04-01 00:00:00 | 3 | Murugesan | 972 | 972
2021-04-01 00:00:00 | 4 | MRK Cottage Industries | 912 | 912
2021-04-01 00:00:00 | 5 | Jahir, Natchiyarkoil | 370 | 370
2021-04-01 00:00:00 |  | Saravana Food Product | 0 |  |  | 25000
2021-04-02 00:00:00 | 6 | Amman Aqua Products | 16500
2021-04-02 00:00:00 | 7 | [NAME], Sakkottai | 486.0000000000001 | 485
2021-04-02 00:00:00 | 8 | Saravanan AG | 2515 | 2550
2021-04-02 00:00:00 | 9 | SAV Traders | 1037 | 1037
2021-04-02 00:00:00 | 10 | Algreen Cottage Industries | 5202 | 5000
2021-04-02 00:00:00 | 11 | [NAME] | 300 | 300
2021-04-02 00:00:00 | D1 | [NAME], Kumbakonam | 392 | 362
2021-04-03 00:00:00 | 12 | [NAME], Kumbakonam | 5863.000000000001
2021-04-03 00:00:00 | 13 | Gnanasekaran, Sathish Kumar Oil Mill | 792.0000000000001 | 792
2021-04-03 00:00:00 | 14 | Sowra Plastic | 26301
2021-04-03 00:00:00 | 15 | Sowra Plastic | 24662 | 15000 |  | 10000
2021-04-03 00:00:00 | 16 | [NAME] | 200 | 200
2021-04-03 00:00:00 | D3 | Local Sales | 100 | 100
2021-04-03 00:00:00 | D4 | Local Sales | 100 | 100
2021-04-03 00:00:00 | 17 | Saravanan, Thukkachi | 871.0000000000002 | 870
2021-04-03 00:00:00 | 18 | Algreen Cottage Industries | 454 | 550
2021-04-03 00:00:00 | 19 | Mangalambigai Traders | 3696 |  |  | 3190
2021-04-03 00:00:00 |  | [NAME], [NAME] | 0 |  |  | 30000
2021-04-04 00:00:00 | 20 | PS Sweets, Trichy | 31405 | 31405
 |  | Kings Badam Milk | 637.9999999999999 |  | 638
 |  | KKR Marachekku | 944.9999999999999 | 945
 |  | Purusothaman | 879.9999999999999 | 880
Spreadsheet: 862921d1710491702-increasing-by-a-percentage-based-on-a-dynamic-spread-sample-budget-worksheet
Sheet: Sheet1

Yearly Revenue Increase | 0.04
Monthly Increase
 |  |  |  |  |  |  |  | 0.01
 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
Yearly Revenue | 100500
Spreadsheet: 598331d1542378954-smallest-value-for-conditions-example
Sheet: not working!

Country | Location | Colour | Value |  | Class
poland | warsaw | blue apple | 0.2 |  | big
poland | poznan | blue apple | 0.4 |  | small
poland | warsaw | red apple | 0.1 |  | small
poland | poznan | blue apple | 0.3 |  | small
germany | xyz | blue apple | 0.5 |  | small | Provide Country: | poland
poland | poznan | blue apple | 0 | 0% should be not taken into consideration!! |  | Provide Colour | blue apple
 |  |  |  |  |  | Provide class: | small
 |  |  |  | Final result
Spreadsheet: 187838d1350592578-multiple-look-up-multile-lookup-bithurocks
Sheet: Data 2

Contracts | ID | Cust_Name
127650~[NAME] | 100-1 | A
17960-bbCD-123 | 200-2 | B
1244360-ZZRO~8792x3 | 100-1 | A
1895436-LLGT~90422vT | 100-1 | A
123960-KbLM-12x3 | 300-3 | C
1244360-ZZRO~872x3 | 100-1 | A
196780-nuLM-2Yx3 | 300-3 | C
1560-Nys-123 | 405-9 | D
123960-KbLM-12x3 | 300-3 | C
1000-Sys-123 | 700-4 | E
Spreadsheet: 769797d1645690779-sequence-of-numbers-based-on-multiplicity-sourced-form-two-cells-book1
Sheet: Sheet1

1 | 3
2 | 2
3 | 1
4 | 7