tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 874793d1721301994-create-a-water-meter-read-log-that-can-handle-missed-meter-reads-and-weekends-updated_water_meter_logo_final
Sheet: Sheet1

Date | [NAME] | Usage | Current/Next Meter Read | Current/Previous Meter Read | Diff | Days of Read | Missed Days Count | Cumulative Usage | Actual/Estimate Meter Read | Actual/Estimate Usage
2024-07-01 00:00:00 | 421830
2024-07-02 00:00:00 | 421840 | 10 |  |  |  |  |  |  |  |  |  | 6 helper columns from D to I, with Actual/Estimate Meter Read in column J:
2024-07-03 00:00:00 | 421860 | 20
2024-07-04 00:00:00
2024-07-05 00:00:00
2024-07-06 00:00:00
2024-07-07 00:00:00
2024-07-08 00:00:00
2024-07-09 00:00:00
2024-07-10 00:00:00
2024-07-11 00:00:00
2024-07-12 00:00:00 | 421950
2024-07-13 00:00:00 | 421960 | 10
2024-07-14 00:00:00
2024-07-15 00:00:00
2024-07-16 00:00:00
2024-07-17 00:00:00
2024-07-18 00:00:00
2024-07-19 00:00:00 | 422080
2024-07-20 00:00:00 | 422088
2024-07-21 00:00:00
2024-07-22 00:00:00
2024-07-23 00:00:00
2024-07-24 00:00:00
2024-07-25 00:00:00
2024-07-26 00:00:00
2024-07-27 00:00:00
2024-07-28 00:00:00
2024-07-29 00:00:00
2024-07-30 00:00:00
2024-07-31 00:00:00
2024-08-01 00:00:00
Spreadsheet: 765841d1643635689-compare-2-columns-on-multiple-values-exdata2-aligw
Sheet: This Month

Product | Subscription key | Company | Usage | Total seats
Product1 | abc123 | Comp1 | 10 | 20
Product2 | def456 | Comp1 | 4 | 5
Product1 | ghi789 | Comp1 | 4 | 4
Product3 | jkl123 | Comp1 | 1 | 1
Product2 | mno456 | Comp1 | 19 | 19
Product1 | pqr789 | Comp1 | 1 | 1
Product2 | stu123 | Comp1 | 5 | 5
Product1 | vwx456 | comp2 | 25 | 25
Product3 | yza789 | comp3 | 5 | 5
Product2 | bcd123 | comp2 | 19 | 20
Product1 | efg456 | comp2 | 42 | 46
Product2 | hij789 | comp3 | 8 | 8
Product1 | klm123 | comp2 | 36 | 40
Product3 | nop456 | comp3 | 19 | 19
Product2 | qrs789 | comp2 | 2 | 2
Product1 | tuv123 | comp2 | 4 | 4
Product2 | wxy456 | comp3 | 2 | 2
Spreadsheet: tracy_geaccone__40350__4Q fcst - kd
Sheet: up-down

 |  |  |  |  |  |  |  | Current
 |  |  |  |  |  | 1CE |  | Forecast |  | Upside |  | Downside
Total IBIT per Plan |  |  |  |  | $ | 11 |  | 11 |  | 11 |  | 11
Profit Adjustments
 | Puerto Rico - $0 to ($23.0) |  |  |  |  | -23 |  | -28 |  | -9 |  | -28
 | EPC 63/64 - $5.7 to $.3 |  |  |  |  | -5.4 |  | -5.8 |  | 0 |  | -9.4
 | Arcos - delayed |  |  |  |  | -4 |  |  |  | -4 |  | -4
 | Turkey - $33.7 to $31.5 |  |  |  |  | -2.145 |  | -2.145 |  | -2.1 |  | -7.7
* | India LNG - $26.0 to $6.3 |  |  |  |  |  |  | -5.3 |  | -7.5
 | Poland - $5.6 to $3.4 |  |  |  |  |  |  | -2.2 |  |  |  | -1.7
 | Cuiaba - $16.6 to $15.6 |  |  |  |  | -0.5 |  | -3.3 |  | -0.5 |  | -3.3
 | Other Misc. projects |  |  |  |  | -0.3 |  |  |  | -0.3 |  | -0.3
 | Project Reserves in Plan |  |  |  |  | 20 |  |  |  | 20 |  | 20
Accro Selldown |  |  |  |  |  | 0 |  | -21.5 |  | 0 |  | -21.5
India Selldown |  |  |  |  |  | 0 |  | 0 |  | 18 |  | 0
Remaining Assets Solddown |  |  |  |  |  | 2.8 |  | 0 |  | 12.3 |  | 0
Credit Reserve |  |  |  |  |  |  |  | -8.5
Additional G&A
 | G&A not billed to BU's |  |  |  |  |  |  | -7.4 |  | -5
 | Corporate Charges |  |  |  |  | -7.8 |  |  |  |  |  | -7.8
Increased Development Expense |  |  |  |  |  |  |  | -3.5
3rd Party Interest Income |  |  |  |  |  | 2.3 |  |  |  | 2.3 |  | 2.3
Lagos Performance Test |  |  |  |  |  | 0 |  | 0 |  | 4 |  | 0
India - 4th Tank |  |  |  |  |  | 0 |  | 0 |  | 0 |  | -16
Stretch |  |  |  |  |  | 7 |  |  |  | 7
Total IBIT per Forecast
*Total profit decrease is $(7.8) offset by +$.3 of progress
Spreadsheet: 220534dd-e8ef-4483-9bbe-0c038687242e
Sheet: Data-Diri

 | BIODATA  PESERTA
 | DATA DIRI
 | Nama | :
 | NIP | :
 | [NAME] | :
 | [NAME] | :
 | NUPTK | :
 | Agama | :
 | email | :
 | Pendidikan | :
 | [NAME] | :
 | Bidang Studi | :
 | Telp / HP | :
 | INSTANSI
 | Nama | :
 | Alamat | :
 | [NAME] | :
 | [NAME] | :
 | Provinsi | :
 | KELOMPOK KERJA (KKG/MGMP)
 | [NAME] | :
 | Alamat [NAME] | :
 | [NAME] | :
 | [NAME] | :
 | Provinsi | :
Spreadsheet: 149496d1333991448-how-to-fill-formula-down-but-skip-every-nth-cell-i-e-leave-blank-cells-between-results-book1_hyperlollipop
Sheet: Sheet1

 | B2 |  | B2
 | C2 |  | C2
 | B3 |  | B3
 | [NAME] |  | [NAME]
 | B4 |  | B4
 | C4 |  | C4
 | B5 |  | B5
 | C5 |  | C5
 | B6 |  | B6
 | C6 |  | C6
 | B7 |  | B7
 | C7 |  | C7
 | B8 |  | B8
 | C8 |  | C8
 | B9 |  | B9
 | C9 |  | C9
 | B10 |  | B10
 | C10 |  | C10
 | B11 |  | B11
 | C11 |  | C11
 | B12 |  | B12
 | C12 |  | C12
 | B13 |  | B13
 | C13 |  | C13
 | B14 |  | B14
 | C14 |  | C14
 | B15 |  | B15
 | C15 |  | C15
 | B16 |  | B16
 | C16 |  | C16
 | B17 |  | B17
 | C17 |  | C17
 | B18 |  | B18
 | C18 |  | C18
 | B19 |  | B19
 | C19 |  | C19
 | [NAME] |  | [NAME]
 | C20 |  | C20
 | 0 |  | 0
Spreadsheet: 139401d1328218579-count-occurances-using-two-dropdowns-based-on-criteria-accros-multiple-sheets-test
Sheet: town1

 |  | area 1 | area 5 | area 16 | area 19
apple |  | 1 | 3 | 1 | 6 |  |  | area | FRUIT | VEHICLE | FURNITURE |  | TOWNS
pears |  | 2 | 7 | 5 | 3 |  |  | 1 | apple | motorcar | chair |  | town1
oranges |  | 4 | 9 | 8 | 2 |  |  | 2 | pear | boat | cupboard |  | town2
motorcar |  | 14 | 11 | 12 | 34 |  |  | 3 | orange | bike | desk |  | town3
boat |  | 24 | 33 | 45 | 28 |  |  | 4 | peach | bus
bike |  | 34 | 100 | 1 | 2 |  |  | 5
bus |  | 41 | 4 | 5 | 6 |  |  | 6
chair |  | 43 | 6 | 4 | 5 |  |  | 7
cupboard |  | 47 | 9 | 3 | 2
desk |  | 4 | 1 | 6 | 6
Spreadsheet: 555132d1515447516-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 6

 |  |  | Tournament 6
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 68
 |  |  |  | 75
 |  |  |  | 56
 |  |  |  | 64
 |  |  |  | 46
 |  |  |  | 27
 |  |  |  | 40
 |  |  |  | 65
 |  |  |  | 76
 |  |  |  | 44
 |  |  |  | 53
 |  |  |  | 75
 |  |  |  | 49
 |  |  |  | 37
 |  |  |  | 53
 |  |  |  | 42
 |  |  |  | 29
 |  |  |  | 47
 |  |  |  | 24
 |  |  |  | 30
 |  |  |  | 32
 |  |  |  | 59
 |  |  |  | 63
 |  |  |  | 24
 |  |  |  | 54
 |  |  |  | 48
 |  |  |  | 66
 |  |  |  | 70
 |  |  |  | 71
 |  |  |  | 63
 |  |  |  | 73
 |  |  |  | 38
 |  |  |  | 41
 |  |  |  | 67
 |  |  |  | 66
 |  |  |  | 51
 |  |  |  | 42
 |  |  |  | 55
 |  |  |  | 52
 |  |  |  | 48
 |  |  |  | 52
 |  |  |  | 57
 |  |  |  | 76
 |  |  |  | 69
 |  |  |  | 32
 |  |  |  | 76
 |  |  |  | 54
 |  |  |  | 75
 |  |  |  | 78
 |  |  |  | 48
 |  | x | x | x
Spreadsheet: 750356d1633409545-cell-contains-a-date-then-returns-a-certain-text-permit-register-example-5-10-2021
Sheet: To Approve

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP
 | Address 4 | Description 4 | Client 4 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE
ABC-21022 | Address 22 | Description 22 | Client 22 | 001/001/022 | APPROVE | APPROVE
Spreadsheet: 00bcf049-8124-41bb-84ee-6b6f257a6c04
Sheet: Sheet1

Unnamed: 0 | Social Enterprise Summer Fellowship Program  Checklist | Unnamed: 2
 | Students must complete all items on this checklist in order to be considered for a fellowship. All items can be scanned in and emailed. Please ensure forms are signed (where relevant).
 | Items:
 |  | Student Information Form (completed entirely including your signature)
 |  | Resume
 |  | Essay, not to exceed three pages
 |  | Paragraph in the third person about the project
 |  | Employer Information Form (completely entirely including supervisor's signature)
 |  | The offer letter (or detailed email from the employer)
 |  | Proof of organization's 501(c)3 tax-exempt status, L3C or other relevant status; For for-profit ventures, an explanation of why the organization is eligible *
 |  | Employer information not to exceed ten pages
 |  | Tax Certification Form
 |  | Direct deposit form (deliver to Uris 203) **
 |  | [NAME] (deliver to Uris 203) **
 |  | W-8 (signed), copy of passport and copy of U.S. Visa (International students only)
 |  | W-9 (non-International students only) - must deliver signed original to Uris 203
 |  | Your headshot picture taken - please come to Uris 203
 | * Not required for nonprofit organizations that students have interned with in the past. These organizations can be found online (by year) at:
 | www.gsb.columbia.edu/socialenterprise/careers/internships/mbavalue
 | For-profit social ventures require proof of a clearly defined social or environmental purpose incorporated into the core reason for operation – evident in both mission and practice. See guidelines online for more information.
 | ** Forms need to be sent by SEP with other information; please do not send to the address listed
 | on the form.
Spreadsheet: 147004d1332461609-massive-if-headache-data-production-schedule-evening-postable-copy
Sheet: Top Sheet

1900-01-01 00:00:00
Manager
Manager
NAV/Sp NAV
NAV
Repeats
Regional Lead
Regional Associates
Data Production Staff
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  | (blank) | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 |  |  | Grand Total | 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 | 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
Highlighted Networks Contain COVERAGE ALERTS                                                                                                          DMS 2
Spreadsheet: 137725d1327335981-excel-2007-only-one-column-has-multiple-rows-hide-these-rows-but-easily-accessed-by-click-sample-sheet
Sheet: Sheet1

Client A | Blue | Hot | 8 | 8
 |  |  |  | 10
 |  |  |  | 7
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 10
 |  |  |  | 5
 |  |  |  | 7
 |  |  |  | 4
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 5
 |  |  |  | 5
Client B | Green | Cold | 7 | 7
 |  |  |  | 6
 |  |  |  | 4
 |  |  |  | 10
 |  |  |  | 6
 |  |  |  | 10
 |  |  |  | 9
 |  |  |  | 2
 |  |  |  | 8
 |  |  |  | 3
 |  |  |  | 7
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 2
 |  |  |  | 5
 |  |  |  | 10
Client C | Yellow | Hot | 2 | 2
 |  |  |  | 8
 |  |  |  | 7
 |  |  |  | 4
 |  |  |  | 2
 |  |  |  | 6
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 1
 |  |  |  | 10
 |  |  |  | 8
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 5
Client D | Red | Hot | 3 | 3
 |  |  |  | 7
 |  |  |  | 9
 |  |  |  | 2
 |  |  |  | 7
 |  |  |  | 5
 |  |  |  | 10
 |  |  |  | 9
 |  |  |  | 6
 |  |  |  | 2
 |  |  |  | 7
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 1
 |  |  |  | 6
 |  |  |  | 7
Spreadsheet: 136929d1326893244-integrating-a-shift-schedule-and-time-sheets-if-i-had-hair-i-would-pull-it-out-sched-time-sheet-integration
Sheet: Site 1

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 808025d1670246843-dropdown-list-and-new-rows-drop-down-list-example
Sheet: SHEET 2 FORUMLA

2. Superstructure | 4. Fittings, Furnishings and Equipment | 5. Services | 8. External Works |  |  | Filtered list 1 (COLUMN B) | Filtered List 2 (COLOUMN D)
2.3. | 4.1. | 5.1. | 8.1.
2.4. |  | 5.2. | 8.2.
2.5. |  | 5.3. | 8.3.
2.6. |  | 5.4. | 8.4.
2.8. |  | 5.5. | 8.5.
 |  | 5.6. | 8.6.
 |  | 5.7. | 8.7.
 |  | 5.8.
 |  | 5.9.
 |  | 5.10.
 |  | 5.11.
 |  | 5.12.
 |  | 5.13.
 |  | 5.14.
[NAME] | Stairs and [NAME] | External Walls | Windows And External Doors | Internal Doors | Fittings, Furnishings & Equipment | Sanitary Installations | Lifts And Conveyor Installations | Fire And Lightning Protection | Communications, Security & Control Systems | Specialist Installations | Builders Work In Connection With Services | Services Equipment | Disposal Installations | Water Installations | Heat Source | Space Heating & Air Conditioning | Ventilation | Electrical Installations | Fuel Installations | Site Preparation Works | Roads, Paths, Paving's & Surfacing's | [NAME], Planting & Irrigation Systems | Fencing, Railings & Walls | External Fixtures | External Drainage | External Services
DRG | ACC | BMU | FAC | FFE | FFE | SAN | LFT | FPE | BMS | SEL | BWH | BWH | DRG | CHW | HTG | ACE | AHV | ELD | GAS | EXT | EXT | IRI | EXT | EXT | DRG | EXT
WIN |  |  |  |  |  |  |  | LPE | COM | SME |  |  | RDP | DHW |  | SPH | SMV | LTG | OIL
 |  |  |  |  |  |  |  |  | SEC | SPI |  |  |  | LTHW |  | CHC |  | ELT
 |  |  |  |  |  |  |  |  |  | SRE |  |  |  | CWS |  |  |  | ELI
 |  |  |  |  |  |  |  |  |  | FFE |  |  |  | STE
Spreadsheet: 47836d1246999433-calculating-miles-distance-and-mph-dianes-exercise-tracking
Sheet: Sheet1

[NAME]'s Exercise Tracking
Date | Laps | Time | [NAME] | MPH
2009-07-01 00:00:00 | 9 | 1
2009-07-02 00:00:00 | 8 | 1
2009-07-03 00:00:00 | 9 | 1.06
2009-07-05 00:00:00 | 9 | 1.04
2009-07-06 00:00:00 | 9 | 1.05
2009-07-07 00:00:00 | 9 | 1.07
Spreadsheet: 327665d1403638149-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans2
Sheet: Sheet8

SERIES | ACCIDENT_ID | SEVERITY | KILLED | INJURED | DUPLICATE | PATTERN | PATTERN2 | UNIQUE | Pattern of Values | [NAME] ASSIGNED | COUNT
0 | 111 | PDO | 0 | 0 | DEL |  |  |  | 000000 | $A$1 | 2
1 | 111 | PDO | 0 | 0 | DEL |  |  |  | 101010 | $A$2 | 2
2 | 111 | PDO | 0 | 0 | DEL | a | $A$1 | 000000 | 111001 | $A$3 | 2
3 |  |  |  |  |  |  |  |  | 010101 | $A$4 | 1
4 |  | K | 1 | 0 | 0 |  |  |  | 100101 | $A$5 | 1
5 | 111 | K | 1 | 0 | 0 |  |  |  | 212121 | $A$6 | 1
6 | 111 | K | 1 | 0 | 0 | b | $A$2 | 101010 | 130102 | $A$7 | 1
7 |  |  |  |  |  |  |  |  | 00100000 | $A$8 | 1
8 | 0 | K | 1 | 1 | 0 |  |  |  | 1414 | $A$9 | 1
9 | 111 | K | 1 | 0 | 0 |  |  |  | 01100100 | $A$10 | 1
10 | 111 | I | 0 | 1 | DEL | c | $A$3 | 111001 |  | $A$11 | 0
11 |  |  |  |  |  |  |  |  |  | $A$12 | 0
12 | 0 | PDO | 0 | 0 | DEL |  |  |  |  | $A$13 | 0
13 | 111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$14 | 0
14 | 111 | PDO | 0 | 0 | DEL | a | $A$1 | 000000 |  | $A$15 | 0
15 |  |  |  |  |  |  |  |  |  | $A$16 | 0
16 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$17 | 0
17 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$18 | 0
18 | 111 | K | 1 | 0 | 0 | b | $A$2 | 101010 |  | $A$19 | 0
19 |  |  |  |  |  |  |  |  |  | $A$20
20 | 0 | I | 0 | 1 | 0 |  |  |  |  | $A$21
21 | 111 | I | 0 | 1 | 0 |  |  |  |  | $A$22
22 | 111 | I | 0 | 1 | 0 | d | $A$4 | 010101 |  | $A$23
23 |  |  |  |  |  |  |  |  |  | $A$24 | UDF is used.
24 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$25
25 | 111 | I | 0 | 1 | DEL |  |  |  |  | $A$26
26 | 111 | I | 0 | 1 | DEL | e | $A$5 | 100101 |  | $A$27
27 |  |  |  |  |  |  |  |  |  | $A$28
28 | 0 | K | 2 | 1 | 0 |  |  |  |  | $A$29
29 | 111 | K | 2 | 1 | 0 |  |  |  |  | $A$30
30 | 111 | K | 2 | 1 | 0 | f | $A$6 | 212121 |  | $A$31
31 |  |  |  |  |  |  |  |  |  | $A$32
32 | 0 | K | 1 | 3 | 0 |  |  |  |  | $A$33
33 | 111 | I | 0 | 1 | DEL |  |  |  |  | $A$34
34 | 111 | I | 0 | 2 | DEL | g | $A$7 | 130102 |  | $A$35
35 |  |  |  |  |  |  |  |  |  | $A$36
36 | 0 | K | 1 | 1 | 0 |  |  |  |  | $A$37
37 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$38
38 | 111 | I | 0 | 1 | DEL | c | $A$3 | 111001 |  | $A$39
39 |  |  |  |  |  |  |  |  |  | $A$40
40 | 1111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$41
41 | 1111 | K | 1 | 0 | 0 |  |  |  |  | $A$42
42 | 1111 | PDO | 0 | 0 | DEL | h |  |  |  | $A$43
42 | 1111 | PDO | 0 | 0 | DEL |  | $A$8 | 00100000 |  | $A$44
42 |  |  |  |  |  |  |  |  |  | $A$45
42 | 1112 | K | 1 | 4 | 0 | i |  |  |  | $A$46
42 | 1112 | K | 1 | 4 | 0 |  | $A$9 | 1414 |  | $A$47
42 |  |  |  |  |  |  |  |  |  | $A$48
42 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$49
42 | 2222 | K | 1 | 0 | 0 |  |  |  |  | $A$50
42 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$51
42 | 2222 | PDO | 0 | 0 | DEL |  | $A$10 | 01100100 |  | $A$52
42
42 |  |  | 0 | 0
 |  |  |  |  |  |  |  | 000014
Spreadsheet: 886194d1736222253-how-to-have-a-cell-populate-number-from-another-cell-only-when-formula-executed-in-row-test-sheet2
Sheet: Sheet1

 |  |  |  |  |  | Price Paid |  | Date |  | Gallons |  | Price |  | Regulatory Charge |  | Del. Charge |  | Total Pd. | Total Pd
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Fuel Recov. Fee |  |  | with Fees:
Home
 |  |  |  |  |  | 2.499 | Pre-Season | 2024-08-13 00:00:00 |  | 44.4
 |  |  |  |  |  | 2.999 |  | 2024-10-22 00:00:00 |  | 56.2 |  |  |  | 13.62 |  | 7.96
 |  |  |  |  |  |  |  | 2024-11-26 00:00:00 |  | 22.9 |  |  |  | 13.62 |  | 7.96
Price per gallon | 2.999 |  |  |  |  |  |  | 2024-12-07 00:00:00 |  | 14.5 |  |  |  | 13.62 |  | 7.96
 |  |  |  |  |  |  |  | 2024-12-18 00:00:00 |  | 13.6 |  |  |  | 13.62 |  | 7.96
[NAME] | 13.62 |  |  |  |  |  |  | 2025-01-06 00:00:00 |  | 26 |  |  |  |  |  | 7.96
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.62
Recovery Fee | 7.96
Total:
 |  |  |  |  |  |  |  |  |  |  |  | All Fees: |  | Total Reg. + Del. |  |  |  |  | Total Pd
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total [NAME]. |  |  |  |  | with fees:
Spreadsheet: 864350d1711556277-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question-1-
Sheet: WORKING Version

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 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
Users | 25 | 28 | 26 | 21 | 29 | 34 | 33 | 35 | 31 | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 | 608 | 612 | 574 | 773 | 809 | 768 | 811 | 809 | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024
Spreadsheet: 734620d1622288937-how-to-sort-using-formula-test
Sheet: Sheet1

Name | Today | Yesterday |  |  | Name | Today |  | Name | Yesterday
Banglamotor | 15 | 27
Mohakhali | 26 | 101
Barisal | 26 | 101
[NAME] | 20 | 58
Khulna | 31 | 0
[NAME] | 44 | 94
Muradpur | 23 | 96
Comilla | 33 | 88
Rangpur | 27 | 28
[NAME] | 24 | 10
[NAME] | 13 | 25
Jessore | 16 | 28
Mymensingh | 17 | 30
Sylhet | 27 | 22
Faridpur | 13 | 7
Tangail | 7 | 43
Agrabad | 24 | 21
Spreadsheet: 40552d1238897697-if-vlookup-or-database-problem-mcl_test
Sheet: 01

SERIAL # | ACCOUNT # | DATE CHECKED OUT | DATE INSTALLED | DATE RETURNED
12345 | 765432 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12346 | 765433 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12347 | 765434 | 2009-04-01 00:00:00 |  | 2009-04-02 00:00:00
12348 | 765435 | 2009-04-01 00:00:00 |  | 2009-04-02 00:00:00
12349 | 765436 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12350 | 765437 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12351 | 765438 | 2009-04-02 00:00:00 | 2009-04-03 00:00:00
12352 | 765439 | 2009-04-03 00:00:00 |  | 2009-04-04 00:00:00
12353 | 765440 | 2009-04-03 00:00:00 | 2009-04-03 00:00:00
12354 | 765441 | 2009-04-04 00:00:00 | 2009-04-04 00:00:00
12355 | 765442 | 2009-04-04 00:00:00 | 2009-04-04 00:00:00
Spreadsheet: 90767d1290519395-sorting-dates-that-are-referenced-from-other-sheets-forum-reference-example
Sheet: Provident FM

Customer | PROVIDENT FINANCIAL MANAGEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pages
Bid Number | 2710D503
Version | 1
Status | EMEA approved
Validation date | 12/04/2010
Start date | 01/04/2010
End date | 01/04/2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage Increase: | 0
[NAME]
Description | Quantity | Bid price | Part number | 2009 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Total Units | Total Revenue | Bid £ | BDP | % Discount | New Price? | New Discount? | New Price £ Estimate | Current £ Year Estimate
Spreadsheet: 167274d1341940376-distribution-using-parabolic-formula-book1
Sheet: Sheet2

 | Index | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
Spreadsheet: 131083d1322733007-formulas-referencing-quarter-and-yearly-achieved-targets-sales_rev_-_samplev3
Sheet: Sales

 | Client | Invoice Date | Revenue | Job Function | Position | Consultant | Days to Closure | Remarks
 | AB1 | 2011-01-24 00:00:00 | 3800 | Accounting  - Audit |  | Eunice
 | AB1 | 2011-01-14 00:00:00 | 4328 | Accounting  - Accounts / Finance Manager |  | Sydney
 | AB3 | 2011-01-17 00:00:00 | 2344 | Accounting  - Credit Control |  | CC
 | AB4 | 2011-02-21 00:00:00 | 934 |  |  | CC
 | AB1 | 2011-02-09 00:00:00 | 8534 |  |  | Sydney
 | AB6 | 2011-02-21 00:00:00 | 8323 |  |  | CC
 | AB3 | 2011-03-02 00:00:00 | 12312 |  |  | CC
 | AB8 | 2011-04-01 00:00:00 | 345 |  |  | JJ
 | AB9 | 2011-04-04 00:00:00 | 4353 |  |  | JJ
 | AB3 | 2011-04-15 00:00:00 | 9034 |  |  | CC
 | AB1 | 2011-04-25 00:00:00 | 943 |  |  | Sydney
 | AB12 | 2011-05-06 00:00:00 | 1231 |  |  | Sydney
 | AB13 | 2011-06-01 00:00:00 | 8233 |  |  | Ernest
 | AB3 | 2011-06-14 00:00:00 | 4221 |  |  | Sydney
 | AB3 | 2011-09-26 00:00:00 | 2341 |  |  | JJ
 | AB16 | 2011-10-11 00:00:00 | 2132 |  |  | SS
 | AB17 | 2011-10-24 00:00:00 | 2111 |  |  | CC
 | AB3 | 2011-10-31 00:00:00 | 4332 |  |  | JJ
 | AB19 | 2011-11-03 00:00:00 | 3432 |  |  | CC
 | AB3 | 2011-11-21 00:00:00 | 4532 |  |  | SS
 | AB3 | 2011-11-28 00:00:00 | 4222 |  |  | SS
 | AB22 | 2011-12-01 00:00:00 | 2133 |  |  | CC
 | [NAME] | 2011-12-05 00:00:00 | 13211 |  |  | CC
 | [NAME] | 2012-01-05 00:00:00 | 4324 |  |  | SS
Spreadsheet: 70166d1270861083-pivot-chart-dividing-a-column-with-4values-stacked-into-2-columns-with-2values-stack-copy-of-test
Sheet: toto

Month | Amount | Amount2 | Amount3 | Amount4 |  | Month |  | Amount | Amount2 | Amount3 | Amount4
Jan | 7 | 1 | 6 | 8 |  |  |  | 7 | 1
Feb | 5 | 4 | 5 | 4 |  | Jan |  |  |  | 6 | 8
Mar | 8 | 2 | 7 | 8
 |  |  |  |  |  |  |  | 5 | 4
 |  |  |  |  |  | Feb |  |  |  | 5 | 4
 |  |  |  |  |  |  |  | 8 | 2
 | Values |  |  |  |  | Mar |  |  |  | 7 | 8
Row Labels | Sum of Amount | Sum of Amount2 | Sum of Amount3 | Sum of Amount4
Feb | 5 | 4 | 5 | 4
Jan | 7 | 1 | 6 | 8
Mar | 8 | 2 | 7 | 8
Grand Total | 20 | 7 | 18 | 20
Spreadsheet: 727922d1618217326-moving-letters-from-the-middle-of-digits-example
Sheet: Example data

7.15 | 7.15 | 22.45 | 23.3 | 23.4 | 23.45
7.18 | 7.18 | 22.48 | 23.33 | 23.43 | 23.48
. . | . . | . . | . . | . . | . .
7.24 | 7.24 | 22.54 | 23.39 | 23.49 | 23.54
7.4 | 7.4 | 23.1 | 23.56 | . . | 0.1
. . . . | . . . . | . . . . | . . . . | . . . . | . . . .
7.5 | 7.5 | 23.2 | 0.06 | 0.13 | 0.2
. . . . | . . . . | . . . . | 0.12 | . . . . | . . . .
7.58 | 7.58 | 23.28 | 0.16 | 0.21 | 0.28
8 | 8 | 23.29 | 0.17 | 0.22 | 0.29
8.06 | 8.06 | 23.35 | 0.24 | . . | 00s35
8.09 | 8.09 | 23.39 | 0.28 | . . . . | 0.4
8.1 | 8.1 | 23.4 | . . | . . | 0.41
8.15 | 8.15 | 23s45 | . . . . | . . . . | 00s45
8.2 | 8.2 | 23s49 | . . | . . | 00s50
8.26 | 8.26 | 23s56 | . . . . | . . . . | 00s56
8.3 | 8.3 | 23s59 | . . | . . | 01s01
8.34 | 8.34 | 00s04 | . . . . | . . . . | 01s05
8.42 | 8.42 | 00s12 | . . | . . | 01s13
8.46 | 8.46 | 00s16 | . . . . | . . . . | 01x17
8.52 | 8.52 | 00s21 | . . | . . | 01x22