tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 881287d1729316194-i-want-to-calculate-daily-consumption-for-each-material-from-another-sheet-1
Sheet: Sheet2

Sl.No. | Material Description | Unit | 2024-10-10 00:00:00 | 2024-10-11 00:00:00 | 2024-10-12 00:00:00 | 2024-10-13 00:00:00 | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00
1 |  | Nos |  |  |  |  |  |  | 7410 | 7410 | 7410 | 18278 | 18278 | 18278 | 10868 | 10868 | 10868 | 8892
2 | Cement | Bag
3 | Stone aggregate 20mm | Cum
4 | Stone aggregate 10mm | Cum
5 | Sand | Cum
6 | Fine Sand | Cum
7 | Mason | Day
8 | Helper | Day
9 | W-Helper | Day
65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84
Spreadsheet: 105580d1302884350-auto-fill-address-es-of-cells-that-meet-a-manually-entered-criteria-example
Sheet: Sheet1

 | Condition 1 | Condition 2 | Condition 3 | Condition 4 | Condition 5 | Condition 6 | Condition 7 | Condition 8 | Condition 9
Client 1 | Yes | No | Maybe | N/A | Maybe | N/A | Maybe | N/A | Maybe
Client 2 | Maybe | Yes | Maybe | N/A | N/A | Maybe | No | Maybe | Maybe
Client 3 | No | Yes | No | No | Yes | Yes | N/A | N/A | Yes
Client 4 | Yes | Yes | Yes | Yes | No | Yes | Yes | No | Yes
Client 5 | Yes | Yes | N/A | N/A | No | No | N/A | Maybe | Yes
Client 6 | N/A | Maybe | Maybe | No | Yes | N/A | Yes | Yes | Yes
Client 7 | Maybe | N/A | N/A | Yes | N/A | No | Yes | Yes | No
Client 8 | N/A | Maybe | Yes | N/A | Yes | N/A | N/A | Yes | No
Client 9 | N/A | N/A | N/A | N/A | No | Yes | Yes | No | Yes
Client 10 | Maybe | No | N/A | Maybe | Yes | No | No | Yes | No
Client 11 | N/A | Yes | No | No | Yes | No | No | Maybe | Maybe
Client 12 | No | N/A | No | No | No | No | No | No | Maybe
Client 13 | N/A | Yes | No | No | Yes | No | No | Maybe | No
Client 14 | N/A | No | Yes | N/A | No | No | Yes | Yes | Yes
Client 15 | Maybe | Yes | N/A | Yes | Maybe | N/A | No | No | No
Client 16 | No | No | N/A | No | Maybe | Yes | Yes | No | Yes
Client 17 | Maybe | No | N/A | No | No | No | No | Yes | Yes
Client 18 | Yes | No | No | Yes | No | N/A | No | No | Yes
Client 19 | No | Maybe | Yes | No | No | N/A | Yes | No | N/A
Client 20 | No | Yes | Yes | Yes | No | Maybe | N/A | Maybe | Maybe
Client 21 | No | Yes | Maybe | Maybe | Yes | Yes | Maybe | No | N/A
Client 22 | Yes | N/A | Maybe | N/A | N/A | Maybe | Yes | No | Maybe
Client 23 | No | Yes | N/A | Maybe | No | Maybe | Maybe | Yes | Yes
Client 24 | Yes | No | Yes | Yes | No | Yes | N/A | Yes | Yes
 | B2 | Notes for the Yes value of Client 1 and Condition 1
 | [NAME] | Notes for the Yes value of Client 2 and Condition 2
 | C4 | Notes for the Yes value of Client 3 and Condition 3
Spreadsheet: 84847d1284941524-index-and-match-or-lookup-formula-copy-of-demo-3
Sheet: DEMO Sheet

 |  | Date | Name | In coming | Out going | Balance |  |  |  | Date | Name | In coming | Out going | Balance
Spreadsheet: 455596d1460422254-look-up-a-value-from-a-table-adding-the-text-and-changing-the-cell-background-colour-risk_register_version_d0_1_copy
Sheet: Project Specific Level Risks

PRE MITIGATION RISK |  |  |  | RISK EXPOSURE |  |  |  |  |  |  | RISK MITIGATION
Risk ID (Pro No, then risk no) | Risk Originator | Risk Description | Risk Related ID | Cost Impact $ | Schedule Impact (working days) | Performance Impact | Probability Score | Impact Score | Total Score | Area of Risk | Comments | Governance Level | Mitigation Plan | Projected Date of implementation | Risk meeting minutes (link) | Risk Owner
All001 |  | Client could completely reconfigure CARPS and change the installation baseline and then blame '[NAME]' for providing the wrong configuration settings |  |  |  |  | moderate | major | high |  | In Control cannot prove what baseline was installed which means there is additional costs to [NAME] to go have to revist the site and re-install/change the baseline back to what it should be. |  | Create an installations plan.  After installatin of the system, and agreement by the customer, get them to sign a declaration of the system and take a baseline snapshot of the configuration prior to leaving.  If they reconfigure the system any time after installation and change several settings, we have a copy that they signed so we can compare and prove what settings we last set it to and can understand what changes they made.
Spreadsheet: 776559d1649788043-sumifs-with-four-contions-criteria-and-help-with-dropdown-list-180
Sheet: Sheet1

 |  |  | Projects | Items | [NAME] | Amount
 |  |  | Green_Street | Basement | 4D Communications Ltd | 70
 |  |  | Green_Street | first_floor | SURREY COUNTY COUNCIL | 50
 |  |  | Derby | Sssecond_Floor | PYRAMID PLUS SOUTH LLP | 40
 |  |  | Upton_Lane | Toisslet | SURREY COUNTY COUNCIL | 60
Spreadsheet: 189717d1351291490-divide-and-distribute-costs-to-multiple-participants-based-on-individual-amount-owed-vacation-cost-calculator
Sheet: Family5

Family5 |  |  |  |  | Receipts for Group Items | Cost | Total Paid
Family Members at Parker | 2 |  |  |  | Pontoon Boat | 1400 | 1700 |  |  | OLD FAMILY DAYS AT PARKER
Family Days at Parker | 4 |  |  |  | [NAME] | 300 |  |  |  | 2
Family Members: | Days at Parker
Family_Member1 | 2
Family_Member2 | 0
Family_Member3 | 2
Family_Member4 | 0
Spreadsheet: 94507d1294309702-excel-2007-excel-experts-plz-i-need-help-project-data-4
Sheet: Economics

 |  |  |  | ID | 900012394 |  | Major
 |  |  | [NAME]
 |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI101 |  |  | ENG204 |  |  |  |  | ENG208 |  |  | ECO327
 |  |  | 1st semester | BIS101 |  | 3rd semester | ACC201 |  |  |  | 5th semester | BLW301 |  | 7th semester | ECO401
 |  |  |  | MTH101 |  |  | ECO201 |  |  |  |  | QBA202 |  |  | MJEXXX
 |  |  |  | HUMXXX |  |  | QBA201 |  |  |  |  | ECO301 |  |  | FREEXXX
 |  |  |  | SCIXXX |  |  | MGT201 |  |  |  |  | FREEXXX |  |  | FREEXXX
 |  |  |  | Course |  |  | Grade |  |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI102 |  |  | ECO202 |  |  |  |  | [NAME] |  |  | MGT406
 |  |  | 2nd semester | ARAXXX |  | 4th semester | ACC202 |  |  |  | 6th semester | MGT360 |  | 8th semester | MJEXXX
 |  |  |  | MTH102 |  |  | FIN201 |  |  |  |  | HSSXXX |  |  | MJEXXX
 |  |  |  | SCIXXX |  |  | MKT201 |  |  |  |  | ECO302 |  |  | FREEXXX
 |  |  |  | HUMXXX |  |  | MIS201 |  |  |  |  | ECO351 |  |  | FREEXXX
 |  |  |  |  |  |  |  |  |  |  |  | FREEXXX
Spreadsheet: 838366d1690964155-return-rows-and-column-of-data-based-on-user-input-fuel-calculator-aligw
Sheet: Sheet1

FUEL CALCULATOR BASED ON ACTUAL DEPARTURE TIME FOR TRIP |  |  |  |  |  |  |  |  |  |  |  | LITERS | = | LBS | = | GAL
SCHEDULED WHEELS UP TIME |  | ACTUAL WHEELS UP TIME |  | TIME DELAYED MINUTES |  |  |  | WU | WD | TOTAL TIME |  | 1 |  |  |  |  | FUEL
09:00:00 |  | 10:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONVERSION
 |  |  |  |  |  |  |  |  |  |  |  | GAL | = | LITERS | = | LBS
 |  |  |  |  |  |  |  | 03:45:00 | 06:00:00
TOTAL FUEL REQUIRED FOR TRIP (LBS) |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 08:06:00 | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  | LBS |  | LITERS |  | GAL
[NAME] (LBS) |  | AUX TANKS (LBS) |  |  | ME TANKS (LBS) |  |  |  |  |  |  | 1
FULL = 2546 LBS / 1438 L |  | FULL = 1065 LBS / 602 L |  |  | FULL = 1754 LBS / 991 L |  |  |  |  |  |  | TEMP CONVERSION |  |  |  | PRESS CONVERSION
 | V SPEED LOOKUP |  |  | V1 |  |  |  |  |  |  |  | *F | = |  |  | MB | =
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 29.92
 | FLAP SETTING | APP |  | VR
 | [NAME] | DRY |  | V2
 | OUTSIDE AIR TEMP | 19 |  | V35
 | AIRCRAFT WEIGHT | 12677 |  | TOFL
 |  |  |  |  |  |  |  | TOFL
 |  |  |  | V SPEEDS
Spreadsheet: 488333d1478619168-center-excel-tool-book1
Sheet: Original

tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
tool | tool | tool | tool | tool
Spreadsheet: 829328d1684146169-filter-define-txt-basis-difference-cells-price-etaf
Sheet: Sheet1

 | Customer Price (USD) | Vendor [NAME]) | Margin Amount | Margin % | Cost Base Price | Priority |  | vendor higher than cost | Vendor higher than customer | Focus Area |  | venor less than custome | higher cost | Check
 | 185.72 | 130 |  |  | 182
 | 283 | 110 | 173 | 0.6113074204946997 | 75
 | 100 | 150 | 1126.29 | 0.882471852008556 | 100
 | 1967.66 | 550 | 1417.66 | 0.7204801642560199 | 560
 | 628.56 | 320 | 308.5599999999999 | 0.4908998345424462 | 380.8
 | 180 | 80 | 100 | 0.5555555555555556 | 66
 | 800 | 550 | 250 | 0.3125 | 560
 | What happens if equal or none are true - it will also refer as "check price"
 | vendor price is higher than cost base price and customer price it will reflect as "Focus area"
 | vendor price is higher than cost base price and less than customer price "vendor higher cost base"
 | c3 > f3   , c3 > f3 | focus
Spreadsheet: 868673d1715341303-lookup-function-book2
Sheet: Plan

 |  |  | To serach | Fiscalité I
 |  |  | Result
 |  | 2024-01-04 00:00:00 |  |  | 2024-01-05 00:00:00 |  |  | 2024-01-06 00:00:00 |  |  | 2024-01-07 00:00:00
 |  | 08h00-09h30 |  |  | 08h00-09h30 |  |  | 08h00-09h30 |  |  | 08h00-09h30
 |  | Names | Pro | Course | Names | Pro | Course | Names | Pro | Course | Names | Pro | Course
 | Room 1
 | Room 2
 | Room 3
 | Room4 |  |  |  |  |  |  |  |  |  |  |  | Fiscalité 1
 | Room 5
Spreadsheet: 708961d1608113266-look-up-value-in-range-and-perform-action-with-data-on-that-row-bpm-tax-online
Sheet: BPM - year 

2017 |  |  |  |  | 2018 |  |  |  |  | 2019 |  |  |  |  | 2020
MORE THAN | BUT NOT MORE THAN | 1. CO2 g minus value of I 2. Multiply result with IV 3. Add result with III |  |  | MORE THAN | BUT NOT MORE THAN | 1. CO2 g minus value of I 2. Multiply result with IV 3. Add result with III |  |  | MORE THAN | BUT NOT MORE THAN | 1. CO2 g minus value of I 2. Multiply result with IV 3. Add result with III |  |  | MORE THAN | BUT NOT MORE THAN | 1. CO2 g minus value of I 2. Multiply result with IV 3. Add result with III
I | II | III | IV |  | I | II | III | IV |  | I | II | III | IV |  | I | II | III | IV
0 | 76 | 353 | 2 |  | 0 | 73 | 356 | 2 |  | 0 | 71 | 360 | 2 |  | 0 | 68 | 366 | 2
76 | 102 | 505 | 66 |  | 73 | 98 | 502 | 63 |  | 71 | 95 | 502 | 60 |  | 68 | 91 | 502 | 59
102 | 150 | 2221 | 145 |  | 98 | 144 | 2077 | 139 |  | 95 | 139 | 1942 | 131 |  | 91 | 133 | 1859 | 129
150 | 168 | 9181 | 238 |  | 144 | 162 | 8471 | 229 |  | 139 | 156 | 7706 | 215 |  | 133 | 150 | 7277 | 212
168 | / | 13465 | 475 |  | 162 | / | 12593 | 458 |  | 156 | / | 11361 | 429 |  | 150 | / | 10881 | 424
 |  | base value diesel | Extra cost per gram |  |  |  | base value diesel | Extra cost per gram |  |  |  | base value diesel | Extra cost per gram |  |  |  | base value diesel | Extra cost per gram
 |  | 65 | 68.69 |  |  |  | 63 | 87.38 |  |  |  | 61 | 88.43 |  |  |  | 59 | 89.85
Spreadsheet: 673200d1587246423-how-to-display-the-latest-20-dates-from-a-data-sheet-golf-handicap-index-calculation-golfhandicapindexcalculation-5-
Sheet: Scores

Date | Course | Rating | Slope | A | B | C | D |  |  |  | C
2019-07-29 00:00:00 | Cowansville | 69.9 | 125 |  | 97 | 100 | 89
2019-07-30 00:00:00 | Chateau Bromont | 68 | 122 |  | 109 | 116 | 87
2019-08-10 00:00:00 | Tremblant-Le Diable | 69.9 | 126 |  |  | 109 | 88
2019-08-11 00:00:00 | Ile de Montreal-Ile | 68.6 | 122 |  |  | 110 | 89
2019-08-15 00:00:00 | Metropolitain | 69.6 | 126 |  | 99 | 101
2019-08-17 00:00:00 | Mirabel-Le Select | 69.7 | 122 |  | 106 | 102 | 96
2019-08-22 00:00:00 | Ile de Montreal-Ireland | 69.4 | 126 |  |  | 117 | 93
2019-08-24 00:00:00 | Candiac | 70.6 | 129 |  |  | 113 | 87
2019-08-26 00:00:00 | Candiac | 70.6 | 129 |  | 115 | 97
2019-08-29 00:00:00 | Montebello | 67.7 | 124 |  |  | 120 | 88
2019-08-31 00:00:00 | Beloeil | 69.6 | 126 |  |  | 99
2019-09-01 00:00:00 | Candiac | 70.6 | 129 |  |  | 101 | 87
2019-09-05 00:00:00 | Royal Bromont | 67 | 115 |  |  | 99 | 93
2019-09-08 00:00:00 | Candiac | 70.6 | 129 |  |  | 97 | 87
2019-09-12 00:00:00 | Atlantide | 67.7 | 120 |  | 107 | 95
2019-09-14 00:00:00 | Elmridge-North | 68.7 | 120 |  | 106 | 108 | 89
2019-09-15 00:00:00 | Ile de Montreal-Ireland | 69.4 | 126 |  |  | 107 | 89
2019-09-15 00:00:00 | Metropolitain | 69.9 | 126
2019-09-19 00:00:00 | Montebello | 67.7 | 124 |  | 108 | 121 | 99
2019-09-21 00:00:00 | Mirabel-Le Select | 69.7 | 122
2019-09-22 00:00:00 | Metropolitain | 69.6 | 126 |  |  | 98 | 83
2019-09-25 00:00:00 | Ile de Montreal-Ireland | 69.4 | 126 |  |  | 112 | 90
2019-09-30 00:00:00 | Le Versant-Braves | 69.2 | 120 |  |  | 106
2019-10-14 00:00:00 | La Seigneurie | 68.5 | 123 |  | 97
2019-10-24 00:00:00 | Atlantide | 67.7 | 120 |  |  | 107 | 93
2019-10-31 00:00:00 | Ile de Montreal-Ireland | 69.4 | 126 |  | 104 | 104 | 93
2019-11-03 00:00:00 | Ile de Montreal-Ireland | 69.4 | 126 |  |  | 105 | 93
2020-01-30 00:00:00 | Championsgate-National | 67.9 | 116 | 111 | 118 | 99 | 89
2020-01-30 00:00:00 | Championsgate-International | 70.8 | 127 | 114 | 109 | 108 | 93
2020-01-31 00:00:00 | Eagle Creek Orlando | 72.5 | 128 | 101 | 101 | 104 | 87
2020-01-31 00:00:00 | Eagle Creek Orlando | 72.5 | 128 | 98 | 100 | 112 | 86
2020-02-01 00:00:00 | Walt Disney-Magnolia | 71.6 | 130 | 118 | 115 | 108 | 90
2020-02-01 00:00:00 | Walt Disney-Palm | 70.1 | 123 | 107 | 109 | 102 | 90
Spreadsheet: 786618d1657303770-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-2022-07-08-oeldere-johnyam54-how-to-sum-vlookup
Sheet: Cost 2

if($B6="n/a",0,iferror((getpivotdata($AZ$7,$AM$7,$AM$7,$B6)),0) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if($B6= | Cost centre 1 | on original data file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $AZ$7= | SUM of TOTAL | on original data file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $AM$7,$AM$7= | left header name on the orginal Pivot Table
Cost centres | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL |  |  |  | Rijlabels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March | Sum of SUM of TOTAL
Product 1 | 2733 | 4796 | 4145 | 4411 | 2090 | 3133 | 2334 | 4089 | 4070 | 2490 | 4186 | 4107 |  |  |  |  | Product 1 | 2733 | 4796 | 4145 | 4411 | 2090 | 3133 | 2334 | 4089 | 4070 | 2490 | 4186 | 4107 | 42584
Product 2 | 2039 | 3161 | 2881 | 3314 | 2365 | 4773 | 2812 | 3590 | 4323 | 4506 | 4777 | 3114 |  |  |  |  | Product 2 | 2039 | 3161 | 2881 | 3314 | 2365 | 4773 | 2812 | 3590 | 4323 | 4506 | 4777 | 3114 | 41655
Product 3 | 4596 | 4684 | 3467 | 4675 | 4756 | 2521 | 3893 | 4603 | 2892 | 2326 | 2951 | 4146 |  |  |  |  | Product 3 | 4596 | 4684 | 3467 | 4675 | 4756 | 2521 | 3893 | 4603 | 2892 | 2326 | 2951 | 4146 | 45510
Product 4 | 3716 | 3865 | 3774 | 3533 | 4048 | 2646 | 3983 | 2117 | 3278 | 2844 | 3773 | 3531 |  |  |  |  | Product 4 | 3716 | 3865 | 3774 | 3533 | 4048 | 2646 | 3983 | 2117 | 3278 | 2844 | 3773 | 3531 | 41108
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 13084 | 16506 | 14267 | 15933 | 13259 | 13073 | 13022 | 14399 | 14563 | 12166 | 15687 | 14898 | 170857
Requirement please
How can I wrap sum into getpivitdata to add April and May so I have amy Ytd costs
 |  | Ytd costs
Product 1 | cost centres 1 |  | manual approach-assuming I have to do this from June to March 23, I'll be adding every month
Product 2 |  |  | How can I wrap sum into getpivotdata so I'll be expanding the range each month
Product 3
Product 4
Spreadsheet: 587036d1534797761-adding-data-to-new-sheets-from-main-sheet-example
Sheet: Strawberry

[NAME] | Chevy | Miami | 6
[NAME] | Dodge | Tusla | 2135
[NAME] | Dodge | Bangor | 3
[NAME] | BMW | New York City | 5
[NAME] | Ford | Miami | 7
[NAME] | Chevy | Tusla | 35674
[NAME] | Dodge | Miami | 5375
[NAME] | Dodge | Tusla | 35
Spreadsheet: 211670d1359880524-pattern-matching-within-a-dynamic-data-set-position_spreadsheet-copy
Sheet: 6Mth_Fly

 |  | Fly | Mar13Jun13Sep13 | Jun13Sep13Dec13 | Sep13Dec13Mar14 | [NAME] | Mar14Jun14Sep14 | [NAME] | Sep14Dec14Mar15 | Dec14Mar15Jun15 | Mar15Jun15Sep15 | Jun15Sep15Dec
 | Position
 |  | Spread | Mar13 [NAME] | [NAME] | [NAME] | Dec13 Mar14 | [NAME] | [NAME] Sep14 | Sep14 Dec14 | Dec14 Mar15 | Mar15 [NAME] | [NAME]
2013-03-18 00:00:00 | 0
2013-06-17 00:00:00 | -8
2013-09-16 00:00:00 | 0
2013-12-16 00:00:00 | 16
2014-03-17 00:00:00 | 0
2014-06-16 00:00:00 | -8
2014-09-15 00:00:00 | 0
2014-12-15 00:00:00 | 0
2015-03-16 00:00:00 | 0
Spreadsheet: 141464d1329287510-vlookup-and-if-formula-help-vlookup
Sheet: Sheet1

 | 2012-02-13 00:00:00
 |  | UNIT | NAME | # LETTERS | SCORE | AVERAGE  SCORE
 | 1 | p | RAF | 2 | 600 | 300 |  |  | p | 200
 | 2 | U | MIG | 1 | 300 | 300 |  |  | U | 100
 | 3 | U2 | RAM | 1 | 100 | 100 |  |  | U2 | 100
 | 4 | U8 | DAV | 1 | 300 | 300 |  |  | U8 | 100
 | 5 | U12 | MAX | 2 | 600 | 300 |  |  | U12 | 200
 | 6 | U14 | DAV | 1 | 300 | 300 |  |  | U14 | 100
 | 7 | U18 | VIC | 2 | 600 | 300 |  |  | U18 | 200
 | 8 | u | MIG |  |  | #N/A |  |  | u
 | 9 | unit 1 | MIG |  |  | #N/A |  |  | unit 1
 | 10 | unit 3 | MIG |  |  | #N/A |  |  | unit 3
 | 11 | 5 | #N/A |  |  | #N/A |  |  | 5
 | 12 |  | #N/A |  |  | #N/A |  |  | 0
 | 13 |  | #N/A |  |  | #N/A |  |  | 0
 | 14 |  | #N/A |  |  | #N/A |  |  | 0
 | 15 |  | #N/A |  |  | #N/A |  |  | 0
 | 16 |  | #N/A |  |  | #N/A |  |  | 0
 | 17 |  | #N/A |  |  | #N/A
 | 18 |  | #N/A |  |  | #N/A
 | 19 |  | #N/A |  |  | #N/A
 | 20 |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  | TOTAL | 1000
 |  |  |  |  | TOTAL LETTERS
 |  |  |  |  | 10
 |  |  | TOTAL SCORE MUST BE 270 OR MORE TO BE QUALIFIED
 |  |  |  | A | LU
 |  |  |  | B | HAS
 |  |  |  | C | IGN
 |  |  |  | D | FRA
 |  |  |  | E | ROM
 |  |  |  | F | SIAV
 |  |  |  | G | JAI
 |  |  |  | H | MIR
 |  |  |  | I | ALE
 |  |  |  | J | PET
 |  |  |  | K | ADA
 |  |  |  | L | MOH
 |  |  |  | M | MIK
 |  |  |  | N | ANT
 |  |  |  | O | JOS
 |  |  |  | P | RAF
 |  |  |  | Q | RA
 |  |  |  | R | JES
 |  |  |  | S | ELI
 |  |  |  | T | MAR
 |  |  |  | U | MIG
 |  |  |  | V | PED
 |  |  |  | W | EFR
 |  |  |  | X | AMI
 |  |  |  | Y | JOS
 |  |  |  | Z | JOS
 |  |  |  | U1 | RAF
 |  |  |  | U2 | RAM
 |  |  |  | U3 | VIR
 |  |  |  | U4 | HEC
 |  |  |  | U5 | ALI
 |  |  |  | U6 | [NAME]
 |  |  |  | U7 | CES
 |  |  |  | U8 | DAV
 |  |  |  | U9 | UNK
 |  |  |  | U10 | OSC
 |  |  |  | U11 | JOS
 |  |  |  | U12 | MAX
 |  |  |  | U13 | MIN
 |  |  |  | U14 | DAV
 |  |  |  | U15 | CHR
 |  |  |  | U16 | AHM
 |  |  |  | U17 | RAH
 |  |  |  | U18 | VIC
Spreadsheet: 750071d1633209601-sort-names-according-to-the-scores-of-different-departments-forum-help
Sheet: Sheet1

Name | Language | math | geography | history |  |  | Ranking | Language | math | history | geography
courcy | 110 | 109 | 95 | 96 |  |  | 1 | courcy | hellen | courcy | courcy
hellen | 105 | 118 | 90 | 88 |  |  | 2 | [NAME] | dee | sela | [NAME]
[NAME] | 107 | 117 | 92 | 91 |  |  | 3 | sela | cheves | [NAME] | sela
dee | 104 | 118 | 89 | 88 |  |  | 4 | hellen | [NAME] | zucca | hellen
zucca | 103 | 113 | 88 | 89 |  |  | 5 | dee | sela | hellen | dee
cheves | 104 | 118 | 89 | 87 |  |  | 6 | cheves | zucca | dee | cheves
sela | 107 | 115 | 92 | 93 |  |  | 7 | zucca | [NAME] | cheves | zucca
[NAME] | 101 | 113 | 86 | 87 |  |  | 8 | [NAME] | courcy | [NAME] | [NAME]
Spreadsheet: 328583d1403953278-formula-to-sum-by-month-and-financial-year-sum-by-mth-and-financial-year-dgk
Sheet: Sum by month and financial year

Year | SubTotal by FinYear Prod1 | SubTotal by FinYear Prod2 | SubTotal by FinYear Prod3 | SubTotal by FinYear Prod4 | Total by FinYear |  | Total fot FY commencing 1st June | July | August | September | October | November | December | January | February | March | April | May | June
12/13 |  |  |  |  |  |  | 2012
13/14 |  |  |  |  | 8848.5 |  | 2013
1. [NAME] for calculating given income for given month in financial year across all products.
2. [NAME] for calculating given income for given financial year for given product.
In | Prod1 | Prod2 | Prod3 | Prod4
2012-09-02 00:00:00 | 100 |  | 1760 | 720
2013-06-03 00:00:00 |  | 300 |  | 720
2012-07-05 00:00:00 | 200 |  | 1760
2013-07-02 00:00:00 |  |  |  | 425
2013-09-14 00:00:00 | 2337.5
2014-02-25 00:00:00 |  |  | 1760 | 720
2014-06-02 00:00:00 |  | 550
2014-05-25 00:00:00 |  |  |  | 240
2014-01-02 00:00:00 |  |  | 1116
2014-02-25 00:00:00 | 800
2014-06-02 00:00:00 |  | 350 |  | 550
Spreadsheet: 853891d1703850065-need-help-creating-a-work-hours-and-payment-calculator-work-hours-and-payment-calculator
Sheet: Sheet1

Total Hours Worked
Rate per Hour |  | 10
Payment Due
Payment Received
Paid Work Hours
Unpaid Work Hours
Expecting
Date | Hours Worked | Payment Received
20/12/2023 | 0 | 200
21/12/2023 | 8
22/12/2023 | 3
23/12/2023 | 0 | 200
2023-12-24 00:00:00 | 10
2023-12-25 00:00:00 | 10
2023-12-26 00:00:00
Spreadsheet: 776813d1649926493-automatically-copy-data-into-summary-book2-summary
Sheet: Sheet1

 |  |  |  | J League |  |  |  |  |  |  |  |  |  |  |  |  | L League |  |  |  |  |  |  |  |  |  |  |  |  | S League |  |  |  |  |  |  |  |  |  |  |  |  | M League
 |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date
 |  |  | BBB | J 1224 | 2167.76 | 2022-02-16 00:00:00 |  |  |  |  |  |  |  |  |  | AAA | L 093 | 2255.24 | 2022-01-05 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | S 016 | 1874.23 | 2022-01-04 00:00:00 |  |  |  |  |  |  |  |  |  | CCC | M 015 | 2350.48 | 2022-03-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | S 015 | 2614.75 | 2021-12-12 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | M 014 | 1899.18 | 2021-12-18 00:00:00
Spreadsheet: e9ab689e-62e5-4fff-89e8-dd4dc8aab8a8
Sheet: Sheet1

MGNR lt. GPDB | Art der Urkunde | Firmenbezeichnung lt. GPDB | Unternehmens- Standort | Titel | Vorname | Nachname | Geschl. m/w | Berufsbezeichnung | [NAME] | Verleihungs- Datum | Anrede | Artikel
Angaben [NAME]: |  | Kontaktperson / Telefon | Art der Urkunde: | Dienststelle | Kostenstelle | [NAME] bis Datum | Bestelldatum | [NAME]. der [NAME]
 |  |  |  |  |  |  |  | 0
Hinweise: | A4GRAU (10-25 Jahre) / A4ROT (30-35 Jahre) / [NAME] (ab 40 Jahre)
MGNR lt. GPDB | Art der Urkunde | Firmenbezeichnung lt. GPDB | Unternehmens- Standort | Titel | Vorname | Nachname | Geschl. m/w | Berufsbezeichnung | [NAME] | Verleihungs- Datum | Anrede | Artikel
1234 | ART | Musterfirma GmbH & Co KG | Graz | Mag. | [NAME] | Maier-Test | w | kfm. [NAME] | 35 | am 15. [NAME] 2005 | Frau | ihren