tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766723d1644014663-what-if-scenario-manager-4-changing-columns-needed-in-summary-sheet-sales
Sheet: Scenario Summary

 | Scenario Summary
 |  |  | Current Values: | Sales | Growth | Numbers | As is
 |  |  |  | Created by [NAME] on 2/4/2022 | Created by [NAME] on 2/4/2022 | Created by [NAME] on 2/4/2022 | Created by [NAME] on 2/4/2022
 | Changing Cells:
 |  | $B$3 | 10000 | 10000 | 10000 | 10000 | 10000
 |  | $C$3 | 10001 | 10001 | 10001 | 10001 | 10001
 |  | $D$3 | 10002 | 10002 | 10002 | 10002 | 10002
 |  | $E$3 | 10003 | 10003 | 10003 | 10003 | 10003
 |  | $F$3 | 10004 | 10004 | 10004 | 10004 | 10004
 |  | $[NAME] | 10005 | 10005 | 10005 | 10005 | 10005
 |  | $H$3 | 10006 | 10006 | 10006 | 10006 | 10006
 |  | $I$3 | 10007 | 10007 | 10007 | 10007 | 10007
 |  | $J$3 | 10008 | 10008 | 10008 | 10008 | 10008
 |  | $[NAME] | 10009 | 10009 | 10009 | 10009 | 10009
 |  | $B$4 | NO | NO | NO | NO | NO
 |  | $C$4 | NO | NO | NO | NO | NO
 |  | $D$4 | NO | NO | NO | NO | NO
 |  | $E$4 | NO | NO | NO | NO | NO
 |  | $F$4 | NO | NO | NO | NO | NO
 |  | $G$4 | NO | NO | NO | NO | NO
 |  | $H$4 | NO | NO | NO | NO | NO
 |  | $I$4 | NO | NO | NO | NO | NO
 |  | $J$4 | NO | NO | NO | NO | NO
 |  | $[NAME] | YES | YES | YES | YES | YES
 |  | $B$5 | NO | NO | NO | NO | NO
 |  | $C$5 | NO | NO | NO | NO | NO
 |  | $D$5 | NO | NO | NO | NO | NO
 |  | $E$5 | NO | NO | NO | NO | NO
 |  | $F$5 | YES | YES | YES | YES | YES
 |  | $G$5 | NO | NO | NO | NO | NO
 |  | $H$5 | NO | NO | NO | NO | NO
 |  | $I$5 | NO | NO | NO | NO | NO
 |  | $J$5 | NO | NO | NO | NO | NO
 |  | $K$5 | NO | NO | NO | NO | NO
 | Result Cells:
 |  | $[NAME]
 | Notes:  Current Values column represents values of changing cells at
 | time Scenario Summary Report was created.  Changing cells for each
 | scenario are highlighted in gray.
Spreadsheet: 4e8dc5a0-f0e0-4813-8279-2b9c647c7de9
Sheet: FORM 11 Cash Flow

 |  |  |  |  | CASH FLOW STATEMENT
 |  | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | PROJECTED | Total  Projected | Final Approved Budget
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | [NAME]
REVENUES
Type:
Distributive School Acct
Donations
Federal Grant A
Total Revenues
Total Revenues Y-T-D
EXPENDITURES
Salaries & Benefits
Salaries
Benefits
Total Salaries & Ben
Operating
Supplies
Rent
Utilities
Contracts
Textbooks
Equipment
 |  |  |  |  |  |  |  |  |  |  |  |  | W
Total Expenses
Total Expenses Y-T-D
Percent of Budget
Projected Cash Balance Statement
Net change in Cash (F/B)
Begin Cash Balance(F/B) |  | 0
End Cash Balance (F/B)
FORM 11 CASH FLOW
Spreadsheet: kate_symes__18748__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
Spreadsheet: 302ca299-0526-4244-86b0-9d33fade9d2f
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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | ($ millions) | Q110 | Q210 | Q310 | Q410 |  | Q111 | Q211 | Q311 | Q411 |  | Q112 | Q212 | Q312 | Q412 | Q212 |  | 2010 | 2011 | 2012
 | Revenue
 | North America | 1704 | 2111 | 2381 | 2631 |  | 2982 | 3445 | 3876 | 4110 |  | 4168 | 0 | 0 | 0 | 4140 |  | 8827 | 14413 | 8308
 | Latin America | 495 | 567 | 568 | 599 |  | 612 | 687 | 806 | 877 |  | 780 | 0 | 0 | 0 | 879 |  | 2229 | 2982 | 1659
 | Europe / Africa / CIS | 920 | 981 | 947 | 1066 |  | 911 | 969 | 991 | 1085 |  | 1012 | 0 | 0 | 0 | 1156 |  | 3914 | 3956 | 2168
 | Middle East / Asia | 642 | 728 | 769 | 864 |  | 777 | 834 | 875 | 992 |  | 908 | 0 | 0 | 0 | 1059 |  | 3003 | 3478 | 1967
 | Total | 3761 | 4387 | 4665 | 5160 |  | 5282 | 5935 | 6548 | 7064 |  | 6868 | 0 | 0 | 0 | 7234 |  | 17973 | 24829 | 14102
 | Operating Income
 | North America | 230 | 441 | 573 | 632 |  | 732 | 997 | 1135 | 1118 |  | 1061 | 0 | 0 | 0 | 857 |  | 1876 | 3982 | 1918
 | Latin America | 46 | 89 | 77 | 78 |  | 76 | 81 | 137 | 170 |  | 122 | 0 | 0 | 0 | 138 |  | 290 | 464 | 260
 | Europe / Africa / CIS | 130 | 148 | 139 | 167 |  | -4 | 68 | 66 | 109 |  | 97 | 0 | 0 | 0 | 159 |  | 584 | 239 | 256
 | Middle East / Asia | 102 | 137 | 91 | 165 |  | 86 | 96 | 99 | 170 |  | 124 | 0 | 0 | 0 | 153 |  | 495 | 451 | 277
 | Corporate and Other | -59 | -53 | -62 | -62 |  | -76 | -81 | -105 | -137 |  | -381 | 0 | 0 | 0 | -106 |  | -236 | -399 | -487
 | Total | 449 | 762 | 818 | 980 |  | 814 | 1161 | 1332 | 1430 |  | 1023 | 0 | 0 | 0 | 1201 |  | 3009 | 4737 | 2224
Spreadsheet: 806942d1669682943-if-and-or-help-sample-sheet
Sheet: Sheet1

EVENT STATUS:
SAP EVENT NO: |  |  |  | 122855
START DATE: |  |  |  | 2023-01-01 00:00:00
END DATE: |  |  |  | 2023-01-02 00:00:00
STAFF REQUIRED: |  |  |  | 0
APPLIED = A
WITHDRAWN = W
SELECTED  = S
TOTAL EVENT HOURS:
# EVENTS APPLIED | # EVENTS W/DRAWN | # EVENTS SELECTED | TOTAL HOURS
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
Spreadsheet: 772881d1647509256-extract-range-of-sequence-between-gap-s-summary-cover
Sheet: Sheet1

Unsorted
Master List |  |  |  |  | Summary Cover
Used# | Trans. Code# | User |  |  | # | From | To | Trans. Code# |  | Sorted
22000001 |  |  |  |  | 1 | 22000001 | 22000005 |  |  | 22000001
22000051 |  |  |  |  | 2 | 22000007 | 22000007 |  |  | 22000002
22000076 |  |  |  |  | 3 | 22000051 | 22000052 |  |  | 22000003 | #1
22000132 |  |  |  |  | 4 | 22000076 | 22000076 |  |  | 22000004
22000002 |  |  |  |  | 5 | 22000131 | 22000133 |  |  | 22000005
22000003 |  |  |  |  | 6 |  |  |  |  | 22000007 | #2
22000004 |  |  |  |  | 7 |  |  |  |  | 22000051 | #3
22000005 |  |  |  |  | 8 |  |  |  |  | 22000052
22000052 |  |  |  |  | 9 |  |  |  |  | 22000076 | #4
22000131 |  |  |  |  | 10 |  |  |  |  | 22000131
22000133 |  |  |  |  | 11 |  |  |  |  | 22000132 | #5
22000007 |  |  |  |  | 12 |  |  |  |  | 22000133
 |  |  |  |  | 13
 |  |  |  |  | 14
 |  |  |  |  | 15
Spreadsheet: 467913d1467042414-return-multiple-values-ak-return-multiple-values-question
Sheet: Sheet1

Need formula that looks up these criteria | Count |  | Colors | Object
Green
Blue
Orange
Yellow
Red
Against this Data
Colors | Object
Green, Blue, Orange | Object 1
Yellow, Red, Blue | Object 2
Green, Blue | Object 3
Spreadsheet: 695734d1600366450-pivot-refresh-based-on-data-validation-sample2
Sheet: Sheet1

Country | No. of trade | No. of Sell
India | 42 | 31 |  |  |  |  |  |  | Values
Italy | 22 | 45 |  |  |  |  |  | Country | Sum of No. of trade | Sum of No. of Sell
Germany | 33 | 44 |  |  |  |  |  | France | 33 | 44
France | 33 | 44 |  |  |  |  |  | Germany | 33 | 44
 |  |  |  |  |  |  |  | India | 42 | 31
 |  |  |  |  |  |  |  | Italy | 22 | 45
 |  |  |  |  |  |  |  | Grand Total | 130 | 164
 |  |  |  |  | India
Spreadsheet: 684565d1593444845-pair-up-values-in-one-range-area-with-values-in-other-range-area-book1-succeeded2
Sheet: Sheet1

Group One | A | B | C | D | E |  |  | A | B | C | D | E
 | 5 | 3 | 7 | 6 | 4
Group Two | I | II | III | IV | V
 | 2 | 4 | 7 | 6 | 5
Rules
1. If value of a cell in group-1 is more than 5 (--> 6 and 7), it's paired up with value of cell in group-2 which is more than 4 (--> 5, 6 and 7)
2. If value of a cell in group-1 is between 3 and 6 (--> 4 and 5), it's paired up with value of cell in group-2 which is more than 5 (-->  6 and 7)
3. Those pairs will be put in yellow area
Spreadsheet: 856100d1705482021-find-the-index-of-last-zero-after-which-the-entries-start-increasing-help-with-formula-aligw
Sheet: Sheet1

 | 150 | 140 | 130 | 120 | 110 | 105 | 100 | 95 | 90 | 85 | 80 | 78 | 76 | 74 | 72 | 70 | 68 | 66 | 64 | 62 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | Determined Index
Series 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 14 | 0 | 15 | 19 | 20
series 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 9 | 10 | 15 | 18 | 18 | 18 | 20
 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 125 | 130 | 135 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | Determined Index
Series 1 | 20 | 20 | 20 | 16 | 18 | 17 | 15 | 18 | 15 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
series 2 | 20 | 20 | 20 | 20 | 18 | 18 | 17 | 17 | 17 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Saud Al Slash

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 0 to 200,000 | 0.25
 |  | [NAME] to 500,000 | 0.3
 |  | [NAME] to 600,000 | 0.32
 |  | [NAME] to 700,000 | 0.35
 |  | Tier 5 - 700,001 to 800,000 | 0.37
 |  | Tier 6 - 800,001 to 900,000 | 0.4
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Refferal | 0.1
 |  | Procedure in the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.5
 |  | OR in the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.25
 |  | OR outside the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.65
Doctor Calculation
 |  | Doctor Consultation Revenue | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be paid
 |  | Lab Revenue | 0
 |  | [NAME] (65%)
 |  | Clinics Share (35%)
 |  | Amount to be paid
 |  | Procedure Revenue | 0
 |  | Consumables
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be Paid
 |  | OR in the Clinic Doctor Revenue | 0
 |  | OR Fees
 |  | OHE (5%)
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be Paid
 |  | OR outside the Clinics Revenue | 0
 |  | Hospital Fees
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  | Sr. Finance Manager |  | .......................
 |  |  |  |  |  |  |  | Operations Report on Aug- 2019
 |  |  |  |  |  |  |  | # | Day/Date | Time | Patient |  | [NAME] | Price | Surgeon | Anesthesia |  | Amount
 |  |  |  |  |  |  |  | 1 | Sunday 25-08-2019 | At 5:33  pm he tooks          2 hrs & 35 mins | Daae Tualb 10053232 |  | Breast Reduction | Dr [NAME] | GA | IV sedation + local | 2000+1000+500
Spreadsheet: 866068d1713003409-assign-serial-numbers-to-each-product-code-assigning-serial-number-to-each-product-code-2-ans
Sheet: Sheet1

ProdCode | Specification | Printing Category | Serial Number - manually THIS SHOULD BE THE RESULT FROM THE FORMULA | Serial Number - Automatik
Prod A | Spec.1 | A5 | 1
Prod A | Spec.2 | A5 | 1
Prod A | Spec.3 | A5 | 1
Prod B | Spec.1 | A5 | 2
Prod B | Spec.2 | A5 | 2
Prod B | Spec.3 | A5 | 2
Prod B | Spec.4 | A5 | 2
Prod C | Spec.1 | A6 | 1
Prod C | Spec.2 | A6 | 1
Prod C | Spec.3 | A6 | 1
Prod C | Spec.4 | A6 | 1
Prod C | Spec.5 | A6 | 1
Prod C | Spec.6 | A6 | 1
Prod D | Spec.1 | A6 | 2
Prod D | Spec.2 | A6 | 2
Prod D | Spec.3 | A6 | 2
Prod D | Spec.4 | A6 | 2
Prod D | Spec.5 | A6 | 2
Prod D | Spec.6 | A6 | 2
Prod E | Spec.1 | A5 | 3
Prod E | Spec.2 | A5 | 3
Prod E | Spec.3 | A5 | 3
Prod E | Spec.4 | A5 | 3
Prod E | Spec.5 | A5 | 3
Prod E | Spec.6 | A5 | 3
[NAME] | Spec.1 | A7 | 1
[NAME] | Spec.2 | A7 | 1
[NAME] | Spec.3 | A7 | 1
[NAME] | Spec.4 | A7 | 1
[NAME] | Spec.5 | A7 | 1
[NAME] | Spec.6 | A7 | 1
[NAME] | Spec.1 | A7 | 2
[NAME] | Spec.2 | A7 | 2
[NAME] | Spec.3 | A7 | 2
[NAME] | Spec.4 | A7 | 2
[NAME] | Spec.5 | A7 | 2
[NAME] | Spec.6 | A7 | 2
Prod H | Spec.1 | A7 | 3
Prod H | Spec.2 | A7 | 3
Prod H | Spec.3 | A7 | 3
Prod H | Spec.4 | A7 | 3
Prod H | Spec.5 | A7 | 3
Prod H | Spec.6 | A7 | 3
Prod I | Spec.1 | A7 | 4
Prod I | Spec.2 | A7 | 4
Prod I | Spec.3 | A7 | 4
Prod I | Spec.4 | A7 | 4
Prod I | Spec.5 | A7 | 4
Prod I | Spec.6 | A7 | 4
Prod J | Spec.1 | A5 | 4
Prod J | Spec.2 | A5 | 4
Prod J | Spec.3 | A5 | 4
Prod J | Spec.4 | A5 | 4
Prod J | Spec.5 | A5 | 4
Prod J | Spec.6 | A5 | 4
Spreadsheet: 865166d1712225152-indirect-function-with-multiple-criteria-indirect-formula-with-multiple-criteria
Sheet: Details

Date | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | Month
Shift | A | B | C | Total | A | B | C | Total | A | B | C | Total | A | B | C | Total
Manpower on Board | 10 | 6 | 4 |  | 10 | 6 | 4 |  | 10 | 6 | 4
Manpower Attended | 7 | 4 | 2 |  | 6 | 3 | 2 |  | 7 | 4 | 3
Absent %
Output | 10 | 8 | 9 |  | 10 | 8 | 9 |  | 9 | 7 | 19
Net Man Hrs / MT
Spreadsheet: 377134d1423815457-how-to-combine-specific-sheets-from-workbooks-dropped-into-a-folder-teacher-2-pay_attendance
Sheet: Attendance

COMPANY Name |  |  |  |  |  |  |  | 2015
 |  | Totals |  |  |  |  |  | Wk1 |  |  |  |  | Wk2 |  |  |  |  | Wk3 |  |  |  |  | Wk4 |  |  |  |  | Wk5
Students
Number | Name | P | Pr | Ax | Cx | Nc |  | P | Pr | Ax | Cx | Nc | P | Pr | Ax | Cx | Nc | P | Pr | Ax | Cx | Nc | P | Pr | Ax | Cx | Nc | P | Pr | Ax | Cx | Nc
0 | Special Class
100 | Student 1
101 | Student 2
102 | Student 3
103 | Student 4
104 | Student 5
105 | Student 6
106 | Student 7
107 | Student 8
108 | Student 9
109 | Student 10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 180250d1347543143-delete-duplicates-in-range-book8
Sheet: Sheet 1

Item ID | Item Description | Qty | PO Cost | Unit Price | Supplier ID | Line # | Disposition | Source ID |  |  | PO # | [NAME] | Supp ID | Customer Name | Cust PO # | Ship To | [NAME]. Date
 |  |  |  |  |  |  |  |  | 0 |  | 2412712 | 23 | 13754 | Customer Name | 123456789 | 123456 | 2012-09-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  | 2412712 | 25 | 13754
 |  |  |  |  |  |  |  |  | 0 |  | 2412712 | 26 | 13754
 |  |  |  |  |  |  |  |  | 0 |  | 2412712 | 27 | 13754
 |  |  |  |  |  |  |  |  | 0 |  | 2412714 | 7 | 24713
 |  |  |  |  |  |  |  |  | 0 |  | 2412715 | 29 | 53242
 |  |  |  |  |  |  |  |  | 0 |  | 2412717 | 4 | 86689
 |  |  |  |  |  |  |  |  | 0 |  | 2412718 | 2 | 97145
 |  |  |  |  |  |  |  |  | 0 |  | 2413020 | 5 | 119025
 |  |  |  |  |  |  |  |  | 0 |  | 2413021 | 28 | 196700
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 838919d1691516557-calculating-the-waiting-time-value-book1
Sheet: Sheet1

Delivery Waiting Time (hh:[NAME]) | Daily Waiting Time | Daily Income |  |  | Example of calc | Value | Daily Waiting Time | Daily Income
00:51:00 | Sum all values above 0:00, after removing 0:45 from each line | Total of B * £0.36
01:51:00
00:55:00
00:12:00
01:30:00
00:55:00
00:43:00
00:58:00
00:55:00
02:35:00
I can not enter the helper columns (F to I) as the data comes from an external source.
If a vehicle has to wait longer than 45 mins to make a delivery,  we are paid £0.36 for each minute above the 0:45
If a value in Column A is above 0:45, then deduct 0:45
Then sum all values above 0:00 in the range A3:A12 and put the result in B3
Then multiply B3 by £0.36 to give me a  daily total payment due in C3.
Spreadsheet: 78320d1278689842-creating-unique-lists-file
Sheet: Tutor Lookup

TUTOR NAMES & ASSIGNED NUMBERS
20 | # | Tutor Name (No Duplicates)
G S | 1 | A B
C S | 2 | A L
J S | 3 | B E
L G | 4 | C I
M K | 5 | C K
P H | 6 | C M
S C | 7 | C S
S WE | 8 | G S
S T | 9 | J S
S W | 10 | L G
W A | 11 | M D
A B | 12 | M K
 | 13 | P H
A L | 14 | S C
B E | 15 | S T
C I | 16 | S W
C M | 17 | S WE
C K | 18 | W A
M D | 19 | ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
ZZZZ
Spreadsheet: 37698d1235733677-chart-axis-date-intervals-672812
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 0.5 | 2001-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-13 16:44:51.868000 | 2001-06-08 21:32:01.154000 |  | 0.5 | 2001-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-21 13:21:39.743000 | 2001-05-15 04:16:33.111000 |  | 0.5 | 2001-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 |  | 0.5 | 2001-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-28 00:00:00 | 2001-12-28 00:00:00 |  | 0.5 | 2001-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-21 20:53:00.276000 | 2001-07-30 10:06:09.803000 |  | 0.5 | 2001-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2001-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2002-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 2002-02-01 00:00:00
Spreadsheet: 186798d1350227827-display-weekly-data-on-a-chart-only-if-the-week-has-a-value-test
Sheet: Sheet1

Week | Type | Qty |  |  | Week |  |  | Week | Qty
1 | ABC | 51168.18183631881 |  |  | 4 | YTD |  | 1
1 | DEF | 88475.95166737172 |  | ABC |  |  |  | 2
1 | ABC | 50340.97389625815 |  | DEF |  |  |  | 3
1 | DEF | 10991.90616991054 |  |  |  |  |  | 4
2 | ABC | 26739.1710054267 |  |  |  |  |  | 5
2 | DEF | 24595.70949845594 |  |  |  |  |  | 6
2 | ABC | 47781.5135310286 |  |  |  |  |  | 7
2 | DEF | 73035.88152846738 |  |  |  |  |  | 8
3 | ABC | 99510.40978001354 |  |  |  |  |  | 9
3 | DEF | 82713.33046081348 |  |  |  |  |  | 10
4 | ABC | 92020.03218806865 |  |  |  |  |  | 11
4 | DEF | 10389.66716691851 |  |  |  |  |  | 12
4 | ABC | 18803.24177717066
4 | DEF | 19396.40694008908
5 | ABC | 66354.37928738263
5 | DEF | 47642.65388627604
5 | ABC | 45029.46954291183
5 | DEF | 45484.07954810708
6 | ABC | 3352.178882685519
6 | DEF | 11953.46560578662
6 | ABC | 35115.10151287661
6 | DEF | 2789.741228835507
Spreadsheet: 865128d1712187795-too-many-if-and-statements-production_cost_calculator_test
Sheet: <ENTER JOB NAME>

Description | Volume
TEST | Print | [NAME]
 | 207541 | 830164
Mailing size | DL presort postage - Small up to 125g
ITEM | COST
Development costs | 5000
Production costs ex GST
DL Envelopes ex GST
[NAME] ex GST
[NAME] ex GST
Design ex GST | 2500
<STOCK ITEM> ex GST | 0
Postage
TOTAL
Spreadsheet: 108326d1305345497-index-and-match-function-for-same-item-in-the-table-index-and-match-function-testing
Sheet: Sheet2

RM |  | YTD | Amount
apple | Creditcard | 5 | 30000
apple | Loan | 3 | 2000
[NAME] | Creditcard | 4 | 10000
[NAME] total |  | 4 | 10000
[NAME] | Loan | 6 | 12222
[NAME] | Creditcard | 3 | 30000 |  |  | {=INDEX($D$2:$D$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$2:$C$7),0))}
[NAME] | Loan | 5 | 65550
[NAME] | LOC | 55 | 32333
karem 10850 * | Creditcard | 32 | 3004
karem 10850 * | Loan | 50 | 4565
karem 10850 * | LOC | 90 | 500000
[NAME] | Creditcard | 5 | 32333
[NAME] | Loan | 5 | 34324
 |  |  |  |  | karem 10850 * | Creditcard | 3004
Spreadsheet: 59031d1259361329-using-2-listboxes-to-determine-a-cell-value-708893-using-2-listboxes-to-determine-a-cell-value
Sheet: Sheet1

1 | 1 | 140 |  |  |  |  |  |  |  |  |  |  |  | 1 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Look Up Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | A | B | C | D | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 140 | 180 | 225 | 275 | 350
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 135 | 145 | 160 | 200 | 310
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 130 | 130 | 130 | 130 | 130
Spreadsheet: 845497d1697003315-copy-formulas-and-format-from-existing-row-to-a-new-row-my-gites-aligw
Sheet: Data

Direct |  | 1
Booking |  | 2 |  | BACS |  | 2 Bruce Springsteen
 |  | 3 |  | Cheque |  | 3 Mick Jagger
 |  | 4 |  | Cash |  | 4 [NAME]
 |  | 5 |  | CB |  | 5 [NAME]
 |  | 6 |  |  |  | 6 [NAME]
 |  | 7 |  |  |  | 7 [NAME]
 |  | 8 |  |  |  | 8 [NAME]
 |  | 9 |  |  |  | 9 [NAME]
 |  | 10 |  |  |  | 10 Ringo Starr
 |  | 11
 |  | 12